INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-14 ','08:16:25');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-14','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-13';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-13';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-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='2026-05-13' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-13';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-13';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-13';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-13';
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-14' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-13' 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-14';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-14 ','08:16:50');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0001','1','TFA-ZEAC-14-0','1','3.650','3.650','TOKO','SEM-BALIK','TOKO','TFA.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TFA.BALIK' WHERE kode_barang='TFA-ZEAC-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','TFA.BALIK','TFA','TFA-ZEAC-14-0','83.00','1','3.650','3.650','1','3.650','3.650');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.650',berat_out_asli=berat_out_asli+'3.650',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='TFA-ZEAC-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260514-0001','2026-05-14','2026-05-14','08:17','3.65','input','2026-05-14 08:17:59');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0002','1','ABRE-ZEAC-11-0','1','1.170','1.170','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZEAC-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','ABRE.BALIK','ABRE','ABRE-ZEAC-11-0','75.00','1','1.170','1.170','1','1.170','1.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.170',berat_out_asli=berat_out_asli+'1.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='ABRE-ZEAC-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0002','2','ABRE-ZEAC-4-0','1','4.550','4.550','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZEAC-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','ABRE.BALIK','ABRE','ABRE-ZEAC-4-0','83.00','1','4.550','4.550','1','4.550','4.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.550',berat_out_asli=berat_out_asli+'4.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='ABRE-ZEAC-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260514-0002','2026-05-14','2026-05-14','08:18','5.72','input','2026-05-14 08:18:23');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0003','1','CBRE-ZEAC-10-0','1','2.170','2.170','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZEAC-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','CBRE.BALIK','CBRE','CBRE-ZEAC-10-0','83.00','1','2.170','2.170','1','2.170','2.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.170',berat_out_asli=berat_out_asli+'2.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='CBRE-ZEAC-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0003','2','CBRE-ZEAC-2-0','1','4.610','4.610','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZEAC-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','CBRE.BALIK','CBRE','CBRE-ZEAC-2-0','75.00','1','4.610','4.610','1','4.610','4.610');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.610',berat_out_asli=berat_out_asli+'4.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='CBRE-ZEAC-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0003','3','CBRE-ZEAC-3-0','1','8.060','8.060','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZEAC-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','CBRE.BALIK','CBRE','CBRE-ZEAC-3-0','75.00','1','8.060','8.060','1','8.060','8.060');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.060',berat_out_asli=berat_out_asli+'8.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='CBRE-ZEAC-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0003','4','CBRE-ZEAC-5-0','1','4.970','4.970','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZEAC-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','CBRE.BALIK','CBRE','CBRE-ZEAC-5-0','88.00','1','4.970','4.970','1','4.970','4.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.970',berat_out_asli=berat_out_asli+'4.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='CBRE-ZEAC-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0003','5','CBRE-ZEAC-8-0','1','2.930','2.930','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZEAC-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','CBRE.BALIK','CBRE','CBRE-ZEAC-8-0','75.00','1','2.930','2.930','1','2.930','2.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.930',berat_out_asli=berat_out_asli+'2.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='CBRE-ZEAC-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0003','6','CBRE-ZEAC-9-0','1','2.830','2.830','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZEAC-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','CBRE.BALIK','CBRE','CBRE-ZEAC-9-0','75.00','1','2.830','2.830','1','2.830','2.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.830',berat_out_asli=berat_out_asli+'2.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='CBRE-ZEAC-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0003','7','CBRE-ZEAC-12-0','1','4.280','4.280','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZEAC-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','CBRE.BALIK','CBRE','CBRE-ZEAC-12-0','83.00','1','4.280','4.280','1','4.280','4.280');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.280',berat_out_asli=berat_out_asli+'4.280',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='CBRE-ZEAC-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0003','8','CBRE-ZEAC-6-0','1','1.290','1.290','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZEAC-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','CBRE.BALIK','CBRE','CBRE-ZEAC-6-0','75.00','1','1.290','1.290','1','1.290','1.290');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.290',berat_out_asli=berat_out_asli+'1.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='CBRE-ZEAC-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0003','9','CBRE-ZEAC-7-0','1','1.880','1.880','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZEAC-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','CBRE.BALIK','CBRE','CBRE-ZEAC-7-0','83.00','1','1.880','1.880','1','1.880','1.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.880',berat_out_asli=berat_out_asli+'1.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='CBRE-ZEAC-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260514-0003','10','CBRE-ZEAC-13-0','1','0.820','0.820','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZEAC-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-14','TOKO','CBRE.BALIK','CBRE','CBRE-ZEAC-13-0','75.00','1','0.820','0.820','1','0.820','0.820');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.820',berat_out_asli=berat_out_asli+'0.820',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-14' AND kode_barang='CBRE-ZEAC-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260514-0003','2026-05-14','2026-05-14','08:19','33.84','input','2026-05-14 08:19:48');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260514-0001','1','ABRE-ZEAC-4-0','1','4.550','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-ZEAC-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-ZEAC-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-ZEAC-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-ZEAC-4-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='ABRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='ABRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='ABRE-ZEAC-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.550',berat_out_asli='4.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.550',berat_akhir_asli =berat_akhir_asli-'4.550' WHERE kode_barang='ABRE-ZEAC-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-260514-0001','2','ABRE-ZEAC-11-0','1','1.170','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-ZEAC-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-ZEAC-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-ZEAC-11-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-ZEAC-11-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='ABRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='ABRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='ABRE-ZEAC-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.170',berat_out_asli='1.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.170',berat_akhir_asli =berat_akhir_asli-'1.170' WHERE kode_barang='ABRE-ZEAC-11-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-260514-0001','2026-05-14','2026-05-14','08:23','1.170','input','2026-05-14 08:23:58','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260514-0002','1','CBRE-ZEAC-2-0','1','4.610','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZEAC-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZEAC-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZEAC-2-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZEAC-2-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZEAC-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.610',berat_out_asli='4.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.610',berat_akhir_asli =berat_akhir_asli-'4.610' WHERE kode_barang='CBRE-ZEAC-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-260514-0002','2','CBRE-ZEAC-3-0','1','8.060','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZEAC-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZEAC-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZEAC-3-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZEAC-3-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZEAC-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.060',berat_out_asli='8.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.060',berat_akhir_asli =berat_akhir_asli-'8.060' WHERE kode_barang='CBRE-ZEAC-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-260514-0002','3','CBRE-ZEAC-5-0','1','4.970','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZEAC-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZEAC-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZEAC-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZEAC-5-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZEAC-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.970',berat_out_asli='4.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.970',berat_akhir_asli =berat_akhir_asli-'4.970' WHERE kode_barang='CBRE-ZEAC-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-260514-0002','4','CBRE-ZEAC-6-0','1','1.290','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZEAC-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZEAC-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZEAC-6-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZEAC-6-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZEAC-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.290',berat_out_asli='1.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.290',berat_akhir_asli =berat_akhir_asli-'1.290' WHERE kode_barang='CBRE-ZEAC-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-260514-0002','5','CBRE-ZEAC-7-0','1','1.880','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZEAC-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZEAC-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZEAC-7-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZEAC-7-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZEAC-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.880',berat_out_asli='1.880', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.880',berat_akhir_asli =berat_akhir_asli-'1.880' WHERE kode_barang='CBRE-ZEAC-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-260514-0002','6','CBRE-ZEAC-8-0','1','2.930','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZEAC-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZEAC-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZEAC-8-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZEAC-8-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZEAC-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.930',berat_out_asli='2.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.930',berat_akhir_asli =berat_akhir_asli-'2.930' WHERE kode_barang='CBRE-ZEAC-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-260514-0002','7','CBRE-ZEAC-9-0','1','2.830','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZEAC-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZEAC-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZEAC-9-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZEAC-9-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZEAC-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.830',berat_out_asli='2.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.830',berat_akhir_asli =berat_akhir_asli-'2.830' WHERE kode_barang='CBRE-ZEAC-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-260514-0002','8','CBRE-ZEAC-10-0','1','2.170','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZEAC-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZEAC-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZEAC-10-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZEAC-10-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZEAC-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.170',berat_out_asli='2.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.170',berat_akhir_asli =berat_akhir_asli-'2.170' WHERE kode_barang='CBRE-ZEAC-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-260514-0002','9','CBRE-ZEAC-12-0','1','4.280','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZEAC-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZEAC-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZEAC-12-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZEAC-12-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZEAC-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.280',berat_out_asli='4.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.280',berat_akhir_asli =berat_akhir_asli-'4.280' WHERE kode_barang='CBRE-ZEAC-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-260514-0002','10','CBRE-ZEAC-13-0','1','0.820','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZEAC-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZEAC-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZEAC-13-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZEAC-13-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZEAC-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.820',berat_out_asli='0.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.820',berat_akhir_asli =berat_akhir_asli-'0.820' WHERE kode_barang='CBRE-ZEAC-13-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-260514-0002','2026-05-14','2026-05-14','08:24','0.820','input','2026-05-14 08:24:07','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260514-0003','1','TFA-ZEAC-14-0','1','3.650','TOKO','TFA.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='TFA-ZEAC-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFA-ZEAC-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFA-ZEAC-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFA-ZEAC-14-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFA' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFA' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='TFA.BALIK';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='TFA.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFA-ZEAC-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.650',berat_out_asli='3.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.650',berat_akhir_asli =berat_akhir_asli-'3.650' WHERE kode_barang='TFA-ZEAC-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-260514-0003','2026-05-14','2026-05-14','08:24','3.650','input','2026-05-14 08:24:31','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-14 ','08:28:37');
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='DP-02992';
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 ('PSGE-ZEAD-1-0','00043559','DP-02992 ','CINCIN EMAS ','','GR','---','PSGE','PSGE','TOKO','PSN','1488500','2026-05-14','1488500','1.350','45.00','375','260000','2450000.00','1','0.04', 'input','2026-05-14 09:31:06','1.350','0','','17500.00','','TOKO','FREETAG','','2','','','PSN02992','1','RS 15','','DP-02992');
DELETE FROM tp_barang WHERE kode_dept = 'PSGE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGE','PSGE-ZEAD-1-0','00043559');
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-14','PSGE-ZEAD-1-0','PSGE','TOKO','PSN','45.00','1.350','1.350','1','1.350','1.350','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGE','DP-02992 ');
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='DP-02996';
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 ('PSGE-ZEAD-2-0','00043560','DP-02996 ','CINCIN EMAS ','','GR','---','PSGE','PSGE','TOKO','PSN','8480000','2026-05-14','8480000','4.170','83.00','75','260000','2450000.00','1','0.04', 'input','2026-05-14 09:32:54','4.170','0','','17500.00','','TOKO','FREETAG','','2','','','PSN02996','1','RS 14','','DP-02996');
DELETE FROM tp_barang WHERE kode_dept = 'PSGE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGE','PSGE-ZEAD-2-0','00043560');
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-14','PSGE-ZEAD-2-0','PSGE','TOKO','PSN','83.00','4.170','4.170','1','4.170','4.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGE','DP-02996 ');
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='DP-02997';
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 ('PSGE-ZEAD-3-0','00043561','DP-02997 ','CINCIN EMAS ','','GR','---','PSGE','PSGE','TOKO','PSN','10391500','2026-05-14','10391500','5.110','83.00','75','260000','2450000.00','1','0.04', 'input','2026-05-14 09:34:19','5.110','0','','17500.00','','TOKO','FREETAG','','2','','','PSN02997','1','RS 21','','DP-02997');
DELETE FROM tp_barang WHERE kode_dept = 'PSGE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGE','PSGE-ZEAD-3-0','00043561');
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-14','PSGE-ZEAD-3-0','PSGE','TOKO','PSN','83.00','5.110','5.110','1','5.110','5.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGE','DP-02997 ');
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-02057';
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 ('PSPLT-ZEAD-4-0','00043562','DP-02057MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','539000','2026-05-14','539000','2.640','17.00','10','250000','1200000.00','1','0.14', 'input','2026-05-14 09:36:18','2.640','0','','17500.00','','TOKO','FREETAG','','10','','','PSN02057MM','1','RS 20','','DP-02057');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZEAD-4-0','00043562');
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-14','PSPLT-ZEAD-4-0','PSPLT','TOKO','MMPSN','17.00','2.640','2.640','1','2.640','2.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02057MM ');
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-01977';
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 ('PSPLT-ZEAD-5-0','00043563','DP-01977BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','318500','2026-05-14','318500','1.560','17.00','10','260000','1200000.00','1','0.14', 'input','2026-05-14 09:40:06','1.560','0','','17500.00','','TOKO','FREETAG','','10','','','PSN01977BIP','1','RS 5 5','','DP-01977');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZEAD-5-0','00043563');
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-14','PSPLT-ZEAD-5-0','PSPLT','TOKO','PSNB','17.00','1.560','1.560','1','1.560','1.560','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01977BIP ');
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-01978';
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 ('PSPLT-ZEAD-6-0','00043564','DP-01978BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','598000','2026-05-14','598000','2.930','17.00','10','250000','1200000.00','1','0.14', 'input','2026-05-14 09:41:41','2.930','0','','17500.00','','TOKO','FREETAG','','10','','','PSN01978BIP','1','RS 17','','DP-01978');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZEAD-6-0','00043564');
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-14','PSPLT-ZEAD-6-0','PSPLT','TOKO','PSNB','17.00','2.930','2.930','1','2.930','2.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01978BIP ');
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-02040';
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 ('PSPLT-ZEAD-7-0','00043565','DP-02040BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','341000','2026-05-14','341000','1.670','17.00','10','460000','1200000.00','1','0.14', 'input','2026-05-14 09:43:52','1.670','0','','17500.00','','TOKO','FREETAG','','10','','','PSN02040BIP','1','RS 10','','DP-02040');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZEAD-7-0','00043565');
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-14','PSPLT-ZEAD-7-0','PSPLT','TOKO','PSNB','17.00','1.670','1.670','1','1.670','1.670','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02040BIP ');
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='';
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 ('BDCM-ZEAD-8-0','00043566','750K-105 ','CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','4469000','2026-05-14','4469000','3.200','57.00','50','260000','2450000.00','1','0.14', 'input','2026-05-14 11:08:00','3.200','0','','17500.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-ZEAD-8-0','00043566');
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-14','BDCM-ZEAD-8-0','BDCM','TOKO','CMBD','57.00','3.200','3.200','1','3.200','3.200','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','750K-105 ');
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='';
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 ('PLBDG-ZEAD-9-0','00043567','PLBDG-00162 ','CINCIN PALADIUM PLBDG-00162 ','','GR','---','PLD','PLBDG','TOKO','PLBDG','522500','2026-05-14','522500','2.560','17.00','10','420000','1200000.00','1','0.14', 'input','2026-05-14 11:09:52','2.560','0','','17500.00','','TOKO','FREETAG','','10','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PLBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLBDG','PLBDG-ZEAD-9-0','00043567');
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-14','PLBDG-ZEAD-9-0','PLBDG','TOKO','PLBDG','17.00','2.560','2.560','1','2.560','2.560','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PLBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLBDG','PLBDG-00162 ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-14 ','11:27:09');