CheckService.php 62 KB

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