| Line 163... |
Line 163... |
| 163 |
<td></td>
|
163 |
<td></td>
|
| 164 |
<td valign="top">
|
164 |
<td valign="top">
|
| 165 |
<!-- DETAILS ------------------------------------------------->
|
165 |
<!-- DETAILS ------------------------------------------------->
|
| 166 |
<br>
|
166 |
<br>
|
| 167 |
<span class="body_colb">Package Notification Details</span><br>
|
167 |
<span class="body_colb">Package Notification Details</span><br>
|
| 168 |
<table width="100%" border="0" cellspacing="1" cellpadding="3">
|
168 |
<table width="100%" border="0" cellspacing="1" cellpadding="3" class=stdGrey>
|
| - |
|
169 |
<thead>
|
| 169 |
<tr class="form_field_hdr">
|
170 |
<tr>
|
| 170 |
<td nowrap width="1%" >Who<%=Quick_Help("enabledUser")%> </td>
|
171 |
<th nowrap width="1%" >Who<%=Quick_Help("enabledUser")%> </th>
|
| 171 |
<td nowrap width="1%">Opr<%=Quick_Help("opr")%> </td>
|
172 |
<th nowrap width="1%">Opr<%=Quick_Help("opr")%> </th>
|
| 172 |
<td nowrap width="97%">Project </td>
|
173 |
<th nowrap width="97%">Project </th>
|
| 173 |
|
- |
|
| - |
|
174 |
</thead>
|
| 174 |
</tr>
|
175 |
</tr>
|
| 175 |
<%
|
176 |
<%
|
| 176 |
|
177 |
|
| 177 |
OraDatabase.Parameters.Add "PKG_ID", pkgInfoHash.Item("pkg_id"), ORAPARM_INPUT, ORATYPE_NUMBER
|
178 |
OraDatabase.Parameters.Add "PKG_ID", pkgInfoHash.Item("pkg_id"), ORAPARM_INPUT, ORATYPE_NUMBER
|
| 178 |
|
179 |
|
| 179 |
Set rsTemp = OraDatabase.DbCreateDynaset( "select pi.proj_id, p.PROJ_NAME, u.user_id, u.FULL_NAME, u.USER_EMAIL, u.IS_DISABLED from PACKAGE_INTEREST pi, PROJECTS p, USERS u where pi.USER_ID = u.USER_ID and p.PROJ_ID = pi.proj_id and pkg_id = :PKG_ID order by UPPER(PROJ_NAME), UPPER(FULL_NAME)", cint(0))
|
180 |
Set rsTemp = OraDatabase.DbCreateDynaset( "select pi.proj_id, p.PROJ_NAME, u.user_id, u.FULL_NAME, u.USER_EMAIL, u.IS_DISABLED from PACKAGE_INTEREST pi, PROJECTS p, USERS u where pi.USER_ID = u.USER_ID and p.PROJ_ID = pi.proj_id and pkg_id = :PKG_ID order by UPPER(PROJ_NAME), UPPER(FULL_NAME)", cint(0))
|
| 180 |
%>
|
181 |
%>
|
| 181 |
<%If rsTemp.RecordCount < 1 Then%>
|
182 |
<%If rsTemp.RecordCount < 1 Then%>
|
| 182 |
<tr class="form_item_grey" >
|
183 |
<tr>
|
| 183 |
<td nowrap> </td>
|
184 |
<td nowrap> </td>
|
| 184 |
<td nowrap> </td>
|
185 |
<td nowrap> </td>
|
| 185 |
<td nowrap> </td>
|
186 |
<td nowrap> </td>
|
| 186 |
<td nowrap> </td>
|
187 |
<td nowrap> </td>
|
| 187 |
</tr>
|
188 |
</tr>
|
| Line 200... |
Line 201... |
| 200 |
btnText = "Remove notifications to this user"
|
201 |
btnText = "Remove notifications to this user"
|
| 201 |
btnClass = "class=btn_delete"
|
202 |
btnClass = "class=btn_delete"
|
| 202 |
End If
|
203 |
End If
|
| 203 |
|
204 |
|
| 204 |
%>
|
205 |
%>
|
| 205 |
<tr class="form_item_grey" data-user_id="<%=rsTemp("user_id")%>" data-proj_id="<%=rsTemp("proj_id")%>" >
|
206 |
<tr data-user_id="<%=rsTemp("user_id")%>" data-proj_id="<%=rsTemp("proj_id")%>" >
|
| 206 |
<td nowrap valign="top"><%=emailField(userImage & rsTemp("FULL_NAME"),rsTemp("user_email"))%></td>
|
207 |
<td nowrap valign="top"><%=emailField(userImage & rsTemp("FULL_NAME"),rsTemp("user_email"))%></td>
|
| 207 |
<td nowrap valign="top" <%=btnClass%> title="<%=btnText%>"><%=DelUserImage%></td>
|
208 |
<td nowrap valign="top" <%=btnClass%> title="<%=btnText%>"><%=DelUserImage%></td>
|
| 208 |
<td nowrap valign="top"><a href="rtree.asp?proj_id=<%=rsTemp("PROJ_ID")%>"><%=rsTemp("PROJ_NAME")%></a></td>
|
209 |
<td nowrap valign="top"><a href="rtree.asp?proj_id=<%=rsTemp("PROJ_ID")%>"><%=rsTemp("PROJ_NAME")%></a></td>
|
| 209 |
</tr>
|
210 |
</tr>
|
| 210 |
<%rsTemp.MoveNext
|
211 |
<%rsTemp.MoveNext
|