command('inspire') // ->hourly(); $schedule->command(AutoPayment::class)->everyMinute(); // $schedule->command(SynOrderNewCommand::class)->everyMinute()->withoutOverlapping(); // $schedule->command(BigGiftUserImgDCommand::class)->dailyAt('11:17'); $schedule->command(BigGiftUserImgCommand::class)->dailyAt('11:17'); // $schedule->command(SynOrderCommand::class)->everyMinute()->withoutOverlapping(); // $schedule->command(SynOrderCommand::class)->everyMinute()->withoutOverlapping(); $schedule->call(function (){ ini_set('memory_limit', '-1'); $in=DataInfo::where('status',0)->get(); foreach ($in as $k=>$v){ $this->DelOrder(json_decode($v->data,true),$v->url); DataInfo::where('id',$v->id)->update(['status'=>1]); } })->everyMinute(); $schedule->call(function (){ $re=DB::connection('mysql_w') ->table('data_or_user') // ->where('id','<','3872') ->where('status',0) ->where('created_at','>',Carbon::now()->startOfDay()->toDateTimeString()) ->get(); if ($re->count()==0) { Log::error('没有了'); } foreach ($re as $k=>$v){ $string=$v->data; $customKey = base64_decode('RUFBOTI3OTdGNEVEQTgwOUQyM0YzMUZDRDY1MTIwRkM'); // 从第一个项目获取的密钥(需要解码) $encryptedData = $string; // 加密后的数据 $encrypter = new Encrypter($customKey, config('app.cipher')); // cipher 通常是 AES-256-CBC $decryptedData = $encrypter->decryptString($encryptedData); $arr=json_decode($decryptedData,true); $url=UrlList::where('url',mb_substr($arr['Domain'],0,-1))->first(); $token=$this->getToekn($url->url,$url->id); $client=new Client(); $re=$client->post($url->url.'/api/Admin/CustomerCompanyList/GetCustomerDetail',[ 'headers' => [ 'Content-Type' => 'application/json', // 设置请求头 'Auth-AdminToken' => $token, // 如果需要身份验证令牌 ], 'json'=>['ID'=>$arr['CustomerID']] ]); $res=$re->getBody()->getContents(); $info=json_decode($res,true); $data_info=$info['data']; $mobile=$data_info['Telephone']; $name=$data_info['Name']; $code=$data_info['CustomerBrandDetail'][0]['AuthorizationCode']; $level=$data_info['CustomerBrandDetail'][0]['BrandLevelName']; if ($arr['Type']==2){ DB::connection('mysql_z') ->table('base_users') ->where('code',$code) ->update(['deleted_at'=>Carbon::now()->toDateTimeString()]); $remark='用户删除'; }else{ $user=DB::connection('mysql_z') ->table('base_users') ->where('code',$code) ->first(); if ($level=='经销商'){ $g=2; }elseif ($level=='批发商'){ $g=3; }else{ $g=2; } $remark='用户存在'; if (!$user){ $remark='用户导入'; $customKey = base64_decode('ikvRFbC6TDfmDDJw/rpYghnneWQ4Kz9KzXP7Nxq8GOM='); // 从第一个项目获取的密钥(需要解码) $decrypt = new Encrypter($customKey, config('app.cipher')); // cipher 通常是 AES-256-CBC $encryptData = $decrypt->encryptString($mobile); $insert_user=[ 'nickname'=>$name, 'mobile'=>mb_substr($mobile,0,3).'****'.mb_substr($mobile,-4), 'mobile_code'=>'+86', 'group_id'=>$g, 'mobile_encryption'=>$encryptData, 'created_at'=>Carbon::now()->toDateTimeString(), 'updated_at'=>Carbon::now()->toDateTimeString(), 'code'=>$code ]; DB::connection('mysql_z') ->table('base_users') ->insert($insert_user); } } DB::connection('mysql_w') ->table('data_or_user') ->where('id',$v->id) ->update(['status'=>1,'remark'=>$remark]); } })->everyMinute() ->name('insert_users') ->withoutOverlapping(); $schedule->call(function (){ // $url='http://hnsystemfo.quzhouoy.top'; //// $url_list=UrlList::where('id','>',1)->where('url',$url)->get(); //// foreach ($url_list as $k=>$v){ //// $this->getToekn($v->url,$v->id); //// } // // $zz=new SynOrderController(); // // $id=1146; // $zz->SearchOrder($url,$id); })->everyMinute(); // $schedule->call(function (){ // $data=Order::where('created_at','>','2024-08-27 09:00:00') // ->where('created_at','<','2024-08-29 21:00:00') // ->select('user_id',DB::raw('SUM(money) as money')) // ->where('is_deleted',0)->groupBy('user_id')->get(); // foreach ($data as $k=>$v){ // if ($v->money>=300000){ // $pay_money=Order::where('created_at','>','2024-08-27 09:00:00') // ->where('created_at','<','2024-08-29 21:00:00') // ->where('user_id',$v->user_id) // ->where('is_deleted',0)->sum('pay_money'); // //折扣金额 // $money=$v->money*0.95; // if ($money==$pay_money){ // Order::where('created_at','>','2024-08-27 09:00:00') // ->where('created_at','<','2024-08-29 21:00:00') // ->where('user_id',$v->user_id) // ->where('is_deleted',0)->update(['pay_status'=>2]); // }elseif($money<$pay_money){ // Order::where('created_at','>','2024-08-27 09:00:00') // ->where('created_at','<','2024-08-29 21:00:00') // ->where('user_id',$v->user_id) // ->where('is_deleted',0)->update(['pay_status'=>2]); // } // // } // } // })->everyMinute(); // $schedule->call(function (){ // Log::error('kaishi'); // $data=Order::where('is_deleted',0)->get(); // //// $arr=['精装','高腰','青春']; // foreach ($data as $k=>$v){ //// $detail=OrderDetail::where('order_id',$v->id)->get(); // // $hard=OrderDetail::where('order_id',$v->id)->where('goods_name','like',"%精装%")->sum('num'); // $gaoyao=OrderDetail::where('order_id',$v->id)->where('goods_name','like',"%高腰%")->sum('num'); // $qingchun=OrderDetail::where('order_id',$v->id)->where('goods_name','like',"%青春%")->sum('num'); // // $gift_ka=$hard+$gaoyao*2+$qingchun*6; // // $num=$hard+$gaoyao*2+$qingchun*2; // // $gift_xl=intval($num/6); // // // if ($gift_xl>0){ // $re=new OrderGift(); // $re->order_id=$v->id; // $re->gift_id=10; // $re->num=$gift_xl; // $re->activity_id=8; // $re->save(); // } // // if ($gift_ka>0){ // $res=new OrderGift(); // $res->order_id=$v->id; // $res->gift_id=11; // $res->num=$gift_ka; // $res->activity_id=8; // $res->save(); // } // } // Log::error('结束'); // })->dailyAt('15:43'); // $schedule->call(function (){ // $arr=UrlList::where('id','>',1)->get(); // foreach ($arr as $k=>$v){ // $client=new Client(); // // $re=$client->post($v->url.'/api/Admin/System/MainSubLogin',[ // 'headers' => [ // 'Content-Type' => 'application/json', // 设置请求头 //// 'Auth-AdminToken' => 'SjI5Ym5US0xZVzZjSVd4V1FheHg4VG5hL1dpWDJwVi82RDdMY09WU3NTeENIdmJUdmxxTEFVOHZSZkRiaXM1c3RuYUlZTGVIcmI2NGlUdXJ4MXZ6dkREWmRoY283UG5TclQ2RnI5amV3UGYzYjBjNkZ0RTFzUElzRzRhV2F1d0M=', // 如果需要身份验证令牌 // ], // 'json'=>['UserName'=>'dwadmin','Password'=>'zS76UMV9'] // ]); // $res=$re->getBody()->getContents(); // $info=json_decode($res,true); // $urlinfo=UrlList::find($v->id); // Log::error($res); // Log::error($info); // // $token=$info['data']['accessToken']; // $urlinfo->token=$token; // $urlinfo->save(); //// if (!$info['errcode']){ //// //// }else{ //// Log::error($urlinfo->name.'生成token出错===='.$info['errcode']); //// } // } // $arr=UrlList::where('id','>',1)->get(); // foreach ($arr as $k=>$v){ // $json='{"BrandID":1,"BrandLevel":1,"BrandState":"0","TeamID":0,"AuthorizationCode":"","AuthorizationTimeStart":"","AuthorizationTimeEnd":"","CreateTimeStart":"","CreateTimeEnd":"","Name":"","WeChat":"","Phone":"","IdentityCard":"","UserName":"","IsChina":"","AddrID":"","AddressDetail":"","CustomerFieldValue":[],"CustomerBrandFieldValue":[],"PageNo":1,"PageSize":10,"Sort":"CreateTime","IsAsc":false,"CustomerParentName":"","CustomerParentPhone":"","ParentAuthorizationCode":"","SuperiorName":"","SuperiorPhone":"","SuperiorAuthorizationCode":"","MemberType":"","BusinessContactName":"","BusinessInfoQuery":{"BusinessType":"","RegisteredCapital":"","BusinessScope":"","RegisterCode":"","LegalPerson":""},"AccuracyQueryKey":[]}'; // $client=new Client(); // $data=json_decode($json,true); // $data['PageSize']=200; // // $re=$client->post($v->url.'/api/Admin/CustomerCompanyList/Comput_GetCustomerBrandQuery',[ // 'headers' => [ // 'Content-Type' => 'application/json', // 设置请求头 // 'Auth-AdminToken' => $v->token, // 如果需要身份验证令牌 // ], // 'json'=>$data // ]); // $res=$re->getBody()->getContents(); // $info=json_decode($res,true); // Log::error($info); // $arrs=$info['data']['Models']; // // if ($arrs){ // foreach ($arrs as $ke=>$va){ // $Sourcemobile=$va['Telephone']; // $Sourcenickname=$va['Name']; // $Sourcecode=$va['AuthorizationCode']; // $user=User::where('auth_code',$va['AuthorizationCode'])->first(); // if (!$user){ // $user=new User(); // $user->name=$Sourcenickname; // $user->nickname=$Sourcenickname; // $user->realname=$Sourcenickname; // $user->remark_name=$Sourcenickname; // $user->mobile=$Sourcemobile; // $user->uuid=$Sourcemobile; // $user->auth_code=$Sourcecode; // $user->level=3; // $user->url=$v->url; // $user->save(); // } // } // } // // } // dd(1); // })->everyMinute(); // $schedule->call(function (){ // $this->shenhe(); // })->dailyAt('13:30'); // $schedule->call(function (){ // $data=Order::where('created_at','>','2024-11-05 09:00:00') // ->where('created_at','<','2024-11-08 12:20:00') // // ->select('user_id',DB::raw('SUM(money) as money'),DB::raw('SUM(pay_money) as pay_money')) // ->where('is_deleted',0)->groupBy('user_id')->get(); // foreach ($data as $k=>$v){ // if ($v->money>=300000){ // if ($v->money*0.95 <=$v->pay_money){ // Order::where('created_at','>','2024-11-05 09:00:00') // ->where('created_at','<','2024-11-08 13:20:00') // ->where('user_id',$v->user_id) // ->where('is_deleted',0) // ->update(['pay_status'=>2]); // } // } // } // })->dailyAt('13:37'); // $schedule->call(function (){ // $data=Order::where('created_at','>','2024-11-05 09:00:00') // ->where('created_at','<','2024-11-08 12:20:00') // ->select('user_id',DB::raw('SUM(money) as money')) //// ->where('user_id',14836) // ->where('is_deleted',0)->groupBy('user_id')->get(); // foreach ($data as $k=>$v){ // if ($v->money>=300000){ // $pay_money=Order::where('created_at','>','2024-11-05 09:00:00') // ->where('created_at','<','2024-11-08 12:20:00') // ->where('user_id',$v->user_id) // ->where('is_deleted',0)->sum('pay_money'); // //折扣金额 // $money=$v->money*0.95; // if($money<$pay_money){ // $cha_money=$pay_money-$money; // if ($cha_money>0){ // $order_moneu=Order::where('created_at','>','2024-11-05 09:00:00') // ->where('created_at','<','2024-11-08 12:20:00') // ->where('user_id',$v->user_id) // ->where('is_deleted',0) // ->orderByDesc('money')->first(); // $pay_num=$this->pay_num($v->user_id); // $user_money=User::find($v->user_id); // $user_money->money+=$cha_money; // $user_money->save(); // //支付日志 // $arr=[ // 'user_id'=>$v->user_id, // 'remark'=>'订单编号为' . $order_moneu->order_num.'满九五折,退款:'.$cha_money, // 'op_name'=>'系统自动退款', // 'type'=>2, // 'created_at'=>Carbon::now()->toDateTimeString(), // 'updated_at'=>Carbon::now()->toDateTimeString(), // 'order_num'=>$order_moneu->order_num, // 'pay_num'=>$pay_num, // 'pay_money'=>$cha_money, // 'user_money'=>$user_money->money // ]; // DB::table('user_pay_log')->insert($arr); // Order::where('id',$order_moneu->id) // ->update(['pay_money'=>$order_moneu->pay_money-$cha_money,'no_pay_money'=>$order_moneu->no_pay_money+$cha_money]); // } // } // } // } // Log::error('九五折退款'); // })->dailyAt('17:35'); } /** * Register the commands for the application. * * @return void */ protected function commands() { $this->load(__DIR__.'/Commands'); require base_path('routes/console.php'); } //支付单号 public function pay_num($user_id) { $num = date('Ymd', time()) . '100000' . str_pad($user_id, 6, 0, STR_PAD_LEFT) . rand(11111, 99999); return $num; } protected function shenhe(){ $url_list=UrlList::where('id','>',1)->get(); foreach ($url_list as $k=>$v){ $token=$this->getToekn($v->url,$v->id); $order=Order::where('status',3) ->where('created_at','>','2024-10-18') ->where('url',$v->url)->get(); foreach ($order as $ke=>$va){ $client=new Client(); $url = $v->url.'/api/Admin/CompanyCustomerOrderSubmit/OrderReviewSuccess'; $data=['ID'=>$va->ZDL_id]; $re=$client->post($url,[ 'headers' => [ 'Content-Type' => 'application/json', // 设置请求头 'Auth-AdminToken' => $token, // 如果需要身份验证令牌 ], 'json'=>$data ]); $res=$re->getBody()->getContents(); $info=json_decode($res,true); Log::error($info); } } } protected function DelOrder($arr,$url){ // Log::error($arr); if (!$arr){ return; } $activity_id=Activity::where('is_ing',1)->value('id'); foreach ($arr as $k=>$v){ if ($v['Packages']!=1 && $v['Packages'] !=0){ Log::info($v['Code']); break; } //批发商 $Sourcemobile=$v['SourceCustomerModel']['Telephone']; $Sourcenickname=$v['SourceCustomerModel']['CustomerName']; $Sourcecode=$v['SourceCustomerModel']['AuthorizationCode']; $user=User::where('auth_code',$Sourcecode)->first(); Log::info($Sourcecode); if (!$user){ $user=new User(); $user->name=$Sourcenickname; $user->nickname=$Sourcenickname; $user->realname=$Sourcenickname; $user->remark_name=$Sourcenickname; $user->mobile=$Sourcemobile; $user->uuid=$Sourcemobile; $user->auth_code=$Sourcecode; $user->level=3; $user->url=$url; $user->save(); } $TopCode=$v['TopCustomerModel']['AuthorizationCode']; $belongUser=User::where('auth_code',$TopCode)->first(); if (!$belongUser){ //经销商 $belongUser=new User(); $belongUser->name=$v['TopCustomerModel']['CustomerName']; $belongUser->nickname=$v['TopCustomerModel']['CustomerName']; $belongUser->realname=$v['TopCustomerModel']['CustomerName']; $belongUser->remark_name=$v['TopCustomerModel']['CustomerName']; $belongUser->mobile=$v['TopCustomerModel']['Telephone']; $belongUser->uuid=$v['TopCustomerModel']['Telephone']; $belongUser->auth_code=$TopCode; $belongUser->level=2; $belongUser->url=$url; $belongUser->save(); } $order_num=$v['Code']; Log::info($order_num); $order=Order::where('order_num',$order_num)->first(); if ($order){ if ($v['State']==7 || $v['State']==6){ if (!$order->is_deleted){ $order->wait_back_money=$order->pay_money; $order->pay_status=3; } $order->is_deleted=1; $order->save(); break; } $address=Address::where('id',$order->address_id)->first(); $address->user_id=$user->id; $address->username=$v['AddressDetail']['Name']; $address->mobile=$v['AddressDetail']['Phone']; $address->province=$v['AddressDetail']['Province']; $address->city=$v['AddressDetail']['City']; $address->town=$v['AddressDetail']['District']; $address->address=$v['AddressDetail']['Address']; $address->type=0; $address->save(); if ($order->money!=$v['TotalCash']){ OrderDetail::where('order_id',$order->id)->delete(); } $order->money=$v['TotalCash']; if ($order->money==$order->pay_money){ $order->no_pay_money=0;//未支付变为0 $order->pay_status=2;//支付状态2,为全部支付 $order->wait_back_money=0;//待退回金额为0 }elseif ($order->money<$order->pay_money){//订单金额小于支付金额 $order->no_pay_money=0;//未支付金额变为0 $order->pay_status=3;//支付状态3,待退款状态 $order->wait_back_money=$order->pay_money-$order->money;//待退款金额为支付金额减去订单金额 }elseif ($order->money>$order->pay_money){//订单金额大于支付金额 if ($order->pay_money==0){//如果支付金额为0 $order->pay_status=0;//则支付状态0,未支付 }else{ $order->pay_status=1;//否则支付状态1,部分支付 } $order->no_pay_money=$order->money-$order->pay_money;//未支付金额等于订单金额减去支付金额 $order->wait_back_money=0;//待退款为0 } $order->total=$v['TotalQty']; $order->State=$v['State']; $order->save(); $detail=$v['OrderDetailOutput']; $activity_status=false; $orderdrtail_id=[]; foreach ($detail as $ke=>$va){ if ($va['IsGift']){ $activity_status=true; $gift_name=$va['ProductName']; $num=$va['Qty']; $gift=Gifts::where('name',$gift_name)->where('activity_id',$activity_id)->first(); $ordergift=OrderGift::where('order_id',$order->id) ->where('gift_id',$gift->id)->first(); if (!$ordergift){ $ordergift=new OrderGift(); } $order->total-=$num; $order->save(); $ordergift->gift_id=$gift->id; $ordergift->order_id=$order->id; $ordergift->activity_id=$activity_id; $ordergift->num=$num; $ordergift->limit_num=1; $ordergift->save(); }else{ // Log::error($va); $GroupID=$va['ProductGroupSKUID']; $num=$va['Qty']; $goods=Goods::where('groupID',$GroupID)->first(); if (!$goods){ Log::error('不存在该商品'.$GroupID); } $orderDetail=OrderDetail::where('order_id',$order->id) ->where('goods_id',$goods->id)->first(); if (!$orderDetail){ $orderDetail=new OrderDetail(); } $orderDetail->order_id=$order->id; $orderDetail->goods_id=$goods->id; $orderDetail->num=$num; $orderDetail->goods_price=$va['Price']; $orderDetail->money=$num*$va['Price']; $orderDetail->goods_name=$goods->name; $orderDetail->goods_size=$goods->size; $orderDetail->goods_unit=$goods->unit; $orderDetail->goods_sku=$va['SKUCode']; $orderDetail->save(); $order_id[]=$orderDetail->id; } } // $order->is_deleted=0; // $order->wait_back_money=$order->pay_money; // $order->save(); }else{ $address=new Address(); $address->user_id=$user->id; $address->username=$v['AddressDetail']['Name']; $address->mobile=$v['AddressDetail']['Phone']; $address->province=$v['AddressDetail']['Province']; $address->city=$v['AddressDetail']['City']; $address->town=$v['AddressDetail']['District']; $address->address=$v['AddressDetail']['Address']; $address->type=0; $address->uid=$belongUser->id; $address->save(); $order=new Order(); $order->order_num=$order_num; $order->money=$v['TotalCash']; $order->no_pay_money=$v['TotalCash']; $order->user_id=$user->id; $order->total=$v['TotalQty']; $order->created_at=$v['CreateDate']; $order->ZDL_id=$v['CustomerOrderID']; $order->url=$url; $order->State=$v['State']; $order->address_id=$address->id; $order->good_user_id=$belongUser->id; if ($v['State']=='7'){ $order->is_deleted=1; } $order->save(); $detail=$v['OrderDetailOutput']; $activity_status=false; foreach ($detail as $ke=>$va){ if ($va['IsGift']){ $activity_status=true; $gift_name=$va['ProductName']; $num=$va['Qty']; $gift=Gifts::where('name',$gift_name)->where('activity_id',$activity_id)->first(); $ordergift=new OrderGift(); $ordergift->gift_id=$gift->id; $ordergift->order_id=$order->id; $ordergift->activity_id=$activity_id; $ordergift->num=$num; $ordergift->limit_num=1; $ordergift->save(); $order->total-=$num; $order->save(); }else{ $GroupID=$va['ProductGroupSKUID']; $num=$va['Qty']; $goods=Goods::where('groupID',$GroupID)->first(); if (!$goods){ Log::error('不存在该商品'.$GroupID); } $orderDetail=new OrderDetail(); $orderDetail->order_id=$order->id; $orderDetail->goods_id=$goods->id; $orderDetail->num=$num; $orderDetail->goods_price=$va['Price']; $orderDetail->money=$num*$va['Price']; $orderDetail->goods_name=$goods->name; $orderDetail->goods_size=$goods->size; $orderDetail->goods_unit=$goods->unit; $orderDetail->goods_sku=$va['SKUCode']; $orderDetail->save(); } } if ($activity_status){ $order->activity_id=$activity_id; $order->save(); } } } } protected function getToekn($url,$id){ $client=new Client(); $re=$client->post($url.'/api/Admin/System/MainSubLogin',[ 'headers' => [ 'Content-Type' => 'application/json', // 设置请求头 // 'Auth-AdminToken' => 'SjI5Ym5US0xZVzZjSVd4V1FheHg4VG5hL1dpWDJwVi82RDdMY09WU3NTeENIdmJUdmxxTEFVOHZSZkRiaXM1c3RuYUlZTGVIcmI2NGlUdXJ4MXZ6dkREWmRoY283UG5TclQ2RnI5amV3UGYzYjBjNkZ0RTFzUElzRzRhV2F1d0M=', // 如果需要身份验证令牌 ], 'json'=>['UserName'=>'dwadmin','Password'=>'zS76UMV9'] ]); $res=$re->getBody()->getContents(); $info=json_decode($res,true); $urlinfo=UrlList::find($id); // Log::error($res); // Log::error($info); if (!$info['errcode']){ $token=$info['data']['accessToken']; $urlinfo->token=$token; $urlinfo->time=time()+9*60; $urlinfo->save(); return $token; }else{ Log::error($urlinfo->name.'生成token出错===='.$info['errcode']); return 0; } } }