INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-23 ','14:11:34');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-22';
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-05-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-22' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-05-23';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-23 ','14:13:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-23 ','14:17:51');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-23 ','14:18:41');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('LGM25-ZEBC-1-0','00043760','LME25-112% ','LOGAM MULIA 25 GR ELCO 25GR D76072265 ','','GR','---','GOLD','LGM25','TOKO','LM','68600500','2026-05-23','68600500','25.000','112.00','99.99','','2450000.00','1','0.04', 'input','2026-05-23 14:46:24','25.000','0','','17500.00','','TOKO','FREETAG','','0','','','LME25112','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM25' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM25','LGM25-ZEBC-1-0','00043760');
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 ('2026-05-23','LGM25-ZEBC-1-0','LGM25','TOKO','LM','112.00','25.000','25.000','1','25.000','25.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM25';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM25','LME25-112% ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-23 ','14:47:45');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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 ('LGM25-ZEBC-2-0','00043761','LME25-112% ','LOGAM MULIA 25 GR ELCO 25GR D76072264 ','','GR','---','GOLD','LGM25','TOKO','LM','68600500','2026-05-23','68600500','25.000','112.00','99.99','','2450000.00','1','0.04', 'input','2026-05-23 14:51:21','25.000','0','','17500.00','','TOKO','FREETAG','','0','','','LME25112','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM25' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM25','LGM25-ZEBC-2-0','00043761');
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 ('2026-05-23','LGM25-ZEBC-2-0','LGM25','TOKO','LM','112.00','25.000','25.000','1','25.000','25.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM25';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM25','LME25-112% ');
UPDATE th_user_login SET tgl_logout = '2026-05-23', jam_logout = '14:58:59' WHERE user_id = 'input' AND tgl_login = '2026-05-23' AND jam_login= '14:47:45';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-23 ','14:59:07');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260523-0001','1','LGM25-ZEBC-1-0','1','25.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM25-ZEBC-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM25-ZEBC-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM25-ZEBC-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM25-ZEBC-1-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='LGM25' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM25' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM25-ZEBC-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='25.000',berat_out_asli='25.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'25.000',berat_akhir_asli =berat_akhir_asli-'25.000' WHERE kode_barang='LGM25-ZEBC-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260523-0001','2','LGM25-ZEBC-2-0','1','25.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM25-ZEBC-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM25-ZEBC-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM25-ZEBC-2-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM25-ZEBC-2-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='LGM25' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM25' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM25-ZEBC-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='25.000',berat_out_asli='25.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'25.000',berat_akhir_asli =berat_akhir_asli-'25.000' WHERE kode_barang='LGM25-ZEBC-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260523-0001','2026-05-23','2026-05-23','15:07','25.000','input','2026-05-23 15:07:36','ELCO');