Ejemplos de make_custom_fields en Python

Ejemplo n.º 1

def execute():
    company = frappe.get_all('Company', filters={'country': 'Italy'})
    if not company:
        return

    frappe.reload_doc('regional', 'report', 'electronic_invoice_register')
    make_custom_fields()
    setup_report()

    # Set state codes
    condition = ""
    for state, code in state_codes.items():
        condition += " when {0} then {1}".format(frappe.db.escape(state),
                                                 frappe.db.escape(code))

    if condition:
        condition = "state_code = (case state {0} end),".format(condition)

    frappe.db.sql("""
		UPDATE tabAddress set {condition} country_code = UPPER(ifnull((select code
			from `tabCountry` where name = `tabAddress`.country), ''))
			where country_code is null and state_code is null
	""".format(condition=condition))

    frappe.db.sql("""
		UPDATE `tabSales Invoice Item` si, `tabSales Order` so
			set si.customer_po_no = so.po_no, si.customer_po_date = so.po_date
		WHERE
			si.sales_order = so.name and so.po_no is not null
	""")

Ejemplo n.º 2

Archivo: make_italian_localization_fields.py Proyecto: ci2014/erpnext

def execute():
	company = frappe.get_all('Company', filters = {'country': 'Italy'})
	if not company:
		return

	frappe.reload_doc('regional', 'report', 'electronic_invoice_register')
	make_custom_fields()
	setup_report()

	# Set state codes
	condition = ""
	for state, code in state_codes.items():
		condition += " when '{0}' then '{1}'".format(frappe.db.escape(state), frappe.db.escape(code))

	if condition:
		condition = "state_code = (case state {0} end),".format(condition)

	frappe.db.sql("""
		UPDATE tabAddress set {condition} country_code = UPPER(ifnull((select code
			from `tabCountry` where name = `tabAddress`.country), ''))
			where country_code is null and state_code is null
	""".format(condition=condition))

	frappe.db.sql("""
		UPDATE `tabSales Invoice Item` si, `tabSales Order` so
			set si.customer_po_no = so.po_no, si.customer_po_date = so.po_date
		WHERE
			si.sales_order = so.name and so.po_no is not null
	""")

Ejemplo n.º 3

Archivo: set_permission_einvoicing.py Proyecto: ParsimonyGit/erpnext

def execute():
    company = frappe.get_all('Company', filters={'country': 'Italy'})

    if not company:
        return

    make_custom_fields()

    add_permission('Import Supplier Invoice', 'Accounts Manager', 0)
    update_permission_property('Import Supplier Invoice', 'Accounts Manager',
                               0, 'write', 1)
    update_permission_property('Import Supplier Invoice', 'Accounts Manager',
                               0, 'create', 1)

Ejemplo n.º 4

def execute():
    company = frappe.get_all("Company", filters={"country": "Italy"})

    if not company:
        return

    make_custom_fields()

    frappe.reload_doc("regional", "doctype", "import_supplier_invoice")

    add_permission("Import Supplier Invoice", "Accounts Manager", 0)
    update_permission_property("Import Supplier Invoice", "Accounts Manager",
                               0, "write", 1)
    update_permission_property("Import Supplier Invoice", "Accounts Manager",
                               0, "create", 1)

Ejemplo n.º 5

Archivo: make_italian_localization_fields.py Proyecto: sandyc316/erpnext

def execute():

    company = frappe.get_all('Company', filters={'country': 'Italy'})
    if not company:
        return

    make_custom_fields()
    setup_report()

    # Set state codes
    condition = ""
    for state, code in state_codes.items():
        condition += " when '{0}' then '{1}'".format(frappe.db.escape(state),
                                                     frappe.db.escape(code))

    if condition:
        frappe.db.sql("""
        UPDATE tabAddress set state_code = (case state {condition} end)
        WHERE country in ('Italy', 'Italia', 'Italian Republic', 'Repubblica Italiana')
      """.format(condition=condition))

Ejemplo n.º 6

Archivo: make_italian_localization_fields.py Proyecto: Aptronics/erpnext

def execute():
	company = frappe.get_all('Company', filters = {'country': 'Italy'})
	if not company:
		return

	frappe.reload_doc('regional', 'report', 'electronic_invoice_register')
	make_custom_fields()
	setup_report()

	# Set state codes
	condition = ""
	for state, code in state_codes.items():
		condition += " when '{0}' then '{1}'".format(frappe.db.escape(state), frappe.db.escape(code))

	if condition:
		condition = "state_code = (case state {0} end),".format(condition)

	frappe.db.sql("""
		UPDATE tabAddress set {condition} country_code = UPPER(ifnull((select code
			from `tabCountry` where name = `tabAddress`.country), ''))
	""".format(condition=condition))

Ejemplo n.º 7

Archivo: make_italian_localization_fields.py Proyecto: eqilibruim501/erp-cloudbi

def execute():
    company = frappe.get_all('Company', filters={'country': 'Italy'})
    if not company:
        return

    frappe.reload_doc('regional', 'report', 'electronic_invoice_register')
    make_custom_fields()
    setup_report()

    # Set state codes
    condition = ""
    for state, code in state_codes.items():
        condition += " when '{0}' then '{1}'".format(frappe.db.escape(state),
                                                     frappe.db.escape(code))

    if condition:
        condition = "state_code = (case state {0} end),".format(condition)

    frappe.db.sql("""
		UPDATE tabAddress set {condition} country_code = UPPER(ifnull((select code
			from `tabCountry` where name = `tabAddress`.country), ''))
	""".format(condition=condition))