<?php
namespace Home\Model;
use Think\Model;
/**
* 优惠券模块
* @author fish
*
*/
class VoucherModel {
public function checkUserCanGetOneVoucher( $voucher_id,$user_id,$check_count =false , $is_admin = false)
{
if($user_id <= 0)
{
return 4;
}
$voucher_info = M('lionfish_comshop_coupon')->where( array('id' => $voucher_id) )->find();
if($voucher_info['total_count'] !=-1 && $voucher_info['total_count'] <= $voucher_info['send_count']){
return 1;//被抢光了
}
if(!$is_admin)
{
if($check_count) {
if($voucher_info['total_count'] !=-1 && $voucher_info['total_count'] <= $voucher_info['send_count']){
return 1;//被抢光了
}else {
$get_count = M('lionfish_comshop_coupon_list')->where( array('voucher_id' => $voucher_id , 'user_id' => $user_id ) )->count();
if($voucher_info['person_limit_count'] > 0 && $voucher_info['person_limit_count'] <= $get_count) {
return 2;//已领过
}
}
}
//判断是否是新人专享的优惠券
if( $voucher_info['is_new_man'] == 1 )
{
//检测是否购买过
$od_status = "1,2,4,6,7,8,9,10,11,12,14";
$buy_count = M('lionfish_comshop_order')->where(" order_status_id in ({$od_status}) and member_id=".$user_id )->count();
if( !empty($buy_count) && $buy_count >0 )
{
return 4;
}
}
}
return 0;
}
public function send_user_voucher_byId($voucher_id,$user_id,$check_count =false, $is_admin = false)
{
if($user_id <= 0)
{
return 4;
}
$voucher_info = M('lionfish_comshop_coupon')->where( array('id' => $voucher_id) )->find();
if($voucher_info['total_count'] !=-1 && $voucher_info['total_count'] <= $voucher_info['send_count']){
return 1;//被抢光了
}
if(!$is_admin)
{
if($check_count) {
if($voucher_info['total_count'] !=-1 && $voucher_info['total_count'] <= $voucher_info['send_count']){
return 1;//被抢光了
}else {
$get_count = M('lionfish_comshop_coupon_list')->where( array('voucher_id' => $voucher_id , 'user_id' => $user_id ) )->count();
if($voucher_info['person_limit_count'] > 0 && $voucher_info['person_limit_count'] <= $get_count) {
return 2;//已领过
}
}
}
//判断是否是新人专享的优惠券
if( $voucher_info['is_new_man'] == 1 )
{
//检测是否购买过
$od_status = "1,2,4,6,7,8,9,10,11,12,14";
$buy_count = M('lionfish_comshop_order')->where(" order_status_id in ({$od_status}) and member_id=".$user_id )->count();
if( !empty($buy_count) && $buy_count >0 )
{
return 4;
}
}
}
//开始生产优惠券
$begin_time = $voucher_info['begin_time'];
$end_time = $voucher_info['end_time'];
if( $voucher_info['timelimit'] == 0)
{
$begin_time = time();
$end_time = time() + 3600 * $voucher_info['get_over_hour'];
}
$voucher = array(
'voucher_id' => $voucher_id,
'voucher_title' => $voucher_info['voucher_title'],
'user_id' => $user_id,
'store_id' => 0,
'type' => $voucher_info['type'],
'credit' => $voucher_info['credit'],
'limit_money' => $voucher_info['limit_money'],
'is_limit_goods_buy' => $voucher_info['is_limit_goods_buy'],
'limit_goods_list' => $voucher_info['limit_goods_list'],
'goodscates' => $voucher_info['goodscates'],
'consume' => 'N',
'begin_time' => $begin_time,
'end_time' => $end_time,
'add_time'=>time(),
);
//user_id
$id = M('lionfish_comshop_coupon_list')->add( $voucher );
if($id){
M()->execute("update ".C('DB_PREFIX')."lionfish_comshop_coupon set send_count=send_count+1 where id =".$voucher_id );
}
return 3;//领取成功
}
/**
优惠券活动页面领券
**/
public function send_user_voucher_byId_frombonus($voucher_id,$user_id,$check_count =false,$is_double = false)
{
$voucher_info = M('voucher')->where( array('id' => $voucher_id) )->find();
if($check_count) {
if($voucher_info['total_count'] <= $voucher_info['send_count']){
return -1;//被抢光了
}else {
$get_count = M('voucher_list')->where( "voucher_id={$voucher_id} and user_id={$user_id} " )->count();
if($voucher_info['person_limit_count'] > 0 && $voucher_info['person_limit_count'] <= $get_count) {
return -2;//已领过
}
}
}
$voucher_list_one = M('voucher_list')->where( array('voucher_id' =>$voucher_id,'user_id' =>0 ) )->order('id desc')->find();
if($voucher_list_one){
$credit = $voucher_list_one['credit'];
//get_over_hour
if($is_double)
{
$credit = 2 * $voucher_list_one['credit'];
}
$end_time = $voucher_list_one['end_time'];
if( $voucher_info['get_over_hour'] > 0)
{
$end_time = time() + intval(3600 * $voucher_info['get_over_hour']);
}
M('voucher')->where( array('id' => $voucher_id) )->setInc('send_count');
M('voucher_list')->where( array('id' => $voucher_list_one['id']) )->save( array('user_id' => $user_id,'end_time' => $end_time ,'credit' => $credit) );
}
return $voucher_list_one['id'];//领取成功
}
/**
* 获取用户可用给当前店铺商品支付的优惠券
* @param unknown $user_id
* @param unknown $store_id
* @param unknown $total_money
*/
public function get_user_canpay_voucher($user_id,$store_id,$total_money, $uniacid = '',$goods_ids = array())
{
//ims_
$voucher_list = M()->query("select * from ".C('DB_PREFIX')."lionfish_comshop_coupon_list
where (is_limit_goods_buy = 0 and (limit_money = 0 or (limit_money<=".$total_money.") ) ) and (store_id=".$store_id." or store_id=0) and user_id=".$user_id." and consume='N' and begin_time<".time().' and end_time >'.time() );
//-----------
//var_dump( $voucher_list );
//die();
if( empty($voucher_list) )
{
$voucher_list = array();
}
//判断是否有限制商品的券
$voucher_list_goods = M('lionfish_comshop_coupon_list')->where( "is_limit_goods_buy = 1 and (store_id={$store_id} or store_id=0) and user_id={$user_id} and consume='N' and begin_time<".time().' and end_time >'.time() )->select();
if( !empty($voucher_list_goods) )
{
foreach($voucher_list_goods as $gd_quan)
{
if( empty($gd_quan['limit_goods_list']) )
{
//(limit_money = 0 or (limit_money<=:total_money) )
if($gd_quan['limit_money'] ==0 || $gd_quan['limit_money'] <= $total_money)
{
$voucher_list[] = $gd_quan;
}
}else{
$voucher_goods_ids = explode(',', $gd_quan['limit_goods_list']);
$voucher_goods_ids_total_money = 0;
$is_in = false;
foreach($goods_ids as $key_goods_id => $money_goods_id)
{
if( in_array($key_goods_id, $voucher_goods_ids ) )
{
$voucher_goods_ids_total_money += $money_goods_id;
$is_in = true;
}
}
if( $is_in && $voucher_goods_ids_total_money >= $gd_quan['limit_money'] )
{
$voucher_list[] = $gd_quan;
}
}
}
}
//判断是否有限制商品分类的券
$voucher_list_cate = M('lionfish_comshop_coupon_list')->where( "is_limit_goods_buy = 2 and (store_id={$store_id} or store_id=0) and user_id={$user_id} and consume='N' and begin_time<".time().' and end_time >'.time() )->select();
if( !empty($voucher_list_cate) )
{
foreach($voucher_list_cate as $gd_quan)
{
if( empty($gd_quan['goodscates']) )
{
if($gd_quan['limit_money'] ==0 || $gd_quan['limit_money'] <= $total_money)
{
$voucher_list[] = $gd_quan;
}
}else{
$voucher_goods_cate = $gd_quan['goodscates'];
$voucher_goods_ids_total_money = 0;
$is_in = false ;
foreach($goods_ids as $key_goods_id => $money_goods_id)
{
$cate_gd_arr = M('lionfish_comshop_goods_to_category')->field('cate_id')->where( array('goods_id' => $key_goods_id) )->select();
if( !empty($cate_gd_arr) )
{
foreach($cate_gd_arr as $cate_val)
{
if( $cate_val['cate_id'] == $voucher_goods_cate )
{
$is_in = true;
$voucher_goods_ids_total_money += $money_goods_id;
}
}
}
}
if($is_in && $voucher_goods_ids_total_money >= $gd_quan['limit_money'] )
{
$voucher_list[] = $gd_quan;
}
}
}
}
//---------------
if( !empty($voucher_list) )
{
foreach($voucher_list as $key => $val)
{
$val['begin_time'] = date('Y-m-d H:i:s', $val['begin_time']);
$val['end_time'] = date('Y-m-d H:i:s', $val['end_time']);
//---begin
$coupon_info = M('lionfish_comshop_coupon')->where( array('id' =>$val['voucher_id'] ) )->find();
if( $coupon_info['catid'] > 0 )
{
$cate_info = M('lionfish_comshop_coupon_category')->where( array('id' => $coupon_info['catid']) )->find();
$val['cate_name'] = $cate_info['name'];
}else{
$val['cate_name'] = '';
}
//--end
$voucher_list[$key] = $val;
}
}
//credit
$last_index_sort = array_column($voucher_list, 'credit');
array_multisort($last_index_sort, SORT_DESC, $voucher_list);
return $voucher_list;
}
/**
* @author cy 2021-01-03
* @desc 获取优惠券最大可以优惠金额
* @param unknown $vouche_list 优惠券列表
* @param unknown $goods 购买商品列表
* @param unknown $reduce_money 满级金额
* @return number
*/
public function get_voucher_amout_bygoods($vouche_list, $goods, $reduce_money){
$order_total = 0;
foreach($goods as $k=>$v){
$order_total = $order_total + round($v['price']*$v['quantity'],2);
}
if(!empty($vouche_list)){
foreach($vouche_list as $vk=>$vv){
$vouche_amount = 0;//优惠券优惠总金额
$limit_money = $vv['limit_money'];
if(empty($limit_money)){
$limit_money = 0;
}
$goods_amount = 0;
if($vv['is_limit_goods_buy'] == 0){//所有商品
foreach($goods as $k=>$v){
if($v['level_total'] > 0){
$goods_amount = $goods_amount + $v['level_total'];
}else{
$goods_amount = $goods_amount + $v['total'];
}
}
}else if($vv['is_limit_goods_buy'] == 1){//指定商品
$goods_array = explode(',', $vv['limit_goods_list']);
foreach($goods as $k=>$v){
if(in_array($v['goods_id'], $goods_array)){
if($v['level_total'] > 0){
$goods_amount = $goods_amount + $v['level_total'];
}else{
$goods_amount = $goods_amount + $v['total'];
}
}
}
}else if($vv['is_limit_goods_buy'] == 2){//指定商品分类
$goodscates = $vv['goodscates'];
foreach($goods as $k=>$v){
$goods_id = $v['goods_id'];
$cate_gd_arr = M('lionfish_comshop_goods_to_category')->field('cate_id')->where( array('goods_id' => $goods_id) )->select();
if( !empty($cate_gd_arr) )
{
foreach($cate_gd_arr as $cate_val)
{
if( $cate_val['cate_id'] == $goodscates )
{
if($v['level_total'] > 0){
$goods_amount = $goods_amount + $v['level_total'];
}else{
$goods_amount = $goods_amount + $v['total'];
}
}
}
}
}
}
if($goods_amount >= $limit_money){
if($goods_amount >= $vv['credit']){
$vouche_amount = $vv['credit'];
}else{
$vouche_amount = $goods_amount;
}
if($vouche_amount > $order_total - $reduce_money){
$vouche_amount = $order_total - $reduce_money;
}
}
$vouche_list[$vk]['can_vouche_amount'] = $vouche_amount;
}
}
return $vouche_list;
}
/**
* @author cy 2021-03-12
* @desc 邀新有礼送优惠券
* @param $voucher_id
* @param $user_id
* @param $invite_id
* @param $receive_type
* @return int
*/
public function send_invitegift_coupon_byId($voucher_id ,$user_id, $invite_id ,$receive_type)
{
if($user_id <= 0)
{
return ['code'=>4];
}
$voucher_info = M('lionfish_comshop_coupon')->where( array('id' => $voucher_id) )->find();
if($voucher_info['total_count'] !=-1 && $voucher_info['total_count'] <= $voucher_info['send_count']){
return ['code'=>1];//被抢光了
}else {
$get_count = M('lionfish_comshop_coupon_list')->where( array('voucher_id' => $voucher_id , 'user_id' => $user_id ) )->count();
if($voucher_info['person_limit_count'] > 0 && $voucher_info['person_limit_count'] <= $get_count) {
return ['code'=>2];//已领过
}
}
//判断是否是新人专享的优惠券
if( $voucher_info['is_new_man'] == 1 )
{
//检测是否购买过
$od_status = "1,2,4,6,7,8,9,10,11,12,14";
$buy_count = M('lionfish_comshop_order')->where(" order_status_id in ({$od_status}) and member_id=".$user_id )->count();
if( !empty($buy_count) && $buy_count >0 )
{
return ['code'=>3];//不是新人
}
}
//开始生产优惠券
$begin_time = $voucher_info['begin_time'];
$end_time = $voucher_info['end_time'];
if( $voucher_info['timelimit'] == 0)
{
$begin_time = time();
$end_time = time() + 3600 * $voucher_info['get_over_hour'];
}
$voucher = array(
'voucher_id' => $voucher_id,
'voucher_title' => $voucher_info['voucher_title'],
'user_id' => $user_id,
'store_id' => 0,
'type' => $voucher_info['type'],
'credit' => $voucher_info['credit'],
'limit_money' => $voucher_info['limit_money'],
'is_limit_goods_buy' => $voucher_info['is_limit_goods_buy'],
'limit_goods_list' => $voucher_info['limit_goods_list'],
'goodscates' => $voucher_info['goodscates'],
'consume' => 'N',
'begin_time' => $begin_time,
'end_time' => $end_time,
'receive_type' => $receive_type,
'receive_id' => $invite_id,
'add_time'=>time(),
);
//user_id
$id = M('lionfish_comshop_coupon_list')->add( $voucher );
if($id){
M()->execute("update ".C('DB_PREFIX')."lionfish_comshop_coupon set send_count=send_count+1 where id =".$voucher_id );
}
return ['code' => 0, 'id'=> $id];//领取成功
}
}