INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','11:02:10');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','11:13:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','11:22:55');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','11:21:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','11:25:47');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','11:29:51');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','11:34:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-25 ','11:37:01');
DELETE FROM tm_otoritas WHERE user_id='kasir';
UPDATE tm_user SET nama_lkp='KASIR',pass_key='oxx',type='KSR' WHERE user_id='kasir';
INSERT INTO tm_user_deleted(user_id,pass_key,nama_lkp,type,input_by,input_date,edit_by,edit_date,deleted_by,deleted_date) VALUES ('kasir','oxx','KASIR','KSR','admin','2020-04-02 12:21:33','','','Nagatech','2026-05-25 11:37:35');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 1.0  Data Master ----- ','Nagatech','2026-05-25 11:38:15');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.1  Kategori Barang','Nagatech','2026-05-25 11:38:15');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.2  Jenis Barang','Nagatech','2026-05-25 11:38:15');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','11:38:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-25 ','11:38:47');
DELETE FROM tm_otoritas WHERE user_id='kasir';
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 1.0  Data Master -----','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.1  Kategori Barang','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.2  Jenis Barang','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.05  Data Sales','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.11  Parameter Batu Berlian','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 10.01  Laporan Barang ----- ','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.8  Laporan Terima Data Barang','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.1  Laporan Tambah Barang','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.2  Laporan Timbang Baki','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.3  Laporan Barang (Detail)','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.4  Laporan Barang (Summary)','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.5  Laporan Barang Yang Hilang','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.6  Laporan Barang Yang Di Hancur','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.7  Laporan Barang Yang Di Pindah','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 10.02  Laporan Penjualan ----- ','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.1  Laporan Transaksi Penjualan','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.2  Laporan Stock Terjual','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.3  Laporan Batal Penjualan','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.4  Laporan Penjualan Sales','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.5  Laporan Selisih Berat Penjualan','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.6  Laporan Penjualan Tukar','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.7  Laporan Penjualan Batal Tukar','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.8  Laporan Penjualan Berlian','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','---------------------------------------------------------------------------------------------','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.1  Laporan Transaksi Titip Uang','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 10.03  Laporan Titip Uang ----- ','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.2  Laporan Pengambilan Barang Titipan','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.3  Laporan Batal Titip Uang','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.4  Laporan Stock Titip Uang','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 10.04  Laporan Barang Balik ----- ','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.1  Laporan Transaksi Barang Balik','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.2  Laporan Stock Barang Balik','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.3  Laporan Batal Barang Balik','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.4  Laporan Barang Balik Sales','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.10 Laporan Pembelian Umum Berlian','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 10.05  Laporan Pesanan ----- ','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.1  Laporan Transaksi Pesanan','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.2  Laporan Stock Pesanan','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.3  Laporan Pesanan - Customer','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 10.06  Laporan Service ----- ','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.1  Laporan Transaksi Service','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.2  Laporan Service - Tgl Selesai','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.3  Laporan Service - Tgl Ambil','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.4  Laporan Transaksi Batal Service','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.5  Laporan Stock Service','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 10.08  Laporan Keuangan ----- ','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.1  Laporan Transaksi','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.2  Laporan Cashier Jual','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.3  Laporan Cashier Beli','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.4  Laporan Uang Cashier','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.11  Laporan Barang (Summary) Tutup Toko','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.12  Buku Berlian','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 11.0  Utility ----- ','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.2  Harga Emas','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.4  Cetak Barcode','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.1  Tambah Uang Bank','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.2  Ambil Uang Bank','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 15.0  Member ----- ','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA MEMBER','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TUKAR POIN','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA HADIAH','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LIHAT TRANSAKSI MEMBER','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','---------------------------------------------------------------------------------------------','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN TUKAR POIN','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','PARAMETER POIN','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TAMBAH POIN MANUAL','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','AMBIL POIN MANUAL','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','CARI POIN','Nagatech','2026-05-25 11:39:48');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN DAFTAR MEMBER','Nagatech','2026-05-25 11:39:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','11:40:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','11:40:24');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-05-25 ','13:03:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','13:03:45');
UPDATE tm_group SET nama_group='PERAK',jenis_group='MUDA',harga='100000',status_berlian='1',edit_by='kasir',edit_date='2026-05-25 13:03:56' WHERE kode_group='PER';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'100000' WHERE stock_on_hand*1> 0 AND kode_group='PER';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','13:04:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','13:04:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','13:05:58');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','13:13:19');
UPDATE tm_group SET nama_group='PERAK',jenis_group='MUDA',harga='100000',status_berlian='0',edit_by='kasir',edit_date='2026-05-25 13:13:25' WHERE kode_group='PER';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'100000' WHERE stock_on_hand*1> 0 AND kode_group='PER';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-25 ','14:37:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','14:38:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-25 ','14:40:38');
DELETE FROM tm_otoritas WHERE user_id='kasir';
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 10.01  Laporan Barang -----','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 10.02  Laporan Penjualan -----','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 10.03  Laporan Titip Uang -----','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 10.04  Laporan Barang Balik -----','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 10.05  Laporan Pesanan -----','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 10.06  Laporan Service -----','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 10.08  Laporan Keuangan -----','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 11.0  Utility -----','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 15.0  Member -----','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.1  Kategori Barang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.2  Jenis Barang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.05  Data Sales','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.11  Parameter Batu Berlian','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.1  Laporan Tambah Barang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.2  Laporan Timbang Baki','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.3  Laporan Barang (Detail)','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.4  Laporan Barang (Summary)','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.5  Laporan Barang Yang Hilang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.6  Laporan Barang Yang Di Hancur','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.7  Laporan Barang Yang Di Pindah','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.8  Laporan Terima Data Barang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.1  Laporan Transaksi Penjualan','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.2  Laporan Stock Terjual','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.3  Laporan Batal Penjualan','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.4  Laporan Penjualan Sales','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.5  Laporan Selisih Berat Penjualan','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.6  Laporan Penjualan Tukar','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.7  Laporan Penjualan Batal Tukar','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.8  Laporan Penjualan Berlian','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.1  Laporan Transaksi Titip Uang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.2  Laporan Pengambilan Barang Titipan','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.3  Laporan Batal Titip Uang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.4  Laporan Stock Titip Uang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.1  Laporan Transaksi Barang Balik','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.10 Laporan Pembelian Umum Berlian','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.2  Laporan Stock Barang Balik','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.3  Laporan Batal Barang Balik','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.4  Laporan Barang Balik Sales','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.1  Laporan Transaksi Pesanan','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.2  Laporan Stock Pesanan','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.3  Laporan Pesanan - Customer','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.1  Laporan Transaksi Service','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.2  Laporan Service - Tgl Selesai','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.3  Laporan Service - Tgl Ambil','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.4  Laporan Transaksi Batal Service','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.5  Laporan Stock Service','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.1  Laporan Transaksi','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.2  Laporan Cashier Jual','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.3  Laporan Cashier Beli','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.4  Laporan Uang Cashier','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.11  Laporan Barang (Summary) Tutup Toko','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.12  Buku Berlian','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.2  Harga Emas','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.4  Cetak Barcode','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.1  Tambah Uang Bank','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.2  Ambil Uang Bank','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','AMBIL POIN MANUAL','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','CARI POIN','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA HADIAH','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA MEMBER','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN DAFTAR MEMBER','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN TUKAR POIN','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LIHAT TRANSAKSI MEMBER','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','PARAMETER POIN','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TAMBAH POIN MANUAL','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TUKAR POIN','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 2.0  Barang ----- ','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.01  Terima Barang Pusat','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.01  Tambah Barang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.03  Hilang Barang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.02  Ganti Data Barang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.04  Hancur Barang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.05  Pindah Barang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.06  Pindah Barang Satu Baki','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.07  Cari Data Barang','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.08  Cari Barang Berdasarkan Berat','Nagatech','2026-05-25 14:41:02');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.09  Timbang Baki','Nagatech','2026-05-25 14:41:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','14:41:33');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-25 ','14:52:08');
DELETE FROM tm_otoritas WHERE user_id='kasir';
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 2.0  Barang -----','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.1  Kategori Barang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.2  Jenis Barang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.05  Data Sales','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.11  Parameter Batu Berlian','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.1  Laporan Tambah Barang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.2  Laporan Timbang Baki','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.3  Laporan Barang (Detail)','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.4  Laporan Barang (Summary)','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.5  Laporan Barang Yang Hilang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.6  Laporan Barang Yang Di Hancur','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.7  Laporan Barang Yang Di Pindah','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.8  Laporan Terima Data Barang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.1  Laporan Transaksi Penjualan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.2  Laporan Stock Terjual','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.3  Laporan Batal Penjualan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.4  Laporan Penjualan Sales','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.5  Laporan Selisih Berat Penjualan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.6  Laporan Penjualan Tukar','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.7  Laporan Penjualan Batal Tukar','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.8  Laporan Penjualan Berlian','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.1  Laporan Transaksi Titip Uang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.2  Laporan Pengambilan Barang Titipan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.3  Laporan Batal Titip Uang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.4  Laporan Stock Titip Uang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.1  Laporan Transaksi Barang Balik','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.10 Laporan Pembelian Umum Berlian','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.2  Laporan Stock Barang Balik','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.3  Laporan Batal Barang Balik','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.4  Laporan Barang Balik Sales','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.1  Laporan Transaksi Pesanan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.2  Laporan Stock Pesanan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.3  Laporan Pesanan - Customer','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.1  Laporan Transaksi Service','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.2  Laporan Service - Tgl Selesai','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.3  Laporan Service - Tgl Ambil','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.4  Laporan Transaksi Batal Service','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.5  Laporan Stock Service','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.1  Laporan Transaksi','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.2  Laporan Cashier Jual','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.3  Laporan Cashier Beli','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.4  Laporan Uang Cashier','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.11  Laporan Barang (Summary) Tutup Toko','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.12  Buku Berlian','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.2  Harga Emas','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.4  Cetak Barcode','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.1  Tambah Uang Bank','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.2  Ambil Uang Bank','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.01  Tambah Barang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.01  Terima Barang Pusat','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.02  Ganti Data Barang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.03  Hilang Barang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.04  Hancur Barang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.05  Pindah Barang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.06  Pindah Barang Satu Baki','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.07  Cari Data Barang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.08  Cari Barang Berdasarkan Berat','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.09  Timbang Baki','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','AMBIL POIN MANUAL','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','CARI POIN','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA HADIAH','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA MEMBER','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN DAFTAR MEMBER','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN TUKAR POIN','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LIHAT TRANSAKSI MEMBER','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','PARAMETER POIN','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TAMBAH POIN MANUAL','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TUKAR POIN','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 3.0  Jual ----- ','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.01  Transaksi Penjualan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.02  Lihat Penjualan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.03  Pembatalan Penjualan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.04  Titip Uang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.05  Pengambilan Barang Titipan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.06  Pembatalan Titip Uang','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 4.0  Barang Balik ----- ','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.01  Transaksi Barang Balik','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.02  Lihat Barang Balik','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.03  Pembatalan Barang Balik','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.04  Hancur Barang Barang Balik','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.08  Transaksi Pembelian Umum Berlian','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 5.0  Pesanan ----- ','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.01  Transaksi Pesanan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.02  Lihat Transaksi Pesanan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.03  Pembatalan Pesanan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.04  Tambah Uang Pesanan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.05  Pesanan Selesai','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.06  Penyerahan Pesanan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 6.0  Service ----- ','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.01  Transaksi Service','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.02  Lihat Transaksi Service','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.03  Pembatalan Service','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.04  Service - Selesai','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.05  Service - Ambil','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 7.0  Uang Kas ----- ','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','7.01  Tambah Uang Kas','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','7.02  Ambil Uang Kas','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 9.0  Validasi ----- ','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.01  Validasi Penjualan','Nagatech','2026-05-25 14:52:39');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.02  Validasi Pembelian','Nagatech','2026-05-25 14:52:39');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','14:53:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-25 ','14:54:40');
DELETE FROM tm_otoritas WHERE user_id='kasir';
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 3.0  Jual -----','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 4.0  Barang Balik -----','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 5.0  Pesanan -----','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 6.0  Service -----','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 7.0  Uang Kas -----','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 9.0  Validasi -----','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.1  Kategori Barang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.2  Jenis Barang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.05  Data Sales','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.11  Parameter Batu Berlian','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.1  Laporan Tambah Barang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.2  Laporan Timbang Baki','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.3  Laporan Barang (Detail)','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.4  Laporan Barang (Summary)','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.5  Laporan Barang Yang Hilang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.6  Laporan Barang Yang Di Hancur','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.7  Laporan Barang Yang Di Pindah','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.8  Laporan Terima Data Barang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.1  Laporan Transaksi Penjualan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.2  Laporan Stock Terjual','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.3  Laporan Batal Penjualan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.4  Laporan Penjualan Sales','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.5  Laporan Selisih Berat Penjualan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.6  Laporan Penjualan Tukar','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.7  Laporan Penjualan Batal Tukar','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.8  Laporan Penjualan Berlian','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.1  Laporan Transaksi Titip Uang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.2  Laporan Pengambilan Barang Titipan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.3  Laporan Batal Titip Uang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.4  Laporan Stock Titip Uang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.1  Laporan Transaksi Barang Balik','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.10 Laporan Pembelian Umum Berlian','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.2  Laporan Stock Barang Balik','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.3  Laporan Batal Barang Balik','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.4  Laporan Barang Balik Sales','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.1  Laporan Transaksi Pesanan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.2  Laporan Stock Pesanan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.3  Laporan Pesanan - Customer','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.1  Laporan Transaksi Service','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.2  Laporan Service - Tgl Selesai','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.3  Laporan Service - Tgl Ambil','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.4  Laporan Transaksi Batal Service','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.5  Laporan Stock Service','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.1  Laporan Transaksi','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.2  Laporan Cashier Jual','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.3  Laporan Cashier Beli','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.4  Laporan Uang Cashier','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.11  Laporan Barang (Summary) Tutup Toko','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.12  Buku Berlian','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.2  Harga Emas','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.4  Cetak Barcode','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.1  Tambah Uang Bank','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.2  Ambil Uang Bank','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.01  Tambah Barang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.01  Terima Barang Pusat','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.02  Ganti Data Barang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.03  Hilang Barang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.04  Hancur Barang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.05  Pindah Barang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.06  Pindah Barang Satu Baki','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.07  Cari Data Barang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.08  Cari Barang Berdasarkan Berat','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.09  Timbang Baki','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.01  Transaksi Penjualan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.02  Lihat Penjualan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.03  Pembatalan Penjualan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.04  Titip Uang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.05  Pengambilan Barang Titipan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.06  Pembatalan Titip Uang','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.01  Transaksi Barang Balik','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.02  Lihat Barang Balik','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.03  Pembatalan Barang Balik','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.04  Hancur Barang Barang Balik','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.08  Transaksi Pembelian Umum Berlian','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.01  Transaksi Pesanan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.02  Lihat Transaksi Pesanan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.03  Pembatalan Pesanan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.04  Tambah Uang Pesanan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.05  Pesanan Selesai','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.06  Penyerahan Pesanan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.01  Transaksi Service','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.02  Lihat Transaksi Service','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.03  Pembatalan Service','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.04  Service - Selesai','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.05  Service - Ambil','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','7.01  Tambah Uang Kas','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','7.02  Ambil Uang Kas','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.01  Validasi Penjualan','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.02  Validasi Pembelian','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','AMBIL POIN MANUAL','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','CARI POIN','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA HADIAH','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA MEMBER','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN DAFTAR MEMBER','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN TUKAR POIN','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LIHAT TRANSAKSI MEMBER','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','PARAMETER POIN','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TAMBAH POIN MANUAL','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TUKAR POIN','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir',' ----- 13.0  Stock Opname ----- ','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','13.1  Stock Opname','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','13.2  Laporan Hasil Stock Opname','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','13.3  Laporan Barang Tidak Ketemu','Nagatech','2026-05-25 14:55:14');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','13.4  Laporan Barang Lebih','Nagatech','2026-05-25 14:55:14');
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-00009247','X-00009247','GIWANG ABRE-01811','GR','---','ABRE','BELI','BELI001','2720000','2026-05-25','1.170','1','Nagatech','2026-05-25 15:05:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-ABRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-ABRE','X-00009247','X-00009247');
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-260525-0001','FE-231009-0001','FAISAL','1','BELI','BELI001','ABRE', 'X-00009247', 'GIWANG ABRE-01811','1.170','1.170','75.00','3400000','2720000','2324786','1','2720000','2720000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.170',berat_beli_asli=berat_beli_asli+'1.170',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.170',berat_akhir_asli=berat_akhir_asli+'1.170',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='ABRE' 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-260525-0001','2026-05-25','2026-05-25','15:05:18','FAISAL','---','1.170','2720000','2720000','2720000','2720000','2720000','Nagatech','2026-05-25 15:05:18','BE-260525-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260525-0001','NUR AZIZAH','-','','','0','Nagatech','2026-05-25 15:05:18');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260525-0001','2026-05-25','2026-05-25 15:05:18','PEMBELIAN UMUM : BE-260525-0001','-','TBC','2720000','2720000');
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-260525-0002','K','2026-05-25','15:05:18','TBC','PEMBELIAN UMUM','BE-260525-0001','97621612685','2720000','97618892685','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','15:05:33');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260525-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260525-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','17:08:54');
UPDATE tm_credit_card SET nama_customer='-',no_ktp='-',alamat1=' - ' ,alamat2=' - ' ,kota= ' - ' ,no_telp='-',tgl_valid_until='-',tgl_last_gesek='2026-05-25 17:17:54' WHERE id_card = '-';
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-260525-0001','kasir','1',' CBRE-02174','TOKO','CBR','CBRE-ZEAC-2-0','CINCIN CBRE-02174 ','','4.610','1','75.00','13654000','4044500','227','17800','16500000','0','0','0','16500000','ILU','00043546','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZEAC-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.610',berat_jual_asli=berat_jual_asli+'4.610',stock_jual='1',berat_akhir=berat_akhir-'4.610',berat_akhir_asli=berat_akhir_asli-'4.610',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='CBRE-ZEAC-2-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-260525-0001','2026-05-25','4.610','2026-05-25','17:17:57','PLG0028727','16500000','16500000','0','16500000','0','kasir','2026-05-25 17:17:55','FE-260525-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-05-25','FE-260525-0001','2026-05-25','17:17:57','ILU','16500000','0');
INSERT INTO tt_card(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,card_rp,card_fee_rp) VALUES ('CC-260525-0001','2026-05-25','2026-05-25 17:17:55','PENJUALAN : FE-260525-0001','','BCK','16500000','16500000','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-260525-0002','D','2026-05-25','17:17:57','BCK','PENJUALAN BERLIAN','FE-260525-0001','16580677978.088','16500000','16597177978.088','CARD');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='16500000',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260525-0001' LIMIT 1;
UPDATE tm_credit_card SET nama_customer='-',no_ktp='-',alamat1=' - ' ,alamat2=' - ' ,kota= ' - ' ,no_telp='-',tgl_valid_until='-',tgl_last_gesek='2026-05-25 17:35:00' WHERE id_card = '-';
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-260525-0002','kasir','1',' CBRE-03754','TOKO','CBR','CBRE-ZEXA-45-0','CINCIN CBRE-03754 ','','3.040','1','75.00','8502000','2211000','124','17800','10500000','0','0','0','10500000','ILU','00043067','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZEXA-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.040',berat_jual_asli=berat_jual_asli+'3.040',stock_jual='1',berat_akhir=berat_akhir-'3.040',berat_akhir_asli=berat_akhir_asli-'3.040',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='CBRE-ZEXA-45-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-260525-0002','2026-05-25','3.040','2026-05-25','17:35:01','PLG0028728','10500000','10500000','0','10500000','0','kasir','2026-05-25 17:35:01','FE-260525-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('2026-05-25','FE-260525-0002','2026-05-25','17:35:01','ILU','10500000','0');
INSERT INTO tt_card(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,card_rp,card_fee_rp) VALUES ('CC-260525-0002','2026-05-25','2026-05-25 17:35:01','PENJUALAN : FE-260525-0002','','BCK','10500000','10500000','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-260525-0003','D','2026-05-25','17:35:01','BCK','PENJUALAN BERLIAN','FE-260525-0002','16597177978.088','10500000','16607677978.088','CARD');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='10500000',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260525-0002' LIMIT 1;
UPDATE tm_credit_card SET nama_customer='-',no_ktp='-',alamat1=' - ' ,alamat2=' - ' ,kota= ' - ' ,no_telp='-',tgl_valid_until='-',tgl_last_gesek='2026-05-25 17:35:48' WHERE id_card = '-';
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-260525-0003','kasir','1',' ABRE-01549','TOKO','ABR','ABRE-ZDAC-33-0','GIWANG ABRE-01549 ','','1.650','1','75.00','6784000','3172000','178','17800','8500000','0','0','0','8500000','BARY','00042500','ABRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ABRE-ZDAC-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='ABRE-ZDAC-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='ABR' 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-260525-0003','2026-05-25','1.650','2026-05-25','17:35:50','PLG0028729','8500000','8500000','0','8500000','0','kasir','2026-05-25 17:35:49','FE-260525-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-05-25','FE-260525-0003','2026-05-25','17:35:50','BARY','8500000','0');
INSERT INTO tt_card(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,card_rp,card_fee_rp) VALUES ('CC-260525-0003','2026-05-25','2026-05-25 17:35:49','PENJUALAN : FE-260525-0003','','BCK','8500000','8500000','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-260525-0004','D','2026-05-25','17:35:50','BCK','PENJUALAN BERLIAN','FE-260525-0003','16607677978.088','8500000','16616177978.088','CARD');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='8500000',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-260525-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260525-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260525-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260525-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260525-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260525-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260525-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260525-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260525-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260525-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','17:39:19');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-25 ','17:46:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('ac','2026-05-25 ','17:47:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','17:53:07');
UPDATE tm_barang SET stock_on_hand='1' WHERE kode_barang='CBRE-ZEAC-2-0' AND kode_lokasi_toko='CBR' LIMIT 1;
UPDATE tt_jual_sales SET jml_jual_rp =jml_jual_rp-'16500000',ongkos_rp=ongkos_rp-'0' WHERE no_faktur_jual ='FE-260525-0001';
UPDATE tt_jual_head SET status_return = 'CLOS' WHERE no_faktur_jual ='FE-260525-0001';
UPDATE tt_barang_tukar SET status='CLOS' WHERE no_faktur_group='FE-260525-0001';
UPDATE tt_voucher_customer SET status='OPEN' WHERE no_voucher='-'
UPDATE tt_barang_saldo SET stock_jual=stock_jual-1, berat_jual = berat_jual-'4.61',berat_jual_asli = berat_jual_asli-'4.61', stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'4.61',berat_akhir_asli=berat_akhir_asli+'4.61' WHERE tanggal ='2026-05-25' AND kode_lokasi_toko ='CBR' AND kode_barang='CBRE-ZEAC-2-0' AND stock_jual*1 > 0 LIMIT 1;
INSERT INTO tt_batal_card SELECT * FROM tt_card WHERE right(deskripsi,14)='FE-260525-0001' AND kode_bank='BCK';
DELETE FROM tt_card WHERE right(deskripsi,14)='FE-260525-0001' AND kode_bank='BCK' LIMIT 1;
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-260525-0005','K','2026-05-25','18:00:04','BCK','BATAL PENJUALAN BERLIAN','BJ-260525-0001','16616177978.088','16500000','16599677978.088','BATAL CREDIT');
INSERT INTO tt_jual_retur_detail(no_retur_jual,no_urut,no_faktur_jual,kode_barang,nama_barang,berat,harga,ongkos,jml_detail,kode_lokasi_toko,kode_dept,kadar,sales_id,alasan,harga_atribut) VALUES ('BJ-260525-0001','1','FE-260525-0001','CBRE-ZEAC-2-0','CINCIN CBRE-02174 ','4.61','16500000.00','0','16500000','CBR','CBRE','75.00','kasir','SALAH INPUT','0');
DELETE FROM tt_jual_head WHERE no_faktur_jual ='FE-260525-0001' LIMIT 1;
DELETE FROM tt_jual_detail WHERE no_faktur_jual ='FE-260525-0001' LIMIT 1;
DELETE FROM tt_jual_sales WHERE no_faktur_jual ='FE-260525-0001' LIMIT 1;
INSERT INTO tt_jual_retur_head(no_retur_jual,tgl_system,tgl_retur_jual,kode_customer,dpp_netto_rp,jml_retur_rp,input_by,input_date)VALUES('BJ-260525-0001','2026-05-25','2026-05-25','PLG0028727','16500000','16500000','kasir','2026-05-25 18:00:04');
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-00009248','X-00009248','GIWANG ABRE-02006','GR','---','ABRE','BELI','BELI001','5440000','2026-05-25','1.350','1','kasir','2026-05-25 18:04:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-ABRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-ABRE','X-00009248','X-00009248');
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-260525-0002','FE-250624-0003','ILU','1','BELI','BELI001','ABRE', 'X-00009248', 'GIWANG ABRE-02006','1.350','1.350','75.00','6800000','5440000','4029630','1','5440000','5440000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.350',berat_beli_asli=berat_beli_asli+'1.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.350',berat_akhir_asli=berat_akhir_asli+'1.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='ABRE' 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-260525-0002','2026-05-25','2026-05-25','18:04:31','ILU','---','1.350','5440000','5440000','5440000','5440000','5440000','kasir','2026-05-25 18:04:32','BE-260525-0002','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260525-0002','TIARA','JKT','','','/','kasir','2026-05-25 18:04:32');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260525-0002','2026-05-25','2026-05-25 18:04:32','PEMBELIAN UMUM : BE-260525-0002','-','TBC','5440000','5440000');
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-260525-0003','K','2026-05-25','18:04:31','TBC','PEMBELIAN UMUM','BE-260525-0002','97618892685','5440000','97613452685','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-00009249','X-00009249','CBRE04002','GR','---','CBRE','BELI','BELI001','10880000','2026-05-25','3.960','1','kasir','2026-05-25 18:06:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00009249','X-00009249');
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-260525-0003','FE-221227-0016','ILU','1','BELI','BELI001','CBRE', 'X-00009249', 'CBRE04002','4.200','3.960','75.00','13600000','10880000','2747475','1','10880000','10880000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.960',berat_beli_asli=berat_beli_asli+'3.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.960',berat_akhir_asli=berat_akhir_asli+'3.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-25' 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-260525-0003','2026-05-25','2026-05-25','18:06:45','ILU','---','3.960','10880000','10880000','10880000','10880000','10880000','kasir','2026-05-25 18:06:45','BE-260525-0003','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260525-0003','TIARA','-','','','-','kasir','2026-05-25 18:06:45');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260525-0003','2026-05-25','2026-05-25 18:06:45','PEMBELIAN UMUM : BE-260525-0003','-','TBC','10880000','10880000');
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-260525-0004','K','2026-05-25','18:06:45','TBC','PEMBELIAN UMUM','BE-260525-0003','97613452685','10880000','97602572685','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260525-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260525-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260525-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260525-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','20:13:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-25 ','20:15:39');
DELETE FROM tm_otoritas WHERE user_id='kasir';
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','----- 13.0  Stock Opname -----','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.1  Kategori Barang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.01.2  Jenis Barang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.05  Data Sales','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','1.11  Parameter Batu Berlian','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.1  Laporan Tambah Barang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.2  Laporan Timbang Baki','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.3  Laporan Barang (Detail)','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.4  Laporan Barang (Summary)','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.5  Laporan Barang Yang Hilang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.6  Laporan Barang Yang Di Hancur','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.7  Laporan Barang Yang Di Pindah','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.01.8  Laporan Terima Data Barang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.1  Laporan Transaksi Penjualan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.2  Laporan Stock Terjual','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.3  Laporan Batal Penjualan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.4  Laporan Penjualan Sales','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.5  Laporan Selisih Berat Penjualan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.6  Laporan Penjualan Tukar','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.7  Laporan Penjualan Batal Tukar','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.02.8  Laporan Penjualan Berlian','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.1  Laporan Transaksi Titip Uang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.2  Laporan Pengambilan Barang Titipan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.3  Laporan Batal Titip Uang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.03.4  Laporan Stock Titip Uang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.1  Laporan Transaksi Barang Balik','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.10 Laporan Pembelian Umum Berlian','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.2  Laporan Stock Barang Balik','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.3  Laporan Batal Barang Balik','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.04.4  Laporan Barang Balik Sales','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.1  Laporan Transaksi Pesanan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.2  Laporan Stock Pesanan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.05.3  Laporan Pesanan - Customer','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.1  Laporan Transaksi Service','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.2  Laporan Service - Tgl Selesai','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.3  Laporan Service - Tgl Ambil','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.4  Laporan Transaksi Batal Service','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.06.5  Laporan Stock Service','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.1  Laporan Transaksi','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.2  Laporan Cashier Jual','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.3  Laporan Cashier Beli','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.08.4  Laporan Uang Cashier','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.11  Laporan Barang (Summary) Tutup Toko','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','10.12  Buku Berlian','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.2  Harga Emas','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.4  Cetak Barcode','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','13.1  Stock Opname','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','13.2  Laporan Hasil Stock Opname','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','13.3  Laporan Barang Tidak Ketemu','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','13.4  Laporan Barang Lebih','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.1  Tambah Uang Bank','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','14.0.2  Ambil Uang Bank','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.01  Tambah Barang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.01  Terima Barang Pusat','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.02  Ganti Data Barang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.03  Hilang Barang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.04  Hancur Barang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.05  Pindah Barang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.06  Pindah Barang Satu Baki','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.07  Cari Data Barang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.08  Cari Barang Berdasarkan Berat','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','2.09  Timbang Baki','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.01  Transaksi Penjualan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.02  Lihat Penjualan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.03  Pembatalan Penjualan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.04  Titip Uang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.05  Pengambilan Barang Titipan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','3.06  Pembatalan Titip Uang','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.01  Transaksi Barang Balik','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.02  Lihat Barang Balik','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.03  Pembatalan Barang Balik','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.04  Hancur Barang Barang Balik','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','4.08  Transaksi Pembelian Umum Berlian','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.01  Transaksi Pesanan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.02  Lihat Transaksi Pesanan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.03  Pembatalan Pesanan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.04  Tambah Uang Pesanan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.05  Pesanan Selesai','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','5.06  Penyerahan Pesanan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.01  Transaksi Service','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.02  Lihat Transaksi Service','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.03  Pembatalan Service','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.04  Service - Selesai','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','6.05  Service - Ambil','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','7.01  Tambah Uang Kas','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','7.02  Ambil Uang Kas','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.01  Validasi Penjualan','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','9.02  Validasi Pembelian','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','AMBIL POIN MANUAL','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','CARI POIN','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA HADIAH','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','DATA MEMBER','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN DAFTAR MEMBER','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LAPORAN TUKAR POIN','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','LIHAT TRANSAKSI MEMBER','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','PARAMETER POIN','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TAMBAH POIN MANUAL','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','TUKAR POIN','Nagatech','2026-05-25 20:15:59');
INSERT INTO tm_otoritas (user_id,nama_form,input_by,input_date) VALUES('kasir','11.8  Tutup Toko (Closing)','Nagatech','2026-05-25 20:15:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-25 ','20:16:15');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-25';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-05-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-25';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-25' 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-260526-0001','D','2026-05-26','20:16:22','TBC','SALDO AWAL','SALDO AWAL','0','97602572685','97602572685');
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-260526-0001','D','2026-05-26','20:16:22','BCK','SALDO AWAL','SALDO AWAL','0','16599677978.088','16599677978.088');
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-260526-0001','D','2026-05-26','20:16:22','SHO','SALDO AWAL','SALDO AWAL','0','2758505684','2758505684');
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-260526-0001','D','2026-05-26','20:16:22','TMR','SALDO AWAL','SALDO AWAL','0','8689183779','8689183779');
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-260526-0001','D','2026-05-26','20:16:22','BNI','SALDO AWAL','SALDO AWAL','0','84527900','84527900');
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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','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-260526-0001','D','2026-05-26','20:16:22','','SALDO AWAL','SALDO AWAL','0','16885500','16885500');
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-260526-0001','D','2026-05-26','20:16:22','BCD','SALDO AWAL','SALDO AWAL','0','15125321700','15125321700');
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-260526-0001','D','2026-05-26','20:16:22','DPE','SALDO AWAL','SALDO AWAL','0','228362000','228362000');
UPDATE tp_system SET tgl_system='2026-05-26';