Select::make('decedent_id')
->label(__('decedent_id'))
->required()
->options(DB::table('people')->select('id', DB::raw("CONCAT(people.full_name,' (',people.doc_num,') ',COALESCE(DATE_FORMAT(people.date_of_death,'%d-%b-%Y', 'es_es'),'sin fecha fallecimiento')) AS full_name"))->get()->pluck('full_name', 'id'))
Select::make('decedent_id')
->label(__('decedent_id'))
->required()
->options(DB::table('people')->select('id', DB::raw("CONCAT(people.full_name,' (',people.doc_num,') ',COALESCE(DATE_FORMAT(people.date_of_death,'%d-%b-%Y', 'es_es'),'sin fecha fallecimiento')) AS full_name"))->get()->pluck('full_name', 'id'))