<?php
namespace App\Model;

use Illuminate\Database\Eloquent\Model;
use Request;
use Excel;
use DB;

class CmsModel extends Model
{
    protected $table = 'user_info';
    protected $primaryKey = 'userId';
    public $timestamps = false;

    // 获取用户名称
    public function getUserName($userId, $field='name')
    {
        $user = $this->where(['userId' => $userId])->select($field)->first(); 

        return $user ? $user->$field : '';
    }

    // 获取用户ID
    public function getSaleId($name='')
    {
    	if (!$name) return false;
    	
    	$name && $map['name'] = $name;

    	$user = $this->where($map)->select('userId')->first(); 

        return $user ? $user->userId : 0;
    }

    /*
		查询cms系统用户信息
    */
	public function getUserInfo($where){

		return $this->where($where)->select('userId')->first(); 
	}

	/*
		批量查询用户姓名
	*/
	public function getBatchUserName($user_ids){

		return $this->whereIn('userId',$user_ids)->select('userId','name','email')->get()->toArray(); 
	}

}