system/evt_log.class.php

<?php
/*******************************************************************************
 * Copyright (c) 2007 Eclipse Foundation and others.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *    Denis Roy (Eclipse Foundation)- initial API and implementation
 *******************************************************************************/

define('MAX_LOG_DAYS', 365);

require_once("/home/data/httpd/eclipse-php-classes/system/dbconnection_rw.class.php");

class EvtLog {

	#*****************************************************************************
	#
	# evt_log.class.php
	#
	# Author: 		Denis Roy
	# Date:			2004-08-05
	#
	# Description: Functions and modules related to a modification log entry
	#
	# HISTORY:
	#
	#*****************************************************************************


	
	var $LogID 		= 0;
	var $LogTable		= "";
	var $PK1		= "";
	var $PK2		= "";
	var $LogAction		= "";
	var $uid		= "";
	var $EvtDateTime	= "";
	
	function getLogID() {
		return $this->LogID;
	}
	function getLogTable() {
		return $this->LogTable;
	}
	function getPK1() {
		return $this->PK1;
	}
	function getPK2() {
		return $this->PK2;
	}
	function getLogAction() {
		return $this->LogAction;
	}
	function getuid() {
		return $this->PersonID;
	}
	function getEvtDateTime() {
		return $this->EvtDateTime;
	}


	function setLogID($_LogID) {
		$this->LogID = $_LogID;
	}
	function setLogTable($_LogTable) {
		$this->LogTable = $_LogTable;
	}
	function setPK1($_PK1) {
		$this->PK1 = $_PK1;
	}
	function setPK2($_PK2) {
		$this->PK2 = $_PK2;
	}
	function setLogAction($_LogAction) {
		$this->LogAction = $_LogAction;
	}
	function setuid($_uid) {
		$this->uid = $_uid;
	}
	function setEvtDateTime($_EvtDateTime) {
		$this->EvtDateTime = $_EvtDateTime;
	}

	function insertModLog ($_uid) {
		$uid = $_uid;
		if($this->getLogTable() != "" && $this->getPK1() != "" && $this->getLogAction() != "" && $uid != "") {
			$App = new App();
			$dbc = new DBConnectionRW();
			$dbh = $dbc->connect();
			
			$sql = "INSERT INTO SYS_EvtLog (
						LogID,
						LogTable,
						PK1,
						PK2,
						LogAction,
						uid,
						EvtDateTime)
					VALUES (
						NULL,
						" . $App->returnQuotedString($App->sqlSanitize($this->getLogTable(),$dbh)) . ",
						" . $App->returnQuotedString($App->sqlSanitize($this->getPK1(),$dbh)) . ",
						" . $App->returnQuotedString($App->sqlSanitize($this->getPK2(),$dbh)) . ",
						" . $App->returnQuotedString($App->sqlSanitize($this->getLogAction(),$dbh)) . ",
						" . $App->returnQuotedString($App->sqlSanitize($uid),$dbh) . ",
						NOW()
					)";
					
			mysql_query($sql, $dbh);
			if(mysql_error() != "") {
				echo "An unknown database error has occurred while logging information.  Please contact the System Administrator.";
				echo mysql_error();
				exit;
			}
			
			$dbc->disconnect();
			
			# 1% of each hits will perform clean up	
			if(rand(0, 100) < 1) {
				$this->cleanup();
			}
		}
		else {
			echo "An unknown system error has occurred while logging information.  Please contact the System Administrator.";
			exit;
		}
	}
	
	function cleanup() {
		$sql = "DELETE FROM SYS_EvtLog WHERE EvtDateTime < " . MAX_LOG_DAYS;
					
		$dbc = new DBConnectionRW();
		$dbh = $dbc->connect();
		mysql_query($sql, $dbh);
		$dbc->disconnect();
	}
}
?>