INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-05 ','08:44:58');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-04';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-04' 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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','BRI','SALDO AWAL','SALDO AWAL','0','363082422','363082422');
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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','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-251105-0001','D','2025-11-05','08:45:18','SMS','SALDO AWAL','SALDO AWAL','0','872096903','872096903');
UPDATE tp_system SET tgl_system='2025-11-05';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-05 ','08:45:32');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-05 ','08:48:01');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-05 ','09:03:12');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-05 ','09:54:33');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-05 ','10:00:18');
UPDATE tm_customer SET nama_customer='NURJANNAH PINDAH ANN0017944',alamat1='RUNGKANG',alamat2='-',kota='',kode_pos='',tgl_lahir='2025-10-24',no_telp='-',no_hp='',npwp_no='',input_by='kasir',input_date='2025-11-05 10:01:16',status_customer='ANN0028024',status_lm='RE' WHERE kode_customer='ANN0028024';
UPDATE db_member_anan.tm_customer SET nama_customer='NURJANNAH PINDAH ANN0017944',alamat1='RUNGKANG',alamat2='-',kota='',kode_pos='',tgl_lahir='2025-10-24',no_telp='-',no_hp='',npwp_no='',input_by='kasir',input_date='2025-11-05 10:01:16',status_customer='ANN0028024',status_lm='RE' WHERE kode_customer='ANN0028024';
UPDATE tm_customer SET nama_customer='NURJANAH',alamat1='RUNGKANG',alamat2='-',kota='',kode_pos='',tgl_lahir='2024-02-09',no_telp='-',no_hp='08812853326',npwp_no='',input_by='kasir',input_date='2025-11-05 10:02:02',status_customer='ANN0017944',status_lm='RE' WHERE kode_customer='ANN0017944';
UPDATE db_member_anan.tm_customer SET nama_customer='NURJANAH',alamat1='RUNGKANG',alamat2='-',kota='',kode_pos='',tgl_lahir='2024-02-09',no_telp='-',no_hp='08812853326',npwp_no='',input_by='kasir',input_date='2025-11-05 10:02:02',status_customer='ANN0017944',status_lm='RE' WHERE kode_customer='ANN0017944';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-05 ','13:17:15');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-05 ','13:38:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2025-11-05 ','14:26:58');