December 23rd, 2011· Security enhancements. One of the most important features implemented in this version is a possibility of storing user permissions in a database table. This allows you to manage them without re-generation of the scripts using the special Administration Panel (available only for users with the admin permission).
· Powerful data export features. New version provides a completely new PDF export engine with Unicode support and great customization abilities. Also we have added the OnCustomRenderExportColumn event to adjust the output data according to your needs.
· New insertion and editing modes. Starting with this version the Save button in the Insert Record form allows you to post changes to the database and re-open the form for adding another record in a single click (without returning to the List page). Another useful thing is a possibility of continue editing of the record after posting the changes in both Edit and Insert forms.
· Advanced control management in Edit and Insert forms. From now on you can use new OnInsertFormControlValueChanged and OnEditFormControlValueChanged events to manipulate with form controls. For example, you can enable/disable a certain control or fill a combo box depending on a value entered in another control.
· Improved project management. Starting with this version PHP Generator allows you to save previously opened project without entering a file name with the Save command. To save the project to a new location, use the Save As command.
· Copying and viewing data in modal windows. From now on you can view and copy individual records without opening a separate webpage. The corresponding abilities can be activated for a whole project or for a concrete page.
· Lookup filtering. Now it becomes possible to filter the contents of lookup controls. Moreover, all the supported variables are accessible in the filter condition.
· Command line generator. Did you know that PHP Generator can build ready-to-use web application even without running the UI? Automate your work with a few mouse clicks. The result command line can be copied to Clipboard or saved to a batch file.
· Bug report sender. Found an occasional bug? Even sending a bug report becomes a pleasure with the new version.
· Speeded up schema refreshing. We have improved the algorithm of the metadata refreshing to save a few moments of your valuable time.
April 20th, 2011· Version 11.4 features support for multi-level auto-complete editors, row numbering in grids, lookup editors based on a template, and a lot of other useful things.
August 26th, 2010Key enhancements:
· Inline Insert and Inline Edit features have been implemented. Use them to insert/edit a record without having to open a new page.
· Support for RSS feeds to publish frequently updated works (such as blog entries, news headlines, etc) in a standardized format has been implemented. All the required fields can be customized within the Page Properties dialog.
· The Advanced Search form can now be displayed on a separate page. Moreover, this form now can substitute by itself the list page, so it becomes possible to display page data only after entering values to search.
· The Advanced Search formPicture 2. The Advanced Search form
· Support for using some environment variables (such as CURRENT_USER_ID, CURRENT_USER_NAME, UNIQUE_ID) in events and templates has been implemented. The variables also can be used for specifying a column default value.
· The following example demonstrates how to use variables within the OnBeforeInsertRecord event.
· rowData['ip_address'] = $this->GetEnvVar('REMOTE_ADDR');
· userName = $this->GetEnvVar('CURRENT_USER_NAME');
· if ($userName != 'admin')
· rowData['changed_by'] = $userName;
· To obtain a complete list of supported variables, uncomment the define('SHOW_VARIABLES', 1); line in the generated settings.php file.
· Page-level permissions have been implemented. Such permissions allow you to customize access to individual pages in the generated app. To setup record-level permissions, use the "Customize user permissions..." button in the Permission Manager dialog.
Event handling extensions:
· Now it is possible to change values posted to the database with OnBeforeInserRecord/OnBeforeUpdateRecord events.
· OnInsertFormValidate/OnEditFormValidate client-side events have been implemented. Use these events to write a custom JavaScript code for checking values entered by the user.
· Listing 2.
· if (fieldValues['percents'] < 0 || fieldValues['percents'] > 100)
· {
· errorInfo.SetMessage('Percent value should be between 0 and 100');
· return false;
· }
· Two other client side events have been added. These are OnBeforePageLoad and OnAfterPageLoad. The first event occurs before page loading and allows you to declare functions and global variables while the second one fires after the page has been fully rendered.
Frontend improvements:
· Page Editor: the Reset column command has been added to the General tab's popup menu.
· An easy access to recently used projects has been implemented.
· Recent projectsPicture
· Image combo box is now used for selecting a lookup source. Using different images for tables, views, and queries helps you to easily select the required object.
· The Send report menu item will allow you to send us a detailed bug report in a single click. We hope this command will not be used so often.
Other new features:
· The UI for column reordering has been improved: now it is possible to reorder columns for all the presentations at once.
· Now it is possible to setup width for each column as well as the whole grid width.
· An ability of changing the number of records displayed at a page during application runtime has been implemented.
· Page list, Print, and Export blocks become collapsible.
· Starting with this version it is possible to exclude a page from the left menu as well as reorder pages in the page list.
· Now it is possible to print a single record in the view form.
· Most-frequently used values can now be specified for a combo box editor. Such values are always displayed at the top of the list.
· Advanced Search: the "is blank" and "is not blank" conditions have been added to the search criteria.
· Values in lookup combo boxes are now sorted.
· The PHPass algorithm can now be used for the password encryption.
April 6th, 2010· Support for right-to-left languages, project-level events and a lot of other new features.
December 23rd, 2009New features:
· Support for updatable SQL queries
· Master-detail presentations
· Event-driven content management
· Client-side data validation
· Custom pagination (display partitioning)
· Data export to PDF, XML, CVS, Excel and Word
· Support for hard-coded, table-based, and database server user authentication
· Record-level security
· Color schemes
· Multi-language support
· Also starting with this version it is possible to connect to a remote server via SSH tunnel using a key-based authentication (in addition to the password-based authentication supported in the previous versions). To establish a remote connection in this way, you have to provide a private key (either in ssh.com or OpenSSH formats) and (optionally) a passphrase.
· This version also introduces support for both SSH-1 and SSH-2 protocols (whereas all the previous versions supported only SSH-1).
· In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.