function deleteAddressDetails($applicant_id) { $addresses = ApplicantAddress::where('applicant_id', $applicant_id); $address_ids = $addresses->lists('address_id'); $addresses->delete(); Addresses::whereIn('id', $address_ids)->delete(); }
function deleteRemoved($lead_id, $income_ids) { $lead = new Lead(); $applicantIds = $lead->getLeadApplicantIds($lead_id); $old_ids = EmploymentDetails::whereIn('applicant_id', $applicantIds)->lists('id')->toArray(); $removed_incomes = array_diff($old_ids, $income_ids); $addressIds = EmploymentDetails::whereIn('id', $removed_incomes)->lists('address_id')->toArray(); $accountants = AccountantDetails::whereIn('employment_details_id', $removed_incomes); $accountant_address_ids = $accountants->lists('business_address_id')->toArray(); $accountants->delete(); Addresses::whereIn('id', $accountant_address_ids)->delete(); EmploymentIncome::whereIn('employment_detail_id', $removed_incomes)->delete(); EmploymentDetails::whereIn('id', $removed_incomes)->delete(); Addresses::whereIn('id', $addressIds)->delete(); }
function deleteRemoved($lead_id, $property_ids) { $lead = new Lead(); $applicantIds = $lead->getLeadApplicantIds($lead_id); $old_ids = Property::whereIn('applicant_id', $applicantIds)->lists('id')->toArray(); $removed_properties = array_diff($old_ids, $property_ids); ExistingLoan::whereIn('property_id', $removed_properties)->delete(); Income::whereIn('property_id', $removed_properties)->delete(); ValuationAccess::whereIn('property_id', $removed_properties)->delete(); $props = Property::whereIn('id', $removed_properties); $removed_addresses = $props->lists('address_id')->toArray(); $props->delete(); Addresses::whereIn('id', $removed_addresses)->delete(); }