Features

  • Supports 5 database types

    • MySQL, PostgreSQL, Microsoft SQL Server, Oracle, SQLite, on Linux or Windows web server
    • Support encryption connection with MySQL/PostgreSQL
    • URL connection script to simulate direct connection with MySQL/PostgreSQL
  • List, Add/Copy, View, Edit, Delete, Multi-Update and Search pages


  • Multi-Column List Page - Table/Cards Views

    • Multi-column cards by Bootstrap Cards
    • Responsive multi-column layout
    • Improved list options button and 4 positions (top/bottom-left/right)
    • Switchable between regular table view and cards view by Ajax
    • Support Custom Template in both views
    • Support Bootstrap card-* classes


    Table view


    Cards view with card-* classes

  • Modal Dialogs

    • Add/Copy, View, Edit, Delete, Multi-Update and Search pages in List page
    • Login, Registration, Change Password, Password Recovery page

  • Optional Tabular Form for Desktop Mode


  • Summary Report


    Detail and summary report


    Compact summary report

  • Crosstab Report


  • Calendar Report


    Calendar Report ("dayGridMonth" view)


    Context menu


    Popover with matching style

  • JavaScript Charts by Chart.js

    • Column 2D Chart
    • Bar 2D Chart
    • Pie 2D Chart
    • Line 2D Chart
    • Area 2D Chart
    • Doughnut 2D Chart
    • Multi-series Column 2D Chart
    • Multi-series Line 2D Chart
    • Multi-series Area 2D Chart
    • Multi-series Bar 2D Chart
    • Stacked Column 2D Chart
    • Stacked Area 2D Chart
    • Stacked Bar 2D Chart
    • Multi-series 2D Single Y Combination Chart (Column/Line/Area)
    • Stacked Column 2D + Line Single Y Axis Chart
    • Multi-series 2D Dual Y Combination Chart (Column/Line/Area)
  • Drill Down Reports and Charts


    Drill down reports


    Drill down charts


    Chart with trend line

  • Dashboard Report


  • Grouping Intervals for Reports

    Summary Report Crosstab Report
    Numeric field Text field Datetime field Datetime field (for Column Headings)
    • Normal (All distinct values)
    • 10s
    • 50s
    • 100s
    • 500s
    • 1000s
    • 5000s
    • 10000s
    • Normal (All distinct values)
    • 1st Letter
    • 2 Initial Letters
    • 3 Initial Letters
    • 4 Initial Letters
    • 5 Initial Letters
    • Normal (All distinct values)
    • Quarter
    • Month
    • Week
    • Day
    • Hour
    • Minute
    • Year
    • Quarter
    • Month
    • Date
    • Date/Time
    (with optional year filter for "Quarter" and "Month")
  • Datetime Field Filters for Reports

    Relative Days Relative Day Periods Relative Weeks Relative Months Relative Years Past/Future
    • Yesterday
    • Today
    • Tomorrow
    • Last 30 days
    • Last 14 days
    • Last 7 days
    • Next 7 days
    • Next 14 days
    • Next 30 days
    • Last two weeks
    • Last week
    • This week
    • Next week
    • Next two weeks
    • Last month
    • This month
    • Next month
    • Last year
    • This year
    • Next year
    • Past
    • Future
  • Linked Tables from Multiple Databases


  • Responsive Layout with Bootstrap and AdminLTE

    • 19 theme colors with Bootstrap 5 and AdminLTE 3
    • User image and user name in sidebar
    • Sidebar search (for searching menu items)
    • Navbar search (as Quick Search input for tables)

  • RTL

    • Detect RTL languages by language ID
    • Generate and use RTL stylesheets automatically

  • Mobile Menu


  • Bootstrap Toast


  • Load JavaScript asynchronously and Automatic Page Load Progress Bar

    Show progress bar when JavaScripts are being loaded asynchonously on page load.


  • Toolbar with Breadcrumbs, Vector Icons and Tooltip


  • Export to Printer-friendly, HTML, Word, Excel, CSV, XML, Email, PDF


  • Links, Button Groups, and Button Dropdowns

    Links with icons
    Button group
    Button dropdown
    Button group in paging section
    Button dropdown in paging section
  • Grid-Add, Grid-Edit, Multi-Edit, Inline-Add, Inline-Copy, and Inline-Edit


  • Master/Detail-Add/Edit/View and Multiple Master/Detail



  • Referential Integrity, Cascade Delete and Cascade Update


  • Optional Confirmation Page Before Inserting or Updating Record


  • Pagers in List/Edit/View page



  • View Tag and and Edit Tag Options

    formatted text

  • File Upload to Folder or Database with Dropzone and Cropper (Supports Mulitple File Upload to Folder)



  • Quick Search, Extended Search and Advanced Search


  • User ID Security and User Level Security



  • User Registration System


  • Password Generator and Password Strength Meter


  • Theme with Bootstrap and AdminLTE Variables


  • Menu Editor (Support Icons)


  • Multiple Master/Detail Relationships


  • Preview Field

  • Detail Preview as Expandable Row, Popover, Modal or Offcanvas (Extension for Registered Users Only)


    Expandable row


    Offcanvas
  • User CSS (Supports Sass)


  • Create, Alter and Drop Database Views and Query Builder


  • User Selectable Page Size


  • Table Row Colors


  • Add New Option to Selection List


  • Dynamic Selection List with Multiple Display and Parent/Filter Fields


  • Dropdown Selection Lists


    Multi-column Radio button list



    Multi-column Checkbox list



    Selection list (select-one)



    Selection list (select-multiple)
  • Option Template for Dropdown Selection Lists


  • Modal Lookup Dialog (Supports Searching)

    • Pagination (Infinite Scrolling)
    • Draggable

  • Table Header Filter

    • Excel filter style
    • Work together with other fields in Extended Search
    • Searchable
    • Pagination (Infinite Scrolling)
    • Dropdown positioning by Popper

  • Auto-Suggest


    With Option Template

  • Multi-Page Add/Edit/View Pages (as Tabs/Pills/Accordion)


    Tabs



    Pills



    Accordion
  • Login Page (Supports Modal Dialog, Google/Facebook/Azure/SAML Login, and CAPTCHA)


  • Web Push Notifications

    • Option to allow anonymous users to receive notifications
    • Generate server public/private keys
    • Users can enable/disable notifications
    • Administrators can send notifications to selected or all subscribers


    Enable notifications


    Receive notifications

  • Two Factor Authentication (Google Authenticator, Email and SMS with Third Party API)

    • Opt in/out or forced 2FA
    • Backup codes
    • Administrators can reset user secret

  • Server Events and Client Scripts


  • Custom Template


    Custom Template as table


    Custom Template as cards
  • Code Editor

    Browser-based code editor with rich features (Requires WebView2)


    Auto-complete field names


    Better Find and Replace


    Indentation by Tab and Ctrl+Tab


    Many more other commands

  • Column Visibility

    Show/Hide table columns in List page during runtime

  • Code repository


  • Multi-Language Property Editor


  • Fixed Header Table


  • Query Builder


  • Internationalization (i18n) by PHP and JavaScript

    • Auto locale settings (customizable) by native PHP Intl extension and JavaScript Intl object
    • Format and parse by ICU number, currency and date/time formats




  • Colorbox


  • Field Visibility (Extension for Registered Users Only)

  • DateTime Picker

    • Dropdown positioning by Popper
    • Support ICU date format
    • Auto internationalization by native JavaScript Intl object

    English

    Chinese

    Arabic (RTL)
  • Timepicker (Extension for Registered Users Only)

  • Date/Time Formats without Seconds


  • Export as native Excel/Word with PHPWord and PHPSpreadsheet (Extensions for Registered Users Only)


  • Custom Fields

  • Custom View Tags

    • Barcode and QR code
    • YouTube videos
    • Google Maps (with MarkerClusterer)
    • Leaflet for OpenStreetMap and Mapbox (with MarkerClusterer, for registered users only)







  • Custom Edit Tag


  • Custom Files


  • Session Keep Alive and Session Timeout


  • Client Side Events and "fields" jQuery Plugin


  • Multi-Update Field Settings


  • Save Search Criteria


  • Cancel Button for Add/Edit/Delete/Update Pages


  • Server-side validation and/or client-side JavaScript validation


  • Auto-Focus

    • Focus the first field on page fully loaded
    • Focus first error field after server side validation

  • Field Input Help Text (Custom Message)


  • Template and Extensions as npm Packages

    • Easy update by npm update
    • No more write permission issues
    • Use semantic versioning
    • Developers can publish their templates/extensions to npm registry by npm publish for sharing
    • Support showing README.md written in Markdown

  • Auto Update to Latest Template and Extensions


  • Project History

  • Auto JS Template

    Modify page content automatically on page load.


  • REST API


    Swagger UI


    HTTP response
  • Import from Excel/CSV

  • General Data Protection Regulation (GDPR)

    • Field Encryption extension (for registered users only) to encrypt selected fields with personal information
    • Consent and privacy page

    • Download and delete personal data page

  • Check Table and Field Variable Names

  • Composer Package Manager

    • Search Composer packages from packagists.org within UI
    • Generate composer.json for project
    • Run "composer update" after generation
  • npm Packages

  • Sharing Project with Other Users (via GitHub)

  • Pretty Error Page for Development

  • More

    • Supports PHP 7.4, 8.0 and 8.1
    • Replaces out-dated Composer packages incompatible with PHP 8.1
    • Use globally installed Node.js and npm
    • PSR-12 coding standard
    • Load classes by PSR-4
    • Logger for logging SQL and errors
    • Error handler and error page
    • Development/Production environment
    • Synchronize project with database
    • Field aggregates (sum, average and count)
    • Single or multiple column sorting
    • Audit trail with log file or database table
    • Email notification on Add/Edit/Delete
    • Dynamic table loading
    • Composite key
    • Auto-Fill child fields on selecting an option for the parent selection list
    • Hashed password and case-sensitive password
    • XSS removal
    • JavaScript compressor with ES6+ support
    • UI supports working behind proxy server
    • Fully customizable template and extensions

 

 ©2022 e.World Technology Limited. All rights reserved.