public function __construct() { $this->tags = Tag::with(['articles' => function ($query) { $query->select('id'); }])->get(); $settings = Setting::lists('value', 'name')->toArray(); $this->setting = (object) $settings; $this->links = Link::all()->sortBy('sort'); /*$this->tags=Tag::select([ 'tags.*', \DB::raw('ifnull(count(article_tag.tag_id),0) as count') ])->join('article_tag','tags.id','=','article_tag.tag_id') ->join('articles','articles.id','=','article_tag.article_id') ->where('articles.deleted_at',null) ->groupBy('article_tag.tag_id') ->get();*/ }
public function toPdf(Rpd $rpd) { $settings = Setting::lists('value', 'key')->all(); $pdf = PDF::loadView('rpd.pdf', ['rpd' => $rpd, 'settings' => $settings]); return $pdf->stream($rpd->kode . '.pdf'); //return view('rpd.pdf', compact('rpd')); }
public function edit() { $settings = Setting::lists('value', 'key')->all(); return view('setting', compact('settings')); }