package tbDataModel_Dell;
import DataBase.DatabaseManagement;
import PbuliClass.ShowMessage;
import home.Open_soft_dialog;
import tbDataModel.tb_line;

import java.util.Arrays;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;

public class Dell_tbline {
    static Vector<tb_line> line = new Vector<>();
    public static Vector<tb_line> getLine_vector() {
        return line;
    }
    static int add=0;//Êý¾Ý¿âÐÂÔö×ֶΠ2023.08.21 zsh

    /**³õʼ»¯Êý¾Ý*/
    @SuppressWarnings("rawtypes")
    public static void chushihua(){
        Open_soft_dialog.addara("¼ÓÔØtb_line");
        Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_line").iterator();
        while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
            List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
            if (info.size()<10) {
                addziDuan(info.size());
            }
            tb_line line1=new tb_line();
            line1.setId((String) info.get(0));
            line1.setFlr((String)info.get(1));
            line1.setGrp((String)info.get(2));
            line1.setVnum((String)info.get(3));
            String ints = (String) info.get(4);
            String ints1 = (String) info.get(5);
            String substring = ints.substring(1, ints.length() - 1);
            String substring1 = ints1.substring(1, ints1.length() - 1);
            String[] x = substring.trim().split(",");
            String[] y = substring1.trim().split(",");
            int length = x.length;
            int[] xs=new int[length];
            int[] ys=new int[length];
            for (int i=0;i<length;i++){
                xs[i]= Integer.parseInt(x[i].trim());
                ys[i]= Integer.parseInt(y[i].trim());
            }
            line1.setPx(xs);
            line1.setPy(ys);
            line1.setLineId((String) info.get(7));
            String s = (String) info.get(8);
            if (s==null){
                s="0";
            }
            line1.setBaoliu1(s);
            line.add(line1);
        }
    }

    //¸øÊý¾Ý¿âÌí¼Ó×ֶΠ 2023.08.21 zsh
    private static void addziDuan(int size) {
        ShowMessage.zidingyi_24("ÕýÔÚ¸øtb_person±íÌí¼Ó×Ö¶Î,ÇëÖØÆô");
        if(add==0) {

            if (size<10) {
                String sql1 = "ALTER TABLE `hxzkuwb`.`tb_line` ADD baoliu1 VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 0 COMMENT '¶ÔËùÓÐͼ²ãÉúЧ'  AFTER lineId;";
                DatabaseManagement.update(sql1);
                String sql = "ALTER TABLE `hxzkuwb`.`tb_line` ADD baoliu2 VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 0 COMMENT ''  AFTER baoliu1;";
                DatabaseManagement.update(sql);
                String sql3 = "ALTER TABLE `hxzkuwb`.`tb_line` ADD baoliu3 VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 0 COMMENT ''  AFTER baoliu2;";
                DatabaseManagement.update(sql3);
            }
            add=1;
            System.exit(-1);
        }
    }


    public static void add(  String flr,
                             String grp,
                             String vnum,
                             int[] px,
                             int[] py,
                             String allFloor){
        tb_line li = new tb_line();
        li.setFlr(flr);
        li.setGrp(grp);
        li.setVnum(vnum);
        li.setPx(px);
        li.setPy(py);
        li.setBaoliu1(allFloor);
        line.add(li);
    }

    /**
     * Ïò¼¯ºÏÖÐÌí¼ÓÒ»¸ö¶à¶ÎÏß±í
     *
     * @param id
     * @param flr
     * @param grp
     * @param vnum
     * @param px
     * @param py
     * @param wd
     */
    public static void insert_line(
            String id,
            String flr,
            String grp,
            String vnum,
            int[] px,
            int[] py,
            String wd,
            String allFloor
    ) {
        String[] ziduan = { "flr", "grp", "vnum", "px", "py", "wd","lineId","baoliu1"};
        String[] zhi = {flr, grp,vnum,Arrays.toString(px), Arrays.toString(py), String.valueOf(wd),String.valueOf(id),allFloor};
        boolean a = DatabaseManagement.insertfast("tb_line", ziduan, zhi);
        if (a) {
            tb_line li = new tb_line();
            li.setLineId(id);
            li.setFlr(flr);
            li.setGrp(grp);
            li.setVnum(vnum);
            li.setPx(px);
            li.setPy(py);
            li.setWd(wd);
            li.setBaoliu1(allFloor);//¶ÔËùÓÐͼ²ãÉúЧ  2023.08.21 zsh
            line.add(li);
        }
    }

    /**ɾ³ý¼¯ºÏÖеÄij¸öΧÀ¸¶ÔÏó*/
    public static void  delete_line(String name) {
        if( found(name) !=null) {
            line.remove(found(name));
            String deleteSql1="DELETE FROM tb_line WHERE lineId='"+name+"'";
            DatabaseManagement.update(deleteSql1);
        }
    }
    /**ɾ³ý¼¯ºÏÖеÄËùÓÐΧÀ¸¶ÔÏó*/
    public static void  delete_all_line() {
        line.removeAllElements();
    }
    /**ÕÒµ½Ä³¸öһάÏ߶ÔÏóͨ¹ýÃû³Æ*/
    public static tb_line found(String name) {
        tb_line poly=null;
        if(line.size() !=0) {
            for(int i=0;i<line.size();i++) {
                tb_line poly1=line.get(i);
                String name1=poly1.getLineId();
                if(name1.equals(name)) {
                    poly=poly1;
                    break;
                }
            }
        }
        return poly;
    }

    //ɾ³ýÈ«²¿
    public static void delete_all() {
        if(line.size() !=0) {
            line.removeAllElements();
        }
    }


    //ÐÞ¸Ä
    public static void alert(int[] x,int[] y,String name) {
        tb_line line=found(name);
        if(line==null) {
            return;
        }
        line.setPx(x);
        line.setPy(y);
    }
}