select aa.*, bb.*
from "Pegawai".master_karyawan aa left join "Pegawai".master_karyawan_detail bb
on aa.kode_karyawan=bb.kode_karyawan
where aa.status='true' and aa.kode_karyawan='KW000152'
order by aa.kode_karyawanArray
(
[0] => Array
(
[kode_karyawan] => KW000152
[nama_karyawan] => AGUS SUSANTO
[alamat_karyawan] => JALAN KARYA MAKMUR RT05 RW02 KEL KARYA MULYA KEC SEMATANG BORANG PALEMBANG
[telpon_karyawan] => 82280132619
[telpon2_karyawan] => 0
[lokasi_karyawan] => PERTAMINA EP SITE ADERA
[status] => true
[kode_jabatan] => JBT039
[kode_wilayah] => WG0003
[info1] => 0
[info2] => 0
[tanggal_bergabung] => 2016-04-01 00:00:00
[no_ktp] => 1671082408920005
[tgl_ktp] => 2025-02-12 00:00:00
[pendidikan] => 2
[tipe_sim] => 0
[sio] =>
[sertifikat_hse] =>
[status_kerja] => 1
[tgl_kontrak] => 01/11/2025 - 20/04/2026
[alamat2_karyawan] => PENGABUAN
[no_rekening] => 110301006289508
[nama_bank] => 3
[tgl_expkontrak] => 2026-04-20 00:00:00
[asuransi] =>
[kondisi_karyawan] => 0
[divisi_karyawan] =>
[no_npwp] =>
[ptkp] => K/2
[nama_rekening] => AGUS SUSANTO
[tgl_lahir] => 1992-08-24 15:50:47
[no_bpjs] => 0001135319141
[no_bpjs_tk] => 13012274505
[hit_bpjs_tk] => UMP2025
[tambah_bpjs] => 0
[tgl_peserta_bpjstk] => 2013-05-01 00:00:01
[hit_bpjs_ks] => UMK2025
[tgl_resign] => 1900-01-01 00:00:00
[tempat_tgllahir] => PALEMBANG
[jenis_kelamin] => L
[email] => AGUS.SUSANTO78@YAHOO.COM
[no_pkwt] => PW-DP-250700054
[gaji_pokok] => 3681697.00
[uang_makan] => 35000.00
[tunjangan_jabatan] => 0.00
[tunjangan_hadir] => 5000.00
[tunjangan_lain] => 0.00
[lembur_regular] => 42563.00
[over_day] => 85000.00
[over_time] => 0
[uang_transport] => 0.00
[pot_bon_kantor] => 0
[pot_jamsostek] => 122948.00
[pot_lain] => 0
[bonus] => 5
[thr] => 0
[over_time_harian] => 0.00
[tunjangan_hadir_harian] => 0.00
[kompensasi] => 0.00
[tunjangan_pph21] => 0.00
[v_jam_opr] => 0
[premi] => 0
[u_mandah] => 0.00
[v_lembur] => 1
[status_pph21] => ya
[status_bpjs] => ya
[status_tunj_jab] => tdk
[pot_umakan] => 0
[gaji_harian] => 0.00
[hitung_ter] => bulan
)
)
select * from "Pegawai".master_gaji
where periode_gaji = '2019-08-01 00:00:00' and kode_karyawan='KW000152' ;Array
(
[0] => Array
(
[kode_karyawan] => KW000152
[nama_karyawan] => AGUS SUSANTO
[alamat_karyawan] => JALAN KARYA MAKMUR RT05 RW02 KEL KARYA MULYA KEC SEMATANG BORANG PALEMBANG
[telpon_karyawan] => 82280132619
[telpon2_karyawan] => 0
[lokasi_karyawan] => PERTAMINA EP SITE ADERA
[status] => true
[kode_jabatan] => JBT039
[kode_wilayah] => WG0003
[info1] => 0
[info2] => 0
[tanggal_bergabung] => 2016-04-01 00:00:00
[no_ktp] => 1671082408920005
[tgl_ktp] => 2025-02-12 00:00:00
[pendidikan] => 2
[tipe_sim] => 0
[sio] =>
[sertifikat_hse] =>
[status_kerja] => 1
[tgl_kontrak] => 01/11/2025 - 20/04/2026
[alamat2_karyawan] => PENGABUAN
[no_rekening] => 110301006289508
[nama_bank] => 3
[tgl_expkontrak] => 2026-04-20 00:00:00
[asuransi] =>
[kondisi_karyawan] => 0
[divisi_karyawan] =>
[no_npwp] =>
[ptkp] => K/2
[nama_rekening] => AGUS SUSANTO
[tgl_lahir] => 1992-08-24 15:50:47
[no_bpjs] => 0001135319141
[no_bpjs_tk] => 13012274505
[hit_bpjs_tk] => UMP2025
[tambah_bpjs] => 0
[tgl_peserta_bpjstk] => 2013-05-01 00:00:01
[hit_bpjs_ks] => UMK2025
[tgl_resign] => 1900-01-01 00:00:00
[tempat_tgllahir] => PALEMBANG
[jenis_kelamin] => L
[email] => AGUS.SUSANTO78@YAHOO.COM
[no_pkwt] => PW-DP-250700054
[gaji_pokok] => 3681697.00
[uang_makan] => 35000.00
[tunjangan_jabatan] => 0.00
[tunjangan_hadir] => 5000.00
[tunjangan_lain] => 0.00
[lembur_regular] => 42563.00
[over_day] => 85000.00
[over_time] => 0
[uang_transport] => 0.00
[pot_bon_kantor] => 0
[pot_jamsostek] => 122948.00
[pot_lain] => 0
[bonus] => 5
[thr] => 0
[over_time_harian] => 0.00
[tunjangan_hadir_harian] => 0.00
[kompensasi] => 0.00
[tunjangan_pph21] => 0.00
[v_jam_opr] => 0
[premi] => 0
[u_mandah] => 0.00
[v_lembur] => 1
[status_pph21] => ya
[status_bpjs] => ya
[status_tunj_jab] => tdk
[pot_umakan] => 0
[gaji_harian] => 0.00
[hitung_ter] => bulan
)
)
KW000152Array
(
[0] => INSERT INTO "Pegawai".master_gaji(
kode_karyawan, periode_gaji, gaji_pokok, workday_hari, variable_wd,
lembur_nom, overtime_hari, variable_ot, overtime_nom, overday_hari,
variable_od, overday_nom, tunj_tetap, tunj_lain, hari_kerja,
uang_makan, cto, pot_um, pot_lain, pot_jamsos, total_brutto,
total_netto, info1, info2,status,tunj_jabatan,variabel_makan,
vpremi , premi ,u_mandah, kompensasi , pot_pph21 ,tunj_hadir ,
insentif_jabatan , v_jam_opr,jam_opr, v_lembur
)
VALUES ('KW000152', '2019-08-01 00:00:00', '3681697', '21', '1',
'893823', '17.5', '1', '0', '0' ,
'85000','0', '0', '0', '1',
'735000', '0', '0', '0', '122948','5415520',
'5292572', '', '','bk','0','35000',
'0','0','0','0','0','0',
'105000','0','0','1');
[1] => UPDATE "Pegawai".master_karyawan_detail
SET pot_bon_kantor='0',
pot_lain= '0'
WHERE kode_karyawan='KW000152';
[2] => UPDATE "Pegawai".master_absensi
SET work_day='21',
over_time='17.5',
over_day='0',
premi='0',
jam_opr='0', pot_bon='0',
pot_lain='0'
WHERE kode_karyawan='KW000152' and periode='2019-08-01 00:00:00';
)
{"result":"true", "msg":"Data Tersimpan", "status":"Array\n(\n [0] => Data Entry stok opname yang ke 0 Sukses disimpan
\n [1] => Data Entry stok opname yang ke 1 Sukses disimpan
\n [2] => Data Entry stok opname yang ke 2 Sukses disimpan
\n [3] => Data Entry stok opname yang ke 3 Sukses disimpan
\n)\n"}