path: root/admin/survey/classes/class.Setting.php

<?php
// star class. Nasomesti ga class.SurveyMissingValues

/*
 * Created on 20.5.2009
 *
 */

class Setting
{
	static private $instance;

	// nastavitve sistema
	static private $sysSetting = array();

	// nastavitve ankete
	static private $srvSetting = array();

	// nastavitve uporabnika
	static private $usrSetting = array();

	// userId
	static private $uid = null;

	static private $mySqlResult = null;
	static private $mySqlErrNo = null;

	// konstrutor
	protected function __construct() {}
	// kloniranje
	private function __clone() {}

	/** Poskrbimo za samo eno instanco razreda
	 *
	 */
	static function getInstance()
	{
		if(!self::$instance)
		{
			self::$instance = new Setting();
		}
		return self::$instance;
	}

	/** inicializacija */

	static function Init( $_userId = null )
	{
		if ( $_userId )
			{ self::$uid = $_userId; }
		self::refreshData();
	}


	// nastavimo nov User Id
	static function setUID( $_userId )
	{
		if ( $_userId )
			{ self::$uid = $_userId; }
		$this->refreshData();
	}

	// osvežimo podatke nastavitev
	static function refreshData()
	{
		// nastavitve sistema
		self::getSystemSetting();
		// nastavitve ankete

		// nastavitve uporabika
	}

	static function getSystemSetting()
	{
		//$stringSystemSetting =  "SELECT * FROM srv_settng "

	}

	/** @desc: polovi sistemske filtre */
	private static $_systemFilters = array();
	private static $_systemFiltersArray;
	static function GetSystemFilters($filter=null)
	{
		if (!$filter) {
			if (isset(self::$_systemFiltersArray)) {
				return self::$_systemFiltersArray;
			}
			else {
				$result = array();
				$stringSystemSetting_filters =  "SELECT * FROM srv_sys_filters ORDER BY type, filter ASC";
				$sqlSystemSetting_filters = sisplet_query($stringSystemSetting_filters );
			    while ( $rowSystemSetting_filters = mysqli_fetch_assoc($sqlSystemSetting_filters) )
			    {
			    	$result[] = $rowSystemSetting_filters;
			    }
			    	self::$_systemFiltersArray = $result;
				return self::$_systemFiltersArray;
			}
		}
		else {
			if (isset(self::$_systemFilters[$filter]))
				return self::$_systemFilters[$filter];
			else
			{
				$stringSystemSetting_filters =  "SELECT * FROM srv_sys_filters where filter = '".$filter."'";
				$sqlSystemSetting_filters = sisplet_query($stringSystemSetting_filters );
			    $result = mysqli_fetch_assoc($sqlSystemSetting_filters);
				self::$_systemFilters[$filter] = $result;
				return $result;
			}
		}
	}

	// vrne array z sistemskimi filtri
	private static $_systemFiltersValues;
	static function GetSystemFiltersValues()
	{
		if (isset(self::$_systemFiltersValues)) {
			return self::$_systemFiltersValues;
		}
		else {
			$result = array();
			$stringSystemSetting_filters =  "SELECT filter FROM srv_sys_filters ORDER BY type, filter ASC";
			$sqlSystemSetting_filters = sisplet_query($stringSystemSetting_filters );
		    while ( $rowSystemSetting_filters = mysqli_fetch_assoc($sqlSystemSetting_filters) )
		    {
		    	$result[$rowSystemSetting_filters['filter']] = $rowSystemSetting_filters['filter'];
		    }
		    self::$_systemFiltersValues = $result;
			return self::$_systemFiltersValues;
		}
	}

	private static $_systemFiltersByType = array();
	static function GetSystemFlterByType($type)
	{
		if (isset(self::$_systemFiltersByType[$type]))
			return self::$_systemFiltersByType[$type];
		else {
			$result = array();
			$stringSystemSetting_filters =  "SELECT * FROM srv_sys_filters WHERE type = '".$type."' ORDER BY filter ASC";
			$sqlSystemSetting_filters = sisplet_query($stringSystemSetting_filters );
		    while ( $rowSystemSetting_filters = mysqli_fetch_assoc($sqlSystemSetting_filters) )
		    {
		    	$result[] = $rowSystemSetting_filters;
		    }
		    self::$_systemFiltersByType[$type] = $result;
			return self::$_systemFiltersByType[$type];
		}
	}

	/** desc: vrnemo sistemsko privzete nastavtive filtrov
	 *  (v opisnih statistikah so vsi filtri vključeni, v frekvencah pa izključeni)
	 */
	private static $_systemFiltersDefaultValues = array();
	static function GetSystemFlterDefaultValues($fid)
	{
		if (isset(self::$_systemFiltersDefaultValues[$fid]))
			return self::$_systemFiltersDefaultValues[$fid];
		else {
	    	$result = array('means'=>false, 'crosstab'=>false, 'frequencies'=>false, 'descriptives'=>true);
		    self::$_systemFiltersByType[$fid] = $result;
			return self::$_systemFiltersByType[$fid];
		}
	}


	// vrne true če je $key v tabeli z filtri
	private static $_systemFiltersValue;
	static function isSystemFiltersValue($key)
	{
		$stringSystemSetting_filters =  "SELECT count(id) as cnt FROM srv_sys_filters where filter = '".$key."'";
		$sqlSystemSetting_filters = sisplet_query($stringSystemSetting_filters );
	    $row = mysqli_fetch_assoc($sqlSystemSetting_filters);
	    return $row['cnt'];
	}

	static function AddSystemFilters( $filter, $text, $fid)
	{
		$insertString = "INSERT INTO srv_sys_filters (fid,filter,text,uid,type) ".
			"VALUES ('".$fid."', '".$filter."', '".$text."', '".self::$uid."', '3');";
		self::$mySqlResult = sisplet_query($insertString);
		self::$mySqlErrNo = mysqli_errno($GLOBALS['connect_db']);
	}
	static function DeleteSystemFilters( $id)
	{
		$deleteString = "DELETE FROM srv_sys_filters WHERE id = '".$id."'";
		self::$mySqlResult = sisplet_query($deleteString);
		self::$mySqlErrNo = mysqli_errno($GLOBALS['connect_db']);
	}
	static function SaveSystemFilters($id,$filter,$text)
	{
		$updateString = "UPDATE srv_sys_filters " .
						"SET filter = '".$filter."', text = '".$text."' ".
						"WHERE id = '".$id."'";
		self::$mySqlResult = sisplet_query($updateString);
		self::$mySqlErrNo = mysqli_errno($GLOBALS['connect_db']);
	}

	private static $_systemSysVarFlterData = array();
	static function GetSystemSysVarFlterData($id)
	{
		if (isset(self::$_systemSysVarFlterData[$id])) {
			return self::$_systemSysVarFlterData[$id];
		}
		else {
			$stringSystemSetting_filters =  "SELECT * FROM srv_sys_filters WHERE id = '".$id."'";
			$sqlSystemSetting_filters = sisplet_query($stringSystemSetting_filters );
		  	$result = mysqli_fetch_assoc($sqlSystemSetting_filters);
		  	self::$_systemSysVarFlterData[$id] = $result;
			return self::$_systemSysVarFlterData[$id];
		}
	}

	/** Hendla prikaz filtrov v nastavitvah
	 *
	 */
	static function DisplaySystemFilters($mode='normal')
	{
		global $lang;
		global $s;
		$filtri = self::GetSystemFilters();
		if ( $mode=='normal' )
		{
			echo '<a href="#" onClick="sysFilterEditMode(\'edit\'); return false;">';
			echo '<span class="faicon edit small"></span>'
					.$lang['srv_settings_filter_edit_mode']. '</a>';
			echo '<div class="clr"></div>';
				echo '<div style="clear:both; padding:5px; height:1.2em">';

				echo '<div style="width:40px; float:left; text-align:left; padding-right:15px; text-align:right">';
				echo '<i style="color:gray; text-align:right">'.$lang['srv_filter_id'].'</i>';
				echo '</div>';

				echo '<div style="width:50px; float:left; text-align:left; padding-right:15px;">';
				echo '<i style="color:gray;text-align:right">'.$lang['srv_filter_vrednost'].'</i>';
				echo '</div>';

				echo '<div class="" style="width:250px; float:left; color: gray">';
				echo '<i style="color:gray;">'.$lang['srv_filter_variabla'].'</i>';
				echo '</div>';

				echo '</div>';

			foreach ( $filtri as $key => $filter)
			{
				echo '<div id="sysfilter_div_'.$filter['id'].'" style="clear:both; padding-bottom:0px; height:1.2em;">';
					echo '<div id="sysfilter_filter_'.$filter['id'].'" class="spr_sysFilter'.$filter['type'].'" style="width:40px; float:left; text-align:left; padding-right:15px; color:gray; text-align:right;">'.$filter['fid'].'</div>';
					echo '<div id="sysfilter_filter_'.$filter['id'].'" class="spr_sysFilter'.$filter['type'].'" style="width:50px; float:left; text-align:left; padding-right:15px; text-align:right;">'.$filter['filter'].'</div>';
					echo '<div id="sysfilter_text_'.$filter['id'].'" class="spr_sysFilter'.$filter['type'].'" style="width:250px; float:left;">'.$filter['text'].'</div>';
				echo '</div>';
			}
		}
		else
		if ( $mode=='edit' || $mode=='new')
		{
			echo '<a href="/" onClick="sysFilterEditMode(\'normal\'); return false;">';
			echo '<span class="faicon mapca anketa small"></span>'
					.$lang['srv_settings_filter_view_mode']. '</a>';

				echo '<div style="clear:both; padding:5px; height:1.2em">';

				echo '<div style="width:40px; float:left; text-align:left; padding-right:15px; text-align:right">';
				echo '<i style="color:gray; text-align:right">'.$lang['srv_filter_id'].'</i>';
				echo '</div>';

				echo '<div style="width:50px; float:left; text-align:left; padding-right:15px;">';
				echo '<i style="color:gray;">'.$lang['srv_filter_vrednost'].'</i>';
				echo '</div>';

				echo '<div class="" style="width:250px; float:left; color: gray">';
				echo '<i style="color:gray;">'.$lang['srv_filter_variabla'].'</i>';
				echo '</div>';

				echo '</div>';
			foreach ( $filtri as $key => $filter)
			{

				echo '<div id="sysfilter_div_'.$filter['id'].'" style="clear:both; padding:5px; height:1.2em">';

				echo '<div id="sysfilter_filter_'.$filter['id'].'" class="" style="width:40px; float:left; text-align:left; padding-right:15px; color:gray; text-align:right;">'.$filter['fid'].'</div>';

				echo '<div id="sysfilter_filter_'.$filter['id'].'" class="" style="width:50px; float:left; text-align:left; padding-right:15px; text-align:right;">';
				echo '<input id="sysfilter_filter_input_'.$filter['id'].'" type="text" value="'.$filter['filter'].'" title="'.$filter['filter'].'" size="6" maxlength="6">';
				echo '</div>';

				echo '<div id="sysfilter_text_'.$filter['id'].'" class="" style="width:250px; float:left;">';
				echo  '<input id="sysfilter_text_input_'.$filter['id'].'" type="text" value="'.$filter['text'].'" title="'.$filter['text'].'" size="45" maxlength="100">';
				echo '</div>';

				if ( $filter['type'] == 3)
				{
					echo '<div id="sysfilter_edit_'.$filter['id'].'" class="" style="width:100px; float:left;">';
					echo '<a href="/" onClick="sysFilterDelete('.$filter['id'].'); return false;">';
					echo '<img id="sysfilter_delete_'.$filter['id'].'" src="img_'.$s->skin.'/delete_red.png" alt="'.$lang['srv_filtri_izbrisi_filter'].'" style="vertical-align:text-bottom " />';
					echo '</a>';
					echo '</div>';
				}
				echo '</div>';
				echo '<script>';
				echo '$(document).ready(function() {';
				echo '$("#sysfilter_delete_'.$filter['id'].'").click(function(e)  {});';
				echo '$("#sysfilter_filter_input_'.$filter['id'].'").blur(function(e)  {sysFilterSave('.$filter['id'].'); return false;});';
				echo '$("#sysfilter_text_input_'.$filter['id'].'").blur(function(e)  {sysFilterSave('.$filter['id'].'); return false;});';
				echo '$("#sysfilter_extra_'.$filter['id'].'").click(function(e)  {sysFilterExtraSetting('.$filter['id'].'); return false;});';

				echo '});';
				echo '</script>';
			}
			echo '<div class="clr"></div>';
			// pohendlamo error: duplicate
			if (self::$mySqlErrNo == 1062)
			{
				echo '<div id="error" class="red">';
				echo $lang['srv_duplicateEntry'];
				echo '</div>';
			}

			echo '<div id="sysfilter_new" style="padding-top:10px;">';
			if ($mode == 'new')
			{
				echo '<div id="sysfilter_div_add" style="clear:both; padding:5px; height:1.2em">';

				echo '<div id="sysfilter_filter_add" style="width:40px; float:left; text-align:left; padding-right:15px;">';
				echo '<input id="sysfilter_fid_input_add" type="text" value="'.$filter['fid'].'" title="'.$filter['fid'].'" size="6" maxlength="6">';
				echo '</div>';

				echo '<div id="sysfilter_filter_add" class="" style="width:50px; float:left; text-align:left; padding-right:15px;">';
				echo '<input id="sysfilter_filter_input_add" type="text" value="'.$filter['filter'].'" title="'.$filter['filter'].'" size="6" maxlength="6">';
				echo '</div>';

				echo '<div id="sysfilter_text_add" class="" style="width:250px; float:left;">';
				echo  '<input id="sysfilter_text_input_add" type="text" value="'.$filter['text'].'" title="'.$filter['text'].'" size="45" maxlength="100">';
				echo '</div>';

				echo '<div class="" style="width:50px; float:left;">';
				echo '<img id="sysfilter_add_img" src="icons/icons/accept.png" alt="'.$lang['srv_novfilter'].'" style="vertical-align:text-bottom " />';
				echo '</div>';
			}
			else
				echo '<img id="sysfilter_new_img" src="img_'.$s->skin.'/add.png" alt="'.$lang['srv_novfilter'].'" style="vertical-align:text-bottom " />'.$lang['srv_novfilter'];
			echo '</div>';
			echo '<script>';
			echo '$(document).ready(function() {';
			echo '$("#sysfilter_new_img").click(function(e) {sysFilterEditMode(\'new\'); return false;});';
			echo '$("#sysfilter_add_img").click(function(e) {sysFilterEditMode(\'add\'); return false;});';
			echo '});';
			echo '</script>';

		}

	}

	/**
	 * @desc polovimo nastavitev survey sistema
	 */
	private static $_sysMiscSetting = array();
	function getSysMiscSetting($what=null)
	{
		if (isset(self::$_sysMiscSetting[$what])) {
			return self::$_sysMiscSetting[$what];
		}
		else
		{
			$result = null;
			if (is_string($what))
			{
				$stringSelect = "SELECT value FROM srv_misc WHERE what = '".$what."'";
				$sqlSelect = sisplet_query($stringSelect);
				$rowSelect = mysqli_fetch_array($sqlSelect);
				if (mysqli_num_rows($sqlSelect) > 0)
					$result = $rowSelect['value'];
				else
					$result = '';
			}
			if($result == ''&&$what == 'export_data_type'){
				$result = 2;
			}			
			self::$_sysMiscSetting[$what] = $result;
			return self::$_sysMiscSetting[$what];
		}
	}
	/**
	 * @desc shranimo nastavitev survey sistema
	 */
	function setSysMiscSetting($what=null, $value=null)
	{
		if ( $what && $value )
		{
			if ( is_string($what) && is_string($value) )
			{
				$stringInsert = "INSERT INTO srv_misc (what, value) VALUES ('".$what."', '".$value."') ON DUPLICATE KEY UPDATE value = '".$value."'";
				$sqlInsert = sisplet_query($stringInsert);
				return mysqli_affected_rows($GLOBALS['connect_db']);
			}
			else
				return false;
		}
		else
			return false;
	}
}
/*
function getTableNextAutoIncrement($tableName)
{
	$next_increment 	= 0;
	$qShowStatus 		= "SHOW TABLE STATUS LIKE '$tableName'";
	$qShowStatusResult 	= sisplet_query($qShowStatus) or die ( "Query failed: " . mysqli_error($GLOBALS['connect_db']) . "<br/>" . qShowStatus );


	while ($row = mysqli_fetch_assoc($qShowStatusResult)) {
		$next_increment = $row['Auto_increment'];
	}
	mysqli_free_result($qShowStatusResult);
	return $next_increment;


}
*/
?>