/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
// obtnemos las categorias
$categories = Category::orderBy('id', 'ASC')->paginate(5);
// le enviamos las categorias
return view('admin.categories.index')->with('categories', $categories);
}
public function index()
{
//get all the categories
$categories = Category::orderBy("category_id", "ASC")->paginate(20);
//load the view and pass the categories
return view('categories.index')->with('categories', $categories);
}
public function compose(View $view)
{
$tags = Tag::orderBy('id', 'DESC')->get();
$categories = Category::orderBy('id', 'DESC')->simplepaginate(7);
$images = Image::orderBy('id', 'DESC')->paginate(4);
$view->with('tags', $tags)->with('categories', $categories)->with('images', $images);
}
public function camposEdicion($id)
{
$product = null;
if ($id != null) {
$product = Product::findOrFail($id);
}
$categories = Category::orderBy('name', 'asc')->get();
$arrayCat = null;
$arrayCol = null;
$checked = null;
foreach ($categories as $cat) {
$arrayCat[$cat->id] = $cat->name;
}
$colors = Color::orderBy('name', 'asc')->get();
foreach ($colors as $col) {
$arrayCol[$col->id] = ['name' => $col->name, 'checked' => ""];
if (isset($product)) {
$checkColor = ProductColor::where('id_product', $product->id)->where('id_color', $col->id)->count();
if ($checkColor > 0) {
$arrayCol[$col->id]['checked'] = "checked";
}
}
}
return ['arrayCat' => $arrayCat, 'colors' => $arrayCol, 'product' => $product];
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$cities = City::all();
// Grab all the cities and then do a for each.
// run this for each of them.
foreach ($cities as $city) {
$events = Event::where('city_id', '=', $city->id)->where('time_end', '>=', date('Y-m-d H:i:s'))->where('time_end', '<=', date('Y-m-d H:i:s', strtotime('+2 weeks')))->orderBy('time_start', 'asc')->get();
if (!count($events)) {
$this->comment('No events found for ' . $city->name . '. Mailer not sent.');
continue;
}
$categories = Category::orderBy('title', 'asc')->get();
if ($this->option('email')) {
$subscriber = new Subscriber();
$subscriber->name = 'Test User';
$subscriber->email = $this->option('email');
$subscribers = [$subscriber];
$this->comment('Sent test email to ' . $this->option('email'));
} else {
$subscribers = Subscriber::where('city_id', '=', $city->id)->get();
}
$count = 0;
foreach ($subscribers as $subscriber) {
Mail::send('emails.subscribers.mailer', ['subscriber' => $subscriber, 'events' => $events, 'categories' => $categories, 'city' => $city], function ($m) use($subscriber, $city) {
$m->from('*****@*****.**', 'See+Do')->to($subscriber->email, $subscriber->name)->subject('Weekly Round-Up of Things to See+Do in ' . $city->name)->getHeaders()->addTextHeader('X-MC-Subaccount', 'see-do');
});
$count++;
}
$this->comment('Sent to ' . $count . ' email addresses in ' . $city->name . '.');
$count = 0;
}
}
public function compose(View $view)
{
$categories = Cache::remember('categories', 1440, function () {
return Category::orderBy('name')->get();
});
$view->with(['user' => $this->auth->user(), 'categories' => $categories, 'guest' => !$this->auth->check()]);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$article = Article::find($id);
$categories = Category::orderBy('name', 'DESC')->lists('name', 'id');
$tags = Tag::orderBy('name', 'DESC')->lists('name', 'id');
$my_tags = $article->tags->lists('id')->toArray();
return view('admin.articles.edit')->with('categories', $categories)->with('tags', $tags)->with('article', $article)->with('my_tags', $my_tags);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$service = Service::findOrFail($id);
$currencies = ['hrk' => 'HRK', 'usd' => 'USD', 'eur' => 'EUR'];
$clients = Client::orderBy('name')->pluck('name', 'id')->toArray();
$categories = Category::orderBy('name')->pluck('name', 'id')->toArray();
return view('services.edit')->with(compact('service', 'currencies', 'clients', 'categories'));
}
/**
* 获取分类列表
*
* @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();
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$pages = Category::orderBy('parent_id', 'ASC')->orderBy('category_order', 'ASC')->get()->toArray();
$Tree = new Tree();
$tree = $Tree->buildTree($pages);
list($keys, $values) = array_divide($tree);
return $values;
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$articles = Article::OrderBy('id', 'DESC')->paginate(7);
$categories = Category::orderBy('name', 'ASC')->get();
$tags = Tag::orderBy('name', 'ASC')->get();
$images = Image::orderBy('article_id', 'DESC')->get();
return view('admin.index')->with('articles', $articles)->with('tags', $tags)->with('images', $images)->with('categories', $categories);
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
$categories = [];
if (Schema::hasTable('categories')) {
$categories = App\Category::orderBy('name')->get();
}
view()->share(compact('categories'));
}
public function edit($id)
{
$post = Post::where('id', $id)->first();
$categories = Category::orderBy('name')->get();
if (empty($post)) {
return Redirect::route('administration.index');
}
return view('administration.blog.edit', ['post' => $post, 'categories' => $categories]);
}
public function edit($id)
{
$article = Article::find($id);
$article->category;
$categories = Category::orderBy('name', 'DESC')->lists('name', 'id');
$tags = Tag::orderBy('name', 'DESC')->lists('name', 'id');
$my_tags = $article->tags->lists('id')->ToArray();
return view('admin.articles.edit')->with(['categories' => $categories, 'article' => $article, 'tags' => $tags, 'my_tags' => $my_tags]);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$categories = Category::orderBy('order')->get()->toArray();
foreach ($categories as &$c) {
$c['action'] = array('create' => Config::get('app.url') . '/category/' . $c['id'] . '/posts/create', 'view' => Config::get('app.url') . '/category/' . $c['id'] . '/posts');
}
$index = new Collection();
$index['data'] = $categories;
return response()->json($index);
}
/**
* The order page
*/
public function order()
{
$Category = $this->Category->findOrFail(Input::get('id'));
if ($Category->parent_id == 0) {
$assign['categorys'] = $this->Category->orderBy('weight', 'asc')->whereRaw('parent_id = 0 and type_id = ' . $Category->type_id)->get();
} else {
$assign['categorys'] = $this->Category->orderBy('weight', 'asc')->where('parent_id', '=', $Category->parent_id)->get();
}
return view('dashboard.category.order', $assign);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$tag = Keyword::findOrFail($id);
$categories = Category::orderBy('name')->get();
$selector = array();
foreach ($categories as $category) {
$selector[$category->id] = $category->name;
}
return view('admin.updateKeyword', ['tag' => $tag, 'categories' => $selector]);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$widget = Widget::findOrFail($id);
if (!$this->adminOrCurrentUserOwns($widget)) {
throw new UnauthorizedException();
}
$categories = Category::orderBy('category_name', 'asc')->lists('category_name', 'id');
$subcategories = Subcategory::orderBy('subcategory_name', 'asc')->where('category_id', '=', $widget->category_id)->lists('subcategory_name', 'id');
return view('widget.edit', compact('widget', 'categories', 'subcategories'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$opp = array();
$categories = Category::orderBy('id', 'DESC')->get();
$title = "Catégories";
$options = Option::all();
foreach ($options as $o) {
$opp[$o->category_id][$o->id] = $o;
}
return view('Categories/categories', ['title' => $title, 'categories' => $categories, 'opp' => $opp]);
}
/**
* Display the specified resource.
*
* @param Category $category
*
* @return \Illuminate\Http\Response
*/
public function show(City $city, Category $category)
{
// overwrite the given category with one that has the same slug and the right cityID,
// this wouldn't be a problem if we used unique slugs but its better to be consistent with
// the category urls
$category = Category::where([['city_id', '=', $city->id], ['slug', '=', $category->slug]])->first();
$event = null;
$events = $category->futureEvents($city)->get();
$categories = Category::orderBy('title', 'asc')->get();
return view('events.index', compact('city', 'events', 'event', 'category', 'categories'));
}
public function index(Request $request)
{
$search = \Request::get('search');
//<-- we use global request to get the param of URI
if ($search) {
$allCategory = Category::whereRaw('category_name = ?', [$search])->orderBy('id', 'asc')->paginate(5);
} else {
$allCategory = Category::orderBy('id', 'asc')->paginate(5);
}
return view('Category.index', ['Categories' => $allCategory]);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
$keyword = $request->input('keyword') ? $request->input('keyword') : '';
$categories = [];
if ($request->input('keyword')) {
$categories = Category::where('name', 'LIKE', '%' . spaceToLike($request->input('keyword')) . '%')->orderBy('order')->get();
} else {
$categories = Category::orderBy('order')->get();
}
return view('admin.category.content', ['categories' => $categories, 'keyword' => $keyword]);
}
/**
* Display a dynamically generated mailer based on data available now.
*
* @return \Illuminate\Http\Response
*/
public function now()
{
$events = Event::futureEvents()->get();
$categories = Category::orderBy('title', 'asc')->get();
$subscriber = new Subscriber();
$subscriber->name = 'Andy Gott';
$subscriber->email = '*****@*****.**';
Mail::send('emails.subscribers.mailer', ['subscriber' => $subscriber, 'events' => $events, 'categories' => $categories], function ($m) use($subscriber) {
$m->from('*****@*****.**', 'See+Do')->to($subscriber->email, $subscriber->name)->subject('Weekly Round-Up of Things to See+Do in Manchester')->getHeaders()->addTextHeader('X-MC-Subaccount', 'see-do');
});
return view('mailers.now', compact('events'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$categories = Category::orderBy('name')->get();
foreach ($categories as $category) {
// $dropbox = Dropbox::createTemporaryDirectLink($category->featured_image);
// $category->featured_image = $dropbox[0];
if ($category->featured_image != '') {
$dropbox = Dropbox::getThumbnail($category->featured_image, "jpeg", "m");
$category->featured_image = 'data:image/jpeg;base64,' . base64_encode($dropbox[1]);
} else {
$category->featured_image = "http://placehold.it/128x128/ecf0f5/444444?text=?";
}
}
return view('auth.categories.index')->withCategories($categories);
}
/**
* Show the report for all things.
*
* @return [type]
*/
public function report()
{
$services = Service::orderBy('month')->orderBy('day')->where('active', 1)->with(['client', 'category'])->get();
$clients = Client::orderBy('name')->whereHas('services', function ($query) {
$query->where('active', 1);
})->with(['services' => function ($query) {
$query->where('active', 1);
}])->get();
$categories = Category::orderBy('name')->whereHas('services', function ($query) {
$query->where('active', 1);
})->with(['services' => function ($query) {
$query->where('active', 1);
}])->get();
return view('report')->with(compact('services', 'clients', 'categories'));
}
public function showList(Request $request)
{
$type = $request->get('show');
$categories = Category::orderBy('name');
switch ($type) {
case 'store':
$categories->store();
break;
case 'group':
$categories->group();
break;
}
$categories = $categories->get()->buildTree();
$panel = ['left' => ['width' => '2'], 'center' => ['width' => '10']];
return view('categories.home', compact('categories', 'panel'));
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$this->validate($request, ['event_name' => 'required', 'event_description' => 'required', 'event_datetime' => 'required']);
$event = new Event();
$event->is_published = $request->get('is_published') == 'on' ? 1 : 0;
$event->name = $request->event_name;
$event->description = $request->event_description;
$event->datetime = Carbon::parse($request->event_datetime);
$event->save();
if ($request->get('event_categories') != null) {
foreach ($request->get('event_categories') as $category_id) {
$event->categories()->attach($category_id);
}
}
$category = new Category();
$categories = $category->orderBy('name')->get();
return view('dashboard/create_event')->with('categories', $categories)->with('event', new Event());
}
public function init(Request $request)
{
\Illuminate\Support\Facades\Session::flush();
$session = new Session();
$session->CreateTime = time();
$session->save();
$departments = Department::where('Type', 'execution')->orderBy('ID', 'ASC')->get();
$retDepartments = [];
for ($i = 0, $l = count($departments); $i < $l; $i++) {
$retDepartments[] = $departments[$i]->toObject();
}
$categories = Category::orderBy('ID', 'ASC')->get();
$retCategories = [];
for ($i = 0, $l = count($categories); $i < $l; $i++) {
$retCategories[] = $categories[$i]->toObject();
}
return view('index', ['sessionId' => $session->id, 'categories' => $retCategories, 'departments' => $retDepartments]);
}
public function overview()
{
$newArray = [];
$Categories = Category::orderBy('category_order', 'asc')->get();
if (!empty($Categories)) {
foreach ($Categories as $key => $Category) {
$newArray[$key] = $Category;
$newArray[$key]['unread_count'] = $Category['unread_count'] = DB::table('feeds')->join('articles', 'feeds.id', '=', 'articles.feed_id')->where('feeds.category_id', $Category['id'])->where('articles.status', 'unread')->count();
$newArray[$key]['feeds'] = Category::find($Category['id'])->feeds;
if (!empty($newArray[$key]['feeds'])) {
foreach ($newArray[$key]['feeds'] as $feedkey => $feed) {
$newArray[$key]['feeds'][$feedkey]['unread_count'] = DB::table('articles')->where('feed_id', $feed['id'])->where('status', 'unread')->count();
}
}
}
}
return response()->json($newArray);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$categories = Category::orderBy('name', 'ASC')->paginate(8);
return view('admin.categories.index', compact('categories'));
}
