query($parent_cat_query); $parent_cat = $parent_cat_result->fetch(); $show = addslashes($_GET["show"]); $cats_array = array(); $cat_array = array(); $mfg_array = array(); $cat_query = "SELECT * FROM `cat`"; if(Str::has_value($this_subcat_id)) { $cat_query .= " WHERE cat_id = '$this_subcat_id'"; } else { $cat_query .= " WHERE cat_name = '$this_subcat_name'"; } // end if $cat_query .= " LIMIT 1;"; $cat_result = $db->query($cat_query); $cat = $cat_result->fetch(); // Product query if($this_mfg_id) { $add_to_query = "AND mfg.mfg_id='" . $this_mfg_id ."'"; } if($this_subcat_id) { $search_id = $this_subcat_id; } else { $search_id = $this_parent_cat_id; } // pagination code $initial_prod_query = "SELECT 1 FROM `prod` LEFT JOIN prod_cat ON prod_cat.prod_id=prod.prod_id LEFT JOIN mfg ON prod.mfg_id = mfg.mfg_id WHERE cat_id='$search_id' $add_to_query AND prod_active = 1;"; $initial_prod_result = $db->query($initial_prod_query); $initial_prod_count = $initial_prod_result->count(); $prod_limit = 15; $total_pages = ceil($initial_prod_count / $prod_limit); $page=1; if (isset($_GET['page'])) { $page = $_GET['page']; } $start_from = ($page - 1) * $prod_limit; if($this_mfg_id) { $add_to_query = "AND mfg.mfg_id='$this_mfg_id'"; } if($start_from < 0) {$start_from = 0;} $initial_subcat_id = $this_subcat_id; // determine if a subcat was sent in the URL // end pagination code $prod_query = "SELECT prod_name, prod_url, prod.prod_id, prod.prod_new, mfg_name, prod.mfg_id, cat_id, prod_new_end, (SELECT prod_img_name FROM prod_img WHERE prod_img.prod_id = prod.prod_id ORDER BY prod_img.prod_img_index LIMIT 1) AS img FROM `prod` LEFT JOIN prod_cat ON prod_cat.prod_id=prod.prod_id LEFT JOIN mfg ON prod.mfg_id = mfg.mfg_id WHERE cat_id='$search_id' $add_to_query AND prod_active = 1 ORDER BY mfg_name, prod_name LIMIT $start_from, $prod_limit;"; $prod_result = $db->query($prod_query); //pagination $mfg_query = "SELECT mfg.mfg_name, mfg.mfg_id from prod LEFT JOIN prod_cat ON prod.prod_id = prod_cat.prod_id Left JOIN mfg ON mfg.mfg_id = prod.mfg_id WHERE `cat_id` LIKE '$this_parent_cat_id' and prod.prod_active = 1 GROUP BY mfg.mfg_id;"; $mfg_result = $db->query($mfg_query); while($mfg_row = $mfg_result->fetch()) { if($mfg_row->mfg_name) { $mfg_array[$mfg_row->mfg_id] = $mfg_row->mfg_name; } } // echo queries // echo "initial " . $initial_prod_query ."
"; // echo "prod " . $prod_query ."
"; // // build mfg array // echo "mfg " . $mfg_query ."
"; // echo "mfg count: " . $mfg_result->count(); // print_r($mfg_array); // if($cat_result->count() == 0) { // redirect("index.htm"); // } // end if include("head.inc"); include("side_menu.inc"); include("menu_bar.inc"); include("breadcrumbs.inc"); ?>
bof(); while($prod_row = $prod_result->fetch()) { $this_prod_id = addslashes($prod_row->prod_id); // get prod id // get pricing? $item_query = "SELECT * FROM `prod_item` WHERE prod_id = '$this_prod_id' ORDER BY `prod_item_price`"; $item_result = $db->query($item_query); $item_count = $item_result->count(); $item = $item_result->fetch(); $price_unformatted = $item->prod_item_price; $price_msrp = $item->prod_item_msrp; $price = Str::format_currency($item->prod_item_price); if($item_count == 0) { $display_price = "Call For Pricing"; } elseif($item_count > 1) { $price_query = "SELECT `prod_item_price` FROM `prod_item` WHERE prod_id = '$this_prod_id' AND prod_item_price_display = 1"; $price_display_result = $db->query($price_query); if($price_display_result->count() > 0) { $price_display = $db->query($price_query)->fetch(); $price = Str::format_currency($price_display->prod_item_price); } $display_price = "Starting at " . $price; } else { $display_price = $price; } // print_r($item); unset($active_promo); if($item->prod_item_promo_start) { // there is a possible promo if((date('Y-m-d') >= $item->prod_item_promo_start) && (date('Y-m-d') <= $item->prod_item_promo_end)) { $active_promo = $item->prod_item_promo_title; $display_price = "Promotional Pricing!
Was ". Str::format_currency($item->prod_item_price) . " - Now only " . Str::format_currency($item->prod_item_promo_price); // $sale_start = date('m d, Y', $item->prod_item_promo_start); } } ?>
prod_new == 1) && (date('Y-m-d') < $prod_row->prod_new_end || $prod_row->prod_new_end == "")) { ?>
query($query)->fetch()->cat_id; } ?> img) { ?>
mfg_name ?> prod_name ?>