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(
'datestartday_dtstart',
'int')) {
349 $param .=
'&datestartday_dtstart='.GETPOST(
'datestartday_dtstart',
'int');
351 if (
GETPOST(
'datestartmonth_dtstart',
'int')) {
352 $param .=
'&datestartmonth_dtstart='.GETPOST(
'datestartmonth_dtstart',
'int');
354 if (
GETPOST(
'datestartyear_dtstart',
'int')) {
355 $param .=
'&datestartyear_dtstart='.GETPOST(
'datestartyear_dtstart',
'int');
357 if (
GETPOST(
'datestartday_dtend',
'int')) {
358 $param .=
'&datestartday_dtend='.GETPOST(
'datestartday_dtend',
'int');
360 if (
GETPOST(
'datestartmonth_dtend',
'int')) {
361 $param .=
'&datestartmonth_dtend='.GETPOST(
'datestartmonth_dtend',
'int');
363 if (
GETPOST(
'datestartyear_dtend',
'int')) {
364 $param .=
'&datestartyear_dtend='.GETPOST(
'datestartyear_dtend',
'int');
366 if (
GETPOST(
'dateendday_dtstart',
'int')) {
367 $param .=
'&dateendday_dtstart='.GETPOST(
'dateendday_dtstart',
'int');
369 if (
GETPOST(
'dateendmonth_dtstart',
'int')) {
370 $param .=
'&dateendmonth_dtstart='.GETPOST(
'dateendmonth_dtstart',
'int');
372 if (
GETPOST(
'dateendyear_dtstart',
'int')) {
373 $param .=
'&dateendyear_dtstart='.GETPOST(
'dateendyear_dtstart',
'int');
375 if (
GETPOST(
'dateendday_dtend',
'int')) {
376 $param .=
'&dateendday_dtend='.GETPOST(
'dateendday_dtend',
'int');
378 if (
GETPOST(
'dateendmonth_dtend',
'int')) {
379 $param .=
'&dateendmonth_dtend='.GETPOST(
'dateendmonth_dtend',
'int');
381 if (
GETPOST(
'dateendyear_dtend',
'int')) {
382 $param .=
'&dateendyear_dtend='.GETPOST(
'dateendyear_dtend',
'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;
433 $sql .=
" FROM ".MAIN_DB_PREFIX.
"actioncomm as a";
434 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"actioncomm_extrafields as ef ON (a.id = ef.fk_object)";
435 if (empty($user->rights->societe->client->voir) && !$socid) {
436 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON a.fk_soc = sc.fk_soc";
438 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON a.fk_soc = s.rowid";
439 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"socpeople as sp ON a.fk_contact = sp.rowid";
440 $sql .=
" ,".MAIN_DB_PREFIX.
"c_actioncomm as c";
442 if ($resourceid > 0) {
443 $sql .=
", ".MAIN_DB_PREFIX.
"element_resources as r";
446 if ($filtert > 0 || $usergroup > 0) {
447 $sql .=
", ".MAIN_DB_PREFIX.
"actioncomm_resources as ar";
449 if ($usergroup > 0) {
450 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"usergroup_user as ugu ON ugu.fk_user = ar.fk_element";
452 $sql .=
" WHERE c.id = a.fk_action";
453 $sql .=
' AND a.entity IN ('.getEntity(
'agenda').
')';
455 if (!empty($actioncode)) {
456 if (empty($conf->global->AGENDA_USE_EVENT_TYPE)) {
457 if ($actioncode ==
'AC_NON_AUTO') {
458 $sql .=
" AND c.type != 'systemauto'";
459 } elseif ($actioncode ==
'AC_ALL_AUTO') {
460 $sql .=
" AND c.type = 'systemauto'";
462 if ($actioncode ==
'AC_OTH') {
463 $sql .=
" AND c.type != 'systemauto'";
465 if ($actioncode ==
'AC_OTH_AUTO') {
466 $sql .=
" AND c.type = 'systemauto'";
470 if ($actioncode ==
'AC_NON_AUTO') {
471 $sql .=
" AND c.type != 'systemauto'";
472 } elseif ($actioncode ==
'AC_ALL_AUTO') {
473 $sql .=
" AND c.type = 'systemauto'";
475 if (is_array($actioncode)) {
476 $sql .=
" AND c.code IN (".$db->sanitize(
"'".implode(
"','", $actioncode).
"'", 1).
")";
478 $sql .=
" AND c.code IN (".$db->sanitize(
"'".implode(
"','", explode(
',', $actioncode)).
"'", 1).
")";
483 if ($resourceid > 0) {
484 $sql .=
" AND r.element_type = 'action' AND r.element_id = a.id AND r.resource_id = ".((int) $resourceid);
487 $sql .=
" AND a.fk_project=".((int) $pid);
489 if (empty($user->rights->societe->client->voir) && !$socid) {
490 $sql .=
" AND (a.fk_soc IS NULL OR sc.fk_user = ".((int) $user->id).
")";
493 $sql .=
" AND s.rowid = ".((int) $socid);
496 if ($filtert > 0 || $usergroup > 0) {
497 $sql .=
" AND ar.fk_actioncomm = a.id AND ar.element_type='user'";
500 $sql .=
" AND c.id = ".((int) $type);
502 if ($search_status ==
'0') {
503 $sql .=
" AND a.percent = 0";
505 if ($search_status ==
'na') {
506 $sql .=
" AND a.percent = -1";
508 if ($search_status ==
'50') {
509 $sql .=
" AND (a.percent > 0 AND a.percent < 100)";
511 if ($search_status ==
'100') {
512 $sql .=
" AND a.percent = 100";
514 if ($search_status ==
'done') {
515 $sql .=
" AND (a.percent = 100)";
517 if ($search_status ==
'todo') {
518 $sql .=
" AND (a.percent >= 0 AND a.percent < 100)";
530 if ($filtert > 0 || $usergroup > 0) {
533 $sql .=
"(ar.fk_element = ".((int) $filtert).
" OR (ar.fk_element IS NULL AND a.fk_user_action = ".((int) $filtert).
"))";
535 if ($usergroup > 0) {
536 $sql .= ($filtert > 0 ?
" OR " :
"").
" ugu.fk_usergroup = ".((
int) $usergroup);
542 if ($dateselect > 0) {
543 $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).
"'))";
545 if ($datestart_dtstart > 0) {
546 $sql .=
" AND a.datep >= '".$db->idate($datestart_dtstart).
"'";
548 if ($datestart_dtend > 0) {
549 $sql .=
" AND a.datep <= '".$db->idate($datestart_dtend).
"'";
551 if ($dateend_dtstart > 0) {
552 $sql .=
" AND a.datep2 >= '".$db->idate($dateend_dtstart).
"'";
554 if ($dateend_dtend > 0) {
555 $sql .=
" AND a.datep2 <= '".$db->idate($dateend_dtend).
"'";
559 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
562 $parameters = array();
563 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object, $action);
564 $sql .= $hookmanager->resPrint;
567 $nbtotalofrecords =
'';
568 if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
579 $sqlforcount = preg_replace(
'/^SELECT[a-zA-Z0-9\._\s\(\),]+FROM/i',
'SELECT COUNT(*) as nbtotalofrecords FROM', $sql);
580 $resql = $db->query($sqlforcount);
581 $objforcount = $db->fetch_object(
$resql);
582 $nbtotalofrecords = $objforcount->nbtotalofrecords;
583 if (($page * $limit) > $nbtotalofrecords) {
591 $sql .= $db->order($sortfield, $sortorder);
593 $sql .= $db->plimit($limit + 1, $offset);
596 $resql = $db->query($sql);
602 $num = $db->num_rows(
$resql);
604 $arrayofselected = is_array($toselect) ? $toselect : array();
607 $newtitle =
'<div class="nowrap clear inline-block minheight30 margintoponly">';
608 $newtitle .=
'<input type="checkbox" id="check_mytasks" name="check_mytasks" checked disabled> '.$langs->trans(
"LocalAgenda").
' ';
609 $newtitle .=
'</div>';
612 $tabactive =
'cardlist';
616 print
'<form method="POST" id="searchFormList" class="listactionsfilter" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
618 if ($optioncss !=
'') {
619 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
621 print
'<input type="hidden" name="token" value="'.newToken().
'">';
622 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
623 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
624 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
625 print
'<input type="hidden" name="type" value="'.$type.
'">';
629 $nav .=
'<input type="hidden" name="search_filter" value="'.$filter.
'">';
632 $nav .=
'<input type="hidden" name="search_showbirthday" value="1">';
644 $parameters = array();
645 $reshook = $hookmanager->executeHooks(
'addCalendarChoice', $parameters, $object, $action);
646 if (empty($reshook)) {
647 $s .= $hookmanager->resPrint;
648 } elseif ($reshook > 1) {
649 $s = $hookmanager->resPrint;
651 $viewyear = is_object($object) ?
dol_print_date($object->datep,
'%Y') :
'';
652 $viewmonth = is_object($object) ?
dol_print_date($object->datep,
'%m') :
'';
653 $viewday = is_object($object) ?
dol_print_date($object->datep,
'%d') :
'';
655 $viewmode .=
'<a class="btnTitle btnTitleSelected reposition" href="'.DOL_URL_ROOT.
'/comm/action/list.php?mode=show_list&restore_lastsearch_values=1'.$paramnoactionodate.
'">';
657 $viewmode .=
img_picto($langs->trans(
"List"),
'object_calendarlist',
'class="imgforviewmode pictoactionview block"');
659 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewList").
'</span></a>';
661 $viewmode .=
'<a class="btnTitle reposition" href="'.DOL_URL_ROOT.
'/comm/action/index.php?mode=show_month&year='.$viewyear.
'&month='.$viewmonth.
'&day='.$viewday.$paramnoactionodate.
'">';
663 $viewmode .=
img_picto($langs->trans(
"ViewCal"),
'object_calendarmonth',
'class="pictoactionview block"');
665 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewCal").
'</span></a>';
667 $viewmode .=
'<a class="btnTitle reposition" href="'.DOL_URL_ROOT.
'/comm/action/index.php?mode=show_week&year='.$viewyear.
'&month='.$viewmonth.
'&day='.$viewday.$paramnoactionodate.
'">';
669 $viewmode .=
img_picto($langs->trans(
"ViewWeek"),
'object_calendarweek',
'class="pictoactionview block"');
671 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewWeek").
'</span></a>';
673 $viewmode .=
'<a class="btnTitle reposition" href="'.DOL_URL_ROOT.
'/comm/action/index.php?mode=show_day&year='.$viewyear.
'&month='.$viewmonth.
'&day='.$viewday.$paramnoactionodate.
'">';
675 $viewmode .=
img_picto($langs->trans(
"ViewDay"),
'object_calendarday',
'class="pictoactionview block"');
677 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewDay").
'</span></a>';
679 $viewmode .=
'<a class="btnTitle reposition marginrightonly" href="'.DOL_URL_ROOT.
'/comm/action/peruser.php?mode=show_peruser&year='.$viewyear.
'&month='.$viewmonth.
'&day='.$viewday.$paramnoactionodate.
'">';
681 $viewmode .=
img_picto($langs->trans(
"ViewPerUser"),
'object_calendarperuser',
'class="pictoactionview block"');
683 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewPerUser").
'</span></a>';
685 $viewmode .=
'<span class="marginrightonly"></span>';
688 $parameters = array();
689 $reshook = $hookmanager->executeHooks(
'addCalendarView', $parameters, $object, $action);
690 if (empty($reshook)) {
691 $viewmode .= $hookmanager->resPrint;
692 } elseif ($reshook > 1) {
693 $viewmode = $hookmanager->resPrint;
698 $newparam =
'&month='.str_pad($month, 2,
"0", STR_PAD_LEFT).
'&year='.$tmpforcreatebutton[
'year'];
703 $url = DOL_URL_ROOT.
'/comm/action/card.php?action=create';
704 $url .=
'&datep='.sprintf(
"%04d%02d%02d", $tmpforcreatebutton[
'year'], $tmpforcreatebutton[
'mon'], $tmpforcreatebutton[
'mday']).$hourminsec;
705 $url .=
'&backtopage='.urlencode($_SERVER[
"PHP_SELF"].($newparam ?
'?'.$newparam :
''));
707 $newcardbutton =
dolGetButtonTitle($langs->trans(
'AddAction'),
'',
'fa fa-plus-circle', $url,
'', $user->rights->agenda->myactions->create || $user->rights->agenda->allactions->create);
709 $param .=
'&mode='.$mode;
711 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);
716 include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
720 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
721 $selectedfields =
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage);
722 if ($massactionbutton) {
723 $selectedfields .=
$form->showCheckAddButtons(
'checkforselect', 1);
727 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
728 print_actions_filter(
$form, $canedit, $search_status, $year, $month, $day, $showbirthday, 0, $filtert, 0, $pid, $socid, $action, -1, $actioncode, $usergroup,
'', $resourceid);
731 print
'<div class="div-table-responsive">';
732 print
'<table class="tagtable liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
734 print
'<tr class="liste_titre_filter">';
735 if (!empty($arrayfields[
'a.id'][
'checked'])) {
736 print
'<td class="liste_titre"><input type="text" class="maxwidth50" name="search_id" value="'.$search_id.
'"></td>';
738 if (!empty($arrayfields[
'owner'][
'checked'])) {
739 print
'<td class="liste_titre"></td>';
741 if (!empty($arrayfields[
'c.libelle'][
'checked'])) {
742 print
'<td class="liste_titre"></td>';
744 if (!empty($arrayfields[
'a.label'][
'checked'])) {
745 print
'<td class="liste_titre"><input type="text" class="maxwidth75" name="search_title" value="'.$search_title.
'"></td>';
747 if (!empty($arrayfields[
'a.note'][
'checked'])) {
748 print
'<td class="liste_titre"><input type="text" class="maxwidth75" name="search_note" value="'.$search_note.
'"></td>';
750 if (!empty($arrayfields[
'a.datep'][
'checked'])) {
751 print
'<td class="liste_titre nowraponall" align="center">';
752 print
'<div class="nowrap">';
753 print
$form->selectDate($datestart_dtstart,
'datestart_dtstart', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'),
'tzuserrel');
755 print
'<div class="nowrap">';
756 print
$form->selectDate($datestart_dtend,
'datestart_dtend', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'To'),
'tzuserrel');
760 if (!empty($arrayfields[
'a.datep2'][
'checked'])) {
761 print
'<td class="liste_titre nowraponall" align="center">';
762 print
'<div class="nowrap">';
763 print
$form->selectDate($dateend_dtstart,
'dateend_dtstart', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'),
'tzuserrel');
765 print
'<div class="nowrap">';
766 print
$form->selectDate($dateend_dtend,
'dateend_dtend', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'To'),
'tzuserrel');
770 if (!empty($arrayfields[
's.nom'][
'checked'])) {
771 print
'<td class="liste_titre"></td>';
773 if (!empty($arrayfields[
'a.fk_contact'][
'checked'])) {
774 print
'<td class="liste_titre"></td>';
776 if (!empty($arrayfields[
'a.fk_element'][
'checked'])) {
777 print
'<td class="liste_titre"></td>';
781 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
784 $parameters = array(
'arrayfields'=>$arrayfields);
785 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters);
786 print $hookmanager->resPrint;
788 if (!empty($arrayfields[
'a.datec'][
'checked'])) {
789 print
'<td class="liste_titre"></td>';
791 if (!empty($arrayfields[
'a.tms'][
'checked'])) {
792 print
'<td class="liste_titre"></td>';
794 if (!empty($arrayfields[
'a.percent'][
'checked'])) {
795 print
'<td class="liste_titre center">';
796 $formactions->form_select_status_action(
'formaction', $search_status, 1,
'search_status', 1, 2,
'minwidth100imp maxwidth125');
801 print
'<td class="liste_titre" align="middle">';
802 $searchpicto =
$form->showFilterButtons();
807 $totalarray = array();
808 $totalarray[
'nbfield'] = 0;
812 print
'<tr class="liste_titre">';
813 if (!empty($arrayfields[
'a.id'][
'checked'])) {
814 print_liste_field_titre($arrayfields[
'a.id'][
'label'], $_SERVER[
"PHP_SELF"],
"a.id", $param,
"",
"", $sortfield, $sortorder);
815 $totalarray[
'nbfield']++;
817 if (!empty($arrayfields[
'owner'][
'checked'])) {
818 print_liste_field_titre($arrayfields[
'owner'][
'label'], $_SERVER[
"PHP_SELF"],
"", $param,
"",
"", $sortfield, $sortorder);
819 $totalarray[
'nbfield']++;
821 if (!empty($arrayfields[
'c.libelle'][
'checked'])) {
822 print_liste_field_titre($arrayfields[
'c.libelle'][
'label'], $_SERVER[
"PHP_SELF"],
"c.libelle", $param,
"",
"", $sortfield, $sortorder);
823 $totalarray[
'nbfield']++;
825 if (!empty($arrayfields[
'a.label'][
'checked'])) {
826 print_liste_field_titre($arrayfields[
'a.label'][
'label'], $_SERVER[
"PHP_SELF"],
"a.label", $param,
"",
"", $sortfield, $sortorder);
827 $totalarray[
'nbfield']++;
829 if (!empty($arrayfields[
'a.note'][
'checked'])) {
830 print_liste_field_titre($arrayfields[
'a.note'][
'label'], $_SERVER[
"PHP_SELF"],
"a.note", $param,
"",
"", $sortfield, $sortorder);
831 $totalarray[
'nbfield']++;
834 if (!empty($arrayfields[
'a.datep'][
'checked'])) {
835 print_liste_field_titre($arrayfields[
'a.datep'][
'label'], $_SERVER[
"PHP_SELF"],
"a.datep,a.id", $param,
'',
'align="center"', $sortfield, $sortorder);
836 $totalarray[
'nbfield']++;
838 if (!empty($arrayfields[
'a.datep2'][
'checked'])) {
839 print_liste_field_titre($arrayfields[
'a.datep2'][
'label'], $_SERVER[
"PHP_SELF"],
"a.datep2", $param,
'',
'align="center"', $sortfield, $sortorder);
840 $totalarray[
'nbfield']++;
842 if (!empty($arrayfields[
's.nom'][
'checked'])) {
843 print_liste_field_titre($arrayfields[
's.nom'][
'label'], $_SERVER[
"PHP_SELF"],
"s.nom", $param,
"",
"", $sortfield, $sortorder);
844 $totalarray[
'nbfield']++;
846 if (!empty($arrayfields[
'a.fk_contact'][
'checked'])) {
847 print_liste_field_titre($arrayfields[
'a.fk_contact'][
'label'], $_SERVER[
"PHP_SELF"],
"", $param,
"",
"", $sortfield, $sortorder);
848 $totalarray[
'nbfield']++;
850 if (!empty($arrayfields[
'a.fk_element'][
'checked'])) {
851 print_liste_field_titre($arrayfields[
'a.fk_element'][
'label'], $_SERVER[
"PHP_SELF"],
"", $param,
"",
"", $sortfield, $sortorder);
852 $totalarray[
'nbfield']++;
855 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
857 $parameters = array(
'arrayfields'=>$arrayfields,
'param'=>$param,
'sortfield'=>$sortfield,
'sortorder'=>$sortorder);
858 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters);
859 print $hookmanager->resPrint;
861 if (!empty($arrayfields[
'a.datec'][
'checked'])) {
862 print_liste_field_titre($arrayfields[
'a.datec'][
'label'], $_SERVER[
"PHP_SELF"],
"a.datec,a.id", $param,
"",
'align="center"', $sortfield, $sortorder);
863 $totalarray[
'nbfield']++;
865 if (!empty($arrayfields[
'a.tms'][
'checked'])) {
866 print_liste_field_titre($arrayfields[
'a.tms'][
'label'], $_SERVER[
"PHP_SELF"],
"a.tms,a.id", $param,
"",
'align="center"', $sortfield, $sortorder);
867 $totalarray[
'nbfield']++;
870 if (!empty($arrayfields[
'a.percent'][
'checked'])) {
871 print_liste_field_titre(
"Status", $_SERVER[
"PHP_SELF"],
"a.percent", $param,
"",
'align="center"', $sortfield, $sortorder);
872 $totalarray[
'nbfield']++;
874 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'',
'',
'align="center"', $sortfield, $sortorder,
'maxwidthsearch ');
875 $totalarray[
'nbfield']++;
879 $delay_warning = $conf->global->MAIN_DELAY_ACTIONS_TODO * 24 * 60 * 60;
881 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/cactioncomm.class.php';
883 $arraylist = $caction->liste_array(1,
'code',
'', (empty($conf->global->AGENDA_USE_EVENT_TYPE) ? 1 : 0),
'', 1);
884 $contactListCache = array();
891 $imaxinloop = ($limit ? min($num, $limit) : $num);
892 while ($i < $imaxinloop) {
893 $obj = $db->fetch_object(
$resql);
899 $object->setVarsFromFetchObj($obj);
902 if (!empty($conf->global->AGENDA_ALWAYS_HIDE_AUTO) && $obj->type_code ==
'AC_OTH_AUTO') {
907 $actionstatic->id = $obj->id;
908 $actionstatic->ref = $obj->id;
909 $actionstatic->code = $obj->code;
910 $actionstatic->type_code = $obj->type_code;
911 $actionstatic->type_label = $obj->type_label;
912 $actionstatic->type_picto = $obj->type_picto;
913 $actionstatic->type_color = $obj->type_color;
914 $actionstatic->label = $obj->label;
915 $actionstatic->location = $obj->location;
917 $actionstatic->datep = $db->jdate($obj->dp);
918 $actionstatic->percentage = $obj->percent;
919 $actionstatic->authorid = $obj->fk_user_author;
920 $actionstatic->userownerid = $obj->fk_user_action;
924 if (!empty($arrayfields[
'a.fk_contact'][
'checked'])) {
925 $actionstatic->fetchResources();
928 print
'<tr class="oddeven">';
931 if (!empty($arrayfields[
'a.id'][
'checked'])) {
932 print
'<td class="nowraponall">';
933 print $actionstatic->getNomUrl(1, -1);
938 if (!empty($arrayfields[
'owner'][
'checked'])) {
939 print
'<td class="tdoverflowmax150">';
940 if ($obj->fk_user_action > 0) {
941 $userstatic->fetch($obj->fk_user_action);
942 print $userstatic->getNomUrl(-1);
950 if (!empty($arrayfields[
'c.libelle'][
'checked'])) {
951 print
'<td class="nowraponall">';
952 print $actionstatic->getTypePicto();
953 $labeltype = $obj->type_code;
954 if (empty($conf->global->AGENDA_USE_EVENT_TYPE) && empty($arraylist[$labeltype])) {
955 $labeltype =
'AC_OTH';
957 if ($actionstatic->type_code ==
'AC_OTH' && $actionstatic->code ==
'TICKET_MSG') {
958 $labeltype = $langs->trans(
"Message");
960 if (!empty($arraylist[$labeltype])) {
961 $labeltype = $arraylist[$labeltype];
963 if ($obj->type_code ==
'AC_OTH_AUTO' && ($obj->type_code != $obj->code) && $labeltype && !empty($arraylist[$obj->code])) {
964 $labeltype .=
' - '.$arraylist[$obj->code];
972 if (!empty($arrayfields[
'a.label'][
'checked'])) {
973 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($actionstatic->label).
'">';
974 print $actionstatic->label;
979 if (!empty($arrayfields[
'a.note'][
'checked'])) {
980 print
'<td class="tdoverflowonsmartphone">';
982 print
$form->textwithtooltip(
dol_trunc($text, 48), $actionstatic->note_private);
986 $formatToUse = $obj->fulldayevent ?
'day' :
'dayhour';
989 if (!empty($arrayfields[
'a.datep'][
'checked'])) {
990 print
'<td class="center nowraponall">';
991 if (empty($obj->fulldayevent)) {
992 print
dol_print_date($db->jdate($obj->dp), $formatToUse,
'tzuserrel');
995 print
dol_print_date($db->jdate($obj->dp), $formatToUse, ($tzforfullday ? $tzforfullday :
'tzuserrel'));
998 if ($actionstatic->hasDelay() && $actionstatic->percentage >= 0 && $actionstatic->percentage < 100 ) {
1008 if (!empty($arrayfields[
'a.datep2'][
'checked'])) {
1009 print
'<td class="center nowraponall">';
1010 if (empty($obj->fulldayevent)) {
1011 print
dol_print_date($db->jdate($obj->dp2), $formatToUse,
'tzuserrel');
1014 print
dol_print_date($db->jdate($obj->dp2), $formatToUse, ($tzforfullday ? $tzforfullday :
'tzuserrel'));
1020 if (!empty($arrayfields[
's.nom'][
'checked'])) {
1021 print
'<td class="tdoverflowmax150">';
1022 if ($obj->socid > 0) {
1023 $societestatic->id = $obj->socid;
1024 $societestatic->client = $obj->client;
1025 $societestatic->name = $obj->societe;
1026 $societestatic->email = $obj->socemail;
1028 print $societestatic->getNomUrl(1,
'', 28);
1036 if (!empty($arrayfields[
'a.fk_contact'][
'checked'])) {
1037 print
'<td class="tdoverflowmax100">';
1039 if (!empty($actionstatic->socpeopleassigned)) {
1040 $contactList = array();
1041 foreach ($actionstatic->socpeopleassigned as $socpeopleassigned) {
1042 if (!isset($contactListCache[$socpeopleassigned[
'id']])) {
1045 if ($contact->fetch($socpeopleassigned[
'id']) > 0) {
1046 $contactListCache[$socpeopleassigned[
'id']] = $contact->getNomUrl(1,
'', 0);
1047 $contactList[] = $contact->getNomUrl(1,
'', 0);
1051 $contactList[] = $contactListCache[$socpeopleassigned[
'id']];
1054 if (!empty($contactList)) {
1055 print implode(
', ', $contactList);
1057 } elseif ($obj->fk_contact > 0) {
1058 $contactstatic->id = $obj->fk_contact;
1059 $contactstatic->email = $obj->email;
1060 $contactstatic->lastname = $obj->lastname;
1061 $contactstatic->firstname = $obj->firstname;
1062 $contactstatic->phone_pro = $obj->phone_pro;
1063 $contactstatic->phone_mobile = $obj->phone_mobile;
1064 $contactstatic->phone_perso = $obj->phone_perso;
1065 $contactstatic->country_id = $obj->country_id;
1066 print $contactstatic->getNomUrl(1,
'', 0);
1074 if (!empty($arrayfields[
'a.fk_element'][
'checked'])) {
1075 print
'<td class="tdoverflowmax150">';
1077 if ($obj->fk_element > 0 && !empty($obj->elementtype)) {
1078 include_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
1087 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1089 $parameters = array(
'arrayfields'=>$arrayfields,
'obj'=>$obj,
'i'=>$i,
'totalarray'=>&$totalarray);
1090 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters);
1091 print $hookmanager->resPrint;
1094 if (!empty($arrayfields[
'a.datec'][
'checked'])) {
1096 print
'<td align="center" class="nowrap">'.dol_print_date($db->jdate($obj->datec),
'dayhour',
'tzuserrel').
'</td>';
1099 if (!empty($arrayfields[
'a.tms'][
'checked'])) {
1100 print
'<td align="center" class="nowrap">'.dol_print_date($db->jdate($obj->datem),
'dayhour',
'tzuserrel').
'</td>';
1102 if (!empty($arrayfields[
'a.percent'][
'checked'])) {
1104 $datep = $db->jdate($obj->dp);
1105 print
'<td align="center" class="nowrap">'.$actionstatic->LibStatut($obj->percent, 5, 0, $datep).
'</td>';
1108 print
'<td class="nowrap center">';
1109 if ($massactionbutton || $massaction) {
1111 if (in_array($obj->id, $arrayofselected)) {
1114 print
'<input id="cb'.$obj->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
1124 print
'<tr><td colspan="'.$totalarray[
'nbfield'].
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
1128 print
'</table>'.
"\n";
1129 print
'</div>'.
"\n";
1131 print
'</form>'.
"\n";