public BalanceAgeePanel() {
super(new GridBagLayout());
JLabel label = new JLabel("Balance âgée client pour la période du ");
SQLRow rowExercice =
((ComptaPropsConfiguration) Configuration.getInstance())
.getRowSociete()
.getForeignRow("ID_EXERCICE_COMMON");
Calendar dDebut = rowExercice.getDate("DATE_DEB");
final JDate dateDeb = new JDate();
dateDeb.setDate(dDebut.getTime());
final JDate dateFin = new JDate(true);
DefaultGridBagConstraints c = new DefaultGridBagConstraints();
c.gridx = GridBagConstraints.RELATIVE;
this.add(label, c);
this.add(dateDeb, c);
this.add(new JLabel("au"), c);
this.add(dateFin, c);
c.gridy++;
c.gridx = 0;
c.gridwidth = GridBagConstraints.REMAINDER;
final JCheckBox boxExcludeEcr = new JCheckBox("Exclure les écritures de clotures");
boxExcludeEcr.setSelected(true);
this.add(boxExcludeEcr, c);
c.gridy++;
c.gridwidth = GridBagConstraints.REMAINDER;
c.anchor = GridBagConstraints.EAST;
c.fill = GridBagConstraints.NONE;
JButton gen = new JButton("Créer");
this.add(gen, c);
gen.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
BalanceAgeeListeSheetXML l =
new BalanceAgeeListeSheetXML(
dateDeb.getDate(), dateFin.getDate(), boxExcludeEcr.isSelected());
try {
l.createDocument();
l.openDocument(false);
} catch (Exception originalExn) {
ExceptionHandler.handle("Impossible de créer la balance âgée", originalExn);
}
}
});
}
private JPanel createPanelDiff(final Type_Diff type) {
GridBagConstraints cTabSite = new DefaultGridBagConstraints();
JPanel tabSite = new JPanel(new GridBagLayout());
cTabSite.weightx = 1;
cTabSite.fill = GridBagConstraints.HORIZONTAL;
cTabSite.gridwidth = 2;
final String name = type.getName();
final JCheckBox boxSiteDiff = new JCheckBox(getLabelFor(name + "_DIFF"));
tabSite.add(boxSiteDiff, cTabSite);
this.addView(boxSiteDiff, name + "_DIFF");
final String fieldSiren = "SIREN_" + name;
if (getTable().contains(fieldSiren)) {
final JLabel labelSrenSite = new JLabel(getLabelFor(fieldSiren));
labelSrenSite.setHorizontalAlignment(SwingConstants.RIGHT);
cTabSite.gridwidth = 1;
cTabSite.gridx = 2;
cTabSite.weightx = 0;
tabSite.add(labelSrenSite, cTabSite);
cTabSite.gridx++;
cTabSite.weightx = 1;
if (type == Type_Diff.SITE) {
throw new IllegalArgumentException("Le siren n'est pas à renseigné pour le site");
}
final JTextField siren = this.sirenDonneur;
tabSite.add(siren, cTabSite);
this.addView(siren, fieldSiren);
DefaultGridBagConstraints.lockMinimumSize(siren);
}
cTabSite.gridy++;
cTabSite.gridx = 0;
cTabSite.weightx = 0;
cTabSite.fill = GridBagConstraints.HORIZONTAL;
cTabSite.gridwidth = 1;
final JLabel labelSiteDes = new JLabel(getLabelFor("DESIGNATION_" + name));
labelSiteDes.setHorizontalAlignment(SwingConstants.RIGHT);
tabSite.add(labelSiteDes, cTabSite);
cTabSite.gridx++;
cTabSite.weightx = 1;
final JTextField designation = type == Type_Diff.SITE ? this.desSite : this.desDonneur;
tabSite.add(designation, cTabSite);
this.addView(designation, "DESIGNATION_" + name);
DefaultGridBagConstraints.lockMinimumSize(designation);
final JLabel labelTelSite = new JLabel(getLabelFor("TEL_" + name));
labelTelSite.setHorizontalAlignment(SwingConstants.RIGHT);
cTabSite.gridx++;
cTabSite.weightx = 0;
tabSite.add(labelTelSite, cTabSite);
cTabSite.gridx++;
cTabSite.weightx = 1;
final JTextField tel = type == Type_Diff.SITE ? this.telSite : this.telDonneur;
tabSite.add(tel, cTabSite);
this.addView(tel, "TEL_" + name);
DefaultGridBagConstraints.lockMinimumSize(tel);
final JLabel labelSiteAdr = new JLabel(getLabelFor("ADRESSE_" + name));
labelSiteAdr.setHorizontalAlignment(SwingConstants.RIGHT);
cTabSite.gridy++;
cTabSite.gridx = 0;
cTabSite.weightx = 0;
tabSite.add(labelSiteAdr, cTabSite);
cTabSite.gridx++;
cTabSite.weightx = 1;
final ITextArea adresse = type == Type_Diff.SITE ? this.adrSite : this.adrDonneur;
tabSite.add(adresse, cTabSite);
this.addView(adresse, "ADRESSE_" + name);
DefaultGridBagConstraints.lockMinimumSize(adresse);
final JLabel labelTelPSite = new JLabel(getLabelFor("TEL_P_" + name));
labelTelPSite.setHorizontalAlignment(SwingConstants.RIGHT);
cTabSite.gridx++;
cTabSite.weightx = 0;
tabSite.add(labelTelPSite, cTabSite);
cTabSite.gridx++;
cTabSite.weightx = 1;
final JTextField telP = type == Type_Diff.SITE ? this.telPSite : this.telPDonneur;
tabSite.add(telP, cTabSite);
this.addView(telP, "TEL_P_" + name);
cTabSite.gridy++;
cTabSite.gridx = 0;
cTabSite.weightx = 0;
final JLabel labelVilleAdr = new JLabel(getLabelFor("VILLE_" + name));
labelVilleAdr.setHorizontalAlignment(SwingConstants.RIGHT);
tabSite.add(labelVilleAdr, cTabSite);
cTabSite.gridx++;
cTabSite.weightx = 1;
final ITextComboVilleViewer ville = type == Type_Diff.SITE ? this.villeSite : this.villeDonneur;
tabSite.add(ville, cTabSite);
this.addView(ville, "VILLE_" + name);
DefaultGridBagConstraints.lockMinimumSize(ville);
cTabSite.gridx++;
cTabSite.weightx = 0;
final JLabel labelFaxSite = new JLabel(getLabelFor("FAX_" + name));
labelFaxSite.setHorizontalAlignment(SwingConstants.RIGHT);
tabSite.add(labelFaxSite, cTabSite);
cTabSite.gridx++;
cTabSite.weightx = 1;
final JTextField fax = type == Type_Diff.SITE ? this.faxSite : this.faxDonneur;
tabSite.add(fax, cTabSite);
this.addView(fax, "FAX_" + name);
DefaultGridBagConstraints.lockMinimumSize(fax);
cTabSite.gridy++;
cTabSite.gridx = 0;
cTabSite.weightx = 0;
final JLabel labelContactSite = new JLabel(getLabelFor("CONTACT_" + name));
labelContactSite.setHorizontalAlignment(SwingConstants.RIGHT);
tabSite.add(labelContactSite, cTabSite);
cTabSite.gridx++;
cTabSite.weightx = 1;
final JTextField contact = type == Type_Diff.SITE ? this.contactSite : this.contactDonneur;
tabSite.add(contact, cTabSite);
this.addView(contact, "CONTACT_" + name);
cTabSite.gridx++;
cTabSite.weightx = 0;
final JLabel labelMailSite = new JLabel(getLabelFor("MAIL_" + name));
labelMailSite.setHorizontalAlignment(SwingConstants.RIGHT);
tabSite.add(labelMailSite, cTabSite);
cTabSite.gridx++;
cTabSite.weightx = 1;
final JTextField mail = type == Type_Diff.SITE ? this.mailSite : this.mailDonneur;
tabSite.add(mail, cTabSite);
this.addView(mail, "MAIL_" + name);
boxSiteDiff.addItemListener(
new ItemListener() {
@Override
public void itemStateChanged(ItemEvent e) {
final boolean selected = boxSiteDiff.isSelected();
setSiteEnabled(selected, type);
if (!selected) {
clearFieldDiff(type);
}
}
});
return tabSite;
}
@Override
public void addViews() {
setLayout(new GridBagLayout());
final GridBagConstraints c = new DefaultGridBagConstraints();
// Champ Module
c.gridx = 0;
c.gridy++;
c.gridwidth = GridBagConstraints.REMAINDER;
final JPanel addP = ComptaSQLConfElement.createAdditionalPanel();
this.setAdditionalFieldsPanel(new FormLayouter(addP, 2));
this.add(addP, c);
c.gridy++;
c.gridwidth = 1;
final JLabel labelNumero = new JLabel(getLabelFor("NUMERO"));
labelNumero.setHorizontalAlignment(SwingConstants.RIGHT);
this.add(labelNumero, c);
// Ligne 1: Numero du devis
c.gridx++;
c.weightx = 1;
c.fill = GridBagConstraints.NONE;
this.numeroUniqueDevis = new JUniqueTextField(15);
DefaultGridBagConstraints.lockMinimumSize(this.numeroUniqueDevis);
DefaultGridBagConstraints.lockMaximumSize(this.numeroUniqueDevis);
this.add(this.numeroUniqueDevis, c);
// Date
c.gridx++;
c.weightx = 0;
c.fill = GridBagConstraints.HORIZONTAL;
final JLabel labelDate = new JLabel(getLabelFor("DATE"));
labelDate.setHorizontalAlignment(SwingConstants.RIGHT);
this.add(labelDate, c);
c.gridx++;
c.weightx = 1;
c.fill = GridBagConstraints.NONE;
final JDate dateDevis = new JDate(true);
this.add(dateDevis, c);
// Etat devis
this.radioEtat.setLayout(new VFlowLayout());
this.radioEtat.setBorder(BorderFactory.createTitledBorder(getLabelFor("ID_ETAT_DEVIS")));
c.gridwidth = GridBagConstraints.REMAINDER;
c.gridheight = 5;
c.weightx = 0;
c.fill = GridBagConstraints.NONE;
c.anchor = GridBagConstraints.EAST;
c.gridx += 2;
this.radioEtat.initLocalization(
new ITransformer<String, String>() {
@Override
public String transformChecked(String id) {
return id;
// return TranslationManager.getInstance().getTranslationForItem(id);
}
});
this.add(this.radioEtat, c);
// this.radioEtat.setVisible(false);
// Ligne 2: Reference
c.gridx = 0;
c.gridy++;
c.gridwidth = 1;
c.gridheight = 1;
c.fill = GridBagConstraints.HORIZONTAL;
c.weightx = 0;
final JLabel labelObjet = new JLabel(getLabelFor("OBJET"));
labelObjet.setHorizontalAlignment(SwingConstants.RIGHT);
this.add(labelObjet, c);
final SQLTextCombo textObjet = new SQLTextCombo();
c.gridx++;
c.weightx = 1;
c.gridwidth = 1;
c.fill = GridBagConstraints.BOTH;
this.add(textObjet, c);
String field;
field = "ID_COMMERCIAL";
// Commercial
final JLabel labelCommercial = new JLabel(getLabelFor(field));
labelCommercial.setHorizontalAlignment(SwingConstants.RIGHT);
c.gridx++;
c.fill = GridBagConstraints.HORIZONTAL;
c.weightx = 0;
this.add(labelCommercial, c);
final ElementComboBox comboCommercial = new ElementComboBox(false, 25);
comboCommercial.setListIconVisible(false);
c.gridx++;
c.weightx = 1;
c.fill = GridBagConstraints.NONE;
c.anchor = GridBagConstraints.WEST;
this.add(comboCommercial, c);
addRequiredSQLObject(comboCommercial, field);
// Ligne 3: Client
c.gridx = 0;
c.gridy++;
c.gridwidth = 1;
final JLabel labelClient = new JLabel(getLabelFor("ID_CLIENT"));
labelClient.setHorizontalAlignment(SwingConstants.RIGHT);
c.weightx = 0;
c.gridwidth = 1;
c.fill = GridBagConstraints.HORIZONTAL;
this.add(labelClient, c);
final ElementComboBox comboClient = new ElementComboBox();
c.gridx++;
c.gridwidth = 1;
c.weightx = 0;
c.weighty = 0;
c.fill = GridBagConstraints.NONE;
this.add(comboClient, c);
addRequiredSQLObject(comboClient, "ID_CLIENT");
final ElementComboBox boxTarif = new ElementComboBox();
if (getTable().getFieldsName().contains("DATE_VALIDITE")) {
c.gridx++;
this.add(new JLabel(getLabelFor("DATE_VALIDITE")), c);
c.gridx++;
JDate dateValidite = new JDate();
this.add(dateValidite, c);
this.addView(dateValidite, "DATE_VALIDITE");
}
// Tarif
if (this.getTable().getFieldsName().contains("ID_TARIF")) {
// TARIF
c.gridy++;
c.gridx = 0;
c.weightx = 0;
c.weighty = 0;
c.gridwidth = 1;
JLabel comp = new JLabel("Tarif à appliquer", SwingConstants.RIGHT);
this.add(comp, c);
c.gridx++;
c.gridwidth = GridBagConstraints.REMAINDER;
c.weightx = 1;
this.add(boxTarif, c);
this.addView(boxTarif, "ID_TARIF");
DefaultGridBagConstraints.lockMinimumSize(boxTarif);
boxTarif.addModelListener(
"wantedID",
new PropertyChangeListener() {
@Override
public void propertyChange(PropertyChangeEvent evt) {
SQLRow selectedRow =
boxTarif.getRequest().getPrimaryTable().getRow(boxTarif.getWantedID());
table.setTarif(selectedRow, !isFilling());
}
});
}
// Table d'élément
this.table = new DevisItemTable();
c.fill = GridBagConstraints.BOTH;
c.gridx = 0;
c.gridy += 5;
c.weighty = 1;
c.gridwidth = GridBagConstraints.REMAINDER;
this.add(this.table, c);
this.addView(this.table.getRowValuesTable(), "");
// Panel en bas
final JPanel bottomPanel = new JPanel(new GridBagLayout());
final GridBagConstraints cBottom = new DefaultGridBagConstraints();
// 1ere Colonne : Infos
cBottom.weightx = 1;
bottomPanel.add(new TitledSeparator(getLabelFor("INFOS")), cBottom);
cBottom.gridy++;
cBottom.fill = GridBagConstraints.BOTH;
cBottom.weighty = 0;
final JScrollPane scrollPane = new JScrollPane(this.infos);
scrollPane.setBorder(null);
bottomPanel.add(scrollPane, cBottom);
// 2eme Colonne : Poids total
final JPanel panel = new JPanel(new GridBagLayout());
this.textPoidsTotal = new JTextField(8);
this.textPoidsTotal.setText("0.0");
final GridBagConstraints cPanel = new DefaultGridBagConstraints();
panel.add(new JLabel(getLabelFor("T_POIDS")), cPanel);
cPanel.weightx = 0;
cPanel.gridx++;
panel.add(this.textPoidsTotal, cPanel);
this.textPoidsTotal.setEnabled(false);
this.textPoidsTotal.setEditable(false);
this.textPoidsTotal.setHorizontalAlignment(SwingConstants.RIGHT);
this.textPoidsTotal.setDisabledTextColor(Color.BLACK);
// Port
cPanel.gridy++;
cPanel.gridx = 0;
panel.add(new JLabel(getLabelFor("PORT_HT"), SwingConstants.RIGHT), cPanel);
cPanel.gridx++;
final DeviseField textPortHT = new DeviseField();
panel.add(textPortHT, cPanel);
// Remise HT
final JRadioButton radioEuros = new JRadioButton("en €");
final JRadioButton radioPourCent = new JRadioButton("en %");
final ButtonGroup radioGroup = new ButtonGroup();
radioGroup.add(radioEuros);
radioGroup.add(radioPourCent);
radioEuros.setSelected(true);
final JPanel panelRemise = new JPanel(new GridBagLayout());
final GridBagConstraints cRemise = new DefaultGridBagConstraints();
cRemise.insets = new Insets(0, 0, 1, 0);
final JLabel labelRemise = new JLabel(getLabelFor("REMISE_HT"));
panelRemise.add(labelRemise, cRemise);
cRemise.gridx++;
panelRemise.add(radioEuros, cRemise);
cRemise.gridx++;
cRemise.weightx = 0;
this.textRemiseHT = new DeviseField();
panelRemise.add(this.textRemiseHT, cRemise);
this.textRemiseHT.setMinimumSize(new Dimension(150, 20));
this.textRemiseHT.setPreferredSize(new Dimension(150, 20));
cRemise.gridx = 1;
cRemise.gridy++;
cRemise.weightx = 0;
panelRemise.add(radioPourCent, cRemise);
this.textPourcentRemise = new JTextField(5);
DefaultGridBagConstraints.lockMinimumSize(this.textPourcentRemise);
cRemise.gridx++;
panelRemise.add(this.textPourcentRemise, cRemise);
cPanel.gridx = 0;
cPanel.gridy++;
cPanel.gridwidth = 2;
panel.add(panelRemise, cPanel);
cBottom.gridy = 0;
cBottom.gridx++;
cBottom.weighty = 0;
cBottom.weightx = 1;
cBottom.gridheight = 2;
cBottom.fill = GridBagConstraints.HORIZONTAL;
cBottom.anchor = GridBagConstraints.NORTHEAST;
DefaultGridBagConstraints.lockMinimumSize(panel);
// bottomPanel.add(panel, cBottom);
addSQLObject(this.textRemiseHT, "REMISE_HT");
addSQLObject(textPortHT, "PORT_HT");
// this.checkImpression.setSelected(true);
// Total
this.fieldHT = new DeviseField();
final DeviseField fieldTVA = new DeviseField();
final DeviseField fieldTTC = new DeviseField();
final DeviseField fieldDevise = new DeviseField();
final DeviseField fieldService = new DeviseField();
this.fieldHT.setEditable(false);
fieldTVA.setEditable(false);
fieldTTC.setEditable(false);
fieldService.setEditable(false);
addRequiredSQLObject(this.fieldHT, "T_HT");
addRequiredSQLObject(fieldTVA, "T_TVA");
addSQLObject(fieldDevise, "T_DEVISE");
addRequiredSQLObject(fieldTTC, "T_TTC");
addRequiredSQLObject(fieldService, "T_SERVICE");
JTextField poids = new JTextField();
// addSQLObject(poids, "T_POIDS");
// FIXME Field add field T_HA dans installation avec recalcul des devis deja saisis
final DeviseField fieldHA = new DeviseField();
if (getTable().contains("PREBILAN")) {
addSQLObject(fieldHA, "PREBILAN");
} else if (getTable().contains("T_HA")) {
addSQLObject(fieldHA, "T_HA");
}
final TotalPanel totalTTC =
new TotalPanel(
this.table,
this.fieldHT,
fieldTVA,
fieldTTC,
textPortHT,
this.textRemiseHT,
fieldService,
fieldHA,
fieldDevise,
poids,
null);
cBottom.gridy = 0;
cBottom.gridx += 2;
cBottom.gridheight = 2;
cBottom.gridwidth = 1;
cBottom.fill = GridBagConstraints.NONE;
cBottom.weightx = 0;
cBottom.anchor = GridBagConstraints.NORTHEAST;
DefaultGridBagConstraints.lockMinimumSize(totalTTC);
bottomPanel.add(totalTTC, cBottom);
c.gridy++;
c.gridx = 0;
c.weighty = 0;
c.fill = GridBagConstraints.HORIZONTAL;
c.gridwidth = GridBagConstraints.REMAINDER;
this.add(bottomPanel, c);
c.gridx = 0;
c.gridy++;
c.weighty = 0;
c.fill = GridBagConstraints.NONE;
c.anchor = GridBagConstraints.SOUTHEAST;
this.panelOO = new PanelOOSQLComponent(this);
this.add(this.panelOO, c);
textPortHT
.getDocument()
.addDocumentListener(
new SimpleDocumentListener() {
@Override
public void update(final DocumentEvent e) {
totalTTC.updateTotal();
}
});
this.textRemiseHT
.getDocument()
.addDocumentListener(
new SimpleDocumentListener() {
@Override
public void update(final DocumentEvent e) {
totalTTC.updateTotal();
}
});
this.textPourcentRemise
.getDocument()
.addDocumentListener(
new SimpleDocumentListener() {
@Override
public void update(final DocumentEvent e) {
calculPourcentage();
}
});
radioEuros.addChangeListener(
new ChangeListener() {
public void stateChanged(final ChangeEvent e) {
DevisSQLComponent.this.textRemiseHT.setEnabled(radioEuros.isSelected());
DevisSQLComponent.this.textPourcentRemise.setEnabled(!radioEuros.isSelected());
}
});
this.table
.getModel()
.addTableModelListener(
new TableModelListener() {
public void tableChanged(final TableModelEvent e) {
DevisSQLComponent.this.textPoidsTotal.setText(
String.valueOf(DevisSQLComponent.this.table.getPoidsTotal()));
}
});
addSQLObject(textObjet, "OBJET");
addSQLObject(this.textPoidsTotal, "T_POIDS");
addRequiredSQLObject(dateDevis, "DATE");
addRequiredSQLObject(this.radioEtat, "ID_ETAT_DEVIS");
addRequiredSQLObject(this.numeroUniqueDevis, "NUMERO");
addSQLObject(this.infos, "INFOS");
comboClient.addModelListener(
"wantedID",
new PropertyChangeListener() {
@Override
public void propertyChange(PropertyChangeEvent arg0) {
if (!isFilling()) {
Integer id = comboClient.getWantedID();
if (id > 1) {
SQLRow row = comboClient.getElement().getTable().getRow(id);
if (comboClient.getElement().getTable().getFieldsName().contains("ID_TARIF")) {
SQLRowAccessor foreignRow = row.getForeignRow("ID_TARIF");
if (!foreignRow.isUndefined()
&& (boxTarif.getSelectedRow() == null
|| boxTarif.getSelectedId() != foreignRow.getID())
&& JOptionPane.showConfirmDialog(
null, "Appliquer les tarifs associés au client?")
== JOptionPane.YES_OPTION) {
boxTarif.setValue(foreignRow.getID());
// SaisieVenteFactureSQLComponent.this.tableFacture.setTarif(foreignRow,
// true);
} else {
boxTarif.setValue(foreignRow.getID());
}
// SQLRowAccessor foreignRow = row.getForeignRow("ID_TARIF");
// if (foreignRow.isUndefined() &&
// !row.getForeignRow("ID_DEVISE").isUndefined()) {
// SQLRowValues rowValsD = new SQLRowValues(foreignRow.getTable());
// rowValsD.put("ID_DEVISE", row.getObject("ID_DEVISE"));
// foreignRow = rowValsD;
//
// }
// table.setTarif(foreignRow, true);
}
}
}
}
});
DefaultGridBagConstraints.lockMinimumSize(comboCommercial);
DefaultGridBagConstraints.lockMinimumSize(comboClient);
}
