addUserToGroupUI.inc
7.09 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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
<?php
/**
* Presentation information for adding a User
*
* @author Mukhtar Dharsey
* @date 5 February 2003
* @package presentation.lookAndFeel.knowledgeTree.
*
*/
// gets main page
function getPage($iUserID, $iGroupID) {
global $default;
$oUser = null;
$oGroup = null;
if (isset($iUserID)) {
$oUser = User::get($iUserID);
}
if (isset($iGroupID)) {
$oGroup = Group::get($iGroupID);
$heading = "<tr><td colspan=\"2\">Please confirm your choice by clicking 'Assign', or 'Cancel' to abort.</td></tr>\n";
} else {
$heading = "<tr><td colspan=\"2\">Please choose the Group to assign to this user.</td></tr>\n";
}
$sQueryString = "&fUserID=$iUserID";
$sToRender .= renderHeading("Add User to Group");
$sToRender .= "<table>\n";
$sToRender .= $heading;
$sToRender .= "<tr>\n";
$sToRender .= "</tr>\n";
$sToRender .= "<td>User Name: </td><td><input type=hidden id=\"fUserID\" name=\"fUserID\" value=\"" . $oUser->getID() . "\">" . $oUser->getName() . "</a></td>\n";
$sToRender .= "<tr>\n";
$sToRender .= "</tr>\n";
$sToRender .= "<tr>\n";
$sToRender .= "<td>Group Name: </td><td>" . getGroupDisplay($oGroup) . "</td>\n";
$sToRender .= "</tr>\n";
$sToRender .= "<tr>\n";
$sToRender .= "</tr>\n";
$sToRender .= "<tr>\n";
$sToRender .= "</tr>\n";
$sToRender .= "<td></td><td>" . getAssignButton($oUser);
$sToRender .= "<td><a href=\"$default->rootUrl/control.php?action=editUserGroups$sQueryString\"><img src =\"$default->graphicsUrl/widgets/cancel.gif\" border = \"0\" /></a></td>";
$sToRender .= "</td></table>\n";
return $sToRender;
}
// page that comes up when there is nothing selected
function getPageNotSelected($sQueryString) {
global $default;
$sToRender .= renderHeading("Add User to Group");
$sToRender .= "<table>\n";
$sToRender .= "<tr><td><b>Sorry, Selection Failed</b></td></tr>\n";
$sToRender .= "<tr><td>Please select Group</td></tr>\n";
$sToRender .= "<tr></tr>\n";
$sToRender .= "<tr></tr>\n";
$sToRender .= "<tr>\n";
$sToRender .= "<td></td><td align = right><a href=\"$default->rootUrl/control.php?action=addUserToGroup$sQueryString\"><img src =\"$default->graphicsUrl/widgets/back.gif\" border = \"0\" /></a></td>\n";
$sToRender .= "</tr>\n";
$sToRender .= "</table>\n";
return $sToRender;
}
//if addition successful
function getPageSuccess($sQueryString) {
global $default;
$sToRender .= renderHeading("Add User to Group");
$sToRender .= "<table>\n";
$sToRender .= "<tr><td><b>Success!</b></td></tr>\n";
$sToRender .= "<tr><td>The User was successfully assigned to the specified Group</td></tr>\n";
$sToRender .= "<tr></tr>\n";
$sToRender .= "<tr></tr>\n";
$sToRender .= "<tr>\n";
$sToRender .= "<td></td><td align = right><a href=\"$default->rootUrl/control.php?action=addUserToGroup$sQueryString\"><img src =\"$default->graphicsUrl/widgets/back.gif\" border = \"0\" /></a></td>\n";
$sToRender .= "</tr>\n";
$sToRender .= "</table>\n";
return $sToRender;
}
//if edition successful
function getPageFail($sQueryString) {
global $default;
$sToRender .= "<table border=\"0\" width=\"600\">" . renderHeading("Add User to Group");
$sToRender .= "<table>\n";
$sToRender .= "<tr><td><b>Failed!</b></td></tr>\n";
$sToRender .= "<tr><td>The User already belongs to the specified Group</td></tr>\n";
$sToRender .= "<tr></tr>\n";
$sToRender .= "<tr></tr>\n";
$sToRender .= "<tr>\n";
$sToRender .= "<td></td><td align = right><a href=\"$default->rootUrl/control.php?action=addUserToGroup$sQueryString\"><img src =\"$default->graphicsUrl/widgets/back.gif\" border = \"0\" /></a></td>\n";
$sToRender .= "</tr>\n";
$sToRender .= "</table>\n";
return $sToRender;
}
// display the listbox initially ..then just display the text
function getUserDisplay($oUser) {
global $default;
if (!isset($oUser)) {
$oPatternListBox = & new PatternListBox($default->owl_users_table, "username", "id", "fUserID");
if (Permission::userIsUnitAdministrator() && !Permission::userIsSystemAdministrator()) {
$oPatternListBox->setFromClause("INNER JOIN $default->owl_users_groups_table UGL ON ST.id=UGL.user_id " .
"INNER JOIN $default->owl_groups_units_table GUL ON UGL.group_id=GUL.group_id");
$oPatternListBox->setWhereClause("GUL.unit_id=" . User::getUnitID($_SESSION["userID"]));
$oUnassignedUsersLB = & new PatternListBox($default->owl_users_table, "username", "id", "fUserID");
$oUnassignedUsersLB->setFromClause("LEFT OUTER JOIN $default->owl_users_groups_table UGL ON ST.id=UGL.user_id");
$oUnassignedUsersLB->setWhereClause("ISNULL(UGL.group_id)");
$oPatternListBox->setAdditionalEntries($oUnassignedUsersLB->getEntries());
}
return $oPatternListBox->render();
} else {
return "<input type=\"hidden\" name=\"fUserID\" value=\"" . $oUser->iId . "\">\n" .
$oUser->getUserName();
}
}
// display the listbox initially ..then just display the text
function getGroupDisplay($oGroup) {
global $default;
if (!isset($oGroup)) {
if (Permission::userIsSystemAdministrator()) {
// if this is the system administrator, prepend group names with unit name
$oPatternListBox = & new PatternListBox($default->owl_groups_table, "name", "id", "fGroupID");
$oPatternListBox->setFromClause("LEFT OUTER JOIN groups_units_link GUL on ST.id=GUL.group_id " .
"LEFT OUTER JOIN units_lookup UL on GUL.unit_id=UL.id");
$oPatternListBox->setCompositeDisplayName("DISTINCT COALESCE(CONCAT(CONCAT(UL.name, '-'),ST.name),ST.name)");
} else if (Permission::userIsUnitAdministrator()) {
// else if this is a unit administrator, only display the groups in your unit
$oPatternListBox = & new PatternListBox($default->owl_groups_table, "name", "id", "fGroupID");
$oPatternListBox->setFromClause("INNER JOIN $default->owl_groups_units_table GUL on ST.id=GUL.group_id");
$oPatternListBox->setWhereClause("GUL.unit_id=" . User::getUnitID($_SESSION["userID"]));
}
return $oPatternListBox->render();
} else {
return "<input type=\"hidden\" name=\"fGroupID\" value=\"" . $oGroup->iId . "\">\n" .
$oGroup->getName();
}
}
// show button after User selected
function getAssignButton($oUser) {
global $default;
if (!isset($oUser)) {
return "<td align = right><input type=\"image\" src =\"$default->graphicsUrl/widgets/select.gif\" value=\"submit\" border=\"0\"/></td>\n";
} else {
return "<td align = right><input type=\"image\" src =\"$default->graphicsUrl/widgets/assign.gif\" value=\"submit\" border=\"0\"/></td>\n";
}
}
// show button after User selected
function getCancelButton($oUser) {
global $default;
if (!isset($oUser)) {
return "<td align = right><a href=\"$default->rootUrl/control.php?action=userManagement\"><img src =\"$default->graphicsUrl/widgets/cancel.gif\" value=\"cancel\" border=\"0\"/></a></td>\n";
} else {
return "<td align = right><a href=\"$default->rootUrl/control.php?action=addUserToGroup\"><img src =\"$default->graphicsUrl/widgets/cancel.gif\" border=\"0\" /></a></td>\n";
}
}
?>