PHPMaker Custom Codes

Description

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.

Login

• User: admin
• password: master
• How to check: Go to the users table and try to add a new record or edit or delete added record. In each case, the message about the cancellation of the operation is displayed dynamically based on the language.