Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item = "AC-ERV-R"; $unit="EA"; $qoks=array(); $items[]="AC-ERV-R"; $itemnames[]="Residential ConsERV Energy Recovery Ventilator"; $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($dealer !="" and $dealer!=0.00 and $dealer!="0.00" and $dealer>1){ $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"){ if($print!="yes"){ $pay[] = "yes"; }else{ $pay[] = "no"; }//print is 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 if($print!="yes"){ $pay[] = "yes"; }else{ $pay[] = "no"; }//print is 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 ?>

LED Cobra Head Light

Item: $items[0]

"); echo("

Price: Quoted

"); if($print!="yes"){ echo("

" . "" . "Quote Request

"); } ?>
" . "
  • Brochure PDF
    • " . "
  • Presentation PDF
    • " . "
  • Help
    • "); } ?>

    ConsERV Reduces:
     smells and musty odors
     conditions fostering mold
     excess humidity
     tobacco smoke
     cooking odors
     offgassing from carpets, paints, and other construction materials


    AHRI Certified Approvals

    ConsERV™ Brings Fresh Air Into Your Home – Without The Hassles. Opening the windows and doors of your home is a great way to bring in fresh air and wash out the stale, recirculated air. But, that can present a long list of problems:  bad weather conditions, uncomfortable temperatures, security risks, humidity, pollen, dust or pests and noise. With the ConsERV system on, it is like being able to keep your windows and doors open, flowing a continuous stream of filtered fresh air every hour of the day, but without the hassle.

    Lower Energy Bills – Lower Carbon Footprint
    A home with recirculated, stuffy air requires you to lower the temperature to make it "feel" comfortable. When you introduce filtered fresh air regularly, you can raise your thermostat 4-6 degrees and have the same level of comfort. U.S. Department of Energy studies show ConsERV can save you 12 percent to 15 percent on cooling or heating costs every month, as well as reduce the carbon footprint of your home. These benefits are huge to you and the environment.

    Indoor Air Pollution & Chemicals
    The U.S. EPA says indoor pollution is two to three times higher than outdoor pollution! This toxic indoor living environment is contributing to chronic health problems. This is especially critical to pregnant women, babies, children, the sick and elderly. While ConsERV can’t cure these illnesses, it can reduce the conditions which trigger them.

    		Conceptual Drawing

    How does the ERV work?
    The enthalpic core at the center of the unit transfers heat and moisture from the incoming air to the outgoing air. The air brought into the living area is cooled and the humidity is reduced for maximum comfort. The load on your air conditioner is less, and you save on cooling costs.


    " . "" . "" . "©2012 Eco-\$mart, Inc." . "    (888) 329-2705" . "    info@eco-smart.com" . "    www.eco-smart.com" . "
    "); }else{ echo("" . "" . "
    " . "

    $mycat_link

    " . "  << Return to $subcat" . "
    " . "" . "©2012 Eco-\$mart, Inc." . "   (888) 329-2705" . "   info@eco-smart.com" . "   www.eco-smart.com" . "" . " QUOTE " . "" . " PRINT " . "
    "); echo("
    " . "
    " . "
    " . "" . "
    " . " ECO-\$MART Home " . "
    " . "" . "
    " . " Catalog Home " . "
    "); $getcats = $dbcnx->query("SELECT cat_name,catpage FROM cats ORDER BY cat_name"); if(!$getcats){ $air[]="Could not get categories for menu. Error: "; }else{ while ($row = $getcats->fetch_row()) { echo("" . "
    " . " $row[0] " . "
    "); }//while fetching cats }//got cats echo("" . "
    " . " TOP " . "
    " . "" . "
     
    "); if($repped==""){ $skip="on"; }else{ $show="on"; $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); echo("

    Eco-\$mart Representative: $repped Logged In.

    "); $dnum=date(Ymd)*4; mysql_select_db('ecosmar_website', $dbcnx); $checkrep=mysql_query("SELECT ID FROM psw WHERE usrn='$repped'"); if(!$checkrep){ $air[]="Could not verify rep. Error: ".mysql_error(); $show="off"; }else{ $row=mysql_fetch_array($checkrep); $uID=$row[0]; if($uID==""){ $air[]="Representative does not match records."; $show="off"; }else{ 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"; }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 foreach($items as $value){ if(in_array($value,$qoks)){ $ast[]=$value; }//in array with dealer prices }//4each items if(empty($ast)){ $air[]="No Quotes. No qualifying prices."; $show="off"; } if($show=="on"){ echo("
    " . "
    " . "" . "
    " . "Eco-\$mart Quotes" . "  Add Products:" . "
    "); if(!empty($ast)){ foreach($ast as $value){ if(in_array($value,$qoks)){ echo("QTY: " . "  ITEM: $value
    "); }//in array with dealer prices }//4each accepted items }//accepted items echo("FOR QUOTE:   " . "" . "" . "" . "" . "
    " . "
    "); }//show is on }//repped matches usrn in psw }//chekd rep }//rep is present if(!empty($air)){ echo("
    "); foreach($air as $value){ echo("
    $value"); }//4each echo("
    "); }//air is not empty }//print is not yes ?>