StockOutOrderClass.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294
  1. <?php
  2. namespace bizGhs\order\classes;
  3. use biz\shop\classes\ShopClass;
  4. use bizGhs\product\classes\ProductClass;
  5. use bizGhs\stock\classes\StockRecordClass;
  6. use common\components\dict;
  7. use common\components\orderSn;
  8. use common\components\util;
  9. use Yii;
  10. use bizGhs\base\classes\BaseClass;
  11. use bizGhs\order\traits\OrderTrait;
  12. class StockOutOrderClass extends BaseClass
  13. {
  14. use OrderTrait;
  15. const STATUS_WAIT = 1; //待出库
  16. const STATUS_COMPLETE = 2; //已出库
  17. const STATUS_CANCEL = 3; //取消出库
  18. const STATUS_BACK = 4; //退回,取消入库 (暂不用)
  19. const ACTION_WAIT = 'wait';
  20. const ACTION_CONFIRM = 'confirm'; //直接入库
  21. public static $statusMap = [
  22. self::STATUS_WAIT => '待出库',
  23. self::STATUS_COMPLETE => '已出库',
  24. self::STATUS_CANCEL => '取消出库',
  25. ];
  26. public static $baseFile = '\bizGhs\order\models\StockOutOrder';
  27. //2021.1.23 lqh 新增出库订单
  28. public static function addOrder($data)
  29. {
  30. $action = $data['action'];
  31. $data['status'] = self::STATUS_WAIT; //待入库
  32. $orderSn = orderSn::getGhsStockOutSn();
  33. $data['orderSn'] = $orderSn;
  34. $ghsItemInfo = $data['itemInfo']; // [{bigNum:0,smallNum:0,productId:1}]
  35. $ghsItemInfo = self::mergeItemInfo($ghsItemInfo);
  36. $sumNum = self::sumNumByItemInfo($ghsItemInfo);
  37. $data['bigNum'] = $sumNum['bigNum'];// 总的大单位数量 总共多少扎
  38. $data['smallNum'] = $sumNum['smallNum']; //总的小单位数量 总共多少支
  39. $outShopId = $data['outShopId'] ?? 0;
  40. $outMainId = $data['outMainId'] ?? 0;
  41. $order = self::add($data, true);
  42. //先减库存,若取消出库则加回来
  43. foreach ($ghsItemInfo as $k => $v) {
  44. $stockInfo = ProductClass::decreaseStock($v['productId'], $v['bigNum'], $v['smallNum'], true);
  45. $ghsItemInfo[$k]['oldStock'] = $stockInfo['oldStock'];
  46. $ghsItemInfo[$k]['newStock'] = $stockInfo['newStock'];
  47. }
  48. //写入详情表
  49. $batchData = self::groupOrderItem($ghsItemInfo, $orderSn);
  50. $totalCost = 0;
  51. foreach ($batchData as $outKey => $outVal) {
  52. $batchData[$outKey]['mainId'] = $outMainId;
  53. $batchData[$outKey]['shopId'] = $outShopId;
  54. $unitCost = $outVal['itemPrice'] ?? 0;
  55. $currentNum = $outVal['itemNum'] ?? 0;
  56. $currentCost = bcmul($unitCost, $currentNum, 2);
  57. $totalCost = bcadd($totalCost, $currentCost, 2);
  58. }
  59. StockOutOrderItemClass::batchAddOrderItem($batchData);
  60. //记录总成本 ssh 20221113
  61. $order->price = $totalCost;
  62. $order->save();
  63. $orderData = self::getOrderDetail($orderSn, $data['outShopId']);
  64. $orderData['shopId'] = $outShopId;
  65. $orderData['mainId'] = $outMainId;
  66. $itemInfo = $orderData['itemInfo'] ?? [];
  67. if (empty($itemInfo)) {
  68. util::fail("订单异常");
  69. }
  70. $orderData['ptStyle'] = dict::getDict('ptStyle', 'ghs');
  71. StockRecordClass::addRecordByOrder($orderData, StockRecordClass::STOCK_RECORD_TYPE_OUT_STOCK);
  72. if ($action === self::ACTION_CONFIRM) {
  73. $adminId = $data['adminId'] ?? 0;
  74. //直接出库,并且在对方门店生成待入库单
  75. $inOrder = self::confirmOrder($orderSn, $data['outShopId'], $adminId);
  76. $confirmIn = $data['confirmIn'] ?? 0;
  77. //直接确认入库
  78. if ($confirmIn == 1) {
  79. $inOrderSn = $inOrder['orderSn'] ?? '';
  80. $inShopId = $inOrder['inShopId'] ?? 0;
  81. $inShop = ShopClass::getById($inShopId, true);
  82. if (empty($inShop)) {
  83. util::fail('没有找到入库门店');
  84. }
  85. StockInOrderClass::confirmOrder($inOrderSn, $inShop, $adminId);
  86. }
  87. }
  88. return $order;
  89. }
  90. //2021.1.23 lqh 确认出库 :
  91. // 一、从状态 1 修改为 2
  92. // 二、解除解冻的库存 todo
  93. // 三、增加流水记录
  94. // 四、写入一条数据到入库门店的入库订单表(生成入库订单号)
  95. // 五、将入库订单号保存当前记录中
  96. public static function confirmOrder($orderSn, $shopId, $adminId)
  97. {
  98. $outTime = date("Y-m-d H:i:s");
  99. $data = [
  100. 'status' => self::STATUS_COMPLETE,
  101. 'adminId' => $adminId,
  102. 'outTime' => $outTime,
  103. ];
  104. $orderData = self::getOrderDetail($orderSn, $shopId);
  105. if ($orderData['status'] != self::STATUS_WAIT) {
  106. util::fail("订单已处理");
  107. }
  108. $orderId = $orderData['id'] ?? 0;
  109. //修改状态
  110. self::updateById($orderId, $data);
  111. $itemInfo = $orderData['itemInfo'] ?? [];
  112. if (empty($itemInfo)) {
  113. util::fail("订单异常");
  114. }
  115. $orderData['shopId'] = $shopId;
  116. //写入一条数据到入库门店的入库订单表,生成入库订单号
  117. $inOrderData = StockInOrderClass::addOrder($orderData);
  118. $inOrderSn = $inOrderData['orderSn'];
  119. //更新入库订单号
  120. self::updateById($orderId, ['inOrderSn' => $inOrderSn]);
  121. //完成,提交事务
  122. return $inOrderData;
  123. }
  124. //2021.1.23. lqh 取消出库 :
  125. //一、 从状态1 修改为 3
  126. //二、 加回库存
  127. public static function cancelOrder($orderSn, $shopId, $adminId)
  128. {
  129. $where = [
  130. 'orderSn' => $orderSn,
  131. 'status' => self::STATUS_WAIT,
  132. 'outShopId' => $shopId,
  133. ];
  134. self::orderExist($where);
  135. $data = [
  136. 'status' => self::STATUS_CANCEL,
  137. 'adminId' => $adminId,
  138. ];
  139. $orderData = self::getOrderDetail($orderSn, $shopId);
  140. $orderData['shopId'] = $shopId;
  141. //加库存
  142. $itemInfo = $orderData['itemInfo'] ?? [];
  143. if (empty($itemInfo)) {
  144. util::fail("订单异常");
  145. }
  146. foreach ($itemInfo as $k => $v) {
  147. $stockInfo = ProductClass::addStockByItemNum($v['productId'], $v['itemNum']);
  148. $itemInfo[$k]['oldStock'] = $stockInfo['oldStock'];
  149. $itemInfo[$k]['itemStock'] = $stockInfo['oldStock'];
  150. $itemInfo[$k]['newStock'] = $stockInfo['newStock'];
  151. }
  152. $orderData['itemInfo'] = $itemInfo;
  153. StockRecordClass::addRecordByOrder($orderData, StockRecordClass::STOCK_RECORD_TYPE_IN_STOCK_CANCEL);
  154. self::updateByCondition($where, $data);
  155. }
  156. //2021.1.23 lqh 订单列表
  157. public static function getOrderList($where)
  158. {
  159. $data = self::getList('*', $where, 'addTime DESC');
  160. $list = isset($data['list']) && !empty($data['list']) ? $data['list'] : [];
  161. if (empty($list)) {
  162. return $data;
  163. }
  164. $ids = array_column($list, 'inShopId');
  165. $ids = array_filter(array_unique($ids));
  166. $shopInfo = ShopClass::getByIds($ids, null, 'id');
  167. foreach ($list as $key => $val) {
  168. $inShopId = $val['inShopId'] ?? 0;
  169. $list[$key]['inShopName'] = $shopInfo[$inShopId]['shopName'] ?? '';
  170. }
  171. $data['list'] = $list;
  172. $data['list'] = self::groupAdminList($list);
  173. $data['list'] = self::groupStatusName($data['list']);
  174. return $data;
  175. }
  176. //2021.1.23 lqh 订单详情
  177. public static function getOrderDetail($orderSn, $shopId)
  178. {
  179. $orderData = self::orderExist(['orderSn' => $orderSn, 'outShopId' => $shopId]);
  180. $orderInfo = StockOutOrderItemClass::getOrderItemDetail($orderSn);
  181. $itemData = [];
  182. if ($orderInfo) {
  183. foreach ($orderInfo as $v) {
  184. $info = json_decode($v['itemInfo'], true);
  185. $tmp = $info;
  186. $tmp['itemCover'] = self::groupImg($info['itemCover']);
  187. unset($v['itemInfo']);
  188. //兼容 旧数据,没有 rank (花材等级 默认给B)
  189. if (!isset($tmp['rank'])) {
  190. $tmp['rank'] = 'B';
  191. }
  192. $tmp = array_merge($tmp, $v);
  193. $itemData[] = $tmp;
  194. }
  195. }
  196. $orderData = self::groupAdmin($orderData);
  197. $orderData['itemInfo'] = $itemData;
  198. $orderData['statusName'] = self::getStatusName($orderData['status']);
  199. $inShopId = $orderData['inShopId'];
  200. $inShop = ShopClass::getById($inShopId);
  201. $orderData['shopName'] = $inShop['shopName'] ?? '';
  202. return $orderData;
  203. }
  204. //2021.1.23 lqh 判断定时是否存在
  205. public static function orderExist($where)
  206. {
  207. $orderData = self::getByCondition($where);
  208. if (!$orderData) {
  209. util::fail('订单不存在或不能取消');
  210. }
  211. return $orderData;
  212. }
  213. // 组装 orderItem lqh 2021.1.25
  214. public static function groupOrderItem($ghsItemInfo, $orderSn)
  215. {
  216. $productData = self::getProductMapData($ghsItemInfo);
  217. //写入详情表
  218. $batchData = [];
  219. foreach ($ghsItemInfo as $v) {
  220. $tmp = [];
  221. $productId = $v['productId'];
  222. $itemId = $productData[$productId]['itemId'];
  223. $rank = $productData[$productId]['rank'] ?? 'B';// 花材级别
  224. $tmp['orderSn'] = $orderSn;
  225. $tmp['itemId'] = $itemId;
  226. $tmp['productId'] = $v['productId'];
  227. $unitNum = $productData[$productId]['ratio'] ?? 0;
  228. $tmp['itemStock'] = $v['oldStock'];//当时库存
  229. $tmp['newStock'] = $v['newStock'];//当时库存
  230. $tmp['itemNum'] = ProductClass::mergeItemNum($v['bigNum'], $v['smallNum'], $unitNum);// 数量
  231. $tmp['itemPrice'] = $productData[$productId]['cost'] ?? 0; //当时成本价
  232. $tmp['price'] = $productData[$productId]['price'] ?? 0; //当时批发价
  233. $tmp['skPrice'] = $productData[$productId]['skPrice'] ?? 0; //当时零售价
  234. $stockFormat = ProductClass::formatStock($tmp['itemStock'], $unitNum); // 库存总单位数量转大小单位的数量
  235. $itemInfo = [
  236. 'itemName' => $productData[$productId]['name'] ?? '',//花材名称
  237. 'itemCover' => $productData[$productId]['cover'] ?? '',//花材图片
  238. 'bigNum' => $v['bigNum'] ?? 0,//数量(大单位)
  239. 'smallNum' => $v['smallNum'] ?? 0,//数量(小单位)
  240. 'bigNumStock' => $stockFormat['bigNum'],// 当时库存大单位数
  241. 'smallNumStock' => $stockFormat['smallNum'],//当时库存 小单位数
  242. 'itemUnit' => $unitNum ? 2 : 1,//单位数量 2表示有两个单位(e.g 扎和支) 1表是只有一个单位(e.g 扎)
  243. 'ratio' => $unitNum,// 比例
  244. 'rank' => $rank,// 花材级别
  245. 'bigUnit' => $productData[$productId]['bigUnit'],//大单位名称 扎
  246. 'smallUnit' => $productData[$productId]['smallUnit'],//小单位名称 支
  247. ];
  248. $tmp['itemInfo'] = json_encode($itemInfo);
  249. $batchData[] = $tmp;
  250. }
  251. return $batchData;
  252. }
  253. // 组装状态码 lqh 2021.1.30
  254. public static function groupStatusName($list)
  255. {
  256. foreach ($list as $k => $val) {
  257. $status = $val['status'] ?? 0;
  258. $list[$k]['statusName'] = self::getStatusName($status);
  259. }
  260. return $list;
  261. }
  262. // 获取状态码名称
  263. public static function getStatusName($status)
  264. {
  265. return self::$statusMap[$status] ?? '';
  266. }
  267. }