function delete()
{
$lender_id = $this->request->route('id');
ApplicationLender::where('lender_id', $lender_id)->delete();
Lender::find($lender_id)->delete();
return $this->success(['message' => 'Lender deleted Successfully']);
}
function assign(array $request, $application_id)
{
DB::beginTransaction();
try {
$application = Application::find($application_id);
ApplicationLender::create(['description' => $request['description'], 'lender_id' => $request['lender_id'], 'application_id' => $application_id, 'status' => 0]);
$application->submitted = 1;
$application->save();
DB::commit();
return true;
} catch (\Exception $e) {
DB::rollback();
dd($e);
return false;
}
}
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;
}