editUI.inc
3.92 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
<?php
/**
* Presentation information used for folder editing. Used by editBL.php
*
* @author Rob Cherry, Jam Warehouse (Pty) Ltd, South Africa
* @date 2 February 2003
* @package presentation.lookAndFeel.knowledgeTree.foldermanagement
*
*/
function getFolderPath($iFolderID) {
global $default;
return displayFolderPathLink(Folder::getFolderPathAsArray($iFolderID), Folder::getFolderPathNamesAsArray($iFolderID), "$default->rootUrl/control.php?action=browse");
}
function getFolderData($iFolderID) {
global $default;
$sQuery = "SELECT F.id, F.name AS folder_name, F.description, F.document_type_id, DTL.name AS document_type_name, F.is_public " .
"FROM $default->owl_folders_table AS F LEFT OUTER JOIN $default->owl_document_types_table AS DTL ON F.document_type_id = DTL.ID " .
"WHERE F.id = $iFolderID";
$aDisplayColumns = array("folder_name", "description", "document_type_name", "is_public");
$aStoreColumns = array("name", "description" , "document_type_id", "is_public");
$aColumnNames = array("Name", "Description", "Document type", "Public");
$aDisplayColumnTypes = array(1,1,3,2);
$aDatabaseColumnTypes = array(1,1,0,2);
$aDropDownListTableNames = array(2 => "$default->owl_document_types_table");
$oPatternEditableListFromQuery = & new PatternEditableListFromQuery($sQuery, $default->owl_folders_table, $aDisplayColumns, $aStoreColumns, $aColumnNames, $aDisplayColumnTypes, $aDatabaseColumnTypes);
$oPatternEditableListFromQuery->setUniqueName("folderEdit");
$oPatternEditableListFromQuery->setDropDownListTableNames($aDropDownListTableNames);
$oPatternEditableListFromQuery->setColumnsRequired(array(1,0,1,0));
return $oPatternEditableListFromQuery->render();
}
function getFolderRouting($iFolderID) {
global $default;
$sQuery = "SELECT GFAL.id as id, GFAL.folder_id AS folder_id, G.name AS group_name, R.name AS role_name, GFAL.precedence AS precedence, 'Edit' as edit, 'Delete' as del " .
"FROM $default->owl_groups_folders_approval_table AS GFAL INNER JOIN roles AS R ON GFAL.role_id = R.id " .
"INNER JOIN $default->owl_groups_table AS G ON G.id = GFAL.group_id " .
"WHERE GFAL.folder_id = $iFolderID " .
"ORDER BY GFAL.precedence, role_name ASC";
$aColumns = array("group_name", "role_name", "precedence", "edit", "del");
$aColumnHeaders = array("Group", "Role", "Seq", "", "");
$aColumnTypes = array(1,1,1,3,3);
$aDBColumnArray = array("id","folder_id");
$aQueryStringVariableNames = array("fFolderCollaborationID", "fFolderID");
$aLinkURLs = array(3=>"$default->rootUrl/control.php?action=modifyFolderCollaboration",4=>"$default->rootUrl/control.php?action=deleteFolderCollaboration");
$oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "90%", $aLinkURLs, $aDBColumnArray,$aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Document Routing");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
return $oPatternTableSqlQuery->render();
}
function getPage($iFolderID) {
global $default;
$sToRender = "<table border=\"1\" width=\"100%\"><tr><td>" . getFolderPath($iFolderID) . "</td></tr></table>\n";
$sToRender .= "<table border =\"0\">\n";
$sToRender .= "<tr>\n";
$sToRender .= "<td>" . wrapInTable(getFolderData($iFolderID)) . "</td>\n";
$sToRender .= "</tr>\n";
$sToRender .= "<tr>\n";
$sToRender .= "<td>" . wrapInTable(getFolderRouting($iFolderID)) . "</td>\n";
$sToRender .= "</tr>\n";
$sToRender .= "<tr>\n";
$sToRender .= "<td><table><tr><td><input type=\"image\" src=\"$default->graphicsUrl/widgets/update.gif\" border=\"0\" /></td><td><a href=\"$default->rootUrl/control.php?action=addFolderCollaboration&fFolderID=$iFolderID\"><img src=\"$default->graphicsUrl/widgets/add.gif\" border=\"0\" /></a></td></tr></table></td>\n"; $sToRender .= "</tr>\n";
$sToRender .= "</table>\n";
return $sToRender;
}
function wrapInTable($sHtml) {
return "\n\t\t\t<table border = 1, width = 100%><tr><td>$sHtml</td></tr></table>\n";
}
?>