Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item="LTIL-EGFUS-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-EGFUS-EC-40W"; $items[] = "LTIL-EGFUS-EC-55W"; $items[] = "LTIL-EGFUS-EC-7028W"; $items[] = "LTIL-EGFUS-EC-8032W"; $items[] = "LTIL-EGFUS-EC-10040W"; $items[] = "LTIL-EGFUS-EC-12048W"; ///////////////////////////////////////////////////////////// $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[]="70/28W"; $labels[]="80/32W"; $labels[]="100/40W"; $labels[]="120/48W"; $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

Smart Light Fixtures use bi-level and on/off sensor controls for increased pedestrian safety and unmatched energy savings.

 Energy Savings: 60% over HID sources
 Lumen Maintenance: 70% over 100,000 hours
 Bi-Level: Ballast option dims to 40% power for increased energy savings
 Engineered optics provide uniform distribution and decreased levels of driver / pedestrian glare
 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
 Excellent vibration & shock resistance
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 / 28W 80W / 32W 100W / 40W 120W / 48W
Lumens: 3,350 4,650 5,900 / 2,400 7,150 / 2,900 8,400 / 3,400 10,100 / 4,100
Lamp Life Rating: 100,000 hrs
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 82.6 / 36.9  94.4 / 46.9  118.0 / 58.5  141.6 / 70.1 
Input Voltage 120-277v / 480v   50/60 Hz
Input Current 0.38-0.17A / 0.10A 0.50-0.21A / 0.13A 0.69-0.30A / 0.17A 0.79-0.34A / 0.20A 0.98-0.43A / 0.25A 1.18-0.51A / 0.30A
Power Factor >.95
Operating Temp. -30 to 130°F -40 to 130°F
THD <10%
 Dimmed
" . "" . "" . "©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

"); } ?>