/** * @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> @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>
<?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