Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item = "LT-SSL-CH"; $unit="EA"; $qoks=array(); $items[]="LT-SSL-CH"; $itemnames[]="Solar Street Light LED Cobra Head Light"; $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($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"){ if($print!="yes"){ $pay[] = "yes"; }else{ $pay[] = "no"; }//print is 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 if($print!="yes"){ $pay[] = "yes"; }else{ $pay[] = "no"; }//print is 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 ?>

LED Cobra Head Light

The LED Cobra Head Light is the best choice for any energy-efficient, environmentally friendly lighting for roads, highways and thoroughfares. It works particularly well with Solar Powered applications because it uses up to 50% less energy than conventional lighting. The photometric design minimizes glare and improves nighttime visibility for superior road safety and remote location illumination. These Cobra Heads meet all LEED requirements forlight pollution reduction credits by minimizing light trespass, reducing sky-glow, andreducing the impact on nocturnal environments.

Item: $items[$i]

"); echo("

Price: Quoted

"); if($print!="yes"){ echo("

" . "" . "Quote Request

"); } ?>
" . "
  • Specifications PDF
  • " . "
  • Help
  • "); } ?>
    LED Cobra Head Dimensions

    LED Cobra Heads comply with ANSI requirements for side-mounted horizontal luminaires and mount easily on a 1¼” NPS or 2” NPS arm with ±6° of leveling adjustment.

    Features and Benefits:
     Full cutoff
     Low glare
     Dark Sky-compliant
     Die-cast housing
     IESNA type II light distribution pattern
     Optional IP-66 rating
     Polycarbonate or acrylic lens

     Highest target efficiency
     Uses up to 50 % less energy
     Maintenance-free for 10+ years
     Environmentally friendly
     No light trespass
     No light pollution

    " . "" . "" . "©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"; $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); echo("

    Eco-\$mart Representative: $repped Logged In.

    "); $dnum=date(Ymd)*4; 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{ 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"; }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 foreach($items as $value){ if(in_array($value,$qoks)){ $ast[]=$value; }//in array with dealer prices }//4each items if(empty($ast)){ $air[]="No Quotes. No qualifying prices."; $show="off"; } if($show=="on"){ echo("
    " . "
    " . "" . "
    " . "Eco-\$mart Quotes" . "  Add Products:" . "
    "); if(!empty($ast)){ foreach($ast as $value){ if(in_array($value,$qoks)){ echo("QTY: " . "  ITEM: $value
    "); }//in array with dealer prices }//4each accepted items }//accepted items echo("FOR QUOTE:   " . "" . "" . "" . "" . "
    " . "
    "); }//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 ?>