';
echo 'No carriers found for this specific order. Call WoodVendors for a price quote, 1-877-983-6367. ';
echo '
';
$err = 1;
}
if (isset($lowestCarrier["warningMsg"])){
echo '
No carriers found for this specific order. Call WoodVendors for a price quote, 1-877-983-6367.
';
$err = 1;
}
if($err != 1){
echo '
';
echo 'Your Full Delivered Price is... $';
echo '
';
for($i=1; $i<=12; $i++){
echo '
';
}
echo '
';
echo 'Delivery Charge to ';
echo $dest;
echo ' = $';
if($markup){
echo ''.getFinalCost($cost->nodeValue,$markup).'';
}else{
echo ''.getFinalCost($cost->nodeValue,0).'';
}
echo ' via ';
if($carrier->nodeValue == ""){
echo ' There is a problem with this shipping calculation. Call WoodVendors for a price quote, 1-877-983-6367. ';
}else{
echo $carrier->nodeValue;
}
echo '
';
/*main mail send for admin*/
/*or*/
/*main mail send for user*/
$to = $_REQUEST['email'];
$headers = "MIME-Version: 1.0\nContent-type: text/html; charset=utf-8\nFrom: $label <$from> \n";
$bodykk = 'Thank you for your interest in '.$c_title.'.
To confirm availability give us a call at 877.983-6367
or
Email your questions to goodwood@woodvendors.com
';
$bodykk .= '
'.$data.'
';
$bodykk .= 'www.WoodVendors.com
Slabs, Lumber and Mouldings
';
/*main mail send for user end*/
/*main mail send for user mail function*/
wp_mail($to, $subject,$bodykk,$headers);
/*main mail send for user mail function end*/
/*main mail send for admin mail function*/
wp_mail($admin_to, $subject,$body,$headers);
/*main mail send for admin mail function end*/
}
}
add_action('wp_ajax_sendemail', 'send_email_callback');
add_action('wp_ajax_nopriv_sendemail', 'send_email_callback');
/*manoj send email end*/
/*manoj add 23/02 end*/
function getInfo_callback()
{
$id = $_REQUEST["id"];
$html = '';
global $wpdb;
$sql = "SELECT * FROM wp_er_ship_products WHERE id=".$id;
$row = $wpdb->get_results($sql);
$i = 1;
$html .= " ";
//set up a max of four different zip codes and descriptions. Must have both a zip code and a label.
while($i<5){
$origin = "origin_".$i;
$originLabel = "originLabel_".$i;
if($row[0]->$origin==''||$row[0]->$origin==0){
break;
}
$html .= ''. $row[0]->$originLabel;
}else{
$html .= '" />'. $row[0]->$originLabel;
}
$html .= " ";
$i++;
}
$html .= '';
$html .= '';
$html .= '';
die($html);
}
add_action('wp_ajax_nopriv_getInfo', 'getInfo_callback');
add_action('wp_ajax_getInfo', 'getInfo_callback');
function getSpecies_callback()
{
if(isset($_REQUEST['title'])){
$prodtitle = $_REQUEST['title'];
}
if(isset($_REQUEST['id'])){
$prod = $_REQUEST['id'];
}
global $wpdb;
$html = '';
switch($prod){
case '0'://freight species rate category
$list = "SELECT * FROM wp_er_ship_products WHERE catid=8 AND published=1 ORDER BY title ASC ";
break;
case '1'://freight moulding rate category
$list = "SELECT * FROM wp_er_ship_products WHERE catid=12 AND published=1 ORDER BY title ASC ";
break;
case '2'://freight dimension rate category
$list = "SELECT * FROM wp_er_ship_products WHERE catid=14 AND published=1 ORDER BY title ASC ";
break;
case '3'://freight decking rate category
$list = "SELECT * FROM wp_er_ship_products WHERE catid=13 AND published=1 ORDER BY title ASC ";
break;
default:
$list = "SELECT * FROM wp_er_ship_products WHERE published=1 ORDER BY title ASC ";
break;
}
$result = $wpdb->get_results($list);
$html .= '';
die($html);
}
add_action('wp_ajax_nopriv_getSpecies', 'getSpecies_callback');
add_action('wp_ajax_getSpecies', 'getSpecies_callback');
function getDimens_callback()
{
global $wpdb;
if(isset($_REQUEST['id'])){
$prod = $_REQUEST['id'];
}
$list = "SELECT chk_meas_group FROM wp_er_ship_products WHERE id=".$prod;
$result = $wpdb->get_results($list);
$boxes = explode(',', $result[0]->chk_meas_group);
if($result){
$i=1;
foreach($boxes as $chkbox=>$value){
echo '';
if($i==3){
echo " ";
$i = 0;
}
$i++;
}
}
}
add_action('wp_ajax_nopriv_getDimens', 'getDimens_callback');
add_action('wp_ajax_getDimens', 'getDimens_callback');
function slabSearch_callback()
{
global $wpdb;
$limit = 5;
$page_no = $_REQUEST['num'];
if($page_no)
{
$page = $page_no;
}
else{
$page = 1;
}
$start_from = ($page-1) * $limit;
$list = "SELECT * FROM wp_woodlister_slab ";
if($_REQUEST['price']!='' || $_REQUEST['length']!='' || $_REQUEST['width']!='' || $_REQUEST['thick']!='')
{
$list .= " WHERE ";
}
if($_REQUEST['price']){
$price = $_REQUEST['price'];
$prc = explode('-',$price);
$list .= " (price BETWEEN ".$prc[0]. " and ".$prc[1].") and (price != '') ";
}
if($_REQUEST['length']){
$length = $_REQUEST['length'];
$len = explode('-',$length);
if($price!='')
{
$list .= " and ";
}
$list .= " (length BETWEEN ".$len[0]. " and ".$len[1].") and (length != '') ";
}
if($_REQUEST['width']){
$width = $_REQUEST['width'];
$wid = explode('-',$width);
if($price!='' || $length!='')
{
$list .= " and ";
}
$list .= " (width BETWEEN ".$wid[0]. " and ".$wid[1].") and (width != '') ";
}
if($_REQUEST['thick']){
$thick = $_REQUEST['thick'];
$thi = explode('-',$thick);
if($price!='' || $length!='' || $width!='')
{
$list .= " and ";
}
$list .= " (thickness BETWEEN ".$thi[0]. " and ".$thi[1].") and (thickness != '') ";
}
$res = $wpdb->get_results($list);
$list .= "ORDER BY title ASC LIMIT $start_from, $limit";
$result = $wpdb->get_results($list);
$html = " ";
if($result){
foreach($result as $value){
$posttitle = $value->title;
$postid = $wpdb->get_var( "SELECT ID FROM $wpdb->posts WHERE post_title = '" . $posttitle . "'" );
$href = get_permalink($postid);
$html .= '
