Add Ons

AppGini add-ons allow you to extend the functionality of your generated application by adding specialized reports, charts, views ... We're developing an expanding list of add-ons to help you greatly enhance your web database applications.

DataTalk plugin for AppGini

DataTalk plugin for AppGini

DataTalk plugin for AppGini
License: Commercial, per-user
Compatible with any PC/server that can run PHP

DataTalk is an innovative AppGini plugin that allows you and your users to interact with your AppGini database using natural language questions. This eliminates the need for writing complex SQL queries and makes it easy for you to retrieve the data you're looking for quickly and efficiently.

With DataTalk, simply ask a question in plain English, and the plugin will translate it into SQL and return the appropriate result set. DataTalk's natural language processing technology is based on the famous ChatGPT API, ensuring accurate interpretation of your questions, making it an ideal solution for businesses and individuals who need to access and analyze data on a regular basis.

Ask questions, naturally
Interact with the database using natural language, just like you talk to your colleagues, eliminating the need for complex SQL syntax. Tip: You can ask DataTalk questions in any language, and ChatGPT will understand them and translate them into SQL code. You could even learn the right SQL syntax by asking DataTalk human questions and copying the generated SQL code.

Multilingual support
DataTalk is available in multiple languages. You can easily set the UI language to your preferred language, and you can ask questions in any language, not just English.

Translation to SQL
DataTalk translates your questions into SQL code, so you don't need to be familiar with database programming. You can copy the SQL code with a single click and use it as-is or customize it in the Interactive SQL queries tool in the admin area of your AppGini application.

Integration with AppGini
DataTalk already knows your AppGini database structure and how to access its contents. No configuration needed. No prompt engineering games. Just start using it out of the box.

User-friendly interface
DataTalk's intuitive interface makes it easy for you to navigate and use in no time.

Like ChatGPT itself, DataTalk takes a minimalistic approach to design, so you can focus on your data and not on the interface. Nonetheless, DataTalk provides many powerful features without sacrificing usability.

Questions history
DataTalk automatically keeps a history of your questions, so you can easily review and re-run them. You can always delete a question from the history if you don't need it anymore. If you click the question text, it will be copied to the input field for you to either edit then re-run, or to run as-is. If the question was asked before, DataTalk will run the corresponding SQL query without resending it to ChatGPT for a faster response.

Export results
Export your results to CSV. You can then easily import them into Excel or any other spreadsheet application. You can also share the CSV file with your colleagues, vendors, or customers.

Saved reports
DataTalk allows you to save your questions and results as reports that you can share with other users of your app. Reports can be static (a snapshot of data at a specific point in time) or dynamic (updated with the latest data).

Frequently asked questions

What's the minimum version of AppGini required for running DataTalk plugin?
The latest version of AppGini is generally recommended when running AppGini plugins. DataTalk 2.0 was tested with AppGini 24.17.
Do I need a ChatGPT account to use DataTalk plugin?
Yes, the first time you open the plugin, you'll be asked to provide a ChatGPT API key. You can currently create a ChatGPT account and obtain an API key for free. You can use that API key for a free trial period, after which you are billed for usage on a pay-as-you-go basis. To give you an idea of pricing, 200 questions would cost around USD 1 or so. And to help reduce your API usage, DataTalk caches questions to avoid making repeated requests to the ChatGPT API. More details on ChatGPT API pricing and rate limits.
Does ChatGPT/OpenAI access my database when I use DataTalk?
No. When you ask a question, DataTalk prepares a prompt consisting of your question and the simplified schema of the database. The prompt doesn't include any data from your database. ChatGPT doesn't have access to your database or the data stored in it. For more detailed info, please click the Data safety button in the plugin's interface.
Which users of my app can access the DataTalk plugin?
Only the admin users can access the DataTalk plugin. This is because the SQL queries returned by ChatGPT can't be modified to limit the results to a specific user. You can, however, export the results to CSV and then share the CSV file with other users of your app.
Some questions result in an SQL error similar to "An error occured while processing your question. Unknown column in field list". How can I fix that?
ChatGPT tries to understand your question and return an SQL query to fetch the data you're looking for. Sometimes, the query it returns is not valid, mainly due to ChatGPT "hallucinating" field names that don't exist in your tables. See the screenshot below for an example. An error occured while processing your question. Unknown column in field list. One way of fixing such errors is to modify your question to include a hint about which tables to use for answering the question. Here is an example hint for the above question that fixes the error: Use table hints to fix ChatGPT SQL errors.
If a new version of AppGini is released, do I need to update this plugin as well?
Usually not. However, if an update is needed we'll issue it free-of-charge.
I already have another plugin installed. Is it safe to install this plugin to the same app into the same plugins folder?
Yes. AppGini plugins share a common set of files that ship with all plugins and are safe to overwrite. Plugin-specific files are installed into a separate subfolder under the plugins folder. So, it's safe to extract this plugin to the plugins folder, overwriting existing files. Both plugins will continue to work fine.
If you make a new version of this plugin, do I have to pay to upgrade?
No. All AppGini plugins come with free life-time updates.
I have several AppGini applications. Do I have to buy a separate license of this plugin for each?
No. When you buy any AppGini plugin, you can install it to all of your AppGini applications. However, just like AppGini, if you are a team of users who use AppGini as part of your development toolset, each user should have a separate license.
Does the DataTalk plugin add any code to hook files?
No. The DataTalk plugin runs only from the plugins/datatalk folder. It does not add any code to hook files.
I have a question not addressed here ... how can I contact you?

What's new?

Latest version: 2.0, released on Aug 21, 2024
  • DataTalk 2.0, Aug 21, 2024
    • Switched to GPT4o Mini: Benefit from faster, more accurate, and cost-effective performance with the new ChatGPT model.
    • Advanced Reporting Capabilities: Create static reports to capture data snapshots as it was at a specific point in time or dynamic reports that stay up-to-date with the latest information. This flexibility helps you make informed decisions. You can also specify which groups can access specific reports.
    • Easy Report Access: Reports are now accessible from the application homepage and top navigation menu.
    • Admin Features: Admins can now quickly access OpenAI API usage and costs from the settings page. Also can easily delete and list all saved reports for efficient data handling.
    • Multilingual Support: Now available in Dutch, Italian, Portuguese, Spanish, French, Greek, German, and Arabic, making DataTalk more accessible. It's very easy to add more languages by simply copying a single file and translating it.
    • Enhanced User Interface: Enjoy a smoother and more intuitive navigation with our updated UI.
    • Improved Error Reporting.
    • Improved Prompting: Get better and more accurate results with refined prompts.
  • DataTalk 1.3, Dec 13, 2023
    • Fix PHP 8.x warnings.
  • DataTalk 1.2, Jul 28, 2023
    • Upgrade model to chatgpt-3.5-turbo (the model used in previous versions, davinci, is deprecated and 10 times as expensive).
    • Increase accuracy through a better prompt.
    • Better security by separating prompt to system and user roles.
  • DataTalk 1.1, Jun 10, 2023
    • Preserve history panel expansion status.
    • Better error handling in case of expired API key.
  • DataTalk 1.0, Apr 25, 2023
    • First release!

Messages Plugin for AppGini

Messages plugin for AppGini

Messages plugin for AppGini
License: Commercial, per-user
Compatible with any PC/server that can run PHP

Messages plugin allows your AppGini app users to easily and securely communicate without leaving the app, and without having to exchange emails/contact info. This is done through an intuitive webmail-like interface, except it doesn't have the annoying distractions of email ads and spam. And you have full control over which users/groups are allowed to communicate together.

Users get notified instantly inside the app when they have new messages

They get a visual hint on the top of each page when they have unread messages, plus a short subtle audio notification when a new message arrives. You can also optionally enable email notifications to make sure they don't miss out!
Message notification badge on top of page
Recipients auto-complete drop-down allowing selection of users, groups, or everyone

Send messages to one or more users, an entire group, or to all users

Specifying message recipients is a breeze. Users don't have to remember contacts as they can just select or search for them in an auto-complete box. And if allowed, they can send a message to an entire group or to all application users.

Compose richly formatted messages using markdown

Messages plugin supports markdown, allowing users to compose richly formatted messages with ease. They can use markdown to format text, add images, links, and even embed videos. Messages are sanitized to prevent XSS attacks and other security issues. So, you can be sure that your users are safe.
Edit communication rules for every user group

Securely control which users can communicate with each other

The Messages plugin allows you to set granular rules for how users can communicate. For example, you can specify that only managers can send messages to board members, board members can send global messages, ...etc.

Fast, intuitive and super easy webmail-like interface

Users don't have to learn anything new to start using the Messages plugin. This is because we made sure when designing the UI that it resembles communication tools they are already used to working with. It'd feel just natural to view incoming messages, reply to them, forward them, and view messages in threads.
Message threads are easy to follow
Developers guide, with clear code examples

Programmable message functions

The Messages plugin is programmable too! You can automate communications to handle specific events/actions. For example, you can send an automated message to shippers when an order is packaged ready for dispatching. Or you can let users share and discuss records via messages. The developers' guide includes clear code examples that you can easily modify to fit your own workflow.

See messaging stats and usage patterns

Application admins can view top users activity stats to better understand how users communicate. This provides bird's eye view visibility, allowing you to set the right communication rules for improving your users experience and facilitating more effective conversations.
Message stats and top users

How to install and configure the Messages plugin

Frequently asked questions

Which version of AppGini is required for running messages plugin?
The latest version of AppGini is generally recommended when running AppGini plugins, but AppGini 5.98 or above is required.
If a new version of AppGini is released, do I need to update this plugin as well?
Usually not. However, if a plugin update is needed we'll issue it free-of-charge.
I already have another plugin installed. Is it safe to install this plugin to the same app into the same plugins folder?
Yes. AppGini plugins share a common set of files that ship with all plugins and are safe to overwrite. Plugin-specific files are installed into a separate subfolder under the plugins folder. So, it's safe to extract this plugin to the plugins folder, overwriting existing files. Both plugins will continue to work fine.
If you make a new version of this plugin, do I have to pay to upgrade?
No. All AppGini plugins come with free life-time updates.
I have several AppGini applications. Do I have to buy a separate license of this plugin for each?
No. When you buy any AppGini plugin, you can install it to all of your AppGini applications. However, just like AppGini, if you are a team of users who use AppGini as part of your development toolset, each user should have a separate license.
Does the Messages plugin add any code to hook files?
Yes, Messages plugin will insert a single line of code into hooks/header-extras.php. The purpose of this line is to display the messages notification icon on top of the pages of your application.
How do I backup messages and restore them later?
You can use the database backup tool under the Utilities menu in the admin area to back up or restore your application database, which includes the messages tables as part of it.
I have a question not addressed here ... how can I contact you?

What's new?

Latest version: 1.5, released on Feb 8, 2024
  • Messages 1.5, Feb 8, 2024
    • Add support for rendering sanitized markdown when composing messages, with ability to preview.
    • Add option to show table menus in inbox page (enable from settings).
    • Refactor message forwarding to use markdown.
      Format forwarded message using markdown
    • Fix position of message alert.
    • Update messaging permissions labels for clarity.
    • Add explanation message in group permissions table in settings page if no groups are found.
    • Fix unread count url.
    • Add MessagesDB::dbInstalled() to check if db is installed, and perform a check in inbox page.
    • Fix bug in stats page.
    • Move js and css to dedicated dirs.
    • Fix lang error on loading of threads.
    • Fix bug preventing display of groups in recipients list when sending messages.
    • Fix display of 'ALL' in 'Allowed recipient groups' in settings.
    • Fix mobile counter badge.
  • Messages 1.4, Dec 13, 2023
    • Fix PHP 8.x warnings.
  • Messages 1.3, May 27, 2023
    • Fix bug in MessagesDB::canSend() causing 'Invalid recipient' error.
    • Fix modal backdrop issue in settings.
    • Fix request to get unread messages count.
  • Messages 1.2, Jul 14, 2022
    • Add option to customize the format of the recipients list when composing a new message.
    • Support for plugin_messages_listAllowedRecipients($type, $defaultRecipients) hook (can be defined in hooks/__global.php) to filter the recipients list (see the developers guide inside the plugin for full details).
  • Messages 1.1, Apr 25, 2022
    • Support for new profile menu added in AppGini 22.13 and above.
    • New option to open the inbox in a separate page when clicking the icon.
    • During install, if the step for installing messages icon into header-extras.php fails, specify the line that should be added on screen so user can manually add it.
    • Bug fix while creating plugins/projects path.
    • Update messages icon.
  • Messages 1.0, Mar 17, 2022
    • First release :)

Calendar plugin for AppGini

Calendar plugin for AppGini

Calendar plugin for AppGini
License: Commercial, per-user
Compatible with any PC/server that can run PHP

With the Calendar plugin for AppGini, you're able to see how your records (which could be tasks, projects, orders, events, or any other kind of data with a date/time) are organized over time. You can also directly add new records into the calendar, making it much easier to assign dates correctly, avoiding conflicts with other records.

Switch between 4 views (month, week, day, agenda)
Calendar plugin displays events from your database in 4 calendar views that users can easily switch between with a button click and no delay: Month view, week view (showing 7 days, with a time grid), day view (with a time grid), and agenda (list) view, displaying list of events of an entire week.

Add multiple color-coded event types to each calendar.
Calendar plugin allows you to create one or more calendars, and select one or more types of events to display in each calendar. You can assign a different color to each type of events for easier recognition by users.

View (and edit) events details with a click of a mouse
When users click on an event, this opens the detail view of the corresponding record in a modal window on top of the calendar. Users can then view other event details, and even make changes to the event (if they have permission to). When the user closes the modal window, changes are automatically applied in the calendar.

Add new events directly inside the calendar
Users with insert permission to an event's table can click anywhere inside a calendar to create a new event, just like in Google Calendar. The new event will have its date/time fields smartly adjusted to the matching date/time in the calendar, saving users a few steps each time.

Easily customize calendars to match all your use cases
You can specify a custom WHERE clause when creating events. For example, you could distinguish non-shipped orders, giving them a red color, from shipped ones, with green color, by creating 2 separate 'order' events, each with different WHERE conditions.

You can also add a JavaScript handler when creating a new event. This is very useful to set default values for one or more fields based on the event type. Calendar plugin is based on the awesome open source fullcalendar, which has very well-oranized documentation, making it easy to modify the calendar behavior to match your desired use cases.

Frequently asked questions

Which version of AppGini is required for running Calendar plugin?
The latest version of AppGini is generally recommended when running AppGini plugins, but AppGini 5.98 or above is required.
If a new version of AppGini is released, do I need to update this plugin as well?
Usually not. However, if an update is needed we'll issue it free-of-charge.
I already have another plugin installed. Is it safe to install this plugin to the same app into the same plugins folder?
Yes. AppGini plugins share a common set of files that ship with all plugins and are safe to overwrite. Plugin-specific files are installed into a separate subfolder under the plugins folder. So, it's safe to extract this plugin to the plugins folder, overwriting existing files. Both plugins will continue to work fine.
If you make a new version of this plugin, do I have to pay to upgrade?
No. All AppGini plugins come with free life-time updates.
I have several AppGini applications. Do I have to buy a separate license of this plugin for each?
No. When you buy any AppGini plugin, you can install it to all of your AppGini applications. However, just like AppGini, if you are a team of users who use AppGini as part of your development toolset, each user should have a separate license.
Does the Calendar plugin add any code to hook files?
Yes, Calendar plugin will insert links to created calendars into the hooks/links-home.php and hooks/links-navmenu.php files. The inserted code is wrapped inside easily recognizable comments, and will not overwrite any code you already have in these files.

The plugin also modifies the files hooks/tablename-dv.js for every table that contains events.

We highly recommend that you use Git to manage customized code in your applications.
I have a question not addressed here ... how can I contact you?

What's new?

Latest version: 1.7, released on Dec 13, 2023
  • Calendar 1.7, Dec 13, 2023
    • Fix PHP 8.x warnings.
  • Calendar 1.6, May 4, 2022
    • Drop support for IE 8, 9.
    • Compatibility with AppGini 22.13.
    • Fix error when creating plugins/projects folder in some scenarios.
  • Calendar 1.5, Oct 31, 2021
    • Fixed stored xss vulnerability in calendar event title.
    • Fix compatibility issues with PHP 8, 8.1
  • Calendar 1.4, Jan 19, 2021
    • Compatibility with apps created by AppGini 5.93.
  • Calendar 1.3, Dec 2, 2020
    • Add plugin version checker/notifier.
  • Calendar 1.2, Oct 28, 2020
    • Improved handling of non-Latin and accented characters.
    • Fix bug with date calculations.
    • Add option to configure event text and background colors separately (to avoid display issues with some dark themes).
  • Calendar 1.1, Apr 19, 2020
    • Fixed a bug where projects with tables that contain a single field failed to load.
  • Calendar 1.0, Mar 29, 2020
    • First release.

BizzWorxx AppGini Helper JavaScript Library

bizzworxx AppGini Helper JavaScript Library

bizzworxx AppGini Helper JavaScript Library
License: Commercial, per-user
Compatible with any PC/server that can run PHP

AppGini Helper JavaScript Library is a powerful plugin provided by bizzworxx. It allows you to rapidly customize the user interface of your AppGini applications through easy one-line commands that are well-documented and easy to understand.

Some examples of how you can customize the UI: You can adjust the layout of input forms, hide fields or add additional buttons at runtime. Many commands are one-liners and thus easy to understand even for beginners. Benefit from the numerous layout functions and give your users a modern user experience. Increase productivity with easy-to-use input forms by grouping fields, inserting headings and additional hints, or through additional buttons in the table views or input screens.

What's new?

Latest version: 20191127-01, released on Nov 27, 2019
Please refer to the changelog for full details.

Mass Update plugin for AppGini

Mass Update plugin for AppGini

Mass Update plugin for AppGini
License: Commercial, per-user
Compatible with any PC/server that can run PHP

Mass update plugin makes it very easy to apply a change to multiple records at once. Update order statuses, invoice payments, task priorities, ... you name it. Save your valuable time and boost your daily workflow efficiency.

Add as many batch commands as you wish, with easily recognizable icons
Mass Update plugin allows you to create any number of commands for any tables in your AppGini application. And to help quickly identify various commands, you can choose a separate icon for each command among more than 260 beautiful ones.

Full control over who can access each command
Only accountants can mark transactions as reconciled, only managers and supervisors can approve employee leave requests, ... Mass Update plugin makes it easy to specify which group(s) can access each command.

Instantly add, edit, and remove commands
Feel free to experiment with batch commands. Mass Update plugin gives you full flexibility to add, edit and delete commands, and to instantly apply the changes to your AppGini application.

Update a field with a fixed value, or allow users to specify
You can configure batch commands to change the field value to a fixed predetermined one, or to a value that the user can manually specify. This provides a fine balance between speed (instantly change fields with a single click), and control (allow users to specify the exact new value in just one extra step).

Smart handling of various field types
Batch commands that change date fields display date pickups to users. Those that change time fields display time pickups. Commands that change checkbox fields allow users to check, uncheck or toggle fields. Lookup and option list fields display auto-complete drop-downs for users to quickly and accurately select new values.

Installation

To install the plugin, sign in to your AppGini app as admin, go to the Admin area > Plugins menu > Install a plugin. Follow the steps from there. Here is a short video to walk you through the process:

Using the Mass Update plugin to add a batch command

Frequently asked questions

Which version of AppGini is required for running Mass Update plugin?
The latest version of AppGini is generally recommended when running AppGini plugins, but AppGini 5.98 or above is required.
If a new version of AppGini is released, do I need to update this plugin as well?
Usually not. However, if an update is needed we'll issue it free-of-charge.
I already have another plugin installed. Is it safe to install this plugin to the same app into the same plugins folder?
Yes. AppGini plugins share a common set of files that ship with all plugins and are safe to overwrite. Plugin-specific files are installed into a separate sub-folder under the plugins folder. So, it's safe to extract this plugin to the plugins folder, overwriting existing files. Both plugins will continue to work fine.
If you make a new version of this plugin, do I have to pay to upgrade?
No. All AppGini plugins come with free life-time updates.
I have several AppGini applications. Do I have to buy a separate license of this plugin for each?
No. When you buy any AppGini plugin, you can install it to all of your AppGini applications. However, just like AppGini, if you are a team of users who use AppGini as part of your development tool set, each user should have a separate license.
I noticed that Mass Update plugin can automatically configure hooks. If I have customized hooks in a project, will the plugin overwrite them?
No, Mass Update plugin will just insert its code into the beginning of the tablename_batch_actions hook function, with comments marking the start and end of the inserted plugin code, and instructions on how to merge your own code. It won't replace your existing custom code, but we highly recommend that you revise the code, read the generated instructions, and apply any advised changes.

The plugin will also append code to tablename-tv.js hook file and to footer-extras.php. Again, this won't overwrite your existing code. And the plugin code will have comments marking its start and end so you can easily recognize it.

We highly recommend that you use Git to manage customized code in your applications.
I created some batch commands for an app but now I want to remove them all. How do I "uninstall" all batch commands from my app?
If you want to delete all code generated by Mass Update plugin from your app, open the hooks folder of that app and delete all files beginning with ajax-mass-update. Next, open the files tablename.php, tablename-tv.js, and footer-extras.php and delete the Mass Update code from them. You can easily recognize this code as it all has a comment marking the start of it, and another comment marking its end.

We highly recommend that you use Git to manage customized code in your applications.
I have a question not addressed here ... how can I contact you?

What's new?

Latest version: 1.8, released on Feb 22, 2024
  • Mass update 1.8, Feb 22, 2024
    • Prevent the browser reload warning when updating the page after running a batch command.
    • Add option to trigger update hooks in the command editor. This is useful if you have custom code in the tablename_before_update or tablename_after_update hooks that you want to run when a batch command is executed.
      Note: Don't use this option with hidden fields; the batch command will not be executed if the field is hidden.
    • Add a clarification in the hint for fixed value commands when applied to lookup fields.
  • Mass update 1.7, Dec 13, 2023
    • Fix PHP 8.x warnings.
  • Mass update 1.6, May 4, 2022
    • Compatibility with AppGini 22.13.
    • Fix issues with creating 'projects' folder under some scenarios.
  • Mass update 1.5, Oct 31, 2021
    • Fix errors with contents of dropdowns for radio lookups.
    • Fix bug where non-existing field caused errors in navigating tables.
    • Fix compatibility issues with PHP 8, 8.1
  • Mass update 1.4, Jan 19, 2021
    • Compatibility with apps created by AppGini 5.93.
  • Mass update 1.3, Dec 2, 2020
    • Add plugin version checker/notifier
    • Show a default table icon if set one not found in project viewer.
    • Fix buggy UI behavior when pressing Home/End multiple times in project viewer.
  • Mass update 1.2, Nov 9, 2020
    • Replace (rather than skip) mass update code in footer-extras.php.
    • Fix warning occurring in some scenarios 'Parameter must be an array or an object that implements Countable'.
    • Fix bug with mass updating option list fields.
    • Fix: js error when trying to apply a mass update command directly after saving a record.
    • Load latest version of jQuery.
    • Fix issues with non-Latin characters in data.
    • Bug fix when opening a project containing tables with a single field.
  • Mass update 1.1, Mar 28, 2020
    • Fixed issue with mass update commands that are available to all groups.
    • Improved plugin UI.
    • Allow downloading and deleting of uploaded project files.
  • Mass update 1.0, June 12, 2019
    • First release!

Summary Reports plugin for AppGini

Summary Reports plugin for AppGini

Summary Reports plugin for AppGini
License: Commercial, per-user
Compatible with any PC/server that can run PHP

Summary Reports plugin enables you to build powerful reports and charts inside your AppGini application through a few simple steps. See the big picture and discover trends in your data that empower you to take the right decisions confidently.

Intuitive reports that tell an intriguing story. Summary Reports plugin creates beautiful, easy-to-understand reports that don't just summarize data. With a glance at the report, you can see the big picture behind the tons of daily details. And you can see the trends and changes in your data over time. Make decisions with confidence in the shortest time.

Visualize your data and instantly see patterns and trends. With the Summary Reports plugin, you can create beautiful bar and pie charts that allow you to visually compare summarized data across not only categories, but also date periods. You can instantly spot trends and patterns in a natural way and communicate your ideas flawlessly. Charts are themeable and very easy to configure.

Export report data to CSV. Users can export report data to CSV and open in Excel or other spreadsheet software and perform advanced analysis and processing. So, even if Summary Reports is missing some feature you'd like to have, you can easily continue your workflow in Excel.

Explore data insights interactively. Generated summary reports come with a report configuration dialog that empowers users to interactively set the report date range, comparison period, sorting, and other options. This makes exploring data and discovering trends a piece of cake.

A friendly interface that makes creating reports a breeze! You don't need to learn or experiment with complex SQL or programming code to create summary reports. The Summary Reports plugin has a very intuitive interface that makes it trivially easy to create any number of reports in no time. And you can control who has access to each report. Create, edit and delete reports on the fly from any where. Feel free to explore!

Features in brief

  • Five ways to summarize your data: Count, sum, average, maximum and minimum.
  • Easily create great-looking bar and pie charts. Charts can be configured by users (colors themes, orientation, dimensions, .. etc).
  • Users can export report data to CSV to open it in Excel for advanced analysis.
  • Filter reports by up to 3 date ranges. Users can optionally limit reports to a specific date range. They can also define up to 3 date ranges per report to compare and discover trends in their data.
  • Drill down to details. Summary reports show summarized data (totals, averages, counts, .. etc) and allow you to click on the figures to open a filtered table view to explore the details from which the summaries were calculated.
  • Flexible customization of report data through SQL. You can optionally add custom WHERE conditions using standard SQL syntax to control which data is included/excluded from reports.
  • Restrict report data on a per-user basis. By default, summary reports are limited to user-accessible records rather than all records (with an option to disable this if desired).
  • Control who can access each report. For each report, you can allow access to all user groups, or specify which groups have access.
  • Create reports from any web browser. You don't need access to your PC to create and edit reports. Just sign in as admin from any browser on any device and control your summary reports.
  • Reports configuration is saved in your AXP project file. Thus, you can safely work with your project in AppGini and re-open it in the plugin without losing any of your reports.
  • One time installation. You don't need to install Summary Reports plugin into each AppGini app you have. You can install it into one single app and create reports for all other apps you have on the same server.

Installation and usage tutorial

Frequently asked questions

Which version of AppGini is required for running Summary Reports plugin?
The latest version of AppGini is generally recommended when running AppGini plugins, but AppGini 5.98 or above is required.
If a new version of AppGini is released, do I need to update Summary Reports plugin as well?
Usually not. However, if an update is needed we'll issue it free-of-charge.
I already have another plugin installed. Is it safe to install this plugin to the same app into the same plugins folder?
Yes. AppGini plugins share a common set of files that ship with all plugins and are safe to overwrite. Plugin-specific files are installed into a separate subfolder under the plugins folder. So, it's safe to extract this plugin to the plugins folder, overwriting existing files. Both plugins will continue to work fine.
If you make a new version of Summary Reports, do I have to pay to upgrade?
No. If you buy Summary Reports plugin, you get free life-time updates to it.
I have several AppGini applications. Do I have to buy a separate license of Summary Reports plugin for each?
No. When you buy Summary Reports plugin, you can install it to all of your AppGini applications. However, just like AppGini, if you are a team of users who use AppGini as part of your development toolset, each user should have a separate license.
I noticed that Summary Reports plugin can automatically configure the hooks. If I have custom hooks in a project, will Summary Reports plugin overwrite them?
No, it will just insert its code into the links-home.php and links-navmenu.php files without replacing any existing code.
I created some summary reports for an app but now I want to remove them all. How do I "uninstall" summary reports from my app?
If you want to delete all summary reports from an app, open the hooks folder of that app and delete SummaryReports.php and all the files starting with summary-reports. Next, open the files links-home.php and links-navmenu.php and delete the summary reports entry from both.
Charts in my report don't display all the records that appear in the report table. How can I fix that?
By default, charts display only the first 20 records to make it easier to read, without cluttering the chart with lots of points. You can change this by editing the report file (which you can find in the hooks folder .. the file name is displayed in your browser address bar when you view the report). Find this line in the file and change the value as desired:
'chart_data_points' => 20,
How can I translate the interface of the reports from English to another language?
Summary reports use text defined in the file hooks/language-summary-reports.php. You can edit the strings in this file to translate the reports to your language. But first, please check the language download page to see if a translation is already available for your language.
I have a question not addressed here ... how can I contact you?

What's new?

Latest version: 3.5, released on Dec 13, 2023
  • Summary Reports 3.5, Dec 13, 2023
    • Fix PHP 8.x warnings.
  • Summary Reports 3.4, May 4, 2022
    • Compatibility with AppGini 22.13.
    • Drop support for IE 8, 9.
    • Fix error when creating plugins/projects folder in some scenarios.
  • Summary Reports 3.3, Oct 31, 2021
    • Fix bug identifying report date field in reports list
    • Clear warning message for reports with no parent table.
    • Fix bug in parsing report dates in PHP 7.3+
    • Fix CSV file naming issue and CSV file encoding
    • Fix caption of summary column
    • Fix bug with loading saved reports in some cases.
    • Security fixes: sanitize date parameters against reflected XSS, and fix a stored xss issue.
    • Fix compatibility issues with PHP 8, 8.1
  • Summary Reports 3.2, Jan 19, 2021
    • Compatibility with apps created by AppGini 5.93.
  • Summary Reports 3.1, Dec 2, 2020
    • Fix bugs with non-Latin data encoding.
    • Load the latest existing jquery lib.
    • Add plugin version checker/notifier.
    • Show a default table icon if set one not found in project viewer.
    • Fix buggy UI behavior when pressing Home/End multiple times in project viewer.
  • Summary Reports 3.0, Apr 18, 2020
    • Screenshot summarizing major changes
    • By default, summary reports are limited to user-accessible records rather than all records.
    • New report editor option to show all records in reports, overriding user permissions.
    • New report editor option to add custom WHERE conditions using standard SQL syntax to control which data is included/excluded from reports.
    • New fields dialog in report editor to list possible fields for use in the custom WHERE clause of reports.
    • UI enhancements
      • Add Compact mode to report editor form, and persist this setting.
      • Preserve reports list detail level when re-opening project page.
      • Show reports count in the tables list.
      • Hide Clear reports button if there are no reports to clear.
      • Add help hint to all report editor action buttons.
      • Various other improvements in report editor.
      • Add icons to report titles in reports list indicating reports with custom WHERE and those with override permissions.
      • Collapsing report config panel in generated reports applies changes, without having to scroll down and click 'Apply'.
    • Bug fixes
      • Bug fix when opening a project containing tables with a single field.
      • Add a logging function in reports that is triggered by passing _debug=1 to the report URL (only works on localhost and for super admin user).
      • Strip HTML tags from labels when plotting charts (since charts don't support HTML rendering anyway and fall back to showing raw HTML labels).
      • Fix bug leading to overwriting some reports on editing other ones.
      • Include 'from to' part of the report title in translation file.
  • Summary Reports 2.1, Mar 28, 2020
    • Option to clear old existing reports in a project.
    • Improved plugin UI.
    • Various bug fixes.
  • Summary Reports 2.0, January 14, 2019
    • Added customizable bar and pie charts to reports.
    • Added ability to export report data to CSV file.
    • Added option to include a report header and footer.
    • Optimizing reports performance when summarizing huge data sets.
    • Easily toggle highlighting of rows in the report by clicking on them.
    • Added inline help to report editor.
    • Added a language file to easily translate reports.
    • Many improvements and bug fixes.
  • Summary Reports 1.01, May 16, 2018
    • Bug fix for date range where condition + code refactoring
  • Summary Reports 1.00, May 15, 2018
    • First release!

Search Page Maker Plugin for AppGini

Search Page Maker plugin for AppGini

Search Page Maker plugin for AppGini
License: Commercial, per-user
Compatible with any PC/server that can run PHP

Search Page Maker (SPM) enables you to build user-friendly yet powerful search pages for your AppGini application by simply dragging and dropping the fields you want to include in search.

User-friendly and powerful search. SPM plugin allows you to create beautiful and user-friendly search pages, with support for date pickups, date and number ranges, auto-complete drop-downs, radio button options, and other easy-to-use search controls.

Simple and advanced search modes. Most of your application users would just love the new search pages created by SPM due to being simple yet powerful. However, the more advanced users might still want more control over search criteria. So we added a 'Switch to advanced search mode' button that switches between the SPM search page and the standard one generated by AppGini.

Fun to use! SPM plugin makes it very easy to design the search page for each of your application tables. It's as easy as dragging and dropping fields to include and order them. And you can also specify whether to show the 'Sort by' options or hide them.

Easy installation. To install SPM into any of your AppGini-generated applications, just unzip it into the application folder. Once you do this, you can access SPM from a 'Plugins' drop-down menu that will automatically show up to the admin user.

Frequently asked questions

Which version of AppGini is required for SPM?
The latest version of AppGini is generally recommended when running AppGini plugins, but AppGini 5.98 or above is required.
If a new version of AppGini is released, do I need to update SPM as well?
Usually not. However, if an update is needed we'll issue it free-of-charge.
I already have another plugin installed. Is it safe to install this plugin to the same app into the same plugins folder?
Yes. AppGini plugins share a common set of files that ship with all plugins and are safe to overwrite. Plugin-specific files are installed into a separate subfolder under the plugins folder. So, it's safe to extract this plugin to the plugins folder, overwriting existing files. Both plugins will continue to work fine.
If you make a new version of SPM, do I have to pay to upgrade?
No. If you buy SPM, you get free life-time updates to it.
I have several AppGini applications. Do I have to buy a separate license of SPM for each?
No. If you buy SPM, you can install it to all of your AppGini applications. However, just like AppGini, if you are a team of developers who use AppGini as part of your development toolset, each developer should have a separate license.
I noticed that SPM can automatically configure the hooks. If I have custom hooks in a project, will SPM overwrite them?
No, it will just insert a single line of code into the tablename_init hook, directly after the function definition line ... It won't affect any of your hooks code.
I have a question not addressed here ... how can I contact you?

What's new?

Latest version: 1.5, released on Dec 13, 2023
  • SPM 1.5, Dec 13, 2023
    • Fix PHP 8.x warnings.

SPM 1.4, May 4, 2022

  • Compatibility with AppGini 22.13.
  • Bug fix while creating plugins/projects path in some scenarios.

SPM 1.3, Oct 31, 2021

  • Fix bug with displaying contents of dropdowns for radio lookups.
  • Fix duplicates in dropdowns.
  • Fix compatibility issues with PHP 8, 8.1
  • Fix datetime picker format.

SPM 1.2, Jan 19, 2021

  • Compatibility with apps created by AppGini 5.93.

SPM 1.1, Dec 2, 2020

  • Include auto-fill lookups in filterable fields.
  • Fix bug with tables that have only one field.
  • Fix bugs with non-Latin data encoding.
  • Load the latest existing jquery lib.
  • Add plugin version checker/notifier.
  • Show a default table icon if set one not found in project viewer.
  • Fix buggy UI behavior when pressing Home/End multiple times in project viewer.

SPM 1.09, Mar 28, 2020

  • Improved plugin UI
  • Persist user-selected search mode (users who prefer advanced search mode would see it by default until they switch back to simple mode)

SPM 1.08, Dec 9, 2018

  • Fixed a bug with displaying filtered values for required lookup fields in filters page.
  • Added a refresh button to the 'Select output folder' page.

SPM 1.07, May 6, 2018

  • Fixed bug with detecting jquery file version that caused SPM to stop working on apps created newly by AppGini 5.70.
  • Some UI enhancements.

SPM 1.06, Apr 15, 2018

  • Fixed bug with searching multiple-choice drop-downs where no results were returned.

SPM 1.05, Mar 9, 2018

  • Updated header.php to load jQuery version supplied with AppGini 5.70.
  • Code refactoring for 'Select output folder' page.
  • Included new table icons shipped with AppGini 5.70.

SPM 1.04, Oct 10, 2016

  • Fixed a bug with date format when searching a date range.

SPM 1.02, Apr 25, 2016

  • Fixed a bug that took place when running SPM on PHP 7.

SPM 1.01, Mar 11, 2016

  • More descriptive path errors in 'select output folder' page.

SPM 1.0, Mar 9, 2016

  • First public release.
Syndicate content