blob: 8478e20d692b62ac65d4f3932082983743c0081c [file] [log] [blame]
Anand Doshi885e0742015-03-03 14:55:30 +05301// Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
Rushabh Mehtae67d1fb2013-08-05 14:59:54 +05302// License: GNU General Public License v3. See license.txt
Rushabh Mehta793ba6b2014-02-14 15:47:51 +05303frappe.provide("erpnext");
Nabin Haitb072c742014-12-16 12:49:13 +05304frappe.provide("erpnext.utils");
rohitwaghchaure0da19a42024-03-12 12:27:21 +05305frappe.provide("erpnext.stock.utils");
Anand Doshie65e6212012-11-19 15:43:18 +05306
Anand Doshibdee6e02013-07-09 13:03:39 +05307$.extend(erpnext, {
Ankush Menatec74a5e2024-03-10 19:45:40 +05308 get_currency: function (company) {
9 if (!company && cur_frm) company = cur_frm.doc.company;
10 if (company)
ruthra kumarfa2d33c2023-12-12 15:43:39 +053011 return frappe.get_doc(":Company", company)?.default_currency || frappe.boot.sysdefaults.currency;
Ankush Menatec74a5e2024-03-10 19:45:40 +053012 else return frappe.boot.sysdefaults.currency;
Anand Doshibdee6e02013-07-09 13:03:39 +053013 },
Rushabh Mehtac38fc712014-04-16 17:21:25 +053014
tundebabzyc8978252018-02-12 10:34:50 +010015 get_presentation_currency_list: () => {
16 const docs = frappe.boot.docs;
Ankush Menatec74a5e2024-03-10 19:45:40 +053017 let currency_list = docs.filter((d) => d.doctype === ":Currency").map((d) => d.name);
Zarrare25dcd22018-06-21 10:53:12 +053018 currency_list.unshift("");
tundebabzyc8978252018-02-12 10:34:50 +010019 return currency_list;
20 },
21
Ankush Menatec74a5e2024-03-10 19:45:40 +053022 toggle_naming_series: function () {
23 if (cur_frm && cur_frm.fields_dict.naming_series) {
24 cur_frm.toggle_display("naming_series", cur_frm.doc.__islocal ? true : false);
Anand Doshibdee6e02013-07-09 13:03:39 +053025 }
26 },
Rushabh Mehtac38fc712014-04-16 17:21:25 +053027
Ankush Menatec74a5e2024-03-10 19:45:40 +053028 hide_company: function (frm) {
29 if (frm?.fields_dict.company) {
Rushabh Mehta89418412013-10-07 18:22:29 +053030 var companies = Object.keys(locals[":Company"] || {});
Ankush Menatec74a5e2024-03-10 19:45:40 +053031 if (companies.length === 1) {
32 if (!frm.doc.company) frm.set_value("company", companies[0]);
Gursheen Anandceeb8fc2024-02-27 13:05:29 +053033 frm.toggle_display("company", false);
Ankush Menatec74a5e2024-03-10 19:45:40 +053034 } else if (erpnext.last_selected_company) {
35 if (!frm.doc.company) frm.set_value("company", erpnext.last_selected_company);
Anand Doshibdee6e02013-07-09 13:03:39 +053036 }
37 }
Anand Doshi1ffc5b52013-07-15 18:09:43 +053038 },
Rushabh Mehtac38fc712014-04-16 17:21:25 +053039
Ankush Menatec74a5e2024-03-10 19:45:40 +053040 is_perpetual_inventory_enabled: function (company) {
41 if (company) {
Rohit Waghchaure44ed52c2024-02-24 15:33:59 +053042 let company_local = locals[":Company"] && locals[":Company"][company];
Ankush Menatec74a5e2024-03-10 19:45:40 +053043 if (company_local) {
Rohit Waghchaure44ed52c2024-02-24 15:33:59 +053044 return cint(company_local.enable_perpetual_inventory);
45 }
Rohit Waghchauree9ff1912017-06-19 12:54:59 +053046 }
47 },
48
Makarand Bauskare6712c12017-10-25 12:17:40 +053049 stale_rate_allowed: () => {
rohitwaghchaure7677ff02017-11-02 18:12:14 +053050 return cint(frappe.boot.sysdefaults.allow_stale);
Makarand Bauskare6712c12017-10-25 12:17:40 +053051 },
52
Ankush Menatec74a5e2024-03-10 19:45:40 +053053 setup_serial_or_batch_no: function () {
Alanc6dc9ea2021-05-07 20:30:04 +053054 let grid_row = cur_frm.open_grid_row();
Ankush Menatec74a5e2024-03-10 19:45:40 +053055 if (
56 !grid_row ||
57 !grid_row.grid_form.fields_dict.serial_no ||
58 grid_row.grid_form.fields_dict.serial_no.get_status() !== "Write"
59 )
60 return;
Rushabh Mehtac38fc712014-04-16 17:21:25 +053061
Ankush Menatec74a5e2024-03-10 19:45:40 +053062 frappe.model.get_value(
63 "Item",
64 { name: grid_row.doc.item_code },
65 ["has_serial_no", "has_batch_no"],
66 ({ has_serial_no, has_batch_no }) => {
67 Object.assign(grid_row.doc, { has_serial_no, has_batch_no });
Rushabh Mehtac38fc712014-04-16 17:21:25 +053068
Alanc6dc9ea2021-05-07 20:30:04 +053069 if (has_serial_no) {
Ankush Menatec74a5e2024-03-10 19:45:40 +053070 attach_selector_button(
71 __("Add Serial No"),
72 grid_row.grid_form.fields_dict.serial_no.$wrapper,
73 this,
74 grid_row
75 );
Alanc6dc9ea2021-05-07 20:30:04 +053076 } else if (has_batch_no) {
Ankush Menatec74a5e2024-03-10 19:45:40 +053077 attach_selector_button(
78 __("Pick Batch No"),
79 grid_row.grid_form.fields_dict.batch_no.$wrapper,
80 this,
81 grid_row
82 );
Marica29a2e162019-11-12 14:43:41 +053083 }
Alanc6dc9ea2021-05-07 20:30:04 +053084 }
85 );
deepeshgarg007e64c3572019-05-14 08:50:45 +053086 },
Nabin Hait1ed1c4e2019-11-25 12:33:40 +053087
88 route_to_adjustment_jv: (args) => {
Ankush Menatec74a5e2024-03-10 19:45:40 +053089 frappe.model.with_doctype("Journal Entry", () => {
Nabin Hait1ed1c4e2019-11-25 12:33:40 +053090 // route to adjustment Journal Entry to handle Account Balance and Stock Value mismatch
Ankush Menatec74a5e2024-03-10 19:45:40 +053091 let journal_entry = frappe.model.get_new_doc("Journal Entry");
Nabin Hait1ed1c4e2019-11-25 12:33:40 +053092
93 args.accounts.forEach((je_account) => {
94 let child_row = frappe.model.add_child(journal_entry, "accounts");
95 child_row.account = je_account.account;
96 child_row.debit_in_account_currency = je_account.debit_in_account_currency;
97 child_row.credit_in_account_currency = je_account.credit_in_account_currency;
Ankush Menatec74a5e2024-03-10 19:45:40 +053098 child_row.party_type = "";
Nabin Hait1ed1c4e2019-11-25 12:33:40 +053099 });
Ankush Menatec74a5e2024-03-10 19:45:40 +0530100 frappe.set_route("Form", "Journal Entry", journal_entry.name);
Nabin Hait1ed1c4e2019-11-25 12:33:40 +0530101 });
Frappe PR Bot255b99e2021-08-24 20:19:22 +0530102 },
103
Ankush Menatd37541d2021-12-10 12:04:10 +0530104 route_to_pending_reposts: (args) => {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530105 frappe.set_route("List", "Repost Item Valuation", args);
Ankush Menatd37541d2021-12-10 12:04:10 +0530106 },
Rushabh Mehtac38fc712014-04-16 17:21:25 +0530107});
Rushabh Mehta7d368752014-11-24 14:16:47 +0530108
Nabin Haitb072c742014-12-16 12:49:13 +0530109$.extend(erpnext.utils, {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530110 set_party_dashboard_indicators: function (frm) {
111 if (frm.doc.__onload && frm.doc.__onload.dashboard_info) {
deepeshgarg007920dc142018-11-23 10:17:28 +0530112 var company_wise_info = frm.doc.__onload.dashboard_info;
Ankush Menatec74a5e2024-03-10 19:45:40 +0530113 if (company_wise_info.length > 1) {
114 company_wise_info.forEach(function (info) {
deepeshgarg00712f5cef2018-12-25 16:06:19 +0530115 erpnext.utils.add_indicator_for_multicompany(frm, info);
deepeshgarg007a1cffc32018-11-23 16:51:35 +0530116 });
deepeshgarg00712f5cef2018-12-25 16:06:19 +0530117 } else if (company_wise_info.length === 1) {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530118 frm.dashboard.add_indicator(
119 __("Annual Billing: {0}", [
120 format_currency(
121 company_wise_info[0].billing_this_year,
122 company_wise_info[0].currency
123 ),
124 ]),
125 "blue"
126 );
127 frm.dashboard.add_indicator(
128 __("Total Unpaid: {0}", [
129 format_currency(company_wise_info[0].total_unpaid, company_wise_info[0].currency),
130 ]),
131 company_wise_info[0].total_unpaid ? "orange" : "green"
132 );
deepeshgarg00712f5cef2018-12-25 16:06:19 +0530133
Ankush Menatec74a5e2024-03-10 19:45:40 +0530134 if (company_wise_info[0].loyalty_points) {
135 frm.dashboard.add_indicator(
136 __("Loyalty Points: {0}", [company_wise_info[0].loyalty_points]),
137 "blue"
138 );
deepeshgarg00764238ee2018-12-25 16:28:39 +0530139 }
deepeshgarg007f31caff2018-11-27 15:04:12 +0530140 }
Rushabh Mehta559aa3a2016-09-19 16:04:58 +0530141 }
142 },
143
Ankush Menatec74a5e2024-03-10 19:45:40 +0530144 view_serial_batch_nos: function (frm) {
rohitwaghchaure3c15fea2023-08-24 17:24:44 +0530145 if (!frm.doc?.items) {
146 return;
147 }
148
Ankush Menatec74a5e2024-03-10 19:45:40 +0530149 let bundle_ids = frm.doc.items.filter((d) => d.serial_and_batch_bundle);
Rohit Waghchaure708eefb2023-07-10 16:54:55 +0530150
151 if (bundle_ids?.length) {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530152 frm.add_custom_button(
153 __("Serial / Batch Nos"),
154 () => {
155 frappe.route_options = {
156 voucher_no: frm.doc.name,
157 voucher_type: frm.doc.doctype,
158 from_date: frm.doc.posting_date || frm.doc.transaction_date,
159 to_date: frm.doc.posting_date || frm.doc.transaction_date,
160 company: frm.doc.company,
161 };
162 frappe.set_route("query-report", "Serial and Batch Summary");
163 },
164 __("View")
165 );
Rohit Waghchaure708eefb2023-07-10 16:54:55 +0530166 }
167 },
168
Ankush Menatec74a5e2024-03-10 19:45:40 +0530169 add_indicator_for_multicompany: function (frm, info) {
Deepak867f2c62022-05-17 11:52:52 +0530170 frm.dashboard.stats_area.show();
Ankush Menatec74a5e2024-03-10 19:45:40 +0530171 frm.dashboard.stats_area_row.addClass("flex");
172 frm.dashboard.stats_area_row.css("flex-wrap", "wrap");
deepeshgarg00712f5cef2018-12-25 16:06:19 +0530173
Ankush Menatec74a5e2024-03-10 19:45:40 +0530174 var color = info.total_unpaid ? "orange" : "green";
deepeshgarg00712f5cef2018-12-25 16:06:19 +0530175
Ankush Menatec74a5e2024-03-10 19:45:40 +0530176 var indicator = $(
177 '<div class="flex-column col-xs-6">' +
178 '<div style="margin-top:10px"><h6>' +
179 info.company +
180 "</h6></div>" +
181 '<div class="badge-link small" style="margin-bottom:10px"><span class="indicator blue">' +
182 "Annual Billing: " +
183 format_currency(info.billing_this_year, info.currency) +
184 "</span></div>" +
185 '<div class="badge-link small" style="margin-bottom:10px">' +
186 '<span class="indicator ' +
187 color +
188 '">Total Unpaid: ' +
189 format_currency(info.total_unpaid, info.currency) +
190 "</span></div>" +
191 "</div>"
192 ).appendTo(frm.dashboard.stats_area_row);
deepeshgarg00712f5cef2018-12-25 16:06:19 +0530193
Ankush Menatec74a5e2024-03-10 19:45:40 +0530194 if (info.loyalty_points) {
195 $(
196 '<div class="badge-link small" style="margin-bottom:10px"><span class="indicator blue">' +
197 "Loyalty Points: " +
198 info.loyalty_points +
199 "</span></div>"
200 ).appendTo(indicator);
deepeshgarg00712f5cef2018-12-25 16:06:19 +0530201 }
202
203 return indicator;
204 },
205
Ankush Menatec74a5e2024-03-10 19:45:40 +0530206 get_party_name: function (party_type) {
207 var dict = {
208 Customer: "customer_name",
209 Supplier: "supplier_name",
210 Employee: "employee_name",
211 Member: "member_name",
212 };
Shreya Shah149f7ee2018-03-27 11:29:25 +0530213 return dict[party_type];
214 },
215
Ankush Menatec74a5e2024-03-10 19:45:40 +0530216 copy_value_in_all_rows: function (doc, dt, dn, table_fieldname, fieldname) {
Neil Trini Lasradofe2ffae2015-07-08 18:16:51 +0530217 var d = locals[dt][dn];
Ankush Menatec74a5e2024-03-10 19:45:40 +0530218 if (d[fieldname]) {
Neil Trini Lasradofe2ffae2015-07-08 18:16:51 +0530219 var cl = doc[table_fieldname] || [];
Ankush Menatec74a5e2024-03-10 19:45:40 +0530220 for (var i = 0; i < cl.length; i++) {
221 if (!cl[i][fieldname]) cl[i][fieldname] = d[fieldname];
Neil Trini Lasradofe2ffae2015-07-08 18:16:51 +0530222 }
223 }
224 refresh_field(table_fieldname);
Makarand Bauskar157c3342017-05-26 21:32:33 +0530225 },
226
Ankush Menatec74a5e2024-03-10 19:45:40 +0530227 get_terms: function (tc_name, doc, callback) {
228 if (tc_name) {
Makarand Bauskar157c3342017-05-26 21:32:33 +0530229 return frappe.call({
Ankush Menatec74a5e2024-03-10 19:45:40 +0530230 method: "erpnext.setup.doctype.terms_and_conditions.terms_and_conditions.get_terms_and_conditions",
Makarand Bauskar157c3342017-05-26 21:32:33 +0530231 args: {
232 template_name: tc_name,
Ankush Menatec74a5e2024-03-10 19:45:40 +0530233 doc: doc,
Makarand Bauskar157c3342017-05-26 21:32:33 +0530234 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530235 callback: function (r) {
236 callback(r);
237 },
Makarand Bauskar157c3342017-05-26 21:32:33 +0530238 });
239 }
tundebabzy1a947db2017-08-29 13:48:27 +0100240 },
241
Ankush Menatec74a5e2024-03-10 19:45:40 +0530242 make_bank_account: function (doctype, docname) {
rohitwaghchaure713cfc72018-09-11 17:40:37 +0530243 frappe.call({
244 method: "erpnext.accounts.doctype.bank_account.bank_account.make_bank_account",
245 args: {
246 doctype: doctype,
Ankush Menatec74a5e2024-03-10 19:45:40 +0530247 docname: docname,
rohitwaghchaure713cfc72018-09-11 17:40:37 +0530248 },
249 freeze: true,
Ankush Menatec74a5e2024-03-10 19:45:40 +0530250 callback: function (r) {
rohitwaghchaure713cfc72018-09-11 17:40:37 +0530251 var doclist = frappe.model.sync(r.message);
252 frappe.set_route("Form", doclist[0].doctype, doclist[0].name);
Ankush Menatec74a5e2024-03-10 19:45:40 +0530253 },
254 });
rohitwaghchaure713cfc72018-09-11 17:40:37 +0530255 },
256
Ankush Menatec74a5e2024-03-10 19:45:40 +0530257 add_dimensions: function (report_name, index) {
Deepesh Garg11ea0b12020-05-26 19:23:45 +0530258 let filters = frappe.query_reports[report_name].filters;
259
Deepesh Garg7b2d5182020-12-04 11:28:26 +0530260 frappe.call({
261 method: "erpnext.accounts.doctype.accounting_dimension.accounting_dimension.get_dimensions",
Ankush Menatec74a5e2024-03-10 19:45:40 +0530262 callback: function (r) {
Deepesh Garg7b2d5182020-12-04 11:28:26 +0530263 let accounting_dimensions = r.message[0];
264 accounting_dimensions.forEach((dimension) => {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530265 let found = filters.some((el) => el.fieldname === dimension["fieldname"]);
Deepesh Garg11ea0b12020-05-26 19:23:45 +0530266
Deepesh Garg7b2d5182020-12-04 11:28:26 +0530267 if (!found) {
Deepesh Garg23ab5c52020-12-31 11:29:06 +0530268 filters.splice(index, 0, {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530269 fieldname: dimension["fieldname"],
270 label: __(dimension["label"]),
271 fieldtype: "MultiSelectList",
272 get_data: function (txt) {
Rohit Waghchaure69be22b2022-05-14 17:19:34 +0530273 return frappe.db.get_link_options(dimension["document_type"], txt);
274 },
Deepesh Garg7b2d5182020-12-04 11:28:26 +0530275 });
276 }
Deepesh Garg11ea0b12020-05-26 19:23:45 +0530277 });
Ankush Menatec74a5e2024-03-10 19:45:40 +0530278 },
Deepesh Garg11ea0b12020-05-26 19:23:45 +0530279 });
280 },
281
Ankush Menatec74a5e2024-03-10 19:45:40 +0530282 add_inventory_dimensions: function (report_name, index) {
Rohit Waghchauredbec5cf2022-06-22 12:24:08 +0530283 let filters = frappe.query_reports[report_name].filters;
284
285 frappe.call({
286 method: "erpnext.stock.doctype.inventory_dimension.inventory_dimension.get_inventory_dimensions",
Ankush Menatec74a5e2024-03-10 19:45:40 +0530287 callback: function (r) {
Rohit Waghchauredbec5cf2022-06-22 12:24:08 +0530288 if (r.message && r.message.length) {
289 r.message.forEach((dimension) => {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530290 let existing_filter = filters.filter((el) => el.fieldname === dimension["fieldname"]);
Rohit Waghchauredbec5cf2022-06-22 12:24:08 +0530291
Rohit Waghchaure0e388ba2023-02-20 12:20:03 +0530292 if (!existing_filter.length) {
Rohit Waghchauredbec5cf2022-06-22 12:24:08 +0530293 filters.splice(index, 0, {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530294 fieldname: dimension["fieldname"],
295 label: __(dimension["doctype"]),
296 fieldtype: "MultiSelectList",
297 get_data: function (txt) {
Rohit Waghchauredbec5cf2022-06-22 12:24:08 +0530298 return frappe.db.get_link_options(dimension["doctype"], txt);
299 },
300 });
Rohit Waghchaure0e388ba2023-02-20 12:20:03 +0530301 } else {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530302 existing_filter[0]["fieldtype"] = "MultiSelectList";
303 existing_filter[0]["get_data"] = function (txt) {
Rohit Waghchaure0e388ba2023-02-20 12:20:03 +0530304 return frappe.db.get_link_options(dimension["doctype"], txt);
Ankush Menatec74a5e2024-03-10 19:45:40 +0530305 };
Rohit Waghchauredbec5cf2022-06-22 12:24:08 +0530306 }
307 });
308 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530309 },
Rohit Waghchauredbec5cf2022-06-22 12:24:08 +0530310 });
311 },
312
Ankush Menatec74a5e2024-03-10 19:45:40 +0530313 make_subscription: function (doctype, docname) {
rohitwaghchaure166b78f2017-09-07 16:14:22 +0530314 frappe.call({
Rucha Mahabal65a627c2019-07-17 13:50:32 +0530315 method: "frappe.automation.doctype.auto_repeat.auto_repeat.make_auto_repeat",
rohitwaghchaure166b78f2017-09-07 16:14:22 +0530316 args: {
317 doctype: doctype,
Ankush Menatec74a5e2024-03-10 19:45:40 +0530318 docname: docname,
rohitwaghchaure166b78f2017-09-07 16:14:22 +0530319 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530320 callback: function (r) {
rohitwaghchaure166b78f2017-09-07 16:14:22 +0530321 var doclist = frappe.model.sync(r.message);
322 frappe.set_route("Form", doclist[0].doctype, doclist[0].name);
Ankush Menatec74a5e2024-03-10 19:45:40 +0530323 },
324 });
rohitwaghchaure166b78f2017-09-07 16:14:22 +0530325 },
326
Ankush Menatec74a5e2024-03-10 19:45:40 +0530327 make_pricing_rule: function (doctype, docname) {
Saif90cf2dd2018-09-30 21:46:31 +0500328 frappe.call({
329 method: "erpnext.accounts.doctype.pricing_rule.pricing_rule.make_pricing_rule",
330 args: {
331 doctype: doctype,
Ankush Menatec74a5e2024-03-10 19:45:40 +0530332 docname: docname,
Saif90cf2dd2018-09-30 21:46:31 +0500333 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530334 callback: function (r) {
Saif90cf2dd2018-09-30 21:46:31 +0500335 var doclist = frappe.model.sync(r.message);
336 frappe.set_route("Form", doclist[0].doctype, doclist[0].name);
Ankush Menatec74a5e2024-03-10 19:45:40 +0530337 },
338 });
Saif90cf2dd2018-09-30 21:46:31 +0500339 },
340
tundebabzy1a947db2017-08-29 13:48:27 +0100341 /**
Ankush Menatec74a5e2024-03-10 19:45:40 +0530342 * Checks if the first row of a given child table is empty
343 * @param child_table - Child table Doctype
344 * @return {Boolean}
345 **/
346 first_row_is_empty: function (child_table) {
347 if ($.isArray(child_table) && child_table.length > 0) {
tundebabzy1a947db2017-08-29 13:48:27 +0100348 return !child_table[0].item_code;
349 }
350 return false;
351 },
352
353 /**
Ankush Menatec74a5e2024-03-10 19:45:40 +0530354 * Removes the first row of a child table if it is empty
355 * @param {_Frm} frm - The current form
356 * @param {String} child_table_name - The child table field name
357 * @return {Boolean}
358 **/
359 remove_empty_first_row: function (frm, child_table_name) {
360 const rows = frm["doc"][child_table_name];
361 if (this.first_row_is_empty(rows)) {
362 frm["doc"][child_table_name] = rows.splice(1);
tundebabzy1a947db2017-08-29 13:48:27 +0100363 }
364 return rows;
365 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530366 get_tree_options: function (option) {
Zarrar6ffdf942018-06-14 12:24:16 +0530367 // get valid options for tree based on user permission & locals dict
368 let unscrub_option = frappe.model.unscrub(option);
369 let user_permission = frappe.defaults.get_user_permissions();
deepeshgarg0070d64d622019-02-20 17:55:14 +0530370 let options;
371
Ankush Menatec74a5e2024-03-10 19:45:40 +0530372 if (user_permission && user_permission[unscrub_option]) {
373 options = user_permission[unscrub_option].map((perm) => perm.doc);
Zarrar6ffdf942018-06-14 12:24:16 +0530374 } else {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530375 options = $.map(locals[`:${unscrub_option}`], function (c) {
376 return c.name;
377 }).sort();
Zarrar6ffdf942018-06-14 12:24:16 +0530378 }
deepeshgarg0070d64d622019-02-20 17:55:14 +0530379
380 // filter unique values, as there may be multiple user permissions for any value
381 return options.filter((value, index, self) => self.indexOf(value) === index);
Zarrar6ffdf942018-06-14 12:24:16 +0530382 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530383 get_tree_default: function (option) {
Zarrar6ffdf942018-06-14 12:24:16 +0530384 // set default for a field based on user permission
385 let options = this.get_tree_options(option);
Ankush Menatec74a5e2024-03-10 19:45:40 +0530386 if (options.includes(frappe.defaults.get_default(option))) {
Zarrar6ffdf942018-06-14 12:24:16 +0530387 return frappe.defaults.get_default(option);
388 } else {
389 return options[0];
390 }
Sanjay Kumar1b49f3a2018-09-06 13:09:35 +0400391 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530392 overrides_parent_value_in_all_rows: function (doc, dt, dn, table_fieldname, fieldname, parent_fieldname) {
Marica24e45162021-04-14 18:53:15 +0530393 if (doc[parent_fieldname]) {
Andy Zhubffe9332021-04-12 22:49:26 +1200394 let cl = doc[table_fieldname] || [];
Marica24e45162021-04-14 18:53:15 +0530395 for (let i = 0; i < cl.length; i++) {
Sanjay Kumar1b49f3a2018-09-06 13:09:35 +0400396 cl[i][fieldname] = doc[parent_fieldname];
397 }
Andy Zhubffe9332021-04-12 22:49:26 +1200398 frappe.refresh_field(table_fieldname);
Sanjay Kumar1b49f3a2018-09-06 13:09:35 +0400399 }
Sanjay Kumar1b49f3a2018-09-06 13:09:35 +0400400 },
Nabin Hait34c551d2019-07-03 10:34:31 +0530401 create_new_doc: function (doctype, update_fields) {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530402 frappe.model.with_doctype(doctype, function () {
Nabin Hait34c551d2019-07-03 10:34:31 +0530403 var new_doc = frappe.model.get_new_doc(doctype);
404 for (let [key, value] of Object.entries(update_fields)) {
405 new_doc[key] = value;
406 }
407 frappe.ui.form.make_quick_entry(doctype, null, null, new_doc);
408 });
Ankush Menat0b86b1b2022-12-08 16:40:13 +0530409 },
Nabin Hait34c551d2019-07-03 10:34:31 +0530410
Ankush Menat0b86b1b2022-12-08 16:40:13 +0530411 // check if payments app is installed on site, if not warn user.
412 check_payments_app: () => {
413 if (frappe.boot.versions && !frappe.boot.versions.payments) {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530414 const marketplace_link =
415 '<a href="https://frappecloud.com/marketplace/apps/payments">Marketplace</a>';
416 const github_link = '<a href="https://github.com/frappe/payments/">GitHub</a>';
417 const msg = __("payments app is not installed. Please install it from {0} or {1}", [
418 marketplace_link,
419 github_link,
420 ]);
Ankush Menat0b86b1b2022-12-08 16:40:13 +0530421 frappe.msgprint(msg);
422 }
Ankush Menat0b86b1b2022-12-08 16:40:13 +0530423 },
Rohit Waghchaure1c2fe082023-06-15 12:54:43 +0530424
425 pick_serial_and_batch_bundle(frm, cdt, cdn, type_of_transaction, warehouse_field) {
426 let item_row = frappe.get_doc(cdt, cdn);
427 item_row.type_of_transaction = type_of_transaction;
428
Ankush Menatec74a5e2024-03-10 19:45:40 +0530429 frappe.db.get_value("Item", item_row.item_code, ["has_batch_no", "has_serial_no"]).then((r) => {
430 item_row.has_batch_no = r.message.has_batch_no;
431 item_row.has_serial_no = r.message.has_serial_no;
Rohit Waghchaure1c2fe082023-06-15 12:54:43 +0530432
Rohit Waghchaure0d9d42a2024-03-27 11:52:06 +0530433 new erpnext.SerialBatchPackageSelector(frm, item_row, (r) => {
434 if (r) {
435 let update_values = {
436 serial_and_batch_bundle: r.name,
437 qty: Math.abs(r.total_qty),
438 };
Rohit Waghchaure1c2fe082023-06-15 12:54:43 +0530439
Rohit Waghchaure0d9d42a2024-03-27 11:52:06 +0530440 if (!warehouse_field) {
441 warehouse_field = "warehouse";
Ankush Menatec74a5e2024-03-10 19:45:40 +0530442 }
Rohit Waghchaure0d9d42a2024-03-27 11:52:06 +0530443
444 if (r.warehouse) {
445 update_values[warehouse_field] = r.warehouse;
446 }
447
448 frappe.model.set_value(item_row.doctype, item_row.name, update_values);
449 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530450 });
Rohit Waghchaure1c2fe082023-06-15 12:54:43 +0530451 });
Deepesh Garg62706072023-07-16 12:58:42 +0530452 },
453
Ankush Menatec74a5e2024-03-10 19:45:40 +0530454 get_fiscal_year: function (date, with_dates = false, boolean = false) {
Corentin Flrc203faf2024-04-09 14:59:58 +0200455 if (!frappe.boot.setup_complete) {
456 return;
457 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530458 if (!date) {
Deepesh Garg3759a412023-07-19 13:17:12 +0530459 date = frappe.datetime.get_today();
460 }
461
Ankush Menatec74a5e2024-03-10 19:45:40 +0530462 let fiscal_year = "";
Deepesh Garg62706072023-07-16 12:58:42 +0530463 frappe.call({
464 method: "erpnext.accounts.utils.get_fiscal_year",
465 args: {
ruthra kumarc31ee8e2023-11-14 06:44:49 +0530466 date: date,
Ankush Menatec74a5e2024-03-10 19:45:40 +0530467 boolean: boolean,
Deepesh Garg62706072023-07-16 12:58:42 +0530468 },
469 async: false,
Ankush Menatec74a5e2024-03-10 19:45:40 +0530470 callback: function (r) {
Deepesh Garg62706072023-07-16 12:58:42 +0530471 if (r.message) {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530472 if (with_dates) fiscal_year = r.message;
473 else fiscal_year = r.message[0];
Deepesh Garg62706072023-07-16 12:58:42 +0530474 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530475 },
Deepesh Garg62706072023-07-16 12:58:42 +0530476 });
477 return fiscal_year;
Ankush Menatec74a5e2024-03-10 19:45:40 +0530478 },
Rushabh Mehta95b995b2015-05-28 12:10:55 +0530479});
480
Ankush Menatec74a5e2024-03-10 19:45:40 +0530481erpnext.utils.select_alternate_items = function (opts) {
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530482 const frm = opts.frm;
Ankush Menatec74a5e2024-03-10 19:45:40 +0530483 const warehouse_field = opts.warehouse_field || "warehouse";
484 const item_field = opts.item_field || "item_code";
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530485
486 this.data = [];
487 const dialog = new frappe.ui.Dialog({
488 title: __("Select Alternate Item"),
489 fields: [
Ankush Menatec74a5e2024-03-10 19:45:40 +0530490 { fieldtype: "Section Break", label: __("Items") },
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530491 {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530492 fieldname: "alternative_items",
493 fieldtype: "Table",
494 cannot_add_rows: true,
495 in_place_edit: true,
496 data: this.data,
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530497 get_data: () => {
498 return this.data;
499 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530500 fields: [
501 {
502 fieldtype: "Data",
503 fieldname: "docname",
504 hidden: 1,
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530505 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530506 {
507 fieldtype: "Link",
508 fieldname: "item_code",
509 options: "Item",
510 in_list_view: 1,
511 read_only: 1,
512 label: __("Item Code"),
513 },
514 {
515 fieldtype: "Link",
516 fieldname: "alternate_item",
517 options: "Item",
518 default: "",
519 in_list_view: 1,
520 label: __("Alternate Item"),
521 onchange: function () {
522 const item_code = this.get_value();
523 const warehouse = this.grid_row.on_grid_fields_dict.warehouse.get_value();
524 if (item_code && warehouse) {
525 frappe.call({
526 method: "erpnext.stock.utils.get_latest_stock_qty",
527 args: {
528 item_code: item_code,
529 warehouse: warehouse,
530 },
531 callback: (r) => {
532 this.grid_row.on_grid_fields_dict.actual_qty.set_value(
533 r.message || 0
534 );
535 },
536 });
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530537 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530538 },
539 get_query: (e) => {
540 return {
541 query: "erpnext.stock.doctype.item_alternative.item_alternative.get_alternative_items",
542 filters: {
543 item_code: e.item_code,
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530544 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530545 };
546 },
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530547 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530548 {
549 fieldtype: "Link",
550 fieldname: "warehouse",
551 options: "Warehouse",
552 default: "",
553 in_list_view: 1,
554 label: __("Warehouse"),
555 onchange: function () {
556 const warehouse = this.get_value();
557 const item_code = this.grid_row.on_grid_fields_dict.item_code.get_value();
558 if (item_code && warehouse) {
559 frappe.call({
560 method: "erpnext.stock.utils.get_latest_stock_qty",
561 args: {
562 item_code: item_code,
563 warehouse: warehouse,
564 },
565 callback: (r) => {
566 this.grid_row.on_grid_fields_dict.actual_qty.set_value(
567 r.message || 0
568 );
569 },
570 });
571 }
572 },
573 },
574 {
575 fieldtype: "Float",
576 fieldname: "actual_qty",
577 default: 0,
578 read_only: 1,
579 in_list_view: 1,
580 label: __("Available Qty"),
581 },
582 ],
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530583 },
584 ],
Ankush Menatec74a5e2024-03-10 19:45:40 +0530585 primary_action: function () {
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530586 const args = this.get_values()["alternative_items"];
Ankush Menatec74a5e2024-03-10 19:45:40 +0530587 const alternative_items = args.filter((d) => {
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530588 if (d.alternate_item && d.item_code != d.alternate_item) {
589 return true;
590 }
591 });
592
Ankush Menatec74a5e2024-03-10 19:45:40 +0530593 alternative_items.forEach((d) => {
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530594 let row = frappe.get_doc(opts.child_doctype, d.docname);
Doridel Cahanape42192b2018-05-16 13:28:39 +0800595 let qty = null;
Ankush Menatec74a5e2024-03-10 19:45:40 +0530596 if (row.doctype === "Work Order Item") {
Doridel Cahanape42192b2018-05-16 13:28:39 +0800597 qty = row.required_qty;
598 } else {
599 qty = row.qty;
600 }
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530601 row[item_field] = d.alternate_item;
Ankush Menatec74a5e2024-03-10 19:45:40 +0530602 frappe.model.set_value(row.doctype, row.name, "qty", qty);
mergify[bot]c1a0f642021-12-17 19:06:19 +0530603 frappe.model.set_value(row.doctype, row.name, opts.original_item_field, d.item_code);
604 frm.trigger(item_field, row.doctype, row.name);
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530605 });
606
607 refresh_field(opts.child_docname);
608 this.hide();
609 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530610 primary_action_label: __("Update"),
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530611 });
612
Ankush Menatec74a5e2024-03-10 19:45:40 +0530613 frm.doc[opts.child_docname].forEach((d) => {
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530614 if (!opts.condition || opts.condition(d)) {
615 dialog.fields_dict.alternative_items.df.data.push({
Ankush Menatec74a5e2024-03-10 19:45:40 +0530616 docname: d.name,
617 item_code: d[item_field],
618 warehouse: d[warehouse_field],
619 actual_qty: d.actual_qty,
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530620 });
621 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530622 });
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530623
624 this.data = dialog.fields_dict.alternative_items.df.data;
625 dialog.fields_dict.alternative_items.grid.refresh();
626 dialog.show();
Ankush Menatec74a5e2024-03-10 19:45:40 +0530627};
rohitwaghchaurea3c3dec2018-03-28 11:51:44 +0530628
Ankush Menatec74a5e2024-03-10 19:45:40 +0530629erpnext.utils.update_child_items = function (opts) {
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800630 const frm = opts.frm;
Ankush Menatec74a5e2024-03-10 19:45:40 +0530631 const cannot_add_row = typeof opts.cannot_add_row === "undefined" ? true : opts.cannot_add_row;
632 const child_docname = typeof opts.cannot_add_row === "undefined" ? "items" : opts.child_docname;
Saqib56fea7d2020-10-09 21:19:25 +0530633 const child_meta = frappe.get_meta(`${frm.doc.doctype} Item`);
s-aga-r2d8363a2023-09-02 11:02:24 +0530634 const has_reserved_stock = opts.has_reserved_stock ? true : false;
Ankush Menatec74a5e2024-03-10 19:45:40 +0530635 const get_precision = (fieldname) => child_meta.fields.find((f) => f.fieldname == fieldname).precision;
Saqib56fea7d2020-10-09 21:19:25 +0530636
Devin Slauenwhitea835c1a2023-01-26 16:53:05 -0500637 this.data = frm.doc[opts.child_docname].map((d) => {
638 return {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530639 docname: d.name,
640 name: d.name,
641 item_code: d.item_code,
642 delivery_date: d.delivery_date,
643 schedule_date: d.schedule_date,
644 conversion_factor: d.conversion_factor,
645 qty: d.qty,
646 rate: d.rate,
647 uom: d.uom,
648 fg_item: d.fg_item,
649 fg_item_qty: d.fg_item_qty,
650 };
Devin Slauenwhitea835c1a2023-01-26 16:53:05 -0500651 });
652
Ankush Menatec74a5e2024-03-10 19:45:40 +0530653 const fields = [
654 {
655 fieldtype: "Data",
656 fieldname: "docname",
657 read_only: 1,
658 hidden: 1,
659 },
660 {
661 fieldtype: "Link",
662 fieldname: "item_code",
663 options: "Item",
Saqib Ansarif53299e2020-04-15 22:08:12 +0530664 in_list_view: 1,
s-aga-rfaf9f132023-08-21 15:51:57 +0530665 read_only: 0,
666 disabled: 0,
Ankush Menatec74a5e2024-03-10 19:45:40 +0530667 label: __("Item Code"),
668 get_query: function () {
669 let filters;
670 if (frm.doc.doctype == "Sales Order") {
671 filters = { is_sales_item: 1 };
672 } else if (frm.doc.doctype == "Purchase Order") {
673 if (frm.doc.is_subcontracted) {
674 if (frm.doc.is_old_subcontracting_flow) {
675 filters = { is_sub_contracted_item: 1 };
676 } else {
677 filters = { is_stock_item: 0 };
678 }
679 } else {
680 filters = { is_purchase_item: 1 };
s-aga-rfaf9f132023-08-21 15:51:57 +0530681 }
682 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530683 return {
684 query: "erpnext.controllers.queries.item_query",
685 filters: filters,
686 };
s-aga-rfaf9f132023-08-21 15:51:57 +0530687 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530688 },
689 {
690 fieldtype: "Link",
691 fieldname: "uom",
692 options: "UOM",
693 read_only: 0,
694 label: __("UOM"),
s-aga-rfaf9f132023-08-21 15:51:57 +0530695 reqd: 1,
Ankush Menatec74a5e2024-03-10 19:45:40 +0530696 onchange: function () {
697 frappe.call({
698 method: "erpnext.stock.get_item_details.get_conversion_factor",
699 args: { item_code: this.doc.item_code, uom: this.value },
700 callback: (r) => {
701 if (!r.exc) {
702 if (this.doc.conversion_factor == r.message.conversion_factor) return;
703
704 const docname = this.doc.docname;
705 dialog.fields_dict.trans_items.df.data.some((doc) => {
706 if (doc.docname == docname) {
707 doc.conversion_factor = r.message.conversion_factor;
708 dialog.fields_dict.trans_items.grid.refresh();
709 return true;
710 }
711 });
712 }
713 },
714 });
715 },
716 },
717 {
718 fieldtype: "Float",
719 fieldname: "qty",
s-aga-rfaf9f132023-08-21 15:51:57 +0530720 default: 0,
721 read_only: 0,
Ankush Menatec74a5e2024-03-10 19:45:40 +0530722 in_list_view: 1,
723 label: __("Qty"),
724 precision: get_precision("qty"),
725 },
726 {
727 fieldtype: "Currency",
728 fieldname: "rate",
729 options: "currency",
730 default: 0,
731 read_only: 0,
732 in_list_view: 1,
733 label: __("Rate"),
734 precision: get_precision("rate"),
735 },
736 ];
737
738 if (frm.doc.doctype == "Sales Order" || frm.doc.doctype == "Purchase Order") {
739 fields.splice(2, 0, {
740 fieldtype: "Date",
741 fieldname: frm.doc.doctype == "Sales Order" ? "delivery_date" : "schedule_date",
742 in_list_view: 1,
743 label: frm.doc.doctype == "Sales Order" ? __("Delivery Date") : __("Reqd by date"),
744 default: frm.doc.doctype == "Sales Order" ? frm.doc.delivery_date : frm.doc.schedule_date,
745 reqd: 1,
746 });
747 fields.splice(3, 0, {
748 fieldtype: "Float",
749 fieldname: "conversion_factor",
750 label: __("Conversion Factor"),
751 precision: get_precision("conversion_factor"),
752 });
753 }
754
755 if (
756 frm.doc.doctype == "Purchase Order" &&
757 frm.doc.is_subcontracted &&
758 !frm.doc.is_old_subcontracting_flow
759 ) {
760 fields.push(
761 {
762 fieldtype: "Link",
763 fieldname: "fg_item",
764 options: "Item",
765 reqd: 1,
766 in_list_view: 0,
767 read_only: 0,
768 disabled: 0,
769 label: __("Finished Good Item"),
770 get_query: () => {
771 return {
772 filters: {
773 is_stock_item: 1,
774 is_sub_contracted_item: 1,
775 default_bom: ["!=", ""],
776 },
777 };
778 },
779 },
780 {
781 fieldtype: "Float",
782 fieldname: "fg_item_qty",
783 reqd: 1,
784 default: 0,
785 read_only: 0,
786 in_list_view: 0,
787 label: __("Finished Good Item Qty"),
788 precision: get_precision("fg_item_qty"),
789 }
790 );
s-aga-rfaf9f132023-08-21 15:51:57 +0530791 }
792
Deepesh Garg40772542023-07-22 23:07:18 +0530793 let dialog = new frappe.ui.Dialog({
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800794 title: __("Update Items"),
Raffael Meyerd5fe1432023-07-14 08:57:35 +0200795 size: "extra-large",
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800796 fields: [
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800797 {
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +0100798 fieldname: "trans_items",
799 fieldtype: "Table",
Maricafc96c1a2020-03-06 10:57:59 +0530800 label: "Items",
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +0100801 cannot_add_rows: cannot_add_row,
Saqibbc919e22020-11-05 17:38:35 +0530802 in_place_edit: false,
Maricafc96c1a2020-03-06 10:57:59 +0530803 reqd: 1,
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +0100804 data: this.data,
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800805 get_data: () => {
806 return this.data;
807 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530808 fields: fields,
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800809 },
810 ],
Ankush Menatec74a5e2024-03-10 19:45:40 +0530811 primary_action: function () {
s-aga-r2d8363a2023-09-02 11:02:24 +0530812 if (frm.doctype == "Sales Order" && has_reserved_stock) {
813 this.hide();
814 frappe.confirm(
Ankush Menatec74a5e2024-03-10 19:45:40 +0530815 __(
816 "The reserved stock will be released when you update items. Are you certain you wish to proceed?"
817 ),
818 () => this.update_items()
819 );
s-aga-r2d8363a2023-09-02 11:02:24 +0530820 } else {
821 this.update_items();
822 }
823 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530824 update_items: function () {
Ankush Menat6de7b8e2021-08-24 12:18:40 +0530825 const trans_items = this.get_values()["trans_items"].filter((item) => !!item.item_code);
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800826 frappe.call({
Ankush Menatec74a5e2024-03-10 19:45:40 +0530827 method: "erpnext.controllers.accounts_controller.update_child_qty_rate",
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +0100828 freeze: true,
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800829 args: {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530830 parent_doctype: frm.doc.doctype,
831 trans_items: trans_items,
832 parent_doctype_name: frm.doc.name,
833 child_docname: child_docname,
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800834 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530835 callback: function () {
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800836 frm.reload_doc();
Ankush Menatec74a5e2024-03-10 19:45:40 +0530837 },
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800838 });
839 this.hide();
840 refresh_field("items");
841 },
Ankush Menatec74a5e2024-03-10 19:45:40 +0530842 primary_action_label: __("Update"),
843 });
Deepesh Garg40772542023-07-22 23:07:18 +0530844
845 dialog.show();
Ankush Menatec74a5e2024-03-10 19:45:40 +0530846};
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800847
Ankush Menatec74a5e2024-03-10 19:45:40 +0530848erpnext.utils.map_current_doc = function (opts) {
Sagar Vora78777d62021-03-09 20:35:08 +0530849 function _map() {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530850 if ($.isArray(cur_frm.doc.items) && cur_frm.doc.items.length > 0) {
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530851 // remove first item row if empty
Ankush Menatec74a5e2024-03-10 19:45:40 +0530852 if (!cur_frm.doc.items[0].item_code) {
Rushabh Mehta176b63b2016-07-14 17:43:48 +0530853 cur_frm.doc.items = cur_frm.doc.items.splice(1);
854 }
bhupen3c7e70f2016-11-30 14:32:11 +0530855
856 // find the doctype of the items table
Ankush Menatec74a5e2024-03-10 19:45:40 +0530857 var items_doctype = frappe.meta.get_docfield(cur_frm.doctype, "items").options;
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530858
bhupen3c7e70f2016-11-30 14:32:11 +0530859 // find the link fieldname from items table for the given
860 // source_doctype
861 var link_fieldname = null;
Ankush Menatec74a5e2024-03-10 19:45:40 +0530862 frappe.get_meta(items_doctype).fields.forEach(function (d) {
863 if (d.options === opts.source_doctype) link_fieldname = d.fieldname;
864 });
bhupen3c7e70f2016-11-30 14:32:11 +0530865
Nabin Hait802b4352017-01-09 15:32:20 +0530866 // search in existing items if the source_name is already set and full qty fetched
bhupen3c7e70f2016-11-30 14:32:11 +0530867 var already_set = false;
Nabin Hait802b4352017-01-09 15:32:20 +0530868 var item_qty_map = {};
bhupen3c7e70f2016-11-30 14:32:11 +0530869
Ankush Menatec74a5e2024-03-10 19:45:40 +0530870 $.each(cur_frm.doc.items, function (i, d) {
871 opts.source_name.forEach(function (src) {
872 if (d[link_fieldname] == src) {
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530873 already_set = true;
Ankush Menatec74a5e2024-03-10 19:45:40 +0530874 if (item_qty_map[d.item_code]) item_qty_map[d.item_code] += flt(d.qty);
875 else item_qty_map[d.item_code] = flt(d.qty);
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530876 }
877 });
878 });
879
Ankush Menatec74a5e2024-03-10 19:45:40 +0530880 if (already_set) {
881 opts.source_name.forEach(function (src) {
882 frappe.model.with_doc(opts.source_doctype, src, function (r) {
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530883 var source_doc = frappe.model.get_doc(opts.source_doctype, src);
Ankush Menatec74a5e2024-03-10 19:45:40 +0530884 $.each(source_doc.items || [], function (i, row) {
885 if (row.qty > flt(item_qty_map[row.item_code])) {
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530886 already_set = false;
887 return false;
888 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530889 });
890 });
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530891
Ankush Menatec74a5e2024-03-10 19:45:40 +0530892 if (already_set) {
893 frappe.msgprint(
894 __("You have already selected items from {0} {1}", [opts.source_doctype, src])
895 );
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530896 return;
897 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530898 });
Nabin Hait802b4352017-01-09 15:32:20 +0530899 }
Rushabh Mehta176b63b2016-07-14 17:43:48 +0530900 }
901
902 return frappe.call({
903 // Sometimes we hit the limit for URL length of a GET request
904 // as we send the full target_doc. Hence this is a POST request.
905 type: "POST",
Ankush Menatec74a5e2024-03-10 19:45:40 +0530906 method: "frappe.model.mapper.map_docs",
Rushabh Mehta176b63b2016-07-14 17:43:48 +0530907 args: {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530908 method: opts.method,
909 source_names: opts.source_name,
910 target_doc: cur_frm.doc,
911 args: opts.args,
Rushabh Mehta176b63b2016-07-14 17:43:48 +0530912 },
s-aga-r2d8363a2023-09-02 11:02:24 +0530913 freeze: true,
914 freeze_message: __("Mapping {0} ...", [opts.source_doctype]),
Ankush Menatec74a5e2024-03-10 19:45:40 +0530915 callback: function (r) {
916 if (!r.exc) {
Deepesh Garg9b1c2222023-12-27 22:37:01 +0530917 frappe.model.sync(r.message);
Vishal Dhayagudef06c2812017-12-26 16:22:40 +0530918 cur_frm.dirty();
Rushabh Mehta176b63b2016-07-14 17:43:48 +0530919 cur_frm.refresh();
920 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530921 },
Rushabh Mehta176b63b2016-07-14 17:43:48 +0530922 });
923 }
Sagar Vora78777d62021-03-09 20:35:08 +0530924
925 let query_args = {};
926 if (opts.get_query_filters) {
927 query_args.filters = opts.get_query_filters;
928 }
929
930 if (opts.get_query_method) {
931 query_args.query = opts.get_query_method;
932 }
933
934 if (query_args.filters || query_args.query) {
935 opts.get_query = () => query_args;
936 }
937
938 if (opts.source_doctype) {
ruthra kumar7da9ffa2024-01-03 17:59:15 +0530939 let data_fields = [];
ruthra kumar550cbbd2024-04-01 16:25:35 +0530940 if (["Purchase Receipt", "Delivery Note"].includes(opts.source_doctype)) {
ruthra kumar7da9ffa2024-01-03 17:59:15 +0530941 data_fields.push({
Ankush Menatec74a5e2024-03-10 19:45:40 +0530942 fieldname: "merge_taxes",
943 fieldtype: "Check",
944 label: __("Merge taxes from multiple documents"),
ruthra kumar7da9ffa2024-01-03 17:59:15 +0530945 });
946 }
Sagar Vora78777d62021-03-09 20:35:08 +0530947 const d = new frappe.ui.form.MultiSelectDialog({
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530948 doctype: opts.source_doctype,
949 target: opts.target,
950 date_field: opts.date_field || undefined,
951 setters: opts.setters,
ruthra kumar7da9ffa2024-01-03 17:59:15 +0530952 data_fields: data_fields,
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530953 get_query: opts.get_query,
marination4f395cc2020-09-24 12:43:41 +0530954 add_filters_group: 1,
Saqib7292f542021-09-13 12:13:43 +0530955 allow_child_item_selection: opts.allow_child_item_selection,
gn3060292a619fd2022-06-29 17:15:21 +0800956 child_fieldname: opts.child_fieldname,
Saqib7292f542021-09-13 12:13:43 +0530957 child_columns: opts.child_columns,
Rohit Waghchaure69ffddf2021-10-07 17:33:58 +0530958 size: opts.size,
Ankush Menatec74a5e2024-03-10 19:45:40 +0530959 action: function (selections, args) {
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530960 let values = selections;
Saqibe03d9aa2021-09-17 13:03:27 +0530961 if (values.length === 0) {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530962 frappe.msgprint(__("Please select {0}", [opts.source_doctype]));
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530963 return;
964 }
965 opts.source_name = values;
ruthra kumar550cbbd2024-04-01 16:25:35 +0530966 if (
967 opts.allow_child_item_selection ||
968 ["Purchase Receipt", "Delivery Note"].includes(opts.source_doctype)
969 ) {
ruthra kumar7da9ffa2024-01-03 17:59:15 +0530970 // args contains filtered child docnames
971 opts.args = args;
972 }
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530973 d.dialog.hide();
974 _map();
975 },
Rushabh Mehta176b63b2016-07-14 17:43:48 +0530976 });
Sagar Vora78777d62021-03-09 20:35:08 +0530977
978 return d;
979 }
980
981 if (opts.source_name) {
Prateeksha Singhedeb4dc2017-05-15 11:32:06 +0530982 opts.source_name = [opts.source_name];
Rushabh Mehta176b63b2016-07-14 17:43:48 +0530983 _map();
984 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530985};
Rushabh Mehta176b63b2016-07-14 17:43:48 +0530986
Ankush Menatec74a5e2024-03-10 19:45:40 +0530987frappe.form.link_formatters["Item"] = function (value, doc) {
Alan157b3882021-04-21 21:00:22 +0530988 if (doc && value && doc.item_name && doc.item_name !== value && doc.item_code === value) {
Ankush Menatec74a5e2024-03-10 19:45:40 +0530989 return value + ": " + doc.item_name;
marination824f48f2020-10-12 20:08:03 +0530990 } else if (!value && doc.doctype && doc.item_name) {
991 // format blank value in child table
992 return doc.item_name;
Rushabh Mehta180e4352016-07-26 17:57:42 +0530993 } else {
marination824f48f2020-10-12 20:08:03 +0530994 // if value is blank in report view or item code and name are the same, return as is
Rushabh Mehta180e4352016-07-26 17:57:42 +0530995 return value;
996 }
Ankush Menatec74a5e2024-03-10 19:45:40 +0530997};
Rushabh Mehta180e4352016-07-26 17:57:42 +0530998
Ankush Menatec74a5e2024-03-10 19:45:40 +0530999frappe.form.link_formatters["Employee"] = function (value, doc) {
Rucha Mahabal5ba1bc12021-11-23 09:30:30 +05301000 if (doc && value && doc.employee_name && doc.employee_name !== value && doc.employee === value) {
Ankush Menatec74a5e2024-03-10 19:45:40 +05301001 return value + ": " + doc.employee_name;
Rucha Mahabal5ba1bc12021-11-23 09:30:30 +05301002 } else if (!value && doc.doctype && doc.employee_name) {
1003 // format blank value in child table
1004 return doc.employee;
Rushabh Mehta180e4352016-07-26 17:57:42 +05301005 } else {
Rucha Mahabal5ba1bc12021-11-23 09:30:30 +05301006 // if value is blank in report view or project name and name are the same, return as is
Rushabh Mehta180e4352016-07-26 17:57:42 +05301007 return value;
1008 }
Ankush Menatec74a5e2024-03-10 19:45:40 +05301009};
Rushabh Mehta180e4352016-07-26 17:57:42 +05301010
Ankush Menatec74a5e2024-03-10 19:45:40 +05301011frappe.form.link_formatters["Project"] = function (value, doc) {
Rucha Mahabal59961f72021-05-20 23:43:19 +05301012 if (doc && value && doc.project_name && doc.project_name !== value && doc.project === value) {
Ankush Menatec74a5e2024-03-10 19:45:40 +05301013 return value + ": " + doc.project_name;
Rucha Mahabal59961f72021-05-20 23:43:19 +05301014 } else if (!value && doc.doctype && doc.project_name) {
1015 // format blank value in child table
1016 return doc.project;
1017 } else {
1018 // if value is blank in report view or project name and name are the same, return as is
1019 return value;
1020 }
1021};
1022
Rushabh Mehta95b995b2015-05-28 12:10:55 +05301023// add description on posting time
Ankush Menatec74a5e2024-03-10 19:45:40 +05301024$(document).on("app_ready", function () {
1025 if (!frappe.datetime.is_timezone_same()) {
1026 $.each(
1027 [
1028 "Stock Reconciliation",
1029 "Stock Entry",
1030 "Stock Ledger Entry",
1031 "Delivery Note",
1032 "Purchase Receipt",
1033 "Sales Invoice",
1034 ],
1035 function (i, d) {
1036 frappe.ui.form.on(d, "onload", function (frm) {
1037 cur_frm.set_df_property("posting_time", "description", frappe.sys_defaults.time_zone);
1038 });
1039 }
1040 );
Rushabh Mehta95b995b2015-05-28 12:10:55 +05301041 }
akshay14384c22016-07-28 13:53:17 +05301042});
Alanc6dc9ea2021-05-07 20:30:04 +05301043
Himanshuec25d592021-06-14 19:05:52 +05301044// Show SLA dashboard
Ankush Menatec74a5e2024-03-10 19:45:40 +05301045$(document).on("app_ready", function () {
1046 $.each(frappe.boot.service_level_agreement_doctypes, function (_i, d) {
Ankush Menatbd9ef742023-07-16 11:34:42 +05301047 frappe.ui.form.on(d, {
Ankush Menatec74a5e2024-03-10 19:45:40 +05301048 onload: function (frm) {
1049 if (!frm.doc.service_level_agreement) return;
Himanshuec25d592021-06-14 19:05:52 +05301050
Ankush Menatbd9ef742023-07-16 11:34:42 +05301051 frappe.call({
Ankush Menatec74a5e2024-03-10 19:45:40 +05301052 method: "erpnext.support.doctype.service_level_agreement.service_level_agreement.get_service_level_agreement_filters",
Ankush Menatbd9ef742023-07-16 11:34:42 +05301053 args: {
1054 doctype: frm.doc.doctype,
1055 name: frm.doc.service_level_agreement,
Ankush Menatec74a5e2024-03-10 19:45:40 +05301056 customer: frm.doc.customer,
Himanshuec25d592021-06-14 19:05:52 +05301057 },
Ankush Menatbd9ef742023-07-16 11:34:42 +05301058 callback: function (r) {
1059 if (r && r.message) {
Ankush Menatec74a5e2024-03-10 19:45:40 +05301060 frm.set_query("priority", function () {
Ankush Menatbd9ef742023-07-16 11:34:42 +05301061 return {
1062 filters: {
Ankush Menatec74a5e2024-03-10 19:45:40 +05301063 name: ["in", r.message.priority],
1064 },
Ankush Menatbd9ef742023-07-16 11:34:42 +05301065 };
Himanshuec25d592021-06-14 19:05:52 +05301066 });
Ankush Menatec74a5e2024-03-10 19:45:40 +05301067 frm.set_query("service_level_agreement", function () {
Ankush Menatbd9ef742023-07-16 11:34:42 +05301068 return {
1069 filters: {
Ankush Menatec74a5e2024-03-10 19:45:40 +05301070 name: ["in", r.message.service_level_agreements],
1071 },
Ankush Menatbd9ef742023-07-16 11:34:42 +05301072 };
1073 });
Himanshuec25d592021-06-14 19:05:52 +05301074 }
Ankush Menatec74a5e2024-03-10 19:45:40 +05301075 },
Himanshuec25d592021-06-14 19:05:52 +05301076 });
Ankush Menatbd9ef742023-07-16 11:34:42 +05301077 },
1078
Ankush Menatec74a5e2024-03-10 19:45:40 +05301079 refresh: function (frm) {
1080 if (
1081 frm.doc.status !== "Closed" &&
1082 frm.doc.service_level_agreement &&
1083 ["First Response Due", "Resolution Due"].includes(frm.doc.agreement_status)
1084 ) {
Ankush Menatbd9ef742023-07-16 11:34:42 +05301085 frappe.call({
Ankush Menatec74a5e2024-03-10 19:45:40 +05301086 method: "frappe.client.get",
Ankush Menatbd9ef742023-07-16 11:34:42 +05301087 args: {
Ankush Menatec74a5e2024-03-10 19:45:40 +05301088 doctype: "Service Level Agreement",
1089 name: frm.doc.service_level_agreement,
Ankush Menatbd9ef742023-07-16 11:34:42 +05301090 },
Ankush Menatec74a5e2024-03-10 19:45:40 +05301091 callback: function (data) {
Ankush Menatbd9ef742023-07-16 11:34:42 +05301092 let statuses = data.message.pause_sla_on;
1093 const hold_statuses = [];
1094 $.each(statuses, (_i, entry) => {
1095 hold_statuses.push(entry.status);
1096 });
1097 if (hold_statuses.includes(frm.doc.status)) {
1098 frm.dashboard.clear_headline();
Ankush Menatec74a5e2024-03-10 19:45:40 +05301099 let message = {
1100 indicator: "orange",
1101 msg: __("SLA is on hold since {0}", [
1102 moment(frm.doc.on_hold_since).fromNow(true),
1103 ]),
1104 };
Ankush Menatbd9ef742023-07-16 11:34:42 +05301105 frm.dashboard.set_headline_alert(
1106 '<div class="row">' +
1107 '<div class="col-xs-12">' +
Ankush Menatec74a5e2024-03-10 19:45:40 +05301108 '<span class="indicator whitespace-nowrap ' +
1109 message.indicator +
1110 '"><span>' +
1111 message.msg +
1112 "</span></span> " +
1113 "</div>" +
1114 "</div>"
Ankush Menatbd9ef742023-07-16 11:34:42 +05301115 );
1116 } else {
1117 set_time_to_resolve_and_response(frm, data.message.apply_sla_for_resolution);
1118 }
Ankush Menatec74a5e2024-03-10 19:45:40 +05301119 },
Ankush Menatbd9ef742023-07-16 11:34:42 +05301120 });
1121 } else if (frm.doc.service_level_agreement) {
1122 frm.dashboard.clear_headline();
1123
Ankush Menatec74a5e2024-03-10 19:45:40 +05301124 let agreement_status =
1125 frm.doc.agreement_status == "Fulfilled"
1126 ? { indicator: "green", msg: "Service Level Agreement has been fulfilled" }
1127 : { indicator: "red", msg: "Service Level Agreement Failed" };
Ankush Menatbd9ef742023-07-16 11:34:42 +05301128
1129 frm.dashboard.set_headline_alert(
1130 '<div class="row">' +
1131 '<div class="col-xs-12">' +
Ankush Menatec74a5e2024-03-10 19:45:40 +05301132 '<span class="indicator whitespace-nowrap ' +
1133 agreement_status.indicator +
1134 '"><span class="hidden-xs">' +
1135 agreement_status.msg +
1136 "</span></span> " +
1137 "</div>" +
1138 "</div>"
Ankush Menatbd9ef742023-07-16 11:34:42 +05301139 );
1140 }
1141 },
1142 });
Himanshuec25d592021-06-14 19:05:52 +05301143 });
1144});
1145
1146function set_time_to_resolve_and_response(frm, apply_sla_for_resolution) {
1147 frm.dashboard.clear_headline();
1148
Saqib24114772021-12-15 11:45:34 +05301149 let time_to_respond;
Saqib Ansari476e81a2021-12-06 18:55:30 +05301150 if (!frm.doc.first_responded_on) {
Himanshuec25d592021-06-14 19:05:52 +05301151 time_to_respond = get_time_left(frm.doc.response_by, frm.doc.agreement_status);
Saqib24114772021-12-15 11:45:34 +05301152 } else {
1153 time_to_respond = get_status(frm.doc.response_by, frm.doc.first_responded_on);
Himanshuec25d592021-06-14 19:05:52 +05301154 }
1155
1156 let alert = `
1157 <div class="row">
1158 <div class="col-xs-12 col-sm-6">
1159 <span class="indicator whitespace-nowrap ${time_to_respond.indicator}">
1160 <span>Time to Respond: ${time_to_respond.diff_display}</span>
1161 </span>
1162 </div>`;
1163
Himanshuec25d592021-06-14 19:05:52 +05301164 if (apply_sla_for_resolution) {
Saqib24114772021-12-15 11:45:34 +05301165 let time_to_resolve;
Saqib Ansari476e81a2021-12-06 18:55:30 +05301166 if (!frm.doc.resolution_date) {
Himanshuec25d592021-06-14 19:05:52 +05301167 time_to_resolve = get_time_left(frm.doc.resolution_by, frm.doc.agreement_status);
Saqib24114772021-12-15 11:45:34 +05301168 } else {
1169 time_to_resolve = get_status(frm.doc.resolution_by, frm.doc.resolution_date);
Himanshuec25d592021-06-14 19:05:52 +05301170 }
1171
1172 alert += `
1173 <div class="col-xs-12 col-sm-6">
1174 <span class="indicator whitespace-nowrap ${time_to_resolve.indicator}">
1175 <span>Time to Resolve: ${time_to_resolve.diff_display}</span>
1176 </span>
1177 </div>`;
1178 }
1179
Ankush Menatec74a5e2024-03-10 19:45:40 +05301180 alert += "</div>";
Himanshuec25d592021-06-14 19:05:52 +05301181
1182 frm.dashboard.set_headline_alert(alert);
1183}
1184
1185function get_time_left(timestamp, agreement_status) {
Ankush Menateaf86a62023-12-14 15:53:57 +05301186 const diff = moment(timestamp).diff(frappe.datetime.system_datetime(true));
Ankush Menatec74a5e2024-03-10 19:45:40 +05301187 const diff_display = diff >= 44500 ? moment.duration(diff).humanize() : "Failed";
1188 let indicator = diff_display == "Failed" && agreement_status != "Fulfilled" ? "red" : "green";
1189 return { diff_display: diff_display, indicator: indicator };
Himanshuec25d592021-06-14 19:05:52 +05301190}
1191
Saqib24114772021-12-15 11:45:34 +05301192function get_status(expected, actual) {
1193 const time_left = moment(expected).diff(moment(actual));
Saqib Ansari476e81a2021-12-06 18:55:30 +05301194 if (time_left >= 0) {
Ankush Menatec74a5e2024-03-10 19:45:40 +05301195 return { diff_display: "Fulfilled", indicator: "green" };
Himanshuec25d592021-06-14 19:05:52 +05301196 } else {
Ankush Menatec74a5e2024-03-10 19:45:40 +05301197 return { diff_display: "Failed", indicator: "red" };
Himanshuec25d592021-06-14 19:05:52 +05301198 }
1199}
1200
Alanc6dc9ea2021-05-07 20:30:04 +05301201function attach_selector_button(inner_text, append_loction, context, grid_row) {
Ankush Menatec74a5e2024-03-10 19:45:40 +05301202 let $btn_div = $("<div>").css({ "margin-bottom": "10px", "margin-top": "10px" }).appendTo(append_loction);
1203 let $btn = $(`<button class="btn btn-sm btn-default">${inner_text}</button>`).appendTo($btn_div);
Alanc6dc9ea2021-05-07 20:30:04 +05301204
Ankush Menatec74a5e2024-03-10 19:45:40 +05301205 $btn.on("click", function () {
Alanc6dc9ea2021-05-07 20:30:04 +05301206 context.show_serial_batch_selector(grid_row.frm, grid_row.doc, "", "", true);
1207 });
ruthra kumar5981c7e2023-08-29 13:19:26 +05301208}
rohitwaghchaure0da19a42024-03-12 12:27:21 +05301209
1210$.extend(erpnext.stock.utils, {
1211 set_item_details_using_barcode(frm, child_row, callback) {
1212 const barcode_scanner = new erpnext.utils.BarcodeScanner({ frm: frm });
1213 barcode_scanner.scan_api_call(child_row.barcode, callback);
1214 },
1215});