Notify.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497
  1. <?php
  2. namespace app\controller\api;
  3. use AdaPaySdk\AdapayTools;
  4. use app\common\repositories\store\order\StoreRefundOrderRepository;
  5. use app\controller\api\merchant\sxy\Access;
  6. use think\facade\Db;
  7. use think\facade\Log;
  8. use think\facade\Request;
  9. class Notify
  10. {
  11. public function notify($type){
  12. // Db::name('log')->insert(['data'=>'汇付支付回调---'.json_encode($type)]);
  13. set_time_limit(0);
  14. $post = Request::param();
  15. Db::name("log")->insert(array('data'=>'【汇付异步接受到的参数】'.json_encode($post),));//日志记录
  16. $post_data_str = isset($post['data']) ? $post['data']: '';
  17. $post_sign_str = isset($post['sign']) ? $post['sign']: '';
  18. # 先校验签名和返回的数据的签名的数据是否一致
  19. $adapay_tools=new AdapayTools();
  20. if ($post['app_id'] == 'app_383a75dd-c03d-44ab-8f58-92c60fe9b9d0'){
  21. AdapayTools::setRsaPrivateKey('MIICdQIBADANBgkqhkiG9w0BAQEFAASCAl8wggJbAgEAAoGBAKvkKGN19wxH9Uusx8gXnt89oYbgvIRkzO2pD0nzSF/MS65m2j5DgKMG5lryL6bfco2p9syoxKI7IE9pLFtFTyI477cNoUsvWiIYikx5uKz0CDdBcR8AAapfrs5XKgJMcogulqDm4/7QUDuQJoATdvEpA6yfiaW2EqSnMpvZKsdFAgMBAAECgYAgmVOjkUK6HIeDw4/b/cbOlbSljMeT4D4RMIfKwY3PRUJxH+Zx+oFR6cQUKWwqHKRwA3Tf2X35OndlOBAGez2Hc1M08brGSlCB/Ze654mOP5H+bImKfmWQxJiVbbY4ef6msgNAp+FicWLvo6WDuymmP7gvoQbC5E90tRKDCvyawQJBANy/GaYU209Dikbd6E2rWKaS9dgx9f/wZOqmUMUzsDicMO4nK1qojyEm8inkoSRyzv0vLXqD/j/buhE4FjO/YbECQQDHV66K4NKNvuKAbI0NNXothxe2PS6lJrBU5QWgt4Q6CsQ8v+WyFq9AUjEahN11Evm2DCnEBddZKmSctZTgry/VAkAgCEMKjKA+Ykige/cHvkOA+HZgRu+xkgqy2iuCUjvSGygmhtyNrUQHxYUCe0C+70IGD2CEFL9COPpJIWBnZfAhAkATbV0qVbzPaaIDaBDbD7Ini7no3c+U8s9Ohr9kqV3uliwHy5/kGkfcGeaFMhuvFDlX35mWbAdPvkzt5NhsiUY9AkBNdE3yUz+f7A92oZr4bHX7r5gyUTumRiBYyiJ8dgMl6lT8OpQZpBxdswyWg2nkmPoCjoASZx8LoCBhsK4SBcfz');
  22. }else{
  23. AdapayTools::setRsaPrivateKey('MIICdQIBADANBgkqhkiG9w0BAQEFAASCAl8wggJbAgEAAoGBALFOkwRKx2HKMpAL7LUb755cIS7mleort++Rkl25tJMJCf9Ezeyg4xwLBN6RQsLERTAzRKc/EUtxm4/9rzDzvNZ4BegEI8mXWBUrgpn7e1ar8Ek8IRPdXLrozuld9cv56R3yB/Yta0R+kmgCfn2C5V+xtM6njimkOStvdK5cNwqFAgMBAAECgYA5pn+87IeJr1Hjbk0n0g6GYhRUCJuECXUEC0QY/3HMQSsj+f4uy10s2BRcPcUESQbqFjFjY+k+q5DWL7kP5KBoXGnFyflAyRhWGTkSC3VhGixh6ro3EcUJSrFDjGaThGaPrc8Zfcp5JhL5Thi0GaBXSnRH1Cmn4h8gkAEJxIM7PQJBAOq2+oVPtqkj99YRs0eewkZAM7bKRzSwI7OFU6YWsCYVkqNE7Lr3KKGekehuWwkOvrCBR+NEGQfAb557g2CHmzMCQQDBYtgQ5wvl9fD8BWAVKuPoxoleH+9wUQ65Rnt/Ebkx+g8kP37JRun81duLDULTKr/3ak42goE00TfnfeXl0gNnAkA0wuUVypF4/AjeKiRu2RU6zXvSfy36fg3IcRQYpcj7BqZr5TaB4MVVb1vFL+lu482hx63tPIWT5IIy0fj6XgFZAkBinlKLRBgIPISZMPCPuuCg22ZADs8fGucEStI9ub8Uom3IUW0JndVDb5fW8HtMjrd4p8ic+a6ETdFRhx2PNqsvAkAzDvlve56sZnLYx9t/MPkJTK3ZhgVETS0H2FUyJGVOSfjv68bNsUshyPfzJrdbCeLzjMLq8TpyOmiIUAeQ5YCX');
  24. }
  25. // AdapayTools::setRsaPrivateKey('MIICdQIBADANBgkqhkiG9w0BAQEFAASCAl8wggJbAgEAAoGBALFOkwRKx2HKMpAL7LUb755cIS7mleort++Rkl25tJMJCf9Ezeyg4xwLBN6RQsLERTAzRKc/EUtxm4/9rzDzvNZ4BegEI8mXWBUrgpn7e1ar8Ek8IRPdXLrozuld9cv56R3yB/Yta0R+kmgCfn2C5V+xtM6njimkOStvdK5cNwqFAgMBAAECgYA5pn+87IeJr1Hjbk0n0g6GYhRUCJuECXUEC0QY/3HMQSsj+f4uy10s2BRcPcUESQbqFjFjY+k+q5DWL7kP5KBoXGnFyflAyRhWGTkSC3VhGixh6ro3EcUJSrFDjGaThGaPrc8Zfcp5JhL5Thi0GaBXSnRH1Cmn4h8gkAEJxIM7PQJBAOq2+oVPtqkj99YRs0eewkZAM7bKRzSwI7OFU6YWsCYVkqNE7Lr3KKGekehuWwkOvrCBR+NEGQfAb557g2CHmzMCQQDBYtgQ5wvl9fD8BWAVKuPoxoleH+9wUQ65Rnt/Ebkx+g8kP37JRun81duLDULTKr/3ak42goE00TfnfeXl0gNnAkA0wuUVypF4/AjeKiRu2RU6zXvSfy36fg3IcRQYpcj7BqZr5TaB4MVVb1vFL+lu482hx63tPIWT5IIy0fj6XgFZAkBinlKLRBgIPISZMPCPuuCg22ZADs8fGucEStI9ub8Uom3IUW0JndVDb5fW8HtMjrd4p8ic+a6ETdFRhx2PNqsvAkAzDvlve56sZnLYx9t/MPkJTK3ZhgVETS0H2FUyJGVOSfjv68bNsUshyPfzJrdbCeLzjMLq8TpyOmiIUAeQ5YCX');
  26. // $adapay_tools->SetParams();
  27. $sign_flag = $adapay_tools->verifySign($post_data_str, $post_sign_str);
  28. $post_data_str=json_decode($post_data_str,true);
  29. if ($sign_flag){
  30. try {
  31. if(empty($post_data_str['error_msg'])){
  32. Db::name("log")->insert(array('data'=>'【验签通过-支付】:时间:'.date('Y-m-d H:i:s',time()),));//日志记录
  33. $requestId = [];
  34. if(strpos($post_data_str['order_no'],'_') !== false){
  35. $requestId = explode("_",$post_data_str['order_no']);
  36. }
  37. $pay_type = $post_data_str['pay_channel'];
  38. $pay_type = $pay_type == 'wx_lite' ? 1 : 4;
  39. switch ($type){
  40. case 'pay':
  41. Db::name('store_group_order') -> where('group_order_sn',$requestId[0]) -> update(['rand'=>$requestId[1]]);
  42. // 判断代付是否支付过
  43. $group_order = Db::name('store_group_order')->where('group_order_sn', $requestId[0])->find();
  44. $group_order_id = $group_order['group_order_id']??'';
  45. $old_pay_open_id = Db::name('store_order')->where('group_order_id', $group_order_id)->value('pay_open_id');
  46. if ($old_pay_open_id && $old_pay_open_id != $post_data_str['expend']['open_id']) {
  47. // 给新支付的这一笔退款
  48. Db::name('log')->insert(['data' => '给新支付的这一笔退款']);
  49. if ($group_order['pay_wx'] == 3){
  50. $key='api_live_b0a687ec-5450-4ada-a0e4-65bac0f46871';
  51. }else{
  52. $key='api_live_90ef02e4-54ac-41ee-adf1-e4927d23d58f';
  53. }
  54. $refund_traits = [
  55. 'payment_id' => $post_data_str['id'],
  56. 'app_id' => $post['app_id'],
  57. 'order_no' => app()->make(StoreRefundOrderRepository::class)->getNewOrderId(),
  58. 'reverse_amt' => $post_data_str['pay_amt'],
  59. 'notify_url' => env('APP_URL') . "/api/hf_notify/reverse_order",
  60. ];
  61. $hf_refund_res = app()->make(StoreRefundOrderRepository::class)->payment_Reverse($refund_traits, $pay_type['pay_type'] == '1' ? 2 : 1, $group_order['pay_wx'], $key);
  62. Db::name('log')->insert(['data'=>'汇付支付撤销返回结果:'.json_encode($hf_refund_res)]);
  63. break;
  64. }
  65. $post_data_str['expend']['open_id'] = $post_data_str['expend']['open_id'] ?? '';
  66. Db::name('store_order')->where('group_order_id', $group_order_id)->update(['pay_open_id' => $post_data_str['expend']['open_id']]);
  67. event('pay_success_order', ['order_sn' => $requestId[0],'pay_type'=>$pay_type]);
  68. break;
  69. case 'pay_channel':
  70. //渠道商
  71. try{
  72. $order_data=Db::name('channel_order') -> where('order_no',$requestId[0]) -> find();
  73. if($order_data['status']==1){
  74. return false;
  75. }
  76. $pay_type = $pay_type == 1 ? 'wx' : 'al';
  77. Db::name('channel_user')->where('uid',$order_data['uid'])->update(['status'=>1]);
  78. Db::name('channel_order') -> where('order_no',$requestId[0]) -> update(['rand'=>$requestId[1],'pay_type'=>$pay_type,'status'=>1]);
  79. }catch (\Exception $e) {
  80. Db::name('log')->insert(['data'=>'支付渠道商错误:'.$e->getFile().':'.$e->getLine().'【'.$e->getMessage().'】']);
  81. }
  82. try{
  83. $access = new Access();
  84. //分佣
  85. $access->channel_fenyong($requestId[0]);
  86. // //给7个激活码
  87. // for($i=0;$i<=6;$i++){
  88. // Db::name('activation_code')->insertGetId([
  89. // 'uid'=>$order_data['uid'],
  90. // 'code'=>$this->randomFromDev(20),
  91. // 'ctime'=>time(),
  92. // 'status'=>1,
  93. // 'utime'=>time(),
  94. // 'use_uid'=>0,
  95. // 'type'=>2
  96. // ]);
  97. // }
  98. //赠送返本商户
  99. $mer = Db::name('user_mer') -> where('uid',$order_data['uid']) -> find();
  100. if(!$mer){
  101. Db::name('user_mer') -> insert(['uid'=>$order_data['uid'],'mer'=>10]);
  102. }else{
  103. Db::name('user_mer') -> where('uid',$order_data['uid'])->inc('mer', 10) ->update();;
  104. }
  105. //赠送商户
  106. $merchant=Db::name('merchant')->where('uid',$order_data['uid'])->find();
  107. if(!$merchant)
  108. Db::name('merchant_intention')->insert(['uid'=>$order_data['uid'],'status'=>3,'activation_code'=>rand('000000000','999999999')]);
  109. //赠送大仓会员资格
  110. $dacang_user = Db::name('da_cang_user')->where('uid', $order_data['uid'])->find();
  111. $time = date('Y-m-d', time());
  112. $time = strtotime($time);
  113. $end_time = $time + 31536000 - 1;
  114. $dc_id = 1;
  115. //如果不是金卡会员,赠送金卡会员一年
  116. if (!$dacang_user) {
  117. Db::name('da_cang_user')->insert(['uid' => $order_data['uid'], 'ctime' => time(), 'end_time' => $end_time, 'dc_id' => $dc_id,'status'=>1,'type'=>1]);
  118. }else{
  119. //如果是银卡会员,变成金卡,一年 || 是否已过期,如果已过期,赠送金卡会员一年
  120. if($dacang_user['type'] == 2 || $dacang_user['end_time'] < $time){
  121. Db::name('da_cang_user')->where('uid', $order_data['uid'])->where('dc_id', $dc_id)->update(['end_time' => $end_time,'status'=>1,'type'=>1]);
  122. }
  123. }
  124. }catch (\Exception $exception){
  125. Db::name('log')->insert(['data'=>'渠道商处理错误:'.$exception->getFile().':'.$exception->getLine().'【'.$exception->getMessage().'】']);
  126. }
  127. break;
  128. case 'pay_annual':
  129. //商户
  130. $annual_cost_order=Db::name('merchant_annual_cost_order')-> where('order_no',$requestId[0])->find();
  131. if($annual_cost_order['status'] == 0) {
  132. $pay_type = $pay_type == 1 ? 'wx' : 'al';
  133. Db::name('merchant_annual_cost_order')->where('order_no', $requestId[0])->update(['rand' => $requestId[1],'pay_type'=>$pay_type,'status' => 1]);
  134. //如果有商户id就是续费
  135. $mer_id = Db::name('merchant_annual_cost_order')->where('order_no', $requestId[0])->value('mer_id');
  136. if ($mer_id !== 0) {
  137. $expire_time = strtotime(date('Y-m-d')) + 86400 * 365 + 86400 - 1;
  138. Db::name('merchant')->where('mer_id', $mer_id)->update(['expire_time' => $expire_time, 'status' => 1]);
  139. }
  140. $mer = Db::name('user_mer') -> where('uid',$annual_cost_order['uid']) -> find();
  141. if(!$mer){
  142. Db::name('user_mer') -> insert(['uid'=>$annual_cost_order['uid'],'mer'=>2]);
  143. }else{
  144. Db::name('user_mer') -> where('uid',$annual_cost_order['uid'])->inc('mer', 2) ->update();;
  145. }
  146. $access = new Access();
  147. $access->nianfei_yj($annual_cost_order['id']);
  148. }
  149. break;
  150. case 'pay_activation':
  151. try{
  152. $order_data=Db::name('activation_code_order') -> where('order_no',$requestId[0]) -> find();
  153. if($order_data['status']==1){
  154. return false;
  155. }
  156. $access = new Access();
  157. $id=Db::name('activation_code')->insertGetId([
  158. 'uid'=>$order_data['uid'],
  159. 'code'=>$access->randomFromDev(20),
  160. 'ctime'=>time(),
  161. 'status'=>1,
  162. 'utime'=>time(),
  163. 'use_uid'=>0,
  164. 'type'=>1
  165. ]);
  166. Db::name('activation_code_order') -> where('order_no',$requestId[0]) -> update(['rand'=>$requestId[1],'status'=>1,'code_id'=>$id]);
  167. }catch (\Exception $e) {
  168. Db::name('log')->insert(['data'=>'支付激活码错误:'.$e->getFile().':'.$e->getLine().'【'.$e->getMessage().'】']);
  169. }
  170. //处理佣金
  171. $num=$access->activation_yj($requestId[0]);
  172. //分账
  173. $access->activation_spilet($requestId[0],$num);
  174. break;
  175. case 'notify_order':
  176. Db::name("log")->insert(array('data'=>'汇付退款回调'));//日志记录
  177. break;
  178. case 'marketing':
  179. $marketing_order=Db::name('marketing_order')-> where('order_no',$requestId[0])->find();
  180. if($marketing_order['status']==1){
  181. return app('json')->success(['result' => 'SUCCESS']);
  182. }
  183. // $pay_type = $pay_type == 1 ? 'wx' : 'ali';
  184. $checkUser = Db::name("MarketingUser") -> where('uid',$marketing_order['uid'])->find();
  185. $handle = $this -> marketing($marketing_order,$checkUser);
  186. if ($handle){
  187. //分账
  188. $this -> pay_user_annual($marketing_order['uid']);
  189. }
  190. break;
  191. case 'pay_user_annual':
  192. $user_pension_account_order=Db::name('user_pension_account_order')-> where('order_no',$requestId[0])->find();
  193. if($user_pension_account_order['status']==1){
  194. return app('json')->success(['result' => 'SUCCESS']);
  195. }
  196. $this -> pay_user_annual($user_pension_account_order['uid'],$requestId[0]);
  197. break;
  198. default:
  199. Db::name("log")->insert(array('data'=>$type));//日志记录
  200. }
  201. }
  202. return app('json')->success(['result' => 'SUCCESS']);
  203. }catch (\Exception $exception){
  204. Db::name("log")->insert(array('data'=>'汇付回调错误:'.$exception->getFile().':'.$exception->getLine().'【'.$exception->getMessage().'】'));//日志记录
  205. return app('json')->success(['result' => 'ERROR']);
  206. }
  207. }
  208. }
  209. public function pay_user_annual($uid,$order_no=''){
  210. Db::startTrans();
  211. try {
  212. if ($order_no != ''){
  213. Db::name('user_pension_account_order')-> where('order_no',$order_no) -> update(['status'=>1]);
  214. }
  215. $check = Db::name("user_pension_account") -> where("uid",$uid) -> find();
  216. $start_time = date('Y-m-d');
  217. $end_time = date("Y-m-d 23:59:59",strtotime("+1 year", strtotime($start_time)));
  218. $give = 0;
  219. //存在既续费
  220. if ($check){
  221. Db::name("user_pension_account") -> where("uid",$uid) -> update(['start_time'=>$start_time,'end_time'=>$end_time]);
  222. $give = $check['give'];
  223. }else{
  224. //新用户订单
  225. Db::name("user_pension_account") -> insert([
  226. "uid" => $uid,
  227. "start_time" => $start_time,
  228. "end_time" => $end_time,
  229. "status" => 1,
  230. ]);
  231. }
  232. if ($give == 0){
  233. Db::name("user_pension_account") -> where("uid",$uid) -> update(['give' => 1]);
  234. $mark = "开通养老金账户";
  235. $billData=[
  236. 'uid'=>$uid,
  237. 'pm'=>1,
  238. 'title'=>'养老金',
  239. 'category'=>'now_money',
  240. 'type'=>'commission',
  241. 'number'=>0.01,
  242. 'balance'=>0,
  243. 'mark'=>$mark,
  244. 'create_time'=>date("Y-m-d H:i:s",time()),
  245. 'status'=>1,
  246. 'order_sn'=>'',
  247. 'type_shop'=>0,
  248. 'commission_type'=>5,
  249. 'order_type'=>1,
  250. 'gzc'=>0
  251. ];
  252. Db::name('user_bill')->insert($billData);
  253. Db::name("user")->where("uid",$uid)->inc('annuity', 0.01) ->update();
  254. Db::name("user")->where("uid",$uid)->inc('annuity_num', 1) ->update();
  255. }
  256. // 提交事务
  257. Db::commit();
  258. return true;
  259. } catch (\Exception $e) {
  260. // 回滚事务
  261. Db::rollback();
  262. Log::error($e->getMessage());
  263. }
  264. }
  265. public function marketing($order,$marketingUser,$pay_type="wx"){
  266. Db::startTrans();
  267. try {
  268. Db::name('marketing_order') -> where('order_no',$order['order_no']) -> update(['pay_type'=>$pay_type,'status'=>1]);
  269. Db::name('marketing_user') -> where('uid',$order['uid']) -> update(['type'=>$order['type']]);
  270. //分红份数及资金
  271. $divvy_number = ceil(bcdiv($order['pay_price'],99));
  272. $divvy_money = $order['pay_price'];
  273. Db::name('marketing_user') -> where('uid',$order['uid']) -> inc('divvy_number', $divvy_number) ->update();
  274. Db::name('marketing_user') -> where('uid',$order['uid']) -> inc('divvy_money', $divvy_money) ->update();
  275. //上级
  276. $spread_uid = $marketingUser['spread_uid'];
  277. //养老金
  278. //本人给养老金10%
  279. $ylj=bcmul($order['pay_price'],'0.1',5);//10%的养老金
  280. $ylj=round($ylj,2);
  281. $title='养老金';
  282. if ($order['type'] == 1){
  283. $identity = "普通会员";
  284. }elseif ($order['type'] == 2){
  285. $identity = "创客";
  286. }elseif ($order['type'] == 3){
  287. $identity = "合伙人";
  288. }else{
  289. $identity = "";
  290. }
  291. $mark = "成为{$identity}获得{$ylj}养老金";
  292. $billData=[
  293. 'uid'=>$order['uid'],
  294. 'link_id'=>$order['id'],
  295. 'pm'=>1,
  296. 'title'=>$title,
  297. 'category'=>'now_money',
  298. 'type'=>'commission',
  299. 'number'=>$ylj,
  300. 'balance'=>0,
  301. 'mark'=>$mark,
  302. 'create_time'=>date("Y-m-d H:i:s",time()),
  303. 'status'=>1,
  304. 'order_sn'=>$order['order_no'],
  305. 'type_shop'=>0,
  306. 'commission_type'=>5,
  307. 'order_type'=>1,
  308. 'gzc'=>0
  309. ];
  310. Db::name('user_bill')->insert($billData);
  311. Db::name("user")->where("uid",$order['uid'])->inc('annuity', $ylj) ->update();
  312. Db::name("user")->where("uid",$order['uid'])->inc('annuity_num', 1) ->update();
  313. //上级佣金
  314. $checkSpread = Db::name("MarketingUser") -> where('uid',$spread_uid)->value("type");
  315. //检查上级身份 必须是会员或以上
  316. if ($checkSpread > 0){
  317. $commission=bcmul($order['pay_price'],'0.3',5);//30%的佣金
  318. $commission=round($commission,2);
  319. $spreadTitle='佣金';
  320. $spreadMark = "推广{$identity}获得{$commission}佣金";
  321. $spreadBillData=[
  322. 'uid'=>$spread_uid,
  323. 'link_id'=>$order['id'],
  324. 'pm'=>1,
  325. 'title'=>$spreadTitle,
  326. 'category'=>'now_money',
  327. 'type'=>'commission',
  328. 'number'=>$commission,
  329. 'balance'=>0,
  330. 'mark'=>$spreadMark,
  331. 'create_time'=>date("Y-m-d H:i:s",time()),
  332. 'status'=>1,
  333. 'order_sn'=>$order['order_no'],
  334. 'type_shop'=>0,
  335. 'commission_type'=>11,
  336. 'order_type'=>1
  337. ];
  338. Db::name('user_bill')->insert($spreadBillData);
  339. Db::name('user')->where('uid',$spread_uid)->inc('brokerage_price',$commission)->update();
  340. }
  341. $spread_list = $marketingUser['spread_list'];
  342. $spread_list = str_replace(['[', ']'], '', $spread_list);
  343. $spread_list = explode(',',$spread_list);
  344. //计算所有上级的累计销售业绩 赠送积分
  345. $achievement = $this -> achievement($spread_list,$order['uid'],$order['pay_price']);
  346. foreach($achievement as $key => $value){
  347. $spreadTitle='业务销售奖励积分';
  348. $achievementMark = "团队推广{$identity}获得{$value['commission']}积分";
  349. $integral = Db::name("marketing_user") -> where('uid',$spread_uid) -> value("integral");
  350. $achievementBillData=[
  351. 'uid'=>$key,
  352. 'pm'=>1,
  353. 'title'=>$spreadTitle,
  354. 'integral'=>$value['commission'],
  355. 'residual_integral' => $integral + $value['commission'],
  356. // 'mark'=>$achievementMark,
  357. 'order_sn'=>$order['order_no'],
  358. ];
  359. Db::name('marketing_integral')->insert($achievementBillData);
  360. Db::name('marketing_user')->where('uid',$spread_uid)->inc('integral',$value['commission'])->update();
  361. }
  362. if ($order['type'] == 2 || $order['type'] == 3) {
  363. //赠送商户
  364. $merchant=Db::name('merchant')->where('uid',$order['uid'])->find();
  365. if(!$merchant) {
  366. $access = new Access();
  367. $activation_code = $access->randomFromDev(20);
  368. // Db::name('activation_code')->insertGetId([
  369. // 'uid' => $order['uid'],
  370. // 'code' => $activation_code,
  371. // 'ctime' => time(),
  372. // 'status' => 1,
  373. // 'utime' => time(),
  374. // 'use_uid' => $order['uid'],
  375. // 'type' => 1
  376. // ]);
  377. Db::name('merchant_intention')->insert(['uid' => $order['uid'], 'status' => 3, 'activation_code' => $activation_code]);
  378. }
  379. }
  380. // 提交事务
  381. Db::commit();
  382. return true;
  383. } catch (\Exception $e) {
  384. // 回滚事务
  385. Db::rollback();
  386. Log::error($e->getMessage());
  387. return false;
  388. }
  389. }
  390. public function achievement($lists,$uid,$pay_price){
  391. $newList = [];
  392. $lastAchievement = 0;
  393. $lastCommission = 0;
  394. $total = 0;
  395. $list=array_reverse($lists);
  396. foreach($list as $value){
  397. $checkSpread = Db::name("MarketingUser") -> where('uid',$value)->value("type");
  398. //检查上级身份 必须是会员或以上
  399. if ($checkSpread <= 0) continue;
  400. $achievement = Db::name('marketing_order')
  401. ->where('uid','in',function($query) use ($value,$uid){
  402. $query->name('marketing_user')-> where("spread_list like '%[$value]%' or uid = $value","") -> where("uid","<>",$uid) -> field("uid");
  403. })
  404. -> where("status",1)
  405. ->sum("pay_price");
  406. if ($achievement >= 50000 && $achievement < 300000){
  407. $c = round(bcmul($pay_price,'0.1',5),2);//10%
  408. //如果业绩大于5万,小于30万。并且业绩等级等于1。奖励等于上个人的奖励减半
  409. if ($lastAchievement == 1){
  410. $c = round(bcmul($lastCommission,0.5,5),2);
  411. }
  412. $lastCommission = $c;
  413. $lastAchievement = 1;
  414. $total += $c;
  415. $newList[$value] = [
  416. "achievement" => $achievement,
  417. "commission" => $c
  418. ];
  419. }elseif ($achievement >= 300000 && $achievement < 1000000){
  420. $c = round(bcmul($pay_price,'0.15',5),2);//15%
  421. //如果业绩大于5万,小于30万。并且业绩等级等于2。奖励等于上个人的奖励减半
  422. if ($lastAchievement == 2){
  423. $c = round(bcmul($lastCommission,0.5,5),2);
  424. }else{
  425. $c = $c - $total;
  426. }
  427. $lastAchievement = 2;
  428. if ($c > 0){
  429. $total += $c;
  430. $lastCommission = $c;
  431. $newList[$value] = [
  432. "achievement" => $achievement,
  433. "commission" => $c
  434. ];
  435. }else{
  436. $lastCommission = 0;
  437. }
  438. }elseif ($achievement >= 1000000){
  439. $c = round(bcmul($pay_price,'0.2',5),2);//20%
  440. //如果业绩大于5万,小于30万。并且业绩等级等于3。奖励等于上个人的奖励减半
  441. if ($lastAchievement == 3){
  442. $c = round(bcmul($lastCommission,0.5,5),2);
  443. }else{
  444. $c = $c - $total;
  445. }
  446. $total += $c;
  447. $lastAchievement = 3;
  448. if ($c > 0){
  449. $total += $c;
  450. $lastCommission = $c;
  451. $newList[$value] = [
  452. "achievement" => $achievement,
  453. "commission" => $c
  454. ];
  455. }else{
  456. $lastCommission = 0;
  457. }
  458. }
  459. }
  460. return $newList;
  461. }
  462. }