Subversion Repositories DevTools

Rev

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

Rev 13 Rev 15
Line 18... Line 18...
18
'------------ ACCESS CONTROL ------------------
18
'------------ ACCESS CONTROL ------------------
19
%>
19
%>
20
<!--#include file="_access_control_general.asp"-->
20
<!--#include file="_access_control_general.asp"-->
21
<%
21
<%
22
'------------ VARIABLE DEFINITION -------------
22
'------------ VARIABLE DEFINITION -------------
23
Dim rsQry
23
Dim rsQry, ProcId, ProcName
24
'------------ CONSTANTS DECLARATION -----------
24
'------------ CONSTANTS DECLARATION -----------
25
'------------ VARIABLE INIT -------------------
25
'------------ VARIABLE INIT -------------------
26
'------------ CONDITIONS ----------------------
26
'------------ CONDITIONS ----------------------
27
'----------------------------------------------
27
'----------------------------------------------
28
%>
28
%>
Line 78... Line 78...
78
		</td>
78
		</td>
79
        <td width="1%" background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="35"></td>
79
        <td width="1%" background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="35"></td>
80
        </tr>
80
        </tr>
81
      <tr>
81
      <tr>
82
        <td background="images/bg_bage_0.gif"><img src="images/spacer.gif" width="30" height="10"></td>
82
        <td background="images/bg_bage_0.gif"><img src="images/spacer.gif" width="30" height="10"></td>
83
        <td background="images/bg_bage_0.gif">&nbsp;</td>
83
        <td background="images/bg_bage_0.gif">
-
 
84
		<!-- BUTTONS CONTROL +++++++++++++++++++ -->			
-
 
85
		<%		
-
 
86
		'-- Define Action buttons on this tab
-
 
87
		aTabBtnsDef = Array("btnAddProc", "btnExportNodespec")
-
 
88
		
-
 
89
		Call LoadTabActionButtons ( aTabBtnsDef, objBtnControl )
-
 
90
 
-
 
91
		' -- Render Buttons
-
 
92
		Call objBtnControl.Render  ( aTabBtnsDef )
-
 
93
		
-
 
94
		%></td>
-
 
95
	
-
 
96
		
84
        <td background="images/bg_blue.gif"><img src="images/p_bar_corrner.gif" width="17" height="42"></td>
97
        <td background="images/bg_blue.gif"><img src="images/p_bar_corrner.gif" width="17" height="42"></td>
85
        </tr>
98
        </tr>
86
      <tr>
99
      <tr>
87
        <td>&nbsp;</td>
100
        <td>&nbsp;</td>
88
        <td>&nbsp;</td>
101
        <td>&nbsp;</td>
Line 91... Line 104...
91
    </table>
104
    </table>
92
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
105
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
93
      <tr>
106
      <tr>
94
        <td>
107
        <td>
95
		<!-- PAGE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
108
		<!-- PAGE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
96
		<table width="100%"  border="0" cellspacing="3" cellpadding="0">
109
		<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --></td>
97
          <tr>
110
      </tr>
98
		  	<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
-
 
99
            <td width="25%" background="images/bg_table_border.gif"><table width="100%"  border="0" cellspacing="1" cellpadding="2">
-
 
100
              <tr>
111
    </table>
101
                <td align="right" nowrap background="images/bg_table_col.gif" class="body_col">Process Name</td>
-
 
102
              </tr>
112
	<table width="520" border="0">
103
            </table></td>
113
      <tr>
104
			<td width="10%" align="right" nowrap background="images/bg_table_col.gif" class="body_col">Run As</td>
114
        <td nowrap width="87" background="images/bg_table_col.gif"><div align="left"><span class="body_col">Health Tag</span></div></td>
105
            <td width="10%" align="right" nowrap background="images/bg_table_col.gif" class="body_col">Health Tag</td>
115
        <td nowrap width="68" background="images/bg_table_col.gif"><div align="left"><span class="body_col">Package</span></div></td>
106
			<td width="15%" align="right" background="images/bg_table_col.gif" class="body_col">Command</td>
116
        <td nowrap width="143" background="images/bg_table_col.gif"><div align="left"><span class="body_col">Command Interface</span></div></td>
107
			<td width="40%" align="right" background="images/bg_table_col.gif" class="body_col">Comments</td>
117
        <td nowrap width="85" background="images/bg_table_col.gif"><div align="left"><span class="body_col">Interface</span></div></td>
108
			<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
118
        <td nowrap width="62" background="images/bg_table_col.gif"><div align="left"><span class="body_col">Owner</span></div></td>
109
			<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
119
        <td nowrap width="" background="images/bg_table_col.gif"><div align="left"></div></td>
110
          </tr>
120
      </tr>
-
 
121
	  
-
 
122
<%
-
 
123
		  ' Load some action buttons
-
 
124
		  Call objBtnControl.LoadActionButtons ( Array("btnEditProc", "btnRemoveProc"), OraDatabase )
-
 
125
		  objBtnControl.ButtonSpacer = 1
111
		  <%
126
		  
112
		  Dim currProd_id
127
		  Dim currProd_id
113
		  
128
		  
114
		  OraDatabase.Parameters.Add "OS_ID", 	dbPARos_id,		ORAPARM_INPUT, ORATYPE_NUMBER 
129
		  OraDatabase.Parameters.Add "OS_ID", 	dbPARos_id,		ORAPARM_INPUT, ORATYPE_NUMBER 
115
		  
130
		  
116
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("OsProcesses.sql"), ORADYN_DEFAULT )
131
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("OsProcessConfig.sql"), ORADYN_DEFAULT )
117
		  
132
		  
118
		  currProd_id = ""
133
		  currProd_id = ""
119
		  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
134
		  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
120
		  %>
-
 
121
		  <!--  Group By Product -->
-
 
122
		  <%If currProd_id <> CStr(rsQry("prod_id")) Then%>
135
		  ProcId = rsQry("prod_id")
123
          <tr>
-
 
124
            <td colspan="8"><a href="#" class="body_link"><%=LIMG_PRODUCT  &  rsQry("pkg_name").Value  &" "&  rsQry("pkg_version").Value%></a></td>
-
 
125
          </tr>
-
 
126
		  <tr>
-
 
127
            <td colspan="8" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
-
 
128
          </tr>
-
 
129
		  <% currProd_id = CStr(rsQry("prod_id")) %>
136
		  ProcName = rsQry("pkg_name")
130
		  <%End If%>
-
 
131
		  
137
%>	  
132
          <tr>
138
      <tr>
133
		  	<td align="center" valign="top"><input type="checkbox" name="proc_id" value="<%=rsQry("proc_id")%>"></td>
-
 
134
			<td nowrap class="body_row" valign="top"><%=LIMG_PROCESS  &  rsQry("proc_name").Value%></td>
-
 
135
            <td nowrap class="body_row" valign="top"><%=rsQry("run_as")%></td>
139
        <td><div align="left"><span class="body_row"><%=rsQry("pkg_health_tag")%></span></div></td>
136
			<td nowrap class="body_row" valign="top"><%=rsQry("pkg_health_tag")%></td>
140
        <td><div align="left"><span class="body_row"><%=rsQry("pkg_name")%></span></div></td>
137
			<td class="body_cmd" valign="top"><%=rsQry("cmd_interface")%></td>
141
        <td><div align="left"><span class="body_row"><%=rsQry("cmd_interface")%></span></div></td>
138
            <td class="body_rowlite" valign="top"><%=rsQry("proc_description").Value%></td>
142
        <td><div align="left"><span class="body_row"><%=rsQry("is_interface")%></span></div></td>
139
			<td align="center"><a href="#" title="Edit"><%=LIMG_EDIT%></a></td>
143
        <td><div align="left"><span class="body_row"><%=rsQry("pkg_owner")%></span></div></td>
140
			<td align="center"><a href="#" title="Remove"><%=LIMG_REMOVE%></a></td>
144
		<td align="left" valign="top" bgcolor="#FAFAF6"><%Call objBtnControl.Render  ( Array("btnEditProc", "btnRemoveProc") )%></td>		
-
 
145
 
141
          </tr>
146
      </tr>
142
		  <%rsQry.MoveNext%>
147
	  <%rsQry.MoveNext%>
143
		  
148
		  
144
		  <%If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then%>
149
		  <%If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then%>
145
          <tr>
150
          <tr>
146
            <td colspan="8" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
151
            <td colspan="8" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
147
          </tr>
152
          </tr>
Line 149... Line 154...
149
		  
154
		  
150
		  <%
155
		  <%
151
		  WEnd
156
		  WEnd
152
		  
157
		  
153
		  OraDatabase.Parameters.Remove "OS_ID"
158
		  OraDatabase.Parameters.Remove "OS_ID"
154
		  %>
159
		  %>	  
155
          <tr>
-
 
156
            <td colspan="8" background="images/bg_table_border.gif">
-
 
157
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
-
 
158
              <tr>
-
 
159
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
-
 
160
              </tr>
-
 
161
             </table>
-
 
162
			</td>
-
 
163
          </tr>
-
 
164
         </table>	
-
 
165
		<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
-
 
166
		</td>
-
 
167
      </tr>
-
 
168
    </table>
160
    </table>	
169
	</td>
161
	<p>&nbsp;</p></td>
170
    <td width="1%" valign="top" background="images/bg_favourits.gif">
162
    <td width="1%" valign="top" background="images/bg_favourits.gif">
171
	<%If Request.Cookies( enumCOOKIE_NAME )( "user_bar" ) <> "hide" Then%>
163
	<%If Request.Cookies( enumCOOKIE_NAME )( "user_bar" ) <> "hide" Then%>
172
	<!-- PERSONAL PANE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
164
	<!-- PERSONAL PANE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
173
      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
165
      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
174
      <tr>
166
      <tr>