Subversion Repositories DevTools

Rev

Rev 5271 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5271 Rev 5357
Line 1... Line 1...
1 
<%@LANGUAGE="VBSCRIPT"%>
 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
 2 
<%
3 
'=====================================================
 3 
'=====================================================
4 
'|                                                   |
 4 
'|                                                   |
5 
'|				    	MEMBERS					     |
 5 
'|				    	MEMBERS					     |
6 
'|        NOTIFICATIONS - My Packages              	 |
 6 
'|        NOTIFICATIONS - My Packages              	 |
7 
'=====================================================
 7 
'=====================================================
8 
%>
 8 
%>
9 
<%
 9 
<%
10 
Option explicit
 10 
Option explicit
11 
' Good idea to set when using redirect
 11 
' Good idea to set when using redirect
12 
Response.Expires = 0	' always load the page, dont store
 12 
Response.Expires = 0	' always load the page, dont store
13 
%>
 13 
%>
14 
<!--#include file="common/conf.asp"-->
 14 
<!--#include file="common/conf.asp"-->
15 
<!--#include file="common/globals.asp"-->
 15 
<!--#include file="common/globals.asp"-->
16 
<!--#include file="common/formating.asp"-->
 16 
<!--#include file="common/formating.asp"-->
17 
<!--#include file="common/qstr.asp"-->
 17 
<!--#include file="common/qstr.asp"-->
18 
<!--#include file="common/common_subs.asp"-->
 18 
<!--#include file="common/common_subs.asp"-->
19 
<!--#include file="common/_form_window_common.asp"-->
 19 
<!--#include file="common/_form_window_common.asp"-->
20 
<%
 20 
<%
21 
'------------ ACCESS CONTROL ------------------
 21 
'------------ ACCESS CONTROL ------------------
22 
%>
 22 
%>
23 
<!--#include file="_access_control_login.asp"-->
 23 
<!--#include file="_access_control_login.asp"-->
24 
<!--#include file="_access_control_general.asp"-->
 24 
<!--#include file="_access_control_general.asp"-->
25 
<%
 25 
<%
26 
'------------ Variable Definition -------------
 26 
'------------ Variable Definition -------------
27 
Dim rsTemp
 27 
Dim rsTemp
28 
Dim parProjId
 28 
Dim parProjId
29 
'------------ Constants Declaration -----------
 29 
'------------ Constants Declaration -----------
30 
'------------ Variable Init -------------------
 30 
'------------ Variable Init -------------------
31 
parProjId = Request("proj_id")
 31 
parProjId = Request("proj_id")
32 
objPMod.PersistInQryString("proj_id")
 32 
objPMod.PersistInQryString("proj_id")
33 
If parProjId = "" then parProjId = 0
 33 
If parProjId = "" then parProjId = 0
34 
'----------------------------------------------
 34 
'----------------------------------------------
35 
 
 35 
 
36 
Function NoSpace( txt )
 36 
Function NoSpace( txt )
37 
    NoSpace = Replace( txt, " ", "&nbsp;")
 37 
    NoSpace = Replace( txt, " ", "&nbsp;")
38 
End Function
 38 
End Function
39 
 
 39 
 
40 
Function Get_My_Packages ( NNuser_id )
 40 
Function Get_My_Packages ( NNuser_id )
41 
	Get_My_Packages = _
 41 
	Get_My_Packages = _
42 
	" SELECT rc.rtag_id, pv.pv_id, pkg.pkg_name, pv.pkg_version, proj.proj_name, rt.rtag_name, pkg.pkg_id "&_
 42 
	" SELECT rc.rtag_id, pv.pv_id, pkg.pkg_name, pv.pkg_version, proj.proj_name, rt.rtag_name, pkg.pkg_id "&_
43 
	"  FROM packages pkg,"&_
 43 
	"  FROM packages pkg,"&_
44 
	"       package_versions pv, "&_
 44 
	"       package_versions pv, "&_
45 
	"       release_content rc,"&_
 45 
	"       release_content rc,"&_
46 
	"       release_tags rt,"&_
 46 
	"       release_tags rt,"&_
47 
	"       projects proj"&_
 47 
	"       projects proj"&_
48 
	" WHERE pv.pkg_id = pkg.pkg_id"&_
 48 
	" WHERE pv.pkg_id = pkg.pkg_id"&_
49 
	"   AND rc.pv_id = pv.pv_id"&_
 49 
	"   AND rc.pv_id = pv.pv_id"&_
50 
	"   AND rc.rtag_id = rt.rtag_id"&_
 50 
	"   AND rc.rtag_id = rt.rtag_id"&_
51 
	"   AND rt.proj_id = proj.proj_id "&_
 51 
	"   AND rt.proj_id = proj.proj_id "&_
52 
	"   AND rt.official not in ( 'A', 'P', 'Y', 'O') "&_
 52 
	"   AND rt.official not in ( 'A', 'P', 'Y', 'O') "&_
53 
    "   AND rc.sdktag_id is NULL" &_
 53 
    "   AND rc.sdktag_id is NULL" &_
54 
	"   AND pv.owner_id = "& NNuser_id &_
 54 
	"   AND pv.owner_id = "& NNuser_id &_
55 
	" ORDER BY UPPER(pkg.pkg_name),UPPER(pv.pkg_version), UPPER(proj.proj_name), UPPER(rt.rtag_name) "
 55 
	" ORDER BY UPPER(pkg.pkg_name),UPPER(pv.pkg_version), UPPER(proj.proj_name), UPPER(rt.rtag_name) "
56 
End Function
 56 
End Function
57 
%>
 57 
%>
58 
<html>
 58 
<html>
59 
<head>
 59 
<head>
60 
<title>Release Manager</title>
 60 
<title>Release Manager</title>
61 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
 61 
<link rel="shortcut icon" href="<%=FavIcon%>"/>
62 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 62 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
63 
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
 63 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
64 
<link rel="stylesheet" href="images/navigation.css" type="text/css">
 64 
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
65 
<script language="JavaScript" src="images/common.js"></script>
 65 
<link rel="stylesheet" href="images/navigation.css" type="text/css">
66 
<script language="javascript">
 66 
<script language="JavaScript" src="images/common.js"></script>
67 
<!--
 67 
<script language="javascript">
68 
function checkUncheckAll(theElement) {
 68 
<!--
69 
     var theForm = theElement.form, z = 0;
 69 
function checkUncheckAll(theElement) {
70 
	 for(z=0; z<theForm.length;z++){
 70 
     var theForm = theElement.form, z = 0;
71 
      if(theForm[z].type == 'checkbox' && theForm[z].name != 'checkall' && theForm[z].disabled != true){
 71 
	 for(z=0; z<theForm.length;z++){
72 
	  theForm[z].checked = theElement.checked;
 72 
      if(theForm[z].type == 'checkbox' && theForm[z].name != 'checkall' && theForm[z].disabled != true){
73 
	  }
 73 
	  theForm[z].checked = theElement.checked;
74 
     }
 74 
	  }
75 
    }
 75 
     }
76 
//-->
 76 
    }
77 
</script>
 77 
//-->
78 
</head>
 78 
</script>
79 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
 79 
</head>
80 
<!-- TIPS LAYERS -------------------------------------->
 80 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
81 
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10">&nbsp;</div>
 81 
<!-- TIPS LAYERS -------------------------------------->
82 
<!----------------------------------------------------->
 82 
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10">&nbsp;</div>
83 
<!-- HEADER -->
 83 
<!----------------------------------------------------->
84 
<!--#include file="_header.asp"-->
 84 
<!-- HEADER -->
85 
<!-- BODY ---->
 85 
<!--#include file="_header.asp"-->
86 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
 86 
<!-- BODY ---->
87 
  <tr>
 87 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
88 
    <td width="1%" background="images/bg_member_dark.gif" valign="top">
 88 
  <tr>
89 
      <!-- MEMBERS MENU ---------------------------------------------->
 89 
    <td width="1%" background="images/bg_member_dark.gif" valign="top">
90 
	  <!--#include file="members_menu_def.asp"-->
 90 
      <!-- MEMBERS MENU ---------------------------------------------->
91 
	  <%Call Member_Menu( "notifications" )%>
 91 
	  <!--#include file="members_menu_def.asp"-->
92 
      <!--  MEMBERS MENU END ------------------------------------------>
 92 
	  <%Call Member_Menu( "notifications" )%>
93 
    </td>
 93 
      <!--  MEMBERS MENU END ------------------------------------------>
94 
    <td width="1%" valign="top" background="images/bg_member_light.gif"><a href="index.asp" class="form_txt_link"><img src="images/i_home.gif" width="13" height="12" border="0" align="absmiddle">Exit</a></td>
 94 
    </td>
95 
    <td rowspan="2" valign="top" width="1%" background="images/bg_member_light.gif" nowrap>
 95 
    <td width="1%" valign="top" background="images/bg_member_light.gif"><a href="index.asp" class="form_txt_link"><img src="images/i_home.gif" width="13" height="12" border="0" align="absmiddle">Exit</a></td>
96 
      <!------------------------------------------->
 96 
    <td rowspan="2" valign="top" width="1%" background="images/bg_member_light.gif" nowrap>
97 
      <br>
 97 
      <!------------------------------------------->
98 
      <span class="mmb_ttl">Owner Notifications</span><br>
 98 
      <br>
99 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
 99 
      <span class="mmb_ttl">Owner Notifications</span><br>
100 
	  <form name="changeowner" method="post" action="members_change_owner.asp">
 100 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
101 
        <tr>
 101 
	  <form name="changeowner" method="post" action="members_change_owner.asp">
102 
          <td width="1%">&nbsp;</td>
 102 
        <tr>
103 
          <td align="right"><img src="images/h_trsp_dot.gif" width="500" height="30"></td>
 103 
          <td width="1%">&nbsp;</td>
104 
          <td width="1%">&nbsp;</td>
 104 
          <td align="right"><img src="images/h_trsp_dot.gif" width="500" height="30"></td>
105 
        </tr>
 105 
          <td width="1%">&nbsp;</td>
106 
        <tr>
 106 
        </tr>
107 
          <td align="left" valign="top" width="1%" background="images/bg_member_dark.gif"><img src="images/h_trsp_dot.gif" width="13" height="13"></td>
 107 
        <tr>
108 
            <td background="images/bg_member_dark.gif" align="left" class="wform_ttl">&nbsp;</td>
 108 
          <td align="left" valign="top" width="1%" background="images/bg_member_dark.gif"><img src="images/h_trsp_dot.gif" width="13" height="13"></td>
109 
          <td align="right" valign="top" width="1%" background="images/bg_member_dark.gif">&nbsp;</td>
 109 
            <td background="images/bg_member_dark.gif" align="left" class="wform_ttl">&nbsp;</td>
110 
        </tr>
 110 
          <td align="right" valign="top" width="1%" background="images/bg_member_dark.gif">&nbsp;</td>
111 
        <tr>
 111 
        </tr>
112 
          <td width="1%" bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="100"></td>
 112 
        <tr>
113 
          <td bgcolor="#FFFFFF" valign="top" class="form_item"> <br>
 113 
          <td width="1%" bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="100"></td>
114 
              You are currently the owner of the following packages. <br>
 114 
          <td bgcolor="#FFFFFF" valign="top" class="form_item"> <br>
115 
              NOTE: You will be notified when your package is ready to be build.<br>
 115 
              You are currently the owner of the following packages. <br>
116 
              <br>
 116 
              NOTE: You will be notified when your package is ready to be build.<br>
117 
              <table width="100%" border="0" cellspacing="1" cellpadding="2">
 117 
              <br>
118 
                <tr>
 118 
              <table width="100%" border="0" cellspacing="1" cellpadding="2">
119 
                  <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"><INPUT type=checkbox name="checkall" value="Check All" onClick="checkUncheckAll(this);"></td>
 119 
                <tr>
120 
                  <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Package Name and Version&nbsp;</td>
 120 
                  <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"><INPUT type=checkbox name="checkall" value="Check All" onClick="checkUncheckAll(this);"></td>
121 
                  <td background="images/bg_form_lightbluedark.gif" class="form_field">Location</td>
 121 
                  <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Package Name and Version&nbsp;</td>
122 
                </tr>
 122 
                  <td background="images/bg_form_lightbluedark.gif" class="form_field">Location</td>
123 
				<%
 123 
                </tr>
124 
				Dim currPv_id
 124 
				<%
125 
				currPv_id = -1
 125 
				Dim currPv_id
126 
				Set rsTemp = OraDatabase.DbCreateDynaset( Get_My_Packages( objAccessControl.UserId ), cint(0))
 126 
				currPv_id = -1
127 
			    While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
 127 
				Set rsTemp = OraDatabase.DbCreateDynaset( Get_My_Packages( objAccessControl.UserId ), cint(0))
128 
				%>
 128 
			    While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
129 
				<%If CStr( currPv_id ) <> CStr(rsTemp("pv_id")) Then%>
 129 
				%>
130 
                <tr>
 130 
				<%If CStr( currPv_id ) <> CStr(rsTemp("pv_id")) Then%>
131 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><input type="checkbox" name="pv_list" value="<%=rsTemp("pv_id")%>"></td>
 131 
                <tr>
132 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><a href="dependencies.asp?pv_id=<%=rsTemp("pv_id")%>&rtag_id=<%=rsTemp("rtag_id")%>" class="txt_linked"><%=NoSpace(rsTemp("pkg_name") &"&nbsp;"& rsTemp("pkg_version"))%></a></td>
 132 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><input type="checkbox" name="pv_list" value="<%=rsTemp("pv_id")%>"></td>
133 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><%=NoSpace(rsTemp("proj_name") &" &gt; "& rsTemp("rtag_name"))%></td>
 133 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><a href="dependencies.asp?pv_id=<%=rsTemp("pv_id")%>&rtag_id=<%=rsTemp("rtag_id")%>" class="txt_linked"><%=NoSpace(rsTemp("pkg_name") &"&nbsp;"& rsTemp("pkg_version"))%></a></td>
134 
                </tr>
 134 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><%=NoSpace(rsTemp("proj_name") &" &gt; "& rsTemp("rtag_name"))%></td>
135 
				<%currPv_id = rsTemp("pv_id")%>
 135 
                </tr>
136 
				<%Else%>
 136 
				<%currPv_id = rsTemp("pv_id")%>
137 
				<tr>
 137 
				<%Else%>
138 
                  <td background="images/bg_form_lightgray.gif" class="form_item"></td>
 138 
				<tr>
139 
                  <td background="images/bg_form_lightgray.gif" class="form_item"></td>
 139 
                  <td background="images/bg_form_lightgray.gif" class="form_item"></td>
140 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><%=NoSpace(rsTemp("proj_name") &" &gt; "& rsTemp("rtag_name"))%></td>
 140 
                  <td background="images/bg_form_lightgray.gif" class="form_item"></td>
141 
                </tr>
 141 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><%=NoSpace(rsTemp("proj_name") &" &gt; "& rsTemp("rtag_name"))%></td>
142 
				<%End If%>
 142 
                </tr>
143 
				<%rsTemp.MoveNext
 143 
				<%End If%>
144 
	    	    WEnd%>
 144 
				<%rsTemp.MoveNext
145 
				<%If rsTemp.RecordCount = 0 Then%>
 145 
	    	    WEnd%>
146 
				<tr>
 146 
				<%If rsTemp.RecordCount = 0 Then%>
147 
                  <td background="images/bg_form_lightgray.gif" class="form_item" colspan="3">You do not own any packages.</td>
 147 
				<tr>
148 
                </tr>
 148 
                  <td background="images/bg_form_lightgray.gif" class="form_item" colspan="3">You do not own any packages.</td>
149 
				<%End If%>
 149 
                </tr>
150 
              </table>
 150 
				<%End If%>
151 
              <p>                <%If rsTemp.RecordCount <> 0 Then%>
 151 
              </table>
152 
                <input name="Submit" type="submit" class="form_btn" value="Change Owner">
 152 
              <p>                <%If rsTemp.RecordCount <> 0 Then%>
153 
                <%End If%>
 153 
                <input name="Submit" type="submit" class="form_btn" value="Change Owner">
154 
			    </p>
 154 
                <%End If%>
155 
              <p>&nbsp;</p>
 155 
			    </p>
156 
 
 156 
              <p>&nbsp;</p>
157 
			  </form>
 157 
 
158 
      </table>
 158 
			  </form>
159 
      <!-------------------------------------------------------->
 159 
      </table>
160 
    </td>
 160 
      <!-------------------------------------------------------->
161 
    <td rowspan="2" valign="bottom" width="100%" background="images/bg_member_light.gif" align="right"><img src="images/bg_img_view.gif" width="249" height="144" vspace="10" hspace="10"></td>
 161 
    </td>
162 
  </tr>
 162 
    <td rowspan="2" valign="bottom" width="100%" background="images/bg_member_light.gif" align="right"><img src="images/bg_img_view.gif" width="249" height="144" vspace="10" hspace="10"></td>
163 
  <tr>
 163 
  </tr>
164 
    <td valign="bottom" align="center" background="images/bg_member_dark.gif"><img src="images/img_members.gif" width="81" height="57" vspace="20" hspace="30"></td>
 164 
  <tr>
165 
    <td background="images/bg_member_light.gif" valign="top"><img src="images/h_trsp_dot.gif" width="100" height="400"></td>
 165 
    <td valign="bottom" align="center" background="images/bg_member_dark.gif"><img src="images/img_members.gif" width="81" height="57" vspace="20" hspace="30"></td>
166 
  </tr>
 166 
    <td background="images/bg_member_light.gif" valign="top"><img src="images/h_trsp_dot.gif" width="100" height="400"></td>
167 
</table>
 167 
  </tr>
168 
<!-- FOOTER -->
 168 
</table>
169 
<!--#include file="_footer.asp"-->
 169 
<!-- FOOTER -->
170 
</body>
 170 
<!--#include file="_footer.asp"-->
171 
</html>
 171 
</body>
172 
<%
 172 
</html>
173 
Call Destroy_All_Objects
 173 
<%
174 
%>
 174 
Call Destroy_All_Objects
- 
 
 175 
%>