$status=$_COOKIE['status'];
$repped=$_COOKIE['ecorep'];
$mycat=$_COOKIE['ecosmartmycat'];
$print=$_GET['print'];
$ctd=$_GET['ctd'];
if($print == "yes"){
if($ctd==""){
$goprint = "onLoad='javascript:printWindow()'";
}//if not coming from mycatalog
$status="";
$repped="";
$bgc="white";
}else{
$goprint = "";
$bgc="#bddea0";
}
$fr = $_GET['fr'];
if($fr == 'wood'){
$head = "catwoodhead.js";
}else{
$head = "catcounthead.js";
}
$subcat="Bamboo Worktops";
$back="catcount6.php";
$page_name="catcount6_2";//this page name w no extensions
$here=$page_name.".php";
$mycathere=$page_name.".php";
$hereprint=$here."?print=yes";
$page=$page_name;
$prodname="Bamboo Worktop - Traditional";
if($mycat!=""){
$mycat_link="Add to My Catalog";
}else{
$mycat_link="My Catalog";
}
$item = "CT-EBWT-TR*";
$unit="SF";
$qoks=array();
$items[]="CT-EBWT-TRN";
$itemnames[]="Bamboo Worktop - Traditional - Natural";
$items[]="CT-EBWT-TRC";
$itemnames[]="Bamboo Worktop - Traditional - 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
?>
The traditional bamboo worktop is ideal for any home or retail decor such as kitchen countertops or restaurant table tops. Extremely durable - 25% harder than red oak. The traditional bamboo face with contrasting strand bamboo core provides a beautiful visual accent to any kitchen or bathroom design or other interior application.
Features:
Available Finished or Unfinished
Finished with Food Grade Mineral Oil / Bees Wax
Formaldehyde Free Manufacture (ISO 14001-certified)
Vertical grain face with strand bamboo core
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"
LEED V3:
MR 6: Rapidly Renewable Materials
IEQ 4.4 Low-Emitting Materials - Composite Wood and Agrifiber Products
echo(" Item: $item "); echo("Price: Quoted "); if($print!="yes"){ echo("" . "" . "Quote Request "); } ?> |
if($print!="yes"){
echo("
|
" . "" . "©2012 Eco-\$mart, Inc." . " (888) 329-2705" . " info@eco-smart.com" . " www.eco-smart.com" . " |
" .
" $mycat_link " . " << Return to $subcat" . " | ||
" . "" . "©2012 Eco-\$mart, Inc." . " (888) 329-2705" . " info@eco-smart.com" . " www.eco-smart.com" . " | " . " QUOTE " . " | " . " PRINT " . " |
" .
"
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("");
foreach($air as $value){
echo(" ");
}//air is not empty
}//print is not yes
?>
$value"); }//4each echo(" |