function act_getProducts2pc($select, $where) { $listArr = UserCacheModel::getOpenSysApi('pc.getEbayProducts2PcProducts', array('all' => 'all'), 'gw88'); if ($listArr) { foreach ($listArr as $value) { $tName = 'pc_products'; $where = "WHERE is_delete=0 and productsStatus=1 and sku='{$value['sku']}'"; $skuCount = OmAvailableModel::getTNameCount($tName, $where); if (!$skuCount) { $pc_pro = array(); $pc_pro['id'] = $value['id']; if (!empty($value['sku'])) { $tmpArr = explode('_', $value['sku']); $pc_pro['spu'] = $tmpArr[0]; } $pc_pro['sku'] = $value['sku']; $pc_pro['productsStatus'] = 1; $pc_pro['productsComfirmerId'] = getPersonIdByName($value['comfirmuser']); $pc_pro['productsComfirmTime'] = $value['comfirmtime']; OmAvailableModel::addTNameRow2arr($tName, $pc_pro); } } self::$errCode = 200; self::$errMsg = 'success'; return true; } else { self::$errCode = 404; self::$errMsg = 'error'; return false; } }
$tName = 'pc_goods_combine'; $select = 'combineSpu,combineUserId,addTime'; $where = "WHERE is_delete=0 limit {$start},{$per}"; $combineSpuList = OmAvailableModel::getTNameList($tName, $select, $where); foreach ($combineSpuList as $value) { $combineSpu = $value['combineSpu']; $combineUserId = $value['combineUserId']; $addTime = $value['addTime']; if (empty($combineSpu)) { continue; } $tName = 'pc_auto_create_spu'; $where = "WHERE spu='{$combineSpu}'"; $count1 = OmAvailableModel::getTNameCount($tName, $where); if (!$count1) { $dataAuto = array(); $dataAuto['spu'] = $combineSpu; $dataAuto['purchaseId'] = $combineUserId; $dataAuto['createdTime'] = $addTime; $dataAuto['status'] = 2; $dataAuto['isSingSpu'] = 2; if (strpos($combineSpu, 'CB') === 0) { $dataAuto['prefix'] = 'CB'; } OmAvailableModel::addTNameRow2arr($tName, $dataAuto); echo "{$combineSpu} insert autoCreateSpu success\n"; } else { echo "{$combineSpu} has exist autoCreateSpu\n"; } } }
session_start(); header("Content-type:text/html;charset=utf-8"); date_default_timezone_set("Asia/Shanghai"); session_cache_expire(30); //session有效时间为30分钟 $tName = 'purchase_sku_conversion'; $select = '*'; $where = "WHERE 1=1"; $purchaseSkuConvertionList = OmAvailableModel::getTNameList($tName, $select, $where); if (!empty($purchaseSkuConvertionList)) { $tName = 'pc_sku_conversion'; $where = "WHERE 1=1"; OmAvailableModel::deleteTNameRow($tName, $where); } foreach ($purchaseSkuConvertionList as $value) { $id = $value['id']; $old_sku = $value['old_sku']; $new_sku = $value['new_sku']; $user = $value['user']; $createdtime = $value['createdtime']; $modifiedtime = $value['modifiedtime']; $dataConvertion = array(); $dataConvertion['id'] = $id; $dataConvertion['old_sku'] = $old_sku; $dataConvertion['new_sku'] = $new_sku; $dataConvertion['addUserId'] = getPersonIdByName($user); $dataConvertion['createdTime'] = strtotime($createdtime); $dataConvertion['modifiedUserId'] = getPersonIdByName($user); $dataConvertion['modifiedTime'] = strtotime($modifiedtime); OmAvailableModel::addTNameRow2arr($tName, $dataConvertion); }
public function view_addOrUpdateSpeicailSpuOn() { $useId = $_SESSION['userId']; $personName = getPersonNameById($useId); if (empty($personName)) { $status = "<font color=red>系统找不到登录人信息!</font><br/>"; echo $status; exit; } if (isset($_POST['submit']) && $_POST['submit'] != '') { $uploadfile = 'addOrUpdateSpeicailSpuExcelImport_' . date("Y") . date("m") . date("d") . date("H") . date('i') . date('s') . '_' . $personName . ".xls"; if (move_uploaded_file($_FILES['upfile']['tmp_name'], 'upload/' . $uploadfile)) { echo "<font color=BLUE>文件上传成功!</font><br>"; } else { echo "<font color=red> 文件上传失败!</font>"; exit; } $fileName = 'upload/' . $uploadfile; $filePath = $fileName; $PHPExcel = new PHPExcel(); $PHPReader = new PHPExcel_Reader_Excel2007(); if (!$PHPReader->canRead($filePath)) { $PHPReader = new PHPExcel_Reader_Excel5(); if (!$PHPReader->canRead($filePath)) { echo 'no Excel'; return; } } $PHPExcel = $PHPReader->load($filePath); $currentSheet = $PHPExcel->getSheet(0); $highestRow = $currentSheet->getHighestRow(); //表格中的最大行数 echo "表格总行数为 {$highestRow} <br />"; if ($highestRow > 30000) { echo "表格不能超过30000行,请重新整理表格导入,谢谢!"; exit; } $status = ''; $flag = true; //标识检测结果 $tName = 'pc_special_property'; $select = 'id,propertyName'; $where = "WHERE isOn=1"; $pspList = OmAvailableModel::getTNameList($tName, $select, $where); $IPArr = array(); foreach ($pspList as $value) { $IPArr[$value['id']] = $value['propertyName']; } if (empty($IPArr)) { echo "启用的特殊属性记录为空,退出"; exit; } for ($i = 2; $i <= $highestRow; $i++) { //先检查导入表格的正确性 $spu = trim($currentSheet->getCell('A' . $i)->getValue()); //spu $spu = preg_replace("/(\\s|\\ \\;| | )/", "", $spu); $spu = strpos($spu, '_') === false ? str_pad($spu, 3, '0', STR_PAD_LEFT) : $spu; $specailPropertyName = trim($currentSheet->getCell('B' . $i)->getValue()); //$specailPropertyName = preg_replace("/(\s|\ \;| |\xc2\xa0)/","",$specailPropertyName); if (empty($spu)) { $status .= "第 {$i} 行,SPU为空 <br/>"; $flag = false; continue; } $tName = 'pc_auto_create_spu'; $where = "WHERE is_delete=0 AND isSingSpu=1 AND spu='{$spu}'"; if (!OmAvailableModel::getTNameCount($tName, $where)) { $status .= "第 {$i} 行,SPU不存在 <br/>"; $flag = false; continue; } $propertyId = intval(array_search($specailPropertyName, $IPArr)); if ($propertyId <= 0) { $status .= "第 {$i} 行,找不到 {$specailPropertyName} 这个特殊属性记录 <br/>"; $flag = false; continue; } } if (!$flag) { //验证不通过 echo "<font color=red>{$status}</font>"; exit; } else { $status = ''; for ($i = 2; $i <= $highestRow; $i++) { //先检查导入表格的正确性 $spu = trim($currentSheet->getCell('A' . $i)->getValue()); //spu $spu = preg_replace("/(\\s|\\ \\;| | )/", "", $spu); $spu = strpos($spu, '_') === false ? str_pad($spu, 3, '0', STR_PAD_LEFT) : $spu; $specailPropertyName = trim($currentSheet->getCell('B' . $i)->getValue()); //spu $propertyId = intval(array_search($specailPropertyName, $IPArr)); $tName = 'pc_special_property_spu'; $where = "WHERE spu='{$spu}' AND propertyId={$propertyId}"; if (OmAvailableModel::getTNameCount($tName, $where)) { $status .= "第 {$i} 行,{$spu} 已经存在 {$specailPropertyName} 这个特殊属性<br/>"; } else { $dataArr = array(); $dataArr['spu'] = $spu; $dataArr['propertyId'] = $propertyId; OmAvailableModel::addTNameRow2arr($tName, $dataArr); $status .= "第 {$i} 行,{$spu} 添加至 {$specailPropertyName} 成功 <br/>"; } } echo "<font color=green>{$status}</font>"; exit; } } }
public function view_addAppointPerson() { $searchDepId = $_GET['searchDepId'] ? post_check(trim($_GET['searchDepId'])) : 0; $searchUserId = $_GET['searchUserId'] ? post_check(trim($_GET['searchUserId'])) : 0; $addDepId = $_GET['addDepId'] ? post_check(trim($_GET['addDepId'])) : 0; $addUserId = $_GET['addUserId'] ? post_check(trim($_GET['addUserId'])) : 0; $addDepId = intval($addDepId); $addUserId = intval($addUserId); $status = ''; if ($addDepId <= 0 || $addUserId <= 0) { $status = "部门或指派工程师为空,添加失败"; } else { $addDepName = getDepNameByDepId($addDepId); $addUserName = getPersonNameById($addUserId); if (empty($addDepName) || empty($addUserName)) { $status = "部门或指派工程师不存在,添加失败"; } else { $tName = 'pc_products_appoint_person'; $where = "WHERE is_delete=0 AND depId='{$addDepId}' AND appointPersonId='{$addUserId}'"; $isExistDU = OmAvailableModel::getTNameCount($tName, $where); if ($isExistDU) { $status = "记录已经存在,添加失败"; } else { $dataArr = array(); $dataArr['depId'] = $addDepId; $dataArr['appointPersonId'] = $addUserId; $dataArr['addUserId'] = $_SESSION['userId']; $dataArr['addTime'] = time(); OmAvailableModel::addTNameRow2arr($tName, $dataArr); $status = "部门:{$addDepName} 指派工程师:{$addUserName} 添加成功"; } } } header("Location:index.php?mod=products&act=getAppointPersonList&status={$status}&addDepId={$addDepId}&addUserId={$addUserId}&searchDepId={$searchDepId}&searchUserId={$searchUserId}"); }
echo "{$spu} spuArchive update category and purchaseId success! {$value['goods_category']} {$pcGoodsArr['purchaseId']} \n"; //continue; } $dataSpuArchive = array(); $dataSpuArchive['spu'] = $spu; $dataSpuArchive['categoryPath'] = $value['goods_category']; $dataSpuArchive['spuName'] = $value['goods_name']; $dataSpuArchive['spuPurchasePrice'] = $value['goods_cost']; $dataSpuArchive['spuLowestPrice'] = $value['goods_cost']; $dataSpuArchive['spuCalWeight'] = $value['goods_weight']; $dataSpuArchive['isPacking'] = $value['ispacking'] == 0 ? 1 : 2; $dataSpuArchive['spuNote'] = $value['goods_note']; $dataSpuArchive['spuSort'] = $value['mainsku']; $dataSpuArchive['purchaseId'] = $purchaseId; $dataSpuArchive['spuCreatedTime'] = $now; $dataSpuArchive['spuStatus'] = $value['isuse'] == 1 ? 2 : 1; //上、下线状态 $dataSpuArchive['auditStatus'] = 2; $dataSpuArchive['referMonthSales'] = 100; $dataSpuArchive['lowestUrl'] = 'taobao.com'; $dataSpuArchive['bidUrl'] = 'taobao.com'; if (!$countSpuArchive) { OmAvailableModel::addTNameRow2arr($tName, $dataSpuArchive); echo "{$spu} spuArchive insert success\n"; } } //}else{ // echo "{$pcGoodsArr['sku']} insert fail!\n"; // } } }
function act_confirmReceivingByMFG() { $ioStoreId = !empty($_POST['ioStoreId']) ? $_POST['ioStoreId'] : 0; $comfirmUserId = $_SESSION['userId']; $now = time(); if (intval($ioStoreId) <= 0) { self::$errCode = '101'; self::$errMsg = "id有误"; return false; } if (intval($comfirmUserId) <= 0) { self::$errCode = '102'; self::$errMsg = "登陆超时,请重试"; return false; } $tName = 'pc_products_iostore'; $select = '*'; $where = "WHERE is_delete=0 AND isAudit=2 AND id='{$ioStoreId}'"; $ioStoreList = OmAvailableModel::getTNameList($tName, $select, $where); if (empty($ioStoreList)) { self::$errCode = '103'; self::$errMsg = "该单据不存在或者未审核通过"; return false; } try { BaseModel::begin(); //标记表头已经确认 $dataIoStore = array(); $dataIoStore['isComfirm'] = 2; //标记单据已经确认 $dataIoStore['comfirmUserId'] = $comfirmUserId; $dataIoStore['comfirmTime'] = $now; OmAvailableModel::updateTNameRow2arr($tName, $dataIoStore, $where); //标记表体确认 $tName = 'pc_products_iostore_detail'; $dataIoStoreDetail = array(); $dataIoStoreDetail['isComfirm'] = 2; $where = "WHERE iostoreId='{$ioStoreId}'"; OmAvailableModel::updateTNameRow2arr($tName, $dataIoStoreDetail, $where); //如果是新品领料单,则产品部确认后,该单据下的sku才进入产品制作表 if ($ioStoreList[0]['iostoreTypeId'] == 1 && $ioStoreList[0]['useTypeId'] == 1) { $select = 'sku'; $skuList = OmAvailableModel::getTNameList($tName, $select, $where); foreach ($skuList as $value) { $sku = $value['sku']; $tName = 'pc_products'; $dataProducts = array(); $dataProducts['sku'] = $sku; OmAvailableModel::addTNameRow2arr($tName, $dataProducts); //将detail中的sku加入到产品制作表中 } } 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; } }
public function view_addCombineOn() { $combineSpu = $_POST['combineSpu'] ? post_check(trim($_POST['combineSpu'])) : ''; if (empty($combineSpu)) { $status = "空的SPU"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if (intval($_SESSION['userId']) <= 0) { $status = "登陆超时!"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } $tName = 'pc_auto_create_spu'; $select = 'status'; $where = "WHERE spu='{$combineSpu}' and is_delete=0"; $autoSpuList = OmAvailableModel::getTNameList($tName, $select, $where); if (empty($autoSpuList)) { $status = "自动生成SPU列表中不存在 {$combineSpu}"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } $amount = $_POST['amount'] ? post_check(trim($_POST['amount'])) : 0; $amount = intval($amount); if ($amount <= 0 || $amount > 500) { $status = "数量必须在1-500之间"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } $tName = 'pc_goods_combine'; $where = "WHERE is_delete=0 AND combineSpu='{$combineSpu}'"; $countComSpu = OmAvailableModel::getTNameCount($tName, $where); $tmpArr = array(); for ($index = 0; $index <= $amount; $index++) { $combineSku = $_POST['combineSku' . $index] ? post_check(trim($_POST['combineSku' . $index])) : ''; $combineSku = $combineSpu . $combineSku; if ($index == 0 && $countComSpu > 0 && $combineSku == $combineSpu) { $status = "存在为空的子料号,请检查!"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if ($index > 0 && $combineSku == $combineSpu) { //只可能index=0时候,$combineSku==$combineSpu,其他表示无效 continue; } $combineLength = $_POST['combineLength' . $index] ? post_check(trim($_POST['combineLength' . $index])) : ''; $combineWidth = $_POST['combineWidth' . $index] ? post_check(trim($_POST['combineWidth' . $index])) : ''; $combineHeight = $_POST['combineHeight' . $index] ? post_check(trim($_POST['combineHeight' . $index])) : ''; $combineNote = $_POST['combineNote' . $index] ? trim($_POST['combineNote' . $index]) : ''; $skuArr = $_POST['sku' . $index]; $countArr = $_POST['count' . $index]; if (strlen($combineSku) > 30) { $status = "{$combineSku} 字符长度大于30,错误!"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if (!preg_match("/^{$combineSpu}(_[A-Z0-9]+)*\$/", $combineSku)) { $status = "{$combineSku} 不规范,请检查格式是否正确"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if ($combineSku == $combineSpu && $amount > 1) { $status = "存在SKU为空的参数"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } $tmpArr[] = $combineSku; if (!empty($combineLength)) { if (!is_numeric($combineLength) || $combineLength < 0) { $status = "{$combineSku} 长度必须为数字"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } } if (!empty($combineWidth)) { if (!is_numeric($combineWidth) || $combineWidth < 0) { $status = "{$combineSku} 宽度必须为数字"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } } if (!empty($combineHeight)) { if (!is_numeric($combineHeight) || $combineHeight < 0) { $status = "{$combineSku} 高度必须为数字"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } } if (empty($skuArr[0]) || empty($countArr[0])) { $status = "{$combineSku} 至少要包含一条不为空的真实料号对应记录"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } $tName = 'pc_goods_combine'; $where = "WHERE combineSku='{$combineSku}' and is_delete=0"; $count = OmAvailableModel::getTNameCount($tName, $where); if ($count) { $status = "{$combineSku} 已经存在"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if (count($skuArr) != count(array_unique($skuArr))) { $status = "{$combineSku} 中存在重复的真实料号,请检查"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } $tName = 'pc_goods'; foreach ($skuArr as $value) { if (!empty($value)) { $where = "WHERE sku='{$value}' and is_delete=0"; $count = OmAvailableModel::getTNameCount($tName, $where); if (!$count) { $status = "{$combineSku} 真实料号 {$value} 不存在"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } } } foreach ($countArr as $value) { if (intval($value) <= 0) { $status = "{$combineSku} 对应真实料号的数量有误"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } } } $tmpArr = array_filter($tmpArr); if (count($tmpArr) != count(array_unique($tmpArr))) { $status = "存在重复的虚拟子料号,请检查!"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } try { $ebayGoodsArr = array(); //同步数据数组 BaseModel::begin(); for ($index = 0; $index <= $amount; $index++) { $combineSku = $_POST['combineSku' . $index] ? post_check(trim($_POST['combineSku' . $index])) : ''; $combineSku = $combineSpu . $combineSku; if ($index > 0 && $combineSku == $combineSpu) { //只可能index=0时候,$combineSku==$combineSpu,其他表示无效 continue; } $combineLength = $_POST['combineLength' . $index] ? post_check(trim($_POST['combineLength' . $index])) : ''; $combineWidth = $_POST['combineWidth' . $index] ? post_check(trim($_POST['combineWidth' . $index])) : ''; $combineHeight = $_POST['combineHeight' . $index] ? post_check(trim($_POST['combineHeight' . $index])) : ''; $combineNote = $_POST['combineNote' . $index] ? trim($_POST['combineNote' . $index]) : ''; $skuArr = $_POST['sku' . $index]; $countArr = $_POST['count' . $index]; $dataCom = array(); $dataCom['combineSpu'] = $combineSpu; $dataCom['combineSku'] = $combineSku; $dataCom['combineCost'] = $combineCost; $dataCom['combineWeight'] = $combineWeight; $dataCom['combineLength'] = $combineLength; $dataCom['combineWidth'] = $combineWidth; $dataCom['combineHeight'] = $combineHeight; $dataCom['combineNote'] = $combineNote; $dataCom['combineUserId'] = $_SESSION['userId']; $dataCom['addTime'] = time(); $tName = 'pc_goods_combine'; $insertIdCom = OmAvailableModel::addTNameRow2arr($tName, $dataCom); if (!$insertIdCom) { throw new Exception('add combine error'); } $dataRelation = array(); $dataRelationMem = array(); for ($i = 0; $i < count($skuArr); $i++) { if (!empty($skuArr[$i]) && !empty($countArr[$i])) { $dataRelation[] = array('combineSku' => $combineSku, 'sku' => $skuArr[$i], 'count' => $countArr[$i]); $dataRelationMem[] = array('sku' => $skuArr[$i], 'count' => $countArr[$i]); } } if (!empty($dataRelation)) { $tName = 'pc_sku_combine_relation'; $where = "WHERE combineSku='{$combineSku}'"; $dataRelationCount = OmAvailableModel::getTNameCount($tName, $where); if ($dataRelationCount) { OmAvailableModel::deleteTNameRow($tName, $where); } foreach ($dataRelation as $value) { if (!empty($value['combineSku']) && !empty($value['sku']) && !empty($value['count'])) { $insertId = OmAvailableModel::addTNameRow2arr($tName, $value); } } } if ($autoSpuList[0]['status'] != 2) { $tName = 'pc_auto_create_spu'; $set = "SET status=2"; $where = "WHERE spu='{$combineSpu}'"; $affectRow = OmAvailableModel::updateTNameRow($tName, $set, $where); } //将新添加的sku添加到mem中 $key = 'pc_goods_combine_' . $combineSku; $dataCom['detail'] = $dataRelationMem; $value = $dataCom; setMemNewByKey($key, $value); //这里不保证能添加成功 //同步新数据到旧系统中 $ebayProductsCombine = array(); $ebayProductsCombine['id'] = $insertIdCom; $ebayProductsCombine['goods_sn'] = $combineSku; $goods_sncombine = array(); $truesku = array(); foreach ($dataRelationMem as $value) { $str = ''; $strTrue = ''; $str = $value['sku'] . '*' . $value['count']; $strTrue = '[' . $value['sku'] . ']'; $goods_sncombine[] = $str; $truesku[] = $strTrue; } $ebayProductsCombine['goods_sncombine'] = implode(',', $goods_sncombine); $ebayProductsCombine['notes'] = $combineNote; $ebayProductsCombine['goods_price'] = $combineCost; $ebayProductsCombine['goods_weight'] = $combineWeight; $ebayProductsCombine['cguser'] = getPersonNameById($_SESSION['userId']); $ebayProductsCombine['ebay_user'] = '******'; $ebayProductsCombine['createdtime'] = time(); $ebayProductsCombine['truesku'] = implode(',', $truesku); $ebayGoodsArr[] = $ebayProductsCombine; } BaseModel::commit(); BaseModel::autoCommit(); addSalerInfoForAny($combineSpu, 2, $_SESSION['userId'], $_SESSION['userId']); //add by zqt 20140519,添加销售人逻辑 //同步数据到深圳ERP foreach ($ebayGoodsArr as $value) { $ret = OmAvailableModel::newData2ErpInterfOpen('pc.erp.addGoodsCombine', $value, 'gw88'); } $status = "添加成功"; echo '<script language="javascript"> alert("' . $status . '"); window.parent.location.href = "index.php?mod=goods&act=getCombineList&searchComField=1&fieldValue=' . $combineSpu . '"; </script>'; exit; } catch (Exception $e) { BaseModel::rollback(); BaseModel::autoCommit(); echo $e->getMessage(); $status = "添加失败,请联系系统技术部,谢谢"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; } }
function act_addPECountOn() { $PEId = intval($_POST['PEId']); $count = intval($_POST['count']); if ($PEId <= 0) { $status = "无效记录"; echo '<script language="javascript"> alert("' . $status . '"); window.history.back(); </script>'; exit; } if ($count <= 0) { $status = "数量必须为正整数"; echo '<script language="javascript"> alert("' . $status . '"); window.history.back(); </script>'; exit; } if (intval($_SESSION['userId']) <= 0) { $status = "登陆超时"; echo '<script language="javascript"> alert("' . $status . '"); window.history.back(); </script>'; exit; } $tName = 'pc_products_pe_count'; $where = "WHERE is_delete=0 AND PEId='{$PEId}'"; $isExsit = OmAvailableModel::getTNameCount($tName, $where); if ($isExsit) { $status = "已经存在该产品工程师的指派数量记录"; echo '<script language="javascript"> alert("' . $status . '"); window.history.back(); </script>'; exit; } $dataArr = array(); $dataArr['PEId'] = $PEId; $dataArr['count'] = $count; $dataArr['addUserId'] = $_SESSION['userId']; $dataArr['addTime'] = time(); $tName = 'pc_products_pe_count'; OmAvailableModel::addTNameRow2arr($tName, $dataArr); $status = "添加成功"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; header("Location:index.php?mod=products&act=getProductsPECountList&status={$status}"); exit; }
public function act_batchAddSpecialTMSpuOn() { $stmnId = $_POST['stmnId']; $spuArr = $_POST['spuArr']; if (intval($stmnId) <= 0) { self::$errCode = '101'; self::$errMsg = "异常,错误"; return false; } if (!is_array($spuArr) || empty($spuArr)) { self::$errCode = '102'; self::$errMsg = "SPU信息为空"; return false; } $spuArr = array_filter($spuArr); //print_r($spuArr);exit; $returnArr = array(); $spanStatus = ''; $insertSpuArr = array(); foreach ($spuArr as $spu) { if (preg_match("/^[A-Z0-9]+\$/", $spu)) { $tName = 'pc_special_transport_manager_spu'; $where = "WHERE spu='{$spu}'"; $pstmnSpuIsExist = OmAvailableModel::getTNameCount($tName, $where); if (!$pstmnSpuIsExist) { $tName = 'pc_goods'; $where = "WHERE is_delete=0 AND spu='{$spu}'"; $spuIsExist = OmAvailableModel::getTNameCount($tName, $where); if ($spuIsExist) { $tName = 'pc_special_transport_manager_spu'; $dataTmpArr = array(); $dataTmpArr['stmnId'] = $stmnId; $dataTmpArr['spu'] = $spu; $insertId = OmAvailableModel::addTNameRow2arr($tName, $dataTmpArr); $insertSpuArr[$insertId] = $spu; $spanStatus .= "<font color='green'>{$spu} 添加成功</font><br/>"; } else { $spanStatus .= "<font color='red'>{$spu} 在产品信息中不存在</font><br/>"; } } else { $spanStatus .= "<font color='red'>{$spu} 已经存在于特殊料号-运输方式管理中</font><br/>"; } } else { $spanStatus .= "<font color='red'>{$spu} 格式有误</font><br/>"; } } $returnArr['spanStatus'] = $spanStatus; $returnArr['insertSpuArr'] = $insertSpuArr; self::$errCode = '200'; self::$errMsg = "操作成功"; return $returnArr; }
function act_addProductsCategoryAppoint() { $largeCategoryId = intval($_POST['largeCategoryId']); $appointPEId = intval($_POST['appointPEId']); $addUserId = $_SESSION['userId']; if ($largeCategoryId <= 0 || $appointPEId <= 0 || $addUserId <= 0) { self::$errCode = '101'; self::$errMsg = '必填项为空或登录超时,请检查'; return false; } $tName = 'pc_products_large_category_appoint'; $where = "WHERE is_delete=0 AND appointPEId={$appointPEId} AND largeCategoryId={$largeCategoryId}"; if (OmAvailableModel::getTNameCount($tName, $where)) { self::$errCode = '102'; self::$errMsg = '已经存在该记录'; return false; } $dataArr = array(); $dataArr['largeCategoryId'] = $largeCategoryId; $dataArr['appointPEId'] = $appointPEId; $dataArr['addUserId'] = $addUserId; $dataArr['addTime'] = time(); OmAvailableModel::addTNameRow2arr($tName, $dataArr); self::$errCode = '200'; self::$errMsg = '添加成功'; return true; }
public function view_updateSpuPersonOn() { $spu = $_POST['spu'] ? post_check(trim($_POST['spu'])) : ''; $isSingSpu = $_POST['isSingSpu'] ? post_check(trim($_POST['isSingSpu'])) : 0; $ebaySalerId = $_POST['ebaySalerId'] ? post_check(trim($_POST['ebaySalerId'])) : 0; $aliexpressSalerId = $_POST['aliexpressSalerId'] ? post_check(trim($_POST['aliexpressSalerId'])) : 0; $amazonSalerId = $_POST['amazonSalerId'] ? post_check(trim($_POST['amazonSalerId'])) : 0; $overseaSalerId = $_POST['overseaSalerId'] ? post_check(trim($_POST['overseaSalerId'])) : 0; $webMakerId = $_POST['webMakerId'] ? post_check(trim($_POST['webMakerId'])) : 0; if ($isSingSpu != 1 && $isSingSpu != 2) { $status = "基础数据 单/虚拟料号出错!"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if (intval($_SESSION['userId']) <= 0) { $status = "登陆超时,请重新登陆"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if (intval($ebaySalerId) <= 0 && intval($aliexpressSalerId) <= 0 && intval($amazonSalerId) <= 0 && !isAccessAll('autoCreateSpu', 'isCanUpdateWebMakerPower')) { $status = "ebay/aliexpress/amazon 平台中至少要存在一个销售人员记录才能提交"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } try { BaseModel::begin(); $status = ''; if ($isSingSpu == 1) { $tName = 'pc_spu_saler_single'; } else { $tName = 'pc_spu_saler_combine'; } $select = 'isAgree,salerId'; if (!empty($ebaySalerId)) { $where = "WHERE is_delete=0 AND spu='{$spu}' AND platformId=1"; //ebay平台 $ebaySpuSalerList = OmAvailableModel::getTNameList($tName, $select, $where); if (!empty($ebaySpuSalerList)) { //更新时如果人员改动会更新是否接手状态,但是不会更新是否被销售同意/拒绝状态 if ($ebaySpuSalerList[0]['salerId'] != $ebaySalerId) { $dataEbayArr = array(); $dataEbayArr['salerId'] = $ebaySalerId; $dataEbayArr['isAgree'] = 1; //add by zqt 20140421,如果换人了的话,则变为待定状态 $dataEbayArr['addTime'] = time(); OmAvailableModel::updateTNameRow2arr($tName, $dataEbayArr, $where); } } else { //插入新数据时,则默认销售同意/拒绝状态为待定 $dataEbayArr = array(); $dataEbayArr['spu'] = $spu; $dataEbayArr['salerId'] = $ebaySalerId; $dataEbayArr['platformId'] = 1; $dataEbayArr['addTime'] = time(); $dataEbayArr['isAgree'] = 1; OmAvailableModel::addTNameRow2arr($tName, $dataEbayArr); } } if (!empty($aliexpressSalerId)) { $where = "WHERE is_delete=0 AND spu='{$spu}' AND platformId=2"; //ali平台 $ebaySpuSalerList = OmAvailableModel::getTNameList($tName, $select, $where); if (!empty($ebaySpuSalerList)) { //更新时如果人员改动会更新是否接手状态,但是不会更新是否被销售同意/拒绝状态 if ($ebaySpuSalerList[0]['salerId'] != $aliexpressSalerId) { $dataEbayArr = array(); $dataEbayArr['salerId'] = $aliexpressSalerId; $dataEbayArr['isAgree'] = 1; //add by zqt 20140421,如果换人了的话,则变为待定状态 $dataEbayArr['addTime'] = time(); OmAvailableModel::updateTNameRow2arr($tName, $dataEbayArr, $where); } } else { //插入新数据时,则默认销售同意/拒绝状态为待定 $dataEbayArr = array(); $dataEbayArr['spu'] = $spu; $dataEbayArr['salerId'] = $aliexpressSalerId; $dataEbayArr['platformId'] = 2; $dataEbayArr['addTime'] = time(); $dataEbayArr['isAgree'] = 1; OmAvailableModel::addTNameRow2arr($tName, $dataEbayArr); } } if (!empty($amazonSalerId)) { $where = "WHERE is_delete=0 AND spu='{$spu}' AND platformId=11"; //amazon平台 $ebaySpuSalerList = OmAvailableModel::getTNameList($tName, $select, $where); if (!empty($ebaySpuSalerList)) { //更新时如果人员改动会更新是否接手状态,但是不会更新是否被销售同意/拒绝状态 if ($ebaySpuSalerList[0]['salerId'] != $amazonSalerId) { $dataEbayArr = array(); $dataEbayArr['salerId'] = $amazonSalerId; $dataEbayArr['isAgree'] = 1; //add by zqt 20140421,如果换人了的话,则变为待定状态 $dataEbayArr['addTime'] = time(); OmAvailableModel::updateTNameRow2arr($tName, $dataEbayArr, $where); } } else { //插入新数据时,则默认销售同意/拒绝状态为待定 $dataEbayArr = array(); $dataEbayArr['spu'] = $spu; $dataEbayArr['salerId'] = $amazonSalerId; $dataEbayArr['platformId'] = 11; $dataEbayArr['addTime'] = time(); $dataEbayArr['isAgree'] = 1; OmAvailableModel::addTNameRow2arr($tName, $dataEbayArr); } } if (!empty($overseaSalerId)) { $where = "WHERE is_delete=0 AND spu='{$spu}' AND platformId=14"; //amazon平台 $ebaySpuSalerList = OmAvailableModel::getTNameList($tName, $select, $where); if (!empty($ebaySpuSalerList)) { //更新时如果人员改动会更新是否接手状态,但是不会更新是否被销售同意/拒绝状态 if ($ebaySpuSalerList[0]['salerId'] != $overseaSalerId) { $dataEbayArr = array(); $dataEbayArr['salerId'] = $overseaSalerId; $dataEbayArr['isAgree'] = 1; //add by zqt 20140421,如果换人了的话,则变为待定状态 $dataEbayArr['addTime'] = time(); OmAvailableModel::updateTNameRow2arr($tName, $dataEbayArr, $where); } } else { //插入新数据时,则默认销售同意/拒绝状态为待定 $dataEbayArr = array(); $dataEbayArr['spu'] = $spu; $dataEbayArr['salerId'] = $overseaSalerId; $dataEbayArr['platformId'] = 14; $dataEbayArr['addTime'] = time(); $dataEbayArr['isAgree'] = 1; OmAvailableModel::addTNameRow2arr($tName, $dataEbayArr); } } if (!empty($webMakerId)) { $tName = 'pc_spu_web_maker'; $select = 'webMakerId,isAgree,isTake'; $where = "WHERE is_delete=0 AND spu='{$spu}' order by id desc limit 1"; $spuWebMakerList = OmAvailableModel::getTNameList($tName, $select, $where); if (empty($spuWebMakerList)) { //不存在该SPU的指派记录 $dataWebMakerArr = array(); $dataWebMakerArr['spu'] = $spu; $dataWebMakerArr['isSingSpu'] = $isSingSpu; $dataWebMakerArr['webMakerId'] = $webMakerId; $dataWebMakerArr['isAgree'] = 1; //add by 20140513,待定状态 $dataWebMakerArr['addTime'] = time(); OmAvailableModel::addTNameRow2arr($tName, $dataWebMakerArr); } else { //存在指派记录时 if ($spuWebMakerList[0]['webMakerId'] != $webMakerId) { //提交的人和之前的不一致则修改/添加,否则不变 if ($spuWebMakerList[0]['isTake'] == 1) { //如果是已经被工程师领取,则表示接手 $dataWebMakerArr = array(); $dataWebMakerArr['spu'] = $spu; $dataWebMakerArr['isSingSpu'] = $isSingSpu; $dataWebMakerArr['webMakerId'] = $webMakerId; $dataWebMakerArr['addTime'] = time(); $dataWebMakerArr['isAgree'] = $spuWebMakerList[0]['isAgree']; //add by 20140513,同意/拒绝状态不变 $dataWebMakerArr['isHandsOn'] = 1; OmAvailableModel::addTNameRow2arr($tName, $dataWebMakerArr); } else { //如果未被领取,则只是修改记录 $dataWebMakerArr = array(); $dataWebMakerArr['webMakerId'] = $webMakerId; $dataWebMakerArr['addTime'] = time(); $dataWebMakerArr['isAgree'] = 1; //add by 20140513,未领取的话,重新变成待定状态 OmAvailableModel::updateTNameRow2arr($tName, $dataWebMakerArr, $where); } } } } BaseModel::commit(); BaseModel::autoCommit(); $status = "更新成功"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } catch (Exception $e) { BaseModel::rollback(); BaseModel::autoCommit(); $status = $e->getMessage(); echo '<script language="javascript"> alert("' . '添加失败——' . $status . '"); </script>'; exit; } }
function addOrUpdateSalerInfo($platformId, $spu, $isSingSpu, $salerId) { if ($isSingSpu == 1) { //单料号 $tName = 'pc_spu_saler_single'; } else { $tName = 'pc_spu_saler_combine'; } $select = 'salerId'; $where = "WHERE is_delete=0 AND spu='{$spu}' AND platformId='{$platformId}'"; $oldSalerList = OmAvailableModel::getTNameList($tName, $select, $where); $dataArr = array(); if (empty($oldSalerList)) { //如果记录不存在,则插入数据 $dataArr['platformId'] = $platformId; $dataArr['spu'] = $spu; $dataArr['salerId'] = $salerId; $dataArr['addTime'] = time(); OmAvailableModel::addTNameRow2arr($tName, $dataArr); } else { //有该平台及该SPU的销售人记录时 if ($oldSalerList[0]['salerId'] != $salerId) { //如果销售人不同时,则修改 $dataArr['salerId'] = $salerId; $dataArr['isHandsOn'] = 1; //更改接手状态 $dataArr['addTime'] = time(); //更新添加时间 OmAvailableModel::updateTNameRow2arr($tName, $dataArr, $where); } } }
function act_updateSkuConversion() { $id = $_GET['id'] ? post_check(trim($_GET['id'])) : 0; $id = intval($id); $new_sku = $_GET['new_sku'] ? post_check(trim($_GET['new_sku'])) : ''; //new_sku $modifiedUserId = intval($_SESSION['userId']); $modifiedTime = time(); if ($modifiedUserId <= 0) { self::$errCode = '103'; self::$errMsg = "登陆超时,请重试"; return; } if ($id <= 0) { self::$errCode = '100'; self::$errMsg = "异常"; return; } if (empty($new_sku)) { self::$errCode = '101'; self::$errMsg = "新料号不能为空"; return; } if (!preg_match("/^[A-Z0-9]+(_[A-Z0-9]+)*\$/", $new_sku)) { self::$errCode = '100'; self::$errMsg = "新料号 {$new_sku} 格式不合法"; return; } if ($modifiedUserId <= 0) { self::$errCode = '103'; self::$errMsg = "登陆超时,请重试"; return; } $tName = 'pc_sku_conversion'; $select = 'new_sku'; $where = "WHERE id={$id} and is_delete=0"; $skuConNewSkuList = OmAvailableModel::getTNameList($tName, $select, $where); //在料号转换表中找到id所在记录的新料号new_sku $skuConNewSku = $skuConNewSkuList[0]['new_sku']; if (empty($skuConNewSku)) { self::$errCode = '104'; self::$errMsg = "记录的新料号不存在"; return; } if ($skuConNewSku == $new_sku) { self::$errCode = '111'; self::$errMsg = "修改前后料号相同,无修改"; return; } $tName = 'pc_goods'; $select = '*'; $where = "WHERE is_delete=0 AND sku='{$skuConNewSku}'"; $newSkuPcList = OmAvailableModel::getTNameList($tName, $select, $where); //在产品表里找是否存在未修改前的料号 $newSkuPc = $newSkuPcList[0]; //未修改前的料号信息 if (empty($newSkuPc)) { self::$errCode = '105'; self::$errMsg = "修改前的料号 {$skuConNewSku} 在产品列表中不存在"; return; } $newSkuPcSku = $newSkuPc['sku']; //$newSkuPcArr = array_filter(explode('_',$newSkuPc));//修改前的sku按照_来截取 // $newSpuPc = $newSkuPcArr[0];//取得新料号的SPU // $newSkuArr = array_filter(explode('_',$new_sku));//修改后的sku按照_来截取 // $newSpu = $newSkuArr[0];//取得新料号的SPU // if($newSpuPc != $newSpu){ // self::$errCode = '107'; // self::$errMsg = "修改前后的SPU不符,请检查"; // return; // } try { BaseModel::begin(); $tName = 'pc_sku_conversion'; $set = "SET new_sku='{$new_sku}',modifiedUserId='{$modifiedUserId}',modifiedTime='{$modifiedTime}'"; $where = "WHERE id={$id} and is_delete=0"; OmAvailableModel::updateTNameRow($tName, $set, $where); //先将转换记录修改 $tName = 'pc_goods'; $set = "SET goodsStatus=101,is_delete=1"; //将未修改前的sku状态改为 料号转化,并delete $where = "WHERE is_delete=0 and sku='{$newSkuPcSku}'"; OmAvailableModel::updateTNameRow($tName, $set, $where); $where = "WHERE is_delete=0 and sku='{$new_sku}'"; $newSkuCount = OmAvailableModel::getTNameCount($tName, $where); if ($newSkuCount) { //如果新料号在产品中已经存在,则只添加转换记录 self::$errCode = '200'; self::$errMsg = "修改转换记录成功,新料号:{$new_sku} 已经存在记录"; } else { //如果新料号在产品表中不存在,则自动添加旧料号的记录进去 unset($newSkuPc['id']); //去掉旧记录的id $newSkuPc['sku'] = $new_sku; //将旧的sku换成新的sku OmAvailableModel::addTNameRow2arr($tName, $newSkuPc); self::$errCode = '200'; self::$errMsg = "修改转换记录成功,新料号:{$new_sku} 记录已插入成功"; } //下面对关联单料号的组合料号进行修改 $tName = 'pc_sku_combine_relation'; $select = '*'; $where = "WHERE sku='{$newSkuPcSku}' group by combineSku"; $skuRelationList = OmAvailableModel::getTNameList($tName, $select, $where); if (empty($skuRelationList)) { self::$errMsg .= "<br/>其中,无关联组合料号被更新"; } else { $combineSkuArr = array(); foreach ($skuRelationList as $value) { $combineSkuArr[] = $value['combineSku']; } $combineSkuStr = implode(',', $combineSkuArr); $set = "SET sku='{$new_sku}'"; $where = "WHERE sku='{$newSkuPcSku}'"; $affectRows = OmAvailableModel::updateTNameRow($tName, $set, $where); self::$errMsg .= "<br/>"; self::$errMsg .= "其中,组合料号 {$combineSkuStr} 中共有 {$affectRows} 条单料号数据已更新"; } ////// BaseModel::commit(); BaseModel::autoCommit(); return; } catch (Exception $e) { BaseModel::rollback(); BaseModel::autoCommit(); self::$errCode = '404'; self::$errMsg = $e->getMessage(); return; } }
try { BaseModel::begin(); $tName = 'pc_goods_whId_location_raletion'; $where = "WHERE sku='{$sku}' AND whId='{$whId}'"; $wlraleCount = OmAvailableModel::getTNameCount($tName, $where); $tmpArr = array(); $tmpArr['sku'] = $sku; $tmpArr['isHasStock'] = $isHasStock; $tmpArr['whId'] = $whId; $tmpArr['isHasLocation'] = $isHasLocation; $tmpArr['location'] = $location; $tmpArr['storageTime'] = $storageTime; $tmpArr['updateTime'] = time(); if (!$wlraleCount) { //如果不存在记录 OmAvailableModel::addTNameRow2arr($tName, $tmpArr); echo "添加记录 成功 \n"; echo "‘ {$sku} ’ ‘ {$isHasStock} ’ ‘ {$whId} ’ ‘ {$isHasLocation} ’ ‘ {$location} ’ ‘ {$storageTime} ’ \n"; } else { //存在记录 unset($tmpArr['sku'], $tmpArr['whId']); OmAvailableModel::updateTNameRow2arr($tName, $tmpArr, $where); echo "更新记录 成功 \n"; echo "‘ {$sku} ’ ‘ {$isHasStock} ’ ‘ {$whId} ’ ‘ {$isHasLocation} ’ ‘ {$location} ’ ‘ {$storageTime} ’ \n"; } BaseModel::commit(); BaseModel::autoCommit(); } catch (Exception $e) { //发生错误则进行下次循环 BaseModel::rollback(); BaseModel::autoCommit();