<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Action_controller.php");
class Profile  extends Action_controller{	
	public function __construct(){
		parent::__construct('profile');
	}
	
	// LOAD PAGE QUICK LINK,FILTERS AND TABLE HEADERS
	public function index(){
		//query for offer_letter and profile picture for profile page

		$company_query	=	'SELECT display_appointment,hr_policy,display_offer FROM cw_company_information';
		$company_info   =	$this->db->query("CALL sp_a_run ('SELECT','$company_query')");
		$company_result =	$company_info->result();
		$company_info->next_result();

		$profile_query	=	'SELECT profile_picture FROM cw_employees';
		$profile_info   =	$this->db->query("CALL sp_a_run ('SELECT','$profile_query')");
		$profile_result = 	$profile_info->result();
		$profile_info->next_result();
		
		$data['company_result'] =	$company_result;
		$data['profile_result'] =	$profile_result;
		$this->load->view("$this->control_name/manage",$data);
	}
	
}
?>