dolibarr 20.0.0
perday.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004-2016 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2005-2010 Regis Houssin <regis.houssin@inodbox.com>
5 * Copyright (C) 2010 François Legastelois <flegastelois@teclib.com>
6 * Copyright (C) 2018-2024 Frédéric France <frederic.france@free.fr>
7 * Copyright (C) 2024 MDW <mdeweerd@users.noreply.github.com>
8 *
9 * This program is free software; you can redistribute it and/or modify
10 * it under the terms of the GNU General Public License as published by
11 * the Free Software Foundation; either version 3 of the License, or
12 * (at your option) any later version.
13 *
14 * This program is distributed in the hope that it will be useful,
15 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 * GNU General Public License for more details.
18 *
19 * You should have received a copy of the GNU General Public License
20 * along with this program. If not, see <https://www.gnu.org/licenses/>.
21 */
22
29require "../../main.inc.php";
30require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
31require_once DOL_DOCUMENT_ROOT.'/projet/class/task.class.php';
32require_once DOL_DOCUMENT_ROOT.'/core/lib/project.lib.php';
33require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
34require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
35require_once DOL_DOCUMENT_ROOT.'/core/class/html.formprojet.class.php';
36require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
37require_once DOL_DOCUMENT_ROOT.'/holiday/class/holiday.class.php';
38
39// Load translation files required by the page
40$langs->loadLangs(array('projects', 'users', 'companies'));
41
42$action = GETPOST('action', 'aZ09');
43$mode = GETPOST("mode", 'alpha');
44$id = GETPOSTINT('id');
45$taskid = GETPOSTINT('taskid');
46
47$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'timespent';
48
49$mine = 0;
50if ($mode == 'mine') {
51 $mine = 1;
52}
53
54$projectid = GETPOSTISSET("id") ? GETPOSTINT("id", 1) : GETPOSTINT("projectid");
55
56$hookmanager->initHooks(array('timesheetperdaycard'));
57
58// Security check
59$socid = 0;
60// For external user, no check is done on company because readability is managed by public status of project and assignment.
61//if ($user->socid > 0) $socid=$user->socid;
62$result = restrictedArea($user, 'projet', $projectid);
63
64$now = dol_now();
65
66$year = GETPOSTINT('reyear') ? GETPOSTINT('reyear') : (GETPOSTINT("year") ? GETPOSTINT("year") : (GETPOSTINT("addtimeyear") ? GETPOSTINT("addtimeyear") : date("Y")));
67$month = GETPOSTINT('remonth') ? GETPOSTINT('remonth') : (GETPOSTINT("month") ? GETPOSTINT("month") : (GETPOSTINT("addtimemonth") ? GETPOSTINT("addtimemonth") : date("m")));
68$day = GETPOSTINT('reday') ? GETPOSTINT('reday') : (GETPOSTINT("day") ? GETPOSTINT("day") : (GETPOSTINT("addtimeday") ? GETPOSTINT("addtimeday") : date("d")));
69$week = GETPOSTINT("week") ? GETPOSTINT("week") : date("W");
70
71$day = (int) $day;
72
73//$search_categ = GETPOST("search_categ", 'alpha');
74$search_usertoprocessid = GETPOSTINT('search_usertoprocessid');
75$search_task_ref = GETPOST('search_task_ref', 'alpha');
76$search_task_label = GETPOST('search_task_label', 'alpha');
77$search_project_ref = GETPOST('search_project_ref', 'alpha');
78$search_thirdparty = GETPOST('search_thirdparty', 'alpha');
79$search_declared_progress = GETPOST('search_declared_progress', 'alpha');
80
81$sortfield = GETPOST('sortfield', 'aZ09comma');
82$sortorder = GETPOST('sortorder', 'aZ09comma');
83
84$monthofday = GETPOST('addtimemonth');
85$dayofday = GETPOST('addtimeday');
86$yearofday = GETPOST('addtimeyear');
87
88//var_dump(GETPOST('remonth'));
89//var_dump(GETPOST('button_search_x'));
90//var_dump(GETPOST('button_addtime'));
91
92$daytoparse = $now;
93if ($year && $month && $day) {
94 $daytoparse = dol_mktime(0, 0, 0, $month, $day, $year); // this are value submitted after submit of action 'submitdateselect'
95} elseif ($yearofday && $monthofday && $dayofday) {
96 $daytoparse = dol_mktime(0, 0, 0, $monthofday, $dayofday, $yearofday); // xxxofday is value of day after submit action 'addtime'
97}
98
99$daytoparsegmt = dol_now('gmt');
100if ($yearofday && $monthofday && $dayofday) {
101 $daytoparsegmt = dol_mktime(0, 0, 0, $monthofday, $dayofday, $yearofday, 'gmt');
102} elseif ($year && $month && $day) { // xxxofday is value of day after submit action 'addtime'
103 $daytoparsegmt = dol_mktime(0, 0, 0, $month, $day, $year, 'gmt');
104} // this are value submitted after submit of action 'submitdateselect'
105
106if (empty($search_usertoprocessid) || $search_usertoprocessid == $user->id) {
107 $usertoprocess = $user;
108 $search_usertoprocessid = $usertoprocess->id;
109} elseif ($search_usertoprocessid > 0) {
110 $usertoprocess = new User($db);
111 $usertoprocess->fetch($search_usertoprocessid);
112 $search_usertoprocessid = $usertoprocess->id;
113} else {
114 $usertoprocess = new User($db);
115}
116
117$object = new Task($db);
118$project = new Project($db);
119
120// Extra fields
121$extrafields = new ExtraFields($db);
122
123// fetch optionals attributes and labels
124$extrafields->fetch_name_optionals_label($object->table_element);
125
126// Definition of fields for list
127$arrayfields = array();
128$arrayfields['t.planned_workload'] = array('label' => 'PlannedWorkload', 'checked' => 1, 'enabled' => 1, 'position' => 0);
129$arrayfields['t.progress'] = array('label' => 'ProgressDeclared', 'checked' => 1, 'enabled' => 1, 'position' => 0);
130$arrayfields['timeconsumed'] = array('label' => 'TimeConsumed', 'checked' => 1, 'enabled' => 1, 'position' => 15);
131/*$arrayfields=array(
132 // Project
133 'p.opp_amount'=>array('label'=>$langs->trans("OpportunityAmountShort"), 'checked'=>0, 'enabled'=>($conf->global->PROJECT_USE_OPPORTUNITIES?1:0), 'position'=>103),
134 'p.fk_opp_status'=>array('label'=>$langs->trans("OpportunityStatusShort"), 'checked'=>0, 'enabled'=>($conf->global->PROJECT_USE_OPPORTUNITIES?1:0), 'position'=>104),
135 'p.opp_percent'=>array('label'=>$langs->trans("OpportunityProbabilityShort"), 'checked'=>0, 'enabled'=>($conf->global->PROJECT_USE_OPPORTUNITIES?1:0), 'position'=>105),
136 'p.budget_amount'=>array('label'=>$langs->trans("Budget"), 'checked'=>0, 'position'=>110),
137 'p.usage_bill_time'=>array('label'=>$langs->trans("BillTimeShort"), 'checked'=>0, 'position'=>115),
138 );
139 */
140// Extra fields
141if (!empty($extrafields->attributes[$object->table_element]['label']) && is_array($extrafields->attributes[$object->table_element]['label']) && count($extrafields->attributes[$object->table_element]['label']) > 0) {
142 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
143 if (!empty($extrafields->attributes[$object->table_element]['list'][$key])) {
144 $arrayfields["efpt.".$key] = array('label' => $extrafields->attributes[$object->table_element]['label'][$key], 'checked' => (($extrafields->attributes[$object->table_element]['list'][$key] < 0) ? 0 : 1), 'position' => $extrafields->attributes[$object->table_element]['pos'][$key], 'enabled' => (abs((int) $extrafields->attributes[$object->table_element]['list'][$key]) != 3 && $extrafields->attributes[$object->table_element]['perms'][$key]));
145 }
146 }
147}
148$arrayfields = dol_sort_array($arrayfields, 'position');
149
150
151$search_array_options_project = $extrafields->getOptionalsFromPost($project->table_element, '', 'search_');
152$search_array_options_task = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_task_');
153
154
155/*
156 * Actions
157 */
158
159$parameters = array('id' => $id, 'taskid' => $taskid, 'projectid' => $projectid);
160$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
161if ($reshook < 0) {
162 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
163}
164// Purge criteria
165if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')) { // All tests are required to be compatible with all browsers
166 $action = '';
167 //$search_categ = '';
168 $search_usertoprocessid = $user->id;
169 $search_task_ref = '';
170 $search_task_label = '';
171 $search_project_ref = '';
172 $search_thirdparty = '';
173 $search_declared_progress = '';
174
175 $search_array_options_project = array();
176 $search_array_options_task = array();
177
178 // We redefine $usertoprocess
179 $usertoprocess = $user;
180}
181if (GETPOST("button_search_x", 'alpha') || GETPOST("button_search.x", 'alpha') || GETPOST("button_search", 'alpha')) {
182 $action = '';
183}
184
185if (GETPOST('submitdateselect')) {
186 if (GETPOSTINT('remonth') && GETPOSTINT('reday') && GETPOSTINT('reyear')) {
187 $daytoparse = dol_mktime(0, 0, 0, GETPOSTINT('remonth'), GETPOSTINT('reday'), GETPOSTINT('reyear'));
188 }
189
190 $action = '';
191}
192
193include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
194
195if ($action == 'addtime' && $user->hasRight('projet', 'lire') && GETPOST('assigntask') && GETPOST('formfilteraction') != 'listafterchangingselectedfields') {
196 $action = 'assigntask';
197
198 if ($taskid > 0) {
199 $result = $object->fetch($taskid, $ref);
200 if ($result < 0) {
201 $error++;
202 }
203 } else {
204 setEventMessages($langs->transnoentitiesnoconv("ErrorFieldRequired", $langs->transnoentitiesnoconv("Task")), null, 'errors');
205 $error++;
206 }
207 if (!GETPOST('type')) {
208 setEventMessages($langs->transnoentitiesnoconv("ErrorFieldRequired", $langs->transnoentitiesnoconv("Type")), null, 'errors');
209 $error++;
210 }
211 if (!$error) {
212 $idfortaskuser = $usertoprocess->id;
213 $result = $object->add_contact($idfortaskuser, GETPOST("type"), 'internal');
214
215 if ($result >= 0 || $result == -2) { // Contact add ok or already contact of task
216 // Test if we are already contact of the project (should be rare but sometimes we can add as task contact without being contact of project, like when admin user has been removed from contact of project)
217 $sql = 'SELECT ec.rowid FROM '.MAIN_DB_PREFIX.'element_contact as ec, '.MAIN_DB_PREFIX.'c_type_contact as tc WHERE tc.rowid = ec.fk_c_type_contact';
218 $sql .= ' AND ec.fk_socpeople = '.((int) $idfortaskuser)." AND ec.element_id = ".((int) $object->fk_project)." AND tc.element = 'project' AND source = 'internal'";
219 $resql = $db->query($sql);
220 if ($resql) {
221 $obj = $db->fetch_object($resql);
222 if (!$obj) { // User is not already linked to project, so we will create link to first type
223 $project = new Project($db);
224 $project->fetch($object->fk_project);
225 // Get type
226 $listofprojcontact = $project->liste_type_contact('internal');
227
228 if (count($listofprojcontact)) {
229 $tmparray = array_keys($listofprojcontact);
230 $typeforprojectcontact = reset($tmparray);
231 $result = $project->add_contact($idfortaskuser, $typeforprojectcontact, 'internal');
232 }
233 }
234 } else {
235 dol_print_error($db);
236 }
237 }
238 }
239
240 if ($result < 0) {
241 $error++;
242 if ($object->error == 'DB_ERROR_RECORD_ALREADY_EXISTS') {
243 $langs->load("errors");
244 setEventMessages($langs->trans("ErrorTaskAlreadyAssigned"), null, 'warnings');
245 } else {
246 setEventMessages($object->error, $object->errors, 'errors');
247 }
248 }
249
250 if (!$error) {
251 setEventMessages("TaskAssignedToEnterTime", null);
252 $taskid = 0;
253 }
254
255 $action = '';
256}
257
258if ($action == 'addtime' && $user->hasRight('projet', 'lire') && GETPOST('formfilteraction') != 'listafterchangingselectedfields') {
259 $timespent_duration = array();
260
261 if (is_array($_POST)) {
262 foreach ($_POST as $key => $time) {
263 if (intval($time) > 0) {
264 $matches = array();
265 // Hours or minutes of duration
266 if (preg_match("/([0-9]+)duration(hour|min)/", $key, $matches)) {
267 $id = $matches[1];
268 if ($id > 0) {
269 // We store HOURS in seconds
270 if ($matches[2] == 'hour') {
271 $timespent_duration[$id] += $time * 60 * 60;
272 }
273
274 // We store MINUTES in seconds
275 if ($matches[2] == 'min') {
276 $timespent_duration[$id] += $time * 60;
277 }
278 }
279 }
280 }
281 }
282 }
283
284 if (count($timespent_duration) > 0) {
285 foreach ($timespent_duration as $key => $val) {
286 $object->fetch($key);
287 $taskid = $object->id;
288
289 if (GETPOSTISSET($taskid.'progress')) {
290 $object->progress = GETPOSTINT($taskid.'progress');
291 } else {
292 unset($object->progress);
293 }
294
295 $object->timespent_duration = $val;
296 $object->timespent_fk_user = $usertoprocess->id;
297 $object->timespent_note = GETPOST($key.'note');
298 if (GETPOSTINT($key."hour") != '' && GETPOSTINT($key."hour") >= 0) { // If hour was entered
299 $object->timespent_datehour = dol_mktime(GETPOSTINT($key."hour"), GETPOSTINT($key."min"), 0, $monthofday, $dayofday, $yearofday);
300 $object->timespent_withhour = 1;
301 } else {
302 $object->timespent_datehour = dol_mktime(12, 0, 0, $monthofday, $dayofday, $yearofday);
303 }
304 $object->timespent_date = $object->timespent_datehour;
305
306 if ($object->timespent_date > 0) {
307 $result = $object->addTimeSpent($user);
308 } else {
309 setEventMessages("ErrorBadDate", null, 'errors');
310 $error++;
311 break;
312 }
313
314 if ($result < 0) {
315 setEventMessages($object->error, $object->errors, 'errors');
316 $error++;
317 break;
318 }
319 }
320
321 if (!$error) {
322 setEventMessages($langs->trans("RecordSaved"), null, 'mesgs');
323
324 // Redirect to avoid submit twice on back
325 header('Location: '.$_SERVER["PHP_SELF"].'?'.($projectid ? 'id='.$projectid : '').($search_usertoprocessid ? '&search_usertoprocessid='.urlencode($search_usertoprocessid) : '').($mode ? '&mode='.$mode : '').'&year='.$yearofday.'&month='.$monthofday.'&day='.$dayofday);
326 exit;
327 }
328 } else {
329 setEventMessages($langs->trans("ErrorTimeSpentIsEmpty"), null, 'errors');
330 }
331}
332
333
334
335/*
336 * View
337 */
338
339$form = new Form($db);
340$formother = new FormOther($db);
341$formcompany = new FormCompany($db);
342$formproject = new FormProjets($db);
343$projectstatic = new Project($db);
344$project = new Project($db);
345$taskstatic = new Task($db);
346$thirdpartystatic = new Societe($db);
347$holiday = new Holiday($db);
348
349$prev = dol_getdate($daytoparse - (24 * 3600));
350$prev_year = $prev['year'];
351$prev_month = $prev['mon'];
352$prev_day = $prev['mday'];
353
354$next = dol_getdate($daytoparse + (24 * 3600));
355$next_year = $next['year'];
356$next_month = $next['mon'];
357$next_day = $next['mday'];
358
359$title = $langs->trans("TimeSpent");
360
361$projectsListId = $projectstatic->getProjectsAuthorizedForUser($usertoprocess, (empty($usertoprocess->id) ? 2 : 0), 1); // Return all project i have permission on (assigned to me+public). I want my tasks and some of my task may be on a public projet that is not my project
362
363if ($id) {
364 $project->fetch($id);
365 $project->fetch_thirdparty();
366}
367
368$onlyopenedproject = 1; // or -1
369$morewherefilter = '';
370
371if ($search_project_ref) {
372 $morewherefilter .= natural_search(array("p.ref", "p.title"), $search_project_ref);
373}
374if ($search_task_ref) {
375 $morewherefilter .= natural_search("t.ref", $search_task_ref);
376}
377if ($search_task_label) {
378 $morewherefilter .= natural_search(array("t.ref", "t.label"), $search_task_label);
379}
380if ($search_thirdparty) {
381 $morewherefilter .= natural_search("s.nom", $search_thirdparty);
382}
383if ($search_declared_progress) {
384 $morewherefilter .= natural_search("t.progress", $search_declared_progress, 1);
385}
386
387$sql = &$morewherefilter;
388
389/*$search_array_options = $search_array_options_project;
390$extrafieldsobjectprefix='efp.';
391$search_options_pattern='search_options_';
392$extrafieldsobjectkey='projet';
393include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
394*/
395$search_array_options = $search_array_options_task;
396$extrafieldsobjectprefix = 'efpt.';
397$search_options_pattern = 'search_task_options_';
398$extrafieldsobjectkey = 'projet_task';
399include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
400
401$tasksarray = $taskstatic->getTasksArray(0, 0, ($project->id ? $project->id : 0), $socid, 0, $search_project_ref, $onlyopenedproject, $morewherefilter, ($search_usertoprocessid ? $search_usertoprocessid : 0), 0, $extrafields); // We want to see all task of opened project i am allowed to see and that match filter, not only my tasks. Later only mine will be editable later.
402if ($morewherefilter) { // Get all task without any filter, so we can show total of time spent for not visible tasks
403 $tasksarraywithoutfilter = $taskstatic->getTasksArray(0, 0, ($project->id ? $project->id : 0), $socid, 0, '', $onlyopenedproject, '', ($search_usertoprocessid ? $search_usertoprocessid : 0)); // We want to see all task of opened project i am allowed to see and that match filter, not only my tasks. Later only mine will be editable later.
404}
405$projectsrole = $taskstatic->getUserRolesForProjectsOrTasks($usertoprocess, null, ($project->id ? $project->id : 0), 0, $onlyopenedproject);
406$tasksrole = $taskstatic->getUserRolesForProjectsOrTasks(null, $usertoprocess, ($project->id ? $project->id : 0), 0, $onlyopenedproject);
407//var_dump($usertoprocess);
408//var_dump($projectsrole);
409//var_dump($taskrole);
410
411llxHeader("", $title, "", '', '', '', array('/core/js/timesheet.js'));
412
413//print_barre_liste($title, $page, $_SERVER["PHP_SELF"], "", $sortfield, $sortorder, "", $num, '', 'project');
414
415$param = '';
416$param .= ($mode ? '&mode='.urlencode($mode) : '');
417$param .= ($search_project_ref ? '&search_project_ref='.urlencode($search_project_ref) : '');
418$param .= ($search_usertoprocessid > 0 ? '&search_usertoprocessid='.urlencode($search_usertoprocessid) : '');
419$param .= ($search_thirdparty ? '&search_thirdparty='.urlencode($search_thirdparty) : '');
420$param .= ($search_task_ref ? '&search_task_ref='.urlencode($search_task_ref) : '');
421$param .= ($search_task_label ? '&search_task_label='.urlencode($search_task_label) : '');
422
423/*
424$search_array_options = $search_array_options_project;
425$search_options_pattern='search_options_';
426include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
427*/
428
429$search_array_options = $search_array_options_task;
430$search_options_pattern = 'search_task_options_';
431include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
432
433// Show navigation bar
434$nav = '<a class="inline-block valignmiddle" href="?year='.$prev_year."&month=".$prev_month."&day=".$prev_day.$param.'">'.img_previous($langs->trans("Previous"))."</a>\n";
435$nav .= dol_print_date(dol_mktime(0, 0, 0, $month, $day, $year), "%a").' ';
436$nav .= ' <span id="month_name">'.dol_print_date(dol_mktime(0, 0, 0, $month, $day, $year), "day")." </span>\n";
437$nav .= '<a class="inline-block valignmiddle" href="?year='.$next_year."&month=".$next_month."&day=".$next_day.$param.'">'.img_next($langs->trans("Next"))."</a>\n";
438$nav .= ' '.$form->selectDate(-1, '', 0, 0, 2, "addtime", 1, ($conf->dol_optimize_smallscreen ? 0 : 1)).' ';
439$nav .= ' <button type="submit" name="button_search_x" value="x" class="bordertransp nobordertransp button_search"><span class="fa fa-search"></span></button>';
440
441$picto = 'clock';
442
443print '<form name="addtime" method="POST" action="'.$_SERVER["PHP_SELF"].($project->id > 0 ? '?id='.$project->id : '').'">';
444print '<input type="hidden" name="token" value="'.newToken().'">';
445print '<input type="hidden" name="action" value="addtime">';
446print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
447print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
448print '<input type="hidden" name="mode" value="'.$mode.'">';
449$tmp = dol_getdate($daytoparse);
450print '<input type="hidden" name="addtimeyear" value="'.$tmp['year'].'">';
451print '<input type="hidden" name="addtimemonth" value="'.$tmp['mon'].'">';
452print '<input type="hidden" name="addtimeday" value="'.$tmp['mday'].'">';
453
454$head = project_timesheet_prepare_head($mode, $usertoprocess);
455print dol_get_fiche_head($head, 'inputperday', $langs->trans('TimeSpent'), -1, $picto);
456
457// Show description of content
458print '<div class="hideonsmartphone opacitymedium">';
459if ($mine || ($usertoprocess->id == $user->id)) {
460 print $langs->trans("MyTasksDesc").'.'.($onlyopenedproject ? ' '.$langs->trans("OnlyOpenedProject") : '').'<br>';
461} else {
462 if (empty($usertoprocess->id) || $usertoprocess->id < 0) {
463 if ($user->hasRight('projet', 'all', 'lire') && !$socid) {
464 print $langs->trans("ProjectsDesc").'.'.($onlyopenedproject ? ' '.$langs->trans("OnlyOpenedProject") : '').'<br>';
465 } else {
466 print $langs->trans("ProjectsPublicTaskDesc").'.'.($onlyopenedproject ? ' '.$langs->trans("OnlyOpenedProject") : '').'<br>';
467 }
468 }
469}
470if ($mine || ($usertoprocess->id == $user->id)) {
471 print $langs->trans("OnlyYourTaskAreVisible").'<br>';
472} else {
473 print $langs->trans("AllTaskVisibleButEditIfYouAreAssigned").'<br>';
474}
475print '</div>';
476
477print dol_get_fiche_end();
478
479
480print '<div class="'.($conf->dol_optimize_smallscreen ? 'center centpercent' : 'floatright right').'">'.$nav.'</div>'; // We move this before the assign to components so, the default submit button is not the assign to.
481
482print '<div class="colorbacktimesheet valignmiddle'.($conf->dol_optimize_smallscreen ? ' center' : ' float').'">';
483$titleassigntask = $langs->transnoentities("AssignTaskToMe");
484if ($usertoprocess->id != $user->id) {
485 $titleassigntask = $langs->transnoentities("AssignTaskToUser", $usertoprocess->getFullName($langs));
486}
487print '<div class="taskiddiv inline-block">';
488print img_picto('', 'projecttask', 'class="pictofixedwidth"');
489$formproject->selectTasks($socid ? $socid : -1, $taskid, 'taskid', 32, 0, '-- '.$langs->trans("ChooseANotYetAssignedTask").' --', 1, 0, 0, 'widthcentpercentminusx', '', 'all', $usertoprocess);
490print '</div>';
491print ' ';
492print $formcompany->selectTypeContact($object, '', 'type', 'internal', 'position', 0, 'maxwidth150onsmartphone');
493print '<input type="submit" class="button valignmiddle smallonsmartphone small" name="assigntask" value="'.dol_escape_htmltag($titleassigntask).'">';
494print '</div>';
495
496print '<div class="clearboth" style="padding-bottom: 20px;"></div>';
497
498
499$moreforfilter = '';
500
501// Filter on categories
502/*if (isModEnabled("categorie")) {
503 require_once DOL_DOCUMENT_ROOT . '/categories/class/categorie.class.php';
504 $moreforfilter.='<div class="divsearchfield">';
505 $moreforfilter.=$langs->trans('ProjectCategories'). ': ';
506 $moreforfilter.=$formother->select_categories('project', $search_categ, 'search_categ', 1, 1, 'maxwidth300');
507 $moreforfilter.='</div>';
508}*/
509
510// If the user can view user other than himself
511$includeonly = 'hierarchyme';
512if (!$user->hasRight('user', 'user', 'lire')) {
513 $includeonly = array($user->id);
514}
515$selecteduser = $search_usertoprocessid ? $search_usertoprocessid : $usertoprocess->id;
516$moreforfiltertmp = $form->select_dolusers($selecteduser, 'search_usertoprocessid', 0, null, 0, $includeonly, null, 0, 0, 0, '', 0, '', 'maxwidth200');
517if ($form->num > 1 || empty($conf->dol_optimize_smallscreen)) {
518 $moreforfilter .= '<div class="divsearchfield">';
519 $moreforfilter .= '<div class="inline-block hideonsmartphone"></div>';
520 $moreforfilter .= img_picto($langs->trans('Filter').' '.$langs->trans('User'), 'user', 'class="paddingright pictofixedwidth"');
521 $moreforfilter .= $moreforfiltertmp;
522 $moreforfilter .= '</div>';
523} else {
524 $moreforfilter .= '<input type="hidden" name="search_usertoprocessid" value="'.$selecteduser.'">';
525}
526
527if (!getDolGlobalString('PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT')) {
528 $moreforfilter .= '<div class="divsearchfield">';
529 $moreforfilter .= '<div class="inline-block"></div>';
530 $moreforfilter .= img_picto($langs->trans('Filter').' '.$langs->trans('Project'), 'project', 'class="paddingright pictofixedwidth"').'<input type="text" name="search_project_ref" class="maxwidth100" value="'.dol_escape_htmltag($search_project_ref).'">';
531 $moreforfilter .= '</div>';
532
533 $moreforfilter .= '<div class="divsearchfield">';
534 $moreforfilter .= '<div class="inline-block"></div>';
535 $moreforfilter .= img_picto($langs->trans('Filter').' '.$langs->trans('ThirdParty'), 'company', 'class="paddingright pictofixedwidth"').'<input type="text" name="search_thirdparty" class="maxwidth100" value="'.dol_escape_htmltag($search_thirdparty).'">';
536 $moreforfilter .= '</div>';
537}
538
539if (!empty($moreforfilter)) {
540 print '<div class="liste_titre liste_titre_bydiv centpercent">';
541 print $moreforfilter;
542 $parameters = array();
543 $reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters); // Note that $action and $object may have been modified by hook
544 print $hookmanager->resPrint;
545 print '</div>';
546}
547
548$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
549$selectedfields = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage); // This also change content of $arrayfields
550
551// This must be after the $selectedfields
552$addcolspan = 0;
553if (!empty($arrayfields['t.planned_workload']['checked'])) {
554 $addcolspan++;
555}
556if (!empty($arrayfields['t.progress']['checked'])) {
557 $addcolspan++;
558}
559foreach ($arrayfields as $key => $val) {
560 if ($val['checked'] && substr($key, 0, 5) == 'efpt.') {
561 $addcolspan++;
562 }
563}
564
565print '<div class="div-table-responsive">';
566print '<table class="tagtable liste'.($moreforfilter ? " listwithfilterbefore" : "").'" id="tablelines3">'."\n";
567
568print '<tr class="liste_titre_filter">';
569if (getDolGlobalString('PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT')) {
570 print '<td class="liste_titre"><input type="text" size="4" name="search_project_ref" value="'.dol_escape_htmltag($search_project_ref).'"></td>';
571}
572if (getDolGlobalString('PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT')) {
573 print '<td class="liste_titre"><input type="text" size="4" name="search_thirdparty" value="'.dol_escape_htmltag($search_thirdparty).'"></td>';
574}
575print '<td class="liste_titre"><input type="text" size="4" name="search_task_label" value="'.dol_escape_htmltag($search_task_label).'"></td>';
576// TASK fields
577$search_options_pattern = 'search_task_options_';
578$extrafieldsobjectkey = 'projet_task';
579$extrafieldsobjectprefix = 'efpt.';
580include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
581if (!empty($arrayfields['t.planned_workload']['checked'])) {
582 print '<td class="liste_titre"></td>';
583}
584if (!empty($arrayfields['t.progress']['checked'])) {
585 print '<td class="liste_titre right"><input type="text" size="4" name="search_declared_progress" value="'.dol_escape_htmltag($search_declared_progress).'"></td>';
586}
587if (!empty($arrayfields['timeconsumed']['checked'])) {
588 print '<td class="liste_titre"></td>';
589 print '<td class="liste_titre"></td>';
590}
591print '<td class="liste_titre"></td>';
592print '<td class="liste_titre"></td>';
593print '<td class="liste_titre"></td>';
594// Action column
595print '<td class="liste_titre nowrap right">';
596$searchpicto = $form->showFilterAndCheckAddButtons(0);
597print $searchpicto;
598print '</td>';
599print "</tr>\n";
600
601print '<tr class="liste_titre">';
602if (getDolGlobalString('PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT')) {
603 print '<th>'.$langs->trans("Project").'</th>';
604}
605if (getDolGlobalString('PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT')) {
606 print '<th>'.$langs->trans("ThirdParty").'</th>';
607}
608print '<th>'.$langs->trans("Task").'</th>';
609// TASK fields
610$extrafieldsobjectkey = 'projet_task';
611$extrafieldsobjectprefix = 'efpt.';
612include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
613if (!empty($arrayfields['t.planned_workload']['checked'])) {
614 print '<th class="leftborder plannedworkload minwidth75 maxwidth100 right" title="'.dol_escape_htmltag($langs->trans("PlannedWorkload")).'">'.$form->textwithpicto($langs->trans("PlannedWorkloadShort"), $langs->trans("PlannedWorkload")).'</th>';
615}
616if (!empty($arrayfields['t.progress']['checked'])) {
617 print '<th class="right minwidth75 maxwidth100 title="'.dol_escape_htmltag($langs->trans("ProgressDeclared")).'">'.$langs->trans("ProgressDeclared").'</th>';
618}
619if (!empty($arrayfields['timeconsumed']['checked'])) {
620 print '<th class="right maxwidth100">'.$langs->trans("TimeSpentSmall").'<br>';
621 print '<span class="nowraponall">';
622 print '<span class="opacitymedium nopadding userimg"><img alt="Photo" class="photouserphoto userphoto" src="'.DOL_URL_ROOT.'/theme/common/everybody.png"></span>';
623 print '<span class="opacitymedium paddingleft">'.$langs->trans("EverybodySmall").'</span>';
624 print '</span>';
625 print '</th>';
626 print '<th class="right maxwidth75 maxwidth100">'.$langs->trans("TimeSpentSmall").($usertoprocess->firstname ? '<br><span class="nowraponall">'.$usertoprocess->getNomUrl(-2).'<span class="opacitymedium paddingleft">'.dol_trunc($usertoprocess->firstname, 10).'</span></span>' : '').'</th>';
627}
628print '<th class="center leftborder">'.$langs->trans("HourStart").'</td>';
629
630// By default, we can edit only tasks we are assigned to
631$restrictviewformytask = getDolGlobalInt('PROJECT_TIME_SHOW_TASK_NOT_ASSIGNED', 2);
632
633$numendworkingday = 0;
634$numstartworkingday = 0;
635// Get if user is available or not for each day
636$isavailable = array();
637
638// Assume from Monday to Friday if conf empty or badly formed
639$numstartworkingday = 1;
640$numendworkingday = 5;
641
642if (getDolGlobalString('MAIN_DEFAULT_WORKING_DAYS')) {
643 $tmparray = explode('-', getDolGlobalString('MAIN_DEFAULT_WORKING_DAYS'));
644 if (count($tmparray) >= 2) {
645 $numstartworkingday = $tmparray[0];
646 $numendworkingday = $tmparray[1];
647 }
648}
649
650$statusofholidaytocheck = Holiday::STATUS_APPROVED;
651$isavailablefordayanduser = $holiday->verifDateHolidayForTimestamp($usertoprocess->id, $daytoparse, $statusofholidaytocheck); // $daytoparse is a date with hours = 0
652$isavailable[$daytoparse] = $isavailablefordayanduser; // in projectLinesPerWeek later, we are using $firstdaytoshow and dol_time_plus_duree to loop on each day
653
654$test = num_public_holiday($daytoparsegmt, $daytoparsegmt + 86400, $mysoc->country_code);
655if ($test) {
656 $isavailable[$daytoparse] = array('morning' => false, 'afternoon' => false, 'morning_reason' => 'public_holiday', 'afternoon_reason' => 'public_holiday');
657}
658
659$tmparray = dol_getdate($daytoparse, true); // detail of current day
660// For monday, must be 0 for monday if MAIN_START_WEEK = 1, must be 1 for monday if MAIN_START_WEEK = 0
661$idw = ($tmparray['wday'] - (!getDolGlobalString('MAIN_START_WEEK') ? 0 : 1));
662// numstartworkingday and numendworkingday are default start and end date of working days (1 means sunday if MAIN_START_WEEK is 0, 1 means monday if MAIN_START_WEEK is 1)
663$cssweekend = '';
664if ((($idw + 1) < $numstartworkingday) || (($idw + 1) > $numendworkingday)) { // This is a day is not inside the setup of working days, so we use a week-end css.
665 $cssweekend = 'weekend';
666}
667
668$tmpday = dol_time_plus_duree($daytoparse, $idw, 'd');
669
670$cssonholiday = '';
671if (!$isavailable[$daytoparse]['morning'] && !$isavailable[$daytoparse]['afternoon']) {
672 $cssonholiday .= 'onholidayallday ';
673} elseif (!$isavailable[$daytoparse]['morning']) {
674 $cssonholiday .= 'onholidaymorning ';
675} elseif (!$isavailable[$daytoparse]['afternoon']) {
676 $cssonholiday .= 'onholidayafternoon ';
677}
678
679print '<th class="center'.($cssonholiday ? ' '.$cssonholiday : '').($cssweekend ? ' '.$cssweekend : '').'">'.$langs->trans("Duration").'</th>';
680print '<th class="center">'.$langs->trans("Note").'</th>';
681//print '<td class="center"></td>';
682print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ');
683
684print "</tr>\n";
685
686$colspan = 2 + (!getDolGlobalString('PROJECT_TIMESHEET_DISABLEBREAK_ON_PROJECT') ? 0 : 2);
687
688if ($conf->use_javascript_ajax && count($tasksarray) >= getDolGlobalInt('NBLINES_TO_DUPLICATE_TOTAL_TIMESPENT_ON_TOP', 10)) {
689 print '<tr class="liste_total hideonsmartphone">';
690 print '<td class="liste_total" colspan="'.($colspan - 1 + $addcolspan).'">';
691 print $langs->trans("Total");
692 print '</td>';
693 if (!empty($arrayfields['timeconsumed']['checked'])) {
694 print '<td class="liste_total"></td>';
695 print '<td class="liste_total"></td>';
696 }
697 print '<td class="liste_total leftborder">';
698 //print ' - '.$langs->trans("ExpectedWorkedHours").': <strong>'.price($usertoprocess->weeklyhours, 1, $langs, 0, 0).'</strong>';
699 print '</td>';
700
701 print '<td class="liste_total center'.($cssonholiday ? ' '.$cssonholiday : '').($cssweekend ? ' '.$cssweekend : '').'"><div class="totalDay0">&nbsp;</div></td>';
702
703 print '<td class="liste_total"></td>';
704 print '<td class="liste_total"></td>';
705 print '</tr>';
706}
707
708
709if (count($tasksarray) > 0) {
710 //var_dump($tasksarray); // contains only selected tasks
711 //var_dump($tasksarraywithoutfilter); // contains all tasks (if there is a filter, not defined if no filter)
712 //var_dump($tasksrole);
713
714 $j = 0;
715 $level = 0;
716 $totalforvisibletasks = projectLinesPerDay($j, 0, $usertoprocess, $tasksarray, $level, $projectsrole, $tasksrole, $mine, $restrictviewformytask, $daytoparse, $isavailable, 0, $arrayfields, $extrafields);
717 //var_dump($totalforvisibletasks);
718
719 // Show total for all other tasks
720
721 // Calculate total for all tasks
722 $listofdistinctprojectid = array(); // List of all distinct projects
723 if (!empty($tasksarraywithoutfilter) && is_array($tasksarraywithoutfilter) && count($tasksarraywithoutfilter)) {
724 foreach ($tasksarraywithoutfilter as $tmptask) {
725 $listofdistinctprojectid[$tmptask->fk_project] = $tmptask->fk_project;
726 }
727 }
728 //var_dump($listofdistinctprojectid);
729 $totalforeachday = array();
730 foreach ($listofdistinctprojectid as $tmpprojectid) {
731 $projectstatic->id = $tmpprojectid;
732 $projectstatic->loadTimeSpent($daytoparse, 0, $usertoprocess->id); // Load time spent from table element_time for the project into this->weekWorkLoad and this->weekWorkLoadPerTask for all days of a week
733 for ($idw = 0; $idw < 7; $idw++) {
734 $tmpday = dol_time_plus_duree($daytoparse, $idw, 'd');
735 $totalforeachday[$tmpday] += $projectstatic->weekWorkLoad[$tmpday];
736 }
737 }
738 //var_dump($totalforeachday);
739
740 // Is there a diff between selected/filtered tasks and all tasks ?
741 $isdiff = 0;
742 if (count($totalforeachday)) {
743 $timeonothertasks = ($totalforeachday[$daytoparse] - $totalforvisibletasks[$daytoparse]);
744 if ($timeonothertasks) {
745 $isdiff = 1;
746 }
747 }
748
749 // There is a diff between total shown on screen and total spent by user, so we add a line with all other cumulated time of user
750 if ($isdiff) {
751 print '<tr class="oddeven othertaskwithtime">';
752 print '<td colspan="'.($colspan - 1).'" class="opacitymedium">';
753 print $langs->trans("OtherFilteredTasks");
754 print '</td>';
755 if (!empty($arrayfields['timeconsumed']['checked'])) {
756 print '<td class="liste_total"></td>';
757 print '<td class="liste_total"></td>';
758 }
759 print '<td class="leftborder"></td>';
760 print '<td class="right">';
761 $timeonothertasks = ($totalforeachday[$daytoparse] - $totalforvisibletasks[$daytoparse]);
762 //if ($timeonothertasks)
763 //{
764 print '<span class="timesheetalreadyrecorded" title="texttoreplace"><input type="text" class="center width40" disabled="" id="timespent[-1][0]" name="task[-1][0]" value="';
765 if ($timeonothertasks) {
766 print convertSecondToTime($timeonothertasks, 'allhourmin');
767 }
768 print '"></span>';
769 //}
770 print '</td>';
771 print ' <td class="liste_total borderleft"></td>';
772 print ' <td class="liste_total"></td>';
773 print '</tr>';
774 }
775
776 if ($conf->use_javascript_ajax) {
777 print '<tr class="liste_total">';
778 print '<td class="liste_total" colspan="'.($colspan - 1 + $addcolspan).'">';
779 print $langs->trans("Total");
780 print '</td>';
781 if (!empty($arrayfields['timeconsumed']['checked'])) {
782 print '<td class="liste_total"></td>';
783 print '<td class="liste_total"></td>';
784 }
785 print '<td class="liste_total leftborder borderleft">';
786 //print ' - '.$langs->trans("ExpectedWorkedHours").': <strong>'.price($usertoprocess->weeklyhours, 1, $langs, 0, 0).'</strong>';
787 print '</td>';
788
789 print '<td class="liste_total center'.($cssonholiday ? ' '.$cssonholiday : '').($cssweekend ? ' '.$cssweekend : '').'"><div class="totalDay0">&nbsp;</div></td>';
790
791 print '<td class="liste_total"></td>
792 <td class="liste_total"></td>
793 </tr>';
794 }
795} else {
796 print '<tr><td colspan="14"><span class="opacitymedium">'.$langs->trans("NoAssignedTasks").'</span></td></tr>';
797}
798print "</table>";
799print '</div>';
800
801print '<input type="hidden" id="numberOfLines" name="numberOfLines" value="'.count($tasksarray).'"/>'."\n";
802
803print '<div class="center">';
804print '<input type="submit" name="button_addtime" class="button button-save"'.(!empty($disabledtask) ? ' disabled' : '').' value="'.$langs->trans("Save").'">';
805print '</div>';
806
807print '</form>';
808
809if (!empty($conf->use_javascript_ajax)) {
810 $modeinput = 'hours';
811 print "\n<!-- JS CODE TO ENABLE Tooltips on all object with class classfortooltip -->\n";
812 print '<script type="text/javascript">'."\n";
813 print "jQuery(document).ready(function () {\n";
814 print " updateTotal(0, '".dol_escape_js($modeinput)."');\n";
815 print ' jQuery(".timesheetalreadyrecorded").tooltip({
816 show: { collision: "flipfit", effect:\'toggle\', delay:50 },
817 hide: { effect:\'toggle\', delay: 50 },
818 tooltipClass: "mytooltip",
819 content: function () {
820 return \''.dol_escape_js($langs->trans("TimeAlreadyRecorded", $usertoprocess->getFullName($langs))).'\';
821 }
822 });'."\n";
823 print " jQuery('.inputhour, .inputminute').bind('keyup', function(e) { updateTotal(0, '".dol_escape_js($modeinput)."') });";
824 print "\n});\n";
825 print '</script>';
826}
827
828// End of page
829llxFooter();
830$db->close();
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:58
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader()
Empty header.
Definition wrapper.php:55
Class to manage standard extra fields.
Class to build HTML component for third parties management Only common components are here.
Class to manage generation of HTML components Only common components must be here.
Class permettant la generation de composants html autre Only common components are here.
Class to manage building of HTML components.
Class of the module paid holiday.
const STATUS_APPROVED
Approved.
Class to manage projects.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage tasks.
Class to manage Dolibarr users.
dol_time_plus_duree($time, $duration_value, $duration_unit, $ruleforendofmonth=0)
Add a delay to a date.
Definition date.lib.php:124
convertSecondToTime($iSecond, $format='all', $lengthOfDay=86400, $lengthOfWeek=7)
Return, in clear text, value of a number of seconds in days, hours and minutes.
Definition date.lib.php:241
num_public_holiday($timestampStart, $timestampEnd, $country_code='', $lastday=0, $includesaturday=-1, $includesunday=-1, $includefriday=-1, $includemonday=-1)
Return the number of non working days including Friday, Saturday and Sunday (or not) between 2 dates ...
Definition date.lib.php:763
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...
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0)
Show tabs of a record.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
natural_search($fields, $value, $mode=0, $nofirstand=0)
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
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...
print_liste_field_titre($name, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
img_previous($titlealt='default', $moreatt='')
Show previous logo.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0)
Set event messages in dol_events session object.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
img_next($titlealt='default', $moreatt='')
Show next logo.
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '…' if string larger than length.
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
dol_getdate($timestamp, $fast=false, $forcetimezone='')
Return an array with locale date info.
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...
projectLinesPerDay(&$inc, $parent, $fuser, $lines, &$level, &$projectsrole, &$tasksrole, $mine, $restricteditformytask, $preselectedday, &$isavailable, $oldprojectforbreak=0, $arrayfields=array(), $extrafields=null)
Output a task line into a pertime input mode.
project_timesheet_prepare_head($mode, $fuser=null)
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.