package gui;

import businessLogic.HouseManager;

import com.toedter.calendar.JCalendar;

import domain.Offer;
import domain.RuralHouse;

import javax.swing.*;

import java.awt.*;
import java.awt.event.*;
import java.beans.*;
import java.sql.Date;
import java.text.DateFormat;
import java.util.*;

import javax.swing.table.DefaultTableModel;





public class QueryAvailabilityGUI extends JFrame {
private static final long serialVersionUID = 1L;

  private JLabel jLabel1 = new JLabel();
  private JLabel jLabel2 = new JLabel();
  private JTextField jTextField2 = new JTextField();
  private JLabel jLabel3 = new JLabel();
  private JTextField jTextField3 = new JTextField();
  private JButton jButton1 = new JButton();
  private JButton jButton2 = new JButton();
  
  // Code for JCalendar
  private JCalendar jCalendar1 = new JCalendar();
  private Calendar calendarMio = null;
  private JLabel jLabel4 = new JLabel();
  private JScrollPane scrollPane = new JScrollPane();
  private JComboBox comboBox ;
  private JTable table;
  private DefaultTableModel tableModel;
  private final JLabel labelNoOffers = new JLabel("");
  private String[] columnNames = new String[] {
  		"Offer#", "Rural House", "First Day", "Last Day", "Price"
  	};


  																					
  public QueryAvailabilityGUI()
  {
  	
    try
    {
      jbInit();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }

  }

  private void jbInit() throws Exception
  {
	HouseManager houseM = new HouseManager();
		
	Vector<RuralHouse> rhs=houseM.getAllRuralHouses();
	
	comboBox = new JComboBox(rhs);
	//comboBox.setModel(new DefaultComboBoxModel(rhs));

	
    this.getContentPane().setLayout(null);
    this.setSize(new Dimension(433, 548));
    this.setTitle("Query availability");
    jLabel1.setText("Rural house code:");
    jLabel1.setBounds(new Rectangle(27, 20, 128, 25));
    jLabel2.setText("First day:");
    jLabel2.setBounds(new Rectangle(40, 55, 75, 25));
    jTextField2.setBounds(new Rectangle(190, 210, 155, 25));
    jTextField2.setEditable(false);
    jLabel3.setText("Number of nights:");
    jLabel3.setBounds(new Rectangle(40, 250, 115, 25));
    jTextField3.setBounds(new Rectangle(190, 250, 155, 25));
    jTextField3.setText("0");
    jButton1.setText("Accept");
    jButton1.setBounds(new Rectangle(55, 455, 130, 30));
    jButton1.addActionListener(new ActionListener()
    	      {
    	        public void actionPerformed(ActionEvent e)
    	        {
    	          jButton1_actionPerformed(e);
    	        }
    	      });
    jButton2.setText("Close");
    jButton2.setBounds(new Rectangle(230, 455, 130, 30));
    
   
    jTextField3.addFocusListener(new FocusListener()
      {
          public void focusGained(FocusEvent e)
          {
          }
  
          public void focusLost(FocusEvent e)
          {
            jTextField3_focusLost();
          }
      });
    jButton2.addActionListener(new ActionListener()
      {
        public void actionPerformed(ActionEvent e)
        {
          jButton2_actionPerformed(e);
        }
      });
    jLabel4.setBounds(new Rectangle(55, 300, 305, 30));
    jLabel4.setForeground(Color.red);
    jCalendar1.setBounds(new Rectangle(190, 60, 225, 150));
    scrollPane.setBounds(new Rectangle(45, 305, 320, 116));
    
    this.getContentPane().add(scrollPane, null);
    
    table = new JTable();
    table.addMouseListener(new MouseAdapter() {
    	@Override
    	public void mouseClicked(MouseEvent e) {
    		int i=table.getSelectedRow();
    		String houseName =  (String) tableModel.getValueAt(i,1);
       		Date firstDate=new Date(((java.util.Date)tableModel.getValueAt(i,2)).getTime());
       		Date lastDate=new Date(((java.util.Date)tableModel.getValueAt(i,3)).getTime());
	
			BookRuralHouseGUI b=new BookRuralHouseGUI(houseName,firstDate,lastDate);
			b.setVisible(true);}
    });

    scrollPane.setViewportView(table);
    tableModel = new DefaultTableModel(
    			null,
            	columnNames);
        	
    table.setModel(tableModel);
    this.getContentPane().add(jCalendar1, null);
    this.getContentPane().add(jLabel4, null);
    this.getContentPane().add(jButton2, null);
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jTextField3, null);
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(jTextField2, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jLabel1, null);
    comboBox.setBounds(new Rectangle(245, 22, 115, 20));
    comboBox.setBounds(189, 22, 115, 20);
    
    getContentPane().add(comboBox);
    labelNoOffers.setBounds(73, 432, 265, 14);
    
    getContentPane().add(labelNoOffers);
    
    // Codigo para el JCalendar
    this.jCalendar1.addPropertyChangeListener(new PropertyChangeListener()
    {
      public void propertyChange(PropertyChangeEvent propertychangeevent)
      {
        if (propertychangeevent.getPropertyName().equals("locale"))
        {
          jCalendar1.setLocale((Locale) propertychangeevent.getNewValue());
          DateFormat dateformat = DateFormat.getDateInstance(1, jCalendar1.getLocale());
          jTextField2.setText(dateformat.format(calendarMio.getTime()));
        }
        else if (propertychangeevent.getPropertyName().equals("calendar"))
        {
          calendarMio = (Calendar) propertychangeevent.getNewValue();
          DateFormat dateformat1 = DateFormat.getDateInstance(1, jCalendar1.getLocale());
          jTextField2.setText(dateformat1.format(calendarMio.getTime()));
          jCalendar1.setCalendar(calendarMio);
        }
      } 
    });
    

  }

  private void jButton2_actionPerformed(ActionEvent e)
  {
    this.setVisible(false);
  }
  
  
 private void jTextField3_focusLost()
 {
   try
  {
    new Integer (jTextField3.getText());
    jLabel4.setText("");
  }
  catch (NumberFormatException ex)
  {
    jLabel4.setText("Error: Introduce a number");
  }
 }

 private void jButton1_actionPerformed(ActionEvent e)
 {		
 		// House object
 		RuralHouse rh=(RuralHouse)comboBox.getSelectedItem();
 		// First day
 		Date firstDay=new Date(jCalendar1.getCalendar().getTime().getTime());
 	    //Remove the hour:minute:second:ms from the date 
 		firstDay=Date.valueOf(firstDay.toString());
 		final long diams=1000*60*60*24;
 		long nights= diams * Integer.parseInt(jTextField3.getText());
 		// Last day
    	Date lastDay= new Date((long)(firstDay.getTime()+nights));
    	
    	try {
    		

    		Vector<Offer> v=rh.getOffers(firstDay, lastDay);
  
			Enumeration<Offer> en=v.elements();
			Offer of;
			tableModel.setDataVector(null, columnNames);
			if (!en.hasMoreElements())
				labelNoOffers.setText("There are no offers at these dates");
			else {
				labelNoOffers.setText("Select an offer if you want to book");

				while (en.hasMoreElements()) {
					of=en.nextElement();
					System.out.println("Offer retrieved: "+of.toString());
					Vector<Object> row = new Vector<Object>();
					row.add(of.getOfferNumber());
					row.add(of.getRuralHouse().getHouseName());

					// Dates are stored in db4o as java.util.Date objects instead of java.sql.Date objects
					// They have to be converted into java.sql.Date objects before
					Date firstDaySqlDate = new Date(of.getFirstDay().getTime());
					Date lastDaySqlDate = new Date(of.getLastDay().getTime());
					row.add(firstDaySqlDate);
					row.add(lastDaySqlDate);
					row.add(of.getPrice());

					
					tableModel.addRow(row);						
				}
			}

		
       } catch (Exception e1) {

    	   labelNoOffers.setText(e1.getMessage());
	}}	
}