Quote Price Calculator

Click Here to see price
Array
(
    [loading_calculator] => 1
    [product_id] => 5985
    [price_defining_method] => 1
    [selected_size_id] => 
    [product_weight] => 
    [selected_quantity] => 
    [product_price] => 
    [options_total_price] => 
    [shipping_method] => 
    [selected_country] => 13
    [selected_ship_type] => 
    [selected_ship_price] => 
    [product_total_price] => 
    [selected_options] => 
    [hire_designer] => 0
    [products_wholesale_price] => 
    [shipqty] => 
    [predefined_product_type] => 0
)
RDataRecordSet Object
(
    [ResultData:RDataRecordSet:private] => PDOStatement Object
        (
            [queryString] => SELECT products.products_id, products.size_visible, products_sizes.*, product_price.price, product_price.product_price_id, vendor_price.vendor_price,vendor_price.vendor_color_price,vendor_price.vendor_price_extra_page, product_price.price AS products_wholesale_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.store_price, (product_price.price + ((product_price.price * :STORE_FLAT_MARKUP)/100))) as price,product_price.color_page_price AS products_wholesale_color_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.color_store_price, (product_price.color_page_price + ((product_price.color_page_price * :STORE_FLAT_MARKUP_1_0)/100))) as color_page_price FROM products LEFT JOIN `product_price` ON `product_price`.`products_id` = `products`.`products_id` AND `product_price`.`visible` = :product_price_visible   AND (`product_price`.`user_type_id` = :product_price_user_type_id_else) LEFT JOIN vendor_price ON vendor_price.price_id = product_price.product_price_id AND vendor_price.price_type='P' LEFT JOIN product_price_markup ON product_price.product_price_id = product_price_markup.product_price_id AND product_price_markup.store_id = :store_id RIGHT JOIN `products_sizes` ON `products_sizes`.`products_id` = `products`.`products_id` AND `products_sizes`.`size_id` = `product_price`.`size_id` AND `products_sizes`.`site_language_id` = :site_lang_id_right_join AND `products_sizes`.`visible`='1'  LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE `products`.`products_id` IN (:input_0) AND IF ( `products`.`price_defining_method` IN ('1', '2', '3'), `product_price`.`qty_to` != :product_price_qty, 1) AND products.predefined_product_type IN (:input_1, :input_2) AND store_products.store_id = :sp_store_id GROUP BY `products`.`products_id`, `products_sizes`.`size_id` ORDER BY `products_sizes`.`sort_order` ASC, `product_price`.`corporate_id` DESC, `products`.`sort_order` ASC, `product_price`.`products_id` ASC, `product_price`.`qty` ASC 
        )

    [AffectedRows:RDataRecordSet:private] => 1
    [RecordCount] => 1
    [foundRows] => -1
    [RecordList:RDataRecordSet:private] => Array
        (
            [0] => RDataRecord Object
                (
                    [_Data:protected] => Array
                        (
                            [products_id] => 5985
                            [size_visible] => Yes
                            [auto_id] => 14990
                            [size_id] => 15936
                            [ibs_size_identifier] => 
                            [size_title] => One size fits all
                            [size_image] => 
                            [size_width] => 0.03937008
                            [size_height] => 0.03937008
                            [size_width_original] => 1
                            [size_height_original] => 1
                            [size_unit] => MM
                            [default_size] => 1
                            [sort_order] => 1
                            [visible] => 1
                            [weight] => 
                            [no_of_folding] => 0
                            [orientation] => 
                            [jobs_per_sheet] => 1
                            [site_language_id] => 1
                            [cover_width] => 
                            [cover_height] => 
                            [cover_width_original] => 
                            [cover_height_original] => 
                            [price] => 1.36
                            [product_price_id] => 200876
                            [vendor_price] => 0.68
                            [vendor_color_price] => 
                            [vendor_price_extra_page] => 
                            [products_wholesale_price] => 1.36
                            [products_wholesale_color_price] => 0
                            [color_page_price] => 0
                        )

                    [_IteratorKeys:protected] => Array
                        (
                            [0] => products_id
                            [1] => size_visible
                            [2] => auto_id
                            [3] => size_id
                            [4] => ibs_size_identifier
                            [5] => size_title
                            [6] => size_image
                            [7] => size_width
                            [8] => size_height
                            [9] => size_width_original
                            [10] => size_height_original
                            [11] => size_unit
                            [12] => default_size
                            [13] => sort_order
                            [14] => visible
                            [15] => weight
                            [16] => no_of_folding
                            [17] => orientation
                            [18] => jobs_per_sheet
                            [19] => site_language_id
                            [20] => cover_width
                            [21] => cover_height
                            [22] => cover_width_original
                            [23] => cover_height_original
                            [24] => price
                            [25] => product_price_id
                            [26] => vendor_price
                            [27] => vendor_color_price
                            [28] => vendor_price_extra_page
                            [29] => products_wholesale_price
                            [30] => products_wholesale_color_price
                            [31] => color_page_price
                        )

                )

        )

    [IteratorCount:RDataRecordSet:private] => 0
    [last_query] => SELECT products.products_id, products.size_visible, products_sizes.*, product_price.price, product_price.product_price_id, vendor_price.vendor_price,vendor_price.vendor_color_price,vendor_price.vendor_price_extra_page, product_price.price AS products_wholesale_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.store_price, (product_price.price + ((product_price.price * 0)/100))) as price,product_price.color_page_price AS products_wholesale_color_price, IF(product_price_markup.product_price_id IS NOT NULL, product_price_markup.color_store_price, (product_price.color_page_price + ((product_price.color_page_price * 0)/100))) as color_page_price FROM products LEFT JOIN `product_price` ON `product_price`.`products_id` = `products`.`products_id` AND `product_price`.`visible` = '1'   AND (`product_price`.`user_type_id` = '1') LEFT JOIN vendor_price ON vendor_price.price_id = product_price.product_price_id AND vendor_price.price_type='P' LEFT JOIN product_price_markup ON product_price.product_price_id = product_price_markup.product_price_id AND product_price_markup.store_id = 138 RIGHT JOIN `products_sizes` ON `products_sizes`.`products_id` = `products`.`products_id` AND `products_sizes`.`size_id` = `product_price`.`size_id` AND `products_sizes`.`site_language_id` = 1 AND `products_sizes`.`visible`='1'  LEFT JOIN store_products ON store_products.products_id = products.products_id WHERE `products`.`products_id` IN (5985) AND IF ( `products`.`price_defining_method` IN ('1', '2', '3'), `product_price`.`qty_to` != 0, 1) AND products.predefined_product_type IN ('0', '1') AND store_products.store_id = 138 GROUP BY `products`.`products_id`, `products_sizes`.`size_id` ORDER BY `products_sizes`.`sort_order` ASC, `product_price`.`corporate_id` DESC, `products`.`sort_order` ASC, `product_price`.`products_id` ASC, `product_price`.`qty` ASC 
)