INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-27 ','09:35:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-08-27 ','09:57:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-27 ','10:05:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-27 ','10:52:03');
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-250827-0001','kasir','1',' 800K-12-00','TOKO','MMPER','PMM-YGXC-17-0','CINCIN SILVER 925 ','','2.330','1','100.00','55000','0','0','16500','800000','0','0','0','800000','NIS','00036935','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXC-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2025-08-27' AND kode_barang='PMM-YGXC-17-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-250827-0001','2025-08-27','2.330','2025-08-27','12:49:43','PLG0006010','800000','800000','0','800000','0','kasir','2025-08-27 12:49:42','FJ-250827-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-08-27','FJ-250827-0001','2025-08-27','12:49:43','NIS','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250827-0001','2025-08-27','2025-08-27 12:49:42','PENJUALAN : FJ-250827-0001','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250827-0002','D','2025-08-27','12:49:43','TBC','PENJUALAN','FJ-250827-0001','15948184264','800000','15948984264','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-250827-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-250827-0002','kasir','1',' 700K-22-00','TOKO','MMPER','PMM-YFBX-146-0','CINCIN SILVER 925 ','','3.470','1','100.00','80000','0','0','16500','700000','0','0','0','700000','NAD','00036587','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-146-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.470',berat_jual_asli=berat_jual_asli+'3.470',stock_jual='1',berat_akhir=berat_akhir-'3.470',berat_akhir_asli=berat_akhir_asli-'3.470',stock_akhir='0' WHERE tanggal='2025-08-27' AND kode_barang='PMM-YFBX-146-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-250827-0002','2025-08-27','3.470','2025-08-27','12:50:18','PLG0006011','700000','700000','0','700000','0','kasir','2025-08-27 12:50:17','FJ-250827-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-08-27','FJ-250827-0002','2025-08-27','12:50:18','NAD','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-250827-0002','2025-08-27','2025-08-27 12:50:17','PENJUALAN : FJ-250827-0002','.','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-250827-0003','D','2025-08-27','12:50:18','TBC','PENJUALAN','FJ-250827-0002','15948984264','700000','15949684264','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-250827-0002' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-27 ','12:54:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-27 ','13:44:39');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250827-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250827-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-250827-0003','kasir','1',' DP-00957BI','TOKO','BIPPSN','PSPRT-YHAH-8-0','CINCIN PERAK ','','2.330','1','100.00','60000','0','0','16500','700000','0','0','0','700000','SUL','00038208','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YHAH-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2025-08-27' AND kode_barang='PSPRT-YHAH-8-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-250827-0003','2025-08-27','2.330','2025-08-27','14:42:44','PLG0006012','700000','700000','0','700000','0','kasir','2025-08-27 14:42:44','FJ-250827-0003','DP-00957','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-08-27','FJ-250827-0003','2025-08-27','14:42:44','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-250827-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250827-0003';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250827-0004','kasir','1',' 850K-13-00','TOKO','MMPER','PMM-YFBX-44-0','CINCIN SILVER 925 ','','1.800','1','100.00','42000','0','0','16500','850000','0','0','0','850000','NIS','00036485','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2025-08-27' AND kode_barang='PMM-YFBX-44-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-250827-0004','2025-08-27','1.800','2025-08-27','16:11:23','PLG0006013','850000','850000','0','850000','0','kasir','2025-08-27 16:11:23','FJ-250827-0004','','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-08-27','FJ-250827-0004','2025-08-27','16:11:23','NIS','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-250827-0003','2025-08-27','2025-08-27 16:11:23','PENJUALAN : FJ-250827-0004','.','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-250827-0004','D','2025-08-27','16:11:23','TBC','PENJUALAN','FJ-250827-0004','15949684264','850000','15950534264','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-250827-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250827-0005','kasir','1',' 700K-135-0','TOKO','MMPER','PMM-YFBX-88-0','CINCIN SILVER 925 ','','3.250','1','100.00','75000','0','0','16500','700000','0','0','0','700000','NAD','00036529','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-88-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.250',berat_jual_asli=berat_jual_asli+'3.250',stock_jual='1',berat_akhir=berat_akhir-'3.250',berat_akhir_asli=berat_akhir_asli-'3.250',stock_akhir='0' WHERE tanggal='2025-08-27' AND kode_barang='PMM-YFBX-88-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-250827-0005','2025-08-27','3.250','2025-08-27','16:12:00','PLG0006014','700000','700000','0','700000','0','kasir','2025-08-27 16:11:59','FJ-250827-0005','','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-08-27','FJ-250827-0005','2025-08-27','16:12:00','NAD','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-250827-0004','2025-08-27','2025-08-27 16:11:59','PENJUALAN : FJ-250827-0005','.','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-250827-0005','D','2025-08-27','16:12:00','TBC','PENJUALAN','FJ-250827-0005','15950534264','700000','15951234264','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-250827-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-250827-0006','kasir','1',' 700K-20-00','TOKO','MMPER','PMM-YFBC-33-0','CINCIN SILVER 925 ','','3.810','1','100.00','88000','0','0','16500','700000','0','0','0','700000','NIS','00036643','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBC-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.810',berat_jual_asli=berat_jual_asli+'3.810',stock_jual='1',berat_akhir=berat_akhir-'3.810',berat_akhir_asli=berat_akhir_asli-'3.810',stock_akhir='0' WHERE tanggal='2025-08-27' AND kode_barang='PMM-YFBC-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-250827-0006','2025-08-27','3.810','2025-08-27','16:48:18','PLG0006015','700000','700000','0','700000','0','kasir','2025-08-27 16:48:18','FJ-250827-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('2025-08-27','FJ-250827-0006','2025-08-27','16:48:18','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-250827-0005','2025-08-27','2025-08-27 16:48:18','PENJUALAN : FJ-250827-0006','.','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-250827-0006','D','2025-08-27','16:48:18','TBC','PENJUALAN','FJ-250827-0006','15951234264','700000','15951934264','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-250827-0006' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01024','NAD','1','PER','CINCIN NIKAH','','','178.000','','925.00','1','25000','0','850000','','850000','SIZE 7 GRAFIR RENDRA','KRUM PUTIH SESUAI CNTH','','','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250827-0006','2025-08-27','2025-08-27 16:56:31','PESANAN : DP-01024','.','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-250827-0007','D','2025-08-27','16:56:31','TBC','PESANAN','DP-01024','15951934264','850000','15952784264','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-01024','2025-08-27','2025-08-27','16:56:31','PLG0006016','NAD','2025-09-10','kasir','2025-08-27 16:56:31','178.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-01025','NAD','1','PER','CINCIN NIKAH','','','178.000','','925.00','1','25000','0','850000','','850000','SIZE 7 GRAFIR RENDRA','KRUM PUTIH SESUAI CNTH','','','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250827-0007','2025-08-27','2025-08-27 16:56:38','PESANAN : DP-01025','.','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-250827-0008','D','2025-08-27','16:56:38','TBC','PESANAN','DP-01025','15952784264','850000','15953634264','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-01025','2025-08-27','2025-08-27','16:56:38','PLG0006017','NAD','2025-09-10','kasir','2025-08-27 16:56:38','178.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-01198','NISA','1','1 PCS CINCIN SILVER','RESIZE KE 18 KRUM PUTIH SESUAI CNTH GRAFIR ICHA','3.810','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-01198','2025-08-27','2025-08-27','17:01:36','PLG0006018','kasir','2025-08-28','kasir','2025-08-27 17:01:36','3.810','0','0','0','0','0','0','0','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250827-0007','kasir','1',' 700K-17-14','TOKO','BIPPER','PBDG-YFBD-56-0','CINCIN SILVER 925 ','','2.370','1','100.00','55000','0','0','16500','700000','0','0','0','700000','HELMI','00036719','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YFBD-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.370',berat_jual_asli=berat_jual_asli+'2.370',stock_jual='1',berat_akhir=berat_akhir-'2.370',berat_akhir_asli=berat_akhir_asli-'2.370',stock_akhir='0' WHERE tanggal='2025-08-27' AND kode_barang='PBDG-YFBD-56-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-250827-0007','2025-08-27','2.370','2025-08-27','18:34:49','PLG0006019','700000','700000','0','700000','0','kasir','2025-08-27 18:34:48','FJ-250827-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-08-27','FJ-250827-0007','2025-08-27','18:34:49','HELMI','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-250827-0008','2025-08-27','2025-08-27 18:34:48','PENJUALAN : FJ-250827-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-250827-0009','D','2025-08-27','18:34:49','TBC','PENJUALAN','FJ-250827-0007','15953634264','700000','15954334264','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-250827-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-250827-0008','kasir',' 1',' 700K-9-152','TOKO','BIPPER','PBDG-YGCA-13-0','CINCIN SILVER 925 ','','1.170','1','100.00','24000','0','0','16500','700000','0','0','0','700000','HELMI','00037815','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YGCA-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2025-08-27' AND kode_barang='PBDG-YGCA-13-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-250827-0008','2025-08-27','1.170','2025-08-27','18:34:49','PLG0006020','700000','700000','0','700000','0','kasir','2025-08-27 18:34:48','FJ-250827-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-08-27','FJ-250827-0008','2025-08-27','18:34:49','HELMI','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-250827-0009','2025-08-27','2025-08-27 18:34:48','PENJUALAN : FJ-250827-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-250827-0010','D','2025-08-27','18:34:49','TBC','PENJUALAN','FJ-250827-0008','15954334264','700000','15955034264','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-250827-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250827-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250827-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250827-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250827-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250827-0008';
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-01026','SUL','1','PER','WIDDING RING','','','2.000','','925.00','1','25000','0','700000','0','700000','size 24 crum putih doff semprot','1 sirkon. font berkshire swash grafir Dian Aulia','model seperti contoh','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-250827-0010','2025-08-27','2025-08-27 19:07:30','PESANAN : DP-01026','.','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-250827-0011','D','2025-08-27','19:07:30','TBC','PESANAN','DP-01026','15955034264','700000','15955734264','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-01026','2025-08-27','2025-08-27','19:07:30','PLG0006021','SUL','2025-09-10','kasir','2025-08-27 19:07:30','2.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-250827-0009','kasir','1',' 700K-12-13','TOKO','BIPPER','PBDG-YFXD-78-0','CINCIN SILVER 925 ','','1.370','1','100.00','32000','0','0','16500','399000','0','0','0','399000','SUL','00036168','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YFXD-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2025-08-27' AND kode_barang='PBDG-YFXD-78-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-250827-0009','2025-08-27','1.370','2025-08-27','19:44:27','PLG0006022','399000','399000','0','399000','0','kasir','2025-08-27 19:44:26','FJ-250827-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-08-27','FJ-250827-0009','2025-08-27','19:44:27','SUL','399000','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-250827-0011','2025-08-27','2025-08-27 19:44:26','PENJUALAN : FJ-250827-0009','.','TBC','399000','399000','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-250827-0012','D','2025-08-27','19:44:27','TBC','PENJUALAN','FJ-250827-0009','15955734264','399000','15956133264','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='399000' WHERE no_faktur_jual='FJ-250827-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-250827-0010','kasir',' 1',' 500K-14-15','TOKO','BIPPER','PBDG-YHXE-8-0','CINCIN SILVER 925 ','','1.890','1','100.00','49000','0','0','16500','400000','0','0','0','400000','SUL','00037858','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YHXE-8-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='2025-08-27' AND kode_barang='PBDG-YHXE-8-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-250827-0010','2025-08-27','1.890','2025-08-27','19:44:27','PLG0006023','400000','400000','0','400000','0','kasir','2025-08-27 19:44:26','FJ-250827-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-08-27','FJ-250827-0010','2025-08-27','19:44:27','SUL','400000','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-250827-0012','2025-08-27','2025-08-27 19:44:26','PENJUALAN : FJ-250827-0010','.','TBC','400000','400000','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-250827-0013','D','2025-08-27','19:44:27','TBC','PENJUALAN','FJ-250827-0010','15956133264','400000','15956533264','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='799000' WHERE no_faktur_jual='FJ-250827-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250827-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250827-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250827-0010';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-27 ','19:44:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-27 ','20:00:01');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-27';
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-08-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-27';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-27' 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-250828-0001','D','2025-08-28','20:06:50','TBC','SALDO AWAL','SALDO AWAL','0','15956533264','15956533264');
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-250828-0001','D','2025-08-28','20:06:50','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-250828-0001','D','2025-08-28','20:06:50','KET','SALDO AWAL','SALDO AWAL','0','134183000','134183000');
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-250828-0001','D','2025-08-28','20:06:50','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-250828-0001','D','2025-08-28','20:06:50','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-250828-0001','D','2025-08-28','20:06:50','MANDIRI','SALDO AWAL','SALDO AWAL','0','44680000','44680000');
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-250828-0001','D','2025-08-28','20:06:50','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-250828-0001','D','2025-08-28','20:06:50','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-250828-0001','D','2025-08-28','20:06:50','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-250828-0001','D','2025-08-28','20:06:50','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-250828-0001','D','2025-08-28','20:06:50','BCD','SALDO AWAL','SALDO AWAL','0','1329371000','1329371000');
UPDATE tp_system SET tgl_system='2025-08-28';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-27 ','20:10:36');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01199','HELMI','1','CC PLD','KRUM ULANG PUTIH DOFF AMPLAS','5.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-01199','2025-08-28','2025-08-28','20:16:32','PLG0006024','kasir','2025-08-29','kasir','2025-08-27 20:16:32','5.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01200','SULIS','1','SEPASANG CC SLV','KRUM ULANG PUTIH GLOSY','5.000','1','100000','100000');
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-01200','2025-08-28','2025-08-28','20:21:20','PLG0006025','kasir','2025-08-29','kasir','2025-08-27 20:21:20','5.000','0','0','0','0','0','100000','100000','100000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01201','HELMI','1','SEPASANG CC SLV','CEWE JD SIZE 9 COWO JD SIZE 15 KRUM HITAM DOFF AMPLAS DUA DUANYA','5.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-01201','2025-08-28','2025-08-28','20:29:16','PLG0006026','kasir','2025-08-29','kasir','2025-08-27 20:29:16','5.000','0','0','0','0','0','0','0','0');