RejectedBillItemController.php 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Components\AsyncResponse;
  4. use App\Events\InformWMSReceivedEvent;
  5. use App\Log;
  6. use App\Owner;
  7. use App\RejectedBill;
  8. use App\RejectedBillItem;
  9. use App\Services\RejectedBillItemService;
  10. use App\UploadFile;
  11. use App\WMSReflectReceive;
  12. use App\WMSReflectReceiveSku;
  13. use Illuminate\Http\Request;
  14. use Illuminate\Support\Collection;
  15. use Illuminate\Support\Facades\Auth;
  16. use Illuminate\Support\Facades\Gate;
  17. use Illuminate\Support\Facades\Validator;
  18. use Intervention\Image\Facades\Image;
  19. use Ramsey\Uuid\Uuid;
  20. class RejectedBillItemController extends Controller
  21. {
  22. use AsyncResponse;
  23. public function apiStore(Request $request)
  24. {
  25. if(!Gate::allows('退货管理-录入')){
  26. return ['success'=>'false','failure_info'=>'没有权限'];
  27. }
  28. $errorFields= $this->validator($request->all())->errors()->getMessages();
  29. if(!empty($errorFields)){
  30. return ['success'=>'false','error_fields'=>$errorFields,'failure_info'=>'fileds error'];
  31. }
  32. /** @var RejectedBillItemService $service */
  33. $service=app('RejectedBillItemService');
  34. $rejectedBillItem=RejectedBillItem::where('barcode_goods',$request->input('barcode_goods'))
  35. ->where('id_quality_label',$request->input('id_quality_label'))
  36. ->where('id_rejected_bill',$request->input('id_rejected_bill'))->first();
  37. if($rejectedBillItem){
  38. $rejectedBillItem['amount']+=$request->input('amount');
  39. if($request->input('name_goods')){
  40. $rejectedBillItem['name_goods']=$request->input('name_goods');
  41. }
  42. $rejectedBillItem->update();
  43. }else{
  44. $rejectedBillItem=new RejectedBillItem($request->all());
  45. $rejectedBillItem->save();
  46. }
  47. try {
  48. $packageImage=$request->packageImages ??false;
  49. $commodityImages=$request->commodityImages ??false;
  50. if ($packageImage) $service->uploadImages($packageImage, $rejectedBillItem->id, '外箱');
  51. if ($commodityImages) $service->uploadImages($commodityImages, $rejectedBillItem->id, '产品');
  52. } catch (\Exception $e) {
  53. \Illuminate\Support\Facades\Log::warning("退货录入图片-异常",
  54. ["msg"=>$e->getMessage(),'data'=>json_encode($request)]);
  55. }
  56. if (!$rejectedBillItem->rejectedBill || !$rejectedBillItem->rejectedBill->owner)return ['success'=>'false','failure_info'=>'退货单或货主不存在'];
  57. // /** @var CommodityService $commodityService */
  58. // $commodityService = app('CommodityService');
  59. // $commodity = $commodityService->ownerBarcodeSeekCommodityFirst(['name'=>$rejectedBillItem->rejectedBill->owner->name],$rejectedBillItem->barcode_goods);
  60. // if (!$commodity){
  61. // $commodity = $commodityService->ownerAndBarcodeFirstOrCreate($rejectedBillItem->rejectedBill->owner,$rejectedBillItem->barcode_goods);
  62. // if (!$commodity){
  63. // $commodity = $commodityService->create([
  64. // "name" => $rejectedBillItem->name_goods,
  65. // "owner_id" => $rejectedBillItem->rejectedBill->owner->id,
  66. // ]);
  67. // app('CommodityBarcodeService')->first([
  68. // 'commodity_id' => $commodity->id,
  69. // 'code' => $rejectedBillItem->barcode_goods,
  70. // ]);
  71. // }
  72. // }
  73. /** @var RejectedBill $rejectedBill */
  74. $rejectedBill = RejectedBill::query()->where('id',$request->input('id_rejected_bill'))->first();
  75. $rejectedBill->updateIsNewRejecting();
  76. $rejectedBill->syncOrderIssue(); // 同步问题件 修改问题件退货状态
  77. app('LogService')->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  78. return ['success'=>'true','id'=>$rejectedBillItem['id']];
  79. }
  80. public function apiReviseOwner(Request $request)
  81. {
  82. if(!Gate::allows('退货管理-录入')){
  83. return ['success'=>'false','failure_info'=>'没有权限'];
  84. }
  85. $rejectedBill = RejectedBill::query()
  86. ->where('id',$request->input('id_rejected_bill'))
  87. ->update(['id_owner'=>$request->input('commodityOwnerId')]);
  88. if ($rejectedBill) return ['success'=>'true'];
  89. return ['success'=>'false','message'=>'校正货主失败!'];
  90. }
  91. public function apiUpdate(Request $request)
  92. {
  93. if(!Gate::allows('退货管理-编辑')){
  94. return ['success'=>'false','failure_info'=>'没有权限'];
  95. }
  96. $errorFields= $this->validator($request->all())->errors()->getMessages();
  97. if(!empty($errorFields)){
  98. return ['success'=>'false','error_fields'=>$errorFields,'failure_info'=>'fileds error'];
  99. }
  100. $rejectedBillItem=RejectedBillItem::where('id',$request->input('id'))->first();
  101. if(!$rejectedBillItem){
  102. return ['success'=>'false','failure_info'=>'数据库没有相应记录,请刷新后重加'];
  103. }else{
  104. $rejectedBillItem->fill($request->all());
  105. $rejectedBillItem->update();
  106. //$rejectedBillItem->injectCommodityName(); Haozi 2020-12-09
  107. /** @var RejectedBill $rejectedBill */
  108. $rejectedBill = RejectedBill::query()->where('id',$rejectedBillItem->id_rejected_bill)->first();
  109. $rejectedBill->updateIsNewRejecting();
  110. $rejectedBill->syncOrderIssue(); // 同步问题件 修改问题件退货状态
  111. app('LogService')->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  112. return ['success'=>'true','id'=>$rejectedBillItem['id']];
  113. }
  114. }
  115. public function collectionsToPackConfirm(Collection $rejectedBillItems)
  116. {
  117. $ids=[];
  118. $rejectedBillItems->each(function ($item)use(&$ids){
  119. $ids[]=$item->id;
  120. });
  121. if(!$ids)return ['success'=>'false','fail_info'=>'没有内容'];
  122. $collections=new Collection($ids);
  123. $i=0;
  124. $collections->each(function ($id)use(&$i,$ids){
  125. $rejectedBillItems=RejectedBillItem::whereIn('id', [$ids[$i]]);
  126. $rejectedBillItems->each(function(RejectedBillItem $rejectedBillItem)use(&$havingFail){
  127. $rejectedBill=RejectedBill::find($rejectedBillItem['id_rejected_bill']);
  128. $owner = Owner::find($rejectedBill['id_owner']);
  129. if(strstr($owner->name??'','笕尚')){
  130. app('LogService')->log(__METHOD__,'找不到表','121行');
  131. // $rejected=new Rejected();
  132. // $rejected->fill($rejectedBill->toArray());
  133. // $rejected->fill($rejectedBillItem->toArray());
  134. $rejected=new Rejected();
  135. $rejected->fill($rejectedBill->toArray());
  136. $rejected->fill($rejectedBillItem->toArray());
  137. $rejectedJianshang=new api\thirdPart\jianshang\RejectedController();
  138. $sended=$rejectedJianshang->sendRejected($rejected);
  139. if(!$sended){
  140. echo '<h1>数据发送给笕尚失败,请通知IT相关负责人</h1>';
  141. app('LogService')->log(__METHOD__,'error','数据发送给笕尚失败');
  142. $havingFail++;
  143. return false;
  144. }
  145. }
  146. });
  147. $i++;
  148. if($i%30==0)
  149. sleep(1);
  150. });
  151. return 'yes'.$i;
  152. }
  153. public function apiPackConfirm(Request $request)
  154. {
  155. if(!Gate::allows('退货管理-录入')){
  156. return ['success'=>'false','fail_info'=>'没有权限'];
  157. }
  158. $ids=$request->input('ids');
  159. if(!$ids)return ['success'=>'false','fail_info'=>'没有内容'];
  160. $rejectedBillItems=RejectedBillItem::whereIn('id', $ids)->get();
  161. if($rejectedBillItems->count()==0){
  162. return ['success'=>'false','fail_info'=>'没有匹配到相应内容'];
  163. }
  164. $item=$rejectedBillItems->first();
  165. $rejectedBill = RejectedBill::query()->find($item['id_rejected_bill']);
  166. $rejectedBill->syncOrderIssue(); // 同步问题件 修改问题件退货状态
  167. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,'请求处理退单:'.$rejectedBill['logistic_number_return'],Auth::user()['id']);
  168. $downloadedSkus = WMSReflectReceive::downloadedSkus($rejectedBill['logistic_number_return'],true);
  169. $isGotMoreThenDownloaded=WMSReflectReceiveSku::isItemsOverDownloadedSkus($rejectedBillItems,$downloadedSkus);
  170. $isJianshang=(function($rejectedBill){
  171. $owner = Owner::find($rejectedBill['id_owner']);
  172. if(strstr($owner->name??'','笕尚')){
  173. return true;
  174. }
  175. return false;
  176. })($rejectedBill);
  177. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"当前,实收件:(".json_encode($rejectedBillItems).")},下载件:("
  178. .json_encode($downloadedSkus).")},退单号:{$rejectedBill['logistic_number_return']}",null);
  179. $shouldStore=!$isGotMoreThenDownloaded //没有录入超过下载货物数
  180. && !($rejectedBill['is_loaded']==1)//并且不是已入库////去掉了或无需入库的判断:||$rejectedBill['is_loaded']===null
  181. &&config('api.api_switch_receive_to_wms');//并且配置开
  182. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"自动入库:{$shouldStore}||isGotMoreThenDownloaded={$isGotMoreThenDownloaded}/rejectedBill['is_loaded']={$rejectedBill['is_loaded']}/rejectedBill['is_loaded']={$rejectedBill['is_loaded']}",null);
  183. if($shouldStore){
  184. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,'满足条件,准备从网页主动请求富勒入库:'.$rejectedBill['logistic_number_return'],Auth::user()['id']);
  185. $result_transferToWms=(new InformWMSReceivedEvent($rejectedBill))->directRun();
  186. if($result_transferToWms=='fail')return ['success'=>'false','fail_info'=>'提交至WMS错误,请手动校验、操作WMS并通知相关人员'];
  187. if($result_transferToWms=='exception')return ['success'=>'exception','fail_info'=>'提交至WMS部分成功,存在异常情况,请校对WMS'];
  188. $isLoaded=false;
  189. if($isJianshang){
  190. $isLoaded=true;
  191. }
  192. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,'标记前端是否入库为:'.$isLoaded,Auth::user()['id']);
  193. return ['success'=>'true','bill_is_loaded'=>$isLoaded];
  194. }
  195. $remoteResultStr='';
  196. if($isJianshang){
  197. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"不满足入库条件,准备发送给笕尚处理,退单号:{$rejectedBill['logistic_number_return']}",Auth::user()['id']);
  198. $remoteResultStr=$this->sendRejectedToThirdPart2($rejectedBillItems,$rejectedBill);//不能入库所以发送给笕尚处理 !!!!
  199. }
  200. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"前端退单处理请求完成:笕尚入库状态为:{$remoteResultStr},退单号: {$rejectedBill['logistic_number_return']},退单ID:{$rejectedBill['id']},form表单:".json_encode($request->toArray()),Auth::user()['id']);
  201. return ['success'=>'true','remote_result'=>$remoteResultStr];
  202. }
  203. public function sendRejectedToThirdPart(Collection $items,$rejectedBill):bool {
  204. $havingFail=0;
  205. if(!config('api.API_FAKING')){
  206. $items->each(function(RejectedBillItem $rejectedBillItem)use(&$havingFail,$rejectedBill){
  207. $rejected=$rejectedBill->toArray();
  208. $rejected = array_merge($rejected, $rejectedBillItem->toArray());
  209. $rejectedJianshang=new api\thirdPart\jianshang\RejectedController();
  210. $sended=$rejectedJianshang->sendRejected($rejected);
  211. if(!$sended){
  212. echo '<h1>数据发送给笕尚失败,请通知IT相关负责人</h1>';
  213. app('LogService')->log(__METHOD__,'error_'.__FUNCTION__.'_'.$rejectedBillItem['id'],'数据发送给笕尚失败');
  214. $havingFail++;
  215. return false;
  216. }
  217. });
  218. $receives=WMSReflectReceive::where('ASNREFERENCE3',$rejectedBill['logistic_number_return'])->where('is_uploaded',0)->get();
  219. $receives->each(function ($receive){
  220. $receive['is_uploaded']=1;
  221. $receive->save();
  222. });
  223. }
  224. if($havingFail>0){
  225. app('LogService')->log(__METHOD__,'error_'.__FUNCTION__.'_'.$rejectedBill['id'],"$havingFail/{$items->count()} 条记录没有发送成功",Auth::user()['id']);
  226. return false;
  227. }
  228. return true;
  229. }
  230. public function sendRejectedToThirdPart2(Collection $items,$rejectedBill) {
  231. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"进入发送方法,发送给笕尚处理,退单号:{$rejectedBill['logistic_number_return']}",Auth::user()['id']);
  232. if($rejectedBill['is_loaded']!=0){
  233. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"进入发送方法,但退单已入库,跳出!退单号:{$rejectedBill['logistic_number_return']}",Auth::user()['id']);
  234. return true;
  235. }
  236. $rejected=$rejectedBill->toArray();
  237. $goodses=[];
  238. $items->each(function(RejectedBillItem $item)use(&$goodses){
  239. $goodses[]=$item->toArray();
  240. });
  241. $rejectedJianshang=new api\thirdPart\jianshang\RejectedController();
  242. $rejected['goodses']=$goodses;
  243. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"进入发送方法,将商品转成数组,准备进入接口!退单号:{$rejectedBill['logistic_number_return']}",Auth::user()['id']);
  244. $resultStr= $rejectedJianshang->sendRejected2($rejected); //!!!
  245. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"发送笕尚取得结果是:{$resultStr}!退单号:{$rejectedBill['logistic_number_return']}",Auth::user()['id']);
  246. if($resultStr=='fail'){
  247. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"发送失败,笕尚取得结果是:{$resultStr}!返回前端。退单号:{$rejectedBill['logistic_number_return']}",Auth::user()['id']);
  248. return $resultStr;
  249. }
  250. if($resultStr=='storable'){
  251. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"发送成功,可入,但待推单,笕尚取得结果是:{$resultStr}!返回前端。退单号:{$rejectedBill['logistic_number_return']}",Auth::user()['id']);
  252. $rejectedBill = RejectedBill::find($rejectedBill['id']);
  253. $rejectedBill->is_loaded=2;
  254. $rejectedBill->save();
  255. $items->each(function(RejectedBillItem $item)use(&$goodses){
  256. $item['is_loaded']='待推单';
  257. $item->save();
  258. });
  259. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"标记退单和商品为待推单!退单号:{$rejectedBill['logistic_number_return']}",Auth::user()['id']);
  260. }
  261. if(config('api.jianshang_rejecteds_log_switch'))Controller::logS(__METHOD__,__FUNCTION__,"处理完成,返回前端入库状态,标记笕尚取得结果是:{$resultStr}!退单号:{$rejectedBill['logistic_number_return']}",Auth::user()['id']);
  262. return $resultStr;
  263. }
  264. public function apiPackDestroy(Request $request)
  265. {
  266. if(!(Gate::allows('退货管理-录入')||Gate::allows('退货管理-编辑'))){
  267. return ['success'=>'false','failure_info'=>'没有权限'];
  268. }
  269. $ids=$request->input('ids');
  270. if(!$ids)return ['success'=>'false','fail_info'=>'没有内容'];
  271. $rejectedBillItems=RejectedBillItem::whereIn('id', $ids);
  272. $rejectedBillItems->each(function(RejectedBillItem $rejectedBillItem){
  273. $rejectedBillItem->delete();
  274. });
  275. app('LogService')->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  276. return ['success'=>'true'];
  277. }
  278. protected function validator(array $data,$isUpdate=false)
  279. {
  280. return Validator::make($data, [
  281. 'id_rejected_bill' => ['required', 'numeric', 'exists:rejected_bills,id'],
  282. 'barcode_goods' => ['required', 'string','max:60'],
  283. 'name_goods' => ['nullable', 'string','max:219'],
  284. 'amount' => ['numeric','required', 'max:99999'],
  285. 'id_quality_label' => ['required','numeric', 'max:11'],
  286. 'batch_number' => ['string', 'nullable',],
  287. 'validity_at' => ['nullable','date_format:Y-m-d'],
  288. 'remark' => ['nullable','string','max:191'],
  289. ],[],[
  290. 'id_rejected_bill' =>'退单头',
  291. 'barcode_goods' => '商品条码',
  292. 'name_goods' => '商品名称',
  293. 'amount' => '数量',
  294. 'id_quality_label' => '品质',
  295. 'batch_number' => '批次',
  296. 'validity_at' => '效期',
  297. 'remark' => '备注'
  298. ]);
  299. }
  300. public function apiGet(Request $request)
  301. {
  302. if(!Gate::allows('退货管理-查询')){
  303. return ['success'=>'false','failure_info'=>'没有权限'];}
  304. if(!$request->input('id_rejected_bill')){
  305. return ['success'=>'false','failure_info'=>'表头id不能为空'];
  306. }
  307. $rejectedBillItems = RejectedBillItem::query()->with(['uploadFiles','packageImages','commodityImages'])
  308. ->where('id_rejected_bill',$request->input('id_rejected_bill'))->get();
  309. return ['success'=>'true','items'=>$rejectedBillItems];
  310. }
  311. public function apiDelete(Request $request)
  312. {
  313. if(!Gate::allows('退货管理-删除')){
  314. return ['success'=>'false','failure_info'=>'没有权限'];}
  315. if(!$request->input('id')){
  316. return ['success'=>'false','failure_info'=>'传入id不能为空'];
  317. }
  318. $rejectedBillItem = RejectedBillItem::find($request->input('id'));
  319. if(!$rejectedBillItem)return ['success'=>'false','id'=>$request->input('id')];
  320. $rejectedBillItem->forceDelete();
  321. /** @var RejectedBill $rejectedBill */
  322. $rejectedBill = RejectedBill::query()->where('id',$rejectedBillItem->id_rejected_bill)->first();
  323. if(!$rejectedBill)return ['success'=>'false','id'=>$request->input('id')];
  324. $rejectedBill->syncOrderIssue(); // 同步问题件 修改问题件退货状态
  325. app('LogService')->log(__METHOD__,__FUNCTION__,json_encode($rejectedBillItem),Auth::user()['id']);
  326. return ['success'=>'true','id'=>$request->input('id')];
  327. }
  328. public function apiUpload(Request $request)
  329. {
  330. $files=$request->file("files");
  331. if (!$files)$this->error("未传递照片");
  332. $id=$request->input('id');
  333. $rejectedBillItem=RejectedBillItem::query()->find($id);
  334. if (!$rejectedBillItem)$this->error("未找到该退货详情!");
  335. $res = [];
  336. foreach ($files as $file){
  337. if (!$file->isValid()){
  338. return ['success'=>false,'error'=>"找不到照片!"];
  339. }
  340. $tmpFile = $file->getRealPath();
  341. if (! is_uploaded_file($tmpFile)) {
  342. return ['success'=>false,'error'=>"文件错误!"];
  343. }
  344. $fileExtension=$file->getClientOriginalExtension();
  345. // 5.存储, 生成一个随机文件名
  346. $fileName = date('ymd').'-'.Uuid::uuid1();
  347. $thumbnailName=storage_path('app/public/files/'.$fileName.'-thumbnail.'.$fileExtension);
  348. $commonName=storage_path('app/public/files/'.$fileName.'-common.'.$fileExtension);
  349. $bulkyName=storage_path('app/public/files/'.$fileName.'-bulky.'.$fileExtension);
  350. $result=move_uploaded_file ($tmpFile ,$bulkyName);
  351. if ($result){
  352. $img=Image::make($bulkyName)->resize(250,250);
  353. if ($img->height() > $img->width()){
  354. $img->heighten(250)->save($commonName);
  355. } else{
  356. $img->widen(250)->save($commonName);
  357. $img->widen(28)->save($thumbnailName);
  358. }
  359. if (file_exists($bulkyName)){unlink($bulkyName);}
  360. /** @var UploadFile|\stdClass $uploadFile */
  361. $uploadFile=new UploadFile([
  362. "table_name"=>"rejected_bill_items",
  363. "table_id"=>$id,
  364. "url"=>'/files/'.$fileName,
  365. "type"=>$fileExtension,
  366. "file_name"=>$request->type??'',
  367. ]);
  368. if ($uploadFile->save()) $res[] = $uploadFile;
  369. }else $this->error("图片存储失败,检查服务器状态");
  370. }
  371. $this->success($res);
  372. }
  373. //删除照片
  374. public function apiDeleteImg(Request $request){
  375. $id=$request->input("id");
  376. $url=$request->input("url");
  377. $query=UploadFile::query()->where('table_name','rejected_bill_items');
  378. if ($url)$query = $query->where('table_id',$id)->where("url",$request->input("url"));
  379. else $query = $query->whereIn('table_id',$request->input("id"));
  380. foreach ($query->get() as $uploadFile){
  381. $bulky=storage_path('app/public/'.$uploadFile->url.'-bulky.'.$uploadFile->type);
  382. $common=storage_path('app/public/'.$uploadFile->url.'-common.'.$uploadFile->type);
  383. $thumbnail=storage_path('app/public/'.$uploadFile->url.'-thumbnail.'.$uploadFile->type);
  384. if (file_exists($bulky))unlink($bulky);
  385. if (file_exists($common))unlink($common);
  386. if (file_exists($thumbnail))unlink($thumbnail);
  387. }
  388. $query->delete();
  389. app('LogService')->log(__METHOD__,'退货商品详情图片删除',json_encode($request),Auth::user()['id']);
  390. $this->success();
  391. }
  392. }