Array
(
[0] => Array
(
[kode_karyawan] => KW000983
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 924479
)
[1] => Array
(
[kode_karyawan] => KW000857
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 1881976
)
[2] => Array
(
[kode_karyawan] => KW001001
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[3] => Array
(
[kode_karyawan] => KW000959
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[4] => Array
(
[kode_karyawan] => KW001038
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[5] => Array
(
[kode_karyawan] => KW001000
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[6] => Array
(
[kode_karyawan] => KW001016
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[7] => Array
(
[kode_karyawan] => KW001002
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[8] => Array
(
[kode_karyawan] => KW001039
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[9] => Array
(
[kode_karyawan] => KW000953
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[10] => Array
(
[kode_karyawan] => KW001014
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[11] => Array
(
[kode_karyawan] => KW001053
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[12] => Array
(
[kode_karyawan] => KW001068
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[13] => Array
(
[kode_karyawan] => KW000413
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 594308
)
[14] => Array
(
[kode_karyawan] => KW000949
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 1873171
)
[15] => Array
(
[kode_karyawan] => KW000948
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 1873171
)
[16] => Array
(
[kode_karyawan] => KW001005
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 792411
)
[17] => Array
(
[kode_karyawan] => KW000894
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 1881976
)
[18] => Array
(
[kode_karyawan] => KW000946
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 944290
)
[19] => Array
(
[kode_karyawan] => KW001052
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 944290
)
[20] => Array
(
[kode_karyawan] => KW000895
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 944290
)
[21] => Array
(
[kode_karyawan] => KW000952
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 944290
)
[22] => Array
(
[kode_karyawan] => KW000944
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 944290
)
[23] => Array
(
[kode_karyawan] => KW000961
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 944290
)
[24] => Array
(
[kode_karyawan] => KW000945
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 944290
)
[25] => Array
(
[kode_karyawan] => KW000873
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 1873171
)
[26] => Array
(
[kode_karyawan] => KW000897
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 2606151
)
[27] => Array
(
[kode_karyawan] => KW000943
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 1089565
)
[28] => Array
(
[kode_karyawan] => KW000689
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 1598028
)
[29] => Array
(
[kode_karyawan] => KW000862
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 944290
)
[30] => Array
(
[kode_karyawan] => KW000786
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 944290
)
[31] => Array
(
[kode_karyawan] => KW000858
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 1873171
)
[32] => Array
(
[kode_karyawan] => KW000806
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 1598028
)
[33] => Array
(
[kode_karyawan] => KW000855
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 4072111
)
[34] => Array
(
[kode_karyawan] => KW000867
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 2117498
)
[35] => Array
(
[kode_karyawan] => KW001021
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 871652
)
[36] => Array
(
[kode_karyawan] => KW000914
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 871652
)
[37] => Array
(
[kode_karyawan] => KW000835
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 908047
)
[38] => Array
(
[kode_karyawan] => KW000683
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 1498278
)
[39] => Array
(
[kode_karyawan] => KW000815
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 499426
)
[40] => Array
(
[kode_karyawan] => KW000859
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 499426
)
[41] => Array
(
[kode_karyawan] => KW001043
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 635633
)
[42] => Array
(
[kode_karyawan] => KW000747
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 590231
)
[43] => Array
(
[kode_karyawan] => KW000993
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 908047
)
[44] => Array
(
[kode_karyawan] => KW000849
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 590231
)
[45] => Array
(
[kode_karyawan] => KW000999
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 499426
)
[46] => Array
(
[kode_karyawan] => KW000790
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 590231
)
[47] => Array
(
[kode_karyawan] => KW000821
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 590231
)
[48] => Array
(
[kode_karyawan] => KW000848
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 681036
)
[49] => Array
(
[kode_karyawan] => KW000792
[periode] => 2023-09-01 00:00:00
[tahap] => 1
[info1] =>
[info2] =>
[bonus] => 590231
)
)
Array
(
[0] => UPDATE "Pegawai".master_gaji
SET bonus='924479',
total_brutto='8012460',
total_netto='7801712'
WHERE kode_karyawan='KW000983' and date(periode_gaji)='2023-09-01' and info2='1' ;
[1] => UPDATE "Pegawai".master_gaji
SET bonus='1881976',
total_brutto='11793184',
total_netto='11047911'
WHERE kode_karyawan='KW000857' and date(periode_gaji)='2023-09-01' and info2='1' ;
[2] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6434412',
total_netto='6190415'
WHERE kode_karyawan='KW001001' and date(periode_gaji)='2023-09-01' and info2='1' ;
[3] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6903946',
total_netto='6759710'
WHERE kode_karyawan='KW000959' and date(periode_gaji)='2023-09-01' and info2='1' ;
[4] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6903946',
total_netto='6759710'
WHERE kode_karyawan='KW001038' and date(periode_gaji)='2023-09-01' and info2='1' ;
[5] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6843038',
total_netto='6702456'
WHERE kode_karyawan='KW001000' and date(periode_gaji)='2023-09-01' and info2='1' ;
[6] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6843038',
total_netto='6664002'
WHERE kode_karyawan='KW001016' and date(periode_gaji)='2023-09-01' and info2='1' ;
[7] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6903946',
total_netto='6759710'
WHERE kode_karyawan='KW001002' and date(periode_gaji)='2023-09-01' and info2='1' ;
[8] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6310780',
total_netto='6202133'
WHERE kode_karyawan='KW001039' and date(periode_gaji)='2023-09-01' and info2='1' ;
[9] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='7147578',
total_netto='7056223'
WHERE kode_karyawan='KW000953' and date(periode_gaji)='2023-09-01' and info2='1' ;
[10] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='7147578',
total_netto='6988723'
WHERE kode_karyawan='KW001014' and date(periode_gaji)='2023-09-01' and info2='1' ;
[11] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='7086670',
total_netto='6317802'
WHERE kode_karyawan='KW001053' and date(periode_gaji)='2023-09-01' and info2='1' ;
[12] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='7147578',
total_netto='6377223'
WHERE kode_karyawan='KW001068' and date(periode_gaji)='2023-09-01' and info2='1' ;
[13] => UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='7747578',
total_netto='7679568'
WHERE kode_karyawan='KW000413' and date(periode_gaji)='2023-09-01' and info2='1' ;
[14] => UPDATE "Pegawai".master_gaji
SET bonus='1873171',
total_brutto='10986897',
total_netto='10543029'
WHERE kode_karyawan='KW000949' and date(periode_gaji)='2023-09-01' and info2='1' ;
[15] => UPDATE "Pegawai".master_gaji
SET bonus='1873171',
total_brutto='10986897',
total_netto='10543029'
WHERE kode_karyawan='KW000948' and date(periode_gaji)='2023-09-01' and info2='1' ;
[16] => UPDATE "Pegawai".master_gaji
SET bonus='792411',
total_brutto='6316544',
total_netto='6207552'
WHERE kode_karyawan='KW001005' and date(periode_gaji)='2023-09-01' and info2='1' ;
[17] => UPDATE "Pegawai".master_gaji
SET bonus='1881976',
total_brutto='10145650',
total_netto='9896910'
WHERE kode_karyawan='KW000894' and date(periode_gaji)='2023-09-01' and info2='1' ;
[18] => UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8703946',
total_netto='8519210'
WHERE kode_karyawan='KW000946' and date(periode_gaji)='2023-09-01' and info2='1' ;
[19] => UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8810672',
total_netto='8203698'
WHERE kode_karyawan='KW001052' and date(periode_gaji)='2023-09-01' and info2='1' ;
[20] => UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8993328',
total_netto='8684528'
WHERE kode_karyawan='KW000895' and date(periode_gaji)='2023-09-01' and info2='1' ;
[21] => UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8864766',
total_netto='8670380'
WHERE kode_karyawan='KW000952' and date(periode_gaji)='2023-09-01' and info2='1' ;
[22] => UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8775449',
total_netto='8586423'
WHERE kode_karyawan='KW000944' and date(periode_gaji)='2023-09-01' and info2='1' ;
[23] => UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8816951',
total_netto='8657353'
WHERE kode_karyawan='KW000961' and date(periode_gaji)='2023-09-01' and info2='1' ;
[24] => UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8060419',
total_netto='7936794'
WHERE kode_karyawan='KW000945' and date(periode_gaji)='2023-09-01' and info2='1' ;
[25] => UPDATE "Pegawai".master_gaji
SET bonus='1873171',
total_brutto='11359094',
total_netto='10691958'
WHERE kode_karyawan='KW000873' and date(periode_gaji)='2023-09-01' and info2='1' ;
[26] => UPDATE "Pegawai".master_gaji
SET bonus='2606151',
total_brutto='14233706',
total_netto='12981639'
WHERE kode_karyawan='KW000897' and date(periode_gaji)='2023-09-01' and info2='1' ;
[27] => UPDATE "Pegawai".master_gaji
SET bonus='1089565',
total_brutto='9207184',
total_netto='8969753'
WHERE kode_karyawan='KW000943' and date(periode_gaji)='2023-09-01' and info2='1' ;
[28] => UPDATE "Pegawai".master_gaji
SET bonus='1598028',
total_brutto='11296964',
total_netto='10843510'
WHERE kode_karyawan='KW000689' and date(periode_gaji)='2023-09-01' and info2='1' ;
[29] => UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='9621658',
total_netto='9199760'
WHERE kode_karyawan='KW000862' and date(periode_gaji)='2023-09-01' and info2='1' ;
[30] => UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='10237446',
total_netto='9704706'
WHERE kode_karyawan='KW000786' and date(periode_gaji)='2023-09-01' and info2='1' ;
[31] => UPDATE "Pegawai".master_gaji
SET bonus='1873171',
total_brutto='11194700',
total_netto='10719662'
WHERE kode_karyawan='KW000858' and date(periode_gaji)='2023-09-01' and info2='1' ;
[32] => UPDATE "Pegawai".master_gaji
SET bonus='1598028',
total_brutto='11174910',
total_netto='10608426'
WHERE kode_karyawan='KW000806' and date(periode_gaji)='2023-09-01' and info2='1' ;
[33] => UPDATE "Pegawai".master_gaji
SET bonus='4072111',
total_brutto='20974222',
total_netto='17640889'
WHERE kode_karyawan='KW000855' and date(periode_gaji)='2023-09-01' and info2='1' ;
[34] => UPDATE "Pegawai".master_gaji
SET bonus='2117498',
total_brutto='12410360',
total_netto='11621496'
WHERE kode_karyawan='KW000867' and date(periode_gaji)='2023-09-01' and info2='1' ;
[35] => UPDATE "Pegawai".master_gaji
SET bonus='871652',
total_brutto='5281860',
total_netto='4056975'
WHERE kode_karyawan='KW001021' and date(periode_gaji)='2023-09-01' and info2='1' ;
[36] => UPDATE "Pegawai".master_gaji
SET bonus='871652',
total_brutto='8663252',
total_netto='8413456'
WHERE kode_karyawan='KW000914' and date(periode_gaji)='2023-09-01' and info2='1' ;
[37] => UPDATE "Pegawai".master_gaji
SET bonus='908047',
total_brutto='7956094',
total_netto='7820789'
WHERE kode_karyawan='KW000835' and date(periode_gaji)='2023-09-01' and info2='1' ;
[38] => UPDATE "Pegawai".master_gaji
SET bonus='1498278',
total_brutto='12499756',
total_netto='12499756'
WHERE kode_karyawan='KW000683' and date(periode_gaji)='2023-09-01' and info2='1' ;
[39] => UPDATE "Pegawai".master_gaji
SET bonus='499426',
total_brutto='6006852',
total_netto='5916440'
WHERE kode_karyawan='KW000815' and date(periode_gaji)='2023-09-01' and info2='1' ;
[40] => UPDATE "Pegawai".master_gaji
SET bonus='499426',
total_brutto='4767408',
total_netto='4751364'
WHERE kode_karyawan='KW000859' and date(periode_gaji)='2023-09-01' and info2='1' ;
[41] => UPDATE "Pegawai".master_gaji
SET bonus='635633',
total_brutto='7771266',
total_netto='7468324'
WHERE kode_karyawan='KW001043' and date(periode_gaji)='2023-09-01' and info2='1' ;
[42] => UPDATE "Pegawai".master_gaji
SET bonus='590231',
total_brutto='7191222',
total_netto='7051322'
WHERE kode_karyawan='KW000747' and date(periode_gaji)='2023-09-01' and info2='1' ;
[43] => UPDATE "Pegawai".master_gaji
SET bonus='908047',
total_brutto='7176094',
total_netto='7015528'
WHERE kode_karyawan='KW000993' and date(periode_gaji)='2023-09-01' and info2='1' ;
[44] => UPDATE "Pegawai".master_gaji
SET bonus='590231',
total_brutto='8222889',
total_netto='8067016'
WHERE kode_karyawan='KW000849' and date(periode_gaji)='2023-09-01' and info2='1' ;
[45] => UPDATE "Pegawai".master_gaji
SET bonus='499426',
total_brutto='7560452',
total_netto='7466824'
WHERE kode_karyawan='KW000999' and date(periode_gaji)='2023-09-01' and info2='1' ;
[46] => UPDATE "Pegawai".master_gaji
SET bonus='590231',
total_brutto='8773120',
total_netto='7503959'
WHERE kode_karyawan='KW000790' and date(periode_gaji)='2023-09-01' and info2='1' ;
[47] => UPDATE "Pegawai".master_gaji
SET bonus='590231',
total_brutto='8473422',
total_netto='8302517'
WHERE kode_karyawan='KW000821' and date(periode_gaji)='2023-09-01' and info2='1' ;
[48] => UPDATE "Pegawai".master_gaji
SET bonus='681036',
total_brutto='8474444',
total_netto='8303478'
WHERE kode_karyawan='KW000848' and date(periode_gaji)='2023-09-01' and info2='1' ;
[49] => UPDATE "Pegawai".master_gaji
SET bonus='590231',
total_brutto='8338834',
total_netto='8176004'
WHERE kode_karyawan='KW000792' and date(periode_gaji)='2023-09-01' and info2='1' ;
)
UPDATE "Pegawai".master_gaji
SET bonus='924479',
total_brutto='8012460',
total_netto='7801712'
WHERE kode_karyawan='KW000983' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='1881976',
total_brutto='11793184',
total_netto='11047911'
WHERE kode_karyawan='KW000857' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6434412',
total_netto='6190415'
WHERE kode_karyawan='KW001001' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6903946',
total_netto='6759710'
WHERE kode_karyawan='KW000959' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6903946',
total_netto='6759710'
WHERE kode_karyawan='KW001038' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6843038',
total_netto='6702456'
WHERE kode_karyawan='KW001000' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6843038',
total_netto='6664002'
WHERE kode_karyawan='KW001016' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6903946',
total_netto='6759710'
WHERE kode_karyawan='KW001002' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='6310780',
total_netto='6202133'
WHERE kode_karyawan='KW001039' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='7147578',
total_netto='7056223'
WHERE kode_karyawan='KW000953' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='7147578',
total_netto='6988723'
WHERE kode_karyawan='KW001014' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='7086670',
total_netto='6317802'
WHERE kode_karyawan='KW001053' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='7147578',
total_netto='6377223'
WHERE kode_karyawan='KW001068' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='594308',
total_brutto='7747578',
total_netto='7679568'
WHERE kode_karyawan='KW000413' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='1873171',
total_brutto='10986897',
total_netto='10543029'
WHERE kode_karyawan='KW000949' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='1873171',
total_brutto='10986897',
total_netto='10543029'
WHERE kode_karyawan='KW000948' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='792411',
total_brutto='6316544',
total_netto='6207552'
WHERE kode_karyawan='KW001005' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='1881976',
total_brutto='10145650',
total_netto='9896910'
WHERE kode_karyawan='KW000894' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8703946',
total_netto='8519210'
WHERE kode_karyawan='KW000946' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8810672',
total_netto='8203698'
WHERE kode_karyawan='KW001052' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8993328',
total_netto='8684528'
WHERE kode_karyawan='KW000895' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8864766',
total_netto='8670380'
WHERE kode_karyawan='KW000952' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8775449',
total_netto='8586423'
WHERE kode_karyawan='KW000944' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8816951',
total_netto='8657353'
WHERE kode_karyawan='KW000961' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='8060419',
total_netto='7936794'
WHERE kode_karyawan='KW000945' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='1873171',
total_brutto='11359094',
total_netto='10691958'
WHERE kode_karyawan='KW000873' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='2606151',
total_brutto='14233706',
total_netto='12981639'
WHERE kode_karyawan='KW000897' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='1089565',
total_brutto='9207184',
total_netto='8969753'
WHERE kode_karyawan='KW000943' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='1598028',
total_brutto='11296964',
total_netto='10843510'
WHERE kode_karyawan='KW000689' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='9621658',
total_netto='9199760'
WHERE kode_karyawan='KW000862' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='944290',
total_brutto='10237446',
total_netto='9704706'
WHERE kode_karyawan='KW000786' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='1873171',
total_brutto='11194700',
total_netto='10719662'
WHERE kode_karyawan='KW000858' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='1598028',
total_brutto='11174910',
total_netto='10608426'
WHERE kode_karyawan='KW000806' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='4072111',
total_brutto='20974222',
total_netto='17640889'
WHERE kode_karyawan='KW000855' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='2117498',
total_brutto='12410360',
total_netto='11621496'
WHERE kode_karyawan='KW000867' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='871652',
total_brutto='5281860',
total_netto='4056975'
WHERE kode_karyawan='KW001021' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='871652',
total_brutto='8663252',
total_netto='8413456'
WHERE kode_karyawan='KW000914' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='908047',
total_brutto='7956094',
total_netto='7820789'
WHERE kode_karyawan='KW000835' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='1498278',
total_brutto='12499756',
total_netto='12499756'
WHERE kode_karyawan='KW000683' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='499426',
total_brutto='6006852',
total_netto='5916440'
WHERE kode_karyawan='KW000815' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='499426',
total_brutto='4767408',
total_netto='4751364'
WHERE kode_karyawan='KW000859' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='635633',
total_brutto='7771266',
total_netto='7468324'
WHERE kode_karyawan='KW001043' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='590231',
total_brutto='7191222',
total_netto='7051322'
WHERE kode_karyawan='KW000747' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='908047',
total_brutto='7176094',
total_netto='7015528'
WHERE kode_karyawan='KW000993' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='590231',
total_brutto='8222889',
total_netto='8067016'
WHERE kode_karyawan='KW000849' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='499426',
total_brutto='7560452',
total_netto='7466824'
WHERE kode_karyawan='KW000999' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='590231',
total_brutto='8773120',
total_netto='7503959'
WHERE kode_karyawan='KW000790' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='590231',
total_brutto='8473422',
total_netto='8302517'
WHERE kode_karyawan='KW000821' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='681036',
total_brutto='8474444',
total_netto='8303478'
WHERE kode_karyawan='KW000848' and date(periode_gaji)='2023-09-01' and info2='1' ;
UPDATE "Pegawai".master_gaji
SET bonus='590231',
total_brutto='8338834',
total_netto='8176004'
WHERE kode_karyawan='KW000792' and date(periode_gaji)='2023-09-01' and info2='1' ;