function deleteRemoved($lead_id, $expense_ids)
{
$lead = new Lead();
$applicantIds = $lead->getLeadApplicantIds($lead_id);
$old_ids = LivingExpense::whereIn('applicant_id', $applicantIds)->lists('id')->toArray();
$removed_expenses = array_diff($old_ids, $expense_ids);
LivingExpense::whereIn('id', $removed_expenses)->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();
}
