Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item="LTLED-ECO-*W-360-SQ"; $items[]="LTLED-ECO-27W-360-SQ"; $itemnames[]="27W LED HO 360 Degree Low Profile Screw-based Lamp"; $items[]="LTLED-ECO-33W-360-SQ"; $itemnames[]="33W LED HO 360 Degree Low Profile Screw-based Lamp"; $items[]="LTLED-ECO-43W-360-SQ"; $itemnames[]="43W LED HO 360 Degree Low Profile Screw-based Lamp"; $items[]="LTLED-ECO-55W-360-SQ"; $itemnames[]="55W LED HO 360 Degree Low Profile Screw-based Lamp"; $items[]="LTLED-ECO-63W-360-SQ"; $itemnames[]="63W LED HO 360 Degree Low Profile Screw-based Lamp"; $countem=count($items); if($countem > 6){//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[]="27 Watt"; $labels[]="33 Watt"; $labels[]="43 Watt"; $labels[]="55 Watt"; $labels[]="63 Watt"; $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("
Low Profile LED Lamp

Description: High Power LED Screw Based Lamps produce retrofit equivalent light output in an energy saving, 50,000 hour alternative to Metal Halide, HPS, Fluorescent, or Incandescent lighting. This patented LED Low Profile Lamp is designed with an oblique light panel which takes full advantage of LED unidirectional photic that makes the light spot to the ground efficiently increasing the light use ratio.

Features
 Beam Angle: 360°
 Lifetime: 50,000Hours
 Base: E40 E39
 Color Temperature:
    WW(2700~3800K), NW(4000-5000K) or CW(5500-6700K)
 Light Source: Epistar LED Chip(90~100Lm/LED)
 Body Temperature: < 70°
 Rated Voltage: 100~300VAC, 50/60Hz
    24VDC for solar power system is available
 Power Factor: 0.95
 3 Year Warranty
 CE ROHS approved

Low Profile Installed
Low Profile Lamp installed in Canopy Light
Applications:

• canopy lights
• ceiling lights
• coach lights
• display lights
• warehouse
• lobbies
• offices
• supermarkets

43 Watts Replaces 175 Watt MH
43W LED
- Replacing 175W MH

55 Watt LED Replaces 250 Watt HID
55W LED
- Replacing 250W HID
Specifications    CE Listed  FCC Standards
Item ECO-27W-360-SQ ECO-33W-360-SQ ECO-43W-360-SQ ECO-55W-360-SQ ECO-63W-360-SQ
Dimensions D 5.0" x L 7.1" D 5.0" x L 7.1" D 5.0" x L 7.1" D 5.0" x L 7.1" D 5.0" x L 7.1"
LED 430PCS 3528 SMD 510PCS 3528 SMD 430PCS 2833 SMD 510PCS 2833 SMD 510PCS 2833 SMD
Power 27W ±10% Watts 33W ±10% Watts 43W ±10% Watts 55W ±10% Watts 63W ±10% Watts
Replaces Up to 125W HID up to 150W HID up to 175W HID up to 250W HID up to 350W HID
Lumens 2700LM 3600LM 4400LM 5500LM 6300LM
Life Time ≥50,000 Hrs
" . "" . "" . "©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 if($ref_RID!=""){ echo("

RID: $ref_RID

"); } ?>