$status = $_COOKIE['status'];
$repped=$_COOKIE['ecorep'];
$mycat=$_COOKIE['ecocat'];
$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 == "ac"){
$subcat = "Solar AC";//category name
$back = "catac20.php?fr=".$fr;//category address
$head = "../catachead.js";
}else{
$subcat = "Solar Energy";//category name
$back = "../catsolar.php";//category address
$head = "../catsolarhead.js";
}
$page_name = "catac20_ducted";
$here=$page_name.".php";
$hereprint=$here."?print=yes";
$page="catsolarac/".$page_name;//change folder if needed
if($mycat!=""){
$mycat_link="Add to My Catalog";
}else{
$mycat_link="";
}
$prodname="Solar AC - Ducted";
$item="AC-Solar-DCT";
$price_display="Listed Below";
$items[]="AC-Solar-DCT";
$itemnames[]="Solar AC - Ducted";
$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 = "
 ";
if($unit==""){
$unit="EACH";
}
?>
	
| 
Item Number:  Unit of Issue:  | |
| 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("  | |
| " . " | |
Fresh Air for Healthy Living 
Fresh air can be introduced into the building through the design of fresh air intakes such that a predetermined percentage of fresh air can be drawn into the system and supplied to every corner of the building.  This will improve the Indoor Air Quality (I.A.Q).  
| 
Super Silent Operation for All Areas 
 The ducted design allows for air to be supplied into the room without motor noise, providing a super silent condition for better living.  | 
 
 | 
Superior Air Distribution for Comfortable Living
 High airflow coupled with high external static pressure allows for the air to be distributed to every corner of the building through long ducting, providing optimum comfort to the occupants.  | 
| 
Flexibility in Installation
 Available models include horizontal and vertical discharge options, as well as convertible models that can be configured for horizontal or vertical discharge.  | 
 
 | 
Flexibility of Air Supply 
 Belt driven models allow controll of air volume and static can be adjusted according to requirements. This flexibility provides wider application. All models can be configured with belt drive.  | 
| " . "" . "©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("  |