game-sdk/simplewind/huo/model/integral/AwardsModel.php

<?php
/**
 * AwardsModel.php UTF-8
 * 抽奖奖励表
 *
 * @date    : 2018/5/10 21:12
 *
 * @license 这不是一个自由软件，未经授权不许任何使用和传播。
 * @author  : wuyonghong <wyh@huosdk.com>
 * @version : HUOSDK 8.0
 */

namespace huo\model\integral;

use huo\model\common\CommonModel;

class AwardsModel extends CommonModel {
    protected $name               = 'awards';
    protected $autoWriteTimestamp = true;

    /**
     * 基础查询
     *
     * @param $query
     */
    protected function base($query) {
        $query->where('delete_time', 0)
              ->where('is_delete', 2);
    }

    /**
     * 添加奖品
     *
     * @param array $data
     *
     * @return bool|mixed
     */
    public function addAward($data) {
        $_data['act_id'] = get_val($data, 'act_id', '');
        $_data['award_name'] = get_val($data, 'award_name', '');
        $_data['rate'] = get_val($data, 'rate', 0);
        $_data['total_cnt'] = get_val($data, 'total_cnt', PHP_INT_MAX);
        $_data['remain_cnt'] = get_val($data, 'remain_cnt', 0);
        $_data['limit_cnt'] = get_val($data, 'limit_cnt', 0);
        $_data['list_order'] = get_val($data, 'list_order', 0);
        $_data['goods_id'] = get_val($data, 'goods_id', 0);
        $_data['create_time'] = time();
        if (empty($_data)) {
            return false;
        }
        if ($_obj = self::create($_data)) {
            return $_obj->id;
        } else {
            return false;
        }
    }

    /**
     * 获取奖品
     *
     * @param int $act_id
     *
     * @return array|false|\PDOStatement|string|\think\Collection
     */
    public function getAwards($act_id = 0) {
        $_map['act_id'] = $act_id;
        $_field = 'id award_id,act_id,award_name,rate,total_cnt,remain_cnt,goods_id,limit_cnt,list_order';
        $_data = $this->where($_map)->order('list_order asc, id asc')->column($_field, 'id');

        return $_data;
    }

    /**
     * 更新奖品
     *
     * @param array  $award_data
     * @param string $award_id
     *
     * @return bool
     */
    public function updateAward($award_data, $award_id) {
        $_map['id'] = $award_id;
        $_data = $award_data;
        $_rs = self::update($_data, $_map, true);
        if (false == $_rs) {
            return false;
        } else {
            return true;
        }
    }
}