import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.*;

public class SlobodnoOsluskivac implements ActionListener{
	private PanelDestinacija  pDest;
	private PanelAranzman pAranzman;
	private PanelKategorijaDestinacije pKdestinacije;
	private int id;
	private JScrollPane scroll;

	private int compW=100;
	private int compH=30;
	private int offsetW=compW+20;
	private int offsetH=compH+10;

	public SlobodnoOsluskivac(int id, PanelDestinacija pD, PanelAranzman pA, PanelKategorijaDestinacije pKd, JScrollPane s) {
		this.id = id;
		pDest = pD;
		pAranzman = pA;
		pKdestinacije = pKd;
		scroll = s;

	}

	@Override
	public void actionPerformed(ActionEvent arg0) {
		// TODO Auto-generated method stub
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
			Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3307/java_turs","root","");
			String query="SELECT *, prevoz.tip FROM aranzman JOIN ponuda ON aranzman.id = ponuda.aranzman_id JOIN prevoz ON aranzman.prevoz_id = prevoz.id WHERE ponuda.destinacija_id=" + id+"";

			PreparedStatement prepStat = con.prepareStatement(query);

			ResultSet rs=prepStat.executeQuery();

			int brojac = 1;
			while(rs.next()) {

			JLabel pansionL1= new JLabel(rs.getString("pansion"));
			pansionL1.setBounds(10, 40 + offsetH*brojac, compW, compH);
			pAranzman.add(pansionL1);

			JLabel smestajL1= new JLabel(rs.getString("smestaj"));
			smestajL1.setBounds(pansionL1.getX()+offsetW, pansionL1.getY(), compW, compH);
			pAranzman.add(smestajL1);

			JLabel opisL1= new JLabel(rs.getString("opis"));
			opisL1.setBounds(smestajL1.getX()+offsetW, pansionL1.getY(), compW, compH);
			pAranzman.add(opisL1);

			JLabel bazenL1= new JLabel(rs.getString("bazen"));
			bazenL1.setBounds(opisL1.getX()+offsetW, pansionL1.getY(), compW, compH);
			pAranzman.add(bazenL1);

			JLabel prevozL1= new JLabel(rs.getString("prevoz"));
			prevozL1.setBounds(bazenL1.getX()+offsetW, pansionL1.getY(), compW, compH);
			pAranzman.add(prevozL1);

			JLabel klimaL1= new JLabel(rs.getString("klima"));
			klimaL1.setBounds(prevozL1.getX()+offsetW, pansionL1.getY(), compW, compH);
			pAranzman.add(klimaL1);

			JLabel terasaL1= new JLabel(rs.getString("terasa"));
			terasaL1.setBounds(klimaL1.getX()+offsetW, pansionL1.getY(), compW, compH);
			pAranzman.add(terasaL1);

			JLabel cenaL1= new JLabel(rs.getString("cena"));
			cenaL1.setBounds(terasaL1.getX()+offsetW, pansionL1.getY(), compW, compH);
			pAranzman.add(cenaL1);

			JLabel terminL1= new JLabel(rs.getString("termin"));
			terminL1.setBounds(cenaL1.getX()+offsetW, pansionL1.getY(), compW, compH);
			pAranzman.add(terminL1);

			JLabel petFriendlyL1= new JLabel(rs.getString("pet_friendly"));
			petFriendlyL1.setBounds(terminL1.getX()+offsetW, pansionL1.getY(), compW, compH);
			pAranzman.add(petFriendlyL1);

			JLabel trajanjeL1= new JLabel(rs.getString("trajanje"));
			trajanjeL1.setBounds(petFriendlyL1.getX()+offsetW, pansionL1.getY(), compW, compH);
			pAranzman.add(trajanjeL1);

			brojac++;
			}
			pDest.setVisible(false);
			pKdestinacije.setVisible(false);
			scroll.setVisible(true);

		}catch (Exception e) {
			System.out.println("Pojavio se izuzetak"+e);
		}
	}

}