====Desktop ExcelManager Application====

The app has a preset info prompt, You require to re adjust to your excelsheet

This project uses phpdesktop by cztomczak to package a web application into a desktop executable.

• Application Code: Louay Benali (aka Kazuma)
• Dependencies: Requires ZipArchive support for Excel file handling.
• Current Version: 2.6
• Copyright Claim: ⚠️ Legal Notice: This application and its source code are the work of Louay Benali (aka Kazuma).
  No one is allowed to claim ownership, redistribute, or use it for commercial purposes without explicit written permission.
  Any unauthorized claim of authorship or rights, especially under Moroccan jurisdiction, is strictly prohibited.

---

Features (v1.0/1.5)

• Manage and display information directly from Excel files.
• User Interface styled after a Windows command prompt:
  • Black and white theme (no green).
  • Full-screen design with creative layout.
• Application language: French.
• Debug display: visible under the app title to show errors or processes in real-time.
• Excel folder integration:
  • A dedicated excel/ folder stores all uploaded Excel files.
  • The app rescans this folder on every action—no SQL or external database required.
• Error handling:
  • Displays errors in the debug window.
  • Smart reading ensures corrupted files don’t break execution.
• Excel compatibility:
  • Must work with the provided sample file.
  • Supports different Excel formats.
• Smart Search:
  • Handles missing or incomplete fields by marking them as N/A.
  • Can reorder and adapt content to ensure consistent display.
• Separation of concerns: Excel reading logic is placed in a dedicated module for easy maintenance.
• Session support: prevents resets and ensures continuity.
• File handling: Avoids reliance on external PHP libraries or Composer installs.

---

Application Buttons & Functionalities

• Add

  • Upload and copy one or multiple Excel files into the excel/ folder.

• Search

  • Opens a search bar for individuals or establishments.
  • If no keyword is entered, displays a complete list of all Excel data.

• Duplicate (Doublon)

  • Detects duplicate files.
  • Detects duplicate individuals by name or CIN.
  • Results show in the debug display with source file details.

• Establishments

  • Displays all establishments with statistics:
    • Number of students per establishment.
    • Any available extra details.

• List

  • Shows summary statistics (students, establishments, etc.).
  • Below the stats, displays a full list of records (Excel-style view).

• Details

  • Accessible from Search, Establishments, or List.
  • Displays full details of a selected individual.

• Files

  • Lists all Excel files.
  • Options to delete or replace files.

• Archive

  • Two functions:
    • Archive current files: move them into a dated folder.
    • Browse archives: view archived folders, inspect them as lists, or delete them.

---

Version 2.0 — Major Update

• Archive Improvements

  • Archive lists now display only name, last name, and CIN.
  • Clicking an entry reveals full details.

• Search / List Merge

  • Search now works as a filter applied on the list.
  • The list remains in structured format.

• Establishments Enhancements

  • Added filter by filière (study track) for easier navigation.

• List View Updates

  • Pagination introduced (instead of long scrolling).
  • Option to filter by establishment before listing students.

• Duplicates Section

  • Displays full name and establishment(s) for duplicates.

---

Version 2.6 — Patch/Upgrade

• Fixed glitches and improved stability across all functions.
• Merging File adding Dashboard with the file display.
• Modify Capability in file Display.
• Fixed Search ability in inspection.
• Fixed List search Reset.
• Fixed no file to scan loop
• Fixed delete file.

=>File Lines Numerical<=

script.js:752 styles.css:783 ajax-handler.php:44 excel-reader.php:1085 index.php:699