ronaldkwandy

Untitled

Jan 14th, 2020
309
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.13 KB | None | 0 0
  1. @Transactional
  2.   public void executeSpHatAlokasiSaldoCuti(Employee karyawan, SdKelompokJenisAbsensi kelompokJenisAbsensi) {
  3.         String rndIdProses = System.currentTimeMillis() + RandomDataGenerator.randomString(5);
  4.        
  5.         em.createNativeQuery("INSERT INTO hat_alokasi_saldo_cuti_i001 "
  6.                 + "VALUES(:id,:processId,:karyawanId,:sdKelompokJenisAbsensi,:version,:usrCrt,:crtTime,:usrMod,:modTime)")
  7.                 .setParameter("id", UUID.randomUUID().toString())
  8.                 .setParameter("processId", rndIdProses)
  9.                 .setParameter("karyawanId", karyawan.getId())
  10.                 .setParameter("sdKelompokJenisAbsensi", kelompokJenisAbsensi.getId())
  11.                 .setParameter("version", 1)
  12.                 .setParameter("usrCrt", CurrentUser.getUsername())
  13.                 .setParameter("crtTime", TimeUtil.getSystemDateTime())
  14.                 .setParameter("usrMod", CurrentUser.getUsername())
  15.                 .setParameter("modTime", TimeUtil.getSystemDateTime())
  16.                 .executeUpdate();
  17.        
  18.         clearSpParameter();
  19.         addSpParameter(rndIdProses);
  20.         addSpParameter(CurrentUser.getUsername());
  21.         addSpParameter(TimeUtil.convertDateToSQLString(TimeUtil.getSystemDateTime()));
  22.         executeVoidProcedure("public.spHatAlokasiSaldoCuti");
  23.   }
Advertisement
Add Comment
Please, Sign In to add comment