I am running Linux, PHP 5 and MySql
(mysqlt): SET SESSION sql_mode='ansi' (mysqlt): SET SESSION time_zone='America/Detroit' (mysqlt): select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = '4be51ca6a696cae9e172a5b5e8e4f3ca' AND ip_address = '70.141.24.217' AND updated_date >= 1201528750 (mysqlt): update authentication set updated_date = 1201543151 where session_id = '4be51ca6a696cae9e172a5b5e8e4f3ca' (mysqlt): select * from station where company_id = '1' AND station_id = '73cd8a004be564a15069646cbbcd93d6' AND deleted = 0 (mysqlt): select * from cron WHERE deleted = 0 ORDER BY last_run_date DESC LIMIT 1 (mysqlt): select d.severity_id as severity_id, count(*) as count from exception as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN exception_policy as d ON a.exception_policy_id = d.id LEFT JOIN pay_period as e ON b.pay_period_id = e.id where b.user_id = '1' AND a.type_id = 50 AND b.date_stamp < '2008-01-28' AND e.status_id = 10 AND NOT EXISTS ( select z.id from request as z where z.user_date_id = a.user_date_id AND z.status_id = 30 ) AND ( a.deleted = 0 AND b.deleted = 0 AND e.deleted=0) GROUP BY d.severity_id ORDER BY d.severity_id desc /tmp/timetrex//8f/adodb_8fad02a0ca0445208f29b0128a30344a.cache reloaded, ttl=1644 [ select * from user_generic_data where id = -1 ]
(mysqlt): select * from user_generic_data where user_id = '1' AND script = '/interface/timesheet/ViewUserTimeSheet.php' AND is_default = 1 AND deleted = 0 order by updated_date desc (mysqlt): SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM user_group_tree a LEFT JOIN user_group_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.object_id = 0 GROUP BY a.object_id, a.left_id, a.object_id, a.parent_id, a.right_id (mysqlt): SELECT object_id FROM user_group_tree WHERE tree_id = '1' AND parent_id = -1 LIMIT 1 (mysqlt): SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM user_group_tree a LEFT JOIN user_group_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.object_id = '0' GROUP BY a.object_id, a.left_id, a.object_id, a.parent_id, a.right_id (mysqlt): SELECT a.object_id, a.parent_id, count(b.object_id)-1 as level FROM user_group_tree a LEFT JOIN user_group_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND b.left_id >= '1' AND b.right_id <= '605' AND a.object_id != '0' GROUP BY a.object_id, a.parent_id, a.left_id ORDER BY a.left_id (mysqlt): select * from user_group where id = 1 (mysqlt): select * from user_group where id = 2 (mysqlt): select * from user_group where id = 6 (mysqlt): select * from user_group where id = 8 (mysqlt): select * from user_group where id = 23 (mysqlt): select * from user_group where id = 42 (mysqlt): select * from user_group where id = 38 (mysqlt): select * from user_group where id = 39 (mysqlt): select * from user_group where id = 37 (mysqlt): select * from user_group where id = 43 (mysqlt): select * from user_group where id = 9 (mysqlt): select * from user_group where id = 40 (mysqlt): select * from user_group where id = 10 (mysqlt): select * from user_group where id = 32 (mysqlt): select * from user_group where id = 44 (mysqlt): select * from user_group where id = 11 (mysqlt): select * from user_group where id = 14 (mysqlt): select * from user_group where id = 12 (mysqlt): select * from user_group where id = 33 (mysqlt): select * from user_group where id = 45 (mysqlt): select * from user_group where id = 19 (mysqlt): select * from user_group where id = 27 (mysqlt): select * from user_group where id = 28 (mysqlt): select * from user_group where id = 34 (mysqlt): select * from user_group where id = 46 (mysqlt): select * from user_group where id = 7 (mysqlt): select * from user_group where id = 13 (mysqlt): select * from user_group where id = 30 (mysqlt): select * from user_group where id = 29 (mysqlt): select * from user_group where id = 41 (mysqlt): select * from user_group where id = 35 (mysqlt): select * from user_group where id = 36 (mysqlt): select * from user_group where id = 48 (mysqlt): select * from user_group where id = 18 (mysqlt): select * from user_group where id = 54 (mysqlt): select * from user_group where id = 3 (mysqlt): select * from user_group where id = 26 (mysqlt): select * from user_group where id = 4 (mysqlt): select * from user_group where id = 21 (mysqlt): select * from user_group where id = 22 (mysqlt): select * from user_group where id = 5 (mysqlt): select * from user_group where id = 47 (mysqlt): select * from user_group where id = 15 (mysqlt): select * from user_group where id = 20 (mysqlt): select * from user_group where id = 24 (mysqlt): select * from user_group where id = 25 (mysqlt): select * from user_group where id = 31 (mysqlt): select * from user_group where id = 17 (mysqlt): select * from user_group where id = 16 (mysqlt): select * from user_group where id = 49 (mysqlt): select * from user_group where id = 50 (mysqlt): select * from user_group where id = 51 (mysqlt): select * from user_group where id = 52 (mysqlt): select * from user_group where id = 53 (mysqlt): select * from branch where company_id = '1' AND deleted = 0 (mysqlt): select * from department where company_id = '1' AND deleted = 0 (mysqlt): SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM hierarchy_tree a LEFT JOIN hierarchy_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.object_id = 0 GROUP BY a.object_id, a.left_id, a.object_id, a.parent_id, a.right_id (mysqlt): SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM hierarchy_tree a LEFT JOIN hierarchy_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.object_id = 0 GROUP BY a.object_id, a.left_id, a.object_id, a.parent_id, a.right_id (mysqlt): SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM hierarchy_tree a LEFT JOIN hierarchy_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.object_id = '1' GROUP BY a.object_id, a.left_id, a.object_id, a.parent_id, a.right_id (mysqlt): SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM hierarchy_tree a LEFT JOIN hierarchy_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.object_id = '64' GROUP BY a.object_id, a.left_id, a.object_id, a.parent_id, a.right_id (mysqlt): SELECT a.object_id, a.parent_id, count(b.object_id)-1 as level FROM hierarchy_tree a LEFT JOIN hierarchy_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.parent_id = '64' GROUP BY a.object_id, a.parent_id, a.left_id ORDER BY a.left_id (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = '1' (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 78 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 69 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 38 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 49 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 89 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 7 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 10 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 50 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 3 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 127 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 107 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 27 (mysqlt): select * from hierarchy_share where hierarchy_control_id = '1' AND user_id = 1 (mysqlt): SELECT a.object_id, a.parent_id, a.left_id, a.right_id, count(b.object_id)-1 as level FROM hierarchy_tree a LEFT JOIN hierarchy_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND a.object_id = 1 GROUP BY a.object_id, a.left_id, a.object_id, a.parent_id, a.right_id (mysqlt): SELECT a.object_id, a.parent_id, count(b.object_id)-1 as level FROM hierarchy_tree a LEFT JOIN hierarchy_tree b ON a.tree_id = b.tree_id AND a.left_id BETWEEN b.left_id AND b.right_id WHERE a.tree_id = '1' AND b.left_id >= '1934' AND b.right_id <= '1955' GROUP BY a.object_id, a.parent_id, a.left_id ORDER BY a.left_id /tmp/timetrex//4c/adodb_4c9dda71339c0edbc28182dda95269db.cache reloaded, ttl=1644 [ select * from users where id = -1 ]
(mysqlt): select a.* from users as a LEFT JOIN branch as b ON a.default_branch_id = b.id LEFT JOIN department as c ON a.default_department_id = c.id LEFT JOIN user_group as d ON a.group_id = d.id LEFT JOIN user_title as e ON a.title_id = e.id where a.company_id = '1' AND a.deleted = 0 order by status_id asc,last_name asc,first_name asc,middle_name asc /tmp/timetrex//4c/adodb_4c9dda71339c0edbc28182dda95269db.cache reloaded, ttl=1644 [ select * from users where id = -1 ]
(mysqlt): select * from users where company_id = '1' AND id in ('194') AND deleted = 0 order by status_id asc,last_name asc (mysqlt): select * from users where company_id = '1' AND id in ('194') AND deleted = 0 order by status_id asc,last_name asc (mysqlt): SET AUTOCOMMIT=0 (mysqlt): BEGIN /tmp/timetrex//8f/adodb_8fad02a0ca0445208f29b0128a30344a.cache reloaded, ttl=1644 [ select * from user_generic_data where id = -1 ]
(mysqlt): select * from user_generic_data where user_id = '1' AND script = '/interface/timesheet/ViewUserTimeSheet.php' AND is_default = 1 AND deleted = 0 order by updated_date desc (mysqlt): select id,user_id,script,name,is_default,data,created_date,created_by,updated_date,updated_by,deleted_date,deleted_by,deleted,company_id from user_generic_data where id = 54 (mysqlt): UPDATE user_generic_data SET IS_DEFAULT=0, UPDATED_DATE=1201543151 WHERE id = 54 (mysqlt): select id,name,company_id,user_id,script,data,is_default,updated_date,updated_by from user_generic_data where id = 54 (mysqlt): UPDATE user_generic_data SET IS_DEFAULT=1 WHERE id = 54 (mysqlt): COMMIT (mysqlt): SET AUTOCOMMIT=1 Smart Commit occurred
(mysqlt): select * from user_date where user_id = '194' AND date_stamp = '2008-01-25' AND deleted = 0 ORDER BY id ASC (mysqlt): select * from pay_period where id = '0' AND deleted=0 (mysqlt): select name FROM bread_crumb WHERE user_id = '1' AND name = 'My Timesheet' LIMIT 1 (mysqlt): UPDATE bread_crumb SET url = '/interface/timesheet/ViewUserTimeSheet.php', created_date = 1201543151 WHERE user_id = '1' AND name = 'My Timesheet' (mysqlt): select a.*, c.date_stamp as user_date_stamp, b.note as note from punch as a, punch_control as b, user_date as c, users as d where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = d.id AND d.company_id = '1' AND c.user_id = '194' AND c.date_stamp >= '2008-01-21' AND c.date_stamp <= '2008-01-27' AND ( a.deleted = 0 AND b.deleted = 0 AND c.deleted = 0 ) ORDER BY a.time_stamp asc, a.status_id desc, a.punch_control_id asc /tmp/timetrex//aa/adodb_aaba1b8b7ee92daf556dcb042b4bb180.cache reloaded, ttl=1645 [ select * from meal_policy where id = -1 ]
(mysqlt): select * from meal_policy as a where company_id = '1' AND deleted = 0 order by type_id asc (mysqlt): select a.*, b.date_stamp as user_date_stamp from user_date_total as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN over_time_policy as d ON a.over_time_policy_id = d.id where c.company_id = '1' AND b.user_id = '194' AND b.date_stamp >= '2008-01-21' AND b.date_stamp <= '2008-01-27' AND a.status_id in (10) AND a.type_id in (100) AND ( a.deleted = 0 AND b.deleted = 0 ) ORDER BY b.date_stamp asc, a.status_id asc, a.type_id asc, d.type_id desc (mysqlt): select a.*, b.date_stamp as user_date_stamp from user_date_total as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN over_time_policy as d ON a.over_time_policy_id = d.id where c.company_id = '1' AND b.user_id = '194' AND a.status_id = 10 AND a.type_id not in (40,100) AND b.date_stamp >= '2008-01-21' AND b.date_stamp <= '2008-01-27' AND ( a.deleted = 0 AND b.deleted = 0 ) ORDER BY b.date_stamp asc, a.status_id asc, a.type_id asc, d.type_id desc, a.over_time_policy_id desc, a.premium_policy_id, a.total_time, a.id (mysqlt): select * from over_time_policy where id = '1' AND deleted = 0 (mysqlt): select a.*, b.date_stamp as user_date_stamp from user_date_total as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN over_time_policy as d ON a.over_time_policy_id = d.id LEFT JOIN absence_policy as e ON a.absence_policy_id = e.id LEFT JOIN punch_control as f ON a.punch_control_id = f.id where c.company_id = '1' AND b.user_id = '194' AND a.type_id not in (10,40,100) AND b.date_stamp >= '2008-01-21' AND b.date_stamp <= '2008-01-27' AND a.status_id in (10,30) AND ( e.type_id is NULL OR e.type_id = 10 ) AND ( a.deleted = 0 AND b.deleted = 0 AND (f.deleted=0 OR f.deleted is NULL) ) ORDER BY b.date_stamp asc, a.status_id asc, a.type_id asc, d.type_id desc /tmp/timetrex//dd/adodb_dd09be64e8c914560e916f2c3cb3a58f.cache reloaded, ttl=71688 [ select * from premium_policy where id = -1 ]
(mysqlt): select * from premium_policy as a where company_id = '1' AND deleted = 0 order by type_id asc (mysqlt): select a.*, b.date_stamp as user_date_stamp from user_date_total as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN over_time_policy as d ON a.over_time_policy_id = d.id where c.company_id = '1' AND b.user_id = '194' AND b.date_stamp >= '2008-01-21' AND b.date_stamp <= '2008-01-27' AND a.status_id in (10) AND a.type_id in (40) AND ( a.deleted = 0 AND b.deleted = 0 ) ORDER BY b.date_stamp asc, a.status_id asc, a.type_id asc, d.type_id desc /tmp/timetrex//21/adodb_211264a6147e22933fa0eba400f14039.cache reloaded, ttl=1645 [ select * from absence_policy where id = -1 ]
(mysqlt): select * from absence_policy as a where company_id = '1' AND deleted = 0 order by type_id asc (mysqlt): select a.*, b.date_stamp as user_date_stamp from user_date_total as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN over_time_policy as d ON a.over_time_policy_id = d.id where c.company_id = '1' AND b.user_id = '194' AND a.status_id = 30 AND a.type_id not in (40,100) AND b.date_stamp >= '2008-01-21' AND b.date_stamp <= '2008-01-27' AND ( a.deleted = 0 AND b.deleted = 0 ) ORDER BY b.date_stamp asc, a.status_id asc, a.type_id asc, d.type_id desc, a.over_time_policy_id desc, a.premium_policy_id, a.total_time, a.id (mysqlt): select a.*, b.date_stamp as user_date_stamp, d.severity_id as severity_id, d.type_id as exception_policy_type_id from exception as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN exception_policy as d ON a.exception_policy_id = d.id where c.company_id = '1' AND b.user_id = '194' AND b.date_stamp >= '2008-01-21' AND b.date_stamp <= '2008-01-27' AND ( a.deleted = 0 AND b.deleted = 0 ) ORDER BY b.date_stamp asc, d.type_id (mysqlt): select a.*, b.date_stamp as date_stamp from request as a, user_date as b, users as c where a.user_date_id = b.id AND b.user_id = c.id AND c.company_id = '1' AND b.user_id = '194' AND a.status_id = 30 AND b.date_stamp >= '2008-01-21' AND b.date_stamp <= '2008-01-27' AND ( a.deleted = 0 AND b.deleted = 0 AND c.deleted = 0 ) /tmp/timetrex//7e/adodb_7e11c77778220df214c467401c3e3cb6.cache reloaded, ttl=1645 [ select * from holidays where id = -1 ]
(mysqlt): select distinct d.* from policy_group_user as a, policy_group as b, holiday_policy as c, holidays as d where a.policy_group_id = b.id AND b.holiday_policy_id = c.id AND c.id = d.holiday_policy_id AND d.date_stamp >= '2008-01-21' AND d.date_stamp <= '2008-01-27' AND a.user_id in ('194') AND ( c.deleted = 0 AND d.deleted=0 ) order by d.date_stamp desc (mysqlt): select sum(total_time) from user_date_total as a, user_date as b where a.user_date_id = b.id AND b.user_id = '194' AND b.pay_period_id = '0' AND ( a.status_id = 20 OR ( a.status_id = 10 AND a.type_id = 100 ) ) AND ( a.deleted = 0 AND b.deleted=0 ) (mysqlt): select sum(total_time) from user_date_total as a, user_date as b, absence_policy as c where a.user_date_id = b.id AND a.absence_policy_id = c.id AND b.user_id = '194' AND b.pay_period_id = '0' AND a.status_id = 30 AND c.type_id = 10 AND ( a.deleted = 0 AND b.deleted=0 ) (mysqlt): select sum(total_time) from user_date_total as a, user_date as b, absence_policy as c where a.user_date_id = b.id AND a.absence_policy_id = c.id AND b.user_id = '194' AND b.pay_period_id = '0' AND a.status_id = 30 AND c.type_id = 30 AND ( a.deleted = 0 AND b.deleted=0 ) (mysqlt): select a.type_id as type_id, a.over_time_policy_id as over_time_policy_id, sum(total_time) as total_time from user_date_total as a, user_date as b where a.user_date_id = b.id AND b.user_id = '194' AND b.pay_period_id = '0' AND a.status_id = 10 AND a.type_id not in ( 10, 40, 100 ) AND ( a.deleted = 0 AND b.deleted=0 ) group by a.type_id, a.over_time_policy_id order by a.type_id, a.over_time_policy_id /tmp/timetrex//c2/adodb_c28808172d9b700c3d41d866ac596a9b.cache reloaded, ttl=71688 [ select * from over_time_policy where id = -1 ]
(mysqlt): select * from over_time_policy as a where company_id = '1' AND deleted = 0 order by type_id asc,trigger_time desc (mysqlt): select a.*, b.user_id as user_id from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND a.company_id = '1' AND b.user_id in ('194') AND a.deleted = 0
In / Out
TimeSheet
Schedule
Admin
Reports
MyAccount
Help
Logout
MyTimeSheet
Mass Punch
Requests
Exceptions
Accruals
Pay Stubs
TimeTrex
The Apothecary Shoppe - Loukas Stoumbos
M
(mysqlt): SELECT name,url FROM bread_crumb WHERE user_id = '1' ORDER BY created_date DESC LIMIT 5 Home > Meal Policy List > Schedule Policy List > Policy Group List > Edit Policy Group > My Timesheet
My Timesheet
Group: Branch: Dept: Employee: Add:
Date: Pick a date
View Schedule Print Timesheet Mon
Jan 21 Tue
Jan 22 Wed
Jan 23 Thu
Jan 24 Fri
Jan 25 Sat
Jan 26 Sun
Jan 27
In
*4:00 PM
5:00 PM
7:00 PM
5:00 PM
5:00 PM
Out
*4:30 AM
6:30 AM
4:30 AM
6:30 AM
12:00 AM
Exceptions B O B O B O B O B O
Accumulated Time
Total Time 12:30 13:30 09:30 13:30 07:00 00:00 00:00
Regular Time 12:30 13:30 03:15
1 1/2 Standard Overtime Non-Exempt 06:15 13:30 07:00
Branch
Wackerly Location 12:30 13:30 09:30 13:30 07:00
Department
Delivery Wackerly 12:30 13:30 09:30 13:30 07:00
Pay Period: NONE
Verification
Brian Lemm Not Verified
Exception Legend
Code Exception
B Not Scheduled
O No Lunch
Paid Time
Worked Time 56:00
Total Time 56:00
Accumulated Time
Regular Time 29:15
1 1/2 Standard Overtime Non-Exempt 26:45
Total Time 56:00
Server response time: 1.470 seconds.
Copyright © 2007 TimeTrex-Debug. All Rights Reserved.
Time and Attendance
Debug Buffer
============================================================================
Memory Usage: 12800984
----------------------------------------------------------------------------
DEBUG [259]: [Function](): URI: /interface/timesheet/ViewUserTimeSheet.php
DEBUG [261]: [Function](): Version: 2.2.2 Edition: 10 Production: 0 Demo Mode: 0
DEBUG [107]: TTDate::setTimeZone(): Setting TimeZone: America/Detroit
DEBUG [497]: Authentication::Check(): Session Name: SessionID
DEBUG [503]: Authentication::Check(): Session ID: 4be51ca6a696cae9e172a5b5e8e4f3ca
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:4be51ca6a696cae9e172a5b5e8e4f3ca
DEBUG [78]: Authentication::getIdle(): Idle Seconds Allowed: 14400
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:4be51ca6a696cae9e172a5b5e8e4f3ca
DEBUG [69]: [Function](): User Authenticated: admin Created Date: 1201540954
DEBUG [1961]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [102]: TTDate::setTimeZone(): TimeZone already set to: America/Detroit
DEBUG [135]: TTDate::setDateFormat(): Setting Default Date Format: d-M-y
DEBUG [149]: TTDate::setTimeFormat(): Setting Default Time Format: g:i A
DEBUG [163]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 10
DEBUG [101]: [Function](): Locale Cookie: en_US
DEBUG [287]: TTi18n::getLanguageFromLocale(): Locale: en_US
DEBUG [109]: [Function](): User Preference Language matches cookie!
DEBUG [318]: TTi18n::setLocale(): Generated/Passed In Locale:
DEBUG [252]: TTi18n::generateLocale(): Array of Locales to try in order: en_US,en_US.UTF-8,en,en.UTF-8
DEBUG [211]: TTi18n::tryLocale(): Found valid locale: en_US
DEBUG [324]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 6 Current Locale:
DEBUG [327]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US
DEBUG [340]: TTi18n::setLocale(): Setting translator locale to: en_US
DEBUG [357]: TTi18n::setLocale(): Set Master Locale To: en_US
DEBUG [1961]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [1138]: UserPreferenceFactory::isPreferencesComplete(): User Preferences IS Complete:
DEBUG [138]: [Function](): Station ID Cookie found! 73cd8a004be564a15069646cbbcd93d6
DEBUG [241]: [Function](): UnRead Messages: 0
DEBUG [118]: [Function](): Found Default Filter!
DEBUG [342]: FastTree::getAllChildren(): Getting Root ID: 0
DEBUG [457]: HierarchyListFactory::getHierarchyChildrenByCompanyIdAndUserIdAndObjectTypeID(): Hierarchy Control ID: 1
DEBUG [171] Array: HierarchyListFactory::getCurrentLevelIdArrayByHierarchyControlIdAndUserId(): Nodes at the same level
Array
(
[0] => 78
[1] => 69
[2] => 38
[3] => 49
[4] => 89
[5] => 7
[6] => 10
[7] => 50
[8] => 3
[9] => 127
[10] => 107
[11] => 27
[12] => 1
)
DEBUG [178]: HierarchyListFactory::getCurrentLevelIdArrayByHierarchyControlIdAndUserId(): Root User ID: 1 Shared: 0
DEBUG [178]: [Function](): Viewing all users timesheet
DEBUG [308]: TTDate::parseDateTime(): String: 1201237200 Date Format: d-M-y
DEBUG [401]: TTDate::parseDateTime(): NO Custom Parse Format detected!
DEBUG [404]: TTDate::parseDateTime(): Parsing Date: 1201237200
DEBUG [145]: Validator::isLength(): Value: Default Length: 7 Min: 1 Max: 100
DEBUG [145]: Validator::isLength(): Value: /interface/timesheet/ViewUserTimeSheet.php Length: 42 Min: 1 Max: 250
DEBUG [739]: Factory::isValid(): Calling Validate()
DEBUG [722]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0
DEBUG [768]: Factory::Save(): Calling preSave()
DEBUG [170]: UserGenericDataFactory::preSave(): Removing Default Flag From: 54
DEBUG [739]: Factory::isValid(): Calling Validate()
DEBUG [722]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 1 Trans Off: 1
DEBUG [768]: Factory::Save(): Calling preSave()
DEBUG [739]: Factory::isValid(): Calling Validate()
DEBUG [811]: Factory::Save(): Updating...
DEBUG [636]: Factory::getUpdateQuery(): Update
DEBUG [354]: Validator::isDate(): Raw Date: 1201543151 Converted Value: 1201543151
DEBUG [667]: Factory::getUpdateQuery(): Data changed, set updated date:
DEBUG [732]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 2
DEBUG [739]: Factory::isValid(): Calling Validate()
DEBUG [811]: Factory::Save(): Updating...
DEBUG [636]: Factory::getUpdateQuery(): Update
DEBUG [354]: Validator::isDate(): Raw Date: 1201543151 Converted Value: 1201543151
DEBUG [667]: Factory::getUpdateQuery(): Data changed, set updated date:
DEBUG [732]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 1
DEBUG [295]: [Function](): Pay Period ID: 0
DEBUG [307]: [Function](): Action:
DEBUG [48]: BreadCrumb::setCrumb(): Dropping Bread Crumb: My Timesheet URL: /interface/timesheet/ViewUserTimeSheet.php
DEBUG [425]: [Function](): Default Action:
DEBUG [1099]: TTDate::getBeginWeekEpoch(): Epoch: 25-Jan-08 12:00 AM Retval: 21-Jan-08 12:00 AM Start Day of Week: 1 Offset: 4
DEBUG [1099]: TTDate::getBeginWeekEpoch(): Epoch: 25-Jan-08 12:00 AM Retval: 21-Jan-08 12:00 AM Start Day of Week: 1 Offset: 4
DEBUG [430]: [Function](): Start Date: 21-Jan-08 12:00 AM End Date: 27-Jan-08 11:59 PM
DEBUG [1270]: TTDate::getCalendarArray(): Start Day Of Week: 1
DEBUG [1272]: TTDate::getCalendarArray(): Raw Start Date: 21-Jan-08 12:00 AM Raw End Date: 27-Jan-08 11:59 PM
DEBUG [1099]: TTDate::getBeginWeekEpoch(): Epoch: 21-Jan-08 12:00 AM Retval: 21-Jan-08 12:00 AM Start Day of Week: 1 Offset: 0
DEBUG [1099]: TTDate::getBeginWeekEpoch(): Epoch: 27-Jan-08 11:59 PM Retval: 21-Jan-08 12:00 AM Start Day of Week: 1 Offset: 6
DEBUG [1283]: TTDate::getCalendarArray(): Cal Start Date: 21-Jan-08 12:00 AM Cal End Date: 27-Jan-08 11:59 PM
DEBUG [1348]: TTDate::getCalendarArray(): i: 1200891600 Date: 21-Jan-08 12:00 AM
DEBUG [1348]: TTDate::getCalendarArray(): i: 1200978000 Date: 22-Jan-08 12:00 AM
DEBUG [1348]: TTDate::getCalendarArray(): i: 1201064400 Date: 23-Jan-08 12:00 AM
DEBUG [1348]: TTDate::getCalendarArray(): i: 1201150800 Date: 24-Jan-08 12:00 AM
DEBUG [1348]: TTDate::getCalendarArray(): i: 1201237200 Date: 25-Jan-08 12:00 AM
DEBUG [1348]: TTDate::getCalendarArray(): i: 1201323600 Date: 26-Jan-08 12:00 AM
DEBUG [1348]: TTDate::getCalendarArray(): i: 1201410000 Date: 27-Jan-08 12:00 AM
DEBUG [601]: [Function](): No Punch Count: 2 Max: 14
DEBUG [601]: [Function](): No Punch Count: 2 Max: 14
DEBUG [601]: [Function](): No Punch Count: 9 Max: 14
DEBUG [601]: [Function](): No Punch Count: 16 Max: 14
DEBUG [605]: [Function](): Stopping Loop at: 3
DEBUG [615]: [Function](): Popping Off Last TWO Row: 3
DEBUG [39]: TimeSheetFormatArrayByDate(): Group Array While Loop:
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 0 Max No Punch Count: 7 Type ID: 100 ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 2 Max: 7
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 1 Max No Punch Count: 7 Type ID: 200 ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 4 Max: 7
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 2 Max No Punch Count: 7 Type ID: 301 ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 4 Max: 7
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 3 Max No Punch Count: 7 Type ID: ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 7 Max: 7
DEBUG [83]: TimeSheetFormatArrayByDate(): Stopping Loop at: 3
DEBUG [850]: [Function](): Formatting Branch Array By Date:
DEBUG [39]: TimeSheetFormatArrayByDate(): Group Array While Loop:
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 0 Max No Punch Count: 7 Type ID: 1 ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 2 Max: 7
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 1 Max No Punch Count: 7 Type ID: ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 7 Max: 7
DEBUG [83]: TimeSheetFormatArrayByDate(): Stopping Loop at: 1
DEBUG [39]: TimeSheetFormatArrayByDate(): Group Array While Loop:
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 0 Max No Punch Count: 7 Type ID: 7 ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 2 Max: 7
DEBUG [53]: TimeSheetFormatArrayByDate(): While Loop: 1 Max No Punch Count: 7 Type ID: ...
DEBUG [81]: TimeSheetFormatArrayByDate(): No Punch Count: 7 Max: 7
DEBUG [83]: TimeSheetFormatArrayByDate(): Stopping Loop at: 1
DEBUG [1071]: [Function](): Found exceptions!:
DEBUG [1278]: UserDateTotalListFactory::getWorkedTimeSumByUserIDAndPayPeriodId(): Total: 201600
DEBUG [1258]: [Function](): Worked Total Time: 201600
DEBUG [1358]: UserDateTotalListFactory::getPaidAbsenceTimeSumByUserIDAndPayPeriodId(): Total:
DEBUG [1261]: [Function](): Paid Absence Total Time:
DEBUG [1442]: UserDateTotalListFactory::getDockAbsenceTimeSumByUserIDAndPayPeriodId(): Total:
DEBUG [1264]: [Function](): Dock Absence Total Time:
DEBUG [1273]: [Function](): Type ID: 20 OverTime Policy ID: 0 Total Time: 105300
DEBUG [1273]: [Function](): Type ID: 30 OverTime Policy ID: 1 Total Time: 96300
DEBUG [1335]: [Function](): Pay Period Object NOT Found!
DEBUG [1340]: [Function](): Pay Period Schedule Found!
DEBUG [1506]: CompanyFactory::getLogoFileName(): Logo File Name: /var/www/timetrex/classes/modules/core/../../..//interface/images/timetrex_logo_wbg_small2.jpg
============================================================================
============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 82.9351 ms (5.67 %) Authentication::Check()
1 67.1868 ms (4.59 %) Interface.inc - Check for Exceptions
1 26.0429 ms (1.78 %) Interface.inc - Check for UNREAD messages...
11 18.0299 ms (1.23 %) getEmptyRecordSet()
1 57.6379 ms (3.94 %) getPermissionHierarchyChildrenByCompanyIdAndUserId
1 35.9080 ms (2.45 %) setLocale()
1 845.8729 ms (57.79 %) unprofiled
330.0824 ms (22.55 %) Missed
============================================================================
1463.6960 ms (100.00 %) OVERALL TIME
============================================================================
