package dell_system;
import databases.DBConnector;
import targets.Department;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class Dell_department {
	// ²éѯËùÓв¿ÃÅ
	static List<Department> departments=null;
	public static List<Department> getAllDepartments() throws SQLException {
		departments= new ArrayList<>();
		ResultSet rs = DBConnector.queryTableData("department");

		while (rs.next()) {
			Department dept = new Department();
			dept.setId(rs.getString("id"));
			dept.setDepartmentName(rs.getString("department_name"));
			dept.setAddedBy(rs.getString("added_by"));
			dept.setCompany(rs.getString("company"));
			dept.setViewPermission(rs.getString("view_permission"));
			dept.setAddPermission(rs.getString("add_permission"));
			dept.setEditPermission(rs.getString("edit_permission"));
			dept.setDeletePermission(rs.getString("delete_permission"));
			dept.setAddedDate(rs.getString("added_date"));
			dept.setReserved1(rs.getString("reserved1"));
			dept.setReserved2(rs.getString("reserved2"));
			dept.setReserved3(rs.getString("reserved3"));
			dept.setReserved4(rs.getString("reserved4"));
			departments.add(dept);
		}
		return departments;
	}

	// ÐÂÔö²¿ÃÅ
	public static void insertDepartment(Department department) throws SQLException {
		String sql = "INSERT INTO department (department_name, company, added_by) " +
				"VALUES (?, ?, ?)";
		DBConnector.executeUpdate(sql,
				department.getDepartmentName(),
				department.getCompany(),
				department.getAddedBy());
	}

	// ɾ³ý²¿ÃÅ
	public static void deleteDepartment(String departmentId) throws SQLException {
		String sql = "DELETE FROM department WHERE id = ?";
		DBConnector.executeUpdate(sql, departmentId);
	}


	// ¸üв¿ÃÅ
	public static void updateDepartment(Department department) throws SQLException {
		String sql = "UPDATE department SET department_name = ?, company = ?, " +
				"view_permission = ?, add_permission = ?, " +
				"edit_permission = ?, delete_permission = ? " +
				"WHERE id = ?";
		DBConnector.executeUpdate(sql,
				department.getDepartmentName(),
				department.getCompany(),
				department.getViewPermission(),
				department.getAddPermission(),
				department.getEditPermission(),
				department.getDeletePermission(),
				department.getId());
	}

	// ÐÂÔö·½·¨£º»ñÈ¡ËùÓв¿ÃÅÃû³ÆµÄ×Ö·û´®Êý×é 	
	public static String[] getAllDepartmentNames() {
	    if (departments == null || departments.isEmpty()) {
	        return new String[0]; // ·µ»Ø¿ÕÊý×é¶ø²»ÊÇnull
	    }
	    
	    String[] departmentNames = new String[departments.size()];
	    for (int i = 0; i < departments.size(); i++) {
	        departmentNames[i] = departments.get(i).getDepartmentName();
	    }
	    
	    return departmentNames;
	}

	// ¼ì²éÃû³ÆÊÇ·ñ´æÔÚ
	public static boolean isDepartmentNameExists(String Name) {
		if (departments== null) return false;
		for (Department f : departments) {
			if (Name.equals(f.getDepartmentName())) {
				return true;
			}
		}
		return false;
	}
}