PurchaseOrderService.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605
  1. <?php
  2. namespace App\Service;
  3. use App\Model\BasicType;
  4. use App\Model\BookingList;
  5. use App\Model\Depart;
  6. use App\Model\Employee;
  7. use App\Model\PaymentReceipt;
  8. use App\Model\PaymentReceiptInfo;
  9. use App\Model\PurchaseOrder;
  10. use App\Model\PurchaseOrderFile;
  11. use App\Model\PurchaseOrderInfo;
  12. use App\Model\ReturnExchangeOrder;
  13. use App\Model\SalesOrder;
  14. use App\Model\SeeRange;
  15. use App\Model\Storehouse;
  16. use App\Model\Supplier;
  17. use Illuminate\Http\Request;
  18. use Illuminate\Support\Facades\DB;
  19. /**
  20. * 采购单
  21. */
  22. class PurchaseOrderService extends Service
  23. {
  24. /**
  25. * 采购单编辑
  26. * @param $data
  27. * @param $user
  28. * @return array
  29. */
  30. public function edit($data,$user){
  31. list($status,$msg) = $this->orderRule($data,$user, false);
  32. if(!$status) return [$status,$msg];
  33. $params = $this->getDataFile($data);
  34. (new OperationLogService())->setOperationList($params,$user,2);
  35. try{
  36. DB::beginTransaction();
  37. $material_model = PurchaseOrder::where('order_number',$data['order_number'])->first();
  38. $material_model->purchase_type = $data['purchase_type'] ?? 0;
  39. $material_model->order_number = $data['order_number'];
  40. // $material_model->depart_id = $data['depart_id'] ?? 0;
  41. // $material_model->top_depart_id = $data['top_depart_id'] ?? 0;
  42. $material_model->total = $data['total'] ?? 0;
  43. $material_model->other_fee = $data['other_fee'] ?? 0;
  44. $material_model->discount_fee = $data['discount_fee'] ?? 0;
  45. $material_model->purchase_total = $data['purchase_total'] ?? 0;
  46. $material_model->supplier = $data['supplier'] ?? 0;
  47. $material_model->purchase_id = $data['purchase_id'] ?? 0;
  48. $material_model->order_type = $data['order_type'];
  49. $material_model->sales_order_id = $data['sales_order_id'] ?? 0;
  50. $material_model->mark = $data['mark'] ?? '';
  51. $material_model->storehouse_id = $data['storehouse_id'];
  52. $material_model->save();
  53. $time = time();
  54. PurchaseOrderInfo::where('order_number',$data['order_number'])
  55. ->where('del_time',0)
  56. ->update(['del_time' => time()]);
  57. if(!empty($data['product'])){
  58. $sub = [];
  59. foreach ($data['product'] as $value){
  60. $sub[] = [
  61. 'purchase_order_id' => $material_model->id,
  62. 'order_number' => $data['order_number'],
  63. 'storehouse_id' => $data['storehouse_id'] ?? 0,
  64. 'product_id' => $value['product_id'],
  65. 'number' => $value['number'],
  66. 'basic_type_id' => $value['basic_type_id'],
  67. 'price' => $value['price'],
  68. 'mark' => $value['mark'] ?? '',
  69. 'rate' => $value['rate'] ?? 0,
  70. ];
  71. }
  72. PurchaseOrderInfo::insert($sub);
  73. }
  74. $old = PurchaseOrderFile::where('del_time',0)
  75. ->where('purchase_order_id',$data['id'])
  76. ->whereIn('type',[PurchaseOrderFile::type_one])
  77. ->select('file')
  78. ->get()->toArray();
  79. $old = array_column($old,'file');
  80. PurchaseOrderFile::where('order_number',$data['order_number'])
  81. ->where('del_time',0)
  82. ->update(['del_time' => time()]);
  83. $new = [];
  84. if(! empty($data['file'])){
  85. $insert = [];
  86. foreach ($data['file'] as $value){
  87. $insert[] = [
  88. 'purchase_order_id' => $material_model->id,
  89. 'order_number' => $data['order_number'],
  90. 'file' => $value['url'],
  91. 'type' => PurchaseOrderFile::type_one,
  92. 'name' => $value['name'],
  93. 'crt_time' => $time,
  94. ];
  95. if(in_array($value['url'], $old)) {
  96. foreach ($old as $o_k => $o_v){
  97. if($o_v == $value['url']) unset($old[$o_k]);
  98. }
  99. }else{
  100. $new[] = $value['url'];
  101. }
  102. }
  103. PurchaseOrderFile::insert($insert);
  104. }
  105. DB::commit();
  106. }catch (\Throwable $e){
  107. DB::rollBack();
  108. return [false,$e->getMessage()];
  109. }
  110. return [true, ['file' => ['new' => $new, 'old' => $old]]];
  111. }
  112. /**
  113. * 采购单新增
  114. * @param $data
  115. * @param $user
  116. * @return array
  117. */
  118. public function add($data,$user){
  119. list($status,$msg) = $this->orderRule($data, $user);
  120. if(!$status) return [$status,$msg];
  121. try{
  122. DB::beginTransaction();
  123. $material_model = new PurchaseOrder();
  124. $material_model->order_number = $data['order_number'];
  125. $material_model->purchase_type = $data['purchase_type'] ?? 0;
  126. $material_model->depart_id = $data['depart_id'] ?? 0;
  127. $material_model->top_depart_id = $data['top_depart_id'] ?? 0;
  128. $material_model->total = $data['total'] ?? 0;
  129. $material_model->other_fee = $data['other_fee'] ?? 0;
  130. $material_model->discount_fee = $data['discount_fee'] ?? 0;
  131. $material_model->purchase_total = $data['purchase_total'] ?? 0;
  132. $material_model->supplier = $data['supplier'] ?? 0;
  133. $material_model->purchase_id = $data['purchase_id'] ?? 0;
  134. $material_model->order_type = $data['order_type'];
  135. $material_model->sales_order_id = $data['sales_order_id'] ?? 0;
  136. $material_model->mark = $data['mark'] ?? '';
  137. $material_model->crt_id = $user['id'];
  138. $material_model->storehouse_id = $data['storehouse_id'];
  139. $material_model->save();
  140. $time = time();
  141. if(!empty($data['product'])){
  142. $sub = [];
  143. foreach ($data['product'] as $value){
  144. $sub[] = [
  145. 'purchase_order_id' => $material_model->id,
  146. 'order_number' => $data['order_number'],
  147. 'storehouse_id' => $data['storehouse_id'] ?? 0,
  148. 'product_id' => $value['product_id'],
  149. 'number' => $value['number'],
  150. 'basic_type_id' => $value['basic_type_id'],
  151. 'price' => $value['price'],
  152. 'mark' => $value['mark'] ?? '',
  153. 'rate' => $value['rate'] ?? 0,
  154. ];
  155. }
  156. PurchaseOrderInfo::insert($sub);
  157. }
  158. $new = [];
  159. if(! empty($data['file'])){
  160. $insert = [];
  161. foreach ($data['file'] as $value){
  162. $insert[] = [
  163. 'purchase_order_id' => $material_model->id,
  164. 'order_number' => $data['order_number'],
  165. 'file' => $value['url'],
  166. 'type' => PurchaseOrderFile::type_one,
  167. 'name' => $value['name'],
  168. 'crt_time' => $time,
  169. ];
  170. if(! empty($value['url'])) $new[] = $value['url'];
  171. }
  172. PurchaseOrderFile::insert($insert);
  173. }
  174. DB::commit();
  175. }catch (\Throwable $e){
  176. DB::rollBack();
  177. return [false,$e->getMessage()];
  178. }
  179. (new OperationLogService())->setOperationList($data,$user);
  180. return [true, ['file' => ['new' => $new]]];
  181. }
  182. /**
  183. * 采购单详情
  184. * @param $data
  185. * @return array
  186. */
  187. public function detail($data,$user){
  188. if($this->isEmpty($data,'order_number')) return [false,'请选择数据'];
  189. $order = PurchaseOrder::where('order_number',$data['order_number'])
  190. ->where('del_time',0)
  191. ->select('id','order_number','depart_id','mark','state','crt_id','order_type','sales_order_id','supplier','purchase_id','total','other_fee','discount_fee','purchase_total','crt_time','storehouse_id','top_depart_id','purchase_type')
  192. ->first();
  193. if(empty($order)) return [false, '采购订单不存在或已被删除'];
  194. $order = $order->toArray();
  195. $order['file'] = [];
  196. $order['purchase_type_title'] = BasicType::where('id',$order['purchase_type'])->value('title') ?? '';
  197. $order['storehouse_title'] = Storehouse::where('id',$order['storehouse_id'])->value('title');
  198. $supplier = Supplier::where('id',$order['supplier'])->first();
  199. $order['supplier_title'] = $supplier->title ?? '';
  200. $order['order_type_title'] = PurchaseOrder::$order_type[$order['order_type']] ?? '';
  201. $sales = SalesOrder::where('id',$order['sales_order_id'])->value('order_number');
  202. $order['sales_order_number'] = $sales;
  203. $emp_map = Employee::whereIn('id',array_unique(array_merge_recursive([$order['purchase_id']],[$order['crt_id']])))
  204. ->pluck('emp_name','id')
  205. ->toArray();
  206. $order['purchase_title'] = $emp_map[$order['purchase_id']] ?? '';
  207. $p_info = PurchaseOrderInfo::where('del_time',0)
  208. ->where('order_number',$data['order_number'])
  209. ->get()->toArray();
  210. $basic_price = BasicType::whereIn('id',array_unique(array_column($p_info,'basic_type_id')))->pluck('title','id')->toArray();
  211. $map = (new ProductService())->getProductDetail(array_column($p_info,'product_id'));
  212. foreach ($p_info as $value){
  213. $tmp = $map[$value['product_id']] ?? [];
  214. $value['title'] = $tmp['title'] ?? "";
  215. $value['code'] = $tmp['code'] ?? "";
  216. $value['size'] = $tmp['size'] ?? "";
  217. $value['unit'] = $tmp['unit'] ?? "";
  218. $value['bar_code'] = $tmp['bar_code'] ?? "";
  219. $value['basic_type_title'] = $basic_price[$value['basic_type_id']] ?? "";
  220. $order['product'][] = $value;
  221. }
  222. $file = PurchaseOrderFile::where('del_time',0)
  223. ->where('order_number',$data['order_number'])
  224. ->get()->toArray();
  225. $fileUploadService = new FileUploadService();
  226. foreach ($file as $value){
  227. if($value['type'] == PurchaseOrderFile::type_one){
  228. $tmp = [
  229. 'url' => $value['file'],
  230. 'name' => $value['name'],
  231. 'show_url' => $fileUploadService->getFileShow($value['file']),
  232. ];
  233. $order['file'][] = $tmp;
  234. }
  235. }
  236. $order['crt_name'] = $emp_map[$order['crt_id']] ?? '';
  237. $order['crt_time'] = $order['crt_time'] ? date("Y-m-d H:i:s",$order['crt_time']): '';
  238. $state_array = $this->getStateMake([$order]);
  239. $order['state_title'] = $this->makeState($order,$state_array);
  240. //可见范围
  241. $return = (new RangeService())->RangeDetail($order['id'],SeeRange::type_five);
  242. $order['depart'] = $return[0] ?? [];
  243. $order['employee'] = $return[1] ?? [];
  244. //对应的分社订货合同
  245. $order['sales_order_number2'] = SalesOrder::where('del_time',0)->where('contact_order_no',$data['order_number'])->value('order_number') ?? "";
  246. //退换货信息
  247. $order['return_exchange'] = (new ReturnExchangeOrderService())->getDifferentAmount($order['id'],ReturnExchangeOrder::Order_type2);
  248. $order['return_exchange_amount'] = 0;
  249. foreach ($order['return_exchange'] as $value){
  250. if($value['state'] == ReturnExchangeOrder::State_two) $order['return_exchange_amount'] += $value['difference_amount'];
  251. }
  252. //回款单信息 审核过的
  253. $order['payment_receipt_list'] = (new PaymentReceiptService())->getPaymentReceiptDataList($order,PaymentReceipt::data_type_two);
  254. //坏账金额 = 已审核退货退款金额 - 红冲金额
  255. $order['payment_receipt_list']['bad_amount'] = bcsub($order['return_exchange_amount'], $order['payment_receipt_list']['red_amount'],2);
  256. //未回款金额 = 总金额 - 已回款金额 - 坏账金额 - 红冲
  257. $order['payment_receipt_list']['not_receipt_amount'] = bcsub(bcsub(bcsub($order['purchase_total'], $order['payment_receipt_list']['receipt_amount'],2), $order['payment_receipt_list']['bad_amount'], 2),$order['payment_receipt_list']['red_amount'],2);
  258. //回款单信息 审核过的
  259. $order['not_payment_receipt_amount'] = bcsub($order['purchase_total'],$order['payment_receipt_list']['not_confirm_receipt_amount'],2);
  260. return [true, $order];
  261. }
  262. /**
  263. * 采购单删除
  264. * @param $data
  265. * @return array
  266. */
  267. public function del($data){
  268. if($this->isEmpty($data,'order_number')) return [false,'请选择数据!'];
  269. $order = PurchaseOrder::where('del_time',0)->where('order_number',$data['order_number'])->first();
  270. if(empty($order)) return [false,'采购单不存在或已被删除'];
  271. $order = $order->toArray();
  272. if($order['state'] > PurchaseOrder::STATE_ZERO) return [false,'请确认采购订单状态,删除失败!'];
  273. $bool = PaymentReceiptInfo::where('del_time',0)
  274. ->where('type',PaymentReceiptInfo::type_three)
  275. ->where('data_order_no', $order['order_number'])
  276. ->exists();
  277. if($bool) return [false, '采购已存在收付款单记录,请先删除收付款单据!'];
  278. try{
  279. DB::beginTransaction();
  280. PurchaseOrder::where('order_number',$data['order_number'])->where('del_time',0)->update([
  281. 'del_time'=>time()
  282. ]);
  283. PurchaseOrderInfo::where('order_number',$data['order_number'])->where('del_time',0)->update([
  284. 'del_time'=>time()
  285. ]);
  286. $old = PurchaseOrderFile::where('del_time',0)
  287. ->where('purchase_order_id',$order['id'])
  288. ->whereIn('type',[PurchaseOrderFile::type_one])
  289. ->select('file')
  290. ->get()->toArray();
  291. $old = array_column($old,'file');
  292. PurchaseOrderFile::where('order_number',$data['order_number'])
  293. ->where('del_time',0)
  294. ->update(['del_time' => time()]);
  295. (new RangeService())->RangeDelete($order['id'],SeeRange::type_five);
  296. DB::commit();
  297. }catch (\Throwable $e){
  298. DB::rollBack();
  299. return [false,$e->getMessage()];
  300. }
  301. return [true, ['file' => ['old' => $old]]];
  302. }
  303. /**
  304. * 获取采购单列表
  305. * @param $data
  306. * @param $user
  307. * @return array
  308. */
  309. public function getList($data,$user){
  310. $model = PurchaseOrder::Clear($user,$data);
  311. $model = $model->where('del_time',0)->select('order_number','id','depart_id','top_depart_id','mark','crt_time','state','crt_id','order_type','sales_order_id','supplier','purchase_id','purchase_total','discount_fee','other_fee','total','storehouse_id')
  312. ->orderby('id', 'desc');
  313. if(! empty($data['purchase_id'])) $model->where('id', $data['purchase_id']);
  314. if(! empty($data['order_number'])) $model->where('order_number', 'LIKE', '%'.$data['order_number'].'%');
  315. if(! empty($data['depart_id'])) $model->where('depart_id', $data['depart_id']);
  316. if(! empty($data['company_id'])) $model->where('company_id', $data['company_id']);
  317. if(isset($data['state'])) $model->where('state',$data['state']);
  318. if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
  319. $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
  320. $model->whereBetween('crt_time',[$return[0],$return[1]]);
  321. }
  322. if(! empty($data['time_type'])) {
  323. if($data['time_type'] == 1) {
  324. $start = strtotime('today');
  325. $end = strtotime('tomorrow') - 1;
  326. }elseif ($data['time_type'] == 2){
  327. $start = strtotime('this week',strtotime('today'));
  328. $end = strtotime('this week +6 days 23:59:59', strtotime('today'));
  329. }
  330. if(! empty($start) && ! empty($end)) {
  331. $model->where('crt_time','>=',$start);
  332. $model->where('crt_time','<=',$end);
  333. }
  334. }
  335. if(! empty($data['order_type'])) {
  336. if($data['order_type'] == PurchaseOrder::Order_type_five){
  337. $model->whereIn('order_type',[PurchaseOrder::Order_type_two,PurchaseOrder::Order_type_three,PurchaseOrder::Order_type_four]);
  338. }else{
  339. $model->where('order_type',$data['order_type']);
  340. }
  341. }
  342. if(! empty($data['sale_order'])){
  343. $model2 = SalesOrder::Clear($user,$data);
  344. $sale = $model2->where('del_time',0)
  345. ->where('order_number', 'LIKE', '%'.$data['sale_order'].'%')
  346. ->select('id')
  347. ->get()->toArray();
  348. $model->whereIn('sales_order_id',array_unique(array_column($sale,'id')));
  349. }
  350. if(! empty($data['supplier_man'])){
  351. $emp = Supplier::where('del_time',0)
  352. ->where('title', 'LIKE', '%'.$data['supplier_man'].'%')
  353. ->select('id')
  354. ->get()->toArray();
  355. $model->whereIn('supplier',array_unique(array_column($emp,'id')));
  356. }
  357. if(! empty($data['purchase_man'])){
  358. $emp = Employee::where('del_time',0)
  359. ->where('emp_name', 'LIKE', '%'.$data['purchase_man'].'%')
  360. ->select('id')
  361. ->get()->toArray();
  362. $model->whereIn('purchase_id',array_unique(array_column($emp,'id')));
  363. }
  364. $list = $this->limit($model,'',$data);
  365. $list = $this->fillListData($list,$data,$user);
  366. return [true, $list];
  367. }
  368. /**
  369. * 拼接数据
  370. * @param $data
  371. * @return array
  372. */
  373. public function fillListData($data,$ergs,$user){
  374. if(empty($data['data'])) return $data;
  375. $depart_id = array_unique(array_column($data['data'],'depart_id'));
  376. $depart_map = Depart::whereIn('id',$depart_id)
  377. ->pluck('title','id')
  378. ->toArray();
  379. $emp_id = array_unique(array_merge_recursive(array_column($data['data'],'crt_id'),array_column($data['data'],'purchase_id')));
  380. $emp_map = Employee::whereIn('id',$emp_id)
  381. ->pluck('emp_name','id')
  382. ->toArray();
  383. $sales = SalesOrder::whereIn('id',array_unique(array_column($data['data'],'sales_order_id')))->pluck('order_number','id')->toArray();
  384. $storehouse = Storehouse::whereIn('id',array_unique(array_column($data['data'],'storehouse_id')))
  385. ->pluck('title','id')
  386. ->toArray();
  387. $supplier = Supplier::whereIn('id',array_unique(array_column($data['data'],'supplier')))
  388. ->select('title','id','is_main')
  389. ->get()
  390. ->toArray();
  391. $supplier_map = array_column($supplier,null,'id');
  392. $product = [];
  393. if(! empty($ergs['product'])){
  394. $sales_p_info = PurchaseOrderInfo::where('del_time',0)
  395. ->whereIn('purchase_order_id',array_column($data['data'],'id'))
  396. ->get()->toArray();
  397. $basic_price = BasicType::whereIn('id',array_unique(array_column($sales_p_info,'basic_type_id')))->pluck('title','id')->toArray();
  398. $map = (new ProductService())->getProductDetail(array_column($sales_p_info,'product_id'));
  399. foreach ($sales_p_info as $value){
  400. $tmp = $map[$value['product_id']] ?? [];
  401. $value['title'] = $tmp['title'] ?? "";
  402. $value['code'] = $tmp['code'] ?? "";
  403. $value['size'] = $tmp['size'] ?? "";
  404. $value['unit'] = $tmp['unit'] ?? "";
  405. $value['bar_code'] = $tmp['bar_code'] ?? "";
  406. $value['basic_type_title'] = $basic_price[$value['basic_type_id']] ?? "";
  407. $product[$value['purchase_order_id']][] = $value;
  408. }
  409. }
  410. list($for_amount_list, $for_amount_list1) = (new PaymentReceiptService())->getPaymentReceiptDataCountList(array_column($data['data'],'order_number'));
  411. list($getDifferentAmountALL,$getDifferentAmountALL1) = (new ReturnExchangeOrderService())->getDifferentAmountALLNew(array_column($data['data'],'id'),1);
  412. //获取发货信息
  413. // $invoice_map = (new InvoiceOrderService())->getInvoiceData($data['data']);
  414. //订单状态数据组织
  415. $state_array = $this->getStateMake($data['data']);
  416. foreach ($data['data'] as $key => $value){
  417. $supplier_tmp = $supplier_map[$value['supplier']] ?? [];
  418. $data['data'][$key]['crt_time'] = $value['crt_time'] ? date("Y-m-d H:i:s",$value['crt_time']) : '';
  419. $data['data'][$key]['depart_name'] = $depart_map[$value['depart_id']] ?? '';
  420. $data['data'][$key]['crt_name'] = $emp_map[$value['crt_id']] ?? '';
  421. $data['data'][$key]['state_title'] = $this->makeState($data['data'][$key], $state_array);
  422. $data['data'][$key]['purchase_name'] = $emp_map[$value['purchase_id']] ?? '';
  423. $data['data'][$key]['order_type_title'] = PurchaseOrder::$order_type[$value['order_type']] ?? '';
  424. $data['data'][$key]['sales_order_number'] = $sales[$value['sales_order_id']] ?? '';
  425. $data['data'][$key]['storehouse_title'] = $storehouse[$value['storehouse_id']] ?? '';
  426. $data['data'][$key]['supplier_title'] = $supplier_tmp['title'] ?? '';
  427. $data['data'][$key]['product'] = $product[$value['id']] ?? [];
  428. //发货信息 分社向总社采购
  429. // $invoice_state = "未发货";
  430. // if(! empty($invoice_map[$value['order_number']])) $invoice_state = implode(',',$invoice_map[$value['order_number']]);
  431. // $data['data'][$key]['state_message'] = "订单状态:" . $data['data'][$key]['state_title'] . "\n"."是否发货:" . $invoice_state;
  432. $data['data'][$key]['state_message'] = $data['data'][$key]['state_title'];
  433. //用于计算--------
  434. //已收(审核后)
  435. $one1 = $for_amount_list1[$value['order_number'] . PaymentReceipt::type_one] ?? 0;
  436. $data['data'][$key]['checked_payment_receipt_amount'] = $one1;
  437. //已收
  438. $one = $for_amount_list[$value['order_number'] . PaymentReceipt::type_one] ?? 0;
  439. $data['data'][$key]['payment_receipt_amount'] = $one;
  440. //已红冲
  441. $three = $for_amount_list[$value['order_number'] . PaymentReceipt::type_three] ?? 0;
  442. $data['data'][$key]['red_amount'] = $three;
  443. //已退货退款
  444. $return_exchange_amount = $getDifferentAmountALL[$value['id']] ?? 0;
  445. $data['data'][$key]['return_exchange_amount'] = $return_exchange_amount;
  446. //用于计算--------
  447. //用于统计--------
  448. $red = $for_amount_list1[$value['order_number'] . PaymentReceipt::type_three] ?? 0;
  449. $return_exchange_amount1 = $getDifferentAmountALL1[$value['id']] ?? 0;
  450. $bad = bcsub($return_exchange_amount1 ,$red,2);
  451. //已收金额
  452. $fee1 = bcsub($one1 ,$red,2);
  453. $data['data'][$key]['fee1'] = $fee1;
  454. //未收金额
  455. $fee2 = bcsub(bcsub(bcsub($value['purchase_total'], $fee1,2), $bad, 2),$red,2);
  456. $data['data'][$key]['fee2'] = $fee2;
  457. //红冲金额
  458. $data['data'][$key]['fee3'] = $red;
  459. //坏账金额
  460. $data['data'][$key]['fee4'] = $bad;
  461. //用于统计--------
  462. }
  463. return $data;
  464. }
  465. public function getStateMake($data){
  466. if(empty($data)) return [];
  467. $order_no = [];
  468. foreach ($data as $value){
  469. if(! in_array($value['state'], [PurchaseOrder::State_minus_one,PurchaseOrder::STATE_ONE])) continue;
  470. $order_no[] = $value['order_number'];
  471. }
  472. return (new OaService())->getOaTeamDetailList($order_no);
  473. }
  474. public function makeState($value, $state_array){
  475. if(! empty($state_array[$value['order_number']])){
  476. $return = $state_array[$value['order_number']];
  477. if($value['state'] == PurchaseOrder::State_minus_one){
  478. $state = "驳回:" . $return;
  479. }else{
  480. $state = "待" . $return . "审核";
  481. }
  482. }elseif($value['state'] == PurchaseOrder::STATE_ZERO){
  483. $state = "待" . $value['crt_name'] . "提交";
  484. }else{
  485. $state = PurchaseOrder::$name[$value['state']] ?? '';
  486. }
  487. return $state;
  488. }
  489. /**
  490. * 采购单参数规则
  491. * @param $data
  492. * @param $is_check
  493. * @return array
  494. */
  495. public function orderRule(&$data, $user, $is_check = true){
  496. if(empty($data['order_type'])) return [false,'采购订单类型不能为空'];
  497. if($data['order_type'] == PurchaseOrder::Order_type_two && ! empty($data['supplier'])) {
  498. $supplier = Supplier::where('id',$data['supplier'])->first();
  499. if(! empty($supplier->is_main)) return [false,PurchaseOrder::$order_type[PurchaseOrder::Order_type_two] . '供应商请选择非总社供应商'];
  500. }
  501. if($data['order_type'] == PurchaseOrder::Order_type_three || $data['order_type'] == PurchaseOrder::Order_type_four) {
  502. if(empty($data['supplier'])){
  503. return [false,'请选择总部供应商'];
  504. }else{
  505. $supplier = Supplier::where('id',$data['supplier'])->first();
  506. if(empty($supplier->is_main)) return [false,'请选择总社供应商'];
  507. }
  508. }
  509. if($data['order_type'] == PurchaseOrder::Order_type_three && ! empty($data['sales_order_id'])) return [false,PurchaseOrder::$order_type[PurchaseOrder::Order_type_three] . '不需要选择合同'];
  510. if($data['order_type'] == PurchaseOrder::Order_type_four && empty($data['sales_order_id'])) return [false, PurchaseOrder::$order_type[PurchaseOrder::Order_type_four] . '必须选择合同'];
  511. if($this->isEmpty($data,'product')) return [false,'产品不能为空'];
  512. if(empty($data['storehouse_id'])) return [false,'请选择仓库'];
  513. if(! empty($data['other_fee'])){
  514. $res = $this->checkNumber($data['other_fee']);
  515. if(! $res) return [false, '其它费用请输入不超过两位小数并且大于0的数值'];
  516. }
  517. if(! empty($data['discount_fee'])){
  518. $res = $this->checkNumber($data['discount_fee']);
  519. if(! $res) return [false, '优惠金额请输入不超过两位小数并且大于0的数值'];
  520. }
  521. if(! empty($data['total'])){
  522. $res = $this->checkNumber($data['total']);
  523. if(! $res) return [false, '产品总价请输入不超过两位小数并且大于0的数值'];
  524. }
  525. if(! empty($data['purchase_total'])){
  526. $res = $this->checkNumber($data['purchase_total']);
  527. if(! $res) return [false, '采购总价请输入不超过两位小数并且大于0的数值'];
  528. }
  529. foreach ($data['product'] as $value){
  530. if(empty($value['number'])) return [false,'产品数量不能为空'];
  531. $res = $this->checkNumber($value['number']);
  532. if(! $res) return [false,'请输入正确的产品数量'];
  533. }
  534. //所属部门 以及 顶级部门
  535. if(empty($data['depart_id'])) $data['depart_id'] = $this->getDepart($user);
  536. $data['top_depart_id'] = $user['depart_map'][$data['depart_id']] ?? 0;
  537. if($is_check){
  538. $order_number = (new OrderNoService())->createOrderNumber(PurchaseOrder::prefix);
  539. if(empty($order_number)) return [false,'采购单号生成失败!'];
  540. $data['order_number'] = $order_number;
  541. }else{
  542. if($this->isEmpty($data,'order_number')) return [false,'采购单号不能为空!'];
  543. }
  544. return [true, ''];
  545. }
  546. }