Feature request: Draft word by word translation

[naveed-ahmad]

Word-by-Word Translation Draft Review Feature

Implement a draft review and approval system for word-by-word translations in the QUL admin panel, similar to the existing draft translation and tafsir feature. This system will ensure word translations are reviewed and approved before updating the main table, preventing accidental updates.

Key Features:

1. Draft Table for Translations:

   • Columns:
     • id, draft_text, current_text, need_review, text_matched, imported, resource_content_id, user_id, word_id, verse_id, location.

2. Import Functionality:

   • Import draft translations from CSV or SQLite database.
   • Data source columns:
     • surah_id, ayah_number, word_number, text.
   • Validate imported data and log errors.

3. Filtering and Review:

   • Implement filters for draft translation
   • Side-by-side comparison of draft and current text.
   • Highlight differences
   • Allow user to update the draft text

4. Approval Process:

   • Approve drafts and copy them to the main table.
   • Track approvals with timestamps and user details.

5. Audit Log and Version Control:

   • Maintain logs of all changes.
   • Keep translation history for rollbacks.