INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-13 ','10:28:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-13 ','10:29: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-260913-0001','kasirbip','1',' DP-03620BI','TOKO','BIPPSN','PSGT-ZIXH-7-0','CINCIN EMAS ','','2.440','1','83.00','4959000','0','0','17800','6390000','0','0','0','6390000','KUR','00047020','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIXH-7-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-09-13' AND kode_barang='PSGT-ZIXH-7-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-260913-0001','2026-09-13','2.440','2026-09-13','10:31:22','PLG0015769','6390000','6390000','0','6390000','0','kasirbip','2026-09-13 10:31:21','FJ-260913-0001','DP-03620','5220000');
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-09-13','FJ-260913-0001','2026-09-13','10:31:22','KUR','6390000','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-260913-0001','2026-09-13','2026-09-13 10:31:21','PENJUALAN : FJ-260913-0001','.','TBC','1170000','1170000','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-260913-0002','D','2026-09-13','10:31:22','TBC','PENJUALAN','FJ-260913-0001','27734214964','1170000','27735384964','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='1170000' WHERE no_faktur_jual='FJ-260913-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-260913-0002','kasirbip',' 1',' DP-03621BI','TOKO','BIPPSN','PSPLT-ZIAA-5-0','CINCIN PALADIUM ','','4.160','1','17.00','934000','0','0','17800','2206000','0','0','0','2206000','KUR','00047115','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIAA-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.160',berat_jual_asli=berat_jual_asli+'4.160',stock_jual='1',berat_akhir=berat_akhir-'4.160',berat_akhir_asli=berat_akhir_asli-'4.160',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPLT-ZIAA-5-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-260913-0002','2026-09-13','4.160','2026-09-13','10:31:22','PLG0015770','2206000','2206000','0','2206000','0','kasirbip','2026-09-13 10:31:21','FJ-260913-0001','DP-03621','1720000');
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-09-13','FJ-260913-0002','2026-09-13','10:31:22','KUR','2206000','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-260913-0002','2026-09-13','2026-09-13 10:31:21','PENJUALAN : FJ-260913-0002','.','TBC','486000','486000','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-260913-0003','D','2026-09-13','10:31:22','TBC','PENJUALAN','FJ-260913-0002','27735384964','486000','27735870964','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='1656000' WHERE no_faktur_jual='FJ-260913-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-260913-0003','kasirbip','1',' 800K-21-28','TOKO','BIPPER','PBDG-ZHXD-31-0','CINCIN SILVER 925 ','','3.230','1','100.00','330000','0','0','17800','850000','0','0','0','850000','KUR','00045870','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHXD-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.230',berat_jual_asli=berat_jual_asli+'3.230',stock_jual='1',berat_akhir=berat_akhir-'3.230',berat_akhir_asli=berat_akhir_asli-'3.230',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PBDG-ZHXD-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-260913-0003','2026-09-13','3.230','2026-09-13','10:40:12','PLG0015771','850000','850000','0','850000','0','kasirbip','2026-09-13 10:40:12','FJ-260913-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','FJ-260913-0003','2026-09-13','10:40:12','KUR','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-260913-0003','2026-09-13','2026-09-13 10:40:12','PENJUALAN : FJ-260913-0003','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260913-0004','D','2026-09-13','10:40:12','TBC','PENJUALAN','FJ-260913-0003','27735870964','850000','27736720964','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-260913-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-260913-0004','kasirbip',' 1',' 900K-11-24','TOKO','BIPPER','PBDG-ZDAX-29-0','CINCIN SILVER 925 ','','1.620','1','100.00','166000','0','0','17800','950000','0','0','0','950000','KUR','00042466','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDAX-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PBDG-ZDAX-29-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-260913-0004','2026-09-13','1.620','2026-09-13','10:40:12','PLG0015772','950000','950000','0','950000','0','kasirbip','2026-09-13 10:40:12','FJ-260913-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','FJ-260913-0004','2026-09-13','10:40:12','KUR','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260913-0004','2026-09-13','2026-09-13 10:40:12','PENJUALAN : FJ-260913-0004','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260913-0005','D','2026-09-13','10:40:12','TBC','PENJUALAN','FJ-260913-0004','27736720964','950000','27737670964','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-260913-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0004';
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-04006','ADL','1','PER','WEDDING RING','','','4.500','','925.00','1','100000','0','1400000','0','1400000','sz cwe 26 sz cwo 30','ukir nama Font Vintage : Badawi Ardhita','charge over sz','0','0','200000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0005','2026-09-13','2026-09-13 10:48:38','PESANAN : DP-04006','-','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-260913-0006','D','2026-09-13','10:48:38','TBC','PESANAN','DP-04006','27737670964','1600000','27739270964','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-04006','2026-09-13','2026-09-13','10:48:38','PLG0015773','ADL','2026-10-05','jogja','2026-09-13 10:48:38','4.500','0','0','0','1600000','0','0','1600000','1600000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-09-13 ','11:01:39');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260913-0005','sby','1',' DP-03411SB','TOKO','SBYPSN','PSPLT-ZIXD-84-0','CINCIN PALADIUM ','','3.090','1','17.00','694000','0','0','17800','1841000','0','0','0','1841000','VAN','00046947','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIXD-84-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-09-13' AND kode_barang='PSPLT-ZIXD-84-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-260913-0005','2026-09-13','3.090','2026-09-13','11:04:38','PLG0015774','1841000','1841000','0','1841000','0','sby','2026-09-13 11:04:38','FJ-260913-0005','DP-03411','1500000');
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-09-13','FJ-260913-0005','2026-09-13','11:04:38','VAN','1841000','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-260913-0006','2026-09-13','2026-09-13 11:04:38','PENJUALAN : FJ-260913-0005','','TBC','341000','341000','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-260913-0007','D','2026-09-13','11:04:38','TBC','PENJUALAN','FJ-260913-0005','27739270964','341000','27739611964','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='341000' WHERE no_faktur_jual='FJ-260913-0005' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-13 ','11:08:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-13 ','11:10:20');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04007','NAD','1','PER','WEDRING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','size 14 crom putih glossy','Grf Koswara .... Astri','Font Vintage','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0007','2026-09-13','2026-09-13 11:12:00','PESANAN : DP-04007','.','TBC','1000000','1000000');
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-260913-0008','D','2026-09-13','11:12:00','TBC','PESANAN','DP-04007','27739611964','1000000','27740611964','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-04007','2026-09-13','2026-09-13','11:12:00','PLG0015775','NAD','2026-10-08','kasirbip','2026-09-13 11:12:00','2.000','0','0','0','1000000','0','0','1000000','1000000','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-04008','NAD','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','size 22 crom putih doff semprot','Grf Astri ..... Koswara','Font Vintage','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0008','2026-09-13','2026-09-13 11:13:58','PESANAN : DP-04008','.','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-260913-0009','D','2026-09-13','11:13:58','TBC','PESANAN','DP-04008','27740611964','850000','27741461964','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-04008','2026-09-13','2026-09-13','11:13:58','PLG0015776','NAD','2026-10-08','kasirbip','2026-09-13 11:13:58','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02247','KUR','1','CINCIN SILVER','REPARASI DIBULATIN PASANG MATA SIRKON 1 KROM ULANG NAMA JANGAN ILANG PUTIH DOF SEPINGGANG','1.500','1','150000','150000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260913-0009','2026-09-13','2026-09-13 11:16:43','SERVICE : SV-02247','.','TBC','150000','150000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260913-0010','D','2026-09-13','11:16:43','TBC','SERVICE','SV-02247','27741461964','150000','27741611964','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02247','2026-09-13','2026-09-13','11:16:43','PLG0015777','kasirbip','2026-09-29','kasirbip','2026-09-13 11:16:43','1.500','0','0','0','150000','0','150000','150000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260913-0006','sby','1',' 750K-175-0','TOKO','SBYPER','PSBY-ZIXD-69-0','CINCIN SILVER 925 ','','2.230','1','100.00','228000','0','0','17800','850000','0','0','0','850000','VAN','00046932','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZIXD-69-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-09-13' AND kode_barang='PSBY-ZIXD-69-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-260913-0006','2026-09-13','2.230','2026-09-13','11:21:23','PLG0015778','850000','850000','0','850000','0','sby','2026-09-13 11:21:23','FJ-260913-0006','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','FJ-260913-0006','2026-09-13','11:21:23','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-260913-0010','2026-09-13','2026-09-13 11:21:23','PENJUALAN : FJ-260913-0006','','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260913-0011','D','2026-09-13','11:21:23','TBC','PENJUALAN','FJ-260913-0006','27741611964','850000','27742461964','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-260913-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0006';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-13 ','11:48:30');
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-04009','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','800000','3000000','SIZE: 21.5','GRF: Favianadhirah FONT: BERKSHIRE','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-260913-0011','2026-09-13','2026-09-13 11:55:18','PESANAN : DP-04009','-','TBC','2000000','2000000');
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-260913-0012','D','2026-09-13','11:55:18','TBC','PESANAN','DP-04009','27742461964','2000000','27744461964','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-04009','2026-09-13','2026-09-13','11:55:18','PLG0015779','VAN','2026-10-06','sby','2026-09-13 11:55:18','4.000','0','0','0','2000000','0','800000','3000000','3000000','1000000');
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-260913-0007','kasirbip','1',' DP-03568BI','TOKO','BIPPSN','PSPRT-ZIAA-36-0','CINCIN PERAK ','','3.400','1','100.00','347000','0','0','17800','900000','0','0','0','900000','KUR','00047146','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAA-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.400',berat_jual_asli=berat_jual_asli+'3.400',stock_jual='1',berat_akhir=berat_akhir-'3.400',berat_akhir_asli=berat_akhir_asli-'3.400',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIAA-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260913-0007','2026-09-13','3.400','2026-09-13','11:58:23','PLG0015780','900000','900000','0','900000','0','kasirbip','2026-09-13 11:58:22','FJ-260913-0007','DP-03568','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-09-13','FJ-260913-0007','2026-09-13','11:58:23','KUR','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260913-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-260913-0008','kasirbip',' 1',' DP-03567BI','TOKO','BIPPSN','PSPRT-ZIXA-32-0','CINCIN PERAK ','','2.100','1','100.00','215000','0','0','17800','1000000','0','0','0','1000000','KUR','00046802','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXA-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIXA-32-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-260913-0008','2026-09-13','2.100','2026-09-13','11:58:23','PLG0015781','1000000','1000000','0','1000000','0','kasirbip','2026-09-13 11:58:22','FJ-260913-0007','DP-03567','1000000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','FJ-260913-0008','2026-09-13','11:58:23','KUR','1000000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260913-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-260913-0009','kasirbip','1',' DP-03500BI','TOKO','BIPPSN','PSPRT-ZIAA-4-0','CINCIN PERAK ','','6.030','1','100.00','616000','0','0','17800','950000','0','0','0','950000','SULIS','00047114','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAA-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.030',berat_jual_asli=berat_jual_asli+'6.030',stock_jual='1',berat_akhir=berat_akhir-'6.030',berat_akhir_asli=berat_akhir_asli-'6.030',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIAA-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-260913-0009','2026-09-13','6.030','2026-09-13','12:46:57','PLG0015782','950000','950000','0','950000','0','kasirbip','2026-09-13 12:46:56','FJ-260913-0009','DP-03500','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-09-13','FJ-260913-0009','2026-09-13','12:46:57','SULIS','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-260913-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0009';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04010','PUT','1','GOLD','WEDRING','','','2.000','','50.00','1','2400000','1800000','0','750000','4350000','sz cwe 13 crom putih gllosy','grf Ghian font Berkshire','','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-260913-0012','2026-09-13','2026-09-13 13:05:03','PESANAN : DP-04010','.','TBC','3480000','3480000');
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-260913-0013','D','2026-09-13','13:05:03','TBC','PESANAN','DP-04010','27744461964','3480000','27747941964','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-04010','2026-09-13','2026-09-13','13:05:03','PLG0015783','PUT','2026-10-08','kasirbip','2026-09-13 13:05:03','2.000','0','0','0','3480000','0','750000','4350000','4350000','870000');
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-04011','PUT','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','850000','0','850000','sz cwo 19 crom putih doff amplas','grf Rossana font Berkshire','','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-260913-0013','2026-09-13','2026-09-13 13:07:12','PESANAN : DP-04011','.','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-260913-0014','D','2026-09-13','13:07:12','TBC','PESANAN','DP-04011','27747941964','850000','27748791964','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-04011','2026-09-13','2026-09-13','13:07:12','PLG0015784','PUT','2026-10-08','kasirbip','2026-09-13 13:07:12','4.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260913-0010','sby','1',' DP-03414SB','TOKO','SBYPSN','PSPRT-ZIXC-10-0','CINCIN PERAK YL01 ','','4.200','1','100.00','429000','0','0','17800','1400000','0','0','0','1400000','DIL','00046840','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXC-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.200',berat_jual_asli=berat_jual_asli+'4.200',stock_jual='1',berat_akhir=berat_akhir-'4.200',berat_akhir_asli=berat_akhir_asli-'4.200',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIXC-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-260913-0010','2026-09-13','4.200','2026-09-13','13:26:14','PLG0015785','1400000','1400000','0','1400000','0','sby','2026-09-13 13:26:14','FJ-260913-0010','DP-03414','1400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','FJ-260913-0010','2026-09-13','13:26:14','DIL','1400000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260913-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-260913-0011','kasirbip','1',' 750K-18-29','TOKO','BIPPER','PBDG-ZIXC-24-0','CINCIN SILVER 925 ','','2.130','1','100.00','218000','0','0','17800','850000','0','0','0','850000','SULIS','00046854','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIXC-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PBDG-ZIXC-24-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-260913-0011','2026-09-13','2.130','2026-09-13','13:53:07','PLG0015786','850000','850000','0','850000','0','kasirbip','2026-09-13 13:53:06','FJ-260913-0011','','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-09-13','FJ-260913-0011','2026-09-13','13:53:07','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-260913-0014','2026-09-13','2026-09-13 13:53:06','PENJUALAN : FJ-260913-0011','.','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-260913-0015','D','2026-09-13','13:53:07','TBC','PENJUALAN','FJ-260913-0011','27748791964','850000','27749641964','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-260913-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-260913-0012','kasirbip',' 1',' 1.1K-14-23','TOKO','BIPPER','PBDG-ZDXG-12-0','CINCIN SILVER 925 ','','1.660','1','100.00','170000','0','0','17800','1200000','0','0','0','1200000','SULIS','00042327','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDXG-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PBDG-ZDXG-12-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-260913-0012','2026-09-13','1.660','2026-09-13','13:53:07','PLG0015787','1200000','1200000','0','1200000','0','kasirbip','2026-09-13 13:53:06','FJ-260913-0011','','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-09-13','FJ-260913-0012','2026-09-13','13:53:07','SULIS','1200000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260913-0015','2026-09-13','2026-09-13 13:53:06','PENJUALAN : FJ-260913-0012','.','TBC','1200000','1200000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260913-0016','D','2026-09-13','13:53:07','TBC','PENJUALAN','FJ-260913-0012','27749641964','1200000','27750841964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2050000' WHERE no_faktur_jual='FJ-260913-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0012';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-13 ','13:54:19');
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-09-13',  status ='CLOS' WHERE no_service='SV-02235';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02235';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260913-0001','1','PSPRT-ZIAA-53-0','1','2.060','2.060','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAA-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-53-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAA-53-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAA-53-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-09-13 14:00:28' WHERE kode_barang='PSPRT-ZIAA-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAA-53-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-13 14:00:28','TOKO','JOGPSN','PSPRT','PSPRT-ZIAA-53-0','1','2.060','','1','2.060','','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIAA-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-53-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-13' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260913-0001','1','PSGT-ZIAA-56-0','1','2.470','2.470','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIAA-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIAA-56-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIAA-56-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIAA-56-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-09-13 14:00:28' WHERE kode_barang='PSGT-ZIAA-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIAA-56-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-13 14:00:28','TOKO','JOGPSN','PSGT','PSGT-ZIAA-56-0','1','2.470','','1','2.470','','45.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZIAA-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIAA-56-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-13' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260913-0001','1','PSPLT-ZIAA-55-0','1','4.420','4.420','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIAA-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-55-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIAA-55-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIAA-55-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-09-13 14:00:28' WHERE kode_barang='PSPLT-ZIAA-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIAA-55-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-13 14:00:28','TOKO','JOGPSN','PSPLT','PSPLT-ZIAA-55-0','1','4.420','','1','4.420','','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIAA-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-55-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-13' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260913-0001','1','PSPLT-ZIAA-52-0','1','3.340','3.340','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIAA-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-52-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIAA-52-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIAA-52-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-09-13 14:00:28' WHERE kode_barang='PSPLT-ZIAA-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIAA-52-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-13 14:00:28','TOKO','JOGPSN','PSPLT','PSPLT-ZIAA-52-0','1','3.340','','1','3.340','','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIAA-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-52-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-13' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260913-0001','1','PSPLT-ZIAA-54-0','1','1.900','1.900','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIAA-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-54-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIAA-54-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIAA-54-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-09-13 14:00:28' WHERE kode_barang='PSPLT-ZIAA-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIAA-54-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-13 14:00:28','TOKO','JOGPSN','PSPLT','PSPLT-ZIAA-54-0','1','1.900','','1','1.900','','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIAA-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIAA-54-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-13' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260913-0001','1','PSPRT-ZIAA-20-0','1','4.330','4.330','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIAA-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIAA-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIAA-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-09-13 14:00:28' WHERE kode_barang='PSPRT-ZIAA-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIAA-20-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-13 14:00:28','TOKO','JOGPSN','PSPRT','PSPRT-ZIAA-20-0','1','4.330','','1','4.330','','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIAA-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIAA-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-13' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260913-0001','2026-09-13','13:54','18.520','jogja','2026-09-13 14:00:28');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-13 ','14:23:25');
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-04012','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz cwe 23 crom putih doff semprot','grf Fikri font Berkshire','','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-260913-0016','2026-09-13','2026-09-13 14:25:50','PESANAN : DP-04012','.','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-260913-0017','D','2026-09-13','14:25:50','TBC','PESANAN','DP-04012','27750841964','900000','27751741964','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-04012','2026-09-13','2026-09-13','14:25:50','PLG0015788','PUT','2026-10-08','kasirbip','2026-09-13 14:25:50','3.000','0','0','0','900000','0','0','900000','900000','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-04013','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz cwo 16.5 crom putih doff amplas','grf Fitria font Berkshire','','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-260913-0017','2026-09-13','2026-09-13 14:27:43','PESANAN : DP-04013','.','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-260913-0018','D','2026-09-13','14:27:43','TBC','PESANAN','DP-04013','27751741964','850000','27752591964','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-04013','2026-09-13','2026-09-13','14:27:43','PLG0015789','PUT','2026-10-08','kasirbip','2026-09-13 14:27:43','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-13 ','14:36:36');
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-260913-0013','kasirbip','1',' DP-03441DU','TOKO','DUPSN','PSPLT-ZIXD-77-0','CINCIN PALADIUM ','','2.510','1','17.00','523000','0','0','17800','1678500','0','0','0','1678500','PUT','00046940','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIXD-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.510',berat_jual_asli=berat_jual_asli+'2.510',stock_jual='1',berat_akhir=berat_akhir-'2.510',berat_akhir_asli=berat_akhir_asli-'2.510',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPLT-ZIXD-77-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-260913-0013','2026-09-13','2.510','2026-09-13','14:39:37','PLG0015790','1678500','1678500','0','1678500','0','kasirbip','2026-09-13 14:39:37','FJ-260913-0013','DP-03441','1480000');
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-09-13','FJ-260913-0013','2026-09-13','14:39:37','PUT','1678500','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-260913-0018','2026-09-13','2026-09-13 14:39:37','PENJUALAN : FJ-260913-0013','.','TBC','198500','198500','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-260913-0019','D','2026-09-13','14:39:37','TBC','PENJUALAN','FJ-260913-0013','27752591964','198500','27752790464','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='198500' WHERE no_faktur_jual='FJ-260913-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-260913-0014','kasirbip',' 1',' DP-03442DU','TOKO','DUPSN','PSPLT-ZIXH-43-0','CINCIN PALADIUM ','','3.150','1','17.00','708000','0','0','17800','1852500','0','0','0','1852500','PUT','00047056','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIXH-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.150',berat_jual_asli=berat_jual_asli+'3.150',stock_jual='1',berat_akhir=berat_akhir-'3.150',berat_akhir_asli=berat_akhir_asli-'3.150',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPLT-ZIXH-43-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-260913-0014','2026-09-13','3.150','2026-09-13','14:39:37','PLG0015791','1852500','1852500','0','1852500','0','kasirbip','2026-09-13 14:39:37','FJ-260913-0013','DP-03442','1440000');
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-09-13','FJ-260913-0014','2026-09-13','14:39:37','PUT','1852500','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-260913-0019','2026-09-13','2026-09-13 14:39:37','PENJUALAN : FJ-260913-0014','.','TBC','412500','412500','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-260913-0020','D','2026-09-13','14:39:37','TBC','PENJUALAN','FJ-260913-0014','27752790464','412500','27753202964','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='611000' WHERE no_faktur_jual='FJ-260913-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0014';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04014','ELLA','1','PER','CINCIN PROMO CP05','','','3.000','','925.00','1','100000','0','0','','1500000','cwe size 13 grf Teguh i m zircone 10 BTR','cwo size 18 grf Fitri Andriyanti zircone 1 BTR','warna crom putih 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-260913-0020','2026-09-13','2026-09-13 14:48:18','PESANAN : DP-04014','0','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-260913-0021','D','2026-09-13','14:48:18','TBC','PESANAN','DP-04014','27753202964','1500000','27754702964','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-04014','2026-09-13','2026-09-13','14:48:18','PLG0015792','ELLA','2026-10-08','kasir','2026-09-13 14:48:18','3.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-260913-0015','kasirbip','1',' DP-03460DU','TOKO','DUPSN','PSPRT-ZIAA-16-0','1PS CINCIN PERAK ','','3.580','1','100.00','366000','0','0','17800','1500000','0','0','0','1500000','PUT','00047126','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAA-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.580',berat_jual_asli=berat_jual_asli+'3.580',stock_jual='1',berat_akhir=berat_akhir-'3.580',berat_akhir_asli=berat_akhir_asli-'3.580',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIAA-16-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-260913-0015','2026-09-13','3.580','2026-09-13','15:06:11','PLG0015793','1500000','1500000','0','1500000','0','kasirbip','2026-09-13 15:06:10','FJ-260913-0015','DP-03460','1500000');
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-09-13','FJ-260913-0015','2026-09-13','15:06:11','PUT','1500000','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-260913-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-04015','NAD','1','PER','WEDRING','','','2.000','','925.00','1','100000','0','600000','0','600000','size 13.5 crom putih doff amplas','YL-01','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0021','2026-09-13','2026-09-13 15:12:35','PESANAN : DP-04015','.','TBC','600000','600000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260913-0022','D','2026-09-13','15:12:35','TBC','PESANAN','DP-04015','27754702964','600000','27755302964','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-04015','2026-09-13','2026-09-13','15:12:35','PLG0015794','NAD','2026-10-08','kasirbip','2026-09-13 15:12:35','2.000','0','0','0','600000','0','0','600000','600000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0015';
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-260913-0016','kasirbip','1',' DP-03505BI','TOKO','BIPPSN','PSGT-ZIXH-47-0','CINCIN EMAS ','','2.830','1','45.00','3118000','0','0','17800','4952000','0','0','0','4952000','SULIS','00047060','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIXH-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.830',berat_jual_asli=berat_jual_asli+'2.830',stock_jual='1',berat_akhir=berat_akhir-'2.830',berat_akhir_asli=berat_akhir_asli-'2.830',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSGT-ZIXH-47-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-260913-0016','2026-09-13','2.830','2026-09-13','15:27:56','PLG0015795','4952000','4952000','0','4952000','0','kasirbip','2026-09-13 15:27:56','FJ-260913-0016','DP-03505','4712000');
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-09-13','FJ-260913-0016','2026-09-13','15:27:56','SULIS','4952000','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-260913-0022','2026-09-13','2026-09-13 15:27:56','PENJUALAN : FJ-260913-0016','.','TBC','240000','240000','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-260913-0023','D','2026-09-13','15:27:56','TBC','PENJUALAN','FJ-260913-0016','27755302964','240000','27755542964','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='240000' WHERE no_faktur_jual='FJ-260913-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-260913-0017','kasirbip',' 1',' DP-03421BI','TOKO','BIPPSN','PSPRT-ZIXD-91-0','CINCIN PERAK ','','2.060','1','100.00','211000','0','0','17800','900000','0','0','0','900000','SULIS','00046954','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXD-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIXD-91-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-260913-0017','2026-09-13','2.060','2026-09-13','15:27:56','PLG0015796','900000','900000','0','900000','0','kasirbip','2026-09-13 15:27:56','FJ-260913-0016','DP-03421','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-09-13','FJ-260913-0017','2026-09-13','15:27:56','SULIS','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='240000' WHERE no_faktur_jual='FJ-260913-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0017';
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-04016','KUR','1','GOLD','CINCIN KAWIN','','','3.000','','37.50','1','2400000','1400000','0','700000','4900000','size 13 grf Tony','putih dof sepinggang sirkon 1','font times new roman','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-260913-0023','2026-09-13','2026-09-13 15:37:15','PESANAN : DP-04016','.','TBC','3900000','3900000');
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-260913-0024','D','2026-09-13','15:37:15','TBC','PESANAN','DP-04016','27755542964','3900000','27759442964','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-04016','2026-09-13','2026-09-13','15:37:15','PLG0015797','KUR','2026-10-13','kasirbip','2026-09-13 15:37:15','3.000','0','0','0','3900000','0','700000','4900000','4900000','1000000');
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-04017','KUR','1','PER','CINCIN KAWIN','','','4.000','','925.00','1','100000','0','900000','0','900000','size 17.5 grf Agnia 14-12-26','putih dof ampals keliling','font times new roman','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-260913-0024','2026-09-13','2026-09-13 15:42:43','PESANAN : DP-04017','.','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-260913-0025','D','2026-09-13','15:42:43','TBC','PESANAN','DP-04017','27759442964','900000','27760342964','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-04017','2026-09-13','2026-09-13','15:42:43','PLG0015798','KUR','2026-10-13','kasirbip','2026-09-13 15:42:43','4.000','0','0','0','900000','0','0','900000','900000','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-260913-0018','kasirbip','1',' DP-03433DU','TOKO','DUPSN','PSPRT-ZIAA-18-0','CINCIN PERAK SR03 YL01 ','','3.120','1','100.00','319000','0','0','17800','950000','0','0','0','950000','PUT','00047128','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAA-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIAA-18-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-260913-0018','2026-09-13','3.120','2026-09-13','15:44:49','PLG0015799','950000','950000','0','950000','0','kasirbip','2026-09-13 15:44:49','FJ-260913-0018','DP-03433','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-09-13','FJ-260913-0018','2026-09-13','15:44:49','PUT','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-260913-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0018';
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-04018','NAD','1','GOLD','WEDRING','','','2.000','','37.50','1','2400000','1400000','0','700000','3500000','size 10.5 crom putih glossy','Grf Tiara Kristina Font Vintage','jangan lebih dari 2 gram zircon OVAL','0','0','150000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0025','2026-09-13','2026-09-13 15:50:12','PESANAN : DP-04018','.','TBC','2920000','2920000');
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-260913-0026','D','2026-09-13','15:50:12','TBC','PESANAN','DP-04018','27760342964','2920000','27763262964','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-04018','2026-09-13','2026-09-13','15:50:12','PLG0015800','NAD','2026-10-08','kasirbip','2026-09-13 15:50:12','2.000','0','0','0','2920000','0','700000','3650000','3650000','730000');
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-04019','NAD','1','PER','WEDRING','','','4.000','','925.00','2','100000','0','950000','0','950000','sze cwe 14.5 sze cwo 20.5','Grf Adit ..... Nisa Font Berkshire','SR-03','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-260913-0026','2026-09-13','2026-09-13 16:30:46','PESANAN : DP-04019','.','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-260913-0027','D','2026-09-13','16:30:46','TBC','PESANAN','DP-04019','27763262964','950000','27764212964','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-04019','2026-09-13','2026-09-13','16:30:46','PLG0015801','NAD','2026-10-08','kasirbip','2026-09-13 16:30:46','4.000','0','0','0','950000','0','0','950000','950000','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-260913-0019','kasir','1',' DP-03316MM','TOKO','MMPSN','PSPLT-ZIXD-39-0','CINCIN PALADIUM ','','1.870','1','17.00','421000','0','0','17800','1355000','0','0','0','1355000','ELLA','00046902','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIXD-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPLT-ZIXD-39-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-260913-0019','2026-09-13','1.870','2026-09-13','16:33:16','PLG0015802','1355000','1355000','0','1355000','0','kasir','2026-09-13 16:33:15','FJ-260913-0019','DP-03316','1260000');
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-09-13','FJ-260913-0019','2026-09-13','16:33:16','ELLA','1355000','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-260913-0027','2026-09-13','2026-09-13 16:33:15','PENJUALAN : FJ-260913-0019','.','TBC','95000','95000','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-260913-0028','D','2026-09-13','16:33:16','TBC','PENJUALAN','FJ-260913-0019','27764212964','95000','27764307964','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='95000' WHERE no_faktur_jual='FJ-260913-0019' 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-260913-0020','kasirbip','1',' DP-03571DU','TOKO','DUPSN','PSPRT-ZIAA-45-0','CINCIN PERAK YL01 ','','3.080','1','100.00','315000','0','0','17800','850000','0','0','0','850000','NAD','00047155','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAA-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIAA-45-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-260913-0020','2026-09-13','3.080','2026-09-13','16:34:59','PLG0015803','850000','850000','0','850000','0','kasirbip','2026-09-13 16:34:58','FJ-260913-0020','DP-03571','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-09-13','FJ-260913-0020','2026-09-13','16:34:59','NAD','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-260913-0020' 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-04020','ADL','1','GOLD','WEDDINGRING','','','3.500','','375.00','1','2400000','1400000','0','950000','5850000','sz cwe 19 gold','ukirnama font berkshine : Singgih Kartika','zircon 15','0','0','150000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0028','2026-09-13','2026-09-13 16:41:50','PESANAN : DP-04020','-','TBC','4000000','4000000');
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-260913-0029','D','2026-09-13','16:41:50','TBC','PESANAN','DP-04020','27764307964','4000000','27768307964','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-04020','2026-09-13','2026-09-13','16:41:50','PLG0015804','ADL','2026-10-05','jogja','2026-09-13 16:41:50','3.500','0','0','0','4000000','0','950000','6000000','6000000','2000000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-13 ','16:42:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-13 ','16:48:09');
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-04021','ADL','1','PER','WEDDINGRING','','','3.500','','925.00','1','100000','0','1000000','0','1000000','sz cwo 20 mix silver gold','ukir nama berkhsine :Kartika Singgih','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0029','2026-09-13','2026-09-13 16:50:30','PESANAN : DP-04021','-','TBC','1000000','1000000');
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-260913-0030','D','2026-09-13','16:50:30','TBC','PESANAN','DP-04021','27768307964','1000000','27769307964','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-04021','2026-09-13','2026-09-13','16:50:30','PLG0015805','ADL','2026-10-05','jogja','2026-09-13 16:50:30','3.500','0','0','0','1000000','0','0','1000000','1000000','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-04022','SBR','1','PER','WEDDINGRING','','','4.000','','925.00','1','100000','0','1000000','0','1000000','sz cwo 22','express','','0','200000','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0030','2026-09-13','2026-09-13 16:56:20','PESANAN : DP-04022','-','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-260913-0031','D','2026-09-13','16:56:20','TBC','PESANAN','DP-04022','27769307964','1200000','27770507964','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-04022','2026-09-13','2026-09-13','16:56:20','PLG0015806','SBR','2026-09-20','jogja','2026-09-13 16:56:20','4.000','0','0','0','1200000','0','0','1200000','1200000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-13 ','16:58:50');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260913-0021','kasirbip','1',' DP-03381BI','TOKO','BIPPSN','PSPRT-ZIXH-38-0','1PS CINCIN PERAK ','','3.500','1','100.00','357000','0','0','17800','1400000','0','0','0','1400000','SAL','00047051','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXH-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.500',berat_jual_asli=berat_jual_asli+'3.500',stock_jual='1',berat_akhir=berat_akhir-'3.500',berat_akhir_asli=berat_akhir_asli-'3.500',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIXH-38-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-260913-0021','2026-09-13','3.500','2026-09-13','16:59:49','PLG0015807','1400000','1400000','0','1400000','0','kasirbip','2026-09-13 16:59:49','FJ-260913-0021','DP-03381','1400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','FJ-260913-0021','2026-09-13','16:59:49','SAL','1400000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260913-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-04023','PUT','1','GOLD','WEDRING','','','2.500','','50.00','1','2400000','1800000','0','700000','5200000','sz cwe 15.5 crom putih doff semprot','grf A.... A 10.1.27 font Berkshire','jngn lebih 2.5gr','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-260913-0031','2026-09-13','2026-09-13 17:05:57','PESANAN : DP-04023','.','TBC','4160000','4160000');
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-260913-0032','D','2026-09-13','17:05:57','TBC','PESANAN','DP-04023','27770507964','4160000','27774667964','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-04023','2026-09-13','2026-09-13','17:05:57','PLG0015808','PUT','2026-10-08','kasirbip','2026-09-13 17:05:57','2.500','0','0','0','4160000','0','700000','5200000','5200000','1040000');
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-04024','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz 20 putih doff semprot','dibuat tanpa permata','font berkshire swash grf Tammy . . .','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0032','2026-09-13','2026-09-13 17:07:21','PESANAN : DP-04024','.','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-260913-0033','D','2026-09-13','17:07:21','TBC','PESANAN','DP-04024','27774667964','850000','27775517964','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-04024','2026-09-13','2026-09-13','17:07:21','PLG0015809','SAL','2026-10-11','kasirbip','2026-09-13 17:07:21','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04025','DIL','1','PER','WEDD RING PRIA','','','2.000','','925.00','1','100000','0','850000','0','850000','SIZE 16 GRF: S ?? J (BRUSH SCRIPT)','PUTIH GLOSSY MIX ROSE GOLD 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-260913-0033','2026-09-13','2026-09-13 17:08:54','PESANAN : DP-04025','-','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-260913-0034','D','2026-09-13','17:08:54','TBC','PESANAN','DP-04025','27775517964','850000','27776367964','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-04025','2026-09-13','2026-09-13','17:08:54','PLG0015810','DIL','2026-10-07','sby','2026-09-13 17:08:54','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-04026','PUT','1','PLD','WEDRING','','','3.000','','25.00','1','1200000','550000','0','700000','2350000','sz cwo 18.5 crom putih doff semprot','grf A .... A 10.1.27 font Bekshire','jngn lebih 3gr','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-260913-0034','2026-09-13','2026-09-13 17:09:07','PESANAN : DP-04026','.','TBC','1880000','1880000');
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-260913-0035','D','2026-09-13','17:09:07','TBC','PESANAN','DP-04026','27776367964','1880000','27778247964','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-04026','2026-09-13','2026-09-13','17:09:07','PLG0015811','PUT','2026-10-08','kasirbip','2026-09-13 17:09:07','3.000','0','0','0','1880000','0','700000','2350000','2350000','470000');
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-04027','SAL','1','GOLD','WED RING','','','2.000','','37.50','1','2400000','1400000','0','850000','3650000','sz 12.5 putih glossy 7 zirkon','font berkshire swash grf Rizky . . .','berat akhir jgn terlalu jauh dgn estimasi awal','70000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0035','2026-09-13','2026-09-13 17:09:30','PESANAN : DP-04027','.','TBC','2976000','2976000');
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-260913-0036','D','2026-09-13','17:09:30','TBC','PESANAN','DP-04027','27778247964','2976000','27781223964','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-04027','2026-09-13','2026-09-13','17:09:30','PLG0015812','SAL','2026-10-11','kasirbip','2026-09-13 17:09:30','2.000','0','0','0','2976000','0','850000','3720000','3720000','744000');
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-04028','DIL','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','1300000','0','1300000','PERMATA MENYESUAIKAN','SIZE 12.5 GRF: J ?? S (BRUSH SCRIPT)','PUTIH GLOSSY MIX ROSE GOLD 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-260913-0036','2026-09-13','2026-09-13 17:12:02','PESANAN : DP-04028','-','TBC','1300000','1300000');
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-260913-0037','D','2026-09-13','17:12:02','TBC','PESANAN','DP-04028','27781223964','1300000','27782523964','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-04028','2026-09-13','2026-09-13','17:12:02','PLG0015813','DIL','2026-10-07','sby','2026-09-13 17:12:02','2.000','0','0','0','1300000','0','0','1300000','1300000','0');
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-09-13',  status ='CLOS' WHERE no_service='SV-02238';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02238';
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-09-13',  status ='CLOS' WHERE no_service='SV-02194';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02194';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-13 ','17:34:20');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04029','ADL','1','GOLD','WEDRING','','','3.000','','375.00','1','2400000','1400000','0','1500000','5700000','sz cwe 12','mix warna rosegold silver','zircon 50','0','0','500000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0037','2026-09-13','2026-09-13 17:36:52','PESANAN : DP-04029','-','TBC','4960000','4960000');
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-260913-0038','D','2026-09-13','17:36:52','TBC','PESANAN','DP-04029','27782523964','4960000','27787483964','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-04029','2026-09-13','2026-09-13','17:36:52','PLG0015814','ADL','2026-10-05','jogja','2026-09-13 17:36:52','3.000','0','0','0','4960000','0','1500000','6200000','6200000','1240000');
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-04030','ADL','1','PLD','WEDDINGRING','','','4.300','','10.00','1','1200000','350000','0','850000','2355000','sz cwo 145','','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0038','2026-09-13','2026-09-13 17:40:26','PESANAN : DP-04030','-','TBC','1884000','1884000');
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-260913-0039','D','2026-09-13','17:40:26','TBC','PESANAN','DP-04030','27787483964','1884000','27789367964','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-04030','2026-09-13','2026-09-13','17:40:26','PLG0015815','ADL','2026-10-05','jogja','2026-09-13 17:40:26','4.300','0','0','0','1884000','0','850000','2355000','2355000','471000');
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-04031','NAD','1','PLD','WEDRING','','','2.000','','10.00','1','1200000','350000','0','700000','1400000','size 11.5 crom putih glossy','zircon 28','Grf M ..... N Font Times new','0','280000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0039','2026-09-13','2026-09-13 17:55:54','PESANAN : DP-04031','.','TBC','1344000','1344000');
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-260913-0040','D','2026-09-13','17:55:54','TBC','PESANAN','DP-04031','27789367964','1344000','27790711964','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-04031','2026-09-13','2026-09-13','17:55:54','PLG0015816','NAD','2026-10-08','kasirbip','2026-09-13 17:55:54','2.000','0','0','0','1344000','0','700000','1680000','1680000','336000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0021';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-13 ','18:14:07');
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-260913-0022','jogja','1',' DP-03549JO','TOKO','JOGPSN','PSGT-ZIAA-56-0','CINCIN EMAS ','','2.470','1','45.00','2722000','0','0','17800','3458000','0','800000','0','4258000','ADL','00047166','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIAA-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.470',berat_jual_asli=berat_jual_asli+'2.470',stock_jual='1',berat_akhir=berat_akhir-'2.470',berat_akhir_asli=berat_akhir_asli-'2.470',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSGT-ZIAA-56-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-260913-0022','2026-09-13','2.470','2026-09-13','18:16:40','PLG0015817','3458000','3458000','800000','4258000','0','jogja','2026-09-13 18:16:39','FJ-260913-0022','DP-03549','2150000');
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-09-13','FJ-260913-0022','2026-09-13','18:16:40','ADL','4258000','800000');
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-260913-0040','2026-09-13','2026-09-13 18:16:39','PENJUALAN : FJ-260913-0022','','TBC','2108000','2108000','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-260913-0041','D','2026-09-13','18:16:40','TBC','PENJUALAN','FJ-260913-0022','27790711964','2108000','27792819964','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='2108000' WHERE no_faktur_jual='FJ-260913-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-260913-0023','jogja',' 1',' DP-03551JO','TOKO','JOGPSN','PSPRT-ZIAA-20-0','CINCIN PERAK ','','4.330','1','100.00','442000','0','0','17800','850000','0','0','0','850000','ADL','00047130','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAA-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.330',berat_jual_asli=berat_jual_asli+'4.330',stock_jual='1',berat_akhir=berat_akhir-'4.330',berat_akhir_asli=berat_akhir_asli-'4.330',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIAA-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-260913-0023','2026-09-13','4.330','2026-09-13','18:16:40','PLG0015818','850000','850000','0','850000','0','jogja','2026-09-13 18:16:39','FJ-260913-0022','DP-03551','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-09-13','FJ-260913-0023','2026-09-13','18:16:40','ADL','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2108000' WHERE no_faktur_jual='FJ-260913-0023' 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-260913-0024','sby','1',' DP-03326SB','TOKO','SBYPSN','PSGT-ZHBD-9-0','CINCIN EMAS ','','2.840','1','83.00','5771000','0','0','17800','7348000','0','0','0','7348000','DIL','00046327','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZHBD-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.840',berat_jual_asli=berat_jual_asli+'2.840',stock_jual='1',berat_akhir=berat_akhir-'2.840',berat_akhir_asli=berat_akhir_asli-'2.840',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSGT-ZHBD-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260913-0024','2026-09-13','2.840','2026-09-13','18:28:08','PLG0015819','7348000','7348000','0','7348000','0','sby','2026-09-13 18:28:07','FJ-260913-0024','DP-03326','5050000');
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-09-13','FJ-260913-0024','2026-09-13','18:28:08','DIL','7348000','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-260913-0041','2026-09-13','2026-09-13 18:28:07','PENJUALAN : FJ-260913-0024','','TBC','2298000','2298000','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-260913-0042','D','2026-09-13','18:28:08','TBC','PENJUALAN','FJ-260913-0024','27792819964','2298000','27795117964','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='2298000' WHERE no_faktur_jual='FJ-260913-0024' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260913-0025','sby',' 1',' DP-03328SB','TOKO','SBYPSN','PSPRT-ZHCA-34-0','CINCIN PERAK ','','2.010','1','100.00','206000','0','0','17800','950000','0','0','0','950000','DIL','00046726','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHCA-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZHCA-34-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-260913-0025','2026-09-13','2.010','2026-09-13','18:28:08','PLG0015820','950000','950000','0','950000','0','sby','2026-09-13 18:28:07','FJ-260913-0024','DP-03328','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-09-13','FJ-260913-0025','2026-09-13','18:28:08','DIL','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2298000' WHERE no_faktur_jual='FJ-260913-0025' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0022';
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-260913-0026','jogja','1',' DP-03676JO','TOKO','JOGPSN','PSPRT-ZIAA-53-0','CINCIN PERAK ','','2.060','1','100.00','211000','0','0','17800','800000','0','0','0','800000','ADL','00047163','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAA-53-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIAA-53-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-260913-0026','2026-09-13','2.060','2026-09-13','18:34:17','PLG0015821','800000','800000','0','800000','0','jogja','2026-09-13 18:34:17','FJ-260913-0026','DP-03676','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','FJ-260913-0026','2026-09-13','18:34:17','ADL','800000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260913-0026' 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-260913-0027','jogja',' 1',' DP-03678JO','TOKO','JOGPSN','PSPLT-ZIAA-54-0','CINCIN PALADIUM ','','1.900','1','17.00','427000','0','0','17800','665000','0','1000000','0','1665000','ADL','00047164','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIAA-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPLT-ZIAA-54-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-260913-0027','2026-09-13','1.900','2026-09-13','18:34:17','PLG0015822','665000','665000','1000000','1665000','0','jogja','2026-09-13 18:34:17','FJ-260913-0026','DP-03678','937500');
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-09-13','FJ-260913-0027','2026-09-13','18:34:17','ADL','1665000','1000000');
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-260913-0042','2026-09-13','2026-09-13 18:34:17','PENJUALAN : FJ-260913-0027','','TBC','727500','727500','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-260913-0043','D','2026-09-13','18:34:17','TBC','PENJUALAN','FJ-260913-0027','27795117964','727500','27795845464','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='727500' WHERE no_faktur_jual='FJ-260913-0027' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0027';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04032','PUT','1','PER','WEDRING','','','2.500','','925.00','1','100000','0','850000','0','850000','sz cwe 10 crom putih doff semprot','grf Kholfan 06.12.26','font Berkshire','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-260913-0043','2026-09-13','2026-09-13 18:43:51','PESANAN : DP-04032','.','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-260913-0044','D','2026-09-13','18:43:51','TBC','PESANAN','DP-04032','27795845464','850000','27796695464','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-04032','2026-09-13','2026-09-13','18:43:51','PLG0015823','PUT','2026-10-08','kasirbip','2026-09-13 18:43:51','2.500','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-04033','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz cwo 17 crom putih doff semprot','grf Fazrin 06.12.26','Font Berkshire','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-260913-0044','2026-09-13','2026-09-13 18:45:34','PESANAN : DP-04033','.','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-260913-0045','D','2026-09-13','18:45:34','TBC','PESANAN','DP-04033','27796695464','850000','27797545464','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-04033','2026-09-13','2026-09-13','18:45:34','PLG0015824','PUT','2026-10-08','kasirbip','2026-09-13 18:45:34','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04034','ELLA','1','PER','WEDDING RING','','','3.000','','925.00','1','100000','0','0','0','1100000','size 18 grf Deny & Eka','zircone 26 butir','warna crom full rose gold','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-260913-0045','2026-09-13','2026-09-13 19:01:20','PESANAN : DP-04034','0','TBC','1100000','1100000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260913-0046','D','2026-09-13','19:01:20','TBC','PESANAN','DP-04034','27797545464','1100000','27798645464','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-04034','2026-09-13','2026-09-13','19:01:20','PLG0015825','ELLA','2026-10-09','kasir','2026-09-13 19:01:20','3.000','0','0','0','1100000','0','0','1100000','1100000','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-260913-0028','sby','1',' DP-03520SB','TOKO','SBYPSN','PSPRT-ZIAA-46-0','CINCIN PERAK ','','2.390','1','100.00','244000','0','0','17800','900000','0','0','0','900000','VAN','00047156','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAA-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIAA-46-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-260913-0028','2026-09-13','2.390','2026-09-13','19:03:11','PLG0015826','900000','900000','0','900000','0','sby','2026-09-13 19:03:10','FJ-260913-0028','DP-03520','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-09-13','FJ-260913-0028','2026-09-13','19:03:11','VAN','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-260913-0028' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260913-0029','sby',' 1',' DP-03521SB','TOKO','SBYPSN','PSPRT-ZIAA-47-0','CINCIN PERAK ','','1.890','1','100.00','193000','0','0','17800','900000','0','0','0','900000','VAN','00047157','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAA-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.890',berat_jual_asli=berat_jual_asli+'1.890',stock_jual='1',berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIAA-47-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-260913-0029','2026-09-13','1.890','2026-09-13','19:03:11','PLG0015827','900000','900000','0','900000','0','sby','2026-09-13 19:03:10','FJ-260913-0028','DP-03521','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-09-13','FJ-260913-0029','2026-09-13','19:03:11','VAN','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-260913-0029' 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-04035','ELLA','1','PER','WEDDING RING','','','4.000','','925.00','1','100000','0','0','0','950000','size 27 grf Deny & Eka','warna crom full rosegold full glosy','tanpa permata','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0046','2026-09-13','2026-09-13 19:04:33','PESANAN : DP-04035','0','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260913-0047','D','2026-09-13','19:04:33','TBC','PESANAN','DP-04035','27798645464','950000','27799595464','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-04035','2026-09-13','2026-09-13','19:04:33','PLG0015828','ELLA','2026-10-09','kasir','2026-09-13 19:04:33','4.000','0','0','0','950000','0','0','950000','950000','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-260913-0030','kasirbip','1',' DP-03428DU','TOKO','DUPSN','PSPRT-ZIAX-11-0','CINCIN PERAK ','','3.640','1','100.00','372000','0','0','17800','900000','0','0','0','900000','PUT','00047110','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAX-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.640',berat_jual_asli=berat_jual_asli+'3.640',stock_jual='1',berat_akhir=berat_akhir-'3.640',berat_akhir_asli=berat_akhir_asli-'3.640',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIAX-11-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-260913-0030','2026-09-13','3.640','2026-09-13','19:32:09','PLG0015829','900000','900000','0','900000','0','kasirbip','2026-09-13 19:32:08','FJ-260913-0030','DP-03428','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-09-13','FJ-260913-0030','2026-09-13','19:32:09','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-260913-0030' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260913-0031','kasirbip',' 1',' DP-03427DU','TOKO','DUPSN','PSPLT-ZIXH-41-0','CINCIN PALADIUM ','','2.290','1','17.00','515000','0','0','17800','1671500','0','0','0','1671500','PUT','00047054','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIXH-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.290',berat_jual_asli=berat_jual_asli+'2.290',stock_jual='1',berat_akhir=berat_akhir-'2.290',berat_akhir_asli=berat_akhir_asli-'2.290',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPLT-ZIXH-41-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-260913-0031','2026-09-13','2.290','2026-09-13','19:32:09','PLG0015830','1671500','1671500','0','1671500','0','kasirbip','2026-09-13 19:32:08','FJ-260913-0030','DP-03427','1396000');
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-09-13','FJ-260913-0031','2026-09-13','19:32:09','PUT','1671500','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-260913-0047','2026-09-13','2026-09-13 19:32:08','PENJUALAN : FJ-260913-0031','.','TBC','275500','275500','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-260913-0048','D','2026-09-13','19:32:09','TBC','PENJUALAN','FJ-260913-0031','27799595464','275500','27799870964','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='275500' WHERE no_faktur_jual='FJ-260913-0031' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0024';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0028';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0029';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0030' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0030' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0030';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0031';
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-260913-0032','kasirbip','1',' DP-03423DU','TOKO','DUPSN','PSPRT-ZIXH-50-0','CINCIN PERAK SR03 YL01 ','','3.270','1','100.00','334000','0','0','17800','950000','0','0','0','950000','PUT','00047063','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXH-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.270',berat_jual_asli=berat_jual_asli+'3.270',stock_jual='1',berat_akhir=berat_akhir-'3.270',berat_akhir_asli=berat_akhir_asli-'3.270',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPRT-ZIXH-50-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-260913-0032','2026-09-13','3.270','2026-09-13','19:58:26','PLG0015831','950000','950000','0','950000','0','kasirbip','2026-09-13 19:58:26','FJ-260913-0032','DP-03423','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-09-13','FJ-260913-0032','2026-09-13','19:58:26','PUT','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-260913-0032' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0032';
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-04036','NAD','1','PER','WEDRING','','','4.000','','925.00','2','100000','0','950000','0','950000','sze cwe 13 sze cwo 24 font Berkshire','Grf cwe Khaerul... 04.10.2026','Grf cwo Anisa... 04.10.2026','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0048','2026-09-13','2026-09-13 20:01:40','PESANAN : DP-04036','.','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-260913-0049','D','2026-09-13','20:01:40','TBC','PESANAN','DP-04036','27799870964','950000','27800820964','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-04036','2026-09-13','2026-09-13','20:01:40','PLG0015832','NAD','2026-09-24','kasirbip','2026-09-13 20:01:40','4.000','0','0','0','950000','0','0','950000','950000','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-260913-0033','kasirbip','1',' DP-03562BI','TOKO','BIPPSN','PSPLT-ZIAA-38-0','CINCIN PALADIUM ','','2.140','1','17.00','481000','0','0','17800','1449000','0','0','0','1449000','SULIS','00047148','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIAA-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-09-13' AND kode_barang='PSPLT-ZIAA-38-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-260913-0033','2026-09-13','2.140','2026-09-13','20:25:58','PLG0015833','1449000','1449000','0','1449000','0','kasirbip','2026-09-13 20:25:57','FJ-260913-0033','DP-03562','1400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-13','FJ-260913-0033','2026-09-13','20:25:58','SULIS','1449000','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-260913-0049','2026-09-13','2026-09-13 20:25:57','PENJUALAN : FJ-260913-0033','.','TBC','49000','49000','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-260913-0050','D','2026-09-13','20:25:58','TBC','PENJUALAN','FJ-260913-0033','27800820964','49000','27800869964','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='49000' WHERE no_faktur_jual='FJ-260913-0033' 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-260913-0034','kasirbip',' 1',' DP-03561BI','TOKO','BIPPSN','PSGT-ZIXH-10-0','CINCIN EMAS ','','2.390','1','83.00','4857000','0','0','17800','6897500','0','0','0','6897500','SULIS','00047023','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIXH-10-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-09-13' AND kode_barang='PSGT-ZIXH-10-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-260913-0034','2026-09-13','2.390','2026-09-13','20:25:58','PLG0015834','6897500','6897500','0','6897500','0','kasirbip','2026-09-13 20:25:57','FJ-260913-0033','DP-03561','5716000');
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-09-13','FJ-260913-0034','2026-09-13','20:25:58','SULIS','6897500','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-260913-0050','2026-09-13','2026-09-13 20:25:57','PENJUALAN : FJ-260913-0034','.','TBC','1181500','1181500','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-260913-0051','D','2026-09-13','20:25:58','TBC','PENJUALAN','FJ-260913-0034','27800869964','1181500','27802051464','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='1230500' WHERE no_faktur_jual='FJ-260913-0034' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0033';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0034' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260913-0034' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260913-0034';
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-04037','DIL','1','PER','WEDD RING CUSTOM','','','3.000','','925.00','1','100000','0','1050000','0','1050000','PERMATA 21 BUTIR (DETAIL WA)','SIZE 22 GRF: 09.AH.08 (YASEVA) - KAPITAL','PUTIH GLOSSY FULL','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260913-0051','2026-09-13','2026-09-13 20:34:38','PESANAN : DP-04037','-','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-260913-0052','D','2026-09-13','20:34:38','TBC','PESANAN','DP-04037','27802051464','1050000','27803101464','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-04037','2026-09-13','2026-09-13','20:34:38','PLG0015835','DIL','2026-10-08','sby','2026-09-13 20:34:38','3.000','0','0','0','1050000','0','0','1050000','1050000','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-14','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-13';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-13';
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-09-13' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-13';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-13';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-13';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-13';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-14' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-13' 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-260914-0001','D','2026-09-14','21:07:22','TBC','SALDO AWAL','SALDO AWAL','0','27803101464','27803101464');
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-260914-0001','D','2026-09-14','21:07:22','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-260914-0001','D','2026-09-14','21:07:22','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-260914-0001','D','2026-09-14','21:07:22','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-260914-0001','D','2026-09-14','21:07:22','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-260914-0001','D','2026-09-14','21:07:22','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-260914-0001','D','2026-09-14','21:07:22','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-260914-0001','D','2026-09-14','21:07:22','','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-260914-0001','D','2026-09-14','21:07:22','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-260914-0001','D','2026-09-14','21:07:22','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-260914-0001','D','2026-09-14','21:07:22','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000');
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-260914-0001','D','2026-09-14','21:07:22','BCD','SALDO AWAL','SALDO AWAL','0','1459469500','1459469500');
UPDATE tp_system SET tgl_system='2026-09-14';