.idea

app.post("/post-data", upload.single("fileFoto"), (req, res) => {
  // prettier-ignore
  const { namaLengkap, NIS, NIS2, NISN, kelas, tempatLahir, tglLahir, blnLahir, thnLahir, alamat } = req.body;
  // prettier-ignore
  const programKeahlian = kelas == "Rekayasa Perangkat Lunak" ? "Teknik Informatika dan Komputer" : "Teknologi dan Rekayasa";
  const data = {
    nama: namaLengkap.toUpperCase(),
    nomorInduk: `${NIS}/${NIS2} - ${NISN}`,
    programKeahlian,
    kompetensiKeahlian: kelas,
    ttl: `${tempatLahir}, ${tglLahir} ${blnLahir} ${thnLahir}`,
    tmpfoto: req.file,
    alamat,
  };
  console.log(data);
  // prettier-ignore
  fs.renameSync(`./${data.tmpfoto.path.replace("\\", "/")}`, `./${data.tmpfoto.path.replace("\\", "/")}.jpeg`);
  const foto = data.tmpfoto.filename + ".jpeg";
  res.render("kartu", { data, foto });
});

app.post("/form/:kelas/add", upload.single("fileFoto"), (req, res) => {
  const { kelas } = req.params;
  const fileFoto = req.file;
  const { namaLengkap, NIS, NIS2, NISN, komp_keahlian, tempatLahir, tglLahir, blnLahir, thnLahir, alamat } = req.body;
  const ttl = `${tempatLahir}, ${tglLahir} ${blnLahir} ${thnLahir}`;
  const fileBlob = fileFoto.buffer;
  const fileName = fileFoto.originalname;
  const foto = `/uploads/${kelas}/${fileName}`
  if (!fs.existsSync(`./uploads/${kelas}`)) fs.mkdirSync(`./uploads/${kelas}`);
  fs.writeFileSync(`./uploads/${kelas}/${fileName}`, fileBlob);
  db.query(`INSERT INTO siswa(kelas, nama, nis, absen, nisn, komp_keahlian, ttl, alamat, foto) VALUES('${kelas}', '${namaLengkap}', '${NIS}', '${NIS2}', '${NISN}', '${komp_keahlian}', '${ttl}', '${alamat}', '${foto}')`, (err, result, field) => {
    if (err) res.json(`Error : ${err}`);
    res.json("Success!");
  });
});