PatternListBox.inc
4.22 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
<?php
/**
*
* Class PatternListBox
*
* Creates a drop down list box using a table name and
* two column names (one column is the display value, the other
* is the option value). The option value column should always
* be an ID that is a primary key in a table.
*
* @author Rob Cherry, Jam Warehouse (Pty) Ltd, South Africa
* @date 16 January 2003
* @todo - if the list is set to submit on change, it submits the form. Investigate ways
* to get a list action to occur, instead of the default form action
* @package lib.visualpatterns
*
*/
class PatternListBox {
/** Database table to get information from */
var $sTableName;
/** Column in table to display */
var $sDisplayColumn;
/** Column in table to use as option value */
var $sValueColumn;
/** Select name */
var $sSelectName;
/** Where clause */
var $sWhereClause;
/**from clause, use to add extra inner joins. The default selected table gets
a name of ST and the two selected columns are 'value' and 'display' */
var $sFromClause;
/** Order columns ascending*/
var $bOrderAsc;
/** set this to true to cause the list box to post back on a change */
var $bPostBackOnChange = false;
/** action to perform on a postback */
var $sOnChangeAction = "document.MainForm.submit();";
/** currently selected value */
var $selectedValue;
/** error message for an empty list box */
var $sEmptyErrorMessage = "No values";
/** whether to include 'None' as an option*/
var $bIncludeDefaultValue = true;
/**
* Constructor
*
* @param Table in database that information will come from
* @param Column in table that will be display in list box
* @param Column in table that will be assigned to the 'option' attribute
* @param 'name' attribute of 'select' tab
* @param Where clause
*/
function PatternListBox($sNewTableName, $sNewDisplayColumn, $sNewValueColumn, $sNewSelectName, $sNewWhereClause = null, $bNewOrderAsc = true) {
$this->sTableName = $sNewTableName;
$this->sDisplayColumn = $sNewDisplayColumn;
$this->sValueColumn = $sNewValueColumn;
$this->sSelectName = $sNewSelectName;
$this->sWhereClause = $sNewWhereClause;
$this->bOrderAsc = $bNewOrderAsc;
}
function setPostBackOnChange($bNewValue) {
$this->bPostBackOnChange = $bNewValue;
}
function setOnChangeAction($sNewValue) {
$this->sOnChangeAction = $sNewValue;
}
function setSelectedValue($NewValue) {
$this->selectedValue = $NewValue;
}
function setWhereClause($sNewValue) {
$this->sWhereClause = $sNewValue;
}
function setFromClause($sNewValue) {
$this->sFromClause = $sNewValue;
}
function setEmptyErrorMessage($sNewValue) {
$this->sEmptyErrorMessage = $sNewValue;
}
function setIncludeDefaultValue($bNewValue) {
$this->bIncludeDefaultValue = $bNewValue;
}
/**
* Create the HTML string that will be used to render the list box
*
* @return String html used to render the list box
*
*/
function & render() {
global $default;
$sql = $default->db;
$sQuery = "SELECT DISTINCT ST." . $this->sDisplayColumn . " AS display, ST." . $this->sValueColumn . " AS value FROM $this->sTableName AS ST ";
if (isset($this->sFromClause)) {
$sQuery .= $this->sFromClause . " ";
}
if (isset($this->sWhereClause)) {
$sQuery .= "WHERE " . $this->sWhereClause . " ";
}
$sQuery .= "ORDER BY $this->sDisplayColumn " . ($this->bOrderAsc ? "ASC" : "DESC");
$sql->query($sQuery);
if ($sql->num_rows() > 0) {
//$sToRender = "<SELECT NAME = \"$this->sSelectName\" ". ($this->bPostBackOnChange ? "onChange=\"location=$this->sOnChangeAction;\" " : " ") . ">\n";
$sToRender = "<SELECT NAME = \"$this->sSelectName\" ". ($this->bPostBackOnChange ? "onChange=\"document.MainForm.submit();\" " : " ") . ">\n";
if ($this->bIncludeDefaultValue) {
$sToRender .= "<OPTION value=\"-1\">None</OPTION>\n";
}
while ($sql->next_record()) {
if ($this->selectedValue == $sql->f("value")) {
$sToRender .= "<OPTION value=\"" . $sql->f("value") . "\" SELECTED>" . $sql->f("display") . "</OPTION>\n";
} else {
$sToRender .= "<OPTION value=\"" . $sql->f("value") . "\">" . $sql->f("display") . "</OPTION>\n";
}
}
$sToRender .= "</SELECT>\n";
} else {
$sToRender .= "<label class=\"errorText\">$this->sEmptyErrorMessage</label>\n";
}
return $sToRender;
}
}
?>