Subversion Repositories DevTools

Rev

Rev 6783 | Rev 6873 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6783 Rev 6790
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")%>&nbsp;</td>
171
                                <th nowrap width="1%" >Who<%=Quick_Help("enabledUser")%>&nbsp;</th>
171
                            <td nowrap width="1%">Opr<%=Quick_Help("opr")%>&nbsp;&nbsp;</td>
172
                                <th nowrap width="1%">Opr<%=Quick_Help("opr")%>&nbsp;&nbsp;</th>
172
                            <td nowrap width="97%">Project&nbsp;&nbsp;</td>
173
                                <th nowrap width="97%">Project&nbsp;&nbsp;</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>&nbsp;</td>
184
                            <td nowrap>&nbsp;</td>
184
                            <td nowrap>&nbsp;</td>
185
                            <td nowrap>&nbsp;</td>
185
                            <td nowrap>&nbsp;</td>
186
                            <td nowrap>&nbsp;</td>
186
                            <td nowrap>&nbsp;</td>
187
                            <td nowrap>&nbsp;</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