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