Time: 0.026745080947876 -- 25-08-13 08:24:31[黄绮敏-2142] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para=%7B%22event%22:%22edit_turnfull%22,%22turnfull_id%22:%22212%22%7D&event=edit_turnfull&turnfull_id=212 SELECT tf.turnfull_id,tf.turnfull_no,tf.owner_id,tf.status_id,tf.employee_id,tf.employee_name,tf.employee_no,tf.department_id, DATE_FORMAT(tf.entry_time,'%Y-%m-%d') entry_time,tf.createdon,tf.updatedon,tf.trial_job_id,tf.trial_salary,tf.firstMonth_assess, tf.secondMonth_assess,tf.thirdMonth_assess,tf.trial_goodresult,tf.trial_ability,tf.brief_summary,tf.self_evaluation, DATE_FORMAT(tf.apply_date,'%Y-%m-%d') apply_date,tf.appr_proc_id,tf.cur_appr_id_str,org.org_name department, apro.appr_proc_name,job.job_name trial_job,IFNULL(DATE_FORMAT(tf.effective_date,'%Y-%m-%d'),'') effective_date, IFNULL(turnfull_job.job_name,'') turnfull_job,IFNULL(tf.turnfull_salary,'') turnfull_salary FROM dbhr.hr_turnfull tf LEFT JOIN dboa.oa_appr_process apro ON tf.appr_proc_id = apro.appr_proc_id LEFT JOIN dbhr.hr_job job ON tf.trial_job_id = job.job_id LEFT JOIN dbhr.hr_job turnfull_job ON tf.turnfull_job_id = turnfull_job.job_id LEFT JOIN dbsys.sys_org org ON tf.department_id = org.org_id WHERE tf.turnfull_id = 212 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048551559448242 -- 25-08-13 08:24:31[黄绮敏-2142] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para=%7B%22event%22:%22edit_turnfull%22,%22turnfull_id%22:%22212%22%7D&event=edit_turnfull&turnfull_id=212 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2142 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02565598487854 -- 25-08-13 08:44:24 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029124021530151 -- 25-08-13 08:44:26[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038790702819824 -- 25-08-13 08:44:26[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043399333953857 -- 25-08-13 08:44:26[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091400146484375 -- 25-08-13 08:44:26[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042200088500977 -- 25-08-13 08:44:26[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043911933898926 -- 25-08-13 08:44:26[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029396057128906 -- 25-08-13 08:44:33[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0067250728607178 -- 25-08-13 08:44:33[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 1423 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048141479492188 -- 25-08-13 08:44:33[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.035885095596313 -- 25-08-13 09:11:33[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1423 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021075963973999 -- 25-08-13 09:11:40[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00406813621521 -- 25-08-13 09:11:40[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039989948272705 -- 25-08-13 09:11:40[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039410591125488 -- 25-08-13 09:11:40[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039470195770264 -- 25-08-13 09:11:40[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 1423 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039758682250977 -- 25-08-13 09:11:40[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 1423 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020279169082642 -- 25-08-13 09:11:41[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7241 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049660205841064 -- 25-08-13 09:11:41[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7241 SELECT ow.offwork_id,ow.offwork_no,ow.offwork_type_id,ow.owner_id,ow.status_id,ow.employee_id,ow.department_id,ow.job_id, ow.appr_proc_id,ow.offwork_reason,ow.notes,e.employee_name,depart.org_name department,j.job_name,proc.appr_proc_name, DATE_FORMAT(ow.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date, DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON e.employee_id = ow.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ow.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = ow.job_id LEFT JOIN dboa.oa_appr_process proc ON proc.appr_proc_id = ow.appr_proc_id WHERE ow.offwork_id = 7241 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037868022918701 -- 25-08-13 09:11:41[李振撼-1423] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7241 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1423 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016736030578613 -- 25-08-13 11:29:22[余泽旭-927] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028581857681274 -- 25-08-13 11:54:13[胡发根-832] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 832 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043230056762695 -- 25-08-13 11:54:13[胡发根-832] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 832 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043098926544189 -- 25-08-13 11:54:13[胡发根-832] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 832 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048220157623291 -- 25-08-13 11:54:13[胡发根-832] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 832 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043239593505859 -- 25-08-13 11:54:13[胡发根-832] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 832 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042800903320312 -- 25-08-13 11:54:13[胡发根-832] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 832 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017147064208984 -- 25-08-13 11:54:16[胡发根-832] -- /buz/hr/index.php/hrmgmt/hr_approval_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 832 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018795967102051 -- 25-08-13 14:57:28 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030368089675903 -- 25-08-13 14:57:30[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 1295 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004302978515625 -- 25-08-13 14:57:30[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 1295 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043280124664307 -- 25-08-13 14:57:30[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 1295 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044441223144531 -- 25-08-13 14:57:30[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 1295 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043060779571533 -- 25-08-13 14:57:30[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 1295 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042960643768311 -- 25-08-13 14:57:30[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 1295 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024902820587158 -- 25-08-13 14:57:33[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '9' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047929286956787 -- 25-08-13 14:57:33[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 9 AND c.cont_id = 1295 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004694938659668 -- 25-08-13 14:57:33[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 235 and acct_id = 9 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022639989852905 -- 25-08-13 14:57:39[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 1295 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048530101776123 -- 25-08-13 14:57:39[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 1295 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004802942276001 -- 25-08-13 14:57:39[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 1295 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049891471862793 -- 25-08-13 14:57:39[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 1295 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048060417175293 -- 25-08-13 14:57:39[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 1295 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047948360443115 -- 25-08-13 14:57:39[丁松坤-1295] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 1295 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01766300201416 -- 25-08-13 15:05:27 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003507137298584 -- 25-08-13 15:05:27 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043370723724365 -- 25-08-13 15:05:27 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ChenZiHao' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037400722503662 -- 25-08-13 15:05:27[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 14 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016191959381104 -- 25-08-13 15:05:27[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036220550537109 -- 25-08-13 15:05:27[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035858154296875 -- 25-08-13 15:05:27[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 660 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004141092300415 -- 25-08-13 15:05:27[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035581588745117 -- 25-08-13 15:05:27[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035459995269775 -- 25-08-13 15:05:28[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 660 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019253015518188 -- 25-08-13 15:05:30[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '14' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047681331634521 -- 25-08-13 15:05:30[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 14 AND c.cont_id = 660 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047430992126465 -- 25-08-13 15:05:30[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 184 and acct_id = 14 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01980996131897 -- 25-08-13 15:05:32[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042719841003418 -- 25-08-13 15:05:32[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042390823364258 -- 25-08-13 15:05:32[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 660 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045878887176514 -- 25-08-13 15:05:32[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043089389801025 -- 25-08-13 15:05:32[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 660 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042259693145752 -- 25-08-13 15:05:32[陈梓豪-660] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 660 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023768901824951 -- 25-08-13 16:15:18 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02007794380188 -- 25-08-13 16:15:21[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045719146728516 -- 25-08-13 16:15:21[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044238567352295 -- 25-08-13 16:15:21[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044651031494141 -- 25-08-13 16:15:21[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044398307800293 -- 25-08-13 16:15:21[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043680667877197 -- 25-08-13 16:15:21[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02950119972229 -- 25-08-13 16:15:25[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036489963531494 -- 25-08-13 16:15:25[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036158561706543 -- 25-08-13 16:15:25[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036349296569824 -- 25-08-13 16:15:25[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003633975982666 -- 25-08-13 16:15:25[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035970211029053 -- 25-08-13 16:15:25[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023421049118042 -- 25-08-13 16:15:32[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name FROM dbsys.`sys_contact` c LEFT JOIN dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 23 AND c.cont_id = 2273 and c.`cont_name`=e.employee_name limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054550170898438 -- 25-08-13 16:15:32[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 271 and acct_id = 23 AND is_enable = 1 AND appr_type_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022063016891479 -- 25-08-13 16:16:03[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046830177307129 -- 25-08-13 16:16:03[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046689510345459 -- 25-08-13 16:16:03[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047259330749512 -- 25-08-13 16:16:03[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047199726104736 -- 25-08-13 16:16:03[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004647970199585 -- 25-08-13 16:16:03[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020328044891357 -- 25-08-13 16:16:06[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004176139831543 -- 25-08-13 16:16:06[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041289329528809 -- 25-08-13 16:16:06[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040960311889648 -- 25-08-13 16:16:06[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038080215454102 -- 25-08-13 16:16:06[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040779113769531 -- 25-08-13 16:16:06[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021784067153931 -- 25-08-13 16:16:07[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=297 SELECT q.quit_id,q.status_id,q.employee_id,e.department_id,e.job_id,q.owner_id,q.appr_proc_id,q.quit_reason_para,q.quit_no, e.employee_name,o.org_name department,j.job_name,q.quit_type_id,q.other_quit_reason,q.quit_reason,q.advision, a_p.appr_proc_name,DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e on e.employee_id = q.employee_id LEFT JOIN dbsys.sys_org o on o.org_id = e.department_id LEFT JOIN dbhr.hr_job j on j.job_id = e.job_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = q.createdby_id LEFT JOIN dbsys.sys_contact UB ON UB.cont_id = q.updatedby_id LEFT JOIN dboa.oa_appr_process a_p ON a_p.appr_proc_id = q.appr_proc_id WHERE q.quit_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039520263671875 -- 25-08-13 16:16:07[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=297 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2273 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021841049194336 -- 25-08-13 16:16:11[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047178268432617 -- 25-08-13 16:16:11[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004666805267334 -- 25-08-13 16:16:11[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046408176422119 -- 25-08-13 16:16:11[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042910575866699 -- 25-08-13 16:16:11[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046288967132568 -- 25-08-13 16:16:11[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.034938097000122 -- 25-08-13 16:16:29[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7210 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '23' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005795955657959 -- 25-08-13 16:16:29[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7210 SELECT ow.offwork_id,ow.offwork_no,ow.offwork_type_id,ow.owner_id,ow.status_id,ow.employee_id,ow.department_id,ow.job_id, ow.appr_proc_id,ow.offwork_reason,ow.notes,e.employee_name,depart.org_name department,j.job_name,proc.appr_proc_name, DATE_FORMAT(ow.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date, DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON e.employee_id = ow.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ow.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = ow.job_id LEFT JOIN dboa.oa_appr_process proc ON proc.appr_proc_id = ow.appr_proc_id WHERE ow.offwork_id = 7210 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045030117034912 -- 25-08-13 16:16:29[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7210 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2273 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018499135971069 -- 25-08-13 16:16:35[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039770603179932 -- 25-08-13 16:16:35[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039858818054199 -- 25-08-13 16:16:35[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039889812469482 -- 25-08-13 16:16:35[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046279430389404 -- 25-08-13 16:16:35[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039920806884766 -- 25-08-13 16:16:35[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030944108963013 -- 25-08-13 16:16:36[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044388771057129 -- 25-08-13 16:16:36[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044147968292236 -- 25-08-13 16:16:36[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044319629669189 -- 25-08-13 16:16:36[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041079521179199 -- 25-08-13 16:16:36[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044410228729248 -- 25-08-13 16:16:36[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026448011398315 -- 25-08-13 16:16:38[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=297 SELECT q.quit_id,q.status_id,q.employee_id,e.department_id,e.job_id,q.owner_id,q.appr_proc_id,q.quit_reason_para,q.quit_no, e.employee_name,o.org_name department,j.job_name,q.quit_type_id,q.other_quit_reason,q.quit_reason,q.advision, a_p.appr_proc_name,DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e on e.employee_id = q.employee_id LEFT JOIN dbsys.sys_org o on o.org_id = e.department_id LEFT JOIN dbhr.hr_job j on j.job_id = e.job_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = q.createdby_id LEFT JOIN dbsys.sys_contact UB ON UB.cont_id = q.updatedby_id LEFT JOIN dboa.oa_appr_process a_p ON a_p.appr_proc_id = q.appr_proc_id WHERE q.quit_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016179084777832 -- 25-08-13 16:16:46[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=save_quit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2273 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017937898635864 -- 25-08-13 16:16:53[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037031173706055 -- 25-08-13 16:16:53[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036849975585938 -- 25-08-13 16:16:53[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036461353302002 -- 25-08-13 16:16:53[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033388137817383 -- 25-08-13 16:16:53[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036568641662598 -- 25-08-13 16:16:53[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016772985458374 -- 25-08-13 16:16:57[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034098625183105 -- 25-08-13 16:16:57[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034430027008057 -- 25-08-13 16:16:57[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033798217773438 -- 25-08-13 16:16:57[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033700466156006 -- 25-08-13 16:16:57[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003375768661499 -- 25-08-13 16:16:57[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019768953323364 -- 25-08-13 16:17:00[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7210 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '23' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042350292205811 -- 25-08-13 16:17:00[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7210 SELECT ow.offwork_id,ow.offwork_no,ow.offwork_type_id,ow.owner_id,ow.status_id,ow.employee_id,ow.department_id,ow.job_id, ow.appr_proc_id,ow.offwork_reason,ow.notes,e.employee_name,depart.org_name department,j.job_name,proc.appr_proc_name, DATE_FORMAT(ow.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(ow.start_date,'%Y-%m-%d %H:%i') start_date, DATE_FORMAT(ow.end_date,'%Y-%m-%d %H:%i') end_date, o_e.adjustLeave_leftDays,o_e.annualLeave_leftDays,o_e.personalLeave_applyDays,o_e.annualLeave_applyDays,o_e.adjustLeave_applyDays FROM dbhr.hr_offwork ow LEFT JOIN dbhr.hr_offwork_ext o_e ON o_e.offwork_id = ow.offwork_id LEFT JOIN dbhr.hr_employee e ON e.employee_id = ow.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = ow.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = ow.job_id LEFT JOIN dboa.oa_appr_process proc ON proc.appr_proc_id = ow.appr_proc_id WHERE ow.offwork_id = 7210 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038771629333496 -- 25-08-13 16:17:00[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_id=7210 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2273 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022937059402466 -- 25-08-13 16:17:02[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046169757843018 -- 25-08-13 16:17:02[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004601001739502 -- 25-08-13 16:17:02[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046641826629639 -- 25-08-13 16:17:02[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046279430389404 -- 25-08-13 16:17:02[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045928955078125 -- 25-08-13 16:17:02[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014764070510864 -- 25-08-13 16:17:04[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029881000518799 -- 25-08-13 16:17:04[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029969215393066 -- 25-08-13 16:17:04[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029780864715576 -- 25-08-13 16:17:04[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030031204223633 -- 25-08-13 16:17:04[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 90 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029609203338623 -- 25-08-13 16:17:04[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 90 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023723125457764 -- 25-08-13 16:17:05[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050201416015625 -- 25-08-13 16:17:05[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049970149993896 -- 25-08-13 16:17:05[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046901702880859 -- 25-08-13 16:17:05[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050690174102783 -- 25-08-13 16:17:05[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049769878387451 -- 25-08-13 16:17:05[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028466939926147 -- 25-08-13 16:17:25[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=297 SELECT q.quit_id,q.status_id,q.employee_id,e.department_id,e.job_id,q.owner_id,q.appr_proc_id,q.quit_reason_para,q.quit_no, e.employee_name,o.org_name department,j.job_name,q.quit_type_id,q.other_quit_reason,q.quit_reason,q.advision, a_p.appr_proc_name,DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e on e.employee_id = q.employee_id LEFT JOIN dbsys.sys_org o on o.org_id = e.department_id LEFT JOIN dbhr.hr_job j on j.job_id = e.job_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = q.createdby_id LEFT JOIN dbsys.sys_contact UB ON UB.cont_id = q.updatedby_id LEFT JOIN dboa.oa_appr_process a_p ON a_p.appr_proc_id = q.appr_proc_id WHERE q.quit_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038628578186035 -- 25-08-13 16:17:25[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=297 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2273 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024527072906494 -- 25-08-13 16:17:29[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047190189361572 -- 25-08-13 16:17:29[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046839714050293 -- 25-08-13 16:17:29[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046849250793457 -- 25-08-13 16:17:29[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047168731689453 -- 25-08-13 16:17:29[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046560764312744 -- 25-08-13 16:17:29[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029282093048096 -- 25-08-13 16:17:31[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=297 SELECT q.quit_id,q.status_id,q.employee_id,e.department_id,e.job_id,q.owner_id,q.appr_proc_id,q.quit_reason_para,q.quit_no, e.employee_name,o.org_name department,j.job_name,q.quit_type_id,q.other_quit_reason,q.quit_reason,q.advision, a_p.appr_proc_name,DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e on e.employee_id = q.employee_id LEFT JOIN dbsys.sys_org o on o.org_id = e.department_id LEFT JOIN dbhr.hr_job j on j.job_id = e.job_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = q.createdby_id LEFT JOIN dbsys.sys_contact UB ON UB.cont_id = q.updatedby_id LEFT JOIN dboa.oa_appr_process a_p ON a_p.appr_proc_id = q.appr_proc_id WHERE q.quit_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003032922744751 -- 25-08-13 16:17:31[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=297 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2273 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031102895736694 -- 25-08-13 16:17:32[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045421123504639 -- 25-08-13 16:17:32[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045280456542969 -- 25-08-13 16:17:32[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045480728149414 -- 25-08-13 16:17:32[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045320987701416 -- 25-08-13 16:17:32[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2273 AND (apply_date >= now() - interval 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045289993286133 -- 25-08-13 16:17:32[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2273 AND (createdon >= now() - interval 30 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024560928344727 -- 25-08-13 16:20:02[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=297 SELECT q.quit_id,q.status_id,q.employee_id,e.department_id,e.job_id,q.owner_id,q.appr_proc_id,q.quit_reason_para,q.quit_no, e.employee_name,o.org_name department,j.job_name,q.quit_type_id,q.other_quit_reason,q.quit_reason,q.advision, a_p.appr_proc_name,DATE_FORMAT(q.apply_date,'%Y-%m-%d') apply_date,DATE_FORMAT(q.quit_date,'%Y-%m-%d') quit_date FROM dbhr.hr_quit q LEFT JOIN dbhr.hr_employee e on e.employee_id = q.employee_id LEFT JOIN dbsys.sys_org o on o.org_id = e.department_id LEFT JOIN dbhr.hr_job j on j.job_id = e.job_id LEFT JOIN dbsys.sys_contact CB ON CB.cont_id = q.createdby_id LEFT JOIN dbsys.sys_contact UB ON UB.cont_id = q.updatedby_id LEFT JOIN dboa.oa_appr_process a_p ON a_p.appr_proc_id = q.appr_proc_id WHERE q.quit_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004647970199585 -- 25-08-13 16:20:02[桂丽-2273] -- /buz/hr/index.php/hrmgmt/hr_quit?event=edit_quit&quit_id=297 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2273 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019499063491821 -- 25-08-13 17:08:12 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023216009140015 -- 25-08-13 17:08:14[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050029754638672 -- 25-08-13 17:08:14[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049741268157959 -- 25-08-13 17:08:14[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2275 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049340724945068 -- 25-08-13 17:08:14[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049190521240234 -- 25-08-13 17:08:14[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048959255218506 -- 25-08-13 17:08:14[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2275 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020678997039795 -- 25-08-13 17:08:54[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044190883636475 -- 25-08-13 17:08:54[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043940544128418 -- 25-08-13 17:08:54[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2275 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044031143188477 -- 25-08-13 17:08:54[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043818950653076 -- 25-08-13 17:08:54[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044150352478027 -- 25-08-13 17:08:54[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2275 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023061037063599 -- 25-08-13 17:09:00[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '5' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055241584777832 -- 25-08-13 17:09:00[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 5 AND c.cont_id = 2275 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005073070526123 -- 25-08-13 17:09:00[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=1 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 335 and acct_id = 5 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019075870513916 -- 25-08-13 17:10:49[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2275 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017760992050171 -- 25-08-13 17:11:00[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038769245147705 -- 25-08-13 17:11:00[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038490295410156 -- 25-08-13 17:11:00[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2275 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038399696350098 -- 25-08-13 17:11:00[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037879943847656 -- 25-08-13 17:11:00[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2275 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037829875946045 -- 25-08-13 17:11:00[廖嘉政-2275] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2275 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018615007400513 -- 25-08-13 17:39:38[廖天伦-2150] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para=%7B%22event%22:%22edit_turnfull%22,%22turnfull_id%22:%22255%22%7D&event=edit_turnfull&turnfull_id=255 SELECT tf.turnfull_id,tf.turnfull_no,tf.owner_id,tf.status_id,tf.employee_id,tf.employee_name,tf.employee_no,tf.department_id, DATE_FORMAT(tf.entry_time,'%Y-%m-%d') entry_time,tf.createdon,tf.updatedon,tf.trial_job_id,tf.trial_salary,tf.firstMonth_assess, tf.secondMonth_assess,tf.thirdMonth_assess,tf.trial_goodresult,tf.trial_ability,tf.brief_summary,tf.self_evaluation, DATE_FORMAT(tf.apply_date,'%Y-%m-%d') apply_date,tf.appr_proc_id,tf.cur_appr_id_str,org.org_name department, apro.appr_proc_name,job.job_name trial_job,IFNULL(DATE_FORMAT(tf.effective_date,'%Y-%m-%d'),'') effective_date, IFNULL(turnfull_job.job_name,'') turnfull_job,IFNULL(tf.turnfull_salary,'') turnfull_salary FROM dbhr.hr_turnfull tf LEFT JOIN dboa.oa_appr_process apro ON tf.appr_proc_id = apro.appr_proc_id LEFT JOIN dbhr.hr_job job ON tf.trial_job_id = job.job_id LEFT JOIN dbhr.hr_job turnfull_job ON tf.turnfull_job_id = turnfull_job.job_id LEFT JOIN dbsys.sys_org org ON tf.department_id = org.org_id WHERE tf.turnfull_id = 255 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033519268035889 -- 25-08-13 17:39:38[廖天伦-2150] -- /buz/hr/index.php/hrmgmt/hr_turnfull?para=%7B%22event%22:%22edit_turnfull%22,%22turnfull_id%22:%22255%22%7D&event=edit_turnfull&turnfull_id=255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2150 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017143964767456 -- 25-08-13 18:40:45 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022011041641235 -- 25-08-13 18:40:46[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047321319580078 -- 25-08-13 18:40:46[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047369003295898 -- 25-08-13 18:40:46[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048348903656006 -- 25-08-13 18:40:46[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046720504760742 -- 25-08-13 18:40:46[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046920776367188 -- 25-08-13 18:40:46[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02026104927063 -- 25-08-13 18:40:50[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049660205841064 -- 25-08-13 18:40:50[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 15 AND c.cont_id = 2180 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045309066772461 -- 25-08-13 18:40:50[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022205114364624 -- 25-08-13 18:46:20[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2180 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017555952072144 -- 25-08-13 18:46:25[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038039684295654 -- 25-08-13 18:46:25[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037779808044434 -- 25-08-13 18:46:25[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035891532897949 -- 25-08-13 18:46:25[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037682056427002 -- 25-08-13 18:46:25[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2180 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038020610809326 -- 25-08-13 18:46:25[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2180 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01792311668396 -- 25-08-13 18:46:27[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043590068817139 -- 25-08-13 18:46:27[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 15 AND c.cont_id = 2180 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044140815734863 -- 25-08-13 18:46:27[林雅楠-2180] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018071174621582 -- 25-08-13 18:57:50 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021144151687622 -- 25-08-13 18:57:56[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045759677886963 -- 25-08-13 18:57:56[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045859813690186 -- 25-08-13 18:57:56[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050990581512451 -- 25-08-13 18:57:56[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045170783996582 -- 25-08-13 18:57:56[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045890808105469 -- 25-08-13 18:57:56[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016749858856201 -- 25-08-13 18:57:58[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041780471801758 -- 25-08-13 18:57:58[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 15 AND c.cont_id = 498 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040609836578369 -- 25-08-13 18:57:58[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021554946899414 -- 25-08-13 18:58:17[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 498 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021000862121582 -- 25-08-13 18:58:22[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041961669921875 -- 25-08-13 18:58:22[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041959285736084 -- 25-08-13 18:58:22[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043718814849854 -- 25-08-13 18:58:22[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041708946228027 -- 25-08-13 18:58:22[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 498 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041689872741699 -- 25-08-13 18:58:22[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 498 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022218942642212 -- 25-08-13 18:58:23[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049009323120117 -- 25-08-13 18:58:23[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 15 AND c.cont_id = 498 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050621032714844 -- 25-08-13 18:58:23[高蓉-498] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01955509185791 -- 25-08-13 19:19:25 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039029121398926 -- 25-08-13 19:19:25 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043570995330811 -- 25-08-13 19:19:25 -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='TangZiJi' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041770935058594 -- 25-08-13 19:19:25[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?appid=ww5262fb147810c303&agentid=1000013 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018162965774536 -- 25-08-13 19:19:26[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040390491485596 -- 25-08-13 19:19:26[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039899349212646 -- 25-08-13 19:19:26[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2005 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036671161651611 -- 25-08-13 19:19:26[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039670467376709 -- 25-08-13 19:19:26[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039379596710205 -- 25-08-13 19:19:26[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2005 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018478155136108 -- 25-08-13 19:19:30[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT DATE_FORMAT(rest_date,'%Y-%m-%d') rest_date FROM dbsys.sys_restschedule WHERE rest_date > 0 and acct_id = '15' AND DATE_FORMAT(rest_date,'%Y') > 2024 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044271945953369 -- 25-08-13 19:19:30[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 SELECT e.employee_id,e.employee_name,e.department_id,depart.org_name department,e.job_id,j.job_name,e.adjustLeave_leftDays,e.annualLeave_leftDays FROM dbsys.`sys_contact` c left join dbhr.hr_employee e ON c.`employee_id` = e.employee_id LEFT JOIN dbsys.sys_org depart ON depart.org_id = e.department_id LEFT JOIN dbhr.hr_job j ON j.job_id = e.job_id WHERE c.acct_id = 15 AND c.cont_id = 2005 AND c.`cont_name`=e.employee_name and e.onjob_status_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045421123504639 -- 25-08-13 19:19:30[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=edit_offwork&offwork_type_id=5 select appr_proc_id,appr_proc_name from dboa.oa_appr_process where org_id = 181 and acct_id = 15 AND is_enable = 1 AND appr_type_id = 8 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019279956817627 -- 25-08-13 19:19:47[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_offwork?event=save_offwork select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2005 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0224609375 -- 25-08-13 19:19:52[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT recruitApply_id apply_id,recruitApply_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,5 as appr_type FROM dbhr.hr_recruitapply WHERE createdby_id = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048260688781738 -- 25-08-13 19:19:52[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT turnfull_id apply_id,turnfull_no apply_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,6 as appr_type FROM dbhr.hr_turnfull WHERE createdby_id = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047628879547119 -- 25-08-13 19:19:52[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT change_id apply_id,change_no apply_no,status_id,change_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,7 as appr_type FROM dbhr.hr_change WHERE createdby_id = 2005 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048649311065674 -- 25-08-13 19:19:52[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT offwork_id apply_id,offwork_no apply_no,status_id,offwork_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,8 as appr_type FROM dbhr.hr_offwork WHERE createdby_id = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047650337219238 -- 25-08-13 19:19:52[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT quit_id apply_id,quit_no apply_no,status_id,quit_type_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,9 as appr_type FROM dbhr.hr_quit WHERE createdby_id = 2005 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047609806060791 -- 25-08-13 19:19:52[唐梓基-2005] -- /buz/hr/index.php/hrmgmt/hr_application_list?event=query SELECT fired_id apply_id,fired_no apply_no,status_id,fired_type_id,DATE_FORMAT(createdon,'%Y-%m-%d') apply_date,10 as appr_type FROM dbhr.hr_fired WHERE createdby_id = 2005 AND (createdon >= now() - interval 7 day) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------