INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-21 ','07:54:01');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-21 ','08:17:36');
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-20260921-0001','1','PSPLT-ZIBA-1-0','1','4.260','4.260','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-09-21 08:25:02' WHERE kode_barang='PSPLT-ZIBA-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-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-09-21 08:25:02','TOKO','MMPSN','PSPLT','PSPLT-ZIBA-1-0','1','4.260','4.260','1','4.260','4.260','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-ZIBA-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-21' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260921-0001','2026-09-21','08:24','4.260','kasir','2026-09-21 08:25:01');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-21 ','08:35:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-21 ','09:30:22');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-21 ','10:06:14');
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-260921-0001','kasirbip','1',' DP-03754BI','TOKO','BIPPSN','PSPRT-ZIAH-4-0','CINCIN PERAK ','','1.860','1','100.00','190000','0','0','17800','900000','0','0','0','900000','KUR','00047333','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSPRT-ZIAH-4-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-260921-0001','2026-09-21','1.860','2026-09-21','10:06:54','PLG0016186','900000','900000','0','900000','0','kasirbip','2026-09-21 10:06:54','FJ-260921-0001','DP-03754','900000');
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-21','FJ-260921-0001','2026-09-21','10:06:54','KUR','900000','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-260921-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-260921-0002','kasirbip',' 1',' DP-03755BI','TOKO','BIPPSN','PSPRT-ZIAH-5-0','CINCIN PERAK ','','1.700','1','100.00','174000','0','0','17800','900000','0','0','0','900000','KUR','00047334','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSPRT-ZIAH-5-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-260921-0002','2026-09-21','1.700','2026-09-21','10:06:54','PLG0016187','900000','900000','0','900000','0','kasirbip','2026-09-21 10:06:54','FJ-260921-0001','DP-03755','900000');
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-21','FJ-260921-0002','2026-09-21','10:06:54','KUR','900000','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-260921-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-21 ','10:57:33');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260921-0002','1','PSGT-ZIBA-2-0','1','1.980','1.980','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIBA-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIBA-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIBA-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIBA-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-21 10:58:01' WHERE kode_barang='PSGT-ZIBA-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIBA-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-09-21 10:58:01','TOKO','DUPSN','PSGT','PSGT-ZIBA-2-0','1','1.980','1.980','1','1.980','1.980','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-ZIBA-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIBA-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-21' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260921-0002','2026-09-21','10:57','1.980','kasirbip','2026-09-21 10:58:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-09-21 ','11:20:53');
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-04164','PUT','1','PER','WEDRING','','','2.300','','925.00','1','100000','0','850000','0','850000','sz cwe 13 crom putih glosy komb hitam glosy','grf So Hart Be Knit 23.12.26','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-260921-0001','2026-09-21','2026-09-21 11:46:46','PESANAN : DP-04164','.','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-260921-0002','D','2026-09-21','11:46:46','TBC','PESANAN','DP-04164','28127937964','850000','28128787964','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-04164','2026-09-21','2026-09-21','11:46:46','PLG0016188','PUT','2026-10-18','kasirbip','2026-09-21 11:46:46','2.300','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-04165','PUT','1','PER','WEDRING','','','3.500','','925.00','1','100000','0','850000','0','850000','sz cwo 18.5 crom putih glosy komb hitam doff','grf As Handes Doe Shut 23.12.26','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-260921-0002','2026-09-21','2026-09-21 11:49:03','PESANAN : DP-04165','.','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-260921-0003','D','2026-09-21','11:49:03','TBC','PESANAN','DP-04165','28128787964','850000','28129637964','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-04165','2026-09-21','2026-09-21','11:49:03','PLG0016189','PUT','2026-10-18','kasirbip','2026-09-21 11:49:03','3.500','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260921-0003','kasirbip','1',' 900K-11 ','TOKO','BIPCMP','BDCM-ZDBI-59-0','CINCIN EMAS ','','1.550','1','45.00','1708000','0','0','17800','3300000','0','0','0','3300000','KUR','00042957','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-ZDBI-59-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='BDCM-ZDBI-59-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260921-0003','2026-09-21','1.550','2026-09-21','11:55:48','PLG0016190','3300000','3300000','0','3300000','0','kasirbip','2026-09-21 11:55:48','FJ-260921-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-21','FJ-260921-0003','2026-09-21','11:55:48','KUR','3300000','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-260921-0003','2026-09-21','2026-09-21 11:55:48','PENJUALAN : FJ-260921-0003','.','TBC','3300000','3300000','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-260921-0004','D','2026-09-21','11:55:48','TBC','PENJUALAN','FJ-260921-0003','28129637964','3300000','28132937964','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='3300000' WHERE no_faktur_jual='FJ-260921-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260921-0004','kasirbip',' 1',' 800K-17-28','TOKO','BIPPER','PBDG-ZHXD-36-0','CINCIN SILVER 925 ','','3.410','1','100.00','348000','0','0','17800','900000','0','0','0','900000','KUR','00045875','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHXD-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.410',berat_jual_asli=berat_jual_asli+'3.410',stock_jual='1',berat_akhir=berat_akhir-'3.410',berat_akhir_asli=berat_akhir_asli-'3.410',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PBDG-ZHXD-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260921-0004','2026-09-21','3.410','2026-09-21','11:55:48','PLG0016191','900000','900000','0','900000','0','kasirbip','2026-09-21 11:55:48','FJ-260921-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-21','FJ-260921-0004','2026-09-21','11:55:48','KUR','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-260921-0004','2026-09-21','2026-09-21 11:55:48','PENJUALAN : FJ-260921-0004','.','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260921-0005','D','2026-09-21','11:55:48','TBC','PENJUALAN','FJ-260921-0004','28132937964','900000','28133837964','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='4200000' WHERE no_faktur_jual='FJ-260921-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-04166','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','850000','0','850000','cwo YL-01 sz 19.5 grf Puri Purwanti','cwe sz 21 grf Fauzan Eka. F','font berkshire swash OVERSIZE 100.000','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260921-0005','2026-09-21','2026-09-21 11:58:04','PESANAN : DP-04166','.','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-260921-0006','D','2026-09-21','11:58:04','TBC','PESANAN','DP-04166','28133837964','850000','28134687964','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-04166','2026-09-21','2026-09-21','11:58:04','PLG0016192','SAL','2026-10-18','kasirbip','2026-09-21 11:58:04','3.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0004';
UPDATE tm_credit_card SET nama_customer='.',no_ktp='',alamat1='' ,alamat2='' ,kota= '' ,no_telp='',tgl_valid_until='',tgl_last_gesek='2026-09-21 12:48:32' WHERE id_card = '.';
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-260921-0005','kasirbip','1',' 800K-135-0','TOKO','DUPERBDG','LXPER-ZHAX-9-0','CINCIN SILVER 925 ','','2.050','1','100.00','210000','0','0','17800','900000','0','0','0','900000','PUT','00046012','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHAX-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='LXPER-ZHAX-9-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-260921-0005','2026-09-21','2.050','2026-09-21','12:48:42','PLG0016193','900000','900000','0','900000','0','kasirbip','2026-09-21 12:48:42','FJ-260921-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-21','FJ-260921-0005','2026-09-21','12:48:42','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-260921-0006','2026-09-21','2026-09-21 12:48:42','PENJUALAN : FJ-260921-0005','.','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-260921-0007','D','2026-09-21','12:48:42','TBC','PENJUALAN','FJ-260921-0005','28134687964','900000','28135587964','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-260921-0005' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260921-0006','kasirbip',' 1',' 750K-18-00','TOKO','DUPERBDG','LXPER-ZIXC-30-0','CINCIN SILVER 925 ','','1.520','1','100.00','156000','0','0','17800','850000','0','0','0','850000','PUT','00046860','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZIXC-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='LXPER-ZIXC-30-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-260921-0006','2026-09-21','1.520','2026-09-21','12:48:42','PLG0016194','850000','850000','0','850000','0','kasirbip','2026-09-21 12:48:42','FJ-260921-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-21','FJ-260921-0006','2026-09-21','12:48:42','PUT','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-260921-0007','2026-09-21','2026-09-21 12:48:42','PENJUALAN : FJ-260921-0006','.','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-260921-0008','D','2026-09-21','12:48:42','TBC','PENJUALAN','FJ-260921-0006','28135587964','850000','28136437964','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='1750000' WHERE no_faktur_jual='FJ-260921-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-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-260921-0007','jogja','1',' 750K-16-00','TOKO','JOGPER','PJOG-ZFAA-95-0','CINCIN SILVER 925 ','','1.590','1','100.00','163000','0','0','17800','850000','0','0','0','850000','DLA','00044294','PJOG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAA-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.590',berat_jual_asli=berat_jual_asli+'1.590',stock_jual='1',berat_akhir=berat_akhir-'1.590',berat_akhir_asli=berat_akhir_asli-'1.590',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PJOG-ZFAA-95-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260921-0007','2026-09-21','1.590','2026-09-21','13:10:44','PLG0016195','850000','850000','0','850000','0','jogja','2026-09-21 13:10:44','FJ-260921-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-21','FJ-260921-0007','2026-09-21','13:10:44','DLA','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-260921-0008','2026-09-21','2026-09-21 13:10:44','PENJUALAN : FJ-260921-0007','0','BCD','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-260921-0002','D','2026-09-21','13:10:44','BCD','PENJUALAN','FJ-260921-0007','1460419500','850000','1461269500','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='850000' WHERE no_faktur_jual='FJ-260921-0007' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-09-21 ','13:14: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-260921-0008','kasirbip','1',' DP-03636DU','TOKO','DUPSN','PSGT-ZIAH-56-0','CINCIN EMAS ','','1.890','1','45.00','1996000','0','0','17800','3396000','0','0','0','3396000','PUT','00047385','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIAH-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.890',berat_jual_asli=berat_jual_asli+'1.890',stock_jual='1',berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSGT-ZIAH-56-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-260921-0008','2026-09-21','1.890','2026-09-21','13:18:22','PLG0016196','3396000','3396000','0','3396000','0','kasirbip','2026-09-21 13:18:22','FJ-260921-0008','DP-03636','2840000');
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-21','FJ-260921-0008','2026-09-21','13:18:22','PUT','3396000','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-260921-0009','2026-09-21','2026-09-21 13:18:22','PENJUALAN : FJ-260921-0008','.','TBC','556000','556000','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-260921-0009','D','2026-09-21','13:18:22','TBC','PENJUALAN','FJ-260921-0008','28136437964','556000','28136993964','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='556000' WHERE no_faktur_jual='FJ-260921-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0008';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260921-0009','kasirbip','1',' DP-03687DU','TOKO','DUPSN','PSPRT-ZIAH-29-0','CINCIN PERAK SR03 YL01 ','','3.840','1','100.00','392000','0','0','17800','950000','0','0','0','950000','NAD','00047358','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.840',berat_jual_asli=berat_jual_asli+'3.840',stock_jual='1',berat_akhir=berat_akhir-'3.840',berat_akhir_asli=berat_akhir_asli-'3.840',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSPRT-ZIAH-29-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-260921-0009','2026-09-21','3.840','2026-09-21','13:19:43','PLG0016197','950000','950000','0','950000','0','kasirbip','2026-09-21 13:19:43','FJ-260921-0009','DP-03687','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-21','FJ-260921-0009','2026-09-21','13:19:43','NAD','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-260921-0009' LIMIT 1;
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260921-0003','1','PSPLT-ZIBA-3-0','1','4.070','4.070','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-21 13:23:40' WHERE kode_barang='PSPLT-ZIBA-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-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-09-21 13:23:40','TOKO','SBYPSN','PSPLT','PSPLT-ZIBA-3-0','1','4.070','4.070','1','4.070','4.070','57.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-ZIBA-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-21' 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-20260921-0003','1','PSPLT-ZIBA-4-0','1','3.530','3.530','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIBA-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIBA-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIBA-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-21 13:23:40' WHERE kode_barang='PSPLT-ZIBA-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIBA-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-09-21 13:23:40','TOKO','SBYPSN','PSPLT','PSPLT-ZIBA-4-0','1','3.530','3.530','1','3.530','3.530','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-ZIBA-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIBA-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-21' 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-20260921-0003','1','PSGT-ZIBA-5-0','1','1.460','1.460','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIBA-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIBA-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIBA-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIBA-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-21 13:23:40' WHERE kode_barang='PSGT-ZIBA-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIBA-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-09-21 13:23:40','TOKO','SBYPSN','PSGT','PSGT-ZIBA-5-0','1','1.460','1.460','1','1.460','1.460','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-ZIBA-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIBA-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-21' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260921-0003','2026-09-21','13:14','9.060','sby','2026-09-21 13:23:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-21 ','13:57:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-21 ','13:59:39');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000384','X-00000384','THIFA GELANG RANTAI RG','GR','---','TFGRR','BELI','BELI001','9360000','2026-09-21','5.850','1','kasir','2026-09-21 14:03:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-TFGRR';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFGRR','X-00000384','X-00000384');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260921-0001','-','FIR','1','BELI','BELI001','TFGRR', 'X-00000384', 'THIFA GELANG RANTAI RG','5.850','5.850','75.00','12700000','9360000','1600000','1','9360000','9360000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.850',berat_beli_asli=berat_beli_asli+'5.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.850',berat_akhir_asli=berat_akhir_asli+'5.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFGRR' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-260921-0001','2026-09-21','2026-09-21','14:03:52','FIR','---','5.850','9360000','9360000','9360000','9360000','9360000','kasir','2026-09-21 14:03:53','FB-260921-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0001','IBU KIKI','JKT','','JKT','','kasir','2026-09-21 14:03:53');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260921-0010','2026-09-21','2026-09-21 14:03:53','PEMBELIAN UMUM : FB-260921-0001','.','TBC','9360000','9360000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-260921-0010','K','2026-09-21','14:03:52','TBC','PEMBELIAN UMUM','FB-260921-0001','28136993964','9360000','28127633964','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-0001';
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-04167','KUR','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','sz 15 putih doff semprot 1 zirkon','font berkshire swash grf Adang Mita','model persis 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-260921-0011','2026-09-21','2026-09-21 14:27:55','PESANAN : DP-04167','.','TBC','1480000','1480000');
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-260921-0011','D','2026-09-21','14:27:55','TBC','PESANAN','DP-04167','28127633964','1480000','28129113964','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-04167','2026-09-21','2026-09-21','14:27:55','PLG0016198','KUR','2026-10-20','kasirbip','2026-09-21 14:27:55','3.000','0','0','0','1480000','0','800000','1850000','1850000','370000');
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-04168','KUR','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','700000','1750000','sz 15.5 putih doff amplas','font berkshire swash grf Mita Adang','model persis sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260921-0012','2026-09-21','2026-09-21 14:29:47','PESANAN : DP-04168','.','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-260921-0012','D','2026-09-21','14:29:47','TBC','PESANAN','DP-04168','28129113964','1400000','28130513964','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-04168','2026-09-21','2026-09-21','14:29:47','PLG0016199','KUR','2026-10-20','kasirbip','2026-09-21 14:29:47','3.000','0','0','0','1400000','0','700000','1750000','1750000','350000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-21 ','14:34:49');
DELETE FROM tm_berlian WHERE kode_barang='TFA-XHBX-15-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-XHBX-15-0','TFA-XHBX-15-0','00030672','RD','2','0.360','800');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-XHBX-15-0','00030672','RD','2','0.360','800','288')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-XHBX-15-0','TFA-XHBX-15-0','00030672','RD','8','0.100','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-XHBX-15-0','00030672','RD','8','0.100','400','40')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-XHBX-15-0','TFA-XHBX-15-0','00030672','RD','40','0.200','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-XHBX-15-0','00030672','RD','40','0.200','400','80')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFA-XHBX-15-0','00030672','00030672','GIWANG TFA-21090','GIWANG TFA-21090','','','7317500','7317500',' 0','0','kasir','2026-09-21 14:37:33');
UPDATE tm_barang SET nama_barang='GIWANG TFA-21090' ,nama_atribut='' ,kode_intern='TFA-21090 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 51 000 000',total_usd='408' WHERE kode_barang='TFA-XHBX-15-0' 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-260921-0010','kasir','1',' TFA-21090 ','TOKO','TFABR','TFA-XHBX-15-0','GIWANG TFA-21090','','2.960','1','103.00','16568000','7743500','435','17800','20000000','0','0','0','20000000','BARY','00030672','TFA','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFA-XHBX-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.960',berat_jual_asli=berat_jual_asli+'2.960',stock_jual='1',berat_akhir=berat_akhir-'2.960',berat_akhir_asli=berat_akhir_asli-'2.960',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='TFA-XHBX-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFABR' 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-260921-0010','2026-09-21','2.960','2026-09-21','14:38:16','PLG0016200','20000000','20000000','0','20000000','20000000','kasir','2026-09-21 14:38:15','FJ-260921-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-21','FJ-260921-0010','2026-09-21','14:38:16','BARY','20000000','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-260921-0002','D','2026-09-21','14:38:16','kasir','PENJUALAN BERLIAN','FJ-260921-0010','6940500','20000000','26940500');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0010';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000385','X-00000385','ABRE01804','GR','---','ABRE','BELI','BELI001','13200000','2026-09-21','4.270','1','kasir','2026-09-21 14:40:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-ABRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-ABRE','X-00000385','X-00000385');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260921-0002','-','BARY','1','BELI','BELI001','ABRE', 'X-00000385', 'ABRE01804','4.270','4.270','75.00','16500000','13200000','3091335','1','13200000','13200000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.270',berat_beli_asli=berat_beli_asli+'4.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.270',berat_akhir_asli=berat_akhir_asli+'4.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='ABRE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-260921-0002','2026-09-21','2026-09-21','14:40:50','BARY','---','4.270','13200000','13200000','13200000','13200000','13200000','kasir','2026-09-21 14:40:50','FB-260921-0002','OPEN','CASH');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0002','-','-','','','','kasir','2026-09-21 14:40:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-21' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260921-0003','K','2026-09-21','14:40:50','kasir','PEMBELIAN UMUM','FB-260921-0002','26940500','13200000','13740500','OPEN');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000386','X-00000386','ABRE02077','GR','---','ABRE','BELI','BELI001','9600000','2026-09-21','2.760','1','kasir','2026-09-21 14:41:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-ABRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-ABRE','X-00000386','X-00000386');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260921-0003','-','BARY','1','BELI','BELI001','ABRE', 'X-00000386', 'ABRE02077','2.760','2.760','75.00','12000000','9600000','3478261','1','9600000','9600000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.760',berat_beli_asli=berat_beli_asli+'2.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.760',berat_akhir_asli=berat_akhir_asli+'2.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='ABRE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-260921-0003','2026-09-21','2026-09-21','14:41:32','BARY','---','2.760','9600000','9600000','9600000','9600000','9600000','kasir','2026-09-21 14:41:32','FB-260921-0003','OPEN','CASH');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260921-0003','-','-','','','','kasir','2026-09-21 14:41:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-21' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260921-0004','K','2026-09-21','14:41:32','kasir','PEMBELIAN UMUM','FB-260921-0003','13740500','9600000','4140500','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260921-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260921-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-21 ','14:43:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-21 ','14:45:21');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260921-0011','sby','1',' DP-03715SB','TOKO','SBYPSN','PSPRT-ZIAH-63-0','CINCIN PERAK ','','4.090','1','100.00','418000','0','0','17800','800000','0','0','0','800000','DIL','00047392','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-63-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.090',berat_jual_asli=berat_jual_asli+'4.090',stock_jual='1',berat_akhir=berat_akhir-'4.090',berat_akhir_asli=berat_akhir_asli-'4.090',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSPRT-ZIAH-63-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-260921-0011','2026-09-21','4.090','2026-09-21','16:42:30','PLG0016201','800000','800000','0','800000','0','sby','2026-09-21 16:42:29','FJ-260921-0011','DP-03715','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-21','FJ-260921-0011','2026-09-21','16:42:30','DIL','800000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260921-0011' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-21 ','17:11:54');
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-260921-0012','kasirbip','1',' DP-03563DU','TOKO','DUPSN','PSGT-ZIBA-2-0','CINCIN EMAS ','','1.980','1','83.00','3856000','0','0','17800','5375000','0','0','0','5375000','NAD','00047400','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIBA-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSGT-ZIBA-2-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-260921-0012','2026-09-21','1.980','2026-09-21','17:13:44','PLG0016202','5375000','5375000','0','5375000','0','kasirbip','2026-09-21 17:13:43','FJ-260921-0012','DP-03563','4336000');
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-21','FJ-260921-0012','2026-09-21','17:13:44','NAD','5375000','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-260921-0013','2026-09-21','2026-09-21 17:13:43','PENJUALAN : FJ-260921-0012','.','TBC','1039000','1039000','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-260921-0013','D','2026-09-21','17:13:44','TBC','PENJUALAN','FJ-260921-0012','28130513964','1039000','28131552964','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='1039000' WHERE no_faktur_jual='FJ-260921-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-260921-0013','kasirbip',' 1',' DP-03564DU','TOKO','DUPSN','PSPLT-ZIAH-41-0','CINCIN PALADIUM ','','3.360','1','17.00','755000','0','0','17800','1876000','0','0','0','1876000','NAD','00047370','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIAH-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.360',berat_jual_asli=berat_jual_asli+'3.360',stock_jual='1',berat_akhir=berat_akhir-'3.360',berat_akhir_asli=berat_akhir_asli-'3.360',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSPLT-ZIAH-41-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-260921-0013','2026-09-21','3.360','2026-09-21','17:13:44','PLG0016203','1876000','1876000','0','1876000','0','kasirbip','2026-09-21 17:13:43','FJ-260921-0012','DP-03564','1540000');
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-21','FJ-260921-0013','2026-09-21','17:13:44','NAD','1876000','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-260921-0014','2026-09-21','2026-09-21 17:13:43','PENJUALAN : FJ-260921-0013','.','TBC','336000','336000','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-260921-0014','D','2026-09-21','17:13:44','TBC','PENJUALAN','FJ-260921-0013','28131552964','336000','28131888964','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='1375000' WHERE no_faktur_jual='FJ-260921-0013' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260921-0014','kasirbip','1',' DP-03598DU','TOKO','DUPSN','PSPRT-ZIAH-27-0','1PS CINCIN PERAK ','','4.150','1','100.00','424000','0','0','17800','1600000','0','0','0','1600000','PUT','00047356','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.150',berat_jual_asli=berat_jual_asli+'4.150',stock_jual='1',berat_akhir=berat_akhir-'4.150',berat_akhir_asli=berat_akhir_asli-'4.150',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSPRT-ZIAH-27-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-260921-0014','2026-09-21','4.150','2026-09-21','17:49:33','PLG0016204','1600000','1600000','0','1600000','0','kasirbip','2026-09-21 17:49:33','FJ-260921-0014','DP-03598','1600000');
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-21','FJ-260921-0014','2026-09-21','17:49:33','PUT','1600000','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-260921-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-260921-0015','kasirbip','1',' DP-03351DU','TOKO','DUPSN','PSPRT-ZIXD-79-0','CINCIN PERAK ','','1.840','1','100.00','188000','0','0','17800','950000','0','0','0','950000','NAD','00046942','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXD-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.840',berat_jual_asli=berat_jual_asli+'1.840',stock_jual='1',berat_akhir=berat_akhir-'1.840',berat_akhir_asli=berat_akhir_asli-'1.840',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSPRT-ZIXD-79-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-260921-0015','2026-09-21','1.840','2026-09-21','18:29:07','PLG0016205','950000','950000','0','950000','0','kasirbip','2026-09-21 18:29:07','FJ-260921-0015','DP-03351','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-21','FJ-260921-0015','2026-09-21','18:29:07','NAD','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-260921-0015' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260921-0016','kasirbip',' 1',' DP-03349DU','TOKO','DUPSN','PSPRT-ZIXD-78-0','CINCIN PERAK ','','3.060','1','100.00','313000','0','0','17800','800000','0','0','0','800000','NAD','00046941','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXD-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSPRT-ZIXD-78-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-260921-0016','2026-09-21','3.060','2026-09-21','18:29:07','PLG0016206','800000','800000','0','800000','0','kasirbip','2026-09-21 18:29:07','FJ-260921-0015','DP-03349','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-21','FJ-260921-0016','2026-09-21','18:29:07','NAD','800000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260921-0016' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260921-0017','kasirbip','1',' 900K-12-29','TOKO','BIPPER','PBDG-ZHBH-26-0','CINCIN SILVER 925 ','','1.470','1','100.00','150000','0','0','17800','950000','0','0','0','950000','SULIS','00046616','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHBH-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PBDG-ZHBH-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260921-0017','2026-09-21','1.470','2026-09-21','18:45:31','PLG0016207','950000','950000','0','950000','0','kasirbip','2026-09-21 18:45:30','FJ-260921-0017','','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-21','FJ-260921-0017','2026-09-21','18:45:31','SULIS','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-260921-0015','2026-09-21','2026-09-21 18:45:30','PENJUALAN : FJ-260921-0017','.','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-260921-0015','D','2026-09-21','18:45:31','TBC','PENJUALAN','FJ-260921-0017','28131888964','950000','28132838964','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-260921-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-260921-0018','kasirbip',' 1',' 750K-18-27','TOKO','BIPPER','PBDG-ZGXF-43-0','CINCIN SILVER 925 ','','2.150','1','100.00','220000','0','0','17800','800000','0','0','0','800000','SULIS','00044971','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGXF-43-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-09-21' AND kode_barang='PBDG-ZGXF-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-260921-0018','2026-09-21','2.150','2026-09-21','18:45:31','PLG0016208','800000','800000','0','800000','0','kasirbip','2026-09-21 18:45:30','FJ-260921-0017','','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-21','FJ-260921-0018','2026-09-21','18:45:31','SULIS','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260921-0016','2026-09-21','2026-09-21 18:45:30','PENJUALAN : FJ-260921-0018','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260921-0016','D','2026-09-21','18:45:31','TBC','PENJUALAN','FJ-260921-0018','28132838964','800000','28133638964','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='1750000' WHERE no_faktur_jual='FJ-260921-0018' 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-02256','SULIS','1','SEPASANG CCN SILVER','FONT KEDUANYA BERKSHIRE SWASH','4.000','1','0','0');
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-02256','2026-09-21','2026-09-21','18:46:28','PLG0016209','kasirbip','2026-09-22','kasirbip','2026-09-21 18:46:28','4.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-21 ','18:46:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-21 ','18:54:41');
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-260921-0019','kasirbip','1',' 800K-125-0','TOKO','DUPERBDG','LXPER-ZHBF-25-0','CINCIN SILVER 925 ','','1.620','1','100.00','166000','0','0','17800','900000','0','0','0','900000','NAD','00046531','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHBF-25-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-21' AND kode_barang='LXPER-ZHBF-25-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-260921-0019','2026-09-21','1.620','2026-09-21','18:56:10','PLG0016210','900000','900000','0','900000','0','kasirbip','2026-09-21 18:56:09','FJ-260921-0019','','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-21','FJ-260921-0019','2026-09-21','18:56:10','NAD','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-260921-0017','2026-09-21','2026-09-21 18:56:09','PENJUALAN : FJ-260921-0019','.','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-260921-0017','D','2026-09-21','18:56:10','TBC','PENJUALAN','FJ-260921-0019','28133638964','900000','28134538964','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-260921-0019' 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-260921-0020','kasirbip',' 1',' 800K-175-0','TOKO','DUPERBDG','LXPER-ZFAH-30-0','CINCIN SILVER 925 ','','3.980','1','100.00','406000','0','0','17800','900000','0','0','0','900000','NAD','00044543','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAH-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.980',berat_jual_asli=berat_jual_asli+'3.980',stock_jual='1',berat_akhir=berat_akhir-'3.980',berat_akhir_asli=berat_akhir_asli-'3.980',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='LXPER-ZFAH-30-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-260921-0020','2026-09-21','3.980','2026-09-21','18:56:10','PLG0016211','900000','900000','0','900000','0','kasirbip','2026-09-21 18:56:09','FJ-260921-0019','','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-21','FJ-260921-0020','2026-09-21','18:56:10','NAD','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-260921-0018','2026-09-21','2026-09-21 18:56:09','PENJUALAN : FJ-260921-0020','.','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-260921-0018','D','2026-09-21','18:56:10','TBC','PENJUALAN','FJ-260921-0020','28134538964','900000','28135438964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1800000' WHERE no_faktur_jual='FJ-260921-0020' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260921-0021','kasirbip','1',' DP-03802BI','TOKO','BIPPSN','PSPRT-ZIAH-52-0','CINCIN PERAK SR01 YL01 ','','3.120','1','100.00','319000','0','0','17800','950000','0','0','0','950000','KUR','00047381','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-52-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-21' AND kode_barang='PSPRT-ZIAH-52-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-260921-0021','2026-09-21','3.120','2026-09-21','19:25:55','PLG0016212','950000','950000','0','950000','0','kasirbip','2026-09-21 19:25:54','FJ-260921-0021','DP-03802','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-21','FJ-260921-0021','2026-09-21','19:25:55','KUR','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260921-0021' 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-260921-0022','jogja','1',' DP-04057JO','TOKO','JOGPSN','PSGT-ZIAH-69-0','CINCIN EMAS ','','3.010','1','83.00','5862000','0','0','17800','6772000','150000','900000','0','7672000','ADL','00047398','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIAH-69-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSGT-ZIAH-69-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-260921-0022','2026-09-21','3.010','2026-09-21','19:26:59','PLG0016213','6772000','6772000','900000','7672000','0','jogja','2026-09-21 19:26:58','FJ-260921-0022','DP-04057','3825000');
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-21','FJ-260921-0022','2026-09-21','19:26:59','ADL','7672000','900000');
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-260921-0019','2026-09-21','2026-09-21 19:26:58','PENJUALAN : FJ-260921-0022','.','TBC','3847000','3847000','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-260921-0019','D','2026-09-21','19:26:59','TBC','PENJUALAN','FJ-260921-0022','28135438964','3847000','28139285964','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='3847000' WHERE no_faktur_jual='FJ-260921-0022' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260921-0023','jogja','1',' DP-04058JO','TOKO','JOGPSN','PSPLT-ZIAH-68-0','CINCIN PALADIUM ','','2.590','1','32.00','1095000','0','0','17800','1424500','0','750000','0','2174500','ADL','00047397','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIAH-68-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-21' AND kode_barang='PSPLT-ZIAH-68-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-260921-0023','2026-09-21','2.590','2026-09-21','19:30:23','PLG0016214','1424500','1424500','750000','2174500','0','jogja','2026-09-21 19:30:22','FJ-260921-0023','DP-04058','1062000');
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-21','FJ-260921-0023','2026-09-21','19:30:23','ADL','2174500','750000');
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-260921-0020','2026-09-21','2026-09-21 19:30:22','PENJUALAN : FJ-260921-0023','.','TBC','1112500','1112500','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-260921-0020','D','2026-09-21','19:30:23','TBC','PENJUALAN','FJ-260921-0023','28139285964','1112500','28140398464','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='1112500' WHERE no_faktur_jual='FJ-260921-0023' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0023';
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-04169','DIL','1','PLD','WEDD RING PRIA','','','4.500','','10.00','1','1200000','350000','0','700000','2275000','SIZE 21.5 GRF: Adinda ?? Bayu (VINTAGE)','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-260921-0021','2026-09-21','2026-09-21 19:54:39','PESANAN : DP-04169','-','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-260921-0021','D','2026-09-21','19:54:39','TBC','PESANAN','DP-04169','28140398464','1500000','28141898464','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-04169','2026-09-21','2026-09-21','19:54:39','PLG0016215','DIL','2026-10-15','sby','2026-09-21 19:54:39','4.500','0','0','0','1500000','0','700000','2275000','2275000','775000');
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-04170','DIL','1','PLD','WEDD RING WANITA','','','3.000','','10.00','1','1200000','350000','0','850000','1900000','PERMATA 21 BUTIR','SIZE 9.5 GRF: Bayu ?? Adinda (VINTAGE)','PUTIH GLOSSY','210000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260921-0022','2026-09-21','2026-09-21 19:56:53','PESANAN : DP-04170','-','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-260921-0022','D','2026-09-21','19:56:53','TBC','PESANAN','DP-04170','28141898464','1400000','28143298464','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-04170','2026-09-21','2026-09-21','19:56:53','PLG0016216','DIL','2026-10-15','sby','2026-09-21 19:56:53','3.000','0','0','0','1400000','0','850000','2110000','2110000','710000');
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-04171','KUR','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1100000','0','1100000','sz 10 putih glossy 23 zirkon','font vintage rotter grf Indra','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260921-0023','2026-09-21','2026-09-21 19:56:58','PESANAN : DP-04171','.','TBC','1100000','1100000');
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-260921-0023','D','2026-09-21','19:56:58','TBC','PESANAN','DP-04171','28143298464','1100000','28144398464','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-04171','2026-09-21','2026-09-21','19:56:58','PLG0016217','KUR','2026-10-12','kasirbip','2026-09-21 19:56:58','2.000','0','0','0','1100000','0','0','1100000','1100000','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-04172','KUR','1','PER','WED RING','','','2.000','','925.00','1','100000','0','800000','0','800000','sz 22 putih doff semprot 1 zirkon','font vintage rotter grf Santi','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260921-0024','2026-09-21','2026-09-21 19:59:16','PESANAN : DP-04172','.','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-260921-0024','D','2026-09-21','19:59:16','TBC','PESANAN','DP-04172','28144398464','800000','28145198464','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-04172','2026-09-21','2026-09-21','19:59:16','PLG0016218','KUR','2026-10-12','kasirbip','2026-09-21 19:59:16','2.000','0','0','0','800000','0','0','800000','800000','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-260921-0024','sby','1',' DP-03714SB','TOKO','SBYPSN','PSPRT-ZIAH-46-0','CINCIN PERAK ','','3.420','1','100.00','349000','0','0','17800','800000','0','0','0','800000','DIL','00047375','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.420',berat_jual_asli=berat_jual_asli+'3.420',stock_jual='1',berat_akhir=berat_akhir-'3.420',berat_akhir_asli=berat_akhir_asli-'3.420',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSPRT-ZIAH-46-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-260921-0024','2026-09-21','3.420','2026-09-21','20:07:28','PLG0016219','800000','800000','0','800000','0','sby','2026-09-21 20:07:27','FJ-260921-0024','DP-03714','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-21','FJ-260921-0024','2026-09-21','20:07:28','DIL','800000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260921-0024' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0024';
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-04173','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','750000','2950000','SIZE:15 PERMATA 1','GRF: WMG FONT: TIMES NEW','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-260921-0025','2026-09-21','2026-09-21 20:44:30','PESANAN : DP-04173','-','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-260921-0025','D','2026-09-21','20:44:30','TBC','PESANAN','DP-04173','28145198464','2000000','28147198464','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-04173','2026-09-21','2026-09-21','20:44:30','PLG0016220','VAN','2026-10-01','sby','2026-09-21 20:44:30','4.000','0','0','0','2000000','0','750000','2960000','2960000','960000');
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-260921-0025','kasirbip','1',' DP-04052BI','TOKO','BIPPSN','PSPRT-ZIAH-55-0','CINCIN PERAK SR05 YL01 ','','3.310','1','100.00','338000','0','0','17800','950000','0','0','0','950000','KUR','00047384','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAH-55-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.310',berat_jual_asli=berat_jual_asli+'3.310',stock_jual='1',berat_akhir=berat_akhir-'3.310',berat_akhir_asli=berat_akhir_asli-'3.310',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSPRT-ZIAH-55-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-260921-0025','2026-09-21','3.310','2026-09-21','20:56:30','PLG0016221','950000','950000','0','950000','0','kasirbip','2026-09-21 20:56:29','FJ-260921-0025','DP-04052','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-21','FJ-260921-0025','2026-09-21','20:56:30','KUR','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260921-0025' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0025';
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-260921-0026','sby','1',' 850K-145-0','TOKO','SBYPER','PSBY-ZHAC-24-0','CINCIN SILVER 925 ','','1.610','1','100.00','165000','0','0','17800','950000','0','0','0','950000','VAN','00046138','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZHAC-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSBY-ZHAC-24-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-260921-0026','2026-09-21','1.610','2026-09-21','21:05:56','PLG0016222','950000','950000','0','950000','0','sby','2026-09-21 21:05:55','FJ-260921-0026','','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-21','FJ-260921-0026','2026-09-21','21:05:56','VAN','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-260921-0026','2026-09-21','2026-09-21 21:05:55','PENJUALAN : FJ-260921-0026','','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-260921-0026','D','2026-09-21','21:05:56','TBC','PENJUALAN','FJ-260921-0026','28147198464','950000','28148148464','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-260921-0026' 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-260921-0027','sby',' 1',' 800K-215-0','TOKO','SBYPER','PSBY-ZIAH-24-0','CINCIN SILVER 925 ','','3.360','1','100.00','343000','0','0','17800','900000','0','0','0','900000','VAN','00047353','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZIAH-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.360',berat_jual_asli=berat_jual_asli+'3.360',stock_jual='1',berat_akhir=berat_akhir-'3.360',berat_akhir_asli=berat_akhir_asli-'3.360',stock_akhir='0' WHERE tanggal='2026-09-21' AND kode_barang='PSBY-ZIAH-24-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-260921-0027','2026-09-21','3.360','2026-09-21','21:05:56','PLG0016223','900000','900000','0','900000','0','sby','2026-09-21 21:05:55','FJ-260921-0026','','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-21','FJ-260921-0027','2026-09-21','21:05:56','VAN','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260921-0027','2026-09-21','2026-09-21 21:05:55','PENJUALAN : FJ-260921-0027','','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-260921-0027','D','2026-09-21','21:05:56','TBC','PENJUALAN','FJ-260921-0027','28148148464','900000','28149048464','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1850000' WHERE no_faktur_jual='FJ-260921-0027' LIMIT 1;
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='';
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='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260921-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260921-0027';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-21';
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-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-21';
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-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-21' 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-260922-0001','D','2026-09-22','21:24:54','TBC','SALDO AWAL','SALDO AWAL','0','28149048464','28149048464');
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-260922-0001','D','2026-09-22','21:24:54','BCD','SALDO AWAL','SALDO AWAL','0','1461269500','1461269500');
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-260922-0001','D','2026-09-22','21:24:54','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-260922-0001','D','2026-09-22','21:24:54','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-260922-0001','D','2026-09-22','21:24:54','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-260922-0001','D','2026-09-22','21:24:54','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-260922-0001','D','2026-09-22','21:24:54','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-260922-0001','D','2026-09-22','21:24:54','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-260922-0001','D','2026-09-22','21:24:54','','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-260922-0001','D','2026-09-22','21:24:54','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-260922-0001','D','2026-09-22','21:24:54','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-260922-0001','D','2026-09-22','21:24:54','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000');
UPDATE tp_system SET tgl_system='2026-09-22';