Document

Overview

This project provides a comprehensive learning system built with PHPMaker, demonstrating advanced field validations, automated calculations, and integrated dynamic actions across multiple tables and features.


Tables and Their Roles

  • Users: Demonstrates field validations for Mobile Number, User Name, Password, and Email using jQuery. It includes an API-based Custom Action to verify if the username, mobile number, or email is already registered.
  • Customer Numerator: Stores default prefixes and numbers for generating customer IDs.
  • Customer: Automatically generates customer IDs based on Customer Numerator values. Date and Time fields are auto-filled. Validations are included for national ID and mobile number fields.
  • Number To Word: Converts numbers into words. The corresponding "Number Word" field is auto-filled upon entering a number.
  • Sales Calc: Demonstrates how to calculate Total Price by multiplying Quantity and Unit Price. Also includes functionality to auto-fill the Total Price in words and provides buttons for additional actions like Add Payment.
  • Sales Payment: Related to Sales Calc, this table calculates the remaining amount automatically by subtracting the total paid amount from the sales total.
  • Character Limit: Enforces character limits on specific fields.
  • Upper Case: Converts text input to uppercase automatically.
  • Number Convert: Converts Arabic or Persian digits to Latin format before saving them to the database, ensuring standardization.
  • Addresses Calc: Demonstrates auto-filling multiple fields (City and State) based on the inputted ZIP Code.
  • Download Backup: Provides a backup system for exporting the database in .sql format.
  • Mail Template: Allows editing of static email templates (e.g., changepassword.html, notify.php) directly from the admin panel without accessing the file manager.
  • Mail Config: Enables dynamic updates to mail server settings in config.production.php and config.development.php through the admin panel.
  • E-Mail Backup: Sends a database backup to the email address specified in the Mail Config settings.

Key Features

  • Field Validations: Learn how to apply advanced field validations using jQuery and API integrations.
  • Auto-Filling Fields: Automate field values like customer ID, date, time, and derived calculations.
  • Dynamic Calculations: Implement calculations like sales totals and remaining payment amounts.
  • Data Standardization: Convert non-standard numeric inputs into a standard Latin format.
  • Dynamic Email Templates: Edit email templates and mail configurations directly from the admin panel.
  • Backup System: Export database backups in .sql format and send them via email.

Usage Instructions

  1. Set Field Validations: Explore the Users table to learn about applying jQuery-based validations and API calls for checking duplicates.
  2. Configure Customer IDs: Set up prefixes and numbers in Customer Numerator. New customer IDs will auto-generate in the Customer table.
  3. Perform Calculations: Use the Sales Calc table to calculate total prices and handle payments.
  4. Backup Database: Use the Download Backup page to export the database or configure E-Mail Backup to send backups via email.
  5. Customize Email Templates: Edit static email templates in the Mail Template table and update mail server settings in Mail Config.

Benefits

  • Improved Validation: Ensure data accuracy with advanced validation techniques.
  • Efficiency: Automate repetitive tasks like calculations and field updates.
  • Data Standardization: Maintain a consistent format for database values.
  • Ease of Management: Simplify configuration and customization with a centralized admin panel.