Line 57... |
Line 57... |
57 |
mapList.put("Relances", Arrays.asList("RELANCE"));
|
57 |
mapList.put("Relances", Arrays.asList("RELANCE"));
|
58 |
mapList.put("Devis", Arrays.asList("DEVIS"));
|
58 |
mapList.put("Devis", Arrays.asList("DEVIS"));
|
59 |
mapList.put("Avoirs", Arrays.asList("AVOIR_CLIENT"));
|
59 |
mapList.put("Avoirs", Arrays.asList("AVOIR_CLIENT"));
|
60 |
mapList.put("Articles facturés", Arrays.asList("SAISIE_VENTE_FACTURE_ELEMENT"));
|
60 |
mapList.put("Articles facturés", Arrays.asList("SAISIE_VENTE_FACTURE_ELEMENT"));
|
61 |
mapList.put("Articles proposés", Arrays.asList("DEVIS_ELEMENT"));
|
61 |
mapList.put("Articles proposés", Arrays.asList("DEVIS_ELEMENT"));
|
- |
|
62 |
mapList.put("Encaissements", Arrays.asList("ENCAISSER_MONTANT"));
|
62 |
Map<SQLTable, SQLField> map = new HashMap<SQLTable, SQLField>();
|
63 |
Map<SQLTable, SQLField> map = new HashMap<SQLTable, SQLField>();
|
63 |
map.put(b.getTable("SAISIE_VENTE_FACTURE_ELEMENT"), b.getTable("SAISIE_VENTE_FACTURE_ELEMENT").getField("ID_SAISIE_VENTE_FACTURE"));
|
64 |
map.put(b.getTable("SAISIE_VENTE_FACTURE_ELEMENT"), b.getTable("SAISIE_VENTE_FACTURE_ELEMENT").getField("ID_SAISIE_VENTE_FACTURE"));
|
64 |
map.put(b.getTable("DEVIS_ELEMENT"), b.getTable("DEVIS_ELEMENT").getField("ID_DEVIS"));
|
65 |
map.put(b.getTable("DEVIS_ELEMENT"), b.getTable("DEVIS_ELEMENT").getField("ID_DEVIS"));
|
65 |
|
66 |
|
66 |
final HistoriqueClientBilanPanel bilanPanel = new HistoriqueClientBilanPanel();
|
67 |
final HistoriqueClientBilanPanel bilanPanel = new HistoriqueClientBilanPanel();
|
67 |
SQLTable tableEch = Configuration.getInstance().getRoot().findTable("ECHEANCE_CLIENT");
|
68 |
SQLTable tableEch = Configuration.getInstance().getRoot().findTable("ECHEANCE_CLIENT");
|
68 |
Where wNotRegle = new Where(tableEch.getField("REGLE"), "=", Boolean.FALSE);
|
69 |
Where wNotRegle = new Where(tableEch.getField("REGLE"), "=", Boolean.FALSE);
|
69 |
wNotRegle = wNotRegle.and(new Where(tableEch.getField("REG_COMPTA"), "=", Boolean.FALSE));
|
70 |
wNotRegle = wNotRegle.and(new Where(tableEch.getField("REG_COMPTA"), "=", Boolean.FALSE));
|
70 |
|
71 |
|
71 |
this.listPanel = new ListeHistoriquePanel("Clients", JListSQLTablePanel.createComboRequest(Configuration.getInstance().getDirectory().getElement(b.getTable("CLIENT")), true), mapList,
|
72 |
this.listPanel = new ListeHistoriquePanel("Clients", JListSQLTablePanel.createComboRequest(Configuration.getInstance().getDirectory().getElement(b.getTable("CLIENT")), false), mapList,
|
72 |
bilanPanel, map, wNotRegle);
|
73 |
bilanPanel, map, null, wNotRegle);
|
73 |
this.listPanel.addListenerTable(new TableModelListener() {
|
74 |
this.listPanel.addListenerTable(new TableModelListener() {
|
74 |
public void tableChanged(TableModelEvent arg0) {
|
75 |
public void tableChanged(TableModelEvent arg0) {
|
75 |
bilanPanel.updateRelance(HistoriqueClientFrame.this.listPanel.getListId("RELANCE"));
|
76 |
bilanPanel.updateRelance(HistoriqueClientFrame.this.listPanel.getListId("RELANCE"));
|
76 |
}
|
77 |
}
|
77 |
}, "RELANCE");
|
78 |
}, "RELANCE");
|
Line 117... |
Line 118... |
117 |
listPanel.removeAllTableListener();
|
118 |
listPanel.removeAllTableListener();
|
118 |
};
|
119 |
};
|
119 |
});
|
120 |
});
|
120 |
|
121 |
|
121 |
this.panelFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
|
122 |
this.panelFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
|
- |
|
123 |
|
- |
|
124 |
// // Daet filter
|
- |
|
125 |
// Map<IListe, SQLField> listeFilter = new HashMap<IListe, SQLField>();
|
- |
|
126 |
// IListe listeRel = this.listPanel.getIListeFromTableName("RELANCE");
|
- |
|
127 |
// listeFilter.put(listeRel, listeRel.getModel().getTable().getField("DATE"));
|
- |
|
128 |
// IListe listeVtC = this.listPanel.getIListeFromTableName("SAISIE_VENTE_COMPTOIR");
|
- |
|
129 |
// listeFilter.put(listeVtC, listeVtC.getModel().getTable().getField("DATE"));
|
- |
|
130 |
// IListe listeDevis = this.listPanel.getIListeFromTableName("DEVIS");
|
- |
|
131 |
// listeFilter.put(listeDevis, listeDevis.getModel().getTable().getField("DATE"));
|
- |
|
132 |
//
|
- |
|
133 |
// IListe listeChq = this.listPanel.getIListeFromTableName("CHEQUE_A_ENCAISSER");
|
- |
|
134 |
// listeFilter.put(listeChq, listeChq.getModel().getTable().getField("DATE"));
|
- |
|
135 |
//
|
- |
|
136 |
// IListe listeEch = this.listPanel.getIListeFromTableName("ECHEANCE_CLIENT");
|
- |
|
137 |
// listeFilter.put(listeEch, listeEch.getModel().getTable().getField("DATE"));
|
- |
|
138 |
// IListe listedevisElt = this.listPanel.getIListeFromTableName("DEVIS_ELEMENT");
|
- |
|
139 |
// listeFilter.put(listedevisElt,
|
- |
|
140 |
// listedevisElt.getModel().getTable().getForeignTable("ID_DEVIS").getField("DATE"));
|
- |
|
141 |
//
|
- |
|
142 |
// IListe listeAvoir = this.listPanel.getIListeFromTableName("AVOIR_CLIENT");
|
- |
|
143 |
// listeFilter.put(listeAvoir, listeAvoir.getModel().getTable().getField("DATE"));
|
- |
|
144 |
//
|
- |
|
145 |
// IListe listefactElt =
|
- |
|
146 |
// this.listPanel.getIListeFromTableName("SAISIE_VENTE_FACTURE_ELEMENT");
|
- |
|
147 |
// listeFilter.put(listefactElt,
|
- |
|
148 |
// listefactElt.getModel().getTable().getForeignTable("ID_SAISIE_VENTE_FACTURE").getField("DATE"));
|
- |
|
149 |
//
|
- |
|
150 |
// IListe listeFact = this.listPanel.getIListeFromTableName("SAISIE_VENTE_FACTURE");
|
- |
|
151 |
// listeFilter.put(listeFact, listeFact.getModel().getTable().getField("DATE"));
|
- |
|
152 |
//
|
- |
|
153 |
// final IListFilterDatePanel panel = new IListFilterDatePanel(listeFilter,
|
- |
|
154 |
// IListFilterDatePanel.getDefaultMap());
|
- |
|
155 |
// GridBagConstraints c = new DefaultGridBagConstraints();
|
- |
|
156 |
// c.gridy = 4;
|
- |
|
157 |
// c.gridwidth = GridBagConstraints.REMAINDER;
|
- |
|
158 |
// c.weightx = 1;
|
- |
|
159 |
// c.gridx=0;
|
- |
|
160 |
// this.listPanel.add(panel);
|
- |
|
161 |
|
122 |
}
|
162 |
}
|
123 |
|
163 |
|
124 |
public PanelFrame getFrame() {
|
164 |
public PanelFrame getFrame() {
|
125 |
return this.panelFrame;
|
165 |
return this.panelFrame;
|
126 |
}
|
166 |
}
|