Gitiles
Code Review Sign In
git.clicks.codes / Clicks / Forks / ERPNext / b19305aa8350c810535c94dc6af7ba0b9e2dde89 / . / erpnext / stock / __init__.py
blob: e8b2804b7d774393f6636dbca184f605dc293815 [file] [log] [blame]
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530[diff] [blame]1import frappe
Nabin Haitd2c5b502018-10-08 18:19:53 +0530[diff] [blame]2from frappe import _
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530[diff] [blame]3
Anand Doshi7e0479b2012-04-05 18:27:56 +0530[diff] [blame]4install_docs = [
Rushabh Mehta94157332015-07-13 15:06:12 +0530[diff] [blame]5 {"doctype":"Role", "role_name":"Stock Manager", "name":"Stock Manager"},
6 {"doctype":"Role", "role_name":"Item Manager", "name":"Item Manager"},
7 {"doctype":"Role", "role_name":"Stock User", "name":"Stock User"},
Anand Doshi24e18562012-04-17 11:45:35 +0530[diff] [blame]8 {"doctype":"Role", "role_name":"Quality Manager", "name":"Quality Manager"},
Saurabh6bc7b892016-07-14 14:03:19 +0530[diff] [blame]9 {"doctype":"Item Group", "item_group_name":"All Item Groups", "is_group": 1},
Rohit Waghchaure6b33c9b2019-03-08 11:13:35 +0530[diff] [blame]10 {"doctype":"Item Group", "item_group_name":"Default",
Saurabh6bc7b892016-07-14 14:03:19 +0530[diff] [blame]11 "parent_item_group":"All Item Groups", "is_group": 0},
Anand Doshi7e0479b2012-04-05 18:27:56 +0530[diff] [blame]12]
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530[diff] [blame]13
Rohit Waghchaure6b33c9b2019-03-08 11:13:35 +0530[diff] [blame]14def get_warehouse_account_map(company=None):
Saqib25846cc2020-03-31 15:31:15 +0530[diff] [blame]15 company_warehouse_account_map = company and frappe.flags.setdefault('warehouse_account_map', {}).get(company)
16 warehouse_account_map = frappe.flags.warehouse_account_map
17
18 if not warehouse_account_map or not company_warehouse_account_map or frappe.flags.in_test:
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530[diff] [blame]19 warehouse_account = frappe._dict()
20
Rohit Waghchaure6b33c9b2019-03-08 11:13:35 +0530[diff] [blame]21 filters = {}
22 if company:
23 filters['company'] = company
Saqib25846cc2020-03-31 15:31:15 +0530[diff] [blame]24 frappe.flags.setdefault('warehouse_account_map', {}).setdefault(company, {})
Rohit Waghchaure6b33c9b2019-03-08 11:13:35 +0530[diff] [blame]25
Nabin Haitedd320e2018-04-02 10:30:17 +0530[diff] [blame]26 for d in frappe.get_all('Warehouse',
Anurag Mishraa11e7382019-10-31 15:55:03 +0530[diff] [blame]27 fields = ["name", "account", "parent_warehouse", "company", "is_group"],
Rohit Waghchaure6b33c9b2019-03-08 11:13:35 +0530[diff] [blame]28 filters = filters,
Nabin Haitedd320e2018-04-02 10:30:17 +0530[diff] [blame]29 order_by="lft, rgt"):
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530[diff] [blame]30 if not d.account:
Nabin Haitedd320e2018-04-02 10:30:17 +0530[diff] [blame]31 d.account = get_warehouse_account(d, warehouse_account)
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530[diff] [blame]32
33 if d.account:
Nabin Haitedd320e2018-04-02 10:30:17 +0530[diff] [blame]34 d.account_currency = frappe.db.get_value('Account', d.account, 'account_currency', cache=True)
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530[diff] [blame]35 warehouse_account.setdefault(d.name, d)
Saqib25846cc2020-03-31 15:31:15 +0530[diff] [blame]36 if company:
37 frappe.flags.warehouse_account_map[company] = warehouse_account
38 else:
39 frappe.flags.warehouse_account_map = warehouse_account
Rohit Waghchaurec603fd62021-02-26 17:34:53 +0530[diff] [blame]40
Saqib25846cc2020-03-31 15:31:15 +0530[diff] [blame]41 return frappe.flags.warehouse_account_map.get(company) or frappe.flags.warehouse_account_map
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530[diff] [blame]42
Nabin Haitedd320e2018-04-02 10:30:17 +0530[diff] [blame]43def get_warehouse_account(warehouse, warehouse_account=None):
44 account = warehouse.account
45 if not account and warehouse.parent_warehouse:
46 if warehouse_account:
Nabin Haitd2c5b502018-10-08 18:19:53 +0530[diff] [blame]47 if warehouse_account.get(warehouse.parent_warehouse):
48 account = warehouse_account.get(warehouse.parent_warehouse).account
49 else:
50 from frappe.utils.nestedset import rebuild_tree
51 rebuild_tree("Warehouse", "parent_warehouse")
Nabin Haitedd320e2018-04-02 10:30:17 +0530[diff] [blame]52 else:
53 account = frappe.db.sql("""
54 select
55 account from `tabWarehouse`
56 where
57 lft <= %s and rgt >= %s and company = %s
58 and account is not null and ifnull(account, '') !=''
59 order by lft desc limit 1""", (warehouse.lft, warehouse.rgt, warehouse.company), as_list=1)
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530[diff] [blame]60
Nabin Haitedd320e2018-04-02 10:30:17 +0530[diff] [blame]61 account = account[0][0] if account else None
62
Nabin Hait9409edd2018-08-16 13:58:44 +0530[diff] [blame]63 if not account and warehouse.company:
Nabin Haitedd320e2018-04-02 10:30:17 +0530[diff] [blame]64 account = get_company_default_inventory_account(warehouse.company)
65
Rohit Waghchaurec603fd62021-02-26 17:34:53 +0530[diff] [blame]66 if not account and warehouse.company:
67 account = frappe.db.get_value('Account',
68 {'account_type': 'Stock', 'is_group': 0, 'company': warehouse.company}, 'name')
69
Nabin Hait9b178bc2021-02-16 14:57:00 +0530[diff] [blame]70 if not account and warehouse.company and not warehouse.is_group:
Nabin Haitd2c5b502018-10-08 18:19:53 +0530[diff] [blame]71 frappe.throw(_("Please set Account in Warehouse {0} or Default Inventory Account in Company {1}")
Nabin Hait5d117162018-10-19 18:03:13 +0530[diff] [blame]72 .format(warehouse.name, warehouse.company))
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530[diff] [blame]73 return account
Rohit Waghchaure6b33c9b2019-03-08 11:13:35 +0530[diff] [blame]74
Nabin Hait6d7b0ce2017-06-15 11:09:27 +0530[diff] [blame]75def get_company_default_inventory_account(company):
Nabin Haitd826bee2021-02-18 14:14:21 +0530[diff] [blame]76 return frappe.get_cached_value('Company', company, 'default_inventory_account')