You can enter the following UBB tags: [b]bold[/b], [i]italic[/i], [red]red[/red] and [pre] [/pre]
Topic: PHPLens Newsletter #19 (phpLens 3.20 is out)
author: John Lim
created: 13-08-2003 10:53:24 AM
PHPLens 3.20 is out.
a. improved UI configuration: previously you had to use templates for many
user interface features. Now we help you reduce the need for such templates
by offering many ui configuration features from the dynamic editor.
In this example, note that phpLens editor has section breaks for ADDRESS and
MISC. Also the "postcode" and "city" are on the same line in the details
grid and NEW/EDIT forms.
b. keyVariable: previously keeping track of the primary key in a PHP session
variable did not work when inserting records, using the old
keyColVariable property. The newer keyVariable property fixes this
problem. Also you can enter this in the dynamic editor.
c. The new selectLookupLens helps you perform searches for data entry in
the NEW/EDIT forms. See the two examples:
Detailed Info on UI Improvements
In your edit/new record forms and detail grid, sometimes you want to have two
fields in the same row. Previously, the only way to do so was by using a
template. Now we have a property that allows you to do this.
From the dynamic editor for a column, select the "2 Fields in Row" checkbox
and the next 2 fields will be in the same row.
HINT: Don't forget that you have a similar functionality in the Filter Form.
When you click on a column in the filter form, you can set the "Fields per Row"
This property allows you to control whether you want to have borders around
the tables that make up phpLens. From the global settings dynamic editor
(red "e" button), just below Table Width 100%, you will see 3 radio buttons:
This allows you to create a CSS page break after x number of rows. Useful
for reports. For example, set $lens->pageBreakRows = 10 and a page break
will be added after every 10 rows. This setting can be configured in the
dynamic editor too, below "#Rows per Page".
This allows you to have a section break between fields in your edit/new record
form and details grid. You can place a title in the section break.
This is configuration in the Columns dynamic editor just above the
"WYSIWYG Editor" setting.
In phpLens 3.1.2, we added the keyVariable property, which stores in a
session variable the primary key of the currently selected record. Eg.
$lens->keyVariable = 'KEY' will store in $_SESSION['KEY'] the primary
key of the current record.
Now when $lens->keyColClear = true (the default), we will set $_SESSION['KEY']
to false when no record is selected, or we scroll the page away from the
previous record, or a new search is initiated, or phpLens is reset.
When $lens->keyColClear = false, then the $_SESSION['KEY'] is never cleared,
except when (a) a new search is initiated, (b) phpLens is reset.
This property allows you to set various save settings for the New/Edit record
The sqlWhere property is no longer saved after every change (persistent).
Instead sqlWhere must now be reset on every page request. This makes sqlWhere
useful for temporary setting of the Where clause for 1 page request.
Detailed Change Log
=== 3.2.0/3.1.5 13 Aug 2003
The detail grid were not hidden properly if showDetails == false and keyVariable set. Fixed.
Some bugs in lookups involving #Meta*. Fixed.
Numbers in detail grid are now left-aligned!
Now is supported as a non-breaking space in lookupLens
If grouping by alphanumeric field, sumLens has these problems
- a. first subtotals after first page is wrong if group name is not in uppercase already
- b. group change not detected if occurs exactly at end-of-page.
Added pageBreakHTML property.
=== 3.1.4 6 Aug 2003
Now combo boxes support hotupdates properly, both sending and receiving.
Also combo popup is always reset to blank to avoid seeing double.
Tested combo with IE 5/6, Mozilla 1.4.
Added ability to display delete icon in edit form. Set $lens->saveOptions = 'DELETE';
Added $lens->saveOptions = 'HIDETOPBTNS' and 'SAMEROW1COLOR'.
Removed showNewInEdit property. Changed to use saveOptions = 'NEW'.
Execution of applet can be deferred with $PHPLENS_DO_NOT_RUN.
Added inputTypeLens type readonly and property roInputStyle
Added support for MetaColumns, MetaPrimaryKeys and MetaForeignKeys in phplens_remoteq.php.
Added sectionLens, keyColClear properties.
Set default of keyColClear to true, which has backward compat issues.
Now defaultLens supports global variables.
Added pageBreakRows property.
=== 3.1.3 11 July 2003
Release to BCouncil.
Cleaned up _sqlBind. Also made sqlBind work only with odbc_mssql and oci8.
Searching for dates with BETWEEN for mssql did not work properly without CAST. Fixed.
If debug is enabled, search form uses GET method for easy copy and paste.
If debug is enabled, now lookupLens are shown too, in italics.
Fixed bug in dynamic editing, hiding of menus did not work properly.
Changed OS check for MS-Windows to prevent confusion with darWIN (MacOS)
=== 3.1.2 23 June 2003
We now optimize odbc_mssql, using bind parameters.
Optimizations in filtering for oci8 and odbc_mssql disabled when filterModifierFn is enabled
to guarantee 100% compatibility...
Do not validate blank input fields.
showNewInEdit property (set to false|true)
keyVariable property (varName;SQL) -- mention that keyColVariable is obsolete...
Fixed validation of numeric fields bug introduced in 3.1.0, which caused
setting field to read-only to fail.
Default value of '0' not properly handled because we use empty(). Fixed.
We also validate for numbers between 1-31 for days, 1-12 for months.
Added details to below grid option in showRecNo property.
Made nameSpace first class property, which separate set of variable properties when
Combo box with value/text pairs did not work. Fixed.
Filtering an empty dataset with child new record form caused the filter criteria form
to disappear, with only the new rec form showing. Fixed.
Experimental sameRowLens and border0.
Added .cvsignore file to applet directory, to ignore templates_c directory.
When in FILTERVIEW mode, we no longer switch to new record form when no recs found
Added noAutoNew property, if true we do not auto-show new record form when no records found - requested by vince.
=== 3.1.1 May 2003
Added $PHPLENS_REPORT_WRITER variable. Set to true to disable editing/create new record.
ForceType in dynamic editor overwrote previous settings - fixed.
We now quote field names in search screen.
We also fix spNew to set unknown fields to null.
Redirect using redirect properties attempts to use Header redirect even on windows.
The filterModifierFn did not work properly with numeric fields. Fixed.
Now searchLookupLens has priority over lookupLens, and it can set the
value of a user-defined input field.
Fixed mssql order by non-unique cols bug, when cols are numeric
The filterLens does not work when exporting if filterLens undefined,
so we now automatically define it on creation of applet.
Added Oracle CLOB support in insert/update.
Added new property searchLookupLens
added modes: only in NEW state, NEW to EDIT, and cancel button
works with popups, radios and text fields.
does not work with checkboxes, because checkboxes do not store actual
data values, but array indices. changing behaviour would break compat
with some apps.
We validate date/time fields, so you can only enter 1-31 for days, 1-12 for mths, etc.
We also auto-tab date/time fields if we reach maxlength characters.
Combo box input type, though available since 1.2, was missing from the docs
and dynamic editor. Added!
keyCompound cannot be cleared from dynamic editor - fixed.
Generated edit/new templates are more user-friendly now.
Added new method ResetAll() that also deselects the currently selected record (and clears
the associated primary key value).
Added filterTableCols property.
The random number in the sort urls is set to a fixed length (5 chars) to ensure
that ab (apache bench) does not generate length errors.
New global $PHPLENS_TABLE which holds name of phplens table. Defaults to 'phplens'.
We now auto-hide (in IE) select tags when in dynamic editing mode, so that select tags
do not shine thru.