public static function getLists($user_id, $page, $page_size)
{
$user_id = (int) $user_id;
if (!$user_id) {
return array();
}
$table = self::table();
$sku_table = ProductsSku::table();
$item_table = ProductsItem::table();
$sql = " SELECT a.id, b.id AS skuid, c.title, b.sku, b.sku_name, b.current_price FROM {$table} AS a, {$sku_table} AS b, {$item_table} AS c WHERE b.item=c.item AND a.sku_id=b.id AND a.user_id='{$user_id}' ORDER BY a.id DESC";
$lists = Paging::bySQL($sql, $page, $page_size, 'a');
ProductsSku::getProductsPic($lists['data']);
return $lists;
}
if (!$item) {
header("Location: /html/404.html?005");
exit;
}
$sku['iteminfo'] = $item;
$sku_code = $sku['sku'];
$pics = ProductsPic::getSkuPics($sku_code, 'path', 'sort DESC LIMIT 0,3');
$sku['pics'] = $pics;
$sku['order_num'] = OrdersProducts::getSkuAllNum($sku_code);
$sku['stock'] = ProductsStock::getSkuStock($sku_code);
$skus = ProductsSku::getItemSkus($item_code, "id,sku,sku_name");
$skus = ProductsSku::getProductsPic($skus);
$sku['skus'] = $skus;
$userid = isset($_SESSION['userid']) ? (int) $_SESSION['userid'] : 0;
$history = array();
if ($userid) {
$history = UsersHistory::getProductViewLog($userid, $id);
}
if (!$history) {
$history = ProductsSku::getRand($item_code);
}
$history = ProductsSku::getProductsPic($history);
$history = ProductsSku::getProductsItemTitle($history);
ProductsSku::increase("id={$id}", 'view_num');
$log = array('op' => 'view', 'id' => $id, 'url' => Func::getCurrentURL());
$log = json_encode($log);
UsersHistory::addLog($userid, ProductsSku::$module_id, $log);
Templates::Assign('history', $history);
Templates::Assign('sku', $sku);
Templates::Display('product.html');
}
*/
for ($j = $i + 1; $j < $len; $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;
}
}
$products[$i]['outstock'][] = array('product_num' => $products[$i]['product_num'], 'exp_date' => $products[$i]['exp_date']);
unset($products[$i]['product_num'], $products[$i]['exp_date']);
}
foreach ($tmp as $pk => $v) {
if (isset($products[$pk])) {
unset($products[$pk]);
}
}
ProductsSku::getProductsPic($products);
$orders[$k]['products'] = $products;
$status_name = OrdersStatus::getName($order['order_status']);
$orders[$k]['status_name'] = $status_name;
}
if ((int) $stardate > 0 && (int) $enddate > 0) {
$stardate = date('Y-m-d', $stardate);
$enddate = date('Y-m-d', $enddate);
}
Templates::Assign('stardate', $stardate);
Templates::Assign('enddate', $enddate);
Templates::Assign('keyword', $keyword);
Templates::Assign('paged', $paged);
Templates::Assign('orders', $orders);
Templates::Assign('ordercount', Orders::getUserOrderNum($user_code));
Templates::Assign('status', $status);
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;
}
