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]);
}
