INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-06 ','10:13:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-06 ','11:38:13');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07825','FAISAL','1','CBRE','LISTRING PASANG MATA DAN SOLITER CROM ULANG PUTIH','1.740','1','125000','125000');
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-251106-0001','2025-11-06','2025-11-06 11:41:27','SERVICE : SV-07825','-','TBC','125000','125000','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-251106-0002','D','2025-11-06','11:41:27','TBC','SERVICE','SV-07825','92877781520','125000','92877906520','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-07825','2025-11-06','2025-11-06','11:41:27','PLG0027234','kasir','2025-11-07','kasir','2025-11-06 11:41:27','1.740','0','0','0','125000','0','125000','125000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-06 ','14:23:51');
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 ('FE-251106-0001','kasir','1',' CBRE-06922','TOKO','CBR','CBRE-YKXC-5-0','CINCIN CBRE-06922 ','','1.640','1','75.00','4102000','1096000','66','16700','4900000','0','0','0','4900000','NANA','00039392','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-YKXC-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.640',berat_jual_asli=berat_jual_asli+'1.640',stock_jual='1',berat_akhir=berat_akhir-'1.640',berat_akhir_asli=berat_akhir_asli-'1.640',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='CBRE-YKXC-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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 ('FE-251106-0001','2025-11-06','1.640','2025-11-06','14:25:38','PLG0027235','4900000','4900000','0','4900000','0','kasir','2025-11-06 14:25:38','FE-251106-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-06','FE-251106-0001','2025-11-06','14:25:38','NANA','4900000','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-251106-0002','2025-11-06','2025-11-06 14:25:38','PENJUALAN : FE-251106-0001','.','DPE','4900000','4900000','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-251106-0002','D','2025-11-06','14:25:38','DPE','PENJUALAN BERLIAN','FE-251106-0001','218672800','4900000','223572800','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='4900000' WHERE no_faktur_jual='FE-251106-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251106-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251106-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251106-0001';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07826','NANA','1','CBRE06922','RESIZE KE SIZE 8 CROM PUTIH','1.640','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-07826','2025-11-06','2025-11-06','14:29:38','PLG0027236','kasir','2025-11-08','kasir','2025-11-06 14:29:38','1.640','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-06 ','15:05:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-06 ','15:06:58');
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YJXF-23-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YJXF-23-0','CBRE-YJXF-23-0','00039029','RD','13','0.720','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YJXF-23-0','00039029','RD','13','0.720','320','230.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YJXF-23-0','CBRE-YJXF-23-0','00039029','RD','36','0.900','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YJXF-23-0','00039029','RD','36','0.900','320','288')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-YJXF-23-0','00039029','00039029','CINCIN CBRE-03308 ','CINCIN CBRE-03308','','','12310500','12310500',' 0','0','spv','2025-11-06 15:09:33');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-03308' ,nama_atribut='' ,kode_intern='CBRE-03308 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1126 1125 17B6',total_usd_ext='IDB 72 000 000',total_usd='518.4' WHERE kode_barang='CBRE-YJXF-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YDBA-13-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBA-13-0','CBRE-YDBA-13-0','00035107','RD','113','1.440','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBA-13-0','00035107','RD','113','1.440','420','604.8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-YDBA-13-0','00035107','00035107','CINCIN CBRE-00107 ','CINCIN CBRE-00107','','','10533000','10533000',' 0','0','spv','2025-11-06 15:11:39');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-00107' ,nama_atribut='' ,kode_intern='CBRE-00107 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1125',total_usd_ext='IDB 71 000 000',total_usd='604.8' WHERE kode_barang='CBRE-YDBA-13-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-06 ','15:12:25');
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YCXC-6-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YCXC-6-0','CBRE-YCXC-6-0','00034468','RD','6','0.460','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YCXC-6-0','00034468','RD','6','0.460','450','207')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-YCXC-6-0','00034468','00034468','CINCIN CBRE-06351','CINCIN CBRE-06351','','','6874000','6874000',' 0','0','spv','2025-11-06 15:13:37');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06351' ,nama_atribut='' ,kode_intern='CBRE-06351 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C744 16 1125',total_usd_ext='IDB 39 000 000',total_usd='207' WHERE kode_barang='CBRE-YCXC-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YHXD-3-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHXD-3-0','CBRE-YHXD-3-0','00037844','RD','6','0.110','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHXD-3-0','00037844','RD','6','0.110','320','35.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHXD-3-0','CBRE-YHXD-3-0','00037844','RD','19','0.680','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHXD-3-0','00037844','RD','19','0.680','320','217.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHXD-3-0','CBRE-YHXD-3-0','00037844','RD','156','0.410','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHXD-3-0','00037844','RD','156','0.410','320','131.2')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-YHXD-3-0','00037844','00037844','CINCIN CBRE-01029','CINCIN CBRE-01029','','','11347500','11347500',' 0','0','spv','2025-11-06 15:16:11');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-01029' ,nama_atribut='' ,kode_intern='CBRE-01029 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1125',total_usd_ext='IDB 61 500 000',total_usd='384' WHERE kode_barang='CBRE-YHXD-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YHAC-16-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHAC-16-0','CBRE-YHAC-16-0','00037965','RD','12','0.225','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-16-0','00037965','RD','12','0.225','420','94.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHAC-16-0','CBRE-YHAC-16-0','00037965','RD','6','0.085','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-16-0','00037965','RD','6','0.085','420','35.7')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHAC-16-0','CBRE-YHAC-16-0','00037965','RD','1','0.030','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-16-0','00037965','RD','1','0.030','360','10.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHAC-16-0','CBRE-YHAC-16-0','00037965','RD','94','0.500','390');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-16-0','00037965','RD','94','0.500','390','195')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-YHAC-16-0','00037965','00037965','CINCIN CBRE-06862 ','CINCIN CBRE-06862','','','9094500','9094500',' 0','0','spv','2025-11-06 15:18:22');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06862' ,nama_atribut='' ,kode_intern='CBRE-06862 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1422 13 1125',total_usd_ext='IDR 55 000 000',total_usd='336' WHERE kode_barang='CBRE-YHAC-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WHXG-3-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WHXG-3-0','CBRE-WHXG-3-0','00023351','BD','16','0.310','40');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WHXG-3-0','00023351','BD','16','0.310','40','12.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WHXG-3-0','CBRE-WHXG-3-0','00023351','RD','1','0.185','900');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WHXG-3-0','00023351','RD','1','0.185','900','166.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WHXG-3-0','CBRE-WHXG-3-0','00023351','RD','8','0.270','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WHXG-3-0','00023351','RD','8','0.270','420','113.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WHXG-3-0','CBRE-WHXG-3-0','00023351','RD','85','0.405','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WHXG-3-0','00023351','RD','85','0.405','420','170.1')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-WHXG-3-0','00023351','00023351','CINCIN CBRE-05760','CINCIN CBRE-05760','','','9396500','9396500',' 0','0','spv','2025-11-06 15:21:02');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05760' ,nama_atribut='' ,kode_intern='CBRE-05760 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1125',total_usd_ext='IDR 73 500 000',total_usd='462.4' WHERE kode_barang='CBRE-WHXG-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YDAF-4-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDAF-4-0','CBRE-YDAF-4-0','00035009','RD','1','0.300','1050');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAF-4-0','00035009','RD','1','0.300','1050','315')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDAF-4-0','CBRE-YDAF-4-0','00035009','RD','8','0.370','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAF-4-0','00035009','RD','8','0.370','480','177.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDAF-4-0','CBRE-YDAF-4-0','00035009','RD','76','0.400','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAF-4-0','00035009','RD','76','0.400','450','180')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-YDAF-4-0','00035009','00035009','CINCIN CBRE-04121 ','CINCIN CBRE-04121','','','11883000','11883000',' 0','0','spv','2025-11-06 15:23:12');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-04121' ,nama_atribut='' ,kode_intern='CBRE-04121 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1174 RS16 1125',total_usd_ext='IDB 79 000 000',total_usd='672.6' WHERE kode_barang='CBRE-YDAF-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XEAX-37-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XEAX-37-0','CBRE-XEAX-37-0','00028318','RD','1','0.080','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XEAX-37-0','00028318','RD','1','0.080','620','49.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XEAX-37-0','CBRE-XEAX-37-0','00028318','RD','6','0.240','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XEAX-37-0','00028318','RD','6','0.240','480','115.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XEAX-37-0','CBRE-XEAX-37-0','00028318','RD','92','0.610','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XEAX-37-0','00028318','RD','92','0.610','450','274.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-XEAX-37-0','00028318','00028318','CINCIN CBRE-05813','CINCIN CBRE-05813','','','13144000','13144000',' 0','0','spv','2025-11-06 15:25:58');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05813' ,nama_atribut='' ,kode_intern='CBRE-05813 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1125',total_usd_ext='IDB 75 000 000',total_usd='439.3' WHERE kode_barang='CBRE-XEAX-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YGBB-40-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-40-0','CBRE-YGBB-40-0','00037441','RD','13','0.230','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-40-0','00037441','RD','13','0.230','360','82.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-40-0','CBRE-YGBB-40-0','00037441','RD','6','0.055','380');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-40-0','00037441','RD','6','0.055','380','20.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-40-0','CBRE-YGBB-40-0','00037441','RD','6','0.295','370');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-40-0','00037441','RD','6','0.295','370','109.15')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-40-0','CBRE-YGBB-40-0','00037441','RD','2','0.155','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-40-0','00037441','RD','2','0.155','620','96.1')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-YGBB-40-0','00037441','00037441','CINCIN CBRE-06802 ','CINCIN CBRE-06802','','','7336000','7336000',' 0','0','spv','2025-11-06 15:28:04');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06802' ,nama_atribut='' ,kode_intern='CBRE-06802 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1430 16 1125',total_usd_ext='IDR 47 000 000',total_usd='308.95' WHERE kode_barang='CBRE-YGBB-40-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XBXB-24-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XBXB-24-0','CBRE-XBXB-24-0','00026393','RD','17','0.530','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXB-24-0','00026393','RD','17','0.530','420','222.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XBXB-24-0','CBRE-XBXB-24-0','00026393','RD','72','0.240','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXB-24-0','00026393','RD','72','0.240','420','100.8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-XBXB-24-0','00026393','00026393','CINCIN CBRE-01888','CINCIN CBRE-01888','','','8082000','8082000',' 0','0','spv','2025-11-06 15:29:45');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-01888' ,nama_atribut='' ,kode_intern='CBRE-01888 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 11 5 1125',total_usd_ext='IDB 52 000 000',total_usd='323.4' WHERE kode_barang='CBRE-XBXB-24-0' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008855','X-00008855','KALUNG BERLIAN CLARISSA','GR','---','PSN','BELI','BELI001','8799200','2025-11-06','5.100','1','kasir','2025-11-06 16:03:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-PSN';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PSN','X-00008855','X-00008855');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251106-0001','FE-220224-0013','ASRI','1','BELI','BELI001','PSN', 'X-00008855', 'KALUNG BERLIAN CLARISSA','5.100','5.100','83.00','10999000','8799200','1725333','1','8799200','8799200','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.100',berat_beli_asli=berat_beli_asli+'5.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.100',berat_akhir_asli=berat_akhir_asli+'5.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PSN' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-251106-0001','2025-11-06','2025-11-06','16:03:25','ASRI','---','5.100','8799200','8799200','8799200','8799200','8799200','kasir','2025-11-06 16:03:26','BE-251106-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251106-0001','THINA','JAKARTA','JAKARTA','','0812885999280','kasir','2025-11-06 16:03:26');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251106-0003','2025-11-06','2025-11-06 16:03:26','PEMBELIAN UMUM : BE-251106-0001','.','TBC','8799200','8799200');
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 ('KK-251106-0003','K','2025-11-06','16:03:25','TBC','PEMBELIAN UMUM','BE-251106-0001','92877906520','8799200','92869107320','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008856','X-00008856','CINCIN CBRE-02814','GR','---','CBRE','BELI','BELI001','12800000','2025-11-06','4.540','1','kasir','2025-11-06 16:07:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00008856','X-00008856');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251106-0002','FE-241028-0003','ASRI','1','BELI','BELI001','CBRE', 'X-00008856', 'CINCIN CBRE-02814','4.540','4.540','83.00','16000000','12800000','2819383','1','12800000','12800000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.540',berat_beli_asli=berat_beli_asli+'4.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.540',berat_akhir_asli=berat_akhir_asli+'4.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-251106-0002','2025-11-06','2025-11-06','16:07:46','ASRI','---','4.540','12800000','12800000','12800000','12800000','12800000','kasir','2025-11-06 16:07:47','BE-251106-0002','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251106-0002','NILA ADITYA DEVI','-','','','-','kasir','2025-11-06 16:07:47');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251106-0004','2025-11-06','2025-11-06 16:07:47','PEMBELIAN UMUM : BE-251106-0002','.','TBC','12800000','12800000');
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 ('KK-251106-0004','K','2025-11-06','16:07:46','TBC','PEMBELIAN UMUM','BE-251106-0002','92869107320','12800000','92856307320','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008857','X-00008857','CINCIN BERLIAN BALIK','GR','---','CBR','BELI','BELI001','5304000','2025-11-06','3.680','1','kasir','2025-11-06 16:07:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBR';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBR','X-00008857','X-00008857');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251106-0003','-','ASRI','2','BELI','BELI001','CBR', 'X-00008857', 'CINCIN BERLIAN BALIK','0.000','3.680','75.00','0','5304000','1441304','1','5304000','5304000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.680',berat_beli_asli=berat_beli_asli+'3.680',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.680',berat_akhir_asli=berat_akhir_asli+'3.680',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBR' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-251106-0003','2025-11-06','2025-11-06','16:07:46','ASRI','---','3.680','5304000','5304000','5304000','5304000','5304000','kasir','2025-11-06 16:07:47','BE-251106-0002','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251106-0003','NURUL','JKT','','JKT','0','kasir','2025-11-06 16:07:47');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251106-0005','2025-11-06','2025-11-06 16:07:47','PEMBELIAN UMUM : BE-251106-0003','.','TBC','5304000','5304000');
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 ('KK-251106-0005','K','2025-11-06','16:07:46','TBC','PEMBELIAN UMUM','BE-251106-0003','92856307320','5304000','92851003320','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07827','ILUNG','1','CBRE06305','PASANG MATA CROM ULANG','0.700','1','150000','150000');
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-07827','2025-11-06','2025-11-06','19:21:58','PLG0027237','kasir','2025-11-08','kasir','2025-11-06 19:21:58','0.700','0','0','0','0','0','150000','150000','150000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251106-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251106-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251106-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251106-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251106-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251106-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-07','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-06';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-06';
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-06' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-06';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-06';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-06';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-06';
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-07' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-06' 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-251107-0001','D','2025-11-07','20:08:05','TBC','SALDO AWAL','SALDO AWAL','0','92851003320','92851003320');
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-251107-0001','D','2025-11-07','20:08:05','DPE','SALDO AWAL','SALDO AWAL','0','223572800','223572800');
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-251107-0001','D','2025-11-07','20:08:05','TMR','SALDO AWAL','SALDO AWAL','0','8177583779','8177583779');
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-251107-0001','D','2025-11-07','20:08:05','BCD','SALDO AWAL','SALDO AWAL','0','14838019700','14838019700');
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-251107-0001','D','2025-11-07','20:08:05','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900');
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-251107-0001','D','2025-11-07','20:08:05','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000');
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-251107-0001','D','2025-11-07','20:08:05','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000');
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-251107-0001','D','2025-11-07','20:08:05','4000000','SALDO AWAL','SALDO AWAL','0','0','0');
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-251107-0001','D','2025-11-07','20:08:05','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000');
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-251107-0001','D','2025-11-07','20:08:05','3450000','SALDO AWAL','SALDO AWAL','0','0','0');
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-251107-0001','D','2025-11-07','20:08:05','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251107-0001','D','2025-11-07','20:08:05','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000');
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-251107-0001','D','2025-11-07','20:08:05','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092');
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-251107-0001','D','2025-11-07','20:08:05','BCA','SALDO AWAL','SALDO AWAL','0','0','0');
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-251107-0001','D','2025-11-07','20:08:05','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000');
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-251107-0001','D','2025-11-07','20:08:05','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000');
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-251107-0001','D','2025-11-07','20:08:05','6000000','SALDO AWAL','SALDO AWAL','0','0','0');
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-251107-0001','D','2025-11-07','20:08:05','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450');
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-251107-0001','D','2025-11-07','20:08:05','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581');
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-251107-0001','D','2025-11-07','20:08:05','SHO','SALDO AWAL','SALDO AWAL','0','2741005684','2741005684');
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-251107-0001','D','2025-11-07','20:08:05','','SALDO AWAL','SALDO AWAL','0','13818500','13818500');
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-251107-0001','D','2025-11-07','20:08:05','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250');
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-251107-0001','D','2025-11-07','20:08:05','BCK','SALDO AWAL','SALDO AWAL','0','16104582978.088','16104582978.088');
UPDATE tp_system SET tgl_system='2025-11-07';