Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $prodname="15W LED Ceiling Spotlight"; $item="LTLED-FDL-12X1.2W-001*"; $items[]="LTLED-FDL-12X1.2W-001N"; $itemnames[]="15W LED Ceiling Spotlight - Natural White"; $items[]="LTLED-FDL-12X1.2W-001W"; $itemnames[]="15W LED Ceiling Spotlight - Warm White"; $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[]="Natural White"; $labels[]="Warm White"; $itcount=count($items); $labcount=count($labels); $dibby=$itcount/$labcount; //$codes[]="D = Daylight"; //$codes[]="W = Warm White"; $codes=array(); ?>
www.eco-smart.com

LED Replacement Lamps
BACK

$value"); } ?> " . " $items[$i]
$mess[$i]
" . "" . "" . "" . "" . "" . "" . "QTY: " . " " . ""); }else{ echo(""); }//pay is no }else{ echo(""); }//print is yes $i=$i+1; }//while counting items ?> "); }//codes is not empty ?>
" . " $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("

Features:

  • Aluminum heat sink.
  • No UV or RF interference.
  • Patented heat sink and optical diffuser.
  • Longer life than incandescent & fluorescents.
  • No mercury.
  • No ballast required.
  • Wide voltage and constant current design.
  • Solid state, high shock & vibration resistant.
  • No noise, no flickering.
  • 66%+ savings in energy consumption.
  • In accordance with CE, UL and FCC testing standards.

Applications:  The 15W Ceiling Spotlight has been designed to retrofit existing ceiling down light installations, thereby reducing maintenance and energy expenditures, and as an energy saving light source for new fixtures and installations. Adjustable beam angle to 60° makes it perfect for focusing light on displays or architectural features.

 Focal Lighting    Security Lighting    Retail Display    Hospitality    Residential lighting    Walk and Hallway

Ceiling Spotlight
Also shown in
LED Spotlights
Specifications:
Base: 2 pin Beam Angle: 30/45/60° LED Qty: 12 LEDs
Input Voltage: 85VAC to 266VAC Power(W): 15 Watts Lumens: 1200
Color
   Natural White
   Warm White
Color Temperature
~ 2600-3700K
~ 4000-4500K

" . "" . "" . "©2010 Eco-\$mart, Inc." . "    (888) 329-2705" . "    info@eco-smart.com" . "    www.eco-smart.com" . "
"); }else{ echo("" . "" . "
" . "

$mycat_link

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