function get_client_name($client_id)
{
$client = \App\Models\System\Client\Client::select('given_name', 'surname')->find($client_id);
$name = !empty($client) ? $client->given_name . ' ' . $client->surname : 'Undefined';
return $name;
}
function edit()
{
$lead_id = $this->request->route('id');
$data['lead'] = Lead::where('id', $lead_id)->with('loan')->first();
$users = User::select('id', 'email')->get()->toArray();
$data['users'][0] = 'Select User';
foreach ($users as $user) {
$data['users'][$user['id']] = $user['email'];
}
$clients = Client::select('id', 'preferred_name', 'given_name', 'surname')->get();
$data['clients'][0] = 'Select Client';
foreach ($clients as $client) {
$data['clients'][$client->id] = $client->preferred_name . ' ' . $client->given_name . ' ' . $client->surname;
}
return view('system.lead.edit', $data);
}
function remove($client_id)
{
DB::beginTransaction();
try {
//get details
$client = Client::find($client_id);
//change this later for multiple addresses
$client_address = ClientAddress::where('ex_clients_id', $client->id)->first();
$address = Addresses::find($client_address->address_id);
//phone numbers
$all_client_phones = ClientPhone::where('ex_clients_id', $client->id);
$client_phones = $all_client_phones->get();
$all_client_phones->delete();
/* delete data */
//delete phone numbers
if (!empty($client_phones)) {
foreach ($client_phones as $client_phone) {
$phones = Phone::find($client_phone->phones_id)->delete();
}
}
//delete address
$client_address->delete();
$address->delete();
//delete client
$client->delete();
DB::commit();
// all good
} catch (\Exception $e) {
DB::rollback();
dd($e);
// something went wrong
}
}
function details()
{
$client_id = $this->request->route('id');
$client = Client::select('id', 'preferred_name', 'given_name', 'surname')->find($client_id);
$client->phone = $client->currentPhone();
$view = view('system.client.details', ['client' => $client]);
$template = $view->render();
return $this->success(['template' => $template]);
}
function dataTablePagination(Request $request, array $select = array(), $unassigned_only = false)
{
if (is_array($select) and count($select) < 1) {
$select = "*";
}
$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();
$query = $this->select($select)->with('loan')->first();
if ($orderColumn != '' and $orderdir != '') {
$query = $query->orderBy($orderColumn, $orderdir);
}
if ($search != '') {
$query = $query->where('domain', 'LIKE', "%{$search}%")->orwhere('email', 'LIKE', "%{$search}%");
}
if (!current_user()->isSuperAdmin) {
$query = $query->where('added_by_users_id', current_user_id());
}
$lead['total'] = $query->count();
$query->skip($start)->take($take);
if ($unassigned_only == true) {
$query = $query->where('status', 0);
}
$data = $query->get();
foreach ($data as $key => &$value) {
$client = Client::find($value->ex_clients_id);
if ($value->status == 1) {
$meeting_date = ClientLeadAssign::where('ex_leads_id', $value->id)->first()->meeting_datetime;
$meeting_date = format_datetime($meeting_date);
} else {
$meeting_date = "Not Assigned Yet <a class = 'btn btn-primary btn-xs' href =" . url('system/lead/assign', $value->id) . ">Assign Now</a>";
}
$phone_number = $client->currentPhone();
$value->client = $client->given_name . " " . $client->surname;
$value->preferred_name = $client->preferred_name;
$value->phone_number = $phone_number;
$value->loan_type = $value->loan->loan_type;
$value->meeting_date = $meeting_date;
$value->actual_status = $value->status;
$value->amount = $value->loan->amount;
$value->status = $value->status == 0 ? '<span class="label label-danger">Unassigned</span>' : '<span class="label label-success">Assigned</span>';
}
$lead['data'] = $data->toArray();
$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;
}
