INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-01-11 ','10:04:35');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-11','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-10';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-10';
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-01-10' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-10';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-10';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-10';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-10';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-11' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-10' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-01-11';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-01-11 ','10:04:58');
UPDATE tm_group SET harga='1080000' WHERE kode_group = 'MD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MD','1080000','admin','2026-01-11 10:05:20');
UPDATE tm_group SET harga='1080000' WHERE kode_group = 'MS' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MS','1080000','admin','2026-01-11 10:05:30');
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3170500',harga_beli ='3170500' WHERE kode_barcode='00027410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5502000',harga_beli ='5502000' WHERE kode_barcode='00027411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4401500',harga_beli ='4401500' WHERE kode_barcode='00027412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6639500',harga_beli ='6639500' WHERE kode_barcode='00027413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4010000',harga_beli ='4010000' WHERE kode_barcode='00027414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5968000',harga_beli ='5968000' WHERE kode_barcode='00027415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5949500',harga_beli ='5949500' WHERE kode_barcode='00027416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3637000',harga_beli ='3637000' WHERE kode_barcode='00027417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='2872500',harga_beli ='2872500' WHERE kode_barcode='00027418' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4961000',harga_beli ='4961000' WHERE kode_barcode='00027419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4980000',harga_beli ='4980000' WHERE kode_barcode='00027420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4215000',harga_beli ='4215000' WHERE kode_barcode='00027421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5931000',harga_beli ='5931000' WHERE kode_barcode='00027422' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5464500',harga_beli ='5464500' WHERE kode_barcode='00027423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4700000',harga_beli ='4700000' WHERE kode_barcode='00027424' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5427500',harga_beli ='5427500' WHERE kode_barcode='00027425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3879500',harga_beli ='3879500' WHERE kode_barcode='00027426' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4308500',harga_beli ='4308500' WHERE kode_barcode='00027427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4849000',harga_beli ='4849000' WHERE kode_barcode='00027428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4942500',harga_beli ='4942500' WHERE kode_barcode='00027429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4439000',harga_beli ='4439000' WHERE kode_barcode='00027430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5371500',harga_beli ='5371500' WHERE kode_barcode='00027431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5408500',harga_beli ='5408500' WHERE kode_barcode='00027432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5446000',harga_beli ='5446000' WHERE kode_barcode='00027433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='3786000',harga_beli ='3786000' WHERE kode_barcode='00027434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='7423000',harga_beli ='7423000' WHERE kode_barcode='00027435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5054500',harga_beli ='5054500' WHERE kode_barcode='00027436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5129000',harga_beli ='5129000' WHERE kode_barcode='00027437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6024000',harga_beli ='6024000' WHERE kode_barcode='00027438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='13353500',harga_beli ='13353500' WHERE kode_barcode='00027439' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5278000',harga_beli ='5278000' WHERE kode_barcode='00027440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6602500',harga_beli ='6602500' WHERE kode_barcode='00027441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6378500',harga_beli ='6378500' WHERE kode_barcode='00027442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6490500',harga_beli ='6490500' WHERE kode_barcode='00027443' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6266500',harga_beli ='6266500' WHERE kode_barcode='00027444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5819000',harga_beli ='5819000' WHERE kode_barcode='00027445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='11544500',harga_beli ='11544500' WHERE kode_barcode='00027446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6472000',harga_beli ='6472000' WHERE kode_barcode='00027447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='7646500',harga_beli ='7646500' WHERE kode_barcode='00027448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5856500',harga_beli ='5856500' WHERE kode_barcode='00027449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5819000',harga_beli ='5819000' WHERE kode_barcode='00027450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5726000',harga_beli ='5726000' WHERE kode_barcode='00027451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6527500',harga_beli ='6527500' WHERE kode_barcode='00027452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='10127000',harga_beli ='10127000' WHERE kode_barcode='00027453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='5781500',harga_beli ='5781500' WHERE kode_barcode='00027454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='7479000',harga_beli ='7479000' WHERE kode_barcode='00027455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='12570500',harga_beli ='12570500' WHERE kode_barcode='00027456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6360000',harga_beli ='6360000' WHERE kode_barcode='00027457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6117500',harga_beli ='6117500' WHERE kode_barcode='00027458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='12067000',harga_beli ='12067000' WHERE kode_barcode='00027459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='13111000',harga_beli ='13111000' WHERE kode_barcode='00027460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='7012500',harga_beli ='7012500' WHERE kode_barcode='00027461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='8710000',harga_beli ='8710000' WHERE kode_barcode='00027462' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6210500',harga_beli ='6210500' WHERE kode_barcode='00027463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='7796000',harga_beli ='7796000' WHERE kode_barcode='00027464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6639500',harga_beli ='6639500' WHERE kode_barcode='00027465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='10724000',harga_beli ='10724000' WHERE kode_barcode='00027466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6490500',harga_beli ='6490500' WHERE kode_barcode='00027467' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='7311000',harga_beli ='7311000' WHERE kode_barcode='00027468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6341000',harga_beli ='6341000' WHERE kode_barcode='00027469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='6192000',harga_beli ='6192000' WHERE kode_barcode='00027470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='4122000',harga_beli ='4122000' WHERE kode_barcode='00027471' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='7870500',harga_beli ='7870500' WHERE kode_barcode='00027472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='8299500',harga_beli ='8299500' WHERE kode_barcode='00027473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1865000',harga_jual='15890000',harga_beli ='15890000' WHERE kode_barcode='00027474' LIMIT 1;
UPDATE tm_group SET harga='1865000' WHERE kode_group = 'MT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MT','1865000','admin','2026-01-11 10:05:45');