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
Overview of the generated files and creating a Git repository5:09
Our first customization4:03
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
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

Understanding filters11:15
Searching numeric ranges9:52
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
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

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: