/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function acceptCase($id)
{
$caseOwnerObj = CaseOwner::where("caseId", '=', $id)->where("user", '=', \Auth::user()->id)->first();
$numberCases = CaseReport::where('user', '=', \Auth::user()->id)->get();
if (sizeof($caseOwnerObj) > 0) {
$caseOwnerObj->accept = 1;
$caseOwnerObj->save();
$caseActivity = new CaseActivity();
$caseActivity->caseId = $id;
$caseActivity->user = \Auth::user()->id;
$caseActivity->addressbook = 0;
$caseActivity->note = "Case Accepted by " . \Auth::user()->name . ' ' . \Auth::user()->surname;
$caseActivity->save();
$case = CaseReport::find($id);
if ($case->status == "Pending") {
$case->status = "Actioned";
$case->accepted_at = \Carbon\Carbon::now('Africa/Johannesburg')->toDateTimeString();
$case->save();
}
$caseOwners = CaseOwner::where("caseId", '=', $id)->where("user", "<>", \Auth::user()->id)->get();
foreach ($caseOwners as $owner) {
if ($owner->addressbook == 1) {
$user = AddressBook::find($owner->user);
} else {
$user = User::find($owner->user);
}
$data = array('name' => $user->name, 'caseID' => $id, 'acceptedBy' => \Auth::user()->name . ' ' . \Auth::user()->surname);
\Mail::send('emails.acceptCase', $data, function ($message) use($user) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($user->username)->subject("Siyaleader Notification - New Case Accepted: ");
});
}
}
return "ok";
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
\Log::info("Elie Ishimwe");
$nowDate = \Carbon\Carbon::now('Africa/Johannesburg')->toDateTimeString();
//$endDate = \Carbon\Carbon::now('Africa/Johannesburg')->addMinutes(5);
$cases = CaseReport::where('accepted_at', '=', '0000-00-00 00:00:00')->where('referred_at', '<>', '0000-00-00 00:00:00')->get();
\Log::info("Cases:");
\Log::info($cases);
foreach ($cases as $case) {
if ($case->sub_sub_category > 0) {
$firstRespondersObj = CaseResponder::where("sub_sub_category", '=', $case->sub_sub_category)->select('firstResponder')->get();
\Log::info("First Responders");
\Log::info($firstRespondersObj);
\Log::info(sizeof($firstRespondersObj));
$secondRespondersObj = CaseResponder::where("sub_sub_category", '=', $case->sub_sub_category)->select('secondResponder')->get();
\Log::info("Second Responders");
\Log::info($secondRespondersObj);
\Log::info(sizeof($secondRespondersObj));
if (sizeof($firstRespondersObj) > 0) {
$firstResponders = explode(",", $firstRespondersObj->firstResponder);
foreach ($firstResponders as $firstResponder) {
$firstResponderUser = User::find($firstResponder);
$data = array('name' => $firstResponderUser->name, 'caseID' => $case->id, 'caseDesc' => $case->description, 'caseReporter' => $case->description);
\Mail::send('emails.firstNotification', $data, function ($message) use($firstResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($firstResponderUser->username)->subject("Siyaleader Notification - New Case Notification:");
});
}
}
/* if (sizeof($secondRespondersObj) > 0) {
$secondResponders = explode(",",$secondRespondersObj->secondResponder);
foreach ($secondResponders as $secondResponder) {
$secondResponderUser = User::find($secondResponder);
$caseOwner = new CaseOwner();
$caseOwner->user = $secondResponder ;
$caseOwner->caseId = $case->id;
$caseOwner->type = 2;
$caseOwner->active = 1;
$caseOwner->save();
$data = array(
'name' =>$secondResponderUser->name,
'caseID' =>$case->id,
'caseDesc' => $case->description,
'caseReporter' => $case->description,
);
\Mail::send('emails.responder',$data, function($message) use ($secondResponderUser) {
$message->from('*****@*****.**', 'Siyaleader');
$message->to($secondResponderUser->username)->subject("Siyaleader Notification - New Case Reported:");
});
}
}*/
}
}
}
