INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-05 ','10:20:25');
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-251105-0001','kasir','1',' 700K-17-00','TOKO','MMPER','PBSD-YGCX-39-0','CINCIN SILVER 925 ','','3.280','1','100.00','68000','0','0','16600','700000','0','0','0','700000','NIS','00037778','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGCX-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.280',berat_jual_asli=berat_jual_asli+'3.280',stock_jual='1',berat_akhir=berat_akhir-'3.280',berat_akhir_asli=berat_akhir_asli-'3.280',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PBSD-YGCX-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251105-0001','2025-11-05','3.280','2025-11-05','10:22:20','PLG0007382','700000','700000','0','700000','0','kasir','2025-11-05 10:22:19','FJ-251105-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','FJ-251105-0001','2025-11-05','10:22:20','NIS','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251105-0002','2025-11-05','2025-11-05 10:22:19','PENJUALAN : FJ-251105-0001','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251105-0003','D','2025-11-05','10:22:20','TBC','PENJUALAN','FJ-251105-0001','17762382314','700000','17763082314','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='700000' WHERE no_faktur_jual='FJ-251105-0001' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01411','NIS','1','1PCS CINCIN SLV','RESIZE KE 16 5 GRF CIWUL 07 12 25','3.280','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01411','2025-11-05','2025-11-05','10:27:15','PLG0007383','kasir','2025-11-06','kasir','2025-11-05 10:27:15','3.280','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-05 ','10:49:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-05 ','11:11:14');
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-251105-0002','kasir','1',' 850K-12-11','TOKO','BIPPER','PBDG-YEBB-64-0','CINCIN SILVER 925 ','','1.760','1','100.00','41000','0','0','16600','850000','0','0','0','850000','HELMI','00035767','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YEBB-64-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PBDG-YEBB-64-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-251105-0002','2025-11-05','1.760','2025-11-05','11:12:29','PLG0007384','850000','850000','0','850000','0','kasir','2025-11-05 11:12:28','FJ-251105-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','FJ-251105-0002','2025-11-05','11:12:29','HELMI','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-251105-0003','2025-11-05','2025-11-05 11:12:28','PENJUALAN : FJ-251105-0002','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251105-0004','D','2025-11-05','11:12:29','TBC','PENJUALAN','FJ-251105-0002','17763082314','850000','17763932314','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-251105-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251104-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251104-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251105-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251105-0002';
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-251105-0003','kasir','1',' 750K-12-10','TOKO','BIPPER','PBDG-YEBA-23-0','CINCIN SILVER 925 ','','1.630','1','100.00','38000','0','0','16600','750000','0','0','0','750000','SUL','00035671','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YEBA-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PBDG-YEBA-23-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-251105-0003','2025-11-05','1.630','2025-11-05','13:21:07','PLG0007385','750000','750000','0','750000','0','kasir','2025-11-05 13:21:07','FJ-251105-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('2025-11-05','FJ-251105-0003','2025-11-05','13:21:07','SUL','750000','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-251105-0004','2025-11-05','2025-11-05 13:21:07','PENJUALAN : FJ-251105-0003','.','TBC','750000','750000','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-251105-0005','D','2025-11-05','13:21:07','TBC','PENJUALAN','FJ-251105-0003','17763932314','750000','17764682314','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='750000' WHERE no_faktur_jual='FJ-251105-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-251105-0004','kasir',' 1',' 700K-19-16','TOKO','BIPPER','PBDG-YJXC-17-0','CINCIN SILVER 925 ','','4.540','1','100.00','116000','0','0','16600','700000','0','0','0','700000','SUL','00038988','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YJXC-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.540',berat_jual_asli=berat_jual_asli+'4.540',stock_jual='1',berat_akhir=berat_akhir-'4.540',berat_akhir_asli=berat_akhir_asli-'4.540',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PBDG-YJXC-17-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-251105-0004','2025-11-05','4.540','2025-11-05','13:21:07','PLG0007386','700000','700000','0','700000','0','kasir','2025-11-05 13:21:07','FJ-251105-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('2025-11-05','FJ-251105-0004','2025-11-05','13:21:07','SUL','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251105-0005','2025-11-05','2025-11-05 13:21:07','PENJUALAN : FJ-251105-0004','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251105-0006','D','2025-11-05','13:21:07','TBC','PENJUALAN','FJ-251105-0004','17764682314','700000','17765382314','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='1450000' WHERE no_faktur_jual='FJ-251105-0004' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01349','SULIS','1','PER','WEDDING RING','','','1.000','','925.00','1','60000','0','700000','0','700000','sz 14 crom putih glosy. 1 zircon','font vintage rotter grf Hendri','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251105-0006','2025-11-05','2025-11-05 13:30:07','PESANAN : DP-01349','.','TBC','700000','700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251105-0007','D','2025-11-05','13:30:07','TBC','PESANAN','DP-01349','17765382314','700000','17766082314','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-01349','2025-11-05','2025-11-05','13:30:07','PLG0007387','SULIS','2025-11-25','kasir','2025-11-05 13:30:07','1.000','0','0','0','700000','0','0','700000','700000','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-01350','SULIS','1','PER','WEDDING RING','','','1.000','','925.00','1','60000','0','700000','0','700000','sz 12 crom putih glosy','font vintage rotter','grf Novi','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251105-0007','2025-11-05','2025-11-05 13:31:55','PESANAN : DP-01350','.','TBC','700000','700000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251105-0008','D','2025-11-05','13:31:55','TBC','PESANAN','DP-01350','17766082314','700000','17766782314','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-01350','2025-11-05','2025-11-05','13:31:55','PLG0007388','SULIS','2025-11-25','kasir','2025-11-05 13:31:55','1.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01412','SULIS','1','SEPASANG SILVER','CWO SZ 22 JGN DIBUAT TIPIS FONT VINTAGE ROTTER','6.000','1','100000','100000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251105-0008','2025-11-05','2025-11-05 13:34:20','SERVICE : SV-01412','.','TBC','100000','100000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251105-0009','D','2025-11-05','13:34:20','TBC','SERVICE','SV-01412','17766782314','100000','17766882314','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-01412','2025-11-05','2025-11-05','13:34:20','PLG0007389','kasir','2025-11-13','kasir','2025-11-05 13:34:20','6.000','0','0','0','100000','0','100000','100000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-05 ','13:34:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-05 ','14:08:21');
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-251105-0005','kasir','1',' DP-01247BI','TOKO','BIPPSN','PSPRT-YJBD-15-0','CINCIN PERAK ','','3.840','1','100.00','236000','0','0','16600','700000','0','0','0','700000','SUL','00039297','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YJBD-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.840',berat_jual_asli=berat_jual_asli+'3.840',stock_jual='1',berat_akhir=berat_akhir-'3.840',berat_akhir_asli=berat_akhir_asli-'3.840',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PSPRT-YJBD-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251105-0005','2025-11-05','3.840','2025-11-05','14:23:22','PLG0007390','700000','700000','0','700000','0','kasir','2025-11-05 14:23:22','FJ-251105-0005','DP-01247','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','FJ-251105-0005','2025-11-05','14:23:22','SUL','700000','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-251105-0005' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251105-0006','kasir',' 1',' DP-01248BI','TOKO','BIPPSN','PSPRT-YJBH-16-0','CINCIN PERAK ','','1.840','1','100.00','113000','0','0','16600','950000','0','0','0','950000','SUL','00039324','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YJBH-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.840',berat_jual_asli=berat_jual_asli+'1.840',stock_jual='1',berat_akhir=berat_akhir-'1.840',berat_akhir_asli=berat_akhir_asli-'1.840',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PSPRT-YJBH-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251105-0006','2025-11-05','1.840','2025-11-05','14:23:22','PLG0007391','950000','950000','0','950000','0','kasir','2025-11-05 14:23:22','FJ-251105-0005','DP-01248','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('2025-11-05','FJ-251105-0006','2025-11-05','14:23:22','SUL','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-251105-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251105-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251105-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251105-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251105-0006';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251105-0007','kasir','1',' 700K-20-17','TOKO','BIPPER','PBDG-YJBH-26-0','CINCIN SILVER 925 ','','4.720','1','100.00','290000','0','0','16600','700000','0','0','0','700000','SUL','00039334','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YJBH-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.720',berat_jual_asli=berat_jual_asli+'4.720',stock_jual='1',berat_akhir=berat_akhir-'4.720',berat_akhir_asli=berat_akhir_asli-'4.720',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PBDG-YJBH-26-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-251105-0007','2025-11-05','4.720','2025-11-05','17:13:38','PLG0007392','700000','700000','0','700000','0','kasir','2025-11-05 17:13:38','FJ-251105-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','FJ-251105-0007','2025-11-05','17:13:38','SUL','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251105-0009','2025-11-05','2025-11-05 17:13:38','PENJUALAN : FJ-251105-0007','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251105-0010','D','2025-11-05','17:13:38','TBC','PENJUALAN','FJ-251105-0007','17766882314','700000','17767582314','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='700000' WHERE no_faktur_jual='FJ-251105-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-251105-0008','kasir',' 1',' 700K-9-170','TOKO','BIPPER','PBDG-YJBH-25-0','CINCIN SILVER 925 ','','2.490','1','100.00','153000','0','0','16600','700000','0','0','0','700000','SUL','00039333','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YJBH-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.490',berat_jual_asli=berat_jual_asli+'2.490',stock_jual='1',berat_akhir=berat_akhir-'2.490',berat_akhir_asli=berat_akhir_asli-'2.490',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PBDG-YJBH-25-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-251105-0008','2025-11-05','2.490','2025-11-05','17:13:38','PLG0007393','700000','700000','0','700000','0','kasir','2025-11-05 17:13:38','FJ-251105-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','FJ-251105-0008','2025-11-05','17:13:38','SUL','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251105-0010','2025-11-05','2025-11-05 17:13:38','PENJUALAN : FJ-251105-0008','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251105-0011','D','2025-11-05','17:13:38','TBC','PENJUALAN','FJ-251105-0008','17767582314','700000','17768282314','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='1400000' WHERE no_faktur_jual='FJ-251105-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251105-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251105-0008';
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-251105-0009','kasir','1',' 750K-11-00','TOKO','MMPER','PMM-YFBX-23-0','CINCIN SILVER 925 ','','1.850','1','100.00','43000','0','0','16600','750000','0','0','0','750000','NIS','00036464','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PMM-YFBX-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251105-0009','2025-11-05','1.850','2025-11-05','18:31:49','PLG0007394','750000','750000','0','750000','0','kasir','2025-11-05 18:31:48','FJ-251105-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','FJ-251105-0009','2025-11-05','18:31:49','NIS','750000','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-251105-0011','2025-11-05','2025-11-05 18:31:48','PENJUALAN : FJ-251105-0009','.','TBC','750000','750000','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-251105-0012','D','2025-11-05','18:31:49','TBC','PENJUALAN','FJ-251105-0009','17768282314','750000','17769032314','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='750000' WHERE no_faktur_jual='FJ-251105-0009' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251105-0010','kasir','1',' 700K-15-00','TOKO','MMPER','PBSD-YGBD-12-0','CINCIN SILVER 925 ','','2.430','1','100.00','50000','0','0','16600','700000','0','0','0','700000','GEISYA','00037474','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBD-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.430',berat_jual_asli=berat_jual_asli+'2.430',stock_jual='1',berat_akhir=berat_akhir-'2.430',berat_akhir_asli=berat_akhir_asli-'2.430',stock_akhir='0' WHERE tanggal='2025-11-05' AND kode_barang='PBSD-YGBD-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251105-0010','2025-11-05','2.430','2025-11-05','18:33:48','PLG0007395','700000','700000','0','700000','0','kasir','2025-11-05 18:33:47','FJ-251105-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-05','FJ-251105-0010','2025-11-05','18:33:48','GEISYA','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251105-0012','2025-11-05','2025-11-05 18:33:47','PENJUALAN : FJ-251105-0010','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251105-0013','D','2025-11-05','18:33:48','TBC','PENJUALAN','FJ-251105-0010','17769032314','700000','17769732314','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='700000' WHERE no_faktur_jual='FJ-251105-0010' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01413','NIS','1','2PCS CINCIN SLV','CEWE RESIZE KE 19 GRF IBNU 11 11 2025 DAN COWO RESIZE KE 21 GRF YUNITA 11 11 2025','4.010','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-251105-0013','2025-11-05','2025-11-05 18:37:03','SERVICE : SV-01413','.','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-251105-0014','D','2025-11-05','18:37:03','TBC','SERVICE','SV-01413','17769732314','150000','17769882314','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-01413','2025-11-05','2025-11-05','18:37:03','PLG0007396','kasir','2025-11-06','kasir','2025-11-05 18:37:03','4.010','0','0','0','150000','0','150000','150000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-05 ','18:37:31');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01414','HELMI','1','CC SILVER','JD SZ 11 5 CROM SPT ASAL','2.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01414','2025-11-05','2025-11-05','18:48:12','PLG0007397','kasir','2025-11-14','kasir','2025-11-05 18:48:12','2.000','0','0','0','0','0','0','0','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-01351','SULIS','1','PER','WEDDING RING','','','2.000','','925.00','1','60000','0','799000','0','799000','cwe sz 12. crom putih glosy. grf EGA','cwo sz 20 crom putih doff amplas. grf UTAMI','font yeseva one','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251105-0014','2025-11-05','2025-11-05 18:54:37','PESANAN : DP-01351','.','TBC','799000','799000');
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-251105-0015','D','2025-11-05','18:54:37','TBC','PESANAN','DP-01351','17769882314','799000','17770681314','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-01351','2025-11-05','2025-11-05','18:54:37','PLG0007398','SULIS','2025-11-25','kasir','2025-11-05 18:54:37','2.000','0','0','0','799000','0','0','799000','799000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251105-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251105-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251105-0010';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-06';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-05';
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='2025-11-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-05';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-05' 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-251106-0001','D','2025-11-06','20:04:54','TBC','SALDO AWAL','SALDO AWAL','0','17770681314','17770681314');
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-251106-0001','D','2025-11-06','20:04:54','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-251106-0001','D','2025-11-06','20:04:54','SHO','SALDO AWAL','SALDO AWAL','0','141465650','141465650');
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-251106-0001','D','2025-11-06','20:04:54','TOP','SALDO AWAL','SALDO AWAL','0','253907000','253907000');
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-251106-0001','D','2025-11-06','20:04:54','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-251106-0001','D','2025-11-06','20:04:54','BCK','SALDO AWAL','SALDO AWAL','0','1927708000','1927708000');
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-251106-0001','D','2025-11-06','20:04:54','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-251106-0001','D','2025-11-06','20:04:54','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-251106-0001','D','2025-11-06','20:04:54','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-251106-0001','D','2025-11-06','20:04:54','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
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-251106-0001','D','2025-11-06','20:04:54','BCD','SALDO AWAL','SALDO AWAL','0','1334821000','1334821000');
UPDATE tp_system SET tgl_system='2025-11-06';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-05 ','20:11:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-05 ','20:28:33');
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-01352','HELMI','1','PLD','WEDDING RING','','','2.000','','10.00','1','2140000','250000','0','700000','1200000','size 9 grf Adellia','model spt contoh','krum putih glosy','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251106-0001','2025-11-06','2025-11-05 20:31:23','PESANAN : DP-01352','.','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-251106-0002','D','2025-11-06','20:31:23','TBC','PESANAN','DP-01352','17770681314','600000','17771281314','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-01352','2025-11-06','2025-11-06','20:31:23','PLG0007399','HELMI','2025-11-25','kasir','2025-11-05 20:31:23','2.000','0','0','0','600000','0','700000','1200000','1200000','600000');
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-01353','HELMI','1','PLD','WEDDING RING','','','1.500','','10.00','1','2140000','250000','0','750000','1125000','zirkon 2butir','size 12 grf Akmal','krum putih glosy','20000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251106-0002','2025-11-06','2025-11-05 20:33:28','PESANAN : DP-01353','.','TBC','572500','572500');
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-251106-0003','D','2025-11-06','20:33:28','TBC','PESANAN','DP-01353','17771281314','572500','17771853814','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-01353','2025-11-06','2025-11-06','20:33:28','PLG0007400','HELMI','2025-11-25','kasir','2025-11-05 20:33:28','1.500','0','0','0','572500','0','750000','1145000','1145000','572500');