Location: PHPKode > projects > SimpleHRM > simplehrm-1.0-beta1/simplehrm-1.0-beta1/flexycms/modules/company/business/company_bl.class.php
<?php
class company_bl extends business{
##########################################################
### Function Name : generalConf			       ###
### Description   : Function to select comapnt details ###
### Input         : No input 			       ###
### Ouput 	  : sql query		      	       ###
##########################################################
	function generalConf(){
		$sql = "SELECT c.*,t.* FROM ".TABLE_PREFIX."company AS c,".TABLE_PREFIX."timezone AS t 
			WHERE c.id_company = ".$_SESSION['id_company']." 
				AND c.timezone = t.timezone_value 
				LIMIT 1";
		return $sql;
	}
};
Return current item: SimpleHRM