qpapi/app/Http/Models/UserInfo.php

<?php

namespace App\Http\Models;

use Illuminate\Database\Eloquent\Model;
use \App\Models;

/**
 * 救济金模型类
 */
class UserInfo extends Model
{


    /**
     * 用户详细查询
     *
     * @access public
     * @param mixed $where 查询条件
     * @param mixed $select 查询字段
     * @return array
     */
    public function userInfo($select, $where)
    {
        // 获取救济金记录.
        $membersDetailedModel = new Models\MembersDetailed;
        $result = $membersDetailedModel
            ->select($select)
            ->where($where)
            ->first();

        return $result;

    }//end userInfo()


    /**
     * 用户详细多个查询
     *
     * @access public
     * @param mixed $where 查询条件
     * @param mixed $select 查询字段
     * @return array
     */
    public function getUserInfo($select, $where)
    {
        // 获取救济金记录.
        $membersDetailedModel = new Models\MembersDetailed;
        $result               = $membersDetailedModel->select($select);
        if (empty($where) === false) {
            $result = $result->where($where);
        }

        $result = $result->get();

        return $result;

    }//end getUserInfo()


    /**
     * 用户详细多个查询
     *
     * @access public
     * @param mixed $where 查询条件
     * @param mixed $select 查询字段
     * @return array
     */
    public function getAllUserInfo($select)
    {
        $membersDetailedModel = new Models\MembersDetailed;
        $result               = $membersDetailedModel
            ->select($select)
            ->join('members', 'membersDetailed.members_id', 'members.id')
            ->whereNotIn('membersDetailed_cash', [0])
            ->get();

        return $result;

    }//end getAllUserInfo()


    /**
     * 用户游戏余额
     *
     * @access public
     * @param mixed $where 查询条件
     * @param mixed $select 查询字段
     * @return array
     */
    public function gameMoney($select, $where)
    {
        // 获取救济金记录.
        $gameMoneyModel = new Models\GameMoney;
        $result         = $gameMoneyModel->select($select);
        if (empty($where) === false) {
            $result = $result->where($where);
        }

        $result = $result->get();

        return $result;

    }//end gameMoney()


    /**
     * 修改用户信息
     *
     * @access public
     * @param mixed $where 查询条件
     * @param mixed $data 修改数据
     * @return array
     */
    public function upUserInfo($where, $data)
    {
        // 获取救济金记录.
        $membersDetailedModel = new Models\MembersDetailed;
        $result = $membersDetailedModel
            ->where($where)
            ->update($data);

        return $result;

    }//end upUserInfo()


}