Cron.php 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. <?php
  2. namespace Clue\Lib;
  3. use Dever;
  4. Class Cron
  5. {
  6. public function stat_api()
  7. {
  8. $start=mktime(0,0,0,date('m'),date('d'),date('Y'));
  9. $end = $start+86400-1;
  10. $data = Dever::db('work/branch')->state();
  11. foreach ($data as $k => $v) {
  12. $w['follow_group_id'] = $v['group_id'];
  13. $w['start'] = $start;
  14. $w['end'] = $end;
  15. $where['group_id'] = $v['group_id'];
  16. $where['day'] = $start;
  17. // $cy = Dever::db('clue/info_log')->getCountAll($w);
  18. $info = Dever::db('clue/info')->getAll($w);
  19. $create = Dever::db('clue/info')->getAll(array('start'=>$start,'end'=>$end,'create_group_id'=>$v['group_id']));
  20. $cinfo = array_merge($info,$create);
  21. $rest = array();
  22. foreach ($cinfo as $k1 =>$v1) {
  23. $rest[$v1['id']]=$v1;
  24. }
  25. $where['group_num'] = count($rest);
  26. $w['type'] = '1,2,3,4,5';
  27. $where['num'] = Dever::db('clue/info')->getHAll($w);
  28. $w['type'] = 1;
  29. $where['d_num'] = Dever::db('clue/info')->getHAll($w);
  30. $w['type'] = 2;
  31. $where['dg_num'] = Dever::db('clue/info')->getHAll($w);
  32. $w['type'] = 3;
  33. $w['gstart'] = $start;
  34. $w['gend'] = $end;
  35. $where['g_num'] = Dever::db('clue/info')->getHAll($w);
  36. $w['type'] = 5;
  37. $where['qx_num'] = Dever::db('clue/info')->getHAll($w);
  38. $w['type'] = 4;
  39. $where['f_num'] = Dever::db('clue/info')->getHAll($w);
  40. $res = Dever::db('clue/info_stat')->find(array('group_id'=>$v['group_id'],'day'=>$start,'clear'=>true));
  41. $where['clear'] = true;
  42. if ($res) {
  43. $where['where_id'] = $res['id'];
  44. Dever::db('clue/info_stat')->update($where);
  45. } else{
  46. Dever::db('clue/info_stat')->insert($where);
  47. }
  48. // print_R($where);die;
  49. // $data[''] = Dever::db('clue/info')->
  50. }
  51. }
  52. }