Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.34.1.lve.el8.x86_64

PHP Version:

8.1.34

User:

u823300664

Directory:

/home/u823300664/public_html/app.allspikes.in/app/Http/Controllers/Admin/Notifications

Free Space:

1.9 TB

🔧 Quick Actions

✏️ Editing: NotificationsController.php

<?php
namespace App\Http\Controllers\Admin\Notifications;
use Image;
use Session;
use Exception;
use PDOException;
use App\Models\User;
use App\Models\Language;
use Illuminate\Support\Str;
use Illuminate\Http\Request;
use App\Models\Notification;
use App\Models\EmailTemplate;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\App;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Auth;
use App\Traits\checkPermissionsTrait;
use App\Models\NotificationSentRecord;
use App\Exceptions\InvalidOrderException;
use Illuminate\Support\Facades\Validator;
// use Intervention\Image\Facades\Image as Image;
use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;

class NotificationsController extends Controller
{
    /**
     * Handle an authentication attempt.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */

use checkPermissionsTrait;

public function __construct(){
        $this->middleware('admin');
    }

public function index(){

if(!$this->checkPermission(Auth::user()->role_id, 'notifications', 'is_read')){

return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
        }

$metatitle = "Notification";
        return view('Admin.Notifications.index',compact('metatitle'));
    }

public function getNotification(Request $request){

## Read value
        $draw = $request->get('draw');
        $start = $request->get("start");
        $rowperpage = $request->get("length"); // Rows display per page

$order_arr = $request->get('order');
        $search_arr = $request->get('search');
        $columnName_arr = $request->get('columns');
        $columnIndex_arr = $request->get('order');

$columnIndex = $columnIndex_arr[0]['column']; // Column index
        $columnName = $columnName_arr[$columnIndex]['data']; // Column name
        $columnSortOrder = $order_arr[0]['dir']; // asc or desc
        $searchValue = $search_arr['value']; // Search value
		
		$language_id = 1;
		
        // Total records
        $totalRes = Notification::select('count(*) as allcount');
					if(!empty($language_id)){
						$totalRes->where('language_id',$language_id);
					}
		$totalRecords = $totalRes->count();
		
        // Fetch records

$getRecords =  Notification::orderBy($columnName,$columnSortOrder);
	    $getRecords->where(function ($query) use ($searchValue)
		{ 
			
			if(!empty($searchValue)){
				$value = date('Y-m-d',strtotime(str_replace('/','-',$searchValue)));
                $query->where('title', 'like', '%' .$searchValue . '%')
                ->orWhere('id', 'like', '%' .$searchValue . '%')
                ->orWhere('schedule_type', 'like', '%' .$searchValue . '%')
                ->orWhere('created_at', 'like', '%' .$value . '%')
                ->orWhere('description', 'like', '%' .$searchValue . '%');
			}
		});

if(!empty($language_id))
		{
			$getRecords->where('language_id',$language_id);
		}

$totalRecordswithFilter = $getRecords->count();
	    $getRecords->skip($start)->take($rowperpage);
        $records = $getRecords->get();

$data_arr = array();
        $incKey = 0;

foreach($records as $record){
			
			$id = $record->id;
            $data_arr[$incKey]['id'] = $incKey+1;
			$data_arr[$incKey]['title'] =  !empty($record->title) ? $record->title : '';
			$data_arr[$incKey]['description'] = !empty($record->description) ? Str::of($record->description)->words(15, ' ...') : '';
            $data_arr[$incKey]['created_at'] = !empty($record->created_at) ?  \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $record->created_at)->format('d/m/Y') : '';
            $data_arr[$incKey]['type'] =  !empty($record->schedule_type) ? app('translator')->get('messages.'.$record->schedule_type) : '';
		
			
		
            $are_you_sure_want_to_delete = app('translator')->get('messages.are_you_sure_want_to_delete');

$actions = '';
			if($record->user_type !=2 && $record->user_type !=3){
			$actions .= '<a href="'.route('notification.history',$record->common_id).'" class="btn btn-secondary btn-sm"> '.app('translator')->get('messages.Recipients').'</a> ';
			$actions .= '<a href="'.route('notification.user_list',$record->common_id).'" class="btn btn-secondary btn-sm"> '.app('translator')->get('messages.send status').'</a> ';
			}

if($record->user_type !=1){
			$actions .= '<a href="'.route('notification.edit', $record->common_id).'" class="btn btn-warning btn-sm"> '.app('translator')->get('messages.edit').'</a> ';
			}

$actions .= '<a href="'.route('notification.delete', $record->common_id).'" class="btn btn-danger btn-sm" onclick="return confirm(`'.$are_you_sure_want_to_delete.'`)"> '.app('translator')->get('messages.delete').'</a> ';
 
 $data_arr[$incKey]['action'] = $actions;
			$incKey++;
 }

$response = array(
            "draw" => intval($draw),
            "aaData" => $data_arr,
            "iTotalRecords" => $totalRecords,
            "iTotalDisplayRecords" => $totalRecordswithFilter,
        );

echo json_encode($response);
        exit;
    }

public function create(){

if( !$this->checkPermission(Auth::user()->role_id, 'notifications', 'is_add')){

return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
        }

Session::forget('parent_id');

$Languages = Language::where('status',1)->orderBy('is_default' ,'DESC')->get();
        $userData = User::where('id','!=' , 1)->whereIn('role_id',array(2,4))
                    ->where('delete_status',0)->where('status',1)
                    ->select( DB::raw("CONCAT(first_name,' ',last_name) AS name"),'id')
                    ->pluck('name', 'id');
		$metatitle = "Notification";
        return view('Admin.Notifications.create',compact('metatitle','Languages','userData'));
    }

public function notificationHistory( $notification_id ){

try
        {
            if( !$this->checkPermission(Auth::user()->role_id, 'notifications', 'is_read') )
            {
                return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
            }

$total = $percentage = $totalSend = $totalFail = $totalClick = 0;

$notification = NotificationSentRecord::where('notification_id', $notification_id)->firstOrFail();

$total_user_ids = explode(",", $notification->user_ids);

if (!empty($notification->sent_user_ids)) :
                $total_sent_user_ids = explode(",", $notification->sent_user_ids);
            else :
                $total_sent_user_ids = array();
            endif;

if (count($total_user_ids) > 0) :
                $percentage = (count(array_unique($total_sent_user_ids)) / count(array_unique($total_user_ids))) * 100;
            endif;

$total = count(array_unique($total_user_ids));
            $totalSend = count(array_unique($total_sent_user_ids));
            $percentage = $percentage;

return view('Admin.Notifications.notification-history',compact('notification','total','totalSend','percentage'));
        }
        catch (Exception $e)
        {
            return  redirect()->route('notification.index')
                    ->with('error',app('translator')->get('messages.Data not found'));
        }
    }

public function userList( $notification_id ){

$notification = NotificationSentRecord::where('notification_id', $notification_id)->firstOrFail();

$total_user_ids = explode(",", $notification->user_ids);
            $userList = array();
            if (!empty($total_user_ids))
            {
                $userList = User::whereIn('id', $total_user_ids)->select('first_name' ,'profile_pic','last_name')->whereIn('delete_status',0)->get();
            }

return view('Admin.Notifications.user-list',compact('userList'));
        }
        catch (Exception $e)
        {
            echo $e->getMessage();die;
            return  redirect()->route('notification.index')
                    ->with('error',app('translator')->get('messages.Data not found'));
        }
    }

public function store(Request $request ){

try
 {
 // echo '<pre>'; print_r($request->all());die;

$languages = Language::where('status',1)->where('is_default',1)->first();

$default_link = request('link')[$languages->id];
            $default_title = request('title')[$languages->id];
            $default_description = request('description')[$languages->id];

$title = request('title');
            $description = request('description');
            $link = request('link');

$radius = request('radius');
            $latitude = request('latitude');
            $user_type = request('user_type');
            $longitude = request('longitude');
            $totalusercount = request('totalusercount');
			
			$sending_time 		= NULL;	
			$sending_date 		= NULL;
			$sending_date_time 	= NULL;
			$sending_date_sche 	= NULL;
			$sending_time_sche 	= NULL;
			$monday_status 		= 0;
			$tuesday_status 	= 0;
			$wednesday_status 	= 0;
			$thursday_status 	= 0;
			$friday_status 		= 0;
			$saturday_status 	= 0;
			$sunday_status 		= 0;	
			$role_id = Auth::user()->role_id;
			
			switch(request('schedule_type')){

case "Immediately":
					$sending_time 		= NULL;	
					$sending_date 		= NULL;
					$sending_date_time 	= NULL;
					$sending_date_sche 	= NULL;
					$sending_time_sche 	= NULL;
					$monday_status 		= 0;
					$tuesday_status 	= 0;
					$wednesday_status 	= 0;
					$thursday_status 	= 0;
					$friday_status 		= 0;
					$saturday_status 	= 0;
					$sunday_status 		= 0;					
				break;
				case "Schedule":
			
					$sending_time1 		= !empty(request('sending_time_sche')) ? \Carbon\Carbon::createFromFormat('H:i', request('sending_time_sche'))->format('H:i:s') : '';
				
					$sending_time 		= $sending_time1;
					$sending_date 		= !empty(request('sending_date_sche')) ? \Carbon\Carbon::createFromFormat('d/m/Y', request('sending_date_sche'))->format('Y-m-d') : '';
					$sending_date_time 	= $sending_date.' '.$sending_time;
				break;
				case "ScheduleRecurrence":
					$sending_date_sche = NULL;
					$sending_time_sche = NULL;
					$monday_status 		= !empty(request('monday_status'))?1:0;
					$tuesday_status 	= !empty(request('tuesday_status'))?1:0;
					$wednesday_status 	= !empty(request('wednesday_status'))?1:0;
					$thursday_status 	= !empty(request('thursday_status'))?1:0;
					$friday_status 		= !empty(request('friday_status'))?1:0;
					$saturday_status 	= !empty(request('saturday_status'))?1:0;
					$sunday_status 		= !empty(request('sunday_status'))?1:0;
					$sending_time1 		= !empty(request('schedule_type_recu_time')) ? \Carbon\Carbon::createFromFormat('H:i', request('schedule_type_recu_time'))->format('H:i:s') : '';
					$sending_time 		= $sending_time1;
					$sending_date 		= date('Y-m-d');
					$sending_date_time 	= $sending_date.' '.$sending_time;
					break;
			}			
			//echo '<pre>';print_r($sending_date_sche);die;
			$schedule_type = request('schedule_type');
			$selectUsers = request('select_user');
			if (!empty($selectUsers)){
				$selectUsers = implode(',', $selectUsers);
			}

foreach ($title as $key => $value){

$def_link = request('link')[$key];
                    $def_title = request('title')[$key];
                    $def_description = request('description')[$key];

$create =   Notification::create([
                                'link' => !empty($def_link) ? $def_link : $default_link ,
                                'title' => !empty($def_title) ? $def_title : $default_title ,
                                'address' => !empty(request('address')) ? request('address') : '' ,
                                'latitude' => !empty(request('latitude')) ? request('latitude') : '' ,
                                'longitude' => !empty(request('longitude')) ? request('longitude') : '' ,
                                'language_id' => $key ,
                                'description' => !empty($def_description) ? $def_description : $default_description ,
								'sending_time' 		=> !empty($sending_time)?$sending_time:NULL, 		
								'sending_date' 		=> !empty($sending_date)?$sending_date:NULL, 		
								'sending_date_time' => !empty($sending_date_time)?$sending_date_time:NULL, 	
								'monday_status' 	=> !empty($monday_status)?$monday_status:0,		
								'tuesday_status' 	=> !empty($tuesday_status)?$tuesday_status:0, 	
								'wednesday_status' 	=> !empty($wednesday_status)?$wednesday_status:0, 	
								'thursday_status' 	=> !empty($thursday_status)?$thursday_status:0, 	
								'friday_status' 	=> !empty($friday_status)?$friday_status:0, 		
								'saturday_status' 	=> !empty($saturday_status)?$saturday_status:0, 	
								'sunday_status' 	=> !empty($sunday_status)?$sunday_status:0,
								'schedule_type'	    => !empty($schedule_type)?$schedule_type:'',	
								'role_id' =>$role_id,
								'user_type'=>$user_type,
								'radius'=>!empty($radius)?$radius:0,
								'totalusercount'=>!empty($totalusercount)?$totalusercount:0,
								'user_ids'=>$selectUsers,
                            ]);

$parent_id = $request->session()->get('parent_id');

if(empty($request->session()->get('parent_id'))){
                    $parent_id =  $request->session()->put('parent_id', $create->id);
                }

if(empty($parent_id)){
                    $parent_id = $create->id;
                }

Notification::where('id', $create->id)->update([
                    'parent_id' => $parent_id,
                    'common_id' => $parent_id,
                ]);

if ($create){

switch ($user_type){

case '1':
 $users = DB::select('SELECT users.id as id,user_devices.device_token as device_token,user_devices.device_type as device_type,user_devices.language_id as language_id FROM user_devices INNER JOIN users on users.id = user_devices.user_id where users.status = 1 and users.delete_status = 0 and users.role_id IN = (2,4)');
 break;
 case '2':
 $users = DB::select('(SELECT * FROM user_devices INNER JOIN users on users.id = user_devices.user_id where users.status = 1 && users.id IN('.$selectUsers.'))');
 break;
						case '3':
						 $users = DB::select('SELECT * FROM (SELECT device_type,device_token,user_id AS id,device_latitude, device_longitude,language_id, (6371 * acos(cos(radians(' . $latitude . ')) * cos(radians(device_latitude)) * cos(radians(device_latitude) - radians(' . $longitude . ')) + sin(radians(' . $latitude . ')) * sin(radians(device_latitude)))) AS distance FROM user_devices) AS distances WHERE distance < ' . $radius . ' ORDER BY distance');
						break;
 }
 }
 }

if (!empty($users)){

foreach ($users as $key => $user){

$user_id = $user->id;
                        $language_id = $user->language_id;
                        $all_get_notifications_user_id[] = $user->id;

$def_link = request('link');
                        $def_title = request('title');
                        $def_description = request('description');

$link = (isset($def_link[$language_id]) && !empty($def_link[$language_id])) ? $def_link[$language_id] : $default_link;
                        $title = (isset($def_title[$language_id]) && !empty($def_title[$language_id])) ? $def_title[$language_id] : $default_title;
                        $message = (isset($def_description[$language_id]) && !empty($def_description[$language_id])) ? $def_description[$language_id] : $default_description;

$token = $user->device_token;

$androidData = [
                                        'url' => $link,
                                        'badge' => 0,
                                        'title' => $title,
                                        'message' => $message,
                                        'user_id' => $user_id,
                                        'fromuser_id' => 0,
                                        'related_id' => 0,
                                        'notify_type' => 'adminNotify',
                                    ];

$iosData = [
                                    'alert' => [
                                        'body' => $message,
                                        'title' => $title
                                    ],
                                    'url' => $link,
                                    'user_id' => $user_id,
                                    'notify_type' => 'adminNotify',
                                    'related_id' => 0,
                                    'fromuser_id' => 0,
                                ];

$user_role = 2;
                        if(strtolower($user->device_type) == "android")
                        {
                            $PfplaArgument[] = array('device_type' => "Android",'role' => $user_role,"device_token" => $token,"notification_data" => $androidData);
                        }
                        else if(strtolower($user->device_type) == "ios")
                        {
                            $PfplaArgument[] = array('device_type' => "ios",'role' => $user_role,"device_token" => $token,"notification_data" => $iosData);
                        }
                    }
                }

if($schedule_type == 'Immediately'){

if(!empty($all_get_notifications_user_id)){

NotificationSentRecord::create([
                            'status' => 0,
                            'message' => json_encode($PfplaArgument, JSON_UNESCAPED_UNICODE),
                            'user_ids' => implode(",",array_unique($all_get_notifications_user_id)),
                            'notification_id' => $parent_id,
                        ]);
                    }
                }else{
                    NotificationSentRecord::create([
                                'status' => 0,
                                'message' => null,
                                'user_ids' => null,
                                'notification_id' => $parent_id,
                            ]);
                }

$request->session()->forget('parent_id');
            return  redirect()->route('notification.index')
                    ->with('success',  app('translator')->get('messages.The notification was successfully added'));

}catch (PDOException $e){

return back()->with('error',app('translator')->get('messages.error oocured'));;
        }
    }

public function edit(Notification $Notification , $id){
        try
        {
            if( !$this->checkPermission(Auth::user()->role_id, 'address', 'is_edit') ){

return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
            }
			
			$Languages = Language::where('status',1)->orderBy('is_default' ,'DESC')->get();
			$NotificationData = Notification::where('common_id', $id )->where('language_id', 1 )->first();
			$selectdUser = NotificationSentRecord::where('notification_id', $id )->first();
			$user_selected  = !empty($selectdUser->user_ids)?explode(",",$selectdUser->user_ids):array();
            $notifications = Notification::with('getLanguage')->where('common_id', $id )->get();
			
			$userData = User::where('id','!=' , 1)->whereIn('role_id',array(2,4))
                    ->where('delete_status',0)->where('status',1)
                    ->select( DB::raw("CONCAT(first_name,' ',last_name) AS name"),'id')
                    ->pluck('name', 'id');
			$metatitle = "Notification";
			return view('Admin.Notifications.edit',compact('metatitle','user_selected','NotificationData','notifications','Languages','userData','id'));
        }
        catch (Exception $e)
        {
            // echo $e->getMessage();die;
		
            $route = route('notification.index');
            return view('Admin.Error.error400',compact('route'));
        }
        catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e)
        {
            $route = route('notification.index');
            return view('Admin.Error.error404',compact('route'));

}
    }

public function update(Request $request,$id){
 
 try
 { 
			// echo '<pre>'; print_r($request->all());die;
			
 $languages = Language::where('status',1)->where('is_default',1)->first();

$getNotificationData = Notification::where('common_id' , $id)->where('language_id' , $languages->id)->first();
            $default_link = request('link')[$languages->id];
            $default_title = request('title')[$languages->id];
            $default_description = request('description')[$languages->id];

$title = request('title');
            $description = request('description');
            $link = request('link');

$radius = request('radius');
 $totalusercount = request('totalusercount');
 $latitude = request('latitude');
 $user_type = request('user_type');
 $longitude = request('longitude');
			
			$sending_time 		= NULL;	
			$sending_date 		= NULL;
			$sending_date_time 	= NULL;
			$sending_date_sche 	= NULL;
			$sending_time_sche 	= NULL;
			$monday_status 		= 0;
			$tuesday_status 	= 0;
			$wednesday_status 	= 0;
			$thursday_status 	= 0;
			$friday_status 		= 0;
			$saturday_status 	= 0;
			$sunday_status 		= 0;	
			$role_id = Auth::user()->role_id;
			
			switch(request('schedule_type')){
				case "Immediately":
					$sending_time 		= NULL;	
					$sending_date 		= NULL;
					$sending_date_time 	= NULL;
					$sending_date_sche 	= NULL;
					$sending_time_sche 	= NULL;
					$monday_status 		= 0;
					$tuesday_status 	= 0;
					$wednesday_status 	= 0;
					$thursday_status 	= 0;
					$friday_status 		= 0;
					$saturday_status 	= 0;
					$sunday_status 		= 0;					
				break;
				case "Schedule":
			
					$sending_time1 		= !empty(request('sending_time_sche')) ? \Carbon\Carbon::createFromFormat('H:i', request('sending_time_sche'))->format('H:i:s') : '';
				
					$sending_time 		= $sending_time1;
					$sending_date 		= !empty(request('sending_date_sche')) ? \Carbon\Carbon::createFromFormat('d/m/Y', request('sending_date_sche'))->format('Y-m-d') : '';
					$sending_date_time 	= $sending_date.' '.$sending_time;
				break;
				case "ScheduleRecurrence":
					$sending_date_sche = NULL;
					$sending_time_sche = NULL;
					$monday_status 		= !empty(request('monday_status'))?1:0;
					$tuesday_status 	= !empty(request('tuesday_status'))?1:0;
					$wednesday_status 	= !empty(request('wednesday_status'))?1:0;
					$thursday_status 	= !empty(request('thursday_status'))?1:0;
					$friday_status 		= !empty(request('friday_status'))?1:0;
					$saturday_status 	= !empty(request('saturday_status'))?1:0;
					$sunday_status 		= !empty(request('sunday_status'))?1:0;
					$sending_time1 		= !empty(request('schedule_type_recu_time')) ? \Carbon\Carbon::createFromFormat('H:i', request('schedule_type_recu_time'))->format('H:i:s') : '';
					$sending_time 		= $sending_time1;
					$sending_date 		= date('Y-m-d');
					$sending_date_time 	= $sending_date.' '.$sending_time;
					break;
			}			
			//echo '<pre>';print_r($sending_date_sche);die;
			$schedule_type = request('schedule_type');
			$selectUsers = request('select_user');
			
			if (!empty($selectUsers))
			{
				$selectUsers = implode(',', $selectUsers);
			}

$parent_id = $id;
            foreach ($title as $key => $value){

if(!empty($value))
				{
					$getNotification = Notification::where('common_id' , $id)->where('language_id' , $key)->first();

$def_link = request('link')[$key];
                    $def_title = request('title')[$key];
                    $def_description = request('description')[$key];

if (!empty($getNotification)){
						   
						$update['link'] 		= !empty($def_link)?$def_link:$getNotification->link;
						$update['title'] 		= !empty($def_title)?$def_title:$getNotification->title;
						$update['address'] 		= !empty(request('address')) ? request('address') :$getNotification->address;
						$update['latitude'] 	= !empty(request('latitude')) ? request('latitude') : $getNotification->latitude;
						$update['longitude']	= !empty(request('longitude')) ? request('longitude') : $getNotification->longitude;
						$update['language_id'] 	= $key ;
						$update['description'] 	= !empty($def_description)?$def_description:$getNotification->description;
						$update['sending_time'] 	 = !empty($sending_time)?$sending_time:NULL; 		
						$update['sending_date'] 	 = !empty($sending_date)?$sending_date:NULL; 		
						$update['sending_date_time'] = !empty($sending_date_time)?$sending_date_time:NULL; 	
						$update['monday_status'] 	 = !empty($monday_status)?$monday_status:0;		
						$update['tuesday_status'] 	 = !empty($tuesday_status)?$tuesday_status:0; 	
						$update['wednesday_status']  = !empty($wednesday_status)?$wednesday_status:0; 	
						$update['thursday_status'] 	 = !empty($thursday_status)?$thursday_status:0; 	
						$update['friday_status'] 	 = !empty($friday_status)?$friday_status:0; 		
						$update['saturday_status'] 	 = !empty($saturday_status)?$saturday_status:0; 	
						$update['sunday_status'] 	 = !empty($sunday_status)?$sunday_status:0;
						$update['schedule_type']	 = !empty($schedule_type)?$schedule_type:'';
						$update['user_type']	 = !empty($user_type)?$user_type:0;
						$update['radius']	 = !empty($radius)?$radius:0;
						$update['totalusercount']	 = !empty($totalusercount)?$totalusercount:0;
						$update['user_ids'] = !empty($selectUsers)?$selectUsers:'';
						
									
						$create =  Notification::whereId($getNotification->id)->update($update);		
					}
					else
					{

$input['link'] = !empty($def_link) ? $def_link : $default_link;
						$input['title'] = !empty($def_title) ? $def_title : $default_title;
						$input['address'] = !empty(request('address')) ? request('address') : '' ;
						$input['latitude'] = !empty(request('latitude')) ? request('latitude') : '' ;
						$input['longitude'] = !empty(request('longitude')) ? request('longitude') : '' ;
						$input['language_id'] = $key ;
						$input['description'] = !empty($def_description) ? $def_description : $default_description;
						$input['sending_time'] 		= !empty($sending_time)?$sending_time:NULL; 		
						$input['sending_date'] 		= !empty($sending_date)?$sending_date:NULL; 		
						$input['sending_date_time'] = !empty($sending_date_time)?$sending_date_time:NULL; 	
						$input['monday_status'] 	= !empty($monday_status)?$monday_status:0;		
						$input['tuesday_status'] 	= !empty($tuesday_status)?$tuesday_status:0; 	
						$input['wednesday_status'] 	= !empty($wednesday_status)?$wednesday_status:0; 	
						$input['thursday_status'] 	= !empty($thursday_status)?$thursday_status:0; 	
						$input['friday_status'] 	= !empty($friday_status)?$friday_status:0; 		
						$input['saturday_status'] 	= !empty($saturday_status)?$saturday_status:0; 	
						$input['sunday_status'] 	= !empty($sunday_status)?$sunday_status:0;
						$input['schedule_type']	    = !empty($schedule_type)?$schedule_type:'';	
						$input['user_type']	 = !empty($user_type)?$user_type:0;
						$input['role_id'] 			= $role_id;
						$input['parent_id'] 		= $parent_id;
						$input['common_id'] 		= $parent_id;
						$input['radius']	 		= !empty($radius)?$radius:0;
						$input['totalusercount']	= !empty($totalusercount)?$totalusercount:0;
						$input['user_ids'] = !empty($selectUsers)?$selectUsers:'';
									
						$create = Notification::create($input);			
					}
				}
			}

if ($create){

switch ($user_type){

$users = DB::select('(SELECT * FROM user_devices INNER JOIN users on users.id = user_devices.user_id where users.status=1 && users.id IN('.$selectUsers.'))');
 }
 break;
 case '3':
 $users = DB::select('SELECT * FROM (SELECT device_type,device_token,user_id AS id,device_latitude, device_longitude,language_id, (6371 * acos(cos(radians(' . $latitude . ')) * cos(radians(device_latitude)) * cos(radians(device_latitude) - radians(' . $longitude . ')) + sin(radians(' . $latitude . ')) * sin(radians(device_latitude)))) AS distance FROM user_devices) AS distances WHERE distance < ' . $radius . ' ORDER BY distance');
 break;
 }
	
 if (!empty($users)){

foreach ($users as $key => $user){

$user_id = $user->id;
                            $language_id = $user->language_id;
                            $all_get_notifications_user_id[] = $user->id;

$link = (isset($link[$language_id]) && !empty($link[$language_id])) ? $link[$language_id] : $default_link;
                            $title = (isset($title[$language_id]) && !empty($title[$language_id])) ? $title[$language_id] : $default_title;
                            $message = (isset($description[$language_id]) && !empty($description[$language_id])) ? $description[$language_id] : $default_description;

$token = $user->device_token;

$androidData = [
                                            'url' => $link,
                                            'badge' => 0,
                                            'title' => $title,
                                            'message' => $message,
                                            'user_id' => $user_id,
                                            'fromuser_id' => 0,
                                            'related_id' => 0,
                                            'notify_type' => 'adminNotify',
                                        ];

$iosData = [
                                        'alert' => [
                                            'body' => $message,
                                            'title' => $title
                                        ],
                                        'url' => $link,
                                        'user_id' => $user_id,
                                        'notify_type' => 'adminNotify',
                                        'related_id' => 0,
                                        'fromuser_id' => 0,
                                    ];

$user_role = 2;
                            if(strtolower($user->device_type) == "android")
                            {
                                $PfplaArgument[] = array('device_type' => "Android",'role' => $user_role,"device_token" => $token,"notification_data" => $androidData);
                            }
                            else if(strtolower($user->device_type) == "ios")
                            {
                                $PfplaArgument[] = array('device_type' => "ios",'role' => $user_role,"device_token" => $token,"notification_data" => $iosData);
                            }
                        }
                    }

if($schedule_type == 'Immediately'){

if(!empty($all_get_notifications_user_id)){

return  redirect()->route('notification.index')
                    ->with('success',  app('translator')->get('messages.The notification was successfully updated'));

}
        catch (Exception $e)
        {
			// echo $e->getMessage();die;
            $route = route('notification.index');
            return view('Admin.Error.error400',compact('route'));
        }
        catch (PDOException $e)
        {
            return back()->with('error','Database error occured');;
        }
    }

public function distroy($common_id){
        try
        {
            if( !$this->checkPermission(Auth::user()->role_id, 'notifications', 'is_delete') ){

return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
            }

$notificationData = Notification::where('common_id', $common_id )->delete();

NotificationSentRecord::where('notification_id', $common_id )->delete();

return redirect()->route('notification.index')->with('success',app('translator')->get('messages.The notification has been successfully deleted'));

}
        catch (Exception $e)
        {
            $route = route('faq_option.index');
            return view('Admin.Error.error400',compact('route'));
        }
        catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e)
        {
            $route = route('faq_option.index');
            return view('Admin.Error.error404',compact('route'));
        }
    }

public function updateStatus(Request $request){

if ($request->ajax()){

if( !$this->checkPermission(Auth::user()->role_id, 'notifications', 'is_edit') ){
                return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
            }

$id = request('id');
            $output = array('success' => '', 'error' => '');
            $status = request('status') ? false : true;

$update = FaqOption::where('common_id', $id)->update(['status' => $status]);

if ($update){
                $output['success'] = trans('messages.status_updated_successfully');
            }else{
                $output['error'] = trans('messages.something_worng');
            }

return response()->json($output);
        }
    }

public function userCount(Request $request){

$latitude = request('latitude');
        $longitude = request('longitude');
        $srcradius = request('srcradius');
        $user_type = request('user_type');

$circle_radius = 6371;
 $max_distance = $srcradius;
 // echo '<pre>'; print_r($request->all());die;
 $candidates = '';

if($user_type == 3 && !empty($latitude) && !empty($longitude)){

$candidates = DB::select(
 'SELECT * FROM
 (SELECT device_latitude, device_longitude, (' . $circle_radius . ' * acos(cos(radians(' . $latitude . ')) * cos(radians(device_latitude)) *
 cos(radians(device_latitude) - radians(' . $longitude . ')) +
 sin(radians(' . $latitude . ')) * sin(radians(device_latitude))))
 AS distance
 FROM user_devices) AS distances
 WHERE distance < ' . $max_distance . '
 ORDER BY distance

');
        }

if (!empty($candidates)){
            $newCandidates = count($candidates);
        }else{
            $newCandidates = 0;
        }

return $newCandidates;
    }
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: NotificationsController.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation