'待出库',
self::STATUS_COMPLETE => '已出库',
self::STATUS_CANCEL => '取消出库',
];
public static $baseFile = '\bizGhs\order\models\StockOutOrder';
//2021.1.23 lqh 新增出库订单
public static function addOrder($data)
{
$action = $data['action'];
$data['status'] = self::STATUS_WAIT; //待入库
$orderSn = orderSn::getGhsStockOutSn();
$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']; //总的小单位数量 总共多少支
$outShopId = $data['outShopId'] ?? 0;
$outMainId = $data['outMainId'] ?? 0;
$staffName = $data['staffName'] ?? '';
$ids = array_column($ghsItemInfo, 'productId');
$productList = ProductClass::getAllByCondition(['id' => ['in', $ids]], null, 'id,avCost', 'id');
$order = self::add($data, true);
$map = [];
//先减库存,若取消出库则加回来
foreach ($ghsItemInfo as $k => $v) {
$productId = $v['productId'] ?? 0;
$product = $productList[$productId] ?? [];
$avCost = $product['avCost'] ?? 0;
$stockInfo = ProductClass::decreaseStock($v['productId'], $v['bigNum'], $v['smallNum'], true, false, ['cost' => $avCost]);
$ghsItemInfo[$k]['oldStock'] = $stockInfo['oldStock'];
$ghsItemInfo[$k]['newStock'] = $stockInfo['newStock'];
$newAvCost = $stockInfo['avCost'] ?? 0;
$totalCost = $stockInfo['totalCost'] ?? 0;
$totalStock = $stockInfo['totalStock'] ?? 0;
$changeCost = $stockInfo['changeCost'] ?? 0;
$unitCost = $stockInfo['unitCost'] ?? 0;
$map[$productId] = ['avCost' => $newAvCost, 'totalCost' => $totalCost, 'totalStock' => $totalStock, 'changeCost' => $changeCost,'unitCost'=>$unitCost];
}
//写入详情表
$batchData = self::groupOrderItem($ghsItemInfo, $orderSn);
$totalCost = 0;
foreach ($batchData as $outKey => $outVal) {
$batchData[$outKey]['mainId'] = $outMainId;
$batchData[$outKey]['shopId'] = $outShopId;
$unitCost = $outVal['itemPrice'] ?? 0;
$currentNum = $outVal['itemNum'] ?? 0;
$currentCost = bcmul($unitCost, $currentNum, 2);
$totalCost = bcadd($totalCost, $currentCost, 2);
}
StockOutOrderItemClass::batchAddOrderItem($batchData);
//记录总成本 ssh 20221113
$order->price = $totalCost;
$order->save();
$orderData = self::getOrderDetail($orderSn, $data['outShopId']);
$orderData['shopId'] = $outShopId;
$orderData['mainId'] = $outMainId;
$orderData['staffName'] = $staffName;
$orderData['relateName'] = $staffName;
$itemInfo = $orderData['itemInfo'] ?? [];
if (empty($itemInfo)) {
util::fail("订单异常");
}
//把平均成本相关参数加进入,存到库存变动明细里去 ssh
foreach ($itemInfo as $cKey => $cVal) {
$productId = $cVal['productId'] ?? 0;
$mapItem = $map[$productId] ?? [];
$avCost = $mapItem['avCost'] ?? 0;
$totalCost = $mapItem['totalCost'] ?? 0;
$totalStock = $mapItem['totalStock'] ?? 0;
$changeCost = $mapItem['changeCost'] ?? 0;
$unitCost = $mapItem['unitCost']??0;
$itemInfo[$cKey]['avCost'] = $avCost;
$itemInfo[$cKey]['totalCost'] = $totalCost;
$itemInfo[$cKey]['totalStock'] = $totalStock;
$itemInfo[$cKey]['changeCost'] = $changeCost;
$itemInfo[$cKey]['unitCost'] = $unitCost;
}
$orderData['itemInfo'] = $itemInfo;
$orderData['ptStyle'] = dict::getDict('ptStyle', 'ghs');
StockRecordClass::addRecordByOrder($orderData, StockRecordClass::STOCK_RECORD_TYPE_OUT_STOCK);
if ($action === self::ACTION_CONFIRM) {
$adminId = $data['adminId'] ?? 0;
//直接出库,并且在对方门店生成待入库单
$inOrder = self::confirmOrder($orderSn, $data['outShopId'], $adminId);
$confirmIn = $data['confirmIn'] ?? 0;
//直接确认入库
if ($confirmIn == 1) {
$inOrderSn = $inOrder['orderSn'] ?? '';
$inShopId = $inOrder['inShopId'] ?? 0;
$inShop = ShopClass::getById($inShopId, true);
if (empty($inShop)) {
util::fail('没有找到入库门店');
}
StockInOrderClass::confirmOrder($inOrderSn, $inShop, $adminId);
}
}
return $order;
}
//2021.1.23 lqh 确认出库 :
// 一、从状态 1 修改为 2
// 二、解除解冻的库存
// 三、增加流水记录
// 四、写入一条数据到入库门店的入库订单表(生成入库订单号)
// 五、将入库订单号保存当前记录中
public static function confirmOrder($orderSn, $shopId, $adminId)
{
$outTime = date("Y-m-d H:i:s");
$data = [
'status' => self::STATUS_COMPLETE,
'adminId' => $adminId,
'outTime' => $outTime,
];
$orderData = self::getOrderDetail($orderSn, $shopId);
if ($orderData['status'] != self::STATUS_WAIT) {
util::fail("订单已处理");
}
$orderId = $orderData['id'] ?? 0;
//修改状态
self::updateById($orderId, $data);
$itemInfo = $orderData['itemInfo'] ?? [];
if (empty($itemInfo)) {
util::fail("订单异常");
}
$orderData['shopId'] = $shopId;
//写入一条数据到入库店的入库订单表,生成入库订单号
$inOrderData = StockInOrderClass::addOrder($orderData);
$inOrderSn = $inOrderData['orderSn'];
//更新入库订单号
self::updateById($orderId, ['inOrderSn' => $inOrderSn]);
//完成,提交事务
return $inOrderData;
}
//2021.1.23. lqh 取消出库 :
//一、 从状态1 修改为 3
//二、 加回库存
public static function cancelOrder($orderSn, $shopId, $adminId)
{
$where = [
'orderSn' => $orderSn,
'status' => self::STATUS_WAIT,
'outShopId' => $shopId,
];
self::orderExist($where);
$data = [
'status' => self::STATUS_CANCEL,
'adminId' => $adminId,
];
$orderData = self::getOrderDetail($orderSn, $shopId);
$orderData['shopId'] = $shopId;
//加库存
$itemInfo = $orderData['itemInfo'] ?? [];
if (empty($itemInfo)) {
util::fail("订单异常");
}
foreach ($itemInfo as $k => $v) {
$stockInfo = ProductClass::addStockByItemNum($v['productId'], $v['itemNum']);
$itemInfo[$k]['oldStock'] = $stockInfo['oldStock'];
$itemInfo[$k]['itemStock'] = $stockInfo['oldStock'];
$itemInfo[$k]['newStock'] = $stockInfo['newStock'];
}
$orderData['itemInfo'] = $itemInfo;
StockRecordClass::addRecordByOrder($orderData, StockRecordClass::STOCK_RECORD_TYPE_IN_STOCK_CANCEL);
self::updateByCondition($where, $data);
}
//2021.1.23 lqh 订单列表
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;
}
$ids = array_column($list, 'inShopId');
$ids = array_filter(array_unique($ids));
$shopInfo = ShopClass::getByIds($ids, null, 'id');
foreach ($list as $key => $val) {
$inShopId = $val['inShopId'] ?? 0;
$list[$key]['inShopName'] = $shopInfo[$inShopId]['shopName'] ?? '';
}
$data['list'] = $list;
$data['list'] = self::groupAdminList($list);
$data['list'] = self::groupStatusName($data['list']);
return $data;
}
//2021.1.23 lqh 订单详情
public static function getOrderDetail($orderSn, $shopId)
{
$orderData = self::orderExist(['orderSn' => $orderSn, 'outShopId' => $shopId]);
$orderInfo = StockOutOrderItemClass::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']);
//兼容 旧数据,没有 rank (花材等级 默认给B)
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']);
$inShopId = $orderData['inShopId'];
$inShop = ShopClass::getById($inShopId);
$orderData['shopName'] = $inShop['shopName'] ?? '';
return $orderData;
}
//2021.1.23 lqh 判断定时是否存在
public static function orderExist($where)
{
$orderData = self::getByCondition($where);
if (!$orderData) {
util::fail('订单不存在或不能取消');
}
return $orderData;
}
// 组装 orderItem lqh 2021.1.25
public static function groupOrderItem($ghsItemInfo, $orderSn)
{
$productData = self::getProductMapData($ghsItemInfo);
//写入详情表
$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 = $productData[$productId]['ratio'] ?? 0;
$tmp['itemStock'] = $v['oldStock'];//当时库存
$tmp['newStock'] = $v['newStock'];//当时库存
$tmp['itemNum'] = ProductClass::mergeItemNum($v['bigNum'], $v['smallNum'], $unitNum);// 数量
$tmp['itemPrice'] = $productData[$productId]['avCost'] ?? 0; //平均成本
$tmp['price'] = $productData[$productId]['price'] ?? 0; //当时批发价
$tmp['skPrice'] = $productData[$productId]['skPrice'] ?? 0; //当时零售价
$tmp['hjPrice'] = $productData[$productId]['hjPrice'] ?? 0; //当时会员价
$tmp['cost'] = $productData[$productId]['avCost'] ?? 0; //平均成本
$stockFormat = ProductClass::formatStock($tmp['itemStock'], $unitNum); // 库存总单位数量转大小单位的数量
$itemInfo = [
'itemName' => $productData[$productId]['name'] ?? '',//花材名称
'itemCover' => $productData[$productId]['cover'] ?? '',//花材图片
'bigNum' => $v['bigNum'] ?? 0,//数量(大单位)
'smallNum' => $v['smallNum'] ?? 0,//数量(小单位)
'bigNumStock' => $stockFormat['bigNum'],// 当时库存大单位数
'smallNumStock' => $stockFormat['smallNum'],//当时库存 小单位数
'itemUnit' => $unitNum ? 2 : 1,//单位数量 2表示有两个单位(e.g 扎和支) 1表是只有一个单位(e.g 扎)
'ratio' => $unitNum,// 比例
'rank' => $rank,// 花材级别
'bigUnit' => $productData[$productId]['bigUnit'],//大单位名称 扎
'smallUnit' => $productData[$productId]['smallUnit'],//小单位名称 支
];
$tmp['itemInfo'] = json_encode($itemInfo);
$batchData[] = $tmp;
}
return $batchData;
}
// 组装状态码 lqh 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] ?? '';
}
public static function printOrder($out, $shop)
{
$orderSn = $out->orderSn;
$returnList = StockOutOrderItemClass::getAllByCondition(['orderSn' => $orderSn], null, '*');
if (empty($returnList)) {
return false;
}
$arr = array_chunk($returnList, 50);
$totalPage = count($arr);
foreach ($arr as $key => $itemList) {
$sjName = $shop->merchantName ?? '';
$shopName = $shop->shopName ?? '';
$currentName = $shopName == '首店' ? $sjName : $sjName . ' ' . $shopName;
$content = '';
$content .= "{$currentName}
";
$content .= "出库单
";
$content .= '' . $orderSn . '
';
$content .= '' . date("m-d H:i", strtotime($out->outTime)) . '
';
if ($totalPage > 1) {
$currentPage = bcadd($key, 1);
$content .= "第{$currentPage}页,共{$totalPage}页
";
}
$content .= '
';
$content .= '商品 数量
';
$content .= '--------------------------------
';
if (isset($itemList) && !empty($itemList)) {
foreach ($itemList as $current) {
$json = $current['itemInfo'] ?? '';
$info = json_decode($json, true);
$name = $info['itemName'] ?? '';
$num = $info['bigNum'] ?? 0;
$unitName = $info['bigUnit'] ?? '';
$show = $name . ' ' . $num . $unitName;
$content .= '' . $show . '
';
$content .= '--------------------------------
';
}
}
$content .= '
';
$content .= '
';
$content .= '
';
$content .= '签名:
';
$content .= '
';
$content .= '
';
$content .= '
';
$shopId = $shop->id;
$ext = ShopExtClass::getByCondition(['shopId' => $shopId]);
$printSn = $ext['printSn'] ?? '';
if (!empty($printSn)) {
$p = new printUtil($printSn);
$p->printMsg($content, $shop);
}
}
$out->printNum = bcadd($out->printNum, 1);
$out->save();
}
}