INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-28 ','08:19:19');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-28 ','08:35:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-28 ','09:39:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-28 ','09:39:40');
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-260728-0001','kasirbip','1',' DP-02675DU','TOKO','DUPSN','PSPLT-ZGBX-57-0','CINCIN PALADIUM ','','1.320','1','17.00','297000','0','0','17800','1602000','0','0','0','1602000','PUT','00045377','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBX-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PSPLT-ZGBX-57-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-260728-0001','2026-07-28','1.320','2026-07-28','10:28:04','PLG0013692','1602000','1602000','0','1602000','0','kasirbip','2026-07-28 10:28:04','FJ-260728-0001','DP-02675','1472000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0001','2026-07-28','10:28:04','PUT','1602000','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-260728-0001','2026-07-28','2026-07-28 10:28:04','PENJUALAN : FJ-260728-0001','.','TBC','130000','130000','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-260728-0002','D','2026-07-28','10:28:04','TBC','PENJUALAN','FJ-260728-0001','25448909564','130000','25449039564','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='130000' WHERE no_faktur_jual='FJ-260728-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260728-0002','kasirbip',' 1',' DP-02674DU','TOKO','DUPSN','PSPLT-ZGBD-3-0','CINCIN PALADIUM ','','3.020','1','17.00','679000','0','0','17800','1807000','0','0','0','1807000','PUT','00045579','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBD-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PSPLT-ZGBD-3-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-260728-0002','2026-07-28','3.020','2026-07-28','10:28:04','PLG0013693','1807000','1807000','0','1807000','0','kasirbip','2026-07-28 10:28:04','FJ-260728-0001','DP-02674','1580000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0002','2026-07-28','10:28:04','PUT','1807000','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-260728-0002','2026-07-28','2026-07-28 10:28:04','PENJUALAN : FJ-260728-0002','.','TBC','227000','227000','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-260728-0003','D','2026-07-28','10:28:04','TBC','PENJUALAN','FJ-260728-0002','25449039564','227000','25449266564','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='357000' WHERE no_faktur_jual='FJ-260728-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0002';
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-03132','PUT','1','PER','WEDRING PROMO','','','5.000','','925.00','1','100000','0','1400000','0','1400000','sz cwe 8 CP.02','sz cwo 13 CP.02','','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-260728-0003','2026-07-28','2026-07-28 10:53:02','PESANAN : DP-03132','.','TBC','1400000','1400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260728-0004','D','2026-07-28','10:53:02','TBC','PESANAN','DP-03132','25449266564','1400000','25450666564','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-03132','2026-07-28','2026-07-28','10:53:02','PLG0013694','PUT','2026-08-23','kasirbip','2026-07-28 10:53:02','5.000','0','0','0','1400000','0','0','1400000','1400000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-28 ','11:12:54');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260728-0003','kasirbip','1',' DP-03042BI','TOKO','BIPPSN','PSPRT-ZGBD-24-0','CINCIN PERAK SR-03 YL-01 ','','3.100','1','100.00','317000','0','0','17800','950000','0','0','0','950000','KUR','00045600','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBD-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PSPRT-ZGBD-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-260728-0003','2026-07-28','3.100','2026-07-28','11:13:25','PLG0013695','950000','950000','0','950000','0','kasirbip','2026-07-28 11:13:24','FJ-260728-0003','DP-03042','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0003','2026-07-28','11:13:25','KUR','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260728-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0003';
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-260728-0004','kasirbip','1',' DP-02685DU','TOKO','DUPSN','PSPRT-ZGBC-25-0','CINCIN PERAK YL-01 ','','3.200','1','100.00','327000','0','0','17800','850000','0','0','0','850000','PUT','00045572','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBC-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PSPRT-ZGBC-25-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-260728-0004','2026-07-28','3.200','2026-07-28','11:23:22','PLG0013696','850000','850000','0','850000','0','kasirbip','2026-07-28 11:23:21','FJ-260728-0004','DP-02685','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0004','2026-07-28','11:23:22','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-260728-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0004';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-07-28',  status ='CLOS' WHERE no_service='SV-02145';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02145';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-28 ','12:21:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-28 ','12:27:15');
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-03133','VAN','1','GOLD','WEDDRING WANITA','','','2.500','','37.50','1','2280000','1400000','0','850000','4350000','PERMATA 18','SIZE: 12 GRF: Ridwan??','font: vintage emas kuning','180000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260728-0004','2026-07-28','2026-07-28 12:31:40','PESANAN : DP-03133','-','TBC','3100000','3100000');
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-260728-0005','D','2026-07-28','12:31:40','TBC','PESANAN','DP-03133','25450666564','3100000','25453766564','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-03133','2026-07-28','2026-07-28','12:31:40','PLG0013697','VAN','2026-08-23','sby','2026-07-28 12:31:40','2.500','0','0','0','3100000','0','850000','4530000','4530000','1430000');
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-03134','VAN','1','PLD','WEDDRING PRIA','','','4.000','','10.00','1','1200000','350000','0','700000','2100000','SIZE: 15','GRF: Lisfa?? FONT: VINTAGE','PUTIH GLOSSY MIX DOF KUNING','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-260728-0005','2026-07-28','2026-07-28 12:34:14','PESANAN : DP-03134','-','TBC','1400000','1400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260728-0006','D','2026-07-28','12:34:14','TBC','PESANAN','DP-03134','25453766564','1400000','25455166564','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-03134','2026-07-28','2026-07-28','12:34:14','PLG0013698','VAN','2026-08-23','sby','2026-07-28 12:34:14','4.000','0','0','0','1400000','0','700000','2100000','2100000','700000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-28 ','12:57:34');
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-260728-0005','kasir','1',' DP-02680MM','TOKO','MMPSN','PSGT-ZGBD-35-0','CINCIN EMAS ','','1.260','1','83.00','2433000','0','0','17800','4024000','0','0','0','4024000','ELLA','00045611','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGBD-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PSGT-ZGBD-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260728-0005','2026-07-28','1.260','2026-07-28','12:59:53','PLG0013699','4024000','4024000','0','4024000','0','kasir','2026-07-28 12:59:52','FJ-260728-0005','DP-02680','3680000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0005','2026-07-28','12:59:53','ELLA','4024000','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-260728-0006','2026-07-28','2026-07-28 12:59:52','PENJUALAN : FJ-260728-0005','0','TBC','344000','344000','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-260728-0007','D','2026-07-28','12:59:53','TBC','PENJUALAN','FJ-260728-0005','25455166564','344000','25455510564','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='344000' WHERE no_faktur_jual='FJ-260728-0005' 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-03135','DIL','1','PER','WEDD RING PRIA','','','2.000','','925.00','1','100000','0','850000','0','850000','PERMATA 1 BUTIR','SIZE 15.5 GRF: Anifa ?? (VINTAGE)','CROM PUTIH GLOSSY MIX ROSE GOLD GLOSSY (DETAIL WA)','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-260728-0007','2026-07-28','2026-07-28 13:03:29','PESANAN : DP-03135','-','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-260728-0008','D','2026-07-28','13:03:29','TBC','PESANAN','DP-03135','25455510564','850000','25456360564','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-03135','2026-07-28','2026-07-28','13:03:29','PLG0013700','DIL','2026-08-23','sby','2026-07-28 13:03:29','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-28 ','13:42:26');
UPDATE tt_service_head SET tgl_selesai='2026-07-28',  status ='DONE' WHERE no_service='SV-02184';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02184';
UPDATE tt_service_head SET tgl_selesai='2026-07-28',  status ='DONE' WHERE no_service='SV-02187';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02187';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-07-28',  status ='CLOS' WHERE no_service='SV-02184';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02184';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-07-28',  status ='CLOS' WHERE no_service='SV-02187';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02187';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-28 ','14:28:12');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-07-28 ','14:34:24');
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-03136','PUTRIJG','1','GOLD','WEDD RING','','','2.000','','50.00','1','2280000','2000000','','900000','4900000','SIZE CEWEK 11.5','GRAF : Wildan : Vintage Rotter','WARNA PUTIH GLOSSY/MODEL CINCIN SAMPLE SILVER','','','');
INSERT INTO tm_barang_contoh(no_persekot,no_urut,kode_barang,nama_barang,berat,tgl_titip,status) VALUES ('DP-03136','1','','sample silver','','2026-07-28 14:49:35','OPEN');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260728-0008','2026-07-28','2026-07-28 14:49:35','PESANAN : DP-03136','0','TBC','980000','980000');
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-260728-0009','D','2026-07-28','14:49:35','TBC','PESANAN','DP-03136','25456360564','980000','25457340564','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-03136','2026-07-28','2026-07-28','14:49:35','PLG0013701','PUTRIJG','2026-08-17','jogja','2026-07-28 14:49:35','2.000','3920000','0','0','980000','0','900000','4900000','4900000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260728-0002','D','2026-07-28','14:49:35','jogja','PESANAN','DP-03136','652300','3920000','4572300');
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-03137','PUTRIJG','1','PLD','WEDD RING','','','2.500','','10.00','1','1200000','350000','0','500000','1375000','SIZE CWOK : 14','GRAF : Arum : Vintage Rotter','WARNA KRUM /GLOSSY /MODEL CINCIN SAMPLE SILVER','','','');
INSERT INTO tm_barang_contoh(no_persekot,no_urut,kode_barang,nama_barang,berat,tgl_titip,status) VALUES ('DP-03137','1','','SAMPLE SILVER','','2026-07-28 14:54:54','OPEN');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260728-0009','2026-07-28','2026-07-28 14:54:54','PESANAN : DP-03137','0','TBC','275000','275000');
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-260728-0010','D','2026-07-28','14:54:54','TBC','PESANAN','DP-03137','25457340564','275000','25457615564','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-03137','2026-07-28','2026-07-28','14:54:54','PLG0013702','PUTRIJG','2026-08-17','jogja','2026-07-28 14:54:54','2.500','1100000','0','0','275000','0','500000','1375000','1375000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260728-0003','D','2026-07-28','14:54:54','jogja','PESANAN','DP-03137','4572300','1100000','5672300');
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-03138','PUTRIJG','1','GOLD','WEDD RING','','','2.000','','50.00','1','2280000','2000000','','900000','4900000','SIZE CEWEK 11.5','GRAF : Wildan : Vintage Rotter','WARNA GLOSSY/MODEL CINCIN SAMPLE SILVER','','','');
INSERT INTO tm_barang_contoh(no_persekot,no_urut,kode_barang,nama_barang,berat,tgl_titip,status) VALUES ('DP-03138','1','','MOD SILVER','','2026-07-28 14:59:08','OPEN');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03138','2026-07-28','2026-07-28','14:59:08','PLG0013703','PUTRIJG','2026-08-17','jogja','2026-07-28 14:59:08','2.000','3920000','0','0','0','0','900000','4900000','4900000','980000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260728-0004','D','2026-07-28','14:59:08','jogja','PESANAN','DP-03138','5672300','3920000','9592300');
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-03139','ADEL','1','PLD','WEDD RING','','','2.500','','10.00','1','1200000','350000','','500000','1375000','SIZE CWOK : 14','GRAF : Arum : Vintage Rotter','WARNA KRUM.GLOSSY/MODEL CINCIN SAMPLE SILVER','','','');
INSERT INTO tm_barang_contoh(no_persekot,no_urut,kode_barang,nama_barang,berat,tgl_titip,status) VALUES ('DP-03139','1','','MOD SILVER','','2026-07-28 15:01:49','OPEN');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03139','2026-07-28','2026-07-28','15:01:49','PLG0013704','ADEL','2026-08-17','jogja','2026-07-28 15:01:49','2.500','1100000','0','0','0','0','500000','1375000','1375000','275000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260728-0005','D','2026-07-28','15:01:49','jogja','PESANAN','DP-03139','9592300','1100000','10692300');
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-260728-0006','kasirbip','1',' DP-02713DU','TOKO','DUPSN','PSPRT-ZGBC-21-0','CINCIN PERAK ','','4.580','1','100.00','468000','0','0','17800','900000','0','0','0','900000','PUT','00045568','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBC-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.580',berat_jual_asli=berat_jual_asli+'4.580',stock_jual='1',berat_akhir=berat_akhir-'4.580',berat_akhir_asli=berat_akhir_asli-'4.580',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PSPRT-ZGBC-21-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-260728-0006','2026-07-28','4.580','2026-07-28','15:06:39','PLG0013705','900000','900000','0','900000','0','kasirbip','2026-07-28 15:06:39','FJ-260728-0006','DP-02713','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0006','2026-07-28','15:06:39','PUT','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260728-0006' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03140','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','850000','0','850000','SIZE:23','GRF: MENYUSUL','PUTIH GLOSSY (REQ PRMTA KECIL)','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-260728-0010','2026-07-28','2026-07-28 15:07:50','PESANAN : DP-03140','-','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-260728-0011','D','2026-07-28','15:07:50','TBC','PESANAN','DP-03140','25457615564','850000','25458465564','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-03140','2026-07-28','2026-07-28','15:07:50','PLG0013706','VAN','2026-08-23','sby','2026-07-28 15:07:50','3.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0006';
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03136';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03136';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03136';
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-260728-0006','K','2026-07-28','15:13:16','jogja','PESANAN BATAL','DP-03136','10692300','3920000','6772300');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03137';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03137';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03137';
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-260728-0007','K','2026-07-28','15:13:41','jogja','PESANAN BATAL','DP-03137','6772300','1100000','5672300');
UPDATE tm_sales SET deleted_by = 'jogja',deleted_date = '2026-07-28 15:14:42' WHERE sales_id = 'ADEL';
INSERT INTO tm_sales_deleted SELECT * FROM tm_sales WHERE sales_id = 'ADEL';
DELETE FROM tm_sales WHERE sales_id= 'ADEL';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-28 ','15:31:24');
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-03141','SULIS','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','900000','1600000','sz 17 putih glosy 15 zircon expres 100.000','font berkshire swash grf ASYA','permata atas dibuat utuh 1 butir','150000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260728-0011','2026-07-28','2026-07-28 15:36:07','PESANAN : DP-03141','.','TBC','1392000','1392000');
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-260728-0012','D','2026-07-28','15:36:07','TBC','PESANAN','DP-03141','25458465564','1392000','25459857564','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-03141','2026-07-28','2026-07-28','15:36:07','PLG0013707','SULIS','2026-08-08','kasirbip','2026-07-28 15:36:07','2.000','0','0','0','1392000','0','900000','1750000','1750000','358000');
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-03142','SULIS','1','GOLD','WED RING','','','3.000','','75.00','1','2280000','2250000','0','700000','7450000','sz 12 kuning glosy fint vladimir grf Thomas','express 100.000','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260728-0012','2026-07-28','2026-07-28 16:00:55','PESANAN : DP-03142','.','TBC','5960000','5960000');
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-260728-0013','D','2026-07-28','16:00:55','TBC','PESANAN','DP-03142','25459857564','5960000','25465817564','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-03142','2026-07-28','2026-07-28','16:00:55','PLG0013708','SULIS','2026-08-08','kasirbip','2026-07-28 16:00:55','3.000','0','0','0','5960000','0','700000','7450000','7450000','1490000');
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-03143','SULIS','1','GOLD','WED RING','','','3.500','','75.00','1','2280000','2250000','0','700000','8575000','sz 19 kuning glosy fint vladimir grf nikki','express 100.000','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260728-0013','2026-07-28','2026-07-28 16:02:39','PESANAN : DP-03143','.','TBC','6860000','6860000');
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-260728-0014','D','2026-07-28','16:02:39','TBC','PESANAN','DP-03143','25465817564','6860000','25472677564','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-03143','2026-07-28','2026-07-28','16:02:39','PLG0013709','SULIS','2026-08-08','kasirbip','2026-07-28 16:02:39','3.500','0','0','0','6860000','0','700000','8575000','8575000','1715000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-28 ','17:05:52');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260728-0007','kasir','1',' TFA-21095 ','TOKO','TFABR','TFA-XLXI-16-0','ANTING TFA-21095','','5.590','1','103.00','20061000','5108500','287','17800','22000000','0','0','0','22000000','ILUNG','00032505','TFA','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFA-XLXI-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.590',berat_jual_asli=berat_jual_asli+'5.590',stock_jual='1',berat_akhir=berat_akhir-'5.590',berat_akhir_asli=berat_akhir_asli-'5.590',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='TFA-XLXI-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFABR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260728-0007','2026-07-28','5.590','2026-07-28','17:10:21','PLG0013710','22000000','22000000','0','22000000','0','kasir','2026-07-28 17:10:20','FJ-260728-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-07-28','FJ-260728-0007','2026-07-28','17:10:21','ILUNG','22000000','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-260728-0014','2026-07-28','2026-07-28 17:10:20','PENJUALAN : FJ-260728-0007','.','TBC','22000000','22000000','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-260728-0015','D','2026-07-28','17:10:21','TBC','PENJUALAN BERLIAN','FJ-260728-0007','25472677564','22000000','25494677564','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='22000000' WHERE no_faktur_jual='FJ-260728-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-28 ','17:17:16');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02192','ILUNG','1','TFA21095','CRUM FULL ROSE GOLD','5.590','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-02192','2026-07-28','2026-07-28','17:21:47','PLG0013711','kasir','2026-07-30','kasir','2026-07-28 17:21:47','5.590','0','0','0','0','0','0','0','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-260728-0008','sby','1',' PLSBY-0000','TOKO','SBYPLD','PLSBY-ZFXB-12-0','CINCIN PALADIUM 10% PLSBY-00003 ','','4.320','1','17.00','970000','0','0','17800','2212000','0','0','0','2212000','DIL','00043934','PLSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLSBY-ZFXB-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.320',berat_jual_asli=berat_jual_asli+'4.320',stock_jual='1',berat_akhir=berat_akhir-'4.320',berat_akhir_asli=berat_akhir_asli-'4.320',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PLSBY-ZFXB-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPLD' 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-260728-0008','2026-07-28','4.320','2026-07-28','18:51:26','PLG0013712','2212000','2212000','0','2212000','0','sby','2026-07-28 18:51:25','FJ-260728-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0008','2026-07-28','18:51:26','DIL','2212000','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-260728-0015','2026-07-28','2026-07-28 18:51:25','PENJUALAN : FJ-260728-0008','','TBC','2212000','2212000','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-260728-0016','D','2026-07-28','18:51:26','TBC','PENJUALAN','FJ-260728-0008','25494677564','2212000','25496889564','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='2212000' WHERE no_faktur_jual='FJ-260728-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260728-0009','kasirbip','1',' 900K-135-0','TOKO','DUPERBDG','LXPER-ZEAB-28-0','CINCIN SILVER 925 ','','1.790','1','100.00','183000','0','0','17800','1000000','0','0','0','1000000','PUT','00043495','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEAB-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.790',berat_jual_asli=berat_jual_asli+'1.790',stock_jual='1',berat_akhir=berat_akhir-'1.790',berat_akhir_asli=berat_akhir_asli-'1.790',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='LXPER-ZEAB-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260728-0009','2026-07-28','1.790','2026-07-28','19:13:01','PLG0013713','1000000','1000000','0','1000000','0','kasirbip','2026-07-28 19:13:01','FJ-260728-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0009','2026-07-28','19:13:01','PUT','1000000','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-260728-0016','2026-07-28','2026-07-28 19:13:01','PENJUALAN : FJ-260728-0009','.','TBC','1000000','1000000','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-260728-0017','D','2026-07-28','19:13:01','TBC','PENJUALAN','FJ-260728-0009','25496889564','1000000','25497889564','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='1000000' WHERE no_faktur_jual='FJ-260728-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0009';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260728-0010','sby','1',' 750K-18-00','TOKO','SBYPER','PSBY-ZEXE-59-0','CINCIN SILVER 925 ','','3.700','1','100.00','378000','0','0','17800','850000','0','0','0','850000','DIL','00043255','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-59-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.700',berat_jual_asli=berat_jual_asli+'3.700',stock_jual='1',berat_akhir=berat_akhir-'3.700',berat_akhir_asli=berat_akhir_asli-'3.700',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PSBY-ZEXE-59-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-260728-0010','2026-07-28','3.700','2026-07-28','19:16:48','PLG0013714','850000','850000','0','850000','0','sby','2026-07-28 19:16:48','FJ-260728-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0010','2026-07-28','19:16:48','DIL','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260728-0017','2026-07-28','2026-07-28 19:16:48','PENJUALAN : FJ-260728-0010','','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-260728-0018','D','2026-07-28','19:16:48','TBC','PENJUALAN','FJ-260728-0010','25497889564','850000','25498739564','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-260728-0010' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260728-0011','sby',' 1',' 1.25K-115-','TOKO','SBYPER','PSBY-ZFXH-83-0','CINCIN SILVER 925 ','','2.520','1','100.00','258000','0','0','17800','1350000','0','0','0','1350000','DIL','00044096','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZFXH-83-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-07-28' AND kode_barang='PSBY-ZFXH-83-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-260728-0011','2026-07-28','2.520','2026-07-28','19:16:48','PLG0013715','1350000','1350000','0','1350000','0','sby','2026-07-28 19:16:48','FJ-260728-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0011','2026-07-28','19:16:48','DIL','1350000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260728-0018','2026-07-28','2026-07-28 19:16:48','PENJUALAN : FJ-260728-0011','','TBC','1350000','1350000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260728-0019','D','2026-07-28','19:16:48','TBC','PENJUALAN','FJ-260728-0011','25498739564','1350000','25500089564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2200000' WHERE no_faktur_jual='FJ-260728-0011' 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-03144','NAD','1','PLD','WEDRING','','','3.500','','10.00','1','1200000','350000','0','750000','1975000','size 16.5 crom putih doff semprot','EXPRESS 10 HARI','','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-260728-0019','2026-07-28','2026-07-28 19:20:03','PESANAN : DP-03144','.','TBC','1580000','1580000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260728-0020','D','2026-07-28','19:20:03','TBC','PESANAN','DP-03144','25500089564','1580000','25501669564','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-03144','2026-07-28','2026-07-28','19:20:03','PLG0013716','NAD','2026-08-11','kasirbip','2026-07-28 19:20:03','3.500','0','0','0','1580000','0','750000','1975000','1975000','395000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0011';
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-260728-0008','K','2026-07-28','19:34:56','kasir','KAS BESAR','AMBIL UANG','5672300','5020000','652300');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-28 ','19:48:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-28 ','19:49:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-28 ','19:52:59');
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-03145','SAL','1','PER','WED RING','','','4.000','','925.00','1','100000','0','900000','0','900000','sz 21.5 putih doff semprot 3 zirkon','font berkshire swash grf . . . Yuni Ardiati','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-260728-0020','2026-07-28','2026-07-28 20:06:24','PESANAN : DP-03145','.','TBC','400000','400000');
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-260728-0021','D','2026-07-28','20:06:24','TBC','PESANAN','DP-03145','25501669564','400000','25502069564','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-03145','2026-07-28','2026-07-28','20:06:24','PLG0013717','SAL','2026-08-21','kasirbip','2026-07-28 20:06:24','4.000','0','0','0','400000','0','0','900000','900000','500000');
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-03146','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 7.5 putih doff semprot 3 zirkon','font berkshire swash grf . . . Riza Mulfadli','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-260728-0021','2026-07-28','2026-07-28 20:08:08','PESANAN : DP-03146','.','TBC','400000','400000');
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-260728-0022','D','2026-07-28','20:08:08','TBC','PESANAN','DP-03146','25502069564','400000','25502469564','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-03146','2026-07-28','2026-07-28','20:08:08','PLG0013718','SAL','2026-08-21','kasirbip','2026-07-28 20:08:08','2.000','0','0','0','400000','0','0','900000','900000','500000');
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-260728-0012','kasir','1',' 850K-13-64','TOKO','MMPER','PMM-YLAX-75-0','CINCIN SILVER 925 ','','1.440','1','100.00','89000','0','0','17800','1000000','0','0','0','1000000','ALIKA','00040477','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YLAX-75-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PMM-YLAX-75-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-260728-0012','2026-07-28','1.440','2026-07-28','20:10:00','PLG0013719','1000000','1000000','0','1000000','0','kasir','2026-07-28 20:09:59','FJ-260728-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0012','2026-07-28','20:10:00','ALIKA','1000000','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-260728-0022','2026-07-28','2026-07-28 20:09:59','PENJUALAN : FJ-260728-0012','0','TBC','1000000','1000000','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-260728-0023','D','2026-07-28','20:10:00','TBC','PENJUALAN','FJ-260728-0012','25502469564','1000000','25503469564','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='1000000' WHERE no_faktur_jual='FJ-260728-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-260728-0013','kasir',' 1',' 500K-15-00','TOKO','MMPER','PBSD-YGBI-97-0','CINCIN SILVER 925 ','','1.600','1','100.00','33000','0','0','17800','700000','0','0','0','700000','ALIKA','00037733','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBI-97-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PBSD-YGBI-97-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-260728-0013','2026-07-28','1.600','2026-07-28','20:10:00','PLG0013720','700000','700000','0','700000','0','kasir','2026-07-28 20:09:59','FJ-260728-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0013','2026-07-28','20:10:00','ALIKA','700000','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-260728-0023','2026-07-28','2026-07-28 20:09:59','PENJUALAN : FJ-260728-0013','0','TBC','700000','700000','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-260728-0024','D','2026-07-28','20:10:00','TBC','PENJUALAN','FJ-260728-0013','25503469564','700000','25504169564','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='1700000' WHERE no_faktur_jual='FJ-260728-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-260728-0014','sby','1',' 1.0K-12-00','TOKO','SBYPER','PSBY-ZEXE-33-0','CINCIN SILVER 925 ','','1.380','1','100.00','141000','0','0','17800','1100000','0','0','0','1100000','VAN','00043229','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PSBY-ZEXE-33-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-260728-0014','2026-07-28','1.380','2026-07-28','20:31:40','PLG0013721','1100000','1100000','0','1100000','0','sby','2026-07-28 20:31:40','FJ-260728-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0014','2026-07-28','20:31:40','VAN','1100000','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-260728-0024','2026-07-28','2026-07-28 20:31:40','PENJUALAN : FJ-260728-0014','','TBC','1100000','1100000','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-260728-0025','D','2026-07-28','20:31:40','TBC','PENJUALAN','FJ-260728-0014','25504169564','1100000','25505269564','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='1100000' WHERE no_faktur_jual='FJ-260728-0014' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260728-0015','sby',' 1',' 750K-165-0','TOKO','SBYPER','PSBY-ZGBB-39-0','CINCIN SILVER 925 ','','1.800','1','100.00','184000','0','0','17800','850000','0','0','0','850000','VAN','00045530','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGBB-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PSBY-ZGBB-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260728-0015','2026-07-28','1.800','2026-07-28','20:31:40','PLG0013722','850000','850000','0','850000','0','sby','2026-07-28 20:31:40','FJ-260728-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0015','2026-07-28','20:31:40','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-260728-0025','2026-07-28','2026-07-28 20:31:40','PENJUALAN : FJ-260728-0015','','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-260728-0026','D','2026-07-28','20:31:40','TBC','PENJUALAN','FJ-260728-0015','25505269564','850000','25506119564','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='1950000' WHERE no_faktur_jual='FJ-260728-0015' 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-03147','DIL','1','PER','WEDD RING PRIA YL10','','','4.000','','925.00','1','100000','0','800000','0','800000','REQ LEBAR 4MM','SIZE 22.5 GRF: Vinta ?? Rizky (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-260728-0026','2026-07-28','2026-07-28 20:48:56','PESANAN : DP-03147','-','TBC','800000','800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260728-0027','D','2026-07-28','20:48:56','TBC','PESANAN','DP-03147','25506119564','800000','25506919564','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-03147','2026-07-28','2026-07-28','20:48:56','PLG0013723','DIL','2026-08-21','sby','2026-07-28 20:48:56','4.000','0','0','0','800000','0','0','800000','800000','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-03148','DIL','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','1050000','0','1050000','SIZE 14 GRF: Rizky ?? Vinta (BERKSHIRE)','PUTIH GLOSSY','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260728-0027','2026-07-28','2026-07-28 20:51:38','PESANAN : DP-03148','-','TBC','1050000','1050000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260728-0028','D','2026-07-28','20:51:38','TBC','PESANAN','DP-03148','25506919564','1050000','25507969564','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-03148','2026-07-28','2026-07-28','20:51:38','PLG0013724','DIL','2026-08-21','sby','2026-07-28 20:51:38','2.000','0','0','0','1050000','0','0','1050000','1050000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-28 ','20:55:10');
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-260728-0016','sby','1',' 750K-14-00','TOKO','SBYPER','PSBY-ZEXD-32-0','CINCIN SILVER 925 ','','1.910','1','100.00','195000','0','0','17800','850000','0','0','0','850000','VAN','00043164','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXD-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PSBY-ZEXD-32-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-260728-0016','2026-07-28','1.910','2026-07-28','20:57:20','PLG0013725','850000','850000','0','850000','0','sby','2026-07-28 20:57:19','FJ-260728-0016','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0016','2026-07-28','20:57:20','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-260728-0028','2026-07-28','2026-07-28 20:57:19','PENJUALAN : FJ-260728-0016','','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-260728-0029','D','2026-07-28','20:57:20','TBC','PENJUALAN','FJ-260728-0016','25507969564','850000','25508819564','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-260728-0016' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260728-0017','sby',' 1',' 800K-115-0','TOKO','SBYPER','PSBY-ZFBB-11-0','CINCIN SILVER 925 ','','2.390','1','100.00','244000','0','0','17800','900000','0','0','0','900000','VAN','00044625','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZFBB-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PSBY-ZFBB-11-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-260728-0017','2026-07-28','2.390','2026-07-28','20:57:20','PLG0013726','900000','900000','0','900000','0','sby','2026-07-28 20:57:19','FJ-260728-0016','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0017','2026-07-28','20:57:20','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-260728-0029','2026-07-28','2026-07-28 20:57:19','PENJUALAN : FJ-260728-0017','','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-260728-0030','D','2026-07-28','20:57:20','TBC','PENJUALAN','FJ-260728-0017','25508819564','900000','25509719564','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-260728-0017' 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-03149','SAL','1','PER','WED RING','','','4.000','','925.00','1','100000','0','1500000','0','1500000','cwo sz 24 putih doff semprot 1 zirkon grf Wisma . . .','cwe sz 10.5 putih glossy 10 zirkon grf Puji . . .','font yeseva one OVERSIZE 100.000 model spt cnth','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260728-0030','2026-07-28','2026-07-28 20:57:34','PESANAN : DP-03149','.','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-260728-0031','D','2026-07-28','20:57:34','TBC','PESANAN','DP-03149','25509719564','1500000','25511219564','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-03149','2026-07-28','2026-07-28','20:57:34','PLG0013727','SAL','2026-08-26','kasirbip','2026-07-28 20:57:34','4.000','0','0','0','1500000','0','0','1500000','1500000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260728-0018','kasirbip','1',' 750K-125-2','TOKO','BIPPER','PBDG-ZGXF-50-0','CINCIN SILVER 925 ','','2.230','1','100.00','228000','0','0','17800','850000','0','0','0','850000','SULIS','00044978','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGXF-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PBDG-ZGXF-50-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-260728-0018','2026-07-28','2.230','2026-07-28','21:02:36','PLG0013728','850000','850000','0','850000','0','kasirbip','2026-07-28 21:02:35','FJ-260728-0018','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0018','2026-07-28','21:02:36','SULIS','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260728-0031','2026-07-28','2026-07-28 21:02:35','PENJUALAN : FJ-260728-0018','.','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-260728-0032','D','2026-07-28','21:02:36','TBC','PENJUALAN','FJ-260728-0018','25511219564','850000','25512069564','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-260728-0018' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260728-0019','kasirbip',' 1',' 750K-185-2','TOKO','BIPPER','PBDG-ZGXF-52-0','CINCIN SILVER 925 ','','2.440','1','100.00','249000','0','0','17800','850000','0','0','0','850000','SULIS','00044980','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGXF-52-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.440',berat_jual_asli=berat_jual_asli+'2.440',stock_jual='1',berat_akhir=berat_akhir-'2.440',berat_akhir_asli=berat_akhir_asli-'2.440',stock_akhir='0' WHERE tanggal='2026-07-28' AND kode_barang='PBDG-ZGXF-52-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-260728-0019','2026-07-28','2.440','2026-07-28','21:02:36','PLG0013729','850000','850000','0','850000','0','kasirbip','2026-07-28 21:02:35','FJ-260728-0018','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-28','FJ-260728-0019','2026-07-28','21:02:36','SULIS','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260728-0032','2026-07-28','2026-07-28 21:02:35','PENJUALAN : FJ-260728-0019','.','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-260728-0033','D','2026-07-28','21:02:36','TBC','PENJUALAN','FJ-260728-0019','25512069564','850000','25512919564','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-260728-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260728-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260728-0019';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-28';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-07-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-28' 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-260729-0001','D','2026-07-29','21:36:27','TBC','SALDO AWAL','SALDO AWAL','0','25512919564','25512919564');
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-260729-0001','D','2026-07-29','21:36:27','BCK','SALDO AWAL','SALDO AWAL','0','1996308000','1996308000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260729-0001','D','2026-07-29','21:36:27','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-260729-0001','D','2026-07-29','21:36:27','','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-260729-0001','D','2026-07-29','21:36:27','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-260729-0001','D','2026-07-29','21:36:27','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-260729-0001','D','2026-07-29','21:36:27','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-260729-0001','D','2026-07-29','21:36:27','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-260729-0001','D','2026-07-29','21:36:27','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-260729-0001','D','2026-07-29','21:36:27','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-260729-0001','D','2026-07-29','21:36:27','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-260729-0001','D','2026-07-29','21:36:27','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
UPDATE tp_system SET tgl_system='2026-07-29';