INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-14 ','09:42:24');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-14 ','09:47:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-14 ','10:34:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-14 ','11:31:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-14 ','13:50:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-14 ','13:57:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-14 ','14:12:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-14 ','14:12:45');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-14','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-13';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-13';
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-13' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-13';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-13';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-13';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-13';
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-14' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-13' 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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','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-251114-0001','D','2025-11-14','14:42:58','SHOPEE','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-11-14';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-14 ','14:48:45');
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-251113-0001','D','2025-11-13','15:43:48','PT SSS','KOREKSI','FJ-251014-0068 EDC PT SSS','0','5330000','5330000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251113-0001','K','2025-11-13','15:43:48','BCA','KOREKSI','FJ-251014-0068 EDC PT SSS','0','5330000','-5330000');
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-251113-0002','D','2025-11-13','15:49:39','PT SSS','KOREKSI','FJ-241027-0036 EDC PT SSS','5330000','1745000','7075000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251113-0002','K','2025-11-13','15:49:39','BCA','KOREKSI','FJ-241027-0036 EDC PT SSS','-5330000','1745000','-7075000');
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-251113-0003','D','2025-11-13','15:50:18','PT SSS','KOREKSI','FJ-251027-0037 EDC PT SSS','7075000','3520000','10595000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251113-0003','K','2025-11-13','15:50:18','BCA','KOREKSI','FJ-251027-0037 EDC PT SSS','-7075000','3520000','-10595000');
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-251113-0004','D','2025-11-13','15:50:55','PT SSS','KOREKSI','FJ-241027-0038 EDC PT SSS','10595000','4490000','15085000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251113-0004','K','2025-11-13','15:50:55','BCA','KOREKSI','FJ-241027-0038 EDC PT SSS','-10595000','4490000','-15085000');