dart_email = $AdminRepository->email_to();
}
public function index()
{
$users = DB::select(DB::raw("select ANY_VALUE(defaulted_users.id) id,ANY_VALUE(username) username,ANY_VALUE(mobile) mobile,ANY_VALUE(mobile_country_code) mobile_country_code, ANY_VALUE(defaulted_users.status) status, SUM(IF(circles.status = 2, 1, 0)) blocked, SUM(IF(circles.status = 3, 1, 0)) suspended from defaulted_users join circles on circles.circle_code = defaulted_users.circle_code group by mobile"));
//dd($users);
// dd($this->dart_email[4]['value']);
return view('admin.pages.defaulted.list', compact('users'));
}
public function status($id) {
$id = base64_decode($id);
$details = DefaultedUser::where('id', $id)->first();
$userData = User::where('mobile_number', $details->mobile)->first();
if($userData){
/*************email********************/
$to = $userData->email;
$email_text='
|
'.__('messages.all_mail_before_name').' '.$userData->first_name.'
|
|
'.__('messages.defaulter_set_by_admin_mail_body_para1').'
|
|
'.__('messages.all_mail_footer_para2').'
'.__('messages.all_mail_footer_para3').'
|
';
//echo $email_text; die;
$data['email_text'] = $email_text;
Mail::send('mail.email_template', $data, function($message) use ($to)
{
$message->from($this->dart_email[4]['value'], 'DANT');
$message->to($to);
$message->subject(__('messages.defaulter_set_by_admin_mail_subject'));
});
/*************email********************/
}
$data = array('status' => 2);
$status = User::where('mobile_number', $details->mobile)->update($data);
$status = DefaultedUser::where('mobile', $details->mobile)->update(['status'=>1]);
session()->flash('success', 'User Status Changed Successfully');
return redirect()->route('admin.defaulted.list');
}
public function details($id)
{
$id = base64_decode($id);
$details = DefaultedUser::where('id', $id)->first();
$userlist = DefaultedUser::where('mobile', $details->mobile)->join('circles','circles.circle_code','=','defaulted_users.circle_code')->select('*','circles.status')->get();
return view('admin.pages.defaulted.details', compact('userlist'));
}
}