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);
}
}
/**
* createTopics-funktio lähettää Topic-mallille kutsun luoda uusi keskustelu ja Message-mallille lisätä uusi viesti
*/
public static function createTopic()
{
$params = $_POST;
if ($params['title'] != null && $params['content'] != null && !ctype_space($params['title']) && !ctype_space($params['content'])) {
$topic = Topic::createTopic($params['title'], $params['category']);
$message = Message::createMessage($topic->id, $params['content']);
$messages = Message::all($topic->id);
View::make('keskustelu.html', array('topic' => $topic, 'messages' => $messages));
}
$categories = Category::all();
View::make('luokeskustelu.html', array('categories' => $categories, 'error' => "Otsikko tai aloitusviestisi oli tyhjä"));
}
/**
* Returns all the messages of a user
* @param int userid
* @return JSON $messages (object)
*/
public function fetchMessages()
{
$inputJson = Input::json();
$input = (array) $inputJson;
//We need to validate the input first
$rules = array('userid' => ['required']);
$errorMessages = array('userid.required' => 'userid can not be empty');
$validator = Validator::make($input, $rules, $errorMessages);
//Exit early if the validator fails
if ($validator->fails()) {
return Response::json(array('success' => false, 'errors' => $validator->getMessageBag()->toArray()), 400);
// 400 being the HTTP code for an invalid request.
}
$messages = Message::all();
return Response::json($messages);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$messages = Message::all();
return $this->render('messages.index', compact('messages'));
}
<?php
spl_autoload_register(function ($class) {
require_once str_replace('\\', '/', $class) . '.php';
});
$file = __DIR__ . '/storage/database.sqlite';
$options = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ];
$pdo = new PDO("sqlite:{$file}", null, null, $options);
$pdo->exec("\n CREATE TABLE IF NOT EXISTS\n messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n content TEXT,\n published_at DATETIME )\n");
$pdo->exec("\n CREATE TABLE IF NOT EXISTS\n histories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n published_at DATETIME )\n");
// observers
$db = new Observers\DB($pdo, 'histories');
$splFile = new \SplFileObject(__DIR__ . '/storage/data.txt', 'a+');
$file = new Observers\File($splFile);
// subjects
$message = new Message($pdo);
$message->attach($db);
$message->attach($file);
$message->create('Hello world');
var_dump($message->all());
$stmt = $pdo->query('select * from histories');
var_dump($stmt->fetchAll());
var_dump(file_get_contents(__DIR__ . '/storage/data.txt'));
public function getIndex()
{
return View::make('messages.index')->with('messages', Message::all());
}
public function getMessages()
{
return Message::all(array('conditions' => array('conversation_id' => $this->id), 'order' => 'timestamp asc'));
}
Route::get('/associate/{id}', ['as' => 'associate', 'uses' => 'ApartmentController@associateApartment']);
Route::patch('/set-default/{id}', ['as' => 'set-default', 'uses' => 'ApartmentController@setDefaultApartment']);
Route::post('/apartment-userinfo', ['as' => 'post-apartment-userinfo', 'uses' => 'ApartmentController@storeApartmentUserInfo']);
Route::resource('members', 'AdduserController');
Route::resource('polls', 'PollingController');
Route::post('/voteup', ['as' => 'voteup', 'uses' => 'PollingController@voteUp']);
Route::post('/votedown', ['as' => 'votedown', 'uses' => 'PollingController@voteDown']);
Route::get('/accept/{id}', ['as' => 'accept', 'uses' => 'AdminController@acceptAddRequest']);
Route::get('/reject/{id}', ['as' => 'reject', 'uses' => 'AdminController@rejectAddRequest']);
Route::patch('/setflatfloor/{id}', ['as' => 'setflatfloor', 'uses' => 'AdminController@update']);
Route::resource('bank', 'BankController');
Route::get('/linkBank/{id}', ['as' => 'linkBank', 'uses' => 'BankController@linkBank']);
Route::get('/searchbank', ['as' => 'searchbank', 'uses' => 'BankController@searchbank']);
// API
get('api/messages', function () {
return Message::all();
});
post('api/messages', function () {
return Message::create(Request::all());
});
#Image Uploader
#Route::get('/complaint', ['as' => 'complaint', 'uses' => 'ImageController@getUpload']);
Route::resource('complaints', 'ComplaintController');
Route::post('complaint', ['as' => 'complaint-post', 'uses' => 'ImageController@postUpload']);
Route::post('complaint/delete', ['as' => 'complaint-remove', 'uses' => 'ImageController@deleteUpload']);
Route::resource('classifieds', 'ClassifiedController');
Route::get('/timeline', ['as' => 'timeline', 'uses' => 'ComplaintController@getTimeline']);
#External Routes
Route::resource('visitors', 'VisitorController');
#Accounting Controllers
Route::resource('crm', 'CrmController');
public function getModerer()
{
// Are we logged in?
//
if (Auth::check()) {
return View::make('/moderer')->with('messages', Message::all());
}
return View::make('/');
}
