/** *添加指定表记录,返回 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}"); }