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
Tubular Sky Light Day Lighting

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.

Diffuser options
"); }//print isnt yes ?>
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" . "

 ----- 

" . "
" . "" . "

 10” diameter - Ideal for bathrooms and hallways (to 150 sq. ft.)
 13” diameter - Perfect for kitchens and larger rooms (to 250 sq. ft.)
 21” diameter
Illuminates up to 500 sq. ft.

<< Diffuser Options
Dot The white translucent diffuser is recommended for residential applications. It has a larger diffusion range and a softer more even light.
Dot The prismatic diffuser provides a stronger light, but in a tighter focus.

Potential LEED Credits
Credit for daylight - 1
Energy optimization credit - 10
Recycled content credit - 1

"); }else{ echo(""); }//pay is no }//print is not yes else{ echo(""); }//print is yes $i=$i+1; }//while counting down items ?>
" . " $itemnames[$i]
 $items[$i]   $mess[$i] " . "
" . "
" . "" . "" . "" . "" . "" . "QTY: " . " " . "
" . " $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" . ""); }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("
" . "
" . "
" . "" . "
" . "" . "
"); $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("" . "
"); }//while fetching cats }//got cats echo("" . "
" . "" . "
 
"); if($repped==""){ $skip="on"; }else{ $show="on"; $dnum=date(Ymd)*4; $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); 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{ echo("

" . " 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("
" . "
" . "" . "
" . "Eco-\$mart Quotes" . "  Add Products:" . "
"); if(!empty($ast)){ $i=0; $countast=count($ast); while($i<$countast){ if(in_array($ast[$i],$qoks)){ echo("QTY: " . "  ITEM: $ast[$i] ¦ $astname[$i]
"); }//in array with dealer prices $i=$i+1; }//while counting assepted items }//accepted items echo("TO:   " . "" . "" . "" . "" . "
" . "
"); }//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 ?>