<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
/**
 * CodeIgniter
 *
 * An open source application development framework for PHP 5.1.6 or newer
 *
 * @package		CodeIgniter
 * @author		ExpressionEngine Dev Team
 * @copyright	Copyright (c) 2008 - 2014, EllisLab, Inc.
 * @license		http://codeigniter.com/user_guide/license.html
 * @link		http://codeigniter.com
 * @since		Version 1.0
 * @filesource
 */

	function asset_url(){
		return 'http://developers.activeitzone.com/activesupershopv1.4/';
	}
	
	function img_loading(){
		return base_url().'uploads/others/image_loading.gif';
	}


	function make_proper($text){
		//$text = json_encode($text);
		//$text = json_decode($text,true);
		$text = rawurldecode($text);
		return $text;
	}
	


if ( ! function_exists('create_time_range') ){

	function create_time_range($start, $end, $interval = '30 mins', $format = '12') {

	    $startTime = strtotime($start); 

	    $endTime   = strtotime($end);

	    $returnTimeFormat = ($format == '12')?'g:i A':'G:i:s';

	    $current   = time(); 

	    $addTime   = strtotime('+'.$interval, $current); 

	    $diff      = $addTime - $current;

	    $times = array(); 

	    while ($startTime < $endTime) { 

	        $times[] = date($returnTimeFormat, $startTime); 

	        $startTime += $diff; 

	    } 

	    $times[] = date($returnTimeFormat, $startTime); 

	    return $times; 

	}

}


if ( ! function_exists('getreview') ){

	function getreview($type,$sourceid,$perentid='')
	{
		$CI =& get_instance();

		$CI->db->where('type_of_review', $type);

		$CI->db->where('source_id', $sourceid);
		
		if(!empty($perentid) || $perentid != ""){$CI->db->where('parent', $perentid);}

		$CI->db->order_by('review_id', "DESC");

		$query = $CI->db->get('review');

		return $rslt = $query->result();

	}

}

if ( ! function_exists('_is_front_login') ){

	function _is_front_login(){
		if(get_instance()->session->userdata('user_login') == 'yes'){
			return true;
		}else{
			return false;
		}
	}
}

if ( ! function_exists('m_active_link')){
    function active_link($controller){
        $CI = &get_instance();
        $class = $CI->router->fetch_class();
        return ($class == $controller) ? 'current' : '';        
    }
}

if(!function_exists('active_link_sub_menu')) {
  function active_link_sub_menu($function_name) {
    $CI = get_instance();
    $class = $CI->router->fetch_method();
    return ($class == $function_name) ? 'current' : '';
  }
}

function secondsToTime($inputSeconds) {

    $secondsInAMinute = 60;
    $secondsInAnHour  = 60 * $secondsInAMinute;
    $secondsInADay    = 24 * $secondsInAnHour;

    // extract days
    $days = floor($inputSeconds / $secondsInADay);

    // extract hours
    $hourSeconds = $inputSeconds % $secondsInADay;
    $hours = floor($hourSeconds / $secondsInAnHour);

    // extract minutes
    $minuteSeconds = $hourSeconds % $secondsInAnHour;
    $minutes = floor($minuteSeconds / $secondsInAMinute);

    // extract the remaining seconds
    $remainingSeconds = $minuteSeconds % $secondsInAMinute;
    $seconds = ceil($remainingSeconds);

    // return the final array
    $obj = array(
        'd' => (int) $days,
        'h' => (int) $hours,
        'm' => (int) $minutes,
        's' => (int) $seconds,
    );
    return $obj;
}




if( ! function_exists('get_friend')){

	function get_friend()
	{
		$CI =& get_instance();
		$listing = $CI->db->where(array("user_id"=>$CI->session->userdata('user_id'),"is_accept"=>'yes'))->get('ac_friend_usr')->result();

		if(count($listing)){

			foreach ($listing as $key => $value) {
				$friendsids[] = $value->friend_user_id;
			}
			return $friendsids;			
		}
	}
}

if( ! function_exists('is_check_friend_data')){

	function is_check_friend_data($id)
	{
		
		$CI =& get_instance();
		$friend_list = $CI->db->where(array("user_id"=>$CI->session->userdata('user_id'),"friend_user_id"=>$id))->get('ac_friend_usr')->result();
		if(count($friend_list)){if($friend_list[0]->is_accept=='yes'){return 'friends';}else{return 'requested';}}else{return 'addfriend';}
	}
}

if( ! function_exists('is_check_friend')){

	function is_check_friend($id)
	{
		$friend_list = get_friend();

		if(count($friend_list)){

			foreach ($friend_list as $key => $value) {
				$friendids[] = $value;
			}
			if (in_array($id, $friendids))
			{
				return 'true';
			}else{
				return 'false';
			}
		}else{
			return 'false';
		}
	}
}

if(! function_exists('is_check_send_request')){

	function is_check_send_request($id){

		$CI =& get_instance();
		$send_request = $CI->db->where(array("user_id"=>$CI->session->userdata('user_id'),"friend_user_id"=>$id,"is_accept"=>'no'))->get('ac_friend_usr')->result();
		if(count($send_request)){return 'true';}else{return 'false';}			
	}
}

if( !function_exists('get_friends_request')){

	function get_friends_request()
	{
		$CI =& get_instance();
						
		$CI->db->select('ac_friend_usr.*,user.fname,user.lname,user.profile_image');

		$match = array('ac_friend_usr.friend_user_id'=>$CI->session->userdata('user_id'),'ac_friend_usr.is_accept'=>'no');	    
	    
	    $CI->db->from('ac_friend_usr'); 
	    $CI->db->join('user', 'user.user_id=ac_friend_usr.user_id', 'left');
	    $CI->db->where($match);
	    $CI->db->order_by('ac_friend_usr.id','DESC'); 
	    $query = $CI->db->get();
	    return $query->result();
			
	}
}

if ( ! function_exists('create_notification') ){

	function create_notification($from,$to,$source_id,$type)  
	{
		$CI =& get_instance();

		$data = array( "from_id"	=> $from,
						"to_id"		=> $to,
						"source_id"	=> $source_id,
						"type"		=> $type,
						"is_readed"	=> 'no',
						"created"	=> date('Y-m-d h:i:s')
				);
		$CI->db->insert('notification', $data);
	}
}

if(! function_exists('get_admin_notification')){
	function get_admin_notification($to_id){ 

		$CI =& get_instance();
		$CI->db->where('to_id', $to_id);
		$CI->db->where('is_readed', 'no');
		$CI->db->order_by('id', 'DESC');
		$query = $CI->db->get('notification'); 
		$rslt = $query->result();  
		return $rslt;
	}
} 

if(! function_exists('update_admin_notification')){
	function update_admin_notification($id){ 

		$CI =& get_instance();
		$CI->load->database();
		$data['is_readed'] = 'yes';
		$CI->db->where('id',$id);
		$CI->db->update('notification',$data);
	}
} 

if ( ! function_exists('time_elapsed_string') ){
	function time_elapsed_string($datetime, $full = false) {
	     $now = new DateTime;
	     $ago = new DateTime($datetime);
	     $diff = $now->diff($ago);

	     $diff->w = floor($diff->d / 7);
	     $diff->d -= $diff->w * 7;

	     $string = array(
	         'y' => 'year',
	         'm' => 'month',
	         'w' => 'week',
	         'd' => 'day',
	         'h' => 'hour',
	         'i' => 'minute',
	         's' => 'second',
	     );
	     foreach ($string as $k => &$v) {
	         if ($diff->$k) {
	             $v = $diff->$k . ' ' . $v . ($diff->$k > 1 ? 's' : '');
	         } else {
	             unset($string[$k]);
	         }
	     }

	     if (!$full) $string = array_slice($string, 0, 1);
	     return $string ? implode(', ', $string) . ' ago' : 'just now';
	 }
}

if ( ! function_exists('get_single_field_by_id') ){

	function get_single_field_by_id($dbname,$fid,$id,$fieldname = ''){

		$CI =& get_instance();
		return $CI->db->select($fieldname)->from($dbname)->where($fid,$id)->get()->row()->$fieldname;
	}
}


if ( ! function_exists('is_user_free') ){

	function is_user_free($userid){

		$CI =& get_instance();
		$ptype = $CI->db->select('usertype_package')->from('user')->where('user_id',$userid)->get()->row()->usertype_package;
		if($ptype == "" || $ptype == "free" || $ptype != "paid")
		return true;
		else
		return false;
	}
}

if ( ! function_exists('is_user_plan_expried') ){

	function is_user_plan_expried($userid){

		$CI =& get_instance();
		$userdata = $CI->db->select('package_info,usertype_package,package_purchase_date')->from('user')->where('user_id',$userid)->get()->row();
		

		$plandata = $CI->db->select('*')->from('listing_price')->where('listing_price_id',$userdata->package_info)->get()->row();

		$expired_date = date('Y-m-d', strtotime('+'.$plandata->days_expiration.' day', strtotime($userdata->package_purchase_date)));
		
		$expiry_date = $expired_date." 23:59:59";
       	$today = date('d-m-Y',time()); 
       	$exp = date('d-m-Y',strtotime($expiry_date));

       	$expDate =  date_create($exp);
       	$todayDate = date_create($today);
       	$diff =  date_diff($todayDate, $expDate);
       	if($diff->format("%R%a")>0){
            //echo "active";
            return false;
       	}else{
            //echo "inactive";
            return true;
       	}

	}
}

if ( ! function_exists('totalListingsOfPlan') ){

	function totalListingsOfPlan($userid){

		$CI =& get_instance();
		$userdata = $CI->db->select('package_info')->from('user')->where('user_id',$userid)->get()->row();
	
		$plandata = $CI->db->select('*')->from('listing_price')->where('listing_price_id',$userdata->package_info)->get()->row();

		if($plandata)
		return $plandata->no_of_listing;
		else
		return "";

	}
}

if( ! function_exists('getOwnerData')){

	function getOwnerData($id = '')
	{
		
		$CI =& get_instance();
		if(empty($id)) $id = $CI->session->userdata('user_orgid');
		$orgdata = $CI->db->where(array("OrgID"=>$id))->get('baris_organization')->result();
		// if(count($friend_list)){if($friend_list[0]->is_accept=='yes'){return 'friends';}else{return 'requested';}}else{return 'addfriend';}
		return $orgdata[0];
	}
}


if( ! function_exists('fetchCoachList')){

	function fetchCoachList($tokenid)
	{
		$CI =& get_instance();
		$SQL = "SELECT
		baris_survey.db_coachNo,
		baris_survey.db_coachName
		FROM
		baris_survey
		WHERE baris_survey.is_submit = 'Y' ";

		$SQL .= " 
		AND baris_survey.db_surveyPageId != '15' " ;

		$SQL .= " 
		AND baris_survey.tokenid = '".$tokenid."' " ;
		
		$SQL .= " GROUP BY baris_survey.db_coachNo ORDER BY baris_survey.created_date ASC";

		$query = $CI->db->query($SQL);
		$result = $query->result();

		$surveyArr = array();
		//$index=0;
		for($c=0; $c<count($result); $c++){
			if($result[$c]->db_coachNo != "")
			if(!in_array($result[$c]->db_coachNo,$surveyArr))	{
				$index = explode(' ', $result[$c]->db_coachName)[1]-1;
				$surveyArr[$index][0] = $result[$c]->db_coachNo;
				$surveyArr[$index][1] = $result[$c]->db_coachName;
				// $index++;
			}
		}
		ksort($surveyArr);
		
		$surveyArr1 = array();
		$index=0;
		foreach ($surveyArr as $key => $value) {

			if($index == $key){
				$surveyArr1[] = $value;
			}else{

				$diff = $key - $index;
				if($diff > 2){
					for ($i=0; $i < $diff; $i++) { 
						$surveyArr1[$index+$i][0] = "";
						$surveyArr1[$index+$i][1] = "";

					}
					$surveyArr1[$key] = $value;
					$index = $index + $diff;
				}else{
					$surveyArr1[$index][0] = "";
					$surveyArr1[$index][1] = "";

					$surveyArr1[$key] = $value;
					$index++;
				}

			}

			$index++;
		}
		return $surveyArr1;
	}
}


if( ! function_exists('selectBarisPageName')){

	function selectBarisPageName($pageId)
	{
		$CI =& get_instance();
		$SQL = "SELECT db_pagename FROM baris_page WHERE pageId = ".$pageId;
		$query = $CI->db->query($SQL);
		$result = $query->result();

		
		return $result[0]->db_pagename;
	}
}


if( ! function_exists('fetchValueScorecard')){

	function fetchValueScorecard($queId,$subqueId,$PageParamID,$PageID="",$tokenID="",$coachNo="")
	{
		$CI =& get_instance();

		$SQL = "SELECT db_surveyValue AS AvgValue FROM baris_survey WHERE db_surveyPageid = ".$PageID." AND is_submit = 'Y' ";

		if(!empty($queId))
		$SQL .= " 
		AND db_surveyQuestionId = ".$queId." " ;

		if(!empty($subqueId))
		$SQL .= " 
		AND db_surveySubQuestionId = ".$subqueId." " ;

		// if(!empty($PageParamID))
		// $SQL .= " AND db_surveyParamId = ".$PageParamID. " ";

		if(!empty($coachNo))
		$SQL .= " AND db_coachNo = '".$coachNo. "' ";

		if(!empty($tokenID))
		$SQL .= " AND tokenid = '".$tokenID. "' ";
		
		// $SQL .= " AND created_date BETWEEN '".date("Y-m-d",strtotime($this->FromDate))." 00:00:00' AND '".date("Y-m-d",strtotime($this->ToDate))." 23:59:59' ";
		
		
		$query = $CI->db->query($SQL);	
		$result = $query->result();
		
		//$avgValue = "";
		if($result[0]->AvgValue == '0'){
			$result[0]->AvgValue == "0";
		}elseif ($result[0]->AvgValue == '1') {
			$result[0]->AvgValue == "1";
		}elseif ($result[0]->AvgValue == 'X') {
			$result[0]->AvgValue = "X";
		}else{
			$result[0]->AvgValue = "-";

		}
		
		return $result[0]->AvgValue;
	}
}

if( ! function_exists('fetchContentRemark')){

	function fetchContentRemark($tokenID="",$coachNo="")
	{
		$CI =& get_instance();

		$SQL = "SELECT db_surveyValue FROM baris_survey WHERE db_surveyPageid = '15' AND is_submit = 'Y' ";

		if(!empty($coachNo))
		$SQL .= " AND db_coachNo = '".$coachNo."' ";


		if(!empty($tokenID))
		$SQL .= " AND tokenid = '".$tokenID. "' ";
		
		
		$query = $CI->db->query($SQL);	
		$result = $query->result();
		if(count($result) > 0)
			return json_decode(stripslashes($result[0]->db_surveyValue));	
		else return "";
		
		// return $result[0]->AvgValue;
	}
}

if( ! function_exists('getcommondata')){

	function getcommondata($table,$data,$fieldname,$fieldid)
	{
		$CI =& get_instance();

		$SQL = "SELECT ".$data." FROM ".$table." WHERE ".$fieldname." = ".$fieldid;
		
		$query = $CI->db->query($SQL);	
		$result = $query->result();
		if(count($result) > 0)
			return $result[0]->$data;	
		else return "";
		
		// return $result[0]->AvgValue;
	}
}

if( ! function_exists('fetchTotalTrainsForSummery')){

	function fetchTotalTrainsForSummery($reportType,$FromDate,$ToDate)
	{
		$CI =& get_instance();

		$SQL = "SELECT DISTINCT db_trainno FROM
		baris_survey WHERE is_submit = 'Y' ";

		if(empty($FromDate) && empty($ToDate))
		$SQL .= " AND created_date BETWEEN '".date("Y-m-d")." 00:00:00' AND '".date("Y-m-d")." 23:59:59' ";
		else
		$SQL .= " AND created_date BETWEEN '".date("Y-m-d",strtotime($FromDate))." 00:00:00' AND '".date("Y-m-d",strtotime($ToDate))." 23:59:59' ";


		//if(!empty($this->AuditorId))
		$SQL .= " 
		AND OrgID = ".$CI->session->userdata('user_orgid')." ";

		if($reportType == 'CTS'){
			$SQL .= " AND db_surveyQuestionId = '11' ";
			$SQL .= " AND db_surveySubQuestionId = '6' ";
		}elseif($reportType == 'RBPC'){
			$SQL .= " AND db_surveyQuestionId = '12' ";
			$SQL .= " AND db_surveySubQuestionId = '10' ";
		}elseif($reportType == 'WAT'){
			$SQL .= " AND db_surveyQuestionId = '13' ";
			$SQL .= " AND db_surveySubQuestionId = '14' ";
		}
		
		$SQL .= " GROUP BY tokenid ORDER BY created_date DESC";
		
		$query = $CI->db->query($SQL);	
		return $result = $query->result();

	}
}

if( ! function_exists('fetchTotalCoachesForSummery')){

	function fetchTotalCoachesForSummery($reportType,$FromDate,$ToDate)
	{
		$CI =& get_instance();

		$SQL = "SELECT db_totalCoachCount FROM
		baris_survey WHERE is_submit = 'Y' ";

		if(empty($FromDate) && empty($ToDate))
		$SQL .= " AND created_date BETWEEN '".date("Y-m-d")." 00:00:00' AND '".date("Y-m-d")." 23:59:59' ";
		else
		$SQL .= " AND created_date BETWEEN '".date("Y-m-d",strtotime($FromDate))." 00:00:00' AND '".date("Y-m-d",strtotime($ToDate))." 23:59:59' ";


		//if(!empty($this->AuditorId))
		$SQL .= " 
		AND OrgID = ".$CI->session->userdata('user_orgid')." ";

		if($reportType == 'CTS'){
			$SQL .= " AND db_surveyQuestionId = '11' ";
			$SQL .= " AND db_surveySubQuestionId = '6' ";
		}elseif($reportType == 'RBPC'){
			$SQL .= " AND db_surveyQuestionId = '12' ";
			$SQL .= " AND db_surveySubQuestionId = '10' ";
		}elseif($reportType == 'WAT'){
			$SQL .= " AND db_surveyQuestionId = '13' ";
			$SQL .= " AND db_surveySubQuestionId = '14' ";
		}
		
		$SQL .= " GROUP BY tokenid ORDER BY created_date DESC";
		
		$query = $CI->db->query($SQL);	
		$result = $query->result();

		$rsCoachList = 0;
		for ($i=0;$i< count($result);$i++)
        {
			$rsCoachList = $rsCoachList + $result[$i]->db_totalCoachCount;
        }

        return $rsCoachList;
	}
}