public function queryInitiator(Request $request)
{
$queryInitiatorName = $request->name;
$initiatorIds = StakeholderTranslation::where('org_name', 'like', '%' . $queryInitiatorName . '%')->lists('stakeholder_id');
$initiators = Stakeholder::whereIn('id', $initiatorIds)->orWhere('name', 'like', '%' . $queryInitiatorName . '%')->with(['translations'])->get();
$result = [];
foreach ($initiators as $initiator) {
$result[] = ['id' => $initiator->id, 'name' => $initiator->name ? $initiator->name : $initiator->org_name];
}
return $result;
}
