PHPMaker 2020.0.16 Released

[Webmaster]

We are pleased to announce the official release of PHPMaker 2020 and the new domain for PHPMaker: https://phpmaker.dev.

The new version can be downloaded at:
https://phpmaker.dev/download.php

PHPMaker 2020 is a huge upgrade from v2019. It integrates most features of PHP Report Maker and is loaded with a bunch of new features, please refer to here for more details:
https://phpmaker.dev/phpmaker2020.php

---

IMPORTANT NOTES:
Please make sure you read the following before you try the new version:

• Requires Composer (https://getcomposer.org/download/), make sure you install it first.
• Requires PHP >= 5.6
• Read "Migrating to v2020" first: https://phpmaker.dev/doc/migrate2020.htm
  *************************************************************************************************************************

PHPMaker 2020 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 2020 or upgrade, please visit:
https://phpmaker.dev/purchase.php

Upgrade policy remains unchanged. 6-month email support.

[Webmaster]

2019/08/19 v2020.0.1

• Allow update template in trial version
• Move forgot password and register links in login page
• Improved: Detect Azure SQL Server for optimizing SELECT statement
• Improved: Add error handling for CurrentPageID()
• Fixed: Class names for Font Awesome Free
• Fixed: Upload field input group icon
• Fixed: Some code of extensions not generated
• Fixed: Alignment for crosstab summary field
• Fixed: Hidden primary key fields (if not selected for the page)
• Fixed: Maximum call stack size exceeded error during generation
• Fixed: Security for Custom File with Static User Levels
• Fixed: Custom File content with special characters
• Fixed: Search operator LIKE, NOT LIKE, STARTS WITH and ENDS WITH
• Fixed: Multi-Select Lookup field SQL for LIKE and other operators
• Fixed: AutoSuggest not closed after blur
• Fixed: Custom Template not rendered properly
• Fixed: OtherOptions in List page not rendered properly
• Fixed: Class ExportEmail for View page
• Fixed: Lookup field with lookup table filter
• Fixed: Lookup_Selecting server event
• Fixed: Hyperlink prefix/suffix
• Fixed: Function HtmlToText()
• Fixed: et.json
• Replace ScrollingTable extension by FixedHeaderTable extension (for registered users)
• Many other minor improvements

[Webmaster]

2019/09/02 v2020.0.2

• Change cookie consent to Toast
• Right click and repeat selected code for all fields in Custom Template Editor
• Add GetLinkHtml() method to class ListOption
• Fixed: Lookup fields in registration page
• Fixed: Upload icon for file upload input group
• Fixed: Default language cannot be set
• Fixed: Replace CR+LF by <BR>
• Fixed: Master record page hyperlinks
• Fixed: Default decimal precision for lookup fields
• Fixed: Confirm password Custom Template in registration page
• Fixed: Lookup field with Advanced Search enabled but Extended Search disabled
• Fixed: SendEmail() for plain text email
• Fixed: Set field properties for multiple fields (UI)
• Fixed: Upload and barcode with S3
• Fixed: Support for IE 11
• Updated: CurrentUserIP()
• Updated: Use fa-ellipsis-v for list action button
• Updated: Sample code for Custom Template in code repository
• Many other minor improvements

[Webmaster]

2019/09/16 v2020.0.3

• Add server events to index page
• Allow no grouping fields for summary report
• Fixed: Include shared file in extension
• Fixed: Sort direction icon in userpriv.php
• Fixed: Preview extension with Firefox
• Fixed: Warnings for cancelAnimationFrame and requestAnimationFrame in Chrome
• Fixed: Table name field size in user level permission table
• Fixed: DateTime picker for date formats without seconds
• Fixed: File upload handler not returning MIME type for PDF files
• Updated: AdminLTE 3.0.0-rc.1
• Updated: DateTime picker (Tempus Dominus v5.1.2)
• Many other minor improvements

[Webmaster]

2019/10/02 v2020.0.4

• Improved: Handle page size = 0
• Improved: Allow HTML in Toast message
• Fixed: Lookup cache for Link Table
• Fixed: Lookup filter for dropdown
• Fixed: Detail report in View page
• Fixed: NumericPager not used if Preview extension enabled
• Fixed: Inline update failure not handled correctly
• Fixed: Searching multiple selected values (databases other than MySQL)
• Fixed: Lookup with ORDER BY clause (PostgreSQL)
• Fixed: Default search value for reports
• Fixed: Chart in Dashboard report
• Fixed: SELECT tag id in grid
• Fixed: Duplicate primary key error not handled properly
• Fixed: Extra double quote in menu template
• Fixed: userpriv.php shows all table
• Fixed: Lookup permission when adding new user level
• Fixed: Detail table permission checking
• Fixed: $body undefined when using modal dialog (ew.js)
• Fixed: ew.showMessage() function
• Fixed: Error after removing User ID field for table (UI)
• Updated: mobile-detect.js and JsRender/JsViews
• Many other minor improvements

[Webmaster]

2019/10/16 v2020.0.5

• Improved: Treat MySQL TinyInt field as boolean only if set as checkbox
• Fixed: Select options across pages in Modal Lookup
• Fixed: Selected value in AutoSuggest removed on blur
• Fixed: Collapsible Cards in Dashboard report
• Fixed: Crosstab report column field ORDER BY (MSSQL)
• Fixed: AutoFill with updating Dynamic Selection Lists
• Fixed: OverlayScrollars option of FixedHeaderTable extension
• Fixed: Duplicate group values in summary only reports with compact summary footer
• Fixed: Export with Extended Search in report
• Fixed: Startup Script for grid page
• Fixed: Crosstab report year selection
• Fixed: Report grouping field CSS class
• Fixed: NOT LIKE operator with collation
• Updated: AdminLTE 3.0.0-rc.4
• Many other minor improvements

[Webmaster]

2019/11/04 v2020.0.6

• Add advanced setting "List page minimum table height (px)"
• Add FormData polyfill (for IE)
• Improved: Show Extended Filter for charts if not showing report
• Improved: CSS styles for User Level Permissions page
• Improved: Skip "No record found" message for Grid page
• Fixed: Lazy loading images for modal View page
• Fixed: Use input with type="text" for TEXTAREA in Confirm page
• Fixed: Error with Detail grid
• Fixed: Personal Data page
• Fixed: Master/Detail-Add/Edit with Confirm page
• Fixed: "dropdown-toggle" class for delete filter button
• Fixed: Span tag ID for search value 2
• Fixed: Default value for date filter
• Fixed: Column field of date type (Crosstab report)
• Fixed: Import/Lookup permissions
• Fixed: File upload with special characters in file name
• Fixed: Lookup ORDER BY for grouping field
• Fixed: Brand image CSS style
• Fixed: Error when changing some settings in "Tables" grid (UI)
• Updated: AdminLTE 3.0.0 and Chart.js
• Many other minor improvements

[Webmaster]

2019/11/25 v2020.0.7

• More AdminLTE 3 sidbar and navbar CSS classes
• Allow file upload in Add Option page
• Allow encrypting email field if not used as username field (Field encrpytion extension)
• Improved: Connecting with PostgreSQL 12
• Improved: Handle typing date in datetimepicker
• Improved: "Plain" theme with fixed header table
• Improved: Keep uploaded files when insert/update is cancelled
• Fixed: Auto hide page size selector
• Fixed: Drilldown for dropdown filter
• Fixed: dompdf extension font for CPDF
• Fixed: FormData for IE
• Fixed: jQuery file download for Android browser
• Fixed: Update primary key with confirm page
• Fixed: Modal registration confirm page
• Fixed: Reports with Linked Table as source
• Fixed: Report as detail table
• Fixed: Menu with all items as Navbar items
• Updated: AdminLTE 3.0.1 (include fixed margin left on sidebar collapse without sidebar-mini) and Chart.js
• Many other minor improvements

[Webmaster]

2019/12/10 v2020.0.8

• Improved: User interface
• Improved: Handle empty display value in lookup (Use original value)
• Improved: submitAction() allows $.ajax() settings
• Improved: Center reCAPTCHA in mobile mode (reCAPTCHA extension)
• Fixed: Autologin after registratio/activation
• Fixed: Navbar CSS class names
• Fixed: Table grid panel colors in List page
• Fixed: Virtual lookup field unchecked in List page
• Fixed: Input group width in Login and Change Password pages
• Fixed: Load events on changing reports (UI)
• Updated: Bootstrap 4.4.1
• Many other minor improvements

[Webmaster]

2020/01/07 v2020.0.9

• Improved: Use encryption key as random key if set
• Improved: Use TransactionIsolation = SQLSRV_TXN_READ_UNCOMMITTED (MSSQL)
• Improved: Encrypt session ID in encrypted file path
• Improved: Handle Custom Field that is a SELECT statement
• Fixed: Cell_Rendered server event for reports
• Fixed: function submitAction()
• Fixed: Export to PDF with Barcode
• Fixed: Date/Time picker and lookup field text input width (for Bootstrap 4.4)
• Fixed: Search panel toggle button (for Bootstrap 4.4)
• Fixed: Reports not shown for Static User Level Security
• Updated: OverlayScrollars 1.10.2
• Many other minor improvements

[Webmaster]

2020/01/21 v2020.0.10

• Improved: Skip render own lookup
• Improved: Check "pageno" before "start" for pager
• Fixed: Lookup display fields in same table
• Fixed: API with Windows Authentication
• Fixed: Master/Detail key with Auto-Update Value
• Fixed: Custom full URL protocols
• Fixed: Google maps for reports
• Fixed: Boolean lookup for reports
• Fixed: Cannot delete report (UI)
• Fixed: Font error in Firefox
• Updated: AdminLTE 3.0.2
• Many other minor improvements

[Webmaster]

2020/02/05 v2020.0.11

• Improved: Skip lookup for readonly fields
• Fixed: API for multiple file upload
• Fixed: Connection with PostgreSQL 12 (UI)
• Fixed: Google maps for report with groups
• Fixed: Inline-Add lookup for multi column List page
• Fixed: Row_Import server event
• Fixed: Export aggregate (PhpSpreadsheet extension)
• Updated: OverlayScrollars 1.10.3
• Many other minor improvements

[Webmaster]

2020/03/03 v2020.0.12
- Improved: Allow manual input of database name and schema for PostgreSQL (UI)
- Improved: Page number selector width
- Improved: Error handling of invalid Custom Field expression
- Improved: Handle incorrect upload settings
- Improved: Handle empty field format type for highlighting search result
- Improved: insertSql() method
- Improved: JSON encode for data in Custom Template
- Fixed: Missing header in export to CSV (View page)
- Fixed: Export numeric lookup field (PhpSpreadsheet)
- Fixed: API user level security
- Updated: UploadHandler.php
- Updated: OverlayScrollars 1.11.0
- Updated: JsRender 1.0.6
- Many other minor improvements

[Webmaster]

2020/03/24 v2020.0.13
- Improved: Add DOWNLOAD_PDF_FILE configuration setting
- Improved: UnFormatDateTime() supports format in "hh:mm AM/PM"
- Improved: Import records to table without primary key
- Improved: Add Option dialog with textarea
- Improved: Set textarea (with HTML editor) value by .value() of .fields() jQuery plugin
- Improved: Hide tooltip when datetime/time picker shows
- Improved: REST API login action returns more info
- Improved: REST API edit action for editing primary key
- Fixed: ADOdb MSSQL driver
- Fixed: View file if security not enabled
- Fixed: Checkbox id for boolean fields in Modal dialog
- Fixed: Error on copying file during generation
- Fixed: Check duplicate (for Oracle)
- Fixed: Color palette setup form for charts (UI)
- Many other minor improvements

[Webmaster]

2020/04/06 v2020.0.14
- Support connection to Azure Database for MySQL
- ScrollbarMode advanced setting (UI)
- Advanced settings for cookie
- Improved: Set up lookup setting for Date Interval
- Improved: Skip updating selection lists in Confirm page
- Improved: HTML-encode foreign key hidden values
- Improved: Consent page cookie expiry time
- Fixed: Save current filters for report (Server side)
- Fixed: Date/Time picker
- Fixed: REST API with security disabled
- Fixed: REST API file access without User Level security
- Fixed: Custom field setting on copying field settings
- Fixed: YouTubeVideos Custom View Tag
- Fixed: Siderbar for top navigation
- Updated: ADOdb v5.20.17
- Updated: AdminLTE v3.0.4
- Updated: OverlayScrollars 1.12.0
- Many other minor improvements

[Webmaster]

2020/05/11 v2020.0.15
- Add "permission" and "register" actions (REST API)
- Return "401 Unauthorized" if no permission (REST API)
- Support FormData with both normal fields and file upload fields (REST API)
- Support "Max Length (List page)" for memo fields (REST API)
- Support citext data type as text data type (PostgreSQL)
- Improved: Return Href Fields also in List page (REST API)
- Improved: Add custom headers in web.config (REST API)
- Improved: Add nav-child-indent class to menu
- Improved: File type checking with ContentType()
- Fixed: Custom file with relative path
- Fixed: Multi-language lookup request
- Fixed: YouTube Videos (Custom View Tag)
- Fixed: Validation of DateTime without seconds
- Fixed: Validation of User Level ID field when adding user level
- Fixed: Not including Href Fields for List page (REST API)
- Fixed: IMPORT_CSV_DELIMITER with escape character
- Many other minor improvements

[Webmaster]

2020/06/01 v2020.0.16
- Improved: Handle zero values for master keys
- Improved: Add Lookup permission for "Allow View All" (User ID Security)
- Improved: Handle autoincrement user level ID field
- Improved: Secruity for "permission" action (REST API)
- Improved: Handle invalid JWT token (REST API)
- Fixed: Registration if user already exists (REST API)
- Fixed: Security for Anonymous Access (REST API)
- Fixed: Default extensions not enabled for new project
- Fixed: Captcha in change password page
- Updated: jQuery v3.5.1
- Updated: Bootstrap v4.5.0
- Updated: AdminLTE v3.0.5
- Many other minor improvements