/** * @param $filters * @param null $limit * * @return \Illuminate\Database\Eloquent\Collection|static[] */ public function getAll($filters, $limit = null) { $query = $this->post->select('*'); if (!\Entrust::can('manage-all-content')) { $query->where('created_by', auth()->user()->id); } $from = "posts "; if (isset($filters['status']) && $filters['status'] != '') { $status = $filters['status']; $query->whereRaw("posts.metadata->>'status' = ?", [$status]); } if (isset($filters['date_from']) && $filters['date_from'] != '') { $query->whereRaw("date(created_at) >= ?", [str_replace('/', '-', $filters['date_from'])]); } if (isset($filters['date_to']) && $filters['date_to'] != '') { $query->whereRaw("date(created_at) <= ?", [str_replace('/', '-', $filters['date_to'])]); } if (isset($filters['post_type']) && $filters['post_type'] != '') { $post_type = $filters['post_type']; $query->whereRaw("posts.metadata->>'type' = ?", [$post_type]); } if (array_has($filters, "sub_category1")) { $ids = $filters['sub_category1']; $query->category($ids); } if (array_has($filters, "sub_category")) { $category = Category::find($filters['sub_category']); $category_ids = $category->getDescendantsAndSelf()->lists('id')->toArray(); $query->category($category_ids); } if (array_has($filters, "category")) { $category = Category::find($filters['category']); $category_ids = $category->getDescendantsAndSelf()->lists('id')->toArray(); $query->category($category_ids); } $query->from($this->db->raw($from)); $query->orderBy('updated_at', 'DESC'); if (is_null($limit)) { return $query->get(); } return $query->paginate(); }
<div class="col-md-3 left_col"> <div class="left_col scroll-view"> <div class="navbar nav_title" style="border: 0;"> <a href="{{route('home')}}" class="site_title"><i class="fa fa-paw"></i> <span>Shuvayatra</span></a> </div> <div class="clearfix"></div> <br/> <div class="menu_section"> <h3>Content</h3> <ul class=""> <?php $sections = \App\Nrna\Models\Category::all()->toHierarchy(); ?> @foreach($sections as $section) <li class="active"> <span class="">{{$section->title}}</span> <a class="" href="{{route('category.create')}}?section_id={{$section->id}}">Add</a> <ul class="child_menu"> @foreach($section->children as $child) <li>{{$child->title}} <a class="sidebar-edit" href="{{route('category.edit',$child->id)}}?section_id={{$section->id}}" href="">edit</a></li> @endforeach </ul> </li> @endforeach </ul> </div>
/** * Category by section * * @param $section * * @return mixed|static */ public function findBySection($section) { return $this->category->where('section', $section)->first(); }
/** * @param Category $category * * @return mixed */ public function buildCategory(Category $category) { $categoryArray['id'] = $category->id; $categoryArray['title'] = $category->title; $categoryArray['alias_name'] = $category->section; $categoryArray['parent_alias'] = is_null($category->parent_id) ? null : $category->getRoot()->section; $categoryArray['description'] = $category->description; $categoryArray['featured_image'] = $category->main_image_link; $categoryArray['icon'] = $category->icon_link; $categoryArray['small_icon'] = $category->small_icon_link; $categoryArray['position'] = $category->position; $categoryArray['small_icon'] = $category->small_icon_link; $categoryArray['parent_id'] = $category->parent_id; $categoryArray['lft'] = $category->lft; $categoryArray['rgt'] = $category->rgt; $categoryArray['depth'] = $category->depth; $categoryArray['created_at'] = $category->created_at->timestamp; $categoryArray['updated_at'] = $category->updated_at->timestamp; return $categoryArray; }
</div> @if(!request()->has('section_id')) <div class="form-group {{ $errors->has('section') ? 'has-error' : ''}}"> {!! Form::label('section', trans('category.section'), ['class' => 'col-sm-3 control-label']) !!} <div class="col-sm-6"> {!! Form::text('section', null, ['class' => 'form-control']) !!} {!! $errors->first('section', '<p class="help-block">:message</p>') !!} </div> </div> @endif {!! Form::hidden('parent_id', request()->get('section_id', null), ['class' => 'form-control']) !!} <?php $main_category = false; if (request()->has('section_id')) { $main_category = \App\Nrna\Models\Category::find(request()->get('section_id')); } ?> @if($main_category && $main_category->getLevel()==0) <div class="form-group {{ $errors->has('main_image') ? 'has-error' : ''}}"> {!! Form::label('main_image', 'Main Image: ', ['class' => 'col-sm-3 control-label']) !!} <div class="col-sm-6"> {!! Form::file('main_image', null, ['class' => 'form-control']) !!} {!! $errors->first('main_image', '<p class="help-block">:message</p>') !!} @if(isset($category)) <a href="#" class="thumbnail"> <img src="{{$category->main_image_link}}"> </a> @endif </div>
<li> <a href="{{route('apilogs.index')}}">Api Log</a> </li> <li> <a href="{{route('tag.index')}}" class="user-profile dropdown-toggle">Tags</a> </li> <li> <a href="javascript:;" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"> Content <span class="caret"></span> </a> <ul class="dropdown-menu"> <?php $sections = \App\Nrna\Models\Category::roots()->get(); ?> @foreach($sections as $section) <li><a href="{{route('post.index')}}?category={{$section->id}}"> {{$section->title}}</a> </li> @endforeach <li><a href="{{route('category.index')}}"> Manage <i class="glyphicon glyphicon-cog pull-right"></i> </a> </li> </ul> </li> @endrole <li> <a href="javascript:;" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false"> <!-- <img class="img-responsive admin-image" src="{{url()}}/images/user.png" alt=""> -->
<?php $url = route('post.index') . "?" . request()->getQueryString(); ?> <a href="{{removeParam($url,['sub_category','sub_category1'])}}&sub_category={{$child->id}}" class="list-group-item @if(request()->has('sub_category')&& request()->get('sub_category') == $child->id) active @endif" data-parent="#sub-menu">{{$child->title}}</a> @endforeach </div> </div> </div> @endif @if(request()->has('sub_category')) <?php $post_column = $post_column - 2; $sub_category = Category::find(request()->get('sub_category')); ?> <div class="col-md-6 col-xs-12 sub-sidebar mCustomScrollbar"> <div class="list-group"> <span class="list-group-item"><strong>{{$sub_category->title}}</strong><a class="pull pull-right" href="{{route('category.create')}}?section_id={{$sub_category->id}}"><i class="glyphicon glyphicon-plus add-icon"></i>Add</a></span> <?php $subCategories = $sub_category->getImmediateDescendants(); $subCategories = $subCategories->sortBy('position'); ?> @foreach($subCategories as $child) <a href="{{removeParam($url,'sub_category1')}}&sub_category1={{$child->id}}" class="list-group-item @if(request()->has('sub_category1')&& request()->get('sub_category1') == $child->id) active @endif">{{$child->title}}</a> @endforeach
?> @foreach(config('post_type') as $key => $post_type) <li class="icon-wrap @if($post_type_active==$key) active @endif "> <a class="post_type {{$key}}" data-post-type="{{$key}}" href="javascript:;"> {{$post_type}}</a> </li> @endforeach </ul> <?php $tagService = app('App\\Nrna\\Services\\TagService'); $tags = $tagService->getList(); $sectionService = app('App\\Nrna\\Services\\SectionService'); $sections = $sectionService->all(); $categories = \App\Nrna\Models\Category::where('depth', '!=', '0')->lists('title', 'id')->toArray(); $postService = app('App\\Nrna\\Services\\PostService'); $posts = $postService->getAllPosts()->lists('title', 'id')->toArray(); $show_text_type = true; if (isset($post)) { $show_text_type = false; } $post_categories = []; if (request()->has('sub_category1')) { $post_categories[] = request()->get('sub_category1'); } if (request()->has('sub_category')) { $post_categories[] = request()->get('sub_category'); } if (isset($post)) { $post_categories = $post->categories->lists('id')->toArray();