array(50) {
["pc_id"]=>
string(2) "21"
["product_id"]=>
string(2) "21"
["mcat_id"]=>
string(1) "3"
["jwtyp_id"]=>
string(2) "20"
["variety_id"]=>
string(1) "9"
["product_size"]=>
string(0) ""
["product_length"]=>
string(0) ""
["general_wt"]=>
string(6) "10.000"
["other_stone_type"]=>
string(0) ""
["other_stone_cost"]=>
string(4) "0.00"
["product_sub_total"]=>
float(748)
["product_cost"]=>
float(771)
["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"]=>
string(2) "10"
["silver_wt"]=>
string(6) "10.000"
["platinum_purity"]=>
NULL
["platinum_wt"]=>
string(5) "0.000"
["gold_purity"]=>
NULL
["gold_wt"]=>
string(5) "0.000"
["diamond_purity"]=>
NULL
["diamond_wt"]=>
string(5) "0.000"
["added_by"]=>
string(1) "1"
["added_on"]=>
string(10) "2020-10-09"
["crl_sql"]=>
string(158) "
SELECT `catpu_id` FROM `category_rates_list` WHERE `crat_state` = '1' AND `catpu_id` IN(10) ORDER BY `crat_amt` DESC
silver_purity = 10"
["silver_purity_arr"]=>
string(2) "10"
["totalProductDiscount"]=>
float(0)
["actualProductAmt"]=>
float(770.44)
["actualGSTamt"]=>
float(22.44)
["gstAmount"]=>
float(22.44)
["gstRate"]=>
float(3)
["manual_discount_amt"]=>
int(0)
["actual_manual_amt"]=>
int(0)
["mcRate"]=>
string(3) "10%"
["mcDiscount"]=>
int(0)
["actualMC"]=>
int(0)
["makingCharge"]=>
float(68)
["SQL_QUE"]=>
string(1110) "
gold
gold_wt =0.000
gold_purity =
diamond
diamond_wt =0.000
diamond_purity =
silver
SELECT `crat_amt` FROM `category_rates_list` WHERE `crat_state` = '1' AND `catpu_id` = '10'
SELECT `discount_rate` FROM `cat_rate_discount_list` WHERE `ctrtdsc_state` = '1' AND `mcat_id` = '3' AND `jwtyp_id` = '20' AND `variety_id` = '9'
MC=0_wt | Wt =10
SELECT * FROM `making_charge_list` WHERE `mcat_id` = '3' AND `jwtyp_id` = '20' AND `variety_id` = '9' AND `mc_state` = '1' AND ('10' BETWEEN `mc_from` AND `mc_to`) ORDER BY `mc_id` DESC >> silver_wt
68 SELECT * FROM `making_charge_list` WHERE `mcat_id` = '3' AND `jwtyp_id` = '20' AND `variety_id` = '9' AND `mc_state` = '1' AND ('10' BETWEEN `mc_from` AND `mc_to`) ORDER BY `mc_id` DESC
SELECT * FROM `making_charge_list` WHERE `mcat_id` = '3' AND `jwtyp_id` = '20' AND `variety_id` = '9' AND `mc_state` = '1' AND ('10' BETWEEN `mc_from` AND `mc_to`) ORDER BY `mc_id` DESC
mohor
mohor_wt =0.000
mohor_purity =
"
["ERR_MSG"]=>
string(0) ""
["DiscountDtls"]=>
string(0) ""
["silver_rate"]=>
float(68)
["silver_amt"]=>
float(680)
["silver_discount_amt"]=>
int(0)
["silver_discount_rate"]=>
int(0)
["actual_silver_amt"]=>
float(680)
}