public function get($limit = 30)
{
$query = MavenUniqueKey::with('faqs.tags')->orderBy('sort', 'asc');
if (!$this->_draft_flag) {
$query->where('draft_flag', false);
}
if (count($this->_tags) > 0) {
$tag_query = MavenTag::join('maven_faqs', 'maven_tags.faq_id', '=', 'maven_faqs.id');
foreach ($this->_tags as $locale => $tags) {
foreach ($tags as $tag) {
$tag_query->orWhere(function ($query) use($locale, $tag) {
$query->where('maven_faqs.locale', $locale)->where('maven_tags.tag', $tag);
});
}
}
$unique_key_ids = $tag_query->lists('maven_tags.unique_key_id');
$query->whereIn('id', $unique_key_ids);
}
if (count($this->_unique_keys) > 0) {
$query->where(function ($query) {
foreach ($this->_unique_keys as $unique_key) {
$query->orWhere('unique_key', $unique_key);
}
});
}
return $query->paginate($limit);
}
public function edit($id)
{
$maven_item = MavenUniqueKey::with('faqs')->find($id);
$faqs = $maven_item->faqs->keyBy('locale');
return view('maven.input', ['page_title' => trans('maven.edit'), 'sort_options' => MavenUniqueKey::selectOptions(), 'tag_values' => [], 'locales' => MavenLocale::options(), 'current_locale' => Maven::getLocale(), 'maven_item' => $maven_item, 'faqs' => $faqs, 'mode' => 'update']);
}
