public function simpleexport(Request $request) { // nuse League\Csv\Reader; $kw = $request->input('keyword'); $researchs = Research::where('title', 'like', "%{$kw}%")->orWhere('abstract', 'like', "%{$kw}%")->orWhere('keywords', 'like', "%{$kw}%")->orWhere('authors', 'like', "%{$kw}%")->orWhere('publication_name', 'like', "%{$kw}%")->orderBy('created_at', 'desc')->paginate(9999); $csv = \League\Csv\Writer::createFromFileObject(new \SplTempFileObject()); $csv->insertOne(\Schema::getColumnListing('researchs')); foreach ($researchs as $research) { $csv->insertOne($research->toArray()); } $csv->output('publication_search_export.csv'); }
public function showAbout(Request $r) { $var = $this->getVars(); $content = array(); $content["members"] = Member::get(); $content["tools"] = Content::where('type', '=', 'tools')->orderBy("date_created", "desc")->take(3)->get(); $content["researches"] = Research::where('external', '=', false)->take(2)->get(); $content["researchereas"] = explode('#', $var["research"]["body"]); $content["researchesours"] = Content::where('type', '=', 'researches')->whereHas('research', function ($query) { $query->where('external', 0); })->orderBy("date_created", "desc")->take(2)->get(); $lang = $r->session()->get("lang", "fa"); if ($lang == "en") { return view("test.about", ["content" => $content, "var" => $var, "lang" => $lang]); } return view('about', ["content" => $content, "var" => $var, "lang" => $lang]); }