package dell_map;
import databases.DBConnector;
import publicsWay.CoordinateTranslator;
import targets.Csxy;
import targets.Mapdata;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import java.util.Locale;
import java.util.Map;
import java.util.MissingResourceException;
import java.util.PropertyResourceBundle;
import java.util.ResourceBundle;
import java.util.Vector;
import java.util.concurrent.ConcurrentHashMap;
import javax.swing.JOptionPane;

public class Dell_Map {
    static List<Mapdata> maps = null;
    public static Vector<Csxy> csxyvc = new Vector<>();
    private static volatile Map<String, double[]> FLOOR_XYCS = Collections.emptyMap();

    public static List<Mapdata> getAllMaps() {
        maps = new ArrayList<>();
        ResultSet rs = DBConnector.queryTableData("map");
        
        try {
            while (rs.next()) {
                Mapdata map = new Mapdata();
                map.setId(Integer.parseInt(rs.getString("id")));
                map.setMapType(rs.getString("map_type"));
                map.setDetailDisplay(rs.getString("detail_display"));
                map.setOfflineDisappear(rs.getString("offline_disappear"));
                map.setVoiceEnabled(rs.getString("voice_enabled"));
                map.setFenceDisplay(rs.getString("fence_display"));
                map.setBaseStationDisplay(rs.getString("base_station_display"));
                map.setGatewayDisplay(rs.getString("gateway_display"));
                map.setVideoDisplay(rs.getString("video_display"));
                map.setInitialViewPosition(rs.getString("initial_view_position"));
                map.setViewHeight(rs.getString("view_height"));
                map.setMapHeadingAngle(rs.getString("map_heading_angle"));
                map.setMapTiltAngle(rs.getString("map_tilt_angle"));
                map.setTerrainDisabled(rs.getString("terrain_disabled"));
                map.setTileMapLoading(rs.getString("tile_map_loading"));
                map.setLocalImageLoading(rs.getString("local_image_loading"));
                map.setBasemapDisabled(rs.getString("basemap_disabled"));
                map.setThreeDModel(rs.getString("three_d_model"));
                map.setLocatedLayer(rs.getString("located_layer"));
                map.setMapName(rs.getString("map_name"));
                map.setMapNameDetaile(rs.getString("map_name_detaile"));
                map.setActualXLength(rs.getString("actual_x_length"));
                map.setActualYLength(rs.getString("actual_y_length"));
                map.setX0Coordinate(rs.getString("x0_coordinate"));
                map.setY0Coordinate(rs.getString("y0_coordinate"));
                map.setXPixels(rs.getString("x_pixels"));
                map.setYPixels(rs.getString("y_pixels"));
                map.setPointALatlngXyCoordinate(rs.getString("point_a_latlng_xy_coordinate"));
                map.setPointBLatlngXyCoordinate(rs.getString("point_b_latlng_xy_coordinate"));
                map.setCompany(rs.getString("company"));
                map.setAddedBy(rs.getString("added_by"));
                map.setAddedTime(rs.getString("added_time"));
                map.setReserved1(rs.getString("reserved1"));
                maps.add(map);
            }
        } catch (NumberFormatException | SQLException e) {
            e.printStackTrace();
        }
        return maps;
    }

    public static Mapdata getMapByName(String mapName) {
        if (maps == null || mapName == null) {
            return null;
        }
        for (Mapdata m : maps) {
            if (mapName.equals(m.getMapName())) {
                return m;
            }
        }
        return null;
    }
    
    public static void insertMap(Mapdata map) throws SQLException {
        String sql = "INSERT INTO map ("
            + "map_type, detail_display, offline_disappear, voice_enabled, fence_display, "
            + "base_station_display, gateway_display, video_display, initial_view_position, "
            + "view_height, map_heading_angle, map_tilt_angle, terrain_disabled, tile_map_loading, "
            + "local_image_loading, basemap_disabled, three_d_model, located_layer, map_name,map_name_detaile, "
            + "actual_x_length, actual_y_length, x0_coordinate, y0_coordinate, x_pixels, y_pixels, "
            + "point_a_latlng_xy_coordinate, point_b_latlng_xy_coordinate, company, added_by, added_time"
            + ") VALUES ("
            + "?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, "
            + "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, "
            + "?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
        
        DBConnector.executeUpdate(sql,
            map.getMapType(),
            map.getDetailDisplay(),
            map.getOfflineDisappear(),
            map.getVoiceEnabled(),
            map.getFenceDisplay(),
            map.getBaseStationDisplay(),
            map.getGatewayDisplay(),
            map.getVideoDisplay(),
            map.getInitialViewPosition(),
            map.getViewHeight(),
            map.getMapHeadingAngle(),
            map.getMapTiltAngle(),
            map.getTerrainDisabled(),
            map.getTileMapLoading(),
            map.getLocalImageLoading(),
            map.getBasemapDisabled(),
            map.getThreeDModel(),
            map.getLocatedLayer(),
            map.getMapName(),
            map.getMapNameDetaile(),
            map.getActualXLength(),
            map.getActualYLength(),
            map.getX0Coordinate(),
            map.getY0Coordinate(),
            map.getXPixels(),
            map.getYPixels(),
            map.getPointALatlngXyCoordinate(),
            map.getPointBLatlngXyCoordinate(),
            map.getCompany(),
            map.getAddedBy(),
            map.getAddedTime()
        );
    }
    
    public static void updateMap(Mapdata map) throws SQLException {
        String sql = "UPDATE map SET "
            + "map_type = ?, detail_display = ?, offline_disappear = ?, voice_enabled = ?, "
            + "fence_display = ?, base_station_display = ?, gateway_display = ?, video_display = ?, "
            + "initial_view_position = ?, view_height = ?, map_heading_angle = ?, map_tilt_angle = ?, "
            + "terrain_disabled = ?, tile_map_loading = ?, local_image_loading = ?, basemap_disabled = ?, "
            + "three_d_model = ?, located_layer = ?, map_name = ?, map_name_detaile = ?,actual_x_length = ?, "
            + "actual_y_length = ?, x0_coordinate = ?, y0_coordinate = ?, x_pixels = ?, y_pixels = ?, "
            + "point_a_latlng_xy_coordinate = ?, point_b_latlng_xy_coordinate = ?, company = ?, "
            + "added_by = ?, added_time = ? "
            + "WHERE id = ?";
        
        DBConnector.executeUpdate(sql,
            map.getMapType(),
            map.getDetailDisplay(),
            map.getOfflineDisappear(),
            map.getVoiceEnabled(),
            map.getFenceDisplay(),
            map.getBaseStationDisplay(),
            map.getGatewayDisplay(),
            map.getVideoDisplay(),
            map.getInitialViewPosition(),
            map.getViewHeight(),
            map.getMapHeadingAngle(),
            map.getMapTiltAngle(),
            map.getTerrainDisabled(),
            map.getTileMapLoading(),
            map.getLocalImageLoading(),
            map.getBasemapDisabled(),
            map.getThreeDModel(),
            map.getLocatedLayer(),
            map.getMapName(),
            map.getMapNameDetaile(),
            map.getActualXLength(),
            map.getActualYLength(),
            map.getX0Coordinate(),
            map.getY0Coordinate(),
            map.getXPixels(),
            map.getYPixels(),
            map.getPointALatlngXyCoordinate(),
            map.getPointBLatlngXyCoordinate(),
            map.getCompany(),
            map.getAddedBy(),
            map.getAddedTime(),
            map.getId()
        );
    }
    
    public static void deleteMap(int mapId) throws SQLException {
        String sql = "DELETE FROM map WHERE id = ?";
        DBConnector.executeUpdate(sql, mapId);
    }
    
    public static String[] getAllMapNames() {
        if (maps == null || maps.isEmpty()) {
            return new String[0];
        }
        String[] mapNames = new String[maps.size()];
        for (int i = 0; i < maps.size(); i++) {
            mapNames[i] = maps.get(i).getMapName();
        }
        return mapNames;
    }
    
    public static boolean isMapNameExist(String mapName) {
        if (maps == null || maps.isEmpty() || mapName == null) {
            return false;
        }
        for (Mapdata map : maps) {
            if (mapName.equals(map.getMapName())) {
                return true;
            }
        }
        return false;
    }
    
    public static Mapdata getMapById(int mapId) throws SQLException {
        String sql = "SELECT * FROM map WHERE id = ?";
        try (ResultSet rs = DBConnector.executeQuery(sql, mapId)) {
            if (rs.next()) {
                Mapdata map = new Mapdata();
                map.setId(Integer.parseInt(rs.getString("id")));
                map.setMapType(rs.getString("map_type"));
                map.setDetailDisplay(rs.getString("detail_display"));
                map.setOfflineDisappear(rs.getString("offline_disappear"));
                map.setVoiceEnabled(rs.getString("voice_enabled"));
                map.setFenceDisplay(rs.getString("fence_display"));
                map.setBaseStationDisplay(rs.getString("base_station_display"));
                map.setGatewayDisplay(rs.getString("gateway_display"));
                map.setVideoDisplay(rs.getString("video_display"));
                map.setInitialViewPosition(rs.getString("initial_view_position"));
                map.setViewHeight(rs.getString("view_height"));
                map.setMapHeadingAngle(rs.getString("map_heading_angle"));
                map.setMapTiltAngle(rs.getString("map_tilt_angle"));
                map.setTerrainDisabled(rs.getString("terrain_disabled"));
                map.setTileMapLoading(rs.getString("tile_map_loading"));
                map.setLocalImageLoading(rs.getString("local_image_loading"));
                map.setBasemapDisabled(rs.getString("basemap_disabled"));
                map.setThreeDModel(rs.getString("three_d_model"));
                map.setLocatedLayer(rs.getString("located_layer"));
                map.setMapName(rs.getString("map_name"));
                map.setMapNameDetaile(rs.getString("map_name_detaile"));
                map.setActualXLength(rs.getString("actual_x_length"));
                map.setActualYLength(rs.getString("actual_y_length"));
                map.setX0Coordinate(rs.getString("x0_coordinate"));
                map.setY0Coordinate(rs.getString("y0_coordinate"));
                map.setXPixels(rs.getString("x_pixels"));
                map.setYPixels(rs.getString("y_pixels"));
                map.setPointALatlngXyCoordinate(rs.getString("point_a_latlng_xy_coordinate"));
                map.setPointBLatlngXyCoordinate(rs.getString("point_b_latlng_xy_coordinate"));
                map.setCompany(rs.getString("company"));
                map.setAddedBy(rs.getString("added_by"));
                map.setAddedTime(rs.getString("added_time"));
                map.setReserved1(rs.getString("reserved1"));
                return map;
            }
        }
        return null;
    }
    
    public static Vector<Csxy> get_foor_xycs() {    	
    	 ResourceBundle bundle = loadResourceBundle();  // ʹÓÃеļÓÔØ·½·¨
        int size = maps.size();
        Vector<Csxy> result = new Vector<>(size);
        
        for (int i = 0; i < size; i++) {
            Mapdata map = maps.get(i);
            String floor = map.getLocatedLayer();
            String ajw = map.getPointALatlngXyCoordinate();
            String bjw = map.getPointBLatlngXyCoordinate();
            String[] A = ajw.split(";", -1);
            String[] B = bjw.split(";", -1);
            if (A.length < 4 || B.length < 4) {
                String errorMsg = String.format(
                    bundle.getString("INVALID_POINT_FORMAT"), 
                    map.getMapName()
                );
                JOptionPane.showMessageDialog(
                    null, 
                    errorMsg, 
                    bundle.getString("ERROR"), 
                    JOptionPane.ERROR_MESSAGE
                );
                continue;
            }
            
            try {
                double lon_a = Double.parseDouble(A[0]);
                double lat_a = Double.parseDouble(A[1]);
                double xa = Double.parseDouble(A[2]);
                double ya = Double.parseDouble(A[3]);
                double lon_b = Double.parseDouble(B[0]);
                double lat_b = Double.parseDouble(B[1]);
                double xb = Double.parseDouble(B[2]);
                double yb = Double.parseDouble(B[3]);
                
                if (lon_a == 0 || lon_b == 0 || lat_a == 0 || lat_b == 0) {
                    String errorMsg = String.format(
                        bundle.getString("ZERO_LATLON"), 
                        map.getMapName()
                    );
                    JOptionPane.showMessageDialog(
                        null, 
                        errorMsg, 
                        bundle.getString("ERROR"), 
                        JOptionPane.ERROR_MESSAGE
                    );
                    continue;
                }
                
                double[] xycs = CoordinateTranslator.computeTransformParamsWithTwoPoints(
                    lat_a, lon_a, lat_b, lon_b, xa, ya, xb, yb
                );
                
                Csxy csxy = new Csxy();
                csxy.setXycs(xycs);
                csxy.setFloor(floor);
                csxy.setAj(lon_a);
                csxy.setAw(lat_a);
                
                // Ô¤ÏȼÆËã²¢´æ´¢UTM×ø±ê
                double[] originUtm = CoordinateTranslator.ubloxraw2xy(lat_a, lon_a);
                csxy.setOriginUtmX(originUtm[0]);
                csxy.setOriginUtmY(originUtm[1]);
                
                // ת»»Â¥²ãΪÕûÊý
                try {
                    csxy.setFloorInt(Integer.parseInt(floor));
                } catch (NumberFormatException e) {
                    csxy.setFloorInt(0);
                }
                
                result.add(csxy);
            } catch (NumberFormatException e) {
                String errorMsg = String.format(
                    bundle.getString("INVALID_COORD_NUMBER"), 
                    map.getMapName()
                );
                JOptionPane.showMessageDialog(
                    null, 
                    errorMsg, 
                    bundle.getString("ERROR"), 
                    JOptionPane.ERROR_MESSAGE
                );
            }
        }
        
        // ¸üÐÂÈ«¾ÖÏòÁ¿
        csxyvc = result;
        
        // ¹¹½¨Â¥²ãת»»»º´æ
        Map<String, double[]> floorCache = new ConcurrentHashMap<>();
        for (Csxy cs : csxyvc) {
            floorCache.put(cs.getFloor(), cs.getXycs());
        }
        FLOOR_XYCS = Collections.unmodifiableMap(floorCache);
        
        return csxyvc;
    }
    
    public static double[] getXycs(String floor) {
        return FLOOR_XYCS.get(floor);
    }
    
    private static ResourceBundle loadResourceBundle() {
        // ʹÓÃϵͳĬÈÏÓïÑÔ»·¾³
        Locale locale = Locale.getDefault();
        String fileName = locale.equals(Locale.ENGLISH) ? 
                "Messages_en.properties" : "Messages_zh.properties";
        
        File langFile = new File("systemfile/" + fileName);
        
        if (!langFile.exists()) {
            System.err.println("ĬÈÏ×ÊÔ´ÎļþδÕÒµ½: " + langFile.getAbsolutePath());
            try {
                // ³¢ÊÔ´ÓÀà·¾¶¼ÓÔØ
                return ResourceBundle.getBundle("systemfile.Messages");
            } catch (MissingResourceException e) {
                throw new RuntimeException("ÎÞ·¨¼ÓÔØ×ÊÔ´Îļþ", e);
            }
        }
        
        try (InputStream inputStream = new FileInputStream(langFile)) {
            return new PropertyResourceBundle(inputStream);
        } catch (IOException e) {
            System.err.println("ÎÞ·¨¼ÓÔØ×ÊÔ´Îļþ: " + e.getMessage());
            throw new RuntimeException(e);
        }
    }
}