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($start_from < 0) { $start_from = 0;} $prod_query = "SELECT prod_name, prod_url, prod.prod_id, prod.prod_new, mfg_name, prod.mfg_id, cat_id, (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 prod.`mfg_id` LIKE '$this_mfg_id' AND `prod_active` = 1 GROUP BY prod.prod_id ORDER BY mfg_name, prod_name LIMIT $start_from, $prod_limit;"; $prod_result = $db->query($prod_query); // echo "initial " . $initial_prod_query ."
"; // echo "prod " . $prod_query ."
"; include("head.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 `prod_item_price`, `prod_item_price_display`, `prod_item_msrp` FROM `prod_item` WHERE prod_id = '$prod_row->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) { $display_price = "Starting at " . $price; } else { $display_price = $price; } ?>

prod_new == 1) { ?>

query($query)->fetch()->cat_id; } ?> img) { ?>

mfg_name ?> prod_name ?>

' . Str::format_currency($price_msrp) . ''; } echo '

' . $display_price . '

'; if($price_msrp) { echo ''; } ?>

"; include("foot.inc"); exit; ?> query($wishlist_query); while($row = $wishlist_result->fetch()) { $wishlist_prod_ids[] = $row->prod_id; } // end while // // get the initial list of products in parent catergory // // if Rick wants to see only one mfg, added this on next line. Add mfg_id to URL if($this_mfg_id) { $add_to_query = "AND mfg.mfg_id='$this_mfg_id'"; } $prod_query = "SELECT prod_name, prod_url, prod.prod_id, mfg_name, prod.mfg_id, cat_id, (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='$this_subcat_id' $add_to_query AND prod_active = 1 ORDER BY mfg_name, prod_index, prod_name"; $prod_result = $db->query($prod_query); while($prod_row = $prod_result->fetch()) { // save this to make pretty urls if(Str::has_value($prod_row->prod_url)) { $prod_link = "/products/{$prod_row->prod_url}?d={$this_dept_id}&pc={$this_parent_cat_id}&sc={$this_subcat_id}&p_id=" . $prod_row->prod_id; } else { $prod_link = "/prod_detail.htm?d={$this_dept_id}&pc={$this_parent_cat_id}&sc={$this_subcat_id}&p_id=" . $prod_row->prod_id; } // end if $cat_query = "SELECT cat_id FROM prod_cat WHERE prod_id = '$prod_row->prod_id'"; $cat_result = $db->query($cat_query); // // find out if product can be sold and display correct icon // $this_prod_id = addslashes($prod_row->prod_id); $item_query = "SELECT `prod_item_price` 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 = Str::format_currency($item->prod_item_price); $shop_line = << In Store Only ENDSHOPLINE; if($item_count > 1) { // check for any items where the prod item is the default display price $item_query = "SELECT `prod_item_price` FROM `prod_item` WHERE prod_id = '$this_prod_id' AND prod_item_price_display = 1"; $item_display_result = $db->query($item_query); if($item_display_result->count() > 0) { $item_display = $item_display_result->fetch(); $price = Str::format_currency($item_display->prod_item_price); } // end if $shop_line = << Starting at {$price} ENDITEM; } // end if if($item_count == 1) { $shop_line = << Available for {$price} ENDITEM; } // end if if(is_array($wishlist_prod_ids) && in_array($prod_row->prod_id, $wishlist_prod_ids)) { $wishlist_line = <<
Added to Favorites ENDWISHLIST; } // end if unset($this_cats); while($row = $cat_result->fetch()) { $this_cats .= "C" . $row->cat_id . " "; } // end while if($prod_row->mfg_name) { $mfg_array[$prod_row->mfg_id] = $prod_row->mfg_name; } if($prod_row->img) { $this_img = $prod_row->img; } else { $this_img = "nif.jpg"; } $prod_name = $prod_row->prod_name; if($prod_row->prod_label) { $prod_name = $prod_row->prod_label; } $cols_per_row = 3; $md_col = 12/$cols_per_row; if($item_counter % $cols_per_row == 0) { if($item_counter > 0) { $products_list .= ""; // close row } $products_list .= '

'; } $item_counter++; $products_list .= <<

$prod_row->mfg_name

$prod_name

{$shop_line}

ENDPRODS; } // end while $products_list .= ""; // close remaining open row $mfg_array = array_unique($mfg_array); asort($mfg_array); if($this_mfg_id) { // show all if MFG is filtered $mfgs = << Show All Manufacturers ENDALL; } else { $mfgs = 'Show Only:'; } foreach($mfg_array as $mfg_id => $mfg_name) { $mfgs .= << $mfg_name ENDFILTER; } // end foreach echo <<

$cat->cat_name

{$mfgs}

{$products_list} ENDHTML; include("foot.inc"); echo <<