INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-29 ','10:04:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-29 ','10:48:42');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-29 ','11:54:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-29 ','12:06:20');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01912','SULIS','1','SEPASANG SILVER','SZ CWE 7 PUTIH GLOSY CWO 17 5 PUTIH DOFF AMPLASS','4.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-01912','2026-03-29','2026-03-29','14:51:21','PLG0010182','kasirbip','2026-04-25','kasirbip','2026-03-29 14:51:21','4.000','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-260329-0001','kasirbip','1',' 800K-95-18','TOKO','BIPPER','PBDG-YKBE-17-0','CINCIN SILVER 925 ','','2.210','1','100.00','136000','0','0','17000','700000','0','0','0','700000','SULIS','00039849','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2026-03-29' AND kode_barang='PBDG-YKBE-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-260329-0001','2026-03-29','2.210','2026-03-29','14:54:44','PLG0010183','700000','700000','0','700000','0','kasirbip','2026-03-29 14:54:43','FJ-260329-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('2026-03-29','FJ-260329-0001','2026-03-29','14:54:44','SULIS','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-260329-0001','2026-03-29','2026-03-29 14:54:43','PENJUALAN : FJ-260329-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-260329-0002','D','2026-03-29','14:54:44','TBC','PENJUALAN','FJ-260329-0001','21204270514','700000','21204970514','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-260329-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-260329-0002','kasirbip',' 1',' 500K-21-21','TOKO','BIPPER','PBDG-ZAAI-35-0','CINCIN SILVER 925 ','','2.080','1','100.00','128000','0','0','17000','500000','0','0','0','500000','SULIS','00041017','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZAAI-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-03-29' AND kode_barang='PBDG-ZAAI-35-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-260329-0002','2026-03-29','2.080','2026-03-29','14:54:44','PLG0010184','500000','500000','0','500000','0','kasirbip','2026-03-29 14:54:43','FJ-260329-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('2026-03-29','FJ-260329-0002','2026-03-29','14:54:44','SULIS','500000','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-260329-0002','2026-03-29','2026-03-29 14:54:43','PENJUALAN : FJ-260329-0002','.','TBC','500000','500000','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-260329-0003','D','2026-03-29','14:54:44','TBC','PENJUALAN','FJ-260329-0002','21204970514','500000','21205470514','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='1200000' WHERE no_faktur_jual='FJ-260329-0002' 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-01867','MIA','1','PLD','WED RING','','','2.000','','10.00','1','1200000','300000','0','750000','1350000','20 zirkon putih glosy','font brush script','grf Fikri & Ira','200000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260329-0003','2026-03-29','2026-03-29 15:20:25','PESANAN : DP-01867','.','TBC','1240000','1240000');
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-260329-0004','D','2026-03-29','15:20:25','TBC','PESANAN','DP-01867','21205470514','1240000','21206710514','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-01867','2026-03-29','2026-03-29','15:20:25','PLG0010185','MIA','2026-05-06','kasirbip','2026-03-29 15:20:25','2.000','0','0','0','1240000','0','750000','1550000','1550000','310000');
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-01868','MIA','1','PLD','WED RING','','','2.000','','10.00','1','1200000','300000','0','700000','1300000','sz 15.5 putih glosy combo doft semprot','font brush script','grf Fikri & Ira','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260329-0004','2026-03-29','2026-03-29 15:23:15','PESANAN : DP-01868','.','TBC','1040000','1040000');
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-260329-0005','D','2026-03-29','15:23:15','TBC','PESANAN','DP-01868','21206710514','1040000','21207750514','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-01868','2026-03-29','2026-03-29','15:23:15','PLG0010186','MIA','2026-05-06','kasirbip','2026-03-29 15:23:15','2.000','0','0','0','1040000','0','700000','1300000','1300000','260000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-29 ','15:27:41');
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='' 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-260329-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260329-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260329-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260329-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260329-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260329-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-260329-0003','kasirbip','1',' PLBDG-0015','TOKO','BIPPLD','PLBDG-ZBXB-1-0','CINCIN PALADIUM PLBDG-00154 ','','1.080','1','17.00','243000','0','0','17000','1024000','0','0','0','1024000','SULIS','00041270','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZBXB-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-03-29' AND kode_barang='PLBDG-ZBXB-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260329-0003','2026-03-29','1.080','2026-03-29','15:28:55','PLG0010187','1024000','1024000','0','1024000','0','kasirbip','2026-03-29 15:28:55','FJ-260329-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-03-29','FJ-260329-0003','2026-03-29','15:28:55','SULIS','1024000','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-260329-0005','2026-03-29','2026-03-29 15:28:55','PENJUALAN : FJ-260329-0003','.','TBC','1024000','1024000','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-260329-0006','D','2026-03-29','15:28:55','TBC','PENJUALAN','FJ-260329-0003','21207750514','1024000','21208774514','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='1024000' WHERE no_faktur_jual='FJ-260329-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-260329-0004','kasirbip',' 1',' PLBDG-0015','TOKO','BIPPLD','PLBDG-ZBXB-2-0','CINCIN PALADIUM PLBDG-00155 ','','1.230','1','17.00','277000','0','0','17000','1069000','0','0','0','1069000','SULIS','00041271','PLBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZBXB-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-03-29' AND kode_barang='PLBDG-ZBXB-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260329-0004','2026-03-29','1.230','2026-03-29','15:28:55','PLG0010188','1069000','1069000','0','1069000','0','kasirbip','2026-03-29 15:28:55','FJ-260329-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-03-29','FJ-260329-0004','2026-03-29','15:28:55','SULIS','1069000','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-260329-0006','2026-03-29','2026-03-29 15:28:55','PENJUALAN : FJ-260329-0004','.','TBC','1069000','1069000','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-260329-0007','D','2026-03-29','15:28:55','TBC','PENJUALAN','FJ-260329-0004','21208774514','1069000','21209843514','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='2093000' WHERE no_faktur_jual='FJ-260329-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260329-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260329-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260329-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260329-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260329-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260329-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-01869','GIN','1','PLD','WED RING','','','2.500','','10.00','1','1200000','300000','0','700000','1450000','tanpa permata hitam doff semprot comb hitam glossy','sz 17 font bershike swash','grafir Diana','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260329-0007','2026-03-29','2026-03-29 15:59:04','PESANAN : DP-01869','.','TBC','1160000','1160000');
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-260329-0008','D','2026-03-29','15:59:04','TBC','PESANAN','DP-01869','21209843514','1160000','21211003514','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-01869','2026-03-29','2026-03-29','15:59:04','PLG0010189','GIN','2026-04-29','kasirbip','2026-03-29 15:59:04','2.500','0','0','0','1160000','0','700000','1450000','1450000','290000');
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-01870','MIA','1','PER','WED RING','','','5.000','','925.00','1','100000','0','1700000','','1700000','cwe sz 15 grf Dafi','cwo sz 17 grf Teli model spt contoh','font berkshine swash keduanya putih doff amplass','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260329-0008','2026-03-29','2026-03-29 16:27:20','PESANAN : DP-01870','.','TBC','1700000','1700000');
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-260329-0009','D','2026-03-29','16:27:20','TBC','PESANAN','DP-01870','21211003514','1700000','21212703514','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-01870','2026-03-29','2026-03-29','16:27:20','PLG0010190','MIA','2026-05-06','kasirbip','2026-03-29 16:27:20','5.000','0','0','0','1700000','0','0','1700000','1700000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01913','GIN','1','CC SILVER','PASANG PERMATA PUTIH DOFF SEMPROT','2.000','1','50000','50000');
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-260329-0009','2026-03-29','2026-03-29 19:47:31','SERVICE : SV-01913','.','TBC','50000','50000','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-260329-0010','D','2026-03-29','19:47:31','TBC','SERVICE','SV-01913','21212703514','50000','21212753514','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-01913','2026-03-29','2026-03-29','19:47:31','PLG0010191','kasirbip','2026-03-25','kasirbip','2026-03-29 19:47:31','2.000','0','0','0','50000','0','50000','50000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-29 ','19:47:47');