<?php
/*
 *
 *
 * PHP version 4 and 5
 *
 * LICENSE: This source file is subject to LGPL license
 * that is available through the world-wide-web at the following URI:
 * http://www.gnu.org/copyleft/lesser.html
 *
 * @package    Sahana - http://sahana.sourceforge.net
 * @author     Ravindra <hide@address.com>
 * @copyright  Lanka Software Foundation - http://www.opensource.lk
 *
 */

$act=$_GET{"act"};

if($act=='add_loc')
{
	_shn_get_level_location();
}else if ($act=='sub_cat')
{
	_shn_get_sub_catalogs();
}
else if($act=='unit_cat')
{
	_shn_get_units();
}else if($act=='get_loc_val')
{
	_shn_get_locations();
}
else if($act=='victims')
{
	_shn_get_victims();
}
else
{
	_shn_get_children();
}


function _shn_get_units()
{
	require_once('../3rd/adodb/adodb.inc.php');
	require_once('../conf/sysconf.inc');
	//Make the connection to $global['db']
	$db = NewADOConnection($conf['db_engine']);
	$db ->Connect($conf['db_host'].($conf['db_port']?':'.$conf['db_por
	t']:''),$conf['db_user'],$conf['db_pass'],$conf['db_name']);

	$cat=$_GET{"cat"};

	$q="select unit_uuid,name from ct_unit where unit_type_uuid ='$cat'";
	$res_child=$db->Execute($q);

	if(!$res_child==NULL && !$res_child->EOF){
		while(!$res_child->EOF){
			$res=$res.",".$res_child->fields[0];
			$res=$res.",".$res_child->fields[1];
			$res_child->MoveNext();
		}
		echo $res;
	}else{
		echo "null,";
	}

}



function _shn_get_sub_catalogs(){
	require_once('../3rd/adodb/adodb.inc.php');
	require_once('../conf/sysconf.inc');
	//Make the connection to $global['db']
	$db = NewADOConnection($conf['db_engine']);
	$db ->Connect($conf['db_host'].($conf['db_port']?':'.$conf['db_por
t']:''),$conf['db_user'],$conf['db_pass'],$conf['db_name']);

	$cat=$_GET{"cat"};
	$flag=$_GET{"flag"};
	if($flag==false)
	{
		$q="select ct_uuid,name from ct_catalogue where parentid='{$cat}'";
		$res_child=$db->Execute($q);
	}
	else if($flag==true)
	{
		$q="select ct_uuid,name from ct_catalogue where parentid='{$cat}' and final_flag='0' ";
		$res_child=$db->Execute($q);
	}

	$res=$res.","."";
	$res=$res.","."";

	if(!$res_child==NULL && !$res_child->EOF){
		while(!$res_child->EOF){
			$res=$res.",".$res_child->fields[0];
			$res=$res.",".$res_child->fields[1];
			$res_child->MoveNext();
		}
		echo $res;
	}else{
		echo "null,";
	}
}

function _shn_get_children(){
	require_once('../3rd/adodb/adodb.inc.php');
	require_once('../conf/sysconf.inc');
	//Make the connection to $global['db']
	$db = NewADOConnection($conf['db_engine']);
	$db ->Connect($conf['db_host'].($conf['db_port']?':'.$conf['db_por
t']:''),$conf['db_user'],$conf['db_pass'],$conf['db_name']);

	$level=$_GET{"lvl"}+1;
	$parent=$_GET{"sel"};

	$q = "SELECT location.name,location.loc_uuid,parent_id FROM location WHERE location.opt_location_type='{$level}' AND parent_id='{$parent}' ORDER BY location.name";
	//echo $q;
	$res_child=$db->Execute($q);
	if($res_child->EOF)
	return;
	while(!$res_child->EOF){
		$res=$res.",".$res_child->fields[1];
		$res=$res.",".$res_child->fields[0];
		$res_child->MoveNext();
	}
	echo $res;
}

function _shn_get_locations(){
	require_once('../3rd/adodb/adodb.inc.php');
	require_once('../conf/sysconf.inc');
	//Make the connection to $global['db']
	$db = NewADOConnection($conf['db_engine']);
	$db ->Connect($conf['db_host'].($conf['db_port']?':'.$conf['db_por
t']:''),$conf['db_user'],$conf['db_pass'],$conf['db_name']);

	$level=1;
	$sel_id=$_GET{"sel"};

	if($_GET{"type"}=="camp"){
		$q="SELECT location_id FROM camp_general WHERE c_uuid='{$sel_id}'";
		$res=$db->Execute($q);
		if($res->EOF)
		return;
		$loc_id=$res->fields["location_id"];
	}else if($_GET{"type"}=="poc"){
		$q = "SELECT location_id FROM location_details WHERE poc_uuid='{$sel_id}'";
		$res=$db->Execute($q);
		if($res->EOF)
		return;
		$loc_id=$res->fields["location_id"];
	}else{
		$loc_id=$_GET{"sel"};
	}



	$q = "SELECT parent_id,opt_location_type FROM location WHERE loc_uuid='{$loc_id}'";
	$res=$db->Execute($q);
	if($res->EOF)
	return;
	 
	$parent=$res->fields["parent_id"];
	$header.="loc_dir".",".$parent;
	$header.=",".$res->fields["opt_location_type"];
	 
	$level=$res->fields["opt_location_type"];

	$q = "SELECT location.name,location.loc_uuid FROM location WHERE location.opt_location_type='{$level}' AND parent_id='{$parent}' ORDER BY location.name";
	//echo $q;
	$res_child=$db->Execute($q);
	if($res_child->EOF)
	return;
	$count=0;
	while(!$res_child->EOF){
		if($count==0){
			$res_data=$res_data.$res_child->fields["loc_uuid"];
			$res_data=$res_data.":".$res_child->fields["name"];
		}else{
			$res_data=$res_data.",".$res_child->fields["loc_uuid"];
			$res_data=$res_data.":".$res_child->fields["name"];
		}
		if($res_child->fields["loc_uuid"]==$loc_id){
			$header.=",".$count;
		}
		$count++;
		$res_child->MoveNext();
	}
	//echo $header;
	// echo $res_data;
	
	 
	echo $header.";".$res_data;
}


function _shn_get_level_location(){
	require_once('../3rd/adodb/adodb.inc.php');
	require_once('../conf/sysconf.inc');
	//Make the connection to $global['db']
	$db = NewADOConnection($conf['db_engine']);
	$db ->Connect($conf['db_host'].($conf['db_port']?':'.$conf['db_por
t']:''),$conf['db_user'],$conf['db_pass'],$conf['db_name']);


	$level=$_GET{"sel"};
	if($level==1){
		echo "none,";
	}
	$q = "SELECT location.name,location.loc_uuid,parent_id FROM location WHERE location.opt_location_type={$level}";
	$res_child=$db->Execute($q);
	if($res_child->EOF)
	return;
	while(!$res_child->EOF){
		$res=$res.",".$res_child->fields[1];
		$res=$res.",".$res_child->fields[0];
		$res_child->MoveNext();
	}
	echo $res;
}

function _shn_get_victims()
{
	// print ('test');
	require_once('../3rd/adodb/adodb.inc.php');
	require_once('../conf/sysconf.inc');
	//Make the connection to $global['db']
	$db = NewADOConnection($conf['db_engine']);
	$db ->Connect($conf['db_host'].($conf['db_port']?':'.$conf['db_por
t']:''),$conf['db_user'],$conf['db_pass'],$conf['db_name']);

	$level=1;
	$head_name=$_GET{"head_name"};
	//$victim_array=array();

	//$search="select p.p_uuid as pid, pg.opt_group_type as group_type,gd.head_uuid as head_uuid,pe.full_name as full_name,pe.family_name as family_name,pe.l10n_name as local_name,i.serial as serial,c.contact_value as address  from person_to_pgroup as p inner join pgroup as pg on pg.g_uuid =p.g_uuid inner join group_details as gd on gd.g_uuid=p.g_uuid inner join person_uuid as pe on pe.p_uuid = p.p_uuid left join identity_to_person as i on (i.p_uuid = p.p_uuid and i.opt_id_type='idcard') left join contact as c on (c.pgoc_uuid= p.p_uuid and c.opt_contact_type='address') where pe.full_name='$head_name' or pe.family_name='$head_name' or pe.l10n_name='$head_name' or i.serial='$head_name';";
	$search="select p.p_uuid as pid, pe.full_name as full_name, pe.family_name as family_name from person_to_pgroup as p inner join pgroup as pg on pg.g_uuid =p.g_uuid inner join group_details as gd on gd.g_uuid=p.g_uuid inner join person_uuid as pe on pe.p_uuid = p.p_uuid left join identity_to_person as i on (i.p_uuid = p.p_uuid and i.opt_id_type='idcard') left join contact as c on (c.pgoc_uuid= p.p_uuid and c.opt_contact_type='address') where pe.full_name='$head_name' or pe.family_name='$head_name' or pe.l10n_name='$head_name' or i.serial='$head_name';";
	$res=$db->Execute($search);
	$i=0;
	if(!$res->EOF && $res!=NULL)
	{
		while(!$res->EOF && $res!=NULL)
		{

			//$name=$res->fields['first_name']." " .$res->fields['last_name'];
			$victim_array=$victim_array.",".$res->fields['0'];
			$victim_array=$victim_array.",".$res->fields['1']." ".$res->fields['2'];

			//$victim_array[$i]=$i;
			$i=$i+1;
			$res->MoveNext();
		}
		//return $victim_array;
		echo $victim_array;
	}
	else
	{
		echo "null";
	}


}
?>