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 view()
{
$users = User::select('id', 'email', 'given_name', 'surname')->get()->toArray();
$data['users'][0] = 'Don\'t Email';
foreach ($users as $user) {
$data['users'][$user['id']] = $user['given_name'] . ' ' . $user['surname'];
}
$lead_id = $this->request->route('id');
$data['logs'] = Lead::with('leadlogs.log')->find($lead_id);
$data['lead_details'] = $this->lead->getLeadDetails($lead_id);
$data['lead_status'] = $this->lead->getLeadStatus($lead_id);
return view('system.lead.view', $data);
}
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 getApplicationDetails($application_id)
{
$lead_id = Application::select('ex_lead_id')->find($application_id)->ex_lead_id;
$lead = new Lead();
$details = $lead->getLeadDetails($lead_id);
return $details;
}
function getLeadStatus($lead_id)
{
$lead = Lead::select('created_at', 'added_by_users_id', 'status')->find($lead_id);
$status = array();
$status['added_on']['date'] = format_datetime($lead->created_at);
$status['added_on']['person'] = get_user_name($lead->added_by_users_id);
$assign = ClientLeadAssign::select('assign_to', 'added_by_users_id', 'created_at', 'status')->where('ex_leads_id', $lead_id)->first();
$status['assign']['date'] = !empty($assign) ? format_datetime($assign->created_at) : '';
$status['assign']['person'] = !empty($assign) ? get_user_name($assign->added_by_users_id) : '';
$status['received']['date'] = !empty($assign) && $assign->status == 1 ? format_datetime($assign->accepted_date) : '';
$status['received']['person'] = !empty($assign) && $assign->status == 1 ? get_user_name($assign->assign_to) : '';
return $status;
}
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();
}
