Rushabh Mehta | 81e9d4e | 2015-08-19 13:00:03 +0530 | [diff] [blame] | 1 | ## temp utility |
| 2 | |
| 3 | import frappe |
Rushabh Mehta | 6dd461f | 2017-02-16 14:51:48 +0530 | [diff] [blame] | 4 | from erpnext.utilities.activation import get_level |
Saurabh | f4ee682 | 2017-05-16 08:30:27 +0530 | [diff] [blame] | 5 | from frappe.utils import cstr |
Rushabh Mehta | 81e9d4e | 2015-08-19 13:00:03 +0530 | [diff] [blame] | 6 | |
| 7 | def 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"): |
| 15 | print f.parent, f.fieldname |
| 16 | f.fieldtype = "Text Editor" |
| 17 | dt.save() |
| 18 | break |
Anand Doshi | f576f3b | 2016-06-25 19:51:48 +0530 | [diff] [blame] | 19 | |
| 20 | def 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: |
Saurabh | f4ee682 | 2017-05-16 08:30:27 +0530 | [diff] [blame] | 30 | domain = frappe.db.get_value('Company', cstr(company), 'domain') |
Anand Doshi | f576f3b | 2016-06-25 19:51:48 +0530 | [diff] [blame] | 31 | |
| 32 | return { |
| 33 | 'company': company, |
Rushabh Mehta | 6dd461f | 2017-02-16 14:51:48 +0530 | [diff] [blame] | 34 | 'domain': domain, |
| 35 | 'activation': get_level() |
Anand Doshi | f576f3b | 2016-06-25 19:51:48 +0530 | [diff] [blame] | 36 | } |