blob: 7e5dc32139a23ca1b979a5c7c1cc983fe02dae30 [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
Anand Doshi3543f302013-05-24 19:25:01 +05303
Rushabh Mehta793ba6b2014-02-14 15:47:51 +05304frappe.provide("erpnext");
Nabin Haitb4a3dfa2015-01-22 17:13:13 +05305frappe.require("assets/erpnext/js/controllers/taxes_and_totals.js");
Neil Trini Lasrado78fa6952014-10-03 17:43:02 +05306frappe.require("assets/erpnext/js/utils.js");
7
Nabin Haitb4a3dfa2015-01-22 17:13:13 +05308erpnext.TransactionController = erpnext.taxes_and_totals.extend({
Anand Doshi3543f302013-05-24 19:25:01 +05309 onload: function() {
Anand Doshi1e4fb682013-08-23 12:56:33 +053010 var me = this;
Anand Doshi3543f302013-05-24 19:25:01 +053011 if(this.frm.doc.__islocal) {
Anand Doshi1e4fb682013-08-23 12:56:33 +053012 var today = get_today(),
Nabin Hait73083dc2014-03-14 15:10:42 +053013 currency = frappe.defaults.get_user_default("currency");
Rushabh Mehtaff938022014-04-15 18:40:00 +053014
Anand Doshi3543f302013-05-24 19:25:01 +053015 $.each({
Anand Doshifc777182013-05-27 19:29:07 +053016 posting_date: today,
17 due_date: today,
18 transaction_date: today,
19 currency: currency,
20 price_list_currency: currency,
21 status: "Draft",
Anand Doshifc777182013-05-27 19:29:07 +053022 is_subcontracted: "No",
Anand Doshi3543f302013-05-24 19:25:01 +053023 }, function(fieldname, value) {
24 if(me.frm.fields_dict[fieldname] && !me.frm.doc[fieldname])
25 me.frm.set_value(fieldname, value);
Rushabh Mehtaff938022014-04-15 18:40:00 +053026 });
nabinhaitbc408d82014-07-07 16:51:52 +053027
nabinhaitb7392642014-07-28 14:55:08 +053028 if(this.frm.doc.company && !this.frm.doc.amended_from) {
nabinhaitbc408d82014-07-07 16:51:52 +053029 cur_frm.script_manager.trigger("company");
30 }
Anand Doshi3543f302013-05-24 19:25:01 +053031 }
Akhilesh Darjee564c6212013-10-17 11:31:11 +053032
Nabin Haitdd38a262014-12-26 13:15:21 +053033 if(this.frm.fields_dict["taxes"]) {
34 this["taxes_remove"] = this.calculate_taxes_and_totals;
Anand Doshia91c95f2013-08-23 13:00:47 +053035 }
Rushabh Mehtaff938022014-04-15 18:40:00 +053036
Nabin Haitdd38a262014-12-26 13:15:21 +053037 if(this.frm.fields_dict["items"]) {
38 this["items_remove"] = this.calculate_taxes_and_totals;
Anand Doshi1e4fb682013-08-23 12:56:33 +053039 }
Anand Doshi3543f302013-05-24 19:25:01 +053040 },
Rushabh Mehtaff938022014-04-15 18:40:00 +053041
Anand Doshi5e4e5d72013-08-06 17:23:44 +053042 onload_post_render: function() {
Akhilesh Darjee61b5c592013-10-15 20:24:34 +053043 var me = this;
Nabin Haitffc7f3f2015-05-12 15:07:02 +053044 if(this.frm.doc.__islocal && !(this.frm.doc.taxes || []).length
45 && !(this.frm.doc.__onload ? this.frm.doc.__onload.load_after_mapping : false)) {
46 this.apply_default_taxes();
47 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +053048
Nabin Haitdd38a262014-12-26 13:15:21 +053049 if(this.frm.doc.__islocal && this.frm.doc.company && this.frm.doc["items"] && !this.frm.doc.is_pos) {
Anand Doshib054eb72014-04-22 20:35:22 +053050 this.calculate_taxes_and_totals();
Anand Doshi5e4e5d72013-08-06 17:23:44 +053051 }
Nabin Haitdd38a262014-12-26 13:15:21 +053052 if(frappe.meta.get_docfield(this.frm.doc.doctype + " Item", "item_code")) {
53 cur_frm.get_field("items").grid.set_multiple_add("item_code", "qty");
Rushabh Mehtab6843f22014-06-04 13:10:41 +053054 }
Anand Doshi5e4e5d72013-08-06 17:23:44 +053055 },
Rushabh Mehtaff938022014-04-15 18:40:00 +053056
Anand Doshi3543f302013-05-24 19:25:01 +053057 refresh: function() {
Anand Doshi8bde7f92014-04-24 18:11:49 +053058 erpnext.toggle_naming_series();
Anand Doshibdee6e02013-07-09 13:03:39 +053059 erpnext.hide_company();
Nabin Hait239c2c32015-01-15 14:21:41 +053060 this.hide_currency_and_price_list()
Anand Doshi3543f302013-05-24 19:25:01 +053061 this.show_item_wise_taxes();
Nabin Hait1f996c32013-07-29 19:00:53 +053062 this.set_dynamic_labels();
Anand Doshi50d7e8c2015-01-06 17:14:13 +053063 erpnext.pos.make_pos_btn(this.frm);
Rushabh Mehta614e7ab2015-02-18 19:51:48 +053064 this.setup_sms();
65 },
Rushabh Mehta4a3c8052015-05-19 11:10:12 +053066
Nabin Haitffc7f3f2015-05-12 15:07:02 +053067 apply_default_taxes: function() {
68 var me = this;
Rushabh Mehta4984bcc2015-05-21 12:51:07 +053069 var taxes_and_charges_field = frappe.meta.get_docfield(me.frm.doc.doctype, "taxes_and_charges",
70 me.frm.doc.name);
71
72 if(taxes_and_charges_field) {
73 frappe.call({
74 method: "erpnext.controllers.accounts_controller.get_default_taxes_and_charges",
75 args: {
76 "master_doctype": taxes_and_charges_field.options
77 },
78 callback: function(r) {
79 if(!r.exc) {
80 me.frm.set_value("taxes", r.message);
81 }
Nabin Haitffc7f3f2015-05-12 15:07:02 +053082 }
Rushabh Mehta4984bcc2015-05-21 12:51:07 +053083 });
84 }
Nabin Haitffc7f3f2015-05-12 15:07:02 +053085 },
Rushabh Mehta614e7ab2015-02-18 19:51:48 +053086
87 setup_sms: function() {
88 var me = this;
Rushabh Mehta4a3c8052015-05-19 11:10:12 +053089 if(this.frm.doc.docstatus===1 && !in_list(["Lost", "Stopped"], this.frm.doc.status)
90 && this.frm.doctype != "Purchase Invoice") {
Rushabh Mehta614e7ab2015-02-18 19:51:48 +053091 this.frm.page.add_menu_item(__('Send SMS'), function() { me.send_sms(); });
92 }
93 },
94
95 send_sms: function() {
96 frappe.require("assets/erpnext/js/sms_manager.js");
Rushabh Mehta4a3c8052015-05-19 11:10:12 +053097 var sms_man = new SMSManager(this.frm.doc);
Nabin Hait239c2c32015-01-15 14:21:41 +053098 },
Anand Doshi50d7e8c2015-01-06 17:14:13 +053099
Nabin Hait239c2c32015-01-15 14:21:41 +0530100 hide_currency_and_price_list: function() {
101 if(this.frm.doc.docstatus > 0) {
102 hide_field("currency_and_price_list");
103 } else {
104 unhide_field("currency_and_price_list");
105 }
Akhilesh Darjee6773bc22013-09-17 11:56:17 +0530106 },
107
Nabin Hait139dc7b2014-02-12 14:53:18 +0530108 item_code: function(doc, cdt, cdn) {
109 var me = this;
Rushabh Mehta66d52b52014-03-27 14:17:33 +0530110 var item = frappe.get_doc(cdt, cdn);
Nabin Hait139dc7b2014-02-12 14:53:18 +0530111 if(item.item_code || item.barcode || item.serial_no) {
112 if(!this.validate_company_and_party()) {
Nabin Haitdd38a262014-12-26 13:15:21 +0530113 cur_frm.fields_dict["items"].grid.grid_rows[item.idx - 1].remove();
Nabin Hait139dc7b2014-02-12 14:53:18 +0530114 } else {
115 return this.frm.call({
116 method: "erpnext.stock.get_item_details.get_item_details",
117 child: item,
118 args: {
119 args: {
120 item_code: item.item_code,
121 barcode: item.barcode,
122 serial_no: item.serial_no,
123 warehouse: item.warehouse,
Nabin Hait444f9562014-06-20 15:59:49 +0530124 parenttype: me.frm.doc.doctype,
125 parent: me.frm.doc.name,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530126 customer: me.frm.doc.customer,
127 supplier: me.frm.doc.supplier,
128 currency: me.frm.doc.currency,
129 conversion_rate: me.frm.doc.conversion_rate,
130 price_list: me.frm.doc.selling_price_list ||
131 me.frm.doc.buying_price_list,
132 price_list_currency: me.frm.doc.price_list_currency,
133 plc_conversion_rate: me.frm.doc.plc_conversion_rate,
134 company: me.frm.doc.company,
135 order_type: me.frm.doc.order_type,
136 is_pos: cint(me.frm.doc.is_pos),
137 is_subcontracted: me.frm.doc.is_subcontracted,
Nabin Haita1bf43b2015-03-17 10:50:47 +0530138 transaction_date: me.frm.doc.transaction_date || me.frm.doc.posting_date,
Nabin Hait444f9562014-06-20 15:59:49 +0530139 ignore_pricing_rule: me.frm.doc.ignore_pricing_rule,
140 doctype: item.doctype,
Anand Doshi43f087c2014-08-26 14:25:53 +0530141 name: item.name,
Anand Doshi9b955fe2015-01-05 16:19:12 +0530142 project_name: item.project_name || me.frm.doc.project_name,
143 qty: item.qty
Nabin Hait139dc7b2014-02-12 14:53:18 +0530144 }
145 },
Anand Doshi13945092014-09-21 19:45:49 +0530146
Nabin Hait139dc7b2014-02-12 14:53:18 +0530147 callback: function(r) {
148 if(!r.exc) {
149 me.frm.script_manager.trigger("price_list_rate", cdt, cdn);
150 }
151 }
152 });
153 }
154 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530155 },
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530156
157 serial_no: function(doc, cdt, cdn) {
158 var me = this;
Rushabh Mehta66d52b52014-03-27 14:17:33 +0530159 var item = frappe.get_doc(cdt, cdn);
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530160
161 if (item.serial_no) {
162 if (!item.item_code) {
163 this.frm.script_manager.trigger("item_code", cdt, cdn);
164 }
165 else {
166 var sr_no = [];
167
168 // Replacing all occurences of comma with carriage return
169 var serial_nos = item.serial_no.trim().replace(/,/g, '\n');
170
171 serial_nos = serial_nos.trim().split('\n');
Rushabh Mehtaff938022014-04-15 18:40:00 +0530172
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530173 // Trim each string and push unique string to new list
174 for (var x=0; x<=serial_nos.length - 1; x++) {
175 if (serial_nos[x].trim() != "" && sr_no.indexOf(serial_nos[x].trim()) == -1) {
176 sr_no.push(serial_nos[x].trim());
177 }
178 }
179
180 // Add the new list to the serial no. field in grid with each in new line
181 item.serial_no = "";
182 for (var x=0; x<=sr_no.length - 1; x++)
183 item.serial_no += sr_no[x] + '\n';
184
185 refresh_field("serial_no", item.name, item.parentfield);
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530186 frappe.model.set_value(item.doctype, item.name, "qty", sr_no.length);
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530187 }
188 }
189 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530190
Anand Doshi923d41d2013-05-28 17:23:36 +0530191 validate: function() {
Anand Doshi652bc072014-04-16 15:21:46 +0530192 this.calculate_taxes_and_totals(false);
Anand Doshi923d41d2013-05-28 17:23:36 +0530193 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530194
Anand Doshi3543f302013-05-24 19:25:01 +0530195 company: function() {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530196 var me = this;
197 var fn = function() {
198 if(me.frm.doc.company && me.frm.fields_dict.currency) {
199 var company_currency = me.get_company_currency();
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530200 var company_doc = frappe.get_doc(":Company", me.frm.doc.company);
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530201 if (!me.frm.doc.currency) {
202 me.frm.set_value("currency", company_currency);
203 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530204
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530205 if (me.frm.doc.currency == company_currency) {
206 me.frm.set_value("conversion_rate", 1.0);
207 }
208 if (me.frm.doc.price_list_currency == company_currency) {
209 me.frm.set_value('plc_conversion_rate', 1.0);
210 }
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530211 if (company_doc.default_letter_head) {
212 me.frm.set_value("letter_head", company_doc.default_letter_head);
213 }
214 if (company_doc.default_terms) {
215 me.frm.set_value("tc_name", company_doc.default_terms);
216 }
Akhilesh Darjee1797cfe2013-10-11 13:34:10 +0530217
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530218 me.frm.script_manager.trigger("currency");
219 me.apply_pricing_rule();
Nabin Haitdd38a262014-12-26 13:15:21 +0530220 }
Anand Doshi3543f302013-05-24 19:25:01 +0530221 }
Nabin Haitdd38a262014-12-26 13:15:21 +0530222
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530223 if (this.frm.doc.posting_date) var date = this.frm.doc.posting_date;
224 else var date = this.frm.doc.transaction_date;
225 erpnext.get_fiscal_year(this.frm.doc.company, date, fn);
Rushabh Mehta45ca8a42015-04-28 16:02:09 +0530226
227 if(this.frm.doc.company) {
228 erpnext.last_selected_company = this.frm.doc.company;
229 }
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530230 },
231
232 transaction_date: function() {
233 erpnext.get_fiscal_year(this.frm.doc.company, this.frm.doc.transaction_date);
Neil Trini Lasrado78fa6952014-10-03 17:43:02 +0530234 },
235
236 posting_date: function() {
Neil Trini Lasrado565d9862014-10-07 18:26:39 +0530237 erpnext.get_fiscal_year(this.frm.doc.company, this.frm.doc.posting_date);
Anand Doshi3543f302013-05-24 19:25:01 +0530238 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530239
Anand Doshi3543f302013-05-24 19:25:01 +0530240 get_company_currency: function() {
241 return erpnext.get_currency(this.frm.doc.company);
242 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530243
Anand Doshi3543f302013-05-24 19:25:01 +0530244 currency: function() {
Anand Doshi61a2f682013-06-21 17:55:31 +0530245 var me = this;
246 this.set_dynamic_labels();
Akhilesh Darjee78378272013-10-11 19:06:30 +0530247
Anand Doshi61a2f682013-06-21 17:55:31 +0530248 var company_currency = this.get_company_currency();
Nabin Hait69cdf592015-05-02 18:46:10 +0530249 // Added `ignore_pricing_rule` to determine if document is loading after mapping from another doc
Pratik Vyas1a84d8e2015-05-19 12:23:52 +0530250 if(this.frm.doc.currency !== company_currency && !this.frm.doc.ignore_pricing_rule) {
Rushabh Mehtaff938022014-04-15 18:40:00 +0530251 this.get_exchange_rate(this.frm.doc.currency, company_currency,
Anand Doshi61a2f682013-06-21 17:55:31 +0530252 function(exchange_rate) {
Akhilesh Darjee78378272013-10-11 19:06:30 +0530253 me.frm.set_value("conversion_rate", exchange_rate);
Anand Doshi61a2f682013-06-21 17:55:31 +0530254 });
255 } else {
Rushabh Mehtaff938022014-04-15 18:40:00 +0530256 this.conversion_rate();
Anand Doshi61a2f682013-06-21 17:55:31 +0530257 }
258 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530259
Anand Doshi61a2f682013-06-21 17:55:31 +0530260 conversion_rate: function() {
Anand Doshi535d8332013-07-19 13:51:07 +0530261 if(this.frm.doc.currency === this.get_company_currency()) {
262 this.frm.set_value("conversion_rate", 1.0);
Akhilesh Darjeeacf65a72013-10-17 13:04:26 +0530263 }
264 if(this.frm.doc.currency === this.frm.doc.price_list_currency &&
Anand Doshi61a2f682013-06-21 17:55:31 +0530265 this.frm.doc.plc_conversion_rate !== this.frm.doc.conversion_rate) {
266 this.frm.set_value("plc_conversion_rate", this.frm.doc.conversion_rate);
267 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +0530268
Nabin Haita3dd72a2014-05-28 12:49:20 +0530269 if(flt(this.frm.doc.conversion_rate)>0.0) {
Nabin Hait444f9562014-06-20 15:59:49 +0530270 if(this.frm.doc.ignore_pricing_rule) {
271 this.calculate_taxes_and_totals();
Anand Doshi51f722d2014-07-04 15:44:26 +0530272 } else if (!this.in_apply_price_list){
273 this.apply_price_list();
Nabin Hait444f9562014-06-20 15:59:49 +0530274 }
275
Nabin Haita3dd72a2014-05-28 12:49:20 +0530276 }
Anand Doshi3543f302013-05-24 19:25:01 +0530277 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530278
Anand Doshi61a2f682013-06-21 17:55:31 +0530279 get_exchange_rate: function(from_currency, to_currency, callback) {
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +0530280 frappe.call({
281 method: "erpnext.setup.utils.get_exchange_rate",
282 args: {
283 from_currency: from_currency,
284 to_currency: to_currency
285 },
286 callback: function(r) {
287 callback(flt(r.message));
288 }
Anand Doshi61a2f682013-06-21 17:55:31 +0530289 });
290 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530291
Anand Doshi3543f302013-05-24 19:25:01 +0530292 price_list_currency: function() {
Akhilesh Darjeedb59ffb2013-09-11 13:05:24 +0530293 var me=this;
Anand Doshi3543f302013-05-24 19:25:01 +0530294 this.set_dynamic_labels();
Nabin Haitec361ea2015-05-11 18:14:45 +0530295
296 var company_currency = this.get_company_currency();
297 // Added `ignore_pricing_rule` to determine if document is loading after mapping from another doc
298 if(this.frm.doc.price_list_currency !== company_currency && !this.frm.doc.ignore_pricing_rule) {
299 this.get_exchange_rate(this.frm.doc.price_list_currency, company_currency,
300 function(exchange_rate) {
301 me.frm.set_value("plc_conversion_rate", exchange_rate);
302 });
303 } else {
304 this.plc_conversion_rate();
305 }
Anand Doshi3543f302013-05-24 19:25:01 +0530306 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530307
Anand Doshi3543f302013-05-24 19:25:01 +0530308 plc_conversion_rate: function() {
Anand Doshi61a2f682013-06-21 17:55:31 +0530309 if(this.frm.doc.price_list_currency === this.get_company_currency()) {
310 this.frm.set_value("plc_conversion_rate", 1.0);
Nabin Haitec361ea2015-05-11 18:14:45 +0530311 } else if(this.frm.doc.price_list_currency === this.frm.doc.currency && this.frm.doc.plc_conversion_rate && cint(this.frm.doc.plc_conversion_rate) != 1 &&
312 cint(this.frm.doc.plc_conversion_rate) != cint(this.frm.doc.conversion_rate)) {
313 this.frm.set_value("conversion_rate", this.frm.doc.plc_conversion_rate);
Akhilesh Darjee564c6212013-10-17 11:31:11 +0530314 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +0530315
Nabin Haitec361ea2015-05-11 18:14:45 +0530316 if(!this.in_apply_price_list) {
317 this.apply_price_list();
Anand Doshi61a2f682013-06-21 17:55:31 +0530318 }
Anand Doshi3543f302013-05-24 19:25:01 +0530319 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530320
Anand Doshi3543f302013-05-24 19:25:01 +0530321 qty: function(doc, cdt, cdn) {
Nabin Hait444f9562014-06-20 15:59:49 +0530322 this.apply_pricing_rule(frappe.get_doc(cdt, cdn), true);
Anand Doshi3543f302013-05-24 19:25:01 +0530323 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530324
Anand Doshi61a2f682013-06-21 17:55:31 +0530325 set_dynamic_labels: function() {
326 // What TODO? should we make price list system non-mandatory?
327 this.frm.toggle_reqd("plc_conversion_rate",
328 !!(this.frm.doc.price_list_name && this.frm.doc.price_list_currency));
Rushabh Mehtaff938022014-04-15 18:40:00 +0530329
Anand Doshi61a2f682013-06-21 17:55:31 +0530330 var company_currency = this.get_company_currency();
331 this.change_form_labels(company_currency);
332 this.change_grid_labels(company_currency);
Anand Doshi5013dcb2013-08-05 12:16:04 +0530333 this.frm.refresh_fields();
Anand Doshi61a2f682013-06-21 17:55:31 +0530334 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530335
Nabin Hait613d0812015-02-23 11:58:15 +0530336 change_form_labels: function(company_currency) {
337 var me = this;
338 var field_label_map = {};
339
340 var setup_field_label_map = function(fields_list, currency) {
341 $.each(fields_list, function(i, fname) {
342 var docfield = frappe.meta.docfield_map[me.frm.doc.doctype][fname];
343 if(docfield) {
344 var label = __(docfield.label || "").replace(/\([^\)]*\)/g, "");
345 field_label_map[fname] = label.trim() + " (" + currency + ")";
346 }
347 });
348 };
349 setup_field_label_map(["base_total", "base_net_total", "base_total_taxes_and_charges",
350 "base_discount_amount", "base_grand_total", "base_rounded_total", "base_in_words",
351 "base_taxes_and_charges_added", "base_taxes_and_charges_deducted", "total_amount_to_pay",
Nabin Hait37b047d2015-02-23 16:01:33 +0530352 "outstanding_amount", "total_advance", "paid_amount", "write_off_amount"], company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +0530353
354 setup_field_label_map(["total", "net_total", "total_taxes_and_charges", "discount_amount",
355 "grand_total", "taxes_and_charges_added", "taxes_and_charges_deducted",
356 "rounded_total", "in_words"], this.frm.doc.currency);
357
358 cur_frm.set_df_property("conversion_rate", "description", "1 " + this.frm.doc.currency
359 + " = [?] " + company_currency)
360
361 if(this.frm.doc.price_list_currency && this.frm.doc.price_list_currency!=company_currency) {
362 cur_frm.set_df_property("plc_conversion_rate", "description", "1 " + this.frm.doc.price_list_currency
363 + " = [?] " + company_currency)
364 }
365
366 // toggle fields
367 this.frm.toggle_display(["conversion_rate", "base_total", "base_net_total", "base_total_taxes_and_charges",
368 "base_taxes_and_charges_added", "base_taxes_and_charges_deducted",
369 "base_grand_total", "base_rounded_total", "base_in_words", "base_discount_amount"],
370 this.frm.doc.currency != company_currency);
371
372 this.frm.toggle_display(["plc_conversion_rate", "price_list_currency"],
373 this.frm.doc.price_list_currency != company_currency);
374
375 // set labels
376 $.each(field_label_map, function(fname, label) {
377 me.frm.fields_dict[fname].set_label(label);
378 });
Nabin Hait37b047d2015-02-23 16:01:33 +0530379
Nabin Hait903c42a2015-02-24 15:24:49 +0530380 var show =cint(cur_frm.doc.discount_amount) ||
381 ((cur_frm.doc.taxes || []).filter(function(d) {return d.included_in_print_rate===1}).length);
382
383 if(frappe.meta.get_docfield(cur_frm.doctype, "net_total"))
384 cur_frm.toggle_display("net_total", show);
385
386 if(frappe.meta.get_docfield(cur_frm.doctype, "base_net_total"))
387 cur_frm.toggle_display("base_net_total", (show && (me.frm.doc.currency != company_currency)));
388
Nabin Hait613d0812015-02-23 11:58:15 +0530389 },
390
391 change_grid_labels: function(company_currency) {
392 var me = this;
393 var field_label_map = {};
394
395 var setup_field_label_map = function(fields_list, currency, parentfield) {
396 var grid_doctype = me.frm.fields_dict[parentfield].grid.doctype;
397 $.each(fields_list, function(i, fname) {
398 var docfield = frappe.meta.docfield_map[grid_doctype][fname];
399 if(docfield) {
400 var label = __(docfield.label || "").replace(/\([^\)]*\)/g, "");
401 field_label_map[grid_doctype + "-" + fname] =
402 label.trim() + " (" + currency + ")";
403 }
404 });
405 }
406
407 setup_field_label_map(["base_rate", "base_net_rate", "base_price_list_rate", "base_amount", "base_net_amount"],
408 company_currency, "items");
409
410 setup_field_label_map(["rate", "net_rate", "price_list_rate", "amount", "net_amount"],
411 this.frm.doc.currency, "items");
412
413 if(this.frm.fields_dict["taxes"]) {
414 setup_field_label_map(["tax_amount", "total", "tax_amount_after_discount"], this.frm.doc.currency, "taxes");
415
416 setup_field_label_map(["base_tax_amount", "base_total", "base_tax_amount_after_discount"], company_currency, "taxes");
417 }
418
419 if(this.frm.fields_dict["advances"]) {
420 setup_field_label_map(["advance_amount", "allocated_amount"], company_currency, "advances");
421 }
422
423 // toggle columns
424 var item_grid = this.frm.fields_dict["items"].grid;
425 $.each(["base_rate", "base_price_list_rate", "base_amount"], function(i, fname) {
426 if(frappe.meta.get_docfield(item_grid.doctype, fname))
427 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
428 });
429
430 var show = (cint(cur_frm.doc.discount_amount)) ||
431 ((cur_frm.doc.taxes || []).filter(function(d) {return d.included_in_print_rate===1}).length);
432
433 $.each(["net_rate", "net_amount"], function(i, fname) {
434 if(frappe.meta.get_docfield(item_grid.doctype, fname))
435 item_grid.set_column_disp(fname, show);
436 });
437
438 $.each(["base_net_rate", "base_net_amount"], function(i, fname) {
439 if(frappe.meta.get_docfield(item_grid.doctype, fname))
440 item_grid.set_column_disp(fname, (show && (me.frm.doc.currency != company_currency)));
441 });
442
443 // set labels
444 var $wrapper = $(this.frm.wrapper);
445 $.each(field_label_map, function(fname, label) {
446 fname = fname.split("-");
447 var df = frappe.meta.get_docfield(fname[0], fname[1], me.frm.doc.name);
448 if(df) df.label = label;
449 });
450 },
451
Anand Doshi923d41d2013-05-28 17:23:36 +0530452 recalculate: function() {
453 this.calculate_taxes_and_totals();
454 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530455
Anand Doshi923d41d2013-05-28 17:23:36 +0530456 recalculate_values: function() {
457 this.calculate_taxes_and_totals();
458 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530459
Anand Doshid0b00722013-05-28 18:54:48 +0530460 calculate_charges: function() {
461 this.calculate_taxes_and_totals();
462 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530463
Nabin Hait444f9562014-06-20 15:59:49 +0530464 ignore_pricing_rule: function() {
465 this.apply_pricing_rule();
466 },
467
468 apply_pricing_rule: function(item, calculate_taxes_and_totals) {
Nabin Haita3dd72a2014-05-28 12:49:20 +0530469 var me = this;
Anand Doshidffec8f2014-07-01 17:45:15 +0530470 return this.frm.call({
471 method: "erpnext.accounts.doctype.pricing_rule.pricing_rule.apply_pricing_rule",
472 args: { args: this._get_args(item) },
473 callback: function(r) {
Anand Doshif214bfc2014-07-16 17:52:08 +0530474 if (!r.exc && r.message) {
Anand Doshidffec8f2014-07-01 17:45:15 +0530475 me._set_values_for_item_list(r.message);
476 if(calculate_taxes_and_totals) me.calculate_taxes_and_totals();
477 }
478 }
479 });
480 },
481
482 _get_args: function(item) {
483 var me = this;
484 return {
485 "item_list": this._get_item_list(item),
Nabin Hait444f9562014-06-20 15:59:49 +0530486 "customer": me.frm.doc.customer,
487 "customer_group": me.frm.doc.customer_group,
488 "territory": me.frm.doc.territory,
489 "supplier": me.frm.doc.supplier,
490 "supplier_type": me.frm.doc.supplier_type,
491 "currency": me.frm.doc.currency,
492 "conversion_rate": me.frm.doc.conversion_rate,
493 "price_list": me.frm.doc.selling_price_list || me.frm.doc.buying_price_list,
Nabin Haitdd82bf22015-05-11 16:49:17 +0530494 "price_list_currency": me.frm.doc.price_list_currency,
Nabin Hait444f9562014-06-20 15:59:49 +0530495 "plc_conversion_rate": me.frm.doc.plc_conversion_rate,
496 "company": me.frm.doc.company,
497 "transaction_date": me.frm.doc.transaction_date || me.frm.doc.posting_date,
498 "campaign": me.frm.doc.campaign,
499 "sales_partner": me.frm.doc.sales_partner,
500 "ignore_pricing_rule": me.frm.doc.ignore_pricing_rule,
501 "parenttype": me.frm.doc.doctype,
502 "parent": me.frm.doc.name
503 };
Nabin Hait444f9562014-06-20 15:59:49 +0530504 },
505
506 _get_item_list: function(item) {
507 var item_list = [];
508 var append_item = function(d) {
Anand Doshi39edcbc2014-07-28 16:00:19 +0530509 if (d.item_code) {
510 item_list.push({
511 "doctype": d.doctype,
512 "name": d.name,
513 "item_code": d.item_code,
514 "item_group": d.item_group,
515 "brand": d.brand,
516 "qty": d.qty
517 });
518 }
Nabin Hait444f9562014-06-20 15:59:49 +0530519 };
Nabin Haita3dd72a2014-05-28 12:49:20 +0530520
Nabin Hait444f9562014-06-20 15:59:49 +0530521 if (item) {
522 append_item(item);
Nabin Haitc1367d92014-05-30 11:43:00 +0530523 } else {
Nabin Hait96339342015-01-21 17:22:11 +0530524 $.each(this.frm.doc["items"] || [], function(i, d) {
Nabin Hait444f9562014-06-20 15:59:49 +0530525 append_item(d);
Nabin Haita3dd72a2014-05-28 12:49:20 +0530526 });
527 }
Nabin Hait444f9562014-06-20 15:59:49 +0530528 return item_list;
Nabin Haita3dd72a2014-05-28 12:49:20 +0530529 },
530
Anand Doshidffec8f2014-07-01 17:45:15 +0530531 _set_values_for_item_list: function(children) {
Nabin Hait49a27292014-12-17 11:21:32 +0530532 var me = this;
Nabin Hait7d8fa802014-12-30 15:35:45 +0530533 var price_list_rate_changed = false;
Anand Doshidea3fb02015-02-05 15:05:58 +0530534 for(var i=0, l=children.length; i<l; i++) {
535 var d = children[i];
Nabin Hait49a27292014-12-17 11:21:32 +0530536 var existing_pricing_rule = frappe.model.get_value(d.doctype, d.name, "pricing_rule");
Anand Doshidea3fb02015-02-05 15:05:58 +0530537
538 for(var k in d) {
539 var v = d[k];
Anand Doshidffec8f2014-07-01 17:45:15 +0530540 if (["doctype", "name"].indexOf(k)===-1) {
Nabin Hait7d8fa802014-12-30 15:35:45 +0530541 if(k=="price_list_rate") {
542 if(flt(v) != flt(d.price_list_rate)) price_list_rate_changed = true;
543 }
Anand Doshidffec8f2014-07-01 17:45:15 +0530544 frappe.model.set_value(d.doctype, d.name, k, v);
545 }
Anand Doshidea3fb02015-02-05 15:05:58 +0530546 }
547
Nabin Hait49a27292014-12-17 11:21:32 +0530548 // if pricing rule set as blank from an existing value, apply price_list
Nabin Haitcfe3c542014-12-22 10:42:48 +0530549 if(!me.frm.doc.ignore_pricing_rule && existing_pricing_rule && !d.pricing_rule) {
Nabin Hait49a27292014-12-17 11:21:32 +0530550 me.apply_price_list(frappe.get_doc(d.doctype, d.name));
551 }
Anand Doshidea3fb02015-02-05 15:05:58 +0530552 }
Nabin Hait7d8fa802014-12-30 15:35:45 +0530553
Anand Doshidea3fb02015-02-05 15:05:58 +0530554 if(!price_list_rate_changed) me.calculate_taxes_and_totals();
Anand Doshidffec8f2014-07-01 17:45:15 +0530555 },
556
Nabin Hait49a27292014-12-17 11:21:32 +0530557 apply_price_list: function(item) {
Anand Doshidffec8f2014-07-01 17:45:15 +0530558 var me = this;
Rushabh Mehta052bd622015-01-30 16:57:24 +0530559 var args = this._get_args(item);
Nabin Hait37b047d2015-02-23 16:01:33 +0530560
Anand Doshidffec8f2014-07-01 17:45:15 +0530561 return this.frm.call({
562 method: "erpnext.stock.get_item_details.apply_price_list",
Rushabh Mehta052bd622015-01-30 16:57:24 +0530563 args: { args: args },
Anand Doshidffec8f2014-07-01 17:45:15 +0530564 callback: function(r) {
565 if (!r.exc) {
Anand Doshi51f722d2014-07-04 15:44:26 +0530566 me.in_apply_price_list = true;
Anand Doshidffec8f2014-07-01 17:45:15 +0530567 me.frm.set_value("price_list_currency", r.message.parent.price_list_currency);
568 me.frm.set_value("plc_conversion_rate", r.message.parent.plc_conversion_rate);
Anand Doshi51f722d2014-07-04 15:44:26 +0530569 me.in_apply_price_list = false;
Nabin Hait37b047d2015-02-23 16:01:33 +0530570
571 if(args.item_list.length) {
572 me._set_values_for_item_list(r.message.children);
573 }
Anand Doshidffec8f2014-07-01 17:45:15 +0530574 }
575 }
576 });
577 },
578
Anand Doshi3543f302013-05-24 19:25:01 +0530579 get_item_wise_taxes_html: function() {
580 var item_tax = {};
581 var tax_accounts = [];
582 var company_currency = this.get_company_currency();
Rushabh Mehtaff938022014-04-15 18:40:00 +0530583
Nabin Hait96339342015-01-21 17:22:11 +0530584 $.each(this.frm.doc["taxes"] || [], function(i, tax) {
Anand Doshi3543f302013-05-24 19:25:01 +0530585 var tax_amount_precision = precision("tax_amount", tax);
Anand Doshi53b73422013-05-31 11:50:01 +0530586 var tax_rate_precision = precision("rate", tax);
Rushabh Mehtaff938022014-04-15 18:40:00 +0530587 $.each(JSON.parse(tax.item_wise_tax_detail || '{}'),
Anand Doshi53b73422013-05-31 11:50:01 +0530588 function(item_code, tax_data) {
Anand Doshi3543f302013-05-24 19:25:01 +0530589 if(!item_tax[item_code]) item_tax[item_code] = {};
Anand Doshi53b73422013-05-31 11:50:01 +0530590 if($.isArray(tax_data)) {
Anand Doshi1e4fb682013-08-23 12:56:33 +0530591 var tax_rate = "";
592 if(tax_data[0] != null) {
593 tax_rate = (tax.charge_type === "Actual") ?
594 format_currency(flt(tax_data[0], tax_amount_precision), company_currency, tax_amount_precision) :
595 (flt(tax_data[0], tax_rate_precision) + "%");
596 }
597 var tax_amount = format_currency(flt(tax_data[1], tax_amount_precision), company_currency,
598 tax_amount_precision);
Rushabh Mehtaff938022014-04-15 18:40:00 +0530599
Anand Doshiaa71b5b2013-08-05 13:00:53 +0530600 item_tax[item_code][tax.name] = [tax_rate, tax_amount];
Anand Doshi53b73422013-05-31 11:50:01 +0530601 } else {
Anand Doshiaa71b5b2013-08-05 13:00:53 +0530602 item_tax[item_code][tax.name] = [flt(tax_data, tax_rate_precision) + "%", ""];
Anand Doshi53b73422013-05-31 11:50:01 +0530603 }
Anand Doshi3543f302013-05-24 19:25:01 +0530604 });
Anand Doshiaa71b5b2013-08-05 13:00:53 +0530605 tax_accounts.push([tax.name, tax.account_head]);
Anand Doshi3543f302013-05-24 19:25:01 +0530606 });
Rushabh Mehtaff938022014-04-15 18:40:00 +0530607
608 var headings = $.map([__("Item Name")].concat($.map(tax_accounts, function(head) { return head[1]; })),
Anand Doshi3543f302013-05-24 19:25:01 +0530609 function(head) { return '<th style="min-width: 100px;">' + (head || "") + "</th>" }).join("\n");
Rushabh Mehtaff938022014-04-15 18:40:00 +0530610
Anand Doshi179e3772013-09-05 16:53:57 +0530611 var distinct_item_names = [];
612 var distinct_items = [];
Nabin Hait96339342015-01-21 17:22:11 +0530613 $.each(this.frm.doc["items"] || [], function(i, item) {
Anand Doshi179e3772013-09-05 16:53:57 +0530614 if(distinct_item_names.indexOf(item.item_code || item.item_name)===-1) {
615 distinct_item_names.push(item.item_code || item.item_name);
616 distinct_items.push(item);
617 }
618 });
Rushabh Mehtaff938022014-04-15 18:40:00 +0530619
Anand Doshi179e3772013-09-05 16:53:57 +0530620 var rows = $.map(distinct_items, function(item) {
Anand Doshi3543f302013-05-24 19:25:01 +0530621 var item_tax_record = item_tax[item.item_code || item.item_name];
Anand Doshi53b73422013-05-31 11:50:01 +0530622 if(!item_tax_record) { return null; }
Anand Doshi3543f302013-05-24 19:25:01 +0530623 return repl("<tr><td>%(item_name)s</td>%(taxes)s</tr>", {
624 item_name: item.item_name,
625 taxes: $.map(tax_accounts, function(head) {
Anand Doshiaa71b5b2013-08-05 13:00:53 +0530626 return item_tax_record[head[0]] ?
627 "<td>(" + item_tax_record[head[0]][0] + ") " + item_tax_record[head[0]][1] + "</td>" :
Anand Doshi64f316b2013-07-17 15:12:22 +0530628 "<td></td>";
Anand Doshi3543f302013-05-24 19:25:01 +0530629 }).join("\n")
630 });
631 }).join("\n");
Rushabh Mehtaff938022014-04-15 18:40:00 +0530632
Anand Doshi53b73422013-05-31 11:50:01 +0530633 if(!rows) return "";
Rushabh Mehta7d8b1892013-11-08 16:27:18 +0530634 return '<p><a href="#" onclick="$(\'.tax-break-up\').toggleClass(\'hide\'); return false;">Show / Hide tax break-up</a><br><br></p>\
635 <div class="tax-break-up hide" style="overflow-x: auto;"><table class="table table-bordered table-hover">\
Anand Doshi3543f302013-05-24 19:25:01 +0530636 <thead><tr>' + headings + '</tr></thead> \
637 <tbody>' + rows + '</tbody> \
638 </table></div>';
639 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530640
Nabin Hait139dc7b2014-02-12 14:53:18 +0530641 validate_company_and_party: function() {
Anand Doshi923d41d2013-05-28 17:23:36 +0530642 var me = this;
Anand Doshi3543f302013-05-24 19:25:01 +0530643 var valid = true;
Rushabh Mehtaff938022014-04-15 18:40:00 +0530644
Nabin Hait0f231062014-02-20 11:27:47 +0530645 $.each(["company", "customer"], function(i, fieldname) {
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530646 if(frappe.meta.has_field(me.frm.doc.doctype, fieldname)) {
Nabin Hait139dc7b2014-02-12 14:53:18 +0530647 if (!me.frm.doc[fieldname]) {
Rushabh Mehtaff938022014-04-15 18:40:00 +0530648 msgprint(__("Please specify") + ": " +
649 frappe.meta.get_label(me.frm.doc.doctype, fieldname, me.frm.doc.name) +
Pratik Vyasb52618c2014-04-14 16:25:30 +0530650 ". " + __("It is needed to fetch Item Details."));
Nabin Hait139dc7b2014-02-12 14:53:18 +0530651 valid = false;
652 }
Anand Doshi3543f302013-05-24 19:25:01 +0530653 }
654 });
655 return valid;
656 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530657
Anand Doshibf3e54a2013-06-05 14:11:32 +0530658 get_terms: function() {
659 var me = this;
660 if(this.frm.doc.tc_name) {
Anand Doshi1fac2a92013-07-29 19:30:39 +0530661 return this.frm.call({
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530662 method: "frappe.client.get_value",
Anand Doshibf3e54a2013-06-05 14:11:32 +0530663 args: {
664 doctype: "Terms and Conditions",
665 fieldname: "terms",
666 filters: { name: this.frm.doc.tc_name },
667 },
668 });
669 }
670 },
Akhilesh Darjee4f721562014-01-29 16:31:38 +0530671
672 taxes_and_charges: function() {
673 var me = this;
674 if(this.frm.doc.taxes_and_charges) {
675 return this.frm.call({
Nabin Hait6b039142014-05-02 15:45:10 +0530676 method: "erpnext.controllers.accounts_controller.get_taxes_and_charges",
677 args: {
Nabin Hait03f3a8a2014-05-13 16:38:31 +0530678 "master_doctype": frappe.meta.get_docfield(this.frm.doc.doctype, "taxes_and_charges",
679 this.frm.doc.name).options,
Nabin Hait6b039142014-05-02 15:45:10 +0530680 "master_name": this.frm.doc.taxes_and_charges,
Nabin Hait6b039142014-05-02 15:45:10 +0530681 },
Akhilesh Darjee4f721562014-01-29 16:31:38 +0530682 callback: function(r) {
683 if(!r.exc) {
Nabin Haitdd38a262014-12-26 13:15:21 +0530684 me.frm.set_value("taxes", r.message);
Akhilesh Darjee4f721562014-01-29 16:31:38 +0530685 me.calculate_taxes_and_totals();
686 }
687 }
688 });
Nabin Haitbc83b9c2014-05-02 17:03:18 +0530689 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +0530690 },
691
692 show_item_wise_taxes: function() {
693 if(this.frm.fields_dict.other_charges_calculation) {
Anand Doshidd942bb2015-02-04 18:52:35 +0530694 var html = this.get_item_wise_taxes_html();
695 if (html) {
696 this.frm.toggle_display("other_charges_calculation", true);
697 $(this.frm.fields_dict.other_charges_calculation.wrapper).html(html);
698 } else {
699 this.frm.toggle_display("other_charges_calculation", false);
700 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +0530701 }
702 },
Anand Doshi13945092014-09-21 19:45:49 +0530703
704 is_recurring: function() {
705 // set default values for recurring documents
706 if(this.frm.doc.is_recurring) {
707 var owner_email = this.frm.doc.owner=="Administrator"
708 ? frappe.user_info("Administrator").email
709 : this.frm.doc.owner;
710
711 this.frm.doc.notification_email_address = $.map([cstr(owner_email),
712 cstr(this.frm.doc.contact_email)], function(v) { return v || null; }).join(", ");
713 this.frm.doc.repeat_on_day_of_month = frappe.datetime.str_to_obj(this.frm.doc.posting_date).getDate();
714 }
715
716 refresh_many(["notification_email_address", "repeat_on_day_of_month"]);
717 },
718
719 from_date: function() {
720 // set to_date
721 if(this.frm.doc.from_date) {
722 var recurring_type_map = {'Monthly': 1, 'Quarterly': 3, 'Half-yearly': 6,
723 'Yearly': 12};
724
725 var months = recurring_type_map[this.frm.doc.recurring_type];
726 if(months) {
727 var to_date = frappe.datetime.add_months(this.frm.doc.from_date,
728 months);
729 this.frm.doc.to_date = frappe.datetime.add_days(to_date, -1);
730 refresh_field('to_date');
731 }
732 }
733 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530734});
Nabin Haitce245122015-02-22 20:14:49 +0530735
Nabin Hait93b3a372015-02-24 17:08:34 +0530736frappe.ui.form.on(cur_frm.doctype + " Item", "rate", function(frm, cdt, cdn) {
Nabin Haitce245122015-02-22 20:14:49 +0530737 var item = frappe.get_doc(cdt, cdn);
738 frappe.model.round_floats_in(item, ["rate", "price_list_rate"]);
739
740 if(item.price_list_rate) {
741 item.discount_percentage = flt((1 - item.rate / item.price_list_rate) * 100.0, precision("discount_percentage", item));
742 } else {
743 item.discount_percentage = 0.0;
744 }
745
746 cur_frm.cscript.calculate_taxes_and_totals();
747})
Nabin Hait613d0812015-02-23 11:58:15 +0530748
749frappe.ui.form.on(cur_frm.cscript.tax_table, "rate", function(frm, cdt, cdn) {
750 cur_frm.cscript.calculate_taxes_and_totals();
751})
752
753frappe.ui.form.on(cur_frm.cscript.tax_table, "tax_amount", function(frm, cdt, cdn) {
754 cur_frm.cscript.calculate_taxes_and_totals();
755})
756
757frappe.ui.form.on(cur_frm.cscript.tax_table, "row_id", function(frm, cdt, cdn) {
758 cur_frm.cscript.calculate_taxes_and_totals();
759})
760
761frappe.ui.form.on(cur_frm.cscript.tax_table, "included_in_print_rate", function(frm, cdt, cdn) {
Nabin Hait903c42a2015-02-24 15:24:49 +0530762 cur_frm.cscript.set_dynamic_labels();
Nabin Hait613d0812015-02-23 11:58:15 +0530763 cur_frm.cscript.calculate_taxes_and_totals();
764})
Nabin Hait37b047d2015-02-23 16:01:33 +0530765
766frappe.ui.form.on(cur_frm.doctype, "apply_discount_on", function(frm) {
767 cur_frm.cscript.calculate_taxes_and_totals();
768})
769
770frappe.ui.form.on(cur_frm.doctype, "discount_amount", function(frm) {
Nabin Hait903c42a2015-02-24 15:24:49 +0530771 cur_frm.cscript.set_dynamic_labels();
Nabin Hait37b047d2015-02-23 16:01:33 +0530772 cur_frm.cscript.calculate_taxes_and_totals();
773})