30 if (!defined(
"NOREDIRECTBYMAINTOLOGIN")) {
31 define(
'NOREDIRECTBYMAINTOLOGIN', 1);
34 require
'../../main.inc.php';
35 require_once DOL_DOCUMENT_ROOT.
'/contact/class/contact.class.php';
36 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
37 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
38 require_once DOL_DOCUMENT_ROOT.
'/core/lib/agenda.lib.php';
39 include_once DOL_DOCUMENT_ROOT.
'/core/class/html.formactions.class.php';
40 require_once DOL_DOCUMENT_ROOT.
'/core/class/extrafields.class.php';
43 $langs->loadLangs(array(
"users",
"companies",
"agenda",
"commercial",
"other",
"orders",
"bills"));
45 $action =
GETPOST(
'action',
'aZ09');
46 $massaction =
GETPOST(
'massaction',
'alpha');
47 $contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'actioncommlist';
48 $optioncss =
GETPOST(
'optioncss',
'alpha');
49 $toselect =
GETPOST(
'toselect',
'array');
50 $confirm =
GETPOST(
'confirm',
'alpha');
52 $disabledefaultvalues =
GETPOST(
'disabledefaultvalues',
'int');
54 $mode =
GETPOST(
'mode',
'aZ09');
55 if (empty($mode) && preg_match(
'/show_/', $action)) {
58 $resourceid =
GETPOST(
"search_resourceid",
"int") ?
GETPOST(
"search_resourceid",
"int") :
GETPOST(
"resourceid",
"int");
59 $pid =
GETPOST(
"search_projectid",
'int', 3) ?
GETPOST(
"search_projectid",
'int', 3) :
GETPOST(
"projectid",
'int', 3);
60 $search_status = (
GETPOST(
"search_status",
'aZ09') !=
'') ?
GETPOST(
"search_status",
'aZ09') :
GETPOST(
"status",
'aZ09');
61 $type =
GETPOST(
'search_type',
'alphanohtml') ?
GETPOST(
'search_type',
'alphanohtml') :
GETPOST(
'type',
'alphanohtml');
63 $month =
GETPOST(
"month",
'int');
67 if (
GETPOST(
'search_actioncode',
'array')) {
68 $actioncode =
GETPOST(
'search_actioncode',
'array', 3);
69 if (!count($actioncode)) {
73 $actioncode =
GETPOST(
"search_actioncode",
"alpha", 3) ?
GETPOST(
"search_actioncode",
"alpha", 3) : (
GETPOST(
"search_actioncode") ==
'0' ?
'0' : ((empty($conf->global->AGENDA_DEFAULT_FILTER_TYPE) || $disabledefaultvalues) ?
'' : $conf->global->AGENDA_DEFAULT_FILTER_TYPE));
76 $search_id =
GETPOST(
'search_id',
'alpha');
77 $search_title =
GETPOST(
'search_title',
'alpha');
78 $search_note =
GETPOST(
'search_note',
'alpha');
81 $datestart_dtstart =
dol_mktime(0, 0, 0,
GETPOST(
'datestart_dtstartmonth',
'int'),
GETPOST(
'datestart_dtstartday',
'int'),
GETPOST(
'datestart_dtstartyear',
'int'),
'tzuserrel');
82 $datestart_dtend =
dol_mktime(23, 59, 59,
GETPOST(
'datestart_dtendmonth',
'int'),
GETPOST(
'datestart_dtendday',
'int'),
GETPOST(
'datestart_dtendyear',
'int'),
'tzuserrel');
83 $dateend_dtstart =
dol_mktime(0, 0, 0,
GETPOST(
'dateend_dtstartmonth',
'int'),
GETPOST(
'dateend_dtstartday',
'int'),
GETPOST(
'dateend_dtstartyear',
'int'),
'tzuserrel');
84 $dateend_dtend =
dol_mktime(23, 59, 59,
GETPOST(
'dateend_dtendmonth',
'int'),
GETPOST(
'dateend_dtendday',
'int'),
GETPOST(
'dateend_dtendyear',
'int'),
'tzuserrel');
85 if ($search_status ==
'' && !
GETPOSTISSET(
'search_status')) {
86 $search_status = ((empty($conf->global->AGENDA_DEFAULT_FILTER_STATUS) || $disabledefaultvalues) ?
'' : $conf->global->AGENDA_DEFAULT_FILTER_STATUS);
89 $mode = (empty($conf->global->AGENDA_DEFAULT_VIEW) ?
'show_month' : $conf->global->AGENDA_DEFAULT_VIEW);
92 $filter =
GETPOST(
"search_filter",
'alpha', 3) ?
GETPOST(
"search_filter",
'alpha', 3) :
GETPOST(
"filter",
'alpha', 3);
93 $filtert =
GETPOST(
"search_filtert",
"int", 3) ?
GETPOST(
"search_filtert",
"int", 3) :
GETPOST(
"filtert",
"int", 3);
94 $usergroup =
GETPOST(
"search_usergroup",
"int", 3) ?
GETPOST(
"search_usergroup",
"int", 3) :
GETPOST(
"usergroup",
"int", 3);
95 $showbirthday = empty($conf->use_javascript_ajax) ? (
GETPOST(
"search_showbirthday",
"int") ?
GETPOST(
"search_showbirthday",
"int") :
GETPOST(
"showbirthday",
"int")) : 1;
99 $hookmanager->initHooks(array(
'agendalist'));
104 $extrafields->fetch_name_optionals_label($object->table_element);
106 $search_array_options = $extrafields->getOptionalsFromPost($object->table_element,
'',
'search_');
108 if (empty($filtert) && empty($conf->global->AGENDA_ALL_CALENDARS)) {
109 $filtert = $user->id;
112 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
113 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
114 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
116 if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
120 $offset = $limit * $page;
122 $sortorder =
"DESC,DESC";
123 if ($search_status ==
'todo') {
124 $sortorder =
"DESC,DESC";
128 $sortfield =
"a.datep,a.id";
129 if ($search_status ==
'todo') {
130 $sortfield =
"a.datep,a.id";
137 $socid = $user->socid;
144 if (empty($user->rights->agenda->myactions->read)) {
147 if (empty($user->rights->agenda->allactions->read)) {
150 if (empty($user->rights->agenda->allactions->read) || $filter ==
'mine') {
151 $filtert = $user->id;
154 $arrayfields = array(
155 'a.id'=>array(
'label'=>
"Ref",
'checked'=>1),
156 'owner'=>array(
'label'=>
"Owner",
'checked'=>1),
157 'c.libelle'=>array(
'label'=>
"Type",
'checked'=>1),
158 'a.label'=>array(
'label'=>
"Title",
'checked'=>1),
159 'a.note'=>array(
'label'=>
'Description',
'checked'=>0),
160 'a.datep'=>array(
'label'=>
"DateStart",
'checked'=>1),
161 'a.datep2'=>array(
'label'=>
"DateEnd",
'checked'=>1),
162 's.nom'=>array(
'label'=>
"ThirdParty",
'checked'=>1),
163 'a.fk_contact'=>array(
'label'=>
"Contact",
'checked'=>0),
164 'a.fk_element'=>array(
'label'=>
"LinkedObject",
'checked'=>1,
'enabled'=>(!empty($conf->global->AGENDA_SHOW_LINKED_OBJECT))),
165 'a.datec'=>array(
'label'=>
'DateCreation',
'checked'=>0,
'position'=>510),
166 'a.tms'=>array(
'label'=>
'DateModification',
'checked'=>0,
'position'=>520),
167 'a.percent'=>array(
'label'=>
"Status",
'checked'=>1,
'position'=>1000)
170 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_array_fields.tpl.php';
176 if ($user->socid && $socid) {
185 if (
GETPOST(
'cancel',
'alpha')) {
192 if (is_array($_POST)) {
193 foreach ($_POST as $key => $val) {
194 $param .=
'&'.$key.
'='.urlencode($val);
198 header(
"Location: ".DOL_URL_ROOT.
'/comm/action/index.php?'.$param);
202 $parameters = array(
'id'=>$socid);
203 $reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
209 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
211 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
216 $datestart_dtstart =
'';
217 $datestart_dtend =
'';
218 $dateend_dtstart =
'';
229 $search_array_options = array();
232 if (empty($reshook) && !empty($massaction)) {
235 switch ($massaction) {
236 case 'set_all_events_to_todo':
240 case 'set_all_events_to_in_progress':
244 case 'set_all_events_to_finished':
249 if (isset($percent)) {
250 foreach ($toselect as $toselectid) {
251 $result = $object->updatePercent($toselectid, $percent);
261 if (empty($reshook)) {
262 $objectclass =
'ActionComm';
263 $objectlabel =
'Events';
266 $permissiontodelete = $user->rights->agenda->allactions->delete;
267 $permissiontoadd = $user->rights->agenda->myactions->create;
268 include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
276 $userstatic =
new User($db);
280 $societestatic =
new Societe($db);
281 $contactstatic =
new Contact($db);
284 $nav .=
$form->selectDate($dateselect,
'dateselect', 0, 0, 1,
'', 1, 0);
285 $nav .=
' <input type="submit" name="submitdateselect" class="button" value="'.$langs->trans(
"Refresh").
'">';
289 $help_url =
'EN:Module_Agenda_En|FR:Module_Agenda|ES:M&omodulodulo_Agenda';
290 $title = $langs->trans(
"Agenda");
294 $listofextcals = array();
297 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
298 $param .=
'&contextpage='.urlencode($contextpage);
300 if ($limit > 0 && $limit != $conf->liste_limit) {
301 $param .=
'&limit='.urlencode($limit);
303 if ($actioncode !=
'') {
304 if (is_array($actioncode)) {
305 foreach ($actioncode as $str_action) {
306 $param .=
"&search_actioncode[]=".urlencode($str_action);
309 $param .=
"&search_actioncode=".urlencode($actioncode);
312 if ($resourceid > 0) {
313 $param .=
"&search_resourceid=".urlencode($resourceid);
315 if ($search_status !=
'') {
316 $param .=
"&search_status=".urlencode($search_status);
319 $param .=
"&search_filter=".urlencode($filter);
322 $param .=
"&search_filtert=".urlencode($filtert);
324 if ($usergroup > 0) {
325 $param .=
"&search_usergroup=".urlencode($usergroup);
328 $param .=
"&search_socid=".urlencode($socid);
331 $param .=
"&search_showbirthday=1";
334 $param .=
"&search_projectid=".urlencode($pid);
337 $param .=
"&search_type=".urlencode($type);
339 if ($search_id !=
'') {
340 $param .=
'&search_title='.urlencode($search_id);
342 if ($search_title !=
'') {
343 $param .=
'&search_title='.urlencode($search_title);
345 if ($search_note !=
'') {
346 $param .=
'&search_note='.urlencode($search_note);
348 if (
GETPOST(
'datestart_dtstartday',
'int')) {
349 $param .=
'&datestart_dtstartday='.GETPOST(
'datestart_dtstartday',
'int');
351 if (
GETPOST(
'datestart_dtstartmonth',
'int')) {
352 $param .=
'&datestart_dtstartmonth='.GETPOST(
'datestart_dtstartmonth',
'int');
354 if (
GETPOST(
'datestart_dtstartyear',
'int')) {
355 $param .=
'&datestart_dtstartyear='.GETPOST(
'datestart_dtstartyear',
'int');
357 if (
GETPOST(
'datestart_dtendday',
'int')) {
358 $param .=
'&datestart_dtendday='.GETPOST(
'datestart_dtendday',
'int');
360 if (
GETPOST(
'datestart_dtendmonth',
'int')) {
361 $param .=
'&datestart_dtendmonth='.GETPOST(
'datestart_dtendmonth',
'int');
363 if (
GETPOST(
'datestart_dtendyear',
'int')) {
364 $param .=
'&datestart_dtendyear='.GETPOST(
'datestart_dtendyear',
'int');
366 if (
GETPOST(
'dateend_dtstartday',
'int')) {
367 $param .=
'&dateend_dtstartday='.GETPOST(
'dateend_dtstartday',
'int');
369 if (
GETPOST(
'dateend_dtstartmonth',
'int')) {
370 $param .=
'&dateend_dtstartmonth='.GETPOST(
'dateend_dtstartmonth',
'int');
372 if (
GETPOST(
'dateend_dtstartyear',
'int')) {
373 $param .=
'&dateend_dtstartyear='.GETPOST(
'dateend_dtstartyear',
'int');
375 if (
GETPOST(
'dateend_dtendday',
'int')) {
376 $param .=
'&dateend_dtendday='.GETPOST(
'dateend_dtendday',
'int');
378 if (
GETPOST(
'dateend_dtendmonth',
'int')) {
379 $param .=
'&dateend_dtendmonth='.GETPOST(
'dateend_dtendmonth',
'int');
381 if (
GETPOST(
'dateend_dtendyear',
'int')) {
382 $param .=
'&dateend_dtendyear='.GETPOST(
'dateend_dtendyear',
'int');
384 if ($optioncss !=
'') {
385 $param .=
'&optioncss='.urlencode($optioncss);
388 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
390 $paramnoactionodate = $param;
393 $arrayofmassactions = array(
394 'set_all_events_to_todo' => $langs->trans(
"SetAllEventsToTodo"),
395 'set_all_events_to_in_progress' => $langs->trans(
"SetAllEventsToInProgress"),
396 'set_all_events_to_finished' => $langs->trans(
"SetAllEventsToFinished"),
398 if ($user->rights->agenda->allactions->delete) {
399 $arrayofmassactions[
'predelete'] =
img_picto(
'',
'delete',
'class="pictofixedwidth"').$langs->trans(
"Delete");
401 if (
isModEnabled(
'category') && $user->rights->agenda->myactions->create) {
402 $arrayofmassactions[
'preaffecttag'] =
img_picto(
'',
'category',
'class="pictofixedwidth"').$langs->trans(
"AffectTag");
404 if (
GETPOST(
'nomassaction',
'int') || in_array($massaction, array(
'presend',
'predelete',
'preaffecttag'))) {
405 $arrayofmassactions = array();
407 $massactionbutton =
$form->selectMassAction(
'', $arrayofmassactions);
410 if ($usergroup > 0) {
413 $sql .=
" s.nom as societe, s.rowid as socid, s.client, s.email as socemail,";
414 $sql .=
" a.id, a.code, a.label, a.note, a.datep as dp, a.datep2 as dp2, a.fulldayevent, a.location,";
415 $sql .=
" a.fk_user_author, a.fk_user_action,";
416 $sql .=
" a.fk_contact, a.note, a.percent as percent,";
417 $sql .=
" a.fk_element, a.elementtype, a.datec, a.tms as datem,";
418 $sql .=
" c.code as type_code, c.libelle as type_label, c.color as type_color, c.type as type_type, c.picto as type_picto,";
419 $sql .=
" sp.lastname, sp.firstname, sp.email, sp.phone, sp.address, sp.phone as phone_pro, sp.phone_mobile, sp.phone_perso, sp.fk_pays as country_id";
422 if (!empty($extrafields->attributes[$object->table_element][
'label'])) {
423 foreach ($extrafields->attributes[$object->table_element][
'label'] as $key => $val) {
424 $sql .= ($extrafields->attributes[$object->table_element][
'type'][$key] !=
'separate' ?
", ef.".$key.
" as options_".$key :
'');
429 $parameters = array();
430 $reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters, $object, $action);
431 $sql .= $hookmanager->resPrint;
435 $sql .=
" FROM ".MAIN_DB_PREFIX.
"actioncomm as a";
436 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"actioncomm_extrafields as ef ON (a.id = ef.fk_object)";
437 if (empty($user->rights->societe->client->voir) && !$socid) {
438 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON a.fk_soc = sc.fk_soc";
440 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON a.fk_soc = s.rowid";
441 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"socpeople as sp ON a.fk_contact = sp.rowid";
442 $sql .=
" ,".MAIN_DB_PREFIX.
"c_actioncomm as c";
444 if ($resourceid > 0) {
445 $sql .=
", ".MAIN_DB_PREFIX.
"element_resources as r";
448 if ($filtert > 0 || $usergroup > 0) {
449 $sql .=
", ".MAIN_DB_PREFIX.
"actioncomm_resources as ar";
451 if ($usergroup > 0) {
452 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"usergroup_user as ugu ON ugu.fk_user = ar.fk_element";
454 $sql .=
" WHERE c.id = a.fk_action";
455 $sql .=
' AND a.entity IN ('.getEntity(
'agenda').
')';
457 if (!empty($actioncode)) {
458 if (empty($conf->global->AGENDA_USE_EVENT_TYPE)) {
459 if ($actioncode ==
'AC_NON_AUTO') {
460 $sql .=
" AND c.type != 'systemauto'";
461 } elseif ($actioncode ==
'AC_ALL_AUTO') {
462 $sql .=
" AND c.type = 'systemauto'";
464 if ($actioncode ==
'AC_OTH') {
465 $sql .=
" AND c.type != 'systemauto'";
467 if ($actioncode ==
'AC_OTH_AUTO') {
468 $sql .=
" AND c.type = 'systemauto'";
472 if ($actioncode ==
'AC_NON_AUTO') {
473 $sql .=
" AND c.type != 'systemauto'";
474 } elseif ($actioncode ==
'AC_ALL_AUTO') {
475 $sql .=
" AND c.type = 'systemauto'";
477 if (is_array($actioncode)) {
478 $sql .=
" AND c.code IN (".$db->sanitize(
"'".implode(
"','", $actioncode).
"'", 1).
")";
480 $sql .=
" AND c.code IN (".$db->sanitize(
"'".implode(
"','", explode(
',', $actioncode)).
"'", 1).
")";
485 if ($resourceid > 0) {
486 $sql .=
" AND r.element_type = 'action' AND r.element_id = a.id AND r.resource_id = ".((int) $resourceid);
489 $sql .=
" AND a.fk_project=".((int) $pid);
491 if (empty($user->rights->societe->client->voir) && !$socid) {
492 $sql .=
" AND (a.fk_soc IS NULL OR sc.fk_user = ".((int) $user->id).
")";
495 $sql .=
" AND s.rowid = ".((int) $socid);
498 if ($filtert > 0 || $usergroup > 0) {
499 $sql .=
" AND ar.fk_actioncomm = a.id AND ar.element_type='user'";
502 $sql .=
" AND c.id = ".((int) $type);
504 if ($search_status ==
'0') {
505 $sql .=
" AND a.percent = 0";
507 if ($search_status ==
'na') {
508 $sql .=
" AND a.percent = -1";
510 if ($search_status ==
'50') {
511 $sql .=
" AND (a.percent > 0 AND a.percent < 100)";
513 if ($search_status ==
'100') {
514 $sql .=
" AND a.percent = 100";
516 if ($search_status ==
'done') {
517 $sql .=
" AND (a.percent = 100)";
519 if ($search_status ==
'todo') {
520 $sql .=
" AND (a.percent >= 0 AND a.percent < 100)";
532 if ($filtert > 0 || $usergroup > 0) {
535 $sql .=
"(ar.fk_element = ".((int) $filtert).
" OR (ar.fk_element IS NULL AND a.fk_user_action = ".((int) $filtert).
"))";
537 if ($usergroup > 0) {
538 $sql .= ($filtert > 0 ?
" OR " :
"").
" ugu.fk_usergroup = ".((
int) $usergroup);
544 if ($dateselect > 0) {
545 $sql .=
" AND ((a.datep2 >= '".$db->idate($dateselect).
"' AND a.datep <= '".$db->idate($dateselect + 3600 * 24 - 1).
"') OR (a.datep2 IS NULL AND a.datep > '".$db->idate($dateselect - 3600).
"' AND a.datep <= '".$db->idate($dateselect + 3600 * 24 - 1).
"'))";
547 if ($datestart_dtstart > 0) {
548 $sql .=
" AND a.datep >= '".$db->idate($datestart_dtstart).
"'";
550 if ($datestart_dtend > 0) {
551 $sql .=
" AND a.datep <= '".$db->idate($datestart_dtend).
"'";
553 if ($dateend_dtstart > 0) {
554 $sql .=
" AND a.datep2 >= '".$db->idate($dateend_dtstart).
"'";
556 if ($dateend_dtend > 0) {
557 $sql .=
" AND a.datep2 <= '".$db->idate($dateend_dtend).
"'";
561 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
564 $parameters = array();
565 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object, $action);
566 $sql .= $hookmanager->resPrint;
569 $nbtotalofrecords =
'';
570 if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
581 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords', $sql);
582 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
584 $resql = $db->query($sqlforcount);
588 $objforcount = $db->fetch_object(
$resql);
589 $nbtotalofrecords = $objforcount->nbtotalofrecords;
590 if (($page * $limit) > $nbtotalofrecords) {
599 $sql .= $db->order($sortfield, $sortorder);
601 $sql .= $db->plimit($limit + 1, $offset);
604 $resql = $db->query($sql);
610 $num = $db->num_rows(
$resql);
612 $arrayofselected = is_array($toselect) ? $toselect : array();
615 $newtitle =
'<div class="nowrap clear inline-block minheight30 margintoponly">';
616 $newtitle .=
'<input type="checkbox" id="check_mytasks" name="check_mytasks" checked disabled> '.$langs->trans(
"LocalAgenda").
' ';
617 $newtitle .=
'</div>';
620 $tabactive =
'cardlist';
624 print
'<form method="POST" id="searchFormList" class="listactionsfilter" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
626 if ($optioncss !=
'') {
627 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
629 print
'<input type="hidden" name="token" value="'.newToken().
'">';
630 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
631 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
632 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
633 print
'<input type="hidden" name="type" value="'.$type.
'">';
637 $nav .=
'<input type="hidden" name="search_filter" value="'.$filter.
'">';
640 $nav .=
'<input type="hidden" name="search_showbirthday" value="1">';
652 $parameters = array();
653 $reshook = $hookmanager->executeHooks(
'addCalendarChoice', $parameters, $object, $action);
654 if (empty($reshook)) {
655 $s .= $hookmanager->resPrint;
656 } elseif ($reshook > 1) {
657 $s = $hookmanager->resPrint;
659 $viewyear = is_object($object) ?
dol_print_date($object->datep,
'%Y') :
'';
660 $viewmonth = is_object($object) ?
dol_print_date($object->datep,
'%m') :
'';
661 $viewday = is_object($object) ?
dol_print_date($object->datep,
'%d') :
'';
663 $viewmode .=
'<a class="btnTitle btnTitleSelected reposition" href="'.DOL_URL_ROOT.
'/comm/action/list.php?mode=show_list&restore_lastsearch_values=1'.$paramnoactionodate.
'">';
665 $viewmode .=
img_picto($langs->trans(
"List"),
'object_calendarlist',
'class="imgforviewmode pictoactionview block"');
667 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewList").
'</span></a>';
669 $viewmode .=
'<a class="btnTitle reposition" href="'.DOL_URL_ROOT.
'/comm/action/index.php?mode=show_month&year='.$viewyear.
'&month='.$viewmonth.
'&day='.$viewday.$paramnoactionodate.
'">';
671 $viewmode .=
img_picto($langs->trans(
"ViewCal"),
'object_calendarmonth',
'class="pictoactionview block"');
673 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewCal").
'</span></a>';
675 $viewmode .=
'<a class="btnTitle reposition" href="'.DOL_URL_ROOT.
'/comm/action/index.php?mode=show_week&year='.$viewyear.
'&month='.$viewmonth.
'&day='.$viewday.$paramnoactionodate.
'">';
677 $viewmode .=
img_picto($langs->trans(
"ViewWeek"),
'object_calendarweek',
'class="pictoactionview block"');
679 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewWeek").
'</span></a>';
681 $viewmode .=
'<a class="btnTitle reposition" href="'.DOL_URL_ROOT.
'/comm/action/index.php?mode=show_day&year='.$viewyear.
'&month='.$viewmonth.
'&day='.$viewday.$paramnoactionodate.
'">';
683 $viewmode .=
img_picto($langs->trans(
"ViewDay"),
'object_calendarday',
'class="pictoactionview block"');
685 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewDay").
'</span></a>';
687 $viewmode .=
'<a class="btnTitle reposition marginrightonly" href="'.DOL_URL_ROOT.
'/comm/action/peruser.php?mode=show_peruser&year='.$viewyear.
'&month='.$viewmonth.
'&day='.$viewday.$paramnoactionodate.
'">';
689 $viewmode .=
img_picto($langs->trans(
"ViewPerUser"),
'object_calendarperuser',
'class="pictoactionview block"');
691 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewPerUser").
'</span></a>';
693 $viewmode .=
'<span class="marginrightonly"></span>';
696 $parameters = array();
697 $reshook = $hookmanager->executeHooks(
'addCalendarView', $parameters, $object, $action);
698 if (empty($reshook)) {
699 $viewmode .= $hookmanager->resPrint;
700 } elseif ($reshook > 1) {
701 $viewmode = $hookmanager->resPrint;
706 $newparam =
'&month='.str_pad($month, 2,
"0", STR_PAD_LEFT).
'&year='.$tmpforcreatebutton[
'year'];
711 $url = DOL_URL_ROOT.
'/comm/action/card.php?action=create';
712 $url .=
'&datep='.sprintf(
"%04d%02d%02d", $tmpforcreatebutton[
'year'], $tmpforcreatebutton[
'mon'], $tmpforcreatebutton[
'mday']).$hourminsec;
713 $url .=
'&backtopage='.urlencode($_SERVER[
"PHP_SELF"].($newparam ?
'?'.$newparam :
''));
715 $newcardbutton =
dolGetButtonTitle($langs->trans(
'AddAction'),
'',
'fa fa-plus-circle', $url,
'', $user->rights->agenda->myactions->create || $user->rights->agenda->allactions->create);
717 $param .=
'&mode='.$mode;
719 print_barre_liste($langs->trans(
"Agenda"), $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, -1 * $nbtotalofrecords,
'object_action', 0, $nav.$newcardbutton,
'', $limit, 0, 0, 1, $viewmode);
724 include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
728 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
729 $selectedfields =
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage);
730 if ($massactionbutton) {
731 $selectedfields .=
$form->showCheckAddButtons(
'checkforselect', 1);
735 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
736 print_actions_filter(
$form, $canedit, $search_status, $year, $month, $day, $showbirthday, 0, $filtert, 0, $pid, $socid, $action, -1, $actioncode, $usergroup,
'', $resourceid);
739 print
'<div class="div-table-responsive">';
740 print
'<table class="tagtable liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
742 print
'<tr class="liste_titre_filter">';
743 if (!empty($arrayfields[
'a.id'][
'checked'])) {
744 print
'<td class="liste_titre"><input type="text" class="maxwidth50" name="search_id" value="'.$search_id.
'"></td>';
746 if (!empty($arrayfields[
'owner'][
'checked'])) {
747 print
'<td class="liste_titre"></td>';
749 if (!empty($arrayfields[
'c.libelle'][
'checked'])) {
750 print
'<td class="liste_titre"></td>';
752 if (!empty($arrayfields[
'a.label'][
'checked'])) {
753 print
'<td class="liste_titre"><input type="text" class="maxwidth75" name="search_title" value="'.$search_title.
'"></td>';
755 if (!empty($arrayfields[
'a.note'][
'checked'])) {
756 print
'<td class="liste_titre"><input type="text" class="maxwidth75" name="search_note" value="'.$search_note.
'"></td>';
758 if (!empty($arrayfields[
'a.datep'][
'checked'])) {
759 print
'<td class="liste_titre nowraponall" align="center">';
760 print
'<div class="nowrap">';
761 print
$form->selectDate($datestart_dtstart,
'datestart_dtstart', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'),
'tzuserrel');
763 print
'<div class="nowrap">';
764 print
$form->selectDate($datestart_dtend,
'datestart_dtend', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'To'),
'tzuserrel');
768 if (!empty($arrayfields[
'a.datep2'][
'checked'])) {
769 print
'<td class="liste_titre nowraponall" align="center">';
770 print
'<div class="nowrap">';
771 print
$form->selectDate($dateend_dtstart,
'dateend_dtstart', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'),
'tzuserrel');
773 print
'<div class="nowrap">';
774 print
$form->selectDate($dateend_dtend,
'dateend_dtend', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'To'),
'tzuserrel');
778 if (!empty($arrayfields[
's.nom'][
'checked'])) {
779 print
'<td class="liste_titre"></td>';
781 if (!empty($arrayfields[
'a.fk_contact'][
'checked'])) {
782 print
'<td class="liste_titre"></td>';
784 if (!empty($arrayfields[
'a.fk_element'][
'checked'])) {
785 print
'<td class="liste_titre"></td>';
789 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
792 $parameters = array(
'arrayfields'=>$arrayfields);
793 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters);
794 print $hookmanager->resPrint;
796 if (!empty($arrayfields[
'a.datec'][
'checked'])) {
797 print
'<td class="liste_titre"></td>';
799 if (!empty($arrayfields[
'a.tms'][
'checked'])) {
800 print
'<td class="liste_titre"></td>';
802 if (!empty($arrayfields[
'a.percent'][
'checked'])) {
803 print
'<td class="liste_titre center">';
804 $formactions->form_select_status_action(
'formaction', $search_status, 1,
'search_status', 1, 2,
'minwidth100imp maxwidth125');
809 print
'<td class="liste_titre" align="middle">';
810 $searchpicto =
$form->showFilterButtons();
815 $totalarray = array();
816 $totalarray[
'nbfield'] = 0;
820 print
'<tr class="liste_titre">';
821 if (!empty($arrayfields[
'a.id'][
'checked'])) {
822 print_liste_field_titre($arrayfields[
'a.id'][
'label'], $_SERVER[
"PHP_SELF"],
"a.id", $param,
"",
"", $sortfield, $sortorder);
823 $totalarray[
'nbfield']++;
825 if (!empty($arrayfields[
'owner'][
'checked'])) {
826 print_liste_field_titre($arrayfields[
'owner'][
'label'], $_SERVER[
"PHP_SELF"],
"", $param,
"",
"", $sortfield, $sortorder);
827 $totalarray[
'nbfield']++;
829 if (!empty($arrayfields[
'c.libelle'][
'checked'])) {
830 print_liste_field_titre($arrayfields[
'c.libelle'][
'label'], $_SERVER[
"PHP_SELF"],
"c.libelle", $param,
"",
"", $sortfield, $sortorder);
831 $totalarray[
'nbfield']++;
833 if (!empty($arrayfields[
'a.label'][
'checked'])) {
834 print_liste_field_titre($arrayfields[
'a.label'][
'label'], $_SERVER[
"PHP_SELF"],
"a.label", $param,
"",
"", $sortfield, $sortorder);
835 $totalarray[
'nbfield']++;
837 if (!empty($arrayfields[
'a.note'][
'checked'])) {
838 print_liste_field_titre($arrayfields[
'a.note'][
'label'], $_SERVER[
"PHP_SELF"],
"a.note", $param,
"",
"", $sortfield, $sortorder);
839 $totalarray[
'nbfield']++;
842 if (!empty($arrayfields[
'a.datep'][
'checked'])) {
843 print_liste_field_titre($arrayfields[
'a.datep'][
'label'], $_SERVER[
"PHP_SELF"],
"a.datep,a.id", $param,
'',
'align="center"', $sortfield, $sortorder);
844 $totalarray[
'nbfield']++;
846 if (!empty($arrayfields[
'a.datep2'][
'checked'])) {
847 print_liste_field_titre($arrayfields[
'a.datep2'][
'label'], $_SERVER[
"PHP_SELF"],
"a.datep2", $param,
'',
'align="center"', $sortfield, $sortorder);
848 $totalarray[
'nbfield']++;
850 if (!empty($arrayfields[
's.nom'][
'checked'])) {
851 print_liste_field_titre($arrayfields[
's.nom'][
'label'], $_SERVER[
"PHP_SELF"],
"s.nom", $param,
"",
"", $sortfield, $sortorder);
852 $totalarray[
'nbfield']++;
854 if (!empty($arrayfields[
'a.fk_contact'][
'checked'])) {
855 print_liste_field_titre($arrayfields[
'a.fk_contact'][
'label'], $_SERVER[
"PHP_SELF"],
"", $param,
"",
"", $sortfield, $sortorder);
856 $totalarray[
'nbfield']++;
858 if (!empty($arrayfields[
'a.fk_element'][
'checked'])) {
859 print_liste_field_titre($arrayfields[
'a.fk_element'][
'label'], $_SERVER[
"PHP_SELF"],
"", $param,
"",
"", $sortfield, $sortorder);
860 $totalarray[
'nbfield']++;
863 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
865 $parameters = array(
'arrayfields'=>$arrayfields,
'param'=>$param,
'sortfield'=>$sortfield,
'sortorder'=>$sortorder);
866 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters);
867 print $hookmanager->resPrint;
869 if (!empty($arrayfields[
'a.datec'][
'checked'])) {
870 print_liste_field_titre($arrayfields[
'a.datec'][
'label'], $_SERVER[
"PHP_SELF"],
"a.datec,a.id", $param,
"",
'align="center"', $sortfield, $sortorder);
871 $totalarray[
'nbfield']++;
873 if (!empty($arrayfields[
'a.tms'][
'checked'])) {
874 print_liste_field_titre($arrayfields[
'a.tms'][
'label'], $_SERVER[
"PHP_SELF"],
"a.tms,a.id", $param,
"",
'align="center"', $sortfield, $sortorder);
875 $totalarray[
'nbfield']++;
878 if (!empty($arrayfields[
'a.percent'][
'checked'])) {
879 print_liste_field_titre(
"Status", $_SERVER[
"PHP_SELF"],
"a.percent", $param,
"",
'align="center"', $sortfield, $sortorder);
880 $totalarray[
'nbfield']++;
882 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'',
'',
'align="center"', $sortfield, $sortorder,
'maxwidthsearch ');
883 $totalarray[
'nbfield']++;
887 $delay_warning = $conf->global->MAIN_DELAY_ACTIONS_TODO * 24 * 60 * 60;
889 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/cactioncomm.class.php';
891 $arraylist = $caction->liste_array(1,
'code',
'', (empty($conf->global->AGENDA_USE_EVENT_TYPE) ? 1 : 0),
'', 1);
892 $contactListCache = array();
899 $imaxinloop = ($limit ? min($num, $limit) : $num);
900 while ($i < $imaxinloop) {
901 $obj = $db->fetch_object(
$resql);
907 $object->setVarsFromFetchObj($obj);
910 if (!empty($conf->global->AGENDA_ALWAYS_HIDE_AUTO) && $obj->type_code ==
'AC_OTH_AUTO') {
915 $actionstatic->id = $obj->id;
916 $actionstatic->ref = $obj->id;
917 $actionstatic->code = $obj->code;
918 $actionstatic->type_code = $obj->type_code;
919 $actionstatic->type_label = $obj->type_label;
920 $actionstatic->type_picto = $obj->type_picto;
921 $actionstatic->type_color = $obj->type_color;
922 $actionstatic->label = $obj->label;
923 $actionstatic->location = $obj->location;
925 $actionstatic->datep = $db->jdate($obj->dp);
926 $actionstatic->percentage = $obj->percent;
927 $actionstatic->authorid = $obj->fk_user_author;
928 $actionstatic->userownerid = $obj->fk_user_action;
932 if (!empty($arrayfields[
'a.fk_contact'][
'checked'])) {
933 $actionstatic->fetchResources();
936 print
'<tr class="oddeven">';
939 if (!empty($arrayfields[
'a.id'][
'checked'])) {
940 print
'<td class="nowraponall">';
941 print $actionstatic->getNomUrl(1, -1);
946 if (!empty($arrayfields[
'owner'][
'checked'])) {
947 print
'<td class="tdoverflowmax150">';
948 if ($obj->fk_user_action > 0) {
949 $userstatic->fetch($obj->fk_user_action);
950 print $userstatic->getNomUrl(-1);
958 if (!empty($arrayfields[
'c.libelle'][
'checked'])) {
959 print
'<td class="nowraponall">';
960 print $actionstatic->getTypePicto();
961 $labeltype = $obj->type_code;
962 if (empty($conf->global->AGENDA_USE_EVENT_TYPE) && empty($arraylist[$labeltype])) {
963 $labeltype =
'AC_OTH';
965 if ($actionstatic->type_code ==
'AC_OTH' && $actionstatic->code ==
'TICKET_MSG') {
966 $labeltype = $langs->trans(
"Message");
968 if (!empty($arraylist[$labeltype])) {
969 $labeltype = $arraylist[$labeltype];
971 if ($obj->type_code ==
'AC_OTH_AUTO' && ($obj->type_code != $obj->code) && $labeltype && !empty($arraylist[$obj->code])) {
972 $labeltype .=
' - '.$arraylist[$obj->code];
980 if (!empty($arrayfields[
'a.label'][
'checked'])) {
981 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($actionstatic->label).
'">';
982 print $actionstatic->label;
987 if (!empty($arrayfields[
'a.note'][
'checked'])) {
988 print
'<td class="tdoverflowonsmartphone">';
990 print
$form->textwithtooltip(
dol_trunc($text, 48), $actionstatic->note_private);
994 $formatToUse = $obj->fulldayevent ?
'day' :
'dayhour';
997 if (!empty($arrayfields[
'a.datep'][
'checked'])) {
998 print
'<td class="center nowraponall">';
999 if (empty($obj->fulldayevent)) {
1000 print
dol_print_date($db->jdate($obj->dp), $formatToUse,
'tzuserrel');
1003 print
dol_print_date($db->jdate($obj->dp), $formatToUse, ($tzforfullday ? $tzforfullday :
'tzuserrel'));
1006 if ($actionstatic->hasDelay() && $actionstatic->percentage >= 0 && $actionstatic->percentage < 100 ) {
1016 if (!empty($arrayfields[
'a.datep2'][
'checked'])) {
1017 print
'<td class="center nowraponall">';
1018 if (empty($obj->fulldayevent)) {
1019 print
dol_print_date($db->jdate($obj->dp2), $formatToUse,
'tzuserrel');
1022 print
dol_print_date($db->jdate($obj->dp2), $formatToUse, ($tzforfullday ? $tzforfullday :
'tzuserrel'));
1028 if (!empty($arrayfields[
's.nom'][
'checked'])) {
1029 print
'<td class="tdoverflowmax150">';
1030 if ($obj->socid > 0) {
1031 $societestatic->id = $obj->socid;
1032 $societestatic->client = $obj->client;
1033 $societestatic->name = $obj->societe;
1034 $societestatic->email = $obj->socemail;
1036 print $societestatic->getNomUrl(1,
'', 28);
1044 if (!empty($arrayfields[
'a.fk_contact'][
'checked'])) {
1045 print
'<td class="tdoverflowmax100">';
1047 if (!empty($actionstatic->socpeopleassigned)) {
1048 $contactList = array();
1049 foreach ($actionstatic->socpeopleassigned as $socpeopleassigned) {
1050 if (!isset($contactListCache[$socpeopleassigned[
'id']])) {
1053 if ($contact->fetch($socpeopleassigned[
'id']) > 0) {
1054 $contactListCache[$socpeopleassigned[
'id']] = $contact->getNomUrl(1,
'', 0);
1055 $contactList[] = $contact->getNomUrl(1,
'', 0);
1059 $contactList[] = $contactListCache[$socpeopleassigned[
'id']];
1062 if (!empty($contactList)) {
1063 print implode(
', ', $contactList);
1065 } elseif ($obj->fk_contact > 0) {
1066 $contactstatic->id = $obj->fk_contact;
1067 $contactstatic->email = $obj->email;
1068 $contactstatic->lastname = $obj->lastname;
1069 $contactstatic->firstname = $obj->firstname;
1070 $contactstatic->phone_pro = $obj->phone_pro;
1071 $contactstatic->phone_mobile = $obj->phone_mobile;
1072 $contactstatic->phone_perso = $obj->phone_perso;
1073 $contactstatic->country_id = $obj->country_id;
1074 print $contactstatic->getNomUrl(1,
'', 0);
1082 if (!empty($arrayfields[
'a.fk_element'][
'checked'])) {
1083 print
'<td class="tdoverflowmax150">';
1085 if ($obj->fk_element > 0 && !empty($obj->elementtype)) {
1086 include_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
1095 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1097 $parameters = array(
'arrayfields'=>$arrayfields,
'obj'=>$obj,
'i'=>$i,
'totalarray'=>&$totalarray);
1098 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters);
1099 print $hookmanager->resPrint;
1102 if (!empty($arrayfields[
'a.datec'][
'checked'])) {
1104 print
'<td align="center" class="nowrap">'.dol_print_date($db->jdate($obj->datec),
'dayhour',
'tzuserrel').
'</td>';
1107 if (!empty($arrayfields[
'a.tms'][
'checked'])) {
1108 print
'<td align="center" class="nowrap">'.dol_print_date($db->jdate($obj->datem),
'dayhour',
'tzuserrel').
'</td>';
1110 if (!empty($arrayfields[
'a.percent'][
'checked'])) {
1112 $datep = $db->jdate($obj->dp);
1113 print
'<td align="center" class="nowrap">'.$actionstatic->LibStatut($obj->percent, 5, 0, $datep).
'</td>';
1116 print
'<td class="nowrap center">';
1117 if ($massactionbutton || $massaction) {
1119 if (in_array($obj->id, $arrayofselected)) {
1122 print
'<input id="cb'.$obj->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
1132 print
'<tr><td colspan="'.$totalarray[
'nbfield'].
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
1136 print
'</table>'.
"\n";
1137 print
'</div>'.
"\n";
1139 print
'</form>'.
"\n";