INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-17 ','08:08:13');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-17','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-16';
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-12-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-16' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-12-17';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-17 ','08:11:25');
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-251217-0001','1','LBRE-YLAF-11-0','1','1.350','1.350','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-YLAF-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-12-17','TOKO','LBRE.BALIK','LBRE','LBRE-YLAF-11-0','83.00','1','1.350','1.350','1','1.350','1.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.350',berat_out_asli=berat_out_asli+'1.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='LBRE-YLAF-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-251217-0001','2025-12-17','2025-12-17','08:30','1.35','input','2025-12-17 08:30:16');
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-251217-0002','1','KLBE-YLAF-21-0','1','2.630','2.630','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-YLAF-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-12-17','TOKO','KLBE.BALIK','KLBE','KLBE-YLAF-21-0','75.00','1','2.630','2.630','1','2.630','2.630');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.630',berat_out_asli=berat_out_asli+'2.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='KLBE-YLAF-21-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-251217-0002','2','KLBE-YLAF-22-0','1','7.510','7.510','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-YLAF-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-12-17','TOKO','KLBE.BALIK','KLBE','KLBE-YLAF-22-0','75.00','1','7.510','7.510','1','7.510','7.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.510',berat_out_asli=berat_out_asli+'7.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='KLBE-YLAF-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-251217-0002','2025-12-17','2025-12-17','08:30','10.14','input','2025-12-17 08:30:34');
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-251217-0003','1','CBRE-YLAF-14-0','1','1.310','1.310','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-YLAF-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-12-17','TOKO','CBRE.BALIK','CBRE','CBRE-YLAF-14-0','75.00','1','1.310','1.310','1','1.310','1.310');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.310',berat_out_asli=berat_out_asli+'1.310',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CBRE-YLAF-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-251217-0003','2','CBRE-YLAF-8-0','1','12.970','12.970','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YLAF-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-17','TOKO','CBRE.BALIK','CBRE','CBRE-YLAF-8-0','75.00','1','12.970','12.970','1','12.970','12.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'12.970',berat_out_asli=berat_out_asli+'12.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CBRE-YLAF-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251217-0003','3','CBRE-YLAF-7-0','1','4.450','4.450','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-YLAF-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-17','TOKO','CBRE.BALIK','CBRE','CBRE-YLAF-7-0','75.00','1','4.450','4.450','1','4.450','4.450');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.450',berat_out_asli=berat_out_asli+'4.450',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CBRE-YLAF-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251217-0003','4','CBRE-YLAF-9-0','1','1.500','1.500','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-YLAF-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-17','TOKO','CBRE.BALIK','CBRE','CBRE-YLAF-9-0','83.00','1','1.500','1.500','1','1.500','1.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.500',berat_out_asli=berat_out_asli+'1.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CBRE-YLAF-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251217-0003','5','CBRE-YLAF-15-0','1','3.740','3.740','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-YLAF-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-12-17','TOKO','CBRE.BALIK','CBRE','CBRE-YLAF-15-0','83.00','1','3.740','3.740','1','3.740','3.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.740',berat_out_asli=berat_out_asli+'3.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CBRE-YLAF-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-251217-0003','6','CBRE-YLAF-6-0','1','7.330','7.330','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-YLAF-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-17','TOKO','CBRE.BALIK','CBRE','CBRE-YLAF-6-0','75.00','1','7.330','7.330','1','7.330','7.330');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.330',berat_out_asli=berat_out_asli+'7.330',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CBRE-YLAF-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251217-0003','7','CBRE-YLAF-20-0','1','3.810','3.810','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-YLAF-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-12-17','TOKO','CBRE.BALIK','CBRE','CBRE-YLAF-20-0','75.00','1','3.810','3.810','1','3.810','3.810');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.810',berat_out_asli=berat_out_asli+'3.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CBRE-YLAF-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-251217-0003','8','CBRE-YLAF-4-0','1','1.240','1.240','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-YLAF-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-17','TOKO','CBRE.BALIK','CBRE','CBRE-YLAF-4-0','75.00','1','1.240','1.240','1','1.240','1.240');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.240',berat_out_asli=berat_out_asli+'1.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CBRE-YLAF-4-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-251217-0003','9','CBRE-YLAF-16-0','1','2.610','2.610','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YLAF-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-12-17','TOKO','CBRE.BALIK','CBRE','CBRE-YLAF-16-0','83.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-12-17' AND kode_barang='CBRE-YLAF-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-251217-0003','10','CBRE-YLAF-5-0','1','1.750','1.750','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-YLAF-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-17','TOKO','CBRE.BALIK','CBRE','CBRE-YLAF-5-0','75.00','1','1.750','1.750','1','1.750','1.750');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.750',berat_out_asli=berat_out_asli+'1.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CBRE-YLAF-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251217-0003','11','CBRE-YLAF-10-0','1','3.500','3.500','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-YLAF-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-17','TOKO','CBRE.BALIK','CBRE','CBRE-YLAF-10-0','75.00','1','3.500','3.500','1','3.500','3.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.500',berat_out_asli=berat_out_asli+'3.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CBRE-YLAF-10-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-251217-0003','2025-12-17','2025-12-17','08:31','44.21','input','2025-12-17 08:32:19');
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-251217-0004','1','CKSE-YLAF-17-0','1','4.210','4.210','TOKO','SEM-EMAS','TOKO','CKSE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CKSE.BALIK' WHERE kode_barang='CKSE-YLAF-17-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-12-17','TOKO','CKSE.BALIK','CKSE','CKSE-YLAF-17-0','76.00','1','4.210','4.210','1','4.210','4.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.210',berat_out_asli=berat_out_asli+'4.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CKSE-YLAF-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-251217-0004','2','CKSE-YLAF-24-0','1','1.590','1.590','TOKO','SEM-EMAS','TOKO','CKSE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CKSE.BALIK' WHERE kode_barang='CKSE-YLAF-24-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-12-17','TOKO','CKSE.BALIK','CKSE','CKSE-YLAF-24-0','76.00','1','1.590','1.590','1','1.590','1.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.590',berat_out_asli=berat_out_asli+'1.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='CKSE-YLAF-24-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-251217-0004','2025-12-17','2025-12-17','08:32','5.8','input','2025-12-17 08:32:44');
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-251217-0005','1','KMP-YLAF-18-0','1','2.010','2.010','TOKO','SEM-EMAS','TOKO','KMPE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='KMPE.BALIK' WHERE kode_barang='KMP-YLAF-18-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-12-17','TOKO','KMPE.BALIK','KMP','KMP-YLAF-18-0','76.00','1','2.010','2.010','1','2.010','2.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.010',berat_out_asli=berat_out_asli+'2.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='KMP-YLAF-18-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-251217-0005','2025-12-17','2025-12-17','08:32','2.01','input','2025-12-17 08:33:00');
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-251217-0006','1','LMP-YLAF-19-0','1','2.180','2.180','TOKO','SEM-EMAS','TOKO','LMPE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='LMPE.BALIK' WHERE kode_barang='LMP-YLAF-19-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-12-17','TOKO','LMPE.BALIK','LMP','LMP-YLAF-19-0','76.00','1','2.180','2.180','1','2.180','2.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.180',berat_out_asli=berat_out_asli+'2.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='LMP-YLAF-19-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-251217-0006','2025-12-17','2025-12-17','08:33','2.18','input','2025-12-17 08:33:18');
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-251217-0007','1','TFGKR-YLAF-23-0','1','5.230','5.230','TOKO','SEM-EMAS','TOKO','GLKTF');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='GLKTF' WHERE kode_barang='TFGKR-YLAF-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-12-17','TOKO','GLKTF','TFGKR','TFGKR-YLAF-23-0','76.00','1','5.230','5.230','1','5.230','5.230');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.230',berat_out_asli=berat_out_asli+'5.230',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-17' AND kode_barang='TFGKR-YLAF-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-251217-0007','2025-12-17','2025-12-17','08:33','5.23','input','2025-12-17 08:33:36');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0001','1','CBRE-YLAF-4-0','1','1.240','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAF-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAF-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAF-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAF-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.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-YLAF-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.240',berat_out_asli='1.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.240',berat_akhir_asli =berat_akhir_asli-'1.240' WHERE kode_barang='CBRE-YLAF-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-251217-0001','2','CBRE-YLAF-5-0','1','1.750','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAF-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAF-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAF-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAF-5-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-YLAF-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.750',berat_out_asli='1.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.750',berat_akhir_asli =berat_akhir_asli-'1.750' WHERE kode_barang='CBRE-YLAF-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-251217-0001','3','CBRE-YLAF-6-0','1','7.330','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAF-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAF-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAF-6-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAF-6-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-YLAF-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.330',berat_out_asli='7.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.330',berat_akhir_asli =berat_akhir_asli-'7.330' WHERE kode_barang='CBRE-YLAF-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-251217-0001','4','CBRE-YLAF-7-0','1','4.450','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAF-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAF-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAF-7-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAF-7-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-YLAF-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.450',berat_out_asli='4.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.450',berat_akhir_asli =berat_akhir_asli-'4.450' WHERE kode_barang='CBRE-YLAF-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-251217-0001','5','CBRE-YLAF-8-0','1','12.970','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAF-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAF-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAF-8-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAF-8-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-YLAF-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='12.970',berat_out_asli='12.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'12.970',berat_akhir_asli =berat_akhir_asli-'12.970' WHERE kode_barang='CBRE-YLAF-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0001','6','CBRE-YLAF-9-0','1','1.500','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAF-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAF-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAF-9-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAF-9-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-YLAF-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.500',berat_out_asli='1.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.500',berat_akhir_asli =berat_akhir_asli-'1.500' WHERE kode_barang='CBRE-YLAF-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0001','7','CBRE-YLAF-10-0','1','3.500','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAF-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAF-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAF-10-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAF-10-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-YLAF-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.500',berat_out_asli='3.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.500',berat_akhir_asli =berat_akhir_asli-'3.500' WHERE kode_barang='CBRE-YLAF-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0001','8','CBRE-YLAF-14-0','1','1.310','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAF-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAF-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAF-14-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAF-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='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-YLAF-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.310',berat_out_asli='1.310', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.310',berat_akhir_asli =berat_akhir_asli-'1.310' WHERE kode_barang='CBRE-YLAF-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-251217-0001','9','CBRE-YLAF-15-0','1','3.740','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAF-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAF-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAF-15-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAF-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-YLAF-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.740',berat_out_asli='3.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.740',berat_akhir_asli =berat_akhir_asli-'3.740' WHERE kode_barang='CBRE-YLAF-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-251217-0001','10','CBRE-YLAF-16-0','1','2.610','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAF-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAF-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAF-16-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAF-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='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-YLAF-16-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='CBRE-YLAF-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-251217-0001','11','CBRE-YLAF-20-0','1','3.810','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-YLAF-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-YLAF-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-YLAF-20-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-YLAF-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-YLAF-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.810',berat_out_asli='3.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.810',berat_akhir_asli =berat_akhir_asli-'3.810' WHERE kode_barang='CBRE-YLAF-20-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-251217-0001','2025-12-17','2025-12-17','08:40','3.810','input','2025-12-17 08:40:30','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0002','1','KLBE-YLAF-21-0','1','2.630','TOKO','KLBE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='KLBE-YLAF-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='KLBE-YLAF-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='KLBE-YLAF-21-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='KLBE-YLAF-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='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-YLAF-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.630',berat_out_asli='2.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.630',berat_akhir_asli =berat_akhir_asli-'2.630' WHERE kode_barang='KLBE-YLAF-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0002','2','KLBE-YLAF-22-0','1','7.510','TOKO','KLBE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='KLBE-YLAF-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='KLBE-YLAF-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='KLBE-YLAF-22-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='KLBE-YLAF-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-YLAF-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.510',berat_out_asli='7.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.510',berat_akhir_asli =berat_akhir_asli-'7.510' WHERE kode_barang='KLBE-YLAF-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-251217-0002','2025-12-17','2025-12-17','08:40','7.510','input','2025-12-17 08:40:45','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0003','1','LBRE-YLAF-11-0','1','1.350','TOKO','LBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='LBRE-YLAF-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LBRE-YLAF-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LBRE-YLAF-11-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LBRE-YLAF-11-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='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-YLAF-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.350',berat_out_asli='1.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.350',berat_akhir_asli =berat_akhir_asli-'1.350' WHERE kode_barang='LBRE-YLAF-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-251217-0003','2025-12-17','2025-12-17','08:40','1.350','input','2025-12-17 08:40:53','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0004','1','CKSE-YLAF-17-0','1','4.210','TOKO','CKSE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CKSE-YLAF-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-YLAF-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-YLAF-17-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-YLAF-17-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKSE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKSE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-YLAF-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.210',berat_out_asli='4.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.210',berat_akhir_asli =berat_akhir_asli-'4.210' WHERE kode_barang='CKSE-YLAF-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0004','2','CKSE-YLAF-24-0','1','1.590','TOKO','CKSE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CKSE-YLAF-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-YLAF-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-YLAF-24-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-YLAF-24-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKSE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKSE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-YLAF-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.590',berat_out_asli='1.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.590',berat_akhir_asli =berat_akhir_asli-'1.590' WHERE kode_barang='CKSE-YLAF-24-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-251217-0004','2025-12-17','2025-12-17','08:41','1.590','input','2025-12-17 08:41:01','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0005','1','KMP-YLAF-18-0','1','2.010','TOKO','KMPE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='KMP-YLAF-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='KMP-YLAF-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='KMP-YLAF-18-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='KMP-YLAF-18-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='KMP' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='KMP' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='KMPE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='KMPE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='KMP-YLAF-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.010' WHERE kode_barang='KMP-YLAF-18-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-251217-0005','2025-12-17','2025-12-17','08:41','2.010','input','2025-12-17 08:41:09','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0006','1','LMP-YLAF-19-0','1','2.180','TOKO','LMPE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='LMP-YLAF-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMP-YLAF-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMP-YLAF-19-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMP-YLAF-19-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='LMP' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMP' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMPE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMPE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMP-YLAF-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.180',berat_out_asli='2.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.180',berat_akhir_asli =berat_akhir_asli-'2.180' WHERE kode_barang='LMP-YLAF-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-251217-0006','2025-12-17','2025-12-17','08:41','2.180','input','2025-12-17 08:41:18','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0007','1','PSGE-YLAF-1-0','1','4.120','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGE-YLAF-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGE-YLAF-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGE-YLAF-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGE-YLAF-1-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSGE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSGE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGE' 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='PSGE-YLAF-1-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='PSGE-YLAF-1-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-251217-0007','2025-12-17','2025-12-17','08:41','4.120','input','2025-12-17 08:41:27','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0008','1','TFGKR-YLAF-23-0','1','5.230','TOKO','GLKTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGKR-YLAF-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGKR-YLAF-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGKR-YLAF-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGKR-YLAF-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='TFGKR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGKR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLKTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLKTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGKR-YLAF-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.230',berat_out_asli='5.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.230',berat_akhir_asli =berat_akhir_asli-'5.230' WHERE kode_barang='TFGKR-YLAF-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-251217-0008','2025-12-17','2025-12-17','08:41','5.230','input','2025-12-17 08:41:39','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-17 ','08:46:51');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-17 ','09:14:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-17 ','10:41:03');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-02911';
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 ('PSPRE-YLAG-1-0','00040610','DP-02911 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','243000','2025-12-17','243000','4.050','100.00','925','350000','60000.00','1','0.04', 'input','2025-12-17 10:45:43','4.050','0','','16750.00','','TOKO','FREETAG','','2','','','PSN02911','1','RS 16 5','','DP-02911');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-YLAG-1-0','00040610');
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-12-17','PSPRE-YLAG-1-0','PSPRE','TOKO','PSN','100.00','4.050','4.050','1','4.050','4.050','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-02911 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-02914';
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 ('PSPRE-YLAG-2-0','00040611','DP-02914 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','109500','2025-12-17','109500','1.820','100.00','925','350000','60000.00','1','0.04', 'input','2025-12-17 10:47:30','1.820','0','','16750.00','','TOKO','FREETAG','','2','','','PSN02914','1','RS 13','','DP-02914');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-YLAG-2-0','00040611');
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-12-17','PSPRE-YLAG-2-0','PSPRE','TOKO','PSN','100.00','1.820','1.820','1','1.820','1.820','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-02914 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-02915';
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 ('PSPRE-YLAG-3-0','00040612','DP-02915 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','137000','2025-12-17','137000','2.280','100.00','925','350000','60000.00','1','0.04', 'input','2025-12-17 10:49:08','2.280','0','','16750.00','','TOKO','FREETAG','','2','','','PSN02915','1','RS 16','','DP-02915');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-YLAG-3-0','00040612');
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-12-17','PSPRE-YLAG-3-0','PSPRE','TOKO','PSN','100.00','2.280','2.280','1','2.280','2.280','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-02915 ');
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-01442';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-YLAG-4-0','00040613','DP-01442BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','312000','2025-12-17','312000','2.260','6.00','10','300000','2300000.00','1','0.14', 'input','2025-12-17 10:51:10','2.260','0','','16750.00','','TOKO','FREETAG','','10','','','PSN01442BIP','1','RS 11','','DP-01442');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YLAG-4-0','00040613');
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-12-17','PSPLT-YLAG-4-0','PSPLT','TOKO','PSNB','6.00','2.260','2.260','1','2.260','2.260','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01442BIP ');
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2367000',harga_beli ='2367000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='4794000',harga_beli ='4794000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='186500',harga_beli ='186500' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2712000',harga_beli ='2712000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='6004500',harga_beli ='6004500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2249500',harga_beli ='2249500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2151500',harga_beli ='2151500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2191000',harga_beli ='2191000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='5222500',harga_beli ='5222500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='19285000',harga_beli ='19285000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2683000',harga_beli ='2683000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2512500',harga_beli ='2512500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2610000',harga_beli ='2610000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2585500',harga_beli ='2585500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='7257500',harga_beli ='7257500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2778500',harga_beli ='2778500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='9954500',harga_beli ='9954500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='3591000',harga_beli ='3591000' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='4221000',harga_beli ='4221000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='4335500',harga_beli ='4335500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='5099500',harga_beli ='5099500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='4125500',harga_beli ='4125500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='5901500',harga_beli ='5901500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='7047500',harga_beli ='7047500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='8499000',harga_beli ='8499000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='6875500',harga_beli ='6875500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='1432500',harga_beli ='1432500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2655000',harga_beli ='2655000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='4049000',harga_beli ='4049000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='3667000',harga_beli ='3667000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2101000',harga_beli ='2101000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2024500',harga_beli ='2024500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='6207000',harga_beli ='6207000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='7448500',harga_beli ='7448500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='3323500',harga_beli ='3323500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='6589000',harga_beli ='6589000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='5233000',harga_beli ='5233000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2540500',harga_beli ='2540500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='2158500',harga_beli ='2158500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='4908500',harga_beli ='4908500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='3438000',harga_beli ='3438000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='5096000',harga_beli ='5096000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='6570000',harga_beli ='6570000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='9950500',harga_beli ='9950500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='8976500',harga_beli ='8976500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='3285000',harga_beli ='3285000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='5118500',harga_beli ='5118500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='7143000',harga_beli ='7143000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='6513000',harga_beli ='6513000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='6704000',harga_beli ='6704000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='7697000',harga_beli ='7697000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='15355500',harga_beli ='15355500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='1566500',harga_beli ='1566500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='1566500',harga_beli ='1566500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='1490000',harga_beli ='1490000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='1432500',harga_beli ='1432500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='4736500',harga_beli ='4736500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='8136000',harga_beli ='8136000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='9301000',harga_beli ='9301000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='7907000',harga_beli ='7907000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='7410500',harga_beli ='7410500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='8117000',harga_beli ='8117000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='7238500',harga_beli ='7238500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='4316500',harga_beli ='4316500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='51814000',harga_beli ='51814000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='8060000',harga_beli ='8060000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='7448500',harga_beli ='7448500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='5519500',harga_beli ='5519500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='10600000',harga_beli ='10600000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='12300500',harga_beli ='12300500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='7066500',harga_beli ='7066500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='5710500',harga_beli ='5710500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='6264500',harga_beli ='6264500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='4908500',harga_beli ='4908500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2301000','input','2025-12-17 13:16:36');
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='16136000',harga_beli ='16136000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='9466500',harga_beli ='9466500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='4987500',harga_beli ='4987500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='5027000',harga_beli ='5027000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='5833500',harga_beli ='5833500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='4427500',harga_beli ='4427500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='10997000',harga_beli ='10997000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='3375500',harga_beli ='3375500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='12655500',harga_beli ='12655500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='6016000',harga_beli ='6016000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2301000','input','2025-12-17 13:16:44');
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2301000','input','2025-12-17 13:16:48');
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2301000','input','2025-12-17 13:16:52');
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2301000','input','2025-12-17 13:16:55');
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2301000','input','2025-12-17 13:16:59');
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2301000','input','2025-12-17 13:17:02');
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2301000','input','2025-12-17 13:17:07');
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='3476000',harga_beli ='3476000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2301000','input','2025-12-17 13:17:10');
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2301000','input','2025-12-17 13:17:16');
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2301000','input','2025-12-17 13:17:20');
UPDATE tm_barang SET harga_skrg ='2301000',harga_jual='312500',harga_beli ='312500' WHERE kode_barcode='00040613' LIMIT 1;
UPDATE tm_group SET harga='2301000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2301000','input','2025-12-17 13:17:24');
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 ('LMB5-YLAG-5-0','00040614','LMB5-110% ','LM ANTAM 5 GR H75317895 ','','GR','---','GOLD','LMB5','TOKO','BIPLM','12655500','2025-12-17','12655500','5.000','110.00','9999','0','2301000.00','1','0.14', 'input','2025-12-17 13:27:53','5.000','0','','16750.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMB5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMB5','LMB5-YLAG-5-0','00040614');
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-12-17','LMB5-YLAG-5-0','LMB5','TOKO','BIPLM','110.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMB5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMB5','LMB5-110% ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251217-0009','1','LMB5-YLAG-5-0','1','5.000','TOKO','BIPLM');
DELETE FROM tm_barang_export WHERE kode_barang='LMB5-YLAG-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMB5-YLAG-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMB5-YLAG-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMB5-YLAG-5-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='LMB5' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMB5' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='BIPLM';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BIPLM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMB5-YLAG-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LMB5-YLAG-5-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-251217-0009','2025-12-17','2025-12-17','13:28','5.000','input','2025-12-17 13:28:30','THIFA');