def execute():
	import webnotes
	from webnotes.modules.module_manager import reload_doc
	reload_doc('stock', 'doctype', 'delivery_note_detail')
	reload_doc('stock', 'Print Format', 'Delivery Note Packing List Wise')
	
	webnotes.conn.sql("delete from `tabDocField` where fieldname in ('packed_by', 'packing_checked_by', 'pack_size') and parent = 'Delivery Note'")

def execute():
	import webnotes
	from webnotes.modules.module_manager import reload_doc
	sql = webnotes.conn.sql

	reload_doc('hr', 'doctype', 'salary_manager')
	sql("delete from `tabDocField` where parent = 'Salary Manager' and fieldname = 'employment_type'")

def setup():
	"creates the DocTrigger table from core"
	webnotes.conn.commit()
	from webnotes.modules.module_manager import reload_doc
	reload_doc('core','doctype','doctrigger')
	webnotes.conn.begin()
	

def execute():
	import webnotes
	from webnotes.modules.module_manager import reload_doc
	reload_doc('setup', 'doctype', 'manage_account')
	reload_doc('stock', 'doctype', 'item')
	webnotes.conn.sql("delete from `tabDocField` where fieldname='minimum_inventory_level' and parent='item'")
	webnotes.conn.sql("update `tabItem` set re_order_level = minimum_inventory_level where ifnull(re_order_level,0) = 0 ")

def execute():
	import webnotes
	from webnotes.modules.module_manager import reload_doc
	webnotes.conn.sql("delete from `tabField Mapper Detail` where from_field = 'transaction_date' and parent in ('Sales Order-Delivery Note', 'Purchase Order-Purchase Receipt')")

	reload_doc('stock', 'DocType Mapper', 'Sales Order-Delivery Note')
	reload_doc('stock', 'DocType Mapper', 'Purchase Order-Purchase Receipt')

def execute():
    import webnotes

    webnotes.conn.sql("DELETE FROM `tabDocFormat` WHERE format='POS Invoice'")
    from webnotes.modules.module_manager import reload_doc

    reload_doc("accounts", "Print Format", "POS Invoice")

def execute():
	from webnotes.model.doc import Document
	from webnotes.modules.module_manager import reload_doc
	reload_doc('hr', 'search_criteria', 'employeewise_balance_leave_report')
	d = Document('Search Criteria', 'employeewise_balance_leave_report')
	d.criteria_name = 'Employee Leave Balance Report'
	d.description = 'Employeewise Balance Leave Report'
	d.save()

def execute():
	import webnotes
	from webnotes.modules.module_manager import reload_doc
	from webnotes.model import delete_doc

	delete_doc('DocType', 'Landed Cost Wizard')
	delete_doc('DocType', 'LC PR Detail')
	reload_doc('stock', 'doctype', 'landed_cost_wizard')
	reload_doc('stock', 'doctype', 'lc_pr_detail')

def execute():
	import webnotes
	from webnotes.modules.module_manager import reload_doc
	from webnotes.model.code import get_obj

	reload_doc('accounts', 'doctype', 'receivable_voucher')

	reload_doc('setup', 'doctype', 'features_setup')
	get_obj('Features setup').validate()

def execute():
	import webnotes
	from webnotes.modules.module_manager import reload_doc
	
	
	reload_doc('stock', 'doctype', 'landed_cost_wizard')
	reload_doc('stock', 'doctype', 'lc_pr_detail')
	
	webnotes.conn.sql("delete from `tabDocField` where parent ='LC PR Detail' and fieldname in ('purchase_receipt_no', 'include_in_landed_cost')")

def execute():
	"""
		* Change option of doclayer's doc_type field
		* Reload doclayer
	"""
	webnotes.conn.sql("""
		UPDATE `tabDocField` SET options=NULL
		WHERE parent='DocLayer' AND fieldname='doc_type'
	""")
	from webnotes.modules.module_manager import reload_doc
	reload_doc('core', 'doctype', 'doclayer')

def execute():
	"""
		Install print formats
	"""
	from webnotes.modules.module_manager import reload_doc
	reload_doc('core', 'doctype', 'print_format')
	
	#copy_doctype_to_pfs()
	global pf_to_install
	for pf in pf_to_install:
	#	install_print_format(pf)
	#	print "Installed PF: " + pf['name']
		reload_doc(pf['module'], 'Print Format', pf['name'])

def execute():
	"""
		* Change type of mail_port field to int
		* reload email settings
	"""
	import webnotes
	webnotes.conn.sql("""
		UPDATE `tabDocField` SET fieldtype='Int'
		WHERE parent = 'Email Settings' AND fieldname = 'mail_port'
	""")

	from webnotes.modules.module_manager import reload_doc
	reload_doc('setup', 'doctype', 'email_settings')

def execute():
	import webnotes
	from webnotes.modules.module_manager import reload_doc

	reload_doc('accounts', 'doctype', 'receivable_voucher')
	reload_doc('stock', 'doctype', 'delivery_note')
	reload_doc('selling', 'doctype', 'sales_order')
	reload_doc('selling', 'doctype', 'quotation')
	reload_doc('setup', 'doctype', 'manage_account')


	for d in ['Receivable Voucher', 'Delivery Note', 'Sales Order', 'Quotation']:
		webnotes.conn.sql("update `tab%s` set price_list_currency = currency, plc_conversion_rate = conversion_rate" % d)

def execute():
	"""
		Remove One Get TDS button, which is appearing twice in JV
	"""
	import webnotes
	webnotes.conn.sql("""
		DELETE from `tabDocField`
		WHERE parent='Journal Voucher'
		AND label='Get TDS'
		AND fieldtype='Button'
	""")

	from webnotes.modules.module_manager import reload_doc
	reload_doc('accounts', 'doctype', 'journal_voucher')

def execute():
	import webnotes
	opts = webnotes.conn.sql("""\
		SELECT options FROM `tabDocField`
		WHERE parent='Serial No' AND fieldname='status' AND
		fieldtype='Select'""")
	if opts and opts[0][0]:
		opt_list = opts[0][0].split("\n")
		if not "Purchase Returned" in opt_list:
			webnotes.conn.sql("""
				UPDATE `tabDocField` SET options=%s
				WHERE parent='Serial No' AND fieldname='status' AND
				fieldtype='Select'""", "\n".join(opt_list + ["Purchase Returned"]))
			webnotes.conn.commit()
			webnotes.conn.begin()

	from webnotes.modules.module_manager import reload_doc
	reload_doc('stock', 'doctype', 'serial_no')

def execute():
	import webnotes
	from webnotes.modules.module_manager import reload_doc

	reload_doc('accounts', 'doctype', 'receivable_voucher')
	reload_doc('accounts', 'doctype', 'c_form')
	reload_doc('accounts', 'doctype', 'c_form_invoice_detail')
	reload_doc('accounts', 'Module Def', 'Accounts')

	sql = webnotes.conn.sql
	sql("update `tabReceivable Voucher` set c_form_applicable = 'Yes' where c_form_applicable = 'Y'")
	sql("update `tabReceivable Voucher` set c_form_applicable = 'No' where c_form_applicable = 'N'")

def execute():
	from webnotes.modules.module_manager import reload_doc
	reload_doc('core', 'doctype', 'print_format')
	reload_doc('core', 'doctype', 'doclayer')
	reload_doc('core', 'doctype', 'doclayerfield')
	reload_doc('accounts', 'doctype', 'gl_entry')
	from webnotes.model.doc import Document
	d = Document('DocType Label')
	d.dt = "DocLayer"
	d.dt_label = "Customize Form View"
	d.save(1)
	from webnotes.session_cache import clear
	clear()

def execute():
	"""
		Changes allocated_to option to Profile in
		DocType Customer Issue
	"""
	import webnotes
	webnotes.conn.sql("""
		UPDATE `tabDocField`
		SET options='Profile'
		WHERE fieldname='allocated_to'
	""")

	webnotes.conn.sql("""
		DELETE from `tabDocField`
		WHERE parent='Customer Issue'
		AND label='Make Maintenance Visit'
	""")

	from webnotes.modules.module_manager import reload_doc
	reload_doc('support', 'doctype', 'customer_issue')

def run_patches():
	# update module
	dt_module = {'LC PR Detail':'Stock', 'Landed Cost Detail':'Stock', 'Comment Widget Record': 'Core', 'Tag':'Core', 'Tag Detail': 'Core', 'POS Settings': 'Accounts', 'Menu Item': 'Setup', 'Menu Item Role': 'Setup'}
	for d in dt_module.keys():
		sql("update `tabDocType` set module = '%s' where name = '%s'" % (dt_module[d], d))
	delete_unwanted_mappers()
	delete_unwanted_doctypes()
	sql("start transaction")
	delete_unwanted_pages()

	delete_unwanted_search_criteria()

	
	rename_merge_modules()
	sync_roles()
	sync_mapper()
	delete_unwanted_modules()
	# landed cost wizard link in stock
	reload_doc('stock', 'Module Def', 'Stock')
	
	sql("commit")