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