post_type && post_type_supports($post->post_type, 'page-attributes') ) { add_meta_box( 'custompageparentdiv', __('Template'), 'custom_page_attributes_meta_box', NULL, 'side', 'core'); } } function custom_page_attributes_meta_box($post) { $template = get_post_meta( $post->ID, '_wp_page_template', 1 ); ?> admin_url( 'admin-ajax.php' ) ) ); } function getQuantities($id){ global $wpdb; $tmpArray = array(); if($id != 0 ) { $query = "SELECT * FROM wp_woodlister_products WHERE id = '".$id."'"; $prod = $wpdb->get_results( $query); $i = 1; for($i=1; $i<=10; $i++){ $breakd_ = 'breakd_'.$i; if($prod[0]->$breakd_ == 1){ $opt = 'brkd_opt_'.$i; $query = "SELECT size_label FROM wp_woodlister_wood_ship_breakdown WHERE id = '".$prod[0]->$opt."'"; $result = $wpdb->get_row( $query); array_push($tmpArray, $result->size_label); } } return $tmpArray; } return; } function getVariations($id){ global $wpdb; $query = "SELECT * FROM wp_woodlister_product_variations WHERE avail_enable='1' AND prod_id = '".$id."' ORDER BY ordering"; $data = $wpdb->get_results( $query); $data = getPriceList($data, $id); return $data; } function getPriceList($variations, $id){ $i = 0; foreach($variations as $item){ if($item->breakd_1 == 1 && $item->price_algor_1!='none'){ $variations[$i]->price_1 = calcPrice($item->id, $item->price_algor_1, $id); }else{ $variations[$i]->price_1 = 0; } if($item->breakd_2 == 1 && $item->price_algor_2!='none'){ $variations[$i]->price_2 = calcPrice($item->id, $item->price_algor_2, $id); }else{ $variations[$i]->price_2 = 0; } if($item->breakd_3 == 1 && $item->price_algor_3!='none'){ $variations[$i]->price_3 = calcPrice($item->id, $item->price_algor_3, $id); }else{ $variations[$i]->price_3 = 0; } if($item->breakd_4 == 1 && $item->price_algor_4!='none'){ $variations[$i]->price_4 = calcPrice($item->id, $item->price_algor_4, $id); }else{ $variations[$i]->price_4 = 0; } $i++; } return $variations; } function calcPrice($prod_id, $algor_id, $parentid){ global $wpdb; $query = "SELECT * FROM wp_woodlister_markup_algorithms WHERE published='1' AND id = '".$algor_id."'"; $algorithm = $wpdb->get_results( $query); $perc_add = 0; $perc_subtr = 0; $amt_add = 0; $amt_subtr = 0; if($algorithm[0]->perc_add > 0){ $perc_add = $algorithm[0]->perc_add; } if($algorithm[0]->perc_subtr > 0){ $perc_subtr = $algorithm[0]->perc_subtr; } if($algorithm[0]->amt_add > 0){ $amt_add = $algorithm[0]->amt_add; } if($algorithm[0]->amt_subtr > 0){ $amt_subtr = $algorithm[0]->amt_subtr; } $query = "SELECT * FROM wp_woodlister_product_variations WHERE avail_enable='1' AND id = '".$prod_id."' ORDER BY id DESC limit 0,1"; $variation = $wpdb->get_results( $query); $query = "SELECT * FROM wp_woodlister_price_logs WHERE published='1' AND prod_id = '".$prod_id."' ORDER BY id DESC limit 0,1"; $log = $wpdb->get_results( $query); $query = "SELECT roundup FROM wp_woodlister_settings ORDER BY id DESC limit 1"; $roundup = $wpdb->get_results( $query); if($log != '' && $variation[0]->base_price==0){ $cur_price = $log[0]->price; }else if($variation[0]->base_price!=0){ $cur_price = $variation[0]->base_price; }else{ $cur_price = 0; } $calc_price = 0; if($perc_add > 0){ $perc = $perc_add/100; if($amt_add > 0){ $calc_price = $cur_price + ($perc * $cur_price) + $amt_add; }else{ $calc_price = $cur_price + ($perc * $cur_price) - $amt_subtr; } }else if($perc_subtr > 0){ $perc = $perc_subtr/100; if($amt_add > 0){ $calc_price = ($cur_price - ($perc * $cur_price)) + $amt_add; }else{ $calc_price = ($cur_price - ($perc * $cur_price)) - $amt_subtr; } }else if($perc_add == 0 && $perc_subtr == 0){ if($amt_add > 0){ $calc_price = $cur_price + $amt_add; }else if($amt_subtr > 0){ $calc_price = $cur_price - $amt_subtr; }else{ $calc_price = $cur_price; } } //roundup to nearest nickel if($roundup[0]->roundup == 1){ $x = 100 / 5; $calc_price = number_format(round($calc_price * $x) / $x, 2); } return $calc_price; } function getProductCat($id){ global $wpdb; $q = "SELECT cat_1 FROM wp_woodlister_product_cats WHERE prod_id = '".$id."'"; $data = $wpdb->get_results( $q); $q = "SELECT name FROM wp_k2_categories WHERE id = '".$data[0]->cat_1 ."'"; $data = $wpdb->get_results( $q); return $data[0]->name ; } function getRate($userid, $password, $classof, $specificWeight) { global $query; $query = ' %1s %2s %3$s %4$s %3$s 12 22 %5$s %6$s '.date("Y-m-d").' Third Party 0 false false '; if ($_POST){ $skip = $_POST['skip']; if($skip != 1){ if($_POST['dimen']){ $bf = $_POST['bf']; $dimen = $_POST['dimen']; $bf = convertToBf($dimen, $bf); }else{ $bf = $_POST['bf']; } }else{ $bf = $_POST['bf']; } $destination = $_POST['destination']; $origin = $_POST['origin']; $specificWeight = $_POST['specificWeight']; $classof = $_POST['classof']; $markup = $_POST['markup']; }else{ return; } $weight=$bf*$specificWeight; $formattedQuery = sprintf($query, $userid, $password, $weight, $classof, $origin, $destination); $ch = curl_init (); curl_setopt ($ch, CURLOPT_URL, "http://services.echo.com/Quote.asmx"); curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt ($ch, CURLOPT_TIMEOUT, 20); curl_setopt ($ch, CURLOPT_HEADER, 1); curl_setopt ($ch, CURLOPT_POST, 1); curl_setopt ($ch, CURLOPT_POSTFIELDS,$formattedQuery); $header = array(); $header[] = "Content-Type: text/xml"; $header[] = 'SOAPAction: "http://www.echo.com/GetQuote"'; $header[] = "User-Agent: windows"; $header[] = "Host: services.echo.com"; $header[] = "Content-Length: ".strlen($formattedQuery); $header[] = "Connection: close"; curl_setopt ($ch, CURLOPT_HTTPHEADER, $header); $result = curl_exec ($ch); $header_size = curl_getinfo($ch,CURLINFO_HEADER_SIZE); $xml = substr($result, $header_size ); curl_close($ch); return $xml; } function convertToBf($str, $amt){ $q = "SELECT conversion FROM wp_er_ship_dimen_vals WHERE dimension = '".$str."'"; $conv =$wpdb->get_results( $q); $new_bf = number_format($conv[0]->conversion, 2, '.', '')*$amt; return $new_bf; } function getLowestCost($rateXML){ $xmlString = str_replace('xmlns="http://www.echo.com/"', '', $rateXML); $domObj = new DOMDocument(); $domObj->loadXML($xmlString); $xPath = new DOMXPath($domObj); $retValues = array(); $carrier = $xPath->query('//RateDetail[not(Charges/TotalCharge <= preceding-sibling::RateDetail/Charges/TotalCharge)and not(Charges/TotalCharge <= following-sibling::RateDetail/Charges/TotalCharge)]/Carrier/CarrierName'); $charge = $xPath->query('//RateDetail[not(Charges/TotalCharge <= preceding-sibling::RateDetail/Charges/TotalCharge)and not(Charges/TotalCharge <= following-sibling::RateDetail/Charges/TotalCharge)]/Charges/TotalCharge'); $errorMsgs=$xPath->query('//Messages/Errors'); $errorMsgNode=$errorMsgs->item( 0 ); if(isset($errorMsgNode->firstChild)){ $errorMsg=$errorMsgNode->firstChild->nodeValue; if(isset($errorMsg)){ $retValues["errorMsg"]=$errorMsg; } } $warningMsgs=$xPath->query('//Messages/Warnings'); $warningMsgNode=$warningMsgs->item( 0 ); if(isset($warningMsgNode->firstChild)){ $warningMsg=$warningMsgNode->firstChild->nodeValue; if(isset($warningMsg)){ $retValues["warningMsg"]=$warningMsg; } } $retValues["carrier"] = $carrier; $retValues["cost"] = $charge; return $retValues; } function getFinalCost($cost, $markup){ $markupValue=$markup; if (is_numeric($markupValue)){ $cost+=$markupValue; } return number_format ( $cost, 2 ); } function calcSubtotal_callback() { if(isset($_REQUEST['title'])){ $prodtitle = $_REQUEST['title']; } if(isset($_REQUEST['id'])){ $id = $_REQUEST['id']; } if(isset($_REQUEST['need'])){ $need = $_REQUEST['need']; } if(isset($_REQUEST['pr1'])){ $p1 = $_REQUEST['pr1']; } if(isset($_REQUEST['pr2'])){ $p2 = $_REQUEST['pr2']; } if(isset($_REQUEST['pr3'])){ $p3 = $_REQUEST['pr3']; } if(isset($_REQUEST['pr4'])){ $p4 = $_REQUEST['pr4']; } if(isset($_REQUEST['pr5'])){ $p5 = $_REQUEST['pr5']; } $brk_1 = 0; $brk_2 = 0; $brk_3 = 0; $brk_4 = 0; $brk_5 = 0; $subtot = 0; global $wpdb; $q = "SELECT * FROM wp_woodlister_products WHERE id=".$id; $row = $wpdb->get_results( $q); $brk_1 = $row[0]->brkd_opt_1; $brk_2 = $row[0]->brkd_opt_2; $brk_3 = $row[0]->brkd_opt_3; $brk_4 = $row[0]->brkd_opt_4; $brk_5 = $row[0]->brkd_opt_5; $q = "SELECT * FROM wp_woodlister_wood_ship_breakdown"; $result = $wpdb->get_results( $q); foreach($result as $row) { if($brk_1 == $row->id){ $min_1 = $row->min_size; $max_1 = $row->max_size; } if($brk_2 == $row->id){ $min_2 = $row->min_size; $max_2 = $row->max_size; } if($brk_3 == $row->id){ $min_3 = $row->min_size; $max_3 = $row->max_size; } if($brk_4 == $row->id){ $min_4 = $row->min_size; $max_4 = $row->max_size; } if($brk_5 == $row->id){ $min_5 = $row->min_size; $max_5 = $row->max_size; } } switch($need){ case ($need < $min_1): $subtot = 0; break; case ($need >= $min_1 && $need < $min_2): case ($need >= $min_1 && $min_2==0): $subtot = $p1*$need; break; case ($need >= $min_2 && $need < $min_3): case ($need >= $min_2 && $min_3==0): $subtot = $p2*$need; break; case ($need >= $min_3 && $need < $min_4): case ($need >= $min_3 && $min_4==0): $subtot = $p3*$need; break; case ($need >= $min_4 && $need < $min_5): case ($need >= $min_4 && $min_5==0): $subtot = $p4*$need; break; case ($need >= $min_5): $subtot = $p5*$need; break; } echo number_format($subtot, 2, '.', ''); return; } add_action('wp_ajax_nopriv_calcSubtotal', 'calcSubtotal_callback'); add_action('wp_ajax_calcSubtotal', 'calcSubtotal_callback'); function convertMeas_callback() { if($_POST){ $val = $_REQUEST['val']; $desc = $_REQUEST['desc']; } $parts = explode(" ", $desc); global $wpdb; $list = "SELECT * FROM wp_er_ship_dimen_vals "; $result = $wpdb->get_results($list); $convers_num = 1; foreach($result as $row) { $id = $row->id; $dimen = $row->dimension; $conv = $row->conversion; foreach($parts as $a=>$txt){ if($txt === $dimen){ $convers_num = $conv; } } } $newMeas = $convers_num*$val; echo $newMeas; die(); } add_action('wp_ajax_nopriv_convertMeas', 'convertMeas_callback'); add_action('wp_ajax_convertMeas', 'convertMeas_callback'); function quoteShipping_callback() { if ($_POST){ $userid = $_REQUEST['userid']; $password = $_REQUEST['password']; $classof = $_REQUEST['classof']; $specificWeight = $_REQUEST['specificWeight']; $origin = $_REQUEST['origin']; $dest = $_REQUEST['dest']; $markup = $_REQUEST['markup']; //$productid = $_REQUEST['product']; $raterXML = getRate($userid, $password, $classof, $specificWeight); $lowestCarrier = getLowestCost($raterXML); echo '

'; $carrier = $lowestCarrier['carrier']->item(0); $cost = $lowestCarrier['cost']->item(0); $err = 0; echo ''; if (isset($lowestCarrier["errorMsg"])){ //echo '
' .'Error: ' . $lowestCarrier["errorMsg"] . '
'; 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 ''; for($i=1; $i<=12; $i++){ echo ''; } echo ''; $imageUrl = get_stylesheet_directory_uri(); echo ''; } echo '

'; echo 'No carriers found for this specific order. Call WoodVendors for a price quote, 1-877-983-6367. '; echo '
'; echo 'Your Full Delivered Price is... $'; 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 '
Questions? Call us 877.983.6367		Residential Deliveries add $100

'; echo '

'; } die(); } add_action('wp_ajax_nopriv_quoteShipping', 'quoteShipping_callback'); add_action('wp_ajax_quoteShipping', 'quoteShipping_callback'); 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 ''.$value.''; if($i==3){ echo "
"; $i = 0; } $i++; } } } add_action('wp_ajax_nopriv_getDimens', 'getDimens_callback'); add_action('wp_ajax_getDimens', 'getDimens_callback'); ?>