qpapi/app/Http/Models/Activity.php

<?php

namespace App\Http\Models;

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

/**
 * 活动管理模型类
 */
class Activity extends Model
{


    /**
     * 获取活动
     *
     * @access public
     * @param mixed $where 查询条件
     * @return String
     */
    public function getActivity($where)
    {
        $activityModel = new Models\Activity;
        $select = [
            'activity_title',
            'activity_content',
            'activity_beginTime',
            'activity_endTime',
            'activity_type',
            'activity_label',
            'activity_money',
            'activity_identity',
            'activity_ico',
        ];
        $where = $where;
        $where['activity_delete'] = 0;
        $newTime = date('Y-m-d H:i:s');
        $result = $activityModel
            ->select($select)
            ->where($where)
            ->where('activity_beginTime', '<=', $newTime)
            ->where('activity_endTime', '>', $newTime)
            ->orderBy('activity_beginTime', 'asc')
            ->get();

        return $result;

    }//end getActivity()


    /**
     * 获取所有活动
     *
     * @access public
     * @param mixed $where 查询条件
     * @param mixed $paginate 分页
     * @return String
     */
    public function getAllActivity($where, $paginate)
    {
        // 获取游戏地址数据.
        $activityModel = new Models\Activity;
        $select = [
            'activity_title',
            'activity_content',
            'activity_delete',
            'activity_type',
            'activity_label',
            'activity_money',
            'activity_data',
            'activity_data',
            'activity_identity',
            'activity_beginTime',
            'activity_endTime',
            'activity_ico',
        ];
        $getActivity = $activityModel->select($select);
        if (empty($where) === false) {
            $getActivity = $getActivity->where($where);
        }

        $getActivity = $getActivity
            ->orderBy('activity_beginTime','asc')
            ->paginate($paginate)
            ->toArray();

        return $getActivity;

    }//end getActivity()


}