public IntervenantPage() throws SQLException {
initComponents();
ConnectBDD();
jTextField1.setText("-");
jLabel4.setVisible(false);
jComboBox3.setVisible(false);
jLabel5.setVisible(false);
jTextField1.setVisible(false);
identifiantConnect = ConnectPage.getIdentifiant();
IntervenantsDAO i1 = new IntervenantsDAO();
i1.getConnection();
ArrayList<Intervenants> mesLogin = i1.selectAll();
for (Intervenants ii : mesLogin) {
jComboBox1.addItem(ii.getLogin());
}
OrdinateurDAO o1 = new OrdinateurDAO();
o1.getConnection();
ArrayList<Ordinateur> mesordi = o1.selectAll();
for (Ordinateur oo : mesordi) {
jComboBox2.addItem(oo.getRefOrdinateur());
}
PanneDAO p1 = new PanneDAO();
p1.getConnection();
ArrayList<Panne> mesPanne = p1.selectAll();
DefaultTableModel model = new DefaultTableModel();
model.addColumn("Id Panne");
model.addColumn("Date Panne");
model.addColumn("Type Materiel");
model.addColumn("Urgence Panne");
model.addColumn("Peripherique Panne");
model.addColumn("Ordinateur");
model.addColumn("Descriptif");
for (Panne pp : mesPanne) {
model.addRow(
new Object[] {
pp.getIdPanne(),
pp.getDatePanne(),
pp.getTypeMaterielPanne(),
pp.getUrgencePanne(),
pp.getPeripheriquePanne(),
pp.getIdOrdinateurPanne(),
pp.getDescriptifPanne()
});
}
jTable2.setModel(model);
this.setIconImage(new ImageIcon(getClass().getResource("gsb-icon.png")).getImage());
}
private void jComboBox5ActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jComboBox5ActionPerformed
int a = jComboBox3.getSelectedIndex();
int b = jComboBox5.getSelectedIndex();
if (b == 1) { // SI TYPE SELECTIONNEE EST HARDWARE
jLabel4.setVisible(true);
jComboBox3.setVisible(true);
jLabel5.setVisible(true);
jTextField1.setVisible(true);
if (a == 1) {
variable = "CarteMere";
} else if (a == 2) {
variable = "Processeur";
} else if (a == 3) {
variable = "MemoireVive";
} else if (a == 4) {
variable = "DisqueDur";
} else if (a == 5) {
variable = "CarteReseau";
} else if (a == 6) {
variable = "Lecteur";
} else if (a == 7) {
variable = "CarteGraphique";
} else if (a == 8) {
variable = "CarteSon";
} else if (a == 9) {
variable = "Alimentation";
}
} else {
jLabel4.setVisible(false);
jComboBox3.setVisible(false);
jLabel5.setVisible(false);
jTextField1.setVisible(false);
}
String panne;
boolean compare;
int idPanne;
jComboBox4.removeAllItems();
PanneDAO p2 = new PanneDAO();
p2.getConnection();
ArrayList<Panne> mesPanne2 = p2.selectAll();
machine = jComboBox2.getSelectedItem().toString();
for (Panne pp : mesPanne2) {
panne = pp.getIdOrdinateurPanne();
idPanne = pp.getIdPanne();
selected = jComboBox5.getSelectedItem().toString();
String typeMaterielPanne = pp.getTypeMaterielPanne();
compare = panne.equals(machine);
if (compare == true) {
if (typeMaterielPanne.equals(selected)) {
jComboBox4.addItem(idPanne);
}
}
}
} // GEN-LAST:event_jComboBox5ActionPerformed
private void jButton3ActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton3ActionPerformed
modification = jTextField1.getText();
machine = jComboBox2.getSelectedItem().toString();
intervenant = jComboBox1.getSelectedItem().toString();
composant = jComboBox3.getSelectedItem().toString();
info = jTextArea1.getText();
try {
formatDate = df.format(jDateChooser1.getDate());
try {
int a = jComboBox3.getSelectedIndex();
int b = jComboBox5.getSelectedIndex();
if (b == 1) { // SI TYPE SELECTIONNEE EST HARDWARE
Ordinateur update = new Ordinateur(variable, modification, machine);
OrdinateurDAO ordi = new OrdinateurDAO();
ordi.getConnection();
ordi.update(update);
}
int idPanneSelect;
idPanneSelect = jComboBox4.getSelectedItem().hashCode();
InterventionDAO iDAO = new InterventionDAO(); // DEBUT INSERT INTERVENTION
Intervention insertInter =
new Intervention(
formatDate,
machine,
composant,
idPanneSelect,
modification,
info,
identifiantConnect);
iDAO.getConnection();
iDAO.insert(insertInter);
int idPanne = jComboBox4.getSelectedItem().hashCode();
Panne delete = new Panne(idPanne);
PanneDAO ordinateurPanne = new PanneDAO();
ordinateurPanne.getConnection();
ordinateurPanne.delete(delete);
jComboBox4.removeAllItems();
PanneDAO p2 = new PanneDAO(); // ACTUALISE ID PANNE
p2.getConnection();
ArrayList<Panne> mesPanne2 = p2.selectAll();
String panne;
boolean compare;
for (Panne pp : mesPanne2) {
panne = pp.getIdOrdinateurPanne();
idPanne = pp.getIdPanne();
compare = panne.equals(machine);
if (compare == true) {
jComboBox4.addItem(idPanne);
}
}
} catch (Exception e) {
jTextArea1.setText("-");
jTextField1.setText("-");
JOptionPane.showMessageDialog(null, "Veuillez spécifier tous les champs ");
e.printStackTrace();
}
jTextField1.setText("-");
jTextArea1.setText("-");
JOptionPane.showMessageDialog(null, "Votre panne a bien etais résolu");
} catch (Exception e) {
jTextArea1.setText("-");
jTextField1.setText("-");
JOptionPane.showMessageDialog(null, "Veuillez selectionner une date ");
e.printStackTrace();
}
PanneDAO p1 = new PanneDAO(); // ACTUALISE HISTORIQUE PANNE
p1.getConnection();
ArrayList<Panne> mesPanne = p1.selectAll();
DefaultTableModel model = new DefaultTableModel();
model.addColumn("Id Panne");
model.addColumn("Date Panne");
model.addColumn("Type Materiel");
model.addColumn("Urgence Panne");
model.addColumn("Peripherique Panne");
model.addColumn("Ordinateur");
model.addColumn("Descriptif");
for (Panne pp : mesPanne) {
model.addRow(
new Object[] {
pp.getIdPanne(),
pp.getDatePanne(),
pp.getTypeMaterielPanne(),
pp.getUrgencePanne(),
pp.getPeripheriquePanne(),
pp.getIdOrdinateurPanne(),
pp.getDescriptifPanne()
});
}
jTable2.setModel(model);
jComboBox5.setSelectedIndex(0);
machine = jComboBox2.getSelectedItem().toString();
intervenant = jComboBox1.getSelectedItem().toString();
composant = jComboBox3.getSelectedItem().toString();
info = jTextArea1.getText();
try {
FileWriter fw = new FileWriter("log_intervenant.txt", true);
BufferedWriter bw = new BufferedWriter(fw);
bw.newLine();
PrintWriter pw = new PrintWriter(bw);
pw.print(
"Modification: "
+ modification
+ "\n Machine: "
+ machine
+ "\n Intervenant: "
+ intervenant
+ "\n Composant: "
+ composant
+ "\n Info: "
+ info
+ "\n ----------------------- \n");
pw.close();
} catch (IOException e) {
System.out.println(" Problème à l’écriture du fichier ");
System.exit(0);
}
} // GEN-LAST:event_jButton3ActionPerformed