public function markAsRead($id)
{
$message = Message::find($id);
$message->read = 1;
$message->save();
return $this->response();
}
/**
* Sets a user's message to opened.
* @since 0.1.0
*/
public function setMessageOpened($id)
{
$message = Message::find($id);
$message->opened = true;
$message->save();
return $message;
}
public function destroy($id)
{
$message = Message::find($id);
if (count($message) > 0) {
return Message::destroy($id);
}
abort(204);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$message = Message::find($id);
if (count($message) > 0) {
return response()->json($message);
}
abort(204);
}
/**
* Send an email with the saved message.
*
* @param $id
* @return Response
*/
public function send($id)
{
$payload = Message::find($id);
$data = array('email' => $payload->email, 'name' => $payload->name, 'content' => $payload->message);
Mail::send('notifications.herpakken', $data, function ($message) use($data) {
$message->to($data['email'], $data['name'])->from('*****@*****.**')->subject('Tijd om je te herpakken!');
});
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$message = Message::find($id);
if (is_null($message)) {
return response()->json(["status" => "Mensagem não encontrada"], 400);
}
$message->delete();
return response()->json($message);
}
/**
* @param $message_id
* @param Request $request
*
* @return mixed
* @throws NotFoundException
*/
public function changeSubject($message_id, Request $request)
{
$this->validate($request, ['subject' => 'required']);
if ($message = Message::find($message_id)) {
$message->update($request->get('subject'));
return $this->respondSuccess('Subject successfully updated', ['message' => Fractal::item($message, new MessageTransformer())]);
}
throw new NotFoundException();
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
$message = Message::find($request->route()->getParameter('id'));
if ($message) {
$message->read = 1;
$message->save();
}
return $next($request);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$msgObj = Message::find($id);
$msgObj->read = 1;
$msgObj->save();
$data = array('type' => 'noreadprivatemsg', 'dest' => $msgObj->to);
event(new MyEventNameHere($data));
$sender = User::find($msgObj->from);
return view('messages.detail', compact('msgObj', 'sender'));
}
/**
* 评论
* @return bool
*/
public function comments(Request $request)
{
$comment = new Comment();
$comment->content = $request->content;
$comment->message_id = $request->message_id;
$comment->user_id = Auth::id();
$comment->message_user_id = Message::find($request->message_id)['user_id'];
$comment->save();
return Redirect('/message_info' . '/' . $request->message_id);
}
/**
* Actualiza la formación de un mensaje es específico
*
* @param MessageRequest $request -> valida los campos requeridos para actualizar un mensaje
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(MessageRequest $request, $id)
{
/* encuentra el mensaje basado en su id (select * from messages where id = $id) */
$message = Message::find($id);
/* $request->all() trae todos los datos que fueron ingresados en la forma */
/* $message->fill() Actualiza sólo los campos que se encuentran en $request->all() */
$message->fill($request->all());
/* guarda los cambios */
$message->save();
/* retorno a el listado de mensajes */
return redirect('msgs');
}
public function viewMessage($id)
{
$message = Message::find($id);
if (!Auth::check()) {
return Redirect::to('/login');
} else {
if (Auth::user()->id != $message->receiver_id) {
return Redirect::to('/inbox');
}
}
DB::table('messages')->where('id', $id)->update(['read' => true]);
return view('message', ['message' => $message]);
}
public function chat()
{
$receiverId = Input::get('receiver');
DB::beginTransaction();
$message = Message::create(['sender' => Session::get(MateMiddleware::$VERIFY), 'receiver' => $receiverId, 'content' => Input::get('content')]);
$mate = Mate::find($receiverId);
$mate->inform = true;
$mate->save();
DB::commit();
$result = Message::find($message->id);
//$result = ['id'=>$message->id, 'sender'=>$message->sender, 'receiver'=>$message->receiver, 'content'=>$message->content, 'edit'=>$message->edit];
return $result;
}
public function onMessage(ConnectionInterface $from, $msg)
{
$msg = json_decode($msg);
if (isset($msg->action)) {
if ($msg->action == Message::CREATE_ACTION_NAME) {
$this->createMessage($from, $msg);
} elseif (isset($msg->id) && $msg->action == Message::DELETE_ACTION_NAME) {
if (($message = Message::find($msg->id)) !== null) {
$this->deleteMessage($message);
}
}
}
}
/**
* Remove message from Discussion
*
* @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector
*/
public function deleteMessage()
{
$input = Input::all();
$message = Message::find($input['delete']);
if (!is_null($message->attachment)) {
$image = 'uploads/projects/' . $message->attachment;
$thumbnail = 'uploads/projects/thumbnails/' . $message->attachment;
if (file_exists($image)) {
unlink($image);
}
if (file_exists($thumbnail)) {
unlink($thumbnail);
}
}
$message->delete();
return redirect('/projects/discussion');
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function message_info($id)
{
$message = Message::find($id);
$message->face = User::find($message->user_id)->face;
$cate = Category::find($message->category);
$message->class_id = $cate->id;
$message->class = $cate->name;
$message->color = $cate->color;
//所属评论
// comments表中属于这个id的评论数据
$comments = DB::table('comments')->select(DB::raw('comments.content,comments.user_id,comments.created_at,users.name,users.face,users.word,users.id as uid'))->leftJoin('users', 'comments.user_id', '=', 'users.id')->where('comments.message_id', '=', $id)->orderBy('comments.created_at', 'desc')->paginate(30);
foreach ($comments as $key => $value) {
$value->created_at = $this->t_time($value->created_at);
}
// return view('home.message_info')->withmessage_info($message)->withcomments($comments);
$data = ['message_info' => $message, 'comments' => $comments];
return view('home.message_info', $data);
}
public function getMessagesdByCid($id)
{
$messages = Message::find($id);
return $messages;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$Message = Message::find($id);
$Message->delete();
return \Redirect::route('message.index');
}
public function delete($id, $token)
{
if (!Entrust::can('manage_message')) {
return redirect('/dashboard')->withErrors(config('constants.NA'));
}
if (!Helper::verifyCsrf($token)) {
return redirect('/dashboard')->withErrors(config('constants.CSRF'));
}
if (!Helper::getMode()) {
return redirect()->back()->withErrors(config('constants.DISABLE_MESSAGE'));
}
$message = Message::find($id);
if (!$message || $message->to_user_id != Auth::user()->id && $message->from_user_id != Auth::user()->id) {
return redirect('/message')->withErrors(config('constants.INVALID_LINK'));
}
if ($message->to_user_id == Auth::user()->id) {
$message->delete_receiver = 1;
} else {
$message->delete_sender = 1;
}
$message->save();
return redirect('/message')->withSuccess(config('constants.DELETED'));
}
public function DeleteMessage($id)
{
$message = Message::find($id);
$message->delete();
return back();
}
public function delete($id)
{
$message = \App\Message::find($id)->delete();
header('Location:' . url() . '/message');
exit;
}
/**
* Change the accepted parameter of the message to 0.
*
*/
public function rejectMessage($id)
{
$message = Message::find($id);
$current = $message->accepted;
if ($message == null) {
return response()->json(['success' => false, 'message' => 'Message with the given id was not found'], self::NOT_FOUND_STATUS_CODE);
}
$message->accepted = 0;
try {
$message->save();
} catch (Exception $e) {
$message->accepted = $current;
return response()->json(['success' => false, 'message' => 'There was an error saving the change', 'resource' => $message], self::SERVER_ERROR_STATUS_CODE);
}
return response()->json(['success' => true, 'message' => 'Status of message successfully changed!', 'resource' => $message]);
}
public function showMessage($id)
{
$message = Message::find($id);
$message->update(['opened' => 1]);
return view('admin.showMessage', compact('message'));
}
/**
* Remove the message by ID.
*
* @param number id
* @return number
*/
public function remove($id)
{
$message = Message::find($id);
return (int) $message->delete();
}
/**
* Fetch a message by id.
*
* @param int $id
*
* @return mixed
*/
public function findById($id)
{
return Message::find($id);
}
public function show($id)
{
$message = Message::find($id);
return view('messages.show', compact('message'));
}
public function edit($id)
{
$message = Message::find($id);
return view('pages.contact.edit', compact('message'));
}
/**
* 删除message
*/
public function del_message($id)
{
Message::find($id)->delete();
Comment::where('message_id', '=', $id)->delete();
return $id;
}
public function check_single_corr($event_id)
{
$user = Auth::user();
$data = Input::all();
$level = $data['level'];
$answer = $data['answer'];
// $event_id = $data['event_id'];
$event_name = $event_id;
$event = Event::where('event_name', $event_id)->first();
if ($event == null) {
return ['status' => 0, '_token' => csrf_token()];
}
$start = strtotime($event->start_time);
$end = strtotime($event->end_time);
$now = time() + 5.5 * 60 * 60;
if ($end < $now) {
//Event has finished ...
return ['status' => 0, '_token' => csrf_token()];
} else {
if ($start < $now && $end > $now) {
//Event is ongoing ...
$question_tuple = Question::where('level', $level)->where('event_id', $event->id)->first();
$user_level = Score::where('user_id', $user->id)->where('event_id', $event->id)->first()['level'];
$randomint = rand(1, Message::count());
$message = Message::find($randomint);
$response = [];
if ($user_level == $level - 1) {
$ans = Answers::where('ques_id', $question_tuple->id)->first();
if ($ans['answer'] == $answer) {
$score = Score::where('user_id', $user->id)->where('event_id', $event->id)->first();
$score->score += $ans['score'];
$score->level += 1;
$score->updated_at = date('Y-m-d H:i:s', time());
$score->save();
if ($score->level == $event->num_ques) {
return ['status' => 1, 'end' => 1];
}
//if level == num_ques then display end page...
$fetched = self::fetch_ques($event_name, $score->level + 1);
$next_q = $fetched['question'];
$response['status'] = 1;
$response['message'] = $message->correct;
$response['question'] = $next_q;
if ($next_q->html != "" || $next_q->html != null) {
$response['html'] = $next_q->html;
}
if ($next_q->image != "" || $next_q->image != null) {
$response['image'] = $next_q->image;
}
$response['level'] = $level + 1;
$response['user_level'] = $user_level + 1;
$response['rank'] = $next_q['rank'];
$response['_token'] = csrf_token();
return $response;
} else {
$response['status'] = 0;
$response['message'] = $message->incorrect;
$response['rank'] = self::rank($event_id);
$response['_token'] = csrf_token();
}
}
//for event type == 3 sc w/ bt and input
//do something else..
return $response;
//return more values to spice it up??
} else {
//Event hasn't started yet ...
return ['status' => 0, '_token' => csrf_token(), 're' => 1];
//can make this interesting ??
//perhaps a waiting area.. ? <<<---- To be done...
}
}
}
