$status = $_COOKIE['status'];
$repped=$_COOKIE['ecorep'];
$mycat=$_COOKIE['ecosmartmycat'];
$print = $_GET['print'];
$ctd=$_GET['ctd'];
if($print == "yes"){
if($ctd==""){
$goprint = "onLoad='javascript:printWindow()'";
}//if not coming from mycatalog
$status="";
$repped="";
$pgbg="white";
}else{
$goprint = "";
$pgbg="#BDDEA0";
}
/////////////////////////////////////////////////////////
$fr=$_GET['fr'];
if($fr == "iaq"){
$subcat = "Indoor Air Quality";//category name
$back = "IAQ/catiaq.php";//category address
$head = "catiaqhead.js";
if($print=="yes"){
$head = "catiaqheadprint.js";
}
}else{
$subcat = "HVAC";//category name
$back = "catac.php";//category address
$head = "catachead.js";
if($print=="yes"){
$head = "catacheadprint.js";
}
}
$page_name = "catac6";
$here=$page_name.".php";
$mycathere=$here;
$hereprint=$here."?print=yes";
$page=$page_name;//change folder if needed
$prodname="In-Duct UV Air Purifier";
if($mycat!=""){
$mycat_link="Add to My Catalog";
}else{
$mycat_link="My Catalog";
}
$item="AC-NatAir-Bio*";
$price_display="Listed Below";
$items[]="AC-NatAir-Bio150";
$itemnames[]="Residential In-Duct UV Air Purifier - Bio 150";
$items[]="AC-NatAir-Bio350";
$itemnames[]="Residential In-Duct UV Air Purifier - Bio 350";
$dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products');
foreach($items as $value){
$result = $dbcnx->query("SELECT list,retail,special,dealer,unit,cs FROM price WHERE item = '$value'");
if (!$result) {
//echo("ERROR:".mysql_error()."
");
$mess[]="Eco-\$mart Price: Quoted*";
$pay[] = "no";
}else{
$row = $result->fetch_row();
$list = $row['list'];
$retail = $row['retail'];
$special = $row['special'];
$dealer = $row['dealer'];
$unit = $row['unit'];
$units[]=$unit;
$cs = $row['cs']*1;
if($unit == "CS" and $cs > 0){
$unit = "CS*".$cs;
$caseit = "on";
}else{
$caseit = "off";
}
if($special>0 or $dealer>0){
$qoks[]=$value;
}
if($status == 'wholesale'){$charge=$special; $bergen = 'Special';}
elseif($status == 'dealer'){$charge=$dealer; $bergen = 'Wholesale';}
else{$charge=$retail; $bergen = "";}
if($retail == "0.00" and $list == "0.00" or $retail="" or $list==""){
$mess[]="Eco-\$mart Price: Quoted";
$pay[] = "no";
}else{
if($retail != "0.00" and $list == "0.00"){
$pay[] = "yes";
if($bergen != ""){
$mess[]="Regular Price: \$".$retail."" .
"
Eco-\$mart ".$bergen." Price: \$".$charge."";
}else{
$mess[]="Eco-\$mart Price: \$".$charge." ".$unit."";
}//no special pricing
}//retail is not 0 and list is
else{//all present
$pay[] = "yes";
if($bergen != ""){
$mess[]="List Price: \$".$list."".
"
Regular Price: \$".$retail."" .
"
Eco-\$mart ".$bergen." Price: \$".$charge." ".$unit."";
}else{//list but no special pricing
$mess[]="List Price: \$".$list."".
"
Eco-\$mart Price: \$".$charge." ".$unit."";
}
}//allpresent
}//retail and list are 0.00
if($caseit == "on"){
$cso[] = $cs.":".$charge;
$casecharge = $charge * $cs;
$price[] = sprintf("%01.2f", $casecharge);
}else{
$price[] = $charge;
$cso[] = "";
}//no cases
}//got result
}//4eachitem
//////////////////////////divide table cells for quote request
//$labels[]="Item Number";
//$itcount=count($items);
//$labcount=count($labels);
//$dibby=$itcount/$labcount;
//$codes=array();
$libdot = " ";
$libdotnew = "
";
?>
Residential In-Duct UV Air Purifier
Natures Aire Systems Ultraviolet Air Purifiers will destroy bio-chemical contaminants such as mold, mildew, fungus spores, formaldehyde, carbon monoxide, solvents and secondhand smoke. Additionally, these Air Purifiers will also irradiate viruses and bacteria such as legionella and tuberculosis.
The Bio-150 & Bio-350 are ideal for installation into the existing ductwork.
Perfect for ASTHMA & ALLERGY sufferers!
Item Number: AC-NatAir-Bio Unit of Issue: Each | |
Prices are for equipment only. Please contact your local A/C contractor for installation pricing. | |
| |
" .
"$itemnames[$i] " . "Item Number: $items[$i]"); if($print!="yes"){ if($pay[$i]=="yes"){ echo(" $mess[$i] " . ""); }else{ echo(" $mess[$i]"); if($print!="yes"){ echo(" " . "" . "Quote "); }//print is not yes }//pay is no }//print is not yes else{ echo(" $mess[$i]"); }//print is yes echo(" |
The Patented ProcessMore Details
" . "" . "©2010 Eco-\$mart, Inc." . " (888) 329-2705" . " info@eco-smart.com" . " www.eco-smart.com" . " |
" .
" $mycat_link " . " << Return to $subcat" . " | ||
" . "" . " ©2010 Eco-\$mart, Inc." . " (888) 329-2705" . " info@eco-smart.com" . " www.eco-smart.com" . " | " . " QUOTE " . " | " . " PRINT " . " |
" .
"
" . " Eco-\$mart Representative $repped Logged In. "); mysql_select_db('ecosmar_inv', $dbcnx); $getquote = $dbcnx->query("SELECT ID,CID FROM quotes WHERE usrn='$repped'"); if(!$getquote){ $air[]="Could not get quotes for ".$repped.". Error: ".mysql_error(); $show="off"; }else{ $numquos=mysql_num_rows($getquote); if($numquos < 1){ $show="off"; $air[]="No Quotes Started."; }else{//there are quotes while($rowq=mysql_fetch_array($getquote)){ $QIDs[]=$rowq['ID']; $CIDs[]=$rowq['CID']; }//while getting and filling arrays mysql_select_db('ecosmar_contacts', $dbcnx); foreach($CIDs as $value){ $getcon=mysql_query("SELECT first_Name,Name,Company FROM con_main WHERE ID='$value'"); if(!$getcon){ $air[]="Could not get contact info for contact. Error: ".mysql_error(); $show="off"; }else{ $rowc=mysql_fetch_array($getcon); $first_Name=$rowc[0]; $Name=$rowc[1]; $Company=$rowc[2]; if($Company!=""){ $quocos[]=$Company; }else{ $quocos[]=$first_Name." ".$Name; } }//got contact }//4each quote/contact ID }//there are quotes }//got quote $i=0; $countem=count($items); while($i<$countem){ if(in_array($items[$i],$qoks)){ $ast[]=$items[$i]; $astname[]=$itemnames[$i]; }//in array with dealer prices $i=$i+1; }//while counting items if(empty($ast)){ $air[]="No Quotes. No qualifying prices."; $show="off"; } if($show=="on"){ echo("");
foreach($air as $value){
echo(" ");
}//air is not empty
}//print is not yes
?>
$value"); }//4each echo(" |