blob: e02abb48e5cd96da08bba458f688e2eb6304375a [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')));
s-aga-rdc0ddf82023-02-03 18:08:34 +053045 let entry_type = action === "Move" ? "Material Transfer" : "Material Receipt";
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');
s-aga-rdc0ddf82023-02-03 18:08:34 +053066 if (entry_type) {
67 doc.stock_entry_type = entry_type;
68 }
Shivam Mishra38b930b2019-07-05 10:38:48 +053069
70 var row = frappe.model.add_child(doc, 'items');
71 row.item_code = item;
s-aga-rdc0ddf82023-02-03 18:08:34 +053072
73 if (entry_type === "Material Transfer") {
74 row.s_warehouse = warehouse;
75 }
76 else {
77 row.t_warehouse = warehouse;
78 }
Shivam Mishra38b930b2019-07-05 10:38:48 +053079
80 frappe.set_route('Form', doc.doctype, doc.name);
Anurag Mishraabf974d2021-03-17 18:40:21 +053081 });
Shivam Mishra38b930b2019-07-05 10:38:48 +053082 }
83
Rushabh Mehta3d2622c2016-04-25 17:53:42 +053084 // more
Anurag Mishraabf974d2021-03-17 18:40:21 +053085 this.content.find('.btn-more').on('click', function () {
marinationa5d8d322020-12-09 16:27:18 +053086 me.start += me.page_length;
Rushabh Mehta3d2622c2016-04-25 17:53:42 +053087 me.refresh();
88 });
89
Faris Ansari1fe891b2021-04-23 08:04:00 +053090 }
91 refresh() {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +053092 if(this.before_refresh) {
93 this.before_refresh();
94 }
95
marination1087d972020-11-26 10:45:44 +053096 let args = {
97 item_code: this.item_code,
98 warehouse: this.warehouse,
99 parent_warehouse: this.parent_warehouse,
100 item_group: this.item_group,
101 company: this.company,
102 start: this.start,
103 sort_by: this.sort_by,
104 sort_order: this.sort_order
marination0f3cfc52020-12-08 19:11:51 +0530105 };
marination1087d972020-11-26 10:45:44 +0530106
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530107 var me = this;
108 frappe.call({
marination1087d972020-11-26 10:45:44 +0530109 method: this.method,
110 args: args,
Anurag Mishraabf974d2021-03-17 18:40:21 +0530111 callback: function (r) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530112 me.render(r.message);
Devin Slauenwhite123920d2022-12-29 00:01:26 -0500113 if(me.after_refresh) {
114 me.after_refresh();
115 }
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530116 }
117 });
Faris Ansari1fe891b2021-04-23 08:04:00 +0530118 }
119 render(data) {
marination1087d972020-11-26 10:45:44 +0530120 if (this.start===0) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530121 this.max_count = 0;
122 this.result.empty();
123 }
124
marination0f3cfc52020-12-08 19:11:51 +0530125 let context = "";
marination1087d972020-11-26 10:45:44 +0530126 if (this.page_name === "warehouse-capacity-summary") {
marination0f3cfc52020-12-08 19:11:51 +0530127 context = this.get_capacity_dashboard_data(data);
marination1087d972020-11-26 10:45:44 +0530128 } else {
marination0f3cfc52020-12-08 19:11:51 +0530129 context = this.get_item_dashboard_data(data, this.max_count, true);
marination1087d972020-11-26 10:45:44 +0530130 }
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530131
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530132 // show more button
Anurag Mishraabf974d2021-03-17 18:40:21 +0530133 if (data && data.length === (this.page_length + 1)) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530134 this.content.find('.more').removeClass('hidden');
135
136 // remove the last element
137 data.splice(-1);
138 } else {
139 this.content.find('.more').addClass('hidden');
140 }
141
Vinayak Jethe2c8ce5a2018-01-24 13:51:26 +0530142 // If not any stock in any warehouses provide a message to end user
Stavros Anastasiadis58b58782017-10-05 16:14:50 +0300143 if (context.data.length > 0) {
marination1087d972020-11-26 10:45:44 +0530144 this.content.find('.result').css('text-align', 'unset');
145 $(frappe.render_template(this.template, context)).appendTo(this.result);
Stavros Anastasiadis58b58782017-10-05 16:14:50 +0300146 } else {
marination1087d972020-11-26 10:45:44 +0530147 var message = __("No Stock Available Currently");
148 this.content.find('.result').css('text-align', 'center');
149
marinationa97eb6a2021-02-07 22:27:40 +0530150 $(`<div class='text-muted' style='margin: 20px 5px;'>
marination1087d972020-11-26 10:45:44 +0530151 ${message} </div>`).appendTo(this.result);
Stavros Anastasiadis58b58782017-10-05 16:14:50 +0300152 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530153 }
marination1087d972020-11-26 10:45:44 +0530154
Faris Ansari1fe891b2021-04-23 08:04:00 +0530155 get_item_dashboard_data(data, max_count, show_item) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530156 if(!max_count) max_count = 0;
Rushabh Mehta0dcb8612016-05-31 07:22:37 +0530157 if(!data) data = [];
Vinayak Jethe549c1962018-01-24 19:47:59 +0530158
Anurag Mishraabf974d2021-03-17 18:40:21 +0530159 data.forEach(function (d) {
Nabin Haita6746402018-03-28 11:16:00 +0530160 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 +0530161 d.pending_qty = 0;
Nabin Hait2c7a6e62018-03-12 14:12:12 +0530162 d.total_reserved = d.reserved_qty + d.reserved_qty_for_production + d.reserved_qty_for_sub_contract;
Anurag Mishraabf974d2021-03-17 18:40:21 +0530163 if (d.actual_or_pending > d.actual_qty) {
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530164 d.pending_qty = d.actual_or_pending - d.actual_qty;
165 }
166
167 max_count = Math.max(d.actual_or_pending, d.actual_qty,
168 d.total_reserved, max_count);
169 });
Vinayak Jethe549c1962018-01-24 19:47:59 +0530170
marination1087d972020-11-26 10:45:44 +0530171 let can_write = 0;
marination0f3cfc52020-12-08 19:11:51 +0530172 if (frappe.boot.user.can_write.indexOf("Stock Entry") >= 0) {
Vinayak Jethe549c1962018-01-24 19:47:59 +0530173 can_write = 1;
174 }
175
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530176 return {
177 data: data,
178 max_count: max_count,
Anurag Mishraabf974d2021-03-17 18:40:21 +0530179 can_write: can_write,
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530180 show_item: show_item || false
marinationb8aeb9e2021-01-05 12:16:25 +0530181 };
Faris Ansari1fe891b2021-04-23 08:04:00 +0530182 }
marination1087d972020-11-26 10:45:44 +0530183
Faris Ansari1fe891b2021-04-23 08:04:00 +0530184 get_capacity_dashboard_data(data) {
marination0f3cfc52020-12-08 19:11:51 +0530185 if (!data) data = [];
marination1087d972020-11-26 10:45:44 +0530186
Anurag Mishraabf974d2021-03-17 18:40:21 +0530187 data.forEach(function (d) {
188 d.color = d.percent_occupied >= 80 ? "#f8814f" : "#2490ef";
marination1087d972020-11-26 10:45:44 +0530189 });
190
191 let can_write = 0;
marination0f3cfc52020-12-08 19:11:51 +0530192 if (frappe.boot.user.can_write.indexOf("Putaway Rule") >= 0) {
marination1087d972020-11-26 10:45:44 +0530193 can_write = 1;
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530194 }
marination1087d972020-11-26 10:45:44 +0530195
196 return {
197 data: data,
198 can_write: can_write,
marination0f3cfc52020-12-08 19:11:51 +0530199 };
Rushabh Mehta3d2622c2016-04-25 17:53:42 +0530200 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530201};
Shivam Mishra444091b2019-07-10 10:22:08 +0530202
Anurag Mishraabf974d2021-03-17 18:40:21 +0530203erpnext.stock.move_item = function (item, source, target, actual_qty, rate, callback) {
Shivam Mishra444091b2019-07-10 10:22:08 +0530204 var dialog = new frappe.ui.Dialog({
205 title: target ? __('Add Item') : __('Move Item'),
Anurag Mishraabf974d2021-03-17 18:40:21 +0530206 fields: [{
207 fieldname: 'item_code',
208 label: __('Item'),
209 fieldtype: 'Link',
210 options: 'Item',
211 read_only: 1
212 },
213 {
214 fieldname: 'source',
215 label: __('Source Warehouse'),
216 fieldtype: 'Link',
217 options: 'Warehouse',
218 read_only: 1
219 },
220 {
221 fieldname: 'target',
222 label: __('Target Warehouse'),
223 fieldtype: 'Link',
224 options: 'Warehouse',
Ankush Menat88a21ca2022-01-26 01:01:10 +0530225 reqd: 1,
226 get_query() {
227 return {
228 filters: {
229 is_group: 0
230 }
231 }
232 }
Anurag Mishraabf974d2021-03-17 18:40:21 +0530233 },
234 {
235 fieldname: 'qty',
236 label: __('Quantity'),
237 reqd: 1,
238 fieldtype: 'Float',
239 description: __('Available {0}', [actual_qty])
240 },
241 {
242 fieldname: 'rate',
243 label: __('Rate'),
244 fieldtype: 'Currency',
245 hidden: 1
246 },
Shivam Mishra444091b2019-07-10 10:22:08 +0530247 ],
Anurag Mishraabf974d2021-03-17 18:40:21 +0530248 });
Shivam Mishra444091b2019-07-10 10:22:08 +0530249 dialog.show();
250 dialog.get_field('item_code').set_input(item);
251
Anurag Mishraabf974d2021-03-17 18:40:21 +0530252 if (source) {
Shivam Mishra444091b2019-07-10 10:22:08 +0530253 dialog.get_field('source').set_input(source);
254 } else {
255 dialog.get_field('source').df.hidden = 1;
256 dialog.get_field('source').refresh();
257 }
258
Anurag Mishraabf974d2021-03-17 18:40:21 +0530259 if (rate) {
Shivam Mishra444091b2019-07-10 10:22:08 +0530260 dialog.get_field('rate').set_value(rate);
261 dialog.get_field('rate').df.hidden = 0;
262 dialog.get_field('rate').refresh();
263 }
264
Anurag Mishraabf974d2021-03-17 18:40:21 +0530265 if (target) {
Shivam Mishra444091b2019-07-10 10:22:08 +0530266 dialog.get_field('target').df.read_only = 1;
267 dialog.get_field('target').value = target;
268 dialog.get_field('target').refresh();
269 }
270
Ankush Menat0bed5922022-01-26 01:01:33 +0530271 dialog.set_primary_action(__('Create Stock Entry'), function () {
Devin Slauenwhitecdf631b2022-06-29 02:36:47 -0400272 if (source && (dialog.get_value("qty") == 0 || dialog.get_value("qty") > actual_qty)) {
273 frappe.msgprint(__("Quantity must be greater than zero, and less or equal to {0}", [actual_qty]));
274 return;
275 }
276
277 if (dialog.get_value("source") === dialog.get_value("target")) {
278 frappe.msgprint(__("Source and target warehouse must be different"));
279 return;
280 }
281
Ankush Menat0bed5922022-01-26 01:01:33 +0530282 frappe.model.with_doctype('Stock Entry', function () {
283 let doc = frappe.model.get_new_doc('Stock Entry');
284 doc.from_warehouse = dialog.get_value('source');
285 doc.to_warehouse = dialog.get_value('target');
286 doc.stock_entry_type = doc.from_warehouse ? "Material Transfer" : "Material Receipt";
287 let row = frappe.model.add_child(doc, 'items');
288 row.item_code = dialog.get_value('item_code');
Ankush Menat3cc47d52022-02-28 13:04:24 +0530289 row.s_warehouse = dialog.get_value('source');
Ankush Menat0bed5922022-01-26 01:01:33 +0530290 row.t_warehouse = dialog.get_value('target');
291 row.qty = dialog.get_value('qty');
292 row.conversion_factor = 1;
293 row.transfer_qty = dialog.get_value('qty');
294 row.basic_rate = dialog.get_value('rate');
295 frappe.set_route('Form', doc.doctype, doc.name);
Shivam Mishra444091b2019-07-10 10:22:08 +0530296 });
297 });
Anurag Mishraabf974d2021-03-17 18:40:21 +0530298};