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