Thanks a ton for your swift response sir , here is my script , this script works like a charm expect for the fact that I need to delete the first row and add things in the second row ,
frappe.ui.form.on("BOM", {
item: function(frm) {
frappe.call({
"method": "frappe.client.get_value",
"args": {
"doctype": "Item",
"filters": {"item_code": cur_frm.doc.item},
"fieldname": ["percnt_carbon_min","percnt_nik_min","percnt_man_min","percnt_chro_min","percnt_sil_min","percnt_moly_min","percnt_sul_min","percnt_van_min","percnt_phos_min","percnt_cob_min","percnt_cop_min","percnt_nit_min","percnt_carbon_max","percnt_nik_max","percnt_man_max","percnt_chro_max","percnt_sil_max","percnt_moly_max","percnt_sul_max","percnt_van_max","percnt_phos_max","percnt_cob_max","percnt_cop_max","percnt_nit_max"]
},
callback: function(r) {
cur_frm.set_query("item_code", "items", function(doc, cdt, cdn){
return {
"filters": {
"percnt_carbon_min": [">=",r.message.percnt_carbon_min],
"percnt_carbon_max": ["<=",r.message.percnt_carbon_max],
"percnt_nit_min": [">=",r.message.percnt_nit_min],
"percnt_nit_max": ["<=",r.message.percnt_nit_max],
"percnt_man_min": [">=",r.message.percnt_man_min],
"percnt_man_max": ["<=",r.message.percnt_man_max],
"percnt_chro_min": [">=",r.message.percnt_chro_min],
"percnt_chro_max": ["<=",r.message.percnt_chro_max],
"percnt_sil_min": [">=",r.message.percnt_sil_min],
"percnt_sil_max": ["<=",r.message.percnt_sil_max],
"percnt_moly_min": [">=",r.message.percnt_moly_min],
"percnt_moly_max": ["<=",r.message.percnt_moly_max],
"percnt_sul_min": [">=",r.message.percnt_sul_min],
"percnt_sul_max": ["<=",r.message.percnt_sul_max],
"percnt_van_min": [">=",r.message.percnt_van_min],
"percnt_van_max": ["<=",r.message.percnt_van_max],
"percnt_phos_min": [">=",r.message.percnt_phos_min],
"percnt_phos_max": ["<=",r.message.percnt_phos_max],
"percnt_cob_min": [">=",r.message.percnt_cob_min],
"percnt_cob_max": ["<=",r.message.percnt_cob_max],
"percnt_cop_min": [">=",r.message.percnt_cop_min],
"percnt_cop_max": ["<=",r.message.percnt_cop_max],
"percnt_nit_min": [">=",r.message.percnt_nit_min],
"percnt_nit_max": ["<=",r.message.percnt_nit_max],
"item_group": "Raw Material"
}
}
});
}
});
}
});
Please help me.
Thanks in advance