$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 == "spot"){
$subcat = "LED Ceiling Spotlights";//category name
$back = "catled2010_SPOT2_.php";//category address
}else{
$subcat = "Daylighting";//category name
$back = "catdaylite.php";//category address
}
$page_name = "catdaylite2";
$here=$page_name.".php";
$mycathere=$here;
$hereprint=$here."?print=yes";
$page=$page_name;//change folder if needed
$prodname="Residential & Light Commercial Daylighting";
if($mycat!=""){
$mycat_link="Add to My Catalog";
}else{
$mycat_link="My Catalog";
}
$item="DL-DayTub-*";
$price_display="Listed Below";
$items[]="DL-DayTub-10";
$itemnames[]="10 inch dia. Tubular Daylighting Unit";
$items[]="DL-DayTub-13";
$itemnames[]="13 inch dia. Tubular Daylighting Unit";
$items[]="DL-DayTub-21";
$itemnames[]="21 inch dia. Tubular Daylighting Unit";
$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 & Light Commercial Daylighting
Save up to 90% daytime lighting costs with significant reduction in both A/C heat load and run time with tubular skylights.
These high quality, cost-efficient tubular skylights, with a tube reflectance of 98%, can fully replace electrical daytime lights, conserving energy and money.
O WATTS PER LUMEN!
No extra directional device in the dome is required to obtain maximum sunlight capture because the flashing mounts the roof dome in an upright position. Roof slopes ranging from flat to 8/12 can be accommodated.
Item: Unit of Issue: System Price: Quoted Installation by licensed roofing contractor. Typically $150.00 per unit. |
" .
" " .
" " .
"More Information" . " $libdotGallery" . " $libdotTubular Daylighting Overview PDF" . " $libdotClassroom Light Calculations PDF" . " $libdot2’ x 2’ Troffer' PDF" . " $libdotCross Sectional Drawing PDF" . " $libdotDade County Approval PDF" . " $libdotInstallation PDF" . " $libdotnewMiro-Silver for Light Pipes PDF" . " $libdotParts List PDF" . " $libdotMiro Testing PDF" . " $libdotLexan Data Sheet DOC" . " $libdotParts/Accessories" . " ----- " . "
|
<< Diffuser Options
![]() ![]() |
" .
" $itemnames[$i] $items[$i] $mess[$i] " . " | " . " |
" .
" $itemnames[$i] $items[$i] $mess[$i]"); if($print!="yes"){ echo(" | " . "" . "" . "Quote "); }//print is not yes echo(" |
" .
" $itemnames[$i] $items[$i] $mess[$i] |
" . "" . "©2012 Eco-\$mart, Inc." . " (888) 329-2705" . " info@eco-smart.com" . " www.eco-smart.com" . " |
" .
" $mycat_link " . " << Return to $subcat" . " | ||
" . "" . " ©2012 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(" |