CheckService.php 89 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259
  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\Inventory;
  10. use App\Model\InventorySub;
  11. use App\Model\InvoiceOrder;
  12. use App\Model\InvoiceOrderInfo;
  13. use App\Model\OrderInventoryStock;
  14. use App\Model\OrderOperation;
  15. use App\Model\OutBoundOrder;
  16. use App\Model\OutBoundOrderInfo;
  17. use App\Model\PaymentReceipt;
  18. use App\Model\PaymentReceiptInfo;
  19. use App\Model\ProductAdjustment;
  20. use App\Model\ProductAdjustmentSub;
  21. use App\Model\ProductInventory;
  22. use App\Model\ProductInventorySet;
  23. use App\Model\PurchaseOrder;
  24. use App\Model\PurchaseOrderInfo;
  25. use App\Model\PurchaseOrderInfoForOutBound;
  26. use App\Model\PurchaseOrderInfoForOutboundInfo;
  27. use App\Model\PurchaseOrderSpecial;
  28. use App\Model\PurchaseOrderSpecialInfo;
  29. use App\Model\ReturnExchangeOrder;
  30. use App\Model\ReturnExchangeOrderForOutboundInfo;
  31. use App\Model\ReturnExchangeOrderProductInfo;
  32. use App\Model\SalesOrder;
  33. use App\Model\SalesOrderInfo;
  34. use App\Model\SalesOrderOtherFee;
  35. use App\Model\SalesOrderProductInfo;
  36. use App\Model\SeeRange;
  37. use App\Model\SportsBag;
  38. use App\Model\Storehouse;
  39. use App\Model\Supplier;
  40. use Illuminate\Support\Facades\DB;
  41. class CheckService extends Service
  42. {
  43. //特殊操作数
  44. const minus_one = -1;//跳出库存流水
  45. //审批操作对应的数值
  46. const one = 1; //收货
  47. const two = 2; //发货
  48. const three = 3; //采购单入库
  49. const four = 4; //合同公司完结
  50. const five = 5; //施工单
  51. const six = 6; //退换货单
  52. const seven = 7; //采购单确认
  53. const eight = 8; //合同确认
  54. const nine = 9; //合同客户完结
  55. const ten = 10; //收付款确认
  56. const eve = 11; //接受派单
  57. const twl = 12; //活动包
  58. const thi = 13; //虚拟采购单
  59. const fourteen = 14; //盘点
  60. const fifteen = 15; //放弃门店派单
  61. const sixteen = 16; //出库单审核
  62. const seventeen = 17; //产品金额调整单审核
  63. //中文对照
  64. public $map = [
  65. self::one => '收货单',
  66. self::two => '发货单',//确认后出库
  67. self::three => '采购单入库',//确认后入库
  68. self::four => '公司完结', // 安装件 合同完结
  69. self::five => '施工单',//确认后出库
  70. self::six => '退换货单',//确认后出库或出库入库
  71. self::seven => '采购单确认',
  72. self::eight => '合同确认',
  73. self::nine => '合同客户完结',
  74. self::ten => '收付款确认',
  75. self::eve => '接受门店派单',
  76. self::twl => '活动包',
  77. self::thi => '虚拟采购单',
  78. self::fourteen => '盘点单',
  79. self::fifteen => '放弃门店派单',
  80. self::sixteen => '出库单审核',
  81. self::seventeen => '产品金额调整单审核',
  82. ];
  83. //入库操作
  84. public static $in_opt = [
  85. self::three,
  86. ];
  87. //出库操作
  88. public static $out_opt = [
  89. self::two,
  90. self::five,
  91. self::sixteen,
  92. ];
  93. const TYPE_ONE = 1;//通过
  94. const TYPE_TWO = 2;//不通过
  95. const TYPE_THREE = 3;//通过后驳回
  96. //改为待审核状态 校验
  97. public static $opt_1case_check = [
  98. // self::five => 'checkConstruction',//施工单
  99. ];
  100. //改为待审核状态
  101. public static $opt_1case = [
  102. self::two => 'waitInvoice',//发货单
  103. // self::three => 'waitPurchase',//采购单 入库
  104. self::five => 'waitConstruction',//施工单
  105. self::six => 'waitReturnExchange',//退换货单
  106. self::seven => 'waitPurchaseConfirm', //采购单确认
  107. self::eight => 'waitSales', // 合同安装件 合同确认
  108. self::ten => 'waitPaymentReceipt', //收付款确认
  109. self::twl => 'waitSportsBag', //活动包确认
  110. self::thi => 'waitPurchaseSpecial', //虚拟采购单
  111. self::fourteen => 'waitInventory', //盘点单
  112. self::sixteen => 'waitOut', //出库单
  113. self::seventeen => 'waitProductAdjustment', //产品金额调整单
  114. ];
  115. public static $finished = [
  116. self::three => 'confirmPurchaseOrder',//采购单 入库
  117. self::four => 'settleSalesOrder', // 合同 安装件 合同公司完结
  118. self::nine => 'settleSalesOrderCustomer', // 合同 安装件 合同客户完结
  119. self::eve => 'settleSalesOrderConfirm', // 合同 安装件 合同接收
  120. self::fifteen => 'settleSalesOrderConfirmBack', // 合同 安装件 合同接收后放弃
  121. ];
  122. //单据操作
  123. public static $opt_case = [
  124. self::two => 'confirmInvoiceOrder',
  125. // self::three => 'confirmPurchaseOrder',
  126. self::five => 'confirmConstruction',
  127. self::six => 'confirmReturnExchangeOrder',
  128. self::seven => 'confirmPurchaseOrderState',
  129. self::eight => 'confirmSales', // 合同 安装件 合同确认
  130. self::ten => 'confirmPaymentReceipt', // 确认收付款单
  131. self::twl => 'confirmSportsBag', // 确认活动包
  132. self::thi => 'confirmPurchaseSpecial', //虚拟采购单
  133. self::fourteen => 'confirmInventory', //盘点单
  134. self::sixteen => 'confirmOut', //出库单
  135. self::seventeen => 'confirmProductAdjustment', //产品金额调整单
  136. ];
  137. //单据库存流水
  138. public static $record = [
  139. // self::two => 'recordInvoiceOrder',
  140. self::three => 'recordPurchaseOrder',
  141. // self::five => 'recordConstruction',
  142. self::six => 'recordReturnExchangeOrder',
  143. self::fourteen => 'recordInventory',
  144. self::sixteen => 'recordOut',
  145. self::seventeen => 'recordProductAdjustment',
  146. ];
  147. //自动生成
  148. public static $create = [
  149. self::seven => 'createPurchaseOrderSales', //分社合同生成
  150. self::four => 'createPurchaseOrder', // 派给分社的合同 公司完结以后生成虚拟采购单
  151. ];
  152. //自动生成的删除
  153. public static $create_del = [
  154. self::seven => 'delCreatePurchaseOrderSales', //分社合同生成(删除)
  155. // self::four => 'delCreatePurchaseOrder', // 派给分社的合同确认以后生成虚拟采购单
  156. ];
  157. //审核通过后 弃审
  158. public static $opt_case_reject = [
  159. self::four => 'reject_sales', // 合同
  160. // self::three => 'reject_purchase', //采购入库
  161. self::seven => 'reject_purchase_confirm', //采购确认驳回
  162. self::five => 'reject_construction',//施工单
  163. self::six => 'reject_return_exchange',//退换货
  164. self::ten => 'reject_payment_receipt',//收付款单
  165. self::twl => 'reject_sports_bag',//活动包
  166. self::thi => 'reject_purchase_special',//虚拟采购单
  167. ];
  168. //审核通过后 驳回 产生流水
  169. public static $reject_record = [
  170. // self::five => 'reject_record_construction', //施工单驳回
  171. self::three => 'reject_record_purchase', //采购
  172. self::six => 'reject_record_return_exchange',//退换货
  173. ];
  174. //旅程日志 同意
  175. public static $operation_order = [
  176. self::eight => OrderOperation::three, //合同确认
  177. self::two => OrderOperation::eight, //发货单确认
  178. self::six => OrderOperation::nine, //退换货审核
  179. self::five => OrderOperation::eve, //施工单
  180. self::seven => OrderOperation::thi,//采购单确认
  181. self::three => OrderOperation::fourteen,//采购单入库
  182. self::ten => OrderOperation::twenty_one,//收付款单
  183. self::twl => OrderOperation::twenty_seven,//活动包确认
  184. self::thi => OrderOperation::twenty_nine,//虚拟采购单
  185. self::sixteen => OrderOperation::thirty_three,//出库单
  186. ];
  187. //旅程日志 驳回
  188. public static $operation_order_reject = [
  189. self::four => OrderOperation::four, //合同弃审
  190. self::six => OrderOperation::ten, //退换货弃审
  191. self::five => OrderOperation::twl, //施工单弃审
  192. self::three => OrderOperation::fif,//采购单入库弃审
  193. self::seven => OrderOperation::twenty,//采购单确认弃审
  194. self::ten => OrderOperation::twenty_two,//收付款单
  195. self::twl => OrderOperation::twenty_eight,//活动包
  196. self::thi => OrderOperation::thirty,//虚拟采购单
  197. ];
  198. //校验 不需要了
  199. public function checkConstruction($data, $user){
  200. $order = Construction::where('del_time',0)
  201. ->where('order_number',$data['order_number'])
  202. ->first();
  203. if(empty($order)) return [false,'施工单不存在或已被删除'];
  204. $order = $order->toArray();
  205. //总社id
  206. $head = $user['head'] ?? [];
  207. $head = $head['id'] ?? 0;
  208. //分社自己的施工单 直接返回
  209. if($order['top_depart_id'] != $head) return [true, ''];
  210. //不校验库存
  211. if($user['is_check_stock'] == ProductInventorySet::type_two) return [true,''];
  212. //施工单产品
  213. $sub = ConstructionProductInfo::where('construction_id',$order['id'])
  214. ->where('del_time',0)
  215. ->get()->toArray();
  216. if(empty($sub)) return [false,'施工单产品不存在或已被删除'];
  217. $product_submit = $product_id = [];
  218. foreach ($sub as $value){
  219. $product_id[] = $value['product_id'];
  220. $key = $value['product_id'] . ',' . $value['storehouse_id'];
  221. if(isset($product_save[$key])){
  222. $product_submit[$key] += $value['number'];
  223. }else{
  224. $product_submit[$key] = $value['number'];
  225. }
  226. }
  227. //比较库存
  228. list($status,$msg) = (new ProductInventoryService())->compareStock($user,$product_id, $product_submit, []);
  229. if(! $status) return [false, $msg];
  230. //锁定库存
  231. // ProductInventoryService::changeLockNumber($user,$product_submit);
  232. return [true, ''];
  233. }
  234. //改为待审核---------------------------------
  235. public function waitInvoice($data){
  236. $model = InvoiceOrder::where('id',$data['id'])
  237. ->where('del_time',0)
  238. ->first();
  239. if(empty($model)) return [false, '发货单不存在或已被删除'];
  240. if($model->state != InvoiceOrder::STATE_ZERO) return [false, '请确认发货单状态,操作失败'];
  241. InvoiceOrder::where('del_time',0)->where('id',$data['id'])
  242. ->update(['state' => InvoiceOrder::STATE_ONE]);
  243. return [true, $model->toArray()];
  244. }
  245. public function waitPurchaseConfirm($data){
  246. $model = PurchaseOrder::where('id',$data['id'])
  247. ->where('del_time',0)
  248. ->first();
  249. if(empty($model)) return [false,'采购单不存在或已被删除'];
  250. if(! in_array($model->state, [PurchaseOrder::State_minus_one,PurchaseOrder::STATE_ZERO])) return [false, '请确认采购单状态,操作失败'];
  251. //待确认
  252. PurchaseOrder::where('id',$data['id'])->update(['state' => PurchaseOrder::STATE_ONE]);
  253. return [true, $model->toArray()];
  254. }
  255. public function waitPurchase($data){
  256. $model = PurchaseOrder::where('id',$data['id'])
  257. ->where('del_time',0)
  258. ->first();
  259. if(empty($model)) return [false, '采购订单不存在或已被删除'];
  260. if($model->state != PurchaseOrder::STATE_TWO) return [false, '请确认采购订单状态,操作失败'];
  261. //待入库
  262. PurchaseOrder::where('del_time',0)->where('id',$data['id'])
  263. ->update(['state' => PurchaseOrder::STATE_Three]);
  264. return [true, $model->toArray()];
  265. }
  266. public function waitPurchaseSpecial($data){
  267. $model = PurchaseOrderSpecial::where('id',$data['id'])
  268. ->where('del_time',0)
  269. ->first();
  270. if(empty($model)) return [false, '虚拟采购订单不存在或已被删除'];
  271. if($model->state > PurchaseOrderSpecial::STATE_ZERO) return [false, '请确认虚拟采购订单状态,操作失败'];
  272. //待入库
  273. PurchaseOrderSpecial::where('del_time',0)->where('id',$data['id'])
  274. ->update(['state' => PurchaseOrder::STATE_ONE]);
  275. return [true, $model->toArray()];
  276. }
  277. public function waitInventory($data){
  278. $model = Inventory::where('id',$data['id'])
  279. ->where('del_time',0)
  280. ->first();
  281. if(empty($model)) return [false, '盘点单不存在或已被删除'];
  282. if($model->state > Inventory::STATE_ZERO) return [false, '请确认盘点单状态,操作失败'];
  283. //待入库
  284. Inventory::where('del_time',0)->where('id',$data['id'])
  285. ->update(['state' => Inventory::STATE_ONE]);
  286. return [true, $model->toArray()];
  287. }
  288. public function waitOut($data){
  289. $model = OutBoundOrder::where('id',$data['id'])
  290. ->where('del_time',0)
  291. ->first();
  292. if(empty($model)) return [false, '出库单不存在或已被删除'];
  293. if($model->state > OutBoundOrder::STATE_ZERO) return [false, '请确认出库单状态,操作失败'];
  294. //待入库
  295. OutBoundOrder::where('del_time',0)->where('id',$data['id'])
  296. ->update(['state' => OutBoundOrder::STATE_ONE]);
  297. return [true, $model->toArray()];
  298. }
  299. public function waitProductAdjustment($data){
  300. $model = ProductAdjustment::where('id',$data['id'])
  301. ->where('del_time',0)
  302. ->first();
  303. if(empty($model)) return [false, '产品金额调整单不存在或已被删除'];
  304. if($model->state > ProductAdjustment::STATE_ZERO) return [false, '请确认产品金额调整单状态,操作失败'];
  305. //待审核
  306. ProductAdjustment::where('del_time',0)->where('id',$data['id'])
  307. ->update(['state' => ProductAdjustment::STATE_ONE]);
  308. return [true, $model->toArray()];
  309. }
  310. public function waitConstruction($data){
  311. $model = Construction::where('id',$data['id'])
  312. ->where('del_time',0)
  313. ->first();
  314. if(empty($model)) return [false, '施工单不存在或已被删除'];
  315. if(! in_array($model->state, [Construction::State_minus_one,Construction::STATE_ZERO])) return [false, '请确认施工单状态,操作失败'];
  316. //待确认
  317. Construction::where('del_time',0)->where('id',$data['id'])
  318. ->update(['state' => Construction::STATE_ONE]);
  319. return [true, $model->toArray()];
  320. }
  321. public function waitReturnExchange($data){
  322. $model = ReturnExchangeOrder::where('id',$data['id'])
  323. ->where('del_time',0)
  324. ->first();
  325. if(empty($model)) return [false, '退换货单不存在或已被删除'];
  326. if(! in_array($model->state, [ReturnExchangeOrder::State_minus_one,ReturnExchangeOrder::State_zero])) return [false, '请确认退换货单状态,操作失败'];
  327. //待确认
  328. ReturnExchangeOrder::where('del_time',0)->where('id',$data['id'])
  329. ->update(['state' => ReturnExchangeOrder::State_one]);
  330. return [true, $model->toArray()];
  331. }
  332. public function waitSales($data){
  333. $model = SalesOrder::where('id', $data['id'])
  334. ->where('del_time',0)
  335. ->first();
  336. if(empty($model)) return [false, '合同不存在或已被删除'];
  337. //安装件
  338. if(! in_array($model->state, [SalesOrder::State_minus_one,SalesOrder::State_zero])) return [false, '请确认合同状态,操作失败'];
  339. SalesOrder::where('del_time',0)->where('id',$data['id'])
  340. ->update(['state' => SalesOrder::State_one]);
  341. return [true, $model->toArray()];
  342. }
  343. public function waitPaymentReceipt($data){
  344. $model = PaymentReceipt::where('id', $data['id'])
  345. ->where('del_time',0)
  346. ->first();
  347. if(empty($model)) return [false, '收付款单不存在或已被删除'];
  348. if(! in_array($model->state, [PaymentReceipt::State_minus_one,PaymentReceipt::STATE_ZERO])) return [false, '请确认收付款单状态,操作失败'];
  349. PaymentReceipt::where('del_time',0)->where('id',$data['id'])
  350. ->update(['state' => PaymentReceipt::STATE_ONE]);
  351. return [true, $model->toArray()];
  352. }
  353. public function waitSportsBag($data){
  354. $model = SportsBag::where('id', $data['id'])
  355. ->where('del_time',0)
  356. ->first();
  357. if(empty($model)) return [false, '活动包不存在或已被删除'];
  358. if(! in_array($model->state, [SportsBag::State_minus_one,SportsBag::STATE_ZERO])) return [false, '请确认活动包状态,操作失败'];
  359. SportsBag::where('del_time',0)->where('id',$data['id'])
  360. ->update(['state' => SportsBag::STATE_ONE]);
  361. return [true, $model->toArray()];
  362. }
  363. //改为待审核---------------------------------
  364. //自动生成-----------------------------------
  365. //总社派给分社的合同 完成生成虚拟采购单
  366. public function createPurchaseOrder($order,$user){
  367. //快递件
  368. if($order['sales_order_type'] == SalesOrder::Order_type_two) return [true,''];
  369. //不是总公司的合同
  370. $head = $user['head'] ?? [];
  371. $head = $head['id'] ?? 0; //总社id
  372. if($head != $order['top_depart_id']) return [true, ''];
  373. $see = SeeRange::where('del_time',0)
  374. ->where('data_id',$order['id'])
  375. ->where('data_type',SeeRange::type_seven)
  376. ->where('type',SeeRange::data_three)
  377. ->first();
  378. if(empty($see)) return [false, '未找到指派分社信息'];
  379. $depart_id = $see->param_id;//指派的分社
  380. //总社指派给自己
  381. if($depart_id == $head) return [true, ''];
  382. //获取指派分社时候的金额
  383. $fee = SalesOrderOtherFee::where('del_time',0)
  384. ->where('sales_order_id',$order['id'])
  385. ->first();
  386. if(empty($fee)) return [false, '未找到指派分社时填写的金额'];
  387. $fee = $fee->toArray();
  388. $order_number = (new OrderNoService())->createOrderNumber(PurchaseOrderSpecial::prefix);
  389. $storehouse = Storehouse::where('depart_id',$head)->value('id');
  390. $product = SalesOrderProductInfo::where('del_time',0)
  391. ->where('sales_order_id',$order['id'])
  392. ->select('product_id','number','retail_price')
  393. ->get()->toArray();
  394. //退货的差异
  395. $returnExchange_map = [];
  396. $returnExchange = ReturnExchangeOrder::where('del_time',0)
  397. ->where('type',ReturnExchangeOrder::Order_type)
  398. ->where('data_id',$order['id'])
  399. ->select('id')
  400. ->get()->toArray();
  401. $return_product = ReturnExchangeOrderProductInfo::where('del_time',0)
  402. ->where('return_exchange_id',array_column($returnExchange,'id'))
  403. ->select('product_id','number')
  404. ->get()->toArray();
  405. foreach ($return_product as $value){
  406. if(isset($returnExchange_map[$value['product_id']])){
  407. $returnExchange_map[$value['product_id']] += $value['number'];
  408. }else{
  409. $returnExchange_map[$value['product_id']] = $value['number'];
  410. }
  411. }
  412. $product_map = $rate = [];
  413. $total = 0;
  414. foreach ($product as $key => $value){
  415. $return_number = 0;
  416. if(isset($returnExchange_map[$value['product_id']])) $return_number = $returnExchange_map[$value['product_id']];
  417. $number = $value['number'];
  418. if($return_number >= $value['number']) {
  419. unset($product[$key]);
  420. continue;
  421. }else{
  422. $number = bcsub($number,$return_number,2);
  423. $product[$key]['number'] = $number;
  424. }
  425. $total += $number * $value['retail_price'];
  426. if(isset($product_map[$value['product_id']])){
  427. $product_map[$value['product_id']] += $value['retail_price'] * $number;
  428. }else{
  429. $product_map[$value['product_id']] = $value['retail_price'] * $number;
  430. }
  431. }
  432. foreach ($product_map as $key => $value){
  433. $rate[$key] = bcdiv($value, $total, 2);
  434. }
  435. try {
  436. DB::beginTransaction();
  437. $model = new PurchaseOrderSpecial();
  438. $model->order_number = $order_number;
  439. $model->sales_order_id = $order['id'];
  440. $model->supplier = $depart_id;
  441. $model->type = $order['type'];
  442. $model->depart_id = $head;
  443. $model->top_depart_id = $head;
  444. $model->crt_id = Employee::SPECIAL_ADMIN;
  445. $model->purchase_id = Employee::SPECIAL_ADMIN;
  446. $model->purchase_total = $fee['other_fee_1'] ?? 0;
  447. $model->storehouse_id = $storehouse ?? 0;
  448. $model->save();
  449. if(empty($model->id)) return [false,'采购单主信息生成失败'];
  450. $purchase_order_id = $model->id;
  451. $insert = [];$product_total = 0;
  452. foreach ($product as $value){
  453. $rate_tmp = $rate[$value['product_id']] ?? 0;
  454. $price = bcdiv(bcmul($rate_tmp, $fee['other_fee_1'],2), $value['number'],2);
  455. $product_total += $price * $value['number'];
  456. $insert[] = [
  457. 'purchase_order_special_id' => $purchase_order_id,
  458. 'product_id' => $value['product_id'],
  459. 'order_number' => $order_number,
  460. 'number' => $value['number'],
  461. 'price' => $price,
  462. 'storehouse_id' => $storehouse,
  463. ];
  464. }
  465. PurchaseOrderSpecialInfo::insert($insert);
  466. PurchaseOrderSpecial::where('id',$purchase_order_id)->update(['total' => $product_total]);
  467. $insert_see[] = [
  468. 'data_id' => $purchase_order_id, // 虚拟采购单
  469. 'data_type' => SeeRange::type_ten,
  470. 'param_id' => $depart_id, //门店id
  471. 'type' => SeeRange::data_three,
  472. 'crt_time' => time(),
  473. ];
  474. if(! empty($insert_see)) SeeRange::insert($insert_see);
  475. DB::commit();
  476. }catch (\Throwable $exception){
  477. DB::rollBack();
  478. if (str_contains($exception->getMessage(), '1062') || str_contains($exception->getMessage(), 'Duplicate entry')) {
  479. return [false, '网络波动,请重新操作!'];
  480. }
  481. return [false, $exception->getMessage()];
  482. }
  483. return [true, ''];
  484. }
  485. //分社向总社采购 生成 分社订货合同
  486. public function createPurchaseOrderSales($order,$user){
  487. //没有供应商 不创建合同
  488. if(empty($order['supplier'])) return [true, ''];
  489. //总公司的采购单 不创建合同
  490. $head = $user['head'] ?? [];
  491. $head = $head['id'] ?? 0; //总社id
  492. if($head == $order['top_depart_id']) return [true, ''];
  493. //分社公司的采购单 不向总供应商采购 不创建合同
  494. $is_create = Supplier::where('id',$order['supplier'])->value('is_main');
  495. if(empty($is_create)) return [true, ''];
  496. // $customer_short_name = Depart::where('id',$order['top_depart_id'])->value('id') ?? "";
  497. $prefix = SalesOrder::$prefix[SalesOrder::Model_type_two];
  498. $order_number = OrderNoService::createSalesOrderNumber($prefix);
  499. $product = PurchaseOrderInfo::where('del_time',0)
  500. ->where('purchase_order_id',$order['id'])
  501. ->get()->toArray();
  502. if(empty($product)) return [false, '采购订单产品数据不能为空'];
  503. try{
  504. DB::beginTransaction();
  505. $time = time();
  506. $model = new SalesOrder();
  507. $model->model_type = SalesOrder::Model_type_two;
  508. $model->sales_order_type = SalesOrder::Order_type_two;
  509. $model->customer_id = Customer::special_id;
  510. $model->order_number = $order_number;
  511. $model->crt_id = $order['crt_id'];
  512. $model->depart_id = $head;
  513. $model->top_depart_id = $head;
  514. $model->other_fee = $order['other_fee'];
  515. $model->discount_fee = $order['discount_fee'];
  516. $model->contract_fee = $order['purchase_total'];
  517. $model->contact_order_no = $order['order_number'];
  518. $model->sign_time = $time;
  519. $model->save();
  520. $sales_order_id = $model->id;
  521. //产品字典
  522. $product_map = (new ProductService())->getProductDetail(array_column($product,'product_id'));
  523. $insert = [];
  524. $product_total = 0;
  525. foreach ($product as $value){
  526. $tmp = $product_map[$value['product_id']] ?? [];
  527. $product_total += $value['price'] * $value['number'];
  528. $insert[] = [
  529. 'sales_order_id' => $sales_order_id,
  530. 'product_id' => $value['product_id'],
  531. 'number' => $value['number'],
  532. 'basic_type_id' => $value['basic_type_id'],
  533. 'price' => $value['price'],
  534. 'cost' => $tmp['cost'] ?? 0,
  535. 'retail_price' => $tmp['retail_price'] ?? 0,
  536. 'final_amount' => $value['price'] * $value['number'],
  537. ];
  538. }
  539. $bool = SalesOrderProductInfo::insert($insert);
  540. if(! $bool) return [false,'合同生成失败!'];
  541. //反写数据
  542. $tmp = $product_total + $order['other_fee'];
  543. $tmp = $tmp > 0 ? $tmp : 1;
  544. $rate = ($product_total + $order['other_fee'] - $order['discount_fee']) / $tmp;
  545. SalesOrder::where('id',$sales_order_id)->update([
  546. 'product_total' => $product_total,
  547. 'rate' => $rate
  548. ]);
  549. //生成付款单
  550. $model = new PaymentReceipt();
  551. $model->order_number = (new OrderNoService())->createOrderNumber(PaymentReceipt::prefix);
  552. $model->data_type = PaymentReceipt::data_type_one;
  553. $model->type = PaymentReceipt::type_one;
  554. $model->crt_id = $user['id'];
  555. $model->depart_id = $head;
  556. $model->top_depart_id = $head;
  557. $model->save();
  558. $insert = [];
  559. $insert[] = [
  560. 'payment_receipt_id' => $model->id,
  561. 'data_type' => PaymentReceipt::type_one,
  562. 'data_order_no' => $order_number,
  563. 'data_order_type' => PaymentReceipt::data_type_one,
  564. 'amount' => $order['purchase_total'],
  565. 'type' => PaymentReceiptInfo::type_three,
  566. 'crt_time' => $time,
  567. ];
  568. PaymentReceiptInfo::insert($insert);
  569. DB::commit();
  570. }catch (\Throwable $exception){
  571. DB::rollBack();
  572. if (str_contains($exception->getMessage(), '1062') || str_contains($exception->getMessage(), 'Duplicate entry')) {
  573. return [false, '网络波动,请重新操作!'];
  574. }
  575. return [false ,$exception->getMessage()];
  576. }
  577. return [true,''];
  578. }
  579. //自动生成-----------------------------------
  580. //自动生成删除
  581. //分社订货合同删除
  582. public function delCreatePurchaseOrderSales($data, $order){
  583. $sale_order = SalesOrder::where('del_time',0)
  584. ->where('contact_order_no',$order['order_number'])
  585. ->select('id','order_number')
  586. ->get()->toArray();
  587. if(empty($sale_order)) return [true,''];
  588. foreach ($sale_order as $value){
  589. list($status, $msg) = (new SalesOrderService())->salesOrderDel(['id' => $value['id']]);
  590. if(! $status) return [false,$msg];
  591. list($status, $msg) = (new PaymentReceiptService())->customerDel(['id' => $value['id']]);
  592. if(! $status) return [false,$msg];
  593. }
  594. return [true, ''];
  595. }
  596. //自动生成删除
  597. public function confirmSportsBag($data){
  598. $model = SportsBag::where('order_number',$data['order_number'])
  599. ->where('del_time',0)
  600. ->first();
  601. if(empty($model)) return [false, '活动包不存在或已被删除'];
  602. if($model->state != SportsBag::STATE_ONE) return [false, '请确认活动包状态,操作失败'];
  603. if($data['type'] == self::TYPE_ONE){
  604. //通过
  605. $model->state = SportsBag::STATE_TWO;
  606. $model->save();
  607. }else{
  608. //驳回
  609. $model->state = SportsBag::State_minus_one;
  610. $model->save();
  611. }
  612. return [true, $model->toArray()];
  613. }
  614. public function confirmPaymentReceipt($data){
  615. $model = PaymentReceipt::where('order_number',$data['order_number'])
  616. ->where('del_time',0)
  617. ->first();
  618. if(empty($model)) return [false, '收付款单不存在或已被删除'];
  619. if($model->state != PaymentReceipt::STATE_ONE) return [false, '请确认收付款单状态,操作失败'];
  620. if($data['type'] == self::TYPE_ONE){
  621. //通过
  622. $model->state = PaymentReceipt::STATE_TWO;
  623. $model->save();
  624. }else{
  625. //驳回
  626. $model->state = PaymentReceipt::State_minus_one;
  627. $model->save();
  628. }
  629. return [true, $model->toArray()];
  630. }
  631. public function confirmInvoiceOrder($data){
  632. $model = InvoiceOrder::where('order_number',$data['order_number'])
  633. ->where('del_time',0)
  634. ->first();
  635. if(empty($model)) return [false, '发货单不存在或已被删除'];
  636. if($model->state != InvoiceOrder::STATE_ONE) return [false, '请确认发货单状态,操作失败'];
  637. $send_data = [];
  638. if($data['type'] == self::TYPE_ONE){
  639. //通过
  640. $model->state = InvoiceOrder::STATE_TWO;
  641. $model->save();
  642. $sale = SalesOrder::where('id',$model->sales_order_id)->first();
  643. if($sale['sales_order_type'] == SalesOrder::Order_type_one){
  644. //安装件更新发货状态
  645. SalesOrder::where('id',$model->sales_order_id)
  646. ->update(['invoice_state' => SalesOrder::invoice_one]);
  647. }else{
  648. //快递件更新 单据状态 发货状态
  649. SalesOrder::where('id',$model->sales_order_id)
  650. ->update([
  651. 'state' => SalesOrder::State2_one,
  652. 'invoice_state' => SalesOrder::invoice_one
  653. ]);
  654. }
  655. //分社采购单更新发货状态
  656. if(! empty($sale->contact_order_no)) {
  657. $purchase = PurchaseOrder::where('order_number',$sale->contact_order_no)->where('del_time', 0)->first();
  658. if(! empty($purchase)){
  659. $purchase = $purchase->toArray();
  660. if(in_array($purchase['order_type'], [PurchaseOrder::Order_type_three, PurchaseOrder::Order_type_four])) {
  661. //提醒创建人
  662. $emp_tmp = Employee::where('id', $purchase['crt_id'])->value('emp_name');
  663. $send_data[] = [
  664. 'employee_id' => $purchase['crt_id'],
  665. 'type' => 2,
  666. 'state' => 0,
  667. 'menu_id' => 45,
  668. 'order_number' => $purchase['order_number'],
  669. 'tmp_data' => [
  670. $purchase['order_number'],
  671. "分社采购单",
  672. '已发货',
  673. $emp_tmp,
  674. date('Y-m-d H:i:s'),
  675. ],
  676. ];
  677. }
  678. }
  679. PurchaseOrder::where('order_number',$sale->contact_order_no)->update(['invoice_state' => PurchaseOrder::invoice_state_one]);
  680. }
  681. }else{
  682. //驳回
  683. $model->state = InvoiceOrder::STATE_ZERO;
  684. $model->save();
  685. }
  686. (new OaService())->sendWxOaCheckMessage($send_data);
  687. return [true, $model->toArray()];
  688. }
  689. public function recordInvoiceOrder($data, $order){
  690. $result = InvoiceOrderInfo::where('del_time',0)
  691. ->where('order_number',$order['order_number'])
  692. ->get()->toArray();
  693. if(empty($result)) return [false,'发货单产品信息不存在或已被删除'];
  694. $insert = [];
  695. $time = time();
  696. foreach ($result as $value){
  697. $key = $value['product_id'] . $value['storehouse_id'];
  698. if(isset($insert[$key])){
  699. $insert[$key]['number'] += -($value['number']);
  700. }else{
  701. $insert[$key] = [
  702. 'product_id' => $value['product_id'],
  703. 'number' => -($value['number']),
  704. 'order_type' => InvoiceOrder::prefix,
  705. 'order_number' => $order['order_number'],
  706. 'crt_time' => $time,
  707. 'storehouse_id' => $value['storehouse_id'],
  708. 'depart_id' => $order['depart_id'],
  709. 'top_depart_id' => $order['top_depart_id'],
  710. 'price' => $value['price'],
  711. ];
  712. }
  713. }
  714. $insert = array_values($insert);
  715. $bool = InOutRecord::insert($insert);
  716. if(! $bool) return [false,'流水写入失败'];
  717. return [true,''];
  718. }
  719. public function confirmPurchaseOrderState($data){
  720. $model = PurchaseOrder::where('order_number',$data['order_number'])
  721. ->where('del_time',0)
  722. ->first();
  723. if(empty($model)) return [false,'采购单不存在或已被删除'];
  724. if($model->state != PurchaseOrder::STATE_ONE) return [false,'请确认采购单状态,操作失败'];
  725. if($data['type'] == self::TYPE_ONE){
  726. $model->state = PurchaseOrder::STATE_TWO;
  727. $model->save();
  728. }else{
  729. //驳回
  730. $model->state = PurchaseOrder::State_minus_one;
  731. $model->save();
  732. }
  733. return [true, $model->toArray()];
  734. }
  735. public function confirmPurchaseOrder($data,$user){
  736. $model = PurchaseOrder::where('order_number',$data['order_number'])
  737. ->where('del_time',0)
  738. ->first();
  739. if(empty($model)) return [false, '采购订单不存在或已被删除'];
  740. if($model->state != PurchaseOrder::STATE_TWO) return [false, '请确认采购订单状态,操作失败'];
  741. $model->state = PurchaseOrder::STATE_Four;
  742. $model->save();
  743. return [true, $model->toArray()];
  744. }
  745. public function recordPurchaseOrder($data, $order){
  746. $result = PurchaseOrderInfo::where('del_time',0)
  747. ->where('order_number',$order['order_number'])
  748. ->get()->toArray();
  749. if(empty($result)) return [false,'采购单产品信息不存在或已被删除'];
  750. $insert = [];
  751. $time = time();
  752. foreach ($result as $value){
  753. $key = $value['product_id'] . $value['storehouse_id'];
  754. if(isset($insert[$key])){
  755. $insert[$key]['number'] += $value['number'];
  756. }else{
  757. $insert[$key] = [
  758. 'product_id' => $value['product_id'],
  759. 'number' => $value['number'],
  760. 'order_type' => PurchaseOrder::prefix,
  761. 'order_number' => $order['order_number'],
  762. 'crt_time' => $time,
  763. 'storehouse_id' => $value['storehouse_id'],
  764. 'depart_id' => $order['depart_id'],
  765. 'top_depart_id' => $order['top_depart_id'],
  766. 'price' => $value['price'],
  767. ];
  768. }
  769. }
  770. $insert = array_values($insert);
  771. $bool = InOutRecord::insert($insert);
  772. if(! $bool) return [false,'流水写入失败'];
  773. return [true,''];
  774. }
  775. public function confirmPurchaseSpecial($data){
  776. $model = PurchaseOrderSpecial::where('order_number',$data['order_number'])
  777. ->where('del_time',0)
  778. ->first();
  779. if(empty($model)) return [false,'虚拟采购订单不存在或已被删除'];
  780. if($model->state != PurchaseOrderSpecial::STATE_ONE) return [false,'请确认虚拟采购订单状态,操作失败'];
  781. if($data['type'] == self::TYPE_ONE){
  782. $model->state = PurchaseOrderSpecial::STATE_TWO;
  783. $model->save();
  784. }else{
  785. //驳回
  786. $model->state = PurchaseOrderSpecial::State_minus_one;
  787. $model->save();
  788. }
  789. return [true, $model->toArray()];
  790. }
  791. public function confirmConstruction($data){
  792. $model = Construction::where('order_number',$data['order_number'])
  793. ->where('del_time',0)
  794. ->first();
  795. if(empty($model)) return [false, '施工单不存在或已被删除'];
  796. if($model->state != Construction::STATE_ONE) return [false, '请确认施工单状态,操作失败'];
  797. if($data['type'] == self::TYPE_ONE){
  798. $model->state = Construction::STATE_TWO;
  799. $model->save();
  800. //已下施工
  801. SalesOrder::where('id',$model->sales_order_id)->update(['state' => SalesOrder::State_five]);
  802. }else{
  803. //驳回
  804. $model->state = Construction::State_minus_one;
  805. $model->save();
  806. }
  807. return [true, $model->toArray()];
  808. }
  809. public function recordConstruction($data, $order){
  810. //仅施工不需要库存流水
  811. if($order['model_type'] == Construction::Model_type_two) return [true, self::minus_one];
  812. $result = ConstructionProductInfo::where('del_time',0)
  813. ->where('construction_id',$order['id'])
  814. ->get()->toArray();
  815. if(empty($result)) return [false,'施工单产品信息不存在或已被删除'];
  816. $insert = [];
  817. $time = time();
  818. foreach ($result as $value){
  819. $key = $value['product_id'] . $value['storehouse_id'];
  820. if(isset($insert[$key])){
  821. $insert[$key]['number'] += -($value['number']);
  822. }else{
  823. $insert[$key] = [
  824. 'product_id' => $value['product_id'],
  825. 'number' => -($value['number']),
  826. 'order_type' => Construction::$prefix[$order['model_type']] ?? '',
  827. 'order_number' => $order['order_number'],
  828. 'crt_time' => $time,
  829. 'storehouse_id' => $value['storehouse_id'],
  830. 'depart_id' => $order['depart_id'],
  831. 'top_depart_id' => $order['top_depart_id'],
  832. 'price' => $value['price'],
  833. ];
  834. }
  835. }
  836. $insert = array_values($insert);
  837. $bool = InOutRecord::insert($insert);
  838. if(! $bool) return [false,'流水写入失败'];
  839. return [true,''];
  840. }
  841. public function confirmReturnExchangeOrder($data){
  842. $model = ReturnExchangeOrder::where('order_number',$data['order_number'])
  843. ->where('del_time',0)
  844. ->first();
  845. if(empty($model)) return [false, '退换货单不存在或已被删除'];
  846. if($model->state != ReturnExchangeOrder::State_one) return [false, '请确认退换货单状态,操作失败'];
  847. if($data['type'] == self::TYPE_ONE){
  848. $model->state = ReturnExchangeOrder::State_two;
  849. $model->save();
  850. // if($model->data_type == ReturnExchangeOrder::Order_type){
  851. // SalesOrder::where('id', $model->data_id)->update([
  852. // 'state' => SalesOrder::State_six
  853. // ]);
  854. // }
  855. }else{
  856. //驳回
  857. $model->state = ReturnExchangeOrder::State_minus_one;
  858. $model->save();
  859. }
  860. return [true, $model->toArray()];
  861. }
  862. public function recordReturnExchangeOrder($data, $order){
  863. if($order['model_type'] == ReturnExchangeOrder::Model_type_three) return [true, self::minus_one];
  864. // if($order['type'] == ReturnExchangeOrder::Order_type){
  865. // //快递件不记录流水
  866. // $sales_order_type = SalesOrder::where('id',$order['data_id'])->value('sales_order_type');
  867. // if($sales_order_type == SalesOrder::Order_type_two) return [true, self::minus_one];
  868. // }
  869. //合同 退货
  870. $map = $outbound = [];
  871. if($order['type'] == ReturnExchangeOrder::Order_type){
  872. //查找 出库数据的产品
  873. $product = OutBoundOrderInfo::where('del_time',0)
  874. ->where('data_id', $order['data_id'])
  875. ->where('type', OutBoundOrder::out_type_one)
  876. ->whereColumn('number','>','return_number')
  877. ->select('id','product_id','number','return_number','out_bound_id')
  878. ->get()->toArray();
  879. foreach($product as $value){
  880. $map[$value['product_id']][] = $value;
  881. }
  882. //采购占用数量
  883. $purchase = PurchaseOrderInfoForOutBound::where('del_time',0)
  884. ->whereIn('data_id', array_unique(array_column($product,'out_bound_id')))
  885. ->where('type',PurchaseOrderInfoForOutBound::type_one)
  886. ->where('from_order_type',PurchaseOrderInfoForOutBound::from_type_zero)
  887. ->where('is_use',PurchaseOrderInfoForOutBound::is_use)
  888. ->whereColumn('number','>','return_number')
  889. ->get()->toArray();
  890. foreach ($purchase as $value){
  891. $key = $value['data_id'] . $value['product_id'];
  892. $num = bcsub($value['number'],$value['return_number'],2);
  893. if(isset($outbound[$key])){
  894. $tmp = bcadd($num, $outbound[$key]['number'],2);
  895. $outbound[$key]['number'] = $tmp;
  896. }else{
  897. $outbound[$key] = [
  898. 'id' => $value['id'],
  899. 'number' => $num,
  900. ];
  901. }
  902. }
  903. }
  904. $result = ReturnExchangeOrderProductInfo::where('del_time',0)
  905. ->where('return_exchange_id',$order['id'])
  906. ->get()->toArray();
  907. if(empty($result)) return [false,'退换货单产品信息不存在或已被删除'];
  908. $insert = $update = $insert2 = $update2 = [];
  909. $time = time();
  910. foreach ($result as $value){
  911. $key = $value['product_id'] . $value['storehouse_id'];
  912. $prefix = ReturnExchangeOrder::$prefix[$value['return_or_exchange']] ?? '';
  913. if($value['return_or_exchange'] == ReturnExchangeOrderProductInfo::type_one){
  914. //退货
  915. if($order['type'] == ReturnExchangeOrder::Order_type){
  916. $number = 0;
  917. //合同出库数量
  918. $out_array = $map[$value['product_id']] ?? [];
  919. if(empty($out_array)){
  920. //未出库 这个退货不需要加回来 不需要流水
  921. continue;
  922. } else{
  923. foreach ($out_array as $out){
  924. if($value['number'] <= 0) continue;
  925. //剩余能退数量
  926. $out_number = bcsub($out['number'], $out['return_number'],2);
  927. if($out_number >= $value['number']) {
  928. $number = bcadd($value['number'], $number,2);
  929. $t = $value['number'];
  930. $value['number'] = 0;
  931. }else{
  932. $number = bcadd($out_number, $number,2);
  933. $value['number'] = bcsub($value['number'], $out_number,2);
  934. $t = $out_number;
  935. }
  936. //更新数据
  937. $update[] = [
  938. 'id' => $out['id'],
  939. 'return_number' => bcadd($out['return_number'], $t,2),
  940. ];
  941. $insert2[] = [
  942. 'order_number' => $order['order_number'],
  943. 'out_bound_order_info_id' => $out['id'],
  944. 'number' => $t,
  945. 'crt_time' => $time
  946. ];
  947. $out_key = $out['out_bound_id'] . $value['product_id'];
  948. if(isset($outbound[$out_key])){
  949. $num = $outbound[$out_key]['number'];
  950. $id = $outbound[$out_key]['id'];
  951. if($t > $num){
  952. $update2_num = $num;
  953. }else{
  954. $update2_num = $t;
  955. }
  956. if(isset($update2[$id])){
  957. $update2[$id] = bcadd($update2_num, $update2[$id],2);
  958. }else{
  959. $update2[$id] = $update2_num;
  960. }
  961. }
  962. }
  963. }
  964. }else{
  965. // 采购
  966. $number = -($value['number']);
  967. }
  968. if(isset($insert[$key])){
  969. $insert[$key]['number'] += $number;
  970. }else{
  971. $insert[$key] = [
  972. 'product_id' => $value['product_id'],
  973. 'number' => $number,
  974. 'order_type' => $prefix,
  975. 'order_number' => $order['order_number'],
  976. 'crt_time' => $time,
  977. 'storehouse_id' => $value['storehouse_id'],
  978. 'depart_id' => $order['depart_id'],
  979. 'top_depart_id' => $order['top_depart_id'],
  980. 'price' => $value['return_exchange_price'],
  981. ];
  982. }
  983. }
  984. }
  985. $insert = array_values($insert);
  986. if(empty($insert)) return [true, self::minus_one];
  987. $bool = InOutRecord::insert($insert);
  988. if(! $bool) return [false,'流水写入失败'];
  989. if(! empty($insert2)) ReturnExchangeOrderForOutboundInfo::insert($insert2);
  990. if(! empty($update)){
  991. foreach ($update as $value){
  992. OutBoundOrderInfo::where('id', $value['id'])
  993. ->update(['return_number' => $value['return_number']]);
  994. }
  995. }
  996. if(! empty($update2)){
  997. foreach ($update2 as $key => $value){
  998. $insert3[] = [
  999. 'order_number' => $order['order_number'],
  1000. 'purchase_order_info_id' => $key,
  1001. 'number' => $value,
  1002. 'crt_time' => $time
  1003. ];
  1004. PurchaseOrderInfoForOutBound::where('id', $key)
  1005. ->lockForUpdate()
  1006. ->update([
  1007. 'return_number' => DB::raw('return_number + ('. $value . ')'),
  1008. ]);
  1009. }
  1010. if(! empty($insert3)) PurchaseOrderInfoForOutboundInfo::insert($insert3);
  1011. }
  1012. return [true,''];
  1013. }
  1014. public function confirmInventory($data){
  1015. $model = Inventory::where('order_number',$data['order_number'])
  1016. ->where('del_time',0)
  1017. ->first();
  1018. if(empty($model)) return [false,'盘点单不存在或已被删除'];
  1019. if($model->state != Inventory::STATE_ONE) return [false,'请确认盘点单状态,操作失败'];
  1020. if($data['type'] == self::TYPE_ONE){
  1021. $model->state = Inventory::STATE_TWO;
  1022. $model->save();
  1023. }else{
  1024. //驳回
  1025. $model->state = Inventory::State_minus_one;
  1026. $model->save();
  1027. }
  1028. return [true, $model->toArray()];
  1029. }
  1030. public function confirmOut($data){
  1031. $model = OutBoundOrder::where('order_number',$data['order_number'])
  1032. ->where('del_time',0)
  1033. ->first();
  1034. if(empty($model)) return [false,'出库单不存在或已被删除'];
  1035. if($model->state != OutBoundOrder::STATE_ONE) return [false,'请确认出库单状态,操作失败'];
  1036. if($data['type'] == self::TYPE_ONE){
  1037. $model->state = OutBoundOrder::STATE_TWO;
  1038. $model->save();
  1039. }else{
  1040. //驳回
  1041. $model->state = OutBoundOrder::State_minus_one;
  1042. $model->save();
  1043. }
  1044. return [true, $model->toArray()];
  1045. }
  1046. public function confirmProductAdjustment($data){
  1047. $model = ProductAdjustment::where('order_number',$data['order_number'])
  1048. ->where('del_time',0)
  1049. ->first();
  1050. if(empty($model)) return [false,'产品金额调整单不存在或已被删除'];
  1051. if($model->state != ProductAdjustment::STATE_ONE) return [false,'请确认产品金额调整单状态,操作失败'];
  1052. if($data['type'] == self::TYPE_ONE){
  1053. $model->state = ProductAdjustment::STATE_TWO;
  1054. $model->save();
  1055. }else{
  1056. //驳回
  1057. $model->state = ProductAdjustment::State_minus_one;
  1058. $model->save();
  1059. }
  1060. return [true, $model->toArray()];
  1061. }
  1062. public function recordInventory($data, $order){
  1063. $result = InventorySub::where('del_time',0)
  1064. ->where('inventory_id',$order['id'])
  1065. ->get()->toArray();
  1066. if(empty($result)) return [false,'盘点单明细信息不存在或已被删除'];
  1067. $prefix = Inventory::prefix;
  1068. $insert = [];
  1069. $time = time();
  1070. foreach ($result as $value){
  1071. $key = $value['product_id'] . $value['storehouse_id'];
  1072. $number = $value['final_num'];
  1073. if(isset($insert[$key])){
  1074. $insert[$key]['number'] += $number;
  1075. }else{
  1076. $insert[$key] = [
  1077. 'product_id' => $value['product_id'],
  1078. 'number' => $number,
  1079. 'order_type' => $prefix,
  1080. 'order_number' => $order['order_number'],
  1081. 'crt_time' => $time,
  1082. 'storehouse_id' => $value['storehouse_id'],
  1083. 'depart_id' => $order['depart_id'],
  1084. 'top_depart_id' => $order['top_depart_id'],
  1085. 'price' => $value['price'],
  1086. ];
  1087. }
  1088. }
  1089. $bool = InOutRecord::insert($insert);
  1090. if(! $bool) return [false,'流水写入失败'];
  1091. return [true,''];
  1092. }
  1093. public function recordOut($data, $order){
  1094. $result = PurchaseOrderInfoForOutBound::where('del_time',0)
  1095. ->where('data_id',$order['id'])
  1096. ->where('type',PurchaseOrderInfoForOutBound::type_one)
  1097. ->where('is_use',PurchaseOrderInfoForOutBound::is_not_use)
  1098. ->get()->toArray();
  1099. if(empty($result)) return [false,'出库单明细信息不存在或已被删除'];
  1100. $prefix = OutBoundOrder::prefix;
  1101. $insert = $tmp = [];
  1102. $time = time();
  1103. foreach ($result as $value){
  1104. $key = $value['product_id'] . $value['storehouse_id'];
  1105. $number = -($value['number']);
  1106. if(isset($insert[$key])){
  1107. $insert[$key]['number'] += $number;
  1108. }else{
  1109. $insert[$key] = [
  1110. 'product_id' => $value['product_id'],
  1111. 'number' => $number,
  1112. 'order_type' => $prefix,
  1113. 'order_number' => $order['order_number'],
  1114. 'crt_time' => $time,
  1115. 'storehouse_id' => $value['storehouse_id'],
  1116. 'depart_id' => $order['depart_id'],
  1117. 'top_depart_id' => $order['top_depart_id'],
  1118. 'price' => $value['price'],
  1119. ];
  1120. }
  1121. if(empty($value['purchase_order_id'])){
  1122. //没采购或盘点入库信息 则加入一条记录平流水
  1123. $tmp[] = [
  1124. 'product_id' => $value['product_id'],
  1125. 'number' => $value['number'],
  1126. 'order_type' => PurchaseOrderInfoForOutBound::prefix,
  1127. 'order_number' => $order['order_number'],
  1128. 'crt_time' => $time,
  1129. 'storehouse_id' => $value['storehouse_id'],
  1130. 'depart_id' => $order['depart_id'],
  1131. 'top_depart_id' => $order['top_depart_id'],
  1132. 'price' => $value['price'],
  1133. ];
  1134. }
  1135. }
  1136. $insert_final = array_merge_recursive(array_values($insert),$tmp);
  1137. $bool = InOutRecord::insert($insert_final);
  1138. if(! $bool) return [false, '流水写入失败'];
  1139. //更新采购出库占用
  1140. PurchaseOrderInfoForOutBound::where('del_time',0)
  1141. ->where('data_id',$order['id'])
  1142. ->where('type',PurchaseOrderInfoForOutBound::type_one)
  1143. ->where('is_use',PurchaseOrderInfoForOutBound::is_not_use)
  1144. ->update(['is_use' => PurchaseOrderInfoForOutBound::is_use]);
  1145. return [true, ''];
  1146. }
  1147. public function recordProductAdjustment($data, $order){
  1148. $result = ProductAdjustmentSub::where('del_time',0)
  1149. ->where('product_adjustment_id', $order['id'])
  1150. ->select('product_id','storehouse_id','final_amount')
  1151. ->get()->toArray();
  1152. if(empty($result)) return [false, "产品调整单明细数据不能为空"];
  1153. $time = time();
  1154. $prefix = ProductAdjustment::prefix;
  1155. $insert = [];
  1156. foreach ($result as $value){
  1157. $key = $value['product_id'] . $value['storehouse_id'];
  1158. if(isset($insert[$key])){
  1159. $price = bcadd($insert[$key]['price'], $value['final_amount'],2);
  1160. $insert[$key]['price'] = $price;
  1161. }else{
  1162. $insert[$key] = [
  1163. 'product_id' => $value['product_id'],
  1164. 'number' => 0,
  1165. 'order_type' => $prefix,
  1166. 'order_number' => $order['order_number'],
  1167. 'crt_time' => $time,
  1168. 'storehouse_id' => $value['storehouse_id'],
  1169. 'depart_id' => $order['depart_id'],
  1170. 'top_depart_id' => $order['top_depart_id'],
  1171. 'price' => $value['final_amount'],
  1172. ];
  1173. }
  1174. }
  1175. $bool = InOutRecord::insert($insert);
  1176. if(! $bool) return [false, '流水写入失败'];
  1177. return [true, self::minus_one];
  1178. }
  1179. public function settleSalesOrder($data,$user){
  1180. $model = SalesOrder::where('order_number', $data['order_number'])
  1181. ->where('del_time',0)
  1182. ->first();
  1183. if(empty($model)) return [false, '合同不存在或已被删除'];
  1184. //安装件
  1185. if($model->state <= SalesOrder::State_four || $model->state >= SalesOrder::State_seven) return [false, '请确认合同状态,操作失败'];
  1186. SalesOrder::where('del_time',0)->where('order_number',$data['order_number'])
  1187. ->update(['state' => SalesOrder::State_seven]);
  1188. $time = time();
  1189. $insert = [];
  1190. $new = [];
  1191. if(! empty($data['img'])){
  1192. foreach ($data['img'] as $value){
  1193. $insert[] = [
  1194. 'sales_order_id' => $model->id,
  1195. 'data_id' => 0,
  1196. 'type' => SalesOrderInfo::type_seven,
  1197. 'file' => $value,
  1198. 'crt_time' => $time,
  1199. ];
  1200. $new[] = $value;
  1201. }
  1202. }
  1203. if(! empty($data['mark'])){
  1204. $insert[] = [
  1205. 'sales_order_id' => $model->id,
  1206. 'data_id' => $user['id'],
  1207. 'type' => SalesOrderInfo::type_eight,
  1208. 'file' => $data['mark'],
  1209. 'crt_time' => $time,
  1210. ];
  1211. }
  1212. if(! empty($insert)) SalesOrderInfo::insert($insert);
  1213. return [true, ['file' => $new, 'order' => $model->toArray()]];
  1214. }
  1215. public function settleSalesOrderCustomer($data,$user){
  1216. $model = SalesOrder::where('order_number', $data['order_number'])
  1217. ->where('del_time',0)
  1218. ->first();
  1219. if(empty($model)) return [false, '合同不存在或已被删除'];
  1220. if(empty($data['img'])) return [false,'图片不能为空'];
  1221. //安装件
  1222. if($model->state != SalesOrder::State_seven) return [false, '请确认合同状态,操作失败'];
  1223. SalesOrder::where('del_time',0)->where('order_number',$data['order_number'])
  1224. ->update(['state' => SalesOrder::State_eight]);
  1225. SalesOrderInfo::insert([
  1226. 'sales_order_id' => $model->id,
  1227. 'type' => SalesOrderInfo::type_six,
  1228. 'file' => $data['img'],
  1229. 'crt_time' => time(),
  1230. ]);
  1231. return [true, $model->toArray()];
  1232. }
  1233. public function settleSalesOrderConfirm($data,$user){
  1234. $model = SalesOrder::where('order_number', $data['order_number'])
  1235. ->where('del_time',0)
  1236. ->first();
  1237. if(empty($model)) return [false, '合同不存在或已被删除'];
  1238. //安装件
  1239. if($model->state != SalesOrder::State_four) return [false, '请确认合同状态,操作失败'];
  1240. $model->is_confirm = 1;
  1241. $model->save();
  1242. $depart = SeeRange::where('del_time',0)
  1243. ->where('data_id', $model->id)
  1244. ->where('data_type',SeeRange::type_seven)
  1245. ->where('type',SeeRange::data_three)
  1246. ->first();
  1247. if(! empty($depart)){
  1248. $depart = $depart->toArray();
  1249. $channel_id = Depart::where('id',$depart['param_id'])->value('channel_id');
  1250. if(! empty($channel_id)){
  1251. $emp_name = Employee::where('id',$channel_id)->value('emp_name');
  1252. $send_data[] = [
  1253. 'employee_id' => $channel_id,
  1254. 'type' => 2,
  1255. 'state' => 0,
  1256. 'menu_id' => 37,
  1257. 'order_number' => $model->order_number,
  1258. 'tmp_data' => [
  1259. $model->order_number,
  1260. "派单合同",
  1261. "门店接收派单",
  1262. $emp_name,
  1263. date('Y-m-d H:i:s'),
  1264. ],
  1265. ];
  1266. (new OaService())->sendWxOaCheckMessage($send_data);
  1267. }
  1268. }
  1269. return [true, $model->toArray()];
  1270. }
  1271. public function settleSalesOrderConfirmBack($data,$user){
  1272. $model = SalesOrder::where('order_number', $data['order_number'])
  1273. ->where('del_time',0)
  1274. ->first();
  1275. if(empty($model)) return [false, '合同不存在或已被删除'];
  1276. //安装件
  1277. if($model->state != SalesOrder::State_four) return [false, '请确认合同状态,操作失败'];
  1278. //校验施工
  1279. $bool = Construction::where('del_time',0)
  1280. ->where('sales_order_id', $model->id)
  1281. ->exists();
  1282. if($bool) return [false,'合同已生成施工单,操作失败'];
  1283. if($model->is_confirm != 1) return [false, '合同未接受派单,操作失败'];
  1284. $model->is_confirm = 0;
  1285. $model->save();
  1286. //单据状态还原
  1287. SalesOrder::where('del_time',0)->where('id', $model->id)->update([
  1288. 'state' => SalesOrder::State_three,
  1289. 'dispatch_time_second' => 0,
  1290. 'dispatch_time_second_id' => 0,
  1291. ]);
  1292. SeeRange::where('del_time',0)
  1293. ->where('data_id', $model->id)
  1294. ->where('data_type',SeeRange::type_seven)
  1295. ->where('type',SeeRange::data_three)
  1296. ->update(['del_time' => time()]);
  1297. return [true, $model->toArray()];
  1298. }
  1299. public function confirmSales($data){
  1300. $model = SalesOrder::where('order_number', $data['order_number'])
  1301. ->where('del_time',0)
  1302. ->first();
  1303. if(empty($model)) return [false, '合同不存在或已被删除'];
  1304. if($model->state != SalesOrder::State_one) return [false, '请确认合同状态,操作失败'];
  1305. if($data['type'] == self::TYPE_ONE){
  1306. $state = SalesOrder::State_three;
  1307. if(in_array($model->model_type,[SalesOrder::Model_type_four,SalesOrder::Model_type_seven])){
  1308. //线上订单 补贴订单
  1309. $state = SalesOrder::State_two;
  1310. }
  1311. $model->state = $state;
  1312. $model->save();
  1313. }else{
  1314. $model->state = SalesOrder::State_minus_one;
  1315. $model->save();
  1316. }
  1317. return [true, $model->toArray()];
  1318. }
  1319. public function reject_sales($data){
  1320. $model = SalesOrder::where('order_number', $data['order_number'])
  1321. ->where('del_time',0)
  1322. ->first();
  1323. if(empty($model)) return [false, '合同不存在或已被删除'];
  1324. if($model->out_state > SalesOrder::out_zero) return [false, '合同已提交出库,操作失败'];
  1325. //安装件
  1326. if(in_array($model->model_type,[SalesOrder::Model_type_four,SalesOrder::Model_type_seven])){
  1327. //线上订单 补贴订单
  1328. if($model->state != SalesOrder::State_two) return [false, '请确认合同状态,操作失败'];
  1329. }else{
  1330. //除线上订单 补贴订单 之外
  1331. if($model->state != SalesOrder::State_three) return [false, '请确认合同状态,操作失败'];
  1332. }
  1333. //未确认
  1334. $model->state = SalesOrder::State_zero;
  1335. $model->save();
  1336. return [true, $model->toArray()];
  1337. }
  1338. public function reject_purchase($data){
  1339. $model = PurchaseOrder::where('order_number', $data['order_number'])
  1340. ->where('del_time',0)
  1341. ->first();
  1342. if(empty($model)) return [false, '采购单不存在或已被删除'];
  1343. //安装件
  1344. if($model->state != PurchaseOrder::STATE_Four) return [false, '请确认采购单状态,操作失败'];
  1345. $model->state = PurchaseOrder::STATE_TWO;
  1346. $model->save();
  1347. return [true, $model->toArray()];
  1348. }
  1349. public function reject_purchase_special($data){
  1350. $model = PurchaseOrderSpecial::where('order_number', $data['order_number'])
  1351. ->where('del_time',0)
  1352. ->first();
  1353. if(empty($model)) return [false, '虚拟采购订单不存在或已被删除'];
  1354. //安装件
  1355. if($model->state != PurchaseOrderSpecial::STATE_TWO) return [false, '请确认虚拟采购订单状态,操作失败'];
  1356. $model->state = PurchaseOrder::STATE_ZERO;
  1357. $model->save();
  1358. return [true, $model->toArray()];
  1359. }
  1360. public function reject_purchase_confirm($data){
  1361. $model = PurchaseOrder::where('order_number', $data['order_number'])
  1362. ->where('del_time',0)
  1363. ->first();
  1364. if(empty($model)) return [false, '采购单不存在或已被删除'];
  1365. //安装件
  1366. if($model->state != PurchaseOrder::STATE_TWO) return [false, '请确认采购单状态,操作失败'];
  1367. $model->state = PurchaseOrder::STATE_ZERO;
  1368. $model->save();
  1369. return [true, $model->toArray()];
  1370. }
  1371. public function reject_construction($data){
  1372. $model = Construction::where('order_number', $data['order_number'])
  1373. ->where('del_time',0)
  1374. ->first();
  1375. if(empty($model)) return [false, '施工单不存在或已被删除'];
  1376. //安装件
  1377. if($model->state != Construction::STATE_TWO) return [false, '请确认施工单状态,操作失败'];
  1378. $model->state = Construction::STATE_ZERO;
  1379. $model->save();
  1380. return [true, $model->toArray()];
  1381. }
  1382. public function reject_payment_receipt($data){
  1383. $model = PaymentReceipt::where('order_number', $data['order_number'])
  1384. ->where('del_time',0)
  1385. ->first();
  1386. if(empty($model)) return [false, '收付款单不存在或已被删除'];
  1387. if($model->state != PaymentReceipt::STATE_TWO) return [false, '请确认收付款单状态,操作失败'];
  1388. $model->state = PaymentReceipt::STATE_ZERO;
  1389. $model->save();
  1390. return [true, $model->toArray()];
  1391. }
  1392. public function reject_sports_bag($data){
  1393. $model = SportsBag::where('order_number', $data['order_number'])
  1394. ->where('del_time',0)
  1395. ->first();
  1396. if(empty($model)) return [false, '活动包不存在或已被删除'];
  1397. if($model->state != SportsBag::STATE_TWO) return [false, '请确认活动包状态,操作失败'];
  1398. $model->state = SportsBag::STATE_ZERO;
  1399. $model->save();
  1400. return [true, $model->toArray()];
  1401. }
  1402. public function reject_return_exchange($data){
  1403. $model = ReturnExchangeOrder::where('order_number', $data['order_number'])
  1404. ->where('del_time',0)
  1405. ->first();
  1406. if(empty($model)) return [false, '退换货单不存在或已被删除'];
  1407. if($model->state != ReturnExchangeOrder::State_two) return [false, '请确认退换货单状态,操作失败'];
  1408. $model->state = ReturnExchangeOrder::State_zero;
  1409. $model->save();
  1410. return [true, $model->toArray()];
  1411. }
  1412. public function reject_record_construction($data,$order){
  1413. //仅施工不需要库存流水
  1414. if($order['model_type'] == Construction::Model_type_two) return [true, self::minus_one];
  1415. //获取单据最新数据时间 正常施工数据
  1416. $crt_time = 0;
  1417. $latest = InOutRecord::where('del_time',0)
  1418. ->where('order_number',$data['order_number'])
  1419. ->where('number','<',0)
  1420. ->select('crt_time')
  1421. ->orderBy('crt_time', 'desc')
  1422. ->first();
  1423. if(! empty($latest)) $crt_time = $latest->crt_time;
  1424. $result = InOutRecord::where('del_time',0)
  1425. ->where('crt_time',$crt_time)
  1426. ->where('order_number',$data['order_number'])
  1427. ->where('number','<',0)
  1428. ->select('product_id','storehouse_id','number','depart_id','order_number','top_depart_id','order_type','price')
  1429. ->get()->toArray();
  1430. if(empty($result)) return [false,'施工出库流水数据未找到'];
  1431. //生成对冲数据
  1432. $time = time();
  1433. foreach ($result as $key => $value){
  1434. $result[$key]['number'] = abs($value['number']);
  1435. $result[$key]['crt_time'] = $time;
  1436. }
  1437. $bool = InOutRecord::insert($result);
  1438. if(! $bool) return [false,'流水写入失败'];
  1439. //写入流水
  1440. return [true, ''];
  1441. }
  1442. public function reject_record_purchase($data,$order){
  1443. //获取单据最新数据时间 正常采购入库数据
  1444. $crt_time = 0;
  1445. $latest = InOutRecord::where('del_time',0)
  1446. ->where('order_number',$data['order_number'])
  1447. ->where('number','>',0)
  1448. ->select('crt_time')
  1449. ->orderBy('crt_time', 'desc')
  1450. ->first();
  1451. if(! empty($latest)) $crt_time = $latest->crt_time;
  1452. $result = InOutRecord::where('del_time',0)
  1453. ->where('crt_time',$crt_time)
  1454. ->where('order_number',$data['order_number'])
  1455. ->where('number','>',0)
  1456. ->select('product_id','storehouse_id','number','depart_id','order_number','top_depart_id','order_type','price')
  1457. ->get()->toArray();
  1458. if(empty($result)) return [false,'采购入库流水数据未找到'];
  1459. //生成对冲数据
  1460. $time = time();
  1461. foreach ($result as $key => $value){
  1462. $result[$key]['number'] = - $value['number'];
  1463. $result[$key]['crt_time'] = $time;
  1464. }
  1465. $bool = InOutRecord::insert($result);
  1466. if(! $bool) return [false,'流水写入失败'];
  1467. //写入流水
  1468. return [true, ''];
  1469. }
  1470. public function reject_record_return_exchange($data,$order){
  1471. if($order['model_type'] == ReturnExchangeOrder::Model_type_three) return [true, self::minus_one];
  1472. //获取单据最新数据时间 正常退换货流水数据
  1473. $crt_time = 0;
  1474. $latest = InOutRecord::where('del_time',0)
  1475. ->where('order_number',$data['order_number'])
  1476. ->select('crt_time')
  1477. ->orderBy('crt_time', 'desc')
  1478. ->first();
  1479. if(! empty($latest)) $crt_time = $latest->crt_time;
  1480. $result = InOutRecord::where('del_time',0)
  1481. ->where('crt_time',$crt_time)
  1482. ->where('order_number',$data['order_number'])
  1483. ->select('product_id','storehouse_id','number','depart_id','order_number','top_depart_id','order_type','price')
  1484. ->get()->toArray();
  1485. if(empty($result)) return [true, self::minus_one];
  1486. //生成对冲数据
  1487. $time = time();
  1488. foreach ($result as $key => $value){
  1489. $result[$key]['number'] = - $value['number'];
  1490. $result[$key]['crt_time'] = $time;
  1491. }
  1492. $bool = InOutRecord::insert($result);
  1493. if(! $bool) return [false, '流水写入失败'];
  1494. $info = ReturnExchangeOrderForOutboundInfo::where('del_time',0)
  1495. ->where('order_number',$data['order_number'])
  1496. ->get()->toArray();
  1497. if(! empty($info)){
  1498. foreach ($info as $value){
  1499. //出库单占用出库数量解放
  1500. OutBoundOrderInfo::where('id',$value['out_bound_order_info_id'])
  1501. ->lockForUpdate()
  1502. ->update([
  1503. 'return_number' => DB::raw('return_number - ('. $value['number'] . ')'),
  1504. ]);
  1505. }
  1506. //记录信息标记删除
  1507. ReturnExchangeOrderForOutboundInfo::where('del_time',0)
  1508. ->where('order_number',$data['order_number'])
  1509. ->update(['del_time' => $time]);
  1510. }
  1511. $info = PurchaseOrderInfoForOutboundInfo::where('del_time',0)
  1512. ->where('order_number',$data['order_number'])
  1513. ->get()->toArray();
  1514. if(! empty($info)){
  1515. foreach ($info as $value){
  1516. //退换货退合同 合同占用的采购或盘点占用出库数量解放
  1517. PurchaseOrderInfoForOutBound::where('id',$value['purchase_order_info_id'])
  1518. ->lockForUpdate()
  1519. ->update([
  1520. 'return_number' => DB::raw('return_number - ('. $value['number'] . ')'),
  1521. ]);
  1522. }
  1523. //记录信息标记删除
  1524. PurchaseOrderInfoForOutboundInfo::where('del_time',0)
  1525. ->where('order_number',$data['order_number'])
  1526. ->update(['del_time' => $time]);
  1527. }
  1528. //写入流水
  1529. return [true, ''];
  1530. }
  1531. public function getOrderDetail($data,$user){
  1532. if(empty($data['order_number'])) return [false,'必传参数不能为空'];
  1533. $array = [];
  1534. foreach (Construction::$prefix as $value){
  1535. $array[$value] = "\App\Service\\ConstructionService";
  1536. }
  1537. foreach (ReturnExchangeOrder::$prefix as $value){
  1538. $array[$value] = "\App\Service\\ReturnExchangeOrderService";
  1539. }
  1540. foreach (SalesOrder::$prefix as $value){
  1541. $array[$value] = "\App\Service\\SalesOrderService";
  1542. }
  1543. $status = true;
  1544. $msg = [];
  1545. foreach ($array as $key => $value){
  1546. if(strpos($data['order_number'],$key) !== false) {
  1547. list($status, $msg) = (new $value)->detail($data,$user);
  1548. return [$status, $msg];
  1549. }
  1550. }
  1551. if(strpos($data['order_number'],PurchaseOrder::prefix) !== false){
  1552. $service = "\App\Service\\PurchaseOrderService";
  1553. list($status, $msg) = (new $service)->detail($data,$user);
  1554. return [$status, $msg];
  1555. }
  1556. return [$status, $msg];
  1557. }
  1558. public function checkAll($data,$user){
  1559. if(empty($data['id']) || empty($data['order_number'])|| empty($data['opt_case'])) return [false,'必传参数不能为空或者参数值错误!'];
  1560. list($status,$msg) = $this->limitingSendRequestBackgExpire($data['order_number'].$data['opt_case']);
  1561. if(! $status) return [false,$msg];
  1562. //走审批流 单据校验
  1563. $function_check = self::$opt_1case_check[$data['opt_case']] ?? '';
  1564. //走审批流 单据状态改为待审批方法
  1565. $function = self::$opt_1case[$data['opt_case']] ?? '';
  1566. //单据不走审批流
  1567. $function2 = self::$finished[$data['opt_case']] ?? '';
  1568. try{
  1569. DB::beginTransaction();
  1570. //不走审批流,更新完直接返回
  1571. if($function2) {
  1572. list($bool,$msg) = $this->$function2($data,$user);
  1573. if($bool) {
  1574. $file = [];
  1575. if(isset($msg['order'])){
  1576. $order = $msg['order'];
  1577. $file = $msg['file'];
  1578. } else{
  1579. $order = $msg;
  1580. }
  1581. list($bool,$err) = $this->createRecordAndInventoryMy($data,$user,$order);
  1582. if($bool){
  1583. DB::commit();
  1584. if(! empty($file)) return [true, ['file' => ['new' => $file]]];
  1585. return [true, ''];
  1586. }else{
  1587. DB::rollBack();
  1588. return [false, $err];
  1589. }
  1590. }else{
  1591. DB::rollBack();
  1592. return [false, $msg];
  1593. }
  1594. }
  1595. //需要审批流,校验
  1596. if($function_check){
  1597. list($bool,$msg) = $this->$function_check($data, $user);
  1598. if(! $bool){
  1599. DB::rollBack();
  1600. return [false, $msg];
  1601. }
  1602. }
  1603. //需要审批流,从未审核变成待审核
  1604. if($function){
  1605. list($bool,$msg) = $this->$function($data);
  1606. if(! $bool){
  1607. DB::rollBack();
  1608. return [false, $msg];
  1609. }
  1610. //创建审批流
  1611. $args = [
  1612. 'order_no' => $data['order_number'],
  1613. 'menu_id' => $data['menu_id'] ?? 0,
  1614. 'opt_case' => $data['opt_case'],
  1615. 'order' => $msg,
  1616. ];
  1617. $oa = new OaService($user);
  1618. list($bool,$msg) = $oa->createOaOrder($args);
  1619. if(! $bool) {
  1620. DB::rollBack();
  1621. if($msg) return [false,$msg];
  1622. }
  1623. }
  1624. DB::commit();
  1625. return [true, ''];
  1626. }catch (\Throwable $exception){
  1627. DB::rollBack();
  1628. return [false, $exception->getMessage() . $exception->getFile(). $exception->getLine()];
  1629. }
  1630. }
  1631. //更新库存
  1632. public function changeInventory($data,$order,$user){
  1633. $number_symbol = "";
  1634. if(in_array($data['opt_case'],self::$in_opt)){
  1635. $number_symbol = ">";
  1636. }elseif (in_array($data['opt_case'],self::$out_opt)){
  1637. $number_symbol = "<";
  1638. }
  1639. //获取单据最新数据时间 正常审核的数据
  1640. $latest = InOutRecord::where('del_time',0)
  1641. ->where('order_number',$order['order_number'])
  1642. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1643. return $query->where('number', $number_symbol,0);
  1644. })
  1645. ->select('crt_time')
  1646. ->orderBy('crt_time', 'desc')
  1647. ->first();
  1648. $model = InOutRecord::where('del_time',0)
  1649. ->where('order_number',$order['order_number'])
  1650. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1651. return $query->where('number', $number_symbol,0);
  1652. })
  1653. ->select('number','crt_time','product_id','storehouse_id','top_depart_id');
  1654. if(! empty($latest)) {
  1655. $t = $latest->toArray();
  1656. $model->where('crt_time',$t['crt_time']);
  1657. }
  1658. $record = $model->get()->toArray();
  1659. if (empty($record)) return [false,'流水记录不存在'];
  1660. $top_depart_id = Storehouse::where('id', $order['storehouse_id'])->value('top_depart_id');
  1661. $result = $lock_number = [];
  1662. foreach ($record as $value){
  1663. $key = $value['product_id'] . $value['storehouse_id'];
  1664. if(isset($result[$key])){
  1665. $result[$key]['number'] += $value['number'];
  1666. }else{
  1667. $result[$key] = [
  1668. 'product_id' => $value['product_id'],
  1669. 'number' => $value['number'],
  1670. 'crt_time' => $value['crt_time'],
  1671. 'storehouse_id' => $value['storehouse_id'],
  1672. 'top_depart_id' => $top_depart_id,
  1673. ];
  1674. }
  1675. if($value['number'] < 0){
  1676. if(isset($lock_number[$key])){
  1677. $lock_number[$key] += $value['number'];
  1678. }else{
  1679. $lock_number[$key] = $value['number'];
  1680. }
  1681. }
  1682. }
  1683. //是否校验库存 是的话锁定数量要更新(根据当前操作人所在门店是否校验库存)
  1684. // $lock = $user['is_check_stock'];
  1685. $lock = ProductInventorySet::type_one;
  1686. $for_lock = OrderInventoryStock::where('order_number',$order['order_number'])
  1687. ->where('del_time',0)
  1688. ->orderBy('id','desc')
  1689. ->first();
  1690. if(! empty($for_lock)) {
  1691. $for_lock = $for_lock->toArray();
  1692. $lock = $for_lock['is_check_stock'];
  1693. }
  1694. $result = array_values($result);
  1695. foreach ($result as $key => $value){
  1696. $keys = $value['product_id'] . $value['storehouse_id'];
  1697. $m = ProductInventory::where('product_id',$value['product_id'])
  1698. ->where('storehouse_id',$value['storehouse_id'])
  1699. ->select('product_id','number','storehouse_id')
  1700. ->first();
  1701. if(empty($m)){
  1702. ProductInventory::insert($result[$key]);
  1703. }else{
  1704. //锁定数量
  1705. $lock_number_tmp = 0;
  1706. if($lock == ProductInventorySet::type_one && ! empty($lock_number[$keys])) $lock_number_tmp = $lock_number[$keys];
  1707. ProductInventory::where('product_id',$m->product_id)
  1708. ->where('storehouse_id',$m->storehouse_id)
  1709. ->lockForUpdate()
  1710. ->update([
  1711. 'number' => DB::raw('number + ('. $value['number'] . ')'),
  1712. 'lock_number' => DB::raw('lock_number + ('. $lock_number_tmp . ')')
  1713. ]);
  1714. }
  1715. }
  1716. return [true,''];
  1717. }
  1718. //业务单据审批通过后 驳回 更新库存
  1719. public function changeInventoryReject($data,$order,$user){
  1720. $number_symbol = "";
  1721. if(in_array($data['opt_case'],self::$in_opt)){
  1722. $number_symbol = "<";
  1723. }elseif (in_array($data['opt_case'],self::$out_opt)){
  1724. $number_symbol = ">";
  1725. }
  1726. //获取单据最新数据时间 正常审核的数据
  1727. $latest = InOutRecord::where('del_time',0)
  1728. ->where('order_number',$order['order_number'])
  1729. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1730. return $query->where('number', $number_symbol,0);
  1731. })
  1732. ->select('crt_time')
  1733. ->orderBy('crt_time', 'desc')
  1734. ->first();
  1735. $model = InOutRecord::where('del_time',0)
  1736. ->where('order_number',$order['order_number'])
  1737. ->when(! empty($number_symbol), function ($query) use ($number_symbol) {
  1738. return $query->where('number', $number_symbol,0);
  1739. })
  1740. ->select('number','crt_time','product_id','storehouse_id','top_depart_id');
  1741. if(! empty($latest)) {
  1742. $t = $latest->toArray();
  1743. $model->where('crt_time',$t['crt_time']);
  1744. }
  1745. $record = $model->get()->toArray();
  1746. if (empty($record)) return [false,'流水记录不存在'];
  1747. $top_depart_id = Storehouse::where('id', $order['storehouse_id'])->value('top_depart_id');
  1748. $result = $lock_number = [];
  1749. foreach ($record as $value){
  1750. $key = $value['product_id'] . $value['storehouse_id'];
  1751. if(isset($result[$key])){
  1752. $result[$key]['number'] += $value['number'];
  1753. }else{
  1754. $result[$key] = [
  1755. 'product_id' => $value['product_id'],
  1756. 'number' => $value['number'],
  1757. 'crt_time' => $value['crt_time'],
  1758. 'storehouse_id' => $value['storehouse_id'],
  1759. 'top_depart_id' => $top_depart_id,
  1760. ];
  1761. }
  1762. if($value['number'] > 0){
  1763. if(isset($lock_number[$key])){
  1764. $lock_number[$key] += $value['number'];
  1765. }else{
  1766. $lock_number[$key] = $value['number'];
  1767. }
  1768. }
  1769. }
  1770. //是否校验库存 是的话锁定数量要更新(根据当前操作人所在门店是否校验库存)
  1771. $lock = $user['is_check_stock'];
  1772. $result = array_values($result);
  1773. foreach ($result as $key => $value){
  1774. $keys = $value['product_id'] . $value['storehouse_id'];
  1775. $m = ProductInventory::where('product_id',$value['product_id'])
  1776. ->where('storehouse_id',$value['storehouse_id'])
  1777. ->select('product_id','number','storehouse_id')
  1778. ->first();
  1779. if(empty($m)){
  1780. ProductInventory::insert($result[$key]);
  1781. }else{
  1782. //锁定数量
  1783. $lock_number_tmp = 0;
  1784. if($lock == ProductInventorySet::type_one && ! empty($lock_number[$keys])) $lock_number_tmp = $lock_number[$keys];
  1785. ProductInventory::where('product_id',$m->product_id)
  1786. ->where('storehouse_id',$m->storehouse_id)
  1787. ->lockForUpdate()
  1788. ->update([
  1789. 'number' => DB::raw('number + ('. $value['number'] . ')'),
  1790. 'lock_number' => DB::raw('lock_number + ('. $lock_number_tmp . ')')
  1791. ]);
  1792. }
  1793. }
  1794. return [true,''];
  1795. }
  1796. public function createRecordAndInventory($data = []){
  1797. if(empty($data['type']) || empty($data['opt_case']) || empty($data['order_number'])) return [false, '传递参数缺少'];
  1798. $user = $data['user_data'] ?? [];
  1799. if($data['type'] == self::TYPE_THREE){
  1800. //通过后弃审
  1801. if(! isset(self::$opt_case_reject[$data['opt_case']])) return [false, '该操作不存在'];
  1802. //具体方法
  1803. $function = self::$opt_case_reject[$data['opt_case']];
  1804. //流水
  1805. $function2 = self::$reject_record[$data['opt_case']] ?? '';
  1806. //自动生成删除
  1807. $function3 = self::$create_del[$data['opt_case']] ?? '';
  1808. try{
  1809. DB::beginTransaction();
  1810. //更新单据的状态
  1811. list($bool,$msg) = $this->$function($data);
  1812. if(! $bool){
  1813. DB::rollBack();
  1814. return [false, $msg];
  1815. }
  1816. $order = $msg;
  1817. if($function3){
  1818. list($boolean,$msg) = $this->$function3($data,$order);
  1819. if(! $boolean) {
  1820. DB::rollBack();
  1821. return [false, $msg];
  1822. }
  1823. }
  1824. if($function2) {
  1825. //流水
  1826. list($boolean,$msg) = $this->$function2($data,$order);
  1827. if(! $boolean) {
  1828. DB::rollBack();
  1829. return [false, $msg];
  1830. }
  1831. if($msg != self::minus_one){
  1832. //库存
  1833. list($bool,$msg) = $this->changeInventoryReject($data,$order,$user);
  1834. if(! $bool){
  1835. DB::rollBack();
  1836. return [false, $msg];
  1837. }
  1838. }
  1839. }
  1840. if(! empty(self::$operation_order_reject[$data['opt_case']])){
  1841. $type = self::$operation_order_reject[$data['opt_case']];
  1842. (new OrderOperationService())->add([
  1843. 'order_number' => $order['order_number'],
  1844. 'msg' => OrderOperation::$type[$type],
  1845. 'type' => $type
  1846. ],$user);
  1847. }
  1848. DB::commit();
  1849. return [true, ''];
  1850. }catch (\Throwable $exception){
  1851. DB::rollBack();
  1852. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1853. }
  1854. }else{
  1855. //具体方法
  1856. $function = self::$opt_case[$data['opt_case']] ?? "";
  1857. $record = self::$record[$data['opt_case']] ?? "";
  1858. $create = self::$create[$data['opt_case']] ?? "";
  1859. try{
  1860. DB::beginTransaction();
  1861. list($bool,$msg) = $this->$function($data);
  1862. if(! $bool){
  1863. DB::rollBack();
  1864. return [false, $msg];
  1865. }
  1866. $order = $msg;
  1867. if($data['type'] == self::TYPE_ONE){
  1868. if($record) {
  1869. //流水
  1870. list($bool,$msg) = $this->$record($data, $order);
  1871. if(! $bool) {
  1872. DB::rollBack();
  1873. return [false, $msg];
  1874. }
  1875. if($msg != self::minus_one){
  1876. //库存
  1877. list($bool,$msg) = $this->changeInventory($data, $order, $user);
  1878. if(! $bool) {
  1879. DB::rollBack();
  1880. return [false, $msg];
  1881. }
  1882. }
  1883. }
  1884. if($create) {
  1885. list($bool,$msg) = $this->$create($order,$user);
  1886. if(! $bool) {
  1887. DB::rollBack();
  1888. return [false, $msg];
  1889. }
  1890. }
  1891. }
  1892. if(! empty(self::$operation_order[$data['opt_case']])){
  1893. $user = $data['user_data'] ?? [];
  1894. $type = self::$operation_order[$data['opt_case']];
  1895. (new OrderOperationService())->add([
  1896. 'order_number' => $order['order_number'],
  1897. 'msg' => OrderOperation::$type[$type],
  1898. 'type' => $type
  1899. ],$user);
  1900. }
  1901. DB::commit();
  1902. return [true, ''];
  1903. }catch (\Throwable $exception){
  1904. DB::rollBack();
  1905. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1906. }
  1907. }
  1908. }
  1909. //不需要走审批流 直接调用
  1910. public function createRecordAndInventoryMy($data = [],$user = [],$order = []){
  1911. if(! empty($data['type']) && $data['type'] == self::TYPE_THREE){
  1912. }else{
  1913. //具体方法
  1914. $record = self::$record[$data['opt_case']] ?? "";
  1915. $create = self::$create[$data['opt_case']] ?? "";
  1916. try{
  1917. DB::beginTransaction();
  1918. if($record) {
  1919. //流水
  1920. list($bool,$msg) = $this->$record($data, $order);
  1921. if(! $bool) {
  1922. DB::rollBack();
  1923. return [false, $msg];
  1924. }
  1925. if($msg != self::minus_one){
  1926. //库存
  1927. list($bool,$msg) = $this->changeInventory($data, $order, $user);
  1928. if(! $bool) {
  1929. DB::rollBack();
  1930. return [false, $msg];
  1931. }
  1932. }
  1933. }
  1934. if($create) {
  1935. list($bool,$msg) = $this->$create($order,$user);
  1936. if(! $bool) {
  1937. DB::rollBack();
  1938. return [false, $msg];
  1939. }
  1940. }
  1941. if(! empty(self::$operation_order[$data['opt_case']])){
  1942. $type = self::$operation_order[$data['opt_case']];
  1943. (new OrderOperationService())->add([
  1944. 'order_number' => $order['order_number'],
  1945. 'msg' => OrderOperation::$type[$type],
  1946. 'type' => $type
  1947. ],$user);
  1948. }
  1949. DB::commit();
  1950. return [true, ''];
  1951. }catch (\Throwable $exception){
  1952. DB::rollBack();
  1953. return [false, $exception->getMessage() . $exception->getLine() . $exception->getFile()];
  1954. }
  1955. }
  1956. }
  1957. public function orderInventoryInsert($insert){
  1958. if(empty($insert['order_number'])) return;
  1959. $model = new OrderInventoryStock();
  1960. $model->order_number = $insert['order_number'];
  1961. $model->is_check_stock = $insert['is_check_stock'];
  1962. $model->save();
  1963. }
  1964. }