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