PHP Group::count方法代码示例

 public function testHasManyThrough()
 {
     $this->createUsersWithGroups(10, 5);
     $this->assertEqual(User::count(), 10);
     $this->assertEqual(Group::count(), 5);
     $this->assertEqual(UserAndGroupRelation::count(), 14);
     $user = User::findFirst(['conditions' => "login = 'login_1'"]);
     // Test has_many_through collection
     $queryCount = TipyDAO::$queryCount;
     $groups = $user->groups;
     // We got a 2 new querys
     $this->assertEqual(TipyDAO::$queryCount, $queryCount + 2);
     $this->assertNotEqual($groups, null);
     $this->assertEqual(sizeof($groups), 5);
     $this->assertEqual($groups[0]->name, 'name_1');
     // Test cached association
     $this->assertNotEqual($user->associationsCache["groups"], null);
     $this->assertEqual($groups, $user->associationsCache["groups"]);
     // Test no query
     $queryCount = TipyDAO::$queryCount;
     $groupsAgain = $user->groups;
     // no more queries
     $this->assertEqual(TipyDAO::$queryCount, $queryCount);
     $this->assertEqual($groups, $groupsAgain);
     // Test has many collection with conditions
     $groups = $user->groups(["order" => " name desc"]);
     $this->assertEqual(sizeof($groups), 5);
     $this->assertEqual($groups[0]->name, 'name_5');
     // Test queries association is not cached
     $this->assertNotEqual($groups, $user->associationsCache["groups"]);
 }

 public function render()
 {
     if (isset($this->config['course_id'])) {
         $course = new Course();
         $course->include_related('period');
         $course->get_by_id((int) $this->config['course_id']);
         $this->parser->assign('course', $course);
         if ($course->exists()) {
             $task_sets = new Task_set();
             $task_sets->where_related($course);
             $task_sets->where('published', 1);
             $task_sets->where('content_type', 'task_set');
             $task_sets_count = $task_sets->count();
             $this->parser->assign('task_sets_count', $task_sets_count);
             $task_sets->where_related($course);
             $task_sets->where('published', 1);
             $task_sets->where('content_type', 'project');
             $projects_count = $task_sets->count();
             $this->parser->assign('projects_count', $projects_count);
             $groups = new Group();
             $groups->where_related($course);
             $groups_count = $groups->count();
             $this->parser->assign('groups_count', $groups_count);
             $students = new Student();
             $students->where_related('participant/course', 'id', $course->id);
             $students->where_related('participant', 'allowed', 1);
             $students_count = $students->count();
             $this->parser->assign('students_count', $students_count);
             $task_set_permissions = new Task_set_permission();
             $task_set_permissions->select_func('COUNT', '*', 'count');
             $task_set_permissions->where('enabled', 1);
             $task_set_permissions->where_related('task_set', 'id', '${parent}.id');
             $now = date('Y-m-d H:i:s');
             $plus_two_weeks = date('Y-m-d H:i:s', strtotime($now . ' + 2 weeks'));
             $minus_one_week = date('Y-m-d H:i:s', strtotime($now . ' - 1 week'));
             $task_sets->select('id, name, upload_end_time AS min_upload_end_time, upload_end_time AS max_upload_end_time');
             $task_sets->where_related($course);
             $task_sets->where('published', 1);
             $task_sets->where_subquery('0', $task_set_permissions);
             $task_sets->where('upload_end_time >=', $minus_one_week);
             $task_sets->where('upload_end_time <=', $plus_two_weeks);
             $task_sets_2 = new Task_set();
             $task_sets_2->select('id, name');
             $task_sets_2->where_related($course);
             $task_sets_2->where('published', 1);
             $task_sets_2->select_min('task_set_permissions.upload_end_time', 'min_upload_end_time');
             $task_sets_2->select_max('task_set_permissions.upload_end_time', 'max_upload_end_time');
             $task_sets_2->where_related('task_set_permission', 'enabled', 1);
             $task_sets_2->having('(MAX(`task_set_permissions`.`upload_end_time`) >= ' . $this->db->escape($minus_one_week) . ' AND MAX(`task_set_permissions`.`upload_end_time`) <= ' . $this->db->escape($plus_two_weeks) . ')');
             $task_sets_2->or_having('(MIN(`task_set_permissions`.`upload_end_time`) >= ' . $this->db->escape($minus_one_week) . ' AND MIN(`task_set_permissions`.`upload_end_time`) <= ' . $this->db->escape($plus_two_weeks) . ')');
             $task_sets_2->group_by('id');
             $task_sets->union_iterated($task_sets_2, FALSE, 'min_upload_end_time DESC, max_upload_end_time DESC', isset($this->config['number_of_task_sets']) ? (int) $this->config['number_of_task_sets'] : 5);
             $this->parser->assign('task_sets', $task_sets);
         }
     }
     $this->parser->parse('widgets/admin/course_overview/main.tpl');
 }

 public function run()
 {
     if (Group::count('id')) {
         echo 'Skipping group seeder' . "\n";
         return;
     }
     $groups = [['title' => 'Ожидающий доступа', 'configs' => ['stars' => 0, 'title' => 'Ожидающий доступа', 'conf_show_signature' => false]], ['title' => 'Администратор', 'configs' => ['title' => 'Администратор']], ['title' => 'Newbie', 'configs' => ['stars' => 0, 'title' => 'Ньюбл', 'conf_show_signature' => false]], ['title' => 'Junior', 'configs' => ['stars' => 1, 'title' => 'Юниор']], ['title' => 'Member', 'configs' => ['stars' => 2, 'title' => 'Участник']], ['title' => 'Full Member', 'configs' => ['stars' => 3, 'title' => 'Уверенный пользователь']], ['title' => 'Senior Member', 'configs' => ['stars' => 4, 'title' => 'Сеньор']], ['title' => 'Profi', 'configs' => ['stars' => 5, 'title' => 'Профи']], ['title' => 'Master', 'configs' => ['stars' => 6, 'title' => 'Мастер']], ['title' => 'Guru', 'configs' => ['stars' => 7, 'title' => 'Гуру']], ['title' => 'Monster', 'configs' => ['stars' => 8, 'title' => 'Монстр']], ['title' => 'Wizard', 'configs' => ['stars' => 9, 'title' => 'Волшебник']], ['title' => 'God', 'configs' => ['stars' => 10, 'title' => 'Бог']], ['title' => 'Нарушившие правила', 'configs' => ['title' => 'Нарушитель', 'conf_show_signature' => false]], ['title' => 'Бан', 'configs' => ['title' => 'В бане', 'conf_show_signature' => false]], ['title' => 'Комодератор', 'configs' => ['title' => 'Помошник модератора']], ['title' => 'Модератор', 'configs' => ['title' => 'Модератор']], ['title' => 'Супермодератор', 'configs' => ['title' => 'Супермод']], ['title' => 'Ветеран', 'configs' => ['title' => 'Ветеран']], ['title' => 'Участники клуба Sources.RU', 'configs' => ['title' => 'Клубень']]];
     DB::transaction(function () use($groups) {
         foreach ($groups as $group) {
             Group::create($group);
         }
     });
 }

 /**
  * View groups
  *
  * @param Request $request
  * @return mixed
  */
 public function groups_list(Request $request)
 {
     $filter = [];
     if ($request->order) {
         $filter['order'] = $request->order;
     }
     /** @var Listing $paginator */
     $paginator = NCService::load('Paginator.Listing', [$request->page, \Group::count()]);
     $filter = array_merge($filter, $paginator->limit());
     // Filter groups
     $groups = \Group::all($filter);
     $groups = array_map(function ($i) {
         return $i->to_array();
     }, $groups);
     return $this->view->render('users/groups.twig', ['title' => $this->lang->translate('user.groups'), 'groups_list' => $groups, 'listing' => $paginator->pages(), 'page' => $paginator->cur_page]);
 }

 public function insertGroup()
 {
     $cre = ["group" => Input::get('group')];
     $rules = ["group" => 'required'];
     $validator = Validator::make($cre, $rules);
     if ($validator->passes()) {
         $group = new Group();
         $group->group_name = Input::get('group');
         $group->center_id = Input::get('center_id');
         $group->save();
         $group_info = Group::select('center.center_name', 'groups.group_name', 'city.city_name', 'groups.id')->join('center', 'groups.center_id', '=', 'center.id')->join('city', 'center.city_id', '=', 'city.id')->where('groups.id', '=', $group->id)->first();
         $count = Group::count();
         $data['success'] = 'true';
         $data['message'] = html_entity_decode(View::make('admin.manage.groups.view', ["data" => $group_info, "count" => $count]));
     } else {
         $data["success"] = false;
         $data["message"] = "All fields are not filled";
     }
     return json_encode($data);
 }

$group->name = 'Yo! Ugly Group';
$group->date = '19001231';
$group->insert();
echo '<p>The "' . $group->name . '" have ID = ' . $group->id . '.</p>';
echo "<p>Oops... it's not " . substr($group->date, 0, 4) . " but 1999. Let's <b>update</b> it.</p>";
$group->date = '19991231';
$group->update();
echo "<p>Now we have the correct year: " . substr($group->date, 0, 4) . ".</p>";
$group->reset();
echo "<h1>Let's find the groups starting with Y</h1>";
$group->addWhere("name LIKE 'Y%'");
$group->addOrder("id");
$total = $group->find();
echo "<p>We've found " . $total . " groups starting with Y.</p>";
// we can use the count method to get the same result
if ($group->count() > 1) {
    while ($group->fetch()) {
        YDDebugUtil::dump($group->getValues());
    }
}
echo "<h1>But I really want is the first group.</h1>";
$group->reset();
$group->find(1);
YDDebugUtil::dump($group->getValues());
echo "<h1>And I don't like the 'Yo! Ugly Group, so I'll delete it. I will reset the object and execute a delete.</h1>";
$group->reset();
$group->delete();
echo "<p>A PHP notice saying that I have no conditions... This is a protection defined by the configuration<br>";
echo "YD_DATABASEOBJECT_DELETE. A similar configuration is available for UPDATEs that don't have conditions<br>";
echo "YD_DATABASEOBJECT_UPDATE. The default is false for both.</p>";
echo "<p>Let's set the ID.</p>";

 public function countGroups($params = array())
 {
     if (!isset($params['status'])) {
         $params['status'] = 1;
     }
     if (!isset($params['is_delete'])) {
         $params['is_del'] = 0;
     }
     $model = new Group();
     $criteria = new CDbCriteria();
     $criteria->condition .= "1";
     $criteria->order = !empty($params['order']) ? $params['order'] : 't.ctime';
     if (!empty($limit)) {
         $criteria->limit = $limit;
     }
     if (!empty($params)) {
         $array = array('id', 'uid', 'cid0', 'cid1', 'type', 'status', 'is_del');
         foreach ($params as $key => $value) {
             if (in_array($key, $array)) {
                 $criteria->condition .= " and {$key}=:{$key}";
                 $criteria->params[':' . $key] = $value;
             }
         }
     }
     if (!empty($params['pageSize'])) {
         $pageSize = $params['pageSize'];
         $page = $params['page'];
         $_GET['page'] = $page;
         $total = $model->count($criteria);
         $pages = new CPagination($total);
         $pages->pageSize = $pageSize ? $pageSize : self::PAGE_SIZE;
         $pages->applyLimit($criteria);
     }
     $count = $model->count($criteria);
     return $count;
 }

 /**
  * Lists all models.
  */
 public function actionAdmin()
 {
     $model = new Group('search');
     $model->unsetAttributes();
     // clear any default values
     if (isset($_GET['Group'])) {
         $model->attributes = $_GET['Group'];
     }
     $this->render('admin', array('model' => $model, 'count' => $model->count()));
 }

 private function set_paginate_options()
 {
     $config = array();
     $config['base_url'] = site_url() . 'admin/groups';
     $config['use_page_numbers'] = TRUE;
     $config['per_page'] = 10;
     $config['total_rows'] = Group::count();
     $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;
 }