organisations_table, "name", "id", "iOrganisationID"); $oPatternListBox->setPostBackOnChange(true); if ($iOrganisationID != 0) { $oPatternListBox->setSelectedValue($iOrganisationID); } return "

" . _("Filter By Organisation") . "

" . $oPatternListBox->render() . "

"; } function getUnits($iOrganisationID) { global $default; $aParams = array(); /*ok*/ $sQuery = "SELECT units_lookup.id as unitID, units_lookup.name as name, " . "'Edit', 'Delete', 'Edit Organisations', " . "CASE WHEN organisations_lookup.name Is Null THEN '* No Organisation' ELSE organisations_lookup.name END AS OrgName " . "FROM (units_lookup " . "LEFT JOIN units_organisations_link ON units_lookup.id = units_organisations_link.unit_id) " . "LEFT JOIN organisations_lookup ON units_organisations_link.organisation_id = organisations_lookup.id "; if ($iOrganisationID) { $sQuery .= "WHERE units_organisations_link.organisation_id = ? "; $aParams[] = $iOrganisationID; } $sQuery .= "ORDER BY units_lookup.name"; $aColumns = array("name", "OrgName", "Edit", "Delete");//, "Edit Organisations"); $aColumnNames = array(_("Unit Name"), _("Organisation"), _("Edit"), _("Delete"));//, "Edit Organisations"); $aColumnTypes = array(1,1,3,3);//,3); $aDBColumnArray = array("unitID"); $aQueryStringVariableNames = array("fUnitID"); $aHyperLinkURL = array( 2=> "$default->rootUrl/control.php?action=editUnit", 3=> "$default->rootUrl/control.php?action=removeUnit"); //4=> "$default->rootUrl/control.php?action=editUnitOrg"); $oSearchResults = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnNames, "100%", $aHyperLinkURL,$aDBColumnArray,$aQueryStringVariableNames); $oSearchResults->setDisplayColumnHeadings(true); return $oSearchResults->render() ; } function getPage($iOrganisationID) { global $default; $sToRender .= renderHeading(_("Unit Management")); $sToRender .= getAddLink("addUnit", _("Add A Unit")); //$sToRender .= getOrganisationDisplay($iOrganisationID); $sToRender .= getUnits($iOrganisationID); return $sToRender; } ?>