Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item="LTLED-ECO-STN-*W"; $items[]="LTLED-ECO-STN-20W"; $itemnames[]="20W LED 360 degree Screw-in Lamp"; $items[]="LTLED-ECO-STN-30W"; $itemnames[]="30W LED 360 degree Screw-in Lamp"; $items[]="LTLED-ECO-STN-40W"; $itemnames[]="40W LED 360 degree Screw-in Lamp"; $items[]="LTLED-ECO-STN-50W"; $itemnames[]="50W LED 360 degree Screw-in Lamp"; $items[]="LTLED-ECO-STN-60W"; $itemnames[]="60W LED 360 degree Screw-in Lamp"; $items[]="LTLED-ECO-STN-80W"; $itemnames[]="80W LED 360 degree Screw-in Lamp"; $countem=count($items); if($countem > 8){//go to price list $price_list="on"; }else{ $price_list="off"; } $qoks=array(); ///////////////////////////////////////////////////////////// $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[]="20W"; $labels[]="30W"; $labels[]="40W"; $labels[]="50W"; $labels[]="60W"; $labels[]="80W"; $itcount=count($items); $labcount=count($labels); $dibby=$itcount/$labcount; //$codes[]="DL = Daylight"; $codes=array(); ?>
www.eco-smart.com

LED Replacement Lamps
BACK

" . ""); $i=0; while($i<$countem){ echo("" . ""); $i=$i+1; }//while counting items echo("" . "" . "" . "" . "" . "" . "" . "" . "" . ""); }//print is not yes else{ echo(""); }//print is yes }//price list is on else{ foreach($labels as $value){ echo(""); }//4each echo(""); $i=0; $countem=count($items); while($i<$countem){ if($print!="yes"){ if($pay[$i]=="yes"){ echo(""); }else{ echo(""); }//pay is no }else{ echo(""); }//print is yes $i=$i+1; }//while counting items ?> "); }//codes is not empty }//no price list ?>
" . "See Price List$value
" . " $items[$i]
$mess[$i]
" . "
" . "" . "" . "" . "" . "" . "QTY: " . " " . "
" . " $items[$i]
$mess[$i]"); if($print!="yes"){ echo("

" . "" . "Quote

"); }//print is not yes echo("
" . " $items[$i] 
$mess[$i]
"); $codcount=count($codes); $a=0; foreach($codes as $value){ $a=$a+1; if($codcount!=$a){ $sp=","; }else{ $sp=""; } echo("$value$sp "); }//4each echo("

The 360° LED Screw-In Lamp integrates energy saving, long life LED technology in a powerful and efficient SMD LED street light lamp. E26, E27, E39, E40 base options for direct retrofit of incandescent, CFL and HID lamps.

Features:
  • 20 to 80 Watts
  • Standard Screw-in Base E27 / E39 / E40
  • 360° illumination
  • Replaces 70W to 320W CFL
  • Available Color Temp (Kelvins) 2700-6700K
  • Minimal heat output
  • Up to 50,000 hour lamp life
  • 3 year warranty
Applications:

Communities and housing developments can drastically reduce energy costs and significantly decrease maintenance costs with energy efficient LED lamps that last up to 11 years.
• Site, Roadway, Post Lighting  • Wall packs  • Security lighting   • Parks and quads  • Municipal lighting


LED 360 Degree Lamp
Item LTLED-ECO-STN-20W LTLED-ECO-STN-30W LTLED-ECO-STN-40W LTLED-ECO-STN-50W LTLED-ECO-STN-60W LTLED-ECO-STN-80W
Power 20W 30W 40W 50W 60W 80W
Voltage 100-300 VAC / 50-60HZ
LED Emitter Life 50,000hrs (3 Year Warranty)
PF >0.95
Power Efficiency >87%
Working Voltage 33VDC ±5%
Operating Temperature -40 ~ 45°
Color Rendering Index Ra >85
LED Qty 300 pcs 486 pcs 660 pcs 780 pcs 900 pcs 1160 pcs
Dimensions
Inches DxL
3.5 x 9 3.5 x 9 3.6 x 9.4 3.6 x 10.2 3.6 x 11.2 4.2 x 11.4
Luminous Flux  ±5% 2200lm 3300lm 4600lm 5600lm 6600lm 9000lm
Replaces 75W HID 125W HID 175W HID 200W HID 250W HID 320W CFL
" . "" . "" . "©2011 Eco-\$mart, Inc." . "    (888) 329-2705" . "    info@eco-smart.com" . "    www.eco-smart.com" . "
"); }else{ echo("" . "" . "
" . "

$mycat_link

" . "  << Return to $subcat" . "
" . "" . " ©2011 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 ?>