package dell_suanfa;
import databases.DBConnector;
import targets.GroupManagement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

// ×é¹ÜÀíÊý¾Ý²Ù×÷Àà
public class Dell_GroupManagement {
	static List<GroupManagement> groups=null;
    // »ñÈ¡ËùÓÐ×éÐÅÏ¢
    public static List<GroupManagement> getAllGroups() throws SQLException {
        groups = new ArrayList<>(); // ´´½¨×éÁбí
        // ²éѯ×é¹ÜÀí±íÊý¾Ý
        ResultSet rs = DBConnector.queryTableData("group_management");
        
        while (rs.next()) { // ±éÀú½á¹û¼¯
            GroupManagement group = new GroupManagement(); // ´´½¨×é¶ÔÏó
            // ÉèÖÃ×éÊôÐÔ
            group.setId(rs.getString("id")); // ÉèÖÃID
            group.setGroupNumber(rs.getString("group_number")); // ÉèÖÃ×é±àºÅ
            group.setBelongLayer(rs.getString("belong_layer")); // ÉèÖÃËùÊô²ã
            group.setAlgorithm(rs.getString("algorithm")); // ÉèÖÃËã·¨
            group.setOutdoorGroup(rs.getString("outdoor_group")); // ÉèÖÃÊÒÍâ×é±êʶ
            group.setMustPassGroup(rs.getString("must_pass_group")); // ÉèÖñؾ­×é±êʶ
            group.setCrossMultilayer(rs.getString("cross_multilayer")); // ÉèÖÿç¶à²ã±êʶ
            group.setGroupWidth(rs.getString("group_width")); // ÉèÖÃ×é¿í¶È
            group.setValidArea(rs.getString("valid_area")); // ÉèÖÃÓÐЧÇøÓò
            group.setCompany(rs.getString("company")); // ÉèÖÃËùÊô¹«Ë¾
            group.setAddTime(rs.getString("add_time")); // ÉèÖÃÌí¼Óʱ¼ä
            groups.add(group); // Ìí¼Óµ½Áбí
        }
        return groups; // ·µ»Ø×éÁбí
    }
    
    // Ìí¼ÓÐÂ×é
    public static void insertGroup(GroupManagement group) throws SQLException {
        // ²åÈëSQLÓï¾ä
        String sql = "INSERT INTO group_management (group_number, belong_layer, algorithm, outdoor_group, must_pass_group, cross_multilayer, group_width, valid_area, company, add_time) " +
                     "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
        // Ö´ÐиüвÙ×÷
        DBConnector.executeUpdate(sql,
                group.getGroupNumber(),
                group.getBelongLayer(),
                group.getAlgorithm(),
                group.getOutdoorGroup(),
                group.getMustPassGroup(),
                group.getCrossMultilayer(),
                group.getGroupWidth(),
                group.getValidArea(),
                group.getCompany(),
                group.getAddTime());
    }
    
    // ¸üÐÂ×éÐÅÏ¢
    public static void updateGroup(GroupManagement group) throws SQLException {
        // ¸üÐÂSQLÓï¾ä
        String sql = "UPDATE group_management SET group_number = ?, belong_layer = ?, algorithm = ?, outdoor_group = ?, must_pass_group = ?, cross_multilayer = ?, group_width = ?, valid_area = ?, company = ? WHERE id = ?";
        // Ö´ÐиüвÙ×÷
        DBConnector.executeUpdate(sql,
                group.getGroupNumber(),
                group.getBelongLayer(),
                group.getAlgorithm(),
                group.getOutdoorGroup(),
                group.getMustPassGroup(),
                group.getCrossMultilayer(),
                group.getGroupWidth(),
                group.getValidArea(),
                group.getCompany(),
                group.getId());
    }
    
    // ɾ³ý×é
    public static void deleteGroup(int groupId) throws SQLException {
        // ɾ³ýSQLÓï¾ä
        String sql = "DELETE FROM group_management WHERE id = ?";
        // Ö´ÐÐɾ³ý²Ù×÷
        DBConnector.executeUpdate(sql, groupId);
    }
    
    /**
     * ´ÓËùÓÐÒѼÓÔصÄ×éÐÅÏ¢ÖÐÌáÈ¡×é±àºÅÁбí
     * @return ËùÓÐ×é±àºÅÊý×飬ÈôÁбíΪ¿ÕÔò·µ»Ø¿ÕÊý×飨·Ç null£©
     */
    public static String[] getAllGroupNumbers() {
        if (groups == null || groups.isEmpty()) {
            return new String[0];
        }

        String[] groupNumbers = new String[groups.size()];
        for (int i = 0; i < groups.size(); i++) {
            groupNumbers[i] = groups.get(i).getGroupNumber();
        }
        return groupNumbers;
    }
}