Array
(
[0] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='9992202',
total_gaji='10194081.57',
bonus='2135081',
prosen_ter='1.5',
income_tax='152911',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000028' and periode='2024-05-01 00:00:00'
and info2='1' ;
[1] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='6333804',
total_gaji='6517246.27',
bonus='790771',
prosen_ter='0.5',
income_tax='32586',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000074' and periode='2024-05-01 00:00:00'
and info2='1' ;
[2] => INSERT INTO "Pegawai".log_transaksi(
kode_pegawai, tanggal, no_faktur, kondisi, info1, info2, info3)
VALUES ('SBU00001' , '2025-12-08 17:48:11', '', '108', '216.73.216.111', ' ubah jumlah pph dari 0 ke 32586', '');
[3] => UPDATE "Pegawai".master_gaji
SET
pot_lain='0', pot_pph21='32586', total_netto='4679733'
WHERE date(periode_gaji)='2024-05-01' and kode_karyawan='KW000074';
[4] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='11423346',
total_gaji='11648174',
bonus='6853346',
prosen_ter='3',
income_tax='349445',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000088' and periode='2024-05-01 00:00:00'
and info2='1' ;
[5] => INSERT INTO "Pegawai".log_transaksi(
kode_pegawai, tanggal, no_faktur, kondisi, info1, info2, info3)
VALUES ('SBU00001' , '2025-12-08 17:48:11', '', '108', '216.73.216.111', ' ubah jumlah pph dari 0 ke 349445', '');
[6] => UPDATE "Pegawai".master_gaji
SET
pot_lain='0', pot_pph21='349445', total_netto='10922825'
WHERE date(periode_gaji)='2024-05-01' and kode_karyawan='KW000088';
[7] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='13682707',
total_gaji='13948977',
bonus='7907707',
prosen_ter='6',
income_tax='836939',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000169' and periode='2024-05-01 00:00:00'
and info2='1' ;
[8] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='8323853',
total_gaji='8545417',
bonus='3953853',
prosen_ter='1.5',
income_tax='128181',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000655' and periode='2024-05-01 00:00:00'
and info2='1' ;
[9] => INSERT INTO "Pegawai".log_transaksi(
kode_pegawai, tanggal, no_faktur, kondisi, info1, info2, info3)
VALUES ('SBU00001' , '2025-12-08 17:48:11', '', '108', '216.73.216.111', ' ubah jumlah pph dari 0 ke 128181', '');
[10] => UPDATE "Pegawai".master_gaji
SET
pot_lain='0', pot_pph21='128181', total_netto='8049396'
WHERE date(periode_gaji)='2024-05-01' and kode_karyawan='KW000655';
[11] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='5521156',
total_gaji='5739558',
bonus='1186156',
prosen_ter='0',
income_tax='0',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000677' and periode='2024-05-01 00:00:00'
and info2='1' ;
[12] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='5304361',
total_gaji='5522865',
bonus='1054361',
prosen_ter='0',
income_tax='0',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000708' and periode='2024-05-01 00:00:00'
and info2='1' ;
[13] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='13997707',
total_gaji='14226411',
bonus='7907707',
prosen_ter='5',
income_tax='711321',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000733' and periode='2024-05-01 00:00:00'
and info2='1' ;
[14] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='6386511',
total_gaji='6605015',
bonus='1054361',
prosen_ter='0.5',
income_tax='33025',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000763' and periode='2024-05-01 00:00:00'
and info2='1' ;
[15] => INSERT INTO "Pegawai".log_transaksi(
kode_pegawai, tanggal, no_faktur, kondisi, info1, info2, info3)
VALUES ('SBU00001' , '2025-12-08 17:48:11', '', '108', '216.73.216.111', ' ubah jumlah pph dari 0 ke 33025', '');
[16] => UPDATE "Pegawai".master_gaji
SET
pot_lain='0', pot_pph21='33025', total_netto='6211710'
WHERE date(periode_gaji)='2024-05-01' and kode_karyawan='KW000763';
[17] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='10164985',
total_gaji='10384631.4',
bonus='5798985',
prosen_ter='2.5',
income_tax='259616',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000765' and periode='2024-05-01 00:00:00'
and info2='1' ;
[18] => INSERT INTO "Pegawai".log_transaksi(
kode_pegawai, tanggal, no_faktur, kondisi, info1, info2, info3)
VALUES ('SBU00001' , '2025-12-08 17:48:11', '', '108', '216.73.216.111', ' ubah jumlah pph dari 0 ke 259616', '');
[19] => UPDATE "Pegawai".master_gaji
SET
pot_lain='0', pot_pph21='259616', total_netto='9761913'
WHERE date(periode_gaji)='2024-05-01' and kode_karyawan='KW000765';
[20] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='8801541',
total_gaji='9064281',
bonus='1581541',
prosen_ter='1',
income_tax='90643',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000825' and periode='2024-05-01 00:00:00'
and info2='1' ;
[21] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='16725658',
total_gaji='17011608',
bonus='9225658',
prosen_ter='8',
income_tax='1360929',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000832' and periode='2024-05-01 00:00:00'
and info2='1' ;
[22] => INSERT INTO "Pegawai".log_transaksi(
kode_pegawai, tanggal, no_faktur, kondisi, info1, info2, info3)
VALUES ('SBU00001' , '2025-12-08 17:48:11', '', '108', '216.73.216.111', ' ubah jumlah pph dari 1190813 ke 1360929', '');
[23] => UPDATE "Pegawai".master_gaji
SET
pot_lain='0', pot_pph21='1360929', total_netto='15067579'
WHERE date(periode_gaji)='2024-05-01' and kode_karyawan='KW000832';
[24] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='9965081',
total_gaji='10255001',
bonus='2135081',
prosen_ter='1.5',
income_tax='153825',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000844' and periode='2024-05-01 00:00:00'
and info2='1' ;
[25] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='5154361',
total_gaji='5374701',
bonus='1054361',
prosen_ter='0',
income_tax='0',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000850' and periode='2024-05-01 00:00:00'
and info2='1' ;
[26] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='18150877',
total_gaji='18392017',
bonus='12300877',
prosen_ter='7',
income_tax='1287441',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000910' and periode='2024-05-01 00:00:00'
and info2='1' ;
[27] => INSERT INTO "Pegawai".log_transaksi(
kode_pegawai, tanggal, no_faktur, kondisi, info1, info2, info3)
VALUES ('SBU00001' , '2025-12-08 17:48:11', '', '108', '216.73.216.111', ' ubah jumlah pph dari 0 ke 1287441', '');
[28] => UPDATE "Pegawai".master_gaji
SET
pot_lain='0', pot_pph21='1287441', total_netto='16694836'
WHERE date(periode_gaji)='2024-05-01' and kode_karyawan='KW000910';
[29] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='9610067',
total_gaji='9829409.08',
bonus='5798985',
prosen_ter='2',
income_tax='196588',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000911' and periode='2024-05-01 00:00:00'
and info2='1' ;
[30] => INSERT INTO "Pegawai".log_transaksi(
kode_pegawai, tanggal, no_faktur, kondisi, info1, info2, info3)
VALUES ('SBU00001' , '2025-12-08 17:48:11', '', '108', '216.73.216.111', ' ubah jumlah pph dari 0 ke 196588', '');
[31] => UPDATE "Pegawai".master_gaji
SET
pot_lain='0', pot_pph21='196588', total_netto='9270471'
WHERE date(periode_gaji)='2024-05-01' and kode_karyawan='KW000911';
[32] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='10884073',
total_gaji='11104311',
bonus='7029073',
prosen_ter='3.5',
income_tax='388651',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000970' and periode='2024-05-01 00:00:00'
and info2='1' ;
[33] => INSERT INTO "Pegawai".log_transaksi(
kode_pegawai, tanggal, no_faktur, kondisi, info1, info2, info3)
VALUES ('SBU00001' , '2025-12-08 17:48:11', '', '108', '216.73.216.111', ' ubah jumlah pph dari 0 ke 388651', '');
[34] => UPDATE "Pegawai".master_gaji
SET
pot_lain='0', pot_pph21='388651', total_netto='10351096'
WHERE date(periode_gaji)='2024-05-01' and kode_karyawan='KW000970';
[35] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='7566673',
total_gaji='7787217',
bonus='3426673',
prosen_ter='1.5',
income_tax='116808',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW000995' and periode='2024-05-01 00:00:00'
and info2='1' ;
[36] => INSERT INTO "Pegawai".log_transaksi(
kode_pegawai, tanggal, no_faktur, kondisi, info1, info2, info3)
VALUES ('SBU00001' , '2025-12-08 17:48:11', '', '108', '216.73.216.111', ' ubah jumlah pph dari 0 ke 116808', '');
[37] => UPDATE "Pegawai".master_gaji
SET
pot_lain='0', pot_pph21='116808', total_netto='7305089'
WHERE date(periode_gaji)='2024-05-01' and kode_karyawan='KW000995';
[38] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='4996156',
total_gaji='5211600',
bonus='1186156',
prosen_ter='0',
income_tax='0',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW001028' and periode='2024-05-01 00:00:00'
and info2='1' ;
[39] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='13355439',
total_gaji='13645359',
bonus='6150439',
prosen_ter='5',
income_tax='682268',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW001051' and periode='2024-05-01 00:00:00'
and info2='1' ;
[40] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='4097180',
total_gaji='4311604',
bonus='527180',
prosen_ter='0',
income_tax='0',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW001069' and periode='2024-05-01 00:00:00'
and info2='1' ;
[41] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='5739026',
total_gaji='5955490',
bonus='369026',
prosen_ter='0',
income_tax='0',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW001082' and periode='2024-05-01 00:00:00'
and info2='1' ;
[42] => UPDATE "Pegawai".master_karyawan_pph21_v2
SET
gaji='4109026',
total_gaji='4325490',
bonus='369026',
prosen_ter='0',
income_tax='0',
last_edited='08/12/2025 17:48:11 - henry'
where kode_karyawan='KW001100' and periode='2024-05-01 00:00:00'
and info2='1' ;
)
{"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 [4] => Data Entry stok opname yang ke 4 Sukses disimpan
\n [5] => Data Entry stok opname yang ke 5 Sukses disimpan
\n [6] => Data Entry stok opname yang ke 6 Sukses disimpan
\n [7] => Data Entry stok opname yang ke 7 Sukses disimpan
\n [8] => Data Entry stok opname yang ke 8 Sukses disimpan
\n [9] => Data Entry stok opname yang ke 9 Sukses disimpan
\n [10] => Data Entry stok opname yang ke 10 Sukses disimpan
\n [11] => Data Entry stok opname yang ke 11 Sukses disimpan
\n [12] => Data Entry stok opname yang ke 12 Sukses disimpan
\n [13] => Data Entry stok opname yang ke 13 Sukses disimpan
\n [14] => Data Entry stok opname yang ke 14 Sukses disimpan
\n [15] => Data Entry stok opname yang ke 15 Sukses disimpan
\n [16] => Data Entry stok opname yang ke 16 Sukses disimpan
\n [17] => Data Entry stok opname yang ke 17 Sukses disimpan
\n [18] => Data Entry stok opname yang ke 18 Sukses disimpan
\n [19] => Data Entry stok opname yang ke 19 Sukses disimpan
\n [20] => Data Entry stok opname yang ke 20 Sukses disimpan
\n [21] => Data Entry stok opname yang ke 21 Sukses disimpan
\n [22] => Data Entry stok opname yang ke 22 Sukses disimpan
\n [23] => Data Entry stok opname yang ke 23 Sukses disimpan
\n [24] => Data Entry stok opname yang ke 24 Sukses disimpan
\n [25] => Data Entry stok opname yang ke 25 Sukses disimpan
\n [26] => Data Entry stok opname yang ke 26 Sukses disimpan
\n [27] => Data Entry stok opname yang ke 27 Sukses disimpan
\n [28] => Data Entry stok opname yang ke 28 Sukses disimpan
\n [29] => Data Entry stok opname yang ke 29 Sukses disimpan
\n [30] => Data Entry stok opname yang ke 30 Sukses disimpan
\n [31] => Data Entry stok opname yang ke 31 Sukses disimpan
\n [32] => Data Entry stok opname yang ke 32 Sukses disimpan
\n [33] => Data Entry stok opname yang ke 33 Sukses disimpan
\n [34] => Data Entry stok opname yang ke 34 Sukses disimpan
\n [35] => Data Entry stok opname yang ke 35 Sukses disimpan
\n [36] => Data Entry stok opname yang ke 36 Sukses disimpan
\n [37] => Data Entry stok opname yang ke 37 Sukses disimpan
\n [38] => Data Entry stok opname yang ke 38 Sukses disimpan
\n [39] => Data Entry stok opname yang ke 39 Sukses disimpan
\n [40] => Data Entry stok opname yang ke 40 Sukses disimpan
\n [41] => Data Entry stok opname yang ke 41 Sukses disimpan
\n [42] => Data Entry stok opname yang ke 42 Sukses disimpan
\n)\n"}