sQuery = $sNewQuery; $this->sTableName = $sNewTableName; $this->aDisplayColumns = $aNewDisplayColumns; $this->aStoreColumns = $aNewStoreColumns; $this->aColumnNames = $aNewColumnNames; $this->aDisplayColumnTypes = $aNewDisplayColumnTypes; $this->aDatabaseColumnTypes = $aNewDatabaseColumnTypes; } function setUniqueName($sNewValue) { $this->sUniqueName = $sNewValue; } function setTableWidth($iNewValue) { $this->iTableWidth = $iNewValue; } function setTextAreaRows($iNewValue) { $this->iTextAreaRows = $iNewValue; } function setTextAreaDisplayColumns($iNewValue) { $this->iTextAreaDisplayColumns = $iNewValue; } function setTableHeading($sNewValue) { $this->sTableHeading = $sNewValue; } function setRenderIndividualTableForEachResult($bNewValue) { $this->bIndividualTableForEachResult = $bNewValue; } function setDropDownListTableNames($aNewValue) { $this->aDropDownListTableNames = $aNewValue; } function setColumnsRequired($aNewValue) { $this->aColumnsRequired = $aNewValue; } function & render() { global $default; //records the columns to generate validation javascript for $aValidationColumnNames = array(); $sql = $default->db; $sql->query($this->sQuery); if ($sql->next_record()) {; $sToRender = ""; $sToRender .= "iTableWidth) ? ", width = $this->iTableWidth" : "") . " >\n"; $sToRender .= "sUniqueName . "\" value=\"\" />\n"; $sToRender .= "sUniqueName\" value=\"" . $sql->f("id") . "\" />\n"; $sToRender .= "sUniqueName . "_tn\" value=\"$this->sTableName\" />\n"; if (isset($this->sTableHeading)) { $sToRender .= "\n"; } for ($i = 0; $i < count($this->aDisplayColumns); $i++) { $sToRender .= "\n"; $sToRender .= "sUniqueName . "_" . $i . "_tc\" value=\"" . $this->aStoreColumns[$i] . "\" />\n"; $sToRender .= "sUniqueName . "_" . $i . "_type\" value=\"" . $this->aDatabaseColumnTypes[$i] . "\" />\n"; $sToRender .= "\t\n"; switch ($this->aDisplayColumnTypes[$i]) { case 1: //plain text field $sToRender .= "\t\n"; break; case 2: //boolean value $sToRender .= "\t\n"; break; case 3: $oPatternListBox = & new PatternListBox($this->aDropDownListTableNames[$i], "name", "id", $this->sUniqueName . "_" . $i . "_value"); $oPatternListBox->setSelectedValue($sql->f($this->aStoreColumns[$i])); $sToRender .= "\t\t\n"; break; default: break; } $sToRender .= "\n"; //check for required columns if (isset($this->aColumnsRequired) &&($this->aColumnsRequired[$i])) { $iArrayEntry = count($aValidationColumnNames); $aValidationColumnNames[$iArrayEntry]["formName"] = $this->sUniqueName . "_" . $i . "_value"; $aValidationColumnNames[$iArrayEntry]["displayName"] = $this->aColumnNames[$i]; } } $sToRender .= "sUniqueName . "\" value=\"\" />\n"; $sToRender .= "

$this->sTableHeading

" . $this->aColumnNames[$i] . "

sUniqueName . "_" . $i . "_value\" value=\"" . stripslashes($sql->f($this->aDisplayColumns[$i])) . "\"

sUniqueName . "_" . $i . "_value\" value=\"1\" " . ($sql->f($this->aDisplayColumns[$i]) ? " CHECKED " : " ") . "/>

" . $oPatternListBox->render() . "

\n"; } else { $sToRender .= "\n"; $sToRender .= "No " . (isset($this->sTableHeading) ? "$this->sTableHeading" : "") . " data\n"; $sToRender .= "\n"; } $sToRender .= $this->generateRequiredFieldValidation($aValidationColumnNames); return $sToRender; } function generateRequiredFieldValidation($aValidationColumnNames) { $sToRender .= "\n\n\n\n"; return $sToRender; } } ?>