ProcessController.php 58 KB

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