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')->find($act_id); if(!$actinfo){ exit('相关活动不存在,清除数据失败'); } //清理prize_log if(false === M('prize_log_v2')->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()); } //清理vip_vote if(false === M('activity_vip_vote')->where(['act_id'=>$actinfo['id']])->delete()){ exit(M()->getLastSql()); } //清理vote if(false === M('activity_vote')->where(['act_id'=>$actinfo['id']])->delete()){ exit(M()->getLastSql()); } exit('清理活动数据成功'); } }