Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item="LTIL-*W-V-E*"; $items[] = "LTIL-18W-V-120-E26"; $items[] = "LTIL-18W-V-220-E26"; $items[] = "LTIL-18W-V-277-E26"; $items[] = "LTIL-18W-V-120-E40"; $items[] = "LTIL-18W-V-220-E40"; $items[] = "LTIL-18W-V-277-E40"; $items[] = "LTIL-23W-V-120-E26"; $items[] = "LTIL-23W-V-220-E26"; $items[] = "LTIL-23W-V-277-E26"; $items[] = "LTIL-23W-V-120-E40"; $items[] = "LTIL-23W-V-220-E40"; $items[] = "LTIL-23W-V-277-E40"; $items[] = "LTIL-40W-V-120-E26"; $items[] = "LTIL-40W-V-220-E26"; $items[] = "LTIL-40W-V-277-E26"; $items[] = "LTIL-40W-V-120-E40"; $items[] = "LTIL-40W-V-220-E40"; $items[] = "LTIL-40W-V-277-E40"; $items[] = "LTIL-50W-V-120-E26"; $items[] = "LTIL-50W-V-220-E26"; $items[] = "LTIL-50W-V-277-E26"; $items[] = "LTIL-50W-V-120-E40"; $items[] = "LTIL-50W-V-220-E40"; $items[] = "LTIL-50W-V-277-E40"; $items[] = "LTIL-60W-V-120-E26"; $items[] = "LTIL-60W-V-220-E26"; $items[] = "LTIL-60W-V-277-E26"; $items[] = "LTIL-60W-V-120-E40"; $items[] = "LTIL-60W-V-220-E40"; $items[] = "LTIL-60W-V-277-E40"; $countem=count($items); if($countem > 8){//go to price list $price_list="on"; }else{ $price_list="off"; //////////////////////////edit labels for price table if presented on this page $labels[]="120VAC"; $labels[]="240VAC"; $labels[]="277VAC"; $itcount=count($items); $labcount=count($labels); $dibby=$itcount/$labcount; //$codes[]="E26 = E26 Base"; //$codes[]="E40 = E40 Base"; $codes=array(); }//pricelist is off $qoks=array(); ///////////////////////////////////////////////////// $dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products'); if($price_list=="off"){ 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; $itemnames[]=$row['description']; 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 }//pricelist is off ?>
www.eco-smart.com

Induction Lighting
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 ?> "); }//codes is not empty ?>
" . "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("
"); $codcount=count($codes); $a=0; foreach($codes as $value){ $a=$a+1; if($codcount!=$a){ $sp=","; }else{ $sp=""; } echo("$value$sp "); }//4each echo("
50 Watt Induction Light Bulb
Self Ballasted Induction Lamp Sale Special Web Sale!
 23 Watt 5000K 277V Medium Base - $27.95 each
While Supplies Last - No Minimum Order - In Stock!  Order Request

Compact ballast design, low wattage (18W - 60W)
International standard lamp base, E26 or E40.
Rated 60,000 Hours - 5 Year Warranty

 Special mushroom shape structure provides uniform light emission in 360° space. Larger light surface area than other lamps with the same wattage with no glare.
 Compact integrated structure and standard E-type spiral lamp base allows direct replacement in many kinds of lighting fixtures for many different uses.
 Special magnetic hoop structure effectively stops magnetic leakage and magnetic core power loss with highly efficient heat dissipation.
 Ferrite magnetic core, with unique BH curve, maintains magnetic core inductance stability in a wide temperature range reducing magnetic leakage and magnetic core loss.
 Special amalgam allows instant-start with continued stability in a wide temperature range. Eco-friendly amalgam reduces pollution.
 Advanced technology and special winding technology improves instant-start further even at low temperatures.
 Proprietary inert gas formula ensures the consistent light efficiency and power.
 Full range of color temperature, a variety of power options
 Advanced internal ballast technology improves the power factor.
UL Listed  UL Listed.
Specifications
For base down applications only
Watts Volts  DC/AC Rated Lumens (Lm) Pupil Lumens (Plm) Lamp Dimensions(in.)
18 12/24/120/220/277 950 1995 2.3 x 6.3
23 12/24/120/220/277 1400 2730 3.1 x 7.2
40 12/24/120/220/277 2800 5880 3.5 x 10.3
50 12/24/120/220/277 3500 7665 3.5 x 10.3
60 12/24/120/220/277 4200 9198 3.5 x 10.3
Color temperature: 3500/4000/5000/6500 K  Color index: CRI>80 (Ra)
" . "" . "" . "©2011 Eco-\$mart, Inc." . "    (888) 329-2705" . "    info@eco-smart.com" . "    www.eco-smart.com" . "
"); }else{ echo("" . "" . "
" . "

$mycat_link

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

"); } ?>