INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-11-15 ','08:34:43'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-15','116','0','-250100000','116','0','-250100000'); DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-15'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-14'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-14'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-14' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-14'; DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-14'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-14'; DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-14'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10'; UPDATE tt_barang_saldo SET tanggal= '2025-11-15' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-14' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251115-0001','D','2025-11-15','08:34:51','','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251115-0001','D','2025-11-15','08:34:51','BCA','SALDO AWAL','SALDO AWAL','0','1422351657','1422351657'); UPDATE tp_system SET tgl_system='2025-11-15'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-11-15 ','08:35:14'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-11-15 ','08:48:40'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2025-11-15 ','08:50:36'); INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('adminpusat','2025-11-15 08:51:25'); CREATE TABLE th_20251115_085125 SELECT * FROM tt_barang_stock; CREATE TABLE th_20251115_085125_lebih SELECT * FROM tt_barang_stock_lebih; DELETE FROM tt_barang_stock; DELETE FROM tt_barang_stock_lebih; DELETE FROM tt_barang_stock WHERE stock_fisik*1=0; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='BTKLMT' AND stock_on_hand*1 =1 AND harga_jual*1 > 0; UPDATE tt_barang_stock SET tgl_taking= '2025-11-15',jam_taking= '08:51:56',input_by='adminpusat'; DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-53-0' AND kode_barcode='00022992'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-53-0','00022992','2025-11-15',' 08:52:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-75-0' AND kode_barcode='00021503'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-75-0','00021503','2025-11-15',' 08:52:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-64-0' AND kode_barcode='00023003'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-64-0','00023003','2025-11-15',' 08:52:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-63-0' AND kode_barcode='00023002'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-63-0','00023002','2025-11-15',' 08:52:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WFXC-116-0' AND kode_barcode='00016192'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WFXC-116-0','00016192','2025-11-15',' 08:53:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-10-0' AND kode_barcode='00022949'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-10-0','00022949','2025-11-15',' 08:53:21','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XEBE-87-0' AND kode_barcode='00020316'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XEBE-87-0','00020316','2025-11-15',' 08:53:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-133-0' AND kode_barcode='00019701'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-133-0','00019701','2025-11-15',' 08:53:42','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YAXF-11-0' AND kode_barcode='00022635'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YAXF-11-0','00022635','2025-11-15',' 08:53:52','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-93-0' AND kode_barcode='00021521'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-93-0','00021521','2025-11-15',' 08:54:00','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-81-0' AND kode_barcode='00013393'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-81-0','00013393','2025-11-15',' 08:54:06','1','adminpusat'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008985','X-00008985','GL CAP HOLO 16CM KKT PER SHB','GR','---','MDGL','BELI','BELI001','4863500','2025-11-15','5.600','1','sales','2025-11-15 08:54:08'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGL'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGL','X-00008985','X-00008985'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251115-0001','FJ-250309-0004','2402','1','BELI','BELI001','MDGL', 'X-00008985', 'GL CAP HOLO 16CM KKT PER SHB','5.600','5.600','100.00','4074000','4863500','868482','1','4863500','4863500','MULUS'); INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-11-15','BELI','BELI001','MDGL','MDGL','100.00','5.600','5.600','1','5.600','5.600','1'); INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-251115-0001','2025-11-15','2025-11-15','08:54:08','2402','---','5.600','4863500','4863500','4863500','4863500','4863500','sales','2025-11-15 08:54:08','FB-251115-0001','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251115-0001','INAYAH','KARANG TEMBOK G1/18','','','','sales','2025-11-15 08:54:08'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-15' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-251115-0002','K','2025-11-15','08:54:08','sales','PEMBELIAN UMUM','FB-251115-0001','212272829','4863500','207409329','OPEN'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WIAE-57-0' AND kode_barcode='00017562'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WIAE-57-0','00017562','2025-11-15',' 08:54:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBAG-97-0' AND kode_barcode='00014250'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBAG-97-0','00014250','2025-11-15',' 08:54:18','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XGXC-109-0' AND kode_barcode='00020503'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XGXC-109-0','00020503','2025-11-15',' 08:54:27','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBAG-96-0' AND kode_barcode='00014249'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBAG-96-0','00014249','2025-11-15',' 08:54:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VKCX-24-0' AND kode_barcode='00012483'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VKCX-24-0','00012483','2025-11-15',' 08:54:49','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-89-0' AND kode_barcode='00021517'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-89-0','00021517','2025-11-15',' 08:54:57','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBBB-75-0' AND kode_barcode='00014331'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBBB-75-0','00014331','2025-11-15',' 08:55:05','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-65-0' AND kode_barcode='00013377'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-65-0','00013377','2025-11-15',' 08:55:10','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-63-0' AND kode_barcode='00013375'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-63-0','00013375','2025-11-15',' 08:55:18','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-64-0' AND kode_barcode='00013376'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-64-0','00013376','2025-11-15',' 08:55:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-80-0' AND kode_barcode='00013392'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-80-0','00013392','2025-11-15',' 08:55:34','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-62-0' AND kode_barcode='00013374'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-62-0','00013374','2025-11-15',' 08:55:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-102-0' AND kode_barcode='00024385'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-102-0','00024385','2025-11-15',' 08:56:02','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XJAE-126-0' AND kode_barcode='00021165'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XJAE-126-0','00021165','2025-11-15',' 08:56:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-83-0' AND kode_barcode='00025805'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-83-0','00025805','2025-11-15',' 08:56:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-41-0' AND kode_barcode='00026128'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-41-0','00026128','2025-11-15',' 08:56:34','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBBB-90-0' AND kode_barcode='00014346'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBBB-90-0','00014346','2025-11-15',' 08:56:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDAD-158-0' AND kode_barcode='00001779'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDAD-158-0','00001779','2025-11-15',' 08:57:02','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBAC-2-0' AND kode_barcode='00014151'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBAC-2-0','00014151','2025-11-15',' 08:57:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UJAE-77-0' AND kode_barcode='00005150'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UJAE-77-0','00005150','2025-11-15',' 08:57:20','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UJAE-80-0' AND kode_barcode='00005153'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UJAE-80-0','00005153','2025-11-15',' 08:57:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WJXC-6-0' AND kode_barcode='00017726'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WJXC-6-0','00017726','2025-11-15',' 08:57:35','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UJAE-79-0' AND kode_barcode='00005152'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UJAE-79-0','00005152','2025-11-15',' 08:57:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WDXC-47-0' AND kode_barcode='00015283'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WDXC-47-0','00015283','2025-11-15',' 08:57:54','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XABD-55-0' AND kode_barcode='00018614'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XABD-55-0','00018614','2025-11-15',' 08:57:59','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-84-0' AND kode_barcode='00025806'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-84-0','00025806','2025-11-15',' 08:58:07','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XAXI-26-0' AND kode_barcode='00018314'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XAXI-26-0','00018314','2025-11-15',' 08:58:14','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XAXI-25-0' AND kode_barcode='00018313'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XAXI-25-0','00018313','2025-11-15',' 08:58:28','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XEBE-85-0' AND kode_barcode='00020314'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XEBE-85-0','00020314','2025-11-15',' 08:58:34','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-69-0' AND kode_barcode='00025791'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-69-0','00025791','2025-11-15',' 08:58:38','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XEBE-92-0' AND kode_barcode='00020321'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XEBE-92-0','00020321','2025-11-15',' 08:58:43','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-78-0' AND kode_barcode='00025800'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-78-0','00025800','2025-11-15',' 08:58:52','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-79-0' AND kode_barcode='00025801'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-79-0','00025801','2025-11-15',' 08:58:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-72-0' AND kode_barcode='00025794'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-72-0','00025794','2025-11-15',' 08:59:04','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-71-0' AND kode_barcode='00025793'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-71-0','00025793','2025-11-15',' 08:59:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XEBE-89-0' AND kode_barcode='00020318'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XEBE-89-0','00020318','2025-11-15',' 08:59:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XEBE-88-0' AND kode_barcode='00020317'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XEBE-88-0','00020317','2025-11-15',' 08:59:17','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-33-0' AND kode_barcode='00013345'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-33-0','00013345','2025-11-15',' 08:59:21','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-43-0' AND kode_barcode='00026130'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-43-0','00026130','2025-11-15',' 08:59:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-8-0' AND kode_barcode='00013320'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-8-0','00013320','2025-11-15',' 08:59:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBBD-106-0' AND kode_barcode='00014493'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBBD-106-0','00014493','2025-11-15',' 08:59:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VLAX-90-0' AND kode_barcode='00012721'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VLAX-90-0','00012721','2025-11-15',' 08:59:42','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDBB-36-0' AND kode_barcode='00002231'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDBB-36-0','00002231','2025-11-15',' 08:59:49','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJAH-77-0' AND kode_barcode='00026308'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJAH-77-0','00026308','2025-11-15',' 09:00:00','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XFAI-4-0' AND kode_barcode='00020337'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XFAI-4-0','00020337','2025-11-15',' 09:01:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-169-0' AND kode_barcode='00025251'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-169-0','00025251','2025-11-15',' 09:01:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-12-0' AND kode_barcode='00013324'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-12-0','00013324','2025-11-15',' 09:01:16','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-31-0' AND kode_barcode='00022970'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-31-0','00022970','2025-11-15',' 09:01:22','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCBG-129-0' AND kode_barcode='00014935'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCBG-129-0','00014935','2025-11-15',' 09:01:26','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-39-0' AND kode_barcode='00026126'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-39-0','00026126','2025-11-15',' 09:01:34','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-26-0' AND kode_barcode='00022965'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-26-0','00022965','2025-11-15',' 09:01:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXD-55-0' AND kode_barcode='00021408'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXD-55-0','00021408','2025-11-15',' 09:01:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-23-0' AND kode_barcode='00022962'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-23-0','00022962','2025-11-15',' 09:01:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XGXC-101-0' AND kode_barcode='00020495'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XGXC-101-0','00020495','2025-11-15',' 09:02:04','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-32-0' AND kode_barcode='00022971'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-32-0','00022971','2025-11-15',' 09:02:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-86-0' AND kode_barcode='00025808'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-86-0','00025808','2025-11-15',' 09:02:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-48-0' AND kode_barcode='00024331'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-48-0','00024331','2025-11-15',' 09:02:17','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XABD-58-0' AND kode_barcode='00018617'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XABD-58-0','00018617','2025-11-15',' 09:02:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XEBE-91-0' AND kode_barcode='00020320'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XEBE-91-0','00020320','2025-11-15',' 09:02:26','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WHAE-86-0' AND kode_barcode='00017313'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WHAE-86-0','00017313','2025-11-15',' 09:02:35','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XJAE-127-0' AND kode_barcode='00021166'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XJAE-127-0','00021166','2025-11-15',' 09:02:37','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WIAE-54-0' AND kode_barcode='00017559'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WIAE-54-0','00017559','2025-11-15',' 09:02:42','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VLAX-88-0' AND kode_barcode='00012719'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VLAX-88-0','00012719','2025-11-15',' 09:02:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-5-0' AND kode_barcode='00013317'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-5-0','00013317','2025-11-15',' 09:03:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-3-0' AND kode_barcode='00013315'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-3-0','00013315','2025-11-15',' 09:03:14','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-4-0' AND kode_barcode='00013316'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-4-0','00013316','2025-11-15',' 09:03:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-30-0' AND kode_barcode='00013342'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-30-0','00013342','2025-11-15',' 09:03:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-35-0' AND kode_barcode='00013347'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-35-0','00013347','2025-11-15',' 09:03:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XIXE-78-0' AND kode_barcode='00020933'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XIXE-78-0','00020933','2025-11-15',' 09:03:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXE-154-0' AND kode_barcode='00024982'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXE-154-0','00024982','2025-11-15',' 09:03:50','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-73-0' AND kode_barcode='00025795'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-73-0','00025795','2025-11-15',' 09:03:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-75-0' AND kode_barcode='00025797'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-75-0','00025797','2025-11-15',' 09:04:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-80-0' AND kode_barcode='00025802'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-80-0','00025802','2025-11-15',' 09:04:07','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VLAX-89-0' AND kode_barcode='00012720'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VLAX-89-0','00012720','2025-11-15',' 09:04:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-68-0' AND kode_barcode='00025790'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-68-0','00025790','2025-11-15',' 09:04:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-67-0' AND kode_barcode='00025789'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-67-0','00025789','2025-11-15',' 09:04:17','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-65-0' AND kode_barcode='00021493'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-65-0','00021493','2025-11-15',' 09:04:32','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-72-0' AND kode_barcode='00021500'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-72-0','00021500','2025-11-15',' 09:04:35','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-71-0' AND kode_barcode='00021499'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-71-0','00021499','2025-11-15',' 09:04:47','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-48-0' AND kode_barcode='00022987'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-48-0','00022987','2025-11-15',' 09:04:54','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XACA-226-0' AND kode_barcode='00018926'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XACA-226-0','00018926','2025-11-15',' 09:05:00','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-80-0' AND kode_barcode='00023019'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-80-0','00023019','2025-11-15',' 09:05:20','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-81-0' AND kode_barcode='00023020'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-81-0','00023020','2025-11-15',' 09:05:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJAH-80-0' AND kode_barcode='00026311'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJAH-80-0','00026311','2025-11-15',' 09:05:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-90-0' AND kode_barcode='00021518'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-90-0','00021518','2025-11-15',' 09:05:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WIAH-12-0' AND kode_barcode='00017716'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WIAH-12-0','00017716','2025-11-15',' 09:05:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXD-75-0' AND kode_barcode='00021428'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXD-75-0','00021428','2025-11-15',' 09:05:55','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCAD-73-0' AND kode_barcode='00024233'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCAD-73-0','00024233','2025-11-15',' 09:05:59','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WFXC-111-0' AND kode_barcode='00016187'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WFXC-111-0','00016187','2025-11-15',' 09:06:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-49-0' AND kode_barcode='00022988'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-49-0','00022988','2025-11-15',' 09:06:07','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WGAH-134-0' AND kode_barcode='00016350'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WGAH-134-0','00016350','2025-11-15',' 09:06:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-99-0' AND kode_barcode='00024382'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-99-0','00024382','2025-11-15',' 09:06:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WLAE-45-0' AND kode_barcode='00018187'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WLAE-45-0','00018187','2025-11-15',' 09:06:20','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-74-0' AND kode_barcode='00023013'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-74-0','00023013','2025-11-15',' 09:06:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XABD-66-0' AND kode_barcode='00018625'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XABD-66-0','00018625','2025-11-15',' 09:06:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WJXC-7-0' AND kode_barcode='00017727'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WJXC-7-0','00017727','2025-11-15',' 09:06:49','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-85-0' AND kode_barcode='00021513'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-85-0','00021513','2025-11-15',' 09:06:56','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XIXE-84-0' AND kode_barcode='00020939'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XIXE-84-0','00020939','2025-11-15',' 09:06:58','1','adminpusat'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251115-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251115-0001'; DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-126-0' AND kode_barcode='00019694'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-126-0','00019694','2025-11-15',' 09:07:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WDAE-164-0' AND kode_barcode='00015528'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WDAE-164-0','00015528','2025-11-15',' 09:10:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-66-0' AND kode_barcode='00021494'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-66-0','00021494','2025-11-15',' 09:11:06','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XHXH-24-0' AND kode_barcode='00020796'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XHXH-24-0','00020796','2025-11-15',' 09:11:26','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WFXC-117-0' AND kode_barcode='00016193'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WFXC-117-0','00016193','2025-11-15',' 09:11:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-57-0' AND kode_barcode='00022996'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-57-0','00022996','2025-11-15',' 09:11:45','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-52-0' AND kode_barcode='00022991'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-52-0','00022991','2025-11-15',' 09:11:59','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-69-0' AND kode_barcode='00021497'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-69-0','00021497','2025-11-15',' 09:12:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WJAB-102-0' AND kode_barcode='00017829'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WJAB-102-0','00017829','2025-11-15',' 09:12:42','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XGXC-108-0' AND kode_barcode='00020502'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XGXC-108-0','00020502','2025-11-15',' 09:12:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XABD-70-0' AND kode_barcode='00018629'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XABD-70-0','00018629','2025-11-15',' 09:12:54','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-88-0' AND kode_barcode='00021516'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-88-0','00021516','2025-11-15',' 09:13:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-87-0' AND kode_barcode='00021515'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-87-0','00021515','2025-11-15',' 09:13:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WABX-84-0' AND kode_barcode='00013482'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WABX-84-0','00013482','2025-11-15',' 09:13:20','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-83-0' AND kode_barcode='00023022'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-83-0','00023022','2025-11-15',' 09:13:41','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-44-0' AND kode_barcode='00024771'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-44-0','00024771','2025-11-15',' 09:13:45','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XIXE-85-0' AND kode_barcode='00020940'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XIXE-85-0','00020940','2025-11-15',' 09:13:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJCX-42-0' AND kode_barcode='00026388'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJCX-42-0','00026388','2025-11-15',' 09:14:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-45-0' AND kode_barcode='00026132'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-45-0','00026132','2025-11-15',' 09:14:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-166-0' AND kode_barcode='00025248'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-166-0','00025248','2025-11-15',' 09:14:17','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-78-0' AND kode_barcode='00023017'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-78-0','00023017','2025-11-15',' 09:14:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-43-0' AND kode_barcode='00024770'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-43-0','00024770','2025-11-15',' 09:14:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-45-0' AND kode_barcode='00022984'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-45-0','00022984','2025-11-15',' 09:14:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-43-0' AND kode_barcode='00022982'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-43-0','00022982','2025-11-15',' 09:14:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-36-0' AND kode_barcode='00022975'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-36-0','00022975','2025-11-15',' 09:15:02','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-104-0' AND kode_barcode='00024387'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-104-0','00024387','2025-11-15',' 09:15:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-72-0' AND kode_barcode='00024799'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-72-0','00024799','2025-11-15',' 09:15:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-105-0' AND kode_barcode='00024388'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-105-0','00024388','2025-11-15',' 09:15:21','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VJXF-109-0' AND kode_barcode='00011495'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VJXF-109-0','00011495','2025-11-15',' 09:15:26','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WHAE-83-0' AND kode_barcode='00017310'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WHAE-83-0','00017310','2025-11-15',' 09:15:38','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-37-0' AND kode_barcode='00022976'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-37-0','00022976','2025-11-15',' 09:16:00','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XJAE-133-0' AND kode_barcode='00021172'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XJAE-133-0','00021172','2025-11-15',' 09:16:20','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-65-0' AND kode_barcode='00024792'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-65-0','00024792','2025-11-15',' 09:16:38','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WDAE-155-0' AND kode_barcode='00015519'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WDAE-155-0','00015519','2025-11-15',' 09:16:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VCAA-32-0' AND kode_barcode='00006784'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VCAA-32-0','00006784','2025-11-15',' 09:17:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UEXD-3-0' AND kode_barcode='00002925'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UEXD-3-0','00002925','2025-11-15',' 09:17:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-55-0' AND kode_barcode='00013367'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-55-0','00013367','2025-11-15',' 09:17:32','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-75-0' AND kode_barcode='00024802'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-75-0','00024802','2025-11-15',' 09:17:42','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XBBG-81-0' AND kode_barcode='00019185'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XBBG-81-0','00019185','2025-11-15',' 09:17:47','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-63-0' AND kode_barcode='00024790'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-63-0','00024790','2025-11-15',' 09:17:54','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UEXD-5-0' AND kode_barcode='00002927'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UEXD-5-0','00002927','2025-11-15',' 09:18:14','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-74-0' AND kode_barcode='00024801'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-74-0','00024801','2025-11-15',' 09:18:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-43-0' AND kode_barcode='00013355'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-43-0','00013355','2025-11-15',' 09:18:29','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-83-0' AND kode_barcode='00024810'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-83-0','00024810','2025-11-15',' 09:18:34','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-99-0' AND kode_barcode='00025821'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-99-0','00025821','2025-11-15',' 09:18:43','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WEAE-125-0' AND kode_barcode='00015859'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WEAE-125-0','00015859','2025-11-15',' 09:18:54','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VKBE-30-0' AND kode_barcode='00012453'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VKBE-30-0','00012453','2025-11-15',' 09:19:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VKBD-105-0' AND kode_barcode='00012417'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VKBD-105-0','00012417','2025-11-15',' 09:19:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBBC-36-0' AND kode_barcode='00014386'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBBC-36-0','00014386','2025-11-15',' 09:19:17','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-91-0' AND kode_barcode='00025813'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-91-0','00025813','2025-11-15',' 09:19:29','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-123-0' AND kode_barcode='00019691'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-123-0','00019691','2025-11-15',' 09:19:37','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VLAX-91-0' AND kode_barcode='00012722'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VLAX-91-0','00012722','2025-11-15',' 09:19:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-51-0' AND kode_barcode='00024778'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-51-0','00024778','2025-11-15',' 09:19:43','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-47-0' AND kode_barcode='00024774'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-47-0','00024774','2025-11-15',' 09:19:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBAE-1-0' AND kode_barcode='00014153'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBAE-1-0','00014153','2025-11-15',' 09:19:54','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-55-0' AND kode_barcode='00024782'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-55-0','00024782','2025-11-15',' 09:19:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-49-0' AND kode_barcode='00024776'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-49-0','00024776','2025-11-15',' 09:20:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-38-0' AND kode_barcode='00013350'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-38-0','00013350','2025-11-15',' 09:20:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-48-0' AND kode_barcode='00024775'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-48-0','00024775','2025-11-15',' 09:20:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-172-0' AND kode_barcode='00025254'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-172-0','00025254','2025-11-15',' 09:20:17','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-59-0' AND kode_barcode='00024786'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-59-0','00024786','2025-11-15',' 09:20:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-51-0' AND kode_barcode='00013363'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-51-0','00013363','2025-11-15',' 09:20:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-49-0' AND kode_barcode='00013361'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-49-0','00013361','2025-11-15',' 09:20:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-50-0' AND kode_barcode='00013362'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-50-0','00013362','2025-11-15',' 09:20:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-57-0' AND kode_barcode='00024784'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-57-0','00024784','2025-11-15',' 09:21:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-87-0' AND kode_barcode='00024814'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-87-0','00024814','2025-11-15',' 09:21:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCBH-188-0' AND kode_barcode='00015149'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCBH-188-0','00015149','2025-11-15',' 09:21:07','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCBH-190-0' AND kode_barcode='00015151'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCBH-190-0','00015151','2025-11-15',' 09:21:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-60-0' AND kode_barcode='00024787'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-60-0','00024787','2025-11-15',' 09:21:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-90-0' AND kode_barcode='00025812'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-90-0','00025812','2025-11-15',' 09:21:16','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-96-0' AND kode_barcode='00025818'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-96-0','00025818','2025-11-15',' 09:21:20','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-22-0' AND kode_barcode='00022961'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-22-0','00022961','2025-11-15',' 09:21:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-21-0' AND kode_barcode='00022960'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-21-0','00022960','2025-11-15',' 09:22:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-100-0' AND kode_barcode='00024383'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-100-0','00024383','2025-11-15',' 09:22:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-178-0' AND kode_barcode='00025260'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-178-0','00025260','2025-11-15',' 09:22:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBF-7-0' AND kode_barcode='00025902'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBF-7-0','00025902','2025-11-15',' 09:22:37','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XJAE-131-0' AND kode_barcode='00021170'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XJAE-131-0','00021170','2025-11-15',' 09:22:43','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WKBA-103-0' AND kode_barcode='00018087'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WKBA-103-0','00018087','2025-11-15',' 09:22:50','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBBB-72-0' AND kode_barcode='00014328'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBBB-72-0','00014328','2025-11-15',' 09:23:00','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XJAE-132-0' AND kode_barcode='00021171'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XJAE-132-0','00021171','2025-11-15',' 09:23:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCBH-193-0' AND kode_barcode='00015154'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCBH-193-0','00015154','2025-11-15',' 09:23:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBBB-71-0' AND kode_barcode='00014327'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBBB-71-0','00014327','2025-11-15',' 09:23:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-109-0' AND kode_barcode='00024392'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-109-0','00024392','2025-11-15',' 09:23:39','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXA-4-0' AND kode_barcode='00023572'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXA-4-0','00023572','2025-11-15',' 09:23:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-102-0' AND kode_barcode='00025824'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-102-0','00025824','2025-11-15',' 09:24:00','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-95-0' AND kode_barcode='00025817'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-95-0','00025817','2025-11-15',' 09:24:21','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCBH-189-0' AND kode_barcode='00015150'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCBH-189-0','00015150','2025-11-15',' 09:24:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-97-0' AND kode_barcode='00025819'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-97-0','00025819','2025-11-15',' 09:24:28','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-89-0' AND kode_barcode='00024816'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-89-0','00024816','2025-11-15',' 09:24:34','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VKBD-97-0' AND kode_barcode='00012409'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VKBD-97-0','00012409','2025-11-15',' 09:24:37','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-47-0' AND kode_barcode='00013359'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-47-0','00013359','2025-11-15',' 09:24:43','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VKBD-98-0' AND kode_barcode='00012410'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VKBD-98-0','00012410','2025-11-15',' 09:24:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCBG-135-0' AND kode_barcode='00014941'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCBG-135-0','00014941','2025-11-15',' 09:24:52','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXA-12-0' AND kode_barcode='00023580'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXA-12-0','00023580','2025-11-15',' 09:25:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-58-0' AND kode_barcode='00024785'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-58-0','00024785','2025-11-15',' 09:25:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-171-0' AND kode_barcode='00025253'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-171-0','00025253','2025-11-15',' 09:25:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WHAE-90-0' AND kode_barcode='00017317'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WHAE-90-0','00017317','2025-11-15',' 09:25:41','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WDAE-157-0' AND kode_barcode='00015521'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WDAE-157-0','00015521','2025-11-15',' 09:25:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBBB-63-0' AND kode_barcode='00014319'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBBB-63-0','00014319','2025-11-15',' 09:25:49','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-50-0' AND kode_barcode='00024777'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-50-0','00024777','2025-11-15',' 09:25:52','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-42-0' AND kode_barcode='00013354'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-42-0','00013354','2025-11-15',' 09:25:59','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-54-0' AND kode_barcode='00024781'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-54-0','00024781','2025-11-15',' 09:26:05','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-53-0' AND kode_barcode='00024780'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-53-0','00024780','2025-11-15',' 09:26:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXA-13-0' AND kode_barcode='00023581'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXA-13-0','00023581','2025-11-15',' 09:26:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCBH-170-0' AND kode_barcode='00015131'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCBH-170-0','00015131','2025-11-15',' 09:26:28','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XABD-61-0' AND kode_barcode='00018620'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XABD-61-0','00018620','2025-11-15',' 09:26:38','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-56-0' AND kode_barcode='00024783'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-56-0','00024783','2025-11-15',' 09:26:42','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VKXD-24-0' AND kode_barcode='00011846'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VKXD-24-0','00011846','2025-11-15',' 09:26:50','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VKBD-106-0' AND kode_barcode='00012418'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VKBD-106-0','00012418','2025-11-15',' 09:26:56','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VLAB-72-0' AND kode_barcode='00012807'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VLAB-72-0','00012807','2025-11-15',' 09:26:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-85-0' AND kode_barcode='00024812'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-85-0','00024812','2025-11-15',' 09:27:07','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-61-0' AND kode_barcode='00024788'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-61-0','00024788','2025-11-15',' 09:27:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-84-0' AND kode_barcode='00024811'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-84-0','00024811','2025-11-15',' 09:27:17','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-56-0' AND kode_barcode='00013368'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-56-0','00013368','2025-11-15',' 09:27:28','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-62-0' AND kode_barcode='00024789'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-62-0','00024789','2025-11-15',' 09:27:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-46-0' AND kode_barcode='00024773'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-46-0','00024773','2025-11-15',' 09:27:31','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-58-0' AND kode_barcode='00013370'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-58-0','00013370','2025-11-15',' 09:27:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-80-0' AND kode_barcode='00024807'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-80-0','00024807','2025-11-15',' 09:27:55','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WGBX-134-0' AND kode_barcode='00016484'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WGBX-134-0','00016484','2025-11-15',' 09:27:59','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-54-0' AND kode_barcode='00013366'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-54-0','00013366','2025-11-15',' 09:28:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-76-0' AND kode_barcode='00024803'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-76-0','00024803','2025-11-15',' 09:28:20','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJAH-76-0' AND kode_barcode='00026307'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJAH-76-0','00026307','2025-11-15',' 09:28:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-82-0' AND kode_barcode='00024809'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-82-0','00024809','2025-11-15',' 09:28:41','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-66-0' AND kode_barcode='00024793'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-66-0','00024793','2025-11-15',' 09:28:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-103-0' AND kode_barcode='00024386'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-103-0','00024386','2025-11-15',' 09:29:17','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WABX-83-0' AND kode_barcode='00013481'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WABX-83-0','00013481','2025-11-15',' 09:29:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-79-0' AND kode_barcode='00024806'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-79-0','00024806','2025-11-15',' 09:29:32','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-53-0' AND kode_barcode='00013365'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-53-0','00013365','2025-11-15',' 09:29:39','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-42-0' AND kode_barcode='00022981'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-42-0','00022981','2025-11-15',' 09:29:50','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-35-0' AND kode_barcode='00022974'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-35-0','00022974','2025-11-15',' 09:29:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-106-0' AND kode_barcode='00024389'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-106-0','00024389','2025-11-15',' 09:29:54','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-38-0' AND kode_barcode='00022977'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-38-0','00022977','2025-11-15',' 09:29:55','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-44-0' AND kode_barcode='00022983'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-44-0','00022983','2025-11-15',' 09:29:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-44-0' AND kode_barcode='00026131'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-44-0','00026131','2025-11-15',' 09:35:38','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XLAF-5-0' AND kode_barcode='00022460'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XLAF-5-0','00022460','2025-11-15',' 09:35:56','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YBAA-85-0' AND kode_barcode='00023129'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YBAA-85-0','00023129','2025-11-15',' 09:36:07','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-66-0' AND kode_barcode='00025788'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-66-0','00025788','2025-11-15',' 09:36:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-13-0' AND kode_barcode='00022952'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-13-0','00022952','2025-11-15',' 09:36:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-38-0' AND kode_barcode='00026125'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-38-0','00026125','2025-11-15',' 09:36:18','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-15-0' AND kode_barcode='00022954'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-15-0','00022954','2025-11-15',' 09:36:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-14-0' AND kode_barcode='00022953'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-14-0','00022953','2025-11-15',' 09:36:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XACA-216-0' AND kode_barcode='00018916'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XACA-216-0','00018916','2025-11-15',' 09:36:57','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXA-6-0' AND kode_barcode='00023574'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXA-6-0','00023574','2025-11-15',' 09:37:05','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WDAC-56-0' AND kode_barcode='00015353'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WDAC-56-0','00015353','2025-11-15',' 09:37:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-42-0' AND kode_barcode='00026129'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-42-0','00026129','2025-11-15',' 09:37:20','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-104-0' AND kode_barcode='00025826'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-104-0','00025826','2025-11-15',' 09:37:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-173-0' AND kode_barcode='00025255'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-173-0','00025255','2025-11-15',' 09:37:31','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCAG-103-0' AND kode_barcode='00014795'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCAG-103-0','00014795','2025-11-15',' 09:37:38','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-85-0' AND kode_barcode='00025807'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-85-0','00025807','2025-11-15',' 09:37:43','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UEXF-109-0' AND kode_barcode='00003171'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UEXF-109-0','00003171','2025-11-15',' 09:37:52','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UEXF-108-0' AND kode_barcode='00003170'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UEXF-108-0','00003170','2025-11-15',' 09:38:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-118-0' AND kode_barcode='00024401'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-118-0','00024401','2025-11-15',' 09:38:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-98-0' AND kode_barcode='00024825'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-98-0','00024825','2025-11-15',' 09:38:31','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBBB-83-0' AND kode_barcode='00014339'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBBB-83-0','00014339','2025-11-15',' 09:38:39','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-107-0' AND kode_barcode='00024390'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-107-0','00024390','2025-11-15',' 09:38:55','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-100-0' AND kode_barcode='00025822'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-100-0','00025822','2025-11-15',' 09:39:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-95-0' AND kode_barcode='00024822'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-95-0','00024822','2025-11-15',' 09:39:07','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XLXB-64-0' AND kode_barcode='00022354'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XLXB-64-0','00022354','2025-11-15',' 09:39:14','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-99-0' AND kode_barcode='00024826'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-99-0','00024826','2025-11-15',' 09:39:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-101-0' AND kode_barcode='00025823'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-101-0','00025823','2025-11-15',' 09:39:38','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-40-0' AND kode_barcode='00026127'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-40-0','00026127','2025-11-15',' 09:39:49','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XDXD-70-0' AND kode_barcode='00020052'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XDXD-70-0','00020052','2025-11-15',' 09:39:57','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XIXE-80-0' AND kode_barcode='00020935'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XIXE-80-0','00020935','2025-11-15',' 09:40:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WAAI-27-0' AND kode_barcode='00013339'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WAAI-27-0','00013339','2025-11-15',' 09:40:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XACA-197-0' AND kode_barcode='00018897'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XACA-197-0','00018897','2025-11-15',' 09:40:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-92-0' AND kode_barcode='00025814'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-92-0','00025814','2025-11-15',' 09:40:32','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-94-0' AND kode_barcode='00024821'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-94-0','00024821','2025-11-15',' 09:40:42','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-93-0' AND kode_barcode='00024820'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-93-0','00024820','2025-11-15',' 09:40:55','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXC-92-0' AND kode_barcode='00024819'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXC-92-0','00024819','2025-11-15',' 09:41:02','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-87-0' AND kode_barcode='00025809'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-87-0','00025809','2025-11-15',' 09:41:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-99-0' AND kode_barcode='00021527'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-99-0','00021527','2025-11-15',' 09:41:16','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-34-0' AND kode_barcode='00022973'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-34-0','00022973','2025-11-15',' 09:41:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-88-0' AND kode_barcode='00025810'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-88-0','00025810','2025-11-15',' 09:41:41','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-30-0' AND kode_barcode='00022969'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-30-0','00022969','2025-11-15',' 09:41:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XACA-198-0' AND kode_barcode='00018898'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XACA-198-0','00018898','2025-11-15',' 09:41:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-117-0' AND kode_barcode='00024400'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-117-0','00024400','2025-11-15',' 09:42:17','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XLXB-63-0' AND kode_barcode='00022353'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XLXB-63-0','00022353','2025-11-15',' 09:42:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCBG-136-0' AND kode_barcode='00014942'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCBG-136-0','00014942','2025-11-15',' 09:42:29','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-105-0' AND kode_barcode='00025827'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-105-0','00025827','2025-11-15',' 09:42:35','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBF-14-0' AND kode_barcode='00024471'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBF-14-0','00024471','2025-11-15',' 09:42:45','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXE-14-0' AND kode_barcode='00023683'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXE-14-0','00023683','2025-11-15',' 09:42:59','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-48-0' AND kode_barcode='00026135'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-48-0','00026135','2025-11-15',' 09:43:10','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-20-0' AND kode_barcode='00022959'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-20-0','00022959','2025-11-15',' 09:43:20','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-18-0' AND kode_barcode='00019586'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-18-0','00019586','2025-11-15',' 09:43:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-17-0' AND kode_barcode='00019585'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-17-0','00019585','2025-11-15',' 09:43:49','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WLAF-27-0' AND kode_barcode='00018277'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WLAF-27-0','00018277','2025-11-15',' 09:44:21','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-20-0' AND kode_barcode='00019588'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-20-0','00019588','2025-11-15',' 09:44:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-21-0' AND kode_barcode='00019589'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-21-0','00019589','2025-11-15',' 09:44:28','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-47-0' AND kode_barcode='00026134'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-47-0','00026134','2025-11-15',' 09:44:32','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-94-0' AND kode_barcode='00025816'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-94-0','00025816','2025-11-15',' 09:44:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-19-0' AND kode_barcode='00022958'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-19-0','00022958','2025-11-15',' 09:44:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-116-0' AND kode_barcode='00024399'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-116-0','00024399','2025-11-15',' 09:44:56','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXD-54-0' AND kode_barcode='00021407'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXD-54-0','00021407','2025-11-15',' 09:44:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBBB-76-0' AND kode_barcode='00014332'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBBB-76-0','00014332','2025-11-15',' 09:45:00','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCBH-181-0' AND kode_barcode='00015142'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCBH-181-0','00015142','2025-11-15',' 09:45:07','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XAXI-24-0' AND kode_barcode='00018312'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XAXI-24-0','00018312','2025-11-15',' 09:45:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-167-0' AND kode_barcode='00023981'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-167-0','00023981','2025-11-15',' 09:45:26','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-163-0' AND kode_barcode='00023977'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-163-0','00023977','2025-11-15',' 09:45:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WDXC-35-0' AND kode_barcode='00015271'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WDXC-35-0','00015271','2025-11-15',' 09:45:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WDXC-34-0' AND kode_barcode='00015270'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WDXC-34-0','00015270','2025-11-15',' 09:46:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UEXF-110-0' AND kode_barcode='00003172'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UEXF-110-0','00003172','2025-11-15',' 09:46:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VDBC-31-0' AND kode_barcode='00009010'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VDBC-31-0','00009010','2025-11-15',' 09:46:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-168-0' AND kode_barcode='00025250'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-168-0','00025250','2025-11-15',' 09:46:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXH-152-0' AND kode_barcode='00000495'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXH-152-0','00000495','2025-11-15',' 09:46:31','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCAG-98-0' AND kode_barcode='00014790'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCAG-98-0','00014790','2025-11-15',' 09:46:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WDAC-51-0' AND kode_barcode='00015348'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WDAC-51-0','00015348','2025-11-15',' 09:46:53','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WDAC-54-0' AND kode_barcode='00015351'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WDAC-54-0','00015351','2025-11-15',' 09:46:56','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-174-0' AND kode_barcode='00025256'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-174-0','00025256','2025-11-15',' 09:47:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-17-0' AND kode_barcode='00022956'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-17-0','00022956','2025-11-15',' 09:47:05','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-113-0' AND kode_barcode='00024396'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-113-0','00024396','2025-11-15',' 09:47:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WHAB-70-0' AND kode_barcode='00017154'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WHAB-70-0','00017154','2025-11-15',' 09:47:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-114-0' AND kode_barcode='00024397'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-114-0','00024397','2025-11-15',' 09:47:17','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-112-0' AND kode_barcode='00024395'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-112-0','00024395','2025-11-15',' 09:47:20','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XEBE-80-0' AND kode_barcode='00020309'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XEBE-80-0','00020309','2025-11-15',' 09:47:37','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-51-0' AND kode_barcode='00025773'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-51-0','00025773','2025-11-15',' 09:49:10','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-69-0' AND kode_barcode='00023008'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-69-0','00023008','2025-11-15',' 09:49:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-76-0' AND kode_barcode='00023015'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-76-0','00023015','2025-11-15',' 09:50:04','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-59-0' AND kode_barcode='00022998'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-59-0','00022998','2025-11-15',' 09:50:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-95-0' AND kode_barcode='00021523'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-95-0','00021523','2025-11-15',' 09:50:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-22-0' AND kode_barcode='00025744'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-22-0','00025744','2025-11-15',' 09:50:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-47-0' AND kode_barcode='00025769'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-47-0','00025769','2025-11-15',' 09:50:55','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-59-0' AND kode_barcode='00025781'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-59-0','00025781','2025-11-15',' 09:51:05','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XGXC-106-0' AND kode_barcode='00020500'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XGXC-106-0','00020500','2025-11-15',' 09:51:29','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJAH-75-0' AND kode_barcode='00026306'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJAH-75-0','00026306','2025-11-15',' 09:51:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-49-0' AND kode_barcode='00025771'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-49-0','00025771','2025-11-15',' 09:51:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-43-0' AND kode_barcode='00025765'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-43-0','00025765','2025-11-15',' 09:51:57','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-21-0' AND kode_barcode='00025743'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-21-0','00025743','2025-11-15',' 09:52:10','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-45-0' AND kode_barcode='00025767'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-45-0','00025767','2025-11-15',' 09:52:19','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-60-0' AND kode_barcode='00025782'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-60-0','00025782','2025-11-15',' 09:52:43','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-46-0' AND kode_barcode='00025768'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-46-0','00025768','2025-11-15',' 09:53:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-55-0' AND kode_barcode='00025777'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-55-0','00025777','2025-11-15',' 09:53:27','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-53-0' AND kode_barcode='00025775'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-53-0','00025775','2025-11-15',' 09:53:53','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-18-0' AND kode_barcode='00025740'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-18-0','00025740','2025-11-15',' 09:54:18','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-54-0' AND kode_barcode='00025776'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-54-0','00025776','2025-11-15',' 09:54:31','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-58-0' AND kode_barcode='00025780'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-58-0','00025780','2025-11-15',' 09:54:42','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-50-0' AND kode_barcode='00025772'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-50-0','00025772','2025-11-15',' 09:54:56','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-17-0' AND kode_barcode='00025739'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-17-0','00025739','2025-11-15',' 09:55:07','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-13-0' AND kode_barcode='00025735'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-13-0','00025735','2025-11-15',' 09:55:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-63-0' AND kode_barcode='00025785'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-63-0','00025785','2025-11-15',' 09:55:56','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-42-0' AND kode_barcode='00025764'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-42-0','00025764','2025-11-15',' 09:56:06','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFBF-7-0' AND kode_barcode='00025544'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFBF-7-0','00025544','2025-11-15',' 09:56:21','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-44-0' AND kode_barcode='00025766'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-44-0','00025766','2025-11-15',' 09:56:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-64-0' AND kode_barcode='00025786'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-64-0','00025786','2025-11-15',' 09:57:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-48-0' AND kode_barcode='00025770'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-48-0','00025770','2025-11-15',' 09:57:32','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WLAE-41-0' AND kode_barcode='00018183'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WLAE-41-0','00018183','2025-11-15',' 09:57:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-91-0' AND kode_barcode='00021519'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-91-0','00021519','2025-11-15',' 09:57:53','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WHAE-99-0' AND kode_barcode='00017326'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WHAE-99-0','00017326','2025-11-15',' 09:58:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-165-0' AND kode_barcode='00025247'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-165-0','00025247','2025-11-15',' 09:58:14','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-12-0' AND kode_barcode='00025734'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-12-0','00025734','2025-11-15',' 09:58:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-47-0' AND kode_barcode='00022986'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-47-0','00022986','2025-11-15',' 09:58:41','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-20-0' AND kode_barcode='00025742'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-20-0','00025742','2025-11-15',' 09:59:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-82-0' AND kode_barcode='00023021'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-82-0','00023021','2025-11-15',' 09:59:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XIXE-83-0' AND kode_barcode='00020938'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XIXE-83-0','00020938','2025-11-15',' 09:59:27','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-51-0' AND kode_barcode='00022990'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-51-0','00022990','2025-11-15',' 09:59:39','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXA-16-0' AND kode_barcode='00023584'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXA-16-0','00023584','2025-11-15',' 09:59:49','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-86-0' AND kode_barcode='00021514'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-86-0','00021514','2025-11-15',' 10:00:10','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-56-0' AND kode_barcode='00025778'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-56-0','00025778','2025-11-15',' 10:00:28','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-15-0' AND kode_barcode='00025737'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-15-0','00025737','2025-11-15',' 10:00:42','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-19-0' AND kode_barcode='00025741'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-19-0','00025741','2025-11-15',' 10:00:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-16-0' AND kode_barcode='00025738'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-16-0','00025738','2025-11-15',' 10:01:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-40-0' AND kode_barcode='00025762'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-40-0','00025762','2025-11-15',' 10:01:29','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-24-0' AND kode_barcode='00025746'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-24-0','00025746','2025-11-15',' 10:01:43','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XHXH-23-0' AND kode_barcode='00020795'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XHXH-23-0','00020795','2025-11-15',' 10:01:59','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-71-0' AND kode_barcode='00023010'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-71-0','00023010','2025-11-15',' 10:02:14','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-27-0' AND kode_barcode='00025749'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-27-0','00025749','2025-11-15',' 10:02:27','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-26-0' AND kode_barcode='00025748'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-26-0','00025748','2025-11-15',' 10:02:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-23-0' AND kode_barcode='00025745'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-23-0','00025745','2025-11-15',' 10:02:53','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-41-0' AND kode_barcode='00025763'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-41-0','00025763','2025-11-15',' 10:03:07','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-31-0' AND kode_barcode='00025753'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-31-0','00025753','2025-11-15',' 10:03:28','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-37-0' AND kode_barcode='00025759'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-37-0','00025759','2025-11-15',' 10:03:47','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-28-0' AND kode_barcode='00025750'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-28-0','00025750','2025-11-15',' 10:04:10','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-61-0' AND kode_barcode='00025783'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-61-0','00025783','2025-11-15',' 10:04:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-56-0' AND kode_barcode='00022995'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-56-0','00022995','2025-11-15',' 10:04:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-97-0' AND kode_barcode='00024380'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-97-0','00024380','2025-11-15',' 10:04:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-73-0' AND kode_barcode='00023012'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-73-0','00023012','2025-11-15',' 10:05:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-98-0' AND kode_barcode='00024381'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-98-0','00024381','2025-11-15',' 10:05:32','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-95-0' AND kode_barcode='00024378'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-95-0','00024378','2025-11-15',' 10:05:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-65-0' AND kode_barcode='00023004'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-65-0','00023004','2025-11-15',' 10:05:53','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-36-0' AND kode_barcode='00025758'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-36-0','00025758','2025-11-15',' 10:06:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-38-0' AND kode_barcode='00025760'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-38-0','00025760','2025-11-15',' 10:06:27','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-32-0' AND kode_barcode='00025754'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-32-0','00025754','2025-11-15',' 10:06:35','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-35-0' AND kode_barcode='00025757'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-35-0','00025757','2025-11-15',' 10:06:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-62-0' AND kode_barcode='00025784'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-62-0','00025784','2025-11-15',' 10:07:02','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXA-15-0' AND kode_barcode='00023583'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXA-15-0','00023583','2025-11-15',' 10:07:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-65-0' AND kode_barcode='00025787'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-65-0','00025787','2025-11-15',' 10:07:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-36-0' AND kode_barcode='00026123'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-36-0','00026123','2025-11-15',' 10:07:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJAH-79-0' AND kode_barcode='00026310'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJAH-79-0','00026310','2025-11-15',' 10:07:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-162-0' AND kode_barcode='00025244'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-162-0','00025244','2025-11-15',' 10:07:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XLBG-56-0' AND kode_barcode='00022517'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XLBG-56-0','00022517','2025-11-15',' 10:08:06','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XEBE-98-0' AND kode_barcode='00020327'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XEBE-98-0','00020327','2025-11-15',' 10:08:18','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBC-94-0' AND kode_barcode='00019897'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBC-94-0','00019897','2025-11-15',' 10:08:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-74-0' AND kode_barcode='00021502'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-74-0','00021502','2025-11-15',' 10:08:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-58-0' AND kode_barcode='00022997'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-58-0','00022997','2025-11-15',' 10:08:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WHAE-100-0' AND kode_barcode='00017327'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WHAE-100-0','00017327','2025-11-15',' 10:09:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-5-0' AND kode_barcode='00022944'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-5-0','00022944','2025-11-15',' 10:09:14','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJAH-70-0' AND kode_barcode='00026301'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJAH-70-0','00026301','2025-11-15',' 10:10:29','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VJBX-26-0' AND kode_barcode='00011674'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VJBX-26-0','00011674','2025-11-15',' 10:11:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-7-0' AND kode_barcode='00022946'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-7-0','00022946','2025-11-15',' 10:11:34','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-5-0' AND kode_barcode='00025727'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-5-0','00025727','2025-11-15',' 10:12:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YAXD-48-0' AND kode_barcode='00022623'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YAXD-48-0','00022623','2025-11-15',' 10:12:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-8-0' AND kode_barcode='00022947'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-8-0','00022947','2025-11-15',' 10:13:18','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-4-0' AND kode_barcode='00025726'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-4-0','00025726','2025-11-15',' 10:13:38','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-2-0' AND kode_barcode='00022941'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-2-0','00022941','2025-11-15',' 10:14:14','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-3-0' AND kode_barcode='00025725'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-3-0','00025725','2025-11-15',' 10:14:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-2-0' AND kode_barcode='00025724'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-2-0','00025724','2025-11-15',' 10:14:54','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WJAB-97-0' AND kode_barcode='00017824'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WJAB-97-0','00017824','2025-11-15',' 10:15:31','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-161-0' AND kode_barcode='00025243'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-161-0','00025243','2025-11-15',' 10:15:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VJBX-28-0' AND kode_barcode='00011676'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VJBX-28-0','00011676','2025-11-15',' 10:16:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WFXC-115-0' AND kode_barcode='00016191'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WFXC-115-0','00016191','2025-11-15',' 10:16:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-4-0' AND kode_barcode='00022943'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-4-0','00022943','2025-11-15',' 10:16:41','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-10-0' AND kode_barcode='00025732'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-10-0','00025732','2025-11-15',' 10:17:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VJBX-39-0' AND kode_barcode='00011687'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VJBX-39-0','00011687','2025-11-15',' 10:17:16','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YACX-9-0' AND kode_barcode='00022948'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YACX-9-0','00022948','2025-11-15',' 10:17:34','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VJBX-35-0' AND kode_barcode='00011683'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VJBX-35-0','00011683','2025-11-15',' 10:17:53','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-9-0' AND kode_barcode='00025731'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-9-0','00025731','2025-11-15',' 10:18:05','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-129-0' AND kode_barcode='00019697'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-129-0','00019697','2025-11-15',' 10:18:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-7-0' AND kode_barcode='00025729'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-7-0','00025729','2025-11-15',' 10:18:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-8-0' AND kode_barcode='00025730'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-8-0','00025730','2025-11-15',' 10:19:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-97-0' AND kode_barcode='00021525'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-97-0','00021525','2025-11-15',' 10:19:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-125-0' AND kode_barcode='00019693'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-125-0','00019693','2025-11-15',' 10:19:53','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YGAE-6-0' AND kode_barcode='00025728'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YGAE-6-0','00025728','2025-11-15',' 10:20:05','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXG-16-0' AND kode_barcode='00024025'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXG-16-0','00024025','2025-11-15',' 10:21:37','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXG-22-0' AND kode_barcode='00024031'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXG-22-0','00024031','2025-11-15',' 10:21:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXG-14-0' AND kode_barcode='00024023'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXG-14-0','00024023','2025-11-15',' 10:22:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXG-18-0' AND kode_barcode='00024027'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXG-18-0','00024027','2025-11-15',' 10:22:35','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXG-20-0' AND kode_barcode='00024029'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXG-20-0','00024029','2025-11-15',' 10:22:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXG-13-0' AND kode_barcode='00024022'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXG-13-0','00024022','2025-11-15',' 10:23:05','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-37-0' AND kode_barcode='00026124'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-37-0','00026124','2025-11-15',' 10:23:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-174-0' AND kode_barcode='00023988'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-174-0','00023988','2025-11-15',' 10:23:41','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXE-149-0' AND kode_barcode='00024977'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXE-149-0','00024977','2025-11-15',' 10:23:50','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-194-0' AND kode_barcode='00024008'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-194-0','00024008','2025-11-15',' 10:24:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-188-0' AND kode_barcode='00024002'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-188-0','00024002','2025-11-15',' 10:24:21','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-180-0' AND kode_barcode='00023994'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-180-0','00023994','2025-11-15',' 10:24:57','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-185-0' AND kode_barcode='00023999'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-185-0','00023999','2025-11-15',' 10:25:10','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-172-0' AND kode_barcode='00023986'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-172-0','00023986','2025-11-15',' 10:25:44','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-23-0' AND kode_barcode='00019591'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-23-0','00019591','2025-11-15',' 10:25:56','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-181-0' AND kode_barcode='00023995'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-181-0','00023995','2025-11-15',' 10:26:19','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-191-0' AND kode_barcode='00024005'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-191-0','00024005','2025-11-15',' 10:26:32','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-189-0' AND kode_barcode='00024003'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-189-0','00024003','2025-11-15',' 10:27:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-192-0' AND kode_barcode='00024006'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-192-0','00024006','2025-11-15',' 10:27:22','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-169-0' AND kode_barcode='00023983'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-169-0','00023983','2025-11-15',' 10:27:39','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XLXB-60-0' AND kode_barcode='00022350'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XLXB-60-0','00022350','2025-11-15',' 10:27:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-35-0' AND kode_barcode='00026122'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-35-0','00026122','2025-11-15',' 10:28:16','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-173-0' AND kode_barcode='00023987'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-173-0','00023987','2025-11-15',' 10:28:26','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YEXE-148-0' AND kode_barcode='00024976'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YEXE-148-0','00024976','2025-11-15',' 10:28:39','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCAX-31-0' AND kode_barcode='00024073'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCAX-31-0','00024073','2025-11-15',' 10:29:00','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-178-0' AND kode_barcode='00023992'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-178-0','00023992','2025-11-15',' 10:29:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YHBI-34-0' AND kode_barcode='00026121'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YHBI-34-0','00026121','2025-11-15',' 10:29:28','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJAH-72-0' AND kode_barcode='00026303'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJAH-72-0','00026303','2025-11-15',' 10:29:55','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XJBE-9-0' AND kode_barcode='00021228'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XJBE-9-0','00021228','2025-11-15',' 10:30:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XJBE-11-0' AND kode_barcode='00021230'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XJBE-11-0','00021230','2025-11-15',' 10:30:52','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXB-67-0' AND kode_barcode='00021298'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXB-67-0','00021298','2025-11-15',' 10:31:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJAH-73-0' AND kode_barcode='00026304'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJAH-73-0','00026304','2025-11-15',' 10:31:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XEBE-93-0' AND kode_barcode='00020322'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XEBE-93-0','00020322','2025-11-15',' 10:32:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-81-0' AND kode_barcode='00024364'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-81-0','00024364','2025-11-15',' 10:32:10','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXA-11-0' AND kode_barcode='00023579'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXA-11-0','00023579','2025-11-15',' 10:32:22','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-83-0' AND kode_barcode='00024366'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-83-0','00024366','2025-11-15',' 10:32:37','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXF-176-0' AND kode_barcode='00023990'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXF-176-0','00023990','2025-11-15',' 10:33:06','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXG-5-0' AND kode_barcode='00024014'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXG-5-0','00024014','2025-11-15',' 10:33:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-93-0' AND kode_barcode='00024376'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-93-0','00024376','2025-11-15',' 10:34:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YBXC-20-0' AND kode_barcode='00023044'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YBXC-20-0','00023044','2025-11-15',' 10:34:28','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCAD-44-0' AND kode_barcode='00019390'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCAD-44-0','00019390','2025-11-15',' 10:34:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJAH-78-0' AND kode_barcode='00026309'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJAH-78-0','00026309','2025-11-15',' 10:34:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCAD-46-0' AND kode_barcode='00019392'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCAD-46-0','00019392','2025-11-15',' 10:35:11','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-91-0' AND kode_barcode='00024374'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-91-0','00024374','2025-11-15',' 10:36:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VDXH-64-0' AND kode_barcode='00007163'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VDXH-64-0','00007163','2025-11-15',' 10:36:24','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-90-0' AND kode_barcode='00024373'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-90-0','00024373','2025-11-15',' 10:36:29','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UJXH-21-0' AND kode_barcode='00005065'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UJXH-21-0','00005065','2025-11-15',' 10:37:04','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XJBB-1-0' AND kode_barcode='00021215'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XJBB-1-0','00021215','2025-11-15',' 10:37:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XAXI-70-0' AND kode_barcode='00018358'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XAXI-70-0','00018358','2025-11-15',' 10:37:18','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-63-0' AND kode_barcode='00000711'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-63-0','00000711','2025-11-15',' 10:37:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VGXH-48-0' AND kode_barcode='00010357'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VGXH-48-0','00010357','2025-11-15',' 10:37:52','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WIXH-44-0' AND kode_barcode='00017501'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WIXH-44-0','00017501','2025-11-15',' 10:38:16','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-92-0' AND kode_barcode='00024375'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-92-0','00024375','2025-11-15',' 10:38:38','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-85-0' AND kode_barcode='00024368'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-85-0','00024368','2025-11-15',' 10:38:50','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCAD-60-0' AND kode_barcode='00024220'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCAD-60-0','00024220','2025-11-15',' 10:39:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VGXH-52-0' AND kode_barcode='00010361'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VGXH-52-0','00010361','2025-11-15',' 10:39:35','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VGXH-53-0' AND kode_barcode='00010362'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VGXH-53-0','00010362','2025-11-15',' 10:39:41','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VGXH-51-0' AND kode_barcode='00010360'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VGXH-51-0','00010360','2025-11-15',' 10:39:54','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YBXC-15-0' AND kode_barcode='00023039'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YBXC-15-0','00023039','2025-11-15',' 10:40:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YBXC-17-0' AND kode_barcode='00023041'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YBXC-17-0','00023041','2025-11-15',' 10:40:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBE-87-0' AND kode_barcode='00024370'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBE-87-0','00024370','2025-11-15',' 10:40:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-82-0' AND kode_barcode='00021510'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-82-0','00021510','2025-11-15',' 10:40:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XEBE-86-0' AND kode_barcode='00020315'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XEBE-86-0','00020315','2025-11-15',' 10:40:59','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-31-0' AND kode_barcode='00019599'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-31-0','00019599','2025-11-15',' 10:41:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XBAE-30-0' AND kode_barcode='00019046'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XBAE-30-0','00019046','2025-11-15',' 10:41:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJAH-74-0' AND kode_barcode='00026305'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJAH-74-0','00026305','2025-11-15',' 10:41:27','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XACA-204-0' AND kode_barcode='00018904'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XACA-204-0','00018904','2025-11-15',' 10:41:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-33-0' AND kode_barcode='00019601'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-33-0','00019601','2025-11-15',' 10:41:57','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-81-0' AND kode_barcode='00021509'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-81-0','00021509','2025-11-15',' 10:42:05','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-36-0' AND kode_barcode='00019604'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-36-0','00019604','2025-11-15',' 10:42:19','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-37-0' AND kode_barcode='00019605'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-37-0','00019605','2025-11-15',' 10:42:29','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-83-0' AND kode_barcode='00021511'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-83-0','00021511','2025-11-15',' 10:42:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WGBX-145-0' AND kode_barcode='00016495'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WGBX-145-0','00016495','2025-11-15',' 10:42:53','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WHAE-95-0' AND kode_barcode='00017322'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WHAE-95-0','00017322','2025-11-15',' 10:43:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WGBX-144-0' AND kode_barcode='00016494'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WGBX-144-0','00016494','2025-11-15',' 10:43:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XACA-208-0' AND kode_barcode='00018908'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XACA-208-0','00018908','2025-11-15',' 10:43:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WFXC-112-0' AND kode_barcode='00016188'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WFXC-112-0','00016188','2025-11-15',' 10:43:31','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-63-0' AND kode_barcode='00021491'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-63-0','00021491','2025-11-15',' 10:43:47','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XACA-210-0' AND kode_barcode='00018910'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XACA-210-0','00018910','2025-11-15',' 10:44:27','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XEBE-79-0' AND kode_barcode='00020308'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XEBE-79-0','00020308','2025-11-15',' 10:44:32','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XGXC-96-0' AND kode_barcode='00020490'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XGXC-96-0','00020490','2025-11-15',' 10:44:36','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YJAH-71-0' AND kode_barcode='00026302'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YJAH-71-0','00026302','2025-11-15',' 10:44:41','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XAXI-20-0' AND kode_barcode='00018308'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XAXI-20-0','00018308','2025-11-15',' 10:44:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XDXD-68-0' AND kode_barcode='00020050'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XDXD-68-0','00020050','2025-11-15',' 10:44:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCXA-5-0' AND kode_barcode='00023573'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCXA-5-0','00023573','2025-11-15',' 10:44:55','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XCBA-121-0' AND kode_barcode='00019689'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XCBA-121-0','00019689','2025-11-15',' 10:45:00','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XGAX-41-0' AND kode_barcode='00020647'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XGAX-41-0','00020647','2025-11-15',' 10:45:10','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-79-0' AND kode_barcode='00021507'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-79-0','00021507','2025-11-15',' 10:45:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WGBX-138-0' AND kode_barcode='00016488'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WGBX-138-0','00016488','2025-11-15',' 10:45:29','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XACA-220-0' AND kode_barcode='00018920'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XACA-220-0','00018920','2025-11-15',' 10:45:34','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-62-0' AND kode_barcode='00021490'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-62-0','00021490','2025-11-15',' 10:45:41','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XABD-56-0' AND kode_barcode='00018615'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XABD-56-0','00018615','2025-11-15',' 10:45:52','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WBBB-74-0' AND kode_barcode='00014330'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WBBB-74-0','00014330','2025-11-15',' 10:46:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-77-0' AND kode_barcode='00021505'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-77-0','00021505','2025-11-15',' 10:46:26','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDAE-97-0' AND kode_barcode='00001895'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDAE-97-0','00001895','2025-11-15',' 10:46:37','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-60-0' AND kode_barcode='00021488'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-60-0','00021488','2025-11-15',' 10:46:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-27-0' AND kode_barcode='00000675'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-27-0','00000675','2025-11-15',' 10:47:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXG-58-0' AND kode_barcode='00021486'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXG-58-0','00021486','2025-11-15',' 10:47:10','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WDAE-154-0' AND kode_barcode='00015518'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WDAE-154-0','00015518','2025-11-15',' 10:47:18','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VLAX-85-0' AND kode_barcode='00012716'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VLAX-85-0','00012716','2025-11-15',' 10:47:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXH-268-0' AND kode_barcode='00000611'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXH-268-0','00000611','2025-11-15',' 10:47:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WGBX-135-0' AND kode_barcode='00016485'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WGBX-135-0','00016485','2025-11-15',' 10:47:45','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXH-162-0' AND kode_barcode='00000505'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXH-162-0','00000505','2025-11-15',' 10:47:55','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XABD-62-0' AND kode_barcode='00018621'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XABD-62-0','00018621','2025-11-15',' 10:48:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXH-195-0' AND kode_barcode='00000538'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXH-195-0','00000538','2025-11-15',' 10:48:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XJAE-130-0' AND kode_barcode='00021169'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XJAE-130-0','00021169','2025-11-15',' 10:48:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDAE-105-0' AND kode_barcode='00001903'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDAE-105-0','00001903','2025-11-15',' 10:48:39','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YFAH-170-0' AND kode_barcode='00025252'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YFAH-170-0','00025252','2025-11-15',' 10:48:45','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDBG-3-0' AND kode_barcode='00002609'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDBG-3-0','00002609','2025-11-15',' 10:48:55','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXH-164-0' AND kode_barcode='00000507'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXH-164-0','00000507','2025-11-15',' 10:48:57','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-6-0' AND kode_barcode='00000654'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-6-0','00000654','2025-11-15',' 10:49:19','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-14-0' AND kode_barcode='00000662'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-14-0','00000662','2025-11-15',' 10:50:02','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-12-0' AND kode_barcode='00000660'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-12-0','00000660','2025-11-15',' 10:50:08','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-10-0' AND kode_barcode='00000658'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-10-0','00000658','2025-11-15',' 10:50:20','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-8-0' AND kode_barcode='00000656'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-8-0','00000656','2025-11-15',' 10:50:27','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-11-0' AND kode_barcode='00000659'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-11-0','00000659','2025-11-15',' 10:50:34','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-13-0' AND kode_barcode='00000661'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-13-0','00000661','2025-11-15',' 10:50:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-9-0' AND kode_barcode='00000657'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-9-0','00000657','2025-11-15',' 10:50:56','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-122-0' AND kode_barcode='00000770'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-122-0','00000770','2025-11-15',' 10:51:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-4-0' AND kode_barcode='00000652'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-4-0','00000652','2025-11-15',' 10:51:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCAD-5-0' AND kode_barcode='00014521'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCAD-5-0','00014521','2025-11-15',' 10:52:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-121-0' AND kode_barcode='00000769'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-121-0','00000769','2025-11-15',' 10:52:32','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WCAD-4-0' AND kode_barcode='00014520'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WCAD-4-0','00014520','2025-11-15',' 10:53:13','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-2-0' AND kode_barcode='00000650'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-2-0','00000650','2025-11-15',' 10:53:37','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-131-0' AND kode_barcode='00000779'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-131-0','00000779','2025-11-15',' 10:53:57','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-107-0' AND kode_barcode='00000755'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-107-0','00000755','2025-11-15',' 10:54:06','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-110-0' AND kode_barcode='00000758'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-110-0','00000758','2025-11-15',' 10:54:51','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UDXI-111-0' AND kode_barcode='00000759'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UDXI-111-0','00000759','2025-11-15',' 10:55:19','1','adminpusat'); DELETE FROM tt_barang_stock WHERE stock_fisik*1=0; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='BTKLMT' AND stock_on_hand*1 =1 AND harga_jual*1 > 0; UPDATE tt_barang_stock SET tgl_taking= '2025-11-15',jam_taking= '10:58:20',input_by='adminpusat'; DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VDBC-33-0' AND kode_barcode='00009012'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VDBC-33-0','00009012','2025-11-15',' 10:58:24','1','adminpusat'); INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('adminpusat','2025-11-15 11:04:24'); CREATE TABLE th_20251115_110424 SELECT * FROM tt_barang_stock; CREATE TABLE th_20251115_110424_lebih SELECT * FROM tt_barang_stock_lebih; DELETE FROM tt_barang_stock; DELETE FROM tt_barang_stock_lebih; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-11-15 ','11:04:58'); INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('adminpusat','2025-11-15 11:05:27'); CREATE TABLE th_20251115_110527 SELECT * FROM tt_barang_stock; CREATE TABLE th_20251115_110527_lebih SELECT * FROM tt_barang_stock_lebih; DELETE FROM tt_barang_stock; DELETE FROM tt_barang_stock_lebih; DELETE FROM tt_barang_stock WHERE stock_fisik*1=0; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='BTMF' AND stock_on_hand*1 =1 AND harga_jual*1 > 0; UPDATE tt_barang_stock SET tgl_taking= '2025-11-15',jam_taking= '11:06:01',input_by='adminpusat'; DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-XDBD-5-0' AND kode_barcode='00020099'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-XDBD-5-0','00020099','2025-11-15',' 11:06:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-XBBG-64-0' AND kode_barcode='00019168'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-XBBG-64-0','00019168','2025-11-15',' 11:06:34','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-XBBG-63-0' AND kode_barcode='00019167'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-XBBG-63-0','00019167','2025-11-15',' 11:06:40','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-XKXD-56-0' AND kode_barcode='00021409'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-XKXD-56-0','00021409','2025-11-15',' 11:06:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-XCBC-46-0' AND kode_barcode='00019849'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-XCBC-46-0','00019849','2025-11-15',' 11:06:52','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-UJAE-50-0' AND kode_barcode='00005123'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-UJAE-50-0','00005123','2025-11-15',' 11:07:02','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-UJXF-58-0' AND kode_barcode='00005000'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-UJXF-58-0','00005000','2025-11-15',' 11:07:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WIAF-48-0' AND kode_barcode='00017620'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WIAF-48-0','00017620','2025-11-15',' 11:07:15','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-XBBG-65-0' AND kode_barcode='00019169'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-XBBG-65-0','00019169','2025-11-15',' 11:07:30','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-VCAF-35-0' AND kode_barcode='00006862'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-VCAF-35-0','00006862','2025-11-15',' 11:07:35','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-WHAB-48-0' AND kode_barcode='00017132'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-WHAB-48-0','00017132','2025-11-15',' 11:07:42','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-WGBD-62-0' AND kode_barcode='00016722'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-WGBD-62-0','00016722','2025-11-15',' 11:07:46','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-YCBF-2-0' AND kode_barcode='00024459'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-YCBF-2-0','00024459','2025-11-15',' 11:07:58','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-VKXC-56-0' AND kode_barcode='00011822'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-VKXC-56-0','00011822','2025-11-15',' 11:08:01','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-VCAF-36-0' AND kode_barcode='00006863'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-VCAF-36-0','00006863','2025-11-15',' 11:08:04','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-UFBI-16-0' AND kode_barcode='00004142'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-UFBI-16-0','00004142','2025-11-15',' 11:08:07','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-XBBG-67-0' AND kode_barcode='00019171'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-XBBG-67-0','00019171','2025-11-15',' 11:08:10','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-YCBF-6-0' AND kode_barcode='00024463'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-YCBF-6-0','00024463','2025-11-15',' 11:08:14','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGL-YCBF-7-0' AND kode_barcode='00024464'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGL-YCBF-7-0','00024464','2025-11-15',' 11:08:16','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-ULBB-42-0' AND kode_barcode='00005849'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-ULBB-42-0','00005849','2025-11-15',' 11:08:19','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGL-YCBF-10-0' AND kode_barcode='00024467'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGL-YCBF-10-0','00024467','2025-11-15',' 11:08:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGL-XDXD-45-0' AND kode_barcode='00020027'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGL-XDXD-45-0','00020027','2025-11-15',' 11:08:25','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-YCBF-4-0' AND kode_barcode='00024461'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-YCBF-4-0','00024461','2025-11-15',' 11:09:23','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGL-VDXH-48-0' AND kode_barcode='00007147'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGL-VDXH-48-0','00007147','2025-11-15',' 11:09:29','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGW-VDXH-49-0' AND kode_barcode='00007148'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGW-VDXH-49-0','00007148','2025-11-15',' 11:09:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VDXH-50-0' AND kode_barcode='00007149'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VDXH-50-0','00007149','2025-11-15',' 11:09:43','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-VDXH-46-0' AND kode_barcode='00007145'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-VDXH-46-0','00007145','2025-11-15',' 11:09:48','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGL-VDXH-45-0' AND kode_barcode='00007144'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGL-VDXH-45-0','00007144','2025-11-15',' 11:09:50','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGW-VDXH-44-0' AND kode_barcode='00007143'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGW-VDXH-44-0','00007143','2025-11-15',' 11:09:59','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-VDXH-43-0' AND kode_barcode='00007142'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-VDXH-43-0','00007142','2025-11-15',' 11:10:03','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-YCBF-1-0' AND kode_barcode='00024458'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-YCBF-1-0','00024458','2025-11-15',' 11:10:06','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-YCBF-3-0' AND kode_barcode='00024460'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-YCBF-3-0','00024460','2025-11-15',' 11:10:09','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-VDXH-47-0' AND kode_barcode='00007146'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-VDXH-47-0','00007146','2025-11-15',' 11:10:12','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTCN-YCBF-5-0' AND kode_barcode='00024462'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTCN-YCBF-5-0','00024462','2025-11-15',' 11:10:27','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGW-YCBF-12-0' AND kode_barcode='00024469'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGW-YCBF-12-0','00024469','2025-11-15',' 11:10:33','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTKL-YCBF-13-0' AND kode_barcode='00024470'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTKL-YCBF-13-0','00024470','2025-11-15',' 11:10:37','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGL-YCBF-9-0' AND kode_barcode='00024466'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGL-YCBF-9-0','00024466','2025-11-15',' 11:10:53','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGL-VDXF-40-0' AND kode_barcode='00007099'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGL-VDXF-40-0','00007099','2025-11-15',' 11:11:00','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGL-WCBG-122-0' AND kode_barcode='00014928'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGL-WCBG-122-0','00014928','2025-11-15',' 11:11:04','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGL-YCBF-11-0' AND kode_barcode='00024468'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGL-YCBF-11-0','00024468','2025-11-15',' 11:11:06','1','adminpusat'); DELETE FROM tt_barang_stock WHERE kode_barang='MTGL-YCBF-8-0' AND kode_barcode='00024465'; INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('MTGL-YCBF-8-0','00024465','2025-11-15',' 11:11:49','1','adminpusat'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-251115-0001','sales','1',' ','TOKO','BTGLMT','MTGL-VLBI-94-0','GL VIGARU VAR 17CM KKT PER SHB ','','4.420','1','100.00','7647000','0','0','0','7647000','0','0','0','7647000','2503','00013097','MTGL','208000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-VLBI-94-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.420',berat_jual_asli=berat_jual_asli+'4.420',stock_jual='1',berat_akhir=berat_akhir-'4.420',berat_akhir_asli=berat_akhir_asli-'4.420',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='MTGL-VLBI-94-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-251115-0001','2025-11-15','4.420','2025-11-15','13:32:39','PLG0017543','7647000','7647000','0','7647000','7647000','sales','2025-11-15 13:32:39','FJ-251115-0001'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-15','FJ-251115-0001','2025-11-15','13:32:39','2503','7647000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251115-0003','D','2025-11-15','13:32:39','sales','PENJUALAN','FJ-251115-0001','207409329','7647000','215056329'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0001'; INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008986','X-00008986','CN COR BT SHB','GR','---','MTCN','BELI','BELI001','2663500','2025-11-15','1.750','1','sales','2025-11-15 14:18:56'); DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN'; INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00008986','X-00008986'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251115-0002','FJ-220204-0014','2105','1','BELI','BELI001','MTCN', 'X-00008986', 'CN COR BT SHB','1.810','1.750','100.00','1204000','2663500','1522000','1','2663500','2663500','MULUS'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.750',berat_beli_asli=berat_beli_asli+'1.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.750',berat_akhir_asli=berat_akhir_asli+'1.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-251115-0002','2025-11-15','2025-11-15','14:18:56','2105','---','1.750','2663500','2663500','2663500','2663500','2663500','sales','2025-11-15 14:18:56','FB-251115-0002','OPEN'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251115-0002','SILLA','ARIMBI 3/16','','','','sales','2025-11-15 14:18:56'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-15' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-251115-0004','K','2025-11-15','14:18:56','sales','PEMBELIAN UMUM','FB-251115-0002','215056329','2663500','212392829','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251115-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251115-0002'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-251115-0002','sales','1',' EX ','TOKO','BTCNMT','MTCN-WGBX-77-0','CN COR BT SHB ','','1.880','1','100.00','3252500','0','0','0','3252500','0','0','0','3252500','2402','00016427','MTCN','208000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-WGBX-77-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='MTCN-WGBX-77-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-251115-0002','2025-11-15','1.880','2025-11-15','15:15:48','PLG0017544','3252500','3252500','0','3252500','3252500','sales','2025-11-15 15:15:47','FJ-251115-0002'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-15','FJ-251115-0002','2025-11-15','15:15:48','2402','3252500','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251115-0005','D','2025-11-15','15:15:48','sales','PENJUALAN','FJ-251115-0002','212392829','3252500','215645329'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0002'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-251115-0003','sales','1',' EX ','TOKO','BTATMT','MTAT-YEXE-85-0','AT ITALY BT SHB ','','1.080','1','100.00','1868500','0','0','0','1868500','0','0','0','1868500','2105','00024913','MTAT','208000','0','-','0'); UPDATE tm_barang SET tgl_last_jual='2025-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-YEXE-85-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2025-11-15' AND kode_barang='MTAT-YEXE-85-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-251115-0003','2025-11-15','1.080','2025-11-15','15:24:55','PLG0017545','1868500','1868500','0','1868500','0','sales','2025-11-15 15:24:54','FJ-251115-0003'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-15','FJ-251115-0003','2025-11-15','15:24:55','2105','1868500','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251115-0001','2025-11-15','2025-11-15 15:24:54','PENJUALAN : FJ-251115-0003','bri','BCA','1868500','1868500','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251115-0002','D','2025-11-15','15:24:55','BCA','PENJUALAN','FJ-251115-0003','1422351657','1868500','1424220157','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bri','SITTI AMRIYATI'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1868500' WHERE no_faktur_jual='FJ-251115-0003' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251115-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251115-0003';