/**
*添加指定表记录,返回 insertId
*/
function act_addTNameRow($tName, $set)
{
$ret = OmAvailableModel::addTNameRow($tName, $set);
if ($ret !== FALSE) {
return $ret;
} else {
self::$errCode = OmAvailableModel::$errCode;
self::$errMsg = OmAvailableModel::$errMsg;
return false;
}
}
function act_insertBlackList($data, $table)
{
//表名，SET，WHERE
$key = array();
$value = array();
foreach ($data as $k => $v) {
$key[] = $k;
$value[] = $v;
}
$set = " (" . implode(',', $key) . ") VALUE ('" . implode("','", $value) . "')";
$ret = OmAvailableModel::addTNameRow($table, $set);
if ($ret) {
return true;
} else {
self::$errCode = OmAvailableModel::$errCode;
self::$errMsg = OmAvailableModel::$errMsg;
return false;
}
}
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 = OmAvailableModel::addTNameRow($tName, $set);
if ($insertId !== FALSE) {
self::$errCode = '200';
self::$errMsg = '成功';
return $insertId;
} else {
self::$errCode = '404';
self::$errMsg = '数据库操作错误';
return false;
}
}
function act_updateCostAndAddHistory()
{
$sku = $_GET['sku'] ? post_check(trim($_GET['sku'])) : '';
//sku
$purchaseCost = $_GET['purchaseCost'] ? post_check(trim($_GET['purchaseCost'])) : 0;
//成本
$addUserId = $_GET['addUserId'] ? post_check(trim($_GET['addUserId'])) : 0;
//添加人
$addTime = time();
if (empty($sku)) {
self::$errCode = '101';
self::$errMsg = 'sku为空';
return false;
}
if (!is_numeric($purchaseCost) || $purchaseCost <= 0) {
self::$errCode = '102';
self::$errMsg = '成本必须大于0';
return false;
}
if (intval($addUserId) <= 0) {
self::$errCode = '103';
self::$errMsg = '添加人id不合法';
return false;
}
$tName = 'pc_goods';
$select = '*';
$where = "WHERE sku='{$sku}' and is_delete=0";
$skuList = OmAvailableModel::getTNameList($tName, $select, $where);
if (empty($skuList)) {
self::$errCode = '104';
self::$errMsg = "找不到 {$sku} 料号";
return false;
}
try {
BaseModel::begin();
//先更新goods表中对应sku的goodsCost
$set = "SET goodsCost='{$purchaseCost}'";
OmAvailableModel::updateTNameRow($tName, $set, $where);
//然后再历史记录表中添加一条记录
$tName = 'pc_goods_cost_history_record';
$set = "SET sku='{$sku}',purchaseCost='{$purchaseCost}',addUserId='{$addUserId}',addTime='{$addTime}'";
OmAvailableModel::addTNameRow($tName, $set);
//更新mem中的sku
$key = 'pc_goods_' . $sku;
$value = $skuList[0];
$value['goodsCost'] = $purchaseCost;
setMemNewByKey($key, $value);
//这里不保证能添加成功
BaseModel::commit();
BaseModel::autoCommit();
self::$errCode = '200';
self::$errMsg = "更新成功";
return true;
} catch (Exception $e) {
BaseModel::rollback();
BaseModel::autoCommit();
self::$errCode = '404';
self::$errMsg = $e->getMessage();
return false;
}
}
Log::write("INSERT INTO " . $tracknumber_tname . $tracknumber_set, Log::ERR);
OmAvailableModel::rollback();
continue;
}
}
$detail_blag = false;
foreach ($order_detail as $detail) {
$insert_detail_arr = array();
$insert_detail_arr[] = "shipOrderId = '{$shipOrderId}'";
$insert_detail_arr[] = "sku = '{$detail['sku']}'";
$insert_detail_arr[] = "amount = '{$detail['amount']}'";
$insert_detail_arr[] = "positionId = '{$detail['positionId']}'";
$insert_detail_arr[] = "pName = '{$detail['pName']}'";
$detail_tname = "wh_shipping_orderdetail";
$detail_set = "set " . implode(",", $insert_tracknumber_arr);
$detailId = OmAvailableModel::addTNameRow($detail_tname, $detail_set);
if (!$detailId) {
Log::write("INSERT INTO " . $detail_tname . $detail_set, Log::ERR);
OmAvailableModel::rollback();
$detail_blag = true;
break;
}
}
if ($detail_blag) {
continue;
}
OmAvailableModel::commit();
$channel->basic_ack($msg->delivery_info['delivery_tag']);
}
}
}
function act_checkOrder()
{
$userId = $_SESSION['userId'];
$order_id = trim($_POST['ebay_id']);
$state_status = array(PKS_WIQC);
//先核对订单
$p_real_ebayid = '#^\\d+$#';
if (!preg_match($p_real_ebayid, $order_id)) {
self::$errCode = "001";
self::$errMsg = "发货单号[" . $order_id . "]格式有误";
return false;
}
$ordercheck = ShippingOrderModel::getShippingOrder("*", "where id='{$order_id}'");
if (empty($ordercheck)) {
self::$errCode = '001';
self::$errMsg = '未找到发货单[' . $order_id . ']';
return false;
}
if ($ordercheck[0]['isExpressDelivery'] == 1) {
self::$errCode = '001';
self::$errMsg = '此发货单是快递运输方式，请转到快递复核界面操作！';
return false;
}
$orderinfos = array();
$skuinfos = array();
$orderinfos = get_realskunum($ordercheck[0]['id']);
//配货单所有料号及数量
foreach ($orderinfos as $or_sku => $or_nums) {
$sku_info = OrderReviewModel::getSkuInfo("goodsName", "where sku='{$or_sku}'");
$skuinfos[] = array('sku' => $or_sku, 'goodsName' => $sku_info['goodsName'], 'num' => $or_nums);
}
$string = "";
$time = strtotime(date('Y-m-d H:i:s'));
foreach ($skuinfos as $info) {
$string .= "('" . $ordercheck[0]['id'] . "','" . $info['sku'] . "','" . $info['goodsName'] . "','0','" . $info['num'] . "','" . $userId . "','" . $time . "','0'),";
}
$string = trim($string, ",");
OrderReviewModel::update(array('is_delete' => 1), "and shipOrderId='{$ordercheck[0]['id']}'");
$insert_info = OrderReviewModel::insert($string);
if ($insert_info) {
if (!in_array($ordercheck[0]['orderStatus'], $state_status)) {
if ($ordercheck[0]['orderStatus'] == PKS_PROCESS_GET_GOODS) {
$where = "where shipOrderId='{$ordercheck[0]['id']}' and is_delete=0";
$list = OmAvailableModel::getTNameList("wh_order_picking_records", "*", $where);
$eosr_arrlist = array();
foreach ($list as $row) {
$eosr_arrlist[] = $row['shipOrderdetailId'];
}
//$skuinfos = get_realskunum($orderid);
$skuinfos = OmAvailableModel::getTNameList("wh_shipping_orderdetail", "*", "where shipOrderId='{$ordercheck[0]['id']}' and is_delete = 0");
foreach ($skuinfos as $info) {
$order_detail = array();
if (!in_array($info['id'], $eosr_arrlist)) {
$order_detail['shipOrderId'] = $info['shipOrderId'];
$order_detail['shipOrderdetailId'] = $info['id'];
$order_detail['sku'] = $info['sku'];
$order_detail['pName'] = $info['pName'];
$order_detail['totalNums'] = $info['amount'];
$order_detail['isScan'] = 0;
$order_detail['is_delete'] = 0;
$field = ' SET ' . array2sql($order_detail);
OmAvailableModel::addTNameRow("wh_order_picking_records", $field);
}
}
$where = "where shipOrderId='{$ordercheck[0]['id']}' and is_delete=0 and isScan=0";
$p_list = OmAvailableModel::getTNameList("wh_order_picking_records", "*", $where);
$str = '';
if (!empty($p_list)) {
foreach ($p_list as $eo) {
$op_amount = empty($eo['amount']) ? 0 : $eo['amount'];
$str .= "料号 {$eo['sku']} 未配货,";
$str .= " 已配货 {$op_amount} 还需配货 " . ($eo['totalNums'] - $op_amount);
$str .= " PDA扫描时间:" . ($eo['scanTime'] ? date('Y-m-d H:i:s', $eo['scanTime']) : ' 无 ');
$str .= "<br>";
}
}
self::$errCode = '004';
self::$errMsg = "该订单[{$order_id}]在等待配货状态,请确认!<br/>" . $str;
return false;
}
self::$errCode = '001';
self::$errMsg = "该订单[{$order_id}]在" . LibraryStatusModel::getStatusNameByStatusCode($ordercheck[0]['orderStatus']) . "状态,请确认!";
return false;
}
$fist_skuinfos = OrderReviewModel::getReviewList("*", "where shipOrderId='{$ordercheck[0]['id']}' and is_delete=0 and storeId=1");
$note_info = OmAvailableModel::getTNameList("wh_shipping_order_note_record", "*", "where shipOrderId='{$ordercheck[0]['id']}'");
if (!empty($note_info)) {
self::$errMsg = "订单有效,请复核该订单下的料号及数量!<br/>备注：" . $note_info[0]['content'];
} else {
self::$errMsg = "订单有效,请复核该订单下的料号及数量!";
}
return $fist_skuinfos;
} else {
self::$errCode = '003';
self::$errMsg = "订单料号初始化出错,请重试";
return false;
}
}
public function view_tmpModReturnPros()
{
//添加sku
$type = isset($_GET['type']) ? $_GET['type'] : '';
$sku = isset($_GET['sku']) ? post_check(trim($_GET['sku'])) : '';
$addUserId = intval($_SESSION['userId']);
if ($addUserId <= 0) {
$status = '登陆超时，请重试';
header('Location:index.php?mod=products&act=tmpModReturnPros&status=' . $status);
exit;
}
$now = time();
if ($type == 'add') {
if (!empty($sku)) {
$skuList = getSkuBygoodsCode($sku);
$sku = $skuList[0]['sku'];
if (empty($sku)) {
$status = "{$_GET['sku']} 找不到对应料号";
header('Location:index.php?mod=products&act=tmpModReturnPros&status=' . $status);
exit;
}
$tName = 'pc_products_iostore_detail';
$where = "WHERE is_delete=0 AND sku='{$sku}' AND iostoreTypeId=1 AND useTypeId=2 AND isAudit<3";
//找出领料单中修改领取的该产品记录数
$countDetailLL = OmAvailableModel::getTNameCount($tName, $where);
if (empty($countDetailLL)) {
$status = "找不到 {$_GET['sku']} 的 修改领料 记录";
header('Location:index.php?mod=products&act=tmpModReturnPros&status=' . $status);
exit;
}
$tName = 'pc_products_iostore_detail';
$where = "WHERE is_delete=0 AND sku='{$sku}' AND iostoreTypeId=2 AND useTypeId=2 AND isAudit<3";
//找出退料单中修改归还的该产品记录数
$countDetailTL = OmAvailableModel::getTNameCount($tName, $where);
$allowAddCount = $countDetailLL - $countDetailTL;
//该料号允许添加的数量
$tName = 'pc_tmp_products_return';
$where = "WHERE returnType=3 AND sku='{$sku}'";
$countSku = OmAvailableModel::getTNameCount($tName, $where);
$countSku++;
//当前该sku的数量
if ($allowAddCount < $countSku) {
//如果允许添加的该sku数量小于该sku已经添加的数量，则报错
$status = "{$_GET['sku']} 已经全部归还，不能再添加";
header('Location:index.php?mod=products&act=tmpModReturnPros&status=' . $status);
exit;
}
$set = "SET returnType=3,sku='{$sku}',addUserId='{$addUserId}',createdTime='{$now}'";
//type=3 ,修改归还
OmAvailableModel::addTNameRow($tName, $set);
$status = $sku . ' 添加成功';
header('Location:index.php?mod=products&act=tmpModReturnPros&status=' . $status);
}
}
//展示tmp表中的记录
$tName = 'pc_tmp_products_return';
$select = "*";
$where = "WHERE returnType=3 order by createdTime desc";
//修改领料
$tmpModReturnProsList = OmAvailableModel::getTNameList($tName, $select, $where);
$navlist = array(array('url' => 'index.php?mod=products&act=getProductsComfirmList', 'title' => '产品制作'), array('url' => 'index.php?mod=products&act=tmpModReturnPros', 'title' => '修改产品归还'));
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('onevar', 5);
$this->smarty->assign('twovar', 510);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('title', '修改产品归还');
if (!empty($tmpModReturnProsList)) {
$whInfoList = getWhInfo();
//根据接口取得对应仓库信息
$whArr = array();
foreach ($whInfoList as $value) {
if (intval($value['id']) > 0) {
$whArr[$value['id']] = $value['whName'];
}
}
$countProsList = count($tmpModReturnProsList);
for ($i = 0; $i < $countProsList; $i++) {
$sku = $tmpModReturnProsList[$i]['sku'];
$tName = 'pc_goods';
$select = 'goodsName';
$where = "WHERE sku='{$sku}'";
$skuInfoList = OmAvailableModel::getTNameList($tName, $select, $where);
$tmpModReturnProsList[$i]['goodsName'] = $skuInfoList[0]['goodsName'];
$tName = 'pc_goods_whId_location_raletion';
$select = 'location,whId';
$where = "WHERE sku='{$sku}'";
$skuLocWhInfoList = OmAvailableModel::getTNameList($tName, $select, $where);
$tmpModReturnProsList[$i]['location'] = $skuLocWhInfoList[0]['location'];
$tmpModReturnProsList[$i]['whName'] = $whArr[$skuLocWhInfoList[0]['whId']];
}
}
$this->smarty->assign('tmpModReturnProsList', empty($tmpModReturnProsList) ? array() : $tmpModReturnProsList);
$this->smarty->display("tmpModReturnPros.htm");
}
//添加自动生成SPU记录
$tName = 'pc_auto_create_spu';
$where = "WHERE spu='{$spu}'";
$countAutoCreSpu = OmAvailableModel::getTNameCount($tName, $where);
if ($countAutoCreSpu) {
echo "{$spu} autoCreateSpu has exist!\n";
//continue;
}
if (preg_match("/^[A-Z]{2}[0-9]{6}\$/", $spu)) {
$sort = intval(substr($spu, 2));
} else {
$sort = 0;
}
$set = "SET spu='{$spu}',purchaseId='{$purchaseId}',createdTime='{$now}',sort='{$sort}',status=2";
if (!$countAutoCreSpu) {
OmAvailableModel::addTNameRow($tName, $set);
echo "{$spu} autoCreateSpu insert success\n";
}
//添加SPU档案
$tName = 'pc_spu_archive';
$where = "WHERE spu='{$spu}'";
$countSpuArchive = OmAvailableModel::getTNameCount($tName, $where);
if ($countSpuArchive) {
echo "{$spu} spuArchive has exist!\n";
$set = "SET categoryPath='{$value['goods_category']}',purchaseId='{$pcGoodsArr['purchaseId']}'";
OmAvailableModel::updateTNameRow($tName, $set, $where);
echo "{$spu} spuArchive update category and purchaseId success! {$value['goods_category']} {$pcGoodsArr['purchaseId']} \n";
//continue;
}
$dataSpuArchive = array();
$dataSpuArchive['spu'] = $spu;
function act_addInput()
{
//$pidNew = $_POST['pidNew']?post_check($_POST['pidNew']):'';//类别
$finalIdArr = $_POST['finalIdStr'];
//新建属性-类别4
$inputName = $_POST['inputName'] ? post_check($_POST['inputName']) : '';
//类别
$textStatus = $_POST['textStatus'] ? post_check($_POST['textStatus']) : '';
//文本方式
if (empty($finalIdArr) || empty($inputName)) {
self::$errCode = 101;
self::$errMsg = '类别或属性名不能为空';
return false;
}
if (intval($textStatus) <= 0) {
self::$errCode = 102;
self::$errMsg = '文本方式有误';
return false;
}
$tmpArr = array();
if (!is_array($finalIdArr)) {
$tmpArr[] = $finalIdArr;
$finalIdArr = $tmpArr;
}
$finalPathArr = array();
foreach ($finalIdArr as $cid) {
$catePath = CategoryModel::getCategoryPathById($cid);
if (empty($catePath)) {
self::$errCode = 109;
self::$errMsg = '类别有误';
return false;
}
$finalPathArr[] = $catePath;
}
$tName = 'pc_goods_category';
foreach ($finalPathArr as $value) {
$where = "WHERE path like'%{$value}-%' and is_delete=0";
$count = OmAvailableModel::getTNameCount($tName, $where);
if ($count) {
self::$errCode = 105;
self::$errMsg = '只能在最小分类进行复制';
return false;
}
}
try {
$pidNewStr = '';
BaseModel::begin();
$tName = 'pc_archive_input';
foreach ($finalPathArr as $value) {
$where = "WHERE inputName='{$inputName}' AND categoryPath='{$value}'";
$countIN = OmAvailableModel::getTNameCount($tName, $where);
if (!$countIN) {
$pidNewStr .= CategoryModel::getCategoryNameByPath($value) . ' ';
$set = "SET inputName='{$inputName}',categoryPath='{$value}',textStatus='{$textStatus}'";
OmAvailableModel::addTNameRow($tName, $set);
}
}
BaseModel::commit();
BaseModel::autoCommit();
self::$errCode = 200;
self::$errMsg = "{$inputName} 添加到 {$pidNewStr} 成功";
return true;
} catch (Exception $e) {
BaseModel::rollback();
BaseModel::autoCommit();
self::$errCode = 201;
self::$errMsg = $e->getMessage();
return false;
}
}
function act_searchPickingInfo($orderid)
{
$p_real_ebayid = '#^\\d+$#';
$p_trackno_eub = '#^(LK|RA|RB|RC|RR|RF|LN|LX)\\d+(CN|HK|DE200)$#';
$is_eub_package_type = false;
if (preg_match($p_real_ebayid, $orderid)) {
} else {
if (preg_match($p_trackno_eub, $orderid)) {
$is_eub_package_type = true;
} else {
return "订单号{$orderid}没有配货记录!订单号不存在,请确认!";
exit;
}
}
if ($is_eub_package_type === true) {
$ordercheck = ShippingOrderModel::getShippingOrderInfo("b.*", "where a.tracknumber='{$orderid}' and a.is_delete=0");
} else {
$ordercheck = ShippingOrderModel::getShippingOrder("*", "where id='{$orderid}'");
}
if (empty($ordercheck)) {
return "订单号{$orderid}没有配货记录!订单号不存在,请确认!";
exit;
} else {
$orderid = $ordercheck[0]['id'];
}
$where = "where shipOrderId='{$orderid}' and is_delete=0";
$list = OmAvailableModel::getTNameList("wh_order_picking_records", "*", $where);
$eosr_arrlist = array();
foreach ($list as $row) {
$eosr_arrlist[] = $row['shipOrderdetailId'];
}
//$skuinfos = get_realskunum($orderid);
$skuinfos = OmAvailableModel::getTNameList("wh_shipping_orderdetail", "*", "where shipOrderId='{$orderid}'");
foreach ($skuinfos as $info) {
$order_detail = array();
if (!in_array($info['id'], $eosr_arrlist)) {
$order_detail['shipOrderId'] = $info['shipOrderId'];
$order_detail['shipOrderdetailId'] = $info['id'];
$order_detail['sku'] = $info['sku'];
$order_detail['pName'] = $info['pName'];
$order_detail['totalNums'] = $info['amount'];
$order_detail['isScan'] = 0;
$order_detail['is_delete'] = 0;
$field = ' SET ' . array2sql($order_detail);
OmAvailableModel::addTNameRow("wh_order_picking_records", $field);
}
}
$where = "where shipOrderId='{$orderid}'";
$p_list = OmAvailableModel::getTNameList("wh_order_picking_records", "*", $where);
$show = '';
foreach ($p_list as $value) {
$scan_status = $value['isScan'] == 0 ? '未配货' : '已配货';
if (empty($value['scanUserId'])) {
$op_name = '无';
} else {
//配货人
$usermodel = UserModel::getInstance();
$iqc_user = $usermodel->getGlobalUserLists('global_user_name', "where a.global_user_id={$value['scanUserId']}", '', '');
$op_name = $iqc_user[0]['global_user_name'];
}
$op_amount = empty($value['amount']) ? 0 : $value['amount'];
if ($value['is_delete'] == 1) {
$show .= "<font style='color:red;'>配货记录已删除：订单{$orderid} 的料号 {$value['sku']} 仓位{$value['pName']} {$scan_status} 配货人 {$op_name}， ";
$show .= " 已配货 {$op_amount} 还需配货 " . ($value['totalNums'] - $op_amount);
$show .= " PDA扫描时间:" . ($value['scanTime'] ? date('Y-m-d H:i:s', $value['scanTime']) : ' 无 ') . "</font>";
} else {
$show .= "订单{$orderid} 的料号 {$value['sku']} 仓位{$value['pName']} {$scan_status} 配货人 {$op_name}， ";
$show .= " 已配货 {$op_amount} 还需配货 " . ($value['totalNums'] - $op_amount);
$show .= " PDA扫描时间:" . ($value['scanTime'] ? date('Y-m-d H:i:s', $value['scanTime']) : ' 无 ');
}
/*
if($value['isScan']==1 && $value['is_delete']==0){
$show .= "<input class='del' type='button' name='deletebutton' orderid='{$orderid}' sku='{$value['sku']}' pname='{$value['pName']}' value='删除订单的配货记录,回滚库存' />";
}*/
$show .= "<br>";
}
return $show;
}
public function act_modify()
{
$skuNumber = 0;
$skuAmount = 0;
$skuSql = '';
$detailArr = array();
$num = $_REQUEST['num'];
$orderId = $_REQUEST['orderId'];
$detailId = $_REQUEST['detailId'];
$transport = $_REQUEST['transport'];
$materials = $_REQUEST['materials'];
$skuString = $_REQUEST['skuString'];
$numberString = $_REQUEST['numberString'];
$countryName = $_REQUEST['countryName'];
$state = $_REQUEST['state'];
$city = $_REQUEST['city'];
$street = $_REQUEST['street'];
$address2 = $_REQUEST['address2'];
$address3 = $_REQUEST['address3'];
$landline = $_REQUEST['landline'];
$phone = $_REQUEST['phone'];
$zipCode = $_REQUEST['zipCode'];
$currency = $_REQUEST['currency'];
$notes = $_REQUEST['notes'];
$detailIdArr = explode(',', $detailId);
$skuArr = explode(',', $skuString);
$numberArr = explode(',', $numberString);
for ($i = 0; $i < $num; $i++) {
$detailArr[$i]['id'] = $detailIdArr[$i];
$detailArr[$i]['sku'] = $skuArr[$i];
$detailArr[$i]['amount'] = $numberArr[$i];
}
$orderData = OmAvailableModel::getTNameList(' om_unshipped_order ', ' * ', ' WHERE id = ' . $orderId);
$set = ' SET transportId = "' . $transport . '" , pmId = "' . $materials . '" ';
$where = ' WHERE id = ' . $orderId;
$ret1 = OmAvailableModel::updateTNameRow('om_unshipped_order', $set, $where);
if ($ret1 === false) {
self::$errCode = OmAvailableModel::$errCode;
self::$errMsg = OmAvailableModel::$errMsg;
return false;
}
foreach ($detailArr as $k => $v) {
$skuData = OmAvailableModel::getTNameList(' om_unshipped_order_detail ', ' * ', ' WHERE id = ' . $v['id']);
$set = ' SET sku = "' . $v['sku'] . '" , amount = "' . $v['amount'] . '" ';
$where = ' WHERE id = ' . $v['id'];
$ret2 = OmAvailableModel::updateTNameRow('om_unshipped_order_detail', $set, $where);
if ($ret2 === false) {
self::$errCode = OmAvailableModel::$errCode;
self::$errMsg = OmAvailableModel::$errMsg;
return false;
}
if ($ret2 !== 0) {
$skuSql .= ' UPDATE om_unshipped_order_detail SET sku = \\"' . $v['sku'] . '\\" , amount = \\"' . $v['amount'] . '\\" WHERE id = ' . $v['id'];
if ($skuData[0]['sku'] != $v['sku']) {
$skuNumber = 1;
}
if ($skuData[0]['amount'] != $v['amount']) {
$skuAmount = 1;
}
}
}
$set = ' SET countryName = "' . $countryName . '" , state = "' . $state . '" , city = "' . $city . '" , street = "' . $street . '" , address2 = "' . $address2 . '" , address3 = "' . $address3 . '" , landline = "' . $landline . '" , phone = "' . $phone . '" , zipCode = "' . $zipCode . '" , currency = "' . $currency . '" ';
$where = ' WHERE omOrderId = ' . $orderId;
$ret3 = OmAvailableModel::updateTNameRow('om_unshipped_order_userInfo', $set, $where);
if ($ret3 === false) {
self::$errCode = OmAvailableModel::$errCode;
self::$errMsg = OmAvailableModel::$errMsg;
return false;
}
if ($ret3 !== 0) {
$userInfoSql .= ' UPDATE om_unshipped_order_userInfo SET countryName = \\"' . $countryName . '\\" , state = \\"' . $state . '\\" , city = \\"' . $city . '\\" , street = \\"' . $street . '\\" , address2 = \\"' . $address2 . '\\" , address3 = \\"' . $address3 . '\\" , landline = \\"' . $landline . '\\" , phone = \\"' . $phone . '\\" , zipCode = \\"' . $zipCode . '\\" , currency = \\"' . $currency . '\\" WHERE omOrderId = ' . $orderId;
}
$currencyData = OmAvailableModel::getTNameList(' om_order_notes ', ' * ', ' WHERE omOrderId = ' . $orderId);
if (!empty($currencyData)) {
$set = ' SET content = "' . $notes . '" , userId = "' . $_SESSION['sysUserId'] . '" ,createdTime = "' . time() . '" ';
$ret4 = OmAvailableModel::updateTNameRow('om_order_notes', $set, $where);
if ($ret4 === false) {
self::$errCode = OmAvailableModel::$errCode;
self::$errMsg = OmAvailableModel::$errMsg;
return false;
}
if ($ret4 !== 0) {
$notesSql .= ' UPDATE om_unshipped_order_userInfo SET notes = \\"' . $notes . '\\" , userId = \\"' . $_SESSION['sysUserId'] . '\\" ,createdTime = \\"' . time() . '\\" WHERE omOrderId = ' . $orderId;
}
} else {
$addNotes = ' (omOrderId,content,userId,createdTime) VALUES ("' . $orderId . '","' . $notes . '","' . $_SESSION['sysUserId'] . '","' . time() . '")';
$ret4 = OmAvailableModel::addTNameRow('om_order_notes', $addNotes);
if ($ret4 === false) {
self::$errCode = OmAvailableModel::$errCode;
self::$errMsg = OmAvailableModel::$errMsg;
return false;
}
if ($ret4 !== 0) {
$notesSql .= ' INSERT INTO om_order_notes (omOrderId,content,userId,createdTime) VALUES (\\"' . $orderId . '\\",\\"' . $notes . '\\",\\"' . $_SESSION['sysUserId'] . '\\",\\"' . time() . '\\")';
}
}
if ($ret1 !== 0 || $ret2 !== 0 || $ret3 !== 0 || $ret4 !== 0) {
$value = ' (`operatorId`,`omOrderId`,`oldStatus`,`newStatus`,`sql`,`note`,`createdTime`) VALUES (';
$value .= '"' . $_SESSION['sysUserId'] . '",';
$value .= '"' . $orderId . '",';
$status = $orderData[0]['orderType'] == '' ? $orderData[0]['orderStatus'] : $orderData[0]['orderType'];
$value .= '"' . $status . '",';
$value .= '"' . $status . '",';
$value .= '"UPDATE om_unshipped_order SET transportId = \\"' . $transport . '\\" , pmId = \\"' . $materials . '\\" WHERE id = \\"' . $orderId . '\\" ' . $skuSql . '",';
$value .= ' "修改了';
if ($orderData[0]['transportId'] != $transport) {
$value .= ' 运输方式 ';
}
if ($orderData[0]['pmId'] != $materials) {
$value .= ' 包装材料 ';
}
if ($skuNumber == 1) {
$value .= ' sku ';
}
if ($skuAmount == 1) {
$value .= ' 数量 ';
}
if ($ret3 !== 0) {
$value .= ' 运费详情 ';
}
if ($ret4 !== 0) {
$value .= ' 备注 ';
}
$value .= '" ,';
$value .= '"' . time() . '")';
//$result = OmAvailableModel::addTNameRow(' `om_order_log_2013-09_2013-12` ',$value);
}
return true;
}
$affectRowCom = 1;
if ($affectRowCom !== false) {
//echo "{$pcGoodsArr['combineSku']} insert success\n";
$goods_sncombine = $value['goods_sncombine'];
$tmpArr1 = explode(',', $goods_sncombine);
//按逗号截取字符串，生成对应真实料号及对应数量的数组数量
//$tName = 'pc_sku_combine_relation';
// $where = "WHERE combineSku='{$pcGoodsArr['combineSku']}'";
// OmAvailableModel::deleteTNameRow($tName, $where);//删除旧的关系
// echo "{$pcGoodsArr['combineSku']} old relation delete success\n";
foreach ($tmpArr1 as $value1) {
$tmpArr2 = explode('*', $value1);
//按*截取，获取真实料号及数量
$trueSku = trim($tmpArr2[0]);
$amount = trim($tmpArr2[1]);
if (!empty($trueSku) && !empty($amount)) {
$tName = 'pc_sku_combine_relation';
$set = "SET combineSku='{$pcGoodsArr['combineSku']}',sku='{$trueSku}',count='{$amount}'";
$affectRow = OmAvailableModel::addTNameRow($tName, $set);
if ($affectRow !== false) {
echo "{$pcGoodsArr['combineSku']} {$trueSku} {$amount} insert success in relation\n";
} else {
echo "{$pcGoodsArr['combineSku']} {$trueSku} {$amount} insert fail in relation\n";
}
}
}
} else {
echo "{$pcGoodsArr['combineSku']} insert fail\n";
}
}
}
public function view_addInputOn()
{
$inputName = $_GET['inputName'] ? post_check(trim($_GET['inputName'])) : '';
$pid = $_GET['pid'] ? post_check(trim($_GET['pid'])) : '';
if (empty($inputName)) {
$status = "属性名不能为空";
header("Location:index.php?mod=property&act=addInput&status={$status}");
exit;
}
if (empty($pid)) {
$status = "类别不能为空";
header("Location:index.php?mod=property&act=addInput&status={$status}");
exit;
}
$categoryName = getAllCateNameByPath($pid);
$pathImplodeStr = getAllPathBypid($pid);
$tName = 'pc_archive_input';
$where = "WHERE inputName='{$inputName}' and categoryPath IN ({$pathImplodeStr})";
$count = OmAvailableModel::getTNameCount($tName, $where);
if ($count) {
$status = "{$categoryName} 或其父类下已经存在 {$inputName} 属性";
header("Location:index.php?mod=property&act=addInput&status={$status}");
exit;
}
$set = "SET inputName='{$inputName}',categoryPath='{$pid}'";
$insertId = OmAvailableModel::addTNameRow($tName, $set);
if (!$insertId) {
$status = "系统插入数据错误";
header("Location:index.php?mod=property&act=addInput&status={$status}");
exit;
}
$status = "{$categoryName} 中添加 {$inputName} 文本属性成功";
header("Location:index.php?mod=property&act=addInput&status={$status}");
}
function act_addSkuConversion()
{
$old_sku = $_POST['old_sku'] ? post_check(trim($_POST['old_sku'])) : '';
//old_sku
$new_sku = $_POST['new_sku'] ? post_check(trim($_POST['new_sku'])) : '';
//new_sku
$addUserId = intval($_SESSION['userId']);
$createdTime = time();
if (empty($old_sku) || empty($new_sku)) {
self::$errCode = '101';
self::$errMsg = "新/旧料号不能为空";
return;
}
if ($old_sku == $new_sku) {
self::$errCode = '109';
self::$errMsg = "新/旧料号相同，不能转换";
return;
}
if (!preg_match("/^[A-Z0-9]+(_[A-Z0-9]+)*\$/", $new_sku)) {
self::$errCode = '100';
self::$errMsg = "新料号 {$new_sku} 格式不合法";
return;
}
if ($addUserId <= 0) {
self::$errCode = '103';
self::$errMsg = "登陆超时，请重试";
return;
}
$tName = 'pc_sku_conversion';
$where = "WHERE is_delete=0 AND old_sku='{$old_sku}'";
$countOldSkuCon = OmAvailableModel::getTNameCount($tName, $where);
//在料号转换表里查找是否已经存在该旧料号的信息
if ($countOldSkuCon) {
self::$errCode = '104';
self::$errMsg = "旧料号 {$old_sku} 已经存在料号转换列表中";
return;
}
$tName = 'pc_goods';
$select = '*';
$where = "WHERE is_delete=0 AND sku='{$old_sku}' order by id desc limit 1";
$oldSkuList = OmAvailableModel::getTNameList($tName, $select, $where);
//在产品表里找是否存在旧料号
$oldSku = $oldSkuList[0];
//旧料号的信息
if (empty($oldSku)) {
self::$errCode = '105';
self::$errMsg = "旧料号 {$old_sku} 在产品列表中不存在";
return;
}
try {
BaseModel::begin();
$tName = 'pc_sku_conversion';
$set = "SET old_sku='{$old_sku}',new_sku='{$new_sku}',addUserId='{$addUserId}',createdTime='{$createdTime}'";
$flag = OmAvailableModel::addTNameRow($tName, $set);
//添加转换记录
if ($flag) {
self::$errCode = '200';
self::$errMsg = "旧料号 {$old_sku}转{$new_sku}添加成功";
}
BaseModel::commit();
BaseModel::autoCommit();
return;
} catch (Exception $e) {
BaseModel::rollback();
BaseModel::autoCommit();
self::$errCode = '404';
self::$errMsg = $e->getMessage();
return;
}
}
public function view_addSpuPrefixOn()
{
$prefix = $_GET['prefix'] ? post_check(trim($_GET['prefix'])) : '';
$isSingSpu = $_GET['isSingSpu'] ? post_check(trim($_GET['isSingSpu'])) : '';
$companyId = $_GET['companyId'] ? post_check(trim($_GET['companyId'])) : '';
$isUse = $_GET['isUse'] ? post_check(trim($_GET['isUse'])) : '';
if (!preg_match("/^[A-Z]{2}\$/", $prefix)) {
$status = "前缀必须是两个大写字母的组合";
header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}");
exit;
}
if (intval($isSingSpu) != 1 && intval($isSingSpu) != 2) {
$status = "单/组合料号有误";
header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}");
exit;
}
$companyInfo = getCompanyNameById($companyId);
if (empty($companyInfo)) {
$status = "公司信息有误";
header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}");
exit;
}
if (intval($isUse) == 0) {
$status = "启动/禁用不能为空";
header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}");
exit;
}
$tName = 'pc_auto_create_spu_prefix';
$where = "WHERE prefix='{$prefix}' AND companyId='{$companyId}'";
$count = OmAvailableModel::getTNameCount($tName, $where);
if ($count) {
$status = "该公司下已经存在 {$prefix} 前缀";
header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}");
exit;
}
$set = "SET prefix='{$prefix}',isSingSpu='{$isSingSpu}',companyId='{$companyId}',isUse='{$isUse}'";
$insertId = OmAvailableModel::addTNameRow($tName, $set);
if (!$insertId) {
$status = "系统插入数据错误";
header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}");
exit;
}
$status = "添加 {$prefix} 前缀成功";
header("Location:index.php?mod=spu&act=getSpuPrefixList&status={$status}");
}
