INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-08 ','08:04:40');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-07';
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-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-07';
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-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-07' 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-08';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-08 ','08:05:10');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','1','PMM-ZAXG-2-0','1','4.880','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-2-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.880',berat_out_asli='4.880', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.880',berat_akhir_asli =berat_akhir_asli-'4.880' WHERE kode_barang='PMM-ZAXG-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','2','PMM-ZAXG-3-0','1','4.710','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-3-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.710',berat_out_asli='4.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.710',berat_akhir_asli =berat_akhir_asli-'4.710' WHERE kode_barang='PMM-ZAXG-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','3','PMM-ZAXG-4-0','1','4.830','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-4-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.830',berat_out_asli='4.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.830',berat_akhir_asli =berat_akhir_asli-'4.830' WHERE kode_barang='PMM-ZAXG-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','4','PMM-ZAXG-5-0','1','4.870','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-5-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.870',berat_out_asli='4.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.870',berat_akhir_asli =berat_akhir_asli-'4.870' WHERE kode_barang='PMM-ZAXG-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','5','PMM-ZAXG-6-0','1','1.240','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-6-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.240',berat_out_asli='1.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.240',berat_akhir_asli =berat_akhir_asli-'1.240' WHERE kode_barang='PMM-ZAXG-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','6','PMM-ZAXG-7-0','1','1.190','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-7-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.190',berat_out_asli='1.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.190',berat_akhir_asli =berat_akhir_asli-'1.190' WHERE kode_barang='PMM-ZAXG-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','7','PMM-ZAXG-8-0','1','1.150','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-8-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.150',berat_out_asli='1.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.150',berat_akhir_asli =berat_akhir_asli-'1.150' WHERE kode_barang='PMM-ZAXG-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','8','PMM-ZAXG-9-0','1','1.220','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-9-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.220',berat_out_asli='1.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.220',berat_akhir_asli =berat_akhir_asli-'1.220' WHERE kode_barang='PMM-ZAXG-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','9','PMM-ZAXG-10-0','1','1.950','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-10-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.950',berat_out_asli='1.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.950',berat_akhir_asli =berat_akhir_asli-'1.950' WHERE kode_barang='PMM-ZAXG-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','10','PMM-ZAXG-11-0','1','1.990','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-11-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.990',berat_out_asli='1.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.990',berat_akhir_asli =berat_akhir_asli-'1.990' WHERE kode_barang='PMM-ZAXG-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','11','PMM-ZAXG-12-0','1','2.070','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-12-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.070',berat_out_asli='2.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.070',berat_akhir_asli =berat_akhir_asli-'2.070' WHERE kode_barang='PMM-ZAXG-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','12','PMM-ZAXG-13-0','1','1.210','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-13-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.210',berat_out_asli='1.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.210',berat_akhir_asli =berat_akhir_asli-'1.210' WHERE kode_barang='PMM-ZAXG-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260108-0001','13','PMM-ZAXG-14-0','1','1.150','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZAXG-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZAXG-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZAXG-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZAXG-14-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZAXG-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.150',berat_out_asli='1.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.150',berat_akhir_asli =berat_akhir_asli-'1.150' WHERE kode_barang='PMM-ZAXG-14-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-260108-0001','2026-01-08','2026-01-08','08:18','1.150','input','2026-01-08 08:18:02','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-08 ','08:23:56');