Alluring Necklace Set

array(56) { ["pc_id"]=> string(2) "28" ["product_id"]=> string(2) "30" ["mcat_id"]=> string(1) "2" ["jwtyp_id"]=> string(1) "6" ["variety_id"]=> string(1) "5" ["product_size"]=> string(0) "" ["product_length"]=> string(0) "" ["general_wt"]=> string(6) "25.620" ["other_stone_type"]=> string(2) "NA" ["other_stone_cost"]=> string(4) "0.00" ["product_sub_total"]=> float(317900.58) ["product_cost"]=> float(327438) ["gemstone_size"]=> NULL ["gemstone_certificate"]=> NULL ["gemstone_purity"]=> NULL ["gemstone_wt"]=> string(5) "0.000" ["mohor_purity"]=> NULL ["mohor_wt"]=> string(5) "0.000" ["manual_gst_id"]=> string(1) "0" ["silver_purity"]=> NULL ["silver_wt"]=> string(5) "0.000" ["platinum_purity"]=> NULL ["platinum_wt"]=> string(5) "0.000" ["gold_purity"]=> string(1) "3" ["gold_wt"]=> string(6) "25.142" ["diamond_purity"]=> string(1) "8" ["diamond_wt"]=> string(5) "2.390" ["added_by"]=> string(1) "1" ["added_on"]=> string(10) "2020-10-09" ["crl_sql"]=> string(317) "
SELECT `catpu_id` FROM `category_rates_list` WHERE `crat_state` = '1' AND `catpu_id` IN(2,3) ORDER BY `crat_amt` DESC gold_purity = 3
SELECT `catpu_id` FROM `category_rates_list` WHERE `crat_state` = '1' AND `catpu_id` IN(7,8,6) ORDER BY `crat_amt` DESC diamond_purity = 8" ["gold_purity_arr"]=> string(3) "2,3" ["diamond_purity_arr"]=> string(5) "7,8,6" ["totalProductDiscount"]=> float(0) ["actualProductAmt"]=> float(327437.6) ["actualGSTamt"]=> float(9537.02) ["gstAmount"]=> float(9537.02) ["gstRate"]=> float(3) ["manual_discount_amt"]=> int(0) ["actual_manual_amt"]=> int(0) ["mcRate"]=> string(18) "Rs 2000 X 25.142gm" ["mcDiscount"]=> int(0) ["actualMC"]=> int(0) ["makingCharge"]=> float(50284) ["SQL_QUE"]=> string(1551) "

gold

SELECT `crat_amt` FROM `category_rates_list` WHERE `crat_state` = '1' AND `catpu_id` = '3'
SELECT `discount_rate` FROM `cat_rate_discount_list` WHERE `ctrtdsc_state` = '1' AND `mcat_id` = '1' AND `jwtyp_id` = '6' AND `variety_id` = '5'

MC=0_wt | Wt =25.142

SELECT * FROM `making_charge_list` WHERE `mcat_id` = '1' AND `jwtyp_id` = '6' AND `variety_id` = '5' AND `mc_state` = '1' AND ('25.142' BETWEEN `mc_from` AND `mc_to`) ORDER BY `mc_id` DESC >> gold_wt

diamond

SELECT `crat_amt` FROM `category_rates_list` WHERE `crat_state` = '1' AND `catpu_id` = '8'
SELECT `discount_rate` FROM `cat_rate_discount_list` WHERE `ctrtdsc_state` = '1' AND `mcat_id` = '2' AND `jwtyp_id` = '6' AND `variety_id` = '5'

MC=0_wt | Wt =2.39

SELECT * FROM `making_charge_list` WHERE `mcat_id` = '2' AND `jwtyp_id` = '6' AND `variety_id` = '5' AND `mc_state` = '1' AND ('25.142' BETWEEN `mc_from` AND `mc_to`) ORDER BY `mc_id` DESC >> diamond_wt50284
SELECT * FROM `making_charge_list` WHERE `mcat_id` = '2' AND `jwtyp_id` = '6' AND `variety_id` = '5' AND `mc_state` = '1' AND ('25.142' BETWEEN `mc_from` AND `mc_to`) ORDER BY `mc_id` DESC
SELECT * FROM `making_charge_list` WHERE `mcat_id` = '2' AND `jwtyp_id` = '6' AND `variety_id` = '5' AND `mc_state` = '1' AND ('25.142' BETWEEN `mc_from` AND `mc_to`) ORDER BY `mc_id` DESC

silver

silver_wt =0.000

silver_purity =

mohor

mohor_wt =0.000

mohor_purity =

" ["ERR_MSG"]=> string(0) "" ["DiscountDtls"]=> string(0) "" ["gold_rate"]=> float(3990) ["gold_amt"]=> float(100316.58) ["gold_discount_amt"]=> int(0) ["gold_discount_rate"]=> int(0) ["actual_gold_amt"]=> float(100316.58) ["diamond_rate"]=> float(70000) ["diamond_amt"]=> float(167300) ["diamond_discount_amt"]=> int(0) ["diamond_discount_rate"]=> int(0) ["actual_diamond_amt"]=> float(167300) }