public static function unreadInboxMessageAlert()
{
$new = Message::where('to', '=', Auth::user()->id)->where('checked', '=', 0)->where('type', '=', 1);
$data['count'] = $new->count();
$data['messages'] = $new->get()->toArray();
//tt($data);
return $data;
}
public static function unreadInboxMessageAlert($type)
{
$new = Message::where('to', '=', Auth::user()->id)->where('checked', '=', 0)->where('type', '=', 1);
$data['count'] = $new->count();
if ($type === 'list' || $type === 'all') {
$data['messages'] = $new->get()->toArray();
}
return $data;
}
public function beheer()
{
if (Auth::check()) {
$messages = Message::where('status', '=', 'unsolved')->get();
return View::make('users.admin.beheer', ['messages' => $messages]);
} else {
return Redirect::to('/');
}
}
public function messageList()
{
if (Auth::user()->role == 1) {
$messages = Message::all();
return View::make('backend.user.messagelist')->with('data', $messages);
} elseif (Auth::user()->role == 2) {
$messages = Message::where('recipient_id', '=', Auth::user()->id)->orWhere('mass_message', '=', 1)->get();
return View::make('backend.user.messagelist')->with('data', $messages);
}
}
public function quickView($id)
{
$msg = Message::where('id', '=', $id);
$msgx = $msg->where('to', '=', Auth::user()->id)->get()->toArray();
$msgx = empty($msgx) ? tt('Access denied to this message') : $msgx[0];
//tt($msg->get()->toArray());
$msg->update(array('checked' => 1));
//tt($msg);
$data['msg'] = $msgx;
return View::make('quickview_messagealert', $data);
}
public function getUserMsg($interlocutor_id)
{
$user_id = Auth::user()->id;
$messages = Message::where(function ($query) use($interlocutor_id, $user_id) {
$query->where('addressee_id', $interlocutor_id)->where('sender_id', $user_id);
})->orWhere(function ($query) use($interlocutor_id, $user_id) {
$query->where('addressee_id', $user_id)->where('sender_id', $interlocutor_id);
})->orderBy('created_at', 'desc')->paginate(20);
$interlocutor = array('id' => $interlocutor_id, 'name' => User::where('id', $interlocutor_id)->pluck('name'));
Message::where('addressee_id', $user_id)->where('sender_id', $interlocutor_id)->update(array('isread' => 1));
$view = array('messages' => $messages, 'addressee' => $interlocutor);
return View::make('user.msg.user-msg', $view);
}
public function infinite($chan, $direction, $id)
{
$channel = Channel::where('name', $chan)->firstOrFail();
$log = Message::findOrFail($id);
// Build the query to fetch logs with
if ($direction === 'up') {
$logs = Message::where('channel', $channel->sid)->where('ts', '<', "{$log->ts}")->orderBy('ts', 'desc')->take($this->ajaxLoad)->get();
} else {
$logs = Message::where('channel', $channel->sid)->where('ts', '>', "{$log->ts}")->orderBy('ts', 'asc')->take($this->ajaxLoad)->get();
}
$logs = Message\Repository::convertCollection($logs);
$loadMore = null;
if (count($logs) === $this->ajaxLoad) {
$loadMore = end($logs)->_id;
}
if ($direction === 'up') {
$logs = array_reverse($logs);
}
return View::make('partials.logs', compact('chan', 'logs'))->with('more' . $direction, $loadMore);
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($url, $key)
{
$fbua = ["facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)", "facebookexternalhit/1.1 (+https://www.facebook.com/externalhit_uatext.php)", "facebookexternalhit/1.0 (+http://www.facebook.com/externalhit_uatext.php)", "facebookexternalhit/1.0 (+https://www.facebook.com/externalhit_uatext.php)", "facebookexternalhit/1.2 (+http://www.facebook.com/externalhit_uatext.php)", "facebookexternalhit/1.2 (+https://www.facebook.com/externalhit_uatext.php)"];
if (in_array(Request::header('User-Agent'), $fbua)) {
return View::make('messages.show', ['body' => '']);
}
// Fetch our message
$msg = Message::where('url', '=', $url)->first();
if ($msg->destroyed) {
$body = "This message has been destroyed";
} else {
// Decrypt it
$iv = $msg->iv;
$body = mcrypt_decrypt(MCRYPT_BLOWFISH, $key, $msg->body, MCRYPT_MODE_CFB, $iv);
// Destroy the message
$msg->body = null;
$msg->destroyed = true;
$msg->save();
}
return View::make('messages.show', ['body' => $body]);
}
public function getIndex()
{
$this->pusher = App::make('pusher');
$this->user = Auth::user();
$this->chatChannel = self::DEFAULT_CHAT_CHANNEL;
$this->friends = Enroll::getFriends(\Auth::user());
if (!$this->user) {
return redirect('auth/login');
}
if (!$this->friends) {
return redirect('/main');
}
if (\Input::get('friend')) {
$current_friend = \Input::get('friend');
} else {
$current_friend = $this->friends[0];
}
$messages = Message::where('from_user_id', '=', $this->user->id)->where('to_user_id', '=', $current_friend->id)->orWhere(function ($query) use($current_friend) {
$query->where('from_user_id', '=', $current_friend->id)->where('to_user_id', '=', $this->user->id);
})->get();
return view('chat', ['chatChannel' => $this->chatChannel, 'friends' => $this->friends, 'messages' => $messages, 'current_friend' => $current_friend]);
}
public function sentMessages()
{
$sentMessages = Message::where('from_user_id', Auth::user()->id)->orderBy('created_at', 'desc')->paginate(8);
return $sentMessages;
}
public function checkMsgTypeUsed($type_id)
{
$count = Message::where('type_id', '=', $type_id)->count();
if ($count > 0) {
return true;
} else {
return false;
}
}
public function showActu()
{
return View::make('actu')->with('position', Position::all())->with('messages', Message::where('active', '>', 0)->get());
}
public function sendMails()
{
//gedeelte dat mails verstuurd wanneer er iets deffect of vermist is
$teachers = User::where('type', '=', 'teacher')->get();
$messages = Message::where('status', '=', 'unsolved')->where('mailsend', '=', false)->get();
if (!$messages->isEmpty()) {
Mail::send('emails.message', array('messages' => $messages), function ($message) use($teachers) {
foreach ($teachers as $teacher) {
$message->to($teacher->email, $teacher->lastname . ' ' . $teacher->firstname)->subject("Alle berichten van uitleendienst");
}
});
}
foreach ($messages as $message) {
$message->mailsend = true;
$message->save();
}
//gedeelte dat studenten op de hoogt brengt wanneer hun materiaal nog niet binnen is wanneer iemand anders zijn reservatie start
// de gebruikers + details van reservatie waarvan het materiaal nog niet binnen is of het gebroken of vermist is
$usersMaterialNotAvailable = $this->reservation->checkMaterialAvailable();
if (!empty($usersMaterialNotAvailable)) {
foreach ($usersMaterialNotAvailable as $reservation) {
Mail::send('emails.notavailable', array('reservation' => $reservation), function ($message) use($reservation) {
$message->to($reservation->email, $reservation->lastname . ' ' . $reservation->firstname)->subject('materiaal voor reservatie niet binnen');
});
}
}
// gedeelte waarbij student op de hoogte word gebracht wanneer materiaal niet binnen is na de opgegeven eind tijd
$usersMaterialBringback = $this->reservation->checkMaterialBroughtBack();
if (!empty($usersMaterialBringback)) {
foreach ($usersMaterialBringback as $reservation) {
Mail::send('emails.bringBack', array('reservation' => $reservation), function ($message) use($reservation) {
$message->to($reservation->email, $reservation->lastname . ' ' . $reservation->firstname)->subject('materiaal voor reservatie niet binnen gebracht');
});
}
}
}
public static function textSearch(\Channel $channel, $q)
{
$results = \Message::where('channel', $channel->sid)->where('text', 'like', "%{$q}%")->take(static::$downLimit + static::$upLimit)->orderBy('ts', 'desc')->get();
return static::convertCollection($results);
}
public function deleteUser()
{
$id = Input::get('userId');
$test_user = DB::table('admin_option')->where('option_name', 'Test User Emails')->select('option_value')->get();
if (!empty($test_user)) {
$count = 0;
foreach ($test_user as $value) {
foreach (explode(',', $value->option_value) as $test_user_id) {
if ($id == $test_user_id) {
$count = $count + 1;
}
}
}
} else {
$count = 0;
}
if ($count > 0) {
$connections = Connection::Where('user_id', '=', $id)->first();
if (!empty($connections)) {
$connections->user_id = null;
$connections->save();
}
$deletekarmanote = Karmanote::where('user_idreceiver', '=', $id)->delete();
$deletekarmanote = Karmanote::where('user_idgiver', '=', $id)->delete();
$deleterequest = Meetingrequest::where('user_id_receiver', '=', $id)->delete();
$deletekarmanote = Meetingrequest::where('user_id_giver', '=', $id)->delete();
$deletekarmanote = Meetingrequest::where('user_id_introducer', '=', $id)->delete();
$deleteusergroups = Usersgroup::where('user_id', '=', $id)->delete();
$findquestion = Question::Where('user_id', '=', $id)->get();
if (!empty($findquestion)) {
foreach ($findquestion as $val) {
$question_id = $val->id;
$findgroupquestion = Groupquestion::Where('question_id', '=', $question_id)->get();
if (!empty($findgroupquestion)) {
$deletegroupquestion = Groupquestion::Where('question_id', '=', $question_id)->delete();
}
$findQuestionwillingtohelp = Questionwillingtohelp::Where('question_id', '=', $question_id)->get();
if (!empty($findQuestionwillingtohelp)) {
$deleteQuestionwillingtohelp = Questionwillingtohelp::Where('question_id', '=', $question_id)->delete();
}
}
}
$deleteQuestionwillingtohelp = Questionwillingtohelp::Where('user_id', '=', $id)->delete();
if (!empty($findquestion)) {
$deletequestion = Question::where('user_id', '=', $id)->delete();
}
$deletekarmacircles = Karmacircle::where('user_id', '=', $id)->delete();
$deletekarmaFeed = Karmafeed::where('receiver_id', '=', $id)->orWhere('giver_id', '=', $id)->delete();
$userMykarmaDelete = Mykarma::where('user_id', '=', $id)->delete();
$userMessageDelete = Message::where('receiver_id', '=', $id)->orWhere('giver_id', '=', $id)->delete();
$getIntroDataDelete = KarmaIntro::where('intro_giver_id', '=', $id)->orWhere('intro_receiver_id', '=', $id)->orWhere('intro_introducer_id', '=', $id)->delete();
$getMyKarmaDataDelete = Mykarma::where('user_id', '=', $id)->delete();
$user = User::find($id);
$user->delete();
echo "User " . $id . " deleted";
} else {
echo "User " . $id . " cant be deleted.Its not a test user.";
}
}
public function showMessages()
{
// Only show the messages from this day
$messages = Message::where('published_at', '>', date('Y-m-d') . ' 00:00:00')->where('published_at', '<=', date('Y-m-d') . ' 23:59:59')->orderBy('published_at', 'desc')->get();
return View::make('live', compact('messages'));
}
public function message_history()
{
return Message::where('object_id', '=', $this->id)->orderBy('id', 'desc')->get();
}
public static function countUnreadMessages($user_fp)
{
return Message::where('user_fp', '=', $user_fp)->where('unread', '=', '1')->count();
}
private function markAsRead($chat, $user)
{
$deliverState = false;
foreach ($chat->getMembersTokens(true) as $token) {
MessageUnread::whereRaw('chat_id = ' . $chat->id)->get()->each(function ($unread) use($chat, $user, $deliverState) {
if ($unread->user_id == $user->id) {
$unread->delete();
Message::where('chat_id', $chat->id)->whereNull('delivered_at')->get()->map(function ($message) use($chat, $user, $deliverState) {
if (!$message->delivered_at) {
$message->delivered_at = Carbon::now();
}
if (!$message->viewed_at) {
$message->viewed_at = Carbon::now();
}
$message->save();
});
}
});
$state = new StateSender($token);
if ($deliverState) {
$state->setChatAsDelivered($chat->id, $user->id);
}
$state->setChatAsRead($chat->id, $user->id);
$state->send();
}
$this->updateCounts($chat);
return $this;
}
/**
* 获取未读消息数
*
* @param int $user_id
* @return int
*/
function unread_message_count($user_id = 0)
{
$unread_count = 0;
if (Auth::check()) {
$user_id = !$user_id ? Auth::user()->id : $user_id;
$unread_count = Message::where('user_id', $user_id)->where('type', '>', 1)->where('is_readed', 0)->count();
}
return $unread_count;
}
/**
* Login form processing.
*
* @access public
* @return Redirect
*/
public function postModerer($id)
{
$mess = Message::where('id', '=', $id)->first();
if (Input::get('modifier') !== null) {
if ($mess->active == 1) {
$mess->update(array('active' => 0));
} else {
$mess->update(array('active' => 1));
}
} else {
$mess->delete();
}
return Redirect::to('moderer')->with('success', 'Logged out with success!');
}
public function message()
{
$user_id = Input::get('user_id');
$user = User::find($user_id);
$messages = Message::where('receiver_id', '=', $user_id)->orderBy("created_at", "desc")->get();
foreach ($messages as $message) {
$message['sender'] = User::find($message['sender_id'])->username;
$message['avatar'] = User::find($message['sender_id'])->avatar;
$message['messageCommentCount'] = $message->MessageComments()->count();
$message['comments'] = MessageComment::where("message_id", "=", $message->id)->orderBy("created_at")->get();
foreach ($message["comments"] as &$comment) {
$comment["sender_name"] = User::find($comment["sender_id"])->username;
$comment["receiver_name"] = User::find($comment["receiver_id"])->username;
$comment["sender_avatar"] = User::find($comment["sender_id"])->avatar;
}
}
return View::make('userCenter.message')->with(array('messages' => $messages, 'user' => $user, 'links' => $this->link()));
}
public function messages()
{
// return $this->hasMany('Message')->get();
return Message::where('from', $this->email)->orWhere('to', $this->email)->get();
}
public function searchConversationByID()
{
$input = Input::all();
$user = Auth::user();
$messages = array();
$umessages = Message::where('to', '=', $user['id'])->where('from', $input['id'])->get();
$imessages = Message::where('to', '=', $input['id'])->where('from', $user['id'])->get();
//echo($input['id']);
$i = 0;
foreach ($umessages as $umessage) {
if (true) {
$tou = DB::select('select * from users where id = ?', array($umessage->to));
$fromu = DB::select('select * from users where id = ?', array($umessage->from));
$messages['user']['firstname'] = ucfirst($tou[0]->firstname);
$messages['user']['lastname'] = ucfirst($tou[0]->lastname);
$messages['list'][$i]['id'] = $umessage->id;
$messages['list'][$i]['message'] = $umessage->message;
$messages['list'][$i]['from'] = $umessage->from;
$messages['list'][$i]['to'] = $umessage->to;
$messages['list'][$i]['pic'] = base64_decode($fromu[0]->picture);
$messages['list'][$i]['tousername'] = $tou[0]->firstname . " " . $tou[0]->lastname;
$messages['list'][$i]['fromusername'] = $fromu[0]->firstname . " " . $fromu[0]->lastname;
if ($umessage->from == $user['id']) {
$messages['list'][$i]['type'] = 'current_user';
}
$m = new \MomentPHP\MomentPHP($umessage->updated_at);
$momentFromVo = $m->fromNow();
$messages['list'][$i]['updated_at'] = $momentFromVo;
$i++;
}
}
foreach ($imessages as $imessage) {
if (true) {
$tou = DB::select('select * from users where id = ?', array($imessage->to));
$fromu = DB::select('select * from users where id = ?', array($imessage->from));
$messages['user']['firstname'] = ucfirst($tou[0]->firstname);
$messages['user']['lastname'] = ucfirst($tou[0]->lastname);
$messages['list'][$i]['id'] = $imessage->id;
$messages['list'][$i]['message'] = $imessage->message;
$messages['list'][$i]['from'] = $imessage->from;
$messages['list'][$i]['to'] = $imessage->to;
$messages['list'][$i]['pic'] = base64_decode($fromu[0]->picture);
$messages['list'][$i]['tousername'] = $tou[0]->firstname . " " . $tou[0]->lastname;
$messages['list'][$i]['fromusername'] = $fromu[0]->firstname . " " . $fromu[0]->lastname;
if ($imessage->from == $user['id']) {
$messages['list'][$i]['type'] = 'current_user';
}
$m = new \MomentPHP\MomentPHP($imessage->updated_at);
$momentFromVo = $m->fromNow();
$messages['list'][$i]['updated_at'] = $momentFromVo;
$i++;
}
}
//print_r($messages);
return $messages;
}
public function readAllMessages()
{
$messages = Message::where('to_user_id', Auth::user()->id)->update(['read' => true]);
return Redirect::to('/message');
}
/**
* Clear the chat.
*
* @param $chatId Chat ID
* @return Response
*/
public function clearChatHistory($chatId)
{
if (($chat = Chat::find($chatId)) && $chat->hasMember(Auth::user()->id)) {
$lastMessage = Message::where('chat_id', $chat->id)->orderBy('id', 'desc')->take(1)->get()->first();
ChatCleared::whereRaw('chat_id = ? and user_id = ?', array($chat->id, Auth::user()->id))->delete();
$cleared = new ChatCleared();
$cleared->chat_id = $chat->id;
$cleared->user_id = Auth::user()->id;
$cleared->message_id = $lastMessage->id;
$cleared->save();
return $this->respondNoContent();
} else {
return $this->respondWithError('Chat isn\'t found');
}
}
/**
* Display a listing of messages.
*
* @return Response
*/
public function index()
{
$conversation = Conversation::where('name', Input::get('conversation'))->first();
$messages = Message::where('conversation_id', $conversation->id)->orderBy('created_at')->get();
return View::make('templates/messages')->with('messages', $messages)->render();
}
