';
echo 'No image selected.
';
echo '';
get_footer();
exit;
}
$sql_image = "select * from wp_woodlister_slab_images where wp_woodlister_slab_images.slider_title = '" . woodvendors_slug_decode($parent_slug) . "' order by slider_sortId";
$slabResult = $wpdb->get_row($sql_image);
$id = get_query_var('image_id');
if (empty($id)) {
echo '';
echo '
No image selected.
';
echo '';
get_footer();
exit;
}
$sql = "SELECT *
FROM wp_posts
WHERE post_title = '" . woodvendors_slug_decode($id) . "'";
$results = $wpdb->get_results($sql);
// echo "";
// print_r($slabResult);
// echo "
";
if (count($results) != 1) {
echo '';
if (count($results) == 0) {
echo '
No matching image found.
';
} else {
echo 'Multiple images found with same slug.
';
}
echo '';
get_footer();
exit;
}
$attachment = $results[0];
$image_id = $attachment->ID;
$url = wp_get_attachment_image_src($image_id, 'large');
$src = $url[0];
$image_title = $attachment->post_title;
$description = $attachment->post_content;
$slab_no = get_post_meta($image_id, 'slab_no', true);
$price = get_post_meta($image_id, 'price', true);
$min_width = get_post_meta($image_id, 'min_width', true);
$max_width = get_post_meta($image_id, 'max_width', true);
$length = get_post_meta($image_id, 'length', true);
$area_sf = get_post_meta($image_id, 'area_sf', true);
$margin = get_post_meta($image_id, 'margin', true);
// echo "";
// print_r([
// 'slab_no' => $slab_no,
// 'price' => $price,
// 'min_width' => $min_width,
// 'max_width' => $max_width,
// 'length' => $length,
// 'area_sf' => $area_sf,
// 'margin' => $margin,
// ]);
// echo "
";
?>
0 && $max_width_inch > 0) {
// $width_inch = ($min_width_inch + $max_width_inch) / 2;
// } elseif ($min_width_inch > 0) {
// $width_inch = $min_width_inch;
// } elseif ($max_width_inch > 0) {
// $width_inch = $max_width_inch;
// } else {
// $width_inch = 0;
// }
// if ($length_inch <= 0 || $width_inch <= 0 || $slab_price <= 0) {
if ($area_sf <= 0 || $slab_price <= 0) {
echo '';
echo '
Calculator data missing.
';
// echo '
Please make sure Length, Width and Price are added.
';
echo '
Please make sure Area (SF) and Price are added.
';
echo '
';
echo '
Pricing data not found.
';
echo '';
get_footer();
exit;
}
// print_r($price_row);
$options = [
'single' => [
[
'id' => 'surface',
'label' => 'Surface',
'title' => 'Surface both faces flat to 100 grit',
'sf_rate' => $price_row->surface_rate,
'flat_rate' => $price_row->surface_flat,
'default' => true,
'force_enable' => false
],
[
'id' => 'epoxy',
'label' => 'Epoxy',
'title' => 'Epoxy fill minor checks on top face',
'sf_rate' => $price_row->epoxy_rate,
'flat_rate' => $price_row->epoxy_flat,
'default' => true,
'force_enable' => false
],
[
'id' => 'finish_sand',
'label' => 'Finish Sand',
'title' => 'Sand top face to 220 grit and reverse face to 150 grit',
'sf_rate' => $price_row->finish_sand_rate,
'flat_rate' => $price_row->finish_sand_flat,
'default' => true,
'force_enable' => false
],
[
'id' => 'coating',
'label' => 'Finished Tabletop',
'title' => 'Finish with 3 coats conversion varnish or hand rubbed oil',
'sf_rate' => $price_row->coating_rate,
'flat_rate' => $price_row->coating_flat,
'default' => true,
'force_enable' => false
],
// [
// 'id' => 'table_base',
// 'label' => 'Table Base',
// 'title' => 'Add standard Table Base',
// 'sf_rate' => $price_row->table_base_rate,
// 'flat_rate' => $price_row->table_base_flat,
// 'default' => true,
// 'force_enable' => false
// ]
],
'bookmatch' => [
[
'id' => 'surface',
'label' => 'Surface',
'title' => 'Surface both slabs, both faces flat to 100 grit',
'sf_rate' => $price_row->surface_rate,
'flat_rate' => $price_row->surface_flat,
'default' => true,
'force_enable' => false
],
[
'id' => 'join_slabs',
'label' => 'Join Slabs',
'title' => 'Join slabs as book-match using Festool dominos',
'sf_rate' => $price_row->join_slabs_rate,
'flat_rate' => $price_row->join_slabs_flat,
'default' => true,
'force_enable' => false
],
[
'id' => 'epoxy',
'label' => 'Epoxy',
'title' => 'Fill minor checks with epoxy',
'sf_rate' => $price_row->epoxy_rate,
'flat_rate' => $price_row->epoxy_flat,
'default' => true,
'force_enable' => false
],
[
'id' => 'finish_sand',
'label' => 'Finish Sand',
'title' => 'Sand book-matched top to 220 grit',
'sf_rate' => $price_row->finish_sand_rate,
'flat_rate' => $price_row->finish_sand_flat,
'default' => true,
'force_enable' => false
],
[
'id' => 'coating',
'label' => 'Finished Tabletop',
'title' => 'Finish with 3 coats conversion varnish or hand rubbed oil',
'sf_rate' => $price_row->coating_rate,
'flat_rate' => $price_row->coating_flat,
'default' => true,
'force_enable' => false
],
// [
// 'id' => 'table_base',
// 'label' => 'Table Base',
// 'title' => 'Add standard Table Base',
// 'sf_rate' => $price_row->table_base_rate,
// 'flat_rate' => $price_row->table_base_flat,
// 'default' => true,
// 'force_enable' => false
// ]
]
];
$current_options = $is_bookmatch
? $options['bookmatch']
: $options['single'];
$calculated_options = [];
// margin
$margin = ($margin !== '' && $margin !== null)
? floatval($margin)
: floatval($price_row->default_margin_percentage);
foreach ($current_options as $option) {
$sf_rate = !empty($option['sf_rate'])
? floatval($option['sf_rate'])
: 0;
$flat_rate = !empty($option['flat_rate'])
? floatval($option['flat_rate'])
: 0;
/*
| IMPORTANT
|
| Margin ONLY on SF RATE
| Flat rate added AFTER margin calculation
*/
$sf_rate_with_margin =
$sf_rate + (($sf_rate * $margin) / 100);
// SF calculation
$sf_total =
$sf_rate_with_margin * $square_feet;
// Final total
$total =
$sf_total + $flat_rate;
$total = round($total, 2);
$option['sf_rate_with_margin'] = $sf_rate_with_margin;
$option['sf_total'] = round($sf_total, 2);
$option['flat_total'] = round($flat_rate, 2);
$option['total'] = $total;
$calculated_options[] = $option;
}
?>
|
|
|
$
|
|
Optional Millwork Pricing
|
|
|
add $
|
|
|
|
|
Total $0
|
|
Total
|
$0
|