PHP UserModel::search方法代码示例

 public function noneedhelp($id = null)
 {
     $this->load->model('UserModel');
     $user = new UserModel();
     $data = $user->search($id);
     if ($data['help'] === '0') {
         return true;
     } else {
         redirect(base_url('help'));
     }
 }

 public function search()
 {
     parent::checkLogin();
     $data = null;
     $user = new UserModel();
     $tables = $user->getTables();
     foreach ($tables as $item) {
         $item->tableName = substr($item->tableName, 10);
         $item->tableName = str_replace('_', '-', $item->tableName);
     }
     $BMIArr = array(0 => '肥胖', 1 => '超重', 2 => '低体重', '正常');
     $otherArr = array(0 => '不及格', 1 => '及格', 2 => '良好', 3 => '优秀');
     if (isset($_POST['send'])) {
         $model = new UserModel();
         $model->tableName = 'tice_data_' . str_replace('-', '_', $_POST['year']);
         $model->stuId = $_SESSION['ticeStuId'];
         $data = $model->search();
         //var_dump($data);
     }
     $config = new AttributesModel();
     $configArr = $config->getConfig();
     $pageArr = array(0 => 'site/searchColleage', 1 => 'site/searchColleage', 2 => 'site/searchColleage', 3 => 'site/searchPrimary');
     $this->render($pageArr[$configArr->schoolType], array('yearArr' => $tables, 'data' => $data, 'post' => isset($_POST['send']) ? true : false, 'BMIArr' => $BMIArr, 'otherArr' => $otherArr, 'searchYear' => isset($_POST['year']) ? $_POST['year'] : ''));
 }

 /**
  * User management list.
  *
  * @since 2.0.0
  * @access public
  * @param mixed $Keywords Term or array of terms to filter list of users.
  * @param int $Page Page number.
  * @param string $Order Sort order for list.
  */
 public function index($Keywords = '', $Page = '', $Order = '')
 {
     $this->permission(array('Garden.Users.Add', 'Garden.Users.Edit', 'Garden.Users.Delete'), '', false);
     // Page setup
     $this->addJsFile('jquery.gardenmorepager.js');
     $this->addJsFile('user.js');
     $this->title(t('Users'));
     $this->setHighlightRoute('dashboard/user');
     Gdn_Theme::section('Moderation');
     // Form setup
     $this->Form->Method = 'get';
     // Input Validation.
     list($Offset, $Limit) = offsetLimit($Page, PagerModule::$DefaultPageSize);
     if (!$Keywords) {
         $Keywords = $this->Form->getFormValue('Keywords');
         if ($Keywords) {
             $Offset = 0;
         }
     }
     if (!is_string($Keywords)) {
         $Keywords = '';
     }
     // Put the Keyword back in the form
     if ($Keywords) {
         $this->Form->setFormValue('Keywords', $Keywords);
     }
     $UserModel = new UserModel();
     list($Offset, $Limit) = offsetLimit($Page, 30);
     // Determine our data filters.
     $Filter = $this->_getFilter();
     if ($Filter) {
         $Filter['Keywords'] = $Keywords;
     } else {
         $Filter = array('Keywords' => (string) $Keywords);
     }
     $Filter['Optimize'] = Gdn::userModel()->pastUserThreshold();
     // Sorting
     if (in_array($Order, array('DateInserted', 'DateFirstVisit', 'DateLastActive'))) {
         $Order = 'u.' . $Order;
         $OrderDir = 'desc';
     } else {
         $Order = 'u.Name';
         $OrderDir = 'asc';
     }
     // Get user list
     $this->UserData = $UserModel->search($Filter, $Order, $OrderDir, $Limit, $Offset);
     $this->setData('Users', $this->UserData);
     // Figure out our number of results and users.
     $showUserCount = $this->UserData->count();
     if (!Gdn::userModel()->pastUserThreshold()) {
         // Pfft, query that sucker however you want.
         $this->setData('RecordCount', $UserModel->searchCount($Filter));
     } else {
         // We have a user search, so at least set enough data for the Next pager.
         if ($showUserCount) {
             $this->setData('_CurrentRecords', $showUserCount);
         } else {
             // No search was done. Just give the total users overall. First, zero-out our pager.
             $this->setData('_CurrentRecords', 0);
             if (!Gdn::userModel()->pastUserMegaThreshold()) {
                 // Restoring this semi-optimized counter is our compromise to let non-mega sites know their exact total users.
                 $this->setData('UserCount', $UserModel->getCount());
             } else {
                 // Dang, yo. Get a table status guess instead of really counting.
                 $this->setData('UserEstimate', Gdn::userModel()->countEstimate());
             }
         }
     }
     // Add roles to the user data.
     RoleModel::setUserRoles($this->UserData->result());
     // Deliver json data if necessary
     if ($this->_DeliveryType != DELIVERY_TYPE_ALL && $this->_DeliveryMethod == DELIVERY_METHOD_XHTML) {
         $this->setJson('LessRow', $this->Pager->toString('less'));
         $this->setJson('MoreRow', $this->Pager->toString('more'));
         $this->View = 'users';
     }
     $this->render();
 }

 public function update()
 {
     if ($this->isLogged()) {
         $page = $this->getPage();
         $this->load->model('UserModel');
         $user = new UserModel();
         $data['id'] = $this->input->get('id');
         $data['name'] = mb_strtoupper($this->input->get('name'));
         $data['username'] = $this->input->get('username');
         $data['phone'] = $this->input->get('phone');
         $pass = $this->input->get('changepass');
         $confirmpass = $this->input->get('confirmpass');
         if (empty($pass)) {
             $pass = $this->input->get('password');
             $confirmpass = $pass;
             $data['password'] = $pass;
         } else {
             $data['password'] = md5($this->input->get('changepass'));
         }
         $data['role'] = $this->input->get('role');
         $data['status'] = $this->input->get('status');
         if ($pass === $confirmpass) {
             if (!$user->verifyusn($this->input->get('username'))) {
                 if ($user->update($data)) {
                     redirect(base_url('user/index/2'));
                 }
             } else {
                 $aux = $user->search($data['id']);
                 if ($aux['username'] === $data['username']) {
                     if ($user->update($data)) {
                         redirect(base_url('user/index/2'));
                     }
                 } else {
                     $savefail = array("class" => "danger", "message" => "Nome de usuário já existente no banco");
                     $data = $user->search($data['id']);
                     $msg = array("savefail" => $savefail, "user" => $data);
                     $this->load->view('template/super/header', $page);
                     $this->load->view('super/edituser', $msg);
                     $this->load->view('template/public/footer');
                 }
             }
         } else {
             $savefail = array("class" => "danger", "message" => "As senhas inseridas não são iguais");
             $data = $user->search($data['id']);
             $msg = array("savefail" => $savefail, "user" => $data);
             $this->load->view('template/super/header', $page);
             $this->load->view('super/edituser', $msg);
             $this->load->view('template/public/footer');
         }
     }
 }

 public function index()
 {
     if (in_array(Auth::getCapability(), array(CAPABILITY_ADMINISTRATOR))) {
         Model::autoloadModel('User');
         $model = new UserModel($this->db);
         $this->para = new stdClass();
         if (isset($_POST['type'])) {
             $this->para->type = $_POST['type'];
         }
         if (isset($_POST['role'])) {
             $this->para->role = $_POST['role'];
         }
         if (isset($_POST['orderby'])) {
             $this->para->orderby = $_POST['orderby'];
         }
         if (isset($_POST['order'])) {
             $this->para->order = $_POST['order'];
         }
         if (isset($_POST['page'])) {
             $this->para->page = $_POST['page'];
         }
         if (isset($_POST['s'])) {
             $this->para->s = $_POST['s'];
         }
         if (isset($_POST['paged'])) {
             $this->para->paged = $_POST['paged'];
         }
         if (isset($_POST['users'])) {
             $this->para->users = $_POST['users'];
         }
         if (isset($_POST['new_role'])) {
             $this->para->new_role = $_POST['new_role'];
         }
         if (isset($_POST['new_role2'])) {
             $this->para->new_role2 = $_POST['new_role2'];
         }
         if (isset($_POST['action'])) {
             $this->para->action = $_POST['action'];
         }
         if (isset($_POST['action2'])) {
             $this->para->action2 = $_POST['action2'];
         }
         if (isset($_POST['email_show'])) {
             $this->para->email_show = $_POST['email_show'];
         }
         if (isset($_POST['role_show'])) {
             $this->para->role_show = $_POST['role_show'];
         }
         if (isset($_POST['tours_show'])) {
             $this->para->tours_show = $_POST['tours_show'];
         }
         if (isset($_POST['users_per_page'])) {
             $this->para->users_per_page = $_POST['users_per_page'];
         }
         if (isset($_POST['adv_setting'])) {
             $this->para->adv_setting = $_POST['adv_setting'];
         }
         if (isset($this->para->adv_setting) && $this->para->adv_setting == "adv_setting") {
             $model->changeAdvSetting($this->para);
         }
         if (isset($this->para->type) && in_array($this->para->type, array("action", "action2", "new_role", "new_role2")) && isset($this->para->users)) {
             if (in_array($this->para->type, array("action", "action2"))) {
                 $model->executeAction($this->para);
             } else {
                 $model->changeRole($this->para);
             }
         }
         $model->search($this->view, $this->para);
         if (count((array) $this->para) > 0) {
             $this->view->ajax = TRUE;
             $this->view->renderAdmin(RENDER_VIEW_USER_INDEX, TRUE);
         } else {
             $this->view->renderAdmin(RENDER_VIEW_USER_INDEX);
         }
     } else {
         $this->login();
     }
 }