public function dashboard() { $user = Auth::user(); $publicnotes = Note::where('user_id', '=', Auth::user()->id)->where('public_or_private', '=', 'public')->get(); $privatenotes = Note::where('user_id', '=', Auth::user()->id)->where('public_or_private', '=', 'private')->get(); $publicsheets = Sheet::where('user_id', '=', Auth::user()->id)->where('public_or_private', '=', 'public')->get(); $privatesheets = Sheet::where('user_id', '=', Auth::user()->id)->where('public_or_private', '=', 'private')->get(); $publicmeetups = Meetup::where('admin_id', '=', Auth::user()->id)->get(); $yournotes = Note::where('user_id', '=', Auth::user()->id)->take(5)->get(); $yoursheets = Sheet::where('user_id', '=', Auth::user()->id)->take(5)->get(); $yourmeetups = Meetup::where('admin_id', '=', Auth::user()->id)->take(5)->get(); $userlists = DB::table('sheets')->where('user_id', Auth::user()->id)->orderBy('created_at', 'desc')->paginate(5); $usernotes = DB::table('notes')->where('user_id', Auth::user()->id)->orderBy('created_at', 'desc')->paginate(5); $alladmin = DB::table('meetups')->where('admin_id', Auth::user()->id)->orderBy('created_at', 'desc')->paginate(5); $allmeetups = DB::table('attendees')->where('attendee_id', Auth::user()->id)->orderBy('created_at', 'desc')->paginate(5); $meetupsyouarepartof = []; if ($allmeetups != null) { foreach ($allmeetups as $individualmeetups) { $meetup = Meetup::find($individualmeetups->meetup_id); array_push($meetupsyouarepartof, $meetup->title); } } else { array_push($meetupsyouarepartof, 'You are not attending any meetups, or you are admin of all of them!'); } return View::make('/users/dashboard')->with('user', $user)->with('userlists', $userlists)->with('usernotes', $usernotes)->with('alladmin', $alladmin)->with('meetupsyouarepartof', $meetupsyouarepartof)->with('publicnotes', $publicnotes)->with('privatenotes', $privatenotes)->with('publicsheets', $publicsheets)->with('privatesheets', $privatesheets)->with('publicmeetups', $publicmeetups)->with('yournotes', $yournotes)->with('yoursheets', $yoursheets)->with('yourmeetups', $yourmeetups); }
public function search() { if ($this->params()->query) { $query = '%' . implode('%', array_filter(explode(' ', $this->params()->query))) . '%'; $this->notes = Note::where("body LIKE ?", $query)->order("id asc")->paginate($this->page_number(), 25); $this->respond_to_list("notes"); } else { $this->notes = new Rails\ActiveRecord\Collection(); } }
public function edit($idOrTitle) { if (is_numeric($idOrTitle)) { $note = Note::find($idOrTitle); } else { $note = Note::where('slug', '=', $idOrTitle)->first(); } if (Auth::user()->id != $note->user_id) { Session::flash('errorMessage', 'You are not authorized to edit this note.'); return Redirect::action('NotesController@index'); } return View::make('notes.edit')->with('note', $note); }
public function destroy($id) { $classe = $this->model->findOrFail($id); $classe->tps()->detach(); $classe->delete(); // Détruit les notes associées à cette classes //TODO mettre un observer sur le delete afin que tous les dépendants se mettre à jour $notes = Note::where('classe_id', '=', $id)->get(); //TODO:: injecter Note foreach ($notes as $note) { $note->delete(); } return true; }
public function deleteCategory($userId, $categoryId) { $date = date('Y-m-d H:i:s'); $cate = Category::where('categoryId', $categoryId)->where('userId', $userId)->first(); $categoryName = $cate->categoryName . (string) $date; if (Category::where('categoryId', $categoryId)->where('userId', $userId)->update(array('categoryName' => $categoryName, 'status' => -1, 'updated_at' => $date))) { // Delete all note in cate Note::where('cateId', $categoryId)->update(array('status' => -1, 'updated_at' => $date)); // Update lasted_update of user table User::updateLastest($userId, $date); return array('status' => 200, 'lastedUpdate' => $date); } else { return array('status' => 304); } }
/** * function nextRow() * Used by both next() and prev() * Search database to find the same systemName * Sort the search in ticketNumber order which gives the index a sequence * Use the index to find the next number in row * Passes content, ticketNumber and systemName to the view (ticket.blade.php) * @param $nextRow - increments to find the next / prev row * @param $checkIndex - not in use */ public function nextRow($nextRow, $checkIndex) { $data = array(); $systemName = $_POST['systemName']; $ticketNumber = $_POST['ticketNumber']; //Getting all the same system number and stores the tickets in an array to find the max ticketNumber $getAllModel = Document::where('systemName', '=', $systemName)->orderBy('documents_id', 'asc')->get(); // $index variable to store the location of the current ticketNumber // Using this variable to locate the next ticketNumber in row $index = 0; $allIndex = []; //Store all index in an array if (sizeof($getAllModel) > 0) { foreach ($getAllModel as $key => $value) { if ($value->ticketNumber == $ticketNumber) { $index = $key; } $allIndex[] = $key; } } $maxIndex = max($allIndex); //Check the max index $minIndex = min($allIndex); //Check the min index usually 0 $nextIndex = $index + $nextRow; //Next index = next row or previous row if ($nextIndex == $maxIndex || $nextIndex == $minIndex) { $data['disable'] = 'disable'; } $nextModel = $getAllModel[$nextIndex]; $data['content'] = $nextModel->fileContent; $data['ticketNumber'] = $nextModel->ticketNumber; $data['systemName'] = $nextModel->systemName; $data['dateOfFile'] = $nextModel->dateOfFile; $data['paxName'] = $nextModel->paxName; $data['airlineName'] = $nextModel->airlineName; //Use next ticketNumber to find the notes in the notes table and put them into an array $comments = array(); $notes = Note::where('ticketNumber', '=', $nextModel->ticketNumber)->get(); foreach ($notes as $key => $value) { $comments[$key]['time'] = $value->created_at->toDateTimeString(); $comments[$key]['content'] = $value->note; } $data['comments'] = $comments; if (sizeof($comments) > 0) { $data['hasComment'] = "<span class='has-comment'>*R*</span>"; } else { $data['hasComment'] = ""; } echo json_encode($data); }
protected function checkExistNote($noteName, $cateId) { $note = Note::where('noteName', $noteName)->where('cateId', $cateId)->first(); if (is_null($note)) { return true; } return false; }