/**
* testGetModelCount
*
* Test for ERestBaseAction->getModelCount()
*/
public function testGetModelCount()
{
$category = new Category();
$count = $category->count();
$this->assertEquals($count, $this->baseAction->getModelCount(null));
$this->assertEquals(1, $this->baseAction->getModelCount(1));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$counts = array();
$counts['article_total'] = \Article::count();
$counts['category_total'] = \Category::count();
$counts['user_total'] = \User::count();
$counts['page_total'] = \Page::count();
return View::make('admin.index.index')->with('counts', $counts);
}
public function listCategory()
{
if (!Request::ajax()) {
return App::abort(404);
}
$start = Input::has('start') ? (int) Input::get('start') : 0;
$length = Input::has('length') ? Input::get('length') : 10;
$search = Input::has('search') ? Input::get('search') : [];
$categories = Category::select('categories.id', 'categories.name', 'categories.description', 'categories.order_no', 'parent.name as parent_name', 'categories.active');
if (!empty($search)) {
foreach ($search as $key => $value) {
if (empty($value)) {
continue;
}
if ($key == 'active') {
if ($value == 'yes') {
$value = 1;
} else {
$value = 0;
}
$categories->where('categories.' . $key, $value);
} else {
if ($key == 'parent_id') {
$categories->where('categories.' . $key, '=', (int) $value);
} else {
$value = ltrim(rtrim($value));
$categories->where('categories.' . $key, 'like', '%' . $value . '%');
}
}
}
}
$order = Input::has('order') ? Input::get('order') : [];
if (!empty($order)) {
$columns = Input::has('columns') ? Input::get('columns') : [];
foreach ($order as $value) {
$column = $value['column'];
if (!isset($columns[$column]['name']) || empty($columns[$column]['name'])) {
continue;
}
$categories->orderBy($columns[$column]['name'], $value['dir'] == 'asc' ? 'asc' : 'desc');
}
}
$count = $categories->count();
if ($length > 0) {
$categories = $categories->skip($start)->take($length);
}
$arrcategories = $categories->leftJoin('categories as parent', 'categories.parent_id', '=', 'parent.id')->get()->toArray();
$arrReturn = ['draw' => Input::has('draw') ? Input::get('draw') : 1, 'recordsTotal' => Category::count(), 'recordsFiltered' => $count, 'data' => []];
if (!empty($arrcategories)) {
foreach ($arrcategories as $category) {
$category['parent_name'] = is_null($category['parent_name']) ? 'No Parent' : $category['parent_name'];
$arrReturn['data'][] = [++$start, $category['id'], $category['name'], $category['description'], $category['order_no'], $category['parent_name'], $category['active']];
}
}
return $arrReturn;
}
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);
}
public function run()
{
if (Category::count('id')) {
echo 'Skipping category seeder' . "\n";
return;
}
$categories = DB::connection('old')->table('categories')->get();
DB::transaction(function () use($categories) {
foreach ($categories as $c) {
$cat = new Category();
$cat->position = $c->position;
$cat->state = $c->state;
$cat->title = $c->name;
$cat->about = $c->description;
$cat->icon = $c->image;
$cat->save();
}
});
}
function test_post_count_delete()
{
$this->_assert_equals($this->m_all_count, Category::count());
}
Notify::error($errors);
return Response::redirect('admin/categories/add');
}
if (empty($input['slug'])) {
$input['slug'] = $input['title'];
}
$input['slug'] = slug($input['slug']);
$category = Category::create($input);
Extend::process('category', $category->id);
Notify::success(__('categories.created'));
return Response::redirect('admin/categories');
});
/*
Delete Category
*/
Route::get('admin/categories/delete/(:num)', function ($id) {
$total = Category::count();
if ($total == 1) {
Notify::error(__('categories.delete_error'));
return Response::redirect('admin/categories/edit/' . $id);
}
// move posts
$category = Category::where('id', '<>', $id)->fetch();
// delete selected
Category::find($id)->delete();
// update posts
Post::where('category', '=', $id)->update(array('category' => $category->id));
Notify::success(__('categories.deleted'));
return Response::redirect('admin/categories');
});
});
<?php
$s = new Slug();
$slug_count = $s->like('id', 'category.', 'after')->count();
$c = new Category();
$content_count = $c->count();
if ($slug_count < $content_count) {
$slugs = array();
$c = new Category();
foreach ($c->select('slug')->get_iterated() as $content) {
$slugs[] = "('category." . $content->slug . "')";
}
$slugs = join(', ', $slugs);
$this->db->query("INSERT INTO {$s->table}(id) VALUES {$slugs} ON DUPLICATE KEY UPDATE id=id;");
}
$done = true;
public function blog_category_count($args)
{
if ($sql = $this->include_exclude_blogs($args)) {
$blog_filter = 'and category_blog_id ' . $sql;
} elseif (isset($args['blog_id'])) {
$blog_id = intval($args['blog_id']);
$blog_filter = 'and category_blog_id = ' . $blog_id;
}
$where = "category_class = 'category'\n {$blog_filter}";
require_once 'class.mt_category.php';
$cat = new Category();
$result = $cat->count(array('where' => $where));
return $result;
}
public function validate()
{
if ($this->category_id) {
if ($this->id) {
$rows = Category::count(array('conditions' => array('category_id = ? AND name = ? AND id <> ?', $this->category_id, $this->name, $this->id)));
} else {
$rows = Category::count(array('conditions' => array('category_id = ? AND name = ?', $this->category_id, $this->name)));
}
} else {
if ($this->id) {
$rows = Category::count(array('conditions' => array('category_id is null AND name = ? AND id <> ?', $this->name, $this->id)));
} else {
$rows = Category::count(array('conditions' => array('category_id is null AND name = ?', $this->name)));
}
}
if ($rows) {
$this->errors->add('name', "El nombre no es único en esta categoría");
} else {
return TRUE;
}
}
$parent = isset($_GET['parent']) ? (int) $_GET['parent'] : 0;
if (isset($_GET['d'])) {
$d = (int) $_GET['d'];
if ($d > 0) {
Category::delete($d);
}
}
if (isset($_GET['o'])) {
$o = (int) $_GET['o'];
$r = (int) $_GET['r'];
if ($r != 0) {
$r = 1;
}
Category::set_order($o, $parent, $r);
}
$tct = Category::count(array('parent' => $parent));
//total count
$rpp = 10;
//row per page
$pager_options = array('mode' => 'Sliding', 'perPage' => $rpp, 'delta' => 2, 'totalItems' => $tct, 'urlVar' => "pageID{$parent}", 'excludeVars' => array('o', 'r', 'd', 't', 'e'));
$pager = @Pager::factory($pager_options);
list($from, $to) = $pager->getOffsetByPageId();
$categories = Category::get_all(array('r.parent' => $parent), '', $from - 1 . ", {$rpp}");
include "page-header.php";
?>
<div id="wrapper">
<?php
include "page-left.php";
?>
private function set_paginate_options($category_id = NULL)
{
$config = array();
if ($category_id) {
$config["base_url"] = site_url() . "categories/{$category_id}";
$config["total_rows"] = Category::count(array('conditions' => 'category_id = ' . $category_id . ''));
} else {
$config["base_url"] = site_url() . "categories";
$config["total_rows"] = Category::count(array('conditions' => 'category_id is null'));
}
$config["use_page_numbers"] = TRUE;
$config["per_page"] = 10;
$config["uri_segment"] = 3;
$config["first_link"] = "<< " . lang('web_first');
$config['first_tag_open'] = "<span class='pag'>";
$config['first_tag_close'] = '</span>';
$config['last_link'] = lang('web_last') . " >>";
$config['last_tag_open'] = "<span class='pag'>";
$config['last_tag_close'] = "</span>";
$config['next_link'] = FALSE;
$config['next_tag_open'] = "<span class='pag'>";
$config['next_tag_close'] = '</span>';
$config['prev_link'] = FALSE;
$config['prev_tag_open'] = "<span class='pag'>";
$config['prev_tag_close'] = '</span>';
$config['cur_tag_open'] = "<span class='pag pag_active'>";
$config['cur_tag_close'] = '</span>';
$config['num_tag_open'] = "<span class='pag'>";
$config['num_tag_close'] = '</span>';
$config['full_tag_open'] = "<div class='navigation'>";
$config['full_tag_close'] = '</div>';
$choice = $config["total_rows"] / $config["per_page"];
//$config["num_links"] = round($choice);
return $config;
}
