public function pullCategories()
{
$uri = 'https://tartan.plaid.com/categories';
$client = new Client();
$response = $client->get($uri);
$array = json_decode($response->getBody(), true);
//var_dump($array['66']);
foreach ($array as $record) {
$category = new Categories();
foreach ($record as $key => $value) {
if ($key == 'id') {
if (Categories::where('Cat_ID', '=', $value)->exists()) {
break;
}
$category['Cat_ID'] = $value;
}
//echo "I should not be here";
if ($key == 'type') {
$category['Type'] = $value;
}
if ($key == 'hierarchy') {
$category['c1'] = $value['0'];
isset($value['1']) ? $category['c2'] = $value['1'] : ($category['c2'] = null);
isset($value['2']) ? $category['c3'] = $value['2'] : ($category['c3'] = null);
}
$category->save();
}
}
return view('categories')->with('data', $array);
}
public function post_year($year)
{
// возвращаем посты за year
# обращаемся к моделе Category
$Categories = new Categories();
$categories = $Categories->cats_for_header();
# обращаемся к моделе Page
$pages = new Page();
$footer_pages = $pages->footer_pages();
$Posts_model = new Posts();
$posts = $Posts_model->post_of_year($year);
return view('layouts.default', ['categories' => $categories, 'pages' => $footer_pages, 'content_layout' => 'posts_content', 'posts' => $posts]);
}
public function index()
{
# обращаемся к моделе Category
$vrode_model = new Categories();
$categories = $vrode_model->cats_for_header();
# обращаемся к моделе Page
$pages = new Page();
$footer_pages = $pages->footer_pages();
//Получение разбитого на страницы запроса из базы данных:
$postsi = new Posts();
$per_page = 10;
$posts = $postsi->post_paginate($per_page);
return view('layouts.default', ['categories' => $categories, 'pages' => $footer_pages, 'content_layout' => 'posts_content', 'posts' => $posts]);
}
/**
* Store a newly created resource in storage.
*
* @param CategoryRequest|Request $request
* @return Response
*/
public function store(CategoryRequest $request)
{
$this->validate($request, ['name' => 'required']);
Categories::create(['name' => $request->get('name')]);
message()->success('Alright Sparky !', 'You have created the category !');
return redirect('/category');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$infoArr = [["cat_name" => "先锋网络部专版"], ["cat_name" => "吐槽什么什么的"], ["cat_name" => "技术宅们的世界"], ["cat_name" => "音游交流区"], ["cat_name" => "niconico 分享"], ["cat_name" => "声控灯"], ["cat_name" => "管理版"]];
foreach ($infoArr as $data) {
Categories::create($data);
}
}
public function pullCategories()
{
$uri = 'https://tartan.plaid.com/categories';
$client = new Client();
$response = $client->get($uri);
$categories = json_decode($response->getBody(), true);
// var_dump($categories);
foreach ($categories as $category_key => $category_value) {
$category = Categories::find($category_value['id']);
if (!$category) {
$category = new Categories();
$category['id'] = $category_value['id'];
$category['type'] = $category_value['type'];
isset($category_value['hierarchy'][0]) ? $category['c1'] = $category_value['hierarchy'][0] : ($category['c1'] = null);
isset($category_value['hierarchy'][1]) ? $category['c2'] = $category_value['hierarchy'][1] : ($category['c2'] = null);
isset($category_value['hierarchy'][2]) ? $category['c3'] = $category_value['hierarchy'][2] : ($category['c3'] = null);
// if(isset($category_value['meta']['location']['city']))
// $category['location_city'] = $category_value['meta']['location']['city'];
var_dump($category);
$category->save();
// die;
}
}
return view('categories')->with('data', $category);
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
// $user_id = 1;
// $productsCount = Products::count();
// $product = Products::get();
// $ordersCount = DB::select('select count(*) as say from orders where cast(created_at as DATE) = ?', array(Carbon::now()->format('Y-m-d')));
//
// if ($productsCount != ($ordersCount[0]->say)) {
// foreach ($product as $key => $pro) {
//// $ordersCount = DB::select('select count(*) as say from orders where cast(created_at as DATE) = ? and ProductName = ? ', array(Carbon::now()->format('Y-m-d'), $pro->Name));
////dd(Carbon::now()->format('Y-m-d h:i:s'));
//// dd(Carbon::now());
// $today = Carbon::now()->format('Y-m-d h:n:s');
// $ifnotinsert = DB::insert(DB::raw("INSERT INTO orders (ProductName,CustomerId,CustomerName,quantity,Alish,Satish,Income,created_at,updated_at,user_id)
//SELECT * FROM (SELECT '$pro->Name' as name, '$pro->CustomerId' as cusid, '$pro->CustomerId' as cusname, 0 as quantity , '$pro->Alish' as alish , '$pro->Satish' as satish, '$pro->Income' as income, '$today' as created_at, '$today' as updated_at,0 as user_id) AS tmp
//WHERE NOT EXISTS (
// SELECT * FROM orders WHERE ProductName = '$pro->Name' and CustomerId = '$pro->CustomerId' and Format(Alish,2) = Format('$pro->Alish',2) AND
//Format(Satish,2)= Format('$pro->Satish',2)) LIMIT 1"));
//
// }
// }
$CustomerName = Customers::lists('name', 'id');
$CategoryName = Categories::lists('name', 'id');
return view('orders.newAlish', compact('CustomerName', $CustomerName), compact('CategoryName'));
}
public function index($category)
{
$categories = Categories::all();
$topics = new Topic();
$topics = $topics->getTopicChannel($category);
$title = $category;
return view('channel', compact('categories', 'topics', 'title'));
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id, Request $request)
{
$category = Categories::findOrFail($id);
$this->validate($request, ['name' => 'required|max:100']);
$category->update($request->all());
Flash::success('Category updated');
return redirect()->action('CategoriesController@index');
}
public static function children($id)
{
$child = Categories::whereParent($id)->get();
if (count($child)) {
return $child;
}
return false;
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$categories = Categories::all();
$jsonArray = [];
foreach ($categories as $category) {
$jsonArray[] = ["categoryId" => $category->category_id, "categoryName" => $category->name, "categoryDescription" => $category->description];
}
return response()->json($jsonArray);
}
public function index($id = 0)
{
$categories = Categories::all();
$categories = $categories->sortBy('sort_id');
$item = Items::find($id);
$comments = Comments::where('items_id', '=', $id)->get();
$data = ['categories' => $categories, 'item' => $item, 'id' => $item->categories_id, 'comments' => $comments];
return view('items.index', $data);
}
public function cachecate()
{
$data = \App\Categories::select(array('id', 'name'))->whereRaw("cid_parent=0 AND status='1'")->orderBy("id", "ASC")->get();
$j = array();
foreach ($data as $key => $value) {
$j[] = array($value['id'], IndexController::toAlias2($value['name']));
}
echo json_encode($j);
}
public function index($slug)
{
# обращаемся к моделе Category
$vrode_model = new Categories();
$categories = $vrode_model->cats_for_header();
// проверка на правильнось данных
/*
$post = DB::table('pages')
->where('slug', '=', "$slug")
->get();
*/
# обращаемся к моделе Page
$pages = new Page();
$footer_pages = $pages->footer_pages();
$post = $pages->page_text($slug);
return view('layouts.page_lay', ['categories' => $categories, 'pages' => $footer_pages, 'content_layout' => 'post_content', 'post' => $post]);
}
public function user_posts_all(Request $request)
{
//
$user = $request->user();
$posts = Posts::where('author_id', $user->id)->orderBy('created_at', 'desc')->paginate(5);
$title = $user->name;
$id = $request->user()->id;
$categories = Categories::where('author_id', $id);
return view('home')->withPosts($posts)->withTitle($title)->withTitlecategory('Categories')->withCategories($categories);
}
/**
* @param Request $request
* @param $id
* @return mixed
*/
public function edit(Request $request, $id)
{
$comment = Comments::where('id', $id)->first();
$user = $request->user();
$categories = Categories::all();
if ($user->is_admin() or $user->is_moderator() or $user->id == $comment->user_id) {
return view('comment.edit')->withComment($comment)->withCategories($categories);
} else {
redirect('/')->withErrors('You have not sufficient permissions');
}
}
public static function getCategories()
{
$resultArr = [];
$catsObj = Categories::all();
foreach ($catsObj as $cat) {
$tmpData = ['cat_id' => $cat->cat_id, 'cat_name' => $cat->cat_name];
array_push($resultArr, $tmpData);
}
//var_dump($resultArr);
return $resultArr;
}
public function index($id = 0)
{
# обращаемся к моделе Category
$vrode_model = new Categories();
$categories = $vrode_model->cats_for_header();
# обращаемся к моделе Page
$pages = new Page();
$footer_pages = $pages->footer_pages();
if ($id == 0 || empty($id)) {
//Нету номера выводим рандомную цытату
$ex_id = mt_rand(1, 366);
} else {
// выведем цытату с номером в заросе
if ($id > 366 || $id <= 0) {
return view('errors.404');
}
$ex_id = $id;
}
$excerptions_model = new Excerptions();
$ex = $excerptions_model->index($ex_id);
return view('layouts.default', ['categories' => $categories, 'pages' => $footer_pages, 'ex' => $ex, 'content_layout' => 'ex_content']);
}
public static function getColumn($column)
{
$array = Categories::all();
$result = array();
foreach ($array as $item) {
$result += array($item['id'] => $item[$column]);
}
if (count($result) > 0) {
return $result;
} else {
return array('-1' => 'Chưa có Category nào được tạo. Liên hệ Webmaster');
}
}
public function index($slug = 0)
{
# обращаемся к моделе Category
$category_model = new Categories();
$categories = $category_model->cats_for_header();
# обращаемся к моделе Page
$pages = new Page();
$footer_pages = $pages->footer_pages();
if (isset($slug) && !empty($slug)) {
//категория есть, выводим по ней посты
//тут нужно сначала проверить категорию и вытащить ее айди
$cat_id = $category_model->select_cat($slug);
$postsi = new Posts();
$posts = $postsi->post_of_category($slug);
return view('layouts.category_lay', ['categories' => $categories, 'pages' => $footer_pages, 'content_layout' => 'posts_content', 'posts' => $posts]);
} else {
//категория не указана, выводим список категорий
// зделаем запрос на категорию с картинкой и количеством постов внем
$posts = $category_model->cats_page();
return view('layouts.categories_lay', ['categories' => $categories, 'pages' => $footer_pages, 'content_layout' => 'posts_content', 'posts' => $posts]);
}
// return view('layouts.default',['categories' => $categories]);
}
/**
* @return mixed
*/
public function data()
{
$categories = Categories::select('id', 'name', 'description', 'slug')->orderBy('id', 'desc');
return Datatables::of($categories)->editColumn('name', '
<a href="#"><b>{{$name}}</b></a>
<div class="row-actions hide">
<a href="{{{ URL::to(\'admin/categories/edit/\' . $id . \'/\') }}}">Edit</a>
|
<a class="delete-tag" href="{{ URL::to(\'admin/categories/delete/\' . $id .\'/\') }}"
onclick=" return confirm(\'Are you want to delete\')">Delete</a>
|
<a href="#">View</a>
</div>
')->editColumn('id', '<input id="cb-select-all-1" type="checkbox" data="{{$id}}">')->make();
}
public function show($slug)
{
/**
* @var $category Categories
*/
$category = Categories::where('slug', $slug)->first();
if ($category == NULL) {
return redirect('/')->withErrors('Requested url does not exist');
}
$categories = Categories::all();
/**
* @var $products Products
*/
$products = $category->products()->paginate(9);
return view('home')->withProducts($products)->withCategories($categories)->withTitle('Products from the category ' . $category->title);
}
public function index($id = 0)
{
//get rundom category
if ($id == 0) {
$category = Categories::where('parent_id', '!=', 0)->orderBy(DB::raw('RAND()'))->take(1)->get();
$id = $category[0]->id;
}
//get all categories for menu
$categories = Categories::all();
$categories = $categories->sortBy('sort_id');
//get categories for slider
$sliders = Categories::where('parent_id', '!=', 0)->orderBy(DB::raw('RAND()'))->take(3)->get();
//get items
$items = Items::where('categories_id', '=', $id)->get();
$data = ['categories' => $categories, 'items' => $items, 'id' => $id, 'sliders' => $sliders];
return view('categories.index', $data);
}
public function sort(Request $request)
{
$criterion = $request->get('criterion');
$order = $request->get('order');
$posts = Posts::where('active', 1)->orderBy($criterion, $order)->paginate(5);
$titlepost = 'News';
$titlecategory = 'Categories';
$categories = Categories::all();
return view('home')->withPosts($posts)->withCategories($categories)->withTitlepost($titlepost)->withTitlecategory($titlecategory)->withCriterion($criterion)->withOrder($order);
// var_dump($posts[0]->title);
// die();
}
/**
* Создание категории (AJAX)
*/
public function addCategory(Request $request)
{
$this->validate($request, ['title' => 'required', 'url' => 'required']);
$category = new Categories();
$category->title = $request->title;
$category->slug = $request->url;
if ($request->hasFile('image')) {
$file = $request->file('image');
$filename = str_random(10);
$extension = $file->getClientOriginalExtension();
$surl = $this->globalSiteSettings['site_url'];
$imgurl = $surl . '/uploads/' . $filename . '.' . $extension;
Image::make($request->file('image'))->fit(135, 120)->save(public_path() . '/uploads/' . $filename . '.' . $extension);
$category->img = $imgurl;
}
if ($category->save()) {
Session::flash('success', 'Категория «' . $request->title . '» успешно создана.');
return redirect()->back();
}
return response()->json(['status' => 'error']);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
Categories::destroy($id);
return redirect('categories');
}
/**
* Show the application dashboard.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$categories = Categories::all();
$user = User::find(Auth::user()->id);
/*echo $user;
echo $user->uuid;*/
if (empty($user->displayname)) {
return redirect()->action('ProfileController@createName');
}
$followFeed = new Users_follow();
$topics = $followFeed->getFeed(Auth::user()->uuid);
// print_r($topics);
return view('home', compact('categories', 'topics'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
*
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$myasset = MyAsset::findOrFail($id);
$categories = Categories::distinct()->select('name')->where('creater_id', Auth::id())->orderBy('id', 'desc')->get();
return view('myasset.edit')->with('myasset', $myasset)->with('category', $categories);
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id, Requests\PostsFormRequest $request)
{
$post = Posts::findOrFail($id);
$input = $request->all();
$input['alias'] = HelperFunctions::str2url($request->title);
$post->update($input);
$categories_ids = [];
foreach ($input['categories_list'] as $value) {
$category = Categories::findOrNew($value);
if ($category->exists) {
array_push($categories_ids, $value);
} else {
$category->name = $value;
$category->save();
array_push($categories_ids, $category->id);
}
}
$post->categories()->sync($categories_ids);
$tags_ids = [];
foreach ($input['tags_list'] as $value) {
$tag = Tags::findOrNew($value);
if ($tag->exists) {
array_push($tags_ids, $value);
} else {
$tag->name = $value;
$tag->save();
array_push($tags_ids, $tag->id);
}
}
$post->tags()->sync($tags_ids);
\Session::flash('success', 'Post updated');
return redirect('/');
}
public function updateCategoryPost()
{
$categories = Categories::where('added_by', Session::get('id'))->get();
$data = Input::get('enabled');
foreach ($categories as $category) {
if (in_array($category->id, $data)) {
$category->is_enabled = "yes";
$category->save();
} else {
$category->is_enabled = "no";
$category->save();
}
}
Flash::success('Category preferences updated successfully.');
return redirect('/admin/categories/manage');
}