Cron.php 9.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229
  1. <?php
  2. namespace Work\Lib;
  3. use Dever;
  4. Class Cron
  5. {
  6. #工单日统计
  7. public function index_api(){
  8. $title = '工单每日统计';
  9. $data = Dever::db('work/branch')->state(array('type'=>1));
  10. foreach ($data as $k => $v) {
  11. $group_id = explode(',',$v['group']);
  12. $admin = Dever::db('manage/admin')->find($group_id[1]);
  13. $content = $this->email_api($v,$admin);
  14. if ($content) {
  15. $this->send($admin['email'], $admin['username'], $title, $content);
  16. }
  17. }
  18. }
  19. public function test_api(){
  20. $title = '工单每日统计';
  21. $data = Dever::db('work/branch')->state(array('type'=>1));
  22. foreach ($data as $k => $v) {
  23. $group_id = explode(',',$v['group']);
  24. $admin = Dever::db('manage/admin')->find($group_id[1]);
  25. $content = $this->email_api($v,$admin);
  26. if ($content) {
  27. $this->send('1849506057@qq.com', $admin['username'], $title, $content);
  28. }
  29. }
  30. }
  31. #发送邮件
  32. public function email_api($v,$fsadmin)
  33. {
  34. $start=mktime(0,0,0,date('m'),date('d'),date('Y'))-86400;
  35. $end = $start+86400-1;
  36. $config = Dever::db('work/info')->config['config_status'];
  37. $dbranch = $v;
  38. $question = Dever::db('work/question')->state(array('branch_id'=>$dbranch['group_id']));
  39. $question = array_keys($question);
  40. $data['info']['app'] = Dever::db('work/info')->getCount(array('question'=>$question,'start'=>$start,'end'=>$end));
  41. // echo Dever::sql();
  42. $data['info']['xu'] = Dever::db('work/info')->getCount(array('group'=>$dbranch['group_id'],'start'=>$start,'end'=>$end,'status'=>2));
  43. $admin = explode(',',$dbranch['group']);
  44. if ($dbranch['coor']) {
  45. $coor = explode(',',$dbranch['coor']);
  46. if (isset($coor) && $coor[0] && $coor[0] >0) {
  47. $people = $dbranch['coor'].','.$admin[1];
  48. } else {
  49. $people = $admin[1];
  50. }
  51. } else {
  52. $people = $admin[1];
  53. }
  54. $data['info']['yi'] = Dever::db('work/info')->getCount(array('fpeople'=>$people,'start'=>$start,'end'=>$end,'status'=>'3,4'));
  55. $data['question'] = Dever::db('work/question')->getAll(array('branch_id'=>$dbranch['group_id']));
  56. $question = implode(',',$question);
  57. if ($question) {
  58. $data['app'] = Dever::db('work/info')->fetchAll('select * from churen_work_info where (`group` in ('.$dbranch['group_id'].') or fpeople in ('.$people.') or question in ('.$question.')) and cdate>='.$start.' and cdate <='.$end.' and state = 1');
  59. foreach ($data['app'] as $k1 => $v1) {
  60. $data['app'][$k1]['cdate'] = date('Y-m-d H:i:s',$v1['cdate']);
  61. if ($v1['zdate']) {
  62. $data['app'][$k1]['zhipai'] = date('Y-m-d H:i:s',$v1['zdate']).'<br/>'.date('Y-m-d H:i:s',$v1['chdate']);
  63. } else {
  64. $data['app'][$k1]['zhipai'] = date('Y-m-d H:i:s',$v1['chdate']);
  65. }
  66. // $data['app'][$k1]['chu'] = date('Y-m-d H:i:s',$v1['chdate']);
  67. $cate = Dever::db('work/q_cate')->find($v1['cate_id']);
  68. $data['app'][$k1]['cate_name'] = $cate['name'];
  69. $priority = Dever::db('work/priority')->find($v1['priority_id']);
  70. $data['app'][$k1]['priority_name'] = $priority['name'];
  71. $data['app'][$k1]['status']= Dever::status($config,$v1['status']);
  72. }
  73. }
  74. $msg = array();
  75. $msg['admin_email'] = $fsadmin['email'];
  76. $msg['admin_username'] = $fsadmin['username'];
  77. $msg['app'] = $data['info']['app'];
  78. $msg['xu'] = $data['info']['xu'];
  79. $msg['yi'] = $data['info']['yi'];
  80. $res = Dever::log($msg, 'work');
  81. return Dever::render('email', $data);
  82. }
  83. #代理商统计发送邮件
  84. public function send($email, $username, $title, $content)
  85. {
  86. $config = Dever::config('base', 'project')->email;
  87. Dever::apply('src/PHPMailer', 'email');
  88. Dever::apply('src/Exception', 'email');
  89. Dever::apply('src/SMTP', 'email');
  90. $mail = new \PHPMailer\PHPMailer\PHPMailer();
  91. $mail->isSMTP();
  92. //$mail->SMTPDebug = 2;
  93. $mail->CharSet = 'UTF-8';
  94. $mail->Host = $config['smtp'];
  95. $mail->Port = 465;
  96. $mail->SMTPSecure = 'ssl';
  97. $mail->SMTPAuth = true;
  98. $mail->Username = $config['username'];
  99. $mail->Password = $config['password'];
  100. $mail->setFrom($config['from'][0], '统计');
  101. $mail->addAddress($email, $username);
  102. $mail->Subject = "=?utf-8?B?" . base64_encode($title) . "?=";
  103. $mail->Body = $content;
  104. $mail->isHTML(true);
  105. //$mail->addAttachment($file);
  106. if (!$mail->send()) {
  107. Dever::alert("Mailer Error: " . $mail->ErrorInfo);
  108. } else {
  109. return 'ok';
  110. }
  111. }
  112. #同步info表中的product
  113. public function product_api()
  114. {
  115. $data = Dever::db('work/info')->state();
  116. if ($data) {
  117. foreach ($data as $k => $v) {
  118. if (!$v['product'] || $v['product']<=0) {
  119. $cate = explode(',',$v['cate_id']);
  120. if (isset($cate[1]) && $cate[1]) {
  121. $product = Dever::db('work/question')->find($cate[1]);
  122. if ($product) {
  123. $where['where_id'] = $v['id'];
  124. $where['product'] = $product['product_id'];
  125. Dever::db('work/info')->update($where);
  126. }
  127. }
  128. }
  129. }
  130. }
  131. }
  132. public function updateTime_api()
  133. {
  134. $data = Dever::db('work/info')->state();
  135. foreach ($data as $k => $v) {
  136. if (!$v['fpeople'] && ($v['status'] == 3 || $v['status'] == 4)) {
  137. $app = Dever::db('work/appoint')->getAdmin(array('info_id'=>$v['id'],'admin'=>$v['audit_admin']));
  138. if ($app && $app['admin']) {
  139. $update['fpeople'] = $app['admin'];
  140. } else {
  141. if ($v['branch_id']) {
  142. $branch = explode(',',$v['branch_id']);
  143. if (isset($branch[1]) && $branch[1]) {
  144. $update['fpeople'] = $branch[1];
  145. }
  146. } else {
  147. $update['fpeople'] = $v['audit_admin'];
  148. }
  149. }
  150. $update['where_id'] = $v['id'];
  151. Dever::db('work/info')->update($update);
  152. }
  153. }
  154. }
  155. public function user_api()
  156. {
  157. $num = Dever::input('num', 1);
  158. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  159. $end = Dever::input('end', date('Y-m-d'));
  160. $start = Dever::maketime($start . ' 00:00:00');
  161. $end = Dever::maketime($end . ' 23:59:59');
  162. $day = intval(($end - $start)/86400);
  163. for($i=0; $i<=$day; $i++) {
  164. $where['start'] = $start + 86400*$i;
  165. $where['end'] = $start + 86400*$i + 86399;
  166. $where['priority_id'] = '';
  167. $cate = Dever::db('work/q_cate')->state();
  168. foreach ($cate as $k =>$v) {
  169. $where['cate'] = $v['id'];
  170. unset($where['priority_id']);
  171. $num = Dever::db('work/info')->getNum($where);
  172. if ($num <= 0) {
  173. continue;
  174. }
  175. $data = array();
  176. $data['cate'] = $where['cate'];
  177. $data['day'] = $where['start'];
  178. $info = Dever::db('work/info_stat')->find($data);
  179. $data['question'] = $num;
  180. $where['priority_id'] = 4;
  181. $data['super'] = Dever::db('work/info')->getNum($where);
  182. $where['priority_id'] = 3;
  183. $data['urgent'] = Dever::db('work/info')->getNum($where);
  184. $where['priority_id'] = 2;
  185. $data['yb'] = Dever::db('work/info')->getNum($where);
  186. $where['priority_id'] = 1;
  187. $data['pt'] = Dever::db('work/info')->getNum($where);
  188. // echo dever::sql();
  189. // print_r($data);
  190. if (!$info) {
  191. Dever::db('work/info_stat')->insert($data);
  192. } else {
  193. $data['where_id'] = $info['id'];
  194. Dever::db('work/info_stat')->update($data);
  195. }
  196. }
  197. }
  198. return 'ok';
  199. }
  200. #修改info表中的问题分类
  201. public function updateCate_api()
  202. {
  203. $data = Dever::db('work/info')->state();
  204. foreach ($data as $k => $v) {
  205. if (!$v['cate'] || $v['cate']<=0) {
  206. if ($v['cate_id']) {
  207. $cate_id = explode(',',$v['cate_id']);
  208. $where['where_id'] = $v['id'];
  209. $where['cate'] = $cate_id[0];
  210. Dever::db('work/info')->update($where);
  211. }
  212. }
  213. }
  214. }
  215. }