auth->parent_id;
$group = [];
$notesandupdate = Notification::on("mysql_$clientId")->join('master.users', 'crm_notifications.user_id', '=', 'users.id')->orderBy('crm_notifications.id','DESC')
->get(['crm_notifications.*', 'users.first_name','users.last_name'])->all();
return $this->successResponse("Notifications", $notesandupdate);
}
catch (\Throwable $exception)
{
return $this->failResponse("Failed to list of Notifications", [$exception->getMessage()], $exception, $exception->getCode());
}
}
public function create(Request $request)
{
//return $request->all();
try
{
//send email abhishek
$clientId = $request->auth->parent_id;
$Notification = new Notification();
$Notification->setConnection("mysql_$clientId");
$Notification->user_id = $request->auth->id;
$Notification->lead_id = $request->lead_id;
$Notification->message = $request->message;
if ($request->has("type"))
$Notification->type = $request->input("type");
else
$Notification->type = '0';
$Notification->saveOrFail();
$messageData = array(
"lead_id" => $request->lead_id,
"message" => $request->message,
"user_id" => $request->auth->id,
'type' => $request->input("type"),
'mailable' =>"emails.crm-generic"
);
// $data = array('request' => $request);
$notificationData = [
"action" => "notification",
"user" => $messageData
];
//dispatch(new SendCrmNotificationEmail($request->auth->parent_id, $notificationData, 'notification'))->onConnection("database");
$notificationController = new NotificationController();
$notificationController->sendCrmNotification($request->auth->parent_id, $notificationData, 'notification');
// $this->sendEmailNotification($request);
return $this->successResponse("Notification Added Successfully", $Notification->toArray());
}
catch (\Exception $exception)
{
return $this->failResponse("Failed to create Notification ", [
$exception->getMessage()
], $exception, 500);
}
}
public function sendEmailNotificationOLD($request)
{
$clientId = $request->auth->parent_id;
$client = Client::findOrFail($clientId);
$company_name = $client->company_name;
$smtp_setting = SmtpSetting::on("mysql_$clientId")->where('status','1')->first();
$mailable ="emails.crm-generic";
$name = User::findOrFail($request->auth->id);
$subject = 'Status Update - '.$company_name.' Lead Id - '.$request->lead_id;
if($request->input("type") == '1')
{
$message = $name->first_name.' '.$name->last_name.' added notes '.$request->message.'';
}
else
{
$message = $name->first_name.' '.$name->last_name.' - '.$request->message.'';
}
$data = array('subject'=>$subject,'content'=>$message);
$mailService = new CrmMailService($request->auth->parent_id, $mailable, $smtp_setting, $data);
// $to = array('abhi4mca@gmail.com');//env('SYSTEM_ADMIN_EMAIL'); //,'mailme@rohitwanchoo.com'
// $send = $mailService->sendEmail($to);
// $admins = User::where('role', '=', 6)->orWhere('role', '=', 1)->where('is_deleted','=','0')->get()->all();
if(!empty($to))
{
foreach($to as $email)
{
$send = $mailService->sendEmail($email);
}
}
//return response()->json(["success" => true]);
//close send email abhishek
}
public function listbyLeadId(Request $request,$lead_id,$type)
{
//return $this->successResponse("Notifications", [$type]);
try
{
$clientId = $request->auth->parent_id;
/*$notesandupdate = Notification::on("mysql_$clientId")->join('master.users', 'crm_notifications.user_id', '=', 'users.id')->orderBy('crm_notifications.id','DESC')->where('crm_notifications.lead_id',$lead_id)
->get(['crm_notifications.*', 'users.first_name','users.last_name'])->all();*/
if($type == 1)
{
$notesandupdate = Notification::on("mysql_$clientId")->orderBy('crm_notifications.id','DESC')->where('crm_notifications.lead_id',$lead_id)->where('type',$type)
->get(['crm_notifications.*'])->all();
}
else
{
$notesandupdate = Notification::on("mysql_$clientId")->orderBy('crm_notifications.id','DESC')->where('crm_notifications.lead_id',$lead_id)->where('type',$type) //both submission and updates
->get(['crm_notifications.*'])->all();
}
return $this->successResponse("Notifications", $notesandupdate);
}
catch (\Throwable $exception)
{
return $this->failResponse("Failed to list of Notifications", [$exception->getMessage()], $exception, $exception->getCode());
}
}
}