function assign()
{
$application_id = $this->request->route('id');
$data['application'] = $this->application->getApplicationDetails($application_id);
$lender = Lender::select('id', 'company_name', 'contact_name')->get();
$data['lender'][''] = 'Choose Lender';
if (!empty($lender)) {
$lender = $lender->toArray();
foreach ($lender as $lender_person) {
$data['lender'][$lender_person['id']] = $lender_person['company_name'] . ', ' . $lender_person['contact_name'];
}
}
return view('system.lender.assign', $data);
}
function edit(array $request, $lender_id)
{
$lender = Lender::find($lender_id);
$lender->company_name = $request['company_name'];
$lender->contact_name = $request['contact_name'];
$lender->job_title = $request['job_title'];
$lender->title = $request['title'];
$lender->preferred_name = $request['preferred_name'];
$lender->first_name = $request['first_name'];
$lender->last_name = $request['last_name'];
$lender->phone = $request['phone'];
$lender->email = $request['email'];
$lender->abn = $request['abn'];
$lender->occupation = $request['occupation'];
$lender->commission = $request['commission'];
$lender->save();
}
function dataAcceptedTablePagination(Request $request, $user_id)
{
$take = $request->input('length') > 0 ? $request->input('length') : 10;
$start = $request->input('start') > 0 ? $request->input('start') : 0;
$search = $request->input('search');
$search = $search['value'];
$order = $request->input('order');
$column_id = $order[0]['column'];
$columns = $request->input('columns');
$orderColumn = $columns[$column_id]['data'];
$orderdir = $order[0]['dir'];
$lead = array();
$adminquery = DB::table('applications as app')->join('ex_leads as leads', 'leads.id', '=', 'app.ex_lead_id')->join('ex_clients as clients', 'leads.ex_clients_id', '=', 'clients.id')->join('loans', 'loans.ex_leads_id', '=', 'leads.id')->join('application_assign as assign', 'assign.application_id', '=', 'app.id')->select('app.id', 'clients.given_name', 'clients.surname', 'clients.email', 'loans.amount', 'loans.loan_type', 'app.ex_lead_id as leadId')->where('app.submitted', 1)->where('assign.status', 1)->where('assign.assign_to', $user_id);
$lead['total'] = $adminquery->count();
$adminquery->skip($start)->take($take);
$data = $adminquery->get();
foreach ($data as $key => &$value) {
$assigned_lender = ApplicationLender::where('application_id', $value->id)->first();
if (empty($assigned_lender)) {
$value->isAssigned = false;
$value->assigned = "Not Assigned";
} else {
$value->isAssigned = false;
$lender = Lender::select('company_name')->find($assigned_lender->lender_id);
$value->assigned = $lender->company_name;
}
$value->client_name = $value->given_name . " " . $value->surname;
$value->type = $value->loan_type;
}
$lead['data'] = $data;
$json = new \stdClass();
$json->draw = $request->input('draw') > 0 ? $request->input('draw') : 1;
$json->recordsTotal = $lead['total'];
$json->recordsFiltered = $lead['total'];
$json->data = $lead['data'];
return $json;
}
