WEBCONDDB/php_CondDB/Ora_queries.php

<?php
/*
 * Created on Sep 14, 2006
 * by Katarzyna Maria Dziedziniewicz
 * Contains:
 * Ora_queries subpage
 */
        
        session_start();
        include('utils/header.php');
        require('utils/tableViewer.php');
        require('utils/dropdownViewer.php');
        include('utils/queryLister.php');
        include ('utils/queryResponder.php');
        $queryL = new queryLister;
        
        
        $iov_val = isset($_POST['IOV_name']) ? ($_POST['IOV_name']) : '';
        
?>      
        <!--      <p>&nbsp;&nbsp; 
        <!--            <table class="main_part">
                <tr><td class="in_main_tile_td">
                        Get information about production requests: 
                        </td></tr>
                        <tr><td>
                        &nbsp;&nbsp;
                        <? /*
                         echo '<form name="get_IOV_TAG" method="post" action='. $_SERVER['PHP_SELF'].'>
                        &nbsp;&nbsp;IOV name <input type="text" name="IOV_name" value="'.$iov_val.'">';
                        */ ?>
                        <input type=submit name="IOVSubmit" value="IOVSubmit">
                        </td></tr>
                </form>
        -->     
<?              
        $queryList = $queryL->parse();
        if (count($queryList) < 1)
        {
                echo '&nbsp;&nbsp;There are no available queries';
        }
        else
        {
                echo 
                '<h2 class="h2cond" >CondDB:: Bookeeping:  </h2>' .
                '<h4 class="h4cond">Available queries</h4>'.
                '<form name="selectQuery" method="post" action='. $_SERVER['PHP_SELF'].'>
                ';
                echo '<select name="sel_query" class="iov" size="10" onclick="submit()">';
                foreach($queryList as $query)
                {
                        if (isset($_POST['sel_query']) && ($_POST['sel_query']==$query->name))
                        {
                                echo '<option SELECTED value="'. $query->name.'">'.$query->description.'</option>';
                        }
                        else
                        {
                                echo '<option value="'. $query->name.'">'.$query->description.'</option>';              
                        }
                }
                echo '</select>';
                echo '<input type="submit" class="submit" name="chooseQuery" value="Choose query" >'.
        
                '</form>';
                //if (isset($_POST['chooseQuery']) || isset($_POST['querySubmit'])) 
                //{
                        if (!isset($_POST['sel_query']) && $_SESSION['sel_query']=='')
                        {
                                //no query selected
                                //do nothing
                                                'No query selected';
                        }
                        else
                        {
                                /// creates input box for every parameter
                                if (isset($_POST['sel_query']))
                                {       
                                        $_SESSION['sel_query']= $_POST['sel_query'];
                                }
                                echo 
                                                '<h4 class="h4cond">Required parameters:</h4>' .
                                        '<form name="queryParams" method="post" action='. $_SERVER['PHP_SELF'].' ' .
                                                        'id="query_form" onSubmit="return validate();">' .
                                                        '<table class="in_form"> ';
                                
                                $_SESSION['has_curs'] = $queryList[($_SESSION['sel_query'])]->has_curs;
                                $_SESSION['out_params'] = $queryList[($_SESSION['sel_query'])]->out_parameters;
                                if (count($queryList[($_SESSION['sel_query'])]->in_parameters)!=0)
                                {
                                        foreach($queryList[($_SESSION['sel_query'])]->in_parameters as $param)
                                        {
                                                echo '<tr><td class="narrow">'.$param.'</td><td class="left_al_form">';
                                                if ($param =='production_name' || $param == 'detector_name' || 
                                                        $param == 'service_name')
                                                {
                                                        prepareSelect($param,'request' );
                                                }
                                                else
                                                {
                                                        $val = isset($_POST[$param]) ? ($_POST[$param]) : '';
                                                        echo '<input class="wide" type="text" name='.$param.' 
                                                        value='.$val.' >';
                                                }
                                                echo '</td></tr>';
                                        }
                                        
                                }
                                else
                                {
                                        echo '<tr><td class="left_al_form">Selected query does not require any parameters</td>' .
                                                        '<td></td></tr>';
                                }
                                        echo '<tr><td><input type=submit name="querySubmit" value="Submit query"' .
                                                        'onSubmit="return validate();">' .
                                                        '</td></tr>
                                        ' .
                                                        '</form>' .
                                                        '</table>';
                                // create parameter form
                        }
                //}
        }
        
        /// QUERY RESULT PRESENTATION
        if (isset($_POST['querySubmit']))
                {
                        echo 
                        '
                                                <h2 class="h2cond">Query result presentation:</h2>
                        ' ;
                        $qResp = new queryResponder;
                        $parameters = array();
                        foreach($queryList[($_SESSION['sel_query'])]->in_parameters as $param)
                                {                               
                                        $parameters[$param] = ($_POST[$param]);
                                }
                echo '<link rel="stylesheet" type="text/css" href="css/cmscond_table.css">';
                        $results = $qResp->getData($queryList[($_SESSION['sel_query'])]->name, $parameters, $_SESSION['has_curs'], $_SESSION['out_params']);    
                        $resViewer = new tableViewer($results);
                        $resViewer->showData();
                        echo '<script type="text/javascript" src="js/tableViewer.js"></script>';
                }
                
                
        /// IOV info presentation
/*      if (isset($_POST['IOVSubmit']))
        {
                echo '&nbsp;&nbsp;<tr><td>IOV information presentation';
                $qResp = new queryResponder;
                $result = $qResp->getIOVinfo($_POST['IOV_name']);
                echo '&nbsp;&nbsp;Information about: '.$_POST['IOV_name'].'</td></tr>';
        }
        
        */
        include('utils/backButton.php');
        include('utils/footer.html');
        
        function prepareSelect($param, $class)
        {
                $queryR = new queryResponder;
                if ($param == 'production_name')
                {
                        $options = $queryR->getConfigData('production');
                }
                elseif ($param == 'detector_name')
                {
                        $options = $queryR->getConfigData('detector');
                }
                elseif ($param == 'service_name')
                {
                        $options = $queryR->getConfigData('service');
                }
                else
                {
                        echo 'Wrong parameter';
                }
                makeDropdown($param, $options,$_SESSION['atr'.$param], $class);
        /*      echo $param.'<select name="'.$param.'" class="select">';
                foreach ($options as $obj)
                {
                        if ($_SESSION['atr'.$param]==$obj)
                        {
                                echo '<option selected="selected" value="'.$obj.'">'.$obj.'</option>';
                        }
                        else
                        {
                                echo '<option value="'.$obj.'">'.$obj.'</option>';
                        }
                }       
                        
                echo '
                </select><br>';
        
        */
        }
        

?>
<script type="text/javascript">
        function validate() {
                
                var er = document.getElementById('error_div');
                var form = document.getElementById('query_form');
                var msg = '';
                for (i=0; i <form.elements.length; i++)
                        {
                                if (form.elements[i].value.length < 1)
                                {
                                        msg += form.elements[i].name +' has to be entered. ';   
                                }
                        }
                if (msg == '')
                {
                        return true;
                        er.style.visibility="hidden";
                }               
                er.textContent = msg;
                er.style.visibility="visible";
                window.scroll(0,0);
                return false;
        }
        
</script>

Revision:	1.1
Committed:	Fri Jun 29 07:53:09 2007 UTC (17 years, 10 months ago) by kdziedzi
Branch:	MAIN
CVS Tags:	V01-01-02, V01-01-01, V1_01_00, V01-01-00, V1_00_01, HEAD
Log Message:	Introducing new order in project
#	User	Rev	Content
1	kdziedzi	1.1	<?php
2			/*
3			* Created on Sep 14, 2006
4			* by Katarzyna Maria Dziedziniewicz
5			* Contains:
6			* Ora_queries subpage
7			*/
8
9			session_start();
10			include('utils/header.php');
11			require('utils/tableViewer.php');
12			require('utils/dropdownViewer.php');
13			include('utils/queryLister.php');
14			include ('utils/queryResponder.php');
15			$queryL = new queryLister;
16
17
18			$iov_val = isset($_POST['IOV_name']) ? ($_POST['IOV_name']) : '';
19
20			?>
21			<!-- <p>
22			<!-- <table class="main_part">
23			<tr><td class="in_main_tile_td">
24			Get information about production requests:
25			</td></tr>
26			<tr><td>
27
28			<? /*
29			echo '<form name="get_IOV_TAG" method="post" action='. $_SERVER['PHP_SELF'].'>
30			IOV name <input type="text" name="IOV_name" value="'.$iov_val.'">';
31			*/ ?>
32			<input type=submit name="IOVSubmit" value="IOVSubmit">
33			</td></tr>
34			</form>
35			-->
36			<?
37			$queryList = $queryL->parse();
38			if (count($queryList) < 1)
39			{
40			echo '  There are no available queries';
41			}
42			else
43			{
44			echo
45			'<h2 class="h2cond" >CondDB:: Bookeeping: </h2>' .
46			'<h4 class="h4cond">Available queries</h4>'.
47			'<form name="selectQuery" method="post" action='. $_SERVER['PHP_SELF'].'>
48			';
49			echo '<select name="sel_query" class="iov" size="10" onclick="submit()">';
50			foreach($queryList as $query)
51			{
52			if (isset($_POST['sel_query']) && ($_POST['sel_query']==$query->name))
53			{
54			echo '<option SELECTED value="'. $query->name.'">'.$query->description.'</option>';
55			}
56			else
57			{
58			echo '<option value="'. $query->name.'">'.$query->description.'</option>';
59			}
60			}
61			echo '</select>';
62			echo '<input type="submit" class="submit" name="chooseQuery" value="Choose query" >'.
63
64			'</form>';
65			//if (isset($_POST['chooseQuery']) \|\| isset($_POST['querySubmit']))
66			//{
67			if (!isset($_POST['sel_query']) && $_SESSION['sel_query']=='')
68			{
69			//no query selected
70			//do nothing
71			'No query selected';
72			}
73			else
74			{
75			/// creates input box for every parameter
76			if (isset($_POST['sel_query']))
77			{
78			$_SESSION['sel_query']= $_POST['sel_query'];
79			}
80			echo
81			'<h4 class="h4cond">Required parameters:</h4>' .
82			'<form name="queryParams" method="post" action='. $_SERVER['PHP_SELF'].' ' .
83			'id="query_form" onSubmit="return validate();">' .
84			'<table class="in_form"> ';
85
86			$_SESSION['has_curs'] = $queryList[($_SESSION['sel_query'])]->has_curs;
87			$_SESSION['out_params'] = $queryList[($_SESSION['sel_query'])]->out_parameters;
88			if (count($queryList[($_SESSION['sel_query'])]->in_parameters)!=0)
89			{
90			foreach($queryList[($_SESSION['sel_query'])]->in_parameters as $param)
91			{
92			echo '<tr><td class="narrow">'.$param.'</td><td class="left_al_form">';
93			if ($param =='production_name' \|\| $param == 'detector_name' \|\|
94			$param == 'service_name')
95			{
96			prepareSelect($param,'request' );
97			}
98			else
99			{
100			$val = isset($_POST[$param]) ? ($_POST[$param]) : '';
101			echo '<input class="wide" type="text" name='.$param.'
102			value='.$val.' >';
103			}
104			echo '</td></tr>';
105			}
106
107			}
108			else
109			{
110			echo '<tr><td class="left_al_form">Selected query does not require any parameters</td>' .
111			'<td></td></tr>';
112			}
113			echo '<tr><td><input type=submit name="querySubmit" value="Submit query"' .
114			'onSubmit="return validate();">' .
115			'</td></tr>
116			' .
117			'</form>' .
118			'</table>';
119			// create parameter form
120			}
121			//}
122			}
123
124			/// QUERY RESULT PRESENTATION
125			if (isset($_POST['querySubmit']))
126			{
127			echo
128			'
129			<h2 class="h2cond">Query result presentation:</h2>
130			' ;
131			$qResp = new queryResponder;
132			$parameters = array();
133			foreach($queryList[($_SESSION['sel_query'])]->in_parameters as $param)
134			{
135			$parameters[$param] = ($_POST[$param]);
136			}
137			echo '<link rel="stylesheet" type="text/css" href="css/cmscond_table.css">';
138			$results = $qResp->getData($queryList[($_SESSION['sel_query'])]->name, $parameters, $_SESSION['has_curs'], $_SESSION['out_params']);
139			$resViewer = new tableViewer($results);
140			$resViewer->showData();
141			echo '<script type="text/javascript" src="js/tableViewer.js"></script>';
142			}
143
144
145			/// IOV info presentation
146			/* if (isset($_POST['IOVSubmit']))
147			{
148			echo '  <tr><td>IOV information presentation';
149			$qResp = new queryResponder;
150			$result = $qResp->getIOVinfo($_POST['IOV_name']);
151			echo '  Information about: '.$_POST['IOV_name'].'</td></tr>';
152			}
153
154			*/
155			include('utils/backButton.php');
156			include('utils/footer.html');
157
158			function prepareSelect($param, $class)
159			{
160			$queryR = new queryResponder;
161			if ($param == 'production_name')
162			{
163			$options = $queryR->getConfigData('production');
164			}
165			elseif ($param == 'detector_name')
166			{
167			$options = $queryR->getConfigData('detector');
168			}
169			elseif ($param == 'service_name')
170			{
171			$options = $queryR->getConfigData('service');
172			}
173			else
174			{
175			echo 'Wrong parameter';
176			}
177			makeDropdown($param, $options,$_SESSION['atr'.$param], $class);
178			/* echo $param.'<select name="'.$param.'" class="select">';
179			foreach ($options as $obj)
180			{
181			if ($_SESSION['atr'.$param]==$obj)
182			{
183			echo '<option selected="selected" value="'.$obj.'">'.$obj.'</option>';
184			}
185			else
186			{
187			echo '<option value="'.$obj.'">'.$obj.'</option>';
188			}
189			}
190
191			echo '
192			</select><br>';
193
194			*/
195			}
196
197
198			?>
199			<script type="text/javascript">
200			function validate() {
201
202			var er = document.getElementById('error_div');
203			var form = document.getElementById('query_form');
204			var msg = '';
205			for (i=0; i <form.elements.length; i++)
206			{
207			if (form.elements[i].value.length < 1)
208			{
209			msg += form.elements[i].name +' has to be entered. ';
210			}
211			}
212			if (msg == '')
213			{
214			return true;
215			er.style.visibility="hidden";
216			}
217			er.textContent = msg;
218			er.style.visibility="visible";
219			window.scroll(0,0);
220			return false;
221			}
222
223			</script>
224