<?php
require_once("common/SQLServerManager.php");

class InitializationService
{
    public function getCountries() 
    {
		$query = "SELECT alpha2 FROM [evolucare].[dbo].[tr_country]";
		$results = SQLServerManager::queryOnDatabase( $query );
		
		$resultArray = array();

		foreach( $results as $value ) 
		{
			array_push( $resultArray, trim( $value->alpha2 ) );
		}

		return $resultArray;
	}
	
	public function getQuestions() 
    {
		$query = "SELECT code FROM [evolucare].[dbo].[tr_question]";
		$results = SQLServerManager::queryOnDatabase( $query );
		
		$resultArray = array();

		foreach( $results as $value ) 
		{
			array_push( $resultArray, trim( $value->code ) );
		}
		
		return $resultArray;
	}
	
	public function getSpecialities() 
    {
		$query = "SELECT code FROM [evolucare].[dbo].[tr_speciality]";
		$results = SQLServerManager::queryOnDatabase( $query );
		
		$resultArray = array();

		foreach( $results as $value ) 
		{
			array_push( $resultArray, trim( $value->code ) );
		}
		
		return $resultArray;
	}
	
	public function getCoronaryDiseases() 
    {
		$query = "SELECT code FROM [intimamedia_physician].[dbo].[tr_coronary_disease]";
		$results = SQLServerManager::queryOnDatabase( $query );
		
		$resultArray = array();

		foreach( $results as $value ) 
		{
			array_push( $resultArray, trim( $value->code ) );
		}
		
		return $resultArray;
	}
	
	public function getTypeEthiologies() 
    {
		$query = "SELECT code FROM [intimamedia_physician].[dbo].[tr_type_ethiology]";
		$results = SQLServerManager::queryOnDatabase( $query );
		
		$resultArray = array();

		foreach( $results as $value ) 
		{
			array_push( $resultArray, trim( $value->code ) );
		}
		
		return $resultArray;
	}
	
	public function getTypeAIC() 
    {
		$query = "SELECT code FROM [intimamedia_physician].[dbo].[tr_type_aic]";
		$results = SQLServerManager::queryOnDatabase( $query );
		
		$resultArray = array();

		foreach( $results as $value ) 
		{
			array_push( $resultArray, trim( $value->code ) );
		}
		
		return $resultArray;
	}
	
	public function getType() 
    {
		$query = "SELECT * FROM [intimamedia_physician].[dbo].[tr_type]";
		$results = SQLServerManager::queryOnDatabase( $query );
		
		$resultArray = array();

		foreach( $results as $value ) 
		{
			array_push( $resultArray, trim( $value->code ) );
		}
		
		return $resultArray;
	}
	
	public function getLocation() 
    {
		$query = "SELECT * FROM [intimamedia_physician].[dbo].[tr_location]";
		$results = SQLServerManager::queryOnDatabase( $query );
		
		$resultArray = array();

		foreach( $results as $value ) 
		{
			array_push( $resultArray, trim( $value->code ) );
		}
		
		return $resultArray;
	}
	
	public function getEthnic() 
    {
		$query = "SELECT * FROM [evolucare].[dbo].[tr_ethnic] ORDER BY ethnic_group ASC";
		$results = SQLServerManager::queryOnDatabase( $query );
		
		$resultArray = array();

		foreach( $results as $value ) 
		{
			array_push( $resultArray, trim( $value->ethnic_group ) );
		}
		
		return $resultArray;
	}
}
?>