zhongshen_project/addon/turntable/shop/controller/Turntable.php

<?php
/**
 * Niushop商城系统 - 团队十年电商经验汇集巨献!
 * =========================================================
 * Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
 * ----------------------------------------------
 * 官方网址: https://www.niushop.com
 * =========================================================
 */

namespace addon\turntable\shop\controller;

use app\model\games\Games;
use app\model\member\MemberLevel;
use app\shop\controller\BaseShop;

/**
 * 幸运抽奖控制器
 */
class Turntable extends BaseShop
{
    //游戏类型
    private $game_type = 'turntable';
    private $game_type_name = '幸运抽奖';
    private $game_url = '/pages_promotion/game/turntable';

    public function __construct()
    {
        $this->app_module = input('app_module', SHOP_MODULE);
        if ($this->app_module == 'store') {
            $this->initConstructInfo(); // 加载构造函数重要信息
        } else {
            parent::__construct();
        }
    }

    /*
     *  幸运抽奖活动列表
     */
    public function lists()
    {
        //获取续签信息
        if (request()->isAjax()) {

            $model = new Games();

            $condition = [
                [ 'site_id', '=', $this->site_id ],
                [ 'game_type', '=', $this->game_type ]
            ];

            $status = input('status', '');//幸运抽奖状态
            if ($status !== '') {
                $condition[] = [ 'status', '=', $status ];
            }
            //游戏活动名称
            $game_name = input('game_name', '');
            if ($game_name) {
                $condition[] = [ 'game_name', 'like', '%' . $game_name . '%' ];
            }

            $page = input('page', 1);
            $page_size = input('page_size', PAGE_LIST_ROWS);

            $start_time = input('start_time', '');
            $end_time = input('end_time', '');

            if ($start_time && !$end_time) {
                $condition[] = [ 'end_time', '>=', date_to_time($start_time) ];
            } elseif (!$start_time && $end_time) {
                $condition[] = [ 'start_time', '<=', date_to_time($end_time) ];
            } elseif ($start_time && $end_time) {
                $start_timestamp = date_to_time($start_time);
                $end_timestamp = date_to_time($end_time);
                $sql = "start_time between {$start_timestamp} and {$end_timestamp}";
                $sql .= " or end_time between {$start_timestamp} and {$end_timestamp}";
                $sql .= " or (start_time <= {$start_timestamp} and end_time >= {$end_timestamp})";
                $condition[] = [ '', 'exp', \think\facade\Db::raw($sql) ];
            }

            $list = $model->getGamesPageList($condition, $page, $page_size, 'game_id desc');
            return $list;

        } else {

            return $this->fetch("turntable/lists");
        }
    }

    /**
     * 添加活动
     */
    public function add()
    {
        if (request()->isAjax()) {
            //获取商品信息

            $game_data = [
                'site_id' => $this->site_id,
                'game_name' => input('game_name', ''),
                'game_type' => $this->game_type,
                'game_type_name' => $this->game_type_name,
                'level_id' => input('level_id', ''),
                'level_name' => input('level_name', ''),
                'points' => input('points', ''),
                'start_time' => strtotime(input('start_time', '')),
                'end_time' => strtotime(input('end_time', '')),
                'remark' => input('remark', ''),
                'winning_rate' => input('winning_rate', ''),
                'no_winning_desc' => input('no_winning_desc', ''),
                'no_winning_img' => input('no_winning_img', ''),
                'is_show_winner' => input('is_show_winner', ''),
                'join_type' => input('join_type', ''),
                'join_frequency' => input('join_frequency', '')
            ];

            $award_json = input('award_json', '');

            $model = new Games();
            return $model->addGames($game_data, $award_json);
        } else {


            //会员等级
            $member_level_model = new MemberLevel();
            $member_level_list = $member_level_model->getMemberLevelList([ [ 'site_id', '=', $this->site_id ] ], 'level_id, level_name', 'growth asc');
            $this->assign('member_level_list', $member_level_list[ 'data' ]);

            return $this->fetch("turntable/add");
        }
    }

    /**
     * 编辑活动
     */
    public function edit()
    {
        $model = new Games();
        $game_id = input('game_id');
        if (request()->isAjax()) {

            $game_data = [
                'game_id' => $game_id,
                'site_id' => $this->site_id,
                'game_name' => input('game_name', ''),
                'level_id' => input('level_id', ''),
                'level_name' => input('level_name', ''),
                'points' => input('points', ''),
                'start_time' => strtotime(input('start_time', '')),
                'end_time' => strtotime(input('end_time', '')),
                'remark' => input('remark', ''),
                'winning_rate' => input('winning_rate', ''),
                'no_winning_desc' => input('no_winning_desc', ''),
                'no_winning_img' => input('no_winning_img', ''),
                'is_show_winner' => input('is_show_winner', ''),
                'join_type' => input('join_type', ''),
                'join_frequency' => input('join_frequency', '')
            ];

            $award_json = input('award_json', '');
            $delete_award_ids = input('delete_award_ids', '');

            return $model->editGames([ [ 'site_id', '=', $this->site_id ], [ 'game_id', '=', $game_id ] ], $game_data, $award_json, $delete_award_ids);
        } else {
            //会员等级
            $member_level_model = new MemberLevel();
            $member_level_list = $member_level_model->getMemberLevelList([ [ 'site_id', '=', $this->site_id ] ], 'level_id, level_name', 'growth asc');
            $this->assign('member_level_list', $member_level_list[ 'data' ]);

            //获取游戏详情
            $info = $model->getGamesDetail($this->site_id, $game_id);
            $this->assign('info', $info[ 'data' ]);
            if (empty($info[ 'data' ])) $this->error('未获取到活动数据', addon_url('turntable://shop/turntable/lists'));
            return $this->fetch("turntable/edit");
        }
    }

    /*
     *  幸运抽奖详情
     */
    public function detail()
    {
        $turntable_model = new Games();

        $game_id = input('game_id', '');
        //获取幸运抽奖信息
        $info = $turntable_model->getGamesDetail($this->site_id, $game_id)[ 'data' ] ?? [];
        if (empty($info)) $this->error('未获取到活动数据', addon_url('turntable://shop/turntable/lists'));
        $info[ 'status_name' ] = $turntable_model->status[ $info[ 'status' ] ] ?? '';
        $this->assign('info', $info);

        return $this->fetch("turntable/detail");
    }

    /*
     *  删除幸运抽奖活动
     */
    public function delete()
    {
        $game_id = input('game_id', '');
        $site_id = $this->site_id;

        $turntable_model = new Games();
        return $turntable_model->deleteGames($site_id, $game_id);
    }

    /*
     *  结束幸运抽奖活动
     */
    public function finish()
    {
        $game_id = input('game_id', '');
        $site_id = $this->site_id;

        $turntable_model = new Games();
        return $turntable_model->finishGames($site_id, $game_id);
    }


    /*
     *  重启幸运抽奖活动
     */
    public function start()
    {
        $game_id = input('game_id', '');

        $turntable_model = new Games();
        return $turntable_model->startGames($game_id);
    }

    /**
     * 游戏推广
     * return
     */
    public function gameUrl()
    {
        $game_id = input('game_id', '');
        $model = new Games();
//        $game_info_data = $model->getGamesInfo([['game_id', '=', $game_id]], 'game_id,game_name');
//        $game_info = $game_info_data[ 'data' ];
//        $res = $model->qrcode($game_info[ 'game_id' ], $game_info[ 'game_name' ],$this->game_url, $this->site_id);
        $res = $model->gameUrlQrcode($this->game_url, [ 'id' => $game_id ], 'turntable', $this->site_id);
        return $res;
    }
}