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