$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_cell_conc";
$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 - Ceiling Concealed";
$item="AC-Solar-CCN";
$price_display="Listed Below";
$items[]="AC-Solar-CCN";
$itemnames[]="Solar AC - Ceiling Concealed";
$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("  | |
| " . " | |
Evergreen 
The unit is designed to be installed above the ceiling with only supply and return grilles exposed to view, making it an evergreen design while secretly providing you the perfect cooling comfort. 
| 
 Features & Benefits  | ||
| 
Versatility 
 With the only one unit of fan coil, multiple rooms can be cooled together at the same time.  
 | 
Flexibility In Installation 
 The supply & return grilles can be selected based on your personal preference to blend with your interior design. No more worries of where to locate your air conditioner as the ACC unit is cleverly hidden above the ceiling.  | 
Space Saving 
 Designed for flexibility in installation location, the low physical height allows application even in buildings with limited above – ceiling height.  | 
| 
Excellent Air Distribution 
 Cool conditioned air can be effectively distributed to every corner of the room through the ducting and this ensures a more pleasant environment for comfort living.  | 
Double Protection Drainage System 
 The original Double Protection Drainage System offers you double protection against water leakage. The primary drain pan is designed with the thermal insulation material and mould in gradient for better condensate water drainage. The “Ready-made” and “Built-in” secondary drain pan offers easy installation at site while providing the extra prevention for water leakage problems.  | |
| 
Duct Accessories (Optional*) 
 * Available only for SCC12SP - SCC24SP The following accessories are designed for easy installation at site. 
  | 
 
 | 
| " . "" . "©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("  |