123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184 |
- <?php
- namespace app\models\store;
- use crmeb\basic\BaseModel;
- use crmeb\traits\ModelTrait;
- use think\db\Where;
- class StoreCouponIssue extends BaseModel
- {
-
- protected $pk = 'id';
-
- protected $name = 'store_coupon_issue';
- use ModelTrait;
- public function used()
- {
- return $this->hasOne(StoreCouponIssueUser::class, 'issue_coupon_id', 'id')->field('issue_coupon_id');
- }
- public static function getIssueCouponList($uid, $limit, $page = 0, $type = 0, $product_id = 0)
- {
- $model1 = self::validWhere('A')->alias('A')
- ->join('store_coupon B', 'A.cid = B.id')
- ->field('A.*,B.type,B.coupon_price,B.use_min_price,B.title')
- ->order('B.sort DESC,A.id DESC');
- $model2 = self::validWhere('A')->alias('A')
- ->join('store_coupon B', 'A.cid = B.id')
- ->field('A.*,B.type,B.coupon_price,B.use_min_price,B.title')
- ->order('B.sort DESC,A.id DESC');
- $model3 = self::validWhere('A')->alias('A')
- ->join('store_coupon B', 'A.cid = B.id')
- ->field('A.*,B.type,B.coupon_price,B.use_min_price,B.title')
- ->order('B.sort DESC,A.id DESC');
- if ($uid) {
- $model1->with(['used' => function ($query) use ($uid) {
- $query->where('uid', $uid);
- }]);
- $model2->with(['used' => function ($query) use ($uid) {
- $query->where('uid', $uid);
- }]);
- $model3->with(['used' => function ($query) use ($uid) {
- $query->where('uid', $uid);
- }]);
- }
- $lst1 = $lst2 = $lst3 = [];
- if ($type) {
- if ($product_id) {
-
- $lst1 = $model1->where('B.type', 2)
- ->where('is_give_subscribe', 0)
- ->where('is_full_give', 0)
- ->whereFindinSet('B.product_id', $product_id)
- ->select()
- ->hidden(['is_del', 'status'])
- ->toArray();
-
- $cate_id = StoreProduct::where('id', $product_id)->value('cate_id');
- $category = explode(',', $cate_id);
- foreach ($category as $value) {
- $temp[] = StoreCategory::where('id', $value)->value('pid');
- }
- $temp = array_unique($temp);
- $cate_id = $cate_id . ',' . implode(',', $temp);
- $lst2 = $model2->where('B.type', 1)
- ->where('is_give_subscribe', 0)
- ->where('is_full_give', 0)
- ->where('B.category_id', 'in', $cate_id)
- ->select()
- ->hidden(['is_del', 'status'])
- ->toArray();
- }
- } else {
-
- $lst3 = $model3->where('B.type', 0)
- ->where('is_give_subscribe', 0)
- ->where('is_full_give', 0)
- ->select()
- ->hidden(['is_del', 'status'])
- ->toArray();
- }
- $list = array_merge($lst1, $lst2, $lst3);
- $list = array_unique_fb($list);
- if ($page) $list = array_slice($list, ((int)$page - 1) * $limit, $limit);
- foreach ($list as $k => $v) {
- $v['is_use'] = $uid ? isset($v['used']) : false;
- if (!$v['end_time']) {
- $v['start_time'] = '';
- $v['end_time'] = '不限时';
- } else {
- $v['start_time'] = date('Y/m/d', $v['start_time']);
- $v['end_time'] = $v['end_time'] ? date('Y/m/d', $v['end_time']) : date('Y/m/d', time() + 86400);
- }
- $v['coupon_price'] = (int)$v['coupon_price'];
- $list[$k] = $v;
- }
- if ($list)
- return $list;
- else
- return [];
- }
-
- public static function validWhere($prefix = '')
- {
- $model = new self;
- if ($prefix) {
- $model->alias($prefix);
- $prefix .= '.';
- }
- $newTime = time();
- return $model->where("{$prefix}status", 1)
- ->where(function ($query) use ($newTime, $prefix) {
- $query->where(function ($query) use ($newTime, $prefix) {
- $query->where("{$prefix}start_time", '<', $newTime)->where("{$prefix}end_time", '>', $newTime);
- })->whereOr(function ($query) use ($prefix) {
- $query->where("{$prefix}start_time", 0)->where("{$prefix}end_time", 0);
- });
- })->where("{$prefix}is_del", 0)->where("{$prefix}remain_count > 0 OR {$prefix}is_permanent = 1");
- }
- public static function issueUserCoupon($id, $uid)
- {
- $issueCouponInfo = self::validWhere()->where('id', $id)->find();
- if (!$issueCouponInfo) return self::setErrorInfo('领取的优惠劵已领完或已过期!');
- if (StoreCouponIssueUser::be(['uid' => $uid, 'issue_coupon_id' => $id]))
- return self::setErrorInfo('已领取过该优惠劵!');
- if ($issueCouponInfo['remain_count'] <= 0 && !$issueCouponInfo['is_permanent']) return self::setErrorInfo('抱歉优惠卷已经领取完了!');
- self::beginTrans();
- $res1 = false != StoreCouponUser::addUserCoupon($uid, $issueCouponInfo['cid']);
- $res2 = false != StoreCouponIssueUser::addUserIssue($uid, $id);
- $res3 = true;
- if ($issueCouponInfo['total_count'] > 0) {
- $issueCouponInfo['remain_count'] -= 1;
- $res3 = false !== $issueCouponInfo->save();
- }
- $res = $res1 && $res2 && $res3;
- self::checkTrans($res);
- return $res;
- }
-
- public static function getIssueCouponTitle($id)
- {
- $cid = self::where('id', $id)->value('cid');
- return StoreCoupon::where('id', $cid)->value('title');
- }
- }
|