CheckService.php 60 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557
  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. $result = ReturnExchangeOrderProductInfo::where('del_time',0)
  639. ->where('return_exchange_id',$order['id'])
  640. ->get()->toArray();
  641. if(empty($result)) return [false,'退换货单产品信息不存在或已被删除'];
  642. $insert = $insert2 = [];
  643. $time = time();
  644. foreach ($result as $value){
  645. $key = $value['product_id'] . $value['storehouse_id'];
  646. $prefix = ReturnExchangeOrder::$prefix[$value['return_or_exchange']] ?? '';
  647. if($value['return_or_exchange'] == ReturnExchangeOrderProductInfo::type_one){
  648. //退货
  649. if(isset($insert[$key])){
  650. $insert[$key]['number'] += $value['number'];
  651. }else{
  652. $insert[$key] = [
  653. 'product_id' => $value['product_id'],
  654. 'number' => $value['number'],
  655. 'order_type' => $prefix,
  656. 'order_number' => $order['order_number'],
  657. 'crt_time' => $time,
  658. 'storehouse_id' => $value['storehouse_id'],
  659. 'depart_id' => $order['depart_id'],
  660. 'top_depart_id' => $order['top_depart_id'],
  661. ];
  662. }
  663. }else{
  664. //换货
  665. if(isset($insert2[$key])){
  666. $insert2[$key]['number'] += -($value['number']);
  667. }else{
  668. $insert2[$key] = [
  669. 'product_id' => $value['product_id'],
  670. 'number' => -($value['number']),
  671. 'order_type' => $prefix,
  672. 'order_number' => $order['order_number'],
  673. 'crt_time' => $time,
  674. 'storehouse_id' => $value['storehouse_id'],
  675. 'depart_id' => $order['depart_id'],
  676. 'top_depart_id' => $order['top_depart_id'],
  677. ];
  678. }
  679. }
  680. }
  681. $insert = array_values($insert);
  682. $bool = InOutRecord::insert($insert);
  683. if(! $bool) return [false,'流水写入失败'];
  684. if(! empty($insert2)) {
  685. $insert2 = array_values($insert2);
  686. $bool = InOutRecord::insert($insert2);
  687. if(! $bool) return [false,'流水写入失败'];
  688. }
  689. return [true,''];
  690. }
  691. public function settleSalesOrder($data,$user){
  692. $model = SalesOrder::where('order_number', $data['order_number'])
  693. ->where('del_time',0)
  694. ->first();
  695. if(empty($model)) return [false, '合同不存在或已被删除'];
  696. //安装件
  697. if($model->state <= SalesOrder::State_four || $model->state >= SalesOrder::State_seven) return [false, '请确认合同状态,操作失败'];
  698. SalesOrder::where('del_time',0)->where('order_number',$data['order_number'])
  699. ->update(['state' => SalesOrder::State_seven]);
  700. return [true, $model->toArray()];
  701. }
  702. public function settleSalesOrderCustomer($data,$user){
  703. $model = SalesOrder::where('order_number', $data['order_number'])
  704. ->where('del_time',0)
  705. ->first();
  706. if(empty($model)) return [false, '合同不存在或已被删除'];
  707. if(empty($data['img'])) return [false,'图片不能为空'];
  708. //安装件
  709. if($model->state != SalesOrder::State_seven) return [false, '请确认合同状态,操作失败'];
  710. SalesOrder::where('del_time',0)->where('order_number',$data['order_number'])
  711. ->update(['state' => SalesOrder::State_eight]);
  712. SalesOrderInfo::insert([
  713. 'sales_order_id' => $model->id,
  714. 'type' => SalesOrderInfo::type_six,
  715. 'file' => $data['img'],
  716. 'crt_time' => time(),
  717. ]);
  718. return [true, $model->toArray()];
  719. }
  720. public function settleSalesOrderConfirm($data,$user){
  721. $model = SalesOrder::where('order_number', $data['order_number'])
  722. ->where('del_time',0)
  723. ->first();
  724. if(empty($model)) return [false, '合同不存在或已被删除'];
  725. //安装件
  726. if($model->state != SalesOrder::State_four) return [false, '请确认合同状态,操作失败'];
  727. $model->is_confirm = 1;
  728. $model->save();
  729. $emp_name = Employee::where('id',$user['id'])->value('emp_name');
  730. $tmp_data = [
  731. $model->order_number,
  732. "派单合同",
  733. "接收派单成功",
  734. $emp_name,
  735. date('Y-m-d H:i:s'),
  736. ];
  737. if(! empty($model->dispatch_time_second_id)) (new OaService())->sendWxMsg($model->dispatch_time_second_id,2,0,37,$tmp_data);
  738. return [true, $model->toArray()];
  739. }
  740. public function confirmSales($data){
  741. $model = SalesOrder::where('order_number', $data['order_number'])
  742. ->where('del_time',0)
  743. ->first();
  744. if(empty($model)) return [false, '合同不存在或已被删除'];
  745. if($model->state != SalesOrder::State_one) return [false, '请确认合同状态,操作失败'];
  746. if($data['type'] == self::TYPE_ONE){
  747. $state = SalesOrder::State_three;
  748. if($model->model_type == SalesOrder::Model_type_four){
  749. //线上订单
  750. $state = SalesOrder::State_two;
  751. }
  752. $model->state = $state;
  753. $model->save();
  754. }else{
  755. $model->state = SalesOrder::State_minus_one;
  756. $model->save();
  757. }
  758. return [true, $model->toArray()];
  759. }
  760. public function reject_sales($data){
  761. $model = SalesOrder::where('order_number', $data['order_number'])
  762. ->where('del_time',0)
  763. ->first();
  764. if(empty($model)) return [false, '合同不存在或已被删除'];
  765. //安装件
  766. if($model->model_type == SalesOrder::Model_type_four){
  767. //线上订单
  768. if($model->state != SalesOrder::State_two) return [false, '请确认合同状态,操作失败'];
  769. }else{
  770. //除线上订单之外
  771. if($model->state != SalesOrder::State_three) return [false, '请确认合同状态,操作失败'];
  772. }
  773. //未确认
  774. $model->state = SalesOrder::State_zero;
  775. $model->save();
  776. return [true, $model->toArray()];
  777. }
  778. public function reject_purchase($data){
  779. $model = PurchaseOrder::where('order_number', $data['order_number'])
  780. ->where('del_time',0)
  781. ->first();
  782. if(empty($model)) return [false, '采购单不存在或已被删除'];
  783. //安装件
  784. if($model->state != PurchaseOrder::STATE_Four) return [false, '请确认采购单状态,操作失败'];
  785. $model->state = PurchaseOrder::STATE_TWO;
  786. $model->save();
  787. return [true, $model->toArray()];
  788. }
  789. public function reject_purchase_confirm($data){
  790. $model = PurchaseOrder::where('order_number', $data['order_number'])
  791. ->where('del_time',0)
  792. ->first();
  793. if(empty($model)) return [false, '采购单不存在或已被删除'];
  794. //安装件
  795. if($model->state != PurchaseOrder::STATE_TWO) return [false, '请确认采购单状态,操作失败'];
  796. $model->state = PurchaseOrder::STATE_ZERO;
  797. $model->save();
  798. return [true, $model->toArray()];
  799. }
  800. public function reject_construction($data){
  801. $model = Construction::where('order_number', $data['order_number'])
  802. ->where('del_time',0)
  803. ->first();
  804. if(empty($model)) return [false, '施工单不存在或已被删除'];
  805. //安装件
  806. if($model->state != Construction::STATE_TWO) return [false, '请确认施工单状态,操作失败'];
  807. $model->state = Construction::STATE_ZERO;
  808. $model->save();
  809. return [true, $model->toArray()];
  810. }
  811. public function reject_payment_receipt($data){
  812. $model = PaymentReceipt::where('order_number', $data['order_number'])
  813. ->where('del_time',0)
  814. ->first();
  815. if(empty($model)) return [false, '收付款单不存在或已被删除'];
  816. if($model->state != PaymentReceipt::STATE_TWO) return [false, '请确认收付款单状态,操作失败'];
  817. $model->state = PaymentReceipt::STATE_ZERO;
  818. $model->save();
  819. return [true, $model->toArray()];
  820. }
  821. public function reject_return_exchange($data){
  822. $model = ReturnExchangeOrder::where('order_number', $data['order_number'])
  823. ->where('del_time',0)
  824. ->first();
  825. if(empty($model)) return [false, '退换货单不存在或已被删除'];
  826. if($model->state != ReturnExchangeOrder::State_two) return [false, '请确认退换货单状态,操作失败'];
  827. $model->state = ReturnExchangeOrder::State_zero;
  828. $model->save();
  829. return [true, $model->toArray()];
  830. }
  831. public function reject_record_construction($data,$order){
  832. //获取单据最新数据时间 正常施工数据
  833. $latest = InOutRecord::where('del_time',0)
  834. ->where('order_number',$data['order_number'])
  835. ->where('number','<',0)
  836. ->select('crt_time')
  837. ->orderBy('crt_time', 'desc')
  838. ->first();
  839. $latest = $latest->toArray();
  840. $result = InOutRecord::where('del_time',0)
  841. ->where('crt_time',$latest['crt_time'])
  842. ->where('order_number',$data['order_number'])
  843. ->where('number','<',0)
  844. ->select('product_id','storehouse_id','number','depart_id','order_number','top_depart_id','order_type')
  845. ->get()->toArray();
  846. if(empty($result)) return [false,'施工出库流水数据未找到'];
  847. //生成对冲数据
  848. $time = time();
  849. foreach ($result as $key => $value){
  850. $result[$key]['number'] = abs($value['number']);
  851. $result[$key]['crt_time'] = $time;
  852. }
  853. $bool = InOutRecord::insert($result);
  854. if(! $bool) return [false,'流水写入失败'];
  855. //写入流水
  856. return [true, ''];
  857. }
  858. public function reject_record_purchase($data,$order){
  859. //获取单据最新数据时间 正常采购入库数据
  860. $latest = InOutRecord::where('del_time',0)
  861. ->where('order_number',$data['order_number'])
  862. ->where('number','>',0)
  863. ->select('crt_time')
  864. ->orderBy('crt_time', 'desc')
  865. ->first();
  866. $latest = $latest->toArray();
  867. $result = InOutRecord::where('del_time',0)
  868. ->where('crt_time',$latest['crt_time'])
  869. ->where('order_number',$data['order_number'])
  870. ->where('number','>',0)
  871. ->select('product_id','storehouse_id','number','depart_id','order_number','top_depart_id','order_type')
  872. ->get()->toArray();
  873. if(empty($result)) return [false,'采购入库流水数据未找到'];
  874. //生成对冲数据
  875. $time = time();
  876. foreach ($result as $key => $value){
  877. $result[$key]['number'] = - $value['number'];
  878. $result[$key]['crt_time'] = $time;
  879. }
  880. $bool = InOutRecord::insert($result);
  881. if(! $bool) return [false,'流水写入失败'];
  882. //写入流水
  883. return [true, ''];
  884. }
  885. public function reject_record_return_exchange($data,$order){
  886. if($order['model_type'] == ReturnExchangeOrder::Model_type_three) return [true, self::minus_one];
  887. $result = ReturnExchangeOrderProductInfo::where('del_time',0)
  888. ->where('return_exchange_id',$order['id'])
  889. ->get()->toArray();
  890. if(empty($result)) return [false,'退换货单产品信息不存在或已被删除'];
  891. $insert = $insert2 = [];
  892. $time = time();
  893. foreach ($result as $value){
  894. $key = $value['product_id'] . $value['storehouse_id'];
  895. $prefix = ReturnExchangeOrder::$prefix[$value['return_or_exchange']] ?? '';
  896. if($value['return_or_exchange'] == ReturnExchangeOrderProductInfo::type_one){
  897. //退货 扣出
  898. if(isset($insert[$key])){
  899. $insert[$key]['number'] += -($value['number']);
  900. }else{
  901. $insert[$key] = [
  902. 'product_id' => $value['product_id'],
  903. 'number' => -($value['number']),
  904. 'order_type' => $prefix,
  905. 'order_number' => $order['order_number'],
  906. 'crt_time' => $time,
  907. 'storehouse_id' => $value['storehouse_id'],
  908. 'depart_id' => $order['depart_id'],
  909. 'top_depart_id' => $order['top_depart_id'],
  910. ];
  911. }
  912. }else{
  913. //换货 加回
  914. if(isset($insert2[$key])){
  915. $insert2[$key]['number'] += $value['number'];
  916. }else{
  917. $insert2[$key] = [
  918. 'product_id' => $value['product_id'],
  919. 'number' => $value['number'],
  920. 'order_type' => $prefix,
  921. 'order_number' => $order['order_number'],
  922. 'crt_time' => $time,
  923. 'storehouse_id' => $value['storehouse_id'],
  924. 'depart_id' => $order['depart_id'],
  925. 'top_depart_id' => $order['top_depart_id'],
  926. ];
  927. }
  928. }
  929. }
  930. $insert = array_values($insert);
  931. $bool = InOutRecord::insert($insert);
  932. if(! $bool) return [false,'流水写入失败'];
  933. if(! empty($insert2)) {
  934. $insert2 = array_values($insert2);
  935. $bool = InOutRecord::insert($insert2);
  936. if(! $bool) return [false,'流水写入失败'];
  937. }
  938. return [true,''];
  939. }
  940. public function getOrderDetail($data,$user){
  941. if(empty($data['order_number'])) return [false,'必传参数不能为空'];
  942. $array = [];
  943. foreach (Construction::$prefix as $value){
  944. $array[$value] = "\App\Service\\ConstructionService";
  945. }
  946. foreach (ReturnExchangeOrder::$prefix as $value){
  947. $array[$value] = "\App\Service\\ReturnExchangeOrderService";
  948. }
  949. foreach (SalesOrder::$prefix as $value){
  950. $array[$value] = "\App\Service\\SalesOrderService";
  951. }
  952. $status = true;
  953. $msg = [];
  954. foreach ($array as $key => $value){
  955. if(strpos($data['order_number'],$key) !== false) {
  956. list($status, $msg) = (new $value)->detail($data);
  957. return [$status, $msg];
  958. }
  959. }
  960. if(strpos($data['order_number'],PurchaseOrder::prefix) !== false){
  961. $service = "\App\Service\\PurchaseOrderService";
  962. list($status, $msg) = (new $service)->detail($data,$user);
  963. return [$status, $msg];
  964. }
  965. return [$status, $msg];
  966. }
  967. public function checkAll($data,$user){
  968. if(empty($data['id']) || empty($data['order_number'])|| empty($data['opt_case'])) return [false,'必传参数不能为空或者参数值错误!'];
  969. list($status,$msg) = $this->limitingSendRequestBackgExpire($data['order_number'].$data['opt_case']);
  970. if(! $status) return [false,$msg];
  971. //走审批流 单据校验
  972. $function_check = self::$opt_1case_check[$data['opt_case']] ?? '';
  973. //走审批流 单据状态改为待审批方法
  974. $function = self::$opt_1case[$data['opt_case']] ?? '';
  975. //单据不走审批流
  976. $function2 = self::$finished[$data['opt_case']] ?? '';
  977. try{
  978. DB::beginTransaction();
  979. //不走审批流,更新完直接返回
  980. if($function2) {
  981. list($bool,$msg) = $this->$function2($data,$user);
  982. if($bool) {
  983. $order = $msg;
  984. list($bool,$err) = $this->createRecordAndInventoryMy($data,$user,$order);
  985. if($bool){
  986. DB::commit();
  987. return [true, ''];
  988. }else{
  989. DB::rollBack();
  990. return [false, $err];
  991. }
  992. }else{
  993. DB::rollBack();
  994. return [false, $msg];
  995. }
  996. }
  997. //需要审批流,校验
  998. if($function_check){
  999. list($bool,$msg) = $this->$function_check($data, $user);
  1000. if(! $bool){
  1001. DB::rollBack();
  1002. return [false, $msg];
  1003. }
  1004. }
  1005. //需要审批流,从未审核变成待审核
  1006. if($function){
  1007. list($bool,$msg) = $this->$function($data);
  1008. if(! $bool){
  1009. DB::rollBack();
  1010. return [false, $msg];
  1011. }
  1012. //创建审批流
  1013. $args = [
  1014. 'order_no' => $data['order_number'],
  1015. 'menu_id' => $data['menu_id'] ?? 0,
  1016. 'opt_case' => $data['opt_case'],
  1017. 'order' => $msg,
  1018. ];
  1019. $oa = new OaService($user);
  1020. list($bool,$msg) = $oa->createOaOrder($args);
  1021. if(! $bool) {
  1022. DB::rollBack();
  1023. if($msg) return [false,$msg];
  1024. }
  1025. }
  1026. DB::commit();
  1027. return [true, ''];
  1028. }catch (\Throwable $exception){
  1029. DB::rollBack();
  1030. return [false, $exception->getMessage() . $exception->getFile(). $exception->getLine()];
  1031. }
  1032. }
  1033. //更新库存
  1034. public function changeInventory($data,$order,$user){
  1035. $number_symbol = "";
  1036. if(in_array($data['opt_case'],self::$in_opt)){
  1037. $number_symbol = ">";
  1038. }elseif (in_array($data['opt_case'],self::$out_opt)){
  1039. $number_symbol = "<";
  1040. }
  1041. //获取单据最新数据时间 正常审核的数据
  1042. $latest = InOutRecord::where('del_time',0)
  1043. ->where('order_number',$order['order_number'])
  1044. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1045. return $query->where('number', $number_symbol,0);
  1046. })
  1047. ->select('crt_time')
  1048. ->orderBy('crt_time', 'desc')
  1049. ->first();
  1050. $model = InOutRecord::where('del_time',0)
  1051. ->where('order_number',$order['order_number'])
  1052. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1053. return $query->where('number', $number_symbol,0);
  1054. })
  1055. ->select('number','crt_time','product_id','storehouse_id','top_depart_id');
  1056. if(! empty($latest)) {
  1057. $t = $latest->toArray();
  1058. $model->where('crt_time',$t['crt_time']);
  1059. }
  1060. $record = $model->get()->toArray();
  1061. if (empty($record)) return [false,'流水记录不存在'];
  1062. $top_depart_id = Storehouse::where('id', $order['storehouse_id'])->value('top_depart_id');
  1063. $result = $lock_number = [];
  1064. foreach ($record as $value){
  1065. $key = $value['product_id'] . $value['storehouse_id'];
  1066. if(isset($result[$key])){
  1067. $result[$key]['number'] += $value['number'];
  1068. }else{
  1069. $result[$key] = [
  1070. 'product_id' => $value['product_id'],
  1071. 'number' => $value['number'],
  1072. 'crt_time' => $value['crt_time'],
  1073. 'storehouse_id' => $value['storehouse_id'],
  1074. 'top_depart_id' => $top_depart_id,
  1075. ];
  1076. }
  1077. if($value['number'] < 0){
  1078. if(isset($lock_number[$key])){
  1079. $lock_number[$key] += $value['number'];
  1080. }else{
  1081. $lock_number[$key] = $value['number'];
  1082. }
  1083. }
  1084. }
  1085. //是否校验库存 是的话锁定数量要更新(根据当前操作人所在门店是否校验库存)
  1086. $lock = $user['is_check_stock'];
  1087. $result = array_values($result);
  1088. foreach ($result as $key => $value){
  1089. $keys = $value['product_id'] . $value['storehouse_id'];
  1090. $m = ProductInventory::where('product_id',$value['product_id'])
  1091. ->where('storehouse_id',$value['storehouse_id'])
  1092. ->select('product_id','number','storehouse_id')
  1093. ->first();
  1094. if(empty($m)){
  1095. ProductInventory::insert($result[$key]);
  1096. }else{
  1097. //锁定数量
  1098. $lock_number_tmp = 0;
  1099. if($lock && ! empty($lock_number[$keys])) $lock_number_tmp = $lock_number[$keys];
  1100. ProductInventory::where('product_id',$m->product_id)
  1101. ->where('storehouse_id',$m->storehouse_id)
  1102. ->lockForUpdate()
  1103. ->update([
  1104. 'number' => DB::raw('number + ('. $value['number'] . ')'),
  1105. 'lock_number' => DB::raw('lock_number + ('. $lock_number_tmp . ')')
  1106. ]);
  1107. }
  1108. }
  1109. return [true,''];
  1110. }
  1111. //业务单据审批通过后 驳回 更新库存
  1112. public function changeInventoryReject($data,$order,$user){
  1113. $number_symbol = "";
  1114. if(in_array($data['opt_case'],self::$in_opt)){
  1115. $number_symbol = "<";
  1116. }elseif (in_array($data['opt_case'],self::$out_opt)){
  1117. $number_symbol = ">";
  1118. }
  1119. //获取单据最新数据时间 正常审核的数据
  1120. $latest = InOutRecord::where('del_time',0)
  1121. ->where('order_number',$order['order_number'])
  1122. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1123. return $query->where('number', $number_symbol,0);
  1124. })
  1125. ->select('crt_time')
  1126. ->orderBy('crt_time', 'desc')
  1127. ->first();
  1128. $model = InOutRecord::where('del_time',0)
  1129. ->where('order_number',$order['order_number'])
  1130. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1131. return $query->where('number', $number_symbol,0);
  1132. })
  1133. ->select('number','crt_time','product_id','storehouse_id','top_depart_id');
  1134. if(! empty($latest)) {
  1135. $t = $latest->toArray();
  1136. $model->where('crt_time',$t['crt_time']);
  1137. }
  1138. $record = $model->get()->toArray();
  1139. if (empty($record)) return [false,'流水记录不存在'];
  1140. $top_depart_id = Storehouse::where('id', $order['storehouse_id'])->value('top_depart_id');
  1141. $result = $lock_number = [];
  1142. foreach ($record as $value){
  1143. $key = $value['product_id'] . $value['storehouse_id'];
  1144. if(isset($result[$key])){
  1145. $result[$key]['number'] += $value['number'];
  1146. }else{
  1147. $result[$key] = [
  1148. 'product_id' => $value['product_id'],
  1149. 'number' => $value['number'],
  1150. 'crt_time' => $value['crt_time'],
  1151. 'storehouse_id' => $value['storehouse_id'],
  1152. 'top_depart_id' => $top_depart_id,
  1153. ];
  1154. }
  1155. if($value['number'] > 0){
  1156. if(isset($lock_number[$key])){
  1157. $lock_number[$key] += $value['number'];
  1158. }else{
  1159. $lock_number[$key] = $value['number'];
  1160. }
  1161. }
  1162. }
  1163. //是否校验库存 是的话锁定数量要更新(根据当前操作人所在门店是否校验库存)
  1164. $lock = $user['is_check_stock'];
  1165. $result = array_values($result);
  1166. foreach ($result as $key => $value){
  1167. $keys = $value['product_id'] . $value['storehouse_id'];
  1168. $m = ProductInventory::where('product_id',$value['product_id'])
  1169. ->where('storehouse_id',$value['storehouse_id'])
  1170. ->select('product_id','number','storehouse_id')
  1171. ->first();
  1172. if(empty($m)){
  1173. ProductInventory::insert($result[$key]);
  1174. }else{
  1175. //锁定数量
  1176. $lock_number_tmp = 0;
  1177. if($lock && ! empty($lock_number[$keys])) $lock_number_tmp = $lock_number[$keys];
  1178. ProductInventory::where('product_id',$m->product_id)
  1179. ->where('storehouse_id',$m->storehouse_id)
  1180. ->lockForUpdate()
  1181. ->update([
  1182. 'number' => DB::raw('number + ('. $value['number'] . ')'),
  1183. 'lock_number' => DB::raw('lock_number + ('. $lock_number_tmp . ')')
  1184. ]);
  1185. }
  1186. }
  1187. return [true,''];
  1188. }
  1189. public function createRecordAndInventory($data = []){
  1190. if(empty($data['type']) || empty($data['opt_case']) || empty($data['order_number'])) return [false, '传递参数缺少'];
  1191. $user = $data['user_data'] ?? [];
  1192. if($data['type'] == self::TYPE_THREE){
  1193. //通过后弃审
  1194. if(! isset(self::$opt_case_reject[$data['opt_case']])) return [false, '该操作不存在'];
  1195. //具体方法
  1196. $function = self::$opt_case_reject[$data['opt_case']];
  1197. //流水
  1198. $function2 = self::$reject_record[$data['opt_case']] ?? '';
  1199. //自动生成删除
  1200. $function3 = self::$create_del[$data['opt_case']] ?? '';
  1201. try{
  1202. DB::beginTransaction();
  1203. //更新单据的状态
  1204. list($bool,$msg) = $this->$function($data);
  1205. if(! $bool){
  1206. DB::rollBack();
  1207. return [false, $msg];
  1208. }
  1209. $order = $msg;
  1210. if($function3){
  1211. list($boolean,$msg) = $this->$function3($data,$order);
  1212. if(! $boolean) {
  1213. DB::rollBack();
  1214. return [false, $msg];
  1215. }
  1216. }
  1217. if($function2) {
  1218. //流水
  1219. list($boolean,$msg) = $this->$function2($data,$order);
  1220. if(! $boolean) {
  1221. DB::rollBack();
  1222. return [false, $msg];
  1223. }
  1224. if($msg != self::minus_one){
  1225. //库存
  1226. list($bool,$msg) = $this->changeInventoryReject($data,$order,$user);
  1227. if(! $bool){
  1228. DB::rollBack();
  1229. return [false, $msg];
  1230. }
  1231. }
  1232. }
  1233. if(! empty(self::$operation_order_reject[$data['opt_case']])){
  1234. $type = self::$operation_order_reject[$data['opt_case']];
  1235. (new OrderOperationService())->add([
  1236. 'order_number' => $order['order_number'],
  1237. 'msg' => OrderOperation::$type[$type],
  1238. 'type' => $type
  1239. ],$user);
  1240. }
  1241. DB::commit();
  1242. return [true, ''];
  1243. }catch (\Throwable $exception){
  1244. DB::rollBack();
  1245. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1246. }
  1247. }else{
  1248. //具体方法
  1249. $function = self::$opt_case[$data['opt_case']] ?? "";
  1250. $record = self::$record[$data['opt_case']] ?? "";
  1251. $create = self::$create[$data['opt_case']] ?? "";
  1252. try{
  1253. DB::beginTransaction();
  1254. list($bool,$msg) = $this->$function($data);
  1255. if(! $bool){
  1256. DB::rollBack();
  1257. return [false, $msg];
  1258. }
  1259. $order = $msg;
  1260. if($data['type'] == self::TYPE_ONE){
  1261. if($record) {
  1262. //流水
  1263. list($bool,$msg) = $this->$record($data, $order);
  1264. if(! $bool) {
  1265. DB::rollBack();
  1266. return [false, $msg];
  1267. }
  1268. if($msg != self::minus_one){
  1269. //库存
  1270. list($bool,$msg) = $this->changeInventory($data, $order, $user);
  1271. if(! $bool) {
  1272. DB::rollBack();
  1273. return [false, $msg];
  1274. }
  1275. }
  1276. }
  1277. if($create) {
  1278. list($bool,$msg) = $this->$create($order,$user);
  1279. if(! $bool) {
  1280. DB::rollBack();
  1281. return [false, $msg];
  1282. }
  1283. }
  1284. }
  1285. if(! empty(self::$operation_order[$data['opt_case']])){
  1286. $user = $data['user_data'] ?? [];
  1287. $type = self::$operation_order[$data['opt_case']];
  1288. (new OrderOperationService())->add([
  1289. 'order_number' => $order['order_number'],
  1290. 'msg' => OrderOperation::$type[$type],
  1291. 'type' => $type
  1292. ],$user);
  1293. }
  1294. DB::commit();
  1295. return [true, ''];
  1296. }catch (\Throwable $exception){
  1297. DB::rollBack();
  1298. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1299. }
  1300. }
  1301. }
  1302. //不需要走审批流 直接调用
  1303. public function createRecordAndInventoryMy($data = [],$user = [],$order = []){
  1304. if(! empty($data['type']) && $data['type'] == self::TYPE_THREE){
  1305. }else{
  1306. //具体方法
  1307. $record = self::$record[$data['opt_case']] ?? "";
  1308. $create = self::$create[$data['opt_case']] ?? "";
  1309. try{
  1310. DB::beginTransaction();
  1311. if($record) {
  1312. //流水
  1313. list($bool,$msg) = $this->$record($data, $order);
  1314. if(! $bool) {
  1315. DB::rollBack();
  1316. return [false, $msg];
  1317. }
  1318. if($msg != self::minus_one){
  1319. //库存
  1320. list($bool,$msg) = $this->changeInventory($data, $order, $user);
  1321. if(! $bool) {
  1322. DB::rollBack();
  1323. return [false, $msg];
  1324. }
  1325. }
  1326. }
  1327. if($create) {
  1328. list($bool,$msg) = $this->$create($order,$user);
  1329. if(! $bool) {
  1330. DB::rollBack();
  1331. return [false, $msg];
  1332. }
  1333. }
  1334. if(! empty(self::$operation_order[$data['opt_case']])){
  1335. $type = self::$operation_order[$data['opt_case']];
  1336. (new OrderOperationService())->add([
  1337. 'order_number' => $order['order_number'],
  1338. 'msg' => OrderOperation::$type[$type],
  1339. 'type' => $type
  1340. ],$user);
  1341. }
  1342. DB::commit();
  1343. return [true, ''];
  1344. }catch (\Throwable $exception){
  1345. DB::rollBack();
  1346. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1347. }
  1348. }
  1349. }
  1350. }