trunk/admin/res_search.phtml

<?php
// Load globals
require_once ("global_vars.php");

// Includes
require_once ($GLOBAL_ADMIN_INC."sessionClass.php");
require_once ($GLOBAL_ADMIN_INC."accessClass.php");
require_once ($GLOBAL_ADMIN_INC."db_connect.php");
require_once ($GLOBAL_ADMIN_INC."app_controls.php");


// HTML header
printf("<HTML>\n");
printf("<HEAD>\n");
printf("<title>%s Resource Search</title>\n", $GLOBAL_SYS_NAME);
printf("<link rel=\"stylesheet\" href=\"%s\" type=\"text/css\">\n", $GLOBAL_ADMIN_CSS);
printf("</HEAD>\n");


// Page header
require_once ($GLOBAL_ADMIN_HEADER);


// Collect access information
if (isset($libsession)) {

        // Fetch session information
        $sessionClass = new sessionClass("", $libsession, "", "");
        $accessClass = new accessClass($sessionClass);

        // Load user session variables
        $sess_time_human = $sessionClass->time_human;   
        $sess_staff_account = $sessionClass->staff_account;
        $sess_access_level = $accessClass->access_level;
        $sess_access = $accessClass->access;
        $sess_last_name = $accessClass->last_name;
        $sess_first_name = $accessClass->first_name;
        
}


// If the cookie is set and access level is appropriate
if(isset($libsession) && $sess_access_level >= 20) {
?>

        <center>
        <table width="80%" border="1" class="backLight" cellpadding="2">
        <tr>

                <td colspan="4" class="cellPlain" align="center">
                        Resource Search 
                </td>

        </tr>

        <tr>
                <td width="20%">
                        <form method="POST" action="res_results_brief.phtml">
                        <br><b>Resource ID:</b> <input type = "text" name="resource_id" size="6"><br><br>
                </td>

                <td width="20%">
                        <br><b>Catalog Number:</b> <input type="text" name="cat_num" size="20"><br><br>
                </td>

                <td width="60%" colspan = "2" align="center">
                        <input type ="Submit" value="Search"> <input type ="Reset" value= "Reset"><br>
                </td>
        </tr>

        <tr>
                <td>
                        <b>Date Created (format: YYYY-MM-DD):</b>
                </td>

                <td colspan="3" align="left">
                        <input type = "text" name="date_created" size="10"><br>
                </td>
        </tr>

        <tr>
                <td>
                        <b>Date Modified (format: YYYY-MM-DD):</b>
                </td>

                <td colspan="3" align="left">
                        <input type = "text" name="date_modified" size="10"><br>
                </td>
        </tr>

        <tr>
                <td>
                        <b>Creator:</b>
                </td>

                <td colspan="3" align="left">
                        <select name ="account_created">
                        <option value ="">Unselected</option>                   
                        <?php dropDownAccountOmit($con, " WHERE staff_id > 1"); ?>
                        </select>
                        <br>
                </td>
        </tr>
        
        
        <tr>
                <td>
                        <b>Modified by:</b>
                </td>

                <td colspan="3" align="left">
                        <select name ="account_modified">
                        <option value ="">Unselected</option>                   
                        <?php dropDownAccountOmit($con, " WHERE staff_id > 1"); ?>
                        </select>
                        <br>
                </td>
        </tr>   


        <tr>
                <td>
                        <b>Title:</b>
                </td>
                <td colspan="3" align="left">   
                        <input type = "text" name="title" size="30"><br>
                </td>
        </tr>

        <tr>
                <td>
                        <b>Author:</b>
                </td>
                <td colspan="3" align="left">   
                        <input type ="text" name="author" size="30"><br>
                </td>
        </tr>

        <tr>
                <td>
                        <b>Pub. Date (format: YYYY):</b>
                </td>
                <td colspan="3" align="left">   
                        <input type ="text" name="pub_date" size="4"><br>
                </td>
        </tr>

        <tr>
                <td>
                        <b>Base Information Type:</b>
                </td>

                <td colspan="3" align="left">
                        <select name ="infotype_id">
                        <option value ="">Unselected</option>                   
                        <?php dropDownField($con, "infotype", "infotype", "infotype_id", "WHERE infotype_id > 1"); ?>
                        </select>
                        <br>
                </td>
        </tr>   

        <tr>
                <td>
                        <b>Feature:</b>
                </td>

                <td colspan="3" align="left">   
                        <select name="feature_id">
                        <option selected value="0">Unselected</option>
                        <?php dropDownFieldOmit($con, "feature", "feature", "feature_id", "WHERE feature_id > 1"); ?>
                        </select>
                </td>
        </tr>

        <tr>
                <td>
                        <b>Location:</b>
                </td>

                <td colspan="3" align="left">   
                        <select name="location_id">
                        <option selected value="0">Unselected</option>
                        <?php dropDownField($con, "location", "location", "location_id"); ?>
                        </select>
                </td>
        </tr>

        <tr>
                <td>
                        <b>Library/Call Number:</b>
                </td>
                <td colspan="3" align="left">   
                        <input type="text" name="call_no" size="30">
                </td>
        </tr>

        <tr>
                <td>
                        <b>URL (full or partial, example: .gov):</b>
                </td>
                <td colspan="3" align="left">   
                        <input type="text" name="url" size="60">
                </td>
        </tr>

        <tr>
                <td>
                        <b>Annotation (phrase or keyword):</b>
                </td>
                <td colspan="3" align="left">   
                        <input type="text" name="annotation" size="40">
                </td>
        </tr>

        <tr>
                <td colspan="4" class="cellPlain" align="center">
                        Output Parameters
                </td>

        <tr>
                <td colspan="2">
                        <b>Order results by:</b>
                </td>
                <td colspan="2">
                        <b>Direction:</b>
                </td>

        </tr>

        <tr>
                <td width="25%">
                        Title
                </td>
                <td width="8%">
                        <input type="radio" name="orderby" value="title" checked>
                </td>
                <td width="25%">
                        Ascending
                </td>
                <td width="8%">
                        <input type="radio" name="orderdir" value="ASC" checked>
                </td>
        </tr>

        <tr>
                <td width="25%">
                        Author
                </td>
                <td width="8%">
                        <input type="radio" name="orderby" value="author">
                </td>
                <td width="25%">
                        Descending
                </td>
                <td width="8%">
                        <input type="radio" name="orderdir" value="DESC">
                </td>
        </tr>

        <tr>
                <td width="25%">
                        Pub Date
                </td>
                <td colspan="3">
                        <input type="radio" name="orderby" value="pub_date">
                </td>
        </tr>

        <tr>
                <td width="30%">
                        Resource ID
                </td>
                <td colspan="3">
                        <input type="radio" name="orderby" value = "resource_id">
                </td>
        </tr>

        <tr>
                <td width="25%">
                        Date Created
                </td>
                <td colspan="3">
                        <input type="radio" name="orderby" value = "date_created">
                </td>
        </tr>

        <tr>
                <td width="25%">
                        Date Modified
                </td>
                <td colspan="3">
                        <input type="radio" name="orderby" value = "date_modified">
                </td>
        </tr>

        <tr>
                <td align= "center" colspan="4">
                        <br><input type ="Submit" value="Search"> <input type ="Reset" value= "Reset">
                        </form>
                </td>
        </tr>
        </table>

<?php

        // Link to return to admin console
        adminReturn($sess_access_level);

} // logged in

// No access
else require_once ($GLOBAL_NO_ACCESS);


// Page footer
require_once ($GLOBAL_ADMIN_FOOTER);
?>

</body>
</html>
1	dpavlin	16	<?php
2			// Load globals
3			require_once ("global_vars.php");
4
5			// Includes
6			require_once ($GLOBAL_ADMIN_INC."sessionClass.php");
7			require_once ($GLOBAL_ADMIN_INC."accessClass.php");
8			require_once ($GLOBAL_ADMIN_INC."db_connect.php");
9			require_once ($GLOBAL_ADMIN_INC."app_controls.php");
10
11
12			// HTML header
13			printf("<HTML>\n");
14			printf("<HEAD>\n");
15			printf("<title>%s Resource Search</title>\n", $GLOBAL_SYS_NAME);
16			printf("<link rel=\"stylesheet\" href=\"%s\" type=\"text/css\">\n", $GLOBAL_ADMIN_CSS);
17			printf("</HEAD>\n");
18
19
20			// Page header
21			require_once ($GLOBAL_ADMIN_HEADER);
22
23
24			// Collect access information
25			if (isset($libsession)) {
26
27			// Fetch session information
28			$sessionClass = new sessionClass("", $libsession, "", "");
29			$accessClass = new accessClass($sessionClass);
30
31			// Load user session variables
32			$sess_time_human = $sessionClass->time_human;
33			$sess_staff_account = $sessionClass->staff_account;
34			$sess_access_level = $accessClass->access_level;
35			$sess_access = $accessClass->access;
36			$sess_last_name = $accessClass->last_name;
37			$sess_first_name = $accessClass->first_name;
38
39			}
40
41
42			// If the cookie is set and access level is appropriate
43			if(isset($libsession) && $sess_access_level >= 20) {
44			?>
45
46			<center>
47			<table width="80%" border="1" class="backLight" cellpadding="2">
48			<tr>
49
50			<td colspan="4" class="cellPlain" align="center">
51			Resource Search
52			</td>
53
54			</tr>
55
56			<tr>
57			<td width="20%">
58			<form method="POST" action="res_results_brief.phtml">
59			<br><b>Resource ID:</b> <input type = "text" name="resource_id" size="6"><br><br>
60			</td>
61
62			<td width="20%">
63			<br><b>Catalog Number:</b> <input type="text" name="cat_num" size="20"><br><br>
64			</td>
65
66			<td width="60%" colspan = "2" align="center">
67			<input type ="Submit" value="Search"> <input type ="Reset" value= "Reset"><br>
68			</td>
69			</tr>
70
71			<tr>
72			<td>
73			<b>Date Created (format: YYYY-MM-DD):</b>
74			</td>
75
76			<td colspan="3" align="left">
77			<input type = "text" name="date_created" size="10"><br>
78			</td>
79			</tr>
80
81			<tr>
82			<td>
83			<b>Date Modified (format: YYYY-MM-DD):</b>
84			</td>
85
86			<td colspan="3" align="left">
87			<input type = "text" name="date_modified" size="10"><br>
88			</td>
89			</tr>
90
91			<tr>
92			<td>
93			<b>Creator:</b>
94			</td>
95
96			<td colspan="3" align="left">
97			<select name ="account_created">
98			<option value ="">Unselected</option>
99			<?php dropDownAccountOmit($con, " WHERE staff_id > 1"); ?>
100			</select>
101			<br>
102			</td>
103			</tr>
104
105
106			<tr>
107			<td>
108			<b>Modified by:</b>
109			</td>
110
111			<td colspan="3" align="left">
112			<select name ="account_modified">
113			<option value ="">Unselected</option>
114			<?php dropDownAccountOmit($con, " WHERE staff_id > 1"); ?>
115			</select>
116			<br>
117			</td>
118			</tr>
119
120
121			<tr>
122			<td>
123			<b>Title:</b>
124			</td>
125			<td colspan="3" align="left">
126			<input type = "text" name="title" size="30"><br>
127			</td>
128			</tr>
129
130			<tr>
131			<td>
132			<b>Author:</b>
133			</td>
134			<td colspan="3" align="left">
135			<input type ="text" name="author" size="30"><br>
136			</td>
137			</tr>
138
139			<tr>
140			<td>
141			<b>Pub. Date (format: YYYY):</b>
142			</td>
143			<td colspan="3" align="left">
144			<input type ="text" name="pub_date" size="4"><br>
145			</td>
146			</tr>
147
148			<tr>
149			<td>
150			<b>Base Information Type:</b>
151			</td>
152
153			<td colspan="3" align="left">
154			<select name ="infotype_id">
155			<option value ="">Unselected</option>
156			<?php dropDownField($con, "infotype", "infotype", "infotype_id", "WHERE infotype_id > 1"); ?>
157			</select>
158			<br>
159			</td>
160			</tr>
161
162			<tr>
163			<td>
164			<b>Feature:</b>
165			</td>
166
167			<td colspan="3" align="left">
168			<select name="feature_id">
169			<option selected value="0">Unselected</option>
170			<?php dropDownFieldOmit($con, "feature", "feature", "feature_id", "WHERE feature_id > 1"); ?>
171			</select>
172			</td>
173			</tr>
174
175			<tr>
176			<td>
177			<b>Location:</b>
178			</td>
179
180			<td colspan="3" align="left">
181			<select name="location_id">
182			<option selected value="0">Unselected</option>
183			<?php dropDownField($con, "location", "location", "location_id"); ?>
184			</select>
185			</td>
186			</tr>
187
188			<tr>
189			<td>
190			<b>Library/Call Number:</b>
191			</td>
192			<td colspan="3" align="left">
193			<input type="text" name="call_no" size="30">
194			</td>
195			</tr>
196
197			<tr>
198			<td>
199			<b>URL (full or partial, example: .gov):</b>
200			</td>
201			<td colspan="3" align="left">
202			<input type="text" name="url" size="60">
203			</td>
204			</tr>
205
206			<tr>
207			<td>
208			<b>Annotation (phrase or keyword):</b>
209			</td>
210			<td colspan="3" align="left">
211			<input type="text" name="annotation" size="40">
212			</td>
213			</tr>
214
215			<tr>
216			<td colspan="4" class="cellPlain" align="center">
217			Output Parameters
218			</td>
219
220			<tr>
221			<td colspan="2">
222			<b>Order results by:</b>
223			</td>
224			<td colspan="2">
225			<b>Direction:</b>
226			</td>
227
228			</tr>
229
230			<tr>
231			<td width="25%">
232			Title
233			</td>
234			<td width="8%">
235			<input type="radio" name="orderby" value="title" checked>
236			</td>
237			<td width="25%">
238			Ascending
239			</td>
240			<td width="8%">
241			<input type="radio" name="orderdir" value="ASC" checked>
242			</td>
243			</tr>
244
245			<tr>
246			<td width="25%">
247			Author
248			</td>
249			<td width="8%">
250			<input type="radio" name="orderby" value="author">
251			</td>
252			<td width="25%">
253			Descending
254			</td>
255			<td width="8%">
256			<input type="radio" name="orderdir" value="DESC">
257			</td>
258			</tr>
259
260			<tr>
261			<td width="25%">
262			Pub Date
263			</td>
264			<td colspan="3">
265			<input type="radio" name="orderby" value="pub_date">
266			</td>
267			</tr>
268
269			<tr>
270			<td width="30%">
271			Resource ID
272			</td>
273			<td colspan="3">
274			<input type="radio" name="orderby" value = "resource_id">
275			</td>
276			</tr>
277
278			<tr>
279			<td width="25%">
280			Date Created
281			</td>
282			<td colspan="3">
283			<input type="radio" name="orderby" value = "date_created">
284			</td>
285			</tr>
286
287			<tr>
288			<td width="25%">
289			Date Modified
290			</td>
291			<td colspan="3">
292			<input type="radio" name="orderby" value = "date_modified">
293			</td>
294			</tr>
295
296			<tr>
297			<td align= "center" colspan="4">
298			<br><input type ="Submit" value="Search"> <input type ="Reset" value= "Reset">
299			</form>
300			</td>
301			</tr>
302			</table>
303
304			<?php
305
306			// Link to return to admin console
307			adminReturn($sess_access_level);
308
309			} // logged in
310
311			// No access
312			else require_once ($GLOBAL_NO_ACCESS);
313
314
315			// Page footer
316			require_once ($GLOBAL_ADMIN_FOOTER);
317			?>
318
319			</body>
320			</html>