### 檢查訂單錄入SKU是否符合發貨條件
**位置:**
Common\Lib\FlowLib.class.php
**參數:**
* @param $id int 訂單ID
* @param $order_type int 訂單類型
* @param $shipper_id int 發貨位置ID
* @param $sku string 錄入的SKU
* @param $num int 發貨數量
* @return 不滿足條件提示信息(失敗)或 SKU的ID
**調用:**
* $flow = new FlowLib();
* $order_arr = $flow->checkSku($id, $order_type, $shipper_id, $sku, $num);
**完整代碼:**
~~~
/**
* 檢查SKU的正確性和庫存
* @param $id int 訂單ID
* @param $order_type int 訂單類型
* @param $shipper_id int 發貨位置ID
* @param $sku string 發貨的SKU
* @param $num int 發貨數量
* @return array
* whz 2018-01-25
*
*/
public function checkSku($id, $order_type, $shipper_id, $sku, $num) {
//1、判斷導入SKU不能為空
if ($sku == "") {
return array('success'=>false, 'code'=>201, 'msg'=>'導入SKU不能為空!');
}
//2、判斷導入發貨數量不能為空
if ($num == "") {
return array('success'=>false, 'code'=>202, 'msg'=>'導入發貨數量不能為空!');
}
//3、判斷導入發貨數量必須是數字
if (!is_numeric($num)) {
return array('success'=>false, 'code'=>203, 'msg'=>'導入發貨數量必須是數字!');
}
//4、判斷SKU發貨數量是否小于0
if ($num <= 0) {
return array('success'=>false, 'code'=>204, 'msg'=>$sku.',填寫發貨數量必須大于0!');
}
//5、根據SKU查詢SKU的ID,判斷SKU是否存在
$sku_id = M('goods_sku')
->field('id')
->where(array('goods_sku'=>$sku, 'is_delete'=>0))
->find();
if (count($sku_id) == 0) {
return array('success'=>false, 'code'=>205, 'msg'=>$sku . ',SKU不存在!');
}
$sku_id = $sku_id['id'];
//6、判斷SKU是否訂單已經錄入過
$map = array(
'type' => $order_type,
'order_id' => $id,
'sku_id' => $sku_id,
'sku' => $sku,
'is_delete' => 0
);
$exit_sku = M('wms_sku')->where($map)->count();
if ($exit_sku > 0) {
return array('success'=>false, 'code'=>206, 'msg'=>$sku . ',當前訂單已錄入!');
}
//7、根據SKU的ID和發貨位置ID去商品唯一碼表查詢可發貨的庫存
//訂單類型:配貨單、移庫單,發貨位置是倉庫
if ($order_type == 1 || $order_type == 4) {
//查詢倉庫名
$delivery = get_warehouse($shipper_id);
$where['warehouse'] = $shipper_id;
//配貨、移庫的商品必須在倉庫
$where['inventory_status'] = array('in',array(1,2,3,5,6));
$where['delivery_status'] = 1;
}
//訂單類型:調撥單、退倉單,發貨位置是門店
if ($order_type == 2 || $order_type == 3) {
//查詢門店名
$delivery = get_shops_name($shipper_id);
$where['max_shops_id'] = $shipper_id;
//調撥、退倉的商品必須在門店
$where['inventory_status'] = array('in',array(1,2,3,5,6));
$where['delivery_status'] = 2;
}
//屬于同一個SKU的唯一碼的sku_id相同
$where['sku_id'] = $sku_id;
$where['is_delete'] = 0;
//查詢SKU庫存
$goodcount = M('goods_no')
->where($where)
->count();
//8、判斷是否有可發貨的庫存
if ($goodcount <1) {
return array('success'=>false, 'code'=>207, 'msg'=>$delivery . ',未找到SKU為:' . $sku . '相關商品信息!');
}
//9、減去已經錄入SKU的發貨數量()
$num_sku = M('wms_flow as r')
->field('u.num')
->join('coscia_wms_sku as u on r.id=u.order_id','left')
->where(array('u.type'=>$order_type, 'u.sku'=>$sku, 'u.is_delete'=>0, 'r.order_type'=>$order_type, 'r.status'=>array('in',array(0,1))))
->select();
$num_skus = 0;
foreach ($num_sku as $key => $value) {
$num_skus += $value['num'];
}
$nums = $goodcount - $num_skus;
//10、判斷發貨數量是否大于發貨庫存
if ((int)$num > (int)$nums) {
return array('success'=>false, 'code'=>208, 'msg'=>$sku . ',原因:庫存不足,可發庫存為:' . $goodcount . ',減去已經錄入SKU的發貨數量:' . $num_skus . ',' . $delivery . '庫存量為:' . $nums . ' !');
}
//11、SKU和發貨數量沒有問題返回SKU的ID
return $sku_id;
}
~~~
- 模版
- 前言
- 項目架構
- 項目規范
- HTML
- CSS
- Javascript
- PHP
- MySQL
- 注意規范
- 開發版本管理
- 開發流程
- 系統配置
- 阿里云服務器配置
- 計劃任務配置說明
- 開發示例
- Page分頁
- Search_param搜索結果賦值
- Add新增
- Edit編輯
- Ajax表單驗證
- Ajax二級聯動
- Excel 導出數據首位不去0的方法
- POS總部控制
- 下載CSV格式的模板
- 訂單唯一碼表和訂單SKU表實收金額生成
- 快捷日期選擇
- JS函數
- ajax_send
- ajax_result
- createQrCodes
- createBarCodes
- printTpl
- JS插件
- BootstrapValidator表單驗證插件
- Address省市區插件
- Bootstrap-datepicker日期插件
- Bootstrap-select多選框插件
- Toastr消息提示插件
- PalyAudit掃描聲音提示插件
- WebUploader多圖片上傳插件
- Ueditor富文本編輯器插件
- Function
- alert
- object_to_array
- array_to_object
- get_address
- set_param_url
- get_shops_name
- get_user_name
- get_warehouse
- get_cheapest_sku
- print_attr(新)
- print_img(新)
- get_spu_no(新)
- get_type_name(新)
- get_brand_en(新)
- get_cat_name(新)
- get_attr_name(新)
- spu_cat_info(新)
- get_time_event_price
- get_vendors
- check_total_reduce
- check_total_discount
- get_inventory
- get_delivery
- get_sale_inventory
- get_customer_name
- phone_protection
- get_order_no
- get_event_name
- get_order_status
- get_item_status
- get_ditch_name
- get_card_no
- get_shop_sales
- get_pay_name
- get_season
- amt_format
- get_cat_parent
- print_attr_id
- round_bcadd
- round_bcsub
- round_bcmul
- round_bcdiv
- get_account_name
- Controller
- Common_BaseController
- check_membership_card
- get_menu_list
- importErrorMassage
- Wpos_IndexController
- get_customer_vip_card
- get_shops_id
- calculate_active_integral
- check_numbers_active
- check_goods_active
- Woms_IndexController
- Model
- View
- category
- cycle_date.html
- shop_select門店多選搜索框
- 品牌A-Z排序多選brand_mc.html
- 供應商代碼A-Z排序vendor_no_mc.html
- Lib
- BuyerLib
- WarehouseLib
- EventLib
- getTimeEventPrice
- getVipType
- getEvent
- orderTotalEvent
- orderTimeEvent
- getTotalReduce
- getTotalDiscount
- SaleLib
- CustomerLib
- addCustomerService
- GiftcardLib
- WechatLib
- wxRefund
- OrdersLib
- orderLog
- calculatePayinAmount
- calculateSubtotal
- correctPayinAmount
- saveOrderAddress
- getOrderAddress
- setDeliveryNo
- SyncLib
- updateOuterStock
- UserLib
- createCommission
- FlowLib
- orderList
- addOrder
- addLog
- orderInfo
- checkSku
- orderSave
- orderStop
- orderExecute
- skuEdit
- orderPrinta
- scanGoods
- boxClose
- orderOut
- take
- bview
- check
- deliveryStatus
- checkGoods
- GoodsLib
- createGoodsNo
- createNewGoodsNo
- getSystemStyleNo
- getDim
- MallLib
- smsLog
- GoodsBaseLib
- getBrandInfo
- getBrandsInfo
- getAttrIdArray
- getPrintAttr
- getMustAttr
- getCatIdInfo
- valTypeId
- valsTypeId
- getCatNoInfo
- getCatInfo
- getAttrArr
- getAttrInfo
- getValInfo
- getAttrId
- getValId
- getAttrSeaon
- getValueId
- PointsLog
- pointsIn
- pointsUp
- EcGoodsLib
- getSkuInventory
- Tools
- CsvTools
- csvImport
- csvExport
- ExcelTools
- importExcel
- exportExcel
- exportHeadExcel
- MailTools
- SmsTools
- sendMessage
- UploadTools
- ExportTools
- exportData
- TaobaoTools
- getOnsaleItems
- getSkusItems
- PicturesTools
- uploadPicture
- Plugins
- WxBase
- Taobao
- 問題反饋