public function view_skuInfo() { $sku = isset($_GET['sku']) ? trim($_GET['sku']) : ""; //$spu = ExportsToXlsModel::getGoods($sku); $spu = GoodsModel::getSkuList($sku); $spu = $spu['spu']; $where = "where spu = '{$spu}'"; $skuinfo = OmAvailableModel::getTNameList("pc_goods", "*", $where); $skuStock = array(); foreach ($skuinfo as $key => $value) { $sku = $value['sku']; //获取库存 $skuStock = WarehouseAPIModel::getSkuStock($sku); //获取料号信息 //$skumsg = ExportsToXlsModel::getGoods($sku); $skumsg = GoodsModel::getSkuList($sku); //获取缓存表信息 $where = "where sku='{$sku}'"; $skuStatics = OmAvailableModel::getTNameList("om_sku_daily_status", "*", $where); $skuStockList = array(); $skuStockList['nums'] = $skuStock; $skuStockList['sku'] = $skumsg['sku']; $skuStockList['spu'] = $skumsg['spu']; $skuStockList['goodsName'] = $skumsg['goodsName']; $skuStockList['goodsCost'] = $skumsg['goodsCost']; $skuStockList['goodsWeight'] = $skumsg['goodsWeight']; $skuStockList['AverageDailyCount'] = $skuStatics['AverageDailyCount']; $skuStockList['waitingSendCount'] = $skuStatics['waitingSendCount']; $skuStockList['xuniCount'] = $skuStatics['waitingSendCount']; $skuStockList['goodsStatus'] = $skumsg['goodsStatus']; $path = $skumsg['goodsCategory']; $cateName = GoodsModel::getCategoryInfoByPath($path); $skuStockList['cateName'] = $cateName['name']; $skuStockList['isNew'] = $skumsg['isNew']; $skuStockList['pmId'] = $skumsg['pmId']; $pmName = GoodsModel::getMaterInfoById($skumsg['pmId']); $skuStockList['pmName'] = $pmName['pmName']; //print_r($pmName); $pName = $skumsg['purchaseId']; $skuStockList['pName'] = UserModel::getUsernameById($pName); $skuStockList['isPacking'] = $skumsg['isPacking']; $skuStockList['whName'] = "深圳A仓"; $skuStock_arr[] = $skuStockList; } $this->smarty->assign("skuStockList", $skuStock_arr); //print_r($skuStockList); $this->smarty->display("skuInfo.htm"); }
public static function calcOnlySkuWeight($sku, $amount) { global $memc_obj; //调用memcache对象 //var_dump($obj_order_detail_data); exit; $skuWeight = 0; //初始化要返回的仅仅SKU重量 $pweight = 0; //初始化包材重量 //var_dump($obj_order_detail_data); exit; //foreach($obj_order_detail_data as $detailValue){ //$sku = $detailValue['orderDetailData']['sku']; //$amount = $detailValue['orderDetailData']['amount']; $skuinfo = GoodsModel::getCombineSkuinfo($sku); //var_dump($skuinfo); if ($skuinfo) { //组合料号 $skuinfoDetail = $skuinfo['detail']; if (count($skuinfoDetail) == 1) { $ssku = $skuinfoDetail[0]['sku']; $scount = $skuinfoDetail[0]['count']; $goodsinfo = GoodsModel::getSkuinfo($ssku); //获取单料号信息 if ($goodsinfo) { $pmId = $goodsinfo['pmId']; $goodsWeight = $goodsinfo['goodsWeight']; $pmCapacity = $goodsinfo['pmCapacity']; } $pmInfo = GoodsModel::getMaterInfoById($pmId); //获取包材信息 if ($pmInfo) { $pweight = $pmInfo['pmWeight']; } if ($scount <= $pmCapacity) { $skuWeight += $pweight + $goodsWeight * $scount; } else { $skuWeight += (1 + ($scount - $pmCapacity) / $pmCapacity * 0.6) * $pweight + $goodsWeight * $scount; } } else { if (count($skuinfoDetail) > 1) { foreach ($skuinfoDetail as $skuinfoDetailValue) { $ssku = $skuinfoDetailValue['sku']; $scount = $skuinfoDetailValue['count']; $goodsinfo = GoodsModel::getSkuinfo($ssku); //获取单料号信息 if ($goodsinfo) { $pmId = $goodsinfo['pmId']; $goodsWeight = $goodsinfo['goodsWeight']; $pmCapacity = $goodsinfo['pmCapacity']; } $pmInfo = GoodsModel::getMaterInfoById($pmId); //获取包材信息 if ($pmInfo) { $pweight = $pmInfo['pmWeight']; } $skuWeight += $scount / $pmCapacity * 0.6 * $pweight + $goodsWeight * $scount; } } } } else { //单料号 $goodsinfo = GoodsModel::getSkuinfo($sku); //获取单料号信息 //var_dump($goodsinfo); if ($goodsinfo) { $pmId = $goodsinfo['pmId']; $goodsWeight = $goodsinfo['goodsWeight']; $pmCapacity = $goodsinfo['pmCapacity']; } //var_dump($pmId); $pmInfo = GoodsModel::getMaterInfoById($pmId); //获取包材信息 if ($pmInfo) { $pweight = $pmInfo['pmWeight']; } if ($amount <= $pmCapacity) { $skuWeight += $pweight + $goodsWeight * $amount; } else { $skuWeight += (1 + ($amount - $pmCapacity) / $pmCapacity * 0.6) * $pweight + $goodsWeight * $amount; } } //} return array($skuWeight, $pmId); }