@props(['demographyconfigId','result','rowid','moduleid'])

@php

use App\Models\Demography;


$Field=DB::table('DemographyConfig')->where('DemographyConfigId',$demographyconfigId)->get()->first();
$DisplayName=$Field->LabelValue;
$ColumnName=$Field->ColumnName;
$LabelValue=$result->$ColumnName;

$ParentModuleId=$Field->ParentModuleId;
$ParentRowId=$result->$ColumnName;

$ParentField=DB::table('DemographyConfig')->where('ModuleId',$moduleid)->where('ReferenceField',1)->get(['ColumnName'])->first();


try
{
	$ParentField=$ParentField->ColumnName;
}
catch(\Exception $e)
{
	$ParentField=DB::table('DemographyConfig')->where('ModuleId',$moduleid)->where('ColumnName','%like%','Name')->get(['ColumnName'])->first();

	try
	{
		$ParentField=$ParentField->ColumnName;
	}
	catch(\Exception $e)
	{
		$ParentField="CreatedDate";	
	}
}

$RelatedName="";

if($LabelValue!='')
{
	$demography=new Demography();
	$MainTableName=$demography->getMainTableName($moduleid);
	$CstmTableName=$demography->GetCustomTableName($moduleid);
	$primarykeyName=$demography->getPrimaryKeyName($moduleid);
	$CstmPrimaryKeyName=$demography->getCstmPrimaryKeyName($moduleid);


	$RelatedName=DB::table($MainTableName)->join($CstmTableName,$MainTableName.".".$primarykeyName,'=',$CstmTableName.".".$CstmPrimaryKeyName)->where($primarykeyName,$LabelValue)->where('DeletedStatus',0)->get([$ParentField])->first();

	try
	{
		$RelatedName=$RelatedName->$ParentField;
	}
	catch(\Exception $e)
	{
		$RelatedName="";
	}
}



$DependentField=$Field->DependentField;
		$DependentFieldId=$Field->DependentFieldId;
		$displayColumn=1;

		if($DependentField && $DependentFieldId)
		{
			$DropdownResult=DB::table('DropDownLists')->where('DropDownListId',$DependentFieldId)->get(['DropDownNameId'])->first();

			try
			{
				$dependentFieldDropdownId=$DropdownResult->DropDownNameId;

				$GetParentColumnName=DB::table('DemographyConfig')->where('ModuleId',$moduleid)->where('DisplayType','26')->where('DropDownNameId',$dependentFieldDropdownId)->get(['ColumnName'])->first();
				$ParentColumnName=$GetParentColumnName->ColumnName;

				if($result->$ParentColumnName==$DependentFieldId)
				{
					$displayColumn=1;
				}
				else
				{
					$displayColumn=0;
				}

			}
			catch(\Exception $e){}

		}

		if($displayColumn)
		{
			$displayDiv="style=''";
		}	
		else
		{
			$displayDiv="style='display:none';";

		}	
@endphp

<div class="col-md-4 form-group" {{$displayDiv}}>
	<label>@php echo $DisplayName; @endphp</label>
	<a style="display: block;cursor: pointer;" onclick="popUp('{{$moduleid}}','{{$LabelValue}}','8','{{$ColumnName}}','{{$RelatedName}}')" class="text-info" data-toggle="modal" data-target="#exampleModal">{{$RelatedName}}</a>
</div>