PageRenderTime 56ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 0ms

/src/mpv5/ui/panels/JournalPanel.java

http://mp-rechnungs-und-kundenverwaltung.googlecode.com/
Java | 1223 lines | 1035 code | 134 blank | 54 comment | 108 complexity | d433f5dba6b2624597f503a1ca595a41 MD5 | raw file
Possible License(s): LGPL-3.0, Apache-2.0, GPL-3.0, GPL-2.0, AGPL-3.0, JSON, BSD-3-Clause 
    

  1. /*
    2. 

  2.  *  This file is part of YaBS.
    3. 

  3.  *
    4. 

  4.  *      YaBS is free software: you can redistribute it and/or modify
    5. 

  5.  *      it under the terms of the GNU General Public License as published by
    6. 

  6.  *      the Free Software Foundation, either version 3 of the License, or
    7. 

  7.  *      (at your option) any later version.
    8. 

  8.  *
    9. 

  9.  *      YaBS is distributed in the hope that it will be useful,
    10. 

  10.  *      but WITHOUT ANY WARRANTY; without even the implied warranty of
    11. 

  11.  *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    12. 

  12.  *      GNU General Public License for more details.
    13. 

  13.  *
    14. 

  14.  *      You should have received a copy of the GNU General Public License
    15. 

  15.  *      along with YaBS.  If not, see <http://www.gnu.org/licenses/>.
    16. 

  16.  */
    17. 

  17. /*
    18. 

  18.  * HistoryPanel.java
    19. 

  19.  *
    20. 

  20.  * Created on 30.03.2009, 12:05:51
    21. 

  21.  */
    22. 

  22. package mpv5.ui.panels;
    23. 

  23. 

  24. import enoa.handler.TableHandler;
    25. 

  25. import enoa.handler.TemplateHandler;
    26. 

  26. import java.awt.Component;
    27. 

  27. import java.awt.event.ActionEvent;
    28. 

  28. import java.awt.event.ActionListener;
    29. 

  29. import java.util.ArrayList;
    30. 

  30. import java.util.Arrays;
    31. 

  31. import java.util.Date;
    32. 

  32. import java.util.HashMap;
    33. 

  33. import java.util.List;
    34. 

  34. import javax.swing.DefaultComboBoxModel;
    35. 

  35. import javax.swing.DefaultListModel;
    36. 

  36. import javax.swing.JComponent;
    37. 

  37. import javax.swing.SwingUtilities;
    38. 

  38. import javax.swing.table.DefaultTableModel;
    39. 

  39. import javax.swing.table.TableCellRenderer;
    40. 

  40. import javax.swing.table.TableModel;
    41. 

  41. import mpv5.db.common.Context;
    42. 

  42. 

  43. import mpv5.db.common.DatabaseObject;
    44. 

  44. import mpv5.db.common.DatabaseObject.Entity;
    45. 

  45. import mpv5.db.common.NodataFoundException;
    46. 

  46. import mpv5.db.common.QueryCriteria2;
    47. 

  47. import mpv5.db.common.QueryHandler;
    48. 

  48. import mpv5.db.common.QueryParameter;
    49. 

  49. import mpv5.db.common.Templateable;
    50. 

  50. import mpv5.db.objects.Account;
    51. 

  51. import mpv5.db.objects.Contact;
    52. 

  52. import mpv5.db.objects.Expense;
    53. 

  53. import mpv5.globals.Headers;
    54. 

  54. import mpv5.db.objects.Group;
    55. 

  55. import mpv5.db.objects.Item;
    56. 

  56. import mpv5.db.objects.Revenue;
    57. 

  57. import mpv5.db.objects.Template;
    58. 

  58. import mpv5.db.objects.User;
    59. 

  59. import mpv5.globals.Constants;
    60. 

  60. import mpv5.globals.Messages;
    61. 

  61. import mpv5.logging.Log;
    62. 

  62. import mpv5.ui.beans.MPCombobox;
    63. 

  63. import mpv5.ui.dialogs.DialogForFile;
    64. 

  64. import mpv5.ui.dialogs.Popup;
    65. 

  65. import mpv5.ui.misc.MPTable;
    66. 

  66. import mpv5.ui.popups.TablePopUp;
    67. 

  67. import mpv5.utils.arrays.ArrayUtilities;
    68. 

  68. import mpv5.utils.date.DateConverter;
    69. 

  69. import mpv5.utils.date.vTimeframe;
    70. 

  70. import mpv5.utils.export.DTAFile;
    71. 

  71. import mpv5.utils.export.Export;
    72. 

  72. import mpv5.utils.jobs.Job;
    73. 

  73. import mpv5.utils.jobs.Waitable;
    74. 

  74. import mpv5.utils.models.MPComboBoxModelItem;
    75. 

  75. import mpv5.utils.models.MPTableModel;
    76. 

  76. import mpv5.utils.models.MPTreeModel;
    77. 

  77. import mpv5.utils.tables.ExcelAdapter;
    78. 

  78. import mpv5.utils.tables.TableFormat;
    79. 

  79. import mpv5.utils.text.TypeConversion;
    80. 

  80. import mpv5.ui.misc.TableViewPersistenceHandler;
    81. 

  81. import mpv5.utils.numberformat.FormatNumber;
    82. 

  82. 

  83. /**
    84. 

  84.  *
    85. 

  85.  * FIXME unpaid??
    86. 

  86.  */
    87. 

  87. public class JournalPanel extends javax.swing.JPanel implements ListPanel {
    88. 

  88. 

  89.     private static JournalPanel t;
    90. 

  90.     private static final long serialVersionUID = 1L;
    91. 

  91.     private java.util.ResourceBundle bundle = mpv5.i18n.LanguageManager.getBundle();
    92. 

  92. 

  93.     public static JComponent instanceOf() {
    94. 

  94.         if (t == null) {
    95. 

  95.             t = new JournalPanel();
    96. 

  96.         }
    97. 

  97.         return t;
    98. 

  98.     }
    99. 

  99.     private Contact dataOwner;
    100. 

  100.     private Template journalOrContactTemplate;
    101. 

  101. 

  102.     /**
    103. 

  103.      * Creates new form HistoryPanel
    104. 

  104.      */
    105. 

  105.     public JournalPanel() {
    106. 

  106.         initComponents();
    107. 

  107.         setName("journalpanel");
    108. 

  108.         new ExcelAdapter(jTable1);
    109. 

  109.         setPopup();
    110. 

  110.         jPanel5.setEnabled(false);
    111. 

  111.         jTabbedPane1.removeTabAt(0);
    112. 

  112.         jLabel3.setEnabled(false);
    113. 

  113.         jLabel4.setEnabled(false);
    114. 

  114.         jLabel4.setText("");
    115. 

  115.         jTabbedPane1.setSelectedComponent(jPanel4);
    116. 

  116.         validate();
    117. 

  117.         timeframeChooser1.setTime(new vTimeframe(DateConverter.getDate(DateConverter.getYear()), new Date()));
    118. 

  118.         bydateend.setSelected(User.getCurrentUser().getProperties().getProperty(this, bydateend, Boolean.FALSE));
    119. 

  119.         expbydateend.setSelected(User.getCurrentUser().getProperties().getProperty(this, expbydateend, Boolean.FALSE));
    120. 

  120.         groups.setSearchEnabled(true);
    121. 

  121.         groups.setContext(Context.getGroup());
    122. 

  122.         groups.triggerSearch();
    123. 

  123.         users.setSearchEnabled(true);
    124. 

  124.         users.setContext(Context.getUser());
    125. 

  125.         users.setModel();
    126. 

  126. 

  127.         try {
    128. 

  128.             DefaultListModel al = new DefaultListModel();
    129. 

  129.             ArrayList<DatabaseObject> accounts = DatabaseObject.getObjects(Context.getAccounts());
    130. 

  130.             for (int i = 0; i < accounts.size(); i++) {
    131. 

  131.                 DatabaseObject databaseObject = accounts.get(i);
    132. 

  132.                 al.addElement((Account) databaseObject);
    133. 

  133.             }
    134. 

  134.             jList1.setModel(al);
    135. 

  135.         } catch (NodataFoundException nodataFoundException) {
    136. 

  136.             Log.Debug(this, nodataFoundException.getMessage());
    137. 

  137.         }
    138. 

  138. 

  139.         statusc.getComboBox().setModel(new DefaultComboBoxModel(new Object[]{Messages.ALL, Messages.STATUS_PAID, Messages.STATUS_UNPAID, Messages.STATUS_CANCELLED}));
    140. 

  140.         prinitingComboBox1.init(jTable1);
    141. 

  141.         refresh(null, null);
    142. 

  142.         jButton4.setEnabled(false);
    143. 

  143.         loadTemplate();
    144. 

  144.         ((MPTable) jTable1).setPersistanceHandler(new TableViewPersistenceHandler((MPTable) jTable1, this));
    145. 

  145. 

  146.     }
    147. 

  147. 

  148.     public JournalPanel(Contact dataOwner) {
    149. 

  149.         initComponents();
    150. 

  150.         setPopup();
    151. 

  151.         jLabel4.setText(dataOwner.__getCname());
    152. 

  152.         timeframeChooser1.setTime(new vTimeframe(DateConverter.getDate(DateConverter.getYear()), new Date()));
    153. 

  153.         prinitingComboBox1.init(jTable1);
    154. 

  154. 

  155.         this.dataOwner = dataOwner;
    156. 

  156.         groups.setSearchEnabled(true);
    157. 

  157.         groups.setContext(Context.getGroup());
    158. 

  158.         groups.triggerSearch();
    159. 

  159. 

  160.         try {
    161. 

  161.             DefaultListModel al = new DefaultListModel();
    162. 

  162.             ArrayList<DatabaseObject> accounts = DatabaseObject.getObjects(Context.getAccounts());
    163. 

  163.             for (int i = 0; i < accounts.size(); i++) {
    164. 

  164.                 DatabaseObject databaseObject = accounts.get(i);
    165. 

  165.                 al.addElement((Account) databaseObject);
    166. 

  166.             }
    167. 

  167.             jList1.setModel(al);
    168. 

  168.         } catch (NodataFoundException nodataFoundException) {
    169. 

  169.             Log.Debug(this, nodataFoundException.getMessage());
    170. 

  170.         }
    171. 

  171. 

  172.         statusc.getComboBox().setModel(new DefaultComboBoxModel(new Object[]{Messages.ALL, Messages.STATUS_PAID, Messages.STATUS_UNPAID}));
    173. 

  173. 

  174.         refresh(null, null);
    175. 

  175. 

  176.         jTree1.setCellRenderer(MPTreeModel.getRenderer());
    177. 

  177.         jTree1.setModel(new MPTreeModel(dataOwner, null));
    178. 

  178.         jTree1.addMouseListener(MPTreeModel.getDefaultTreeListener(jTree1));
    179. 

  179.         prinitingComboBox1.init(jTable1);
    180. 

  180. //        TreeFormat.expandTree(jTree1);
    181. 

  181.         loadTemplate();
    182. 

  182.         ((MPTable) jTable1).setPersistanceHandler(new TableViewPersistenceHandler((MPTable) jTable1, this));
    183. 

  183. 

  184.     }
    185. 

  185. 

  186.     /**
    187. 

  187.      * This method is called from within the constructor to initialize the form.
    188. 

  188.      * WARNING: Do NOT modify this code. The content of this method is always
    189. 

  189.      * regenerated by the Form Editor.
    190. 

  190.      */
    191. 

  191.     @SuppressWarnings("unchecked")
    192. 

  192.     // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    193. 

  193.     private void initComponents() {
    194. 

  194. 

  195.         buttonGroup1 = new javax.swing.ButtonGroup();
    196. 

  196.         buttonGroup2 = new javax.swing.ButtonGroup();
    197. 

  197.         jPanel1 = new javax.swing.JPanel();
    198. 

  198.         jTabbedPane1 = new javax.swing.JTabbedPane();
    199. 

  199.         jPanel5 = new javax.swing.JPanel();
    200. 

  200.         jScrollPane2 = new javax.swing.JScrollPane();
    201. 

  201.         jTree1 = new javax.swing.JTree();
    202. 

  202.         jPanel10 = new javax.swing.JPanel();
    203. 

  203.         filternone = new javax.swing.JRadioButton();
    204. 

  204.         filterinvoice = new javax.swing.JRadioButton();
    205. 

  205.         filterorders = new javax.swing.JRadioButton();
    206. 

  206.         filteroffers = new javax.swing.JRadioButton();
    207. 

  207.         jPanel4 = new javax.swing.JPanel();
    208. 

  208.         jScrollPane1 = new javax.swing.JScrollPane();
    209. 

  209.         jTable1 = new  mpv5.ui.misc.MPTable(this) {
    210. 

  210.             private static final long serialVersionUID = 1L;
    211. 

  211.             public Component prepareRenderer(TableCellRenderer renderer,
    212. 

  212.                 int rowIndex, int vColIndex) {
    213. 

  213.                 Component c = super.prepareRenderer(renderer, rowIndex, vColIndex);
    214. 

  214.                 if (c instanceof JComponent) {
    215. 

  215.                     JComponent jc = (JComponent)c;
    216. 

  216.                     jc.setToolTipText(String.valueOf(getValueAt(rowIndex, vColIndex)));
    217. 

  217.                 }
    218. 

  218.                 return c;
    219. 

  219.             }
    220. 

  220.         };
    221. 

  221.         jPanel2 = new javax.swing.JPanel();
    222. 

  222.         jPanel7 = new javax.swing.JPanel();
    223. 

  223.         bydateend = new javax.swing.JCheckBox();
    224. 

  224.         groups = new mpv5.ui.beans.MPCombobox();
    225. 

  225.         jLabel8 = new javax.swing.JLabel();
    226. 

  226.         statusc = new mpv5.ui.beans.MPCombobox();
    227. 

  227.         includechildgroups = new javax.swing.JCheckBox();
    228. 

  228.         jLabel2 = new javax.swing.JLabel();
    229. 

  229.         users = new mpv5.ui.beans.MPCombobox();
    230. 

  230.         jLabel6 = new javax.swing.JLabel();
    231. 

  231.         expbydateend = new javax.swing.JCheckBox();
    232. 

  232.         jPanel8 = new javax.swing.JPanel();
    233. 

  233.         jLabel3 = new javax.swing.JLabel();
    234. 

  234.         jLabel5 = new javax.swing.JLabel();
    235. 

  235.         jLabel4 = new javax.swing.JLabel();
    236. 

  236.         timeframeChooser1 = new mpv5.ui.beans.TimeframeChooser();
    237. 

  237.         jPanel6 = new javax.swing.JPanel();
    238. 

  238.         jScrollPane3 = new javax.swing.JScrollPane();
    239. 

  239.         jList1 = new javax.swing.JList();
    240. 

  240.         jButton1 = new javax.swing.JButton();
    241. 

  241.         count = new javax.swing.JLabel();
    242. 

  242.         jPanel3 = new javax.swing.JPanel();
    243. 

  243.         jButton4 = new javax.swing.JButton();
    244. 

  244.         prinitingComboBox1 = new mpv5.ui.beans.PrinitingComboBox();
    245. 

  245.         revenueNetto = new mpv5.ui.beans.LabeledTextField();
    246. 

  246.         volumeNetto = new mpv5.ui.beans.LabeledTextField();
    247. 

  247.         volumeBrutto = new mpv5.ui.beans.LabeledTextField();
    248. 

  248.         taxVolume = new mpv5.ui.beans.LabeledTextField();
    249. 

  249.         jPanel9 = new javax.swing.JPanel();
    250. 

  250. 

  251.         setName("Form"); // NOI18N
    252. 

  252. 

  253.         java.util.ResourceBundle bundle = mpv5.i18n.LanguageManager.getBundle(); // NOI18N
    254. 

  254.         jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(bundle.getString("JournalPanel.jPanel1.border.title"))); // NOI18N
    255. 

  255.         jPanel1.setName("jPanel1"); // NOI18N
    256. 

  256. 

  257.         jTabbedPane1.setName("jTabbedPane1"); // NOI18N
    258. 

  258. 

  259.         jPanel5.setName("jPanel5"); // NOI18N
    260. 

  260.         jPanel5.setLayout(new java.awt.BorderLayout());
    261. 

  261. 

  262.         jScrollPane2.setName("jScrollPane2"); // NOI18N
    263. 

  263. 

  264.         javax.swing.tree.DefaultMutableTreeNode treeNode1 = new javax.swing.tree.DefaultMutableTreeNode("root");
    265. 

  265.         jTree1.setModel(new javax.swing.tree.DefaultTreeModel(treeNode1));
    266. 

  266.         jTree1.setName("jTree1"); // NOI18N
    267. 

  267.         jScrollPane2.setViewportView(jTree1);
    268. 

  268. 

  269.         jPanel5.add(jScrollPane2, java.awt.BorderLayout.CENTER);
    270. 

  270. 

  271.         jPanel10.setBorder(javax.swing.BorderFactory.createTitledBorder(bundle.getString("JournalPanel.jPanel10.border.title"))); // NOI18N
    272. 

  272.         jPanel10.setName("jPanel10"); // NOI18N
    273. 

  273.         jPanel10.setPreferredSize(new java.awt.Dimension(874, 45));
    274. 

  274.         jPanel10.setLayout(new javax.swing.BoxLayout(jPanel10, javax.swing.BoxLayout.LINE_AXIS));
    275. 

  275. 

  276.         buttonGroup2.add(filternone);
    277. 

  277.         filternone.setSelected(true);
    278. 

  278.         filternone.setText(bundle.getString("JournalPanel.filternone.text")); // NOI18N
    279. 

  279.         filternone.setName("filternone"); // NOI18N
    280. 

  280.         filternone.addItemListener(new java.awt.event.ItemListener() {
    281. 

  281.             public void itemStateChanged(java.awt.event.ItemEvent evt) {
    282. 

  282.                 filternoneItemStateChanged(evt);
    283. 

  283.             }
    284. 

  284.         });
    285. 

  285.         jPanel10.add(filternone);
    286. 

  286. 

  287.         buttonGroup2.add(filterinvoice);
    288. 

  288.         filterinvoice.setText(bundle.getString("JournalPanel.filterinvoice.text")); // NOI18N
    289. 

  289.         filterinvoice.setName("filterinvoice"); // NOI18N
    290. 

  290.         filterinvoice.addItemListener(new java.awt.event.ItemListener() {
    291. 

  291.             public void itemStateChanged(java.awt.event.ItemEvent evt) {
    292. 

  292.                 filterinvoiceItemStateChanged(evt);
    293. 

  293.             }
    294. 

  294.         });
    295. 

  295.         jPanel10.add(filterinvoice);
    296. 

  296. 

  297.         buttonGroup2.add(filterorders);
    298. 

  298.         filterorders.setText(bundle.getString("JournalPanel.filterorders.text")); // NOI18N
    299. 

  299.         filterorders.setName("filterorders"); // NOI18N
    300. 

  300.         filterorders.addItemListener(new java.awt.event.ItemListener() {
    301. 

  301.             public void itemStateChanged(java.awt.event.ItemEvent evt) {
    302. 

  302.                 filterordersItemStateChanged(evt);
    303. 

  303.             }
    304. 

  304.         });
    305. 

  305.         jPanel10.add(filterorders);
    306. 

  306. 

  307.         buttonGroup2.add(filteroffers);
    308. 

  308.         filteroffers.setText(bundle.getString("JournalPanel.filteroffers.text")); // NOI18N
    309. 

  309.         filteroffers.setName("filteroffers"); // NOI18N
    310. 

  310.         filteroffers.addItemListener(new java.awt.event.ItemListener() {
    311. 

  311.             public void itemStateChanged(java.awt.event.ItemEvent evt) {
    312. 

  312.                 filteroffersItemStateChanged(evt);
    313. 

  313.             }
    314. 

  314.         });
    315. 

  315.         jPanel10.add(filteroffers);
    316. 

  316. 

  317.         jPanel5.add(jPanel10, java.awt.BorderLayout.NORTH);
    318. 

  318. 

  319.         jTabbedPane1.addTab(bundle.getString("JournalPanel.jPanel5.TabConstraints.tabTitle"), jPanel5); // NOI18N
    320. 

  320. 

  321.         jPanel4.setName("jPanel4"); // NOI18N
    322. 

  322.         jPanel4.setLayout(new java.awt.BorderLayout(2, 0));
    323. 

  323. 

  324.         jScrollPane1.setName("jScrollPane1"); // NOI18N
    325. 

  325.         jScrollPane1.setPreferredSize(new java.awt.Dimension(452, 430));
    326. 

  326. 

  327.         jTable1.setAutoCreateRowSorter(true);
    328. 

  328.         jTable1.setModel(new javax.swing.table.DefaultTableModel(
    329. 

  329.             new Object [][] {
    330. 

  330. 

  331.             },
    332. 

  332.             new String [] {
    333. 

  333. 

  334.             }
    335. 

  335.         ));
    336. 

  336.         jTable1.setFillsViewportHeight(true);
    337. 

  337.         jTable1.setName("jTable1"); // NOI18N
    338. 

  338.         jTable1.setSelectionMode(javax.swing.ListSelectionModel.MULTIPLE_INTERVAL_SELECTION);
    339. 

  339.         jTable1.addMouseListener(new java.awt.event.MouseAdapter() {
    340. 

  340.             public void mouseClicked(java.awt.event.MouseEvent evt) {
    341. 

  341.                 jTable1MouseClicked(evt);
    342. 

  342.             }
    343. 

  343.         });
    344. 

  344.         jScrollPane1.setViewportView(jTable1);
    345. 

  345. 

  346.         jPanel4.add(jScrollPane1, java.awt.BorderLayout.CENTER);
    347. 

  347. 

  348.         jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(bundle.getString("JournalPanel.jPanel2.border.title"))); // NOI18N
    349. 

  349.         jPanel2.setName("jPanel2"); // NOI18N
    350. 

  350.         jPanel2.setPreferredSize(new java.awt.Dimension(734, 200));
    351. 

  351.         jPanel2.setRequestFocusEnabled(false);
    352. 

  352. 

  353.         jPanel7.setBackground(new java.awt.Color(255, 255, 255));
    354. 

  354.         jPanel7.setBorder(javax.swing.BorderFactory.createEtchedBorder());
    355. 

  355.         jPanel7.setName("jPanel7"); // NOI18N
    356. 

  356. 

  357.         bydateend.setBackground(new java.awt.Color(255, 255, 255));
    358. 

  358.         bydateend.setFont(bydateend.getFont());
    359. 

  359.         bydateend.setText(bundle.getString("JournalPanel.bydateend.text")); // NOI18N
    360. 

  360.         bydateend.setName("bydateend"); // NOI18N
    361. 

  361.         bydateend.addItemListener(new java.awt.event.ItemListener() {
    362. 

  362.             public void itemStateChanged(java.awt.event.ItemEvent evt) {
    363. 

  363.                 bydateendItemStateChanged(evt);
    364. 

  364.             }
    365. 

  365.         });
    366. 

  366. 

  367.         groups.setFont(groups.getFont());
    368. 

  368.         groups.setName("groups"); // NOI18N
    369. 

  369. 

  370.         jLabel8.setFont(jLabel8.getFont());
    371. 

  371.         jLabel8.setText(bundle.getString("JournalPanel.jLabel8.text_1")); // NOI18N
    372. 

  372.         jLabel8.setName("jLabel8"); // NOI18N
    373. 

  373.         jLabel8.setPreferredSize(new java.awt.Dimension(150, 21));
    374. 

  374. 

  375.         statusc.setFont(statusc.getFont());
    376. 

  376.         statusc.setName("statusc"); // NOI18N
    377. 

  377. 

  378.         includechildgroups.setBackground(new java.awt.Color(255, 255, 255));
    379. 

  379.         includechildgroups.setFont(includechildgroups.getFont());
    380. 

  380.         includechildgroups.setSelected(true);
    381. 

  381.         includechildgroups.setText(bundle.getString("JournalPanel.includechildgroups.text")); // NOI18N
    382. 

  382.         includechildgroups.setName("includechildgroups"); // NOI18N
    383. 

  383. 

  384.         jLabel2.setFont(jLabel2.getFont());
    385. 

  385.         jLabel2.setText(bundle.getString("JournalPanel.jLabel2.text")); // NOI18N
    386. 

  386.         jLabel2.setName("jLabel2"); // NOI18N
    387. 

  387.         jLabel2.setPreferredSize(new java.awt.Dimension(150, 21));
    388. 

  388. 

  389.         users.setFont(users.getFont());
    390. 

  390.         users.setName("users"); // NOI18N
    391. 

  391. 

  392.         jLabel6.setFont(jLabel6.getFont());
    393. 

  393.         jLabel6.setText(bundle.getString("JournalPanel.jLabel6.text")); // NOI18N
    394. 

  394.         jLabel6.setName("jLabel6"); // NOI18N
    395. 

  395.         jLabel6.setPreferredSize(new java.awt.Dimension(150, 21));
    396. 

  396. 

  397.         expbydateend.setBackground(new java.awt.Color(255, 255, 255));
    398. 

  398.         expbydateend.setFont(expbydateend.getFont());
    399. 

  399.         expbydateend.setText(bundle.getString("JournalPanel.expbydateend.text")); // NOI18N
    400. 

  400.         expbydateend.setName("expbydateend"); // NOI18N
    401. 

  401.         expbydateend.addItemListener(new java.awt.event.ItemListener() {
    402. 

  402.             public void itemStateChanged(java.awt.event.ItemEvent evt) {
    403. 

  403.                 expbydateendItemStateChanged(evt);
    404. 

  404.             }
    405. 

  405.         });
    406. 

  406. 

  407.         javax.swing.GroupLayout jPanel7Layout = new javax.swing.GroupLayout(jPanel7);
    408. 

  408.         jPanel7.setLayout(jPanel7Layout);
    409. 

  409.         jPanel7Layout.setHorizontalGroup(
    410. 

  410.             jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    411. 

  411.             .addGroup(jPanel7Layout.createSequentialGroup()
    412. 

  412.                 .addContainerGap()
    413. 

  413.                 .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
    414. 

  414.                     .addComponent(jLabel6, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
    415. 

  415.                     .addComponent(jLabel8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
    416. 

  416.                     .addComponent(jLabel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
    417. 

  417.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
    418. 

  418.                 .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    419. 

  419.                     .addComponent(groups, javax.swing.GroupLayout.DEFAULT_SIZE, 258, Short.MAX_VALUE)
    420. 

  420.                     .addComponent(users, javax.swing.GroupLayout.DEFAULT_SIZE, 258, Short.MAX_VALUE)
    421. 

  421.                     .addComponent(statusc, javax.swing.GroupLayout.DEFAULT_SIZE, 258, Short.MAX_VALUE))
    422. 

  422.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
    423. 

  423.                 .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    424. 

  424.                     .addComponent(expbydateend, javax.swing.GroupLayout.PREFERRED_SIZE, 210, javax.swing.GroupLayout.PREFERRED_SIZE)
    425. 

  425.                     .addComponent(bydateend, javax.swing.GroupLayout.PREFERRED_SIZE, 210, javax.swing.GroupLayout.PREFERRED_SIZE)
    426. 

  426.                     .addComponent(includechildgroups, javax.swing.GroupLayout.PREFERRED_SIZE, 210, javax.swing.GroupLayout.PREFERRED_SIZE))
    427. 

  427.                 .addContainerGap())
    428. 

  428.         );
    429. 

  429.         jPanel7Layout.setVerticalGroup(
    430. 

  430.             jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    431. 

  431.             .addGroup(jPanel7Layout.createSequentialGroup()
    432. 

  432.                 .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.CENTER)
    433. 

  433.                     .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    434. 

  434.                     .addComponent(groups, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    435. 

  435.                     .addComponent(includechildgroups))
    436. 

  436.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
    437. 

  437.                 .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.CENTER)
    438. 

  438.                     .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    439. 

  439.                     .addComponent(users, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    440. 

  440.                     .addComponent(expbydateend))
    441. 

  441.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
    442. 

  442.                 .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.CENTER)
    443. 

  443.                     .addComponent(bydateend)
    444. 

  444.                     .addComponent(statusc, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    445. 

  445.                     .addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
    446. 

  446.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
    447. 

  447.         );
    448. 

  448. 

  449.         jPanel8.setBackground(new java.awt.Color(255, 255, 255));
    450. 

  450.         jPanel8.setBorder(javax.swing.BorderFactory.createEtchedBorder());
    451. 

  451.         jPanel8.setName("jPanel8"); // NOI18N
    452. 

  452. 

  453.         jLabel3.setFont(jLabel3.getFont());
    454. 

  454.         jLabel3.setText(bundle.getString("JournalPanel.jLabel3.text")); // NOI18N
    455. 

  455.         jLabel3.setName("jLabel3"); // NOI18N
    456. 

  456. 

  457.         jLabel5.setFont(jLabel5.getFont());
    458. 

  458.         jLabel5.setText(bundle.getString("JournalPanel.jLabel5.text")); // NOI18N
    459. 

  459.         jLabel5.setName("jLabel5"); // NOI18N
    460. 

  460. 

  461.         jLabel4.setFont(jLabel4.getFont());
    462. 

  462.         jLabel4.setText(bundle.getString("JournalPanel.jLabel4.text")); // NOI18N
    463. 

  463.         jLabel4.setName("jLabel4"); // NOI18N
    464. 

  464. 

  465.         timeframeChooser1.setBackground(new java.awt.Color(255, 255, 255));
    466. 

  466.         timeframeChooser1.setFont(timeframeChooser1.getFont());
    467. 

  467.         timeframeChooser1.setName("timeframeChooser1"); // NOI18N
    468. 

  468. 

  469.         javax.swing.GroupLayout jPanel8Layout = new javax.swing.GroupLayout(jPanel8);
    470. 

  470.         jPanel8.setLayout(jPanel8Layout);
    471. 

  471.         jPanel8Layout.setHorizontalGroup(
    472. 

  472.             jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    473. 

  473.             .addGroup(jPanel8Layout.createSequentialGroup()
    474. 

  474.                 .addContainerGap()
    475. 

  475.                 .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
    476. 

  476.                     .addComponent(jLabel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
    477. 

  477.                     .addComponent(jLabel5, javax.swing.GroupLayout.DEFAULT_SIZE, 162, Short.MAX_VALUE))
    478. 

  478.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
    479. 

  479.                 .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    480. 

  480.                     .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 269, javax.swing.GroupLayout.PREFERRED_SIZE)
    481. 

  481.                     .addComponent(timeframeChooser1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
    482. 

  482.                 .addContainerGap(134, Short.MAX_VALUE))
    483. 

  483.         );
    484. 

  484.         jPanel8Layout.setVerticalGroup(
    485. 

  485.             jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    486. 

  486.             .addGroup(jPanel8Layout.createSequentialGroup()
    487. 

  487.                 .addContainerGap()
    488. 

  488.                 .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.CENTER)
    489. 

  489.                     .addComponent(jLabel3)
    490. 

  490.                     .addComponent(jLabel4))
    491. 

  491.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
    492. 

  492.                 .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.CENTER)
    493. 

  493.                     .addComponent(timeframeChooser1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    494. 

  494.                     .addComponent(jLabel5))
    495. 

  495.                 .addContainerGap())
    496. 

  496.         );
    497. 

  497. 

  498.         jPanel6.setBorder(javax.swing.BorderFactory.createTitledBorder(bundle.getString("JournalPanel.jPanel6.border.title"))); // NOI18N
    499. 

  499.         jPanel6.setName("jPanel6"); // NOI18N
    500. 

  500.         jPanel6.setLayout(new java.awt.BorderLayout());
    501. 

  501. 

  502.         jScrollPane3.setName("jScrollPane3"); // NOI18N
    503. 

  503. 

  504.         jList1.setFont(jList1.getFont().deriveFont(jList1.getFont().getStyle() | java.awt.Font.BOLD));
    505. 

  505.         jList1.setName("jList1"); // NOI18N
    506. 

  506.         jList1.setSelectionBackground(new java.awt.Color(51, 51, 255));
    507. 

  507.         jScrollPane3.setViewportView(jList1);
    508. 

  508. 

  509.         jPanel6.add(jScrollPane3, java.awt.BorderLayout.CENTER);
    510. 

  510. 

  511.         jButton1.setFont(jButton1.getFont());
    512. 

  512.         jButton1.setText(bundle.getString("JournalPanel.jButton1.text")); // NOI18N
    513. 

  513.         jButton1.setName("jButton1"); // NOI18N
    514. 

  514.         jButton1.addActionListener(new java.awt.event.ActionListener() {
    515. 

  515.             public void actionPerformed(java.awt.event.ActionEvent evt) {
    516. 

  516.                 jButton1ActionPerformed(evt);
    517. 

  517.             }
    518. 

  518.         });
    519. 

  519. 

  520.         count.setFont(count.getFont().deriveFont(count.getFont().getStyle() | java.awt.Font.BOLD));
    521. 

  521.         count.setForeground(new java.awt.Color(102, 102, 102));
    522. 

  522.         count.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
    523. 

  523.         count.setText(bundle.getString("JournalPanel.count.text")); // NOI18N
    524. 

  524.         count.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
    525. 

  525.         count.setName("count"); // NOI18N
    526. 

  526. 

  527.         javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
    528. 

  528.         jPanel2.setLayout(jPanel2Layout);
    529. 

  529.         jPanel2Layout.setHorizontalGroup(
    530. 

  530.             jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    531. 

  531.             .addGroup(jPanel2Layout.createSequentialGroup()
    532. 

  532.                 .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
    533. 

  533.                     .addComponent(jPanel7, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
    534. 

  534.                     .addComponent(jPanel8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
    535. 

  535.                 .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    536. 

  536.                     .addGroup(jPanel2Layout.createSequentialGroup()
    537. 

  537.                         .addGap(100, 100, 100)
    538. 

  538.                         .addComponent(count, javax.swing.GroupLayout.PREFERRED_SIZE, 67, javax.swing.GroupLayout.PREFERRED_SIZE))
    539. 

  539.                     .addGroup(jPanel2Layout.createSequentialGroup()
    540. 

  540.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
    541. 

  541.                         .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE))
    542. 

  542.                     .addGroup(jPanel2Layout.createSequentialGroup()
    543. 

  543.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
    544. 

  544.                         .addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, 212, javax.swing.GroupLayout.PREFERRED_SIZE)))
    545. 

  545.                 .addContainerGap())
    546. 

  546.         );
    547. 

  547.         jPanel2Layout.setVerticalGroup(
    548. 

  548.             jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    549. 

  549.             .addGroup(jPanel2Layout.createSequentialGroup()
    550. 

  550.                 .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
    551. 

  551.                     .addGroup(jPanel2Layout.createSequentialGroup()
    552. 

  552.                         .addComponent(jPanel6, 0, 0, Short.MAX_VALUE)
    553. 

  553.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
    554. 

  554.                         .addComponent(jButton1))
    555. 

  555.                     .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel2Layout.createSequentialGroup()
    556. 

  556.                         .addComponent(jPanel8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    557. 

  557.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
    558. 

  558.                         .addComponent(jPanel7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
    559. 

  559.                 .addGap(11, 11, 11)
    560. 

  560.                 .addComponent(count, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE))
    561. 

  561.         );
    562. 

  562. 

  563.         jPanel4.add(jPanel2, java.awt.BorderLayout.NORTH);
    564. 

  564. 

  565.         jPanel3.setName("jPanel3"); // NOI18N
    566. 

  566. 

  567.         jButton4.setText(bundle.getString("JournalPanel.jButton4.text")); // NOI18N
    568. 

  568.         jButton4.setName("jButton4"); // NOI18N
    569. 

  569.         jButton4.addActionListener(new java.awt.event.ActionListener() {
    570. 

  570.             public void actionPerformed(java.awt.event.ActionEvent evt) {
    571. 

  571.                 jButton4ActionPerformed(evt);
    572. 

  572.             }
    573. 

  573.         });
    574. 

  574. 

  575.         prinitingComboBox1.setName("prinitingComboBox1"); // NOI18N
    576. 

  576. 

  577.         revenueNetto.set_Label(bundle.getString("JournalPanel.revenueNetto._Label")); // NOI18N
    578. 

  578.         revenueNetto.setName("revenueNetto"); // NOI18N
    579. 

  579. 

  580.         volumeNetto.set_Label(bundle.getString("JournalPanel.volumeNetto._Label")); // NOI18N
    581. 

  581.         volumeNetto.setName("volumeNetto"); // NOI18N
    582. 

  582. 

  583.         volumeBrutto.set_Label(bundle.getString("JournalPanel.volumeBrutto._Label")); // NOI18N
    584. 

  584.         volumeBrutto.setName("volumeBrutto"); // NOI18N
    585. 

  585. 

  586.         taxVolume.set_Label(bundle.getString("JournalPanel.taxVolume._Label")); // NOI18N
    587. 

  587.         taxVolume.setName("taxVolume"); // NOI18N
    588. 

  588. 

  589.         javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
    590. 

  590.         jPanel3.setLayout(jPanel3Layout);
    591. 

  591.         jPanel3Layout.setHorizontalGroup(
    592. 

  592.             jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    593. 

  593.             .addGroup(jPanel3Layout.createSequentialGroup()
    594. 

  594.                 .addContainerGap()
    595. 

  595.                 .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    596. 

  596.                     .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
    597. 

  597.                         .addComponent(volumeNetto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    598. 

  598.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
    599. 

  599.                         .addComponent(revenueNetto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
    600. 

  600.                     .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
    601. 

  601.                         .addComponent(prinitingComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 196, javax.swing.GroupLayout.PREFERRED_SIZE)
    602. 

  602.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
    603. 

  603.                         .addComponent(jButton4)
    604. 

  604.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 145, Short.MAX_VALUE)
    605. 

  605.                         .addComponent(volumeBrutto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    606. 

  606.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
    607. 

  607.                         .addComponent(taxVolume, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
    608. 

  608.                 .addContainerGap())
    609. 

  609.         );
    610. 

  610.         jPanel3Layout.setVerticalGroup(
    611. 

  611.             jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    612. 

  612.             .addGroup(jPanel3Layout.createSequentialGroup()
    613. 

  613.                 .addContainerGap()
    614. 

  614.                 .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.CENTER)
    615. 

  615.                     .addComponent(volumeNetto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    616. 

  616.                     .addComponent(revenueNetto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
    617. 

  617.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
    618. 

  618.                 .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.CENTER)
    619. 

  619.                     .addComponent(taxVolume, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    620. 

  620.                     .addComponent(volumeBrutto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    621. 

  621.                     .addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
    622. 

  622.                     .addComponent(prinitingComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 19, javax.swing.GroupLayout.PREFERRED_SIZE))
    623. 

  623.                 .addContainerGap())
    624. 

  624.         );
    625. 

  625. 

  626.         jPanel4.add(jPanel3, java.awt.BorderLayout.SOUTH);
    627. 

  627. 

  628.         jTabbedPane1.addTab(bundle.getString("JournalPanel.jPanel4.TabConstraints.tabTitle"), jPanel4); // NOI18N
    629. 

  629. 

  630.         jPanel9.setName("jPanel9"); // NOI18N
    631. 

  631. 

  632.         javax.swing.GroupLayout jPanel9Layout = new javax.swing.GroupLayout(jPanel9);
    633. 

  633.         jPanel9.setLayout(jPanel9Layout);
    634. 

  634.         jPanel9Layout.setHorizontalGroup(
    635. 

  635.             jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    636. 

  636.             .addGap(0, 874, Short.MAX_VALUE)
    637. 

  637.         );
    638. 

  638.         jPanel9Layout.setVerticalGroup(
    639. 

  639.             jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    640. 

  640.             .addGap(0, 297, Short.MAX_VALUE)
    641. 

  641.         );
    642. 

  642. 

  643.         jTabbedPane1.addTab(bundle.getString("JournalPanel.jPanel9.TabConstraints.tabTitle"), jPanel9); // NOI18N
    644. 

  644. 

  645.         javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
    646. 

  646.         jPanel1.setLayout(jPanel1Layout);
    647. 

  647.         jPanel1Layout.setHorizontalGroup(
    648. 

  648.             jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    649. 

  649.             .addComponent(jTabbedPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 879, Short.MAX_VALUE)
    650. 

  650.         );
    651. 

  651.         jPanel1Layout.setVerticalGroup(
    652. 

  652.             jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    653. 

  653.             .addComponent(jTabbedPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 325, Short.MAX_VALUE)
    654. 

  654.         );
    655. 

  655. 

  656.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(this);
    657. 

  657.         this.setLayout(layout);
    658. 

  658.         layout.setHorizontalGroup(
    659. 

  659.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    660. 

  660.             .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
    661. 

  661.         );
    662. 

  662.         layout.setVerticalGroup(
    663. 

  663.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
    664. 

  664.             .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
    665. 

  665.         );
    666. 

  666.     }// </editor-fold>//GEN-END:initComponents
    667. 

  667. 

  668.     private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
    669. 

  669.         setData();
    670. 

  670.     }//GEN-LAST:event_jButton1ActionPerformed
    671. 

  671. 

  672.     private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTable1MouseClicked
    673. 

  673.         if (evt.getClickCount() > 1) {
    674. 

  674.             try {
    675. 

  675.                 int index = jTable1.convertRowIndexToModel(jTable1.getSelectedRow());
    676. 

  676.                 DatabaseObject obj = DatabaseObject.getObject((DatabaseObject.Entity<?, ?>) jTable1.getModel().getValueAt(index, 0));
    677. 

  677.                 mpv5.YabsViewProxy.instance().addTab(obj);
    678. 

  678.             } catch (NodataFoundException ex) {
    679. 

  679.                 Log.Debug(ex);
    680. 

  680.             }
    681. 

  681.         }
    682. 

  682.     }//GEN-LAST:event_jTable1MouseClicked
    683. 

  683. 

  684.     private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed
    685. 

  685. 

  686.         preview();
    687. 

  687.     }//GEN-LAST:event_jButton4ActionPerformed
    688. 

  688. 

  689.     private void bydateendItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_bydateendItemStateChanged
    690. 

  690.         User.getCurrentUser().getProperties().changeProperty(this, bydateend, bydateend.isSelected());
    691. 

  691.     }//GEN-LAST:event_bydateendItemStateChanged
    692. 

  692. 

  693.     private void expbydateendItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_expbydateendItemStateChanged
    694. 

  694.         User.getCurrentUser().getProperties().changeProperty(this, expbydateend, expbydateend.isSelected());
    695. 

  695.     }//GEN-LAST:event_expbydateendItemStateChanged
    696. 

  696. 

  697.     private void filterinvoiceItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_filterinvoiceItemStateChanged
    698. 

  698.         filter();
    699. 

  699.     }//GEN-LAST:event_filterinvoiceItemStateChanged
    700. 

  700. 

  701.     private void filterordersItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_filterordersItemStateChanged
    702. 

  702.         filter();
    703. 

  703.     }//GEN-LAST:event_filterordersItemStateChanged
    704. 

  704. 

  705.     private void filteroffersItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_filteroffersItemStateChanged
    706. 

  706.         filter();
    707. 

  707.     }//GEN-LAST:event_filteroffersItemStateChanged
    708. 

  708. 

  709.     private void filternoneItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_filternoneItemStateChanged
    710. 

  710.         filter();
    711. 

  711.     }//GEN-LAST:event_filternoneItemStateChanged
    712. 

  712.     // Variables declaration - do not modify//GEN-BEGIN:variables
    713. 

  713.     private javax.swing.ButtonGroup buttonGroup1;
    714. 

  714.     private javax.swing.ButtonGroup buttonGroup2;
    715. 

  715.     private javax.swing.JCheckBox bydateend;
    716. 

  716.     private javax.swing.JLabel count;
    717. 

  717.     private javax.swing.JCheckBox expbydateend;
    718. 

  718.     private javax.swing.JRadioButton filterinvoice;
    719. 

  719.     private javax.swing.JRadioButton filternone;
    720. 

  720.     private javax.swing.JRadioButton filteroffers;
    721. 

  721.     private javax.swing.JRadioButton filterorders;
    722. 

  722.     private mpv5.ui.beans.MPCombobox groups;
    723. 

  723.     private javax.swing.JCheckBox includechildgroups;
    724. 

  724.     private javax.swing.JButton jButton1;
    725. 

  725.     private javax.swing.JButton jButton4;
    726. 

  726.     private javax.swing.JLabel jLabel2;
    727. 

  727.     private javax.swing.JLabel jLabel3;
    728. 

  728.     private javax.swing.JLabel jLabel4;
    729. 

  729.     private javax.swing.JLabel jLabel5;
    730. 

  730.     private javax.swing.JLabel jLabel6;
    731. 

  731.     private javax.swing.JLabel jLabel8;
    732. 

  732.     private javax.swing.JList jList1;
    733. 

  733.     private javax.swing.JPanel jPanel1;
    734. 

  734.     private javax.swing.JPanel jPanel10;
    735. 

  735.     private javax.swing.JPanel jPanel2;
    736. 

  736.     private javax.swing.JPanel jPanel3;
    737. 

  737.     private javax.swing.JPanel jPanel4;
    738. 

  738.     private javax.swing.JPanel jPanel5;
    739. 

  739.     private javax.swing.JPanel jPanel6;
    740. 

  740.     private javax.swing.JPanel jPanel7;
    741. 

  741.     private javax.swing.JPanel jPanel8;
    742. 

  742.     private javax.swing.JPanel jPanel9;
    743. 

  743.     private javax.swing.JScrollPane jScrollPane1;
    744. 

  744.     private javax.swing.JScrollPane jScrollPane2;
    745. 

  745.     private javax.swing.JScrollPane jScrollPane3;
    746. 

  746.     private javax.swing.JTabbedPane jTabbedPane1;
    747. 

  747.     private javax.swing.JTable jTable1;
    748. 

  748.     private javax.swing.JTree jTree1;
    749. 

  749.     private mpv5.ui.beans.PrinitingComboBox prinitingComboBox1;
    750. 

  750.     private mpv5.ui.beans.LabeledTextField revenueNetto;
    751. 

  751.     private mpv5.ui.beans.MPCombobox statusc;
    752. 

  752.     private mpv5.ui.beans.LabeledTextField taxVolume;
    753. 

  753.     private mpv5.ui.beans.TimeframeChooser timeframeChooser1;
    754. 

  754.     private mpv5.ui.beans.MPCombobox users;
    755. 

  755.     private mpv5.ui.beans.LabeledTextField volumeBrutto;
    756. 

  756.     private mpv5.ui.beans.LabeledTextField volumeNetto;
    757. 

  757.     // End of variables declaration//GEN-END:variables
    758. 

  758. 

  759.     private Object[][] parse(Object[][] data) {
    760. 

  760.         //#entity date group account number type status value
    761. 

  761.         double revenuenet = 0d;
    762. 

  762.         double volumenet = 0d;
    763. 

  763.         double taxvolume = 0d;
    764. 

  764.         double volumebrut = 0d;
    765. 

  765.         Object[][] d = new Object[data.length][16];
    766. 

  766.         try {
    767. 

  767.             for (int i = 0; i < d.length; i++) {
    768. 

  768.                 d[i][1] = data[i][1];
    769. 

  769.                 d[i][2] = data[i][2];
    770. 

  770.                 d[i][3] = data[i][3];
    771. 

  771.                 d[i][4] = data[i][4];
    772. 

  772.                 d[i][5] = data[i][5];
    773. 

  773.                 //d[i][14] = data[i][14];
    774. 

  774.                 d[i][8] = data[i][8];
    775. 

  775.                 d[i][9] = data[i][9];
    776. 

  776.                 d[i][7] = data[i][7];
    777. 

  777.                 d[i][6] = DateConverter.getDefDateString(DateConverter.getDate(data[i][6].toString()));
    778. 

  778. 

  779.                 d[i][0] = data[i][0];
    780. 

  780. 

  781.                 int type = Integer.valueOf(data[i][10].toString());
    782. 

  782.                 if (type == Revenue.TYPE_REVENUE) {
    783. 

  783.                     d[i][10] = Messages.TYPE_REVENUE.toString();
    784. 

  784.                 } else if (type == Expense.TYPE_EXPENSE) {
    785. 

  785.                     d[i][10] = Messages.TYPE_EXPENSE.toString();
    786. 

  786.                 } else {
    787. 

  787.                     d[i][10] = Item.getTypeString(type);
    788. 

  788.                 }
    789. 

  789. 

  790.                 double netVolume = Double.valueOf(data[i][12].toString());
    791. 

  791.                 double taxVal = Double.valueOf(data[i][13].toString());
    792. 

  792.                 double brutVolume = Double.valueOf(data[i][14].toString());
    793. 

  793.                 d[i][11] = Item.getStatusString(Integer.valueOf(data[i][11].toString()));
    794. 

  794. 

  795.                 if (Integer.valueOf(data[i][11].toString()).intValue() == Item.STATUS_PAID) {
    796. 

  796.                     revenuenet += netVolume;
    797. 

  797.                     d[i][15] = "<html><p align=center>" + mpv5.utils.numberformat.FormatNumber.formatDezimal(netVolume);
    798. 

  798.                 } else if (Integer.valueOf(data[i][11].toString()).intValue() == 1000) {
    799. 

  799.                     d[i][15] = "<html><p align=center>" + mpv5.utils.numberformat.FormatNumber.formatDezimal(-1 * netVolume);
    800. 

  800.                     revenuenet -= netVolume;
    801. 

  801.                     d[i][11] = Item.getStatusString(Item.STATUS_PAID);
    802. 

  802.                 } else if (Integer.valueOf(data[i][11].toString()).intValue() == 2000) {
    803. 

  803.                     d[i][15] = "<html><p align=center>" + mpv5.utils.numberformat.FormatNumber.formatDezimal(-1 * netVolume);
    804. 

  804.                     revenuenet -= netVolume;
    805. 

  805.                     d[i][11] = Item.getStatusString(Item.STATUS_IN_PROGRESS);
    806. 

  806.                 } else {
    807. 

  807.                     d[i][15] = "<html><p align=center>" + mpv5.utils.numberformat.FormatNumber.formatDezimal(0d);
    808. 

  808.                 }
    809. 

  809.                 d[i][12] = "<html><p align=center>" + mpv5.utils.numberformat.FormatNumber.formatDezimal(netVolume);
    810. 

  810.                 d[i][13] = "<html><p align=center>" + mpv5.utils.numberformat.FormatNumber.formatDezimal(taxVal);
    811. 

  811.                 d[i][14] = "<html><p align=center>" + mpv5.utils.numberformat.FormatNumber.formatDezimal(brutVolume);
    812. 

  812.                 volumenet += netVolume;
    813. 

  813.                 volumebrut += brutVolume;
    814. 

  814.                 taxvolume += taxVal;
    815. 

  815.             }
    816. 

  816.         } catch (Exception numberFormatException) {
    817. 

  817.             Log.Debug(numberFormatException);
    818. 

  818.             Log.Debug(this, Arrays.asList(data[0]));
    819. 

  819.         }
    820. 

  820. 

  821.         volumeNetto.setText(mpv5.utils.numberformat.FormatNumber.formatDezimal(volumenet));
    822. 

  822.         revenueNetto.setText(mpv5.utils.numberformat.FormatNumber.formatDezimal(revenuenet));
    823. 

  823.         volumeBrutto.setText(mpv5.utils.numberformat.FormatNumber.formatDezimal(volumebrut));
    824. 

  824.         taxVolume.setText(mpv5.utils.numberformat.FormatNumber.formatDezimal(taxvolume));
    825. 

  825. 

  826.         return d;
    827. 

  827.     }
    828. 

  828. 

  829.     private void refresh(final Group forGroup, final User forUser) {
    830. 

  830.         Runnable runnable = new Runnable() {
    831. 

  831. 

  832.             @Override
    833. 

  833.             public void run() {
    834. 

  834. 

  835.                 try {
    836. 

  836.                     QueryCriteria2 itemsParams = new QueryCriteria2();
    837. 

  837.                     Object[][] d = new Object[0][0];
    838. 

  838.                     Object[][] d1 = new Object[0][0];
    839. 

  839.                     Object[][] d2 = new Object[0][0];
    840. 

  840. 

  841.                     if (!includechildgroups.isSelected()) {
    842. 

  842.                         if (forGroup != null && !forGroup.__getCname().equals("")) {
    843. 

  843.                             itemsParams.and(new QueryParameter(Context.getItem(), forGroup.getDbIdentity() + "ids", forGroup.__getIDS(), QueryParameter.EQUALS));
    844. 

  844.                         }
    845. 

  845.                     } else {
    846. 

  846.                         if (forGroup != null && !forGroup.__getCname().equals("")) {
    847. 

  847.                             List<Group> gs = forGroup.getChildGroups();
    848. 

  848.                             QueryParameter[] params = new QueryParameter[gs.size()];
    849. 

  849.                             QueryParameter param1 = (new QueryParameter(Context.getItem(), forGroup.getDbIdentity() + "ids", forGroup.__getIDS(), QueryParameter.EQUALS));
    850. 

  850.                             if (gs.size() >= 1) {
    851. 

  851.                                 for (int i = 0; i < gs.size(); i++) {
    852. 

  852.                                     Group group = gs.get(i);
    853. 

  853.                                     params[i] = (new QueryParameter(Context.getItem(), group.getDbIdentity() + "ids", group.__getIDS(), QueryParameter.EQUALS));
    854. 

  854.                                 }
    855. 

  855.                                 //System.err.println(params);
    856. 

  856.                                 itemsParams.or(param1, params);
    857. 

  857.                             } else {
    858. 

  858.                                 itemsParams.and(param1);
    859. 

  859.                             }
    860. 

  860.                         }
    861. 

  861.                     }
    862. 

  862. 

  863.                     if (forUser != null && !forUser.__getCname().equals("")) {
    864. 

  864.                         itemsParams.and(new QueryParameter(Context.getItem(), "intaddedby", forUser.__getIDS(), QueryParameter.EQUALS));
    865. 

  865.                     }
    866. 

  866. 

  867. 

  868.                     ArrayList<QueryParameter> l = new ArrayList<QueryParameter>();
    869. 

  869. 

  870.                     for (int i = 0; i < jList1.getSelectedValues().length; i++) {
    871. 

  871.                         l.add(new QueryParameter(Context.getItem(), "accountsids", ((Account) jList1.getSelectedValues()[i]).__getIDS(), QueryParameter.EQUALS));
    872. 

  872.                     }
    873. 

  873.                     if (l.size() > 1) {
    874. 

  874.                         itemsParams.or(l);
    875. 

  875.                     } else {
    876. 

  876.                         itemsParams.and(l.toArray(new QueryParameter[0]));
    877. 

  877.                     }
    878. 

  878. 

  879.                     if (dataOwner != null) {
    880. 

  880.                         itemsParams.and(new QueryParameter(dataOwner.getContext(), "ids", dataOwner.__getIDS(), QueryParameter.EQUALS));
    881. 

  881.                     }
    882. 

  882. 

  883.                     boolean additional = true;
    884. 

  884.                     if (statusc.getComboBox().getSelectedItem().equals(Messages.STATUS_PAID)) {
    885. 

  885.                         itemsParams.and(new QueryParameter(Context.getItem(), "intstatus", Item.STATUS_PAID, QueryParameter.EQUALS));
    886. 

  886.                     } else if (statusc.getComboBox().getSelectedItem().equals(Messages.STATUS_UNPAID)) {
    887. 

  887. //                        additional = false;
    888. 

  888.                         itemsParams.or(
    889. 

  889.                                 new QueryParameter(Context.getItem(), "intstatus", Item.STATUS_QUEUED, QueryParameter.EQUALS),
    890. 

  890.                                 new QueryParameter(Context.getItem(), "intstatus", Item.STATUS_PAUSED, QueryParameter.EQUALS),
    891. 

  891.                                 new QueryParameter(Context.getItem(), "intstatus", Item.STATUS_IN_PROGRESS, QueryParameter.EQUALS),
    892. 

  892.                                 new QueryParameter(Context.getItem(), "intstatus", Item.STATUS_FINISHED, QueryParameter.EQUALS));
    893. 

  893.                     } else if (statusc.getComboBox().getSelectedItem().equals(Messages.STATUS_CANCELLED)) {
    894. 

  894. //                        additional = false;
    895. 

  895.                         itemsParams.and(new QueryParameter(Context.getItem(), "intstatus", Item.STATUS_CANCELLED, QueryParameter.EQUALS));
    896. 

  896.                     }
    897. 

  897. 

  898.                     try {
    899. 

  899.                         Context c = Context.getItem();
    900. 

  900.                         itemsParams.setOrder("accountsids", true);
    901. 

  901.                         c.addReference(Context.getGroup());
    902. 

  902.                         c.addReference(Context.getAccounts());
    903. 

  903.                         c.addReference(Context.getContact());
    904. 

  904. 

  905.                         try {
    906. 

  906.                             String datecriterium = "dateadded";
    907. 

  907.                             if (bydateend.isSelected()) {
    908. 

  908.                                 datecriterium = "dateend";
    909. 

  909.                             }
    910. 

  910.                             d = QueryHandler.instanceOf().clone(c).select(Context.DETAILS_JOURNAL.replace("{date}", datecriterium), itemsParams, timeframeChooser1.getTime(), datecriterium).getData();
    911. 

  911.                         } catch (NodataFoundException nodataFoundException) {
    912. 

  912.                             d = new Object[0][15];
    913. 

  913.                         }
    914. 

  914. 

  915.                         DatabaseObject.Entity<?, ?>[] es = new DatabaseObject.Entity<?, ?>[d.length];
    916. 

  916.                         for (int i = 0; i < d.length; i++) {
    917. 

  917.                             es[i] = new DatabaseObject.Entity<Context, Integer>(Context.getItem(), Integer.valueOf(d[i][0].toString()));
    918. 

  918.                         }
    919. 

  919. 

  920.                         d = ArrayUtilities.replaceColumn(d, 0, es);
    921. 

  921.                         if (!additional) {
    922. 

  922.                             d = ArrayUtilities.removeRows(d, 11, Item.STATUS_PAID);
    923. 

  923.                         }
    924. 

  924.                     } catch (Exception ex) {
    925. 

  925.                         Log.Debug(ex);
    926. 

  926.                     }
    927. 

  927.                     if (dataOwner == null && additional) {
    928. 

  928.                         try {
    929. 

  929.                             Context c = Context.getExpense();
    930. 

  930.                             itemsParams.setOrder("dateadded", true);
    931. 

  931.                             c.addReference(Context.getGroup());
    932. 

  932.                             c.addReference(Context.getAccounts());
    933. 

  933.                             QueryCriteria2 expensesParams = new QueryCriteria2();
    934. 

  934.                             ArrayList<QueryParameter> l1 = new ArrayList<QueryParameter>();
    935. 

  935.                             for (int i = 0; i < jList1.getSelectedValues().length; i++) {
    936. 

  936.                                 l1.add(new QueryParameter(Context.getExpense(), "accountsids", ((Account) jList1.getSelectedValues()[i]).__getIDS(), QueryParameter.EQUALS));
    937. 

  937.                             }
    938. 

  938.                             if (l1.size() > 1) {
    939. 

  939.                                 expensesParams.or(l1);
    940. 

  940.                             } else {
    941. 

  941.                                 expensesParams.and(l1.toArray(new QueryParameter[0]));
    942. 

  942.                             }
    943. 

  943.                             if (forUser != null && !forUser.__getCname().equals("")) {
    944. 

  944.                                 expensesParams.and(new QueryParameter(c, "intaddedby", forUser.__getIDS(), QueryParameter.EQUALS));
    945. 

  945.                             }
    946. 

  946.                             if (!includechildgroups.isSelected()) {
    947. 

  947.                                 if (forGroup != null && !forGroup.__getCname().equals("")) {
    948. 

  948.                                     expensesParams.and(new QueryParameter(c, forGroup.getDbIdentity() + "ids", forGroup.__getIDS(), QueryParameter.EQUALS));
    949. 

  949.                                 }
    950. 

  950. 

  951.                             } else {
    952. 

  952.                                 if (forGroup != null) {
    953. 

  953.                                     List<Group> gs = forGroup.getChildGroups();
    954. 

  954.                                     QueryParameter[] params = new QueryParameter[gs.size()];
    955. 

  955.                                     QueryParameter params1 = (new QueryParameter(c, forGroup.getDbIdentity() + "ids", forGroup.__getIDS(), QueryParameter.EQUALS));
    956. 

  956.                                     if (gs.size() >= 1) {
    957. 

  957.                                         for (int i = 0; i < gs.size(); i++) {
    958. 

  958.                                             Group group = gs.get(i);
    959. 

  959.                                             params[i] = (new QueryParameter(c, group.getDbIdentity() + "ids", group.__getIDS(), QueryParameter.EQUALS));
    960. 

  960.                                         }
    961. 

  961.                                         itemsParams.or(params1, params);
    962. 

  962.                                     } else {
    963. 

  963.                                         expensesParams.and(params1);
    964. 

  964.                                     }
    965. 

  965.                                 }
    966. 

  966.                             }
    967. 

  967.                             if (statusc.getComboBox().getSelectedItem().equals(Messages.STATUS_PAID)) {
    968. 

  968.                                 expensesParams.and(new QueryParameter(c, "ispaid", true, QueryParameter.EQUALS));
    969. 

  969.                             } else if (statusc.getComboBox().getSelectedItem().equals(Messages.STATUS_UNPAID)) {
    970. 

  970.                                 expensesParams.and(new QueryParameter(c, "ispaid", false, QueryParameter.EQUALS));
    971. 

  971.                             }
    972. 

  972. 

  973.                             try {
    974. 

  974.                                 String datecriterium = "dateadded";
    975. 

  975.                                 if (expbydateend.isSelected()) {
    976. 

  976.                                     datecriterium = "dateend";
    977. 

  977.                                 }
    978. 

  978.                                 d1 = QueryHandler.instanceOf().clone(c).select(Context.DETAILS_JOURNAL3.replace("{date}", datecriterium), expensesParams, timeframeChooser1.getTime(), datecriterium).getData();
    979. 

  979.                             } catch (NodataFoundException nodataFoundException) {
    980. 

  980.                                 d1 = new Object[0][15];
    981. 

  981.                             }
    982. 

  982. 

  983. //                            try {
    984. 

  984. //                                d1 = QueryHandler.instanceOf().clone(c).select(Context.DETAILS_JOURNAL3, expensesParams, timeframeChooser1.getTime()).getData();
    985. 

  985. //                            } catch (NodataFoundException nodataFoundException) {
    986. 

  986. //                                d1 = new Object[0][14];
    987. 

  987. //                            }
    988. 

  988.                             for (int i = 0; i < d1.length; i++) {
    989. 

  989.                                 d1[i][10] = Expense.TYPE_EXPENSE;
    990. 

  990. 

  991.                                 if (TypeConversion.stringToBoolean(String.valueOf(d1[i][11]))) {
    992. 

  992.                                     d1[i][11] = 1000;
    993. 

  993.                                 } else {
    994. 

  994.                                     d1[i][11] = 2000;
    995. 

  995.                                 }
    996. 

  996.                             }
    997. 

  997. 

  998.                             DatabaseObject.Entity<?, ?>[] es = new DatabaseObject.Entity<?, ?>[d1.length];
    999. 

  999.                             for (int i = 0; i < d1.length; i++) {
    1000. 

  1000.                                 es[i] = new DatabaseObject.Entity<Context, Integer>(Context.getExpense(), Integer.valueOf(d1[i][0].toString()));
    1001. 

  1001.                             }
    1002. 

  1002.                             d1 = ArrayUtilities.replaceColumn(d1, 0, es);
    1003. 

  1003. 

  1004.                         } catch (Exception ex) {
    1005. 

  1005.                             Log.Debug(this, ex);
    1006. 

  1006.                         }
    1007. 

  1007. 

  1008.                         try {
    1009. 

  1009.                             Context c = Context.getRevenue();
    1010. 

  1010.                             itemsParams.setOrder("dateadded", true);
    1011. 

  1011.                             c.addReference(Context.getGroup());
    1012. 

  1012.                             c.addReference(Context.getAccounts());
    1013. 

  1013.                             QueryCriteria2 revenuesParams = new QueryCriteria2();
    1014. 

  1014.                             ArrayList<QueryParameter> l2 = new ArrayList<QueryParameter>();
    1015. 

  1015.                             for (int i = 0; i < jList1.getSelectedValues().length; i++) {
    1016. 

  1016.                                 l2.add(new QueryParameter(Context.getRevenue(), "accountsids", ((Account) jList1.getSelectedValues()[i]).__getIDS(), QueryParameter.EQUALS));
    1017. 

  1017.                             }
    1018. 

  1018.                             if (l2.size() > 1) {
    1019. 

  1019.                                 revenuesParams.or(l2);
    1020. 

  1020.                             } else {
    1021. 

  1021.                                 revenuesParams.and(l2.toArray(new QueryParameter[0]));
    1022. 

  1022.                             }
    1023. 

  1023.                             if (forUser != null && !forUser.__getCname().equals("")) {
    1024. 

  1024.                                 revenuesParams.and(new QueryParameter(c, "intaddedby", forUser.__getIDS(), QueryParameter.EQUALS));
    1025. 

  1025.                             }
    1026. 

  1026.                             if (!includechildgroups.isSelected()) {
    1027. 

  1027.                                 if (forGroup != null && !forGroup.__getCname().equals("")) {
    1028. 

  1028.                                     revenuesParams.and(new QueryParameter(c, forGroup.getDbIdentity() + "ids", forGroup.__getIDS(), QueryParameter.EQUALS));
    1029. 

  1029.                                 }
    1030. 

  1030.                             } else {
    1031. 

  1031.                                 if (forGroup != null) {
    1032. 

  1032.                                     List<Group> gs = forGroup.getChildGroups();
    1033. 

  1033.                                     QueryParameter[] params = new QueryParameter[gs.size()];
    1034. 

  1034.                                     QueryParameter params1 = (new QueryParameter(c, forGroup.getDbIdentity() + "ids", forGroup.__getIDS(), QueryParameter.EQUALS));
    1035. 

  1035.                                     if (gs.size() >= 1) {
    1036. 

  1036.                                         for (int i = 0; i < gs.size(); i++) {
    1037. 

  1037.                                             Group group = gs.get(i);
    1038. 

  1038.                                             params[i] = (new QueryParameter(c, group.getDbIdentity() + "ids", group.__getIDS(), QueryParameter.EQUALS));
    1039. 

  1039.                                         }
    1040. 

  1040.                                         revenuesParams.or(params1, params);
    1041. 

  1041.                                     } else {
    1042. 

  1042.                                         revenuesParams.and(params1);
    1043. 

  1043.                                     }
    1044. 

  1044.                                 }
    1045. 

  1045.                             }
    1046. 

  1046. //                            if (statusc.getComboBox().getSelectedItem().equals(Messages.STATUS_PAID)) {
    1047. 

  1047. //                                revenuesParams.and(new QueryParameter(c, "intstatus", Item.STATUS_PAID, QueryParameter.EQUALS));
    1048. 

  1048. //                            } else if (statusc.getComboBox().getSelectedItem().equals(Messages.STATUS_UNPAID)) {
    1049. 

  1049. ////                        additional = false;
    1050. 

  1050. //                                revenuesParams.or(new QueryParameter(Context.getExpense(), "intstatus", Item.STATUS_PAID, QueryParameter.EQUALS),
    1051. 

  1051. //                                        new QueryParameter(c, "intstatus", Item.STATUS_FINISHED, QueryParameter.EQUALS));
    1052. 

  1052. //                            }
    1053. 

  1053.                             try {
    1054. 

  1054.                                 d2 = QueryHandler.instanceOf().clone(c).select(Context.DETAILS_JOURNAL2, revenuesParams, timeframeChooser1.getTime()).getData();
    1055. 

  1055.                             } catch (NodataFoundException nodataFoundException) {
    1056. 

  1056.                                 d2 = new Object[0][15];
    1057. 

  1057.                             }
    1058. 

  1058.                             for (int i = 0; i < d2.length; i++) {
    1059. 

  1059.                                 d2[i][10] = Revenue.TYPE_REVENUE;
    1060. 

  1060.                                 d2[i][11] = Item.STATUS_PAID;//revenues are currently always paid :-/
    1061. 

  1061.                             }
    1062. 

  1062. 

  1063.                             DatabaseObject.Entity<?, ?>[] es = new DatabaseObject.Entity<?, ?>[d2.length];
    1064. 

  1064.                             for (int i = 0; i < d2.length; i++) {
    1065. 

  1065.                                 es[i] = new DatabaseObject.Entity<Context, Integer>(Context.getRevenue(), Integer.valueOf(d2[i][0].toString()));
    1066. 

  1066.                             }
    1067. 

  1067.                             d2 = ArrayUtilities.replaceColumn(d2, 0, es);
    1068. 

  1068. 

  1069.                         } catch (Exception ex) {
    1070. 

  1070.                             Log.Debug(this, ex);
    1071. 

  1071.                         }
    1072. 

  1072. 

  1073.                         d = ArrayUtilities.merge(ArrayUtilities.merge(d, d1), d2);
    1074. 

  1074.                     }
    1075. 

  1075.                     d = parse(d);
    1076. 

  1076.                     jTable1.setModel(new MPTableModel(d, Headers.JOURNAL.getValue(),
    1077. 

  1077.                             new Class[]{Entity.class, String.class, String.class, String.class, String.class, String.class, String.class, String.class, String.class, String.class, String.class, String.class, String.class, String.class, String.class, String.class, String.class}));
    1078. 

  1078.                     TableFormat.stripColumn(jTable1, DatabaseObject.Entity.class);
    1079. 

  1079.                     count.setText("" + d.length);
    1080. 

  1080.                 } catch (Exception e) {
    1081. 

  1081.                     Log.Debug(this, e);
    1082. 

  1082.                 }
    1083. 

  1083.             }
    1084. 

  1084.         };
    1085. 

  1085.         SwingUtilities.invokeLater(runnable);
    1086. 

  1086.     }
    1087. 

  1087. 

  1088.     @Override
    1089. 

  1089.     public void refresh() {
    1090. 

  1090.         refresh(null, null);
    1091. 

  1091.     }
    1092. 

  1092. 

  1093.     @Override
    1094. 

  1094.     public void flush() {
    1095. 

  1095.         jTable1.setModel(new DefaultTableModel());
    1096. 

  1096.     }
    1097. 

  1097. 

  1098.     private void setPopup() {
    1099. 

  1099.         TablePopUp tablePopUp = new TablePopUp(jTable1,
    1100. 

  1100.                 new String[]{Messages.DELETE.toString(),
    1101. 

  1101.                     null, Messages.RELOAD.getValue(),
    1102. 

  1102.                     null, Messages.DTA_CREATE.getValue(),
    1103. 

  1103.                     Messages.PDF_CREATE.getValue(),
    1104. 

  1104.                     Messages.ODT_CREATE.getValue(),
    1105. 

  1105.                     null, Messages.SET_STATUS_PAID.getValue(),},
    1106. 

  1106.                 new ActionListener[]{new ActionListener() {
    1107. 

  1107. 

  1108.                 public void actionPerformed(ActionEvent e) {
    1109. 

  1109.                     if (Popup.Y_N_dialog(Messages.REALLY_DELETE2 + " (" + jTable1.getSelectedRowCount() + ")")) {
    1110. 

  1110.                         int[] rows = jTable1.getSelectedRows();
    1111. 

  1111.                         for (int i = 0; i < rows.length; i++) {
    1112. 

  1112.                             try {
    1113. 

  1113.                                 int index = jTable1.convertRowIndexToModel(rows[i]);
    1114. 

  1114.                                 DatabaseObject obj = DatabaseObject.getObject((DatabaseObject.Entity<?, ?>) jTable1.getModel().getValueAt(index, 0));
    1115. 

  1115.                                 obj.delete();
    1116. 

  1116.                                 jTable1.getSelectionModel().removeSelectionInterval(rows[i] - 1, rows[i]);
    1117. 

  1117.                             } catch (NodataFoundException ex) {
    1118. 

  1118.                                 Log.Debug(ex);
    1119. 

  1119.                             } catch (Exception exc) {
    1120. 

  1120.                                 Log.Debug(exc);
    1121. 

  1121.                                 Popup.error(exc);
    1122. 

  1122.                             }
    1123. 

  1123.                         }
    1124. 

  1124.                         setData();
    1125. 

  1125.                     }
    1126. 

  1126.                 }
    1127. 

  1127.             }, null, new ActionListener() {
    1128. 

  1128. 

  1129.                 public void actionPerformed(ActionEvent e) {
    1130. 

  1130.                     setData();
    1131. 

  1131.                 }
    1132. 

  1132.             },
    1133. 

  1133.                     null,
    1134. 

  1134.                     new ActionListener() {
    1135. 

  1135. 

  1136.                         public void actionPerformed(ActionEvent e) {
    1137. 

  1137.                             dta();
    1138. 

  1138.                         }
    1139. 

  1139.                     },
    1140. 

  1140.                     new ActionListener() {
    1141. 

  1141. 

  1142.                         public void actionPerformed(ActionEvent e) {
    1143. 

  1143.                             pdf();
    1144. 

  1144.                         }
    1145. 

  1145.                     },
    1146. 

  1146.                     new ActionListener() {
    1147. 

  1147. 

  1148.                         public void actionPerformed(ActionEvent e) {
    1149. 

  1149.                             odt();
    1150. 

  1150.                         }
    1151. 

  1151.                     },
    1152. 

  1152.                     null,
    1153. 

  1153.                     new ActionListener() {
    1154. 

  1154. 

  1155.                         public void actionPerformed(ActionEvent e) {
    1156. 

  1156.                             if (Popup.Y_N_dialog(Messages.REALLY_CHANGE2 + " (" + jTable1.getSelectedRowCount() + ")")) {
    1157. 

  1157.                                 int[] rows = jTable1.getSelectedRows();
    1158. 

  1158.                                 for (int i = 0; i < rows.length; i++) {
    1159. 

  1159.                                     try {
    1160. 

  1160.                                         int index = jTable1.convertRowIndexToModel(rows[i]);
    1161. 

  1161.                                         DatabaseObject obj = DatabaseObject.getObject((DatabaseObject.Entity<?, ?>) jTable1.getModel().getValueAt(index, 0));
    1162. 

  1162.                                         if (obj instanceof Item) {
    1163. 

  1163.                                             Item dbi = (Item) obj;
    1164. 

  1164.                                             if (dbi.__getIntstatus() != Item.STATUS_PAID) {
    1165. 

  1165.                                                 dbi.setIntstatus(Item.STATUS_PAID);
    1166. 

  1166.                                                 dbi.save();
    1167. 

  1167.                                             }
    1168. 

  1168.                                         } else if (obj instanceof Expense) {
    1169. 

  1169.                                             Expense dbi = (Expense) obj;
    1170. 

  1170.                                             if (!dbi.__getIspaid()) {
    1171. 

  1171.                                                 dbi.setIspaid(true);
    1172. 

  1172.                                                 dbi.save();
    1173. 

  1173.                                             }
    1174. 

  1174.                                         }
    1175. 

  1175.                                         jTable1.getSelectionModel().removeSelectionInterval(rows[i] - 1, rows[i]);
    1176. 

  1176.                                     } catch (NodataFoundException ex) {
    1177. 

  1177.                                         Log.Debug(ex);
    1178. 

  1178.                                     } catch (Exception exc) {
    1179. 

  1179.                                         Log.Debug(exc);
    1180. 

  1180.                                         Popup.error(exc);
    1181. 

  1181.                                     }
    1182. 

  1182.                                 }
    1183. 

  1183.                                 setData();
    1184. 

  1184.                             }
    1185. 

  1185.                         }
    1186. 

  1186.                     }
    1187. 

  1187.                 });
    1188. 

  1188. 

  1189. 

  1190.     }
    1191. 

  1191. 

  1192.     private void setData() {
    1193. 

  1193.         try {
    1194. 

  1194.             Group g = null;
    1195. 

  1195.             User u = null;
    1196. 

  1196. 

  1197.             if (groups.getSelectedItem().isValid()) {
    1198. 

  1198.                 try {
    1199. 

  1199.                     g = ((Group) Group.getObject(Context.getGroup(), Integer.valueOf(groups.getSelectedItem().getId())));
    1200. 

  1200.                 } catch (Exception nodataFoundException) {
    1201. 

  1201.                     g = null;
    1202. 

  1202.                 }
    1203. 

  1203.             }
    1204. 

  1204.             try {
    1205. 

  1205.                 if (users.getSelectedItem().isValid()) {
    1206. 

  1206.                     u = ((User) User.getObject(Context.getUser(), Integer.valueOf(users.getSelectedItem().getId())));
    1207. 

  1207.                 }
    1208. 

  1208.             } catch (Exception nodataFoundException) {
    1209. 

  1209.                 u = null;
    1210. 

  1210.             }
    1211. 

  1211.             refresh(g, u);
    1212. 

  1212.         } catch (Exception ignore) {
    1213. 

  1213.             refresh(null, null);
    1214. 

  1214.         }
    1215. 

  1215.     }
    1216. 

  1216. 

  1217.     private void preview() {
    1218. 

  1218.         PreviewPanel pr;
    1219. 

  1219.         if (journalOrContactTemplate != null) {
    1220. 

  1220.             pr = new PreviewPanel();
    1221. 

  1221.             pr.setDataOwner(dataOwner);
    1222. 

  1222.             HashMap<String, Object> map = new HashMap<String, Object>();
    1223. 

  1223.             map.put("jo
    1224.