PatternListFromQuery.inc
3.59 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
<?php
/**
* Class PatternListFromQuery
* Takes a SQL query, an array of column names and and an array of column types
* and displays the data in a two column list format
*
* @author Rob Cherry, Jam Warehouse (Pty) Ltd, South Africa
* @date 22 January 2003
* @package lib.visualpatterns
*
* @todo implement HyperLinkURL option
*/
class PatternListFromQuery {
/** SQL query to execute */
var $sQuery;
/** array of columns to display */
var $aColumns;
/** array of column types (textfield = 1, textarea = 2, hyperlink = 3) */
var $aColumnTypes;
/** names of columns to display */
var $aColumnNames;
/** array of hyperlink URLS */
var $aHyperLinkURL;
/** array of text to be used on querystring with a hyperlink
Each entry must take the format of:
<queryStringName>=<[columnName]>&<queryStringName2>=<columnName2> e.g. fId = [DOC.id] (the querystring will be
build by replacing <columnName> with the actual value from the column
retrieved from the query)*/
var $aQueryStringText;
/** number of rows for text area if text area option is being used */
var $iTextAreaRows = 6;
/** number of colums for text area if text area option is being used */
var $iTextAreaColums = 20;
/** heading for table */
var $sTableHeading;
/** set the table width */
var $iTableWidth = null;
/**
* Default constructor
*
* @param String Query to execute
* @param
*/
function PatternListFromQuery($sNewQuery, $aNewColumns, $aNewColumnNames, $aNewColumnTypes, $aNewHyperLinkURL = null, $aNewQueryStringText = null) {
$this->sQuery = $sNewQuery;
$this->aColumns = $aNewColumns;
$this->aColumnNames = $aNewColumnNames;
$this->aColumnTypes = $aNewColumnTypes;
$this->aHyperLinkURL = $aNewHyperLinkURL;
$this->aQueryStringText = $aNewQueryStringText;
}
function setTableWidth($iNewValue) {
$this->iTableWidth = $iNewValue;
}
function setTextAreaRows($iNewValue) {
$this->iTextAreaRows = $iNewValue;
}
function setTextAreaColumns($iNewValue) {
$this->iTextAreaColumns = $iNewValue;
}
function setTableHeading($sNewValue) {
$this->sTableHeading = $sNewValue;
}
function setRenderIndividualTableForEachResult($bNewValue) {
$this->bIndividualTableForEachResult = $bNewValue;
}
function & render() {
$sql = new Owl_DB();
$sql->query($this->sQuery);
$sToRender = "";
$sToRender .= "<table border = 0, cellpadding = 5 " . (isset($this->iTableWidth) ? ", width = $this->iTableWidth" : "") . " >\n";
while ($sql->next_record()) {
if (isset($this->sTableHeading)) {
$sToRender .= "<caption align = left><b>$this->sTableHeading</b></caption>\n";
}
$sToRender .= "<tr><td>\n";
for ($i = 0; $i < count($this->aColumns); $i++) {
$sToRender .= "<tr>\n";
switch ($this->aColumnTypes[$i]) {
//plain text field
case 1:
$sToRender .= "<td>" . $this->aColumnNames[$i] . "</td><td>" . $sql->f($this->aColumns[$i]) . "</td>\n";
break;
//text area
case 2:
$sToRender .= "<td>" . $this->aColumnNames[$i] . "</td><td><textarea cols=$this->iTextAreaColumns rows=$this->iTextAreaRows READONLY>" . $sql->f($this->aColumns[$i]) . "</textarea></td>\n";
break;
case 3:
$sToRender .= "<td>" . $this->aColumnNames[$i] . "</b></td><td><a href=\"" . $this->aHyperLinkURL[$i] . "?" . $this->replaceValues($this->aQueryStringText[$i], $sql) . "\">" . $sql->f($this->aColumns[$i]) . "</a></td>\n";
break;
default:
break;
}
$sToRender .= "</tr>\n";
}
}
$sToRender .= "</table>\n";
return $sToRender;
}
function replaceValues($sQueryStringText, $sql) {
return $sQueryStringText;
}
}
?>