Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item="LTIL-BLGFUS-EC-*W"; //$proddocs[]="LTIL-EGF-EC-70W.pdf"; //$proddocs[]="LTIL-EGF-EC-100W.pdf"; //$proddocnames[]="70 Watt"; //$proddocnames[]="100 Watt"; $proddocs=array(); $proddocnames=array(); $items[] = "LTIL-BLGFUS-EC-40W"; $items[] = "LTIL-BLGFUS-EC-55W"; $items[] = "LTIL-BLGFUS-EC-70W"; $items[] = "LTIL-BLGFUS-EC-100W"; ///////////////////////////////////////////////////////////// $dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products'); foreach($items as $value){ $result = $dbcnx->query("SELECT list,retail,special,dealer,unit,cs,description 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($dealer !="" and $dealer!=0.00 and $dealer!="0.00" and $dealer>1){ $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 $itemnames[]=$row['description']; }//got result }//4eachitem //////////////////////////divide table cells for quote request $labels[]="40W"; $labels[]="55W"; $labels[]="70W"; $labels[]="100W"; $itcount=count($items); $labcount=count($labels); $dibby=$itcount/$labcount; //$codes[]="D = Daylight"; //$codes[]="W = Warm White"; $codes=array(); ?>
www.eco-smart.com

Induction Lighting
BACK

$labels[0]"); }else{ echo(""); } }//more than one label $countem=count($items); if($countem==1){ if($print!="yes"){ echo(" $items[0] "); if($pay[0]=="yes"){ echo(""); }else{ echo(""); }//pay is no }else{ echo(""); }//print is yes }else{////////////////////more than one item echo(""); $i=0; 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 }//more than one item ?> "); }//codes is not empty ?>
" . "

$labels[0]

"); } }else{ foreach($labels as $value){ echo("
$value" . "$mess[0]
" . "
" . "" . "" . "" . "" . "" . "QTY: " . " " . "
" . "$mess[0]"); if($print!="yes"){ echo("

" . "" . "Quote

"); }//print is not yes echo("
" . " $items[0] 
$mess[0]
" . " $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("
Round Induction Garage Light

An energy efficient Induction and LED lighting source fixture coupled with occupancy sensor controls that creates a Dark-Sky and Nature Friendly environment.

 Engineered optics provide uniform distribution and decreased levels of driver / pedestrian glare
 Lamp Life Rating: 100,000/50,000 hours
 Energy Savings: 60%-80% over HPS and HID sources
 Lumen Maintenance: 70% over 100,000 hours
 Heat management system including heatsink technology and isolated ballast compartment
 Light weight and compact structure for easy installation and maintenance
 Die cast aluminum housing with powder coat finish for corrosion resistance
 Amber LED lights are Dark-Sky and Animal Friendly
 Amber light prevents the altering of circadian rythm for certain species in surrounding wildlife
 Not intended for sea turtle mating habitats
Specifications "); $countdocs=count($proddocs); $i=0; while($i<$countdocs){ echo("$proddocnames[$i] PDF  "); $i=$i+1; }//while echo(""); }//print is not yes ?>
Wattage: 40W 55W 70W 100W
Lumens: 3,350 4,650 5,900 8,400
Lamp Life Rating: 100,000 hrs
LED Light Output: Amber Standard, 3000K, 5000K available*
CCT(Kelvin): 5000k
CRI: 82-85
IP Rating: IP65
Warranty: 10 Years
Applications: Induction Lighting for parking garages, gas stations, schools, shopping malls
Ballast Specifications:
Input Wattage 44 61 78 111
Input Voltage 120-277v / 480v   50/60 Hz
Input Current 0.37-0.16A 0.50-0.21A 0.63-0.29A 0.70-0.32A
Power Factor >.95
Operating Temp. -40 to 130°F
THD <10%
LED Specifications
Wattage 20 40
Lumens 865 1,733
Input Voltage 120/277V
Output Voltage 2.8-28V
CCT(Kelvin): Amber, 3000, 5000
Operating Temp. -40 to 130°F
Rated Life 50,000 Hours

 

" . "" . "" . "©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

"); } ?>