/**
* ProductStockalarmAct::act_updateWarnOld()
* 更新选择料号的预警信息
* @param array skuArr 料号数组
* @return bool
*/
public function act_updateWarnOld()
{
$skuArr = isset($_POST['skuList']) ? $_POST['skuList'] : "";
$gid = isset($_SESSION[C('USER_AUTH_SYS_ID')]) ? $_SESSION[C('USER_AUTH_SYS_ID')] : 0;
if (empty($skuArr) || !is_array($skuArr)) {
self::$errCode = 10000;
self::$errMsg = "料号参数非法！";
return false;
}
if (!count($skuArr)) {
self::$errCode = 10001;
self::$errMsg = "料号不能为空数组！";
return false;
}
if (empty($gid)) {
self::$errCode = 10002;
self::$errMsg = "您无权更新缓存！";
return false;
}
$res = ProductStockalarmModel::updateWarn($gid, $skuArr);
self::$errCode = ProductStockalarmModel::$errCode;
self::$errMsg = ProductStockalarmModel::$errMsg;
return $res;
}
/**
* ProductStockalarmModel::updateWarnInfo()
* 更新选择料号的预警信息
* @param array $dataarray 预警信息
* @param string $sku 料号
* @return bool
*/
public static function updateWarnInfo($sku, $dataarray)
{
self::initDB();
$res = self::isWarnInfo($sku);
if ($res) {
$sql = array2sql($dataarray);
$sql = "UPDATE `" . self::$prefix . self::$tab_skuInfo . "` SET " . $sql . " WHERE sku = '{$sku}'";
} else {
$dataarray['sku'] = $sku;
$sql = array2sql($dataarray);
$sql = "INSERT INTO `" . self::$prefix . self::$tab_skuInfo . "` SET " . $sql;
}
$query = self::$dbConn->query($sql);
if ($query) {
return true;
} else {
self::$errCode = 20000;
self::$errMsg = "执行SQL语句出错";
return false;
}
}