-
//bootsize();
$prods_in_row = 6;
$prods_in_row2 = $prods_in_row*2;
$col_md = 2;
// Hot Deal Products
$i = 0;
$query= "SELECT P.id as prod_id, P.product, H.photo, P.comp_id, P.hotdeal_img,
P.fob_currency, P.fob_min, P.date_posted, P.is_newarrival, P.product_url
FROM products P
JOIN product_photo H ON H.prod_id=P.id and H.is_main=1 AND H.photo_video='p'
WHERE P.purpose=1 AND P.is_hotdeal=1 AND P.status=1 AND P.comp_id NOT IN (1, 2)
ORDER BY P.id DESC
LIMIT $prods_in_row";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
$i++;
$prod_id = $row["prod_id"];
$product = $row["product"];
$photo = $row["photo"];
$comp_id = $row["comp_id"];
$hotdeal_img = $row["hotdeal_img"];
$fob_currency = $row["fob_currency"];
$fob_min = $row["fob_min"];
$date_posted = $row["date_posted"];
$is_new = $row["is_newarrival"];
$product_url = $row["product_url"];
$cast_price = cast_price($fob_min, $fob_currency);
show_items($is_new, $prod_id, $comp_id, $photo, $product, $product_url, $cast_price, $col_md);
//if (strtotime(date("Y-m-d H:i:s")) - strtotime($date_posted) <= 60*60*24*14) // 14 weeks
}
?>
-
// Spotlight Products
$i = 0;
$query= "SELECT P.id as prod_id, P.product, H.photo, P.comp_id, P.spotlight_img, P.fob_currency, P.fob_min, P.spot_row,
P.date_posted, P.is_newarrival, P.product_url
FROM products P
JOIN product_photo H ON H.prod_id=P.id and H.is_main=1 AND H.photo_video='p'
WHERE P.purpose=1 AND P.is_spotlight=1 AND P.status=1 AND P.comp_id NOT IN (1, 2)
ORDER BY P.id DESC
LIMIT $prods_in_row2";
$result = mysql_query($query);
$cn_spots = mysql_num_rows($query);
while($row = mysql_fetch_array($result)){
$i++;
$prod_id = $row["prod_id"];
$product = $row["product"];
$photo = $row["photo"];
$comp_id = $row["comp_id"];
$spotlight_img = $row["spotlight_img"];
$fob_currency = $row["fob_currency"];
$fob_min = $row["fob_min"];
$spot_row = $row["spot_row"];
$date_posted = $row["date_posted"];
$is_new = $row["is_newarrival"];
$product_url = $row["product_url"];
$cast_price = cast_price($fob_min, $fob_currency);
show_items($is_new, $prod_id, $comp_id, $photo, $product, $product_url, $cast_price, $col_md);
}
?>
-
// Top Selling Products
$i = 0;
$query= "SELECT P.id as prod_id, P.product, H.photo, P.comp_id, P.hotdeal_img, P.fob_currency,
P.fob_min, P.date_posted, P.is_newarrival, P.product_url
FROM products P
JOIN sourcing_cart_products S ON S.prod_id=P.id
JOIN product_photo H ON H.prod_id=P.id and H.is_main=1 AND H.photo_video='p'
WHERE P.purpose=1 AND P.status=1 AND P.comp_id NOT IN (1, 2)
GROUP BY S.prod_id
ORDER BY COUNT(S.prod_id) DESC
LIMIT $prods_in_row";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
$i++;
$prod_id = $row["prod_id"];
$product = $row["product"];
$photo = $row["photo"];
$comp_id = $row["comp_id"];
$hotdeal_img = $row["hotdeal_img"];
$fob_currency = $row["fob_currency"];
$fob_min = $row["fob_min"];
$date_posted = $row["date_posted"];
$is_new = $row["is_newarrival"];
$product_url = $row["product_url"];
$cast_price = cast_price($fob_min, $fob_currency);
show_items($is_new, $prod_id, $comp_id, $photo, $product, $product_url, $cast_price, $col_md);
}
?>