| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208 |
- <?php
- namespace bizGhs\order\classes;
- use bizGhs\admin\classes\AdminClass;
- use bizGhs\product\classes\ProductClass;
- use bizGhs\stock\services\StockRecordService;
- use common\components\orderSn;
- use common\components\util;
- use Yii;
- use bizGhs\base\classes\BaseClass;
- use common\services\xhItemService;
- use bizGhs\order\traits\OrderTrait;
- class CheckOrderClass extends BaseClass
- {
- use OrderTrait;
- public static $baseFile = '\bizGhs\order\models\CheckOrder';
- const STATUS_DRAFT = 1; //草稿
- const STATUS_COMPLETE = 2; //完成
- public static $statusMap = [
- self::STATUS_DRAFT => '草稿',
- self::STATUS_COMPLETE => '已盘点',
- ];
- //2021.1.22 linqh 操作订单 添加/保存草稿/草稿编辑保存: 区别在添加是立即改库存和记录流水记录,而保存草稿是只保存订单信息
- public static function opOrder($data,$draft=false,$update=false)
- {
- $merchantId = $data['merchantId'];
- $shopId = $data['shopId'];
- $adminId = $data['adminId']??0;
- if($draft){
- //保存草稿
- $data['status'] = self::STATUS_DRAFT;
- }else{
- //确定保存
- $data['status'] = self::STATUS_COMPLETE;
- }
- if($update){
- $orderSn = $data['orderSn'];
- }else{
- $orderSn =orderSn::getGhsCheckSn();
- }
- $data['orderSn'] = $orderSn;
- $ghsItemInfo = $data['itemInfo']; // [{bigNum:0,smallNum:0,productId:1}]
- $ghsItemInfo = self::mergeItemInfo($ghsItemInfo);
- $sumNum = self::sumNumByItemInfo($ghsItemInfo);
- $data['bigNum'] = $sumNum['bigNum'];// 总的大单位数量 总共多少扎
- $data['smallNum'] = $sumNum['smallNum']; //总的小单位数量 总共多少支
- $connection = Yii::$app->db;
- $transaction = $connection->beginTransaction();
- try{
- if($update){
- //删除 ?? 是否合理,暂时先这样处理
- self::deleteByCondition(['orderSn'=>$orderSn]);
- }
- $order = self::add($data);
- //写入详情表
- $batchData = self::groupOrderItem($ghsItemInfo,$orderSn);
- if($update){
- //先删除
- CheckOrderItemClass::deleteByCondition(['orderSn'=>$orderSn]);
- }
- CheckOrderItemClass::batchAddOrderItem($batchData);
- if($draft===false){
- //非草稿
- //盘点完成完成,直接将库存中的数量改为当时盘点的数量
- foreach ($batchData as $v){
- $productId = $v['productId'];
- //修改库存数量
- ProductClass::updateStockById($productId,$v['itemNum'],$adminId);
- //流水记录
- $record = [];
- $record['merchantId'] = $merchantId;
- $record['shopId'] = $shopId;
- $record['orderSn'] = $orderSn;
- $record['itemId'] = $v['itemId'];
- $record['itemNum'] = $v['profitLossNum'];//盈亏数
- $record['oldStock'] = $v['itemStock'];
- $record['newStock'] = $v['itemNum']; //新库存直接等于盘点的数量
- StockRecordService::addCheckOrderRecord($record);
- }
- }
- $transaction->commit();
- return $order;
- }catch (\Exception $exception){
- $transaction->rollBack();
- util::fail('保存失败'.$exception->getMessage());
- }
- }
- //2021.1.22 linqh 订单列表
- public static function getOrderList($where)
- {
- $data = self::getList('*', $where, 'addTime DESC');
- $list = isset($data['list']) && !empty($data['list']) ? $data['list'] : [];
- if (empty($list)) {
- return $data;
- }
- $data['list'] = $list;
- $data['list'] = self::groupAdminList($list);
- $data['list'] = self::groupStatusName($data['list']);
- return $data;
- }
- //2021.1.22 订单详情
- //获取订单详情信息 lqh 2021.1.20
- public static function getOrderDetail($orderSn,$shopId)
- {
- $orderData = self::orderExist($orderSn,$shopId);
- $orderInfo = CheckOrderItemClass::getOrderItemDetail($orderSn);
- $itemData = [];
- if($orderInfo) {
- foreach ($orderInfo as $v) {
- $info = json_decode($v['itemInfo'],true);
- $tmp = $info;
- $tmp['itemCover'] = self::groupImg($info['itemCover']);
- unset($v['itemInfo']);
- if(!isset($tmp['rank'])){
- $tmp['rank']= 'B';
- }
- $tmp = array_merge($tmp,$v);
- $itemData[] = $tmp;
- }
- }
- $orderData = self::groupAdmin($orderData);
- $orderData['itemInfo'] = $itemData;
- $orderData['statusName'] = self::getStatusName($orderData['status']);
- return $orderData;
- }
- //2021.1.22 linqh 判断订单号是否存在
- public static function orderExist($orderSn,$shopId)
- {
- $where = [
- 'orderSn'=>$orderSn,
- 'shopId'=>$shopId,
- ];
- $orderData = self::getByCondition($where);
- if(!$orderData) {
- util::fail('订单不存在');
- }
- return $orderData;
- }
- // 组装 orderItem linqh 2021.1.25
- public static function groupOrderItem($ghsItemInfo,$orderSn)
- {
- $productData = self::getProductMapData($ghsItemInfo);
- $itemIds = array_column($productData,'itemId');
- $itemData = xhItemService::getByIds($itemIds);
- $itemData = array_column($itemData, NULL, 'id');
- //写入详情表
- $batchData = [];
- foreach($ghsItemInfo as $v){
- $tmp = [];
- $productId = $v['productId'];
- $itemId = $productData[$productId]['itemId'];
- $rank = $productData[$productId]['rank']??'B';// 花材级别
- $tmp['orderSn'] = $orderSn;
- $tmp['itemId'] = $itemId;
- $tmp['productId'] = $v['productId'];
- $unitNum = $itemData[$itemId]['unitNum']??0;
- $tmp['itemStock'] = $productData[$productId]['stock']??0;//当时库存
- $tmp['itemNum'] = ProductClass::mergeItemNum($v['bigNum'],$v['smallNum'],$unitNum);// 盘点数量
- $tmp['itemPrice'] =$productData[$productId]['price']??0; //当时售卖的价格
- $tmp['profitLossNum'] = bcsub( $tmp['itemNum']- $tmp['itemStock'],2); //盈亏数 = 盘点数-当时库存数
- $stockFormat= ProductClass::formatStock($tmp['itemStock'],$unitNum); // 库存总单位数量转大小单位的数量
- $itemInfo = [
- 'itemName'=> $itemData[$itemId]['name']??'',//花材名称
- 'itemCover'=> $itemData[$itemId]['cover']??'',//花材图片
- 'bigNum'=> $v['bigNum']??0,//数量(大单位)
- 'smallNum'=> $v['smallNum']??0,//数量(小单位)
- 'bigNumStock'=> $stockFormat['bigNum'],// 当时库存大单位数
- 'smallNumStock'=> $stockFormat['smallNum'],//当时库存 小单位数
- 'bigNumProfitLoss'=>bcsub($v['bigNum'],$stockFormat['bigNum'],2),//大单位的盈亏
- 'smallNumProfitLoss'=>bcsub($v['smallNum'],$stockFormat['smallNum'],2),//小单位的盈亏
- 'itemUnit'=> $unitNum?2:1,//单位
- 'ratio'=>$unitNum,// 比例
- 'rank'=>$rank,// 花材级别
- 'bigUnit'=> xhItemService::getUnitName($itemData[$itemId]['bigUnit']),//大单位名称 扎
- 'smallUnit'=> xhItemService::getUnitName($itemData[$itemId]['smallUnit']),//小单位名称 支
- ];
- $tmp['itemInfo'] = json_encode($itemInfo);
- $batchData[] = $tmp;
- }
- return $batchData;
- }
- // 组装状态码 linqh 2021.1.30
- public static function groupStatusName($list)
- {
- foreach ($list as $k => $val) {
- $status = $val['status'] ?? 0;
- $list[$k]['statusName'] = self::getStatusName($status);
- }
- return $list;
- }
- // 获取状态码名称
- public static function getStatusName($status)
- {
- return self::$statusMap[$status]??'';
- }
- }
|