Subversion Repositories DevTools

<%@LANGUAGE="VBSCRIPT"%>

<%

Option explicit

Response.Expires = 0   ' always load the page, dont store

%>

<%

'=====================================================

'           Update a Project's Code Review Base URL and Jira Key

'=====================================================

%>

<!--#include file="common/conf.asp"-->

<!--#include file="common/globals.asp"-->

<!--#include file="common/formating.asp"-->

<!--#include file="common/qstr.asp"-->

<!--#include file="common/common_subs.asp"-->

<!--#include file="common/common_dbedit.asp"-->

<!--#include file="common/_popup_window_common.asp"-->

<%

' Set rfile parameter. This is a return page after Login

Call objPMod.StoreParameter ( "rfile", "admin_projects.asp" )

'------------ ACCESS CONTROL ------------------

%>

<!--#include file="_access_control_login.asp"-->

<!--#include file="_access_control_general.asp"-->

<!--#include file="_access_control_project.asp"-->

<%

'------------ Variable Definition -------------

Dim sMessage

Dim parProj_id

Dim projName

Dim baseURL

Dim jiraKey

'------------ Constants Declaration -----------

'------------ Variable Init -------------------

parProj_id = Request("proj_id")

sMessage = NULL

'----------------------------------------------

%>

<%

'-----------------------------------------------------------------------------------------------------------------------------

Sub Get_Project_Config ( NNproj_id, out_base_url, out_jira_key, out_proj_name )

   Dim rsTemp, Query_String

   Query_String = _

   " SELECT base_url, jira_key, proj_name "&_

   "   FROM projects pr "&_

  "  WHERE pr.proj_id = "& NNproj_id

   Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))

   out_base_url = rsTemp("base_url")

   out_jira_key = rsTemp("jira_key")

   out_proj_name = rsTemp("proj_name")

   rsTemp.Close()

   Set rsTemp = nothing

End Sub

'-----------------------------------------------------------------------------------------------------------------------------------

Sub Update_Project_Config ( nProj_id, sBaseURL, sJiraKey, sProjName)

   Dim sTempURL

   sTempURL = sBaseURL

   If (sTempURL <> "") and (Right(sTempURL, 1) <> "/") Then sTempURL = sTempURL & "/"

   OraDatabase.Parameters.Add "PROJ_ID",        nProj_id,          ORAPARM_INPUT,    ORATYPE_NUMBER

   OraDatabase.Parameters.Add "BASE_URL",       sTempURL,          ORAPARM_INPUT,    ORATYPE_VARCHAR2

   OraDatabase.Parameters.Add "JIRA_KEY",       sJiraKey,          ORAPARM_INPUT,    ORATYPE_VARCHAR2

   OraDatabase.Parameters.Add "PROJ_NAME",      sProjName,          ORAPARM_INPUT,    ORATYPE_VARCHAR2

   objEH.ErrorRedirect = FALSE

   objEH.TryORA ( OraSession )

   On Error Resume Next

   OraDatabase.ExecuteSQL _

        "UPDATE projects" &_

        " SET base_url = :BASE_URL," &_

        " jira_key = :JIRA_KEY," &_

        " proj_name = :PROJ_NAME" &_

        " WHERE proj_id = :PROJ_ID"

   objEH.CatchORA ( OraSession )

   If objEH.Finally Then

      Call OpenInParentWindow ("admin_projects.asp" )

      Call CloseWindow

   End If

   OraDatabase.Parameters.Remove "PROJ_ID"

   OraDatabase.Parameters.Remove "BASE_URL"

   OraDatabase.Parameters.Remove "JIRA_KEY"

   OraDatabase.Parameters.Remove "PROJ_NAME"

End Sub

'-----------------------------------------------------------------------------------------------------------------------------------

%>

<%

'-----------------------------------------------------------------------------------------------------------------------------------

Function ValidateURL ( sBaseURL )

   Dim oExp

   Set oExp = new RegExp

   oExp.Global = False

   oExp.Pattern = "(^https?:\/\/[a-z1-9])|(^$)"

   ValidateURL = oExp.Test(sBaseURL)

End Function

'-----------------------------------------------------------------------------------------------------------------------------------

Function ValidateJiraKey ( sJiraKey )

   Dim oExp

   Set oExp = new RegExp

   oExp.Global = False

   oExp.Pattern = "^[A-Za-z0-9]*$"

   ValidateJiraKey = oExp.Test(sJiraKey)

End Function

'-----------------------------------------------------------------------------------------------------------------------------------

%>

<%

'------------ Action Requirements -------------------

'Process submition

If CBool(Request("action")) AND objAccessControl.UserLogedIn Then

   If ValidateURL (Request("base_url")) and ValidateJiraKey (Request("jira_key")) Then

      Call Update_Project_Config ( parProj_id, Request("base_url"), Request("jira_key"), Request("project_name") )

   End If

End If

Call Get_Project_Config ( parProj_id, baseURL, jiraKey, projName )

%>

<html>

   <head>

      <title>Release Manager</title>

      <link rel="shortcut icon" href="<%=FavIcon%>"/>

      <meta http-equiv="Pragma" content="no-cache">

      <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

      <link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">

      <link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">

      <script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>

      <!-- TIPS -->

      <script language="JavaScript" src="images/tipster.js?ver=<%=VixVerNum%>"></script>

      <script language="JavaScript" src="images/_help_tips.js?ver=<%=VixVerNum%>"></script>

   </head>

   <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">

      <form class="form_tight" action="<%=scriptName%>" method="post" name="baseurl" onsubmit="MM_validateForm('base_url','Base URL','isURL','jira_key','JIRA Key','isAlphaNum');return document.MM_returnValue;">

         <table width="100%" border="0" cellspacing="0" cellpadding="2">

         <tr>

            <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">

               <!-- LOCAL ERROR +++++++++++++++++++++++++++++++++++++++++++++++ -->

               <%Call Messenger ( sMessage , 3, "100%" )%>

               <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->

               <!--#include file="messages/_msg_inline.asp"-->

               <table width="100%" border="0" cellspacing="0" cellpadding="0">

               <tr>

                  <td width="1%"><img src="images/h_trsp_dot.gif" width="10" height="30"></td>

                  <td width="100%">

                     <table width="100%" border="0" cellspacing="1" cellpadding="4">

                     <tr>

                        <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Project Name</td>

                        <td nowrap background="images/bg_form_lightbluedark.gif" class="form_item" colspan="3" width="100%">

                           <input name="project_name" type="text" size="30" maxlength="30" class="form_item" value='<%=projName%>'>

                        </td>

                     </tr>

                     <tr>

                        <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Code Review Base URL</td>

                        <td nowrap background="images/bg_form_lightbluedark.gif" class="form_item" colspan="3" width="100%">

                           <input name="base_url" type="text" size="78" maxlength="200" class="form_item" value='<%=baseURL%>'>

                        </td>

                     </tr>

                     <tr>

                        <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">JIRA Key</td>

                        <td nowrap background="images/bg_form_lightbluedark.gif" class="form_item" colspan="3" width="100%">

                           <input name="jira_key" type="text" size="10" maxlength="20" class="form_item" value='<%=jiraKey%>'>

                        </td>

                     </tr>

                     </table>

                  </td>

               </tr>

               </table>

               <input type="hidden" name="action" value="true">

               <input type="hidden" name="proj_id" value="<%=parProj_id%>">

            </td>

         </tr>

         <tr>

            <td><%=ProgressBar()%></td>

            <td align="right" nowrap class="wform_ttl">

               <input type="submit" name="btn" value="Save" class="form_btn">

               <input type="reset" name="btn" value="Close" class="form_btn" onclick="parent.closeIFrame();">

            </td>

         </tr>

         </table>

      </form>

   </body>

</html>

<!-- DESTRUCTOR ------->

<!--#include file="common/destructor.asp"-->