INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','08:23:26'); 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-20261111-0001','1','PSPRT-ZKAX-6-0','1','2.190','2.190','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKAX-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-6-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKAX-6-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAX-6-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-11-11 08:23:46' WHERE kode_barang='PSPRT-ZKAX-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKAX-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-11-11 08:23:46','TOKO','MMPSN','PSPRT','PSPRT-ZKAX-6-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-ZKAX-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-6-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0001','1','PSPLT-ZKAX-7-0','1','2.990','2.990','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKAX-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKAX-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAX-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-11-11 08:23:46' WHERE kode_barang='PSPLT-ZKAX-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKAX-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-11-11 08:23:46','TOKO','MMPSN','PSPLT','PSPLT-ZKAX-7-0','1','2.990','2.990','1','2.990','2.990','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-ZKAX-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0001','1','PSGT-ZKAX-8-0','1','3.010','3.010','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZKAX-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZKAX-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAX-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-11-11 08:23:46' WHERE kode_barang='PSGT-ZKAX-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZKAX-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-11-11 08:23:46','TOKO','MMPSN','PSGT','PSGT-ZKAX-8-0','1','3.010','3.010','1','3.010','3.010','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-ZKAX-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0001','1','PSPRT-ZKAX-21-0','1','5.370','5.370','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKAX-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-21-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKAX-21-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAX-21-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-11-11 08:23:46' WHERE kode_barang='PSPRT-ZKAX-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKAX-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-11-11 08:23:46','TOKO','MMPSN','PSPRT','PSPRT-ZKAX-21-0','1','5.370','5.370','1','5.370','5.370','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZKAX-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-21-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0001','1','PSGT-ZKAX-22-0','1','2.830','2.830','TOKO','MMPSN','TOKO','MMPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZKAX-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-22-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZKAX-22-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAX-22-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-11-11 08:23:46' WHERE kode_barang='PSGT-ZKAX-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZKAX-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-11-11 08:23:46','TOKO','MMPSN','PSGT','PSGT-ZKAX-22-0','1','2.830','2.830','1','2.830','2.830','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-ZKAX-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-22-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261111-0001','2026-11-11','08:23','16.390','kasir','2026-11-11 08:23:45'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','09:06:01'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-11 ','10:29:32'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-11-11 ','10:34:51'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-05174','ADL','1','PER','WEDRING','','','4.000','','925.00','2','100000','0','1600000','0','1600000','sz cwo 21.5 sz cwe 10.5 (express 200rb)','gf Berkshbire ccn cwe : Fido... ccn cwo : Sonya...','oversize cwo','0','0','100000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261111-0001','2026-11-11','2026-11-11 10:38:07','PESANAN : DP-05174','-','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-261111-0002','D','2026-11-11','10:38:07','TBC','PESANAN','DP-05174','30862264964','1700000','30863964964','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-05174','2026-11-11','2026-11-11','10:38:07','PLG0018796','ADL','2026-11-18','jogja','2026-11-11 10:38:07','4.000','0','0','0','1700000','0','0','1700000','1700000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','11:25:57'); 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-05175','MIL','1','PER','WEDRING PROMO','','','4.000','','925.00','1','100000','0','950000','0','950000','sz cwe 16 grf B & W SR-05','sz cwo 16 grf B & W','Font: Brush Script','100000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261111-0002','2026-11-11','2026-11-11 11:55:27','PESANAN : DP-05175','.','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-261111-0003','D','2026-11-11','11:55:27','TBC','PESANAN','DP-05175','30863964964','1050000','30865014964','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-05175','2026-11-11','2026-11-11','11:55:27','PLG0018797','MIL','2026-12-15','kasirbip','2026-11-11 11:55:27','4.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-261111-0001','kasirbip','1',' 800K-165-0','TOKO','DUPERBDG','LXPER-ZDBH-32-0','CINCIN SILVER 925 ','','2.220','1','100.00','227000','0','0','17800','900000','0','0','0','900000','PUT','00042848','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDBH-32-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-11-11' AND kode_barang='LXPER-ZDBH-32-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-261111-0001','2026-11-11','2.220','2026-11-11','12:00:18','PLG0018798','900000','900000','0','900000','0','kasirbip','2026-11-11 12:00:17','FJ-261111-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-11-11','FJ-261111-0001','2026-11-11','12:00:18','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-261111-0003','2026-11-11','2026-11-11 12:00:17','PENJUALAN : FJ-261111-0001','.','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-261111-0004','D','2026-11-11','12:00:18','TBC','PENJUALAN','FJ-261111-0001','30865014964','900000','30865914964','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-261111-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-261111-0002','kasirbip',' 1',' 500K-20-00','TOKO','DUPERBDG','LXPER-ZKXG-22-0','CINCIN SILVER 925 YL01 ','','2.230','1','100.00','228000','0','0','17800','600000','0','0','0','600000','PUT','00049151','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZKXG-22-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-11-11' AND kode_barang='LXPER-ZKXG-22-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-261111-0002','2026-11-11','2.230','2026-11-11','12:00:18','PLG0018799','600000','600000','0','600000','0','kasirbip','2026-11-11 12:00:17','FJ-261111-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-11-11','FJ-261111-0002','2026-11-11','12:00:18','PUT','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-261111-0004','2026-11-11','2026-11-11 12:00:17','PENJUALAN : FJ-261111-0002','.','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-261111-0005','D','2026-11-11','12:00:18','TBC','PENJUALAN','FJ-261111-0002','30865914964','600000','30866514964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1500000' WHERE no_faktur_jual='FJ-261111-0002' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-11 ','12:33:15'); 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-05176','VAN','1','PLD','WEDDRING PRIA','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','PERMATA 1','GRF: T&R FONT: Brush script','FINISHING: PUTIH 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-261111-0005','2026-11-11','2026-11-11 12:36:43','PESANAN : DP-05176','-','TBC','1500000','1500000'); 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-261111-0006','D','2026-11-11','12:36:43','TBC','PESANAN','DP-05176','30866514964','1500000','30868014964','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-05176','2026-11-11','2026-11-11','12:36:43','PLG0018800','VAN','2026-12-06','sby','2026-11-11 12:36:43','4.000','0','0','0','1500000','0','750000','2160000','2160000','660000'); 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-261111-0003','sby','1',' DP-04662SB','TOKO','SBYPSN','PSPRT-ZKXF-41-0','CINCIN PERAK CM03 ','','3.390','1','100.00','346000','0','0','17800','1200000','0','0','0','1200000','VAN','00049092','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXF-41-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.390',berat_jual_asli=berat_jual_asli+'3.390',stock_jual='1',berat_akhir=berat_akhir-'3.390',berat_akhir_asli=berat_akhir_asli-'3.390',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='PSPRT-ZKXF-41-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-261111-0003','2026-11-11','3.390','2026-11-11','12:38:32','PLG0018801','1200000','1200000','0','1200000','0','sby','2026-11-11 12:38:31','FJ-261111-0003','DP-04662','1200000'); 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-11-11','FJ-261111-0003','2026-11-11','12:38:32','VAN','1200000','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-261111-0003' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-11 ','13:09:47'); 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-261111-0004','kasirbip','1',' 750K-115-3','TOKO','BIPPER','PBDG-ZKXI-22-0','CINCIN SILVER 925 ','','1.760','1','100.00','180000','0','0','17800','850000','0','0','0','850000','SULIS','00049204','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZKXI-22-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='PBDG-ZKXI-22-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-261111-0004','2026-11-11','1.760','2026-11-11','13:11:48','PLG0018802','850000','850000','0','850000','0','kasirbip','2026-11-11 13:11:48','FJ-261111-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-11-11','FJ-261111-0004','2026-11-11','13:11:48','SULIS','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-261111-0006','2026-11-11','2026-11-11 13:11:48','PENJUALAN : FJ-261111-0004','.','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-261111-0007','D','2026-11-11','13:11:48','TBC','PENJUALAN','FJ-261111-0004','30868014964','850000','30868864964','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-261111-0004' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0004'; 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-05177','MIL','1','PER','WEDDRING PROMO','','','4.000','','925.00','1','100000','0','850000','0','850000','sz cwe 13 grf Wiranata','sz cwo 18 grf Nine','font Yeseva','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-261111-0007','2026-11-11','2026-11-11 13:27:22','PESANAN : DP-05177','.','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-261111-0008','D','2026-11-11','13:27:22','TBC','PESANAN','DP-05177','30868864964','850000','30869714964','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-05177','2026-11-11','2026-11-11','13:27:22','PLG0018803','MIL','2026-12-15','kasirbip','2026-11-11 13:27:22','4.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','14:16: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-261111-0005','jogja','1',' DP-04569JO','TOKO','JOGPSN','PSPRT-ZJBH-19-0','CINCIN PERAK YL10 ','','4.580','1','100.00','468000','0','0','17800','950000','0','0','0','950000','ADL','00048720','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBH-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.580',berat_jual_asli=berat_jual_asli+'4.580',stock_jual='1',berat_akhir=berat_akhir-'4.580',berat_akhir_asli=berat_akhir_asli-'4.580',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='PSPRT-ZJBH-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261111-0005','2026-11-11','4.580','2026-11-11','14:32:02','PLG0018804','950000','950000','0','950000','0','jogja','2026-11-11 14:32:01','FJ-261111-0005','DP-04569','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-11-11','FJ-261111-0005','2026-11-11','14:32:02','ADL','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-261111-0005' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi=''; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','14:41:08'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261111-0006','kasir','1',' TFCMP75-84','TOKO','TFCINMAS','TFCMP-ZBBF-32-0','THIFA CINCIN MAS PUTIH ','','1.500','1','84.00','2938000','0','0','17800','3045000','0','0','0','3045000','FAISAL','00041931','TFCMP','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMP-ZBBF-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='TFCMP-ZBBF-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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-261111-0006','2026-11-11','1.500','2026-11-11','14:41:43','PLG0018805','3045000','3045000','0','3045000','0','kasir','2026-11-11 14:41:42','FJ-261111-0006','','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-11-11','FJ-261111-0006','2026-11-11','14:41:43','FAISAL','3045000','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-261111-0008','2026-11-11','2026-11-11 14:41:42','PENJUALAN : FJ-261111-0006','.','TBC','3045000','3045000','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-261111-0009','D','2026-11-11','14:41:43','TBC','PENJUALAN','FJ-261111-0006','30869714964','3045000','30872759964','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='3045000' WHERE no_faktur_jual='FJ-261111-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0006'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','15:08:23'); 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-261111-0007','kasirbip','1',' DP-04779BI','TOKO','BIPPSN','PSPLT-ZKXF-20-0','CINCIN PALADIUM ','','1.620','1','17.00','365000','0','0','17800','1267000','0','0','0','1267000','SULIS','00049071','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXF-20-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='PSPLT-ZKXF-20-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-261111-0007','2026-11-11','1.620','2026-11-11','15:13:57','PLG0018806','1267000','1267000','0','1267000','0','kasirbip','2026-11-11 15:13:56','FJ-261111-0007','DP-04779','1100000'); 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-11-11','FJ-261111-0007','2026-11-11','15:13:57','SULIS','1267000','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-261111-0009','2026-11-11','2026-11-11 15:13:56','PENJUALAN : FJ-261111-0007','.','TBC','167000','167000','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-261111-0010','D','2026-11-11','15:13:57','TBC','PENJUALAN','FJ-261111-0007','30872759964','167000','30872926964','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='167000' WHERE no_faktur_jual='FJ-261111-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-261111-0008','kasirbip',' 1',' DP-04778BI','TOKO','BIPPSN','PSPLT-ZKXF-21-0','CINCIN PALADIUM ','','2.150','1','17.00','483000','0','0','17800','1452500','0','0','0','1452500','SULIS','00049072','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXF-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='PSPLT-ZKXF-21-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-261111-0008','2026-11-11','2.150','2026-11-11','15:13:57','PLG0018807','1452500','1452500','0','1452500','0','kasirbip','2026-11-11 15:13:56','FJ-261111-0007','DP-04778','1100000'); 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-11-11','FJ-261111-0008','2026-11-11','15:13:57','SULIS','1452500','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-261111-0010','2026-11-11','2026-11-11 15:13:56','PENJUALAN : FJ-261111-0008','.','TBC','352500','352500','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-261111-0011','D','2026-11-11','15:13:57','TBC','PENJUALAN','FJ-261111-0008','30872926964','352500','30873279464','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='519500' WHERE no_faktur_jual='FJ-261111-0008' 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-05178','KUR','1','PLD','WED RING','','','6.000','','10.00','1','1200000','350000','0','850000','2950000','sz 33 putih doff semprot 1 zirkon','font berkshire swash grf NADA 11.09.2026','','','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261111-0011','2026-11-11','2026-11-11 15:31:45','PESANAN : DP-05178','.','TBC','2360000','2360000'); 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-261111-0012','D','2026-11-11','15:31:45','TBC','PESANAN','DP-05178','30873279464','2360000','30875639464','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-05178','2026-11-11','2026-11-11','15:31:45','PLG0018808','KUR','2026-11-17','kasirbip','2026-11-11 15:31:45','6.000','0','0','0','2360000','0','850000','2950000','2950000','590000'); 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-05179','KUR','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','850000','1900000','sz 18 putih doff semprot 1 zirkon','font berkshire swash FAIZAL 11.09.2026','EXPRESS 200.000','','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261111-0012','2026-11-11','2026-11-11 15:33:23','PESANAN : DP-05179','.','TBC','1520000','1520000'); 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-261111-0013','D','2026-11-11','15:33:23','TBC','PESANAN','DP-05179','30875639464','1520000','30877159464','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-05179','2026-11-11','2026-11-11','15:33:23','PLG0018809','KUR','2026-11-17','kasirbip','2026-11-11 15:33:23','3.000','0','0','0','1520000','0','850000','1900000','1900000','380000'); 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-20261111-0002','1','PSPRT-ZKXI-9-0','1','3.090','3.090','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXI-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXI-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXI-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPRT-ZKXI-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXI-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-11-11 15:51:26','TOKO','DUPSN','PSPRT','PSPRT-ZKXI-9-0','1','3.090','3.090','1','3.090','3.090','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-ZKXI-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPRT-ZKXI-10-0','1','3.170','3.170','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXI-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-10-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXI-10-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXI-10-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPRT-ZKXI-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXI-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-11-11 15:51:26','TOKO','DUPSN','PSPRT','PSPRT-ZKXI-10-0','1','3.170','3.170','1','3.170','3.170','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-ZKXI-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-10-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPRT-ZKXI-11-0','1','3.640','3.640','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXI-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-11-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXI-11-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXI-11-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPRT-ZKXI-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXI-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-11-11 15:51:26','TOKO','DUPSN','PSPRT','PSPRT-ZKXI-11-0','1','3.640','3.640','1','3.640','3.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-ZKXI-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-11-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPLT-ZKXI-12-0','1','2.220','2.220','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXI-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXI-12-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXI-12-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXI-12-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPLT-ZKXI-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXI-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-11-11 15:51:26','TOKO','DUPSN','PSPLT','PSPLT-ZKXI-12-0','1','2.220','2.220','1','2.220','2.220','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-ZKXI-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXI-12-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPRT-ZKXI-13-0','1','4.500','4.500','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXI-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-13-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXI-13-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXI-13-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPRT-ZKXI-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXI-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-11-11 15:51:26','TOKO','DUPSN','PSPRT','PSPRT-ZKXI-13-0','1','4.500','4.500','1','4.500','4.500','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-ZKXI-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-13-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPRT-ZKXI-14-0','1','3.860','3.860','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXI-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-14-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXI-14-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXI-14-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPRT-ZKXI-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXI-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-11-11 15:51:26','TOKO','DUPSN','PSPRT','PSPRT-ZKXI-14-0','1','3.860','3.860','1','3.860','3.860','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZKXI-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-14-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPRT-ZKXI-15-0','1','1.740','1.740','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXI-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-15-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXI-15-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXI-15-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPRT-ZKXI-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXI-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-11-11 15:51:26','TOKO','DUPSN','PSPRT','PSPRT-ZKXI-15-0','1','1.740','1.740','1','1.740','1.740','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-ZKXI-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-15-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPRT-ZKAX-16-0','1','3.080','3.080','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKAX-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-16-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKAX-16-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAX-16-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPRT-ZKAX-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKAX-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-11-11 15:51:26','TOKO','DUPSN','PSPRT','PSPRT-ZKAX-16-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-ZKAX-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-16-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPLT-ZKAX-17-0','1','2.570','2.570','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKAX-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-17-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKAX-17-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAX-17-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPLT-ZKAX-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKAX-17-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-11 15:51:26','TOKO','DUPSN','PSPLT','PSPLT-ZKAX-17-0','1','2.570','2.570','1','2.570','2.570','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-ZKAX-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-17-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPLT-ZKAX-18-0','1','3.120','3.120','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKAX-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-18-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKAX-18-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAX-18-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPLT-ZKAX-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKAX-18-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-11 15:51:26','TOKO','DUPSN','PSPLT','PSPLT-ZKAX-18-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-ZKAX-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-18-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSGT-ZKAX-19-0','1','2.010','2.010','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZKAX-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-19-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZKAX-19-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAX-19-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSGT-ZKAX-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZKAX-19-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-11 15:51:26','TOKO','DUPSN','PSGT','PSGT-ZKAX-19-0','1','2.010','2.010','1','2.010','2.010','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-ZKAX-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-19-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSGT-ZKAX-26-0','1','2.080','2.080','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZKAX-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-26-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZKAX-26-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAX-26-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSGT-ZKAX-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZKAX-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-11-11 15:51:26','TOKO','DUPSN','PSGT','PSGT-ZKAX-26-0','1','2.080','2.080','1','2.080','2.080','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-ZKAX-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-26-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPRT-ZKAX-27-0','1','3.750','3.750','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKAX-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKAX-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAX-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPRT-ZKAX-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKAX-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-11-11 15:51:26','TOKO','DUPSN','PSPRT','PSPRT-ZKAX-27-0','1','3.750','3.750','1','3.750','3.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-ZKAX-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPRT-ZKAX-28-0','1','2.180','2.180','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKAX-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-28-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKAX-28-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAX-28-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPRT-ZKAX-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKAX-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-11-11 15:51:26','TOKO','DUPSN','PSPRT','PSPRT-ZKAX-28-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-ZKAX-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-28-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0002','1','PSPRT-ZKAX-30-0','1','3.350','3.350','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKAX-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKAX-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAX-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-11-11 15:51:26' WHERE kode_barang='PSPRT-ZKAX-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKAX-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-11-11 15:51:26','TOKO','DUPSN','PSPRT','PSPRT-ZKAX-30-0','1','3.350','3.350','1','3.350','3.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-ZKAX-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261111-0002','2026-11-11','15:50','44.360','kasirbip','2026-11-11 15:51:26'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-11 ','16:08:17'); 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-05180','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 23 putih glossy dibuat tanpa mata','font berkshire swash grf cafa','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261111-0013','2026-11-11','2026-11-11 16:22:24','PESANAN : DP-05180','.','TBC','1400000','1400000'); 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-261111-0014','D','2026-11-11','16:22:24','TBC','PESANAN','DP-05180','30877159464','1400000','30878559464','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-05180','2026-11-11','2026-11-11','16:22:24','PLG0018810','SULIS','2026-12-10','kasirbip','2026-11-11 16:22:24','3.000','0','0','0','1400000','0','750000','1800000','1800000','400000'); 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-20261111-0003','1','PSGT-ZKAX-1-0','1','4.000','4.000','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZKAX-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-1-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZKAX-1-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAX-1-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-11 16:27:00' WHERE kode_barang='PSGT-ZKAX-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZKAX-1-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-11-11 16:27:00','TOKO','BIPPSN','PSGT','PSGT-ZKAX-1-0','1','4.000','4.000','1','4.000','4.000','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-ZKAX-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-1-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0003','1','PSPLT-ZKAX-2-0','1','3.680','3.680','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKAX-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-2-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKAX-2-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAX-2-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-11 16:27:00' WHERE kode_barang='PSPLT-ZKAX-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKAX-2-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-11-11 16:27:00','TOKO','BIPPSN','PSPLT','PSPLT-ZKAX-2-0','1','3.680','3.680','1','3.680','3.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-ZKAX-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-2-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0003','1','PSPLT-ZKAX-3-0','1','3.160','3.160','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKAX-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-3-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKAX-3-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAX-3-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-11 16:27:00' WHERE kode_barang='PSPLT-ZKAX-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKAX-3-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-11-11 16:27:00','TOKO','BIPPSN','PSPLT','PSPLT-ZKAX-3-0','1','3.160','3.160','1','3.160','3.160','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-ZKAX-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-3-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0003','1','PSGT-ZKAX-4-0','1','2.820','2.820','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZKAX-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-4-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZKAX-4-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAX-4-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-11 16:27:00' WHERE kode_barang='PSGT-ZKAX-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZKAX-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-11-11 16:27:00','TOKO','BIPPSN','PSGT','PSGT-ZKAX-4-0','1','2.820','2.820','1','2.820','2.820','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-ZKAX-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-4-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0003','1','PSGT-ZKAX-5-0','1','3.000','3.000','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZKAX-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-5-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZKAX-5-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAX-5-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-11 16:27:00' WHERE kode_barang='PSGT-ZKAX-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZKAX-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-11-11 16:27:00','TOKO','BIPPSN','PSGT','PSGT-ZKAX-5-0','1','3.000','3.000','1','3.000','3.000','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-ZKAX-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-5-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0003','1','PSPRT-ZKAX-20-0','1','1.250','1.250','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKAX-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-20-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKAX-20-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAX-20-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-11-11 16:27:00' WHERE kode_barang='PSPRT-ZKAX-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKAX-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-11-11 16:27:00','TOKO','BIPPSN','PSPRT','PSPRT-ZKAX-20-0','1','1.250','1.250','1','1.250','1.250','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZKAX-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAX-20-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261111-0003','2026-11-11','16:26','17.910','kasirbip','2026-11-11 16:27:00'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-11 ','16:28:16'); UPDATE tt_service_head SET tgl_selesai='2026-11-11', status ='DONE' WHERE no_service='SV-02310'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02310'; 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-261111-0009','kasirbip','1',' DP-04568BI','TOKO','BIPPSN','PSPRT-ZKXF-18-0','CINCIN PERAK SR03 YL01 ','','3.340','1','100.00','341000','0','0','17800','950000','0','0','0','950000','SAL','00049069','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXF-18-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.340',berat_jual_asli=berat_jual_asli+'3.340',stock_jual='1',berat_akhir=berat_akhir-'3.340',berat_akhir_asli=berat_akhir_asli-'3.340',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='PSPRT-ZKXF-18-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-261111-0009','2026-11-11','3.340','2026-11-11','17:17:17','PLG0018811','950000','950000','0','950000','0','kasirbip','2026-11-11 17:17:16','FJ-261111-0009','DP-04568','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-11-11','FJ-261111-0009','2026-11-11','17:17:17','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-261111-0009' 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-05181','ADL','1','PER','WEDRING','','','2.500','','925.00','1','100000','0','900000','0','900000','sz cwe 14','gf Vintage : Hamdan...Tiara','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-261111-0014','2026-11-11','2026-11-11 17:17:46','PESANAN : DP-05181','-','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-261111-0015','D','2026-11-11','17:17:46','TBC','PESANAN','DP-05181','30878559464','900000','30879459464','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-05181','2026-11-11','2026-11-11','17:17:46','PLG0018812','ADL','2026-11-21','jogja','2026-11-11 17:17:46','2.500','0','0','0','900000','0','0','900000','900000','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0009'; 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-05182','ADL','1','PER','WEDRING','','','2.500','','925.00','1','100000','0','600000','0','600000','sz cwo 19 YL01','gf Vintage : Hamdan...Tiara 25.11.26','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-261111-0015','2026-11-11','2026-11-11 17:24:22','PESANAN : DP-05182','-','TBC','600000','600000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261111-0016','D','2026-11-11','17:24:22','TBC','PESANAN','DP-05182','30879459464','600000','30880059464','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-05182','2026-11-11','2026-11-11','17:24:22','PLG0018813','ADL','2026-11-21','jogja','2026-11-11 17:24:22','2.500','0','0','0','600000','0','0','600000','600000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','17:30:55'); UPDATE th_user_login SET tgl_logout = '2026-11-11', jam_logout = '17:43:58' WHERE user_id = 'kasirbip' AND tgl_login = '2026-11-11' AND jam_login= '16:08:17'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-11-11 ','17:44:16'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-11 ','17:50:59'); 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-261111-0010','kasirbip','1',' 800K-23-00','TOKO','DUPERBDG','LXPER-ZKXG-23-0','CINCIN SILVER 925 YL10 ','','4.900','1','100.00','501000','0','0','17800','950000','0','0','0','950000','MIL','00049152','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZKXG-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.900',berat_jual_asli=berat_jual_asli+'4.900',stock_jual='1',berat_akhir=berat_akhir-'4.900',berat_akhir_asli=berat_akhir_asli-'4.900',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='LXPER-ZKXG-23-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-261111-0010','2026-11-11','4.900','2026-11-11','18:09:47','PLG0018814','950000','950000','0','950000','0','kasirbip','2026-11-11 18:09:47','FJ-261111-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-11-11','FJ-261111-0010','2026-11-11','18:09:47','MIL','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-261111-0016','2026-11-11','2026-11-11 18:09:47','PENJUALAN : FJ-261111-0010','.','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-261111-0017','D','2026-11-11','18:09:47','TBC','PENJUALAN','FJ-261111-0010','30880059464','950000','30881009464','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='950000' WHERE no_faktur_jual='FJ-261111-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-261111-0011','kasirbip','1',' DP-04837DU','TOKO','DUPSN','PSPLT-ZKXC-11-0','CINCIN PALADIUM ','','2.220','1','17.00','766000','0','0','17800','1577000','0','0','0','1577000','MIL','00048888','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXC-11-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-11-11' AND kode_barang='PSPLT-ZKXC-11-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-261111-0011','2026-11-11','2.220','2026-11-11','18:37:03','PLG0018815','1577000','1577000','0','1577000','0','kasirbip','2026-11-11 18:37:03','FJ-261111-0011','DP-04837','1340000'); 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-11-11','FJ-261111-0011','2026-11-11','18:37:03','MIL','1577000','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-261111-0017','2026-11-11','2026-11-11 18:37:03','PENJUALAN : FJ-261111-0011','.','TBC','237000','237000','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-261111-0018','D','2026-11-11','18:37:03','TBC','PENJUALAN','FJ-261111-0011','30881009464','237000','30881246464','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='237000' WHERE no_faktur_jual='FJ-261111-0011' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261111-0012','kasirbip',' 1',' DP-04836DU','TOKO','DUPSN','PSGT-ZKXF-75-0','CINCIN EMAS ','','2.530','1','57.00','3310000','0','0','17800','5354000','0','0','0','5354000','MIL','00049126','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZKXF-75-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.530',berat_jual_asli=berat_jual_asli+'2.530',stock_jual='1',berat_akhir=berat_akhir-'2.530',berat_akhir_asli=berat_akhir_asli-'2.530',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='PSGT-ZKXF-75-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-261111-0012','2026-11-11','2.530','2026-11-11','18:37:03','PLG0018816','5354000','5354000','0','5354000','0','kasirbip','2026-11-11 18:37:03','FJ-261111-0011','DP-04836','4240000'); 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-11-11','FJ-261111-0012','2026-11-11','18:37:03','MIL','5354000','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-261111-0018','2026-11-11','2026-11-11 18:37:03','PENJUALAN : FJ-261111-0012','.','TBC','1114000','1114000','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-261111-0019','D','2026-11-11','18:37:03','TBC','PENJUALAN','FJ-261111-0012','30881246464','1114000','30882360464','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='1351000' WHERE no_faktur_jual='FJ-261111-0012' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261111-0013','kasir','1',' TFCMR75-82','TOKO','TFCINMAS','TFCMR-ZJBX-37-0','THIFA CINCIN MAS RG ','','0.700','1','82.00','1339000','0','0','17800','1400000','0','0','0','1400000','RISIANA','00048370','TFCMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZJBX-37-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='TFCMR-ZJBX-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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-261111-0013','2026-11-11','0.700','2026-11-11','18:38:20','PLG0018817','1400000','1400000','0','1400000','1400000','kasir','2026-11-11 18:38:20','FJ-261111-0013','','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-11-11','FJ-261111-0013','2026-11-11','18:38:20','RISIANA','1400000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261111-0002','D','2026-11-11','18:38:20','kasir','PENJUALAN','FJ-261111-0013','22179100','1400000','23579100'); 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-20261111-0004','1','PSPLT-ZKXI-3-0','1','1.920','1.920','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXI-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXI-3-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXI-3-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXI-3-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-11 18:48:21' WHERE kode_barang='PSPLT-ZKXI-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXI-3-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-11-11 18:48:21','TOKO','JOGPSN','PSPLT','PSPLT-ZKXI-3-0','1','1.920','','1','1.920','','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-ZKXI-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXI-3-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0004','1','PSPLT-ZKAX-24-0','1','2.580','2.580','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKAX-24-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-24-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKAX-24-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAX-24-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-11 18:48:21' WHERE kode_barang='PSPLT-ZKAX-24-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKAX-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-11-11 18:48:21','TOKO','JOGPSN','PSPLT','PSPLT-ZKAX-24-0','1','2.580','','1','2.580','','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-ZKAX-24-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-24-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0004','1','PSGT-ZKAX-29-0','1','1.850','1.850','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZKAX-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZKAX-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAX-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-11 18:48:21' WHERE kode_barang='PSGT-ZKAX-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZKAX-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-11-11 18:48:21','TOKO','JOGPSN','PSGT','PSGT-ZKAX-29-0','1','1.850','','1','1.850','','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-ZKAX-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAX-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0004','1','PSPLT-ZKAX-33-0','1','4.020','4.020','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKAX-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-33-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKAX-33-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAX-33-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-11 18:48:21' WHERE kode_barang='PSPLT-ZKAX-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKAX-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-11-11 18:48:21','TOKO','JOGPSN','PSPLT','PSPLT-ZKAX-33-0','1','4.020','','1','4.020','','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-ZKAX-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAX-33-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0004','1','PSPRT-ZKXI-2-0','1','3.460','3.460','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZKXI-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-2-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZKXI-2-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXI-2-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-11 18:48:21' WHERE kode_barang='PSPRT-ZKXI-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZKXI-2-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-11-11 18:48:21','TOKO','JOGPSN','PSPRT','PSPRT-ZKXI-2-0','1','3.460','','1','3.460','','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-ZKXI-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXI-2-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261111-0004','2026-11-11','18:34','13.830','jogja','2026-11-11 18:48:21'); 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-20261111-0005','1','PJOG-ZKXG-49-0','1','4.640','4.640','TOKO','JOGPER','TOKO','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZKXG-49-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZKXG-49-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZKXG-49-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZKXG-49-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-11-11 18:56:15' WHERE kode_barang='PJOG-ZKXG-49-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZKXG-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-11-11 18:56:15','TOKO','JOGPER','PJOG','PJOG-ZKXG-49-0','1','4.640','','1','4.640','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZKXG-49-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZKXG-49-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0005','1','PJOG-ZKXG-46-0','1','2.380','2.380','TOKO','JOGPER','TOKO','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZKXG-46-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZKXG-46-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZKXG-46-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZKXG-46-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-11-11 18:56:15' WHERE kode_barang='PJOG-ZKXG-46-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZKXG-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-11-11 18:56:15','TOKO','JOGPER','PJOG','PJOG-ZKXG-46-0','1','2.380','','1','2.380','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZKXG-46-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZKXG-46-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0005','1','PJOG-ZKXG-47-0','1','2.370','2.370','TOKO','JOGPER','TOKO','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZKXG-47-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZKXG-47-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZKXG-47-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZKXG-47-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-11-11 18:56:15' WHERE kode_barang='PJOG-ZKXG-47-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZKXG-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-11-11 18:56:15','TOKO','JOGPER','PJOG','PJOG-ZKXG-47-0','1','2.370','','1','2.370','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZKXG-47-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZKXG-47-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' 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-20261111-0005','1','PJOG-ZKXG-48-0','1','5.230','5.230','TOKO','JOGPER','TOKO','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZKXG-48-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZKXG-48-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZKXG-48-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZKXG-48-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-11-11 18:56:15' WHERE kode_barang='PJOG-ZKXG-48-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZKXG-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-11-11 18:56:15','TOKO','JOGPER','PJOG','PJOG-ZKXG-48-0','1','5.230','','1','5.230','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' 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='PJOG-ZKXG-48-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZKXG-48-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-11' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261111-0005','2026-11-11','18:54','14.620','jogja','2026-11-11 18:56:15'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','19:00:20'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','19:02:47'); 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-261111-0014','kasir','1',' 800K-19-13','TOKO','MMPER','PMM-ZJCX-32-0','CINCIN SILVER 925 ','','3.210','1','100.00','328000','0','0','17800','900000','0','0','0','900000','ELLA','00048796','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZJCX-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.210',berat_jual_asli=berat_jual_asli+'3.210',stock_jual='1',berat_akhir=berat_akhir-'3.210',berat_akhir_asli=berat_akhir_asli-'3.210',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='PMM-ZJCX-32-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-261111-0014','2026-11-11','3.210','2026-11-11','19:04:03','PLG0018818','900000','900000','0','900000','0','kasir','2026-11-11 19:04:02','FJ-261111-0014','','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-11-11','FJ-261111-0014','2026-11-11','19:04:03','ELLA','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-261111-0019','2026-11-11','2026-11-11 19:04:02','PENJUALAN : FJ-261111-0014','0','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-261111-0020','D','2026-11-11','19:04:03','TBC','PENJUALAN','FJ-261111-0014','30882360464','900000','30883260464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); 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-261111-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-261111-0015','kasir','1',' TFGRR75-85','TOKO','TFGLR','TFGRR-ZHBE-112-0','THIFA GELANG RANTAI RG ','','2.850','1','85.00','5647000','0','0','17800','5750000','0','0','0','5750000','FAISAL','00046470','TFGRR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-ZHBE-112-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.850',berat_jual_asli=berat_jual_asli+'2.850',stock_jual='1',berat_akhir=berat_akhir-'2.850',berat_akhir_asli=berat_akhir_asli-'2.850',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='TFGRR-ZHBE-112-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' 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-261111-0015','2026-11-11','2.850','2026-11-11','19:12:13','PLG0018819','5750000','5750000','0','5750000','5750000','kasir','2026-11-11 19:12:12','FJ-261111-0015','','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-11-11','FJ-261111-0015','2026-11-11','19:12:13','FAISAL','5750000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261111-0003','D','2026-11-11','19:12:13','kasir','PENJUALAN','FJ-261111-0015','23579100','5750000','29329100'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','19:13:22'); 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-261111-0016','kasir','1',' TFCMR75-87','TOKO','TFCINMAS','TFCMR-ZJBX-46-0','THIFA CINCIN MAS RG ','','0.540','1','87.00','1096000','0','0','17800','1150000','0','0','0','1150000','FAISAL','00048379','TFCMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZJBX-46-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='TFCMR-ZJBX-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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-261111-0016','2026-11-11','0.540','2026-11-11','19:14:55','PLG0018820','1150000','1150000','0','1150000','1150000','kasir','2026-11-11 19:14:54','FJ-261111-0016','','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-11-11','FJ-261111-0016','2026-11-11','19:14:55','FAISAL','1150000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261111-0004','D','2026-11-11','19:14:55','kasir','PENJUALAN','FJ-261111-0016','29329100','1150000','30479100'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0016'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','19:29:13'); 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-261111-0017','kasirbip','1',' DP-04592DU','TOKO','DUPSN','PSPRT-ZKXI-11-0','CINCIN PERAK SR04 YL01 ','','3.640','1','100.00','372000','0','0','17800','1050000','0','0','0','1050000','MIL','00049193','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZKXI-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.640',berat_jual_asli=berat_jual_asli+'3.640',stock_jual='1',berat_akhir=berat_akhir-'3.640',berat_akhir_asli=berat_akhir_asli-'3.640',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='PSPRT-ZKXI-11-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-261111-0017','2026-11-11','3.640','2026-11-11','19:30:23','PLG0018821','1050000','1050000','0','1050000','0','kasirbip','2026-11-11 19:30:22','FJ-261111-0017','DP-04592','1050000'); 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-11-11','FJ-261111-0017','2026-11-11','19:30:23','MIL','1050000','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-261111-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-261111-0018','kasir','1',' DP-04762MM','TOKO','MMPSN','PSPLT-ZKAX-7-0','CINCIN PALADIUM ','','2.990','1','17.00','671000','0','0','17800','1826500','0','0','0','1826500','ELLA','00049273','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKAX-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.990',berat_jual_asli=berat_jual_asli+'2.990',stock_jual='1',berat_akhir=berat_akhir-'2.990',berat_akhir_asli=berat_akhir_asli-'2.990',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='PSPLT-ZKAX-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-261111-0018','2026-11-11','2.990','2026-11-11','19:39:51','PLG0018822','1826500','1826500','0','1826500','0','kasir','2026-11-11 19:39:50','FJ-261111-0018','DP-04762','1884000'); 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-11-11','FJ-261111-0018','2026-11-11','19:39:51','ELLA','1826500','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-261111-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-261111-0019','kasir',' 1',' DP-04760MM','TOKO','MMPSN','PSGT-ZKXF-58-0','CINCIN EMAS SR04 ','','1.150','1','57.00','1505000','0','0','17800','2820000','0','0','0','2820000','ELLA','00049109','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZKXF-58-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-11-11' AND kode_barang='PSGT-ZKXF-58-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-261111-0019','2026-11-11','1.150','2026-11-11','19:39:51','PLG0018823','2820000','2820000','0','2820000','0','kasir','2026-11-11 19:39:50','FJ-261111-0018','DP-04760','2472000'); 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-11-11','FJ-261111-0019','2026-11-11','19:39:51','ELLA','2820000','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-261111-0020','2026-11-11','2026-11-11 19:39:50','PENJUALAN : FJ-261111-0019','0','TBC','348000','348000','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-261111-0021','D','2026-11-11','19:39:51','TBC','PENJUALAN','FJ-261111-0019','30883260464','348000','30883608464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='348000' WHERE no_faktur_jual='FJ-261111-0019' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-11 ','19:44:43'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0018'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0017'; 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-261111-0020','sby','1',' DP-04706SB','TOKO','SBYPSN','PSPLT-ZKXE-29-0','CINCIN PALADIUM ','','3.200','1','17.00','719000','0','0','17800','1880000','0','0','0','1880000','ARA','00049049','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZKXE-29-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-11-11' AND kode_barang='PSPLT-ZKXE-29-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-261111-0020','2026-11-11','3.200','2026-11-11','19:48:33','PLG0018824','1880000','1880000','0','1880000','0','sby','2026-11-11 19:48:31','FJ-261111-0020','DP-04706','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-11-11','FJ-261111-0020','2026-11-11','19:48:33','ARA','1880000','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-261111-0021','2026-11-11','2026-11-11 19:48:31','PENJUALAN : FJ-261111-0020','','TBC','380000','380000','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-261111-0022','D','2026-11-11','19:48:33','TBC','PENJUALAN','FJ-261111-0020','30883608464','380000','30883988464','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='380000' WHERE no_faktur_jual='FJ-261111-0020' LIMIT 1; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-11-11', status ='CLOS' WHERE no_service='SV-02301'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02301'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261111-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261111-0020'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-12','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-12'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-11'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-11'; 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-11-11' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-11'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-11'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-11'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-11'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-12' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-11' 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-261112-0001','D','2026-11-12','21:11:20','TBC','SALDO AWAL','SALDO AWAL','0','30883988464','30883988464'); 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-261112-0001','D','2026-11-12','21:11:20','BCD','SALDO AWAL','SALDO AWAL','0','1468857500','1468857500'); 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-261112-0001','D','2026-11-12','21:11:20','KET','SALDO AWAL','SALDO AWAL','0','148641000','148641000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261112-0001','D','2026-11-12','21:11:20','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-261112-0001','D','2026-11-12','21:11:20','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-261112-0001','D','2026-11-12','21:11:20','','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-261112-0001','D','2026-11-12','21:11:20','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-261112-0001','D','2026-11-12','21:11:20','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-261112-0001','D','2026-11-12','21:11:20','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-261112-0001','D','2026-11-12','21:11:20','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-261112-0001','D','2026-11-12','21:11:20','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-261112-0001','D','2026-11-12','21:11:20','SHO','SALDO AWAL','SALDO AWAL','0','145535650','145535650'); UPDATE tp_system SET tgl_system='2026-11-12';