affcontrat.java

用xml+swing+jdbc(hsqldb)写的电视广告管理软件 客户定义好广告的具体信息

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * AffContrat.java
 *
 * Created on 30 janv. 2009, 17:48:10
 */

package view.swing;

import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.List;
import java.util.Map;
import java.util.Vector;

import javax.swing.BorderFactory;
import javax.swing.DefaultListModel;
import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JList;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.LayoutStyle;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;
import javax.swing.table.DefaultTableCellRenderer;
import javax.swing.table.DefaultTableModel;

import service.IService;
import service.ServiceImpl;
import util.TableSorter;
import view.swing.model.DateColorTableCellRender;
import dao.model.Contrat;
import dao.model.Plage;
import dao.model.Spot;
import exception.MetieException;

/**
 *
 * @author Alex
 */
public class AffContrat extends javax.swing.JPanel {

    public AffContrat() {
        initComponents();
        service=new ServiceImpl();
    }

    private void initComponents() {

        jPanel1 = new JPanel();
        jLabel1 = new JLabel();
        jTextField1 = new JTextField();
        jButton1 = new JButton();
        jScrollPane1 = new JScrollPane();
        jList1 = new JList();
        jScrollPane2 = new JScrollPane();
        jTable1 = new JTable();
        jScrollPane4 = new JScrollPane();
        jTable3 = new JTable();


        jPanel1.setBorder(BorderFactory.createEtchedBorder());

        jLabel1.setText("Rechercher");

        jButton1.setText("Ok");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        GroupLayout jPanel1Layout = new GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
            .addGroup(GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
                .addContainerGap(154, Short.MAX_VALUE)
                .addComponent(jLabel1, GroupLayout.PREFERRED_SIZE, 80, GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jTextField1, GroupLayout.PREFERRED_SIZE, 175, GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(jButton1)
                .addGap(142, 142, 142))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap(GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGroup(jPanel1Layout.createParallelGroup(GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel1)
                    .addComponent(jTextField1, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
                    .addComponent(jButton1))
                .addContainerGap())
        );

        jList1.setBorder(BorderFactory.createTitledBorder("Contrat de"));
        jList1.setModel(new DefaultListModel());
        jList1.addListSelectionListener(new ListSelectionListener(){

			@Override
			public void valueChanged(ListSelectionEvent e) {
				jListValueChanged( e);
				
			}
        	
        });
        
        jScrollPane1.setViewportView(jList1);

        jTable1.setModel(new DefaultTableModel(
            new Object [][] {
            },
            new String [] {
            	"Date", "Début du Spot", "Catégorie"
            }
        ));
        TableSorter  sorter = new TableSorter(jTable1.getModel());
        jTable1.setModel(sorter);
        sorter.addMouseListenerToHeaderInTable(jTable1);
        DefaultTableCellRenderer dateColumnRenderer = new DateColorTableCellRender();
		jTable1.getColumn("Date").setCellRenderer(dateColumnRenderer);
        jScrollPane2.setViewportView(jTable1);

        jTable3.setModel(new DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null}
            },
            new String [] {
                "Nom de Client", "Titre", "Theme", "Duree", "Coût", "Date de Signature"
            }
        ));
        jScrollPane4.setViewportView(jTable3);

        GroupLayout layout = new GroupLayout(this);
        this.setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(GroupLayout.Alignment.LEADING)
            .addGroup(GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(layout.createParallelGroup(GroupLayout.Alignment.TRAILING)
                    .addComponent(jPanel1, GroupLayout.Alignment.LEADING, GroupLayout.DEFAULT_SIZE, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jScrollPane1, GroupLayout.PREFERRED_SIZE, 123, GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
                            .addComponent(jScrollPane2, GroupLayout.DEFAULT_SIZE, 479, Short.MAX_VALUE)
                            .addComponent(jScrollPane4, GroupLayout.DEFAULT_SIZE, 479, Short.MAX_VALUE))))
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(12, 12, 12)
                .addComponent(jPanel1, GroupLayout.PREFERRED_SIZE, 44, GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(layout.createParallelGroup(GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jScrollPane4, GroupLayout.PREFERRED_SIZE, 60, GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jScrollPane2, GroupLayout.PREFERRED_SIZE, 268, GroupLayout.PREFERRED_SIZE))
                    .addComponent(jScrollPane1, GroupLayout.DEFAULT_SIZE, 308, Short.MAX_VALUE))
                .addContainerGap())
        );
    }// </editor-fold>

    protected void jListValueChanged(ListSelectionEvent e) {
    	if(!e.getValueIsAdjusting()){
    		Contrat c = (Contrat) jList1.getSelectedValue();
    		if(c!=null){
    			//DISPLAY SPOT
    			Spot s=c.getSpot();
    			DefaultTableModel model=(DefaultTableModel) jTable3.getModel();
    			for (int i = model.getRowCount() - 1; i >= 0; i--) {
    				model.removeRow(i);
    				
    			}
    			Vector<Object> row=new Vector<Object>();
    			row.add(c.getNomClient());
    			row.add(s.getTitre());
    			row.add(s.getTheme());
    			row.add(s.getDuree());
    			row.add(c.getCout());
    			row.add(new SimpleDateFormat("dd/MM/yyyy").format(c.getDate()));
    			model.addRow(row);
    			
    			//DISPLAY PLAGES
    			DefaultTableModel model1=(DefaultTableModel) ((TableSorter) jTable1.getModel()).getModel();
    			try {
					Map<Plage,Timestamp> map=service.getPlageByContrat(s.getId());
					for (int i = model1.getRowCount() - 1; i >= 0; i--) {
						model1.removeRow(i);
						
					}
					for(Plage p:map.keySet()){
						Vector<Object> row1 = new Vector<Object>();
						SimpleDateFormat sf = new SimpleDateFormat("dd-MM-yyyy");
						String pDebut = sf.format(p.getDebut());
						row1.add(pDebut);

						sf=new SimpleDateFormat("hh:mm:ss");
						row1.add(sf.format(map.get(p)));

						row1.add(p.getCategorie());
						model1.addRow(row1);
					}
				} catch (MetieException e1) {
					e1.printStackTrace();
				}
    		}
    	}
	}

	private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
    	List<Contrat> list;
		try {
			list = service.getContrat(jTextField1.getText().trim());
			DefaultListModel model=(DefaultListModel)jList1.getModel();
			model.clear();
			for(Contrat c:list){
				model.addElement(c);
			}
		} catch (MetieException e) {
			e.printStackTrace();
		}
    }


    private JButton jButton1;
    private JLabel jLabel1;
    private JList jList1;
    private JPanel jPanel1;
    private JScrollPane jScrollPane1;
    private JScrollPane jScrollPane2;
    private JScrollPane jScrollPane4;
    private JTable jTable1;
    private JTable jTable3;
    private JTextField jTextField1;
    private IService service;

}