Plantask.php 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187
  1. <?php
  2. namespace app\index\controller;
  3. use think\Controller;
  4. use think\Db;
  5. use app\common\model\Wallet;
  6. class Plantask extends Controller
  7. {
  8. public function index()
  9. {
  10. exit;
  11. }
  12. //推荐奖励
  13. //订单支付回调之后的任务,每分钟运行
  14. //烧伤
  15. public function auto_order_paid(){
  16. $map = [
  17. 'status' => 1,
  18. 'have_paid' => ['gt',0],
  19. 'paidtasktime' => 0,
  20. ];
  21. Db::startTrans();
  22. $order_list = Db::name('unishop_order')->where($map)->order('id asc')->limit(10)->lock(true)->select();
  23. if(empty($order_list)){
  24. echo '没有数据';
  25. Db::rollback();
  26. exit;
  27. }
  28. $walletmodel = new Wallet();
  29. foreach($order_list as $key => $order){
  30. //本金立即到账给入金者
  31. if($order['order_benjin'] > 0){
  32. $remark = '本金:'.$order['order_benjin'];
  33. $rs_wallet = $walletmodel->lockChangeAccountRemain($order['user_id'],'score',$order['order_benjin'],5,$remark,'unishop_order',$order['id'],$order['user_id']);
  34. if($rs_wallet['status'] === false){
  35. echo $rs_wallet['msg'];
  36. Db::rollback();
  37. exit;
  38. }
  39. }
  40. //直推代理商获益
  41. $intro_uid = Db::name('user')->where('id',$order['user_id'])->value('intro_uid');
  42. if($intro_uid){
  43. //直推的第一单金额,烧伤
  44. $map = [
  45. 'status' => 1,
  46. 'have_paid' => ['gt',0],
  47. 'user_id' => $intro_uid,
  48. ];
  49. $first_order = Db::name('unishop_order')->where($map)->order('have_paid asc')->value('order_price');
  50. $first_order = $first_order ?: 0;
  51. $jishu = $order['order_price'];
  52. $remark_shaoshang = '';
  53. if($first_order < $order['order_price']){
  54. $jishu = $first_order;
  55. $remark_shaoshang = '(烧伤)';
  56. }
  57. //奖励
  58. $bili = config('site.orderpaid_zhitui_bili') ?: 5;
  59. $score = bcdiv(bcmul($jishu,$bili,0),100,0);
  60. if($score > 0){
  61. $rs_wallet = $walletmodel->lockChangeAccountRemain($intro_uid,'score',$score,3,'直推代理奖励'.$remark_shaoshang,'unishop_order',$order['id'],$order['user_id']);
  62. if($rs_wallet['status'] === false){
  63. echo $rs_wallet['msg'];
  64. Db::rollback();
  65. exit;
  66. }
  67. $rs_wallet = $walletmodel->lockChangeAccountRemain($intro_uid,'shouyi',$score,31,'直推代理奖励'.$remark_shaoshang,'unishop_order',$order['id'],$order['user_id']);
  68. if($rs_wallet['status'] === false){
  69. echo $rs_wallet['msg'];
  70. Db::rollback();
  71. exit;
  72. }
  73. }
  74. }
  75. //订单完成
  76. $rs_order = Db::name('unishop_order')->where('id',$order['id'])->update(['paidtasktime'=>time()]);
  77. if($rs_order === false){
  78. echo '更新失败';
  79. Db::rollback();
  80. exit;
  81. }
  82. //循环结束
  83. }
  84. Db::commit();
  85. echo '成功'.count($order_list);
  86. }
  87. //总代奖励
  88. //自动结算10日前订单,每分钟运行
  89. public function auto_jiesuan_order(){
  90. $nowtime = time();
  91. /*$toweek = date('w',$nowtime);
  92. if($toweek == 0){
  93. //周日不结算(自动到下周一结算)
  94. echo '周日不结算';
  95. exit;
  96. }*/
  97. $tendays_ago = jiesuan_tendays_ago();
  98. //
  99. Db::startTrans();
  100. $order_map = [
  101. 'status' => 1,
  102. 'have_paid' => ['lt',$tendays_ago],
  103. 'jiesuantime' => 0,
  104. ];
  105. $order_list = Db::name('unishop_order')->where($order_map)->where('have_paid','gt',0)->order('id asc')->lock(true)->limit(10)->select();
  106. if(empty($order_list)){
  107. echo '没有数据';
  108. Db::rollback();
  109. exit;
  110. }
  111. foreach($order_list as $key => $order){
  112. //买家得到收益,两个数据同步加
  113. if($order['order_shouyi'] > 0){
  114. $shouyi = bcsub($order['order_shouyi'],$order['order_benjin']); //总收益 - 本金 = 可提现收益
  115. $remark = '收益:'.$shouyi;
  116. if($shouyi > 0){
  117. $rs_wallet = model('wallet')->lockChangeAccountRemain($order['user_id'],'score',$shouyi,50,$remark,'unishop_order',$order['id'],$order['user_id']);
  118. if($rs_wallet['status'] === false){
  119. echo $rs_wallet['msg'];
  120. Db::rollback();
  121. exit;
  122. }
  123. $rs_wallet = model('wallet')->lockChangeAccountRemain($order['user_id'],'shouyi',$shouyi,51,$remark,'unishop_order',$order['id'],$order['user_id']);
  124. if($rs_wallet['status'] === false){
  125. echo $rs_wallet['msg'];
  126. Db::rollback();
  127. exit;
  128. }
  129. }
  130. }
  131. //标记为结算
  132. $jiesuan = Db::name('unishop_order')->where('id',$order['id'])->update(['jiesuantime'=>$nowtime]);
  133. if($jiesuan === false){
  134. echo '修改状态失败';
  135. Db::rollback();
  136. exit;
  137. }
  138. //批发的都卖出
  139. $pifa = Db::name('unishop_order_product')->where('order_id',$order['id'])->update(['pifa_status'=>1]);
  140. if($pifa === false){
  141. echo '修改状态失败2';
  142. Db::rollback();
  143. exit;
  144. }
  145. //循环结束
  146. echo '完成'.$order['id'];
  147. }
  148. Db::commit();
  149. echo '成功'.count($order_list);
  150. }
  151. }