blob: 1be528f1dd175087568f820dd15a0c5115488360 [file] [log] [blame]
Rushabh Mehta3d2622c2016-04-25 17:53:42 +05301frappe.provide('erpnext.stock');
2
Faris Ansari1fe891b2021-04-23 08:04:00 +05303erpnext.stock.ItemDashboard = class ItemDashboard {
4 constructor(opts) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +05305 $.extend(this, opts);
6 this.make();
Faris Ansari1fe891b2021-04-23 08:04:00 +05307 }
8 make() {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +05309 var me = this;
10 this.start = 0;
Anurag Mishraabf974d2021-03-17 18:40:21 +053011 if (!this.sort_by) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +053012 this.sort_by = 'projected_qty';
13 this.sort_order = 'asc';
14 }
15
16 this.content = $(frappe.render_template('item_dashboard')).appendTo(this.parent);
17 this.result = this.content.find('.result');
18
Anurag Mishraabf974d2021-03-17 18:40:21 +053019 this.content.on('click', '.btn-move', function () {
20 handle_move_add($(this), "Move");
Shivam Mishra38b930b2019-07-05 10:38:48 +053021 });
22
Anurag Mishraabf974d2021-03-17 18:40:21 +053023 this.content.on('click', '.btn-add', function () {
24 handle_move_add($(this), "Add");
Shivam Mishra5738c932019-07-16 12:52:19 +053025 });
26
Anurag Mishraabf974d2021-03-17 18:40:21 +053027 this.content.on('click', '.btn-edit', function () {
marination1087d972020-11-26 10:45:44 +053028 let item = unescape($(this).attr('data-item'));
29 let warehouse = unescape($(this).attr('data-warehouse'));
30 let company = unescape($(this).attr('data-company'));
Anurag Mishraabf974d2021-03-17 18:40:21 +053031 frappe.db.get_value('Putaway Rule', {
32 'item_code': item,
33 'warehouse': warehouse,
34 'company': company
35 }, 'name', (r) => {
36 frappe.set_route("Form", "Putaway Rule", r.name);
37 });
marination1087d972020-11-26 10:45:44 +053038 });
39
Shivam Mishra5738c932019-07-16 12:52:19 +053040 function handle_move_add(element, action) {
41 let item = unescape(element.attr('data-item'));
42 let warehouse = unescape(element.attr('data-warehouse'));
43 let actual_qty = unescape(element.attr('data-actual_qty'));
44 let disable_quick_entry = Number(unescape(element.attr('data-disable_quick_entry')));
Anurag Mishraabf974d2021-03-17 18:40:21 +053045 let entry_type = action === "Move" ? "Material Transfer" : null;
Shivam Mishra444091b2019-07-10 10:22:08 +053046
Shivam Mishrafd6ff622019-07-16 12:32:50 +053047 if (disable_quick_entry) {
Shivam Mishra5738c932019-07-16 12:52:19 +053048 open_stock_entry(item, warehouse, entry_type);
Shivam Mishrafd6ff622019-07-16 12:32:50 +053049 } else {
Shivam Mishra5738c932019-07-16 12:52:19 +053050 if (action === "Add") {
51 let rate = unescape($(this).attr('data-rate'));
Anurag Mishraabf974d2021-03-17 18:40:21 +053052 erpnext.stock.move_item(item, null, warehouse, actual_qty, rate, function () {
53 me.refresh();
54 });
55 } else {
56 erpnext.stock.move_item(item, warehouse, null, actual_qty, null, function () {
57 me.refresh();
58 });
Shivam Mishra5738c932019-07-16 12:52:19 +053059 }
Shivam Mishrafd6ff622019-07-16 12:32:50 +053060 }
Shivam Mishra5738c932019-07-16 12:52:19 +053061 }
Shivam Mishra38b930b2019-07-05 10:38:48 +053062
63 function open_stock_entry(item, warehouse, entry_type) {
Anurag Mishraabf974d2021-03-17 18:40:21 +053064 frappe.model.with_doctype('Stock Entry', function () {
Shivam Mishra38b930b2019-07-05 10:38:48 +053065 var doc = frappe.model.get_new_doc('Stock Entry');
66 if (entry_type) doc.stock_entry_type = entry_type;
67
68 var row = frappe.model.add_child(doc, 'items');
69 row.item_code = item;
70 row.s_warehouse = warehouse;
71
72 frappe.set_route('Form', doc.doctype, doc.name);
Anurag Mishraabf974d2021-03-17 18:40:21 +053073 });
Shivam Mishra38b930b2019-07-05 10:38:48 +053074 }
75
Rushabh Mehta3d2622c2016-04-25 17:53:42 +053076 // more
Anurag Mishraabf974d2021-03-17 18:40:21 +053077 this.content.find('.btn-more').on('click', function () {
marinationa5d8d322020-12-09 16:27:18 +053078 me.start += me.page_length;
Rushabh Mehta3d2622c2016-04-25 17:53:42 +053079 me.refresh();
80 });
81
Faris Ansari1fe891b2021-04-23 08:04:00 +053082 }
83 refresh() {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +053084 if(this.before_refresh) {
85 this.before_refresh();
86 }
87
marination1087d972020-11-26 10:45:44 +053088 let args = {
89 item_code: this.item_code,
90 warehouse: this.warehouse,
91 parent_warehouse: this.parent_warehouse,
92 item_group: this.item_group,
93 company: this.company,
94 start: this.start,
95 sort_by: this.sort_by,
96 sort_order: this.sort_order
marination0f3cfc52020-12-08 19:11:51 +053097 };
marination1087d972020-11-26 10:45:44 +053098
Rushabh Mehta3d2622c2016-04-25 17:53:42 +053099 var me = this;
100 frappe.call({
marination1087d972020-11-26 10:45:44 +0530101 method: this.method,
102 args: args,
Anurag Mishraabf974d2021-03-17 18:40:21 +0530103 callback: function (r) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530104 me.render(r.message);
Devin Slauenwhite123920d2022-12-29 00:01:26 -0500105 if(me.after_refresh) {
106 me.after_refresh();
107 }
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530108 }
109 });
Faris Ansari1fe891b2021-04-23 08:04:00 +0530110 }
111 render(data) {
marination1087d972020-11-26 10:45:44 +0530112 if (this.start===0) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530113 this.max_count = 0;
114 this.result.empty();
115 }
116
marination0f3cfc52020-12-08 19:11:51 +0530117 let context = "";
marination1087d972020-11-26 10:45:44 +0530118 if (this.page_name === "warehouse-capacity-summary") {
marination0f3cfc52020-12-08 19:11:51 +0530119 context = this.get_capacity_dashboard_data(data);
marination1087d972020-11-26 10:45:44 +0530120 } else {
marination0f3cfc52020-12-08 19:11:51 +0530121 context = this.get_item_dashboard_data(data, this.max_count, true);
marination1087d972020-11-26 10:45:44 +0530122 }
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530123
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530124 this.max_count = this.max_count;
125
126 // show more button
Anurag Mishraabf974d2021-03-17 18:40:21 +0530127 if (data && data.length === (this.page_length + 1)) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530128 this.content.find('.more').removeClass('hidden');
129
130 // remove the last element
131 data.splice(-1);
132 } else {
133 this.content.find('.more').addClass('hidden');
134 }
135
Vinayak Jethe2c8ce5a2018-01-24 13:51:26 +0530136 // If not any stock in any warehouses provide a message to end user
Stavros Anastasiadis58b58782017-10-05 16:14:50 +0300137 if (context.data.length > 0) {
marination1087d972020-11-26 10:45:44 +0530138 this.content.find('.result').css('text-align', 'unset');
139 $(frappe.render_template(this.template, context)).appendTo(this.result);
Stavros Anastasiadis58b58782017-10-05 16:14:50 +0300140 } else {
marination1087d972020-11-26 10:45:44 +0530141 var message = __("No Stock Available Currently");
142 this.content.find('.result').css('text-align', 'center');
143
marinationa97eb6a2021-02-07 22:27:40 +0530144 $(`<div class='text-muted' style='margin: 20px 5px;'>
marination1087d972020-11-26 10:45:44 +0530145 ${message} </div>`).appendTo(this.result);
Stavros Anastasiadis58b58782017-10-05 16:14:50 +0300146 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530147 }
marination1087d972020-11-26 10:45:44 +0530148
Faris Ansari1fe891b2021-04-23 08:04:00 +0530149 get_item_dashboard_data(data, max_count, show_item) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530150 if(!max_count) max_count = 0;
Rushabh Mehta0dcb8612016-05-31 07:22:37 +0530151 if(!data) data = [];
Vinayak Jethe549c1962018-01-24 19:47:59 +0530152
Anurag Mishraabf974d2021-03-17 18:40:21 +0530153 data.forEach(function (d) {
Nabin Haita6746402018-03-28 11:16:00 +0530154 d.actual_or_pending = d.projected_qty + d.reserved_qty + d.reserved_qty_for_production + d.reserved_qty_for_sub_contract;
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530155 d.pending_qty = 0;
Nabin Hait2c7a6e62018-03-12 14:12:12 +0530156 d.total_reserved = d.reserved_qty + d.reserved_qty_for_production + d.reserved_qty_for_sub_contract;
Anurag Mishraabf974d2021-03-17 18:40:21 +0530157 if (d.actual_or_pending > d.actual_qty) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530158 d.pending_qty = d.actual_or_pending - d.actual_qty;
159 }
160
161 max_count = Math.max(d.actual_or_pending, d.actual_qty,
162 d.total_reserved, max_count);
163 });
Vinayak Jethe549c1962018-01-24 19:47:59 +0530164
marination1087d972020-11-26 10:45:44 +0530165 let can_write = 0;
marination0f3cfc52020-12-08 19:11:51 +0530166 if (frappe.boot.user.can_write.indexOf("Stock Entry") >= 0) {
Vinayak Jethe549c1962018-01-24 19:47:59 +0530167 can_write = 1;
168 }
169
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530170 return {
171 data: data,
172 max_count: max_count,
Anurag Mishraabf974d2021-03-17 18:40:21 +0530173 can_write: can_write,
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530174 show_item: show_item || false
marinationb8aeb9e2021-01-05 12:16:25 +0530175 };
Faris Ansari1fe891b2021-04-23 08:04:00 +0530176 }
marination1087d972020-11-26 10:45:44 +0530177
Faris Ansari1fe891b2021-04-23 08:04:00 +0530178 get_capacity_dashboard_data(data) {
marination0f3cfc52020-12-08 19:11:51 +0530179 if (!data) data = [];
marination1087d972020-11-26 10:45:44 +0530180
Anurag Mishraabf974d2021-03-17 18:40:21 +0530181 data.forEach(function (d) {
182 d.color = d.percent_occupied >= 80 ? "#f8814f" : "#2490ef";
marination1087d972020-11-26 10:45:44 +0530183 });
184
185 let can_write = 0;
marination0f3cfc52020-12-08 19:11:51 +0530186 if (frappe.boot.user.can_write.indexOf("Putaway Rule") >= 0) {
marination1087d972020-11-26 10:45:44 +0530187 can_write = 1;
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530188 }
marination1087d972020-11-26 10:45:44 +0530189
190 return {
191 data: data,
192 can_write: can_write,
marination0f3cfc52020-12-08 19:11:51 +0530193 };
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530194 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530195};
Shivam Mishra444091b2019-07-10 10:22:08 +0530196
Anurag Mishraabf974d2021-03-17 18:40:21 +0530197erpnext.stock.move_item = function (item, source, target, actual_qty, rate, callback) {
Shivam Mishra444091b2019-07-10 10:22:08 +0530198 var dialog = new frappe.ui.Dialog({
199 title: target ? __('Add Item') : __('Move Item'),
Anurag Mishraabf974d2021-03-17 18:40:21 +0530200 fields: [{
201 fieldname: 'item_code',
202 label: __('Item'),
203 fieldtype: 'Link',
204 options: 'Item',
205 read_only: 1
206 },
207 {
208 fieldname: 'source',
209 label: __('Source Warehouse'),
210 fieldtype: 'Link',
211 options: 'Warehouse',
212 read_only: 1
213 },
214 {
215 fieldname: 'target',
216 label: __('Target Warehouse'),
217 fieldtype: 'Link',
218 options: 'Warehouse',
Ankush Menat88a21ca2022-01-26 01:01:10 +0530219 reqd: 1,
220 get_query() {
221 return {
222 filters: {
223 is_group: 0
224 }
225 }
226 }
Anurag Mishraabf974d2021-03-17 18:40:21 +0530227 },
228 {
229 fieldname: 'qty',
230 label: __('Quantity'),
231 reqd: 1,
232 fieldtype: 'Float',
233 description: __('Available {0}', [actual_qty])
234 },
235 {
236 fieldname: 'rate',
237 label: __('Rate'),
238 fieldtype: 'Currency',
239 hidden: 1
240 },
Shivam Mishra444091b2019-07-10 10:22:08 +0530241 ],
Anurag Mishraabf974d2021-03-17 18:40:21 +0530242 });
Shivam Mishra444091b2019-07-10 10:22:08 +0530243 dialog.show();
244 dialog.get_field('item_code').set_input(item);
245
Anurag Mishraabf974d2021-03-17 18:40:21 +0530246 if (source) {
Shivam Mishra444091b2019-07-10 10:22:08 +0530247 dialog.get_field('source').set_input(source);
248 } else {
249 dialog.get_field('source').df.hidden = 1;
250 dialog.get_field('source').refresh();
251 }
252
Anurag Mishraabf974d2021-03-17 18:40:21 +0530253 if (rate) {
Shivam Mishra444091b2019-07-10 10:22:08 +0530254 dialog.get_field('rate').set_value(rate);
255 dialog.get_field('rate').df.hidden = 0;
256 dialog.get_field('rate').refresh();
257 }
258
Anurag Mishraabf974d2021-03-17 18:40:21 +0530259 if (target) {
Shivam Mishra444091b2019-07-10 10:22:08 +0530260 dialog.get_field('target').df.read_only = 1;
261 dialog.get_field('target').value = target;
262 dialog.get_field('target').refresh();
263 }
264
Ankush Menat0bed5922022-01-26 01:01:33 +0530265 dialog.set_primary_action(__('Create Stock Entry'), function () {
Devin Slauenwhitecdf631b2022-06-29 02:36:47 -0400266 if (source && (dialog.get_value("qty") == 0 || dialog.get_value("qty") > actual_qty)) {
267 frappe.msgprint(__("Quantity must be greater than zero, and less or equal to {0}", [actual_qty]));
268 return;
269 }
270
271 if (dialog.get_value("source") === dialog.get_value("target")) {
272 frappe.msgprint(__("Source and target warehouse must be different"));
273 return;
274 }
275
Ankush Menat0bed5922022-01-26 01:01:33 +0530276 frappe.model.with_doctype('Stock Entry', function () {
277 let doc = frappe.model.get_new_doc('Stock Entry');
278 doc.from_warehouse = dialog.get_value('source');
279 doc.to_warehouse = dialog.get_value('target');
280 doc.stock_entry_type = doc.from_warehouse ? "Material Transfer" : "Material Receipt";
281 let row = frappe.model.add_child(doc, 'items');
282 row.item_code = dialog.get_value('item_code');
Ankush Menat3cc47d52022-02-28 13:04:24 +0530283 row.s_warehouse = dialog.get_value('source');
Ankush Menat0bed5922022-01-26 01:01:33 +0530284 row.t_warehouse = dialog.get_value('target');
285 row.qty = dialog.get_value('qty');
286 row.conversion_factor = 1;
287 row.transfer_qty = dialog.get_value('qty');
288 row.basic_rate = dialog.get_value('rate');
289 frappe.set_route('Form', doc.doctype, doc.name);
Shivam Mishra444091b2019-07-10 10:22:08 +0530290 });
291 });
Anurag Mishraabf974d2021-03-17 18:40:21 +0530292};