blob: c2b4229f171bf481f1afc031e1115d6a6e132c16 [file] [log] [blame]
Rushabh Mehta81e9d4e2015-08-19 13:00:03 +05301## temp utility
Chillar Anand915b3432021-09-02 16:44:59 +05302
Rushabh Mehta81e9d4e2015-08-19 13:00:03 +05303import frappe
Saurabhf4ee6822017-05-16 08:30:27 +05304from frappe.utils import cstr
Rushabh Mehta81e9d4e2015-08-19 13:00:03 +05305
Chillar Anand915b3432021-09-02 16:44:59 +05306from erpnext.utilities.activation import get_level
7
8
Rushabh Mehta81e9d4e2015-08-19 13:00:03 +05309def update_doctypes():
Ankush Menat494bd9e2022-03-28 18:52:46 +053010 for d in frappe.db.sql(
11 """select df.parent, df.fieldname
Rushabh Mehta81e9d4e2015-08-19 13:00:03 +053012 from tabDocField df, tabDocType dt where df.fieldname
Ankush Menat494bd9e2022-03-28 18:52:46 +053013 like "%description%" and df.parent = dt.name and dt.istable = 1""",
14 as_dict=1,
15 ):
Rushabh Mehta81e9d4e2015-08-19 13:00:03 +053016 dt = frappe.get_doc("DocType", d.parent)
17
18 for f in dt.fields:
19 if f.fieldname == d.fieldname and f.fieldtype in ("Text", "Small Text"):
Rushabh Mehta81e9d4e2015-08-19 13:00:03 +053020 f.fieldtype = "Text Editor"
21 dt.save()
22 break
Anand Doshif576f3b2016-06-25 19:51:48 +053023
Ankush Menat494bd9e2022-03-28 18:52:46 +053024
Anand Doshif576f3b2016-06-25 19:51:48 +053025def get_site_info(site_info):
26 # called via hook
Ankush Menat494bd9e2022-03-28 18:52:46 +053027 company = frappe.db.get_single_value("Global Defaults", "default_company")
Anand Doshif576f3b2016-06-25 19:51:48 +053028 domain = None
29
30 if not company:
Ankush Menat494bd9e2022-03-28 18:52:46 +053031 company = frappe.db.sql("select name from `tabCompany` order by creation asc")
Anand Doshif576f3b2016-06-25 19:51:48 +053032 company = company[0][0] if company else None
33
34 if company:
Ankush Menat494bd9e2022-03-28 18:52:46 +053035 domain = frappe.get_cached_value("Company", cstr(company), "domain")
Anand Doshif576f3b2016-06-25 19:51:48 +053036
Ankush Menat494bd9e2022-03-28 18:52:46 +053037 return {"company": company, "domain": domain, "activation": get_level()}