$sql = " SELECT a.* FROM {$ordertable} AS a, {$orderproducttable} AS b WHERE RIGHT(a.order_code,2)='BH' AND a.order_code=b.order_code AND a.user_code='{$user_code}' ORDER BY a.id DESC";
$order = Paging::bySQL($sql, $page, $page_size, 'a');
} else {
//DB::Debug();
$ordertable = Orders::table();
$orderproducttable = OrdersProducts::table();
$sql = " SELECT a.* FROM {$ordertable} AS a, {$orderproducttable} AS b WHERE (RIGHT(a.order_code,2)='SK' OR LEFT(a.order_code,4)='FXAD') AND a.order_code=b.order_code AND a.user_code='{$user_code}' AND (a.order_code LIKE '%{$keyword}%' OR b.product_sku LIKE '%{$keyword}%') GROUP BY a.order_code ORDER BY a.id DESC";
$order = Paging::bySQL($sql, $page, $page_size, 'a');
}
}
}
$orders = $order['data'];
$paged = $order['page'];
foreach ($orders as $k => $order) {
$order_code = $order['order_code'];
$products = OrdersProducts::getUserProducts($order_code);
$tmp = array();
//获取各个PRODCUT STOCK
$len = count($products);
for ($i = 0; $i < $len; $i++) {
if (!isset($products[$i])) {
continue;
}
/*
//合并相同 ITEM 的SKU
for ($j=$i+1; $j<$len; $j++){
if(!isset($products[$j])) continue;
if($products[$i]['item']===$products[$j]['item']){
$products[$i]['outstock'][] = array('product_num'=>$products[$j]['product_num'],'exp_date'=>$products[$j]['exp_date']);
unset($products[$j]);
}
public static function getOrderPrducts($order_code)
{
if (!$order_code) {
return array();
}
//-- 处理重复ORDER SKU, 同一个SKU有不同批号时会出现重复
$tmp = array();
$products = OrdersProducts::getUserProducts($order_code);
for ($i = 0; $i < count($products); $i++) {
$products[$i]['outstock'][] = array('product_num' => $products[$i]['product_num'], 'exp_date' => $products[$i]['exp_date']);
for ($j = $i + 1; $j < count($products); $j++) {
if ($products[$i]['sku'] == $products[$j]['sku']) {
$products[$i]['outstock'][] = array('product_num' => $products[$j]['product_num'], 'exp_date' => $products[$j]['exp_date']);
$tmp[$j] = $j;
}
}
}
foreach ($tmp as $k => $v) {
if (isset($products[$k])) {
unset($products[$k]);
}
}
//-- END 处理重复ORDER SKU
ProductsSku::getProductsPic($products);
//var_dump($products);
return $products;
}
