tp3_activity/Application/Admin/Controller/CleanPrizeLogController.class.php

<?php

namespace Admin\Controller;

/**
 * 样式管理
 * @author   xusong
 * @version  0.0.1
 */
class CleanPrizeLogController extends CommonController {

    /**
     * [_initialize 前置操作-继承公共前置方法]
     */

    public function _initialize() {
        // 调用父类前置方法
        parent::_initialize();
        // 登录校验
        $this->Is_Login();
        // 权限校验
        $this->Is_Power();
        //要执行的表
    }

    /**
     * 活动列表
     * @author   Devil
     */
    public function Index() {
        $keyword = I('keyword','');
        if($keyword){
            $where['activity_name'] = array('like','%'.$keyword.'%');
        }else{
            $where = 1;
        }
        $List = M('activity_v2')->field('id,activity_name')->where($where)->order('id desc')->select();
        $this->assign('List', $List);
        $this->assign('keyword',$keyword);
        $this->display('Index');
    }


    /**
     * [Delete 删除]
     * @author   Devil
     * @blog     http://gong.gg/
     * @version  0.0.1
     * @datetime 2016-12-15T11:03:30+0800
     */
    public function clean() {
        // 是否ajax请求
        if (!IS_AJAX) {
            $this->error(L('common_unauthorized_access'));
        }
        $act_id = I('act_id');
        $actinfo = M('activity_v2')->field('id,prize_log_table')->find($act_id);
        if(!$actinfo){
            exit('相关活动不存在，清除数据失败');
        }
        //清理prize_log
        if(false === M($actinfo['prize_log_table'])->where(['act_id'=>$actinfo['id']])->delete()){
            exit(M()->getLastSql());
        }

        //清理daooju
        if(false === M('activity_daoju')->where(['act_id'=>$actinfo['id']])->delete()){
            exit(M()->getLastSql());
        }

        //清理中奖联系方式
        if(false === M('activity_user_v2')->where(['act_id'=>$actinfo['id']])->delete()){
            exit(M()->getLastSql());
        }

        //清理游戏消耗次数
        if(false === M('activity_take_part')->where(['act_id'=>$actinfo['id']])->delete()){
            exit(M()->getLastSql());
        }

        //清理集卡
        if(false === M('activity_collect')->where(['act_id'=>$actinfo['id']])->delete()){
            exit(M()->getLastSql());
        }

        exit('清理活动数据成功');
    }

}