owl_groups_table", "name", "id", "fGroupID"); $oPatternListBox->setPostBackOnChange(true); $sOnChangeAction = $_SERVER["PHP_SELF"] . "?fForFilter=1&fDocumentRoutingID=$iDocumentRoutingID&fDocumentID=$fDocumentID"; $oPatternListBox->setOnChangeAction("setActionAndSubmit('$sOnChangeAction')"); if (isset($_POST["fGroupID"])) { $oPatternListBox->setSelectedValue($_POST["fGroupID"]); } $oPatternListBox->setEmptyErrorMessage("There are no groups"); return $oPatternListBox->render(); } function getUserDropDown() { global $_GET, $_POST, $default; $oPatternListBox = & new PatternListBox("$default->owl_users_table", "name", "id", "fUserID"); if (isset($_GET["fForFilter"])) { $sFromClause = "INNER JOIN $default->owl_users_groups_table AS UGL ON ST.id = UGL.user_id "; $oPatternListBox->setFromClause($sFromClause); $sWhereClause = "UGL.group_id = " . $_POST["fGroupID"]; $oPatternListBox->setWhereClause($sWhereClause); } $oPatternListBox->setEmptyErrorMessage("There are no users in this group"); return $oPatternListBox->render(); } function getRoleDropDown() { global $default; $oPatternListBox = & new PatternListBox("$default->owl_roles_table", "name", "id", "fRole"); $oPatternListBox->setEmptyErrorMessage("There are no users in this group"); return $oPatternListBox->render(); } function getDocumentRoutingPage($oDocumentRouting, $fDocumentID) { global $default; return "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "
Edit document routing information
Group".getGroupDropDown(1, 1)."
User".getUserDropDown()."
Role".getRoleDropDown()."
Seq. no.
 
owl_root_url/control.php?action=viewDocument&fDocumentID=$fDocumentID \">Cancel
\n"; } /*function getRoutingRow($iSequenceValue, $iIndex) { $sToRender = "\n"; $sToRender .= "\t" . renderGroupDropDown($iIndex) . "\n"; $sToRender .= "\t" . renderUserDropDown($iIndex) . "\n"; $sToRender .= "\t" . renderRoleDropDown($iIndex) . "\n"; $sToRender .= "\t\n"; $sToRender .= "\n"; return $sToRender; } function something($fDocumentID) { $sQuery = "SELECT GFAL.id, R.name AS role_name, COALESCE(U.Name, 'Not assigned') AS name, GFAL.precedence AS precedence " . "FROM documents AS D INNER JOIN groups_folders_approval_link AS GFAL ON D.folder_id = GFAL.folder_id " . "INNER JOIN roles AS R ON GFAL.role_id = R.id " . "LEFT OUTER JOIN folders_users_roles_link AS FURL ON FURL.folder_id = D.folder_id " . "LEFT OUTER JOIN users AS U ON FURL.user_id = U.id " . "WHERE D.id = $fDocumentID " . "ORDER BY GFAL.precedence, role_name ASC"; $sql = new Owl_DB(); $sql->query($sQuery); $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $iIndex = 0; while ($sql->next_record()) { $sToRender .= getRoutingRow($sql->f("id"), $sql->f("precedence")); $iIndex++; } $sToRender .= "
GroupUserRoleSequence no.
\n"; return $sToRender; } function getPage($fSelectedGroupID, $iSequenceValue, $iIndex) { $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; for ($i = 0; $i < 5; $i++) { $sToRender .= getRoutingRow($fSelectedGroupID, $iSequenceValue, $i); } $sToRender .= "
GroupUserSequence no.
\n"; }*/ ?>