CheckOrderClass.php 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612
  1. <?php
  2. namespace bizGhs\order\classes;
  3. use biz\shop\classes\ShopClass;
  4. use biz\stat\classes\StatPdAddClass;
  5. use biz\stat\classes\StatPdSubClass;
  6. use bizGhs\book\classes\BookCustomClass;
  7. use bizGhs\book\classes\BookItemClass;
  8. use bizGhs\book\classes\BookItemCustomClass;
  9. use bizGhs\product\classes\ProductClass;
  10. use bizGhs\shop\classes\MainClass;
  11. use bizGhs\stock\classes\StockInDayClass;
  12. use bizGhs\stock\classes\StockRecordClass;
  13. use common\components\orderSn;
  14. use common\components\stringUtil;
  15. use common\components\util;
  16. use Yii;
  17. use bizGhs\base\classes\BaseClass;
  18. use bizGhs\order\traits\OrderTrait;
  19. class CheckOrderClass extends BaseClass
  20. {
  21. use OrderTrait;
  22. public static $baseFile = '\bizGhs\order\models\CheckOrder';
  23. const STATUS_DRAFT = 1; //草稿
  24. const STATUS_COMPLETE = 2; //完成
  25. public static $statusMap = [
  26. self::STATUS_DRAFT => '草稿',
  27. self::STATUS_COMPLETE => '已盘点',
  28. ];
  29. public static function bookToDelStock($productId, $num, $shop, $staff)
  30. {
  31. $sjId = $shop->sjId ?? 0;
  32. $shopId = $shop->id ?? 0;
  33. $mainId = $shop->mainId ?? 0;
  34. $product = ProductClass::getById($productId, true);
  35. if (empty($product) || $product->mainId != $mainId) {
  36. util::fail('没有找到花材。');
  37. }
  38. $stock = $out->stock ?? 0;
  39. $bookSn = $shop->bookSn ?? 0;
  40. $couldDelNum = 0;
  41. if (empty($bookSn)) {
  42. util::fail('没有在预订活动中');
  43. }
  44. $bookItem = BookItemClass::getByCondition(['bookSn' => $bookSn, 'itemId' => $productId], true);
  45. if (!empty($bookItem)) {
  46. //借出的人预订控制在不受影响范围
  47. $bookNum = $bookItem->bookNum ?? 0;
  48. if ($bookNum > 0) {
  49. $roadNum = $bookItem->roadNum ?? 0;
  50. $needCgNum = $bookItem->needCgNum ?? 0;
  51. $unReachNum = bcadd($roadNum, $needCgNum, 2);
  52. $useStock = bcsub($bookNum, $unReachNum, 2);
  53. if ($stock > $useStock) {
  54. $couldDelNum = bcsub($stock, $useStock, 2);
  55. }
  56. } else {
  57. $couldDelNum = $stock;
  58. }
  59. } else {
  60. $couldDelNum = $stock;
  61. }
  62. if ($couldDelNum <= 0) {
  63. util::fail('不能减库存');
  64. }
  65. if ($num > $couldDelNum) {
  66. util::fail("最多只能删{$couldDelNum}份");
  67. }
  68. $newStock = bcsub($stock, $num, 2);
  69. $adminId = $staff->adminId ?? 0;
  70. $staffName = $staff->name ?? '';
  71. $staffId = $staff->id ?? 0;
  72. $ghsItemInfo = [['productId' => $couldDelNum, 'bigNum' => $newStock, 'smallNum' => 0,]];
  73. $pdData = [];
  74. $pdData['itemInfo'] = $ghsItemInfo;
  75. $pdData['sjId'] = $sjId;
  76. $pdData['shopId'] = $shopId;
  77. $pdData['adminId'] = $adminId;
  78. $pdData['mainId'] = $mainId;
  79. $pdData['staffName'] = $data['staffName'] ?? '';
  80. $pdData['remark'] = "在预订中删除库存";
  81. $pdData['staffName'] = $staffName;
  82. $pdData['staffId'] = $staffId;
  83. self::opOrder($pdData, false, false, false);
  84. return true;
  85. }
  86. public static function bookToAddStock($productId, $num, $shop, $staff, $bookItemCustomRes)
  87. {
  88. $cacheKey = 'change_book_item_num_' . $productId;
  89. $noLock = util::lock($cacheKey);
  90. if (!$noLock) {
  91. util::fail("系统繁忙,1秒后再提交");
  92. }
  93. $mainId = $shop->mainId ?? 0;
  94. $product = ProductClass::getById($productId, true);
  95. if (empty($product) || $product->mainId != $mainId) {
  96. util::fail('没有找到花材...');
  97. }
  98. $bookSn = $shop->bookSn ?? 0;
  99. $stock = $product->stock ?? 0;
  100. $newStock = bcadd($stock, $num);
  101. $adminId = $staff->adminId ?? 0;
  102. $staffName = $staff->name ?? '';
  103. $staffId = $staff->id ?? 0;
  104. $sjId = $shop->sjId ?? 0;
  105. $shopId = $shop->id ?? 0;
  106. $mainId = $shop->mainId ?? 0;
  107. $ghsItemInfo = [['productId' => $productId, 'bigNum' => $newStock, 'smallNum' => 0,]];
  108. $pdData = [];
  109. $pdData['itemInfo'] = $ghsItemInfo;
  110. $pdData['sjId'] = $sjId;
  111. $pdData['shopId'] = $shopId;
  112. $pdData['adminId'] = $adminId;
  113. $pdData['mainId'] = $mainId;
  114. $pdData['staffName'] = $staffName;
  115. $pdData['staffId'] = $staffId;
  116. $pdData['remark'] = "预定盘点增加{$num}个库存";
  117. $inOrder = self::opOrder($pdData, false, false, false);
  118. $needCgNum = $bookItemCustomRes->needCgNum ?? 0;
  119. if ($num > $needCgNum) {
  120. util::fail('增加库存不能超过待采数量');
  121. }
  122. $delNeedCgNum = $num;
  123. $params = ['staffId' => $staffId, 'staffName' => $staffName];
  124. $params['currentChangeType'] = 'pdAddStock';
  125. $bookItemCustomRes = BookItemCustomClass::delNeedCgNum($bookItemCustomRes, $delNeedCgNum, 0, $inOrder, $shop, $product, $params);
  126. $bookItemRes = BookItemClass::getByCondition(['bookSn' => $bookSn, 'itemId' => $productId], true);
  127. if (empty($bookItemRes)) {
  128. util::fail('借库存没有找到bookItem');
  129. }
  130. $bookItemRes = BookItemClass::delNeedCgNum($bookItemRes, $delNeedCgNum, 0, $inOrder, $shop, $product, $params);
  131. $customId = $bookItemCustomRes->customId ?? 0;
  132. $bookCustomRes = BookCustomClass::getByCondition(['bookSn' => $bookSn, 'customId' => $customId], true);
  133. if (empty($bookCustomRes)) {
  134. util::fail('盘点加库存没有找到bookCustom');
  135. }
  136. $bookCustomRes = BookCustomClass::delNeedCgNum($bookCustomRes, $delNeedCgNum, 0, $inOrder, $shop, $product, $params);
  137. util::unlock($cacheKey);
  138. return true;
  139. }
  140. public static function loanStock($inId, $outId, $num, $shop, $staff, $bookItemCustomRes)
  141. {
  142. $cacheKey = 'change_book_item_num_' . $inId;
  143. $noLock = util::lock($cacheKey);
  144. if (!$noLock) {
  145. util::fail("系统繁忙,1秒后再提交");
  146. }
  147. $sjId = $shop->sjId ?? 0;
  148. $shopId = $shop->id ?? 0;
  149. $mainId = $shop->mainId ?? 0;
  150. $in = ProductClass::getById($inId, true);
  151. if (empty($in) || $in->mainId != $mainId) {
  152. util::fail('没有找到花材...');
  153. }
  154. $inName = $in->name ?? '';
  155. $out = ProductClass::getById($outId, true);
  156. if (empty($out) || $out->mainId != $mainId) {
  157. util::fail('没有找到花材。');
  158. }
  159. $outName = $out->name ?? '';
  160. $stock = $out->stock ?? 0;
  161. $bookSn = $shop->bookSn ?? 0;
  162. $couldLoan = 0;
  163. if (!empty($bookSn)) {
  164. $bookItem = BookItemClass::getByCondition(['bookSn' => $bookSn, 'itemId' => $outId], true);
  165. if (!empty($bookItem)) {
  166. //借出的人预订控制在不受影响范围
  167. $bookNum = $bookItem->bookNum ?? 0;
  168. if ($bookNum > 0) {
  169. $roadNum = $bookItem->roadNum ?? 0;
  170. $needCgNum = $bookItem->needCgNum ?? 0;
  171. $unReachNum = bcadd($roadNum, $needCgNum, 2);
  172. $useStock = bcsub($bookNum, $unReachNum, 2);
  173. if ($stock > $useStock) {
  174. $couldLoan = bcsub($stock, $useStock, 2);
  175. }
  176. } else {
  177. $couldLoan = $stock;
  178. }
  179. } else {
  180. $couldLoan = $stock;
  181. }
  182. }
  183. if ($num > $couldLoan) {
  184. util::fail("只能借{$couldLoan}");
  185. }
  186. if ($inId == $outId) {
  187. util::fail('同个花材呢');
  188. }
  189. $newOutStock = bcsub($stock, $num, 2);
  190. $inStock = $in->stock ?? 0;
  191. $newInStock = bcadd($inStock, $num);
  192. $adminId = $staff->adminId ?? 0;
  193. $staffName = $staff->name ?? '';
  194. $staffId = $staff->id ?? 0;
  195. $ghsItemInfo = [['productId' => $outId, 'bigNum' => $newOutStock, 'smallNum' => 0,]];
  196. $pdData = [];
  197. $pdData['itemInfo'] = $ghsItemInfo;
  198. $pdData['sjId'] = $sjId;
  199. $pdData['shopId'] = $shopId;
  200. $pdData['adminId'] = $adminId;
  201. $pdData['mainId'] = $mainId;
  202. $pdData['staffName'] = $data['staffName'] ?? '';
  203. $pdData['remark'] = "借{$num}个库存给{$inName}";
  204. $pdData['staffName'] = $staffName;
  205. $pdData['staffId'] = $staffId;
  206. self::opOrder($pdData, false, false, false);
  207. $sjId = $shop->sjId ?? 0;
  208. $shopId = $shop->id ?? 0;
  209. $mainId = $shop->mainId ?? 0;
  210. $ghsItemInfo = [['productId' => $inId, 'bigNum' => $newInStock, 'smallNum' => 0,]];
  211. $pdData = [];
  212. $pdData['itemInfo'] = $ghsItemInfo;
  213. $pdData['sjId'] = $sjId;
  214. $pdData['shopId'] = $shopId;
  215. $pdData['adminId'] = $adminId;
  216. $pdData['mainId'] = $mainId;
  217. $pdData['staffName'] = $staffName;
  218. $pdData['staffId'] = $staffId;
  219. $pdData['remark'] = "向{$outName}借{$num}个库存";
  220. $inOrder = self::opOrder($pdData, false, false, false);
  221. //借入的人待采会被影响
  222. $needCgNum = $bookItemCustomRes->needCgNum ?? 0;
  223. if ($num > $needCgNum) {
  224. $delNeedCgNum = $needCgNum;
  225. } else {
  226. $delNeedCgNum = $num;
  227. }
  228. $params = ['staffId' => $staffId, 'staffName' => $staffName];
  229. $params['currentChangeType'] = 'loanStock';
  230. $params['outName'] = $outName;
  231. $bookItemCustomRes = BookItemCustomClass::delNeedCgNum($bookItemCustomRes, $delNeedCgNum, 0, $inOrder, $shop, $in, $params);
  232. $bookItemRes = BookItemClass::getByCondition(['bookSn' => $bookSn, 'itemId' => $inId], true);
  233. if (empty($bookItemRes)) {
  234. util::fail('借库存没有找到bookItem');
  235. }
  236. $bookItemRes = BookItemClass::delNeedCgNum($bookItemRes, $delNeedCgNum, 0, $inOrder, $shop, $in, $params);
  237. $customId = $bookItemCustomRes->customId ?? 0;
  238. $bookCustomRes = BookCustomClass::getByCondition(['bookSn' => $bookSn, 'customId' => $customId], true);
  239. if (empty($bookCustomRes)) {
  240. util::fail('借库存没有找到bookCustom');
  241. }
  242. $bookCustomRes = BookCustomClass::delNeedCgNum($bookCustomRes, $delNeedCgNum, 0, $inOrder, $shop, $in, $params);
  243. util::unlock($cacheKey);
  244. return true;
  245. }
  246. //2021.1.22 lqh 操作订单 添加/保存草稿/草稿编辑保存: 区别在添加是立即改库存和记录流水记录,而保存草稿是只保存订单信息
  247. public static function opOrder($data, $draft = false, $update = false, $check = true, $params = [])
  248. {
  249. $sjId = $data['sjId'];
  250. $shopId = $data['shopId'];
  251. $adminId = $data['adminId'] ?? 0;
  252. $pdType = $data['pdType'] ?? '';
  253. $mainId = $data['mainId'] ?? 0;
  254. $remark = $data['remark'] ?? '';
  255. if (!empty($remark)) {
  256. $remark = stringUtil::subStringUtf8($remark, 100, '...');
  257. }
  258. //控制修改库存的权限,在这里控制 ssh 20250313
  259. if (getenv('YII_ENV') == 'production') {
  260. //花大苪只有三个人可以修改库存
  261. if ($mainId == 8164) {
  262. if (!in_array($adminId, [9273, 9303, 47576])) {
  263. util::fail('不能修改库存哦');
  264. }
  265. }
  266. }
  267. if ($draft) {
  268. //保存草稿
  269. $data['status'] = self::STATUS_DRAFT;
  270. } else {
  271. //确定保存
  272. $data['status'] = self::STATUS_COMPLETE;
  273. }
  274. if ($update) {
  275. $orderSn = $data['orderSn'];
  276. } else {
  277. $orderSn = orderSn::getGhsCheckSn();
  278. }
  279. $data['orderSn'] = $orderSn;
  280. //数据格式 [{bigNum:0,smallNum:0,productId:1}]
  281. $ghsItemInfo = $data['itemInfo'];
  282. //之前出现过同个花材在不现分类下出现,这里进行组合
  283. $ghsItemInfo = self::mergeItemInfo($ghsItemInfo);
  284. $sumNum = self::sumNumByItemInfo($ghsItemInfo);
  285. $data['bigNum'] = $sumNum['bigNum'];// 总的大单位数量 总共多少扎
  286. $data['smallNum'] = $sumNum['smallNum']; //总的小单位数量 总共多少支
  287. $connection = Yii::$app->db;
  288. $transaction = $connection->beginTransaction();
  289. try {
  290. if ($update) {
  291. //更新先删除数据
  292. self::deleteByCondition(['orderSn' => $orderSn]);
  293. CheckOrderItemClass::deleteByCondition(['orderSn' => $orderSn]);
  294. }
  295. $order = self::add($data, true);
  296. //写入详情表
  297. $batchData = self::groupOrderItem($ghsItemInfo, $orderSn);
  298. CheckOrderItemClass::batchAddOrderItem($batchData);
  299. $avCost = 0;
  300. $changeCost = 0;
  301. $unitCost = 0;
  302. $remainCost = 0;
  303. $remainStock = 0;
  304. if (isset($params['motherId']) && $params['motherId'] > 0) {
  305. $motherInfo = ProductClass::getById($params['motherId'], true);
  306. $unitCost = $motherInfo->avCost ?? 0;
  307. }
  308. $addAmount = 0;
  309. $subAmount = 0;
  310. $ids = [];
  311. if ($draft === false) {
  312. //盘点完成完成,直接将库存中的数量改为当时盘点的数量
  313. foreach ($batchData as $v) {
  314. $productId = $v['productId'];
  315. $ids[] = $productId;
  316. //修改库存数量
  317. $key = ProductClass::LOCK_STOCK . '_' . $productId;
  318. $lock = util::lock($key);
  319. if (!$lock) {
  320. util::fail("系统繁忙,请稍后再试");
  321. }
  322. $productData = ProductClass::getById($productId, true);
  323. //当 limitBuy=0 时,则清空限购记录缓存
  324. if ($productData->limitBuy == 0) {
  325. ProductClass::clearLimitBuyCache($productId);
  326. \bizHd\product\classes\ProductClass::clearLimitBuyCache($productId);
  327. }
  328. //涉及平均成本计算的,多处要修改,搜索关键词 calc_av_cost
  329. if (isset($params['motherId']) && $params['motherId'] > 0) {
  330. //变动库存和变动成本
  331. $changeNum = bcsub($productData->stock, $v['itemNum'], 2);
  332. $changeNum = abs($changeNum);
  333. $changeCost = bcmul($unitCost, $changeNum, 2);
  334. //原库存和原成本,也叫剩余成本和剩余库存
  335. $oldItemStock = $productData->stock ?? 0;
  336. $oldAvCost = $productData->avCost ?? 0;
  337. $oldItemCost = bcmul($oldItemStock, $oldAvCost, 2);
  338. if ($productId == $params['motherId']) {
  339. //新库存和新成本
  340. $remainCost = bcsub($oldItemCost, $changeCost, 2);
  341. $remainCost = $remainCost > 0 ? $remainCost : 0;
  342. $remainStock = bcsub($oldItemStock, $changeNum, 2);
  343. $remainStock = $remainStock > 0 ? $remainStock : 0;
  344. $avCost = $unitCost;
  345. $productData->avCost = $avCost;
  346. $productData->totalCost = $remainCost;
  347. $productData->totalStock = $remainStock;
  348. $productData->save();
  349. } else {
  350. //新库存和新成本
  351. $remainStock = bcadd($changeNum, $oldItemStock, 2);
  352. $remainCost = bcadd($changeCost, $oldItemCost, 2);
  353. if ($remainStock > 0) {
  354. $avCost = bcdiv($remainCost, $remainStock, 2);
  355. } else {
  356. $avCost = 0;
  357. $remainStock = 0;
  358. $remainCost = 0;
  359. }
  360. $productData->avCost = $avCost;
  361. $productData->totalCost = $remainCost;
  362. $productData->totalStock = $remainStock;
  363. $productData->save();
  364. }
  365. }
  366. ProductClass::updateStockById($productId, $v['itemNum'], $adminId);
  367. //上架
  368. if ($v['itemNum'] > 0 && $productData->status == 2) {
  369. ProductClass::changeStatus($productId, 1);
  370. }
  371. //下架
  372. if ($v['itemNum'] <= 0 && $productData->status == 1) {
  373. ProductClass::changeStatus($productId, 2);
  374. }
  375. util::unlock($key);
  376. //流水记录
  377. $record = [];
  378. $record['sjId'] = $sjId;
  379. $record['shopId'] = $shopId;
  380. $record['mainId'] = $productData->mainId ?? 0;
  381. $record['orderSn'] = $orderSn;
  382. $record['ptStyle'] = 2;
  383. $record['relateName'] = $data['staffName'] ?? '';
  384. $record['itemId'] = $v['itemId'];
  385. $record['productId'] = $productId;
  386. $record['itemNum'] = abs($v['profitLossNum']);
  387. $record['oldStock'] = $productData->stock ?? 0;
  388. $record['newStock'] = $v['itemNum'];
  389. $record['targetId'] = $order->id ?? 0;
  390. $record['remark'] = $remark;
  391. $record['avCost'] = $avCost;
  392. $record['changeCost'] = $changeCost;
  393. $record['unitCost'] = $unitCost;
  394. $record['totalStock'] = $remainStock;
  395. $record['totalCost'] = $remainCost;
  396. StockRecordClass::addCheckOrderRecord($record);
  397. $amount = $v['amount'] ?? 0;
  398. if ($amount > 0) {
  399. $addAmount = bcadd($addAmount, $amount, 2);
  400. } else {
  401. $subAmount = bcadd($subAmount, $amount, 2);
  402. }
  403. //如果花材是自动补充库存类型的花材,则库存低于900时,自动补充到98520,多处要同步修改,关键词 auto_add_stock
  404. if ($productData->virtualStock == 1 && $v['itemNum'] < 9900) {
  405. ProductClass::updateStockById($productId, 98520, $adminId);
  406. }
  407. }
  408. $shop = ShopClass::getById($shopId, true);
  409. $bookSn = $shop->bookSn ?? 0;
  410. if (!empty($bookSn) && $check == true) {
  411. $bookItemRes = BookItemClass::getAllByCondition(['bookSn' => $bookSn, 'itemId' => ['in', $ids]], null, '*', null, true);
  412. if (!empty($bookItemRes)) {
  413. foreach ($bookItemRes as $bookItem) {
  414. $name = $bookItem->name ?? '未命名';
  415. util::fail($name . " 被预订,不能直接改库存");
  416. }
  417. }
  418. }
  419. if ($pdType == 'stockInPd' && !empty($mainId)) {
  420. //如果是车销的入库花材盘点,则将记录过的花材清除
  421. StockInDayClass::deleteByCondition(['mainId' => $mainId]);
  422. }
  423. }
  424. $order->addAmount = $addAmount;
  425. $order->subAmount = $subAmount;
  426. $order->price = bcadd($addAmount, $subAmount, 2);
  427. $order->save();
  428. $shop = ShopClass::getLockById($shopId);
  429. $mainId = $shop->mainId ?? 0;
  430. $main = MainClass::getLockById($mainId);
  431. if (!empty($main)) {
  432. $currentAdd = bcadd($main->totalPdAdd, $addAmount, 2);
  433. $currentSub = bcadd($main->totalPdSub, abs($subAmount), 2);
  434. $main->totalPdAdd = $currentAdd;
  435. $main->totalPdSub = $currentSub;
  436. $main->save();
  437. }
  438. //统计每天和每月的盘盈盘亏数额
  439. StatPdAddClass::replace($main, $shop, $addAmount);
  440. $subAmount = abs($subAmount);
  441. StatPdSubClass::replace($main, $shop, $subAmount);
  442. $transaction->commit();
  443. return $order;
  444. } catch (\Exception $exception) {
  445. $transaction->rollBack();
  446. util::fail('保存失败' . $exception->getMessage());
  447. }
  448. }
  449. //2021.1.22 lqh 订单列表
  450. public static function getOrderList($where)
  451. {
  452. $data = self::getList('*', $where, 'addTime DESC');
  453. $list = isset($data['list']) && !empty($data['list']) ? $data['list'] : [];
  454. if (empty($list)) {
  455. return $data;
  456. }
  457. $data['list'] = $list;
  458. $data['list'] = self::groupAdminList($list);
  459. $data['list'] = self::groupStatusName($data['list']);
  460. return $data;
  461. }
  462. //2021.1.22 订单详情
  463. //获取订单详情信息 lqh 2021.1.20
  464. public static function getOrderDetail($orderSn, $shopId)
  465. {
  466. $orderData = self::orderExist($orderSn, $shopId);
  467. $orderInfo = CheckOrderItemClass::getOrderItemDetail($orderSn);
  468. $itemData = [];
  469. if ($orderInfo) {
  470. foreach ($orderInfo as $v) {
  471. $info = json_decode($v['itemInfo'], true);
  472. $tmp = $info;
  473. $tmp['itemCover'] = self::groupImg($info['itemCover']);
  474. unset($v['itemInfo']);
  475. if (!isset($tmp['rank'])) {
  476. $tmp['rank'] = 'B';
  477. }
  478. $tmp = array_merge($tmp, $v);
  479. $tmp['id'] = $v['productId'];
  480. $tmp['classId'] = 0;
  481. $itemData[] = $tmp;
  482. }
  483. }
  484. $orderData = self::groupAdmin($orderData);
  485. $orderData['itemInfo'] = $itemData;
  486. $orderData['statusName'] = self::getStatusName($orderData['status']);
  487. return $orderData;
  488. }
  489. //2021.1.22 lqh 判断订单号是否存在
  490. public static function orderExist($orderSn, $shopId)
  491. {
  492. $where = [
  493. 'orderSn' => $orderSn,
  494. 'shopId' => $shopId,
  495. ];
  496. $orderData = self::getByCondition($where);
  497. if (!$orderData) {
  498. util::fail('订单不存在');
  499. }
  500. return $orderData;
  501. }
  502. // 组装 orderItem lqh 2021.1.25
  503. public static function groupOrderItem($ghsItemInfo, $orderSn)
  504. {
  505. $productData = self::getProductMapData($ghsItemInfo);
  506. //写入详情表
  507. $batchData = [];
  508. foreach ($ghsItemInfo as $v) {
  509. $tmp = [];
  510. $productId = $v['productId'];
  511. $itemId = $productData[$productId]['itemId'];
  512. $rank = $productData[$productId]['rank'] ?? 'B';// 花材级别
  513. $tmp['orderSn'] = $orderSn;
  514. $tmp['itemId'] = $itemId;
  515. $tmp['productId'] = $v['productId'];
  516. $unitNum = $productData[$productId]['ratio'] ?? 0;
  517. $tmp['itemStock'] = $productData[$productId]['stock'] ?? 0;//当时库存
  518. $itemNum = ProductClass::mergeItemNum($v['bigNum'], $v['smallNum'], $unitNum);
  519. $tmp['itemNum'] = $itemNum;// 盘点数量
  520. $tmp['itemPrice'] = $productData[$productId]['price'] ?? 0; //当时售卖的价格
  521. $tmp['itemCost'] = $productData[$productId]['cost'] ?? 0; //当时成本的价格
  522. $tmp['profitLossNum'] = bcsub($tmp['itemNum'], $tmp['itemStock'], 2); //盈亏数 = 盘点数-当时库存数
  523. $tmp['amount'] = bcmul($tmp['profitLossNum'], $tmp['itemCost'], 2);
  524. $stockFormat = ProductClass::formatStock($tmp['itemStock'], $unitNum); // 库存总单位数量转大小单位的数量
  525. $itemInfo = [
  526. 'itemName' => $productData[$productId]['name'] ?? '',//花材名称
  527. 'itemCover' => $productData[$productId]['cover'] ?? '',//花材图片
  528. 'bigNum' => $v['bigNum'] ?? 0,//数量(大单位)
  529. 'smallNum' => $v['smallNum'] ?? 0,//数量(小单位)
  530. 'bigNumStock' => $stockFormat['bigNum'],// 当时库存大单位数
  531. 'smallNumStock' => $stockFormat['smallNum'],//当时库存 小单位数
  532. 'bigNumProfitLoss' => bcsub($v['bigNum'], $stockFormat['bigNum']),//大单位的盈亏
  533. 'smallNumProfitLoss' => bcsub($v['smallNum'], $stockFormat['smallNum']),//小单位的盈亏
  534. 'itemUnit' => $unitNum ? 2 : 1,//单位
  535. 'ratio' => $unitNum,// 比例
  536. 'rank' => $rank,// 花材级别
  537. 'bigUnit' => $productData[$productId]['bigUnit'],//大单位名称 扎
  538. 'smallUnit' => $productData[$productId]['smallUnit'],//小单位名称 支
  539. ];
  540. $tmp['itemInfo'] = json_encode($itemInfo);
  541. $batchData[] = $tmp;
  542. }
  543. return $batchData;
  544. }
  545. // 组装状态码 lqh 2021.1.30
  546. public static function groupStatusName($list)
  547. {
  548. foreach ($list as $k => $val) {
  549. $status = $val['status'] ?? 0;
  550. $list[$k]['statusName'] = self::getStatusName($status);
  551. }
  552. return $list;
  553. }
  554. // 获取状态码名称
  555. public static function getStatusName($status)
  556. {
  557. return self::$statusMap[$status] ?? '';
  558. }
  559. }