Subversion Repositories DevTools

Rev

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

Rev 119 Rev 129
Line 30... Line 30...
30 
Set viewinfoHash = CreateObject("Scripting.Dictionary")
 30 
Set viewinfoHash = CreateObject("Scripting.Dictionary")
31 
parView_id = QStrPar("FRview_id")
 31 
parView_id = QStrPar("FRview_id")
32 
'----------------------------------------------
 32 
'----------------------------------------------
33 
%>
 33 
%>
34 
<%
 34 
<%
35 
Function Get_All_Pkg_Names
35 
Function Get_All_Pkg_Names
36 
	Get_All_Pkg_Names = " SELECT pkg_id, pkg_name, UPPER(pkg_name) AS name_order FROM packages WHERE pkg_id > 0 ORDER BY name_order ASC"
 36 
	Get_All_Pkg_Names = " SELECT pkg_id, pkg_name, UPPER(pkg_name) AS name_order FROM packages WHERE pkg_id > 0 ORDER BY name_order ASC"
37 
End Function
 37 
End Function
38 
 
 38 
 
39 
Sub Populate_viewdefHash ( NNview_id,  HHviewdefHash )
 39 
Sub Populate_viewdefHash ( NNview_id,  HHviewdefHash )
40 
	Dim rsTemp, Query_String
 40 
	Dim rsTemp, Query_String
Line 63... Line 63...
63 
%>
 63 
%>
64 
<%
 64 
<%
65 
'------------------------- MAIN LINE ------------------------
 65 
'------------------------- MAIN LINE ------------------------
66 
'Process submition
 66 
'Process submition
67 
If CBool(QStrPar("action"))  Then
 67 
If CBool(QStrPar("action"))  Then
68
68 
 
69 
	%>
 69 
	%>
70 
	<script language="JavaScript" type="text/javascript">
 70 
	<script language="JavaScript" type="text/javascript">
71 
	window.opener.document.location='_edit_public_view.asp?FRview_id=<%=parView_id%>&FRviewname=<%=QStrPar("FRviewname")%>&FRpkginc=<%=Request("FRpkginc")%>';
 71 
	window.opener.document.location='_edit_public_view.asp?FRview_id=<%=parView_id%>&FRviewname=<%=QStrPar("FRviewname")%>&FRpkginc=<%=Request("FRpkginc")%>';
72 
	</script>
72 
	</script>
73 
	<%
 73 
	<%
74 
	Call CloseWindow
 74 
	Call CloseWindow
75 
End If
 75 
End If
76 
 
 76 
 
77 
Call Populate_viewdefHash ( parView_id, viewdefHash )
 77 
Call Populate_viewdefHash ( parView_id, viewdefHash )
Line 94... Line 94...
94 
<!-- TIPS LAYERS -------------------------------------->
 94 
<!-- TIPS LAYERS -------------------------------------->
95 
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10">&nbsp;</div>
 95 
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10">&nbsp;</div>
96 
<!----------------------------------------------------->
 96 
<!----------------------------------------------------->
97 
<form name="editview" method="post" action="<%=scriptName%>?done=done<%=QSTR_All%>" onSubmit="return check();">
 97 
<form name="editview" method="post" action="<%=scriptName%>?done=done<%=QSTR_All%>" onSubmit="return check();">
98 
  <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
 98 
  <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
99 
    <tr>
99 
    <tr>
100 
      <td background="images/bg_member_dark.gif" width="1%" height="1%"><img src="images/bt_view.gif" width="31" height="18" hspace="5"></td>
 100 
      <td background="images/bg_member_dark.gif" width="1%" height="1%"><img src="images/bt_view.gif" width="31" height="18" hspace="5"></td>
101 
      <td background="images/bg_member_dark.gif" nowrap width="50%" class="wform_ttl">&nbsp;Edit Public View</td>
 101 
      <td background="images/bg_member_dark.gif" nowrap width="50%" class="wform_ttl">&nbsp;Edit Public View</td>
102 
      <td background="images/bg_member_dark.gif" align="right" width="50%">
 102 
      <td background="images/bg_member_dark.gif" align="right" width="50%">
103 
	  	<input type="hidden" name="action" value="true">
103 
	  	<input type="hidden" name="action" value="true">
104 
		<input type="hidden" name="FRview_id" value="<%=parView_id%>">
104 
		<input type="hidden" name="FRview_id" value="<%=parView_id%>">
105 
        <input type="submit" name="btn" value="Update" class="form_btn_comp" onClick="clickedButton=true;MM_validateForm('FRviewname','View Name','R');return document.MM_returnValue">
 105 
        <input type="submit" name="btn" value="Update" class="form_btn_comp" onClick="clickedButton=true;MM_validateForm('FRviewname','View Name','R');return document.MM_returnValue">
106 
        <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
 106 
        <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
107 
      </td>
 107 
      </td>
108 
      <td background="images/bg_member_dark.gif" align="right" width="1%%" nowrap>
108 
      <td background="images/bg_member_dark.gif" align="right" width="1%%" nowrap>
109 
        <img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
 109 
        <img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
110 
    </tr>
 110 
    </tr>
111 
    <tr>
111 
    <tr>
112 
      <td height="100%" width="1%">&nbsp;</td>
 112 
      <td height="100%" width="1%">&nbsp;</td>
113 
      <td valign="top" nowrap colspan="3" class="wform_ttl">
113 
      <td valign="top" nowrap colspan="3" class="wform_ttl">
114 
        <table width="100%" border="0" cellspacing="1" cellpadding="2">
 114 
        <table width="100%" border="0" cellspacing="1" cellpadding="2">
115 
          <tr>
115 
          <tr>
116 
            <td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
 116 
            <td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
117 
            <td width="1%" nowrap class="form_group" valign="bottom"></td>
 117 
            <td width="1%" nowrap class="form_group" valign="bottom"></td>
118 
            <td nowrap width="100%" align="right" class="form_step">&nbsp;</td>
 118 
            <td nowrap width="100%" align="right" class="form_step">&nbsp;</td>
119 
          </tr>
 119 
          </tr>
120 
          <tr>
120 
          <tr>
121 
            <td width="1%">&nbsp;</td>
 121 
            <td width="1%">&nbsp;</td>
122 
            <td colspan="2" width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">
122 
            <td colspan="2" width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">
123 
              View Name</td>
 123 
              View Name</td>
124 
          </tr>
 124 
          </tr>
125 
          <tr>
125 
          <tr>
126 
            <td width="1%">&nbsp;</td>
 126 
            <td width="1%">&nbsp;</td>
127 
            <td colspan="2" width="1%" nowrap background="images/bg_form_lightgray.gif">
127 
            <td colspan="2" width="1%" nowrap background="images/bg_form_lightgray.gif">
128 
              <input type="text" name="FRviewname" maxlength="30" class="form_item" value="<%=viewinfoHash.Item("view_name")%>">
 128 
              <input type="text" name="FRviewname" maxlength="30" class="form_item" value="<%=viewinfoHash.Item("view_name")%>">
129 
			</td>
 129 
			</td>
130 
          </tr>
 130 
          </tr>
131 
          <tr>
131 
          <tr>
132 
            <td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="10"></td>
 132 
            <td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="10"></td>
133 
            <td width="1%" nowrap class="form_group" valign="bottom"></td>
 133 
            <td width="1%" nowrap class="form_group" valign="bottom"></td>
134 
            <td nowrap width="100%" align="right" class="form_step"></td>
 134 
            <td nowrap width="100%" align="right" class="form_step"></td>
135 
          </tr>
 135 
          </tr>
136 
          <tr>
136 
          <tr>
137 
            <td width="1%">&nbsp;</td>
 137 
            <td width="1%">&nbsp;</td>
138 
            <td colspan="2" width="1%" nowrap class="form_field">
138 
            <td colspan="2" width="1%" nowrap class="form_field">
139 
              <table width="100%" border="0" cellspacing="1" cellpadding="2">
 139 
              <table width="100%" border="0" cellspacing="1" cellpadding="2">
140 
                <tr>
140 
                <tr>
141 
                  <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field">&nbsp;</td>
 141 
                  <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field">&nbsp;</td>
142 
                  <td background="images/bg_form_lightbluedark.gif" nowrap width="100%" class="form_field">Package Name</td>
 142 
                  <td background="images/bg_form_lightbluedark.gif" nowrap width="100%" class="form_field">Package Name</td>
143 
                </tr>
 143 
                </tr>
144 
                <%Set rsTemp = OraDatabase.DbCreateDynaset( Get_All_Pkg_Names, cint(0))
 144 
                <%Set rsTemp = OraDatabase.DbCreateDynaset( Get_All_Pkg_Names, cint(0))
145 
				While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
 145 
				While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
146 
                <tr>
146 
                <tr>
147 
                  <td background="images/bg_form_lightgray.gif" nowrap class="form_item">
147 
                  <td background="images/bg_form_lightgray.gif" nowrap class="form_item">
148 
                    <input type="checkbox" name="FRpkginc" value="<%=rsTemp.Fields("pkg_id")%>" <%If viewdefHash.Exists (Cstr(rsTemp.Fields("pkg_id"))) Then Response.write "checked"%>>
 148 
                    <input type="checkbox" name="FRpkginc" value="<%=rsTemp.Fields("pkg_id")%>" <%If viewdefHash.Exists (Cstr(rsTemp.Fields("pkg_id"))) Then Response.write "checked"%>>
149 
                  </td>
 149 
                  </td>
150 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><%=rsTemp.Fields("pkg_name")%></td>
 150 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><%=rsTemp.Fields("pkg_name")%></td>
151 
                </tr>
 151 
                </tr>
152 
                <%rsTemp.MoveNext
 152 
                <%rsTemp.MoveNext
153 
			  	WEnd%>
 153 
			  	WEnd%>
154 
				<%If rsTemp.RecordCount < 1 Then%>
 154 
				<%If rsTemp.RecordCount < 1 Then%>
155 
				<tr>
155 
				<tr>
156 
                  <td background="images/bg_form_lightgray.gif" nowrap class="form_item"></td>
 156 
                  <td background="images/bg_form_lightgray.gif" nowrap class="form_item"></td>
157 
                  <td background="images/bg_form_lightgray.gif" class="err_alert">NO PACKAGES FOUND!</td>
 157 
                  <td background="images/bg_form_lightgray.gif" class="err_alert">NO PACKAGES FOUND!</td>
158 
                </tr>
 158 
                </tr>
159 
				<%End If%>
 159 
				<%End If%>
160 
              </table>
 160 
              </table>
161 
            </td>
 161 
            </td>
162 
          </tr>
 162 
          </tr>
163 
        </table>
 163 
        </table>
164 
      </td>
 164 
      </td>
165 
    </tr>
 165 
    </tr>
166 
    <tr>
166 
    <tr>
167 
      <td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
 167 
      <td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
168 
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_member_dark.gif"></td>
 168 
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_member_dark.gif"></td>
169 
    </tr>
 169 
    </tr>
170 
  </table>
 170 
  </table>
171 
</form>
 171 
</form>
172 
</body>
 172 
</body>
173 
</html>
 173 
</html>
- 
 
 174 
<%
- 
 
 175 
Call Destroy_All_Objects
- 
 
 176 
%>