Softpedia >Windows >Internet >Servers >Database Utils >Oracle PHP Generator Professional >  Changelog

Oracle PHP Generator Professional Changelog

What's new in Oracle PHP Generator Professional 12.8.0.18

Jul 22, 2014
  • Ability to specify several output paths for a project is added (useful if you want to test the generated app under several local webservers).
  • Now it is possible to include/exclude all columns to/from a certain presentation with a single click.
  • Editors for entering file name templates (for example, in the Upload file to folder properties dialog) become more convenient.
  • MS SQL: default content encoding is set to ANSI.
  • Some client-side events did not fire for Insert forms in master/detail pages.
  • Changes of column properties at the General tab could be displayed incorrectly for columns excluded from the List view.
  • Headers of "Stored value" and "Display value" columns in Radio/Checkbox group editors are not swapped anymore.
  • Popup hints for "More" links become available for columns of detail rows in master/detail views.
  • Popup hints for "More" links could be displayed for non-english texts even if the text is not truncated.
  • Images stored in the database could be displayed incorrectly in master/detail views if columns in master and detail tables have the same name.
  • Uploading images to the database could cause a PHP warning in the strict mode.
  • MS SQL: national symbols are now inserted and updated correctly even if the database collation does not correspond to the system locale.
  • Code generation from the command line did not work without specifying the -o parameter (output directory). Now this parameter is not required (as it can be obtained from the project file).
  • Some other minor fixes and corrections.

New in Oracle PHP Generator Professional 12.8.0.16 (Apr 12, 2014)

  • Support for user-defined parameters in custom templates. More information and examples.
  • Ability to use separate custom layout templates for Insert and Edit forms.
  • MS SQL Server: added support for SQL Server Express LocalDB databases. To access such databases, use SQL Server 2012 Native Client (SQLNCLI11) and SQL Server Driver for PHP.
  • Czech localization has been improved. Thanks to Jaromír Adámek.
  • Hopefully the final fix for processing datetime values in formats like m-d-y or d/m/Y. Now should work correctly for all supported versions of PHP.
  • Filter row: filtering on date/datetime values could cause an error.
  • Export to some formats could work incorrectly on using the ANSI encoding.
  • Some other minor fixes and code optimization.

New in Oracle PHP Generator Professional 12.8.0.15 (Apr 12, 2014)

  • A new implementation of HTTP tunnel based on the MySQLi PHP extension.
  • Smart default values of view/edit properties for pages based on queries.
  • Automatic detection of query key columns.
  • The visible (true|false) method added to the editor's API.
  • A modal editor for lookup conditions becomes available (useful for lengthy and complex conditions).
  • A link to the manual is included into the warning on invalid queries.
  • Less compiler errors (if any) are now dispalyed in the preview window after theme customization.
  • A warning message is displayed in the preview window on detecting an obsolete IE version
  • Command buttons are added to the Details tab of the Page Editor.
  • "More information and examples" link becomes available for global events.
  • Combobox editor could display incorrect value if detail field contains NULL and master table contains a record with id = 0.
  • Datetime values could be processed incorrectly on using some datetime formats like m-d-y or d/m/Y.
  • A warning message is displayed if either .NET framework or dotLess compiler are missing in the system.
  • A missing ampersand is added to the customHTMLHeaderText parameter in the OnCustomHTMLHeader event handler.
  • Some other minor fixes and code optimization.

New in Oracle PHP Generator Professional 12.8.0.14 (Nov 21, 2013)

  • Filter row: the "Apply filter automatically" option is added. Also it becomes possible to specify the timer interval .
  • Default empty grid height was decreased from 200 to 25 pixels.
  • The login panel is now always visible and right-aligned (even on pages with a large amount of columns).
  • There are no more conflicts between the library and generated files (so it becomes possible to use any file names for output pages).
  • User-defined styles are now applied to the login page.
  • Some markup corrections to simplify applying of user-defined styles.
  • A number of translations have been updated.
  • Some other minor fixes and code optimization.

New in Oracle PHP Generator Professional 12.8.0.12 (Sep 3, 2013)

  • This version has been successfully tested with PHP 5.5.
  • Support for the SQLite3 database extension has been implemented.
  • MySQL bit(1) columns are now displayed as check boxes.
  • Turkish localization has been added.
  • Fixed some potential security vulnerabilities.
  • PostgreSQL: modal and inline inserts could work incorrectly on using the serial data type.
  • Some other minor fixes and code optimization.

New in Oracle PHP Generator Professional 12.8.0.11 (Jun 18, 2013)

  • Support for keyboard interactive SSH authentication has been added (when applicable).
  • New program icons designed for up to 256x256 resolution.
  • Now end-users can change their passwords themselves (on using table-based authorization).
  • Record-level security becomes available for the first level detail pages.
  • Admin panel: now to change a user password you need to enter it twice to avoid input mistakes.
  • The inline display mode has been added for checkbox and radio groups (default mode is stacked).
  • A handy editor has been added for editing combobox and radiogroup values.
  • Computed columns are now excluded from the edit and insert forms by default (where applicable).
  • Slovenian localization has been added.
  • No warnings are displayed anymore on opening the generated PHP files in our favorite IDE.
  • Record-level security: additional verification of permissions has been added on opening of edit forms and on saving data.
  • Table-based authorization: application and page-level permissions could be incorrectly saved in the database in certain cases.
  • Now all the SpinEdit properties are saved, restored, and processed as expected.
  • Some other minor fixes and code optimization.

New in Oracle PHP Generator Professional 12.8.0.10 (May 24, 2013)

  • New modern look and feel. The main goal of the new version is to provide a capability to construct a modern-look and powerful web applications in the simplest possible way. For this purpose we significantly changed the design for all generated pages and refactored the web code. We hope you and your end-users will like the new UI.
  • Enhanced master-detail management. The new version provides some extremely useful features such as inline displaying of nested detail views without limitation on the depth and displaying several detail presentations simultaneously on the tabs.
  • Custom templates. From now on you can customize the design and layout of pages produced by PHP Generator according to your needs. For example, you can change captions, re-arrange controls, or even add a chart diagram for a certain page.
  • Automatic Filter Row. This row is displayed at the top of the data rows and allows you to filter data on the fly by typing text directly into the row. When you type the text within a cell in the row, a filter condition is automatically created based upon the values entered and applied to the column. The filter is updated automatically after 1 second after entering a value or when you press the Enter key.
  • Filter Builder. This control displays filter criteria as a tree structure and allows you to visually build complex filter criteria with an unlimited number of filter conditions combined by logical operators. The Filter Builder window can be invoked by pressing the Create filter link at the bottom of the grid.
  • New visual themes. In this case a picture is worth a thousand words, so please find all of them at the appropriate step of the software.
  • Improved usability. Starting from this version you can access detail pages directly from insert, edit, and view forms. This should be especially useful on adding new records.
  • New Autocomplete and Milti-Level Autocomplete controls. The new versions of these widgets allow you to select a required value as comfortable as possible.
  • New "after action" events. The OnAfterInsertRecord, OnAfterEditRecord, and OnAfterDeleteRecord events are now at your disposal.
  • On-the-fly metadata refreshing. Starting from this version you can synchronize your database schema changes with PHP Generator in a single click.
  • In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

New in Oracle PHP Generator Professional 11.12.0.1 (Dec 23, 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.

New in Oracle PHP Generator Professional 11.4.0.14 (Nov 17, 2011)

  • Support for multi-level auto-complete editors has been implemented. Such control is based on cascading drop-down lists and allows you to select a value from a long list step-by-step. For example, when we select a country in the Country drop-down list, it will populate the City drop-down list according to the country selected, and so on
  • Starting with this version it is possible to edit and insert data within modal dialogs. To activate this feature, tick the corresponding checkbox in the Project Options or Page Properties window
  • Starting with this version it becomes possible to use a fixed header for data grid as well as display line numbers for grid records
  • Client side validation has been significantly improved. Now our software comes with a number of pre-defined validators including Range, Length range, Email, Credit card, URL, Regular expression, and some others. It is also still possible to implement your own validation logic using the OnEditFormValidate/OnInsertFormValidate events
  • New version comes with a time edit control (that is now used by default for columns that store time-of-day values) and with a masked edit control that provides restricted data input
  • Support for grid footers has been added. The footers allow you to display summaries (Sum, Average, Count, etc) for all or selected grid columns
  • New version also features a possibility of excluding certain files from the output. This can be useful if you modified some files (e.g. images) manually and don’t want them to be rewritten on the next generation
  • Now it is possible to enable lookup editors based on a template that contains one or more table columns. No more additional queries, just specify the template of the editor data and get easy-to-use interface
  • The Generate thumbnail option has been added to additional settings of the Upload image to folder editor. This feature allows you to save resized copies of uploaded images to a specified catalog

New in Oracle PHP Generator Professional 10.8 (Nov 17, 2011)

  • Key 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.
  • 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.
  • 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.
  • 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.
  • 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.

New in Oracle PHP Generator Professional 10.3 (Nov 17, 2011)

  • The Autocomplete Editor has been implemented. After entering something into such a control, PHP Generator starts searching for matching entries and displays a list of values to choose from. By entering more characters, the user can filter down the list to better matches.
  • Starting with this version it is possible to use WYSIWYG Editor for text fields that store an HTML code. Such a control provides an editing interface which resembles how the data will be displayed in a web browser in the generated app. Because using a WYSIWYG editor does not require any HTML knowledge, they are easier for an average computer user to get started with.
  • Support for horizontal filters has been added. The filters allow you to restrict number of records returned without necessary to create a query-based page and provide custom SQLs for INSERT, UPDATE, and DELETE.
  • Nested master-detail presentations have been implemented. Such presentations are very useful for displaying data with multilevel master/detail relationships (for example, conference/division/team/player).
  • Starting with this version it is possible to define primary key columns for views and updatable queries. By default (if not defined manually) the key includes all the non-BLOB columns.
  • Support for right-to-left languages (such as Arabic and Hebrew) has been added. Text direction can be specified for a concrete page, for a whole project or even at the application level (for all the projects).
  • The read-only attribute has been added to the column properties. Values of such columns are displayed at the Edit and Insert pages but they cannot be changed.
  • Support for project-level data manipulation events has been added (OnBeforeInsertRecord, OnBeforeUpdateRecord, OnBeforeDeleteRecord). These events allow you to share the same logic for all the insert, update and delete operations executed from the project pages. Also we have implemented the OnAfterLogin event to allow you to track user activity.
  • A lot of other useful things including default ordering for page records, hints for the column headers, pictograms for adding/editing/deleting records, updated image viewer and calendar components, printing for single records, controls for editing passwords, and so on.

New in Oracle PHP Generator Professional 9.12 (Nov 17, 2011)

  • 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
  • Possible to connect to a remote server via SSH tunnel using a key-based authentication
  • support for both SSH-1 and SSH-2 protocols