Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package Presentacion; import Datos.vhabitacion; import Datos.vreserva; import Logica.fhabitacion; import Logica.freserva; import Utils.Utils; import java.sql.Date; import java.util.Calendar; import java.util.List; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import org.joda.time.DateTime; import org.joda.time.Days; /** * * @author CARLOS */ public class frmreserva extends javax.swing.JInternalFrame { /** * Creates new form frmreserva */ public frmreserva() { initComponents(); mostrar(""); inhabilitar(); } private String acao = ""; public static int idusuario; public static String valorAlguel; void ocultar_columnas() { tablalistado.getColumnModel().getColumn(0).setMaxWidth(0); tablalistado.getColumnModel().getColumn(0).setMinWidth(0); tablalistado.getColumnModel().getColumn(0).setPreferredWidth(0); tablalistado.getColumnModel().getColumn(1).setMaxWidth(0); tablalistado.getColumnModel().getColumn(1).setMinWidth(0); tablalistado.getColumnModel().getColumn(1).setPreferredWidth(0); tablalistado.getColumnModel().getColumn(3).setMaxWidth(0); tablalistado.getColumnModel().getColumn(3).setMinWidth(0); tablalistado.getColumnModel().getColumn(3).setPreferredWidth(0); tablalistado.getColumnModel().getColumn(5).setMaxWidth(0); tablalistado.getColumnModel().getColumn(5).setMinWidth(0); tablalistado.getColumnModel().getColumn(5).setPreferredWidth(0); } void inhabilitar() { txtidreserva.setVisible(false); txtidhabitacion.setVisible(false); txtidcliente.setVisible(false); txtidtrabajador.setVisible(false); txtnumero.setEnabled(false); txtcliente.setEnabled(false); txttrabajador.setEnabled(false); cbotipo_reserva.setEnabled(false); dcfecha_reserva.setEnabled(false); dcfecha_ingresa.setEnabled(false); dcfecha_salida.setEnabled(false); txtcosto_alojamiento.setEnabled(false); cbotipo_reserva.setEnabled(false); btnguardar.setEnabled(false); btncancelar.setEnabled(false); btneliminar.setEnabled(false); btnbuscacliente.setEnabled(false); btnbuscahabitacion.setEnabled(false); txtidreserva.setText(""); txtidcliente.setText(""); txtnumero.setText(""); txtcliente.setText(""); txtcosto_alojamiento.setText(""); txtidhabitacion.setText(""); } void habilitar() { txtidreserva.setVisible(false); txtidhabitacion.setVisible(false); txtidcliente.setVisible(false); txtidtrabajador.setVisible(false); txtnumero.setEnabled(false); txtcliente.setEnabled(false); txttrabajador.setEnabled(false); cbotipo_reserva.setEnabled(true); dcfecha_reserva.setEnabled(true); dcfecha_ingresa.setEnabled(true); dcfecha_salida.setEnabled(true); txtcosto_alojamiento.setEnabled(true); cbotipo_reserva.setEnabled(true); btnguardar.setEnabled(true); btncancelar.setEnabled(true); btneliminar.setEnabled(true); btnbuscacliente.setEnabled(true); btnbuscahabitacion.setEnabled(true); txtidreserva.setText(""); txtidcliente.setText(""); txtnumero.setText(""); txtcliente.setText(""); txtcosto_alojamiento.setText(""); txtidhabitacion.setText(""); } void mostrar(String buscar) { try { DefaultTableModel modelo; freserva func = new freserva(); modelo = func.mostrar(buscar); tablalistado.setModel(modelo); ocultar_columnas(); lbltotalregistros.setText("Total Registros " + Integer.toString(func.totalregistros)); } catch (Exception e) { JOptionPane.showConfirmDialog(rootPane, e); } } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents private void initComponents() { jLabel1 = new javax.swing.JLabel(); jPanel1 = new javax.swing.JPanel(); txtidreserva = new javax.swing.JTextField(); jLabel2 = new javax.swing.JLabel(); txtidhabitacion = new javax.swing.JTextField(); jLabel4 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); txtcosto_alojamiento = new javax.swing.JTextField(); jLabel7 = new javax.swing.JLabel(); cbotipo_reserva = new javax.swing.JComboBox(); btnnuevo = new javax.swing.JButton(); btnguardar = new javax.swing.JButton(); btncancelar = new javax.swing.JButton(); txtnumero = new javax.swing.JTextField(); txtidcliente = new javax.swing.JTextField(); txtcliente = new javax.swing.JTextField(); jLabel5 = new javax.swing.JLabel(); txtidtrabajador = new javax.swing.JTextField(); txttrabajador = new javax.swing.JTextField(); jLabel3 = new javax.swing.JLabel(); dcfecha_reserva = new com.toedter.calendar.JDateChooser(); jLabel8 = new javax.swing.JLabel(); dcfecha_ingresa = new com.toedter.calendar.JDateChooser(); jLabel10 = new javax.swing.JLabel(); dcfecha_salida = new com.toedter.calendar.JDateChooser(); jLabel11 = new javax.swing.JLabel(); cboestado = new javax.swing.JComboBox(); btnbuscahabitacion = new javax.swing.JButton(); btnbuscacliente = new javax.swing.JButton(); jPanel2 = new javax.swing.JPanel(); jScrollPane3 = new javax.swing.JScrollPane(); tablalistado = new javax.swing.JTable(); jLabel9 = new javax.swing.JLabel(); txtbuscar = new javax.swing.JTextField(); btnbuscar = new javax.swing.JButton(); btneliminar = new javax.swing.JButton(); btnsalir = new javax.swing.JButton(); lbltotalregistros = new javax.swing.JLabel(); btnverconsumo = new javax.swing.JButton(); btnrealizarpagos = new javax.swing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE); jLabel1.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N jLabel1.setText("Reserva"); jPanel1.setBackground(new java.awt.Color(255, 204, 102)); jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Registro de Reservas")); jLabel2.setText("Quarto:"); txtidhabitacion.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { txtidhabitacionActionPerformed(evt); } }); jLabel4.setText("Cliente:"); jLabel6.setText("Valor:"); txtcosto_alojamiento.addFocusListener(new java.awt.event.FocusAdapter() { public void focusGained(java.awt.event.FocusEvent evt) { txtcosto_alojamientoFocusGained(evt); } }); txtcosto_alojamiento.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { txtcosto_alojamientoActionPerformed(evt); } }); jLabel7.setText("Tipo Reserva:"); cbotipo_reserva.setModel( new javax.swing.DefaultComboBoxModel(new String[] { "Reserva", "Checking", "Pago", "Cancelado" })); cbotipo_reserva.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cbotipo_reservaActionPerformed(evt); } }); btnnuevo.setBackground(new java.awt.Color(51, 51, 51)); btnnuevo.setForeground(new java.awt.Color(255, 255, 255)); btnnuevo.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Files/nuevo.GIF"))); // NOI18N btnnuevo.setText("Novo"); btnnuevo.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnnuevoActionPerformed(evt); } }); btnguardar.setBackground(new java.awt.Color(51, 51, 51)); btnguardar.setForeground(new java.awt.Color(255, 255, 255)); btnguardar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Files/guardar.png"))); // NOI18N btnguardar.setText("Salvar"); btnguardar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnguardarActionPerformed(evt); } }); btncancelar.setBackground(new java.awt.Color(51, 51, 51)); btncancelar.setForeground(new java.awt.Color(255, 255, 255)); btncancelar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Files/cancelar.png"))); // NOI18N btncancelar.setText("Cancelar"); btncancelar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btncancelarActionPerformed(evt); } }); txtnumero.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { txtnumeroActionPerformed(evt); } }); txtidcliente.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { txtidclienteActionPerformed(evt); } }); txtcliente.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { txtclienteActionPerformed(evt); } }); jLabel5.setText("Funcionrio:"); txtidtrabajador.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { txtidtrabajadorActionPerformed(evt); } }); txttrabajador.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { txttrabajadorActionPerformed(evt); } }); jLabel3.setText("Data Reserva:"); jLabel8.setText("Data entrada:"); jLabel10.setText("Data sada:"); jLabel11.setText("Situao:"); cboestado.setModel( new javax.swing.DefaultComboBoxModel(new String[] { "Funcionado", "Manuteno", "Limpeza" })); cboestado.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cboestadoActionPerformed(evt); } }); btnbuscahabitacion.setText("..."); btnbuscahabitacion.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnbuscahabitacionActionPerformed(evt); } }); btnbuscacliente.setText("..."); btnbuscacliente.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnbuscaclienteActionPerformed(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().addGap(20, 20, 20).addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addGap(66, 66, 66) .addComponent(txtidreserva, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(139, 212, Short.MAX_VALUE)) .addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addGap(10, 10, 10) .addComponent(jLabel11).addGap(34, 34, 34).addComponent(cboestado, javax.swing.GroupLayout.PREFERRED_SIZE, 148, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(jPanel1Layout.createSequentialGroup().addComponent(btnnuevo) .addGap(42, 42, 42).addComponent(btnguardar).addGap(58, 58, 58) .addComponent(btncancelar)) .addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel8) .addGap(44, 44, 44).addComponent(dcfecha_ingresa, javax.swing.GroupLayout.PREFERRED_SIZE, 169, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup().addComponent(jLabel10) .addGap(44, 44, 44)) .addGroup(jPanel1Layout.createSequentialGroup() .addComponent(jLabel6).addGap(93, 93, 93))) .addGroup(jPanel1Layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addComponent(txtcosto_alojamiento, javax.swing.GroupLayout.PREFERRED_SIZE, 98, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(dcfecha_salida, javax.swing.GroupLayout.PREFERRED_SIZE, 169, javax.swing.GroupLayout.PREFERRED_SIZE))))) .addGap(0, 0, Short.MAX_VALUE)) .addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false) .addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel5) .addGap(48, 48, 48)) .addGroup( javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel3).addComponent(jLabel7)) .addGap(34, 34, 34))) .addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(cbotipo_reserva, javax.swing.GroupLayout.PREFERRED_SIZE, 148, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(jPanel1Layout.createSequentialGroup() .addComponent(txtidtrabajador, javax.swing.GroupLayout.PREFERRED_SIZE, 51, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18).addComponent(txttrabajador, javax.swing.GroupLayout.PREFERRED_SIZE, 190, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(jPanel1Layout.createSequentialGroup().addGap(10, 10, 10) .addComponent(dcfecha_reserva, javax.swing.GroupLayout.PREFERRED_SIZE, 169, javax.swing.GroupLayout.PREFERRED_SIZE)))) .addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel4) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(txtidcliente, javax.swing.GroupLayout.PREFERRED_SIZE, 51, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18).addComponent(txtcliente, javax.swing.GroupLayout.PREFERRED_SIZE, 159, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout .createSequentialGroup().addComponent(jLabel2) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(txtidhabitacion, javax.swing.GroupLayout.PREFERRED_SIZE, 51, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18).addComponent(txtnumero, javax.swing.GroupLayout.PREFERRED_SIZE, 159, javax.swing.GroupLayout.PREFERRED_SIZE))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(btnbuscahabitacion, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(btnbuscacliente, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap()))))); jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addComponent(txtidreserva, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(23, 23, 23) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel2) .addComponent(txtidhabitacion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(txtnumero, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(btnbuscahabitacion)) .addGap(18, 18, 18) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(txtidcliente, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(txtcliente, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel4).addComponent(btnbuscacliente)) .addGap(18, 18, 18) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(txtidtrabajador, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(txttrabajador, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel5)) .addGap(18, 18, 18) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(cbotipo_reserva, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel7)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel3).addComponent(dcfecha_reserva, 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.TRAILING) .addComponent(jLabel8).addComponent(dcfecha_ingresa, 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.TRAILING) .addComponent(jLabel10).addComponent(dcfecha_salida, 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(txtcosto_alojamiento, 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(cboestado, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel11)) .addGap(52, 52, 52) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(btnnuevo).addComponent(btnguardar).addComponent(btncancelar)) .addContainerGap(24, Short.MAX_VALUE))); jPanel2.setBackground(new java.awt.Color(255, 255, 153)); jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("Lista de Reservas")); tablalistado .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[] { "Title 1", "Title 2", "Title 3", "Title 4" })); tablalistado.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { tablalistadoMouseClicked(evt); } }); jScrollPane3.setViewportView(tablalistado); jLabel9.setText("Buscar"); btnbuscar.setBackground(new java.awt.Color(51, 51, 51)); btnbuscar.setForeground(new java.awt.Color(255, 255, 255)); btnbuscar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Files/buscar.png"))); // NOI18N btnbuscar.setText("Buscar"); btnbuscar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnbuscarActionPerformed(evt); } }); btneliminar.setBackground(new java.awt.Color(51, 51, 51)); btneliminar.setForeground(new java.awt.Color(255, 255, 255)); btneliminar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Files/eliminar.png"))); // NOI18N btneliminar.setText("Apagar"); btneliminar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btneliminarActionPerformed(evt); } }); btnsalir.setBackground(new java.awt.Color(51, 51, 51)); btnsalir.setForeground(new java.awt.Color(255, 255, 255)); btnsalir.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Files/salir.gif"))); // NOI18N btnsalir.setText("Sair"); btnsalir.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnsalirActionPerformed(evt); } }); lbltotalregistros.setText("Registros"); btnverconsumo.setText("Produtos"); btnverconsumo.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnverconsumoActionPerformed(evt); } }); btnrealizarpagos.setText("Realizar Pagamentos"); btnrealizarpagos.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnrealizarpagosActionPerformed(evt); } }); javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2); jPanel2.setLayout(jPanel2Layout); jPanel2Layout.setHorizontalGroup(jPanel2Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup().addGroup(jPanel2Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(jScrollPane3) .addGroup(jPanel2Layout.createSequentialGroup().addContainerGap().addGroup(jPanel2Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false) .addGroup(jPanel2Layout.createSequentialGroup() .addComponent(btnverconsumo, javax.swing.GroupLayout.PREFERRED_SIZE, 169, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(28, 28, 28) .addComponent(btnrealizarpagos, javax.swing.GroupLayout.PREFERRED_SIZE, 169, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(lbltotalregistros, javax.swing.GroupLayout.PREFERRED_SIZE, 109, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup( jPanel2Layout.createSequentialGroup().addComponent(jLabel9) .addGap(18, 18, 18) .addComponent(txtbuscar, javax.swing.GroupLayout.PREFERRED_SIZE, 169, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(btnbuscar, javax.swing.GroupLayout.PREFERRED_SIZE, 98, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18).addComponent(btneliminar).addGap(18, 18, 18) .addComponent(btnsalir))) .addGap(0, 145, Short.MAX_VALUE))) .addContainerGap())); jPanel2Layout.setVerticalGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup() .addGap(20, 20, 20) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel9) .addComponent(txtbuscar, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(btnbuscar).addComponent(btneliminar).addComponent(btnsalir)) .addGap(18, 18, 18) .addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE) .addGap(5, 5, 5) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(lbltotalregistros).addComponent(btnverconsumo) .addComponent(btnrealizarpagos)))); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGap(19, 19, 19) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel1) .addGroup(layout.createSequentialGroup() .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))) .addContainerGap())); layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGap(19, 19, 19).addComponent(jLabel1).addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))); pack(); }// </editor-fold>//GEN-END:initComponents private void txtidhabitacionActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtidhabitacionActionPerformed // TODO add your handling code here: txtidhabitacion.transferFocus(); }//GEN-LAST:event_txtidhabitacionActionPerformed private void txtcosto_alojamientoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtcosto_alojamientoActionPerformed // TODO add your handling code here: txtcosto_alojamiento.transferFocus(); }//GEN-LAST:event_txtcosto_alojamientoActionPerformed private void cbotipo_reservaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cbotipo_reservaActionPerformed // TODO add your handling code here: cbotipo_reserva.transferFocus(); }//GEN-LAST:event_cbotipo_reservaActionPerformed private void btnnuevoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnnuevoActionPerformed // TODO add your handling code here: habilitar(); btnguardar.setText("Guardar"); acao = "novo"; }//GEN-LAST:event_btnnuevoActionPerformed private void btnguardarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnguardarActionPerformed // TODO add your handling code here: DateTime dateVerificarReserva; DateTime dateVerificarEntrada; DateTime dateVerificarSaida; if (txtidhabitacion.getText().length() == 0) { JOptionPane.showMessageDialog(rootPane, "Selecione um quarto"); txtidhabitacion.requestFocus(); return; } if (txtidcliente.getText().length() == 0) { JOptionPane.showMessageDialog(rootPane, "Selecione um cliente"); txtidcliente.requestFocus(); return; } if (txtcosto_alojamiento.getText().length() == 0) { JOptionPane.showMessageDialog(rootPane, "Preencha o valor da reserva"); txtcosto_alojamiento.requestFocus(); return; } vreserva dts = new vreserva(); freserva func = new freserva(); dts.setIdhabitacion(Integer.parseInt(txtidhabitacion.getText())); dts.setIdcliente(Integer.parseInt(txtidcliente.getText())); dts.setIdtrabajador(idusuario); int seleccionado = cbotipo_reserva.getSelectedIndex(); dts.setTipo_reserva((String) cbotipo_reserva.getItemAt(seleccionado)); Calendar cal; int d, m, a; cal = dcfecha_reserva.getCalendar(); d = cal.get(Calendar.DAY_OF_MONTH); m = cal.get(Calendar.MONTH); a = cal.get(Calendar.YEAR) - 1900; dts.setFecha_reserva(new Date(a, m, d)); cal = dcfecha_ingresa.getCalendar(); d = cal.get(Calendar.DAY_OF_MONTH); m = cal.get(Calendar.MONTH); a = cal.get(Calendar.YEAR) - 1900; dts.setFecha_ingresa(new Date(a, m, d)); cal = dcfecha_salida.getCalendar(); d = cal.get(Calendar.DAY_OF_MONTH); m = cal.get(Calendar.MONTH); a = cal.get(Calendar.YEAR) - 1900; dts.setFecha_salida(new Date(a, m, d)); dts.setCosto_alojamiento(Double.parseDouble(txtcosto_alojamiento.getText())); seleccionado = cboestado.getSelectedIndex(); dts.setEstado((String) cboestado.getItemAt(seleccionado)); if (acao.equals("novo")) { dateVerificarReserva = new DateTime(dts.getFecha_reserva().getTime()); dateVerificarEntrada = new DateTime(dts.getFecha_ingresa().getTime()); dateVerificarSaida = new DateTime(dts.getFecha_salida().getTime()); dateVerificarReserva = dateVerificarReserva.plusDays(1); dateVerificarEntrada = dateVerificarEntrada.plusDays(1); dateVerificarSaida = dateVerificarSaida.plusDays(1); if (dateVerificarReserva.isBeforeNow() || dateVerificarEntrada.isBeforeNow() || dateVerificarSaida.isBeforeNow()) { JOptionPane.showMessageDialog(rootPane, "Selecione uma data atual"); return; } if (validarDisponibilidade()) { JOptionPane.showMessageDialog(rootPane, "Quarto no disponivel para esta data"); return; } if (func.insertar(dts)) { JOptionPane.showMessageDialog(rootPane, "A reserva foi registrada com sucesso"); mostrar(""); inhabilitar(); //ocupamos la Habitacin alquilada fhabitacion func3 = new fhabitacion(); vhabitacion dts3 = new vhabitacion(); dts3.setIdhabitacion(Integer.parseInt(txtidhabitacion.getText())); func3.ocupar(dts3); } } else if (acao.equals("editar")) { if (validarDisponibilidade()) { JOptionPane.showMessageDialog(rootPane, "Quarto no disponivel para esta data"); return; } dts.setIdreserva(Integer.parseInt(txtidreserva.getText())); dts.setIdtrabajador(Integer.parseInt(txtidtrabajador.getText())); if (func.editar(dts)) { JOptionPane.showMessageDialog(rootPane, "A reserva foi editada com sucesso"); mostrar(""); inhabilitar(); } } }//GEN-LAST:event_btnguardarActionPerformed private void btncancelarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btncancelarActionPerformed // TODO add your handling code here: this.dispose(); }//GEN-LAST:event_btncancelarActionPerformed private void tablalistadoMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tablalistadoMouseClicked // TODO add your handling code here: fhabitacion quaContro = new fhabitacion(); vhabitacion vQuarto = new vhabitacion(); btnguardar.setText("Editar"); habilitar(); btneliminar.setEnabled(true); acao = "editar"; int fila = tablalistado.rowAtPoint(evt.getPoint()); txtidreserva.setText(tablalistado.getValueAt(fila, 0).toString()); txtidhabitacion.setText(tablalistado.getValueAt(fila, 1).toString()); txtnumero.setText(tablalistado.getValueAt(fila, 2).toString()); txtidcliente.setText(tablalistado.getValueAt(fila, 3).toString()); txtcliente.setText(tablalistado.getValueAt(fila, 4).toString()); txtidtrabajador.setText(tablalistado.getValueAt(fila, 5).toString()); txttrabajador.setText(tablalistado.getValueAt(fila, 6).toString()); cbotipo_reserva.setSelectedItem(tablalistado.getValueAt(fila, 7).toString()); dcfecha_reserva.setDate( Date.valueOf(Utils.getInstance().desformatarData(tablalistado.getValueAt(fila, 8).toString()))); dcfecha_ingresa.setDate( Date.valueOf(Utils.getInstance().desformatarData(tablalistado.getValueAt(fila, 9).toString()))); dcfecha_salida.setDate( Date.valueOf(Utils.getInstance().desformatarData(tablalistado.getValueAt(fila, 10).toString()))); txtcosto_alojamiento.setText(tablalistado.getValueAt(fila, 11).toString()); cboestado.setSelectedItem(tablalistado.getValueAt(fila, 12).toString()); if (txtidhabitacion.getText() != "") { vQuarto.setIdhabitacion(Integer.valueOf(txtidhabitacion.getText())); } else { return; } vQuarto = quaContro.procurarQuartoPorId(vQuarto); if (vQuarto.getPrecio_diario() != null) { this.valorAlguel = vQuarto.getPrecio_diario().toString().replace(".0", ""); } }//GEN-LAST:event_tablalistadoMouseClicked private void btnbuscarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnbuscarActionPerformed // TODO add your handling code here: mostrar(txtbuscar.getText()); }//GEN-LAST:event_btnbuscarActionPerformed private void btneliminarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btneliminarActionPerformed // TODO add your handling code here: if (!txtidreserva.getText().equals("")) { int confirmacion = JOptionPane.showConfirmDialog(rootPane, "Tem certeza que deseja apagar a reserva?", "Confirmar", 2); if (confirmacion == 0) { freserva func = new freserva(); vreserva dts = new vreserva(); dts.setIdreserva(Integer.parseInt(txtidreserva.getText())); func.eliminar(dts); mostrar(""); inhabilitar(); } } }//GEN-LAST:event_btneliminarActionPerformed private void btnsalirActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnsalirActionPerformed // TODO add your handling code here: this.dispose(); }//GEN-LAST:event_btnsalirActionPerformed private void txtnumeroActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtnumeroActionPerformed // TODO add your handling code here: }//GEN-LAST:event_txtnumeroActionPerformed private void txtidclienteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtidclienteActionPerformed // TODO add your handling code here: }//GEN-LAST:event_txtidclienteActionPerformed private void txtclienteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtclienteActionPerformed // TODO add your handling code here: }//GEN-LAST:event_txtclienteActionPerformed private void txtidtrabajadorActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtidtrabajadorActionPerformed // TODO add your handling code here: }//GEN-LAST:event_txtidtrabajadorActionPerformed private void txttrabajadorActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txttrabajadorActionPerformed // TODO add your handling code here: }//GEN-LAST:event_txttrabajadorActionPerformed private void cboestadoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cboestadoActionPerformed // TODO add your handling code here: }//GEN-LAST:event_cboestadoActionPerformed private void btnbuscahabitacionActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnbuscahabitacionActionPerformed // TODO add your handling code here: frmvistahabitacion form = new frmvistahabitacion(); form.toFront(); form.setVisible(true); }//GEN-LAST:event_btnbuscahabitacionActionPerformed private void btnbuscaclienteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnbuscaclienteActionPerformed // TODO add your handling code here: frmvistacliente form = new frmvistacliente(); form.toFront(); form.setVisible(true); }//GEN-LAST:event_btnbuscaclienteActionPerformed private void btnverconsumoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnverconsumoActionPerformed // TODO add your handling code here: int fila = tablalistado.getSelectedRow(); if (fila < 0) { JOptionPane.showMessageDialog(this, "Favor selecione uma linha", "Ateno", JOptionPane.WARNING_MESSAGE); return; } frmConsumo.idreserva = tablalistado.getValueAt(fila, 0).toString(); frmConsumo.cliente = tablalistado.getValueAt(fila, 4).toString(); frmConsumo form = new frmConsumo(); frminicio.escritorio.add(form); form.toFront(); form.setVisible(true); }//GEN-LAST:event_btnverconsumoActionPerformed private void btnrealizarpagosActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnrealizarpagosActionPerformed // TODO add your handling code here: int fila = tablalistado.getSelectedRow(); if (fila < 0) { JOptionPane.showMessageDialog(this, "Favor selecione uma linha", "Ateno", JOptionPane.WARNING_MESSAGE); return; } frmPago.idreserva = tablalistado.getValueAt(fila, 0).toString(); frmPago.cliente = tablalistado.getValueAt(fila, 4).toString(); frmPago.totalreserva = Double.parseDouble(tablalistado.getValueAt(fila, 11).toString()); frmPago.idhabitacion = tablalistado.getValueAt(fila, 1).toString(); frmPago.habitacion = tablalistado.getValueAt(fila, 2).toString(); frmPago form = new frmPago(); frminicio.escritorio.add(form); form.toFront(); form.setVisible(true); }//GEN-LAST:event_btnrealizarpagosActionPerformed private void txtcosto_alojamientoFocusGained(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_txtcosto_alojamientoFocusGained if (dcfecha_ingresa.getDate() == null || dcfecha_ingresa.getDate() == null || this.valorAlguel == null || !this.txtcosto_alojamiento.getText().isEmpty()) { return; } DateTime jdEntrada = new DateTime(dcfecha_ingresa.getDate().getTime()); DateTime jdSaida = new DateTime(dcfecha_salida.getDate().getTime()); Integer numDiasEstadia = Days.daysBetween(jdEntrada, jdSaida).getDays(); txtcosto_alojamiento.setText(Integer.toString(Integer.valueOf(this.valorAlguel) * numDiasEstadia)); }//GEN-LAST:event_txtcosto_alojamientoFocusGained /** * @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(frmreserva.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(frmreserva.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(frmreserva.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(frmreserva.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 frmreserva().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton btnbuscacliente; private javax.swing.JButton btnbuscahabitacion; private javax.swing.JButton btnbuscar; private javax.swing.JButton btncancelar; private javax.swing.JButton btneliminar; private javax.swing.JButton btnguardar; private javax.swing.JButton btnnuevo; private javax.swing.JButton btnrealizarpagos; private javax.swing.JButton btnsalir; private javax.swing.JButton btnverconsumo; private javax.swing.JComboBox cboestado; private javax.swing.JComboBox cbotipo_reserva; private com.toedter.calendar.JDateChooser dcfecha_ingresa; private com.toedter.calendar.JDateChooser dcfecha_reserva; private com.toedter.calendar.JDateChooser dcfecha_salida; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel10; private javax.swing.JLabel jLabel11; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private javax.swing.JLabel jLabel8; private javax.swing.JLabel jLabel9; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel2; private javax.swing.JScrollPane jScrollPane3; private javax.swing.JLabel lbltotalregistros; private javax.swing.JTable tablalistado; private javax.swing.JTextField txtbuscar; public static javax.swing.JTextField txtcliente; private javax.swing.JTextField txtcosto_alojamiento; public static javax.swing.JTextField txtidcliente; public static javax.swing.JTextField txtidhabitacion; private javax.swing.JTextField txtidreserva; public static javax.swing.JTextField txtidtrabajador; public static javax.swing.JTextField txtnumero; public static javax.swing.JTextField txttrabajador; // End of variables declaration//GEN-END:variables private Boolean validarDisponibilidade() { DefaultTableModel modelo; DefaultTableModel modelo2; freserva freserva = new freserva(); vreserva vReserva = new vreserva(); freserva func = new freserva(); Boolean validacao = false; DateTime dtEntrada = new DateTime(dcfecha_ingresa.getDate().getTime()); DateTime dtSaida = new DateTime(dcfecha_salida.getDate().getTime()); dtEntrada = dtEntrada.plusDays(1); dtSaida = dtSaida.minusDays(1); vReserva.setIdhabitacion(Integer.valueOf(txtnumero.getText())); vReserva.setFecha_ingresa(new java.sql.Date(dtEntrada.getMillis())); vReserva.setFecha_salida(new java.sql.Date(dtSaida.getMillis())); if (!this.txtidreserva.getText().isEmpty()) { vReserva.setIdreserva(Integer.valueOf(this.txtidreserva.getText())); } modelo = freserva.validarDisponibilidade(vReserva); if (modelo.getRowCount() > 0) { tablalistado.setModel(modelo); ocultar_columnas(); validacao = true; } dtEntrada = dtEntrada.minusDays(1); dtSaida = dtSaida.plusDays(1); vReserva.setIdhabitacion(Integer.valueOf(txtnumero.getText())); vReserva.setFecha_ingresa(new java.sql.Date(dtEntrada.getMillis())); vReserva.setFecha_salida(new java.sql.Date(dtSaida.getMillis())); if (!this.txtidreserva.getText().isEmpty()) { vReserva.setIdreserva(Integer.valueOf(this.txtidreserva.getText())); } modelo2 = freserva.verificarReservaMesmaDataPorQuarto(vReserva); if (modelo2.getRowCount() > 0) { tablalistado.setModel(modelo2); ocultar_columnas(); validacao = true; } return validacao; } }