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();
