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'));
}