Untitled

router.post(
  "/kelas:id/update/:idData",
  upload.single("image"),
  function (req, res, next) {
    let idData = req.params.idData;
    let namaSiswa = req.body.nama_siswa;
    let alamat = req.body.alamat;
    let telepon = req.body.telepon;

    let errors = false;

    // Validasi
    if (namaSiswa.length === 0 || alamat.length === 0 || telepon.length === 0) {
      errors = true;

      req.flash("error", "Silahkan masukkan data anda");
      res.render("siswa/edit", {
        nama_siswa: namaSiswa,
        alamat: alamat,
        telepon: telepon,
      });
    }

    if (!errors) {
      connection.query(
        `SELECT image FROM kelas${req.params.id} WHERE id = ${idData}`,
        function (err, results) {
          if (err) {
            req.flash("error", err);
            res.render("siswa/edit", {
              nama_siswa: namaSiswa,
              alamat: alamat,
              telepon: telepon,
            });
          } else {
            let previousImage = results[0].image;

            if (previousImage) {
              fs.unlinkSync("public/images/" + previousImage);
            }

            let formData = {
              nama_siswa: namaSiswa,
              alamat: alamat,
              telepon: telepon,
            };

            if (req.file) {
              formData.image = req.file.originalname;
            }

            connection.query(
              `UPDATE kelas${req.params.id} SET ? WHERE id = ${idData}`,
              formData,
              function (err, result) {
                if (err) {
                  req.flash("error", err);
                  res.render("siswa/edit", {
                    nama_siswa: namaSiswa,
                    alamat: alamat,
                    telepon: telepon,
                  });
                } else {
                  req.flash("success", "Data berhasil di Edit");
                  res.redirect(`/siswa/kelas${req.params.id}`);
                }
              }
            );
          }
        }
      );
    }
  }
);