xyzshop/admin/control/brand.php

<?php
/**
 * 商品品牌管理
 *
 *
 *
 ***/

defined('InShopNC') or exit('Access Invalid!');
class brandControl extends SystemControl{
	const EXPORT_SIZE = 1000;
	public function __construct(){
		parent::__construct();
		Language::read('brand');
	}

	/**
	 * 品牌列表
	 */
	public function brandOp(){
		$lang	= Language::getLangContent();
		$model_brand = Model('brand');
		if (chksubmit()){
			if (!empty($_POST['del_brand_id'])){
				//删除图片
				if (is_array($_POST['del_brand_id'])){
				    $brandid_array = array();
					foreach ($_POST['del_brand_id'] as $k => $v){
						$brandid_array[] = intval($v);
					}
					$model_brand->delBrand(array('brand_id' => array('in', $brandid_array)));
				}
				$this->log(L('nc_delete,brand_index_brand').'[ID:'.implode(',',$_POST['del_brand_id']).']',1);
				showMessage($lang['nc_common_del_succ']);
			}else {
				$this->log(L('nc_delete,brand_index_brand').'[ID:'.implode(',',$_POST['del_brand_id']).']',0);
				showMessage($lang['nc_common_del_fail']);
			}
		}
		/**
		 * 检索条件
		 */
		if (!empty($_GET['search_brand_name'])){
			$condition['brand_name'] = array('like',"%".$_GET['search_brand_name']."%");
		}
		if (!empty($_GET['search_brand_class'])){
			$condition['brand_class'] = array('like',"%".$_GET['search_brand_class']."%");
		}
		$condition['brand_apply']	= '1';
		$brand_list = $model_brand->getBrandList($condition, "*", 10);
		Tpl::output('page',$model_brand->showpage());
		Tpl::output('brand_list',$brand_list);
		Tpl::output('search_brand_name',trim($_GET['search_brand_name']));
		Tpl::output('search_brand_class',trim($_GET['search_brand_class']));
		Tpl::showpage('brand.index');
	}

	/**
	 * 增加品牌
	 */
	public function brand_addOp(){
		$lang	= Language::getLangContent();
		$model_brand = Model('brand');
		if (chksubmit()){
			$obj_validate = new Validator();
			$obj_validate->validateparam = array(
				array("input"=>$_POST["brand_name"], "require"=>"true", "message"=>$lang['brand_add_name_null']),
				array("input"=>$_POST["brand_initial"], "require"=>"true", "message"=>'请填写首字母'),
				array("input"=>$_POST["brand_sort"], "require"=>"true", 'validator'=>'Number', "message"=>$lang['brand_add_sort_int']),
			);
			$error = $obj_validate->validate();
			if ($error != ''){
				showMessage($error);
			}else {
				$insert_array = array();
				$insert_array['brand_name'] = trim($_POST['brand_name']);
				$insert_array['brand_country'] = trim($_POST['brand_country']);
				$insert_array['brand_initial'] = strtoupper($_POST['brand_initial']);
				$insert_array['class_id']	= $_POST['class_id'];
				$insert_array['brand_class'] = trim($_POST['brand_class']);
				$insert_array['brand_pic'] = trim($_POST['brand_pic']);
				$insert_array['brand_recommend'] = trim($_POST['brand_recommend']);
				$insert_array['brand_sort'] = intval($_POST['brand_sort']);
				$insert_array['show_type'] = intval($_POST['show_type'])==1?1:0;
				$result = $model_brand->addBrand($insert_array);
				if ($result){
					$url = array(
						array(
							'url'=>'index.php?act=brand&op=brand_add',
							'msg'=>$lang['brand_add_again'],
						),
						array(
							'url'=>'index.php?act=brand&op=brand',
							'msg'=>$lang['brand_add_back_to_list'],
						)
					);
					$this->log(L('nc_add,brand_index_brand').'['.$_POST['brand_name'].']',1);
					showMessage($lang['nc_common_save_succ'],$url);
				}else {
					showMessage($lang['nc_common_save_fail']);
				}
			}
		}

		// 一级商品分类
		$gc_list = Model('goods_class')->getGoodsClassListByParentId(0);
		Tpl::output('gc_list', $gc_list);

		Tpl::showpage('brand.add');
	}

	/**
	 * 品牌编辑
	 */
	public function brand_editOp(){
		$lang	= Language::getLangContent();
		$model_brand = Model('brand');

		if (chksubmit()){
			$obj_validate = new Validator();
			$obj_validate->validateparam = array(
				array("input"=>$_POST["brand_name"], "require"=>"true", "message"=>$lang['brand_add_name_null']),
				array("input"=>$_POST["brand_initial"], "require"=>"true", "message"=>'请填写首字母'),
				array("input"=>$_POST["brand_sort"], "require"=>"true", 'validator'=>'Number', "message"=>$lang['brand_add_sort_int']),
			);
			$error = $obj_validate->validate();
			if ($error != ''){
				showMessage($error);
			}else {
			    $brand_info = $model_brand->getBrandInfo(array('brand_id' => intval($_POST['brand_id'])));
			    $where = array();
				$where['brand_id'] = intval($_POST['brand_id']);
				$update_array = array();
				$update_array['brand_name'] = trim($_POST['brand_name']);
                $update_array['brand_country'] = trim($_POST['brand_country']);
                $update_array['brand_initial'] = strtoupper($_POST['brand_initial']);
				$update_array['class_id']	= $_POST['class_id'];
				$update_array['brand_class'] = trim($_POST['brand_class']);
				if (!empty($_POST['brand_pic'])){
					$update_array['brand_pic'] = $_POST['brand_pic'];
				}
				$update_array['brand_recommend'] = intval($_POST['brand_recommend']);
				$update_array['brand_sort'] = intval($_POST['brand_sort']);
				$update_array['show_type'] = intval($_POST['show_type'])==1?1:0;
				$result = $model_brand->editBrand($where, $update_array);
				if ($result){
					if (!empty($_POST['brand_pic']) && !empty($brand_info['brand_pic'])){
						@unlink(BASE_UPLOAD_PATH.DS.ATTACH_BRAND.DS.$brand_info['brand_pic']);
					}
					$url = array(
						array(
							'url'=>'index.php?act=brand&op=brand_edit&brand_id='.intval($_POST['brand_id']),
							'msg'=>$lang['brand_edit_again'],
						),
						array(
							'url'=>'index.php?act=brand&op=brand',
							'msg'=>$lang['brand_add_back_to_list'],
						)
					);
					$this->log(L('nc_edit,brand_index_brand').'['.$_POST['brand_name'].']',1);
					showMessage($lang['nc_common_save_succ'],$url);
				}else {
					$this->log(L('nc_edit,brand_index_brand').'['.$_POST['brand_name'].']',0);
					showMessage($lang['nc_common_save_fail']);
				}
			}
		}

		$brand_info = $model_brand->getBrandInfo(array('brand_id' => intval($_GET['brand_id'])));
		if (empty($brand_info)){
			showMessage($lang['param_error']);
		}
		Tpl::output('brand_array',$brand_info);

		// 一级商品分类
		$gc_list = Model('goods_class')->getGoodsClassListByParentId(0);
		Tpl::output('gc_list', $gc_list);

		Tpl::showpage('brand.edit');
	}

	/**
	 * 删除品牌
	 */
	public function brand_delOp(){
		if (intval($_GET['del_brand_id']) > 0){
			Model('brand')->delBrand(array('brand_id' => intval($_GET['del_brand_id'])));
			$this->log(L('nc_delete,brand_index_brand').'[ID:'.intval($_GET['del_brand_id']).']',1);
			showMessage(L('nc_common_del_succ'),'index.php?act=brand&op=brand');
		}else {
			$this->log(L('nc_delete,brand_index_brand').'[ID:'.intval($_GET['del_brand_id']).']',0);
			showMessage(L('nc_common_del_fail'),'index.php?act=brand&op=brand');
		}
	}

	/**
	 * 品牌申请
	 */
	public function brand_applyOp(){
		$lang	= Language::getLangContent();
		$model_brand = Model('brand');
		/**
		 * 对申请品牌进行操作 通过，拒绝
		 */
		if (chksubmit()){
			if (!empty($_POST['del_id'])){
				switch ($_POST['type']){
					case 'pass':
						//更新品牌 申请状态
						$brandid_array = array();
						foreach ($_POST['del_id'] as $v){
							$brandid_array[] = intval($v);
						}
						$update_array = array();
						$update_array['brand_apply'] = 1;
						$model_brand->editBrand(array('brand_id' => array('in', $brandid_array)), $update_array);
						$this->log(L('brand_apply_pass').'[ID:'.implode(',',$brandid_array).']',null);
						showMessage($lang['brand_apply_passed']);
						break;
					case 'refuse':
						//删除该品牌
						$brandid_array = array();
						foreach ($_POST['del_id'] as $v){
							$brandid_array[] = intval($v);
						}
                        $model_brand->delBrand(array('brand_id' => array('in', $brandid_array)));
						$this->log(L('nc_delete,brand_index_brand').'[ID:'.implode(',',$_POST['del_id']).']',1);
						showMessage($lang['nc_common_del_succ']);
						break;
						default:
							showMessage($lang['brand_apply_invalid_argument']);
				}
			}else {
				$this->log(L('nc_delete,brand_index_brand'),0);
				showMessage($lang['nc_common_del_fail']);
			}
		}
		/**
		 * 检索条件
		 */
		$condition = array();
		if (!empty($_POST['search_brand_name'])) {
            $condition['brand_name'] = array('like', '%' . trim($_POST['search_brand_name']) . '%');
		}
		if (!empty($_POST['search_brand_class'])) {
		    $condition['brand_class'] = array('like', '%' . trim($_POST['search_brand_class']) . '%');
		}
		$brand_list = $model_brand->getBrandNoPassedList($condition, '*', 10);

		Tpl::output('brand_list',$brand_list);
		Tpl::output('show_page', $model_brand->showpage());
		Tpl::output('search_brand_name',trim($_POST['search_brand_name']));
		Tpl::output('search_brand_class',trim($_POST['search_brand_class']));
		Tpl::showpage('brand.apply');
	}

	/**
	 * 审核 申请品牌操作
	 */
	public function brand_apply_setOp(){
		$model_brand = Model('brand');

		if (intval($_GET['brand_id']) > 0){
			switch ($_GET['state']){
				case 'pass':
					/**
					 * 更新品牌 申请状态
					 */
					$update_array = array();
					$update_array['brand_apply'] = 1;
					$result = $model_brand->editBrand(array('brand_id' => intval($_GET['brand_id'])), $update_array);
					if ($result === true){
						$this->log(L('brand_apply_pass').'[ID:'.intval($_GET['brand_id']).']',null);
						showMessage(Language::get('brand_apply_pass'));
					}else {
						$this->log(L('brand_apply_pass').'[ID:'.intval($_GET['brand_id']).']',0);
						showMessage(Language::get('brand_apply_fail'));
					}
					break;
				case 'refuse':
					// 删除
					$model_brand->delBrand(array('brand_id' => intval($_GET['brand_id'])));
					$this->log(L('nc_delete,brand_index_brand').'[ID:'.intval($_GET['brand_id']).']',1);
					showMessage(Language::get('nc_common_del_succ'));
					break;
					default:
						showMessage(Language::get('brand_apply_paramerror'));
			}
		}else {
			$this->log(L('nc_delete,brand_index_brand').'[ID:'.intval($_GET['brand_id']).']',0);
			showMessage(Language::get('brand_apply_brandparamerror'));
		}
	}

	/**
	 * ajax操作
	 */
	public function ajaxOp(){
		$model_brand = Model('brand');
		switch ($_GET['branch']){
			/**
			 * 品牌名称
			 */
			case 'brand_name':
				/**
				 * 判断是否有重复
				 */
				$condition['brand_name'] = trim($_GET['value']);
				$condition['brand_id'] = array('neq', intval($_GET['id']));
				$result = $model_brand->getBrandList($condition);
				if (empty($result)){
					$model_brand->editBrand(array('brand_id' => intval($_GET['id'])), array('brand_name' => trim($_GET['value'])));
					$this->log(L('nc_edit,brand_index_name').'['.$_GET['value'].']',1);
					echo 'true';exit;
				}else {
					echo 'false';exit;
				}
				break;
			/**
			 * 品牌类别，品牌排序，推荐
			 */
			case 'brand_class':
			case 'brand_sort':
			case 'brand_recommend':
				$model_brand->editBrand(array('brand_id' => intval($_GET['id'])), array($_GET['column'] => trim($_GET['value'])));
				$detail_log = str_replace(array('brand_class','brand_sort','brand_recommend'),array(L('brand_index_class'),L('nc_sort'),L('nc_recommend')),$_GET['branch']);
				$this->log(L('nc_edit,brand_index_brand').$detail_log.'[ID:'.intval($_GET['id']).']',1);
				echo 'true';exit;
				break;
			/**
			 * 验证品牌名称是否有重复
			 */
			case 'check_brand_name':
				$condition['brand_name'] = trim($_GET['brand_name']);
				$condition['brand_id'] = array('neq', intval($_GET['id']));
				$result = $model_brand->getBrandList($condition);
				if (empty($result)){
					echo 'true';exit;
				}else {
					echo 'false';exit;
				}
				break;
		}
	}

	/**
	 * 品牌导出第一步
	 */
	public function export_step1Op(){
		$model_brand = Model('brand');
		$condition = array();
		if (!empty($_GET['search_brand_name'])){
			$condition['brand_name'] = array('like',"%{$_GET['search_brand_name']}%");
		}
		if (!empty($_GET['search_brand_class'])){
			$condition['brand_class'] = array('like',"%{$_GET['search_brand_class']}%");
		}
		$condition['brand_apply']	= '1';

		if (!is_numeric($_GET['curpage'])){
			$count = $model_brand->getBrandCount($condition);
			$array = array();
			if ($count > self::EXPORT_SIZE ){	//显示下载链接
				$page = ceil($count/self::EXPORT_SIZE);
				for ($i=1;$i<=$page;$i++){
					$limit1 = ($i-1)*self::EXPORT_SIZE + 1;
					$limit2 = $i*self::EXPORT_SIZE > $count ? $count : $i*self::EXPORT_SIZE;
					$array[$i] = $limit1.' ~ '.$limit2 ;
				}
				Tpl::output('list',$array);
				Tpl::output('murl','index.php?act=brand&op=brand');
				Tpl::showpage('export.excel');
			}else{	//如果数量小，直接下载
				$data = $model_brand->getBrandList($condition, '*', 0, 'brand_id desc', self::EXPORT_SIZE);
				$this->createExcel($data);
			}
		}else{	//下载
			$limit1 = ($_GET['curpage']-1) * self::EXPORT_SIZE;
			$limit2 = self::EXPORT_SIZE;
			$data = $model_brand->getBrandList($condition, '*', 0, 'brand_id desc', "{$limit1},{$limit2}");
			$this->createExcel($data);
		}
	}

	/**
	 * 生成excel
	 *
	 * @param array $data
	 */
	private function createExcel($data = array()){
		Language::read('export');
		import('libraries.excel');
		$excel_obj = new Excel();
		$excel_data = array();
		//设置样式
		$excel_obj->setStyle(array('id'=>'s_title','Font'=>array('FontName'=>'宋体','Size'=>'12','Bold'=>'1')));
		//header
		$excel_data[0][] = array('styleid'=>'s_title','data'=>L('exp_brandid'));
		$excel_data[0][] = array('styleid'=>'s_title','data'=>L('exp_brand'));
		$excel_data[0][] = array('styleid'=>'s_title','data'=>L('exp_brand_cate'));
		$excel_data[0][] = array('styleid'=>'s_title','data'=>L('exp_brand_img'));
		foreach ((array)$data as $k=>$v){
			$tmp = array();
			$tmp[] = array('data'=>$v['brand_id']);
			$tmp[] = array('data'=>$v['brand_name']);
			$tmp[] = array('data'=>$v['brand_class']);
			$tmp[] = array('data'=>$v['brand_pic']);
			$excel_data[] = $tmp;
		}
		$excel_data = $excel_obj->charset($excel_data,CHARSET);
		$excel_obj->addArray($excel_data);
		$excel_obj->addWorksheet($excel_obj->charset(L('exp_brand'),CHARSET));
		$excel_obj->generateXML($excel_obj->charset(L('exp_brand'),CHARSET).$_GET['curpage'].'-'.date('Y-m-d-H',time()));
	}

}