search.php

本代码是为客户联系管理而做的系统

<?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) .  "&nbsp;All&nbsp;" . 
	form_radio_single('completed', 'complete', $complete) . "&nbsp;Complete&nbsp;". 
	form_radio_single('completed', 'incomplete', $incomplete) . "&nbsp;Incomplete&nbsp;");

$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();
?>