* Oberflache fur MySQL Vokabeln

* @author Lukas Schreiner

* @version 0.5

*/

    // Anfang Attribute

    private Vokabeln self;

    private String title;

    private Container con;

    private ImageIcon image;

    // Registerkarten

    private JTabbedPane register;

    private JComponent tab1; // Vokabeln

    private JComponent tab2; // Kategorie

    // Tabelle Kategorien

    private JScrollPane scrollKate;

    private JTable tabKate;

    private TableModel modelKate;

    // Tabelle Vokabeln

    private JScrollPane tabelle;

    private JTable tabvok;

    private TableModel model;

    private JComboBox kateg;

    private JLabel startDate;

    private JLabel endDate;

    private JDateChooser startStamp;

    private JDateChooser endStamp;

    private boolean category = true;

    private String categoryName = "";

    // Menu Attribute:   

    private JMenuBar mainMenu;

    private JMenu fileMenu;

    private JMenu trainMenu;

    private JMenu helpMenu;

    private JMenuItem newDBItem;

    private JMenuItem loadDBItem;

    private JMenuItem newVokabelItem;

    private JMenuItem newCategoryItem;

    private JMenuItem printItem;

    // Recent Menu

    private JMenu recentFiles;

    private ArrayList<JMenuItem> recentFilesItems;

    private JMenuItem exitItem;

    private JMenuItem resetVokabeln;

    private JMenuItem traineer[] = new JMenuItem[4];

    private JMenuItem aboutItem;

    private JMenuItem lizenz;

    //private JMenuItem updateItem;

    // Suchfunktion

    private JTextField searchField;

    // Ende Menu Attribute

    // Objekte

    private IniManager im;

    private MySQL ms;

    private VokabelnBackend ba;

    // Ende Attribute

    // Anfang Methoden

    public Vokabeln(){

        super();

        this.self = this;

        this.title = "Thematische Vokabellisten";

        this.con = this.getContentPane();

        this.setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        this.setResizable(true);

        this.addIcon();

        this.initConfig();

        this.connect();

        this.initMenu();

        this.initWindow();

        this.addActions();

        this.pack();

    }

    private void addIcon(){

        image = new ImageIcon("icons/application_form.png");

        this.setIconImage(image.getImage());

    }

    private void initConfig(){

        this.im = new IniManager("config.ini");

    }

    private void connect(){

        // Variablen initializieren

        this.ba = new VokabelnBackend(this.im);

        if(im.get("useSQLite", "SQLite").equals("true")){

            String sqdb = "vokabeln.db";

            sqdb = this.ba.pathToDB();

            System.err.println(":: "+sqdb);

            this.ms = new MySQL(im.get("driver", "SQLite"), sqdb, true);

        }else{

            this.ms = new MySQL(im.get("driver", "MySQL"), im.get("database", "MySQL"), im.get("host", "MySQL"), im.get("user", "MySQL"), im.get("password", "MySQL"), im.get("port", "MySQL"), false);

        }

        if(im.get("useProxy", "Proxy").equals("true")){

            this.ms.useProxy(im.get("host", "Proxy"), im.get("port", "Proxy"));

        }

        this.ba.setMySQL(this.ms);

    }

    private void initMenu(){

        // Alles erzeugen

        this.mainMenu = new JMenuBar();

        this.fileMenu = new JMenu("Datei");

        this.recentFiles = new JMenu("Zuletzt verwendet");

        this.trainMenu = new JMenu("Trainieren");

        this.helpMenu = new JMenu("Hilfe");

        // Items

        this.newDBItem = new JMenuItem("Neue Datenbank");

        this.loadDBItem = new JMenuItem("Datenbank laden");

        this.newVokabelItem = new JMenuItem("Neue Vokabel");

        this.newCategoryItem = new JMenuItem("Neue Kategorie");

        this.printItem = new JMenuItem("Liste drucken");

        this.exitItem = new JMenuItem("Beenden");

        this.lizenz = new JMenuItem("Lizenz");

        this.aboutItem = new JMenuItem("Credits");

        this.resetVokabeln = new JMenuItem("Status resetten");

        this.trainMenu.add(resetVokabeln);

        String bezeich[] = {"Alle Vokabeln","10 Vokabeln","20 Vokabeln","30 Vokabeln"};

        for(int i = 0; i < traineer.length; i++){

            this.traineer[i] = new JMenuItem(bezeich[i]);

            switch(i){

                case 0:

                    this.traineer[i].setAccelerator(KeyStroke.getKeyStroke('G', InputEvent.CTRL_DOWN_MASK));

                break;

                case 1:

                    this.traineer[i].setAccelerator(KeyStroke.getKeyStroke('H', InputEvent.CTRL_DOWN_MASK));

                break;

                case 2:

                    this.traineer[i].setAccelerator(KeyStroke.getKeyStroke('J', InputEvent.CTRL_DOWN_MASK));

                break;

                case 3:

                    this.traineer[i].setAccelerator(KeyStroke.getKeyStroke('L', InputEvent.CTRL_DOWN_MASK));

                break;

                default:

                break;

            }

            this.trainMenu.add(traineer[i]);

        }

        // Recent Files

        this.recentFilesItems = new ArrayList<JMenuItem>();

        ArrayList<String> tmple = this.ba.getRecentDatabases();

        for(String item: tmple){

            JMenuItem tmp = new JMenuItem(item);

            this.recentFilesItems.add(tmp);

            this.recentFiles.add(tmp);

        }

        // Tastenkombinationen

        this.loadDBItem.setAccelerator(KeyStroke.getKeyStroke('O', InputEvent.CTRL_DOWN_MASK));

        this.newVokabelItem.setAccelerator(KeyStroke.getKeyStroke('N', InputEvent.CTRL_DOWN_MASK));

        this.newCategoryItem.setAccelerator(KeyStroke.getKeyStroke('K', InputEvent.CTRL_DOWN_MASK));

        this.printItem.setAccelerator(KeyStroke.getKeyStroke('P', InputEvent.CTRL_DOWN_MASK));

        this.exitItem.setAccelerator(KeyStroke.getKeyStroke('Q', InputEvent.CTRL_DOWN_MASK));

        // Items den Eltern adden

        this.fileMenu.add(this.newDBItem);

        this.fileMenu.add(this.loadDBItem);

        this.fileMenu.addSeparator();

        this.fileMenu.add(this.newVokabelItem);

        this.fileMenu.add(this.newCategoryItem);

        this.fileMenu.add(this.printItem);

        this.fileMenu.add(this.recentFiles);

        this.fileMenu.addSeparator();

        this.fileMenu.add(this.exitItem);

        this.helpMenu.add(this.lizenz);

        this.helpMenu.addSeparator();

        this.helpMenu.add(this.aboutItem);

        // Menus der Bar hinzufugen

        this.mainMenu.add(this.fileMenu);

        this.mainMenu.add(this.trainMenu);

        this.mainMenu.add(this.helpMenu);

        this.buildFilesMenu(false);

        // Menubar dem Frame hinzufugen

        this.setJMenuBar(this.mainMenu);

    }

   

    private void initWindow(){

        // Ttiel setzen

        this.setTitle(this.title+" : "+this.ms.getDatabase());

        this.setSize(800,800);

        this.setMinimumSize(new Dimension(800, 300));

        register = new JTabbedPane();

            // Nimbus Design

            try{

                UIManager.setLookAndFeel("com.sun.java.swing.plaf.nimbus.NimbusLookAndFeel");

            }catch(Exception e){

                System.out.println("Nimbus ist nicht installiert!");

            }

            // Nimbus Design ENDE

        // Liste

        this.showVokabeln("Alle", false);

        // Register anzeigen:

        register1();

        register2();

        this.register.addTab("Vokabeln", this.tab1);

        this.register.addTab("Kategorien", this.tab2);

        this.register.setMnemonicAt(0, KeyEvent.VK_1);

        this.register.setMnemonicAt(1, KeyEvent.VK_2);

        // Adden

        this.con.add(register);

    }

   

    public void register1(){

        // Elemente

        Date dd = new Date(System.currentTimeMillis());

        this.kateg = new JComboBox(ba.getCategories());

        this.startDate = new JLabel("\tDatum ");

        this.startStamp = new JDateChooser(dd, "dd.MM.yyyy", new JSpinnerDateEditor());

        this.endDate = new JLabel(" und ");

        this.endStamp = new JDateChooser(dd, "dd.MM.yyyy", new JSpinnerDateEditor());

       

        // Panels

        JPanel underTab = new JPanel();

        underTab.setLayout(new BoxLayout(underTab, BoxLayout.X_AXIS));

        underTab.add(this.kateg);

        underTab.add(Box.createRigidArea(new Dimension(5,0)));

        underTab.add(this.startDate);

        underTab.add(this.startStamp);

        underTab.add(this.endDate);

        underTab.add(this.endStamp);

        underTab.add(Box.createRigidArea(new Dimension(5,0)));

        // Suchfeld

        this.searchField = new JTextField("Suche...");

        underTab.add(this.searchField);

        // Register 1

        this.tab1 = new JPanel();

        this.tab1.setLayout(new BorderLayout());

        this.tab1.add(underTab, BorderLayout.NORTH);

        this.tab1.add(this.tabelle, BorderLayout.CENTER);

    }

   

    public void register2(){

        // Tab 2:

        this.showCategories();

        tab2 = new JPanel();

        tab2.setLayout(new BoxLayout(tab2, BoxLayout.Y_AXIS));

        tab2.add(scrollKate);

    }

   

    public void showCategories(){

        this.showCategories(false);

    }

   

    public void showCategories(boolean reset){

        this.showCategories(reset, "");

    }

   

    public void showCategories(boolean reset, String toMark){

        if(reset){

            this.modelKate = null;

        }

        // Tabelle

        String[] columnNames = {

            "#", "Name"

        };

       

        try{

            ms.connect();

            ms.exec("SELECT * FROM franz_category");

            ms.closeConnection();

        }catch(Exception ex){}

       

        String[][] rowData = ms.getResult();

        if(rowData.length > 0){

        // zum Objekt umwandeln

        Object data[][] = new Object[rowData.length][rowData[0].length];

            for(int i = 0; i < rowData.length; i++){

                for(int j = 0; j < rowData[i].length; j++){

                    if(j == 4){

                        data[i][j] = new ImageIcon(rowData[i][j]);

                    }else{

                        data[i][j] = rowData[i][j];

                    }

                }

            }

        }

       

        this.modelKate = new DefaultTableModel(rowData, columnNames);

        if(!reset){

            this.tabKate = new JTable(this.modelKate) {

                @Override

                public boolean isCellEditable(int x, int y) {

                    return false;

                }

            };

           

            this.scrollKate = new JScrollPane(this.tabKate);

            this.tabKate.setSelectionMode( ListSelectionModel.SINGLE_INTERVAL_SELECTION );

            this.tabKate.setColumnSelectionAllowed( false );

            this.tabKate.setRowSelectionAllowed( true );

            this.tabKate.getTableHeader().setReorderingAllowed( false );

            this.tabKate.getTableHeader().setResizingAllowed( true );

        }else{

            this.tabKate.setModel(this.modelKate);

        }

       

        // Setze ID Feldlaenge fest auf 25.

        TableColumn col = this.tabKate.getColumnModel().getColumn( 0 );

        col.setMinWidth( 25 );

        col.setMaxWidth( 25 );

    }

    public void searchInTable(){

        this.searchInTable(this.searchField.getText(), -1);

    }

    public void searchInTable(String sword){

        this.searchInTable(sword, -1);

    }

    public void searchInTable(String sword, int st){

        this.tabvok.requestFocus();

        boolean notfound = true;

        int start = 0;

        if(st == -1){

            start = this.tabvok.getSelectedRow();

            if(start == -1){

                start = 0;

            }else{

                start++;

            }

        }else{

            start = st;

        }

        while(start < this.tabvok.getRowCount() && notfound){

            if(this.tabvok.getModel().getValueAt(start, 2).equals(sword) ||

                    this.tabvok.getModel().getValueAt(start, 3).equals(sword)){

                this.tabvok.getSelectionModel().setSelectionInterval(start, start);

                notfound = false;

            }

            start++;

        }

        if(notfound){

            int t = JOptionPane.showConfirmDialog(this, "Leider konnte \""+sword+"\" nicht gefunden werden.\n"

                    + "Soll die Suche von Vorne begonnen werden?", "Suche: nicht gefunden", JOptionPane.YES_NO_OPTION, JOptionPane.WARNING_MESSAGE);

            if(t == 0){

                this.searchInTable(sword, 0);

            }

        }

    }

    public void buildFilesMenu(){

        this.buildFilesMenu(true);

    }

    public void buildFilesMenu(boolean ws){

        if(ws){

            // Recent Files

            // Position?

            int i = 0;

            boolean run = true;

            while(run && i < this.fileMenu.getItemCount()){

                if(this.fileMenu.getItem(i) == this.recentFiles){

                    run = false;

                }else{

                    i++;

                }

            }

            this.fileMenu.remove(this.recentFiles);

            this.recentFiles.removeAll();

            this.recentFilesItems = new ArrayList<JMenuItem>();

            ArrayList<String> tmple = this.ba.getRecentDatabases();

            for(String item: tmple){

                JMenuItem tmp = new JMenuItem(item);

                this.recentFilesItems.add(tmp);

                this.recentFiles.add(tmp);

            }

            this.fileMenu.add(this.recentFiles, i);

        }

        // Recent Files

        for(int i = 0; i < this.recentFilesItems.size(); i++){

            this.recentFilesItems.get(i).addActionListener(new ActionListener(){

                @Override

                public void actionPerformed(ActionEvent evt){

                    changeDatabase(evt.getActionCommand());

                }

            });

        }

        this.validate();

        this.repaint();

    }

    private void addActions(){

        final VokabelnBackend b = this.ba;

        // Weitersuchen

        this.tabvok.addKeyListener(new KeyListener() {

            @Override

            public void keyTyped(KeyEvent e) {

                //throw new UnsupportedOperationException("Not supported yet.");

            }

            @Override

            public void keyPressed(KeyEvent e) {

                //throw new UnsupportedOperationException("Not supported yet.");

            }

            @Override

            public void keyReleased(KeyEvent e) {

                if(e.getKeyCode() == KeyEvent.VK_F3){

                    searchInTable();

                }

                //throw new UnsupportedOperationException("Not supported yet.");

            }

        });

        // Datumauswahl

        startStamp.getDateEditor().addPropertyChangeListener(new PropertyChangeListener(){

            @Override

            public void propertyChange(PropertyChangeEvent evt){

                if(evt.getPropertyName().equals("date")){

                    SimpleDateFormat sdf = new SimpleDateFormat("dd.MM.yyyy");

                    Date da;

                    try{

                        da = sdf.parse(sdf.format(evt.getNewValue()));

                        System.out.println(""+(da.getTime()/1000));

                        showVokabeln((da.getTime()/1000), (endStamp.getDate().getTime()/1000));

                    }catch(ParseException npe){

                        System.out.println("DEBUG :: Unknown Error in Line 337 in Vokabeln.java :: "+npe);

                    }

                   

                    startStamp.setMaxSelectableDate(endStamp.getDate());

                    startStamp.updateUI();

                    endStamp.setMinSelectableDate(startStamp.getDate());

                    endStamp.updateUI();

                    category = false;

                }

            }

        });

 

        endStamp.getDateEditor().addPropertyChangeListener(new PropertyChangeListener(){

            @Override

            public void propertyChange(PropertyChangeEvent evt){

                if(evt.getPropertyName().equals("date")){

                    SimpleDateFormat sdf = new SimpleDateFormat("dd.MM.yyyy");

                    Date da;

                   

                    try{

                        da = sdf.parse(sdf.format(evt.getNewValue()));

                        System.out.println(""+(da.getTime()/1000));

                        showVokabeln((startStamp.getDate().getTime()/1000), (da.getTime()/1000));

                    }catch(ParseException npe){

                        System.out.println("DEBUG :: Unknown Error in Line 360 in Vokabeln.java :: "+npe);

                    }

                   

                    startStamp.setMaxSelectableDate(endStamp.getDate());

                    startStamp.updateUI();

                    endStamp.setMinSelectableDate(startStamp.getDate());

                    endStamp.updateUI();

                    category = false;

                }

            }

        });

        // Suchfeld

        this.searchField.addFocusListener(new FocusListener() {

            @Override

            public void focusGained(FocusEvent e) {

                searchField.setSelectionStart(0);

                searchField.setSelectionEnd(searchField.toString().length());

            }

            @Override

            public void focusLost(FocusEvent e) {

                //throw new UnsupportedOperationException("Not supported yet.");

            }

        });

        this.searchField.addKeyListener(new KeyListener() {

            @Override

            public void keyTyped(KeyEvent e) {

                //throw new UnsupportedOperationException("Not supported yet.");

            }

            @Override

            public void keyPressed(KeyEvent e) {

                //throw new UnsupportedOperationException("Not supported yet.");

            }

            @Override

            public void keyReleased(KeyEvent e) {

                //throw new UnsupportedOperationException("Not supported yet.");

                // On Enter => Search

                if(e.getKeyCode() == KeyEvent.VK_ENTER){

                    searchInTable();

                }

            }

        });

        // Datumauswahl Ende

        // Drucken

        printItem.addActionListener(new ActionListener(){

            @Override

            public void actionPerformed(ActionEvent evt){

                try{

                    TableColumn col = tabvok.getColumnModel().getColumn( 0 );

                    col.setMinWidth( 0 );

                    col.setMaxWidth( 0 );

                    col = null;

                    col = tabvok.getColumnModel().getColumn( 1 );

                    col.setMinWidth( 0 );

                    col.setMaxWidth( 0 );

                    col = null;

                    col = tabvok.getColumnModel().getColumn( 4 );

                    col.setMinWidth(0);

                    col.setMaxWidth(0);

                    String title = "";

                    if(category){

                        title += getSelectedKategorie();

                    }else{

                        Calendar ca1 = Calendar.getInstance();

                        ca1.setTime(startStamp.getDate());

                        Calendar ca2 = Calendar.getInstance();

                        ca2.setTime(endStamp.getDate());

                        title += "Vokabeln von "+ca1.get(Calendar.DATE)+"."+(ca1.get(Calendar.MONTH)+1)+"."+ca1.get(Calendar.YEAR)+" bis "+ca2.get(Calendar.DATE)+"."+(ca2.get(Calendar.MONTH)+1)+"."+ca2.get(Calendar.YEAR);

                    }

                    tabvok.print(JTable.PrintMode.FIT_WIDTH, new MessageFormat(title), new MessageFormat(""));

                }catch(java.awt.print.PrinterException pe){

                    System.out.println("Fehler beim Drucken");

                }

            }

        });

        // Vokabeln anhand Kategorien

        kateg.addActionListener(new ActionListener(){

            @Override

            public void actionPerformed(ActionEvent evt){

                System.out.println(kateg.getSelectedItem());

                showVokabeln(""+kateg.getSelectedItem(), true);

            }

        });

        // Neue Vokabel

        newVokabelItem.addActionListener(new ActionListener(){

            @Override

            public void actionPerformed(ActionEvent evt){

                newVokForm();

            }

        });

        // Neue Kategorie

        newCategoryItem.addActionListener(new ActionListener(){

            @Override

            public void actionPerformed(ActionEvent evt){

                newCategorie();

                showCategories(true);

            }

        });

       

        // ANFANG Trainer MENU

        for(int i = 0; i < this.traineer.length; i++){

            final int tmp = i;

            this.traineer[i].addActionListener(new ActionListener(){

           

                @Override

                public void actionPerformed(ActionEvent evt){

                    // Hole erstmal alle

                    ArrayList<Integer> blub = new ArrayList<Integer>();

                    for(int j = 0; j < tabvok.getRowCount(); j++){

                        blub.add(Integer.parseInt(""+tabvok.getValueAt(j,0)));

                    }

                    showTrainer(b.getRandomVocabulary(blub, tabvok.getRowCount(), tmp));

                }

            });

        }

       

        // ENDE Trainer MENU

        tabvok.addMouseListener( new MouseAdapter(){

            @Override

            public void mouseReleased( MouseEvent me ) {

                if ( me.getButton() == 3 ) {

                    JPopupMenu popmen = new JPopupMenu();

                    JMenuItem menu1 = new JMenuItem("Löschen");

                    JMenuItem menu2 = new JMenuItem("Bearbeiten");

                    popmen.add( menu1 );

                    popmen.add( menu2 );

                    tabvok.changeSelection(tabvok.rowAtPoint(me.getPoint()), tabvok.columnAtPoint(me.getPoint()),false,false);

                    popmen.show( me.getComponent(), me.getX(), me.getY() );

                   

                    menu1.addActionListener(new ActionListener(){

                        @Override

                        public void actionPerformed(ActionEvent evt){

                            ba.removeItem(""+tabvok.getValueAt(tabvok.getSelectedRow(),0));

                            showVokabeln(""+kateg.getSelectedItem(), true);

                        }

                    });

                   

                    menu2.addActionListener(new ActionListener(){

                        @Override

                        public void actionPerformed(ActionEvent evt){

                            newVokForm(true, ""+tabvok.getValueAt(tabvok.getSelectedRow(),0));

                            showVokabeln(""+kateg.getSelectedItem(), true);

                        }

                    });

                }

            }

        } );

       

        tabKate.addMouseListener( new MouseAdapter(){

            @Override

            public void mouseReleased( MouseEvent me ) {

                if ( me.getButton() == 3 ) {

                    JPopupMenu popmen = new JPopupMenu();

                    JMenuItem menu1 = new JMenuItem("Löschen");

                    JMenuItem menu2 = new JMenuItem("Bearbeiten");

                    popmen.add( menu1 );

                    popmen.add( menu2 );

                    tabKate.changeSelection(tabKate.rowAtPoint(me.getPoint()), tabKate.columnAtPoint(me.getPoint()),false,false);

                    popmen.show( me.getComponent(), me.getX(), me.getY() );

                   

                    menu1.addActionListener(new ActionListener(){

                        @Override

                        public void actionPerformed(ActionEvent evt){

                            ba.removeCategory(""+tabKate.getValueAt(tabKate.getSelectedRow(),0));

                            showCategories(true);

                        }

                    });

       

                    menu2.addActionListener(new ActionListener(){

                        @Override

                        public void actionPerformed(ActionEvent evt){

                            String categ = "";

                            do{

                                categ = JOptionPane.showInputDialog(con, "Bitte geben Sie unten einen neuen Kategorie Name ein!", "Kategorie bearbeiten", JOptionPane.QUESTION_MESSAGE);

                            }while(categ != null && !ba.getCategoryID(categ,Integer.parseInt(""+tabKate.getValueAt(tabKate.getSelectedRow(),0))).equals("FALSE"));

                           

                            categ = (categ == null)?"":categ;

         

                            if(!categ.equals("")){

                                ba.saveNewCategory(categ,Integer.parseInt(""+tabKate.getValueAt(tabKate.getSelectedRow(),0)),true);

                            }

         

                            showCategories(true);

                        }

                    });

                }

            }

        } );

       

        exitItem.addActionListener(new ActionListener(){

            @Override

            public void actionPerformed(ActionEvent evt){

                dispose();

                System.exit(0);

            }

        });

       

        aboutItem.addActionListener(new ActionListener(){

            @Override

            public void actionPerformed(ActionEvent evt){

                credits();

            }

        });

        this.lizenz.addActionListener(new ActionListener() {

            @Override

            public void actionPerformed(ActionEvent e) {

                lizenz();

            }

        });

        this.newDBItem.addActionListener(new ActionListener() {

            @Override

            public void actionPerformed(ActionEvent e) {

                createNewDatabase();

            }

        });

        loadDBItem.addActionListener(new ActionListener(){

            @Override

            public void actionPerformed(ActionEvent evt){

                changeDatabase();

                buildFilesMenu();

            }

        });

       

        resetVokabeln.addActionListener(new ActionListener(){

            @Override

            public void actionPerformed(ActionEvent evt){

                try{

                    ms.connect();

                    ms.exec("UPDATE franz_vok SET vok_level = -1 WHERE vok_ID > 0");

                    ms.closeConnection();

                    // Ansicht aktualisieren

                    showVokabeln("Alle",true);

                }catch(Exception ex){}

            }

        });

    }

   

    public boolean exist(int items[], int id){

        boolean exist = false;

        int i = 0;

        while(i < items.length && !exist){

            if(items[i] == id){

                exist = true;

            }

        }

   

        return (id == -1)?true:exist;

    }

   

    public void newCategorie(){

        String categ = "";

        do{

            categ = JOptionPane.showInputDialog(con, "Bitte geben Sie unten den Kategorie Name ein!", "Neue Kategorie", JOptionPane.QUESTION_MESSAGE);

        }while(categ != null && !ba.getCategoryID(categ).equals("FALSE"));

        categ = (categ == null)?"":categ;

       

        if(!categ.equals("")){

            this.ba.saveNewCategory(categ);

            this.showCategories(true);

        }

    }

   

    public void credits(){

        JOptionPane.showMessageDialog(con, "Autor: Lukas Schreiner (Mono, LukSch)\n" +

                "Some rights reserved.\n" +

                "Copyright 2010 by Lukas Schreiner\n" +

                "http://lschreiner.de\n\n" +

                "Danke geht an:\n" +

                "Kai Toedter (Kalenderfunktion)\n" +

                "Sebastian Riedel [DaBASCHT] (INI Datei Manager)\n" +

                "David Crawshaw (SQLite JDBC)\n" +

                "Rich Midwinter (Google Übersetzungsanbindung)", "Credits...", JOptionPane.INFORMATION_MESSAGE);

    }

    public void lizenz(){

        final JDialog lz = new JDialog(this, "Lizenz", true);

        lz.setLayout(new BoxLayout(lz.getContentPane(), BoxLayout.Y_AXIS));

        lz.setPreferredSize(new Dimension(550,500));

        lz.setSize(550,500);

        lz.add(new JLabel("Lizenzbestimmungen für "+this.title));

        // Lizenz

        JTextPane jtp = new JTextPane();

        jtp.setAutoscrolls(true);

        jtp.setEditable(false);

        try{

            jtp.setPage("file://"+System.getProperty("user.dir")+File.separator+"lizenz.html");

        }catch(Exception ex){ System.err.println(ex.getMessage()); }

       

        JScrollPane jsp = new JScrollPane(jtp);

        jsp.setVerticalScrollBarPolicy(JScrollPane.VERTICAL_SCROLLBAR_ALWAYS);

        jsp.setPreferredSize(new Dimension(540, 450));

        jsp.setMinimumSize(new Dimension(300,300));

        lz.add(jsp);

        JButton jb = new JButton("OK");

        jb.setSize(80, 20);

        jb.addActionListener(new ActionListener() {

            @Override

            public void actionPerformed(ActionEvent e) {

                lz.setVisible(false);

                lz.dispose();

            }

        });

        lz.add(jb);

        lz.setVisible(true);

    }

   

    public void newVokForm(){

        this.newVokForm(false, "");

    }

   

    public String getSelectedKategorie(){

        return ""+kateg.getSelectedItem();

    }

   

    public void newVokForm(final boolean edit, String id){

        // here are declarations for the controls you created

        JButton save = new JButton("Speichern");

        JLabel labCate = new JLabel("Kategorie");

        final JComboBox cate = new JComboBox(ba.getCategories(true));

        JLabel word = new JLabel("Wort/Satz");

        JButton cancel = new JButton("Abbrechen");

        final JTextField fieldWord = new JTextField();

        final JTextField fieldTransWord = new JTextField();

        JButton transWord = new JButton("Übersetzung",new ImageIcon("icons/asterisk_orange.png"));

        JLabel timeLab = new JLabel("Datum");

        final JDateChooser timestamp = new JDateChooser();

        transWord.addActionListener(new ActionListener() {

            @Override

            public void actionPerformed(ActionEvent ae) {

                String translation = (String)JOptionPane.showInputDialog(null, "Bitte wählen Sie die Zielsprache aus:", "Zielsprache",

                    JOptionPane.QUESTION_MESSAGE, null, new Object[] { "de",

                        "en", "fr", "es", "it" }, "fr");

                if(translation != null){

                    fieldTransWord.setText(ba.getTranslation(fieldWord.getText(), "", translation));

                }

            }

        });

        // Daten fuellen

        final String[] data = (!edit?new String[0]:ba.getVokabel(id));

        if(edit){

            // Daten holen

            fieldWord.setText(data[2]);

            fieldTransWord.setText(data[3]);

            timestamp.setDate(new Date(Long.parseLong(data[1])*1000));

            cate.setSelectedItem(data[5]);

        }

        final JDialog newVokWin;

        Container vokCon;

 

        newVokWin = new JDialog();

        newVokWin.setModalityType(JDialog.ModalityType.APPLICATION_MODAL);

        vokCon = newVokWin.getContentPane();

        vokCon.setLayout(new GridLayout(/*3*/ 0, 2, 6, 3));

        newVokWin.setTitle("Neue Vokabel eintragen");

        newVokWin.setSize(600,300);

        newVokWin.setLocation(300,300);

        // Tasten

        cancel.setMnemonic('A');

        save.setMnemonic('S');

        // here we add the controls to the container.

        vokCon.add(labCate, "labCate");

        vokCon.add(cate, "cate");

        vokCon.add(word, "word");

        vokCon.add(fieldWord, "fieldWord");

        vokCon.add(transWord, "transWord");

        vokCon.add(fieldTransWord, "fieldTransWord");

        vokCon.add(timeLab, "timeLab");

        vokCon.add(timestamp, "timestamp");

        vokCon.add(save, "save");

        vokCon.add(cancel, "cancel");

 

        // Aktionen

        cancel.addActionListener(new ActionListener(){

            @Override

            public void actionPerformed(ActionEvent evt){

                newVokWin.dispose();

            }

        });

       

        save.addActionListener(new ActionListener(){

            @Override

            public void actionPerformed(ActionEvent evt){

                if(ba.checkInput(fieldWord.getText(),fieldTransWord.getText())){

                    if(!edit){

                        ba.saveInput(""+cate.getSelectedItem(),fieldWord.getText(),fieldTransWord.getText(),timestamp.getDate());

                    }else{

                        ba.saveInput(""+cate.getSelectedItem(),fieldWord.getText(),fieldTransWord.getText(),timestamp.getDate(), data[0], true);

                    }

                    newVokWin.dispose();

                    if(category){

                        showVokabeln(categoryName, true);

                    }else{

                        showVokabeln((startStamp.getDate().getTime()/1000),(endStamp.getDate().getTime()/1000));

                    }

                    //showVokabeln(""+cate.getSelectedItem(), true);

                }else{

                    JOptionPane.showConfirmDialog( con, "Sie müssen alle Eingabefelder ausfüllen!", "Fehler", JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE );

                }

            }

        });

        // Make it later....

        newVokWin.pack();

        newVokWin.setVisible(true);

    }

   

    public void showVokabeln(long timeStart, long timeEnd){

        showVokabeln("Alle", timeStart, timeEnd, true);

    }

   

    public void showVokabeln(String what, boolean reset){

        showVokabeln(what, 0, 0, reset);

        category = true;

    }

   

    public void showVokabeln(String what, long timeStart, long timeEnd, boolean reset){

        model = null;

        if(timeStart > 0){

            category = false;

        }else{

            category = true;

            categoryName = what;

        }

       

        String[] columnNames = {

            "#", "Datum", "Wort/Satz", "Übersetzung","Status"

        };

       

        String[][] rowData;

        if(timeStart == 0){

            rowData = ba.getVokabeln(what);

        }else{

            rowData = ba.getVokabeln(what, timeStart, timeEnd+138000);

        }

       

        // zum Objekt umwandeln

        Object data[][] = new Object[rowData.length][(rowData.length > 0?rowData[0].length:0)];

        for(int i = 0; i < rowData.length; i++){

            for(int j = 0; j < rowData[i].length; j++){

                if(j == 4){

                    data[i][j] = new ImageIcon(rowData[i][j]);

                }else{

                    data[i][j] = rowData[i][j];

                }

            }

        }

           

        this.model = new DefaultTableModel(data, columnNames);

        if(!reset){

            tabvok = new JTable(model) {

                @Override

                public boolean isCellEditable(int x, int y) {

                    return false;

                }

            };

            tabvok.getColumn("Status").setCellRenderer(

                // Standard-Renderer erweitern

                new DefaultTableCellRenderer() {

                    @Override

                    public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected,boolean hasFocus, int row, int column) {

                        // Label der Oberklasse erweitern

                        JLabel label = (JLabel) super.getTableCellRendererComponent(table, value, isSelected, hasFocus, row, column);

                       

                        // Lediglich Text und Grafik anpassen

                        if (value != null) {

                            label.setText("");

                            label.setIcon((ImageIcon) value);

                        }

                   

                        return label;

                    }

                }

            );

               

            tabelle = new JScrollPane(tabvok);

            tabvok.setSelectionMode( ListSelectionModel.SINGLE_INTERVAL_SELECTION );

            tabvok.setColumnSelectionAllowed( false );

            tabvok.setRowSelectionAllowed( true );

            tabvok.getTableHeader().setReorderingAllowed( false );

            tabvok.getTableHeader().setResizingAllowed( true );

        }else{

            tabvok.setModel(model);

      tabvok.getColumn("Status").setCellRenderer(

                // Standard-Renderer erweitern

                new DefaultTableCellRenderer() {

                    @Override

                    public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected,boolean hasFocus, int row, int column) {

                        // Label der Oberklasse erweitern

                        JLabel label = (JLabel) super.getTableCellRendererComponent(table, value, isSelected, hasFocus, row, column);

                       

                        // Lediglich Text und Grafik anpassen

                        if (value != null) {

                            label.setText("");

                            label.setIcon((ImageIcon) value);

                        }

                   

                        return label;

                    }

                }

            );

        }

        tabvok.setAutoCreateRowSorter(true);

       

        TableColumn col = tabvok.getColumnModel().getColumn( 0 );

        col.setMinWidth( 0 );

        col.setMaxWidth( 0 );

        col = null;

        col = tabvok.getColumnModel().getColumn( 1 );

        col.setMinWidth(75);

        col.setMaxWidth(75);

  col = null;

        col = tabvok.getColumnModel().getColumn( 4 );

        col.setMinWidth(50);

        col.setMaxWidth(50);

    }

    public void createNewDatabase(){

        JFileChooser db = null; // FileChooser

        FileNameExtensionFilter filter = new FileNameExtensionFilter(

        "SQLite Database (db, sqlite, sqlite3)", "db", "sqlite", "sqlite3"); // Filter

        File def = null; // Default

        File file = null; // Later

        def = new File(System.getProperty("user.home")+File.separator+".vokabeln"+File.separator);

        if(def.exists()){

            db = new JFileChooser(def); // Standard Pfad?

        }else{

            db = new JFileChooser();

        }

        db.setFileFilter(filter);

        int state = db.showSaveDialog(this);

        if (state == JFileChooser.APPROVE_OPTION){

            file = db.getSelectedFile();