ProcessController.php 56 KB

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