PHPMaker v2022.12.4 Released

PHPMaker General Discussion (PHPMaker)
1

We are pleased to announce the official release of PHPMaker 2022.PHPMaker 2022 is a huge upgrade from v2021. It is loaded with a bunch of new features, please refer to What’s New in PHPMaker 2022 for more details.The new version can be downloaded at the Download page.Note The system requirements has been changed, please read System Requirements before installing the new version.IMPORTANT NOTESPlease make sure you read the following before you try the new version:

PHPMaker 2022 can co-exist with previous version of PHPMaker. You do NOT need to uninstall previous version of PHPMaker if you don’t want to.Before trying the new version, please backup your existing projects first.To purchase license for PHPMaker 2022 or upgrade, please visit the Purchase.Upgrade policy remains unchanged. 6-month email support.

2

2021/09/01 v2022.1

  • Fixed: Custom Template with comparison/logical operators
  • Fixed: Default values for (Extended) Quick Search
  • Fixed: Lookup with security disabled
  • Fixed: Multiple colorpickers in tabs
  • Fixed: Server/Client side validation for localized field values
  • Fixed: Custom currency symbol in locale settings
  • Fixed: Unsupported HTMLElement.attachInternals() in Firefox/Safari
  • Fixed: Auto-focus RADIO/CHECKBOX fields
  • Fixed: User image not showing
  • Fixed: Home page link when Start Page is function name
  • Fixed: Extended Search Option AND/OR/AUTO
  • Fixed: Date/Time picker enabled for fields with custom format
  • Fixed: Bootstrap/AdminLTE settings not initiated properly (UI)
  • Fixed: Language file version not checked properly (UI)
  • Improved: Allow all Windows users to use PHPMaker (UI)
  • Improved: HTML preview (UI)
  • Improved: Show locale settings in right-to-left for RTL lauguages (UI)
  • Improved: Create InnoDB tables if MySQL >= 5.6 (UI)
  • Improved: Allow fields with “TEXT” Edit Tag set as Modal Lookup
  • Improved: Search all display fields in Modal Lookup, Select2 and Filter
  • Improved: Add selectMinimumInputLength setting for Select2
  • Improved: Use SPAN tag for read-only lookup fields
  • Updated: SweetAlert2 and Date/Time picker
  • Other minor improvements
3

2021/09/15 v2022.2.0

  • New browser-based code editor (requires WebView2 Runtime)
  • Fixed: Lookup request with mixed types
  • Fixed: CHECKBOX/RADIO selection lists problem in Firefox
  • Fixed: Invalid feedback for CHECKBOX/RADIO selection lists
  • Fixed: Master record User ID checking
  • Fixed: CKEditor dialogs in modal pages
  • Fixed: Chart data labels
  • Fixed: Email_Sending for Multi-Update/Delete
  • Improved: Ignore List page search criteria for modal View/Edit pages
  • Improved: Check lanuguage ID case-insensitively
  • Improved: Check numeric user values of lookup fields better
  • Improved: Reset Password and Register links in modal Login page
  • Improved: Error handling on copying CKEditor/TinyMCE from composer packages to project folder
  • Improved: Error handling on getting Chart advanced settings
  • Improved: Batch size for batch Ajax lookup
  • Updated: Bootstrap 5.1.1, SweetAlert2 and Date/Time picker
  • Other minor improvements
4

2021/10/04 v2022.3.0

  • Fixed: Icon size
  • Fixed: CSS of hidden tabs
  • Fixed: CSS when search panel ‘Field per row’ = 1
  • Fixed: Check search operator 2
  • Fixed: JavaScript error of search panel buttons
  • Fixed: Warning message on import failure
  • Fixed: Preview extension - SingleRow option
  • Fixed: Custom field format pattern
  • Fixed: ‘file’ API action for encrypted file path
  • Fixed: Load user extensions (UI)
  • Fixed: control.xml not found (UI)
  • Improved: browser-based code editor (UI)
  • Improved: Preview HTML (UI)
  • Improved: Error handling for AutoFill
  • Improved: Change menu item name attribute to data-name
  • Improved: Add spacing between multiple uploaded files on List/View
  • Updated: SweetAlert2 and Date/Time picker
  • Other minor improvements
5

2021/10/18 v2022.4.0

  • Fixed: User profile corrupted error in Multi-Language project
  • Fixed: Client side validation for boolean field
  • Fixed: Autofill boolean checkbox
  • Fixed: Search User ID fields
  • Fixed: Format report summary fields
  • Fixed: ChartScaleBeginWithZero for Line/Area charts
  • Fixed: Expand preview row on clicking row links/buttons (not in dropdown)
  • Fixed: Client side redirect() with port number
  • Fixed: Search filter field
  • Fixed: Hide detail items for dropdown (Preview extension)
  • Fixed: Export in Excel2007 format (PhpSpreadsheet extension)
  • Improved: Allow setting lookup cache by page IDs in Config
  • Improved: Update theme settings (UI)
  • Improved: Import without enabling PhpSpreadsheet extension
  • Improved: Built-in JavaScript plugins in AdminLTE
  • Updated: Bootstrap 5.1.3, SweetAlert2 and Date/Time picker
  • Other minor improvements
6

2021/11/01 v2022.5.0

  • Fixed: Preview field
  • Fixed: Searching in column filters
  • Fixed: Detect empty form
  • Fixed: Page_Redirecting server event
  • Fixed: Detail record count in multiple Master/Detail-View page
  • Fixed: Export to Excel (.xlsx format)
  • Fixed: Export reports to Word
  • Fixed: Dashboard report page title and breadcrumb
  • Fixed: Quick Search (A OR B) with “Auto” option
  • Fixed: Report with fields using TEXTAREA Edit Tag
  • Fixed: Dual Y charts
  • Fixed: Load database names with URL connection (UI)
  • Improved: Use psr/log if PHP < 8
  • Improved: Show message in Custom File
  • Improved: Submit modal login, password recovery and change password pages by pressing Enter key
  • Improved: Focus modal dialog on show
  • Improved: Handle empty timezone
  • Improved: Log PHPMailer debug messages
  • Updated: Chart.js v3.6.0
  • Other minor improvements
7

2021/11/15 v2022.6.0

  • Allow setting locale numbering system to ‘latn’
  • Add client side PAGE_ID for login and reset/change password pages
  • Fixed: Aggregates for multi-column table layout or preview field
  • Fixed: Button group in Grid page
  • Fixed: Init HTML editors for Custom Template in non-modal pages
  • Fixed: FixedHeaderTable extension generate-time error
  • Fixed: Audit trail for anonymous user
  • Fixed: Detail table in accordion
  • Fixed: Submit button of Custom Template for Extended Search
  • Fixed: Scroll to row after Inline-Edit
  • Fixed: Focus CKEditor dialog in modal pages
  • Improved: Date/Time picker (Edit date only)
  • Improved: Chart labels
  • Improved: CurrentUserEmail() and CurrentUserImageBase64()
  • Updated: SweetAlert2 and session middleware
  • Other minor improvements
8

2021/12/01 v2022.7.0

  • Display lookup fields in reports and charts (X-axis)
  • Fixed: Search composer packages
  • Fixed: Select2 dropdown position in modal
  • Fixed: Connection to PostgreSQL with SSL
  • Fixed: Captcha in Login and Change Password pages
  • Fixed: ReCaptcha in modal Login page on reload
  • Fixed: Swagger UI for Add/Edit/Register
  • Fixed: Date/Time picker “change” event
  • Fixed: Concurrent user login error (non-modal)
  • Fixed: Invalid feedback not reset for Modal Lookup fields
  • Fixed: Empty string parsed as 0 by PHP 7.x
  • Improved: Handle custom element for Firefox >= 93
  • Improved: Ignore error on calling HtmlToText()
  • Improved: Add global upload options for jQuery File Upload
  • Improved: Remove “Save” button in CKEditor
  • Improved: Add decimal and grouping separators to locale settings
  • Improved: Change form CSS width to max-width
  • Updated: SweetAlert2, dompdf, Chart.js and chartjs-plugin-annotation
  • Other minor improvements
9

2021/12/15 v2022.8.0

  • Fixed: Error message HTML-encoded
  • Fixed: Image column width (PhpSpreadsheet)
  • Fixed: Card CSS class in Dashboard reports
  • Fixed: Check duplicate for primary key fields
  • Fixed: Fixed header table in Dashboard reports
  • Fixed: Field max length for numeric fields after sync (UI)
  • Improved: Check project name
  • Improved: Attributes of menu item
  • Improved: Format null as empty string
  • Improved: Skip ‘SET DATEFORMAT ymd’ (MSSQL)
  • Improved: Custom Template in Modal dialog
  • Improved: Error handling on generating barcode (PHPBarcode)
  • Improved: Allow rendering a field more than once in Custom Template
  • Improved: Column headings as “Date” with DateTime fields (Crosstab)
  • Improved: Allow changing grouping/decimal separators in locale settings
  • Improved: Add ExportFieldCaption property for DbField class
  • Updated: SweetAlert2, luxon, element-internals-polyfill.js, Chart.js and chartjs-plugin-annotation
  • Other minor improvements
10

2022/01/11 v2022.9.0

  • Fixed: jQuery plugin .toJsDate() method
  • Fixed: Form object value property not always reset on re-validation
  • Fixed: Invalid feedback for native SELECT tag not reset in Safari
  • Fixed: Active sub-menu item in side menu not highlighted properly
  • Fixed: Report lookup field ‘BETWEEN’ operator
  • Fixed: Detail List page master record checking
  • Fixed: Chart drilldown for Crosstab reports
  • Fixed: addUserPermission() for new table
  • Fixed: File upload field drop zone width for mobile
  • Fixed: Confirm password field in Custom Template
  • Fixed: Allow View All for lookup fields
  • Fixed: Lookup permission checking for userIDAllow()
  • Fixed: Export to email in View page
  • Fixed: Export S3 images
  • Improved: Handle double byte characters better (PhpSpreadsheet)
  • Improved: Skip 2FA for registration if forced 2FA not enabled
  • Improved: Replace toast by alert on Add Option error
  • Improved: Add “select2” event before initializing Select2
  • Improved: Add CSS classes option for YouTube Custom View Tag
  • Improved: Update package versions in composer.json
  • Improved: Add option to show chart missing series values as zero
  • Improved: Pager in View/Edit pages
  • Updated: Chart.js, chartjs-plugin-annotation and date/time picker
  • Other minor improvements
11

2022/01/31 v2022.10.0

  • Fixed: Update current values in addRow() and editRow()
  • Fixed: Preview extension ‘previewPopoverTrigger’ setting
  • Fixed: Audit table set wrongly as Subscription table (UI)
  • Improved: emptyRow() checking
  • Improved: Add language files for TinyMCE
  • Improved: HTML preview for large project (UI)
  • Updated: Chart.js, chartjs-plugin-annotation, chartjs-adapter-luxon, SweetAlert2, Popper and Luxon
  • Other minor improvements
12

2022/02/28 v2022.11.0

  • Compatibility with PHP 8.1
  • Fixed: Preview field checking
  • Fixed: Accordion collapsing
  • Fixed: Routes for View pages in groups
  • Fixed: Showing PDF from BLOB field in Preview page
  • Fixed: AutoSuggest with “Auto-Suggest all display fields” disabled
  • Fixed: Auto JS Template not shown in Code repo for server event (UI)
  • Improved: Check User ID field of user table better (UI)
  • Improved: Handle non-varchar fields for Custom Template (PostgreSQL)
  • Improved: Load default values for table without primary key field(s)
  • Updated: SweetAlert2, Chart.js, chartjs-plugin-annotation and element-internals-polyfill
  • Other minor improvements
13

2022/04/25 v2022.12.0

  • Better compatibility with PHP 8.1
  • Fixed: Checking empty row in grid
  • Fixed: Default sorting order
  • Fixed: Multi-Page as Accordion
  • Fixed: ListOptions visibleCount() method
  • Fixed: CHECKBOX Edit Tag without dropdown
  • Fixed: Showing server side error message in Login pages
  • Fixed: $DownloadFileName global variable for BLOB fields without file name field
  • Improved: fetch() method
  • Improved: Check permission for Grid/Inline-Add/Edit
  • Improved: beforesubmit/aftersubmit client side event
  • Improved: Mute video before autoplay for YouTube videos
  • Updated: SweetAlert2, chartjs-plugin-annotation v1.4.0, date/time picker and element-internals-polyfill
  • Other minor improvements
14

2022/08/04 v2022.12.4

  • Better compatibility with PHP 8.1
  • Fixed: Connection info of MSSQL not shown properly
  • Fixed: Export Master/Detail
  • Fixed: Decimal field as Link Field
  • Fixed: Lookup options with master table
  • Fixed: Email template path
  • Fixed: list_options_2 Custom Template Tag
  • Fixed: Stacked chart tooltips
  • Updated: SweetAlert2, Luxon, jQuery UI, date/time picker and element-internals-polyfill
  • Other minor improvements