public function store_group(Request $request) { // $this->validate($request, ['group_id' => 'required|integer|min:0', 'touched_at' => 'required|date', 'staff_id' => 'required|integer|min:0', 'type' => 'in:Email,Call,Letter,Face,Other']); $group_id = $request->input('group_id'); $group_members = \montserrat\GroupContact::whereGroupId($group_id)->whereStatus('Added')->get(); foreach ($group_members as $group_member) { $touchpoint = new \montserrat\Touchpoint(); $touchpoint->person_id = $group_member->contact_id; $touchpoint->staff_id = $request->input('staff_id'); $touchpoint->touched_at = Carbon::parse($request->input('touched_at')); $touchpoint->type = $request->input('type'); $touchpoint->notes = $request->input('notes'); $touchpoint->save(); } return Redirect::action('GroupsController@show', $touchpoint->group_id); }
public function store_group(Request $request) { $this->validate($request, ['register_date' => 'required|date', 'attendance_confirm_date' => 'date', 'registration_confirm_date' => 'date', 'canceled_at' => 'date', 'arrived_at' => 'date', 'departed_at' => 'date', 'event_id' => 'required|integer|min:0', 'group_id' => 'required|integer|min:0', 'deposit' => 'required|numeric|min:0|max:10000']); $retreat = \montserrat\Retreat::findOrFail($request->input('event_id')); $group_members = \montserrat\GroupContact::whereGroupId($request->input('group_id'))->whereStatus('Added')->get(); foreach ($group_members as $group_member) { //ensure that it is a valid room (not N/A) $registration = new \montserrat\Registration(); $registration->event_id = $request->input('event_id'); $registration->contact_id = $group_member->contact_id; $registration->register_date = $request->input('register_date'); $registration->attendance_confirm_date = $request->input('attendance_confirm_date'); if (!empty($request->input('canceled_at'))) { $registration->canceled_at = $request->input('canceled_at'); } if (!empty($request->input('arrived_at'))) { $registration->arrived_at = $request->input('arrived_at'); } if (!empty($request->input('departed_at'))) { $registration->departed_at = $request->input('departed_at'); } $registration->room_id = 0; $registration->registration_confirm_date = $request->input('registration_confirm_date'); $registration->confirmed_by = $request->input('confirmed_by'); $registration->deposit = $request->input('deposit'); $registration->notes = $request->input('notes'); $registration->save(); //TODO: verify that the newly created room assignment does not conflict with an existing one } return Redirect::action('RetreatsController@show' . '', $retreat->id); }
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')); }