sQuery = $sTmpQuery; $this->aColumns = & $aTmpColumns; $this->aColumnTypes = $aTmpColumnTypes; $this->aColumnHeaderNames = $aTmpColumnHeaderNames; $this->sWidth = $sTmpWidth; $this->bDisplayColumnHeadings = $bTmpDisplayColumnHeadings; $this->sLinkURL = $sTmpLinkURL; $this->sDBQueryStringColumn = $sTmpDBQueryStringColumn; } function setEmptyTableMessage($sNewValue) { $this->sEmptyTableMessage = $sNewValue; } function setTableHeading($sNewValue) { $this->sTableHeading = $sNewValue; } function setImageURL($sNewValue) { $this->sImageURL = $sNewValue; } function setUseImageURLFromQuery($bNewValue) { $this->bUseImageURLFromQuery = $bNewValue; } /** * Build the HTML string used to render the object * * @return String of HTML used to render object * * @todo possibly add in image size restraints for link types 2 and 3 */ function & render() { $sToRender = "\n"; if (isset($this->sTableHeading)) { $sToRender .= "\n"; } if ($this->bDisplayColumnHeadings) { for ($i = 0; $i < count($this->aColumnHeaderNames); $i++) { $sToRender .= "\n"; } } $sql = new Owl_DB(); $sql->query($this->sQuery); if ($sql->num_rows() == 0) { $sToRender .= "\n"; if (isset($this->sEmptyTableMessage)) { $sToRender .= "\n"; } else { $sToRender .= "\n"; } $sToRender .= "\n"; } else { while ($sql->next_record()) { $sToRender .= "\n"; for ($i = 0; $i < count($this->aColumns); $i++) { switch ($this->aColumnTypes[$i]) { case 1: $sToRender .= ""; break; case 3: $sToRender .= "\n"; break; default: break; } } $sToRender .= "\n"; } } $sToRender .= "

$this->sTableHeading

" . $this->aColumnHeaderNames[$i] . "
$this->sEmptyTableMessage	No " . (isset($this->sTableHeading) ? $this->sTableHeading : "") . " data
" . (isset($this->sImageURL) ? $this->generateImageURL() : "") . $sql->f($this->aColumns[$i]) . "	sLinkURL . $sql->f($this->sDBQueryStringColumn) . "\">" . (isset($this->sImageURL) ? $this->generateImageURL() : "") . $sql->f($this->aColumns[$i]) . "

"; return $sToRender; } function generateImageURL() { return "sImageURL . "\" border=\"0\"/>"; } } ?>