Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item = "AC-ERV-C"; $unit="EA"; $qoks=array(); $items[]="AC-ERV-C"; $itemnames[]="Commercial ConsERV Energy Recovery Ventilator"; /////////////////////////////more items to follow $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 " . "From Small Light Industrial To Large Scale Commercial, we have an ERV Solution To Meet Your Needs. ConsERV™ provides a complete solution to meet your requirements – ranging from 50 cfm to 11,000 cfm in packaged units and custom packages available up to 35,000 cfm. ConsERV is the industry’s best performing fixed plate ERV as determined by our growing list of customers, and independent industry validation." . "

"); }//print is not yes ?>
Item: $items[0]

"); echo("

Price: Quoted

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

" . "" . "Quote Request

"); } ?>
" . "
  • Brochure PDF
    • " . "
  • Presentation PDF
    • " . "
  • Help
    • "); } ?>
    Certificates and Approvals
    " . "From Small Light Industrial To Large Scale Commercial, we have an ERV Solution To Meet Your Needs. ConsERV™ provides a complete solution to meet your requirements – ranging from 50 cfm to 11,000 cfm in packaged units and custom packages available up to 35,000 cfm. ConsERV is the industry’s best performing fixed plate ERV as determined by our growing list of customers, and independent industry validation." . "

    "); }//print is not yes ?>
    Applications
    Rooftop with Fans
    Outside with Fan
    350 cfm to 11,000 cfm rooftop fanned units with *options that can run independent or connected to all air handlers.     		Indoor with Fans
    Inside with Fan
    350 cfm to 11,000 cfm indoor fanned units configured with *options to connect to all air handlers.
    *Options include VFDs, pre-heat, motorized dampers, gravity dampers, temperature control, occupancy control, dirty filter sensor, air flow monitoring and more.
    !tinydiamond.gifSmallest ERV Footprint
    !tinydiamond.gifGreat for Renovation
    !tinydiamond.gifFits most equipment rooms
    Indoor without Fans
    Inside No Fan
     A complete line of non-fanned units can be integrated into projects with existing fan capacity. Units can be stacked to provide more than 28,800 cfm if required. These have the smallest ERV footprint and are great for renovation projects as they can easily fit in most existing equipment rooms.     		Custom Units
    Custom Applications
    Larger system requirements are addressed with multiple systems, or the integration of ConsERV cores (orcore cassettes) into custom built enclosures to meet these special project needs. Please contact us to discuss your project requirements.

    " . "" . "" . "©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 ?>