Subversion Repositories DevTools

Rev

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