mode_officicAction.php 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. <?php
  2. /**
  3. * 此文件是流程模块【officic.公文查阅】对应控制器接口文件。
  4. */
  5. class mode_officicClassAction extends inputAction{
  6. public function storeafter($table, $rows)
  7. {
  8. return array(
  9. 'isadd' => false
  10. );
  11. }
  12. //统计
  13. public function tongjiDataAjax()
  14. {
  15. $columns = $rows = array();
  16. $dtobj = c('date');
  17. $startdt = $this->post('startdt', $this->date);
  18. $enddt = $this->post('enddt');
  19. if($enddt=='')$enddt = $dtobj->adddate($startdt,'d',7);
  20. $jg = $dtobj->datediff('d',$startdt, $enddt);
  21. if($jg>30)$jg = 30;
  22. $atype = $this->post('atype');
  23. $where = ' and `uid`='.$this->adminid.'';
  24. if($atype=='all')$where='';
  25. $darr = $this->db->getall("SELECT type,applydt,count(1)as stotal FROM `[Q]official` where `status`=1 and `applydt` between '$startdt' and '$enddt' $where group by type,applydt;");
  26. $carr = array();
  27. foreach($darr as $k=>$rs){
  28. $carr[$rs['applydt']][$rs['type']] = floatval($rs['stotal']);
  29. }
  30. $dt = $startdt;
  31. $fwshuz = $swshuz = 0;
  32. for($i=0; $i<=$jg; $i++){
  33. $fwshu = $swshu = 0;
  34. if($i>0)$dt = $dtobj->adddate($dt,'d',1);
  35. $w = $dtobj->cnweek($dt);
  36. $sbarr = array(
  37. 'dt' => $dt,
  38. 'week' => $w,
  39. );
  40. if(isset($carr[$dt]) && isset($carr[$dt][0]))$fwshu = $carr[$dt][0];
  41. if(isset($carr[$dt]) && isset($carr[$dt][1]))$swshu = $carr[$dt][1];
  42. if($fwshu>0)$sbarr['fwshu'] = $fwshu;
  43. if($swshu>0)$sbarr['swshu'] = $swshu;
  44. $fwshuz+=$fwshu;
  45. $swshuz+=$swshu;
  46. $rows[] = $sbarr;
  47. }
  48. $sbarr = array(
  49. 'dt' => '合计',
  50. 'fwshu' => $fwshuz,
  51. 'swshu' => $swshuz,
  52. );
  53. $rows[] = $sbarr;
  54. return array(
  55. 'rows' => $rows,
  56. 'columns' => $columns,
  57. 'startdt' => $startdt,
  58. 'enddt' => $enddt,
  59. 'totalCount' => count($rows),
  60. 'downCount' => count($rows),
  61. );
  62. }
  63. }
粤ICP备19079148号