CheckService.php 60 KB

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