application/modelsUser_model.php

<?php

if (!defined('BASEPATH'))
	exit('No direct script access allowed');
class User_model extends CI_Model
{
    private $table ='user';
    private static $DB;
	public function __construct()
	{
		parent::__construct();
		self::$DB = $this->load->database('dev', TRUE);
		//self::$DB    = $this->load->database('yiqi', TRUE);
	}
	
	/**
	 * 数据统计
	 * */
	public function getStatisticsUserCount($stime,$etime)
	{
// 	    self::$DB->where('typeFlag',2);
	    self::$DB->where('createTime >',$stime);
	    self::$DB->where('createTime <',$etime);
	   // self::$DB->get($this->table);
	    //echo self::$DB->last_query()."++++";exit;
	    return self::$DB->count_all_results($this->table);
	    //echo self::$DB->last_query()."++++";exit;
	     
	}
	
	/**统计年龄
	 * */
	public function getStatisticsAgeUserCount($satime,$eatime)
	{
// 	    self::$DB->where('typeFlag',2);
	    self::$DB->where('birthday >=', "$satime");
	    self::$DB->where('birthday <',"$eatime");
	   //echo self::$DB->last_query();
	    return self::$DB->count_all_results($this->table);
	}
	
	/**
	 * 统计性别
	 * */
	public function getStatisticsSexUserCount($type=0,$stime=0,$etime=0)
	{
// 	    self::$DB->where('typeFlag',2);
        if(!empty($stime)){
	    self::$DB->where('createTime >',$stime);
        }
        if(!empty($etime)){
	    self::$DB->where('createTime <',$etime);
        }
	    self::$DB->where('sex',$type);
	    return self::$DB->count_all_results($this->table);
	}
	
	/**
	 * 根据用户名和密码获取用户信息
	 *
	 * @param unknown $username
	 * @param unknown $password
	 */
	public function getUserByNamePass($username, $password)
	{

		$sql = self::$DB->query('SELECT * FROM `user` WHERE (`userName` = "'.$username.'" OR `email` = "'.$username.'" OR `phone` = "'.$username.'") AND `password` = "'.md5($password).'" and active=0');
		return $sql->row_array();
	}

	/**
	 * 获取用户列表
	 * */
	public function getUserList($where=array(), $select = '*',$limit=10,$start=0)
	{
	    $param = $this->_getWhere($where);
	    self::$DB->select($select);
	    self::$DB->where($param);
	    self::$DB->where('deleteFlag','0');
	    self::$DB->order_by('userId','desc')->limit($limit, $start);
	    return self::$DB->get($this->table)->result_array();
	    
	     
	}
	
	/**
	 * 获取用户列表
	 * */
	public function getUserAllList()
	{	 
	    self::$DB->order_by('userId','desc');
	    return self::$DB->get($this->table)->result_array();
	}

	
	/**
	 *获取单条数据
	 * */
	public function getUserRow($userId=0)
	{
	    self::$DB->where('id', $userId);
	    $result = self::$DB->get($this->table);
	    return $result->row_array();
	}
	
	public function getUserInfoRow($userId=0)
	{
	    self::$DB->where('userId', $userId);
	    self::$DB->where('typeFlag', 0);
	    $result = self::$DB->get('userinfo');
	    return $result->row_array();
	}
	
	/**
	 * 
	 * 添加
	 * */
	public function insertData($userData)
	{
	    
	    $bool = self::$DB->insert($this->table, $userData);
	    $res = $bool ?self::$DB->insert_id() : false;
		return $res;
	}
	
    /**
     * 修改
     * */

	public function setUserByID($updateData, $userId)
	{
	    self::$DB->where('userId', $userId);
	   // $this->db->where('typeFlag',$typeFlag);
	    return self::$DB->update($this->table, $updateData);
	}
	
	public function updateNum($data,$userId=0)
	{
	    foreach ($data as $k => $v)
	    {
	        self::$DB->set($k, $v, FALSE);
	    }
	    self::$DB->where('userId', $userId)->update( $this->table );
	    return self::$DB->affected_rows();
	}
	
	/**
	 * 获取总条数
	 * */
	public function getUserCount($where=array())
	{

	    
	    return self::$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['userName']))
	    {
	        $param['userName like'] = '%'.strval($where['userName']).'%';
	    }
	    if (!empty($where['phone']))
	    {
	        $param['phone like'] = '%'.strval($where['phone']).'%';
	    }
	    if (!empty($where['email']))
	    {
	        $param['email like'] = '%'.strval($where['email']).'%';
	    }
	    if (isset($where['userFlag']) && $where['userFlag']!='-1')
	    {
	        $param['userFlag'] = intval($where['userFlag']);
	    }
// 	    $param['typeFlag'] = intval(2);
	   $param['deleteFlag'] = intval(0);
	    return $param;
	}
	
	/**
	 * 验证唯一
	 * */
	public function checkUnique($name,$userId=0)
	{

	    $sql1 ='';
	    if(!empty($userId)){ $sql1=' and userId !='.$userId;}
	    $sql = self::$DB->query('SELECT * FROM `user` WHERE (`cellphone` = "'.$name.'")'.$sql1);
//	   echo $name;exit;
	    return $sql->row_array();
	    
	}
	
	public function checkEmail($name,$userId=0)
	{
	    if($name)
	    {
	        self::$DB->where('email', $name);
	    }
	
	    if(!empty($userId))
	    {
	        self::$DB->where('userId !=', $userId);
	    }
	    $result = self::$DB->get($this->table);
	     
	    return $result->row_array();
	}
	
	public function checkPhone($name,$userId=0)
	{
	    if($name)
	    {
	        self::$DB->where('phone', $name);
	    }
	
	    if(!empty($userId))
	    {
	        self::$DB->where('userId !=', $userId);
	    }
	    $result = self::$DB->get($this->table);
	
	    return $result->row_array();
	}
	
	/**
	 * 验证密码是否正确
	 * */
	public function checkPassword($password,$userId=0)
	{
	    self::$DB->where('password', md5($password));
	    self::$DB->where('userId', $userId);
	    $result = self::$DB->get($this->table);
	    return $result->row_array();
	}
	
	public function checkPhoneEmail($param,$userId=0,$type='phone')
	{
	    self::$DB->where($type, $param);
	    self::$DB->where('userId', $userId);
	    $result = self::$DB->get($this->table);
	    return $result->row_array();
	}
	
	/**
	 * 删除用户
	 * */
	public function delete( $userId )
	{
	    self::$DB->where( 'id', $userId );
	    $query = self::$DB->delete( $this->table);
	    return $query ? $userId : false;
	}
}
?>