<?php /** * Created by PhpStorm. * User: zhonglei * Date: 2017/6/5 * Time: 14:33 */ namespace Common\Model; use Common\Common\Constant; class UserAwardModel extends AbstractModel { // 构造方法 public function __construct() { parent::__construct(); } /** * 获得勋章的人员 * @author liyifei * @param int $startTime 开始时间(毫秒时间戳,默认0,不限时间) * @param int $endTime 结束时间(毫秒时间戳,默认0,不限时间) * @return array */ public function getMedalList($startTime = 0, $endTime = 0) { // 不限结束时间 $where = ''; if ($endTime > 0) { $where .= " AND `created` < {$endTime} "; } $sql = "SELECT medal_id, uid, username FROM __TABLE__ WHERE `created` > ? {$where} AND `award_type` = ? AND `status` < ? AND `domain` = ? GROUP BY medal_id, uid"; $params = [ $startTime, Constant::AWARD_TYPE_IS_MEDAL, self::ST_DELETE, QY_DOMAIN, ]; return $this->_m->fetch_array($sql, $params); } }