$table
$table :
Model Class
<?php
if (!defined('BASEPATH'))
exit('No direct script access allowed');
class Admin_model extends CI_Model
{
private $table = 'admin';
public function __construct()
{
parent::__construct();
}
/**
* 根据用户名和密码获取用户信息
*
* @param unknown $adminname
* @param unknown $password
*/
public function getAdminByName($adminName, $password = FALSE)
{
if ($password != FALSE)
{
$this->db->where('password', md5($password));
}
$this->db->where('adminName', $adminName);
$result = $this->db->get($this->table);
// return $result;
return $result->row_array();
}
public function getOneByName($adminName)
{
$this->db->where('adminName', $adminName);
$result = $this->db->get($this->table);
return $result->row_array();
}
/**
* 获取用户列表
* */
public function getAdminList($where=array(), $select = '*',$limit=10,$start=0)
{
$param = $this->_getWhere($where);
$this->db->select($select);
$this->db->where($param);
$this->db->order_by('adminId','desc')->limit($limit, $start);
return $this->db->get( $this->table )->result_array();
}
/**
* 获取用户列表
* */
public function getAdminAllList()
{
$this->db->order_by('adminId','desc');
return $this->db->get($this->table)->result_array();
}
/**
*获取单条数据
* */
public function getAdminRow($adminId=0)
{
$this->db->where('adminId', $adminId);
$result = $this->db->get($this->table);
return $result->row_array();
}
/**
* 添加
* */
public function insertData($userData)
{
$res = $this->db->insert($this->table, $userData);
return $res;
}
/**
* 修改
* */
public function setAdminByID($updateData, $adminId)
{
$this->db->where('adminId', $adminId);
return $this->db->update($this->table, $updateData);
}
/**
* 获取总条数
* */
public function getAdminCount($where=array())
{
$param = $this->_getWhere($where);
$this->db->where($param);
return $this->db->count_all_results($this->table);
}
/**
* 查询条件
* */
public function _getWhere( $where=array() )
{
$param = array();
if (!empty($where['realName']))
{
$param['realName like'] = '%'.strval($where['realName']).'%';
}
if (!empty($where['roleId']))
{
$param['roleId'] = $where['roleId'];
}
if (!empty($where['adminName']))
{
$param['adminName like'] = '%'.strval($where['adminName']).'%';
}
return $param;
}
/**
* 验证唯一
* */
public function checkUnique($name,$adminId=0)
{
$this->db->where('adminName', $name);
if(!empty($adminId))
{
$this->db->where('adminId !=', $adminId);
}
$result = $this->db->get($this->table);
return $result->row_array();
}
/**
* 删除用户
* */
public function delete( $adminId )
{
$this->db->where( 'adminId', $adminId );
$query = $this->db->delete( $this->table);
return $query ? $adminId : false;
}
}
?>