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