String ifComplete;
String ifCollected;
public ArrayList<Workorder> workorderList(){
        ArrayList<Workorder> workordersList = new ArrayList();
        try{
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost/grdatabase?verifyServerCertificate=false&useSSL=true";
            Connection con = DriverManager.getConnection(url, "tester", "tester");
            String query = String.format("SELECT * FROM workorders WHERE customerid LIKE %s", sqlCustomerID);
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery(query);
            Workorder workorder;
            while(rs.next()){
                workorder = new Workorder(rs.getString("customerid"), rs.getString("ticketnumber"), rs.getString("description"),                rs.getString("jobtype"), rs.getString("service"), rs.getString("ticketby"), rs.getString("datereceived"), rs.getString("daterequired"), rs.getString("jobby"), rs.getString("datefinished"), rs.getString("datecollected"), rs.getString("subtotal"), rs.getString("servicechargepercent"), rs.getString("servicechargetotal"), rs.getString("totalprice"), rs.getString("totalpaid"));
                workordersList.add(workorder);
                ifComplete = rs.getString("datefinished");
                ifCollected = rs.getString("datecollected");
            }
            con.close();
        }catch(Exception e){
            JOptionPane.showMessageDialog(null, e);
        }
        return workordersList;
    }

    public DefaultTableModel model;

    public void showWorkorderCurrent(DefaultTableModel model){
        ArrayList<Workorder> list = workorderList();

        model = (DefaultTableModel)tblCurrentWorkorders.getModel();
        if(ifComplete == null){
        Object[] row = new Object[6];
        for(int i=0; i<list.size();i++){
            row[0]=list.get(i).getTicketNumber();
            row[1]=list.get(i).getDescription();
            row[2]=list.get(i).getDateReceived();
            row[3]=list.get(i).getDateRequired();
            row[4]=list.get(i).getTotalPrice();
            row[5]=list.get(i).getTotalPaid();
            model.addRow(row);
        }
        }else{
                DefaultTableModel modelCollected = (DefaultTableModel)tblPastWorkorders.getModel();
                Object[] row = new Object[6];
                for(int i=0; i<list.size();i++){
                    row[0]=list.get(i).getTicketNumber();
                    row[1]=list.get(i).getDescription();
                    row[2]=list.get(i).getDateReceived();
                    row[3]=list.get(i).getDateRequired();
                    row[4]=list.get(i).getTotalPrice();
                    row[5]=list.get(i).getTotalPaid();
                    model.addRow(row);
                }
            }
        }