function updateSkuInfo($data)
{
global $dbConn, $configArgument;
$setContent = array2sql($data);
$sql = "select count(*) as totalnum,purchasedays,safeStockDays,cycle_days from ow_stock where sku='{$data['sku']}'";
$sql = $dbConn->execute($sql);
$num = $dbConn->fetch_one($sql);
$comObj = new CommonAct();
$booknums = $comObj->getOrderSkuNum($data['sku']);
//已订购库存
if ($num['totalnum'] > 0) {
$alertdays = $configArgument['onseadays'] + max($configArgument['stockreaddays'], $configArgument['shipredaydays']) + $configArgument['reshelfdays'] + $num['safeStockDays'] + $num['cycle_days'];
//预警天数计算
if ($data['everyday_sale'] != 0) {
$days = ($data['virtual_stock'] + $data['onWayCount'] + $data['b_stock_cout'] + $booknums) / $data['everyday_sale'];
$out_alert_days = $data['virtual_stock'] / $data['everyday_sale'];
//可用天数
if ($days < $alertdays) {
$is_alert = 1;
} else {
$is_alert = 0;
}
if ($out_alert_days <= 5) {
$out_alert = 1;
//超卖控制
} else {
$out_alert = 0;
}
} else {
$is_alert = 0;
$out_alert = 0;
}
$sql = "update ow_stock set {$setContent}, is_alert='{$is_alert}',out_alert='{$out_alert}',booknums='{$booknums}' where sku='{$data['sku']}'";
} else {
$is_alert = 0;
$out_alert = 0;
$sql = "INSERT INTO `ow_stock`(`sku`,`everyday_sale`, `count`, `onWayCount`, `salensend`, `booknums`, `virtual_stock`, `b_stock_cout`,`is_alert`,out_alert) VALUES ('{$data['sku']}','{$data['everyday_sale']}','{$data['count']}','{$data['onWayCount']}','{$data['salensend']}','{$booknums}','{$data['virtual_stock']}','{$data['b_stock_cout']}','{$is_alert}','{$out_alert}')";
}
echo $sql . "\n";
if ($dbConn->execute($sql)) {
return 1;
} else {
echo $sql . "\n";
return 0;
}
}
function updateSkuInfo($data)
{
global $dbConn;
$comm = new CommonAct();
$bookNum = $comm->getOrderSkuNum($data['sku']);
$item = $data;
if (isset($item['everyday_sale'])) {
$alertNum = $item['stock_qty'] + $item['ow_stock'] + $bookNum - $item['salensend'] - $item['interceptnums'] - $item['autointerceptnums'] - $item['auditingnums'];
$outalertNum = $item['stock_qty'] + $item['ow_stock'] - $item['salensend'] - $item['autointerceptnums'];
if ($item['everyday_sale'] != 0) {
$canUseDay = $alertNum / $item['everyday_sale'];
if ($canUseDay < $item['alertDays']) {
$isAlert = 1;
} else {
$isAlert = 0;
}
$outuseDay = $outalertNum / $item['everyday_sale'];
if (isset($item['stockoutDays']) && $item['stockoutDays'] != 0) {
$stockoutDays = $item['stockoutDays'];
} else {
$stockoutDays = 10;
}
if ($outuseDay < $stockoutDays) {
$outAlert = 1;
} else {
$outAlert = 0;
}
} else {
$outAlert = 0;
$isAlert = 0;
}
$data['is_alert'] = $isAlert;
$data['out_alert'] = $outAlert;
$data['newBookNum'] = $bookNum;
} else {
$sql = "select * from ph_sku_statistics where sku='{$data['sku']}'";
$sql = $dbConn->execute($sql);
$skuitem = $dbConn->fetch_one($sql);
$alertNum = $item['stock_qty'] + $item['ow_stock'] + $bookNum - $skuitem['salensend'] - $skuitem['interceptnums'] - $skuitem['autointerceptnums'] - $skuitem['auditingnums'];
$outalertNum = $item['stock_qty'] + $item['ow_stock'] - $item['salensend'] - $item['autointerceptnums'];
if ($skuitem['everyday_sale'] != 0) {
$canUseDay = $alertNum / $skuitem['everyday_sale'];
if ($canUseDay < $skuitem['alertDays']) {
$isAlert = 1;
} else {
$isAlert = 0;
}
$outuseDay = $outalertNum / $skuitem['everyday_sale'];
if (isset($skuitem['stockoutDays']) && $skuitem['stockoutDays'] != 0) {
$stockoutDays = $item['stockoutDays'];
} else {
$stockoutDays = 10;
}
echo "可用天数" . $outuseDay . "超卖预警控制天数" . $stockoutDays . "\n";
if ($outuseDay < $stockoutDays) {
$outAlert = 1;
} else {
$outAlert = 0;
}
} else {
$isAlert = 0;
$outAlert = 0;
}
$data['is_alert'] = $isAlert;
$data['out_alert'] = $outAlert;
$data['newBookNum'] = $bookNum;
}
$setContent = array2sql($data);
$sql = "select count(*) as totalnum from ph_sku_statistics where sku='{$data['sku']}'";
$sql = $dbConn->execute($sql);
$num = $dbConn->fetch_one($sql);
if ($num['totalnum'] > 0) {
$sql = "update ph_sku_statistics set {$setContent} where sku='{$data['sku']}'";
} else {
$sql = "insert into ph_sku_statistics set {$setContent} ";
}
echo $sql . "\n";
if ($dbConn->execute($sql)) {
//$comm->calcAlert($data['sku'],"auto"); //自动更新判断预警
return 1;
} else {
return 0;
}
//echo $sql;
}
