minutes.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851
  1. <?php
  2. /**
  3. * 任务计划 - 分钟执行的任务
  4. *
  5. *
  6. *
  7. *
  8. */
  9. defined('InShopNC') or exit('Access Invalid!');
  10. require_once (BASE_ROOT_PATH . '/helper/message/publisher.php');
  11. require_once(BASE_HELPER_PATH . '/refill/util.php');
  12. require_once(BASE_HELPER_PATH . '/refill/divert_account.php');
  13. require_once(BASE_HELPER_PATH . '/refill/RefillFactory.php');
  14. require_once(BASE_CORE_PATH . '/framework/function/http.php');
  15. require_once(BASE_HELPER_PATH . '/PHPExcel/PHPExcel.php');
  16. require_once(BASE_HELPER_PATH . '/task/task_helper.php');
  17. class minutesControl extends BaseCronControl
  18. {
  19. public function indexexOp()
  20. {
  21. $this->_cron_common([1,2,3,4,5,6,7]);
  22. }
  23. public function indexOp()
  24. {
  25. Log::record(__FUNCTION__ . " start",Log::DEBUG);
  26. //未付款订单超期自动关闭
  27. // $this->_order_timeout_cancel();
  28. $this->_cron_common([1,2,3,4,5,6,7]);
  29. $this->_fetch_order_unavaliable();
  30. $this->_check_merchant_alarm_amount();
  31. Log::record(__FUNCTION__ . " end",Log::DEBUG);
  32. // $this->_web_index_update();
  33. // $this->_check_merchant_alarm_amount();
  34. // $this->check_refill_order_limit();
  35. // $this->_cron_mail_send();
  36. // $this->_SendOrderQuery();
  37. }
  38. public function update_channel_balanceOp()
  39. {
  40. $balance_getter = function ($provider_id)
  41. {
  42. $provider_model = Model('refill_provider');
  43. $provider_info = $provider_model->getProviderInfo(['provider_id' => $provider_id, 'opened' => 1]);
  44. if (empty($provider_info)) {
  45. return false;
  46. }
  47. $channel_name = $provider_info['name'];
  48. if ($provider_info['type'] == 1) {
  49. $type = 'RefillOil';
  50. } elseif ($provider_info['type'] == 2 || $provider_info['type'] == 3) {
  51. $type = 'RefillPhone';
  52. } else {
  53. $type = 'RefillPhone';
  54. }
  55. Log::record("query balance channel_name:{$channel_name}",Log::DEBUG);
  56. $provider = refill\util::getProvider($channel_name,$type);
  57. if($provider == false) return false;
  58. [$state, $balance] = $provider->balance();
  59. Log::record("query balance channel_name:{$channel_name}, err_msg:{$balance}",Log::DEBUG);
  60. if(!$state) {
  61. return false;
  62. } else {
  63. return round(floatval($balance),4);
  64. }
  65. };
  66. $providers = function ()
  67. {
  68. $pids = [];
  69. $i = 0;
  70. while (true)
  71. {
  72. $start = $i * 1000;
  73. $items = Model()->table('refill_provider')->where(['opened' => 1])->field('*')->order('provider_id desc')->limit("{$start},1000")->select();
  74. if(empty($items)) {
  75. return $pids;
  76. }
  77. $i++;
  78. foreach ($items as $item) {
  79. $pid = intval($item['provider_id']);
  80. $pids[] = $pid;
  81. }
  82. }
  83. };
  84. $mod_provider = Model('refill_provider');
  85. $pids = $providers();
  86. foreach ($pids as $pid)
  87. {
  88. try {
  89. $balance = $balance_getter($pid);
  90. if($balance !== false) {
  91. $mod_provider->editProvider(['balance' => $balance],['provider_id' => $pid]);
  92. }
  93. }
  94. catch (Exception $ex)
  95. {
  96. Log::record($ex->getMessage(),Log::ERR);
  97. }
  98. }
  99. }
  100. private function _fetch_order_unavaliable()
  101. {
  102. try {
  103. $mod_fetch_order = Model('fetch_order');
  104. $trans = new trans_wapper($mod_fetch_order,__METHOD__);
  105. $items = $mod_fetch_order->timeout_orders(900);
  106. foreach ($items as $item) {
  107. $fetch_id = $item['fetch_id'];
  108. $mod_fetch_order->unavaliable($fetch_id);
  109. }
  110. $trans->commit();
  111. foreach ($items as $item) {
  112. $order_sn = $item['order_sn'];
  113. $chname = $item['channel_name'];
  114. refill\util::push_notify($chname,['order_sn' => $order_sn,'state' => 'CANCEL']);
  115. }
  116. }
  117. catch (Exception $ex) {
  118. $trans->rollback();
  119. Log::record(__METHOD__ . " " . $ex->getMessage(),Log::ERR);
  120. }
  121. }
  122. private function _check_merchant_alarm_amount()
  123. {
  124. if(defined('COMPANY_NAME') && COMPANY_NAME === 'XYZ_COMPANY')
  125. {
  126. $mch_cache = rcache("merchant-notify" , 'refill-');
  127. $caches = empty($mch_cache['data']) ? [] : unserialize($mch_cache['data']);
  128. $new_caches = [];
  129. $merchants = Model('merchant')->getMerchantList(['merchant.merchant_state'=>1],'','',true,'merchant.*,member.available_predeposit' ,"0,1000");
  130. foreach ($merchants as $merchant)
  131. {
  132. $mchid = $merchant['mchid'];
  133. $phones = empty($merchant['warning_phone']) ? [] : unserialize($merchant['warning_phone']);
  134. $available_pd = intval($merchant['available_predeposit']);
  135. $alarm_pd = intval($merchant['alarm_amount']);
  136. if(array_key_exists($mchid,$caches)) {
  137. $mch_cache = $caches[$mchid];
  138. }
  139. else {
  140. $mch_cache = ['last_time' => 0, 'send_count' => 0];
  141. }
  142. if($available_pd < $alarm_pd || $available_pd < 10000)
  143. {
  144. $counts = $mch_cache['send_count'];
  145. if(($mch_cache['last_time'] + 300 < time()) && $counts < 2) {
  146. $mch_cache = ['last_time' => time(), 'send_count' => $counts + 1];
  147. foreach ($phones as $phone) {
  148. if(!empty($phone)){
  149. QueueClient::push('sendSMS', ['mobile'=>$phone,
  150. 'type'=>'balance_warning','datas' => [date("m月d日H时") , $merchant['available_predeposit']]]);
  151. }
  152. }
  153. }
  154. }
  155. else {
  156. $mch_cache = ['last_time' => 0, 'send_count' => 0];
  157. }
  158. $new_caches[$mchid] = $mch_cache;
  159. }
  160. wcache("merchant-notify", ['data' => serialize($new_caches)], 'refill-');
  161. }
  162. }
  163. public function check_refill_order_limit()
  164. {
  165. $mch_cache = rcache("storge_limit" , 'merchant-');
  166. $caches = empty($mch_cache['data']) ? [] : unserialize($mch_cache['data']);
  167. $reader = function ($mchid,$time)
  168. {
  169. $cond['mchid'] = $mchid;
  170. $cond['inner_status'] = 0;
  171. $cond['order_state'] = ORDER_STATE_SUCCESS;
  172. $cond['refill_order.order_time'] = ['egt', $time];
  173. $items = Model('')->table('refill_order,vr_order')->join('inner')
  174. ->on('refill_order.order_id=vr_order.order_id')
  175. ->field('refill_order.mchid,refill_order.card_type,refill_order.refill_amount,count(*) as num')
  176. ->group('refill_order.card_type,refill_order.refill_amount')
  177. ->where($cond)->select();
  178. return $items;
  179. };
  180. $merger = function ($limits,$reals,$mchid,$card_type)
  181. {
  182. $result = [];
  183. foreach ($limits as $amount => $limit)
  184. {
  185. $limit = intval($limit);
  186. if($limit === -1) {
  187. $allow = true;
  188. }
  189. elseif($limit === 0) {
  190. $allow = false;
  191. }
  192. else
  193. {
  194. $finded = false;
  195. foreach ($reals as $item)
  196. {
  197. $tmp = intval($item['refill_amount'] + 0.005);
  198. if($item['card_type'] == $card_type && $tmp == $amount) {
  199. $num = $item['num'];
  200. $allow = $limit > $num;
  201. $finded = true;
  202. break;
  203. }
  204. }
  205. if(!$finded) {
  206. $allow = true;
  207. }
  208. }
  209. $result["{$mchid}-{$card_type}-{$amount}"] = $allow;
  210. }
  211. return $result;
  212. };
  213. $type_map = ['petrochina' => 1,'sinopec' => 2];
  214. $abilitys = [];
  215. foreach ($caches as $cache)
  216. {
  217. $mchid = intval($cache['mchid']);
  218. $start = $cache['time'];
  219. $petros = $cache['petrochina'];
  220. $sinos = $cache['sinopec'];
  221. $items = $reader($mchid,$start);
  222. $prets = $merger($petros,$items,$mchid,$type_map['petrochina']);
  223. $srets = $merger($sinos,$items,$mchid,$type_map['sinopec']);
  224. foreach ($prets as $key => $val) {
  225. $abilitys[$key] = $val;
  226. }
  227. foreach ($srets as $key => $val) {
  228. $abilitys[$key] = $val;
  229. }
  230. }
  231. $old = rcache("refill_able",'merchant-');
  232. $old = empty($old) ? "" : $old['data'];
  233. ksort($abilitys);
  234. $new = serialize($abilitys);
  235. if($new != $old) {
  236. wcache("refill_able" , ['data' => $new] , 'merchant-');
  237. // $publisher = new message\publisher();
  238. // $publisher->modify_refill_merchant();
  239. }
  240. }
  241. /**
  242. * 未付款订单超期自动关闭
  243. */
  244. private function _order_timeout_cancel()
  245. {
  246. Log::record(__FUNCTION__,Log::DEBUG);
  247. //实物订单超期未支付系统自动关闭
  248. $_break = false;
  249. $model_order = Model('order');
  250. $logic_order = Logic('order');
  251. $condition = [];
  252. $condition['order_state'] = ORDER_STATE_NEW;
  253. $condition['add_time'] = ['lt',time() - ORDER_AUTO_CANCEL_DAY * 86400];
  254. //分批,每批处理100个订单,最多处理5W个订单
  255. for ($i = 0; $i < 500; $i++)
  256. {
  257. if ($_break) {
  258. break;
  259. }
  260. $order_list = $model_order->getOrderList($condition, '', '*', '', 100);
  261. if (empty($order_list)) break;
  262. foreach ($order_list as $order_info)
  263. {
  264. Log::record("1",Log::DEBUG);
  265. $result = $logic_order->changeOrderStateCancel($order_info,'system','系统','超期未支付系统自动关闭订单',true,false);
  266. Log::record("2",Log::DEBUG);
  267. if (!$result['state']) {
  268. $this->log('实物订单超期未支付关闭失败SN:'.$order_info['order_sn']); $_break = true; break;
  269. } else {
  270. Log::record("3",Log::DEBUG);
  271. account_helper::onPredeposit('order_cancel',$order_info['buyer_id'],$order_info['order_sn']);
  272. Log::record("4",Log::DEBUG);
  273. }
  274. }
  275. }
  276. //虚拟订单超期未支付系统自动关闭
  277. $_break = false;
  278. $model_vr_order = Model('vr_order');
  279. $logic_vr_order = Logic('vr_order');
  280. $condition = [];
  281. $condition['order_state'] = ORDER_STATE_NEW;
  282. $condition['add_time'] = ['lt',time() - VRORDER_AUTO_CANCEL_MINUTE * 60];
  283. //分批,每批处理100个订单,最多处理5W个订单
  284. for ($i = 0; $i < 500; $i++)
  285. {
  286. if ($_break) {
  287. break;
  288. }
  289. $order_list = $model_vr_order->getOrderList($condition, '', '*', '',100);
  290. if (empty($order_list)) break;
  291. foreach ($order_list as $order_info) {
  292. $result = $logic_vr_order->changeOrderStateCancel($order_info,'system','超期未支付系统自动关闭订单',false);
  293. }
  294. if (!$result['state']) {
  295. $this->log('虚拟订单超期未支付关闭失败SN:'.$order_info['order_sn']);
  296. $_break = true;
  297. }
  298. }
  299. }
  300. /**
  301. * 更新首页的商品价格信息
  302. */
  303. private function _web_index_update()
  304. {
  305. Model('web_config')->updateWebGoods();
  306. }
  307. /**
  308. * 发送邮件消息
  309. */
  310. private function _cron_mail_send()
  311. {
  312. //每次发送数量
  313. $_num = 50;
  314. $model_storemsgcron = Model('mail_cron');
  315. $cron_array = $model_storemsgcron->getMailCronList([], $_num);
  316. if (!empty($cron_array))
  317. {
  318. $email = new Email();
  319. $mail_array = [];
  320. foreach ($cron_array as $val)
  321. {
  322. $return = $email->send_sys_email($val['mail'],$val['subject'],$val['contnet']);
  323. if ($return) {
  324. // 记录需要删除的id
  325. $mail_array[] = $val['mail_id'];
  326. }
  327. }
  328. // 删除已发送的记录
  329. $model_storemsgcron->delMailCron(['mail_id' => ['in', $mail_array]]);
  330. }
  331. }
  332. public function second_queueOp()
  333. {
  334. while (true)
  335. {
  336. do{
  337. try {
  338. $ret = $this->_cron_common([8]);
  339. perfor_clear();
  340. } catch (Exception $ex) {
  341. Log::record($ex->getMessage(),Log::ERR);
  342. }
  343. }
  344. while($ret === true);
  345. sleep(1);
  346. }
  347. }
  348. public function account_editOp()
  349. {
  350. $stamp = 0;
  351. while (true)
  352. {
  353. try {
  354. $divertor = new refill\divert_account();
  355. $next = time();
  356. $divertor->update_account($stamp);
  357. $stamp = $next;
  358. } catch (Exception $ex) {
  359. Log::record($ex->getMessage(),Log::ERR);
  360. }
  361. sleep(1);
  362. }
  363. }
  364. //任务队列处理
  365. public function taskOp()
  366. {
  367. Log::short_name('task');
  368. Log::record('start task',Log::DEBUG);
  369. $task_manager = new task\manager();
  370. $task_id = 0;
  371. while (true)
  372. {
  373. try
  374. {
  375. $task = $task_manager->pop_task($task_id);
  376. if (!empty($task)) {
  377. $task_manager->handle($task);
  378. $task_id = $task['task_id'];
  379. }
  380. }
  381. catch (Exception $ex) {
  382. Log::record($ex->getMessage(),Log::ERR);
  383. }
  384. sleep(1);
  385. }
  386. }
  387. //更新统计业务数据
  388. public function stat_utilOp()
  389. {
  390. Log::short_name('stat_util');
  391. while (true)
  392. {
  393. try {
  394. $this->stat_util();
  395. } catch (Exception $ex) {
  396. Log::record($ex->getMessage(), Log::ERR);
  397. }
  398. sleep(1);
  399. }
  400. }
  401. private function stat_util()
  402. {
  403. //查找最早的充值中的单子
  404. $update_earliest_ordertime = function () {
  405. $mod = Model('refill_detail');
  406. $time = $mod->getLatestSendTime();
  407. wcache('earliest_sending', ['order_time' => $time], 'refill-stat-');
  408. Log::record("earliest_sending order_time={$time}",Log::DEBUG);
  409. };
  410. $update_earliest_ordertime();
  411. }
  412. /**
  413. * 执行通用任务
  414. */
  415. private function _cron_common($types)
  416. {
  417. Log::record(__FUNCTION__,Log::DEBUG);
  418. //查找待执行任务
  419. $model_cron = Model('cron');
  420. $cron = $model_cron->getCronList(['exetime'=> ['elt',time()],'type' => ['in',$types]]);
  421. if (!is_array($cron)) return false;
  422. $count = count($cron);
  423. if ($count <= 0) return false;
  424. Log::record("match cron count={$count}",Log::DEBUG);
  425. $cron_array = [];
  426. $cronid = [];
  427. $exeid = 1;
  428. foreach ($cron as $v)
  429. {
  430. $type = intval($v['type']);
  431. if($type == 8) {
  432. $cron_array[$v['type']][$exeid] = $v;
  433. $exeid++;
  434. }
  435. else {
  436. $cron_array[$v['type']][$v['exeid']] = $v;
  437. }
  438. }
  439. foreach ($cron_array as $k=>$v)
  440. {
  441. // 如果方法不存是,直接删除id
  442. if (!method_exists($this,'_cron_'.$k)) {
  443. $tmp = current($v);
  444. $cronid[] = $tmp['id'];
  445. continue;
  446. }
  447. $method = '_cron_'.$k;
  448. Log::record("crontab minutest:{$method}",Log::DEBUG);
  449. $result = call_user_func_array([$this, '_cron_' . $k], [$v]);
  450. if (is_array($result)) {
  451. $cronid = array_merge($cronid, $result);
  452. } else {
  453. $method = '_cron_' . $k;
  454. Log::record("crontab minutest err:{$method}", Log::ERR);
  455. }
  456. }
  457. //删除执行完成的cron信息
  458. if (!empty($cronid) && is_array($cronid)) {
  459. $model_cron->delCron(['id' => ['in', $cronid]]);
  460. }
  461. return true;
  462. }
  463. //'任务类型 1商品上架 2根据商品id更新商品促销价格 3优惠套装过期 4推荐展位过期 5团购开始更新商品促销价格 6团购过期 7限时折扣过期',
  464. //1商品上架
  465. private function _cron_1($cron = array())
  466. {
  467. $condition = ['goods_commonid' => ['in',array_keys($cron)]];
  468. $update = Model('goods')->editProducesOnline($condition);
  469. if ($update)
  470. {
  471. //返回执行成功的cronid
  472. $cronid = [];
  473. foreach ($cron as $v) {
  474. $cronid[] = $v['id'];
  475. }
  476. }
  477. else {
  478. return false;
  479. }
  480. return $cronid;
  481. }
  482. //2根据商品id更新商品促销价格
  483. private function _cron_2($cron = array())
  484. {
  485. $condition = ['goods_id' => ['in',array_keys($cron)]];
  486. $update = Model('goods')->editGoodsPromotionPrice($condition);
  487. if ($update){
  488. //返回执行成功的cronid
  489. $cronid = [];
  490. foreach ($cron as $v) {
  491. $cronid[] = $v['id'];
  492. }
  493. }else{
  494. return false;
  495. }
  496. return $cronid;
  497. }
  498. //3优惠套装过期
  499. private function _cron_3($cron = [])
  500. {
  501. $condition = ['store_id' => ['in', array_keys($cron)]];
  502. $update = Model('p_bundling')->editBundlingQuotaClose($condition);
  503. if ($update) {
  504. //返回执行成功的cronid
  505. $cronid = [];
  506. foreach ($cron as $v) {
  507. $cronid[] = $v['id'];
  508. }
  509. } else {
  510. return false;
  511. }
  512. return $cronid;
  513. }
  514. //4推荐展位过期
  515. private function _cron_4($cron = [])
  516. {
  517. $condition = array('store_id' => array('in', array_keys($cron)));
  518. $update = Model('p_booth')->editBoothClose($condition);
  519. if ($update) {
  520. //返回执行成功的cronid
  521. $cronid = array();
  522. foreach ($cron as $v) {
  523. $cronid[] = $v['id'];
  524. }
  525. } else {
  526. return false;
  527. }
  528. return $cronid;
  529. }
  530. //5团购开始更新商品促销价格
  531. private function _cron_5($cron = array())
  532. {
  533. $condition = [];
  534. $condition['goods_commonid'] = ['in', array_keys($cron)];
  535. $condition['start_time'] = ['lt', time()];
  536. $condition['end_time'] = ['gt', time()];
  537. $groupbuy = Model('groupbuy')->getGroupbuyList($condition);
  538. foreach ($groupbuy as $val) {
  539. Model('goods')->editGoods(['goods_promotion_price' => $val['groupbuy_price'], 'goods_promotion_type' => 1],
  540. ['goods_commonid' => $val['goods_commonid']]);
  541. }
  542. //返回执行成功的cronid
  543. $cronid = array();
  544. foreach ($cron as $v) {
  545. $cronid[] = $v['id'];
  546. }
  547. return $cronid;
  548. }
  549. /**
  550. * 抢购过期
  551. *
  552. * @param array $cron
  553. */
  554. private function _cron_6($cron = array())
  555. {
  556. $condition = ['goods_commonid' => ['in', array_keys($cron)]];
  557. //抢购活动过期
  558. $update = Model('groupbuy')->editExpireGroupbuy($condition);
  559. if ($update){
  560. //返回执行成功的cronid
  561. $cronid = [];
  562. foreach ($cron as $v) {
  563. $cronid[] = $v['id'];
  564. }
  565. }else{
  566. return false;
  567. }
  568. return $cronid;
  569. }
  570. /**
  571. * 限时折扣过期
  572. *
  573. * @param array $cron
  574. */
  575. private function _cron_7($cron = array())
  576. {
  577. $condition = array('xianshi_id' => array('in', array_keys($cron)));
  578. //限时折扣过期
  579. $update = Model('p_xianshi')->editExpireXianshi($condition);
  580. if ($update){
  581. //返回执行成功的cronid
  582. $cronid = array();
  583. foreach ($cron as $v) {
  584. $cronid[] = $v['id'];
  585. }
  586. }
  587. else{
  588. return false;
  589. }
  590. return $cronid;
  591. }
  592. private function _cron_8($cron = array())
  593. {
  594. $cronid = [];
  595. foreach ($cron as $v)
  596. {
  597. $cronid[] = intval($v['id']);
  598. $params = $v['params'];
  599. if(!empty($params))
  600. {
  601. $params = unserialize($params);
  602. if(is_array($params))
  603. {
  604. foreach ($params as $key => $value) {
  605. Log::record("delay queue: {$key}",Log::DEBUG);
  606. QueueClient::push($key,$value);
  607. }
  608. }
  609. }
  610. }
  611. return $cronid;
  612. }
  613. //查询超过5分钟的充值中订单
  614. public function _SendOrderQuery()
  615. {
  616. $model_refill_order = Model('refill_order');
  617. $condition['order_state'] = ORDER_STATE_SEND;
  618. $condition['refill_order.order_time'] = ['lt', (time() - 300)];
  619. $orders = $model_refill_order->getMerchantOrderList($condition, 1000, 0,'refill_order.order_id');
  620. if(!empty($orders)) {
  621. foreach ($orders as $order) {
  622. $order_id = $order['order_id'];
  623. QueueClient::push("QueryRefillState",['order_id' => $order_id]);
  624. }
  625. }
  626. }
  627. //
  628. public function _refill_task(): bool
  629. {
  630. Log::record(__FUNCTION__,Log::DEBUG);
  631. $model_refill_task = Model('refill_task');
  632. $task = $model_refill_task->UnDispose('order_export');
  633. if (empty($task)) return false;
  634. $task_id = $task['task_id'];
  635. $task_condition = unserialize($task['task_condition']);
  636. if (empty($task_condition)) {
  637. Log::record("refill task condition unserialize err, task_id:{$task_id}");
  638. return false;
  639. }
  640. $type = $task['type'];
  641. $cid = $task['cid'];
  642. if ($type === 'merchant') {
  643. $condition['refill_order.mchid'] = $cid;
  644. } elseif ($type === 'provider') {
  645. $condition['vr_order.store_id'] = $cid;
  646. } else {
  647. Log::record("refill task type err, task_id:{$task_id}");
  648. return false;
  649. }
  650. $order_time_type = $task_condition['order_time_type'];
  651. $start_unixtime = $task_condition['start_unixtime'];
  652. $end_unixtime = $task_condition['end_unixtime'];
  653. $order_state = $task_condition['order_state'];
  654. if ($start_unixtime > 0 && $end_unixtime > $start_unixtime) {
  655. $condition["refill_order.{$order_time_type}"] = [['egt', $start_unixtime], ['lt', $end_unixtime], 'and'];
  656. $condition['vr_order.add_time'] = ['egt', $start_unixtime-1];
  657. } elseif ($start_unixtime > 0) {
  658. $condition["refill_order.{$order_time_type}"] = ['egt', $start_unixtime];
  659. $condition['vr_order.add_time'] = ['egt', $start_unixtime-1];
  660. }
  661. if (in_array($order_state, ['0', '10', '20', '30', '40'], true)) {
  662. $condition['order_state'] = $order_state;
  663. }
  664. $model_refill_task->Dispose($task_id);
  665. [$state, $task_result] = $this->order_export($condition, $type, $task_id);
  666. if ($state) {
  667. $model_refill_task->DisposeFinish($task_id, $task_result);
  668. } else {
  669. $model_refill_task->DisposeErr($task_id, $task_result);
  670. }
  671. return true;
  672. }
  673. /**
  674. * @throws PHPExcel_Exception
  675. */
  676. private function order_export($condition, $type, $task_id)
  677. {
  678. $orders = Model('refill_order')->getAllOrders($condition);
  679. if(empty($orders)) {
  680. return [false, '统计数据为空'];
  681. }
  682. $orders = $this->orderFormat($orders);
  683. $objPHPExcel = new PHPExcel();
  684. if ($type === 'merchant') {
  685. $column_keys = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K'];
  686. $column_values = ['商户号', '客户订单号', '平台单号', '面额', '充值卡号', '充值卡类型', '下单日期', '完成日期', '官方流水号', '订单状态', '扣款金额'];
  687. $data_keys = ['mchid', 'mch_order', 'order_sn', 'refill_amount', 'card_no', 'card_type_text', 'order_time_text', 'notify_time_text', 'official_sn', 'order_state_text', 'mch_amount'];
  688. } elseif ($type === 'provider') {
  689. $column_keys = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J'];
  690. $column_values = ['上游订单号', '平台单号', '面额', '充值卡号', '充值卡类型', '下单日期', '完成日期', '官方流水号', '订单状态', '扣款金额'];
  691. $data_keys = ['ch_trade_no', 'order_sn', 'refill_amount', 'card_no', 'card_type_text', 'order_time_text', 'notify_time_text', 'official_sn', 'order_state_text', 'channel_amount'];
  692. } else {
  693. return [false, '主体类型错误'];
  694. }
  695. $objPHPExcel->setActiveSheetIndex(0);
  696. $objPHPExcel->getDefaultStyle()->getFont()->setName('Arial')->setSize(10);
  697. foreach ($column_keys as $key => $column_key) {
  698. $objPHPExcel->getActiveSheet()->getColumnDimension($column_key)->setWidth(25);
  699. $cell_value = $column_key . 1;
  700. $objPHPExcel->getActiveSheet()->setCellValue($cell_value, $column_values[$key]);
  701. }
  702. foreach ($orders as $k => $order) {
  703. foreach ($column_keys as $key => $column_key) {
  704. $field = $column_key.($k+2);
  705. $objPHPExcel->getActiveSheet()->setCellValueExplicit($field, $order[$data_keys[$key]],
  706. PHPExcel_Cell_DataType::TYPE_STRING);
  707. }
  708. }
  709. try {
  710. $path = BASE_ROOT_PATH . "/data/upload/task/";
  711. if(!is_dir($path)){
  712. mkdir($path, 0755);
  713. }
  714. $filename = date('YmdHis',time())."-任务导出-任务ID:{$task_id}.xlsx";
  715. $file_path = $path . $filename;
  716. $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
  717. $objWriter->save($file_path);
  718. return [true, $filename];
  719. } catch (Exception $e) {
  720. return [false, $e->getMessage()];
  721. }
  722. }
  723. private function orderFormat($orders): array
  724. {
  725. $card_type_texts = [mtopcard\PetroChinaCard => '中石油', mtopcard\SinopecCard => '中石化', mtopcard\ChinaMobileCard => '中国移动', mtopcard\ChinaUnicomCard => '中国联通', mtopcard\ChinaTelecomCard => '中国电信'];
  726. $orderState = function ($order_info) {
  727. $is_retrying = $order_info['is_retrying'];
  728. switch ($order_info['order_state']) {
  729. case ORDER_STATE_CANCEL:
  730. if ($is_retrying) {
  731. $order_state = '重试中';
  732. } else {
  733. $order_state = '已取消';
  734. }
  735. break;
  736. case ORDER_STATE_NEW:
  737. $order_state = '待付款';
  738. break;
  739. case ORDER_STATE_PAY:
  740. $order_state = '待发货';
  741. break;
  742. case ORDER_STATE_SEND:
  743. $order_state = '待收货';
  744. break;
  745. case ORDER_STATE_SUCCESS:
  746. $order_state = '交易完成';
  747. break;
  748. default :
  749. $order_state = '未知状态';
  750. }
  751. return $order_state;
  752. };
  753. foreach($orders as $key => $order)
  754. {
  755. $orders[$key]['card_type_text'] = $card_type_texts[$order['card_type']];
  756. $orders[$key]['order_time_text'] = $order['order_time'] ? date('Y-m-d H:i:s', $order['order_time']) : '';
  757. $orders[$key]['notify_time_text'] = $order['notify_time'] ? date('Y-m-d H:i:s', $order['notify_time']) : '';
  758. $orders[$key]['order_state_text'] = $orderState($order);
  759. }
  760. return $orders;
  761. }
  762. }