config.inc.php

<?php

class Config{
	var $ParameterArray;
	var $defaults;
	
	function Config(){
		global $dbh;
		
		//Get parameter value pairs from fac_Config
		$sql='select Parameter, Value, DefaultVal from fac_Config';
                $sth=$dbh->prepare($sql);
                $sth->execute();
		while ($row = $sth->fetch()) {
			if ($row['Parameter']== 'ClassList'){
				$List = explode(', ', $row['Value']);
				$this->ParameterArray[$row['Parameter']]=$List;
				$this->defaults[$row['Parameter']]=$row['DefaultVal'];
			}else{
				// this allows us to support quotes in paths for whatever reason
				if(preg_match('/.*path$/',$row['Parameter'])){
					$this->ParameterArray[$row['Parameter']]=html_entity_decode($row['Value'],ENT_QUOTES);
				}else{
					$this->ParameterArray[$row['Parameter']]=$row['Value'];
				}
				$this->defaults[$row['Parameter']]=$row['DefaultVal'];
			}
		}
		return;
	}

	function UpdateConfig(){
		global $dbh;
		
		foreach($this->ParameterArray as $key=>$value){
			if ($key=='ClassList'){
				$numItems=count($value);
				$i=0;
				$valueStr='';
				foreach($value as $item){
					$valueStr .= $item;
					if($i+1 != $numItems){
						$valueStr.=', ';
					}
					$i++;
				}
					
				$sql='update fac_Config set Value=\''.sanitize($valueStr).'\' where Parameter=\''.$key.'\'';
				if(!$dbh->query($sql)){
					$info=$dbh->errorInfo();
					error_log("UpdateConfig::PDO Error: {$info[2]} SQL=$sql");
				}
			}else{
				if(preg_match('/[m|w]Date/',$key)){
					if($value!='now'){$value='blank';} // if someone puts a weird value in default it back to blank
				}
				$sql="update fac_Config set Value=\"".sanitize($value)."\" where Parameter=\"$key\";";
				if(!$dbh->query($sql)){
					$info=$dbh->errorInfo();
					error_log("UpdateConfig::PDO Error: {$info[2]} SQL=$sql");
				}
			}
		}
		return;
	}
	
	static function UpdateParameter($parameter,$value){
		global $dbh;

		if(is_null($parameter) || is_null($value)){
			return false;
		}else{
			$sql="UPDATE fac_Config SET Value=\"$value\" WHERE Parameter=\"$parameter\";";
			if($dbh->query($sql)){
				return true;
			}else{
				$info=$dbh->errorInfo();
				error_log("UpdateParamter::PDO Error: {$info[2]} SQL=$sql");
				return false;
			}
		}
	}

	static function RevertToDefault($parameter){
		global $dbh;
		
		if($parameter=='none'){
			$sql='UPDATE fac_Config SET Value=DefaultVal;';
		}else{
			$sql="UPDATE fac_Config SET Value=DefaultVal WHERE Parameter=\"$parameter\";";
		}
		
		$dbh->query($sql);
		return;
	}
	
	function Rebuild (){
/* Rebuild: This function should only be needed after something like the version erasing glitch from 1.1 and 1.2.
			At this time it is possible to get unwanted duplicate configuration parameters and this will clean
			them.

			I am not sanitizing input here because it should have no user interaction.  Read from the db, flush
			db, write unique values back to the db.
*/
		global $dbh;
		
		$sql='select * from fac_Config';
		
		$uniqueconfig=array();

		// Build array of unique config parameters
		foreach ( $dbh->query( $sql ) as $row){
			if(isset($uniqueconfig[$row['Parameter']]['Value'])){
				// if value in the array is equal to the default value AND the current value is different from the value in the array update the value in the array
				if($uniqueconfig[$row['Parameter']]['Value']==$row['DefaultVal'] && $uniqueconfig[$row['Parameter']]['Value']!=$row['Value']){
					$uniqueconfig[$row['Parameter']]['Value']=$row['Value'];
				}
			}else{
				// value wasn't set in the array so we'll take whatever we're given even if it is the default value
				$uniqueconfig[$row['Parameter']]['Value']=$row['Value'];
			}
			// the following aren't user configurable so no need to check for differences
			$uniqueconfig[$row['Parameter']]['UnitOfMeasure']=$row['UnitOfMeasure'];
			$uniqueconfig[$row['Parameter']]['ValType']=$row['ValType'];
			$uniqueconfig[$row['Parameter']]['DefaultVal']=$row['DefaultVal'];
		}

		// Empty config table
		$dbh->exec('TRUNCATE TABLE fac_Config;');

		// Rebuild config table from cleaned array
		$sth = $dbh->prepare( "INSERT INTO fac_Config VALUES ( :key, :value, :unitofmeasure, :valtype, :defaultval )" );
		
		foreach($uniqueconfig as $key => $row){
			$sth->execute( array( ':key' => $key, ':value' => $row['Value'], ':unitofmeasure' => $row['UnitOfMeasure'], ':valtype' => $row['ValType'], ':defaultval' => $row['DefaultVal'] ) ); 
		}
	}
}
?>