<?php

namespace App\Http\Models;

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

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


    /**
     * 查询救济金记录
     *
     * @access public
     * @param mixed $where 查询条件
     * @param mixed $between 查询条件
     * @param mixed $paginate 分页
     * @return array
     */
    public function getRelief($select, $paginate, $where='', $between='')
    {
        // 获取救济金记录.
        $getReliefModel = new Models\GetRelief;
        $getReliefModel = $getReliefModel
            ->select($select)
            ->join('members', 'members.id', 'getrelief.members_id');
        if (empty($where) === false) {
            $getReliefModel = $getReliefModel->where($where);
        }

        if (empty($between) === false) {
            $getReliefModel = $getReliefModel->whereBetween('getrelief_addtime', $between);
        }

        $getReliefModel = $getReliefModel
            ->orderBy('getrelief_addtime','desc')
            ->paginate($paginate)
            ->toArray();

        return $getReliefModel;

    }//end getRelief()


    /**
     * 添加救济金记录
     *
     * @access public
     * @param mixed $data 数据
     * @return array
     */
    public function addRelief($data)
    {
        // 获取救济金记录.
        $getReliefModel = new Models\GetRelief;
        $result = $getReliefModel->insert($data);

        return $result;

    }//end addRelief()


    /**
     * 查询救济金记录
     *
     * @access public
     * @param mixed $where 查询条件
     * @param mixed $between 查询条件
     * @param mixed $paginate 分页
     * @return array
     */
    public function countRelief($where, $between)
    {
        // 获取救济金记录.
        $getReliefModel = new Models\GetRelief;
        $result = $getReliefModel
            ->where($where)
            ->whereBetween('getrelief_addtime', $between)
            ->count();

        return $result;

    }//end countRelief()


    /**
     * 查询救济金系统设置
     *
     * @access public
     * @param mixed $where 查询条件
     * @param mixed $between 查询条件
     * @param mixed $paginate 分页
     * @return array
     */
    public function getSystemconfig($select, $where)
    {
        // 查询救济金系统设置.
        $systemconfigModel = new Models\Systemconfig;
        $systemconfigModel = $systemconfigModel
            ->select($select)
            ->where($where)
            ->get();

        return $systemconfigModel;

    }//end getSystemconfig()


    /**
     * 修改救济金系统设置
     *
     * @access public
     * @param mixed $where 查询条件
     * @param mixed $data 数据
     * @return array
     */
    public function upSystemconfig($where, $data)
    {
        // 查询救济金系统设置.
        $systemconfigModel = new Models\Systemconfig;
        $systemconfigModel = $systemconfigModel
            ->where($where)
            ->update($data);

        return $systemconfigModel;

    }//end upSystemconfig()


}