public function getUsersDataTable() { $query = UserModel::select('username', 'roles', 'id')->get(); return Datatable::collection($query)->addColumn('id', function ($model) { return '<a href="/users/' . $model->id . '">view</a>'; })->searchColumns('username', 'roles')->orderColumns('username', 'roles')->make(); }
public function index() { $usertype = Cookie::get('usertype'); if ($usertype === 'Manager') { $user = new UserModel(); $teacher = new TeacherModel(); $course = new CourseModel(); $school = new SchoolModel(); $userlist = $user->select(); $teacherlist = $teacher->select(); $courselist = $course->select(); $schoollist = $school->select(); $username = Cookie::get('username'); $usertype = Cookie::get('usertype'); $lastlogintime = Cookie::get('lastlogintime'); $this->assign('userlist', $userlist); $this->assign('teacherlist', $teacherlist); $this->assign('courselist', $courselist); $this->assign('schoollist', $schoollist); $this->assign('username', $username); $this->assign('usertype', $usertype); $this->assign('lastlogintime', $lastlogintime); $this->display(); } elseif ($usertype === 'teacher') { $this->assign("jumpUrl", "__APP__/Teacher/login"); } else { $this->assign("jumpUrl", "__APP__/Index/index"); $this->success("正在转向首页"); } }
/** * @return bool */ public function getUsersDataTable() { $query = UserModel::select('username', 'roles', 'id')->get(); return Datatable::collection($query)->searchColumns('username', 'roles')->orderColumns('username', 'roles')->addColumn('username', function ($model) { return $model->username; })->addColumn('roles', function ($model) { return $model->roles; })->addColumn('Actions', function ($model) { return "<a href='/projectinv/public/resource/" . $model->id . "' class='btn btn-success'>View</a>"; })->make(); }
public function index($args) { //var_dump(func_get_args()); print_r($args); $user = new UserModel(); /*$user->insert('user', array( 'username' => 'chipolata', 'passwd' => 'shit happens', 'role' => 0 ));*/ $user->select('uid'); var_dump($user->get(1)); }
<?php /* 后台文件 Background entry file */ if (!defined('ACC')) { define('ACC', true); require '../system/init.php'; } // $user = new UserModel(); $userlist = $user->select(); $perPage = 7; $curPage = isset($_GET['page']) ? $_GET['page'] : 1; $pageObj = new PaginationHelper(count($userlist), $perPage, $curPage); $pageMenu = $pageObj->showPageMenu(); $userlist = $user->selectLimited(($curPage - 1) * $perPage, $perPage); $userlist = $user->dataByRealDate($userlist); include __ROOT__ . 'view/admin/templates/userlist.html';
public function testDeleteAll() { $table = new UserModel(); $table->deleteAll(); $this->assertCount(0, $table->select()); }
/** * 编辑 * */ public function editAction() { // 获取主键 $id = $this->getg('id', 0); if (empty($id)) { $this->error('id 不能为空!'); } // 实例化Model $user = new UserModel(); // 处理Post if ($this->getRequest()->isPost()) { // 获取所有post数据 $pdata = $this->getAllPost(); // 处理图片等特殊数据 // 验证 $result = $user->validation->validate($pdata, 'edit'); $user->parseAttributes($pdata); // 通过验证 if ($result) { // 入库前数据处理 // Model转换成数组 $data = $user->toArray($pdata); $result = $user->update(array('id' => $id), $data); if ($result) { // 提示信息并跳转到列表 Tools_help::setSession('Message', '修改成功!'); $this->redirect('/backend/user/index'); } else { // 出错 Tools_help::setSession('ErrorMessage', '修改失败, 请确定已修改了某项!'); $this->_view->assign("errors", $user->validation->getErrorSummary()); } $user->id = $id; } else { // 验证失败 Tools_help::setSession('ErrorMessage', '修改失败, 请检查错误项'); $this->_view->assign("errors", $user->validation->getErrorSummary()); } } // 如果Model数据为空,则获取 if (!empty($id) && empty($user->id)) { $data = $user->select(array('where' => array('id' => $id))); $user->parseAttributes($data); } // 格式化表单数据 // 模版分配数据 $this->_view->assign("user", $user); $this->_view->assign("pageTitle", '修改'); }
<?php /*验证用户名*/ define('ACC', true); require './include/init.php'; $user = new UserModel(); $rs = $user->select(); //print_r($rs); $u = $_REQUEST['username']; foreach ($rs as $v) { if ($v['username'] == $u) { echo '用户名已存在'; //return false; } } //echo '用户名已存在';
public function getUserDic() { return $this->userDao->select(['name', 'id']); }