from flask import Flask, render_template_string, request, jsonify, redirect, url_for, flash from flask_sqlalchemy import SQLAlchemy from flask_login import LoginManager, UserMixin, login_user, login_required, logout_user, current_user from werkzeug.security import generate_password_hash, check_password_hash from openai import OpenAI import os import uuid import random import json app = Flask(__name__) app.config['SECRET_KEY'] = 'super-gizli-anahtar' app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:Mmty2676*@localhost/arapca_app' app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False # --- OPENAI API AYARI --- # UYARI: Güvenliğin için yeni bir API Key oluşturup burayı değiştirmelisin! client = OpenAI(api_key="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") UPLOAD_FOLDER = 'static/uploads' os.makedirs(UPLOAD_FOLDER, exist_ok=True) app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER db = SQLAlchemy(app) login_manager = LoginManager() login_manager.init_app(app) login_manager.login_view = 'login' class User(UserMixin, db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(50), unique=True, nullable=False) password = db.Column(db.String(255), nullable=False) role = db.Column(db.String(20), default='user') score = db.Column(db.Integer, default=0) class Unit(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) lessons = db.relationship('Lesson', backref='unit', cascade="all, delete-orphan", lazy=True) class Lesson(db.Model): id = db.Column(db.Integer, primary_key=True) unit_id = db.Column(db.Integer, db.ForeignKey('unit.id'), nullable=False) title = db.Column(db.String(100), nullable=False) words = db.relationship('Word', backref='lesson', cascade="all, delete-orphan", lazy=True) class Word(db.Model): id = db.Column(db.Integer, primary_key=True) lesson_id = db.Column(db.Integer, db.ForeignKey('lesson.id'), nullable=False) ar = db.Column(db.String(100), nullable=False) tr = db.Column(db.String(100), nullable=False) q_type = db.Column(db.String(20), nullable=False) audio_file = db.Column(db.String(255), nullable=True) class CompletedLesson(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) lesson_id = db.Column(db.Integer, db.ForeignKey('lesson.id'), nullable=False) @login_manager.user_loader def load_user(user_id): return User.query.get(int(user_id)) GLOBAL_HTML_START = """ """ GLOBAL_HTML_END = "" HTML_DASHBOARD = GLOBAL_HTML_START + """ Yol Haritası

Merhaba, {{ user.username }}! 🌟

Puanın: {{ user.score }} XP
{% if user.role == 'admin' %}👑 ADMİN PANELİNE GİT{% endif %} Çıkış Yap {% for u in units %}

📚 {{ u.title }}

{% for lesson in u.lessons %}
{% if lesson.id in completed_ids %}✅{% else %}⚪{% endif %} {{ lesson.title }} ({{ lesson.words|length }} Kelime) {% if lesson.id in completed_ids %} Tekrar Et (+ Az XP) {% else %} Derse Başla {% endif %}
{% endfor %}
{% endfor %}
""" + GLOBAL_HTML_END # YENİ JAVASCRIPT: OPENAI SES KAYIT SİSTEMİ HTML_LESSON = GLOBAL_HTML_START + """ Ders Ekranı
Yükleniyor...

Dersi Terk Et
""" + GLOBAL_HTML_END HTML_ADMIN = GLOBAL_HTML_START + """ Admin Paneli

👑 ADMİN PANELİ

Ana Sayfaya Dön

Yeni Ünite Ekle

{% for u in units %}

📂 {{ u.title }}

🗑️
{% for lesson in u.lessons %}

📄 {{ lesson.title }}

🗑️
{% if lesson.words %}
{% for w in lesson.words %} {% endfor %}
ArapçaTürkçeTürİşlem
{{ w.ar }} {{ w.tr }}{{ w.q_type }} 🗑️
{% endif %}
{% endfor %}
{% endfor %}
""" + GLOBAL_HTML_END @app.route('/') def index(): return redirect(url_for('dashboard')) if current_user.is_authenticated else redirect(url_for('login')) @app.route('/login', methods=['GET', 'POST']) def login(): if current_user.is_authenticated: return redirect(url_for('dashboard')) if request.method == 'POST': user = User.query.filter_by(username=request.form['username']).first() if user and check_password_hash(user.password, request.form['password']): login_user(user, remember=(True if request.form.get('remember') else False)) return redirect(url_for('dashboard')) html = GLOBAL_HTML_START + "Giriş

Giriş Yap

Kayıt Ol
" + GLOBAL_HTML_END return render_template_string(html) @app.route('/register', methods=['GET', 'POST']) def register(): if current_user.is_authenticated: return redirect(url_for('dashboard')) if request.method == 'POST': if User.query.filter_by(username=request.form['username']).first(): pass else: db.session.add(User(username=request.form['username'], password=generate_password_hash(request.form['password']))) db.session.commit() return redirect(url_for('login')) html = GLOBAL_HTML_START + "Kayıt

Kayıt Ol

Zaten hesabım var (Giriş)
" + GLOBAL_HTML_END return render_template_string(html) @app.route('/logout') @login_required def logout(): logout_user(); return redirect(url_for('login')) @app.route('/dashboard') @login_required def dashboard(): units = Unit.query.all() completed_ids = [c.lesson_id for c in CompletedLesson.query.filter_by(user_id=current_user.id).all()] return render_template_string(HTML_DASHBOARD, user=current_user, units=units, completed_ids=completed_ids) @app.route('/lesson/') @login_required def lesson(lesson_id): lesson_data = Lesson.query.get_or_404(lesson_id) words = [{"ar": w.ar, "tr": w.tr, "q_type": w.q_type, "audio_file": w.audio_file} for w in lesson_data.words] random.shuffle(words) return render_template_string(HTML_LESSON, words=words, lesson_id=lesson_id) # YENİ OPENAI YAPAY ZEKA KONTROL SİSTEMİ @app.route('/kontrol', methods=['POST']) @login_required def kontrol(): hedef = request.form.get('hedef_kelime', '') lesson_id = request.form.get('lesson_id') audio_file = request.files.get('audio') if not audio_file: return jsonify({'durum': 'hata', 'mesaj': 'Ses alınamadı.'}) temp_path = f"temp_{uuid.uuid4()}.webm" audio_file.save(temp_path) try: # 1. Aşama: Sesi Yazıya Çevir (Whisper) with open(temp_path, "rb") as audio: transcript = client.audio.transcriptions.create( model="whisper-1", file=audio, language="ar" ) soylenen = transcript.text # 2. Aşama: Uzman Değerlendirmesi (GPT-4o) prompt = f""" Sen bir Arapça dil, tecvid ve telaffuz uzmanısın. Kullanıcının söylediği kelime ile hedef kelimeyi karşılaştır. Hedef Kelime: {hedef} Kullanıcının Söylediği: {soylenen} KURALLAR: 1. Özellikle HAREKE (üstün, esre, ötre hataları) ve MED (uzatma harflerinin eksikliği veya fazlalığı) hatalarını ara. 2. Ufak tefek noktalama işaretlerini görmezden gel. 3. Eğer telaffuz doğruysa JSON "durum" değeri "basarili" olsun. 4. Eğer hareke veya uzatma hatası varsa (veya tamamen başka bir şey söylediyse) "durum" değeri "hata" olsun. 5. "mesaj" kısmına kullanıcıya HTML tagları kullanarak (örneğin kalın yazarak) kibar, Türkçe ve eğitici bir geri bildirim ver. Neyin yanlış olduğunu açıkla. ÇIKTI FORMATI SADECE AŞAĞIDAKİ GİBİ JSON OLMALIDIR: {{"durum": "basarili" veya "hata", "mesaj": "Açıklamanız"}} """ response = client.chat.completions.create( model="gpt-4o", # En zeki model response_format={ "type": "json_object" }, messages=[ {"role": "system", "content": "You are a strict Arabic pronunciation API that outputs only JSON."}, {"role": "user", "content": prompt} ] ) sonuc_json = json.loads(response.choices[0].message.content) # 3. Aşama: Eğer başarılıysa puan ver if sonuc_json.get('durum') == 'basarili': is_completed = CompletedLesson.query.filter_by(user_id=current_user.id, lesson_id=lesson_id).first() kazanilan_puan = 2 if is_completed else 10 current_user.score += kazanilan_puan db.session.commit() sonuc_json['mesaj'] += f"

+{kazanilan_puan} XP Kazandın!" except Exception as e: sonuc_json = {'durum': 'hata', 'mesaj': f'Yapay zeka analizinde hata oluştu: {str(e)}'} finally: if os.path.exists(temp_path): os.remove(temp_path) return jsonify(sonuc_json) @app.route('/finish_lesson/', methods=['POST']) @login_required def finish_lesson(lesson_id): if not CompletedLesson.query.filter_by(user_id=current_user.id, lesson_id=lesson_id).first(): db.session.add(CompletedLesson(user_id=current_user.id, lesson_id=lesson_id)) db.session.commit() return "OK" @app.route('/admin') @login_required def admin(): if current_user.role != 'admin': return redirect(url_for('dashboard')) units = Unit.query.all() return render_template_string(HTML_ADMIN, units=units) @app.route('/admin/add_unit', methods=['POST']) @login_required def add_unit(): if current_user.role == 'admin': db.session.add(Unit(title=request.form['title'])); db.session.commit() return redirect(url_for('admin')) @app.route('/admin/add_lesson', methods=['POST']) @login_required def add_lesson(): if current_user.role == 'admin': db.session.add(Lesson(unit_id=request.form['unit_id'], title=request.form['title'])); db.session.commit() return redirect(url_for('admin')) @app.route('/admin/add_word', methods=['POST']) @login_required def add_word(): if current_user.role == 'admin': audio_filename = None if request.form['q_type'] in ['listening', 'repeat']: file = request.files.get('audio') if file and file.filename != '': ext = file.filename.rsplit('.', 1)[-1].lower() audio_filename = str(uuid.uuid4()) + '.' + ext file.save(os.path.join(app.config['UPLOAD_FOLDER'], audio_filename)) db.session.add(Word(lesson_id=request.form['lesson_id'], ar=request.form['ar'], tr=request.form['tr'], q_type=request.form['q_type'], audio_file=audio_filename)) db.session.commit() return redirect(url_for('admin')) @app.route('/admin/delete_unit/') @login_required def delete_unit(id): if current_user.role == 'admin': Unit.query.filter_by(id=id).delete(); db.session.commit() return redirect(url_for('admin')) @app.route('/admin/delete_lesson/') @login_required def delete_lesson(id): if current_user.role == 'admin': Lesson.query.filter_by(id=id).delete(); db.session.commit() return redirect(url_for('admin')) @app.route('/admin/delete_word/') @login_required def delete_word(id): if current_user.role == 'admin': Word.query.filter_by(id=id).delete(); db.session.commit() return redirect(url_for('admin')) with app.app_context(): db.create_all() if not User.query.filter_by(username='Mervan').first(): db.session.add(User(username='Mervan', password=generate_password_hash('Mmty2676*'), role='admin')) if not User.query.filter_by(username='Merve').first(): db.session.add(User(username='Merve', password=generate_password_hash('2676274'), role='admin')) db.session.commit() if __name__ == '__main__': app.run(host='0.0.0.0', port=8080)