<?php

namespace Common\Model;
//[1.7.14]

/**
 * VipMCouponModel 删除
 * Class GoodsModel
 * @package Common\Model
 */
class RetailVipMCouponModel extends BaseModel
{
    protected $tableName = 'retail_vipmcoupon';
    const ID = 'id';   //int(11) NOT NULL AUTO_INCREMENT,
    const VID = 'vid';   //int(11) NOT NULL DEFAULT '0' COMMENT '会员id',
    const MCOUPON_ID = 'mcouponid';    //int(11) NOT NULL DEFAULT '0' COMMENT '商家优惠券id。',
    const START_TIME = 'starttime';  //varchar(13) NOT NULL DEFAULT '' COMMENT '优惠券生效时间。',
    const END_TIME = 'endtime';    //varchar(13) NOT NULL DEFAULT '' COMMENT '优惠券过期时间。',
    const NEED_MONEY = 'needmoney';   //decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '优惠券使用门槛。',
    const REDUCE_MONEY = 'reducemoney';   //decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '优惠券面额。',
    const IS_USE = 'isuse';   //tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否使用：1，未使用。2，已使用，3，已过期（未使用的优惠券过期将改变该字段未3）',
    const USE_TIME = 'usetime';   //varchar(13) NOT NULL DEFAULT '' COMMENT '使用时间',
    const CAN_USE_STORE_IDS = 'canusestoreids';   //text NOT NULL COMMENT '能使用该优惠券的门店 。 以 ‘，’连接',
    const MERCHANT_ID = 'merchantid';   //int(11) NOT NULL DEFAULT '0' COMMENT '商户id。',
    const STORE_ID = 'storeid';    //int(11) NOT NULL DEFAULT '0' COMMENT '使用门店的id',
    const LESS_MONEY = 'lessmoney';   //decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '使用时抵扣的金额。（部分优惠券金额未完全抵扣完）。',
    const ADD_TIME = 'addtime';   //varchar(13) NOT NULL DEFAULT '' COMMENT '会员获得优惠券的时间。',
    const STATUS = 'status';    //tinyint(3) DEFAULT '2' COMMENT '优惠券状态   1下架  2开启    3删除（不读取）',
    const TYPE = 'type';   //tinyint(1) DEFAULT '1' COMMENT '类型1.普通优惠券2.券包优惠券',
    const MCOUPON_GROUP_ID = 'mcoupon_group_id';   //int(10) DEFAULT NULL COMMENT '券包id',
    const RECHARGE_ORDER_ID = 'recharge_order_id';   //int(10) DEFAULT NULL COMMENT '充值订单id',
    const BILL_ID = 'bill_id';   //int(10) DEFAULT NULL COMMENT '充值订单id',

    /**
     * 获取正在使用的优惠券,并判断该优惠券是否可以在当前门店使用
     * @param $map
     * @param $store_id
     * @param $fields
     * @return mixed
     */
    public function getFindUseCoupon($map, $store_id, $fields)
    {
        $coupon = $this->alias('v')
            ->join('ls_retail_mcoupon as m on m.id=v.' . $this::MCOUPON_ID)
            ->field($fields)
            ->where($map)
            ->find();
        if (!empty($coupon)) {
            if ($coupon[$this::CAN_USE_STORE_IDS] != 0) {
                //限制了使用门店
                $canUseStore = explode(',', trim($coupon[$this::CAN_USE_STORE_IDS], ','));
                if (!in_array($store_id, $canUseStore)) {
                    $res['status'] = 0;
                    $res['msg'] = '该优惠券不能在当前门店使用';
                    return $res;
                }
            }
            if (!is_numeric($coupon[$this::NEED_MONEY])) {
                $res['status'] = 0;
                $res['msg'] = '优惠券设置有误';
                return $res;
            }
            $res['status'] = 1;
            $res['coupon'] = $coupon;
            $res['msg'] = '查询成功';
            return $res;
        } else {
            $res['status'] = 0;
            $res['msg'] = '优惠券信息有误';
            return $res;
        }
    }


    /**
     * 获取多条可使用的优惠券
     * @param $map
     * @param $store_id
     * @param $fields
     * @return mixed
     */
    public function getSelectUseCoupon($map, $store_id, $fields = null)
    {
        $MCouponModel = D('RetailMCoupon');
        if (empty($fields)) {
            $fields = array(
                'v.' . $this::ID,
                'v.' . $this::NEED_MONEY . ' as need_money',
                'v.' . $this::REDUCE_MONEY . ' as reduce_money',
                'v.' . $this::START_TIME,
                'v.' . $this::END_TIME,
                'v.' . $this::CAN_USE_STORE_IDS,
                'm.' . $MCouponModel::COUPON_NAME . ' as coupon_name',
            );
        }
        $coupon = $this->alias('v')
            ->join('ls_retail_mcoupon as m on m.id=v.' . $this::MCOUPON_ID)
            ->field($fields)
            ->where($map)
            ->select();
        if (!empty($coupon)) {
            $temp = array();
            foreach ($coupon as &$value) {
                $value['coupon_choice_type'] = 2;//商户优惠券
                $value['begin_time'] = date('Y-m-d', $value[$this::START_TIME]);
                $value['end_time'] = date('Y-m-d', $value[$this::END_TIME]);
                $value['reducemoney'] = round($value['reducemoney'], 2);
                $value['needmoney'] = round($value['needmoney'], 2);
                if ($value[$this::CAN_USE_STORE_IDS] != 0) {
                    //限制了使用门店
                    $canUseStore = explode(',', trim($value[$this::CAN_USE_STORE_IDS], ','));
                    if (in_array($store_id, $canUseStore)) {
                        $temp[] = $value;
                    }
                } else {
                    $temp[] = $value;
                }
            }
            if (!empty($temp)) {
                return $temp;
            } else {
                return false;
            }
        } else {
            return false;
        }
    }


    //发放记录
    public function getGrantRecord($where, $fields, $order, $page, $limit)
    {
        $list = $this->alias('r')
            ->join('ls_retail_mcoupon as c on c.id=r.mcouponid')
            ->join('ls_retail_vip as v on r.vid=v.id')
            ->field($fields)
            ->where($where)
            ->order($order)
            ->page($page, $limit)
            ->select();
        return $list;
    }

    //发放记录
    public function getGrantRecordCount($where)
    {
        $count = $this->alias('r')
            ->join('ls_retail_mcoupon as c on c.id=r.mcouponid')
            ->join('ls_retail_vip as v on r.vid=v.id')
            ->where($where)
            ->count();
        return $count;
    }


    /**
     * 会员优惠券记录
     * @param $where
     * @param $fields
     * @param $order
     * @param $page
     * @param $limit
     * @return mixed
     */
    public function getVipCouponList($where, $fields, $order = 'c.id desc', $page = '', $limit = '')
    {
        if (!empty($page) && !empty($limit)) {
            $list = $this->alias('r')
                ->join('ls_retail_mcoupon as c on r.mcouponid=c.id')
                ->field($fields)
                ->where($where)
                ->order($order)
                ->page($page, $limit)
                ->select();
        } else {
            $list = $this->alias('r')
                ->join('ls_retail_mcoupon as c on r.mcouponid=c.id')
                ->field($fields)
                ->where($where)
                ->order($order)
                ->select();
        }
        return $list;
    }


    /**
     * 获取单张优惠券
     * @param $where
     * @param $fields
     * @return mixed
     */
    public function getSingleCoupon($where, $fields)
    {
        $coupon = $this->alias('r')
            ->join('ls_retail_mcoupon as c on c.id=r.mcouponid')
            ->field($fields)
            ->where($where)
            ->find();
        return $coupon;
    }
}