/** * 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')); // }
public function edit_group($id) { // $registration = \montserrat\Registration::with('retreatant', 'retreat', 'room')->findOrFail($id); // $retreat = \montserrat\Retreat::findOrFail($registration->event_id); $retreatant = \montserrat\Contact::findOrFail($registration->contact_id); $retreats = \montserrat\Retreat::select(\DB::raw('CONCAT(idnumber, "-", title, " (",DATE_FORMAT(start_date,"%m-%d-%Y"),")") as description'), 'id')->where("end_date", ">", \Carbon\Carbon::today())->orderBy('start_date')->pluck('description', 'id'); //dd($retreats); //TODO: we will want to be able to switch between types when going from a group registration to individual room assignment if ($retreatant->contact_type == CONTACT_TYPE_INDIVIDUAL) { $retreatants = \montserrat\Contact::whereContactType(CONTACT_TYPE_INDIVIDUAL)->orderBy('sort_name')->pluck('sort_name', 'id'); } if ($retreatant->contact_type == CONTACT_TYPE_ORGANIZATION) { $retreatants = \montserrat\Contact::whereContactType(CONTACT_TYPE_ORGANIZATION)->whereSubcontactType($retreatant->subcontact_type)->orderBy('sort_name')->pluck('sort_name', 'id'); } $rooms = \montserrat\Room::orderby('name')->pluck('name', 'id'); $rooms->prepend('Unassigned', 0); /* Check to see if the current registration is for a past retreat and if so, add it to the collection */ // $retreats[0] = 'Unassigned'; if ($registration->retreat->end < \Carbon\Carbon::now()) { $retreats[$registration->event_id] = $registration->retreat->idnumber . '-' . $registration->retreat->title . " (" . date('m-d-Y', strtotime($registration->retreat->start_date)) . ")"; } return view('registrations.edit_group', compact('registration', 'retreats', 'rooms', 'retreatants')); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { // \montserrat\Contact::destroy($id); return Redirect::action('VendorsController@index'); }
public function get_contact_type_list($contact_type = 'Individual', $contact_subtype = NULL) { //dd($contact_type,$contact_subtype); switch ($contact_type) { case 'Household': $households = \montserrat\Contact::whereContactType(CONTACT_TYPE_HOUSEHOLD)->orderBy('organization_name', 'asc')->pluck('organization_name', 'id'); return $households; break; case 'Organization': switch ($contact_subtype) { case 'Parish': $parish_list = array(); $parishes = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_PARISH)->orderBy('organization_name', 'asc')->with('address_primary.state', 'diocese.contact_a')->get(); foreach ($parishes as $parish) { $parish_list[$parish->id] = $parish->organization_name . ' (' . $parish->address_primary_city . ') - ' . $parish->diocese_name; } return $parish_list; break; case 'Diocese': $dioceses = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_DIOCESE)->orderBy('organization_name', 'asc')->pluck('organization_name', 'id'); return $dioceses; break; case 'Province': $provinces = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_PROVINCE)->orderBy('organization_name', 'asc')->pluck('organization_name', 'id'); return $provinces; break; case 'Community': $communities = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_COMMUNITY)->orderBy('organization_name', 'asc')->pluck('organization_name', 'id'); return $communities; break; case 'Retreat House': $retreat_houses = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_RETREAT_HOUSE)->orderBy('organization_name', 'asc')->pluck('organization_name', 'id'); return $retreat_houses; break; case 'Vendor': $vendors = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_VENDOR)->orderBy('organization_name', 'asc')->pluck('organization_name', 'id'); return $vendors; break; case 'Religious-Catholic': $religious_catholic = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_RELIGIOUS_CATHOLIC)->orderBy('organization_name', 'asc')->pluck('organization_name', 'id'); return $religious_catholic; break; case 'Religious-Non-Catholic': $religious_non_catholic = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_RELIGIOUS_NONCATHOLIC)->orderBy('organization_name', 'asc')->pluck('organization_name', 'id'); return $religious_non_catholic; break; case 'Foundation': $foundations = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_FOUNDATION)->orderBy('organization_name', 'asc')->pluck('organization_name', 'id'); return $religious_non_catholic; break; //default NULL (generic organization) //default NULL (generic organization) default: $organizations = \montserrat\Contact::whereContactType(CONTACT_TYPE_ORGANIZATION)->orderBy('organization_name', 'asc')->pluck('organization_name', 'id'); return $organizations; break; } break; // default Individual // default Individual default: switch ($contact_subtype) { case 'Bishop': $bishops = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_BISHOP); })->pluck('sort_name', 'id'); return $bishops; break; case 'Priest': $priests = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_PRIEST); })->pluck('sort_name', 'id'); return $priests; break; case 'Deacon': $deacons = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_DEACON); })->pluck('sort_name', 'id'); return $deacons; break; case 'Pastor': $pastors = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_PASTOR); })->pluck('sort_name', 'id'); return $pastors; break; case 'Innkeeper': $innkeepers = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_INNKEEPER); })->pluck('sort_name', 'id'); return $innkeepers; break; case 'Assistant': $assistants = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_ASSISTANT); })->pluck('sort_name', 'id'); return $assistants; break; case 'Director': $directors = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_DIRECTOR); })->pluck('sort_name', 'id'); return $directors; break; case 'Captain': $captains = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_CAPTAIN); })->pluck('sort_name', 'id'); return $captains; break; case 'Jesuit': $jesuits = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_JESUIT); })->pluck('sort_name', 'id'); return $jesuits; break; case 'Provincial': $provincials = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_PROVINCIAL); })->pluck('sort_name', 'id'); return $provincials; break; case 'Superior': $superiors = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_SUPERIOR); })->pluck('sort_name', 'id'); return $superiors; break; case 'Board member': $board_members = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_BOARD); })->pluck('sort_name', 'id'); return $board_members; break; case 'Employee': $staff = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_STAFF); })->pluck('sort_name', 'id'); return $staff; break; case 'Volunteer': $volunteers = \montserrat\Contact::with('groups.group')->orderby('sort_name')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_VOLUNTEER); })->pluck('sort_name', 'id'); return $volunteers; break; //default null //default null default: $individuals = \montserrat\Contact::whereContactType(CONTACT_TYPE_INDIVIDUAL)->orderBy('sort_name', 'asc')->pluck('sort_name', 'id'); return $individuals; break; } } }
public function role($role) { // TODO: figure out how to handle roles $contacts = \montserrat\Contact::orderBy('last_name', 'asc', 'first_name', 'asc')->where($role['field'], '1')->get(); //dd($contacts); return view('contacts.role', compact('contacts', 'role')); // }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { // TODO: delete addresses, emails, webpages, and phone numbers for persons, parishes, dioceses and organizations \montserrat\Contact::destroy($id); return Redirect::action('OrganizationsController@index'); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { // $touchpoint = \montserrat\Touchpoint::with('staff', 'person')->findOrFail($id); $staff = \montserrat\Contact::with('groups')->whereHas('groups', function ($query) { $query->where('group_id', '=', GROUP_ID_STAFF); })->orderBy('sort_name')->pluck('sort_name', 'id'); //consider renaming touchpoint table's person_id field to contact_id $contact = \montserrat\Contact::findOrFail($touchpoint->person_id); if (isset($contact->subcontact_type)) { $persons = \montserrat\Contact::whereSubcontactType($contact->subcontact_type)->orderBy('sort_name')->pluck('sort_name', 'id'); } else { $persons = \montserrat\Contact::whereContactType($contact->contact_type)->orderBy('sort_name')->pluck('sort_name', 'id'); } //$persons = \montserrat\Contact::whereContactType(CONTACT_TYPE_INDIVIDUAL)->orderBy('sort_name')->pluck('sort_name','id'); // check contact type and if parish get list of parishes if individual get list of persons return view('touchpoints.edit', compact('touchpoint', 'staff', 'persons')); // }
public function contact_info_report($id) { $person = \montserrat\Contact::findOrFail($id); return view('reports.contact_info', compact('person')); // }
public function edit($id) { //get this retreat's information $retreat = \montserrat\Retreat::with('retreatmasters', 'assistant', 'innkeeper', 'captains')->findOrFail($id); $event_types = \montserrat\EventType::whereIsActive(1)->orderBy('name')->pluck('name', 'id'); //create lists of retreat directors, innkeepers, and assistants from relationship to retreat house $retreat_house = \montserrat\Contact::with('retreat_directors.contact_b', 'retreat_innkeepers.contact_b', 'retreat_assistants.contact_b')->findOrFail(CONTACT_MONTSERRAT); foreach ($retreat_house->retreat_innkeepers as $innkeeper) { $i[$innkeeper->contact_id_b] = $innkeeper->contact_b->sort_name; } asort($i); $i = array(0 => 'N/A') + $i; foreach ($retreat_house->retreat_directors as $director) { $d[$director->contact_id_b] = $director->contact_b->sort_name; } asort($d); $d = array(0 => 'N/A') + $d; foreach ($retreat_house->retreat_assistants as $assistant) { $a[$assistant->contact_id_b] = $assistant->contact_b->sort_name; } asort($a); $a = array(0 => 'N/A') + $a; foreach ($retreat_house->retreat_captains as $captain) { $c[$captain->contact_id_b] = $captain->contact_b->sort_name; } asort($c); $c = array(0 => 'N/A') + $c; //dd($a); return view('retreats.edit', compact('retreat', 'd', 'i', 'a', 'c', 'event_types')); }
public function search() { $person = new \montserrat\Contact(); $parishes = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_PARISH)->orderBy('organization_name', 'asc')->with('address_primary.state', 'diocese.contact_a')->get(); $parish_list[0] = 'N/A'; $contact_types = \montserrat\ContactType::whereIsReserved(TRUE)->pluck('label', 'id'); $contact_types->prepend('N/A', 0); $subcontact_types = \montserrat\ContactType::whereIsReserved(FALSE)->whereIsActive(TRUE)->pluck('label', 'id'); $subcontact_types->prepend('N/A', 0); // while probably not the most efficient way of doing this it gets me the result foreach ($parishes as $parish) { $parish_list[$parish->id] = $parish->organization_name . ' (' . $parish->address_primary_city . ') - ' . $parish->diocese_name; } $countries = \montserrat\Country::orderBy('iso_code')->pluck('iso_code', 'id'); $countries->prepend('N/A', 0); $ethnicities = \montserrat\Ethnicity::orderBy('ethnicity')->pluck('ethnicity', 'id'); $ethnicities->prepend('N/A', 0); $genders = \montserrat\Gender::orderBy('name')->pluck('name', 'id'); $genders->prepend('N/A', 0); $languages = \montserrat\Language::orderBy('label')->whereIsActive(1)->pluck('label', 'id'); $languages->prepend('N/A', 0); $prefixes = \montserrat\Prefix::orderBy('name')->pluck('name', 'id'); $prefixes->prepend('N/A', 0); $religions = \montserrat\Religion::orderBy('name')->whereIsActive(1)->pluck('name', 'id'); $religions->prepend('N/A', 0); $states = \montserrat\StateProvince::orderBy('name')->whereCountryId(1228)->pluck('name', 'id'); $states->prepend('N/A', 0); $suffixes = \montserrat\Suffix::orderBy('name')->pluck('name', 'id'); $suffixes->prepend('N/A', 0); $occupations = \montserrat\Ppd_occupation::orderBy('name')->pluck('name', 'id'); $occupations->prepend('N/A', 0); //create defaults array for easier pre-populating of default values on edit/update blade // initialize defaults to avoid undefined index errors $defaults = array(); $defaults['Home']['street_address'] = ''; $defaults['Home']['supplemental_address_1'] = ''; $defaults['Home']['city'] = ''; $defaults['Home']['state_province_id'] = ''; $defaults['Home']['postal_code'] = ''; $defaults['Home']['country_id'] = ''; $defaults['Home']['Phone'] = ''; $defaults['Home']['Mobile'] = ''; $defaults['Home']['Fax'] = ''; $defaults['Home']['email'] = ''; $defaults['Work']['street_address'] = ''; $defaults['Work']['supplemental_address_1'] = ''; $defaults['Work']['city'] = ''; $defaults['Work']['state_province_id'] = ''; $defaults['Work']['postal_code'] = ''; $defaults['Work']['country_id'] = ''; $defaults['Work']['Phone'] = ''; $defaults['Work']['Mobile'] = ''; $defaults['Work']['Fax'] = ''; $defaults['Work']['email'] = ''; $defaults['Other']['street_address'] = ''; $defaults['Other']['supplemental_address_1'] = ''; $defaults['Other']['city'] = ''; $defaults['Other']['state_province_id'] = ''; $defaults['Other']['postal_code'] = ''; $defaults['Other']['country_id'] = ''; $defaults['Other']['Phone'] = ''; $defaults['Other']['Mobile'] = ''; $defaults['Other']['Fax'] = ''; $defaults['Other']['email'] = ''; $defaults['Main']['url'] = ''; $defaults['Work']['url'] = ''; $defaults['Facebook']['url'] = ''; $defaults['Google']['url'] = ''; $defaults['Instagram']['url'] = ''; $defaults['LinkedIn']['url'] = ''; $defaults['Twitter']['url'] = ''; foreach ($person->addresses as $address) { $defaults[$address->location->name]['street_address'] = $address->street_address; $defaults[$address->location->name]['supplemental_address_1'] = $address->supplemental_address_1; $defaults[$address->location->name]['city'] = $address->city; $defaults[$address->location->name]['state_province_id'] = $address->state_province_id; $defaults[$address->location->name]['postal_code'] = $address->postal_code; $defaults[$address->location->name]['country_id'] = $address->country_id; } foreach ($person->phones as $phone) { $defaults[$phone->location->name][$phone->phone_type] = $phone->phone; } foreach ($person->emails as $email) { $defaults[$email->location->name]['email'] = $email->email; } foreach ($person->websites as $website) { $defaults[$website->website_type]['url'] = $website->url; } //dd($person); return view('search.search', compact('prefixes', 'suffixes', 'person', 'parish_list', 'ethnicities', 'states', 'countries', 'genders', 'languages', 'defaults', 'religions', 'occupations', 'contact_types', 'subcontact_types')); }
public function merge($contact_id, $merge_id = NULL) { $contact = \montserrat\Contact::findOrFail($contact_id); $similar = \montserrat\Contact::whereSortName($contact->sort_name)->get(); $duplicates = $similar->keyBy('id'); $duplicates->forget($contact->id); if (!empty($merge_id)) { $merge = \montserrat\Contact::findOrFail($merge_id); //dd($merge); if (empty($contact->prefix_id) && !empty($merge->prefix_id)) { $contact->prefix_id = $merge->prefix_id; } if (empty($contact->first_name) && !empty($merge->first_name)) { $contact->first_name = $merge->first_name; } if (empty($contact->nick_name) && !empty($merge->nick_name)) { $contact->nick_name = $merge->nick_name; } if (empty($contact->middle_name) && !empty($merge->middle_name)) { $contact->middle_name = $merge->middle_name; } if (empty($contact->last_name) && !empty($merge->last_name)) { $contact->last_name = $merge->last_name; } if (empty($contact->organization_name) && !empty($merge->organization_name)) { $contact->organization_name = $merge->organization_name; } if (empty($contact->suffix_id) && !empty($merge->suffix_id)) { $contact->suffix_id = $merge->suffix_id; } if (empty($contact->gender_id) && !empty($merge->gender_id)) { $contact->gender_id = $merge->gender_id; } if (empty($contact->birth_date) && !empty($merge->birth_date)) { $contact->birth_date = $merge->birth_date; } if (empty($contact->religion_id) && !empty($merge->religion_id)) { $contact->religion_id = $merge->religion_id; } if (empty($contact->occupation_id) && !empty($merge->occupation_id)) { $contact->occupation_id = $merge->occupation_id; } if (empty($contact->ethnicity_id) && !empty($merge->ethnicity_id)) { $contact->ethnicity_id = $merge->ethnicity_id; } $contact->save(); //addresses if (NULL === $contact->address_primary) { $contact->address_primary = new \montserrat\Address(); $contact->address_primary->contact_id = $contact->id; $contact->address_primary->is_primary = 1; } if (empty($contact->address_primary->street_address) && !empty($merge->address_primary->street_address)) { $contact->address_primary->street_address = $merge->address_primary->street_address; } if (empty($contact->address_primary->supplemental_address) && !empty($merge->address_primary->supplemental_address)) { $contact->address_primary->supplemental_address = $merge->address_primary->supplemental_address; } if (empty($contact->address_primary->city) && !empty($merge->address_primary->city)) { $contact->address_primary->city = $merge->address_primary->city; } if (empty($contact->address_primary->state_province_id) && !empty($merge->address_primary->state_province_id)) { $contact->address_primary->state_province_id = $merge->address_primary->state_province_id; } if (empty($contact->address_primary->postal_code) && !empty($merge->address_primary->postal_code)) { $contact->address_primary->postal_code = $merge->address_primary->postal_code; } if (empty($contact->address_primary->country_code) && !empty($merge->address_primary->country_code)) { $contact->address_primary->country_code = $merge->address_primary->country_code; } $contact->address_primary->save(); //emergency_contact_info if (NULL === $contact->emergency_contact) { $contact->emergency_contact = new \montserrat\EmergencyContact(); $contact->emergency_contact->contact_id = $contact->id; } if (empty($contact->emergency_contact->name) && !empty($merge->emergency_contact->name)) { $contact->emergency_contact->name = $merge->emergency_contact->name; } if (empty($contact->emergency_contact->relationship) && !empty($merge->emergency_contact->relationship)) { $contact->emergency_contact->relationship = $merge->emergency_contact->relationship; } if (empty($contact->emergency_contact->phone) && !empty($merge->emergency_contact->phone)) { $contact->emergency_contact->phone = $merge->emergency_contact->phone; } if (empty($contact->emergency_contact->phone_alternate) && !empty($merge->emergency_contact->phone_alternate)) { $contact->emergency_contact->phone_alternate = $merge->emergency_contact->phone_alternate; } $contact->emergency_contact->save(); //emails foreach ($merge->emails as $email) { $contact_email = \montserrat\Email::firstOrNew(['contact_id' => $contact->id, 'location_type_id' => $email->location_type_id]); $contact_email->contact_id = $contact->id; $contact_email->location_type_id = $email->location_type_id; $contact_email->is_primary = $email->is_primary; //only create or overwrite if the current email address for the location is empty if (empty($contact_email->email)) { $contact_email->email = $email->email; $contact_email->save(); } } //phones foreach ($merge->phones as $phone) { $contact_phone = \montserrat\Phone::firstOrNew(['contact_id' => $contact->id, "location_type_id" => $phone->location_type_id, "phone_type" => $phone->phone_type]); $contact_phone->contact_id = $contact->id; $contact_phone->location_type_id = $phone->location_type_id; $contact_phone->phone_type = $phone->phone_type; $contact_phone->is_primary = $phone->is_primary; //only create or overwrite if the current email address for the location is empty if (empty($contact_phone->phone)) { $contact_phone->phone = $phone->phone; $contact_phone->save(); } } //notes - move all from merge to contact foreach ($merge->notes as $note) { $note->entity_id = $contact_id; $note->save(); } //groups - move all from merge to contact foreach ($merge->groups as $group) { $group_exist = \montserrat\GroupContact::whereContactId($contact_id)->whereGroupId($group->group_id)->first(); if (!isset($group_exist)) { $group->contact_id = $contact_id; $group->save(); } } //relationships foreach ($merge->a_relationships as $a_relationship) { $a_relationship_exist = \montserrat\Relationship::whereContactIdA($contact_id)->whereContactIdB($a_relationship->contact_id_b)->whereRelationshipTypeId($a_relationship->relationship_type_id)->first(); if (!isset($a_relationship_exist)) { $a_relationship->contact_id_a = $contact_id; $a_relationship->save(); } } foreach ($merge->b_relationships as $b_relationship) { $b_relationship_exist = \montserrat\Relationship::whereContactIdB($contact_id)->whereContactIdA($b_relationship->contact_id_a)->whereRelationshipTypeId($b_relationship->relationship_type_id)->first(); if (!isset($b_relationship_exist)) { $b_relationship->contact_id_b = $contact_id; $b_relationship->save(); } } //touchpoints foreach ($merge->touchpoints as $touchpoint) { $touchpoint->person_id = $contact_id; $touchpoint->save(); } //attachments foreach ($merge->attachments as $attachment) { $path = 'contact/' . $merge_id . '/attachments/' . $attachment->uri; $newpath = 'contact/' . $contact_id . '/attachments/' . $attachment->uri; Storage::move($path, $newpath); $attachment->entity_id = $contact->id; $attachment->save(); } } return view('persons.merge', compact('contact', 'duplicates')); }
public function tylerdiocese() { $parishes = \montserrat\Contact::whereSubcontactType(CONTACT_TYPE_PARISH)->orderBy('organization_name', 'asc')->with('addresses.state', 'phones', 'emails', 'websites', 'pastor.contact_b', 'diocese.contact_a')->whereHas('diocese.contact_a', function ($query) { $query->where('contact_id_a', '=', CONTACT_DIOCESE_TYLER); })->get(); return view('parishes.tylerdiocese', compact('parishes')); // }