在項目開發中經常會遇到花錢抽獎類型的需求。但是老闆總是擔心用戶用小錢抽到大獎。這樣會導致項目虧損。下邊這段代碼可以有效制止抽獎項目虧錢。 個人獎池: 語言:thinkphp redis mysql 表:desire抽獎商品表 desire_log用戶抽獎獎品表 user_desire_log用戶抽獎 ...
在項目開發中經常會遇到花錢抽獎類型的需求。但是老闆總是擔心用戶用小錢抽到大獎。這樣會導致項目虧損。下邊這段代碼可以有效制止抽獎項目虧錢。
個人獎池:
語言:thinkphp redis mysql
表:desire抽獎商品表 desire_log用戶抽獎獎品表 user_desire_log用戶抽獎記錄表 desire_risk抽獎風控表
需求:用戶獎池分為進行中獎池 和已完成獎池 當用戶抽到大獎後 用戶個人獎池重置 否則將繼續抽獎 最後一次抽獎必中大獎 通過風控金額來判斷用戶是否可以抽大獎
當所有用戶已完成的抽獎 盈利大於風控金額的時候可以讓用戶抽大獎 否則用戶抽不到大獎
<?php //抽獎介面 public function desire() { $userData = $this->userSessionData();///用戶的唯一標識 $time = time(); $this->limit_reward_time($userData['id'], $time);///限制抽獎間隔時間 防止被惡意刷獎品 //活動開啟開關 $num = input('num/d'); if (!$num) { output('1008', '參數錯誤'); } if ($num!=1){ if ($num !=10){ if ($num !=100){ output('1008', '參數錯誤'); }else{ $send = $this->draw($num); } }else{ $send = $this->draw($num); } }else{ $send = $this->draw($num); } if ($send != '金幣不足') { output('200', '列表', $send); } else { output('1012', $send); } } /////抽獎核心 public function draw($num) { $userData = $this->userSessionData(); $resultSend = Cache::get('獎池名稱加上用戶的唯一標識,確保一人一獎池' . $userData['id']);//獲取個人獎池 if (!empty($resultSend)) { $userRedis = unserialize(Cache::get('newdesiredraw' . $userData['id']));///將獎池序列化 } else { $userRedis = '';///當前用戶不存在獎池 } ///查詢當前用戶的金幣 $desireDiamonds = Db::connect('db_qmconfig')->name('user_money')->where(['uid' => $userData['id']])->field('diamonds')->find(); $sendNum = $num; if ($desireDiamonds['diamonds'] < $num) { return ['msg' => '金幣不足'];///判斷當前用戶的金幣是不是夠抽獎 } $gift_height = 0;///檢測是否更新個人獎池和抽獎數量 $newNum = 0;///檢測下一輪抽獎數量 $suiji = Db::connect('db_qmconfig')->name('desire')->order('num desc')->find();///隨機小禮物 if ($userRedis) {///如果用戶獎池存在 $joins = [ ['gift_info f', 'd.giftid = f.id'] ]; $gift = Db::connect('db_qmconfig')->name('desire') ->alias('d') ->join($joins) ->where(['d.state' => 1]) ->order('f.price desc') ->field('f.name,f.price,f.egif,d.num,f.id,d.position')->find(); ///查詢抽獎表的禮物 if (!$gift){ return ['msg'=>'禮物查詢錯誤']; } ///查詢用戶的總抽獎數量 $user_all = Db::connect('db_qmconfig')->name('user_desire_log')->order('kind desc') ->where(['uid'=>$userData['id'],'state'=>0])->field('SUM(num) as kindNum')->find(); //十次抽獎 必中 $count = count($userRedis); if ($num == 10) { $where[] = ['d.state', '=', 1]; $where[] = ['d.ten', '=', 1]; $giftId = $this->giftInfo($where); if ($giftId) { $result[] = $giftId[0]['id']; } $num = $num - 1; } ///百次抽獎 必中 if ($num == 100) { $where[] = ['d.state', '=', 1]; $where[] = ['d.hundred', '=', 1]; $giftId = $this->giftInfo($where); $lwhere[] = ['d.state', '=', 1]; $lwhere[] = ['d.ten', '=', 1]; $lgiftId = $this->giftInfo($lwhere); if ($lgiftId) { for ($l=0;$l<10;$l++){ $result[] = $lgiftId[0]['id']; } } if ($giftId) { $result[] = $giftId[0]['id']; } $num = $num - 11; } if ($num ==1){ if ($user_all){ $number1 = ''; $num1 = str_split($user_all['kindNum']); $number = $num1[count($num1) - 1]; if ($user_all['kindNum']>98){ $number1 = $num1[count($num1) - 2]; } if (($number==9)&& ($number1 !=9)){ //十抽必中 $where[] = ['d.state', '=', 1]; $where[] = ['d.ten', '=', 1]; $giftId = $this->giftInfo($where); if ($giftId) { $result[] = $giftId[0]['id']; } $num = $num - 1; } if (($number1==9) && ($number==9)){//百抽必中 $where[] = ['d.state', '=', 1]; $where[] = ['d.hundred', '=', 1]; $giftId = $this->giftInfo($where); if ($giftId) { $result[] = $giftId[0]['id']; } $num = $num - 1; } } } ////判斷當前獎池的獎品是否夠此次抽獎 如果獎池獎品數量不夠此次抽獎 將此次獎池抽完後 獲取剩下要抽將的數量 重置獎池 並且遞歸此方法傳入剩下要抽的數量 if ($count < $num) { $newNum = $num - $count; $num = $count; } $user = Db::connect('db_qmconfig') ->name('desire_log')->where(['uid' => $userData['id']]) ->field('SUM(num) as num') ->find();///已抽數量 if (!$user){ return ['msg'=>'已抽數量有誤']; } $res['zongshu'] = Db::connect('db_qmconfig') ->name('desire')->where(['state' => 1]) ->field('SUM(num) as num,checksum') ->find();///總數量 if (!$res['zongshu']){ return ['msg'=>'總數量有誤']; } $resNum = 0; ////獲取個人多少次抽獎 if (($user['num']+$sendNum) > $res['zongshu']['checksum']) { $res['zongshu']['user_num'] = $user['num'] % $res['zongshu']['checksum']; ///獲取餘數 if (($res['zongshu']['user_num'] + $sendNum) > $res['zongshu']['checksum']) { ///獲取這次抽獎的數量 $resNum = $sendNum - (($res['zongshu']['user_num'] + $sendNum) - $res['zongshu']['checksum']); } // return ['msg'=>$res['zongshu']['user_num']]; }else{ $res['zongshu']['user_num'] = $user['num']; } $cruuy = 0; ///隨機選擇獎池 for ($i = 0; $i < $num; $i++) { $send = array_rand($userRedis); if ($resNum > 0) { ///如果本輪獎池抽完 並且沒有抽到大獎 那麼必中大獎 $result[] = $gift['id']; $gift_height = 1;//抽到大獎後更改三個變數狀態 $resNum=0; $cruuy = 1; } else { if ($userRedis[$send]==$gift['id']){ $haveJoin = [ ['desire_log d', 'd.cid = u.id'], ['gift_info f', 'd.giftid = f.id'] ]; $all = Db::connect('db_qmconfig') ->name('user_desire_log') ->alias('u') ->where(['u.state'=>1]) ->field('SUM(u.num) as num')->find(); // var_dump($all); ///如果抽到大獎 if ($all['num']==null){ ///如果這是整個獎池第一輪抽獎 那麼可以中大獎 $result[] = $suiji['giftid']; }else{ $alls = Db::connect('db_qmconfig')->name('user_desire_log') ->alias('u') ->where(['u.state'=>1]) ->join($haveJoin) ->field('SUM(f.price*d.num) as num')->find(); ///查詢獎池風控金額 $reskList = Db::connect('db_qmconfig')->name('desire_risk')->find(); $riskPrice = $all['num'] * 20 - $alls['num']; ///如果風控金額小於當前已完成抽獎的金額 那麼代表軟體處於盈利狀態 可以中大獎 if (($riskPrice >= $reskList['price'])&&($cruuy==0)){ $result[] = $userRedis[$send]; $gift_height = 1; $cruuy = 1; } else{ ///如果風控金額大於當前已完成抽獎金額 不能中大獎 隨機選擇一次小獎品 替換大獎 $result[] = $suiji['giftid']; } } }else{ $result[] = $userRedis[$send]; } } ///清空個人獎池此次抽獎的禮物 unset($userRedis[$send]); } ////新增用戶抽獎次數 $result = array_count_values($result); $user_desire_list = Db::connect('db_qmconfig')->name('user_desire_log')->order('id desc')->where(['uid'=>$userData['id']])->find(); if ($user_desire_list){ if ($user_desire_list['state']==0){ $user_desire_logData[ 'kind'] = $user_desire_list['kind']+1; }else{ $user_desire_logData[ 'kind'] = 1; } }else{ $user_desire_logData[ 'kind'] = 1; } $user_desire_logData['uid'] =$userData['id']; $user_desire_logData['ctime'] =time(); $user_desire_logData['num'] =$sendNum; ////更改此輪抽獎後 用戶獎池的狀態 if ($gift_height==1){ $user_desire_log_update = Db::connect('db_qmconfig')->name('user_desire_log') ->where(['uid'=>$userData['id'],'state'=>0])->update(['state'=>1]); $user_desire_logData[ 'state'] = 1; }else{ $user_desire_logData[ 'state'] = 0; } $user_desire_log = Db::connect('db_qmconfig')->name('user_desire_log')->insertGetId($user_desire_logData); foreach ($result as $k => $v) { if ($resNum == ($k + 1)) { ///如果這次抽獎大於獎池總數 那麼更新獎池並且抽獎剩下的次數 Cache::set('newdesiredraw' . $userData['id'], serialize([])); return $this->draw($sendNum - ($k + 1)); } ////禮物新增用戶背包 $data = [ 'uid' => $userData['id'], 'giftid' => $k, 'num' => $v, 'ctime' => time(), 'cid' => $user_desire_log ]; $join = [ ['gift_info f', 'd.giftid = f.id'] ]; $gift_info = Db::connect('db_qmconfig')->name('desire') ->alias('d') ->join($join) ->where(['d.giftid' => $k]) ->field('f.name,f.egif,d.position')->find(); $gift_infonum['num'] = $v; $list['gift'][] = array_merge($gift_info, $gift_infonum); $desireLog = Db::connect('db_qmconfig')->name('desire_log')->insert($data); $userKnapsack = Db::connect('db_qmconfig')->name('gift_knapsack')->where(['uid' => $userData['id'], 'giftid' => $k])->field('id,num')->find(); if ($userKnapsack) { $userKnapsackData = [ 'num' => $v + $userKnapsack['num'], 'updatetime' => time() ]; $userKnapsackUpdate = Db::connect('db_qmconfig')->name('gift_knapsack')->where(['id' => $userKnapsack['id']])->update($userKnapsackData); } else { $userKnapsackData = [ 'num' => $v, 'giftid' => $k, 'uid' => $userData['id'], 'createtime' => time() ]; $userKnapsackInsert = Db::connect('db_qmconfig')->name('gift_knapsack')->insert($userKnapsackData); } } ///增加用戶消費記錄 $userXfData = [ 'uid' => $userData['id'], 'xf_price' => $sendNum, 'xf_method' => 5, 'scene' => 19, 'status' => 1, 'ctime' => time() ]; $userXf = Db::connect('db_qmconfig')->name('xfprice')->insert($userXfData); if ($desireLog && $userXf) { ///扣除用戶金幣 $newDiamondsData = [ 'diamonds' => $desireDiamonds['diamonds'] - $sendNum ]; $newDiamonds = Db::connect('db_qmconfig')->name('user_money')->where(['uid' => $userData['id']])->update($newDiamondsData); } if ($userRedis) { Cache::set('用戶獎池名稱' . $userData['id'], serialize($userRedis)); ////如果此輪抽獎抽到大獎 重置用戶個人獎池 if ($gift_height == 1) { Cache::set('用戶獎池名稱' . $userData['id'], serialize([])); $userChecksum = $res['zongshu']['checksum'] - ($res['zongshu']['user_num'] + $sendNum); $desireLogUserWhere = [ 'uid' => $userData['id'], 'giftid' => 0, 'num' => $userChecksum, 'ctime' => time(), 'cid' => $user_desire_log, ]; ///添加禮物抽中記錄 $desireLogUser = Db::connect('db_qmconfig')->name('desire_log')->insert($desireLogUserWhere); } $swhere[] = ['d.state', '=', 1]; $swhere[] = ['d.kind', '=', 1]; $res['data'] = $this->giftInfo($swhere); if (empty($res['data'])) { output('1008', '獎池更新中'); } ////獲取用戶此輪抽獎數量 返回給前端 控制獎池動畫百分比 $res['zongshu'] = Db::connect('db_qmconfig') ->name('desire')->where(['state' => 1, 'kind' => 1]) ->field('checksum as num') ->find(); $user = Db::connect('db_qmconfig') ->name('desire_log')->where(['uid' => $userData['id']]) ->field('SUM(num) as num') ->find(); $res['diamonds'] = Db::connect('db_qmconfig') ->name('user_money')->where(['uid' => $userData['id']]) ->value('diamonds'); if ($user) { if ($user['num'] > $res['zongshu']['num']) { $res['zongshu']['user_num'] = $user['num'] % $res['zongshu']['num']; } else { $res['zongshu']['user_num'] = $user['num']; } } else { $res['zongshu']['user_num'] = 0; } $list['info'] = $res; return $list; // return ['msg'=>$res['zongshu']['user_num']]; } else { ////如果當前用戶獎池抽完獎了 那麼重置此用戶獎池 $where[] = ['d.state', '=', 1]; $where[] = ['d.kind', '=', 1]; $res = $this->giftInfo($where); if (empty($res)) { return ['msg' => '獎池更新中']; } $c = []; foreach ($res as $m => $n) { ///十抽必中獎品 if ($n['ten']==1){ $n['num'] = $n['num'] - $n['checksum']/10; $giftarr = array_fill(0, $n['num']+$n['checksum']/10, $suiji['giftid']); $c = array_merge($c, $giftarr); if ($n['num']<=0){ continue; } } ///百抽必中獎品 if ($n['hundred']==1){ $n['num'] = $n['num'] - $n['checksum']/100; $giftarr = array_fill(0, $n['num']+$n['checksum']/100, $suiji['giftid']); $c = array_merge($c, $giftarr); if ($n['num']<=0){ continue; } } $giftarr = array_fill(0, $n['num'], $n['id']); $c = array_merge($c, $giftarr); } ///隨機打亂獎池 shuffle($c); Cache::set('用戶獎池名稱' . $userData['id'], serialize($c)); if ($newNum>0){ ///遞歸此方法 抽剩下的獎品 return $this->draw($newNum); } } } else { ///如果沒有獎池 生成獎池 $where[] = ['d.state', '=', 1]; $where[] = ['d.kind', '=', 1]; $res = $this->giftInfo($where); if (empty($res)) { return ['msg' => '獎池更新中']; } $c = []; foreach ($res as $m => $n) { if ($n['ten']==1){ $n['num'] = $n['num'] - $n['checksum']/10; $giftarr = array_fill(0, $n['num']+$n['checksum']/10, $suiji['giftid']); $c = array_merge($c, $giftarr); if ($n['num']<=0){ continue; } } if ($n['hundred']==1){ $n['num'] = $n['num'] - $n['checksum']/100; $giftarr = array_fill(0, $n['num']+$n['checksum']/100, $suiji['giftid']); $c = array_merge($c, $giftarr); if ($n['num']<=0){ continue; } } $giftarr = array_fill(0, $n['num'], $n['id']); $c = array_merge($c, $giftarr); } shuffle($c); Cache::set('用戶獎池名稱' . $userData['id'], serialize($c)); ///遞歸此方法抽獎 return $this->draw($num); } } ?>