search.php
上传用户:gzy2002
上传日期:2010-02-11
资源大小:1785k
文件大小:3k
- <?php
- // +-------------------------------------------------------------+
- // | DeskPRO v [2.0.1 Production]
- // | Copyright (C) 2001 - 2004 Headstart Solutions Limited
- // | Supplied by WTN-WDYL
- // | Nullified by WTN-WDYL
- // | Distribution via WebForum, ForumRU and associated file dumps
- // +-------------------------------------------------------------+
- // | DESKPRO IS NOT FREE SOFTWARE
- // +-------------------------------------------------------------+
- // | License ID : Full Enterprise License =) ...
- // | License Owner : WTN-WDYL Team
- // +-------------------------------------------------------------+
- // | $RCSfile: search.php,v $
- // | $Date: 2004/02/10 01:34:25 $
- // | $Revision: 1.12 $
- // +-------------------------------------------------------------+
- // | File Details:
- // | - Task search form and processor.
- // +-------------------------------------------------------------+
- error_reporting(E_ALL ^ E_NOTICE);
- include "./../global.php";
- tech_nav('calendar');
- // globalise variables
- $global = array (
- array('year'),
- array('day'),
- array('month'),
- array('week')
- );
- rg($global);
- require_once(INCLUDE_PATH . 'functions/calendar_functions.php');
- if ($_REQUEST['yenddate'] && $_REQUEST['menddate'] && $_REQUEST['denddate']) {
- $ed = $_REQUEST['yenddate'].'-'.$_REQUEST['menddate'].'-'.$_REQUEST['denddate'];
- } else {
- $ed = $date;
- }
- if ($_REQUEST['ystartdate'] && $_REQUEST['mstartdate'] && $_REQUEST['dstartdate']) {
- $sd = $_REQUEST['ystartdate'].'-'.$_REQUEST['mstartdate'].'-'.$_REQUEST['dstartdate'];
- } else {
- $sd = '';
- }
- switch ($_REQUEST['completed']) {
- default:
- case 'all':
- $all = 'checked'; break;
- case 'complete':
- $complete = 'checked'; break;
- case 'incomplete':
- $incomplete = 'checked'; break;
- }
- echo "<form method="post" action="index.php">n";
- echo form_hidden('search', '1');
- $table[] = array('<B>Title Contains</B><BR>List only tasks whose title contains ...', form_input('title', $_REQUEST['title'], 20));
- $table[] = array('<B>Description Contains</B><BR>List only tasks whose description contains ...', form_input('description', $_REQUEST['description'], 20));
- $table[] = array('<B>Search Range</B><BR>List only tasks (or repeats) that fall within the specified range', '<B>From:</B><BR>' . form_date('startdate', '', '', '', 1, $sd) . '<BR><BR><B>To:</B><BR>' . form_date('enddate', '', '', '', '', $ed));
- $table[] = array('<B>Status</B><BR>List only tasks that are (in)complete',
- form_radio_single('completed', 'all', $all) . " All " .
- form_radio_single('completed', 'complete', $complete) . " Complete ".
- form_radio_single('completed', 'incomplete', $incomplete) . " Incomplete ");
- $db->query("SELECT id,username FROM tech order by username");
- while ($result = $db->row_array()) {
- $tech[$result[id]] = $result['username'];
- }
- $total = $db->num_rows();
- if ($total < 10) {
- $selsize = $total;
- } else {
- $selsize = 10;
- }
- $tmp .= form_select('techs', $tech, '', explode('|', $_REQUEST['techs']), '', '', $selsize);
- $table[] = array('<B>Assigned Technician(s)</B><BR>List only tasks assigned to technician(s) ...', $tmp);
- $width = array('60%', '40%');
- table_header('Search Tasks');
- table_content('', $table, '', '', '', '', $width);
- table_footer();
- echo "<center><input type="submit" name="submit" value="Search Tasks"></center></form>";
- tech_footer();
- ?>