CheckService.php 61 KB

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