public function show($id = null)
{
// if (is_null($id ))
// {
// return index();
// }
// else
// {
// $notebook = DB::table('notebooks')
// ->join('notebook_user', function($join) {
// $join->on('notebooks.id', '=', 'notebook_user.notebook_id')
// ->where('notebook_user.user_id', '=', Auth::user()->id);
// })
// ->select('notebooks.uuid AS id', 'notebooks.type', 'notebooks.title')
// ->where('notebooks.uuid', '=', $id)
// ->whereNull('notebooks.deleted_at')
// ->first();
// if(is_null($notebook)){
// return PaperworkHelpers::apiResponse(PaperworkHelpers::STATUS_NOTFOUND, array());
// } else {
// $notebook->children = $this->getNotebookChildren($id);
// return PaperworkHelpers::apiResponse(PaperworkHelpers::STATUS_SUCCESS, $notebook);
// }
// }
$notebooks = PaperworkDb::notebook()->get(array('id' => explode(PaperworkHelpers::MULTIPLE_REST_RESOURCE_DELIMITER, $id)))->toArray();
if (empty($notebooks)) {
return PaperworkHelpers::apiResponse(PaperworkHelpers::STATUS_NOTFOUND, array());
}
return PaperworkHelpers::apiResponse(PaperworkHelpers::STATUS_SUCCESS, $notebooks);
}
public function show($notebookId, $id = null)
{
// if (is_null($id ))
// {
// return index($notebookId);
// }
// else
// {
// $note = null;
// // $note = DB::table('notes')
// // ->join('note_user', function($join) {
// // $join->on('notes.id', '=', 'note_user.note_id')
// // ->where('note_user.user_id', '=', Auth::user()->id);
// // })
// // ->join('notebooks', function($join) {
// // $join->on('notes.notebook_id', '=', 'notebooks.id');
// // })
// // ->join('versions', function($join) {
// // $join->on('notes.version_id', '=', 'versions.id');
// // })
// // ->select('notes.id', 'notes.notebook_id', 'notebooks.title as notebook_title', 'versions.title', 'versions.content_preview', 'versions.content', 'notes.created_at', 'notes.updated_at', 'note_user.umask')
// // ->where('notes.notebook_id', ($notebookId>0 ? '=' : '>'), ($notebookId>0 ? $notebookId : '0'))
// // ->where('notes.id', '=', $id)
// // ->whereNull('notes.deleted_at')
// // ->first();
// $note = Note::with(
// array(
// 'users' => function($query) {
// $query->where('note_user.user_id', '=', Auth::user()->id);
// },
// 'notebook' => function($query) use(&$notebookId) {
// $query->where('uuid', '=', $notebookId);
// $query->whereNull('notebooks.deleted_at');
// },
// 'version' => function($query) {
// },
// 'tags' => function($query) {
// }
// )
// )->where('notes.uuid', '=', $id)->whereNull('deleted_at')->get();
// if(is_null($note)){
// return PaperworkHelpers::apiResponse(PaperworkHelpers::STATUS_NOTFOUND, array());
// } else {
// // $note->tags = $this->getNoteTags($id);
// // $note->versions = $this->getNoteVersionsBrief($id);
// return PaperworkHelpers::apiResponse(PaperworkHelpers::STATUS_SUCCESS, $note);
// }
// }
$notes = PaperworkDb::note()->get(array('id' => explode(PaperworkHelpers::MULTIPLE_REST_RESOURCE_DELIMITER, $id)));
// print_r($notes[0]->version()->title);
if (empty($notes)) {
return PaperworkHelpers::apiResponse(PaperworkHelpers::STATUS_NOTFOUND, array());
}
$note = $notes->first();
$note->versions = $this->getNoteVersionsBrief($note->id);
return PaperworkHelpers::apiResponse(PaperworkHelpers::STATUS_SUCCESS, $note);
}
