/** * Update a new Note: load date and forward to view * * @param Request $request, Note $note * @return view */ public function update(Request $request, Note $note) { $categories = Category::All(['id', 'name']); $tags = Tag::All(['id', 'name', 'css_class']); $user = User::find($request->user()->id); //get next id $notes = DB::table('notes')->leftjoin('categories', 'notes.category_id', '=', 'categories.id')->select('notes.id as id'); //handle categories $ses_category_id = $request->session()->get('note_category_id'); if ($ses_category_id) { $notes->where('category_id', '=', $ses_category_id); } //handle search tags $search = $request->session()->get('note_search'); if (strlen($search) > 0) { $search_array = explode(",", $search); $tags_sel = Tag::find($search_array); foreach (explode(",", $search) as $s) { $notes->where('tag_ids', 'like', "%," . $s . ",%"); } } //handle search if ($request->btn_search == "s") { if ($request->search_text) { $request->session()->put('note_search_text', $request->search_text); } else { $request->session()->forget('note_search_text'); } } $search_text = $request->session()->get('note_search_text'); if (strlen($search_text) > 0) { $notes->where(function ($query) use($search_text) { $query->where('notes.title', 'like', "%" . $search_text . "%")->orWhere('notes.description', 'like', "%" . $search_text . "%"); }); } //handle sort order $order = $request->session()->get('note_order'); if (!$order) { $order = 'title'; } //handle sort direction $dir = $request->session()->get('note_dir'); if (!$dir) { $dir = 'ASC'; } $pagination_number = $request->session()->get('pagination_number'); $notes = $notes->orderBy('notes.' . $order, $dir)->orderBy('notes.title', 'ASC')->paginate($pagination_number); $previous_id = 0; $next_id = 0; $counter = 0; $found = false; foreach ($notes as $temp) { if ($found) { $next_id = $temp->id; break; } if ($temp->id == $note->id) { $found = true; } $counter++; if (!$found) { $previous_id = $temp->id; } } return view('notes.update', ['categories' => $categories, 'note' => $note, 'category_id' => False, 'tags' => $tags, 'tags_sel' => $tags_sel = Tag::find(explode(",", $note->tag_ids)), 'previous_id' => $previous_id, 'next_id' => $next_id, 'counter' => $counter, 'total' => count($notes), 'page' => $request->session()->get('note_page'), 'filetab' => $request->filetab])->withNote($note); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $tags = Tag::All(); //view of all tags and some games under each }
/** * Update a new task: load date and forward to view * * @param Request $request, Task $task * @return view */ public function update(Request $request, Person $person) { $user = User::find($request->user()->id); $categories = Category::where('is_note', '=', 0)->orderBy('seq')->get(); $tags = Tag::All(['id', 'name', 'css_class']); $parents = Person::All(['id', 'lastname', 'surname']); //get next id $persons = DB::table('persons')->leftjoin('categories', 'persons.category_id', '=', 'categories.id')->select('persons.id as id'); //handle categories $ses_category_id = $request->session()->get('person_category_id'); if ($ses_category_id) { $persons->where('category_id', '=', $ses_category_id); } //handle search tags $search = $request->session()->get('person_search'); if (strlen($search) > 0) { $search_array = explode(",", $search); $tags_sel = Tag::find($search_array); foreach (explode(",", $search) as $s) { $persons->where('tag_ids', 'like', "%" . $s . "%"); } } //handle search text $search_text = $request->session()->get('person_search_text'); if (strlen($search_text) > 0) { $persons->where('persons.searchname', 'like', "%" . $search_text . "%"); } //handle sort order $order = $request->session()->get('person_order'); if (!$order) { $order = 'lastname'; } //handle sort direction $dir = $request->session()->get('person_dir'); if (!$dir) { $dir = 'ASC'; } //handle filters $filter_parent = $request->session()->get('filter_parent'); if ($filter_parent == 1) { $persons->where('parent_id', '=', 0); } $filter_child = $request->session()->get('filter_child'); if ($filter_child == 1) { $persons->where('parent_id', '>', 0); } $filter_birthday = $request->session()->get('filter_birthday'); if ($filter_birthday == 1) { $persons->where('birthday', '>', 0); $order = 'birthday'; } $pagination_number = $request->session()->get('pagination_number'); $persons = $persons->orderBy($order, $dir)->orderBy('searchname')->paginate($pagination_number); $previous_id = 0; $next_id = 0; $counter = 0; $found = false; foreach ($persons as $temp) { if ($found) { $next_id = $temp->id; break; } if ($temp->id == $person->id) { $found = true; } $counter++; if (!$found) { $previous_id = $temp->id; } } $tags_sel = Tag::find(explode(",", $person->tag_ids)); $children = Person::where('parent_id', '=', $person->id)->orderBy('searchname')->get(); return view('persons.update', ['categories' => $categories, 'person' => $person, 'category_id' => False, 'tags' => $tags, 'tags_sel' => $tags_sel, 'parents' => $parents, 'next_id' => $next_id, 'previous_id' => $previous_id, 'counter' => $counter, 'total' => count($persons), 'children' => $children, 'page' => $request->session()->get('person_page')])->withPerson($person); }