public int miseAJourStatutCommande() {
ConnexionBD bd = new ConnexionBD();
Statement st = bd.createStatement();
int rs = 0;
try {
// on regarde combie de colis à la commande correspondant au colis controle
ResultSet i =
st.executeQuery(
"SELECT id_commande, count(id_colis) FROM "
+ Constantes.base_colis
+ " WHERE id_colis = "
+ id
+ " GROUP BY id_commande;");
if (i.next()) {
int numCommande = i.getInt(1);
int nbColis = i.getInt(2);
// i.close();
// on récupère les colis donc le statut à été controle, cad passer par la douane et approuvé
ResultSet g =
st.executeQuery(
" SELECT id_colis FROM "
+ Constantes.base_colis
+ " WHERE id_commande = "
+ numCommande
+ " AND statut IN ('controle', 'emballe') GROUP BY id_colis;");
if (g.next()) {
g.last();
int nombreColis = g.getRow();
g.beforeFirst();
// si le nombre de colis de la commande est égal au nombre de colis controle de la
// commande, on peut changer le statut de la commande a expedie
if (nbColis == nombreColis) {
rs =
st.executeUpdate(
"UPDATE "
+ Constantes.base_commande
+ " SET statut = 'expediee' WHERE id_commande = "
+ numCommande
+ ";");
}
} else {
System.out.println("NOOOON");
}
} else {
System.out.println("RIEEEEN");
}
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
public void updateInfos() {
ConnexionBD bd = new ConnexionBD();
Statement st = bd.createStatement();
try {
ResultSet rs =
st.executeQuery(
"SELECT id_colis, id_commande, cast(date_emballage as varchar) FROM "
+ Constantes.base_colis
+ " natural join "
+ Constantes.base_emballage
+ " WHERE id_colis ="
+ id
+ ";");
int col, com;
String embal;
if (rs.next()) {
// rs.previous();
col = rs.getInt(1);
com = rs.getInt(2);
embal = rs.getString(3);
// q = rs.getInt(4);
colis.setText(String.valueOf(col));
commande.setText(String.valueOf(com));
date.setText(embal);
// qual.setText(String.valueOf(q));
}
rs.close();
st.close();
bd.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public int miseAJour(String statutC) {
ConnexionBD bd = new ConnexionBD();
Statement st = bd.createStatement();
int rs = 0;
try {
rs =
st.executeUpdate(
"UPDATE "
+ Constantes.base_colis
+ " SET statut = '"
+ statutC
+ "' WHERE id_colis = "
+ id
+ ";");
miseAJourStatutCommande();
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
public InfosColis(int idColis, String statut) {
ConnexionBD conn = new ConnexionBD();
Statement st = conn.createStatement();
ResultSet rs;
try {
rs =
st.executeQuery(
"SELECT id_produit, quantite FROM "
+ Constantes.base_contenuColis
+ " WHERE id_colis="
+ idColis
+ ";");
LinkedList<Object[]> save = new LinkedList<Object[]>();
while (rs.next()) {
Object[] data = new Object[2];
data[0] = rs.getString(1);
data[1] = rs.getInt(2);
save.add(data);
}
donnees = new Object[save.size()][];
for (int i = 0; i < donnees.length; i++) {
donnees[i] = save.get(i);
}
// --Table
DefaultTableModel tableModel =
new DefaultTableModel(donnees, columnNames) {
private static final long serialVersionUID = 1L;
public boolean isCellEditable(int iRowIndex, int iColumnIndex) {
return false;
}
};
jt = new JTable(tableModel);
} catch (SQLException e) {
e.printStackTrace();
}
panelTable = new JPanel();
// panelTable.setVisible(true);
panelTable.setLayout(new BorderLayout());
panelTable.add(jt.getTableHeader(), BorderLayout.PAGE_START);
// panelTable.add(new JScrollPane(jt), BorderLayout.CENTER);
panelTable.add(jt, BorderLayout.CENTER);
panelTable.setVisible(false);
// panelTable.repaint();
// scrollJT.revalidate();
// panelTable.revalidate();
ImageIcon iconeDerouler = new ImageIcon();
try {
BufferedImage img = ImageIO.read(new File("src/ic_menu_add.png"));
Image resize = img.getScaledInstance(20, 20, Image.SCALE_SMOOTH);
iconeDerouler.setImage(resize);
} catch (IOException e) {
e.printStackTrace();
}
derouler = new JButton(iconeDerouler);
derouler.addActionListener(this);
derouler.setContentAreaFilled(false);
derouler.setBorderPainted(false);
JLabel infos = new JLabel("ID: " + idColis + " [" + statut + "]");
entete = new JPanel();
entete.add(derouler);
entete.add(infos);
this.setLayout(new BorderLayout());
this.add(entete, BorderLayout.NORTH);
this.add(panelTable, BorderLayout.CENTER);
// this.revalidate();
}