36require
'../../main.inc.php';
46@phan-var-force ?string $uploaddir
48require_once DOL_DOCUMENT_ROOT .
'/projet/class/project.class.php';
49require_once DOL_DOCUMENT_ROOT .
'/projet/class/task.class.php';
50require_once DOL_DOCUMENT_ROOT .
'/compta/facture/class/facture.class.php';
51require_once DOL_DOCUMENT_ROOT .
'/core/lib/project.lib.php';
52require_once DOL_DOCUMENT_ROOT .
'/core/lib/date.lib.php';
53require_once DOL_DOCUMENT_ROOT .
'/core/class/html.formother.class.php';
54require_once DOL_DOCUMENT_ROOT .
'/core/class/html.formprojet.class.php';
55require_once DOL_DOCUMENT_ROOT .
'/core/class/html.formintervention.class.php';
56require_once DOL_DOCUMENT_ROOT .
'/product/class/product.class.php';
59$langsLoad = array(
'projects',
'bills',
'orders',
'companies');
61 $langsLoad[] =
'eventorganization';
64$langs->loadLangs($langsLoad);
66$action =
GETPOST(
'action',
'aZ09');
67$massaction =
GETPOST(
'massaction',
'alpha');
68$confirm =
GETPOST(
'confirm',
'alpha');
69$cancel =
GETPOST(
'cancel',
'alpha');
70$toselect =
GETPOST(
'toselect',
'array:int');
71$contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'timespentlist';
72$backtopage =
GETPOST(
'backtopage',
'alpha');
73$optioncss =
GETPOST(
'optioncss',
'alpha');
74$mode =
GETPOST(
'mode',
'alpha');
81$project_ref =
GETPOST(
'project_ref',
'alpha');
87$search_date_startday =
GETPOSTINT(
'search_date_startday');
88$search_date_startmonth =
GETPOSTINT(
'search_date_startmonth');
89$search_date_startyear =
GETPOSTINT(
'search_date_startyear');
90$search_date_endday =
GETPOSTINT(
'search_date_endday');
91$search_date_endmonth =
GETPOSTINT(
'search_date_endmonth');
92$search_date_endyear =
GETPOSTINT(
'search_date_endyear');
93$search_date_start =
dol_mktime(0, 0, 0, $search_date_startmonth, $search_date_startday, $search_date_startyear);
94$search_date_end =
dol_mktime(23, 59, 59, $search_date_endmonth, $search_date_endday, $search_date_endyear);
95$search_note =
GETPOST(
'search_note',
'alpha');
96$search_duration =
GETPOST(
'search_duration',
'alpha');
97$search_task_ref =
GETPOST(
'search_task_ref',
'alpha');
98$search_task_label =
GETPOST(
'search_task_label',
'alpha');
99$search_user =
GETPOST(
'search_user',
'intcomma');
100$search_valuebilled =
GETPOST(
'search_valuebilled',
'intcomma');
101$search_product_ref =
GETPOST(
'search_product_ref',
'alpha');
102$search_company =
GETPOST(
'$search_company',
'alpha');
103$search_company_alias =
GETPOST(
'$search_company_alias',
'alpha');
104$search_project_ref =
GETPOST(
'$search_project_ref',
'alpha');
105$search_project_label =
GETPOST(
'$search_project_label',
'alpha');
106$search_timespent_starthour =
GETPOSTINT(
"search_timespent_duration_starthour");
107$search_timespent_startmin =
GETPOSTINT(
"search_timespent_duration_startmin");
108$search_timespent_endhour =
GETPOSTINT(
"search_timespent_duration_endhour");
109$search_timespent_endmin =
GETPOSTINT(
"search_timespent_duration_endmin");
112$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
113$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
115if (empty($page) || $page == -1) {
118$offset = $limit * $page;
119$pageprev = $page - 1;
120$pagenext = $page + 1;
122 $sortfield =
't.element_date,t.element_datehour,t.rowid';
125 $sortorder =
'DESC,DESC,DESC';
128$childids = $user->getAllChildIds(1);
132$hookmanager->initHooks(array(
'projecttasktime',
'globalcard'));
136$projectstatic =
new Project($db);
139$extrafields->fetch_name_optionals_label($projectstatic->table_element);
140$extrafields->fetch_name_optionals_label(
$object->table_element);
142$search_array_options = $extrafields->getOptionalsFromPost(
$object->table_element,
'',
'search_');
145if ($id > 0 || $ref) {
154if (!$user->hasRight(
'projet',
'lire')) {
163 if (empty($projectid) && !$user->hasRight(
'projet',
'all',
'lire')) {
164 $search_user = $user->id;
175if (
GETPOST(
'cancel',
'alpha')) {
178if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend' && $massaction !=
'confirm_generateinvoice' && $massaction !=
'confirm_generateinter') {
182$parameters = array(
'socid' => $socid,
'projectid' => $projectid);
183$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
188include DOL_DOCUMENT_ROOT .
'/core/actions_changeselectedfields.inc.php';
191if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
196 $search_duration =
'';
197 $search_date_startday =
'';
198 $search_date_startmonth =
'';
199 $search_date_startyear =
'';
200 $search_date_endday =
'';
201 $search_date_endmonth =
'';
202 $search_date_endyear =
'';
203 $search_date_start =
'';
204 $search_date_end =
'';
205 $search_task_ref =
'';
206 $search_company =
'';
207 $search_company_alias =
'';
208 $search_project_ref =
'';
209 $search_project_label =
'';
210 $search_task_label =
'';
212 $search_valuebilled =
'';
213 $search_product_ref =
'';
215 $search_array_options = array();
216 $search_timespent_starthour =
'';
217 $search_timespent_startmin =
'';
218 $search_timespent_endhour =
'';
219 $search_timespent_endmin =
'';
223if ($action ==
'addtimespent' && $user->hasRight(
'projet',
'time')) {
224 $timespent_durationhour =
GETPOSTINT(
'timespent_durationhour');
225 $timespent_durationmin =
GETPOSTINT(
'timespent_durationmin');
226 if (empty($timespent_durationhour) && empty($timespent_durationmin)) {
227 setEventMessages($langs->trans(
'ErrorFieldRequired', $langs->transnoentitiesnoconv(
"Duration")),
null,
'errors');
231 $langs->load(
"errors");
232 setEventMessages($langs->trans(
'ErrorUserNotAssignedToTask'),
null,
'errors');
241 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Task")),
null,
'errors');
242 $action =
'createtime';
252 if (empty(
$object->project->status)) {
253 setEventMessages($langs->trans(
"ProjectMustBeValidatedFirst"),
null,
'errors');
254 $action =
'createtime';
265 $object->timespent_withhour = 1;
268 $object->timespent_withhour = 0;
273 $result =
$object->addTimeSpent($user);
284 $action =
'createtime';
288if (($action ==
'updateline' || $action ==
'updatesplitline') && !$cancel && $user->hasRight(
'projet',
'lire')) {
289 if (!
GETPOST(
"new_durationhour") && !
GETPOST(
"new_durationmin")) {
290 setEventMessages($langs->trans(
'ErrorFieldRequired', $langs->transnoentitiesnoconv(
"Duration")),
null,
'errors');
301 $object->fetchTimeSpent($lineid);
302 $timespentoldowner =
$object->timespent_fk_user;
306 $object->fetch($id_temp, $ref);
308 $object->timespent_note =
GETPOST(
"timespent_note_line",
"alphanohtml");
312 if (
GETPOST(
"timelinehour") !=
'' &&
GETPOST(
"timelinehour") >= 0 && !empty($timespent_date)) {
314 $object->timespent_withhour = 1;
315 } elseif (!empty($timespent_date)) {
316 $object->timespent_date = $timespent_date;
317 $object->timespent_withhour = 0;
320 if (GETPOSTISSET(
"userid_line")) {
328 if ((in_array($timespentoldowner, $childids) || $user->hasRight(
'projet',
'all',
'creer')) && (in_array(
$object->timespent_fk_user, $childids) || $user->hasRight(
'projet',
'all',
'creer'))) {
329 $result =
$object->updateTimeSpent($user);
341 $timespentoldowner =
$object->timespent_fk_user;
343 $object->timespent_note =
GETPOST(
"timespent_note_line",
"alphanohtml");
348 if (
GETPOST(
"timelinehour") !=
'' &&
GETPOST(
"timelinehour") >= 0) {
351 $object->timespent_withhour = 1;
352 } elseif (!empty($timespent_date)) {
353 $object->timespent_date = $timespent_date;
354 $object->timespent_datehour = $timespent_date;
355 $object->timespent_withhour = 0;
359 if (GETPOSTISSET(
"userid_line")) {
368 if ((in_array($timespentoldowner, $childids) || $user->hasRight(
'projet',
'all',
'creer')) && (in_array(
$object->timespent_fk_user, $childids) || $user->hasRight(
'projet',
'all',
'creer'))) {
369 $result =
$object->updateTimeSpent($user);
384if ($action ==
'confirm_deleteline' && $confirm ==
"yes" && ($user->hasRight(
'projet',
'time') || $user->hasRight(
'projet',
'all',
'creer'))) {
387 if (in_array(
$object->timespent_fk_user, $childids) || $user->hasRight(
'projet',
'all',
'creer')) {
388 $result =
$object->delTimeSpent($user);
391 $langs->load(
"errors");
402if (!empty($project_ref) && !empty($withproject)) {
403 if ($projectstatic->fetch(0, $project_ref) > 0) {
404 $tasksarray =
$object->getTasksArray(
null,
null, $projectstatic->id, $socid, 0);
405 if (count($tasksarray) > 0) {
406 $id = $tasksarray[0]->id;
408 header(
"Location: " . DOL_URL_ROOT .
'/projet/tasks.php?id=' . $projectstatic->id . ($withproject ?
'&withproject=1' :
'') . (empty($mode) ?
'' :
'&mode=' . $mode));
415$projectidforalltimes = 0;
417 $projectidforalltimes =
GETPOSTINT(
'projectid');
419 $result = $projectstatic->fetch($projectidforalltimes);
420 if (!empty($projectstatic->socid)) {
421 $projectstatic->fetch_thirdparty();
423 $res = $projectstatic->fetch_optionals();
426 if ($action ==
'update_extras' && $projectstatic->id > 0) {
427 $permissiontoeditextra = $user->hasRight(
'projet',
'creer');
428 if (
GETPOST(
'attribute',
'aZ09') && isset($extrafields->attributes[$projectstatic->table_element][
'perms'][
GETPOST(
'attribute',
'aZ09')])) {
429 $permissiontoeditextra =
dol_eval((
string) $extrafields->attributes[$projectstatic->table_element][
'perms'][
GETPOST(
'attribute',
'aZ09')]);
432 if ($permissiontoeditextra) {
433 $projectstatic->oldcopy =
dol_clone($projectstatic, 2);
435 $attribute_name =
GETPOST(
'attribute',
'aZ09');
438 $ret = $extrafields->setOptionalsFromPost(
null, $projectstatic, $attribute_name);
444 $result = $projectstatic->updateExtraField($attribute_name,
'PROJECT_MODIFY');
453 $action =
'edit_extras';
456} elseif (
GETPOST(
'project_ref',
'alpha')) {
457 $projectstatic->fetch(0,
GETPOST(
'project_ref',
'alpha'));
458 $projectidforalltimes = $projectstatic->id;
462 $result = $projectstatic->fetch(
$object->fk_project);
465$allprojectforuser = 0;
467if ($id <= 0 && $projectidforalltimes == 0) {
468 $allprojectforuser = $user->id;
471if ($action ==
'confirm_generateinvoice' && $user->hasRight(
'facture',
'creer')) {
472 if (!empty($projectstatic->socid)) {
473 $projectstatic->fetch_thirdparty();
476 if (!($projectstatic->thirdparty->id > 0)) {
477 setEventMessages($langs->trans(
"ThirdPartyRequiredToGenerateInvoice"),
null,
'errors');
479 include_once DOL_DOCUMENT_ROOT .
'/compta/facture/class/facture.class.php';
480 include_once DOL_DOCUMENT_ROOT .
'/projet/class/project.class.php';
481 include_once DOL_DOCUMENT_ROOT .
'/product/class/product.class.php';
483 $tmpinvoice =
new Facture($db);
484 $tmptimespent =
new Task($db);
485 $tmpproduct =
new Product($db);
486 $fuser =
new User($db);
493 $generateinvoicemode =
GETPOST(
'generateinvoicemode',
'alphanohtml');
496 $prodDurationHoursBase = 1.0;
497 $product_data_cache = array();
499 $tmpproduct->fetch($idprod);
505 $prodDurationHoursBase = $tmpproduct->getProductDurationHours();
506 if ($prodDurationHoursBase < 0) {
508 $langs->load(
"errors");
512 $dataforprice = $tmpproduct->getSellPrice(
$mysoc, $projectstatic->thirdparty, 0);
514 $pu_ht = empty($dataforprice[
'pu_ht']) ? 0 : $dataforprice[
'pu_ht'];
515 $txtva = $dataforprice[
'tva_tx'];
516 $localtax1 =
get_localtax($txtva, 1, $projectstatic->thirdparty);
517 $localtax2 =
get_localtax($txtva, 2, $projectstatic->thirdparty);
519 $prodDurationHoursBase = 1;
527 $tmpinvoice->socid = $projectstatic->thirdparty->id;
529 $tmpinvoice->fk_project = $projectstatic->id;
530 $tmpinvoice->cond_reglement_id = $condidproject;
531 $tmpinvoice->mode_reglement_id = $projectstatic->thirdparty->mode_reglement_id;
532 $tmpinvoice->fk_account = $projectstatic->thirdparty->fk_account;
535 $tmpinvoice->fetch($invoiceToUse);
537 $result = $tmpinvoice->create($user);
545 if ($generateinvoicemode ==
'onelineperuser') {
546 $arrayoftasks = array();
547 foreach ($toselect as $key => $value) {
549 $object->fetchTimeSpent($value);
550 $arrayoftasks[
$object->timespent_fk_user][(int)
$object->timespent_fk_product][
'timespent'] +=
$object->timespent_duration;
551 $arrayoftasks[
$object->timespent_fk_user][(int)
$object->timespent_fk_product][
'totalvaluetodivideby3600'] += (
$object->timespent_duration *
$object->timespent_thm);
554 foreach ($arrayoftasks as $userid => $data) {
555 $fuser->fetch($userid);
556 $username = $fuser->getFullName($langs);
558 foreach ($data as $fk_product => $timespent_data) {
560 $qtyhour = $timespent_data[
'timespent'] / 3600;
561 $qtyhourtext =
convertSecondToTime($timespent_data[
'timespent'],
'all', $conf->global->MAIN_DURATION_OF_WORKDAY);
567 } elseif ($idprod <= 0) {
570 $pu_ht = $fuser->thm;
575 if ($timespent_data[
'timespent']) {
576 $pu_ht =
price2num(($timespent_data[
'totalvaluetodivideby3600'] / $timespent_data[
'timespent']),
'MU');
581 $prodDurationHours = $prodDurationHoursBase;
582 $idprodline = $idprod;
585 $localtax1line = $localtax1;
586 $localtax2line = $localtax2;
589 if (!empty($fk_product) && ($fk_product > 0) && ($fk_product !== $idprod)) {
590 if (!array_key_exists($fk_product, $product_data_cache)) {
591 $result = $tmpproduct->fetch($fk_product);
596 $prodDurationHours = $tmpproduct->getProductDurationHours();
597 if ($prodDurationHours < 0) {
599 $langs->load(
"errors");
605 $dataforprice = $tmpproduct->getSellPrice(
$mysoc, $projectstatic->thirdparty, 0);
607 $pu_htline = empty($dataforprice[
'pu_ht']) ? 0 : $dataforprice[
'pu_ht'];
608 $txtvaline = $dataforprice[
'tva_tx'];
609 $localtax1line = $dataforprice[
'localtax1'];
610 $localtax2line = $dataforprice[
'localtax2'];
612 $product_data_cache[$fk_product] = array(
'duration' => $prodDurationHours,
'dataforprice' => $dataforprice);
614 $prodDurationHours = $product_data_cache[$fk_product][
'duration'];
615 $pu_htline = empty($product_data_cache[$fk_product][
'dataforprice'][
'pu_ht']) ? 0 : $product_data_cache[$fk_product][
'dataforprice'][
'pu_ht'];
616 $txtvaline = $product_data_cache[$fk_product][
'dataforprice'][
'tva_tx'];
617 $localtax1line = $product_data_cache[$fk_product][
'dataforprice'][
'localtax1'];
618 $localtax2line = $product_data_cache[$fk_product][
'dataforprice'][
'localtax2'];
620 $idprodline = $fk_product;
627 $lineid = $tmpinvoice->addline($langs->trans(
"TimeSpentForInvoice").
' - '.$username .
' : ' . $qtyhourtext, $pu_htline, round($qtyhour / $prodDurationHours, 2), $txtvaline, $localtax1line, $localtax2line, ($idprodline > 0 ? $idprodline : 0), (float) $remiseproject,
'',
'', 0, 0, 0,
'HT', 0,
Product::TYPE_SERVICE);
634 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'element_time SET invoice_line_id = '.((int) $lineid).
', invoice_id = '.((int) $tmpinvoice->id);
635 $sql .=
' WHERE rowid IN ('.$db->sanitize(implode(
',', $toselect)).
') AND fk_user = '.((
int) $userid);
636 $result = $db->query($sql);
644 } elseif ($generateinvoicemode ==
'onelineperperiod') {
645 $arrayoftasks = array();
647 $withdetail =
GETPOST(
'detail_time_duration',
'alpha');
648 foreach ($toselect as $key => $value) {
650 $object->fetchTimeSpent($value);
652 $ftask =
new Task($db);
655 $fuser->fetch(
$object->timespent_fk_user);
656 $username = $fuser->getFullName($langs);
658 $arrayoftasks[
$object->timespent_id][
'timespent'] =
$object->timespent_duration;
659 $arrayoftasks[
$object->timespent_id][
'totalvaluetodivideby3600'] =
$object->timespent_duration *
$object->timespent_thm;
660 $arrayoftasks[
$object->timespent_id][
'note'] = $ftask->ref .
' - ' . $ftask->label .
' - ' . $username;
663 if (!empty($withdetail)) {
664 if (!empty(
$object->timespent_withhour)) {
671 $arrayoftasks[
$object->timespent_id][
'user'] =
$object->timespent_fk_user;
672 $arrayoftasks[
$object->timespent_id][
'fk_product'] =
$object->timespent_fk_product;
675 $pu_ht_saved = $pu_ht;
676 foreach ($arrayoftasks as $timespent_id => $value) {
677 $pu_ht = $pu_ht_saved;
678 $userid = $value[
'user'];
682 $qtyhour = $value[
'timespent'] / 3600;
686 if ($value[
'timespent']) {
687 $pu_ht =
price2num(($value[
'totalvaluetodivideby3600'] / $value[
'timespent']),
'MU');
692 $prodDurationHours = $prodDurationHoursBase;
693 $idprodline = $idprod;
696 $localtax1line = $localtax1;
697 $localtax2line = $localtax2;
699 if (!empty($value[
'fk_product']) && $value[
'fk_product'] !== $idprod) {
700 if (!array_key_exists($value[
'fk_product'], $product_data_cache)) {
701 $result = $tmpproduct->fetch($value[
'fk_product']);
706 $prodDurationHours = $tmpproduct->getProductDurationHours();
707 if ($prodDurationHours < 0) {
709 $langs->load(
"errors");
715 $dataforprice = $tmpproduct->getSellPrice(
$mysoc, $projectstatic->thirdparty, 0);
717 $pu_htline = empty($dataforprice[
'pu_ht']) ? 0 : $dataforprice[
'pu_ht'];
718 $txtvaline = $dataforprice[
'tva_tx'];
719 $localtax1line = $dataforprice[
'localtax1'];
720 $localtax2line = $dataforprice[
'localtax2'];
722 $product_data_cache[$value[
'fk_product']] = array(
'duration' => $prodDurationHours,
'dataforprice' => $dataforprice);
724 $prodDurationHours = $product_data_cache[$value[
'fk_product']][
'duration'];
725 $pu_htline = empty($product_data_cache[$value[
'fk_product']][
'dataforprice'][
'pu_ht']) ? 0 : $product_data_cache[$value[
'fk_product']][
'dataforprice'][
'pu_ht'];
726 $txtvaline = $product_data_cache[$value[
'fk_product']][
'dataforprice'][
'tva_tx'];
727 $localtax1line = $product_data_cache[$value[
'fk_product']][
'dataforprice'][
'localtax1'];
728 $localtax2line = $product_data_cache[$value[
'fk_product']][
'dataforprice'][
'localtax2'];
730 $idprodline = $value[
'fk_product'];
736 $lineid = $tmpinvoice->addline($value[
'note'], $pu_htline, round($qtyhour / $prodDurationHours, 2), $txtvaline, $localtax1line, $localtax2line, ($idprodline > 0 ? $idprodline : 0), (float) $remiseproject,
'',
'', 0, 0, 0,
'HT', 0,
Product::TYPE_SERVICE);
744 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'element_time SET invoice_line_id = '.((int) $lineid).
', invoice_id = '.((int) $tmpinvoice->id);
745 $sql .=
' WHERE rowid = '.((int) $timespent_id).
' AND fk_user = '.((int) $userid);
746 $result = $db->query($sql);
753 } elseif ($generateinvoicemode ==
'onelinepertask') {
754 $arrayoftasks = array();
755 foreach ($toselect as $key => $value) {
757 $object->fetchTimeSpent($value);
759 $arrayoftasks[
$object->id][(int)
$object->timespent_fk_product][
'timespent'] +=
$object->timespent_duration;
760 $arrayoftasks[
$object->id][(int)
$object->timespent_fk_product][
'totalvaluetodivideby3600'] += (
$object->timespent_duration *
$object->timespent_thm);
763 foreach ($arrayoftasks as $task_id => $data) {
764 $ftask =
new Task($db);
765 $ftask->fetch($task_id);
767 foreach ($data as $fk_product => $timespent_data) {
768 $qtyhour = $timespent_data[
'timespent'] / 3600;
769 $qtyhourtext =
convertSecondToTime($timespent_data[
'timespent'],
'all', $conf->global->MAIN_DURATION_OF_WORKDAY);
772 $prodDurationHours = $prodDurationHoursBase;
773 $idprodline = $idprod;
776 $localtax1line = $localtax1;
777 $localtax2line = $localtax2;
779 if (!empty($fk_product) && $fk_product !== $idprod) {
780 if (!array_key_exists($fk_product, $product_data_cache)) {
781 $result = $tmpproduct->fetch($fk_product);
786 $prodDurationHours = $tmpproduct->getProductDurationHours();
787 if ($prodDurationHours < 0) {
789 $langs->load(
"errors");
795 $dataforprice = $tmpproduct->getSellPrice(
$mysoc, $projectstatic->thirdparty, 0);
797 $pu_htline = empty($dataforprice[
'pu_ht']) ? 0 : $dataforprice[
'pu_ht'];
798 $txtvaline = $dataforprice[
'tva_tx'];
799 $localtax1line = $dataforprice[
'localtax1'];
800 $localtax2line = $dataforprice[
'localtax2'];
802 $product_data_cache[$fk_product] = array(
'duration' => $prodDurationHours,
'dataforprice' => $dataforprice);
804 $prodDurationHours = $product_data_cache[$fk_product][
'duration'];
805 $pu_htline = empty($product_data_cache[$fk_product][
'dataforprice'][
'pu_ht']) ? 0 : $product_data_cache[$fk_product][
'dataforprice'][
'pu_ht'];
806 $txtvaline = $product_data_cache[$fk_product][
'dataforprice'][
'tva_tx'];
807 $localtax1line = $product_data_cache[$fk_product][
'dataforprice'][
'localtax1'];
808 $localtax2line = $product_data_cache[$fk_product][
'dataforprice'][
'localtax2'];
810 $idprodline = $fk_product;
814 if ($idprodline > 0) {
816 $pu_ht_for_task = $pu_htline;
819 $pu_ht_for_task = (float)
price2num($timespent_data[
'totalvaluetodivideby3600'] / $timespent_data[
'timespent'],
'MU') * $prodDurationHours;
821 $pa_ht = (float)
price2num($timespent_data[
'totalvaluetodivideby3600'] / $timespent_data[
'timespent'],
'MU') * $prodDurationHours;
827 $pu_ht_for_task =
price2num($timespent_data[
'totalvaluetodivideby3600'] / $timespent_data[
'timespent'],
'MU');
829 $pa_ht =
price2num($timespent_data[
'totalvaluetodivideby3600'] / $timespent_data[
'timespent'],
'MU');
835 $lineName = $ftask->ref .
' - ' . $ftask->label;
836 $lineid = $tmpinvoice->addline($lineName, (
float) $pu_ht_for_task, (
float)
price2num($qtyhour / $prodDurationHours,
'MS'), $txtvaline, $localtax1line, $localtax2line, ($idprodline > 0 ? $idprodline : 0), (float) $remiseproject, $date_start, $date_end, 0, 0, 0,
'HT', 0, 1, -1, 0,
'', 0, 0, 0, $pa_ht);
845 $sql =
'UPDATE ' . MAIN_DB_PREFIX .
'element_time SET invoice_line_id = ' . ((int) $lineid) .
', invoice_id = ' . ((int) $tmpinvoice->id);
846 $sql .=
' WHERE rowid IN (' . $db->sanitize(implode(
',', $toselect)) .
')';
847 $result = $db->query($sql);
860 $urltoinvoice = $tmpinvoice->getNomUrl(0);
861 $mesg = $langs->trans(
"InvoiceGeneratedFromTimeSpent",
'{s1}');
862 $mesg = str_replace(
'{s1}', $urltoinvoice, $mesg);
872if ($action ==
'confirm_generateinter' && $user->hasRight(
'fichinter',
'creer')) {
873 $langs->load(
'interventions');
875 if (!empty($projectstatic->socid)) {
876 $projectstatic->fetch_thirdparty();
879 if (!($projectstatic->thirdparty->id > 0)) {
880 setEventMessages($langs->trans(
"ThirdPartyRequiredToGenerateIntervention"),
null,
'errors');
882 include_once DOL_DOCUMENT_ROOT .
'/compta/facture/class/facture.class.php';
883 include_once DOL_DOCUMENT_ROOT .
'/projet/class/project.class.php';
884 include_once DOL_DOCUMENT_ROOT .
'/product/class/product.class.php';
887 require_once DOL_DOCUMENT_ROOT .
'/fichinter/class/fichinter.class.php';
889 $tmptimespent =
new Task($db);
890 $fuser =
new User($db);
896 $tmpinter->socid = $projectstatic->thirdparty->id;
898 $tmpinter->fk_project = $projectstatic->id;
899 $tmpinter->description = $projectstatic->title . (!empty($projectstatic->description) ?
'-' . $projectstatic->description :
'');
902 $tmpinter->fetch($interToUse);
904 $result = $tmpinter->create($user);
912 $arrayoftasks = array();
913 foreach ($toselect as $key => $value) {
915 $object->fetchTimeSpent($value);
918 $arrayoftasks[
$object->timespent_id][
'timespent'] =
$object->timespent_duration;
919 $arrayoftasks[
$object->timespent_id][
'totalvaluetodivideby3600'] =
$object->timespent_duration *
$object->timespent_thm;
920 $arrayoftasks[
$object->timespent_id][
'note'] =
$object->timespent_note;
921 $arrayoftasks[
$object->timespent_id][
'date'] =
$object->timespent_datehour;
924 foreach ($arrayoftasks as $timespent_id => $value) {
925 $ftask =
new Task($db);
926 $ftask->fetch($value[
'id']);
928 $qtyhour = $value[
'timespent'] / 3600;
929 $qtyhourtext =
convertSecondToTime($value[
'timespent'],
'all', $conf->global->MAIN_DURATION_OF_WORKDAY);
932 $lineid = $tmpinter->addline($user, $tmpinter->id, $ftask->label . (!empty($value[
'note']) ?
' - ' . $value[
'note'] :
''), (int) $value[
'date'], $value[
'timespent']);
937 $timespent->fetch($timespent_id);
938 $timespent->intervention_id = $tmpinter->id;
939 $timespent->intervention_line_id = $lineid;
940 $result = $timespent->update($user);
950 $urltointer = $tmpinter->getNomUrl(0);
951 $mesg = $langs->trans(
"InterventionGeneratedFromTimeSpent",
'{s1}');
952 $mesg = str_replace(
'{s1}', $urltointer, $mesg);
969$form =
new Form($db);
972$userstatic =
new User($db);
974$arrayofselected = is_array($toselect) ? $toselect : array();
976$title =
$object->ref .
' - ' . $langs->trans(
"TimeSpent");
977if (!empty($withproject)) {
978 $title .=
' | ' . $langs->trans(
"Project") . (!empty($projectstatic->ref) ?
': ' . $projectstatic->ref :
'');
982llxHeader(
'', $title, $help_url,
'', 0, 0,
'',
'',
'',
'mod-project project-tasks page-task_time');
985$param = ((!empty($mode) && $mode ==
'mine') ?
'&mode=mine' :
'');
987 $param .=
'&search_user=' . ((int) $search_user);
990 $param .=
'&search_month=' . ((int) $search_month);
993 $param .=
'&search_year=' . ((int) $search_year);
997if (($id > 0 || !empty($ref)) || $projectidforalltimes > 0 || $allprojectforuser > 0) {
999 if ($projectidforalltimes > 0) {
1000 $result = $projectstatic->fetch($projectidforalltimes);
1001 if (!empty($projectstatic->socid)) {
1002 $projectstatic->fetch_thirdparty();
1004 $res = $projectstatic->fetch_optionals();
1005 } elseif (
$object->fetch($id, $ref) > 0) {
1009 $result = $projectstatic->fetch(
$object->fk_project);
1010 if (
getDolGlobalString(
'PROJECT_ALLOW_COMMENT_ON_PROJECT') && method_exists($projectstatic,
'fetchComments') && empty($projectstatic->comments)) {
1011 $projectstatic->fetchComments();
1013 if (!empty($projectstatic->socid)) {
1014 $projectstatic->fetch_thirdparty();
1016 $res = $projectstatic->fetch_optionals();
1018 $object->project = clone $projectstatic;
1021 $userRead = $projectstatic->restrictedProjectArea($user,
'read');
1022 $linktocreatetime =
'';
1024 if ($projectstatic->id > 0) {
1027 if (empty($id) || $tab ==
'timespent') {
1034 print
dol_get_fiche_head($head, $tab, $langs->trans(
"Project"), -1, ($projectstatic->public ?
'projectpub' :
'project'));
1038 $linkback =
'<a href="'.DOL_URL_ROOT.
'/projet/list.php?restore_lastsearch_values=1">'.$langs->trans(
"BackToList").
'</a>';
1040 $morehtmlref =
'<div class="refidno">';
1042 $morehtmlref .= $projectstatic->title;
1044 if (!empty($projectstatic->thirdparty->id) && $projectstatic->thirdparty->id > 0) {
1045 $morehtmlref .=
'<br>' . $projectstatic->thirdparty->getNomUrl(1,
'project');
1047 $morehtmlref .=
'</div>';
1050 if (!$user->hasRight(
'projet',
'all',
'lire')) {
1051 $objectsListId = $projectstatic->getProjectsAuthorizedForUser($user, 0, 0);
1052 $projectstatic->next_prev_filter =
"rowid:IN:" . $db->sanitize(count($objectsListId) ? implode(
',', array_keys($objectsListId)) :
'0');
1055 dol_banner_tab($projectstatic,
'project_ref', $linkback, 1,
'ref',
'ref', $morehtmlref, $param);
1057 print
'<div class="fichecenter">';
1058 print
'<div class="fichehalfleft">';
1059 print
'<div class="underbanner clearboth"></div>';
1061 print
'<table class="border tableforfield centpercent">';
1065 print
'<tr><td class="tdtop">';
1066 print $langs->trans(
"Usage");
1070 print
'<input type="checkbox" disabled name="usage_opportunity"' . (GETPOSTISSET(
'usage_opportunity') ? (
GETPOST(
'usage_opportunity',
'alpha') !=
'' ?
' checked="checked"' :
'') : ($projectstatic->usage_opportunity ?
' checked="checked"' :
'')) .
'"> ';
1071 $htmltext = $langs->trans(
"ProjectFollowOpportunity");
1072 print $form->textwithpicto($langs->trans(
"ProjectFollowOpportunity"), $htmltext);
1076 print
'<input type="checkbox" disabled name="usage_task"' . (GETPOSTISSET(
'usage_task') ? (
GETPOST(
'usage_task',
'alpha') !=
'' ?
' checked="checked"' :
'') : ($projectstatic->usage_task ?
' checked="checked"' :
'')) .
'"> ';
1077 $htmltext = $langs->trans(
"ProjectFollowTasks");
1078 print $form->textwithpicto($langs->trans(
"ProjectFollowTasks"), $htmltext);
1082 print
'<input type="checkbox" disabled name="usage_bill_time"' . (GETPOSTISSET(
'usage_bill_time') ? (
GETPOST(
'usage_bill_time',
'alpha') !=
'' ?
' checked="checked"' :
'') : ($projectstatic->usage_bill_time ?
' checked="checked"' :
'')) .
'"> ';
1083 $htmltext = $langs->trans(
"ProjectBillTimeDescription");
1084 print $form->textwithpicto($langs->trans(
"BillTime"), $htmltext);
1088 print
'<input type="checkbox" disabled name="usage_organize_event"' . (GETPOSTISSET(
'usage_organize_event') ? (
GETPOST(
'usage_organize_event',
'alpha') !=
'' ?
' checked="checked"' :
'') : ($projectstatic->usage_organize_event ?
' checked="checked"' :
'')) .
'"> ';
1089 $htmltext = $langs->trans(
"EventOrganizationDescriptionLong");
1090 print $form->textwithpicto($langs->trans(
"ManageOrganizeEvent"), $htmltext);
1096 print
'<tr><td>' . $langs->trans(
"Budget") .
'</td><td>';
1097 if (!is_null($projectstatic->budget_amount) && strcmp($projectstatic->budget_amount,
'')) {
1098 print
'<span class="amount">' .
price($projectstatic->budget_amount, 0, $langs, 1, 0, 0, $conf->currency) .
'</span>';
1103 print
'<tr><td>' . $langs->trans(
"Dates") .
'</td><td>';
1105 print($start ? $start :
'?');
1108 print($end ? $end :
'?');
1109 if ($projectstatic->hasDelay()) {
1115 print
'<tr><td class="titlefield">' . $langs->trans(
"Visibility") .
'</td><td>';
1116 if ($projectstatic->public) {
1117 print
img_picto($langs->trans(
'SharedProject'),
'world',
'class="paddingrightonly"');
1118 print $langs->trans(
'SharedProject');
1120 print
img_picto($langs->trans(
'PrivateProject'),
'private',
'class="paddingrightonly"');
1121 print $langs->trans(
'PrivateProject');
1132 $forcefieldid =
'projectid';
1133 $moreparam =
'&withproject=1';
1134 include DOL_DOCUMENT_ROOT .
'/core/tpl/extrafields_view.tpl.php';
1135 unset($forcefieldid, $moreparam);
1141 print
'<div class="fichehalfright">';
1142 print
'<div class="underbanner clearboth"></div>';
1144 print
'<table class="border tableforfield centpercent">';
1148 print
'<tr><td class="valignmiddle">' . $langs->trans(
"Categories") .
'</td><td>';
1149 print $form->showCategories($projectstatic->id,
'project', 1);
1154 print
'<tr><td class="titlefield'.($projectstatic->description ?
' noborderbottom' :
'').
'" colspan="2">'.$langs->trans(
"Description").
'</td></tr>';
1155 if ($projectstatic->description) {
1156 print
'<tr><td class="nottitleforfield" colspan="2">';
1157 print
'<div class="longmessagecut">';
1168 print
'<div class="clearboth"></div>';
1176 $linktocreatetimeBtnStatus = 0;
1177 $linktocreatetimeUrl =
'';
1178 $linktocreatetimeHelpText =
'';
1179 if ($user->hasRight(
'projet',
'time')) {
1180 if ($projectstatic->public || $userRead > 0) {
1181 $linktocreatetimeBtnStatus = 1;
1183 if (!empty($projectidforalltimes)) {
1185 $backtourl = $_SERVER[
'PHP_SELF'] .
'?projectid=' . $projectstatic->id . ($withproject ?
'&withproject=1' :
'');
1186 $linktocreatetimeUrl = $_SERVER[
'PHP_SELF'] .
'?' . ($withproject ?
'withproject=1' :
'') .
'&projectid=' . $projectstatic->id .
'&action=createtime&token=' .
newToken() . $param .
'&backtopage=' . urlencode($backtourl);
1189 $backtourl = $_SERVER[
'PHP_SELF'] .
'?id=' .
$object->id . ($withproject ?
'&withproject=1' :
'');
1190 $linktocreatetimeUrl = $_SERVER[
'PHP_SELF'] .
'?' . ($withproject ?
'withproject=1' :
'') . (
$object->id > 0 ?
'&id=' .
$object->id :
'&projectid=' . $projectstatic->id) .
'&action=createtime&token=' .
newToken() . $param .
'&backtopage=' . urlencode($backtourl);
1193 $linktocreatetimeBtnStatus = -2;
1194 $linktocreatetimeHelpText = $langs->trans(
"NotOwnerOfProject");
1197 $linktocreatetimeBtnStatus = -2;
1198 $linktocreatetimeHelpText = $langs->trans(
"NotEnoughPermissions");
1201 $paramsbutton = array(
'morecss' =>
'reposition');
1202 $linktocreatetime =
dolGetButtonTitle($langs->trans(
'AddTimeSpent'), $linktocreatetimeHelpText,
'fa fa-plus-circle', $linktocreatetimeUrl,
'', $linktocreatetimeBtnStatus, $paramsbutton);
1205 $massactionbutton =
'';
1206 $arrayofmassactions = array();
1208 if ($projectstatic->id > 0) {
1210 if ($projectstatic->usage_bill_time) {
1211 $arrayofmassactions = array(
1212 'generateinvoice' => $langs->trans(
"GenerateBill"),
1216 if (
isModEnabled(
'intervention') && $user->hasRight(
'ficheinter',
'creer')) {
1217 $langs->load(
"interventions");
1218 $arrayofmassactions[
'generateinter'] = $langs->trans(
"GenerateInter");
1221 if (in_array($massaction, array(
'presend',
'predelete',
'generateinvoice',
'generateinter'))) {
1222 $arrayofmassactions = array();
1224 $massactionbutton = $form->selectMassAction(
'', $arrayofmassactions);
1231 if (empty($projectidforalltimes) && empty($allprojectforuser)) {
1233 print
dol_get_fiche_head($head,
'task_time', $langs->trans(
"Task"), -1,
'projecttask', 0,
'',
'reposition');
1235 $param = (
GETPOST(
'withproject') ?
'&withproject=1' :
'');
1236 $linkback =
GETPOST(
'withproject') ?
'<a href="'.DOL_URL_ROOT.
'/projet/tasks.php?id='.$projectstatic->id.
'">'.$langs->trans(
"BackToList").
'</a>' :
'';
1238 if ($action ==
'deleteline') {
1239 $urlafterconfirm = $_SERVER[
"PHP_SELF"] .
"?" . (
$object->id > 0 ?
"id=" .
$object->id :
'projectid=' . $projectstatic->id) .
'&lineid=' .
GETPOSTINT(
"lineid") . $param;
1240 $formconfirm .= $form->formconfirm($urlafterconfirm, $langs->trans(
"DeleteATimeSpent"), $langs->trans(
"ConfirmDeleteATimeSpent"),
"confirm_deleteline",
'',
'', 1);
1243 if (!
GETPOST(
'withproject') || empty($projectstatic->id)) {
1244 $projectsListId = $projectstatic->getProjectsAuthorizedForUser($user, 0, 1);
1245 $object->next_prev_filter =
"fk_projet:IN:" . $db->sanitize($projectsListId);
1247 $object->next_prev_filter =
"fk_projet:=:" . ((int) $projectstatic->id);
1253 if (empty($withproject)) {
1254 $morehtmlref .=
'<div class="refidno">';
1255 $morehtmlref .= $langs->trans(
"Project") .
': ';
1256 $morehtmlref .= $projectstatic->getNomUrl(1);
1257 $morehtmlref .=
'<br>';
1260 $morehtmlref .= $langs->trans(
"ThirdParty") .
': ';
1261 if (!empty($projectstatic->thirdparty) && is_object($projectstatic->thirdparty)) {
1262 $morehtmlref .= $projectstatic->thirdparty->getNomUrl(1);
1264 $morehtmlref .=
'</div>';
1267 dol_banner_tab($object,
'ref', $linkback, 1,
'ref',
'ref', $morehtmlref, $param);
1269 print
'<div class="fichecenter">';
1270 print
'<div class="fichehalfleft">';
1272 print
'<div class="underbanner clearboth"></div>';
1273 print
'<table class="border centpercent tableforfield">';
1276 print
'<tr><td>' . $langs->trans(
"ParentTask") .
'</td><td>';
1277 if (
$object->fk_task_parent > 0) {
1278 $tasktmp =
new Task($db);
1279 $tasktmp->fetch(
$object->fk_task_parent);
1280 print $tasktmp->getNomUrl(1);
1285 print
'<tr><td class="titlefield">' . $langs->trans(
"DateStart") .
' - ' . $langs->trans(
"Deadline") .
'</td><td>';
1287 print($start ? $start :
'?');
1290 print($end ? $end :
'?');
1297 print
'<tr><td>' . $langs->trans(
"PlannedWorkload") .
'</td><td>';
1298 if (
$object->planned_workload) {
1306 print
'<div class="fichehalfright">';
1308 print
'<div class="underbanner clearboth"></div>';
1309 print
'<table class="border tableforfield centpercent">';
1312 print
'<tr><td class="titlefield">' . $langs->trans(
"ProgressDeclared") .
'</td><td>';
1317 print
'<tr><td>' . $langs->trans(
"ProgressCalculated") .
'</td><td>';
1318 if (
$object->planned_workload) {
1319 $tmparray =
$object->getSummaryOfTimeSpent();
1320 if ($tmparray[
'total_duration'] > 0) {
1321 print round($tmparray[
'total_duration'] /
$object->planned_workload * 100, 2) .
' %';
1326 print
'<span class="opacitymedium">' . $langs->trans(
"WorkloadNotDefined") .
'</span>';
1337 print
'<div class="clearboth"></div>';
1341 if ($action ==
'deleteline') {
1342 $urlafterconfirm = $_SERVER[
"PHP_SELF"] .
"?" . ($projectstatic->id > 0 ?
'projectid=' . $projectstatic->id : (
$object->id > 0 ?
"id=" .
$object->id :
'')) .
'&lineid=' .
GETPOSTINT(
"lineid") . ($withproject ?
'&withproject=1' :
'').
"&contextpage=" . urlencode($contextpage).$param;
1343 $formconfirm .= $form->formconfirm($urlafterconfirm, $langs->trans(
"DeleteATimeSpent"), $langs->trans(
"ConfirmDeleteATimeSpent"),
"confirm_deleteline",
'',
'', 1);
1348 $parameters = array(
'formConfirm' => $formconfirm,
"projectstatic" => $projectstatic,
"withproject" => $withproject);
1349 $reshook = $hookmanager->executeHooks(
'formConfirm', $parameters, $object, $action);
1350 if (empty($reshook)) {
1351 $formconfirm .= $hookmanager->resPrint;
1352 } elseif ($reshook > 0) {
1353 $formconfirm = $hookmanager->resPrint;
1357 if ($projectstatic->id > 0 || $allprojectforuser > 0) {
1359 $hookmanager->initHooks(array(
'tasktimelist'));
1365 $arrayfields = array();
1366 $arrayfields[
't.element_date'] = array(
'label' => $langs->trans(
"Date"),
'checked' =>
'1');
1367 $arrayfields[
'p.fk_soc'] = array(
'label' => $langs->trans(
"ThirdParty"),
'type' =>
'integer:Societe:/societe/class/societe.class.php:1',
'checked' =>
'1');
1368 $arrayfields[
's.name_alias'] = array(
'label' => $langs->trans(
"AliasNameShort"),
'type' =>
'integer:Societe:/societe/class/societe.class.php:1');
1369 if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) {
1370 if (! empty($allprojectforuser)) {
1371 $arrayfields[
'p.project_ref'] = [
'label' => $langs->trans(
'RefProject'),
'checked' =>
'1'];
1372 $arrayfields[
'p.project_label'] = [
'label' => $langs->trans(
'ProjectLabel'),
'checked' =>
'1'];
1374 $arrayfields[
't.element_ref'] = array(
'label' => $langs->trans(
"RefTask"),
'checked' =>
'1');
1375 $arrayfields[
't.element_label'] = array(
'label' => $langs->trans(
"LabelTask"),
'checked' =>
'1');
1377 $arrayfields[
'author'] = array(
'label' => $langs->trans(
"By"),
'checked' =>
'1');
1378 $arrayfields[
't.note'] = array(
'label' => $langs->trans(
"Note"),
'checked' =>
'1');
1379 if (
isModEnabled(
'service') && !empty($projectstatic->thirdparty) && $projectstatic->thirdparty->id > 0 && $projectstatic->usage_bill_time) {
1380 $arrayfields[
't.fk_product'] = array(
'label' => $langs->trans(
"Product"),
'checked' =>
'1');
1382 $arrayfields[
't.element_duration'] = array(
'label' => $langs->trans(
"Duration"),
'checked' =>
'1');
1383 $arrayfields[
'value'] = array(
'label' => $langs->trans(
"Value"),
'checked' =>
'1',
'enabled' => (
string) (
int)
isModEnabled(
"salaries"));
1384 $arrayfields[
'valuebilled'] = array(
'label' => $langs->trans(
"Billed"),
'checked' =>
'1',
'enabled' => (
string) (
int) (((
getDolGlobalInt(
'PROJECT_HIDE_TASKS') || !
getDolGlobalInt(
'PROJECT_BILL_TIME_SPENT')) ? 0 : 1) && $projectstatic->usage_bill_time));
1386 include DOL_DOCUMENT_ROOT .
'/core/tpl/extrafields_list_array_fields.tpl.php';
1391 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
1392 $param .=
'&contextpage=' . urlencode($contextpage);
1394 if ($limit > 0 && $limit != $conf->liste_limit) {
1395 $param .=
'&limit='.((int) $limit);
1398 $param .=
'&id='.((int) $id);
1400 if ($search_month > 0) {
1401 $param .=
'&search_month=' . urlencode((
string) ($search_month));
1403 if ($search_year > 0) {
1404 $param .=
'&search_year=' . urlencode((
string) ($search_year));
1406 if (!empty($search_user)) {
1407 $param .=
'&search_user='.urlencode($search_user);
1409 if ($search_task_ref !=
'') {
1410 $param .=
'&search_task_ref=' . urlencode($search_task_ref);
1412 if ($search_company !=
'') {
1413 $param .=
'&search_company=' . urlencode($search_company);
1415 if ($search_company_alias !=
'') {
1416 $param .=
'&search_company_alias=' . urlencode($search_company_alias);
1418 if ($search_project_ref !=
'') {
1419 $param .=
'&search_project_ref=' . urlencode($search_project_ref);
1421 if ($search_project_label !=
'') {
1422 $param .=
'&search_project_label=' . urlencode($search_project_label);
1424 if ($search_task_label !=
'') {
1425 $param .=
'&search_task_label=' . urlencode($search_task_label);
1427 if ($search_note !=
'') {
1428 $param .=
'&search_note=' . urlencode($search_note);
1430 if ($search_duration !=
'') {
1431 $param .=
'&search_field2=' . urlencode((
string) ($search_duration));
1433 if ($optioncss !=
'') {
1434 $param .=
'&optioncss=' . urlencode($optioncss);
1436 if ($search_date_startday) {
1437 $param .=
'&search_date_startday=' . urlencode((
string) ($search_date_startday));
1439 if ($search_date_startmonth) {
1440 $param .=
'&search_date_startmonth=' . urlencode((
string) ($search_date_startmonth));
1442 if ($search_date_startyear) {
1443 $param .=
'&search_date_startyear=' . urlencode((
string) ($search_date_startyear));
1445 if ($search_date_endday) {
1446 $param .=
'&search_date_endday=' . urlencode((
string) ($search_date_endday));
1448 if ($search_date_endmonth) {
1449 $param .=
'&search_date_endmonth=' . urlencode((
string) ($search_date_endmonth));
1451 if ($search_date_endyear) {
1452 $param .=
'&search_date_endyear=' . urlencode((
string) ($search_date_endyear));
1454 if ($search_timespent_starthour) {
1455 $param .=
'&search_timespent_duration_starthour=' . urlencode((
string) ($search_timespent_starthour));
1457 if ($search_timespent_startmin) {
1458 $param .=
'&search_timespent_duration_startmin=' . urlencode((
string) ($search_timespent_startmin));
1460 if ($search_timespent_endhour) {
1461 $param .=
'&search_timespent_duration_endhour=' . urlencode((
string) ($search_timespent_endhour));
1463 if ($search_timespent_endmin) {
1464 $param .=
'&search_timespent_duration_endmin=' . urlencode((
string) ($search_timespent_endmin));
1467 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
1469 $param .=
'&id=' . urlencode((
string) ($id));
1472 $param .=
'&projectid=' . urlencode((
string) ($projectid));
1475 $param .=
'&withproject=' . urlencode((
string) ($withproject));
1478 $parameters = array(
'param' => &$param);
1479 $reshook = $hookmanager->executeHooks(
'printFieldListSearchParam', $parameters, $object, $action);
1480 $param .= $hookmanager->resPrint;
1482 print
'<form method="POST" action="' . $_SERVER[
"PHP_SELF"] .
'">';
1483 if ($optioncss !=
'') {
1484 print
'<input type="hidden" name="optioncss" value="' . $optioncss .
'">';
1486 print
'<input type="hidden" name="token" value="' .
newToken() .
'">';
1487 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
1488 if ($action ==
'editline') {
1489 print
'<input type="hidden" name="action" value="updateline">';
1490 } elseif ($action ==
'splitline') {
1491 print
'<input type="hidden" name="action" value="updatesplitline">';
1492 } elseif ($action ==
'createtime' && $user->hasRight(
'projet',
'time')) {
1493 print
'<input type="hidden" name="action" value="addtimespent">';
1494 } elseif ($massaction ==
'generateinvoice' && $user->hasRight(
'facture',
'creer')) {
1495 print
'<input type="hidden" name="action" value="confirm_generateinvoice">';
1496 } elseif ($massaction ==
'generateinter' && $user->hasRight(
'ficheinter',
'creer')) {
1497 print
'<input type="hidden" name="action" value="confirm_generateinter">';
1499 print
'<input type="hidden" name="action" value="list">';
1501 print
'<input type="hidden" name="sortfield" value="' . $sortfield .
'">';
1502 print
'<input type="hidden" name="sortorder" value="' . $sortorder .
'">';
1506 print
'<input type="hidden" name="id" value="' . ((int) $id) .
'">';
1507 print
'<input type="hidden" name="projectid" value="' . $projectidforalltimes .
'">';
1508 print
'<input type="hidden" name="withproject" value="' . $withproject .
'">';
1509 print
'<input type="hidden" name="tab" value="' . $tab .
'">';
1510 print
'<input type="hidden" name="page_y" value="">';
1513 if ($massaction ==
'generateinvoice') {
1514 if (!empty($projectstatic->thirdparty) && $projectstatic->thirdparty->id > 0) {
1515 print
'<table class="noborder centerpercent">';
1517 print
'<td class="titlefield">';
1518 print $langs->trans(
'DateInvoice');
1521 print $form->selectDate(
'',
'', 0, 0, 0,
'', 1, 1);
1527 print $langs->trans(
'Mode');
1531 'onelineperuser' =>
'OneLinePerUser',
1532 'onelinepertask' =>
'OneLinePerTask',
1533 'onelineperperiod' =>
'OneLinePerTimeSpentLine',
1535 print $form->selectarray(
'generateinvoicemode', $tmparray,
'onelineperuser', 0, 0, 0,
'', 1);
1536 print
"\n" .
'<script type="text/javascript">';
1538 $(document).ready(function () {
1539 setDetailVisibility();
1540 $("#generateinvoicemode").change(function() {
1541 setDetailVisibility();
1543 function setDetailVisibility() {
1544 generateinvoicemode = $("#generateinvoicemode option:selected").val();
1545 if (generateinvoicemode=="onelineperperiod") {
1546 $("#detail_time_duration").show();
1548 $("#detail_time_duration").hide();
1553 print
'</script>' .
"\n";
1554 print
'<span style="display:none" id="detail_time_duration"><input type="checkbox" value="detail" name="detail_time_duration"/>' . $langs->trans(
'AddDetailDateAndDuration') .
'</span>';
1561 print $langs->trans(
'ServiceToUseOnLines');
1564 $form->select_produits(0,
'productid', 1, 0, $projectstatic->thirdparty->price_level, 1, 2,
'', 0, array(), $projectstatic->thirdparty->id,
'None', 0,
'maxwidth500');
1569 print
'<td class="titlefield">';
1570 print $langs->trans(
'InvoiceToUse');
1573 print $form->selectInvoiceForTimeProject($projectstatic->thirdparty->id,
'',
'invoiceid', 24, 0, $langs->trans(
'NewInvoice'), 1, 0, 0,
'maxwidth500',
'',
'all');
1577 print
'<td class="titlefield">';
1578 print $langs->trans(
"CustomerRelativeDiscount");
1581 print
'<input type="text" size="5" name="remiseproject" value="'.$projectstatic->thirdparty->remise_percent.
'">%';
1584 print
'<tr class="newinvoicedetail">';
1585 print
'<td class="titlefield">';
1586 print $langs->trans(
"PaymentConditions");
1589 print $form->getSelectConditionsPaiements((
int) $projectstatic->thirdparty->cond_reglement_id,
'condidproject');
1603 print
'<div class="center">';
1604 print
'<input type="submit" class="button" id="createbills" name="createbills" value="' . $langs->trans(
'GenerateBill') .
'"> ';
1605 print
'<input type="submit" class="button button-cancel" id="cancel" name="cancel" value="' . $langs->trans(
"Cancel") .
'">';
1609 print
'<div class="warning">' . $langs->trans(
"ThirdPartyRequiredToGenerateInvoice") .
'</div>';
1610 print
'<div class="center">';
1611 print
'<input type="submit" class="button button-cancel" id="cancel" name="cancel" value="' . $langs->trans(
"Cancel") .
'">';
1615 } elseif ($massaction ==
'generateinter') {
1617 print
'<input type="hidden" name="massaction" value="confirm_createinter">';
1619 if (!empty($projectstatic->thirdparty) && $projectstatic->thirdparty->id > 0) {
1621 print
'<table class="noborder centpercent">';
1623 print
'<td class="titlefield">';
1624 print
img_picto(
'',
'intervention',
'class="pictofixedwidth"') . $langs->trans(
'InterToUse');
1628 print $forminter->select_interventions($projectstatic->thirdparty->id, 0,
'interid', 24, $langs->trans(
'NewInter'),
true);
1633 print
'<div class="center">';
1634 print
'<input type="submit" class="button" id="createinter" name="createinter" value="' . $langs->trans(
'GenerateInter') .
'"> ';
1635 print
'<input type="submit" class="button" id="cancel" name="cancel" value="' . $langs->trans(
'Cancel') .
'">';
1639 print
'<div class="warning">' . $langs->trans(
"ThirdPartyRequiredToGenerateIntervention") .
'</div>';
1640 print
'<div class="center">';
1641 print
'<input type="submit" class="button" id="cancel" name="cancel" value="' . $langs->trans(
'Cancel') .
'">';
1648 $parameters = array(
1649 'toselect' => $toselect,
1650 'uploaddir' => isset($uploaddir) ? $uploaddir : null
1653 $reshook = $hookmanager->executeHooks(
'doPreMassActions', $parameters, $object, $action);
1657 print $hookmanager->resPrint;
1665 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
1666 $selectedfields = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
getDolGlobalString(
'MAIN_CHECKBOX_LEFT_COLUMN'));
1669 if ($projectstatic->usage_bill_time) {
1670 $arrayfields[
'valuebilled'][
'checked'] = 1;
1673 $sql =
"SELECT t.rowid, t.fk_element, t.element_date, t.element_datehour, t.element_date_withhour, t.element_duration, t.fk_user, t.note, t.thm,";
1674 $sql .=
" t.fk_product, t.invoice_line_id,";
1675 $sql .=
" pt.rowid as taskid, pt.ref, pt.label, pt.fk_projet, pt.billable,";
1676 $sql .=
" u.lastname, u.firstname, u.login, u.photo, u.gender, u.statut as user_status,";
1677 $sql .=
" il.fk_facture as invoice_id, inv.fk_statut,";
1678 $sql .=
" p.fk_soc,s.name_alias";
1679 if (!empty($extrafields->attributes[
'projet_task'][
'label'])) {
1680 foreach ($extrafields->attributes[
'projet_task'][
'label'] as $key => $val) {
1681 $sql .= ($extrafields->attributes[
'projet_task'][
'type'][$key] !=
'separate' ?
",efpt.".$key.
" as options_".$key :
'');
1685 $parameters = array();
1686 $reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters, $object, $action);
1687 $sql .= $hookmanager->resPrint;
1688 $sql = preg_replace(
'/,\s*$/',
'', $sql);
1692 $sql .=
" FROM ".MAIN_DB_PREFIX.
"element_time as t";
1693 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"facturedet as il ON il.rowid = t.invoice_line_id";
1694 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"facture as inv ON inv.rowid = il.fk_facture";
1695 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"product as prod ON prod.rowid = t.fk_product";
1696 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"projet_task as pt ON pt.rowid = t.fk_element";
1697 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"projet_task_extrafields as efpt ON pt.rowid = efpt.fk_object";
1698 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"projet as p ON p.rowid = pt.fk_projet";
1699 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"user as u ON t.fk_user = u.rowid";
1700 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON s.rowid = p.fk_soc";
1703 $parameters = array();
1704 $reshook = $hookmanager->executeHooks(
'printFieldListFrom', $parameters, $object, $action);
1705 $sql .= $hookmanager->resPrint;
1706 $sql .=
" WHERE elementtype = 'task'";
1707 $sql .=
" AND p.entity IN (".getEntity(
'project').
")";
1708 if (!$user->hasRight(
'projet',
'all',
'lire')) {
1712 $projectsListId = $projectstatic->getProjectsAuthorizedForUser($user, 0, 1, $user->socid > 0 ? $user->socid : 0, $filterproj);
1713 $sql .=
" AND p.rowid IN (".$db->sanitize($projectsListId).
")";
1715 if (empty($projectidforalltimes) && empty($allprojectforuser)) {
1717 $sql .=
" AND t.fk_element =".((int)
$object->id);
1718 } elseif (!empty($projectidforalltimes)) {
1720 $sql .=
" AND pt.fk_projet IN (" . $db->sanitize((
string) $projectidforalltimes) .
")";
1721 } elseif (!empty($allprojectforuser)) {
1723 if (empty($search_user) && !empty($arrayfields[
'author'][
'checked'])) {
1724 $search_user = $user->id;
1726 if ($search_user > 0) {
1727 $sql .=
" AND t.fk_user = " . ((int) $search_user);
1734 if ($search_task_ref) {
1737 if (empty($arrayfields[
's.name_alias'][
'checked']) && $search_company) {
1738 $sql .=
natural_search(array(
"s.nom",
"s.name_alias"), $search_company);
1740 if ($search_company) {
1743 if ($search_company_alias) {
1747 if ($search_project_ref) {
1750 if ($search_project_label) {
1753 if ($search_task_label) {
1756 if ($search_user > 0) {
1759 if (!empty($search_product_ref)) {
1762 if ($search_valuebilled ==
'1') {
1763 $sql .=
' AND t.invoice_id > 0';
1765 if ($search_valuebilled ==
'0') {
1766 $sql .=
' AND (t.invoice_id = 0 OR t.invoice_id IS NULL)';
1769 if ($search_date_start) {
1770 $sql .=
" AND t.element_date >= '".$db->idate($search_date_start).
"'";
1772 if ($search_date_end) {
1773 $sql .=
" AND t.element_date <= '".$db->idate($search_date_end).
"'";
1776 if (!empty($arrayfields[
't.element_duration'][
'checked'])) {
1777 if ($search_timespent_starthour || $search_timespent_startmin) {
1778 $timespent_duration_start = $search_timespent_starthour * 60 * 60;
1779 $timespent_duration_start += ($search_timespent_startmin ? $search_timespent_startmin : 0) * 60;
1780 $sql .=
" AND t.element_duration >= " . $timespent_duration_start;
1783 if ($search_timespent_endhour || $search_timespent_endmin) {
1784 $timespent_duration_end = $search_timespent_endhour * 60 * 60;
1785 $timespent_duration_end += ($search_timespent_endmin ? $search_timespent_endmin : 0) * 60;
1786 $sql .=
" AND t.element_duration <= " . $timespent_duration_end;
1790 $sql .=
dolSqlDateFilter(
't.element_datehour', $search_day, $search_month, $search_year);
1793 $extrafieldsobjectkey =
'projet_task';
1794 $extrafieldsobjectprefix =
'efpt.';
1795 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
1798 $parameters = array();
1799 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object, $action);
1800 $sql .= $hookmanager->resPrint;
1803 $nbtotalofrecords =
'';
1806 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords', $sql);
1807 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
1808 $resql = $db->query($sqlforcount);
1810 $objforcount = $db->fetch_object($resql);
1811 $nbtotalofrecords = $objforcount->nbtotalofrecords;
1816 if (($page * $limit) > (
int) $nbtotalofrecords) {
1824 $sql .= $db->order($sortfield, $sortorder);
1826 $sql .= $db->plimit($limit + 1, $offset);
1829 $resql = $db->query($sql);
1835 $num = $db->num_rows($resql);
1838 if (!empty($projectidforalltimes)) {
1839 print
'<!-- List of time spent for project -->' .
"\n";
1841 $title = $langs->trans(
"ListTaskTimeUserProject");
1843 print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'clock', 0, $linktocreatetime,
'', $limit, 0, 0, 1);
1845 print
'<!-- List of time spent -->' .
"\n";
1847 $title = $langs->trans(
"ListTaskTimeForTask");
1849 print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'clock', 0, $linktocreatetime,
'', $limit, 0, 0, 1);
1854 $row = $db->fetch_object($resql);
1868 if ($action ==
'createtime' && $user->hasRight(
'projet',
'time')) {
1869 print
'<!-- table to add time spent -->' .
"\n";
1871 print
'<input type="hidden" name="taskid" value="' .
$id .
'">';
1874 print
'<div class="div-table-responsive-no-min">';
1875 print
'<table class="noborder nohover centpercent">';
1877 print
'<tr class="liste_titre">';
1878 print
'<td>' . $langs->trans(
"Date") .
'</td>';
1879 if (!empty($allprojectforuser)) {
1880 print
'<td>' . $langs->trans(
"Project") .
'</td>';
1883 print
'<td>' . $langs->trans(
"Task") .
'</td>';
1885 print
'<td>' . $langs->trans(
"By") .
'</td>';
1886 print
'<td>' . $langs->trans(
"Note") .
'</td>';
1887 print
'<td>' . $langs->trans(
"NewTimeSpent") .
'</td>';
1888 print
'<td>' . $langs->trans(
"ProgressDeclared") .
'</td>';
1892 if (
isModEnabled(
"service") && !empty($projectstatic->thirdparty) && $projectstatic->thirdparty->id > 0 && $projectstatic->usage_bill_time) {
1893 print
'<td>'.$langs->trans(
"Product").
'</td>';
1897 $parameters = array(
'mode' =>
'create');
1898 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object, $action);
1899 print $hookmanager->resPrint;
1903 print
'<tr class="oddeven nohover">';
1906 print
'<td class="maxwidthonsmartphone">';
1908 print $form->selectDate($newdate,
'time', ($conf->browser->layout ==
'phone' ? 2 : 1), 1, 2,
"timespent_date", 1, 0);
1911 if (!empty($allprojectforuser)) {
1920 print
'<td class="maxwidthonsmartphone">';
1921 $nboftasks = $formproject->selectTasks(-1,
GETPOSTINT(
'taskid'),
'taskid', 0, 0,
'1', 1, 0, 0,
'maxwidth300', (
string) $projectstatic->id,
'progress');
1926 print
'<td class="maxwidthonsmartphone nowraponall">';
1927 $contactsofproject = $projectstatic->getListContactId(
'internal');
1928 if (count($contactsofproject) > 0) {
1929 print
img_object(
'',
'user',
'class="hideonsmartphone"');
1930 if (in_array($user->id, $contactsofproject)) {
1931 $userid = $user->id;
1933 $userid = $contactsofproject[0];
1936 if ($projectstatic->public) {
1937 $contactsofproject = array();
1939 print $form->select_dolusers((
GETPOSTINT(
'userid') ?
GETPOSTINT(
'userid') : $userid),
'userid', 0, null, 0,
'', $contactsofproject,
'0', 0, 0,
'', 0, $langs->trans(
"ResourceNotAssignedToProject"),
'minwidth150imp maxwidth200');
1942 print
img_error($langs->trans(
'FirstAddRessourceToAllocateTime')) .
' ' . $langs->trans(
'FirstAddRessourceToAllocateTime');
1949 print
'<textarea name="timespent_note" class="maxwidth100onsmartphone" rows="' . ROWS_2 .
'">' . (
GETPOST(
'timespent_note') ?
GETPOST(
'timespent_note') :
'') .
'</textarea>';
1953 print
'<td class="nowraponall">';
1954 $durationtouse = (
GETPOST(
'timespent_duration') ?
GETPOST(
'timespent_duration') :
'');
1955 if (GETPOSTISSET(
'timespent_durationhour') || GETPOSTISSET(
'timespent_durationmin')) {
1956 $durationtouse = ((int)
GETPOST(
'timespent_durationhour') * 3600 + (int)
GETPOST(
'timespent_durationmin') * 60);
1958 print $form->select_duration(
'timespent_duration', $durationtouse, 0,
'text');
1962 print
'<td class="nowrap">';
1963 print $formother->select_percent(
GETPOST(
'progress') ?
GETPOST(
'progress') :
$object->progress,
'progress', 0, 5, 0, 100, 1);
1971 if (
isModEnabled(
"service") && !empty($projectstatic->thirdparty) && $projectstatic->thirdparty->id > 0 && $projectstatic->usage_bill_time) {
1972 print
'<td class="nowraponall">';
1974 print $form->select_produits((GETPOSTISSET(
'fk_product') ?
GETPOSTINT(
"fk_product") :
''),
'fk_product', 1, 0, $projectstatic->thirdparty->price_level, 1, 2,
'', 1, array(), $projectstatic->thirdparty->id,
'None', 0,
'maxwidth150', ($user->hasRight(
'produit',
'lire') ? 0 : 1),
'', null, 1);
1980 $parameters = array(
'mode' =>
'create');
1981 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $object, $action);
1982 print $hookmanager->resPrint;
1984 print
'<td class="center">';
1985 $form->buttonsSaveCancel();
1986 print
'<input type="submit" name="save" class="button buttongen smallpaddingimp marginleftonly margintoponlyshort marginbottomonlyshort button-add reposition" value="'.$langs->trans(
"Add").
'">';
1987 print
'<input type="submit" name="cancel" class="button buttongen smallpaddingimp marginleftonly margintoponlyshort marginbottomonlyshort button-cancel" value="'.$langs->trans(
"Cancel").
'">';
1996 $moreforfilter =
'';
1998 $parameters = array();
1999 $reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
2000 if (empty($reshook)) {
2001 $moreforfilter .= $hookmanager->resPrint;
2003 $moreforfilter = $hookmanager->resPrint;
2006 if (!empty($moreforfilter)) {
2007 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
2008 print $moreforfilter;
2012 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
2013 $selectedfields = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
getDolGlobalString(
'MAIN_CHECKBOX_LEFT_COLUMN'));
2014 $selectedfields .= (is_array($arrayofmassactions) && count($arrayofmassactions) ? $form->showCheckAddButtons(
'checkforselect', 1) :
'');
2017 if ($projectstatic->usage_bill_time) {
2018 $arrayfields[
'valuebilled'][
'checked'] = 1;
2021 print
'<!-- Liste of time spent -->'.
"\n";
2022 print
'<div class="div-table-responsive">';
2023 print
'<table class="tagtable nobottomiftotal liste' . ($moreforfilter ?
" listwithfilterbefore" :
"") .
'">' .
"\n";
2027 print
'<tr class="liste_titre_filter">';
2030 print
'<td class="liste_titre center">';
2031 $searchpicto = $form->showFilterButtons(
'left');
2036 if (!empty($arrayfields[
't.element_date'][
'checked'])) {
2037 print
'<td class="liste_titre left">';
2038 print
'<div class="nowrapfordate paddingright">';
2039 print $form->selectDate($search_date_start ? $search_date_start : -1,
'search_date_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
2041 print
'<div class="nowrapfordate">';
2042 print $form->selectDate($search_date_end ? $search_date_end : -1,
'search_date_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
2047 if (!empty($arrayfields[
'p.fk_soc'][
'checked'])) {
2048 print
'<td class="liste_titre"><input type="text" class="flat maxwidth100" name="$search_company" value="' .
dol_escape_htmltag($search_company) .
'"></td>';
2052 if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2053 print
'<td class="liste_titre"><input type="text" class="flat maxwidth100" name="$search_company_alias" value="' .
dol_escape_htmltag($search_company_alias) .
'"></td>';
2056 if (!empty($allprojectforuser)) {
2057 if (!empty($arrayfields[
'p.project_ref'][
'checked'])) {
2058 print
'<td class="liste_titre"><input type="text" class="flat maxwidth125" name="$search_project_ref" value="' .
dol_escape_htmltag($search_project_ref) .
'"></td>';
2060 if (!empty($arrayfields[
'p.project_label'][
'checked'])) {
2061 print
'<td class="liste_titre"><input type="text" class="flat maxwidth125" name="$search_project_label" value="' .
dol_escape_htmltag($search_project_label) .
'"></td>';
2065 if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) {
2066 if (!empty($arrayfields[
't.element_ref'][
'checked'])) {
2067 print
'<td class="liste_titre"><input type="text" class="flat maxwidth125" name="search_task_ref" value="'.dol_escape_htmltag($search_task_ref).
'"></td>';
2069 if (!empty($arrayfields[
't.element_label'][
'checked'])) {
2070 print
'<td class="liste_titre"><input type="text" class="flat maxwidth125" name="search_task_label" value="'.dol_escape_htmltag($search_task_label).
'"></td>';
2074 if (!empty($arrayfields[
'author'][
'checked'])) {
2075 print
'<td class="liste_titre">'.$form->select_dolusers(($search_user > 0 ? $search_user : -1),
'search_user', 1, null, 0,
'',
'',
'0', 0, 0,
'', 0,
'',
'maxwidth125').
'</td>';
2078 if (!empty($arrayfields[
't.note'][
'checked'])) {
2079 print
'<td class="liste_titre"><input type="text" class="flat maxwidth75" name="search_note" value="' .
dol_escape_htmltag($search_note) .
'"></td>';
2082 if (!empty($arrayfields[
't.element_duration'][
'checked'])) {
2084 print
'<td class="liste_titre right">';
2086 $durationtouse_start =
'';
2087 if ($search_timespent_starthour || $search_timespent_startmin) {
2088 $durationtouse_start = ($search_timespent_starthour * 3600 + $search_timespent_startmin * 60);
2090 print
'<div class="nowraponall">' . $langs->trans(
'from') .
' ';
2091 print $form->select_duration(
'search_timespent_duration_start', $durationtouse_start, 0,
'text', 0, 1);
2094 $durationtouse_end =
'';
2095 if ($search_timespent_endhour || $search_timespent_endmin) {
2096 $durationtouse_end = ($search_timespent_endhour * 3600 + $search_timespent_endmin * 60);
2098 print
'<div class="nowraponall">' . $langs->trans(
'to') .
' ';
2099 print $form->select_duration(
'search_timespent_duration_end', $durationtouse_end, 0,
'text', 0, 1);
2105 if (!empty($arrayfields[
't.fk_product'][
'checked'])) {
2106 print
'<td class="liste_titre right"></td>';
2109 if (!empty($arrayfields[
'value'][
'checked'])) {
2110 print
'<td class="liste_titre"></td>';
2113 if (!empty($arrayfields[
'valuebilled'][
'checked'])) {
2114 print
'<td class="liste_titre center">' . $form->selectyesno(
'search_valuebilled', $search_valuebilled, 1,
false, 1) .
'</td>';
2118 $extrafieldsobjectkey =
'projet_task';
2119 $extrafieldsobjectprefix =
'ef.';
2120 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
2122 $parameters = array(
'arrayfields' => $arrayfields);
2123 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters, $object, $action);
2124 print $hookmanager->resPrint;
2127 print
'<td class="liste_titre center">';
2128 $searchpicto = $form->showFilterButtons();
2132 print
'</tr>' .
"\n";
2140 print
'<tr class="liste_titre">';
2142 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'', $param,
'', $sortfield, $sortorder,
'center maxwidthsearch ');
2145 if (!empty($arrayfields[
't.element_date'][
'checked'])) {
2146 print_liste_field_titre($arrayfields[
't.element_date'][
'label'], $_SERVER[
'PHP_SELF'],
't.element_date,t.element_datehour,t.rowid',
'', $param,
'', $sortfield, $sortorder);
2149 if (!empty($arrayfields[
'p.fk_soc'][
'checked'])) {
2150 print_liste_field_titre($arrayfields[
'p.fk_soc'][
'label'], $_SERVER[
'PHP_SELF'],
't.element_date,t.element_datehour,t.rowid',
'', $param,
'', $sortfield, $sortorder);
2153 if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2155 print_liste_field_titre($arrayfields[
's.name_alias'][
'label'], $_SERVER[
'PHP_SELF'],
's.name_alias',
'', $param,
'', $sortfield, $sortorder);
2158 if (!empty($allprojectforuser)) {
2159 if (!empty($arrayfields[
'p.project_ref'][
'checked'])) {
2160 print_liste_field_titre($arrayfields[
'p.project_ref'][
'label'], $_SERVER[
'PHP_SELF'],
'p.ref',
'', $param,
'', $sortfield, $sortorder);
2163 if (!empty($arrayfields[
'p.project_label'][
'checked'])) {
2164 print_liste_field_titre($arrayfields[
'p.project_label'][
'label'], $_SERVER[
'PHP_SELF'],
'p.title',
'', $param,
'', $sortfield, $sortorder);
2168 if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) {
2169 if (!empty($arrayfields[
't.element_ref'][
'checked'])) {
2170 print_liste_field_titre($arrayfields[
't.element_ref'][
'label'], $_SERVER[
'PHP_SELF'],
'pt.ref',
'', $param,
'', $sortfield, $sortorder);
2173 if (!empty($arrayfields[
't.element_label'][
'checked'])) {
2174 print_liste_field_titre($arrayfields[
't.element_label'][
'label'], $_SERVER[
'PHP_SELF'],
'pt.label',
'', $param,
'', $sortfield, $sortorder);
2178 if (!empty($arrayfields[
'author'][
'checked'])) {
2179 print_liste_field_titre($arrayfields[
'author'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'', $sortfield, $sortorder);
2182 if (!empty($arrayfields[
't.note'][
'checked'])) {
2183 print_liste_field_titre($arrayfields[
't.note'][
'label'], $_SERVER[
'PHP_SELF'],
't.note',
'', $param,
'', $sortfield, $sortorder);
2186 if (!empty($arrayfields[
't.element_duration'][
'checked'])) {
2187 print_liste_field_titre($arrayfields[
't.element_duration'][
'label'], $_SERVER[
'PHP_SELF'],
't.element_duration',
'', $param,
'', $sortfield, $sortorder,
'right ');
2190 if (!empty($arrayfields[
't.fk_product'][
'checked'])) {
2191 print_liste_field_titre($arrayfields[
't.fk_product'][
'label'], $_SERVER[
'PHP_SELF'],
't.fk_product',
'', $param,
'', $sortfield, $sortorder);
2195 if (!empty($arrayfields[
'value'][
'checked'])) {
2196 print_liste_field_titre($arrayfields[
'value'][
'label'], $_SERVER[
'PHP_SELF'],
'',
'', $param,
'', $sortfield, $sortorder,
'right ');
2199 if (!empty($arrayfields[
'valuebilled'][
'checked'])) {
2200 print_liste_field_titre($arrayfields[
'valuebilled'][
'label'], $_SERVER[
'PHP_SELF'],
'il.total_ht',
'', $param,
'', $sortfield, $sortorder,
'center ', $langs->trans(
"SelectLinesOfTimeSpentToInvoice"));
2204 $extrafieldsobjectkey =
'projet_task';
2205 $extrafieldsobjectprefix =
'ef.';
2206 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
2208 $parameters = array(
'arrayfields' => $arrayfields,
'param' => $param,
'sortfield' => $sortfield,
'sortorder' => $sortorder);
2209 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object, $action);
2210 print $hookmanager->resPrint;
2212 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'', $param,
'', $sortfield, $sortorder,
'center maxwidthsearch ');
2217 $tasktmp =
new Task($db);
2218 $tmpinvoice =
new Facture($db);
2221 $param .=
'&page='.((int) $page);
2223 $param .=
'&sortfield='.urlencode($sortfield).
'&sortorder='.urlencode($sortorder);
2231 foreach ($tasks as $task_time) {
2237 $invoiced = $task_time->invoice_id ? true :
false;
2239 $date1 = $db->jdate($task_time->element_date);
2240 $date2 = $db->jdate($task_time->element_datehour);
2244 print
'<tr data-rowid="'.$task_time->rowid.
'" class="oddeven">';
2248 print
'<td class="center nowraponall">';
2249 if (($action ==
'editline' || $action ==
'splitline') &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2250 print
'<input type="hidden" name="lineid" value="' .
GETPOSTINT(
'lineid') .
'">';
2252 print
'<input type="hidden" name="id" value="' .
$id .
'">';
2254 print
'<input type="submit" class="button buttongen reposition smallpaddingimp margintoponlyshort marginbottomonlyshort button-save" name="save" value="'.$langs->trans(
"Save").
'">';
2256 print
'<input type="submit" class="button buttongen reposition smallpaddingimp margintoponlyshort marginbottomonlyshort button-cancel" name="cancel" value="'.$langs->trans(
"Cancel").
'">';
2257 } elseif ($user->hasRight(
'projet',
'time') || $user->hasRight(
'projet',
'all',
'creer')) {
2258 if (in_array($task_time->fk_user, $childids) || $user->hasRight(
'projet',
'all',
'creer')) {
2259 print
'<a class="reposition editfielda" href="'.$_SERVER[
"PHP_SELF"].
'?'.($withproject ?
'id='.$task_time->fk_element :
'').
'&action=editline&token='.
newToken().
'&lineid='.$task_time->rowid.$param.((empty($id) || $tab ==
'timespent') ?
'&tab=timespent' :
'').
'">';
2260 print
img_edit(
'default', 0,
'class="pictofixedwidth paddingleft"');
2264 print
'<a class="reposition editfielda paddingleft" href="' . $_SERVER[
"PHP_SELF"] .
'?action=splitline&token=' .
newToken() .
'&lineid=' . $task_time->rowid . $param . ((empty($id) || $tab ==
'timespent') ?
'&tab=timespent' :
'') .
'">';
2265 print
img_split(
'',
'class="pictofixedwidth paddingleft"');
2269 print
'<a class="reposition paddingleft" href="'.$_SERVER[
"PHP_SELF"].
'?'.($withproject ?
'id='.$task_time->fk_element :
'').
'&action=deleteline&token='.
newToken().
'&lineid='.$task_time->rowid.$param.((empty($id) || $tab ==
'timespent') ?
'&tab=timespent' :
'').
'">';
2270 print
img_delete(
'default',
'class="pictodelete paddingleft"');
2273 if ($massactionbutton || $massaction) {
2275 if (in_array($task_time->rowid, $arrayofselected)) {
2281 $disabled = (intval($task_time->billable) != 1 || $invoiced);
2282 $ctrl =
'<input '.($disabled ?
'disabled' :
'').
' id="cb' . $task_time->rowid .
'" class="flat checkforselect marginleftonly" type="checkbox" name="toselect[]" value="' . $task_time->rowid .
'"' . ($selected ?
' checked="checked"' :
'') .
'>';
2286 print
'<span id="cbsp'. $task_time->rowid .
'">'.$ctrl.
'</span>';
2287 print
'<script>$("#cbsp' . $task_time->rowid .
'").dblclick(()=>{ $("#cb' . $task_time->rowid .
'").removeAttr("disabled") })</script>';
2301 if (!empty($arrayfields[
't.element_date'][
'checked'])) {
2302 print
'<td class="nowrap">';
2303 if ($action ==
'editline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2304 if (empty($task_time->element_date_withhour)) {
2305 print $form->selectDate(($date2 ? $date2 : $date1),
'timeline', 4, 3, 2,
"timespent_date", 1, 0);
2307 print $form->selectDate(($date2 ? $date2 : $date1),
'timeline', 2, 1, 2,
"timespent_date", 1, 0);
2310 print
dol_print_date(($date2 ? $date2 : $date1), ($task_time->element_date_withhour ?
'dayhour' :
'day'));
2319 if (!empty($arrayfields[
'p.fk_soc'][
'checked'])) {
2320 print
'<td class="tdoverflowmax125">';
2321 if ($task_time->fk_soc > 0) {
2322 if (empty($conf->cache[
'thirdparty'][$task_time->fk_soc])) {
2323 $tmpsociete =
new Societe($db);
2324 $tmpsociete->fetch($task_time->fk_soc);
2325 $conf->cache[
'thirdparty'][$task_time->fk_soc] = $tmpsociete;
2327 $tmpsociete = $conf->cache[
'thirdparty'][$task_time->fk_soc];
2329 print $tmpsociete->getNomUrl(1,
'', 100, 0, 1, empty($arrayfields[
's.name_alias'][
'checked']) ? 0 : 1);
2338 if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2340 if ($task_time->fk_soc > 0) {
2341 if (empty($conf->cache[
'thirdparty'][$task_time->fk_soc])) {
2342 $tmpsociete =
new Societe($db);
2343 $tmpsociete->fetch($task_time->fk_soc);
2344 $conf->cache[
'thirdparty'][$task_time->fk_soc] = $tmpsociete;
2346 $tmpsociete = $conf->cache[
'thirdparty'][$task_time->fk_soc];
2348 $valtoshow = $tmpsociete->name_alias;
2350 print
'<td class="nowrap tdoverflowmax150" title="'.dol_escape_htmltag($valtoshow).
'">';
2358 if (!empty($allprojectforuser)) {
2360 if (!empty($arrayfields[
'p.project_ref'][
'checked'])) {
2361 if (empty($conf->cache[
'project'][$task_time->fk_projet])) {
2362 $tmpproject =
new Project($db);
2363 $tmpproject->fetch($task_time->fk_projet);
2364 $conf->cache[
'project'][$task_time->fk_projet] = $tmpproject;
2366 $tmpproject = $conf->cache[
'project'][$task_time->fk_projet];
2368 print
'<td class="nowraponall">';
2369 print $tmpproject->getNomUrl(1);
2376 if (!empty($arrayfields[
'p.project_label'][
'checked'])) {
2377 if (empty($conf->cache[
'project'][$task_time->fk_projet])) {
2378 $tmpproject =
new Project($db);
2379 $tmpproject->fetch($task_time->fk_projet);
2380 $conf->cache[
'project'][$task_time->fk_projet] = $tmpproject;
2382 $tmpproject = $conf->cache[
'project'][$task_time->fk_projet];
2384 print
'<td class="tdoverflowmax250" title="'.dolPrintHTMLForAttribute($tmpproject->title).
'">';
2385 if (!empty($arrayfields[
'p.project_ref'][
'checked'])) {
2388 print $tmpproject->getNomUrl(1,
'', -1);
2398 if (!empty($arrayfields[
't.element_ref'][
'checked'])) {
2399 if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) {
2400 print
'<td class="nowrap">';
2401 if ($action ==
'editline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2402 $formproject->selectTasks(-1,
GETPOSTINT(
'taskid') ?
GETPOSTINT(
'taskid') : $task_time->fk_element,
'taskid', 0, 0,
'1', 1, 0, 0,
'maxwidth250', (string) $projectstatic->id,
'');
2404 $tasktmp->id = $task_time->fk_element;
2405 $tasktmp->ref = $task_time->ref;
2406 $tasktmp->label = $task_time->label;
2407 print $tasktmp->getNomUrl(1,
'withproject',
'time');
2414 } elseif ($action !==
'createtime') {
2415 print
'<input type="hidden" name="taskid" value="' .
$id .
'">';
2419 if (!empty($arrayfields[
't.element_label'][
'checked'])) {
2420 if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) {
2421 print
'<td class="tdoverflowmax250" title="'.dolPrintHTMLForAttribute($task_time->label).
'">';
2422 if (!empty($arrayfields[
't.element_ref'][
'checked'])) {
2425 $tasktmp->id = $task_time->fk_element;
2426 $tasktmp->ref = $task_time->ref;
2427 $tasktmp->label = $task_time->label;
2428 print $tasktmp->getNomUrl(1,
'withproject',
'time', -1);
2438 if (!empty($arrayfields[
'author'][
'checked'])) {
2439 print
'<td class="tdoverflowmax125">';
2440 if ($action ==
'editline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2443 $object->fetch($task_time->fk_element);
2445 $contactsoftask =
$object->getListContactId(
'internal');
2446 if (!in_array($task_time->fk_user, $contactsoftask)) {
2447 $contactsoftask[] = $task_time->fk_user;
2449 if (count($contactsoftask) > 0) {
2450 print
img_object(
'',
'user',
'class="pictofixedwidth hideonsmartphone"');
2451 print $form->select_dolusers($task_time->fk_user,
'userid_line', 0,
null, 0,
'', $contactsoftask,
'0', 0, 0,
'', 0,
'',
'minwidth100 maxwidth100');
2453 print
img_error($langs->trans(
'FirstAddRessourceToAllocateTime')) . $langs->trans(
'FirstAddRessourceToAllocateTime');
2456 $userstatic->id = $task_time->fk_user;
2457 $userstatic->lastname = $task_time->lastname;
2458 $userstatic->firstname = $task_time->firstname;
2459 $userstatic->photo = $task_time->photo;
2460 $userstatic->gender = $task_time->gender;
2461 $userstatic->status = $task_time->user_status;
2463 print $userstatic->getNomUrl(-1);
2472 if (!empty($arrayfields[
't.note'][
'checked'])) {
2473 if ($action ==
'editline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2474 print
'<td class="small">';
2475 print
'<textarea name="timespent_note_line" class="centpercentimp" rows="' . ROWS_2 .
'">' .
dol_escape_htmltag($task_time->note, 0, 1) .
'</textarea>';
2478 print
'<td class="small tdoverflowmax150 classfortooltip" title="'.dol_string_onlythesehtmltags(
dol_htmlentitiesbr($task_time->note)).
'">';
2485 } elseif ($action ==
'editline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2486 print
'<input type="hidden" name="timespent_note_line" value="' .
dol_escape_htmltag($task_time->note, 0, 1) .
'">';
2490 if (!empty($arrayfields[
't.element_duration'][
'checked'])) {
2491 print
'<td class="right nowraponall">';
2492 if ($action ==
'editline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2493 print
'<input type="hidden" name="old_duration" value="'.$task_time->element_duration.
'">';
2494 print $form->select_duration(
'new_duration', $task_time->element_duration, 0,
'text');
2505 if (empty(
$totalarray[
'val'][
't.element_duration'])) {
2506 $totalarray[
'val'][
't.element_duration'] = $task_time->element_duration;
2508 $totalarray[
'val'][
't.element_duration'] += $task_time->element_duration;
2514 $totalarray[
'totalduration'] = $task_time->element_duration;
2516 $totalarray[
'totalduration'] += $task_time->element_duration;
2521 if (!empty($arrayfields[
't.fk_product'][
'checked'])) {
2522 print
'<td class="nowraponall">';
2523 if ($action ==
'editline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2525 print $form->select_produits($task_time->fk_product,
'fk_product', 1, 0, $projectstatic->thirdparty->price_level, 1, 2,
'', 1, array(), $projectstatic->thirdparty->id,
'None', 0,
'maxwidth500', ($user->hasRight(
'produit',
'lire') ? 0 : 1),
'', null, 1);
2526 } elseif (!empty($task_time->fk_product)) {
2528 $resultFetch = $product->fetch($task_time->fk_product);
2529 if ($resultFetch < 0) {
2532 print $product->getNomUrl(1);
2542 if (!empty($arrayfields[
'value'][
'checked'])) {
2543 $langs->load(
"salaries");
2544 $value =
price2num($task_time->thm * $task_time->element_duration / 3600,
'MT', 1);
2546 print
'<td class="nowraponall right">';
2547 print
'<span class="amount" title="' . $langs->trans(
"THM") .
': ' .
price($task_time->thm) .
'">';
2548 print
price($value, 1, $langs, 1, -1, -1, $conf->currency);
2573 if (!empty($arrayfields[
'valuebilled'][
'checked'])) {
2574 print
'<td class="center">';
2576 if ($projectstatic->usage_bill_time) {
2577 if ($task_time->invoice_id) {
2578 $result = $tmpinvoice->fetch($task_time->invoice_id);
2580 if ($user->hasRight(
'facture',
'lire')) {
2581 if ($action ==
'editline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2582 print $formproject->selectInvoiceAndLine($task_time->invoice_id, $task_time->invoice_line_id,
'invoiceid',
'invoicelineid',
'maxwidth500', array(
'p.rowid' => $projectstatic->id));
2584 print $tmpinvoice->getNomUrl(1);
2585 if (!empty($task_time->invoice_line_id)) {
2587 $invoiceLine->fetch($task_time->invoice_line_id);
2588 if (!empty($invoiceLine->id)) {
2589 print
'<br><span class="small opacitymedium">'.$langs->trans(
'Qty').
':'.$invoiceLine->qty;
2590 print
' '.$langs->trans(
'TotalHT').
':'.
price($invoiceLine->total_ht);
2596 print $langs->trans(
"Yes");
2601 if (intval($task_time->billable) == 1) {
2602 print $langs->trans(
"No");
2604 print $langs->trans(
"Disabled");
2608 print
'<span class="opacitymedium">' . $langs->trans(
"NA") .
'</span>';
2619 $extrafieldsobjectkey =
'projet_task';
2620 $extrafieldsobjectprefix =
'ef.';
2621 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
2624 $parameters = array(
'arrayfields' => $arrayfields,
'obj' => $task_time,
'i' => $i,
'totalarray' => &
$totalarray);
2625 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $object, $action);
2626 print $hookmanager->resPrint;
2630 print
'<td class="center nowraponall">';
2631 if (($action ==
'editline' || $action ==
'splitline') &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2632 print
'<input type="hidden" name="lineid" value="'.GETPOSTINT(
'lineid').
'">';
2633 print
'<input type="submit" class="button buttongen smallpaddingimp margintoponlyshort marginbottomonlyshort button-save" name="save" value="'.$langs->trans(
"Save").
'">';
2635 print
'<input type="submit" class="button buttongen smallpaddingimp margintoponlyshort marginbottomonlyshort button-cancel" name="cancel" value="'.$langs->trans(
"Cancel").
'">';
2636 } elseif ($user->hasRight(
'projet',
'time') || $user->hasRight(
'projet',
'all',
'creer')) {
2637 if (in_array($task_time->fk_user, $childids) || $user->hasRight(
'projet',
'all',
'creer')) {
2638 print
'<a class="reposition editfielda" href="'.$_SERVER[
"PHP_SELF"].
'?'.($withproject ?
'id='.$task_time->fk_element :
'').
'&action=editline&token='.
newToken().
'&lineid='.$task_time->rowid.$param.((empty($id) || $tab ==
'timespent') ?
'&tab=timespent' :
'').
'">';
2639 print
img_edit(
'default', 0,
'class="pictofixedwidth paddingleft"');
2643 print
'<a class="reposition editfielda paddingleft" href="' . $_SERVER[
"PHP_SELF"] .
'?action=splitline&token=' .
newToken() .
'&lineid=' . $task_time->rowid . $param . ((empty($id) || $tab ==
'timespent') ?
'&tab=timespent' :
'') .
'">';
2644 print
img_split(
'',
'class="pictofixedwidth paddingleft"');
2648 print
'<a class="reposition paddingleft" href="'.$_SERVER[
"PHP_SELF"].
'?'.($withproject ?
'id='.$task_time->fk_element :
'').
'&action=deleteline&token='.
newToken().
'&lineid='.$task_time->rowid.$param.((empty($id) || $tab ==
'timespent') ?
'&tab=timespent' :
'').
'">';
2649 print
img_delete(
'default',
'class="pictodelete paddingleft"');
2652 if ($massactionbutton || $massaction) {
2654 if (in_array($task_time->rowid, $arrayofselected)) {
2660 $disabled = (intval($task_time->billable) != 1 || $invoiced);
2661 $ctrl =
'<input '.($disabled ?
'disabled' :
'').
' id="cb' . $task_time->rowid .
'" class="flat checkforselect marginleftonly" type="checkbox" name="toselect[]" value="' . $task_time->rowid .
'"' . ($selected ?
' checked="checked"' :
'') .
'>';
2665 print
'<span id="cbsp'. $task_time->rowid .
'">'.$ctrl.
'</span>';
2666 print
'<script>$("#cbsp' . $task_time->rowid .
'").dblclick(()=>{ $("#cb' . $task_time->rowid .
'").removeAttr("disabled") })</script>';
2684 if ($action ==
'splitline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2685 print
'<!-- first line -->';
2686 print
'<tr class="oddeven">';
2694 if (!empty($arrayfields[
't.element_date'][
'checked'])) {
2695 print
'<td class="nowrap">';
2696 if ($action ==
'splitline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2697 if (empty($task_time->element_date_withhour)) {
2698 print $form->selectDate(($date2 ? $date2 : $date1),
'timeline', 3, 3, 2,
"timespent_date", 1, 0);
2700 print $form->selectDate(($date2 ? $date2 : $date1),
'timeline', 1, 1, 2,
"timespent_date", 1, 0);
2703 print
dol_print_date(($date2 ? $date2 : $date1), ($task_time->element_date_withhour ?
'dayhour' :
'day'));
2709 if (!empty($arrayfields[
'p.fk_soc'][
'checked'])) {
2710 print
'<td class="nowrap">';
2715 if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2716 print
'<td class="nowrap">';
2721 if (!empty($allprojectforuser)) {
2722 if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) {
2723 print
'<td class="nowrap">';
2729 if (!empty($arrayfields[
't.element_ref'][
'checked'])) {
2730 if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) {
2731 print
'<td class="nowrap">';
2732 $tasktmp->id = $task_time->fk_element;
2733 $tasktmp->ref = $task_time->ref;
2734 $tasktmp->label = $task_time->label;
2735 print $tasktmp->getNomUrl(1,
'withproject',
'time');
2741 if (!empty($arrayfields[
't.element_label'][
'checked'])) {
2742 if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) {
2743 print
'<td class="tdoverflowmax300" title="'.dol_escape_htmltag($task_time->label).
'">';
2750 if (!empty($arrayfields[
'author'][
'checked'])) {
2751 print
'<td class="nowraponall">';
2752 if ($action ==
'splitline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2754 $idTask = (!empty($id)) ? $id : $task_time->fk_element;
2757 $contactsoftask =
$object->getListContactId(
'internal');
2758 if (!in_array($task_time->fk_user, $contactsoftask)) {
2759 $contactsoftask[] = $task_time->fk_user;
2761 if (count($contactsoftask) > 0) {
2762 print
img_object(
'',
'user',
'class="hideonsmartphone"');
2763 print $form->select_dolusers($task_time->fk_user,
'userid_line', 0,
null, 0,
'', $contactsoftask);
2765 print
img_error($langs->trans(
'FirstAddRessourceToAllocateTime')) . $langs->trans(
'FirstAddRessourceToAllocateTime');
2768 $userstatic->id = $task_time->fk_user;
2769 $userstatic->lastname = $task_time->lastname;
2770 $userstatic->firstname = $task_time->firstname;
2771 $userstatic->photo = $task_time->photo;
2772 $userstatic->status = $task_time->user_status;
2773 print $userstatic->getNomUrl(-1);
2779 if (!empty($arrayfields[
't.note'][
'checked'])) {
2780 print
'<td class="tdoverflowmax300">';
2781 if ($action ==
'splitline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2782 print
'<textarea name="timespent_note_line" class="centpercentimp" rows="' . ROWS_2 .
'">' .
dol_escape_htmltag($task_time->note, 0, 1) .
'</textarea>';
2787 } elseif ($action ==
'splitline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2788 print
'<input type="hidden" name="timespent_note_line" rows="' . ROWS_2 .
'" value="' .
dol_escape_htmltag($task_time->note, 0, 1) .
'">';
2792 if (!empty($arrayfields[
't.element_duration'][
'checked'])) {
2793 print
'<td class="right">';
2794 if ($action ==
'splitline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2795 print
'<input type="hidden" name="old_duration" value="'.$task_time->element_duration.
'">';
2796 print $form->select_duration(
'new_duration', $task_time->element_duration, 0,
'text');
2804 if (!empty($arrayfields[
't.fk_product'][
'checked'])) {
2805 print
'<td class="nowraponall tdoverflowmax125">';
2810 if (!empty($arrayfields[
'value'][
'checked'])) {
2811 print
'<td class="right">';
2812 print
'<span class="amount">';
2813 $value =
price2num($task_time->thm * $task_time->element_duration / 3600,
'MT', 1);
2814 print
price($value, 1, $langs, 1, -1, -1, $conf->currency);
2820 if (!empty($arrayfields[
'valuebilled'][
'checked'])) {
2821 print
'<td class="right">';
2822 $valuebilled =
price2num($task_time->total_ht,
'', 1);
2823 if (isset($task_time->total_ht)) {
2824 print
price($valuebilled, 1, $langs, 1, -1, -1, $conf->currency);
2831 $extrafieldsobjectkey =
'projet_task';
2832 $extrafieldsobjectprefix =
'ef.';
2833 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
2836 $parameters = array(
'arrayfields' => $arrayfields,
'obj' => $task_time,
'mode' =>
'split1');
2837 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $object, $action);
2838 print $hookmanager->resPrint;
2842 print
'<td class="center nowraponall">';
2851 print
'<!-- second line --><tr class="oddeven">';
2855 print
'<td class="center nowraponall">';
2860 if (!empty($arrayfields[
't.element_date'][
'checked'])) {
2861 print
'<td class="nowraponall">';
2862 if ($action ==
'splitline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2863 if (empty($task_time->element_date_withhour)) {
2864 print $form->selectDate(($date2 ? $date2 : $date1),
'timeline_2', 3, 3, 2,
"timespent_date", 1, 0);
2866 print $form->selectDate(($date2 ? $date2 : $date1),
'timeline_2', 1, 1, 2,
"timespent_date", 1, 0);
2869 print
dol_print_date(($date2 ? $date2 : $date1), ($task_time->element_date_withhour ?
'dayhour' :
'day'));
2875 if (!empty($arrayfields[
'p.fk_soc'][
'checked'])) {
2881 if (!empty($arrayfields[
's.name_alias'][
'checked'])) {
2887 if (!empty($allprojectforuser)) {
2888 if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) {
2895 if (!empty($arrayfields[
't.element_ref'][
'checked'])) {
2896 if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) {
2897 print
'<td class="nowraponall">';
2898 $tasktmp->id = $task_time->fk_element;
2899 $tasktmp->ref = $task_time->ref;
2900 $tasktmp->label = $task_time->label;
2901 print $tasktmp->getNomUrl(1,
'withproject',
'time');
2907 if (!empty($arrayfields[
't.element_label'][
'checked'])) {
2908 if ((empty($id) && empty($ref)) || !empty($projectidforalltimes)) {
2909 print
'<td class="tdoverflowmax125" title="'.dol_escape_htmltag($task_time->label).
'">';
2916 if (!empty($arrayfields[
'author'][
'checked'])) {
2917 print
'<td class="nowraponall tdoverflowmax100">';
2918 if ($action ==
'splitline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2920 $idTask = (!empty($id)) ? $id : $task_time->fk_element;
2923 $contactsoftask =
$object->getListContactId(
'internal');
2924 if (!in_array($task_time->fk_user, $contactsoftask)) {
2925 $contactsoftask[] = $task_time->fk_user;
2927 if (count($contactsoftask) > 0) {
2928 print
img_object(
'',
'user',
'class="hideonsmartphone"');
2929 print $form->select_dolusers($task_time->fk_user,
'userid_line_2', 0,
null, 0,
'', $contactsoftask);
2931 print
img_error($langs->trans(
'FirstAddRessourceToAllocateTime')) . $langs->trans(
'FirstAddRessourceToAllocateTime');
2934 $userstatic->id = $task_time->fk_user;
2935 $userstatic->lastname = $task_time->lastname;
2936 $userstatic->firstname = $task_time->firstname;
2937 $userstatic->photo = $task_time->photo;
2938 $userstatic->status = $task_time->user_status;
2939 print $userstatic->getNomUrl(-1);
2945 if (!empty($arrayfields[
't.note'][
'checked'])) {
2946 print
'<td class="small tdoverflowmax300"">';
2947 if ($action ==
'splitline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2948 print
'<textarea name="timespent_note_line_2" class="centpercentimp" rows="' . ROWS_2 .
'">' .
dol_escape_htmltag($task_time->note, 0, 1) .
'</textarea>';
2953 } elseif ($action ==
'splitline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2954 print
'<input type="hidden" name="timespent_note_line_2" value="' .
dol_escape_htmltag($task_time->note, 0, 1) .
'">';
2958 if (!empty($arrayfields[
't.element_duration'][
'checked'])) {
2959 print
'<td class="right">';
2960 if ($action ==
'splitline' &&
GETPOSTINT(
'lineid') == $task_time->rowid) {
2961 print
'<input type="hidden" name="old_duration_2" value="0">';
2962 print $form->select_duration(
'new_duration_2', 0, 0,
'text');
2970 if (!empty($arrayfields[
't.fk_product'][
'checked'])) {
2971 print
'<td class="nowraponall tdoverflowmax125">';
2976 if (!empty($arrayfields[
'value'][
'checked'])) {
2977 print
'<td class="right">';
2978 print
'<span class="amount nowraponall">';
2980 print
price($value, 1, $langs, 1, -1, -1, $conf->currency);
2987 if (!empty($arrayfields[
'valuebilled'][
'checked'])) {
2988 print
'<td class="right">';
2989 if (isset($task_time->total_ht)) {
2990 $valuebilled =
price2num($task_time->total_ht,
'', 1);
2991 print
'<span class="amount nowraponall small">';
2992 print
price($valuebilled, 1, $langs, 1, -1, -1, $conf->currency);
3000 $extrafieldsobjectkey =
'projet_task';
3001 $extrafieldsobjectprefix =
'ef.';
3002 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
3005 $parameters = array(
'arrayfields' => $arrayfields,
'obj' => $task_time,
'mode' =>
'split2');
3006 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $object, $action);
3007 print $hookmanager->resPrint;
3011 print
'<td class="center nowraponall">';
3024 print
'<tr class="liste_total">';
3029 if ($num < $limit && empty($offset)) {
3030 print
'<td class="left">' . $langs->trans(
"Total") .
'</td>';
3032 print
'<td class="left">'.$form->textwithpicto($langs->trans(
"Total"), $langs->trans(
"Totalforthispage")).
'</td>';
3046 if (!count($tasks)) {
3047 $totalnboffields = 1;
3048 foreach ($arrayfields as $value) {
3049 if (!empty($value[
'checked'])) {
3053 print
'<tr class="oddeven"><td colspan="' . $totalnboffields .
'">';
3054 print
'<span class="opacitymedium">' . $langs->trans(
"None") .
'</span>';
3058 $parameters = array(
'arrayfields' => $arrayfields,
'sql' => $sql);
3059 $reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters, $object, $action);
3060 print $hookmanager->resPrint;
$id
Support class for third parties, contacts, members, users or resources.
if(! $sortfield) if(! $sortorder) $object
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Class to manage invoices.
Class to manage invoice lines.
Class to manage products or services.
Class to manage projects.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
dolSqlDateFilter($datefield, $day_date, $month_date, $year_date, $excludefirstand=0, $gm=false)
Generate a SQL string to make a filter into a range (for second of date until last second of date).
convertSecondToTime($iSecond, $format='all', $lengthOfDay=86400, $lengthOfWeek=7)
Return, in clear text, value of a number of seconds in days, hours and minutes.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
get_default_localtax($thirdparty_seller, $thirdparty_buyer, $local, $idprod=0)
Function that return localtax of a product line (according to seller, buyer and product vat rate) If ...
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
print_liste_field_titre($name, $file="", $field="", $begin="", $param="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $selectlimitsuffix=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
img_delete($titlealt='default', $other='class="pictodelete"', $morecss='')
Show delete logo.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dolGetFirstLineOfText($text, $nboflines=1, $charset='UTF-8')
Return first line of text.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
dolPrintHTML($s, $allowiframe=0)
Return a string (that can be on several lines) ready to be output on a HTML page.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dolGetButtonTitle($label, $helpText='', $iconClass='fa fa-file', $url='', $id='', $status=1, $params=array())
Function dolGetButtonTitle : this kind of buttons are used in title in list.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $allowothertags=array())
Show a picto called object_picto (generic function)
dol_nl2br($stringtoencode, $nl2brmode=0, $forxml=false)
Replace CRLF in string with a HTML BR tag.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
natural_search($fields, $value, $mode=0, $nofirstand=0, $sqltoadd='')
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_sort_array(&$array, $index, $order='asc', $natsort=0, $case_sensitive=0, $keepindex=0)
Advanced sort array by the value of a given key, which produces ascending (default) or descending out...
newToken()
Return the value of token currently saved into session with name 'newtoken'.
dol_concatdesc($text1, $text2, $forxml=false, $invert=false)
Concat 2 descriptions with a new line between them (second operand after first one with appropriate n...
img_split($titlealt='default', $other='class="pictosplit"')
Show split logo.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_clone($srcobject, $native=2)
Create a clone of instance of object (new instance with same value for each properties) With native =...
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
img_error($titlealt='default')
Show error logo.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_htmlentitiesbr($stringtoencode, $nl2brmode=0, $pagecodefrom='UTF-8', $removelasteolbr=1)
This function is called to encode a string into a HTML string but differs from htmlentities because a...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
img_edit($titlealt='default', $float=0, $other='')
Show logo edit/modify fiche.
get_default_tva(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that return vat rate of a product line (according to seller, buyer and product vat rate) VAT...
get_localtax($vatrate, $local, $thirdparty_buyer=null, $thirdparty_seller=null, $vatnpr=0)
Return localtax rate for a particular VAT rate, when selling a product with vat $vatrate,...
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
task_prepare_head($object)
Prepare array with list of tabs.
project_prepare_head(Project $project, $moreparam='')
Prepare array with list of tabs.
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.