28 require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
40 global $db, $langs, $conf, $user;
45 $head[$h][0] = DOL_URL_ROOT.
'/projet/card.php?id='.((int) $project->id).($moreparam ?
'&'.$moreparam :
'');
46 $head[$h][1] = $langs->trans(
"Project");
47 $head[$h][2] =
'project';
51 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
52 $cachekey =
'count_contacts_project_'.$project->id;
55 if (!is_null($dataretrieved)) {
56 $nbContacts = $dataretrieved;
58 $nbContacts = count($project->liste_contact(-1,
'internal')) + count($project->liste_contact(-1,
'external'));
61 $head[$h][0] = DOL_URL_ROOT.
'/projet/contact.php?id='.((int) $project->id).($moreparam ?
'&'.$moreparam :
'');
62 $head[$h][1] = $langs->trans(
"ProjectContact");
63 if ($nbContacts > 0) {
64 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbContacts.
'</span>';
66 $head[$h][2] =
'contact';
69 if (empty($conf->global->PROJECT_HIDE_TASKS)) {
73 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
74 $cachekey =
'count_tasks_project_'.$project->id;
77 if (!is_null($dataretrieved)) {
78 $nbTasks = $dataretrieved;
80 require_once DOL_DOCUMENT_ROOT.
'/projet/class/task.class.php';
81 $taskstatic =
new Task($db);
82 $nbTasks = count($taskstatic->getTasksArray(0, 0, $project->id, 0, 0));
85 $head[$h][0] = DOL_URL_ROOT.
'/projet/tasks.php?id='.((int) $project->id).($moreparam ?
'&'.$moreparam :
'');
86 $head[$h][1] = $langs->trans(
"Tasks");
88 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.($nbTasks).
'</span>';
90 $head[$h][2] =
'tasks';
95 $cachekey =
'count_timespent_project_'.$project->id;
97 if (!is_null($dataretrieved)) {
98 $nbTimeSpent = $dataretrieved;
100 $sql =
"SELECT t.rowid";
103 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet_task_time as t, ".MAIN_DB_PREFIX.
"projet_task as pt";
104 $sql .=
" WHERE t.fk_task = pt.rowid";
105 $sql .=
" AND pt.fk_projet =".((int) $project->id);
106 $resql = $db->query($sql);
108 $obj = $db->fetch_object(
$resql);
118 $head[$h][0] = DOL_URL_ROOT.
'/projet/tasks/time.php?withproject=1&projectid='.((int) $project->id).($moreparam ?
'&'.$moreparam :
'');
119 $head[$h][1] = $langs->trans(
"TimeSpent");
120 if ($nbTimeSpent > 0) {
121 $head[$h][1] .=
'<span class="badge marginleftonlyshort">...</span>';
123 $head[$h][2] =
'timespent';
127 if (((!empty($conf->fournisseur->enabled) && empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD)) || !empty($conf->supplier_order->enabled) || !empty($conf->supplier_invoice->enabled))
128 || !empty($conf->propal->enabled) || !empty($conf->commande->enabled)
129 ||
isModEnabled(
'facture') || !empty($conf->contrat->enabled)
130 || !empty($conf->ficheinter->enabled) || !empty($conf->agenda->enabled) || !empty($conf->deplacement->enabled) || !empty($conf->stock->enabled)) {
133 $cachekey =
'count_elements_project_'.$project->id;
135 if (!is_null($dataretrieved)) {
136 $nbElements = $dataretrieved;
138 if (!empty($conf->stock->enabled)) {
139 $nbElements += $project->getElementCount(
'stock',
'entrepot',
'fk_project');
141 if (!empty($conf->propal->enabled)) {
142 $nbElements += $project->getElementCount(
'propal',
'propal');
144 if (!empty($conf->commande->enabled)) {
145 $nbElements += $project->getElementCount(
'order',
'commande');
148 $nbElements += $project->getElementCount(
'invoice',
'facture');
151 $nbElements += $project->getElementCount(
'invoice_predefined',
'facture_rec');
153 if (!empty($conf->supplier_proposal->enabled)) {
154 $nbElements += $project->getElementCount(
'proposal_supplier',
'supplier_proposal');
156 if (!empty($conf->supplier_order->enabled)) {
157 $nbElements += $project->getElementCount(
'order_supplier',
'commande_fournisseur');
159 if (!empty($conf->supplier_invoice->enabled)) {
160 $nbElements += $project->getElementCount(
'invoice_supplier',
'facture_fourn');
162 if (!empty($conf->contrat->enabled)) {
163 $nbElements += $project->getElementCount(
'contract',
'contrat');
165 if (!empty($conf->ficheinter->enabled)) {
166 $nbElements += $project->getElementCount(
'intervention',
'fichinter');
168 if (!empty($conf->expedition->enabled)) {
169 $nbElements += $project->getElementCount(
'shipping',
'expedition');
171 if (!empty($conf->mrp->enabled)) {
172 $nbElements += $project->getElementCount(
'mrp',
'mrp_mo',
'fk_project');
174 if (!empty($conf->deplacement->enabled)) {
175 $nbElements += $project->getElementCount(
'trip',
'deplacement');
177 if (!empty($conf->expensereport->enabled)) {
178 $nbElements += $project->getElementCount(
'expensereport',
'expensereport');
180 if (!empty($conf->don->enabled)) {
181 $nbElements += $project->getElementCount(
'donation',
'don');
183 if (!empty($conf->loan->enabled)) {
184 $nbElements += $project->getElementCount(
'loan',
'loan');
186 if (!empty($conf->tax->enabled)) {
187 $nbElements += $project->getElementCount(
'chargesociales',
'chargesociales');
189 if (!empty($conf->project->enabled)) {
190 $nbElements += $project->getElementCount(
'project_task',
'projet_task');
192 if (!empty($conf->stock->enabled)) {
193 $nbElements += $project->getElementCount(
'stock_mouvement',
'stock');
195 if (!empty($conf->salaries->enabled)) {
196 $nbElements += $project->getElementCount(
'salaries',
'payment_salary');
198 if (!empty($conf->banque->enabled)) {
199 $nbElements += $project->getElementCount(
'variouspayment',
'payment_various');
203 $head[$h][0] = DOL_URL_ROOT.
'/projet/element.php?id='.$project->id;
204 $head[$h][1] = $langs->trans(
"ProjectOverview");
205 if ($nbElements > 0) {
206 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbElements.
'</span>';
208 $head[$h][2] =
'element';
212 if (!empty($conf->eventorganization->enabled) && !empty($project->usage_organize_event)) {
213 $langs->load(
'eventorganization');
214 $head[$h][0] = DOL_URL_ROOT .
'/eventorganization/conferenceorbooth_list.php?projectid=' . $project->id;
215 $head[$h][1] = $langs->trans(
"EventOrganization");
219 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
220 $cachekey =
'count_conferenceorbooth_'.$project->id;
222 if (!is_null($dataretrieved)) {
223 $nbConfOrBooth = $dataretrieved;
225 require_once DOL_DOCUMENT_ROOT.
'/eventorganization/class/conferenceorbooth.class.php';
227 $result = $conforbooth->fetchAll(
'',
'', 0, 0, array(
't.fk_project'=>$project->id));
229 if (!is_array($result) && $result<0) {
232 $nbConfOrBooth = count($result);
236 if ($nbConfOrBooth > 0) {
237 $head[$h][1] .=
'<span class="badge marginleftonlyshort">' . $nbConfOrBooth .
'</span>';
239 $head[$h][2] =
'eventorganisation';
250 if (empty($conf->global->MAIN_DISABLE_NOTES_TAB)) {
252 if (!empty($project->note_private)) {
255 if (!empty($project->note_public)) {
258 $head[$h][0] = DOL_URL_ROOT.
'/projet/note.php?id='.$project->id;
259 $head[$h][1] = $langs->trans(
'Notes');
261 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbNote.
'</span>';
263 $head[$h][2] =
'notes';
270 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
271 $cachekey =
'count_attached_project_'.$project->id;
273 if (!is_null($dataretrieved)) {
274 $totalAttached = $dataretrieved;
276 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
277 require_once DOL_DOCUMENT_ROOT.
'/core/class/link.class.php';
278 $upload_dir = $conf->project->multidir_output[$project->entity].
"/".
dol_sanitizeFileName($project->ref);
279 $nbFiles = count(
dol_dir_list($upload_dir,
'files', 0,
'',
'(\.meta|_preview.*\.png)$'));
280 $nbLinks =
Link::count($db, $project->element, $project->id);
281 $totalAttached = $nbFiles + $nbLinks;
284 $head[$h][0] = DOL_URL_ROOT.
'/projet/document.php?id='.$project->id;
285 $head[$h][1] = $langs->trans(
'Documents');
286 if (($totalAttached) > 0) {
287 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.($totalAttached).
'</span>';
289 $head[$h][2] =
'document';
293 if (!empty($conf->global->PROJECT_ALLOW_COMMENT_ON_PROJECT)) {
296 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
297 $cachekey =
'count_attached_project_'.$project->id;
299 if (!is_null($dataretrieved)) {
300 $nbComments = $dataretrieved;
302 $nbComments = $project->getNbComments();
305 $head[$h][0] = DOL_URL_ROOT.
'/projet/comment.php?id='.$project->id;
306 $head[$h][1] = $langs->trans(
"CommentLink");
307 if ($nbComments > 0) {
308 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbComments.
'</span>';
310 $head[$h][2] =
'project_comment';
314 $head[$h][0] = DOL_URL_ROOT.
'/projet/info.php?id='.$project->id;
315 $head[$h][1] = $langs->trans(
"Events");
316 if (
isModEnabled(
'agenda') && (!empty($user->rights->agenda->myactions->read) || !empty($user->rights->agenda->allactions->read))) {
318 $head[$h][1] .= $langs->trans(
"Agenda");
320 $head[$h][2] =
'agenda';
337 global $db, $langs, $conf, $user;
341 $head[$h][0] = DOL_URL_ROOT.
'/projet/tasks/task.php?id='.$object->id.(GETPOST(
'withproject') ?
'&withproject=1' :
'');
342 $head[$h][1] = $langs->trans(
"Task");
343 $head[$h][2] =
'task_task';
346 $nbContact = count($object->liste_contact(-1,
'internal')) + count($object->liste_contact(-1,
'external'));
347 $head[$h][0] = DOL_URL_ROOT.
'/projet/tasks/contact.php?id='.$object->id.(GETPOST(
'withproject') ?
'&withproject=1' :
'');
348 $head[$h][1] = $langs->trans(
"TaskRessourceLinks");
349 if ($nbContact > 0) {
350 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbContact.
'</span>';
352 $head[$h][2] =
'task_contact';
357 $sql =
"SELECT t.rowid";
360 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet_task_time as t";
361 $sql .=
" WHERE t.fk_task = ".((int) $object->id);
362 $resql = $db->query($sql);
364 $obj = $db->fetch_object(
$resql);
372 $head[$h][0] = DOL_URL_ROOT.
'/projet/tasks/time.php?id='.urlencode($object->id).(GETPOST(
'withproject') ?
'&withproject=1' :
'');
373 $head[$h][1] = $langs->trans(
"TimeSpent");
374 if ($nbTimeSpent > 0) {
375 $head[$h][1] .=
'<span class="badge marginleftonlyshort">...</span>';
377 $head[$h][2] =
'task_time';
386 if (empty($conf->global->MAIN_DISABLE_NOTES_TAB)) {
388 if (!empty($object->note_private)) {
391 if (!empty($object->note_public)) {
394 $head[$h][0] = DOL_URL_ROOT.
'/projet/tasks/note.php?id='.urlencode($object->id).(GETPOST(
'withproject') ?
'&withproject=1' :
'');
395 $head[$h][1] = $langs->trans(
'Notes');
397 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbNote.
'</span>';
399 $head[$h][2] =
'task_notes';
403 $head[$h][0] = DOL_URL_ROOT.
'/projet/tasks/document.php?id='.$object->id.(GETPOST(
'withproject') ?
'&withproject=1' :
'');
405 include_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
406 include_once DOL_DOCUMENT_ROOT.
'/core/class/link.class.php';
407 $nbFiles = count(
dol_dir_list($filesdir,
'files', 0,
'',
'(\.meta|_preview.*\.png)$'));
408 $nbLinks =
Link::count($db, $object->element, $object->id);
409 $head[$h][1] = $langs->trans(
'Documents');
410 if (($nbFiles + $nbLinks) > 0) {
411 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.($nbFiles + $nbLinks).
'</span>';
413 $head[$h][2] =
'task_document';
417 if (!empty($conf->global->PROJECT_ALLOW_COMMENT_ON_TASK)) {
418 $nbComments = $object->getNbComments();
419 $head[$h][0] = DOL_URL_ROOT.
'/projet/tasks/comment.php?id='.$object->id.(GETPOST(
'withproject') ?
'&withproject=1' :
'');
420 $head[$h][1] = $langs->trans(
"CommentLink");
421 if ($nbComments > 0) {
422 $head[$h][1] .=
'<span class="badge marginleftonlyshort">'.$nbComments.
'</span>';
424 $head[$h][2] =
'task_comment';
442 global $langs, $conf, $user;
449 $param .= ($mode ?
'&mode='.$mode :
'');
450 if (is_object($fuser) && $fuser->id > 0 && $fuser->id != $user->id) {
451 $param .=
'&search_usertoprocessid='.$fuser->id;
454 if (empty($conf->global->PROJECT_DISABLE_TIMESHEET_PERMONTH)) {
455 $head[$h][0] = DOL_URL_ROOT.
"/projet/activity/permonth.php".($param ?
'?'.$param :
'');
456 $head[$h][1] = $langs->trans(
"InputPerMonth");
457 $head[$h][2] =
'inputpermonth';
461 if (empty($conf->global->PROJECT_DISABLE_TIMESHEET_PERWEEK)) {
462 $head[$h][0] = DOL_URL_ROOT.
"/projet/activity/perweek.php".($param ?
'?'.$param :
'');
463 $head[$h][1] = $langs->trans(
"InputPerWeek");
464 $head[$h][2] =
'inputperweek';
468 if (empty($conf->global->PROJECT_DISABLE_TIMESHEET_PERTIME)) {
469 $head[$h][0] = DOL_URL_ROOT.
"/projet/activity/perday.php".($param ?
'?'.$param :
'');
470 $head[$h][1] = $langs->trans(
"InputPerDay");
471 $head[$h][2] =
'inputperday';
490 global $langs, $conf, $user;
496 $head[$h][0] = DOL_URL_ROOT.
"/projet/admin/project.php";
497 $head[$h][1] = $langs->trans(
"Projects");
498 $head[$h][2] =
'project';
503 $head[$h][0] = DOL_URL_ROOT.
"/projet/admin/project_extrafields.php";
504 $head[$h][1] = $langs->trans(
"ExtraFieldsProject");
505 $head[$h][2] =
'attributes';
508 $head[$h][0] = DOL_URL_ROOT.
'/projet/admin/project_task_extrafields.php';
509 $head[$h][1] = $langs->trans(
"ExtraFieldsProjectTask");
510 $head[$h][2] =
'attributes_task';
513 if (!empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
514 $langs->load(
"members");
516 $head[$h][0] = DOL_URL_ROOT.
'/projet/admin/website.php';
517 $head[$h][1] = $langs->trans(
"BlankSubscriptionForm");
518 $head[$h][2] =
'website';
546 function projectLinesa(&$inc, $parent, &$lines, &$level, $var, $showproject, &$taskrole, $projectsListId =
'', $addordertick = 0, $projectidfortotallink = 0, $filterprogresscalc =
'', $showbilltime = 0, $arrayfields = array())
548 global $user, $langs, $conf, $db, $hookmanager;
549 global $projectstatic, $taskstatic, $extrafields;
553 $projectsArrayId = explode(
',', $projectsListId);
554 if ($filterprogresscalc !==
'') {
555 foreach ($lines as $key => $line) {
556 if (!empty($line->planned_workload) && !empty($line->duration)) {
557 $filterprogresscalc = str_replace(
' = ',
' == ', $filterprogresscalc);
558 if (!eval($filterprogresscalc)) {
563 $lines = array_values($lines);
565 $numlines = count($lines);
568 global $total_projectlinesa_spent, $total_projectlinesa_planned, $total_projectlinesa_spent_if_planned, $total_projectlinesa_declared_if_planned, $total_projectlinesa_tobill, $total_projectlinesa_billed, $total_budget_amount;
571 $total_projectlinesa_spent = 0;
572 $total_projectlinesa_planned = 0;
573 $total_projectlinesa_spent_if_planned = 0;
574 $total_projectlinesa_declared_if_planned = 0;
575 $total_projectlinesa_tobill = 0;
576 $total_projectlinesa_billed = 0;
577 $total_budget_amount = 0;
580 for ($i = 0; $i < $numlines; $i++) {
581 if ($parent == 0 && $level >= 0) {
588 if ($lines[$i]->fk_parent == $parent || $level < 0) {
594 if (is_array($taskrole)) {
596 if (!isset($taskrole[$lines[$i]->
id]) && $lines[$i]->
id != $lines[$i]->fk_parent) {
598 $foundtaskforuserdeeper = 0;
601 if ($foundtaskforuserdeeper > 0) {
610 if (empty($user->rights->projet->all->lire)) {
612 if (!in_array($lines[$i]->fk_project, $projectsArrayId)) {
623 if ($parent == 0 && $lines[$i]->fk_project != $lastprojectid) {
625 $lastprojectid = $lines[$i]->fk_project;
628 print
'<tr class="oddeven" id="row-'.$lines[$i]->id.
'">'.
"\n";
630 $projectstatic->id = $lines[$i]->fk_project;
631 $projectstatic->ref = $lines[$i]->projectref;
632 $projectstatic->public = $lines[$i]->public;
633 $projectstatic->title = $lines[$i]->projectlabel;
634 $projectstatic->usage_bill_time = $lines[$i]->usage_bill_time;
635 $projectstatic->status = $lines[$i]->projectstatus;
637 $taskstatic->id = $lines[$i]->id;
638 $taskstatic->ref = $lines[$i]->ref;
639 $taskstatic->label = (!empty($taskrole[$lines[$i]->
id]) ? $langs->trans(
"YourRole").
': '.$taskrole[$lines[$i]->id] :
'');
640 $taskstatic->projectstatus = $lines[$i]->projectstatus;
641 $taskstatic->progress = $lines[$i]->progress;
642 $taskstatic->fk_statut = $lines[$i]->status;
643 $taskstatic->date_start = $lines[$i]->date_start;
644 $taskstatic->date_end = $lines[$i]->date_end;
645 $taskstatic->datee = $lines[$i]->date_end;
646 $taskstatic->planned_workload = $lines[$i]->planned_workload;
647 $taskstatic->duration_effective = $lines[$i]->duration;
648 $taskstatic->budget_amount = $lines[$i]->budget_amount;
653 print
'<td class="nowraponall">';
655 if ($lines[$i]->
public || in_array($lines[$i]->fk_project, $projectsArrayId) || !empty($user->rights->projet->all->lire)) {
656 print $projectstatic->getNomUrl(1);
658 print $projectstatic->getNomUrl(1,
'nolink');
665 $projectstatic->statut = $lines[$i]->projectstatus;
666 print $projectstatic->getLibStatut(2);
671 if (count($arrayfields) > 0 && !empty($arrayfields[
't.ref'][
'checked'])) {
672 print
'<td class="nowraponall">';
673 if ($showlineingray) {
674 print
'<i>'.img_object(
'',
'projecttask').
' '.$lines[$i]->ref.
'</i>';
676 print $taskstatic->getNomUrl(1,
'withproject');
682 if (count($arrayfields) > 0 && !empty($arrayfields[
't.label'][
'checked'])) {
684 if ($showlineingray) {
685 $labeltoshow .=
'<i>';
688 for ($k = 0; $k < $level; $k++) {
689 $labeltoshow .=
'<div class="marginleftonly">';
692 for ($k = 0; $k < $level; $k++) {
693 $labeltoshow .=
'</div>';
695 if ($showlineingray) {
696 $labeltoshow .=
'</i>';
698 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($labeltoshow).
'">';
703 if (count($arrayfields) > 0 && !empty($arrayfields[
't.description'][
'checked'])) {
704 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($lines[$i]->
description).
'">';
705 print $lines[$i]->description;
710 if (count($arrayfields) > 0 && !empty($arrayfields[
't.dateo'][
'checked'])) {
711 print
'<td class="center nowraponall">';
717 if (count($arrayfields) > 0 && !empty($arrayfields[
't.datee'][
'checked'])) {
718 print
'<td class="center nowraponall">';
720 if ($taskstatic->hasDelay()) {
726 $plannedworkloadoutputformat =
'allhourmin';
727 $timespentoutputformat =
'allhourmin';
728 if (!empty($conf->global->PROJECT_PLANNED_WORKLOAD_FORMAT)) {
729 $plannedworkloadoutputformat = $conf->global->PROJECT_PLANNED_WORKLOAD_FORMAT;
731 if (!empty($conf->global->PROJECT_TIMES_SPENT_FORMAT)) {
732 $timespentoutputformat = $conf->global->PROJECT_TIME_SPENT_FORMAT;
736 if (count($arrayfields) > 0 && !empty($arrayfields[
't.planned_workload'][
'checked'])) {
737 print
'<td class="right">';
738 $fullhour =
convertSecondToTime($lines[$i]->planned_workload, $plannedworkloadoutputformat);
740 if ($lines[$i]->planned_workload !=
'') {
750 if (count($arrayfields) > 0 && !empty($arrayfields[
't.duration_effective'][
'checked'])) {
751 print
'<td class="right">';
752 if ($showlineingray) {
755 print
'<a href="'.DOL_URL_ROOT.
'/projet/tasks/time.php?id='.$lines[$i]->id.($showproject ?
'' :
'&withproject=1').
'">';
757 if ($lines[$i]->duration) {
762 if ($showlineingray) {
771 if (count($arrayfields) > 0 && !empty($arrayfields[
't.progress_calculated'][
'checked'])) {
772 print
'<td class="right">';
773 if ($lines[$i]->planned_workload || $lines[$i]->duration) {
774 if ($lines[$i]->planned_workload) {
775 print round(100 * $lines[$i]->duration / $lines[$i]->planned_workload, 2).
' %';
777 print
'<span class="opacitymedium">'.$langs->trans(
'WorkloadNotDefined').
'</span>';
784 if (count($arrayfields) > 0 && !empty($arrayfields[
't.progress'][
'checked'])) {
785 print
'<td class="right">';
786 if ($lines[$i]->progress !=
'') {
793 if (count($arrayfields) > 0 && !empty($arrayfields[
't.progress_summary'][
'checked'])) {
794 print
'<td class="right">';
795 if ($lines[$i]->progress !=
'' && $lines[$i]->duration) {
803 if (count($arrayfields) > 0 && !empty($arrayfields[
't.tobill'][
'checked'])) {
804 print
'<td class="right">';
805 if ($lines[$i]->usage_bill_time) {
807 $total_projectlinesa_tobill += $lines[$i]->tobill;
809 print
'<span class="opacitymedium">'.$langs->trans(
"NA").
'</span>';
815 if (count($arrayfields) > 0 && !empty($arrayfields[
't.billed'][
'checked'])) {
816 print
'<td class="right">';
817 if ($lines[$i]->usage_bill_time) {
819 $total_projectlinesa_billed += $lines[$i]->billed;
821 print
'<span class="opacitymedium">'.$langs->trans(
"NA").
'</span>';
828 if (count($arrayfields) > 0 && !empty($arrayfields[
't.budget_amount'][
'checked'])) {
829 print
'<td class="center">';
830 if ($lines[$i]->budget_amount) {
831 print
'<span class="amount">'.price($lines[$i]->budget_amount, 0, $langs, 1, 0, 0, $conf->currency).
'</span>';
832 $total_budget_amount += $lines[$i]->budget_amount;
838 if (count($arrayfields) > 0 && !empty($arrayfields[
'c.assigned'][
'checked'])) {
839 print
'<td class="center">';
841 foreach (array(
'internal',
'external') as $source) {
842 $tab = $lines[$i]->liste_contact(-1, $source);
843 $numcontact = count($tab);
844 if (!empty($numcontact)) {
845 foreach ($tab as $contacttask) {
847 if ($source ==
'internal') {
852 $c->fetch($contacttask[
'id']);
853 if (!empty($c->photo)) {
854 if (get_class($c) ==
'User') {
855 print $c->getNomUrl(-2,
'', 0, 0, 24, 1,
'', ($ifisrt ?
'' :
'notfirst'));
857 print $c->getNomUrl(-2,
'', 0,
'', -1, 0, ($ifisrt ?
'' :
'notfirst'));
860 if (get_class($c) ==
'User') {
861 print $c->getNomUrl(2,
'', 0, 0, 24, 1,
'', ($ifisrt ?
'' :
'notfirst'));
863 print $c->getNomUrl(2,
'', 0,
'', -1, 0, ($ifisrt ?
'' :
'notfirst'));
874 $extrafieldsobjectkey = $taskstatic->table_element;
876 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
878 $parameters = array(
'arrayfields'=>$arrayfields,
'obj'=>$lines[$i]);
879 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters);
880 print $hookmanager->resPrint;
883 print
'<td class="tdlineupdown center"></td>';
887 if (!$showlineingray) {
893 if ($lines[$i]->
id) {
894 projectLinesa($inc, $lines[$i]->
id, $lines, $level, $var, $showproject, $taskrole, $projectsListId, $addordertick, $projectidfortotallink, $filterprogresscalc, $showbilltime, $arrayfields);
899 $total_projectlinesa_spent += $lines[$i]->duration;
900 $total_projectlinesa_planned += $lines[$i]->planned_workload;
901 if ($lines[$i]->planned_workload) {
902 $total_projectlinesa_spent_if_planned += $lines[$i]->duration;
904 if ($lines[$i]->planned_workload) {
905 $total_projectlinesa_declared_if_planned += $lines[$i]->planned_workload * $lines[$i]->progress / 100;
913 if (($total_projectlinesa_planned > 0 || $total_projectlinesa_spent > 0 || $total_projectlinesa_tobill > 0 || $total_projectlinesa_billed > 0 || $total_budget_amount > 0)
915 print
'<tr class="liste_total nodrag nodrop">';
916 print
'<td class="liste_total">'.$langs->trans(
"Total").
'</td>';
918 print
'<td></td><td></td>';
920 if (count($arrayfields) > 0 && ! empty($arrayfields[
't.label'][
'checked'])) {
923 if (count($arrayfields) > 0 && ! empty($arrayfields[
't.description'][
'checked'])) {
926 if (count($arrayfields) > 0 && ! empty($arrayfields[
't.dateo'][
'checked'])) {
929 if (count($arrayfields) > 0 && ! empty($arrayfields[
't.datee'][
'checked'])) {
932 if (count($arrayfields) > 0 && ! empty($arrayfields[
't.planned_workload'][
'checked'])) {
933 print
'<td class="nowrap liste_total right">';
937 if (count($arrayfields) > 0 && ! empty($arrayfields[
't.duration_effective'][
'checked'])) {
938 print
'<td class="nowrap liste_total right">';
939 if ($projectidfortotallink > 0) {
940 print
'<a href="'.DOL_URL_ROOT.
'/projet/tasks/time.php?projectid='.$projectidfortotallink.($showproject ?
'' :
'&withproject=1').
'">';
943 if ($projectidfortotallink > 0) {
949 if ($total_projectlinesa_planned) {
950 $totalAverageDeclaredProgress = round(100 * $total_projectlinesa_declared_if_planned / $total_projectlinesa_planned, 2);
951 $totalCalculatedProgress = round(100 * $total_projectlinesa_spent / $total_projectlinesa_planned, 2);
954 $warningRatio = !empty($conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT) ? (1 + $conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT / 100) : 1.10;
957 $progressBarClass =
'progress-bar-info';
958 $badgeClass =
'badge ';
960 if ($totalCalculatedProgress > $totalAverageDeclaredProgress) {
961 $progressBarClass =
'progress-bar-danger';
962 $badgeClass .=
'badge-danger';
963 } elseif ($totalCalculatedProgress * $warningRatio >= $totalAverageDeclaredProgress) {
964 $progressBarClass =
'progress-bar-warning';
965 $badgeClass .=
'badge-warning';
967 $progressBarClass =
'progress-bar-success';
968 $badgeClass .=
'badge-success';
973 if (count($arrayfields) > 0 && !empty($arrayfields[
't.progress_calculated'][
'checked'])) {
974 print
'<td class="nowrap liste_total right">';
975 if ($total_projectlinesa_planned) {
976 print $totalCalculatedProgress.
' %';
982 if (count($arrayfields) > 0 && !empty($arrayfields[
't.progress'][
'checked'])) {
983 print
'<td class="nowrap liste_total right">';
984 if ($total_projectlinesa_planned) {
985 print
'<span class="'.$badgeClass.
'" >'.$totalAverageDeclaredProgress.
' %</span>';
992 if (count($arrayfields) > 0 && !empty($arrayfields[
't.progress_summary'][
'checked'])) {
993 print
'<td class="right">';
994 if ($total_projectlinesa_planned) {
996 print
' <div class="progress sm" title="'.$totalAverageDeclaredProgress.
'%" >';
997 print
' <div class="progress-bar '.$progressBarClass.
'" style="width: '.$totalAverageDeclaredProgress.
'%"></div>';
1004 if ($showbilltime) {
1005 if (count($arrayfields) > 0 && !empty($arrayfields[
't.tobill'][
'checked'])) {
1006 print
'<td class="nowrap liste_total right">';
1010 if (count($arrayfields) > 0 && !empty($arrayfields[
't.billed'][
'checked'])) {
1011 print
'<td class="nowrap liste_total right">';
1018 if (count($arrayfields) > 0 && !empty($arrayfields[
't.budget_amount'][
'checked'])) {
1019 print
'<td class="nowrap liste_total center">';
1020 if (strcmp($total_budget_amount,
'')) {
1021 print
price($total_budget_amount, 0, $langs, 1, 0, 0, $conf->currency);
1027 if (!empty($conf->global->PROJECT_SHOW_CONTACTS_IN_LIST)) {
1031 if (count($arrayfields) > 0 && !empty($arrayfields[
'c.assigned'][
'checked'])) {
1034 if (! empty($totalarray[
'nbfield'])) {
1035 print
'<td colspan="'.$totalarray[
'nbfield'].
'" class=""></td>';
1037 print
'<td class=""></td>';
1062 function projectLinesPerAction(&$inc, $parent, $fuser, $lines, &$level, &$projectsrole, &$tasksrole, $mine, $restricteditformytask, $preselectedday, &$isavailable, $oldprojectforbreak = 0)
1064 global $conf, $db, $user, $langs;
1065 global
$form, $formother, $projectstatic, $taskstatic, $thirdpartystatic;
1068 $totalforeachline = array();
1069 $workloadforid = array();
1070 $lineswithoutlevel0 = array();
1072 $numlines = count($lines);
1076 for ($i = 0; $i < $numlines; $i++) {
1077 if ($lines[$i]->fk_task_parent) {
1078 $lineswithoutlevel0[] = $lines[$i];
1083 if (empty($oldprojectforbreak)) {
1084 $oldprojectforbreak = (empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT) ? 0 : -1);
1088 for ($i = 0; $i < $numlines; $i++) {
1096 if (empty($mine) || !empty($tasksrole[$lines[$i]->
id])) {
1100 if ($parent == 0 && $lines[$i]->fk_project != $lastprojectid) {
1101 $lastprojectid = $lines[$i]->fk_project;
1102 if ($preselectedday) {
1103 $projectstatic->id = $lines[$i]->fk_project;
1107 if (empty($workloadforid[$projectstatic->id])) {
1108 if ($preselectedday) {
1109 $projectstatic->loadTimeSpent($preselectedday, 0, $fuser->id);
1110 $workloadforid[$projectstatic->id] = 1;
1114 $projectstatic->id = $lines[$i]->fk_project;
1115 $projectstatic->ref = $lines[$i]->project_ref;
1116 $projectstatic->title = $lines[$i]->project_label;
1117 $projectstatic->public = $lines[$i]->public;
1118 $projectstatic->status = $lines[$i]->project_status;
1120 $taskstatic->id = $lines[$i]->task_id;
1121 $taskstatic->ref = ($lines[$i]->task_ref ? $lines[$i]->task_ref : $lines[$i]->task_id);
1122 $taskstatic->label = $lines[$i]->task_label;
1123 $taskstatic->date_start = $lines[$i]->date_start;
1124 $taskstatic->date_end = $lines[$i]->date_end;
1126 $thirdpartystatic->id = $lines[$i]->socid;
1127 $thirdpartystatic->name = $lines[$i]->thirdparty_name;
1128 $thirdpartystatic->email = $lines[$i]->thirdparty_email;
1130 if (empty($oldprojectforbreak) || ($oldprojectforbreak != -1 && $oldprojectforbreak != $projectstatic->id)) {
1131 print
'<tr class="oddeven trforbreak nobold">'.
"\n";
1132 print
'<td colspan="11">';
1133 print $projectstatic->getNomUrl(1,
'', 0, $langs->transnoentitiesnoconv(
"YourRole").
': '.$projectsrole[$lines[$i]->fk_project]);
1134 if ($projectstatic->title) {
1136 print $projectstatic->title;
1142 if ($oldprojectforbreak != -1) {
1143 $oldprojectforbreak = $projectstatic->id;
1146 print
'<tr class="oddeven">'.
"\n";
1157 if ($oldprojectforbreak == -1) {
1158 print $projectstatic->getNomUrl(1,
'', 0, $langs->transnoentitiesnoconv(
"YourRole").
': '.$projectsrole[$lines[$i]->fk_project]);
1159 print
'<br>'.$projectstatic->title;
1164 print
'<td class="tdoverflowmax100">';
1165 if ($thirdpartystatic->id > 0) {
1166 print $thirdpartystatic->getNomUrl(1,
'project', 10);
1172 print
'<!-- Task id = '.$lines[$i]->id.
' -->';
1173 for ($k = 0; $k < $level; $k++) {
1174 print
" ";
1176 print $taskstatic->getNomUrl(1,
'withproject',
'time');
1179 for ($k = 0; $k < $level; $k++) {
1180 print
" ";
1182 print $taskstatic->label;
1189 print
'<td class="center">';
1193 $disabledproject = 1;
1199 if ($lines[$i]->
public || !empty($projectsrole[$lines[$i]->fk_project]) || $user->rights->projet->all->creer) {
1200 $disabledproject = 0;
1204 if ($restricteditformytask && empty($tasksrole[$lines[$i]->
id])) {
1209 print
'<td class="nowrap center">';
1214 if (!$isavailable[$preselectedday][
'morning'] && !$isavailable[$preselectedday][
'afternoon']) {
1215 $cssonholiday .=
'onholidayallday ';
1216 } elseif (!$isavailable[$preselectedday][
'morning']) {
1217 $cssonholiday .=
'onholidaymorning ';
1218 } elseif (!$isavailable[$preselectedday][
'afternoon']) {
1219 $cssonholiday .=
'onholidayafternoon ';
1223 print
'<td class="duration'.($cssonholiday ?
' '.$cssonholiday :
'').
' center">';
1225 $dayWorkLoad = $lines[$i]->timespent_duration;
1226 $totalforeachline[$preselectedday] += $lines[$i]->timespent_duration;
1229 if ($dayWorkLoad > 0) {
1247 print
'<td class="center">';
1248 print
'<textarea name="'.$lines[$i]->id.
'note" rows="'.ROWS_2.
'" id="'.$lines[$i]->id.
'note"'.($disabledtask ?
' disabled="disabled"' :
'').
'>';
1249 print $lines[$i]->timespent_note;
1250 print
'</textarea>';
1254 print
'<td class="right">';
1274 return $totalforeachline;
1297 function projectLinesPerDay(&$inc, $parent, $fuser, $lines, &$level, &$projectsrole, &$tasksrole, $mine, $restricteditformytask, $preselectedday, &$isavailable, $oldprojectforbreak = 0, $arrayfields = array(), $extrafields =
null)
1299 global $conf, $db, $user, $langs;
1300 global
$form, $formother, $projectstatic, $taskstatic, $thirdpartystatic;
1303 $totalforeachday = array();
1304 $workloadforid = array();
1305 $lineswithoutlevel0 = array();
1307 $numlines = count($lines);
1311 for ($i = 0; $i < $numlines; $i++) {
1312 if ($lines[$i]->fk_task_parent) {
1313 $lineswithoutlevel0[] = $lines[$i];
1318 if (empty($oldprojectforbreak)) {
1319 $oldprojectforbreak = (empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT) ? 0 : -1);
1322 $restrictBefore =
null;
1324 if (! empty($conf->global->PROJECT_TIMESHEET_PREVENT_AFTER_MONTHS)) {
1325 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
1330 for ($i = 0; $i < $numlines; $i++) {
1335 if ($lines[$i]->fk_task_parent == $parent) {
1339 if (empty($mine) || !empty($tasksrole[$lines[$i]->
id])) {
1342 if ($restricteditformytask == 2 && empty($tasksrole[$lines[$i]->
id])) {
1347 if ($parent == 0 && $lines[$i]->fk_project != $lastprojectid) {
1348 $lastprojectid = $lines[$i]->fk_project;
1349 if ($preselectedday) {
1350 $projectstatic->id = $lines[$i]->fk_project;
1354 if (empty($workloadforid[$projectstatic->id])) {
1355 if ($preselectedday) {
1356 $projectstatic->loadTimeSpent($preselectedday, 0, $fuser->id);
1357 $workloadforid[$projectstatic->id] = 1;
1361 $projectstatic->id = $lines[$i]->fk_project;
1362 $projectstatic->ref = $lines[$i]->projectref;
1363 $projectstatic->title = $lines[$i]->projectlabel;
1364 $projectstatic->public = $lines[$i]->public;
1365 $projectstatic->status = $lines[$i]->projectstatus;
1367 $taskstatic->id = $lines[$i]->id;
1368 $taskstatic->ref = ($lines[$i]->ref ? $lines[$i]->ref : $lines[$i]->id);
1369 $taskstatic->label = $lines[$i]->label;
1370 $taskstatic->date_start = $lines[$i]->date_start;
1371 $taskstatic->date_end = $lines[$i]->date_end;
1373 $thirdpartystatic->id = $lines[$i]->socid;
1374 $thirdpartystatic->name = $lines[$i]->thirdparty_name;
1375 $thirdpartystatic->email = $lines[$i]->thirdparty_email;
1377 if (empty($oldprojectforbreak) || ($oldprojectforbreak != -1 && $oldprojectforbreak != $projectstatic->id)) {
1379 if (!empty($arrayfields[
't.planned_workload'][
'checked'])) {
1382 if (!empty($arrayfields[
't.progress'][
'checked'])) {
1385 foreach ($arrayfields as $key => $val) {
1386 if ($val[
'checked'] && substr($key, 0, 5) ==
'efpt.') {
1391 print
'<tr class="oddeven trforbreak nobold">'.
"\n";
1392 print
'<td colspan="'.(7 + $addcolspan).
'">';
1393 print $projectstatic->getNomUrl(1,
'', 0,
'<strong>'.$langs->transnoentitiesnoconv(
"YourRole").
':</strong> '.$projectsrole[$lines[$i]->fk_project]);
1394 if ($thirdpartystatic->id > 0) {
1395 print
' - '.$thirdpartystatic->getNomUrl(1);
1397 if ($projectstatic->title) {
1399 print
'<span class="secondary">'.$projectstatic->title.
'</span>';
1466 if ($oldprojectforbreak != -1) {
1467 $oldprojectforbreak = $projectstatic->id;
1470 print
'<tr class="oddeven" data-taskid="'.$lines[$i]->id.
'">'.
"\n";
1480 if (!empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT)) {
1482 if ($oldprojectforbreak == -1) {
1483 print $projectstatic->getNomUrl(1,
'', 0, $langs->transnoentitiesnoconv(
"YourRole").
': '.$projectsrole[$lines[$i]->fk_project]);
1489 if (!empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT)) {
1490 print
'<td class="tdoverflowmax100">';
1491 if ($thirdpartystatic->id > 0) {
1492 print $thirdpartystatic->getNomUrl(1,
'project', 10);
1499 print
'<!-- Task id = '.$lines[$i]->id.
' -->';
1500 for ($k = 0; $k < $level; $k++) {
1501 print
'<div class="marginleftonly">';
1503 print $taskstatic->getNomUrl(1,
'withproject',
'time');
1506 print
'<span class="opacitymedium">'.$taskstatic->label.
'</a>';
1507 for ($k = 0; $k < $level; $k++) {
1513 $extrafieldsobjectkey =
'projet_task';
1514 $extrafieldsobjectprefix =
'efpt.';
1515 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1518 if (!empty($arrayfields[
't.planned_workload'][
'checked'])) {
1519 print
'<td class="leftborder plannedworkload right">';
1520 if ($lines[$i]->planned_workload) {
1529 if (!empty($arrayfields[
't.progress'][
'checked'])) {
1530 print
'<td class="right">';
1531 print $formother->select_percent($lines[$i]->progress, $lines[$i]->
id.
'progress');
1535 if (!empty($arrayfields[
'timeconsumed'][
'checked'])) {
1537 print
'<td class="right">';
1539 if ($lines[$i]->duration) {
1540 print
'<a href="'.DOL_URL_ROOT.
'/projet/tasks/time.php?id='.$lines[$i]->id.
'">';
1549 print
'<td class="right">';
1550 $tmptimespent = $taskstatic->getSummaryOfTimeSpent($fuser->id);
1551 if ($tmptimespent[
'total_duration']) {
1559 $disabledproject = 1;
1565 if ($lines[$i]->
public || !empty($projectsrole[$lines[$i]->fk_project]) || $user->rights->projet->all->creer) {
1566 $disabledproject = 0;
1570 if ($restricteditformytask && empty($tasksrole[$lines[$i]->
id])) {
1574 if ($restrictBefore && $preselectedday < $restrictBefore) {
1579 print
'<td class="nowraponall leftborder center minwidth150imp">';
1580 $tableCell =
$form->selectDate($preselectedday, $lines[$i]->
id, 1, 1, 2,
"addtime", 0, 0, $disabledtask);
1585 if (!$isavailable[$preselectedday][
'morning'] && !$isavailable[$preselectedday][
'afternoon']) {
1586 $cssonholiday .=
'onholidayallday ';
1587 } elseif (!$isavailable[$preselectedday][
'morning']) {
1588 $cssonholiday .=
'onholidaymorning ';
1589 } elseif (!$isavailable[$preselectedday][
'afternoon']) {
1590 $cssonholiday .=
'onholidayafternoon ';
1596 $idw = ($tmparray[
'wday'] - (empty($conf->global->MAIN_START_WEEK) ? 0 : 1));
1597 global $numstartworkingday, $numendworkingday;
1599 if ((($idw + 1) < $numstartworkingday) || (($idw + 1) > $numendworkingday)) {
1600 $cssweekend =
'weekend';
1604 print
'<td class="center duration'.($cssonholiday ?
' '.$cssonholiday :
'').($cssweekend ?
' '.$cssweekend :
'').
'">';
1605 $dayWorkLoad = $projectstatic->weekWorkLoadPerTask[$preselectedday][$lines[$i]->id];
1606 $totalforeachday[$preselectedday] += $dayWorkLoad;
1609 if ($dayWorkLoad > 0) {
1616 $tableCell .=
'<span class="timesheetalreadyrecorded" title="texttoreplace"><input type="text" class="center" size="2" disabled id="timespent['.$inc.
']['.$idw.
']" name="task['.$lines[$i]->id.
']['.$idw.
']" value="'.$alreadyspent.
'"></span>';
1617 $tableCell .=
'<span class="hideonsmartphone"> + </span>';
1619 $tableCell .=
$form->select_duration($lines[$i]->
id.
'duration',
'', $disabledtask,
'text', 0, 1);
1635 print
'<td class="center">';
1636 print
'<textarea name="'.$lines[$i]->id.
'note" rows="'.ROWS_2.
'" id="'.$lines[$i]->id.
'note"'.($disabledtask ?
' disabled="disabled"' :
'').
'>';
1637 print
'</textarea>';
1641 print
'<td class="right">';
1642 if ((!$lines[$i]->
public) && $disabledproject) {
1643 print
$form->textwithpicto(
'', $langs->trans(
"UserIsNotContactOfProject"));
1644 } elseif ($disabledtask) {
1645 $titleassigntask = $langs->trans(
"AssignTaskToMe");
1646 if ($fuser->id != $user->id) {
1647 $titleassigntask = $langs->trans(
"AssignTaskToUser",
'...');
1650 print
$form->textwithpicto(
'', $langs->trans(
"TaskIsNotAssignedToUser", $titleassigntask));
1659 if ($lines[$i]->
id > 0) {
1662 $ret =
projectLinesPerDay($inc, $lines[$i]->
id, $fuser, ($parent == 0 ? $lineswithoutlevel0 : $lines), $level, $projectsrole, $tasksrole, $mine, $restricteditformytask, $preselectedday, $isavailable, $oldprojectforbreak, $arrayfields, $extrafields);
1665 foreach ($ret as $key => $val) {
1666 $totalforeachday[$key] += $val;
1677 return $totalforeachday;
1700 function projectLinesPerWeek(&$inc, $firstdaytoshow, $fuser, $parent, $lines, &$level, &$projectsrole, &$tasksrole, $mine, $restricteditformytask, &$isavailable, $oldprojectforbreak = 0, $arrayfields = array(), $extrafields =
null)
1702 global $conf, $db, $user, $langs;
1703 global
$form, $formother, $projectstatic, $taskstatic, $thirdpartystatic;
1705 $numlines = count($lines);
1708 $workloadforid = array();
1709 $totalforeachday = array();
1710 $lineswithoutlevel0 = array();
1714 for ($i = 0; $i < $numlines; $i++) {
1715 if ($lines[$i]->fk_task_parent) {
1716 $lineswithoutlevel0[] = $lines[$i];
1723 if (empty($oldprojectforbreak)) {
1724 $oldprojectforbreak = (empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT) ? 0 : -1);
1727 $restrictBefore =
null;
1729 if (! empty($conf->global->PROJECT_TIMESHEET_PREVENT_AFTER_MONTHS)) {
1730 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
1734 for ($i = 0; $i < $numlines; $i++) {
1739 if ($lines[$i]->fk_task_parent == $parent) {
1743 if (empty($mine) || !empty($tasksrole[$lines[$i]->
id])) {
1746 if ($restricteditformytask == 2 && empty($tasksrole[$lines[$i]->
id])) {
1751 if ($parent == 0 && $lines[$i]->fk_project != $lastprojectid) {
1752 $lastprojectid = $lines[$i]->fk_project;
1753 $projectstatic->id = $lines[$i]->fk_project;
1758 if (empty($workloadforid[$projectstatic->id])) {
1759 $projectstatic->loadTimeSpent($firstdaytoshow, 0, $fuser->id);
1760 $workloadforid[$projectstatic->id] = 1;
1765 $projectstatic->id = $lines[$i]->fk_project;
1766 $projectstatic->ref = $lines[$i]->projectref;
1767 $projectstatic->title = $lines[$i]->projectlabel;
1768 $projectstatic->public = $lines[$i]->public;
1769 $projectstatic->thirdparty_name = $lines[$i]->thirdparty_name;
1770 $projectstatic->status = $lines[$i]->projectstatus;
1772 $taskstatic->id = $lines[$i]->id;
1773 $taskstatic->ref = ($lines[$i]->ref ? $lines[$i]->ref : $lines[$i]->id);
1774 $taskstatic->label = $lines[$i]->label;
1775 $taskstatic->date_start = $lines[$i]->date_start;
1776 $taskstatic->date_end = $lines[$i]->date_end;
1778 $thirdpartystatic->id = $lines[$i]->thirdparty_id;
1779 $thirdpartystatic->name = $lines[$i]->thirdparty_name;
1780 $thirdpartystatic->email = $lines[$i]->thirdparty_email;
1782 if (empty($oldprojectforbreak) || ($oldprojectforbreak != -1 && $oldprojectforbreak != $projectstatic->id)) {
1784 if (!empty($arrayfields[
't.planned_workload'][
'checked'])) {
1787 if (!empty($arrayfields[
't.progress'][
'checked'])) {
1790 foreach ($arrayfields as $key => $val) {
1791 if ($val[
'checked'] && substr($key, 0, 5) ==
'efpt.') {
1796 print
'<tr class="oddeven trforbreak nobold">'.
"\n";
1797 print
'<td colspan="'.(11 + $addcolspan).
'">';
1798 print $projectstatic->getNomUrl(1,
'', 0,
'<strong>'.$langs->transnoentitiesnoconv(
"YourRole").
':</strong> '.$projectsrole[$lines[$i]->fk_project]);
1799 if ($thirdpartystatic->id > 0) {
1800 print
' - '.$thirdpartystatic->getNomUrl(1);
1802 if ($projectstatic->title) {
1804 print
'<span class="secondary">'.$projectstatic->title.
'</span>';
1871 if ($oldprojectforbreak != -1) {
1872 $oldprojectforbreak = $projectstatic->id;
1875 print
'<tr class="oddeven" data-taskid="'.$lines[$i]->id.
'">'.
"\n";
1885 if (!empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT)) {
1886 print
'<td class="nowrap">';
1887 if ($oldprojectforbreak == -1) {
1888 print $projectstatic->getNomUrl(1,
'', 0, $langs->transnoentitiesnoconv(
"YourRole").
': '.$projectsrole[$lines[$i]->fk_project]);
1894 if (!empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT)) {
1895 print
'<td class="tdoverflowmax100">';
1896 if ($thirdpartystatic->id > 0) {
1897 print $thirdpartystatic->getNomUrl(1,
'project');
1903 print
'<td class="nowrap">';
1904 print
'<!-- Task id = '.$lines[$i]->id.
' -->';
1905 for ($k = 0; $k < $level; $k++) {
1906 print
'<div class="marginleftonly">';
1908 print $taskstatic->getNomUrl(1,
'withproject',
'time');
1911 print
'<span class="opacitymedium">'.$taskstatic->label.
'</span>';
1912 for ($k = 0; $k < $level; $k++) {
1918 $extrafieldsobjectkey =
'projet_task';
1919 $extrafieldsobjectprefix =
'efpt.';
1920 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1923 if (!empty($arrayfields[
't.planned_workload'][
'checked'])) {
1924 print
'<td class="leftborder plannedworkload right">';
1925 if ($lines[$i]->planned_workload) {
1933 if (!empty($arrayfields[
't.progress'][
'checked'])) {
1935 print
'<td class="right">';
1936 print $formother->select_percent($lines[$i]->progress, $lines[$i]->
id.
'progress');
1940 if (!empty($arrayfields[
'timeconsumed'][
'checked'])) {
1942 print
'<td class="right">';
1944 if ($lines[$i]->duration) {
1945 print
'<a href="'.DOL_URL_ROOT.
'/projet/tasks/time.php?id='.$lines[$i]->id.
'">';
1954 print
'<td class="right">';
1955 $tmptimespent = $taskstatic->getSummaryOfTimeSpent($fuser->id);
1956 if ($tmptimespent[
'total_duration']) {
1964 $disabledproject = 1;
1970 if ($lines[$i]->
public || !empty($projectsrole[$lines[$i]->fk_project]) || $user->rights->projet->all->creer) {
1971 $disabledproject = 0;
1975 if ($restricteditformytask && empty($tasksrole[$lines[$i]->
id])) {
1983 $modeinput =
'hours';
1984 for ($idw = 0; $idw < 7; $idw++) {
1988 if (!$isavailable[$tmpday][
'morning'] && !$isavailable[$tmpday][
'afternoon']) {
1989 $cssonholiday .=
'onholidayallday ';
1990 } elseif (!$isavailable[$tmpday][
'morning']) {
1991 $cssonholiday .=
'onholidaymorning ';
1992 } elseif (!$isavailable[$tmpday][
'afternoon']) {
1993 $cssonholiday .=
'onholidayafternoon ';
1997 $dayWorkLoad = $projectstatic->weekWorkLoadPerTask[$tmpday][$lines[$i]->id];
1998 $totalforeachday[$tmpday] += $dayWorkLoad;
2001 if ($dayWorkLoad > 0) {
2004 $alttitle = $langs->trans(
"AddHereTimeSpentForDay", $tmparray[
'day'], $tmparray[
'mon']);
2006 global $numstartworkingday, $numendworkingday;
2008 if (($idw + 1 < $numstartworkingday) || ($idw + 1 > $numendworkingday)) {
2009 $cssweekend =
'weekend';
2012 $disabledtaskday = $disabledtask;
2014 if (! $disabledtask && $restrictBefore && $tmpday < $restrictBefore) {
2015 $disabledtaskday = 1;
2018 $tableCell =
'<td class="center hide'.$idw.($cssonholiday ?
' '.$cssonholiday :
'').($cssweekend ?
' '.$cssweekend :
'').
'">';
2021 if ($alreadyspent) {
2022 $tableCell .=
'<span class="timesheetalreadyrecorded" title="texttoreplace"><input type="text" class="center smallpadd" size="2" disabled id="timespent['.$inc.
']['.$idw.
']" name="task['.$lines[$i]->id.
']['.$idw.
']" value="'.$alreadyspent.
'"></span>';
2026 $tableCell .=
'<input type="text" alt="'.($disabledtaskday ?
'' : $alttitle).
'" title="'.($disabledtaskday ?
'' : $alttitle).
'" '.($disabledtaskday ?
'disabled' : $placeholder).
' class="center smallpadd" size="2" id="timeadded['.$inc.
']['.$idw.
']" name="task['.$lines[$i]->id.
']['.$idw.
']" value="" cols="2" maxlength="5"';
2027 $tableCell .=
' onkeypress="return regexEvent(this,event,\'timeChar\')"';
2028 $tableCell .=
' onkeyup="updateTotal('.$idw.
',\''.$modeinput.
'\')
"';
2029 $tableCell .= ' onblur="regexEvent(
this,event,\
''.$modeinput.
'\'); updateTotal(
'.$idw.',\
''.$modeinput.
'\')
" />';
2030 $tableCell .= '</td>';
2035 print '<td class="right
">';
2036 if ((!$lines[$i]->public) && $disabledproject) {
2037 print $form->textwithpicto('', $langs->trans("UserIsNotContactOfProject
"));
2038 } elseif ($disabledtask) {
2039 $titleassigntask = $langs->trans("AssignTaskToMe
");
2040 if ($fuser->id != $user->id) {
2041 $titleassigntask = $langs->trans("AssignTaskToUser
", '...');
2044 print $form->textwithpicto('', $langs->trans("TaskIsNotAssignedToUser
", $titleassigntask));
2051 // Call to show task with a lower level (task under the current task)
2054 if ($lines[$i]->id > 0) {
2055 //var_dump('totalforeachday after taskid='.$lines[$i]->id.' and previous one on level '.$level);
2056 //var_dump($totalforeachday);
2057 $ret = projectLinesPerWeek($inc, $firstdaytoshow, $fuser, $lines[$i]->id, ($parent == 0 ? $lineswithoutlevel0 : $lines), $level, $projectsrole, $tasksrole, $mine, $restricteditformytask, $isavailable, $oldprojectforbreak, $arrayfields, $extrafields);
2058 //var_dump('ret with parent='.$lines[$i]->id.' level='.$level);
2060 foreach ($ret as $key => $val) {
2061 $totalforeachday[$key] += $val;
2063 //var_dump('totalforeachday after taskid='.$lines[$i]->id.' and previous one on level '.$level.' + subtasks');
2064 //var_dump($totalforeachday);
2072 return $totalforeachday;
2093 function projectLinesPerMonth(&$inc, $firstdaytoshow, $fuser, $parent, $lines, &$level, &$projectsrole, &$tasksrole, $mine, $restricteditformytask, &$isavailable, $oldprojectforbreak = 0, $TWeek = array())
2095 global $conf, $db, $user, $langs;
2096 global $form, $formother, $projectstatic, $taskstatic, $thirdpartystatic;
2098 $numlines = count($lines);
2101 $workloadforid = array();
2102 $totalforeachweek = array();
2103 $lineswithoutlevel0 = array();
2105 // Create a smaller array with sublevels only to be used later. This increase dramatically performances.
2106 if ($parent == 0) { // Always and only if at first level
2107 for ($i = 0; $i < $numlines; $i++) {
2108 if ($lines[$i]->fk_task_parent) {
2109 $lineswithoutlevel0[] = $lines[$i];
2114 //dol_syslog('projectLinesPerWeek inc='.$inc.' firstdaytoshow='.$firstdaytoshow.' task parent id='.$parent.' level='.$level." count(lines)=
".$numlines." count(lineswithoutlevel0)=
".count($lineswithoutlevel0));
2116 if (empty($oldprojectforbreak)) {
2117 $oldprojectforbreak = (empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT) ? 0 : -1); // 0 = start break, -1 = never break
2120 $restrictBefore = null;
2122 if (! empty($conf->global->PROJECT_TIMESHEET_PREVENT_AFTER_MONTHS)) {
2123 require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
2124 $restrictBefore = dol_time_plus_duree(dol_now(), - $conf->global->PROJECT_TIMESHEET_PREVENT_AFTER_MONTHS, 'm');
2127 for ($i = 0; $i < $numlines; $i++) {
2132 if ($lines[$i]->fk_task_parent == $parent) {
2133 // If we want all or we have a role on task, we show it
2134 if (empty($mine) || !empty($tasksrole[$lines[$i]->id])) {
2135 //dol_syslog("projectLinesPerWeek Found line
".$i.", a qualified task (i have role or want to show all tasks) with
id=
".$lines[$i]->id." project
id=
".$lines[$i]->fk_project);
2137 // Break on a new project
2138 if ($parent == 0 && $lines[$i]->fk_project != $lastprojectid) {
2139 $lastprojectid = $lines[$i]->fk_project;
2140 $projectstatic->id = $lines[$i]->fk_project;
2143 //var_dump('--- '.$level.' '.$firstdaytoshow.' '.$fuser->id.' '.$projectstatic->id.' '.$workloadforid[$projectstatic->id]);
2144 //var_dump($projectstatic->weekWorkLoadPerTask);
2145 if (empty($workloadforid[$projectstatic->id])) {
2146 $projectstatic->loadTimeSpentMonth($firstdaytoshow, 0, $fuser->id); // Load time spent from table projet_task_time for the project into this->weekWorkLoad and this->weekWorkLoadPerTask for all days of a week
2147 $workloadforid[$projectstatic->id] = 1;
2149 //var_dump($projectstatic->weekWorkLoadPerTask);
2150 //var_dump('--- '.$projectstatic->id.' '.$workloadforid[$projectstatic->id]);
2152 $projectstatic->id = $lines[$i]->fk_project;
2153 $projectstatic->ref = $lines[$i]->projectref;
2154 $projectstatic->title = $lines[$i]->projectlabel;
2155 $projectstatic->public = $lines[$i]->public;
2156 $projectstatic->thirdparty_name = $lines[$i]->thirdparty_name;
2157 $projectstatic->status = $lines[$i]->projectstatus;
2159 $taskstatic->id = $lines[$i]->id;
2160 $taskstatic->ref = ($lines[$i]->ref ? $lines[$i]->ref : $lines[$i]->id);
2161 $taskstatic->label = $lines[$i]->label;
2162 $taskstatic->date_start = $lines[$i]->date_start;
2163 $taskstatic->date_end = $lines[$i]->date_end;
2165 $thirdpartystatic->id = $lines[$i]->thirdparty_id;
2166 $thirdpartystatic->name = $lines[$i]->thirdparty_name;
2167 $thirdpartystatic->email = $lines[$i]->thirdparty_email;
2169 if (empty($oldprojectforbreak) || ($oldprojectforbreak != -1 && $oldprojectforbreak != $projectstatic->id)) {
2170 print '<tr class="oddeven trforbreak nobold
">'."\n
";
2171 print '<td colspan="'.(6 + count($TWeek)).'">';
2172 print $projectstatic->getNomUrl(1, '', 0, '<strong>'.$langs->transnoentitiesnoconv("YourRole
").':</strong> '.$projectsrole[$lines[$i]->fk_project]);
2173 if ($thirdpartystatic->id > 0) {
2174 print ' - '.$thirdpartystatic->getNomUrl(1);
2176 if ($projectstatic->title) {
2178 print '<span class="secondary
">'.$projectstatic->title.'</span>';
2184 if ($oldprojectforbreak != -1) {
2185 $oldprojectforbreak = $projectstatic->id;
2187 print '<tr class="oddeven
" data-taskid="'.$lines[$i]->id.'">'."\n
";
2191 print '<td class="nowrap
">';
2192 print $fuser->getNomUrl(1, 'withproject', 'time');
2197 /*print '<td class="nowrap
">';
2198 if ($oldprojectforbreak == -1) print $projectstatic->getNomUrl(1,'',0,$langs->transnoentitiesnoconv("YourRole
").': '.$projectsrole[$lines[$i]->fk_project]);
2202 /*print '<td class="tdoverflowmax100
">';
2203 if ($thirdpartystatic->id > 0) print $thirdpartystatic->getNomUrl(1, 'project');
2207 print '<td class="nowrap
">';
2208 print '<!-- Task id = '.$lines[$i]->id.' -->';
2209 for ($k = 0; $k < $level; $k++) {
2210 print '<div class="marginleftonly
">';
2212 print $taskstatic->getNomUrl(1, 'withproject', 'time');
2215 print '<span class="opacitymedium
">'.$taskstatic->label.'</span>';
2216 for ($k = 0; $k < $level; $k++) {
2222 print '<td class="leftborder plannedworkload right
">';
2223 if ($lines[$i]->planned_workload) {
2224 print convertSecondToTime($lines[$i]->planned_workload, 'allhourmin');
2230 // Progress declared %
2231 print '<td class="right
">';
2232 print $formother->select_percent($lines[$i]->progress, $lines[$i]->id.'progress');
2235 // Time spent by everybody
2236 print '<td class="right
">';
2237 // $lines[$i]->duration is a denormalised field = summ of time spent by everybody for task. What we need is time consumed by user
2238 if ($lines[$i]->duration) {
2239 print '<a href="'.DOL_URL_ROOT.'/projet/tasks/time.php?
id=
'.$lines[$i]->id.'">';
2240 print convertSecondToTime($lines[$i]->duration, 'allhourmin');
2247 // Time spent by user
2248 print '<td class="right
">';
2249 $tmptimespent = $taskstatic->getSummaryOfTimeSpent($fuser->id);
2250 if ($tmptimespent['total_duration']) {
2251 print convertSecondToTime($tmptimespent['total_duration'], 'allhourmin');
2257 $disabledproject = 1;
2259 //print "x
".$lines[$i]->fk_project;
2260 //var_dump($lines[$i]);
2261 //var_dump($projectsrole[$lines[$i]->fk_project]);
2262 // If at least one role for project
2263 if ($lines[$i]->public || !empty($projectsrole[$lines[$i]->fk_project]) || $user->rights->projet->all->creer) {
2264 $disabledproject = 0;
2267 // If $restricteditformytask is on and I have no role on task, i disable edit
2268 if ($restricteditformytask && empty($tasksrole[$lines[$i]->id])) {
2272 //var_dump($projectstatic->weekWorkLoadPerTask);
2274 // Fields to show current time
2276 $modeinput = 'hours';
2277 $TFirstDay = getFirstDayOfEachWeek($TWeek, date('Y', $firstdaytoshow));
2278 $TFirstDay[reset($TWeek)] = 1;
2280 $firstdaytoshowarray = dol_getdate($firstdaytoshow);
2281 $year = $firstdaytoshowarray['year'];
2282 $month = $firstdaytoshowarray['mon'];
2283 foreach ($TWeek as $weekIndex => $weekNb) {
2284 $weekWorkLoad = $projectstatic->monthWorkLoadPerTask[$weekNb][$lines[$i]->id];
2285 $totalforeachweek[$weekNb] += $weekWorkLoad;
2288 if ($weekWorkLoad > 0) {
2289 $alreadyspent = convertSecondToTime($weekWorkLoad, 'allhourmin');
2291 $alttitle = $langs->trans("AddHereTimeSpentForWeek
", $weekNb);
2293 $disabledtaskweek = $disabledtask;
2294 $firstdayofweek = dol_mktime(0, 0, 0, $month, $TFirstDay[$weekIndex], $year);
2296 if (! $disabledtask && $restrictBefore && $firstdayofweek < $restrictBefore) {
2297 $disabledtaskweek = 1;
2300 $tableCell = '<td class="center hide weekend
">';
2302 if ($alreadyspent) {
2303 $tableCell .= '<span class="timesheetalreadyrecorded
" title="texttoreplace
"><input type="text
" class="center smallpadd
" size="2
" disabled id="timespent[
'.$inc.'][
'.((int) $weekNb).']
" name="task[
'.$lines[$i]->id.'][
'.$weekNb.']
" value="'.$alreadyspent.'"></span>';
2304 //$placeholder=' placeholder="00:00
"';
2308 $tableCell .= '<input type="text
" alt="'.($disabledtaskweek ? '' : $alttitle).'" title="'.($disabledtaskweek ? '' : $alttitle).'" '.($disabledtaskweek ? 'disabled' : $placeholder).' class="center smallpadd
" size="2
" id="timeadded[
'.$inc.'][
'.((int) $weekNb).']
" name="task[
'.$lines[$i]->id.'][
'.($TFirstDay[$weekNb] - 1).']
" value="" cols="2
" maxlength="5
"';
2309 $tableCell .= ' onkeypress="return regexEvent(
this,event,\
'timeChar\')"';
2310 $tableCell .=
' onkeyup="updateTotal('.$weekNb.
',\''.$modeinput.
'\')
"';
2311 $tableCell .= ' onblur="regexEvent(
this,event,\
''.$modeinput.
'\'); updateTotal(
'.$weekNb.',\
''.$modeinput.
'\')
" />';
2312 $tableCell .= '</td>';
2317 print '<td class="right
">';
2318 if ((!$lines[$i]->public) && $disabledproject) {
2319 print $form->textwithpicto('', $langs->trans("UserIsNotContactOfProject
"));
2320 } elseif ($disabledtask) {
2321 $titleassigntask = $langs->trans("AssignTaskToMe
");
2322 if ($fuser->id != $user->id) {
2323 $titleassigntask = $langs->trans("AssignTaskToUser
", '...');
2326 print $form->textwithpicto('', $langs->trans("TaskIsNotAssignedToUser
", $titleassigntask));
2333 // Call to show task with a lower level (task under the current task)
2336 if ($lines[$i]->id > 0) {
2337 //var_dump('totalforeachday after taskid='.$lines[$i]->id.' and previous one on level '.$level);
2338 //var_dump($totalforeachday);
2339 $ret = projectLinesPerMonth($inc, $firstdaytoshow, $fuser, $lines[$i]->id, ($parent == 0 ? $lineswithoutlevel0 : $lines), $level, $projectsrole, $tasksrole, $mine, $restricteditformytask, $isavailable, $oldprojectforbreak, $TWeek);
2340 //var_dump('ret with parent='.$lines[$i]->id.' level='.$level);
2342 foreach ($ret as $key => $val) {
2343 $totalforeachweek[$key] += $val;
2345 //var_dump('totalforeachday after taskid='.$lines[$i]->id.' and previous one on level '.$level.' + subtasks');
2346 //var_dump($totalforeachday);
2354 return $totalforeachweek;
2367 function searchTaskInChild(&$inc, $parent, &$lines, &$taskrole)
2369 //print 'Search in line with parent id = '.$parent.'<br>';
2370 $numlines = count($lines);
2371 for ($i = 0; $i < $numlines; $i++) {
2372 // Process line $lines[$i]
2373 if ($lines[$i]->fk_parent == $parent && $lines[$i]->id != $lines[$i]->fk_parent) {
2374 // If task is legitimate to show, no more need to search deeper
2375 if (isset($taskrole[$lines[$i]->id])) {
2376 //print 'Found a legitimate task id='.$lines[$i]->id.'<br>';
2381 searchTaskInChild($inc, $lines[$i]->id, $lines, $taskrole);
2382 //print 'Found inc='.$inc.'<br>';
2406 function print_projecttasks_array($db, $form, $socid, $projectsListId, $mytasks = 0, $status = -1, $listofoppstatus = array(), $hiddenfields = array())
2408 global $langs, $conf, $user;
2409 global $theme_datacolor;
2411 require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
2413 $listofstatus = array_keys($listofoppstatus);
2415 if (is_array($listofstatus) && !empty($conf->global->USE_COLOR_FOR_PROSPECTION_STATUS)) {
2416 // Define $themeColorId and array $statusOppList for each $listofstatus
2418 $statusOppList = array();
2419 foreach ($listofstatus as $oppStatus) {
2420 $oppStatusCode = dol_getIdFromCode($db, $oppStatus, 'c_lead_status', 'rowid', 'code');
2421 if ($oppStatusCode) {
2422 $statusOppList[$oppStatus]['code'] = $oppStatusCode;
2423 $statusOppList[$oppStatus]['color'] = isset($theme_datacolor[$themeColorId]) ? implode(', ', $theme_datacolor[$themeColorId]) : '';
2429 $projectstatic = new Project($db);
2430 $thirdpartystatic = new Societe($db);
2434 $project_year_filter = 0;
2436 $title = $langs->trans("Projects");
2437 if (strcmp($status, '') && $status >= 0) {
2438 $title = $langs->trans("Projects").' '.$langs->trans($projectstatic->statuts_long[$status]);
2441 $arrayidtypeofcontact = array();
2443 print '<div class="div-table-responsive-no-min
">';
2444 print '<table class="noborder centpercent
">';
2446 $sql = " FROM
".MAIN_DB_PREFIX."projet as p
";
2448 $sql .= ",
".MAIN_DB_PREFIX."projet_task as t
";
2449 $sql .= ",
".MAIN_DB_PREFIX."element_contact as ec
";
2450 $sql .= ",
".MAIN_DB_PREFIX."c_type_contact as ctc
";
2452 $sql .= " LEFT JOIN
".MAIN_DB_PREFIX."projet_task as t ON p.rowid = t.fk_projet
";
2454 $sql .= " WHERE p.entity IN (
".getEntity('project').")
";
2455 $sql .= " AND p.rowid IN (
".$db->sanitize($projectsListId).")
";
2457 $sql .= " AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc =
".((int) $socid).")
";
2460 $sql .= " AND p.rowid = t.fk_projet
";
2461 $sql .= " AND ec.element_id = t.rowid
";
2462 $sql .= " AND ec.fk_socpeople =
".((int) $user->id);
2463 $sql .= " AND ec.fk_c_type_contact = ctc.rowid
"; // Replace the 2 lines with ec.fk_c_type_contact in $arrayidtypeofcontact
2464 $sql .= " AND ctc.element =
'project_task'";
2467 $sql .= " AND p.fk_statut =
".(int) $status;
2469 if (!empty($conf->global->PROJECT_LIMIT_YEAR_RANGE)) {
2470 $project_year_filter = GETPOST("project_year_filter
");
2471 //Check if empty or invalid year. Wildcard ignores the sql check
2472 if ($project_year_filter != "*
") {
2473 if (empty($project_year_filter) || !ctype_digit($project_year_filter)) {
2474 $project_year_filter = date("Y
");
2476 $sql .= " AND (p.dateo IS NULL OR p.dateo <=
".$db->idate(dol_get_last_day($project_year_filter, 12, false)).")
";
2477 $sql .= " AND (p.datee IS NULL OR p.datee >=
".$db->idate(dol_get_first_day($project_year_filter, 1, false)).")
";
2481 // Get id of project we must show tasks
2482 $arrayidofprojects = array();
2483 $sql1 = "SELECT p.rowid as projectid
";
2485 $resql = $db->query($sql1);
2488 $num = $db->num_rows($resql);
2490 $objp = $db->fetch_object($resql);
2491 $arrayidofprojects[$objp->projectid] = $objp->projectid;
2495 dol_print_error($db);
2497 if (empty($arrayidofprojects)) {
2498 $arrayidofprojects[0] = -1;
2501 // Get list of project with calculation on tasks
2502 $sql2 = "SELECT p.rowid as projectid, p.ref, p.title, p.fk_soc,
";
2503 $sql2 .= " s.rowid as socid, s.nom as socname, s.name_alias,
";
2504 $sql2 .= " s.code_client, s.code_compta, s.client,
";
2505 $sql2 .= " s.code_fournisseur, s.code_compta_fournisseur, s.fournisseur,
";
2506 $sql2 .= " s.logo, s.email, s.entity,
";
2507 $sql2 .= " p.fk_user_creat, p.public, p.fk_statut as status, p.fk_opp_status as opp_status, p.opp_percent, p.opp_amount,
";
2508 $sql2 .= " p.dateo, p.datee,
";
2509 $sql2 .= " COUNT(t.rowid) as nb, SUM(t.planned_workload) as planned_workload, SUM(t.planned_workload * t.progress / 100) as declared_progess_workload";
2510 $sql2 .= " FROM ".MAIN_DB_PREFIX."projet as p";
2511 $sql2 .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s ON s.
rowid = p.fk_soc";
2512 $sql2 .= " LEFT JOIN ".MAIN_DB_PREFIX."projet_task as t ON p.
rowid = t.fk_projet";
2513 $sql2 .= " WHERE p.
rowid IN (".$db->sanitize(join(',', $arrayidofprojects)).")";
2514 $sql2 .= " GROUP BY p.
rowid, p.
ref, p.title, p.fk_soc, s.
rowid, s.nom, s.name_alias, s.code_client, s.code_compta, s.client, s.code_fournisseur, s.code_compta_fournisseur, s.fournisseur,";
2515 $sql2 .= " s.logo, s.email, s.entity, p.fk_user_creat, p.public, p.fk_statut, p.fk_opp_status, p.opp_percent, p.opp_amount, p.dateo, p.datee";
2516 $sql2 .= " ORDER BY p.title, p.
ref";
2518 $resql = $db->query($sql2);
2521 $total_opp_amount = 0;
2522 $ponderated_opp_amount = 0;
2524 $num = $db->num_rows(
$resql);
2527 print
'<tr class="liste_titre">';
2528 print_liste_field_titre($title.
'<a href="'.DOL_URL_ROOT.
'/projet/list.php?search_status='.((
int) $status).
'"><span class="badge marginleftonlyshort">'.$num.
'</span></a>', $_SERVER[
"PHP_SELF"],
"",
"",
"",
"", $sortfield, $sortorder);
2530 if (!empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
2531 if (!in_array(
'prospectionstatus', $hiddenfields)) {
2532 print_liste_field_titre(
"OpportunityStatus",
"",
"",
"",
"",
'style="max-width: 100px"', $sortfield, $sortorder,
'center ');
2534 print_liste_field_titre(
$form->textwithpicto($langs->trans(
"Amount"), $langs->trans(
"OpportunityAmount").
' ('.$langs->trans(
"Tooltip").
' = '.$langs->trans(
"OpportunityWeightedAmount").
')'),
"",
"",
"",
"",
'style="max-width: 100px"', $sortfield, $sortorder,
'right ');
2537 if (empty($conf->global->PROJECT_HIDE_TASKS)) {
2539 if (!in_array(
'plannedworkload', $hiddenfields)) {
2540 print_liste_field_titre(
"PlannedWorkload",
"",
"",
"",
"",
'style="max-width: 100px"', $sortfield, $sortorder,
'right ');
2542 if (!in_array(
'declaredprogress', $hiddenfields)) {
2543 print_liste_field_titre(
"%",
"",
"",
"",
"",
'', $sortfield, $sortorder,
'right ', $langs->trans(
"ProgressDeclared"));
2546 if (!in_array(
'projectstatus', $hiddenfields)) {
2551 $total_plannedworkload = 0;
2552 $total_declaredprogressworkload = 0;
2554 $objp = $db->fetch_object(
$resql);
2556 $projectstatic->id = $objp->projectid;
2557 $projectstatic->user_author_id = $objp->fk_user_creat;
2558 $projectstatic->public = $objp->public;
2561 $userAccess = $projectstatic->restrictedProjectArea($user);
2562 if ($userAccess >= 0) {
2563 $projectstatic->ref = $objp->ref;
2564 $projectstatic->status = $objp->status;
2565 $projectstatic->title = $objp->title;
2566 $projectstatic->date_end = $db->jdate($objp->datee);
2567 $projectstatic->date_start = $db->jdate($objp->dateo);
2569 print
'<tr class="oddeven">';
2571 print
'<td class="tdoverflowmax150">';
2572 print $projectstatic->getNomUrl(1,
'', 0,
'',
'-', 0, -1,
'nowraponall');
2573 if (!in_array(
'projectlabel', $hiddenfields)) {
2574 print
'<br><span class="opacitymedium">'.dol_trunc($objp->title, 24).
'</span>';
2578 print
'<td class="nowraponall tdoverflowmax100">';
2579 if ($objp->fk_soc > 0) {
2580 $thirdpartystatic->id = $objp->socid;
2581 $thirdpartystatic->name = $objp->socname;
2584 $thirdpartystatic->code_compta = $objp->code_compta;
2585 $thirdpartystatic->client = $objp->client;
2587 $thirdpartystatic->code_compta_fournisseur = $objp->code_compta_fournisseur;
2588 $thirdpartystatic->fournisseur = $objp->fournisseur;
2589 $thirdpartystatic->logo = $objp->logo;
2590 $thirdpartystatic->email = $objp->email;
2591 $thirdpartystatic->entity = $objp->entity;
2592 print $thirdpartystatic->getNomUrl(1);
2596 if (!empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
2597 if (!in_array(
'prospectionstatus', $hiddenfields)) {
2598 print
'<td class="center tdoverflowmax75">';
2600 if (empty($conf->global->USE_COLOR_FOR_PROSPECTION_STATUS)) {
2601 $oppStatusCode =
dol_getIdFromCode($db, $objp->opp_status,
'c_lead_status',
'rowid',
'code');
2602 if ($langs->trans(
"OppStatus".$oppStatusCode) !=
"OppStatus".$oppStatusCode) {
2603 print $langs->trans(
"OppStatus".$oppStatusCode);
2606 if (isset($statusOppList[$objp->opp_status])) {
2607 $oppStatusCode = $statusOppList[$objp->opp_status][
'code'];
2608 $oppStatusColor = $statusOppList[$objp->opp_status][
'color'];
2610 $oppStatusCode =
dol_getIdFromCode($db, $objp->opp_status,
'c_lead_status',
'rowid',
'code');
2611 $oppStatusColor =
'';
2613 if ($oppStatusCode) {
2614 if (!empty($oppStatusColor)) {
2615 print
'<a href="'.dol_buildpath(
'/projet/list.php?search_opp_status='.$objp->opp_status, 1).
'" style="display: inline-block; width: 4px; border: 5px solid rgb('.$oppStatusColor.
'); border-radius: 2px;" title="'.$langs->trans(
"OppStatus".$oppStatusCode).
'"></a>';
2617 print
'<a href="'.dol_buildpath(
'/projet/list.php?search_opp_status='.$objp->opp_status, 1).
'" title="'.$langs->trans(
"OppStatus".$oppStatusCode).
'">'.$oppStatusCode.
'</a>';
2624 print
'<td class="right">';
2625 if ($objp->opp_percent && $objp->opp_amount) {
2626 $opp_weighted_amount = $objp->opp_percent * $objp->opp_amount / 100;
2627 $alttext = $langs->trans(
"OpportunityWeightedAmount").
' '.
price($opp_weighted_amount, 0,
'', 1, -1, 0, $conf->currency);
2628 $ponderated_opp_amount +=
price2num($opp_weighted_amount);
2630 if ($objp->opp_amount) {
2631 print
'<span class="amount" title="'.$alttext.
'">'.
$form->textwithpicto(
price($objp->opp_amount, 0,
'', 1, -1, 0), $alttext).
'</span>';
2636 if (empty($conf->global->PROJECT_HIDE_TASKS)) {
2637 print
'<td class="right">'.$objp->nb.
'</td>';
2639 $plannedworkload = $objp->planned_workload;
2640 $total_plannedworkload += $plannedworkload;
2641 if (!in_array(
'plannedworkload', $hiddenfields)) {
2642 print
'<td class="right">'.($plannedworkload ?
convertSecondToTime($plannedworkload) :
'').
'</td>';
2644 if (!in_array(
'declaredprogress', $hiddenfields)) {
2645 $declaredprogressworkload = $objp->declared_progess_workload;
2646 $total_declaredprogressworkload += $declaredprogressworkload;
2647 print
'<td class="right">';
2649 print ($plannedworkload ?round(100 * $declaredprogressworkload / $plannedworkload, 0).
'%' :
'');
2654 if (!in_array(
'projectstatus', $hiddenfields)) {
2655 print
'<td class="right">';
2656 print $projectstatic->getLibStatut(3);
2662 $total_task = $total_task + $objp->nb;
2663 $total_opp_amount = $total_opp_amount + $objp->opp_amount;
2669 print
'<tr class="liste_total">';
2670 print
'<td>'.$langs->trans(
"Total").
"</td><td></td>";
2671 if (!empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
2672 if (!in_array(
'prospectionstatus', $hiddenfields)) {
2673 print
'<td class="liste_total"></td>';
2675 print
'<td class="liste_total right">';
2677 print
$form->textwithpicto(
price($total_opp_amount, 0,
'', 1, -1, 0), $langs->trans(
"OpportunityPonderatedAmountDesc").
' : '.
price($ponderated_opp_amount, 0,
'', 1, -1, 0, $conf->currency));
2680 if (empty($conf->global->PROJECT_HIDE_TASKS)) {
2681 print
'<td class="liste_total right">'.$total_task.
'</td>';
2682 if (!in_array(
'plannedworkload', $hiddenfields)) {
2683 print
'<td class="liste_total right">'.($total_plannedworkload ?
convertSecondToTime($total_plannedworkload) :
'').
'</td>';
2685 if (!in_array(
'declaredprogress', $hiddenfields)) {
2686 print
'<td class="liste_total right">'.($total_plannedworkload ?round(100 * $total_declaredprogressworkload / $total_plannedworkload, 0).
'%' :
'').
'</td>';
2689 if (!in_array(
'projectstatus', $hiddenfields)) {
2690 print
'<td class="liste_total"></td>';
2702 if (!empty($conf->global->PROJECT_LIMIT_YEAR_RANGE)) {
2704 print
'<form method="get" action="'.$_SERVER[
"PHP_SELF"].
'">';
2705 print
'<table width="100%">';
2707 print
'<td>'.$langs->trans(
"Year").
'</td>';
2708 print
'<td class="right"><input type="text" size="4" class="flat" name="project_year_filter" value="'.$project_year_filter.
'"/>';
2710 print
'</table></form>';
2723 function getTaskProgressView($task, $label =
true, $progressNumber =
true, $hideOnProgressNull =
false, $spaced =
false)
2725 global $langs, $conf;
2729 $plannedworkloadoutputformat =
'allhourmin';
2730 $timespentoutputformat =
'allhourmin';
2731 if (!empty($conf->global->PROJECT_PLANNED_WORKLOAD_FORMAT)) {
2732 $plannedworkloadoutputformat = $conf->global->PROJECT_PLANNED_WORKLOAD_FORMAT;
2734 if (!empty($conf->global->PROJECT_TIMES_SPENT_FORMAT)) {
2735 $timespentoutputformat = $conf->global->PROJECT_TIME_SPENT_FORMAT;
2738 if (empty($task->progress) && !empty($hideOnProgressNull)) {
2742 $spaced = !empty($spaced) ?
'spaced' :
'';
2747 $progressBarClass =
'progress-bar-info';
2748 $progressCalculated = 0;
2749 if ($task->planned_workload) {
2750 $progressCalculated = round(100 * floatval($task->duration_effective) / floatval($task->planned_workload), 2);
2753 $warningRatio = !empty($conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT) ? (1 + $conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT / 100) : 1.10;
2755 $diffTitle =
'<br>'.$langs->trans(
'ProgressDeclared').
' : '.$task->progress.($task->progress ?
'%' :
'');
2756 $diffTitle .=
'<br>'.$langs->trans(
'ProgressCalculated').
' : '.$progressCalculated.($progressCalculated ?
'%' :
'');
2759 if (floatval($progressCalculated) > floatval($task->progress * $warningRatio)) {
2760 $progressBarClass =
'progress-bar-danger';
2761 $title = $langs->trans(
'TheReportedProgressIsLessThanTheCalculatedProgressionByX', abs($task->progress - $progressCalculated).
' '.$langs->trans(
"point"));
2762 $diff =
'<span class="text-danger classfortooltip paddingrightonly" title="'.dol_htmlentities($title.$diffTitle).
'" ><i class="fa fa-caret-down"></i> '.($task->progress - $progressCalculated).
'%</span>';
2763 } elseif (floatval($progressCalculated) > floatval($task->progress)) {
2764 $progressBarClass =
'progress-bar-warning';
2765 $title = $langs->trans(
'TheReportedProgressIsLessThanTheCalculatedProgressionByX', abs($task->progress - $progressCalculated).
' '.$langs->trans(
"point"));
2766 $diff =
'<span class="text-warning classfortooltip paddingrightonly" title="'.dol_htmlentities($title.$diffTitle).
'" ><i class="fa fa-caret-left"></i> '.($task->progress - $progressCalculated).
'%</span>';
2768 $progressBarClass =
'progress-bar-success';
2769 $title = $langs->trans(
'TheReportedProgressIsMoreThanTheCalculatedProgressionByX', ($task->progress - $progressCalculated).
' '.$langs->trans(
"point"));
2770 $diff =
'<span class="text-success classfortooltip paddingrightonly" title="'.dol_htmlentities($title.$diffTitle).
'" ><i class="fa fa-caret-up"></i> '.($task->progress - $progressCalculated).
'%</span>';
2774 $out .=
'<div class="progress-group">';
2776 if ($label !==
false) {
2777 $out .=
' <span class="progress-text">';
2779 if ($label !==
true) {
2788 if ($progressNumber !==
false) {
2789 $out .=
' <span class="progress-number">';
2790 if ($progressNumber !==
true) {
2791 $out .= $progressNumber;
2793 if ($task->hasDelay()) {
2797 $url = DOL_URL_ROOT.
'/projet/tasks/time.php?id='.$task->id;
2799 $out .= !empty($diff) ? $diff.
' ' :
'';
2800 $out .=
'<a href="'.$url.
'" >';
2801 $out .=
'<b title="'.$langs->trans(
'TimeSpent').
'" >';
2802 if ($task->duration_effective) {
2812 $out .=
'<a href="'.$url.
'" >';
2813 $out .=
'<span title="'.$langs->trans(
'PlannedWorkload').
'" >';
2814 if ($task->planned_workload) {
2826 $out .=
' <div class="progress sm '.$spaced.
'">';
2827 $diffval = floatval($task->progress) - floatval($progressCalculated);
2828 if ($diffval >= 0) {
2830 $out .=
' <div class="progress-bar '.$progressBarClass.
'" style="width: '.floatval($task->progress).
'%" title="'.floatval($task->progress).
'%">';
2831 if (!empty($task->progress)) {
2832 $out .=
' <div class="progress-bar progress-bar-consumed" style="width: '.floatval($progressCalculated / $task->progress * 100).
'%" title="'.floatval($progressCalculated).
'%"></div>';
2837 $out .=
' <div class="progress-bar progress-bar-consumed-late" style="width: '.floatval($progressCalculated).
'%" title="'.floatval($progressCalculated).
'%">';
2838 $out .=
' <div class="progress-bar '.$progressBarClass.
'" style="width: '.($task->progress ? floatval($task->progress / $progressCalculated * 100).
'%' :
'1px').
'" title="'.floatval($task->progress).
'%"></div>';
2857 global $conf, $langs;
2861 if ($task->progress !=
'') {
2865 $badgeClass =
'badge ';
2866 if ($task->planned_workload) {
2867 $progressCalculated = round(100 * floatval($task->duration_effective) / floatval($task->planned_workload), 2);
2870 $warningRatio = !empty($conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT) ? (1 + $conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT / 100) : 1.10;
2872 if (floatval($progressCalculated) > floatval($task->progress * $warningRatio)) {
2873 $badgeClass .=
'badge-danger';
2874 if (empty($tooltip)) {
2875 $tooltip = $task->progress.
'% < '.$langs->trans(
"TimeConsumed").
' '.$progressCalculated.
'%';
2877 } elseif (floatval($progressCalculated) > floatval($task->progress)) {
2878 $badgeClass .=
'badge-warning';
2879 if (empty($tooltip)) {
2880 $tooltip = $task->progress.
'% < '.$langs->trans(
"TimeConsumed").
' '.$progressCalculated.
'%';
2883 $badgeClass .=
'badge-success';
2884 if (empty($tooltip)) {
2885 $tooltip = $task->progress.
'% >= '.$langs->trans(
"TimeConsumed").
' '.$progressCalculated.
'%';
2892 if (!empty($tooltip)) {
2893 $badgeClass .=
' classfortooltip';
2894 $title =
'title="'.dol_htmlentities($tooltip).
'"';
2897 if (empty($label)) {
2898 $label = $task->progress.
' %';
2901 if (!empty($label)) {
2902 $out =
'<span class="'.$badgeClass.
'" '.$title.
' >'.$label.
'</span>';