';
$htmlTitle = "| {$sku_lang} | ";
$htmlTitle .= "{$productTitle_lang} | ";
$htmlTitle .= "{$onway_lang} | ";
$htmlTitle .= "{$Pending_lang} | ";
$htmlTitle .= "{$Available_lang} | ";
$htmlTitle .= "{$Unavailable_lang} | ";
$htmlTitle .= "{$shipment_occupation_lang} | ";
$htmlTitle .= "{$Shipped_lang} | ";
$htmlTitle .= "{$pqoUpdateTime_lang} | ";
$htmlTitle .= '
';
$titlesku = '';
$orderContent = '';
$max = 1;
foreach($inventoryArr as $key=>$inventory_id){
$inventory_info = Service_ProductInventory::getByField($inventory_id,'pi_id');
if(empty($inventory_info)){ continue;}
//print_r($orderInfo);
$orderContent.="";
if($inventory_info['product_id']){
$product_array = Service_Product::getByField($inventory_info['product_id'],'product_id');
$inventory_info['product_sku'] = $product_array['product_sku'];
$inventory_info['product_title'] = $product_array['product_title'];
}
//产品SKU
$orderContent.="| {$inventory_info['product_sku']} | ";
//产品名称
$orderContent.="{$product_array['product_title']} | ";
//在途
$orderContent.="{$inventory_info['pi_onway']} | ";
//已收货
$orderContent.="{$inventory_info['pi_pending']} | ";
//可用
$orderContent.="{$inventory_info['pi_sellable']} | ";
//问题库存
$orderContent.="{$inventory_info['pi_unsellable']} | ";
//冻结
$orderContent.="{$inventory_info['pi_reserved']} | ";
//已出货
$orderContent.="{$inventory_info['pi_shipped']} | ";
//更新时间
$orderContent.="{$inventory_info['pi_update_time']} | ";
$orderContent.="
";
}
echo $orderHtml.$htmlTitle.$orderContent.'
';
exit;
}elseif($exportformat=='csv'){
}
}else{
//获取全部情况
$condition = array();
/* 以下为提交数据整理 */
$product_sku_s = $this->_request->getParam("product_sku_s","");
$warehouse_id_s = $this->_request->getParam("warehouse_id_s","");
$product_title = $this->_request->getParam("product_title","");
$product_id_array = array();
if($product_sku_s){
$product_array = Service_Product::getByCondition(array('comefrom'=>1,'product_sku'=>$product_sku_s));
if($product_array){
foreach($product_array as $row){
$product_id_array[] = $row['product_id'];
}
}
}//if($product_sku_s){
$customer = $this->_customerAuth;
$customerId = $customer['id'];
$condition = array(
'product_id_array'=>$product_id_array,
'warehouse_id'=>$warehouse_id_s,
'customer_id'=> $customerId,
'product_title'=>$product_title
);
$count = Service_ProductInventory::getJoinProductByCondition($condition,"count(*)");
if($count>0){
$pageSize = 20;
$pages = ceil($count/20);
$orderHtml = '';
$htmlTitle = "| {$sku_lang} | ";
$htmlTitle .= "{$productTitle_lang} | ";
$htmlTitle .= "{$onway_lang} | ";
$htmlTitle .= "{$Pending_lang} | ";
$htmlTitle .= "{$Available_lang} | ";
$htmlTitle .= "{$Unavailable_lang} | ";
$htmlTitle .= "{$shipment_occupation_lang} | ";
$htmlTitle .= "{$Shipped_lang} | ";
$htmlTitle .= "{$pqoUpdateTime_lang} | ";
$htmlTitle .= '
';
$titlesku = '';
$orderContent = '';
$max = 1;
for($page=1;$page<=$pages;$page++){
$rows = Service_ProductInventory::getJoinProductByCondition($condition, '*', $pageSize,$page,'pi_id desc');
foreach($rows as $keyo=>$inventory_info){
if(empty($inventory_info)){ continue;}
if($inventory_info['product_id']){
$product_array = Service_Product::getByField($inventory_info['product_id'],'product_id');
$inventory_info['product_sku'] = $product_array['product_sku'];
$inventory_info['product_title'] = $product_array['product_title'];
}
//产品SKU
$orderContent.="{$inventory_info['product_sku']} | ";
//产品名称
$orderContent.="{$product_array['product_title']} | ";
//在途
$orderContent.="{$inventory_info['pi_onway']} | ";
//已收货
$orderContent.="{$inventory_info['pi_pending']} | ";
//可用
$orderContent.="{$inventory_info['pi_sellable']} | ";
//问题库存
$orderContent.="{$inventory_info['pi_unsellable']} | ";
//冻结
$orderContent.="{$inventory_info['pi_reserved']} | ";
//已出货
$orderContent.="{$inventory_info['pi_shipped']} | ";
//更新时间
$orderContent.="{$inventory_info['pi_update_time']} | ";
$orderContent.="";
}
}
echo $orderHtml.$htmlTitle.$orderContent.'
';
}
}
exit;
}
}