ProcessController.php 55 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Commodity;
  4. use App\CommodityBarcode;
  5. use App\Events\ResetProcessStatisticStartDateEvent;
  6. use App\LaborReport;
  7. use App\Owner;
  8. use App\Process;
  9. use App\ProcessDaily;
  10. use App\ProcessDailyParticipant;
  11. use App\ProcessesContent;
  12. use App\ProcessMethod;
  13. use App\ProcessStatistic;
  14. use App\Services\OwnerService;
  15. use App\Sign;
  16. use App\Tutorial;
  17. use App\User;
  18. use App\UserDetail;
  19. use App\UserDutyCheck;
  20. use App\UserLabor;
  21. use Carbon\Carbon;
  22. use Illuminate\Contracts\Foundation\Application;
  23. use Illuminate\Contracts\View\Factory;
  24. use Illuminate\Database\Eloquent\Builder;
  25. use Illuminate\Http\Request;
  26. use Illuminate\Support\Facades\Auth;
  27. use Illuminate\Support\Facades\DB;
  28. use Illuminate\Support\Facades\Gate;
  29. use Illuminate\Support\Facades\Log;
  30. use Illuminate\Support\Facades\Validator;
  31. use Illuminate\View\View;
  32. use Oursdreams\Export\Export;
  33. use Ramsey\Uuid\Uuid;
  34. class ProcessController extends Controller
  35. {
  36. /**
  37. * Display a listing of the resource.
  38. * @param Request $request
  39. * @param OwnerService $ownerService
  40. * @return Application|Factory|View
  41. */
  42. public function index(Request $request,OwnerService $ownerService)
  43. {
  44. $paginateParams = $request->input();
  45. $processes = app('ProcessService')->paginate($paginateParams);
  46. $owners=$ownerService->getIntersectPermitting();
  47. return view('process.index',['processes'=>$processes,'owners'=>$owners,'paginateParams'=>$paginateParams]);
  48. }
  49. //获取每日参与人
  50. public function getDailyParticipant(Request $request){
  51. if(!Gate::allows('二次加工管理-登记工时')){ return redirect(url('/')); }
  52. $today=Carbon::now()->format('Y-m-d');
  53. $id=$request->input('id');
  54. $processDailies=ProcessDaily::with(['processDailyParticipants','process'])->orderBy('date','DESC')
  55. ->where('process_id',$id)->get();
  56. $process=Process::query()->with('automaticSupplementSign')->find($id);
  57. if (count($processDailies)>0){
  58. if ((($process->amount)-($process->completed_amount))<=0 ||
  59. $process->status=='交接完成' || $process->automaticSupplementSign)$result=true;
  60. else $result=$this->createDeficiencyData($processDailies,$today);
  61. if ($result){
  62. $processDailies=ProcessDaily::with(['processDailyParticipants','process'])
  63. ->orderBy('date','DESC')->where('process_id',$id)->get();
  64. }
  65. }
  66. return $processDailies;
  67. }
  68. //生成二次加工单缺失时间记录及本日记录
  69. private function createDeficiencyData($processDailies,$today){
  70. $processDailiesArr=[];
  71. foreach ($processDailies as $processDaily){
  72. $processDailiesArr[$processDaily->date]=$processDaily;
  73. }
  74. $processDailyOne=$processDailies[count($processDailies)-1];
  75. $startDate=Carbon::parse($processDailyOne->date);
  76. $diffDay=$startDate->diffInDays($today,true);
  77. $remain=$processDailyOne->remain;
  78. $processId=$processDailyOne->process_id;
  79. for ($i=1;$i<=$diffDay;$i++){
  80. $date=date("Y-m-d",strtotime('+'.strval($i)." day",strtotime($startDate)));
  81. if (!isset($processDailiesArr[$date])){
  82. $processDaily=new ProcessDaily([
  83. 'process_id'=>$processId,
  84. 'date'=>$date,
  85. 'output'=>0,
  86. 'remain'=>$remain
  87. ]);
  88. $processDaily->save();
  89. }
  90. if (isset($processDailiesArr[$date])){
  91. $remain=$remain-($processDailiesArr[$date]->output);
  92. }
  93. }
  94. return true;
  95. }
  96. //驳回二次加工单
  97. public function reject($id){
  98. if(!Gate::allows('二次加工管理-接单与驳回')){ return redirect(url('/')); }
  99. $process=Process::select('id','status')->find($id);
  100. $process->status="已驳回";
  101. $process->update();
  102. $process->createOperatorLog('驳回');
  103. app('LogService')->log(__METHOD__,"驳回二次加工单_".__FUNCTION__,json_encode($process),Auth::user()['id']);
  104. return $process;
  105. }
  106. //接单
  107. public function receive($id){
  108. if(!Gate::allows('二次加工管理-接单与驳回')){ return ["success"=>false,"data"=>"无权操作"]; }
  109. /** @var Process|\stdClass $process */
  110. $process=Process::query()->select('id','status','amount','designate_id')->find($id);
  111. if ($process && $process->designate_id && $process->designate_id!=Auth::id())return ["success"=>false,"data"=>"无权操作"];
  112. $amount=$process->amount;
  113. $today=Carbon::now()->format('Y-m-d');
  114. $processDaily=ProcessDaily::query()->where('date',$today)->where('process_id',$id)->first();
  115. if (!$processDaily){
  116. $processDaily=new ProcessDaily([
  117. 'process_id'=>$id,
  118. 'date'=>$today,
  119. 'output'=>0,
  120. 'remain'=>$amount,
  121. ]);
  122. $processDaily->save();
  123. }
  124. $process->status="待加工";
  125. $process->update();
  126. $process->createOperatorLog('接单');
  127. return ["success"=>true,"data"=>$process->status];
  128. }
  129. //完成
  130. public function accomplish(Request $request){
  131. if(!Gate::allows('二次加工管理-交接完成')){ return ['success'=>false,'data'=>'您无权进行该操作!']; }
  132. $process=Process::with('processDailies')->find($request->id);
  133. if (!$process || $process->status == '交接完成')return ['success'=>false];
  134. $this->statistic($process);
  135. $process->update(['status'=>'交接完成']);
  136. $process->createOperatorLog('交接完成');
  137. app('ProcessService')->createInstantBill($process);
  138. return ['success'=>true,'data'=>'交接完成'];
  139. }
  140. private function statistic($process, $sign_end = false){
  141. $processStatistic=ProcessStatistic::query()->find($process->id);
  142. if (!$processStatistic)return ['success'=>true];
  143. if (count($process->processDailies)>0){
  144. $completed_amount=0;
  145. foreach ($process->processDailies as $processDaily){
  146. $completed_amount=$completed_amount+($processDaily->output);
  147. }
  148. $process->completed_amount=$completed_amount;
  149. }
  150. //统计:
  151. $revenue=($process->unit_price)*($process->completed_amount); //收入合计
  152. $processDailies=ProcessDaily::with('processDailyParticipants')->where('process_id',$process->id)->where('output','>',0)->get();
  153. $duration_days=count($processDailies); //完成天数
  154. $duration_man_hours=0; //总工时
  155. $total_cost=0; //合计成本
  156. foreach ($processDailies as $processDailyOne){
  157. foreach ($processDailyOne->processDailyParticipants as $processDailyParticipant){
  158. if (!$processDailyParticipant->unit_price && !$processDailyParticipant->hour_price) continue;
  159. $duration_man_hours += $processDailyParticipant->hour_count;
  160. if ($processDailyParticipant->unit_count){
  161. $total_cost += ($processDailyParticipant->unit_count)*($processDailyParticipant->unit_price);
  162. continue;
  163. }
  164. $total_cost += ($processDailyParticipant->hour_count)*($processDailyParticipant->hour_price);
  165. }
  166. };
  167. $processStatistic->revenue=$revenue;
  168. $processStatistic->duration_days=$duration_days;
  169. $processStatistic->duration_man_hours=$duration_man_hours;
  170. if ($sign_end) $processStatistic->ended_at = date('Y-m-d H:i:s');
  171. if (!$revenue || !$total_cost){
  172. if (!$total_cost && $revenue){
  173. $processStatistic->total_cost = 0;
  174. $processStatistic->gross_profit = $revenue;
  175. $processStatistic->gross_profit_rate = 1;
  176. }
  177. $processStatistic->update();
  178. return ['success'=>false,'data'=>'该单未产生费用,无法计算毛利率!'];
  179. }
  180. $gross_profit=$revenue-$total_cost; //毛利润
  181. if ($gross_profit!=0)$gross_profit_rate=$gross_profit/$revenue; //毛利率;
  182. else $gross_profit_rate=0;
  183. $processStatistic->total_cost=$total_cost;
  184. $processStatistic->gross_profit=$gross_profit;
  185. $processStatistic->gross_profit_rate=$gross_profit_rate;
  186. $processStatistic->update();
  187. app('LogService')->log(__METHOD__,"修改二次加工单统计单_".__FUNCTION__,json_encode($processStatistic),Auth::user()['id']);
  188. return ['success'=>true,'data'=>$processStatistic];
  189. }
  190. //修改当日产量
  191. public function updateDailyOutput(Request $request){
  192. if(!Gate::allows('二次加工管理-登记工时')){ return redirect(url('/')); }
  193. $errors=$this->validator($request)->errors();
  194. if (count($errors)>0)return ['status'=>"error",'data'=>$errors];
  195. $id=$request->input('id');
  196. $output=$request->input('output');
  197. $processDaily=ProcessDaily::with('process')->find($id);
  198. $processDaily->output=$output;
  199. $processDaily->update();
  200. $result=$this->countRemains($processDaily);
  201. $processDailies=$result['processDailies'];
  202. app('LogService')->log(__METHOD__,"修改当日产量".__FUNCTION__,json_encode($processDaily),Auth::user()['id']);
  203. $response=[];
  204. $response['status']='success';
  205. $response['data']=$processDailies;
  206. if (isset($result['process'])){$response['process']=$result['process'];}
  207. return $response;
  208. }
  209. //每次修改,去查询该单下全部日期,逐个替换,前一天剩余减当天产量为当天剩余,无前天记录去拿单子预期产量
  210. private function countRemains($processDaily){
  211. if (!$processDaily || !$processDaily->process) return;
  212. $processDailies=ProcessDaily::where('process_id',$processDaily->process_id)->orderBy('date')->get();
  213. $completed_amount = 0;
  214. for ($i=0;$i<count($processDailies);$i++){
  215. if ($i==0&&$processDailies[$i]->date>=$processDaily->date){
  216. $processDailies[$i]->remain=($processDaily->process->amount)-$processDailies[$i]->output;
  217. $processDailies[$i]->update();
  218. }
  219. if ($i>0&&$processDailies[$i]->date>=$processDaily->date){
  220. $processDailies[$i]->remain=($processDailies[$i-1]->remain)-$processDailies[$i]->output;
  221. $processDailies[$i]->update();
  222. }
  223. $completed_amount += $processDailies[$i]->output;
  224. }
  225. if ($completed_amount) Process::query()->where('id',$processDaily->process_id)->update(['completed_amount'=>$completed_amount]);
  226. //同步二次加工单统计
  227. $processDailiesStatistic=$processDailies->where('output','>',0);
  228. $processStatistic=ProcessStatistic::find($processDaily->process_id); //如非录入渠道建单不生成统计单,报错
  229. if(!$processStatistic){
  230. Log::warning("二次加工统单不存在",["user"=>Auth::id(),"param"=>$processDaily->process_id]);
  231. return ["processDailies"=>$processDailies];
  232. }
  233. $processStatistic->top_capacity=$processDailiesStatistic->max('output');
  234. $processStatistic->bottom_capacity=$processDailiesStatistic->min('output');
  235. $processStatistic->average_capacity=$processDailiesStatistic->avg('output');
  236. $processStatistic->update();
  237. //修改二次加工单状态
  238. $result=[];
  239. /*if (count($processDailies)>0 && ($processDailies[(count($processDailies)-1)]->remain)<=0){
  240. $result['process']=$this->changeProcessCheck($processDaily->process_id); //保留 目前小于0后等待人工确认再进入待验收
  241. }*/
  242. $result['processDailies']=$processDailies;
  243. return $result;
  244. }
  245. //剩余小于等于0,状态待验收
  246. private function changeProcessCheck($process_id){
  247. $process=Process::select('id','status')->find($process_id);
  248. if ($process->status=="加工中"){
  249. $process->status="待验收";
  250. $process->update();
  251. $processStatistic=ProcessStatistic::find($process_id);
  252. $processStatistic->ended_at=date('Y-m-d H:i:s');
  253. $processStatistic->update();
  254. app('LogService')->log(__METHOD__,"二次加工单待验收".__FUNCTION__,json_encode($process)." || ".json_encode($processStatistic),Auth::user()['id']);
  255. }
  256. return $process_id;
  257. }
  258. //新增参与人
  259. public function storeProcessDailyParticipant(Request $request){
  260. if(!Gate::allows('二次加工管理-登记工时')){ return redirect(url('/')); }
  261. $errors=$this->validatorProcessDailyParticipant($request)->errors();
  262. if (count($errors)>0)return ['status'=>"error",'data'=>$errors];
  263. $user_id=$request->input('user_id');
  264. $started_at=$request->input('started_at');
  265. $ended_at=$request->input('ended_at');
  266. $daily_id=$request->input('daily_id');
  267. $hour_count=$request->input('hour_count');
  268. $unit_count=$request->input('unit_count');
  269. $hour_price=$request->input('hour_price');
  270. $unit_price=$request->input('unit_price');
  271. $dinner_duration=$request->input('dinner_duration');
  272. $remark=$request->input('remark');
  273. $userLabor=UserLabor::find($user_id);
  274. $processDaily=processDaily::find($daily_id);
  275. if ($userLabor->isOccupiedAt($processDaily->date,$ended_at)){
  276. return ['status'=>"warning",'data'=>'该临时工此时间段已存在工作记录!'];
  277. };
  278. $processDailyParticipant=new ProcessDailyParticipant([
  279. 'process_daily_id'=>$daily_id,
  280. 'user_id'=>$user_id,
  281. 'started_at'=>$started_at,
  282. 'ended_at'=>$ended_at,
  283. 'hour_price'=>$hour_price,
  284. 'hour_count'=>$hour_count,
  285. 'unit_price'=>$unit_price,
  286. 'unit_count'=>$unit_count,
  287. 'dinner_duration'=>$dinner_duration,
  288. 'remark'=>$remark,
  289. ]);
  290. $processDailyParticipant->save();
  291. app('LogService')->log(__METHOD__,"添加新参与人".__FUNCTION__,json_encode($processDailyParticipant),Auth::user()['id']);
  292. $processDailyParticipant->load(['processDaily'=>function($query){
  293. $query->with('process');
  294. }]);
  295. // 重置统计开始时间
  296. //event(new ResetProcessStatisticStartDateEvent($processDailyParticipant->processDaily->process));
  297. if ($processDailyParticipant->processDaily && $processDailyParticipant->processDaily->process &&
  298. $processDailyParticipant->processDaily->process->status=='交接完成'){
  299. $this->statistic($processDailyParticipant->processDaily->process);
  300. }
  301. $result=[];
  302. $processDaily=ProcessDaily::with('process')->select('process_id','date')->find($daily_id);
  303. if ($processDaily->process && $processDaily->process->status=="待加工"){
  304. $process=Process::find($processDaily->process_id);
  305. $process->status="加工中";
  306. $process->update();
  307. $result['process']=$processDaily->process_id;
  308. $processStatistic=ProcessStatistic::find($processDaily->process_id);
  309. if (!$processStatistic){
  310. Log::warning("二次加工统单不存在2",["user"=>Auth::id(),"param"=>$processDaily->process_id]);
  311. }else {
  312. $processStatistic->started_at=$processDaily->date.' '.$started_at;
  313. $processStatistic->update();
  314. app('LogService')->log(__METHOD__,"二次加工单加工中".__FUNCTION__,json_encode($process)." || ".json_encode($processStatistic),Auth::user()['id']);
  315. }
  316. }
  317. $result['status']="success";
  318. $result['data']=$processDailyParticipant;
  319. return $result;
  320. }
  321. //验证参与人
  322. public function verifyUserName(Request $request){
  323. $userName=$request->input('userName');
  324. if (!$userName) return ['success'=>false,'data'=>'未输入参与者!'];
  325. $date = $request->date;
  326. if (!$date){
  327. $processDailyParticipant=ProcessDailyParticipant::query()->find($request->id);
  328. $date=$processDailyParticipant->process_daily_date;
  329. }
  330. return $this->seekUserLabor($userName,$date);
  331. }
  332. //根据全名查询临时工
  333. public function seekUserLabor($userName,$date){
  334. $userDetails=UserDetail::with('userLabor')->where('type','临时工')->where('full_name',$userName)->get();
  335. if (!$userDetails)return ['success'=>false,'data'=>'未找到临时工信息!'];
  336. if (count($userDetails)==1){
  337. if (!$userDetails[0]->userLabor)return ['success'=>false,'data'=>'该员工非临时工身份!'];
  338. $laborReport=LaborReport::where('check_in_at','like',$date.'%')->where('user_id',$userDetails[0]->user_id)->first();
  339. if ($laborReport){
  340. $userDetails[0]->started_at=Carbon::parse($laborReport->thisRoundOnlineStartTime)->format('H:i');
  341. $userDetails[0]->ended_at=Carbon::parse($laborReport->thisRoundOnlineEndTime)->format('H:i');
  342. }
  343. return ['success'=>true,'data'=>$userDetails[0]];
  344. }
  345. //多个同名
  346. foreach ($userDetails as $userDetail){
  347. $userDutyCheck=UserDutyCheck::select('checked_at')->where("user_id",$userDetail->user_id)->orderBy('checked_at','DESC')->first();
  348. $laborReport=LaborReport::where('check_in_at','like',$date.'%')->where('user_id',$userDetail->user_id)->first();
  349. if ($laborReport) {
  350. $userDetail->started_at = Carbon::parse($laborReport->thisRoundOnlineStartTime)->format('H:i');
  351. $userDetail->ended_at = Carbon::parse($laborReport->thisRoundOnlineEndTime)->format('H:i');
  352. }
  353. if ($userDutyCheck)$userDetail->checked_at=$userDutyCheck->checked_at;
  354. }
  355. if (!$userDetails)return ['success'=>false,'data'=>'未找到临时工信息!'];
  356. return ['success'=>true,'data'=>$userDetails];
  357. }
  358. //修改参与人
  359. public function updateProcessDailyParticipant(Request $request){
  360. if(!Gate::allows('二次加工管理-登记工时')){ return redirect(url('/')); }
  361. $id=$request->input('id');
  362. if (!$id) return ['success'=>false,'data'=>"修改失败,ID未传递"];
  363. $errors=$this->validatorProcessDailyParticipant($request)->errors();
  364. if (count($errors)>0)return ['success'=>false,'data'=>$errors];
  365. $processDailyParticipant=ProcessDailyParticipant::with(['processDaily'=>function($query){
  366. $query->with('process');
  367. },'userLabor'])->find($id);
  368. if (!$processDailyParticipant || !$processDailyParticipant->processDaily
  369. || !$processDailyParticipant->processDaily->process || !$processDailyParticipant->userLabor) return ['success'=>false,'data'=>"修改失败,该信息不存在"];
  370. if ($processDailyParticipant->userLabor->isOccupiedAt($processDailyParticipant->processDaily->date,$request->started_at)){
  371. return ['success'=>false,'data'=>"该临时工此时间段已存在工作记录"];
  372. }
  373. $processDailyParticipant->user_id=$request->input('user_id');
  374. $processDailyParticipant->started_at=$request->input('started_at');
  375. $processDailyParticipant->ended_at=$request->input('ended_at');
  376. $processDailyParticipant->hour_count=$request->input('hour_count');
  377. $processDailyParticipant->unit_count=$request->input('unit_count');
  378. $processDailyParticipant->hour_price=$request->input('hour_price');
  379. $processDailyParticipant->unit_price=$request->input('unit_price');
  380. $processDailyParticipant->dinner_duration=$request->input('dinner_duration');
  381. $processDailyParticipant->remark=$request->input('remark');
  382. $processDailyParticipant->update();
  383. app('LogService')->log(__METHOD__,"修改参与人".__FUNCTION__,json_encode($processDailyParticipant),Auth::user()['id']);
  384. if ($processDailyParticipant->processDaily->process->status=='交接完成'){
  385. $this->statistic($processDailyParticipant->processDaily->process);
  386. }
  387. return ['success'=>true,'data'=>$processDailyParticipant];
  388. }
  389. //获取全部教程
  390. public function getTutorials($id){
  391. $process=Process::with('tutorials')->find($id);
  392. $tutorials_id=[];
  393. if ($process->tutorials){
  394. foreach ($process->tutorials as $tutorial){
  395. array_push($tutorials_id,$tutorial->id);
  396. }
  397. }
  398. $tutorials=Tutorial::query()->where('owner_id',$process->owner_id)->get();
  399. if ($tutorials_id && $tutorials) $tutorials=$tutorials->diff(Tutorial::whereIn('id',$tutorials_id)->get());
  400. return ['success'=>true,'data'=>$tutorials];
  401. }
  402. //添加教程关联
  403. public function selectedTutorial(Request $request){
  404. if(!Gate::allows('二次加工管理-教程管理')){ return ['success'=>false,'data'=>'您无权进行该操作!']; }
  405. $process_id=$request->input('process_id');
  406. $tutorial_id=$request->input('tutorial_id');
  407. if (!$process_id || !$tutorial_id) return ['success'=>false,'data'=>'二次加工或教程传递错误!'];
  408. $tutorial=Tutorial::find($tutorial_id);
  409. if (!$tutorial)return ['success'=>false,'data'=>'未找到相关教程!'];
  410. $tutorial->processes()->syncWithoutDetaching([$process_id]);
  411. app('LogService')->log(__METHOD__,"添加教程关联".__FUNCTION__,json_encode($process_id),Auth::user()['id']);
  412. return ['success'=>true,'data'=>$tutorial];
  413. }
  414. //删除教程关联
  415. public function deleteTutorial(Request $request){
  416. if(!Gate::allows('二次加工管理-教程管理')){ return ['success'=>false,'data'=>'您无权进行该操作!']; }
  417. $process_id=$request->input('process_id');
  418. $tutorial_id=$request->input('tutorial_id');
  419. if (!$process_id || !$tutorial_id) return ['success'=>false,'data'=>'二次加工或教程传递错误!'];
  420. DB::table('process_tutorial')->where('process_id',$process_id)->where('tutorial_id',$tutorial_id)->delete();
  421. app('LogService')->log(__METHOD__,"删除教程关联".__FUNCTION__,json_encode($process_id),Auth::user()['id']);
  422. return ['success'=>true];
  423. }
  424. /**
  425. * Show the form for creating a new resource.
  426. *
  427. * @return Application|Factory|\Illuminate\Http\Response|View
  428. */
  429. public function create()
  430. {
  431. if(!Gate::allows('二次加工管理-录入')){ return view("exception.authority"); }
  432. $processMethods=ProcessMethod::query()->get();
  433. $users = User::query()->whereNotNull("email")->whereHas("roles",function ($query){
  434. /** @var Builder $query */
  435. $query->whereHas("authorities",function($query){
  436. /** @var Builder $query */
  437. $query->where("alias_name","二次加工管理-接单与驳回");
  438. });
  439. })->orWhereIn("name",config("users.superAdmin"))->get();
  440. return view('process/create',['processMethods'=>$processMethods,'process'=>null,"users"=>$users]);
  441. }
  442. //货主ID获取教程
  443. public function ownerGetTutorials($owner_id){
  444. $tutorials=Tutorial::query()->where('owner_id',$owner_id)->get();
  445. return $tutorials;
  446. }
  447. public function store(Request $request)
  448. {
  449. if(!Gate::allows('二次加工管理-录入')){ return redirect(url('/')); }
  450. $errors=$this->validatorProcess($request)->errors();
  451. if (count($errors)>0)return ['error'=>$errors,'data'=>"process"];
  452. $errors=[];
  453. foreach ($request->input('processContents') as $processContent){
  454. if ($processContent['addBtnShow'])continue;
  455. $error=$this->validatorProcessContent($processContent)->errors();
  456. if (count($error)>0)$errors[$processContent['wms_code']]=$error;
  457. }
  458. if (count($errors)>0)return ['error'=>$errors];
  459. $process=new Process([
  460. 'code'=>Uuid::uuid1(),
  461. 'owner_id'=>$request->input('owner_id'),
  462. 'process_method_id'=>$request->input('process_method_id'),
  463. 'unit_price'=>$request->input('unit_price'),
  464. 'remark'=>$request->input('remark'),
  465. 'balance_remark'=>$request->input('balance_remark'),
  466. 'amount'=>$request->input('amount'),
  467. 'designate_id'=>$request->input('designate_id'),
  468. 'status'=>'待审核',
  469. ]);
  470. $process->save();
  471. ProcessStatistic::query()->create([
  472. 'process_id'=>$process->id,
  473. ]);
  474. $process->createOperatorLog('创建');
  475. $processContents=[];
  476. foreach ($request->input('processContents') as $processContent){
  477. $wmsCode_commoditySku=$processContent['wms_code'].'_'.$processContent['commodity_id'].'_'.$processContent['type'];
  478. array_push($processContents,$wmsCode_commoditySku);
  479. }
  480. $removeDuplicateProcessContents=array_unique($processContents);
  481. if (count($processContents)>count($removeDuplicateProcessContents)){
  482. return ['success'=>false,'data'=>'录入商品不可重复!'];
  483. }else{
  484. foreach ($request->input('processContents') as $processContent){
  485. if ($processContent['addBtnShow'])continue;
  486. $processContentOne=new ProcessesContent([
  487. 'process_id'=>$process->id,
  488. 'bill_type'=>$processContent['bill_type'],
  489. 'commodity_id'=>$processContent['commodity_id'],
  490. 'wms_code'=>$processContent['wms_code'],
  491. 'amount'=>$processContent['amount'],
  492. ]);
  493. if ($processContent['type'])$processContentOne->type='成品单';
  494. $processContentOne->save();
  495. if (isset($processContent['is_update_commodity_name'])){
  496. Sign::query()->create([
  497. 'signable_type'=>'processes_contents',
  498. 'signable_id'=>$processContentOne->id,
  499. 'field'=>'commodity_name',
  500. 'mark'=>$processContent['commodity_name'],
  501. ]);
  502. }
  503. if (isset($processContent['commodity_barcode'])){
  504. Sign::query()->create([
  505. 'signable_type'=>'processes_contents',
  506. 'signable_id'=>$processContentOne->id,
  507. 'field'=>'commodity_barcode',
  508. 'mark'=>$processContent['commodity_barcode'],
  509. ]);
  510. }
  511. if (isset($processContent['is_update_commodity_sku'])){
  512. Sign::query()->create([
  513. 'signable_type'=>'processes_contents',
  514. 'signable_id'=>$processContentOne->id,
  515. 'field'=>'commodity_sku',
  516. 'mark'=>$processContent['commodity_sku'],
  517. ]);
  518. }
  519. }
  520. }
  521. $process->code='P'.date ("Ymd").str_pad($process->id,3,"0",STR_PAD_LEFT);
  522. $process->update();
  523. return ['success'=>true];
  524. }
  525. //修改价格
  526. function updateUnitPrice(Request $request){
  527. if(!Gate::allows('二次加工管理-修改价格')){ return ['success'=>false,'data'=>'您无权进行该操作!']; }
  528. $errors=Validator::make($request->input(),[
  529. 'id' => 'required',
  530. 'unit_price'=>['required','numeric'],
  531. ])->errors();
  532. if (count($errors)>0)return ['success'=>false,'data'=>'非法参数!'];
  533. $process=Process::with('signs')->find($request->id);
  534. if (!$process || $process->status!='交接完成' || count($process->signs)>0)return ['success'=>false,'data'=>'无法操作该二次加工单!'];
  535. $process->createSignUnitPrice($request->unit_price);
  536. $sign=$process->createSign('发起修改');
  537. app('LogService')->log(__METHOD__,"修改二次加工单价格_".__FUNCTION__,json_encode($request->input()),Auth::user()['id']);
  538. return ['success'=>true,'sign'=>$sign];
  539. }
  540. //二次加工组审核 两个方法大体相同 拆分原因是为了精确区分权限
  541. function workGroupVerify(Request $request){
  542. if(!Gate::allows('二次加工管理-组长确认')){ return ['success'=>false,'data'=>'您无权进行该操作!']; }
  543. app('LogService')->log(__METHOD__,"修改二次加工单价格二次加工组确认_".__FUNCTION__,json_encode($request->input()),Auth::user()['id']);
  544. return $this->verify($request->id,'二次加工组确认');
  545. }
  546. //二次加工组审核
  547. function accountantVerify(Request $request){
  548. if(!Gate::allows('二次加工管理-财务确认')){ return ['success'=>false,'data'=>'您无权进行该操作!']; }
  549. app('LogService')->log(__METHOD__,"修改二次加工单价格财务确认_".__FUNCTION__,json_encode($request->input()),Auth::user()['id']);
  550. return $this->verify($request->id,'财务确认');
  551. }
  552. private function verify($id,$msg){
  553. $process=Process::with(['signs','processDailies'])->find($id);
  554. if (!$process || count($process->signs)<1)return false;
  555. $signMap=[];
  556. foreach ($process->signs as $sign){
  557. $signMap[$sign->mark]=true;
  558. }
  559. if (isset($signMap[$msg]))return ['success'=>false,'data'=>'该单已被确认过!'];
  560. if (isset($signMap['二次加工组确认'])){
  561. $signUnitPrice=$process->signUnitPrice;
  562. DB::beginTransaction();
  563. if ($signUnitPrice){
  564. $process->update(['unit_price' => $signUnitPrice->mark]);
  565. $this->statistic($process);
  566. }
  567. $process->createSign('财务确认');
  568. $process->destroySign();
  569. DB::commit();
  570. return ['success'=>true,'data'=>false];
  571. }
  572. if (isset($signMap['财务确认'])){
  573. $signUnitPrice=$process->signUnitPrice;
  574. DB::beginTransaction();
  575. if ($signUnitPrice){
  576. $process->update(['unit_price' => $signUnitPrice->mark]);
  577. $this->statistic($process);
  578. }
  579. $process->createSign('二次加工组确认');
  580. $process->destroySign();
  581. DB::commit();
  582. return ['success'=>true,'data'=>false];
  583. }
  584. $sign = $process->createSign($msg);
  585. return ['success'=>true,'data'=>$sign];
  586. }
  587. //审核
  588. function audit(Request $request){
  589. if(!Gate::allows('二次加工管理-审核')){ return ['success'=>false,'data'=>'您无权进行该操作!']; }
  590. $process=Process::query()->find($request->id);
  591. if (!$process)return ['success'=>false];
  592. $process->update(['status'=>'待接单']);
  593. $process->createOperatorLog('审核');
  594. app('LogService')->log(__METHOD__,"二次加工单审核_".__FUNCTION__,json_encode($request->input()),Auth::user()['id']);
  595. return ['success'=>true];
  596. }
  597. /**
  598. * Show the form for editing the specified resource.
  599. *
  600. * @param int $id
  601. * @return Application|Factory|\Illuminate\Http\Response|View
  602. */
  603. public function edit($id)
  604. {
  605. if(!Gate::allows('二次加工管理-编辑')){ return redirect(url('/')); }
  606. $process=Process::with(['processesContents'=>function($query){
  607. return $query->with(['signCommodityName','signCommoditySku','signCommodityBarcode','commodity'=>function($query){
  608. return $query->with('barcodes');
  609. }]);
  610. }])->find($id);
  611. $processMethods=ProcessMethod::get();
  612. $users = User::query()->whereNotNull("email")->whereHas("roles",function ($query){
  613. /** @var Builder $query */
  614. $query->whereHas("authorities",function($query){
  615. /** @var Builder $query */
  616. $query->where("alias_name","二次加工管理-接单与驳回");
  617. });
  618. })->orWhereIn("name",config("users.superAdmin"))->get();
  619. return view('process.create',['process'=>$process,'processMethods'=>$processMethods,"users"=>$users]);
  620. }
  621. public function show($id){
  622. $process=Process::with(['processesContents'=>function($query){
  623. $query->with(['signCommodityName','signCommoditySku','signCommodityBarcode','commodity'=>function($query){
  624. $query->with('barcodes');
  625. }]);
  626. },'tutorials'])->find($id);
  627. return view('process.show',compact('process'));
  628. }
  629. /**
  630. * Update the specified resource in storage.
  631. *
  632. * @param Request $request
  633. * @param int $id
  634. * @return array
  635. */
  636. public function update(Request $request, $id)
  637. {
  638. if(!Gate::allows('二次加工管理-编辑')){ return ['success'=>false,'data'=>'您无权进行该操作!']; }
  639. $errors=$this->validatorProcess($request)->errors();
  640. if (count($errors)>0)return ['error'=>$errors,'data'=>"process"];
  641. $errors=[];
  642. foreach ($request->input('processContents') as $processContent){
  643. if ($processContent['addBtnShow'])continue;
  644. $error=$this->validatorProcessContent($processContent)->errors();
  645. if (count($error)>0)$errors[$processContent['wms_code']]=$error;
  646. }
  647. if (count($errors)>0)return ['error'=>$errors];
  648. $process=Process::query()->find($id);
  649. if (!$request->is_hide){
  650. $process->owner_id=$request->input('owner_id');
  651. $process->process_method_id=$request->input('process_method_id');
  652. $process->unit_price=$request->input('unit_price');
  653. $process->remark=$request->input('remark');
  654. $process->balance_remark=$request->input('balance_remark');
  655. $process->amount=$request->input('amount');
  656. $process->designate_id=$request->input('designate_id');
  657. if ($process->status=='已驳回')$process->status='待接单';
  658. $process->update();
  659. $process->createOperatorLog('编辑');
  660. }
  661. $processContents=[];
  662. foreach ($request->input('processContents') as $processContent){
  663. $wmsCode_commoditySku=$processContent['wms_code'].'_'.$processContent['commodity_sku'].'_'.$processContent['type'];
  664. array_push($processContents,$wmsCode_commoditySku);
  665. }
  666. $removeDuplicateProcessContents=array_unique($processContents);
  667. if (count($processContents)>count($removeDuplicateProcessContents)){
  668. return ['success'=>false,'data'=>'录入商品不可重复!'];
  669. }else{
  670. $ProcessesContents=ProcessesContent::where('process_id',$process->id)->get();
  671. $ids=array_column($ProcessesContents->toArray(),'id');
  672. Sign::query()->where('signable_type','processes_contents')->whereIn('signable_id',$ids)->delete();
  673. ProcessesContent::where('process_id',$process->id)->delete();
  674. foreach ($request->input('processContents') as $processContent){
  675. if ($processContent['addBtnShow'])continue;
  676. $processContentOne=new ProcessesContent([
  677. 'process_id'=>$process->id,
  678. 'bill_type'=>$processContent['bill_type'],
  679. 'commodity_id'=>$processContent['commodity_id'],
  680. 'wms_code'=>$processContent['wms_code'],
  681. 'amount'=>$processContent['amount'],
  682. ]);
  683. if ($processContent['type'])$processContentOne->type='成品单';
  684. $processContentOne->save();
  685. if (isset($processContent['is_update_commodity_name'])){
  686. Sign::query()->updateOrCreate([
  687. 'signable_type'=>'processes_contents',
  688. 'signable_id'=>$processContentOne->id,
  689. 'field'=>'commodity_name',
  690. ],[
  691. 'signable_type'=>'processes_contents',
  692. 'signable_id'=>$processContentOne->id,
  693. 'field'=>'commodity_name',
  694. 'mark'=>$processContent['commodity_name'],
  695. ]);
  696. }
  697. if (isset($processContent['commodity_barcode'])){
  698. Sign::query()->updateOrCreate([
  699. 'signable_type'=>'processes_contents',
  700. 'signable_id'=>$processContentOne->id,
  701. 'field'=>'commodity_barcode',
  702. ],[
  703. 'signable_type'=>'processes_contents',
  704. 'signable_id'=>$processContentOne->id,
  705. 'field'=>'commodity_barcode',
  706. 'mark'=>$processContent['commodity_barcode'],
  707. ]);
  708. }
  709. if (isset($processContent['is_update_commodity_sku'])){
  710. Sign::query()->updateOrCreate([
  711. 'signable_type'=>'processes_contents',
  712. 'signable_id'=>$processContentOne->id,
  713. 'field'=>'commodity_sku',
  714. ],[
  715. 'signable_type'=>'processes_contents',
  716. 'signable_id'=>$processContentOne->id,
  717. 'field'=>'commodity_sku',
  718. 'mark'=>$processContent['commodity_sku'],
  719. ]);
  720. }
  721. }
  722. }
  723. app('LogService')->log(__METHOD__,"编辑二次加工单_".__FUNCTION__,json_encode($request->input()),Auth::user()['id']);
  724. return ['success'=>true];
  725. }
  726. //删除二次加工内容单 弃用,保留,改为全部提交后一次性验证,不在操作时就允许删除
  727. public function deleteProcessContent($id){
  728. if(!Gate::allows('二次加工管理-删除')){ return redirect(url('/')); }
  729. $processContent=ProcessesContent::find($id);
  730. if (!$processContent) return ['success'=>false,'data'=>'未找到对应二次加工内容单'];
  731. $processContent->delete();
  732. return ['success'=>true];
  733. }
  734. //回滚二次加工单状态
  735. function rollback(Request $request){
  736. if(!Gate::allows('二次加工管理-回滚')){ return ['success'=>false,'data'=>'您无权进行该操作!']; }
  737. if (!$request->id)return ['success'=>false];
  738. $process=Process::query()->find($request->id);
  739. switch ($process->status){
  740. case '待接单':
  741. $process->status='待审核';break;
  742. case '待加工':
  743. $process->status='待接单';break;
  744. case '已驳回':
  745. $process->status='待审核';break;
  746. case '加工中':
  747. $process->status='待接单';break;
  748. case '待验收':
  749. $process->status='加工中';break;
  750. case '待交接':
  751. $process->status='待验收';break;
  752. }
  753. $process->save();
  754. $process->createOperatorLog('回滚');
  755. app('LogService')->log(__METHOD__,"回滚二次加工单_".__FUNCTION__,json_encode($request->input()),Auth::user()['id']);
  756. return ['success'=>true,'data'=>$process->status];
  757. }
  758. //加工完成
  759. function processAccomplish(Request $request){
  760. if(!Gate::allows('二次加工管理-登记工时')){ return ['success'=>false,'data'=>'您无权进行该操作!']; }
  761. $process= Process::query()->find($request->id);
  762. if (!$process)return ['success'=>false];
  763. $process->update([
  764. 'status'=>'待验收'
  765. ]);
  766. $process->createOperatorLog('加工完成');
  767. app('LogService')->log(__METHOD__,"标记加工完成_".__FUNCTION__,json_encode($request->input()),Auth::user()['id']);
  768. return ['success'=>true,'data'=>'待验收'];
  769. }
  770. //质量验收
  771. function checkAndAccept(Request $request){
  772. $process = Process::query()->with('processDailies')->find($request->id);
  773. if (!$process)return ['success'=>false];
  774. $process->load(['processesContents'=>function($query){
  775. $query->where('type','成品单');
  776. }]);
  777. if (count($process->processesContents) == 0)return ['success'=>false,'data'=>'没有成本单不得验收!'];
  778. $this->statistic($process, true);
  779. $process->update([
  780. 'status'=>'待交接'
  781. ]);
  782. $process->createOperatorLog('质量验收');
  783. app('LogService')->log(__METHOD__,"质量验收二次加工单_".__FUNCTION__,json_encode($request->input()),Auth::user()['id']);
  784. return ['success'=>true,'data'=>'待交接'];
  785. }
  786. //回收站
  787. function recycle(Request $request){
  788. if(!Gate::allows('二次加工管理-删除')){ return redirect('/'); }
  789. $processes=Process::filterAuthorities()->onlyTrashed()->paginate($request->paginate??50);
  790. return view('process.recycle',compact('processes'));
  791. }
  792. //回收站恢复
  793. function recover(Request $request){
  794. if(!Gate::allows('二次加工管理-删除')){ return redirect('/'); }
  795. $checkData=$request->checkData;
  796. app('LogService')->log(__METHOD__,"回收站恢复二次加工单_".__FUNCTION__,json_encode($request->input()),Auth::user()['id']);
  797. return ['success'=>Process::withTrashed()->whereIn('id',$checkData)->restore()];
  798. }
  799. /**
  800. * Remove the specified resource from storage.
  801. * @param int $id
  802. * @return array
  803. */
  804. public function destroy($id)
  805. {
  806. if(!Gate::allows('二次加工管理-删除')){ return redirect('/'); }
  807. app('LogService')->log(__METHOD__,"删除二次加工单进回收站_".__FUNCTION__,json_encode($id),Auth::user()['id']);
  808. return ['success'=>Process::destroy($id)];
  809. }
  810. //修改二次加工单每日单的起始日期
  811. public function updateStartDate(Request $request){
  812. $start_date=$request->date;
  813. $process_id=$request->process_id;
  814. if (!$start_date || !$process_id)return ['success'=>false,'data'=>'起始日期为空或单据已不存在!'];
  815. $processDailiesId=[];
  816. $processDailies=ProcessDaily::where('process_id',$process_id)->get();
  817. $is_process_daily=false;
  818. foreach ($processDailies as $processDaily){
  819. if ($processDaily->date == $start_date){
  820. $is_process_daily=true;
  821. }
  822. if (Carbon::parse($processDaily->date)->lt(Carbon::parse($start_date))){
  823. array_push($processDailiesId,$processDaily->id);
  824. unset($processDaily);
  825. }
  826. }
  827. $process=Process::find($process_id);
  828. if (count($processDailiesId) > 0){
  829. ProcessDaily::destroy($processDailiesId);
  830. ProcessDailyParticipant::whereIn('process_daily_id',$processDailiesId)->delete();
  831. event(new ResetProcessStatisticStartDateEvent($process));
  832. }
  833. if (!$is_process_daily && $process){
  834. $ProcessDailyNow=ProcessDaily::create([
  835. 'process_id'=>$process_id,
  836. 'date'=>$start_date,
  837. 'output'=>0,
  838. 'remain'=>$process->amount,
  839. ]);
  840. $processDailies->push($ProcessDailyNow);
  841. }
  842. $today=Carbon::parse($start_date)->format('Y-m-d');
  843. $this->createDeficiencyData($processDailies,$today);
  844. $processDailies=ProcessDaily::with('processDailyParticipants')->where('process_id',$process_id)
  845. ->orderBy('date','DESC')->get();
  846. app('LogService')->log(__METHOD__,"修改二次加工单加工日记录_".__FUNCTION__,json_encode($request),Auth::user()['id']);
  847. return ['success'=>true,'data'=>$processDailies];
  848. }
  849. //修改二次加工单终止日期
  850. public function updateEndDate(Request $request){
  851. $end_date=$request->date;
  852. $process_id=$request->process_id;
  853. if (!$end_date || !$process_id)return ['success'=>false,'data'=>'终止日期为空或单据已不存在!'];
  854. $processDailiesId=[];
  855. $processDailies=ProcessDaily::where('process_id',$process_id)->orderBy('date','DESC')->get();
  856. foreach ($processDailies as $processDaily){
  857. if (Carbon::parse($processDaily->date)->gt(Carbon::parse($end_date))){
  858. array_push($processDailiesId,$processDaily->id);
  859. unset($processDaily);
  860. }
  861. }
  862. ProcessDaily::destroy($processDailiesId);
  863. ProcessDailyParticipant::whereIn('process_daily_id',$processDailiesId)->delete();
  864. $this->createDeficiencyData($processDailies,$end_date);
  865. $processDailies=ProcessDaily::with('processDailyParticipants')->where('process_id',$process_id)
  866. ->orderBy('date','DESC')->get();
  867. $this->createAutomaticSupplement($process_id);
  868. app('LogService')->log(__METHOD__,"修改二次加工单加工日记录_".__FUNCTION__,json_encode($request),Auth::user()['id']);
  869. return ['success'=>true,'data'=>$processDailies];
  870. }
  871. //增加填充标记
  872. private function createAutomaticSupplement($process_id){
  873. Sign::query()->firstOrCreate([
  874. 'signable_type'=>'processes',
  875. 'signable_id'=>$process_id,
  876. 'field'=>'automatic_supplement',
  877. 'mark'=>"停止自动补充每日记录单"
  878. ]);
  879. }
  880. //删除临时工工作记录
  881. public function destroyDailyParticipant($id){
  882. $pro = ProcessDailyParticipant::query()->with(["processDaily"=>function($query){
  883. /** @var Builder $query */
  884. $query->with("process");
  885. }])->find($id);
  886. if ($pro->delete()) {
  887. //event(new ResetProcessStatisticStartDateEvent($pro->processDaily->process));
  888. return ['success'=>true];
  889. }
  890. return ['success'=>false , 'data'=>'记录不存在!'];
  891. }
  892. //导入商品数据
  893. public function importPasteData(Request $request){
  894. $commodities = explode("\n",$request->data); //拆分行
  895. $owner='';
  896. $processContents=[];
  897. $errors = [];
  898. foreach ($commodities as $i => $commodity){
  899. if ($i==0 && mb_strpos($commodity,'货主')!==false && mb_strpos($commodity,'品名')!==false
  900. && mb_strpos($commodity,'数量')!==false)continue;
  901. $commodity = explode("\t",$commodity); //拆分列
  902. $head="第".($i+1)."行";
  903. if (count($commodity)<count($request->rows)){
  904. $errors[$head] = ['数据不完整'];
  905. unset($commodity);
  906. continue;
  907. }
  908. $commodityData=[];
  909. $wmsCode='';
  910. $barcode='';
  911. $amount=0;
  912. $errors[$head] = [];
  913. foreach ($request->rows as $index => $row){
  914. if ($row == '货主'){
  915. if ($commodity[$index] && !$owner){
  916. $owner = $commodity[$index];
  917. }
  918. if (!$commodity[$index])array_push($errors[$head],"货主为空");
  919. }
  920. if ($row == '单据号'){
  921. $wmsCode = $commodity[$index] ?? '';
  922. }
  923. if ($row == 'SKU'){
  924. $commodityData['sku'] = $commodity[$index] ?? '';
  925. if (!$commodity[$index])array_push($errors[$head],"SKU为空");
  926. }
  927. if ($row == '品名'){
  928. $commodityData['name'] = $commodity[$index] ?? '';
  929. if (!$commodity[$index])array_push($errors[$head],"品名为空");
  930. }
  931. if ($row == '条码'){
  932. $barcode = $commodity[$index] ?? '';
  933. }
  934. if ($row == '数量'){
  935. $amount = $commodity[$index] ?? '';
  936. if (!$commodity[$index])array_push($errors[$head],"数量为空");
  937. if (!is_numeric($commodity[$index]) || $commodity[$index] < 1)array_push($errors[$head],"数量为空或小于1");
  938. }
  939. }
  940. if (count($errors[$head]) > 0)continue;
  941. else unset($errors[$head]);
  942. if (!is_object($owner)){
  943. $str = $owner;
  944. if (!$str) throw new \Exception('未找到货主!');
  945. $owner=Owner::query()->whereNull("deleted_at")->where(function ($query)use($str){
  946. $query->where('code',$str)->orWhere('name',$str);
  947. })->first();
  948. if (!$owner){
  949. $owner=Owner::query()->whereNotNull("deleted_at")->where(function ($query)use($str){
  950. $query->where('code',$str)->orWhere('name',$str);
  951. })->first();
  952. if (!$owner){
  953. $owner = Owner::query()->create([
  954. 'code' => $str,
  955. 'name' => $str
  956. ]);
  957. Log::info("二次加工录入货主",["owner"=>$owner->toJson(),"user"=>Auth::id()]);
  958. }else{
  959. $owner->update(["deleted_at"=>null]);
  960. Log::info("二次加工恢复货主",["owner"=>$owner->toJson(),"user"=>Auth::id()]);
  961. }
  962. }
  963. }
  964. $goods = Commodity::query()->with('barcodes')->where('owner_id',$owner->id)//->whereNull('owner_id') 保留,暂时不知为何限定货主为空
  965. ->where('sku',$commodityData['sku'])->first();
  966. $commodity_barcodes = [];
  967. if (!$goods){
  968. $goods = Commodity::query()->create($commodityData);
  969. if ($barcode){
  970. $commodityBarCode=CommodityBarcode::query()->create([
  971. 'code' => $barcode,
  972. 'commodity_id' => $goods->id
  973. ]);
  974. $commodity_barcodes = [$commodityBarCode];
  975. }
  976. }else {
  977. if ($barcode){
  978. $commodity_barcodes = $goods->barcodes->toArray();
  979. $commodityBarCode = $goods->barcodes->where('code',$barcode)->first();
  980. if (!$commodityBarCode){
  981. $commodityBarCode = CommodityBarcode::query()->create([
  982. 'code' => $barcode,
  983. 'commodity_id' => $goods->id
  984. ]);
  985. array_push($commodity_barcodes,$commodityBarCode);
  986. }
  987. }
  988. }
  989. app('LogService')->log(__METHOD__,"二次加工单录入导入商品数据时添加商品及条码".__FUNCTION__,
  990. json_encode($goods)." || ".json_encode($commodity_barcodes),Auth::user()['id']);
  991. $processContent=['bill_type'=>'入库单','commodity_id'=>$goods->id,'wms_code'=>$wmsCode,'amount'=>$amount,
  992. 'commodity_name'=>$goods->name,'commodity_barcodes'=>$commodity_barcodes,'commodity_sku'=>$goods->sku,
  993. 'lineNo'=>1,'owner_id'=>$owner->id,'owner_name'=>$owner->name,'addBtnShow'=>false,'type'=>$request->type];
  994. array_push($processContents,$processContent);
  995. }
  996. return ['success'=>true,'data'=>$processContents,'errors'=>count($errors)>0?$errors:''];
  997. }
  998. //导出
  999. public function export(Request $request){
  1000. if(!Gate::allows('二次加工管理-查询')){ return '没有权限'; }
  1001. if ($request->checkAllSign){
  1002. $params = $request->input();
  1003. unset($params['checkAllSign']);
  1004. $sql = app('ProcessService')->getSql($params);
  1005. }else $sql = app('ProcessService')->getSql(["id"=>$request->data]);
  1006. $e = new Export();
  1007. $e->setMysqlConnection(config('database.connections.mysql.host'),
  1008. config('database.connections.mysql.port'),config('database.connections.mysql.database')
  1009. ,config('database.connections.mysql.username'),config('database.connections.mysql.password'));
  1010. $e->setFileName("二次加工记录-".date('ymdHis'));
  1011. return $e->sql($sql,[
  1012. "code"=>"任务号","owner_name"=>"货主",
  1013. "process_method_name"=>"加工类型","amount"=>"预期数量",
  1014. "completed_amount"=>"实际数量","status"=>"状态",
  1015. "remark"=>"加工备注","unit_price"=>"单价",
  1016. "created_at"=>"提交日期","content_bill_type"=>"单据类型","content_wms_code"=>"单据号",
  1017. "commodity_sku"=> "商品编码","commodity_name"=>"商品名称","commodity_barcode_code"=>"商品条码",
  1018. "content_amount"=>"本次数量","process_balance_remark"=>"结算备注"])->direct();
  1019. }
  1020. public function validatorProcessContent(array $processContent){
  1021. $validator=Validator::make($processContent,[
  1022. 'commodity_id'=>['required','integer'],
  1023. 'bill_type'=>['required'],
  1024. 'amount'=>['required','integer']
  1025. ],[
  1026. 'required'=>':attribute 不应为空',
  1027. 'min'=>':attribute 不得为0或为负',
  1028. 'integer'=>':attribute 必须为整数',
  1029. 'max'=>':attribute 输入值过大',
  1030. ],[
  1031. 'commodity_id'=>'商品',
  1032. 'bill_type'=>'单据类型',
  1033. 'amount'=>'商品数量',
  1034. ]);
  1035. return $validator;
  1036. }
  1037. public function validatorProcess(Request $request){
  1038. $validator=Validator::make($request->input(),[
  1039. 'owner_id'=>['required'],
  1040. 'process_method_id'=>['required','integer'],
  1041. 'amount'=>['required','integer'],
  1042. 'unit_price'=>['required','min:0','max:999999','numeric'],
  1043. ],[
  1044. 'required'=>':attribute 不应为空',
  1045. 'min'=>':attribute 不得为0或为负',
  1046. 'numeric'=>':attribute 必须为数字',
  1047. 'max'=>':attribute 输入值过大',
  1048. 'integer' =>':attribute 必须为整数',
  1049. ],[
  1050. 'owner_id'=>'货主',
  1051. 'process_method_id'=>'加工类型',
  1052. 'amount'=>'数量',
  1053. 'unit_price'=>'单价',
  1054. ]);
  1055. return $validator;
  1056. }
  1057. public function validator(Request $request){
  1058. $validator=Validator::make($request->input(),[
  1059. 'id'=>['required','integer'],
  1060. 'output'=>'required|min:0|max:999999|numeric',
  1061. ],[
  1062. 'required'=>':attribute 不应为空',
  1063. 'min'=>':attribute 不得为0或为负',
  1064. 'numeric'=>':attribute 必须为数字',
  1065. 'max'=>':attribute 输入值过大',
  1066. ],[
  1067. 'output'=>'每日产量'
  1068. ]);
  1069. return $validator;
  1070. }
  1071. //参与人信息校验
  1072. public function validatorProcessDailyParticipant(Request $request){
  1073. $validator=Validator::make($request->input(),[
  1074. 'daily_id'=>'filled',
  1075. 'user_id'=>'required',
  1076. 'started_at'=>'required|date_format:H:i',
  1077. 'ended_at'=>'required|date_format:H:i',
  1078. 'hour_price'=>'nullable|min:0|max:999999|nullable|numeric',
  1079. 'unit_price'=>'nullable|min:0|max:999999|nullable|numeric',
  1080. 'dinner_duration'=>'nullable|integer',
  1081. 'hour_count'=>'required_with:hour_price|min:0|max:999999|nullable|numeric',
  1082. 'unit_count'=>'required_with:unit_price|min:0|max:999999|nullable|numeric',
  1083. 'remark'=>'nullable',
  1084. ],[
  1085. 'required'=>':attribute 不应为空',
  1086. 'min'=>':attribute 不得为0或为负',
  1087. 'numeric'=>':attribute 必须为数字',
  1088. 'max'=>':attribute 输入值过大',
  1089. 'required_without'=>':attribute 计时与计件至少填一项',
  1090. 'date_format'=>':attribute 格式错误',
  1091. 'integer'=>':attribute 选择错误',
  1092. 'required_with'=>':attribute 必须填写',
  1093. ],[
  1094. 'daily_id'=>'所属每日单',
  1095. 'user_id'=>'参与人',
  1096. 'started_at'=>'开始时间',
  1097. 'ended_at'=>'结束时间',
  1098. 'hour_price'=>'计时单价',
  1099. 'unit_price'=>'计件单价',
  1100. 'dinner_duration'=>'晚饭时间',
  1101. 'hour_count'=>'计时工时',
  1102. 'unit_count'=>'计件数量',
  1103. 'remark'=>'备注',
  1104. ]);
  1105. return $validator;
  1106. }
  1107. }