from __future__ import unicode_literals

import frappe

# Set department value based on employee value

def execute():

	doctypes_to_update = {
		'hr': ['Appraisal', 'Leave Allocation', 'Expense Claim', 'Salary Slip',
			'Attendance', 'Training Feedback', 'Training Result Employee','Leave Application',
			'Employee Advance', 'Training Event Employee', 'Payroll Employee Detail'],
		'education': ['Instructor'],
		'projects': ['Activity Cost', 'Timesheet'],
		'setup': ['Sales Person']
	}

	for module, doctypes in doctypes_to_update.items():
		for doctype in doctypes:
			if frappe.db.table_exists(doctype):
				frappe.reload_doc(module, 'doctype', frappe.scrub(doctype))
				frappe.db.sql("""
					update `tab%s` dt
					set department=(select department from `tabEmployee` where name=dt.employee)
				""" % doctype)
