Nómina
Código Fuente:
//Corona
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.DecimalFormat;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
/**
*
* @author Edgar Leyva Corona
*/
public class cia_corona extends javax.swing.JFrame {
cia_empleados obj=new cia_empleados();
DecimalFormat d=new DecimalFormat("##########.00");
int retardos,faltas,pro,sp;
double inasistencias,inasistenciast,salario,
sueldo,dt,sd,neta,toti,
infon,imss,isr,subt,pago,resultado;
String nom,tele,cuenta,nut,seg,ape;
String db = "ciacorona_nomina"; //Nombre de la base de datos
String url = "jdbc:mysql://localhost:3306/"+db;
String user = "root"; //Usuario de MySql
String pass = ""; //Password de entrada
DefaultTableModel modelo;
String sSQL = "";
static Connection coneccion;
static Statement instruccion;
DefaultListModel mod;
public cia_corona() {
initComponents();
mod = new DefaultListModel();
calcuiii.setModel(mod);
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
Calculo = new javax.swing.JTabbedPane();
jPanel1 = new javax.swing.JPanel();
jLabel2 = new javax.swing.JLabel();
jSeparator1 = new javax.swing.JSeparator();
jLabel3 = new javax.swing.JLabel();
nombre = new javax.swing.JTextField();
jLabel4 = new javax.swing.JLabel();
apellidos = new javax.swing.JTextField();
jLabel5 = new javax.swing.JLabel();
nutra = new javax.swing.JTextField();
jLabel6 = new javax.swing.JLabel();
seguro = new javax.swing.JTextField();
jLabel7 = new javax.swing.JLabel();
tel = new javax.swing.JTextField();
jSeparator3 = new javax.swing.JSeparator();
jLabel8 = new javax.swing.JLabel();
masc = new javax.swing.JRadioButton();
fem = new javax.swing.JRadioButton();
jLabel9 = new javax.swing.JLabel();
deptos = new javax.swing.JComboBox();
jLabel10 = new javax.swing.JLabel();
jLabel11 = new javax.swing.JLabel();
ret = new javax.swing.JTextField();
inas = new javax.swing.JTextField();
jLabel12 = new javax.swing.JLabel();
unobox = new javax.swing.JCheckBox();
tresbox = new javax.swing.JCheckBox();
cincobox = new javax.swing.JCheckBox();
jLabel13 = new javax.swing.JLabel();
cash = new javax.swing.JTextField();
salslider = new javax.swing.JSlider();
salprog = new javax.swing.JProgressBar();
jLabel14 = new javax.swing.JLabel();
jLabel15 = new javax.swing.JLabel();
jLabel16 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
calcuiii = new javax.swing.JList();
blist = new javax.swing.JButton();
calculo = new javax.swing.JButton();
jPanel2 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jSeparator2 = new javax.swing.JSeparator();
jLabel17 = new javax.swing.JLabel();
nomcom = new javax.swing.JTextField();
jLabel18 = new javax.swing.JLabel();
nutrat = new javax.swing.JTextField();
jLabel19 = new javax.swing.JLabel();
seguros = new javax.swing.JTextField();
jLabel20 = new javax.swing.JLabel();
sexo = new javax.swing.JTextField();
jLabel21 = new javax.swing.JLabel();
dep = new javax.swing.JTextField();
jSeparator4 = new javax.swing.JSeparator();
jLabel22 = new javax.swing.JLabel();
totina = new javax.swing.JTextField();
jLabel23 = new javax.swing.JLabel();
desci = new javax.swing.JTextField();
jLabel24 = new javax.swing.JLabel();
info = new javax.swing.JTextField();
jLabel25 = new javax.swing.JLabel();
ims1 = new javax.swing.JTextField();
jLabel26 = new javax.swing.JLabel();
is = new javax.swing.JTextField();
jLabel27 = new javax.swing.JLabel();
sub = new javax.swing.JTextField();
jLabel28 = new javax.swing.JLabel();
neto = new javax.swing.JTextField();
jLabel29 = new javax.swing.JLabel();
jScrollPane2 = new javax.swing.JScrollPane();
ares = new javax.swing.JTextArea();
nuevo = new javax.swing.JButton();
jLabel30 = new javax.swing.JLabel();
dinero = new javax.swing.JTextField();
jPanel3 = new javax.swing.JPanel();
jScrollPane5 = new javax.swing.JScrollPane();
tabdat = new javax.swing.JTable();
jScrollPane7 = new javax.swing.JScrollPane();
tabpag = new javax.swing.JTable();
borrar = new javax.swing.JButton();
modificar = new javax.swing.JButton();
insertar = new javax.swing.JButton();
consulta = new javax.swing.JButton();
modificar1 = new javax.swing.JButton();
borrar1 = new javax.swing.JButton();
consulta1 = new javax.swing.JButton();
insertar1 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
Calculo.setBackground(new java.awt.Color(255, 153, 153));
Calculo.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
Calculo.setTabPlacement(javax.swing.JTabbedPane.BOTTOM);
Calculo.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
Calculo.setFocusable(false);
Calculo.setFont(new java.awt.Font("Gisha", 1, 18)); // NOI18N
jPanel1.setBackground(new java.awt.Color(102, 102, 102));
jLabel2.setFont(new java.awt.Font("Gadugi", 1, 18)); // NOI18N
jLabel2.setForeground(new java.awt.Color(255, 255, 255));
jLabel2.setText("C.I.A. La Corona");
jLabel3.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel3.setForeground(new java.awt.Color(255, 255, 255));
jLabel3.setText("Nombre:");
jLabel4.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel4.setForeground(new java.awt.Color(255, 255, 255));
jLabel4.setText("Apellidos:");
jLabel5.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel5.setForeground(new java.awt.Color(255, 255, 255));
jLabel5.setText("No.Trabajador:");
jLabel6.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel6.setForeground(new java.awt.Color(255, 255, 255));
jLabel6.setText("Seguro Social:");
jLabel7.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel7.setForeground(new java.awt.Color(255, 255, 255));
jLabel7.setText("Teléfono:");
jLabel8.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel8.setForeground(new java.awt.Color(255, 255, 255));
jLabel8.setText("Sexo:");
masc.setBackground(new java.awt.Color(204, 204, 204));
masc.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N
masc.setForeground(new java.awt.Color(255, 255, 255));
masc.setText("M");
fem.setBackground(new java.awt.Color(204, 204, 204));
fem.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N
fem.setForeground(new java.awt.Color(255, 255, 255));
fem.setText("F");
jLabel9.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel9.setForeground(new java.awt.Color(255, 255, 255));
jLabel9.setText("Depto. :");
deptos.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "", "Distribuidores", "Oficinas", "Directivos", "Administrativos" }));
jLabel10.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel10.setForeground(new java.awt.Color(255, 255, 255));
jLabel10.setText("Retardos:");
jLabel11.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel11.setForeground(new java.awt.Color(255, 255, 255));
jLabel11.setText("Inasistencias:");
ret.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
retActionPerformed(evt);
}
});
inas.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
inasActionPerformed(evt);
}
});
jLabel12.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel12.setForeground(new java.awt.Color(255, 255, 255));
jLabel12.setText("Porcentaje IMSS:");
unobox.setBackground(new java.awt.Color(204, 204, 204));
unobox.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N
unobox.setForeground(new java.awt.Color(255, 255, 255));
unobox.setText("1%");
unobox.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
unoboxActionPerformed(evt);
}
});
tresbox.setBackground(new java.awt.Color(204, 204, 204));
tresbox.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N
tresbox.setForeground(new java.awt.Color(255, 255, 255));
tresbox.setText("3%");
tresbox.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
tresboxActionPerformed(evt);
}
});
cincobox.setBackground(new java.awt.Color(204, 204, 204));
cincobox.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N
cincobox.setForeground(new java.awt.Color(255, 255, 255));
cincobox.setText("5%");
cincobox.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cincoboxActionPerformed(evt);
}
});
jLabel13.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel13.setForeground(new java.awt.Color(255, 255, 255));
jLabel13.setText("Salario:");
cash.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cashActionPerformed(evt);
}
});
salslider.setBackground(new java.awt.Color(204, 204, 204));
salslider.setMajorTickSpacing(1500);
salslider.setMaximum(45000);
salslider.setValue(0);
salslider.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
salslider.addChangeListener(new javax.swing.event.ChangeListener() {
public void stateChanged(javax.swing.event.ChangeEvent evt) {
salsliderStateChanged(evt);
}
});
salprog.setBackground(new java.awt.Color(255, 51, 51));
salprog.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
salprog.setMaximum(45000);
salprog.setToolTipText("");
salprog.setStringPainted(true);
jLabel14.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel14.setForeground(new java.awt.Color(255, 255, 255));
jLabel14.setText("Salario Máximo:");
jLabel15.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel15.setForeground(new java.awt.Color(255, 255, 255));
jLabel15.setText("$45,000.00");
jLabel16.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel16.setForeground(new java.awt.Color(255, 255, 255));
jLabel16.setText("Cálculo de ISR, IMSS e Infonavit:");
jScrollPane1.setViewportView(calcuiii);
blist.setFont(new java.awt.Font("Trebuchet MS", 1, 12)); // NOI18N
blist.setText("VER");
blist.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
blistActionPerformed(evt);
}
});
calculo.setFont(new java.awt.Font("Trebuchet MS", 1, 18)); // NOI18N
calculo.setText("Calcular");
calculo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
calculoActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel16, javax.swing.GroupLayout.PREFERRED_SIZE, 190, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(0, 0, Short.MAX_VALUE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 190, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(blist)
.addGap(102, 102, 102)
.addComponent(calculo, javax.swing.GroupLayout.PREFERRED_SIZE, 156, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jLabel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jSeparator1)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel5)
.addComponent(jLabel4)
.addComponent(jLabel3))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(apellidos, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(nutra, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(nombre, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel6)
.addComponent(jLabel7))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(tel, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(seguro, javax.swing.GroupLayout.PREFERRED_SIZE, 105, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(masc)
.addGap(18, 18, 18)
.addComponent(fem))))
.addComponent(jSeparator3))
.addComponent(jLabel8))
.addGap(46, 46, 46)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel9)
.addComponent(jLabel10)
.addComponent(jLabel11))
.addGap(27, 27, 27)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(inas, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(ret, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(deptos, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel12)
.addComponent(jLabel13)
.addComponent(jLabel14)
.addComponent(jLabel15, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(unobox)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(tresbox))
.addComponent(cash))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(cincobox))
.addComponent(salslider, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
.addComponent(salprog, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE))))))
.addContainerGap(196, Short.MAX_VALUE))))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(salslider, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(nombre, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel9)
.addComponent(deptos, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4)
.addComponent(apellidos, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel10)
.addComponent(ret, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(9, 9, 9)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel5)
.addComponent(nutra, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel11)
.addComponent(inas, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel6)
.addComponent(seguro, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel12)
.addComponent(unobox)
.addComponent(tresbox)
.addComponent(cincobox))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel7)
.addComponent(tel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel13, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(cash, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel8)
.addComponent(masc)
.addComponent(fem))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jSeparator3, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(17, 17, 17)
.addComponent(jLabel14)))))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(salprog, javax.swing.GroupLayout.DEFAULT_SIZE, 24, Short.MAX_VALUE)
.addComponent(jLabel15, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(2, 2, 2)
.addComponent(jLabel16, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(blist)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 85, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(calculo, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(340, 340, 340))
);
Calculo.addTab("Datos ", jPanel1);
jPanel2.setBackground(new java.awt.Color(153, 153, 153));
jLabel1.setFont(new java.awt.Font("Gadugi", 1, 18)); // NOI18N
jLabel1.setForeground(new java.awt.Color(255, 255, 255));
jLabel1.setText("C.I.A. La Corona");
jLabel17.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel17.setForeground(new java.awt.Color(255, 255, 255));
jLabel17.setText("Nombre:");
nomcom.setEditable(false);
nomcom.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
nomcomActionPerformed(evt);
}
});
jLabel18.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel18.setForeground(new java.awt.Color(255, 255, 255));
jLabel18.setText("No.Trabajador:");
nutrat.setEditable(false);
nutrat.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
nutratActionPerformed(evt);
}
});
jLabel19.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel19.setForeground(new java.awt.Color(255, 255, 255));
jLabel19.setText("Seguro Social:");
seguros.setEditable(false);
seguros.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
segurosActionPerformed(evt);
}
});
jLabel20.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel20.setForeground(new java.awt.Color(255, 255, 255));
jLabel20.setText("Sexo:");
sexo.setEditable(false);
sexo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
sexoActionPerformed(evt);
}
});
jLabel21.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel21.setForeground(new java.awt.Color(255, 255, 255));
jLabel21.setText("Departamento:");
dep.setEditable(false);
jLabel22.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel22.setForeground(new java.awt.Color(255, 255, 255));
jLabel22.setText("Total de Inasistencias:");
totina.setEditable(false);
totina.setText("0");
jLabel23.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel23.setForeground(new java.awt.Color(255, 255, 255));
jLabel23.setText("Descuento por Inasistencias:");
desci.setEditable(false);
desci.setText("0");
desci.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
desciActionPerformed(evt);
}
});
jLabel24.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel24.setForeground(new java.awt.Color(255, 255, 255));
jLabel24.setText("Infonavit:");
info.setText("0");
jLabel25.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel25.setForeground(new java.awt.Color(255, 255, 255));
jLabel25.setText("IMSS:");
ims1.setText("0");
ims1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ims1ActionPerformed(evt);
}
});
jLabel26.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel26.setForeground(new java.awt.Color(255, 255, 255));
jLabel26.setText("ISR:");
is.setText("0");
is.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
isActionPerformed(evt);
}
});
jLabel27.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel27.setForeground(new java.awt.Color(255, 255, 255));
jLabel27.setText("Subtotal:");
sub.setText("0");
jLabel28.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel28.setForeground(new java.awt.Color(255, 255, 255));
jLabel28.setText("Salario Neto:");
neto.setText("0");
jLabel29.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel29.setForeground(new java.awt.Color(255, 255, 255));
jLabel29.setText("Resumen:");
ares.setEditable(false);
ares.setBackground(new java.awt.Color(102, 102, 102));
ares.setColumns(20);
ares.setFont(new java.awt.Font("Bitstream Vera Sans Mono", 0, 10)); // NOI18N
ares.setForeground(new java.awt.Color(255, 255, 255));
ares.setRows(5);
ares.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));
jScrollPane2.setViewportView(ares);
nuevo.setFont(new java.awt.Font("Trebuchet MS", 1, 12)); // NOI18N
nuevo.setText("Nuevo");
nuevo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
nuevoActionPerformed(evt);
}
});
jLabel30.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N
jLabel30.setForeground(new java.awt.Color(255, 255, 255));
jLabel30.setText("Salario:");
dinero.setText("0");
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jScrollPane2)
.addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jSeparator2)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel18)
.addComponent(jLabel17))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(nomcom, javax.swing.GroupLayout.PREFERRED_SIZE, 135, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(nutrat, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel19)
.addComponent(jLabel20))
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(18, 18, 18)
.addComponent(seguros, javax.swing.GroupLayout.PREFERRED_SIZE, 107, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(20, 20, 20)
.addComponent(sexo, javax.swing.GroupLayout.PREFERRED_SIZE, 107, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(jLabel21)
.addGap(18, 18, 18)
.addComponent(dep))
.addComponent(jSeparator4)
.addComponent(jLabel29))
.addGap(63, 63, 63)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(jLabel22)
.addGap(50, 50, 50)
.addComponent(totina, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel23)
.addComponent(jLabel24)
.addComponent(jLabel25)
.addComponent(jLabel26)
.addComponent(jLabel27)
.addComponent(jLabel28)
.addComponent(jLabel30))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(desci)
.addComponent(info)
.addComponent(ims1)
.addComponent(is)
.addComponent(sub)
.addComponent(neto)
.addComponent(nuevo, javax.swing.GroupLayout.DEFAULT_SIZE, 104, Short.MAX_VALUE)
.addComponent(dinero))))
.addContainerGap(127, Short.MAX_VALUE))
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jSeparator2, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel17)
.addComponent(nomcom, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel22)
.addComponent(totina, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(nutrat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel23)
.addComponent(desci, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel19)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(seguros, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel24)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel20)
.addComponent(sexo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel25))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel21)
.addComponent(dep, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel26))
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(11, 11, 11)
.addComponent(jSeparator4, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel30))))
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(info, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(ims1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(is, 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)
.addComponent(dinero, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel29)
.addComponent(jLabel27))
.addComponent(sub, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel28)
.addComponent(neto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(10, 10, 10)
.addComponent(nuevo, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(53, Short.MAX_VALUE))
);
Calculo.addTab("Cálculo", jPanel2);
jPanel3.setBackground(new java.awt.Color(153, 153, 153));
tabdat.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Nombre", "No. Trbajador", "Seguro ", "Departamento"
}
) {
boolean[] canEdit = new boolean [] {
false, false, false, false
};
public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
jScrollPane5.setViewportView(tabdat);
tabpag.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null, null, null, null},
{null, null, null, null, null, null, null},
{null, null, null, null, null, null, null},
{null, null, null, null, null, null, null}
},
new String [] {
"No. Trabajador", "Desc. Inas.", "Infonavit", "IMSS", "ISR", "Salario", "Salario Neto"
}
) {
boolean[] canEdit = new boolean [] {
false, false, false, false, false, true, true
};
public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
jScrollPane7.setViewportView(tabpag);
borrar.setText("Borrar");
borrar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
borrarActionPerformed(evt);
}
});
modificar.setText("Modificar");
modificar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
modificarActionPerformed(evt);
}
});
insertar.setText("Insertar");
insertar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
insertarActionPerformed(evt);
}
});
consulta.setText("Consulta");
consulta.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
consultaActionPerformed(evt);
}
});
modificar1.setText("Modificar");
modificar1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
modificar1ActionPerformed(evt);
}
});
borrar1.setText("Borrar");
borrar1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
borrar1ActionPerformed(evt);
}
});
consulta1.setText("Consulta");
consulta1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
consulta1ActionPerformed(evt);
}
});
insertar1.setText("Insertar");
insertar1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
insertar1ActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
jPanel3.setLayout(jPanel3Layout);
jPanel3Layout.setHorizontalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addGap(125, 125, 125)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addComponent(insertar)
.addGap(18, 18, 18)
.addComponent(consulta)
.addGap(18, 18, 18)
.addComponent(borrar)
.addGap(18, 18, 18)
.addComponent(modificar))
.addGroup(jPanel3Layout.createSequentialGroup()
.addComponent(insertar1)
.addGap(18, 18, 18)
.addComponent(consulta1)
.addGap(18, 18, 18)
.addComponent(borrar1)
.addGap(18, 18, 18)
.addComponent(modificar1))))
.addGroup(jPanel3Layout.createSequentialGroup()
.addGap(30, 30, 30)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jScrollPane7, javax.swing.GroupLayout.DEFAULT_SIZE, 653, Short.MAX_VALUE)
.addComponent(jScrollPane5))))
.addContainerGap(32, Short.MAX_VALUE))
);
jPanel3Layout.setVerticalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addGap(34, 34, 34)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(insertar)
.addComponent(consulta)
.addComponent(borrar)
.addComponent(modificar))
.addGap(18, 18, 18)
.addComponent(jScrollPane5, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 56, Short.MAX_VALUE)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(modificar1)
.addComponent(borrar1)
.addComponent(consulta1)
.addComponent(insertar1))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane7, javax.swing.GroupLayout.PREFERRED_SIZE, 112, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(46, 46, 46))
);
Calculo.addTab("Base de Datos", jPanel3);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(Calculo, javax.swing.GroupLayout.PREFERRED_SIZE, 722, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(10, 10, 10))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(Calculo, javax.swing.GroupLayout.PREFERRED_SIZE, 471, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(10, 10, 10))
);
pack();
}// </editor-fold>
private void nuevoActionPerformed(java.awt.event.ActionEvent evt) {
mod.removeAllElements();
nombre.setText("");
apellidos.setText("");
nutra.setText("");
seguro.setText("");
tel.setText("");
ret.setText("");
inas.setText("");
cash.setText("");
nomcom.setText("");
nutrat.setText("");
seguros.setText("");
sexo.setText("");
dep.setText("");
totina.setText("");
info.setText("");
ims1.setText("");
sub.setText("");
is.setText("");
neto.setText("");
desci.setText("");
salprog.setValue(0);
salslider.setValue(0);
unobox.setSelected(false);
tresbox.setSelected(false);
cincobox.setSelected(false);
masc.setSelected(false);
fem.setSelected(false);
dinero.setText("");
deptos.setSelectedIndex(0);
ares.setText("");
}
private void isActionPerformed(java.awt.event.ActionEvent evt) {
}
private void ims1ActionPerformed(java.awt.event.ActionEvent evt) {
}
private void desciActionPerformed(java.awt.event.ActionEvent evt) {
}
private void sexoActionPerformed(java.awt.event.ActionEvent evt) {
}
private void segurosActionPerformed(java.awt.event.ActionEvent evt) {
}
private void nutratActionPerformed(java.awt.event.ActionEvent evt) {
}
private void calculoActionPerformed(java.awt.event.ActionEvent evt) {
cash.getText();
salario=Integer.parseInt(cash.getText());
ret.getText();
retardos=Integer.parseInt(ret.getText());
inas.getText();
inasistencias=Integer.parseInt(inas.getText());
String mensaje="";
if(masc.isSelected()){
mensaje=mensaje+"Masculino";
}else if(fem.isSelected()){
mensaje=mensaje+"Femenino";
}
infon=salario*.05;
sexo.setText(mensaje);
if(unobox.isSelected()==true){
imss=salario*.01;
}else if (tresbox.isSelected()==true){
imss=salario*.03;
}else if(cincobox.isSelected()==true){
imss=salario*.05;
}
nom=nombre.getText();
ape=apellidos.getText();
nomcom.setText(nom+" "+ape);
nutrat.setText(nutra.getText());
seguros.setText(seguro.getText());
Integer DeptIndex=deptos.getSelectedIndex();
String Dept=null;
if(DeptIndex.equals(1)){
Dept="Distribuidores";}
else if(DeptIndex.equals(2)){
Dept="Oficinas";
}else if(DeptIndex.equals(3)){
Dept="Directivos";
}else if(DeptIndex.equals(4)){
Dept="Administrativos";
}else if(DeptIndex.equals(0)){
Dept="No selecciono";
}
dep.setText(Dept);
faltas=retardos/3;
inasistencias=inasistencias+faltas;
sd=salario/15;
dt=15-inasistencias;
sueldo=sd*dt;
isr=(infon+imss)*.03;
pago=subt+isr;
toti=salario-sueldo;
subt=infon+imss+toti+isr;
neta=salario-subt;
totina.setText(""+inasistencias);
info.setText(d.format(infon));
ims1.setText(d.format(imss));
sub.setText(d.format(subt));
is.setText(d.format(isr));
neto.setText(d.format(neta));
desci.setText(d.format(toti));
pro=Integer.parseInt(cash.getText());
dinero.setText(d.format(pro));
int ineto=(int) pro;
sp=ineto;
salprog.setValue(sp);
ares.setText("Resumen del empleado\n"+"Nombre: "+nom+" "+ape+"\n"+"No. de Trabajador: "+nutra.getText()+
"\n"+"Seguro Social: "+seguro.getText()+"\n"+"Departamento: "+Dept+"\n"+"Salario: "+d.format(salario)+"\n"
+"Descuentos totales: -"+d.format(subt)+"\n"+"Sueldo Neto: "+d.format(pro));
}
private void blistActionPerformed(java.awt.event.ActionEvent evt) {
mod.addElement("ISR = (IMSS+INFONAVIT)*(.3)");
mod.addElement("IMSS = salario*(.1), (.3), (.5)");
mod.addElement("INFONAVIT =Salario*(.5)");
}
private void salsliderStateChanged(javax.swing.event.ChangeEvent evt) {
cash.setText(String.valueOf(salslider.getValue()));
int salslide;
salslide = Integer.parseInt(cash.getText());
salprog.setValue(salslide);
}
private void cashActionPerformed(java.awt.event.ActionEvent evt) {
cash.getText();
salario=Integer.parseInt(cash.getText());
}
private void cincoboxActionPerformed(java.awt.event.ActionEvent evt) {
}
private void tresboxActionPerformed(java.awt.event.ActionEvent evt) {
}
private void unoboxActionPerformed(java.awt.event.ActionEvent evt) {
}
private void inasActionPerformed(java.awt.event.ActionEvent evt) {
inas.getText();
inasistencias=Integer.parseInt(inas.getText());
}
private void retActionPerformed(java.awt.event.ActionEvent evt) {
ret.getText();
retardos=Integer.parseInt(ret.getText());
}
private void borrarActionPerformed(java.awt.event.ActionEvent evt) {
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// eliminar desde la base de datos
int emp=Integer.parseInt(nutrat.getText());
instruccion.executeUpdate("delete from datos where d_notrabajador='"+emp+"'");
JOptionPane.showMessageDialog(null," Registro Eliminado");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error al Borrar el Registro",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void modificarActionPerformed(java.awt.event.ActionEvent evt) {
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
int a=Integer.parseInt(nutrat.getText());
try{
instruccion.executeUpdate(" update datos "
+ "set d_nombre='"+nomcom.getText()+"',"
+ " d_segurosoc='"+seguros.getText()+"'"
+ " d_depto='"+dep.getText()+"'"
+ "where d_notrabajador='"+a+"'");
JOptionPane.showMessageDialog(null,"Registro Modificado");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"No existe Registro",JOptionPane.ERROR_MESSAGE);
}
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error al modificar datos",JOptionPane.ERROR_MESSAGE);
}
catch(ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void insertarActionPerformed(java.awt.event.ActionEvent evt) {
String d_nombre=nomcom.getText();
String d_notrabajador=nutra.getText();
String d_segurosoc=seguro.getText();
String d_depto=dep.getText();
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
instruccion.executeUpdate
("insert into datos values('"+d_nombre+"','"+d_notrabajador+"','"+d_segurosoc+"','"+d_depto+"')");
JOptionPane.showMessageDialog(null,"Creacion del Registro Correctamente");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"no se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
}
private void consultaActionPerformed(java.awt.event.ActionEvent evt) {
modelo = new DefaultTableModel();
// Creamos las columnas.
modelo.addColumn("Nombre");
modelo.addColumn("No. Trabajador");
modelo.addColumn("Seguro");
modelo.addColumn("Departamento");
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
ResultSet result=instruccion.executeQuery("select * FROM datos ORDER BY d_notrabajador");
while(result.next()){
//son 4 columnas, la dimesion del objeto datos de 4
Object[] datos = new Object[4];
for (int i = 0; i < 4; i++) {
datos[i] = result.getObject(i+1);
}
modelo.addRow(datos);
}
tabdat.setModel(modelo);
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error en la base de datos",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador ",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void modificar1ActionPerformed(java.awt.event.ActionEvent evt) {
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
int a=Integer.parseInt(nutrat.getText());
try{
instruccion.executeUpdate(" update calculo "
+ "set c_desinas='"+desci.getText()+"',"
+ " c_info='"+info.getText()+"'"
+ " c_imss='"+ims1.getText()+"'"
+ " c_isr='"+is.getText()+"'"
+ " c_sal='"+cash.getText()+"'"
+ " c_neto='"+neto.getText()+"'"
+ "where d_notrabajador='"+a+"'");
JOptionPane.showMessageDialog(null,"Registro Modificado");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"No existe Registro",JOptionPane.ERROR_MESSAGE);
}
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error al modificar datos",JOptionPane.ERROR_MESSAGE);
}
catch(ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void borrar1ActionPerformed(java.awt.event.ActionEvent evt) {
//Borrar1
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// eliminar desde la base de datos
int emp=Integer.parseInt(nutrat.getText());
instruccion.executeUpdate("delete from calculo where c_notrabajador='"+emp+"'");
JOptionPane.showMessageDialog(null,"Registro Eliminado");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error al Borrar el Registro",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void consulta1ActionPerformed(java.awt.event.ActionEvent evt) {
modelo = new DefaultTableModel();
// Creamos las columnas. MODIFICAME
modelo.addColumn("No. Trabajador");
modelo.addColumn("Desc. Inas.");
modelo.addColumn("Infonavit");
modelo.addColumn("IMSS");
modelo.addColumn("ISR");
modelo.addColumn("Salario");
modelo.addColumn("Salario Neto");
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
ResultSet result=instruccion.executeQuery("select * FROM calculo ORDER BY c_notrabajador");
while(result.next()){
//son 8 columnas, la dimesion del objeto datos de 7
Object[] datos = new Object[7];
for (int i = 0; i < 7; i++) {
datos[i] = result.getObject(i+1);
}
modelo.addRow(datos);
}
tabpag.setModel(modelo);
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error en la base de datos",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador ",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void insertar1ActionPerformed(java.awt.event.ActionEvent evt) {
String c_notrabajador=nutrat.getText();
String c_desinas=desci.getText();
String c_info=info.getText();
String c_imss=ims1.getText();
String c_isr=is.getText();
String c_sal=cash.getText();
String c_neto=neto.getText();
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/ciacorona_nomina","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
instruccion.executeUpdate
("insert into calculo values"
+ "('"+c_notrabajador+"','"+c_desinas+"','"+c_info+"','"+c_imss+"','"
+c_isr+"','"+c_sal+"','"+c_neto+"')");
JOptionPane.showMessageDialog(null,"Creacion del Registro Correctamente");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
}
private void nomcomActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(cia_corona.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(cia_corona.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(cia_corona.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(cia_corona.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new cia_corona().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JTabbedPane Calculo;
private javax.swing.JTextField apellidos;
private javax.swing.JTextArea ares;
private javax.swing.JButton blist;
private javax.swing.JButton borrar;
private javax.swing.JButton borrar1;
private javax.swing.JList calcuiii;
private javax.swing.JButton calculo;
private javax.swing.JTextField cash;
private javax.swing.JCheckBox cincobox;
private javax.swing.JButton consulta;
private javax.swing.JButton consulta1;
private javax.swing.JTextField dep;
private javax.swing.JComboBox deptos;
private javax.swing.JTextField desci;
private javax.swing.JTextField dinero;
private javax.swing.JRadioButton fem;
private javax.swing.JTextField ims1;
private javax.swing.JTextField inas;
private javax.swing.JTextField info;
private javax.swing.JButton insertar;
private javax.swing.JButton insertar1;
private javax.swing.JTextField is;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
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 jLabel26;
private javax.swing.JLabel jLabel27;
private javax.swing.JLabel jLabel28;
private javax.swing.JLabel jLabel29;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel30;
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 jPanel2;
private javax.swing.JPanel jPanel3;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JScrollPane jScrollPane5;
private javax.swing.JScrollPane jScrollPane7;
private javax.swing.JSeparator jSeparator1;
private javax.swing.JSeparator jSeparator2;
private javax.swing.JSeparator jSeparator3;
private javax.swing.JSeparator jSeparator4;
private javax.swing.JRadioButton masc;
private javax.swing.JButton modificar;
private javax.swing.JButton modificar1;
private javax.swing.JTextField neto;
private javax.swing.JTextField nombre;
private javax.swing.JTextField nomcom;
private javax.swing.JButton nuevo;
private javax.swing.JTextField nutra;
private javax.swing.JTextField nutrat;
private javax.swing.JTextField ret;
private javax.swing.JProgressBar salprog;
private javax.swing.JSlider salslider;
private javax.swing.JTextField seguro;
private javax.swing.JTextField seguros;
private javax.swing.JTextField sexo;
private javax.swing.JTextField sub;
private javax.swing.JTable tabdat;
private javax.swing.JTable tabpag;
private javax.swing.JTextField tel;
private javax.swing.JTextField totina;
private javax.swing.JCheckBox tresbox;
private javax.swing.JCheckBox unobox;
// End of variables declaration
}
Código Fuente, Segundo programa:
import java.text.DecimalFormat;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
public class nominas extends javax.swing.JFrame {
empleado obj=new empleado();
int retardos, faltas, inasistencias, salaryProgress, empnum;
double inasistenciast, salario, sueldo, dt,sd ,
neto, tot, infon, imss, isr, subt, pago, resultado;
String Nom, ApPat, ApMat;
String db = "sagn"; //Nombre de la base de datos
String url = "jdbc:mysql://localhost:3306/"+db;
String user = "root"; //Usuario de MySql
String pass = ""; //Password de entrada
DefaultTableModel modelo;
String sSQL = "";
static Connection coneccion;
static Statement instruccion;
public nominas() {
setResizable(false);
initComponents();
setLocation(300,50);
}
/**
* 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">
private void initComponents() {
jMenuItem1 = new javax.swing.JMenuItem();
jPanel1 = new javax.swing.JPanel();
Gender = new javax.swing.ButtonGroup();
MainFrame = new javax.swing.JTabbedPane();
CalcPanel = new javax.swing.JPanel();
Name = new javax.swing.JTextField();
NameLabel = new javax.swing.JLabel();
Retard = new javax.swing.JTextField();
RetLabel = new javax.swing.JLabel();
FaultLabel = new javax.swing.JLabel();
Fault = new javax.swing.JTextField();
Salary = new javax.swing.JTextField();
SalaryLabel = new javax.swing.JLabel();
TotalFaultLabel = new javax.swing.JLabel();
TotalFault = new javax.swing.JTextField();
Cotizar = new javax.swing.JButton();
Copyright1 = new javax.swing.JLabel();
Header1 = new javax.swing.JLabel();
SAGN1 = new javax.swing.JLabel();
jSeparator1 = new javax.swing.JSeparator();
SAGN01 = new javax.swing.JLabel();
APat = new javax.swing.JTextField();
APaternoLabel = new javax.swing.JLabel();
AMat = new javax.swing.JTextField();
AMaterno = new javax.swing.JLabel();
Copyright3 = new javax.swing.JLabel();
EmpNo = new javax.swing.JTextField();
EmpNoLabel = new javax.swing.JLabel();
GenderLabel = new javax.swing.JLabel();
jRadioButtonM = new javax.swing.JRadioButton();
jRadioButtonF = new javax.swing.JRadioButton();
DepLabel = new javax.swing.JLabel();
DepComboBox = new javax.swing.JComboBox();
BonoPunt = new javax.swing.JCheckBox();
BonoProd = new javax.swing.JCheckBox();
BonoCap = new javax.swing.JCheckBox();
jScrollPane1 = new javax.swing.JScrollPane();
Listado = new javax.swing.JTextArea();
ListadoHeader = new javax.swing.JTextField();
ClearCalc = new javax.swing.JButton();
SalarySlider = new javax.swing.JSlider();
SalaryBar = new javax.swing.JProgressBar();
jScrollPane2 = new javax.swing.JScrollPane();
jTree = new javax.swing.JTree();
ListadoHeader1 = new javax.swing.JTextField();
loadPic = new javax.swing.JButton();
photoContainer = new javax.swing.JPanel();
Kain = new javax.swing.JLabel();
ResPanel = new javax.swing.JPanel();
jSeparator2 = new javax.swing.JSeparator();
Name2 = new javax.swing.JTextField();
NameLabel2 = new javax.swing.JLabel();
DescFaultLabel = new javax.swing.JLabel();
DescFault = new javax.swing.JTextField();
Infonavit = new javax.swing.JTextField();
InfonavitLabel = new javax.swing.JLabel();
IMSSLabel = new javax.swing.JLabel();
IMSS = new javax.swing.JTextField();
ISR = new javax.swing.JTextField();
ISRLabel = new javax.swing.JLabel();
SubTotalLabel = new javax.swing.JLabel();
SubTotal = new javax.swing.JTextField();
SalaryNetoLabel = new javax.swing.JLabel();
SalaryNeto = new javax.swing.JTextField();
TotalFaultLabel2 = new javax.swing.JLabel();
TotalFault2 = new javax.swing.JTextField();
Header2 = new javax.swing.JLabel();
SAGN2 = new javax.swing.JLabel();
SAGN02 = new javax.swing.JLabel();
Copyright2 = new javax.swing.JLabel();
Copyright4 = new javax.swing.JLabel();
EmpNo2 = new javax.swing.JTextField();
EmpNoLabel2 = new javax.swing.JLabel();
GenderLabel2 = new javax.swing.JLabel();
Gender1 = new javax.swing.JTextField();
DescFaultLabel1 = new javax.swing.JLabel();
Departamento = new javax.swing.JTextField();
ClearRes = new javax.swing.JButton();
jScrollPane3 = new javax.swing.JScrollPane();
EmpTable = new javax.swing.JTable();
HeaderEmpTable = new javax.swing.JTextField();
HeaderNominaTable = new javax.swing.JTextField();
ClrEmpTable = new javax.swing.JButton();
InsEmpTable = new javax.swing.JButton();
UpdEmpTable = new javax.swing.JButton();
QryEmpTable = new javax.swing.JButton();
ClrNomTable = new javax.swing.JButton();
InsNomTable = new javax.swing.JButton();
UpdNomTable = new javax.swing.JButton();
QryNomTable = new javax.swing.JButton();
$a = new javax.swing.JTextField();
$b = new javax.swing.JTextField();
$c = new javax.swing.JTextField();
$d = new javax.swing.JTextField();
$e = new javax.swing.JTextField();
f = new javax.swing.JTextField();
jScrollPane4 = new javax.swing.JScrollPane();
NomTable = new javax.swing.JTable();
jMenuItem1.setText("jMenuItem1");
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 100, Short.MAX_VALUE)
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 100, Short.MAX_VALUE)
);
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("S.A.G.N. - C.I.A. LA CORONA S.A. de C.V");
setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
MainFrame.setBackground(new java.awt.Color(204, 204, 204));
MainFrame.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED, java.awt.Color.gray, java.awt.Color.darkGray, java.awt.Color.gray, java.awt.Color.lightGray));
MainFrame.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
MainFrame.setFocusable(false);
MainFrame.setPreferredSize(new java.awt.Dimension(820, 500));
CalcPanel.setBackground(new java.awt.Color(204, 204, 204));
CalcPanel.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
CalcPanel.setFocusCycleRoot(true);
Name.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
NameActionPerformed(evt);
}
});
NameLabel.setText("Nombre:");
Retard.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
RetardActionPerformed(evt);
}
});
RetLabel.setText("Retardos:");
FaultLabel.setText("Inasistencias:");
Fault.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
FaultActionPerformed(evt);
}
});
Salary.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
SalaryActionPerformed(evt);
}
});
SalaryLabel.setText("Salario Quincenal:");
TotalFaultLabel.setText("Total de Inasistencias:");
TotalFault.setEditable(false);
TotalFault.setBackground(new java.awt.Color(204, 204, 204));
TotalFault.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
TotalFaultActionPerformed(evt);
}
});
Cotizar.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
Cotizar.setText("COTIZAR");
Cotizar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
CotizarActionPerformed(evt);
}
});
Cotizar.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
CotizarKeyPressed(evt);
}
});
Copyright1.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N
Copyright1.setForeground(new java.awt.Color(51, 51, 51));
Copyright1.setText("Developed by Ing. Al Franco - 2013 copyright (c).");
Header1.setFont(new java.awt.Font("Bauhaus 93", 2, 24)); // NOI18N
Header1.setForeground(new java.awt.Color(51, 51, 51));
Header1.setText("C.I.A. LA CORONA S.A. de C.V.");
SAGN1.setFont(new java.awt.Font("Bauhaus 93", 2, 18)); // NOI18N
SAGN1.setForeground(new java.awt.Color(51, 51, 51));
SAGN1.setText("S.A.G.N.");
SAGN01.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N
SAGN01.setForeground(new java.awt.Color(51, 51, 51));
SAGN01.setText("Sistema automatizado de gestión de nomina.");
APat.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
APatActionPerformed(evt);
}
});
APaternoLabel.setText("A. Paterno:");
AMat.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
AMatActionPerformed(evt);
}
});
AMaterno.setText("A. Materno:");
Copyright3.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N
Copyright3.setForeground(new java.awt.Color(51, 51, 51));
Copyright3.setText("Ver. a0.24.04.13");
EmpNo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
EmpNoActionPerformed(evt);
}
});
EmpNoLabel.setText("Numero de Empleado:");
GenderLabel.setText("Sexo:");
jRadioButtonM.setBackground(new java.awt.Color(204, 204, 204));
Gender.add(jRadioButtonM);
jRadioButtonM.setText("Masculino");
jRadioButtonF.setBackground(new java.awt.Color(204, 204, 204));
Gender.add(jRadioButtonF);
jRadioButtonF.setText("Femenino");
jRadioButtonF.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jRadioButtonFActionPerformed(evt);
}
});
DepLabel.setText("Departamento:");
DepComboBox.setModel(new javax.swing.DefaultComboBoxModel(new String[] { " ", "Calidad", "Sistemas", "Administrativo", "Rescursos Humanos" }));
DepComboBox.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
DepComboBoxActionPerformed(evt);
}
});
BonoPunt.setBackground(new java.awt.Color(204, 204, 204));
BonoPunt.setText("Bono Puntualidad");
BonoPunt.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BonoPuntActionPerformed(evt);
}
});
BonoProd.setBackground(new java.awt.Color(204, 204, 204));
BonoProd.setText("Bono Productividad");
BonoCap.setBackground(new java.awt.Color(204, 204, 204));
BonoCap.setText("Bono Certificación");
BonoCap.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BonoCapActionPerformed(evt);
}
});
Listado.setEditable(false);
Listado.setColumns(20);
Listado.setFont(new java.awt.Font("Lucida Console", 0, 13)); // NOI18N
Listado.setRows(5);
Listado.setText("+-------------------------------+\n| CALIDAD: |\n|-------------------------------|\n| * Puntualidad: $ 600.00 |\n| * Productividad: $ 1000.00 |\n| * Certificación: $ 2500.00 |\n|-------------------------------|\n| SISTEMAS: |\n|-------------------------------|\n| * Puntualidad: $ 400.00 |\n| * Productividad: $ 1500.00 |\n| * Certificación: $ 3500.00 |\n|-------------------------------|\n| ADMINISTRATIVO: |\n|-------------------------------|\n| * Puntualidad: $ 600.00 |\n| * Productividad: $ 2500.00 |\n| * Certificación: $ 5000.00 |\n|-------------------------------|\n| RECURSOS HUMANOS: |\n|-------------------------------|\n| * Puntualidad: $ 550.00 |\n| * Productividad: $ 2000.00 |\n| * Certificación: $ 3000.00 |\n+-------------------------------+");
jScrollPane1.setViewportView(Listado);
ListadoHeader.setEditable(false);
ListadoHeader.setBackground(new java.awt.Color(204, 204, 204));
ListadoHeader.setFont(new java.awt.Font("Aharoni", 0, 12)); // NOI18N
ListadoHeader.setForeground(new java.awt.Color(51, 51, 51));
ListadoHeader.setHorizontalAlignment(javax.swing.JTextField.CENTER);
ListadoHeader.setText("LISTADO DE BONOS POR DEPARTAMENTO");
ListadoHeader.setToolTipText("");
ListadoHeader.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));
ClearCalc.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
ClearCalc.setText("BORRAR");
ClearCalc.setPreferredSize(new java.awt.Dimension(80, 23));
ClearCalc.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ClearCalcActionPerformed(evt);
}
});
SalarySlider.setBackground(new java.awt.Color(204, 204, 204));
SalarySlider.setMajorTickSpacing(1000);
SalarySlider.setMaximum(30000);
SalarySlider.addChangeListener(new javax.swing.event.ChangeListener() {
public void stateChanged(javax.swing.event.ChangeEvent evt) {
SalarySliderStateChanged(evt);
}
});
SalaryBar.setBackground(new java.awt.Color(204, 204, 204));
SalaryBar.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
SalaryBar.setForeground(new java.awt.Color(0, 0, 0));
SalaryBar.setMaximum(30000);
SalaryBar.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
SalaryBar.setString("Max: $ 30,000.00");
SalaryBar.setStringPainted(true);
javax.swing.tree.DefaultMutableTreeNode treeNode1 = new javax.swing.tree.DefaultMutableTreeNode("Expedientes");
javax.swing.tree.DefaultMutableTreeNode treeNode2 = new javax.swing.tree.DefaultMutableTreeNode("Departamentos");
javax.swing.tree.DefaultMutableTreeNode treeNode3 = new javax.swing.tree.DefaultMutableTreeNode("Calidad");
javax.swing.tree.DefaultMutableTreeNode treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026443");
treeNode3.add(treeNode4);
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026444");
treeNode3.add(treeNode4);
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026445");
treeNode3.add(treeNode4);
treeNode2.add(treeNode3);
treeNode3 = new javax.swing.tree.DefaultMutableTreeNode("Sistemas");
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026446");
treeNode3.add(treeNode4);
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026447");
treeNode3.add(treeNode4);
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026448");
treeNode3.add(treeNode4);
treeNode2.add(treeNode3);
treeNode3 = new javax.swing.tree.DefaultMutableTreeNode("Administrativo");
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026449");
treeNode3.add(treeNode4);
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026450");
treeNode3.add(treeNode4);
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026451");
treeNode3.add(treeNode4);
treeNode2.add(treeNode3);
treeNode3 = new javax.swing.tree.DefaultMutableTreeNode("RH");
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026452");
treeNode3.add(treeNode4);
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026453");
treeNode3.add(treeNode4);
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("34026454");
treeNode3.add(treeNode4);
treeNode2.add(treeNode3);
treeNode1.add(treeNode2);
treeNode2 = new javax.swing.tree.DefaultMutableTreeNode("Externos");
treeNode3 = new javax.swing.tree.DefaultMutableTreeNode("Varios");
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("00000001");
treeNode3.add(treeNode4);
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("00000002");
treeNode3.add(treeNode4);
treeNode4 = new javax.swing.tree.DefaultMutableTreeNode("00000003");
treeNode3.add(treeNode4);
treeNode2.add(treeNode3);
treeNode1.add(treeNode2);
jTree.setModel(new javax.swing.tree.DefaultTreeModel(treeNode1));
jScrollPane2.setViewportView(jTree);
ListadoHeader1.setEditable(false);
ListadoHeader1.setBackground(new java.awt.Color(204, 204, 204));
ListadoHeader1.setFont(new java.awt.Font("Aharoni", 0, 12)); // NOI18N
ListadoHeader1.setForeground(new java.awt.Color(51, 51, 51));
ListadoHeader1.setHorizontalAlignment(javax.swing.JTextField.CENTER);
ListadoHeader1.setText("BUSCAR FOTO");
ListadoHeader1.setToolTipText("");
ListadoHeader1.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));
ListadoHeader1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ListadoHeader1ActionPerformed(evt);
}
});
loadPic.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
loadPic.setText("CARGAR FOTO");
loadPic.setPreferredSize(new java.awt.Dimension(80, 23));
loadPic.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
loadPicActionPerformed(evt);
}
});
photoContainer.setBackground(new java.awt.Color(204, 204, 204));
photoContainer.setBorder(javax.swing.BorderFactory.createEtchedBorder());
Kain.setIcon(new javax.swing.ImageIcon("C:\\Users\\Al Franco\\Desktop\\kain.jpg")); // NOI18N
Kain.setVerticalAlignment(javax.swing.SwingConstants.TOP);
javax.swing.GroupLayout photoContainerLayout = new javax.swing.GroupLayout(photoContainer);
photoContainer.setLayout(photoContainerLayout);
photoContainerLayout.setHorizontalGroup(
photoContainerLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(Kain, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
);
photoContainerLayout.setVerticalGroup(
photoContainerLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(Kain, javax.swing.GroupLayout.PREFERRED_SIZE, 263, Short.MAX_VALUE)
);
javax.swing.GroupLayout CalcPanelLayout = new javax.swing.GroupLayout(CalcPanel);
CalcPanel.setLayout(CalcPanelLayout);
CalcPanelLayout.setHorizontalGroup(
CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(CalcPanelLayout.createSequentialGroup()
.addContainerGap()
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, CalcPanelLayout.createSequentialGroup()
.addComponent(Header1, javax.swing.GroupLayout.PREFERRED_SIZE, 333, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(160, 160, 160)
.addComponent(SAGN1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(SAGN01))
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, CalcPanelLayout.createSequentialGroup()
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(CalcPanelLayout.createSequentialGroup()
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(FaultLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(SalaryLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(CalcPanelLayout.createSequentialGroup()
.addComponent(RetLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 74, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(0, 0, Short.MAX_VALUE))
.addComponent(NameLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(DepLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(CalcPanelLayout.createSequentialGroup()
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(Name, javax.swing.GroupLayout.DEFAULT_SIZE, 140, Short.MAX_VALUE)
.addComponent(Fault)
.addComponent(Retard, javax.swing.GroupLayout.DEFAULT_SIZE, 140, Short.MAX_VALUE)
.addComponent(Salary))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(CalcPanelLayout.createSequentialGroup()
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(SalarySlider, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
.addComponent(SalaryBar, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
.addComponent(DepComboBox, javax.swing.GroupLayout.Alignment.TRAILING, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(28, 28, 28))))
.addGroup(CalcPanelLayout.createSequentialGroup()
.addGap(10, 10, 10)
.addComponent(photoContainer, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(CalcPanelLayout.createSequentialGroup()
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(CalcPanelLayout.createSequentialGroup()
.addComponent(APaternoLabel)
.addGap(30, 30, 30)
.addComponent(APat, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(AMaterno))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, CalcPanelLayout.createSequentialGroup()
.addGap(0, 0, Short.MAX_VALUE)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(TotalFaultLabel)
.addComponent(EmpNoLabel)
.addComponent(GenderLabel)))
.addComponent(BonoPunt)
.addComponent(BonoProd)
.addComponent(BonoCap))
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(CalcPanelLayout.createSequentialGroup()
.addGap(34, 34, 34)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(AMat, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(EmpNo, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, CalcPanelLayout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, CalcPanelLayout.createSequentialGroup()
.addComponent(jRadioButtonM)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jRadioButtonF))
.addComponent(TotalFault, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)))))
.addGroup(CalcPanelLayout.createSequentialGroup()
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane2)
.addComponent(ListadoHeader1)
.addComponent(loadPic, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(ListadoHeader, javax.swing.GroupLayout.DEFAULT_SIZE, 300, Short.MAX_VALUE)
.addComponent(jScrollPane1))))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(Cotizar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(ClearCalc, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, CalcPanelLayout.createSequentialGroup()
.addComponent(Copyright1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(Copyright3)))
.addContainerGap())
.addComponent(jSeparator1)
);
CalcPanelLayout.setVerticalGroup(
CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(CalcPanelLayout.createSequentialGroup()
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(Header1, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(SAGN1, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(SAGN01, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(3, 3, 3)
.addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(CalcPanelLayout.createSequentialGroup()
.addGap(16, 16, 16)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(APaternoLabel)
.addComponent(APat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(AMat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(Name, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(AMaterno)
.addComponent(NameLabel))
.addGap(3, 3, 3)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(RetLabel)
.addComponent(Retard, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(EmpNoLabel)
.addComponent(EmpNo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(BonoPunt))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(FaultLabel)
.addComponent(Fault, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(BonoProd)
.addComponent(TotalFaultLabel)
.addComponent(TotalFault, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(SalaryLabel)
.addComponent(Salary, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jRadioButtonM)
.addComponent(jRadioButtonF)
.addComponent(GenderLabel)
.addComponent(BonoCap))
.addGap(0, 0, 0)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(CalcPanelLayout.createSequentialGroup()
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(ListadoHeader, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(ListadoHeader1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 341, Short.MAX_VALUE)
.addGroup(CalcPanelLayout.createSequentialGroup()
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(loadPic, javax.swing.GroupLayout.PREFERRED_SIZE, 55, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGroup(CalcPanelLayout.createSequentialGroup()
.addComponent(SalarySlider, javax.swing.GroupLayout.PREFERRED_SIZE, 14, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(0, 0, 0)
.addComponent(SalaryBar, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(3, 3, 3)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(DepComboBox, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(DepLabel))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(photoContainer, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(0, 39, Short.MAX_VALUE))))
.addGroup(CalcPanelLayout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(Cotizar, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(ClearCalc, javax.swing.GroupLayout.PREFERRED_SIZE, 55, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(CalcPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(Copyright1)
.addComponent(Copyright3)))
);
MainFrame.addTab("Calculador", CalcPanel);
ResPanel.setBackground(new java.awt.Color(204, 204, 204));
Name2.setEditable(false);
Name2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
Name2ActionPerformed(evt);
}
});
NameLabel2.setText("Nombre:");
DescFaultLabel.setText("Descuento por Inasistencias:");
DescFault.setEditable(false);
DescFault.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
DescFaultActionPerformed(evt);
}
});
Infonavit.setEditable(false);
Infonavit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
InfonavitActionPerformed(evt);
}
});
InfonavitLabel.setText("Infonavit:");
IMSSLabel.setText("IMSS:");
IMSS.setEditable(false);
IMSS.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
IMSSActionPerformed(evt);
}
});
ISR.setEditable(false);
ISR.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ISRActionPerformed(evt);
}
});
ISRLabel.setText("ISR:");
SubTotalLabel.setText("Subtotal:");
SubTotal.setEditable(false);
SubTotal.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
SubTotalActionPerformed(evt);
}
});
SalaryNetoLabel.setText("Salario Neto:");
SalaryNeto.setEditable(false);
SalaryNeto.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
SalaryNetoActionPerformed(evt);
}
});
TotalFaultLabel2.setText("Total de Inasistencias:");
TotalFault2.setEditable(false);
TotalFault2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
TotalFault2ActionPerformed(evt);
}
});
Header2.setFont(new java.awt.Font("Bauhaus 93", 2, 24)); // NOI18N
Header2.setForeground(new java.awt.Color(51, 51, 51));
Header2.setText("C.I.A. LA CORONA S.A. de C.V.");
SAGN2.setFont(new java.awt.Font("Bauhaus 93", 2, 18)); // NOI18N
SAGN2.setForeground(new java.awt.Color(51, 51, 51));
SAGN2.setText("S.A.G.N.");
SAGN02.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N
SAGN02.setForeground(new java.awt.Color(51, 51, 51));
SAGN02.setText("Sistema automatizado de gestión de nomina.");
Copyright2.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N
Copyright2.setForeground(new java.awt.Color(51, 51, 51));
Copyright2.setText("Developed by Ing. Al Franco - 2013 copyright (c).");
Copyright4.setFont(new java.awt.Font("Berlin Sans FB Demi", 0, 12)); // NOI18N
Copyright4.setForeground(new java.awt.Color(51, 51, 51));
Copyright4.setText("Ver. a0.24.04.13");
EmpNo2.setEditable(false);
EmpNo2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
EmpNo2ActionPerformed(evt);
}
});
EmpNoLabel2.setText("Numero de Empleado:");
GenderLabel2.setText("Sexo:");
Gender1.setEditable(false);
Gender1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
Gender1ActionPerformed(evt);
}
});
DescFaultLabel1.setText("Departamento:");
Departamento.setEditable(false);
Departamento.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
DepartamentoActionPerformed(evt);
}
});
ClearRes.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
ClearRes.setText("BORRAR");
ClearRes.setPreferredSize(new java.awt.Dimension(80, 23));
ClearRes.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ClearResActionPerformed(evt);
}
});
EmpTable.setBackground(new java.awt.Color(204, 204, 204));
EmpTable.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
EmpTable.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Emp. No.", "Nombre", "Sexo", "Departamento"
}
) {
boolean[] canEdit = new boolean [] {
false, false, false, false
};
public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
EmpTable.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
jScrollPane3.setViewportView(EmpTable);
HeaderEmpTable.setEditable(false);
HeaderEmpTable.setBackground(new java.awt.Color(204, 204, 204));
HeaderEmpTable.setFont(new java.awt.Font("Aharoni", 0, 12)); // NOI18N
HeaderEmpTable.setForeground(new java.awt.Color(51, 51, 51));
HeaderEmpTable.setHorizontalAlignment(javax.swing.JTextField.CENTER);
HeaderEmpTable.setText("REGISTRO DE EMPLEADOS");
HeaderEmpTable.setToolTipText("");
HeaderEmpTable.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));
HeaderEmpTable.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
HeaderEmpTableActionPerformed(evt);
}
});
HeaderNominaTable.setEditable(false);
HeaderNominaTable.setBackground(new java.awt.Color(204, 204, 204));
HeaderNominaTable.setFont(new java.awt.Font("Aharoni", 0, 12)); // NOI18N
HeaderNominaTable.setForeground(new java.awt.Color(51, 51, 51));
HeaderNominaTable.setHorizontalAlignment(javax.swing.JTextField.CENTER);
HeaderNominaTable.setText("REGISTRO DE NOMINAS");
HeaderNominaTable.setToolTipText("");
HeaderNominaTable.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));
HeaderNominaTable.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
HeaderNominaTableActionPerformed(evt);
}
});
ClrEmpTable.setText("Borrar");
ClrEmpTable.setPreferredSize(new java.awt.Dimension(80, 23));
ClrEmpTable.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ClrEmpTableActionPerformed(evt);
}
});
InsEmpTable.setText("Insertar");
InsEmpTable.setPreferredSize(new java.awt.Dimension(80, 23));
InsEmpTable.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
InsEmpTableActionPerformed(evt);
}
});
UpdEmpTable.setText("Modificar");
UpdEmpTable.setPreferredSize(new java.awt.Dimension(80, 23));
UpdEmpTable.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
UpdEmpTableActionPerformed(evt);
}
});
QryEmpTable.setText("Consulta");
QryEmpTable.setPreferredSize(new java.awt.Dimension(80, 23));
QryEmpTable.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
QryEmpTableActionPerformed(evt);
}
});
ClrNomTable.setText("Borrar");
ClrNomTable.setPreferredSize(new java.awt.Dimension(80, 23));
ClrNomTable.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ClrNomTableActionPerformed(evt);
}
});
InsNomTable.setText("Insertar");
InsNomTable.setPreferredSize(new java.awt.Dimension(80, 23));
InsNomTable.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
InsNomTableActionPerformed(evt);
}
});
UpdNomTable.setText("Modificar");
UpdNomTable.setPreferredSize(new java.awt.Dimension(80, 23));
UpdNomTable.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
UpdNomTableActionPerformed(evt);
}
});
QryNomTable.setText("Consulta");
QryNomTable.setPreferredSize(new java.awt.Dimension(80, 23));
QryNomTable.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
QryNomTableActionPerformed(evt);
}
});
$a.setEditable(false);
$a.setBackground(new java.awt.Color(204, 204, 204));
$a.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
$a.setText("$");
$a.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
$aActionPerformed(evt);
}
});
$b.setEditable(false);
$b.setBackground(new java.awt.Color(204, 204, 204));
$b.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
$b.setText("$");
$b.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
$bActionPerformed(evt);
}
});
$c.setEditable(false);
$c.setBackground(new java.awt.Color(204, 204, 204));
$c.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
$c.setText("$");
$d.setEditable(false);
$d.setBackground(new java.awt.Color(204, 204, 204));
$d.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
$d.setText("$");
$e.setEditable(false);
$e.setBackground(new java.awt.Color(204, 204, 204));
$e.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
$e.setText("$");
f.setEditable(false);
f.setBackground(new java.awt.Color(204, 204, 204));
f.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
f.setText("$");
NomTable.setBackground(new java.awt.Color(204, 204, 204));
NomTable.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
NomTable.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null, null, null, null, null},
{null, null, null, null, null, null, null, null},
{null, null, null, null, null, null, null, null},
{null, null, null, null, null, null, null, null}
},
new String [] {
"Emp. No.", "Faltas totales", "Descuento Faltas", "INFONAVIT", "IMSS", "ISR", "Sub Total", "Salario Neto"
}
) {
boolean[] canEdit = new boolean [] {
false, false, false, false, false, false, false, false
};
public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
NomTable.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
jScrollPane4.setViewportView(NomTable);
javax.swing.GroupLayout ResPanelLayout = new javax.swing.GroupLayout(ResPanel);
ResPanel.setLayout(ResPanelLayout);
ResPanelLayout.setHorizontalGroup(
ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jSeparator2)
.addGroup(ResPanelLayout.createSequentialGroup()
.addContainerGap()
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(ResPanelLayout.createSequentialGroup()
.addComponent(jScrollPane3)
.addContainerGap())
.addGroup(ResPanelLayout.createSequentialGroup()
.addComponent(Copyright2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(Copyright4)
.addGap(7, 7, 7))
.addGroup(ResPanelLayout.createSequentialGroup()
.addComponent(Header2, javax.swing.GroupLayout.PREFERRED_SIZE, 333, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(160, 160, 160)
.addComponent(SAGN2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(SAGN02)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(ResPanelLayout.createSequentialGroup()
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(ResPanelLayout.createSequentialGroup()
.addComponent(HeaderNominaTable, javax.swing.GroupLayout.PREFERRED_SIZE, 506, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(ClrNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, 64, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(InsNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, 72, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(UpdNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(QryNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(ResPanelLayout.createSequentialGroup()
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(NameLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 169, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(ResPanelLayout.createSequentialGroup()
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(ISRLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(DescFaultLabel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(DescFaultLabel1, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(InfonavitLabel, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(IMSSLabel, javax.swing.GroupLayout.Alignment.LEADING))
.addGap(18, 18, 18)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(Departamento)
.addComponent(Name2, javax.swing.GroupLayout.PREFERRED_SIZE, 260, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(ResPanelLayout.createSequentialGroup()
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent($a, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent($b, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent($c, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent($d, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(ISR)
.addComponent(DescFault, javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(Infonavit, javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(IMSS, javax.swing.GroupLayout.Alignment.TRAILING))))))
.addGap(18, 18, 18)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(ResPanelLayout.createSequentialGroup()
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(GenderLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(TotalFaultLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(EmpNoLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(Gender1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 235, Short.MAX_VALUE)
.addComponent(TotalFault2, javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(EmpNo2)))
.addGroup(ResPanelLayout.createSequentialGroup()
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(SalaryNetoLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(SubTotalLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(ClearRes, javax.swing.GroupLayout.PREFERRED_SIZE, 235, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, ResPanelLayout.createSequentialGroup()
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent($e, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(f, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(SalaryNeto)
.addComponent(SubTotal)))))))
.addGroup(ResPanelLayout.createSequentialGroup()
.addComponent(HeaderEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, 506, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(ClrEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, 64, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(InsEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, 72, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(UpdEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(QryEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(0, 0, Short.MAX_VALUE))
.addComponent(jScrollPane4)))
);
ResPanelLayout.setVerticalGroup(
ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(ResPanelLayout.createSequentialGroup()
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(Header2, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(SAGN2, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(SAGN02, javax.swing.GroupLayout.PREFERRED_SIZE, 32, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(3, 3, 3)
.addComponent(jSeparator2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(16, 16, 16)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(ResPanelLayout.createSequentialGroup()
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(Name2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(NameLabel2))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(Departamento, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(DescFaultLabel1))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(DescFaultLabel)
.addComponent(DescFault, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent($a, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(InfonavitLabel)
.addComponent(Infonavit, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent($b, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(IMSSLabel)
.addComponent(IMSS, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent($c, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(ISRLabel)
.addComponent(ISR, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(ClearRes, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent($d, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(ResPanelLayout.createSequentialGroup()
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(EmpNo2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(EmpNoLabel2))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(GenderLabel2)
.addComponent(Gender1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(TotalFault2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(TotalFaultLabel2))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(SubTotal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(SubTotalLabel)
.addComponent($e, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(SalaryNeto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(SalaryNetoLabel)
.addComponent(f, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGap(7, 7, 7)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(HeaderEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(ClrEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(InsEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(UpdEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(QryEmpTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 141, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(HeaderNominaTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(ClrNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(InsNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(UpdNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(QryNomTable, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(ResPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(Copyright2)
.addComponent(Copyright4)))
);
MainFrame.addTab("Resultados", ResPanel);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(MainFrame, javax.swing.GroupLayout.PREFERRED_SIZE, 845, javax.swing.GroupLayout.PREFERRED_SIZE)
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(MainFrame, javax.swing.GroupLayout.PREFERRED_SIZE, 573, javax.swing.GroupLayout.PREFERRED_SIZE)
);
pack();
}// </editor-fold>
private void TotalFault2ActionPerformed(java.awt.event.ActionEvent evt) {
}
private void SalaryNetoActionPerformed(java.awt.event.ActionEvent evt) {
}
private void SubTotalActionPerformed(java.awt.event.ActionEvent evt) {
}
private void ISRActionPerformed(java.awt.event.ActionEvent evt) {
}
private void IMSSActionPerformed(java.awt.event.ActionEvent evt) {
}
private void InfonavitActionPerformed(java.awt.event.ActionEvent evt) {
}
private void DescFaultActionPerformed(java.awt.event.ActionEvent evt) {
}
private void Name2ActionPerformed(java.awt.event.ActionEvent evt) {
}
private void EmpNo2ActionPerformed(java.awt.event.ActionEvent evt) {
}
private void Gender1ActionPerformed(java.awt.event.ActionEvent evt) {
}
private void jRadioButtonFActionPerformed(java.awt.event.ActionEvent evt) {
}
private void EmpNoActionPerformed(java.awt.event.ActionEvent evt) {
}
private void AMatActionPerformed(java.awt.event.ActionEvent evt) {
}
private void APatActionPerformed(java.awt.event.ActionEvent evt) {
}
private void CotizarKeyPressed(java.awt.event.KeyEvent evt) {
}
private void CotizarActionPerformed(java.awt.event.ActionEvent evt) {
/*---------------------------------------------------------------------//
// Aqui se captura el nombre del empleado en tres campos separados //
// Nombre, Apellido Paterno y Apellido Materno, para depositarlos en //
// un solo contenedor en la pestaña resultados. //
//---------------------------------------------------------------------*/
Name.getText();
Nom=Name.getText();
APat.getText();
ApPat=APat.getText();
AMat.getText();
ApMat=AMat.getText();
Name2.setText(""+Nom+" "+ApPat+" "+ApMat);
/*---------------------------------------------------------------------//
// Aqui se captura el numero de empleado en el calculador para despues //
// depositarlo dentro del contenedor de la pestaña Resultados. //
//---------------------------------------------------------------------*/
EmpNo.getText();
empnum=Integer.parseInt(EmpNo.getText());
EmpNo2.setText(""+empnum);
/*---------------------------------------------------------------------//
// Aqui se captura el numero de retardos en el calculador para despues //
// depositarlo dentro del contenedor de la pestaña Resultados. //
//---------------------------------------------------------------------*/
Retard.getText();
retardos=Integer.parseInt(Retard.getText());
/*---------------------------------------------------------------------//
// Aqui se captura el numero de faltas en el calculador para despues //
// depositarlo dentro del contenedor de la pestaña Resultados. //
//---------------------------------------------------------------------*/
Fault.getText();
inasistencias=Integer.parseInt(Fault.getText());
/*---------------------------------------------------------------------//
// Aqui se captura el salario en el calculador para despues //
// depositarlo dentro del contenedor de la pestaña Resultados. //
//---------------------------------------------------------------------*/
Salary.getText();
salario=Integer.parseInt(Salary.getText());
/*---------------------------------------------------------------------//
// Aqui se selecciona el genero en el calculador para despues //
// depositarlo dentro del contenedor de la pestaña Resultados. //
//---------------------------------------------------------------------*/
String Genero = null;
if (jRadioButtonM.isSelected()) {
Genero="Masculino";}
else if (jRadioButtonF.isSelected()) {
Genero="Femenino";}
Gender1.setText(Genero);
/*---------------------------------------------------------------------//
// Aqui se selecciona el departamento en el calculador para despues //
// depositarlo dentro del contenedor de la pestaña Resultados. //
//---------------------------------------------------------------------*/
Integer DeptIndex = DepComboBox.getSelectedIndex();
String Dept = null;
if (DeptIndex.equals(1)){
Dept="Calidad";}
else if (DeptIndex.equals(2)){
Dept="Sistemas";}
else if (DeptIndex.equals(3)){
Dept="Administrativo";}
else if (DeptIndex.equals(4)){
Dept="Recursos Humanos";}
else if (DeptIndex.equals(0)){
Dept="No Especificado";}
Departamento.setText(Dept);
/*---------------------------------------------------------------------//
// Aqui se realiza el calculo de bonos en el calculador para despues //
// depositarlo dentro del contenedor de la pestaña Resultados. //
//---------------------------------------------------------------------*/
//Calculo de bonos PUNTUALIDAD
//Bono puntualidad Dept. Calidad
double timeBonus = 0;
if (BonoPunt.isSelected()==true && DeptIndex.equals(1)){
timeBonus = 600;}
//bono puntualidad Dept. Sistemas
else if (BonoPunt.isSelected()==true && DeptIndex.equals(2)){
timeBonus = 400;}
//bono puntualidad Dept. Administrativo
else if (BonoPunt.isSelected()==true && DeptIndex.equals(3)){
timeBonus = 1000;}
//bono puntualidad Dept. RH
else if (BonoPunt.isSelected()==true && DeptIndex.equals(4)){
timeBonus = 550;}
else {timeBonus = 0;}
//Calculo de bonos PRODUCTIVIDAD
double prodBonus = 0;
//Bono productividad Dept. Calidad
if (BonoProd.isSelected()==true && DeptIndex.equals(1)){
prodBonus = 1000;}
//bono productividad Dept. Sistemas
else if (BonoProd.isSelected()==true && DeptIndex.equals(2)){
prodBonus = 1500;}
//bono productividad Dept. Administrativo
else if (BonoProd.isSelected()==true && DeptIndex.equals(3)){
prodBonus = 2500;}
//bono productividad Dept. RH
else if (BonoProd.isSelected()==true && DeptIndex.equals(4)){
prodBonus = 2000;}
else {prodBonus = 0;}
//Calculo de bonos CERTIFICACION
double capBonus = 0;
//Bono productividad Dept. Calidad
if (BonoCap.isSelected()==true && DeptIndex.equals(1)){
capBonus = 2500;}
//bono productividad Dept. Sistemas
else if (BonoCap.isSelected()==true && DeptIndex.equals(2)){
capBonus = 3500;}
//bono productividad Dept. Administrativo
else if (BonoCap.isSelected()==true && DeptIndex.equals(3)){
capBonus = 5000;}
//bono productividad Dept. RH
else if (BonoCap.isSelected()==true && DeptIndex.equals(4)){
capBonus = 3000;}
else {capBonus = 0;}
/*---------------------------------------------------------------------//
// Aqui se realiza el calculo de los datos ingresados en el calculador//
// para despues depositarlo dentro del contenedor de la pestaña //
// Resultados. //
//---------------------------------------------------------------------*/
DecimalFormat monetary = new DecimalFormat("#####0.00"); //"$"+
faltas=retardos/3;
inasistencias=inasistencias+faltas;
sd=salario/15;
dt=15-inasistencias;
sueldo=sd*dt;
infon=salario*.05;
imss=salario*.03;
isr=(infon+imss)*.3;
pago=subt+isr;
tot=salario-sueldo;
subt=infon+imss+tot+isr;
neto=salario-subt;
TotalFault.setText(""+inasistencias);
TotalFault2.setText(""+inasistencias);
Infonavit.setText(monetary.format(infon));
IMSS.setText(monetary.format(imss));
SubTotal.setText(monetary.format(neto));
ISR.setText(monetary.format(isr));
SalaryNeto.setText(monetary.format(neto+capBonus+prodBonus+timeBonus));
//int intSalario = (int) salario; //Se utilizara en siguientes versiones para hacer un progressbar que funcione como slider
int intNeto = (int) neto;
salaryProgress= intNeto;
SalaryBar.setValue(salaryProgress);
DescFault.setText(monetary.format(tot));
}
private void TotalFaultActionPerformed(java.awt.event.ActionEvent evt) {
}
private void SalaryActionPerformed(java.awt.event.ActionEvent evt) {
Salary.getText();
salario=Integer.parseInt(Salary.getText());
}
private void FaultActionPerformed(java.awt.event.ActionEvent evt) {
Fault.getText();
inasistencias=Integer.parseInt(Fault.getText());
}
private void RetardActionPerformed(java.awt.event.ActionEvent evt) {
Retard.getText();
retardos=Integer.parseInt(Retard.getText());
}
private void NameActionPerformed(java.awt.event.ActionEvent evt) {
}
private void DepComboBoxActionPerformed(java.awt.event.ActionEvent evt) {
}
private void DepartamentoActionPerformed(java.awt.event.ActionEvent evt) {
}
private void BonoPuntActionPerformed(java.awt.event.ActionEvent evt) {
}
private void BonoCapActionPerformed(java.awt.event.ActionEvent evt) {
}
private void ClearCalcActionPerformed(java.awt.event.ActionEvent evt) {
Name.setText("");
APat.setText("");
AMat.setText("");
Retard.setText("");
EmpNo.setText("");
Fault.setText("");
TotalFault.setText("");
Salary.setText("");
SalaryBar.setValue(0);
DepComboBox.setSelectedIndex(0);
Gender.clearSelection();
BonoPunt.setSelected(false);
BonoProd.setSelected(false);
BonoCap.setSelected(false);
}
private void ClearResActionPerformed(java.awt.event.ActionEvent evt) {
Name2.setText("");
Departamento.setText("");
DescFault.setText("");
Infonavit.setText("");
IMSS.setText("");
ISR.setText("");
EmpNo2.setText("");
Gender1.setText("");
TotalFault2.setText("");
SubTotal.setText("");
SalaryNeto.setText("");
}
private void ListadoHeader1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void loadPicActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void SalarySliderStateChanged(javax.swing.event.ChangeEvent evt) {
Salary.setText (String.valueOf(SalarySlider.getValue()));
int SalSlide=Integer.parseInt(Salary.getText());
SalaryBar.setValue(SalSlide);
}
private void HeaderEmpTableActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void HeaderNominaTableActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void ClrEmpTableActionPerformed(java.awt.event.ActionEvent evt) {
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// eliminar desde la base de datos
int emp=Integer.parseInt(EmpNo.getText());
instruccion.executeUpdate("delete from datos_emp where dIEmpNo='"+emp+"'");
JOptionPane.showMessageDialog(null," Registro Eliminado");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error al Borrar el Registro",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void InsEmpTableActionPerformed(java.awt.event.ActionEvent evt) {
String dCempName=Name2.getText();
String dIEmpNo=EmpNo2.getText();
String dCSexo=Gender1.getText();
String dCempDep=Departamento.getText();
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
instruccion.executeUpdate
("insert into datos_emp values('"+dCempName+"','"+dIEmpNo+"','"+dCSexo+"','"+dCempDep+"')");
JOptionPane.showMessageDialog(null,"Creacion del Registro Correctamente");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"no se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
}
private void UpdEmpTableActionPerformed(java.awt.event.ActionEvent evt) {
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
int a=Integer.parseInt(EmpNo2.getText());
try{
instruccion.executeUpdate(" update datos_emp "
+ "set dCempName='"+Name2.getText()+"',"
+ " dCSexo='"+Gender1.getText()+"'"
+ " dCempDep='"+Gender1.getText()+"'"
+ "where dIEmpNo='"+a+"'");
JOptionPane.showMessageDialog(null,"Registro Modificado");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"No existe Registro",JOptionPane.ERROR_MESSAGE);
}
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error al modificar datos",JOptionPane.ERROR_MESSAGE);
}
catch(ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void QryEmpTableActionPerformed(java.awt.event.ActionEvent evt) {
modelo = new DefaultTableModel();
// Creamos las columnas.
modelo.addColumn("Nombre");
modelo.addColumn("Emp. No.");
modelo.addColumn("Sexo");
modelo.addColumn("Departamento");
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
ResultSet result=instruccion.executeQuery("select * FROM datos_emp ORDER BY dIEmpNo");
while(result.next()){
//son 4 columnas, la dimesion del objeto datos de 4
Object[] datos = new Object[4];
for (int i = 0; i < 4; i++) {
datos[i] = result.getObject(i+1);
}
modelo.addRow(datos);
}
EmpTable.setModel(modelo);
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error en la base de datos",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador ",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void ClrNomTableActionPerformed(java.awt.event.ActionEvent evt) {
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// eliminar desde la base de datos
int emp=Integer.parseInt(EmpNo.getText());
instruccion.executeUpdate("delete from nomina where nomIempNo='"+emp+"'");
JOptionPane.showMessageDialog(null,"Registro Eliminado");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error al Borrar el Registro",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void InsNomTableActionPerformed(java.awt.event.ActionEvent evt) {
String nomIempNo=EmpNo2.getText();
String nomItotal_faltas=TotalFault2.getText();
String nomIdesc_faltas=DescFault.getText();
String nomIinfonavit=Infonavit.getText();
String nomIimss=IMSS.getText();
String nomICISR=ISR.getText();
String nomISubTotal=SubTotal.getText();
String nomISalario_Neto=SalaryNeto.getText();
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
instruccion.executeUpdate
("insert into nomina values"
+"('"+nomIempNo+"','"+nomItotal_faltas+"','"+nomIdesc_faltas+"','"+nomIinfonavit+"','"
+nomIimss+"','"+nomICISR+"','"+nomISubTotal+"','"+nomISalario_Neto+"')");
JOptionPane.showMessageDialog(null,"Creacion del Registro Correctamente");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
}
private void UpdNomTableActionPerformed(java.awt.event.ActionEvent evt) {
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
int a=Integer.parseInt(EmpNo2.getText());
try{
instruccion.executeUpdate(" update nomina "
+ "set nomItotal_faltas='"+TotalFault2.getText()+"',"
+ " nomIdesc_faltas='"+DescFault.getText()+"'"
+ " nomIinfonavit='"+Infonavit.getText()+"'"
+ " nomIimss='"+IMSS.getText()+"'"
+ " nomICISR='"+ISR.getText()+"'"
+ " nomISubTotal='"+SubTotal.getText()+"'"
+ " nomISalario_Neto='"+SalaryNeto.getText()+"'"
+ "where dIEmpNo='"+a+"'");
JOptionPane.showMessageDialog(null,"Registro Modificado");
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"No existe Registro",JOptionPane.ERROR_MESSAGE);
}
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error al modificar datos",JOptionPane.ERROR_MESSAGE);
}
catch(ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
// JOptionPane.showMessageDialog( null,"cerro correctamente la base de datos");
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void QryNomTableActionPerformed(java.awt.event.ActionEvent evt) {
modelo = new DefaultTableModel();
// Creamos las columnas.
modelo.addColumn("Emp. No.");
modelo.addColumn("Faltas totales");
modelo.addColumn("Descuento Faltas");
modelo.addColumn("INFONAVIT");
modelo.addColumn("IMSS");
modelo.addColumn("ISR");
modelo.addColumn("Sub Total");
modelo.addColumn("Salario Neto");
try{
Class.forName("com.mysql.jdbc.Driver");// coneccion a la base de datos
coneccion=DriverManager.getConnection("jdbc:mysql://localhost:3306/sagn","root","");
// establecer conexion ala base de datos
instruccion = coneccion.createStatement();// consultar a la base de datos
// consultar a la base de datos
ResultSet result=instruccion.executeQuery("select * FROM nomina ORDER BY nomIempNo");
while(result.next()){
//son 8 columnas, la dimesion del objeto datos de 8
Object[] datos = new Object[8];
for (int i = 0; i < 8; i++) {
datos[i] = result.getObject(i+1);
}
modelo.addRow(datos);
}
NomTable.setModel(modelo);
}
catch(SQLException exeptionsql){
JOptionPane.showMessageDialog(null,exeptionsql.getMessage(),
"Error en la base de datos",JOptionPane.ERROR_MESSAGE);
}
catch( ClassNotFoundException clasenoencontrada){
JOptionPane.showMessageDialog(null,clasenoencontrada.getMessage(),
"No se encontro el controlador ",JOptionPane.ERROR_MESSAGE);
System.exit(1);
}
finally {
try {
coneccion.close();
instruccion.close();
}
// handle exceptions closing statement and connection
catch ( SQLException sqlException ) {
JOptionPane.showMessageDialog( null,
sqlException.getMessage(), "No cerro correctamente la base de datos",
JOptionPane.ERROR_MESSAGE );
System.exit( 1 );
}
}
}
private void $aActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void $bActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new nominas().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JTextField $a;
private javax.swing.JTextField $b;
private javax.swing.JTextField $c;
private javax.swing.JTextField $d;
private javax.swing.JTextField $e;
private javax.swing.JTextField AMat;
private javax.swing.JLabel AMaterno;
private javax.swing.JTextField APat;
private javax.swing.JLabel APaternoLabel;
private javax.swing.JCheckBox BonoCap;
private javax.swing.JCheckBox BonoProd;
private javax.swing.JCheckBox BonoPunt;
private javax.swing.JPanel CalcPanel;
private javax.swing.JButton ClearCalc;
private javax.swing.JButton ClearRes;
private javax.swing.JButton ClrEmpTable;
private javax.swing.JButton ClrNomTable;
private javax.swing.JLabel Copyright1;
private javax.swing.JLabel Copyright2;
private javax.swing.JLabel Copyright3;
private javax.swing.JLabel Copyright4;
private javax.swing.JButton Cotizar;
private javax.swing.JComboBox DepComboBox;
private javax.swing.JLabel DepLabel;
private javax.swing.JTextField Departamento;
private javax.swing.JTextField DescFault;
private javax.swing.JLabel DescFaultLabel;
private javax.swing.JLabel DescFaultLabel1;
private javax.swing.JTextField EmpNo;
private javax.swing.JTextField EmpNo2;
private javax.swing.JLabel EmpNoLabel;
private javax.swing.JLabel EmpNoLabel2;
private javax.swing.JTable EmpTable;
private javax.swing.JTextField Fault;
private javax.swing.JLabel FaultLabel;
private javax.swing.ButtonGroup Gender;
private javax.swing.JTextField Gender1;
private javax.swing.JLabel GenderLabel;
private javax.swing.JLabel GenderLabel2;
private javax.swing.JLabel Header1;
private javax.swing.JLabel Header2;
private javax.swing.JTextField HeaderEmpTable;
private javax.swing.JTextField HeaderNominaTable;
private javax.swing.JTextField IMSS;
private javax.swing.JLabel IMSSLabel;
private javax.swing.JTextField ISR;
private javax.swing.JLabel ISRLabel;
private javax.swing.JTextField Infonavit;
private javax.swing.JLabel InfonavitLabel;
private javax.swing.JButton InsEmpTable;
private javax.swing.JButton InsNomTable;
private javax.swing.JLabel Kain;
private javax.swing.JTextArea Listado;
private javax.swing.JTextField ListadoHeader;
private javax.swing.JTextField ListadoHeader1;
private javax.swing.JTabbedPane MainFrame;
private javax.swing.JTextField Name;
private javax.swing.JTextField Name2;
private javax.swing.JLabel NameLabel;
private javax.swing.JLabel NameLabel2;
private javax.swing.JTable NomTable;
private javax.swing.JButton QryEmpTable;
private javax.swing.JButton QryNomTable;
private javax.swing.JPanel ResPanel;
private javax.swing.JLabel RetLabel;
private javax.swing.JTextField Retard;
private javax.swing.JLabel SAGN01;
private javax.swing.JLabel SAGN02;
private javax.swing.JLabel SAGN1;
private javax.swing.JLabel SAGN2;
private javax.swing.JTextField Salary;
private javax.swing.JProgressBar SalaryBar;
private javax.swing.JLabel SalaryLabel;
private javax.swing.JTextField SalaryNeto;
private javax.swing.JLabel SalaryNetoLabel;
private javax.swing.JSlider SalarySlider;
private javax.swing.JTextField SubTotal;
private javax.swing.JLabel SubTotalLabel;
private javax.swing.JTextField TotalFault;
private javax.swing.JTextField TotalFault2;
private javax.swing.JLabel TotalFaultLabel;
private javax.swing.JLabel TotalFaultLabel2;
private javax.swing.JButton UpdEmpTable;
private javax.swing.JButton UpdNomTable;
private javax.swing.JTextField f;
private javax.swing.JMenuItem jMenuItem1;
private javax.swing.JPanel jPanel1;
private javax.swing.JRadioButton jRadioButtonF;
private javax.swing.JRadioButton jRadioButtonM;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JScrollPane jScrollPane3;
private javax.swing.JScrollPane jScrollPane4;
private javax.swing.JSeparator jSeparator1;
private javax.swing.JSeparator jSeparator2;
private javax.swing.JTree jTree;
private javax.swing.JButton loadPic;
private javax.swing.JPanel photoContainer;
// End of variables declaration
}