package restaurant;
import java.io.*;
import java.sql.*;
import java.awt.*;
import javax.swing.*;

public class RestaurantMenu5 extends JFrame{
	Connection con = null;
	Statement stmt = null;
	
	ResultSet preRoomRs = null;
	ResultSet absentRoomRs = null;
	ResultSet fullRoomRs = null;
	ResultSet preOvertimeRs = null;
	
	ResultSet foodRs = null;
	ResultSet client = null;
	
	ResultSet operaterSaleRs = null;
	ResultSet hotFoodRs = null;
	
	public void InitCheck( Connection con )
	{
		if ( this.con != con )
		{
			this.con = con;
		}
		
		try
		{
			stmt = con.createStatement();
			
			String strSQL1 = "select * from room where 被預(yù)定了的房間";
			String strSQL2 = "select * from room where 空閑的房間";
			String strSQL3 = "select * from room where 已經(jīng)入住的房間";
			String strSQL4 = "select * from room where 當(dāng)前時間-預(yù)定時間>15天";
			String strSQL5 = "select * from food";
			String strSQL6 = "select * from client";
			
			String strSQL3 = "select * from food where amount<100";
			
			preRoomRs = stmt.executeQuery( strSQL1 );
			absentRoomRs = stmt.executeQuery( strSQL2 );
			fullRoomRs = stmt.executeQuery( strSQL3 );
			preOvertimeRs = stmt.executeQuery( strSQL4 );
			foodRs = stmt.executeQuery( strSQL5 );
			clientRs = stmt.executeQuery( strSQL6 );
		}
		
		catch ( SQLException sex )
		{
			System.out.println( sex.toString() );
		}
		
	}
	
	public boolean preRoomNext()
	{
		boolean result = false;
		
		try
		{
			result = preRoom.next();
		}
		
		catch ( SQLException sex )
		{
			System.out.println( sex.toString() );
		}
		
		return result;
		
	} 
	
	public boolean absentNext()
	{
		boolean result = false;
		
		try
		{
			result = absentRs.next();
		}
		
		catch ( SQLException sex )
		{
			System.out.println( sex.toString() );
		}
		
		return result;		
	} 
	
	public boolean fullNext()
	{
		boolean result = false;
		
		try
		{
			result = fullRs.next();
		}
		
		catch ( SQLException sex )
		{
			System.out.println( sex.toString() );
		}
		
		return result;		
	} 
	
	public boolean preOvertimeNext()
	{
		boolean result = false;
		
		try
		{
			result = preOvertimeRs.next();
		}
		
		catch ( SQLException sex )
		{
			System.out.println( sex.toString() );
		}
		
		return result;		
	} 

	public boolean foodNext()
	{
		boolean result = false;
		
		try
		{
			result = foodRs.next();
		}
		
		catch ( SQLException sex )
		{
			System.out.println( sex.toString() );
		}
		
		return result;		
	}	
	
	public boolean clientNext()
	{
		boolean result = false;
		
		try
		{
			result = clientRs.next();
		}
		
		catch ( SQLException sex )
		{
			System.out.println( sex.toString() );
		}
		
		return result;		
	}
	
//////////////////////////////////////////////////////	
    public String getFoodName(){
		String result = null;
		try{
			result = foodRs.getString("name");
		}catch(SQLException id){
			System.out.println( id.toString() );
		}
		
		return result;
	}
	
	public String getFoodAmount(){
		String result = null;
		try{
			result = foodRs.getString("amount");
		}catch(SQLException id){
			System.out.println( id.toString() );
		}
		
		return result;
	}

    public void prearrange(String roomName){//預(yù)定
    	 String sql="update room set flag='1', pre='1',full='1' where name='"+roomName+"'";
    	 stmt.executeUpdate(sql);
    }
    
    public void disPrearrange(String roomName){
    	 String sql="update room set flag='0', pre='0',full='0' where name='"+roomName+"'";
    	 stmt.executeUpdate(sql);
    }
    
    public void changeRoom(String oldRoom,String newRoom){//換房
    	
    	 String sql1,sql2;
    	 sql1="update room set flag='0', full='0' where name='"+oldRoom+"'";
    	 stmt.executeUpdate(sql);
    	 sql2="update room set flag='1', full='1' where name='"+newRoom+"'";
    	 stmt.executeUpdate(sql);
    }
    
    public String getPreRoomName(){
    	String result = null;
		try{
			result = preRoomRs.getString("name");
		}catch(SQLException id){
			System.out.println( id.toString() );
		}
		
		return result;
    }

    
    public String getAbsentRoomName(){
		String result = null;
		try{
			result = absentRs.getString("name");
		}catch(SQLException id){
			System.out.println( id.toString() );
		}
		
		return result;   	
    }
    
    public String getPreOvertime(){
		String result = null;
		try{
			result = absentRs.getString("name");
		}catch(SQLException id){
			System.out.println( id.toString() );
		}
		
		return result;      	
    }

    public String getFullRoomName(){
		String result = null;
		try{
			result = fullRoomRs.getString("name");
		}catch(SQLException id){
			System.out.println( id.toString() );
		}
		
		return result;    	
    }
    
    public void orderDishes(Vector food){
    	String sql1;  //被點的菜表庫存-,已銷售字段+
    	String sql2;  //營業(yè)員表的業(yè)績+
    	stmt.executeUpdate(sql1);
    	stmt.executeUpdate(sql2);
    }
    
    public String getClientName(){
		String result = null;
		try{
			result = clientRoomRs.getString("name");
		}catch(SQLException id){
			System.out.println( id.toString() );
		}
		
		return result;    	
    }    	
    
    public String getClientAccount(){
		String result = null;
		try{
			result = clientRs.getString("account");
		}catch(SQLException id){
			System.out.println( id.toString() );
		}
		
		return result;    	
    }    	
    
    public void pay(){
    	String sql; //顧客表 pag指定為1(已付款)
    	stmt.executeUpdate(sql); 
    }
    
}