";print_r($Diagnostic11);die;

 		return $Diagnostic11;
    }

function getAuthUser($username)
	{
	    $condition = "";
		$db_name="alert_management";

		$userarray = db__select("SELECT * FROM matrix.users WHERE users.sys_active = 1 AND (users.sys_parent_user IN (6347) OR users.id IN (6347)) AND users.sys_username = '".$username."' ", $condition);

		if(count($userarray)>0) {
			return 1;
		} else {
	    	return 0;
		}
	}

	function getAuthEmails($email,$username)
	{
	    $condition = "";
		$db_name="alert_management";

		$userarray = db__select_staging("SELECT * FROM auth_emails WHERE ms_email = '".$email."' and username = '".$username."' AND STATUS = 1 ", $condition);

		if(count($userarray)>0) {
			return 1;
		} else {
	    	return 0;
		}
	}

	


	function getAllVehiclesIds($Group_id)
	{
	    $condition = "";
		$db_name="matrix";

	    $this->data=db__select_staging62("SELECT sys_Service_id FROM group_services WHERE sys_group_id=".$Group_id." AND `active` = 1;", $condition);

	    //echo count($this->data);die;		
	    return $this->data;
	}

	function getevents($userid)
	{
	    $condition = "";
		$db_name="alert_management";


		$userarray = $this->data=db__select_staging("SELECT id,`name`,title,image,logo,popup_image,header_image,`status` FROM `events` WHERE `status` = 1 AND user_id = ".$userid." order by id desc limit 1", $condition);

		if(count($userarray)>0) {
			$this->data = $userarray;
		} else {
	    	$this->data=db__select_staging("SELECT id,`name`,title,image,logo,popup_image,header_image,`status` FROM `events` WHERE NOW() BETWEEN `from_date` AND `to_date` AND `status` = 1 order by id desc limit 1", $condition);
		}
	    //echo count($this->data);die;
	    return $this->data;
	}
	function getuserevents($userid,$token,$event_id)
	{
	    $condition = "";
		$db_name="alert_management";
		//echo "SELECT id,last_date FROM events_track WHERE event_id = ".$event_id." AND userid = ".$userid." AND groupid = ".$token." ";die;

	    $this->data=db__select_staging("SELECT id,last_date FROM events_track WHERE event_id = ".$event_id." AND userid = ".$userid." AND groupid = ".$token." ", $condition);

	    //echo count($this->data);die;
	    return $this->data;
	}

	 function getVehiclealerts($token,$vehiclesid,$alert_type)
	{
	    $condition = "";
		$db_name="alert_management";

		$queryextra = "";

		if($vehiclesid!='') {
			$queryextra .= " AND sra.sys_service_id = '".$vehiclesid."' ";
		}
		if($alert_type!='') {
			$queryextra .= " AND sra.alert_type = '".$alert_type."' ";
		}

		$sql = "SELECT sra.id,sra.sys_service_id,sra.alert_type,sra.service_document_date,sra.gap_service_document_date,sra.service_km,sra.sys_group_id,sra.alert_message,sra.active,sra.email,sra.mobile,sra.sms,sra.next_service_km,sra.service_gap_km, s.veh_reg, s.veh_cubic_capacity as odometer, s.overspeed_lastchk as odometer_lastdate FROM service_renewal_alerts AS sra LEFT JOIN services s ON s.id = sra.sys_service_id WHERE sra.sys_group_id='".$token."' and sra.active = 1 ".$queryextra." ORDER BY id";

		$data = db__select_staging62($sql, $condition);

		//print_r($data);die;

		if(count($data)>0) {
			return $data;
		} else {
	    	return 0;
		}
	}


}
?>