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.dateo'][
'checked'])) {
926 if (count($arrayfields) > 0 && !empty($arrayfields[
't.datee'][
'checked'])) {
929 if (count($arrayfields) > 0 && !empty($arrayfields[
't.planned_workload'][
'checked'])) {
930 print
'<td class="nowrap liste_total right">';
934 if (count($arrayfields) > 0 && !empty($arrayfields[
't.duration_effective'][
'checked'])) {
935 print
'<td class="nowrap liste_total right">';
936 if ($projectidfortotallink > 0) {
937 print
'<a href="'.DOL_URL_ROOT.
'/projet/tasks/time.php?projectid='.$projectidfortotallink.($showproject ?
'' :
'&withproject=1').
'">';
940 if ($projectidfortotallink > 0) {
946 if ($total_projectlinesa_planned) {
947 $totalAverageDeclaredProgress = round(100 * $total_projectlinesa_declared_if_planned / $total_projectlinesa_planned, 2);
948 $totalCalculatedProgress = round(100 * $total_projectlinesa_spent / $total_projectlinesa_planned, 2);
951 $warningRatio = !empty($conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT) ? (1 + $conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT / 100) : 1.10;
954 $progressBarClass =
'progress-bar-info';
955 $badgeClass =
'badge ';
957 if ($totalCalculatedProgress > $totalAverageDeclaredProgress) {
958 $progressBarClass =
'progress-bar-danger';
959 $badgeClass .=
'badge-danger';
960 } elseif ($totalCalculatedProgress * $warningRatio >= $totalAverageDeclaredProgress) {
961 $progressBarClass =
'progress-bar-warning';
962 $badgeClass .=
'badge-warning';
964 $progressBarClass =
'progress-bar-success';
965 $badgeClass .=
'badge-success';
970 if (count($arrayfields) > 0 && !empty($arrayfields[
't.progress_calculated'][
'checked'])) {
971 print
'<td class="nowrap liste_total right">';
972 if ($total_projectlinesa_planned) {
973 print $totalCalculatedProgress.
' %';
979 if (count($arrayfields) > 0 && !empty($arrayfields[
't.progress'][
'checked'])) {
980 print
'<td class="nowrap liste_total right">';
981 if ($total_projectlinesa_planned) {
982 print
'<span class="'.$badgeClass.
'" >'.$totalAverageDeclaredProgress.
' %</span>';
989 if (count($arrayfields) > 0 && !empty($arrayfields[
't.progress_summary'][
'checked'])) {
990 print
'<td class="right">';
991 if ($total_projectlinesa_planned) {
993 print
' <div class="progress sm" title="'.$totalAverageDeclaredProgress.
'%" >';
994 print
' <div class="progress-bar '.$progressBarClass.
'" style="width: '.$totalAverageDeclaredProgress.
'%"></div>';
1001 if ($showbilltime) {
1002 if (count($arrayfields) > 0 && !empty($arrayfields[
't.tobill'][
'checked'])) {
1003 print
'<td class="nowrap liste_total right">';
1007 if (count($arrayfields) > 0 && !empty($arrayfields[
't.billed'][
'checked'])) {
1008 print
'<td class="nowrap liste_total right">';
1015 if (count($arrayfields) > 0 && !empty($arrayfields[
't.budget_amount'][
'checked'])) {
1016 print
'<td class="nowrap liste_total center">';
1017 if (strcmp($total_budget_amount,
'')) {
1018 print
price($total_budget_amount, 0, $langs, 1, 0, 0, $conf->currency);
1024 if (!empty($conf->global->PROJECT_SHOW_CONTACTS_IN_LIST)) {
1028 if (count($arrayfields) > 0 && !empty($arrayfields[
'c.assigned'][
'checked'])) {
1031 print
'<td class=""></td>';
1056 function projectLinesPerAction(&$inc, $parent, $fuser, $lines, &$level, &$projectsrole, &$tasksrole, $mine, $restricteditformytask, $preselectedday, &$isavailable, $oldprojectforbreak = 0)
1058 global $conf, $db, $user, $langs;
1059 global
$form, $formother, $projectstatic, $taskstatic, $thirdpartystatic;
1062 $totalforeachline = array();
1063 $workloadforid = array();
1064 $lineswithoutlevel0 = array();
1066 $numlines = count($lines);
1070 for ($i = 0; $i < $numlines; $i++) {
1071 if ($lines[$i]->fk_task_parent) {
1072 $lineswithoutlevel0[] = $lines[$i];
1077 if (empty($oldprojectforbreak)) {
1078 $oldprojectforbreak = (empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT) ? 0 : -1);
1082 for ($i = 0; $i < $numlines; $i++) {
1090 if (empty($mine) || !empty($tasksrole[$lines[$i]->
id])) {
1094 if ($parent == 0 && $lines[$i]->fk_project != $lastprojectid) {
1095 $lastprojectid = $lines[$i]->fk_project;
1096 if ($preselectedday) {
1097 $projectstatic->id = $lines[$i]->fk_project;
1101 if (empty($workloadforid[$projectstatic->id])) {
1102 if ($preselectedday) {
1103 $projectstatic->loadTimeSpent($preselectedday, 0, $fuser->id);
1104 $workloadforid[$projectstatic->id] = 1;
1108 $projectstatic->id = $lines[$i]->fk_project;
1109 $projectstatic->ref = $lines[$i]->project_ref;
1110 $projectstatic->title = $lines[$i]->project_label;
1111 $projectstatic->public = $lines[$i]->public;
1112 $projectstatic->status = $lines[$i]->project_status;
1114 $taskstatic->id = $lines[$i]->task_id;
1115 $taskstatic->ref = ($lines[$i]->task_ref ? $lines[$i]->task_ref : $lines[$i]->task_id);
1116 $taskstatic->label = $lines[$i]->task_label;
1117 $taskstatic->date_start = $lines[$i]->date_start;
1118 $taskstatic->date_end = $lines[$i]->date_end;
1120 $thirdpartystatic->id = $lines[$i]->socid;
1121 $thirdpartystatic->name = $lines[$i]->thirdparty_name;
1122 $thirdpartystatic->email = $lines[$i]->thirdparty_email;
1124 if (empty($oldprojectforbreak) || ($oldprojectforbreak != -1 && $oldprojectforbreak != $projectstatic->id)) {
1125 print
'<tr class="oddeven trforbreak nobold">'.
"\n";
1126 print
'<td colspan="11">';
1127 print $projectstatic->getNomUrl(1,
'', 0, $langs->transnoentitiesnoconv(
"YourRole").
': '.$projectsrole[$lines[$i]->fk_project]);
1128 if ($projectstatic->title) {
1130 print $projectstatic->title;
1136 if ($oldprojectforbreak != -1) {
1137 $oldprojectforbreak = $projectstatic->id;
1140 print
'<tr class="oddeven">'.
"\n";
1151 if ($oldprojectforbreak == -1) {
1152 print $projectstatic->getNomUrl(1,
'', 0, $langs->transnoentitiesnoconv(
"YourRole").
': '.$projectsrole[$lines[$i]->fk_project]);
1153 print
'<br>'.$projectstatic->title;
1158 print
'<td class="tdoverflowmax100">';
1159 if ($thirdpartystatic->id > 0) {
1160 print $thirdpartystatic->getNomUrl(1,
'project', 10);
1166 print
'<!-- Task id = '.$lines[$i]->id.
' -->';
1167 for ($k = 0; $k < $level; $k++) {
1168 print
" ";
1170 print $taskstatic->getNomUrl(1,
'withproject',
'time');
1173 for ($k = 0; $k < $level; $k++) {
1174 print
" ";
1176 print $taskstatic->label;
1183 print
'<td class="center">';
1187 $disabledproject = 1;
1193 if ($lines[$i]->
public || !empty($projectsrole[$lines[$i]->fk_project]) || $user->rights->projet->all->creer) {
1194 $disabledproject = 0;
1198 if ($restricteditformytask && empty($tasksrole[$lines[$i]->
id])) {
1203 print
'<td class="nowrap center">';
1208 if (!$isavailable[$preselectedday][
'morning'] && !$isavailable[$preselectedday][
'afternoon']) {
1209 $cssonholiday .=
'onholidayallday ';
1210 } elseif (!$isavailable[$preselectedday][
'morning']) {
1211 $cssonholiday .=
'onholidaymorning ';
1212 } elseif (!$isavailable[$preselectedday][
'afternoon']) {
1213 $cssonholiday .=
'onholidayafternoon ';
1217 print
'<td class="duration'.($cssonholiday ?
' '.$cssonholiday :
'').
' center">';
1219 $dayWorkLoad = $lines[$i]->timespent_duration;
1220 $totalforeachline[$preselectedday] += $lines[$i]->timespent_duration;
1223 if ($dayWorkLoad > 0) {
1241 print
'<td class="center">';
1242 print
'<textarea name="'.$lines[$i]->id.
'note" rows="'.ROWS_2.
'" id="'.$lines[$i]->id.
'note"'.($disabledtask ?
' disabled="disabled"' :
'').
'>';
1243 print $lines[$i]->timespent_note;
1244 print
'</textarea>';
1248 print
'<td class="right">';
1268 return $totalforeachline;
1291 function projectLinesPerDay(&$inc, $parent, $fuser, $lines, &$level, &$projectsrole, &$tasksrole, $mine, $restricteditformytask, $preselectedday, &$isavailable, $oldprojectforbreak = 0, $arrayfields = array(), $extrafields =
null)
1293 global $conf, $db, $user, $langs;
1294 global
$form, $formother, $projectstatic, $taskstatic, $thirdpartystatic;
1297 $totalforeachday = array();
1298 $workloadforid = array();
1299 $lineswithoutlevel0 = array();
1301 $numlines = count($lines);
1305 for ($i = 0; $i < $numlines; $i++) {
1306 if ($lines[$i]->fk_task_parent) {
1307 $lineswithoutlevel0[] = $lines[$i];
1312 if (empty($oldprojectforbreak)) {
1313 $oldprojectforbreak = (empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT) ? 0 : -1);
1316 $restrictBefore =
null;
1318 if (! empty($conf->global->PROJECT_TIMESHEET_PREVENT_AFTER_MONTHS)) {
1319 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
1324 for ($i = 0; $i < $numlines; $i++) {
1329 if ($lines[$i]->fk_task_parent == $parent) {
1333 if (empty($mine) || !empty($tasksrole[$lines[$i]->
id])) {
1336 if ($restricteditformytask == 2 && empty($tasksrole[$lines[$i]->
id])) {
1341 if ($parent == 0 && $lines[$i]->fk_project != $lastprojectid) {
1342 $lastprojectid = $lines[$i]->fk_project;
1343 if ($preselectedday) {
1344 $projectstatic->id = $lines[$i]->fk_project;
1348 if (empty($workloadforid[$projectstatic->id])) {
1349 if ($preselectedday) {
1350 $projectstatic->loadTimeSpent($preselectedday, 0, $fuser->id);
1351 $workloadforid[$projectstatic->id] = 1;
1355 $projectstatic->id = $lines[$i]->fk_project;
1356 $projectstatic->ref = $lines[$i]->projectref;
1357 $projectstatic->title = $lines[$i]->projectlabel;
1358 $projectstatic->public = $lines[$i]->public;
1359 $projectstatic->status = $lines[$i]->projectstatus;
1361 $taskstatic->id = $lines[$i]->id;
1362 $taskstatic->ref = ($lines[$i]->ref ? $lines[$i]->ref : $lines[$i]->id);
1363 $taskstatic->label = $lines[$i]->label;
1364 $taskstatic->date_start = $lines[$i]->date_start;
1365 $taskstatic->date_end = $lines[$i]->date_end;
1367 $thirdpartystatic->id = $lines[$i]->socid;
1368 $thirdpartystatic->name = $lines[$i]->thirdparty_name;
1369 $thirdpartystatic->email = $lines[$i]->thirdparty_email;
1371 if (empty($oldprojectforbreak) || ($oldprojectforbreak != -1 && $oldprojectforbreak != $projectstatic->id)) {
1373 if (!empty($arrayfields[
't.planned_workload'][
'checked'])) {
1376 if (!empty($arrayfields[
't.progress'][
'checked'])) {
1379 foreach ($arrayfields as $key => $val) {
1380 if ($val[
'checked'] && substr($key, 0, 5) ==
'efpt.') {
1385 print
'<tr class="oddeven trforbreak nobold">'.
"\n";
1386 print
'<td colspan="'.(7 + $addcolspan).
'">';
1387 print $projectstatic->getNomUrl(1,
'', 0,
'<strong>'.$langs->transnoentitiesnoconv(
"YourRole").
':</strong> '.$projectsrole[$lines[$i]->fk_project]);
1388 if ($thirdpartystatic->id > 0) {
1389 print
' - '.$thirdpartystatic->getNomUrl(1);
1391 if ($projectstatic->title) {
1393 print
'<span class="secondary">'.$projectstatic->title.
'</span>';
1460 if ($oldprojectforbreak != -1) {
1461 $oldprojectforbreak = $projectstatic->id;
1464 print
'<tr class="oddeven" data-taskid="'.$lines[$i]->id.
'">'.
"\n";
1474 if (!empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT)) {
1476 if ($oldprojectforbreak == -1) {
1477 print $projectstatic->getNomUrl(1,
'', 0, $langs->transnoentitiesnoconv(
"YourRole").
': '.$projectsrole[$lines[$i]->fk_project]);
1483 if (!empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT)) {
1484 print
'<td class="tdoverflowmax100">';
1485 if ($thirdpartystatic->id > 0) {
1486 print $thirdpartystatic->getNomUrl(1,
'project', 10);
1493 print
'<!-- Task id = '.$lines[$i]->id.
' -->';
1494 for ($k = 0; $k < $level; $k++) {
1495 print
'<div class="marginleftonly">';
1497 print $taskstatic->getNomUrl(1,
'withproject',
'time');
1500 print
'<span class="opacitymedium">'.$taskstatic->label.
'</a>';
1501 for ($k = 0; $k < $level; $k++) {
1507 $extrafieldsobjectkey =
'projet_task';
1508 $extrafieldsobjectprefix =
'efpt.';
1509 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1512 if (!empty($arrayfields[
't.planned_workload'][
'checked'])) {
1513 print
'<td class="leftborder plannedworkload right">';
1514 if ($lines[$i]->planned_workload) {
1523 if (!empty($arrayfields[
't.progress'][
'checked'])) {
1524 print
'<td class="right">';
1525 print $formother->select_percent($lines[$i]->progress, $lines[$i]->
id.
'progress');
1529 if (!empty($arrayfields[
'timeconsumed'][
'checked'])) {
1531 print
'<td class="right">';
1533 if ($lines[$i]->duration) {
1534 print
'<a href="'.DOL_URL_ROOT.
'/projet/tasks/time.php?id='.$lines[$i]->id.
'">';
1543 print
'<td class="right">';
1544 $tmptimespent = $taskstatic->getSummaryOfTimeSpent($fuser->id);
1545 if ($tmptimespent[
'total_duration']) {
1553 $disabledproject = 1;
1559 if ($lines[$i]->
public || !empty($projectsrole[$lines[$i]->fk_project]) || $user->rights->projet->all->creer) {
1560 $disabledproject = 0;
1564 if ($restricteditformytask && empty($tasksrole[$lines[$i]->
id])) {
1568 if ($restrictBefore && $preselectedday < $restrictBefore) {
1573 print
'<td class="nowraponall leftborder center minwidth150imp">';
1574 $tableCell =
$form->selectDate($preselectedday, $lines[$i]->
id, 1, 1, 2,
"addtime", 0, 0, $disabledtask);
1579 if (!$isavailable[$preselectedday][
'morning'] && !$isavailable[$preselectedday][
'afternoon']) {
1580 $cssonholiday .=
'onholidayallday ';
1581 } elseif (!$isavailable[$preselectedday][
'morning']) {
1582 $cssonholiday .=
'onholidaymorning ';
1583 } elseif (!$isavailable[$preselectedday][
'afternoon']) {
1584 $cssonholiday .=
'onholidayafternoon ';
1590 $idw = ($tmparray[
'wday'] - (empty($conf->global->MAIN_START_WEEK) ? 0 : 1));
1591 global $numstartworkingday, $numendworkingday;
1593 if ((($idw + 1) < $numstartworkingday) || (($idw + 1) > $numendworkingday)) {
1594 $cssweekend =
'weekend';
1598 print
'<td class="center duration'.($cssonholiday ?
' '.$cssonholiday :
'').($cssweekend ?
' '.$cssweekend :
'').
'">';
1599 $dayWorkLoad = $projectstatic->weekWorkLoadPerTask[$preselectedday][$lines[$i]->id];
1600 $totalforeachday[$preselectedday] += $dayWorkLoad;
1603 if ($dayWorkLoad > 0) {
1610 $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>';
1611 $tableCell .=
'<span class="hideonsmartphone"> + </span>';
1613 $tableCell .=
$form->select_duration($lines[$i]->
id.
'duration',
'', $disabledtask,
'text', 0, 1);
1629 print
'<td class="center">';
1630 print
'<textarea name="'.$lines[$i]->id.
'note" rows="'.ROWS_2.
'" id="'.$lines[$i]->id.
'note"'.($disabledtask ?
' disabled="disabled"' :
'').
'>';
1631 print
'</textarea>';
1635 print
'<td class="right">';
1636 if ((!$lines[$i]->
public) && $disabledproject) {
1637 print
$form->textwithpicto(
'', $langs->trans(
"UserIsNotContactOfProject"));
1638 } elseif ($disabledtask) {
1639 $titleassigntask = $langs->trans(
"AssignTaskToMe");
1640 if ($fuser->id != $user->id) {
1641 $titleassigntask = $langs->trans(
"AssignTaskToUser",
'...');
1644 print
$form->textwithpicto(
'', $langs->trans(
"TaskIsNotAssignedToUser", $titleassigntask));
1653 if ($lines[$i]->
id > 0) {
1656 $ret =
projectLinesPerDay($inc, $lines[$i]->
id, $fuser, ($parent == 0 ? $lineswithoutlevel0 : $lines), $level, $projectsrole, $tasksrole, $mine, $restricteditformytask, $preselectedday, $isavailable, $oldprojectforbreak, $arrayfields, $extrafields);
1659 foreach ($ret as $key => $val) {
1660 $totalforeachday[$key] += $val;
1671 return $totalforeachday;
1694 function projectLinesPerWeek(&$inc, $firstdaytoshow, $fuser, $parent, $lines, &$level, &$projectsrole, &$tasksrole, $mine, $restricteditformytask, &$isavailable, $oldprojectforbreak = 0, $arrayfields = array(), $extrafields =
null)
1696 global $conf, $db, $user, $langs;
1697 global
$form, $formother, $projectstatic, $taskstatic, $thirdpartystatic;
1699 $numlines = count($lines);
1702 $workloadforid = array();
1703 $totalforeachday = array();
1704 $lineswithoutlevel0 = array();
1708 for ($i = 0; $i < $numlines; $i++) {
1709 if ($lines[$i]->fk_task_parent) {
1710 $lineswithoutlevel0[] = $lines[$i];
1717 if (empty($oldprojectforbreak)) {
1718 $oldprojectforbreak = (empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT) ? 0 : -1);
1721 $restrictBefore =
null;
1723 if (! empty($conf->global->PROJECT_TIMESHEET_PREVENT_AFTER_MONTHS)) {
1724 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
1728 for ($i = 0; $i < $numlines; $i++) {
1733 if ($lines[$i]->fk_task_parent == $parent) {
1737 if (empty($mine) || !empty($tasksrole[$lines[$i]->
id])) {
1740 if ($restricteditformytask == 2 && empty($tasksrole[$lines[$i]->
id])) {
1745 if ($parent == 0 && $lines[$i]->fk_project != $lastprojectid) {
1746 $lastprojectid = $lines[$i]->fk_project;
1747 $projectstatic->id = $lines[$i]->fk_project;
1752 if (empty($workloadforid[$projectstatic->id])) {
1753 $projectstatic->loadTimeSpent($firstdaytoshow, 0, $fuser->id);
1754 $workloadforid[$projectstatic->id] = 1;
1759 $projectstatic->id = $lines[$i]->fk_project;
1760 $projectstatic->ref = $lines[$i]->projectref;
1761 $projectstatic->title = $lines[$i]->projectlabel;
1762 $projectstatic->public = $lines[$i]->public;
1763 $projectstatic->thirdparty_name = $lines[$i]->thirdparty_name;
1764 $projectstatic->status = $lines[$i]->projectstatus;
1766 $taskstatic->id = $lines[$i]->id;
1767 $taskstatic->ref = ($lines[$i]->ref ? $lines[$i]->ref : $lines[$i]->id);
1768 $taskstatic->label = $lines[$i]->label;
1769 $taskstatic->date_start = $lines[$i]->date_start;
1770 $taskstatic->date_end = $lines[$i]->date_end;
1772 $thirdpartystatic->id = $lines[$i]->thirdparty_id;
1773 $thirdpartystatic->name = $lines[$i]->thirdparty_name;
1774 $thirdpartystatic->email = $lines[$i]->thirdparty_email;
1776 if (empty($oldprojectforbreak) || ($oldprojectforbreak != -1 && $oldprojectforbreak != $projectstatic->id)) {
1778 if (!empty($arrayfields[
't.planned_workload'][
'checked'])) {
1781 if (!empty($arrayfields[
't.progress'][
'checked'])) {
1784 foreach ($arrayfields as $key => $val) {
1785 if ($val[
'checked'] && substr($key, 0, 5) ==
'efpt.') {
1790 print
'<tr class="oddeven trforbreak nobold">'.
"\n";
1791 print
'<td colspan="'.(11 + $addcolspan).
'">';
1792 print $projectstatic->getNomUrl(1,
'', 0,
'<strong>'.$langs->transnoentitiesnoconv(
"YourRole").
':</strong> '.$projectsrole[$lines[$i]->fk_project]);
1793 if ($thirdpartystatic->id > 0) {
1794 print
' - '.$thirdpartystatic->getNomUrl(1);
1796 if ($projectstatic->title) {
1798 print
'<span class="secondary">'.$projectstatic->title.
'</span>';
1865 if ($oldprojectforbreak != -1) {
1866 $oldprojectforbreak = $projectstatic->id;
1869 print
'<tr class="oddeven" data-taskid="'.$lines[$i]->id.
'">'.
"\n";
1879 if (!empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT)) {
1880 print
'<td class="nowrap">';
1881 if ($oldprojectforbreak == -1) {
1882 print $projectstatic->getNomUrl(1,
'', 0, $langs->transnoentitiesnoconv(
"YourRole").
': '.$projectsrole[$lines[$i]->fk_project]);
1888 if (!empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT)) {
1889 print
'<td class="tdoverflowmax100">';
1890 if ($thirdpartystatic->id > 0) {
1891 print $thirdpartystatic->getNomUrl(1,
'project');
1897 print
'<td class="nowrap">';
1898 print
'<!-- Task id = '.$lines[$i]->id.
' -->';
1899 for ($k = 0; $k < $level; $k++) {
1900 print
'<div class="marginleftonly">';
1902 print $taskstatic->getNomUrl(1,
'withproject',
'time');
1905 print
'<span class="opacitymedium">'.$taskstatic->label.
'</span>';
1906 for ($k = 0; $k < $level; $k++) {
1912 $extrafieldsobjectkey =
'projet_task';
1913 $extrafieldsobjectprefix =
'efpt.';
1914 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1917 if (!empty($arrayfields[
't.planned_workload'][
'checked'])) {
1918 print
'<td class="leftborder plannedworkload right">';
1919 if ($lines[$i]->planned_workload) {
1927 if (!empty($arrayfields[
't.progress'][
'checked'])) {
1929 print
'<td class="right">';
1930 print $formother->select_percent($lines[$i]->progress, $lines[$i]->
id.
'progress');
1934 if (!empty($arrayfields[
'timeconsumed'][
'checked'])) {
1936 print
'<td class="right">';
1938 if ($lines[$i]->duration) {
1939 print
'<a href="'.DOL_URL_ROOT.
'/projet/tasks/time.php?id='.$lines[$i]->id.
'">';
1948 print
'<td class="right">';
1949 $tmptimespent = $taskstatic->getSummaryOfTimeSpent($fuser->id);
1950 if ($tmptimespent[
'total_duration']) {
1958 $disabledproject = 1;
1964 if ($lines[$i]->
public || !empty($projectsrole[$lines[$i]->fk_project]) || $user->rights->projet->all->creer) {
1965 $disabledproject = 0;
1969 if ($restricteditformytask && empty($tasksrole[$lines[$i]->
id])) {
1977 $modeinput =
'hours';
1978 for ($idw = 0; $idw < 7; $idw++) {
1982 if (!$isavailable[$tmpday][
'morning'] && !$isavailable[$tmpday][
'afternoon']) {
1983 $cssonholiday .=
'onholidayallday ';
1984 } elseif (!$isavailable[$tmpday][
'morning']) {
1985 $cssonholiday .=
'onholidaymorning ';
1986 } elseif (!$isavailable[$tmpday][
'afternoon']) {
1987 $cssonholiday .=
'onholidayafternoon ';
1991 $dayWorkLoad = $projectstatic->weekWorkLoadPerTask[$tmpday][$lines[$i]->id];
1992 $totalforeachday[$tmpday] += $dayWorkLoad;
1995 if ($dayWorkLoad > 0) {
1998 $alttitle = $langs->trans(
"AddHereTimeSpentForDay", $tmparray[
'day'], $tmparray[
'mon']);
2000 global $numstartworkingday, $numendworkingday;
2002 if (($idw + 1 < $numstartworkingday) || ($idw + 1 > $numendworkingday)) {
2003 $cssweekend =
'weekend';
2006 $disabledtaskday = $disabledtask;
2008 if (! $disabledtask && $restrictBefore && $tmpday < $restrictBefore) {
2009 $disabledtaskday = 1;
2012 $tableCell =
'<td class="center hide'.$idw.($cssonholiday ?
' '.$cssonholiday :
'').($cssweekend ?
' '.$cssweekend :
'').
'">';
2015 if ($alreadyspent) {
2016 $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>';
2020 $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"';
2021 $tableCell .=
' onkeypress="return regexEvent(this,event,\'timeChar\')"';
2022 $tableCell .=
' onkeyup="updateTotal('.$idw.
',\''.$modeinput.
'\')
"';
2023 $tableCell .= ' onblur="regexEvent(
this,event,\
''.$modeinput.
'\'); updateTotal(
'.$idw.',\
''.$modeinput.
'\')
" />';
2024 $tableCell .= '</td>';
2029 print '<td class="right
">';
2030 if ((!$lines[$i]->public) && $disabledproject) {
2031 print $form->textwithpicto('', $langs->trans("UserIsNotContactOfProject
"));
2032 } elseif ($disabledtask) {
2033 $titleassigntask = $langs->trans("AssignTaskToMe
");
2034 if ($fuser->id != $user->id) {
2035 $titleassigntask = $langs->trans("AssignTaskToUser
", '...');
2038 print $form->textwithpicto('', $langs->trans("TaskIsNotAssignedToUser
", $titleassigntask));
2045 // Call to show task with a lower level (task under the current task)
2048 if ($lines[$i]->id > 0) {
2049 //var_dump('totalforeachday after taskid='.$lines[$i]->id.' and previous one on level '.$level);
2050 //var_dump($totalforeachday);
2051 $ret = projectLinesPerWeek($inc, $firstdaytoshow, $fuser, $lines[$i]->id, ($parent == 0 ? $lineswithoutlevel0 : $lines), $level, $projectsrole, $tasksrole, $mine, $restricteditformytask, $isavailable, $oldprojectforbreak, $arrayfields, $extrafields);
2052 //var_dump('ret with parent='.$lines[$i]->id.' level='.$level);
2054 foreach ($ret as $key => $val) {
2055 $totalforeachday[$key] += $val;
2057 //var_dump('totalforeachday after taskid='.$lines[$i]->id.' and previous one on level '.$level.' + subtasks');
2058 //var_dump($totalforeachday);
2066 return $totalforeachday;
2087 function projectLinesPerMonth(&$inc, $firstdaytoshow, $fuser, $parent, $lines, &$level, &$projectsrole, &$tasksrole, $mine, $restricteditformytask, &$isavailable, $oldprojectforbreak = 0, $TWeek = array())
2089 global $conf, $db, $user, $langs;
2090 global $form, $formother, $projectstatic, $taskstatic, $thirdpartystatic;
2092 $numlines = count($lines);
2095 $workloadforid = array();
2096 $totalforeachweek = array();
2097 $lineswithoutlevel0 = array();
2099 // Create a smaller array with sublevels only to be used later. This increase dramatically performances.
2100 if ($parent == 0) { // Always and only if at first level
2101 for ($i = 0; $i < $numlines; $i++) {
2102 if ($lines[$i]->fk_task_parent) {
2103 $lineswithoutlevel0[] = $lines[$i];
2108 //dol_syslog('projectLinesPerWeek inc='.$inc.' firstdaytoshow='.$firstdaytoshow.' task parent id='.$parent.' level='.$level." count(lines)=
".$numlines." count(lineswithoutlevel0)=
".count($lineswithoutlevel0));
2110 if (empty($oldprojectforbreak)) {
2111 $oldprojectforbreak = (empty($conf->global->PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT) ? 0 : -1); // 0 = start break, -1 = never break
2114 $restrictBefore = null;
2116 if (! empty($conf->global->PROJECT_TIMESHEET_PREVENT_AFTER_MONTHS)) {
2117 require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
2118 $restrictBefore = dol_time_plus_duree(dol_now(), - $conf->global->PROJECT_TIMESHEET_PREVENT_AFTER_MONTHS, 'm');
2121 for ($i = 0; $i < $numlines; $i++) {
2126 if ($lines[$i]->fk_task_parent == $parent) {
2127 // If we want all or we have a role on task, we show it
2128 if (empty($mine) || !empty($tasksrole[$lines[$i]->id])) {
2129 //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);
2131 // Break on a new project
2132 if ($parent == 0 && $lines[$i]->fk_project != $lastprojectid) {
2133 $lastprojectid = $lines[$i]->fk_project;
2134 $projectstatic->id = $lines[$i]->fk_project;
2137 //var_dump('--- '.$level.' '.$firstdaytoshow.' '.$fuser->id.' '.$projectstatic->id.' '.$workloadforid[$projectstatic->id]);
2138 //var_dump($projectstatic->weekWorkLoadPerTask);
2139 if (empty($workloadforid[$projectstatic->id])) {
2140 $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
2141 $workloadforid[$projectstatic->id] = 1;
2143 //var_dump($projectstatic->weekWorkLoadPerTask);
2144 //var_dump('--- '.$projectstatic->id.' '.$workloadforid[$projectstatic->id]);
2146 $projectstatic->id = $lines[$i]->fk_project;
2147 $projectstatic->ref = $lines[$i]->projectref;
2148 $projectstatic->title = $lines[$i]->projectlabel;
2149 $projectstatic->public = $lines[$i]->public;
2150 $projectstatic->thirdparty_name = $lines[$i]->thirdparty_name;
2151 $projectstatic->status = $lines[$i]->projectstatus;
2153 $taskstatic->id = $lines[$i]->id;
2154 $taskstatic->ref = ($lines[$i]->ref ? $lines[$i]->ref : $lines[$i]->id);
2155 $taskstatic->label = $lines[$i]->label;
2156 $taskstatic->date_start = $lines[$i]->date_start;
2157 $taskstatic->date_end = $lines[$i]->date_end;
2159 $thirdpartystatic->id = $lines[$i]->thirdparty_id;
2160 $thirdpartystatic->name = $lines[$i]->thirdparty_name;
2161 $thirdpartystatic->email = $lines[$i]->thirdparty_email;
2163 if (empty($oldprojectforbreak) || ($oldprojectforbreak != -1 && $oldprojectforbreak != $projectstatic->id)) {
2164 print '<tr class="oddeven trforbreak nobold
">'."\n
";
2165 print '<td colspan="'.(6 + count($TWeek)).'">';
2166 print $projectstatic->getNomUrl(1, '', 0, '<strong>'.$langs->transnoentitiesnoconv("YourRole
").':</strong> '.$projectsrole[$lines[$i]->fk_project]);
2167 if ($thirdpartystatic->id > 0) {
2168 print ' - '.$thirdpartystatic->getNomUrl(1);
2170 if ($projectstatic->title) {
2172 print '<span class="secondary
">'.$projectstatic->title.'</span>';
2178 if ($oldprojectforbreak != -1) {
2179 $oldprojectforbreak = $projectstatic->id;
2181 print '<tr class="oddeven
" data-taskid="'.$lines[$i]->id.'">'."\n
";
2185 print '<td class="nowrap
">';
2186 print $fuser->getNomUrl(1, 'withproject', 'time');
2191 /*print '<td class="nowrap
">';
2192 if ($oldprojectforbreak == -1) print $projectstatic->getNomUrl(1,'',0,$langs->transnoentitiesnoconv("YourRole
").': '.$projectsrole[$lines[$i]->fk_project]);
2196 /*print '<td class="tdoverflowmax100
">';
2197 if ($thirdpartystatic->id > 0) print $thirdpartystatic->getNomUrl(1, 'project');
2201 print '<td class="nowrap
">';
2202 print '<!-- Task id = '.$lines[$i]->id.' -->';
2203 for ($k = 0; $k < $level; $k++) {
2204 print '<div class="marginleftonly
">';
2206 print $taskstatic->getNomUrl(1, 'withproject', 'time');
2209 print '<span class="opacitymedium
">'.$taskstatic->label.'</span>';
2210 for ($k = 0; $k < $level; $k++) {
2216 print '<td class="leftborder plannedworkload right
">';
2217 if ($lines[$i]->planned_workload) {
2218 print convertSecondToTime($lines[$i]->planned_workload, 'allhourmin');
2224 // Progress declared %
2225 print '<td class="right
">';
2226 print $formother->select_percent($lines[$i]->progress, $lines[$i]->id.'progress');
2229 // Time spent by everybody
2230 print '<td class="right
">';
2231 // $lines[$i]->duration is a denormalised field = summ of time spent by everybody for task. What we need is time consumed by user
2232 if ($lines[$i]->duration) {
2233 print '<a href="'.DOL_URL_ROOT.'/projet/tasks/time.php?
id=
'.$lines[$i]->id.'">';
2234 print convertSecondToTime($lines[$i]->duration, 'allhourmin');
2241 // Time spent by user
2242 print '<td class="right
">';
2243 $tmptimespent = $taskstatic->getSummaryOfTimeSpent($fuser->id);
2244 if ($tmptimespent['total_duration']) {
2245 print convertSecondToTime($tmptimespent['total_duration'], 'allhourmin');
2251 $disabledproject = 1;
2253 //print "x
".$lines[$i]->fk_project;
2254 //var_dump($lines[$i]);
2255 //var_dump($projectsrole[$lines[$i]->fk_project]);
2256 // If at least one role for project
2257 if ($lines[$i]->public || !empty($projectsrole[$lines[$i]->fk_project]) || $user->rights->projet->all->creer) {
2258 $disabledproject = 0;
2261 // If $restricteditformytask is on and I have no role on task, i disable edit
2262 if ($restricteditformytask && empty($tasksrole[$lines[$i]->id])) {
2266 //var_dump($projectstatic->weekWorkLoadPerTask);
2268 // Fields to show current time
2270 $modeinput = 'hours';
2271 $TFirstDay = getFirstDayOfEachWeek($TWeek, date('Y', $firstdaytoshow));
2272 $TFirstDay[reset($TWeek)] = 1;
2274 $firstdaytoshowarray = dol_getdate($firstdaytoshow);
2275 $year = $firstdaytoshowarray['year'];
2276 $month = $firstdaytoshowarray['mon'];
2277 foreach ($TWeek as $weekIndex => $weekNb) {
2278 $weekWorkLoad = $projectstatic->monthWorkLoadPerTask[$weekNb][$lines[$i]->id];
2279 $totalforeachweek[$weekNb] += $weekWorkLoad;
2282 if ($weekWorkLoad > 0) {
2283 $alreadyspent = convertSecondToTime($weekWorkLoad, 'allhourmin');
2285 $alttitle = $langs->trans("AddHereTimeSpentForWeek
", $weekNb);
2287 $disabledtaskweek = $disabledtask;
2288 $firstdayofweek = dol_mktime(0, 0, 0, $month, $TFirstDay[$weekIndex], $year);
2290 if (! $disabledtask && $restrictBefore && $firstdayofweek < $restrictBefore) {
2291 $disabledtaskweek = 1;
2294 $tableCell = '<td class="center hide weekend
">';
2296 if ($alreadyspent) {
2297 $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>';
2298 //$placeholder=' placeholder="00:00
"';
2302 $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
"';
2303 $tableCell .= ' onkeypress="return regexEvent(
this,event,\
'timeChar\')"';
2304 $tableCell .=
' onkeyup="updateTotal('.$weekNb.
',\''.$modeinput.
'\')
"';
2305 $tableCell .= ' onblur="regexEvent(
this,event,\
''.$modeinput.
'\'); updateTotal(
'.$weekNb.',\
''.$modeinput.
'\')
" />';
2306 $tableCell .= '</td>';
2311 print '<td class="right
">';
2312 if ((!$lines[$i]->public) && $disabledproject) {
2313 print $form->textwithpicto('', $langs->trans("UserIsNotContactOfProject
"));
2314 } elseif ($disabledtask) {
2315 $titleassigntask = $langs->trans("AssignTaskToMe
");
2316 if ($fuser->id != $user->id) {
2317 $titleassigntask = $langs->trans("AssignTaskToUser
", '...');
2320 print $form->textwithpicto('', $langs->trans("TaskIsNotAssignedToUser
", $titleassigntask));
2327 // Call to show task with a lower level (task under the current task)
2330 if ($lines[$i]->id > 0) {
2331 //var_dump('totalforeachday after taskid='.$lines[$i]->id.' and previous one on level '.$level);
2332 //var_dump($totalforeachday);
2333 $ret = projectLinesPerMonth($inc, $firstdaytoshow, $fuser, $lines[$i]->id, ($parent == 0 ? $lineswithoutlevel0 : $lines), $level, $projectsrole, $tasksrole, $mine, $restricteditformytask, $isavailable, $oldprojectforbreak, $TWeek);
2334 //var_dump('ret with parent='.$lines[$i]->id.' level='.$level);
2336 foreach ($ret as $key => $val) {
2337 $totalforeachweek[$key] += $val;
2339 //var_dump('totalforeachday after taskid='.$lines[$i]->id.' and previous one on level '.$level.' + subtasks');
2340 //var_dump($totalforeachday);
2348 return $totalforeachweek;
2361 function searchTaskInChild(&$inc, $parent, &$lines, &$taskrole)
2363 //print 'Search in line with parent id = '.$parent.'<br>';
2364 $numlines = count($lines);
2365 for ($i = 0; $i < $numlines; $i++) {
2366 // Process line $lines[$i]
2367 if ($lines[$i]->fk_parent == $parent && $lines[$i]->id != $lines[$i]->fk_parent) {
2368 // If task is legitimate to show, no more need to search deeper
2369 if (isset($taskrole[$lines[$i]->id])) {
2370 //print 'Found a legitimate task id='.$lines[$i]->id.'<br>';
2375 searchTaskInChild($inc, $lines[$i]->id, $lines, $taskrole);
2376 //print 'Found inc='.$inc.'<br>';
2400 function print_projecttasks_array($db, $form, $socid, $projectsListId, $mytasks = 0, $status = -1, $listofoppstatus = array(), $hiddenfields = array())
2402 global $langs, $conf, $user;
2403 global $theme_datacolor;
2405 require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
2407 $listofstatus = array_keys($listofoppstatus);
2409 if (is_array($listofstatus) && !empty($conf->global->USE_COLOR_FOR_PROSPECTION_STATUS)) {
2410 // Define $themeColorId and array $statusOppList for each $listofstatus
2412 $statusOppList = array();
2413 foreach ($listofstatus as $oppStatus) {
2414 $oppStatusCode = dol_getIdFromCode($db, $oppStatus, 'c_lead_status', 'rowid', 'code');
2415 if ($oppStatusCode) {
2416 $statusOppList[$oppStatus]['code'] = $oppStatusCode;
2417 $statusOppList[$oppStatus]['color'] = isset($theme_datacolor[$themeColorId]) ? implode(', ', $theme_datacolor[$themeColorId]) : '';
2423 $projectstatic = new Project($db);
2424 $thirdpartystatic = new Societe($db);
2428 $project_year_filter = 0;
2430 $title = $langs->trans("Projects");
2431 if (strcmp($status, '') && $status >= 0) {
2432 $title = $langs->trans("Projects").' '.$langs->trans($projectstatic->statuts_long[$status]);
2435 $arrayidtypeofcontact = array();
2437 print '<div class="div-table-responsive-no-min
">';
2438 print '<table class="noborder centpercent
">';
2440 $sql = " FROM
".MAIN_DB_PREFIX."projet as p
";
2442 $sql .= ",
".MAIN_DB_PREFIX."projet_task as t
";
2443 $sql .= ",
".MAIN_DB_PREFIX."element_contact as ec
";
2444 $sql .= ",
".MAIN_DB_PREFIX."c_type_contact as ctc
";
2446 $sql .= " LEFT JOIN
".MAIN_DB_PREFIX."projet_task as t ON p.rowid = t.fk_projet
";
2448 $sql .= " WHERE p.entity IN (
".getEntity('project').")
";
2449 $sql .= " AND p.rowid IN (
".$db->sanitize($projectsListId).")
";
2451 $sql .= " AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc =
".((int) $socid).")
";
2454 $sql .= " AND p.rowid = t.fk_projet
";
2455 $sql .= " AND ec.element_id = t.rowid
";
2456 $sql .= " AND ec.fk_socpeople =
".((int) $user->id);
2457 $sql .= " AND ec.fk_c_type_contact = ctc.rowid
"; // Replace the 2 lines with ec.fk_c_type_contact in $arrayidtypeofcontact
2458 $sql .= " AND ctc.element =
'project_task'";
2461 $sql .= " AND p.fk_statut =
".(int) $status;
2463 if (!empty($conf->global->PROJECT_LIMIT_YEAR_RANGE)) {
2464 $project_year_filter = GETPOST("project_year_filter
");
2465 //Check if empty or invalid year. Wildcard ignores the sql check
2466 if ($project_year_filter != "*
") {
2467 if (empty($project_year_filter) || !ctype_digit($project_year_filter)) {
2468 $project_year_filter = date("Y
");
2470 $sql .= " AND (p.dateo IS NULL OR p.dateo <=
".$db->idate(dol_get_last_day($project_year_filter, 12, false)).")
";
2471 $sql .= " AND (p.datee IS NULL OR p.datee >=
".$db->idate(dol_get_first_day($project_year_filter, 1, false)).")
";
2475 // Get id of project we must show tasks
2476 $arrayidofprojects = array();
2477 $sql1 = "SELECT p.rowid as projectid
";
2479 $resql = $db->query($sql1);
2482 $num = $db->num_rows($resql);
2484 $objp = $db->fetch_object($resql);
2485 $arrayidofprojects[$objp->projectid] = $objp->projectid;
2489 dol_print_error($db);
2491 if (empty($arrayidofprojects)) {
2492 $arrayidofprojects[0] = -1;
2495 // Get list of project with calculation on tasks
2496 $sql2 = "SELECT p.rowid as projectid, p.ref, p.title, p.fk_soc,
";
2497 $sql2 .= " s.rowid as socid, s.nom as socname, s.name_alias,
";
2498 $sql2 .= " s.code_client, s.code_compta, s.client,
";
2499 $sql2 .= " s.code_fournisseur, s.code_compta_fournisseur, s.fournisseur,
";
2500 $sql2 .= " s.logo, s.email, s.entity,
";
2501 $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,
";
2502 $sql2 .= " p.dateo, p.datee,
";
2503 $sql2 .= " COUNT(t.rowid) as nb, SUM(t.planned_workload) as planned_workload, SUM(t.planned_workload * t.progress / 100) as declared_progess_workload";
2504 $sql2 .= " FROM ".MAIN_DB_PREFIX."projet as p";
2505 $sql2 .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s ON s.
rowid = p.fk_soc";
2506 $sql2 .= " LEFT JOIN ".MAIN_DB_PREFIX."projet_task as t ON p.
rowid = t.fk_projet";
2507 $sql2 .= " WHERE p.
rowid IN (".$db->sanitize(join(',', $arrayidofprojects)).")";
2508 $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,";
2509 $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";
2510 $sql2 .= " ORDER BY p.title, p.
ref";
2512 $resql = $db->query($sql2);
2515 $total_opp_amount = 0;
2516 $ponderated_opp_amount = 0;
2518 $num = $db->num_rows(
$resql);
2521 print
'<tr class="liste_titre">';
2522 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);
2524 if (!empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
2525 if (!in_array(
'prospectionstatus', $hiddenfields)) {
2526 print_liste_field_titre(
"OpportunityStatus",
"",
"",
"",
"",
'style="max-width: 100px"', $sortfield, $sortorder,
'center ');
2528 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 ');
2531 if (empty($conf->global->PROJECT_HIDE_TASKS)) {
2533 if (!in_array(
'plannedworkload', $hiddenfields)) {
2534 print_liste_field_titre(
"PlannedWorkload",
"",
"",
"",
"",
'style="max-width: 100px"', $sortfield, $sortorder,
'right ');
2536 if (!in_array(
'declaredprogress', $hiddenfields)) {
2537 print_liste_field_titre(
"%",
"",
"",
"",
"",
'', $sortfield, $sortorder,
'right ', $langs->trans(
"ProgressDeclared"));
2540 if (!in_array(
'projectstatus', $hiddenfields)) {
2545 $total_plannedworkload = 0;
2546 $total_declaredprogressworkload = 0;
2548 $objp = $db->fetch_object(
$resql);
2550 $projectstatic->id = $objp->projectid;
2551 $projectstatic->user_author_id = $objp->fk_user_creat;
2552 $projectstatic->public = $objp->public;
2555 $userAccess = $projectstatic->restrictedProjectArea($user);
2556 if ($userAccess >= 0) {
2557 $projectstatic->ref = $objp->ref;
2558 $projectstatic->status = $objp->status;
2559 $projectstatic->title = $objp->title;
2560 $projectstatic->date_end = $db->jdate($objp->datee);
2561 $projectstatic->date_start = $db->jdate($objp->dateo);
2563 print
'<tr class="oddeven">';
2565 print
'<td class="tdoverflowmax150">';
2566 print $projectstatic->getNomUrl(1,
'', 0,
'',
'-', 0, -1,
'nowraponall');
2567 if (!in_array(
'projectlabel', $hiddenfields)) {
2568 print
'<br><span class="opacitymedium">'.dol_trunc($objp->title, 24).
'</span>';
2572 print
'<td class="nowraponall tdoverflowmax100">';
2573 if ($objp->fk_soc > 0) {
2574 $thirdpartystatic->id = $objp->socid;
2575 $thirdpartystatic->name = $objp->socname;
2578 $thirdpartystatic->code_compta = $objp->code_compta;
2579 $thirdpartystatic->client = $objp->client;
2581 $thirdpartystatic->code_compta_fournisseur = $objp->code_compta_fournisseur;
2582 $thirdpartystatic->fournisseur = $objp->fournisseur;
2583 $thirdpartystatic->logo = $objp->logo;
2584 $thirdpartystatic->email = $objp->email;
2585 $thirdpartystatic->entity = $objp->entity;
2586 print $thirdpartystatic->getNomUrl(1);
2590 if (!empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
2591 if (!in_array(
'prospectionstatus', $hiddenfields)) {
2592 print
'<td class="center tdoverflowmax75">';
2594 if (empty($conf->global->USE_COLOR_FOR_PROSPECTION_STATUS)) {
2595 $oppStatusCode =
dol_getIdFromCode($db, $objp->opp_status,
'c_lead_status',
'rowid',
'code');
2596 if ($langs->trans(
"OppStatus".$oppStatusCode) !=
"OppStatus".$oppStatusCode) {
2597 print $langs->trans(
"OppStatus".$oppStatusCode);
2600 if (isset($statusOppList[$objp->opp_status])) {
2601 $oppStatusCode = $statusOppList[$objp->opp_status][
'code'];
2602 $oppStatusColor = $statusOppList[$objp->opp_status][
'color'];
2604 $oppStatusCode =
dol_getIdFromCode($db, $objp->opp_status,
'c_lead_status',
'rowid',
'code');
2605 $oppStatusColor =
'';
2607 if ($oppStatusCode) {
2608 if (!empty($oppStatusColor)) {
2609 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>';
2611 print
'<a href="'.dol_buildpath(
'/projet/list.php?search_opp_status='.$objp->opp_status, 1).
'" title="'.$langs->trans(
"OppStatus".$oppStatusCode).
'">'.$oppStatusCode.
'</a>';
2618 print
'<td class="right">';
2619 if ($objp->opp_percent && $objp->opp_amount) {
2620 $opp_weighted_amount = $objp->opp_percent * $objp->opp_amount / 100;
2621 $alttext = $langs->trans(
"OpportunityWeightedAmount").
' '.
price($opp_weighted_amount, 0,
'', 1, -1, 0, $conf->currency);
2622 $ponderated_opp_amount +=
price2num($opp_weighted_amount);
2624 if ($objp->opp_amount) {
2625 print
'<span class="amount" title="'.$alttext.
'">'.
$form->textwithpicto(
price($objp->opp_amount, 0,
'', 1, -1, 0), $alttext).
'</span>';
2630 if (empty($conf->global->PROJECT_HIDE_TASKS)) {
2631 print
'<td class="right">'.$objp->nb.
'</td>';
2633 $plannedworkload = $objp->planned_workload;
2634 $total_plannedworkload += $plannedworkload;
2635 if (!in_array(
'plannedworkload', $hiddenfields)) {
2636 print
'<td class="right">'.($plannedworkload ?
convertSecondToTime($plannedworkload) :
'').
'</td>';
2638 if (!in_array(
'declaredprogress', $hiddenfields)) {
2639 $declaredprogressworkload = $objp->declared_progess_workload;
2640 $total_declaredprogressworkload += $declaredprogressworkload;
2641 print
'<td class="right">';
2643 print ($plannedworkload ?round(100 * $declaredprogressworkload / $plannedworkload, 0).
'%' :
'');
2648 if (!in_array(
'projectstatus', $hiddenfields)) {
2649 print
'<td class="right">';
2650 print $projectstatic->getLibStatut(3);
2656 $total_task = $total_task + $objp->nb;
2657 $total_opp_amount = $total_opp_amount + $objp->opp_amount;
2663 print
'<tr class="liste_total">';
2664 print
'<td>'.$langs->trans(
"Total").
"</td><td></td>";
2665 if (!empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
2666 if (!in_array(
'prospectionstatus', $hiddenfields)) {
2667 print
'<td class="liste_total"></td>';
2669 print
'<td class="liste_total right">';
2671 print
$form->textwithpicto(
price($total_opp_amount, 0,
'', 1, -1, 0), $langs->trans(
"OpportunityPonderatedAmountDesc").
' : '.
price($ponderated_opp_amount, 0,
'', 1, -1, 0, $conf->currency));
2674 if (empty($conf->global->PROJECT_HIDE_TASKS)) {
2675 print
'<td class="liste_total right">'.$total_task.
'</td>';
2676 if (!in_array(
'plannedworkload', $hiddenfields)) {
2677 print
'<td class="liste_total right">'.($total_plannedworkload ?
convertSecondToTime($total_plannedworkload) :
'').
'</td>';
2679 if (!in_array(
'declaredprogress', $hiddenfields)) {
2680 print
'<td class="liste_total right">'.($total_plannedworkload ?round(100 * $total_declaredprogressworkload / $total_plannedworkload, 0).
'%' :
'').
'</td>';
2683 if (!in_array(
'projectstatus', $hiddenfields)) {
2684 print
'<td class="liste_total"></td>';
2696 if (!empty($conf->global->PROJECT_LIMIT_YEAR_RANGE)) {
2698 print
'<form method="get" action="'.$_SERVER[
"PHP_SELF"].
'">';
2699 print
'<table width="100%">';
2701 print
'<td>'.$langs->trans(
"Year").
'</td>';
2702 print
'<td class="right"><input type="text" size="4" class="flat" name="project_year_filter" value="'.$project_year_filter.
'"/>';
2704 print
'</table></form>';
2717 function getTaskProgressView($task, $label =
true, $progressNumber =
true, $hideOnProgressNull =
false, $spaced =
false)
2719 global $langs, $conf;
2723 $plannedworkloadoutputformat =
'allhourmin';
2724 $timespentoutputformat =
'allhourmin';
2725 if (!empty($conf->global->PROJECT_PLANNED_WORKLOAD_FORMAT)) {
2726 $plannedworkloadoutputformat = $conf->global->PROJECT_PLANNED_WORKLOAD_FORMAT;
2728 if (!empty($conf->global->PROJECT_TIMES_SPENT_FORMAT)) {
2729 $timespentoutputformat = $conf->global->PROJECT_TIME_SPENT_FORMAT;
2732 if (empty($task->progress) && !empty($hideOnProgressNull)) {
2736 $spaced = !empty($spaced) ?
'spaced' :
'';
2741 $progressBarClass =
'progress-bar-info';
2742 $progressCalculated = 0;
2743 if ($task->planned_workload) {
2744 $progressCalculated = round(100 * floatval($task->duration_effective) / floatval($task->planned_workload), 2);
2747 $warningRatio = !empty($conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT) ? (1 + $conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT / 100) : 1.10;
2749 $diffTitle =
'<br>'.$langs->trans(
'ProgressDeclared').
' : '.$task->progress.($task->progress ?
'%' :
'');
2750 $diffTitle .=
'<br>'.$langs->trans(
'ProgressCalculated').
' : '.$progressCalculated.($progressCalculated ?
'%' :
'');
2753 if (floatval($progressCalculated) > floatval($task->progress * $warningRatio)) {
2754 $progressBarClass =
'progress-bar-danger';
2755 $title = $langs->trans(
'TheReportedProgressIsLessThanTheCalculatedProgressionByX', abs($task->progress - $progressCalculated).
' '.$langs->trans(
"point"));
2756 $diff =
'<span class="text-danger classfortooltip paddingrightonly" title="'.dol_htmlentities($title.$diffTitle).
'" ><i class="fa fa-caret-down"></i> '.($task->progress - $progressCalculated).
'%</span>';
2757 } elseif (floatval($progressCalculated) > floatval($task->progress)) {
2758 $progressBarClass =
'progress-bar-warning';
2759 $title = $langs->trans(
'TheReportedProgressIsLessThanTheCalculatedProgressionByX', abs($task->progress - $progressCalculated).
' '.$langs->trans(
"point"));
2760 $diff =
'<span class="text-warning classfortooltip paddingrightonly" title="'.dol_htmlentities($title.$diffTitle).
'" ><i class="fa fa-caret-left"></i> '.($task->progress - $progressCalculated).
'%</span>';
2762 $progressBarClass =
'progress-bar-success';
2763 $title = $langs->trans(
'TheReportedProgressIsMoreThanTheCalculatedProgressionByX', ($task->progress - $progressCalculated).
' '.$langs->trans(
"point"));
2764 $diff =
'<span class="text-success classfortooltip paddingrightonly" title="'.dol_htmlentities($title.$diffTitle).
'" ><i class="fa fa-caret-up"></i> '.($task->progress - $progressCalculated).
'%</span>';
2768 $out .=
'<div class="progress-group">';
2770 if ($label !==
false) {
2771 $out .=
' <span class="progress-text">';
2773 if ($label !==
true) {
2782 if ($progressNumber !==
false) {
2783 $out .=
' <span class="progress-number">';
2784 if ($progressNumber !==
true) {
2785 $out .= $progressNumber;
2787 if ($task->hasDelay()) {
2791 $url = DOL_URL_ROOT.
'/projet/tasks/time.php?id='.$task->id;
2793 $out .= !empty($diff) ? $diff.
' ' :
'';
2794 $out .=
'<a href="'.$url.
'" >';
2795 $out .=
'<b title="'.$langs->trans(
'TimeSpent').
'" >';
2796 if ($task->duration_effective) {
2806 $out .=
'<a href="'.$url.
'" >';
2807 $out .=
'<span title="'.$langs->trans(
'PlannedWorkload').
'" >';
2808 if ($task->planned_workload) {
2820 $out .=
' <div class="progress sm '.$spaced.
'">';
2821 $diffval = floatval($task->progress) - floatval($progressCalculated);
2822 if ($diffval >= 0) {
2824 $out .=
' <div class="progress-bar '.$progressBarClass.
'" style="width: '.floatval($task->progress).
'%" title="'.floatval($task->progress).
'%">';
2825 if (!empty($task->progress)) {
2826 $out .=
' <div class="progress-bar progress-bar-consumed" style="width: '.floatval($progressCalculated / $task->progress * 100).
'%" title="'.floatval($progressCalculated).
'%"></div>';
2831 $out .=
' <div class="progress-bar progress-bar-consumed-late" style="width: '.floatval($progressCalculated).
'%" title="'.floatval($progressCalculated).
'%">';
2832 $out .=
' <div class="progress-bar '.$progressBarClass.
'" style="width: '.($task->progress ? floatval($task->progress / $progressCalculated * 100).
'%' :
'1px').
'" title="'.floatval($task->progress).
'%"></div>';
2851 global $conf, $langs;
2855 if ($task->progress !=
'') {
2859 $badgeClass =
'badge ';
2860 if ($task->planned_workload) {
2861 $progressCalculated = round(100 * floatval($task->duration_effective) / floatval($task->planned_workload), 2);
2864 $warningRatio = !empty($conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT) ? (1 + $conf->global->PROJECT_TIME_SPEND_WARNING_PERCENT / 100) : 1.10;
2866 if (floatval($progressCalculated) > floatval($task->progress * $warningRatio)) {
2867 $badgeClass .=
'badge-danger';
2868 if (empty($tooltip)) {
2869 $tooltip = $task->progress.
'% < '.$langs->trans(
"TimeConsumed").
' '.$progressCalculated.
'%';
2871 } elseif (floatval($progressCalculated) > floatval($task->progress)) {
2872 $badgeClass .=
'badge-warning';
2873 if (empty($tooltip)) {
2874 $tooltip = $task->progress.
'% < '.$langs->trans(
"TimeConsumed").
' '.$progressCalculated.
'%';
2877 $badgeClass .=
'badge-success';
2878 if (empty($tooltip)) {
2879 $tooltip = $task->progress.
'% >= '.$langs->trans(
"TimeConsumed").
' '.$progressCalculated.
'%';
2886 if (!empty($tooltip)) {
2887 $badgeClass .=
' classfortooltip';
2888 $title =
'title="'.dol_htmlentities($tooltip).
'"';
2891 if (empty($label)) {
2892 $label = $task->progress.
' %';
2895 if (!empty($label)) {
2896 $out =
'<span class="'.$badgeClass.
'" '.$title.
' >'.$label.
'</span>';