INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-09-16 ','08:00:26');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-16','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-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-09-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-15';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-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-09-16';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-09-16 ','08:01:14');
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-250916-0001','1','LBRE-YIAE-14-0','1','4.740','4.740','TOKO','SEM-BALIK','TOKO','LBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='LBRE.BALIK' WHERE kode_barang='LBRE-YIAE-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('2025-09-16','TOKO','LBRE.BALIK','LBRE','LBRE-YIAE-14-0','75.00','1','4.740','4.740','1','4.740','4.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.740',berat_out_asli=berat_out_asli+'4.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='LBRE-YIAE-14-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-250916-0001','2','LBRE-YIAE-16-0','1','2.250','2.250','TOKO','SEM-BALIK','TOKO','LBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='LBRE.BALIK' WHERE kode_barang='LBRE-YIAE-16-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('2025-09-16','TOKO','LBRE.BALIK','LBRE','LBRE-YIAE-16-0','75.00','1','2.250','2.250','1','2.250','2.250');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.250',berat_out_asli=berat_out_asli+'2.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='LBRE-YIAE-16-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-250916-0001','3','LBRE-YIAE-19-0','1','1.910','1.910','TOKO','SEM-BALIK','TOKO','LBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='LBRE.BALIK' WHERE kode_barang='LBRE-YIAE-19-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('2025-09-16','TOKO','LBRE.BALIK','LBRE','LBRE-YIAE-19-0','83.00','1','1.910','1.910','1','1.910','1.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.910',berat_out_asli=berat_out_asli+'1.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='LBRE-YIAE-19-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-250916-0001','2025-09-16','2025-09-16','08:16','8.9','input','2025-09-16 08:16:13');
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-250916-0002','1','KLBE-YIAE-22-0','1','3.920','3.920','TOKO','SEM-BALIK','TOKO','KLBE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='KLBE.BALIK' WHERE kode_barang='KLBE-YIAE-22-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('2025-09-16','TOKO','KLBE.BALIK','KLBE','KLBE-YIAE-22-0','75.00','1','3.920','3.920','1','3.920','3.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.920',berat_out_asli=berat_out_asli+'3.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='KLBE-YIAE-22-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-250916-0002','2025-09-16','2025-09-16','08:16','3.92','input','2025-09-16 08:16:29');
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-250916-0003','1','CKBE-YIAE-12-0','1','2.880','2.880','TOKO','SEM-BALIK','TOKO','CKBE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CKBE.BALIK' WHERE kode_barang='CKBE-YIAE-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('2025-09-16','TOKO','CKBE.BALIK','CKBE','CKBE-YIAE-12-0','75.00','1','2.880','2.880','1','2.880','2.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.880',berat_out_asli=berat_out_asli+'2.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='CKBE-YIAE-12-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-250916-0003','2025-09-16','2025-09-16','08:16','2.88','input','2025-09-16 08:16:43');
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-250916-0004','1','CBRE-YIAE-18-0','1','1.940','1.940','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-YIAE-18-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('2025-09-16','TOKO','CBRE.BALIK','CBRE','CBRE-YIAE-18-0','83.00','1','1.940','1.940','1','1.940','1.940');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.940',berat_out_asli=berat_out_asli+'1.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='CBRE-YIAE-18-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-250916-0004','2','CBRE-YIAE-20-0','1','3.250','3.250','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-YIAE-20-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('2025-09-16','TOKO','CBRE.BALIK','CBRE','CBRE-YIAE-20-0','75.00','1','3.250','3.250','1','3.250','3.250');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.250',berat_out_asli=berat_out_asli+'3.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='CBRE-YIAE-20-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-250916-0004','3','CBRE-YIAE-15-0','1','3.230','3.230','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-YIAE-15-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('2025-09-16','TOKO','CBRE.BALIK','CBRE','CBRE-YIAE-15-0','75.00','1','3.230','3.230','1','3.230','3.230');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.230',berat_out_asli=berat_out_asli+'3.230',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='CBRE-YIAE-15-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-250916-0004','4','CBRE-YIAE-21-0','1','4.120','4.120','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-YIAE-21-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('2025-09-16','TOKO','CBRE.BALIK','CBRE','CBRE-YIAE-21-0','75.00','1','4.120','4.120','1','4.120','4.120');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.120',berat_out_asli=berat_out_asli+'4.120',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='CBRE-YIAE-21-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-250916-0004','2025-09-16','2025-09-16','08:16','12.54','input','2025-09-16 08:17:10');
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-250916-0005','1','ABRE-YIAE-17-0','1','2.510','2.510','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-YIAE-17-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('2025-09-16','TOKO','ABRE.BALIK','ABRE','ABRE-YIAE-17-0','75.00','1','2.510','2.510','1','2.510','2.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.510',berat_out_asli=berat_out_asli+'2.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='ABRE-YIAE-17-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-250916-0005','2','ABRE-YIAE-13-0','1','2.610','2.610','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-YIAE-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('2025-09-16','TOKO','ABRE.BALIK','ABRE','ABRE-YIAE-13-0','75.00','1','2.610','2.610','1','2.610','2.610');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.610',berat_out_asli=berat_out_asli+'2.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='ABRE-YIAE-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-250916-0005','2025-09-16','2025-09-16','08:17','5.12','input','2025-09-16 08:17:29');
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-250916-0006','1','TFGRR-YIAE-23-0','1','2.380','2.380','TOKO','SEM-EMAS','TOKO','GLRTF');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='GLRTF' WHERE kode_barang='TFGRR-YIAE-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
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('2025-09-16','TOKO','GLRTF','TFGRR','TFGRR-YIAE-23-0','75.00','1','2.380','2.380','1','2.380','2.380');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.380',berat_out_asli=berat_out_asli+'2.380',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='TFGRR-YIAE-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-250916-0006','2025-09-16','2025-09-16','08:17','2.38','input','2025-09-16 08:18:09');
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-250916-0007','1','TFA-YIAE-11-0','1','3.640','3.640','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-YIAE-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('2025-09-16','TOKO','TFA.BALIK','TFA','TFA-YIAE-11-0','75.00','1','3.640','3.640','1','3.640','3.640');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.640',berat_out_asli=berat_out_asli+'3.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-16' AND kode_barang='TFA-YIAE-11-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-250916-0007','2025-09-16','2025-09-16','08:18','3.64','input','2025-09-16 08:18:29');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0001','1','ABRE-YIAE-13-0','1','2.610','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-YIAE-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-YIAE-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-YIAE-13-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-YIAE-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='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-YIAE-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.610',berat_out_asli='2.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.610',berat_akhir_asli =berat_akhir_asli-'2.610' WHERE kode_barang='ABRE-YIAE-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-250916-0001','2','ABRE-YIAE-17-0','1','2.510','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-YIAE-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-YIAE-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-YIAE-17-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-YIAE-17-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-YIAE-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.510',berat_out_asli='2.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.510',berat_akhir_asli =berat_akhir_asli-'2.510' WHERE kode_barang='ABRE-YIAE-17-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-250916-0001','2025-09-16','2025-09-16','08:25','2.510','input','2025-09-16 08:25:25','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0002','1','CBRE-YIAE-4-0','1','3.150','TOKO','CBRE');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YIAE-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YIAE-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YIAE-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YIAE-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='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';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-YIAE-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.150',berat_out_asli='3.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.150',berat_akhir_asli =berat_akhir_asli-'3.150' WHERE kode_barang='CBRE-YIAE-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-250916-0002','2','CBRE-YIAE-5-0','1','3.130','TOKO','CBRE');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YIAE-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YIAE-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YIAE-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YIAE-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';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-YIAE-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.130',berat_out_asli='3.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.130',berat_akhir_asli =berat_akhir_asli-'3.130' WHERE kode_barang='CBRE-YIAE-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-250916-0002','3','CBRE-YIAE-6-0','1','3.350','TOKO','CBRE');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YIAE-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YIAE-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YIAE-6-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YIAE-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';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-YIAE-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.350',berat_out_asli='3.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.350',berat_akhir_asli =berat_akhir_asli-'3.350' WHERE kode_barang='CBRE-YIAE-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-250916-0002','4','CBRE-YIAE-8-0','1','2.340','TOKO','CBRE');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YIAE-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YIAE-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YIAE-8-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YIAE-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';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-YIAE-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.340',berat_out_asli='2.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.340',berat_akhir_asli =berat_akhir_asli-'2.340' WHERE kode_barang='CBRE-YIAE-8-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-250916-0002','2025-09-16','2025-09-16','08:25','2.340','input','2025-09-16 08:25:45','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0003','1','CBRE-YIAE-15-0','1','3.230','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YIAE-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YIAE-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YIAE-15-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YIAE-15-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-YIAE-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.230',berat_out_asli='3.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.230',berat_akhir_asli =berat_akhir_asli-'3.230' WHERE kode_barang='CBRE-YIAE-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0003','2','CBRE-YIAE-18-0','1','1.940','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YIAE-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YIAE-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YIAE-18-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YIAE-18-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-YIAE-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.940',berat_out_asli='1.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.940',berat_akhir_asli =berat_akhir_asli-'1.940' WHERE kode_barang='CBRE-YIAE-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0003','3','CBRE-YIAE-20-0','1','3.250','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YIAE-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YIAE-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YIAE-20-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YIAE-20-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-YIAE-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.250',berat_out_asli='3.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.250',berat_akhir_asli =berat_akhir_asli-'3.250' WHERE kode_barang='CBRE-YIAE-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0003','4','CBRE-YIAE-21-0','1','4.120','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YIAE-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YIAE-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YIAE-21-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YIAE-21-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-YIAE-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.120',berat_out_asli='4.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.120',berat_akhir_asli =berat_akhir_asli-'4.120' WHERE kode_barang='CBRE-YIAE-21-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-250916-0003','2025-09-16','2025-09-16','08:25','4.120','input','2025-09-16 08:25:55','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0004','1','CKBE-YIAE-12-0','1','2.880','TOKO','CKBE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-YIAE-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKBE-YIAE-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKBE-YIAE-12-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKBE-YIAE-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='CKBE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKBE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKBE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKBE-YIAE-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.880',berat_out_asli='2.880', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.880',berat_akhir_asli =berat_akhir_asli-'2.880' WHERE kode_barang='CKBE-YIAE-12-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-250916-0004','2025-09-16','2025-09-16','08:26','2.880','input','2025-09-16 08:26:03','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0005','1','KLBE-YIAE-22-0','1','3.920','TOKO','KLBE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='KLBE-YIAE-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='KLBE-YIAE-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='KLBE-YIAE-22-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='KLBE-YIAE-22-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='KLBE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='KLBE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='KLBE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='KLBE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='KLBE-YIAE-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.920',berat_out_asli='3.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.920',berat_akhir_asli =berat_akhir_asli-'3.920' WHERE kode_barang='KLBE-YIAE-22-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-250916-0005','2025-09-16','2025-09-16','08:26','3.920','input','2025-09-16 08:26:12','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0006','1','LBRE-YIAE-14-0','1','4.740','TOKO','LBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='LBRE-YIAE-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LBRE-YIAE-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LBRE-YIAE-14-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LBRE-YIAE-14-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='LBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LBRE-YIAE-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.740',berat_out_asli='4.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.740',berat_akhir_asli =berat_akhir_asli-'4.740' WHERE kode_barang='LBRE-YIAE-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0006','2','LBRE-YIAE-16-0','1','2.250','TOKO','LBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='LBRE-YIAE-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LBRE-YIAE-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LBRE-YIAE-16-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LBRE-YIAE-16-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='LBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LBRE-YIAE-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.250',berat_out_asli='2.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.250',berat_akhir_asli =berat_akhir_asli-'2.250' WHERE kode_barang='LBRE-YIAE-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0006','3','LBRE-YIAE-19-0','1','1.910','TOKO','LBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='LBRE-YIAE-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LBRE-YIAE-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LBRE-YIAE-19-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LBRE-YIAE-19-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='LBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LBRE-YIAE-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.910',berat_out_asli='1.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.910',berat_akhir_asli =berat_akhir_asli-'1.910' WHERE kode_barang='LBRE-YIAE-19-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-250916-0006','2025-09-16','2025-09-16','08:26','1.910','input','2025-09-16 08:26:20','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0007','1','PSPRE-YIAE-10-0','1','3.260','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-YIAE-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-YIAE-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-YIAE-10-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-YIAE-10-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRE-YIAE-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.260',berat_out_asli='3.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.260',berat_akhir_asli =berat_akhir_asli-'3.260' WHERE kode_barang='PSPRE-YIAE-10-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-250916-0007','2025-09-16','2025-09-16','08:26','3.260','input','2025-09-16 08:26:31','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0008','1','TFGRR-YIAE-23-0','1','2.380','TOKO','GLRTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-YIAE-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGRR-YIAE-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGRR-YIAE-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGRR-YIAE-23-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLRTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLRTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGRR-YIAE-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.380',berat_out_asli='2.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.380',berat_akhir_asli =berat_akhir_asli-'2.380' WHERE kode_barang='TFGRR-YIAE-23-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-250916-0008','2025-09-16','2025-09-16','08:26','2.380','input','2025-09-16 08:26:45','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0009','1','PSPRT-YIAE-34-0','1','2.830','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YIAE-34-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YIAE-34-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YIAE-34-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YIAE-34-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-YIAE-34-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='PSPRT-YIAE-34-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0009','2','PSPRT-YIAE-35-0','1','2.960','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YIAE-35-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YIAE-35-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YIAE-35-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YIAE-35-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-YIAE-35-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.960',berat_out_asli='2.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.960',berat_akhir_asli =berat_akhir_asli-'2.960' WHERE kode_barang='PSPRT-YIAE-35-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0009','3','PSPLT-YIAE-36-0','1','1.950','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YIAE-36-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YIAE-36-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YIAE-36-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YIAE-36-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-YIAE-36-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='PSPLT-YIAE-36-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-250916-0009','2025-09-16','2025-09-16','08:27','1.950','input','2025-09-16 08:27:05','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0010','1','TFA-YIAE-11-0','1','3.640','TOKO','TFA.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='TFA-YIAE-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFA-YIAE-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFA-YIAE-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFA-YIAE-11-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-YIAE-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.640',berat_out_asli='3.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.640',berat_akhir_asli =berat_akhir_asli-'3.640' WHERE kode_barang='TFA-YIAE-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-250916-0010','2025-09-16','2025-09-16','08:27','3.640','input','2025-09-16 08:27:19','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250916-0011','1','TFC-YIAE-7-0','1','3.040','TOKO','TFC');
DELETE FROM tm_barang_export WHERE kode_barang='TFC-YIAE-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFC-YIAE-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFC-YIAE-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFC-YIAE-7-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='TFC' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFC' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='TFC';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='TFC';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFC-YIAE-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.040',berat_out_asli='3.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.040',berat_akhir_asli =berat_akhir_asli-'3.040' WHERE kode_barang='TFC-YIAE-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-250916-0011','2','TFC-YIAE-9-0','1','2.280','TOKO','TFC');
DELETE FROM tm_barang_export WHERE kode_barang='TFC-YIAE-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFC-YIAE-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFC-YIAE-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFC-YIAE-9-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='TFC' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFC' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='TFC';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='TFC';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFC-YIAE-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.280',berat_out_asli='2.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.280',berat_akhir_asli =berat_akhir_asli-'2.280' WHERE kode_barang='TFC-YIAE-9-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-250916-0011','2025-09-16','2025-09-16','08:27','2.280','input','2025-09-16 08:27:30','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-09-16 ','08:37:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-09-16 ','09:28:29');
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-01029';
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-YIAF-1-0','00038746','DP-01029BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','2625000','2025-09-16','2625000','1.660','83.00','75','300000','1905000.00','1','0.14', 'input','2025-09-16 10:43:53','1.660','0','','16500.00','','TOKO','FREETAG','','2','','','PSN01029BIP','1','RS 6 5','','DP-01029');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-YIAF-1-0','00038746');
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-09-16','PSGT-YIAF-1-0','PSGT','TOKO','PSNB','83.00','1.660','1.660','1','1.660','1.660','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01029BIP ');
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 ('PMM-YIAF-2-0','00038747','500K-25-00493 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','57500','2025-09-16','57500','2.280','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:46:35','2.280','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-2-0','00038747');
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-09-16','PMM-YIAF-2-0','PMM','TOKO','MMPER','100.00','2.280','2.280','1','2.280','2.280','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-25-00493 ');
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 ('PMM-YIAF-3-0','00038748','500K-16-00494 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','47500','2025-09-16','47500','1.900','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:46:58','1.900','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-3-0','00038748');
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-09-16','PMM-YIAF-3-0','PMM','TOKO','MMPER','100.00','1.900','1.900','1','1.900','1.900','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-16-00494 ');
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 ('PMM-YIAF-4-0','00038749','500K-13-00495 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','46500','2025-09-16','46500','1.860','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:47:20','1.860','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-4-0','00038749');
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-09-16','PMM-YIAF-4-0','PMM','TOKO','MMPER','100.00','1.860','1.860','1','1.860','1.860','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-13-00495 ');
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 ('PMM-YIAF-5-0','00038750','500K-19-00496 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','53000','2025-09-16','53000','2.110','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:47:43','2.110','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-5-0','00038750');
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-09-16','PMM-YIAF-5-0','PMM','TOKO','MMPER','100.00','2.110','2.110','1','2.110','2.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-19-00496 ');
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 ('PMM-YIAF-6-0','00038751','500K-24-00497 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','56500','2025-09-16','56500','2.250','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:48:04','2.250','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-6-0','00038751');
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-09-16','PMM-YIAF-6-0','PMM','TOKO','MMPER','100.00','2.250','2.250','1','2.250','2.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-24-00497 ');
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 ('PMM-YIAF-7-0','00038752','500K-165-00498 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','49500','2025-09-16','49500','1.970','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:48:25','1.970','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-7-0','00038752');
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-09-16','PMM-YIAF-7-0','PMM','TOKO','MMPER','100.00','1.970','1.970','1','1.970','1.970','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-165-00498 ');
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 ('PMM-YIAF-8-0','00038753','500K-14-00499 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','47500','2025-09-16','47500','1.890','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:48:45','1.890','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-8-0','00038753');
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-09-16','PMM-YIAF-8-0','PMM','TOKO','MMPER','100.00','1.890','1.890','1','1.890','1.890','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-14-00499 ');
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 ('PMM-YIAF-9-0','00038754','500K-23-00500 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','53500','2025-09-16','53500','2.140','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:49:09','2.140','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-9-0','00038754');
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-09-16','PMM-YIAF-9-0','PMM','TOKO','MMPER','100.00','2.140','2.140','1','2.140','2.140','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-23-00500 ');
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 ('PMM-YIAF-10-0','00038755','500K-21-00501 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','53500','2025-09-16','53500','2.140','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:49:29','2.140','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-10-0','00038755');
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-09-16','PMM-YIAF-10-0','PMM','TOKO','MMPER','100.00','2.140','2.140','1','2.140','2.140','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-21-00501 ');
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 ('PMM-YIAF-11-0','00038756','500K-125-00502 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','46000','2025-09-16','46000','1.830','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:49:51','1.830','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-11-0','00038756');
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-09-16','PMM-YIAF-11-0','PMM','TOKO','MMPER','100.00','1.830','1.830','1','1.830','1.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-125-00502 ');
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 ('PMM-YIAF-12-0','00038757','500K-15-00503 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','49000','2025-09-16','49000','1.960','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:50:12','1.960','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-12-0','00038757');
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-09-16','PMM-YIAF-12-0','PMM','TOKO','MMPER','100.00','1.960','1.960','1','1.960','1.960','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-15-00503 ');
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 ('PMM-YIAF-13-0','00038758','500K-18-00504 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','51000','2025-09-16','51000','2.030','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:50:54','2.030','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-13-0','00038758');
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-09-16','PMM-YIAF-13-0','PMM','TOKO','MMPER','100.00','2.030','2.030','1','2.030','2.030','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-18-00504 ');
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 ('PMM-YIAF-14-0','00038759','500K-22-00505 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','54000','2025-09-16','54000','2.160','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:51:41','2.160','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-14-0','00038759');
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-09-16','PMM-YIAF-14-0','PMM','TOKO','MMPER','100.00','2.160','2.160','1','2.160','2.160','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-22-00505 ');
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 ('PMM-YIAF-15-0','00038760','500K-20-00506 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','52000','2025-09-16','52000','2.070','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:52:01','2.070','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-15-0','00038760');
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-09-16','PMM-YIAF-15-0','PMM','TOKO','MMPER','100.00','2.070','2.070','1','2.070','2.070','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-20-00506 ');
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 ('PMM-YIAF-16-0','00038761','500K-17-00507 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','51500','2025-09-16','51500','2.060','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:52:31','2.060','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-16-0','00038761');
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-09-16','PMM-YIAF-16-0','PMM','TOKO','MMPER','100.00','2.060','2.060','1','2.060','2.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-17-00507 ');
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 ('PMM-YIAF-17-0','00038762','500K-17-00508 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','51500','2025-09-16','51500','2.050','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-16 10:52:58','2.050','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-YIAF-17-0','00038762');
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-09-16','PMM-YIAF-17-0','PMM','TOKO','MMPER','100.00','2.050','2.050','1','2.050','2.050','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-17-00508 ');
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1970000',harga_beli ='1970000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='3990000',harga_beli ='3990000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='155500',harga_beli ='155500' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2257500',harga_beli ='2257500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4997500',harga_beli ='4997500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1872000',harga_beli ='1872000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1791000',harga_beli ='1791000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1823500',harga_beli ='1823500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4346500',harga_beli ='4346500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='16050000',harga_beli ='16050000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2233000',harga_beli ='2233000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2213000',harga_beli ='2213000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2091000',harga_beli ='2091000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2172500',harga_beli ='2172500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2152000',harga_beli ='2152000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='6040000',harga_beli ='6040000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2312500',harga_beli ='2312500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='8284500',harga_beli ='8284500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2988500',harga_beli ='2988500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='3513000',harga_beli ='3513000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='3608500',harga_beli ='3608500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4244000',harga_beli ='4244000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='3433500',harga_beli ='3433500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4911500',harga_beli ='4911500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='5865500',harga_beli ='5865500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='7073500',harga_beli ='7073500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='5722500',harga_beli ='5722500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1192500',harga_beli ='1192500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2209500',harga_beli ='2209500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='3370000',harga_beli ='3370000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='3052000',harga_beli ='3052000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1748500',harga_beli ='1748500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1685000',harga_beli ='1685000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='5166000',harga_beli ='5166000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='6199000',harga_beli ='6199000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2766000',harga_beli ='2766000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='5484000',harga_beli ='5484000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4355500',harga_beli ='4355500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2114000',harga_beli ='2114000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1796500',harga_beli ='1796500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4085000',harga_beli ='4085000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2861500',harga_beli ='2861500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4241000',harga_beli ='4241000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='5468000',harga_beli ='5468000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='8281500',harga_beli ='8281500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='7470500',harga_beli ='7470500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2734000',harga_beli ='2734000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4260000',harga_beli ='4260000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='5945000',harga_beli ='5945000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='5420500',harga_beli ='5420500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='5579000',harga_beli ='5579000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='6406000',harga_beli ='6406000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='12779500',harga_beli ='12779500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1303500',harga_beli ='1303500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1303500',harga_beli ='1303500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1240000',harga_beli ='1240000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='1192500',harga_beli ='1192500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='3942000',harga_beli ='3942000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='6771500',harga_beli ='6771500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='7741000',harga_beli ='7741000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='6580500',harga_beli ='6580500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='6167500',harga_beli ='6167500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='6755500',harga_beli ='6755500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='6024500',harga_beli ='6024500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='3592500',harga_beli ='3592500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='43122000',harga_beli ='43122000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='6708000',harga_beli ='6708000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='6199000',harga_beli ='6199000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4594000',harga_beli ='4594000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='8821500',harga_beli ='8821500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='10237500',harga_beli ='10237500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='5881000',harga_beli ='5881000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4752500',harga_beli ='4752500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='5213500',harga_beli ='5213500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4085000',harga_beli ='4085000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','1915000','input','2025-09-16 13:13:46');
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='13429000',harga_beli ='13429000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='7878500',harga_beli ='7878500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4151000',harga_beli ='4151000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4183500',harga_beli ='4183500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='4855000',harga_beli ='4855000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='3685000',harga_beli ='3685000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='9152000',harga_beli ='9152000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2809000',harga_beli ='2809000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='10532500',harga_beli ='10532500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='5007000',harga_beli ='5007000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','1915000','input','2025-09-16 13:13:53');
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','1915000','input','2025-09-16 13:13:57');
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','1915000','input','2025-09-16 13:14:00');
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','1915000','input','2025-09-16 13:14:04');
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','1915000','input','2025-09-16 13:14:07');
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','1915000','input','2025-09-16 13:14:11');
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','1915000','input','2025-09-16 13:14:15');
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2893000',harga_beli ='2893000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1915000',harga_jual='2639000',harga_beli ='2639000' WHERE kode_barcode='00038746' LIMIT 1;
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','1915000','input','2025-09-16 13:14:19');
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','1915000','input','2025-09-16 13:14:22');
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','1915000','input','2025-09-16 13:14:26');
UPDATE tm_group SET harga='1915000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','1915000','input','2025-09-16 13:14:30');