31 require
'../../main.inc.php';
32 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
33 require_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
34 require_once DOL_DOCUMENT_ROOT.
'/contact/class/contact.class.php';
35 require_once DOL_DOCUMENT_ROOT.
'/user/class/usergroup.class.php';
36 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
37 require_once DOL_DOCUMENT_ROOT.
'/core/lib/agenda.lib.php';
38 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formprojet.class.php';
39 require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
42 if (!isset($conf->global->AGENDA_MAX_EVENTS_DAY_VIEW)) {
43 $conf->global->AGENDA_MAX_EVENTS_DAY_VIEW = 3;
46 $action =
GETPOST(
'action',
'aZ09');
48 $disabledefaultvalues =
GETPOST(
'disabledefaultvalues',
'int');
50 $filter =
GETPOST(
"search_filter",
'alpha', 3) ?
GETPOST(
"search_filter",
'alpha', 3) :
GETPOST(
"filter",
'alpha', 3);
51 $filtert =
GETPOST(
"search_filtert",
"int", 3) ?
GETPOST(
"search_filtert",
"int", 3) :
GETPOST(
"filtert",
"int", 3);
52 $usergroup =
GETPOST(
"search_usergroup",
"int", 3) ?
GETPOST(
"search_usergroup",
"int", 3) :
GETPOST(
"usergroup",
"int", 3);
63 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
64 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
66 if (empty($page) || $page == -1) {
69 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
70 $offset = $limit * $page;
75 $sortfield =
"a.datec";
80 $socid = $user->socid;
87 if (empty($user->rights->agenda->myactions->read)) {
90 if (empty($user->rights->agenda->allactions->read)) {
93 if (empty($user->rights->agenda->allactions->read) || $filter ==
'mine') {
97 $mode =
'show_peruser';
98 $resourceid =
GETPOST(
"search_resourceid",
"int") ?
GETPOST(
"search_resourceid",
"int") :
GETPOST(
"resourceid",
"int");
99 $year =
GETPOST(
"year",
"int") ?
GETPOST(
"year",
"int") : date(
"Y");
100 $month =
GETPOST(
"month",
"int") ?
GETPOST(
"month",
"int") : date(
"m");
101 $week =
GETPOST(
"week",
"int") ?
GETPOST(
"week",
"int") : date(
"W");
106 $maxprint = ((
GETPOST(
"maxprint",
'int') !=
'') ?
GETPOST(
"maxprint",
'int') : $conf->global->AGENDA_MAX_EVENTS_DAY_VIEW);
107 $optioncss =
GETPOST(
'optioncss',
'aZ');
109 if (
GETPOST(
'search_actioncode',
'array:aZ09')) {
110 $actioncode =
GETPOST(
'search_actioncode',
'array:aZ09', 3);
111 if (!count($actioncode)) {
115 $actioncode =
GETPOST(
"search_actioncode",
"alpha", 3) ?
GETPOST(
"search_actioncode",
"alpha", 3) : (
GETPOST(
"search_actioncode",
"alpha") ==
'0' ?
'0' : ((empty($conf->global->AGENDA_DEFAULT_FILTER_TYPE) || $disabledefaultvalues) ?
'' : $conf->global->AGENDA_DEFAULT_FILTER_TYPE));
119 if ($dateselect > 0) {
120 $day =
GETPOST(
'dateselectday',
'int');
121 $month =
GETPOST(
'dateselectmonth',
'int');
122 $year =
GETPOST(
'dateselectyear',
'int');
125 $tmp = empty($conf->global->MAIN_DEFAULT_WORKING_HOURS) ?
'9-18' : $conf->global->MAIN_DEFAULT_WORKING_HOURS;
126 $tmp = str_replace(
' ',
'', $tmp);
127 $tmparray = explode(
'-', $tmp);
128 $begin_h =
GETPOST(
'begin_h',
'int') !=
'' ?
GETPOST(
'begin_h',
'int') : ($tmparray[0] !=
'' ? $tmparray[0] : 9);
129 $end_h =
GETPOST(
'end_h',
'int') ?
GETPOST(
'end_h',
'int') : ($tmparray[1] !=
'' ? $tmparray[1] : 18);
130 if ($begin_h < 0 || $begin_h > 23) {
133 if ($end_h < 1 || $end_h > 24) {
136 if ($end_h <= $begin_h) {
137 $end_h = $begin_h + 1;
140 $tmp = empty($conf->global->MAIN_DEFAULT_WORKING_DAYS) ?
'1-5' : $conf->global->MAIN_DEFAULT_WORKING_DAYS;
141 $tmp = str_replace(
' ',
'', $tmp);
142 $tmparray = explode(
'-', $tmp);
143 $begin_d =
GETPOST(
'begin_d',
'int') ?
GETPOST(
'begin_d',
'int') : ($tmparray[0] !=
'' ? $tmparray[0] : 1);
144 $end_d =
GETPOST(
'end_d',
'int') ?
GETPOST(
'end_d',
'int') : ($tmparray[1] !=
'' ? $tmparray[1] : 5);
145 if ($begin_d < 1 || $begin_d > 7) {
148 if ($end_d < 1 || $end_d > 7) {
151 if ($end_d < $begin_d) {
152 $end_d = $begin_d + 1;
156 $status = ((empty($conf->global->AGENDA_DEFAULT_FILTER_STATUS) || $disabledefaultvalues) ?
'' : $conf->global->AGENDA_DEFAULT_FILTER_STATUS);
160 $mode = (empty($conf->global->AGENDA_DEFAULT_VIEW) ?
'show_month' : $conf->global->AGENDA_DEFAULT_VIEW);
163 if (
GETPOST(
'viewcal',
'alpha') && $mode !=
'show_day' && $mode !=
'show_week' && $mode !=
'show_peruser') {
164 $mode =
'show_month'; $day =
'';
166 if (
GETPOST(
'viewweek',
'alpha') || $mode ==
'show_week') {
167 $mode =
'show_week'; $week = ($week ? $week : date(
"W")); $day = ($day ? $day : date(
"d"));
169 if (
GETPOST(
'viewday',
'alpha') || $mode ==
'show_day') {
170 $mode =
'show_day'; $day = ($day ? $day : date(
"d"));
176 $langs->loadLangs(array(
'users',
'agenda',
'other',
'commercial'));
179 $hookmanager->initHooks(array(
'agenda'));
182 if ($user->socid && $socid) {
186 $search_status = $status;
217 'maxprint' => $maxprint,
219 'filtert' => $filtert,
220 'showbirthday' => $showbirthday,
221 'canedit' => $canedit,
222 'optioncss' => $optioncss,
223 'actioncode' => $actioncode,
225 'resourceid' => $resourceid,
226 'usergroup' => $usergroup,
228 $reshook = $hookmanager->executeHooks(
'beforeAgendaPerUser', $parameters, $object, $action);
234 $companystatic =
new Societe($db);
236 $help_url =
'EN:Module_Agenda_En|FR:Module_Agenda|ES:Módulo_Agenda';
241 $nowyear = $nowarray[
'year'];
242 $nowmonth = $nowarray[
'mon'];
243 $nowday = $nowarray[
'mday'];
247 $listofextcals = array();
250 $first_day = $prev[
'first_day'];
251 $first_month = $prev[
'first_month'];
252 $first_year = $prev[
'first_year'];
254 $week = $prev[
'week'];
258 $next_year = $next[
'year'];
259 $next_month = $next[
'month'];
260 $next_day = $next[
'day'];
262 $max_day_in_month = date(
"t",
dol_mktime(0, 0, 0, $month, 1, $year));
264 $tmpday = $first_day;
268 $title = $langs->trans(
"DoneAndToDoActions");
269 if ($status ==
'done') {
270 $title = $langs->trans(
"DoneActions");
272 if ($status ==
'todo') {
273 $title = $langs->trans(
"ToDoActions");
278 if (is_array($actioncode)) {
279 foreach ($actioncode as $str_action) {
280 $param .=
"&search_actioncode[]=".urlencode($str_action);
283 $param .=
"&search_actioncode=".urlencode($actioncode);
286 if ($resourceid > 0) {
287 $param .=
"&search_resourceid=".urlencode($resourceid);
291 $param .=
"&search_status=".urlencode($status);
294 $param .=
"&search_filter=".urlencode($filter);
297 $param .=
"&search_filtert=".urlencode($filtert);
299 if ($usergroup > 0) {
300 $param .=
"&search_usergroup=".urlencode($usergroup);
303 $param .=
"&search_socid=".urlencode($socid);
306 $param .=
"&search_showbirthday=1";
309 $param .=
"&search_projectid=".urlencode($pid);
312 $param .=
"&search_type=".urlencode($type);
314 if ($mode !=
'show_peruser') {
315 $param .=
'&mode='.urlencode($mode);
317 if ($begin_h !=
'') {
318 $param .=
'&begin_h='.urlencode($begin_h);
321 $param .=
'&end_h='.urlencode($end_h);
323 if ($begin_d !=
'') {
324 $param .=
'&begin_d='.urlencode($begin_d);
327 $param .=
'&end_d='.urlencode($end_d);
329 $param .=
"&maxprint=".urlencode($maxprint);
331 $paramnoactionodate = $param;
336 $prev_year = $prev[
'prev_year'];
337 $prev_month = $prev[
'prev_month'];
338 $prev_day = $prev[
'prev_day'];
339 $first_day = $prev[
'first_day'];
340 $first_month = $prev[
'first_month'];
341 $first_year = $prev[
'first_year'];
343 $week = $prev[
'week'];
347 $next_year = $next[
'year'];
348 $next_month = $next[
'month'];
349 $next_day = $next[
'day'];
352 $firstdaytoshow =
dol_mktime(0, 0, 0, $first_month, $first_day, $first_year,
'gmt');
354 $nb_weeks_to_show = (!empty($conf->global->AGENDA_NB_WEEKS_IN_VIEW_PER_USER)) ? ((
int) $conf->global->AGENDA_NB_WEEKS_IN_VIEW_PER_USER * 7) : 7;
360 $max_day_in_month = date(
"t",
dol_mktime(0, 0, 0, $month, 1, $year,
'gmt'));
362 $tmpday = $first_day;
363 $picto =
'calendarweek';
365 $nav =
"<a href=\"?year=".$prev_year.
"&month=".$prev_month.
"&day=".$prev_day.$param.
"\"><i class=\"fa fa-chevron-left\" title=\"".
dol_escape_htmltag($langs->trans(
"Previous")).
"\"></i></a> \n";
366 $nav .=
" <span id=\"month_name\">".dol_print_date(
dol_mktime(0, 0, 0, $first_month, $first_day, $first_year),
"%Y").
", ".$langs->trans(
"Week").
" ".$week;
367 $nav .=
" </span>\n";
368 $nav .=
" <a href=\"?year=".$next_year.
"&month=".$next_month.
"&day=".$next_day.$param.
"\"><i class=\"fa fa-chevron-right\" title=\"".
dol_escape_htmltag($langs->trans(
"Next")).
"\"></i></a>\n";
369 if (empty($conf->dol_optimize_smallscreen)) {
370 $nav .=
" <a href=\"?year=".$nowyear.
"&month=".$nowmonth.
"&day=".$nowday.$param.
"\">".$langs->trans(
"Today").
"</a> ";
372 $nav .=
$form->selectDate($dateselect,
'dateselect', 0, 0, 1,
'', 1, 0);
373 $nav .=
' <button type="submit" class="liste_titre button_search" name="button_search_x" value="x"><span class="fa fa-search"></span></button>';
376 $param .=
'&year='.urlencode($year).
'&month='.urlencode($month).($day ?
'&day='.urlencode($day) :
'');
380 $paramnoaction = preg_replace(
'/action=[a-z_]+/',
'', $param);
384 print
'<form method="POST" id="searchFormList" class="listactionsfilter" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
386 $showextcals = $listofextcals;
388 if ($conf->use_javascript_ajax) {
390 $s .=
'<script type="text/javascript">'.
"\n";
391 $s .=
'jQuery(document).ready(function () {'.
"\n";
392 $s .=
'jQuery("#check_mytasks").click(function() { jQuery(".family_mytasks").toggle(); jQuery(".family_other").toggle(); });'.
"\n";
393 $s .=
'jQuery("#check_birthday").click(function() { jQuery(".family_birthday").toggle(); });'.
"\n";
394 $s .=
'jQuery(".family_birthday").toggle();'.
"\n";
395 if ($mode ==
"show_week" || $mode ==
"show_month" || empty($mode)) {
396 $s .=
'jQuery( "td.sortable" ).sortable({connectWith: ".sortable",placeholder: "ui-state-highlight",items: "div:not(.unsortable)", receive: function( event, ui ) {';
399 $s .=
'</script>'.
"\n";
400 if (!empty($conf->use_javascript_ajax)) {
401 $s .=
'<div class="nowrap clear float"><input type="checkbox" id="check_mytasks" name="check_mytasks" checked disabled> '.$langs->trans(
"LocalAgenda").
' </div>';
402 if (is_array($showextcals) && count($showextcals) > 0) {
403 foreach ($showextcals as $val) {
404 $htmlname = md5($val[
'name']);
405 $s .=
'<script type="text/javascript">'.
"\n";
406 $s .=
'jQuery(document).ready(function () {'.
"\n";
407 $s .=
' jQuery("#check_ext'.$htmlname.
'").click(function() {';
408 $s .=
' /* alert("'.$htmlname.
'"); */';
409 $s .=
' jQuery(".family_ext'.$htmlname.
'").toggle();';
412 $s .=
'</script>'.
"\n";
413 $s .=
'<div class="nowrap float"><input type="checkbox" id="check_ext'.$htmlname.
'" name="check_ext'.$htmlname.
'" checked> '.$val [
'name'].
' </div>';
420 $parameters = array();
421 $reshook = $hookmanager->executeHooks(
'addCalendarChoice', $parameters, $object, $action);
422 if (empty($reshook)) {
423 $s .= $hookmanager->resPrint;
424 } elseif ($reshook > 1) {
425 $s = $hookmanager->resPrint;
430 $massactionbutton =
'';
433 $viewmode .=
'<a class="btnTitle reposition" href="'.DOL_URL_ROOT.
'/comm/action/list.php?mode=show_list&restore_lastsearch_values=1'.$paramnoactionodate.
'">';
435 $viewmode .=
img_picto($langs->trans(
"List"),
'object_calendarlist',
'class="imgforviewmode pictoactionview block"');
437 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewList").
'</span></a>';
439 $viewmode .=
'<a class="btnTitle reposition" href="'.DOL_URL_ROOT.
'/comm/action/index.php?mode=show_month&year='.
dol_print_date($object->datep,
'%Y').
'&month='.
dol_print_date($object->datep,
'%m').
'&day='.
dol_print_date($object->datep,
'%d').$paramnoactionodate.
'">';
441 $viewmode .=
img_picto($langs->trans(
"ViewCal"),
'object_calendarmonth',
'class="pictoactionview block"');
443 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewCal").
'</span></a>';
445 $viewmode .=
'<a class="btnTitle reposition" href="'.DOL_URL_ROOT.
'/comm/action/index.php?mode=show_week&year='.
dol_print_date($object->datep,
'%Y').
'&month='.
dol_print_date($object->datep,
'%m').
'&day='.
dol_print_date($object->datep,
'%d').$paramnoactionodate.
'">';
447 $viewmode .=
img_picto($langs->trans(
"ViewWeek"),
'object_calendarweek',
'class="pictoactionview block"');
449 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewWeek").
'</span></a>';
451 $viewmode .=
'<a class="btnTitle reposition" href="'.DOL_URL_ROOT.
'/comm/action/index.php?mode=show_day&year='.
dol_print_date($object->datep,
'%Y').
'&month='.
dol_print_date($object->datep,
'%m').
'&day='.
dol_print_date($object->datep,
'%d').$paramnoactionodate.
'">';
453 $viewmode .=
img_picto($langs->trans(
"ViewDay"),
'object_calendarday',
'class="pictoactionview block"');
455 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewDay").
'</span></a>';
457 $viewmode .=
'<a class="btnTitle btnTitleSelected reposition marginrightonly" href="'.DOL_URL_ROOT.
'/comm/action/peruser.php?mode=show_peruser&year='.
dol_print_date($object->datep,
'%Y').
'&month='.
dol_print_date($object->datep,
'%m').
'&day='.
dol_print_date($object->datep,
'%d').$paramnoactionodate.
'">';
459 $viewmode .=
img_picto($langs->trans(
"ViewPerUser"),
'object_calendarperuser',
'class="pictoactionview block"');
461 $viewmode .=
'<span class="valignmiddle text-plus-circle btnTitle-label hideonsmartphone">'.$langs->trans(
"ViewPerUser").
'</span></a>';
463 $viewmode .=
'<span class="marginrightonly"></span>';
466 $parameters = array(); $object =
null;
467 $reshook = $hookmanager->executeHooks(
'addCalendarView', $parameters, $object, $action);
468 if (empty($reshook)) {
469 $viewmode .= $hookmanager->resPrint;
470 } elseif ($reshook > 1) {
471 $viewmode = $hookmanager->resPrint;
477 if ($user->rights->agenda->myactions->create || $user->rights->agenda->allactions->create) {
480 $newparam .=
'&month='.urlencode(str_pad($month, 2,
"0", STR_PAD_LEFT)).
'&year='.urlencode($tmpforcreatebutton[
'year']);
481 if ($begin_h !==
'') {
482 $newparam .=
'&begin_h='.urlencode($begin_h);
485 $newparam .=
'&end_h='.urlencode($end_h);
487 if ($begin_d !==
'') {
488 $newparam .=
'&begin_d='.urlencode($begin_d);
491 $newparam .=
'&end_d='.urlencode($end_d);
495 $hourminsec =
'100000';
496 $newcardbutton .=
dolGetButtonTitle($langs->trans(
"AddAction"),
'',
'fa fa-plus-circle', DOL_URL_ROOT.
'/comm/action/card.php?action=create&datep='.sprintf(
"%04d%02d%02d", $tmpforcreatebutton[
'year'], $tmpforcreatebutton[
'mon'], $tmpforcreatebutton[
'mday']).$hourminsec.
'&backtopage='.urlencode($_SERVER[
"PHP_SELF"].($newparam ?
'?'.$newparam :
'')));
501 print_barre_liste($langs->trans(
"Agenda"), $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, -1,
'object_action', 0, $nav.
'<span class="marginleftonly"></span>'.$newcardbutton,
'', $limit, 1, 0, 1, $viewmode);
507 $newtitle =
'<div class="nowrap clear inline-block minheight30">';
508 $newtitle .=
'<input type="checkbox" id="check_mytasks" name="check_mytasks" checked disabled> '.$langs->trans(
"LocalAgenda").
' ';
509 $newtitle .=
'</div>';
516 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
517 print_actions_filter(
$form, $canedit, $search_status, $year, $month, $day, $showbirthday, 0, $filtert, 0, $pid, $socid, $action, -1, $actioncode, $usergroup,
'', $resourceid);
522 $eventarray = array();
527 if ($usergroup > 0) {
530 $sql .=
' a.id, a.label,';
532 $sql .=
' a.datep2,';
533 $sql .=
' a.percent,';
534 $sql .=
' a.fk_user_author,a.fk_user_action,';
535 $sql .=
' a.transparency, a.priority, a.fulldayevent, a.location,';
536 $sql .=
' a.fk_soc, a.fk_contact, a.fk_element, a.elementtype, a.fk_project,';
537 $sql .=
' ca.code, ca.libelle as type_label, ca.color, ca.type as type_type, ca.picto as type_picto';
538 $sql .=
' FROM '.MAIN_DB_PREFIX.
'c_actioncomm as ca, '.MAIN_DB_PREFIX.
"actioncomm as a";
539 if (empty($user->rights->societe->client->voir) && !$socid) {
540 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON a.fk_soc = sc.fk_soc";
543 if ($resourceid > 0) {
544 $sql .=
", ".MAIN_DB_PREFIX.
"element_resources as r";
547 if ($filtert > 0 || $usergroup > 0) {
548 $sql .=
", ".MAIN_DB_PREFIX.
"actioncomm_resources as ar";
550 if ($usergroup > 0) {
551 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"usergroup_user as ugu ON ugu.fk_user = ar.fk_element";
553 $sql .=
' WHERE a.fk_action = ca.id';
554 $sql .=
' AND a.entity IN ('.getEntity(
'agenda').
')';
556 if (!empty($actioncode)) {
557 if (empty($conf->global->AGENDA_USE_EVENT_TYPE)) {
558 if ($actioncode ==
'AC_NON_AUTO') {
559 $sql .=
" AND ca.type != 'systemauto'";
560 } elseif ($actioncode ==
'AC_ALL_AUTO') {
561 $sql .=
" AND ca.type = 'systemauto'";
563 if ($actioncode ==
'AC_OTH') {
564 $sql .=
" AND ca.type != 'systemauto'";
566 if ($actioncode ==
'AC_OTH_AUTO') {
567 $sql .=
" AND ca.type = 'systemauto'";
571 if ($actioncode ==
'AC_NON_AUTO') {
572 $sql .=
" AND ca.type != 'systemauto'";
573 } elseif ($actioncode ==
'AC_ALL_AUTO') {
574 $sql .=
" AND ca.type = 'systemauto'";
576 if (is_array($actioncode)) {
577 $sql .=
" AND ca.code IN (".$db->sanitize(
"'".implode(
"','", $actioncode).
"'", 1).
")";
579 $sql .=
" AND ca.code IN (".$db->sanitize(
"'".implode(
"','", explode(
',', $actioncode)).
"'", 1).
")";
584 if ($resourceid > 0) {
585 $sql .=
" AND r.element_type = 'action' AND r.element_id = a.id AND r.resource_id = ".((int) $resourceid);
588 $sql .=
" AND a.fk_project = ".((int) $pid);
590 if (empty($user->rights->societe->client->voir) && !$socid) {
591 $sql .=
" AND (a.fk_soc IS NULL OR sc.fk_user = ".((int) $user->id).
")";
594 $sql .=
' AND a.fk_soc = '.((int) $socid);
597 if ($filtert > 0 || $usergroup > 0) {
598 $sql .=
" AND ar.fk_actioncomm = a.id AND ar.element_type='user'";
600 if ($mode ==
'show_day') {
602 $sql .=
" (a.datep BETWEEN '".$db->idate(
dol_mktime(0, 0, 0, $month, $day, $year,
'tzuserrel')).
"'";
603 $sql .=
" AND '".$db->idate(
dol_mktime(23, 59, 59, $month, $day, $year,
'tzuserrel')).
"')";
605 $sql .=
" (a.datep2 BETWEEN '".$db->idate(
dol_mktime(0, 0, 0, $month, $day, $year,
'tzuserrel')).
"'";
606 $sql .=
" AND '".$db->idate(
dol_mktime(23, 59, 59, $month, $day, $year,
'tzuserrel')).
"')";
608 $sql .=
" (a.datep < '".$db->idate(
dol_mktime(0, 0, 0, $month, $day, $year,
'tzuserrel')).
"'";
609 $sql .=
" AND a.datep2 > '".$db->idate(
dol_mktime(23, 59, 59, $month, $day, $year,
'tzuserrel')).
"')";
614 $sql .=
" (a.datep BETWEEN '".$db->idate($firstdaytoshow - (60 * 60 * 24 * 2)).
"'";
615 $sql .=
" AND '".$db->idate($lastdaytoshow + (60 * 60 * 24 * 2)).
"')";
617 $sql .=
" (a.datep2 BETWEEN '".$db->idate($firstdaytoshow - (60 * 60 * 24 * 2)).
"'";
618 $sql .=
" AND '".$db->idate($lastdaytoshow + (60 * 60 * 24 * 2)).
"')";
620 $sql .=
" (a.datep < '".$db->idate($firstdaytoshow - (60 * 60 * 24 * 2)).
"'";
621 $sql .=
" AND a.datep2 > '".$db->idate($lastdaytoshow + (60 * 60 * 24 * 2)).
"')";
625 $sql .=
" AND ca.id = ".((int) $type);
627 if ($status ==
'0') {
628 $sql .=
" AND a.percent = 0";
630 if ($status ==
'-1' || $status ==
'na') {
632 $sql .=
" AND a.percent = -1";
634 if ($status ==
'50') {
636 $sql .=
" AND (a.percent > 0 AND a.percent < 100)";
638 if ($status ==
'done' || $status ==
'100') {
639 $sql .=
" AND (a.percent = 100)";
641 if ($status ==
'todo') {
642 $sql .=
" AND (a.percent >= 0 AND a.percent < 100)";
645 if ($filtert > 0 || $usergroup > 0) {
648 $sql .=
"ar.fk_element = ".$filtert;
650 if ($usergroup > 0) {
651 $sql .= ($filtert > 0 ?
" OR " :
"").
" ugu.fk_usergroup = ".((
int) $usergroup);
656 $sql .=
' ORDER BY fk_user_action, datep';
659 dol_syslog(
"comm/action/peruser.php", LOG_DEBUG);
660 $resql = $db->query($sql);
662 $num = $db->num_rows(
$resql);
666 $obj = $db->fetch_object(
$resql);
669 if (!empty($conf->global->AGENDA_ALWAYS_HIDE_AUTO) && $obj->code ==
'AC_OTH_AUTO') {
674 $datep = $db->jdate($obj->datep);
675 $datep2 = $db->jdate($obj->datep2);
679 $event->id = $obj->id;
680 $event->datep = $datep;
681 $event->datef = $datep2;
682 $event->type_code = $obj->code;
683 $event->type_color = $obj->color;
684 $event->label = $obj->label;
685 $event->percentage = $obj->percent;
686 $event->authorid = $obj->fk_user_author;
687 $event->userownerid = $obj->fk_user_action;
688 $event->priority = $obj->priority;
689 $event->fulldayevent = $obj->fulldayevent;
690 $event->location = $obj->location;
691 $event->transparency = $obj->transparency;
693 $event->fk_project = $obj->fk_project;
695 $event->socid = $obj->fk_soc;
696 $event->contact_id = $obj->fk_contact;
698 $event->fk_element = $obj->fk_element;
699 $event->elementtype = $obj->elementtype;
703 if ($event->percentage <= 0) {
704 $event->date_start_in_calendar = $datep;
705 if ($datep2 !=
'' && $datep2 >= $datep) {
706 $event->date_end_in_calendar = $datep2;
708 $event->date_end_in_calendar = $datep;
711 $event->date_start_in_calendar = $datep;
712 if ($datep2 !=
'' && $datep2 >= $datep) {
713 $event->date_end_in_calendar = $datep2;
715 $event->date_end_in_calendar = $datep;
720 if ($event->date_end_in_calendar < $firstdaytoshow ||
721 $event->date_start_in_calendar >= $lastdaytoshow) {
726 $event->fetch_userassigned();
728 if ($event->date_start_in_calendar < $firstdaytoshow) {
729 $event->date_start_in_calendar = $firstdaytoshow;
731 if ($event->date_end_in_calendar >= $lastdaytoshow) {
732 $event->date_end_in_calendar = ($lastdaytoshow - 1);
736 $daycursor = $event->date_start_in_calendar;
743 $loop =
true; $j = 0;
744 $daykey =
dol_mktime(0, 0, 0, $mois, $jour, $annee,
'gmt');
748 $eventarray[$daykey][] = $event;
751 $daykey += 60 * 60 * 24;
752 if ($daykey > $event->date_end_in_calendar) {
768 $cachethirdparties = array();
769 $cachecontacts = array();
770 $cacheusers = array();
773 $color_file = DOL_DOCUMENT_ROOT.
"/theme/".$conf->theme.
"/theme_vars.inc.php";
774 if (is_readable($color_file)) {
777 if (!is_array($theme_datacolor)) {
778 $theme_datacolor = array(array(120, 130, 150), array(200, 160, 180), array(190, 190, 220));
783 $newparam = preg_replace(
'/showbirthday=/i',
'showbirthday_=', $newparam);
784 $newparam = preg_replace(
'/mode=show_month&?/i',
'', $newparam);
785 $newparam = preg_replace(
'/mode=show_week&?/i',
'', $newparam);
786 $newparam = preg_replace(
'/day=[0-9]+&?/i',
'', $newparam);
787 $newparam = preg_replace(
'/month=[0-9]+&?/i',
'', $newparam);
788 $newparam = preg_replace(
'/year=[0-9]+&?/i',
'', $newparam);
789 $newparam = preg_replace(
'/viewweek=[0-9]+&?/i',
'', $newparam);
790 $newparam = preg_replace(
'/showbirthday_=/i',
'showbirthday=', $newparam);
791 $newparam .=
'&viewweek=1';
793 echo
'<input type="hidden" name="actionmove" value="mupdate">';
794 echo
'<input type="hidden" name="backtopage" value="'.dol_escape_htmltag($_SERVER[
'PHP_SELF']).
'?'.
dol_escape_htmltag($_SERVER[
'QUERY_STRING']).
'">';
795 echo
'<input type="hidden" name="newdate" id="newdate">';
802 $currentdaytoshow = $firstdaytoshow;
803 echo
'<div class="div-table-responsive">';
805 while ($currentdaytoshow < $lastdaytoshow) {
806 echo
'<table class="centpercent noborder nocellnopadd cal_month">';
808 echo
'<tr class="liste_titre">';
809 echo
'<td class="nopaddingtopimp nopaddingbottomimp nowraponsmartphone">';
811 if ($canedit && $mode ==
'show_peruser') {
813 print
img_picto(
'',
'clock',
'class="fawidth30 inline-block paddingleft"');
814 print
'<span class="hideonsmartphone" title="'.$langs->trans(
"VisibleTimeRange").
'">'.$langs->trans(
"Hours").
'</span>';
815 print
"\n".
'<div class="ui-grid-a inline-block"><div class="ui-block-a nowraponall">';
816 print
'<input type="number" class="short" name="begin_h" value="'.$begin_h.
'" min="0" max="23">';
817 if (empty($conf->dol_use_jmobile)) {
820 print
'</div><div class="ui-block-b">';
822 print
'<input type="number" class="short" name="end_h" value="'.$end_h.
'" min="1" max="24">';
823 if (empty($conf->dol_use_jmobile)) {
824 print
' '.$langs->trans(
"H");
826 print
'</div></div>';
831 print
img_picto(
'',
'clock',
'class="fawidth30 inline-block paddingleft"');
832 print
'<span class="hideonsmartphone" title="'.$langs->trans(
"VisibleDaysRange").
'">'.$langs->trans(
"DaysOfWeek").
'</span>';
833 print
"\n".
'<div class="ui-grid-a inline-block"><div class="ui-block-a nowraponall">';
834 print
'<input type="number" class="short" name="begin_d" value="'.$begin_d.
'" min="1" max="7">';
835 if (empty($conf->dol_use_jmobile)) {
838 print
'</div><div class="ui-block-b">';
840 print
'<input type="number" class="short" name="end_d" value="'.$end_d.
'" min="1" max="7">';
841 print
'</div></div>';
847 if (($i + 1) < $begin_d || ($i + 1) > $end_d) {
851 echo
'<td align="center" colspan="'.($end_h - $begin_h).
'">';
852 echo
'<span class="bold spandayofweek">'.$langs->trans(
"Day".(($i + (isset($conf->global->MAIN_START_WEEK) ? $conf->global->MAIN_START_WEEK : 1)) % 7)).
'</span>';
864 echo
'<tr class="liste_titre">';
868 if (($i + 1) < $begin_d || ($i + 1) > $end_d) {
872 for ($h = $begin_h; $h < $end_h; $h++) {
873 echo
'<td class="center">';
874 print
'<small style="font-family: courier">'.sprintf(
"%02d", $h).
'</small>';
884 $usernames = array();
885 $usernamesid = array();
887 if (!empty($conf->global->AGENDA_SHOWOWNERONLY_ONPERUSERVIEW)) {
888 foreach ($eventarray as $daykey => $notused) {
890 foreach ($eventarray[$daykey] as $index => $event) {
891 $event->fetch_userassigned();
892 $listofuserid = $event->userassigned;
893 foreach ($listofuserid as $userid => $tmp) {
894 if (!in_array($userid, $usernamesid)) {
895 $usernamesid[$userid] = $userid;
902 $sql =
"SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity";
903 $sql .=
" FROM ".MAIN_DB_PREFIX.
"user as u";
904 if (!empty($conf->multicompany->enabled) && !empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE)) {
905 $sql .=
", ".MAIN_DB_PREFIX.
"usergroup_user as ug";
906 $sql .=
" WHERE ug.entity IN (".getEntity(
'usergroup').
")";
907 $sql .=
" AND ug.fk_user = u.rowid ";
909 if ($usergroup > 0) {
910 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"usergroup_user as ug ON u.rowid = ug.fk_user";
912 $sql .=
" WHERE u.entity IN (".getEntity(
'user').
")";
914 $sql .=
" AND u.statut = 1";
915 if ($usergroup > 0) {
916 $sql .=
" AND ug.fk_usergroup = ".((int) $usergroup);
918 if ($user->socid > 0) {
920 $sql .=
" AND u.fk_soc = ".((int) $user->socid);
924 $resql = $db->query($sql);
926 $num = $db->num_rows(
$resql);
930 $obj = $db->fetch_object(
$resql);
931 $usernamesid[$obj->rowid] = $obj->rowid;
940 foreach ($usernamesid as $id) {
941 $tmpuser =
new User($db);
942 $result = $tmpuser->fetch($id);
943 $usernames[] = $tmpuser;
967 $colorsbytype = array();
968 $labelbytype = array();
969 $sql =
"SELECT code, color, libelle as label FROM ".MAIN_DB_PREFIX.
"c_actioncomm ORDER BY position";
970 $resql = $db->query($sql);
971 while ($obj = $db->fetch_object(
$resql)) {
972 $colorsbytype[$obj->code] = $obj->color;
973 $labelbytype[$obj->code] = $obj->label;
981 foreach ($usernames as $username) {
984 echo
'<td class="tdoverflowmax100 cal_current_month cal_peruserviewname'.($var ?
' cal_impair' :
'').
'">';
985 print $username->getNomUrl(-1,
'', 0, 0, 20, 1,
'');
991 for ($iter_day = 0; $iter_day < 8; $iter_day++) {
992 if (($i + 1) < $begin_d || ($i + 1) > $end_d) {
1000 $tmpday = $tmparray[
'mday'];
1001 $tmpmonth = $tmparray[
'mon'];
1002 $tmpyear = $tmparray[
'year'];
1005 $style =
'cal_current_month';
1006 if ($iter_day == 6) {
1007 $style .=
' cal_other_month';
1010 if ($todayarray[
'mday'] == $tmpday && $todayarray[
'mon'] == $tmpmonth && $todayarray[
'year'] == $tmpyear) {
1014 $style =
'cal_today_peruser';
1017 show_day_events2($username, $tmpday, $tmpmonth, $tmpyear, 0, $style, $eventarray, 0, $maxnbofchar, $newparam, 1, 300, $showheader, $colorsbytype, $var);
1022 $showheader =
false;
1033 if (!empty($conf->global->AGENDA_USE_EVENT_TYPE) && !empty($conf->global->AGENDA_USE_COLOR_PER_EVENT_TYPE)) {
1034 $langs->load(
"commercial");
1035 print
'<br>'.$langs->trans(
"Legend").
': <br>';
1036 foreach ($colorsbytype as $code => $color) {
1038 print
'<div style="float: left; padding: 2px; margin-right: 6px;"><div style="'.($color ?
'background: #'.$color.
';' :
'').
'width:16px; float: left; margin-right: 4px;"> </div>';
1039 print $langs->trans(
"Action".$code) !=
"Action".$code ? $langs->trans(
"Action".$code) : $labelbytype[$code];
1045 print
'<div style="float: left; padding: 2px; margin-right: 6px;"><div class="peruser_busy" style="width:16px; float: left; margin-right: 4px;"> </div>';
1046 print $langs->trans(
"Other");
1055 print
"\n".
'</form>';
1059 print
'<script type="text/javascript">
1060 jQuery(document).ready(function() {
1061 jQuery(".onclickopenref").click(function() {
1062 var ref=$(this).attr(\'ref\');
1063 var res = ref.split("_");
1064 var userid = res[1];
1071 if (ids == \'none\') /* No event */
1073 /* alert(\'no event\'); */
1074 url = "'.DOL_URL_ROOT.
'/comm/action/card.php?action=create&assignedtouser="+userid+"&datep="+year+month+day+hour+min+"00&backtopage='.urlencode($_SERVER[
"PHP_SELF"].
'?year='.$year.
'&month='.$month.
'&day='.$day.($begin_h !==
'' ?
'&begin_h='.$begin_h :
'').($end_h !==
'' ?
'&end_h='.$end_h :
'').($begin_d !==
'' ?
'&begin_d='.$begin_d :
'').($end_d !==
'' ?
'&end_d='.$end_d :
'')).
'"
1075 window.location.href = url;
1077 else if (ids.indexOf(",") > -1) /* There is several events */
1079 /* alert(\'several events\'); */
1080 url = "'.DOL_URL_ROOT.
'/comm/action/list.php?mode=show_list&filtert="+userid+"&dateselectyear="+year+"&dateselectmonth="+month+"&dateselectday="+day;
1081 window.location.href = url;
1083 else /* One event */
1085 /* alert(\'one event\'); */
1086 url = "'.DOL_URL_ROOT.
'/comm/action/card.php?action=view&id="+ids
1087 window.location.href = url;
1120 function show_day_events2($username, $day, $month, $year, $monthshown, $style, &$eventarray, $maxprint = 0, $maxnbofchar = 16, $newparam =
'', $showinfo = 0, $minheight = 60, $showheader =
false, $colorsbytype = array(), $var =
false)
1123 global $user, $conf, $langs, $hookmanager, $action;
1124 global $filter, $filtert, $status, $actioncode;
1125 global $theme_datacolor;
1126 global $cachethirdparties, $cachecontacts, $cacheusers, $cacheprojects, $colorindexused;
1127 global $begin_h, $end_h;
1132 $i = 0; $numother = 0; $numbirthday = 0; $numical = 0; $numicals = array();
1135 $colorindexused[$user->id] = 0;
1136 $nextindextouse = count($colorindexused);
1142 foreach ($eventarray as $daykey => $notused) {
1147 if ($day == $jour && $month == $mois && $year == $annee) {
1149 foreach ($eventarray[$daykey] as $index => $event) {
1153 $keysofuserassigned = array_keys($event->userassigned);
1154 $ponct = ($event->date_start_in_calendar == $event->date_end_in_calendar);
1156 if (!in_array($username->id, $keysofuserassigned)) {
1161 $parameters = array();
1162 $reshook = $hookmanager->executeHooks(
'formatEvent', $parameters, $event, $action);
1168 $color = -1; $cssclass =
''; $colorindex = -1;
1169 if (in_array($user->id, $keysofuserassigned)) {
1170 $cssclass =
'family_mytasks';
1172 if (empty($cacheusers[$event->userownerid])) {
1173 $newuser =
new User($db);
1174 $newuser->fetch($event->userownerid);
1175 $cacheusers[$event->userownerid] = $newuser;
1180 if (!empty($cacheusers[$event->userownerid]->color)) {
1181 $color = $cacheusers[$event->userownerid]->color;
1184 if (!empty($conf->global->AGENDA_USE_COLOR_PER_EVENT_TYPE)) {
1185 $color = $event->type_color;
1187 } elseif ($event->type_code ==
'ICALEVENT') {
1189 if (!empty($event->icalname)) {
1196 $color = $event->icalcolor;
1197 $cssclass = (!empty($event->icalname) ?
'family_ext'.md5($event->icalname) :
'family_other unsortable');
1198 } elseif ($event->type_code ==
'BIRTHDAY') {
1199 $numbirthday++; $colorindex = 2; $cssclass =
'family_birthday unsortable'; $color = sprintf(
"%02x%02x%02x", $theme_datacolor[$colorindex][0], $theme_datacolor[$colorindex][1], $theme_datacolor[$colorindex][2]);
1202 $color = ($event->icalcolor ? $event->icalcolor : -1);
1203 $cssclass = (!empty($event->icalname) ?
'family_ext'.md5($event->icalname) :
'family_other');
1205 if (empty($cacheusers[$event->userownerid])) {
1206 $newuser =
new User($db);
1207 $newuser->fetch($event->userownerid);
1208 $cacheusers[$event->userownerid] = $newuser;
1213 if (!empty($cacheusers[$event->userownerid]->color)) {
1214 $color = $cacheusers[$event->userownerid]->color;
1217 if (!empty($conf->global->AGENDA_USE_COLOR_PER_EVENT_TYPE)) {
1218 $color = $event->type_color;
1224 $idusertouse = ($event->userownerid ? $event->userownerid : 0);
1225 if (isset($colorindexused[$idusertouse])) {
1226 $colorindex = $colorindexused[$idusertouse];
1228 $colorindex = $nextindextouse;
1229 $colorindexused[$idusertouse] = $colorindex;
1230 if (!empty($theme_datacolor[$nextindextouse + 1])) {
1235 $color = sprintf(
"%02x%02x%02x", $theme_datacolor[$colorindex][0], $theme_datacolor[$colorindex][1], $theme_datacolor[$colorindex][2]);
1239 for ($h = $begin_h; $h < $end_h; $h++) {
1242 if (empty($event->fulldayevent)) {
1243 $a =
dol_mktime((
int) $h, 0, 0, $month, $day, $year,
'tzuserrel', 0);
1244 $b =
dol_mktime((
int) $h, 30, 0, $month, $day, $year,
'tzuserrel', 0);
1245 $c =
dol_mktime((
int) $h + 1, 0, 0, $month, $day, $year,
'tzuserrel', 0);
1247 $dateendtouse = $event->date_end_in_calendar;
1248 if ($dateendtouse == $event->date_start_in_calendar) {
1254 if ($event->date_start_in_calendar < $b && $dateendtouse > $a) {
1255 $busy = $event->transparency;
1256 $cases1[$h][$event->id][
'busy'] = $busy;
1257 $cases1[$h][$event->id][
'string'] =
dol_print_date($event->date_start_in_calendar,
'dayhour',
'tzuserrel');
1258 if ($event->date_end_in_calendar && $event->date_end_in_calendar != $event->date_start_in_calendar) {
1259 $tmpa =
dol_getdate($event->date_start_in_calendar,
true);
1260 $tmpb =
dol_getdate($event->date_end_in_calendar,
true);
1261 if ($tmpa[
'mday'] == $tmpb[
'mday'] && $tmpa[
'mon'] == $tmpb[
'mon'] && $tmpa[
'year'] == $tmpb[
'year']) {
1262 $cases1[$h][$event->id][
'string'] .=
'-'.dol_print_date($event->date_end_in_calendar,
'hour',
'tzuserrel');
1264 $cases1[$h][$event->id][
'string'] .=
'-'.dol_print_date($event->date_end_in_calendar,
'dayhour',
'tzuserrel');
1267 if ($event->label) {
1268 $cases1[$h][$event->id][
'string'] .=
' - '.$event->label;
1270 $cases1[$h][$event->id][
'typecode'] = $event->type_code;
1271 $cases1[$h][$event->id][
'color'] = $color;
1272 if ($event->fk_project > 0) {
1273 if (empty($cacheprojects[$event->fk_project])) {
1275 $tmpproj->fetch($event->fk_project);
1276 $cacheprojects[$event->fk_project] = $tmpproj;
1278 $cases1[$h][$event->id][
'string'] .=
', '.$langs->trans(
"Project").
': '.$cacheprojects[$event->fk_project]->ref.
' - '.$cacheprojects[$event->fk_project]->title;
1280 if ($event->socid > 0) {
1281 if (empty($cachethirdparties[$event->socid])) {
1282 $tmpthirdparty =
new Societe($db);
1283 $tmpthirdparty->fetch($event->socid);
1284 $cachethirdparties[$event->socid] = $tmpthirdparty;
1286 $cases1[$h][$event->id][
'string'] .=
', '.$cachethirdparties[$event->socid]->name;
1288 if ($event->contact_id > 0) {
1289 if (empty($cachecontacts[$event->contact_id])) {
1290 $tmpcontact =
new Contact($db);
1291 $tmpcontact->fetch($event->contact_id);
1292 $cachecontacts[$event->contact_id] = $tmpcontact;
1294 $cases1[$h][$event->id][
'string'] .=
', '.$cachecontacts[$event->contact_id]->getFullName($langs);
1297 if ($event->date_start_in_calendar < $c && $dateendtouse > $b) {
1298 $busy = $event->transparency;
1299 $cases2[$h][$event->id][
'busy'] = $busy;
1300 $cases2[$h][$event->id][
'string'] =
dol_print_date($event->date_start_in_calendar,
'dayhour',
'tzuserrel');
1301 if ($event->date_end_in_calendar && $event->date_end_in_calendar != $event->date_start_in_calendar) {
1302 $tmpa =
dol_getdate($event->date_start_in_calendar,
true);
1303 $tmpb =
dol_getdate($event->date_end_in_calendar,
true);
1304 if ($tmpa[
'mday'] == $tmpb[
'mday'] && $tmpa[
'mon'] == $tmpb[
'mon'] && $tmpa[
'year'] == $tmpb[
'year']) {
1305 $cases2[$h][$event->id][
'string'] .=
'-'.dol_print_date($event->date_end_in_calendar,
'hour',
'tzuserrel');
1307 $cases2[$h][$event->id][
'string'] .=
'-'.dol_print_date($event->date_end_in_calendar,
'dayhour',
'tzuserrel');
1310 if ($event->label) {
1311 $cases2[$h][$event->id][
'string'] .=
' - '.$event->label;
1313 $cases2[$h][$event->id][
'typecode'] = $event->type_code;
1314 $cases2[$h][$event->id][
'color'] = $color;
1315 if ($event->fk_project > 0) {
1316 if (empty($cacheprojects[$event->fk_project])) {
1318 $tmpproj->fetch($event->fk_project);
1319 $cacheprojects[$event->fk_project] = $tmpproj;
1321 $cases2[$h][$event->id][
'string'] .=
', '.$langs->trans(
"Project").
': '.$cacheprojects[$event->fk_project]->ref.
' - '.$cacheprojects[$event->fk_project]->title;
1323 if ($event->socid > 0) {
1324 if (empty($cachethirdparties[$event->socid])) {
1325 $tmpthirdparty =
new Societe($db);
1326 $tmpthirdparty->fetch($event->socid);
1327 $cachethirdparties[$event->socid] = $tmpthirdparty;
1329 $cases2[$h][$event->id][
'string'] .=
', '.$cachethirdparties[$event->socid]->name;
1331 if ($event->contact_id > 0) {
1332 if (empty($cachecontacts[$event->contact_id])) {
1333 $tmpcontact =
new Contact($db);
1334 $tmpcontact->fetch($event->contact_id);
1335 $cachecontacts[$event->contact_id] = $tmpcontact;
1337 $cases2[$h][$event->id][
'string'] .=
', '.$cachecontacts[$event->contact_id]->getFullName($langs);
1341 $busy = $event->transparency;
1342 $cases1[$h][$event->id][
'busy'] = $busy;
1343 $cases2[$h][$event->id][
'busy'] = $busy;
1344 $cases1[$h][$event->id][
'string'] = $event->label;
1345 $cases2[$h][$event->id][
'string'] = $event->label;
1346 $cases1[$h][$event->id][
'typecode'] = $event->type_code;
1347 $cases2[$h][$event->id][
'typecode'] = $event->type_code;
1348 $cases1[$h][$event->id][
'color'] = $color;
1349 $cases2[$h][$event->id][
'color'] = $color;
1360 for ($h = $begin_h; $h < $end_h; $h++) {
1361 $color1 =
''; $color2 =
'';
1362 $style1 =
''; $style2 =
'';
1363 $string1 =
' '; $string2 =
' ';
1364 $title1 =
''; $title2 =
'';
1365 if (isset($cases1[$h]) && $cases1[$h] !=
'') {
1367 if (count($cases1[$h]) > 1) {
1368 $title1 .= count($cases1[$h]).
' '.(count($cases1[$h]) == 1 ? $langs->trans(
"Event") : $langs->trans(
"Events"));
1370 $string1 =
' ';
1371 if (empty($conf->global->AGENDA_NO_TRANSPARENT_ON_NOT_BUSY)) {
1372 $style1 =
'peruser_notbusy';
1374 $style1 =
'peruser_busy';
1376 foreach ($cases1[$h] as $id => $ev) {
1378 $style1 =
'peruser_busy';
1382 if (isset($cases2[$h]) && $cases2[$h] !=
'') {
1384 if (count($cases2[$h]) > 1) {
1385 $title2 .= count($cases2[$h]).
' '.(count($cases2[$h]) == 1 ? $langs->trans(
"Event") : $langs->trans(
"Events"));
1387 $string2 =
' ';
1388 if (empty($conf->global->AGENDA_NO_TRANSPARENT_ON_NOT_BUSY)) {
1389 $style2 =
'peruser_notbusy';
1391 $style2 =
'peruser_busy';
1393 foreach ($cases2[$h] as $id => $ev) {
1395 $style2 =
'peruser_busy';
1402 if (!empty($cases1[$h]) && is_array($cases1[$h]) && count($cases1[$h]) && array_keys($cases1[$h])) {
1403 $ids1 = join(
',', array_keys($cases1[$h]));
1405 if (!empty($cases2[$h]) && is_array($cases2[$h]) && count($cases2[$h]) && array_keys($cases2[$h])) {
1406 $ids2 = join(
',', array_keys($cases2[$h]));
1409 if ($h == $begin_h) {
1410 echo
'<td class="'.$style.
'_peruserleft cal_peruser'.($var ?
' cal_impair '.$style.
'_impair' :
'').
'">';
1412 echo
'<td class="'.$style.
' cal_peruser'.($var ?
' cal_impair '.$style.
'_impair' :
'').
'">';
1414 if (!empty($cases1[$h]) && is_array($cases1[$h]) && count($cases1[$h]) == 1) {
1415 $output = array_slice($cases1[$h], 0, 1);
1416 $title1 = $langs->trans(
"Ref").
' '.$ids1.($title1 ?
' - '.$title1 :
'');
1417 if ($output[0][
'string']) {
1418 $title1 .= ($title1 ?
' - ' :
'').$output[0][
'string'];
1420 if ($output[0][
'color']) {
1421 $color1 = $output[0][
'color'];
1423 } elseif (!empty($cases1[$h]) && is_array($cases1[$h]) && count($cases1[$h]) > 1) {
1424 $title1 = $langs->trans(
"Ref").
' '.$ids1.($title1 ?
' - '.$title1 :
'');
1428 if (!empty($cases2[$h]) && is_array($cases2[$h]) && count($cases2[$h]) == 1) {
1429 $output = array_slice($cases2[$h], 0, 1);
1430 $title2 = $langs->trans(
"Ref").
' '.$ids2.($title2 ?
' - '.$title2 :
'');
1431 if ($output[0][
'string']) {
1432 $title2 .= ($title2 ?
' - ' :
'').$output[0][
'string'];
1434 if ($output[0][
'color']) {
1435 $color2 = $output[0][
'color'];
1437 } elseif (!empty($cases2[$h]) && is_array($cases2[$h]) && count($cases2[$h]) > 1) {
1438 $title2 = $langs->trans(
"Ref").
' '.$ids2.($title2 ?
' - '.$title2 :
'');
1441 print
'<table class="nobordernopadding" width="100%">';
1443 if ($style1 ==
'peruser_notbusy') {
1444 print
'style="border: 1px solid #'.($color1 ? $color1 :
"888").
' !important" ';
1445 } elseif ($color1) {
1446 print ($color1 ?
'style="background: #'.$color1.
';"' :
'');
1449 print ($style1 ? $style1.
' ' :
'');
1450 print
'onclickopenref center'.($title2 ?
' classfortooltip' :
'').($title1 ?
' cursorpointer' :
'').
'" ref="ref_'.$username->id.
'_'.sprintf(
"%04d", $year).
'_'.sprintf(
"%02d", $month).
'_'.sprintf(
"%02d", $day).
'_'.sprintf(
"%02d", $h).
'_00_'.($ids1 ? $ids1 :
'none').
'"'.($title1 ?
' title="'.$title1.
'"' :
'').
'>';
1453 if ($style2 ==
'peruser_notbusy') {
1454 print
'style="border: 1px solid #'.($color2 ? $color2 :
"888").
' !important" ';
1455 } elseif ($color2) {
1456 print ($color2 ?
'style="background: #'.$color2.
';"' :
'');
1459 print ($style2 ? $style2.
' ' :
'');
1460 print
'onclickopenref center'.($title2 ?
' classfortooltip' :
'').($title1 ?
' cursorpointer' :
'').
'" ref="ref_'.$username->id.
'_'.sprintf(
"%04d", $year).
'_'.sprintf(
"%02d", $month).
'_'.sprintf(
"%02d", $day).
'_'.sprintf(
"%02d", $h).
'_30_'.($ids2 ? $ids2 :
'none').
'"'.($title2 ?
' title="'.$title2.
'"' :
'').
'>';