Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Customizing AppGini web applications

Name: Customizing AppGini web applications
Rating: 4.4 (351 reviews)

Extend what your AppGini web applications can do. Learn the fine details of tailoring the generated code efficiently.

Created byAhmed Genedy

Last updated 10/2020

English

What you'll learn

Understand AppGini hook files, how they work and how to add code to them
Customizing the homepage and adding summary info and special links to it
Changing the appearance of the login page and saving audit data
Customize the layout of data entry forms
Creating efficient user-friendly search forms
Adding more actions to the data entry forms
Add validation rules, business logic and advanced calculations to data entry forms

Course content

12 sections • 33 lectures • 4h 36m total length

Welcome - Introduction to the AppGini customization course3:52
Explore app customization with AppGini using hooks to add validation, emails, reports, and custom buttons while preserving generated code. Learn through 30 examples across 4.5 hours.

Exploring the online demo2:05
Explore the Northwind demo to learn app customization with AppGini: view orders and order details, and see two homepage customizations—AppGini link and demo download—plus a theme switch.
Installing the Northwind demo locally3:57
Download and extract the Northwind demo, set up locally via localhost, configure database connection and admin credentials, and run the sql dump to populate the app data.
Overview of the generated files and creating a Git repository5:09
Explore the Northwind demo AppGini-generated app structure and its key files, then create a Git repository, perform the first commit, and track changes with green checkmarks.
Our first customization4:03
Customize your AppGini footer by editing footer-extras.php to replace the bottom with a date/time banner using bootstrap classes and the php date function, then commit changes to Git.
Overview of the Northwind demo application

Removing demo links3:05
Enable saving filters across all tables in the Northwind AppGini demo, refresh the app, and then remove the two demo links from the homepage by editing hooks/links-home and committing.
Adding a custom link4:17
Add a new unshipped orders link to the homepage by saving a filtered orders link, styling with panel-danger and btn-danger, and committing the change to the repository.
Displaying the count of records in a table5:52
Display a live orders count on the homepage table button by querying with sqlValue and updating the button via jQuery, then refine the query with get_sql_from to respect user access.
Linking to the most recent record in a table7:09
Display the most recent order date on the homepage and link to that order using a limited membership user records query with AppGini sql() and date() formatting via SelectID.
Customizing the homepage

Customizing the appearance of the login page7:59
Customize the AppGini login page by adding a background image, applying changes through the footer-extras hook, and moving marketing copy to the login_splash with jquery.
Reporting failed login attempts6:18
Create a logs table with ip, timestamp, and details fields, then log failed logins via login_failed() by storing the ip from $_SERVER['REMOTE_ADDR'], time(), and the username and password in details.
Customizing the login page

Organizing long forms into tabs12:49
Organize a long details form by creating two tabs in the customers detail view, moving fields with the dv hook, and implementing Bootstrap tabs to improve layout and usability.
Organizing long forms into a horizontal layout7:44
Learn to organize supplier detail forms into two fields per line horizontal layout using a dv hook, jQuery tweaks, and responsive CSS with Bootstrap.
Changing the detail view form layout

Understanding filters11:15
Explore AppGini filters to create customized product searches by defining search criteria with FilterField, FilterOperator, and FilterValue, and combining a unit price range of 20 to 30 dollars with FilterAnd.
Searching numeric ranges9:52
Customize the product search by using AppGini hooks to create a user-defined price-range filter with a products_filter.php, and implement text inputs labeled show prices between and apply.
Searching lookup fields16:38
Enhance the AppGini search page by adding a category filter with a select2 drop-down and ajax-based lookup, preserve price range and category filters across reloads, and improve layout.
Searching Date Ranges17:40
Learn to implement a date range search on the orders page, filtering by order date, with a bootstrap datepicker and correct date formatting for a smoother user interface.
Creating a customized search form

Adding action buttons linking to other pages12:36
Add and customize action buttons in the orders detail view using the dv hook, including a print invoice button and conditional visibility.
Creating a printable invoice, part 113:26
Create a printable invoice page in AppGini by wiring order_invoice.php, enforcing access with get_sql_from, fetching by OrderID via get_sql_fields and db_fetch_assoc, and building a themed invoice header.
Creating a printable invoice, part 214:32
Build a printable order invoice by querying order items from order_details, computing line totals, subtotals, shipping, and total, and rendering a Bootstrap table with a print invoice button.
Adding more action buttons to the detail view

Sending email notifications on new record16:09
Send a new order notification via PHP mail in AppGini using the after_insert hook, with proper headers, date formatting, and data from customers and employees tables.
Sending email notifications on field changes8:18
Learn to send email notifications when the shipped date changes in AppGini by comparing old and new values in the before and after update hooks.
Sending an email notification after adding/editing a record

Adding validation to forms10:22
Learn to add form validation in AppGini via a detail view -dv.js hook to enforce rules, like freight between 0 and 500, with modal errors.
Validating date fields14:27
Apply date validations in AppGini by enforcing ship date against order date and today for records, and validate new entries with yesterday, today, or tomorrow using get_date() to read dropdowns.
Adding validation rules to forms

Conditionally hiding detail view fields8:40
Intercept user actions in AppGini detail views with jQuery to conditionally hide or show fields; hide freight when ShipVia is empty_string and toggle discount based on quantity in order details.
Retrieving parent record info into detail view field11:06
Populate the unit price in the order details form by selecting a product from the products lookup, via ajax to fetch the price from the products table.
Showing/hiding fields in the detail view when a certain event is triggered

Requirements

Install AppGini Professional Edition. There are other programs and utilities needed (all are free or opensource), but we'll cover them in the course.

Description

AppGini is a program that makes it trivially easy for anyone with a PC to create powerful and great-looking web database applications for their work. Since 2003, thousands of users have used AppGini to create applications to manage inventory, payrolls, human resources, real estate, sales, invoicing, projects and tasks, community activities, and .. well, you name it.

All the above and much more can be done without writing a single line of code by using AppGini. However, AppGini offers the ability to customize the generated code by using hooks. And this is what this course is about.

I prepared this course for power users of AppGini, who'd like to add more functionality to their applications by writing custom code. Through 4.5 hours of video, we'll finish 30 practical examples, featuring more than 500 lines of code, that cover the most common hook questions I receive from users. You'll learn how to:

customize the login page,

add links to the main page and show the count of records,

organize long forms into tabs or change their layout,

change the filters page to look more friendly and efficient,

add custom buttons to forms to extend their functionality,

create invoices and similar report types,

add validation rules to forms to enforce business rules,

perform calculations on the fly,

and automatically update an order total field as items get added to the order.

I'll cover many common cases with detailed code .. all the code will be explained in a clear easy-to-follow pace so that you can write your own code afterwards. Moreover, I'll continue adding more and more lectures to expand the course and include additional cases. By signing up now, you'll also get all future lectures for free.

Who this course is for:

This course is meant for users of AppGini who are not afraid of using a text editor to write simple code to extend the functions of their AppGini applications. Prior programming knowledge is helpful but not essential.

Customizing AppGini web applications

What you'll learn

Explore related topics

Course content

Course Introduction1 lecture • 4min

Overview of the Northwind demo application4 lectures • 15min

Customizing the homepage4 lectures • 20min

Customizing the login page2 lectures • 14min

Changing the detail view form layout2 lectures • 21min

Creating a customized search form4 lectures • 55min

Adding more action buttons to the detail view3 lectures • 41min

Sending an email notification after adding/editing a record2 lectures • 24min

Adding validation rules to forms2 lectures • 25min

Showing/hiding fields in the detail view when a certain event is triggered2 lectures • 20min

Requirements

Description

Who this course is for: