Subversion Repositories DevTools

Rev

Rev 7286 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
5357 dpurdie 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
5590 dpurdie 5
'|                    wAddSchedule
5357 dpurdie 6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
Response.Expires = 0
12
%>
13
<!--#include file="common/conf.asp"-->
14
<!--#include file="common/globals.asp"-->
15
<!--#include file="common/formating.asp"-->
16
<!--#include file="common/qstr.asp"-->
17
<!--#include file="common/common_subs.asp"-->
7286 dpurdie 18
<!--#include file="common/_popup_window_common.asp"-->
5357 dpurdie 19
<!--#include file="common/_form_window_common.asp"-->
20
<%
21
'------------ ACCESS CONTROL ------------------
22
%>
6048 dpurdie 23
<!--#include file="_access_control_login.asp"-->
5357 dpurdie 24
<!--#include file="_access_control_general.asp"-->
25
<%
26
'------------ VARIABLE DEFINITION -------------
27
Dim rsQry
28
Dim rsTemp
29
Dim sMessage
30
Dim Query_String
31
'------------ CONSTANTS DECLARATION -----------
32
'------------ VARIABLE INIT -------------------
33
sMessage = NULL
34
 
35
Set objFormCollector = CreateObject("Scripting.Dictionary")
36
'------------ CONDITIONS ----------------------
37
'----------------------------------------------
38
%>
39
<%
40
'--------------------------------------------------------------------------------------------------------------------------
41
Function GetMachType ( ngbe_id )
5590 dpurdie 42
    Dim rsQry, query
43
 
44
    OraDatabase.Parameters.Add "gbe_id",   ngbe_id, ORAPARM_INPUT, ORATYPE_NUMBER 
45
 
46
    query = GetQuery ("GBE_MACHTYPECombo.sql")
47
 
48
    Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
49
    If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then
50
        GetMachType = rsQry.GetRows()
51
    Else
52
        GetMachType = NULL
53
 
54
    End If
55
 
56
    rsQry.Close()
57
    Set rsQry = Nothing
58
 
59
    OraDatabase.Parameters.Remove "gbe_id"
5357 dpurdie 60
End Function
61
'--------------------------------------------------------------------------------------------------------------------------
62
Sub RenderRepeatCombo( cRepeat )
5590 dpurdie 63
    Response.Write "<select name='repeat_combo' class='form_item'>" 
5357 dpurdie 64
    Response.write "<option value='0'>Once Only</option>"
65
    Response.write "<option value='1'>Daily</option>"
66
    Response.write "<option value='7'>Weekly</option>"
5590 dpurdie 67
    Response.Write "</select>"  
5357 dpurdie 68
End Sub
69
'--------------------------------------------------------------------------------------------------------------------------
70
%>
71
<%
72
'------------ RUN BEFORE PAGE RENDER ----------
73
If CBool(Request("action")) Then
74
 
5590 dpurdie 75
    If Len(Request("repeat_combo")) > 1 Then
76
 
77
        Call DisplayInfo ( "REPEAT_SCHEDULE_NOT_SELECTED", "100%" )
78
 
79
    Else
80
        On Error Resume Next
81
        OraDatabase.Parameters.Add "SCHEDULED_PAUSE",   Request("scheduled_pause"),     ORAPARM_INPUT, ORATYPE_VARCHAR2
82
        OraDatabase.Parameters.Add "SCHEDULED_RESUME",  Request("scheduled_resume"),    ORAPARM_INPUT, ORATYPE_VARCHAR2
83
        OraDatabase.Parameters.Add "REPEAT",            Request("repeat_combo"),        ORAPARM_INPUT, ORATYPE_CHAR
84
        OraDatabase.Parameters.Add "INDEFINITE_PAUSE",  Request("indefinite_pause"),    ORAPARM_INPUT, ORATYPE_CHAR
85
 
86
        objEH.TryORA ( OraSession )
87
 
88
        OraDatabase.ExecuteSQL _
5357 dpurdie 89
           "BEGIN PK_BUILDAPI.Insert_Schedule_Info ( " &_
5638 dpurdie 90
                "TO_DATE(:SCHEDULED_PAUSE,'DY DD-MON-YYYY HH24:MI'), " &_
91
                "TO_DATE(:SCHEDULED_RESUME,'DY DD-MON-YYYY HH24:MI'), " &_
5357 dpurdie 92
                ":REPEAT, " &_
93
                ":INDEFINITE_PAUSE );" &_
94
            "END;"
5590 dpurdie 95
 
96
        objEH.CatchORA ( OraSession )
5357 dpurdie 97
 
5590 dpurdie 98
        OraDatabase.Parameters.Remove "SCHEDULED_PAUSE"
99
        OraDatabase.Parameters.Remove "SCHEDULED_RESUME"
100
        OraDatabase.Parameters.Remove "REPEAT"
101
        OraDatabase.Parameters.Remove "INDEFINITE_PAUSE"
5357 dpurdie 102
 
5590 dpurdie 103
        If objEH.Finally Then
104
            Call OpenInParentWindow ("admin_build_service.asp")
105
            Call CloseWindow()
5957 dpurdie 106
            Call Destroy_All_Objects
5636 dpurdie 107
            Response.End
5590 dpurdie 108
        End If
5357 dpurdie 109
 
5590 dpurdie 110
        rsQry.Close()
111
        Set rsQry = nothing
112
    End If
113
 
5357 dpurdie 114
End If
115
 
116
 
117
'----------------------------------------------
118
%>
119
<html>
5590 dpurdie 120
    <head>
121
        <title>Release Manager</title>
5357 dpurdie 122
        <link rel="shortcut icon" href="<%=FavIcon%>"/>
5590 dpurdie 123
        <meta http-equiv="Pragma" content="no-cache">
124
        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
6579 dpurdie 125
        <link href="images/release_manager_style.css?ver=<%=VixVerNum%>" rel="stylesheet" type="text/css">
6676 dpurdie 126
        <script language="JavaScript" src="scripts/common.js?ver=<%=VixVerNum%>"></script>
5636 dpurdie 127
        <%bJqueryTimePicker = TRUE%>
128
        <!--#include file="_jquery_includes.asp"-->
129
        <script>
130
        $(document).ready(function(){
5638 dpurdie 131
            // Set common defaults
132
            $.timepicker.setDefaults({
5636 dpurdie 133
        		timeFormat: "HH:mm",
134
                dateFormat: "D dd-M-yy",
135
        		controlType: 'select',
136
        		oneLine: true,
137
        		timeInput: true,
138
                constrainInput: true,
139
                showOn: 'both',
140
                buttonImageOnly : true,
141
                buttonImage: "images/cal.gif",
142
                buttonText: "Select Date and Time",
143
                minDate : 0,
144
                changeYear : true, 
145
                yearRange : "0000:2099",
5638 dpurdie 146
                changeMonth: true
147
            });
5636 dpurdie 148
 
5638 dpurdie 149
            //  Set up two linked pickers
150
        	var startTime =  $('#scheduled_pause');
151
        	var endTime =  $('#scheduled_resume');
152
        	$.timepicker.datetimeRange(
153
        	    startTime,
154
        	    endTime,
155
        	    {
156
        		start: {             // start picker options
157
                    onClose : function(p1,p2){
158
                        checkForm();
159
            			}
160
                },
161
        		end: {               // end picker options
162
                    onClose : function(p1,p2){
163
                        checkForm();
164
            			}
165
                }					
5636 dpurdie 166
        	    });
167
 
5638 dpurdie 168
            // Update form controls before display
169
            checkForm();
5636 dpurdie 170
 
171
        	});
172
 
5638 dpurdie 173
        // Enable / Disable the forms submit button
174
        // Enable when both dates are not empty
5636 dpurdie 175
        function checkForm() {
176
            var resume = $('#scheduled_resume').val().length;
177
            var pause = $('#scheduled_pause').val().length;
178
            var ok = ( resume > 0 && pause > 0);
179
 
180
            var but = $("#formSubmit");
181
            but.toggleClass("form_btn", ok);
182
            but.toggleClass("form_btn_disabled", !ok);
183
            but.prop("disabled", !ok );
184
        }
185
 
186
        </script>
187
        <style>
188
            #ui-datepicker-div {
189
                position: absolute !important;
190
                top: 0px !important;
191
                left: 0px !important;
192
                }
6695 dpurdie 193
            .ui-datepicker-trigger{
194
                vertical-align: top;
195
                padding-left: 3px;
196
            }
5636 dpurdie 197
        </style>
5590 dpurdie 198
    </head>
6695 dpurdie 199
    <body leftmargin="0" topmargin="0" onload="self.focus();">
7288 dpurdie 200
	<div id='divProgressBar' class='vixSpinner' style='visibility:hidden;'></div>
6695 dpurdie 201
        <table width="100%" border="0" cellspacing="0" cellpadding="10" class=form_field_bg>
5590 dpurdie 202
            <%
203
            '-- FROM START --------------------------------------------------------------------------------------------------------------
204
            objFormComponent.FormName = "run_level_schedule"
205
            objFormComponent.FormClass = "form_tight"
206
            objFormComponent.Action = ScriptName
207
            objFormComponent.OnSubmit = "ShowProgress();"
208
            Call objFormComponent.FormStart()
209
            %>
210
            <tr>
211
                <td>
212
                    <!-- NEW SCHEDULE ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++  -->
213
                    <%Call Messenger ( sMessage , 3, "100%" )%>
214
                    <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
215
                    <!--#include file="messages/_msg_inline.asp"-->
216
                    <br>
5636 dpurdie 217
                    <table border="0">
5590 dpurdie 218
                        <tr>
5636 dpurdie 219
                            <td nowrap class="form_iname">Scheduled Pause</td>
220
                            <td nowrap class="form_item"><%=objFormComponent.TextBox ("scheduled_pause", "", "size='20' class='form_ivalue' id='scheduled_pause'" )%></td>
5590 dpurdie 221
                        </tr>
222
                        <tr>
5636 dpurdie 223
                            <td nowrap class="form_iname">Scheduled Resume</td>
224
                            <td nowrap class="form_item"><%=objFormComponent.TextBox ("scheduled_resume", "", "size='20' class='form_ivalue' id='scheduled_resume'" )%></td>
5590 dpurdie 225
                            </td>
226
                        </tr>
227
                        <tr>
5636 dpurdie 228
                            <td nowrap class="form_iname">Repeat</td>
229
                            <td nowrap class="form_item"><% Call RenderRepeatCombo("")%></td>
5590 dpurdie 230
                        </tr>
231
                    </table>
232
                </td>
233
            </tr>
234
            <tr>
5636 dpurdie 235
                <td style="height:100px">
236
                </td>
237
            </tr>
238
            <tr>
7288 dpurdie 239
                <td class="form_field_hdrgap" align="right">
240
					<input name="btn" type="submit" class="form_btn" value="Add" id="formSubmit">
241
					<input name="btn" type="reset" class="form_btn" value="Cancel" onclick="parent.closeIFrame();">
5590 dpurdie 242
                </td>
243
            </tr>
5636 dpurdie 244
            <%=objPMod.ComposeHiddenTags()%>
245
            <input type="hidden" name="action" value="true">
246
            <%
247
            Call objFormComponent.FormEnd()
248
            '-- FROM END ----------------------------------------------------------------------------------------------------------------
249
            %>
5590 dpurdie 250
        </table>
251
    </body>
5357 dpurdie 252
</html>
253
<%
254
'------------ RUN AFTER PAGE RENDER -----------
255
Set objFormCollector = Nothing
256
'----------------------------------------------
257
Call Destroy_All_Objects
258
%>