StockOutOrderClass.php 14 KB

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