Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item="LTLED-ECO-STW-*"; $items[]="LTLED-ECO-STW-50"; $itemnames[]="50W LED HO 160 Degree Wide-Light Screw-based Lamp"; $items[]="LTLED-ECO-STW-60"; $itemnames[]="60W LED HO 160 Degree Wide-Light Screw-based Lamp"; $items[]="LTLED-ECO-STW-80"; $itemnames[]="80W LED HO 160 Degree Wide-Light 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[]="50 Watts"; $labels[]="60 Watts"; $labels[]="80 Watts"; $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. Lamp base rotates 270 degrees after installation to direct light as required.

Features
 Beam Angle: 160° Wide-Light
 Lifetime: 50,000 Hours
 Base: E27 E40 E39
 Color Temperature:  Warm white (2800K-4500K),
Pure white (5000-6000K), Cold white (6500-8000k)
 CRI: >80
 Working Temperature: < -30°-50°C
 Rated Voltage: 85V-265VAC, or 90 to 277V, 50/60Hz
 Power Factor: >0.90
 3 Year Warranty

LED Wide-Light Installed
160° Lamp installed in Street Light
Applications:

• display lights
• warehouse
• lobbies
• offices
• supermarkets

Specifications
Item LTLED-ECO-STW-50 LTLED-ECO-STW-60 LTLED-ECO-STW-80
Dimensions 10.8" L x 5.9" W 10.8" L x 5.9" W 10.8" L x 5.9" W
LED 45*1W 54*1W 72*1W
Power 50W 60W 80W
Replaces Up to 200W HID up to 250W HID up to 320W HID
Lumens 4250 LM 5100 LM 6800 LM
" . "" . "" . "©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

"); } ?>