Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item = "CT-EBWT-BB*"; $unit="EA"; $qoks=array(); $items[]="CT-EBWT-BBN"; $itemnames[]="Bamboo Worktop - Parquet Butcher Block - Natural"; $items[]="CT-EBWT-BBC"; $itemnames[]="Bamboo Worktop - Parquet Butcher Block - Caramelized"; $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 ?>

Parquet Butcher Block Worktop

An easy, quick way to add spice to your kitchen is to add a bamboo countertop or island. A hard and durable alternative to traditional butcher block delivers an intriguing and subtle parquet pattern of end-grain bamboo into modern kitchens. Furniture-grade end-grain butcher block is made with a formaldehyde-free and food-safe adhesive perfect for table tops as well as kitchen counters, islands and cutting surfaces.

Features:
 Available Finished or Unfinished
 Finished with Food Grade Mineral Oil / Bees Wax
 Formaldehyde Free Manufacture (ISO 14001-certified)
 End Grain Bamboo Parquet
 29% harder than North American Hard Maple and 45% harder than Northern Red Oak

Specifications:
 Colors: Natural, Caramelized
 Dimensions: 30" x 96" X 1-1/2" OR
     36" x 72" X 1-1/2"
     Custom sizes up to 4’ x 8’ x 3" by special order
     (minimum quantities apply)

LEED V3:
 MR 6: Rapidly Renewable Materials
 IEQ 4.4 Low-Emitting Materials - Composite Wood and Agrifiber Products

Item: $item

"); echo("

Price: Quoted

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

" . "" . "Quote Request

"); } ?>
" . "
  • Help
  • "); } ?>
    Natural
    Caramelized

    " . "" . "" . "©2012 Eco-\$mart, Inc." . "    (888) 329-2705" . "    info@eco-smart.com" . "    www.eco-smart.com" . "
    "); }else{ echo("" . "" . "
    " . "

    $mycat_link

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