| Rushabh Mehta | 621283c | 2016-04-21 19:00:34 +0530 | [diff] [blame] | 1 | from __future__ import unicode_literals |
| 2 | |
| 3 | import frappe |
| 4 | |
| 5 | @frappe.whitelist() |
| 6 | def get_data(item_code=None, warehouse=None, start=0, sort_by='actual_qty', sort_order='desc'): |
| 7 | filters = {} |
| 8 | if item_code: |
| Rushabh Mehta | 0394aec | 2016-04-22 17:22:22 +0530 | [diff] [blame] | 9 | filters['item_code'] = item_code |
| Rushabh Mehta | 621283c | 2016-04-21 19:00:34 +0530 | [diff] [blame] | 10 | if warehouse: |
| Rushabh Mehta | 0394aec | 2016-04-22 17:22:22 +0530 | [diff] [blame] | 11 | filters['warehouse'] = warehouse |
| Rushabh Mehta | 621283c | 2016-04-21 19:00:34 +0530 | [diff] [blame] | 12 | return frappe.get_list("Bin", filters=filters, fields=['item_code', 'warehouse', |
| Rushabh Mehta | 3d2622c | 2016-04-25 17:53:42 +0530 | [diff] [blame] | 13 | 'projected_qty', 'reserved_qty', 'reserved_qty_for_production', 'actual_qty', 'valuation_rate'], |
| Rushabh Mehta | 621283c | 2016-04-21 19:00:34 +0530 | [diff] [blame] | 14 | order_by='{0} {1}'.format(sort_by, sort_order), start=start, page_length = 21) |