/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update(Request $request, $id)
{
$page = Content::find($id);
$page->fill($request->all());
$page->save();
return Redirect::route("admin.pages.index");
}
public function getRelatedBlog($id)
{
$ids = DB::select('call related(?)', array($id));
if (count($ids) < 3) {
return Content::where("type", "blogs")->orWhere("type", "didactics")->take(3)->get();
}
return Content::find([$ids[0]->content_id, $ids[1]->content_id, $ids[2]->content_id]);
}
public function showGallery(Request $r)
{
$gal = Content::find($r->input('id'));
$hc = new HomeController();
$vars = $hc->getVars();
$lang = $r->session()->get("lang", "fa");
return view('gallery', ["lang" => $lang, "gallery" => $gal, "vars" => $vars]);
}
public function updateContent(Request $request, $id)
{
$content = Content::find($id);
$content->fill($request->all());
$content->featured = $request->input('featured') ? 1 : 0;
$content->published = $request->input('published') ? 1 : 0;
$content->published_at = $request->input('published') ? Carbon::now() : null;
$content->save();
$files = $this->disk->files($this->contentDir . $id);
$response = $content;
return response()->json(compact('response', 'files'));
}
public function store(Request $request)
{
$input = $request->all();
$input['detail'] = delFontInline(delScriptTag($input['detail']));
$comment = Comment::create($input);
$content = Content::find($comment->content_id);
$topic = Topic::find($comment->content_id);
if ($content) {
return redirect(route('content', $content->link));
} elseif ($topic) {
return redirect(route('read_topic', $topic->id));
}
}
public function postEdit(Request $request, $id)
{
$content = Content::find($id);
$content->title = $request->input('title');
$content->body = $request->input('content');
$content->status = $request->input('status');
// add alias
$alias = $content->alias()->first();
if ($request->has('alias')) {
if (!isset($alias)) {
$alias = new UrlAlias();
}
$alias->path = $request->input('alias');
$content->alias()->save($alias);
} else {
// remove the old if we had one...
if (isset($alias)) {
$content->alias()->delete();
}
}
$content->save();
return \Redirect::to('admin/content');
}
public function edit($id)
{
$content = Content::find($id);
return view('haber', compact('content'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function delete($id)
{
$page = Content::find($id);
$type = $page['type'];
$content = new Content();
$content->deleteContentAndAllAssosiatedFiles($id);
return \Redirect::action('Admin\\ContentController@index', ['type' => $type]);
}
/**
* Sort the specified resource from storage.
*
*/
public function sort()
{
foreach (\Input::get('contents') as $key => $id) {
Content::find($id)->update(['line' => $key]);
}
\Activity::log('Menu Id: ' . $id . ' | İçerik Sıralaması Değiştirildi');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$content = Content::find($id);
$content->delete();
return response()->json(['STATUS' => true]);
}
/**
* Remove the specified content from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
Content::find($id)->delete();
Alert::success('Content deleted successfully', 'Deleted!');
return redirect()->back();
}
/**
* Ajax Update the specified to be published or unpublished.
*
* @return echo out result
*/
public function setActiveStatus()
{
$data = Input::all();
if (Request::ajax()) {
$id = Input::get('id');
$post = Content::find($id);
$post->active = $data['active'];
$post->update();
echo $data['active'];
}
}
public function delete(Request $request)
{
/*
* Find the product and delete it
*/
$content_to_delete = Content::find($request->id);
if ($content_to_delete->delete()) {
return view('cms.content', ['contents' => Content::all()]);
} else {
die("There was an error deleting the copy!");
}
}
public function store(Request $request)
{
$rules = ['title' => 'required', 'slug' => 'required|unique:contents', 'type' => 'required', 'category_id' => 'required', 'content' => 'required'];
if ($request->has('id')) {
$content = Content::find($request->get('id'));
$rules = ['slug' => 'required|unique:contents,title,' . $content->id];
}
$v = Validator::make($request->all(), $rules);
if ($v->fails()) {
return redirect()->back()->withErrors($v->errors())->withInput();
}
if ($request->has('id')) {
//$content = Content::find($request->get('id'));
if ($this->user->id == $content->user_id) {
$content->fill($request->all());
$content->save();
} else {
return redirect()->back()->withErrors(['error' => ['Таны агуулга биш байна']]);
}
} else {
$content = Content::create($request->all());
$content->user_id = $this->user->id;
$content->save();
}
return redirect('admin/content/edit/' . $content->id);
}
public function report(\Illuminate\Http\Request $request)
{
// $request->likeValue;
$cont = Content::find($request->contentId);
Content::where('id', '=', $request->contentId)->update(['redflag' => $cont->redflag + $request->reportValue]);
if ($request->reportValue == 1) {
Content::where('id', '=', $request->contentId)->update(['pscore' => $cont->pscore - 20]);
} else {
Content::where('id', '=', $request->contentId)->update(['pscore' => $cont->pscore + 20]);
}
if (Auth::user()) {
if ($request->reportValue == 1) {
Auth::user()->update(['mplaypoints' => Auth::user()->mplaypoints + 20]);
Auth::user()->update(['loyaltypoints' => Auth::user()->loyaltypoints + 20]);
} else {
Auth::user()->update(['mplaypoints' => Auth::user()->mplaypoints - 20]);
Auth::user()->update(['loyaltypoints' => Auth::user()->loyaltypoints - 20]);
}
$userAction = Useraction::where('userid', '=', Auth::user()->id)->where('crefid', '=', $request->contentId)->where('actiontype', '=', 'Flag')->orWhere('actiontype', '=', 'Unflag')->get();
// return $userAction;
if (!$userAction->isEmpty()) {
$newActionType = "";
if ($userAction[0]->actiontype == "Flag") {
$newActionType = "Unflag";
} else {
$newActionType = "Flag";
}
Useraction::where('id', '=', $userAction[0]->id)->update(['actiontype' => $newActionType]);
} else {
$userAction = new Useraction();
$userAction->crefid = $request->contentId;
$userAction->actiontype = "Flag";
$userAction->creftype = "M";
$userAction->userid = Auth::user()->id;
$userAction->save();
return $userAction;
}
// Auth::user()->action()->save($userAction);
}
}
return view('about');
});
Route::get('/home', function () {
return view('welcome');
});
Route::get('menu/{menuId}/categories/{categoryId}/projects/{projectId?}', function ($menuId, $categoryId, $projectId = '') {
$menu = \App\Menu::find($menuId);
$category = \App\Category::find($categoryId);
$categories = \App\Category::where('level', '1')->where('parent_id', $menu->internal_url)->whereNull('deleted_at')->orderBy('ordering')->get();
if ($projectId == '') {
$parentCategory = \App\Category::where('parent_id', $categoryId)->orWhereIn('parent_id', DB::table('categories')->where('parent_id', $categoryId)->whereNull('deleted_at')->lists('id'))->whereNull('deleted_at')->lists('id');
$parentCategorySup = \App\Category::whereNull('deleted_at')->where('parent_id', 'in', implode(' ,', $parentCategory->toArray()))->lists('id');
$contents = \App\Content::where('category_id', $categoryId)->orWhereIn('category_id', $parentCategory->toArray())->whereNull('deleted_at')->orderBy('created_at')->paginate(21);
return view('project_list')->with(['category' => $category, 'categories' => $categories, 'contents' => $contents, 'menu' => $menu]);
} else {
$content = \App\Content::find($projectId);
return view('project_info')->with(['category' => $category, 'categories' => $categories, 'content' => $content, 'menu' => $menu]);
}
})->where(['menuId' => '[0-9]+', 'categoryId' => '[0-9]+', 'projectId' => '[0-9]+']);
Route::get('categories/projects/search', 'CategoryController@search');
Route::post('menu/{menuId}/categories/{categoryId}/projects', function ($menuId, $categoryId) {
$parentCategory = \App\Category::where('parent_id', $categoryId)->orWhereIn('parent_id', DB::table('categories')->where('parent_id', $categoryId)->lists('id'))->whereNull('deleted_at')->lists('id');
$contents = \App\Content::where('category_id', $categoryId)->orWhereIn('category_id', $parentCategory->toArray())->whereNull('deleted_at')->orderBy('created_at')->paginate(21);
$data = View('project_list_template')->with(['contents' => $contents, 'menu' => \App\Menu::find($menuId)])->render();
return response()->json($data);
});
Route::get('locale/{locale?}', ['as' => 'locale.setocale', 'uses' => 'LocaleController@setLocale']);
});
Route::get('/admin/login', function () {
return view('login');
});
public function insertQuery(Request $request)
{
$type = $request->input('type');
$tag = $request->input('tags');
$id = $request->input('id');
$mode = $request->input('mode');
////////////////////////////////////
//mode = 0 edit , mode = 1 insert///
////////////////////////////////////
if ($type == 'events') {
$validator = Validator::make($request->all(), ['title' => 'required', 'address' => 'required', 'body' => 'required', 'tags' => 'required|array']);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput()->with(array('errorcode' => 'events', 'tags' => $this->returnTags()));
} else {
if ($mode == 1) {
$event = new Event();
$content = new Content();
} else {
$event = Event::find($id);
$content = $event->content;
}
$content->title = $request->input('title');
$event->address = $request->input('address');
$content->body = $request->input('body');
$content->type = $type;
$content->save();
$start = $request->input('start-day') . "|" . $request->input('start-month') . "|" . $request->input('start-year') . "|" . $request->input('start-hour') . ":" . $request->input('start-minute');
$end = $request->input('end-day') . "|" . $request->input('end-month') . "|" . $request->input('end-year') . "|" . $request->input('end-hour') . ":" . $request->input('end-minute');
$event->start = $start;
$event->end = $end;
$event->highlight = $request->input('highlight') == NULL ? 0 : 1;
$files = $request->file('img');
foreach ($files as $file) {
if ($file->isValid()) {
$photo = new Photo();
$tempName = $file->getClientOriginalName();
$extension = explode(".", $tempName);
$name = $extension[0] . "-" . time() . "." . $extension[1];
$destination = 'upload';
$file->move($destination, $name);
$photo->path = $destination . "/" . $name;
$content->photos()->save($photo);
}
}
if (!empty($tag)) {
foreach ($tag as $insertTag) {
$row = Tag::where('title', '=', $insertTag)->first();
$content->tags()->save($row);
}
}
$cat = Category::where('title', '=', $request->input('category'))->first();
if ($cat != null) {
$content->categories()->attach($cat->id);
}
$content->event()->save($event);
return redirect('admin');
}
} elseif ($type == 'members') {
$validator = Validator::make($request->all(), ['firstname' => 'required', 'lastname' => 'required', 'email' => 'required']);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput()->with(array('errorcode' => 'members', 'tags' => $this->returnTags()));
} else {
if ($mode == 1) {
$member = new Member();
} else {
$member = Member::find($id);
}
$member->firstname = $request->input('firstname');
$member->lastname = $request->input('lastname');
$member->email = $request->input('email');
//$member->password = $request->input('password');
$member->researchareas = $request->input('researchareas') == NULL ? NULL : $request->input('researchareas');
$member->industrialareas = $request->input('intery') == NULL ? NULL : $request->input('industry');
$member->tel = $request->input('telephone') == NULL ? NULL : $request->input('telephone');
$member->mobile = $request->input('mobile') == NULL ? NULL : $request->input('mobile');
$member->position = $request->input('position') == NULL ? NULL : $request->input('position');
$member->googleplus = $request->input('googleplus') == NULL ? NULL : $request->input('pinterest');
$member->facebook = $request->input('facebook') == NULL ? NULL : $request->input('facebook');
$member->twitter = $request->input('twitter') == NULL ? NULL : $request->input('instagram');
$member->linkedin = $request->input('linkedin') == NULL ? NULL : $request->input('linkedin');
if ($request->hasFile('img')) {
$file = $request->file('img');
if ($file->isValid()) {
$photo = new Photo();
$tempName = $file->getClientOriginalName();
$extension = explode(".", $tempName);
$name = $extension[0] . "-" . time() . "." . $extension[1];
$destination = 'upload';
$file->move($destination, $name);
//$photo->title = $request->input('photoTitle');
$photo->path = $destination . "/" . $name;
Photo::where("member_id", $member->id)->delete();
$member->photo()->save($photo);
}
}
if ($request->hasFile('cv')) {
$file = $request->file('cv');
if ($file->isValid()) {
$tempName = $file->getClientOriginalName();
$extension = explode(".", $tempName);
$name = $extension[0] . "-" . time() . "." . $extension[count($extension) - 1];
$destination = 'upload';
$file->move($destination, $name);
$member->cv = $destination . "/" . $name;
}
}
$member->save();
if ($mode == 0) {
$record = Member::find($id)->records;
foreach ($record as $rec) {
$rec->delete();
}
}
$recordArray = $request->input('rec');
if (!empty($recordArray)) {
foreach ($recordArray as $key) {
if (empty($key['delete'])) {
$key['delete'] = 'off';
}
if ($key['delete'] != "on" && $key['institute'] != "") {
$record = new Record();
$record->institute = $key['institute'];
$record->position = $key['position'];
$record->start = $key['start'];
$record->end = $key['end'];
$record->type = $key['type'];
$member->records()->save($record);
}
}
}
// $cat = Category::where('title', '=', $request->input('category'))->first();
return redirect('admin');
}
} elseif ($type == 'researches') {
$validator = Validator::make($request->all(), ['author' => 'required', 'title' => 'required', 'abstract' => 'required']);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput()->with(array('errorcode' => 'researches', 'tags' => $this->returnTags()));
} else {
if ($mode == 1) {
$research = new Research();
$content = new Content();
} else {
$research = Research::find($id);
$content = $research->content;
}
$content->title = $request->input('title');
$content->body = $request->input('abstract');
$content->type = $type;
$content->save();
$research->author = $request->input('author');
$research->publisher = $request->input('publisher') == NULL ? NULL : $request->input('publisher');
$date = $request->input('date-year') . "|" . $request->input('date-month') . "|" . $request->input('date-day') . "|" . $request->input('date-hour') . ":" . $request->input('date-minute');
$research->date = $date;
$research->external = $request->input("external") == NULL ? true : false;
$research->pages = $request->input('pages') == NULL ? NULL : $request->input('pages');
// $research->abstract = $request->input('abstract') == NULL ? NULL : $request->input('abstract');
$research->keywords = $request->input('keywords') == NULL ? NULL : $request->input('keywords');
$research->link = $request->input('link') == NULL ? NULL : $request->input('link');
$path = $request->file('path');
if (!empty($path) && $path->isValid()) {
$tempName = $path->getClientOriginalName();
$extension = explode(".", $tempName);
$name = $extension[0] . time() . "." . $extension[count($extension) - 1];
$destination = 'upload';
$path->move($destination, $name);
$research->path = $destination . "/" . $name;
}
if (!empty($tag)) {
foreach ($tag as $insertTag) {
$row = Tag::where('title', '=', $insertTag)->first();
$content->tags()->save($row);
}
}
$research->content()->associate($content);
$research->save();
$cat = Category::where('title', '=', $request->input('category'))->first();
if ($cat != null) {
$content->categories()->attach($cat->id);
}
return redirect('admin');
}
} elseif ($type == 'galleries') {
$validator = Validator::make($request->all(), ['title' => 'required', 'body' => 'required']);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput()->with(array('errorcode' => 'galleries', 'tags' => $this->returnTags()));
} else {
if ($mode == 1) {
$content = new Content();
} else {
$content = Content::find($id);
}
$content->title = $request->input('title');
$content->body = $request->input('body');
$content->type = $type;
$content->save();
if ($request->hasFile('img')) {
$file = $request->file('img');
for ($i = 0; $i < count($file); $i++) {
if ($file[$i]->isValid()) {
$photo = new Photo();
$tempName = $file[$i]->getClientOriginalName();
$extension = explode(".", $tempName);
$name = $extension[0] . "-" . time() . (string) $i . "." . $extension[count($extension) - 1];
$destination = 'upload';
$file[$i]->move($destination, $name);
$photo->title = $request->input('imgtitle')[$i];
$photo->path = $destination . "/" . $name;
$photo->highlight = $request->input("highlight")[$i] == "true" ? 1 : 0;
$content->photos()->save($photo);
}
}
}
if ($mode != 1) {
if (!empty($request->input('oldimg'))) {
foreach ($request->input('oldimg') as $img) {
if (empty($img['delete'])) {
$img['delete'] = "off";
$image = Photo::find($img['id']);
$image->title = $img['title'];
$image->highlight = $img['highlight'] == "true" ? 1 : 0;
$image->save();
}
if ($img['delete'] == "on") {
$temp = Photo::find($img['id']);
$temp->delete();
}
}
}
}
if (!empty($tag)) {
foreach ($tag as $insertTag) {
$row = Tag::where('title', '=', $insertTag)->first();
$content->tags()->save($row);
}
}
$cat = Category::where('title', '=', $request->input('category'))->first();
if ($cat != null) {
$content->categories()->attach($cat->id);
}
return redirect('admin');
}
} elseif ($type == 'tags') {
$input = $request->all();
$split = explode("#", $input['body']);
for ($i = 0; $i < count($split); $i++) {
if (!empty($split[$i]) && $split[$i] != '') {
$tag = new Tag();
$tag->title = trim($split[$i]);
$tag->save();
}
}
return redirect('admin');
} elseif ($type == 'categories') {
$cat = new Category();
$cat->title = $request->input("title");
$cat->parent = $request->input("cat-id");
if ($cat->parent == 0) {
$cat->parent = null;
}
$cat->save();
return redirect('admin');
} elseif ($type == "variables") {
$var = Variable::find($id);
$var->title = $request->input("title");
$var->subtitle = $request->input("subtitle");
$var->body = $request->input("body");
if ($request->hasFile('img')) {
$file = $request->file('img');
if ($file->isValid()) {
$tempName = $file->getClientOriginalName();
$extension = explode(".", $tempName);
$name = $extension[0] . "-" . time() . "." . $extension[count($extension) - 1];
$destination = 'upload';
$file->move($destination, $name);
//$photo->title = $request->input('photoTitle');
$var->body = $destination . "/" . $name;
}
}
$var->save();
return redirect('admin');
} else {
$validator = Validator::make($request->all(), ['title' => 'required', 'body' => 'required', 'tags' => 'required|array']);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput()->with(array('errorcode' => 'news', 'tags' => $this->returnTags()));
} else {
if ($mode == 1) {
$news = new Content();
} else {
$news = Content::find($id);
}
$news->title = $request->input('title');
$news->body = $request->input('body');
$news->type = $type;
$news->save();
if ($request->hasFile('img')) {
$files = $request->file('img');
if ($mode == 0) {
$oldphoto = Photo::where("content_id", $id)->first();
$oldphoto->delete();
}
foreach ($files as $file) {
if ($file->isValid()) {
$photo = new Photo();
$tempName = $file->getClientOriginalName();
$extension = explode(".", $tempName);
$name = $extension[0] . "-" . time() . "." . $extension[count($extension) - 1];
$destination = 'upload';
$file->move($destination, $name);
//$photo->title = $request->input('photoTitle');
$photo->path = $destination . "/" . $name;
$news->photos()->save($photo);
}
}
}
if (!empty($tag)) {
foreach ($tag as $insertTag) {
$row = Tag::where('title', '=', $insertTag)->first();
$news->tags()->save($row);
}
}
$cat = Category::find($request->input('cat-id'));
if ($cat != null) {
$news->categories()->attach($cat->id);
}
return redirect('admin');
}
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @param Request $request
* @return \Illuminate\Http\Response
*/
public function edit($id, Request $request)
{
$module = $request->get('module');
$row = $request->get('data');
$partial = $this->provider->edit($module, $row);
$item = \App\Module::findOrFail($module);
$model = \App\Content::find($id);
$model->active = $model->active == "1";
//dd($model);
// dd($item);
return view('admin.element.edit', array('provider' => $this->provider, 'modules' => SelectboxHelper::singleItemToSelect($item), 'id' => $id, 'partial' => $partial, 'model' => $model));
}
public function showDetail($id)
{
$contents = Content::where('id', $id)->get();
$currentid = Content::find($id)->id;
$comments = DB::table('comments')->where('content_id', $currentid)->select('id', 'username', 'comment')->orderBy('comments.created_at', 'desc')->get();
$count = DB::table('comments')->where('content_id', $currentid)->select('id', 'username', 'comment')->orderBy('comments.created_at', 'desc')->count();
return view('content.show')->with('contents', $contents)->with('comments', $comments)->with('count', $count);
}
public function changeStatus($id, Request $request)
{
if (Auth::user()->types === 'admin') {
$content = Content::find($id);
if ($content) {
$content->update($request->all());
}
return redirect()->action('Admin\\ContentController@index');
} else {
return redirect()->route('home');
}
}
