27 require
"../../main.inc.php";
28 require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
29 require_once DOL_DOCUMENT_ROOT.
'/projet/class/task.class.php';
30 require_once DOL_DOCUMENT_ROOT.
'/core/lib/project.lib.php';
31 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
33 $search_project_user =
GETPOST(
'search_project_user',
'int');
34 $mine =
GETPOST(
'mode',
'aZ09') ==
'mine' ? 1 : 0;
35 if ($search_project_user == $user->id) {
41 if ($user->socid > 0) {
42 $socid = $user->socid;
45 if (!$user->rights->projet->lire) {
52 $hookmanager->initHooks(array(
'activityindex'));
55 $langs->load(
"projects");
68 $projectstatic =
new Project($db);
69 $taskstatic =
new Task($db);
70 $projectsListId = $projectstatic->getProjectsAuthorizedForUser($user, 0, 1);
71 $taskstatic =
new Task($db);
72 $tasktmp =
new Task($db);
74 $title = $langs->trans(
"Activities");
81 $titleall = $langs->trans(
"AllAllowedProjects");
82 if (!empty($user->rights->projet->all->lire) && !$socid) {
83 $titleall = $langs->trans(
"AllProjects");
85 $titleall = $langs->trans(
"AllAllowedProjects").
'<br><br>';
90 $morehtml .=
'<form name="projectform">';
91 $morehtml .=
'<SELECT name="mode">';
92 $morehtml .=
'<option name="all" value="all"'.($mine ?
'' :
' selected').
'>'.$titleall.
'</option>';
93 $morehtml .=
'<option name="mine" value="'.$user->id.
'"'.(($search_project_user == $user->id) ?
' selected' :
'').
'>'.$langs->trans(
"ProjectsImContactFor").
'</option>';
94 $morehtml .=
'</SELECT>';
95 $morehtml .=
'<input type="submit" class="button" name="refresh" value="'.$langs->trans(
"Refresh").
'">';
98 $tooltiphelp = $langs->trans(
"MyTasksDesc");
100 if ($user->rights->projet->all->lire && !$socid) {
101 $tooltiphelp = $langs->trans(
"TasksDesc");
103 $tooltiphelp = $langs->trans(
"TasksPublicDesc");
107 print_barre_liste(
$form->textwithpicto($title, $tooltiphelp), 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', 0, -1,
'projecttask', 0, $morehtml);
109 print
'<div class="fichecenter"><div class="fichethirdleft">';
113 print
'<div class="div-table-responsive-no-min">';
114 print
'<table class="noborder centpercent">';
115 print
'<tr class="liste_titre">';
116 print
'<td width="50%">'.$langs->trans(
'ActivityOnProjectToday').
'</td>';
117 print
'<td width="50%" class="right">'.$langs->trans(
"Time").
'</td>';
120 $sql =
"SELECT p.rowid, p.ref, p.title, p.public, SUM(tt.task_duration) as nb";
121 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p";
122 $sql .=
", ".MAIN_DB_PREFIX.
"projet_task as t";
123 $sql .=
", ".MAIN_DB_PREFIX.
"projet_task_time as tt";
124 $sql .=
" WHERE t.fk_projet = p.rowid";
125 $sql .=
" AND p.entity = ".((int) $conf->entity);
126 $sql .=
" AND tt.fk_task = t.rowid";
127 $sql .=
" AND tt.fk_user = ".((int) $user->id);
128 $sql .=
" AND task_date BETWEEN '".$db->idate(
dol_mktime(0, 0, 0, $month, $day, $year)).
"' AND '".$db->idate(
dol_mktime(23, 59, 59, $month, $day, $year)).
"'";
129 $sql .=
" AND p.rowid in (".$db->sanitize($projectsListId).
")";
130 $sql .=
" GROUP BY p.rowid, p.ref, p.title, p.public";
132 $resql = $db->query($sql);
136 while ($row = $db->fetch_object(
$resql)) {
137 print
'<tr class="oddeven">';
139 $projectstatic->id = $row->rowid;
140 $projectstatic->ref = $row->ref;
141 $projectstatic->title = $row->title;
142 $projectstatic->public = $row->public;
143 print $projectstatic->getNomUrl(1,
'', 1);
145 print
'<td class="right">'.convertSecondToTime($row->nb,
'allhourmin').
'</td>';
154 print
'<tr class="liste_total">';
155 print
'<td>'.$langs->trans(
'Total').
'</td>';
156 print
'<td class="right">'.convertSecondToTime($total,
'allhourmin').
'</td>';
162 print
'</div><div class="fichetwothirdright">';
166 print
'<div class="div-table-responsive-no-min">';
167 print
'<table class="noborder centpercent">';
168 print
'<tr class="liste_titre">';
169 print
'<td>'.$langs->trans(
'ActivityOnProjectYesterday').
'</td>';
170 print
'<td class="right">'.$langs->trans(
"Time").
'</td>';
173 $sql =
"SELECT p.rowid, p.ref, p.title, p.public, SUM(tt.task_duration) as nb";
174 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p";
175 $sql .=
", ".MAIN_DB_PREFIX.
"projet_task as t";
176 $sql .=
", ".MAIN_DB_PREFIX.
"projet_task_time as tt";
177 $sql .=
" WHERE t.fk_projet = p.rowid";
178 $sql .=
" AND p.entity = ".((int) $conf->entity);
179 $sql .=
" AND tt.fk_task = t.rowid";
180 $sql .=
" AND tt.fk_user = ".((int) $user->id);
181 $sql .=
" AND task_date BETWEEN '".$db->idate(
dol_time_plus_duree(
dol_mktime(0, 0, 0, $month, $day, $year), -1,
'd')).
"' AND '".$db->idate(
dol_time_plus_duree(
dol_mktime(23, 59, 59, $month, $day, $year), -1,
'd')).
"'";
182 $sql .=
" AND p.rowid in (".$db->sanitize($projectsListId).
")";
183 $sql .=
" GROUP BY p.rowid, p.ref, p.title, p.public";
185 $resql = $db->query($sql);
189 while ($row = $db->fetch_object(
$resql)) {
190 print
'<tr class="oddeven">';
192 $projectstatic->id = $row->rowid;
193 $projectstatic->ref = $row->ref;
194 $projectstatic->title = $row->title;
195 $projectstatic->public = $row->public;
196 print $projectstatic->getNomUrl(1,
'', 1);
198 print
'<td class="right">'.convertSecondToTime($row->nb,
'allhourmin').
'</td>';
207 print
'<tr class="liste_total">';
208 print
'<td>'.$langs->trans(
'Total').
'</td>';
209 print
'<td class="right">'.convertSecondToTime($total,
'allhourmin').
'</td>';
277 if (!empty($conf->global->PROJECT_TASK_TIME_MONTH)) {
278 print
'<div class="div-table-responsive-no-min">';
279 print
'<table class="noborder centpercent">';
280 print
'<tr class="liste_titre">';
281 print
'<td>'.$langs->trans(
"ActivityOnProjectThisMonth").
': '.
dol_print_date($now,
"%B %Y").
'</td>';
282 print
'<td class="right">'.$langs->trans(
"Time").
'</td>';
285 $sql =
"SELECT p.rowid, p.ref, p.title, p.public, SUM(tt.task_duration) as nb";
286 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p";
287 $sql .=
", ".MAIN_DB_PREFIX.
"projet_task as t";
288 $sql .=
", ".MAIN_DB_PREFIX.
"projet_task_time as tt";
289 $sql .=
" WHERE t.fk_projet = p.rowid";
290 $sql .=
" AND p.entity = ".((int) $conf->entity);
291 $sql .=
" AND tt.fk_task = t.rowid";
292 $sql .=
" AND tt.fk_user = ".((int) $user->id);
294 $sql .=
" AND p.rowid in (".$db->sanitize($projectsListId).
")";
295 $sql .=
" GROUP BY p.rowid, p.ref, p.title, p.public";
297 $resql = $db->query($sql);
299 while ($row = $db->fetch_object(
$resql)) {
300 print
'<tr class="oddeven">';
302 $projectstatic->id = $row->rowid;
303 $projectstatic->ref = $row->ref;
304 $projectstatic->title = $row->title;
305 print $projectstatic->getNomUrl(1,
'', 1);
307 print
'<td class="right">'.convertSecondToTime($row->nb,
'allhourmin').
'</td>';
314 print
'<tr class="liste_total">';
315 print
'<td>'.$langs->trans(
'Total').
'</td>';
316 print
'<td class="right">'.convertSecondToTime($total,
'allhourmin').
'</td>';
323 if (!empty($conf->global->PROJECT_TASK_TIME_YEAR)) {
324 print
'<div class="div-table-responsive-no-min">';
325 print
'<br><table class="noborder centpercent">';
326 print
'<tr class="liste_titre">';
327 print
'<td>'.$langs->trans(
"ActivityOnProjectThisYear").
': '.strftime(
"%Y", $now).
'</td>';
328 print
'<td class="right">'.$langs->trans(
"Time").
'</td>';
331 $sql =
"SELECT p.rowid, p.ref, p.title, p.public, SUM(tt.task_duration) as nb";
332 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p";
333 $sql .=
", ".MAIN_DB_PREFIX.
"projet_task as t";
334 $sql .=
", ".MAIN_DB_PREFIX.
"projet_task_time as tt";
335 $sql .=
" WHERE t.fk_projet = p.rowid";
336 $sql .=
" AND p.entity = ".((int) $conf->entity);
337 $sql .=
" AND tt.fk_task = t.rowid";
338 $sql .=
" AND tt.fk_user = ".((int) $user->id);
339 $sql .=
" AND YEAR(task_date) = '".strftime(
"%Y", $now).
"'";
340 $sql .=
" AND p.rowid in (".$db->sanitize($projectsListId).
")";
341 $sql .=
" GROUP BY p.rowid, p.ref, p.title, p.public";
343 $resql = $db->query($sql);
345 while ($row = $db->fetch_object(
$resql)) {
346 print
'<tr class="oddeven">';
348 $projectstatic->id = $row->rowid;
349 $projectstatic->ref = $row->ref;
350 $projectstatic->title = $row->title;
351 $projectstatic->public = $row->public;
352 print $projectstatic->getNomUrl(1,
'', 1);
354 print
'<td class="right">'.convertSecondToTime($row->nb,
'allhourmin').
'</td>';
361 print
'<tr class="liste_total">';
362 print
'<td>'.$langs->trans(
'Total').
'</td>';
363 print
'<td class="right">'.convertSecondToTime($total,
'allhourmin').
'</td>';
369 if (empty($conf->global->PROJECT_HIDE_TASKS) && !empty($conf->global->PROJECT_SHOW_TASK_LIST_ON_PROJECT_AREA)) {
371 $listofprojectcontacttype = array();
372 $sql =
"SELECT ctc.rowid, ctc.code FROM ".MAIN_DB_PREFIX.
"c_type_contact as ctc";
373 $sql .=
" WHERE ctc.element = '".$db->escape($projectstatic->element).
"'";
374 $sql .=
" AND ctc.source = 'internal'";
375 $resql = $db->query($sql);
377 while ($obj = $db->fetch_object(
$resql)) {
378 $listofprojectcontacttype[$obj->rowid] = $obj->code;
383 if (count($listofprojectcontacttype) == 0) {
384 $listofprojectcontacttype[0] =
'0';
387 $listoftaskcontacttype = array();
388 $sql =
"SELECT ctc.rowid, ctc.code FROM ".MAIN_DB_PREFIX.
"c_type_contact as ctc";
389 $sql .=
" WHERE ctc.element = '".$db->escape($taskstatic->element).
"'";
390 $sql .=
" AND ctc.source = 'internal'";
391 $resql = $db->query($sql);
393 while ($obj = $db->fetch_object(
$resql)) {
394 $listoftaskcontacttype[$obj->rowid] = $obj->code;
399 if (count($listoftaskcontacttype) == 0) {
400 $listoftaskcontacttype[0] =
'0';
408 $max = (empty($conf->global->PROJECT_LIMIT_TASK_PROJECT_AREA) ? 1000 : $conf->global->PROJECT_LIMIT_TASK_PROJECT_AREA);
410 $sql =
"SELECT p.ref, p.title, p.rowid as projectid, p.fk_statut as status, p.fk_opp_status as opp_status, p.public, p.dateo as projdateo, p.datee as projdatee,";
411 $sql .=
" t.label, t.rowid as taskid, t.planned_workload, t.duration_effective, t.progress, t.dateo, t.datee, SUM(tasktime.task_duration) as timespent";
412 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p";
413 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s on p.fk_soc = s.rowid";
414 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"projet_task as t on t.fk_projet = p.rowid";
415 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"projet_task_time as tasktime on tasktime.fk_task = t.rowid";
416 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"user as u on tasktime.fk_user = u.rowid";
418 $sql .=
", ".MAIN_DB_PREFIX.
"element_contact as ect";
420 $sql .=
" WHERE p.entity IN (".getEntity(
'project').
")";
421 if ($mine || empty($user->rights->projet->all->lire)) {
422 $sql .=
" AND p.rowid IN (".$db->sanitize($projectsListId).
")";
425 $sql .=
" AND ect.fk_c_type_contact IN (".$db->sanitize(join(
',', array_keys($listoftaskcontacttype))).
") AND ect.element_id = t.rowid AND ect.fk_socpeople = ".((
int) $user->id);
428 $sql .=
" AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc = ".((int) $socid).
")";
430 $sql .=
" AND p.fk_statut=1";
431 $sql .=
" GROUP BY p.ref, p.title, p.rowid, p.fk_statut, p.fk_opp_status, p.public, t.label, t.rowid, t.planned_workload, t.duration_effective, t.progress, t.dateo, t.datee";
432 $sql .=
" ORDER BY t.dateo desc, t.rowid desc, t.datee";
433 $sql .= $db->plimit($max + 1);
435 dol_syslog(
'projet:index.php: affectationpercent', LOG_DEBUG);
436 $resql = $db->query($sql);
438 $num = $db->num_rows(
$resql);
443 print
'<div class="div-table-responsive-no-min">';
444 print
'<table class="noborder centpercent">';
445 print
'<tr class="liste_titre">';
447 print
'<th>'.$langs->trans(
'OpenedProjects').
'</th>';
448 if (!empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
449 print
'<th>'.$langs->trans(
'OpportunityStatus').
'</th>';
451 print
'<th>'.$langs->trans(
'Task').
'</th>';
452 print
'<th class="center">'.$langs->trans(
'DateStart').
'</th>';
453 print
'<th class="center">'.$langs->trans(
'DateEnd').
'</th>';
454 print
'<th class="right">'.$langs->trans(
'PlannedWorkload').
'</th>';
455 print
'<th class="right">'.$langs->trans(
'TimeSpent').
'</th>';
456 print
'<th class="right">'.$langs->trans(
"ProgressCalculated").
'</td>';
457 print
'<th class="right">'.$langs->trans(
"ProgressDeclared").
'</td>';
460 while ($i < $num && $i < $max) {
461 $obj = $db->fetch_object(
$resql);
463 $projectstatic->id = $obj->projectid;
464 $projectstatic->ref = $obj->ref;
465 $projectstatic->title = $obj->title;
466 $projectstatic->statut = $obj->status;
467 $projectstatic->public = $obj->public;
468 $projectstatic->dateo = $db->jdate($obj->projdateo);
469 $projectstatic->datee = $db->jdate($obj->projdatee);
471 $taskstatic->projectstatus = $obj->projectstatus;
472 $taskstatic->progress = $obj->progress;
473 $taskstatic->fk_statut = $obj->status;
474 $taskstatic->dateo = $db->jdate($obj->dateo);
475 $taskstatic->datee = $db->jdate($obj->datee);
478 if ($obj->userid && $userstatic->id != $obj->userid) {
479 $result = $userstatic->fetch($obj->userid);
484 if ($userstatic->id) {
485 $username = $userstatic->getNomUrl(0, 0);
488 print
'<tr class="oddeven">';
491 print $projectstatic->getNomUrl(1,
'', 0,
'',
'<br>');
493 if (!empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
495 $code =
dol_getIdFromCode($db, $obj->opp_status,
'c_lead_status',
'rowid',
'code');
497 print $langs->trans(
"OppStatus".$code);
502 if (!empty($obj->taskid)) {
503 $tasktmp->id = $obj->taskid;
504 $tasktmp->ref = $obj->ref;
505 $tasktmp->label = $obj->label;
506 print $tasktmp->getNomUrl(1,
'withproject',
'task', 1,
'<br>');
508 print $langs->trans(
"NoTasks");
511 print
'<td class="center">'.dol_print_date($db->jdate($obj->dateo),
'day').
'</td>';
512 print
'<td class="center">'.dol_print_date($db->jdate($obj->datee),
'day');
513 if ($taskstatic->hasDelay()) {
517 print
'<td class="right"><a href="'.DOL_URL_ROOT.
'/projet/tasks/time.php?id='.$obj->taskid.
'&withproject=1">';
520 print
'<td class="right"><a href="'.DOL_URL_ROOT.
'/projet/tasks/time.php?id='.$obj->taskid.
'&withproject=1">';
523 print
'<td class="right">';
524 if (!empty($obj->taskid)) {
525 if (empty($obj->planned_workload) > 0) {
526 $percentcompletion = $langs->trans(
"WorkloadNotDefined");
528 $percentcompletion = intval($obj->duration_effective * 100 / $obj->planned_workload).
'%';
531 print $percentcompletion;
533 print
'<td class="right">';
534 print ($obj->taskid > 0) ? $obj->progress.
'%' :
'';
543 if (!empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
546 print
'<tr><td colspan="'.$colspan.
'">'.$langs->trans(
"WarningTooManyDataPleaseUseMoreFilters").
'</td></tr>';
560 print
'</div></div>';
562 $parameters = array(
'user' => $user);
563 $reshook = $hookmanager->executeHooks(
'dashboardActivities', $parameters, $object);