blob: 840b111e50e250abd12fe52878fe329a38538ce1 [file] [log] [blame]
Rushabh Mehta49dd7be2014-01-28 17:43:10 +05301# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. and Contributors
2# License: GNU General Public License v3. See license.txt
3
4from __future__ import unicode_literals
5
Rushabh Mehta793ba6b2014-02-14 15:47:51 +05306import frappe
7from frappe import _
8from frappe.defaults import get_restrictions
Nabin Hait9d1f0772014-02-19 17:43:24 +05309from frappe.utils import add_days
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053010from erpnext.utilities.doctype.address.address import get_address_display
11from erpnext.utilities.doctype.contact.contact import get_contact_details
Rushabh Mehta49dd7be2014-01-28 17:43:10 +053012
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053013@frappe.whitelist()
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053014def get_party_details(party=None, account=None, party_type="Customer", company=None,
15 posting_date=None, price_list=None, currency=None):
Anand Doshi201dbbd2014-02-20 15:21:53 +053016
17 return _get_party_details(party, account, party_type, company, posting_date, price_list, currency)
18
19def _get_party_details(party=None, account=None, party_type="Customer", company=None,
20 posting_date=None, price_list=None, currency=None, ignore_permissions=False):
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053021 out = frappe._dict(set_account_and_due_date(party, account, party_type, company, posting_date))
Rushabh Mehta49dd7be2014-01-28 17:43:10 +053022
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053023 party = out[party_type.lower()]
24
Anand Doshi201dbbd2014-02-20 15:21:53 +053025 if not ignore_permissions and not frappe.has_permission(party_type, "read", party):
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053026 frappe.throw("Not Permitted", frappe.PermissionError)
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053027
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053028 party_bean = frappe.bean(party_type, party)
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053029 party = party_bean.doc
30
Nabin Hait9d1f0772014-02-19 17:43:24 +053031 set_address_details(out, party, party_type)
32 set_contact_details(out, party, party_type)
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053033 set_other_values(out, party, party_type)
34 set_price_list(out, party, price_list)
35
36 if not out.get("currency"):
37 out["currency"] = currency
38
39 # sales team
Rushabh Mehta49dd7be2014-01-28 17:43:10 +053040 if party_type=="Customer":
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053041 out["sales_team"] = [{
42 "sales_person": d.sales_person,
43 "sales_designation": d.sales_designation
44 } for d in party_bean.doclist.get({"doctype":"Sales Team"})]
45
46 return out
47
Nabin Hait9d1f0772014-02-19 17:43:24 +053048def set_address_details(out, party, party_type):
49 billing_address_field = "customer_address" if party_type == "Lead" \
50 else party_type.lower() + "_address"
51 out[billing_address_field] = frappe.conn.get_value("Address",
52 {party_type.lower(): party.name, "is_primary_address":1}, "name")
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053053
54 # address display
Nabin Hait9d1f0772014-02-19 17:43:24 +053055 out.address_display = get_address_display(out[billing_address_field])
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053056
Nabin Hait9d1f0772014-02-19 17:43:24 +053057 # shipping address
58 if party_type in ["Customer", "Lead"]:
59 out.shipping_address_name = frappe.conn.get_value("Address",
60 {party_type.lower(): party.name, "is_shipping_address":1}, "name")
61 out.shipping_address = get_address_display(out["shipping_address_name"])
62
63def set_contact_details(out, party, party_type):
64 out.contact_person = frappe.conn.get_value("Contact",
65 {party_type.lower(): party.name, "is_primary_contact":1}, "name")
66
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053067 out.update(get_contact_details(out.contact_person))
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053068
69def set_other_values(out, party, party_type):
70 # copy
71 if party_type=="Customer":
72 to_copy = ["customer_name", "customer_group", "territory"]
Rushabh Mehta49dd7be2014-01-28 17:43:10 +053073 else:
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053074 to_copy = ["supplier_name", "supplier_type"]
75 for f in to_copy:
76 out[f] = party.get(f)
77
78 # fields prepended with default in Customer doctype
79 for f in ['currency', 'taxes_and_charges'] \
80 + (['sales_partner', 'commission_rate'] if party_type=="Customer" else []):
81 if party.get("default_" + f):
82 out[f] = party.get("default_" + f)
83
84def set_price_list(out, party, given_price_list):
85 # price list
86 price_list = get_restrictions().get("Price List")
87 if isinstance(price_list, list):
88 price_list = None
89
90 if not price_list:
91 price_list = party.default_price_list
92
93 if not price_list and party.party_type=="Customer":
Rushabh Mehta793ba6b2014-02-14 15:47:51 +053094 price_list = frappe.conn.get_value("Customer Group",
Rushabh Mehtacc008cc2014-02-03 16:14:56 +053095 party.customer_group, "default_price_list")
96
97 if not price_list:
98 price_list = given_price_list
99
100 if price_list:
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530101 out.price_list_currency = frappe.conn.get_value("Price List", price_list, "currency")
Rushabh Mehtacc008cc2014-02-03 16:14:56 +0530102
103 out["selling_price_list" if party.doctype=="Customer" else "buying_price_list"] = price_list
104
105
106def set_account_and_due_date(party, account, party_type, company, posting_date):
107 if not posting_date:
108 # not an invoice
109 return {
110 party_type.lower(): party
111 }
112
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530113 if party:
114 account = get_party_account(company, party, party_type)
115 elif account:
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530116 party = frappe.conn.get_value('Account', account, 'master_name')
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530117
118 account_fieldname = "debit_to" if party_type=="Customer" else "credit_to"
119
120 out = {
121 party_type.lower(): party,
122 account_fieldname : account,
123 "due_date": get_due_date(posting_date, party, party_type, account, company)
Rushabh Mehtacc008cc2014-02-03 16:14:56 +0530124 }
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530125 return out
126
127def get_party_account(company, party, party_type):
128 if not company:
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530129 frappe.throw(_("Please select company first."))
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530130
131 if party:
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530132 acc_head = frappe.conn.get_value("Account", {"master_name":party,
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530133 "master_type": party_type, "company": company})
134
135 if not acc_head:
136 create_party_account(party, party_type, company)
137
138 return acc_head
139
140def get_due_date(posting_date, party, party_type, account, company):
141 """Set Due Date = Posting Date + Credit Days"""
142 due_date = None
143 if posting_date:
144 credit_days = 0
Rushabh Mehta24da7612014-01-29 15:26:04 +0530145 if account:
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530146 credit_days = frappe.conn.get_value("Account", account, "credit_days")
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530147 if party and not credit_days:
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530148 credit_days = frappe.conn.get_value(party_type, party, "credit_days")
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530149 if company and not credit_days:
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530150 credit_days = frappe.conn.get_value("Company", company, "credit_days")
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530151
152 due_date = add_days(posting_date, credit_days) if credit_days else posting_date
153
154 return due_date
155
156def create_party_account(party, party_type, company):
157 if not company:
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530158 frappe.throw(_("Company is required"))
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530159
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530160 company_details = frappe.conn.get_value("Company", company,
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530161 ["abbr", "receivables_group", "payables_group"], as_dict=True)
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530162 if not frappe.conn.exists("Account", (party + " - " + company_details.abbr)):
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530163 parent_account = company_details.receivables_group \
164 if party_type=="Customer" else company_details.payables_group
165
166 # create
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530167 account = frappe.bean({
Rushabh Mehta49dd7be2014-01-28 17:43:10 +0530168 "doctype": "Account",
169 'account_name': party,
170 'parent_account': parent_account,
171 'group_or_ledger':'Ledger',
172 'company': company,
173 'master_type': party_type,
174 'master_name': party,
175 "freeze_account": "No"
176 }).insert(ignore_permissions=True)
177
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530178 frappe.msgprint(_("Account Created") + ": " + account.doc.name)