* @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; } } }