<?php

namespace Common\Model;

//[1.8.68]

/**
 * 普通用户领取的优惠券记录表
 * Class RetailCouponLogsModel
 * @package Common\Model
 */
class RetailCouponLogsModel extends BaseModel
{
    protected $tableName = 'retail_coupon_logs';
    const ID = 'id';   //int(11) NOT NULL AUTO_INCREMENT,
    const COUPON_ID = 'coupon_id';   //int(11) DEFAULT NULL COMMENT '用户领取的优惠券id',
    const UID = 'uid';   //int(11) DEFAULT NULL COMMENT '用户id',
    const STORE_ID = 'storeid';   //int(11) DEFAULT NULL COMMENT '门店id',
    const MERCHANT_ID = 'merchantid';   //int(11) DEFAULT NULL COMMENT '商户id ',
    const ADD_TIME = 'addtime';   //varchar(18) DEFAULT NULL COMMENT '领取时间',
    const STATUS = 'status';   //tinyint(3) DEFAULT '1' COMMENT '用户领取得优惠券状态   1：未使用   2：已使用',
    const USE_TIME = 'usetime';   //varchar(18) DEFAULT NULL COMMENT '使用时间',

    /**
     * 获取已领取的优惠券的详细情况
     * @param $where
     * @param $field
     * @param string $order
     * @param $page
     * @return mixed
     */
    public function getCoupon($where, $field, $order = 'c.end_time', $page = '')
    {
        if ($page) {
            $coupon = $this->alias('l')
                ->join("ls_retail_coupon as c ON c.id=l.coupon_id")
                ->field($field)
                ->where($where)
                ->order($order)
                ->page($page)
                ->select();
        } else {
            $coupon = $this->alias('l')
                ->join("ls_retail_coupon as c ON c.id=l.coupon_id")
                ->field($field)
                ->where($where)
                ->order($order)
                ->select();
        }

        return $coupon;
    }

    /**
     * 获取已领取的优惠券的数量
     * @param $where
     * @return mixed
     */
    public function getCouponCount($where)
    {
        $count = $coupon = $this->alias('l')
            ->join("ls_retail_coupon as c ON c.id=l.coupon_id")
            ->where($where)
            ->count();
        return $count;
    }
}