/**
*功能：我自己运行的接口，批量更新数据,根据需求批量更新销售是陈智兴的虚拟料号，将其销售人员改为对应真实SPU的销售人员
* */
public function act_updateBatchForSalers()
{
$tName = 'pc_spu_saler_combine';
$select = 'spu';
$where = "WHERE is_delete=0 and platformId=2 and isAgree=2 and salerId=60";
$combineSpuList = OmAvailableModel::getTNameList($tName, $select, $where);
foreach ($combineSpuList as $value) {
$combineSpu = $value['spu'];
$tName = 'pc_goods_combine';
$select = 'combineSku';
$where = "WHERE is_delete=0 and combineSpu='{$combineSpu}'";
$combineSkuList = OmAvailableModel::getTNameList($tName, $select, $where);
if (!empty($combineSkuList)) {
$tName = 'pc_sku_combine_relation';
$select = 'sku';
$where = "WHERE combineSku='{$combineSkuList[0]['combineSku']}'";
$skuList = OmAvailableModel::getTNameList($tName, $select, $where);
if (!empty($skuList)) {
$tName = 'pc_goods';
$select = 'spu';
$where = "WHERE is_delete=0 and sku='{$skuList[0]['sku']}'";
$spuList = OmAvailableModel::getTNameList($tName, $select, $where);
if (!empty($spuList)) {
$tName = 'pc_spu_saler_single';
$select = 'salerId';
$where = "WHERE is_delete=0 and platformId=2 and isAgree=2 and spu='{$spuList[0]['spu']}'";
$singleSpuSalerIdList = OmAvailableModel::getTNameList($tName, $select, $where);
if (!empty($singleSpuSalerIdList)) {
$salerId = $singleSpuSalerIdList[0]['salerId'];
$saler = getPersonNameById($salerId);
$tName = 'pc_spu_saler_combine';
$where = "WHERE is_delete=0 and spu='{$combineSpu}'";
$dataArr = array();
$dataArr['salerId'] = $salerId;
OmAvailableModel::updateTNameRow2arr($tName, $dataArr, $where);
echo "{$combineSpu} 的原销售是 陈智兴，真实销售是 {$saler} <br />";
} else {
echo "{$combineSpu} 的原销售是 陈智兴，真实销售为空 <br />";
}
}
}
}
}
}
public function view_productsBack()
{
$sku = $_GET['sku'] ? $_GET['sku'] : '';
$id = $_GET['id'] ? $_GET['id'] : '';
$userId = $_SESSION['userId'];
$now = time();
if (intval($userId) <= 0) {
$status = "未登录";
header("Location:index.php?mod=products&act=getProductsTakeList&status={$status}&sku={$sku}");
exit;
}
if (empty($id)) {
$status = "id为空";
header("Location:index.php?mod=products&act=getProductsTakeList&status={$status}&sku={$sku}");
exit;
}
$idArr = array_filter(explode(',', $id));
foreach ($idArr as $value) {
if (intval($value) <= 0) {
$status = "含有非法id";
header("Location:index.php?mod=products&act=getProductsTakeList&status={$status}&sku={$sku}");
exit;
}
}
$newIdArr = implode(',', $idArr);
$tName = 'pc_products';
$set = "SET productsStatus=1";
$where = "WHERE id in({$newIdArr})";
OmAvailableModel::updateTNameRow($tName, $set, $where);
$takeSpuArr = array();
//同步数据到ERP
$tName = 'pc_products';
$select = 'sku';
$where = "WHERE id in({$newIdArr})";
$skuList = OmAvailableModel::getTNameList($tName, $select, $where);
foreach ($skuList as $value) {
$takeInfoArr = array();
$takeInfoArr['sku'] = $value['sku'];
$tName = 'pc_goods';
$select = 'spu';
$where = "WHERE is_delete=0 AND sku='{$value['sku']}'";
$takeSpuList = OmAvailableModel::getTNameList($tName, $select, $where);
if (!empty($takeSpuList)) {
$takeSpuArr[] = $takeSpuList[0]['spu'];
}
$res = OmAvailableModel::newData2ErpInterfOpen('pc.erp.updateEbay_order_productForBack', $takeInfoArr, 'gw88');
}
$takeSpuArr = array_unique($takeSpuArr);
foreach ($takeSpuArr as $value) {
$tName = 'pc_spu_web_maker';
$where = "WHERE is_delete=0 AND spu='{$value}' order by id desc limit 1";
$dataArr = array();
$dataArr['isTake'] = 0;
OmAvailableModel::updateTNameRow2arr($tName, $dataArr, $where);
}
$status = "退还料号成功";
header("Location:index.php?mod=products&act=getProductsComfirmList&status={$status}&sku={$sku}");
}
public function view_updateIsNewBatchExcelImportOn()
{
$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 = 'updateIsNewBatchExcelImport_' . 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();
//表格中的最大行数
//var_dump($highestRow);exit;
if ($highestRow > 500) {
echo "表格不能超过500行，请重新整理表格导入，谢谢！";
exit;
}
$status = '';
$flag = true;
//标识检测结果
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;
if (empty($spu)) {
$status .= "第 {$i} 行，SPU为空 <br/>";
$flag = false;
continue;
}
$tName = 'pc_products';
$where = "WHERE is_delete=0 and productsStatus=2 and spu='{$spu}'";
$spuCount = OmAvailableModel::getTNameCount($tName, $where);
if (!$spuCount) {
$status .= "第 {$i} 行，{$spu} 不在领取料号状态 <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;
$tName = 'pc_products';
$where = "WHERE is_delete=0 and productsStatus=2 and spu='{$spu}'";
$dataArr = array();
$dataArr['productsStatus'] = 3;
$dataArr['productsCompleteTime'] = time();
OmAvailableModel::updateTNameRow2arr($tName, $dataArr, $where);
$_POST['spu'] = $spu;
$_POST['isNew'] = 0;
$goodsAct = new GoodsAct();
$goodsAct->act_updateIsNewBatch();
$status .= "第 {$i} 行，{$spu} 更新成功 <br/>";
}
echo "<font color=green>{$status}</font>";
exit;
}
}
}
public function view_updateCombineOn()
{
$id = $_POST['id'] ? post_check(trim($_POST['id'])) : '';
$combineSpu = $_POST['combineSpu'] ? post_check(trim($_POST['combineSpu'])) : '';
$combineSku = $_POST['combineSku'] ? post_check(trim($_POST['combineSku'])) : '';
$combineLength = $_POST['combineLength'] ? post_check(trim($_POST['combineLength'])) : '';
$combineWidth = $_POST['combineWidth'] ? post_check(trim($_POST['combineWidth'])) : '';
$combineHeight = $_POST['combineHeight'] ? post_check(trim($_POST['combineHeight'])) : '';
$combineNote = $_POST['combineNote'] ? post_check(trim($_POST['combineNote'])) : '';
$skuArr = $_POST['sku'];
$countArr = $_POST['count'];
if (empty($combineSpu)) {
$status = "combineSpu为空";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
}
if (!empty($combineLength)) {
if (!is_numeric($combineLength) || $combineLength < 0) {
$status = "长度必须为数字";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
}
}
if (!empty($combineWidth)) {
if (!is_numeric($combineWidth) || $combineWidth < 0) {
$status = "宽度必须为数字";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
}
}
if (!empty($combineHeight)) {
if (!is_numeric($combineHeight) || $combineHeight < 0) {
$status = "高度必须为数字";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
}
}
//检查spu是否非法
if (intval($id) == 0) {
$status = "非法id";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
}
if (empty($combineSku)) {
$status = "combineSku为空";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
}
if (!preg_match("/^{$combineSpu}(_[A-Z0-9]+)*\$/", $combineSku)) {
$status = "combineSku为空";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
}
$tName = 'pc_goods_combine';
$where = "WHERE is_delete=0 AND combineSku='{$combineSku}' AND id<>{$id}";
//检测新sku是否已经存在
$countNewSku = OmAvailableModel::getTNameCount($tName, $where);
if ($countNewSku) {
$status = "料号 {$combineSku} 已经存在";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
}
if (empty($skuArr[0]) || empty($countArr[0])) {
$status = "至少要包含一条真实料号对应记录";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
}
$tName = 'pc_goods_combine';
$select = 'combineSku';
$where = "WHERE id={$id} and is_delete=0";
$oldComSkuList = OmAvailableModel::getTNameList($tName, $select, $where);
$oldComSku = $oldComSkuList[0]['combineSku'];
if (empty($oldComSku)) {
$status = "料号 {$oldComSku} 不存在";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
}
$count = count($skuArr);
$countFlip = count(array_flip($skuArr));
if ($count != $countFlip) {
$status = "存在重复的真实料号记录";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</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 = "真实料号 {$value} 不存在";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
}
}
}
$dataCom = array();
$dataCom['combineSku'] = $combineSku;
$dataCom['combineLength'] = $combineLength;
$dataCom['combineWidth'] = $combineWidth;
$dataCom['combineHeight'] = $combineHeight;
$dataCom['combineNote'] = $combineNote;
try {
BaseModel::begin();
$tName = 'pc_goods_combine';
$where = "WHERE id={$id}";
$affectRow = OmAvailableModel::updateTNameRow2arr($tName, $dataCom, $where);
if ($affectRow === false) {
$status = "更新失败";
throw new Exception('update combine error');
}
$dataRelation = array();
$dataRelationMem = array();
//用来更新mem中的detail数组
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}'";
$affectRow = OmAvailableModel::deleteTNameRow($tName, $where);
if ($affectRow === false) {
throw new Exception('delete combine relation error');
}
foreach ($dataRelation as $value) {
$insertId = OmAvailableModel::addTNameRow2arr($tName, $value);
if ($insertId === false) {
throw new Exception('add combine relation error');
}
}
}
//将新添加的sku添加到mem中
$key = 'pc_goods_combine_' . $combineSku;
$dataCom['combineSpu'] = $combineSpu;
$dataCom['detail'] = $dataRelationMem;
$value = $dataCom;
setMemNewByKey('pc_goods_combine_' . $oldComSku, '');
//旧的设为空
setMemNewByKey($key, $value);
//这里不保证能添加成功
BaseModel::commit();
BaseModel::autoCommit();
//同步新数据到旧系统中
$ebayProductsCombine = array();
$ebayProductsCombine['id'] = $id;
$ebayProductsCombine['old_goods_sn'] = $oldComSku;
$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['ebay_user'] = '******';
$ebayProductsCombine['createdtime'] = time();
$ebayProductsCombine['truesku'] = implode(',', $truesku);
$ret = OmAvailableModel::newData2ErpInterfOpen('pc.erp.updateCombine2', $ebayProductsCombine, 'gw88');
$status = "{$combineSku} 更新成功";
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
exit;
} catch (Exception $e) {
BaseModel::rollback();
BaseModel::autoCommit();
$status = "更新失败 " . $e->getMessage();
echo '<script language="javascript">
alert("' . $status . '");
history.go(-1);
</script>';
}
}
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;
}
}
function act_updateSpuHsRelaById()
{
$id = intval($_POST['id']);
if ($id <= 0) {
self::$errCode = '101';
self::$errMsg = '无效记录';
return false;
}
$userId = $_SESSION['userId'];
if ($id <= 0) {
self::$errCode = '103';
self::$errMsg = '登陆超时';
return false;
}
$personName = getPersonNameById($userId);
$tName = 'pc_spu_tax_hscode';
$select = 'spu';
$where = "WHERE id='{$id}'";
$psthList = OmAvailableModel::getTNameList($tName, $select, $where);
if (empty($psthList)) {
self::$errCode = '102';
self::$errMsg = "无记录";
return false;
}
$dataTmpArr = array();
$dataTmpArr['customsName'] = !empty($_POST['customsName']) ? $_POST['customsName'] : '';
$dataTmpArr['materialCN'] = !empty($_POST['materialCN']) ? $_POST['materialCN'] : '';
$dataTmpArr['customsNameEN'] = !empty($_POST['customsNameEN']) ? $_POST['customsNameEN'] : '';
$dataTmpArr['materialEN'] = !empty($_POST['materialEN']) ? $_POST['materialEN'] : '';
$dataTmpArr['hsCode'] = !empty($_POST['hsCode']) ? $_POST['hsCode'] : '';
$dataTmpArr['exportRebateRate'] = !empty($_POST['exportRebateRate']) ? $_POST['exportRebateRate'] : '';
$dataTmpArr['importMFNRates'] = !empty($_POST['importMFNRates']) ? $_POST['importMFNRates'] : '';
$dataTmpArr['generalRate'] = !empty($_POST['generalRate']) ? $_POST['generalRate'] : '';
$dataTmpArr['RegulatoryConditions'] = !empty($_POST['RegulatoryConditions']) ? $_POST['RegulatoryConditions'] : '';
$dataTmpArr = array_filter($dataTmpArr);
$jsonData = json_encode($dataTmpArr);
if (!empty($dataTmpArr)) {
OmAvailableModel::updateTNameRow2arr($tName, $dataTmpArr, $where);
error_log(date('Y-m-d_H:i') . "——{$psthList[0]['spu']} 更新成功 BY {$personName}, data: {$jsonData} \r\n", 3, WEB_PATH . "log/spuHscodeTax.txt");
self::$errCode = '200';
self::$errMsg = "更新成功";
return true;
} else {
self::$errCode = '200';
self::$errMsg = "无数据提交";
return true;
}
}
public function act_updateSpecialTMTCOn()
{
$id = $_POST['id'] ? trim($_POST['id']) : 0;
$specialTransportManagerName = $_POST['specialTransportManagerName'] ? trim($_POST['specialTransportManagerName']) : '';
$isOn = $_POST['isOn'] ? trim($_POST['isOn']) : '';
//$canOrNot = $_POST['canOrNot'] ? (trim($_POST['canOrNot'])) : '';
$transportIdArr = !empty($_POST['transportId']) ? $_POST['transportId'] : array();
//选中的transportId数组
//print_r($transportIdArr);exit;
$tName = 'pc_special_transport_manager';
$where = "WHERE id='{$id}'";
$pspIsExist = OmAvailableModel::getTNameCount($tName, $where);
if (!$pspIsExist) {
$status = "记录不存在，错误";
echo '<script language="javascript">
alert("' . $status . '");
</script>';
exit;
}
if (empty($specialTransportManagerName)) {
$status = "特殊运输方式名称为空";
echo '<script language="javascript">
alert("' . $status . '");
</script>';
exit;
}
if (intval($isOn) <= 0) {
$status = "是否启用有误";
echo '<script language="javascript">
alert("' . $status . '");
</script>';
exit;
}
if (empty($transportIdArr)) {
$status = "所选的运输方式为空，错误";
echo '<script language="javascript">
alert("' . $status . '");
</script>';
exit;
}
$tName = 'pc_special_transport_manager';
$where = "WHERE specialTransportManagerName='{$specialTransportManagerName}' AND id<>'{$id}'";
$properNameIsExist = OmAvailableModel::getTNameCount($tName, $where);
if ($properNameIsExist) {
$status = "该特殊运输方式名称已经存在，请检查";
echo '<script language="javascript">
alert("' . $status . '");
</script>';
exit;
}
try {
BaseModel::begin();
$tName = 'pc_special_transport_manager';
$dataTmpArr = array();
$dataTmpArr['specialTransportManagerName'] = $specialTransportManagerName;
$dataTmpArr['isOn'] = $isOn;
$where = "WHERE id='{$id}'";
OmAvailableModel::updateTNameRow2arr($tName, $dataTmpArr, $where);
$tName = 'pc_special_stmnid_transportid';
$select = '*';
$where = "WHERE stmnId='{$id}'";
$psptList = OmAvailableModel::getTNameList($tName, $select, $where);
$psptIdArr = array();
foreach ($psptList as $value) {
$psptIdArr[] = $value['id'];
}
$psptIdStr = !empty($psptIdArr) ? implode(',', $psptIdArr) : 0;
$tName = 'pc_special_stid_channel';
$where = "WHERE stId in({$psptIdStr})";
OmAvailableModel::deleteTNameRow($tName, $where);
//删除渠道关系表的相关数据
$tName = 'pc_special_stmnid_transportid';
$where = "WHERE stmnId='{$id}'";
OmAvailableModel::deleteTNameRow($tName, $where);
//删除运输方式关系表的相关数据
foreach ($transportIdArr as $transportId) {
if (intval($transportId) > 0) {
$channelIdArr = !empty($_POST['tc' . $transportId]) ? $_POST['tc' . $transportId] : array();
//该transpordeId下的channel数组
$tName = 'pc_special_stmnid_transportid';
$dataTmpArr = array();
$dataTmpArr['stmnId'] = $id;
$dataTmpArr['transportId'] = $transportId;
$insertPTId = OmAvailableModel::addTNameRow2arr($tName, $dataTmpArr);
if (intval($insertPTId) <= 0) {
throw new Exception('insertPTId 错误');
}
foreach ($channelIdArr as $channelId) {
if (intval($channelId) > 0) {
$tName = 'pc_special_stid_channel';
$dataTmpArr = array();
$dataTmpArr['stId'] = $insertPTId;
$dataTmpArr['channelId'] = $channelId;
OmAvailableModel::addTNameRow2arr($tName, $dataTmpArr);
}
}
}
}
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;
}
}
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);
}
}
}
$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();
echo "‘ {$sku} ’ 记录插入/更新失败，数据回滚，进入下次循环\n";
continue;
}
}
$page++;
} while ($totalPage >= $page);
