/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
//
$group = \montserrat\Group::findOrFail($id);
$members = \montserrat\Contact::whereHas('groups', function ($query) use($id) {
$query->whereGroupId($id)->whereStatus('Added');
})->orderby('sort_name')->get();
//dd($group);
return view('groups.show', compact('group', 'members'));
//
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
//
$dioceses = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_DIOCESE)->orderby('organization_name')->pluck('organization_name', 'id');
//$pastors = \montserrat\Contact::whereHas('b_relationships', function($query) {
// $query->whereRelationshipTypeId(RELATIONSHIP_TYPE_PASTOR)->whereIsActive(1);})->orderby('sort_name')->pluck('sort_name','id');
$pastors = \montserrat\Contact::whereHas('group_pastor', function ($query) {
$query->whereGroupId(GROUP_ID_PASTOR)->whereStatus('Added');
})->orderby('sort_name')->pluck('sort_name', 'id');
$dioceses[0] = 'No Diocese assigned';
$pastors[0] = 'No pastor assigned';
//dd($pastors);
$states = \montserrat\StateProvince::orderby('name')->whereCountryId(COUNTRY_ID_USA)->pluck('name', 'id');
$states->prepend('N/A', 0);
$countries = \montserrat\Country::orderby('iso_code')->pluck('iso_code', 'id');
$defaults['state_province_id'] = STATE_PROVINCE_ID_TX;
$defaults['country_id'] = COUNTRY_ID_USA;
$countries->prepend('N/A', 0);
$parish = \montserrat\Contact::with('pastor.contact_b', 'diocese.contact_a', 'address_primary.state', 'address_primary.location', 'phone_primary.location', 'phone_main_fax', 'email_primary.location', 'website_main', 'notes')->findOrFail($id);
$defaults['Main']['url'] = '';
$defaults['Work']['url'] = '';
$defaults['Facebook']['url'] = '';
$defaults['Google']['url'] = '';
$defaults['Instagram']['url'] = '';
$defaults['LinkedIn']['url'] = '';
$defaults['Twitter']['url'] = '';
foreach ($parish->websites as $website) {
$defaults[$website->website_type]['url'] = $website->url;
}
return view('parishes.edit', compact('parish', 'dioceses', 'pastors', 'states', 'countries', 'defaults'));
}
