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