INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-21 ','10:56: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-260621-0001','kasirbip','1',' DP-02449BI','TOKO','BIPPSN','PSPRT-ZFAH-70-0','CINCIN PERAK SR-01 YL-01 ','','3.290','1','100.00','336000','0','0','17800','1050000','0','0','0','1050000','SAL','00044583','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFAH-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.290',berat_jual_asli=berat_jual_asli+'3.290',stock_jual='1',berat_akhir=berat_akhir-'3.290',berat_akhir_asli=berat_akhir_asli-'3.290',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSPRT-ZFAH-70-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-260621-0001','2026-06-21','3.290','2026-06-21','10:57:18','PLG0012294','1050000','1050000','0','1050000','0','kasirbip','2026-06-21 10:57:17','FJ-260621-0001','DP-02449','1050000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','FJ-260621-0001','2026-06-21','10:57:18','SAL','1050000','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-260621-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-21 ','11:13:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-21 ','11:49:03');
UPDATE tt_service_head SET tgl_selesai='2026-06-21',  status ='DONE' WHERE no_service='SV-02131';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02131';
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-06-21',  status ='CLOS' WHERE no_service='SV-02131';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02131';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-21 ','12:31:26');
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-02579','ELLA','1','GOLD','WEDDING RING','','','2.000','','375.00','1','2470000','1500000','0','750000','3750000','SIZE 14 GRF SAPTORI','CROM PUIH GLOSY','ZIRKON 1 BUTIR','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-260621-0001','2026-06-21','2026-06-21 12:36:10','PESANAN : DP-02579','.','TBC','3000000','3000000');
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-260621-0002','D','2026-06-21','12:36:10','TBC','PESANAN','DP-02579','23952899014','3000000','23955899014','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-02579','2026-06-21','2026-06-21','12:36:10','PLG0012295','ELLA','2026-07-21','kasir','2026-06-21 12:36:10','2.000','0','0','0','3000000','0','750000','3750000','3750000','750000');
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-02580','ELLA','1','PLD','WEDDING RING','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','SIZE 18 5 GRF SYAPIRA','CROMPUTIH DOFF SEMPROT','TANPA MATA SESUAI MODEL','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-260621-0002','2026-06-21','2026-06-21 12:39:14','PESANAN : DP-02580','.','TBC','1720000','1720000');
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-260621-0003','D','2026-06-21','12:39:14','TBC','PESANAN','DP-02580','23955899014','1720000','23957619014','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-02580','2026-06-21','2026-06-21','12:39:14','PLG0012296','ELLA','2026-07-21','kasir','2026-06-21 12:39:14','4.000','0','0','0','1720000','0','750000','2150000','2150000','430000');
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-02581','SULIS','1','GOLD','WED RING','','','1.500','','37.50','1','2470000','1500000','0','850000','3100000','23 zircon putih glosy sz 9','font brush script grf Triana . . . Raihan','berat akhir jgn jauh dari estimasi','230000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0003','2026-06-21','2026-06-21 12:39:26','PESANAN : DP-02581','.','TBC','2664000','2664000');
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-260621-0004','D','2026-06-21','12:39:26','TBC','PESANAN','DP-02581','23957619014','2664000','23960283014','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-02581','2026-06-21','2026-06-21','12:39:26','PLG0012297','SULIS','2026-07-19','kasirbip','2026-06-21 12:39:26','1.500','0','0','0','2664000','0','850000','3330000','3330000','666000');
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-260621-0002','kasirbip','1',' 700K-16-24','TOKO','BIPPER','PBDG-ZDAX-1-0','CINCIN SILVER 925 ','','3.440','1','100.00','351000','0','0','17800','800000','0','0','0','800000','SAL','00042438','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDAX-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.440',berat_jual_asli=berat_jual_asli+'3.440',stock_jual='1',berat_akhir=berat_akhir-'3.440',berat_akhir_asli=berat_akhir_asli-'3.440',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PBDG-ZDAX-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-260621-0002','2026-06-21','3.440','2026-06-21','12:56:31','PLG0012298','800000','800000','0','800000','0','kasirbip','2026-06-21 12:56:31','FJ-260621-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','FJ-260621-0002','2026-06-21','12:56:31','SAL','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260621-0004','2026-06-21','2026-06-21 12:56:31','PENJUALAN : FJ-260621-0002','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260621-0005','D','2026-06-21','12:56:31','TBC','PENJUALAN','FJ-260621-0002','23960283014','800000','23961083014','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='800000' WHERE no_faktur_jual='FJ-260621-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260621-0003','kasirbip',' 1',' 800K-13-23','TOKO','BIPPER','PBDG-ZDXG-16-0','CINCIN SILVER 925 ','','2.890','1','100.00','295000','0','0','17800','900000','0','0','0','900000','SAL','00042331','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDXG-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.890',berat_jual_asli=berat_jual_asli+'2.890',stock_jual='1',berat_akhir=berat_akhir-'2.890',berat_akhir_asli=berat_akhir_asli-'2.890',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PBDG-ZDXG-16-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-260621-0003','2026-06-21','2.890','2026-06-21','12:56:31','PLG0012299','900000','900000','0','900000','0','kasirbip','2026-06-21 12:56:31','FJ-260621-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','FJ-260621-0003','2026-06-21','12:56:31','SAL','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-260621-0005','2026-06-21','2026-06-21 12:56:31','PENJUALAN : FJ-260621-0003','.','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260621-0006','D','2026-06-21','12:56:31','TBC','PENJUALAN','FJ-260621-0003','23961083014','900000','23961983014','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-260621-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-260621-0004','kasirbip','1',' DP-02117BI','TOKO','BIPPSN','PSPLT-ZFXA-24-0','CINCIN PALADIUM ','','2.930','1','17.00','658000','0','0','17800','1629000','0','0','0','1629000','SAL','00043904','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFXA-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.930',berat_jual_asli=berat_jual_asli+'2.930',stock_jual='1',berat_akhir=berat_akhir-'2.930',berat_akhir_asli=berat_akhir_asli-'2.930',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSPLT-ZFXA-24-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-260621-0004','2026-06-21','2.930','2026-06-21','13:54:38','PLG0012300','1629000','1629000','0','1629000','0','kasirbip','2026-06-21 13:54:37','FJ-260621-0004','DP-02117','1680000');
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-06-21','FJ-260621-0004','2026-06-21','13:54:38','SAL','1629000','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-260621-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260621-0005','kasirbip',' 1',' DP-02116BI','TOKO','BIPPSN','PSPLT-ZEBE-14-0','CINCIN PALADIUM ','','1.770','1','17.00','398000','0','0','17800','1281000','0','0','0','1281000','SAL','00043775','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBE-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSPLT-ZEBE-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-260621-0005','2026-06-21','1.770','2026-06-21','13:54:38','PLG0012301','1281000','1281000','0','1281000','0','kasirbip','2026-06-21 13:54:37','FJ-260621-0004','DP-02116','1080000');
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-06-21','FJ-260621-0005','2026-06-21','13:54:38','SAL','1281000','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-260621-0006','2026-06-21','2026-06-21 13:54:37','PENJUALAN : FJ-260621-0005','.','TBC','201000','201000','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-260621-0007','D','2026-06-21','13:54:38','TBC','PENJUALAN','FJ-260621-0005','23961983014','201000','23962184014','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='201000' WHERE no_faktur_jual='FJ-260621-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0005';
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-02582','KUR','1','PER','CINCIN KAWIN','','','4.000','','925.00','1','100000','0','925000','0','925000','size 16 grf Desty font berkshire swash','putih kilat kombinasi roshgold lebar 4mm','matasirkon 8','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-260621-0007','2026-06-21','2026-06-21 14:37:56','PESANAN : DP-02582','.','TBC','925000','925000');
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-260621-0008','D','2026-06-21','14:37:56','TBC','PESANAN','DP-02582','23962184014','925000','23963109014','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-02582','2026-06-21','2026-06-21','14:37:56','PLG0012302','KUR','2026-07-11','kasirbip','2026-06-21 14:37:56','4.000','0','0','0','925000','0','0','925000','925000','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-02583','KUR','1','PER','CIN CIN KAWIN','','','3.000','','925.00','1','100000','0','925000','0','925000','size 14 grf Mardian font berkshire swash','putih kilat kombinasi roshgold lebar 3mm','sirkon 8','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-260621-0008','2026-06-21','2026-06-21 14:43:33','PESANAN : DP-02583','.','TBC','925000','925000');
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-260621-0009','D','2026-06-21','14:43:33','TBC','PESANAN','DP-02583','23963109014','925000','23964034014','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-02583','2026-06-21','2026-06-21','14:43:33','PLG0012303','KUR','2026-07-11','kasirbip','2026-06-21 14:43:33','3.000','0','0','0','925000','0','0','925000','925000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-21 ','14:52:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-21 ','14:52:56');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-21 ','14:57:10');
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-02584','VAN','1','PER','WEDDRING WANITA','','','2.000','','925.00','1','100000','0','950000','0','950000','PERMATA MENYESUAIKAN','SIZE: 13.5 GRF: ?? Fahmi ?? VINTAGE ROTTER','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-260621-0009','2026-06-21','2026-06-21 15:00:00','PESANAN : DP-02584','-','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-260621-0010','D','2026-06-21','15:00:00','TBC','PESANAN','DP-02584','23964034014','950000','23964984014','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-02584','2026-06-21','2026-06-21','15:00:00','PLG0012304','VAN','2026-07-16','sby','2026-06-21 15:00:00','2.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-02585','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','850000','0','850000','PERMATA 1','SIZE: 15.5 GRF: ?? Nida ?? VINTAGE ROTTER','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-260621-0010','2026-06-21','2026-06-21 15:02:38','PESANAN : DP-02585','-','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-260621-0011','D','2026-06-21','15:02:38','TBC','PESANAN','DP-02585','23964984014','850000','23965834014','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-02585','2026-06-21','2026-06-21','15:02:38','PLG0012305','VAN','2026-07-16','sby','2026-06-21 15:02:38','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260621-0006','sby','1',' DP-02242SB','TOKO','SBYPSN','PSPLT-ZFAI-10-0','CINCIN PALADIUM ','','4.620','1','32.00','1952000','0','0','17800','3341000','0','0','0','3341000','VAN','00044598','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFAI-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.620',berat_jual_asli=berat_jual_asli+'4.620',stock_jual='1',berat_akhir=berat_akhir-'4.620',berat_akhir_asli=berat_akhir_asli-'4.620',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSPLT-ZFAI-10-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-260621-0006','2026-06-21','4.620','2026-06-21','15:17:29','PLG0012306','3341000','3341000','0','3341000','0','sby','2026-06-21 15:17:29','FJ-260621-0006','DP-02242','2400000');
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-06-21','FJ-260621-0006','2026-06-21','15:17:29','VAN','3341000','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-260621-0011','2026-06-21','2026-06-21 15:17:29','PENJUALAN : FJ-260621-0006','','TBC','941000','941000','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-260621-0012','D','2026-06-21','15:17:29','TBC','PENJUALAN','FJ-260621-0006','23965834014','941000','23966775014','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='941000' WHERE no_faktur_jual='FJ-260621-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0006';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260621-0007','kasirbip','1',' 750K-22-27','TOKO','BIPPER','PBDG-ZFAF-30-0','CINCIN SILVER 925 ','','4.150','1','100.00','424000','0','0','17800','900000','0','0','0','900000','SULIS','00044460','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZFAF-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.150',berat_jual_asli=berat_jual_asli+'4.150',stock_jual='1',berat_akhir=berat_akhir-'4.150',berat_akhir_asli=berat_akhir_asli-'4.150',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PBDG-ZFAF-30-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-260621-0007','2026-06-21','4.150','2026-06-21','15:24:02','PLG0012307','900000','900000','0','900000','0','kasirbip','2026-06-21 15:24:02','FJ-260621-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','FJ-260621-0007','2026-06-21','15:24:02','SULIS','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-260621-0012','2026-06-21','2026-06-21 15:24:02','PENJUALAN : FJ-260621-0007','.','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-260621-0013','D','2026-06-21','15:24:02','TBC','PENJUALAN','FJ-260621-0007','23966775014','900000','23967675014','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-260621-0007' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260621-0008','kasirbip',' 1',' 850K-11-26','TOKO','BIPPER','PBDG-ZFXD-31-0','CINCIN SILVER 925 ','','1.570','1','100.00','161000','0','0','17800','900000','0','0','0','900000','SULIS','00043973','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZFXD-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PBDG-ZFXD-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-260621-0008','2026-06-21','1.570','2026-06-21','15:24:02','PLG0012308','900000','900000','0','900000','0','kasirbip','2026-06-21 15:24:02','FJ-260621-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','FJ-260621-0008','2026-06-21','15:24:02','SULIS','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-260621-0013','2026-06-21','2026-06-21 15:24:02','PENJUALAN : FJ-260621-0008','.','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-260621-0014','D','2026-06-21','15:24:02','TBC','PENJUALAN','FJ-260621-0008','23967675014','900000','23968575014','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-260621-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0008';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-06-21 ','15:28:14');
UPDATE tm_user SET nama_lkp='b',pass_key='579',type='OWN' WHERE user_id='b';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-21 ','15:33:48');
UPDATE tm_barang SET stock_on_hand='1' WHERE kode_barang='PSPLT-ZEBE-14-0' AND kode_lokasi_toko='BIPPSN' LIMIT 1;
UPDATE tt_jual_sales SET jml_jual_rp =jml_jual_rp-'1281000',ongkos_rp=ongkos_rp-'0' WHERE no_faktur_jual ='FJ-260621-0005';
UPDATE tt_jual_head SET status_return = 'CLOS' WHERE no_faktur_jual ='FJ-260621-0005';
UPDATE tt_barang_tukar SET status='CLOS' WHERE no_faktur_group='FJ-260621-0004';
UPDATE tt_voucher_customer SET status='OPEN' WHERE no_voucher='-'
UPDATE tt_barang_saldo SET stock_jual=stock_jual-1, berat_jual = berat_jual-'1.77',berat_jual_asli = berat_jual_asli-'1.77', stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.77',berat_akhir_asli=berat_akhir_asli+'1.77' WHERE tanggal ='2026-06-21' AND kode_lokasi_toko ='BIPPSN' AND kode_barang='PSPLT-ZEBE-14-0' AND stock_jual*1 > 0 LIMIT 1;
INSERT INTO tt_jual_retur_detail(no_retur_jual,no_urut,no_faktur_jual,kode_barang,nama_barang,berat,harga,ongkos,jml_detail,kode_lokasi_toko,kode_dept,kadar,sales_id,alasan,harga_atribut) VALUES ('BJ-260621-0001','1','FJ-260621-0005','PSPLT-ZEBE-14-0','CINCIN PALADIUM ','1.77','1281000.00','0','1281000','BIPPSN','PSPLT','17.00','kasirbip','SALAH INPUT','0');
DELETE FROM tt_jual_head WHERE no_faktur_jual ='FJ-260621-0005' LIMIT 1;
DELETE FROM tt_jual_detail WHERE no_faktur_jual ='FJ-260621-0005' LIMIT 1;
DELETE FROM tt_jual_sales WHERE no_faktur_jual ='FJ-260621-0005' LIMIT 1;
INSERT INTO tt_jual_retur_head(no_retur_jual,tgl_system,tgl_retur_jual,kode_customer,dpp_netto_rp,jml_retur_rp,input_by,input_date)VALUES('BJ-260621-0001','2026-06-21','2026-06-21','PLG0012301','1281000','1281000','kasirbip','2026-06-21 15:37:00');
UPDATE tm_barang SET stock_on_hand='1' WHERE kode_barang='PSPLT-ZFXA-24-0' AND kode_lokasi_toko='BIPPSN' LIMIT 1;
UPDATE tt_jual_sales SET jml_jual_rp =jml_jual_rp-'1629000',ongkos_rp=ongkos_rp-'0' WHERE no_faktur_jual ='FJ-260621-0004';
UPDATE tt_jual_head SET status_return = 'CLOS' WHERE no_faktur_jual ='FJ-260621-0004';
UPDATE tt_barang_tukar SET status='CLOS' WHERE no_faktur_group='FJ-260621-0004';
UPDATE tt_voucher_customer SET status='OPEN' WHERE no_voucher='-'
UPDATE tt_barang_saldo SET stock_jual=stock_jual-1, berat_jual = berat_jual-'2.93',berat_jual_asli = berat_jual_asli-'2.93', stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.93',berat_akhir_asli=berat_akhir_asli+'2.93' WHERE tanggal ='2026-06-21' AND kode_lokasi_toko ='BIPPSN' AND kode_barang='PSPLT-ZFXA-24-0' AND stock_jual*1 > 0 LIMIT 1;
INSERT INTO tt_jual_retur_detail(no_retur_jual,no_urut,no_faktur_jual,kode_barang,nama_barang,berat,harga,ongkos,jml_detail,kode_lokasi_toko,kode_dept,kadar,sales_id,alasan,harga_atribut) VALUES ('BJ-260621-0002','1','FJ-260621-0004','PSPLT-ZFXA-24-0','CINCIN PALADIUM ','2.93','1629000.00','0','1629000','BIPPSN','PSPLT','17.00','kasirbip','SALAH INPUT','0');
DELETE FROM tt_jual_head WHERE no_faktur_jual ='FJ-260621-0004' LIMIT 1;
DELETE FROM tt_jual_detail WHERE no_faktur_jual ='FJ-260621-0004' LIMIT 1;
DELETE FROM tt_jual_sales WHERE no_faktur_jual ='FJ-260621-0004' LIMIT 1;
INSERT INTO tt_jual_retur_head(no_retur_jual,tgl_system,tgl_retur_jual,kode_customer,dpp_netto_rp,jml_retur_rp,input_by,input_date)VALUES('BJ-260621-0002','2026-06-21','2026-06-21','PLG0012300','1629000','1629000','kasirbip','2026-06-21 15:37:00');
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-260621-0009','kasirbip','1',' DP-02116BI','TOKO','BIPPSN','PSPLT-ZEBE-14-0','CINCIN PALADIUM ','','1.770','1','17.00','398000','0','0','17800','1551000','0','0','0','1551000','SAL','00043775','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBE-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSPLT-ZEBE-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-260621-0009','2026-06-21','1.770','2026-06-21','15:39:39','PLG0012309','1551000','1551000','0','1551000','0','kasirbip','2026-06-21 15:39:39','FJ-260621-0009','DP-02116','1080000');
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-06-21','FJ-260621-0009','2026-06-21','15:39:39','SAL','1551000','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-260621-0009' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260621-0010','kasirbip',' 1',' DP-02117BI','TOKO','BIPPSN','PSPLT-ZFXA-24-0','CINCIN PALADIUM ','','2.930','1','17.00','658000','0','0','17800','1629000','0','0','0','1629000','SAL','00043904','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFXA-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.930',berat_jual_asli=berat_jual_asli+'2.930',stock_jual='1',berat_akhir=berat_akhir-'2.930',berat_akhir_asli=berat_akhir_asli-'2.930',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSPLT-ZFXA-24-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-260621-0010','2026-06-21','2.930','2026-06-21','15:39:39','PLG0012310','1629000','1629000','0','1629000','0','kasirbip','2026-06-21 15:39:39','FJ-260621-0009','DP-02117','1680000');
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-06-21','FJ-260621-0010','2026-06-21','15:39:39','SAL','1629000','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-260621-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0010';
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-260621-0011','sby','1',' DP-02295SB','TOKO','SBYPSN','PSPLT-ZFAH-73-0','CINCIN PALADIUM ','','1.750','1','17.00','365000','0','0','17800','1603000','0','0','0','1603000','DIL','00044586','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFAH-73-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-06-21' AND kode_barang='PSPLT-ZFAH-73-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-260621-0011','2026-06-21','1.750','2026-06-21','16:50:52','PLG0012311','1603000','1603000','0','1603000','0','sby','2026-06-21 16:50:51','FJ-260621-0011','DP-02295','1300000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','FJ-260621-0011','2026-06-21','16:50:52','DIL','1603000','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-260621-0014','2026-06-21','2026-06-21 16:50:51','PENJUALAN : FJ-260621-0011','','TBC','303000','303000','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-260621-0015','D','2026-06-21','16:50:52','TBC','PENJUALAN','FJ-260621-0011','23968575014','303000','23968878014','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='303000' WHERE no_faktur_jual='FJ-260621-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-260621-0012','sby',' 1',' DP-02296SB','TOKO','SBYPSN','PSPLT-ZFAI-11-0','CINCIN PALADIUM ','','3.480','1','17.00','781000','0','0','17800','1968000','0','0','0','1968000','DIL','00044599','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFAI-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.480',berat_jual_asli=berat_jual_asli+'3.480',stock_jual='1',berat_akhir=berat_akhir-'3.480',berat_akhir_asli=berat_akhir_asli-'3.480',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSPLT-ZFAI-11-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-260621-0012','2026-06-21','3.480','2026-06-21','16:50:52','PLG0012312','1968000','1968000','0','1968000','0','sby','2026-06-21 16:50:51','FJ-260621-0011','DP-02296','1300000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','FJ-260621-0012','2026-06-21','16:50:52','DIL','1968000','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-260621-0015','2026-06-21','2026-06-21 16:50:51','PENJUALAN : FJ-260621-0012','','TBC','668000','668000','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-260621-0016','D','2026-06-21','16:50:52','TBC','PENJUALAN','FJ-260621-0012','23968878014','668000','23969546014','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='971000' WHERE no_faktur_jual='FJ-260621-0012' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260621-0013','kasirbip','1',' DP-02312BI','TOKO','BIPPSN','PSGT-ZFAG-25-0','CINCIN EMAS ','','2.520','1','83.00','5185000','0','0','17800','6998000','0','0','0','6998000','SAL','00044511','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFAG-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSGT-ZFAG-25-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-260621-0013','2026-06-21','2.520','2026-06-21','17:00:59','PLG0012313','6998000','6998000','0','6998000','0','kasirbip','2026-06-21 17:00:58','FJ-260621-0013','DP-02312','5560000');
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-06-21','FJ-260621-0013','2026-06-21','17:00:59','SAL','6998000','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-260621-0016','2026-06-21','2026-06-21 17:00:58','PENJUALAN : FJ-260621-0013','.','TBC','1438000','1438000','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-260621-0017','D','2026-06-21','17:00:59','TBC','PENJUALAN','FJ-260621-0013','23969546014','1438000','23970984014','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='1438000' WHERE no_faktur_jual='FJ-260621-0013' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260621-0014','kasirbip',' 1',' DP-02311BI','TOKO','BIPPSN','PSPLT-ZFAB-4-0','CINCIN PALADIUM ','','2.000','1','17.00','450000','0','0','17800','1400000','0','0','0','1400000','SAL','00044328','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFAB-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSPLT-ZFAB-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-260621-0014','2026-06-21','2.000','2026-06-21','17:00:59','PLG0012314','1400000','1400000','0','1400000','0','kasirbip','2026-06-21 17:00:58','FJ-260621-0013','DP-02311','1120000');
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-06-21','FJ-260621-0014','2026-06-21','17:00:59','SAL','1400000','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-260621-0017','2026-06-21','2026-06-21 17:00:58','PENJUALAN : FJ-260621-0014','.','TBC','280000','280000','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-260621-0018','D','2026-06-21','17:00:59','TBC','PENJUALAN','FJ-260621-0014','23970984014','280000','23971264014','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='1718000' WHERE no_faktur_jual='FJ-260621-0014' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-21 ','17:02:51');
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-02586','VAN','1','PLD','WEDDRING PRIA','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','PERMATA 1','SIZE: 23 GRF: Maydina FONT: BERKSHIRE','FINISHING : PUTIH DOFF MIX GLOSSY','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0018','2026-06-21','2026-06-21 17:06:32','PESANAN : DP-02586','-','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-260621-0019','D','2026-06-21','17:06:32','TBC','PESANAN','DP-02586','23971264014','1500000','23972764014','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-02586','2026-06-21','2026-06-21','17:06:32','PLG0012315','VAN','2026-07-16','sby','2026-06-21 17:06:32','4.000','0','0','0','1500000','0','750000','2160000','2160000','660000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02137','SULIS','1','SEPASANG SILVER','CWE SZ 13 PUTIH GLOSY CWO SZ 15 PUTIH DOFF AMPLASS GRF JGN HILANG','3.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02137','2026-06-21','2026-06-21','17:13:04','PLG0012316','kasirbip','2026-09-05','kasirbip','2026-06-21 17:13:04','3.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-21 ','17:13:28');
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-02587','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','950000','0','950000','cwo YL-01 sz 12 grf Syifa Firza','cwe SR-05 sz 9.5 grf Suci SR . . .','font vintage rotter model sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0019','2026-06-21','2026-06-21 17:58:43','PESANAN : DP-02587','.','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-260621-0020','D','2026-06-21','17:58:43','TBC','PESANAN','DP-02587','23972764014','950000','23973714014','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-02587','2026-06-21','2026-06-21','17:58:43','PLG0012317','SAL','2026-07-06','kasirbip','2026-06-21 17:58:43','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-02588','DIL','1','PLD','WEDD RING WANITA','','','2.500','','25.00','1','1200000','550000','0','800000','2175000','PERMATA 5 BUTIR','SIZE 12 GRF: San ?? Sam (vintage)','crom putih glossy','50000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0020','2026-06-21','2026-06-21 18:11:56','PESANAN : DP-02588','-','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-260621-0021','D','2026-06-21','18:11:56','TBC','PESANAN','DP-02588','23973714014','1500000','23975214014','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-02588','2026-06-21','2026-06-21','18:11:56','PLG0012318','DIL','2026-07-16','sby','2026-06-21 18:11:56','2.500','0','0','0','1500000','0','800000','2225000','2225000','725000');
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-260621-0015','kasir','1',' 1.050K-14-','TOKO','MMPER','LXPER-ZBBD-32-0','CINCIN SILVER 925 ','','1.340','1','100.00','137000','0','0','17800','1150000','0','0','0','1150000','ELLA','00041778','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBBD-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='LXPER-ZBBD-32-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-260621-0015','2026-06-21','1.340','2026-06-21','18:17:00','PLG0012319','1150000','1150000','0','1150000','0','kasir','2026-06-21 18:17:00','FJ-260621-0015','','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-06-21','FJ-260621-0015','2026-06-21','18:17:00','ELLA','1150000','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-260621-0021','2026-06-21','2026-06-21 18:17:00','PENJUALAN : FJ-260621-0015','0','TBC','1150000','1150000','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-260621-0022','D','2026-06-21','18:17:00','TBC','PENJUALAN','FJ-260621-0015','23975214014','1150000','23976364014','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='1150000' WHERE no_faktur_jual='FJ-260621-0015' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260621-0016','kasir',' 1',' 750K-20-10','TOKO','MMPER','PMM-ZFAG-5-0','CINCIN SILVER 925 ','','3.220','1','100.00','329000','0','0','17800','900000','0','0','0','900000','ELLA','00044491','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZFAG-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.220',berat_jual_asli=berat_jual_asli+'3.220',stock_jual='1',berat_akhir=berat_akhir-'3.220',berat_akhir_asli=berat_akhir_asli-'3.220',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PMM-ZFAG-5-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-260621-0016','2026-06-21','3.220','2026-06-21','18:17:00','PLG0012320','900000','900000','0','900000','0','kasir','2026-06-21 18:17:00','FJ-260621-0015','','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-06-21','FJ-260621-0016','2026-06-21','18:17:00','ELLA','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-260621-0022','2026-06-21','2026-06-21 18:17:00','PENJUALAN : FJ-260621-0016','0','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-260621-0023','D','2026-06-21','18:17:00','TBC','PENJUALAN','FJ-260621-0016','23976364014','900000','23977264014','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='2050000' WHERE no_faktur_jual='FJ-260621-0016' 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-02589','ALIKA','1','PER','CINCIN PROMO CM02 SLV','','','4.000','','925.00','1','100000','0','0','0','1200000','CEWE SIZE 12 GRF FAHMI ZIRKON 1 BUTIR','COWOK SIZE 14 GRF GIYAN','CROM PUTIH DOFF AMPLAS','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-260621-0023','2026-06-21','2026-06-21 18:27:04','PESANAN : DP-02589','.','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-260621-0024','D','2026-06-21','18:27:04','TBC','PESANAN','DP-02589','23977264014','1200000','23978464014','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-02589','2026-06-21','2026-06-21','18:27:04','PLG0012321','ALIKA','2026-07-21','kasir','2026-06-21 18:27:04','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-02590','DIL','1','PER','WEDD RING CUSTOM','','','3.000','','925.00','1','100000','0','950000','0','950000','PERMATA 1 BUTIR . REQ LEBAR 4MM','SIZE 16 GRF : Fiya (infinity) Ajib (yaseva)','crom putih doff mix glossy','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0024','2026-06-21','2026-06-21 18:40:53','PESANAN : DP-02590','-','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-260621-0025','D','2026-06-21','18:40:53','TBC','PESANAN','DP-02590','23978464014','950000','23979414014','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-02590','2026-06-21','2026-06-21','18:40:53','PLG0012322','DIL','2026-07-16','sby','2026-06-21 18:40:53','3.000','0','0','0','950000','0','0','950000','950000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0016';
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-02591','SULIS','1','GOLD','WED RING','','','3.000','','75.00','1','2470000','2400000','0','850000','8050000','5 zircon sz 14 putih glosy','font vintage rotter grf Indah . . . Steven','berat akhir jgn lebih dr 3 gr model spt contoh','50000','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0025','2026-06-21','2026-06-21 19:05:21','PESANAN : DP-02591','.','TBC','6480000','6480000');
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-260621-0026','D','2026-06-21','19:05:21','TBC','PESANAN','DP-02591','23979414014','6480000','23985894014','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-02591','2026-06-21','2026-06-21','19:05:21','PLG0012323','SULIS','2026-07-21','kasirbip','2026-06-21 19:05:21','3.000','0','0','0','6480000','0','850000','8100000','8100000','1620000');
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-02592','SULIS','1','PLD','WED RING','','','4.000','','10.00','1','1200000','350000','0','850000','2250000','sz 31.5 putih glosy MODEL TANPA MATA','Font vintage rotter grf Indah . . . Steven','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0026','2026-06-21','2026-06-21 19:08:37','PESANAN : DP-02592','.','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-260621-0027','D','2026-06-21','19:08:37','TBC','PESANAN','DP-02592','23985894014','1800000','23987694014','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-02592','2026-06-21','2026-06-21','19:08:37','PLG0012324','SULIS','2026-07-21','kasirbip','2026-06-21 19:08:37','4.000','0','0','0','1800000','0','850000','2250000','2250000','450000');
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-260621-0017','kasirbip','1',' DP-02219DU','TOKO','DUPSN','PSPRT-ZFXD-8-0','CINCIN PERAK YL-10 ','','5.310','1','100.00','542000','0','0','17800','850000','0','0','0','850000','PUT','00043950','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFXD-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.310',berat_jual_asli=berat_jual_asli+'5.310',stock_jual='1',berat_akhir=berat_akhir-'5.310',berat_akhir_asli=berat_akhir_asli-'5.310',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSPRT-ZFXD-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260621-0017','2026-06-21','5.310','2026-06-21','19:16:55','PLG0012325','850000','850000','0','850000','0','kasirbip','2026-06-21 19:16:55','FJ-260621-0017','DP-02219','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-06-21','FJ-260621-0017','2026-06-21','19:16:55','PUT','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-260621-0017' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260621-0018','kasirbip',' 1',' DP-02220DU','TOKO','DUPSN','PSPRT-ZFAH-2-0','CINCIN PERAK ','','2.410','1','100.00','246000','0','0','17800','1050000','0','0','0','1050000','PUT','00044515','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFAH-2-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-06-21' AND kode_barang='PSPRT-ZFAH-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260621-0018','2026-06-21','2.410','2026-06-21','19:16:55','PLG0012326','1050000','1050000','0','1050000','0','kasirbip','2026-06-21 19:16:55','FJ-260621-0017','DP-02220','1050000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','FJ-260621-0018','2026-06-21','19:16:55','PUT','1050000','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-260621-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0002';
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-260621-0002','K','2026-06-21','19:29:39','kasir','BELANJA','BELI PEMBERSIH KACA','3924200','46500','3877700');
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-260621-0019','kasirbip','1',' PLBDG-0016','TOKO','BIPPLD','PLBDG-ZEAD-9-0','CINCIN PALADIUM PLBDG-00162 ','','2.560','1','17.00','575000','0','0','17800','1796000','0','0','0','1796000','SAL','00043567','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZEAD-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.560',berat_jual_asli=berat_jual_asli+'2.560',stock_jual='1',berat_akhir=berat_akhir-'2.560',berat_akhir_asli=berat_akhir_asli-'2.560',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PLBDG-ZEAD-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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-260621-0019','2026-06-21','2.560','2026-06-21','19:53:10','PLG0012327','1796000','1796000','0','1796000','0','kasirbip','2026-06-21 19:53:09','FJ-260621-0019','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','FJ-260621-0019','2026-06-21','19:53:10','SAL','1796000','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-260621-0027','2026-06-21','2026-06-21 19:53:09','PENJUALAN : FJ-260621-0019','.','TBC','1796000','1796000','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-260621-0028','D','2026-06-21','19:53:10','TBC','PENJUALAN','FJ-260621-0019','23987694014','1796000','23989490014','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='1796000' WHERE no_faktur_jual='FJ-260621-0019' 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-02138','SAL','1','CINCIN PALLADIUM','FONT BERKSHIRE SWASH GRF','2.560','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02138','2026-06-21','2026-06-21','19:55:09','PLG0012328','kasirbip','2026-06-22','kasirbip','2026-06-21 19:55:09','2.560','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-21 ','19:55:26');
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-02593','SAL','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','900000','1600000','sz 13.5 putih glosy 17 zirkon','font berkshire swash grf Andrianto Adi . . .','EXPRESS 100.000','170000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0028','2026-06-21','2026-06-21 19:58:03','PESANAN : DP-02593','.','TBC','1416000','1416000');
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-260621-0029','D','2026-06-21','19:58:03','TBC','PESANAN','DP-02593','23989490014','1416000','23990906014','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-02593','2026-06-21','2026-06-21','19:58:03','PLG0012329','SAL','2026-07-05','kasirbip','2026-06-21 19:58:03','2.000','0','0','0','1416000','0','900000','1770000','1770000','354000');
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-02594','SULIS','1','GOLD','WED RING','','','3.000','','75.00','1','2470000','2400000','0','800000','8000000','SZ 15.5 PUTIH DOFF SEMPROT 1 ZIRCON','FONT BERKSHIRE SEASH GRF Dafa','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0029','2026-06-21','2026-06-21 20:00:40','PESANAN : DP-02594','.','TBC','6400000','6400000');
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-260621-0030','D','2026-06-21','20:00:40','TBC','PESANAN','DP-02594','23990906014','6400000','23997306014','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-02594','2026-06-21','2026-06-21','20:00:40','PLG0012330','SULIS','2026-07-19','kasirbip','2026-06-21 20:00:40','3.000','0','0','0','6400000','0','800000','8000000','8000000','1600000');
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-02595','ELLA','1','PER','CINCIN PROMO CP08','','','4.000','','925.00','1','100000','0','0','0','1600000','CEWE SIZE 13 5 CROM PUTIH','ZIRKON 21 BUTIR','COWO SIZE 20 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-260621-0030','2026-06-21','2026-06-21 20:05:30','PESANAN : DP-02595','.','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-260621-0031','D','2026-06-21','20:05:30','TBC','PESANAN','DP-02595','23997306014','1600000','23998906014','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-02595','2026-06-21','2026-06-21','20:05:30','PLG0012331','ELLA','2026-07-21','kasir','2026-06-21 20:05:30','4.000','0','0','0','1600000','0','0','1600000','1600000','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-260621-0020','kasirbip','1',' DP-02392BI','TOKO','BIPPSN','PSPLT-ZFAI-16-0','CINCIN PALADIUM ','','3.180','1','17.00','714000','0','0','17800','1913000','0','0','0','1913000','SULIS','00044604','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFAI-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSPLT-ZFAI-16-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-260621-0020','2026-06-21','3.180','2026-06-21','20:08:06','PLG0012332','1913000','1913000','0','1913000','0','kasirbip','2026-06-21 20:08:05','FJ-260621-0020','DP-02392','1620000');
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-06-21','FJ-260621-0020','2026-06-21','20:08:06','SULIS','1913000','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-260621-0031','2026-06-21','2026-06-21 20:08:05','PENJUALAN : FJ-260621-0020','.','TBC','293000','293000','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-260621-0032','D','2026-06-21','20:08:06','TBC','PENJUALAN','FJ-260621-0020','23998906014','293000','23999199014','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='293000' WHERE no_faktur_jual='FJ-260621-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-260621-0021','kasirbip',' 1',' DP-02391BI','TOKO','BIPPSN','PSPLT-ZFAI-15-0','CINCIN PALADIUM ','','3.090','1','17.00','694000','0','0','17800','1881500','0','0','0','1881500','SULIS','00044603','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFAI-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.090',berat_jual_asli=berat_jual_asli+'3.090',stock_jual='1',berat_akhir=berat_akhir-'3.090',berat_akhir_asli=berat_akhir_asli-'3.090',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSPLT-ZFAI-15-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-260621-0021','2026-06-21','3.090','2026-06-21','20:08:06','PLG0012333','1881500','1881500','0','1881500','0','kasirbip','2026-06-21 20:08:05','FJ-260621-0020','DP-02391','1620000');
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-06-21','FJ-260621-0021','2026-06-21','20:08:06','SULIS','1881500','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-260621-0032','2026-06-21','2026-06-21 20:08:05','PENJUALAN : FJ-260621-0021','.','TBC','261500','261500','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-260621-0033','D','2026-06-21','20:08:06','TBC','PENJUALAN','FJ-260621-0021','23999199014','261500','23999460514','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='554500' WHERE no_faktur_jual='FJ-260621-0021' 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-02596','ELLA','1','GOLD','WEDDING RING','','','2.500','','375.00','1','2470000','1500000','0','900000','4650000','SIZE 13.5','WARNA PUTIH GLOSY','ZIRCONE 21 BUTIR','0','0','210000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0033','2026-06-21','2026-06-21 20:14:21','PESANAN : DP-02596','0','TBC','3888000','3888000');
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-260621-0034','D','2026-06-21','20:14:21','TBC','PESANAN','DP-02596','23999460514','3888000','24003348514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02596','2026-06-21','2026-06-21','20:14:21','PLG0012334','ELLA','2026-07-21','kasir','2026-06-21 20:14:21','2.500','0','0','0','3888000','0','900000','4860000','4860000','972000');
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-02597','DIL','1','PER','WEDD RING PRIA','','','2.000','','925.00','1','100000','0','850000','0','850000','permata 1 butir','size 21 grf : Ira (infinity) (berkshire)','crom putih doff mix glossy','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0034','2026-06-21','2026-06-21 20:14:39','PESANAN : DP-02597','-','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-260621-0035','D','2026-06-21','20:14:39','TBC','PESANAN','DP-02597','24003348514','850000','24004198514','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-02597','2026-06-21','2026-06-21','20:14:39','PLG0012335','DIL','2026-07-18','sby','2026-06-21 20:14:39','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02598','ELLA','1','PLD','WEDDING RING','','','6.000','','10.00','1','1200000','350000','0','850000','2950000','SIZE 20','WARNA PUTIH DOFF AMPLAS','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0035','2026-06-21','2026-06-21 20:17:42','PESANAN : DP-02598','0','TBC','2360000','2360000');
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-260621-0036','D','2026-06-21','20:17:42','TBC','PESANAN','DP-02598','24004198514','2360000','24006558514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02598','2026-06-21','2026-06-21','20:17:42','PLG0012336','ELLA','2026-07-21','kasir','2026-06-21 20:17:42','6.000','0','0','0','2360000','0','850000','2950000','2950000','590000');
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-02599','DIL','1','PER','WEDD RING WANITA','','','1.500','','925.00','1','100000','0','950000','0','950000','size 7.5 grf : Angga (infinity) (berkshire)','crom putih glossy','permata menyesuaikan','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-260621-0036','2026-06-21','2026-06-21 20:17:52','PESANAN : DP-02599','-','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-260621-0037','D','2026-06-21','20:17:52','TBC','PESANAN','DP-02599','24006558514','950000','24007508514','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-02599','2026-06-21','2026-06-21','20:17:52','PLG0012337','DIL','2026-07-18','sby','2026-06-21 20:17:52','1.500','0','0','0','950000','0','0','950000','950000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0021';
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-260621-0022','sby','1',' 750K-16-00','TOKO','SBYPER','PSBY-ZEXE-20-0','CINCIN SILVER 925 ','','2.090','1','100.00','214000','0','0','17800','850000','0','0','0','850000','VAN','00043216','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-20-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-06-21' AND kode_barang='PSBY-ZEXE-20-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-260621-0022','2026-06-21','2.090','2026-06-21','20:38:50','PLG0012338','850000','850000','0','850000','0','sby','2026-06-21 20:38:49','FJ-260621-0022','','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-06-21','FJ-260621-0022','2026-06-21','20:38:50','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-260621-0037','2026-06-21','2026-06-21 20:38:49','PENJUALAN : FJ-260621-0022','','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-260621-0038','D','2026-06-21','20:38:50','TBC','PENJUALAN','FJ-260621-0022','24007508514','850000','24008358514','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-260621-0022' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260621-0023','sby',' 1',' 800K-18-00','TOKO','SBYPER','PSBY-ZEXA-7-0','CINCIN SILVER 925 ','','4.300','1','100.00','439000','0','0','17800','900000','0','0','0','900000','VAN','00043029','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.300',berat_jual_asli=berat_jual_asli+'4.300',stock_jual='1',berat_akhir=berat_akhir-'4.300',berat_akhir_asli=berat_akhir_asli-'4.300',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='PSBY-ZEXA-7-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-260621-0023','2026-06-21','4.300','2026-06-21','20:38:50','PLG0012339','900000','900000','0','900000','0','sby','2026-06-21 20:38:49','FJ-260621-0022','','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-06-21','FJ-260621-0023','2026-06-21','20:38:50','VAN','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260621-0038','2026-06-21','2026-06-21 20:38:49','PENJUALAN : FJ-260621-0023','','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-260621-0039','D','2026-06-21','20:38:50','TBC','PENJUALAN','FJ-260621-0023','24008358514','900000','24009258514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1750000' WHERE no_faktur_jual='FJ-260621-0023' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260621-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260621-0023';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-21 ','20:40: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-02600','DIL','1','PER','WEDD RING PRIA','','','3.000','','925.00','1','100000','0','900000','0','900000','PERMATA 1 BUTIR','SIZE 22 GRF : Farah Citasari (vintage)','crom putih doff mix glossy','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0039','2026-06-21','2026-06-21 20:57:20','PESANAN : DP-02600','-','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-260621-0040','D','2026-06-21','20:57:20','TBC','PESANAN','DP-02600','24009258514','900000','24010158514','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-02600','2026-06-21','2026-06-21','20:57:20','PLG0012340','DIL','2026-07-18','sby','2026-06-21 20:57:20','3.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-21 ','20:57:35');
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-02601','DIL','1','PLD','WEDD RING WANITA','','','2.500','','10.00','1','1200000','350000','0','850000','1725000','PERMATA 7 BUTIR (REQ TENGAH 1 LEBIH KECIL)','SIZE 11 GRF: Rafliansyah P (vintage)','crom putih glossy','70000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260621-0040','2026-06-21','2026-06-21 21:01:39','PESANAN : DP-02601','-','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-260621-0041','D','2026-06-21','21:01:39','TBC','PESANAN','DP-02601','24010158514','1200000','24011358514','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-02601','2026-06-21','2026-06-21','21:01:39','PLG0012341','DIL','2026-07-18','sby','2026-06-21 21:01:39','2.500','0','0','0','1200000','0','850000','1795000','1795000','595000');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-21';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-21';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-21' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260622-0001','D','2026-06-22','21:12:28','TBC','SALDO AWAL','SALDO AWAL','0','24011358514','24011358514');
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-260622-0001','D','2026-06-22','21:12:28','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-260622-0001','D','2026-06-22','21:12:28','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260622-0001','D','2026-06-22','21:12:28','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-260622-0001','D','2026-06-22','21:12:28','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-260622-0001','D','2026-06-22','21:12:28','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-260622-0001','D','2026-06-22','21:12:28','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-260622-0001','D','2026-06-22','21:12:28','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-260622-0001','D','2026-06-22','21:12:28','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-260622-0001','D','2026-06-22','21:12:28','','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-260622-0001','D','2026-06-22','21:12:28','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-260622-0001','D','2026-06-22','21:12:28','BCD','SALDO AWAL','SALDO AWAL','0','1394153500','1394153500');
UPDATE tp_system SET tgl_system='2026-06-22';