function act_auditSkuWeight() { $id = intval($_POST['id']); $auditValue = intval($_POST['auditValue']); $userId = intval($_SESSION['userId']); if ($id <= 0) { self::$errCode = '101'; self::$errMsg = '无效记录'; return false; } if ($auditValue <= 0) { self::$errCode = '102'; self::$errMsg = '无效状态'; return false; } if ($userId <= 0) { self::$errCode = '103'; self::$errMsg = '登陆超时'; return false; } $tName = 'pc_goods_weight_audit'; $select = 'sku,newWeight'; $where = "WHERE is_delete=0 and id='{$id}'"; $auditList = OmAvailableModel::getTNameList($tName, $select, $where); if (empty($auditList)) { self::$errCode = '104'; self::$errMsg = '记录为空'; return false; } try { BaseModel::begin(); $dataArr = array(); $dataArr['status'] = $auditValue; $dataArr['auditerId'] = $userId; $dataArr['auditTime'] = time(); $tName = 'pc_goods_weight_audit'; $where = "WHERE id={$id}"; OmAvailableModel::updateTNameRow2arr($tName, $dataArr, $where); if ($auditValue == 2) { //审核通过 addWeightBackupsModify($auditList[0]['sku'], $auditList[0]['newWeight'], $userId); //添加重量变化记录 $tName = 'pc_goods'; $where = "where is_delete=0 and sku='{$auditList[0]['sku']}'"; $dataArr = array(); $dataArr['goodsWeight'] = $auditList[0]['newWeight']; OmAvailableModel::updateTNameRow2arr($tName, $dataArr, $where); //同步数据到深圳erp $paraArr['goods_sn'] = $auditList[0]['sku']; $paraArr['goods_weight'] = $auditList[0]['newWeight']; $res = OmAvailableModel::newData2ErpInterfOpen('pc.erp.addGoodsSnWeight', $paraArr, 'gw88'); } BaseModel::commit(); BaseModel::autoCommit(); self::$errCode = '200'; self::$errMsg = "操作成功"; return true; } catch (Excetion $e) { BaseModel::rollback(); BaseModel::autoCommit(); self::$errCode = '404'; self::$errMsg = "系统错误--" . $e->getMessage(); return true; } }
/** *功能:提供给仓库系统的接口,重量拦截重新得到重量 * */ public function act_setSkuWeightInWh() { $sku = isset($_GET['sku']) ? $_GET['sku'] : ""; $skuweight = isset($_GET['skuweight']) ? $_GET['skuweight'] / 1000 : ""; //传递过来的重量为g $userId = isset($_GET['userId']) ? $_GET['userId'] : 0; if (intval($userId) <= 0) { self::$errCode = 111; self::$errMsg = "登陆超时,请重新登陆!"; return false; } if (empty($sku) || empty($skuweight)) { self::$errCode = 333; self::$errMsg = "料号或重量不能为空!"; return false; } $skuList = getSkuBygoodsCode($sku); //根据条码获取真实sku if (empty($skuList)) { self::$errCode = 404; self::$errMsg = '料号不存在'; return false; } $oldWeight = !empty($skuList[0]['goodsWeight']) ? $skuList[0]['goodsWeight'] : 0; //先找出该sku的重量 if ($oldWeight != $skuweight) { //如果新旧重量不相等时,则更新 try { BaseModel::begin(); $tName = 'pc_goods'; $set = "SET goodsWeight='{$skuweight}'"; $where = "WHERE sku='{$skuList[0]['sku']}'"; OmAvailableModel::updateTNameRow($tName, $set, $where); //$info = UserCacheModel::getOpenSysApi('pc.updateTNameRow',array(array('tName'=>"pc_goods",'set'=>"goodsWeight='{$skuweight}'",'where'=>"WHERE sku='{$sku}' and is_delete = 0"))); //添加重量备份记录 //$tName = 'pc_goods_weight_backups'; // $backupsArr = array (); // $backupsArr['sku'] = $skuList[0]['sku']; // $backupsArr['goodsWeight'] = $skuweight; // $backupsArr['addUserId'] = $userId; // $backupsArr['addTime'] = time(); // OmAvailableModel :: addTNameRow2arr($tName, $backupsArr); addWeightBackupsModify($skuList[0]['sku'], $skuweight, $userId); // //$url = "add2ebay_goods_weight.php?goods_sn=".$skuList[0]['sku']."&goods_weight=".$skuweight; // OmAvailableModel::newData2ErpInterf($url); $paraArr['goods_sn'] = $skuList[0]['sku']; $paraArr['goods_weight'] = $skuweight; $res = OmAvailableModel::newData2ErpInterfOpen('pc.erp.addGoodsSnWeight', $paraArr, 'gw88'); //print_r($res); // exit; BaseModel::commit(); BaseModel::autoCommit(); $string = empty($oldWeight) ? "(Kg) 录入成功!" : "(Kg) 更新成功,原来重量为 {$oldWeight}(Kg)"; self::$errCode = 200; self::$errMsg = $skuList[0]['sku'] . " 重量 " . $skuweight . $string; return true; } catch (Exception $e) { BaseModel::rollback(); BaseModel::autoCommit(); self::$errCode = 404; self::$errMsg = $skuList[0]['sku'] . " 重量 " . $skuweight . "(Kg) 录入失败! " . $e->getMessage(); return false; } } else { self::$errCode = 200; self::$errMsg = $skuList[0]['sku'] . " 重量 无修改,为 {$skuweight}(Kg)"; return true; } }
public function view_addSkuSingOn() { $spu = $_POST['spu'] ? post_check(trim($_POST['spu'])) : ''; $pid = $_POST['pid'] ? post_check(trim($_POST['pid'])) : ''; $id = $_POST['id'] ? post_check(trim($_POST['id'])) : ''; $goodsStatus = $_POST['goodsStatus'] ? post_check(trim($_POST['goodsStatus'])) : ''; $isNew = $_POST['isNew'] ? post_check(trim($_POST['isNew'])) : ''; if (!preg_match("/^[A-Z0-9]+\$/", $spu)) { $status = "非法spu"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if (empty($pid)) { $status = "类别为空"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } $skuArr = $_POST['sku']; $goodsNameArr = $_POST['goodsName']; $goodsCostArr = $_POST['goodsCost']; $goodsNoteArr = $_POST['goodsNote']; $goodsColorArr = $_POST['goodsColor']; $goodsSizeArr = $_POST['goodsSize']; if (!isset($skuArr[0])) { $status = "空的SKU记录"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if (empty($skuArr[0]) && !empty($skuArr[1])) { $status = "只能是一个子料号情况下,SKU才能为空"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if (count($skuArr) != count(array_unique($skuArr))) { $status = "错误,存在重复的SKU"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } $userId = $_SESSION['userId']; if (intval($userId) <= 0) { $status = "登陆超时,请重新登陆!"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } for ($i = 0; $i < count($skuArr); $i++) { $sku = post_check($spu . trim($skuArr[$i])); if (strlen($sku) > 30) { $status = "{$sku} 字符长度大于30,错误!"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if (!preg_match("/^{$spu}(_[A-Z0-9]+)*\$/", $sku)) { $status = "{$sku} 格式非法"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } $goodsName = !empty($goodsNameArr[$i]) ? $goodsNameArr[$i] : ''; $goodsCost = !empty($goodsCostArr[$i]) ? $goodsCostArr[$i] : 0; $goodsNote = !empty($goodsNoteArr[$i]) ? $goodsNoteArr[$i] : ''; $goodsColor = !empty($goodsColorArr[$i]) ? $goodsColorArr[$i] : 0; $goodsSize = !empty($goodsSizeArr[$i]) ? $goodsSizeArr[$i] : 0; if ($i >= 1 && $sku == $spu) { continue; } if (empty($goodsName)) { $status = "{$sku} 的描述不能为空"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if (strpos($goodsName, '#') !== false || strpos($goodsNote, '#') !== false) { //如果描述中有#则报错 $status = "{$sku} 的描述/备注 不能含有'井'号等特殊字符"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } if (!is_numeric($goodsCost) || $goodsCost <= 0) { $status = "{$sku} 的成本必须为正数"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } $tName = 'pc_goods'; $where = "WHERE is_delete=0 AND sku='{$sku}'"; $count = OmAvailableModel::getTNameCount($tName, $where); if ($count) { $status = "{$sku} 已经存在"; echo '<script language="javascript"> alert("' . $status . '"); </script>'; exit; } } try { $ebayGoodsArr = array(); //同步数据数组 BaseModel::begin(); for ($i = 0; $i < count($skuArr); $i++) { $sku = post_check($spu . trim($skuArr[$i])); $goodsName = !empty($goodsNameArr[$i]) ? $goodsNameArr[$i] : ''; $goodsCost = !empty($goodsCostArr[$i]) ? $goodsCostArr[$i] : 0; $goodsNote = !empty($goodsNoteArr[$i]) ? $goodsNoteArr[$i] : ''; $goodsColor = !empty($goodsColorArr[$i]) ? $goodsColorArr[$i] : 0; $goodsSize = !empty($goodsSizeArr[$i]) ? $goodsSizeArr[$i] : 0; if ($i >= 1 && $sku == $spu) { continue; } $dataSku = array(); $dataSku['spu'] = $spu; $dataSku['goodsCategory'] = $pid; $dataSku['purchaseId'] = $userId; $dataSku['goodsCreatedTime'] = time(); $dataSku['goodsSort'] = intval(substr($spu, 2)); $dataSku['sku'] = $sku; $dataSku['goodsName'] = $goodsName; $dataSku['goodsCost'] = $goodsCost; $dataSku['goodsNote'] = $goodsNote; $dataSku['goodsStatus'] = $goodsStatus; $dataSku['isNew'] = $isNew; $dataSku['goodsColor'] = $goodsColor; $dataSku['goodsSize'] = $goodsSize; $tName = 'pc_goods'; $insertId = OmAvailableModel::addTNameRow2arr($tName, $dataSku); addWeightBackupsModify($sku, 0, $userId, false); //添加默认的重量变化记录 addVolumeBackupsModify($sku, 0, 0, 0, $userId, false); //添加默认的体积变化记录 addPmBackupsModify($sku, 0, 1, $userId, false); //添加默认的包材变化记录 addCostBackupsModify($sku, $goodsCost, $userId, false); //添加默认的成本变化记录 addStatusBackupsModify($sku, $goodsStatus, '', $userId, false); //添加默认的状态变化记录 //将新添加的sku添加到mem中 $key = 'pc_goods_' . $sku; $value = $dataSku; setMemNewByKey($key, $value); //这里不保证能添加成功 //同步新数据到旧系统中 $ebayGoods = array(); $ebayGoods['goods_id'] = $insertId; $ebayGoods['goods_name'] = preg_replace("/(\\s|\\ \\;| | )/", "", $goodsName); $ebayGoods['goods_sn'] = $sku; $ebayGoods['goods_price'] = $goodsCost; $ebayGoods['goods_cost'] = $goodsCost; //$ebayGoods['goods_weight'] = $goodsWeight; $ebayGoods['goods_note'] = preg_replace("/(\\s|\\ \\;| | )/", "", $goodsNote); $ebayGoods['goods_category'] = $pid; //$ebayGoods['isPacking'] = $isPacking; $ebayGoods['ebay_user'] = '******'; //$ebayGoods['factory'] = $partnerId; $ebayGoods['cguser'] = empty($_SESSION['userId']) ? '' : getPersonNameById($_SESSION['userId']); //$ebayGoods['capacity'] = $pmCapacity; //$ebayGoods['ebay_packingmaterial'] = empty($pmId)?'':PackingMaterialsModel::getPmNameById($pmId); $ebayGoods['add_time'] = time(); $ebayGoods['spu'] = $spu; $ebayGoods['goods_code'] = $insertId + 1000000; $ebayGoods['color'] = $goodsColor; $ebayGoods['size'] = $goodsSize; if ($goodsStatus == 1) { //在线 $ebayGoods['isuse'] = 0; } elseif ($goodsStatus == 51) { //PK产品 $ebayGoods['isuse'] = 51; } else { //其余的都做下线处理 $ebayGoods['isuse'] = 1; } $ebayGoodsArr[] = $ebayGoods; } BaseModel::commit(); BaseModel::autoCommit(); //同步数据到深圳ERP foreach ($ebayGoodsArr as $value) { $res = OmAvailableModel::newData2ErpInterfOpen('pc.erp.addGoods', $value, 'gw88'); } $status = "添加成功"; echo '<script language="javascript"> alert("' . $status . '"); window.parent.location.href = "index.php?mod=goods&act=getGoodsList&searchs=1&status=' . $status . '&seachdata=' . $spu . '"; </script>'; exit; } catch (Exception $e) { BaseModel::rollback(); BaseModel::autoCommit(); $status = $e->getMessage(); echo '<script language="javascript"> alert("' . '添加失败——' . $status . '"); window.parent.location.href = "index.php?mod=goods&act=getGoodsList&searchs=1&status=' . $status . '&seachdata=' . $spu . '"; </script>'; exit; } }