package restaurant;

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

public class RestaurantMenu32{
    
    private DBCon con;
	private Read read;
	private Write write;
	private Exit exit;
	private Common common;
	ResultSet rs=null;


    public Vector getRoomID(){
         Vector vec = new Vector();
  
         String sql="select * from room where flag='full'";
            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 Vector getFood(){
         Vector vec = new Vector();
  
         String sql="select name from food";
            con = new DBCon();
	        read = new Read(con.getConnection());    
            rs=read.executeQuery(sql); 
            
         try{
            while(rs.next()){
    			vec.addElement(rs.getString("name"));
            }
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }   
          exit = new Exit(con.getConnection());
          exit.Close();
          
          return vec;
    }

    public int lookTotal(String name,String discount,String amount)
    {
    	int total=0;
    	common = new Common();
		name=common.toChinese(name);
		
    	String sql="select * from food where name='"+name+"'";
    	       con = new DBCon();
	           read = new Read(con.getConnection());    
               rs=read.executeQuery(sql); 
               
          try{
               rs.next();
               total=rs.getInt("price")*Integer.parseInt(discount)*Integer.parseInt(amount)/10;
               
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }   
          exit = new Exit(con.getConnection());
          exit.Close();
          
        return total;
    	
    }
    
    
    public boolean order(Vector vecOrder){
    	//寫入sales表  
    	Vector vec=new Vector();
    	int pay=0;
		common = new Common();
	
    	String sql="select * from roomBook where roomNo='"+common.toChinese((String)vecOrder.get(1))+"'";
    	       con = new DBCon();
	           read = new Read(con.getConnection());    
               rs=read.executeQuery(sql); 
               
          try{
               rs.next();
            	vec.addElement(rs.getString("customer"));
            	vec.addElement(rs.getString("type"));
            	vec.addElement(rs.getString("tel"));
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }   
          exit = new Exit(con.getConnection());
          exit.Close();
               
               
            sql="select * from food where name='"+common.toChinese((String)vecOrder.get(2))+"'";
    	       con = new DBCon();
	           read = new Read(con.getConnection());    
               rs=read.executeQuery(sql); 
               
          try{
               rs.next();
               vec.addElement(rs.getString("foodType"));
               pay=rs.getInt("price")*rs.getInt("discount");
                
          }catch(SQLException e){
		   System.err.println(e.getMessage());
		  }   
          exit = new Exit(con.getConnection());
          exit.Close();
    	
    	
                sql="insert into sales values(";
		        sql+="'"+common.toChinese((String)vecOrder.get(0))+"',"; //業務員
		        sql+="'"+common.toChinese((String)vecOrder.get(1))+"',";//房號
		        sql+="'"+common.toChinese((String)vec.get(0))+"',";     //顧客
		        sql+="'"+common.toChinese((String)vec.get(1))+"',";     //顧客類型
		        sql+="'"+common.toChinese((String)vec.get(2))+"',";     //顧客電話
    	        sql+="'"+common.toChinese((String)vecOrder.get(2))+"',";//食品名字
                sql+="'"+common.toChinese((String)vec.get(3))+"',";     //食品類型
    	        sql+=Integer.parseInt(common.toChinese((String)vecOrder.get(3)))+",";//數量
    	        sql+=Integer.parseInt(common.toChinese((String)vecOrder.get(4)))+",";//折扣
    	        sql+=Integer.parseInt(common.toChinese((String)vecOrder.get(3)))*pay/10+",";
    	        sql+="now(),";
    	        sql+="'"+common.toChinese((String)vecOrder.get(5))+"')";
    	        
    	     
    	    con = new DBCon();
	        write = new Write(con.getConnection());    
            write.executeUpdate(sql); 
            
            common=new Common();
            common.WriteSystemLog("顧客"+common.toChinese((String)vec.get(0))+"結帳. 操作員:"+common.toChinese((String)vecOrder.get(0))+"."+common.getNowTime());
             
            exit = new Exit(con.getConnection());
            exit.Close();
            return true;
    }
    
    
    public void pay(String roomID){
    	//寫入sales表  
    	Vector vec=new Vector();
    	int pay=0;
    	
    	String sql="update room set flag='empty' where id='"+roomID+"'";
    	       con = new DBCon();
	           read = new Read(con.getConnection());    
               rs=read.executeQuery(sql); 
               
    	  con = new DBCon();
	      write = new Write(con.getConnection());    
          write.executeUpdate(sql); 
          exit = new Exit(con.getConnection());
          exit.Close();
    }
    
}