\App_user_model

<?php

if (!defined('BASEPATH')) exit('No direct script access allowed');
class App_user_model extends CI_Model
{
    //连接华为服务器上tanqinba数据库的user表
    private $table ='user';
    private $db_user='tanqinba';      //用户表所在数据库名  
    private $db_app='jitaapp';          //app数据表所在数据库名
	public function __construct()
	{
		parent::__construct();		
	}
	
	
	public function check($where,$select='*',$limit=16,$start=0){
	    $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
	    if (!is_array($where)){
	        return false;
	    }
	    $this->db->select($select);
	    //$this->db->from('blogs');
	    $this->db->where($where);
	    $this->db->join('userinfo', 'user.userId = userinfo.userId');
	    
	    $res=$this->db->get($this->table,$limit,$start)->result_array();
	    $this->db->db_select($this->db_app);      //函数结束时加载吉他app的数据库
	    return $res;	    
	}
	//获取企业信息
	public function qiye_get($where){
	    $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
	    $this->db->where($where);
	    $res=$this->db->get('user_qiye')->row_array();
	    $this->db->db_select($this->db_app);      //函数结束时加载吉他app的数据库
	    return $res;
	}
	//添加企业信息
	public function qiye_add($data){
	    $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
	    $this->db->insert('user_qiye',$data);
	    $res=$this->db->insert_id();
	    $this->db->db_select($this->db_app);      //函数结束时加载吉他app的数据库
	    return $res;
	}
	//更新企业信息
	public function qiye_update($where,$data){
	    $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
	    $this->db->where($where);
	    $this->db->update('user_qiye',$data);
	    $res=$this->db->affected_rows();
	    $this->db->db_select($this->db_app);      //函数结束时加载吉他app的数据库
	    return $res;
	}
	//获取企业类型	
	public function qiye_type(){
	    $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
	    //$this->db->where($where);
	    $res=$this->db->get('qiye_type')->result_array();
	    $this->db->db_select($this->db_app);      //函数结束时加载吉他app的数据库
	    return $res;
	}
	/**
	 * 修改
	 * */
	
	public function update($userId,$data)
	{
	    $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
	    foreach ($data as $k => $v)
	    {
	        $this->db->set($k, $v, FALSE);
	    }
	    $this->db->where('userId', $userId)->update($this->table);
	    $res=$this->db->affected_rows();
	    $this->db->db_select($this->db_app);      //函数结束时加载吉他app的数据库
	    return $res;
	}
	
    public function userpoint_insert($data){
        $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
        $this->db->insert('userpoints',$data);
        $res=$this->db->affected_rows();
        $this->db->db_select($this->db_app);      //函数结束时加载吉他app的数据库        
        return $res;	    
    }
    //更新浏览量
    public function updateViewNum($userId){
        $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
        $this->db->set('viewNum_singer','viewNum_singer+1',false);
        $this->db->where('userid',$userId)->update('user');
        $this->db->db_select($this->db_app);      //函数结束时加载吉他app的数据库
        return $this->db->affected_rows();
    }
	/**
	 * 根据用户名和密码获取用户信息
	 *
	 * @param unknown $username
	 * @param unknown $password
	 */
	
	public function getUserByNamePass($username, $password)
	{

		$sql = $this->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);
	    $this->db->select($select);
	    $this->db->where($param);
	    $this->db->order_by('userId','desc')->limit($limit, $start);
	    return $this->db->get($this->table)->result_array();
	}
	
	/**
	 * 获取用户列表
	 * */
	public function getUserAllList()
	{	 
	    $this->db->order_by('userId','desc');
	    return $this->db->get($this->table)->result_array();
	}

	
	/**
	 *获取单条数据
	 * */
	public function getUserRow($userId=0)
	{
	    $this->db->where('userId', $userId);
	    $result = $this->db->get($this->table);
	    return $result->row_array();
	}
	
	public function getUserInfoRow($userId=0)
	{
	    $this->db->where('userId', $userId);
	    $this->db->where('typeFlag', 0);
	    $result = $this->db->get('userinfo');
	    return $result->row_array();
	}
	
	/**
	 * 添加
	 * */
	public function insertData($userData)
	{
	    $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
	    $bool = $this->db->insert($this->table, $userData);
	    $res = $bool ? $this->db->insert_id() : false;
	    $this->db->db_select($this->db_app);      //函数开始时加载弹琴吧数据库
		return $res;
	}
	
    
	
	/**
	 * 获取总条数
	 * */
	public function getUserCount($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['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(1);
	    return $param;
	}
	
	/**
	 * 验证唯一
	 * */
	public function checkUnique($name,$userId=0)
	{
	    $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
	    if($name)
	    {
	        $this->db->where('userName', $name);
	        $this->db->or_where('email', $name);
	        $this->db->or_where('phone', $name);
	    }
	   
	    if(!empty($userId))
	    {
	        $this->db->where('userId !=', $userId);
	    }
	    $result = $this->db->get($this->table);
	    $this->db->db_select($this->db_app);      //函数开始时加载千城数据库
	    return $result->row_array();
	}
	
	/**
	 * 验证密码是否正确
	 * */
	public function checkPassword($password,$userId=0)
	{
	    $this->db->where('password', md5($password));
	    $this->db->where('userId', $userId);
	    $result = $this->db->get($this->table);
	    return $result->row_array();
	}
	
	public function checkPhoneEmail($param,$userId=0,$type='phone')
	{
	    $this->db->where($type, $param);
	    $this->db->where('userId', $userId);
	    $result = $this->db->get($this->table);
	    return $result->row_array();
	}
	
	/**
	 * 删除用户
	 * */
	public function delete( $userId )
	{
	    $this->db->where( 'userId', $userId );
	    $query = $this->db->delete( $this->table);
	    return $query ? $userId : false;
	}
	//查询第三方
	public function third_select($where) {
	    $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
	    $result = false;
        $this->db->select();
        $this->db->from('thirdlogin');
        $this->db->where($where);
        $query = $this->db->get();
        if($query)
        {
            $result = $query->row_array();
        }
        $this->db->db_select($this->db_app);      //函数结束时加载吉他app的数据库
        return $result;
	}
	//第三方插入
	public function third_insert($data){
	    $this->db->db_select($this->db_user);      //函数开始时加载弹琴吧数据库
	    $this->db->insert('thirdlogin',$data);
	    $res=$this->db->affected_rows();
	    $this->db->db_select($this->db_app);      //函数结束时加载吉他app的数据库
	    return $res;
	}
}
?>