Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package com.gnadenheimer.mg.frames.admin; import ca.odell.glazedlists.GlazedLists; import ca.odell.glazedlists.matchers.TextMatcherEditor; import ca.odell.glazedlists.swing.AutoCompleteSupport; import com.github.lgooddatepicker.tableeditors.DateTableEditor; import com.gnadenheimer.mg.domain.TblContribuyentes; import com.gnadenheimer.mg.domain.miembros.TblAportesImporteMensualSaldoAnterior; import com.gnadenheimer.mg.domain.miembros.TblEntidades; import com.gnadenheimer.mg.domain.miembros.TblEntidadesHistoricoCategorias; import com.gnadenheimer.mg.utils.CurrentUser; import com.gnadenheimer.mg.utils.Utils; import java.awt.Color; import java.awt.EventQueue; import java.awt.KeyboardFocusManager; import java.beans.Beans; import java.beans.PropertyChangeEvent; import java.beans.PropertyChangeListener; import java.io.File; import java.io.FileInputStream; import java.text.DecimalFormat; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.ZoneId; import java.util.ArrayList; import java.util.HashMap; import java.util.HashSet; import java.util.Iterator; import java.util.LinkedList; import java.util.List; import java.util.Map; import java.util.Optional; import javax.persistence.Persistence; import javax.persistence.RollbackException; import javax.swing.DefaultCellEditor; import javax.swing.JComboBox; import javax.swing.JFileChooser; import javax.swing.JFormattedTextField; import javax.swing.JFrame; import javax.swing.JInternalFrame; import javax.swing.JOptionPane; import javax.swing.SwingUtilities; import javax.swing.event.DocumentEvent; import javax.swing.event.DocumentListener; import javax.swing.event.ListSelectionEvent; import javax.swing.event.ListSelectionListener; import net.coderazzi.filters.gui.AutoChoices; import net.coderazzi.filters.gui.TableFilterHeader; import org.apache.logging.log4j.LogManager; import org.apache.logging.log4j.Logger; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.poifs.filesystem.POIFSFileSystem; import org.apache.poi.ss.usermodel.Cell; /** * * @author user */ public class FrameEntidadesAdmin extends JInternalFrame { private static final Logger LOGGER = LogManager.getLogger(FrameEntidadesAdmin.class); Map<String, String> persistenceMap = new HashMap<>(); CurrentUser currentUser = CurrentUser.getInstance(); private JComboBox cboCategoria = new JComboBox(); public FrameEntidadesAdmin() { super("Administrar Entidades", true, //resizable true, //closable true, //maximizable true);//iconifiable try { persistenceMap = Utils.getInstance().getPersistenceMap(); initComponents(); //txtAporteBase.setValue(0); if (!Beans.isDesignTime()) { entityManager.getTransaction().begin(); } //MUY LENTO--------- TableFilterHeader filterHeader = new TableFilterHeader(masterTable, AutoChoices.DISABLED); //TableFilterHeader filterHeader = new TableFilterHeader(masterTable, AutoChoices.ENABLED); filterHeader.setAdaptiveChoices(false); filterHeader.setPosition(TableFilterHeader.Position.TOP); filterHeader.getParserModel().setIgnoreCase(true); AutoCompleteSupport support = AutoCompleteSupport.install(cboFormaDePago, GlazedLists.eventListOf(listFormasDePago.toArray())); support.setFilterMode(TextMatcherEditor.CONTAINS); AutoCompleteSupport support1 = AutoCompleteSupport.install(cboEntidad, GlazedLists.eventListOf(list.toArray())); support1.setFilterMode(TextMatcherEditor.CONTAINS); /* AutoCompleteSupport support3 = AutoCompleteSupport.install(cboAreaServicio, GlazedLists.eventListOf(listAreaServicio.toArray())); support3.setFilterMode(TextMatcherEditor.CONTAINS); AutoCompleteSupport support4 = AutoCompleteSupport.install(cboAlergia, GlazedLists.eventListOf(listAlergia.toArray())); support4.setFilterMode(TextMatcherEditor.CONTAINS); */ AutoCompleteSupport support5 = AutoCompleteSupport.install(cboCategoria, GlazedLists.eventListOf(listCategoria.toArray())); support5.setFilterMode(TextMatcherEditor.CONTAINS); rucField.getDocument().addDocumentListener(new DocumentListener() { @Override public void changedUpdate(DocumentEvent e) { process(); } @Override public void removeUpdate(DocumentEvent e) { process(); } @Override public void insertUpdate(DocumentEvent e) { process(); } public void process() { if (rucField.getText().length() > 6) { if (rucField.getText() != null) { TblContribuyentes c = entityManager.find(TblContribuyentes.class, rucField.getText()); if (c != null) { txtRazonSocial.setText(c.getRazonSocial()); } } else { txtRazonSocial.setText(""); } } } }); KeyboardFocusManager.getCurrentKeyboardFocusManager().addPropertyChangeListener("permanentFocusOwner", new PropertyChangeListener() { @Override public void propertyChange(final PropertyChangeEvent e) { if (e.getNewValue() instanceof JFormattedTextField) { SwingUtilities.invokeLater(new Runnable() { public void run() { JFormattedTextField textField = (JFormattedTextField) e.getNewValue(); textField.selectAll(); } }); } } }); masterTable.getSelectionModel().addListSelectionListener(new ListSelectionListener() { @Override public void valueChanged(ListSelectionEvent lse) { try { if (!lse.getValueIsAdjusting()) { if (categoriasTable.getColumnModel().getColumnCount() > 0 && categoriasTable.getRowCount() == 1) { categoriasTable.getColumnModel().getColumn(0).setCellEditor(new DateTableEditor()); categoriasTable.getColumnModel().getColumn(1) .setCellEditor(new DefaultCellEditor(cboCategoria)); } if (aportesImportesTable.getColumnModel().getColumnCount() > 0 && aportesImportesTable.getRowCount() == 1) { aportesImportesTable.getColumnModel().getColumn(0) .setCellRenderer(numberCellRenderer1); aportesImportesTable.getColumnModel().getColumn(1) .setCellRenderer(numberCellRenderer1); aportesImportesTable.getColumnModel().getColumn(2) .setCellRenderer(numberCellRenderer1); } } } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } } }); } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents private void initComponents() { bindingGroup = new org.jdesktop.beansbinding.BindingGroup(); entityManager = java.beans.Beans.isDesignTime() ? null : Persistence.createEntityManagerFactory("mg_PU", persistenceMap).createEntityManager(); query = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT t FROM TblEntidades t ORDER BY t.ctacte"); list = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : org.jdesktop.observablecollections.ObservableCollections.observableList(query.getResultList()); ctaCteTableCellRenderer1 = new com.gnadenheimer.mg.utils.CtaCteTableCellRenderer(); numberCellRenderer1 = new com.gnadenheimer.mg.utils.NumberCellRenderer(); rucTableCellRenderer1 = new com.gnadenheimer.mg.utils.RucTableCellRenderer(); queryFormasDePago = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT t FROM TblFormasDePago t"); listFormasDePago = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : org.jdesktop.observablecollections.ObservableCollections .observableList(queryFormasDePago.getResultList()); integerLongConverter1 = new com.gnadenheimer.mg.utils.IntegerLongConverter(); queryCategoria = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT t FROM TblMiembrosCategoriasDePago t ORDER BY t.descripcion"); listCategoria = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : org.jdesktop.observablecollections.ObservableCollections .observableList(queryCategoria.getResultList()); queryAreaServicio = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT t FROM TblAreasServicioEnIglesia t ORDER BY t.id"); listAreaServicio = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : org.jdesktop.observablecollections.ObservableCollections .observableList(queryAreaServicio.getResultList()); queryAlergia = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT t FROM TblMiembrosAlergias t ORDER BY t.id"); listAlergia = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : org.jdesktop.observablecollections.ObservableCollections .observableList(queryAlergia.getResultList()); anoMesCellRenderer1 = new com.gnadenheimer.mg.utils.AnoMesCellRenderer(); dateTableCellRenderer1 = new com.gnadenheimer.mg.utils.DateTableCellRenderer(); masterScrollPane = new javax.swing.JScrollPane(); masterTable = new javax.swing.JTable(); idLabel = new javax.swing.JLabel(); nombreLabel = new javax.swing.JLabel(); ctacteLabel = new javax.swing.JLabel(); direccionLabel = new javax.swing.JLabel(); idField = new javax.swing.JTextField(); nombreField = new javax.swing.JTextField(); ctacteField = new javax.swing.JTextField(); direccionField = new javax.swing.JTextField(); saveButton = new javax.swing.JButton(); refreshButton = new javax.swing.JButton(); newButton = new javax.swing.JButton(); deleteButton = new javax.swing.JButton(); ctacteLabel1 = new javax.swing.JLabel(); direccionLabel1 = new javax.swing.JLabel(); ctacteField1 = new javax.swing.JTextField(); jButton3 = new javax.swing.JButton(); ctacteLabel2 = new javax.swing.JLabel(); ctacteLabel3 = new javax.swing.JLabel(); rucField = new javax.swing.JTextField(); txtAporteBase1 = new javax.swing.JFormattedTextField(); ctacteLabel6 = new javax.swing.JLabel(); idCategoriaLabel = new javax.swing.JLabel(); cboFormaDePago = new javax.swing.JComboBox(); apellidosField = new javax.swing.JTextField(); nombreLabel1 = new javax.swing.JLabel(); txtRazonSocial = new javax.swing.JTextField(); montoLabel2 = new javax.swing.JLabel(); txtCtaCte = new javax.swing.JTextField(); idMiembroLabel2 = new javax.swing.JLabel(); cboEntidad = new javax.swing.JComboBox(); idMiembroLabel = new javax.swing.JLabel(); idMiembroLabel1 = new javax.swing.JLabel(); nombreLabel2 = new javax.swing.JLabel(); nombreLabel3 = new javax.swing.JLabel(); nombreLabel4 = new javax.swing.JLabel(); nombreLabel5 = new javax.swing.JLabel(); dtpFechaNacimiento = new com.github.lgooddatepicker.components.DatePicker(); dtpFechaBautismo = new com.github.lgooddatepicker.components.DatePicker(); dtpFechaCongregacion = new com.github.lgooddatepicker.components.DatePicker(); dtpFechaDescongregacion = new com.github.lgooddatepicker.components.DatePicker(); dtpFechaDefuncion = new com.github.lgooddatepicker.components.DatePicker(); txtAporteBase2 = new javax.swing.JFormattedTextField(); ctacteLabel7 = new javax.swing.JLabel(); nombreLabel7 = new javax.swing.JLabel(); jScrollPane1 = new javax.swing.JScrollPane(); categoriasTable = new javax.swing.JTable(); cmdBorrarCategoria = new javax.swing.JButton(); cmdAddCategoria = new javax.swing.JButton(); montoLabel6 = new javax.swing.JLabel(); jScrollPane2 = new javax.swing.JScrollPane(); aportesImportesTable = new javax.swing.JTable(); cmdBorrarImporteAporte = new javax.swing.JButton(); cmdAddImporteAporte = new javax.swing.JButton(); montoLabel7 = new javax.swing.JLabel(); FormListener formListener = new FormListener(); ctaCteTableCellRenderer1.setText("ctaCteTableCellRenderer1"); numberCellRenderer1.setText("numberCellRenderer1"); rucTableCellRenderer1.setText("rucTableCellRenderer1"); anoMesCellRenderer1.setText("anoMesCellRenderer1"); dateTableCellRenderer1.setText("dateTableCellRenderer1"); addInternalFrameListener(formListener); masterTable.setAutoCreateRowSorter(true); org.jdesktop.swingbinding.JTableBinding jTableBinding = org.jdesktop.swingbinding.SwingBindings .createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, list, masterTable); org.jdesktop.swingbinding.JTableBinding.ColumnBinding columnBinding = jTableBinding .addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${id}")); columnBinding.setColumnName("Nro"); columnBinding.setColumnClass(Integer.class); columnBinding.setEditable(false); columnBinding = jTableBinding .addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${nombreCompleto}")); columnBinding.setColumnName("Nombre"); columnBinding.setEditable(false); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${ctacte}")); columnBinding.setColumnName("Ctacte"); columnBinding.setColumnClass(Integer.class); columnBinding.setEditable(false); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${rucSinDv}")); columnBinding.setColumnName("RUC"); columnBinding.setColumnClass(String.class); columnBinding.setEditable(false); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${domicilio}")); columnBinding.setColumnName("Domicilio"); columnBinding.setColumnClass(String.class); columnBinding.setEditable(false); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${box}")); columnBinding.setColumnName("Casilla Correo"); columnBinding.setColumnClass(Integer.class); columnBinding.setEditable(false); columnBinding = jTableBinding .addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${idEntidadPaganteAportes}")); columnBinding.setColumnName("Pagante"); columnBinding.setColumnClass(com.gnadenheimer.mg.domain.miembros.TblEntidades.class); columnBinding.setEditable(false); bindingGroup.addBinding(jTableBinding); jTableBinding.bind(); masterScrollPane.setViewportView(masterTable); if (masterTable.getColumnModel().getColumnCount() > 0) { masterTable.getColumnModel().getColumn(2).setCellRenderer(ctaCteTableCellRenderer1); masterTable.getColumnModel().getColumn(3).setCellRenderer(rucTableCellRenderer1); masterTable.getColumnModel().getColumn(5).setCellRenderer(numberCellRenderer1); } idLabel.setText("Nro:"); nombreLabel.setText("Nombres:"); ctacteLabel.setText("Cta Cte (FORMATO NUEVO):"); direccionLabel.setText("Domicilio:"); idField.setEditable(false); org.jdesktop.beansbinding.Binding binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.id}"), idField, org.jdesktop.beansbinding.BeanProperty.create("text")); binding.setSourceUnreadableValue("null"); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), idField, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.nombres}"), nombreField, org.jdesktop.beansbinding.BeanProperty.create("text")); binding.setSourceUnreadableValue("null"); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), nombreField, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.ctacte}"), ctacteField, org.jdesktop.beansbinding.BeanProperty.create("text")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), ctacteField, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.domicilio}"), direccionField, org.jdesktop.beansbinding.BeanProperty.create("text")); binding.setSourceUnreadableValue("null"); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), direccionField, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); saveButton.setText("Guardar"); saveButton.addActionListener(formListener); refreshButton.setText("Cancelar"); refreshButton.addActionListener(formListener); newButton.setText("Nuevo"); newButton.addActionListener(formListener); deleteButton.setText("Eliminar"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), deleteButton, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); deleteButton.addActionListener(formListener); ctacteLabel1.setText("(Solo numeros sin simbolos como - o /)"); ctacteLabel1.setForeground(new java.awt.Color(153, 153, 153)); direccionLabel1.setText("Casilla Correo:"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.box}"), ctacteField1, org.jdesktop.beansbinding.BeanProperty.create("text")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), ctacteField1, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); ctacteField1.addActionListener(formListener); jButton3.setText("Cargar EXCEL de Miembros"); jButton3.addActionListener(formListener); ctacteLabel2.setText( "Formato XLS: Nombres, Apellidos, Cta.Cte, Cedula, Domicilio, Box, Fecha Nacimiento, Fecha Bautismo, Fecha Entrada a Congregacion"); ctacteLabel2.setForeground(new java.awt.Color(51, 51, 51)); ctacteLabel3.setText("Cedula / RUC sin DV:"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.rucSinDv}"), rucField, org.jdesktop.beansbinding.BeanProperty.create("text")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), rucField, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); rucField.addKeyListener(formListener); txtAporteBase1.setEditable(false); txtAporteBase1.setColumns(9); txtAporteBase1.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory( new javax.swing.text.NumberFormatter(java.text.NumberFormat.getIntegerInstance()))); txtAporteBase1.setHorizontalAlignment(javax.swing.JTextField.TRAILING); txtAporteBase1.setText("0"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.aporteMensual}"), txtAporteBase1, org.jdesktop.beansbinding.BeanProperty.create("value")); binding.setConverter(integerLongConverter1); bindingGroup.addBinding(binding); txtAporteBase1.addMouseListener(formListener); txtAporteBase1.addActionListener(formListener); ctacteLabel6.setText("Aporte Base:"); idCategoriaLabel.setText("Forma de Pago preferida Viejo:"); cboFormaDePago.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N org.jdesktop.swingbinding.JComboBoxBinding jComboBoxBinding = org.jdesktop.swingbinding.SwingBindings .createJComboBoxBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, listFormasDePago, cboFormaDePago); bindingGroup.addBinding(jComboBoxBinding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.idFormaDePagoPreferida}"), cboFormaDePago, org.jdesktop.beansbinding.BeanProperty.create("selectedItem")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), cboFormaDePago, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); cboFormaDePago.addActionListener(formListener); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.apellidos}"), apellidosField, org.jdesktop.beansbinding.BeanProperty.create("text")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), apellidosField, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); nombreLabel1.setText("Apellidos:"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.razonSocial}"), txtRazonSocial, org.jdesktop.beansbinding.BeanProperty.create("text")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), txtRazonSocial, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); montoLabel2.setText("Razon Social:"); txtCtaCte.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), txtCtaCte, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); txtCtaCte.addFocusListener(formListener); txtCtaCte.addInputMethodListener(formListener); txtCtaCte.addActionListener(formListener); txtCtaCte.addKeyListener(formListener); idMiembroLabel2.setText("Nombre:"); idMiembroLabel2.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N cboEntidad.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N jComboBoxBinding = org.jdesktop.swingbinding.SwingBindings.createJComboBoxBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, list, cboEntidad); bindingGroup.addBinding(jComboBoxBinding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.idEntidadPaganteAportes}"), cboEntidad, org.jdesktop.beansbinding.BeanProperty.create("selectedItem")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), cboEntidad, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); cboEntidad.addActionListener(formListener); idMiembroLabel.setText("Miembro pagante de aporte:"); idMiembroLabel.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N idMiembroLabel1.setText("Cta. Cte.:"); idMiembroLabel1.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N nombreLabel2.setText("Fecha Nacimiento:"); nombreLabel3.setText("Fecha Bautismo:"); nombreLabel4.setText("Fecha Congregacion:"); nombreLabel5.setText("Fecha Descongregacion:"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.fechaNacimiento}"), dtpFechaNacimiento, org.jdesktop.beansbinding.BeanProperty.create("date")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), dtpFechaNacimiento, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.fechaBautismo}"), dtpFechaBautismo, org.jdesktop.beansbinding.BeanProperty.create("date")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), dtpFechaBautismo, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.fechaEntradaCongregacion}"), dtpFechaCongregacion, org.jdesktop.beansbinding.BeanProperty.create("date")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), dtpFechaCongregacion, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.fechaSalidaCongregacion}"), dtpFechaDescongregacion, org.jdesktop.beansbinding.BeanProperty.create("date")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), dtpFechaDescongregacion, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.fechaDefuncion}"), dtpFechaDefuncion, org.jdesktop.beansbinding.BeanProperty.create("date")); bindingGroup.addBinding(binding); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), dtpFechaDefuncion, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); txtAporteBase2.setColumns(9); txtAporteBase2.setEditable(false); txtAporteBase2.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory( new javax.swing.text.NumberFormatter(java.text.NumberFormat.getIntegerInstance()))); txtAporteBase2.setHorizontalAlignment(javax.swing.JTextField.TRAILING); txtAporteBase2.setText("0"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.aporteSaldoAnterior}"), txtAporteBase2, org.jdesktop.beansbinding.BeanProperty.create("value")); bindingGroup.addBinding(binding); txtAporteBase2.addMouseListener(formListener); txtAporteBase2.addActionListener(formListener); ctacteLabel7.setText("Aporte Saldo de Ao Anterior Viejo:"); nombreLabel7.setText("Fecha Defuncin:"); categoriasTable.setAutoCreateRowSorter(true); categoriasTable.setRowHeight(20); org.jdesktop.beansbinding.ELProperty eLProperty = org.jdesktop.beansbinding.ELProperty .create("${selectedElement.tblEntidadesHistoricoCategoriasList}"); jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, eLProperty, categoriasTable); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${fecha}")); columnBinding.setColumnName("Fecha de Cambio"); columnBinding.setColumnClass(java.time.LocalDate.class); columnBinding = jTableBinding .addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${idCategoriaDePago}")); columnBinding.setColumnName("Categoria De Pago"); columnBinding.setColumnClass(com.gnadenheimer.mg.domain.miembros.TblMiembrosCategoriasDePago.class); columnBinding = jTableBinding .addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${observaciones}")); columnBinding.setColumnName("Observaciones"); columnBinding.setColumnClass(String.class); bindingGroup.addBinding(jTableBinding); jTableBinding.bind(); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), categoriasTable, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); jScrollPane1.setViewportView(categoriasTable); if (categoriasTable.getColumnModel().getColumnCount() > 0) { categoriasTable.getColumnModel().getColumn(1).setCellRenderer(numberCellRenderer1); } cmdBorrarCategoria.setText("-"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), cmdBorrarCategoria, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); cmdBorrarCategoria.addActionListener(formListener); cmdAddCategoria.setText("+"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), cmdAddCategoria, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); cmdAddCategoria.addActionListener(formListener); montoLabel6.setText("Categoria de Miembro"); binding = org.jdesktop.beansbinding.Bindings.createAutoBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, org.jdesktop.beansbinding.ELProperty.create("${selectedElement != null}"), montoLabel6, org.jdesktop.beansbinding.BeanProperty.create("enabled")); bindingGroup.addBinding(binding); aportesImportesTable.setAutoCreateRowSorter(true); aportesImportesTable.setRowHeight(20); eLProperty = org.jdesktop.beansbinding.ELProperty .create("${selectedElement.tblAportesImporteMensualSaldoAnteriorList}"); jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding( org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, masterTable, eLProperty, aportesImportesTable); columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${ano}")); columnBinding.setColumnName("Ao"); columnBinding.setColumnClass(Integer.class); columnBinding = jTableBinding .addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${importeMensual}")); columnBinding.setColumnName("Importe Mensual"); columnBinding.setColumnClass(Long.class); columnBinding = jTableBinding .addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${saldoAnterior}")); columnBinding.setColumnName("Saldo Anterior"); columnBinding.setColumnClass(Long.class); bindingGroup.addBinding(jTableBinding); jTableBinding.bind(); jScrollPane2.setViewportView(aportesImportesTable); if (aportesImportesTable.getColumnModel().getColumnCount() > 0) { aportesImportesTable.getColumnModel().getColumn(1).setCellRenderer(numberCellRenderer1); aportesImportesTable.getColumnModel().getColumn(2).setCellRenderer(numberCellRenderer1); } cmdBorrarImporteAporte.setText("-"); cmdBorrarImporteAporte.addActionListener(formListener); cmdAddImporteAporte.setText("+"); cmdAddImporteAporte.addActionListener(formListener); montoLabel7.setText("Importes de Aporte"); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGap(788, 788, 788).addComponent(newButton) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(deleteButton) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(refreshButton) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(saveButton)) .addGroup(layout.createSequentialGroup() .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 221, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18).addComponent(ctacteLabel2))) .addGap(0, 514, Short.MAX_VALUE)) .addGroup(layout.createSequentialGroup().addContainerGap().addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(masterScrollPane) .addGroup(layout.createSequentialGroup().addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(ctacteLabel7).addComponent(idCategoriaLabel) .addComponent(direccionLabel).addComponent(montoLabel2) .addComponent(direccionLabel1).addComponent(ctacteLabel6) .addComponent(ctacteLabel3).addComponent(ctacteLabel) .addComponent(nombreLabel1).addComponent(idLabel).addComponent(nombreLabel)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(nombreField, javax.swing.GroupLayout.PREFERRED_SIZE, 249, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(idField, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createSequentialGroup() .addComponent(ctacteField, javax.swing.GroupLayout.PREFERRED_SIZE, 58, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(ctacteLabel1)) .addComponent(apellidosField, javax.swing.GroupLayout.PREFERRED_SIZE, 249, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(rucField, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(txtRazonSocial) .addComponent(ctacteField1, javax.swing.GroupLayout.PREFERRED_SIZE, 58, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(direccionField, javax.swing.GroupLayout.PREFERRED_SIZE, 295, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup().addGap(45, 45, 45) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addComponent(cboFormaDePago, javax.swing.GroupLayout.PREFERRED_SIZE, 197, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(txtAporteBase2, javax.swing.GroupLayout.PREFERRED_SIZE, 123, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGroup(layout.createSequentialGroup() .addComponent(txtAporteBase1, javax.swing.GroupLayout.PREFERRED_SIZE, 123, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(31, 31, 31)))) .addGroup(layout.createSequentialGroup().addComponent(idMiembroLabel) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(idMiembroLabel1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(txtCtaCte, javax.swing.GroupLayout.PREFERRED_SIZE, 61, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(12, 12, 12).addComponent(idMiembroLabel2) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(cboEntidad, javax.swing.GroupLayout.PREFERRED_SIZE, 200, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGap(35, 35, 35) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addGroup(layout.createSequentialGroup().addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(cmdAddImporteAporte).addGap(12, 12, 12) .addComponent(cmdBorrarImporteAporte, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(montoLabel7)) .addGroup(layout.createSequentialGroup() .addComponent(cmdAddCategoria) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(cmdBorrarCategoria, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(montoLabel6)) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 359, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(48, 48, 48) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addComponent(nombreLabel3).addComponent(nombreLabel2) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(nombreLabel4) .addGap(16, 16, 16)) .addComponent(nombreLabel5, javax.swing.GroupLayout.Alignment.TRAILING)) .addComponent(nombreLabel7) .addGroup(layout.createSequentialGroup() .addGap(161, 161, 161) .addGroup(layout.createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addComponent(dtpFechaCongregacion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(dtpFechaDescongregacion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(dtpFechaDefuncion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(dtpFechaBautismo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(dtpFechaNacimiento, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))) .addComponent(jScrollPane2)) .addGap(0, 0, Short.MAX_VALUE))) .addContainerGap())); layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] { deleteButton, newButton, refreshButton, saveButton }); layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addContainerGap() .addComponent(masterScrollPane, javax.swing.GroupLayout.PREFERRED_SIZE, 148, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(layout.createSequentialGroup() .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 55, Short.MAX_VALUE) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(idField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(idLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 12, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(7, 7, 7) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(nombreField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(nombreLabel)) .addGap(10, 10, 10) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(apellidosField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(nombreLabel1)) .addGap(9, 9, 9) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(ctacteField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(ctacteLabel1).addComponent(ctacteLabel)) .addGap(9, 9, 9) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(rucField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(ctacteLabel3)) .addGap(9, 9, 9) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(txtRazonSocial, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(montoLabel2)) .addGap(8, 8, 8) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(direccionField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(direccionLabel)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(ctacteField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(direccionLabel1)) .addGap(24, 24, 24) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(txtAporteBase1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(ctacteLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(ctacteLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(txtAporteBase2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(idCategoriaLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 21, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(cboFormaDePago)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(idMiembroLabel1) .addComponent(txtCtaCte, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(idMiembroLabel2) .addComponent(cboEntidad, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(idMiembroLabel))) .addGroup(layout.createSequentialGroup().addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(nombreLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 19, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(dtpFechaNacimiento, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(dtpFechaBautismo, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(nombreLabel3)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(dtpFechaCongregacion, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(nombreLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(nombreLabel5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(dtpFechaDescongregacion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout .createSequentialGroup() .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGap(9, 9, 9) .addComponent(montoLabel6)) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(cmdBorrarCategoria, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(cmdAddCategoria))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 97, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(3, 3, 3))) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(dtpFechaDefuncion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(nombreLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 37, Short.MAX_VALUE) .addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout .createParallelGroup( javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(montoLabel7) .addComponent(cmdBorrarImporteAporte)) .addComponent(cmdAddImporteAporte)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 177, javax.swing.GroupLayout.PREFERRED_SIZE))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED, 26, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton3).addComponent(ctacteLabel2)) .addGap(39, 39, 39) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(saveButton).addComponent(refreshButton).addComponent(deleteButton) .addComponent(newButton)) .addContainerGap())); bindingGroup.bind(); } // Code for dispatching events from components to event handlers. private class FormListener implements java.awt.event.ActionListener, java.awt.event.FocusListener, java.awt.event.InputMethodListener, java.awt.event.KeyListener, java.awt.event.MouseListener, javax.swing.event.InternalFrameListener { FormListener() { } public void actionPerformed(java.awt.event.ActionEvent evt) { if (evt.getSource() == saveButton) { FrameEntidadesAdmin.this.saveButtonActionPerformed(evt); } else if (evt.getSource() == refreshButton) { FrameEntidadesAdmin.this.refreshButtonActionPerformed(evt); } else if (evt.getSource() == newButton) { FrameEntidadesAdmin.this.newButtonActionPerformed(evt); } else if (evt.getSource() == deleteButton) { FrameEntidadesAdmin.this.deleteButtonActionPerformed(evt); } else if (evt.getSource() == ctacteField1) { FrameEntidadesAdmin.this.ctacteField1ActionPerformed(evt); } else if (evt.getSource() == jButton3) { FrameEntidadesAdmin.this.jButton3ActionPerformed(evt); } else if (evt.getSource() == txtAporteBase1) { FrameEntidadesAdmin.this.txtAporteBase1ActionPerformed(evt); } else if (evt.getSource() == cboFormaDePago) { FrameEntidadesAdmin.this.cboFormaDePagoActionPerformed(evt); } else if (evt.getSource() == txtCtaCte) { FrameEntidadesAdmin.this.txtCtaCteActionPerformed(evt); } else if (evt.getSource() == cboEntidad) { FrameEntidadesAdmin.this.cboEntidadActionPerformed(evt); } else if (evt.getSource() == txtAporteBase2) { FrameEntidadesAdmin.this.txtAporteBase2ActionPerformed(evt); } else if (evt.getSource() == cmdBorrarCategoria) { FrameEntidadesAdmin.this.cmdBorrarCategoriaActionPerformed(evt); } else if (evt.getSource() == cmdAddCategoria) { FrameEntidadesAdmin.this.cmdAddCategoriaActionPerformed(evt); } else if (evt.getSource() == cmdBorrarImporteAporte) { FrameEntidadesAdmin.this.cmdBorrarImporteAporteActionPerformed(evt); } else if (evt.getSource() == cmdAddImporteAporte) { FrameEntidadesAdmin.this.cmdAddImporteAporteActionPerformed(evt); } } public void focusGained(java.awt.event.FocusEvent evt) { if (evt.getSource() == txtCtaCte) { FrameEntidadesAdmin.this.txtCtaCteFocusGained(evt); } } public void focusLost(java.awt.event.FocusEvent evt) { } public void caretPositionChanged(java.awt.event.InputMethodEvent evt) { } public void inputMethodTextChanged(java.awt.event.InputMethodEvent evt) { if (evt.getSource() == txtCtaCte) { FrameEntidadesAdmin.this.txtCtaCteInputMethodTextChanged(evt); } } public void keyPressed(java.awt.event.KeyEvent evt) { if (evt.getSource() == rucField) { FrameEntidadesAdmin.this.rucFieldKeyPressed(evt); } } public void keyReleased(java.awt.event.KeyEvent evt) { if (evt.getSource() == rucField) { FrameEntidadesAdmin.this.rucFieldKeyReleased(evt); } else if (evt.getSource() == txtCtaCte) { FrameEntidadesAdmin.this.txtCtaCteKeyReleased(evt); } } public void keyTyped(java.awt.event.KeyEvent evt) { } public void mouseClicked(java.awt.event.MouseEvent evt) { if (evt.getSource() == txtAporteBase1) { FrameEntidadesAdmin.this.txtAporteBase1MouseClicked(evt); } else if (evt.getSource() == txtAporteBase2) { FrameEntidadesAdmin.this.txtAporteBase2MouseClicked(evt); } } public void mouseEntered(java.awt.event.MouseEvent evt) { } public void mouseExited(java.awt.event.MouseEvent evt) { } public void mousePressed(java.awt.event.MouseEvent evt) { } public void mouseReleased(java.awt.event.MouseEvent evt) { } public void internalFrameActivated(javax.swing.event.InternalFrameEvent evt) { if (evt.getSource() == FrameEntidadesAdmin.this) { FrameEntidadesAdmin.this.formInternalFrameActivated(evt); } } public void internalFrameClosed(javax.swing.event.InternalFrameEvent evt) { } public void internalFrameClosing(javax.swing.event.InternalFrameEvent evt) { } public void internalFrameDeactivated(javax.swing.event.InternalFrameEvent evt) { } public void internalFrameDeiconified(javax.swing.event.InternalFrameEvent evt) { } public void internalFrameIconified(javax.swing.event.InternalFrameEvent evt) { } public void internalFrameOpened(javax.swing.event.InternalFrameEvent evt) { } }// </editor-fold>//GEN-END:initComponents private void deleteButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_deleteButtonActionPerformed try { int[] selected = masterTable.getSelectedRows(); List<TblEntidades> toRemove = new ArrayList<>(selected.length); TblEntidades t; for (Integer idx = 0; idx < selected.length; idx++) { t = list.get(masterTable.convertRowIndexToModel(selected[idx])); if ((Long) (entityManager .createQuery("select count(evd) from TblEventoDetalle evd where evd.idEntidad.id = " + t.getId().toString()) .getSingleResult()) == 0L) { toRemove.add(t); entityManager.remove(t); } else { JOptionPane.showMessageDialog(null, "El miembro seleccionado tiene registros."); } } //list.removeAll(toRemove); list.removeAll(new HashSet<>(toRemove)); } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } }//GEN-LAST:event_deleteButtonActionPerformed private void newButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_newButtonActionPerformed try { TblEntidades t = new TblEntidades(); entityManager.persist(t); t.setIdUser(currentUser.getUser()); t.setIsMiembroActivo(false); t.setAporteMensual(0); t.setIdFormaDePagoPreferida(listFormasDePago.get(0)); list.add(t); Integer row = list.size() - 1; masterTable.setRowSelectionInterval(row, row); masterTable.scrollRectToVisible(masterTable.getCellRect(row, 0, true)); } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } }//GEN-LAST:event_newButtonActionPerformed private void saveButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_saveButtonActionPerformed try { entityManager.getTransaction().commit(); entityManager.getTransaction().begin(); java.util.List data = query.getResultList(); data.stream().forEach((entity) -> { entityManager.refresh(entity); }); list.clear(); list.addAll(data); } catch (RollbackException ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); entityManager.getTransaction().begin(); List<TblEntidades> merged = new ArrayList<>(list.size()); list.stream().forEach((t) -> { merged.add(entityManager.merge(t)); }); list.clear(); list.addAll(merged); } catch (Exception exx) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + exx.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), exx); } }//GEN-LAST:event_saveButtonActionPerformed private void formInternalFrameActivated(javax.swing.event.InternalFrameEvent evt) {//GEN-FIRST:event_formInternalFrameActivated }//GEN-LAST:event_formInternalFrameActivated @SuppressWarnings("unchecked") private void refreshButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_refreshButtonActionPerformed try { entityManager.getTransaction().rollback(); entityManager.getTransaction().begin(); java.util.List data = query.getResultList(); data.stream().forEach((entity) -> { entityManager.refresh(entity); }); list.clear(); list.addAll(data); } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } }//GEN-LAST:event_refreshButtonActionPerformed private void ctacteField1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ctacteField1ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_ctacteField1ActionPerformed private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed try { JFileChooser fc = new JFileChooser(); Integer returnVal = fc.showOpenDialog(this); if (returnVal == JFileChooser.APPROVE_OPTION) { File file = fc.getSelectedFile(); POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(file)); HSSFWorkbook wb = new HSSFWorkbook(fs); HSSFSheet sheet = wb.getSheetAt(0); HSSFRow row; HSSFCell cell; Integer rows; // No of rows rows = sheet.getPhysicalNumberOfRows(); Integer cols = 0; // No of columns Integer tmp = 0; // This trick ensures that we get the data properly even if it doesn't start from first few rows for (Integer i = 0; i < 10 || i < rows; i++) { row = sheet.getRow(i); if (row != null) { tmp = sheet.getRow(i).getPhysicalNumberOfCells(); if (tmp > cols) { cols = tmp; } } } for (Integer r = 1; r <= rows; r++) { row = sheet.getRow(r); if (row != null) { if (!row.getCell(0).getStringCellValue().equals("")) { TblEntidades miembro = new TblEntidades(); miembro.setNombres(row.getCell(0).getStringCellValue()); if (row.getCell(1) != null) { miembro.setApellidos(row.getCell(1).getStringCellValue()); } else { miembro.setApellidos(""); } if (row.getCell(2).getCellType() == Cell.CELL_TYPE_STRING) { if (row.getCell(2).getStringCellValue().replaceAll("[^\\d.]", "").equals("")) { miembro.setCtacte(99999); } else { miembro.setCtacte(Integer.valueOf( row.getCell(2).getStringCellValue().replaceAll("[^\\d.]", ""))); } } else if (row.getCell(2).getCellType() == Cell.CELL_TYPE_NUMERIC) { miembro.setCtacte((int) (row.getCell(2).getNumericCellValue())); } List<TblEntidades> duplicadoList = entityManager.createQuery( "SELECT t FROM TblEntidades t where t.nombres = '" + miembro.getNombres() + "' and t.apellidos = '" + miembro.getApellidos() + "' and t.ctacte = " + miembro.getCtacte().toString(), TblEntidades.class).getResultList(); if (duplicadoList.size() > 0) { miembro = null; miembro = duplicadoList.get(0); } if (row.getCell(3) != null) { DecimalFormat df = new DecimalFormat("#0"); miembro.setRucSinDv(df.format(row.getCell(3).getNumericCellValue())); if (miembro.getRucSinDv().equals("0")) { miembro.setRucSinDv("44444401"); } } if (row.getCell(4) != null) { miembro.setDomicilio(row.getCell(4).getStringCellValue()); } if (row.getCell(5) != null) { miembro.setBox((int) row.getCell(5).getNumericCellValue()); } if (row.getCell(6) != null) { miembro.setFechaNacimiento( LocalDateTime.ofInstant(row.getCell(6).getDateCellValue().toInstant(), ZoneId.systemDefault()).toLocalDate()); } if (row.getCell(7) != null) { miembro.setFechaBautismo( LocalDateTime.ofInstant(row.getCell(7).getDateCellValue().toInstant(), ZoneId.systemDefault()).toLocalDate()); miembro.setIsMiembroActivo(true); } else { miembro.setIsMiembroActivo(false); } if (row.getCell(8) != null) { miembro.setFechaEntradaCongregacion( LocalDateTime.ofInstant(row.getCell(8).getDateCellValue().toInstant(), ZoneId.systemDefault()).toLocalDate()); } miembro.setAporteMensual(0); miembro.setIdFormaDePagoPreferida(listFormasDePago.get(0)); miembro.setIdUser(currentUser.getUser()); entityManager.persist(miembro); list.add(miembro); } } } } } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } }//GEN-LAST:event_jButton3ActionPerformed private void rucFieldKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_rucFieldKeyPressed }//GEN-LAST:event_rucFieldKeyPressed private void rucFieldKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_rucFieldKeyReleased }//GEN-LAST:event_rucFieldKeyReleased private void txtAporteBase1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtAporteBase1MouseClicked // TODO add your handling code here: }//GEN-LAST:event_txtAporteBase1MouseClicked private void txtAporteBase1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtAporteBase1ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_txtAporteBase1ActionPerformed private void cboFormaDePagoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cboFormaDePagoActionPerformed // TODO add your handling code here: }//GEN-LAST:event_cboFormaDePagoActionPerformed private void txtCtaCteFocusGained(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_txtCtaCteFocusGained try { txtCtaCte.selectAll(); } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } // TODO add your handling code here: }//GEN-LAST:event_txtCtaCteFocusGained private void txtCtaCteInputMethodTextChanged(java.awt.event.InputMethodEvent evt) {//GEN-FIRST:event_txtCtaCteInputMethodTextChanged // TODO add your handling code here: }//GEN-LAST:event_txtCtaCteInputMethodTextChanged private void txtCtaCteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtCtaCteActionPerformed // TODO add your handling code here: }//GEN-LAST:event_txtCtaCteActionPerformed private void txtCtaCteKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_txtCtaCteKeyReleased try { txtCtaCte.setBackground(Color.white); if (txtCtaCte.getText().length() > 4) { List<TblEntidades> listE = list; Optional<TblEntidades> value = listE.stream() .filter(a -> a.getCtacte().equals(Integer.valueOf(txtCtaCte.getText()))).findFirst(); if (value.isPresent()) { cboEntidad.setSelectedItem(value.get()); txtCtaCte.setBackground(Color.green); rucField.requestFocus(); } } } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } // TODO add your handling code here: }//GEN-LAST:event_txtCtaCteKeyReleased private void cboEntidadActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cboEntidadActionPerformed /*if (cboEntidad.getSelectedItem() != null) { txtCtaCte.setText(((TblEntidades) cboEntidad.getSelectedItem()).getCtacte().toString()); } else { txtCtaCte.setText(""); }*/ }//GEN-LAST:event_cboEntidadActionPerformed private void txtAporteBase2MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_txtAporteBase2MouseClicked // TODO add your handling code here: }//GEN-LAST:event_txtAporteBase2MouseClicked private void txtAporteBase2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtAporteBase2ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_txtAporteBase2ActionPerformed private void cmdBorrarCategoriaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdBorrarCategoriaActionPerformed try { Integer index = masterTable.getSelectedRow(); TblEntidades T = list.get(masterTable.convertRowIndexToModel(index)); List<TblEntidadesHistoricoCategorias> ts = T.getTblEntidadesHistoricoCategoriasList(); int[] selected = categoriasTable.getSelectedRows(); List<TblEntidadesHistoricoCategorias> toRemove = new ArrayList<>(selected.length); for (Integer idx = 0; idx < selected.length; idx++) { selected[idx] = categoriasTable.convertRowIndexToModel(selected[idx]); Integer count = 0; Iterator<TblEntidadesHistoricoCategorias> iter = ts.iterator(); while (count++ < selected[idx]) { iter.next(); } TblEntidadesHistoricoCategorias t = iter.next(); toRemove.add(t); entityManager.remove(t); } ts.removeAll(toRemove); categoriasTable.clearSelection(); masterTable.clearSelection(); masterTable.setRowSelectionInterval(index, index); } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } }//GEN-LAST:event_cmdBorrarCategoriaActionPerformed private void cmdAddCategoriaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdAddCategoriaActionPerformed try { Integer index = masterTable.getSelectedRow(); TblEntidades T = list.get(masterTable.convertRowIndexToModel(index)); List<TblEntidadesHistoricoCategorias> ts = T.getTblEntidadesHistoricoCategoriasList(); if (ts == null) { ts = new LinkedList<>(); T.setTblEntidadesHistoricoCategoriasList((List) ts); } TblEntidadesHistoricoCategorias t = new TblEntidadesHistoricoCategorias(); t.setIdEntidad(T); //t.setAnoMes(LocalDate.now().getYear() * 100 + LocalDate.now().getMonth().getValue()); t.setFecha(LocalDate.ofYearDay(LocalDate.now().getYear(), 1)); ts.add(t); entityManager.merge(T); masterTable.clearSelection(); masterTable.setRowSelectionInterval(index, index); Integer row = T.getTblEntidadesHistoricoCategoriasList().size() - 1; categoriasTable.setRowSelectionInterval(row, row); categoriasTable.scrollRectToVisible(categoriasTable.getCellRect(row, 0, true)); if (categoriasTable.getColumnModel().getColumnCount() > 0 && categoriasTable.getRowCount() == 1) { categoriasTable.getColumnModel().getColumn(0).setCellRenderer(anoMesCellRenderer1); categoriasTable.getColumnModel().getColumn(1).setCellEditor(new DefaultCellEditor(cboCategoria)); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } }//GEN-LAST:event_cmdAddCategoriaActionPerformed private void cmdBorrarImporteAporteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdBorrarImporteAporteActionPerformed try { Integer index = masterTable.getSelectedRow(); TblEntidades T = list.get(masterTable.convertRowIndexToModel(index)); List<TblAportesImporteMensualSaldoAnterior> ts = T.getTblAportesImporteMensualSaldoAnteriorList(); int[] selected = aportesImportesTable.getSelectedRows(); List<TblAportesImporteMensualSaldoAnterior> toRemove = new ArrayList<>(selected.length); for (Integer idx = 0; idx < selected.length; idx++) { selected[idx] = aportesImportesTable.convertRowIndexToModel(selected[idx]); Integer count = 0; Iterator<TblAportesImporteMensualSaldoAnterior> iter = ts.iterator(); while (count++ < selected[idx]) { iter.next(); } TblAportesImporteMensualSaldoAnterior t = iter.next(); toRemove.add(t); entityManager.remove(t); } ts.removeAll(toRemove); aportesImportesTable.clearSelection(); masterTable.clearSelection(); masterTable.setRowSelectionInterval(index, index); } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } }//GEN-LAST:event_cmdBorrarImporteAporteActionPerformed private void cmdAddImporteAporteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdAddImporteAporteActionPerformed try { Integer index = masterTable.getSelectedRow(); TblEntidades T = list.get(masterTable.convertRowIndexToModel(index)); List<TblAportesImporteMensualSaldoAnterior> ts = T.getTblAportesImporteMensualSaldoAnteriorList(); if (ts == null) { ts = new LinkedList<>(); T.setTblAportesImporteMensualSaldoAnteriorList((List) ts); } TblAportesImporteMensualSaldoAnterior t = new TblAportesImporteMensualSaldoAnterior(); t.setIdEntidad(T); t.setImporteMensual(0); t.setSaldoAnterior(0); t.setAno(LocalDate.now().getYear()); ts.add(t); entityManager.merge(T); masterTable.clearSelection(); masterTable.setRowSelectionInterval(index, index); Integer row = T.getTblAportesImporteMensualSaldoAnteriorList().size() - 1; aportesImportesTable.setRowSelectionInterval(row, row); aportesImportesTable.scrollRectToVisible(aportesImportesTable.getCellRect(row, 0, true)); if (aportesImportesTable.getColumnModel().getColumnCount() > 0 && aportesImportesTable.getRowCount() == 1) { aportesImportesTable.getColumnModel().getColumn(0).setCellRenderer(numberCellRenderer1); aportesImportesTable.getColumnModel().getColumn(1).setCellRenderer(numberCellRenderer1); aportesImportesTable.getColumnModel().getColumn(2).setCellRenderer(numberCellRenderer1); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, Thread.currentThread().getStackTrace()[1].getMethodName() + " - " + ex.getMessage()); LOGGER.error(Thread.currentThread().getStackTrace()[1].getMethodName(), ex); } }//GEN-LAST:event_cmdAddImporteAporteActionPerformed // Variables declaration - do not modify//GEN-BEGIN:variables private com.gnadenheimer.mg.utils.AnoMesCellRenderer anoMesCellRenderer1; private javax.swing.JTextField apellidosField; private javax.swing.JTable aportesImportesTable; private javax.swing.JTable categoriasTable; private javax.swing.JComboBox cboEntidad; private javax.swing.JComboBox cboFormaDePago; private javax.swing.JButton cmdAddCategoria; private javax.swing.JButton cmdAddImporteAporte; private javax.swing.JButton cmdBorrarCategoria; private javax.swing.JButton cmdBorrarImporteAporte; private com.gnadenheimer.mg.utils.CtaCteTableCellRenderer ctaCteTableCellRenderer1; private javax.swing.JTextField ctacteField; private javax.swing.JTextField ctacteField1; private javax.swing.JLabel ctacteLabel; private javax.swing.JLabel ctacteLabel1; private javax.swing.JLabel ctacteLabel2; private javax.swing.JLabel ctacteLabel3; private javax.swing.JLabel ctacteLabel6; private javax.swing.JLabel ctacteLabel7; private com.gnadenheimer.mg.utils.DateTableCellRenderer dateTableCellRenderer1; private javax.swing.JButton deleteButton; private javax.swing.JTextField direccionField; private javax.swing.JLabel direccionLabel; private javax.swing.JLabel direccionLabel1; private com.github.lgooddatepicker.components.DatePicker dtpFechaBautismo; private com.github.lgooddatepicker.components.DatePicker dtpFechaCongregacion; private com.github.lgooddatepicker.components.DatePicker dtpFechaDefuncion; private com.github.lgooddatepicker.components.DatePicker dtpFechaDescongregacion; private com.github.lgooddatepicker.components.DatePicker dtpFechaNacimiento; private javax.persistence.EntityManager entityManager; private javax.swing.JLabel idCategoriaLabel; private javax.swing.JTextField idField; private javax.swing.JLabel idLabel; private javax.swing.JLabel idMiembroLabel; private javax.swing.JLabel idMiembroLabel1; private javax.swing.JLabel idMiembroLabel2; private com.gnadenheimer.mg.utils.IntegerLongConverter integerLongConverter1; private javax.swing.JButton jButton3; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JScrollPane jScrollPane2; private java.util.List<com.gnadenheimer.mg.domain.miembros.TblEntidades> list; private java.util.List<com.gnadenheimer.mg.domain.miembros.TblMiembrosAlergias> listAlergia; private java.util.List<com.gnadenheimer.mg.domain.miembros.TblAreasServicioEnIglesia> listAreaServicio; private java.util.List<com.gnadenheimer.mg.domain.miembros.TblMiembrosCategoriasDePago> listCategoria; private java.util.List<com.gnadenheimer.mg.domain.TblFormasDePago> listFormasDePago; private javax.swing.JScrollPane masterScrollPane; private javax.swing.JTable masterTable; private javax.swing.JLabel montoLabel2; private javax.swing.JLabel montoLabel6; private javax.swing.JLabel montoLabel7; private javax.swing.JButton newButton; private javax.swing.JTextField nombreField; private javax.swing.JLabel nombreLabel; private javax.swing.JLabel nombreLabel1; private javax.swing.JLabel nombreLabel2; private javax.swing.JLabel nombreLabel3; private javax.swing.JLabel nombreLabel4; private javax.swing.JLabel nombreLabel5; private javax.swing.JLabel nombreLabel7; private com.gnadenheimer.mg.utils.NumberCellRenderer numberCellRenderer1; private javax.persistence.Query query; private javax.persistence.Query queryAlergia; private javax.persistence.Query queryAreaServicio; private javax.persistence.Query queryCategoria; private javax.persistence.Query queryFormasDePago; private javax.swing.JButton refreshButton; private javax.swing.JTextField rucField; private com.gnadenheimer.mg.utils.RucTableCellRenderer rucTableCellRenderer1; private javax.swing.JButton saveButton; private javax.swing.JFormattedTextField txtAporteBase1; private javax.swing.JFormattedTextField txtAporteBase2; private javax.swing.JTextField txtCtaCte; private javax.swing.JTextField txtRazonSocial; private org.jdesktop.beansbinding.BindingGroup bindingGroup; // End of variables declaration//GEN-END:variables public static void main(String[] args) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { javax.swing.UIManager.setLookAndFeel(javax.swing.UIManager.getSystemLookAndFeelClassName()); } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(FrameEntidadesAdmin.class.getName()) .log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(FrameEntidadesAdmin.class.getName()) .log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(FrameEntidadesAdmin.class.getName()) .log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(FrameEntidadesAdmin.class.getName()) .log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> //</editor-fold> //</editor-fold> //</editor-fold> //</editor-fold> //</editor-fold> //</editor-fold> //</editor-fold> /* Create and display the form */ EventQueue.invokeLater(new Runnable() { public void run() { JFrame frame = new JFrame(); frame.setContentPane(new FrameEntidadesAdmin()); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.pack(); frame.setVisible(true); } }); } }