PHP Model_User::count_all方法代码示例

 /**
  * Handle GET requests.
  */
 public function action_index()
 {
     try {
         if (is_numeric($this->request->param('id'))) {
             $this->action_get();
         } else {
             $output = array();
             $users = new Model_User();
             $users->where('status', '=', Model_User::STATUS_ACTIVE);
             //filter results by param, verify field exists and has a value and sort the results
             $users->api_filter($this->_filter_params)->api_sort($this->_sort);
             //how many? used in header X-Total-Count
             $count = $users->count_all();
             //pagination with headers
             $pagination = $users->api_pagination($count, $this->_params['items_per_page']);
             $users = $users->cached()->find_all();
             //as array
             foreach ($users as $user) {
                 $output[] = self::get_user_array($user);
             }
             $this->rest_output(array('users' => $output), 200, $count, $pagination !== FALSE ? $pagination : NULL);
         }
     } catch (Kohana_HTTP_Exception $khe) {
         $this->_error($khe);
     }
 }

 public function action_index()
 {
     Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Newsletter')));
     $this->template->title = __('Newsletter');
     //count all users
     $user = new Model_User();
     $user->where('status', '=', Model_User::STATUS_ACTIVE);
     $count_all_users = $user->count_all();
     //count support expired
     $query = DB::select(DB::expr('COUNT(id_order) count'))->from('orders')->where('status', '=', Model_Order::STATUS_PAID)->where('support_date', '<', Date::unix2mysql())->execute();
     $count_support_expired = $query->as_array();
     $count_support_expired = $count_support_expired[0]['count'];
     //count license expired
     $query = DB::select(DB::expr('COUNT(id_license) count'))->from('licenses')->where('valid_date', 'IS NOT', NULL)->where('valid_date', '<', Date::unix2mysql())->execute();
     $count_license_expired = $query->as_array();
     $count_license_expired = $count_license_expired[0]['count'];
     //orders per product, not accuarate since 1 user could buy more than 1 product but will do
     $query = DB::select(DB::expr('COUNT(id_order) count'))->select('p.title')->select('p.id_product')->from(array('products', 'p'))->join(array('orders', 'o'))->using('id_product')->where('o.status', '=', Model_Order::STATUS_PAID)->group_by('p.id_product')->execute();
     $products = $query->as_array();
     //post done sending newsletter
     if ($this->request->post() and Core::post('subject') != NULL) {
         $users = array();
         if (core::post('send_all') == 'on') {
             $query = DB::select('email')->select('name')->from('users')->where('status', '=', Model_User::STATUS_ACTIVE)->execute();
             $users = array_merge($users, $query->as_array());
         }
         if (Theme::get('premium') == 1) {
             if (core::post('send_expired_support') == 'on') {
                 $query = DB::select('email')->select('name')->from(array('users', 'u'))->join(array('orders', 'o'))->using('id_user')->where('o.status', '=', Model_Order::STATUS_PAID)->where('o.support_date', '<', Date::unix2mysql())->where('u.subscriber', '=', 1)->group_by('u.id_user')->execute();
                 $users = array_merge($users, $query->as_array());
             }
             if (core::post('send_expired_license') == 'on') {
                 $query = DB::select('email')->select('name')->from(array('licenses', 'l'))->join(array('users', 'u'))->using('id_user')->where('l.valid_date', 'IS NOT', NULL)->where('l.valid_date', '<', Date::unix2mysql())->where('u.subscriber', '=', 1)->group_by('u.id_user')->execute();
                 $users = array_merge($users, $query->as_array());
             }
             if (is_numeric(core::post('send_product'))) {
                 $query = DB::select('email')->select('name')->from(array('users', 'u'))->join(array('orders', 'o'))->using('id_user')->where('o.id_product', '=', core::post('send_product'))->where('o.status', '=', Model_Order::STATUS_PAID)->where('u.subscriber', '=', 1)->group_by('u.id_user')->execute();
                 $users = array_merge($users, $query->as_array());
             }
         }
         //NOTE $users may have duplicated emails, but phpmailer takes care of not sending the email 2 times to same recipient
         //sending!
         if (count($users) > 0) {
             if (!Email::send($users, '', Core::post('subject'), Kohana::$_POST_ORIG['description'], Core::post('from'), Core::post('from_email'))) {
                 Alert::set(Alert::ERROR, __('Error on mail delivery, not sent'));
             } else {
                 Alert::set(Alert::SUCCESS, __('Email sent'));
             }
         } else {
             Alert::set(Alert::ERROR, __('Mail not sent'));
         }
     }
     $this->template->content = View::factory('oc-panel/pages/newsletter', array('count_all_users' => $count_all_users, 'count_support_expired' => $count_support_expired, 'count_license_expired' => $count_license_expired, 'products' => $products));
 }

 /**
  *
  * Loads a basic list info
  * @param string $view template to render 
  */
 public function action_index($view = NULL)
 {
     $this->template->title = __($this->_orm_model);
     $this->template->scripts['footer'][] = 'js/oc-panel/crud/index.js';
     $users = new Model_User();
     // filter users by search value
     if ($q = $this->request->query('search')) {
         $users->where('email', 'like', '%' . $q . '%')->or_where('name', 'like', '%' . $q . '%');
     }
     $pagination = Pagination::factory(array('view' => 'oc-panel/crud/pagination', 'total_items' => $users->count_all()))->route_params(array('controller' => $this->request->controller(), 'action' => $this->request->action()));
     $pagination->title($this->template->title);
     $users = $users->limit($pagination->items_per_page)->offset($pagination->offset)->find_all();
     $pagination = $pagination->render();
     $this->render('oc-panel/crud/index', array('elements' => $users, 'pagination' => $pagination));
 }

 public function action_info()
 {
     //try to get the info from the cache
     $info = Core::cache('action_info', NULL);
     //not cached :(
     if ($info === NULL) {
         $ads = new Model_Ad();
         $total_ads = $ads->count_all();
         $last_ad = $ads->select('published')->order_by('published', 'desc')->limit(1)->find();
         $last_ad = $last_ad->published;
         $ads = new Model_Ad();
         $first_ad = $ads->select('published')->order_by('published', 'asc')->limit(1)->find();
         $first_ad = $first_ad->published;
         $views = new Model_Visit();
         $total_views = $views->count_all();
         $users = new Model_User();
         $total_users = $users->count_all();
         $info = array('site_url' => Core::config('general.base_url'), 'site_name' => Core::config('general.site_name'), 'site_description' => Core::config('general.site_description'), 'created' => $first_ad, 'updated' => $last_ad, 'email' => Core::config('email.notify_email'), 'version' => Core::VERSION, 'theme' => Core::config('appearance.theme'), 'theme_mobile' => Core::config('appearance.theme_mobile'), 'charset' => Kohana::$charset, 'timezone' => Core::config('i18n.timezone'), 'locale' => Core::config('i18n.locale'), 'currency' => '', 'ads' => $total_ads, 'views' => $total_views, 'users' => $total_users);
         Core::cache('action_info', $info);
     }
     $this->response->headers('Content-type', 'application/javascript');
     $this->response->body(json_encode($info));
 }

 public function action_index()
 {
     Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Newsletter')));
     $this->template->title = __('Newsletter');
     //count all users
     $user = new Model_User();
     $user->where('status', '=', Model_User::STATUS_ACTIVE)->where('subscriber', '=', 1);
     $count_all_users = $user->count_all();
     //count featured expired
     $query = DB::select(DB::expr('COUNT(id_user) count'))->from('ads')->where('status', '=', Model_Ad::STATUS_PUBLISHED)->where('featured', '<', Date::unix2mysql())->group_by('id_user')->execute();
     $count_featured_expired = $query->as_array();
     $count_featured_expired = isset($count_featured_expired[0]['count']) ? $count_featured_expired[0]['count'] : 0;
     //count all featured
     $query = DB::select(DB::expr('COUNT(id_user) count'))->from('ads')->where('status', '=', Model_Ad::STATUS_PUBLISHED)->where('featured', 'IS NOT', NULL)->group_by('id_user')->execute();
     $count_featured = $query->as_array();
     $count_featured = isset($count_featured[0]['count']) ? $count_featured[0]['count'] : 0;
     //users without published ads
     $query = DB::select(DB::expr('COUNT(id_user) count'))->from(array('users', 'u'))->join(array('ads', 'a'), 'LEFT')->using('id_user')->where('u.status', '=', Model_User::STATUS_ACTIVE)->where('u.subscriber', '=', 1)->where('a.title', 'is', NULL)->group_by('u.id_user')->execute();
     $count_unpub = $query->as_array();
     $count_unpub = isset($count_unpub[0]['count']) ? $count_unpub[0]['count'] : 0;
     //count all users not login 3 months
     $query = DB::select(DB::expr('COUNT(id_user) count'))->from('users')->where('status', '=', Model_User::STATUS_ACTIVE)->where('last_login', '<=', Date::unix2mysql(strtotime('-3 month')))->or_where('last_login', 'IS', NULL)->where('subscriber', '=', 1)->execute();
     $count_logged = $query->as_array();
     $count_logged = isset($count_logged[0]['count']) ? $count_logged[0]['count'] : 0;
     //count all users spammers
     $query = DB::select(DB::expr('COUNT(id_user) count'))->from('users')->where('status', '=', Model_User::STATUS_SPAM)->where('subscriber', '=', 1)->execute();
     $count_spam = $query->as_array();
     $count_spam = isset($count_spam[0]['count']) ? $count_spam[0]['count'] : 0;
     //post done sending newsletter
     if ($this->request->post() and Core::post('subject') != NULL) {
         $users = array();
         if (core::post('send_all') == 'on') {
             $query = DB::select('email')->select('name')->from('users')->where('status', '=', Model_User::STATUS_ACTIVE)->where('subscriber', '=', 1)->execute();
             $users = array_merge($users, $query->as_array());
         }
         if (Theme::get('premium') == 1) {
             if (core::post('send_featured_expired') == 'on') {
                 $query = DB::select('email')->select('name')->from(array('users', 'u'))->join(array('ads', 'a'))->using('id_user')->where('a.status', '=', Model_Ad::STATUS_PUBLISHED)->where('a.featured', '<', Date::unix2mysql())->where('u.subscriber', '=', 1)->group_by('id_user')->execute();
                 $users = array_merge($users, $query->as_array());
             }
             if (core::post('send_featured') == 'on') {
                 $query = DB::select('email')->select('name')->from(array('users', 'u'))->join(array('ads', 'a'))->using('id_user')->where('a.status', '=', Model_Ad::STATUS_PUBLISHED)->where('a.featured', 'IS NOT', NULL)->where('u.subscriber', '=', 1)->group_by('id_user')->execute();
                 $users = array_merge($users, $query->as_array());
             }
             if (core::post('send_unpub') == 'on') {
                 //users without published ads
                 $query = DB::select('email')->select('name')->from(array('users', 'u'))->join(array('ads', 'a'), 'LEFT')->using('id_user')->where('u.status', '=', Model_User::STATUS_ACTIVE)->where('u.subscriber', '=', 1)->where('a.title', 'is', NULL)->execute();
                 $users = array_merge($users, $query->as_array());
             }
             if (core::post('send_logged') == 'on') {
                 $query = DB::select('email')->select('name')->from('users')->where('status', '=', Model_User::STATUS_ACTIVE)->where('last_login', '<=', Date::unix2mysql(strtotime('-3 month')))->or_where('last_login', 'IS', NULL)->where('subscriber', '=', 1)->execute();
                 $users = array_merge($users, $query->as_array());
             }
             if (core::post('send_spam') == 'on') {
                 $query = DB::select('email')->select('name')->from('users')->where('status', '=', Model_User::STATUS_SPAM)->where('subscriber', '=', 1)->execute();
                 $users = array_merge($users, $query->as_array());
             }
         }
         //NOTE $users may have duplicated emails, but phpmailer takes care of not sending the email 2 times to same recipient
         //sending!
         if (count($users) > 0) {
             if (!Email::send($users, '', Core::post('subject'), Kohana::$_POST_ORIG['description'], Core::post('from'), Core::post('from_email'))) {
                 Alert::set(Alert::ERROR, __('Error on mail delivery, not sent'));
             } else {
                 Alert::set(Alert::SUCCESS, __('Email sent'));
             }
         } else {
             Alert::set(Alert::ERROR, __('Mail not sent'));
         }
     }
     $this->template->content = View::factory('oc-panel/pages/newsletter', array('count_all_users' => $count_all_users, 'count_featured_expired' => $count_featured_expired, 'count_featured' => $count_featured, 'count_unpub' => $count_unpub, 'count_logged' => $count_logged, 'count_spam' => $count_spam));
 }

 public function action_index()
 {
     $db_prefix = Database::instance('default')->table_prefix();
     //include num of ads so we can filter, sort and display next to each user
     $query_count = '(SELECT count(id_ad) FROM ' . $db_prefix . 'ads 
                     WHERE id_user=' . $db_prefix . 'user.id_user AND 
                             status=' . Model_Ad::STATUS_PUBLISHED . ')';
     $users = new Model_User();
     $users->select(array(DB::expr($query_count), 'ads_count'))->where('status', '=', Model_User::STATUS_ACTIVE);
     //search filter
     if (core::request('search') !== NULL and strlen(core::request('search')) >= 3) {
         $search = core::request('search');
         $users->where_open()->where('name', 'like', '%' . $search . '%')->or_where('description', 'like', '%' . $search . '%')->where_close();
     }
     //cf filter
     foreach (array_merge($_POST, $_GET) as $name => $value) {
         //value set and is a CF
         if (isset($value) and $value != NULL and strpos($name, 'cf_') !== FALSE and array_key_exists(str_replace('cf_', '', $name), Model_UserField::get_all())) {
             //checkbox when selected return string 'on' as a value
             $value = $value == 'on' ? 1 : $value;
             if (is_numeric($value)) {
                 $users->where($name, '=', $value);
             } elseif (is_string($value)) {
                 $users->where($name, 'like', '%' . $value . '%');
             }
         }
     }
     $pagination = Pagination::factory(array('view' => 'pagination', 'total_items' => $users->count_all(), 'items_per_page' => core::config('advertisement.advertisements_per_page')));
     /**
      * order depending on the sort parameter
      */
     switch (core::request('sort')) {
         //num of ads desc
         case 'ads-asc':
             $users->order_by('ads_count', 'asc')->order_by('created', 'desc');
             break;
             //num of ads desc
         //num of ads desc
         case 'ads-desc':
             $users->order_by('ads_count', 'desc')->order_by('created', 'desc');
             break;
             //name z->a
         //name z->a
         case 'name-asc':
             $users->order_by('name', 'asc')->order_by('created', 'desc');
             break;
             //name a->z
         //name a->z
         case 'name-desc':
             $users->order_by('name', 'desc')->order_by('created', 'desc');
             break;
             //rating
         //rating
         case 'rating':
             $users->order_by('rate', 'desc')->order_by('created', 'desc');
             break;
             //oldest first
         //oldest first
         case 'created-asc':
             $users->order_by('created', 'asc');
             break;
             //newest first
         //newest first
         case 'created-desc':
         default:
             $users->order_by('created', 'desc');
             break;
     }
     $users = $users->limit($pagination->items_per_page)->offset($pagination->offset)->find_all();
     //if home page is the users
     if (($landing = json_decode(core::config('general.landing_page'))) != NULL and $landing->controller == 'user' and $landing->action == 'index' and (isset($pagination) and $pagination->current_page == 1)) {
         //only show site title
         $this->template->title = NULL;
         // if we have site description lets use that ;)
         if (core::config('general.site_description') != '') {
             $this->template->meta_description = core::config('general.site_description');
         }
     } else {
         Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Home'))->set_url(Route::url('default')));
         Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Users')));
         $this->template->title = __('Users search');
     }
     if (Theme::get('infinite_scroll')) {
         $this->template->scripts['footer'][] = '//cdn.jsdelivr.net/jquery.infinitescroll/2.0b2/jquery.infinitescroll.js';
         $this->template->scripts['footer'][] = 'js/users.js';
     }
     $this->template->content = View::factory('pages/user/list', array('users' => $users, 'pagination' => $pagination));
 }