INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-09-07 ','08:05:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-07 ','08:05:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-07 ','08:50:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-07 ','09:17:22');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-09-07 ','09:24:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-09-07 ','10:04:21');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-07 ','10:35:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-07 ','10:35:46');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03892';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03892';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03892';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260907-0002','K','2026-09-07','10:44:34','kasirbip','PESANAN BATAL','DP-03892','8190300','0','8190300');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-09-07 ','12:38:25');
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-260907-0001','sby','1',' DP-03503SB','TOKO','SBYPSN','PSPLT-ZIXD-82-0','CINCIN PALADIUM ','','3.150','1','17.00','708000','0','0','17800','1922000','0','0','0','1922000','DIL','00046945','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIXD-82-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.150',berat_jual_asli=berat_jual_asli+'3.150',stock_jual='1',berat_akhir=berat_akhir-'3.150',berat_akhir_asli=berat_akhir_asli-'3.150',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='PSPLT-ZIXD-82-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-260907-0001','2026-09-07','3.150','2026-09-07','12:40:47','PLG0015564','1922000','1922000','0','1922000','0','sby','2026-09-07 12:40:47','FJ-260907-0001','DP-03503','1400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','FJ-260907-0001','2026-09-07','12:40:47','DIL','1922000','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-260907-0001','2026-09-07','2026-09-07 12:40:47','PENJUALAN : FJ-260907-0001','','TBC','522000','522000','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-260907-0002','D','2026-09-07','12:40:47','TBC','PENJUALAN','FJ-260907-0001','27484614964','522000','27485136964','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='522000' WHERE no_faktur_jual='FJ-260907-0001' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02241','SULIS','1','CCN SILVER','KROM PUTIH GLOSSY FONT VINTAGE ROTTER GRF','2.000','1','50000','50000');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02241','2026-09-07','2026-09-07','12:48:34','PLG0015565','kasirbip','2026-09-24','kasirbip','2026-09-07 12:48:34','2.000','0','0','0','0','0','50000','50000','50000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-07 ','12:59:19');
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-260907-0002','kasirbip','1',' DP-03653BI','TOKO','BIPPSN','PSPRT-ZIXC-6-0','CINCIN PERAK ','','1.400','1','100.00','143000','0','0','17800','1000000','0','0','0','1000000','SAL','00046836','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXC-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='PSPRT-ZIXC-6-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-260907-0002','2026-09-07','1.400','2026-09-07','14:20:06','PLG0015566','1000000','1000000','0','1000000','0','kasirbip','2026-09-07 14:20:05','FJ-260907-0002','DP-03653','1000000');
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-09-07','FJ-260907-0002','2026-09-07','14:20:06','SAL','1000000','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-260907-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260907-0003','kasirbip',' 1',' DP-03654BI','TOKO','BIPPSN','PSPRT-ZIXD-44-0','CINCIN PERAK ','','3.500','1','100.00','357000','0','0','17800','850000','0','0','0','850000','SAL','00046907','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXD-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.500',berat_jual_asli=berat_jual_asli+'3.500',stock_jual='1',berat_akhir=berat_akhir-'3.500',berat_akhir_asli=berat_akhir_asli-'3.500',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='PSPRT-ZIXD-44-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-260907-0003','2026-09-07','3.500','2026-09-07','14:20:06','PLG0015567','850000','850000','0','850000','0','kasirbip','2026-09-07 14:20:05','FJ-260907-0002','DP-03654','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','FJ-260907-0003','2026-09-07','14:20:06','SAL','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260907-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260907-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260907-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260907-0003';
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-03919','KUR','1','GOLD','WEDRING','','','2.500','','37.50','1','2400000','1400000','0','900000','4400000','size 11.5 crom putih glossy','zircon 9 Font Bershire','Grf Aldi','0','90000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260907-0002','2026-09-07','2026-09-07 14:53:22','PESANAN : DP-03919','.','TBC','3590000','3590000');
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-260907-0003','D','2026-09-07','14:53:22','TBC','PESANAN','DP-03919','27485136964','3590000','27488726964','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-03919','2026-09-07','2026-09-07','14:53:22','PLG0015568','KUR','2026-09-28','kasirbip','2026-09-07 14:53:22','2.500','0','0','0','3590000','0','900000','4490000','4490000','900000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-07 ','14:53:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-07 ','14:57:05');
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-260907-0004','kasirbip','1',' DP-03592BI','TOKO','BIPPSN','PSPRT-ZIXC-13-0','CINCIN PERAK SR03 YL01 ','','3.220','1','100.00','329000','0','0','17800','950000','0','0','0','950000','SULIS','00046843','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXC-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.220',berat_jual_asli=berat_jual_asli+'3.220',stock_jual='1',berat_akhir=berat_akhir-'3.220',berat_akhir_asli=berat_akhir_asli-'3.220',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='PSPRT-ZIXC-13-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-260907-0004','2026-09-07','3.220','2026-09-07','15:00:27','PLG0015569','950000','950000','0','950000','0','kasirbip','2026-09-07 15:00:27','FJ-260907-0004','DP-03592','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-09-07','FJ-260907-0004','2026-09-07','15:00:27','SULIS','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260907-0004' 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-03920','KUR','1','PER','WEDRING','','','2.000','','925.00','1','100000','0','850000','0','850000','size 15 crom putih doff semprot','Grf Nabila Font Berkshire','','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-260907-0003','2026-09-07','2026-09-07 15:03:01','PESANAN : DP-03920','.','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-260907-0004','D','2026-09-07','15:03:01','TBC','PESANAN','DP-03920','27488726964','850000','27489576964','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-03920','2026-09-07','2026-09-07','15:03:01','PLG0015570','KUR','2026-09-28','kasirbip','2026-09-07 15:03:01','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-07 ','15:03:54');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260907-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-03921','VAN','1','PER','WEDDRING WANITA','','','2.000','','925.00','1','100000','0','1000000','0','1000000','SIZE: 11','GRF: Rizky?? FONT: BERKSHIRE','PUTIH GLOSSY','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260907-0004','2026-09-07','2026-09-07 15:12:43','PESANAN : DP-03921','-','TBC','1000000','1000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260907-0005','D','2026-09-07','15:12:43','TBC','PESANAN','DP-03921','27489576964','1000000','27490576964','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-03921','2026-09-07','2026-09-07','15:12:43','PLG0015571','VAN','2026-10-01','sby','2026-09-07 15:12:43','2.000','0','0','0','1000000','0','0','1000000','1000000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03922','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','800000','0','800000','SIZE: 14','GRF: Aisyah?? FONT:BERKSHIRE','PUTIH','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-260907-0005','2026-09-07','2026-09-07 15:15:21','PESANAN : DP-03922','-','TBC','800000','800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260907-0006','D','2026-09-07','15:15:21','TBC','PESANAN','DP-03922','27490576964','800000','27491376964','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-03922','2026-09-07','2026-09-07','15:15:21','PLG0015572','VAN','2026-10-01','sby','2026-09-07 15:15:21','3.000','0','0','0','800000','0','0','800000','800000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-07 ','15:19:31');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03909';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03909';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03909';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260907-0003','K','2026-09-07','15:22:05','kasirbip','PESANAN BATAL','DP-03909','8190300','0','8190300');
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-03923','NAD','1','PER','WEDRING','','','4.000','','925.00','2','100000','0','950000','0','950000','sze cwe 19 sze cwo 18 SR-03','Grafir menyusul','','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-260907-0006','2026-09-07','2026-09-07 15:53:20','PESANAN : DP-03923','.','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260907-0007','D','2026-09-07','15:53:20','TBC','PESANAN','DP-03923','27491376964','950000','27492326964','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-03923','2026-09-07','2026-09-07','15:53:20','PLG0015573','NAD','2026-09-30','kasirbip','2026-09-07 15:53:20','4.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-07 ','15:54:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-07 ','15:56:20');
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-03924','DIL','1','PER','WEDD RING PRIA','','','2.000','','925.00','1','100000','0','850000','0','850000','PERMATA 1 BUTIR','SIZE 15 GRF: Oca ?? (BERKSHIRE)','PUTIH GLOSSY MIX DOFF','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-260907-0007','2026-09-07','2026-09-07 16:00:51','PESANAN : DP-03924','-','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-260907-0008','D','2026-09-07','16:00:51','TBC','PESANAN','DP-03924','27492326964','850000','27493176964','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-03924','2026-09-07','2026-09-07','16:00:51','PLG0015574','DIL','2026-09-16','sby','2026-09-07 16:00:51','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03925','VAN','1','GOLD','WEDDRING WANITA','','','2.500','','50.00','1','2400000','1800000','0','800000','5300000','PERMATA 5','SIZE: 11.5 GRF: Linda??Gatot','FONT: VINATAGE ROTTER EMAS PUTIH','50000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260907-0008','2026-09-07','2026-09-07 16:20:55','PESANAN : DP-03925','-','TBC','3700000','3700000');
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-260907-0009','D','2026-09-07','16:20:55','TBC','PESANAN','DP-03925','27493176964','3700000','27496876964','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-03925','2026-09-07','2026-09-07','16:20:55','PLG0015575','VAN','2026-10-01','sby','2026-09-07 16:20:55','2.500','0','0','0','3700000','0','800000','5350000','5350000','1650000');
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-03926','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','700000','2900000','SIZE: 19.5','GRF: Gatot??Linda FONT: VINTAGE ROTTER','FINISHING: PUTIH DOFF MIX GLOSSY','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260907-0009','2026-09-07','2026-09-07 16:23:31','PESANAN : DP-03926','-','TBC','2000000','2000000');
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-260907-0010','D','2026-09-07','16:23:31','TBC','PESANAN','DP-03926','27496876964','2000000','27498876964','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-03926','2026-09-07','2026-09-07','16:23:31','PLG0015576','VAN','2026-10-01','sby','2026-09-07 16:23:31','4.000','0','0','0','2000000','0','700000','2900000','2900000','900000');
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-260907-0005','kasirbip','1',' DP-03410DU','TOKO','DUPSN','PSPRT-ZIXD-104-0','1PS CINCIN PERAK ','','3.620','1','100.00','370000','0','0','17800','1400000','0','0','0','1400000','PUT','00046967','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXD-104-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.620',berat_jual_asli=berat_jual_asli+'3.620',stock_jual='1',berat_akhir=berat_akhir-'3.620',berat_akhir_asli=berat_akhir_asli-'3.620',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='PSPRT-ZIXD-104-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-260907-0005','2026-09-07','3.620','2026-09-07','16:36:23','PLG0015577','1400000','1400000','0','1400000','0','kasirbip','2026-09-07 16:36:23','FJ-260907-0005','DP-03410','1400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','FJ-260907-0005','2026-09-07','16:36:23','PUT','1400000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260907-0005' 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-09-07',  status ='CLOS' WHERE no_service='SV-02221';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02221';
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-03927','KUR','1','PER','CINCIN KAWIN','','','3.000','','925.00','1','100000','0','950000','0','950000','size cewe 15 grf Romy 03.10.2026 YL-01 100.000 kuning (24k)','Size cowo 18 grf Merlin 03.102026 YL-01 kuning (24k)','font vintge','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-260907-0010','2026-09-07','2026-09-07 17:48:15','PESANAN : DP-03927','.','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260907-0011','D','2026-09-07','17:48:15','TBC','PESANAN','DP-03927','27498876964','950000','27499826964','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-03927','2026-09-07','2026-09-07','17:48:15','PLG0015578','KUR','2026-09-28','kasirbip','2026-09-07 17:48:15','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-07 ','17:49:58');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260907-0005';
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-260907-0006','kasir','1',' TFCMR75-81','TOKO','TFCINMAS','TFCMR-YLXC-21-0','THIFA CINCIN MAS RG ','','1.040','1','81.00','2063000','0','0','17800','2210000','0','0','0','2210000','FAISAL','00040144','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YLXC-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='TFCMR-YLXC-21-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-260907-0006','2026-09-07','1.040','2026-09-07','18:20:01','PLG0015579','2210000','2210000','0','2210000','0','kasir','2026-09-07 18:20:00','FJ-260907-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-09-07','FJ-260907-0006','2026-09-07','18:20:01','FAISAL','2210000','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-260907-0011','2026-09-07','2026-09-07 18:20:00','PENJUALAN : FJ-260907-0006','.','TBC','2210000','2210000','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-260907-0012','D','2026-09-07','18:20:01','TBC','PENJUALAN','FJ-260907-0006','27499826964','2210000','27502036964','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='2210000' WHERE no_faktur_jual='FJ-260907-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260907-0006';
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-260907-0007','kasirbip','1',' DP-03338DU','TOKO','DUPSN','PSPLT-ZIXD-48-0','CINCIN PALADIUM YL10 ','','3.120','1','17.00','701000','0','0','17800','1842000','0','0','0','1842000','PUT','00046911','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIXD-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='PSPLT-ZIXD-48-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-260907-0007','2026-09-07','3.120','2026-09-07','18:49:21','PLG0015580','1842000','1842000','0','1842000','0','kasirbip','2026-09-07 18:49:20','FJ-260907-0007','DP-03338','1440000');
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-09-07','FJ-260907-0007','2026-09-07','18:49:21','PUT','1842000','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-260907-0012','2026-09-07','2026-09-07 18:49:20','PENJUALAN : FJ-260907-0007','.','TBC','402000','402000','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-260907-0013','D','2026-09-07','18:49:21','TBC','PENJUALAN','FJ-260907-0007','27502036964','402000','27502438964','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='402000' WHERE no_faktur_jual='FJ-260907-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-260907-0008','sby','1',' 900K-10-00','TOKO','SBYPER','PSBY-ZGBB-41-0','CINCIN SILVER 925 ','','1.900','1','100.00','194000','0','0','17800','1000000','0','0','0','1000000','DIL','00045532','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGBB-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='PSBY-ZGBB-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260907-0008','2026-09-07','1.900','2026-09-07','19:13:37','PLG0015581','1000000','1000000','0','1000000','0','sby','2026-09-07 19:13:37','FJ-260907-0008','','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-09-07','FJ-260907-0008','2026-09-07','19:13:37','DIL','1000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260907-0013','2026-09-07','2026-09-07 19:13:37','PENJUALAN : FJ-260907-0008','','TBC','1000000','1000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260907-0014','D','2026-09-07','19:13:37','TBC','PENJUALAN','FJ-260907-0008','27502438964','1000000','27503438964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1000000' WHERE no_faktur_jual='FJ-260907-0008' 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-260907-0009','sby','1',' 750K-175-0','TOKO','SBYPER','PSBY-ZHBH-40-0','CINCIN SILVER 925 ','','2.590','1','100.00','265000','0','0','17800','850000','0','0','0','850000','DIL','00046630','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZHBH-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.590',berat_jual_asli=berat_jual_asli+'2.590',stock_jual='1',berat_akhir=berat_akhir-'2.590',berat_akhir_asli=berat_akhir_asli-'2.590',stock_akhir='0' WHERE tanggal='2026-09-07' AND kode_barang='PSBY-ZHBH-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260907-0009','2026-09-07','2.590','2026-09-07','19:48:50','PLG0015582','850000','850000','0','850000','0','sby','2026-09-07 19:48:50','FJ-260907-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-07','FJ-260907-0009','2026-09-07','19:48:50','DIL','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-260907-0014','2026-09-07','2026-09-07 19:48:50','PENJUALAN : FJ-260907-0009','','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-260907-0015','D','2026-09-07','19:48:50','TBC','PENJUALAN','FJ-260907-0009','27503438964','850000','27504288964','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-260907-0009' 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-260907-0010','kasirbip','1',' 750K-12-29','TOKO','BIPPER','PBDG-ZHCA-43-0','CINCIN SILVER 925 ','','1.620','1','100.00','166000','0','0','17800','850000','0','0','0','850000','SULIS','00046735','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-07', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHCA-43-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-09-07' AND kode_barang='PBDG-ZHCA-43-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-260907-0010','2026-09-07','1.620','2026-09-07','19:53:54','PLG0015583','850000','850000','0','850000','0','kasirbip','2026-09-07 19:53:54','FJ-260907-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-09-07','FJ-260907-0010','2026-09-07','19:53:54','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-260907-0015','2026-09-07','2026-09-07 19:53:54','PENJUALAN : FJ-260907-0010','.','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-260907-0016','D','2026-09-07','19:53:54','TBC','PENJUALAN','FJ-260907-0010','27504288964','850000','27505138964','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-260907-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260907-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260907-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260907-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260907-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260907-0010';
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-03928','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz 16 putih doff semprot 1 zirkon','font vladimir grf Lisnawati. S . . .','model sprt contoh','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260907-0016','2026-09-07','2026-09-07 20:06:27','PESANAN : DP-03928','.','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-260907-0017','D','2026-09-07','20:06:27','TBC','PESANAN','DP-03928','27505138964','850000','27505988964','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-03928','2026-09-07','2026-09-07','20:06:27','PLG0015584','SAL','2026-10-05','kasirbip','2026-09-07 20:06:27','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03929','SAL','1','PLD','WED RING','','','2.500','','10.00','1','1200000','350000','0','850000','1725000','sz 8 putih glossy 3 zirkon','model dibuat tanpa gerigi jadi polos','font vladimir grf Aldi Ramadita . . .','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260907-0017','2026-09-07','2026-09-07 20:09:10','PESANAN : DP-03929','.','TBC','1380000','1380000');
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-260907-0018','D','2026-09-07','20:09:10','TBC','PESANAN','DP-03929','27505988964','1380000','27507368964','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-03929','2026-09-07','2026-09-07','20:09:10','PLG0015585','SAL','2026-10-05','kasirbip','2026-09-07 20:09:10','2.500','0','0','0','1380000','0','850000','1725000','1725000','345000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-07 ','20:27:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-07 ','20:34:45');
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-03930','ADL','1','PER','PROMO 950 SR03','','','4.000','','925.00','1','100000','0','950000','0','950000','SZ CWO 22 UKIR Dina&Risa Vintage Rotter','SZ CWE 12 UKIR Dina&Risa Vintage Rotter','CHARGE Size 22','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-260907-0018','2026-09-07','2026-09-07 20:41:56','PESANAN : DP-03930','.','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-260907-0019','D','2026-09-07','20:41:56','TBC','PESANAN','DP-03930','27507368964','1050000','27508418964','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-03930','2026-09-07','2026-09-07','20:41:56','PLG0015586','ADL','2026-10-03','jogja','2026-09-07 20:41:56','4.000','0','0','0','1050000','0','0','1050000','1050000','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-07';
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-09-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-07';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-07' 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-260908-0001','D','2026-09-08','21:02:15','TBC','SALDO AWAL','SALDO AWAL','0','27508418964','27508418964');
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-260908-0001','D','2026-09-08','21:02:15','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-260908-0001','D','2026-09-08','21:02:15','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-260908-0001','D','2026-09-08','21:02:15','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650');
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-260908-0001','D','2026-09-08','21:02:15','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-260908-0001','D','2026-09-08','21:02:15','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
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-260908-0001','D','2026-09-08','21:02:15','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-260908-0001','D','2026-09-08','21:02:15','','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-260908-0001','D','2026-09-08','21:02:15','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-260908-0001','D','2026-09-08','21:02:15','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260908-0001','D','2026-09-08','21:02:15','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-260908-0001','D','2026-09-08','21:02:15','BCD','SALDO AWAL','SALDO AWAL','0','1459469500','1459469500');
UPDATE tp_system SET tgl_system='2026-09-08';