user(); if ($user) { $new_messages = count(DB::select( 'SELECT `id` FROM `Messages` WHERE isRead=\'N\' AND `RUID`=?', [$user->id] )); if ($new_messages > 0) { return ' ' . $new_messages . ''; } } return ''; } /** * @return string */ function user_messages() { $user = auth()->user(); $request = request(); if (!$request->has('action')) { /** @var User[] $users */ $users = User::query() ->where('user_id', '!=', $user->id) ->leftJoin('users_personal_data', 'users.id', '=', 'users_personal_data.user_id') ->orderBy('name') ->get(['id', 'name', 'pronoun']); $to_select_data = [ '' => __('Select recipient...') ]; foreach ($users as $u) { $pronoun = ((config('enable_pronoun') && $u->pronoun) ? ' (' . htmlspecialchars($u->pronoun) . ')' : ''); $to_select_data[$u->id] = $u->name . $pronoun; } $to_select = html_select_key('to', 'to', $to_select_data, ''); $messages = DB::select(' SELECT * FROM `Messages` WHERE `SUID`=? OR `RUID`=? ORDER BY `isRead`,`Datum` DESC ', [ $user->id, $user->id, ] ); $messages_table = [ [ 'news' => '', 'timestamp' => date('Y-m-d H:i'), 'from' => User_Nick_render($user), 'to' => $to_select, 'text' => form_textarea('text', '', ''), 'actions' => form_submit('submit', __('Save')) ] ]; foreach ($messages as $message) { $sender_user_source = User::find($message['SUID']); $receiver_user_source = User::find($message['RUID']); $messages_table_entry = [ 'new' => $message['isRead'] == 'N' ? '' : '', 'timestamp' => date('Y-m-d H:i', $message['Datum']), 'from' => User_Nick_render($sender_user_source), 'to' => User_Nick_render($receiver_user_source), 'text' => nl2br(htmlspecialchars($message['Text'])) ]; if ($message['RUID'] == $user->id) { if ($message['isRead'] == 'N') { $messages_table_entry['actions'] = button( page_link_to('user_messages', ['action' => 'read', 'id' => $message['id']]), __('mark as read'), 'btn-xs' ); } } else { $messages_table_entry['actions'] = button( page_link_to('user_messages', ['action' => 'delete', 'id' => $message['id']]), __('delete message'), 'btn-xs' ); } $messages_table[] = $messages_table_entry; } return page_with_title(messages_title(), [ msg(), sprintf(__('Hello %s, here can you leave messages for other angels'), User_Nick_render($user)), form([ table([ 'new' => __('New'), 'timestamp' => __('Date'), 'from' => __('Transmitted'), 'to' => __('Recipient'), 'text' => __('Message'), 'actions' => '' ], $messages_table) ], page_link_to('user_messages', ['action' => 'send'])) ]); } else { switch ($request->input('action')) { case 'read': if ($request->has('id') && preg_match('/^\d{1,11}$/', $request->input('id'))) { $message_id = $request->input('id'); } else { return error(__('Incomplete call, missing Message ID.'), true); } $message = DB::selectOne( 'SELECT `RUID` FROM `Messages` WHERE `id`=? LIMIT 1', [$message_id] ); if (!empty($message) && $message['RUID'] == $user->id) { DB::update( 'UPDATE `Messages` SET `isRead`=\'Y\' WHERE `id`=? LIMIT 1', [$message_id] ); throw_redirect(page_link_to('user_messages')); } else { return error(__('No Message found.'), true); } break; case 'delete': if ($request->has('id') && preg_match('/^\d{1,11}$/', $request->input('id'))) { $message_id = $request->input('id'); } else { return error(__('Incomplete call, missing Message ID.'), true); } $message = DB::selectOne( 'SELECT `SUID` FROM `Messages` WHERE `id`=? LIMIT 1', [$message_id] ); if (!empty($message) && $message['SUID'] == $user->id) { DB::delete('DELETE FROM `Messages` WHERE `id`=? LIMIT 1', [$message_id]); throw_redirect(page_link_to('user_messages')); } else { return error(__('No Message found.'), true); } break; case 'send': if (Message_send($request->input('to'), $request->input('text'))) { throw_redirect(page_link_to('user_messages')); } else { return error(__('Transmitting was terminated with an Error.'), true); } break; default: return error(__('Wrong action.'), true); } } return ''; }