Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

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