2023-04-03 15:12:35 NOTICE 127.0.0.1 --- Access to POST /custom/timesheet/Timesheet.php - action=submit, massaction= 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2023-04-03 15:12:35 DEBUG 127.0.0.1 User::loadParentOf 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1) 2023-04-03 15:12:35 DEBUG 127.0.0.1 User::get_full_tree get user list 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT DISTINCT u.rowid, u.firstname, u.lastname, u.fk_user, u.fk_soc, u.login, u.email, u.gender, u.admin, u.statut, u.photo, u.entity FROM llx_user as u WHERE u.entity IN (0,1) 2023-04-03 15:12:35 DEBUG 127.0.0.1 User::get_full_tree call to build_path_from_id_user 2023-04-03 15:12:35 DEBUG 127.0.0.1 User::get_full_tree dol_sort_array 2023-04-03 15:12:35 INFO 127.0.0.1 Build childid for id = 2 2023-04-03 15:12:35 DEBUG 127.0.0.1 task_timesheet::get_userName 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT usr.rowid, CONCAT(usr.firstname, ' ', usr.lastname) as username FROM llx_user AS usr WHERE usr.rowid = 2 2023-04-03 15:12:35 INFO 127.0.0.1 TimesheetUserTasks::fetch 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT t.rowid, t.fk_userid, t.date_start, t.date_end, t.status, t.date_creation, t.date_modification, t.fk_user_modification, t.note FROM llx_project_task_timesheet as t WHERE t.rowid = 7 2023-04-03 15:12:35 INFO 127.0.0.1 Entering in Timesheet::task_timesheet.php::updateActuals() 2023-04-03 15:12:35 DEBUG 127.0.0.1 Timesheet.class::postTaskTimeActual taskTimeId=109 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::saveTaskTime duration Old=4260 New=4380 Id=20, date=1680472800 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::saveTaskTime taskTimeUpdate 2023-04-03 15:12:35 DEBUG 127.0.0.1 BEGIN Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::updateTimeSpent 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=UPDATE llx_projet_task_time SET task_date = '2023-04-03 00:00:00', task_datehour = '2023-04-03 00:00:00', task_date_withhour = 0, task_duration = 4380, fk_user = 2, note = '' WHERE rowid = 20 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::updateTimeSpent 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=UPDATE llx_projet_task SET duration_effective = (SELECT SUM(task_duration) FROM llx_projet_task_time as ptt where ptt.fk_task = 109) WHERE rowid = 109 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::addTimeSpent 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=UPDATE llx_projet_task_time SET thm = (SELECT thm FROM llx_user WHERE rowid = 2) WHERE (thm IS NULL OR thm = 0) AND rowid = 20 2023-04-03 15:12:35 DEBUG 127.0.0.1 COMMIT Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::saveTaskTime duration Old=0 New=0 Id=0, date=1680580800 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::saveTaskTime duration Old=0 New=0 Id=0, date=1680667200 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::saveTaskTime duration Old=0 New=0 Id=0, date=1680753600 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::saveTaskTime duration Old=0 New=0 Id=0, date=1680840000 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::saveTaskTime duration Old=0 New=0 Id=0, date=1680926400 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::saveTaskTime duration Old=0 New=0 Id=0, date=1681012800 2023-04-03 15:12:35 DEBUG 127.0.0.1 BEGIN Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::updateTimeUsed 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=UPDATE llx_projet_task AS pt SET duration_effective = (SELECT SUM(ptt.task_duration) FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '109') WHERE pt.rowid = '109' 2023-04-03 15:12:35 DEBUG 127.0.0.1 COMMIT Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 Timesheet.class::postTaskTimeActual taskTimeId=99 2023-04-03 15:12:35 DEBUG 127.0.0.1 BEGIN Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::updateTimeUsed 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=UPDATE llx_projet_task AS pt SET duration_effective = (SELECT SUM(ptt.task_duration) FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '99') WHERE pt.rowid = '99' 2023-04-03 15:12:35 DEBUG 127.0.0.1 COMMIT Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 Timesheet.class::postTaskTimeActual taskTimeId=1 2023-04-03 15:12:35 DEBUG 127.0.0.1 BEGIN Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::updateTimeUsed 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=UPDATE llx_projet_task AS pt SET duration_effective = (SELECT SUM(ptt.task_duration) FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '1') WHERE pt.rowid = '1' 2023-04-03 15:12:35 DEBUG 127.0.0.1 COMMIT Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 Timesheet.class::postTaskTimeActual taskTimeId=94 2023-04-03 15:12:35 DEBUG 127.0.0.1 BEGIN Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::updateTimeUsed 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=UPDATE llx_projet_task AS pt SET duration_effective = (SELECT SUM(ptt.task_duration) FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '94') WHERE pt.rowid = '94' 2023-04-03 15:12:35 DEBUG 127.0.0.1 COMMIT Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 Timesheet.class::postTaskTimeActual taskTimeId=91 2023-04-03 15:12:35 DEBUG 127.0.0.1 BEGIN Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::updateTimeUsed 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=UPDATE llx_projet_task AS pt SET duration_effective = (SELECT SUM(ptt.task_duration) FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '91') WHERE pt.rowid = '91' 2023-04-03 15:12:35 DEBUG 127.0.0.1 COMMIT Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 Timesheet.class::postTaskTimeActual taskTimeId=96 2023-04-03 15:12:35 DEBUG 127.0.0.1 BEGIN Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::updateTimeUsed 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=UPDATE llx_projet_task AS pt SET duration_effective = (SELECT SUM(ptt.task_duration) FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '96') WHERE pt.rowid = '96' 2023-04-03 15:12:35 DEBUG 127.0.0.1 COMMIT Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 BEGIN Transaction 2023-04-03 15:12:35 INFO 127.0.0.1 TimesheetUserTasks::update 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=UPDATE llx_project_task_timesheet SET fk_userid='2', date_start='2023-04-03 00:00:00', date_end='2023-04-10 00:00:00', status=1, date_modification = NOW(), fk_user_modification = '2', note = '' WHERE rowid=7 2023-04-03 15:12:35 DEBUG 127.0.0.1 COMMIT Transaction 2023-04-03 15:12:35 INFO 127.0.0.1 TimesheetFavourite::fetchUserList 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT t.rowid, t.fk_user, t.fk_project, t.fk_project_task, t.subtask, t.date_start, t.date_end FROM llx_timesheet_whitelist as t WHERE t.fk_user = 2 AND (t.date_end >'2023-04-03 00:00:00' OR t.date_end IS NULL) AND (t.date_start <'2023-04-10 00:00:00' OR t.date_start IS NULL) 2023-04-03 15:12:35 INFO 127.0.0.1 TimesheetFavourite::getTaskList 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT t.rowid FROM llx_projet_task as t WHERE t.rowid = '109' 2023-04-03 15:12:35 DEBUG 127.0.0.1 timesheet::getTasksTimesheet full 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT DISTINCT element_id as taskid, prj.fk_soc, tsk.fk_projet, tsk.fk_task_parent, tsk.rowid, app.rowid as appid, prj.ref as prjRef, tsk.ref as tskRef FROM llx_element_contact as ec LEFT JOIN llx_c_type_contact as ctc ON(ctc.rowid = ec.fk_c_type_contact AND ctc.active = '1') JOIN llx_projet_task as tsk ON tsk.rowid = ec.element_id LEFT JOIN llx_projet as prj ON prj.rowid = tsk.fk_projet LEFT JOIN llx_project_task_time_approval as app ON tsk.rowid = app.fk_projet_task AND app.fk_userid = fk_socpeople AND app.date_start = '2023-04-03 00:00:00' AND app.date_end = '2023-04-10 00:00:00' WHERE ec.fk_socpeople = '2' AND ctc.element = 'project_task' AND (prj.datee>='2023-04-03 00:00:00' OR prj.datee IS NULL) AND (prj.dateo<='2023-04-10 00:00:00' OR prj.dateo IS NULL) AND (tsk.datee>='2023-04-03 00:00:00' OR tsk.datee IS NULL) AND (tsk.dateo<='2023-04-10 00:00:00' OR tsk.dateo IS NULL) ORDER BY prj.fk_soc, prjRef, tskRef 2023-04-03 15:12:35 INFO 127.0.0.1 TimesheetTask::fetch 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT t.rowid, t.fk_userid, t.date_start, t.date_end, t.status, t.sender, t.recipient, t.planned_workload, t.fk_user_app_team, t.fk_user_app_project, t.fk_user_app_customer, t.fk_user_app_supplier, t.fk_user_app_other, t.date_creation, t.date_modification, t.fk_user_creation, t.fk_user_modification, t.fk_projet_task, t.fk_project_task_timesheet, t.note FROM llx_project_task_time_approval as t WHERE t.rowid = 12 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetUserTasks::fetchTaskTimesheet::task=109 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getTaskInfo 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT p.rowid, p.datee as pdatee, p.fk_statut as pstatus, p.dateo as pdateo, pt.dateo, pt.datee, pt.planned_workload, pt.duration_effective, CONCAT(p.ref, ' - ', p.title) as title, CONCAT(pt.ref, ' - ', pt.label) as label, p.fk_soc as companyId, s.nom as companyName FROM llx_projet_task AS pt JOIN llx_projet as p ON pt.fk_projet = p.rowid LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE pt.rowid = '109' 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getActuals 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT ptt.rowid, ptt.task_duration, DATE(ptt.task_datehour) AS task_date, ptt.note FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '109' AND (ptt.fk_user = '2') AND (DATE(ptt.task_datehour)>='2023-04-03 00:00:00') AND (DATE(ptt.task_datehour)<'2023-04-10 00:00:00') 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetUserTasks::fetchTaskTimesheet::task=99 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getTaskInfo 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT p.rowid, p.datee as pdatee, p.fk_statut as pstatus, p.dateo as pdateo, pt.dateo, pt.datee, pt.planned_workload, pt.duration_effective, CONCAT(p.ref, ' - ', p.title) as title, CONCAT(pt.ref, ' - ', pt.label) as label, p.fk_soc as companyId, s.nom as companyName FROM llx_projet_task AS pt JOIN llx_projet as p ON pt.fk_projet = p.rowid LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE pt.rowid = '99' 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getActuals 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT ptt.rowid, ptt.task_duration, DATE(ptt.task_datehour) AS task_date, ptt.note FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '99' AND (ptt.fk_user = '2') AND (DATE(ptt.task_datehour)>='2023-04-03 00:00:00') AND (DATE(ptt.task_datehour)<'2023-04-10 00:00:00') 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetUserTasks::fetchTaskTimesheet::task=1 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getTaskInfo 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT p.rowid, p.datee as pdatee, p.fk_statut as pstatus, p.dateo as pdateo, pt.dateo, pt.datee, pt.planned_workload, pt.duration_effective, CONCAT(p.ref, ' - ', p.title) as title, CONCAT(pt.ref, ' - ', pt.label) as label, p.fk_soc as companyId, s.nom as companyName FROM llx_projet_task AS pt JOIN llx_projet as p ON pt.fk_projet = p.rowid LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE pt.rowid = '1' 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getActuals 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT ptt.rowid, ptt.task_duration, DATE(ptt.task_datehour) AS task_date, ptt.note FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '1' AND (ptt.fk_user = '2') AND (DATE(ptt.task_datehour)>='2023-04-03 00:00:00') AND (DATE(ptt.task_datehour)<'2023-04-10 00:00:00') 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetUserTasks::fetchTaskTimesheet::task=94 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getTaskInfo 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT p.rowid, p.datee as pdatee, p.fk_statut as pstatus, p.dateo as pdateo, pt.dateo, pt.datee, pt.planned_workload, pt.duration_effective, CONCAT(p.ref, ' - ', p.title) as title, CONCAT(pt.ref, ' - ', pt.label) as label, p.fk_soc as companyId, s.nom as companyName FROM llx_projet_task AS pt JOIN llx_projet as p ON pt.fk_projet = p.rowid LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE pt.rowid = '94' 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getActuals 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT ptt.rowid, ptt.task_duration, DATE(ptt.task_datehour) AS task_date, ptt.note FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '94' AND (ptt.fk_user = '2') AND (DATE(ptt.task_datehour)>='2023-04-03 00:00:00') AND (DATE(ptt.task_datehour)<'2023-04-10 00:00:00') 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetUserTasks::fetchTaskTimesheet::task=91 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getTaskInfo 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT p.rowid, p.datee as pdatee, p.fk_statut as pstatus, p.dateo as pdateo, pt.dateo, pt.datee, pt.planned_workload, pt.duration_effective, CONCAT(p.ref, ' - ', p.title) as title, CONCAT(pt.ref, ' - ', pt.label) as label, p.fk_soc as companyId, s.nom as companyName FROM llx_projet_task AS pt JOIN llx_projet as p ON pt.fk_projet = p.rowid LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE pt.rowid = '91' 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getActuals 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT ptt.rowid, ptt.task_duration, DATE(ptt.task_datehour) AS task_date, ptt.note FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '91' AND (ptt.fk_user = '2') AND (DATE(ptt.task_datehour)>='2023-04-03 00:00:00') AND (DATE(ptt.task_datehour)<'2023-04-10 00:00:00') 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetUserTasks::fetchTaskTimesheet::task=96 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getTaskInfo 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT p.rowid, p.datee as pdatee, p.fk_statut as pstatus, p.dateo as pdateo, pt.dateo, pt.datee, pt.planned_workload, pt.duration_effective, CONCAT(p.ref, ' - ', p.title) as title, CONCAT(pt.ref, ' - ', pt.label) as label, p.fk_soc as companyId, s.nom as companyName FROM llx_projet_task AS pt JOIN llx_projet as p ON pt.fk_projet = p.rowid LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE pt.rowid = '96' 2023-04-03 15:12:35 DEBUG 127.0.0.1 TimesheetTask::getActuals 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT ptt.rowid, ptt.task_duration, DATE(ptt.task_datehour) AS task_date, ptt.note FROM llx_projet_task_time AS ptt WHERE ptt.fk_task = '96' AND (ptt.fk_user = '2') AND (DATE(ptt.task_datehour)>='2023-04-03 00:00:00') AND (DATE(ptt.task_datehour)<'2023-04-10 00:00:00') 2023-04-03 15:12:35 DEBUG 127.0.0.1 BEGIN Transaction 2023-04-03 15:12:35 INFO 127.0.0.1 TimesheetTask::update 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=UPDATE llx_project_task_time_approval SET fk_userid='2', date_start='2023-04-03 00:00:00', date_end='2023-04-10 00:00:00', status='1', sender=null, recipient='1', planned_workload=null, fk_user_app_team=NULL, fk_user_app_project=NULL, fk_user_app_customer=NULL, fk_user_app_supplier=NULL, fk_user_app_other=NULL, date_modification = NOW(), fk_user_modification = '2', fk_projet_task='109', fk_project_task_timesheet='7', note = '' WHERE rowid=12 2023-04-03 15:12:35 DEBUG 127.0.0.1 COMMIT Transaction 2023-04-03 15:12:35 DEBUG 127.0.0.1 task_timesheet::get_userName 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT usr.rowid, CONCAT(usr.firstname, ' ', usr.lastname) as username FROM llx_user AS usr WHERE usr.rowid = 2 2023-04-03 15:12:35 INFO 127.0.0.1 TimesheetUserTasks::fetch 2023-04-03 15:12:35 DEBUG 127.0.0.1 sql=SELECT t.rowid, t.fk_userid, t.date_start, t.date_end, t.status, t.date_creation, t.date_modification, t.fk_user_modification, t.note FROM llx_project_task_timesheet as t WHERE t.rowid = 7 2023-04-03 15:12:35 INFO 127.0.0.1 --- End access to /custom/timesheet/Timesheet.php