kqtotalModel.php 1.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. <?php
  2. /**
  3. * 考勤统计
  4. */
  5. class agent_kqtotalClassModel extends agentModel
  6. {
  7. protected function agentdata($uid, $lx)
  8. {
  9. $key = $this->rock->post('key');
  10. $month = date('Y-m');
  11. if($lx=='mylast' || $lx=='downlast')$month = c('date')->adddate($month.'-01','m', -1,'Y-m');
  12. $mdts = m('kaoqin');
  13. $drows = $rows = array();
  14. if(contain($lx,'down') || !isempt($key)){
  15. $whre1 = $mdts->admindb->monthuwhere($month);
  16. $where = $mdts->admindb->getdowns($uid, 1).$whre1;
  17. if(!isempt($key))$where.=$mdts->admindb->getkeywhere($key);
  18. $drows = $mdts->admindb->getrows($where, '`id`,`name`,`workdate`,`quitdt`','`sort`');
  19. }else{
  20. $drows[]= array('id'=>$uid,'name'=>'我');
  21. }
  22. foreach($drows as $k=>$rs){
  23. $cont = '';
  24. $rwnk = $this->rock->arrvalue($rs, 'workdate');
  25. if(!isempt($rwnk))$cont.='<font color=#888888>入职日期:</font>'.$rwnk.'<br>';
  26. $rwnk = $this->rock->arrvalue($rs, 'quitdt');
  27. if(!isempt($rwnk))$cont.='<font color=#888888>离职日期:</font>'.$rwnk.'<br>';
  28. $carr = $mdts->alltotal($month, $rs['id']);
  29. foreach($carr['fields'] as $k=>$v){
  30. $v1 = $this->rock->arrvalue($carr['data'], $v);
  31. $u1 = $this->rock->arrvalue($carr['unita'], $v,'次');
  32. if(!isempt($v1)){
  33. $cont.='<font color=#888888>'.$k.':</font>'.$v1.'('.$u1.')<br>';
  34. }
  35. }
  36. $rows[] = array(
  37. 'title' => ''.$rs['name'].'['.$month.']统计',
  38. 'cont' => $cont,
  39. 'month' => $month,
  40. 'uid' => $rs['id']
  41. );
  42. }
  43. $arr['rows'] = $rows;
  44. return $arr;
  45. }
  46. }
粤ICP备19079148号