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 |
Rushabh Mehta | 81e9d4e | 2015-08-19 13:00:03 +0530 | [diff] [blame] | 5 | |
| 6 | def update_doctypes(): |
| 7 | for d in frappe.db.sql("""select df.parent, df.fieldname |
| 8 | from tabDocField df, tabDocType dt where df.fieldname |
| 9 | like "%description%" and df.parent = dt.name and dt.istable = 1""", as_dict=1): |
| 10 | dt = frappe.get_doc("DocType", d.parent) |
| 11 | |
| 12 | for f in dt.fields: |
| 13 | if f.fieldname == d.fieldname and f.fieldtype in ("Text", "Small Text"): |
| 14 | print f.parent, f.fieldname |
| 15 | f.fieldtype = "Text Editor" |
| 16 | dt.save() |
| 17 | break |
Anand Doshi | f576f3b | 2016-06-25 19:51:48 +0530 | [diff] [blame] | 18 | |
| 19 | def get_site_info(site_info): |
| 20 | # called via hook |
| 21 | company = frappe.db.get_single_value('Global Defaults', 'default_company') |
| 22 | domain = None |
| 23 | |
| 24 | if not company: |
| 25 | company = frappe.db.sql('select name from `tabCompany` order by creation asc') |
| 26 | company = company[0][0] if company else None |
| 27 | |
| 28 | if company: |
| 29 | domain = frappe.db.get_value('Company', company, 'domain') |
| 30 | |
| 31 | return { |
| 32 | 'company': company, |
Rushabh Mehta | 6dd461f | 2017-02-16 14:51:48 +0530 | [diff] [blame] | 33 | 'domain': domain, |
| 34 | 'activation': get_level() |
Anand Doshi | f576f3b | 2016-06-25 19:51:48 +0530 | [diff] [blame] | 35 | } |