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 difflib import SequenceMatcher import os import re import uuid import random 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 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) # YENİ: Kullanıcının tamamladığı dersleri tutan tablo 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)) def strip_tashkeel(text): tashkeel = re.compile(r'[\u0617-\u061A\u064B-\u0652]') return re.sub(tashkeel, '', text) 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 %} {% if not u.lessons %}

Henüz ders eklenmedi.

{% endif %}
{% endfor %} {% if not units %}

Henüz hiç ünite eklenmemiş.

{% endif %}
""" + GLOBAL_HTML_END 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 {% with messages = get_flashed_messages() %} {% if messages %}
{{ messages[0] }}
{% endif %} {% endwith %}

1. Yeni Ünite Ekle

Mevcut Eğitim İçeriği (Düzenle/Sil)

{% 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']): remember_me = True if request.form.get('remember') else False login_user(user, remember=remember_me) return redirect(url_for('dashboard')) flash('Hatalı kullanıcı adı veya şifre!') html = GLOBAL_HTML_START + "Giriş

Giriş Yap

{% with messages = get_flashed_messages() %}{% if messages %}
{{ messages[0] }}
{% endif %}{% endwith %}
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(): flash('Bu kullanıcı adı zaten alınmış!') else: yeni = User(username=request.form['username'], password=generate_password_hash(request.form['password'])) db.session.add(yeni) db.session.commit() flash('Kayıt başarılı! Şimdi giriş yapabilirsiniz.') return redirect(url_for('login')) html = GLOBAL_HTML_START + "Kayıt

Kayıt Ol

{% with messages = get_flashed_messages() %}{% if messages %}
{{ messages[0] }}
{% endif %}{% endwith %}
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() # Kullanıcının tamamladığı derslerin ID'lerini bir listeye al (Arayüzde ✅ göstermek için) completed = CompletedLesson.query.filter_by(user_id=current_user.id).all() completed_ids = [c.lesson_id for c in completed] 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] # YENİ: Kelimeleri tamamen RASTGELE sırala random.shuffle(words) return render_template_string(HTML_LESSON, words=words, lesson_id=lesson_id) @app.route('/kontrol', methods=['POST']) @login_required def kontrol(): veri = request.get_json() hedef = veri.get('hedef_kelime', '') soylenen = veri.get('soylenen', '') lesson_id = veri.get('lesson_id') benzerlik = SequenceMatcher(None, strip_tashkeel(hedef.replace('ة', 'ه')), strip_tashkeel(soylenen.replace('ة', 'ه'))).ratio() if benzerlik >= 0.85: # YENİ: Tamamlanan ders için az (2 XP), yeni ders için tam (10 XP) puan ver. 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() return jsonify({'durum': 'basarili', 'mesaj': f'Doğru! (+{kazanilan_puan} XP)
Söylediğin: {soylenen}'}) return jsonify({'durum': 'hata', 'mesaj': f'Söylediğin: {soylenen}
Olması Gereken: {hedef}'}) @app.route('/finish_lesson/', methods=['POST']) @login_required def finish_lesson(lesson_id): # Kullanıcı dersi bitirdiğinde veritabanına kaydet 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" # --- ADMİN İŞLEMLERİ --- @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() flash("Ünite eklendi!") 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() flash("Ders eklendi!") 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() flash("Kelime başarıyla eklendi!") 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() flash("Ünite silindi!") 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() flash("Ders silindi!") 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() flash("Kelime silindi!") return redirect(url_for('admin')) @app.route('/admin/edit_unit/') @login_required def edit_unit(id): if current_user.role == 'admin': unit = Unit.query.get(id) if unit: unit.title = request.args.get('new_title') db.session.commit() flash("Ünite adı güncellendi!") return redirect(url_for('admin')) @app.route('/admin/edit_lesson/') @login_required def edit_lesson(id): if current_user.role == 'admin': lesson = Lesson.query.get(id) if lesson: lesson.title = request.args.get('new_title') db.session.commit() flash("Ders adı güncellendi!") 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)