INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','09:42:26');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-02';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-12-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-02' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251203-0001','D','2025-12-03','09:42:34','SYSTEM','SALDO AWAL','SALDO AWAL','0','367686919','367686919');
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-251203-0001','D','2025-12-03','09:42:34','SHOPEE','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-251203-0001','D','2025-12-03','09:42:34','TOKPED','SALDO AWAL','SALDO AWAL','0','4240000','4240000');
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-251203-0001','D','2025-12-03','09:42:34','JCHICKCRB','SALDO AWAL','SALDO AWAL','0','164250000','164250000');
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-251203-0001','D','2025-12-03','09:42:34','J CHICKEN','SALDO AWAL','SALDO AWAL','0','168750000','168750000');
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-251203-0001','D','2025-12-03','09:42:34','BPCM','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-251203-0001','D','2025-12-03','09:42:34','PT SIP CRB','SALDO AWAL','SALDO AWAL','0','405000000','405000000');
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-251203-0001','D','2025-12-03','09:42:34','BCA PT KLC','SALDO AWAL','SALDO AWAL','0','24750000','24750000');
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-251203-0001','D','2025-12-03','09:42:34','SMS PT SIP','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-251203-0001','D','2025-12-03','09:42:34','PADELSMSIP','SALDO AWAL','SALDO AWAL','0','750000000','750000000');
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-251203-0001','D','2025-12-03','09:42:34','l','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-251203-0001','D','2025-12-03','09:42:34','BCA PT SIP','SALDO AWAL','SALDO AWAL','0','310000000','310000000');
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-251203-0001','D','2025-12-03','09:42:34','PT SIP','SALDO AWAL','SALDO AWAL','0','10000000','10000000');
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-251203-0001','D','2025-12-03','09:42:34','BTN','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-251203-0001','D','2025-12-03','09:42:34','SHOPPE','SALDO AWAL','SALDO AWAL','0','2375000','2375000');
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-251203-0001','D','2025-12-03','09:42:34','TOKED','SALDO AWAL','SALDO AWAL','0','1965000','1965000');
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-251203-0001','D','2025-12-03','09:42:34','PAK TONI G','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-251203-0001','D','2025-12-03','09:42:34','SMSDEPOSIT','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-251203-0001','D','2025-12-03','09:42:34','SUP ONLINE','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-251203-0001','D','2025-12-03','09:42:34','NBH KALUNG','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-251203-0001','D','2025-12-03','09:42:34','NBH KL RMB','SALDO AWAL','SALDO AWAL','0','11091659','11091659');
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-251203-0001','D','2025-12-03','09:42:34','SHOPEEPAY','SALDO AWAL','SALDO AWAL','0','832','832');
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-251203-0001','D','2025-12-03','09:42:34','SUP OMA','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-251203-0001','D','2025-12-03','09:42:34','LAZADA','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-251203-0001','D','2025-12-03','09:42:34','NBH NADIA','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-251203-0001','D','2025-12-03','09:42:34','BNI','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-251203-0001','D','2025-12-03','09:42:34','NBH','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-251203-0001','D','2025-12-03','09:42:34','PAK WAWAN','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-251203-0001','D','2025-12-03','09:42:34','BANK LM','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-251203-0001','D','2025-12-03','09:42:34','SMS PT KKM','SALDO AWAL','SALDO AWAL','0','130000000','130000000');
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-251203-0001','D','2025-12-03','09:42:34','QRISBRI','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-251203-0001','D','2025-12-03','09:42:34','SIP ULON','SALDO AWAL','SALDO AWAL','0','48000000','48000000');
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-251203-0001','D','2025-12-03','09:42:34','MANDIRISYR','SALDO AWAL','SALDO AWAL','0','2040455','2040455');
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-251203-0001','D','2025-12-03','09:42:34','SMSRESTOSL','SALDO AWAL','SALDO AWAL','0','71400000','71400000');
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-251203-0001','D','2025-12-03','09:42:34','TIKTOK','SALDO AWAL','SALDO AWAL','0','8594999.61','8594999.61');
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-251203-0001','D','2025-12-03','09:42:34','SMS','SALDO AWAL','SALDO AWAL','0','872096903','872096903');
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-251203-0001','D','2025-12-03','09:42:34','PT SSS','SALDO AWAL','SALDO AWAL','0','763008960','763008960');
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-251203-0001','D','2025-12-03','09:42:34','MANDIRI','SALDO AWAL','SALDO AWAL','0','99095508','99095508');
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-251203-0001','D','2025-12-03','09:42:34','BCA','SALDO AWAL','SALDO AWAL','0','407568492','407568492');
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-251203-0001','D','2025-12-03','09:42:34','BRI','SALDO AWAL','SALDO AWAL','0','363082422','363082422');
UPDATE tp_system SET tgl_system='2025-12-03';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','09:44:18');
INSERT INTO tm_voucher (kode_voucher,nama_voucher,qty,nominal,lama_expire,input_by,input_date) VALUES ('TEST','DISKON TEST 10RB','1','10000','2','admin','2025-12-03 09:47:24')
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','09:49:36');
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TEST'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0001','12/3/2025','TEST','K','MUTASI','MV-251203-0001','1','admin','2025-12-03 09:50:05');
INSERT INTO tt_voucher_customer (no_voucher,tgl_beli,kode_voucher,nama_customer,tgl_expire,nominal,input_by,input_date) VALUES ('VR-251203-0001','2025-12-03','TEST','CUST TES','2025-12-05','10000','admin','2025-12-03 09:51:15')
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TEST'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0001','2025-12-03','TEST','K','PENJUALAN','VR-251203-0001','1','admin','2025-12-03 09:51:15');
INSERT INTO tm_voucher (kode_voucher,nama_voucher,qty,nominal,lama_expire,input_by,input_date) VALUES ('TKANAN','DISKON 50RB AKHIR TAHUN','2','50000','3','admin','2025-12-03 09:57:38')
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','09:58:51');
UPDATE tm_voucher SET nama_voucher ='DISKON 50RB AKHIR TAHUN',qty='1',nominal='50000',lama_expire='3' WHERE kode_voucher ='TKANAN';
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TKANAN'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0001','12/3/2025','TKANAN','K','MUTASI','MV-251203-0001','1','admin','2025-12-03 09:59:29');
UPDATE tm_voucher SET nama_voucher ='DISKON 50RB AKHIR TAHUN',qty='3',nominal='50000',lama_expire='3' WHERE kode_voucher ='TKANAN';
INSERT INTO tt_voucher_customer (no_voucher,tgl_beli,kode_voucher,nama_customer,tgl_expire,nominal,input_by,input_date) VALUES ('VR-251203-0002','2025-12-03','TKANAN','TEST PROGRAM','2025-12-06','50000','admin','2025-12-03 10:00:54')
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TKANAN'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0002','2025-12-03','TKANAN','K','PENJUALAN','VR-251203-0002','1','admin','2025-12-03 10:00:54');
INSERT INTO tt_voucher_customer (no_voucher,tgl_beli,kode_voucher,nama_customer,tgl_expire,nominal,input_by,input_date) VALUES ('VR-251203-0003','2025-12-03','TKANAN','PROGRAM TES','2025-12-06','50000','admin','2025-12-03 10:01:18')
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TKANAN'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0003','2025-12-03','TKANAN','K','PENJUALAN','VR-251203-0003','1','admin','2025-12-03 10:01:18');
INSERT INTO tt_voucher_customer (no_voucher,tgl_beli,kode_voucher,nama_customer,tgl_expire,nominal,input_by,input_date) VALUES ('VR-251203-0004','2025-12-03','TKANAN','PROGRAM TES','2025-12-06','50000','admin','2025-12-03 10:01:18')
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TKANAN'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0004','2025-12-03','TKANAN','K','PENJUALAN','VR-251203-0004','1','admin','2025-12-03 10:01:18');
INSERT INTO tm_voucher (kode_voucher,nama_voucher,qty,nominal,lama_expire,input_by,input_date) VALUES ('TSV','VOUCHER TEST 50RB','3','50000','3','admin','2025-12-03 10:03:46')
UPDATE tm_voucher SET nama_voucher ='VOUCHER TEST 50RB',qty='3',nominal='50000',lama_expire='2' WHERE kode_voucher ='TSV';
UPDATE tm_voucher SET nama_voucher ='VOUCHER TEST 50RB',qty='1',nominal='50000',lama_expire='2' WHERE kode_voucher ='TSV';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','10:05:48');
UPDATE tm_voucher SET nama_voucher ='VOUCHER TEST 50RB',qty='3',nominal='50000',lama_expire='2' WHERE kode_voucher ='TSV';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','10:06:31');
UPDATE tm_voucher SET qty=qty-2 WHERE kode_voucher='TSV'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0001','12/3/2025','TSV','K','MUTASI','MV-251203-0001','2','admin','2025-12-03 10:06:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','10:07:18');
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TSV'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0001','12/3/2025','TSV','K','MUTASI','MV-251203-0001','1','admin','2025-12-03 10:19:07');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','10:19:19');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-03 ','10:25:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-03 ','10:26:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','10:33:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2025-12-03 ','11:36:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2025-12-03 ','12:04:01');
INSERT INTO tm_voucher (kode_voucher,nama_voucher,qty,nominal,lama_expire,input_by,input_date) VALUES ('TES123','VOUCHER TES','100','10000','7','Nagatech','2025-12-03 12:12:09')
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','12:54:40');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251203-0002','K','2025-12-03','13:00:30','Nagatech','CASHBACK','FJ-251203-0001','367686919','50000','367736919');
UPDATE tt_voucher_customer SET status='DONE' WHERE no_voucher='VR-251203-0003'
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,ppn_detail) VALUES ('FJ-251203-0001','Nagatech','1',' S NA ','TOKO','BKPROMO','ANT70-XABC-1-0','ANTING 16K CATOK BULAT BUNGA DIKRON MT PTH LNGKP ','','1.480','1','78.00','2459000','0','0','15000','2459760','0','0','0','2459760','AAR','00104190','ANT70','0','0','VR-251203-0003','0');
UPDATE tm_barang SET tgl_last_jual='2025-12-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ANT70-XABC-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2025-12-03' AND kode_barang='ANT70-XABC-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BKPROMO' 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) VALUES ('FJ-251203-0001','2025-12-03','1.480','2025-12-03','13:00:30','ANN0000002','2459760','2459760','0','2459760','2459760','Nagatech','2025-12-03 13:00:29','FJ-251203-0001');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-03','FJ-251203-0001','2025-12-03','13:00:30','AAR','2459760','0');
INSERT INTO db_member_anan.tt_member (no_trx,tgl_trx,kode_customer,kategori,deskripsi,kode_barang,nama_barang,berat_jual,jual_rp,no_faktur_group,point_2) VALUES ('ANN-251203-0001','2025-12-03','ANN0000002','PENJUALAN','FJ-251203-0001','ANT70-XABC-1-0','ANTING 16K CATOK BULAT BUNGA DIKRON MT PTH LNGKP ','1.480','2459760','FJ-251203-0001','2');
INSERT INTO db_member_anan.tt_poin (no_trx,tanggal,kode_customer,deskripsi,point_2,kode_toko,poin_awal,poin_akhir) VALUES ('ANN-251203-0001','2025-12-03','ANN0000002','FJ-251203-0001','2','ANN','15','17');
UPDATE db_member_anan.tm_customer SET point_2=point_2+'2' WHERE kode_customer='ANN0000002';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251203-0003','D','2025-12-03','13:00:30','Nagatech','PENJUALAN','FJ-251203-0001','367736919','2459760','370196679');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251203-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251203-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251203-0001';
INSERT INTO tt_voucher_customer (no_voucher,tgl_beli,kode_voucher,nama_customer,tgl_expire,nominal,input_by,input_date) VALUES ('VR-251203-0005','2025-12-03','','EKO','1970-01-01','','Nagatech','2025-12-03 13:03:24')
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher=''
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0005','2025-12-03','','K','PENJUALAN','VR-251203-0005','1','Nagatech','2025-12-03 13:03:24');
INSERT INTO tt_voucher_customer (no_voucher,tgl_beli,kode_voucher,nama_customer,tgl_expire,nominal,input_by,input_date) VALUES ('VR-251203-0006','2025-12-03','','EKO','1970-01-01','','Nagatech','2025-12-03 13:03:24')
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher=''
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0006','2025-12-03','','K','PENJUALAN','VR-251203-0006','1','Nagatech','2025-12-03 13:03:24');
INSERT INTO tt_voucher_customer (no_voucher,tgl_beli,kode_voucher,nama_customer,tgl_expire,nominal,input_by,input_date) VALUES ('VR-251203-0007','2025-12-03','TES123','EKO TES','2025-12-10','10000','Nagatech','2025-12-03 13:03:55')
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TES123'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0007','2025-12-03','TES123','K','PENJUALAN','VR-251203-0007','1','Nagatech','2025-12-03 13:03:55');
INSERT INTO tt_voucher_customer (no_voucher,tgl_beli,kode_voucher,nama_customer,tgl_expire,nominal,input_by,input_date) VALUES ('VR-251203-0008','2025-12-03','TES123','EKO TES','2025-12-10','10000','Nagatech','2025-12-03 13:03:55')
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TES123'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0008','2025-12-03','TES123','K','PENJUALAN','VR-251203-0008','1','Nagatech','2025-12-03 13:03:55');
INSERT INTO tt_voucher_customer (no_voucher,tgl_beli,kode_voucher,nama_customer,tgl_expire,nominal,input_by,input_date) VALUES ('VR-251203-0009','2025-12-03','TES123','EKO TES','2025-12-10','10000','Nagatech','2025-12-03 13:03:55')
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TES123'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0009','2025-12-03','TES123','K','PENJUALAN','VR-251203-0009','1','Nagatech','2025-12-03 13:03:55');
INSERT INTO tt_voucher_customer (no_voucher,tgl_beli,kode_voucher,nama_customer,tgl_expire,nominal,input_by,input_date) VALUES ('VR-251203-0010','2025-12-03','TES123','EKO TES','2025-12-10','10000','Nagatech','2025-12-03 13:03:55')
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TES123'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0010','2025-12-03','TES123','K','PENJUALAN','VR-251203-0010','1','Nagatech','2025-12-03 13:03:55');
INSERT INTO tt_voucher_customer (no_voucher,tgl_beli,kode_voucher,nama_customer,tgl_expire,nominal,input_by,input_date) VALUES ('VR-251203-0011','2025-12-03','TES123','EKO TES','2025-12-10','10000','Nagatech','2025-12-03 13:03:55')
UPDATE tm_voucher SET qty=qty-1 WHERE kode_voucher='TES123'
INSERT INTO tt_mutasi_voucher (no_mutasi,tgl_mutasi,kode_voucher,type,kategori,deskripsi,qty,input_by,input_date) VALUES ('MV-251203-0011','2025-12-03','TES123','K','PENJUALAN','VR-251203-0011','1','Nagatech','2025-12-03 13:03:55');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251203-0004','K','2025-12-03','13:08:10','Nagatech','CASHBACK','FJ-251203-0002','370196679','10000','370206679');
UPDATE tt_voucher_customer SET status='DONE' WHERE no_voucher='VR-251203-0001'
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,ppn_detail) VALUES ('FJ-251203-0002','Nagatech','1',' S NA ','TOKO','BKANT','ANT70-XKAI-27-0','ANTING 16K CATOK COR MT PTH LNGKP ','','2.180','1','78.00','3622000','0','0','15000','3623160','0','0','0','3623160','AAR','00129809','ANT70','0','0','VR-251203-0001','0');
UPDATE tm_barang SET tgl_last_jual='2025-12-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ANT70-XKAI-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2025-12-03' AND kode_barang='ANT70-XKAI-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BKANT' 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) VALUES ('FJ-251203-0002','2025-12-03','2.180','2025-12-03','13:08:10','PLG0023347','3623160','3623160','0','3623160','3623160','Nagatech','2025-12-03 13:08:10','FJ-251203-0002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-03','FJ-251203-0002','2025-12-03','13:08:10','AAR','3623160','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251203-0005','D','2025-12-03','13:08:10','Nagatech','PENJUALAN','FJ-251203-0002','370206679','3623160','373829839');
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,ppn_detail) VALUES ('FJ-251203-0003','Nagatech','1',' S NA ','TOKO','BKANT','ANT70-YAXG-37-0','ANTING 16K CATOK COR MT PTH LNGKP ','','1.810','1','78.00','3007500','0','0','15000','3008220','0','0','0','3008220','AAR','00134414','ANT70','0','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-12-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ANT70-YAXG-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2025-12-03' AND kode_barang='ANT70-YAXG-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BKANT' 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) VALUES ('FJ-251203-0003','2025-12-03','1.810','2025-12-03','13:09:45','PLG0000001','3008220','3008220','0','3008220','3008220','Nagatech','2025-12-03 13:09:45','FJ-251203-0003');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-03','FJ-251203-0003','2025-12-03','13:09:45','AAR','3008220','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251203-0006','D','2025-12-03','13:09:45','Nagatech','PENJUALAN','FJ-251203-0003','373829839','3008220','376838059');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251203-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251203-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251203-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251203-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251203-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251203-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','13:54:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','13:57:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-12-03 ','13:57:52');