xyzshop/admin/control/circle_theme.php

<?php
/**
 * 圈子话题管理
 *
 *
 *
 ***/

defined('InShopNC') or exit('Access Invalid!');
class circle_themeControl extends SystemControl{
	public function __construct(){
		parent::__construct();
		Language::read('circle');
	}
	/**
	 * 话题列表
	 */
	public function theme_listOp(){

		$model = Model();
		if (chksubmit()){
			if (!empty($_POST['check_theme_id']) && is_array($_POST['check_theme_id'])){
				foreach ($_POST['check_theme_id'] as $t_id){
					$theme_info = $model->table('circle_theme')->where(array('theme_id'=>$t_id))->find();
					if(empty($theme_info)){
						continue;
					}

					// 删除附件
					$affix_list = $model->table('circle_affix')->where(array('theme_id'=>$t_id))->select();
					if(!empty($affix_list)){
						foreach ($affix_list as $val){
							@unlink(themeImagePath($val['affix_filename']));
							@unlink(themeImagePath($val['affix_filethumb']));
						}
						$model->table('circle_affix')->where(array('theme_id'=>$t_id))->delete();
					}

					// 删除商品
					$model->table('circle_thg')->where(array('theme_id'=>$t_id))->delete();

					// 删除赞表相关
					$model->table('circle_like')->where(array('theme_id'=>$t_id))->delete();

					// 删除回复
					$model->table('circle_threply')->where(array('theme_id'=>$t_id))->delete();

					// 更新圈子主题数量
					$model->table('circle')->update(array('circle_id'=>$theme_info['circle_id'], 'circle_thcount'=>array('exp','circle_thcount-1')));

					// The recycle bin add delete records
					$param = array();
					$param['theme_id']	= $t_id;
					$param['op_id']		= 0;
					$param['op_name']	= L('cirlce_administrator');
					$param['type']		= 'admintheme';
					Model('circle_recycle')->saveRecycle($param, $theme_info);

					// 删除话题
					$model->table('circle_theme')->delete($t_id);

					// Experience
					if(intval($theme_info['theme_exp']) > 0){
						$param = array();
						$param['member_id']		= $theme_info['member_id'];
						$param['member_name']	= $theme_info['member_name'];
						$param['circle_id']		= $theme_info['circle_id'];
						$param['itemid']		= $t_id;
						$param['type']			= 'delRelease';
						$param['exp']			= $theme_info['theme_exp'];
						Model('circle_exp')->saveExp($param);
					}
				}
			}
			showMessage(L('nc_common_op_succ'), 'index.php?act=circle_theme&op=theme_list');
		}
		$where = array();
		if($_GET['searchname'] != ''){
			$where['theme_name'] = array('like', '%'.$_GET['searchname'].'%');
		}
		if($_GET['classname'] != ''){
			$where['circle_name'] = array('like', '%'.$_GET['classname'].'%');
		}
		if($_GET['searchtop'] != '' && in_array($_GET['searchtop'], array(0,1))){
			$where['is_stick'] = intval($_GET['searchtop']);
		}
		if($_GET['searchcream'] != '' && in_array($_GET['searchcream'], array(0,1))){
			$where['is_digest']	= intval($_GET['searchcream']);
		}
		if($_GET['searchrecommend'] != '' && in_array($_GET['searchrecommend'], array(0,1))){
			$where['is_recommend'] = intval($_GET['searchrecommend']);
		}
		$theme_list	= $model->table('circle_theme')->where($where)->order('theme_id desc')->page(10)->select();
		if(!empty($theme_list)){
			$theme_list = array_under_reset($theme_list, 'theme_id'); $themeid_array = array_keys($theme_list);

			// 附件
			$affix_list = $model->table('circle_affix')->where(array('theme_id'=>array('in', $themeid_array), 'affix_type'=>1))->group('theme_id')->select();
			if(!empty($affix_list)) $affix_list = array_under_reset($affix_list, 'theme_id');


			foreach ($theme_list as $key=>$val){
				if(isset($affix_list[$val['theme_id']])) $theme_list[$key]['affix'] = themeImageUrl($affix_list[$val['theme_id']]['affix_filethumb']);
			}
		}
		Tpl::output('theme_list', $theme_list);
		Tpl::output('page', $model->showpage(2));
		Tpl::showpage('circle_theme.list');
	}
	/**
	 * 话题详细
	 */
	public function theme_infoOp(){
		$model = Model();
		$t_id = intval($_GET['t_id']);
		$theme_info = $model->table('circle_theme')->find($t_id);
		Tpl::output('theme_info', $theme_info);

		if($theme_info['theme_special'] == 1){
			$poll_info = $model->table('circle_thpoll')->find($t_id);
			$option_list = $model->table('circle_thpolloption')->where(array('theme_id'=>$t_id))->order('pollop_sort asc')->select();
			Tpl::output('poll_info', $poll_info);
			Tpl::output('option_list', $option_list);
		}
		Tpl::showpage('circle_theme.info');
	}
	/**
	 * 删除话题
	 */
	public function theme_delOp(){
		$model = Model();
		// 验证话题
		$t_id = intval($_GET['t_id']); $c_id = intval($_GET['c_id']);
		$theme_info = $model->table('circle_theme')->where(array('theme_id'=>$t_id, 'circle_id'=>$c_id))->find();
		if(empty($theme_info)){
			showMessage(L('param_error'));
		}

		// 删除附件
		$affix_list = $model->table('circle_affix')->where(array('theme_id'=>$t_id))->select();
		if(!empty($affix_list)){
			foreach ($affix_list as $val){
				@unlink(themeImagePath($val['affix_filename']));
				@unlink(themeImagePath($val['affix_filethumb']));
			}
			$model->table('circle_affix')->where(array('theme_id'=>$t_id))->delete();
		}

		// 删除商品
		$model->table('circle_thg')->where(array('theme_id'=>$t_id))->delete();

		// 删除赞表相关
		$model->table('circle_like')->where(array('theme_id'=>$t_id))->delete();

		// 删除回复
		$model->table('circle_threply')->where(array('theme_id'=>$t_id))->delete();

		// The recycle bin add delete records
		$param = array();
		$param['theme_id']	= $t_id;
		$param['op_id']		= 0;
		$param['op_name']	= L('cirlce_administrator');
		$param['type']		= 'admintheme';
		Model('circle_recycle')->saveRecycle($param, $theme_info);

		// 删除话题
		$model->table('circle_theme')->delete($t_id);

		// 更新圈子主题数量
		$model->table('circle')->update(array('circle_id'=>$c_id, 'circle_thcount'=>array('exp','circle_thcount-1')));

		// Experience
		if(intval($theme_info['theme_exp']) > 0){
			$param = array();
			$param['member_id']		= $theme_info['member_id'];
			$param['member_name']	= $theme_info['member_name'];
			$param['circle_id']		= $theme_info['circle_id'];
			$param['itemid']		= $t_id;
			$param['type']			= 'delRelease';
			$param['exp']			= $theme_info['theme_exp'];
			Model('circle_exp')->saveExp($param);
		}

		showMessage(L('nc_common_op_succ'), 'index.php?act=circle_theme&op=theme_list');
	}
	/**
	 * 话题回复
	 */
	public function theme_replyOp(){
		$model = Model();
		if(chksubmit()){
			$t_id = intval($_POST['t_id']);
			if (!empty($_POST['check_reply_id']) && is_array($_POST['check_reply_id'])){
				foreach ($_POST['check_reply_id'] as $r_id){
					// 验证回复
					$reply_info = $model->table('circle_threply')->where(array('theme_id'=>$t_id, 'reply_id'=>$r_id))->find();
					if(empty($reply_info)){
						showMessage(L('param_error'));
					}

					// 删除附件
					$affix_list = $model->table('circle_affix')->where(array('affix_type'=>2, 'theme_id'=>$t_id, 'reply_id'=>$r_id))->select();
					if(!empty($affix_list)){
						foreach ($affix_list as $val){
							@unlink(themeImagePath($val['affix_filename']));
							@unlink(themeImagePath($val['affix_filethumb']));
						}
						$model->table('circle_affix')->where(array('affix_type'=>2 ,'theme_id'=>$t_id, 'reply_id'=>$r_id))->delete();
					}

					// 删除商品
					$model->table('circle_thg')->where(array('theme_id'=>$t_id, 'reply_id'=>$r_id))->delete();

					// The recycle bin add delete records
					$param = array();
					$param['theme_id']	= $t_id;
					$param['reply_id']	= $r_id;
					$param['op_id']		= 0;
					$param['op_name']	= L('cirlce_administrator');
					$param['type']		= 'adminreply';
					Model('circle_recycle')->saveRecycle($param, $reply_info);

					// 删除回复
					$model->table('circle_threply')->where(array('theme_id'=>$t_id, 'reply_id'=>$r_id))->delete();

					// 更新话题回复数
					$model->table('circle_theme')->update(array('theme_id'=>$t_id, 'theme_commentcount'=>array('exp', 'theme_commentcount-1')));
					// Experience
					if(intval($reply_info['reply_exp']) > 0){
						$param = array();
						$param['member_id']		= $reply_info['member_id'];
						$param['member_name']	= $reply_info['member_name'];
						$param['circle_id']		= $reply_info['circle_id'];
						$param['itemid']		= $t_id.','.$r_id;
						$param['type']			= 'delReplied';
						$param['exp']			= $reply_info['reply_exp'];
						Model('circle_exp')->saveExp($param);
					}
				}
			}

			showMessage(L('nc_common_op_succ'));
		}
		$t_id = intval($_GET['t_id']);
		$reply_list = $model->table('circle_threply')->where(array('theme_id'=>$t_id))->page(10)->select();
		Tpl::output('t_id', $t_id);
		Tpl::output('page', $model->showpage(2));
		Tpl::output('reply_list', $reply_list);
		Tpl::showpage('circle_theme.reply');
	}
	/**
	 * 话题回复删除
	 */
	public function theme_replydelOp(){
		$t_id = intval($_GET['t_id']);
		$r_id = intval($_GET['r_id']);
		$model = Model();
		// 验证回复
		$reply_info = $model->table('circle_threply')->where(array('theme_id'=>$t_id, 'reply_id'=>$r_id))->find();
		if(empty($reply_info)){
			showMessage(L('param_error'));
		}

		// 删除附件
		$affix_list = $model->table('circle_affix')->where(array('affix_type'=>2, 'theme_id'=>$t_id, 'reply_id'=>$r_id))->select();
		if(!empty($affix_list)){
			foreach ($affix_list as $val){
				@unlink(themeImagePath($val['affix_filename']));
				@unlink(themeImagePath($val['affix_filethumb']));
			}
			$model->table('circle_affix')->where(array('affix_type'=>2 ,'theme_id'=>$t_id, 'reply_id'=>$r_id))->delete();
		}

		// 删除商品
		$model->table('circle_thg')->where(array('theme_id'=>$t_id, 'reply_id'=>$r_id))->delete();

		// The recycle bin add delete records
		$param = array();
		$param['theme_id']	= $t_id;
		$param['reply_id']	= $r_id;
		$param['op_id']		= 0;
		$param['op_name']	= L('cirlce_administrator');
		$param['type']		= 'adminreply';
		Model('circle_recycle')->saveRecycle($param, $reply_info);

		// 删除回复
		$model->table('circle_threply')->where(array('theme_id'=>$t_id, 'reply_id'=>$r_id))->delete();

		// 更新话题回复数
		$model->table('circle_theme')->update(array('theme_id'=>$t_id, 'theme_commentcount'=>array('exp', 'theme_commentcount-1')));
		// Experience
		if(intval($reply_info['reply_exp']) > 0){
			$param = array();
			$param['member_id']		= $reply_info['member_id'];
			$param['member_name']	= $reply_info['member_name'];
			$param['circle_id']		= $reply_info['circle_id'];
			$param['itemid']		= $t_id.','.$r_id;
			$param['type']			= 'delReplied';
			$param['exp']			= $reply_info['reply_exp'];
			Model('circle_exp')->saveExp($param);
		}
		showMessage(L('nc_common_op_succ'));
	}
	/**
	 * ajax操作
	 */
	public function ajaxOp(){
		switch ($_GET['branch']){
			case 'recommend':
				$update = array(
					'theme_id'=>intval($_GET['id']),
					$_GET['column']=>$_GET['value']
				);
				Model()->table('circle_theme')->update($update);
				echo 'true';
				break;
		}
	}
}