$updateSkuArr = array(); if (isset($argv[2])) { // 更新单个采购的料号 $sql = "select a.sku from pc_goods as a left join power_global_user as b on a.purchaseId=b.global_user_id where b.global_user_name='{$argv[2]}' "; echo $sql; $sql = $dbConn->execute($sql); $skuArr = $dbConn->getResultArray($sql); foreach ($skuArr as $item) { $updateSkuArr[] = $item['sku']; } } //$updateSkuArr = array("1724"); foreach ($updateSkuArr as $sku) { //$product->resetSkuStock($sku,1); //$product->calcAverageDailyCount($item['sku']); $product->resetSkuAverage($sku); } if (isset($argv[2])) { $sku = $argv[2]; $product->resetSkuStock($sku, 1); $product->calcAverageDailyCount($item['sku']); } else { $sql = "SELECT sku,spu FROM `pc_goods` where 1"; $sql = $dbConn->execute($sql); $skuInfo = $dbConn->getResultArray($sql); if ($argv[1] == "resetSkuAverage") { foreach ($skuInfo as $item) { $sku = $item['sku']; $product->resetSkuAverage($item['sku']); } } else {
if (isset($argv[2])) { // 更新单个采购的料号 //$sql = "select a.sku from pc_goods as a left join power_global_user as b on a.purchaseId=b.global_user_id where b.global_user_name='{$argv[2]}' "; echo $sql; //$sql = "select sku from pc_goods "; $sql = $dbConn->execute($sql); $skuArr = $dbConn->getResultArray($sql); foreach ($skuArr as $item) { $updateSkuArr[] = $item['sku']; } } //$updateSkuArr = array("1724"); foreach ($updateSkuArr as $sku) { $product->resetSkuStock($sku, 1); //$product->calcAverageDailyCount($item['sku']); $product->resetSkuAverage($sku); } /* if(isset($argv[2])){ $sku = $argv[2]; $product->resetSkuStock($sku,1); $product->calcAverageDailyCount($item['sku']); }else{ $sql = "SELECT sku,spu FROM `pc_goods` where 1"; $sql = $dbConn->execute($sql); $skuInfo = $dbConn->getResultArray($sql); if($argv[1] == "resetSkuAverage"){ foreach($skuInfo as $item){ $sku = $item['sku']; $product->resetSkuAverage($item['sku']);