Browse Intertextual Connections - warwickfoster/qurantools GitHub Wiki

File: app/admin/word_correction_logs.php

Purpose

This PHP script displays a list of word corrections made in a database. The script allows users to filter the list by different criteria, such as the status of the corrections (not yet approved, approved but not applied, or applied) and search for specific words.

Features

  • Filters the list of corrections by status (not yet approved, approved but not applied, applied)
  • Searches for specific words
  • Generates SQL statements to update the offline database with the changes
  • Displays a page navigator to navigate through the results

Functionality

  1. The script first checks if the user is authorized to access the page.
  2. It then retrieves the search criteria and filtering parameters from the GET request.
  3. It queries the database to get a list of corrections that match the criteria.
  4. The script displays the list of corrections in a table, along with the status of each correction.
  5. The script also provides options for users to apply all changes, generate SQL statements to update the offline database, or search for specific words.

Database Table

The script assumes that there is a database table called QURAN-DATA that contains the following columns:

  • GLOBAL WORD NUMBER
  • FIXED_GLOSS
  • FIXED_TRANSLITERATION
  • FIXED_ARABIC
  • FIX_CREATED_BY
  • FIX_APPROVED_BY
  • TRANSLATION_STATUS

Permissions

Only users with administrative privileges have access to this page.

Additional Notes

  • The script uses the db_* functions to interact with the database.
  • The script includes a library/footer.php file for the footer content.
  • The script uses the print_page_navigator() function to display the page navigator.
  • The script uses the Tipped JavaScript library to provide tooltips.