INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-16 ','08:04:18');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-16','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-15';
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-10-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-15';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-15' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-10-16';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-16 ','08:05:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-16 ','10:12:15');
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2314500',harga_beli ='2314500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4687500',harga_beli ='4687500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='182500',harga_beli ='182500' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2652000',harga_beli ='2652000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5871500',harga_beli ='5871500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2199500',harga_beli ='2199500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2104000',harga_beli ='2104000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5106500',harga_beli ='5106500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='18857500',harga_beli ='18857500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2623500',harga_beli ='2623500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2600000',harga_beli ='2600000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2457000',harga_beli ='2457000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2552000',harga_beli ='2552000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2528500',harga_beli ='2528500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7096500',harga_beli ='7096500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2717000',harga_beli ='2717000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9733500',harga_beli ='9733500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3511000',harga_beli ='3511000' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4127500',harga_beli ='4127500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4239500',harga_beli ='4239500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4986500',harga_beli ='4986500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4034000',harga_beli ='4034000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5771000',harga_beli ='5771000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6891500',harga_beli ='6891500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8310500',harga_beli ='8310500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6723000',harga_beli ='6723000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1401000',harga_beli ='1401000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2596000',harga_beli ='2596000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3959500',harga_beli ='3959500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3586000',harga_beli ='3586000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2054500',harga_beli ='2054500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1980000',harga_beli ='1980000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6069500',harga_beli ='6069500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7283500',harga_beli ='7283500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3249500',harga_beli ='3249500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6443000',harga_beli ='6443000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5117000',harga_beli ='5117000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2484000',harga_beli ='2484000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2110500',harga_beli ='2110500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3361500',harga_beli ='3361500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4983000',harga_beli ='4983000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6424500',harga_beli ='6424500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9730000',harga_beli ='9730000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8777500',harga_beli ='8777500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3212500',harga_beli ='3212500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5005000',harga_beli ='5005000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6984500',harga_beli ='6984500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6368500',harga_beli ='6368500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6555000',harga_beli ='6555000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7526500',harga_beli ='7526500' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15015000',harga_beli ='15015000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1531500',harga_beli ='1531500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1531500',harga_beli ='1531500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1457000',harga_beli ='1457000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1401000',harga_beli ='1401000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4631500',harga_beli ='4631500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7956000',harga_beli ='7956000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9095000',harga_beli ='9095000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7731500',harga_beli ='7731500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7246000',harga_beli ='7246000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7937000',harga_beli ='7937000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7078000',harga_beli ='7078000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4221000',harga_beli ='4221000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='50665500',harga_beli ='50665500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7881000',harga_beli ='7881000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7283500',harga_beli ='7283500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5397500',harga_beli ='5397500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10365000',harga_beli ='10365000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12028000',harga_beli ='12028000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6910000',harga_beli ='6910000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5584000',harga_beli ='5584000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6125500',harga_beli ='6125500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4800000',harga_beli ='4800000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2250000','input','2025-10-16 13:02:33');
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15778500',harga_beli ='15778500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9256500',harga_beli ='9256500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4877000',harga_beli ='4877000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4915500',harga_beli ='4915500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5704000',harga_beli ='5704000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4329500',harga_beli ='4329500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10753000',harga_beli ='10753000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3300500',harga_beli ='3300500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='12375000',harga_beli ='12375000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5883000',harga_beli ='5883000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2250000','input','2025-10-16 13:02:39');
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2250000','input','2025-10-16 13:02:43');
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2250000','input','2025-10-16 13:02:47');
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2250000','input','2025-10-16 13:02:51');
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2250000','input','2025-10-16 13:02:54');
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2250000','input','2025-10-16 13:02:57');
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2250000','input','2025-10-16 13:03:03');
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3399000',harga_beli ='3399000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2250000','input','2025-10-16 13:03:07');
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2250000','input','2025-10-16 13:03:12');
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2250000','input','2025-10-16 13:03:16');
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='259500',harga_beli ='259500' WHERE kode_barcode='00039208' LIMIT 1;
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2250000','input','2025-10-16 13:03:20');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01181';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-YJAF-1-0','00039218','DP-01181MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','3811000','2025-10-16','3811000','2.920','58.00','50','300000','2250000.00','1','0.14', 'input','2025-10-16 16:33:47','2.920','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01181MM','1','RS 18','','DP-01181');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-YJAF-1-0','00039218');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-16','PSGT-YJAF-1-0','PSGT','TOKO','MMPSN','58.00','2.920','2.920','1','2.920','2.920','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01181MM ');