blob: 0f641b2b38f0d89181b82feb7d73b51398cf8e53 [file] [log] [blame]
Rushabh Mehta81e9d4e2015-08-19 13:00:03 +05301## temp utility
Aditya Hase6ccb6562017-08-28 18:17:36 +05302from __future__ import print_function
Rushabh Mehta81e9d4e2015-08-19 13:00:03 +05303import frappe
Rushabh Mehta6dd461f2017-02-16 14:51:48 +05304from erpnext.utilities.activation import get_level
Saurabhf4ee6822017-05-16 08:30:27 +05305from frappe.utils import cstr
Rushabh Mehta81e9d4e2015-08-19 13:00:03 +05306
7def update_doctypes():
8 for d in frappe.db.sql("""select df.parent, df.fieldname
9 from tabDocField df, tabDocType dt where df.fieldname
10 like "%description%" and df.parent = dt.name and dt.istable = 1""", as_dict=1):
11 dt = frappe.get_doc("DocType", d.parent)
12
13 for f in dt.fields:
14 if f.fieldname == d.fieldname and f.fieldtype in ("Text", "Small Text"):
Aditya Hase6ccb6562017-08-28 18:17:36 +053015 print(f.parent, f.fieldname)
Rushabh Mehta81e9d4e2015-08-19 13:00:03 +053016 f.fieldtype = "Text Editor"
17 dt.save()
18 break
Anand Doshif576f3b2016-06-25 19:51:48 +053019
20def get_site_info(site_info):
21 # called via hook
22 company = frappe.db.get_single_value('Global Defaults', 'default_company')
23 domain = None
24
25 if not company:
26 company = frappe.db.sql('select name from `tabCompany` order by creation asc')
27 company = company[0][0] if company else None
28
29 if company:
Saurabhf4ee6822017-05-16 08:30:27 +053030 domain = frappe.db.get_value('Company', cstr(company), 'domain')
Anand Doshif576f3b2016-06-25 19:51:48 +053031
32 return {
33 'company': company,
Rushabh Mehta6dd461f2017-02-16 14:51:48 +053034 'domain': domain,
35 'activation': get_level()
Anand Doshif576f3b2016-06-25 19:51:48 +053036 }