\n"; // generate log listing $q = "select * from changelog where log_owner='{$_SESSION['user']['empNo']}' "; if (!empty($_SESSION['changelogsearch']['fdate'])) { $sdate = "log_date >= '".str_replace(array("-",".","/","\\",":"),"", $_SESSION['changelogsearch']['fdate'])."'"; } if (!empty($_SESSION['changelogsearch']['tdate'])) { if (!empty($sdate)) { $sdate .= " and "; } $sdate .= "log_date <= '".str_replace(array("-",".","/","\\",":"),"", $_SESSION['changelogsearch']['tdate'])."'"; } if (!empty($sdate)) $sldate = " and ($sdate)"; if (!empty($_SESSION['changelogsearch']['expression'])) { // we have a search target; is it text or regex? if ($_SESSION['changelogsearch']['type'] == "TEXT") { // text search $q .= "and {$_SESSION['changelogsearch']['target']} LIKE '%{$_SESSION['changelogsearch']['expression']}%'".$sldate." "; } else if ($_SESSION['changelogsearch']['type'] == "REGEX") { // regex search $q .= "and {$_SESSION['changelogsearch']['target']} REGEXP '{$_SESSION['changelogsearch']['expression']}'$sldate "; } else { // free-form sql search $q .= "and {$_SESSION['changelogsearch']['expression']} "; } if (!empty($_SESSION['changelogsearch']['client'])) $q .= "and log_client = '{$_SESSION['changelogsearch']['client']}' "; } else if (!empty($sdate)) { $q .= "and $sdate "; } $q .= "order by log_date desc,log_start desc,log_end desc"; if (!empty($_SESSION['changelogsearch']['listlimit'])) $q .= " limit ".$_SESSION['changelogsearch']['listlimit']; $logList = sqlEx($q); debugMarker("Log Query: \"$q\""); $_SESSION['changelogsearch']['cnt'] = mysql_num_rows($logList); if ($_SESSION['changelogsearch']['cnt'] == 0) echo "No Responsive Records
\n"; else { echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($logentry = mysql_fetch_assoc($logList)) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "

Date	Start	End	Source	Comment
".formatDate($logentry['log_date'])."	".formatTime($logentry['log_start'])."	".formatTime($logentry['log_end'])."	{$logentry['log_source']}	".str_replace("\n", " ", $logentry['log_comment'])."

\n"; } echo "\n"; ?>