package Frame;

import ColorAndFont.English;
import ColorAndFont.UIColor;
import ColorAndFont.buttonTitle;
import Company.Dell_tbCompany;
import Company.tb_company;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import PbuliClass.*;
import tbDataModel.TbDepartment;

import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.awt.event.KeyListener;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;

public class CompanyController extends jinternalFrame {
    private static final long serialVersionUID = 1L;


    JPanel northJpanel=null;//±±²¿Ãæ°å
    JTextField searchFileld=null;//ËÑË÷Îı¾¿ò
    JButtonModel search=null;//ËÑË÷°´Å¥
    JButtonModel shuaxin=null;//ˢа´Å¥
    JButtonModel xin_zeng=null;//ÐÂÔö°´Å¥
    JButtonModel xiu_gai=null;//Ð޸İ´Å¥
    JButtonModel delete=null;//ɾ³ý°´Å¥
    JButtonModel deleteAll=null;//È«²¿É¾³ý°´Å¥
    JTable table=null;//ÉêÃ÷±í¸ñ
    Vector<Vector<String>> rowData=null;
    DefaultTableModel tableModel;//±í¸ñÄ£ÐÍ
    int selectedRow;//±»Ñ¡ÖеÄÐÐ
    List<?> list;
    TbDepartment departmentInfo=null;
    Container rq;
    JScrollPane gd;

    public CompanyController() {
        rowData=new Vector<Vector<String>>();
        String title="¹«Ë¾¹ÜÀí";
        if(Systems.sys().getLanguage().equals("English")) {
            title="Department management";
        }
        this.setTitle(title);
        rq=getContentPane();//»ñÈ¡ÈÝÆ÷
        rq.setLayout(new BorderLayout());
        rq.setBackground(UIColor.getNorth_color());
        rq.add(getNorthJpanel(),BorderLayout.NORTH);
        rq.add(getGd());
        this.setFrameIcon(new ImageIcon("image/icon/bumenicon.png"));//ÉèÖô°Ìåͼ±ê

    }

    //»ñÈ¡±±²¿Ãæ°å
    public JPanel getNorthJpanel() {
        if(northJpanel==null) {
            northJpanel=new JPanel();
            Box topicBox = Box.createHorizontalBox();// ´´½¨Ò»¸öˮƽÏäÈÝÆ÷
            topicBox.add(getSearchFileld());//Ìí¼ÓËÑË÷Îı¾¿ò
            topicBox.add(Box.createHorizontalStrut(3));// Ìí¼ÓÒ»¸ö3ÏñËØ¿íµÄˮƽ֧Öù
            topicBox.add(getSearch());
            topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
            topicBox.add(getShuaxin());
            topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
            topicBox.add(getXin_zeng());
            topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
            topicBox.add(getXiu_gai());
            topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
            topicBox.add(getDelete());//Ìí¼Óɾ³ý°´Å¥
            topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
            topicBox.add(getDeleteAll());//Ìí¼Óɾ³ýÈ«²¿°´Å¥
            northJpanel.add(topicBox );
        }

        return northJpanel;
    }



    //»ñÈ¡ËÑË÷Îı¾¿òµÄ·½·¨
    public JTextField getSearchFileld() {
        if(searchFileld==null){
            searchFileld=new JTextField(10);
            searchFileld.addKeyListener(new KeyListener() {	//¼üÅÌʼþ¼àÌý
                public void keyTyped(KeyEvent e) {
                }
                public void keyReleased(KeyEvent e) {
                    int keyCode=e.getKeyCode();
                    if(keyCode==KeyEvent.VK_ENTER) {
                        getSearch().doClick();//ËÑË÷°´Å¥±»µã»÷
                    }
                }
                public void keyPressed(KeyEvent e) {
                }
            });
        }
        return searchFileld;
    }


    //»ñÈ¡ËÑË÷°´Å¥µÄ·½·¨
    public JButtonModel getSearch() {
        if(search==null){
            search=new JButtonModel("ËÑË÷");
            search.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    String serch=getSearchFileld().getText();
                    if(Dell_tbCompany.get_company(serch)==null) {
                        ShowMessage.zidingyi("ÄãËÑË÷µÄ"+serch+"²»´æÔÚ£¡");
                        return;
                    }

                    int num=table.getRowCount();//±í¸ñ×ÜÐÐÊý
                    if(num >0 ) {
                        for (int i = 0; i < num; i++) {//ɾ³ýËùÓÐÐÐ
                            tableModel.removeRow(0);
                        }
                        //½«ÁбíÖÐËùÓнá¹û¼¯¸øµ½list¼¯ºÏ
                        getRowData(Dell_tbCompany.get_companyList(serch));
                    }

                }
            });
        }
        return search;
    }


    //»ñȡˢа´Å¥µÄ·½·¨
    public JButtonModel getShuaxin() {
        if(shuaxin==null){
            shuaxin=new JButtonModel(buttonTitle.getRefresh());
            shuaxin.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    updateTable();
                }
            });

        }
        return shuaxin;
    }
    //»ñÈ¡Ð޸İ´Å¥µÄ·½·¨
    public JButtonModel getXiu_gai() {
        if(xiu_gai==null){
            xiu_gai=new JButtonModel(buttonTitle.getAlert());
            xiu_gai.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    int selectedRow=table.getSelectedRow();//±»Ñ¡ÖÐÐеÄË÷Òý
                    if(selectedRow !=(-1)) {
                        new Xiu_gai_Dialog("Ð޸Ĺ«Ë¾ÐÅÏ¢");
                    }
                    else {
                        ShowMessage.zidingyi("ÇëÑ¡ÖÐÐèÒªÐ޸ĵÄÐУ¡");
                        return;
                    }
                    updateTable();

                }
            });
        }
        return xiu_gai;
    }

    //ÐÂÔö°´Å¥
    public JButtonModel getXin_zeng() {
        if(xin_zeng==null){
            xin_zeng=new JButtonModel(buttonTitle.getAddOne());
            xin_zeng.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    new xin_zeng_dialog("ÐÂÔö¹«Ë¾¶Ô»°¿ò");
                }
            });
        }
        return xin_zeng;
    }

    //»ñȡɾ³ý°´Å¥µÄ·½·¨
    public JButtonModel getDelete() {
        if(delete==null){
            delete=new JButtonModel(buttonTitle.getDelete());
            delete.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {

                    int[] selectedRows=table.getSelectedRows();//±»Ñ¡ÖÐÐеÄË÷Òý¼¯ºÏ
                    int ok=0;
                    if(selectedRows.length !=0) {
                        for(int i=0;i<selectedRows.length;i++){
                            String departmentName=(String) table.getValueAt(selectedRows[i], 0);
                            Dell_tbCompany.delete_company(departmentName);
                        }
                        //ɾ³ý³É¹¦ÌáʾÐÅÏ¢
                        if(ok !=0) {
                            updateTable();//ˢбí¸ñ
                            ShowMessage.zidingyi(selectedRows.length+"Ìõ¼Ç¼ɾ³ý³É¹¦£¡");
                        }else {
                            ShowMessage.zidingyi("дÈëÊý¾Ý¿â³ö´í£¡");
                        }
                    }
                    else {
                        ShowMessage.zidingyi("ÇëÑ¡ÖÐÐèҪɾ³ýµÄÐУ¡");
                        return;
                    }
                    updateTable();
                }
            });
        }
        return delete;
    }
    //»ñÈ¡È«²¿É¾³ý°´Å¥µÄ·½·¨
    public JButtonModel getDeleteAll() {
        if(deleteAll==null){
            deleteAll=new JButtonModel(buttonTitle.getDeleteall());
            deleteAll.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    //Ñ¡Ôñ¶Ô»°¿òÈçyes·µ»Ø0£¬NO·µ»Ø1£¬È¡Ïû·µ»Ø2
                    WarningMessage warning=new WarningMessage();
                    warning.setMessage("Ñ¡Ôñɾ³ýÈ«²¿½«»á°Ñ±í¸ñÊý¾ÝÈ«²¿É¾³ýÈ·¶¨Âð£¿");
                    int warn=warning.getwarMss(northJpanel );
                    int tagnum=table.getRowCount();//±í¸ñ×ÜÐÐÊý
                    if(tagnum!=0 && warn==0) {
                        String deleteSql="TRUNCATE TABLE tb_Company";
                        ShowMessage.deleteAll(DatabaseManagement.update(deleteSql));
                        Dell_tbCompany.delete_all_company();

                    }
                }
            });

        }
        return deleteAll;
    }


    //»ñÈ¡¹ö¶¯Ãæ°åµÄ·½·¨
    public JScrollPane getGd() {
        gd=new JScrollPane(getTable());
        gd.getViewport().setBackground(UIColor.getNorth_color());
        return gd;
    }


    //Ìí¼Ó±í¸ñÐÐÏòÁ¿Êý¾Ý·½·¨
    public void getRowData(Vector<tb_company> list ) {
        Iterator<tb_company> iterator = list.iterator();//´´½¨µü´úÆ÷
        while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
            tb_company depa= (tb_company) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½list¼¯ºÏ
            Vector<String> rowV = new Vector<String>();
            rowV.add( depa.getCompanyName());// ¹«Ë¾Ãû³Æ
            rowV.add(depa.getAddtime());// Ìí¼Óʱ¼ä
            rowData.add(rowV);// Ïò±í¸ñ¶ÔÏóÌí¼ÓÐÐÊý¾Ý
        }

    }


    //»ñÈ¡¸ñµÄ·½·¨

    @SuppressWarnings("serial")
    public JTable getTable() {//»ñÈ¡table
        if(table==null) {
            String[] name1= {"¹«Ë¾Ãû³Æ","Ìí¼Óʱ¼ä"};//±í¸ñÁÐÃû
            String[] name2= {"Department Name","Add Time"};//±í¸ñÁÐÃû
            String[] columnNames= English.columnNames(name1, name2);
            //Ìí¼Ó±í¸ñÁÐÏòÁ¿
            Vector<String>  columnName=new Vector<>();
            for(int i=0;i<columnNames.length;i++){
                columnName.add(columnNames[i]);
            }
            greateTables tables=new greateTables();
            tableModel=new DefaultTableModel(rowData, columnName){
                //  ʵÏÖÈÃÕû¸ö±í¸ñ²»²»ÔÊÐí±»±à¼­
                public boolean isCellEditable(int row,int column){
                    return false;
                }
            };

            table=tables.getTable(tableModel);
            getRowData(Dell_tbCompany.getCompany_vector());
            table.setRowHeight(50);//ÉèÖñí¸ñÐиß

        }
        return table;

    }

    /**ˢбí¸ñ·½·¨*/
    public void updateTable() {
        if(tableModel !=null) {
            tableModel.getDataVector().clear();
            getRowData(Dell_tbCompany.getCompany_vector());
            gd.validate();
        }
    }

    /**»ñÈ¡±í¸ñ±»Ñ¡ÖеÄÐз½·¨*/
    public int getSelectedRow() {
        selectedRow=getTable().getSelectedRow();
        return selectedRow;

    }


    //ÄÚ²¿Àà
    class Xiu_gai_Dialog extends JDialog{

        /**
         *
         */
        private static final long serialVersionUID = 1L;

        JlableModel bumen=new JlableModel("  ¹«Ë¾Ãû³Æ£º ");
        JButtonModel que_ding=null;//È·¶¨°´Å¥
        JButtonModel qu_xiao=null;//È¡Ïû°´Å¥
        JPanel mb=null;//ÉêÃ÷Ò»¸öÃæ°å
        JTextField CompanyName;//²¿ÃÅÃû³Æ
        public Xiu_gai_Dialog(String title) {
            this.setAlwaysOnTop(true);//×ÜÊÇÖö¥
            Toolkit toolkit = getToolkit();// »ñµÃ´°Ì幤¾ß°ü
            Dimension screenSize = toolkit.getScreenSize();// »ñÈ¡ÆÁÄ»´óС
            int width = (int) (screenSize.width* 0.5);// ¼ÆËã´°Ìåпí¶È
            int height = (int) (screenSize.height * 0.5);// ¼ÆËã´°Ìåпí¶È
            int x0=width-175;//´°Ìåx0×ø±ê
            int y0=height-175;//´°Ìåy0×ø±ê
            Container rq=getContentPane();
            rq.add(getMb());
            this.setTitle(title);
            this.setBounds(x0, y0, 260,140);
            this.setVisible(true);

        }



        /**»ñÈ¡È·¶¨°´Å¥µÄ·½·¨*/
        public JButtonModel getQue_ding() {
            if(que_ding==null){
                que_ding=new JButtonModel("È·¶¨");
                que_ding.addActionListener(new ActionListener() {
                    public void actionPerformed(ActionEvent e) {
                        String name=getBumenNameText().getText().trim();//²¿ÃÅÃû³Æ
                        String updateSQL="UPDATE tb_company SET companyName='"+name+"'where companyName='"+name+"'";

                        if(DatabaseManagement.update(updateSQL) !=0) {
                           // Dell_tbCompany.(name);
                            updateTable();//ˢбí¸ñ
                            ShowMessage.zidingyi("Êý¾ÝÐ޸ijɹ¦£¡");
                        }else {
                            ShowMessage.zidingyi("дÈëÊý¾Ý¿â³ö´í£¡");
                        }

                    }
                });

            }
            return que_ding;
        }
        /**»ñÈ¡È¡Ïû°´Å¥µÄ·½·¨*/
        public JButtonModel getQu_xiao() {
            if(qu_xiao==null){
                qu_xiao=new JButtonModel("È¡Ïû");
                qu_xiao.addActionListener(new ActionListener() {
                    public void actionPerformed(ActionEvent e) {
                        closeTagDialog();

                    }
                });

            }
            return qu_xiao;
        }


        /**»ñÈ¡¹«Ë¾Ãû³Æ*/
        public JTextField getBumenNameText() {
            if(CompanyName==null) {
                CompanyName=new JTextField(10);
                CompanyName.setText((String) getTable().getValueAt(getSelectedRow(),0));

            }
            return CompanyName;
        };


        /**¹Ø±Õ¶Ô»°¿ò·½·¨*/
        public void closeTagDialog() {
            this.dispose();

        }

        /**»ñÈ¡Ãæ°å*/
        public JPanel getMb() {
            if(mb==null){
                mb=new JPanel();
                mb.setLayout(new GridLayout(3, 1,5,5));
                JPanel mb1=new JPanel();
                mb1.setLayout(new FlowLayout(FlowLayout.LEFT));
                JPanel mb3=new JPanel();
                mb3.setLayout(new FlowLayout(FlowLayout.CENTER));
                mb1.add(bumen);
                mb1.add(getBumenNameText());
                mb3.add(getQue_ding());
                mb3.add(getQu_xiao());
                mb.add(mb1);
                mb.add(mb3);
            }

            return mb;
        }




    }

    //ÐÂÔöÄÚ²¿Àà
    class xin_zeng_dialog extends Xiu_gai_Dialog {

        /**
         *
         */
        private static final long serialVersionUID = 1L;

        public xin_zeng_dialog(String title) {
            super(title);
        }


        /**»ñÈ¡¹«Ë¾Ãû³Æ*/
        public JTextField getBumenNameText() {
            if(CompanyName==null) {
                CompanyName=new JTextField(10);
            }
            return CompanyName;
        };

        /**»ñÈ¡È·¶¨°´Å¥µÄ·½·¨*/
        public JButtonModel getQue_ding() {
            if(que_ding==null){
                que_ding=new JButtonModel("È·¶¨");
                que_ding.addActionListener(new ActionListener() {
                    public void actionPerformed(ActionEvent e) {
                        String name=getBumenNameText().getText().trim();//²¿ÃÅÃû³Æ
                        if(Dell_tbCompany.get_company(name) !=null) {
                            ShowMessage.zidingyi(name+"¹«Ë¾Ãû³ÆÒѾ­´æÔÚ²»ÄÜÖظ´Ìí¼Ó£¡");
                            return;
                        }
                        if(name.equals("")) {
                            ShowMessage.zidingyi("¹«Ë¾Ãû³Æ²»ÄÜΪ¿Õ");
                            return;
                        }

                        String[]  ziduan= {"companyName","addtime"};
                        String[] zhi= {name, GetNowTime.now()};

                        if(DatabaseManagement.insertfast("tb_company", ziduan, zhi)) {
                            Dell_tbCompany.add_company(name);
                            updateTable();//ˢбí¸ñ
                            ShowMessage.zidingyi("Êý¾ÝдÈë³É¹¦£¡");
                        }else {
                            ShowMessage.zidingyi("дÈëÊý¾Ý¿â³ö´í£¡");
                        }

                    }
                });

            }
            return que_ding;
        }

    }

}