Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item="LTIL-Y*J8*"; $items[] = "LTIL-Y40J840W38"; $items[] = "LTIL-Y40J850W38"; $items[] = "LTIL-Y60J840W38"; $items[] = "LTIL-Y60J850W38"; $items[] = "LTIL-Y80J840W"; $items[] = "LTIL-Y80J850W"; $items[] = "LTIL-Y100J840W"; $items[] = "LTIL-Y100J850W"; $items[] = "LTIL-Y120J840W"; $items[] = "LTIL-Y120J850W"; $items[] = "LTIL-Y150J840W"; $items[] = "LTIL-Y150J850W"; $items[] = "LTIL-Y200J840W58"; $items[] = "LTIL-Y200J850W58"; $items[] = "LTIL-Y250J840W58"; $items[] = "LTIL-Y250J850W58"; $items[] = "LTIL-Y300J840W58"; $items[] = "LTIL-Y300J850W58"; $items[] = "LTIL-Y400J840W58"; $items[] = "LTIL-Y400J850W58"; $items[] = "LTIL-Y500J840W58"; $items[] = "LTIL-Y500J850W58"; $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 ///////////////////////////////////////////////////// $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("
Rectangular Tube Induction Lamp

Retrofit and replace common lighting with
ultra-energy-efficient Induction Lighting

 Compact integrated structure, for many small size lighting fixtures.
 Special magnetic hoop structure, effectively avoids magnetic leakage and magnetic core power loss, with perfect heat dissipation.
 Special ferrite magnetic core, maintains the magnetic core inductance, stable in wide temperature range; unique B-H curve, reduce the magnetic hysteresis loss and magnetic core loss.
 Special, eco-friendly amalgam, for instant-start and enhanced stability in a wide range of temperatures.
 Self-developed inert gas formula, ensures consistency of light efficiency and power.
 Unique ballast designed for induction lighting, improves power factor.
 Special winding technology, improves low temperature start ability.
 Full range of color temperature, a variety of power options. Remote Ballast for Induction Lamp

External Ballast Included  [SpecificationsPDF"); } ?>
Shell Material: Aluminum
Power: 40 to 500 Watts
Voltage: 120 to 277V
Frequency: 50 / 60 Hz
Power Factor: >0.96

Lamp Specifications [PDF]"); } ?>

Power 40W 60W 80W 100W 120W 150W
Luminous efficiency (lm/W) 65-70 65-70 70-75 75-80 75-80 75-80
Initial luminous flux(lm) 2600-2800 3900-4200 5600-6000 7500-8000 9000-9600 11250-12000
Power 200W 250W 300W 400W 500W
Luminous efficiency (lm/W) 80-85 80-85 85-90 85-90 85-90
Initial luminous flux(lm) 16000-17000 20000-21250 25500-27000 34000-36000 42500-45000
Color temperature: 3500/4000/5000/6500 K  Color rendering index: >80  
" . "" . "" . "©2010 Eco-\$mart, Inc." . "    (888) 329-2705" . "    info@eco-smart.com" . "    www.eco-smart.com" . "
"); }else{ echo("" . "" . "
" . "

$mycat_link

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