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 Contabilidad; import Clientes.altaCliente; import Clientes.buscaCliente; import Compania.buscaCompania; import Hibernate.Util.HibernateUtil; import Hibernate.entidades.Adicionales; import Hibernate.entidades.Clientes; import Hibernate.entidades.Compania; import Hibernate.entidades.Concepto; import Hibernate.entidades.Configuracion; import Hibernate.entidades.Factura; import Hibernate.entidades.Marca; import Hibernate.entidades.Orden; import Hibernate.entidades.OrdenExterna; import Hibernate.entidades.Partida; import Hibernate.entidades.PartidaExterna; import Hibernate.entidades.Tipo; import Hibernate.entidades.Usuario; import Integral.Conexion; import Integral.ExtensionFileFilter; import Integral.FormatoEditor; import Servicios.buscaOrden; import java.awt.Color; import java.awt.Dimension; import java.awt.Frame; import java.awt.Toolkit; import java.awt.event.KeyEvent; import java.util.Calendar; import java.util.Vector; import javax.swing.ImageIcon; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import javax.swing.table.JTableHeader; import javax.swing.table.TableColumn; import javax.swing.table.TableColumnModel; import org.hibernate.HibernateException; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.criterion.Order; import org.hibernate.criterion.Restrictions; import Integral.FormatoTabla; import Integral.Herramientas; import Integral.Render1; import Marca.buscaMarca; import Tipo.buscaTipo; import java.io.File; import java.io.FileInputStream; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.HashSet; import java.util.Iterator; import javax.swing.DefaultCellEditor; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.poifs.filesystem.POIFSFileSystem; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; /** * * @author salvador */ public class FacturarOrdenLogis extends javax.swing.JPanel { String[] columnas = new String[] { "Can", "Med", "Descripcin", "N Parte", "Costo c/u", "Descuento", "Total" }; FormatoTabla formato; Usuario user; String sessionPrograma; Herramientas h; DefaultTableModel model; int iva = 0; Factura factura = new Factura(); String id_marca = ""; Conexion mysql; ArrayList orden; Orden orden_act; /** * Creates new form altaFactura */ public FacturarOrdenLogis(Usuario u, String ses) { initComponents(); user = u; sessionPrograma = ses; formato = new FormatoTabla(); formatoTabla(); b_orden.setVisible(false); t_iva1.setValue(16); t_iva1.setText("16"); try { t_iva.commitEdit(); } catch (Exception e) { } ; } /** * 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() { alerta = new javax.swing.JDialog(); jLabel21 = new javax.swing.JLabel(); progreso = new javax.swing.JProgressBar(); addendas = new javax.swing.JDialog(); jLabel24 = new javax.swing.JLabel(); jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jButton4 = new javax.swing.JButton(); jButton5 = new javax.swing.JButton(); medida = new javax.swing.JComboBox(); t_receptor = new javax.swing.JTextField(); t_email = new javax.swing.JTextField(); aviso = new javax.swing.JFileChooser(); jPanel1 = new javax.swing.JPanel(); p_cliente = new javax.swing.JPanel(); Selecciona2 = new javax.swing.JButton(); c_cliente = new javax.swing.JComboBox(); b_buscar = new javax.swing.JButton(); t_rfc = new javax.swing.JTextField(); t_cp = new javax.swing.JTextField(); jLabel9 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); t_cliente = new javax.swing.JTextField(); t_direccion = new javax.swing.JTextField(); jLabel3 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); t_colonia = new javax.swing.JTextField(); jLabel6 = new javax.swing.JLabel(); t_numero_exterior = new javax.swing.JTextField(); jLabel23 = new javax.swing.JLabel(); c_pais = new javax.swing.JComboBox(); jLabel8 = new javax.swing.JLabel(); c_estado = new javax.swing.JComboBox(); jLabel7 = new javax.swing.JLabel(); t_municipio = new javax.swing.JTextField(); jLabel11 = new javax.swing.JLabel(); t_id = new javax.swing.JTextField(); b_actualiza = new javax.swing.JButton(); p_orden = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); t_orden = new javax.swing.JTextField(); b_orden = new javax.swing.JButton(); l_asegurado = new javax.swing.JLabel(); t_asegurado = new javax.swing.JTextField(); jLabel12 = new javax.swing.JLabel(); t_marca = new javax.swing.JTextField(); t_tipo = new javax.swing.JTextField(); jLabel13 = new javax.swing.JLabel(); t_serie = new javax.swing.JTextField(); jLabel14 = new javax.swing.JLabel(); jLabel15 = new javax.swing.JLabel(); t_modelo = new javax.swing.JTextField(); jLabel16 = new javax.swing.JLabel(); t_placas = new javax.swing.JTextField(); jLabel17 = new javax.swing.JLabel(); t_poliza = new javax.swing.JTextField(); jLabel18 = new javax.swing.JLabel(); t_siniestro = new javax.swing.JTextField(); jLabel19 = new javax.swing.JLabel(); t_reporte = new javax.swing.JTextField(); jLabel20 = new javax.swing.JLabel(); t_inc = new javax.swing.JTextField(); b_marca = new javax.swing.JButton(); b_tipo = new javax.swing.JButton(); l_marca = new javax.swing.JTextField(); t_km = new javax.swing.JTextField(); jLabel25 = new javax.swing.JLabel(); p_totales = new javax.swing.JPanel(); b_guardar = new javax.swing.JButton(); jPanel5 = new javax.swing.JPanel(); l_subtotal = new javax.swing.JLabel(); t_subtotal = new javax.swing.JFormattedTextField(); t_iva = new javax.swing.JFormattedTextField(); l_iva = new javax.swing.JLabel(); l_total = new javax.swing.JLabel(); t_total = new javax.swing.JFormattedTextField(); t_iva1 = new javax.swing.JFormattedTextField(); t_descuento = new javax.swing.JFormattedTextField(); l_iva1 = new javax.swing.JLabel(); jLabel22 = new javax.swing.JLabel(); t_noFactura = new javax.swing.JTextField(); b_mas = new javax.swing.JButton(); b_menos = new javax.swing.JButton(); l_iva2 = new javax.swing.JLabel(); t_extra = new javax.swing.JTextField(); jButton3 = new javax.swing.JButton(); jScrollPane1 = new javax.swing.JScrollPane(); t_datos = new javax.swing.JTable(); alerta.setTitle("Conectando"); alerta.setModalExclusionType(null); alerta.setModalityType(null); jLabel21.setFont(new java.awt.Font("Droid Sans", 3, 14)); // NOI18N jLabel21.setText("Generar Factura Electronica"); javax.swing.GroupLayout alertaLayout = new javax.swing.GroupLayout(alerta.getContentPane()); alerta.getContentPane().setLayout(alertaLayout); alertaLayout.setHorizontalGroup(alertaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(alertaLayout.createSequentialGroup().addContainerGap().addComponent(jLabel21) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, alertaLayout.createSequentialGroup() .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(progreso, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(31, 31, 31))); alertaLayout.setVerticalGroup(alertaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(alertaLayout.createSequentialGroup().addContainerGap().addComponent(jLabel21) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(progreso, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))); addendas.setTitle("Facturacion Electrnica"); addendas.setModalityType(java.awt.Dialog.ModalityType.APPLICATION_MODAL); jLabel24.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N jLabel24.setText("Selecciona el tipo de Addenda a utilizar para facturar"); jButton1.setFont(new java.awt.Font("Arial", 0, 11)); // NOI18N jButton1.setText("Qualitas Talleres"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jButton2.setFont(new java.awt.Font("Arial", 0, 11)); // NOI18N jButton2.setText("Axa Talleres"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jButton4.setFont(new java.awt.Font("Arial", 0, 11)); // NOI18N jButton4.setText("GNP Talleres"); jButton4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton4ActionPerformed(evt); } }); jButton5.setFont(new java.awt.Font("Arial", 0, 11)); // NOI18N jButton5.setText("General"); jButton5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton5ActionPerformed(evt); } }); javax.swing.GroupLayout addendasLayout = new javax.swing.GroupLayout(addendas.getContentPane()); addendas.getContentPane().setLayout(addendasLayout); addendasLayout.setHorizontalGroup(addendasLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(addendasLayout.createSequentialGroup().addContainerGap().addGroup(addendasLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(jLabel24) .addGroup(addendasLayout.createSequentialGroup().addGap(42, 42, 42) .addGroup(addendasLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false) .addComponent(jButton2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton1, javax.swing.GroupLayout.Alignment.LEADING)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(addendasLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 98, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 98, javax.swing.GroupLayout.PREFERRED_SIZE)))) .addContainerGap(13, Short.MAX_VALUE))); addendasLayout.setVerticalGroup(addendasLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(addendasLayout.createSequentialGroup().addContainerGap().addComponent(jLabel24) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(addendasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton1).addComponent(jButton5)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(addendasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton2).addComponent(jButton4)) .addContainerGap(22, Short.MAX_VALUE))); addendas.getAccessibleContext().setAccessibleParent(null); medida.setFont(new java.awt.Font("Dialog", 0, 9)); // NOI18N medida.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "PZAS", "LTS", "MTS", "CMS", "MMS", "GRS", "MLS", "KGS", "HRS", "MIN", "KIT", "FT", "LB", "JGO", "NA" })); t_receptor.setText("jTextField1"); t_email.setText("jTextField2"); aviso.setDialogType(javax.swing.JFileChooser.SAVE_DIALOG); aviso.setDialogTitle("Examinar"); setLayout(new java.awt.BorderLayout()); jPanel1.setBackground(new java.awt.Color(254, 254, 254)); p_cliente.setBackground(new java.awt.Color(254, 254, 254)); p_cliente.setBorder(javax.swing.BorderFactory.createTitledBorder( new javax.swing.border.LineBorder(new java.awt.Color(0, 0, 0), 1, true), "Datos del cliente", javax.swing.border.TitledBorder.RIGHT, javax.swing.border.TitledBorder.TOP)); Selecciona2.setBackground(new java.awt.Color(2, 135, 242)); Selecciona2.setForeground(new java.awt.Color(254, 254, 254)); Selecciona2.setText("Nuevo cliente"); Selecciona2.setToolTipText("Agregar un registo actual"); Selecciona2.setFocusable(false); Selecciona2.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); Selecciona2.setMaximumSize(new java.awt.Dimension(87, 23)); Selecciona2.setMinimumSize(new java.awt.Dimension(87, 23)); Selecciona2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { Selecciona2ActionPerformed(evt); } }); c_cliente.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Compaia", "Cliente" })); c_cliente.setToolTipText("Tipo de receptor a buscar"); c_cliente.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { c_clienteActionPerformed(evt); } }); b_buscar.setText("Buscar"); b_buscar.setToolTipText("Consultar datos de cliente o compaia"); b_buscar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { b_buscarActionPerformed(evt); } }); t_rfc.setToolTipText("RFC del receptor"); t_rfc.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_rfc.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_rfcKeyTyped(evt); } }); t_cp.setToolTipText("Codigo postal del receptor"); t_cp.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_cp.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_cpKeyTyped(evt); } }); jLabel9.setForeground(new java.awt.Color(13, 132, 254)); jLabel9.setText("CP:"); jLabel5.setForeground(new java.awt.Color(13, 132, 254)); jLabel5.setText("RFC:"); t_cliente.setToolTipText("Razn social del receptor"); t_cliente.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_cliente.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_clienteKeyTyped(evt); } }); t_direccion.setToolTipText("Calle del receptor"); t_direccion.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_direccion.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_direccionKeyTyped(evt); } }); jLabel3.setForeground(new java.awt.Color(13, 132, 254)); jLabel3.setText("Dir:"); jLabel2.setText("R.social"); jLabel4.setText("Colonia:"); t_colonia.setToolTipText("Colonia del receptor"); t_colonia.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_colonia.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_coloniaKeyTyped(evt); } }); jLabel6.setForeground(new java.awt.Color(13, 132, 254)); jLabel6.setText("Municipio:"); t_numero_exterior.setToolTipText("Nmero exterior del emisor"); t_numero_exterior.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_numero_exterior.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_numero_exteriorKeyTyped(evt); } }); jLabel23.setForeground(new java.awt.Color(13, 132, 254)); jLabel23.setText("No Ex:"); c_pais.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "AD", "AE", "AF", "AG", "AI", "AL", "AM", "AN", "AO", "AQ", "AR", "AS", "AT", "AU", "AW", "AX", "AZ", "BA", "BB", "BD", "BE", "BF", "BG", "BH", "BI", "BJ", "BL", "BM", "BN", "BO", "BR", "BS", "BT", "BV", "BW", "BY", "BZ", "CA", "CC", "CD", "CF", "CG", "CH", "CI", "CK", "CL", "CM", "CN", "CO", "CR", "CU", "CV", "CX", "CY", "CZ", "DE", "DJ", "DK", "DM", "DO", "DZ", "EC", "EE", "EG", "EH", "ER", "ES", "ET", "FI", "FJ", "FK", "FM", "FO", "FR", "GA", "GB", "GD", "GE", "GF", "GG", "GH", "GI", "GL", "GM", "GN", "GP", "GQ", "GR", "GS", "GT", "GU", "GW", "GY", "HK", "HM", "HN", "HR", "HT", "HU", "ID", "IE", "IL", "IM", "IN", "IO", "IQ", "IR", "IS", "IT", "JE", "JM", "JO", "JP", "KE", "KG", "KH", "KI", "KM", "KN", "KP", "KR", "KW", "KY", "KZ", "LA", "LB", "LC", "LI", "LK", "LR", "LS", "LT", "LU", "LV", "LY", "MA", "MC", "MD", "ME", "MF", "MG", "MH", "MK", "ML", "MM", "MN", "MO", "MP", "MQ", "MR", "MS", "MT", "MU", "MV", "MW", "MX", "MY", "MZ", "NA", "NC", "NE", "NF", "NG", "NI", "NL", "NO", "NP", "NR", "NU", "NZ", "OM", "PA", "PE", "PF", "PG", "PH", "PK", "PL", "PM", "PN", "PR", "PS", "PT", "PW", "PY", "QA", "RE", "RO", "RS", "RU", "RW", "SA", "SB", "SC", "SD", "SE", "SG", "SH", "SI", "SJ", "SK", "SL", "SM", "SN", "SO", "SR", "ST", "SV", "SY", "SZ", "TC", "TD", "TF", "TG", "TH", "TJ", "TK", "TL", "TM", "TN", "TO", "TR", "TT", "TV", "TW", "TZ", "UA", "UG", "UM", "US", "UY", "UZ", "VA", "VC", "VE", "VG", "VI", "VN", "VU", "WF", "WS", "YE", "YT", "ZA", "ZM", "ZW" })); c_pais.setSelectedItem("MX"); c_pais.setToolTipText("Pais del receptor"); jLabel8.setForeground(new java.awt.Color(13, 132, 254)); jLabel8.setText("Pais:"); c_estado.setModel(new javax.swing.DefaultComboBoxModel( new String[] { "AGUASCALIENTES", "BAJA CALIFORNIA", "BAJA CALIFORNIA SUR", "CAMPECHE", "CHIAPAS", "CHIHUAHUA", "COAHUILA", "COLIMA", "DISTRITO FEDERAL", "DURANGO", "ESTADO DE MEXICO", "GUANAJUATO", "GUERRERO", "HIDALGO", "JALISCO", "MICHOACAN", "MORELOS", "NAYARIT", "NUEVO LEON", "OAXACA", "PUEBLA", "QUERETARO", "QUINTANA ROO", "SAN LUIS POTOSI", "SINALOA", "SONORA", "TABASCO", "TAMAULIPAS", "TLAXCALA", "VERACRUZ", "YUCATAN", "ZACATECAS" })); c_estado.setToolTipText("Estado del receptor"); jLabel7.setForeground(new java.awt.Color(13, 132, 254)); jLabel7.setText("Estado:"); t_municipio.setToolTipText("Municipio del receptor"); t_municipio.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_municipio.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_municipioKeyTyped(evt); } }); jLabel11.setText("Id:"); t_id.setToolTipText("Numero de compaia o cliente"); t_id.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_id.setEnabled(false); b_actualiza.setBackground(new java.awt.Color(2, 135, 242)); b_actualiza.setFont(new java.awt.Font("Arial", 0, 12)); // NOI18N b_actualiza.setForeground(new java.awt.Color(254, 254, 254)); b_actualiza.setIcon(new ImageIcon("imagenes/guardar.png")); b_actualiza.setText("Actualizar"); b_actualiza.setToolTipText("Actualizar datos del cliente"); b_actualiza.setEnabled(false); b_actualiza.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { b_actualizaActionPerformed(evt); } }); javax.swing.GroupLayout p_clienteLayout = new javax.swing.GroupLayout(p_cliente); p_cliente.setLayout(p_clienteLayout); p_clienteLayout.setHorizontalGroup(p_clienteLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, p_clienteLayout.createSequentialGroup() .addContainerGap() .addGroup(p_clienteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_clienteLayout.createSequentialGroup().addGroup(p_clienteLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(p_clienteLayout.createSequentialGroup().addComponent(jLabel4) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_colonia, javax.swing.GroupLayout.PREFERRED_SIZE, 220, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(p_clienteLayout.createSequentialGroup().addComponent(jLabel7) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(c_estado, javax.swing.GroupLayout.PREFERRED_SIZE, 220, javax.swing.GroupLayout.PREFERRED_SIZE))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_clienteLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel6).addComponent(jLabel8)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_clienteLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_clienteLayout.createSequentialGroup() .addComponent(c_pais, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel23) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_numero_exterior, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE)) .addComponent(t_municipio, javax.swing.GroupLayout.PREFERRED_SIZE, 192, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGroup(p_clienteLayout.createSequentialGroup() .addGroup(p_clienteLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel3).addComponent(jLabel2)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_clienteLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(t_cliente, javax.swing.GroupLayout.PREFERRED_SIZE, 318, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(t_direccion, javax.swing.GroupLayout.PREFERRED_SIZE, 318, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(p_clienteLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, p_clienteLayout.createSequentialGroup() .addComponent(jLabel5) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_rfc, javax.swing.GroupLayout.PREFERRED_SIZE, 113, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, p_clienteLayout.createSequentialGroup() .addComponent(jLabel9) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_cp, javax.swing.GroupLayout.PREFERRED_SIZE, 113, javax.swing.GroupLayout.PREFERRED_SIZE)))) .addGroup(p_clienteLayout.createSequentialGroup().addComponent(jLabel11) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_id, javax.swing.GroupLayout.PREFERRED_SIZE, 113, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(59, 59, 59).addComponent(b_actualiza).addGap(12, 12, 12) .addComponent(Selecciona2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(c_cliente, javax.swing.GroupLayout.PREFERRED_SIZE, 136, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(b_buscar))) .addContainerGap())); p_clienteLayout.setVerticalGroup(p_clienteLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_clienteLayout.createSequentialGroup().addGroup(p_clienteLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_clienteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(b_actualiza).addComponent(jLabel11).addComponent(t_id, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(p_clienteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(c_cliente, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(b_buscar).addComponent(Selecciona2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_clienteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel2) .addComponent(t_cliente, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel5).addComponent(t_rfc, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_clienteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel3) .addComponent(t_direccion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel9).addComponent(t_cp, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_clienteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel4) .addComponent(t_colonia, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel6).addComponent(t_municipio, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_clienteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel7).addComponent(jLabel8) .addComponent(c_estado, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(c_pais, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel23).addComponent(t_numero_exterior, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(0, 0, Short.MAX_VALUE))); p_orden.setBackground(new java.awt.Color(254, 254, 254)); p_orden.setBorder(javax.swing.BorderFactory.createTitledBorder( new javax.swing.border.LineBorder(new java.awt.Color(0, 0, 0), 1, true), "Datos de la Orden", javax.swing.border.TitledBorder.RIGHT, javax.swing.border.TitledBorder.TOP)); jLabel1.setForeground(new java.awt.Color(13, 132, 254)); jLabel1.setText("No:"); t_orden.setToolTipText("Nmero de orden"); t_orden.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_orden.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { t_ordenActionPerformed(evt); } }); t_orden.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_ordenKeyTyped(evt); } public void keyReleased(java.awt.event.KeyEvent evt) { t_ordenKeyReleased(evt); } }); b_orden.setBackground(new java.awt.Color(2, 135, 242)); b_orden.setIcon(new ImageIcon("imagenes/buscar.png")); b_orden.setMnemonic(KeyEvent.VK_F1); b_orden.setToolTipText("Buscar ordenes"); b_orden.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { b_ordenActionPerformed(evt); } }); l_asegurado.setText("Asegurado:"); t_asegurado.setToolTipText("Nombre del asegurado"); t_asegurado.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_asegurado.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { t_aseguradoFocusLost(evt); } }); t_asegurado.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { t_aseguradoActionPerformed(evt); } }); t_asegurado.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_aseguradoKeyTyped(evt); } }); jLabel12.setText("Marca:"); t_marca.setToolTipText("Marca de la unidad"); t_marca.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_marca.setEnabled(false); t_tipo.setToolTipText("Tipo de la unidad"); t_tipo.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_tipo.setEnabled(false); jLabel13.setText("Tipo:"); t_serie.setToolTipText("Numero serie de la unidad"); t_serie.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_serie.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { t_serieFocusLost(evt); } }); t_serie.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { t_serieActionPerformed(evt); } }); t_serie.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_serieKeyTyped(evt); } }); jLabel14.setText("Serie:"); jLabel15.setText("Modelo:"); t_modelo.setToolTipText("Modelo de la unidad"); t_modelo.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_modelo.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { t_modeloFocusLost(evt); } }); t_modelo.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { t_modeloActionPerformed(evt); } }); jLabel16.setText("Placas:"); t_placas.setToolTipText("Nmero de placas"); t_placas.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_placas.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { t_placasFocusLost(evt); } }); t_placas.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { t_placasActionPerformed(evt); } }); t_placas.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_placasKeyTyped(evt); } }); jLabel17.setText("Poliza:"); t_poliza.setToolTipText("Nmero de poliza"); t_poliza.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_poliza.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { t_polizaFocusLost(evt); } }); t_poliza.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { t_polizaActionPerformed(evt); } }); t_poliza.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_polizaKeyTyped(evt); } }); jLabel18.setText("Siniestro:"); t_siniestro.setToolTipText("Nmero de siniestro"); t_siniestro.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_siniestro.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { t_siniestroFocusLost(evt); } }); t_siniestro.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { t_siniestroActionPerformed(evt); } }); t_siniestro.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_siniestroKeyTyped(evt); } }); jLabel19.setText("Reporte:"); t_reporte.setToolTipText("Nmero de reporte"); t_reporte.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_reporte.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { t_reporteFocusLost(evt); } }); t_reporte.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { t_reporteActionPerformed(evt); } }); t_reporte.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_reporteKeyTyped(evt); } }); jLabel20.setText("INC:"); t_inc.setToolTipText("Nmero de inciso"); t_inc.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_inc.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { t_incFocusLost(evt); } }); t_inc.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { t_incActionPerformed(evt); } }); t_inc.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_incKeyTyped(evt); } }); b_marca.setBackground(new java.awt.Color(2, 135, 242)); b_marca.setIcon(new ImageIcon("imagenes/buscar.png")); b_marca.setToolTipText("Consultar marcas"); b_marca.setMaximumSize(new java.awt.Dimension(32, 8)); b_marca.setMinimumSize(new java.awt.Dimension(32, 8)); b_marca.setPreferredSize(new java.awt.Dimension(28, 24)); b_marca.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { b_marcaActionPerformed(evt); } }); b_tipo.setBackground(new java.awt.Color(2, 135, 242)); b_tipo.setIcon(new ImageIcon("imagenes/buscar.png")); b_tipo.setToolTipText("Consultar Tipos de vehculo"); b_tipo.setMargin(new java.awt.Insets(1, 14, 1, 14)); b_tipo.setMaximumSize(new java.awt.Dimension(28, 24)); b_tipo.setMinimumSize(new java.awt.Dimension(28, 24)); b_tipo.setPreferredSize(new java.awt.Dimension(28, 24)); b_tipo.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { b_tipoActionPerformed(evt); } }); l_marca.setToolTipText("Marca de la unidad"); l_marca.setBorder(javax.swing.BorderFactory.createEtchedBorder()); l_marca.setEnabled(false); t_km.setToolTipText("Nmero de inciso"); t_km.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_km.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { t_kmFocusLost(evt); } }); t_km.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { t_kmActionPerformed(evt); } }); t_km.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_kmKeyTyped(evt); } }); jLabel25.setText("Km:"); javax.swing.GroupLayout p_ordenLayout = new javax.swing.GroupLayout(p_orden); p_orden.setLayout(p_ordenLayout); p_ordenLayout.setHorizontalGroup(p_ordenLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_ordenLayout.createSequentialGroup().addContainerGap().addGroup(p_ordenLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_ordenLayout.createSequentialGroup().addComponent(jLabel1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_orden, javax.swing.GroupLayout.PREFERRED_SIZE, 84, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(b_orden, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel20) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_inc, javax.swing.GroupLayout.DEFAULT_SIZE, 58, Short.MAX_VALUE) .addGap(18, 18, 18).addComponent(jLabel25) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_km, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(p_ordenLayout.createSequentialGroup().addComponent(l_asegurado) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_asegurado)) .addGroup(p_ordenLayout.createSequentialGroup().addGroup(p_ordenLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, p_ordenLayout .createSequentialGroup().addComponent(jLabel18).addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_siniestro)) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, p_ordenLayout.createSequentialGroup().addComponent(jLabel16) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_placas)) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, p_ordenLayout .createSequentialGroup() .addGroup(p_ordenLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel14).addComponent(jLabel12)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_ordenLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_ordenLayout.createSequentialGroup() .addComponent(l_marca, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_marca) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(b_marca, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)) .addComponent(t_serie)))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_ordenLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_ordenLayout.createSequentialGroup().addGroup(p_ordenLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel19) .addComponent(jLabel17, javax.swing.GroupLayout.Alignment.TRAILING)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_ordenLayout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addComponent(t_poliza).addComponent(t_reporte))) .addGroup(p_ordenLayout.createSequentialGroup().addGroup(p_ordenLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel13).addComponent(jLabel15)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_ordenLayout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addComponent(t_modelo) .addGroup(p_ordenLayout.createSequentialGroup() .addComponent(t_tipo) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(b_tipo, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE))))))) .addContainerGap())); p_ordenLayout.setVerticalGroup(p_ordenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_ordenLayout.createSequentialGroup().addGroup(p_ordenLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_ordenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(t_orden, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel1).addComponent(b_orden, javax.swing.GroupLayout.PREFERRED_SIZE, 24, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(p_ordenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel25).addComponent(t_km, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(p_ordenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel20).addComponent(t_inc, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_ordenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(l_asegurado).addComponent(t_asegurado, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup( p_ordenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, p_ordenLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel12) .addComponent(t_marca, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel13) .addComponent(t_tipo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(l_marca, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addComponent(b_marca, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 24, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(b_tipo, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 24, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_ordenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel14) .addComponent(t_serie, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel15).addComponent(t_modelo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_ordenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel16) .addComponent(t_placas, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel17).addComponent(t_poliza, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_ordenLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel18) .addComponent(t_siniestro, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel19).addComponent(t_reporte, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap())); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addComponent(p_orden, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED).addComponent(p_cliente, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))); jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(p_cliente, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(p_orden, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)); add(jPanel1, java.awt.BorderLayout.PAGE_START); p_totales.setBackground(new java.awt.Color(2, 135, 242)); b_guardar.setIcon(new ImageIcon("imagenes/guardar.png")); b_guardar.setText("Guardar"); b_guardar.setToolTipText("Almacenar la factura"); b_guardar.setEnabled(false); b_guardar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { b_guardarActionPerformed(evt); } }); jPanel5.setBackground(new java.awt.Color(2, 135, 242)); jPanel5.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout()); l_subtotal.setFont(new java.awt.Font("Arial", 0, 9)); // NOI18N l_subtotal.setForeground(new java.awt.Color(255, 255, 255)); l_subtotal.setText("Subtotal:"); jPanel5.add(l_subtotal, new org.netbeans.lib.awtextra.AbsoluteConstraints(52, 4, -1, -1)); t_subtotal.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_subtotal.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory( new javax.swing.text.NumberFormatter(new java.text.DecimalFormat("#,##0.00")))); t_subtotal.setHorizontalAlignment(javax.swing.JTextField.RIGHT); t_subtotal.setText("0.00"); t_subtotal.setToolTipText("subtotal antes de IVA"); t_subtotal.setEnabled(false); t_subtotal.setFont(new java.awt.Font("Arial", 0, 11)); // NOI18N jPanel5.add(t_subtotal, new org.netbeans.lib.awtextra.AbsoluteConstraints(105, 0, 88, -1)); t_iva.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_iva.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory( new javax.swing.text.NumberFormatter(new java.text.DecimalFormat("#,##0.00")))); t_iva.setHorizontalAlignment(javax.swing.JTextField.RIGHT); t_iva.setText("0.00"); t_iva.setToolTipText("Total de IVA"); t_iva.setEnabled(false); t_iva.setFont(new java.awt.Font("Arial", 0, 11)); // NOI18N jPanel5.add(t_iva, new org.netbeans.lib.awtextra.AbsoluteConstraints(105, 20, 88, -1)); l_iva.setFont(new java.awt.Font("Arial", 0, 9)); // NOI18N l_iva.setForeground(new java.awt.Color(255, 255, 255)); l_iva.setText("% I.V.A.:"); jPanel5.add(l_iva, new org.netbeans.lib.awtextra.AbsoluteConstraints(49, 23, -1, -1)); l_total.setFont(new java.awt.Font("Arial", 0, 9)); // NOI18N l_total.setForeground(new java.awt.Color(255, 255, 255)); l_total.setText("Total:"); jPanel5.add(l_total, new org.netbeans.lib.awtextra.AbsoluteConstraints(62, 44, -1, -1)); t_total.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_total.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory( new javax.swing.text.NumberFormatter(new java.text.DecimalFormat("#,##0.00")))); t_total.setHorizontalAlignment(javax.swing.JTextField.RIGHT); t_total.setText("0.00"); t_total.setToolTipText("Total neto"); t_total.setEnabled(false); t_total.setFont(new java.awt.Font("Arial", 0, 11)); // NOI18N jPanel5.add(t_total, new org.netbeans.lib.awtextra.AbsoluteConstraints(105, 41, 88, -1)); t_iva1.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_iva1.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory( new javax.swing.text.NumberFormatter(new java.text.DecimalFormat("#0")))); t_iva1.setHorizontalAlignment(javax.swing.JTextField.RIGHT); t_iva1.setToolTipText("Total de IVA"); t_iva1.setFont(new java.awt.Font("Arial", 0, 11)); // NOI18N t_iva1.setValue(16); t_iva1.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { t_iva1FocusLost(evt); } }); t_iva1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { t_iva1ActionPerformed(evt); } }); t_iva1.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_iva1KeyTyped(evt); } }); jPanel5.add(t_iva1, new org.netbeans.lib.awtextra.AbsoluteConstraints(1, 20, 40, -1)); t_descuento.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_descuento.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory( new javax.swing.text.NumberFormatter(new java.text.DecimalFormat("0.00")))); t_descuento.setHorizontalAlignment(javax.swing.JTextField.RIGHT); t_descuento.setToolTipText("Agregar descuento general"); t_descuento.setEnabled(false); t_descuento.setFont(new java.awt.Font("Arial", 0, 11)); // NOI18N t_descuento.setNextFocusableComponent(t_datos); t_descuento.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { t_descuentoFocusLost(evt); } }); l_iva1.setFont(new java.awt.Font("Arial", 0, 9)); // NOI18N l_iva1.setForeground(new java.awt.Color(255, 255, 255)); l_iva1.setText("Agregar Descuento:"); jLabel22.setFont(new java.awt.Font("Arial", 0, 9)); // NOI18N jLabel22.setForeground(new java.awt.Color(255, 255, 255)); jLabel22.setText("No Factura:"); t_noFactura.setFont(new java.awt.Font("Arial", 0, 11)); // NOI18N t_noFactura.setToolTipText("Numero de factura"); t_noFactura.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_noFactura.setEnabled(false); b_mas.setBackground(new java.awt.Color(2, 135, 242)); b_mas.setForeground(new java.awt.Color(255, 255, 255)); b_mas.setIcon(new ImageIcon("imagenes/boton_mas.png")); b_mas.setToolTipText("Agrega un concepto"); b_mas.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { b_masActionPerformed(evt); } }); b_menos.setBackground(new java.awt.Color(2, 135, 242)); b_menos.setForeground(new java.awt.Color(255, 255, 255)); b_menos.setIcon(new ImageIcon("imagenes/boton_menos.png")); b_menos.setToolTipText("Eliminar un concepto"); b_menos.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { b_menosActionPerformed(evt); } }); l_iva2.setFont(new java.awt.Font("Arial", 0, 9)); // NOI18N l_iva2.setForeground(new java.awt.Color(255, 255, 255)); l_iva2.setText("Extra:"); t_extra.setBorder(javax.swing.BorderFactory.createEtchedBorder()); t_extra.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { t_extraKeyTyped(evt); } }); jButton3.setText("Importar"); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); javax.swing.GroupLayout p_totalesLayout = new javax.swing.GroupLayout(p_totales); p_totales.setLayout(p_totalesLayout); p_totalesLayout.setHorizontalGroup(p_totalesLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_totalesLayout.createSequentialGroup().addContainerGap() .addComponent(b_mas, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(b_menos, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addGroup(p_totalesLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, p_totalesLayout .createSequentialGroup().addComponent(b_guardar) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jButton3) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 69, Short.MAX_VALUE) .addComponent(l_iva2) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(t_extra, javax.swing.GroupLayout.PREFERRED_SIZE, 287, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(l_iva1).addGap(15, 15, 15)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, p_totalesLayout.createSequentialGroup().addComponent(jLabel22).addGap(18, 18, 18))) .addGroup(p_totalesLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(t_noFactura).addComponent(t_descuento, javax.swing.GroupLayout.DEFAULT_SIZE, 88, Short.MAX_VALUE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED).addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, 195, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(6, 6, 6))); p_totalesLayout.setVerticalGroup(p_totalesLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_totalesLayout.createSequentialGroup().addGroup(p_totalesLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_totalesLayout.createSequentialGroup().addGroup(p_totalesLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(p_totalesLayout.createSequentialGroup().addGap(6, 6, 6) .addGroup(p_totalesLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(t_descuento, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(p_totalesLayout.createSequentialGroup().addGap(7, 7, 7) .addGroup(p_totalesLayout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addComponent(l_iva1) .addGroup(p_totalesLayout.createParallelGroup( javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(l_iva2).addComponent(t_extra, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))))) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, p_totalesLayout .createSequentialGroup().addContainerGap() .addGroup(p_totalesLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(b_mas, javax.swing.GroupLayout.PREFERRED_SIZE, 19, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(b_menos, javax.swing.GroupLayout.PREFERRED_SIZE, 21, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(p_totalesLayout .createParallelGroup( javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(b_guardar).addComponent(jButton3))))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(p_totalesLayout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(t_noFactura, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel22))) .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(2, 2, 2))); add(p_totales, java.awt.BorderLayout.PAGE_END); t_datos.setModel(new javax.swing.table.DefaultTableModel(new Object[][] { }, new String[] { "Cant", "Med", "Descripcin", "N Parte", "Costo c/u", "Descuento", "Total" }) { Class[] types = new Class[] { java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.Object.class, java.lang.String.class }; boolean[] canEdit = new boolean[] { false, false, true, false, true, true, false }; public Class getColumnClass(int columnIndex) { return types[columnIndex]; } public boolean isCellEditable(int rowIndex, int columnIndex) { return canEdit[columnIndex]; } }); t_datos.setSelectionMode(javax.swing.ListSelectionModel.SINGLE_SELECTION); t_datos.getTableHeader().setReorderingAllowed(false); jScrollPane1.setViewportView(t_datos); add(jScrollPane1, java.awt.BorderLayout.CENTER); }// </editor-fold>//GEN-END:initComponents private void t_ordenActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_t_ordenActionPerformed // TODO add your handling code here: buscaOrden(); }//GEN-LAST:event_t_ordenActionPerformed private void t_ordenKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_ordenKeyTyped // TODO add your handling code here: char car = evt.getKeyChar(); if (t_orden.getText().length() > 5) evt.consume(); if ((car < '0' || car > '9')) evt.consume(); }//GEN-LAST:event_t_ordenKeyTyped private void b_ordenActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_b_ordenActionPerformed // TODO add your handling code here: /*Conexion mysql=new Conexion(); String resp=mysql.conectarMSQL("red", "04650077", "logis.ddns.net", "3306", "mydb"); if(resp.compareTo("")==0) { buscaOrden obj = new buscaOrden(new javax.swing.JFrame(), true, user); obj.t_busca.requestFocus(); Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); obj.setLocation((d.width/2)-(obj.getWidth()/2), (d.height/2)-(obj.getHeight()/2)); obj.setVisible(true); orden_act=obj.getReturnStatus(); if (orden_act!=null) { if(orden_act.getAutorizadoFacturar()==true) { Session session = HibernateUtil.getSessionFactory().openSession(); try { orden_act=(Orden)session.get(Orden.class, orden_act.getIdOrden()); int id_fac=OrdenFacturado(orden_act); if(id_fac==-1) { this.t_orden.setText(""+orden_act.getIdOrden()); //consultaOrden(); } else { t_orden.setText(""); orden_act=null; borra_cajas(); habilita(false); t_orden.requestFocus(); int op=JOptionPane.showConfirmDialog(null, "La orden ya esta en facturacin con el nmero:"+id_fac+" desea consultarla?", "En proceso de Facturacin", JOptionPane.YES_NO_OPTION); if(op==0) { session.beginTransaction().begin(); Factura factura=(Factura)session.get(Factura.class, id_fac); if(factura.getAddenda()!=null && factura.getEstadoFactura().compareTo("Facturado")==0) { switch(factura.getAddenda()) { case "qualitas": session.beginTransaction().commit(); QUALITAS genera=new QUALITAS(new Frame(), true, this.user, sessionPrograma, factura); d = Toolkit.getDefaultToolkit().getScreenSize(); genera.setLocation((d.width/2)-(genera.getWidth()/2), (d.height/2)-(genera.getHeight()/2)); genera.consulta(); genera.setVisible(true); factura=genera.getReturnStatus(); break; case "axa": AXA genera1=new AXA(new Frame(), true, this.user, sessionPrograma, factura); d = Toolkit.getDefaultToolkit().getScreenSize(); genera1.setLocation((d.width/2)-(genera1.getWidth()/2), (d.height/2)-(genera1.getHeight()/2)); genera1.consulta(); genera1.setVisible(true); factura=genera1.getReturnStatus(); break; case "gnp": GNP genera2=new GNP(new Frame(), true, this.user, sessionPrograma, factura); d = Toolkit.getDefaultToolkit().getScreenSize(); genera2.setLocation((d.width/2)-(genera2.getWidth()/2), (d.height/2)-(genera2.getHeight()/2)); genera2.consulta(); genera2.setVisible(true); factura=genera2.getReturnStatus(); break; //case "mapfre": //break; case"general": General genera3=new General(new Frame(), true, this.user, sessionPrograma, factura); d = Toolkit.getDefaultToolkit().getScreenSize(); genera3.setLocation((d.width/2)-(genera3.getWidth()/2), (d.height/2)-(genera3.getHeight()/2)); genera3.consulta(); genera3.setVisible(true); factura=genera3.getReturnStatus(); break; default: addendas.setSize(324, 135); d = Toolkit.getDefaultToolkit().getScreenSize(); addendas.setLocation((d.width/2)-(addendas.getWidth()/2), (d.height/2)-(addendas.getHeight()/2)); addendas.setVisible(true); break; } } else { addendas.setSize(324, 135); d = Toolkit.getDefaultToolkit().getScreenSize(); addendas.setLocation((d.width/2)-(addendas.getWidth()/2), (d.height/2)-(addendas.getHeight()/2)); addendas.setVisible(true); } } } }catch(Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "Error al consultar la orden"); } finally { if(session!=null) if(session.isOpen()) session.close(); } } else { t_orden.setText(""); orden_act=null; borra_cajas(); habilita(false); t_orden.requestFocus(); JOptionPane.showMessageDialog(null, "La orden aun no esta lista para facturar"); } } else { t_orden.setText(""); orden_act=null; borra_cajas(); habilita(false); t_orden.requestFocus(); } } else { JOptionPane.showMessageDialog(null, "Error al conextar con el servidor: "+resp); }*/ }//GEN-LAST:event_b_ordenActionPerformed private void t_descuentoFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_t_descuentoFocusLost // TODO add your handling code here: try { t_descuento.commitEdit(); if (((Number) t_descuento.getValue()).doubleValue() <= 100.0d && ((Number) t_descuento.getValue()).doubleValue() >= 0.0d) { for (int a = 0; a < t_datos.getRowCount(); a++) { t_datos.setValueAt(((Number) t_descuento.getValue()).doubleValue(), a, 5); } } else t_descuento.setValue(0); this.sumaTotales(); } catch (Exception e) { } }//GEN-LAST:event_t_descuentoFocusLost private void b_guardarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_b_guardarActionPerformed // TODO add your handling code here: if (t_datos.getRowCount() > 0) { if (t_orden.getText().compareTo("") != 0) { if (t_cliente.getText().trim().compareTo("") != 0) { if (t_rfc.getText().compareTo("") != 0) { if (t_direccion.getText().trim().compareTo("") != 0) { if (t_numero_exterior.getText().compareTo("") != 0) { if (t_cp.getText().compareTo("") != 0) { if (t_municipio.getText().compareTo("") != 0) { Session session = HibernateUtil.getSessionFactory().openSession(); try { Calendar c1 = Calendar.getInstance(); //Calendar c2 = new GregorianCalendar(); session.beginTransaction().begin(); /*orden_act=(Orden)session.get(Orden.class, orden_act.getIdOrden()); if(orden_act.getAutorizadoFacturar()==true) {*/ OrdenExterna ordenx = new OrdenExterna(); ordenx.setAsegurado(this.t_asegurado.getText()); if (this.t_marca.getText().compareTo("") != 0)//agregamos la marca { Marca mar = (Marca) session.get(Marca.class, l_marca.getText()); if (mar != null) { ordenx.setMarca(mar); } else { Marca aux = new Marca(); aux.setIdMarca(l_marca.getText()); aux.setMarcaNombre(t_marca.getText()); session.save(aux); mar = (Marca) session.get(Marca.class, l_marca.getText()); ordenx.setMarca(mar); } } if (this.t_tipo.getText().compareTo("") != 0)//agregamos el tipo { Tipo tip = (Tipo) session.get(Tipo.class, t_tipo.getText()); if (tip != null) { ordenx.setTipo(tip); } else { Tipo t = new Tipo(); t.setTipoNombre(t_tipo.getText()); t.setEPesado(0); session.save(t); tip = (Tipo) session.get(Tipo.class, t_tipo.getText()); ordenx.setTipo(tip); } } ordenx.setNoSerie(t_serie.getText()); if (this.t_modelo.getText().compareTo("") != 0)//agregamos el modelo ordenx.setModelo(Integer.parseInt(this.t_modelo.getText())); ordenx.setNoPlacas(t_placas.getText()); ordenx.setPoliza(t_poliza.getText()); ordenx.setSiniestro(t_siniestro.getText()); ordenx.setNoReporte(t_reporte.getText()); ordenx.setKm(t_km.getText()); int nOrd = (int) session.save(ordenx); ordenx = (OrdenExterna) session.get(OrdenExterna.class, nOrd); Configuracion con = (Configuracion) session.get(Configuracion.class, 1); Factura nuevaFactura = new Factura(); nuevaFactura.setOrden(orden_act); nuevaFactura.setOrdenExterna(ordenx); nuevaFactura.setFecha(c1.getTime());// fecha de emision nuevaFactura.setRfcEmisor(con.getRfc());//RFC emisor nuevaFactura.setNombreEmisor(con.getNombre());//nombre emisor nuevaFactura.setCalleEmisor(con.getDireccion());//calle emisor nuevaFactura.setColoniaEmisor(con.getColonia());//Colonia emisor nuevaFactura.setNumeroExteriorEmisor(con.getNo());//numero exteerior emisor nuevaFactura.setMunicipioEmisor(con.getMunicipio());//municipio emisor nuevaFactura.setEstadoEmisor(con.getEstado());//estado emisor nuevaFactura.setPaisEmisor(con.getPais());//pais emisor nuevaFactura.setCpEmisor(con.getCp());//cp emisor nuevaFactura.setRfcReceptor(t_rfc.getText()); nuevaFactura.setNombreReceptor(t_cliente.getText()); nuevaFactura.setCalleReceptor(t_direccion.getText()); nuevaFactura.setNumeroExteriorReceptor(t_numero_exterior.getText()); nuevaFactura.setColoniaReceptor(t_colonia.getText()); nuevaFactura.setMunicipioReceptor(t_municipio.getText()); nuevaFactura.setEstadoReceptor(c_estado.getSelectedItem().toString()); nuevaFactura.setPaisReceptor(c_pais.getSelectedItem().toString()); nuevaFactura.setCpReceptor(t_cp.getText()); //DEDUCIBLE nuevaFactura.setEstadoFactura("Pendiente"); nuevaFactura.setEstatus("PENDIENTE"); //f_fiscal //fecha_fiscal //serie //folio nuevaFactura.setMetodoPago("98"); nuevaFactura.setCuentaPago(""); nuevaFactura.setMoneda("MXN"); nuevaFactura.setFactorCambio(1.0d); nuevaFactura.setArea("Talleres"); nuevaFactura.setTipoPoliza("AUTOS"); nuevaFactura.setTipoEmisor("MATRIZ"); nuevaFactura.setContactoEmisor(con.getContacto()); nuevaFactura.setCorreoEmisor(con.getMail()); nuevaFactura.setTelefonoEmisor(con.getTel()); nuevaFactura.setTipoReceptor("COORDINADOR"); nuevaFactura.setContactoReceptor(t_receptor.getText()); nuevaFactura.setCorreoReceptor(t_email.getText()); nuevaFactura.setTelefonoReceptor(""); nuevaFactura.setCodigoOficina(""); nuevaFactura.setFoliosElectronicos(""); nuevaFactura.setUsuarioByGenero(user); //AUTORIZO //NPOMBRE DE DOCUMENTO //ERROR //ADDENDA //RI_EMOSOR //RI_RECEPTOR //PROVEEDOR nuevaFactura.setCondicionesPago("UNA SOLA EXHIBICION"); //TIPO FACTURACION //DESCRIPCION EMISOR nuevaFactura.setMedioPago("NO IDENTIFICADO"); nuevaFactura.setFechaMedioPago(c1.getTime()); //FECHA CONDICIONES DE PAGO //RIESGO //ID ORDEN nuevaFactura.setIva(Integer.parseInt(t_iva1.getValue().toString())); nuevaFactura.setExtra(t_extra.getText()); int noFactura = (Integer) session.save(nuevaFactura); factura = (Factura) session.get(Factura.class, noFactura); //crear los conceptos for (int a = 0; a < t_datos.getRowCount(); a++) { Concepto renglon = new Concepto(); renglon.setFactura(nuevaFactura); renglon.setCantidad((double) t_datos.getValueAt(a, 0)); renglon.setMedida(t_datos.getValueAt(a, 1).toString()); renglon.setDescripcion(t_datos.getValueAt(a, 2).toString()); renglon.setPrecio((double) t_datos.getValueAt(a, 4)); renglon.setDescuento((double) t_datos.getValueAt(a, 5)); renglon.setFactura(factura); session.save(renglon); //nuevaFactura.getConceptos().add(renglon); } logis(noFactura); session.beginTransaction().commit(); habilita(false); t_noFactura.setText("" + noFactura); JOptionPane.showMessageDialog(this, "La factura se ha guardado con el nmero:" + noFactura); addendas.setSize(324, 135); Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); addendas.setLocation((d.width / 2) - (addendas.getWidth() / 2), (d.height / 2) - (addendas.getHeight() / 2)); addendas.setVisible(true); /*} else { t_orden.setText(""); orden_act=null; borra_cajas(); habilita(false); t_orden.requestFocus(); JOptionPane.showMessageDialog(this, "La factura no esta lista para facturar"); }*/ } catch (Exception e) { session.beginTransaction().rollback(); e.printStackTrace(); JOptionPane.showMessageDialog(this, "No se pudo guardar la factura."); } finally { if (session != null) if (session.isOpen()) session.close(); } } else JOptionPane.showMessageDialog(this, "Ingrese el Municipio del cliente"); } else JOptionPane.showMessageDialog(this, "Ingrese el CP del cliente"); } else JOptionPane.showMessageDialog(this, "Ingrese el Nmero exterior del cliente"); } else JOptionPane.showMessageDialog(this, "Ingrese la calle del cliente"); } else JOptionPane.showMessageDialog(this, "Ingrese el RFC del cliente"); } else JOptionPane.showMessageDialog(this, "Ingrese en nombre de la razn social"); } else JOptionPane.showMessageDialog(this, "Ingrese el nmero de orden a facturar"); } else JOptionPane.showMessageDialog(this, "Ingrese conceptos a facturar"); }//GEN-LAST:event_b_guardarActionPerformed private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed // TODO add your handling code here: Session session = HibernateUtil.getSessionFactory().openSession(); try { session.beginTransaction().begin(); factura = (Factura) session.get(Factura.class, factura.getIdFactura()); session.beginTransaction().commit(); addendas.setVisible(false); QUALITAS genera = new QUALITAS(new javax.swing.JFrame(), true, user, sessionPrograma, factura); Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); genera.setLocation((d.width / 2) - (genera.getWidth() / 2), (d.height / 2) - (genera.getHeight() / 2)); genera.consulta(); genera.setVisible(true); } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "error al consultar la orden"); } finally { if (session != null) if (session.isOpen()) session.close(); } }//GEN-LAST:event_jButton1ActionPerformed private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed // TODO add your handling code here: Session session = HibernateUtil.getSessionFactory().openSession(); try { session.beginTransaction().begin(); factura = (Factura) session.get(Factura.class, factura.getIdFactura()); session.beginTransaction().commit(); addendas.setVisible(false); AXA genera = new AXA(new javax.swing.JFrame(), true, user, sessionPrograma, factura); Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); genera.setLocation((d.width / 2) - (genera.getWidth() / 2), (d.height / 2) - (genera.getHeight() / 2)); genera.consulta(); genera.setVisible(true); } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "error al consultar la orden"); } finally { if (session != null) if (session.isOpen()) session.close(); } }//GEN-LAST:event_jButton2ActionPerformed private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed // TODO add your handling code here: Session session = HibernateUtil.getSessionFactory().openSession(); try { session.beginTransaction().begin(); factura = (Factura) session.get(Factura.class, factura.getIdFactura()); session.beginTransaction().commit(); addendas.setVisible(false); GNP genera = new GNP(new javax.swing.JFrame(), true, user, sessionPrograma, factura); Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); genera.setLocation((d.width / 2) - (genera.getWidth() / 2), (d.height / 2) - (genera.getHeight() / 2)); genera.consulta(); genera.setVisible(true); } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "Error al consultar la orden"); } finally { if (session != null) if (session.isOpen()) session.close(); } }//GEN-LAST:event_jButton4ActionPerformed private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed // TODO add your handling code here: Session session = HibernateUtil.getSessionFactory().openSession(); try { session.beginTransaction().begin(); factura = (Factura) session.get(Factura.class, factura.getIdFactura()); session.beginTransaction().commit(); addendas.setVisible(false); General genera = new General(new javax.swing.JFrame(), true, user, sessionPrograma, factura); Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); genera.setLocation((d.width / 2) - (genera.getWidth() / 2), (d.height / 2) - (genera.getHeight() / 2)); genera.consulta(); genera.setVisible(true); } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "Error al consultar la orden"); } finally { if (session != null) if (session.isOpen()) session.close(); } }//GEN-LAST:event_jButton5ActionPerformed private void b_masActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_b_masActionPerformed h = new Herramientas(this.user, 0); h.session(sessionPrograma); DefaultTableModel temp = (DefaultTableModel) t_datos.getModel(); Object nuevo[] = { 0.0d, "PZAS", "", "", 0.0d, 0.0d, 0.0d }; temp.addRow(nuevo); formatoTabla(); t_datos.setRowSelectionInterval(t_datos.getRowCount() - 1, t_datos.getRowCount() - 1); t_datos.setColumnSelectionInterval(0, 0); }//GEN-LAST:event_b_masActionPerformed private void b_menosActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_b_menosActionPerformed h = new Herramientas(user, 0); h.session(sessionPrograma); if (t_datos.getRowCount() > 0 && t_datos.getSelectedRow() >= 0) { DefaultTableModel temp = (DefaultTableModel) t_datos.getModel(); temp.removeRow(t_datos.getSelectedRow()); sumaTotales(); if (t_datos.getRowCount() > 0) { t_datos.setRowSelectionInterval(t_datos.getRowCount() - 1, t_datos.getRowCount() - 1); t_datos.setColumnSelectionInterval(0, 0); } } }//GEN-LAST:event_b_menosActionPerformed private void b_marcaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_b_marcaActionPerformed h = new Herramientas(user, 0); h.session(sessionPrograma); buscaMarca obj = new buscaMarca(new javax.swing.JFrame(), true, this.sessionPrograma, this.user); obj.t_busca.requestFocus(); obj.formatoTabla(); Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); obj.setLocation((d.width / 2) - (obj.getWidth() / 2), (d.height / 2) - (obj.getHeight() / 2)); obj.setVisible(true); Marca actor = obj.getReturnStatus(); if (actor != null) { t_marca.setText(actor.getMarcaNombre()); l_marca.setText(actor.getIdMarca()); } else { l_marca.setText(""); t_marca.setText(""); } }//GEN-LAST:event_b_marcaActionPerformed private void b_tipoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_b_tipoActionPerformed // TODO add your handling code here: h = new Herramientas(user, 0); h.session(sessionPrograma); buscaTipo obj = new buscaTipo(new javax.swing.JFrame(), true, this.sessionPrograma, this.user); obj.t_busca.requestFocus(); Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); obj.setLocation((d.width / 2) - (obj.getWidth() / 2), (d.height / 2) - (obj.getHeight() / 2)); obj.setVisible(true); String actor = obj.getReturnStatus(); if (actor != null) t_tipo.setText(actor); else t_tipo.setText(""); }//GEN-LAST:event_b_tipoActionPerformed private void t_incFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_t_incFocusLost // TODO add your handling code here: if (t_inc.getText().length() > 10) { t_inc.setText(t_inc.getText().substring(0, 10)); } }//GEN-LAST:event_t_incFocusLost private void t_incActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_t_incActionPerformed // TODO add your handling code here: }//GEN-LAST:event_t_incActionPerformed private void t_incKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_incKeyTyped // TODO add your handling code here: char car = evt.getKeyChar(); if (t_inc.getText().length() >= 10) evt.consume(); }//GEN-LAST:event_t_incKeyTyped private void t_aseguradoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_t_aseguradoActionPerformed // TODO add your handling code here: }//GEN-LAST:event_t_aseguradoActionPerformed private void t_aseguradoFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_t_aseguradoFocusLost // TODO add your handling code here: if (t_asegurado.getText().length() > 150) { t_asegurado.setText(t_asegurado.getText().substring(0, 150)); } }//GEN-LAST:event_t_aseguradoFocusLost private void t_aseguradoKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_aseguradoKeyTyped // TODO add your handling code here: evt.setKeyChar(Character.toUpperCase(evt.getKeyChar())); char car = evt.getKeyChar(); if (t_asegurado.getText().length() >= 150) evt.consume(); }//GEN-LAST:event_t_aseguradoKeyTyped private void t_serieActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_t_serieActionPerformed // TODO add your handling code here: }//GEN-LAST:event_t_serieActionPerformed private void t_serieFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_t_serieFocusLost // TODO add your handling code here: if (t_serie.getText().length() > 20) { t_serie.setText(t_serie.getText().substring(0, 20)); } }//GEN-LAST:event_t_serieFocusLost private void t_serieKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_serieKeyTyped // TODO add your handling code here: evt.setKeyChar(Character.toUpperCase(evt.getKeyChar())); if (t_serie.getText().length() >= 20) evt.consume(); }//GEN-LAST:event_t_serieKeyTyped private void t_modeloActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_t_modeloActionPerformed // TODO add your handling code here: }//GEN-LAST:event_t_modeloActionPerformed private void t_modeloFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_t_modeloFocusLost // TODO add your handling code here: if (t_modelo.getText().length() > 4) { t_modelo.setText(t_modelo.getText().substring(0, 4)); try { Integer.parseInt(t_modelo.getText()); } catch (Exception e) { e.printStackTrace(); t_modelo.setText(""); } } else { try { Integer.parseInt(t_modelo.getText()); } catch (Exception e) { e.printStackTrace(); t_modelo.setText(""); } } }//GEN-LAST:event_t_modeloFocusLost private void t_placasActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_t_placasActionPerformed // TODO add your handling code here: }//GEN-LAST:event_t_placasActionPerformed private void t_placasFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_t_placasFocusLost // TODO add your handling code here: if (t_placas.getText().length() > 8) { t_placas.setText(t_placas.getText().substring(0, 8)); } }//GEN-LAST:event_t_placasFocusLost private void t_placasKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_placasKeyTyped // TODO add your handling code here: char car = evt.getKeyChar(); if (t_placas.getText().length() >= 8) evt.consume(); }//GEN-LAST:event_t_placasKeyTyped private void t_polizaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_t_polizaActionPerformed // TODO add your handling code here: }//GEN-LAST:event_t_polizaActionPerformed private void t_polizaFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_t_polizaFocusLost // TODO add your handling code here: if (t_poliza.getText().length() > 20) { t_poliza.setText(t_poliza.getText().substring(0, 20)); } }//GEN-LAST:event_t_polizaFocusLost private void t_polizaKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_polizaKeyTyped // TODO add your handling code here: char car = evt.getKeyChar(); if (t_poliza.getText().length() >= 15) evt.consume(); }//GEN-LAST:event_t_polizaKeyTyped private void t_siniestroActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_t_siniestroActionPerformed // TODO add your handling code here: }//GEN-LAST:event_t_siniestroActionPerformed private void t_siniestroFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_t_siniestroFocusLost // TODO add your handling code here: if (t_siniestro.getText().length() > 20) { t_siniestro.setText(t_siniestro.getText().substring(0, 20)); } }//GEN-LAST:event_t_siniestroFocusLost private void t_siniestroKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_siniestroKeyTyped // TODO add your handling code here: char car = evt.getKeyChar(); if (t_siniestro.getText().length() >= 10) evt.consume(); }//GEN-LAST:event_t_siniestroKeyTyped private void t_reporteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_t_reporteActionPerformed // TODO add your handling code here: }//GEN-LAST:event_t_reporteActionPerformed private void t_reporteFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_t_reporteFocusLost // TODO add your handling code here: if (t_reporte.getText().length() > 10) { t_reporte.setText(t_reporte.getText().substring(0, 10)); } }//GEN-LAST:event_t_reporteFocusLost private void t_reporteKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_reporteKeyTyped // TODO add your handling code here: char car = evt.getKeyChar(); if (t_reporte.getText().length() >= 10) evt.consume(); }//GEN-LAST:event_t_reporteKeyTyped private void Selecciona2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_Selecciona2ActionPerformed h = new Herramientas(user, 0); h.session(sessionPrograma); Session session = HibernateUtil.getSessionFactory().openSession(); this.user = (Usuario) session.get(Usuario.class, user.getIdUsuario()); if (user.getCrearClientes() == true) { altaCliente obj = new altaCliente(new javax.swing.JFrame(), true, user, sessionPrograma); Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); obj.setLocation((d.width / 2) - (obj.getWidth() / 2), (d.height / 2) - (obj.getHeight() / 2)); obj.setVisible(true); //borra_cajas(); //b_actualiza.setEnabled(false); } else JOptionPane.showMessageDialog(null, "Acceso denegado!"); if (session != null) if (session.isOpen()) session.close(); }//GEN-LAST:event_Selecciona2ActionPerformed private void c_clienteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_c_clienteActionPerformed // TODO add your handling code here: //cargaCliente(); }//GEN-LAST:event_c_clienteActionPerformed private void b_buscarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_b_buscarActionPerformed // TODO add your handling code here: Session session = HibernateUtil.getSessionFactory().openSession(); try { session.beginTransaction().begin(); if (c_cliente.getSelectedItem().toString().compareTo("Cliente") == 0) { h = new Herramientas(user, 0); h.session(sessionPrograma); buscaCliente obj = new buscaCliente(new javax.swing.JFrame(), true); obj.t_busca.requestFocus(); Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); obj.setLocation((d.width / 2) - (obj.getWidth() / 2), (d.height / 2) - (obj.getHeight() / 2)); obj.setVisible(true); Clientes actor = obj.getReturnStatus(); if (actor != null) { actor = (Clientes) session.get(Clientes.class, actor.getIdClientes()); t_id.setText("" + actor.getIdClientes()); t_cliente.setText(actor.getNombre()); if (actor.getRfc() != null) t_rfc.setText(actor.getRfc()); else t_rfc.setText(""); if (actor.getDireccion() != null) t_direccion.setText(actor.getDireccion()); else t_direccion.setText(""); if (actor.getCp() != null) t_cp.setText("" + actor.getCp()); else t_cp.setText(""); if (actor.getColonia() != null) t_colonia.setText(actor.getColonia()); else t_colonia.setText(actor.getColonia()); if (actor.getMunicipio() != null) t_municipio.setText(actor.getMunicipio()); else t_municipio.setText(""); if (actor.getEstado() != null) c_estado.setSelectedItem(actor.getEstado()); if (actor.getPais() != null) c_pais.setSelectedItem(actor.getPais()); else c_pais.setSelectedItem(""); if (actor.getNumeroExterior() != null) t_numero_exterior.setText(actor.getNumeroExterior()); else t_numero_exterior.setText(""); if (actor.getReceptor() != null) t_receptor.setText(actor.getReceptor()); else t_receptor.setText(""); if (actor.getEmailReceptor() != null) t_email.setText(actor.getEmailReceptor()); else t_email.setText(""); b_actualiza.setEnabled(true); } } if (c_cliente.getSelectedItem().toString().compareTo("Compaia") == 0) { h = new Herramientas(user, 0); h.session(sessionPrograma); buscaCompania obj = new buscaCompania(new javax.swing.JFrame(), true, this.sessionPrograma, this.user); obj.t_busca.requestFocus(); Dimension d = Toolkit.getDefaultToolkit().getScreenSize(); obj.setLocation((d.width / 2) - (obj.getWidth() / 2), (d.height / 2) - (obj.getHeight() / 2)); obj.setVisible(true); Compania actor = obj.getReturnStatus(); if (actor != null) { actor = (Compania) session.get(Compania.class, actor.getIdCompania()); t_id.setText("" + actor.getIdCompania()); t_cliente.setText(actor.getSocial()); if (actor.getRfc() != null) t_rfc.setText(actor.getRfc()); else t_rfc.setText(""); if (actor.getDireccion() != null) t_direccion.setText(actor.getDireccion()); else t_direccion.setText(""); if (actor.getCp() != null) t_cp.setText("" + actor.getCp()); else t_cp.setText(""); if (actor.getColonia() != null) t_colonia.setText(actor.getColonia()); else t_colonia.setText(actor.getColonia()); if (actor.getMunicipio() != null) t_municipio.setText(actor.getMunicipio()); else t_municipio.setText(""); if (actor.getEstado() != null) c_estado.setSelectedItem(actor.getEstado()); if (actor.getPais() != null) c_pais.setSelectedItem(actor.getPais()); else c_pais.setSelectedItem(""); if (actor.getNumeroExterior() != null) t_numero_exterior.setText(actor.getNumeroExterior()); else t_numero_exterior.setText(""); if (actor.getRepresentante2() != null) t_receptor.setText(actor.getRepresentante2()); else t_receptor.setText(""); if (actor.getR2Puesto() != null) t_email.setText(actor.getR2Puesto()); else t_email.setText(""); b_actualiza.setEnabled(true); } } } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "Error al consultar los datos"); } finally { if (session != null) if (session.isOpen()) session.close(); } }//GEN-LAST:event_b_buscarActionPerformed private void t_rfcKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_rfcKeyTyped // TODO add your handling code here: evt.setKeyChar(Character.toUpperCase(evt.getKeyChar())); if (t_rfc.getText().length() >= 13) evt.consume(); }//GEN-LAST:event_t_rfcKeyTyped private void t_cpKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_cpKeyTyped char car = evt.getKeyChar(); if (t_cp.getText().length() >= 5) evt.consume(); if ((car < '0' || car > '9')) evt.consume(); }//GEN-LAST:event_t_cpKeyTyped private void t_clienteKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_clienteKeyTyped // TODO add your handling code here: evt.setKeyChar(Character.toUpperCase(evt.getKeyChar())); if (t_cliente.getText().length() > 100) evt.consume(); }//GEN-LAST:event_t_clienteKeyTyped private void t_direccionKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_direccionKeyTyped // TODO add your handling code here: evt.setKeyChar(Character.toUpperCase(evt.getKeyChar())); if (t_direccion.getText().length() >= 150) evt.consume(); }//GEN-LAST:event_t_direccionKeyTyped private void t_coloniaKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_coloniaKeyTyped // TODO add your handling code here: evt.setKeyChar(Character.toUpperCase(evt.getKeyChar())); if (t_colonia.getText().length() >= 100) evt.consume(); }//GEN-LAST:event_t_coloniaKeyTyped private void t_numero_exteriorKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_numero_exteriorKeyTyped // TODO add your handling code here: if (t_numero_exterior.getText().length() > 10) evt.consume(); }//GEN-LAST:event_t_numero_exteriorKeyTyped private void t_municipioKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_municipioKeyTyped // TODO add your handling code here: evt.setKeyChar(Character.toUpperCase(evt.getKeyChar())); if (t_municipio.getText().length() >= 100) evt.consume(); }//GEN-LAST:event_t_municipioKeyTyped private void t_kmFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_t_kmFocusLost // TODO add your handling code here: }//GEN-LAST:event_t_kmFocusLost private void t_kmActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_t_kmActionPerformed // TODO add your handling code here: }//GEN-LAST:event_t_kmActionPerformed private void t_kmKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_kmKeyTyped // TODO add your handling code here: }//GEN-LAST:event_t_kmKeyTyped private void t_ordenKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_ordenKeyReleased // TODO add your handling code here: if (t_orden.getText().length() >= 6) buscaOrden(); }//GEN-LAST:event_t_ordenKeyReleased private void t_iva1KeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_iva1KeyTyped // TODO add your handling code here: char car = evt.getKeyChar(); if (t_iva1.getText().length() >= 3) evt.consume(); if ((car < '0' || car > '9')) evt.consume(); }//GEN-LAST:event_t_iva1KeyTyped private void t_iva1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_t_iva1ActionPerformed // TODO add your handling code here: try { t_iva1.commitEdit(); } catch (Exception e) { } this.sumaTotales(); }//GEN-LAST:event_t_iva1ActionPerformed private void t_iva1FocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_t_iva1FocusLost // TODO add your handling code here: try { t_iva1.commitEdit(); } catch (Exception e) { } this.sumaTotales(); }//GEN-LAST:event_t_iva1FocusLost private void b_actualizaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_b_actualizaActionPerformed // TODO add your handling code here: if (this.c_cliente.getSelectedItem().toString().compareTo("Compaia") == 0) { h = new Herramientas(user, 0); h.session(sessionPrograma); t_cliente.setText(t_cliente.getText().trim()); if (t_cliente.getText().compareTo("") != 0) { Session session = HibernateUtil.getSessionFactory().openSession(); try { session.beginTransaction().begin(); /*Object resp=session.createQuery("from Compania obj where obj.nombre='"+t_cliente.getText()+"' and obj.idCompania!="+t_id.getText()).uniqueResult(); if(resp==null) {*/ Compania registro = (Compania) session.get(Compania.class, Integer.parseInt(t_id.getText())); registro.setSocial(t_cliente.getText()); if (t_direccion.getText().compareTo("") != 0) registro.setDireccion(t_direccion.getText()); else registro.setDireccion(null); if (t_colonia.getText().compareTo("") != 0) registro.setColonia(t_colonia.getText()); else registro.setColonia(null); registro.setEstado(c_estado.getSelectedItem().toString()); if (t_rfc.getText().compareTo("") != 0) registro.setRfc(t_rfc.getText()); else registro.setRfc(""); if (t_cp.getText().compareTo("") != 0) registro.setCp(t_cp.getText()); else registro.setCp(null); if (t_municipio.getText().compareTo("") != 0) registro.setMunicipio(t_municipio.getText()); else registro.setMunicipio(""); registro.setPais(c_pais.getSelectedItem().toString()); if (t_numero_exterior.getText().trim().compareTo("") != 0) registro.setNumeroExterior(t_numero_exterior.getText().trim()); session.update(registro); session.getTransaction().commit(); JOptionPane.showMessageDialog(null, "Registro modificado"); /*} else { session.getTransaction().rollback(); JOptionPane.showMessageDialog(null, "En nombre de la Compaa ya existe!"); t_cliente.requestFocus(); }*/ } catch (HibernateException he) { he.printStackTrace(); session.getTransaction().rollback(); } finally { if (session != null) if (session.isOpen()) session.close(); } } else { JOptionPane.showMessageDialog(null, "Debe introducir el nombre de la compaa!"); t_cliente.requestFocus(); } } if (this.c_cliente.getSelectedItem().toString().compareTo("Cliente") == 0) { h = new Herramientas(user, 0); h.session(sessionPrograma); Session session = HibernateUtil.getSessionFactory().openSession(); try { session.beginTransaction(); Object resp = session.createQuery("from Clientes obj where obj.nombre='" + t_cliente.getText() + "' and obj.idClientes!=" + t_id.getText()).uniqueResult(); if (resp == null) { Clientes objeto = (Clientes) session.get(Clientes.class, Integer.parseInt(t_id.getText())); objeto.setNombre(t_cliente.getText()); if (t_direccion.getText().compareTo("") != 1) objeto.setDireccion(t_direccion.getText()); else objeto.setDireccion(""); if (t_colonia.getText().compareTo("") != 1) objeto.setColonia(t_colonia.getText()); else objeto.setColonia(""); objeto.setEstado(c_estado.getSelectedItem().toString()); if (t_rfc.getText().compareTo("") != 1) objeto.setRfc(t_rfc.getText()); else objeto.setRfc(""); if (t_cp.getText().compareTo("") == 0) objeto.setCp(null); else objeto.setCp(Integer.parseInt(t_cp.getText())); if (t_municipio.getText().compareTo("") != 0) objeto.setMunicipio(t_municipio.getText()); else objeto.setMunicipio(""); objeto.setPais(c_pais.getSelectedItem().toString()); if (t_numero_exterior.getText().trim().compareTo("") != 0) objeto.setNumeroExterior(t_numero_exterior.getText().trim()); session.update(objeto); session.getTransaction().commit(); JOptionPane.showMessageDialog(null, "Registro modificado"); } else { JOptionPane.showMessageDialog(null, "Error: No se pueden guardar nombres duplicados!"); } } catch (HibernateException he) { he.printStackTrace(); System.out.println(he.hashCode()); session.getTransaction().rollback(); } finally { if (session != null) if (session.isOpen()) session.close(); } } }//GEN-LAST:event_b_actualizaActionPerformed private void t_extraKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_t_extraKeyTyped // TODO add your handling code here: evt.setKeyChar(Character.toUpperCase(evt.getKeyChar())); if (t_extra.getText().length() >= 100) evt.consume(); }//GEN-LAST:event_t_extraKeyTyped private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed // TODO add your handling code here: aviso.setFileFilter(new ExtensionFileFilter("Excel document (*.xls)", new String[] { "xls" })); int resp = aviso.showOpenDialog(null); if (resp == aviso.APPROVE_OPTION) { File archivoXLS = aviso.getSelectedFile(); if (archivoXLS.exists() == true) { Session session = HibernateUtil.getSessionFactory().openSession(); try { FileInputStream archivo = new FileInputStream(archivoXLS); POIFSFileSystem fsFileSystem = new POIFSFileSystem(archivo); Workbook libro1 = new HSSFWorkbook(fsFileSystem); Sheet datos = libro1.getSheetAt(0); Iterator rowIterator; int r = 0; //**********cargamos datos************************ //DefaultTableModel temp = (DefaultTableModel) t_datos.getModel(); t_datos.setModel(ModeloTablaReporte(0, columnas)); rowIterator = datos.rowIterator(); r = 0; while (rowIterator.hasNext()) { HSSFRow renglon = (HSSFRow) rowIterator.next(); if (r > 0) { System.out.println(renglon.getCell(0).getNumericCellValue()); double cant = renglon.getCell(0).getNumericCellValue(); double cu = renglon.getCell(3).getNumericCellValue(); double descuento = renglon.getCell(4).getNumericCellValue(); double suma = cant * cu; double desc = descuento / 100; double total = suma - (suma * desc); Object nuevo[] = { cant, renglon.getCell(1).getStringCellValue(), renglon.getCell(2).getStringCellValue(), "", cu, descuento, total }; model.addRow(nuevo); } else r = 1; } formatoTabla(); this.sumaTotales(); t_datos.setRowSelectionInterval(t_datos.getRowCount() - 1, t_datos.getRowCount() - 1); t_datos.setColumnSelectionInterval(0, 0); t_datos.requestFocus(); } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(this, "No se pudo abrir el archivo"); } if (session != null) if (session.isOpen() == true) session.close(); } } }//GEN-LAST:event_jButton3ActionPerformed // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton Selecciona2; private javax.swing.JDialog addendas; private javax.swing.JDialog alerta; private javax.swing.JFileChooser aviso; private javax.swing.JButton b_actualiza; private javax.swing.JButton b_buscar; private javax.swing.JButton b_guardar; private javax.swing.JButton b_marca; private javax.swing.JButton b_mas; private javax.swing.JButton b_menos; private javax.swing.JButton b_orden; private javax.swing.JButton b_tipo; private javax.swing.JComboBox c_cliente; private javax.swing.JComboBox c_estado; private javax.swing.JComboBox c_pais; private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JButton jButton4; private javax.swing.JButton jButton5; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel11; private javax.swing.JLabel jLabel12; private javax.swing.JLabel jLabel13; private javax.swing.JLabel jLabel14; private javax.swing.JLabel jLabel15; private javax.swing.JLabel jLabel16; private javax.swing.JLabel jLabel17; private javax.swing.JLabel jLabel18; private javax.swing.JLabel jLabel19; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel20; private javax.swing.JLabel jLabel21; private javax.swing.JLabel jLabel22; private javax.swing.JLabel jLabel23; private javax.swing.JLabel jLabel24; private javax.swing.JLabel jLabel25; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private javax.swing.JLabel jLabel8; private javax.swing.JLabel jLabel9; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel5; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JLabel l_asegurado; private javax.swing.JLabel l_iva; private javax.swing.JLabel l_iva1; private javax.swing.JLabel l_iva2; private javax.swing.JTextField l_marca; private javax.swing.JLabel l_subtotal; private javax.swing.JLabel l_total; private javax.swing.JComboBox medida; private javax.swing.JPanel p_cliente; private javax.swing.JPanel p_orden; private javax.swing.JPanel p_totales; private javax.swing.JProgressBar progreso; private javax.swing.JTextField t_asegurado; private javax.swing.JTextField t_cliente; private javax.swing.JTextField t_colonia; private javax.swing.JTextField t_cp; private javax.swing.JTable t_datos; private javax.swing.JFormattedTextField t_descuento; private javax.swing.JTextField t_direccion; private javax.swing.JTextField t_email; private javax.swing.JTextField t_extra; private javax.swing.JTextField t_id; private javax.swing.JTextField t_inc; private javax.swing.JFormattedTextField t_iva; private javax.swing.JFormattedTextField t_iva1; private javax.swing.JTextField t_km; private javax.swing.JTextField t_marca; private javax.swing.JTextField t_modelo; private javax.swing.JTextField t_municipio; private javax.swing.JTextField t_noFactura; private javax.swing.JTextField t_numero_exterior; public javax.swing.JTextField t_orden; private javax.swing.JTextField t_placas; private javax.swing.JTextField t_poliza; private javax.swing.JTextField t_receptor; private javax.swing.JTextField t_reporte; private javax.swing.JTextField t_rfc; private javax.swing.JTextField t_serie; private javax.swing.JTextField t_siniestro; private javax.swing.JFormattedTextField t_subtotal; private javax.swing.JTextField t_tipo; private javax.swing.JFormattedTextField t_total; // End of variables declaration//GEN-END:variables void habilita(boolean estado) { c_cliente.setEnabled(estado); t_cliente.setEnabled(estado); t_direccion.setEnabled(estado); t_numero_exterior.setEnabled(estado); t_colonia.setEnabled(estado); c_estado.setEnabled(estado); t_rfc.setEnabled(estado); t_cp.setEnabled(estado); t_municipio.setEnabled(estado); c_pais.setEnabled(estado); b_guardar.setEnabled(estado); t_datos.setEnabled(estado); t_descuento.setEnabled(estado); b_actualiza.setEnabled(false); } void borra_cajas() { t_iva1.setValue(16); t_iva1.setText("16"); try { t_iva.commitEdit(); } catch (Exception e) { } ; t_asegurado.setText(""); t_marca.setText(""); t_tipo.setText(""); t_serie.setText(""); t_modelo.setText(""); t_placas.setText(""); t_poliza.setText(""); t_siniestro.setText(""); t_reporte.setText(""); t_inc.setText(""); c_cliente.setSelectedItem("Compaia"); t_cliente.setText(""); t_rfc.setText(""); t_direccion.setText(""); t_numero_exterior.setText(""); t_cp.setText(""); t_colonia.setText(""); t_municipio.setText(""); c_estado.setSelectedIndex(0); c_pais.setSelectedItem("MX"); t_subtotal.setValue(0); t_iva.setValue(0); t_total.setValue(0); t_descuento.setValue(0); t_noFactura.setText(""); t_receptor.setText(""); t_email.setText(""); t_extra.setText(""); t_km.setText(""); t_datos.setModel(ModeloTablaReporte(0, columnas)); formatoTabla(); } public void consultaOrden(String dato) { if (t_orden.getText().compareTo("") != 0) { borra_cajas(); try { if (orden.get(0) != null) t_inc.setText(orden.get(0).toString());//orden else t_inc.setText("");//orden t_asegurado.setText(orden.get(1).toString()); l_marca.setText(orden.get(2).toString()); t_marca.setText(orden.get(3).toString()); t_tipo.setText(orden.get(4).toString()); if (orden.get(5) != null) t_serie.setText(orden.get(5).toString()); else t_serie.setText(""); t_modelo.setText(orden.get(6).toString()); if (orden.get(7) != null) t_placas.setText(orden.get(7).toString()); else t_placas.setText(""); if (orden.get(8) != null) t_poliza.setText(orden.get(8).toString()); t_poliza.setText(""); if (orden.get(9) != null) t_siniestro.setText(orden.get(9).toString()); else t_siniestro.setText(""); if (orden.get(10) != null) t_reporte.setText(orden.get(10).toString()); else t_reporte.setText(""); String tipo_cliente = ""; if (orden.get(13) != null) tipo_cliente = orden.get(13).toString(); if (orden.get(16) != null) t_km.setText(orden.get(16).toString()); else t_km.setText(""); t_extra.setText("Orden: " + t_orden.getText()); switch (tipo_cliente) { case "1": l_asegurado.setText("Asegurado:"); break; case "2": l_asegurado.setText("Tercero:"); break; case "3": l_asegurado.setText("Tercero Asegurado:"); break; case "4": l_asegurado.setText("Particular"); break; } //cargar las partidas b_guardar.setEnabled(true); c_cliente.setEnabled(true); habilita(true); ArrayList partidas = mysql .Consulta("select cantidad_factura, med, catalogo.nombre, precio_factura from partida " + "left join catalogo on partida.id_catalogo=catalogo.id_catalogo " + "where id_orden=" + dato + " and facturado=true and incluida=false and enlazada is null " + "order by id_evaluacion, sub_partida asc;"); ArrayList enlazadas = mysql .Consulta("select cantidad_factura, med, catalogo.nombre, precio_factura from partida " + "left join catalogo on partida.id_catalogo=catalogo.id_catalogo " + "where enlazada=" + dato + " and facturado=true and incluida=false and enlazada is null " + "order by id_evaluacion, sub_partida asc;"); ArrayList adicionales = mysql .Consulta("select cantidad, medida, descripcion, precio from adicionales " + "where id_orden=" + dato + " order by id_adicionales asc;"); DefaultTableModel modelo = ModeloTablaReporte(0, columnas); for (int a = 0; a < partidas.size(); a++) { ArrayList aux = (ArrayList) partidas.get(a); String noParte = ""; /*if(partidas[a].getEjemplar()!=null) noParte=partidas[a].getEjemplar().getIdParte();*/ double descuento = 0.0d;//descuento de la partida double total = (Double.parseDouble(aux.get(0).toString()) * Double.parseDouble(aux.get(3).toString())) * (1 + (descuento / 100)); modelo.addRow(new Object[] { Double.parseDouble(aux.get(0).toString()), aux.get(1).toString(), aux.get(2).toString(), noParte, Double.parseDouble(aux.get(3).toString()), descuento, total }); } for (int b = 0; b < enlazadas.size(); b++) { ArrayList aux = (ArrayList) enlazadas.get(b); String noParte2 = ""; /*if(enlazadas[b].getEjemplar()!=null) noParte2=enlazadas[b].getEjemplar().getIdParte();*/ double descuento = 0.0d;//descuento de la partida double total = (Double.parseDouble(aux.get(0).toString()) * Double.parseDouble(aux.get(3).toString())) * (1 + (descuento / 100)); modelo.addRow(new Object[] { Double.parseDouble(aux.get(0).toString()), aux.get(1).toString(), aux.get(2).toString(), noParte2, Double.parseDouble(aux.get(3).toString()), descuento, total }); } for (int c = 0; c < adicionales.size(); c++) { ArrayList aux = (ArrayList) adicionales.get(c); String noParte3 = ""; double descuento = 0.0d;//descuento de la partida double total = (Double.parseDouble(aux.get(0).toString()) * Double.parseDouble(aux.get(3).toString())) * (1 + (descuento / 100)); modelo.addRow(new Object[] { Double.parseDouble(aux.get(0).toString()), aux.get(1).toString(), aux.get(2).toString(), noParte3, Double.parseDouble(aux.get(3).toString()), descuento, total }); } Double mo = Double.parseDouble(orden.get(14).toString()); if (mo > 0.0d) { modelo.addRow(new Object[] { 1.0, "NA", "MANO DE OBRA", "", mo, 0.0, mo }); } else { ArrayList datos1 = mysql .Consulta("SELECT SUM( \n" + "(CASE WHEN dm>0 THEN (dm*cant) ELSE 0 END) + \n" + "(CASE WHEN cam>0 THEN (cam*cant) ELSE 0 END) + \n" + "(CASE WHEN rep_min>0 THEN (rep_min*cant) ELSE 0 END) + \n" + "(CASE WHEN rep_med>0 THEN (rep_med*cant) ELSE 0 END) + \n" + "(CASE WHEN rep_max>0 THEN (rep_max*cant) ELSE 0 END) + \n" + "(CASE WHEN pint>0 THEN (pint*cant) ELSE 0 END) \n" + ") as mo, configuracion.iva from partida, configuracion \n" + "where Id_orden =" + t_orden.getText() + " or enlazada=" + t_orden.getText()); if (datos1.size() > 0) { ArrayList suma = (ArrayList) datos1.get(0); double res = Double.parseDouble(orden.get(15).toString()) * Double.parseDouble(suma.get(0).toString()); if (res > 0.0d) modelo.addRow(new Object[] { 1.0, "NA", "MANO DE OBRA", "", res, 0.0, res }); iva = Integer.parseInt(suma.get(1).toString()); } } t_datos.setModel(modelo); formatoTabla(); //cargaCliente(); } catch (HibernateException he) { he.printStackTrace(); t_orden.setText(""); borra_cajas(); b_guardar.setEnabled(false); c_cliente.setEnabled(false); habilita(false); JOptionPane.showMessageDialog(null, "Error al consultar la Orden"); t_orden.requestFocus(); } finally { mysql.desconectarMSQL(); } } else { borra_cajas(); b_guardar.setEnabled(false); c_cliente.setEnabled(false); habilita(false); } sumaTotales(); this.updateUI(); } void cargaCliente() { if (orden_act != null) { Session session = HibernateUtil.getSessionFactory().openSession(); try { session.beginTransaction().begin(); orden_act = (Orden) session.get(Orden.class, orden_act.getIdOrden()); if (c_cliente.getSelectedItem().toString().compareTo("Compaia") == 0) { t_cliente.setText(orden_act.getCompania().getSocial()); if (orden_act.getCompania().getDireccion() != null) t_direccion.setText(orden_act.getCompania().getDireccion()); else t_direccion.setText(""); if (orden_act.getCompania().getColonia() != null) t_colonia.setText(orden_act.getCompania().getColonia()); else t_colonia.setText(""); c_estado.setSelectedItem(orden_act.getCompania().getEstado()); if (orden_act.getCompania().getRfc() != null) this.t_rfc.setText(orden_act.getCompania().getRfc()); else this.t_rfc.setText(""); if (orden_act.getCompania().getCp() != null) t_cp.setText(orden_act.getCompania().getCp()); else t_cp.setText(""); if (orden_act.getCompania().getMunicipio() != null) t_municipio.setText(orden_act.getCompania().getMunicipio()); else t_municipio.setText(""); if (orden_act.getCompania().getNumeroExterior() != null) t_numero_exterior.setText(orden_act.getCompania().getNumeroExterior()); else t_numero_exterior.setText(""); c_pais.setSelectedItem(orden_act.getCompania().getPais()); } else { t_cliente.setText(orden_act.getClientes().getNombre()); if (orden_act.getClientes().getDireccion() != null) t_direccion.setText(orden_act.getClientes().getDireccion()); else t_direccion.setText(""); if (orden_act.getClientes().getColonia() != null) t_colonia.setText(orden_act.getClientes().getColonia()); else t_colonia.setText(""); c_estado.setSelectedItem(orden_act.getClientes().getEstado()); if (orden_act.getClientes().getRfc() != null) this.t_rfc.setText(orden_act.getClientes().getRfc()); else this.t_rfc.setText(""); try { int cp = orden_act.getClientes().getCp(); t_cp.setText("" + cp); } catch (Exception e) { t_cp.setText(""); } if (orden_act.getClientes().getMunicipio() != null) t_municipio.setText(orden_act.getClientes().getMunicipio()); else t_municipio.setText(""); c_pais.setSelectedItem(orden_act.getClientes().getPais()); if (orden_act.getClientes().getNumeroExterior() != null) t_numero_exterior.setText(orden_act.getClientes().getNumeroExterior()); else t_numero_exterior.setText(""); } session.close(); } catch (Exception e) { System.out.println(e); } finally { if (session != null) if (session.isOpen()) session.close(); } } } public void tabla_tamaos() { TableColumnModel col_model = t_datos.getColumnModel(); FormatoEditor fe=new FormatoEditor(); t_datos.setDefaultEditor(Double.class, fe); for (int i=0; i<t_datos.getColumnCount(); i++) { TableColumn column = col_model.getColumn(i); switch(i) { case 0: column.setPreferredWidth(20); break; case 1: column.setPreferredWidth(20); DefaultCellEditor editor = new DefaultCellEditor(medida); column.setCellEditor(editor); editor.setClickCountToStart(2); break; case 2: column.setPreferredWidth(350); break; case 3: column.setPreferredWidth(100); break; case 4: column.setPreferredWidth(40); break; case 5: column.setPreferredWidth(40); break; case 6: column.setPreferredWidth(40); break; default: column.setPreferredWidth(40); break; } } JTableHeader header = t_datos.getTableHeader(); header.setForeground(Color.white); } public void formatoTabla() { Color c1 = new java.awt.Color(2, 135, 242); for(int x=0; x<t_datos.getColumnModel().getColumnCount(); x++) t_datos.getColumnModel().getColumn(x).setHeaderRenderer(new Render1(c1)); tabla_tamaos(); t_datos.setShowVerticalLines(true); t_datos.setShowHorizontalLines(true); t_datos.setDefaultRenderer(Double.class, formato); t_datos.setDefaultRenderer(Integer.class, formato); t_datos.setDefaultRenderer(String.class, formato); t_datos.setDefaultRenderer(Boolean.class, formato); } DefaultTableModel ModeloTablaReporte(int renglones, String columnas[]) { model = new DefaultTableModel(new Object[renglones][6], columnas) { Class[] types = new Class[] { java.lang.Double.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.Double.class, java.lang.Double.class, java.lang.Double.class }; boolean[] canEdit = new boolean[] { true, true, true, true, true, true, false }; public void setValueAt(Object value, int row, int col) { Vector vector = (Vector) this.dataVector.elementAt(row); Object celda = ((Vector) this.dataVector.elementAt(row)).elementAt(col); switch (col) { case 0: if (vector.get(col) == null) { vector.setElementAt(value, col); this.dataVector.setElementAt(vector, row); fireTableCellUpdated(row, col); } else { if ((double) value >= 0.0d) { vector.setElementAt(value, col); this.dataVector.setElementAt(vector, row); fireTableCellUpdated(row, col); double suma = (((double) t_datos.getValueAt(row, 4)) * ((double) value)); double desc = ((double) t_datos.getValueAt(row, 5)) / 100; double total = suma - (suma * desc); t_datos.setValueAt(total, row, 6); } sumaTotales(); } break; case 4: if (vector.get(col) == null) { vector.setElementAt(value, col); this.dataVector.setElementAt(vector, row); fireTableCellUpdated(row, col); } else { if ((double) value >= 0.0d) { vector.setElementAt(value, col); this.dataVector.setElementAt(vector, row); fireTableCellUpdated(row, col); double suma = (((double) value) * ((double) t_datos.getValueAt(row, 0))); double desc = ((double) t_datos.getValueAt(row, 5)) / 100; double total = suma - (suma * desc); t_datos.setValueAt(total, row, 6); } sumaTotales(); } break; case 5: if (vector.get(col) == null) { vector.setElementAt(value, col); this.dataVector.setElementAt(vector, row); fireTableCellUpdated(row, col); } else { if ((double) value <= 100.0d && (double) value >= 0.0d) { vector.setElementAt(value, col); this.dataVector.setElementAt(vector, row); fireTableCellUpdated(row, col); double suma = (((double) t_datos.getValueAt(row, 4)) * ((double) t_datos.getValueAt(row, 0))); double desc = ((double) value) / 100; double total = suma - (suma * desc); t_datos.setValueAt(total, row, 6); } sumaTotales(); } break; default: vector.setElementAt(value, col); this.dataVector.setElementAt(vector, row); fireTableCellUpdated(row, col); break; } } public Class getColumnClass(int columnIndex) { return types[columnIndex]; } public boolean isCellEditable(int rowIndex, int columnIndex) { return canEdit[columnIndex]; } }; return model; } public void sumaTotales() { try { iva = Integer.parseInt(t_iva1.getValue().toString()); double total = 0.0; for (int ren = 0; ren < t_datos.getRowCount(); ren++) { total += (double) t_datos.getValueAt(ren, 6); } t_subtotal.setText("" + total); t_subtotal.setValue(total); double valor_iva = total * (iva * 0.01); t_iva.setText("" + iva); t_iva.setValue(new Double(valor_iva)); total += valor_iva; t_total.setValue(total); } catch (Exception e) { e.printStackTrace(); } } public int OrdenFacturado(Orden or) { int val = -1; Session session = HibernateUtil.getSessionFactory().openSession(); try { Factura[] fac = (Factura[]) or.getFacturas().toArray(new Factura[0]); for (int r = 0; r < fac.length; r++) { if (fac[r].getEstadoFactura().compareTo("Pendiente") == 0 || fac[r].getEstadoFactura().compareTo("Facturado") == 0) { factura = fac[r]; val = fac[r].getIdFactura(); } } } catch (Exception e) { val = -1; } finally { if (session != null) if (session.isOpen()) session.close(); } return val; } private boolean guardarOrden() { Session session = HibernateUtil.getSessionFactory().openSession(); boolean ID = false; try { session.beginTransaction().begin(); orden_act = (Orden) session.get(Orden.class, Integer.parseInt(t_orden.getText())); //**********Almacenamos el Registro******************* Clientes cliente = new Clientes(); Tipo unidad_tipo = new Tipo(); Marca mr = new Marca(); if (t_inc.getText().compareTo("") != 0) orden_act.setInciso(t_inc.getText()); else orden_act.setInciso(null); /*if(t_nombre_cliente.getText().compareTo("")!=0) { cliente.setIdClientes(Integer.parseInt(l_id_cliente.getText())); registro.setClientes(cliente); }*/ if (t_siniestro.getText().compareTo("") != 0) orden_act.setSiniestro(t_siniestro.getText()); else orden_act.setSiniestro(null); if (t_poliza.getText().compareTo("") != 0) orden_act.setPoliza(t_poliza.getText()); else orden_act.setPoliza(null); if (t_reporte.getText().compareTo("") != 0) orden_act.setNoReporte(t_reporte.getText()); else orden_act.setNoReporte(null); if (t_tipo.getText().compareTo("") != 0) { unidad_tipo.setTipoNombre(t_tipo.getText()); orden_act.setTipo(unidad_tipo); } if (t_marca.getText().compareTo("") != 0) { mr.setIdMarca(l_marca.getText()); orden_act.setMarca(mr); } if (t_placas.getText().compareTo("") != 0) orden_act.setNoPlacas(t_placas.getText()); else orden_act.setNoPlacas(null); if (t_modelo.getText().compareTo("") != 0) orden_act.setModelo(Integer.parseInt(t_modelo.getText())); if (t_serie.getText().compareTo("") != 0) orden_act.setNoSerie(t_serie.getText()); else orden_act.setNoSerie(null); //registro.setKm(t_km.getText()); orden_act.setUsuarioByIdModificado(user); session.update(orden_act); session.getTransaction().commit(); ID = true; } catch (HibernateException he) { he.printStackTrace(); session.getTransaction().rollback(); ID = false; } if (session != null) if (session.isOpen()) session.close(); return ID; } void logis(int nota) { mysql = new Conexion(); String resp = mysql.conectarMSQL("red", "04650077", "logis.ddns.net", "3306", "mydb"); if (resp.compareTo("") == 0) { try { mysql.actualiza("update orden set no_factura=" + nota + " where id_orden=" + t_orden.getText()); } catch (Exception e) { e.printStackTrace(); } finally { mysql.desconectarMSQL(); } } } public void buscaOrden() { if (t_orden.getText().compareTo("") != 0) { mysql = new Conexion(); String resp = mysql.conectarMSQL("red", "04650077", "logis.ddns.net", "3306", "mydb"); if (resp.compareTo("") == 0) { try { ArrayList aux = mysql.Consulta( "select inciso, clientes.nombre, marca.id_marca, marca.marca_nombre, tipo_nombre, " + "no_serie, modelo, no_placas, poliza, siniestro, no_reporte, autorizado_facturar, no_factura, tipo_cliente, mo_directa, importe_hora, km " + "from orden left join marca on orden.id_marca=marca.id_marca " + "left join clientes on orden.id_cliente=clientes.id_clientes " + "left join compania on orden.id_compania=compania.id_compania " + "where id_orden=" + t_orden.getText()); if (aux.size() > 0) { orden = (ArrayList) aux.get(0); if ((boolean) orden.get(11) == true) { int id_fac = -1; if (orden.get(12) != null) id_fac = (int) orden.get(12); validaEdo(id_fac); if (id_fac <= 0) { //this.t_orden.setText(""+orden_act.getIdOrden()); this.consultaOrden(t_orden.getText()); } else { orden_act = null; borra_cajas(); habilita(false); t_orden.requestFocus(); int op = JOptionPane.showConfirmDialog(null, "La orden ya esta en facturacin con el nmero:" + id_fac + " desea consultarla?", "En proceso de Facturacin", JOptionPane.YES_NO_CANCEL_OPTION); if (op == 0) { t_orden.setText(""); Session session = HibernateUtil.getSessionFactory().openSession(); try { session.beginTransaction().begin(); factura = (Factura) session.get(Factura.class, id_fac); session.beginTransaction().commit(); Dimension d; if (factura.getAddenda() != null && factura.getEstadoFactura().compareTo("Facturado") == 0) { switch (factura.getAddenda()) { case "qualitas": QUALITAS genera = new QUALITAS(new Frame(), true, this.user, sessionPrograma, factura); d = Toolkit.getDefaultToolkit().getScreenSize(); genera.setLocation((d.width / 2) - (genera.getWidth() / 2), (d.height / 2) - (genera.getHeight() / 2)); genera.consulta(); genera.setVisible(true); genera.dispose(); genera = null; //factura=genera.getReturnStatus(); break; case "axa": AXA genera1 = new AXA(new Frame(), true, this.user, sessionPrograma, factura); d = Toolkit.getDefaultToolkit().getScreenSize(); genera1.setLocation((d.width / 2) - (genera1.getWidth() / 2), (d.height / 2) - (genera1.getHeight() / 2)); genera1.consulta(); genera1.setVisible(true); genera1.dispose(); genera1 = null; //factura=genera1.getReturnStatus(); break; case "gnp": GNP genera2 = new GNP(new Frame(), true, this.user, sessionPrograma, factura); d = Toolkit.getDefaultToolkit().getScreenSize(); genera2.setLocation((d.width / 2) - (genera2.getWidth() / 2), (d.height / 2) - (genera2.getHeight() / 2)); genera2.consulta(); genera2.setVisible(true); genera2.dispose(); genera2 = null; //factura=genera2.getReturnStatus(); break; //case "mapfre": // break; case "general": General genera3 = new General(new Frame(), true, this.user, sessionPrograma, factura); d = Toolkit.getDefaultToolkit().getScreenSize(); genera3.setLocation((d.width / 2) - (genera3.getWidth() / 2), (d.height / 2) - (genera3.getHeight() / 2)); genera3.consulta(); genera3.setVisible(true); genera3.dispose(); genera3 = null; //factura=genera3.getReturnStatus(); break; default: addendas.setSize(324, 135); d = Toolkit.getDefaultToolkit().getScreenSize(); addendas.setLocation((d.width / 2) - (addendas.getWidth() / 2), (d.height / 2) - (addendas.getHeight() / 2)); addendas.setVisible(true); break; } } else { addendas.setSize(324, 135); d = Toolkit.getDefaultToolkit().getScreenSize(); addendas.setLocation((d.width / 2) - (addendas.getWidth() / 2), (d.height / 2) - (addendas.getHeight() / 2)); addendas.setVisible(true); } } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "Error al consultar la orden"); } finally { if (session != null) if (session.isOpen()) session.close(); } } if (op == 2) { int op1 = JOptionPane.showConfirmDialog(null, "Confirma que desea eliminar la factura:" + id_fac + " de la orden:" + t_orden.getText(), "Eliminar factura de orden logis", JOptionPane.YES_NO_OPTION); if (op1 == 0) { mysql = new Conexion(); String respL = mysql.conectarMSQL("red", "04650077", "logis.ddns.net", "3306", "mydb"); if (respL.compareTo("") == 0) { try { int res = mysql.actualiza( "update orden set no_factura=null where id_orden=" + t_orden.getText()); if (res > 0) { t_orden.setText(""); borra_cajas(); habilita(false); t_datos.setModel(ModeloTablaReporte(0, columnas)); this.formatoTabla(); JOptionPane.showMessageDialog(null, "La factura se elimino de logis"); t_orden.requestFocus(); } } catch (Exception e) { e.printStackTrace(); } finally { mysql.desconectarMSQL(); } } } t_orden.setText(""); } if (op == 1 || op == -1) t_orden.setText(""); } } else { t_orden.setText(""); borra_cajas(); habilita(false); t_datos.setModel(ModeloTablaReporte(0, columnas)); this.formatoTabla(); JOptionPane.showMessageDialog(null, "La orden aun no esta lista para facturar"); t_orden.requestFocus(); } } else { JOptionPane.showMessageDialog(null, "La orden no existe"); t_orden.setText(""); borra_cajas(); habilita(false); t_datos.setModel(ModeloTablaReporte(0, columnas)); formatoTabla(); t_orden.requestFocus(); } } catch (Exception e) { e.printStackTrace(); } finally { mysql.desconectarMSQL(); } } else { JOptionPane.showMessageDialog(null, "Error al conextar con el servidor: " + resp); } } else { h = new Herramientas(user, 0); t_orden.setText(""); borra_cajas(); habilita(false); t_datos.setModel(ModeloTablaReporte(0, columnas)); formatoTabla(); t_orden.requestFocus(); } } int validaEdo(int id_fac) { int op = id_fac; if (id_fac > 0) { Session session = HibernateUtil.getSessionFactory().openSession(); try { Factura f = (Factura) session.get(Factura.class, id_fac); if (f != null) { if (f.getEstadoFactura().compareTo("Cancelado") == 0) { mysql = new Conexion(); String respL = mysql.conectarMSQL("red", "04650077", "logis.ddns.net", "3306", "mydb"); if (respL.compareTo("") == 0) { try { int res = mysql.actualiza( "update orden set no_factura=null where id_orden=" + t_orden.getText()); if (res > 0) { op = -1; } } catch (Exception e) { e.printStackTrace(); } finally { mysql.desconectarMSQL(); } } } } } catch (Exception e) { System.out.println(e); } finally { if (session != null) if (session.isOpen()) session.close(); } } return op; } }