$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="";
$pgbg="white";
}else{
$goprint = "";
$pgbg="#BDDEA0";
}
$back="catwe.php";
$subcat="Wind Energy";
$page_name="catwe2";//this page name w no extensions
$here=$page_name.".php";
$hereprint=$here."?print=yes";
$page="wind_energy/".$page_name;
$mycathere="wind_energy/".$page_name.".php";
$prodname="Horizontal Axis Wind Turbine System";
$dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products');
if($mycat!=""){
$mycat_link="Add to My Catalog";
}else{
$mycat_link="My Catalog";
}
$item = "WE-HAWT-*";
$items[]="WE-HAWT-ECO-300W";
$itemnames[]="300 Watt Horizontal Axis Wind Turbine System";
$items[]="WE-HAWT-ECO-500W";
$itemnames[]="500 Watt Horizontal Axis Wind Turbine System";
$items[]="WE-HAWT-ECO-1000W";
$itemnames[]="1000 Watt Horizontal Axis Wind Turbine System";
$items[]="WE-HAWT-ECO-2000W";
$itemnames[]="2000 Watt Horizontal Axis Wind Turbine System";
$items[]="WE-HAWT-ECO-3000W";
$itemnames[]="3000 Watt Horizontal Axis Wind Turbine System";
$items[]="WE-HAWT-ECO-5000W";
$itemnames[]="5000 Watt Horizontal Axis Wind Turbine System";
$items[]="WE-HAWT-ECO-10KW";
$itemnames[]="10 kW Horizontal Axis Wind Turbine System";
$items[]="WE-HAWT-ECO-20KW";
$itemnames[]="20 kW Horizontal Axis Wind Turbine System";
$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
?>
Horizontal Axis Wind Turbine System
Tubular steel independent tower, with special corrosion protection, allows tilt-up installation without a crane. Wind generator body includes: Nose Cone, Blades*3Pcs, Hub, Generator, Rotor, Tail Rod, Tail Vane; Tower & Accessories includes: Mast (Tower), Base Plate, Bolts, and Cable. Intelligent battery charging and discharging control, over charging and over discharging protection, battery capacity detection, yawing and brake control all included. Two year warranty.
if($print!='yes'){ echo("
////////////////////////////side price display
$i=0;
$countem=count($items);
while($i<$countem){
if($pay[$i]=="yes"){
echo(" Item: $items[$i] "); echo $mess[$i]; echo(""); }else{ echo("Item: $items[$i] "); echo $mess[$i]; if($print!="yes"){ echo("" . "" . "Quote Request "); } }//pay is no $i=$i+1; }//while counting items ?> |
if($print!="yes"){
echo("
|
Specifications | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
" . "" . "©2011 Eco-\$mart, Inc." . " (888) 329-2705" . " info@eco-smart.com" . " www.eco-smart.com" . " |
" .
" $mycat_link " . " << Return to $subcat" . " | ||
" . "" . "©2011 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(" |