INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-15 ','08:26: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-20261015-0001','1','PMM-ZJAD-20-0','1','2.070','2.070','TOKO','MMPER','TOKO','MMPER'); DELETE FROM tm_barang WHERE kode_barang='PMM-ZJAD-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZJAD-20-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PMM-ZJAD-20-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZJAD-20-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-10-15 08:26:48' WHERE kode_barang='PMM-ZJAD-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZJAD-20-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-15 08:26:48','TOKO','MMPER','PMM','PMM-ZJAD-20-0','1','2.070','2.070','1','2.070','2.070','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-ZJAD-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJAD-20-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0001','1','PMM-ZJAD-21-0','1','4.570','4.570','TOKO','MMPER','TOKO','MMPER'); DELETE FROM tm_barang WHERE kode_barang='PMM-ZJAD-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZJAD-21-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PMM-ZJAD-21-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZJAD-21-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-10-15 08:26:48' WHERE kode_barang='PMM-ZJAD-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZJAD-21-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-15 08:26:48','TOKO','MMPER','PMM','PMM-ZJAD-21-0','1','4.570','4.570','1','4.570','4.570','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-ZJAD-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJAD-21-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0001','1','PMM-ZJAD-22-0','1','4.320','4.320','TOKO','MMPER','TOKO','MMPER'); DELETE FROM tm_barang WHERE kode_barang='PMM-ZJAD-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZJAD-22-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PMM-ZJAD-22-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZJAD-22-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-10-15 08:26:48' WHERE kode_barang='PMM-ZJAD-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZJAD-22-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-15 08:26:48','TOKO','MMPER','PMM','PMM-ZJAD-22-0','1','4.320','4.320','1','4.320','4.320','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-ZJAD-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJAD-22-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0001','2026-10-15','08:26','10.960','kasir','2026-10-15 08:26: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-20261015-0002','1','PSGT-ZJAD-4-0','1','1.760','1.760','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJAD-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJAD-4-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJAD-4-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAD-4-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-15 08:27:11' WHERE kode_barang='PSGT-ZJAD-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJAD-4-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-15 08:27:11','TOKO','MMPSN','PSGT','PSGT-ZJAD-4-0','1','1.760','1.760','1','1.760','1.760','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-ZJAD-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAD-4-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0002','1','PSPRT-ZJAD-5-0','1','3.080','3.080','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-5-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-5-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-5-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-15 08:27:11' WHERE kode_barang='PSPRT-ZJAD-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-5-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-15 08:27:11','TOKO','MMPSN','PSPRT','PSPRT-ZJAD-5-0','1','3.080','3.080','1','3.080','3.080','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-ZJAD-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-5-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0002','1','PSPRT-ZJAD-6-0','1','3.570','3.570','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-6-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-6-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-6-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-15 08:27:11' WHERE kode_barang='PSPRT-ZJAD-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-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-15 08:27:11','TOKO','MMPSN','PSPRT','PSPRT-ZJAD-6-0','1','3.570','3.570','1','3.570','3.570','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-ZJAD-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-6-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0002','1','PSGT-ZJAD-37-0','1','2.540','2.540','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJAD-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJAD-37-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJAD-37-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAD-37-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-10-15 08:27:11' WHERE kode_barang='PSGT-ZJAD-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJAD-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-15 08:27:11','TOKO','MMPSN','PSGT','PSGT-ZJAD-37-0','1','2.540','2.540','1','2.540','2.540','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-ZJAD-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAD-37-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0002','2026-10-15','08:27','10.950','kasir','2026-10-15 08:27:10'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-15 ','08:45:09'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-15 ','09:53:24'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-15 ','09:55:04'); 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-261015-0001','jogja','1',' 850K-11-00','TOKO','JOGPER','PJOG-ZFAA-72-0','CINCIN SILVER 925 ','','1.070','1','100.00','110000','0','0','17800','1000000','0','0','0','1000000','DEW','00044271','PJOG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAA-72-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PJOG-ZFAA-72-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-261015-0001','2026-10-15','1.070','2026-10-15','10:02:40','PLG0017368','1000000','1000000','0','1000000','0','jogja','2026-10-15 10:02:39','FJ-261015-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-15','FJ-261015-0001','2026-10-15','10:02:40','DEW','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-261015-0001','2026-10-15','2026-10-15 10:02:39','PENJUALAN : FJ-261015-0001','','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-261015-0002','D','2026-10-15','10:02:40','TBC','PENJUALAN','FJ-261015-0001','29380657964','1000000','29381657964','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='1000000' WHERE no_faktur_jual='FJ-261015-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-261015-0002','jogja',' 1',' 800K-18-00','TOKO','JOGPER','PJOG-ZIBB-24-0','CINCIN SILVER 925 ','','3.520','1','100.00','360000','0','0','17800','1000000','0','0','0','1000000','DEW','00047457','PJOG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZIBB-24-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.520',berat_jual_asli=berat_jual_asli+'3.520',stock_jual='1',berat_akhir=berat_akhir-'3.520',berat_akhir_asli=berat_akhir_asli-'3.520',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PJOG-ZIBB-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-261015-0002','2026-10-15','3.520','2026-10-15','10:02:40','PLG0017369','1000000','1000000','0','1000000','0','jogja','2026-10-15 10:02:39','FJ-261015-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-15','FJ-261015-0002','2026-10-15','10:02:40','DEW','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-261015-0002','2026-10-15','2026-10-15 10:02:39','PENJUALAN : FJ-261015-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-261015-0003','D','2026-10-15','10:02:40','TBC','PENJUALAN','FJ-261015-0002','29381657964','1000000','29382657964','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='2000000' WHERE no_faktur_jual='FJ-261015-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0001'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-15 ','10:32:05'); 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-20261015-0003','1','PBDG-ZJAD-23-0','1','2.290','2.290','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJAD-23-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJAD-23-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJAD-23-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJAD-23-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-15 10:35:27' WHERE kode_barang='PBDG-ZJAD-23-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJAD-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-15 10:35:27','TOKO','BIPPER','PBDG','PBDG-ZJAD-23-0','1','2.290','2.290','1','2.290','2.290','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-ZJAD-23-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJAD-23-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0003','1','PBDG-ZJAD-24-0','1','1.940','1.940','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJAD-24-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJAD-24-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJAD-24-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJAD-24-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-15 10:35:27' WHERE kode_barang='PBDG-ZJAD-24-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJAD-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-15 10:35:27','TOKO','BIPPER','PBDG','PBDG-ZJAD-24-0','1','1.940','1.940','1','1.940','1.940','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-ZJAD-24-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJAD-24-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0003','1','PBDG-ZJAD-25-0','1','4.420','4.420','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJAD-25-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJAD-25-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJAD-25-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJAD-25-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-15 10:35:27' WHERE kode_barang='PBDG-ZJAD-25-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJAD-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-15 10:35:27','TOKO','BIPPER','PBDG','PBDG-ZJAD-25-0','1','4.420','4.420','1','4.420','4.420','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-ZJAD-25-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJAD-25-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0003','1','PBDG-ZJAD-26-0','1','4.420','4.420','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJAD-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJAD-26-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJAD-26-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJAD-26-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-15 10:35:27' WHERE kode_barang='PBDG-ZJAD-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJAD-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-15 10:35:27','TOKO','BIPPER','PBDG','PBDG-ZJAD-26-0','1','4.420','4.420','1','4.420','4.420','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-ZJAD-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJAD-26-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0003','2026-10-15','10:32','13.070','kasirbip','2026-10-15 10:35:27'); 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-20261015-0004','1','PSPRT-ZJAC-9-0','1','3.050','3.050','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAC-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAC-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAC-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAC-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-15 10:37:21' WHERE kode_barang='PSPRT-ZJAC-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAC-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-15 10:37:21','TOKO','BIPPSN','PSPRT','PSPRT-ZJAC-9-0','1','3.050','3.050','1','3.050','3.050','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-ZJAC-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAC-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0004','1','PSPRT-ZJAD-7-0','1','1.750','1.750','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-15 10:37:21' WHERE kode_barang='PSPRT-ZJAD-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-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-15 10:37:21','TOKO','BIPPSN','PSPRT','PSPRT-ZJAD-7-0','1','1.750','1.750','1','1.750','1.750','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-ZJAD-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0004','1','PSPLT-ZJAD-8-0','1','3.130','3.130','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAD-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAD-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAD-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-15 10:37:21' WHERE kode_barang='PSPLT-ZJAD-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAD-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-15 10:37:21','TOKO','BIPPSN','PSPLT','PSPLT-ZJAD-8-0','1','3.130','3.130','1','3.130','3.130','32.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-ZJAD-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0004','1','PSPRT-ZJAD-9-0','1','1.350','1.350','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-15 10:37:21' WHERE kode_barang='PSPRT-ZJAD-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-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-15 10:37:21','TOKO','BIPPSN','PSPRT','PSPRT-ZJAD-9-0','1','1.350','1.350','1','1.350','1.350','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-ZJAD-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0004','1','PSPRT-ZJAD-10-0','1','2.190','2.190','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-10-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-10-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-10-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-15 10:37:21' WHERE kode_barang='PSPRT-ZJAD-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-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-15 10:37:21','TOKO','BIPPSN','PSPRT','PSPRT-ZJAD-10-0','1','2.190','2.190','1','2.190','2.190','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-ZJAD-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-10-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0004','1','PSPRT-ZJAD-11-0','1','1.640','1.640','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-11-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-11-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-11-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-15 10:37:21' WHERE kode_barang='PSPRT-ZJAD-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-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-15 10:37:21','TOKO','BIPPSN','PSPRT','PSPRT-ZJAD-11-0','1','1.640','1.640','1','1.640','1.640','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-ZJAD-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-11-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0004','1','PSPRT-ZJAD-12-0','1','3.270','3.270','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-12-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-12-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-12-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-15 10:37:21' WHERE kode_barang='PSPRT-ZJAD-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-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-15 10:37:21','TOKO','BIPPSN','PSPRT','PSPRT-ZJAD-12-0','1','3.270','3.270','1','3.270','3.270','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-ZJAD-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-12-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0004','1','PSPRT-ZJAD-13-0','1','3.020','3.020','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-13-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-13-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-13-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-15 10:37:21' WHERE kode_barang='PSPRT-ZJAD-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-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-15 10:37:21','TOKO','BIPPSN','PSPRT','PSPRT-ZJAD-13-0','1','3.020','3.020','1','3.020','3.020','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-ZJAD-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-13-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0004','2026-10-15','10:35','19.400','kasirbip','2026-10-15 10:37:21'); UPDATE tt_service_head SET tgl_selesai='2026-10-15', status ='DONE' WHERE no_service='SV-02286'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02286'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-15 ','11:07:10'); 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-261015-0003','kasirbip','1',' DP-04315BI','TOKO','BIPPSN','PSPRT-ZJXI-24-0','1PS CINCIN PERAK ','','4.170','1','100.00','426000','0','0','17800','1500000','0','0','0','1500000','SULIS','00048070','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXI-24-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.170',berat_jual_asli=berat_jual_asli+'4.170',stock_jual='1',berat_akhir=berat_akhir-'4.170',berat_akhir_asli=berat_akhir_asli-'4.170',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPRT-ZJXI-24-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-261015-0003','2026-10-15','4.170','2026-10-15','11:11:15','PLG0017370','1500000','1500000','0','1500000','0','kasirbip','2026-10-15 11:11:15','FJ-261015-0003','DP-04315','1500000'); 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-15','FJ-261015-0003','2026-10-15','11:11:15','SULIS','1500000','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-261015-0003' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0003'; 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-261015-0004','kasirbip','1',' 800K-13-00','TOKO','DUPERBDG','LXPER-ZHAD-13-0','CINCIN SILVER 925 ','','1.180','1','100.00','121000','0','0','17800','900000','0','0','0','900000','PUT','00046161','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHAD-13-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='LXPER-ZHAD-13-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-261015-0004','2026-10-15','1.180','2026-10-15','11:11:48','PLG0017371','900000','900000','0','900000','0','kasirbip','2026-10-15 11:11:48','FJ-261015-0004','','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-15','FJ-261015-0004','2026-10-15','11:11:48','PUT','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-261015-0003','2026-10-15','2026-10-15 11:11:48','PENJUALAN : FJ-261015-0004','.','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-261015-0004','D','2026-10-15','11:11:48','TBC','PENJUALAN','FJ-261015-0004','29382657964','900000','29383557964','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-261015-0004' 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-20261015-0005','1','PSPLT-ZJAC-10-0','1','2.680','2.680','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAC-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAC-10-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAC-10-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAC-10-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSPLT-ZJAC-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAC-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-15 11:19:45','TOKO','DUPSN','PSPLT','PSPLT-ZJAC-10-0','1','2.680','2.680','1','2.680','2.680','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-ZJAC-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAC-10-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0005','1','PSPRT-ZJAD-14-0','1','2.340','2.340','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-14-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-14-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-14-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSPRT-ZJAD-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-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-15 11:19:45','TOKO','DUPSN','PSPRT','PSPRT-ZJAD-14-0','1','2.340','2.340','1','2.340','2.340','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-ZJAD-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-14-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0005','1','PSPLT-ZJAD-15-0','1','2.220','2.220','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAD-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-15-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAD-15-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAD-15-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSPLT-ZJAD-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAD-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-15 11:19:45','TOKO','DUPSN','PSPLT','PSPLT-ZJAD-15-0','1','2.220','2.220','1','2.220','2.220','32.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-ZJAD-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-15-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0005','1','PSPRT-ZJAD-16-0','1','2.910','2.910','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-16-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-16-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-16-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSPRT-ZJAD-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-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-15 11:19:45','TOKO','DUPSN','PSPRT','PSPRT-ZJAD-16-0','1','2.910','2.910','1','2.910','2.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-ZJAD-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-16-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0005','1','PSPRT-ZJAD-38-0','1','2.870','2.870','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-38-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-38-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-38-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-38-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSPRT-ZJAD-38-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-38-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-15 11:19:45','TOKO','DUPSN','PSPRT','PSPRT-ZJAD-38-0','1','2.870','2.870','1','2.870','2.870','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-ZJAD-38-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-38-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0005','1','PSPRT-ZJAD-39-0','1','2.060','2.060','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-39-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-39-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-39-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-39-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSPRT-ZJAD-39-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-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-15 11:19:45','TOKO','DUPSN','PSPRT','PSPRT-ZJAD-39-0','1','2.060','2.060','1','2.060','2.060','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-ZJAD-39-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-39-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0005','1','PSPLT-ZJAD-40-0','1','2.700','2.700','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAD-40-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-40-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAD-40-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAD-40-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSPLT-ZJAD-40-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAD-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-15 11:19:45','TOKO','DUPSN','PSPLT','PSPLT-ZJAD-40-0','1','2.700','2.700','1','2.700','2.700','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-ZJAD-40-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-40-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0005','1','PSPLT-ZJAD-41-0','1','3.120','3.120','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAD-41-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-41-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAD-41-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAD-41-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSPLT-ZJAD-41-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAD-41-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-15 11:19:45','TOKO','DUPSN','PSPLT','PSPLT-ZJAD-41-0','1','3.120','3.120','1','3.120','3.120','32.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-ZJAD-41-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-41-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0005','1','PSPLT-ZJAD-42-0','1','2.600','2.600','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAD-42-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-42-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAD-42-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAD-42-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSPLT-ZJAD-42-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAD-42-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-15 11:19:45','TOKO','DUPSN','PSPLT','PSPLT-ZJAD-42-0','1','2.600','2.600','1','2.600','2.600','32.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-ZJAD-42-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-42-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0005','1','PSPRT-ZJAD-43-0','1','1.870','1.870','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-43-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-43-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-43-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-43-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSPRT-ZJAD-43-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-43-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-15 11:19:45','TOKO','DUPSN','PSPRT','PSPRT-ZJAD-43-0','1','1.870','1.870','1','1.870','1.870','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-ZJAD-43-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-43-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0005','1','PSPLT-ZJAD-44-0','1','1.900','1.900','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAD-44-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-44-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAD-44-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAD-44-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSPLT-ZJAD-44-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAD-44-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-15 11:19:45','TOKO','DUPSN','PSPLT','PSPLT-ZJAD-44-0','1','1.900','1.900','1','1.900','1.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-ZJAD-44-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-44-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0005','1','PSGT-ZJAD-45-0','1','2.550','2.550','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJAD-45-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJAD-45-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJAD-45-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAD-45-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 11:19:45' WHERE kode_barang='PSGT-ZJAD-45-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJAD-45-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-15 11:19:45','TOKO','DUPSN','PSGT','PSGT-ZJAD-45-0','1','2.550','2.550','1','2.550','2.550','83.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-ZJAD-45-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAD-45-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0005','2026-10-15','11:17','29.820','kasirbip','2026-10-15 11:19:44'); 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-20261015-0006','1','LXPER-ZJAD-27-0','1','1.980','1.980','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJAD-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJAD-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJAD-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJAD-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-15 11:22:03' WHERE kode_barang='LXPER-ZJAD-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJAD-27-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-15 11:22:03','TOKO','DUPERBDG','LXPER','LXPER-ZJAD-27-0','1','1.980','1.980','1','1.980','1.980','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-ZJAD-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJAD-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0006','1','LXPER-ZJAD-28-0','1','1.250','1.250','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJAD-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJAD-28-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJAD-28-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJAD-28-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-15 11:22:03' WHERE kode_barang='LXPER-ZJAD-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJAD-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-15 11:22:03','TOKO','DUPERBDG','LXPER','LXPER-ZJAD-28-0','1','1.250','1.250','1','1.250','1.250','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-ZJAD-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJAD-28-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0006','1','LXPER-ZJAD-29-0','1','4.440','4.440','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJAD-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJAD-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJAD-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJAD-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-15 11:22:03' WHERE kode_barang='LXPER-ZJAD-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJAD-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-15 11:22:03','TOKO','DUPERBDG','LXPER','LXPER-ZJAD-29-0','1','4.440','4.440','1','4.440','4.440','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-ZJAD-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJAD-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0006','1','LXPER-ZJAD-30-0','1','4.420','4.420','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJAD-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJAD-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJAD-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJAD-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-15 11:22:03' WHERE kode_barang='LXPER-ZJAD-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJAD-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-15 11:22:03','TOKO','DUPERBDG','LXPER','LXPER-ZJAD-30-0','1','4.420','4.420','1','4.420','4.420','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-ZJAD-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJAD-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0006','2026-10-15','11:19','12.090','kasirbip','2026-10-15 11:22:02'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-15 ','11:36:09'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000394','X-00000394','CINCIN CBRT-00655','GR','---','CBRT','BELI','BELI001','1440000','2026-10-15','0.580','1','kasir','2026-10-15 11:37:05'); DELETE FROM tp_barang WHERE kode_dept = 'X-CBRT'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRT','X-00000394','X-00000394'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261015-0001','FJ-240511-0001','IQB','1','BELI','BELI001','CBRT', 'X-00000394', 'CINCIN CBRT-00655','0.580','0.580','75.00','1800000','1440000','2482759','1','1440000','1440000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRT' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-261015-0001','2026-10-15','2026-10-15','11:37:05','IQB','---','0.580','1440000','1440000','1440000','1440000','1440000','kasir','2026-10-15 11:37:05','FB-261015-0001','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261015-0001','NUR WAHYU','JKT','','JKT','0','kasir','2026-10-15 11:37:05'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0004','2026-10-15','2026-10-15 11:37:05','PEMBELIAN UMUM : FB-261015-0001','.','TBC','1440000','1440000'); 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 ('KK-261015-0005','K','2026-10-15','11:37:05','TBC','PEMBELIAN UMUM','FB-261015-0001','29383557964','1440000','29382117964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261015-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261015-0001'; 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-261015-0005','kasirbip','1',' 700K-17-26','TOKO','BIPPER','PBDG-ZEBB-26-0','CINCIN SILVER 925 ','','1.740','1','100.00','178000','0','0','17800','800000','0','0','0','800000','KUR','00043738','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEBB-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.740',berat_jual_asli=berat_jual_asli+'1.740',stock_jual='1',berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PBDG-ZEBB-26-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-261015-0005','2026-10-15','1.740','2026-10-15','12:32:32','PLG0017372','800000','800000','0','800000','0','kasirbip','2026-10-15 12:32:32','FJ-261015-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-15','FJ-261015-0005','2026-10-15','12:32:32','KUR','800000','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-261015-0005','2026-10-15','2026-10-15 12:32:32','PENJUALAN : FJ-261015-0005','.','TBC','800000','800000','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-261015-0006','D','2026-10-15','12:32:32','TBC','PENJUALAN','FJ-261015-0005','29382117964','800000','29382917964','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='800000' WHERE no_faktur_jual='FJ-261015-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-261015-0006','kasirbip',' 1',' 500K-20-30','TOKO','BIPPER','PBDG-ZJXI-36-0','CINCIN SILVER 925 YL01 ','','1.880','1','100.00','192000','0','0','17800','600000','0','0','0','600000','KUR','00048082','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZJXI-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PBDG-ZJXI-36-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-261015-0006','2026-10-15','1.880','2026-10-15','12:32:32','PLG0017373','600000','600000','0','600000','0','kasirbip','2026-10-15 12:32:32','FJ-261015-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-15','FJ-261015-0006','2026-10-15','12:32:32','KUR','600000','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-261015-0006','2026-10-15','2026-10-15 12:32:32','PENJUALAN : FJ-261015-0006','.','TBC','600000','600000','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-261015-0007','D','2026-10-15','12:32:32','TBC','PENJUALAN','FJ-261015-0006','29382917964','600000','29383517964','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='1400000' WHERE no_faktur_jual='FJ-261015-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0004'; 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-261015-0007','kasirbip','1',' 750K-18-00','TOKO','DUPERBDG','LXPER-ZFAB-63-0','CINCIN SILVER 925 ','','2.490','1','100.00','255000','0','0','17800','850000','0','0','0','850000','MIL','00044387','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAB-63-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.490',berat_jual_asli=berat_jual_asli+'2.490',stock_jual='1',berat_akhir=berat_akhir-'2.490',berat_akhir_asli=berat_akhir_asli-'2.490',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='LXPER-ZFAB-63-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-261015-0007','2026-10-15','2.490','2026-10-15','12:41:52','PLG0017374','850000','850000','0','850000','0','kasirbip','2026-10-15 12:41:52','FJ-261015-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-15','FJ-261015-0007','2026-10-15','12:41:52','MIL','850000','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-261015-0007','2026-10-15','2026-10-15 12:41:52','PENJUALAN : FJ-261015-0007','.','TBC','850000','850000','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-261015-0008','D','2026-10-15','12:41:52','TBC','PENJUALAN','FJ-261015-0007','29383517964','850000','29384367964','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='850000' WHERE no_faktur_jual='FJ-261015-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-261015-0008','kasirbip',' 1',' 750K-17-00','TOKO','DUPERBDG','LXPER-ZIBB-12-0','CINCIN SILVER 925 ','','1.990','1','100.00','203000','0','0','17800','850000','0','0','0','850000','MIL','00047445','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZIBB-12-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='LXPER-ZIBB-12-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-261015-0008','2026-10-15','1.990','2026-10-15','12:41:52','PLG0017375','850000','850000','0','850000','0','kasirbip','2026-10-15 12:41:52','FJ-261015-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-15','FJ-261015-0008','2026-10-15','12:41:52','MIL','850000','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-261015-0008','2026-10-15','2026-10-15 12:41:52','PENJUALAN : FJ-261015-0008','.','TBC','850000','850000','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-261015-0009','D','2026-10-15','12:41:52','TBC','PENJUALAN','FJ-261015-0008','29384367964','850000','29385217964','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='1700000' WHERE no_faktur_jual='FJ-261015-0008' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0008'; 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-261015-0009','kasirbip','1',' DP-04166BI','TOKO','BIPPSN','PSPRT-ZJAD-12-0','CINCIN PERAK YL01 ','','3.270','1','100.00','334000','0','0','17800','850000','0','0','0','850000','SAL','00048139','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAD-12-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.270',berat_jual_asli=berat_jual_asli+'3.270',stock_jual='1',berat_akhir=berat_akhir-'3.270',berat_akhir_asli=berat_akhir_asli-'3.270',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPRT-ZJAD-12-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-261015-0009','2026-10-15','3.270','2026-10-15','13:24:52','PLG0017376','850000','850000','0','850000','0','kasirbip','2026-10-15 13:24:51','FJ-261015-0009','DP-04166','850000'); 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-15','FJ-261015-0009','2026-10-15','13:24:52','SAL','850000','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-261015-0009' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0009'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-15 ','13:25:59'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-15 ','13:26:44'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-15 ','13:29:54'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-15 ','13:32:18'); 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-261015-0010','kasir','1',' 800K-21-13','TOKO','MMPER','PMM-ZJXG-38-0','CINCIN SILVER 925 YL10 ','','4.730','1','100.00','483000','0','0','17800','900000','0','0','0','900000','ALIKA','00047999','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZJXG-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.730',berat_jual_asli=berat_jual_asli+'4.730',stock_jual='1',berat_akhir=berat_akhir-'4.730',berat_akhir_asli=berat_akhir_asli-'4.730',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PMM-ZJXG-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-261015-0010','2026-10-15','4.730','2026-10-15','13:32:37','PLG0017377','900000','900000','0','900000','0','kasir','2026-10-15 13:32:36','FJ-261015-0010','','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-15','FJ-261015-0010','2026-10-15','13:32:37','ALIKA','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-261015-0009','2026-10-15','2026-10-15 13:32:36','PENJUALAN : FJ-261015-0010','.','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-261015-0010','D','2026-10-15','13:32:37','TBC','PENJUALAN','FJ-261015-0010','29385217964','900000','29386117964','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-261015-0010' 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-261015-0011','kasir',' 1',' 850K-115-1','TOKO','MMPER','PMM-ZHAB-17-0','CINCIN SILVER 925 ','','1.610','1','100.00','165000','0','0','17800','950000','0','0','0','950000','ALIKA','00046066','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHAB-17-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PMM-ZHAB-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-261015-0011','2026-10-15','1.610','2026-10-15','13:32:37','PLG0017378','950000','950000','0','950000','0','kasir','2026-10-15 13:32:36','FJ-261015-0010','','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-15','FJ-261015-0011','2026-10-15','13:32:37','ALIKA','950000','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-261015-0010','2026-10-15','2026-10-15 13:32:36','PENJUALAN : FJ-261015-0011','.','TBC','950000','950000','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-261015-0011','D','2026-10-15','13:32:37','TBC','PENJUALAN','FJ-261015-0011','29386117964','950000','29387067964','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='1850000' WHERE no_faktur_jual='FJ-261015-0011' LIMIT 1; 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-04595','VAN','1','PLD','WEDDRING PRIA','','','5.000','','10.00','1','1200000','350000','0','800000','2550000','PERMATA 1','SIE: 20.5 TNPA UKIR NAMA','FINISHING: PUTIH GLOSY MIX LIST TEPI ROSE GOLD','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0011','2026-10-15','2026-10-15 13:34:57','PESANAN : DP-04595','-','TBC','1700000','1700000'); 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-261015-0012','D','2026-10-15','13:34:57','TBC','PESANAN','DP-04595','29387067964','1700000','29388767964','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-04595','2026-10-15','2026-10-15','13:34:57','PLG0017379','VAN','2026-11-09','sby','2026-10-15 13:34:57','5.000','0','0','0','1700000','0','800000','2560000','2560000','860000'); 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-04596','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','sz 17.5 putih glossy EXPRESS 200.000','font yeseva one grf Krisna ... Gyna','model belakang dibuat lurus saja love nya dihilangkan','','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0012','2026-10-15','2026-10-15 14:10:06','PESANAN : DP-04596','.','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-261015-0013','D','2026-10-15','14:10:06','TBC','PESANAN','DP-04596','29388767964','950000','29389717964','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-04596','2026-10-15','2026-10-15','14:10:06','PLG0017380','SAL','2026-10-21','kasirbip','2026-10-15 14:10:06','2.000','0','0','0','950000','0','0','950000','950000','0'); 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-20261015-0007','1','PSPLT-ZJAC-11-0','1','5.500','5.500','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAC-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAC-11-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAC-11-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAC-11-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-15 14:19:32' WHERE kode_barang='PSPLT-ZJAC-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAC-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-15 14:19:32','TOKO','SBYPSN','PSPLT','PSPLT-ZJAC-11-0','1','5.500','5.500','1','5.500','5.500','32.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-ZJAC-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAC-11-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0007','1','PSPRT-ZJAC-12-0','1','3.470','3.470','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAC-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAC-12-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAC-12-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAC-12-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-15 14:19:32' WHERE kode_barang='PSPRT-ZJAC-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAC-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-15 14:19:32','TOKO','SBYPSN','PSPRT','PSPRT-ZJAC-12-0','1','3.470','3.470','1','3.470','3.470','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-ZJAC-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAC-12-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0007','2026-10-15','14:16','8.970','sby','2026-10-15 14:19:31'); 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-04597','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 17 putih doff semprot','font berkshire swash grf Manda 25.11.2026','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0013','2026-10-15','2026-10-15 14:31:24','PESANAN : DP-04597','.','TBC','900000','900000'); 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-261015-0014','D','2026-10-15','14:31:24','TBC','PESANAN','DP-04597','29389717964','900000','29390617964','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-04597','2026-10-15','2026-10-15','14:31:24','PLG0017381','KUR','2026-11-05','kasirbip','2026-10-15 14:31:24','3.000','0','0','0','900000','0','0','900000','900000','0'); 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-04598','KUR','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1050000','0','1050000','sz 13 putih glossy 26 zirkon','font berkshire swash grf Syihva 25.11.2026','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0014','2026-10-15','2026-10-15 14:35:33','PESANAN : DP-04598','.','TBC','1050000','1050000'); 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-261015-0015','D','2026-10-15','14:35:33','TBC','PESANAN','DP-04598','29390617964','1050000','29391667964','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-04598','2026-10-15','2026-10-15','14:35:33','PLG0017382','KUR','2026-11-05','kasirbip','2026-10-15 14:35:33','2.000','0','0','0','1050000','0','0','1050000','1050000','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-261015-0012','kasirbip','1',' DP-04114DU','TOKO','DUPSN','PSPRT-ZJAB-7-0','CINCIN PERAK ','','3.560','1','100.00','364000','0','0','17800','850000','0','0','0','850000','PUT','00048090','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAB-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.560',berat_jual_asli=berat_jual_asli+'3.560',stock_jual='1',berat_akhir=berat_akhir-'3.560',berat_akhir_asli=berat_akhir_asli-'3.560',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPRT-ZJAB-7-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-261015-0012','2026-10-15','3.560','2026-10-15','14:43:14','PLG0017383','850000','850000','0','850000','0','kasirbip','2026-10-15 14:43:14','FJ-261015-0012','DP-04114','850000'); 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-15','FJ-261015-0012','2026-10-15','14:43:14','PUT','850000','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-261015-0012' LIMIT 1; 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-04599','DEW','1','PER','WEDRING','','','35.000','','925.00','1','100000','0','950000','0','950000','size 17','ukir nama vintage :Vito...Sekar','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0015','2026-10-15','2026-10-15 14:52:47','PESANAN : DP-04599','-','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-261015-0016','D','2026-10-15','14:52:47','TBC','PESANAN','DP-04599','29391667964','950000','29392617964','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-04599','2026-10-15','2026-10-15','14:52:47','PLG0017384','DEW','2026-11-06','jogja','2026-10-15 14:52:47','35.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-15 ','14:53:30'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-15 ','15:05:37'); 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-261015-0013','sby','1',' DP-04067SB','TOKO','SBYPSN','PSGT-ZJAB-11-0','CINCIN EMAS ','','1.900','1','57.00','2541000','0','0','17800','4500000','0','0','0','4500000','VAN','00048094','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAB-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSGT-ZJAB-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261015-0013','2026-10-15','1.900','2026-10-15','15:09:38','PLG0017385','4500000','4500000','0','4500000','0','sby','2026-10-15 15:09:38','FJ-261015-0013','DP-04067','3200000'); 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-15','FJ-261015-0013','2026-10-15','15:09:38','VAN','4500000','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-261015-0016','2026-10-15','2026-10-15 15:09:38','PENJUALAN : FJ-261015-0013','','TBC','1300000','1300000','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-261015-0017','D','2026-10-15','15:09:38','TBC','PENJUALAN','FJ-261015-0013','29392617964','1300000','29393917964','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='1300000' WHERE no_faktur_jual='FJ-261015-0013' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0013'; 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-20261015-0008','1','PSGT-ZJAC-13-0','1','2.400','2.400','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJAC-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJAC-13-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJAC-13-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAC-13-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-15 15:14:49' WHERE kode_barang='PSGT-ZJAC-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJAC-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-15 15:14:49','TOKO','JOGPSN','PSGT','PSGT-ZJAC-13-0','1','2.400','','1','2.400','','83.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-ZJAC-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAC-13-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0008','1','PSPRT-ZJAC-14-0','1','3.590','3.590','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAC-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAC-14-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAC-14-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAC-14-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-15 15:14:49' WHERE kode_barang='PSPRT-ZJAC-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAC-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-15 15:14:49','TOKO','JOGPSN','PSPRT','PSPRT-ZJAC-14-0','1','3.590','','1','3.590','','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-ZJAC-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAC-14-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0008','2026-10-15','15:13','5.990','jogja','2026-10-15 15:14:48'); 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-261015-0014','sby','1',' DP-04395SB','TOKO','SBYPSN','PSGT-ZJAB-14-0','CINCIN EMAS ','','3.500','1','83.00','6816000','0','0','17800','8575000','0','0','0','8575000','DIL','00048097','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAB-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.500',berat_jual_asli=berat_jual_asli+'3.500',stock_jual='1',berat_akhir=berat_akhir-'3.500',berat_akhir_asli=berat_akhir_asli-'3.500',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSGT-ZJAB-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261015-0014','2026-10-15','3.500','2026-10-15','15:35:30','PLG0017386','8575000','8575000','0','8575000','0','sby','2026-10-15 15:35:30','FJ-261015-0014','DP-04395','5000000'); 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-15','FJ-261015-0014','2026-10-15','15:35:30','DIL','8575000','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-261015-0017','2026-10-15','2026-10-15 15:35:30','PENJUALAN : FJ-261015-0014','','TBC','3575000','3575000','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-261015-0018','D','2026-10-15','15:35:30','TBC','PENJUALAN','FJ-261015-0014','29393917964','3575000','29397492964','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='3575000' WHERE no_faktur_jual='FJ-261015-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-261015-0015','sby',' 1',' DP-04396SB','TOKO','SBYPSN','PSGT-ZJAB-15-0','CINCIN EMAS ','','2.080','1','83.00','4051000','0','0','17800','5770000','0','0','0','5770000','DIL','00048098','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAB-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSGT-ZJAB-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261015-0015','2026-10-15','2.080','2026-10-15','15:35:30','PLG0017387','5770000','5770000','0','5770000','0','sby','2026-10-15 15:35:30','FJ-261015-0014','DP-04396','3500000'); 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-15','FJ-261015-0015','2026-10-15','15:35:30','DIL','5770000','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-261015-0018','2026-10-15','2026-10-15 15:35:30','PENJUALAN : FJ-261015-0015','','TBC','2270000','2270000','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-261015-0019','D','2026-10-15','15:35:30','TBC','PENJUALAN','FJ-261015-0015','29397492964','2270000','29399762964','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='5845000' WHERE no_faktur_jual='FJ-261015-0015' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0014'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-15 ','16:10:46'); 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-04600','PUT','1','PER','WEDRING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz cwe 17.5 crom putih glosy','grf Abay 07.11.26 font Berkshire','EXPRESS 100.000','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0019','2026-10-15','2026-10-15 16:12:54','PESANAN : DP-04600','.','TBC','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,jenis_trx) VALUES ('KM-261015-0020','D','2026-10-15','16:12:54','TBC','PESANAN','DP-04600','29399762964','850000','29400612964','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-04600','2026-10-15','2026-10-15','16:12:54','PLG0017388','PUT','2026-10-30','kasirbip','2026-10-15 16:12:54','2.000','0','0','0','850000','0','0','850000','850000','0'); 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-04601','PUT','1','PER','WEDRING','','','2.500','','925.00','1','100000','0','850000','0','850000','sz cwo 18 crom putih doff semprot','grf Oci 07.11.26 font berkshire','EXPRESS 100.000','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0020','2026-10-15','2026-10-15 16:14:30','PESANAN : DP-04601','.','TBC','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,jenis_trx) VALUES ('KM-261015-0021','D','2026-10-15','16:14:30','TBC','PESANAN','DP-04601','29400612964','850000','29401462964','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-04601','2026-10-15','2026-10-15','16:14:30','PLG0017389','PUT','2026-10-30','kasirbip','2026-10-15 16:14:30','2.500','0','0','0','850000','0','0','850000','850000','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-261015-0016','kasirbip','1',' DP-04104DU','TOKO','DUPSN','PSPLT-ZJAB-8-0','CINCIN PALADIUM ','','1.400','1','17.00','315000','0','0','17800','1440000','0','0','0','1440000','PUT','00048091','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAB-8-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPLT-ZJAB-8-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-261015-0016','2026-10-15','1.400','2026-10-15','17:00:12','PLG0017390','1440000','1440000','0','1440000','0','kasirbip','2026-10-15 17:00:12','FJ-261015-0016','DP-04104','1320000'); 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-15','FJ-261015-0016','2026-10-15','17:00:12','PUT','1440000','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-261015-0021','2026-10-15','2026-10-15 17:00:12','PENJUALAN : FJ-261015-0016','.','TBC','120000','120000','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-261015-0022','D','2026-10-15','17:00:12','TBC','PENJUALAN','FJ-261015-0016','29401462964','120000','29401582964','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='120000' WHERE no_faktur_jual='FJ-261015-0016' 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-261015-0017','kasirbip','1',' DP-04105DU','TOKO','DUPSN','PSPRT-ZJAB-10-0','CINCIN PERAK ','','1.400','1','100.00','143000','0','0','17800','800000','0','0','0','800000','PUT','00048093','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAB-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPRT-ZJAB-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-261015-0017','2026-10-15','1.400','2026-10-15','17:01:50','PLG0017391','800000','800000','0','800000','0','kasirbip','2026-10-15 17:01:49','FJ-261015-0017','DP-04105','800000'); 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-15','FJ-261015-0017','2026-10-15','17:01:50','PUT','800000','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-261015-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-261015-0018','kasirbip','1',' DP-04091DU','TOKO','DUPSN','PSPRT-ZJAB-9-0','CINCIN PERAK ','','2.200','1','100.00','225000','0','0','17800','850000','0','0','0','850000','PUT','00048092','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAB-9-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPRT-ZJAB-9-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-261015-0018','2026-10-15','2.200','2026-10-15','17:04:42','PLG0017392','850000','850000','0','850000','0','kasirbip','2026-10-15 17:04:42','FJ-261015-0018','DP-04091','850000'); 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-15','FJ-261015-0018','2026-10-15','17:04:42','PUT','850000','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-261015-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-261015-0019','kasirbip',' 1',' DP-04090DU','TOKO','DUPSN','PSPLT-ZJAD-15-0','CINCIN PALADIUM ','','2.220','1','32.00','939000','0','0','17800','2161000','0','0','0','2161000','PUT','00048142','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAD-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPLT-ZJAD-15-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-261015-0019','2026-10-15','2.220','2026-10-15','17:04:42','PLG0017393','2161000','2161000','0','2161000','0','kasirbip','2026-10-15 17:04:42','FJ-261015-0018','DP-04090','1632000'); 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-15','FJ-261015-0019','2026-10-15','17:04:42','PUT','2161000','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-261015-0022','2026-10-15','2026-10-15 17:04:42','PENJUALAN : FJ-261015-0019','.','TBC','529000','529000','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-261015-0023','D','2026-10-15','17:04:42','TBC','PENJUALAN','FJ-261015-0019','29401582964','529000','29402111964','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='529000' WHERE no_faktur_jual='FJ-261015-0019' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0018'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0019'; 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-04602','VAN','1','PLD','WEDDRING PRIA','','','4.000','','10.00','1','1200000','300000','0','700000','1900000','SIZE: 19.5 PERMATA 10','UKIR NAMA: F??M FONT: BERKSHIRE','FINISHING: PUTIH DOFF MIX GLOSSY','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0023','2026-10-15','2026-10-15 17:32:54','PESANAN : DP-04602','-','TBC','1300000','1300000'); 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-261015-0024','D','2026-10-15','17:32:54','TBC','PESANAN','DP-04602','29402111964','1300000','29403411964','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-04602','2026-10-15','2026-10-15','17:32:54','PLG0017394','VAN','2026-11-30','sby','2026-10-15 17:32:54','4.000','0','0','0','1300000','0','700000','1910000','1910000','610000'); 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-04603','SAL','1','GOLD','WED RING','','','3.200','','75.00','1','2300000','2250000','0','950000','8150000','sz 11.5 putih glossy 18 zirkon','kuku permata tengah dibuat 4 kuku saja','font grf menyusul','180000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0024','2026-10-15','2026-10-15 18:57:56','PESANAN : DP-04603','.','TBC','6664000','6664000'); 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-261015-0025','D','2026-10-15','18:57:56','TBC','PESANAN','DP-04603','29403411964','6664000','29410075964','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-04603','2026-10-15','2026-10-15','18:57:56','PLG0017395','SAL','2026-11-15','kasirbip','2026-10-15 18:57:56','3.200','0','0','0','6664000','0','950000','8330000','8330000','1666000'); 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-20261015-0009','1','PSPRT-ZJAE-8-0','1','3.400','3.400','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAE-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAE-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAE-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAE-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 18:58:35' WHERE kode_barang='PSPRT-ZJAE-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAE-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-15 18:58:35','TOKO','DUPSN','PSPRT','PSPRT-ZJAE-8-0','1','3.400','3.400','1','3.400','3.400','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-ZJAE-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAE-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0009','1','PSPRT-ZJAE-9-0','1','2.180','2.180','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAE-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAE-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAE-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAE-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 18:58:35' WHERE kode_barang='PSPRT-ZJAE-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAE-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-15 18:58:35','TOKO','DUPSN','PSPRT','PSPRT-ZJAE-9-0','1','2.180','2.180','1','2.180','2.180','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-ZJAE-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAE-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0009','1','PSPLT-ZJAE-10-0','1','3.400','3.400','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAE-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAE-10-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAE-10-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAE-10-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 18:58:35' WHERE kode_barang='PSPLT-ZJAE-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAE-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-15 18:58:35','TOKO','DUPSN','PSPLT','PSPLT-ZJAE-10-0','1','3.400','3.400','1','3.400','3.400','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-ZJAE-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAE-10-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0009','1','PSPRT-ZJAE-11-0','1','2.130','2.130','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAE-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAE-11-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAE-11-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAE-11-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 18:58:35' WHERE kode_barang='PSPRT-ZJAE-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAE-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-15 18:58:35','TOKO','DUPSN','PSPRT','PSPRT-ZJAE-11-0','1','2.130','2.130','1','2.130','2.130','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-ZJAE-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAE-11-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0009','1','PSPLT-ZJAE-12-0','1','2.600','2.600','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAE-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAE-12-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAE-12-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAE-12-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 18:58:35' WHERE kode_barang='PSPLT-ZJAE-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAE-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-15 18:58:35','TOKO','DUPSN','PSPLT','PSPLT-ZJAE-12-0','1','2.600','2.600','1','2.600','2.600','32.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-ZJAE-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAE-12-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0009','1','PSPRT-ZJAE-13-0','1','2.950','2.950','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAE-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAE-13-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAE-13-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAE-13-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 18:58:35' WHERE kode_barang='PSPRT-ZJAE-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAE-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-15 18:58:35','TOKO','DUPSN','PSPRT','PSPRT-ZJAE-13-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-ZJAE-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAE-13-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0009','1','PSGT-ZJAE-14-0','1','2.750','2.750','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJAE-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJAE-14-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJAE-14-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAE-14-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 18:58:35' WHERE kode_barang='PSGT-ZJAE-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJAE-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-15 18:58:35','TOKO','DUPSN','PSGT','PSGT-ZJAE-14-0','1','2.750','2.750','1','2.750','2.750','83.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-ZJAE-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAE-14-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0009','1','PSGT-ZJAE-15-0','1','2.230','2.230','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJAE-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJAE-15-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJAE-15-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAE-15-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-15 18:58:35' WHERE kode_barang='PSGT-ZJAE-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJAE-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-15 18:58:35','TOKO','DUPSN','PSGT','PSGT-ZJAE-15-0','1','2.230','2.230','1','2.230','2.230','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-ZJAE-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAE-15-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0009','2026-10-15','18:58','21.640','kasirbip','2026-10-15 18:58:35'); 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-04604','SAL','1','PLD','WED RING','','','4.500','','25.00','1','1200000','550000','0','800000','3275000','sz 22 putih doff semprot 1 zirkon','font grf menyusul','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0025','2026-10-15','2026-10-15 18:59:18','PESANAN : DP-04604','.','TBC','2620000','2620000'); 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-261015-0026','D','2026-10-15','18:59:18','TBC','PESANAN','DP-04604','29410075964','2620000','29412695964','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-04604','2026-10-15','2026-10-15','18:59:18','PLG0017396','SAL','2026-11-15','kasirbip','2026-10-15 18:59:18','4.500','0','0','0','2620000','0','800000','3275000','3275000','655000'); 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-04605','DEW','1','GOLD','WEDRING','','','2.500','','375.00','1','2300000','1400000','0','900000','4400000','sz cwe 12 5','gf vintage : Aditya...Erna','gold (zircon 15)','0','0','150000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0026','2026-10-15','2026-10-15 19:12:07','PESANAN : DP-04605','-','TBC','3640000','3640000'); 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-261015-0027','D','2026-10-15','19:12:07','TBC','PESANAN','DP-04605','29412695964','3640000','29416335964','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-04605','2026-10-15','2026-10-15','19:12:07','PLG0017397','DEW','2026-11-06','jogja','2026-10-15 19:12:07','2.500','0','0','0','3640000','0','900000','4550000','4550000','910000'); 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-261015-0020','kasirbip','1',' DP-04515DU','TOKO','DUPSN','PSGT-ZJAE-14-0','CINCIN EMAS ','','2.750','1','83.00','5355000','0','0','17800','7287500','0','0','0','7287500','PUT','00048195','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAE-14-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-15' AND kode_barang='PSGT-ZJAE-14-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-261015-0020','2026-10-15','2.750','2026-10-15','19:15:14','PLG0017398','7287500','7287500','0','7287500','0','kasirbip','2026-10-15 19:15:13','FJ-261015-0020','DP-04515','5492000'); 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-15','FJ-261015-0020','2026-10-15','19:15:14','PUT','7287500','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-261015-0027','2026-10-15','2026-10-15 19:15:13','PENJUALAN : FJ-261015-0020','.','TBC','1795500','1795500','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-261015-0028','D','2026-10-15','19:15:14','TBC','PENJUALAN','FJ-261015-0020','29416335964','1795500','29418131464','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='1795500' WHERE no_faktur_jual='FJ-261015-0020' 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-261015-0021','kasirbip',' 1',' DP-04516DU','TOKO','DUPSN','PSGT-ZJAE-15-0','CINCIN EMAS YL01 ','','2.230','1','45.00','2355000','0','0','17800','3622000','0','0','0','3622000','PUT','00048196','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAE-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSGT-ZJAE-15-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-261015-0021','2026-10-15','2.230','2026-10-15','19:15:14','PLG0017399','3622000','3622000','0','3622000','0','kasirbip','2026-10-15 19:15:13','FJ-261015-0020','DP-04516','3200000'); 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-15','FJ-261015-0021','2026-10-15','19:15:14','PUT','3622000','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-261015-0028','2026-10-15','2026-10-15 19:15:13','PENJUALAN : FJ-261015-0021','.','TBC','422000','422000','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-261015-0029','D','2026-10-15','19:15:14','TBC','PENJUALAN','FJ-261015-0021','29418131464','422000','29418553464','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='2217500' WHERE no_faktur_jual='FJ-261015-0021' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0020'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0021'; 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-261015-0022','kasir','1',' DP-04321MM','TOKO','MMPSN','PSGT-ZJAC-7-0','CINCIN EMAS ','','2.220','1','83.00','4324000','0','0','17800','5695000','0','0','0','5695000','ALIKA','00048120','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAC-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSGT-ZJAC-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-261015-0022','2026-10-15','2.220','2026-10-15','19:26:17','PLG0017400','5695000','5695000','0','5695000','0','kasir','2026-10-15 19:26:16','FJ-261015-0022','DP-04321','5060000'); 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-15','FJ-261015-0022','2026-10-15','19:26:17','ALIKA','5695000','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-261015-0029','2026-10-15','2026-10-15 19:26:16','PENJUALAN : FJ-261015-0022','.','TBC','635000','635000','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-261015-0030','D','2026-10-15','19:26:17','TBC','PENJUALAN','FJ-261015-0022','29418553464','635000','29419188464','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='635000' WHERE no_faktur_jual='FJ-261015-0022' 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-261015-0023','kasirbip','1',' 800K-21-00','TOKO','DUPERBDG','LXPER-ZJXE-26-0','CINCIN SILVER 925 ','','2.880','1','100.00','294000','0','0','17800','900000','0','0','0','900000','MIL','00047911','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJXE-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.880',berat_jual_asli=berat_jual_asli+'2.880',stock_jual='1',berat_akhir=berat_akhir-'2.880',berat_akhir_asli=berat_akhir_asli-'2.880',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='LXPER-ZJXE-26-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-261015-0023','2026-10-15','2.880','2026-10-15','19:38:24','PLG0017401','900000','900000','0','900000','0','kasirbip','2026-10-15 19:38:23','FJ-261015-0023','','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-15','FJ-261015-0023','2026-10-15','19:38:24','MIL','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-261015-0030','2026-10-15','2026-10-15 19:38:23','PENJUALAN : FJ-261015-0023','.','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-261015-0031','D','2026-10-15','19:38:24','TBC','PENJUALAN','FJ-261015-0023','29419188464','900000','29420088464','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-261015-0023' 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-261015-0024','kasirbip',' 1',' 800K-13-00','TOKO','DUPERBDG','LXPER-ZHBH-33-0','CINCIN SILVER 925 ','','1.660','1','100.00','170000','0','0','17800','900000','0','0','0','900000','MIL','00046623','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHBH-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='LXPER-ZHBH-33-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-261015-0024','2026-10-15','1.660','2026-10-15','19:38:24','PLG0017402','900000','900000','0','900000','0','kasirbip','2026-10-15 19:38:23','FJ-261015-0023','','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-15','FJ-261015-0024','2026-10-15','19:38:24','MIL','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-261015-0031','2026-10-15','2026-10-15 19:38:23','PENJUALAN : FJ-261015-0024','.','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-261015-0032','D','2026-10-15','19:38:24','TBC','PENJUALAN','FJ-261015-0024','29420088464','900000','29420988464','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='1800000' WHERE no_faktur_jual='FJ-261015-0024' 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-261015-0025','kasirbip','1',' DP-04061BI','TOKO','BIPPSN','PSPRT-ZJAD-11-0','CINCIN PERAK ','','1.640','1','100.00','168000','0','0','17800','950000','0','0','0','950000','SULIS','00048138','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAD-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.640',berat_jual_asli=berat_jual_asli+'1.640',stock_jual='1',berat_akhir=berat_akhir-'1.640',berat_akhir_asli=berat_akhir_asli-'1.640',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPRT-ZJAD-11-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-261015-0025','2026-10-15','1.640','2026-10-15','19:38:31','PLG0017403','950000','950000','0','950000','0','kasirbip','2026-10-15 19:38:30','FJ-261015-0025','DP-04061','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-15','FJ-261015-0025','2026-10-15','19:38:31','SULIS','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-261015-0025' 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-261015-0026','kasirbip',' 1',' DP-04062BI','TOKO','BIPPSN','PSPRT-ZJAB-16-0','CINCIN PERAK YL10 ','','5.120','1','100.00','523000','0','0','17800','950000','0','0','0','950000','SULIS','00048099','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAB-16-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.120',berat_jual_asli=berat_jual_asli+'5.120',stock_jual='1',berat_akhir=berat_akhir-'5.120',berat_akhir_asli=berat_akhir_asli-'5.120',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPRT-ZJAB-16-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-261015-0026','2026-10-15','5.120','2026-10-15','19:38:31','PLG0017404','950000','950000','0','950000','0','kasirbip','2026-10-15 19:38:30','FJ-261015-0025','DP-04062','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-15','FJ-261015-0026','2026-10-15','19:38:31','SULIS','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-261015-0026' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0022'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0023'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0024' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0024'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0025' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0025' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0025'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0026' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0026' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0026'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-15 ','19:53:16'); 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-20261015-0010','1','PSPLT-ZJAD-46-0','1','4.380','4.380','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAD-46-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-46-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAD-46-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAD-46-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-15 19:56:24' WHERE kode_barang='PSPLT-ZJAD-46-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAD-46-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-15 19:56:24','TOKO','SBYPSN','PSPLT','PSPLT-ZJAD-46-0','1','4.380','4.380','1','4.380','4.380','32.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-ZJAD-46-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-46-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0010','1','PSPLT-ZJAD-47-0','1','2.760','2.760','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAD-47-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-47-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAD-47-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAD-47-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-15 19:56:24' WHERE kode_barang='PSPLT-ZJAD-47-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAD-47-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-15 19:56:24','TOKO','SBYPSN','PSPLT','PSPLT-ZJAD-47-0','1','2.760','2.760','1','2.760','2.760','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-ZJAD-47-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-47-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0010','1','PSPLT-ZJAD-48-0','1','3.100','3.100','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAD-48-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-48-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAD-48-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAD-48-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-15 19:56:24' WHERE kode_barang='PSPLT-ZJAD-48-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAD-48-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-15 19:56:24','TOKO','SBYPSN','PSPLT','PSPLT-ZJAD-48-0','1','3.100','3.100','1','3.100','3.100','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-ZJAD-48-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAD-48-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0010','1','PSPRT-ZJAD-49-0','1','1.780','1.780','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAD-49-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-49-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAD-49-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAD-49-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-15 19:56:24' WHERE kode_barang='PSPRT-ZJAD-49-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAD-49-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-15 19:56:24','TOKO','SBYPSN','PSPRT','PSPRT-ZJAD-49-0','1','1.780','1.780','1','1.780','1.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-ZJAD-49-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAD-49-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0010','2026-10-15','19:53','12.020','sby','2026-10-15 19:56:24'); 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-261015-0027','jogja','1',' 1.25K-15-0','TOKO','JOGPER','PJOG-ZFAA-125-0','CINCIN SILVER 925 ','','2.390','1','100.00','244000','0','0','17800','1400000','0','0','0','1400000','DEW','00044324','PJOG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAA-125-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PJOG-ZFAA-125-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-261015-0027','2026-10-15','2.390','2026-10-15','19:56:36','PLG0017405','1400000','1400000','0','1400000','0','jogja','2026-10-15 19:56:36','FJ-261015-0027','','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-15','FJ-261015-0027','2026-10-15','19:56:36','DEW','1400000','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-261015-0032','2026-10-15','2026-10-15 19:56:36','PENJUALAN : FJ-261015-0027','','TBC','1400000','1400000','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-261015-0033','D','2026-10-15','19:56:36','TBC','PENJUALAN','FJ-261015-0027','29420988464','1400000','29422388464','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='1400000' WHERE no_faktur_jual='FJ-261015-0027' 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-261015-0028','kasirbip','1',' PLBDG-0016','TOKO','BIPPLD','PLBDG-ZJXE-9-0','CINCIN PALADIUM PLBDG-00168 ','','2.630','1','17.00','591000','0','0','17800','1700000','0','0','0','1700000','KUR','00047894','PLBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZJXE-9-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.630',berat_jual_asli=berat_jual_asli+'2.630',stock_jual='1',berat_akhir=berat_akhir-'2.630',berat_akhir_asli=berat_akhir_asli-'2.630',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PLBDG-ZJXE-9-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-261015-0028','2026-10-15','2.630','2026-10-15','19:58:52','PLG0017406','1700000','1700000','0','1700000','0','kasirbip','2026-10-15 19:58:51','FJ-261015-0028','','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-15','FJ-261015-0028','2026-10-15','19:58:52','KUR','1700000','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-261015-0033','2026-10-15','2026-10-15 19:58:51','PENJUALAN : FJ-261015-0028','.','TBC','1700000','1700000','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-261015-0034','D','2026-10-15','19:58:52','TBC','PENJUALAN','FJ-261015-0028','29422388464','1700000','29424088464','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='1700000' WHERE no_faktur_jual='FJ-261015-0028' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0027' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0027' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0027'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0028' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0028' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0028'; 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-20261015-0011','1','PSBY-ZJAD-31-0','1','2.120','2.120','TOKO','SBYPER','TOKO','SBYPER'); DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJAD-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJAD-31-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJAD-31-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJAD-31-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-15 20:02:58' WHERE kode_barang='PSBY-ZJAD-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJAD-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-15 20:02:58','TOKO','SBYPER','PSBY','PSBY-ZJAD-31-0','1','2.120','2.120','1','2.120','2.120','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-ZJAD-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJAD-31-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0011','1','PSBY-ZJAD-32-0','1','2.120','2.120','TOKO','SBYPER','TOKO','SBYPER'); DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJAD-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJAD-32-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJAD-32-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJAD-32-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-15 20:02:58' WHERE kode_barang='PSBY-ZJAD-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJAD-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-15 20:02:58','TOKO','SBYPER','PSBY','PSBY-ZJAD-32-0','1','2.120','2.120','1','2.120','2.120','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-ZJAD-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJAD-32-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0011','1','PSBY-ZJAD-33-0','1','4.510','4.510','TOKO','SBYPER','TOKO','SBYPER'); DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJAD-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJAD-33-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJAD-33-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJAD-33-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-15 20:02:58' WHERE kode_barang='PSBY-ZJAD-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJAD-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-15 20:02:58','TOKO','SBYPER','PSBY','PSBY-ZJAD-33-0','1','4.510','4.510','1','4.510','4.510','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-ZJAD-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJAD-33-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' 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-20261015-0011','1','PSBY-ZJAD-34-0','1','4.360','4.360','TOKO','SBYPER','TOKO','SBYPER'); DELETE FROM tm_barang WHERE kode_barang='PSBY-ZJAD-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZJAD-34-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZJAD-34-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZJAD-34-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-10-15 20:02:58' WHERE kode_barang='PSBY-ZJAD-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZJAD-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-15 20:02:58','TOKO','SBYPER','PSBY','PSBY-ZJAD-34-0','1','4.360','4.360','1','4.360','4.360','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-ZJAD-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZJAD-34-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-15' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0011','2026-10-15','19:56','13.110','sby','2026-10-15 20:02:58'); 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-261015-0029','kasirbip','1',' DP-04191BI','TOKO','BIPPSN','PSPRT-ZJAB-19-0','CINCIN PERAK SR04 YL01 ','','3.200','1','100.00','327000','0','0','17800','950000','0','0','0','950000','SAL','00048102','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAB-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPRT-ZJAB-19-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-261015-0029','2026-10-15','3.200','2026-10-15','20:07:43','PLG0017407','950000','950000','0','950000','0','kasirbip','2026-10-15 20:07:42','FJ-261015-0029','DP-04191','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-15','FJ-261015-0029','2026-10-15','20:07:43','SAL','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-261015-0029' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0029' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0029' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0029'; 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-261015-0030','sby','1',' DP-04060SB','TOKO','SBYPSN','PSPRT-ZJXG-60-0','CINCIN PERAK ','','2.810','1','100.00','287000','0','0','17800','850000','0','0','0','850000','VAN','00048021','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXG-60-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.810',berat_jual_asli=berat_jual_asli+'2.810',stock_jual='1',berat_akhir=berat_akhir-'2.810',berat_akhir_asli=berat_akhir_asli-'2.810',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPRT-ZJXG-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261015-0030','2026-10-15','2.810','2026-10-15','20:47:37','PLG0017408','850000','850000','0','850000','0','sby','2026-10-15 20:47:35','FJ-261015-0030','DP-04060','850000'); 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-15','FJ-261015-0030','2026-10-15','20:47:37','VAN','850000','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-261015-0030' 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-261015-0031','sby',' 1',' DP-04059SB','TOKO','SBYPSN','PSPRT-ZJXG-59-0','CINCIN PERAK YL10 ','','4.130','1','100.00','422000','0','0','17800','800000','0','0','0','800000','VAN','00048020','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXG-59-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.130',berat_jual_asli=berat_jual_asli+'4.130',stock_jual='1',berat_akhir=berat_akhir-'4.130',berat_akhir_asli=berat_akhir_asli-'4.130',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='PSPRT-ZJXG-59-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-261015-0031','2026-10-15','4.130','2026-10-15','20:47:37','PLG0017409','800000','800000','0','800000','0','sby','2026-10-15 20:47:35','FJ-261015-0030','DP-04059','800000'); 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-15','FJ-261015-0031','2026-10-15','20:47:37','VAN','800000','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-261015-0031' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0030' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0030' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0030'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0031' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261015-0031' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261015-0031'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-16','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-15'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-15'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-15'; 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-15' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-15'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-15'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-15'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-15'; 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-16' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-15' 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-261016-0001','D','2026-10-16','21:08:13','TBC','SALDO AWAL','SALDO AWAL','0','29424088464','29424088464'); 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-261016-0001','D','2026-10-16','21:08:13','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); 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-261016-0001','D','2026-10-16','21:08:13','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-261016-0001','D','2026-10-16','21:08:13','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-261016-0001','D','2026-10-16','21:08:13','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-261016-0001','D','2026-10-16','21:08:13','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-261016-0001','D','2026-10-16','21:08:13','','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-261016-0001','D','2026-10-16','21:08:13','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-261016-0001','D','2026-10-16','21:08:13','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000'); 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-261016-0001','D','2026-10-16','21:08:13','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-261016-0001','D','2026-10-16','21:08:13','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-261016-0001','D','2026-10-16','21:08:13','SHO','SALDO AWAL','SALDO AWAL','0','145485650','145485650'); UPDATE tp_system SET tgl_system='2026-10-16'; 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-04606','DIL','1','PER','WEDD RING PRIA','','','4.000','','925.00','1','100000','0','800000','0','800000','SIZE 29 GRF: Ivan ?? Dea 05.06.23 (VINTAGE)','PUTIH GLOSSY MIX MELENGKUNG KUNING GLOSSY','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0034','2026-10-15','2026-10-15 21:08:58','PESANAN : DP-04606','-','TBC','800000','800000'); 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-261015-0001','D','2026-10-15','21:08:58','TBC','PESANAN','DP-04606','0','800000','800000','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-04606','2026-10-15','2026-10-15','21:08:58','PLG0017410','DIL','2026-11-10','sby','2026-10-15 21:08:58','4.000','0','0','0','800000','0','0','800000','800000','0'); 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-04607','DIL','1','GOLD','WEDD RING WANITA','','','2.000','','37.50','1','2300000','1400000','0','800000','3600000','PERMATA 7 BUTIR','SIZE 14.5 GRF: Dea ?? Ivan 05.06.23 (VINTAGE)','EMAS KUNING (MAKSIMAL 2 GRAM)','70000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261015-0035','2026-10-15','2026-10-15 21:14:28','PESANAN : DP-04607','-','TBC','2200000','2200000'); 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-261015-0002','D','2026-10-15','21:14:28','TBC','PESANAN','DP-04607','800000','2200000','3000000','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-04607','2026-10-15','2026-10-15','21:14:28','PLG0017411','DIL','2026-11-10','sby','2026-10-15 21:14:28','2.000','0','0','0','2200000','0','800000','3670000','3670000','1470000');