CheckService.php 59 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540
  1. <?php
  2. namespace App\Service;
  3. use App\Model\Construction;
  4. use App\Model\ConstructionProductInfo;
  5. use App\Model\Depart;
  6. use App\Model\Employee;
  7. use App\Model\InOutRecord;
  8. use App\Model\InvoiceOrder;
  9. use App\Model\InvoiceOrderInfo;
  10. use App\Model\OrderOperation;
  11. use App\Model\PaymentReceipt;
  12. use App\Model\PaymentReceiptInfo;
  13. use App\Model\ProductInventory;
  14. use App\Model\ProductInventorySet;
  15. use App\Model\PurchaseOrder;
  16. use App\Model\PurchaseOrderInfo;
  17. use App\Model\PurchaseOrderSpecial;
  18. use App\Model\PurchaseOrderSpecialInfo;
  19. use App\Model\ReturnExchangeOrder;
  20. use App\Model\ReturnExchangeOrderProductInfo;
  21. use App\Model\SalesOrder;
  22. use App\Model\SalesOrderInfo;
  23. use App\Model\SalesOrderOtherFee;
  24. use App\Model\SalesOrderProductInfo;
  25. use App\Model\SeeRange;
  26. use App\Model\Storehouse;
  27. use App\Model\Supplier;
  28. use App\Service\OaService;
  29. use Illuminate\Support\Facades\DB;
  30. class CheckService extends Service
  31. {
  32. //审批操作对应的数值
  33. const one = 1; //收货
  34. const two = 2; //发货
  35. const three = 3; //采购单入库
  36. const four = 4; //合同公司完结
  37. const five = 5; //施工单
  38. const six = 6; //退换货单
  39. const seven = 7; //采购单确认
  40. const eight = 8; //合同确认
  41. const nine = 9; //合同客户完结
  42. const ten = 10; //收付款确认
  43. const eve = 11; //接受派单
  44. //中文对照
  45. public $map = [
  46. self::one => '收货单',
  47. self::two => '发货单',//确认后出库
  48. self::three => '采购单入库',//确认后入库
  49. self::four => '公司完结', // 安装件 合同完结
  50. self::five => '施工单',//确认后出库
  51. self::six => '退换货单',//确认后出库或出库入库
  52. self::seven => '采购单确认',
  53. self::eight => '合同确认',
  54. self::nine => '合同客户完结',
  55. self::ten => '收付款确认',
  56. self::eve => '接受门店派单',
  57. ];
  58. //入库操作
  59. public static $in_opt = [
  60. self::three,
  61. ];
  62. //出库操作
  63. public static $out_opt = [
  64. self::two,
  65. self::five,
  66. ];
  67. const TYPE_ONE = 1;//通过
  68. const TYPE_TWO = 2;//不通过
  69. const TYPE_THREE = 3;//通过后驳回
  70. //改为待审核状态 校验
  71. public static $opt_1case_check = [
  72. self::five => 'checkConstruction',//施工单
  73. ];
  74. //改为待审核状态
  75. public static $opt_1case = [
  76. self::two => 'waitInvoice',//发货单
  77. // self::three => 'waitPurchase',//采购单 入库
  78. self::five => 'waitConstruction',//施工单
  79. self::six => 'waitReturnExchange',//退换货单
  80. self::seven => 'waitPurchaseConfirm', //采购单确认
  81. self::eight => 'waitSales', // 合同安装件 合同确认
  82. self::ten => 'waitPaymentReceipt', //收付款确认
  83. ];
  84. public static $finished = [
  85. self::three => 'confirmPurchaseOrder',//采购单 入库
  86. self::four => 'settleSalesOrder', // 合同 安装件 合同公司完结
  87. self::nine => 'settleSalesOrderCustomer', // 合同 安装件 合同客户完结
  88. self::eve => 'settleSalesOrderConfirm', // 合同 安装件 合同接收
  89. ];
  90. //单据操作
  91. public static $opt_case = [
  92. self::two => 'confirmInvoiceOrder',
  93. // self::three => 'confirmPurchaseOrder',
  94. self::five => 'confirmConstruction',
  95. self::six => 'confirmReturnExchangeOrder',
  96. self::seven => 'confirmPurchaseOrderState',
  97. self::eight => 'confirmSales', // 合同 安装件 合同确认
  98. self::ten => 'confirmPaymentReceipt', // 确认收付款单
  99. ];
  100. //单据库存流水
  101. public static $record = [
  102. self::two => 'recordInvoiceOrder',
  103. self::three => 'recordPurchaseOrder',
  104. self::five => 'recordConstruction',
  105. self::six => 'recordReturnExchangeOrder'
  106. ];
  107. //自动生成
  108. public static $create = [
  109. self::seven => 'createPurchaseOrderSales', //分社合同生成
  110. self::four => 'createPurchaseOrder', // 派给分社的合同确认以后生成虚拟采购单
  111. ];
  112. //自动生成的删除
  113. public static $create_del = [
  114. self::seven => 'delCreatePurchaseOrderSales', //分社合同生成(删除)
  115. // self::four => 'createPurchaseOrder', // 派给分社的合同确认以后生成虚拟采购单
  116. ];
  117. //审核通过后 驳回
  118. public static $opt_case_reject = [
  119. self::four => 'reject_sales', // 合同
  120. // self::three => 'reject_purchase', //采购入库
  121. self::seven => 'reject_purchase_confirm', //采购确认驳回
  122. self::five => 'reject_construction',//施工单
  123. self::six => 'reject_return_exchange',//退换货
  124. self::ten => 'reject_payment_receipt',//收付款单
  125. ];
  126. //审核通过后 驳回 产生流水
  127. public static $reject_record = [
  128. self::five => 'reject_record_construction', //施工单驳回
  129. self::three => 'reject_record_purchase', //采购
  130. self::six => 'reject_record_return_exchange',//退换货
  131. ];
  132. //旅程日志 同意
  133. public static $operation_order = [
  134. self::eight => OrderOperation::three, //合同确认
  135. self::two => OrderOperation::eight, //发货单确认
  136. self::six => OrderOperation::nine, //退换货审核
  137. self::five => OrderOperation::eve, //施工单
  138. self::seven => OrderOperation::thi,//采购单确认
  139. self::three => OrderOperation::fourteen,//采购单入库
  140. self::ten => OrderOperation::twenty_one,//收付款单
  141. ];
  142. //旅程日志 驳回
  143. public static $operation_order_reject = [
  144. self::four => OrderOperation::four, //合同弃审
  145. self::six => OrderOperation::ten, //退换货弃审
  146. self::five => OrderOperation::twl, //施工单弃审
  147. self::three => OrderOperation::fif,//采购单入库弃审
  148. self::seven => OrderOperation::twenty,//采购单确认弃审
  149. self::ten => OrderOperation::twenty_two,//收付款单
  150. ];
  151. //校验
  152. public function checkConstruction($data, $user){
  153. $order = Construction::where('del_time',0)
  154. ->where('order_number',$data['order_number'])
  155. ->first();
  156. if(empty($order)) return [false,'施工单不存在或已被删除'];
  157. $order = $order->toArray();
  158. //总社id
  159. $head = $user['head'] ?? [];
  160. $head = $head['id'] ?? 0;
  161. //分社自己的施工单 直接返回
  162. if($order['top_depart_id'] != $head) return [true, ''];
  163. //不校验库存
  164. if($user['is_check_stock'] == ProductInventorySet::type_two) return [true,''];
  165. //施工单产品
  166. $sub = ConstructionProductInfo::where('construction_id',$order['id'])
  167. ->where('del_time',0)
  168. ->get()->toArray();
  169. if(empty($sub)) return [false,'施工单产品不存在或已被删除'];
  170. $product_submit = $product_id = [];
  171. foreach ($sub as $value){
  172. $product_id[] = $value['product_id'];
  173. $key = $value['product_id'] . ',' . $value['storehouse_id'];
  174. if(isset($product_save[$key])){
  175. $product_submit[$key] += $value['number'];
  176. }else{
  177. $product_submit[$key] = $value['number'];
  178. }
  179. }
  180. //比较库存
  181. list($status,$msg) = (new ProductInventoryService())->compareStock($user,$product_id, $product_submit, []);
  182. if(! $status) return [false, $msg];
  183. //锁定库存
  184. ProductInventoryService::changeLockNumber($user,$product_submit);
  185. return [true, ''];
  186. }
  187. //改为待审核---------------------------------
  188. public function waitInvoice($data){
  189. $model = InvoiceOrder::where('id',$data['id'])
  190. ->where('del_time',0)
  191. ->first();
  192. if(empty($model)) return [false, '发货单不存在或已被删除'];
  193. if($model->state != InvoiceOrder::STATE_ZERO) return [false, '请确认发货单状态,操作失败'];
  194. InvoiceOrder::where('del_time',0)->where('id',$data['id'])
  195. ->update(['state' => InvoiceOrder::STATE_ONE]);
  196. return [true, $model->toArray()];
  197. }
  198. public function waitPurchaseConfirm($data){
  199. $model = PurchaseOrder::where('id',$data['id'])
  200. ->where('del_time',0)
  201. ->first();
  202. if(empty($model)) return [false,'采购单不存在或已被删除'];
  203. if($model->state != PurchaseOrder::STATE_ZERO) return [false,'请确认采购单状态,操作失败'];
  204. //待确认
  205. PurchaseOrder::where('id',$data['id'])->update(['state' => PurchaseOrder::STATE_ONE]);
  206. return [true, $model->toArray()];
  207. }
  208. public function waitPurchase($data){
  209. $model = PurchaseOrder::where('id',$data['id'])
  210. ->where('del_time',0)
  211. ->first();
  212. if(empty($model)) return [false, '采购订单不存在或已被删除'];
  213. if($model->state != PurchaseOrder::STATE_TWO) return [false, '请确认采购订单状态,操作失败'];
  214. //待入库
  215. PurchaseOrder::where('del_time',0)->where('id',$data['id'])
  216. ->update(['state' => PurchaseOrder::STATE_Three]);
  217. return [true, $model->toArray()];
  218. }
  219. public function waitConstruction($data){
  220. $model = Construction::where('id',$data['id'])
  221. ->where('del_time',0)
  222. ->first();
  223. if(empty($model)) return [false, '施工单不存在或已被删除'];
  224. if($model->state != Construction::STATE_ZERO) return [false, '请确认施工单状态,操作失败'];
  225. //待确认
  226. Construction::where('del_time',0)->where('id',$data['id'])
  227. ->update(['state' => Construction::STATE_ONE]);
  228. return [true, $model->toArray()];
  229. }
  230. public function waitReturnExchange($data){
  231. $model = ReturnExchangeOrder::where('id',$data['id'])
  232. ->where('del_time',0)
  233. ->first();
  234. if(empty($model)) return [false, '退换货单不存在或已被删除'];
  235. if($model->state != ReturnExchangeOrder::State_zero) return [false, '请确认退换货单状态,操作失败'];
  236. //待确认
  237. ReturnExchangeOrder::where('del_time',0)->where('id',$data['id'])
  238. ->update(['state' => ReturnExchangeOrder::State_one]);
  239. return [true, $model->toArray()];
  240. }
  241. public function waitSales($data){
  242. $model = SalesOrder::where('id', $data['id'])
  243. ->where('del_time',0)
  244. ->first();
  245. if(empty($model)) return [false, '合同不存在或已被删除'];
  246. //安装件
  247. if($model->state != SalesOrder::State_zero) return [false, '请确认合同状态,操作失败'];
  248. SalesOrder::where('del_time',0)->where('id',$data['id'])
  249. ->update(['state' => SalesOrder::State_one]);
  250. return [true, $model->toArray()];
  251. }
  252. public function waitPaymentReceipt($data){
  253. $model = PaymentReceipt::where('id', $data['id'])
  254. ->where('del_time',0)
  255. ->first();
  256. if(empty($model)) return [false, '收付款单不存在或已被删除'];
  257. if($model->state != PaymentReceipt::STATE_ZERO) return [false, '请确认收付款单状态,操作失败'];
  258. PaymentReceipt::where('del_time',0)->where('id',$data['id'])
  259. ->update(['state' => PaymentReceipt::STATE_ONE]);
  260. return [true, $model->toArray()];
  261. }
  262. //改为待审核---------------------------------
  263. //自动生成-----------------------------------
  264. //总社派给分社的合同 完成生成虚拟采购单
  265. public function createPurchaseOrder($order,$user){
  266. //快递件
  267. if($order['sales_order_type'] == SalesOrder::Order_type_two) return [true,''];
  268. //不是总公司的合同
  269. $head = $user['head'] ?? [];
  270. $head = $head['id'] ?? 0; //总社id
  271. if($head != $order['top_depart_id']) return [true, ''];
  272. $see = SeeRange::where('del_time',0)
  273. ->where('data_id',$order['id'])
  274. ->where('data_type',SeeRange::type_seven)
  275. ->where('type',SeeRange::data_three)
  276. ->first();
  277. if(empty($see)) return [false, '未找到指派分社信息'];
  278. $depart_id = $see->param_id;//指派的分社
  279. //总社指派给自己
  280. if($depart_id == $head) return [true, ''];
  281. //获取指派分社时候的金额
  282. $fee = SalesOrderOtherFee::where('del_time',0)
  283. ->where('sales_order_id',$order['id'])
  284. ->first();
  285. if(empty($fee)) return [false, '未找到指派分社时填写的金额'];
  286. $fee = $fee->toArray();
  287. $order_number = (new OrderNoService())->createOrderNumber(PurchaseOrderSpecial::prefix);
  288. $storehouse = Storehouse::where('depart_id',$head)->value('id');
  289. $product = SalesOrderProductInfo::where('del_time',0)
  290. ->where('sales_order_id',$order['id'])
  291. ->select('product_id','number','retail_price')
  292. ->get()->toArray();
  293. $product_map = $rate = [];
  294. $total = 0;
  295. foreach ($product as $value){
  296. $total += $value['number'] * $value['retail_price'];
  297. if(isset($product_map[$value['product_id']])){
  298. $product_map[$value['product_id']] += $value['retail_price'] * $value['number'];
  299. }else{
  300. $product_map[$value['product_id']] = $value['retail_price'] * $value['number'];
  301. }
  302. }
  303. foreach ($product_map as $key => $value){
  304. $rate[$key] = sprintf("%.2f", round($value / $total, 2));
  305. }
  306. $model = new PurchaseOrderSpecial();
  307. $model->order_number = $order_number;
  308. $model->sales_order_id = $order['id'];
  309. $model->depart_id = $head;
  310. $model->top_depart_id = $head;
  311. $model->crt_id = Employee::SPECIAL_ADMIN;
  312. $model->purchase_id = Employee::SPECIAL_ADMIN;
  313. $model->purchase_total = $fee['other_fee_1'] ?? 0;
  314. $model->storehouse_id = $storehouse ?? 0;
  315. $model->save();
  316. if(empty($model->id)) return [false,'采购单主信息生成失败'];
  317. $purchase_order_id = $model->id;
  318. $insert = [];$product_total = 0;
  319. foreach ($product as $value){
  320. $rate_tmp = $rate[$value['product_id']] ?? 0;
  321. $price = sprintf("%.2f", round($rate_tmp * $fee['other_fee_1'] / $value['number'], 2));
  322. $product_total += $price * $value['number'];
  323. $insert[] = [
  324. 'purchase_order_special_id' => $purchase_order_id,
  325. 'product_id' => $value['product_id'],
  326. 'order_number' => $order_number,
  327. 'number' => $value['number'],
  328. 'price' => $price,
  329. 'storehouse_id' => $storehouse,
  330. ];
  331. }
  332. PurchaseOrderSpecialInfo::insert($insert);
  333. PurchaseOrderSpecial::where('id',$purchase_order_id)->update(['total' => $product_total]);
  334. return [true, ''];
  335. }
  336. //分社向总社采购 生成 分社订货合同
  337. public function createPurchaseOrderSales($order,$user){
  338. //没有供应商 不创建合同
  339. if(empty($order['supplier'])) return [true, ''];
  340. //总公司的采购单 不创建合同
  341. $head = $user['head'] ?? [];
  342. $head = $head['id'] ?? 0; //总社id
  343. if($head == $order['top_depart_id']) return [true, ''];
  344. //分社公司的采购单 不向总供应商采购 不创建合同
  345. $is_create = Supplier::where('id',$order['supplier'])->value('is_main');
  346. if(empty($is_create)) return [true, ''];
  347. $customer_short_name = Depart::where('id',$order['top_depart_id'])->value('title') ?? "";
  348. $prefix = SalesOrder::$prefix[SalesOrder::Model_type_two];
  349. $order_number = OrderNoService::createSalesOrderNumber($prefix);
  350. $product = PurchaseOrderInfo::where('del_time',0)
  351. ->where('purchase_order_id',$order['id'])
  352. ->get()->toArray();
  353. if(empty($product)) return [false, '采购订单产品数据不能为空'];
  354. $time = time();
  355. $model = new SalesOrder();
  356. $model->model_type = SalesOrder::Model_type_two;
  357. $model->sales_order_type = SalesOrder::Order_type_two;
  358. $model->customer_short_name = $customer_short_name;
  359. $model->order_number = $order_number;
  360. $model->crt_id = $order['crt_id'];
  361. $model->depart_id = $head;
  362. $model->top_depart_id = $head;
  363. $model->other_fee = $order['other_fee'];
  364. $model->discount_fee = $order['discount_fee'];
  365. $model->contract_fee = $order['purchase_total'];
  366. $model->contact_order_no = $order['order_number'];
  367. $model->sign_time = $time;
  368. $model->save();
  369. $sales_order_id = $model->id;
  370. //产品字典
  371. $product_map = (new ProductService())->getProductDetail(array_column($product,'product_id'));
  372. $insert = [];
  373. $product_total = 0;
  374. foreach ($product as $value){
  375. $tmp = $product_map[$value['product_id']] ?? [];
  376. $product_total += $value['price'] * $value['number'];
  377. $insert[] = [
  378. 'sales_order_id' => $sales_order_id,
  379. 'product_id' => $value['product_id'],
  380. 'number' => $value['number'],
  381. 'basic_type_id' => $value['basic_type_id'],
  382. 'price' => $value['price'],
  383. 'cost' => $tmp['cost'] ?? 0,
  384. 'retail_price' => $tmp['retail_price'] ?? 0,
  385. 'final_amount' => $value['price'] * $value['number'],
  386. ];
  387. }
  388. $bool = SalesOrderProductInfo::insert($insert);
  389. if(! $bool) return [false,'合同生成失败!'];
  390. //反写数据
  391. $tmp = $product_total + $order['other_fee'];
  392. $tmp = $tmp > 0 ? $tmp : 1;
  393. $rate = ($product_total + $order['other_fee'] - $order['discount_fee']) / $tmp;
  394. SalesOrder::where('id',$sales_order_id)->update([
  395. 'product_total' => $product_total,
  396. 'rate' => $rate
  397. ]);
  398. //生成付款单
  399. $model = new PaymentReceipt();
  400. $model->order_number = (new OrderNoService())->createOrderNumber(PaymentReceipt::prefix);
  401. $model->data_type = PaymentReceipt::data_type_one;
  402. $model->type = PaymentReceipt::type_one;
  403. $model->crt_id = $user['id'];
  404. $model->depart_id = $head;
  405. $model->top_depart_id = $head;
  406. $model->save();
  407. $insert = [];
  408. $insert[] = [
  409. 'payment_receipt_id' => $model->id,
  410. 'data_type' => PaymentReceipt::type_one,
  411. 'data_order_no' => $order_number,
  412. 'data_order_type' => PaymentReceipt::data_type_one,
  413. 'amount' => $order['amount'],
  414. 'type' => PaymentReceiptInfo::type_three,
  415. 'crt_time' => $time,
  416. ];
  417. PaymentReceiptInfo::insert($insert);
  418. return [true,''];
  419. }
  420. //自动生成-----------------------------------
  421. //自动生成删除
  422. public function delCreatePurchaseOrderSales($data, $order){
  423. $sale_order = SalesOrder::where('del_time',0)
  424. ->where('contact_order_no',$order['order_number'])
  425. ->select('id','order_number')
  426. ->get()->toArray();
  427. if(empty($sale_order)) return [true,''];
  428. foreach ($sale_order as $value){
  429. list($status, $msg) = (new SalesOrderService())->salesOrderDel(['id' => $value['id']]);
  430. if(! $status) return [false,$msg];
  431. list($status, $msg) = (new PaymentReceiptService())->customerDel(['id' => $value['id']]);
  432. if(! $status) return [false,$msg];
  433. }
  434. return [true, ''];
  435. }
  436. //自动生成删除
  437. public function confirmPaymentReceipt($data){
  438. $model = PaymentReceipt::where('order_number',$data['order_number'])
  439. ->where('del_time',0)
  440. ->first();
  441. if(empty($model)) return [false, '收付款单不存在或已被删除'];
  442. if($model->state != PaymentReceipt::STATE_ONE) return [false, '请确认收付款单状态,操作失败'];
  443. if($data['type'] == self::TYPE_ONE){
  444. //通过
  445. $model->state = PaymentReceipt::STATE_TWO;
  446. $model->save();
  447. }else{
  448. //驳回
  449. $model->state = InvoiceOrder::STATE_ZERO;
  450. $model->save();
  451. }
  452. return [true, $model->toArray()];
  453. }
  454. public function confirmInvoiceOrder($data){
  455. $model = InvoiceOrder::where('order_number',$data['order_number'])
  456. ->where('del_time',0)
  457. ->first();
  458. if(empty($model)) return [false, '发货单不存在或已被删除'];
  459. if($model->state != InvoiceOrder::STATE_ONE) return [false, '请确认发货单状态,操作失败'];
  460. if($data['type'] == self::TYPE_ONE){
  461. //通过
  462. $model->state = InvoiceOrder::STATE_TWO;
  463. $model->save();
  464. $sale = SalesOrder::where('id',$model->sales_order_id)->first();
  465. if($sale['sales_order_type'] == SalesOrder::Order_type_one){
  466. //安装件更新发货状态
  467. SalesOrder::where('id',$model->sales_order_id)
  468. ->update(['invoice_state' => SalesOrder::invoice_one]);
  469. }else{
  470. //快递件更新 单据状态 发货状态
  471. SalesOrder::where('id',$model->sales_order_id)
  472. ->update([
  473. 'state' => SalesOrder::State2_one,
  474. 'invoice_state' => SalesOrder::invoice_one
  475. ]);
  476. }
  477. }else{
  478. //驳回
  479. $model->state = InvoiceOrder::STATE_ZERO;
  480. $model->save();
  481. }
  482. return [true, $model->toArray()];
  483. }
  484. public function recordInvoiceOrder($data, $order){
  485. $result = InvoiceOrderInfo::where('del_time',0)
  486. ->where('order_number',$order['order_number'])
  487. ->get()->toArray();
  488. if(empty($result)) return [false,'发货单产品信息不存在或已被删除'];
  489. $insert = [];
  490. $time = time();
  491. foreach ($result as $value){
  492. $key = $value['product_id'] . $value['storehouse_id'];
  493. if(isset($insert[$key])){
  494. $insert[$key]['number'] += -($value['number']);
  495. }else{
  496. $insert[$key] = [
  497. 'product_id' => $value['product_id'],
  498. 'number' => -($value['number']),
  499. 'order_type' => InvoiceOrder::prefix,
  500. 'order_number' => $order['order_number'],
  501. 'crt_time' => $time,
  502. 'storehouse_id' => $value['storehouse_id'],
  503. 'depart_id' => $order['depart_id'],
  504. 'top_depart_id' => $order['top_depart_id'],
  505. ];
  506. }
  507. }
  508. $insert = array_values($insert);
  509. $bool = InOutRecord::insert($insert);
  510. if(! $bool) return [false,'流水写入失败'];
  511. return [true,''];
  512. }
  513. public function confirmPurchaseOrderState($data){
  514. $model = PurchaseOrder::where('order_number',$data['order_number'])
  515. ->where('del_time',0)
  516. ->first();
  517. if(empty($model)) return [false,'采购单不存在或已被删除'];
  518. if($model->state != PurchaseOrder::STATE_ONE) return [false,'请确认采购单状态,操作失败'];
  519. if($data['type'] == self::TYPE_ONE){
  520. $model->state = PurchaseOrder::STATE_TWO;
  521. $model->save();
  522. }else{
  523. $model->state = PurchaseOrder::STATE_ZERO;
  524. $model->save();
  525. }
  526. return [true, $model->toArray()];
  527. }
  528. public function confirmPurchaseOrder($data,$user){
  529. $model = PurchaseOrder::where('order_number',$data['order_number'])
  530. ->where('del_time',0)
  531. ->first();
  532. if(empty($model)) return [false, '采购订单不存在或已被删除'];
  533. if($model->state != PurchaseOrder::STATE_TWO) return [false, '请确认采购订单状态,操作失败'];
  534. $model->state = PurchaseOrder::STATE_Four;
  535. $model->save();
  536. return [true, $model->toArray()];
  537. }
  538. public function recordPurchaseOrder($data, $order){
  539. $result = PurchaseOrderInfo::where('del_time',0)
  540. ->where('order_number',$order['order_number'])
  541. ->get()->toArray();
  542. if(empty($result)) return [false,'采购单产品信息不存在或已被删除'];
  543. $insert = [];
  544. $time = time();
  545. foreach ($result as $value){
  546. $key = $value['product_id'] . $value['storehouse_id'];
  547. if(isset($insert[$key])){
  548. $insert[$key]['number'] += $value['number'];
  549. }else{
  550. $insert[$key] = [
  551. 'product_id' => $value['product_id'],
  552. 'number' => $value['number'],
  553. 'order_type' => PurchaseOrder::prefix,
  554. 'order_number' => $order['order_number'],
  555. 'crt_time' => $time,
  556. 'storehouse_id' => $value['storehouse_id'],
  557. 'depart_id' => $order['depart_id'],
  558. 'top_depart_id' => $order['top_depart_id'],
  559. ];
  560. }
  561. }
  562. $insert = array_values($insert);
  563. $bool = InOutRecord::insert($insert);
  564. if(! $bool) return [false,'流水写入失败'];
  565. return [true,''];
  566. }
  567. public function confirmConstruction($data){
  568. $model = Construction::where('order_number',$data['order_number'])
  569. ->where('del_time',0)
  570. ->first();
  571. if(empty($model)) return [false, '施工单不存在或已被删除'];
  572. if($model->state != Construction::STATE_ONE) return [false, '请确认施工单状态,操作失败'];
  573. if($data['type'] == self::TYPE_ONE){
  574. $model->state = Construction::STATE_TWO;
  575. $model->save();
  576. //已下施工
  577. SalesOrder::where('id',$model->sales_order_id)->update(['state' => SalesOrder::State_five]);
  578. }else{
  579. $model->state = Construction::STATE_ZERO;
  580. $model->save();
  581. }
  582. return [true, $model->toArray()];
  583. }
  584. public function recordConstruction($data, $order){
  585. $result = ConstructionProductInfo::where('del_time',0)
  586. ->where('construction_id',$order['id'])
  587. ->get()->toArray();
  588. if(empty($result)) return [false,'施工单产品信息不存在或已被删除'];
  589. $insert = [];
  590. $time = time();
  591. foreach ($result as $value){
  592. $key = $value['product_id'] . $value['storehouse_id'];
  593. if(isset($insert[$key])){
  594. $insert[$key]['number'] += -($value['number']);
  595. }else{
  596. $insert[$key] = [
  597. 'product_id' => $value['product_id'],
  598. 'number' => -($value['number']),
  599. 'order_type' => Construction::$prefix[$order['model_type']] ?? '',
  600. 'order_number' => $order['order_number'],
  601. 'crt_time' => $time,
  602. 'storehouse_id' => $value['storehouse_id'],
  603. 'depart_id' => $order['depart_id'],
  604. 'top_depart_id' => $order['top_depart_id'],
  605. ];
  606. }
  607. }
  608. $insert = array_values($insert);
  609. $bool = InOutRecord::insert($insert);
  610. if(! $bool) return [false,'流水写入失败'];
  611. return [true,''];
  612. }
  613. public function confirmReturnExchangeOrder($data){
  614. $model = ReturnExchangeOrder::where('order_number',$data['order_number'])
  615. ->where('del_time',0)
  616. ->first();
  617. if(empty($model)) return [false, '退换货单不存在或已被删除'];
  618. if($model->state != ReturnExchangeOrder::State_one) return [false, '请确认退换货单状态,操作失败'];
  619. if($data['type'] == self::TYPE_ONE){
  620. $model->state = ReturnExchangeOrder::State_two;
  621. $model->save();
  622. // if($model->data_type == ReturnExchangeOrder::Order_type){
  623. // SalesOrder::where('id', $model->data_id)->update([
  624. // 'state' => SalesOrder::State_six
  625. // ]);
  626. // }
  627. }else{
  628. $model->state = ReturnExchangeOrder::State_zero;
  629. $model->save();
  630. }
  631. return [true, $model->toArray()];
  632. }
  633. public function recordReturnExchangeOrder($data, $order){
  634. $result = ReturnExchangeOrderProductInfo::where('del_time',0)
  635. ->where('return_exchange_id',$order['id'])
  636. ->get()->toArray();
  637. if(empty($result)) return [false,'退换货单产品信息不存在或已被删除'];
  638. $insert = $insert2 = [];
  639. $time = time();
  640. foreach ($result as $value){
  641. $key = $value['product_id'] . $value['storehouse_id'];
  642. $prefix = ReturnExchangeOrder::$prefix[$value['return_or_exchange']] ?? '';
  643. if($value['return_or_exchange'] == ReturnExchangeOrderProductInfo::type_one){
  644. //退货
  645. if(isset($insert[$key])){
  646. $insert[$key]['number'] += $value['number'];
  647. }else{
  648. $insert[$key] = [
  649. 'product_id' => $value['product_id'],
  650. 'number' => $value['number'],
  651. 'order_type' => $prefix,
  652. 'order_number' => $order['order_number'],
  653. 'crt_time' => $time,
  654. 'storehouse_id' => $value['storehouse_id'],
  655. 'depart_id' => $order['depart_id'],
  656. 'top_depart_id' => $order['top_depart_id'],
  657. ];
  658. }
  659. }else{
  660. //换货
  661. if(isset($insert2[$key])){
  662. $insert2[$key]['number'] += -($value['number']);
  663. }else{
  664. $insert2[$key] = [
  665. 'product_id' => $value['product_id'],
  666. 'number' => -($value['number']),
  667. 'order_type' => $prefix,
  668. 'order_number' => $order['order_number'],
  669. 'crt_time' => $time,
  670. 'storehouse_id' => $value['storehouse_id'],
  671. 'depart_id' => $order['depart_id'],
  672. 'top_depart_id' => $order['top_depart_id'],
  673. ];
  674. }
  675. }
  676. }
  677. $insert = array_values($insert);
  678. $bool = InOutRecord::insert($insert);
  679. if(! $bool) return [false,'流水写入失败'];
  680. if(! empty($insert2)) {
  681. $insert2 = array_values($insert2);
  682. $bool = InOutRecord::insert($insert2);
  683. if(! $bool) return [false,'流水写入失败'];
  684. }
  685. return [true,''];
  686. }
  687. public function settleSalesOrder($data,$user){
  688. $model = SalesOrder::where('order_number', $data['order_number'])
  689. ->where('del_time',0)
  690. ->first();
  691. if(empty($model)) return [false, '合同不存在或已被删除'];
  692. //安装件
  693. if($model->state <= SalesOrder::State_four || $model->state >= SalesOrder::State_seven) return [false, '请确认合同状态,操作失败'];
  694. SalesOrder::where('del_time',0)->where('order_number',$data['order_number'])
  695. ->update(['state' => SalesOrder::State_seven]);
  696. return [true, $model->toArray()];
  697. }
  698. public function settleSalesOrderCustomer($data,$user){
  699. $model = SalesOrder::where('order_number', $data['order_number'])
  700. ->where('del_time',0)
  701. ->first();
  702. if(empty($model)) return [false, '合同不存在或已被删除'];
  703. if(empty($data['img'])) return [false,'图片不能为空'];
  704. //安装件
  705. if($model->state != SalesOrder::State_seven) return [false, '请确认合同状态,操作失败'];
  706. SalesOrder::where('del_time',0)->where('order_number',$data['order_number'])
  707. ->update(['state' => SalesOrder::State_eight]);
  708. SalesOrderInfo::insert([
  709. 'sales_order_id' => $model->id,
  710. 'type' => SalesOrderInfo::type_six,
  711. 'file' => $data['img'],
  712. 'crt_time' => time(),
  713. ]);
  714. return [true, $model->toArray()];
  715. }
  716. public function settleSalesOrderConfirm($data,$user){
  717. $model = SalesOrder::where('order_number', $data['order_number'])
  718. ->where('del_time',0)
  719. ->first();
  720. if(empty($model)) return [false, '合同不存在或已被删除'];
  721. //安装件
  722. if($model->state != SalesOrder::State_four) return [false, '请确认合同状态,操作失败'];
  723. $model->is_confirm = 1;
  724. $model->save();
  725. $emp_name = Employee::where('id',$user['id'])->value('emp_name');
  726. $tmp_data = [
  727. $model->order_number,
  728. "派单合同",
  729. "接收派单成功",
  730. $emp_name,
  731. date('Y-m-d H:i:s'),
  732. ];
  733. if(! empty($model->dispatch_time_second_id)) (new OaService())->sendWxMsg($model->dispatch_time_second_id,2,0,37,$tmp_data);
  734. return [true, $model->toArray()];
  735. }
  736. public function confirmSales($data){
  737. $model = SalesOrder::where('order_number', $data['order_number'])
  738. ->where('del_time',0)
  739. ->first();
  740. if(empty($model)) return [false, '合同不存在或已被删除'];
  741. if($model->state != SalesOrder::State_one) return [false, '请确认合同状态,操作失败'];
  742. if($data['type'] == self::TYPE_ONE){
  743. $state = SalesOrder::State_three;
  744. if($model->model_type == SalesOrder::Model_type_four){
  745. //线上订单
  746. $state = SalesOrder::State_two;
  747. }
  748. $model->state = $state;
  749. $model->save();
  750. }else{
  751. $model->state = SalesOrder::State_zero;
  752. $model->save();
  753. }
  754. return [true, $model->toArray()];
  755. }
  756. public function reject_sales($data){
  757. $model = SalesOrder::where('order_number', $data['order_number'])
  758. ->where('del_time',0)
  759. ->first();
  760. if(empty($model)) return [false, '合同不存在或已被删除'];
  761. //安装件
  762. if($model->model_type == SalesOrder::Model_type_four){
  763. //线上订单
  764. if($model->state != SalesOrder::State_two) return [false, '请确认合同状态,操作失败'];
  765. }else{
  766. //除线上订单之外
  767. if($model->state != SalesOrder::State_three) return [false, '请确认合同状态,操作失败'];
  768. }
  769. //未确认
  770. $model->state = SalesOrder::State_zero;
  771. $model->save();
  772. return [true, $model->toArray()];
  773. }
  774. public function reject_purchase($data){
  775. $model = PurchaseOrder::where('order_number', $data['order_number'])
  776. ->where('del_time',0)
  777. ->first();
  778. if(empty($model)) return [false, '采购单不存在或已被删除'];
  779. //安装件
  780. if($model->state != PurchaseOrder::STATE_Four) return [false, '请确认采购单状态,操作失败'];
  781. $model->state = PurchaseOrder::STATE_TWO;
  782. $model->save();
  783. return [true, $model->toArray()];
  784. }
  785. public function reject_purchase_confirm($data){
  786. $model = PurchaseOrder::where('order_number', $data['order_number'])
  787. ->where('del_time',0)
  788. ->first();
  789. if(empty($model)) return [false, '采购单不存在或已被删除'];
  790. //安装件
  791. if($model->state != PurchaseOrder::STATE_TWO) return [false, '请确认采购单状态,操作失败'];
  792. $model->state = PurchaseOrder::STATE_ZERO;
  793. $model->save();
  794. return [true, $model->toArray()];
  795. }
  796. public function reject_construction($data){
  797. $model = Construction::where('order_number', $data['order_number'])
  798. ->where('del_time',0)
  799. ->first();
  800. if(empty($model)) return [false, '施工单不存在或已被删除'];
  801. //安装件
  802. if($model->state != Construction::STATE_TWO) return [false, '请确认施工单状态,操作失败'];
  803. $model->state = Construction::STATE_ZERO;
  804. $model->save();
  805. return [true, $model->toArray()];
  806. }
  807. public function reject_payment_receipt($data){
  808. $model = PaymentReceipt::where('order_number', $data['order_number'])
  809. ->where('del_time',0)
  810. ->first();
  811. if(empty($model)) return [false, '收付款单不存在或已被删除'];
  812. if($model->state != PaymentReceipt::STATE_TWO) return [false, '请确认收付款单状态,操作失败'];
  813. $model->state = PaymentReceipt::STATE_ZERO;
  814. $model->save();
  815. return [true, $model->toArray()];
  816. }
  817. public function reject_return_exchange($data){
  818. $model = ReturnExchangeOrder::where('order_number', $data['order_number'])
  819. ->where('del_time',0)
  820. ->first();
  821. if(empty($model)) return [false, '退换货单不存在或已被删除'];
  822. if($model->state != ReturnExchangeOrder::State_two) return [false, '请确认退换货单状态,操作失败'];
  823. $model->state = ReturnExchangeOrder::State_zero;
  824. $model->save();
  825. return [true, $model->toArray()];
  826. }
  827. public function reject_record_construction($data,$order){
  828. //获取单据最新数据时间 正常施工数据
  829. $latest = InOutRecord::where('del_time',0)
  830. ->where('order_number',$data['order_number'])
  831. ->where('number','<',0)
  832. ->select('crt_time')
  833. ->orderBy('crt_time', 'desc')
  834. ->first();
  835. $latest = $latest->toArray();
  836. $result = InOutRecord::where('del_time',0)
  837. ->where('crt_time',$latest['crt_time'])
  838. ->where('order_number',$data['order_number'])
  839. ->where('number','<',0)
  840. ->select('product_id','storehouse_id','number','depart_id','order_number','top_depart_id','order_type')
  841. ->get()->toArray();
  842. if(empty($result)) return [false,'施工出库流水数据未找到'];
  843. //生成对冲数据
  844. $time = time();
  845. foreach ($result as $key => $value){
  846. $result[$key]['number'] = abs($value['number']);
  847. $result[$key]['crt_time'] = $time;
  848. }
  849. $bool = InOutRecord::insert($result);
  850. if(! $bool) return [false,'流水写入失败'];
  851. //写入流水
  852. return [true, ''];
  853. }
  854. public function reject_record_purchase($data,$order){
  855. //获取单据最新数据时间 正常采购入库数据
  856. $latest = InOutRecord::where('del_time',0)
  857. ->where('order_number',$data['order_number'])
  858. ->where('number','>',0)
  859. ->select('crt_time')
  860. ->orderBy('crt_time', 'desc')
  861. ->first();
  862. $latest = $latest->toArray();
  863. $result = InOutRecord::where('del_time',0)
  864. ->where('crt_time',$latest['crt_time'])
  865. ->where('order_number',$data['order_number'])
  866. ->where('number','>',0)
  867. ->select('product_id','storehouse_id','number','depart_id','order_number','top_depart_id','order_type')
  868. ->get()->toArray();
  869. if(empty($result)) return [false,'采购入库流水数据未找到'];
  870. //生成对冲数据
  871. $time = time();
  872. foreach ($result as $key => $value){
  873. $result[$key]['number'] = - $value['number'];
  874. $result[$key]['crt_time'] = $time;
  875. }
  876. $bool = InOutRecord::insert($result);
  877. if(! $bool) return [false,'流水写入失败'];
  878. //写入流水
  879. return [true, ''];
  880. }
  881. public function reject_record_return_exchange($data,$order){
  882. $result = ReturnExchangeOrderProductInfo::where('del_time',0)
  883. ->where('return_exchange_id',$order['id'])
  884. ->get()->toArray();
  885. if(empty($result)) return [false,'退换货单产品信息不存在或已被删除'];
  886. $insert = $insert2 = [];
  887. $time = time();
  888. foreach ($result as $value){
  889. $key = $value['product_id'] . $value['storehouse_id'];
  890. $prefix = ReturnExchangeOrder::$prefix[$value['return_or_exchange']] ?? '';
  891. if($value['return_or_exchange'] == ReturnExchangeOrderProductInfo::type_one){
  892. //退货 扣出
  893. if(isset($insert[$key])){
  894. $insert[$key]['number'] += -($value['number']);
  895. }else{
  896. $insert[$key] = [
  897. 'product_id' => $value['product_id'],
  898. 'number' => -($value['number']),
  899. 'order_type' => $prefix,
  900. 'order_number' => $order['order_number'],
  901. 'crt_time' => $time,
  902. 'storehouse_id' => $value['storehouse_id'],
  903. 'depart_id' => $order['depart_id'],
  904. 'top_depart_id' => $order['top_depart_id'],
  905. ];
  906. }
  907. }else{
  908. //换货 加回
  909. if(isset($insert2[$key])){
  910. $insert2[$key]['number'] += $value['number'];
  911. }else{
  912. $insert2[$key] = [
  913. 'product_id' => $value['product_id'],
  914. 'number' => $value['number'],
  915. 'order_type' => $prefix,
  916. 'order_number' => $order['order_number'],
  917. 'crt_time' => $time,
  918. 'storehouse_id' => $value['storehouse_id'],
  919. 'depart_id' => $order['depart_id'],
  920. 'top_depart_id' => $order['top_depart_id'],
  921. ];
  922. }
  923. }
  924. }
  925. $insert = array_values($insert);
  926. $bool = InOutRecord::insert($insert);
  927. if(! $bool) return [false,'流水写入失败'];
  928. if(! empty($insert2)) {
  929. $insert2 = array_values($insert2);
  930. $bool = InOutRecord::insert($insert2);
  931. if(! $bool) return [false,'流水写入失败'];
  932. }
  933. return [true,''];
  934. }
  935. public function getOrderDetail($data,$user){
  936. if(empty($data['order_number'])) return [false,'必传参数不能为空'];
  937. $array = [];
  938. foreach (Construction::$prefix as $value){
  939. $array[$value] = "\App\Service\\ConstructionService";
  940. }
  941. foreach (ReturnExchangeOrder::$prefix as $value){
  942. $array[$value] = "\App\Service\\ReturnExchangeOrderService";
  943. }
  944. foreach (SalesOrder::$prefix as $value){
  945. $array[$value] = "\App\Service\\SalesOrderService";
  946. }
  947. $status = true;
  948. $msg = [];
  949. foreach ($array as $key => $value){
  950. if(strpos($data['order_number'],$key) !== false) {
  951. list($status, $msg) = (new $value)->detail($data);
  952. return [$status, $msg];
  953. }
  954. }
  955. if(strpos($data['order_number'],PurchaseOrder::prefix) !== false){
  956. $service = "\App\Service\\PurchaseOrderService";
  957. list($status, $msg) = (new $service)->detail($data,$user);
  958. return [$status, $msg];
  959. }
  960. return [$status, $msg];
  961. }
  962. public function checkAll($data,$user){
  963. if(empty($data['id']) || empty($data['order_number'])|| empty($data['opt_case'])) return [false,'必传参数不能为空或者参数值错误!'];
  964. list($status,$msg) = $this->limitingSendRequestBackgExpire($data['order_number'].$data['opt_case']);
  965. if(! $status) return [false,$msg];
  966. //走审批流 单据校验
  967. $function_check = self::$opt_1case_check[$data['opt_case']] ?? '';
  968. //走审批流 单据状态改为待审批方法
  969. $function = self::$opt_1case[$data['opt_case']] ?? '';
  970. //单据不走审批流
  971. $function2 = self::$finished[$data['opt_case']] ?? '';
  972. try{
  973. DB::beginTransaction();
  974. //不走审批流,更新完直接返回
  975. if($function2) {
  976. list($bool,$msg) = $this->$function2($data,$user);
  977. if($bool) {
  978. $order = $msg;
  979. list($bool,$err) = $this->createRecordAndInventoryMy($data,$user,$order);
  980. if($bool){
  981. DB::commit();
  982. return [true, ''];
  983. }else{
  984. DB::rollBack();
  985. return [false, $err];
  986. }
  987. }else{
  988. DB::rollBack();
  989. return [false, $msg];
  990. }
  991. }
  992. //需要审批流,校验
  993. if($function_check){
  994. list($bool,$msg) = $this->$function_check($data, $user);
  995. if(! $bool){
  996. DB::rollBack();
  997. return [false, $msg];
  998. }
  999. }
  1000. //需要审批流,从未审核变成待审核
  1001. if($function){
  1002. list($bool,$msg) = $this->$function($data);
  1003. if(! $bool){
  1004. DB::rollBack();
  1005. return [false, $msg];
  1006. }
  1007. //创建审批流
  1008. $args = [
  1009. 'order_no' => $data['order_number'],
  1010. 'menu_id' => $data['menu_id'] ?? 0,
  1011. 'opt_case' => $data['opt_case'],
  1012. 'order' => $msg,
  1013. ];
  1014. $oa = new OaService($user);
  1015. list($bool,$msg) = $oa->createOaOrder($args);
  1016. if(! $bool) {
  1017. DB::rollBack();
  1018. if($msg) return [false,$msg];
  1019. }
  1020. }
  1021. DB::commit();
  1022. return [true, ''];
  1023. }catch (\Throwable $exception){
  1024. DB::rollBack();
  1025. return [false, $exception->getMessage() . $exception->getFile(). $exception->getLine()];
  1026. }
  1027. }
  1028. //更新库存
  1029. public function changeInventory($data,$order,$user){
  1030. $number_symbol = "";
  1031. if(in_array($data['opt_case'],self::$in_opt)){
  1032. $number_symbol = ">";
  1033. }elseif (in_array($data['opt_case'],self::$out_opt)){
  1034. $number_symbol = "<";
  1035. }
  1036. //获取单据最新数据时间 正常审核的数据
  1037. $latest = InOutRecord::where('del_time',0)
  1038. ->where('order_number',$order['order_number'])
  1039. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1040. return $query->where('number', $number_symbol,0);
  1041. })
  1042. ->select('crt_time')
  1043. ->orderBy('crt_time', 'desc')
  1044. ->first();
  1045. $model = InOutRecord::where('del_time',0)
  1046. ->where('order_number',$order['order_number'])
  1047. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1048. return $query->where('number', $number_symbol,0);
  1049. })
  1050. ->select('number','crt_time','product_id','storehouse_id','top_depart_id');
  1051. if(! empty($latest)) {
  1052. $t = $latest->toArray();
  1053. $model->where('crt_time',$t['crt_time']);
  1054. }
  1055. $record = $model->get()->toArray();
  1056. if (empty($record)) return [false,'流水记录不存在'];
  1057. $top_depart_id = Storehouse::where('id', $order['storehouse_id'])->value('top_depart_id');
  1058. $result = $lock_number = [];
  1059. foreach ($record as $value){
  1060. $key = $value['product_id'] . $value['storehouse_id'];
  1061. if(isset($result[$key])){
  1062. $result[$key]['number'] += $value['number'];
  1063. }else{
  1064. $result[$key] = [
  1065. 'product_id' => $value['product_id'],
  1066. 'number' => $value['number'],
  1067. 'crt_time' => $value['crt_time'],
  1068. 'storehouse_id' => $value['storehouse_id'],
  1069. 'top_depart_id' => $top_depart_id,
  1070. ];
  1071. }
  1072. if($value['number'] < 0){
  1073. if(isset($lock_number[$key])){
  1074. $lock_number[$key] += $value['number'];
  1075. }else{
  1076. $lock_number[$key] = $value['number'];
  1077. }
  1078. }
  1079. }
  1080. //是否校验库存 是的话锁定数量要更新(根据当前操作人所在门店是否校验库存)
  1081. $lock = $user['is_check_stock'];
  1082. $result = array_values($result);
  1083. foreach ($result as $key => $value){
  1084. $keys = $value['product_id'] . $value['storehouse_id'];
  1085. $m = ProductInventory::where('product_id',$value['product_id'])
  1086. ->where('storehouse_id',$value['storehouse_id'])
  1087. ->select('product_id','number','storehouse_id')
  1088. ->first();
  1089. if(empty($m)){
  1090. ProductInventory::insert($result[$key]);
  1091. }else{
  1092. //锁定数量
  1093. $lock_number_tmp = 0;
  1094. if($lock && ! empty($lock_number[$keys])) $lock_number_tmp = $lock_number[$keys];
  1095. ProductInventory::where('product_id',$m->product_id)
  1096. ->where('storehouse_id',$m->storehouse_id)
  1097. ->lockForUpdate()
  1098. ->update([
  1099. 'number' => DB::raw('number + ('. $value['number'] . ')'),
  1100. 'lock_number' => DB::raw('lock_number + ('. $lock_number_tmp . ')')
  1101. ]);
  1102. }
  1103. }
  1104. return [true,''];
  1105. }
  1106. //业务单据审批通过后 驳回 更新库存
  1107. public function changeInventoryReject($data,$order,$user){
  1108. $number_symbol = "";
  1109. if(in_array($data['opt_case'],self::$in_opt)){
  1110. $number_symbol = "<";
  1111. }elseif (in_array($data['opt_case'],self::$out_opt)){
  1112. $number_symbol = ">";
  1113. }
  1114. //获取单据最新数据时间 正常审核的数据
  1115. $latest = InOutRecord::where('del_time',0)
  1116. ->where('order_number',$order['order_number'])
  1117. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1118. return $query->where('number', $number_symbol,0);
  1119. })
  1120. ->select('crt_time')
  1121. ->orderBy('crt_time', 'desc')
  1122. ->first();
  1123. $model = InOutRecord::where('del_time',0)
  1124. ->where('order_number',$order['order_number'])
  1125. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1126. return $query->where('number', $number_symbol,0);
  1127. })
  1128. ->select('number','crt_time','product_id','storehouse_id','top_depart_id');
  1129. if(! empty($latest)) {
  1130. $t = $latest->toArray();
  1131. $model->where('crt_time',$t['crt_time']);
  1132. }
  1133. $record = $model->get()->toArray();
  1134. if (empty($record)) return [false,'流水记录不存在'];
  1135. $top_depart_id = Storehouse::where('id', $order['storehouse_id'])->value('top_depart_id');
  1136. $result = $lock_number = [];
  1137. foreach ($record as $value){
  1138. $key = $value['product_id'] . $value['storehouse_id'];
  1139. if(isset($result[$key])){
  1140. $result[$key]['number'] += $value['number'];
  1141. }else{
  1142. $result[$key] = [
  1143. 'product_id' => $value['product_id'],
  1144. 'number' => $value['number'],
  1145. 'crt_time' => $value['crt_time'],
  1146. 'storehouse_id' => $value['storehouse_id'],
  1147. 'top_depart_id' => $top_depart_id,
  1148. ];
  1149. }
  1150. if($value['number'] > 0){
  1151. if(isset($lock_number[$key])){
  1152. $lock_number[$key] += $value['number'];
  1153. }else{
  1154. $lock_number[$key] = $value['number'];
  1155. }
  1156. }
  1157. }
  1158. //是否校验库存 是的话锁定数量要更新(根据当前操作人所在门店是否校验库存)
  1159. $lock = $user['is_check_stock'];
  1160. $result = array_values($result);
  1161. foreach ($result as $key => $value){
  1162. $keys = $value['product_id'] . $value['storehouse_id'];
  1163. $m = ProductInventory::where('product_id',$value['product_id'])
  1164. ->where('storehouse_id',$value['storehouse_id'])
  1165. ->select('product_id','number','storehouse_id')
  1166. ->first();
  1167. if(empty($m)){
  1168. ProductInventory::insert($result[$key]);
  1169. }else{
  1170. //锁定数量
  1171. $lock_number_tmp = 0;
  1172. if($lock && ! empty($lock_number[$keys])) $lock_number_tmp = $lock_number[$keys];
  1173. ProductInventory::where('product_id',$m->product_id)
  1174. ->where('storehouse_id',$m->storehouse_id)
  1175. ->lockForUpdate()
  1176. ->update([
  1177. 'number' => DB::raw('number + ('. $value['number'] . ')'),
  1178. 'lock_number' => DB::raw('lock_number + ('. $lock_number_tmp . ')')
  1179. ]);
  1180. }
  1181. }
  1182. return [true,''];
  1183. }
  1184. public function createRecordAndInventory($data = []){
  1185. if(empty($data['type']) || empty($data['opt_case']) || empty($data['order_number'])) return [false, '传递参数缺少'];
  1186. $user = $data['user_data'] ?? [];
  1187. if($data['type'] == self::TYPE_THREE){
  1188. //通过后弃审
  1189. if(! isset(self::$opt_case_reject[$data['opt_case']])) return [false, '该操作不存在'];
  1190. //具体方法
  1191. $function = self::$opt_case_reject[$data['opt_case']];
  1192. //流水
  1193. $function2 = self::$reject_record[$data['opt_case']] ?? '';
  1194. //自动生成删除
  1195. $function3 = self::$create_del[$data['opt_case']] ?? '';
  1196. try{
  1197. DB::beginTransaction();
  1198. //更新单据的状态
  1199. list($bool,$msg) = $this->$function($data);
  1200. if(! $bool){
  1201. DB::rollBack();
  1202. return [false, $msg];
  1203. }
  1204. $order = $msg;
  1205. if($function3){
  1206. list($boolean,$msg) = $this->$function3($data,$order);
  1207. if(! $boolean) {
  1208. DB::rollBack();
  1209. return [false, $msg];
  1210. }
  1211. }
  1212. if($function2) {
  1213. //流水
  1214. list($boolean,$msg) = $this->$function2($data,$order);
  1215. if(! $boolean) {
  1216. DB::rollBack();
  1217. return [false, $msg];
  1218. }
  1219. //库存
  1220. list($bool,$msg) = $this->changeInventoryReject($data,$order,$user);
  1221. if(! $bool){
  1222. DB::rollBack();
  1223. return [false, $msg];
  1224. }
  1225. }
  1226. if(! empty(self::$operation_order_reject[$data['opt_case']])){
  1227. $type = self::$operation_order_reject[$data['opt_case']];
  1228. (new OrderOperationService())->add([
  1229. 'order_number' => $order['order_number'],
  1230. 'msg' => OrderOperation::$type[$type],
  1231. 'type' => $type
  1232. ],$user);
  1233. }
  1234. DB::commit();
  1235. return [true, ''];
  1236. }catch (\Throwable $exception){
  1237. DB::rollBack();
  1238. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1239. }
  1240. }else{
  1241. //具体方法
  1242. $function = self::$opt_case[$data['opt_case']] ?? "";
  1243. $record = self::$record[$data['opt_case']] ?? "";
  1244. $create = self::$create[$data['opt_case']] ?? "";
  1245. try{
  1246. DB::beginTransaction();
  1247. list($bool,$msg) = $this->$function($data);
  1248. if(! $bool){
  1249. DB::rollBack();
  1250. return [false, $msg];
  1251. }
  1252. $order = $msg;
  1253. if($data['type'] == self::TYPE_ONE){
  1254. if($record) {
  1255. //流水
  1256. $bool = $this->$record($data, $order);
  1257. if(! $bool) {
  1258. DB::rollBack();
  1259. return [false, $msg];
  1260. }
  1261. //库存
  1262. list($bool,$msg) = $this->changeInventory($data, $order, $user);
  1263. if(! $bool) {
  1264. DB::rollBack();
  1265. return [false, $msg];
  1266. }
  1267. }
  1268. if($create) {
  1269. list($bool,$msg) = $this->$create($order,$user);
  1270. if(! $bool) {
  1271. DB::rollBack();
  1272. return [false, $msg];
  1273. }
  1274. }
  1275. }
  1276. if(! empty(self::$operation_order[$data['opt_case']])){
  1277. $user = $data['user_data'] ?? [];
  1278. $type = self::$operation_order[$data['opt_case']];
  1279. (new OrderOperationService())->add([
  1280. 'order_number' => $order['order_number'],
  1281. 'msg' => OrderOperation::$type[$type],
  1282. 'type' => $type
  1283. ],$user);
  1284. }
  1285. DB::commit();
  1286. return [true, ''];
  1287. }catch (\Throwable $exception){
  1288. DB::rollBack();
  1289. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1290. }
  1291. }
  1292. }
  1293. //不需要走审批流 直接调用
  1294. public function createRecordAndInventoryMy($data = [],$user = [],$order = []){
  1295. if(! empty($data['type']) && $data['type'] == self::TYPE_THREE){
  1296. }else{
  1297. //具体方法
  1298. $record = self::$record[$data['opt_case']] ?? "";
  1299. $create = self::$create[$data['opt_case']] ?? "";
  1300. try{
  1301. DB::beginTransaction();
  1302. if($record) {
  1303. //流水
  1304. list($bool,$msg) = $this->$record($data, $order);
  1305. if(! $bool) {
  1306. DB::rollBack();
  1307. return [false, $msg];
  1308. }
  1309. //库存
  1310. list($bool,$msg) = $this->changeInventory($data, $order, $user);
  1311. if(! $bool) {
  1312. DB::rollBack();
  1313. return [false, $msg];
  1314. }
  1315. }
  1316. if($create) {
  1317. list($bool,$msg) = $this->$create($order,$user);
  1318. if(! $bool) {
  1319. DB::rollBack();
  1320. return [false, $msg];
  1321. }
  1322. }
  1323. if(! empty(self::$operation_order[$data['opt_case']])){
  1324. $type = self::$operation_order[$data['opt_case']];
  1325. (new OrderOperationService())->add([
  1326. 'order_number' => $order['order_number'],
  1327. 'msg' => OrderOperation::$type[$type],
  1328. 'type' => $type
  1329. ],$user);
  1330. }
  1331. DB::commit();
  1332. return [true, ''];
  1333. }catch (\Throwable $exception){
  1334. DB::rollBack();
  1335. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1336. }
  1337. }
  1338. }
  1339. }