def sync_roles():
	"Put Roles into corresponding module and delete Roles module"
	
	# roles
	roles = {
		'Accounts'	:		"'Accounts Manager', 'Accounts User', 'Auditor'", 
		'Selling'	: 		"'Customer', 'Sales User', 'Sales Manager', 'Sales Master Manager', 'Partner'", 
		'Buying'	:		"'Supplier', 'Purchase User', 'Purchase Manager', 'Purchase Master Manager'", 
		'Stock'		:		"'Material User', 'Material Master Manager', 'Material Manager', 'Quality Manager'", 
		'Support'	:		"'Support Team', 'Support Manager', 'Maintenance User', 'Maintenance Manager'", 
		'Production':		"'Production User', 'Production Manager', 'Production Master Manager'", 
		'Setup'		:		"'System Manager'", 
		'Projects'	:		"'Projects User'", 
		'HR'		:		"'HR User', 'HR Manager', 'Employee'",
		'Core'		:		"'Administrator', 'All', 'Guest'"
	}
	for mod in roles.keys():
		sql("update `tabRole` set module = '%s' where name in (%s)" % (mod, roles[mod]))
		
	sql("update `tabDocType` set module = 'Setup' where name = 'Role'")
	try:
	
		delete_doc('Module Def', 'Roles')
	except:
		pass

def execute():
	import webnotes
	from webnotes.model import delete_doc
	delete_doc('DocType', 'Bulk Rename Tool')
	webnotes.conn.commit()
	webnotes.conn.sql("drop table `tabBulk Rename Tool`")
	webnotes.conn.begin()

	def delete_supplier_account(self):
		"""delete supplier's ledger if exist and check balance before deletion"""
		acc = sql("select name from `tabAccount` where master_type = 'Supplier' \
			and master_name = %s and docstatus < 2", self.doc.name)
		if acc:
			from webnotes.model import delete_doc
			delete_doc('Account', acc[0][0])

def execute():
	import webnotes
	from webnotes.modules import reload_doc
	reload_doc('stock', 'Search Criteria', 'Stock Ledger')

	from webnotes.model import delete_doc
	delete_doc("Report", "Stock Ledger")

def execute():
	del_rec = {
		'DocType'	:	['Update Series', 'File', 'File Browser Control', 'File Group',
			'Tag Detail', 'DocType Property Setter', 'Company Group', 'Widget Control', 
			'Update Delivery Date Detail', 'Update Delivery	Date',
			'Tag Detail', 'Supplier rating', 'Stylesheet', 'Question Tag',
			'PRO PP Detail', 'PRO Detail', 'PPW Detail', 'PF Detail',
			'Personalize', 'Patch Util', 'Page Template', 'Module Def Role',
			'Module Def Item', 'File Group', 'File Browser Control', 'File',
			'Educational Qualifications', 'Earn Deduction Detail',
			'DocType Property Setter', 'Contact Detail', 'BOM Report Detail', 
			'BOM Replace Utility Detail', 'BOM Replace Utility', 
			'Absent Days Detail', 'Activity Dashboard Control', 'Raw Materials Supplied',
			'Setup Wizard Control', 'Company Group', 'Lease Agreement', 'Lease Installment',
			'Terms and Conditions', 'Time Sheet', 'Time Sheet Detail', 'Naming Series Options',
			'Invest 80 Declaration Detail', 'IT Checklist', 'Chapter VI A Detail', 'Declaration Detail',
			'Personalize', 'Salary Slip Control Panel', 'Question Control'
			],
		'Page'		:	['File Browser', 'Bill of Materials', 'question-view'],
		'DocType Mapper': ['Production Forecast-Production Planning Tool', 'Production Forecast-Production Plan', 'Sales Order-Production Plan'],
	}

	for d in del_rec:
		for r in del_rec[d]:
			print 'Deleted', d, ' - ', r
			if d=='DocType':
				sql("delete from tabFeed where doc_type=%s", r)
			delete_doc(d, r)

	sql("delete from tabDocField where label='Repair Purchase Request' and parent = 'Purchase Request'")

	drop_tables()

def delete(arg):
	"""
		delete a question or answer (called from kb toolbar)
	"""
	args = load_json(arg)
	from webnotes.model import delete_doc
	delete_doc(args['dt'], args['dn'])

	def delete_items(self,arg):
		il = eval(arg)
		from webnotes.model import delete_doc
		for d in il:
			dt_obj = get_obj(d[0], d[1])
			if hasattr(dt_obj, 'on_trash'):
				dt_obj.on_trash()
			delete_doc(d[0], d[1])

def delete_unwanted_pages():
	"deletes pages which are not used anymore"
	lst = ['Transaction Authorization', 'Prduct Display', 'Data Import', 'Partner Home', 'Product Display', 'Module Settings', 'About Us', 'Custom Reports', 'MIS', 'MIS - Comparison Report', 'Monthly MIS', 'MyReports', 'Navigation Page', 'Point Race', 'Tag Widget', 'Widget Test', 'Yearly MIS']
	for d in lst:
		try:
			delete_doc('Page', d)
		except:
			pass

def delete_unwanted_modules():
	"deletes unwanted modules"
	lst = ['Development', 'Recycle Bin', 'Testing', 'Testing System', 'Test', 'Partner Updates', 'My Company', 'Event Updates', 'E-Commerce']
	for d in lst:
		try:
			delete_doc('Module Def', d)
		except:
			pass

def execute():
	import webnotes
	from webnotes.model import delete_doc
	delete_doc("Search Criteria", "sales_order_pending_items1")
	
	webnotes.conn.sql("update `tabSearch Criteria` set module = 'Selling' where module = 'CRM'")
	from webnotes.modules import reload_doc
	reload_doc('selling', 'search_criteria', 'sales_order_pending_items')

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

	delete_doc('DocType', 'Landed Cost Wizard')
	delete_doc('DocType', 'Landed Cost Purchase Receipt')
	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 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():
	# remove doctypes
	for dt in ["Period", "Account Balance", "Multi Ledger Report", 
			"Multi Ledger Report Detail", "Period Control", "Reposting Tool", 
			"Lease Agreement", "Lease Installment"]:
		delete_doc("DocType", dt)
	
	# remove search criteria
	delete_doc("Search Criteria", "Trial Balance")

def delete_unwanted_mappers():
	"deletes unwanted mappers"
	
	lst = ['Customer Issue-Maintenance Report', 'Enquiry-Service Quotation', 'Sales Order-Maintenance Report', 'Service Quotation-Service Order', 'Supplier Quotation-Purchase Order', 'Visit Schedule-Maintenance Report', 'RFQ-Supplier Quotation', 'Indent-RFQ']
	for d in lst:
		try:
			delete_doc('DocType Mapper', d)
		except:
			pass	

def execute():
    import webnotes
    from webnotes.model import delete_doc
    from webnotes.model.code import get_obj
    from webnotes.model.doc import addchild

    # delete doctypes and tables
    for dt in [
        "TDS Payment",
        "TDS Return Acknowledgement",
        "Form 16A",
        "TDS Rate Chart",
        "TDS Category",
        "TDS Control",
        "TDS Detail",
        "TDS Payment Detail",
        "TDS Rate Detail",
        "TDS Category Account",
        "Form 16A Ack Detail",
        "Form 16A Tax Detail",
    ]:
        delete_doc("DocType", dt)

        webnotes.conn.commit()
        webnotes.conn.sql("drop table if exists `tab%s`" % dt)
        webnotes.conn.begin()

    delete_doc("Search Criteria", "tds_return")

    # Add tds entry in tax table for purchase invoice
    pi_list = webnotes.conn.sql(
        """select name from `tabPurchase Invoice` 
		where ifnull(tax_code, '')!='' and ifnull(ded_amount, 0)!=0"""
    )
    for pi in pi_list:
        piobj = get_obj("Purchase Invoice", pi[0], with_children=1)
        ch = addchild(piobj.doc, "taxes_and_charges", "Purchase Taxes and Charges")
        ch.charge_type = "Actual"
        ch.account_head = piobj.doc.tax_code
        ch.description = piobj.doc.tax_code
        ch.rate = -1 * piobj.doc.ded_amount
        ch.tax_amount = -1 * piobj.doc.ded_amount
        ch.category = "Total"
        ch.save(1)

        # Add tds entry in entries table for journal voucher
    jv_list = webnotes.conn.sql(
        """select name from `tabJournal Voucher` 
		where ifnull(tax_code, '')!='' and ifnull(ded_amount, 0)!=0"""
    )
    for jv in jv_list:
        jvobj = get_obj("Journal Voucher", jv[0], with_children=1)
        ch = addchild(jvobj.doc, "entries", "Journal Voucher Detail")
        ch.account = jvobj.doc.tax_code
        ch.credit = jvobj.doc.ded_amount
        ch.save(1)

def del_packing_slip_pf():
	"""
		Delete Print Format: 'Delivery Note Packing List Wise'
	"""
	webnotes.conn.sql("""\
		DELETE FROM `tabDocFormat`
		WHERE parent='Delivery Note'
		AND format='Delivery Note Packing List Wise'""")
	from webnotes.model import delete_doc
	delete_doc('Print Format', 'Delivery Note Packing List Wise')

def delete_items():
    il = eval(webnotes.form_dict.get("items"))
    from webnotes.model import delete_doc
    from webnotes.model.code import get_obj

    for d in il:
        dt_obj = get_obj(d[0], d[1])
        if hasattr(dt_obj, "on_trash"):
            dt_obj.on_trash()
        delete_doc(d[0], d[1])

def execute():
	"""
		deprecate:
		* doctype - import data control
		* page - import data (old)
	"""
	import webnotes
	from webnotes.model import delete_doc
	delete_doc('DocType', 'Import Data Control')
	delete_doc('Page', 'Import Data')

def delete_unwanted_search_criteria():
	"deletes search criteria which are not used anymore"
	
	sql("update `tabSearch Criteria` set module = 'HR' where name = 'salary_structure_details'")
	
	lst = ['_SRCH00002', '_SRCH00001', 'warranty-amc_summary1', 'test_so4', 'test_so3', 'test_so2', 'test_so1', 'test_so', 'test5', 'target_variance_report1', 'STDSRCH/00006', 'STDSRCH/00005', 'STDSRCH/00004', 'STDSRCH/00003', 'STDSRCH/00002', 'STDSRCH/00001', 'so_pending_items_6', 'so_pending_items_5', 'so_pending_items_3', 'so_pending_items_34', 'scrap', 'sales_report_test', 'salary_structure_details1', 'salary_structure_details2', 'salary_structure_details3', 'salary_slips1', 'projectwise_pending_qty_and_costs2', 'projectwise_pending_qty_and_costs1', 'projectwise_delivered_qty_and_costs1', 'projectwise_delivered_qty_and_costs2', 'New Search Criteria 1', 'monthly_salary_register2', 'monthly_salary_register1', 'installed_items','follow_up_history', 'follow_up_report', 'employee_in_company_experience2', 'employee_in_company_experience1', 'employee_in_company_experience', 'employee_details', 'employee_details1', 'employee_details2', 'employees_birthday1', 'draft_so_pending_items', 'draft_sales_orders', 'delivery_notewise_pending_qty_to_install', 'datewise_leave_report2', 'datewise_leave_report1', 'datewise_leave_report', 'customer_issues1', 'cancelled_so_pending_items1', 'cancelled_so_pending_items', 'budget_variance_report3', 'budget_variance_report1', 'account_-_inputs_rg_23_a_-_part_ii_wrong_one', 'territory_item_group_wise_gp', 'sales_orderwise_pending_packing_item_summary', 'itemwise_trend', 'monthly_attendance_details_old', 'projectwise_contribution_report', 'projectwise_delivery_and_material_cost', 'projectwise_delivery_and_mat_cost_report', 'territorywise_trend', 'test_dn', 'rfq', 'rfq1']
	
	for d in lst:
		if sql("select name from `tabSearch Criteria` where ifnull(standard, 'Yes') = 'Yes' and name = '%s'" % d):
			try:
				delete_doc('Search Criteria', d)
			except:
				pass

def delete_items():
	"""delete selected items"""
	import json
	from webnotes.model import delete_doc
	from webnotes.model.code import get_obj

	il = json.loads(webnotes.form_dict.get('items'))
	doctype = webnotes.form_dict.get('doctype')
	
	for d in il:
		dt_obj = get_obj(doctype, d)
		if hasattr(dt_obj, 'on_trash'):
			dt_obj.on_trash()
		delete_doc(doctype, d)