ProcurementController.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240
  1. <?php
  2. namespace App\Http\Controllers\api\thirdPart\weixin;
  3. use App\Components\ApiProcurementResponse;
  4. use App\Http\Controllers\Controller;
  5. use App\Procurement;
  6. use App\ProcurementCheckSheet;
  7. use App\ProcurementDeliverie;
  8. use App\ProcurementQuotation;
  9. use App\ProcurementTotalBill;
  10. use App\Services\api\UserService;
  11. use App\Services\ProcurementService;
  12. use App\Services\SupplierService;
  13. use Carbon\Carbon;
  14. use Illuminate\Database\Eloquent\Builder;
  15. use Illuminate\Http\Request;
  16. use Illuminate\Support\Facades\Auth;
  17. use Illuminate\Support\Facades\DB;
  18. class ProcurementController extends Controller
  19. {
  20. use ApiProcurementResponse;
  21. public function getWaitQuotation(Request $request): \Illuminate\Http\JsonResponse
  22. {
  23. $user=Auth::user();
  24. /**@var SupplierService $supplierService*/
  25. $supplierService=app(SupplierService::class);
  26. $supplier_ids=$supplierService->screenSupplierIds();
  27. $status=$request->input('status');//0:待报价,2:待接单
  28. $procurements=Procurement::query()
  29. ->withCount('procurementQuotations')
  30. ->with('ownerMaterial.material')
  31. ->where('status',$status)
  32. ->whereHas("ownerMaterial",function (Builder $query)use($supplier_ids){
  33. $query->whereHas("material",function (Builder $query)use($supplier_ids){
  34. $query->whereHas("supplier",function (Builder $query)use($supplier_ids){
  35. $query->whereIn('id',$supplier_ids);
  36. });
  37. });
  38. })
  39. ->get();
  40. $keys = [];
  41. foreach ($procurements as $key=>$procurement){
  42. // if ($procurement->procurement_quotations_count>0 && $status==0 )$keys[]= $key;
  43. if ($procurement->procurement_quotations_count>0 && !$user->isSuperAdmin()){
  44. foreach ($procurement->procurementQuotations as $procurementQuotation){
  45. if (in_array($procurementQuotation->supplier_id,$supplier_ids))$keys[]= $key;
  46. }
  47. }
  48. if ($procurement->type==2 && $procurement->supplier_id )$keys[]= $key;
  49. if (Carbon::parse($procurement->deadline)->gt(Carbon::now())) $procurement->deadline=Carbon::parse($procurement->deadline)->diffInMilliseconds();
  50. else $procurement->deadline=0;
  51. }
  52. $procurements = $procurements->diffKeys($keys);
  53. if (!empty($procurements)) return $this->success($procurements);
  54. }
  55. public function getQuotationDetailById(Request $request): \Illuminate\Http\JsonResponse
  56. {
  57. $id=$request->input('id');
  58. $procurement=Procurement::query()
  59. ->with(['ownerMaterial.material','ownerMaterial.owner','ownerMaterial.file'])
  60. ->find($id);
  61. $procurement->deadline=Carbon::parse($procurement->deadline)->diffInMilliseconds(Carbon::now());
  62. if ($procurement) return $this->success($procurement);
  63. }
  64. //报价
  65. public function setOffer(Request $request): \Illuminate\Http\JsonResponse
  66. {
  67. $param=$request->all(['id','offer']);
  68. $user= Auth::user();
  69. $procurement=Procurement::query()->with('ownerMaterial.material')->find($param['id']);
  70. $material=$procurement->ownerMaterial->material;
  71. /** @var ProcurementService $procurementService*/
  72. $procurementService=app(ProcurementService::class);
  73. $supplier=$procurementService->screenSupplier($user,$material);
  74. $procurementQuotation=ProcurementQuotation::query()->create([
  75. 'procurement_id'=>$param['id'],
  76. 'offer'=>$param['offer'],
  77. 'operator'=>$user->id,
  78. 'supplier_id'=>$supplier->id,
  79. 'quoted_at'=>Carbon::now()->toDateTimeString(),
  80. 'status'=>1,//1:已报价
  81. ]);
  82. DB::transaction(function ()use($procurement,$param,$supplier){
  83. if (!$procurement->supplier_id)$procurement->update([
  84. "supplier_id" => $supplier->id,
  85. // "status" =>1,
  86. "cost_price" =>$param['offer'],
  87. ]);
  88. DB::commit();
  89. });
  90. if ($procurementQuotation) return $this->success($procurementQuotation);
  91. }
  92. //接单
  93. public function accept(Request $request): \Illuminate\Http\JsonResponse
  94. {
  95. $id=$request->input('id');
  96. $user= Auth::user();
  97. $procurement=Procurement::query()->with('ownerMaterial.material')->find($id);
  98. if ($procurement->type==2){
  99. $material=$procurement->ownerMaterial->material;
  100. /** @var ProcurementService $procurementService*/
  101. $procurementService=app(ProcurementService::class);
  102. $supplier=$procurementService->screenSupplier($user,$material);
  103. $procurement->update(['status'=>4,'supplier_id'=>$supplier->id,'deadline'=>Carbon::now()->toDateTimeString()]);//4:生产中
  104. }else{
  105. $procurement->update(['status'=>4,'deadline'=>Carbon::now()->toDateTimeString()]);//4:生产中
  106. }
  107. if ($procurement) return $this->success($procurement);
  108. }
  109. //生产中的订单
  110. public function getProductionProcurement(): \Illuminate\Http\JsonResponse
  111. {
  112. /**@var SupplierService $supplierService*/
  113. $supplierService=app(SupplierService::class);
  114. $supplier_ids=$supplierService->screenSupplierIds();
  115. $procurements=Procurement::query()
  116. ->with('ownerMaterial.material')
  117. ->whereIn('type',[0,2])
  118. ->where('status',4) //4:生产中
  119. ->whereIn('supplier_id',$supplier_ids)
  120. ->get();
  121. if ($procurements) return $this->success($procurements);
  122. }
  123. //结束生产
  124. public function finishProductionProcurement(Request $request): \Illuminate\Http\JsonResponse
  125. {
  126. $id=$request->input('id');
  127. $procurement=Procurement::query()->find($id)->update(['status'=>5]);// 5 => "待收货",
  128. if ($procurement) return $this->success($procurement);
  129. }
  130. public function getProcurementDeliveries(): \Illuminate\Http\JsonResponse
  131. {
  132. /**@var SupplierService $supplierService*/
  133. $supplierService=app(SupplierService::class);
  134. $supplier_ids=$supplierService->screenSupplierIds();
  135. $procurementDeliveries=ProcurementDeliverie::query()
  136. ->with('procurement.ownerMaterial.material')
  137. ->whereIn('status',[0,1])//1:待送货,2:送货中
  138. ->whereIn('supplier_id',$supplier_ids)
  139. ->get();
  140. $procurementDeliveries=$procurementDeliveries->filter(function ($item){
  141. return isset($item->procurement);
  142. });
  143. if ($procurementDeliveries) return $this->success($procurementDeliveries);
  144. }
  145. public function makeProcurementDelivery(Request $request): \Illuminate\Http\JsonResponse
  146. {
  147. $param=$request->all(['id','deliverAmount']);
  148. $procurement=Procurement::query()
  149. ->with('procurementDeliveries')
  150. ->find($param['id']);
  151. $deliveryAmount=$param['deliverAmount'];
  152. if (!empty($procurement->procurementDeliveries)){
  153. foreach ($procurement->procurementDeliveries as $delivery){
  154. if (!$delivery->amount)continue;
  155. $deliveryAmount=$deliveryAmount+$delivery->amount;
  156. }
  157. }
  158. if ((int)$deliveryAmount>(int)$procurement->quantity) return response()->json(['status'=>0,'message' => '当前送货数量叠加已送货数量大于采购数量','data'=>$deliveryAmount], 401);
  159. //生成送货单
  160. $procurementDelivery=new ProcurementDeliverie();
  161. $procurementDelivery['procurement_id']=$param['id'];
  162. $procurementDelivery['amount']=$param['deliverAmount'];
  163. $procurementDelivery['initiator']=Auth::user()['id'];
  164. $procurementDelivery['signer']=$procurement->initiator ?? 0;
  165. $procurementDelivery['created_at']=Carbon::now()->toDateTimeString();
  166. $procurementDelivery['updated_at']=Carbon::now()->toDateTimeString();
  167. $procurementDelivery->save();
  168. $procurementDelivery->loadMissing( 'procurement.ownerMaterial.material');
  169. //当前采购单不是打样单生成对账单
  170. if ($procurement->type!=2)ProcurementCheckSheet::query()->create(['procurement_delivery_id'=>$procurementDelivery->id,'account_payable'=>$procurementDelivery->receipt_amount*$procurement->cost_price,'auditor'=>0]);
  171. if ($procurementDelivery) return $this->success($procurementDelivery);
  172. }
  173. public function getProcurementDeliveryById(Request $request): \Illuminate\Http\JsonResponse
  174. {
  175. $procurementDelivery=ProcurementDeliverie::query()
  176. ->with(['procurement.ownerMaterial.material','receiver.userDetail','procurement.ownerMaterial.owner.customer','procurement.supplier','procurement.ownerMaterial.file'])
  177. ->find($request->input('id'));
  178. if ($procurementDelivery) return $this->success($procurementDelivery);
  179. }
  180. public function updateProcurementDeliveryAmount(Request $request): \Illuminate\Http\JsonResponse
  181. {
  182. $param=$request->all(['id','delivernum']);
  183. $procurementDelivery=ProcurementDeliverie::query()->where('id',$param['id'])->update(['amount'=>$param['delivernum']]);
  184. if ($procurementDelivery)return $this->success($procurementDelivery);
  185. }
  186. public function getProcurementTotalBill(): \Illuminate\Http\JsonResponse
  187. {
  188. $procurementTotalBills=ProcurementTotalBill::query()
  189. ->orderByDesc('id')
  190. ->get();
  191. foreach ($procurementTotalBills as $procurementTotalBill){
  192. /** @var ProcurementTotalBill $procurementTotalBill */
  193. $procurementTotalBill->setCurrentMothProcurements();
  194. }
  195. if ($procurementTotalBills) return $this->success($procurementTotalBills);
  196. }
  197. public function markProcurementTotalBillStatus(Request $request): \Illuminate\Http\JsonResponse//供应商提交对账单
  198. {
  199. $id=$request->input('id');
  200. $procurementTotalBill=ProcurementTotalBill::query()->find($id)->update(['status'=>1]);//1:已出账
  201. /** @var ProcurementTotalBill $procurementTotalBill */
  202. $procurementTotalBill->setCurrentMothProcurements();
  203. if (isset($procurementTotalBill->procurementCheckSheets)){
  204. $procurementCheckSheets=$procurementTotalBill->procurementCheckSheets;
  205. foreach ($procurementCheckSheets as $procurementCheckSheet){
  206. $procurementCheckSheet->update(['status'=>2]);//2 已出账
  207. }
  208. }
  209. return $this->success($procurementTotalBill);
  210. }
  211. //收货员确认收货
  212. public function makeReceipt(Request $request): \Illuminate\Http\JsonResponse
  213. {
  214. $param=$request->all(['id','delivernum']);
  215. $procurementDelivery=ProcurementDeliverie::query()->with('procurement')->find($param['id']);
  216. $procurementDelivery ->update(['status'=>1,'receipt_amount'=>$param['delivernum'],'created_at'=>Carbon::now()->toDateTimeString(),'signed_at'=>Carbon::now()->toDateString()]);
  217. $procurementDelivery->procurement->update(['status'=>6]);
  218. if ($procurementDelivery) return $this->success($procurementDelivery);
  219. }
  220. public function supplierDeliverConfirm(Request $request): \Illuminate\Http\JsonResponse
  221. {
  222. $procurementDelivery=ProcurementDeliverie::query()
  223. ->with(['procurement','procurementCheckSheet'])->find($request->input('id'));
  224. $procurementDelivery->update(['status'=>2]);//2:送货完成
  225. $procurementCheckSheet=$procurementDelivery->procurementCheckSheet;
  226. if ($procurementDelivery->procurement
  227. && $procurementDelivery->procurement->type!=2
  228. && $procurementCheckSheet)
  229. $procurementCheckSheet->update(['status'=>1,'account_payable'=>($procurementDelivery->receipt_amount*$procurementDelivery->procurement->cost_price)]);
  230. $procurementDelivery->procurement->update(['status'=>7]);//待出账
  231. if ($procurementDelivery) return $this->success($procurementDelivery);
  232. }
  233. }