<?php
/* <summary>
	 Class contains all methods related to store configuration module
	 <author>
	 Beatle Buddy 2017.
	 </author>
	 Version 1.0
   </summary>
*/
class storeconfig
{
	/*<summary>
		Default constructor
	</summary>	
	*/
	function __construct()
	{
	}
	/* <summary>
	 Fetch store id according to the domain
	 </summary>
	 <returns>Return an array contains information of store</returns>
	*/	
	function find_storeid()
	{
		global $objDB;
		$SQL = "SELECT StoreID, StoreName, StoreDisplayName FROM storeconfiguration WHERE StoreDomain = '" . str_replace("http://", "", str_replace("https://", "", SERVER_ROOT)) . "'";		
		$res = $objDB->sql_query($SQL);
		
		if($res)
		{
			return $res;
		}
		else
		{
			$SQL = "SELECT StoreID FROM storeconfiguration WHERE STRCMP( StoreDomain, '". str_replace("http://", "", str_replace("https://", "", SERVER_ROOT)) ."' ) = '1' OR STRCMP( StoreDomain, '". $_SERVER['HTTP_HOST'] ."' ) = '-1'";
			$res = $objDB->sql_query($SQL);
			return $res;
		}
	}	   
	/* <summary>
	 Find applicateion configuration for particular store
	 </summary>
	 <param name="StoreID">int StoreID</param>
	 <returns>Return an array contains application configuration</returns>	
	 */	
	function fetch_appconfig()
	{
		global $objDB;
		$SQL = "SELECT ConfigName, ConfigValue FROM appconfig WHERE Status = 'Y' ";
		$res = $objDB->sql_query($SQL);
		return $res;
	}
	
	/* <summary>
	 Fetch config value from database by config name
	 </summary>
	 <param name="ConfigName">string ConfigName</param>
	 <param name="StoreID">int StoreID</param>	 
	 <returns>Return an array contains config value and config name</returns>	
	*/	
	function appconfig_host($ConfigName)
	{
		global $objDB;
		$SQL = "SELECT ConfigName, ConfigValue FROM appconfig WHERE ConfigName = '".$ConfigName."'";
		$res = $objDB->sql_query($SQL); //echo $SQL; echo "<br>";
		return $res;
	}
}
?>