2 * To change this license header, choose License Headers in Project Properties.
3 * To change this template file, choose Tools | Templates
4 * and open the template in the editor.
8 import java
.awt
.Component
;
9 import java
.util
.ArrayList
;
10 import javax
.swing
.JFileChooser
;
11 import javax
.swing
.JOptionPane
;
12 import javax
.swing
.JTable
;
13 import javax
.swing
.filechooser
.FileFilter
;
14 import javax
.swing
.filechooser
.FileNameExtensionFilter
;
15 import javax
.swing
.table
.DefaultTableModel
;
16 import javax
.swing
.table
.TableCellRenderer
;
17 import javax
.swing
.table
.TableColumn
;
18 import javax
.swing
.table
.TableColumnModel
;
24 public class NoticesReportViewDialog
extends javax
.swing
.JDialog
{
26 private int currentReport
;
27 private String reportTitle
;
28 private String
[] reportCols
;
29 private ArrayList
<Object
> reportData
;
32 * Creates new form NoticesReportViewDialog
34 public NoticesReportViewDialog(java
.awt
.Frame parent
, boolean modal
) {
41 * This method is called from within the constructor to initialize the form.
42 * WARNING: Do NOT modify this code. The content of this method is always
43 * regenerated by the Form Editor.
45 @SuppressWarnings("unchecked")
46 // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
47 private void initComponents() {
49 popMenu
= new javax
.swing
.JPopupMenu();
50 menuExportCSV
= new javax
.swing
.JMenuItem();
51 labelReportTitle
= new javax
.swing
.JLabel();
52 jScrollPane2
= new javax
.swing
.JScrollPane();
53 tableReport
= new javax
.swing
.JTable();
54 checkFilterByClient
= new javax
.swing
.JCheckBox();
55 comboClients
= new javax
.swing
.JComboBox
<>();
56 buttonApply
= new javax
.swing
.JButton();
58 popMenu
.setLabel("Popup");
60 menuExportCSV
.setMnemonic('C');
61 menuExportCSV
.setText("Export as CSV...");
62 menuExportCSV
.addActionListener(new java
.awt
.event
.ActionListener() {
63 public void actionPerformed(java
.awt
.event
.ActionEvent evt
) {
64 menuExportCSVActionPerformed(evt
);
67 popMenu
.add(menuExportCSV
);
69 setDefaultCloseOperation(javax
.swing
.WindowConstants
.DISPOSE_ON_CLOSE
);
70 setTitle("View Report");
71 setLocationByPlatform(true);
73 labelReportTitle
.setFont(new java
.awt
.Font("Noto Sans", 1, 15)); // NOI18N
74 labelReportTitle
.setHorizontalAlignment(javax
.swing
.SwingConstants
.CENTER
);
75 labelReportTitle
.setText("REPORT TITLE");
77 tableReport
.setModel(new javax
.swing
.table
.DefaultTableModel(
85 tableReport
.setAutoResizeMode(javax
.swing
.JTable
.AUTO_RESIZE_OFF
);
86 tableReport
.setCellSelectionEnabled(true);
87 tableReport
.setComponentPopupMenu(popMenu
);
88 jScrollPane2
.setViewportView(tableReport
);
90 checkFilterByClient
.setText("Filter by Client");
92 buttonApply
.setMnemonic('a');
93 buttonApply
.setText("Apply");
94 buttonApply
.setToolTipText("");
95 buttonApply
.addActionListener(new java
.awt
.event
.ActionListener() {
96 public void actionPerformed(java
.awt
.event
.ActionEvent evt
) {
97 buttonApplyActionPerformed(evt
);
101 javax
.swing
.GroupLayout layout
= new javax
.swing
.GroupLayout(getContentPane());
102 getContentPane().setLayout(layout
);
103 layout
.setHorizontalGroup(
104 layout
.createParallelGroup(javax
.swing
.GroupLayout
.Alignment
.LEADING
)
105 .addComponent(jScrollPane2
, javax
.swing
.GroupLayout
.DEFAULT_SIZE
, 679, Short
.MAX_VALUE
)
106 .addGroup(layout
.createSequentialGroup()
107 .addComponent(labelReportTitle
, javax
.swing
.GroupLayout
.DEFAULT_SIZE
, javax
.swing
.GroupLayout
.DEFAULT_SIZE
, Short
.MAX_VALUE
)
109 .addGroup(layout
.createSequentialGroup()
111 .addComponent(checkFilterByClient
, javax
.swing
.GroupLayout
.PREFERRED_SIZE
, 196, javax
.swing
.GroupLayout
.PREFERRED_SIZE
)
112 .addPreferredGap(javax
.swing
.LayoutStyle
.ComponentPlacement
.RELATED
)
113 .addComponent(comboClients
, 0, javax
.swing
.GroupLayout
.DEFAULT_SIZE
, Short
.MAX_VALUE
)
114 .addPreferredGap(javax
.swing
.LayoutStyle
.ComponentPlacement
.RELATED
)
115 .addComponent(buttonApply
, javax
.swing
.GroupLayout
.PREFERRED_SIZE
, 106, javax
.swing
.GroupLayout
.PREFERRED_SIZE
))
117 layout
.setVerticalGroup(
118 layout
.createParallelGroup(javax
.swing
.GroupLayout
.Alignment
.LEADING
)
119 .addGroup(layout
.createSequentialGroup()
120 .addComponent(labelReportTitle
, javax
.swing
.GroupLayout
.PREFERRED_SIZE
, 21, javax
.swing
.GroupLayout
.PREFERRED_SIZE
)
121 .addPreferredGap(javax
.swing
.LayoutStyle
.ComponentPlacement
.RELATED
)
122 .addGroup(layout
.createParallelGroup(javax
.swing
.GroupLayout
.Alignment
.BASELINE
)
123 .addComponent(checkFilterByClient
)
124 .addComponent(comboClients
, javax
.swing
.GroupLayout
.PREFERRED_SIZE
, javax
.swing
.GroupLayout
.DEFAULT_SIZE
, javax
.swing
.GroupLayout
.PREFERRED_SIZE
)
125 .addComponent(buttonApply
))
126 .addPreferredGap(javax
.swing
.LayoutStyle
.ComponentPlacement
.RELATED
)
127 .addComponent(jScrollPane2
, javax
.swing
.GroupLayout
.DEFAULT_SIZE
, 326, Short
.MAX_VALUE
))
131 }// </editor-fold>//GEN-END:initComponents
133 private void menuExportCSVActionPerformed(java
.awt
.event
.ActionEvent evt
) {//GEN-FIRST:event_menuExportCSVActionPerformed
134 // TODO add your handling code here:
135 JFileChooser chooser
= new JFileChooser ();
136 FileFilter filter
= new FileNameExtensionFilter("Comma Separated Values (.csv)", "csv");
137 chooser
.setFileFilter(filter
);
138 int rt
= chooser
.showSaveDialog(this);
139 if (rt
== JFileChooser
.APPROVE_OPTION
) {
140 String filePath
= chooser
.getSelectedFile().getAbsolutePath();
141 if (!filePath
.endsWith(".csv"))
142 filePath
= filePath
.concat(".csv");
143 boolean ret
= Utility
.saveReportCSV (filePath
, reportCols
, reportData
);
145 JOptionPane
.showMessageDialog(this, ERROR_SAVING_REPORT
);
147 JOptionPane
.showMessageDialog(this, REPORT_SAVED_SUCCESSFULLY
);
149 }//GEN-LAST:event_menuExportCSVActionPerformed
151 private void buttonApplyActionPerformed(java
.awt
.event
.ActionEvent evt
) {//GEN-FIRST:event_buttonApplyActionPerformed
152 // TODO add your handling code here:
153 if (! checkFilterByClient
.isSelected()) {
154 reportData
= Utility
.getReportData(currentReport
, -1);
156 if (reportData
!= null)
159 DBItem db
= (DBItem
)comboClients
.getSelectedItem();
162 int selid
= db
.getKey();
163 reportData
= Utility
.getReportData(currentReport
, selid
);
164 if (reportData
!= null)
168 }//GEN-LAST:event_buttonApplyActionPerformed
169 private static final String REPORT_SAVED_SUCCESSFULLY
= "Report saved successfully";
170 private static final String ERROR_SAVING_REPORT
= "Error saving report";
173 * @param args the command line arguments
175 public static void main(String args
[]) {
176 /* Set the Nimbus look and feel */
177 //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
178 /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
179 * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
182 for (javax
.swing
.UIManager
.LookAndFeelInfo info
: javax
.swing
.UIManager
.getInstalledLookAndFeels()) {
183 if ("Nimbus".equals(info
.getName())) {
184 javax
.swing
.UIManager
.setLookAndFeel(info
.getClassName());
188 } catch (ClassNotFoundException ex
) {
189 java
.util
.logging
.Logger
.getLogger(NoticesReportViewDialog
.class.getName()).log(java
.util
.logging
.Level
.SEVERE
, null, ex
);
190 } catch (InstantiationException ex
) {
191 java
.util
.logging
.Logger
.getLogger(NoticesReportViewDialog
.class.getName()).log(java
.util
.logging
.Level
.SEVERE
, null, ex
);
192 } catch (IllegalAccessException ex
) {
193 java
.util
.logging
.Logger
.getLogger(NoticesReportViewDialog
.class.getName()).log(java
.util
.logging
.Level
.SEVERE
, null, ex
);
194 } catch (javax
.swing
.UnsupportedLookAndFeelException ex
) {
195 java
.util
.logging
.Logger
.getLogger(NoticesReportViewDialog
.class.getName()).log(java
.util
.logging
.Level
.SEVERE
, null, ex
);
199 /* Create and display the dialog */
200 java
.awt
.EventQueue
.invokeLater(new Runnable() {
202 NoticesReportViewDialog dialog
= new NoticesReportViewDialog(new javax
.swing
.JFrame(), true);
203 dialog
.addWindowListener(new java
.awt
.event
.WindowAdapter() {
205 public void windowClosing(java
.awt
.event
.WindowEvent e
) {
209 dialog
.setVisible(true);
214 // Variables declaration - do not modify//GEN-BEGIN:variables
215 private javax
.swing
.JButton buttonApply
;
216 private javax
.swing
.JCheckBox checkFilterByClient
;
217 private javax
.swing
.JComboBox
<DBItem
> comboClients
;
218 private javax
.swing
.JScrollPane jScrollPane2
;
219 private javax
.swing
.JLabel labelReportTitle
;
220 private javax
.swing
.JMenuItem menuExportCSV
;
221 private javax
.swing
.JPopupMenu popMenu
;
222 private javax
.swing
.JTable tableReport
;
223 // End of variables declaration//GEN-END:variables
225 public void setupReportTable(int reportNum
, String title
, String
[] columns
,
226 ArrayList
<Object
> data
) {
227 currentReport
= reportNum
;
229 reportCols
= columns
;
231 DefaultTableModel mdl
= new DefaultTableModel (columns
, 0) {
233 public boolean isCellEditable (int row
, int col
) {
237 tableReport
.setModel(mdl
);
239 labelReportTitle
.setText(title
);
243 private void populateReport () {
244 DefaultTableModel mdl
= (DefaultTableModel
)tableReport
.getModel();
246 for (int i
= 0; i
< reportData
.size(); i
+= reportCols
.length
) {
247 Object
[] row
= new Object
[reportCols
.length
];
248 for (int j
= 0; j
< reportCols
.length
; j
++)
249 row
[j
] = reportData
.get(i
+j
);
252 // resize the column widths to content size
253 for (int i
= 0; i
< tableReport
.getColumnCount(); i
++) {
255 TableColumn clm
= tableReport
.getColumnModel().getColumn (i
);
256 int preferredWidth
= clm
.getMinWidth()+10;
259 for (int r
= 0; r
< tableReport
.getRowCount(); r
++) {
260 TableCellRenderer rend
= tableReport
.getCellRenderer(r
, i
);
261 Component c
= tableReport
.prepareRenderer(rend
, r
, i
);
262 int width
= c
.getPreferredSize().width
+ tableReport
.getIntercellSpacing().width
;
263 preferredWidth
= Math
.max (preferredWidth
, width
+10);
264 if (preferredWidth
>= maxWidth
)
266 preferredWidth
= maxWidth
;
270 clm
.setPreferredWidth(Math
.max(minWidth
, preferredWidth
));
274 private void populateClients() {
275 ArrayList
<Object
> clients
= Utility
.getClientsNameAndId();
276 if (clients
== null) return;
277 for (int i
= 0; i
< clients
.size(); i
+= 2) {
278 comboClients
.addItem (new DBItem ((int)clients
.get(i
),
279 (String
)clients
.get(i
+1)));