"Whos In" Report no longer functions

Topics brought up by the TimeTrex open source community.
Locked
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

"Whos In" Report no longer functions

Post by lstoumbos »

I tried the whos in report and nobody shows up. This happened just after I upgraded from the TT 1.4.1 to 1.4.2

Linux 2.6
PHP 5.1.2
MySQL 5.0.24a
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

I just tested it on our end and it is working fine here, so are employees currently punched in at the exact moment you run the report?

Enable debug display and debug verbosity 11 and re-run the report and paste the output here, including the raw SQL queries.
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

(mysqlt): select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = 'd94ed95e002749b97051e79a61030204' AND ip_address = '10.10.109.192' AND updated_date >= 1169829486
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): update authentication set updated_date = 1169843886 where session_id = 'd94ed95e002749b97051e79a61030204'
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): SET SESSION time_zone='America/Detroit'
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select * from station where company_id = '1' AND station_id = 'a6c171483fa763a45a114e1e9c79584a' 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 b.date_stamp < '2007-01-26 00:00:00' 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
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select name FROM bread_crumb WHERE user_id = '1' AND name = 'Whos In' LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): UPDATE bread_crumb SET url = '/interface/report/ActiveShiftList.php', created_date = 1169843886 WHERE user_id = '1' AND name = 'Whos In'
--------------------------------------------------------------------------------
/tmp/timetrex//4c/adodb_4c9dda71339c0edbc28182dda95269db.cache reloaded, ttl=41817 [ select * from users where id = -1 ]
/tmp/timetrex//4c/adodb_4c9dda71339c0edbc28182dda95269db.cache reloaded, ttl=41817 [ select * from users where id = -1 ]

--------------------------------------------------------------------------------
(mysqlt): SELECT COUNT(*) FROM users where company_id = '1' AND deleted = 0 LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select * from users where company_id = '1' AND deleted = 0 order by status_id asc,last_name asc LIMIT 0,50
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(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.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '2' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '2' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '3' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '3' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '4' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '4' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '5' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '5' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '6' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '6' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '9' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '9' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '10' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '10' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '11' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '11' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '12' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '12' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '13' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '13' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '14' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '14' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '15' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '15' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '16' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '16' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '17' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '17' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '18' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '18' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '19' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '19' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '20' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '20' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '21' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '21' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '22' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '22' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '23' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '23' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '24' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '24' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '25' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '25' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '26' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '26' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '27' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '27' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '28' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '28' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '29' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '29' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '30' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '30' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '31' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '31' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '32' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '32' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '33' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '33' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '34' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '34' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '35' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '35' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '36' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '36' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '37' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '37' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '38' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '38' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '39' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '39' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '40' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '40' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '41' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '41' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '42' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '42' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '43' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '43' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '44' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '44' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '45' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '45' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '46' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '46' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '47' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '47' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '48' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '48' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '49' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '49' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '50' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '50' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '51' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '51' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '52' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '52' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from pay_period_schedule as a, pay_period_schedule_user as b where a.id = b.pay_period_schedule_id AND b.user_id = '53' AND a.deleted=0
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqlt): select a.* from punch as a, punch_control as b, user_date as c where a.punch_control_id = b.id AND b.user_date_id = c.id AND c.user_id = '53' AND a.time_stamp >= '2007-01-26 03:38:06' AND a.time_stamp <= '2007-01-26 15:38:06' AND ( a.deleted = 0 AND b.deleted=0 AND c.deleted=0) ORDER BY a.time_stamp desc, a.status_id asc LIMIT 1
--------------------------------------------------------------------------------


In / Out

TimeSheet

Schedule

Administration

Reports

My Account

Help

Logout




--------------------------------------------------------------------------------
(mysqlt): select a.*, b.name as group_name from help as a, help_group_control as b, help_group as c where b.id = c.help_group_control_id AND c.help_id = a.id AND b.script_name = 'ActiveShiftList.php' AND a.type_id = 10 AND a.deleted=0 AND b.deleted=0 ORDER BY c.order_value asc
--------------------------------------------------------------------------------
Position: Left | Right | Bottom X
Click the item you wish to get help on.

You may use the position links at the top of this window to move it around the screen, or to close the window press the X in the upper right of this window, or press the ESC key.
Sorry, no help is available for that item yet.
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 > Exception List > My TimeSheet > Whos In
Last edited by lstoumbos on Fri Jan 26, 2007 1:49 pm, edited 1 time in total.
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

---------------[ Fri, 26 Jan 2007 15:40:50 -0500 (PID: 3027) ]---------------
DEBUG [135]: <b>[Function]()</b>: URI: /interface/report/ActiveShiftList.php<br>
DEBUG [137]: <b>[Function]()</b>: Production: 1<br>
DEBUG [92]: <b>TTDate::setTimeZone()</b>: Setting TimeZone: PST8PDT<br>
DEBUG [444]: <b>Authentication::Check()</b>: Session Name: SessionID<br>
DEBUG [450]: <b>Authentication::Check()</b>: Session ID: d94ed95e002749b97051e79a61030204<br>
DEBUG [301]: <b>Validator::stripNonAlphaNumeric()</b>: Alpha Numeric String:d94ed95e002749b97051e79a61030204<br>
DEBUG [78]: <b>Authentication::getIdle()</b>: Idle Seconds Allowed: 14400<br>
DEBUG [301]: <b>Validator::stripNonAlphaNumeric()</b>: Alpha Numeric String:d94ed95e002749b97051e79a61030204<br>
DEBUG [62]: <b>[Function]()</b>: User Authenticated: admin<br>
DEBUG [1696]: <b>UserFactory::isInformationComplete()</b>: User Information is Complete: <br>
DEBUG [92]: <b>TTDate::setTimeZone()</b>: Setting TimeZone: America/Detroit<br>
DEBUG [108]: <b>TTDate::setDateFormat()</b>: Setting Default Date Format: d-M-y<br>
DEBUG [122]: <b>TTDate::setTimeFormat()</b>: Setting Default Time Format: g:i A<br>
DEBUG [136]: <b>TTDate::setTimeUnitFormat()</b>: Setting Default Time Unit Format: 10<br>
DEBUG [1696]: <b>UserFactory::isInformationComplete()</b>: User Information is Complete: <br>
DEBUG [954]: <b>UserPreferenceFactory::isPreferencesComplete()</b>: User Preferences IS Complete: <br>
DEBUG [105]: <b>[Function]()</b>: Station ID Cookie found! a6c171483fa763a45a114e1e9c79584a<br>
DEBUG [196]: <b>[Function]()</b>: UnRead Messages: 0<br>
DEBUG [48]: <b>BreadCrumb::setCrumb()</b>: Dropping Bread Crumb: Whos In URL: /interface/report/ActiveShiftList.php<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 2 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 3 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 4 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 5 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 6 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 9 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 10 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 11 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 12 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 13 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 14 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 15 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 16 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 17 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 18 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 19 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 20 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 21 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 22 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 23 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 24 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 25 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 26 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 27 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 28 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 29 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 30 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 31 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 32 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 33 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 34 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 35 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 36 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 37 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 38 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 39 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 40 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 41 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 42 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 43 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 44 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 45 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 46 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 47 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 48 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 49 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 50 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 51 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 52 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [277]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: User ID: 53 Epoch: 1169844049<br>
DEBUG [293]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: aPay Period Schedule Continuous Time: 43200<br>
DEBUG [298]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: bPay Period Schedule Continuous Time: 43200<br>
DEBUG [306]: <b>PunchListFactory::getPreviousPunchByUserIdAndEpoch()</b>: Start Time: 26-Jan-07 3:40 AM<br>
DEBUG [93]: <b>URLBuilder::getURL()</b>: URL Values: sort_column=last_name&sort_order=desc&page=<br>
DEBUG [93]: <b>URLBuilder::getURL()</b>: URL Values: sort_column=last_name&sort_order=asc&page=<br>
DEBUG [93]: <b>URLBuilder::getURL()</b>: URL Values: sort_column=start_date&sort_order=desc&page=<br>
DEBUG [93]: <b>URLBuilder::getURL()</b>: URL Values: sort_column=start_date&sort_order=asc&page=<br>
DEBUG [93]: <b>URLBuilder::getURL()</b>: URL Values: sort_column=start_date&sort_order=desc&page=<br>
DEBUG [93]: <b>URLBuilder::getURL()</b>: URL Values: sort_column=start_date&sort_order=asc&page=<br>
DEBUG [93]: <b>URLBuilder::getURL()</b>: URL Values: sort_column=start_date&sort_order=desc&page=<br>
DEBUG [93]: <b>URLBuilder::getURL()</b>: URL Values: sort_column=start_date&sort_order=asc&page=<br>
---------------[ Fri, 26 Jan 2007 15:40:50 -0500 (PID: 3027) ]---------------
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

At first glance everything looks fine.

I come back to my original question, are employees actually punched in? By punched in I mean are they punched in and not out yet. Because as soon as they punch out, they won't show up on the report anymore (after a certain amount of time)

Also ensure that employees are assigned to a pay period schedule. But I think they are in your case.
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

That would be the obvious problem if employees weren't punched in, but they are punched in. I am one of them punched in and I don't even show up.

I don't know if this makes a difference but I also have more than 53 users. It looks like from the logs its scanning the users and I have 104 in there.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

Thats a very useful bit of information. Edit interface/report/ActiveShiftList.php

On line 67, change:

Code: Select all

$ulf->getByCompanyID($current_company->getID(), 50, $page, array($sort_column => $sort_order) );
to:

Code: Select all

$ulf->getByCompanyID($current_company->getID(), NULL, NULL, array($sort_column => $sort_order) );
lstoumbos
Posts: 80
Joined: Wed Jan 10, 2007 7:41 am

Post by lstoumbos »

Thanx for the help, just confirming the fix worked.
Locked