ProcessController.php 55 KB

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