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 setEmptyTableMessage($sNewValue) { $this->sEmptyTableMessage = $sNewValue; } function & render() { global $default; $sSectionName = $default->siteMap->getSectionName(substr($_SERVER["PHP_SELF"], strlen($default->rootUrl), strlen($_SERVER["PHP_SELF"]))); $sTDBGColour = $default->siteMap->getSectionColour($sSectionName, "td"); $sql = $default->db; $sql->query($this->sQuery); $sToRender = ""; $sToRender .= "iTableWidth) ? " width=\"$this->iTableWidth\"" : "") . " >\n"; if (isset($this->sTableHeading)) { $sToRender .= "\n"; } if ($sql->num_rows() == 0) { $sToRender .= "\n"; if (isset($this->sEmptyTableMessage)) { $sToRender .= "\n"; } else { $sToRender .= "\n"; } $sToRender .= "\n"; } else { $iColour = 0; while ($sql->next_record()) { $sToRender .= "\n"; switch ($this->aColumnTypes[$i]) { //plain text field case 1: $sToRender .= "\n"; } else { $sToRender .= " "; } break; //text area case 2: //boolean $sToRender .= ""; } else { $sToRender .= " "; } break; //$sToRender .= "\n"; //break; case 3: $sToRender .= "\n"; break; default: break; } $sToRender .= "\n"; $iColour++; } } } $sToRender .= "

aColumns) . "\">$this->sTableHeading

$this->sEmptyTableMessage	No " . (isset($this->sTableHeading) ? "$this->sTableHeading" : "") . " data
\n"; for ($i = 0; $i < count($this->aColumns); $i++) { $sToRender .= "
" . $this->aColumnNames[$i] . "	"; if ($sql->f($this->aColumns[$i]) != null) { $sToRender .= $sql->f($this->aColumns[$i]) . "	" . $this->aColumnNames[$i] . "	"; if ($sql->f($this->aColumns[$i]) != null) { $value = $sql->f($this->aColumns[$i]); if ($value) { $sToRender .= "graphicsUrl/" . $this->sChkPicPath . "\">"; } else { $sToRender .= "graphicsUrl/" . $this->sUnChkPicPath . "\">"; } $sToRender .= "	" . $this->aColumnNames[$i] . "	iTextAreaColumns rows=$this->iTextAreaRows READONLY>" . $sql->f($this->aColumns[$i]) . "	" . $this->aColumnNames[$i] . "	aHyperLinkURL[$i] . "?" . $this->replaceValues($this->aQueryStringText[$i], $sql) . "\">" . $sql->f($this->aColumns[$i]) . "

\n"; return $sToRender; } function replaceValues($sQueryStringText, $sql) { return $sQueryStringText; } } ?>