Infinity Diamond Stud Ladies Bracelet

array(56) { ["pc_id"]=> string(4) "1433" ["product_id"]=> string(3) "460" ["mcat_id"]=> string(1) "2" ["jwtyp_id"]=> string(2) "38" ["variety_id"]=> string(1) "7" ["product_size"]=> string(0) "" ["product_length"]=> string(0) "" ["general_wt"]=> string(5) "7.422" ["other_stone_type"]=> string(2) "NA" ["other_stone_cost"]=> float(50) ["product_sub_total"]=> float(58320.93) ["product_cost"]=> float(60071) ["gemstone_size"]=> string(0) "" ["gemstone_certificate"]=> string(0) "" ["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(5) "7.390" ["diamond_purity"]=> string(1) "8" ["diamond_wt"]=> string(5) "0.160" ["added_by"]=> string(1) "1" ["added_on"]=> string(10) "2021-06-04" ["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(60071) ["actualGSTamt"]=> float(1749.63) ["gstAmount"]=> float(1749.63) ["gstRate"]=> float(3) ["manual_discount_amt"]=> int(0) ["actual_manual_amt"]=> int(0) ["mcRate"]=> string(17) "Rs 1200 X 7.390gm" ["mcDiscount"]=> int(0) ["actualMC"]=> int(0) ["makingCharge"]=> float(8868) ["SQL_QUE"]=> string(1476) "

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` = '38' AND `variety_id` = '7'

MC=0_wt | Wt =7.39

SELECT * FROM `making_charge_list` WHERE `mcat_id` = '1' AND `jwtyp_id` = '38' AND `variety_id` = '7' AND `mc_state` = '1' AND ('7.39' 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` = '38' AND `variety_id` = '7'

MC=0_wt | Wt =0.16

SELECT * FROM `making_charge_list` WHERE `mcat_id` = '2' AND `jwtyp_id` = '38' AND `variety_id` = '7' AND `mc_state` = '1' AND ('7.39' BETWEEN `mc_from` AND `mc_to`) ORDER BY `mc_id` DESC >> diamond_wt8868
SELECT * FROM `making_charge_list` WHERE `mcat_id` = '2' AND `jwtyp_id` = '38' AND `variety_id` = '7' AND `mc_state` = '1' AND ('7.39' BETWEEN `mc_from` AND `mc_to`) ORDER BY `mc_id` DESC
SELECT * FROM `making_charge_list` WHERE `mcat_id` = '2' AND `jwtyp_id` = '38' AND `variety_id` = '7' AND `mc_state` = '1' AND ('7.39' BETWEEN `mc_from` AND `mc_to`) ORDER BY `mc_id` DESC

silver

silver_wt =0.000

silver_purity =

" ["ERR_MSG"]=> string(0) "" ["DiscountDtls"]=> string(0) "" ["gold_rate"]=> float(4087) ["gold_amt"]=> float(30202.93) ["gold_discount_amt"]=> int(0) ["gold_discount_rate"]=> int(0) ["actual_gold_amt"]=> float(30202.93) ["diamond_rate"]=> float(120000) ["diamond_amt"]=> float(19200) ["diamond_discount_amt"]=> int(0) ["diamond_discount_rate"]=> int(0) ["actual_diamond_amt"]=> float(19200) }