Allow for field names to be prefixed with 'xxxx' in some cases.
[awl.git] / inc / DataEntry.php
blobb2b62fd99ac9a5114510444be71c7025f545a6b0
1 <?php
2 /**
3 * Classes to handle entry and viewing of field-based data.
5 * @package awl
6 * @subpackage DataEntry
7 * @author Andrew McMillan <andrew@mcmillan.net.nz>
8 * @copyright Catalyst IT Ltd, Morphoss Ltd <http://www.morphoss.com/>
9 * @license http://gnu.org/copyleft/gpl.html GNU GPL v2
11 require_once("AWLUtilities.php");
13 /**
14 * Individual fields used for data entry / viewing.
16 * This object is not really intended to be used directly. The more normal
17 * interface is to instantiate an {@link EntryForm} and then issue calls
18 * to {@link DataEntryLine()} and other {@link EntryForm} methods.
20 * Understanding the operation of this class (and possibly auditing the source
21 * code, particularly {@link EntryField::Render}) will however convey valuable
22 * understanding of some of the more
23 * esoteric features.
25 * @todo This class doesn't really provide a huge amount of utility between construct
26 * and render, but there must be good things possible there. Perhaps one EntryField
27 * is created and used repeatedly as a template (e.g.). That might be useful to
28 * support... Why is this a Class anyway? Maybe we should have just done half a
29 * dozen functions (one per major field type) and just used those... Maybe we should
30 * build a base class for this and extend it to make EntryField in a better way.
32 * EntryField is only useful at present if you desperately want to use it's simple
33 * field interface, but want to intimately control the layout (or parts of the layout),
34 * otherwise you should be using {@link EntryForm} as the main class.
36 * @package awl
38 class EntryField
40 /**#@+
41 * @access private
43 /**
44 * The name of the field
45 * @var string
47 var $fname;
49 /**
50 * The type of entry field
51 * @var string
53 var $ftype;
54 /**#@-*/
56 /**#@+
57 * @access public
59 /**
60 * The current value
61 * @var string
63 var $current;
65 /**
66 * An array of key value pairs
67 * @var string
69 var $attributes;
71 /**
72 * Once it actually is...
73 * @var string
75 var $rendered;
76 /**#@-*/
78 /**
79 * Initialise an EntryField, used for data entry.
81 * The following types of fields are possible:
82 * <ul>
83 * <li>select - Will display a select list of the keys/values in $attributes where the
84 * key starts with an underscore. The key will have the '_' removed before being used
85 * as the key in the list. All the $attributes with keys not beginning with '_' will
86 * be used in the normal manner as HTML attributes within the &lt;select ...&gt; tag.</li>
87 * <li>lookup - Will display a select list of values from the database.
88 * If $attributes defines a '_sql' attibute then that will be used to make
89 * the list, otherwise the database values will be from the 'codes' table
90 * as in "SELECT code_id, code_value FROM codes WHERE code_type = '_type' ORDER BY code_seq, code_id"
91 * using the value of $attributes['_type'] as the code_type.</li>
92 * <li>date - Will be a text field, expecting a date value which might be
93 * javascript validated at some point in the future.</li>
94 * <li>checkbox - Will display a checkbox for an on-off value.</li>
95 * <li>textarea - Will display an HTML textarea.</li>
96 * <li>file - Will display a file browse / enter field.</li>
97 * <li>button - Will display a button field.</li>
98 * <li>password - Password entry. This will display entered data as asterisks.</li>
99 * </ul>
101 * The $attributes array is useful to set specific HTML attributes within the HTML tag
102 * used for the entry field however $attribute keys named starting with an underscore ('_')
103 * affect the field operation rather than the HTML. For the 'select' field type, these are
104 * simply used as the keys / values for the selection (with the '_' removed), but other
105 * cases are more complex:
106 * <ul>
107 * <li>_help - While this will be ignored by the EntryField::Render() method the _help
108 * should be assigned (or will be assigned the same value as the 'title' attribute) and
109 * will (depending on the data-entry line format in force) be displayed as help for the
110 * field by the EntryForm::DataEntryLine() method.</li>
111 * <li>_sql - When used in a 'lookup' field this controls the SQL to return keys/values
112 * for the list. The actual SQL should return two columns, the first will be used for
113 * the key and the second for the displayed value.</li>
114 * <li>_type - When used in a 'lookup' field this defines the codes type used.</li>
115 * <li>_null - When used in a 'lookup' field this will control the description for an
116 * option using a '' key value which will precede the list of values from the database.</li>
117 * <li>_zero - When used in a 'lookup' field this will control the description for an
118 * option using a '0' key value which will precede the list of values from the database.</li>
119 * <li>_label - When used in a 'radio' or 'checkbox' field this will wrap the field
120 * with an HTML label tag as <label ...><input field...>$attributes['_label']</label></li>
121 * <li> - </li>
122 * </ul>
124 * @param text $intype The type of field:
125 * select | lookup | date | checkbox | textarea | file | button | password
126 * (anything else is dealt with as "text")
128 * @param text $inname The name of the field.
130 * @param text $attributes An associative array of extra attributes to be applied
131 * to the field. Optional, but generally important. Some $attribute keys have
132 * special meaning, while others are simply added as HTML attributes to the field.
134 * @param text $current_value The current value to use to initialise the
135 * field. Optional.
137 function EntryField( $intype, $inname, $attributes="", $current_value="" )
139 $this->ftype = $intype;
140 $this->fname = $inname;
141 $this->current = $current_value;
143 if ( isset($this->{"new_$intype"}) && function_exists($this->{"new_$intype"}) ) {
144 // Optionally call a function within this object called "new_<intype>" for setup
145 $this->{"new_$intype"}( $attributes );
147 else if ( is_array($attributes) ) {
148 $this->attributes = $attributes;
150 else {
153 $this->rendered = "";
157 * Render an EntryField into HTML
158 * @see EntryField::EntryField(), EntryForm::DataEntryLine()
160 * @return text An HTML fragment for the data-entry field.
162 function Render() {
163 global $session;
165 $r = "<";
166 dbg_error_log( "EntryField", ":Render: Name: %s, Type: %s, Current: %s", $this->fname, $this->ftype, $this->current );
167 $size = "";
168 switch ( $this->ftype ) {
170 case "select":
171 $r .= "select name=\"$this->fname\"%%attributes%%>";
172 reset( $this->attributes );
173 while( list($k,$v) = each( $this->attributes ) ) {
174 if ( substr($k, 0, 1) != '_' ) continue;
175 if ( $k == '_help' ) continue;
176 $k = substr($k,1);
177 $r .= "<option value=\"".htmlspecialchars($k)."\"";
178 if ( "$this->current" == "$k" ) $r .= " selected";
179 $r .= ">$v</option>" ;
181 $r .= "</select>";
182 break;
184 case "lookup":
185 $r .= "select name=\"$this->fname\"%%attributes%%>";
186 reset( $this->attributes );
187 while( list($k,$v) = each( $this->attributes ) ) {
188 if ( substr($k, 0, 1) != '_' ) continue;
189 $k = substr($k,1);
190 if ( $k == 'help' || $k == "sql" || $k == "type" ) continue;
191 if ( $k == "null" ) $k = "";
192 if ( $k == "zero" ) $k = "0";
193 $r .= "<option value=\"".htmlspecialchars($k)."\"";
194 if ( "$this->current" == "$k" ) $r .= " selected";
195 $r .= ">$v</option>" ;
197 if ( isset($this->attributes["_sql"]) ) {
198 $qry = new PgQuery( $this->attributes["_sql"] );
200 else {
201 $qry = new PgQuery( "SELECT code_id, code_value FROM codes WHERE code_type = ? ORDER BY code_seq, code_id", $this->attributes['_type'] );
203 $r .= $qry->BuildOptionList( $this->current, "rndr:$this->fname", array('translate'=>1) );
204 $r .= "</select>";
205 break;
207 case "date":
208 case "timestamp":
209 $size = '';
210 if ( !isset($this->attributes['size']) || $this->attributes['size'] == "" ) $size = " size=" . ($this->ftype == 'date' ? "12" : "18");
211 $r .= "input type=\"text\" name=\"$this->fname\"$size value=\"".$session->FormattedDate(htmlspecialchars($this->current))."\"%%attributes%%>";
212 break;
214 case "checkbox":
215 // We send a hidden field with a false value, which will be overridden by the real
216 // field with a true value (if true) or not overridden (if false).
217 $r .= "input type=\"hidden\" name=\"$this->fname\" value=\"off\"><";
218 case "radio":
219 $checked = "";
220 if ( $this->current == 't' || intval($this->current) == 1 || $this->current == 'on'
221 || (isset($this->attributes['value']) && $this->current == $this->attributes['value'] ) )
222 $checked = " checked";
223 $id = "id_$this->fname" . ( $this->ftype == "radio" ? "_".$this->attributes['value'] : "");
224 if ( isset($this->attributes['_label']) ) {
225 $r .= "label for=\"$id\"";
226 if ( isset($this->attributes['class']) )
227 $r .= ' class="'. $this->attributes['class'] . '"';
228 $r .= "><";
230 $r .= "input type=\"$this->ftype\" name=\"$this->fname\" id=\"$id\"$checked%%attributes%%>";
231 if ( isset($this->attributes['_label']) ) {
232 $r .= " " . $this->attributes['_label'];
233 $r .= "</label>";
235 break;
237 case "button":
238 $r .= "input type=\"button\" name=\"$this->fname\"%%attributes%%>";
239 break;
241 case "submit":
242 $r .= "input type=\"submit\" name=\"$this->fname\" value=\"".htmlspecialchars($this->current)."\"%%attributes%%>";
243 break;
245 case "textarea":
246 $r .= "textarea name=\"$this->fname\"%%attributes%%>$this->current</textarea>";
247 break;
249 case "file":
250 if ( !isset($this->attributes['size']) || $this->attributes['size'] == "" ) $size = " size=25";
251 $r .= "input type=\"file\" name=\"$this->fname\"$size value=\"".htmlspecialchars($this->current)."\"%%attributes%%>";
252 break;
254 case "password":
255 $r .= "input type=\"password\" name=\"$this->fname\" value=\"".htmlspecialchars($this->current)."\"%%attributes%%>";
256 break;
258 default:
259 $r .= "input type=\"text\" name=\"$this->fname\" value=\"".htmlspecialchars($this->current)."\"%%attributes%%>";
260 break;
263 // Now process the generic attributes
264 reset( $this->attributes );
265 $attribute_values = "";
266 while( list($k,$v) = each( $this->attributes ) ) {
267 if ( $k == '_readonly' ) $attribute_values .= " readonly";
268 else if ( $k == '_disabled' ) $attribute_values .= " disabled";
269 if ( substr($k, 0, 1) == '_' ) continue;
270 $attribute_values .= " $k=\"".htmlspecialchars($v)."\"";
272 $r = str_replace( '%%attributes%%', $attribute_values, $r );
274 $this->rendered = $r;
275 return $r;
279 * Function called indirectly when a new EntryField of type 'lookup' is created.
280 * @param array $attributes The attributes array that was passed in to the new EntryField()
281 * constructor.
283 function new_lookup( $attributes ) {
284 $this->attributes = $attributes;
290 * A class to handle displaying a form on the page (for editing) or a structured
291 * layout of non-editable content (for viewing), with a simple switch to flip from
292 * view mode to edit mode.
294 * @package awl
296 class EntryForm
298 /**#@+
299 * @access private
302 * The submit action for the form
303 * @var string
305 var $action;
308 * The record that the form is dealing with
309 * @var string
311 var $record;
314 * Whether we are editing, or not
315 * @var string
317 var $EditMode;
320 * The name of the form
321 * @var string
323 var $name;
326 * The CSS class of the form
327 * @var string
329 var $class;
332 * Format string for lines that are breaks in the data entry field groupings
333 * @var string
335 var $break_line_format;
338 * Format string for normal data entry field lines.
339 * @var string
341 var $table_line_format;
344 * Format string that has been temporarily saved so we can restore it later
345 * @var string
347 var $saved_line_format;
348 /**#@-*/
351 * Initialise a new data-entry form.
352 * @param string $action The action when the form is submitted.
353 * @param objectref $record A reference to the database object we are displaying / editing.
354 * @param boolean $editmode Whether we are editing.
356 function EntryForm( $action, &$record, $editing=false )
358 $this->action = $action;
359 $this->record = &$record;
360 $this->EditMode = $editing;
361 $this->break_line_format = '<tr><th class="ph" colspan="2">%s</th></tr>'."\n";
362 $this->table_line_format = '<tr><th class="prompt">%s</th><td class="entry">%s<span class="help">%s</span></td></tr>'."\n";
366 * Initialise some more of the forms fields, possibly with a prefix
367 * @param objectref $record A reference to the database object we are displaying / editing.
368 * @param string $prefix A prefix to prepend to the field name.
370 function PopulateForm( &$record, $prefix="" )
372 foreach( $record AS $k => $v ) {
373 $this->record->{"$prefix$k"} = $v;
378 * Set the line format to have no help display
380 function NoHelp( ) {
381 $this->break_line_format = '<tr><th class="ph" colspan="2">%s</th></tr>'."\n";
382 $this->table_line_format = '<tr><th class="prompt">%s</th><td class="entry">%s</td></tr>'."\n";
386 * Set the line format to have help displayed in the same cell as the entry field.
388 function HelpInLine( ) {
389 $this->break_line_format = '<tr><th class="ph" colspan="2">%s</th></tr>'."\n";
390 $this->table_line_format = '<tr><th class="prompt">%s</th><td class="entry">%s<span class="help">%s</span></td></tr>'."\n";
394 * Set the line format to have help displayed in it's own separate cell
396 function HelpInCell( ) {
397 $this->break_line_format = '<tr><th class="ph" colspan="3">%s</th></tr>'."\n";
398 $this->table_line_format = '<tr><th class="prompt">%s</th><td class="entry">%s</td><td class="help">%s</td></tr>'."\n";
402 * Set the line format to an extremely simple CSS based prompt / field layout.
404 function SimpleForm( $new_format = '<span class="prompt">%s:</span>&nbsp;<span class="entry">%s</span>' ) {
405 $this->break_line_format = '%s'."\n";
406 $this->table_line_format = $new_format."\n";
410 * Set the line format to a temporary one that we can revert from.
411 * @param string $new_format The (optional) new format we will temporarily use.
413 function TempLineFormat( $new_format = '<span class="prompt">%s:</span>&nbsp;<span class="entry">%s</span>' ) {
414 $this->saved_line_format = $this->table_line_format;
415 $this->table_line_format = $new_format ."\n";
419 * Revert the line format to what was in place before the last TempLineFormat call.
421 function RevertLineFormat( ) {
422 if ( isset($this->saved_line_format) ) {
423 $this->table_line_format = $this->saved_line_format;
428 * Start the actual HTML form. Return the fragment to do this.
429 * @param array $extra_attributes Extra key/value pairs for the FORM tag.
430 * @return string The HTML fragment for the start of the form.
432 function StartForm( $extra_attributes='' ) {
433 if ( !is_array($extra_attributes) && $extra_attributes != '' ) {
434 list( $k, $v ) = explode( '=', $extra_attributes );
435 $extra_attributes = array( $k => $v );
437 $extra_attributes['action'] = $this->action;
438 if ( !isset($extra_attributes['method']) ) $extra_attributes['method'] = 'post';
439 if ( !isset($extra_attributes['enctype']) ) $extra_attributes['enctype'] = 'multipart/form-data';
440 if ( !isset($extra_attributes['name']) ) $extra_attributes['name'] = 'form';
441 if ( !isset($extra_attributes['class']) ) $extra_attributes['class'] = 'formdata';
442 if ( !isset($extra_attributes['id']) ) $extra_attributes['id'] = $extra_attributes['name'];
444 // Now process the generic attributes
445 reset( $extra_attributes );
446 $attribute_values = "";
447 while( list($k,$v) = each( $extra_attributes ) ) {
448 $attribute_values .= " $k=\"".htmlspecialchars($v)."\"";
450 return "<form$attribute_values>\n";
454 * Return the HTML fragment to end the form.
455 * @return string The HTML fragment to end the form.
457 function EndForm( ) {
458 return "</form>\n";
462 * A utility function for a heading line within a data entry table
463 * @return string The HTML fragment to end the form.
465 function BreakLine( $text = '' )
467 return sprintf( $this->break_line_format, translate($text));
471 * A utility function for a hidden field within a data entry table
473 * @param string $fname The name of the field.
474 * @param string $fvalue The value of the field.
475 * @return string The HTML fragment for the hidden field.
477 function HiddenField($fname,$fvalue) {
478 return sprintf( '<input type="hidden" name="%s" value="%s" />%s', $fname, htmlspecialchars($fvalue), "\n" );
482 * Internal function for parsing the type extra on a field.
484 * If the '_help' attribute is not set it will be assigned the value of
485 * the 'title' attribute, if there is one.
487 * If the 'class' attribute is not set it will be assigned to 'flookup',
488 * 'fselect', etc, according to the field type.
489 * @static
490 * @return string The parsed type extra.
492 function _ParseAttributes( $ftype = '', $attributes = '' ) {
494 if ( !is_array($attributes) ) {
495 if ( strpos( $attributes, '=' ) === false ) {
496 $attributes = array();
498 else {
499 list( $k, $v ) = explode( '=', $attributes );
500 $attributes = array( $k => $v );
504 // Default the help to the title, or to blank
505 if ( !isset($attributes['_help']) ) {
506 $attributes['_help'] = "";
507 if ( isset($attributes['title']) )
508 $attributes['_help'] = $attributes['title'];
511 // Default the style to fdate, ftext, fcheckbox etc.
512 if ( !isset($attributes['class']) ) {
513 $attributes['class'] = "f$ftype";
516 return $attributes;
520 * A utility function for a data entry line within a table
521 * @return string The HTML fragment to display the data entry field
523 function DataEntryField( $format, $ftype='', $base_fname='', $attributes='', $prefix='' )
525 global $session;
527 if ( ($base_fname == '' || $ftype == '') ) {
528 // Displaying never-editable values
529 return $format;
531 $fname = $prefix . $base_fname;
533 dbg_error_log( "DataEntry", ":DataEntryField: fmt='%s', fname='%s', fvalue='%s'", $format, $fname, (isset($this->record->{$fname})?$this->record->{$fname}:'value not set') );
534 if ( !$this->EditMode ) {
535 /** For some forms we prefix the field name with xxxx so it doesn't collide with the real DB field name. */
536 if ( !isset($this->record->{$fname}) && substr($fname,0,4) == 'xxxx' && isset($this->record->{substr($fname,4)}) )
537 $fname = substr($fname,4);
538 /** If it is a date, then format it according to the current user's date format type */
539 if ($ftype == "date" || $ftype == "timestamp")
540 return sprintf($format, $session->FormattedDate($this->record->{$fname}) );
541 dbg_error_log( "DataEntry", ":DataEntryField: fmt='%s', fname='%s', fvalue='%s'", $format, $fname, (isset($this->record->{$fname})?$this->record->{$fname}:'value not set') );
542 return sprintf($format, $this->record->{$fname} );
545 $currval = '';
546 // Get the default value, preferably from $_POST
547 if ( preg_match("/^(.+)\[(.+)\]$/", $fname, $parts) ) {
548 $p1 = $parts[1];
549 $p2 = $parts[2];
550 @dbg_error_log( "DataEntry", ":DataEntryField: fname=%s, p1=%s, p2=%s, POSTVAL=%s, \$this->record->{'%s'}['%s']=%s",
551 $fname, $p1, $p2, $_POST[$p1][$p2], $p1, $p2, $this->record->{"$p1"}["$p2"] );
552 // @todo This could be changed to handle more dimensions on submitted variable names
553 if ( isset($_POST[$p1]) ) {
554 if ( isset($_POST[$p1][$p2]) ) {
555 $currval = $_POST[$p1][$p2];
558 else if ( isset($this->record) && is_object($this->record)
559 && isset($this->record->{"$p1"}["$p2"])
561 $currval = $this->record->{"$p1"}["$p2"];
564 else {
565 if ( isset($_POST[$fname]) ) {
566 $currval = $_POST[$fname];
568 else if ( isset($this->record) && is_object($this->record) && isset($this->record->{"$base_fname"}) ) {
569 $currval = $this->record->{"$base_fname"};
571 else if ( isset($this->record) && is_object($this->record) && isset($this->record->{"$fname"}) ) {
572 $currval = $this->record->{"$fname"};
575 if ( $ftype == "date" ) $currval = $session->FormattedDate($currval);
576 else if ( $ftype == "timestamp" ) $currval = $session->FormattedDate($currval, $ftype);
578 // Now build the entry field and render it
579 $field = new EntryField( $ftype, $fname, $this->_ParseAttributes($ftype,$attributes), $currval );
580 return $field->Render();
585 * A utility function for a submit button within a data entry table
586 * @return string The HTML fragment to display a submit button for the form.
588 function SubmitButton( $fname, $fvalue, $attributes = '' )
590 $field = new EntryField( 'submit', $fname, $this->_ParseAttributes('submit', $attributes), $fvalue );
591 return $field->Render();
595 * A utility function for a data entry line within a table
596 * @return string The HTML fragment to display the prompt and field.
598 function DataEntryLine( $prompt, $field_format, $ftype='', $fname='', $attributes='', $prefix = '' )
600 $attributes = $this->_ParseAttributes( $ftype, $attributes );
601 return sprintf( $this->table_line_format, $prompt,
602 $this->DataEntryField( $field_format, $ftype, $fname, $attributes, $prefix ),
603 $attributes['_help'] );
608 * A utility function for a data entry line, where the prompt is a drop-down.
609 * @return string The HTML fragment for the drop-down prompt and associated entry field.
611 function MultiEntryLine( $prompt_options, $prompt_name, $default_prompt, $format, $ftype='', $fname='', $attributes='', $prefix )
614 $prompt = "<select name=\"$prompt_name\">";
616 reset($prompt_options);
617 while( list($k,$v) = each($prompt_options) ) {
618 $selected = ( ( $k == $default_prompt ) ? ' selected="selected"' : '' );
619 $nextrow = "<option value=\"$k\"$selected>$v</option>";
620 if ( preg_match('/&/', $nextrow) ) $nextrow = preg_replace( '/&/', '&amp;', $nextrow);
621 $prompt .= $nextrow;
623 $prompt .= "</select>";
625 return $this->DataEntryLine( $prompt, $format, $ftype, $fname, $attributes, $prefix );