package restaurant;
import java.io.*;
import java.sql.*;
import javax.swing.JOptionPane;
import java.util.Vector;

public class RestaurantMenu42{

	private DBCon con;
	private Read read;
	private Exit exit;
	private Common common;
    ResultSet rs=null;

    public Vector getOperator(){
    	  Vector vec = new Vector();
    	  String sql="select id from operator";
          ResultSet rs=null;
  
          con = new DBCon();
	      read = new Read(con.getConnection());    
          rs=read.executeQuery(sql); 
          
          try{
            while(rs.next()){
              vec.addElement(rs.getString("id"));
            }
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }
          exit = new Exit(con.getConnection());
          exit.Close();
          return vec;
    }	
	
	public void selectSalesInfo(String startTime,String endTime,String worker){
		
	     String sql="select * from sales where operator='"+worker+"' ";
	            sql+=" AND DATEDIFF('d',consumeDate,'"+startTime+"') <=0 AND DATEDIFF('d',consumeDate,'"+endTime+"') >=0";
  
         con = new DBCon();
	     read = new Read(con.getConnection());    
         rs=read.executeQuery(sql);      
    }
      
    public int getSalesInfo(){
    	int total=0,i=0;
    	try{
    		while(rs.next()){
    			total+=rs.getInt("pay");
    			i++;
    		}
        }catch(SQLException e){
		   System.err.println(e.getMessage());
		}
		exit = new Exit(con.getConnection());
        exit.Close();
		
		return total;
    }
}