erpnext/regional/italy/setup.py

# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
# License: GNU General Public License v3. See license.txt
# coding=utf-8

from __future__ import unicode_literals

import frappe
from frappe import _
from frappe.custom.doctype.custom_field.custom_field import create_custom_fields
from erpnext.regional.italy import fiscal_regimes, tax_exemption_reasons, mode_of_payment_codes, vat_collectability_options

def setup(company=None, patch=True):
	make_custom_fields()
	setup_report()

def make_custom_fields(update=True):
	invoice_item_fields = [
		dict(fieldname='tax_rate', label='Tax Rate',
			fieldtype='Float', insert_after='description',
			print_hide=1, hidden=1, read_only=1),
		dict(fieldname='tax_amount', label='Tax Amount',
			fieldtype='Currency', insert_after='tax_rate',
			print_hide=1, hidden=1, read_only=1, options="currency"),
		dict(fieldname='total_amount', label='Total Amount',
			fieldtype='Currency', insert_after='tax_amount',
			print_hide=1, hidden=1, read_only=1, options="currency")
	]

	customer_po_fields = [
		dict(fieldname='customer_po_details', label='Customer PO',
			fieldtype='Section Break', insert_after='image'),
		dict(fieldname='customer_po_no', label='Customer PO No',
			fieldtype='Data', insert_after='customer_po_details',
			fetch_from = 'sales_order.po_no',
			print_hide=1, allow_on_submit=1, fetch_if_empty= 1, read_only=1, no_copy=1),
		dict(fieldname='customer_po_clm_brk', label='',
			fieldtype='Column Break', insert_after='customer_po_no',
			print_hide=1, read_only=1),
		dict(fieldname='customer_po_date', label='Customer PO Date',
			fieldtype='Date', insert_after='customer_po_clm_brk',
			fetch_from = 'sales_order.po_date',
			print_hide=1, allow_on_submit=1, fetch_if_empty= 1, read_only=1, no_copy=1)
	]

	custom_fields = {
		'Company': [
			dict(fieldname='sb_e_invoicing', label='E-Invoicing',
				fieldtype='Section Break', insert_after='date_of_establishment', print_hide=1),
			dict(fieldname='fiscal_regime', label='Fiscal Regime',
				fieldtype='Select', insert_after='sb_e_invoicing', print_hide=1,
				options="\n".join(map(lambda x: frappe.safe_decode(x, encoding='utf-8'), fiscal_regimes))),
			dict(fieldname='fiscal_code', label='Fiscal Code', fieldtype='Data', insert_after='fiscal_regime', print_hide=1,
				description=_("Applicable if the company is an Individual or a Proprietorship")),
			dict(fieldname='vat_collectability', label='VAT Collectability',
				fieldtype='Select', insert_after='fiscal_code', print_hide=1,
				options="\n".join(map(lambda x: frappe.safe_decode(x, encoding='utf-8'), vat_collectability_options))),
			dict(fieldname='cb_e_invoicing1', fieldtype='Column Break', insert_after='vat_collectability', print_hide=1),
			dict(fieldname='registrar_office_province', label='Province of the Registrar Office',
				fieldtype='Data', insert_after='cb_e_invoicing1', print_hide=1, length=2),
			dict(fieldname='registration_number', label='Registration Number',
				fieldtype='Data', insert_after='registrar_office_province', print_hide=1, length=20),
			dict(fieldname='share_capital_amount', label='Share Capital',
				fieldtype='Currency', insert_after='registration_number', print_hide=1,
				description=_('Applicable if the company is SpA, SApA or SRL')),
			dict(fieldname='no_of_members', label='No of Members',
				fieldtype='Select', insert_after='share_capital_amount', print_hide=1,
				options="\nSU-Socio Unico\nSM-Piu Soci", description=_("Applicable if the company is a limited liability company")),
			dict(fieldname='liquidation_state', label='Liquidation State',
				fieldtype='Select', insert_after='no_of_members', print_hide=1,
				options="\nLS-In Liquidazione\nLN-Non in Liquidazione")
		],
		'Sales Taxes and Charges': [
			dict(fieldname='tax_exemption_reason', label='Tax Exemption Reason',
				fieldtype='Select', insert_after='included_in_print_rate', print_hide=1,
				depends_on='eval:doc.charge_type!="Actual" && doc.rate==0.0',
				options="\n" + "\n".join(map(lambda x: frappe.safe_decode(x, encoding='utf-8'), tax_exemption_reasons))),
			dict(fieldname='tax_exemption_law', label='Tax Exempt Under',
				fieldtype='Text', insert_after='tax_exemption_reason', print_hide=1,
				depends_on='eval:doc.charge_type!="Actual" && doc.rate==0.0')
		],
		'Customer': [
			dict(fieldname='fiscal_code', label='Fiscal Code', fieldtype='Data', insert_after='tax_id', print_hide=1),
			dict(fieldname='recipient_code', label='Recipient Code',
				fieldtype='Data', insert_after='fiscal_code', print_hide=1, default="0000000"),
			dict(fieldname='pec', label='Recipient PEC',
				fieldtype='Data', insert_after='fiscal_code', print_hide=1),
			dict(fieldname='is_public_administration', label='Is Public Administration',
				fieldtype='Check', insert_after='is_internal_customer', print_hide=1,
				description=_("Set this if the customer is a Public Administration company."),
				depends_on='eval:doc.customer_type=="Company"'),
			dict(fieldname='first_name', label='First Name', fieldtype='Data',
				insert_after='salutation', print_hide=1, depends_on='eval:doc.customer_type!="Company"'),
			dict(fieldname='last_name', label='Last Name', fieldtype='Data',
				insert_after='first_name', print_hide=1, depends_on='eval:doc.customer_type!="Company"')
		],
		'Mode of Payment': [
			dict(fieldname='mode_of_payment_code', label='Code',
			fieldtype='Select', insert_after='included_in_print_rate', print_hide=1,
			options="\n".join(map(lambda x: frappe.safe_decode(x, encoding='utf-8'), mode_of_payment_codes)))
		],
		'Payment Schedule': [
			dict(fieldname='mode_of_payment_code', label='Code',
				fieldtype='Select', insert_after='mode_of_payment', print_hide=1,
				options="\n".join(map(lambda x: frappe.safe_decode(x, encoding='utf-8'), mode_of_payment_codes)),
				fetch_from="mode_of_payment.mode_of_payment_code", read_only=1),
			dict(fieldname='bank_account', label='Bank Account',
				fieldtype='Link', insert_after='mode_of_payment_code', print_hide=1,
				options="Bank Account"),
			dict(fieldname='bank_account_name', label='Bank Name',
				fieldtype='Data', insert_after='bank_account', print_hide=1,
				fetch_from="bank_account.bank", read_only=1),
			dict(fieldname='bank_account_no', label='Bank Account No',
				fieldtype='Data', insert_after='bank_account_name', print_hide=1,
				fetch_from="bank_account.bank_account_no", read_only=1),
			dict(fieldname='bank_account_iban', label='IBAN',
				fieldtype='Data', insert_after='bank_account_name', print_hide=1,
				fetch_from="bank_account.iban", read_only=1),
			dict(fieldname='bank_account_swift_number', label='Swift Code (BIC)',
				fieldtype='Data', insert_after='bank_account_iban', print_hide=1,
				fetch_from="bank_account.swift_number", read_only=1),
		],
		"Sales Invoice": [
			dict(fieldname='vat_collectability', label='VAT Collectability',
				fieldtype='Select', insert_after='taxes_and_charges', print_hide=1,
				options="\n".join(map(lambda x: frappe.safe_decode(x, encoding='utf-8'), vat_collectability_options)),
				fetch_from="company.vat_collectability"),
			dict(fieldname='sb_e_invoicing_reference', label='E-Invoicing',
				fieldtype='Section Break', insert_after='pos_total_qty', print_hide=1),
			dict(fieldname='company_tax_id', label='Company Tax ID',
				fieldtype='Data', insert_after='sb_e_invoicing_reference', print_hide=1, read_only=1,
				fetch_from="company.tax_id"),
			dict(fieldname='company_fiscal_code', label='Company Fiscal Code',
				fieldtype='Data', insert_after='company_tax_id', print_hide=1, read_only=1,
				fetch_from="company.fiscal_code"),
			dict(fieldname='company_fiscal_regime', label='Company Fiscal Regime',
				fieldtype='Data', insert_after='company_fiscal_code', print_hide=1, read_only=1,
				fetch_from="company.fiscal_regime"),
			dict(fieldname='cb_e_invoicing_reference', fieldtype='Column Break',
				insert_after='company_fiscal_regime', print_hide=1),
			dict(fieldname='customer_fiscal_code', label='Customer Fiscal Code',
				fieldtype='Data', insert_after='cb_e_invoicing_reference', read_only=1,
				fetch_from="customer.fiscal_code"),
		],
		'Purchase Invoice Item': invoice_item_fields,
		'Sales Order Item': invoice_item_fields,
		'Delivery Note Item': invoice_item_fields,
		'Sales Invoice Item': invoice_item_fields + customer_po_fields,
		'Quotation Item': invoice_item_fields,
		'Purchase Order Item': invoice_item_fields,
		'Purchase Receipt Item': invoice_item_fields,
		'Supplier Quotation Item': invoice_item_fields,
		'Address': [
			dict(fieldname='country_code', label='Country Code',
				fieldtype='Data', insert_after='country', print_hide=1, read_only=0,
				fetch_from="country.code"),
			dict(fieldname='state_code', label='State Code',
				fieldtype='Data', insert_after='state', print_hide=1)
		],
		'Purchase Invoice': [
			dict(fieldname='document_type', label='Document Type',
				fieldtype='Data', insert_after='company', print_hide=1, read_only=1
				),
			dict(fieldname='destination_code', label='Destination Code',
				fieldtype='Data', insert_after='company', print_hide=1, read_only=1
				),
			dict(fieldname='imported_grand_total', label='Imported Grand Total',
				fieldtype='Data', insert_after='update_auto_repeat_reference', print_hide=1, read_only=1
				)
		],
		'Purchase Taxes and Charges': [
			dict(fieldname='tax_rate', label='Tax Rate',
				fieldtype='Data', insert_after='parenttype', print_hide=1, read_only=0
				)
		],
		'Supplier': [
			dict(fieldname='fiscal_code', label='Fiscal Code',
				fieldtype='Data', insert_after='tax_id', print_hide=1, read_only=1
				),
			dict(fieldname='fiscal_regime', label='Fiscal Regime',
				fieldtype='Select', insert_after='fiscal_code', print_hide=1, read_only=1,
				options= "\nRF01\nRF02\nRF04\nRF05\nRF06\nRF07\nRF08\nRF09\nRF10\nRF11\nRF12\nRF13\nRF14\nRF15\nRF16\nRF17\nRF18\nRF19"
				)
		]
	}

	create_custom_fields(custom_fields, ignore_validate = frappe.flags.in_patch, update=update)

def setup_report():
	report_name = 'Electronic Invoice Register'

	frappe.db.sql(""" update `tabReport` set disabled = 0 where
		name = %s """, report_name)

	if not frappe.db.get_value('Custom Role', dict(report=report_name)):
		frappe.get_doc(dict(
			doctype='Custom Role',
			report=report_name,
			roles= [
				dict(role='Accounts User'),
				dict(role='Accounts Manager')
			]
		)).insert()