Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String rndIdProses = System.currentTimeMillis() + RandomDataGenerator.randomString(5);
- Date systemDate = TimeUtil.getSystemDate();
- for (TrxPembayaranSisaCutiDetailSaldoCutiKaryawan pembayaranSisaCutiDetailSaldoCutiKaryawan: pembayaranSisaCutiDetailSaldoCutiKaryawanList) {
- em.createNativeQuery("INSERT INTO hat_alokasi_saldo_cuti_i001 "
- + "VALUES(:id, :processId, :karyawanId, :kelompokJenisAbsensiId, :version, :usrCrt, :crtTime, :usrMod, :modTime)")
- .setParameter("id", UUID.randomUUID().toString())
- .setParameter("processId", rndIdProses)
- .setParameter("karyawanId", pembayaranSisaCutiDetailSaldoCutiKaryawan.getSaldoCuti().getKaryawan().getId())
- .setParameter("kelompokJenisAbsensiId", pembayaranSisaCutiDetailSaldoCutiKaryawan.getSaldoCuti().getSdKelompokJenisAbsensi().getId())
- .setParameter("version", 1)
- .setParameter("usrCrt", CurrentUser.getUsername())
- .setParameter("crtTime", systemDate)
- .setParameter("usrMod", CurrentUser.getUsername())
- .setParameter("modTime", systemDate)
- .executeUpdate();
- }
- clearSpParameter();
- addSpParameter(rndIdProses);
- addSpParameter(CurrentUser.getUsername());
- addSpParameter(TimeUtil.convertDateToSQLString(systemDate));
- executeVoidProcedure("public.spHatAlokasiSaldoCuti");
- em.createNativeQuery("DELETE FROM hat_alokasi_saldo_cuti_i001 WHERE process_id = :rndIdProses")
- .setParameter("rndIdProses", rndIdProses)
- .executeUpdate();
Advertisement
Add Comment
Please, Sign In to add comment