\n";
echo " \n";
debug(2);
// ************ set defaults ************
if (empty($_REQUEST['log_start']))
$_REQUEST['log_start'] = date("H:i");
if (empty($_REQUEST['log_end']))
$_REQUEST['log_end'] = $_REQUEST['log_start'];
if (array_key_exists("listlimit", $_REQUEST))
{
// save new search parameters
$_SESSION['changelogsearch']['type'] = $_REQUEST['type'];
$_SESSION['changelogsearch']['target'] = $_REQUEST['target'];
$_SESSION['changelogsearch']['fdate'] = $_REQUEST['fdate'];
$_SESSION['changelogsearch']['tdate'] = $_REQUEST['tdate'];
$_SESSION['changelogsearch']['client'] = $_REQUEST['client'];
$_SESSION['changelogsearch']['expression'] = str_replace("´", "'", $_REQUEST['expression']);
$_SESSION['changelogsearch']['listlimit'] = $_REQUEST['listlimit'];
}
// no search parameters sent
if (empty($_SESSION['changelogsearch']['listlimit']))
$_SESSION['changelogsearch']['listlimit'] = 50;
if (empty($_SESSION['changelogsearch']['target']))
$_SESSION['changelogsearch']['target'] = "log_comment";
// ********** end set defaults **********
// ************* preprocess *************
if (array_key_exists("updateidx", $_REQUEST))
{
$q = "log_owner = '{$_SESSION['user']['empNo']}', ";
$q .= "log_client = '{$_REQUEST['log_client']}', ";
$q .= "log_date = '".str_replace(array("-",".","/","\\",":"),"", $_REQUEST['log_date'])."', ";
$q .= "log_start = '".str_replace(array("-",".","/","\\",":"),"", $_REQUEST['log_start'])."', ";
$q .= "log_end = '".str_replace(array("-",".","/","\\",":"),"", $_REQUEST['log_end'])."', ";
$q .= "log_source = '{$_REQUEST['log_source']}', ";
$q .= "log_method = '{$_REQUEST['log_method']}', ";
$q .= "log_area = '{$_REQUEST['log_area']}', ";
$q .= "log_tags = '{$_REQUEST['log_tags']}', ";
$q .= "log_email_id = '{$_REQUEST['log_email_id']}', ";
$q .= "log_comment = '{$_REQUEST['log_comment']}'";
if (empty($_REQUEST['updateidx']))
{
// // new entry
sqlInsert("changelog", $q);
}
else
{
// edit existing entry
sqlUpdate("changelog", $q, "tid = '{$_REQUEST['updateidx']}'");
}
}
if (!empty($_REQUEST['editidx']))
{
// load an entry for edit
$q = "select * from changelog where tid='{$_REQUEST['editidx']}'";
$logent = sqlEx($q);
$logent = mysql_fetch_assoc($logent);
}
// *********** end preprocess ***********
$q = "select log_client from changelog where log_owner = '{$_SESSION['user']['empNo']}' group by log_client order by log_client";
$cList = sqlEx($q);
while ($c = mysql_fetch_assoc($cList))
$clientList[] = $c['log_client'];
echo "
UnDocumented Work Log \n";
// form for editing or entering an entry
echo "New Entry \n";
if (empty($logent['log_date']))
$logent['log_date'] = date("Y-m-d");
echo "\n";
// form for searching
echo "Search the Log \n";
echo "
\n";
echo " \n";
?>
|