123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679 |
- <?php
- namespace App\Http\Controllers;
- use App\Events\CancelOrderEvent;
- use App\Events\EnoughFive;
- use App\Events\FinishAccount;
- use App\Events\AuthRefundTip;
- use App\Events\HelpOrderEvent;
- use App\Events\NewOrder;
- use App\Events\ReceivingEvent;
- use App\Events\RetailOutboundEvent;
- use App\Events\RestoreOutboundEvent;
- use App\Events\TipSendingEvent;
- use App\Events\TipPickUpEvent;
- use App\Http\Controllers\MiniSubController as Mini;
- use App\Models\Admin;
- use App\Models\Amount;
- use App\Models\BindRecomLog;
- use App\Models\OrderExpressW;
- use App\Models\AgentNo;
- use App\Models\ShowNumW;
- use App\Models\Verify;
- use App\Models\Warea;
- use App\Models\Select;
- use App\Models\OrderCancelW;
- use App\Models\OrderCodeW;
- use App\Models\OrderDetail;
- use App\Models\OrderRefund;
- use App\Models\OrderRefundW;
- use App\Models\VipLog;
- use App\Models\VipLogW;
- use App\Models\SettingW;
- use Carbon\Carbon;
- use Overtrue\EasySms\EasySms;
- use App\Handlers\RefundAmount;
- use App\Handlers\ExpressHandler;
- use App\Handlers\TencentHandler;
- use App\Handlers\UploadImg;
- use App\Models\Comment;
- use App\Models\Order;
- use App\Models\StoreGoods;
- use App\Models\InventoryW;
- use App\Models\IntegralW;
- use App\Models\See;
- use App\Models\Scan;
- use App\Models\User;
- use App\Models\Store;
- use App\Models\UserW;
- use App\Models\UserZ;
- use App\Models\OrderW;
- use App\Models\OrderShareW;
- use App\Models\TestUserW;
- use App\Models\AddressW;
- use App\Models\ZbsBasic;
- use App\Models\ZbsEnroll;
- use App\Models\OrderDetailW;
- use App\Models\StoreGoodsSku;
- use Illuminate\Http\Request;
- use Intervention\Image\Facades\Image;
- use EasyWeChat\Factory;
- use GuzzleHttp\Client;
- use Illuminate\Support\Facades\Auth;
- use Illuminate\Support\Facades\Config;
- use Illuminate\Support\Facades\Crypt;
- use Illuminate\Support\Facades\Log;
- use DB;
- use Storage;
- use Cache;
- use Validator;
- use TencentCloud\Common\Credential;
- use TencentCloud\Common\Profile\ClientProfile;
- use TencentCloud\Common\Profile\HttpProfile;
- use TencentCloud\Common\Exception\TencentCloudSDKException;
- use TencentCloud\Ocr\V20181119\OcrClient;
- use TencentCloud\Ocr\V20181119\Models\IDCardOCRRequest;
- use SimpleSoftwareIO\QrCode\Facades\QrCode;
- use Qiniu\Auth as Auths;
- use Qiniu\Storage\UploadManager;
- use Qiniu\Storage\BucketManager;
- use App\Handlers\CompressImageHandler;
- use Illuminate\Contracts\Encryption\DecryptException;
- class StoreController extends Controller{
- //获取店铺信息
- public function getStoreInfo()
- {
- $user_id=Auth::user()->id;
- $user=User::where('id',$user_id)->first();
- $data['is_delete'] = 0;
- if(!empty($user->deleted_at)){
- //获取账号余额
- $sub_mchid=Store::withTrashed()->where('is_failure',0)->where('user_id', $user_id)->value('sub_mchid');
- $mini=new Mini();
- $result=$mini->getAccount($sub_mchid);
- Log::info('------------------------------------------------------------------------------');
- Log::info($result);
- if($result['pending_amount']+$result['available_amount']==0){
- Log::info($user->mobile.'///'.$user->deleted_at.'///'.$result['pending_amount'].'///'.$result['available_amount']);
- return $this->error('450005','该商户账号已被删除');
- }
- $data['is_delete'] = 1;
- $store=Store::withTrashed()->where('is_failure',0)->where('is_failure',0)->where('user_id',Auth::user()->id)->first();
- }else{
- //正式版
- if($user->status==1){
- return $this->error('450001','该用户已被禁用');
- }
- if($user->cert_status <> 3){
- if($user->cert_status <> 6){
- return $this->error('450001','该账号未完成账号审核');
- }
- }
- if($user->service_status <> 0){
- return $this->error('450001','该账号未完成审核');
- }
- if($user->in_group!=1){
- return $this->error('450001','该用户未完成客服审核');
- }
- if($user->freeze_status==1){
- return $this->error('450001','该用户已被冻结');
- }
- // if($user->status <> 0 || $user->cert_status <> 6 || $user->service_status <> 0){// || !empty($user->deleted_at)
- // return $this->error('450002','你无权访问该页面');
- // }
- $store=Store::where('user_id',Auth::user()->id)->first();
- $store_del=Store::withTrashed()->where('is_failure',0)->where('user_id',Auth::user()->id)->first();
- if(empty($store) && !empty($store_del)){
- return $this->error('450001','店铺已被删除');
- }
- if(empty($store) && empty($store_del)){
- Store::create([
- 'img'=>$user->headimgurl,
- 'name'=>$user->nickname,
- 'user_id'=>$user->id,
- 'phone'=>$user->mobile
- ]);
- $store=Store::where('user_id',Auth::user()->id)->first();
- }
- if($store->status==1){
- return $this->error('450004','店铺已禁用');
- }
- }
- $arr_test=Store::getTest();
- if($user->headimgurl != $store->img){
- Log::info($store->img);
- $store->img=$user->headimgurl;
- }
- if($user->mobile != $store->phone){
- $store->phone=$user->mobile;
- }
- if($user->nickname != $store->name){
- $store->name=$user->nickname;
- }
- if($user->warea_id != $store->warea_id){
- $store->warea_id=$user->warea_id;
- $store->warea_name=Warea::where('id',$user->warea_id)->value('name');
- }
- $store->save();
- if(in_array($store->id,$arr_test)){
- $store->is_test=1;
- }else{
- $store->is_test=0;
- }
- //测试跳转小程序
- if(in_array($user->mobile,['15138929587','15238617326','13030314383','18838980968'])){
- $user->mini_zbs=1;
- }else{
- $user->mini_zbs=0;
- }
- $no_pay=OrderW::where('store_id',$store->id)->where('is_pay',0)->where('apply_cancel',[0,1,3])->count();
- $no_refund=OrderRefundW::where('store_id',$store->id)->where('status',0)->count();
- $no_cancel=OrderCancelW::where('store_id',$store->id)->where('status',1)->count();
- $see_num=See::where('store_id',$store->id)->whereDate('created_at',date('Y-m-d'))->count();
- $order_num=OrderW::where('store_id',$store->id)->whereIn('apply_cancel',[0,1,3])->whereIn('is_refund',[0,1])
- ->where('is_pay',1)->whereDate('created_at',date('Y-m-d'))->count();
- $order_money=OrderW::where('store_id',$store->id)->whereIn('apply_cancel',[0,1,3])->whereIn('is_refund',[0,1])
- ->where('is_pay',1)->whereDate('created_at',date('Y-m-d'))->sum('account');
- $wait_send_num=OrderW::where('store_id',$store->id)->whereIn('apply_cancel',[0,1,3])->whereIn('is_refund',[0,1,2])
- ->where('is_pay',1)->where('status',1)->count();
- $show_num=ShowNumW::where('obj_id',$store->id)->where('obj_type',1)->where('type',1)->first();
- $data['show_num1']=0;
- if($show_num){
- if($show_num->num < 3){
- $data['show_num1']=1;
- $show_num->num += 1;
- $show_num->save();
- }
- }else{
- ShowNumW::create([
- 'obj_id'=>$store->id,
- 'obj_type'=>1,
- 'type'=>1,
- 'name'=>'首页操作视频',
- 'num'=>1,
- ]);
- }
- $order_money=round($order_money);
- // $data['user']=$user;
- $data['store']=$store;
- $data['wait_send_num']=$wait_send_num?$wait_send_num:0;
- $data['order_num']=$order_num?$order_num:0;
- $data['see_num']=$see_num?$see_num:0;
- $data['order_money']=$order_money?$order_money:'0';
- $data['no_pay']=$no_pay?$no_pay:'0';
- $data['no_auth']=$no_refund+$no_cancel;
- $home_operation_video=SettingW::where('key','home.operation.video')->value('value');
- $data['home_operation_video']=$home_operation_video;
- return $this->success($data);
- }
- public function getZbsRank()
- {
- $zbs['type']=2;
- $zbs['message']='没有';
- return $this->success($zbs);
- }
- public function getStoreData(){
- $user_id=Auth::user()->id;
- $user=User::where('id',$user_id)->first();
- $store=Store::where('user_id',Auth::user()->id)->first();
- if($user->headimgurl != $store->img){
- Log::info($store->img);
- $store->img=$user->headimgurl;
- $store->save();
- }
- if($user->mobile != $store->phone){
- $store->phone=$user->mobile;
- $store->save();
- }
- if($user->nickname != $store->name){
- $store->name=$user->nickname;
- $store->save();
- }
- $no_pay=OrderW::where('store_id',$store->id)->where('is_pay',0)->where('apply_cancel',[0,1,3])->count();
- $no_refund=OrderRefundW::where('store_id',$store->id)->where('status',0)->count();
- $no_cancel=OrderCancelW::where('store_id',$store->id)->where('status',1)->count();
- $see_num=See::where('store_id',$store->id)->whereDate('created_at',date('Y-m-d'))->count();
- $order_num=OrderW::where('store_id',$store->id)->whereIn('apply_cancel',[0,1,3])->whereIn('is_refund',[0,1])
- ->where('is_pay',1)->whereDate('created_at',date('Y-m-d'))->count();
- $order_money=OrderW::where('store_id',$store->id)->whereIn('apply_cancel',[0,1,3])->whereIn('is_refund',[0,1])
- ->where('is_pay',1)->whereDate('created_at',date('Y-m-d'))->sum('account');
- $wait_send_num=OrderW::where('store_id',$store->id)->whereIn('apply_cancel',[0,1,3])->whereIn('is_refund',[0,1,2])
- ->where('is_pay',1)->where('status',1)->count();
- $order_money=round($order_money);
- $data['user']=$user;
- $data['store']=$store;
- $data['wait_send_num']=$wait_send_num?$wait_send_num:0;
- $data['order_num']=$order_num?$order_num:0;
- $data['see_num']=$see_num?$see_num:0;
- $data['order_money']=$order_money?$order_money:'0';
- $data['no_pay']=$no_pay?$no_pay:'0';
- $data['no_auth']=$no_refund+$no_cancel;
- return $this->success($data);
- }
- //获取商户个人信息
- public function getAgentInfo(){
- $store = Store::where('user_id',Auth::user()->id)->first();
- if(empty($store->idCard)){
- return $this->error('450001','店铺未认证');
- }
- $cre_num=$store->idCard;
- $year=substr($cre_num,6,4);
- if($year>1920 && $year<2020) {
- $year .= '-01-01';
- $age = Carbon::parse($year)->diffInYears();
- }else{
- $age = 0;
- }
- $num=substr($cre_num,16,1);
- if($num%2==0){
- $sex = '女';
- }else{
- $sex = '男';
- }
- $name=$store->username;
- $phone=$store->phone;
- switch(Auth::user()->level){
- case 2:
- $level='经销商';
- break;
- case 3:
- $level='批发商';
- break;
- default:
- $level='经销商';
- }
- $data=['username'=>$name,'sex'=>$sex,'age'=>$age,'phone'=>$phone,'level'=>$level,'cre_num'=>$cre_num];
- return $this->success($data);
- }
- //同意门店协议
- // public function setAgree()
- // {
- // $store=Store::where('user_id',Auth::user()->id)->first();
- // $store->is_agree=1;
- // $res=$store->save();
- // if($res){
- // return $this->success([]);
- // }else{
- // return $this->error();
- // }
- // }
- //修改店铺信息
- public function editStoreInfo(Request $request)
- {
- $input=$request->all();
- $rules=[
- 'name'=>'required|max:32'
- ];
- $message=[
- 'name.required'=>'用户名称不能为空.',
- 'name.max'=>'用户名称不能大于32个字符.'
- ];
- $validator = Validator::make($input,$rules,$message);
- if($validator->fails()){
- return $this->error('400013',$validator->errors()->first());
- }
- $store_id=$input['store_id'];
- $name=$input['name'];
- $res=Store::where('id',$store_id)->update(['name'=>$name]);
- if($res){
- return $this->success([]);
- }else{
- return $this->error();
- }
- }
- //修改手机号
- public function editSms(Request $request)
- {
- $rules=[
- 'phone'=>'required|regex:/^1[3456789][0-9]{9}$/',
- 'phone_code'=>'required|size:6',
- ];
- $message=[
- 'phone.required'=>'手机号不能为空.',
- 'phone.regex'=>'手机号格式有误.',
- 'phone_code.required'=>'验证码不能为空.',
- 'phone_code.size'=>'验证码为6位字符串.',
- ];
- $validator = Validator::make($request->input(),$rules,$message);
- if($validator->fails()){
- return $this->error('400013',$validator->errors()->first());
- }
- $phone=$request->input('phone');
- if($phone == Store::where('user_id',Auth::user()->id)->value('phone')){
- return $this->error('450001','新手机号不能与旧手机号相同');
- }
- if(Store::where('phone',$phone)->first()){
- return $this->error('450001','新手机号已绑定店铺');
- }
- $store_id=$request->input('store_id');
- $phone_code=$request->input('phone_code');
- $code=Cache::get('sms'.$phone);
- if($code==$phone_code){
- Cache::put('sms'.$phone,$code,-1);
- $res=Store::where('id',$store_id)->update(['phone'=>$phone]);
- if($res){
- return $this->success([]);
- }
- }else{
- return $this->error('450001','验证码有误');
- }
- return $this->error();
- }
- //校验手机验证码
- public function checkSms(Request $request)
- {
- $rules=[
- 'phone'=>'required|regex:/^1[3456789][0-9]{9}$/',
- 'phone_code'=>'required|size:6',
- ];
- $message=[
- 'phone.required'=>'手机号不能为空.',
- 'phone.regex'=>'手机号格式有误.',
- 'phone_code.required'=>'验证码不能为空.',
- 'phone_code.size'=>'验证码为6位字符串.',
- ];
- $validator = Validator::make($request->input(),$rules,$message);
- if($validator->fails()){
- return $this->error('400013',$validator->errors()->first());
- }
- $phone=$request->input('phone');
- $phone_code=$request->input('phone_code');
- $code=Cache::get('sms'.$phone);
- if($code==$phone_code){
- Cache::put('sms'.$phone,$code,-1);
- return $this->success([]);
- }else{
- return $this->error('450001','验证码有误');
- }
- }
- //发送验证码
- public function sendSms(Request $request){
- $rules=[
- 'phone'=>'required|regex:/^1[3456789][0-9]{9}$/'
- ];
- $message=[
- 'phone.required'=>'手机号不能为空.',
- 'phone.regex'=>'手机号格式有误.'
- ];
- $validator = Validator::make($request->input(),$rules,$message);
- if($validator->fails()){
- return $this->error('400013',$validator->errors()->first());
- }
- $phone=$request->input('phone');
- $config=config('easysms');
- $easySms = new EasySms($config);
- $code = mt_rand(100000,999999);
- $minute=5;
- if($request->input('type')=='card'){
- $content="【大卫博士】您正在绑定身份信息,{$code}为您的验证码,请于{$minute}分钟内填写。如非本人操作,请忽略本短信。 ";
- }else{
- $content="【大卫博士】您正在换绑手机号,{$code}为您的更换验证码,请于{$minute}分钟内填写。如非本人操作,请忽略本短信。";
- }
- Cache::put('sms'.$phone,$code,$minute*60);
- try{
- $easySms->send($phone, ['content' =>$content ]);
- } catch (\Overtrue\EasySms\Exceptions\NoGatewayAvailableException $exception) {
- $message = $exception->getException('qcloud')->getMessage();
- return $this->error(40013, $message == null ? '短信发送异常' : $message);
- }
- return $this->success([]);
- }
- //分享店铺信息
- public function shareStore()
- {
- $store=Store::where('user_id',Auth::user()->id)->first();
- $store->user=Auth::user();
- return $this->success($store);
- }
- //修改店铺图片
- public function uploadStoreImg(Request $request)
- {
- $path_url = 'public/store';
- $path = $request->file('img')->store($path_url);
- if($path){
- $store_id=$request->input('store_id');
- $url = env('APP_URL').Storage::url($path);
- $res=Store::where('id',$store_id)->update(['img'=>$url]);
- if ($res) {
- return $this->success($url);
- }
- }
- return $this->error();
- }
- //上传证件照片--》压缩 七牛云
- public function uploadCertImgQny(Request $request)
- {
- $type= $request->input('type'); //1人像面 2国徽面
- $file= $request->file('img');
- if (!$request->hasFile('img')) {
- return $this->error('450001','请上传文件');
- }
- //设置文件后缀白名单
- $allowExt = ["jpg","png","jpeg"];
- //获取文件后缀名
- $ext = $file->getClientOriginalExtension();
- //判断文件格式是否正确
- if (empty($ext) || !in_array(strtolower($ext), $allowExt)) {
- return $this->error('450001','不允许上传的文件类型');
- }
- // 获取七牛云配置信息
- $config = [
- 'driver' => 'qiniu',
- 'domain' => 'http://image.chuliu.cc', //七牛域名
- 'access_key' => 'cIbo9JAqHBgO6uw97gT5fJOlEHiTiGrpB84unVEn', //AccessKey
- 'secret_key' => '4f0nTNNrvzOsFc6Rz0GC5DntiJRnk2GcfkyJFNQp', //SecretKey
- 'bucket' => 'daweiboshi-app', //Bucket名字
- 'dirname'=> 'daweiboshi-app'
- ];
- // 构建鉴权对象
- $auth = new Auths($config['access_key'], $config['secret_key']);
- // 生成上传 Token
- $token = $auth->uploadToken($config['bucket']);
- // 初始化 UploadManager 对象并进行文件的上传。
- $uploadMgr = new UploadManager();
- // 文件存储路径key
- $pathname= $config['dirname'].'/'.date('Ymd').'/'.date('His') . uniqid(mt_rand(10000,99999)) .'.'. $ext;
- Log::info('文件大小:'.$_FILES['img']['size']);
- if($_FILES['img']['size'] > 1024*1024){
- $handler= new CompressImageHandler();
- $contents= $handler->Upload();
- if(!$contents){
- return $this->error('450001','图片压缩失败');
- }
- // 调用 UploadManager 的 put 方法进行文件的上传。
- try{
- $uploadMgr->put($token, $pathname, $contents);
- }catch(\Exception $e){
- return $this->error('450001',$e->getMessage(),$e->getMessage());
- }
- }else{
- //获取文件的绝对路径,但是获取到的在本地不能打开
- $filePath = $file->getRealPath();
- // 调用 UploadManager 的 putFile 方法进行文件的上传。
- try{
- $uploadMgr->putFile($token, $pathname, $filePath);
- }catch(\Exception $e){
- return $this->error('450001',$e->getMessage(),$e->getMessage());
- }
- }
- // 获取文件完整路径
- $url = $config['domain'].'/'.$pathname;
- Log::info($url);
- try{
- $tenCent = new TencentHandler();
- $certInfo=json_decode($tenCent->getCertInfo($url),true);
- }catch(\Exception $e){
- Log::info('图片识别错误111');
- Log::info($e->getMessage());
- return $this->error('450001',$e->getMessage(),$e->getMessage());
- }
- if(empty($certInfo)){
- return $this->error('450001','上传图片有误','上传图片有误');
- }
- $AdvancedInfo=json_decode($certInfo['AdvancedInfo'],true);
- Log::info(Auth::user()->nickname.'身份证图片质量指数:'.$AdvancedInfo['Quality']);
- if($AdvancedInfo['Quality']<=55){
- return $this->error('450001','身份证图片模糊','身份证图片模糊');
- }
- foreach($tenCent->AdvancedInfo() as $key=>$val){
- if(in_array($key,$AdvancedInfo['WarnInfos'])){
- Log::info('111错误111--'.$val);
- return $this->error('450001',$val,$val);
- }
- }
- if($type==1){
- if(empty($certInfo['Name'])){
- return $this->error('450001','请上传人像面图片','请上传人像面图片');
- }else{
- Store::where('user_id',Auth::user()->id)->update(['cardImg1'=>$url]);
- }
- }elseif($type==2){
- if(empty($certInfo['Authority'])){
- return $this->error('450001','请上传国徽面图片','请上传国徽面图片');
- }else{
- Store::where('user_id',Auth::user()->id)->update(['cardImg2'=>$url]);
- }
- }else{
- return $this->error('450001','参数有误','参数有误');
- }
- $certInfo['url']='/'.$pathname;
- return $this->success($certInfo);
- }
- //上传活体人脸核身视频
- public function uploadFaceImg(Request $request){
- $path_url = 'public/cert/video/'.date('ymd');
- $path = $request->file('video')->store($path_url);
- if($path){
- $url = env('APP_URL').Storage::url($path);
- }else{
- return $this->error('450001','视频上传失败');
- }
- try{
- $tenCent = new TencentHandler();
- $certInfo=json_decode($tenCent->checkFaceId($idCard,$name,$url),true);
- }catch(\Exception $e){
- return $this->error('450001',$e->getMessage());
- }
- if(empty($certInfo) || $certInfo['Sim'] < 70){
- return $this->error('450001','认证失败');
- }
- if($certInfo['Result']=='Success' && $certInfo['Sim'] >= 70){
- return $this->success([]);
- }
- }
- //添加新用户
- public function addUser(Request $request){
- $area_code=$request->input('code','+86');
- $regex=Verify::where('code',$area_code)->value('preg');
- $rules=[
- 'phone'=>['required','regex:'.$regex]
- ];
- $message=[
- 'phone.required'=>'手机号不能为空.',
- 'phone.regex'=>'手机号格式有误.'
- ];
- $validator = Validator::make($request->input(),$rules,$message);
- if($validator->fails()){
- return $this->error('400013',$validator->errors()->first());
- }
- $agent_id = Auth::user()->id;
- $phone=$request->input('phone');
- $nickname=$request->input('nickname');
- $is_vip=$request->input('is_vip');
- $store = Store::where('user_id',$agent_id)->first();
- $phxxe=substr($phone,0,3).'****'.substr($phone,'-4');
- $agent=User::where('mobile',$phxxe)
- ->where(function($query){
- $query->where('cert_status',3)
- ->orWhere('cert_status',6);
- })
- ->where('service_status',0)->whereNull('deleted_at')->get();
- $mobiles = [];
- foreach($agent as $val){
- $mobiles[] = Crypt::decryptString($val->uuid);
- }
- if(in_array($phone, $mobiles)){
- return $this->error('450001','该手机号已注册,不能使用');
- }
- Log::info('---------------------0---------------------');
- Log::info($phone);
- $users=UserW::where('phone',$phxxe)->orWhere('phone',$phone)->orderBy('id')->get();
- $user = [];
- try{
- DB::transaction(function()use(&$user,$users,$phone,$nickname,$area_code,$store,$is_vip,$request){
- $client = new Client(['headers' => [
- "User-Agent" => 'Mozilla/5.0(Windows;U;Windows NT 5.1;en-US;rv:0.9.4)',
- "Content-type" => 'application/json'
- ]]);
- $url='https://weidian.cliu.cc/api/crypt/getCryptDataStore';
- $data = [
- 'form_params' => [
- 'users' => $users->toArray(),
- 'phone' => $phone
- ],
- 'timeout' => 300
- ];
- $data=$client->post($url,$data);
- $uuu=$data->getBody()->getContents();
- $uuu = json_decode($uuu, true);
- Log::info('$phone');
- if($uuu && array_key_exists('id', $uuu)){
- $user=UserW::find($uuu['id']);
- }else{
- $user=UserW::create([
- 'area_code'=>$area_code,
- 'phone'=>$phone,
- 'name'=>$nickname?:$phone,
- 'avatar' => 'http://api.app.cliu.cc/public/uploads/logo.jpg',
- 'nickname'=>$nickname?:$phone
- ]);
- }
- Log::info($user);
- $agent_id=Auth::user()->id;
- $store_id=Store::where('user_id',$agent_id)->value('id');
- if($request->input('province') && $request->input('city') && $request->input('area') && $request->input('address')){
- AddressW::create([
- 'name'=>$nickname?:$phone,
- 'area_code'=>$area_code,
- 'phone'=>$phone,
- 'user_id'=>$user->id,
- 'store_id'=>$store_id,
- 'province'=>$request->input('province'),
- 'city'=>$request->input('city'),
- 'area'=>$request->input('area'),
- 'address'=>$request->input('address'),
- 'is_default'=>$request->input('is_default',0),
- 'remark'=>$request->input('remark',null),
- 'type'=>2,
- ]);
- }
- if($is_vip==1){
- $user->is_vip=1;
- VipLogW::firstORCreate(['user_id'=>$user->id,'store_id'=>$store->id],['order_no'=>null,'type'=>1,'remark'=>'商户手动添加vip']);
- }else{
- $user->is_vip=0;
- }
- },5);
- return $this->success($user);
- }catch(\Exception $e){
- Log::info($e->getMessage());
- return $this->error($e->getMessage());
- }
- }
- //设置vip
- public function setVip(Request $request){
- $agent_id=Auth::user()->id;
- $user_id=$request->input('user_id');
- $store_id=Store::where('user_id',$agent_id)->value('id');
- VipLogW::firstORCreate(['user_id'=>$user_id,'store_id'=>$store_id],['order_no'=>null,'type'=>1,'remark'=>'商户手动设置vip']);
- return $this->success([]);
- }
- //取消vip
- public function cancelVip(Request $request){
- $agent_id=Auth::user()->id;
- $user_id=$request->input('user_id');
- $store_id=Store::where('user_id',$agent_id)->value('id');
- $vip=VipLogW::where('store_id',$store_id)->where('user_id',$user_id)->first();
- if(empty($vip)){
- return $this->error('450001','该客户不是vip');
- }
- $orders=OrderW::where('store_id',$store_id)->where('user_id',$user_id)->get();
- if(count($orders)>0){
- return $this->error('450001','该客户已下单,无法取消vip');
- }
- $vip=VipLogW::where('store_id',$store_id)->where('user_id',$user_id)->first();
- $vip->remark=!empty($vip->remark)?$vip->remark.'->商户删除':'商户删除';
- $vip->save();
- $vip->delete();
- return $this->success([]);
- }
- //获取用户数据信息
- public function getUserDataInfo()
- {
- $store_id = Store::where('user_id',Auth::user()->id)->value('id');
- //客户总数
- $user_num = OrderW::where('store_id', $store_id)
- ->where('is_pay',1)->groupBy('user_id')
- ->whereIn('apply_cancel',[0,1,3])
- ->whereIn('is_refund',[0,1,2])
- ->get()->count();
- //订单数量
- $order_num = OrderW::where('store_id', $store_id)
- ->whereIn('apply_cancel',[0,1,3])
- ->whereIn('is_refund',[0,1,2])
- ->where('is_pay',1)->count();
- //总交易额
- $sale_total = OrderW::where('store_id', $store_id)->where('is_pay',1)->sum('account');
- $sale_total = round($sale_total);
- //扫码用户
- $scan_user = Scan::with('user:id,nickname,avatar')->where('store_id', $store_id)
- ->orderByDesc('created_at')->limit(5)->get();
- $scan_num = Scan::has('user')->where('store_id', $store_id)->count();
- $scan_7_num = Scan::has('user')->where('store_id', $store_id)->whereBetween('created_at', [date("Y-m-d H:i", strtotime('-7 days')), date("Y-m-d H:i")])->count();
- //已购客户
- // $buy_num=UserW::whereHas('order', function ($query)use($store_id) {
- // $query->where('store_id', $store_id)->where('is_pay', 1);
- // })->get()->count();
- // $buy_user = OrderW::with('user:id,nickname,avatar,phone')
- // ->where('store_id',$store_id)->where('is_pay',1)
- // ->orderByDesc('created_at')->limit(5)->get();
- // $user_ids=UserW::where('store_id',$store_id)->pluck('id');
- $userInfo=OrderW::with('user:id,nickname,avatar,phone')->has('user')
- ->where('store_id',$store_id)->where('is_pay',1)
- ->select('user_id',DB::raw('sum(total) as total'),DB::raw('sum(account) as amount'))
- ->groupBy('user_id')->orderByDesc('amount')
- ->orderByDesc('total')->orderBy('user_id')
- ->limit(5)->get();
- $buy_7_num = OrderW::where('store_id', $store_id)
- ->whereBetween('created_at', [date("Y-m-d H:i", strtotime('-7 days')), date("Y-m-d H:i")])
- ->where('is_pay',1)
- ->count();
- $data['user_num'] = $user_num ? $user_num : 0;
- $data['sale_total'] = $sale_total ? $sale_total : 0;
- $data['scan_user'] = $scan_user ? $scan_user : [];
- $data['scan_num'] = $scan_num ? $scan_num : 0;
- $data['scan_7_num'] = $scan_7_num ? $scan_7_num : 0;
- // $data['buy_user'] = $buy_user ? $buy_user : [];
- // $data['buy_num'] = $buy_num ? $buy_num : 0;
- $data['order_num'] = $order_num ? $order_num : 0;
- $data['buy_7_num'] = $buy_7_num ? $buy_7_num : 0;
- $data['user_info'] = $userInfo;
- return $this->success($data);
- }
- //扫码用户查看更多
- public function getMoreScan(Request $request)
- {
- $input = $request->input();
- $page_index = $input['page_index'];
- $page_size = $input['page_size'];
- $num = $page_size * ($page_index - 1);
- $store_id = Store::where('user_id',Auth::user()->id)->value('id');
- $data=Scan::with('user:id,nickname,avatar')
- ->has('user')
- ->where('store_id', $store_id);
- $count=$data->count();
- $list=$data->orderByDesc('created_at')->skip($num)->limit($page_size)->get();
- return $this->success_list($list,'成功',$count);
- }
- //已购客户查看更多
- public function getMoreBuy(Request $request)
- {
- $input=$request->input();
- $page_index=$input['page_index'];
- $page_size=$input['page_size'];
- $num=$page_size*($page_index-1);
- $store_id = Store::where('user_id',Auth::user()->id)->value('id');
- // $data=UserW::withCount(['order'=>function($query){
- // $query->select(DB::raw("sum(account) as money"));
- // }])
- // ->where('store_id', $store_id)->having('order_count','>',0);
- $data=OrderW::with('user:id,nickname,avatar,phone')
- ->where('store_id',$store_id)->where('is_pay',1);
- $count=$data->get()->count();
- $list=$data->orderByDesc('created_at')->skip($num)->limit($page_size)
- ->get();
- return $this->success_list($list,'成功',$count);
- }
- //获取更多用户信息
- public function getMoreUserInfo(Request $request){
- $input=$request->input();
- $page_index=$input['page_index'];
- $page_size=$input['page_size'];
- $num=$page_size*($page_index-1);
- $store_id = Store::where('user_id',Auth::user()->id)->value('id');
- $data=OrderW::with('user:id,nickname,avatar,phone')->has('user')
- ->where('store_id',$store_id)->where('is_pay',1)
- ->select('user_id',DB::raw('sum(total) as total'),DB::raw('sum(account) as amount'))
- ->groupBy('user_id');
- $count=$data->get()->count();
- $list=$data->orderByDesc('amount')->orderByDesc('total')->orderBy('user_id')
- ->skip($num)->limit($page_size)->get();
- return $this->success_list($list,'成功',$count);
- }
- //获取用户所有订单
- public function getUserAllOrder(Request $request){
- $user_id=$request->input('user_id');
- $status=$request->input('status');
- $order_no=$request->input('order_no');
- $page_size=$request->input('page_size');
- $page_index=$request->input('page_index');
- $num=$page_size*($page_index-1);
- $where=[];
- if($status!='all'){
- $where['status']=$status;
- }
- $where['user_id']=$user_id;
- $store_id = Store::where('user_id',Auth::user()->id)->value('id');
- $data=OrderW::with(['user:id,nickname,phone','order_cancel'=>function($query){
- $query->where('using',1);}])
- ->where($where)
- ->where('store_id', $store_id)
- ->whereIn('apply_cancel',[0,1,3])
- ->orderByDesc('id');
- if($order_no){
- $data->where('order_no','like','%'.$order_no.'%');
- }
- $count=$data->count();
- $orders=$data->skip($num)->take($page_size)->get();
- foreach($orders as $key=>$val){
- $goods_ids=OrderDetailW::where('order_no',$val->order_no)->groupBy('goods_id')->pluck('goods_id');
- $goods=[];
- foreach($goods_ids as $k=>$v){
- $goods[$k]=StoreGoods::where('id',$v)->first();
- $goods[$k]->sku=OrderDetailW::where('order_no',$val->order_no)->where('goods_id',$v)->get();
- }
- $orders[$key]->goods=$goods;
- }
- return $this->success_list($orders,'成功',$count);
- }
- //获取代为下单用户信息
- public function getUserInfo(Request $request)
- {
- $input=$request->all();
- $phone=$input['phone'];
- $user=UserW::where('phone',$phone)->first();
- if(empty($user)){
- return $this->error('450001','用户手机号有误');
- }
- if($user->status==1){
- return $this->error('450001','用户已被禁用');
- }
- return $this->success($user);
- }
- //获取用户所有收货地址
- public function getAllAddress(Request $request)
- {
- $input=$request->All();
- $agent_id=Auth::user()->id;
- $store_id=Store::where('user_id',$agent_id)->value('id');
- $address=AddressW::where('user_id',$input['id'])->whereIn('type',[1,2])->orderByDesc('is_default')->orderByDesc('created_at')->get();
- // $address=AddressW::where('user_id',$input['id'])->where('store_id',$store_id)->where('type',2)->orderByDesc('is_default')->orderByDesc('created_at')->get();
- return $this->success($address);
- }
- //获取收货地址
- public function getAddress(Request $request)
- {
- $input=$request->All();
- $agent_id=Auth::user()->id;
- $store_id=Store::where('user_id',$agent_id)->value('id');
- $data['address']=AddressW::where('user_id',$input['id'])->whereIn('type',[1,2])->orderByDesc('is_default')->orderByDesc('created_at')->first();
- // $data['address']=AddressW::where('user_id',$input['id'])->where('store_id',$store_id)->where('type',2)->orderByDesc('is_default')->orderByDesc('created_at')->first();
- $data['store']=Store::with('address_store')->where('user_id',Auth::user()->id)->first();
- return $this->success($data);
- }
- //添加收货地址
- public function addAddress(Request $request)
- {
- $input=$request->all();
- $regex=Verify::where('code',$request->input('areaCode','+86'))->value('preg');
- $rules=[
- 'name'=>'required|max:32',
- 'phone'=>['required','regex:'.$regex],
- 'province'=>'required',
- 'city'=>'required',
- 'area'=>'required',
- 'address'=>'required|max:255',
- ];
- $message=[
- 'name.required'=>'收货人不能为空.',
- 'name.max'=>'收货人姓名不能大于32个字符.',
- 'phone.required'=>'手机号不能为空.',
- 'phone.regex'=>'手机号格式有误.',
- 'province.required'=>'省不能为空.',
- 'city.required'=>'市不能为空.',
- 'area.required'=>'区/县不能为空.',
- 'address.required'=>'详细地址不能为空.',
- 'address.max'=>'详细地址不能大于255个字符.'
- ];
- $validator = Validator::make($input,$rules,$message);
- if($validator->fails()){
- return $this->error('400013',$validator->errors()->first());
- }
- $count=AddressW::where('user_id',$input['user_id'])->count();
- // if($count>=10){
- // return $this->error('450001','用户地址数量已达上限');
- // }
- if($input['is_default']==1){
- AddressW::where('user_id',$input['user_id'])->update(['is_default'=>0]);
- }
- $agent_id=Auth::user()->id;
- $store_id=Store::where('user_id',$agent_id)->value('id');
- $res=AddressW::create([
- 'name'=>$input['name'],
- 'area_code'=>$request->input('areaCode','+86'),
- 'phone'=>$input['phone'],
- 'user_id'=>$input['user_id'],
- 'store_id'=>$store_id,
- 'province'=>$input['province'],
- 'city'=>$input['city'],
- 'area'=>$input['area'],
- 'address'=>$input['address'],
- 'is_default'=>$input['is_default'],
- 'remark'=>$input['remark'],
- 'type'=>2,
- ]);
- if($res){
- return $this->success([]);
- }else{
- return $this->error();
- }
- }
- //修改收货地址
- public function updateAddress(Request $request)
- {
- $input=$request->all();
- $regex=Verify::where('code',$request->input('areaCode','+86'))->value('preg');
- $rules=[
- 'name'=>'required|max:32',
- 'phone'=>['required','regex:'.$regex],
- 'province'=>'required',
- 'city'=>'required',
- 'area'=>'required',
- 'address'=>'required|max:255',
- ];
- $message=[
- 'name.required'=>'收货人不能为空.',
- 'name.max'=>'收货人姓名不能大于32个字符.',
- 'phone.required'=>'手机号不能为空.',
- 'phone.regex'=>'手机号格式有误.',
- 'province.required'=>'省不能为空.',
- 'city.required'=>'市不能为空.',
- 'area.required'=>'区/县不能为空.',
- 'address.required'=>'详细地址不能为空.',
- 'address.max'=>'详细地址不能大于255个字符.'
- ];
- $validator = Validator::make($input,$rules,$message);
- if($validator->fails()){
- return $this->error('400013',$validator->errors()->first());
- }
- $address_id=$input['address_id'];
- $address=AddressW::where('id',$address_id)->first();
- if($input['is_default']==1){
- AddressW::where('user_id',$address->user_id)->update(['is_default'=>0]);
- }
- $res=AddressW::where('id',$address_id)->update([
- 'name'=>$input['name'],
- 'area_code'=>$request->input('areaCode','+86'),
- 'phone'=>$input['phone'],
- 'province'=>$input['province'],
- 'city'=>$input['city'],
- 'area'=>$input['area'],
- 'address'=>$input['address'],
- 'is_default'=>$input['is_default'],
- 'remark'=>$input['remark'],
- ]);
- if($res){
- return $this->success([]);
- }else{
- return $this->error();
- }
- }
- //删除收货地址
- public function destroyAddress(Request $request)
- {
- $res=AddressW::where('id',$request->input('id'))->delete();
- if($res){
- return $this->success([]);
- }else{
- return $this->error();
- }
- }
- //设为默认地址
- public function setDefaultAddress(Request $request)
- {
- $address=AddressW::where('id',$request->input('id'))->first();
- try{
- DB::connection('mysql_w')->transaction(function()use($address){
- if($address->is_default == 1) {
- $address->is_default = 0;
- $address->save();
- }else{
- $address->is_default = 1;
- $address->save();
- AddressW::where('user_id',$address->user_id)->whereNotIn('id',[$address->id])->update(['is_default'=>0]);
- }
- },5);
- return $this->success([]);
- }catch(\Exception $e){
- return $this->error($e->getMessage());
- }
- }
- //判断订单价格
- protected function getOrderPrice($user_id,$store_id,$num){
- $vipLog=VipLogW::where('user_id',$user_id)->where('store_id',$store_id)->first();
- if($vipLog){
- return 'vip_ed';//vip价格
- }else{
- if($num>=2){
- return 'vip_ing';//vip价格
- }else{
- return 'normal';//正常价
- }
- }
- }
- protected function saveAgentNoLog($user_id,$agent_id,$order_no){
- $one=$agent_id;
- $one_agent=User::where('id',$one)->first();
- $data=[];
- $data[0]['order_no'] = $order_no;
- $data[0]['user_id'] = $user_id;
- $data[0]['nickname'] = $one_agent->nickname;
- $data[0]['phone'] = $one_agent->mobile;
- $data[0]['created_at'] = date("Y-m-d H:i:s");
- $data[0]['updated_at'] = date("Y-m-d H:i:s");
- return $data;
- }
- public function CheckOrder(Request $request){
- $input=$request->all();
- $sku=$input['sku'];
- $user=UserW::find($input['user_id']);
- $store=Store::where('user_id',Auth::user()->id)->first();
- $time=Carbon::now()->addMonths(-2);
- $re=OrderW::where('user_id',$user->id)->where('is_pay',1)->where('apply_cancel',0)->where('store_id',$store->id)->where('created_at','>=',$time)->pluck('id');
- if (count($re)==0){
- return $this->success([]);
- }
- foreach ($sku as $k=>$v){
- $res=OrderDetailW::whereIn('order_id',$re)->where('sku_id',$v[0])->count();
- if ($res>0){
- return $this->error(50001,[],'您在2个月内已经购买过相同款式尺码的商品,确定要再次购买吗?');
- }
- }
- return $this->success([]);
- }
- //代下单或分享提交订单
- public function submitOrderInfo(Request $request)
- {
- $input=$request->all();
- $sku=$input['sku'];
- $user=UserW::find($input['user_id']);
- $agent=User::find(Auth::user()->id);
- $store=Store::where('user_id',Auth::user()->id)->first();
- if(empty($store)){
- return $this->error('450001','店铺不存在或者已被删除');
- }
- if($store->status==1){
- return $this->error('450001','店铺已被禁用');
- }
- if($user){
- $recomer_id=null;
- $recomer_status=0;
- }else{
- return $this->error('450001','客户信息有误');
- }
- $store_id=$store->id;
- $remark=$input['remark'];
- $order_no=$this->order_no('dx');
- $account=$vip_account=$num=0;
- $data=$snapshot=[];
- foreach($sku as $key=>$val){
- if($val[1] > 0){
- $num += $val[1];
- }
- }
- $vip=$this->getOrderPrice($user->id,$store_id,$num);
- $arr_test=Store::getTest();
- foreach($sku as $key=>$val){
- $sku_info=[];
- $goodSku=StoreGoodsSku::with(['goods'])->where('id',$val[0])->first();
- if(!array_key_exists($goodSku->goods_id,$snapshot)){
- $snapshot[$goodSku->goods_id]['name']=$goodSku->goods->name;
- $snapshot[$goodSku->goods_id]['main_attr']=$goodSku->goods->main_attr;
- $snapshot[$goodSku->goods_id]['img']=$goodSku->goods->img;
- $snapshot[$goodSku->goods_id]['price']=$goodSku->goods->price;
- $snapshot[$goodSku->goods_id]['sku']=[];
- }
- if(in_array($store_id,$arr_test)){
- $storeInventory=InventoryW::where(['store_id'=>$store_id,'goods_id'=>$goodSku->goods_id,'sku_id'=>$val[0]])->lockForUpdate()->first();
- $storeInve_num=!empty($storeInventory)?$storeInventory->num:0;
- if($val[1] > $storeInve_num){
- return $this->error('450001','【'.$goodSku->goods->main_attr.'-'.$goodSku->type.'-'.$goodSku->size.'】库存不足');
- }
- }
- if(empty($goodSku)){
- return $this->error('450001','商品规格不存在,刷新页面重新下单');
- }
- if($vip=='vip_ed' || $vip=='vip_ing'){
- $data[$key]['price']=$goodSku->goods->vip_price;
- $sku_info['price']=$goodSku->goods->vip_price;
- $data[$key]['account']=$goodSku->goods->vip_price * $val[1];
- $account += $goodSku->goods->vip_price * $val[1];
- }else{
- $data[$key]['price']=$goodSku->goods->price;
- $sku_info['price']=$goodSku->goods->price;
- $data[$key]['account']=$goodSku->goods->price * $val[1];
- $account += $goodSku->goods->price * $val[1];
- }
- $data[$key]['origin_price']=$goodSku->goods->price;
- $data[$key]['order_no']=$order_no;
- $data[$key]['goods_id']=$goodSku->goods_id;
- $data[$key]['store_id']=$store_id;
- $data[$key]['user_id']=$user->id;
- $data[$key]['sku_id']=$goodSku->id;
- $data[$key]['num']=$val[1];
- $data[$key]['size']=$goodSku->size;
- $data[$key]['type']=$goodSku->type;
- $data[$key]['style']=1;
- $data[$key]['created_at']=date("Y-m-d H:i:s");
- $data[$key]['updated_at']=date("Y-m-d H:i:s");
- $sku_info['origin_price']=$goodSku->goods->price;
- $sku_info['sku_id']=$goodSku->id;
- $sku_info['num']=$val[1];
- $sku_info['size']=$goodSku->size;
- $sku_info['type']=$goodSku->type;
- array_push($snapshot[$goodSku->goods_id]['sku'],$sku_info);
- }
- $order_data=[
- 'order_no'=>$order_no,
- 'store_id'=>$store_id,
- 'user_id'=>$user->id,
- 'remark'=>$remark,
- 'is_help'=>1,
- 'op_id'=>Auth::user()->id,
- 'op_name'=>Auth::user()->nickname,
- // 'status'=>0,
- // 'is_pay'=>0,
- 'status'=>1,
- 'is_pay'=>1,//服务商产品权限冻结后下单即支付
- 'pay_money'=>$account,
- 'pay_type'=>3,//免支付
- 'pay_at'=>date("Y-m-d H:i:s"),
- 'is_tip_send'=>0,
- 'is_comment'=>0,
- 'total'=>$num,
- 'account'=>$account,
- 'snapshot'=>json_encode($snapshot),
- 'address_id'=>$request->input('address_id',null),
- ];
- $agent_id=Store::where('id',$store_id)->value('user_id');
- $agent_data=$this->saveAgentNoLog($user->id,$agent_id,$order_no);
- DB::connection('mysql_w')->beginTransaction();
- try{
- $result=OrderW::create($order_data); //生成订单
- // Log::info($result);
- foreach($data as $k=>$v){
- $data[$k]['order_id']=$result->id;
- }
- OrderDetailW::insert($data); //生成订单商品详情
- AgentNo::insert( $agent_data);
- DB::connection('mysql_w')->commit();
- //代下单通知客户
- $order=$result;
- //用户vip变更
- $vipLog=VipLogW::where('user_id',$order->user_id)
- ->where('store_id',$order->store_id)->first();
- if(empty($vipLog) && $order->total>=2){
- VipLogW::create([
- 'user_id'=>$order->user_id,
- 'store_id'=>$store->id,
- 'order_no'=>$order->order_no,
- 'type'=>2,//购买两套,添加vip
- 'remark'=>'购买自动添加vip'
- ]);
- OrderW::where('order_no',$order->order_no)->update([
- 'vip'=>1
- ]);
- }
- return $this->success($order_no);
- }catch(\Exception $e){
- DB::connection('mysql_w')->rollback();
- return $this->error('450001','提交失败',$e->getMessage());
- }
- }
- //修改订单备注信息
- public function editOrderRemark(Request $request){
- $order_no=$request->input('order_no');
- $remark=$request->input('remark');
- $res=OrderW::where('order_no',$order_no)->update([
- 'remark'=>$remark
- ]);
- if($res){
- return $this->success([]);
- }else{
- return $this->error();
- }
- }
- //分享订单
- public function shareOrderInfo(Request $request)
- {
- $input=$request->all();
- $store_id=Store::where('user_id',Auth::user()->id)->value('id');
- $sku=$input['sku'];
- // $user=UserW::find($input['user_id']);
- $self_receive=$input['self_receive'];//不自提0 自提1
- if($self_receive==1){
- $address_id=Store::where('id',$store_id)->value('address_id');
- }else{
- $address_id=$input['address_id'];
- }
- $remark=$input['remark'];
- $order_no=$this->order_no('fx');
- $account=$vip_account=$num=0;
- $data=[];
- foreach($sku as $key=>$val){
- $goodSku=StoreGoodsSku::with(['goods'])->where('id',$val[0])->first();
- if(empty($goodSku)){
- return $this->error('450001','商品规格不存在,请重新分享');
- }
- $account += $goodSku->goods->price * $val[1];
- $num += $val[1];
- $data[$key]['order_no']=$order_no;
- $data[$key]['goods_id']=$goodSku->goods_id;
- $data[$key]['sku_id']=$goodSku->id;
- $data[$key]['num']=$val[1];
- $data[$key]['price']=$goodSku->goods->price;
- $data[$key]['account']=$goodSku->goods->price * $val[1];
- $data[$key]['size']=$goodSku->size;
- $data[$key]['type']=$goodSku->type;
- $data[$key]['created_at']=date("Y-m-d H:i:s");
- $data[$key]['updated_at']=date("Y-m-d H:i:s");
- }
- $order_data=[
- 'order_no'=>$order_no,
- 'store_id'=>$store_id,
- 'user_id'=>$input['user_id'],
- 'address_id'=>$address_id,
- 'self_receive'=>$self_receive,
- 'remark'=>$remark,
- 'op_id'=>Auth::user()->id,
- 'op_name'=>Auth::user()->nickname,
- 'total'=>$num,
- 'account'=>$account,
- ];
- DB::connection('mysql_w')->beginTransaction();
- try{
- OrderDetailW::insert($data);
- OrderShareW::create($order_data);
- DB::connection('mysql_w')->commit();
- return $this->success($order_no);
- }catch(\Exception $e){
- DB::connection('mysql_w')->rollback();
- return $this->error('450001','提交失败',$e->getMessage());
- }
- }
- //生成订单号
- public function order_no($type='dx')
- {
- if($type=='fx'){
- $prefix = 'FX';
- }else{
- $prefix = 'DX';
- }
- $timestamp=date('ymdHis') . substr(microtime(), 2, 6);
- $rand=mt_rand(10000, 99999);
- $order_no=$prefix . $timestamp . $rand;
- if(OrderW::where('order_no',$order_no)->first()){
- $this->order_no($type);
- }else{
- return $order_no;
- }
- }
- //审核订单取消
- public function authOrderCancel(Request $request){
- $id=$request->input('id');
- $type=$request->input('type');//2通过//3驳回
- $remark=$request->input('remark');
- DB::connection('mysql')->beginTransaction();
- DB::connection('mysql_w')->beginTransaction();
- try{
- $cancel=OrderCancelW::where('id',$id)->first();
- $cancel->status=$type;
- $cancel->remark=$remark;
- $cancel->save();
- $order=OrderW::where('id',$cancel->order_id)->first();
- $order->apply_cancel= $type;
- $order->cancel_at=date("Y-m-d H:i:s");
- $order->save();
- $first='取消订单被驳回';
- if($type==2){//同意取消
- //退款
- // $refund=new RefundAmount();
- // $res=$refund->refundAmount($cancel->order_id);
- // if($res[0]=='450001'){
- // return $this->error('450001',$res[1]);
- // }
- // if($res[0]=='450000'){
- // return $this->error('450001','取消订单退款失败',$res[1]);
- // }
- if($order->pay_type!=3){
- //退款
- $refund=new RefundAmount();
- $res=$refund->refundAmount($cancel->order_id);
- if($res[0]=='450001'){
- return $this->error('450001',$res[1]);
- }
- if($res[0]=='450000'){
- return $this->error('450001','取消订单退款失败',$res[1]);
- }
- }
- //判断是否剥夺vip
- if($order->vip==1){
- $orders=OrderW::where('user_id',$order->user_id)
- ->where('store_id',$order->store_id)
- ->where('is_pay',1)
- ->whereIn('apply_cancel',[0,1,3])
- ->whereIn('is_refund',[0,1])
- ->where('total','>=',2)
- ->where('created_at','>',$order->created_at)
- ->orderBy('created_at')->get();
- if(count($orders)>=1){
- OrderW::where('id',$orders[0]->id)->update([
- 'vip'=>1
- ]);
- }else{
- VipLogW::where('user_id',$order->user_id)->where('store_id',$order->store_id)->delete();
- }
- }
- //判断恢复库存
- $store=Store::withTrashed()->where('is_failure',0)->where('id',$order->store_id)->first();
- $level=User::where('id',$store->user_id)->value('level');
- if($level==3){
- event(new RestoreOutboundEvent($order->order_no));
- }
- $first='取消订单审核成功';
- }
- //取消订单通知
- $user=UserW::where('id',$order->user_id)->first();
- if($user->openId){
- $data['openid']=$user->openId;
- $data['data']=[
- 'first' => '您的订单:'.$order->order_no.$first,
- 'keyword1' => $user->nickname,
- 'keyword2' => $order->order_no,
- 'keyword3' => '已取消',
- 'keyword4' => $order->cancel_at
- ];
- event(new CancelOrderEvent($data));
- }
- DB::connection('mysql')->commit();
- DB::connection('mysql_w')->commit();
- return $this->success([]);
- }catch(\Exception $e){
- DB::connection('mysql')->rollback();
- DB::connection('mysql_w')->rollback();
- return $this->error('450001','失败',$e->getMessage());
- }
- }
- //商户取消订单
- public function cancelOrder(Request $request){
- $order_id=$request->input('order_id');
- $order=OrderW::where('id',$order_id)->first();
- // if($order->is_help==0){//用户自己下单
- // return $this->error('450001','用户自己下单商户不能取消');
- // }
- if($order->apply_cancel==1){
- return $this->error('450001','该订单正在审核中,不能再次取消');
- }
- if($order->apply_cancel==2){
- return $this->error('450001','该订单已取消,不能再次取消');
- }
- DB::connection('mysql')->beginTransaction();
- DB::connection('mysql_w')->beginTransaction();
- try {
- //退款
- if($order->is_pay==1){
- // $refund=new RefundAmount();
- // $res=$refund->refundAmount($order->id);
- // if($res[0]=='450001'){
- // return $this->error('450001',$res[1]);
- // }
- // if($res[0]=='450000'){
- // return $this->error('450001','退款失败',$res[1]);
- // }
- if($order->pay_type!=3){
- //退款
- $refund=new RefundAmount();
- $res=$refund->refundAmount($order->id);
- if($res[0]=='450001'){
- return $this->error('450001',$res[1]);
- }
- if($res[0]=='450000'){
- return $this->error('450001','退款失败',$res[1]);
- }
- }
- }
- //判断是否剥夺vip
- if($order->vip==1){
- $orders=OrderW::where('user_id',$order->user_id)
- ->where('store_id',$order->store_id)
- ->where('is_pay',1)
- ->whereIn('apply_cancel',[0,1,3])
- ->whereIn('is_refund',[0,1])
- ->where('total','>=',2)
- ->where('created_at','>',$order->created_at)
- ->orderBy('created_at')->get();
- if(count($orders)>=1){
- OrderW::where('id',$orders[0]->id)->update([
- 'vip'=>1
- ]);
- }else{
- VipLogW::where('user_id',$order->user_id)->where('store_id',$order->store_id)->delete();
- }
- }
- //判断恢复库存
- $store=Store::withTrashed()->where('is_failure',0)->where('id',$order->store_id)->first();
- $level=User::where('id',$store->user_id)->value('level');
- if($level==3){
- event(new RestoreOutboundEvent($order->order_no));
- }
- //取消订单
- OrderW::where('id', $order_id)->update([
- 'apply_cancel'=>2,
- 'cancel_at'=>date("Y-m-d H:i:s")
- ]);
- OrderCancelW::where('user_id',$order->user_id)
- ->where('store_id',$order->store_id)
- ->where('order_id',$order->id)->update(['using'=>0]);
- OrderCancelW::create([
- 'user_id' =>$order->user_id,
- 'store_id'=>$order->store_id,
- 'order_id'=>$order->id,
- 'status' =>2,
- 'using' =>1,
- 'type' =>2, //商户取消订单
- 'reason' =>'商户取消订单'
- ]);
- //取消订单通知
- $user=UserW::where('id',$order->user_id)->first();
- if($user->openId){
- $data['openid']=$user->openId;
- $data['data']=[
- 'first' => '您的订单:'.$order->order_no.'已被商户成功取消',
- 'keyword1' => $user->nickname,
- 'keyword2' => $order->order_no,
- 'keyword3' => '已取消',
- 'keyword4' => date("Y-m-d H:i:s")
- ];
- event(new CancelOrderEvent($data));
- }
- DB::connection('mysql')->commit();
- DB::connection('mysql_w')->commit();
- return $this->success([]);
- }catch(\Exception $e){
- DB::connection('mysql')->rollback();
- DB::connection('mysql_w')->rollback();
- return $this->error('450001','失败',$e->getMessage());
- }
- }
- //获取订单状态数量
- public function getOrderStatusNum(Request $request){
- $store=Store::withTrashed()->where('is_failure',0)->where('user_id',Auth::user()->id)->first();
- $user_id=$request->input('user_id');
- if($user_id){
- $where['user_id']=$user_id;
- }
- $where['store_id']=$store->id;
- $data=OrderW::where($where)->whereIn('apply_cancel',[0,1,3])->whereIn('is_refund',[0,1,2]);
- $data1=clone $data;
- $data2=clone $data;
- $data3=clone $data;
- $num['noPay']=$data->where('status',0)->count();
- $num['noSend']=$data1->where('status',1)->count();
- $num['noReceive']=$data2->where('status',2)->count();
- $num['Finish']=$data3->where('status',3)->count();
- //判断扫码发货还是立即发货,功能暂时未用到
- // if(in_array($store->phone,['15138929587','18838980968', '13030314383'])){//, '13030314383',
- // $num['is_code']=1;
- // }else{
- // $num['is_code']=0;
- // }
- return $this->success($num);
- }
- //获取订单列表
- public function getOrderList(Request $request)
- {
- $input=$request->all();
- $status=$input['status'];
- $page_index=$input['page_index'];
- $page_size=$input['page_size'];
- $order_no=$input['order_no'];
- $num=$page_size*($page_index-1);
- $where=$wheres=[];
- if($status!='all'){
- $where['status']=$status;
- }
- if($order_no){
- $wheres=function($query)use($order_no){
- $query->where('order_no','like','%'.$order_no.'%');
- };
- }
- $store=Store::where('user_id',Auth::user()->id)->first();
- $where['store_id']=$store->id;
- $data=OrderW::with(['user:id,nickname,phone','order_cancel'=>function($query){
- $query->where('using',1);}])->where($where)->where($wheres)->whereIn('apply_cancel',[0,1,3])
- ->whereIn('is_refund',[0,1,2])
- ->orderByDesc('updated_at')->orderByDesc('id');
- $count=$data->count();
- $orders=$data->skip($num)->take($page_size)->get();
- foreach($orders as $key=>$val){
- if($val->status==3 && $val->is_refund > 0){
- $order_refund = OrderRefundW::where('order_no',$val->order_no)->get();
- if($order_refund){
- $orders[$key]->refund_goods=$order_refund;
- }
- }
- $goods_ids=OrderDetailW::where('order_no',$val->order_no)->groupBy('goods_id')->pluck('goods_id');
- $goods=[];
- foreach($goods_ids as $k=>$v){
- $goods[$k]=StoreGoods::where('id',$v)->select('id','name','img','main_attr')->first();
- $goods[$k]->imgs=str_replace('http://','https://',$goods[$k]->img);
- $goods[$k]->sku=OrderDetailW::where('order_no',$val->order_no)
- ->where('goods_id',$v)->select('price','num')->get();
- }
- $goods_infos=OrderDetailW::with('goods:id,img,name,main_attr')->where('order_no',$val->order_no)
- ->groupBy('goods_id')->select(DB::raw('price','sum(num) as num'))->first();
- $orders[$key]->goods=$goods;
- }
- return $this->success_list($orders,'成功',$count);
- }
- //获取订单列表
- public function getOrderList1(Request $request)
- {
- $input=$request->all();
- $status=$request->input('status','all');
- $page_index=$request->input('page_index', 1);
- $page_size=$request->input('page_size', 6);
- $order_no=$request->input('order_no', null);
- $num=$page_size*($page_index-1);
- $where=$wheres=[];
- if($status!='all'){
- $where['status']=$status;
- }
- if($order_no){
- if(strlen($order_no)<=3 && is_numeric($order_no)){
- return $this->error('450001','请最少输入4个字搜索');
- }
- $user_ids=UserW::where(function($query)use($order_no){
- $query->where('phone','like','%'.$order_no.'%')->orwhere('nickname','like','%'.$order_no.'%');
- })->pluck('id');
- $wheres=function($query)use($order_no,$user_ids){
- $query->where('order_no','like','%'.$order_no.'%')->orWhereIn('user_id',$user_ids);
- };
- }
- $store=Store::where('user_id',Auth::user()->id)->first();
- $where['store_id']=$store->id;
- $data=OrderW::with(['user:id,nickname,phone','order_cancel'=>function($query){
- $query->where('using',1);}])->where($where)->where($wheres)->whereIn('apply_cancel',[0,1,3])
- ->whereIn('is_refund',[0,1,2])
- ->select('id','order_no','user_id','store_id','status','apply_cancel','is_refund','is_help','self_receive','total','account','is_pay','updated_at','created_at','snapshot')
- ->orderByDesc('updated_at')->orderByDesc('id');
- $count=$data->count();
- $orders=$data->skip($num)->take($page_size)->get();
- foreach($orders as $key=>$val){
- if($val->status==3 && $val->is_refund > 0){
- $order_refund = OrderRefundW::where('order_no',$val->order_no)->get();
- if($order_refund){
- $orders[$key]->refund_goods=$order_refund;
- }
- }
- $goods=json_decode($val->snapshot,true);
- foreach($goods as $k => $v){
- $goods[$k]['img']= str_replace('api.app.jiuweiyun.cn','api.app.cliu.cc',$v['img']);
- $goods[$k]['name'] = str_replace('健康', '', $v['name']);
- }
- $orders[$key]->goods= $goods;
- }
- return $this->success_list($orders,'成功',$count);
- }
- //获取订单列表
- public function getOrderLists(Request $request)
- {
- $input=$request->all();
- $status=$input['status'];
- $page_index=$input['page_index'];
- $page_size=$input['page_size'];
- $order_no=$input['order_no'];
- $num=$page_size*($page_index-1);
- $where=$wheres=[];
- if($status!='all'){
- $where['status']=$status;
- }
- if($order_no){
- $wheres=function($query)use($order_no){
- $query->where('order_no','like','%'.$order_no.'%');
- };
- }
- $store=Store::where('user_id',Auth::user()->id)->first();
- $where['store_id']=$store->id;
- $data=OrderW::with(['user:id,nickname,phone','order_cancel'=>function($query){
- $query->where('using',1);}])->where($where)->where($wheres)->whereIn('apply_cancel',[0,1,3])
- ->whereIn('is_refund',[0,1,2])
- ->orderByDesc('updated_at')->orderByDesc('id');
- $count=$data->count();
- $orders=$data->skip($num)->take($page_size)->get();
- foreach($orders as $key=>$val){
- if($val->status==3 && $val->is_refund > 0){
- $order_refund = OrderRefundW::where('order_no',$val->order_no)->get();
- if($order_refund){
- $orders[$key]->refund_goods=$order_refund;
- }
- }
- $goods=OrderDetailW::with('goods:id,img,name,main_attr')->where('order_id',$val->id)
- ->groupBy('goods_id')->select('goods_id','price',DB::raw('sum(num) as num'))->get();
- foreach($goods as $k=>$v){
- $goods[$k]->goods->imgs=str_replace('http://','https://',$v->goods->img);
- }
- $orders[$key]->goods=$goods;
- }
- return $this->success_list($orders,'成功',$count);
- }
- //获取退货订单详情
- public function getRefundOrderDetail(Request $request){
- $order_no=$request->input('order_no');
- $order_refund=OrderRefundW::where('order_no',$order_no)->get();
- foreach($order_refund as $key => $val){
- $goods_ids = OrderDetailW::where('order_no', $val->refund_no)->groupBy('goods_id')->pluck('goods_id');
- $goods = [];
- foreach ($goods_ids as $k => $v) {
- $goods[$k] = StoreGoods::where('id', $v)->first();
- $goods[$k]->sku = OrderDetailW::where('order_no', $val->refund_no)->where('goods_id', $v)->get();
- }
- $order_refund[$key]->goods=$goods;
- }
- return $this->success($order_refund);
- }
- //获取id订单信息
- public function getOrderInfo(Request $request)
- {
- $input=$request->all();
- $id=$input['id'];
- $order=OrderW::withTrashed()->with(['user:id,nickname,phone','address'])->where('id',$id)->first();
- $goods_ids=OrderDetailW::where('order_no',$order->order_no)->groupBy('goods_id')->pluck('goods_id');
- $goods=[];
- foreach($goods_ids as $key=>$val){
- $goods[$key]=StoreGoods::where('id',$val)->first();
- $goods[$key]->sku=OrderDetailW::where('order_no',$order->order_no)->where('goods_id',$val)->get();
- }
- $order->goods=$goods;
- return $this->success($order);
- }
- //根据订单号查询订单
- public function getOrderNoInfo(Request $request)
- {
- $input=$request->all();
- $order_no=$input['order_no'];
- $order=OrderW::withTrashed()->with(['order_cancel','user:id,nickname,phone,avatar','address','store:id,name'])->where('order_no',$order_no)->first();
- $agent_id=Auth::user()->id;
- $store_id=Store::where('user_id',$agent_id)->value('id');
- if($store_id!=$order->store_id){
- return $this->error('450401','没有权限查看该订单');
- }
- if(empty($order)){
- return $this->error('450001','订单号有误');
- }
- $goods_ids=OrderDetailW::where('order_no',$order->order_no)->groupBy('goods_id')->pluck('goods_id');
- $goods=[];
- foreach($goods_ids as $key=>$val){
- $goods[$key]=StoreGoods::where('id',$val)->first();
- $goods[$key]->imgs=str_replace('http://','https://',$goods[$key]->img);
- $goods[$key]->sku=OrderDetailW::where('order_no',$order->order_no)->where('goods_id',$val)->get();
- }
- $order->goods=$goods;
- $order->code=OrderCodeW::where('order_id',$order->id)->get();
- if(in_array($order->store_id,[ 99, 102, 105])){//,101,102,105
- $order->is_code=1;
- }else{
- $order->is_code=0;
- }
- if(isset($order->address)){
- Config::set('app.key', 'base64:7yQSmGhLZ2/n5kbyVXAOiJ3DSIP8TifHE3nfOI4d5mU=');
- $address=$order->address;
- if($address->address_code){
- try{
- $order->address->address= Crypt::decryptString($address->address_code);
- }catch(DecryptException $e){
- Log::info($e->getMessage());
- }
- }
- if($address->phone_code){
- try{
- $order->address->phone= Crypt::decryptString($address->phone_code);
- }catch(DecryptException $e){
- Log::info($e->getMessage());
- }
- }
- }
- return $this->success($order);
- }
- //回复评价
- public function addComment(Request $request){
- $input=$request->all();
- $rules=[
- 'content'=>'required|max:255',
- ];
- $message=[
- 'content.required'=>'评价内容不能为空.',
- 'content.max'=>'评价内容不能大于255个字符.'
- ];
- $validator = Validator::make($input,$rules,$message);
- if($validator->fails()){
- return $this->error('400013',$validator->errors()->first());
- }
- $store_id=Store::where('user_id',Auth::user()->id)->value('id');
- $res=Comment::create([
- 'content'=>$input['content'],
- 'comment_id'=>$input['comment_id'],
- 'store_id'=>$store_id,
- 'is_reply'=>2,
- 'is_see'=>0
- ]);
- if($res){
- return $this->success([]);
- }else{
- return $this->error();
- }
- }
- //查看所有评价
- public function getComment(Request $request){
- $input=$request->all();
- $page_index=$input['page_index'];
- $page_size=$input['page_size'];
- $num=$page_size*($page_index-1);
- $store_id=Store::where('user_id',Auth::user()->id)->value('id');
- $count= Comment::where('store_id',$store_id)->where('comment_id',0)->count();
- $list= Comment::with(['comment','store:id,name,img','user:id,avatar,nickname,phone'])
- ->where('store_id',$store_id)->where('comment_id',0)
- ->orderByDesc('id')
- ->skip($num)->take($page_size)->get();
- return $this->success_list($list,'',$count);
- }
- //用户自提
- public function oneSelfTake(Request $request){
- $order_no=$request->input('order_no');
- $order=OrderW::with('address')->where('order_no',$order_no)->first();
- $order->status=2; //已备货,可自提
- $order->express_time = date("Y-m-d H:i:s"); //备货完成时间
- $res=$order->save();
- if($res){
- /* 已备货通知 */
- $user=UserW::where('id',$order->user_id)->first();
- if($user->openId){
- $address=null;
- if($order->address){
- $address=$order->address->province.$order->address->city.$order->address->area.$order->address->address;
- }
- $mes['openid']=$user->openId;
- $mes['data']=[
- 'first' => '您的订单已完成备货,请前往提货',
- 'keyword1' => $order_no,
- 'keyword2' => $order->created_at,
- 'keyword3' => '已备货,可自提',
- 'keyword4' => $address,
- 'remark' => '点击链接进入系统,查看详情',
- ];
- event(new TipPickUpEvent($mes));
- }
- return $this->success([]);
- }else{
- return $this->error();
- }
- }
- //获取所有快递公司信息
- public function getExpressCode(){
- return $this->success(ExpressHandler::getExpressCode());
- }
- //识别扫码信息
- public function scanCodeInfo(Request $request)
- {
- $code=$request->input('code');
- if(!strpos($code,'://')){
- $info=Select::with('select_good')->select('id','good_select_id','security_code','code','is_lowest')->where('code',$code)->first();
- if(empty($info)){
- return $this->error('450001','未识别到二维码信息');
- }
- if($info->is_lowest==0){
- return $this->error('450001','请扫描单个包装盒二维码');
- }
- if(empty($info->good_select_id)){
- return $this->error('450001','该二维码没有绑定商品信息');
- }
- }else{
- $file=file_get_contents($code);
- Log::info('0000------------------0000--'.$code);
- preg_match('/<span>产品名称:<\/span> 大卫博士健康内裤((.*?))/',$file,$result);
- if(!in_array($result[1],['精装版','简约版','老人版','纯棉老人版','高腰版','青春版'])){
- return $this->error('450001','该二维码没有绑定商品信息');
- }
- switch($result[1]){
- case "精装版":
- $goods_id=1;
- break;
- case "简约版":
- $goods_id=2;
- break;
- case "老人版":
- case "高腰版":
- $goods_id=3;
- break;
- case "纯棉老人版":
- $goods_id=4;
- break;
- case "青春版":
- $goods_id=25;
- break;
- default:
- $goods_id=null;
- }
- $info['good_select_id']=$goods_id;
- $info['security_code']=substr($code,-12);;
- $info['code']=$code;
- }
- $code=substr($code,strrpos($code,'?bid='));
- $order_code = OrderCodeW::where('code',$code)->first();
- if($order_code){
- return $this->error('450001','该二维码已发货');
- }
- return $this->success($info);
- }
- //提交发货扫码信息
- public function submitScanCodeInfo(Request $request)
- {
- $order_no=$request->input('order_no');
- $code=$request->input('code');
- $order=OrderW::where('order_no',$order_no)->first();
- Log::info($code);
- Log::info($order_no);
- DB::beginTransaction();
- try{
- foreach($code as $val){
- if(strpos($val,'://')){
- $order_code = OrderCodeW::where('code',substr($val,strrpos($val,'?bid=')))->first();
- }else{
- $order_code = OrderCodeW::where('code',$val)->first();
- }
- if($order_code){
- if($order_code->order_id != $order->id){
- throw new Exception("二维码:".$order_code->security_code." 已发货");
- }
- }else{
- if(!strpos($val,'://')){
- $info=Select::with('select_good')->select('id','good_select_id','security_code','code','is_lowest')->where('code',$val)->first();
- OrderCodeW::create([
- 'store_id' => $order->store_id,
- 'user_id' => $order->user_id,
- 'order_id' => $order->id,
- 'code' => $val,
- 'security_code' => $info->security_code,
- 'good_select_id' => $info->good_select_id,
- 'good_name' => $info->select_good->good_name,
- ]);
- }else{
- $file=file_get_contents($val);
- preg_match('/<span>产品名称:<\/span> 大卫博士健康内裤((.*?))/',$file,$result);
- if(!in_array($result[1],['精装版','简约版','老人版','纯棉老人版','高腰版','青春版'])){
- throw new Exception("二维码没有绑定商品信息");
- }
- $security_code=substr($val,-12);
- switch($result[1]){
- case "精装版":
- $goods_id=1;
- break;
- case "简约版":
- $goods_id=2;
- break;
- case "老人版":
- case "高腰版":
- $goods_id=3;
- break;
- case "纯棉老人版":
- $goods_id=4;
- break;
- case "青春版":
- $goods_id=25;
- break;
- default:
- $goods_id=null;
- }
- OrderCodeW::create([
- 'store_id' => $order->store_id,
- 'user_id' => $order->user_id,
- 'order_id' => $order->id,
- 'code' => substr($val,strrpos($val,'?bid=')),
- 'security_code' => $security_code,
- 'good_select_id' => $goods_id,
- 'good_name' => '大卫博士'.$result[1],
- ]);
- }
- }
- }
- DB::commit();
- return $this->success([]);
- }catch(\Exception $e){
- DB::rollBack();
- Log::info($e->getMessage());
- return $this->error($e->getMessage());
- }
- }
- // 删除发货码
- public function deleteScanCode(Request $request)
- {
- $ids=$request->input('ids');
- $res=OrderCodeW::whereIn('id',$ids)->delete();
- if($res){
- return $this->success([]);
- }else{
- return $this->error();
- }
- }
- //获取客户所有订单
- public function getNoSendOrder(Request $request){
- $order_no=$request->input('order_no');
- $order=OrderW::where('order_no',$order_no)->first();
- $no_send_orders=OrderW::with('user:id,nickname,phone,avatar')
- ->where('store_id',$order->store_id)->where('user_id',$order->user_id)
- ->where('status',1)->whereIn('apply_cancel',[0,3])->get();
- foreach($no_send_orders as $key=>$val){
- $goods_ids=OrderDetailW::where('order_no',$val->order_no)->groupBy('goods_id')->pluck('goods_id');
- $goods=[];
- foreach($goods_ids as $k=>$v){
- $goods[$k]=StoreGoods::where('id',$v)->first();
- $goods[$k]->sku=OrderDetailW::where('order_no',$val->order_no)->where('goods_id',$v)->get();
- }
- $no_send_orders[$key]->goods=$goods;
- }
- return $this->success($no_send_orders);
- }
- //上传订单快递号
- public function addOrderExpressNo(Request $request){
- $input=$request->all();
- $rules=[
- 'express_no' =>'required',
- 'express_company'=>'required',
- 'express_time' =>'required'
- // 'address_id' =>'required'
- ];
- $message=[
- 'express_no.required' =>'发货单号不能为空.',
- 'express_company.required'=>'物流公司不能为空.',
- 'express_time.required' =>'发货时间不能为空.',
- // 'address_id.required' =>'收货地址不能为空.',
- ];
- $validator = Validator::make($input,$rules,$message);
- if($validator->fails()){
- return $this->error('400013',$validator->errors()->first());
- }
- $status=OrderW::where('order_no',$input['order_no'])->value('status');
- if($status > 1){
- return $this->error('450001','该订单已发货');
- }
- $prefix=mb_substr($input['express_no'],0,2);
- if(strtoupper($prefix)=='DD' || strtoupper($prefix)=='DX'){
- return $this->error('450001','物流单号不正确,你填的是订单号,请重新填写');
- }
- $order_nos=explode(',',$input['order_no']);
- // $address_id=$input['address_id'];
- $express_company=$input['express_company'];
- $express_code=$input['express_code'];
- $express_phone=$input['express_phone'];
- $express_time=$input['express_time'];
- $express_no=str_replace(' ','', $input['express_no']);
- $data=[
- // 'address_id'=>$address_id,
- 'self_receive'=>0,
- 'express_no'=>$express_no,
- 'express_company'=>$express_company,
- 'express_code'=>$express_code,
- 'express_state'=>0,
- 'express_phone'=>$express_phone,
- 'express_time'=>$express_time,
- 'status'=>2
- ];
- try{
- DB::connection('mysql_w')->transaction(function()use($order_nos,$data){
- OrderW::whereIn('order_no',$order_nos)->update($data);
- },5);
- $order=OrderW::with('address')->where('order_no',$order_nos[0])->first();
- $user=UserW::where('id',$order->user_id)->first();
- //已发货短信通知
- Config::set('app.key', 'base64:7yQSmGhLZ2/n5kbyVXAOiJ3DSIP8TifHE3nfOI4d5mU=');
- if(strstr($user->phone,'****' )){
- if($user->phone_code){
- $phone = Crypt::decryptString($user->phone_code);
- }else{
- $end = substr($user->openId1, -4);
- $phone = str_replace('****', $end, $user->phone);
- }
- }else {
- $phone = $user->phone;
- }
- $config=config('easysms');
- $easySms = new EasySms($config);
- $express=$express_company.$express_no;
- $content="【大卫博士】您购买的大卫博士健康内裤已发货,快递单号是{$express},请注意查收。";
- try{
- $easySms->send($phone, ['content' =>$content ]);
- Log::info('物流发货短信正常');
- } catch (\Overtrue\EasySms\Exceptions\NoGatewayAvailableException $exception) {
- $message = $exception->getException('qcloud')->getMessage();
- Log::info($phone.'物流发货短信异常:'.json_encode($message));
- }
- // event(new EnoughFive($order->id));
- //已发货公众号通知
- if($user->openId){
- Log::info($user->openId);
- if($order->address){
- $address=$order->address->name.' '.$order->address->phone.' '.$order->address->province.$order->address->city.$order->address->area.$order->address->address;
- }else{
- $address='无收件信息';
- }
- $mes['openid']=$user->openId;
- $mes['data']=[
- 'first' => '您的订单已发货,请注意查收',
- 'keyword1' => $input['order_no'],
- 'keyword2' => $express_time,
- 'keyword3' => $express_company,
- 'keyword4' => $express_no,
- 'keyword5' => $address,
- ];
- Log::info(json_encode($mes));
- event(new TipSendingEvent($mes));
- }
- return $this->success([]);
- }catch(\Exception $e){
- return $this->error('450001',$e->getMessage());
- }
- // OrderExpressW::create([
- // 'order_no'=>$input['order_no'],
- // 'express_no'=>str_replace(' ','', $input['express_no']),
- // 'express_company'=>$input['express_company'],
- // 'express_code'=>$input['express_code'],
- // 'express_state'=>0,
- // 'express_phone'=>$input['express_phone'],
- // 'express_receive_time'=>null,
- // ]);
- }
- //查询订单物流信息
- public function getOrderExpress(Request $request){
- $order_no=$request->input('order_no');
- $order=OrderW::with('address')->where('order_no',$order_no)->first();
- if(empty($order)){
- return $this->error('450001','订单信息有误');
- }
- if($order->express_state==3){ //已签收
- $express=json_decode($order->express_info,true);
- }else{ //未签收
- $CustomerName = null;
- if($order->express_code =='SF'){
- $CustomerName = substr($order->express_phone,-4);
- }
- $express=new ExpressHandler();
- $express=$express->search($order->express_no, $order->express_code, $order->order_no, $CustomerName);
- $express=json_decode(json_encode($express),'true');
- if(isset($express['Traces']) && !empty($express['Traces'])){
- foreach ($express['Traces'] as $key=>$val){
- $express['Traces'][$key]['AcceptTime']=date("Y-m-d H:i:s",substr($val['AcceptTime'],0,strlen($val['AcceptTime'])-3));
- }
- OrderW::where('order_no',$order_no)->update([
- 'express_info'=>json_encode($express),
- 'express_receive_time'=>array_pop($express['Traces'])['AcceptTime'],
- 'express_state'=>$express['State']
- ]);
- }
- }
- $data['express']=$express;
- $data['express_state']=$order->express_state;
- $data['express_code']=$order->express_code;
- $data['express_company']=$order->express_company;
- $data['express_no']=$order->express_no;
- $data['express_time']=$order->express_time;
- $data['express_phone']=$order->express_phone;
- return $this->success($data);
- }
- //修改店铺地址
- public function editStoreAddress(Request $request){
- $user_id=Auth::user()->id;
- // $user=User::where('id',$user_id)->first();
- // $store_id=Store::where('user_id',$user_id)->value('id');
- $res=Store::where('user_id',$user_id)
- ->update([
- 'province'=>$request->input('province'),
- 'city'=>$request->input('city'),
- 'area'=>$request->input('area'),
- 'address'=>$request->input('address'),
- ]);
- // $address=AddressW::where('store_id',$store_id)->first();
- // if($address){
- // $address->province=$request->input('province');
- // $address->city=$request->input('city');
- // $address->area=$request->input('area');
- // $address->address=$request->input('address');
- // $res=$address->save();
- // }else{
- // $res=AddressW::create([
- // 'store_id'=>$store_id,
- // 'name'=>$user->nickname,
- // 'phone'=>$user->mobile,
- // 'province'=>$request->input('province'),
- // 'city'=>$request->input('city'),
- // 'area'=>$request->input('area'),
- // 'address'=>$request->input('address'),
- // 'is_default'=>0
- // ]);
- // }
- if($res){
- return $this->success([]);
- }else{
- return $this->error();
- }
- }
- //获取微信位置授权
- public function getSignPackage(){
- $app=app('wechat.official_account');
- $url='http://api.app.cliu.cc/api/gzh';
- $app->jssdk->setUrl($url);
- $data=$app->jssdk->buildConfig(
- array('onMenuShareAppMessage','onMenuShareTimeline',
- 'openLocation','getLocation','chooseImage',
- 'uploadImage', 'downloadImage','scanQRCode',
- 'updateAppMessageShareData', 'updateTimelineShareData','hideMenuItems','openBusinessView','checkJsApi'),
- $debug = false, $beta = false, $json = true,
- $openTagList = ['wx-open-launch-app']);
- return $this->success($data);
- }
- //根据经纬度获取地理位置信息
- public function getAddressInfo(Request $request){
- $location=$request->input('location');
- $key='b019688375d389c1e55150985e90f816';
- $client=new Client();
- $url='https://restapi.amap.com/v3/geocode/regeo?key='.$key.'&location='.$location;
- $result=$client->request('GET',$url);
- $res = json_decode($result->getBody()->getContents());
- return $this->success($res);
- }
- //提交退货订单
- public function submitRefundOrder(Request $request)
- {
- $sku = $request->input('sku');
- $reason = $request->input('reason');
- $reason_all = $request->input('reason_all');
- $img = $request->input('img');
- $origin_order_no=$request->input('origin_order_no');
- $origin_order=OrderW::where('order_no',$origin_order_no)->first();
- if($origin_order->is_refund==1){
- return $this->error('450001','该订单存在正在审核中的退货订单');
- }
- if($origin_order->is_refund==3){
- return $this->error('450001','该订单已全部退货');
- }
- $refund_no=OrderW::order_no('th');
- $account = $total = 0;
- $list = $sku_ids = [];
- foreach($sku as $key=>$val){
- if($val[1] > 0){
- $order_detail=OrderDetailW::with(['goods'])->where('id',$val[0])->first();
- if($order_detail->num < $val[1]){
- $num = $order_detail->num;
- }else{
- $num = $val[1];
- }
- $list[$key]['num']=$num;
- $list[$key]['price']=$order_detail->price;
- $list[$key]['account']=$order_detail->price * $num;
- $list[$key]['order_no']=$refund_no;
- $list[$key]['goods_id']=$order_detail->goods_id;
- $list[$key]['sku_id']=$order_detail->sku_id;
- $list[$key]['size']=$order_detail->size;
- $list[$key]['type']=$order_detail->type;
- $list[$key]['style']=2;
- $list[$key]['created_at']=date("Y-m-d H:i:s");
- $list[$key]['updated_at']=date("Y-m-d H:i:s");
- $total += $num;
- $account += $order_detail->price * $num;
- }
- }
- $data=[
- 'refund_no'=>$refund_no,
- 'order_no'=>$origin_order_no,
- 'store_id'=>$origin_order->store_id,
- 'user_id'=>$origin_order->user_id,
- 'reason'=>$reason,
- 'reason_all'=>$reason_all,
- 'total'=>$total,
- 'account'=>$account,
- 'img'=>json_encode($img),
- 'status'=>0,
- 'op_name'=> Auth::user()->nickname,
- 'op_type'=>2,
- 'remark'=>null,
- ];
- try{
- DB::connection('mysql_w')->transaction(function ()use($list,$data,$origin_order_no,$account){
- OrderDetailW::insert($list);
- OrderRefundW::create($data);
- OrderW::where('order_no',$origin_order_no)->update(['is_refund'=>1]);
- },5);
- //申请退货提醒
- $user=UserW::where('id',$origin_order->user_id)->first();
- if($user->openId){
- $data['openid']=$user->openId;
- $data['data']=[
- 'first' => '商户提交了新的退单信息',
- 'keyword1' => $origin_order->order_no,
- 'keyword2' => '商户退货,退款金额:'.number_format($account,2)
- ];
- event(new AuthRefundTip($data));
- }
- return $this->success($refund_no);
- }catch(\Exception $e){
- return $this->error('450001',$e->getMessage());
- }
- }
- //获取退款订单原始信息
- public function getOriginOrderInfo(Request $request)
- {
- $order_no=$request->input('order_no');
- $data=OrderW::with(['address','order_cancel'=>function($query){$query->where('using',1);},'store:id,name,img,phone']);
- $order=$data->where('order_no',$order_no)->first()->toArray();
- if(empty($order)){
- return $this->error('450001','订单不存在');
- }
- $goods_ids=OrderDetailW::where('order_no',$order['order_no'])->groupBy('goods_id')->pluck('goods_id');
- $goods=[];
- foreach($goods_ids as $key=>$val){
- $goods[$val]=StoreGoods::select('id','name','img','main_attr')->where('id',$val)->first()->toArray();
- $order_details=OrderDetailW::where('order_no',$order['order_no'])->where('goods_id',$val)->get()->toArray();
- if(count($order_details)>0){
- $sku=[];
- foreach($order_details as $k=>$v){
- $sku[$v['sku_id']]=$v;
- }
- $goods[$val]['sku']=$sku;
- $goods[$val]['price']=$order_details[0]['price'];
- }
- }
- $order['goods']=$goods;
- $refund_nos=OrderRefundW::where('order_no',$order_no)->whereIn('status',[0,1,3])->pluck('refund_no');
- $refund_goods_ids=OrderDetailW::whereIn('order_no',$refund_nos)->groupBy('goods_id')->pluck('goods_id');
- $refunds=[];
- foreach($refund_goods_ids as $key=>$val){
- $refunds[$val]=StoreGoods::select('id','name','img','main_attr')->where('id',$val)->first()->toArray();
- $refunds_details=OrderDetailW::select('goods_id','sku_id','type','size', DB::raw('sum(num) as num'))
- ->whereIn('order_no',$refund_nos)->where('goods_id',$val)->groupBy('sku_id')->get()->toArray();
- if(count($refunds_details)>0){
- $sku=[];
- foreach($refunds_details as $k=>$v){
- $sku[$v['sku_id']]=$v;
- }
- $refunds[$val]['sku']=$sku;
- }
- }
- $order['refunds']=$refunds;
- $products=[];
- foreach($goods as $key=>$val){
- $products[$key]= $goods[$key];
- $sku=[];
- foreach($val['sku'] as $k=>$v){
- if(empty($refunds[$key]['sku'][$k])){
- unset($products[$key]['sku']);
- $sku[$k]= $goods[$key]['sku'][$k];
- }else{
- if($goods[$key]['sku'][$k]['num'] > $refunds[$key]['sku'][$k]['num']){
- unset($products[$key]['sku']);
- $sku[$k] = $goods[$key]['sku'][$k];
- $sku[$k]['num']=$goods[$key]['sku'][$k]['num'] - $refunds[$key]['sku'][$k]['num'];
- }else{
- unset($products[$key]['sku']);
- }
- }
- }
- $products[$key]['sku']= $sku;
- if(empty($products[$key]['sku'])){
- unset($products[$key]);
- }
- }
- $order['products']=$products;
- return $this->success($order);
- }
- //上传退货图片
- public function uploadRefundOrderImg(Request $request){
- $path_url = 'public/refund';
- $path = $request->file('img')->store($path_url);
- if($path){
- $url = env('APP_URL'). Storage::url($path);
- return $this->success($url);
- }
- return $this->error();
- }
- //取消退货审核
- public function cancelRefundOrder(Request $request){
- $refund_id=$request->input('refund_id');
- $refund=OrderRefundW::where('id',$refund_id)->first();
- if(empty($refund)){
- return $this->error('450001','退货单不存在');
- }
- try{
- DB::connection('mysql_w')->transaction(function()use($refund){
- OrderRefundW::where('id',$refund->id)->delete();
- $auth_count=OrderRefundW::where('order_no',$refund->order_no)->where('status',0)->count();
- if($auth_count>=1){
- OrderW::where('order_no',$refund->order_no)->update([
- 'is_refund'=>1
- ]);
- }else{
- $count=OrderRefundW::where('order_no',$refund->order_no)->where('status',1)->count();
- if($count>=1){
- OrderW::where('order_no',$refund->order_no)->update([
- 'is_refund'=>2
- ]);
- }else{
- OrderW::where('order_no',$refund->order_no)->update([
- 'is_refund'=>0
- ]);
- }
- }
- },5);
- return $this->success([]);
- }catch(\Exception $e){
- return $this->error('450001',$e->getMessage());
- }
- }
- //上传签名图片
- public function uploadQianMingImg(Request $request){
- $base64_img=$request->input('img');
- Log::error('签名');
- // preg_match('/^(data:\s*image\/(\w+);base64,)/',$base64_img,$res);
- // $base64_img=base64_decode(str_replace($res[1],'', $base64_img));
- // 获取七牛云配置信息
- $config = [
- 'driver' => 'qiniu',
- 'domain' => 'http://image.chuliu.cc', //七牛域名
- 'access_key' => 'cIbo9JAqHBgO6uw97gT5fJOlEHiTiGrpB84unVEn', //AccessKey
- 'secret_key' => '4f0nTNNrvzOsFc6Rz0GC5DntiJRnk2GcfkyJFNQp', //SecretKey
- 'bucket' => 'daweiboshi-app', //Bucket名字
- 'dirname'=> 'daweiboshi-weidian'
- ];
- $auth = new Auths($config['access_key'], $config['secret_key']);
- // 生成上传 Token
- $token = $auth->uploadToken($config['bucket']);
- $filename=$this->randomKeys(18).'.jpg';
- $dirname=$config['dirname'];
- // 初始化 UploadManager 对象并进行文件的上传。
- $uploadMgr = new UploadManager();
- // 调用 UploadManager 的 putFile 方法进行文件的上传。
- $pathname= $dirname.'/qianming/'.date('Ymd').'/'.$filename;
- try{
- $uploadMgr->putFile($token, $pathname, $base64_img);
- }catch(\Exception $e){
- return $this->error('450001',$e->getMessage(),$e->getMessage());
- }
- // 获取文件完整路径
- $url = $config['domain'].'/'.$pathname;
- if ($url){
- return $this->success($url);
- }
- return $this->error();
- }
- function randomKeys($length){
- $pattern = '1234567890abcdefghijklmnopqrstuvwxyz';
- $key='';
- for($i=0;$i<$length;$i++)
- {
- $key .= $pattern{mt_rand(0,strlen($pattern)-1)};//生成php随机数
- }
- return $key;
- }
- //商户确认收货
- public function agentSureReceiveOrder(Request $request){
- $order_no=$request->input('order_no');
- $order=OrderW::where('order_no',$order_no)->first();
- if($order->status==3){
- return $this->error('450001','订单已完成');
- }
- try{
- DB::connection('mysql_w')->transaction(function()use($order_no,$order,$request){
- $order->status=3;
- $order->order_status=2;
- $order->self_receive=0;//收货
- $order->express_receive_time=date("Y-m-d H:i:s");//订单签收时间
- $order->save();
- },5);
- // event(new FinishAccount($order_no));
- if($order->pay_type != 3){
- event(new FinishAccount($order_no));
- }else{
- OrderW::where('order_no',$order->order_no)->update(['is_finish'=>1,'finish_no'=>$order->order_no]);
- }
- $user=UserW::where('id',$order->user_id)->first();
- //已签收短信通知
- Config::set('app.key', 'base64:7yQSmGhLZ2/n5kbyVXAOiJ3DSIP8TifHE3nfOI4d5mU=');
- if(strstr($user->phone,'****' )){
- if($user->phone_code){
- $phone = Crypt::decryptString($user->phone_code);
- }else{
- $end = substr($user->openId1, -4);
- $phone = str_replace('****', $end, $user->phone);
- }
- }else {
- $phone = $user->phone;
- }
- $config=config('easysms');
- $easySms = new EasySms($config);
- $content="【大卫博士】您购买的大卫博士健康内裤被商户标记为确认签收。若已收到货物,请忽略此短信;若没有收到,请及时联系商户查询。 ";
- // $content="【大卫博士】您购买的大卫博士健康内裤被代理标记为确认签收。若已收到货物,请忽略此短信;若没有收到,请及时联系代理商查询。 ";
- try{
- $easySms->send($phone, ['content' =>$content ]);
- Log::info('确认收货短信正常');
- } catch (\Overtrue\EasySms\Exceptions\NoGatewayAvailableException $exception) {
- $message = $exception->getException('qcloud')->getMessage();
- Log::info($phone.'确认收货短信异常:'.json_encode($message));
- }
- return $this->success([]);
- }catch(\Exception $e){
- Log::info('签收失败2---'.json_encode($e->getMessage()));
- return $this->error('450001',$e->getMessage());
- }
- }
- //商户端确认收货,客户当面签收
- public function sureReceiveOrder(Request $request){
- $signature=$request->input('signature');
- $order_nos=explode(',',$request->input('order_no'));
- $ors=OrderW::whereIn('order_no',$order_nos)->where('status',3)->get();
- Log::info($ors);
- if(count($ors)>0){
- return $this->error('450001','存在已完成订单');
- }
- Log::info(json_encode($request->input()));
- try{
- $order=OrderW::where('order_no',$order_nos[0])->first();
- $user=UserW::where('id',$order->user_id)->first();
- DB::connection('mysql_w')
- ->transaction(function()use($order_nos,$order,$user,$signature,$request){
- $info['status']=3;
- $info['order_status']=0;
- $info['self_receive']=1;//送货上门
- $info['express_receive_time']=date("Y-m-d H:i:s");//订单签收时间
- $info['signature']=$signature;
- //以下单所填地址为准
- // if(empty($order->address_id)){
- // $province=$request->input('province');
- // if(is_array($province) && !empty($province)){
- // $province=implode('',$province);
- // }
- // if(is_array($province) && empty($province)){
- // $province='';
- // }
- // $city=$request->input('city');
- // if(is_array($city) && !empty($city)){
- // $city=implode('',$city);
- // }
- // if(is_array($city) && empty($city)){
- // $city='';
- // }
- // $area=$request->input('area');
- // if(is_array($area) && !empty($area)){
- // $area=implode('',$area);
- // }
- // if(is_array($area) && empty($area)){
- // $area='';
- // }
- // Log::info('dddd-------dddd'.$province.'---'.$city.'---'.$area);
- //
- // $address=AddressW::where('user_id',$order->user_id)
- // ->where('province',$province)->where('city',$city)
- // ->where('area',$area)->first();
- // if($address){
- // $info['address_id']=$address->id;
- // }else{
- // $res=AddressW::create([
- // 'name'=>$user->nickname,
- // 'phone'=>$user->phone,
- // 'user_id'=>$order->user_id,
- // 'store_id'=>$order->store_id,
- // 'province'=>$province,
- // 'city'=>$city,
- // 'area'=>$area,
- // 'type'=>3,
- // 'is_default'=>0,
- // 'remark'=>'自动定位',
- // ]);
- // $info['address_id']=$res->id;
- // }
- // }
- OrderW::whereIn('order_no',$order_nos)->update($info);
- },5);
- foreach($order_nos as $val){
- // event(new FinishAccount($val));
- $oro=OrderW::where('order_no',$val)->first();
- if($oro->pay_type != 3){
- event(new FinishAccount($val));
- }else{
- OrderW::where('order_no',$val)->update(['is_finish'=>1,'finish_no'=>$val]);
- }
- }
- //已签收短信通知
- Config::set('app.key', 'base64:7yQSmGhLZ2/n5kbyVXAOiJ3DSIP8TifHE3nfOI4d5mU=');
- if(strstr($user->phone,'****' )){
- if($user->phone_code){
- $phone = Crypt::decryptString($user->phone_code);
- }else{
- $end = substr($user->openId1, -4);
- $phone = str_replace('****', $end, $user->phone);
- }
- }else {
- $phone = $user->phone;
- }
- $config=config('easysms');
- $easySms = new EasySms($config);
- $content="【大卫博士】您购买的大卫博士健康内裤已由你本人确认签收,谢谢。";
- try{
- $easySms->send($phone, ['content' =>$content ]);
- Log::info('客户当面签收短信正常');
- } catch (\Overtrue\EasySms\Exceptions\NoGatewayAvailableException $exception) {
- $message = $exception->getException('qcloud')->getMessage();
- Log::info($phone.'客户当面签收短信异常:'.json_encode($message));
- }
- // event(new EnoughFive($order->id));
- //签收公众号提醒
- if($user->openId){
- $data['openid']=$user->openId;
- $data['data']=[
- 'first' => '您的订单已被当面签收,如果没有请联系商户',
- 'keyword1' => $request->input('order_no'),
- 'keyword2' => date('Y-m-d H:i:s')
- ];
- event(new ReceivingEvent($data));
- }
- return $this->success([]);
- }catch(\Exception $e){
- Log::info('签收失败1---'.$e->getMessage());
- return $this->error('450001',$e->getMessage());
- }
- }
- //获取客户信息
- public function getUser(Request $request){
- $user_id=$request->input('user_id');
- $user=UserW::where('id',$user_id)->first();
- $store_id=Store::where('user_id',Auth::user()->id)->value('id');
- $vip_log=VipLogW::where('user_id',$user->id)->where('store_id',$store_id)->first();
- if($vip_log){
- $user->is_vip=1;
- }else{
- $user->is_vip=0;
- }
- $orders=OrderW::where('store_id',$store_id)->where('user_id',$user_id)->get();
- if(count($orders)==0){//判断客户在店铺有没有单子
- $user->has_order=0;
- }else{
- $user->has_order=1;
- }
- if($user){
- return $this->success($user);
- }else{
- return $this->error();
- }
- }
- //修改客户信息
- public function editUser(Request $request){
- $rules=[
- 'name'=>'required|max:32',
- 'nickname'=>'required|max:32',
- 'remark'=>'max:255',
- 'phone'=>'required|regex:/^1[3456789][0-9]{9}$/'
- ];
- $message=[
- 'phone.required'=>'手机号不能为空.',
- 'phone.regex'=>'手机号格式有误.',
- 'name.required'=>'客户姓名不能为空.',
- 'name.max'=>'客户姓名最多32个字符.',
- 'nickname.required'=>'客户昵称不能为空.',
- 'nickname.max'=>'客户昵称最多32个字符.',
- 'remark.max'=>'备注最多255个字符.',
- ];
- $validator = Validator::make($request->input(),$rules,$message);
- if($validator->fails()){
- return $this->error('400013',$validator->errors()->first());
- }
- $user_id=$request->input('user_id');
- $res=UserW::where('id',$user_id)->update([
- 'name'=>$request->input('name'),
- 'phone'=>$request->input('phone'),
- 'nickname'=>$request->input('nickname'),
- 'sex'=>$request->input('sex'),
- 'remark'=>$request->input('remark'),
- ]);
- if($res){
- return $this->success([]);
- }else{
- return $this->error();
- }
- }
- //获取所有快递公司信息
- public function getExpressCompany(Request $request){
- $express=new ExpressHandler();
- $expressCode=$request->input('expressCode');
- $res=$express->getExpressCompany($expressCode);
- return $this->success($res);
- }
- //咨询客服,获取客服信息
- public function getServiceInfo()
- {
- $user_id=Auth::user()->id;
- $user=User::where('id',$user_id)->first();
- $admin_id=Warea::where('id',$user->warea_id)->value('admin_id');
- $admin=Admin::where('id',$admin_id)->select('id','headimg','qrcode','name')->first();
- return $this->success($admin);
- }
- }
|