CheckService.php 60 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567
  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 => 'delCreatePurchaseOrder', // 派给分社的合同确认以后生成虚拟采购单
  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. //分社订货合同删除
  425. public function delCreatePurchaseOrderSales($data, $order){
  426. $sale_order = SalesOrder::where('del_time',0)
  427. ->where('contact_order_no',$order['order_number'])
  428. ->select('id','order_number')
  429. ->get()->toArray();
  430. if(empty($sale_order)) return [true,''];
  431. foreach ($sale_order as $value){
  432. list($status, $msg) = (new SalesOrderService())->salesOrderDel(['id' => $value['id']]);
  433. if(! $status) return [false,$msg];
  434. list($status, $msg) = (new PaymentReceiptService())->customerDel(['id' => $value['id']]);
  435. if(! $status) return [false,$msg];
  436. }
  437. return [true, ''];
  438. }
  439. //自动生成删除
  440. public function confirmPaymentReceipt($data){
  441. $model = PaymentReceipt::where('order_number',$data['order_number'])
  442. ->where('del_time',0)
  443. ->first();
  444. if(empty($model)) return [false, '收付款单不存在或已被删除'];
  445. if($model->state != PaymentReceipt::STATE_ONE) return [false, '请确认收付款单状态,操作失败'];
  446. if($data['type'] == self::TYPE_ONE){
  447. //通过
  448. $model->state = PaymentReceipt::STATE_TWO;
  449. $model->save();
  450. }else{
  451. //驳回
  452. $model->state = InvoiceOrder::STATE_ZERO;
  453. $model->save();
  454. }
  455. return [true, $model->toArray()];
  456. }
  457. public function confirmInvoiceOrder($data){
  458. $model = InvoiceOrder::where('order_number',$data['order_number'])
  459. ->where('del_time',0)
  460. ->first();
  461. if(empty($model)) return [false, '发货单不存在或已被删除'];
  462. if($model->state != InvoiceOrder::STATE_ONE) return [false, '请确认发货单状态,操作失败'];
  463. if($data['type'] == self::TYPE_ONE){
  464. //通过
  465. $model->state = InvoiceOrder::STATE_TWO;
  466. $model->save();
  467. $sale = SalesOrder::where('id',$model->sales_order_id)->first();
  468. if($sale['sales_order_type'] == SalesOrder::Order_type_one){
  469. //安装件更新发货状态
  470. SalesOrder::where('id',$model->sales_order_id)
  471. ->update(['invoice_state' => SalesOrder::invoice_one]);
  472. }else{
  473. //快递件更新 单据状态 发货状态
  474. SalesOrder::where('id',$model->sales_order_id)
  475. ->update([
  476. 'state' => SalesOrder::State2_one,
  477. 'invoice_state' => SalesOrder::invoice_one
  478. ]);
  479. }
  480. }else{
  481. //驳回
  482. $model->state = InvoiceOrder::STATE_ZERO;
  483. $model->save();
  484. }
  485. return [true, $model->toArray()];
  486. }
  487. public function recordInvoiceOrder($data, $order){
  488. $result = InvoiceOrderInfo::where('del_time',0)
  489. ->where('order_number',$order['order_number'])
  490. ->get()->toArray();
  491. if(empty($result)) return [false,'发货单产品信息不存在或已被删除'];
  492. $insert = [];
  493. $time = time();
  494. foreach ($result as $value){
  495. $key = $value['product_id'] . $value['storehouse_id'];
  496. if(isset($insert[$key])){
  497. $insert[$key]['number'] += -($value['number']);
  498. }else{
  499. $insert[$key] = [
  500. 'product_id' => $value['product_id'],
  501. 'number' => -($value['number']),
  502. 'order_type' => InvoiceOrder::prefix,
  503. 'order_number' => $order['order_number'],
  504. 'crt_time' => $time,
  505. 'storehouse_id' => $value['storehouse_id'],
  506. 'depart_id' => $order['depart_id'],
  507. 'top_depart_id' => $order['top_depart_id'],
  508. ];
  509. }
  510. }
  511. $insert = array_values($insert);
  512. $bool = InOutRecord::insert($insert);
  513. if(! $bool) return [false,'流水写入失败'];
  514. return [true,''];
  515. }
  516. public function confirmPurchaseOrderState($data){
  517. $model = PurchaseOrder::where('order_number',$data['order_number'])
  518. ->where('del_time',0)
  519. ->first();
  520. if(empty($model)) return [false,'采购单不存在或已被删除'];
  521. if($model->state != PurchaseOrder::STATE_ONE) return [false,'请确认采购单状态,操作失败'];
  522. if($data['type'] == self::TYPE_ONE){
  523. $model->state = PurchaseOrder::STATE_TWO;
  524. $model->save();
  525. }else{
  526. $model->state = PurchaseOrder::STATE_ZERO;
  527. $model->save();
  528. }
  529. return [true, $model->toArray()];
  530. }
  531. public function confirmPurchaseOrder($data,$user){
  532. $model = PurchaseOrder::where('order_number',$data['order_number'])
  533. ->where('del_time',0)
  534. ->first();
  535. if(empty($model)) return [false, '采购订单不存在或已被删除'];
  536. if($model->state != PurchaseOrder::STATE_TWO) return [false, '请确认采购订单状态,操作失败'];
  537. $model->state = PurchaseOrder::STATE_Four;
  538. $model->save();
  539. return [true, $model->toArray()];
  540. }
  541. public function recordPurchaseOrder($data, $order){
  542. $result = PurchaseOrderInfo::where('del_time',0)
  543. ->where('order_number',$order['order_number'])
  544. ->get()->toArray();
  545. if(empty($result)) return [false,'采购单产品信息不存在或已被删除'];
  546. $insert = [];
  547. $time = time();
  548. foreach ($result as $value){
  549. $key = $value['product_id'] . $value['storehouse_id'];
  550. if(isset($insert[$key])){
  551. $insert[$key]['number'] += $value['number'];
  552. }else{
  553. $insert[$key] = [
  554. 'product_id' => $value['product_id'],
  555. 'number' => $value['number'],
  556. 'order_type' => PurchaseOrder::prefix,
  557. 'order_number' => $order['order_number'],
  558. 'crt_time' => $time,
  559. 'storehouse_id' => $value['storehouse_id'],
  560. 'depart_id' => $order['depart_id'],
  561. 'top_depart_id' => $order['top_depart_id'],
  562. ];
  563. }
  564. }
  565. $insert = array_values($insert);
  566. $bool = InOutRecord::insert($insert);
  567. if(! $bool) return [false,'流水写入失败'];
  568. return [true,''];
  569. }
  570. public function confirmConstruction($data){
  571. $model = Construction::where('order_number',$data['order_number'])
  572. ->where('del_time',0)
  573. ->first();
  574. if(empty($model)) return [false, '施工单不存在或已被删除'];
  575. if($model->state != Construction::STATE_ONE) return [false, '请确认施工单状态,操作失败'];
  576. if($data['type'] == self::TYPE_ONE){
  577. $model->state = Construction::STATE_TWO;
  578. $model->save();
  579. //已下施工
  580. SalesOrder::where('id',$model->sales_order_id)->update(['state' => SalesOrder::State_five]);
  581. }else{
  582. $model->state = Construction::STATE_ZERO;
  583. $model->save();
  584. }
  585. return [true, $model->toArray()];
  586. }
  587. public function recordConstruction($data, $order){
  588. $result = ConstructionProductInfo::where('del_time',0)
  589. ->where('construction_id',$order['id'])
  590. ->get()->toArray();
  591. if(empty($result)) return [false,'施工单产品信息不存在或已被删除'];
  592. $insert = [];
  593. $time = time();
  594. foreach ($result as $value){
  595. $key = $value['product_id'] . $value['storehouse_id'];
  596. if(isset($insert[$key])){
  597. $insert[$key]['number'] += -($value['number']);
  598. }else{
  599. $insert[$key] = [
  600. 'product_id' => $value['product_id'],
  601. 'number' => -($value['number']),
  602. 'order_type' => Construction::$prefix[$order['model_type']] ?? '',
  603. 'order_number' => $order['order_number'],
  604. 'crt_time' => $time,
  605. 'storehouse_id' => $value['storehouse_id'],
  606. 'depart_id' => $order['depart_id'],
  607. 'top_depart_id' => $order['top_depart_id'],
  608. ];
  609. }
  610. }
  611. $insert = array_values($insert);
  612. $bool = InOutRecord::insert($insert);
  613. if(! $bool) return [false,'流水写入失败'];
  614. return [true,''];
  615. }
  616. public function confirmReturnExchangeOrder($data){
  617. $model = ReturnExchangeOrder::where('order_number',$data['order_number'])
  618. ->where('del_time',0)
  619. ->first();
  620. if(empty($model)) return [false, '退换货单不存在或已被删除'];
  621. if($model->state != ReturnExchangeOrder::State_one) return [false, '请确认退换货单状态,操作失败'];
  622. if($data['type'] == self::TYPE_ONE){
  623. $model->state = ReturnExchangeOrder::State_two;
  624. $model->save();
  625. // if($model->data_type == ReturnExchangeOrder::Order_type){
  626. // SalesOrder::where('id', $model->data_id)->update([
  627. // 'state' => SalesOrder::State_six
  628. // ]);
  629. // }
  630. }else{
  631. $model->state = ReturnExchangeOrder::State_zero;
  632. $model->save();
  633. }
  634. return [true, $model->toArray()];
  635. }
  636. public function recordReturnExchangeOrder($data, $order){
  637. if($order['model_type'] == ReturnExchangeOrder::Model_type_three) return [true, self::minus_one];
  638. // if($order['type'] == ReturnExchangeOrder::Order_type){
  639. // //快递件不记录流水
  640. // $sales_order_type = SalesOrder::where('id',$order['data_id'])->value('sales_order_type');
  641. // if($sales_order_type == SalesOrder::Order_type_two) return [true, self::minus_one];
  642. // }
  643. $result = ReturnExchangeOrderProductInfo::where('del_time',0)
  644. ->where('return_exchange_id',$order['id'])
  645. ->get()->toArray();
  646. if(empty($result)) return [false,'退换货单产品信息不存在或已被删除'];
  647. $insert = $insert2 = [];
  648. $time = time();
  649. foreach ($result as $value){
  650. $key = $value['product_id'] . $value['storehouse_id'];
  651. $prefix = ReturnExchangeOrder::$prefix[$value['return_or_exchange']] ?? '';
  652. if($value['return_or_exchange'] == ReturnExchangeOrderProductInfo::type_one){
  653. //退货
  654. if(isset($insert[$key])){
  655. $insert[$key]['number'] += $value['number'];
  656. }else{
  657. $insert[$key] = [
  658. 'product_id' => $value['product_id'],
  659. 'number' => $value['number'],
  660. 'order_type' => $prefix,
  661. 'order_number' => $order['order_number'],
  662. 'crt_time' => $time,
  663. 'storehouse_id' => $value['storehouse_id'],
  664. 'depart_id' => $order['depart_id'],
  665. 'top_depart_id' => $order['top_depart_id'],
  666. ];
  667. }
  668. }else{
  669. //换货
  670. if(isset($insert2[$key])){
  671. $insert2[$key]['number'] += -($value['number']);
  672. }else{
  673. $insert2[$key] = [
  674. 'product_id' => $value['product_id'],
  675. 'number' => -($value['number']),
  676. 'order_type' => $prefix,
  677. 'order_number' => $order['order_number'],
  678. 'crt_time' => $time,
  679. 'storehouse_id' => $value['storehouse_id'],
  680. 'depart_id' => $order['depart_id'],
  681. 'top_depart_id' => $order['top_depart_id'],
  682. ];
  683. }
  684. }
  685. }
  686. $insert = array_values($insert);
  687. $bool = InOutRecord::insert($insert);
  688. if(! $bool) return [false,'流水写入失败'];
  689. if(! empty($insert2)) {
  690. $insert2 = array_values($insert2);
  691. $bool = InOutRecord::insert($insert2);
  692. if(! $bool) return [false,'流水写入失败'];
  693. }
  694. return [true,''];
  695. }
  696. public function settleSalesOrder($data,$user){
  697. $model = SalesOrder::where('order_number', $data['order_number'])
  698. ->where('del_time',0)
  699. ->first();
  700. if(empty($model)) return [false, '合同不存在或已被删除'];
  701. //安装件
  702. if($model->state <= SalesOrder::State_four || $model->state >= SalesOrder::State_seven) return [false, '请确认合同状态,操作失败'];
  703. SalesOrder::where('del_time',0)->where('order_number',$data['order_number'])
  704. ->update(['state' => SalesOrder::State_seven]);
  705. return [true, $model->toArray()];
  706. }
  707. public function settleSalesOrderCustomer($data,$user){
  708. $model = SalesOrder::where('order_number', $data['order_number'])
  709. ->where('del_time',0)
  710. ->first();
  711. if(empty($model)) return [false, '合同不存在或已被删除'];
  712. if(empty($data['img'])) return [false,'图片不能为空'];
  713. //安装件
  714. if($model->state != SalesOrder::State_seven) return [false, '请确认合同状态,操作失败'];
  715. SalesOrder::where('del_time',0)->where('order_number',$data['order_number'])
  716. ->update(['state' => SalesOrder::State_eight]);
  717. SalesOrderInfo::insert([
  718. 'sales_order_id' => $model->id,
  719. 'type' => SalesOrderInfo::type_six,
  720. 'file' => $data['img'],
  721. 'crt_time' => time(),
  722. ]);
  723. return [true, $model->toArray()];
  724. }
  725. public function settleSalesOrderConfirm($data,$user){
  726. $model = SalesOrder::where('order_number', $data['order_number'])
  727. ->where('del_time',0)
  728. ->first();
  729. if(empty($model)) return [false, '合同不存在或已被删除'];
  730. //安装件
  731. if($model->state != SalesOrder::State_four) return [false, '请确认合同状态,操作失败'];
  732. $model->is_confirm = 1;
  733. $model->save();
  734. $emp_name = Employee::where('id',$user['id'])->value('emp_name');
  735. $tmp_data = [
  736. $model->order_number,
  737. "派单合同",
  738. "接收派单成功",
  739. $emp_name,
  740. date('Y-m-d H:i:s'),
  741. ];
  742. if(! empty($model->dispatch_time_second_id)) (new OaService())->sendWxMsg($model->dispatch_time_second_id,2,0,37,$tmp_data);
  743. return [true, $model->toArray()];
  744. }
  745. public function confirmSales($data){
  746. $model = SalesOrder::where('order_number', $data['order_number'])
  747. ->where('del_time',0)
  748. ->first();
  749. if(empty($model)) return [false, '合同不存在或已被删除'];
  750. if($model->state != SalesOrder::State_one) return [false, '请确认合同状态,操作失败'];
  751. if($data['type'] == self::TYPE_ONE){
  752. $state = SalesOrder::State_three;
  753. if($model->model_type == SalesOrder::Model_type_four){
  754. //线上订单
  755. $state = SalesOrder::State_two;
  756. }
  757. $model->state = $state;
  758. $model->save();
  759. }else{
  760. $model->state = SalesOrder::State_minus_one;
  761. $model->save();
  762. }
  763. return [true, $model->toArray()];
  764. }
  765. public function reject_sales($data){
  766. $model = SalesOrder::where('order_number', $data['order_number'])
  767. ->where('del_time',0)
  768. ->first();
  769. if(empty($model)) return [false, '合同不存在或已被删除'];
  770. //安装件
  771. if($model->model_type == SalesOrder::Model_type_four){
  772. //线上订单
  773. if($model->state != SalesOrder::State_two) return [false, '请确认合同状态,操作失败'];
  774. }else{
  775. //除线上订单之外
  776. if($model->state != SalesOrder::State_three) return [false, '请确认合同状态,操作失败'];
  777. }
  778. //未确认
  779. $model->state = SalesOrder::State_zero;
  780. $model->save();
  781. return [true, $model->toArray()];
  782. }
  783. public function reject_purchase($data){
  784. $model = PurchaseOrder::where('order_number', $data['order_number'])
  785. ->where('del_time',0)
  786. ->first();
  787. if(empty($model)) return [false, '采购单不存在或已被删除'];
  788. //安装件
  789. if($model->state != PurchaseOrder::STATE_Four) return [false, '请确认采购单状态,操作失败'];
  790. $model->state = PurchaseOrder::STATE_TWO;
  791. $model->save();
  792. return [true, $model->toArray()];
  793. }
  794. public function reject_purchase_confirm($data){
  795. $model = PurchaseOrder::where('order_number', $data['order_number'])
  796. ->where('del_time',0)
  797. ->first();
  798. if(empty($model)) return [false, '采购单不存在或已被删除'];
  799. //安装件
  800. if($model->state != PurchaseOrder::STATE_TWO) return [false, '请确认采购单状态,操作失败'];
  801. $model->state = PurchaseOrder::STATE_ZERO;
  802. $model->save();
  803. return [true, $model->toArray()];
  804. }
  805. public function reject_construction($data){
  806. $model = Construction::where('order_number', $data['order_number'])
  807. ->where('del_time',0)
  808. ->first();
  809. if(empty($model)) return [false, '施工单不存在或已被删除'];
  810. //安装件
  811. if($model->state != Construction::STATE_TWO) return [false, '请确认施工单状态,操作失败'];
  812. $model->state = Construction::STATE_ZERO;
  813. $model->save();
  814. return [true, $model->toArray()];
  815. }
  816. public function reject_payment_receipt($data){
  817. $model = PaymentReceipt::where('order_number', $data['order_number'])
  818. ->where('del_time',0)
  819. ->first();
  820. if(empty($model)) return [false, '收付款单不存在或已被删除'];
  821. if($model->state != PaymentReceipt::STATE_TWO) return [false, '请确认收付款单状态,操作失败'];
  822. $model->state = PaymentReceipt::STATE_ZERO;
  823. $model->save();
  824. return [true, $model->toArray()];
  825. }
  826. public function reject_return_exchange($data){
  827. $model = ReturnExchangeOrder::where('order_number', $data['order_number'])
  828. ->where('del_time',0)
  829. ->first();
  830. if(empty($model)) return [false, '退换货单不存在或已被删除'];
  831. if($model->state != ReturnExchangeOrder::State_two) return [false, '请确认退换货单状态,操作失败'];
  832. $model->state = ReturnExchangeOrder::State_zero;
  833. $model->save();
  834. return [true, $model->toArray()];
  835. }
  836. public function reject_record_construction($data,$order){
  837. //获取单据最新数据时间 正常施工数据
  838. $latest = InOutRecord::where('del_time',0)
  839. ->where('order_number',$data['order_number'])
  840. ->where('number','<',0)
  841. ->select('crt_time')
  842. ->orderBy('crt_time', 'desc')
  843. ->first();
  844. $latest = $latest->toArray();
  845. $result = InOutRecord::where('del_time',0)
  846. ->where('crt_time',$latest['crt_time'])
  847. ->where('order_number',$data['order_number'])
  848. ->where('number','<',0)
  849. ->select('product_id','storehouse_id','number','depart_id','order_number','top_depart_id','order_type')
  850. ->get()->toArray();
  851. if(empty($result)) return [false,'施工出库流水数据未找到'];
  852. //生成对冲数据
  853. $time = time();
  854. foreach ($result as $key => $value){
  855. $result[$key]['number'] = abs($value['number']);
  856. $result[$key]['crt_time'] = $time;
  857. }
  858. $bool = InOutRecord::insert($result);
  859. if(! $bool) return [false,'流水写入失败'];
  860. //写入流水
  861. return [true, ''];
  862. }
  863. public function reject_record_purchase($data,$order){
  864. //获取单据最新数据时间 正常采购入库数据
  865. $latest = InOutRecord::where('del_time',0)
  866. ->where('order_number',$data['order_number'])
  867. ->where('number','>',0)
  868. ->select('crt_time')
  869. ->orderBy('crt_time', 'desc')
  870. ->first();
  871. $latest = $latest->toArray();
  872. $result = InOutRecord::where('del_time',0)
  873. ->where('crt_time',$latest['crt_time'])
  874. ->where('order_number',$data['order_number'])
  875. ->where('number','>',0)
  876. ->select('product_id','storehouse_id','number','depart_id','order_number','top_depart_id','order_type')
  877. ->get()->toArray();
  878. if(empty($result)) return [false,'采购入库流水数据未找到'];
  879. //生成对冲数据
  880. $time = time();
  881. foreach ($result as $key => $value){
  882. $result[$key]['number'] = - $value['number'];
  883. $result[$key]['crt_time'] = $time;
  884. }
  885. $bool = InOutRecord::insert($result);
  886. if(! $bool) return [false,'流水写入失败'];
  887. //写入流水
  888. return [true, ''];
  889. }
  890. public function reject_record_return_exchange($data,$order){
  891. if($order['model_type'] == ReturnExchangeOrder::Model_type_three) return [true, self::minus_one];
  892. // if($order['type'] == ReturnExchangeOrder::Order_type){
  893. // //快递件不记录流水
  894. // $sales_order_type = SalesOrder::where('id',$order['data_id'])->value('sales_order_type');
  895. // if($sales_order_type == SalesOrder::Order_type_two) return [true, self::minus_one];
  896. // }
  897. $result = ReturnExchangeOrderProductInfo::where('del_time',0)
  898. ->where('return_exchange_id',$order['id'])
  899. ->get()->toArray();
  900. if(empty($result)) return [false,'退换货单产品信息不存在或已被删除'];
  901. $insert = $insert2 = [];
  902. $time = time();
  903. foreach ($result as $value){
  904. $key = $value['product_id'] . $value['storehouse_id'];
  905. $prefix = ReturnExchangeOrder::$prefix[$value['return_or_exchange']] ?? '';
  906. if($value['return_or_exchange'] == ReturnExchangeOrderProductInfo::type_one){
  907. //退货 扣出
  908. if(isset($insert[$key])){
  909. $insert[$key]['number'] += -($value['number']);
  910. }else{
  911. $insert[$key] = [
  912. 'product_id' => $value['product_id'],
  913. 'number' => -($value['number']),
  914. 'order_type' => $prefix,
  915. 'order_number' => $order['order_number'],
  916. 'crt_time' => $time,
  917. 'storehouse_id' => $value['storehouse_id'],
  918. 'depart_id' => $order['depart_id'],
  919. 'top_depart_id' => $order['top_depart_id'],
  920. ];
  921. }
  922. }else{
  923. //换货 加回
  924. if(isset($insert2[$key])){
  925. $insert2[$key]['number'] += $value['number'];
  926. }else{
  927. $insert2[$key] = [
  928. 'product_id' => $value['product_id'],
  929. 'number' => $value['number'],
  930. 'order_type' => $prefix,
  931. 'order_number' => $order['order_number'],
  932. 'crt_time' => $time,
  933. 'storehouse_id' => $value['storehouse_id'],
  934. 'depart_id' => $order['depart_id'],
  935. 'top_depart_id' => $order['top_depart_id'],
  936. ];
  937. }
  938. }
  939. }
  940. $insert = array_values($insert);
  941. $bool = InOutRecord::insert($insert);
  942. if(! $bool) return [false,'流水写入失败'];
  943. if(! empty($insert2)) {
  944. $insert2 = array_values($insert2);
  945. $bool = InOutRecord::insert($insert2);
  946. if(! $bool) return [false,'流水写入失败'];
  947. }
  948. return [true,''];
  949. }
  950. public function getOrderDetail($data,$user){
  951. if(empty($data['order_number'])) return [false,'必传参数不能为空'];
  952. $array = [];
  953. foreach (Construction::$prefix as $value){
  954. $array[$value] = "\App\Service\\ConstructionService";
  955. }
  956. foreach (ReturnExchangeOrder::$prefix as $value){
  957. $array[$value] = "\App\Service\\ReturnExchangeOrderService";
  958. }
  959. foreach (SalesOrder::$prefix as $value){
  960. $array[$value] = "\App\Service\\SalesOrderService";
  961. }
  962. $status = true;
  963. $msg = [];
  964. foreach ($array as $key => $value){
  965. if(strpos($data['order_number'],$key) !== false) {
  966. list($status, $msg) = (new $value)->detail($data);
  967. return [$status, $msg];
  968. }
  969. }
  970. if(strpos($data['order_number'],PurchaseOrder::prefix) !== false){
  971. $service = "\App\Service\\PurchaseOrderService";
  972. list($status, $msg) = (new $service)->detail($data,$user);
  973. return [$status, $msg];
  974. }
  975. return [$status, $msg];
  976. }
  977. public function checkAll($data,$user){
  978. if(empty($data['id']) || empty($data['order_number'])|| empty($data['opt_case'])) return [false,'必传参数不能为空或者参数值错误!'];
  979. list($status,$msg) = $this->limitingSendRequestBackgExpire($data['order_number'].$data['opt_case']);
  980. if(! $status) return [false,$msg];
  981. //走审批流 单据校验
  982. $function_check = self::$opt_1case_check[$data['opt_case']] ?? '';
  983. //走审批流 单据状态改为待审批方法
  984. $function = self::$opt_1case[$data['opt_case']] ?? '';
  985. //单据不走审批流
  986. $function2 = self::$finished[$data['opt_case']] ?? '';
  987. try{
  988. DB::beginTransaction();
  989. //不走审批流,更新完直接返回
  990. if($function2) {
  991. list($bool,$msg) = $this->$function2($data,$user);
  992. if($bool) {
  993. $order = $msg;
  994. list($bool,$err) = $this->createRecordAndInventoryMy($data,$user,$order);
  995. if($bool){
  996. DB::commit();
  997. return [true, ''];
  998. }else{
  999. DB::rollBack();
  1000. return [false, $err];
  1001. }
  1002. }else{
  1003. DB::rollBack();
  1004. return [false, $msg];
  1005. }
  1006. }
  1007. //需要审批流,校验
  1008. if($function_check){
  1009. list($bool,$msg) = $this->$function_check($data, $user);
  1010. if(! $bool){
  1011. DB::rollBack();
  1012. return [false, $msg];
  1013. }
  1014. }
  1015. //需要审批流,从未审核变成待审核
  1016. if($function){
  1017. list($bool,$msg) = $this->$function($data);
  1018. if(! $bool){
  1019. DB::rollBack();
  1020. return [false, $msg];
  1021. }
  1022. //创建审批流
  1023. $args = [
  1024. 'order_no' => $data['order_number'],
  1025. 'menu_id' => $data['menu_id'] ?? 0,
  1026. 'opt_case' => $data['opt_case'],
  1027. 'order' => $msg,
  1028. ];
  1029. $oa = new OaService($user);
  1030. list($bool,$msg) = $oa->createOaOrder($args);
  1031. if(! $bool) {
  1032. DB::rollBack();
  1033. if($msg) return [false,$msg];
  1034. }
  1035. }
  1036. DB::commit();
  1037. return [true, ''];
  1038. }catch (\Throwable $exception){
  1039. DB::rollBack();
  1040. return [false, $exception->getMessage() . $exception->getFile(). $exception->getLine()];
  1041. }
  1042. }
  1043. //更新库存
  1044. public function changeInventory($data,$order,$user){
  1045. $number_symbol = "";
  1046. if(in_array($data['opt_case'],self::$in_opt)){
  1047. $number_symbol = ">";
  1048. }elseif (in_array($data['opt_case'],self::$out_opt)){
  1049. $number_symbol = "<";
  1050. }
  1051. //获取单据最新数据时间 正常审核的数据
  1052. $latest = InOutRecord::where('del_time',0)
  1053. ->where('order_number',$order['order_number'])
  1054. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1055. return $query->where('number', $number_symbol,0);
  1056. })
  1057. ->select('crt_time')
  1058. ->orderBy('crt_time', 'desc')
  1059. ->first();
  1060. $model = InOutRecord::where('del_time',0)
  1061. ->where('order_number',$order['order_number'])
  1062. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1063. return $query->where('number', $number_symbol,0);
  1064. })
  1065. ->select('number','crt_time','product_id','storehouse_id','top_depart_id');
  1066. if(! empty($latest)) {
  1067. $t = $latest->toArray();
  1068. $model->where('crt_time',$t['crt_time']);
  1069. }
  1070. $record = $model->get()->toArray();
  1071. if (empty($record)) return [false,'流水记录不存在'];
  1072. $top_depart_id = Storehouse::where('id', $order['storehouse_id'])->value('top_depart_id');
  1073. $result = $lock_number = [];
  1074. foreach ($record as $value){
  1075. $key = $value['product_id'] . $value['storehouse_id'];
  1076. if(isset($result[$key])){
  1077. $result[$key]['number'] += $value['number'];
  1078. }else{
  1079. $result[$key] = [
  1080. 'product_id' => $value['product_id'],
  1081. 'number' => $value['number'],
  1082. 'crt_time' => $value['crt_time'],
  1083. 'storehouse_id' => $value['storehouse_id'],
  1084. 'top_depart_id' => $top_depart_id,
  1085. ];
  1086. }
  1087. if($value['number'] < 0){
  1088. if(isset($lock_number[$key])){
  1089. $lock_number[$key] += $value['number'];
  1090. }else{
  1091. $lock_number[$key] = $value['number'];
  1092. }
  1093. }
  1094. }
  1095. //是否校验库存 是的话锁定数量要更新(根据当前操作人所在门店是否校验库存)
  1096. $lock = $user['is_check_stock'];
  1097. $result = array_values($result);
  1098. foreach ($result as $key => $value){
  1099. $keys = $value['product_id'] . $value['storehouse_id'];
  1100. $m = ProductInventory::where('product_id',$value['product_id'])
  1101. ->where('storehouse_id',$value['storehouse_id'])
  1102. ->select('product_id','number','storehouse_id')
  1103. ->first();
  1104. if(empty($m)){
  1105. ProductInventory::insert($result[$key]);
  1106. }else{
  1107. //锁定数量
  1108. $lock_number_tmp = 0;
  1109. if($lock && ! empty($lock_number[$keys])) $lock_number_tmp = $lock_number[$keys];
  1110. ProductInventory::where('product_id',$m->product_id)
  1111. ->where('storehouse_id',$m->storehouse_id)
  1112. ->lockForUpdate()
  1113. ->update([
  1114. 'number' => DB::raw('number + ('. $value['number'] . ')'),
  1115. 'lock_number' => DB::raw('lock_number + ('. $lock_number_tmp . ')')
  1116. ]);
  1117. }
  1118. }
  1119. return [true,''];
  1120. }
  1121. //业务单据审批通过后 驳回 更新库存
  1122. public function changeInventoryReject($data,$order,$user){
  1123. $number_symbol = "";
  1124. if(in_array($data['opt_case'],self::$in_opt)){
  1125. $number_symbol = "<";
  1126. }elseif (in_array($data['opt_case'],self::$out_opt)){
  1127. $number_symbol = ">";
  1128. }
  1129. //获取单据最新数据时间 正常审核的数据
  1130. $latest = InOutRecord::where('del_time',0)
  1131. ->where('order_number',$order['order_number'])
  1132. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1133. return $query->where('number', $number_symbol,0);
  1134. })
  1135. ->select('crt_time')
  1136. ->orderBy('crt_time', 'desc')
  1137. ->first();
  1138. $model = InOutRecord::where('del_time',0)
  1139. ->where('order_number',$order['order_number'])
  1140. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1141. return $query->where('number', $number_symbol,0);
  1142. })
  1143. ->select('number','crt_time','product_id','storehouse_id','top_depart_id');
  1144. if(! empty($latest)) {
  1145. $t = $latest->toArray();
  1146. $model->where('crt_time',$t['crt_time']);
  1147. }
  1148. $record = $model->get()->toArray();
  1149. if (empty($record)) return [false,'流水记录不存在'];
  1150. $top_depart_id = Storehouse::where('id', $order['storehouse_id'])->value('top_depart_id');
  1151. $result = $lock_number = [];
  1152. foreach ($record as $value){
  1153. $key = $value['product_id'] . $value['storehouse_id'];
  1154. if(isset($result[$key])){
  1155. $result[$key]['number'] += $value['number'];
  1156. }else{
  1157. $result[$key] = [
  1158. 'product_id' => $value['product_id'],
  1159. 'number' => $value['number'],
  1160. 'crt_time' => $value['crt_time'],
  1161. 'storehouse_id' => $value['storehouse_id'],
  1162. 'top_depart_id' => $top_depart_id,
  1163. ];
  1164. }
  1165. if($value['number'] > 0){
  1166. if(isset($lock_number[$key])){
  1167. $lock_number[$key] += $value['number'];
  1168. }else{
  1169. $lock_number[$key] = $value['number'];
  1170. }
  1171. }
  1172. }
  1173. //是否校验库存 是的话锁定数量要更新(根据当前操作人所在门店是否校验库存)
  1174. $lock = $user['is_check_stock'];
  1175. $result = array_values($result);
  1176. foreach ($result as $key => $value){
  1177. $keys = $value['product_id'] . $value['storehouse_id'];
  1178. $m = ProductInventory::where('product_id',$value['product_id'])
  1179. ->where('storehouse_id',$value['storehouse_id'])
  1180. ->select('product_id','number','storehouse_id')
  1181. ->first();
  1182. if(empty($m)){
  1183. ProductInventory::insert($result[$key]);
  1184. }else{
  1185. //锁定数量
  1186. $lock_number_tmp = 0;
  1187. if($lock && ! empty($lock_number[$keys])) $lock_number_tmp = $lock_number[$keys];
  1188. ProductInventory::where('product_id',$m->product_id)
  1189. ->where('storehouse_id',$m->storehouse_id)
  1190. ->lockForUpdate()
  1191. ->update([
  1192. 'number' => DB::raw('number + ('. $value['number'] . ')'),
  1193. 'lock_number' => DB::raw('lock_number + ('. $lock_number_tmp . ')')
  1194. ]);
  1195. }
  1196. }
  1197. return [true,''];
  1198. }
  1199. public function createRecordAndInventory($data = []){
  1200. if(empty($data['type']) || empty($data['opt_case']) || empty($data['order_number'])) return [false, '传递参数缺少'];
  1201. $user = $data['user_data'] ?? [];
  1202. if($data['type'] == self::TYPE_THREE){
  1203. //通过后弃审
  1204. if(! isset(self::$opt_case_reject[$data['opt_case']])) return [false, '该操作不存在'];
  1205. //具体方法
  1206. $function = self::$opt_case_reject[$data['opt_case']];
  1207. //流水
  1208. $function2 = self::$reject_record[$data['opt_case']] ?? '';
  1209. //自动生成删除
  1210. $function3 = self::$create_del[$data['opt_case']] ?? '';
  1211. try{
  1212. DB::beginTransaction();
  1213. //更新单据的状态
  1214. list($bool,$msg) = $this->$function($data);
  1215. if(! $bool){
  1216. DB::rollBack();
  1217. return [false, $msg];
  1218. }
  1219. $order = $msg;
  1220. if($function3){
  1221. list($boolean,$msg) = $this->$function3($data,$order);
  1222. if(! $boolean) {
  1223. DB::rollBack();
  1224. return [false, $msg];
  1225. }
  1226. }
  1227. if($function2) {
  1228. //流水
  1229. list($boolean,$msg) = $this->$function2($data,$order);
  1230. if(! $boolean) {
  1231. DB::rollBack();
  1232. return [false, $msg];
  1233. }
  1234. if($msg != self::minus_one){
  1235. //库存
  1236. list($bool,$msg) = $this->changeInventoryReject($data,$order,$user);
  1237. if(! $bool){
  1238. DB::rollBack();
  1239. return [false, $msg];
  1240. }
  1241. }
  1242. }
  1243. if(! empty(self::$operation_order_reject[$data['opt_case']])){
  1244. $type = self::$operation_order_reject[$data['opt_case']];
  1245. (new OrderOperationService())->add([
  1246. 'order_number' => $order['order_number'],
  1247. 'msg' => OrderOperation::$type[$type],
  1248. 'type' => $type
  1249. ],$user);
  1250. }
  1251. DB::commit();
  1252. return [true, ''];
  1253. }catch (\Throwable $exception){
  1254. DB::rollBack();
  1255. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1256. }
  1257. }else{
  1258. //具体方法
  1259. $function = self::$opt_case[$data['opt_case']] ?? "";
  1260. $record = self::$record[$data['opt_case']] ?? "";
  1261. $create = self::$create[$data['opt_case']] ?? "";
  1262. try{
  1263. DB::beginTransaction();
  1264. list($bool,$msg) = $this->$function($data);
  1265. if(! $bool){
  1266. DB::rollBack();
  1267. return [false, $msg];
  1268. }
  1269. $order = $msg;
  1270. if($data['type'] == self::TYPE_ONE){
  1271. if($record) {
  1272. //流水
  1273. list($bool,$msg) = $this->$record($data, $order);
  1274. if(! $bool) {
  1275. DB::rollBack();
  1276. return [false, $msg];
  1277. }
  1278. if($msg != self::minus_one){
  1279. //库存
  1280. list($bool,$msg) = $this->changeInventory($data, $order, $user);
  1281. if(! $bool) {
  1282. DB::rollBack();
  1283. return [false, $msg];
  1284. }
  1285. }
  1286. }
  1287. if($create) {
  1288. list($bool,$msg) = $this->$create($order,$user);
  1289. if(! $bool) {
  1290. DB::rollBack();
  1291. return [false, $msg];
  1292. }
  1293. }
  1294. }
  1295. if(! empty(self::$operation_order[$data['opt_case']])){
  1296. $user = $data['user_data'] ?? [];
  1297. $type = self::$operation_order[$data['opt_case']];
  1298. (new OrderOperationService())->add([
  1299. 'order_number' => $order['order_number'],
  1300. 'msg' => OrderOperation::$type[$type],
  1301. 'type' => $type
  1302. ],$user);
  1303. }
  1304. DB::commit();
  1305. return [true, ''];
  1306. }catch (\Throwable $exception){
  1307. DB::rollBack();
  1308. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1309. }
  1310. }
  1311. }
  1312. //不需要走审批流 直接调用
  1313. public function createRecordAndInventoryMy($data = [],$user = [],$order = []){
  1314. if(! empty($data['type']) && $data['type'] == self::TYPE_THREE){
  1315. }else{
  1316. //具体方法
  1317. $record = self::$record[$data['opt_case']] ?? "";
  1318. $create = self::$create[$data['opt_case']] ?? "";
  1319. try{
  1320. DB::beginTransaction();
  1321. if($record) {
  1322. //流水
  1323. list($bool,$msg) = $this->$record($data, $order);
  1324. if(! $bool) {
  1325. DB::rollBack();
  1326. return [false, $msg];
  1327. }
  1328. if($msg != self::minus_one){
  1329. //库存
  1330. list($bool,$msg) = $this->changeInventory($data, $order, $user);
  1331. if(! $bool) {
  1332. DB::rollBack();
  1333. return [false, $msg];
  1334. }
  1335. }
  1336. }
  1337. if($create) {
  1338. list($bool,$msg) = $this->$create($order,$user);
  1339. if(! $bool) {
  1340. DB::rollBack();
  1341. return [false, $msg];
  1342. }
  1343. }
  1344. if(! empty(self::$operation_order[$data['opt_case']])){
  1345. $type = self::$operation_order[$data['opt_case']];
  1346. (new OrderOperationService())->add([
  1347. 'order_number' => $order['order_number'],
  1348. 'msg' => OrderOperation::$type[$type],
  1349. 'type' => $type
  1350. ],$user);
  1351. }
  1352. DB::commit();
  1353. return [true, ''];
  1354. }catch (\Throwable $exception){
  1355. DB::rollBack();
  1356. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1357. }
  1358. }
  1359. }
  1360. }