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; }