INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-03 ','08:22:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-03 ','08:33:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-03 ','08:35:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-03 ','08:42:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-03 ','09:34:17');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-03 ','10:27:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-03 ','11:11:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-03 ','11:35:50');
UPDATE tt_service_head SET tgl_selesai='2026-07-30',  status ='DONE' WHERE no_service='SV-02192';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02192';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-08-03',  status ='CLOS' WHERE no_service='SV-02192';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02192';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-03 ','11:50:37');
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-03232','NAD','1','PER','WEDRING','','','4.000','','925.00','2','100000','0','1600000','0','1600000','sze cwe 9 Grf A.T crom putih glossy','sze cowo 19 Grf A.T crom putih doff semprot','Font Times new romam','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-260803-0001','2026-08-03','2026-08-03 11:54:50','PESANAN : DP-03232','.','TBC','1600000','1600000');
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-260803-0002','D','2026-08-03','11:54:50','TBC','PESANAN','DP-03232','25791210564','1600000','25792810564','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-03232','2026-08-03','2026-08-03','11:54:50','PLG0013997','NAD','2026-09-04','kasirbip','2026-08-03 11:54:50','4.000','0','0','0','1600000','0','0','1600000','1600000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-03 ','12:52:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-03 ','13:02:11');
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-260803-0001','jogja','1',' 500K-15-00','TOKO','JOGPER','PJOG-ZFAA-48-0','CINCIN SILVER 925 YL-01 ','CINCIN NIKAH','1.850','1','100.00','189000','0','0','17800','600000','0','0','0','600000','SAB','00044247','PJOG','0','0','-','0','SILVER');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAA-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='PJOG-ZFAA-48-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-260803-0001','2026-08-03','1.850','2026-08-03','13:05:08','PLG0013998','600000','600000','0','600000','0','jogja','2026-08-03 13:05:07','FJ-260803-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-03','FJ-260803-0001','2026-08-03','13:05:08','SAB','600000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260803-0002','2026-08-03','2026-08-03 13:05:07','PENJUALAN : FJ-260803-0001','0','TBC','600000','600000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260803-0003','D','2026-08-03','13:05:08','TBC','PENJUALAN','FJ-260803-0001','25792810564','600000','25793410564','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='600000' WHERE no_faktur_jual='FJ-260803-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-260803-0002','kasir','1',' TFCMR75-86','TOKO','TFCINMAS','TFCMR-ZFBI-29-0','THIFA CINCIN MAS RG ','','2.090','1','86.00','4181000','0','0','17800','4200000','0','0','0','4200000','FIR','00044820','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZFBI-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='TFCMR-ZFBI-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260803-0002','2026-08-03','2.090','2026-08-03','14:18:44','PLG0013999','4200000','4200000','0','4200000','4200000','kasir','2026-08-03 14:18:44','FJ-260803-0002','','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-08-03','FJ-260803-0002','2026-08-03','14:18:44','FIR','4200000','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-260803-0002','D','2026-08-03','14:18:44','kasir','PENJUALAN','FJ-260803-0002','3152300','4200000','7352300');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-03 ','15:11:39');
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-260803-0003','kasir','1',' DP-02851MM','TOKO','MMPSN','PSPRT-ZGBI-20-0','1PS CINCIN PERAK ','','5.130','1','100.00','524000','0','0','17800','1400000','0','0','0','1400000','ELLA','00045721','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBI-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.130',berat_jual_asli=berat_jual_asli+'5.130',stock_jual='1',berat_akhir=berat_akhir-'5.130',berat_akhir_asli=berat_akhir_asli-'5.130',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='PSPRT-ZGBI-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260803-0003','2026-08-03','5.130','2026-08-03','15:21:14','PLG0014000','1400000','1400000','0','1400000','0','kasir','2026-08-03 15:21:13','FJ-260803-0003','DP-02851','1400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-03','FJ-260803-0003','2026-08-03','15:21:14','ELLA','1400000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260803-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-260803-0004','kasir','1',' DP-02716MM','TOKO','MMPSN','PSPLT-ZGBI-17-0','CINCIN PALADIUM ','','2.450','1','32.00','1036000','0','0','17800','2098000','0','0','0','2098000','ALIKA','00045718','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBI-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='PSPLT-ZGBI-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260803-0004','2026-08-03','2.450','2026-08-03','15:44:33','PLG0014001','2098000','2098000','0','2098000','0','kasir','2026-08-03 15:44:32','FJ-260803-0004','DP-02716','1700000');
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-08-03','FJ-260803-0004','2026-08-03','15:44:33','ALIKA','2098000','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-260803-0003','2026-08-03','2026-08-03 15:44:32','PENJUALAN : FJ-260803-0004','0','TBC','398000','398000','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-260803-0004','D','2026-08-03','15:44:33','TBC','PENJUALAN','FJ-260803-0004','25793410564','398000','25793808564','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='398000' WHERE no_faktur_jual='FJ-260803-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260803-0005','kasir',' 1',' DP-02715MM','TOKO','MMPSN','PSGT-ZGBC-19-0','CINCIN EMAS ','','2.500','1','83.00','4826000','0','0','17800','6375000','0','0','0','6375000','ALIKA','00045566','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGBC-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='PSGT-ZGBC-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260803-0005','2026-08-03','2.500','2026-08-03','15:44:33','PLG0014002','6375000','6375000','0','6375000','0','kasir','2026-08-03 15:44:32','FJ-260803-0004','DP-02715','5100000');
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-08-03','FJ-260803-0005','2026-08-03','15:44:33','ALIKA','6375000','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-260803-0004','2026-08-03','2026-08-03 15:44:32','PENJUALAN : FJ-260803-0005','0','TBC','1275000','1275000','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-260803-0005','D','2026-08-03','15:44:33','TBC','PENJUALAN','FJ-260803-0005','25793808564','1275000','25795083564','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='1673000' WHERE no_faktur_jual='FJ-260803-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-260803-0006','kasirbip','1',' DP-03045BI','TOKO','BIPPSN','PSPRT-ZGBI-27-0','CINCIN PERAK ','','2.560','1','100.00','262000','0','0','17800','950000','0','0','0','950000','SAL','00045728','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBI-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.560',berat_jual_asli=berat_jual_asli+'2.560',stock_jual='1',berat_akhir=berat_akhir-'2.560',berat_akhir_asli=berat_akhir_asli-'2.560',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='PSPRT-ZGBI-27-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-260803-0006','2026-08-03','2.560','2026-08-03','16:45:00','PLG0014003','950000','950000','0','950000','0','kasirbip','2026-08-03 16:44:59','FJ-260803-0006','DP-03045','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-08-03','FJ-260803-0006','2026-08-03','16:45:00','SAL','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260803-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-0006';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-03 ','17:28:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-03 ','17:33:11');
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-260803-0007','kasirbip','1',' DP-02835DU','TOKO','DUPSN','PSPRT-ZGBH-22-0','CINCIN PERAK CM02 YL-01 ','','3.640','1','100.00','372000','0','0','17800','1200000','0','0','0','1200000','PUT','00045670','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBH-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.640',berat_jual_asli=berat_jual_asli+'3.640',stock_jual='1',berat_akhir=berat_akhir-'3.640',berat_akhir_asli=berat_akhir_asli-'3.640',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='PSPRT-ZGBH-22-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-260803-0007','2026-08-03','3.640','2026-08-03','17:34:40','PLG0014004','1200000','1200000','0','1200000','0','kasirbip','2026-08-03 17:34:40','FJ-260803-0007','DP-02835','1200000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-03','FJ-260803-0007','2026-08-03','17:34:40','PUT','1200000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260803-0007' 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-03233','DIL','1','PLD','WEDD RING PRIA','','','5.000','','10.00','1','1200000','350000','0','850000','2600000','REQ PERMATANYA DIGANTI PUTIH DOFF SEMPROT','SIZE 21 GRF: Deby ?? 25.10.26 (VINTAGE)','CROM PUTIH GLOSSY MIX DOFF MELINGKAR FULL','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-260803-0005','2026-08-03','2026-08-03 17:34:58','PESANAN : DP-03233','-','TBC','1700000','1700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260803-0006','D','2026-08-03','17:34:58','TBC','PESANAN','DP-03233','25795083564','1700000','25796783564','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-03233','2026-08-03','2026-08-03','17:34:58','PLG0014005','DIL','2026-08-28','sby','2026-08-03 17:34:58','5.000','0','0','0','1700000','0','850000','2600000','2600000','900000');
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-03234','DIL','1','PLD','WEDD RING CUSTOM WANITA','','','3.000','','25.00','1','1200000','550000','0','900000','2550000','PERMATA KOTAK 2 PERMATA PINK 9 (DETAIL WA)','SIZE 12 GRF: Nanda ?? 25.10.26 (VINTAGE)','CROM PUTIH GLOSSY','220000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260803-0006','2026-08-03','2026-08-03 17:37:51','PESANAN : DP-03234','-','TBC','1800000','1800000');
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-260803-0007','D','2026-08-03','17:37:51','TBC','PESANAN','DP-03234','25796783564','1800000','25798583564','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-03234','2026-08-03','2026-08-03','17:37:51','PLG0014006','DIL','2026-08-28','sby','2026-08-03 17:37:51','3.000','0','0','0','1800000','0','900000','2770000','2770000','970000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-0007';
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-03235','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1100000','0','1100000','sz 11 putih glossy font vladimir grf Panji','14 zirkon permata di tengah dibuat 1 zirkon','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260803-0007','2026-08-03','2026-08-03 17:44:25','PESANAN : DP-03235','.','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-260803-0008','D','2026-08-03','17:44:25','TBC','PESANAN','DP-03235','25798583564','1100000','25799683564','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-03235','2026-08-03','2026-08-03','17:44:25','PLG0014007','SAL','2026-08-28','kasirbip','2026-08-03 17:44:25','3.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-03236','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz 17 putih doff semprot','font vladimir grf Aini','model seperti 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-260803-0008','2026-08-03','2026-08-03 17:47:23','PESANAN : DP-03236','.','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-260803-0009','D','2026-08-03','17:47:23','TBC','PESANAN','DP-03236','25799683564','850000','25800533564','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-03236','2026-08-03','2026-08-03','17:47:23','PLG0014008','SAL','2026-08-28','kasirbip','2026-08-03 17:47:23','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03237','ALIKA','1','PLD','WEDING RING','','','3.000','','10.00','1','1200000','350000','0','700000','1750000','cwe size 17.5 grf Nursan','crom kuning tengah doff semprot luar glosy','EXPRESS 100K','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-260803-0009','2026-08-03','2026-08-03 17:58:52','PESANAN : DP-03237','0','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-260803-0010','D','2026-08-03','17:58:52','TBC','PESANAN','DP-03237','25800533564','1400000','25801933564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-03237','2026-08-03','2026-08-03','17:58:52','PLG0014009','ALIKA','2026-08-21','kasir','2026-08-03 17:58:52','3.000','0','0','0','1400000','0','700000','1750000','1750000','350000');
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-03238','ALIKA','1','PLD','WEDING RING','','','3.000','','10.00','1','1200000','350000','0','700000','1750000','cwe size 17.5 grf Nursan','crom kuning tengah doff semprot luar glosy','EXPRESS 100K','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-260803-0010','2026-08-03','2026-08-03 17:58:54','PESANAN : DP-03238','0','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-260803-0011','D','2026-08-03','17:58:54','TBC','PESANAN','DP-03238','25801933564','1400000','25803333564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-03238','2026-08-03','2026-08-03','17:58:54','PLG0014010','ALIKA','2026-08-21','kasir','2026-08-03 17:58:54','3.000','0','0','0','1400000','0','700000','1750000','1750000','350000');
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-260803-0008','kasirbip','1',' DP-02658BI','TOKO','BIPPSN','PSPLT-ZGAG-36-0','CINCIN PALADIUM YL-01 ','','1.840','1','17.00','414000','0','0','17800','1144000','0','0','0','1144000','SAL','00045303','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAG-36-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-08-03' AND kode_barang='PSPLT-ZGAG-36-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-260803-0008','2026-08-03','1.840','2026-08-03','18:00:24','PLG0014011','1144000','1144000','0','1144000','0','kasirbip','2026-08-03 18:00:23','FJ-260803-0008','DP-02658','960000');
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-08-03','FJ-260803-0008','2026-08-03','18:00:24','SAL','1144000','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-260803-0011','2026-08-03','2026-08-03 18:00:23','PENJUALAN : FJ-260803-0008','.','TBC','184000','184000','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-260803-0012','D','2026-08-03','18:00:24','TBC','PENJUALAN','FJ-260803-0008','25803333564','184000','25803517564','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='184000' WHERE no_faktur_jual='FJ-260803-0008' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03239','ALIKA','1','PLD','WEDING RING','','','3.500','','10.00','1','1200000','350000','0','700000','1925000','cwo size 16 grf Chrisanto','crom kuning tengah doff semprot luar glosy','express 100k','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-260803-0012','2026-08-03','2026-08-03 18:03:40','PESANAN : DP-03239','0','TBC','1540000','1540000');
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-260803-0013','D','2026-08-03','18:03:40','TBC','PESANAN','DP-03239','25803517564','1540000','25805057564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-03239','2026-08-03','2026-08-03','18:03:40','PLG0014012','ALIKA','2026-08-21','kasir','2026-08-03 18:03:40','3.500','0','0','0','1540000','0','700000','1925000','1925000','385000');
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-03240','NAD','1','GOLD','WEDRING','','','1.500','','50.00','1','2290000','1800000','0','800000','3500000','zircon 17','size 11.5 crom putih rose gold glossy','EXPRESS 200.000','170000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260803-0013','2026-08-03','2026-08-03 18:13:23','PESANAN : DP-03240','.','TBC','2936000','2936000');
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-260803-0014','D','2026-08-03','18:13:23','TBC','PESANAN','DP-03240','25805057564','2936000','25807993564','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-03240','2026-08-03','2026-08-03','18:13:23','PLG0014013','NAD','2026-08-10','kasirbip','2026-08-03 18:13:23','1.500','0','0','0','2936000','0','800000','3670000','3670000','734000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-03 ','18:14:05');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-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-260803-0009','kasir','1',' TFCMP75-84','TOKO','TFCINMAS','TFCMP-ZGBX-50-0','THIFA CINCIN MAS PUTIH ','','0.580','1','84.00','1134000','0','0','17800','1180000','0','0','0','1180000','FIR','00045370','TFCMP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMP-ZGBX-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='TFCMP-ZGBX-50-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260803-0009','2026-08-03','0.580','2026-08-03','18:32:49','PLG0014014','1180000','1180000','0','1180000','0','kasir','2026-08-03 18:32:48','FJ-260803-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-03','FJ-260803-0009','2026-08-03','18:32:49','FIR','1180000','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-260803-0014','2026-08-03','2026-08-03 18:32:48','PENJUALAN : FJ-260803-0009','.','TBC','1180000','1180000','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-260803-0015','D','2026-08-03','18:32:49','TBC','PENJUALAN','FJ-260803-0009','25807993564','1180000','25809173564','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='1180000' WHERE no_faktur_jual='FJ-260803-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-0009';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03241','ELLA','1','PER','CINCIN PROMO SR01 SLV','','','2.000','','925.00','1','100000','0','0','0','950000','cwe size 9 grf Thorik & Winda zircone 1 BTR doff semprot','cwo size 19 grf Winda & Thorik doff amplas','warna crom putih sesuai model','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260803-0015','2026-08-03','2026-08-03 18:39:25','PESANAN : DP-03241','0','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260803-0016','D','2026-08-03','18:39:25','TBC','PESANAN','DP-03241','25809173564','950000','25810123564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-03241','2026-08-03','2026-08-03','18:39:25','PLG0014015','ELLA','2026-09-01','kasir','2026-08-03 18:39:25','2.000','0','0','0','950000','0','0','950000','950000','0');
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-00000368','X-00000368','THIFA CINCIN MAS RG','GR','---','TFCMR','BELI','BELI001','1400000','2026-08-03','0.900','1','kasir','2026-08-03 19:19:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-TFCMR';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFCMR','X-00000368','X-00000368');
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-260803-0001','-','IQB','1','BELI','BELI001','TFCMR', 'X-00000368', 'THIFA CINCIN MAS RG','0.900','0.900','75.00','1800000','1400000','1555556','1','1400000','1400000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFCMR' 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-260803-0001','2026-08-03','2026-08-03','19:19:05','IQB','---','0.900','1400000','1400000','1400000','1400000','1400000','kasir','2026-08-03 19:19:05','FB-260803-0001','OPEN','CASH');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0001','YESSY','JKT','','JKT','','kasir','2026-08-03 19:19:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0003','K','2026-08-03','19:19:05','kasir','PEMBELIAN UMUM','FB-260803-0001','7352300','1400000','5952300','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-03 ','19:35:21');
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-03242','DIL','1','PER','WEDD RING PRIA','','','2.000','','925.00','1','100000','0','850000','0','850000','PERMATA 1 BUTIR','SIZE 26 GRF: Repma (VINTAGE)','CROM 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-260803-0016','2026-08-03','2026-08-03 19:38:22','PESANAN : DP-03242','-','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-260803-0017','D','2026-08-03','19:38:22','TBC','PESANAN','DP-03242','25810123564','850000','25810973564','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-03242','2026-08-03','2026-08-03','19:38:22','PLG0014016','DIL','2026-08-26','sby','2026-08-03 19:38:22','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03243','DIL','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','850000','0','850000','PERMATA 1 BUTIR','SIZE 9 GRF: Repma (VINTAGE)','CROM 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-260803-0017','2026-08-03','2026-08-03 19:40:21','PESANAN : DP-03243','-','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-260803-0018','D','2026-08-03','19:40:21','TBC','PESANAN','DP-03243','25810973564','850000','25811823564','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-03243','2026-08-03','2026-08-03','19:40:21','PLG0014017','DIL','2026-08-26','sby','2026-08-03 19:40:21','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03244','NAD','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','700000','1575000','size cowo 20 putih doff amplas','Grf Julpah . Adji font Vintage','EXPRESS 100.000','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260803-0018','2026-08-03','2026-08-03 19:45:42','PESANAN : DP-03244','.','TBC','315000','315000');
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-260803-0019','D','2026-08-03','19:45:42','TBC','PESANAN','DP-03244','25811823564','315000','25812138564','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-03244','2026-08-03','2026-08-03','19:45:42','PLG0014018','NAD','2026-08-17','kasirbip','2026-08-03 19:45:42','2.500','0','0','0','315000','0','700000','1575000','1575000','1260000');
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-03245','NAD','1','GOLD','WEDRING','','','2.000','','37.50','1','2290000','1400000','0','750000','3550000','tambah 1 zircon tengah atas','size cewe 10 crom putih glossy','Grf Adji . Julpah Font vintage EXPRESS 100.000','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-260803-0019','2026-08-03','2026-08-03 19:49:41','PESANAN : DP-03245','.','TBC','2848000','2848000');
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-260803-0020','D','2026-08-03','19:49:41','TBC','PESANAN','DP-03245','25812138564','2848000','25814986564','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-03245','2026-08-03','2026-08-03','19:49:41','PLG0014019','NAD','2026-08-17','kasirbip','2026-08-03 19:49:41','2.000','0','0','0','2848000','0','750000','3560000','3560000','712000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-03 ','20:01:25');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260803-0010','sby','1',' DP-02745SB','TOKO','SBYPSN','PSPLT-ZGBH-27-0','CINCIN PALADIUM ','','5.150','1','17.00','1157000','0','0','17800','2563000','0','0','0','2563000','DIL','00045675','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBH-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.150',berat_jual_asli=berat_jual_asli+'5.150',stock_jual='1',berat_akhir=berat_akhir-'5.150',berat_akhir_asli=berat_akhir_asli-'5.150',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='PSPLT-ZGBH-27-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-260803-0010','2026-08-03','5.150','2026-08-03','20:07:21','PLG0014020','2563000','2563000','0','2563000','0','sby','2026-08-03 20:07:20','FJ-260803-0010','DP-02745','1700000');
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-08-03','FJ-260803-0010','2026-08-03','20:07:21','DIL','2563000','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-260803-0020','2026-08-03','2026-08-03 20:07:20','PENJUALAN : FJ-260803-0010','','TBC','863000','863000','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-260803-0021','D','2026-08-03','20:07:21','TBC','PENJUALAN','FJ-260803-0010','25814986564','863000','25815849564','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='863000' WHERE no_faktur_jual='FJ-260803-0010' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260803-0011','sby',' 1',' DP-02747SB','TOKO','SBYPSN','PSPLT-ZGBH-28-0','CINCIN PALADIUM ','','3.190','1','17.00','717000','0','0','17800','2277000','0','0','0','2277000','DIL','00045676','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBH-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.190',berat_jual_asli=berat_jual_asli+'3.190',stock_jual='1',berat_akhir=berat_akhir-'3.190',berat_akhir_asli=berat_akhir_asli-'3.190',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='PSPLT-ZGBH-28-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-260803-0011','2026-08-03','3.190','2026-08-03','20:07:21','PLG0014021','2277000','2277000','0','2277000','0','sby','2026-08-03 20:07:20','FJ-260803-0010','DP-02747','1800000');
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-08-03','FJ-260803-0011','2026-08-03','20:07:21','DIL','2277000','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-260803-0021','2026-08-03','2026-08-03 20:07:20','PENJUALAN : FJ-260803-0011','','TBC','477000','477000','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-260803-0022','D','2026-08-03','20:07:21','TBC','PENJUALAN','FJ-260803-0011','25815849564','477000','25816326564','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='1340000' WHERE no_faktur_jual='FJ-260803-0011' LIMIT 1;
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03244';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03244';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03244';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260803-0004','K','2026-08-03','20:10:31','kasirbip','PESANAN BATAL','DP-03244','5952300','0','5952300');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-03 ','20:11:44');
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-03246','NAD','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','700000','1575000','size cowo 20 crom putih doff amplas','Grf Julpah . Adji Font Vintage','EXPRESS 100.000','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260803-0022','2026-08-03','2026-08-03 20:15:16','PESANAN : DP-03246','.','TBC','1260000','1260000');
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-260803-0023','D','2026-08-03','20:15:16','TBC','PESANAN','DP-03246','25816326564','1260000','25817586564','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-03246','2026-08-03','2026-08-03','20:15:16','PLG0014022','NAD','2026-08-17','kasirbip','2026-08-03 20:15:16','2.500','0','0','0','1260000','0','700000','1575000','1575000','315000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260803-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260803-0011';
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-03247','DIL','1','PER','WEDD RING 950K SR03','','','3.000','','925.00','1','100000','0','950000','0','950000','PRIA: SIZE 22 GRF: Hertina (INFI) FONT: VINTAGE','WANITA: SIZE 13 GRF: Ayyub (NITY) FONT: VINTAGE','CROM SESUAI FOTO','100000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260803-0023','2026-08-03','2026-08-03 20:33:25','PESANAN : DP-03247','-','TBC','1050000','1050000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260803-0024','D','2026-08-03','20:33:25','TBC','PESANAN','DP-03247','25817586564','1050000','25818636564','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-03247','2026-08-03','2026-08-03','20:33:25','PLG0014023','DIL','2026-08-27','sby','2026-08-03 20:33:25','3.000','0','0','0','1050000','0','0','1050000','1050000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-03';
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-08-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-03';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-03' 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-260804-0001','D','2026-08-04','21:09:07','TBC','SALDO AWAL','SALDO AWAL','0','25818636564','25818636564');
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-260804-0001','D','2026-08-04','21:09:07','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-260804-0001','D','2026-08-04','21:09:07','','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-260804-0001','D','2026-08-04','21:09:07','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-260804-0001','D','2026-08-04','21:09:07','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-260804-0001','D','2026-08-04','21:09:07','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-260804-0001','D','2026-08-04','21:09:07','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-260804-0001','D','2026-08-04','21:09:07','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-260804-0001','D','2026-08-04','21:09:07','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-260804-0001','D','2026-08-04','21:09:07','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-260804-0001','D','2026-08-04','21:09:07','BCK','SALDO AWAL','SALDO AWAL','0','2007408000','2007408000');
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-260804-0001','D','2026-08-04','21:09:07','BCD','SALDO AWAL','SALDO AWAL','0','1448723500','1448723500');
UPDATE tp_system SET tgl_system='2026-08-04';