@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="";
	}
}
@endphp

<div class="col-md-4 form-group">
	<label>{{$DisplayName}}</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>