INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-26 ','10:47:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-26 ','11:02:27');
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-03089','SAL','1','PLD','WED RING','','','3.500','','10.00','1','1200000','350000','0','750000','1975000','sz 21.5 putih doff semprot dibuat tanpa mata','font berkshire swash grf Y A 27.09.26','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0001','2026-07-26','2026-07-26 11:05:33','PESANAN : DP-03089','.','TBC','1580000','1580000');
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-260726-0002','D','2026-07-26','11:05:33','TBC','PESANAN','DP-03089','25338542064','1580000','25340122064','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-03089','2026-07-26','2026-07-26','11:05:33','PLG0013603','SAL','2026-08-23','kasirbip','2026-07-26 11:05:33','3.500','0','0','0','1580000','0','750000','1975000','1975000','395000');
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-03090','SAL','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 16 putih doff semprot 1 zirkon','font berskhire swash grf Y A 27.09.26','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0002','2026-07-26','2026-07-26 11:07:03','PESANAN : DP-03090','.','TBC','1440000','1440000');
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-260726-0003','D','2026-07-26','11:07:03','TBC','PESANAN','DP-03090','25340122064','1440000','25341562064','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-03090','2026-07-26','2026-07-26','11:07:03','PLG0013604','SAL','2026-08-23','kasirbip','2026-07-26 11:07:03','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-26 ','11:36:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-26 ','11:38: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-03091','KUR','1','PER','CINCIN KAWIN','','','2.000','','925.00','1','100000','0','900000','0','900000','SIZE 14 GRF Afrizal','putih kilat sirkon 17','font brush script','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-260726-0003','2026-07-26','2026-07-26 11:44:53','PESANAN : DP-03091','.','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-260726-0004','D','2026-07-26','11:44:53','TBC','PESANAN','DP-03091','25341562064','900000','25342462064','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-03091','2026-07-26','2026-07-26','11:44:53','PLG0013605','KUR','2026-08-15','kasirbip','2026-07-26 11:44:53','2.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-26 ','11:48:02');
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-03092','KUR','1','PER','CINCIN KAWIN','','','2.000','','925.00','1','100000','0','600000','0','600000','size 20 grf Saddrina','putih kilat dof amplas model YL 01','FONT BRUSH SCRIPT','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-260726-0004','2026-07-26','2026-07-26 11:49:39','PESANAN : DP-03092','.','TBC','600000','600000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260726-0005','D','2026-07-26','11:49:39','TBC','PESANAN','DP-03092','25342462064','600000','25343062064','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-03092','2026-07-26','2026-07-26','11:49:39','PLG0013606','KUR','2026-08-15','kasirbip','2026-07-26 11:49:39','2.000','0','0','0','600000','0','0','600000','600000','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-03093','NAD','1','GOLD','WEDRING','','','3.000','','37.50','1','2280000','1400000','0','1000000','5200000','zircon 41 sesuai gambar','size 12.5 crom putih glossy','grf Arif...Inka font vintage','410000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0005','2026-07-26','2026-07-26 11:50:57','PESANAN : DP-03093','.','TBC','4480000','4480000');
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-260726-0006','D','2026-07-26','11:50:57','TBC','PESANAN','DP-03093','25343062064','4480000','25347542064','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-03093','2026-07-26','2026-07-26','11:50:57','PLG0013607','NAD','2026-08-29','kasirbip','2026-07-26 11:50:57','3.000','0','0','0','4480000','0','1000000','5610000','5610000','1130000');
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-260726-0001','kasirbip','1',' 750K-12-27','TOKO','BIPPER','PBDG-ZGAF-1-0','CINCIN SILVER 925 ','','1.700','1','100.00','174000','0','0','17800','850000','0','0','0','850000','SULIS','00045219','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGAF-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PBDG-ZGAF-1-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-260726-0001','2026-07-26','1.700','2026-07-26','11:54:49','PLG0013608','850000','850000','0','850000','0','kasirbip','2026-07-26 11:54:49','FJ-260726-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-07-26','FJ-260726-0001','2026-07-26','11:54:49','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-260726-0006','2026-07-26','2026-07-26 11:54:49','PENJUALAN : FJ-260726-0001','.','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-260726-0007','D','2026-07-26','11:54:49','TBC','PENJUALAN','FJ-260726-0001','25347542064','850000','25348392064','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-260726-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-260726-0002','kasirbip',' 1',' 750K-175-2','TOKO','BIPPER','PBDG-ZFAF-31-0','CINCIN SILVER 925 ','','2.770','1','100.00','283000','0','0','17800','850000','0','0','0','850000','SULIS','00044461','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZFAF-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.770',berat_jual_asli=berat_jual_asli+'2.770',stock_jual='1',berat_akhir=berat_akhir-'2.770',berat_akhir_asli=berat_akhir_asli-'2.770',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PBDG-ZFAF-31-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-260726-0002','2026-07-26','2.770','2026-07-26','11:54:49','PLG0013609','850000','850000','0','850000','0','kasirbip','2026-07-26 11:54:49','FJ-260726-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-07-26','FJ-260726-0002','2026-07-26','11:54:49','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-260726-0007','2026-07-26','2026-07-26 11:54:49','PENJUALAN : FJ-260726-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-260726-0008','D','2026-07-26','11:54:49','TBC','PENJUALAN','FJ-260726-0002','25348392064','850000','25349242064','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-260726-0002' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02190','SULIS','1','SEPASANG CCN SILVER','CWO SZ 18 KROM PUTIH DOFF SEMPROT CWE SZ 10 KROM PUTIH DOFF SEMPROT FONT KEDUANYA TIMES NEW ROMAN GRF','4.000','1','100000','100000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02190','SULIS','2','','','','','','');
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-260726-0008','2026-07-26','2026-07-26 11:57:47','SERVICE : SV-02190','.','TBC','100000','100000','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-260726-0009','D','2026-07-26','11:57:47','TBC','SERVICE','SV-02190','25349242064','100000','25349342064','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-02190','2026-07-26','2026-07-26','11:57:47','PLG0013610','kasirbip','2026-08-11','kasirbip','2026-07-26 11:57:47','4.000','0','0','0','100000','0','100000','100000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-26 ','11:58:05');
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-03094','NAD','1','PLD','WEDRING','','','3.500','','10.00','1','1200000','350000','0','750000','1975000','size 18 crom putih doff semprot','grf Inka...Arif font Vintage','','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-260726-0009','2026-07-26','2026-07-26 11:58:21','PESANAN : DP-03094','.','TBC','1580000','1580000');
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-260726-0010','D','2026-07-26','11:58:21','TBC','PESANAN','DP-03094','25349342064','1580000','25350922064','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-03094','2026-07-26','2026-07-26','11:58:21','PLG0013611','NAD','2026-08-09','kasirbip','2026-07-26 11:58:21','3.500','0','0','0','1580000','0','750000','1975000','1975000','395000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-26 ','12:12:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-26 ','12:29:04');
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-260726-0003','sby','1',' 750K-19-00','TOKO','SBYPER','PSBY-ZGBB-34-0','CINCIN SILVER 925 ','','3.280','1','100.00','335000','0','0','17800','850000','0','0','0','850000','DIL','00045525','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGBB-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.280',berat_jual_asli=berat_jual_asli+'3.280',stock_jual='1',berat_akhir=berat_akhir-'3.280',berat_akhir_asli=berat_akhir_asli-'3.280',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSBY-ZGBB-34-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-260726-0003','2026-07-26','3.280','2026-07-26','12:30:33','PLG0013612','850000','850000','0','850000','0','sby','2026-07-26 12:30:33','FJ-260726-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-26','FJ-260726-0003','2026-07-26','12:30:33','DIL','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260726-0010','2026-07-26','2026-07-26 12:30:33','PENJUALAN : FJ-260726-0003','','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-260726-0011','D','2026-07-26','12:30:33','TBC','PENJUALAN','FJ-260726-0003','25350922064','850000','25351772064','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-260726-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-260726-0004','sby',' 1',' 1.1K-135-0','TOKO','SBYPER','PSBY-ZEXA-65-0','CINCIN SILVER 925 ','','2.430','1','100.00','249000','0','0','17800','1200000','0','0','0','1200000','DIL','00043087','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-65-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.430',berat_jual_asli=berat_jual_asli+'2.430',stock_jual='1',berat_akhir=berat_akhir-'2.430',berat_akhir_asli=berat_akhir_asli-'2.430',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSBY-ZEXA-65-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-260726-0004','2026-07-26','2.430','2026-07-26','12:30:33','PLG0013613','1200000','1200000','0','1200000','0','sby','2026-07-26 12:30:33','FJ-260726-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-26','FJ-260726-0004','2026-07-26','12:30:33','DIL','1200000','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-260726-0011','2026-07-26','2026-07-26 12:30:33','PENJUALAN : FJ-260726-0004','','TBC','1200000','1200000','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-260726-0012','D','2026-07-26','12:30:33','TBC','PENJUALAN','FJ-260726-0004','25351772064','1200000','25352972064','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='2050000' WHERE no_faktur_jual='FJ-260726-0004' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03095','DIL','1','PER','WEDD RING SR04','','','3.000','','925.00','1','100000','0','950000','0','950000','WANITA: SIZE 14.5 GRF: Fajar Risaldi ?? (VINTAGE)','PRIA: 20.5 GRF: Maya Mei Sari ?? (VINTAGE)','PUTIH (SESUAI FOTO)','100000','100000','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0012','2026-07-26','2026-07-26 12:36:21','PESANAN : DP-03095','-','TBC','1150000','1150000');
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-260726-0013','D','2026-07-26','12:36:21','TBC','PESANAN','DP-03095','25352972064','1150000','25354122064','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-03095','2026-07-26','2026-07-26','12:36:21','PLG0013614','DIL','2026-08-20','sby','2026-07-26 12:36:21','3.000','0','0','0','1150000','0','0','1150000','1150000','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-03096','PUT','1','PER','WEDDRING','','','2.500','','925.00','1','100000','0','700000','0','700000','sz 17.5 YL-01 crom putih doff amplas','grf Apriani 13.09.26 Font Comic Sans','','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-260726-0013','2026-07-26','2026-07-26 12:41:55','PESANAN : DP-03096','.','TBC','700000','700000');
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-260726-0014','D','2026-07-26','12:41:55','TBC','PESANAN','DP-03096','25354122064','700000','25354822064','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-03096','2026-07-26','2026-07-26','12:41:55','PLG0013615','PUT','2026-08-24','kasirbip','2026-07-26 12:41:55','2.500','0','0','0','700000','0','0','700000','700000','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-260726-0005','sby','1',' DP-02689SB','TOKO','SBYPSN','PSGT-ZGAG-32-0','CINCIN EMAS ','','1.700','1','45.00','1780000','0','0','17800','3640000','0','0','0','3640000','VAN','00045299','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGAG-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSGT-ZGAG-32-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-260726-0005','2026-07-26','1.700','2026-07-26','12:45:11','PLG0013616','3640000','3640000','0','3640000','0','sby','2026-07-26 12:45:10','FJ-260726-0005','DP-02689','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-26','FJ-260726-0005','2026-07-26','12:45:11','VAN','3640000','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-260726-0014','2026-07-26','2026-07-26 12:45:10','PENJUALAN : FJ-260726-0005','','TBC','340000','340000','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-260726-0015','D','2026-07-26','12:45:11','TBC','PENJUALAN','FJ-260726-0005','25354822064','340000','25355162064','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='340000' WHERE no_faktur_jual='FJ-260726-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-260726-0006','sby',' 1',' DP-02687SB','TOKO','SBYPSN','PSPLT-ZGBX-61-0','CINCIN PALADIUM YL-10 ','','3.930','1','17.00','883000','0','0','17800','2075000','0','0','0','2075000','VAN','00045381','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBX-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.930',berat_jual_asli=berat_jual_asli+'3.930',stock_jual='1',berat_akhir=berat_akhir-'3.930',berat_akhir_asli=berat_akhir_asli-'3.930',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPLT-ZGBX-61-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-260726-0006','2026-07-26','3.930','2026-07-26','12:45:11','PLG0013617','2075000','2075000','0','2075000','0','sby','2026-07-26 12:45:10','FJ-260726-0005','DP-02687','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-26','FJ-260726-0006','2026-07-26','12:45:11','VAN','2075000','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-260726-0015','2026-07-26','2026-07-26 12:45:10','PENJUALAN : FJ-260726-0006','','TBC','375000','375000','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-260726-0016','D','2026-07-26','12:45:11','TBC','PENJUALAN','FJ-260726-0006','25355162064','375000','25355537064','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='715000' WHERE no_faktur_jual='FJ-260726-0006' 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-03097','PUT','1','PLD','WEDRING','','','2.500','','25.00','1','1200000','550000','0','850000','2225000','zircon 9','sz 12 crom putih gllosy','grf Ardi 13.09.26 font comic sans','90000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0016','2026-07-26','2026-07-26 12:46:21','PESANAN : DP-03097','.','TBC','1852000','1852000');
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-260726-0017','D','2026-07-26','12:46:21','TBC','PESANAN','DP-03097','25355537064','1852000','25357389064','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-03097','2026-07-26','2026-07-26','12:46:21','PLG0013618','PUT','2026-08-24','kasirbip','2026-07-26 12:46:21','2.500','0','0','0','1852000','0','850000','2315000','2315000','463000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-26 ','12:46:49');
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-260726-0007','sby','1',' DP-02757SB','TOKO','SBYPSN','PSPRT-ZGBC-27-0','CINCIN PERAK ','','2.810','1','100.00','287000','0','0','17800','800000','0','0','0','800000','VAN','00045574','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBC-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.810',berat_jual_asli=berat_jual_asli+'2.810',stock_jual='1',berat_akhir=berat_akhir-'2.810',berat_akhir_asli=berat_akhir_asli-'2.810',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGBC-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-260726-0007','2026-07-26','2.810','2026-07-26','13:00:16','PLG0013619','800000','800000','0','800000','0','sby','2026-07-26 13:00:16','FJ-260726-0007','DP-02757','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-26','FJ-260726-0007','2026-07-26','13:00:16','VAN','800000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260726-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-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-03098','ADEL','1','PLD','WED RING','ONGKOS DAN ZIRCON','','3.500','','10.00','1','1200000','350000','','960000','2185000','SIZE CWE : SIZE 14 CWOK 16','GRAF : MENYUSUL','FINISHING SEPERTI CONTOH CUSTOM','','','');
INSERT INTO tm_barang_contoh(no_persekot,no_urut,kode_barang,nama_barang,berat,tgl_titip,status) VALUES ('DP-03098','1','','GAMBAR CUSTOM DI WA','','2026-07-26 13:19:07','OPEN');
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-03098','2026-07-26','2026-07-26','13:19:07','PLG0013620','ADEL','2026-08-16','jogja','2026-07-26 13:19:07','3.500','1748000','0','0','0','0','960000','2185000','2185000','437000');
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-260726-0002','D','2026-07-26','13:19:07','jogja','PESANAN','DP-03098','652300','1748000','2400300');
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-03099','ADEL','1','PLD','WED RING','ONGKOS DAN ZIRCON','','4.500','','10.00','1','1200000','350000','','860000','2435000','SIZE CWE : SIZE 14 CWOK 16','GRAF : MENYUSUL','FINISHING SEPERTI CONTOH CUSTOM','','','');
INSERT INTO tm_barang_contoh(no_persekot,no_urut,kode_barang,nama_barang,berat,tgl_titip,status) VALUES ('DP-03099','1','','GAMBAR CUSTOM DI WA','','2026-07-26 13:23:03','OPEN');
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-03099','2026-07-26','2026-07-26','13:23:03','PLG0013621','ADEL','2026-08-16','jogja','2026-07-26 13:23:03','4.500','1948000','0','0','0','0','860000','2435000','2435000','487000');
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-260726-0003','D','2026-07-26','13:23:03','jogja','PESANAN','DP-03099','2400300','1948000','4348300');
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-260726-0008','sby','1',' DP-02785SB','TOKO','SBYPSN','PSGT-ZGBD-5-0','CINCIN EMAS SR-02 CINCIN PERAK YL-01 ','','1.830','1','45.00','1916000','0','0','17800','4062000','0','0','0','4062000','DIL','00045581','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGBD-5-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-26' AND kode_barang='PSGT-ZGBD-5-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-260726-0008','2026-07-26','1.830','2026-07-26','13:26:13','PLG0013622','4062000','4062000','0','4062000','0','sby','2026-07-26 13:26:13','FJ-260726-0008','DP-02785','3600000');
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-26','FJ-260726-0008','2026-07-26','13:26:13','DIL','4062000','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-260726-0017','2026-07-26','2026-07-26 13:26:13','PENJUALAN : FJ-260726-0008','','TBC','462000','462000','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-260726-0018','D','2026-07-26','13:26:13','TBC','PENJUALAN','FJ-260726-0008','25357389064','462000','25357851064','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='462000' WHERE no_faktur_jual='FJ-260726-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-260726-0009','kasirbip','1',' 750K-175-0','TOKO','DUPERBDG','LXPER-ZGBA-60-0','CINCIN SILVER 925 ','','3.040','1','100.00','311000','0','0','17800','900000','0','0','0','900000','NAD','00045453','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZGBA-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.040',berat_jual_asli=berat_jual_asli+'3.040',stock_jual='1',berat_akhir=berat_akhir-'3.040',berat_akhir_asli=berat_akhir_asli-'3.040',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='LXPER-ZGBA-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260726-0009','2026-07-26','3.040','2026-07-26','13:27:56','PLG0013623','900000','900000','0','900000','0','kasirbip','2026-07-26 13:27:55','FJ-260726-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-07-26','FJ-260726-0009','2026-07-26','13:27:56','NAD','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260726-0018','2026-07-26','2026-07-26 13:27:55','PENJUALAN : FJ-260726-0009','.','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-260726-0019','D','2026-07-26','13:27:56','TBC','PENJUALAN','FJ-260726-0009','25357851064','900000','25358751064','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-260726-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0009';
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-260726-0010','sby','1',' DP-02818SB','TOKO','SBYPSN','PSPRT-ZGBB-9-0','1PS CINCIN PERAK ','','3.730','1','100.00','381000','0','0','17800','1600000','0','0','0','1600000','VAN','00045500','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBB-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.730',berat_jual_asli=berat_jual_asli+'3.730',stock_jual='1',berat_akhir=berat_akhir-'3.730',berat_akhir_asli=berat_akhir_asli-'3.730',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGBB-9-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-260726-0010','2026-07-26','3.730','2026-07-26','13:30:42','PLG0013624','1600000','1600000','0','1600000','0','sby','2026-07-26 13:30:41','FJ-260726-0010','DP-02818','1600000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-26','FJ-260726-0010','2026-07-26','13:30:42','VAN','1600000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260726-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-260726-0011','kasirbip','1',' DP-02793BI','TOKO','BIPPSN','PSPRT-ZGBB-51-0','CINCIN PERAK ','','3.560','1','100.00','364000','0','0','17800','900000','0','0','0','900000','SULIS','00045542','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBB-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.560',berat_jual_asli=berat_jual_asli+'3.560',stock_jual='1',berat_akhir=berat_akhir-'3.560',berat_akhir_asli=berat_akhir_asli-'3.560',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGBB-51-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-260726-0011','2026-07-26','3.560','2026-07-26','14:32:39','PLG0013625','900000','900000','0','900000','0','kasirbip','2026-07-26 14:32:38','FJ-260726-0011','DP-02793','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-26','FJ-260726-0011','2026-07-26','14:32:39','SULIS','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260726-0011' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260726-0012','kasirbip',' 1',' DP-02792BI','TOKO','BIPPSN','PSPRT-ZGAF-30-0','CINCIN PERAK ','','1.390','1','100.00','142000','0','0','17800','1000000','0','0','0','1000000','SULIS','00045248','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAF-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.390',berat_jual_asli=berat_jual_asli+'1.390',stock_jual='1',berat_akhir=berat_akhir-'1.390',berat_akhir_asli=berat_akhir_asli-'1.390',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGAF-30-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-260726-0012','2026-07-26','1.390','2026-07-26','14:32:39','PLG0013626','1000000','1000000','0','1000000','0','kasirbip','2026-07-26 14:32:38','FJ-260726-0011','DP-02792','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-26','FJ-260726-0012','2026-07-26','14:32:39','SULIS','1000000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260726-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0012';
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-03100','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1500000','0','1500000','cwe sz 12.5 putih glosy grf Nia & Apet','cwo sz 15.5 putih glosy grf Nia & Apet','font vintage rotter CP-06','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0019','2026-07-26','2026-07-26 14:35:28','PESANAN : DP-03100','.','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-260726-0020','D','2026-07-26','14:35:28','TBC','PESANAN','DP-03100','25358751064','1500000','25360251064','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-03100','2026-07-26','2026-07-26','14:35:28','PLG0013627','SULIS','2026-08-13','kasirbip','2026-07-26 14:35:28','2.000','0','0','0','1500000','0','0','1500000','1500000','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-260726-0013','kasir','1',' TFCMR75-84','TOKO','TFCINMAS','TFCMR-YIXD-27-0','THIFA CINCIN MAS RG ','','0.900','1','84.00','1759000','0','0','17800','1800000','0','0','0','1800000','FIR','00038545','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YIXD-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='TFCMR-YIXD-27-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-260726-0013','2026-07-26','0.900','2026-07-26','14:59:55','PLG0013628','1800000','1800000','0','1800000','0','kasir','2026-07-26 14:59:54','FJ-260726-0013','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-26','FJ-260726-0013','2026-07-26','14:59:55','FIR','1800000','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-260726-0020','2026-07-26','2026-07-26 14:59:54','PENJUALAN : FJ-260726-0013','.','TBC','1800000','1800000','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-260726-0021','D','2026-07-26','14:59:55','TBC','PENJUALAN','FJ-260726-0013','25360251064','1800000','25362051064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1800000' WHERE no_faktur_jual='FJ-260726-0013' 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-03101','PUT','1','PLD','WEDRING','','','4.000','','25.00','1','1200000','550000','0','850000','3050000','sz 21.5 crom putih doff semprot','grf 1.23.4 font comic sans','','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-260726-0021','2026-07-26','2026-07-26 15:03:14','PESANAN : DP-03101','.','TBC','2440000','2440000');
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-260726-0022','D','2026-07-26','15:03:14','TBC','PESANAN','DP-03101','25362051064','2440000','25364491064','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-03101','2026-07-26','2026-07-26','15:03:14','PLG0013629','PUT','2026-08-24','kasirbip','2026-07-26 15:03:14','4.000','0','0','0','2440000','0','850000','3050000','3050000','610000');
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-07-26',  status ='CLOS' WHERE no_service='SV-02168';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02168';
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-03102','PUT','1','PLD','WEDRING','','','3.500','','25.00','1','1200000','550000','0','750000','2675000','sz 17.5 crom putih doff semprot','grf 1.23.4 font comic sans','','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-260726-0022','2026-07-26','2026-07-26 15:06:58','PESANAN : DP-03102','.','TBC','2140000','2140000');
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-260726-0023','D','2026-07-26','15:06:58','TBC','PESANAN','DP-03102','25364491064','2140000','25366631064','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-03102','2026-07-26','2026-07-26','15:06:58','PLG0013630','PUT','2026-08-24','kasirbip','2026-07-26 15:06:58','3.500','0','0','0','2140000','0','750000','2675000','2675000','535000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-26 ','15:07:26');
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-260726-0014','sby','1',' DP-03005SB','TOKO','SBYPSN','PSPRT-ZGBD-8-0','CINCIN PERAK ','','2.640','1','100.00','270000','0','0','17800','850000','0','0','0','850000','DIL','00045584','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBD-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.640',berat_jual_asli=berat_jual_asli+'2.640',stock_jual='1',berat_akhir=berat_akhir-'2.640',berat_akhir_asli=berat_akhir_asli-'2.640',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGBD-8-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-260726-0014','2026-07-26','2.640','2026-07-26','15:08:53','PLG0013631','850000','850000','0','850000','0','sby','2026-07-26 15:08:53','FJ-260726-0014','DP-03005','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-26','FJ-260726-0014','2026-07-26','15:08:53','DIL','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-260726-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0013';
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-260726-0015','kasirbip','1',' DP-02700BI','TOKO','BIPPSN','PSPRT-ZGAX-2-0','CINCIN PERAK ','','1.750','1','100.00','179000','0','0','17800','1100000','0','0','0','1100000','SAL','00045082','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAX-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGAX-2-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-260726-0015','2026-07-26','1.750','2026-07-26','15:31:17','PLG0013632','1100000','1100000','0','1100000','0','kasirbip','2026-07-26 15:31:16','FJ-260726-0015','DP-02700','1100000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-26','FJ-260726-0015','2026-07-26','15:31:17','SAL','1100000','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-260726-0015' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-07-26 ','15:33:30');
DELETE FROM tm_berlian WHERE kode_barang='BDCM-YFAG-9-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCM-YFAG-9-0','00036359','00036359','BANDUNG CINCIN EMAS ','BANDUNG CINCIN EMAS','','','2839000','2839000',' 0','0','Nagatech','2026-07-26 15:40:39');
UPDATE tm_barang SET nama_barang='BANDUNG CINCIN EMAS' ,nama_atribut='' ,kode_intern='BDCM700K-51 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='BDCM-YFAG-9-0' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260726-0016','Nagatech','1',' BDCM700K-5','TOKO','BIPCMP','BDCM-YFAG-9-0','BANDUNG CINCIN EMAS','','1.500','1','83.00','3265000','0','0','17800','4225000','0','0','0','4225000','SULIS','00036359','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-YFAG-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='BDCM-YFAG-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260726-0016','2026-07-26','1.500','2026-07-26','15:42:15','PLG0013633','4225000','4225000','0','4225000','0','Nagatech','2026-07-26 15:42:15','FJ-260726-0016','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-26','FJ-260726-0016','2026-07-26','15:42:15','SULIS','4225000','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-260726-0023','2026-07-26','2026-07-26 15:42:15','PENJUALAN : FJ-260726-0016','.','TBC','4225000','4225000','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-260726-0024','D','2026-07-26','15:42:15','TBC','PENJUALAN','FJ-260726-0016','25366631064','4225000','25370856064','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='4225000' WHERE no_faktur_jual='FJ-260726-0016' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260726-0017','Nagatech',' 1',' BDCM75-84%','TOKO','BIPCMP','BDCM-ZBBE-83-0','CINCIN EMAS','','2.090','1','84.00','4084000','0','0','17800','5402500','0','0','0','5402500','SULIS','00041869','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-ZBBE-83-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-26' AND kode_barang='BDCM-ZBBE-83-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260726-0017','2026-07-26','2.090','2026-07-26','15:42:15','PLG0013634','5402500','5402500','0','5402500','0','Nagatech','2026-07-26 15:42:15','FJ-260726-0016','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-26','FJ-260726-0017','2026-07-26','15:42:15','SULIS','5402500','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-260726-0024','2026-07-26','2026-07-26 15:42:15','PENJUALAN : FJ-260726-0017','.','TBC','5402500','5402500','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-260726-0025','D','2026-07-26','15:42:15','TBC','PENJUALAN','FJ-260726-0017','25370856064','5402500','25376258564','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='9627500' WHERE no_faktur_jual='FJ-260726-0017' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-26 ','15:49:30');
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-260726-0018','kasirbip','1',' DP-02855BI','TOKO','BIPPSN','PSPRT-ZGBA-93-0','CINCIN PERAK YL-10 ','','3.880','1','100.00','396000','0','0','17800','900000','0','0','0','900000','KUR','00045486','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBA-93-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.880',berat_jual_asli=berat_jual_asli+'3.880',stock_jual='1',berat_akhir=berat_akhir-'3.880',berat_akhir_asli=berat_akhir_asli-'3.880',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGBA-93-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-260726-0018','2026-07-26','3.880','2026-07-26','15:50:21','PLG0013635','900000','900000','0','900000','0','kasirbip','2026-07-26 15:50:20','FJ-260726-0018','DP-02855','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-26','FJ-260726-0018','2026-07-26','15:50:21','KUR','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260726-0018' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260726-0019','kasirbip',' 1',' DP-02857BI','TOKO','BIPPSN','PSPLT-ZGBD-18-0','CINCIN PALADIUM ','','1.740','1','17.00','391000','0','0','17800','1749000','0','0','0','1749000','KUR','00045594','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBD-18-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-26' AND kode_barang='PSPLT-ZGBD-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260726-0019','2026-07-26','1.740','2026-07-26','15:50:21','PLG0013636','1749000','1749000','0','1749000','-1000','kasirbip','2026-07-26 15:50:20','FJ-260726-0018','DP-02857','1750000');
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-26','FJ-260726-0019','2026-07-26','15:50:21','KUR','1749000','0');
UPDATE tt_jual_head SET dibayar_rp='-1000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260726-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0019';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-26 ','15:57:42');
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-260726-0020','kasir','1',' 1.2K-13-98','TOKO','MMPER','PMM-ZEBA-33-0','CINCIN SILVER 925 ','','2.390','1','100.00','244000','0','0','17800','1300000','0','0','0','1300000','ELLA','00043712','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZEBA-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PMM-ZEBA-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260726-0020','2026-07-26','2.390','2026-07-26','16:00:31','PLG0013637','1300000','1300000','0','1300000','0','kasir','2026-07-26 16:00:30','FJ-260726-0020','','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-26','FJ-260726-0020','2026-07-26','16:00:31','ELLA','1300000','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-260726-0025','2026-07-26','2026-07-26 16:00:30','PENJUALAN : FJ-260726-0020','0','TBC','1300000','1300000','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-260726-0026','D','2026-07-26','16:00:31','TBC','PENJUALAN','FJ-260726-0020','25376258564','1300000','25377558564','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='1300000' WHERE no_faktur_jual='FJ-260726-0020' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260726-0021','kasir',' 1',' 750K-17-11','TOKO','MMPER','PMM-ZGBA-83-0','CINCIN SILVER 925 ','','3.410','1','100.00','348000','0','0','17800','850000','0','0','0','850000','ELLA','00045476','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZGBA-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.410',berat_jual_asli=berat_jual_asli+'3.410',stock_jual='1',berat_akhir=berat_akhir-'3.410',berat_akhir_asli=berat_akhir_asli-'3.410',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PMM-ZGBA-83-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260726-0021','2026-07-26','3.410','2026-07-26','16:00:31','PLG0013638','850000','850000','0','850000','0','kasir','2026-07-26 16:00:30','FJ-260726-0020','','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-26','FJ-260726-0021','2026-07-26','16:00:31','ELLA','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-260726-0026','2026-07-26','2026-07-26 16:00:30','PENJUALAN : FJ-260726-0021','0','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-260726-0027','D','2026-07-26','16:00:31','TBC','PENJUALAN','FJ-260726-0021','25377558564','850000','25378408564','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='2150000' WHERE no_faktur_jual='FJ-260726-0021' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0021';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-26 ','16:21:26');
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-260726-0022','sby','1',' DP-02303SB','TOKO','SBYPSN','PSPRT-ZGAG-51-0','CINCIN PERAK YL-01 ','','3.390','1','100.00','346000','0','0','17800','850000','0','0','0','850000','VAN','00045318','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAG-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.390',berat_jual_asli=berat_jual_asli+'3.390',stock_jual='1',berat_akhir=berat_akhir-'3.390',berat_akhir_asli=berat_akhir_asli-'3.390',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGAG-51-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-260726-0022','2026-07-26','3.390','2026-07-26','16:24:29','PLG0013639','850000','850000','0','850000','0','sby','2026-07-26 16:24:28','FJ-260726-0022','DP-02303','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-26','FJ-260726-0022','2026-07-26','16:24:29','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-260726-0022' LIMIT 1;
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-07-26',  status ='CLOS' WHERE no_service='SV-02162';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02162';
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-03103','ELLA','1','GOLD','WEDDING RING','','','2.500','','375.00','1','2280000','1400000','0','750000','4250000','size 9.5 grf 20.09.2026 logo pdf','zirkon 1 butir','crom putih doff semprot','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-260726-0027','2026-07-26','2026-07-26 16:28:14','PESANAN : DP-03103','.','TBC','3400000','3400000');
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-260726-0028','D','2026-07-26','16:28:14','TBC','PESANAN','DP-03103','25378408564','3400000','25381808564','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-03103','2026-07-26','2026-07-26','16:28:14','PLG0013640','ELLA','2026-08-24','kasir','2026-07-26 16:28:14','2.500','0','0','0','3400000','0','750000','4250000','4250000','850000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02191','KUR','1','SEPASANG CCN SILVER','KROM PUTIH DOFF AMPLAS KEDUANYA','4.000','1','100000','100000');
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-260726-0028','2026-07-26','2026-07-26 16:32:27','SERVICE : SV-02191','.','TBC','100000','100000','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-260726-0029','D','2026-07-26','16:32:27','TBC','SERVICE','SV-02191','25381808564','100000','25381908564','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-02191','2026-07-26','2026-07-26','16:32:27','PLG0013641','kasirbip','2026-07-27','kasirbip','2026-07-26 16:32:27','4.000','0','0','0','100000','0','100000','100000','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-03104','ALIKA','1','GOLD','WEDDING RING','','','2.500','','75.00','1','2280000','2250000','0','850000','6475000','size 13.5 grf M. Syaifullah .A.J','Zirkon 10 butir min 2.5/2 gr','crom putih glosy','0','100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0029','2026-07-26','2026-07-26 16:35:08','PESANAN : DP-03104','.','TBC','5260000','5260000');
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-260726-0030','D','2026-07-26','16:35:08','TBC','PESANAN','DP-03104','25381908564','5260000','25387168564','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-03104','2026-07-26','2026-07-26','16:35:08','PLG0013642','ALIKA','2026-08-24','kasir','2026-07-26 16:35:08','2.500','0','0','0','5260000','0','850000','6575000','6575000','1315000');
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-260726-0023','kasir','1',' 750K-185-9','TOKO','MMPER','PMM-ZDBI-46-0','CINCIN SILVER 925 ','','2.390','1','100.00','244000','0','0','17800','850000','0','0','0','850000','ALIKA','00042944','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZDBI-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PMM-ZDBI-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260726-0023','2026-07-26','2.390','2026-07-26','16:39:30','PLG0013643','850000','850000','0','850000','0','kasir','2026-07-26 16:39:29','FJ-260726-0023','','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-26','FJ-260726-0023','2026-07-26','16:39:30','ALIKA','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-260726-0030','2026-07-26','2026-07-26 16:39:29','PENJUALAN : FJ-260726-0023','.','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-260726-0031','D','2026-07-26','16:39:30','TBC','PENJUALAN','FJ-260726-0023','25387168564','850000','25388018564','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-260726-0023' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0023';
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-260726-0024','kasir','1',' 850K-13-11','TOKO','MMPER','PMM-ZGAD-37-0','CINCIN SILVER 925 ','','1.400','1','100.00','143000','0','0','17800','950000','0','0','0','950000','ELLA','00045174','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZGAD-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PMM-ZGAD-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260726-0024','2026-07-26','1.400','2026-07-26','16:42:34','PLG0013644','950000','950000','0','950000','0','kasir','2026-07-26 16:42:33','FJ-260726-0024','','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-26','FJ-260726-0024','2026-07-26','16:42:34','ELLA','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260726-0031','2026-07-26','2026-07-26 16:42:33','PENJUALAN : FJ-260726-0024','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260726-0032','D','2026-07-26','16:42:34','TBC','PENJUALAN','FJ-260726-0024','25388018564','950000','25388968564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-260726-0024' 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-260726-0025','kasir',' 1',' 750K-165-1','TOKO','MMPER','PMM-ZGBA-82-0','CINCIN SILVER 925 ','','3.370','1','100.00','344000','0','0','17800','850000','0','0','0','850000','ELLA','00045475','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZGBA-82-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.370',berat_jual_asli=berat_jual_asli+'3.370',stock_jual='1',berat_akhir=berat_akhir-'3.370',berat_akhir_asli=berat_akhir_asli-'3.370',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PMM-ZGBA-82-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260726-0025','2026-07-26','3.370','2026-07-26','16:42:34','PLG0013645','850000','850000','0','850000','0','kasir','2026-07-26 16:42:33','FJ-260726-0024','','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-26','FJ-260726-0025','2026-07-26','16:42:34','ELLA','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-260726-0032','2026-07-26','2026-07-26 16:42:33','PENJUALAN : FJ-260726-0025','.','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-260726-0033','D','2026-07-26','16:42:34','TBC','PENJUALAN','FJ-260726-0025','25388968564','850000','25389818564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1800000' WHERE no_faktur_jual='FJ-260726-0025' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-26 ','17:06: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-260726-0026','sby','1',' DP-02816SB','TOKO','SBYPSN','PSPRT-ZGBD-6-0','CINCIN PERAK ','','2.410','1','100.00','246000','0','0','17800','850000','0','0','0','850000','VAN','00045582','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBD-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGBD-6-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-260726-0026','2026-07-26','2.410','2026-07-26','17:07:40','PLG0013646','850000','850000','0','850000','0','sby','2026-07-26 17:07:39','FJ-260726-0026','DP-02816','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-26','FJ-260726-0026','2026-07-26','17:07:40','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-260726-0026' 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-03105','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','850000','0','850000','SIZE: 21.5','GRF: April??Aldi 25.09.26 FONT: VINTAGE','PUTIH GLOSSY','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0033','2026-07-26','2026-07-26 17:30:50','PESANAN : DP-03105','-','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-260726-0034','D','2026-07-26','17:30:50','TBC','PESANAN','DP-03105','25389818564','850000','25390668564','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-03105','2026-07-26','2026-07-26','17:30:50','PLG0013647','VAN','2026-08-20','sby','2026-07-26 17:30:50','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03106','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','800000','0','800000','SIZE: 18','GRF: 17.10.2026 FONT: BRUSH SCRIPT','FINISHING : PUTIH DOF MIX GLOSSY','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0034','2026-07-26','2026-07-26 18:10:51','PESANAN : DP-03106','-','TBC','800000','800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260726-0035','D','2026-07-26','18:10:51','TBC','PESANAN','DP-03106','25390668564','800000','25391468564','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-03106','2026-07-26','2026-07-26','18:10:51','PLG0013648','VAN','2026-08-20','sby','2026-07-26 18:10:51','3.000','0','0','0','800000','0','0','800000','800000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260726-0027','kasirbip','1',' DP-02859BI','TOKO','BIPPSN','PSPRT-ZGBX-2-0','1PS CINCIN PERAK ','','5.040','1','100.00','515000','0','0','17800','1400000','0','0','0','1400000','SULIS','00045322','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBX-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.040',berat_jual_asli=berat_jual_asli+'5.040',stock_jual='1',berat_akhir=berat_akhir-'5.040',berat_akhir_asli=berat_akhir_asli-'5.040',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGBX-2-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-260726-0027','2026-07-26','5.040','2026-07-26','18:32:45','PLG0013649','1400000','1400000','0','1400000','0','kasirbip','2026-07-26 18:32:44','FJ-260726-0027','DP-02859','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-07-26','FJ-260726-0027','2026-07-26','18:32:45','SULIS','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-260726-0027' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0024';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0027';
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-03107','DIL','1','PLD','WEDD RING PRIA','','','3.500','','925.00','1','1200000','550000','0','750000','2675000','PERMATA 1 BUTIR','SIZE 21 GRF: Amel (INFINITY) FONT: VINTAGE','CROM PUTIH GLOSSY FULL','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-260726-0035','2026-07-26','2026-07-26 18:44:22','PESANAN : DP-03107','-','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-260726-0036','D','2026-07-26','18:44:22','TBC','PESANAN','DP-03107','25391468564','1800000','25393268564','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-03107','2026-07-26','2026-07-26','18:44:22','PLG0013650','DIL','2026-08-20','sby','2026-07-26 18:44:22','3.500','0','0','0','1800000','0','750000','2685000','2685000','885000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-26 ','18:45:34');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0014';
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-260726-0028','kasirbip','1',' DP-02807BI','TOKO','BIPPSN','PSPRT-ZGBD-14-0','CINCIN PERAK ','','3.770','1','100.00','385000','0','0','17800','850000','0','0','0','850000','SAL','00045590','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBD-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.770',berat_jual_asli=berat_jual_asli+'3.770',stock_jual='1',berat_akhir=berat_akhir-'3.770',berat_akhir_asli=berat_akhir_asli-'3.770',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGBD-14-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-260726-0028','2026-07-26','3.770','2026-07-26','19:16:30','PLG0013651','850000','850000','0','850000','0','kasirbip','2026-07-26 19:16:30','FJ-260726-0028','DP-02807','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-26','FJ-260726-0028','2026-07-26','19:16:30','SAL','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260726-0028' 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-260726-0029','kasirbip',' 1',' DP-02808BI','TOKO','BIPPSN','PSPRT-ZGAC-4-0','CINCIN PERAK ','','1.970','1','100.00','201000','0','0','17800','850000','0','0','0','850000','SAL','00045114','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAC-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSPRT-ZGAC-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260726-0029','2026-07-26','1.970','2026-07-26','19:16:30','PLG0013652','850000','850000','0','850000','0','kasirbip','2026-07-26 19:16:30','FJ-260726-0028','DP-02808','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-26','FJ-260726-0029','2026-07-26','19:16:30','SAL','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260726-0029' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0028';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0029';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-26 ','19:19:14');
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-03108','PUT','1','PER','WEDRING PROMO','','','4.000','','925.00','1','100000','0','1200000','0','1200000','EXPRESS 200.000 font Vintage','cwe sz 10.5 CM.01 grf Eko ... Iffah','cwo sz 15 CM.01 grf Iffah ... Eko','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-260726-0036','2026-07-26','2026-07-26 19:20:44','PESANAN : DP-03108','.','TBC','1200000','1200000');
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-260726-0037','D','2026-07-26','19:20:44','TBC','PESANAN','DP-03108','25393268564','1200000','25394468564','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-03108','2026-07-26','2026-07-26','19:20:44','PLG0013653','PUT','2026-07-31','kasirbip','2026-07-26 19:20:44','4.000','0','0','0','1200000','0','0','1200000','1200000','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-03109','VAN','1','PLD','WEDDRING PRIA','','','5.000','','25.00','1','1200000','550000','0','700000','3450000','SIZE: 18.5','GRF: TF 10.10.26 FONT: TIMES NEW','PUTIH GLOSSY 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-260726-0037','2026-07-26','2026-07-26 19:21:54','PESANAN : DP-03109','-','TBC','2400000','2400000');
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-260726-0038','D','2026-07-26','19:21:54','TBC','PESANAN','DP-03109','25394468564','2400000','25396868564','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-03109','2026-07-26','2026-07-26','19:21:54','PLG0013654','VAN','2026-08-21','sby','2026-07-26 19:21:54','5.000','0','0','0','2400000','0','700000','3450000','3450000','1050000');
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-260726-0004','K','2026-07-26','19:24:04','kasir','KAS BESAR','SALAH INPUT PSN LUXIA JOGYA','4348300','3696000','652300');
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-03110','ELLA','1','PLD','WEDDING RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','size 16.5','tanpa mata','crom putih doff semprot','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-260726-0038','2026-07-26','2026-07-26 19:29:48','PESANAN : DP-03110','.','TBC','1440000','1440000');
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-260726-0039','D','2026-07-26','19:29:48','TBC','PESANAN','DP-03110','25396868564','1440000','25398308564','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-03110','2026-07-26','2026-07-26','19:29:48','PLG0013655','ELLA','2026-08-24','kasir','2026-07-26 19:29:48','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
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-03111','DIL','1','PLD','WEDD RING PRIA','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','PERMATA 1 BUTIR','SIZE 18 GRF: Sely (INFINITY) FONT : VINTAGE','CROM PUTIH GLOSSY MIX DOFF','10000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0039','2026-07-26','2026-07-26 19:32:24','PESANAN : DP-03111','-','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-260726-0040','D','2026-07-26','19:32:24','TBC','PESANAN','DP-03111','25398308564','1500000','25399808564','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-03111','2026-07-26','2026-07-26','19:32:24','PLG0013656','DIL','2026-08-20','sby','2026-07-26 19:32:24','4.000','0','0','0','1500000','0','750000','2160000','2160000','660000');
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-03112','DIL','1','PLD','WEDD RING PRIA','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','PERMATA 1 BUTIR','SIZE 20.5 GRF: Novia Fitriani ?? (BERSKHIRE)','CROM PUTIH GLOSSY MIX DOFF','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-260726-0040','2026-07-26','2026-07-26 19:36:39','PESANAN : DP-03112','-','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-260726-0041','D','2026-07-26','19:36:39','TBC','PESANAN','DP-03112','25399808564','1500000','25401308564','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-03112','2026-07-26','2026-07-26','19:36:39','PLG0013657','DIL','2026-08-17','sby','2026-07-26 19:36:39','4.000','0','0','0','1500000','0','750000','2160000','2160000','660000');
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-03112','ALIKA','1','PER','WEDDING RING','','','1.000','','925.00','1','100000','0','0','0','1050000','size 15 grf faysal tari','zirkon 15butir','crom putih glosy','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-260726-0041','2026-07-26','2026-07-26 19:36:39','PESANAN : DP-03112','.','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-260726-0042','D','2026-07-26','19:36:39','TBC','PESANAN','DP-03112','25401308564','1050000','25402358564','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-03112','2026-07-26','2026-07-26','19:36:39','PLG0013658','ALIKA','2026-08-24','kasir','2026-07-26 19:36:39','1.000','0','0','0','1050000','0','0','1050000','1050000','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-03113','ALIKA','1','PER','WEDDING RING','','','1.000','','925.00','1','100000','0','0','0','1050000','size 15 grf faysal tari','zirkon 15butir','crom putih glosy','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-260726-0042','2026-07-26','2026-07-26 19:36:44','PESANAN : DP-03113','.','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-260726-0043','D','2026-07-26','19:36:44','TBC','PESANAN','DP-03113','25402358564','1050000','25403408564','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-03113','2026-07-26','2026-07-26','19:36:44','PLG0013659','ALIKA','2026-08-24','kasir','2026-07-26 19:36:44','1.000','0','0','0','1050000','0','0','1050000','1050000','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-03114','DIL','1','PLD','WEDD RING PRIA','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','PERMATA 1 BUTIR','SIZE 20.5 GRF: Novia Fitriani ?? (BEKSHIRE)','CROM PUTIH GLOSSY MIX DOFF','10000','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0043','2026-07-26','2026-07-26 19:40:51','PESANAN : DP-03114','-','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-260726-0044','D','2026-07-26','19:40:51','TBC','PESANAN','DP-03114','25403408564','1500000','25404908564','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-03114','2026-07-26','2026-07-26','19:40:51','PLG0013660','DIL','2026-08-17','sby','2026-07-26 19:40:51','4.000','0','0','0','1500000','0','750000','2160000','2160000','660000');
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-03115','NAD','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','1600000','0','1600000','cwe size 12.5 Grf H&A','cwo size 22 Grf A&H','EXPRESS 200.000 Font Vintage','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-260726-0044','2026-07-26','2026-07-26 19:50:22','PESANAN : DP-03115','.','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-260726-0045','D','2026-07-26','19:50:22','TBC','PESANAN','DP-03115','25404908564','1600000','25406508564','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-03115','2026-07-26','2026-07-26','19:50:22','PLG0013661','NAD','2026-07-31','kasirbip','2026-07-26 19:50:22','4.000','0','0','0','1600000','0','0','1600000','1600000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-26 ','19:56:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-26 ','20:03:12');
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-260726-0030','sby','1',' 750K-16-00','TOKO','SBYPER','PSBY-ZFBB-8-0','CINCIN SILVER 925 ','','1.900','1','100.00','194000','0','0','17800','850000','0','0','0','850000','VAN','00044622','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZFBB-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSBY-ZFBB-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-260726-0030','2026-07-26','1.900','2026-07-26','20:06:37','PLG0013662','850000','850000','0','850000','0','sby','2026-07-26 20:06:36','FJ-260726-0030','','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-26','FJ-260726-0030','2026-07-26','20:06:37','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-260726-0045','2026-07-26','2026-07-26 20:06:36','PENJUALAN : FJ-260726-0030','','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-260726-0046','D','2026-07-26','20:06:37','TBC','PENJUALAN','FJ-260726-0030','25406508564','850000','25407358564','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-260726-0030' 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-260726-0031','sby',' 1',' 1.25K-125-','TOKO','SBYPER','PSBY-ZGXG-23-0','CINCIN SILVER 925 ','','2.530','1','100.00','259000','0','0','17800','1350000','0','0','0','1350000','VAN','00045036','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGXG-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.530',berat_jual_asli=berat_jual_asli+'2.530',stock_jual='1',berat_akhir=berat_akhir-'2.530',berat_akhir_asli=berat_akhir_asli-'2.530',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSBY-ZGXG-23-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-260726-0031','2026-07-26','2.530','2026-07-26','20:06:37','PLG0013663','1350000','1350000','0','1350000','0','sby','2026-07-26 20:06:36','FJ-260726-0030','','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-26','FJ-260726-0031','2026-07-26','20:06:37','VAN','1350000','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-260726-0046','2026-07-26','2026-07-26 20:06:36','PENJUALAN : FJ-260726-0031','','TBC','1350000','1350000','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-260726-0047','D','2026-07-26','20:06:37','TBC','PENJUALAN','FJ-260726-0031','25407358564','1350000','25408708564','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='2200000' WHERE no_faktur_jual='FJ-260726-0031' 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-260726-0032','sby','1',' 750K-21-00','TOKO','SBYPER','PSBY-ZDCX-13-0','CINCIN SILVER 925 ','','1.940','1','100.00','198000','0','0','17800','850000','0','0','0','850000','DIL','00042970','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZDCX-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSBY-ZDCX-13-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-260726-0032','2026-07-26','1.940','2026-07-26','20:22:13','PLG0013664','850000','850000','0','850000','0','sby','2026-07-26 20:22:12','FJ-260726-0032','','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-26','FJ-260726-0032','2026-07-26','20:22:13','DIL','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260726-0047','2026-07-26','2026-07-26 20:22:12','PENJUALAN : FJ-260726-0032','','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-260726-0048','D','2026-07-26','20:22:13','TBC','PENJUALAN','FJ-260726-0032','25408708564','850000','25409558564','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-260726-0032' 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-260726-0033','sby',' 1',' 750K-105-0','TOKO','SBYPER','PSBY-ZEXE-39-0','CINCIN SILVER 925 ','','1.530','1','100.00','157000','0','0','17800','850000','0','0','0','850000','DIL','00043235','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='PSBY-ZEXE-39-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-260726-0033','2026-07-26','1.530','2026-07-26','20:22:13','PLG0013665','850000','850000','0','850000','0','sby','2026-07-26 20:22:12','FJ-260726-0032','','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-26','FJ-260726-0033','2026-07-26','20:22:13','DIL','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260726-0048','2026-07-26','2026-07-26 20:22:12','PENJUALAN : FJ-260726-0033','','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-260726-0049','D','2026-07-26','20:22:13','TBC','PENJUALAN','FJ-260726-0033','25409558564','850000','25410408564','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-260726-0033' LIMIT 1;
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03112';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03112';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03112';
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-260726-0005','K','2026-07-26','20:44:54','sby','PESANAN BATAL','DP-03112','652300','0','652300');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0030' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0030' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0030';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260726-0033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260726-0033';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-26';
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-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-26';
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-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-26' 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-260727-0001','D','2026-07-27','21:14:16','TBC','SALDO AWAL','SALDO AWAL','0','25410408564','25410408564');
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-260727-0001','D','2026-07-27','21:14:16','BCK','SALDO AWAL','SALDO AWAL','0','1996308000','1996308000');
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-260727-0001','D','2026-07-27','21:14:16','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-260727-0001','D','2026-07-27','21:14:16','','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-260727-0001','D','2026-07-27','21:14:16','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-260727-0001','D','2026-07-27','21:14:16','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-260727-0001','D','2026-07-27','21:14:16','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-260727-0001','D','2026-07-27','21:14:16','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-260727-0001','D','2026-07-27','21:14:16','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-260727-0001','D','2026-07-27','21:14:16','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-260727-0001','D','2026-07-27','21:14:16','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-260727-0001','D','2026-07-27','21:14:16','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
UPDATE tp_system SET tgl_system='2026-07-27';
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-03116','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','950000','0','950000','SIZE: 17','GRF: Lisaera?? FONT: BERKSHIRE','PUTIH GLOSSY','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0049','2026-07-26','2026-07-26 21:15:57','PESANAN : DP-03116','-','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-260726-0001','D','2026-07-26','21:15:57','TBC','PESANAN','DP-03116','0','950000','950000','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-03116','2026-07-26','2026-07-26','21:15:57','PLG0013666','VAN','2026-08-21','sby','2026-07-26 21:15:57','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-03117','VAN','1','PER','WEDDRING WANITA','','','3.000','','925.00','1','100000','0','950000','0','950000','SIZE: 15','GRF: Benny.F?? FONT: BERKSHIRE','PUTIH GLOSSY','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260726-0050','2026-07-26','2026-07-26 21:18:37','PESANAN : DP-03117','-','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-260726-0002','D','2026-07-26','21:18:37','TBC','PESANAN','DP-03117','950000','950000','1900000','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-03117','2026-07-26','2026-07-26','21:18:37','PLG0013667','VAN','2026-08-21','sby','2026-07-26 21:18:37','3.000','0','0','0','950000','0','0','950000','950000','0');