function act_addTNameRow($tName, $set)
{
$ret = WhIoStoreModel::addTNameRow($tName, $set);
if ($ret !== FALSE) {
return $ret;
} else {
self::$errCode = WhIoStoreModel::$errCode;
self::$errMsg = WhIoStoreModel::$errMsg;
return false;
}
}
function act_addWhShipingOrderCAT()
{
global $memc_obj;
//调用memcache获取sku信息
$jsonArr = isset($_GET['jsonArr']) ? $_GET['jsonArr'] : '';
//传过来的base64编码的json字符串(客户端要先json然后再base64))
if (empty($jsonArr)) {
self::$errCode = '0101';
self::$errMsg = 'empty jsonArr';
return 0;
}
$jsonArr = json_decode(base64_decode($jsonArr), true);
//对base64及json解码
if (!is_array($jsonArr)) {
self::$errCode = '0201';
self::$errMsg = 'error array';
return 0;
}
if (!is_array($jsonArr['shipOrderDetail'])) {
self::$errCode = '0301';
self::$errMsg = 'shipOrderDetail error array';
return 0;
}
try {
TransactionBaseModel::begin();
$originOrderId = $jsonArr['originOrderId'];
//订单ID
if (intval($originOrderId) == 0) {
self::$errCode = '0401';
self::$errMsg = 'error originOrderId';
return 0;
}
$recordNumber = $jsonArr['recordNumber'];
//订单记录各平台id号
$shipOrderDetail = $jsonArr['shipOrderDetail'];
//订单详细,为数组记录
$username = $jsonArr['username'];
//收件人
$platformUsername = $jsonArr['platformUsername'];
//对应平台的用户登陆名称,买家id
$email = $jsonArr['email'];
//客户邮箱
$countryName = $jsonArr['countryName'];
//收件人国家名称
$countrySn = $jsonArr['countrySn'];
//收件人国家简称
$state = $jsonArr['state'];
//收件人省份，州名
$city = $jsonArr['city'];
//收件人城市名称
$street = $jsonArr['street'];
//收件人街道
$address2 = $jsonArr['address2'];
//收件人地址2
$address3 = $jsonArr['address3'];
//收件人地址3
$currency = $jsonArr['currency'];
//币种
$landline = $jsonArr['landline'];
//座机
$phone = $jsonArr['phone'];
//手机
$zipCode = $jsonArr['zipCode'];
//邮政编码
$transportId = $jsonArr['transportId'];
//运输方式ID
$accountId = $jsonArr['accountId'];
//发货单对应销售账号
$orderAttributes = $jsonArr['orderAttributes'];
//发货单属性状态id,为数组
if (empty($orderAttributes) || !is_array($orderAttributes)) {
self::$errCode = '0501';
self::$errMsg = 'error orderAttributes';
return 0;
}
$pmId = $jsonArr['pmId'];
//包装材料ID
$isFixed = $jsonArr['isFixed'];
//是否固定运输方式，默认2最优运输方式；1固定运输方式
$total = $jsonArr['total'];
//发货单总价值
$channelId = $jsonArr['channelId'];
//渠道ID
$calcWeight = $jsonArr['calcWeight'];
//估算重量，单位是kg
$calcShipping = $jsonArr['calcShipping'];
//估算运费
$createdTime = $jsonArr['createdTime'] ? $jsonArr['createdTime'] : time();
//添加时间
$orderTypeId = $jsonArr['orderTypeId'] ? $jsonArr['orderTypeId'] : 1;
//发货单类别，默认为1，发货单；2为配货单
$companyId = $jsonArr['companyId'] ? $jsonArr['companyId'] : 1;
//公司名称ID，默认赛维网络科技
$storeId = $jsonArr['storeId'] ? $jsonArr['storeId'] : 1;
//仓库ID，默认为1赛维网络深圳仓库
$tName = 'wh_shipping_order';
$set = "SET username='******',platformUsername='******',email='{$email}',countryName='{$countryName}',\n\t\t\t countrySn='{$countrySn}',state='{$state}',city='{$city}',street='{$street}',address2='{$address2}',\n\t\t\t address3='{$address3}',currency='{$currency}',landline='{$landline}',\n\t\t\t phone='{$phone}',zipCode='{$zipCode}',transportId='{$transportId}',\n\t\t\t accountId='{$accountId}',pmId='{$pmId}',\n\t\t\t isFixed='{$isFixed}',total='{$total}',channelId='{$channelId}',\n\t\t\t calcWeight='{$calcWeight}',calcShipping='{$calcShipping}',createdTime='{$createdTime}',\n\t\t\t orderTypeId='{$orderTypeId}',companyId='{$companyId}',storeId='{$storeId}' ";
$insertId = WhIoStoreModel::addTNameRow($tName, $set);
if (!$insertId) {
self::$errCode = '0801';
self::$errMsg = 'addRow error';
throw new Exception('add shipOrder error');
}
$shipOrderId = $insertId;
//发货单ID
foreach ($shipOrderDetail as $detail) {
$sku = $detail['sku'];
//sku
$amount = $detail['amount'];
//配货数量
if (!preg_match("/^[A-Z0-9]+(_[A-Z0-9]+)*\$/", $sku) || intval($amount) == 0) {
self::$errCode = '0811';
self::$errMsg = 'sku or amount error';
throw new Exception('sku or amount error');
}
//echo 'sku == '.$sku.'<br/>';
$storeId = $detail['storeId'] ? $detail['storeId'] : 1;
//仓库ID，默认为1赛维网络深圳仓库
//echo '$memc_obj====';
//print_r($memc_obj);
//echo'<br/>';
$skuInfo = $memc_obj->get_extral("sku_info_" . $sku);
//调用memcache取得对应单料号或组合料号的重量
//echo '$skuInfo=======';
//print_r($skuInfo);
//echo'<br/>';
if (empty($skuInfo)) {
self::$errCode = '0814';
self::$errMsg = 'empty skuInfo';
throw new Exception('skuInfo');
}
// $ppp = $memc_obj->get_extral("pc_packing_material"); //调用memcache取得对应单料号或组合料号的重量
// //echo '$ppp=======';
// //print_r($ppp);
// //echo'<br/>';
if (!empty($skuInfo['sku']) && is_array($skuInfo['sku'])) {
//为组合料号
foreach ($skuInfo['sku'] as $key => $value) {
//循环$skuInfo下的sku的键，找出所有真实料号及对应数量,$key为组合料号下对应的真实单料号，value为对应数量
if (!preg_match("/^[A-Z0-9]+(_[A-Z0-9]+)*\$/", $key) || intval($value) == 0) {
self::$errCode = '0812';
self::$errMsg = 'sku or amount error';
throw new Exception('sku or amount error');
}
$singSkuAmount = $value * $amount;
//echo '$key == '.$key.'<br/>';
//echo '$singSkuAmount == '.$singSkuAmount.'<br/>';
$tName = 'wh_shipping_orderdetail';
$set = "SET shipOrderId='{$shipOrderId}',combineSku='{$sku}',combineNum='{$amount}',sku='{$key}',\n\t\t\t\t\t\t amount='{$singSkuAmount}',storeId='{$storeId}' ";
$insertDetailId = WhIoStoreModel::addTNameRow($tName, $set);
if (!$insertDetailId) {
self::$errCode = '0802';
self::$errMsg = 'add shipOrderDetail1 error';
throw new Exception('add shipOrderDetail1 error');
}
}
} else {
$tName = 'wh_shipping_orderdetail';
$set = "SET shipOrderId='{$shipOrderId}',sku='{$sku}',\n\t\t\t\t\t amount='{$amount}',storeId='{$storeId}' ";
$insertDetailId = WhIoStoreModel::addTNameRow($tName, $set);
//echo'++++++++++++++++++++++++++';
//echo '$insertDetailId========='.$insertDetailId.'<br/>';
if (!$insertDetailId) {
self::$errCode = '0822';
self::$errMsg = 'add shipOrderDetail2 error';
throw new Exception('add shipOrderDetail2 error');
}
}
}
//插入发货单和属性关系表
//echo '$orderAttributes=======';
//print_r($orderAttributes);
//echo'<br/>';
$tName = 'wh_order_attributes_relation';
foreach ($orderAttributes as $orderAttribute) {
if ($orderAttribute != 1 && $orderAttribute != 2) {
self::$errCode = '0805';
self::$errMsg = 'orderAttribute error';
throw new Exception('orderAttribute error');
}
$set = "SET shippingOrderId='{$shipOrderId}',attributeId='{$orderAttribute}'";
$insertARId = WhIoStoreModel::addTNameRow($tName, $set);
//echo'++++++++++++++++++++++++++';
//echo '$insertARId========='.$insertARId.'<br/>';
if ($insertARId !== 0) {
self::$errCode = '0806';
self::$errMsg = 'add insertARId error';
throw new Exception('add insertARId error');
}
}
//插入订单发货单关系表
$tName = 'wh_shipping_order_relation';
$set = "SET originOrderId='{$originOrderId}',shipOrderId='{$shipOrderId}',recordNumber='{$recordNumber}',storeId='{$storeId}' ";
$insertRelationId = WhIoStoreModel::addTNameRow($tName, $set);
if (!$insertRelationId) {
self::$errCode = '0803';
self::$errMsg = 'add relation error';
throw new Exception('add relation error');
}
TransactionBaseModel::commit();
TransactionBaseModel::autoCommit();
self::$errCode = '222';
self::$errMsg = "success";
return 1;
} catch (Exception $e) {
TransactionBaseModel::rollback();
TransactionBaseModel::autoCommit();
self::$errCode = '404';
self::$errMsg = $e->getMessage();
return 0;
}
}
function act_addTNameRow()
{
$jsonArr = isset($_GET['jsonArr']) ? $_GET['jsonArr'] : '';
//传过来的base64编码的json字符串
if (empty($jsonArr)) {
self::$errCode = 101;
self::$errMsg = '参数数组为空';
return false;
}
$jsonArr = json_decode(base64_decode($jsonArr), true);
//对base64及json解码
if (!is_array($jsonArr)) {
self::$errCode = 103;
self::$errMsg = '参数数组不是数组格式';
return false;
}
$tName = $jsonArr['tName'];
//表名
$set = $jsonArr['set'];
//set，用关键字SET
if (empty($tName) || empty($set)) {
self::$errCode = '300';
self::$errMsg = '必要参数不完整';
return false;
}
$insertId = WhIoStoreModel::addTNameRow($tName, $set);
if ($insertId !== FALSE) {
self::$errCode = '200';
self::$errMsg = '成功';
return $insertId;
} else {
self::$errCode = '404';
self::$errMsg = '数据库操作错误';
return false;
}
}
function act_addWhIoStoreDetail()
{
$jsonArr = isset($_GET['jsonArr']) ? $_GET['jsonArr'] : '';
//传过来的base64编码的json字符串
if (empty($jsonArr)) {
self::$errCode = 0101;
self::$errMsg = 'empty jsonArr';
return 0;
}
$jsonArr = json_decode(base64_decode($jsonArr), true);
//对base64及json解码
if (!is_array($jsonArr)) {
self::$errCode = 0201;
self::$errMsg = 'error array';
return 0;
}
$iostoreId = $jsonArr['iostoreId'];
//出入库单据编号(id)
$sku = $jsonArr['sku'];
//添加的sku
$amount = $jsonArr['amount'];
//对应数量
$cost = $jsonArr['cost'];
//成本
$purchaseId = $jsonArr['purchaseId'];
//采购员id
if (empty($iostoreId)) {
//出入库单据的id不能为空
self::$errCode = 0301;
self::$errMsg = 'empty iostoreId';
return 0;
}
if (empty($sku)) {
self::$errCode = 0401;
self::$errMsg = 'empty sku';
return 0;
}
if (empty($amount)) {
self::$errCode = 0501;
self::$errMsg = 'empty amount';
return 0;
}
if (empty($cost)) {
self::$errCode = 0601;
self::$errMsg = 'empty cost';
return 0;
}
if (empty($purchaseId)) {
//默认公司为1赛维
self::$errCode = 0701;
self::$errMsg = 'empty purchaseId';
return 0;
}
$tName = 'wh_iostoredetail';
$set = "SET iostoreId='{$iostoreId}',sku='{$sku}',amount='{$amount}',cost='{$cost}',purchaseId='{$purchaseId}' ";
$affectRows = WhIoStoreModel::addTNameRow($tName, $set);
if (!$affectRows) {
self::$errCode = 00;
self::$errMsg = 'addRow error';
return 0;
} else {
self::$errCode = 200;
self::$errMsg = 'success';
return $affectRows;
}
}
