Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item = "LT-SSL-Power"; $unit="EA"; $qoks=array(); $items[]="LT-SSL-Power"; $itemnames[]="Solar Street Light Power Assembly"; $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 ?>

Solar Power Assembly

Item: $items[0]

"); echo("

Price: Quoted

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

" . "" . "Quote Request

"); } ?>
" . "
  • Specifications PDF
    • " . "
  • Help
    • "); } ?>

    Solar Electric Power Assemblies have riveted aluminum frames and welded mounting brackets to provide durability and flexibility in harsh conditions. Liquid tight plug in connectors and wire harness make installation fast and easy. Unique welded one piece power bracket allows tilting the solar panel assembly for maximum sun exposure.

     Riveted Aluminum Frames and Vented Panel Pans
     Welded Rear Channel Mounting Brackets
     Liquid Tight Connectors and Flex-Tube
     High-Gauge Vented Aluminum Battery Storage Assembly
     Full Wire Harness w/ Battery Cables and Quick Connect Terminals
     Unique Welded One Piece Power Bracket
     Meets 150 MPH Exposure “D” wind force requirements

    Solar Modules
    Solar Panel
     Single Crystal Solar Panels
     Designed for highest durability
     Allows for smallest size and weight
      for desired output     		Deep-Cycle Solar Photovoltaic Batteries
    Deep Cycle Battery
     Maintenance Free
     High Durability
     Sealed Gel-Cell
     Non-Spillable, Non Hazardous

    " . "" . "" . "©2010 Eco-\$mart, Inc." . "    (888) 329-2705" . "    info@eco-smart.com" . "    www.eco-smart.com" . "
    "); }else{ echo("" . "" . "
    " . "  << Return to $subcat" . "
    " . "" . "©2010 Eco-\$mart, Inc." . "   (888) 329-2705" . "   info@eco-smart.com" . "   www.eco-smart.com" . "" . " QUOTE " . "" . " PRINT " . "
    "); echo("
    " . "
    " . "
    " . "" . "
    " . " ECO-\$MART Home " . "
    " . "" . "
    " . " Catalog Home " . "
    "); $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("" . "
    " . " $row[0] " . "
    "); }//while fetching cats }//got cats echo("" . "
    " . " TOP " . "
    " . "" . "
     
    "); 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 if($ref_RID!=""){ echo("

    RID: $ref_RID

    "); } }//print is not yes ?>