include("assign.inc");
if(!$this_prod_id && !$this_prod_name ) {
redirect("index.htm");
} // end if
if(Str::has_value($this_prod_name) && $this_product_count == 0) {
redirect("index.htm");
} // end if
$ga_prod_name = $this_product_name;
$ga_prod_id = $this_prod_id;
$ga_prod_brand = $this_mfg_name;
if(!$this_subcat_id) {
$query = "SELECT cat.cat_id FROM `prod_cat` LEFT JOIN cat on cat.cat_id = prod_cat.cat_id WHERE `prod_id` LIKE '$this_prod_id' AND cat.parent_id = '$this_parent_cat_id';";
$this_subcat_id = $db->query($query)->fetch()->cat_id;
// echo "setting subcat id to " . $this_subcat_id;
}
// Get all product attributes
$prod_attr_query = "SELECT * FROM `attrib` LEFT JOIN `prod_attrib` ON attrib.attrib_id = prod_attrib.attrib_id LEFT JOIN `prod_attrib_data` ON prod_attrib_data.prod_attrib_id = prod_attrib.prod_attrib_id WHERE prod_attrib.prod_id = '$this_prod_id' ORDER BY prod_attrib_index";
$prod_attrib_result = $db->query($prod_attr_query);
$prod_attrib_count = $prod_attrib_result->count();
$prod_attr = $prod_attrib_result->fetch(); // set first attribute for main description, then reset query
$prod_main_desc = $prod_attr->prod_attrib_data_value;
$prod_main_desc = str_replace("query($item_query);
$item_count = $item_result->count();
$item = $item_result->fetch();
$item_price = $item->prod_item_price;
$price = Str::format_currency($item->prod_item_price);
$msrp = Str::format_currency($item->prod_item_msrp);
if($item_count == 0) {
$display_price = "Call For Pricing";
}
elseif($item_count > 1) {
$display_price = "Starting at " . $price;
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!
View Items to see our lower prices!";
// $sale_start = date('m d, Y', $item->prod_item_promo_start);
}
}
}
else {
$display_price = $price;
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);
}
}
}
include("head.inc");
include("side_menu.inc");
include("breadcrumbs.inc");
include("menu_bar.inc");
// include("gtags_tracking.inc");
?>