/**
* @param int $page
* @param int $limit
* @param bool $all
* @return mixed|\StdClass
*/
public function paginate($page = 1, $limit = 10, $all = false)
{
$result = new \StdClass();
$result->page = $page;
$result->limit = $limit;
$result->totalItems = 0;
$result->items = array();
$query = $this->category->orderBy('title');
$categories = $query->skip($limit * ($page - 1))->take($limit)->where('lang', $this->getLang())->get();
$result->totalItems = $this->totalCategories();
$result->items = $categories->all();
return $result;
}
private function getMasterDatas()
{
$data['categories'] = Category::orderBy('title')->get();
View::share('categories', $data['categories']);
$data['locations'] = Location::all();
View::share('locations', $data['locations']);
}
/**
* 博客文章展示页面
* @param string $slug 文章缩略名
* @return response
*/
public function getBlogShow($slug)
{
$article = Article::where('slug', $slug)->first();
is_null($article) and App::abort(404);
$categories = Category::orderBy('sort_order')->get();
return View::make('blog.show')->with(compact('article', 'categories'));
}
/**
* This function responses to
* the get request of /admin/category
* and shows all category as list
*/
public function getViewAllCategory($msg = null)
{
if (!empty($msg) && $msg == 1) {
return View::make('adminArea.category.view')->with('categories', Category::orderBy('id', 'desc')->get())->with('success', 'Category has been deleted successfully');
}
return View::make('adminArea.category.view')->with('categories', Category::orderBy('id', 'desc')->get());
}
public function add()
{
if (Request::isMethod('post')) {
$rules = array('title' => 'required|min:4', 'link' => "required|unique:categories", 'meta_keywords' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->fails()) {
return Redirect::to("admin/category/add")->withErrors($validator)->withInput(Input::except(''));
} else {
$table = new Category();
$table->title = Input::get('title');
$table->link = Input::get('link');
$table->content = Input::get('content');
$table->parent_id = Input::get('parent_id') ? Input::get('parent_id') : null;
$table->meta_title = Input::get('meta_title') ? Input::get('meta_title') : $table->title;
$table->meta_description = Input::get('meta_description') ? Input::get('meta_description') : $table->title;
$table->meta_keywords = Input::get('meta_keywords');
$table->active = Input::get('active', 0);
if ($table->save()) {
$name = trans("name.category");
return Redirect::to("admin/category")->with('success', trans("message.add", ['name' => $name]));
}
return Redirect::to("admin/category")->with('error', trans('message.error'));
}
}
$categories = array(0 => 'Нет родительской категории') + Category::orderBy('title')->lists('title', 'id');
return View::make("admin.shop.category.add", ['categories' => $categories, 'action' => $this->action]);
}
/**
* 获取分类列表
*
* @param string $taxonomy
* @param array $credential
* @param boolean $tree
*
* @return object
*/
public static function getAll(Closure $callback = null)
{
$terms = Category::orderBy('id', 'desc');
if ($callback) {
$callback($terms);
}
return $terms->get();
}
public function getCategory()
{
$category = Category::orderBy('order_type')->get();
if ($category) {
$response_array = array('success' => true, 'category' => $category);
} else {
$response_array = array('success' => false, 'error_msg' => "no data");
}
return Response::json($response_array);
}
public function run()
{
DB::table('packages')->truncate();
$faker = Faker\Factory::create();
for ($i = 0; $i < 1; $i++) {
$sentence = $faker->sentence(5);
$slug = Str::slug($sentence);
$user = User::orderBy(DB::raw('RAND()'))->first()->id;
$category = Category::orderBy(DB::raw('RAND()'))->first()->id;
$posts = array(['title_en' => $sentence, 'title_ar' => $sentence, 'description_en' => $sentence, 'description_ar' => $sentence, 'price' => '30', 'free' => 0, 'created_at' => $faker->DateTime(), 'updated_at' => $faker->DateTime()]);
DB::table('packages')->insert($posts);
}
}
public function run()
{
DB::table('posts')->truncate();
$dt = Carbon::now();
$faker = Faker\Factory::create();
for ($i = 0; $i < 1; $i++) {
$sentence = $faker->sentence(5);
$slug = Str::slug($sentence);
$user = User::orderBy(DB::raw('RAND()'))->first()->id;
$category = Category::orderBy(DB::raw('RAND()'))->first()->id;
$posts = array(['user_id' => $user, 'category_id' => $category, 'title_ar' => $sentence, 'title_en' => $sentence, 'description_ar' => $faker->sentence(200), 'description_en' => $faker->sentence(200), 'created_at' => $dt, 'updated_at' => $dt]);
DB::table('posts')->insert($posts);
}
}
public function modifView($post_id)
{
$post_id = strip_tags($post_id);
$post_id = intval($post_id);
$post_id = filter_var($post_id, FILTER_VALIDATE_INT);
$post = Post::with('category', 'user')->where('post_id', '=', $post_id)->get();
$action = str_replace(':post_id', $post_id, $this->app->urlFor('post_modif'));
$cancel = $this->app->urlFor('posts');
$categories = Category::orderBy('category')->get();
if (isset($_SESSION['vars'])) {
unset($_SESSION['vars']);
}
$this->view = new PostModif($post, $action, $cancel, $categories);
$this->view->display();
}
public function getTags()
{
if (Session::get('user_level') < Config::get('cms.viewComments')) {
return Redirect::to(_l(URL::action('AdminHomeController@getIndex')))->with('message', Lang::get('admin.notPermitted'))->with('notif', 'warning');
}
$this->setLayout();
if (Input::get('q')) {
$categories = Category::where('title', 'LIKE', '%' . Input::get('q') . '%')->where('tag', '=', 1)->orderBy('title')->paginate(20);
} else {
$categories = Category::orderBy('title')->where('tag', '=', 1)->paginate(20);
}
View::share('title', __(Lang::get('admin.tags')));
View::share('categories', $categories);
$this->layout->content = View::make('backend.categories.index');
}
/**
* Show search result
* @return response
*/
public function search()
{
$query = Article::orderBy('created_at', 'desc')->where('post_status', 'open');
$categories = Category::orderBy('sort_order')->get();
// Get search conditions
switch (Input::get('target')) {
case 'title':
$title = Input::get('like');
break;
}
// Construct query statement
isset($title) and $query->where('title', 'like', "%{$title}%")->orWhere('content', 'like', "%{$title}%");
$articles = $query->paginate(6);
return View::make('article.search')->with(compact('articles', 'categories'));
}
public static function getCategories()
{
$arrData = '';
if (Cache::has('categories')) {
$arrData = Cache::get('categories');
} else {
$categories = Category::orderBy('order_no')->get();
$arrData = [];
if (!$categories->isEmpty()) {
$arrData = $categories->toArray();
}
Cache::forever('categories', $arrData);
}
return $arrData;
}
public function get_index()
{
$admin = Auth::user();
$mp3s = MP3::orderBy('created_at', 'desc')->take(10)->get();
$mp3scount = MP3::count();
$mp4s = MP4::orderBy('created_at', 'desc')->take(10)->get();
$mp4scount = MP4::count();
$users = User::orderBy('created_at', 'desc')->take(10)->get();
$userscount = User::count();
$categories = Category::orderBy('name')->take(10)->get();
$catscount = Category::count();
$pages = Page::orderBy('created_at', 'desc')->paginate(10);
$pages_count = Page::count();
$title = 'Administrasyon';
return View::make('admin.index')->withAdmin($admin)->withMp3s($mp3s)->withMp4s($mp4s)->withUsers($users)->withCategories($categories)->withPages($pages)->withTitle($title)->withMp3sCount($mp3scount)->withMp4sCount($mp4scount)->withUsersCount($userscount)->withCatsCount($catscount)->withPagesCount($pages_count);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function getIndex()
{
View::share('title', __(Lang::get('admin.dashboard')));
$news = News::where('post_type', '=', 1)->orderBy('created_at', 'desc')->take(5)->get();
$comments = Comment::orderBy('created_at', 'desc')->take(5)->get();
$users = User::orderBy('created_at', 'desc')->take(5)->get();
$files = Files::orderBy('created_at', 'desc')->take(5)->get();
$categories = Category::orderBy('created_at', 'desc')->take(5)->get();
$pages = News::where('post_type', '=', 2)->orderBy('created_at', 'desc')->take(5)->get();
View::share('news', $news);
View::share('comments', $comments);
View::share('users', $users);
View::share('files', $files);
View::share('pages', $pages);
View::share('categories', $categories);
$this->setLayout();
$this->layout->content = View::make('backend.content.dashboard');
}
public function home()
{
try {
$settings = Setting::first();
if ($settings) {
$search = Input::get('search');
if (isset($search)) {
$media = Media::where('active', '=', 1)->where('title', 'LIKE', '%' . $search . '%')->orderBy('created_at', 'desc')->paginate(Config::get('site.num_results_per_page'));
} else {
$media = Media::with('media_likes', 'comments')->where('active', '=', 1)->orderBy('created_at', 'desc')->paginate(Config::get('site.num_results_per_page'));
}
$categories = Category::orderBy('order', 'ASC')->get();
$pages = Page::all();
$data = array('media' => $media, 'search' => $search, 'categories' => $categories, 'pages' => $pages, 'settings' => Setting::first());
return View::make('Theme::home', $data);
} else {
throw new Exception('settings not set, first install the script');
}
} catch (Exception $e) {
return Redirect::to('install.php');
}
}
public function index()
{
//get imageslider
$sliders = Slider::orderBy('created_at', 'desc')->take(5)->get();
//affiche le post vedette sur la home page avec la categorie prédéfinis
$headliner = Category::with(['posts' => function ($query) {
$query->orderBy('published_at', 'DESC')->take(1)->get();
}])->where('id', '=', '5')->get();
//show 4 categories with only one post by Category
$categories = Category::with(['posts' => function ($query) {
$query->orderBy('published_at', 'DESC')->take(5)->get();
}])->take(4)->get();
//Category publicite show image with publicity link
$pub = Category::orderBy('created_at', 'DESC')->where('id', '=', '6')->take(1)->get();
//affichage des commentaires par posts
$comments = Comment::orderBy('created_at', 'desc')->take(6)->get();
//Retrun 2 post by category check model Category twicePost
$postCat = Category::with(['posts' => function ($query) {
// Note that you don't have to call get() here!
$query->orderBy('published_at', 'desc')->latest();
}])->take(4)->get();
return View::make('home.index')->with(array('sliders' => $sliders, 'comments' => $comments, 'categories' => $categories, 'headliner' => $headliner, 'pub' => $pub, 'postCat' => $postCat));
}
$profile->save();
return $response->getBody()->write(json_encode($profile) . ' ');
} catch (Illuminate\Database\QueryException $e) {
return $response->write('{"msg":"Profil güncellenemedi !"}');
}
})->setName('user_profile_update');
// id'den yemekler
$this->get('/{id:[0-9]+}/foods/{page:[0-9]+}', function ($request, $response, $args) {
$foods = Food::where('user_id', $args['id'])->select('food_id', 'name', 'description')->take(6)->offset($args['page'] * 6)->orderBy('food_id', 'DESC')->get();
return $response->getBody()->write(json_encode($foods) . ' ');
})->setName('user_foods');
})->add($UserToken);
$app->group('/category', function () {
// tüm kategoriler
$this->get('/all', function ($request, $response, $args) {
$categories = Category::orderBy('name')->get();
return $response->getBody()->write(json_encode($categories) . ' ');
})->setName('categories');
// kategoriye ait yemekler
$this->get('/{id:[0-9]+}/{page:[0-9]+}', function ($request, $response, $args) {
$foods = Food::where('category_id', $args['id'])->select('food_id', 'name', 'description')->take(6)->offset($args['page'] * 6)->orderBy('food_id', 'DESC')->get();
return $response->getBody()->write(json_encode($foods) . ' ');
})->setName('user_foods');
})->add($UserToken);
$app->group('/food', function () {
// arama
$this->post('/search', function ($request, $response, $args) {
$searchData = json_decode($request->getBody());
$cleanStr = preg_replace('/[ ]*,[ ]*/i', ',', $searchData->search);
$materials = explode(",", $cleanStr);
$materials = array_filter($materials);
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$items = Category::orderBy('name', 'ASC')->paginate(10);
return View::make('category.view_category', compact('items'));
}
public static function getAllItemOrdered()
{
return Category::orderBy("view_count", "desc")->take(6)->get()->toArray();
}
@endif
<ul>
<li class="@if(Request::is('/') || Request::is('category/*')) active @endif"><a href="{{ URL::to('/') }}"><i class="fa fa-home"></i> {{ Lang::get('lang.home') }}</a></li>
<li class="dropdown @if(Request::is('popular/*') || Request::is('popular')) active @endif">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-star"></i> {{ Lang::get('lang.popular') }} <b class="caret"></b></a>
<ul class="dropdown-menu">
<li><a href="{{ URL::to('popular/week') }}">{{ Lang::get('lang.for_the_week') }}</a></li>
<li><a href="{{ URL::to('popular/month') }}">{{ Lang::get('lang.for_the_month') }}</a></li>
<li><a href="{{ URL::to('popular/year') }}">{{ Lang::get('lang.for_the_year') }}</a></li>
<li><a href="{{ URL::to('popular') }}">{{ Lang::get('lang.all_time') }}</a></li>
</ul>
</li>
<?php
$categories = Category::orderBy('order', 'ASC')->get();
?>
<li class="dropdown">
<a href="#" class="dropdown-toggle categories" data-toggle="dropdown"><i class="fa fa-folder-open"></i> {{ Lang::get('lang.categories') }} <b class="caret"></b></a>
<ul class="dropdown-menu">
<li>
@foreach ($categories as $category)
<a href="{{ URL::to('category') . '/' . strtolower($category->name) }}">{{ $category->name }}</a>
@endforeach
</li>
</ul>
</li>
@if($settings->pages_in_menu)
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$data = array('categories' => Category::orderBy('order', 'ASC')->get());
return View::make('media.create', $data);
}
/**
* Display a listing of categories
*
* @return Response
*/
public function index()
{
$categories = Category::orderBy('id', 'desc')->paginate('10');
return View::make('categories.index', compact('categories'));
}
public function shareLink($id, $data)
{
$segment = $data;
$cats = Category::orderBy('order_type')->get();
$post_details = Post::where('link', $segment)->where('is_approved', 1)->first();
$related = Post::orderByRaw("RAND()")->where('is_approved', 1)->take(2)->get();
if ($post_details) {
counter($segment);
return View::make('single-post')->withRelated($related)->withPost($post_details)->with('cats', $cats);
} else {
return Redirect::route('home');
}
}
public function categories()
{
$categories = Category::orderBy('order', 'ASC')->get();
$data = array('categories' => $categories);
return View::make('admin.sections.categories', $data);
}
public function edit($id)
{
$mp4 = MP4::whereId($id)->first();
$cats = Category::orderBy('name')->get();
if (Auth::check()) {
$user = Auth::user();
if ($user->id == $mp4->user_id || $user->is_admin()) {
$data = ['mp4' => $mp4, 'title' => "Modifye {$mp4->name}", 'cats' => $cats];
return View::make('mp4.put', $data);
} else {
return Redirect::to('/mp4')->withMessage('Ou pa gen dwa pou w modifye videyo a.');
}
}
return Redirect::to('/mp4')->with('message', 'Fòk ou konekte w pou w ka aksede ak paj ou vle a.');
}
public function getIndex()
{
$categories = Category::orderBy('order', 'desc')->orderBy('name')->paginate(20);
return \View::make('redminportal::categories/view')->with('categories', $categories);
}
</strong>
@endforeach
</ul>
@endif
</div>
</div>
<div class="col-sm-4">
<div class="list-group">
<a href="#" class="list-group-item active">
<h4>Category</h4>
</a>
<?php
$cats = Category::orderBy('name')->take(2)->get();
?>
@if ( $cats && count( $cats ) > 0 )
<ul class="list-unstyled">
@foreach( $cats as $cat )
<strong>
<a class="list-group-item" href="/cat/{{ $cat->slug }}">
{{ $cat->name }}
</a>
</strong>
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$data = array('categories' => Category::orderBy('order', 'ASC')->get(), 'settings' => Setting::first());
return View::make('Theme::upload', $data);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$categorys = Category::orderBy('name')->get();
return View::make("admin.category.list", array("categories" => $categorys));
}
