extension=php_igbinary.dll
extension=php_redis.dll

?php
namespace app\index\controller;
use think\Controller;
use think\Db;
use think\cache\driver\Redis;

class Miaosha extends Controller
{

 private $redis = null;
 private $cachekey = null; //緩存變量名
 private $basket = []; //私有數(shù)組，存放商品信息

 private $store = 50;

 /**
 * 購(gòu)物車初始化，傳入用戶id
 */
 public function __construct()
 {
 parent::__construct();

 $this->redis = new \Redis(); // 實(shí)例化
 $this->redis->connect('127.0.0.1','6379');
 $this->redis->auth('zxf123456');

 }

 /**
 * 秒殺初始化
 */
 public function Ms_init()
 {
 // 刪除緩存列表
 $this->redis->del($this->cachekey);

 $len = $this->redis->llen($this->cachekey);
 $count = $this->store - $len;

 for ($i=0; $i  $count; $i++) { 

 // 向庫(kù)存列表推進(jìn)50個(gè),模擬50個(gè)商品庫(kù)存
 $this->redis->lpush($this->cachekey,1);
 }

 echo "庫(kù)存初始化完成:".$this->redis->llen($this->cachekey);
 }
 

 /**
 * 秒殺入口
 */
 public function index()
 {
 $id = 1; //商品編號(hào)
 
 if (empty($id)) {
 // 記錄失敗日志
 return $this->writeLog(0,'商品編號(hào)不存在'); 
 }

 // 計(jì)算庫(kù)存列表長(zhǎng)度
 $count = $this->redis->llen($this->cachekey);

 // 先判斷庫(kù)存是否為0,為0秒殺失敗,不為0,則進(jìn)行先移除一個(gè)元素,再進(jìn)行數(shù)據(jù)庫(kù)操作
 if ($count == 0) { //庫(kù)存為0

 $this->writeLog(0,'庫(kù)存為0');
 echo "庫(kù)存為0";
 exit;

 }else{
 // 有庫(kù)存
 //先移除一個(gè)列表元素
 $this->redis->lpop($this->cachekey);

 $ordersn = $this->build_order_no(); //生成訂單
 $uid = rand(0,9999); //隨機(jī)生成用戶id
 $status = 1;
 // 再進(jìn)行數(shù)據(jù)庫(kù)操作
 $data = Db::table('ab_goods')->field('count,amount')->where('id',$id)->find(); //查找商品

 if (!$data) {
 return $this->writeLog(0,'該商品不存在');
 }

 $insert_data = [
 'order_sn' => $ordersn,
 'user_id' => $uid,
 'goods_id' => $id,
 'price' => $data['amount'],
 'status' => $status,
 'addtime' => date('Y-m-d H:i:s')
 ];

 // 訂單入庫(kù)
 $result = Db::table('ab_order')->insert($insert_data);
 // 自動(dòng)減少一個(gè)庫(kù)存
 $res = Db::table('ab_goods')->where('id',$id)->setDec('count');

 if ($res) {
 echo "第".$count."件秒殺成功";
 $this->writeLog(1,'秒殺成功');
 }else{
 echo "第".$count."件秒殺失敗";
 $this->writeLog(0,'秒殺失敗');
 }
 }
 }

 /**
 * 生成訂單號(hào)
 */
 public function build_order_no()
 {
 return date('ymd').substr(implode(NULL, array_map('ord', str_split(substr(uniqid(), 7, 13), 1))), 0, 8);
 }

 /**
 * 生成日志 1成功 0失敗
 */
 public function writeLog($status = 1,$msg)
 {
 $data['count'] = 1;
 $data['status'] = $status;
 $data['addtime'] = date('Y-m-d H:i:s');
 $data['msg'] = $msg;
 return Db::table('ab_log')->insertGetId($data);
 }

}

public function sqlMs()
 {
 $id = 1; //商品編號(hào)

 $count = 50;
 $ordersn = $this->build_order_no(); //生成訂單
 $uid = rand(0,9999); //隨機(jī)生成用戶id
 $status = 1;
 // 再進(jìn)行數(shù)據(jù)庫(kù)操作
 $data = Db::table('ab_goods')->field('count,amount')->where('id',$id)->find(); //查找商品

 // 查詢還剩多少庫(kù)存
 $rs = Db::table('ab_goods')->where('id',$id)->value('count');
 if ($rs = 0) {
 
 $this->writeLog(0,'庫(kù)存為0');
 }else{

 $insert_data = [
 'order_sn' => $ordersn,
 'user_id' => $uid,
 'goods_id' => $id,
 'price' => $data['amount'],
 'status' => $status,
 'addtime' => date('Y-m-d H:i:s')
 ];

 // 訂單入庫(kù)
 $result = Db::table('ab_order')->insert($insert_data);
 // 自動(dòng)減少一個(gè)庫(kù)存
 $res = Db::table('ab_goods')->where('id',$id)->setDec('count');

 if ($res) {
 echo "第".$data['count']."件秒殺成功";
 $this->writeLog(1,'秒殺成功');
 }else{
 echo "第".$data['count']."件秒殺失敗";
 $this->writeLog(0,'秒殺失敗');
 }
 }
 }