INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-20 ','08:06:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-20 ','08:40:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-20 ','09:54:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-07-20 ','10:11:36');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03026';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03026';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03026';
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-260720-0002','K','2026-07-20','10:19:11','Nagatech','PESANAN BATAL','DP-03026','19763300','0','19763300');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03029';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03029';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03029';
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-260720-0003','K','2026-07-20','10:20:13','Nagatech','PESANAN BATAL','DP-03029','19763300','0','19763300');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-20 ','10:53:41');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-20 ','10:53:58');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260720-0001','Nagatech','1',' DP-02712MM','TOKO','MMPSN','PSPRT-ZGAC-23-0','CINCIN PERAK YL-01 ','','2.670','1','100.00','273000','0','0','17800','850000','0','0','0','850000','ELLA','00045133','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAC-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.670',berat_jual_asli=berat_jual_asli+'2.670',stock_jual='1',berat_akhir=berat_akhir-'2.670',berat_akhir_asli=berat_akhir_asli-'2.670',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='PSPRT-ZGAC-23-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-260720-0001','2026-07-20','2.670','2026-07-20','11:00:21','PLG0013402','850000','850000','0','850000','0','Nagatech','2026-07-20 11:00:20','FJ-260720-0001','DP-02712','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','FJ-260720-0001','2026-07-20','11:00:21','ELLA','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260720-0001' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-20 ','12:25:52');
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-260720-0002','kasirbip','1',' 750K-18-27','TOKO','BIPPER','PBDG-ZGAF-2-0','CINCIN SILVER 925 ','','3.010','1','100.00','308000','0','0','17800','850000','0','0','0','850000','SULIS','00045220','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGAF-2-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-07-20' AND kode_barang='PBDG-ZGAF-2-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-260720-0002','2026-07-20','3.010','2026-07-20','12:27:27','PLG0013403','850000','850000','0','850000','0','kasirbip','2026-07-20 12:27:27','FJ-260720-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-07-20','FJ-260720-0002','2026-07-20','12:27:27','SULIS','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260720-0001','2026-07-20','2026-07-20 12:27:27','PENJUALAN : FJ-260720-0002','.','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-260720-0002','D','2026-07-20','12:27:27','TBC','PENJUALAN','FJ-260720-0002','25159304564','850000','25160154564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260720-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-20 ','12:31:11');
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-03035','VAN','1','PER','WEDDRING SEPAKET','','','3.000','','925.00','1','100000','0','1500000','','1500000','SIZE WANITA: 10.5 SIZE PRIA: 19','GRF WANITA: PRAS GRF PRIA: INTAN','FONT: VINTAGE PUTIH','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260720-0002','2026-07-20','2026-07-20 12:35:12','PESANAN : DP-03035','-','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-260720-0003','D','2026-07-20','12:35:12','TBC','PESANAN','DP-03035','25160154564','1500000','25161654564','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-03035','2026-07-20','2026-07-20','12:35:12','PLG0013404','VAN','2026-08-12','sby','2026-07-20 12:35:12','3.000','0','0','0','1500000','0','0','1500000','1500000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-20 ','12:37:50');
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-260720-0003','sby','1',' 800K-13-00','TOKO','SBYPER','PSBY-ZEXA-76-0','CINCIN SILVER 925 ','','2.330','1','100.00','238000','0','0','17800','900000','0','0','0','900000','VAN','00043098','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-76-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='PSBY-ZEXA-76-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-260720-0003','2026-07-20','2.330','2026-07-20','13:52:53','PLG0013405','900000','900000','0','900000','0','sby','2026-07-20 13:52:52','FJ-260720-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-07-20','FJ-260720-0003','2026-07-20','13:52:53','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-260720-0003','2026-07-20','2026-07-20 13:52:52','PENJUALAN : FJ-260720-0003','','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-260720-0004','D','2026-07-20','13:52:53','TBC','PENJUALAN','FJ-260720-0003','25161654564','900000','25162554564','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-260720-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-260720-0004','sby','1',' DP-02631SB','TOKO','SBYPSN','PSPLT-ZGAG-49-0','CINCIN PALADIUM ','','4.120','1','57.00','3101000','0','0','17800','4930000','0','0','0','4930000','VAN','00045316','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAG-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.120',berat_jual_asli=berat_jual_asli+'4.120',stock_jual='1',berat_akhir=berat_akhir-'4.120',berat_akhir_asli=berat_akhir_asli-'4.120',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='PSPLT-ZGAG-49-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-260720-0004','2026-07-20','4.120','2026-07-20','14:36:47','PLG0013406','4930000','4930000','0','4930000','0','sby','2026-07-20 14:36:46','FJ-260720-0004','DP-02631','3300000');
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-07-20','FJ-260720-0004','2026-07-20','14:36:47','VAN','4930000','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-260720-0004','2026-07-20','2026-07-20 14:36:46','PENJUALAN : FJ-260720-0004','','TBC','1630000','1630000','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-260720-0005','D','2026-07-20','14:36:47','TBC','PENJUALAN','FJ-260720-0004','25162554564','1630000','25164184564','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='1630000' WHERE no_faktur_jual='FJ-260720-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-260720-0005','sby',' 1',' DP-02632SB','TOKO','SBYPSN','PSPRT-ZGAF-48-0','CINCIN PERAK ','','1.340','1','100.00','137000','0','0','17800','1050000','0','0','0','1050000','VAN','00045266','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAF-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='PSPRT-ZGAF-48-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-260720-0005','2026-07-20','1.340','2026-07-20','14:36:47','PLG0013407','1050000','1050000','0','1050000','0','sby','2026-07-20 14:36:46','FJ-260720-0004','DP-02632','1050000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','FJ-260720-0005','2026-07-20','14:36:47','VAN','1050000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1630000' WHERE no_faktur_jual='FJ-260720-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-260720-0006','sby','1',' 750K-12-00','TOKO','SBYPER','PSBY-ZGXG-8-0','CINCIN SILVER 925 ','','1.840','1','100.00','188000','0','0','17800','850000','0','0','0','850000','VAN','00045021','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGXG-8-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-07-20' AND kode_barang='PSBY-ZGXG-8-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-260720-0006','2026-07-20','1.840','2026-07-20','14:57:27','PLG0013408','850000','850000','0','850000','0','sby','2026-07-20 14:57:26','FJ-260720-0006','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','FJ-260720-0006','2026-07-20','14:57:27','VAN','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-260720-0005','2026-07-20','2026-07-20 14:57:26','PENJUALAN : FJ-260720-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-260720-0006','D','2026-07-20','14:57:27','TBC','PENJUALAN','FJ-260720-0006','25164184564','850000','25165034564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260720-0006' 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-260720-0007','sby',' 1',' 750K-19-00','TOKO','SBYPER','PSBY-ZGXG-4-0','CINCIN SILVER 925 ','','2.960','1','100.00','302000','0','0','17800','850000','0','0','0','850000','VAN','00045017','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGXG-4-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-07-20' AND kode_barang='PSBY-ZGXG-4-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-260720-0007','2026-07-20','2.960','2026-07-20','14:57:27','PLG0013409','850000','850000','0','850000','0','sby','2026-07-20 14:57:26','FJ-260720-0006','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','FJ-260720-0007','2026-07-20','14:57:27','VAN','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-260720-0006','2026-07-20','2026-07-20 14:57:26','PENJUALAN : FJ-260720-0007','','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260720-0007','D','2026-07-20','14:57:27','TBC','PENJUALAN','FJ-260720-0007','25165034564','850000','25165884564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1700000' WHERE no_faktur_jual='FJ-260720-0007' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260720-0008','kasirbip','1',' DP-02758BI','TOKO','BIPPSN','PSGT-ZGAF-23-0','CINCIN EMAS ','','1.740','1','45.00','1822000','0','0','17800','3576000','0','0','0','3576000','SAL','00045241','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGAF-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.740',berat_jual_asli=berat_jual_asli+'1.740',stock_jual='1',berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='PSGT-ZGAF-23-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-260720-0008','2026-07-20','1.740','2026-07-20','16:56:47','PLG0013410','3576000','3576000','0','3576000','0','kasirbip','2026-07-20 16:56:46','FJ-260720-0008','DP-02758','3152000');
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-07-20','FJ-260720-0008','2026-07-20','16:56:47','SAL','3576000','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-260720-0007','2026-07-20','2026-07-20 16:56:46','PENJUALAN : FJ-260720-0008','.','TBC','424000','424000','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-260720-0008','D','2026-07-20','16:56:47','TBC','PENJUALAN','FJ-260720-0008','25165884564','424000','25166308564','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='424000' WHERE no_faktur_jual='FJ-260720-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260720-0009','kasirbip',' 1',' DP-02759BI','TOKO','BIPPSN','PSPLT-ZGAG-20-0','CINCIN PALADIUM ','','2.620','1','17.00','589000','0','0','17800','1667000','0','0','0','1667000','SAL','00045287','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAG-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.620',berat_jual_asli=berat_jual_asli+'2.620',stock_jual='1',berat_akhir=berat_akhir-'2.620',berat_akhir_asli=berat_akhir_asli-'2.620',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='PSPLT-ZGAG-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260720-0009','2026-07-20','2.620','2026-07-20','16:56:47','PLG0013411','1667000','1667000','0','1667000','0','kasirbip','2026-07-20 16:56:46','FJ-260720-0008','DP-02759','1300000');
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-07-20','FJ-260720-0009','2026-07-20','16:56:47','SAL','1667000','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-260720-0008','2026-07-20','2026-07-20 16:56:46','PENJUALAN : FJ-260720-0009','.','TBC','367000','367000','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-260720-0009','D','2026-07-20','16:56:47','TBC','PENJUALAN','FJ-260720-0009','25166308564','367000','25166675564','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='791000' WHERE no_faktur_jual='FJ-260720-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0009';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-20 ','17:00: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-260720-0010','kasir','1',' TFCMR75-85','TOKO','TFCINMAS','TFCMR-ZBBF-75-0','THIFA CINCIN MAS RG ','','0.810','1','85.00','1602000','0','0','17800','1650000','0','0','0','1650000','IQB','00041974','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZBBF-75-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='TFCMR-ZBBF-75-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-260720-0010','2026-07-20','0.810','2026-07-20','17:03:54','PLG0013412','1650000','1650000','0','1650000','0','kasir','2026-07-20 17:03:53','FJ-260720-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-07-20','FJ-260720-0010','2026-07-20','17:03:54','IQB','1650000','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-260720-0009','2026-07-20','2026-07-20 17:03:53','PENJUALAN : FJ-260720-0010','.','TBC','1650000','1650000','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-260720-0010','D','2026-07-20','17:03:54','TBC','PENJUALAN','FJ-260720-0010','25166675564','1650000','25168325564','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='1650000' WHERE no_faktur_jual='FJ-260720-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0010';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02179','KUR','1','1 BUAH CINCIN KAWIN SILVER','BESARIN SIZE 18 GRF 1922','2.600','1','150000','150000');
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-260720-0010','2026-07-20','2026-07-20 17:31:58','SERVICE : SV-02179','.','TBC','150000','150000','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-260720-0011','D','2026-07-20','17:31:58','TBC','SERVICE','SV-02179','25168325564','150000','25168475564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
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-02179','2026-07-20','2026-07-20','17:31:58','PLG0013413','kasirbip','2026-08-05','kasirbip','2026-07-20 17:31:58','2.600','0','0','0','150000','0','150000','150000','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-260720-0011','kasir','1',' DP-02663T ','TOKO','TFPSN','PSPRT-ZGXG-3-0','CINCIN PERAK SR-02 YL-01 ','','3.460','1','100.00','353000','0','0','17800','950000','0','0','0','950000','FIR','00045016','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGXG-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.460',berat_jual_asli=berat_jual_asli+'3.460',stock_jual='1',berat_akhir=berat_akhir-'3.460',berat_akhir_asli=berat_akhir_asli-'3.460',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='PSPRT-ZGXG-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFPSN' 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-260720-0011','2026-07-20','3.460','2026-07-20','17:42:25','PLG0013414','950000','950000','0','950000','0','kasir','2026-07-20 17:42:24','FJ-260720-0011','DP-02663','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-07-20','FJ-260720-0011','2026-07-20','17:42:25','FIR','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-260720-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0011';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-20 ','17:44:15');
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-260720-0012','kasir','1',' TFGRP75-85','TOKO','TFGLR','TFGRP-ZBBF-4-0','THIFA GELANG RANTAI PUTIH ','','4.170','1','85.00','8244000','0','0','17800','8300000','0','0','0','8300000','IQB','00041903','TFGRP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRP-ZBBF-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.170',berat_jual_asli=berat_jual_asli+'4.170',stock_jual='1',berat_akhir=berat_akhir-'4.170',berat_akhir_asli=berat_akhir_asli-'4.170',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='TFGRP-ZBBF-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260720-0012','2026-07-20','4.170','2026-07-20','18:08:58','PLG0013415','8300000','8300000','0','8300000','2300000','kasir','2026-07-20 18:08:58','FJ-260720-0012','','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-07-20','FJ-260720-0012','2026-07-20','18:08:58','IQB','8300000','0');
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 ('KM-260720-0004','D','2026-07-20','18:08:58','kasir','PENJUALAN','FJ-260720-0012','19763300','2300000','22063300','OPEN');
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-260720-0011','2026-07-20','2026-07-20 18:08:58','PENJUALAN : FJ-260720-0012','.','TBC','6000000','6000000','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-260720-0012','D','2026-07-20','18:08:58','TBC','PENJUALAN','FJ-260720-0012','25168475564','6000000','25174475564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='2300000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='6000000' WHERE no_faktur_jual='FJ-260720-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0012';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-20 ','18:16:29');
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-260720-0005','K','2026-07-20','18:17:11','kasir','BELANJA','BELI LAP','22063300','31000','22032300');
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-03036','ALIKA','1','PER','WEDDING RING','','','4.000','','925.00','1','100000','0','0','0','850000','SIZE 21 GRF SYALSYA . YOGA','WARNA CROM PUTIH DOFF AMPLAS','TANPA PERMATA','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-260720-0012','2026-07-20','2026-07-20 18:30:22','PESANAN : DP-03036','0','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-260720-0013','D','2026-07-20','18:30:22','TBC','PESANAN','DP-03036','25174475564','850000','25175325564','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-03036','2026-07-20','2026-07-20','18:30:22','PLG0013416','ALIKA','2026-08-18','kasir','2026-07-20 18:30:22','4.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-03037','ALIKA','1','PER','WEDDING RING','','','4.000','','925.00','1','100000','0','0','0','850000','SIZE 21 GRF SYALSYA . YOGA','WARNA CROM PUTIH DOFF AMPLAS','TANPA PERMATA','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-260720-0013','2026-07-20','2026-07-20 18:30:27','PESANAN : DP-03037','0','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-260720-0014','D','2026-07-20','18:30:27','TBC','PESANAN','DP-03037','25175325564','850000','25176175564','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-03037','2026-07-20','2026-07-20','18:30:27','PLG0013417','ALIKA','2026-08-18','kasir','2026-07-20 18:30:27','4.000','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-260720-0013','sby','1',' DP-02661SB','TOKO','SBYPSN','PSGT-ZGAG-30-0','CINCIN EMAS ','','1.830','1','45.00','1916000','0','0','17800','3795000','0','0','0','3795000','VAN','00045297','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGAG-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='PSGT-ZGAG-30-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-260720-0013','2026-07-20','1.830','2026-07-20','18:35:51','PLG0013418','3795000','3795000','0','3795000','0','sby','2026-07-20 18:35:51','FJ-260720-0013','DP-02661','3000000');
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-07-20','FJ-260720-0013','2026-07-20','18:35:51','VAN','3795000','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-260720-0014','2026-07-20','2026-07-20 18:35:51','PENJUALAN : FJ-260720-0013','','TBC','795000','795000','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-260720-0015','D','2026-07-20','18:35:51','TBC','PENJUALAN','FJ-260720-0013','25176175564','795000','25176970564','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='795000' WHERE no_faktur_jual='FJ-260720-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-260720-0014','sby',' 1',' DP-02662SB','TOKO','SBYPSN','PSPLT-ZGAG-25-0','CINCIN PALADIUM ','','2.090','1','17.00','470000','0','0','17800','1481000','0','0','0','1481000','VAN','00045292','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAG-25-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-07-20' AND kode_barang='PSPLT-ZGAG-25-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-260720-0014','2026-07-20','2.090','2026-07-20','18:35:51','PLG0013419','1481000','1481000','0','1481000','0','sby','2026-07-20 18:35:51','FJ-260720-0013','DP-02662','1000000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','FJ-260720-0014','2026-07-20','18:35:51','VAN','1481000','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-260720-0015','2026-07-20','2026-07-20 18:35:51','PENJUALAN : FJ-260720-0014','','TBC','481000','481000','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-260720-0016','D','2026-07-20','18:35:51','TBC','PENJUALAN','FJ-260720-0014','25176970564','481000','25177451564','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='1276000' WHERE no_faktur_jual='FJ-260720-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0014';
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-03038','ALIKA','1','GOLD','WEDDING RING','','','3.000','','75.00','1','2280000','2250000','0','800000','7550000','SIZE 9 GRF YOGA . SYALSYA','WARNA CROM PUTIH GLOSY','ZIRCONE 38 BUTIR','0','0','380000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260720-0016','2026-07-20','2026-07-20 18:40:09','PESANAN : DP-03038','0','TBC','6344000','6344000');
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-260720-0017','D','2026-07-20','18:40:09','TBC','PESANAN','DP-03038','25177451564','6344000','25183795564','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-03038','2026-07-20','2026-07-20','18:40:09','PLG0013420','ALIKA','2026-08-18','kasir','2026-07-20 18:40:09','3.000','0','0','0','6344000','0','800000','7930000','7930000','1586000');
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-260720-0015','sby','1',' DP-02679SB','TOKO','SBYPSN','PSPLT-ZGAG-50-0','CINCIN PALADIUM ','','3.120','1','32.00','1319000','0','0','17800','2546000','0','0','0','2546000','VAN','00045317','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAG-50-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-07-20' AND kode_barang='PSPLT-ZGAG-50-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-260720-0015','2026-07-20','3.120','2026-07-20','18:55:43','PLG0013421','2546000','2546000','0','2546000','0','sby','2026-07-20 18:55:42','FJ-260720-0015','DP-02679','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-07-20','FJ-260720-0015','2026-07-20','18:55:43','VAN','2546000','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-260720-0017','2026-07-20','2026-07-20 18:55:42','PENJUALAN : FJ-260720-0015','','TBC','846000','846000','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-260720-0018','D','2026-07-20','18:55:43','TBC','PENJUALAN','FJ-260720-0015','25183795564','846000','25184641564','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='846000' WHERE no_faktur_jual='FJ-260720-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-260720-0016','sby',' 1',' DP-02678SB','TOKO','SBYPSN','PSPLT-ZGAG-53-0','CINCIN PALADIUM ','','3.050','1','32.00','1289000','0','0','17800','2427000','0','0','0','2427000','VAN','00045320','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAG-53-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='PSPLT-ZGAG-53-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-260720-0016','2026-07-20','3.050','2026-07-20','18:55:43','PLG0013422','2427000','2427000','0','2427000','0','sby','2026-07-20 18:55:42','FJ-260720-0015','DP-02678','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-07-20','FJ-260720-0016','2026-07-20','18:55:43','VAN','2427000','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-260720-0018','2026-07-20','2026-07-20 18:55:42','PENJUALAN : FJ-260720-0016','','TBC','627000','627000','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-260720-0019','D','2026-07-20','18:55:43','TBC','PENJUALAN','FJ-260720-0016','25184641564','627000','25185268564','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='1473000' WHERE no_faktur_jual='FJ-260720-0016' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-07-20 ','18:57:49');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03037';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03037';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03037';
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-260720-0006','K','2026-07-20','18:58:22','Nagatech','PESANAN BATAL','DP-03037','22032300','0','22032300');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-20 ','19:11:56');
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-260720-0017','sby','1',' DP-02611SB','TOKO','SBYPSN','PSPRT-ZGAD-14-0','CINCIN PERAK ','','2.200','1','100.00','225000','0','0','17800','850000','0','0','0','850000','VAN','00045151','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAD-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='PSPRT-ZGAD-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260720-0017','2026-07-20','2.200','2026-07-20','19:16:49','PLG0013423','850000','850000','0','850000','0','sby','2026-07-20 19:16:49','FJ-260720-0017','DP-02611','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','FJ-260720-0017','2026-07-20','19:16:49','VAN','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260720-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260720-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260720-0017';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-20 ','19:35:38');
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-03039','KUR','1','GOLD','CINCIN KAWIN','','','2.000','','37.50','1','2280000','1400000','0','750000','3550000','size 13.5 grf Luthfi','roshgold doff semprot sepinggang 1 sirkon','font brush sript','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-260720-0019','2026-07-20','2026-07-20 19:37:46','PESANAN : DP-03039','.','TBC','2840000','2840000');
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-260720-0020','D','2026-07-20','19:37:46','TBC','PESANAN','DP-03039','25185268564','2840000','25188108564','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-03039','2026-07-20','2026-07-20','19:37:46','PLG0013424','KUR','2026-07-23','kasirbip','2026-07-20 19:37:46','2.000','0','0','0','2840000','0','750000','3550000','3550000','710000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-20 ','19:41:20');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03040','SULIS','1','GOLD','WED RING','','','1.500','','75.00','1','2280000','2250000','0','750000','4125000','SR-04 1 zircon hitam glisy sz 9','font vladimir grf Affan & Getsi','berat akhir jangan lebih dari 1.5 gr','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260720-0020','2026-07-20','2026-07-20 19:48:43','PESANAN : DP-03040','.','TBC','3300000','3300000');
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-260720-0021','D','2026-07-20','19:48:43','TBC','PESANAN','DP-03040','25188108564','3300000','25191408564','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-03040','2026-07-20','2026-07-20','19:48:43','PLG0013425','SULIS','2026-08-12','kasirbip','2026-07-20 19:48:43','1.500','0','0','0','3300000','0','750000','4125000','4125000','825000');
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-260720-0007','K','2026-07-20','19:50:42','kasir','KAS BESAR','SALAH INPUT','22032300','1000000','21032300');
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-03041','SULIS','1','PLD','WED RING','','','3.000','','50.00','1','1200000','1000000','0','700000','3700000','SZ 15 hitam doff semprot','font vladimir grf Getsi & Affan','berat akhit jgn lebih dr 3 mdel persis cnth lebar & tebalnya','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260720-0021','2026-07-20','2026-07-20 19:51:24','PESANAN : DP-03041','.','TBC','2960000','2960000');
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-260720-0022','D','2026-07-20','19:51:24','TBC','PESANAN','DP-03041','25191408564','2960000','25194368564','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-03041','2026-07-20','2026-07-20','19:51:24','PLG0013426','SULIS','2026-08-12','kasirbip','2026-07-20 19:51:24','3.000','0','0','0','2960000','0','700000','3700000','3700000','740000');
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-03042','KUR','1','PER','CINCIN KAWIN PROMO','','','3.000','','925.00','1','100000','0','950000','0','950000','cewe size 8 grf Irfan YL-01','cowo size15.5 grf Laras expres 100.000 SR-03 SIRKON 1','font brushscript','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-260720-0022','2026-07-20','2026-07-20 20:10:14','PESANAN : DP-03042','.','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-260720-0023','D','2026-07-20','20:10:14','TBC','PESANAN','DP-03042','25194368564','950000','25195318564','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-03042','2026-07-20','2026-07-20','20:10:14','PLG0013427','KUR','2026-07-30','kasirbip','2026-07-20 20:10:14','3.000','0','0','0','950000','0','0','950000','950000','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-03043','KUR','1','PER','CINCIN KAWIN','','','25.000','','925.00','1','100000','0','900000','0','900000','SIZE 15 GRF Adinda','putihdoff sepinggang brush cript','expres 200.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-260720-0023','2026-07-20','2026-07-20 20:25:07','PESANAN : DP-03043','.','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260720-0024','D','2026-07-20','20:25:07','TBC','PESANAN','DP-03043','25195318564','900000','25196218564','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-03043','2026-07-20','2026-07-20','20:25:07','PLG0013428','KUR','2026-08-23','kasirbip','2026-07-20 20:25:07','25.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-20';
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-07-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-20' 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-260721-0001','D','2026-07-21','21:02:55','TBC','SALDO AWAL','SALDO AWAL','0','25196218564','25196218564');
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-260721-0001','D','2026-07-21','21:02:55','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-260721-0001','D','2026-07-21','21:02:55','','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-260721-0001','D','2026-07-21','21:02:55','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-260721-0001','D','2026-07-21','21:02:55','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-260721-0001','D','2026-07-21','21:02:55','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-260721-0001','D','2026-07-21','21:02:55','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-260721-0001','D','2026-07-21','21:02:55','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-260721-0001','D','2026-07-21','21:02:55','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-260721-0001','D','2026-07-21','21:02:55','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000');
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-260721-0001','D','2026-07-21','21:02:55','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-260721-0001','D','2026-07-21','21:02:55','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
UPDATE tp_system SET tgl_system='2026-07-21';