agenda.lib.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2008-2014 Laurent Destailleur  <eldy@users.sourceforge.net>
 * Copyright (C) 2005-2009 Regis Houssin        <regis.houssin@inodbox.com>
 * Copyright (C) 2011    Juanjo Menent        <jmenent@2byte.es>
 * Copyright (C) 2022-2024  Frédéric France       <frederic.france@free.fr>
 * Copyright (C) 2024   MDW           <mdeweerd@users.noreply.github.com>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 * or see https://www.gnu.org/
 */
 
function print_actions_filter(
  $form,
  $canedit,
  $status,
  $year,
  $month,
  $day,
  $showbirthday,
  $filtera,
  $filtert,
  $filtered,
  $pid,
  $socid,
  $action,
  $showextcals = array(),
  $actioncode = '',
  $usergroupid = 0,
  $excludetype = '',
  $resourceid = 0,
  $search_categ_cus = 0
) {
  global $user, $langs, $db, $hookmanager;
  global $massaction;
 
  $langs->load("companies");
 
  include_once DOL_DOCUMENT_ROOT.'/core/class/html.formactions.class.php';
  $formactions = new FormActions($db);
 
  // Filters
  //print '<form name="listactionsfilter" class="listactionsfilter" action="' . $_SERVER["PHP_SELF"] . '" method="get">';
  print '<input type="hidden" name="token" value="'.newToken().'">';
  print '<input type="hidden" name="year" value="'.((int) $year).'">';
  print '<input type="hidden" name="month" value="'.((int) $month).'">';
  print '<input type="hidden" name="day" value="'.((int) $day).'">';
  if ($massaction != 'predelete' && $massaction != 'preaffecttag') {    // When $massaction == 'predelete', action may be already output to 'delete' by the mass action system.
    print '<input type="hidden" name="action" value="'.$action.'">';
  }
  print '<input type="hidden" name="search_showbirthday" value="'.((int) $showbirthday).'">';
 
  print '<div class="divsearchfield">';
  // Type
  $multiselect = 0;
  if (getDolGlobalString('MAIN_ENABLE_MULTISELECT_TYPE')) {     // We use an option here because it adds bugs when used on agenda page "peruser" and "list"
    $multiselect = (getDolGlobalString('AGENDA_USE_EVENT_TYPE'));
  }
  print img_picto($langs->trans("ActionType"), 'square', 'class="pictofixedwidth inline-block" style="color: #ddd;"');
  print $formactions->select_type_actions($actioncode, "search_actioncode", $excludetype, (getDolGlobalString('AGENDA_USE_EVENT_TYPE') ? -1 : 1), 0, $multiselect, 0, 'minwidth150 maxwidth200 widthcentpercentminusx', 1);
  print '</div>';
 
  if ($canedit) {
    // Assigned to user
    print '<div class="divsearchfield">';
    print img_picto($langs->trans("ActionsToDoBy"), 'user', 'class="pictofixedwidth inline-block"');
    print $form->select_dolusers($filtert, 'search_filtert', 1, '', !$canedit, '', '', 0, 0, 0, '', 0, '', 'minwidth100 maxwidth250 widthcentpercentminusx');
    print '</div>';
 
    // Assigned to user group
    print '<div class="divsearchfield">';
    print img_picto($langs->trans("ToUserOfGroup"), 'object_group', 'class="pictofixedwidth inline-block"');
    print $form->select_dolgroups($usergroupid, 'usergroup', 1, '', !$canedit, '', '', '0', false, 'minwidth100 maxwidth250 widthcentpercentminusx');
    print '</div>';
 
    if (isModEnabled('resource')) {
      include_once DOL_DOCUMENT_ROOT.'/resource/class/html.formresource.class.php';
      $formresource = new FormResource($db);
 
      // Resource
      print '<div class="divsearchfield">';
      print img_picto($langs->trans("Resource"), 'object_resource', 'class="pictofixedwidth inline-block"');
      print $formresource->select_resource_list($resourceid, "search_resourceid", [], 1, 0, 0, [], [], 2, 0, 'minwidth100 maxwidth250 widthcentpercentminusx');
      print '</div>';
    }
  }
 
  if (isModEnabled('societe') && $user->hasRight('societe', 'lire')) {
    print '<div class="divsearchfield">';
    print img_picto($langs->trans("ThirdParty"), 'company', 'class="pictofixedwidth inline-block"');
    print $form->select_company($socid, 'search_socid', '', '&nbsp;', 0, 0, null, 0, 'minwidth100 maxwidth250 widthcentpercentminusx');
    print '</div>';
  }
 
  if (isModEnabled('project') && $user->hasRight('projet', 'lire')) {
    require_once DOL_DOCUMENT_ROOT.'/core/class/html.formprojet.class.php';
    $formproject = new FormProjets($db);
 
    print '<div class="divsearchfield">';
    print img_picto($langs->trans("Project"), 'project', 'class="pictofixedwidth inline-block"');
    print $formproject->select_projects($socid ? $socid : -1, $pid, 'search_projectid', 0, 0, 1, 0, 0, 0, 0, '', 1, 0, 'minwidth100 maxwidth250 widthcentpercentminusx');
    print '</div>';
  }
 
  if (isModEnabled('category') && $user->hasRight('categorie', 'lire')) {
    require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
    require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
    $formother = new FormOther($db);
    $langs->load('categories');
 
    print '<div class="divsearchfield">';
    print img_picto($langs->trans('Categories'), 'category', 'class="pictofixedwidth"');
    print $formother->select_categories('actioncomm', $search_categ_cus, 'search_categ_cus', 1, $langs->trans('ActionCommCategoriesArea'), 'minwidth100 maxwidth250 widthcentpercentminusx');
    print '</div>';
  }
 
  if ($canedit && !preg_match('/list/', $_SERVER["PHP_SELF"])) {
    // Status
    print '<div class="divsearchfield">';
    print img_picto($langs->trans("Status"), 'status', 'class="pictofixedwidth inline-block"');
    $formactions->form_select_status_action('formaction', $status, 1, 'search_status', 1, 2, 'minwidth100');
    print '</div>';
  }
 
  // Hooks
  $parameters = array('canedit' => $canedit, 'pid' => $pid, 'socid' => $socid);
  $object = null;
  $reshook = $hookmanager->executeHooks('searchAgendaFrom', $parameters, $object, $action); // Note that $action and $object may have been
 
  print '<div class="clearboth"></div>';
}
 
 
function show_array_actions_to_do($max = 5)
{
  global $langs, $conf, $user, $db, $socid;
 
  $now = dol_now();
 
  include_once DOL_DOCUMENT_ROOT.'/comm/action/class/actioncomm.class.php';
  include_once DOL_DOCUMENT_ROOT.'/societe/class/client.class.php';
 
  $sql = "SELECT a.id, a.label, a.datep as dp, a.datep2 as dp2, a.fk_user_author, a.percent";
  $sql .= ", c.code, c.libelle as type_label";
  $sql .= ", s.rowid as socid, s.nom as name, s.name_alias";
  $sql .= ", s.code_client, s.code_compta, s.client";
  $sql .= ", s.logo, s.email, s.entity";
  $sql .= " FROM ".MAIN_DB_PREFIX."actioncomm as a LEFT JOIN ";
  $sql .= " ".MAIN_DB_PREFIX."c_actioncomm as c ON c.id = a.fk_action";
  $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s ON a.fk_soc = s.rowid";
  if (!$user->hasRight('societe', 'client', 'voir')) {
    $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
  }
  $sql .= " WHERE a.entity IN (".getEntity('agenda').")";
  $sql .= " AND ((a.percent >= 0 AND a.percent < 100) OR (a.percent = -1 AND a.datep2 > '".$db->idate($now)."'))";
  if (!$user->hasRight('societe', 'client', 'voir')) {
    $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
  }
  if ($socid) {
    $sql .= " AND s.rowid = ".((int) $socid);
  }
  $sql .= " ORDER BY a.datep DESC, a.id DESC";
  $sql .= $db->plimit($max, 0);
 
  $resql = $db->query($sql);
  if ($resql) {
    $num = $db->num_rows($resql);
 
    print '<div class="div-table-responsive-no-min">';
    print '<table class="noborder centpercent">';
    print '<tr class="liste_titre"><th colspan="2">'.$langs->trans("LastActionsToDo", $max).'</th>';
    print '<th colspan="2" class="right"><a class="commonlink" href="'.DOL_URL_ROOT.'/comm/action/list.php?mode=show_list&status=todo">'.$langs->trans("FullList").'</a></th>';
    print '</tr>';
 
    $i = 0;
 
    $staticaction = new ActionComm($db);
    $customerstatic = new Client($db);
 
    while ($i < $num) {
      $obj = $db->fetch_object($resql);
 
 
      print '<tr class="oddeven">';
 
      $staticaction->type_code = $obj->code;
      $staticaction->label = ($obj->label ? $obj->label : $obj->type_label);
      $staticaction->id = $obj->id;
      print '<td>'.$staticaction->getNomUrl(1, 34).'</td>';
 
      // print '<td>'.dol_trunc($obj->label,22).'</td>';
 
      print '<td>';
      if ($obj->socid > 0) {
        $customerstatic->id = $obj->socid;
        $customerstatic->name = $obj->name;
        //$customerstatic->name_alias = $obj->name_alias;
        $customerstatic->code_client = $obj->code_client;
        $customerstatic->code_compta = $obj->code_compta;
        $customerstatic->code_compta_client = $obj->code_compta;
        $customerstatic->client = $obj->client;
        $customerstatic->logo = $obj->logo;
        $customerstatic->email = $obj->email;
        $customerstatic->entity = $obj->entity;
        print $customerstatic->getNomUrl(1, '', 40);
      }
      print '</td>';
 
      $datep = $db->jdate($obj->dp);
      $datep2 = $db->jdate($obj->dp2);
 
      // Date
      print '<td width="100" class="right tddate">'.dol_print_date($datep, 'day').'&nbsp;';
      $late = 0;
      if ($obj->percent == 0 && $datep && $datep < time()) {
        $late = 1;
      }
      if ($obj->percent == 0 && !$datep && $datep2 && $datep2 < time()) {
        $late = 1;
      }
      if ($obj->percent > 0 && $obj->percent < 100 && $datep2 && $datep2 < time()) {
        $late = 1;
      }
      if ($obj->percent > 0 && $obj->percent < 100 && !$datep2 && $datep && $datep < time()) {
        $late = 1;
      }
      if ($late) {
        print img_warning($langs->trans("Late"));
      }
      print "</td>";
 
      // Statut
      print '<td class="right" width="14">'.$staticaction->LibStatut($obj->percent, 3)."</td>\n";
 
      print "</tr>\n";
 
      $i++;
    }
    print "</table></div><br>";
 
    $db->free($resql);
  } else {
    dol_print_error($db);
  }
}
 
 
function show_array_last_actions_done($max = 5)
{
  global $langs, $conf, $user, $db, $socid;
 
  $now = dol_now();
 
  $sql = "SELECT a.id, a.percent, a.datep as da, a.datep2 as da2, a.fk_user_author, a.label";
  $sql .= ", c.code, c.libelle";
  $sql .= ", s.rowid as socid, s.nom as name, s.name_alias";
  $sql .= ", s.code_client, s.code_compta, s.client";
  $sql .= ", s.logo, s.email, s.entity";
  $sql .= " FROM ".MAIN_DB_PREFIX."actioncomm as a LEFT JOIN ";
  $sql .= " ".MAIN_DB_PREFIX."c_actioncomm as c ON c.id = a.fk_action ";
  $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s ON a.fk_soc = s.rowid";
  if (!$user->hasRight('societe', 'client', 'voir')) {
    $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
  }
  $sql .= " WHERE a.entity IN (".getEntity('agenda').")";
  $sql .= " AND (a.percent >= 100 OR (a.percent = -1 AND a.datep2 <= '".$db->idate($now)."'))";
  if (!$user->hasRight('societe', 'client', 'voir')) {
    $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
  }
  if ($socid) {
    $sql .= " AND s.rowid = ".((int) $socid);
  }
  $sql .= " ORDER BY a.datep2 DESC";
  $sql .= $db->plimit($max, 0);
 
  $resql = $db->query($sql);
  if ($resql) {
    $num = $db->num_rows($resql);
 
    print '<div class="div-table-responsive-no-min">';
    print '<table class="noborder centpercent">';
    print '<tr class="liste_titre"><th colspan="2">'.$langs->trans("LastDoneTasks", $max).'</th>';
    print '<th colspan="2" class="right"><a class="commonlink" href="'.DOL_URL_ROOT.'/comm/action/list.php?mode=show_list&status=done">'.$langs->trans("FullList").'</a></th>';
    print '</tr>';
 
    $i = 0;
 
    $staticaction = new ActionComm($db);
    $customerstatic = new Societe($db);
 
    while ($i < $num) {
      $obj = $db->fetch_object($resql);
 
 
      print '<tr class="oddeven">';
 
      $staticaction->type_code = $obj->code;
      $staticaction->label = $obj->label;
      $staticaction->id = $obj->id;
      print '<td>'.$staticaction->getNomUrl(1, 34).'</td>';
 
      //print '<td>'.dol_trunc($obj->label,24).'</td>';
 
      print '<td>';
      if ($obj->socid > 0) {
        $customerstatic->id = $obj->socid;
        $customerstatic->name = $obj->name;
        //$customerstatic->name_alias = $obj->name_alias;
        $customerstatic->code_client = $obj->code_client;
        $customerstatic->code_compta = $obj->code_compta;
        $customerstatic->code_compta_client = $obj->code_compta;
        $customerstatic->client = $obj->client;
        $customerstatic->logo = $obj->logo;
        $customerstatic->email = $obj->email;
        $customerstatic->entity = $obj->entity;
        print $customerstatic->getNomUrl(1, '', 30);
      }
      print '</td>';
 
      // Date
      print '<td width="100" class="right tddate">'.dol_print_date($db->jdate($obj->da2), 'day');
      print "</td>";
 
      // Status
      print '<td class="right" width="14">'.$staticaction->LibStatut($obj->percent, 3)."</td>\n";
 
      print "</tr>\n";
      $i++;
    }
    // TODO Ajouter rappel pour "il y a des contrats a mettre en service"
    // TODO Ajouter rappel pour "il y a des contrats qui arrivent a expiration"
    print "</table></div><br>";
 
    $db->free($resql);
  } else {
    dol_print_error($db);
  }
}
 
 
function agenda_prepare_head()
{
  global $langs, $conf, $user, $db;
 
  $extrafields = new ExtraFields($db);
  $extrafields->fetch_name_optionals_label('actioncomm');
 
  $h = 0;
  $head = array();
 
  $head[$h][0] = DOL_URL_ROOT."/admin/agenda_other.php";
  $head[$h][1] = $langs->trans("Miscellaneous");
  $head[$h][2] = 'other';
  $h++;
 
  $head[$h][0] = DOL_URL_ROOT."/admin/agenda.php";
  $head[$h][1] = $langs->trans("AutoActions");
  $head[$h][2] = 'autoactions';
  $h++;
 
  $head[$h][0] = DOL_URL_ROOT."/admin/agenda_reminder.php";
  $head[$h][1] = $langs->trans("Reminders");
  $head[$h][2] = 'reminders';
  $h++;
 
  $head[$h][0] = DOL_URL_ROOT."/admin/agenda_xcal.php";
  $head[$h][1] = $langs->trans("ExportCal");
  $head[$h][2] = 'xcal';
  $h++;
 
  $head[$h][0] = DOL_URL_ROOT."/admin/agenda_extsites.php";
  $head[$h][1] = $langs->trans("ExtSites");
  $head[$h][2] = 'extsites';
  $h++;
 
  complete_head_from_modules($conf, $langs, null, $head, $h, 'agenda_admin');
 
  $head[$h][0] = DOL_URL_ROOT."/admin/agenda_extrafields.php";
  $head[$h][1] = $langs->trans("ExtraFields");
  $nbExtrafields = $extrafields->attributes['actioncomm']['count'];
  if ($nbExtrafields > 0) {
    $head[$h][1] .= '<span class="badge marginleftonlyshort">'.$nbExtrafields.'</span>';
  }
  $head[$h][2] = 'attributes';
  $h++;
 
  complete_head_from_modules($conf, $langs, null, $head, $h, 'agenda_admin', 'remove');
 
 
  return $head;
}
 
function actions_prepare_head($object)
{
  global $db, $langs, $conf, $user;
 
  $h = 0;
  $head = array();
 
  $head[$h][0] = DOL_URL_ROOT.'/comm/action/card.php?id='.$object->id;
  $head[$h][1] = $langs->trans("CardAction");
  $head[$h][2] = 'card';
  $h++;
 
  // Tab to link resources
  if (isModEnabled('resource')) {
    include_once DOL_DOCUMENT_ROOT.'/resource/class/dolresource.class.php';
    $resource = new Dolresource($db);
 
    $head[$h][0] = DOL_URL_ROOT.'/resource/element_resource.php?element=action&element_id='.$object->id;
    $listofresourcelinked = $resource->getElementResources($object->element, $object->id);
    $nbResources = (is_array($listofresourcelinked) ? count($listofresourcelinked) : 0);
    $head[$h][1] = $langs->trans("Resources");
    if ($nbResources > 0) {
      $head[$h][1] .= (!getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER') ? '<span class="badge marginleftonlyshort">'.($nbResources).'</span>' : '');
    }
    $head[$h][2] = 'resources';
    $h++;
  }
 
  // Attached files
  require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
  require_once DOL_DOCUMENT_ROOT.'/core/class/link.class.php';
  $upload_dir = $conf->agenda->dir_output."/".$object->id;
  $nbFiles = count(dol_dir_list($upload_dir, 'files', 0, '', '(\.meta|_preview.*\.png)$'));
  $nbLinks = Link::count($db, $object->element, $object->id);
  $head[$h][0] = DOL_URL_ROOT.'/comm/action/document.php?id='.$object->id;
  $head[$h][1] = $langs->trans("Documents");
  if (($nbFiles + $nbLinks) > 0) {
    $head[$h][1] .= (!getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER') ? '<span class="badge marginleftonlyshort">'.($nbFiles + $nbLinks).'</span>' : '');
  }
  $head[$h][2] = 'documents';
  $h++;
 
  $head[$h][0] = DOL_URL_ROOT.'/comm/action/info.php?id='.$object->id;
  $head[$h][1] = $langs->trans('Info');
  $head[$h][2] = 'info';
  $h++;
 
  complete_head_from_modules($conf, $langs, $object, $head, $h, 'action');
 
  complete_head_from_modules($conf, $langs, $object, $head, $h, 'action', 'remove');
 
  return $head;
}
 
 
function calendars_prepare_head($param)
{
  global $langs, $conf, $user;
 
  $h = 0;
  $head = array();
 
  $head[$h][0] = DOL_URL_ROOT.'/comm/action/list.php?mode=show_list'.($param ? '&'.$param : '');
  $head[$h][1] = $langs->trans("ViewList");
  $head[$h][2] = 'cardlist';
  $h++;
 
  $head[$h][0] = DOL_URL_ROOT.'/comm/action/index.php?mode=show_month'.($param ? '&'.$param : '');
  $head[$h][1] = $langs->trans("ViewCal");
  $head[$h][2] = 'cardmonth';
  $h++;
 
  $head[$h][0] = DOL_URL_ROOT.'/comm/action/index.php?mode=show_week'.($param ? '&'.$param : '');
  $head[$h][1] = $langs->trans("ViewWeek");
  $head[$h][2] = 'cardweek';
  $h++;
 
  $head[$h][0] = DOL_URL_ROOT.'/comm/action/index.php?mode=show_day'.($param ? '&'.$param : '');
  $head[$h][1] = $langs->trans("ViewDay");
  $head[$h][2] = 'cardday';
  $h++;
 
  //if (!empty($conf->global->AGENDA_USE_EVENT_TYPE))
  if (getDolGlobalString('AGENDA_SHOW_PERTYPE')) {
    $head[$h][0] = DOL_URL_ROOT.'/comm/action/pertype.php'.($param ? '?'.$param : '');
    $head[$h][1] = $langs->trans("ViewPerType");
    $head[$h][2] = 'cardpertype';
    $h++;
  }
 
  $newparam = $param;
  $newparam = preg_replace('/&?search_filtert=\d+/', '', $newparam);
  $head[$h][0] = DOL_URL_ROOT.'/comm/action/peruser.php'.($newparam ? '?'.$newparam : '');
  $head[$h][1] = $langs->trans("ViewPerUser");
  $head[$h][2] = 'cardperuser';
  $h++;
 
 
  // Show more tabs from modules
  // Entries must be declared in modules descriptor with line
  // $this->tabs = array('entity:+tabname:Title:@mymodule:/mymodule/mypage.php?id=__ID__');   to add new tab
  // $this->tabs = array('entity:-tabname);                           to remove a tab
  complete_head_from_modules($conf, $langs, null, $head, $h, 'agenda');
 
  complete_head_from_modules($conf, $langs, null, $head, $h, 'agenda', 'remove');
 
  return $head;
}