Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item="PC5-*"; $unit="GL"; $qoks=array(); ////////////////////////////////items in page order $items[] = "PC5-MC"; $itemnames[] = "Outdoor Wood Multi Cleaner - Ready Mix 750ml"; $items[] = "PC5-MP"; $itemnames[] = "Outdoor Wood Multi Protector - Ready Mix 750ml"; $items[] = "PC5-C1"; $itemnames[] = "Outdoor Wood Cleaner - 1 L"; $items[] = "PC5-C25"; $itemnames[] = "Outdoor Wood Cleaner - 2.5 L"; $items[] = "PC5-DC1"; $itemnames[] = "Outdoor Wood Two-Step Deep Cleaner - 1L"; $items[] = "PC5-OPRM"; $itemnames[] = "Outdoor Wood Primer"; $items[] = "PC5-DO75"; $itemnames[] = "Outdoor Deck Oil - 750ml"; $items[] = "PC5-DO25"; $itemnames[] = "Outdoor Deck Oil - 2.5L"; $items[] = "PC5-OP75"; $itemnames[] = "Outdoor Paint - 750ml"; $items[] = "PC5-OP25"; $itemnames[] = "Outdoor Paint - 2.5L"; $items[] = "PC5-BRC16"; $itemnames[] = "Outdoor Wood Cleaning Rotational Brush - 16 inch dia."; $items[] = "PC5-BRCM"; $itemnames[] = "Outdoor Wood Cleaning Manual Brush"; $items[] = "PC5-OAPH"; $itemnames[] = "Outdoor Deck Oil Applicator Handle"; $items[] = "PC5-OAPP"; $itemnames[] = "Outdoor Deck Oil Applicator Head"; $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($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 //////////////////////////divide table cells for quote request $labels[]="Item Number"; $itcount=count($items); $labcount=count($labels); $dibby=$itcount/$labcount; //$codes[]="D = Daylight"; //$codes[]="W = Warm White"; $codes=array(); $libdot = " "; ?>

Deck Oil Preserves Wood

"); }//print is not yes ?>
Item Number: PC5-*

Unit of Issue: Liter

Price: Quoted

" . "Quote Request"); } ?>
" . "

More Information" . "

$libdotRenovation" . "

$libdot More information coming soon" . "

 ----- 

" . "
" . "

Instead of merely covering wood with a protective coating, this line of outdoor wood preservation products maintain and rejuvenate outdoor wood with a two step process. The outdoor wood cleaning formulas and tools effectively expose the wood surface to the penetrating qualities of deck oil and primer. The Deck Oil works with wood’s natural characteristics, penetrating deeply into the wood where it hardens providing new life and strength to the wood. All in formulas that are non-toxic, do not pollute, and are not harmful to plants and animals.

Products for Natural Wood

Multi Cleaner
Exterior Wood Multi-Cleaner
Multi Protector
Exterior Wood Protector
Exterior Cleaner
Exterior Wood Cleaner
Deep Cleaner A & B
Exterior Wood Deep Cleaner
Mechanical Brush
Mechanical Cleaning Brush
Manual Brush
Manual Cleaning
Exterior Deck Oil
Exterior Deck Oil
Outdoor Wood Primer
Exterior Paint Primer
Outdoor Wood Paint
Exterior Wood Paint
Oil Applicator
Exterior Oil ApplicatorExterior Oil Applicator Handle
" . "" . "" . "©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($ref_RID!=""){ echo("

RID: $ref_RID

"); } if(!empty($air)){ echo("
"); foreach($air as $value){ echo("
$value"); }//4each echo("
"); }//air is not empty }//print is not yes ?>