@props(['demographyconfigId','moduleid','mandatory','displaysearch']) @php use App\Models\Demography; $Field=DB::table('DemographyConfig')->where('DemographyConfigId',$demographyconfigId)->get()->first(); $DisplayName=$Field->LabelValue; $ColumnName=$Field->ColumnName; $Helptext=$Field->Helptext; $LabelValue=''; $dispRelatedValue=""; $ParentModuleId=$Field->ParentModuleId; $ParentRowId=''; $ParentField=DB::table('DemographyConfig')->where('ModuleId',$ParentModuleId)->where('ReferenceField',1)->get(['ColumnName'])->first(); try { $ParentField=$ParentField->ColumnName; } catch(\Exception $e) { $ParentField=DB::table('DemographyConfig')->where('ModuleId',$ParentModuleId)->where('ColumnName','%like%','Name')->get(['ColumnName'])->first(); try { $ParentField=$ParentField->ColumnName; } catch(\Exception $e) { $ParentField="CreatedDate"; } } $RelatedNames=[]; if($ParentModuleId!="") { $demography=new Demography(); $MainTableName=$demography->getMainTableName($ParentModuleId); $CstmTableName=$demography->GetCustomTableName($ParentModuleId); $primarykeyName=$demography->getPrimaryKeyName($ParentModuleId); $CstmPrimaryKeyName=$demography->getCstmPrimaryKeyName($ParentModuleId); if($LabelValue) { $DisplayValues=DB::table($MainTableName)->join($CstmTableName,$MainTableName.".".$primarykeyName,'=',$CstmTableName.".".$CstmPrimaryKeyName)->where($primarykeyName,$LabelValue)->where('DeletedStatus',0)->get([$ParentField])->first(); try{ $dispRelatedValue=$DisplayValues->$ParentField; } catch(\Exception $e) { $dispRelatedValue=""; } } } if($mandatory==1) { $RequiredField="required"; $DisplayredStar="*"; $Required=1; } else { $RequiredField=""; $DisplayredStar=""; $Required=""; } @endphp