INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-22 ','08:13:49'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-22 ','08:19:47'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0001','1','PMM-ZJBA-6-0','1','3.490','3.490','TOKO','MMPER','TOKO','MMPER'); DELETE FROM tm_barang WHERE kode_barang='PMM-ZJBA-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZJBA-6-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PMM-ZJBA-6-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZJBA-6-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-10-22 08:20:04' WHERE kode_barang='PMM-ZJBA-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZJBA-6-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 08:20:04','TOKO','MMPER','PMM','PMM-ZJBA-6-0','1','3.490','3.490','1','3.490','3.490','100.00'); DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZJBA-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJBA-6-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0001','1','PMM-ZJBA-7-0','1','3.830','3.830','TOKO','MMPER','TOKO','MMPER'); DELETE FROM tm_barang WHERE kode_barang='PMM-ZJBA-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZJBA-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PMM-ZJBA-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZJBA-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-10-22 08:20:04' WHERE kode_barang='PMM-ZJBA-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZJBA-7-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 08:20:04','TOKO','MMPER','PMM','PMM-ZJBA-7-0','1','3.830','3.830','1','3.830','3.830','100.00'); DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZJBA-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJBA-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0001','1','PMM-ZJBA-8-0','1','4.040','4.040','TOKO','MMPER','TOKO','MMPER'); DELETE FROM tm_barang WHERE kode_barang='PMM-ZJBA-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZJBA-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PMM-ZJBA-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZJBA-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-10-22 08:20:04' WHERE kode_barang='PMM-ZJBA-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZJBA-8-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 08:20:04','TOKO','MMPER','PMM','PMM-ZJBA-8-0','1','4.040','4.040','1','4.040','4.040','100.00'); DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZJBA-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJBA-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261022-0001','2026-10-22','08:19','11.360','kasir','2026-10-22 08:20:03'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-22 ','08:59:10'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-22 ','10:01:40'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0002','1','PLJOG-ZJBX-76-0','1','2.990','2.990','TOKO','JOGPLD','TOKO','JOGPLD'); DELETE FROM tm_barang WHERE kode_barang='PLJOG-ZJBX-76-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLJOG-ZJBX-76-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PLJOG-ZJBX-76-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLJOG-ZJBX-76-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPLD',tgl_last_beli='2026-10-22 10:02:17' WHERE kode_barang='PLJOG-ZJBX-76-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PLJOG-ZJBX-76-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 10:02:17','TOKO','JOGPLD','PLJOG','PLJOG-ZJBX-76-0','1','2.990','','1','2.990','','17.00'); DELETE FROM tm_dept WHERE kode_dept='PLJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLJOG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLJOG-ZJBX-76-0'; DELETE FROM tm_barang_export WHERE kode_barang='PLJOG-ZJBX-76-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261022-0002','2026-10-22','10:01','2.990','jogja','2026-10-22 10:02:16'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-22 ','11:05:43'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-22 ','11:17:07'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-22 ','11:26:52'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-22 ','12:08:38'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-22 ','12:26:51'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04726','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','600000','0','600000','sz 16 YL-01 putih doff amplas','font vladimir grf Deulisnawati....Tedi','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261022-0001','2026-10-22','2026-10-22 12:26:57','PESANAN : DP-04726','.','TBC','600000','600000'); 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-261022-0002','D','2026-10-22','12:26:57','TBC','PESANAN','DP-04726','29747718464','600000','29748318464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04726','2026-10-22','2026-10-22','12:26:57','PLG0017725','SULIS','2026-11-20','kasirbip','2026-10-22 12:26:57','2.000','0','0','0','600000','0','0','600000','600000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-22 ','12:28:07'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04727','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','sz 14 putih glossy','font vladimir grf Tedi....Deulsinawati','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261022-0002','2026-10-22','2026-10-22 12:28:51','PESANAN : DP-04727','.','TBC','1000000','1000000'); 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-261022-0003','D','2026-10-22','12:28:51','TBC','PESANAN','DP-04727','29748318464','1000000','29749318464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04727','2026-10-22','2026-10-22','12:28:51','PLG0017726','SULIS','2026-11-20','kasirbip','2026-10-22 12:28:51','2.000','0','0','0','1000000','0','0','1000000','1000000','0'); 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,keterangan) VALUES ('FJ-261022-0001','kasirbip','1',' 950K-14-00','TOKO','DUPERBDG','LXPER-ZGBA-71-0','CINCIN SILVER 925 ','','2.890','1','100.00','295000','0','0','17800','1050000','0','0','0','1050000','MIL','00045464','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZGBA-71-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.890',berat_jual_asli=berat_jual_asli+'2.890',stock_jual='1',berat_akhir=berat_akhir-'2.890',berat_akhir_asli=berat_akhir_asli-'2.890',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='LXPER-ZGBA-71-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0001','2026-10-22','2.890','2026-10-22','12:30:14','PLG0017727','1050000','1050000','0','1050000','0','kasirbip','2026-10-22 12:30:13','FJ-261022-0001','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0001','2026-10-22','12:30:14','MIL','1050000','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-261022-0003','2026-10-22','2026-10-22 12:30:13','PENJUALAN : FJ-261022-0001','.','TBC','1050000','1050000','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-261022-0004','D','2026-10-22','12:30:14','TBC','PENJUALAN','FJ-261022-0001','29749318464','1050000','29750368464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1050000' WHERE no_faktur_jual='FJ-261022-0001' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0002','kasirbip',' 1',' 800K-18-00','TOKO','DUPERBDG','LXPER-ZIAF-42-0','CINCIN SILVER 925 YL10 ','','4.370','1','100.00','446000','0','0','17800','1000000','0','0','0','1000000','MIL','00047274','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZIAF-42-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.370',berat_jual_asli=berat_jual_asli+'4.370',stock_jual='1',berat_akhir=berat_akhir-'4.370',berat_akhir_asli=berat_akhir_asli-'4.370',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='LXPER-ZIAF-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0002','2026-10-22','4.370','2026-10-22','12:30:14','PLG0017728','1000000','1000000','0','1000000','0','kasirbip','2026-10-22 12:30:13','FJ-261022-0001','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0002','2026-10-22','12:30:14','MIL','1000000','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-261022-0004','2026-10-22','2026-10-22 12:30:13','PENJUALAN : FJ-261022-0002','.','TBC','1000000','1000000','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-261022-0005','D','2026-10-22','12:30:14','TBC','PENJUALAN','FJ-261022-0002','29750368464','1000000','29751368464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2050000' WHERE no_faktur_jual='FJ-261022-0002' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0003','sby','1',' 800K-20-00','TOKO','SBYPER','PSBY-ZJAI-76-0','CINCIN SILVER 925 ','','2.750','1','100.00','281000','0','0','17800','900000','0','0','0','900000','VAN','00048320','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJAI-76-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.750',berat_jual_asli=berat_jual_asli+'2.750',stock_jual='1',berat_akhir=berat_akhir-'2.750',berat_akhir_asli=berat_akhir_asli-'2.750',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSBY-ZJAI-76-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0003','2026-10-22','2.750','2026-10-22','12:30:22','PLG0017729','900000','900000','0','900000','0','sby','2026-10-22 12:30:22','FJ-261022-0003','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0003','2026-10-22','12:30:22','VAN','900000','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-261022-0005','2026-10-22','2026-10-22 12:30:22','PENJUALAN : FJ-261022-0003','','TBC','900000','900000','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-261022-0006','D','2026-10-22','12:30:22','TBC','PENJUALAN','FJ-261022-0003','29751368464','900000','29752268464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261022-0003' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0004','sby',' 1',' 950K-145-0','TOKO','SBYPER','PSBY-ZJXE-19-0','CINCIN SILVER 925 ','','2.100','1','100.00','215000','0','0','17800','1050000','0','0','0','1050000','VAN','00047904','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJXE-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSBY-ZJXE-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0004','2026-10-22','2.100','2026-10-22','12:30:22','PLG0017730','1050000','1050000','0','1050000','0','sby','2026-10-22 12:30:22','FJ-261022-0003','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0004','2026-10-22','12:30:22','VAN','1050000','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-261022-0006','2026-10-22','2026-10-22 12:30:22','PENJUALAN : FJ-261022-0004','','TBC','1050000','1050000','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-261022-0007','D','2026-10-22','12:30:22','TBC','PENJUALAN','FJ-261022-0004','29752268464','1050000','29753318464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1950000' WHERE no_faktur_jual='FJ-261022-0004' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0005','sby','1',' 600K-12-00','TOKO','SBYPER','PSBY-ZDCX-58-0','CINCIN SILVER 925 ','','1.430','1','100.00','146000','0','0','17800','700000','0','0','0','700000','VAN','00043015','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZDCX-58-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSBY-ZDCX-58-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0005','2026-10-22','1.430','2026-10-22','12:32:13','PLG0017731','700000','700000','0','700000','0','sby','2026-10-22 12:32:12','FJ-261022-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0005','2026-10-22','12:32:13','VAN','700000','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-261022-0007','2026-10-22','2026-10-22 12:32:12','PENJUALAN : FJ-261022-0005','','TBC','700000','700000','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-261022-0008','D','2026-10-22','12:32:13','TBC','PENJUALAN','FJ-261022-0005','29753318464','700000','29754018464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-261022-0005' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0006','sby',' 1',' 800K-19-00','TOKO','SBYPER','PSBY-ZJAI-77-0','CINCIN SILVER 925 ','','2.940','1','100.00','300000','0','0','17800','900000','0','0','0','900000','VAN','00048321','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJAI-77-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.940',berat_jual_asli=berat_jual_asli+'2.940',stock_jual='1',berat_akhir=berat_akhir-'2.940',berat_akhir_asli=berat_akhir_asli-'2.940',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSBY-ZJAI-77-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0006','2026-10-22','2.940','2026-10-22','12:32:13','PLG0017732','900000','900000','0','900000','0','sby','2026-10-22 12:32:12','FJ-261022-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0006','2026-10-22','12:32:13','VAN','900000','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-261022-0008','2026-10-22','2026-10-22 12:32:12','PENJUALAN : FJ-261022-0006','','TBC','900000','900000','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-261022-0009','D','2026-10-22','12:32:13','TBC','PENJUALAN','FJ-261022-0006','29754018464','900000','29754918464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1600000' WHERE no_faktur_jual='FJ-261022-0006' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-22 ','13:56:08'); 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,keterangan) VALUES ('FJ-261022-0007','kasir','1',' 850K-95 ','TOKO','MMCM','CMMM-ZDBI-37-0','CINCIN MAS MM ','','1.240','1','45.00','1367000','0','0','17800','2736000','0','0','0','2736000','ALIKA','00042935','CMMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CMMM-ZDBI-37-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.240',berat_jual_asli=berat_jual_asli+'1.240',stock_jual='1',berat_akhir=berat_akhir-'1.240',berat_akhir_asli=berat_akhir_asli-'1.240',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='CMMM-ZDBI-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMCM' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0007','2026-10-22','1.240','2026-10-22','13:57:14','PLG0017733','2736000','2736000','0','2736000','0','kasir','2026-10-22 13:57:14','FJ-261022-0007','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0007','2026-10-22','13:57:14','ALIKA','2736000','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-261022-0009','2026-10-22','2026-10-22 13:57:14','PENJUALAN : FJ-261022-0007','.','TBC','2736000','2736000','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-261022-0010','D','2026-10-22','13:57:14','TBC','PENJUALAN','FJ-261022-0007','29754918464','2736000','29757654464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2736000' WHERE no_faktur_jual='FJ-261022-0007' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0008','kasir',' 1',' PLDMM-0005','TOKO','MMPLD','PLDMM-ZJBX-69-0','CINCIN PALADIUM PLDMM-00052 ','','2.950','1','17.00','663000','0','0','17800','1932500','0','0','0','1932500','ALIKA','00048402','PLDMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZJBX-69-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PLDMM-ZJBX-69-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0008','2026-10-22','2.950','2026-10-22','13:57:14','PLG0017734','1932500','1932500','0','1932500','0','kasir','2026-10-22 13:57:14','FJ-261022-0007','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0008','2026-10-22','13:57:14','ALIKA','1932500','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-261022-0010','2026-10-22','2026-10-22 13:57:14','PENJUALAN : FJ-261022-0008','.','TBC','1932500','1932500','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-261022-0011','D','2026-10-22','13:57:14','TBC','PENJUALAN','FJ-261022-0008','29757654464','1932500','29759586964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='4668500' WHERE no_faktur_jual='FJ-261022-0008' LIMIT 1; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0003','1','PSPRT-ZJBX-65-0','1','4.370','4.370','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBX-65-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-65-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBX-65-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBX-65-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-22 14:10:03' WHERE kode_barang='PSPRT-ZJBX-65-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBX-65-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 14:10:03','TOKO','SBYPSN','PSPRT','PSPRT-ZJBX-65-0','1','4.370','4.370','1','4.370','4.370','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBX-65-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-65-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0003','1','PSPRT-ZJBX-82-0','1','4.850','4.850','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBX-82-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-82-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBX-82-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBX-82-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-22 14:10:03' WHERE kode_barang='PSPRT-ZJBX-82-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBX-82-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 14:10:03','TOKO','SBYPSN','PSPRT','PSPRT-ZJBX-82-0','1','4.850','4.850','1','4.850','4.850','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBX-82-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-82-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0003','1','PSPRT-ZJBX-83-0','1','3.240','3.240','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBX-83-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-83-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBX-83-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBX-83-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-22 14:10:03' WHERE kode_barang='PSPRT-ZJBX-83-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBX-83-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 14:10:03','TOKO','SBYPSN','PSPRT','PSPRT-ZJBX-83-0','1','3.240','3.240','1','3.240','3.240','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBX-83-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-83-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0003','1','PSPRT-ZJBX-84-0','1','2.950','2.950','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBX-84-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-84-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBX-84-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBX-84-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-22 14:10:03' WHERE kode_barang='PSPRT-ZJBX-84-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBX-84-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 14:10:03','TOKO','SBYPSN','PSPRT','PSPRT-ZJBX-84-0','1','2.950','2.950','1','2.950','2.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBX-84-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-84-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0003','1','PSPRT-ZJBX-91-0','1','3.380','3.380','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBX-91-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-91-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBX-91-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBX-91-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-22 14:10:03' WHERE kode_barang='PSPRT-ZJBX-91-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBX-91-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 14:10:03','TOKO','SBYPSN','PSPRT','PSPRT-ZJBX-91-0','1','3.380','3.380','1','3.380','3.380','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBX-91-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-91-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0003','1','PSPRT-ZJBX-97-0','1','2.370','2.370','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBX-97-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-97-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBX-97-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBX-97-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-22 14:10:03' WHERE kode_barang='PSPRT-ZJBX-97-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBX-97-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 14:10:03','TOKO','SBYPSN','PSPRT','PSPRT-ZJBX-97-0','1','2.370','2.370','1','2.370','2.370','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBX-97-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBX-97-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261022-0003','2026-10-22','13:49','21.160','sby','2026-10-22 14:10:02'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0004','1','PLSBY-ZJBX-74-0','1','2.360','2.360','TOKO','SBYPLD','TOKO','SBYPLD'); DELETE FROM tm_barang WHERE kode_barang='PLSBY-ZJBX-74-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLSBY-ZJBX-74-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PLSBY-ZJBX-74-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLSBY-ZJBX-74-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPLD',tgl_last_beli='2026-10-22 14:14:57' WHERE kode_barang='PLSBY-ZJBX-74-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PLSBY-ZJBX-74-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 14:14:57','TOKO','SBYPLD','PLSBY','PLSBY-ZJBX-74-0','1','2.360','2.360','1','2.360','2.360','17.00'); DELETE FROM tm_dept WHERE kode_dept='PLSBY' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLSBY' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLSBY-ZJBX-74-0'; DELETE FROM tm_barang_export WHERE kode_barang='PLSBY-ZJBX-74-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0004','1','PLSBY-ZJBX-75-0','1','3.020','3.020','TOKO','SBYPLD','TOKO','SBYPLD'); DELETE FROM tm_barang WHERE kode_barang='PLSBY-ZJBX-75-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PLSBY-ZJBX-75-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PLSBY-ZJBX-75-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PLSBY-ZJBX-75-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPLD',tgl_last_beli='2026-10-22 14:14:57' WHERE kode_barang='PLSBY-ZJBX-75-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PLSBY-ZJBX-75-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 14:14:57','TOKO','SBYPLD','PLSBY','PLSBY-ZJBX-75-0','1','3.020','3.020','1','3.020','3.020','17.00'); DELETE FROM tm_dept WHERE kode_dept='PLSBY' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PLSBY' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PLSBY-ZJBX-75-0'; DELETE FROM tm_barang_export WHERE kode_barang='PLSBY-ZJBX-75-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261022-0004','2026-10-22','14:14','5.380','sby','2026-10-22 14:14:57'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-22 ','16:02:21'); 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,keterangan) VALUES ('FJ-261022-0009','kasirbip','1',' PLBDG-0016','TOKO','BIPPLD','PLBDG-ZJXG-10-0','CINCIN PALADIUM PLBDG-00169 ','','2.440','1','17.00','548000','0','0','17800','1500000','0','0','0','1500000','KUR','00047971','PLBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZJXG-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.440',berat_jual_asli=berat_jual_asli+'2.440',stock_jual='1',berat_akhir=berat_akhir-'2.440',berat_akhir_asli=berat_akhir_asli-'2.440',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PLBDG-ZJXG-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0009','2026-10-22','2.440','2026-10-22','16:02:20','PLG0017735','1500000','1500000','0','1500000','0','kasirbip','2026-10-22 16:02:19','FJ-261022-0009','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0009','2026-10-22','16:02:20','KUR','1500000','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-261022-0011','2026-10-22','2026-10-22 16:02:19','PENJUALAN : FJ-261022-0009','.','TBC','1500000','1500000','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-261022-0012','D','2026-10-22','16:02:20','TBC','PENJUALAN','FJ-261022-0009','29759586964','1500000','29761086964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1500000' WHERE no_faktur_jual='FJ-261022-0009' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0009'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-22 ','16:12:01'); 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,keterangan) VALUES ('FJ-261022-0010','jogja','1',' DP-04625JO','TOKO','JOGPSN','PSPRT-ZJBX-95-0','CINCIN PERAK ','','3.840','1','100.00','392000','0','0','17800','950000','0','0','0','950000','DEW','00048428','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBX-95-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.840',berat_jual_asli=berat_jual_asli+'3.840',stock_jual='1',berat_akhir=berat_akhir-'3.840',berat_akhir_asli=berat_akhir_asli-'3.840',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSPRT-ZJBX-95-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0010','2026-10-22','3.840','2026-10-22','16:24:54','PLG0017736','950000','950000','0','950000','0','jogja','2026-10-22 16:24:54','FJ-261022-0010','DP-04625','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0010','2026-10-22','16:24:54','DEW','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261022-0010' LIMIT 1; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0005','1','PSPRT-ZJBA-23-0','1','2.250','2.250','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-23-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-23-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-23-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-23-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-22 16:33:25' WHERE kode_barang='PSPRT-ZJBA-23-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-23-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:33:25','TOKO','DUPSN','PSPRT','PSPRT-ZJBA-23-0','1','2.250','2.250','1','2.250','2.250','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-23-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-23-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0005','1','PSPRT-ZJBA-24-0','1','2.290','2.290','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-24-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-24-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-24-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-24-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-22 16:33:25' WHERE kode_barang='PSPRT-ZJBA-24-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-24-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:33:25','TOKO','DUPSN','PSPRT','PSPRT-ZJBA-24-0','1','2.290','2.290','1','2.290','2.290','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-24-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-24-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0005','1','PSPRT-ZJBA-25-0','1','1.210','1.210','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-25-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-25-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-25-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-25-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-22 16:33:25' WHERE kode_barang='PSPRT-ZJBA-25-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-25-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:33:25','TOKO','DUPSN','PSPRT','PSPRT-ZJBA-25-0','1','1.210','1.210','1','1.210','1.210','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-25-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-25-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0005','1','PSPRT-ZJBA-35-0','1','2.550','2.550','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-35-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-35-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-35-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-22 16:33:25' WHERE kode_barang='PSPRT-ZJBA-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-35-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:33:25','TOKO','DUPSN','PSPRT','PSPRT-ZJBA-35-0','1','2.550','2.550','1','2.550','2.550','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-35-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0005','1','PSPRT-ZJBA-36-0','1','2.780','2.780','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-36-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-36-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-36-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-22 16:33:25' WHERE kode_barang='PSPRT-ZJBA-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-36-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:33:25','TOKO','DUPSN','PSPRT','PSPRT-ZJBA-36-0','1','2.780','2.780','1','2.780','2.780','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-36-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0005','1','PSPRT-ZJBA-37-0','1','4.830','4.830','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-37-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-37-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-37-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-22 16:33:25' WHERE kode_barang='PSPRT-ZJBA-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-37-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:33:25','TOKO','DUPSN','PSPRT','PSPRT-ZJBA-37-0','1','4.830','4.830','1','4.830','4.830','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-37-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261022-0005','2026-10-22','16:25','15.910','kasirbip','2026-10-22 16:33:24'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0006','1','LXPER-ZJBA-13-0','1','3.410','3.410','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBA-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBA-13-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBA-13-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBA-13-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-22 16:40:09' WHERE kode_barang='LXPER-ZJBA-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBA-13-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:40:09','TOKO','DUPERBDG','LXPER','LXPER-ZJBA-13-0','1','3.410','3.410','1','3.410','3.410','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBA-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBA-13-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0006','1','LXPER-ZJBA-14-0','1','3.430','3.430','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBA-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBA-14-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBA-14-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBA-14-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-22 16:40:09' WHERE kode_barang='LXPER-ZJBA-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBA-14-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:40:09','TOKO','DUPERBDG','LXPER','LXPER-ZJBA-14-0','1','3.430','3.430','1','3.430','3.430','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBA-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBA-14-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0006','1','LXPER-ZJBA-15-0','1','3.800','3.800','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBA-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBA-15-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBA-15-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBA-15-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-22 16:40:09' WHERE kode_barang='LXPER-ZJBA-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBA-15-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:40:09','TOKO','DUPERBDG','LXPER','LXPER-ZJBA-15-0','1','3.800','3.800','1','3.800','3.800','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBA-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBA-15-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0006','1','LXPER-ZJBA-16-0','1','3.870','3.870','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJBA-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJBA-16-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJBA-16-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBA-16-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-22 16:40:09' WHERE kode_barang='LXPER-ZJBA-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJBA-16-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:40:09','TOKO','DUPERBDG','LXPER','LXPER-ZJBA-16-0','1','3.870','3.870','1','3.870','3.870','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJBA-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBA-16-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261022-0006','2026-10-22','16:33','14.510','kasirbip','2026-10-22 16:40:08'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0007','1','PBDG-ZJBA-9-0','1','3.450','3.450','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJBA-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJBA-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJBA-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJBA-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-22 16:53:28' WHERE kode_barang='PBDG-ZJBA-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJBA-9-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:53:28','TOKO','BIPPER','PBDG','PBDG-ZJBA-9-0','1','3.450','3.450','1','3.450','3.450','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJBA-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJBA-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0007','1','PBDG-ZJBA-10-0','1','3.530','3.530','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJBA-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJBA-10-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJBA-10-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJBA-10-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-22 16:53:28' WHERE kode_barang='PBDG-ZJBA-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJBA-10-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:53:28','TOKO','BIPPER','PBDG','PBDG-ZJBA-10-0','1','3.530','3.530','1','3.530','3.530','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJBA-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJBA-10-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0007','1','PBDG-ZJBA-11-0','1','3.790','3.790','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJBA-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJBA-11-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJBA-11-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJBA-11-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-22 16:53:28' WHERE kode_barang='PBDG-ZJBA-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJBA-11-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:53:28','TOKO','BIPPER','PBDG','PBDG-ZJBA-11-0','1','3.790','3.790','1','3.790','3.790','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJBA-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJBA-11-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0007','1','PBDG-ZJBA-12-0','1','3.880','3.880','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJBA-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJBA-12-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJBA-12-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJBA-12-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-22 16:53:28' WHERE kode_barang='PBDG-ZJBA-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJBA-12-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:53:28','TOKO','BIPPER','PBDG','PBDG-ZJBA-12-0','1','3.880','3.880','1','3.880','3.880','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJBA-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJBA-12-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261022-0007','2026-10-22','16:53','14.650','kasirbip','2026-10-22 16:53:28'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0008','1','PSPRT-ZJBA-28-0','1','1.420','1.420','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-28-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-28-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-28-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-22 16:53:56' WHERE kode_barang='PSPRT-ZJBA-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-28-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:53:56','TOKO','BIPPSN','PSPRT','PSPRT-ZJBA-28-0','1','1.420','1.420','1','1.420','1.420','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-28-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0008','1','PSPLT-ZJBA-29-0','1','3.900','3.900','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBA-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBA-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBA-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBA-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-22 16:53:56' WHERE kode_barang='PSPLT-ZJBA-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBA-29-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:53:56','TOKO','BIPPSN','PSPLT','PSPLT-ZJBA-29-0','1','3.900','3.900','1','3.900','3.900','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJBA-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBA-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0008','1','PSGT-ZJBA-30-0','1','1.820','1.820','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJBA-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJBA-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJBA-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJBA-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-22 16:53:56' WHERE kode_barang='PSGT-ZJBA-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJBA-30-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:53:56','TOKO','BIPPSN','PSGT','PSGT-ZJBA-30-0','1','1.820','1.820','1','1.820','1.820','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZJBA-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJBA-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0008','1','PSGT-ZJBA-31-0','1','2.770','2.770','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJBA-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJBA-31-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJBA-31-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJBA-31-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-22 16:53:56' WHERE kode_barang='PSGT-ZJBA-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJBA-31-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:53:56','TOKO','BIPPSN','PSGT','PSGT-ZJBA-31-0','1','2.770','2.770','1','2.770','2.770','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZJBA-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJBA-31-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0008','1','PSGT-ZJBA-32-0','1','2.350','2.350','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJBA-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJBA-32-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJBA-32-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJBA-32-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-22 16:53:56' WHERE kode_barang='PSGT-ZJBA-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJBA-32-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:53:56','TOKO','BIPPSN','PSGT','PSGT-ZJBA-32-0','1','2.350','2.350','1','2.350','2.350','57.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZJBA-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJBA-32-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0008','1','PSPLT-ZJBA-33-0','1','3.050','3.050','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJBA-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBA-33-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJBA-33-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBA-33-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-22 16:53:56' WHERE kode_barang='PSPLT-ZJBA-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJBA-33-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:53:56','TOKO','BIPPSN','PSPLT','PSPLT-ZJBA-33-0','1','3.050','3.050','1','3.050','3.050','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJBA-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBA-33-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0008','1','PSPRT-ZJBA-34-0','1','1.910','1.910','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-34-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-34-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-34-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-22 16:53:56' WHERE kode_barang='PSPRT-ZJBA-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-34-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 16:53:56','TOKO','BIPPSN','PSPRT','PSPRT-ZJBA-34-0','1','1.910','1.910','1','1.910','1.910','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-34-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261022-0008','2026-10-22','16:53','17.220','kasirbip','2026-10-22 16:53:56'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04728','MIL','1','PER','WEDRING PROMO','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cwo 16 grf Sasa 23-11-26','sz cwe 9 grf Galih 23-11-26','font yeseva EXSPRESS 100.000','.','.','.'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261022-0012','2026-10-22','2026-10-22 17:58:57','PESANAN : DP-04728','.','TBC','950000','950000'); 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-261022-0013','D','2026-10-22','17:58:57','TBC','PESANAN','DP-04728','29761086964','950000','29762036964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04728','2026-10-22','2026-10-22','17:58:57','PLG0017737','MIL','2026-11-05','kasirbip','2026-10-22 17:58:57','3.000','0','0','0','950000','0','0','950000','950000','0'); 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,keterangan) VALUES ('FJ-261022-0011','kasirbip','1',' DP-04301DU','TOKO','DUPSN','PSPRT-ZJBX-93-0','CINCIN PERAK ','','2.000','1','100.00','204000','0','0','17800','950000','0','0','0','950000','MIL','00048426','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBX-93-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSPRT-ZJBX-93-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0011','2026-10-22','2.000','2026-10-22','18:04:07','PLG0017738','950000','950000','0','950000','0','kasirbip','2026-10-22 18:04:06','FJ-261022-0011','DP-04301','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0011','2026-10-22','18:04:07','MIL','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261022-0011' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0012','kasirbip','1',' 900K-11 ','TOKO','BIPCMP','BDCM-ZIXH-27-0','CINCIN EMAS ','','1.370','1','45.00','1510000','0','0','17800','2818000','0','0','0','2818000','SAL','00047040','BDCM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-ZIXH-27-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='BDCM-ZIXH-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0012','2026-10-22','1.370','2026-10-22','18:35:11','PLG0017739','2818000','2818000','0','2818000','0','kasirbip','2026-10-22 18:35:10','FJ-261022-0012','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0012','2026-10-22','18:35:11','SAL','2818000','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-261022-0013','2026-10-22','2026-10-22 18:35:10','PENJUALAN : FJ-261022-0012','.','TBC','2818000','2818000','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-261022-0014','D','2026-10-22','18:35:11','TBC','PENJUALAN','FJ-261022-0012','29762036964','2818000','29764854964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2818000' WHERE no_faktur_jual='FJ-261022-0012' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0013','kasirbip',' 1',' 800K-18-28','TOKO','BIPPER','PBDG-ZHXD-33-0','CINCIN SILVER 925 ','','3.970','1','100.00','405000','0','0','17800','900000','0','0','0','900000','SAL','00045872','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHXD-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.970',berat_jual_asli=berat_jual_asli+'3.970',stock_jual='1',berat_akhir=berat_akhir-'3.970',berat_akhir_asli=berat_akhir_asli-'3.970',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PBDG-ZHXD-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0013','2026-10-22','3.970','2026-10-22','18:35:11','PLG0017740','900000','900000','0','900000','0','kasirbip','2026-10-22 18:35:10','FJ-261022-0012','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0013','2026-10-22','18:35:11','SAL','900000','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-261022-0014','2026-10-22','2026-10-22 18:35:10','PENJUALAN : FJ-261022-0013','.','TBC','900000','900000','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-261022-0015','D','2026-10-22','18:35:11','TBC','PENJUALAN','FJ-261022-0013','29764854964','900000','29765754964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3718000' WHERE no_faktur_jual='FJ-261022-0013' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0014','kasirbip','1',' DP-04300DU','TOKO','DUPSN','PSPRT-ZJBX-88-0','1PS CINCIN PERAK ','','5.010','1','100.00','512000','0','0','17800','1400000','0','0','0','1400000','MIL','00048421','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBX-88-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.010',berat_jual_asli=berat_jual_asli+'5.010',stock_jual='1',berat_akhir=berat_akhir-'5.010',berat_akhir_asli=berat_akhir_asli-'5.010',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSPRT-ZJBX-88-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0014','2026-10-22','5.010','2026-10-22','19:06:19','PLG0017741','1400000','1400000','0','1400000','0','kasirbip','2026-10-22 19:06:19','FJ-261022-0014','DP-04300','1400000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0014','2026-10-22','19:06:19','MIL','1400000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261022-0014' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0015','kasirbip','1',' DP-04150BI','TOKO','BIPPSN','PSPLT-ZJAI-39-0','CINCIN PALADIUM ','','2.760','1','32.00','1166000','0','0','17800','2618000','0','0','0','2618000','SAL','00048283','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAI-39-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.760',berat_jual_asli=berat_jual_asli+'2.760',stock_jual='1',berat_akhir=berat_akhir-'2.760',berat_akhir_asli=berat_akhir_asli-'2.760',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSPLT-ZJAI-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0015','2026-10-22','2.760','2026-10-22','19:10:25','PLG0017742','2618000','2618000','0','2618000','0','kasirbip','2026-10-22 19:10:25','FJ-261022-0015','DP-04150','2200000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0015','2026-10-22','19:10:25','SAL','2618000','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-261022-0015','2026-10-22','2026-10-22 19:10:25','PENJUALAN : FJ-261022-0015','.','TBC','418000','418000','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-261022-0016','D','2026-10-22','19:10:25','TBC','PENJUALAN','FJ-261022-0015','29765754964','418000','29766172964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='418000' WHERE no_faktur_jual='FJ-261022-0015' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0016','kasirbip',' 1',' DP-04149BI','TOKO','BIPPSN','PSPLT-ZJAF-47-0','CINCIN PALADIUM ','','3.550','1','32.00','1500000','0','0','17800','2752500','0','0','0','2752500','SAL','00048244','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAF-47-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.550',berat_jual_asli=berat_jual_asli+'3.550',stock_jual='1',berat_akhir=berat_akhir-'3.550',berat_akhir_asli=berat_akhir_asli-'3.550',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSPLT-ZJAF-47-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0016','2026-10-22','3.550','2026-10-22','19:10:25','PLG0017743','2752500','2752500','0','2752500','0','kasirbip','2026-10-22 19:10:25','FJ-261022-0015','DP-04149','2180000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0016','2026-10-22','19:10:25','SAL','2752500','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-261022-0016','2026-10-22','2026-10-22 19:10:25','PENJUALAN : FJ-261022-0016','.','TBC','572500','572500','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-261022-0017','D','2026-10-22','19:10:25','TBC','PENJUALAN','FJ-261022-0016','29766172964','572500','29766745464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='990500' WHERE no_faktur_jual='FJ-261022-0016' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0016'; 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,keterangan) VALUES ('FJ-261022-0017','kasirbip','1',' DP-04220DU','TOKO','DUPSN','PSGT-ZJBX-86-0','CINCIN EMAS ','','2.620','1','45.00','2767000','0','0','17800','4418000','0','0','0','4418000','PUT','00048419','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBX-86-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.620',berat_jual_asli=berat_jual_asli+'2.620',stock_jual='1',berat_akhir=berat_akhir-'2.620',berat_akhir_asli=berat_akhir_asli-'2.620',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSGT-ZJBX-86-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0017','2026-10-22','2.620','2026-10-22','19:19:46','PLG0017744','4418000','4418000','0','4418000','0','kasirbip','2026-10-22 19:19:45','FJ-261022-0017','DP-04220','3400000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0017','2026-10-22','19:19:46','PUT','4418000','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-261022-0017','2026-10-22','2026-10-22 19:19:45','PENJUALAN : FJ-261022-0017','.','TBC','1018000','1018000','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-261022-0018','D','2026-10-22','19:19:46','TBC','PENJUALAN','FJ-261022-0017','29766745464','1018000','29767763464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1018000' WHERE no_faktur_jual='FJ-261022-0017' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0018','kasirbip',' 1',' DP-04221DU','TOKO','DUPSN','PSPLT-ZJAE-10-0','CINCIN PALADIUM ','','3.400','1','17.00','764000','0','0','17800','1940000','0','0','0','1940000','PUT','00048191','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAE-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.400',berat_jual_asli=berat_jual_asli+'3.400',stock_jual='1',berat_akhir=berat_akhir-'3.400',berat_akhir_asli=berat_akhir_asli-'3.400',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSPLT-ZJAE-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0018','2026-10-22','3.400','2026-10-22','19:19:46','PLG0017745','1940000','1940000','0','1940000','0','kasirbip','2026-10-22 19:19:45','FJ-261022-0017','DP-04221','1580000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0018','2026-10-22','19:19:46','PUT','1940000','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-261022-0018','2026-10-22','2026-10-22 19:19:45','PENJUALAN : FJ-261022-0018','.','TBC','360000','360000','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-261022-0019','D','2026-10-22','19:19:46','TBC','PENJUALAN','FJ-261022-0018','29767763464','360000','29768123464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1378000' WHERE no_faktur_jual='FJ-261022-0018' LIMIT 1; 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,keterangan) VALUES ('FJ-261022-0019','kasirbip','1',' DP-04320DU','TOKO','DUPSN','PSPRT-ZJBX-81-0','CINCIN PERAK SR01 YL01 ','','3.040','1','100.00','311000','0','0','17800','950000','0','0','0','950000','KUR','00048414','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBX-81-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.040',berat_jual_asli=berat_jual_asli+'3.040',stock_jual='1',berat_akhir=berat_akhir-'3.040',berat_akhir_asli=berat_akhir_asli-'3.040',stock_akhir='0' WHERE tanggal='2026-10-22' AND kode_barang='PSPRT-ZJBX-81-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-261022-0019','2026-10-22','3.040','2026-10-22','19:28:42','PLG0017746','950000','950000','0','950000','0','kasirbip','2026-10-22 19:28:42','FJ-261022-0019','DP-04320','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-22','FJ-261022-0019','2026-10-22','19:28:42','KUR','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261022-0019' LIMIT 1; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0009','1','PSPRT-ZJBA-26-0','1','2.840','2.840','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-26-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-26-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-26-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-22 20:11:33' WHERE kode_barang='PSPRT-ZJBA-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-26-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 20:11:33','TOKO','SBYPSN','PSPRT','PSPRT-ZJBA-26-0','1','2.840','2.840','1','2.840','2.840','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-26-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0009','1','PSPRT-ZJBA-39-0','1','2.900','2.900','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-39-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-39-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-39-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-39-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-22 20:11:33' WHERE kode_barang='PSPRT-ZJBA-39-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-39-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 20:11:33','TOKO','SBYPSN','PSPRT','PSPRT-ZJBA-39-0','1','2.900','2.900','1','2.900','2.900','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-39-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-39-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0009','1','PSPRT-ZJBA-40-0','1','3.860','3.860','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJBA-40-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-40-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJBA-40-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBA-40-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-22 20:11:33' WHERE kode_barang='PSPRT-ZJBA-40-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJBA-40-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 20:11:33','TOKO','SBYPSN','PSPRT','PSPRT-ZJBA-40-0','1','3.860','3.860','1','3.860','3.860','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJBA-40-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBA-40-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261022-0009','2026-10-22','20:08','9.600','sby','2026-10-22 20:11:33'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0010','1','PSBY-ZJBA-17-0','1','3.330','3.330','TOKO','SBYPER','TOKO','SBYPER'); DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJBA-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJBA-17-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJBA-17-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJBA-17-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-22 20:17:15' WHERE kode_barang='PSBY-ZJBA-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJBA-17-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 20:17:15','TOKO','SBYPER','PSBY','PSBY-ZJBA-17-0','1','3.330','3.330','1','3.330','3.330','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZJBA-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJBA-17-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0010','1','PSBY-ZJBA-18-0','1','3.340','3.340','TOKO','SBYPER','TOKO','SBYPER'); DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJBA-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJBA-18-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJBA-18-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJBA-18-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-22 20:17:15' WHERE kode_barang='PSBY-ZJBA-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJBA-18-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 20:17:15','TOKO','SBYPER','PSBY','PSBY-ZJBA-18-0','1','3.340','3.340','1','3.340','3.340','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZJBA-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJBA-18-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261022-0010','1','PSBY-ZJBA-19-0','1','3.780','3.780','TOKO','SBYPER','TOKO','SBYPER'); DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJBA-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJBA-19-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJBA-19-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJBA-19-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-22 20:17:15' WHERE kode_barang='PSBY-ZJBA-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJBA-19-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-22 20:17:15','TOKO','SBYPER','PSBY','PSBY-ZJBA-19-0','1','3.780','3.780','1','3.780','3.780','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZJBA-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJBA-19-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-22' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261022-0010','2026-10-22','20:16','10.450','sby','2026-10-22 20:17:14'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0018'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261022-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261022-0019'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-23','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-22'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-22'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-22'; 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='2026-10-22' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-22'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-22'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-22'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-22'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-23' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-22' 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-261023-0001','D','2026-10-23','21:04:12','TBC','SALDO AWAL','SALDO AWAL','0','29768123464','29768123464'); 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-261023-0001','D','2026-10-23','21:04:12','KET','SALDO AWAL','SALDO AWAL','0','148641000','148641000'); 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-261023-0001','D','2026-10-23','21:04:12','SHO','SALDO AWAL','SALDO AWAL','0','145485650','145485650'); 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-261023-0001','D','2026-10-23','21:04:12','BCD','SALDO AWAL','SALDO AWAL','0','1465961500','1465961500'); 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-261023-0001','D','2026-10-23','21:04:12','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000'); 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-261023-0001','D','2026-10-23','21:04:12','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); 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-261023-0001','D','2026-10-23','21:04:12','','SALDO AWAL','SALDO AWAL','0','250000','250000'); 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-261023-0001','D','2026-10-23','21:04:12','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000'); 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-261023-0001','D','2026-10-23','21:04:12','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); 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-261023-0001','D','2026-10-23','21:04:12','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); 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-261023-0001','D','2026-10-23','21:04:12','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); 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-261023-0001','D','2026-10-23','21:04:12','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); UPDATE tp_system SET tgl_system='2026-10-23'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-22 ','21:09:57'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-22 ','21:13:03');