xyzshop/admin/control/spec.php

<?php
/**
 * 规格栏目管理
 *
 *
 *
 ***/

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

	/**
	 * 规格管理
	 */
	public function specOp(){
		$lang	= Language::getLangContent();
		$model_spec = Model('spec');

		$page	= new Page();
		$page->setEachNum(10);
		$page->setStyle('admin');

		$spec_list	= $model_spec->specList(array('order'=>'sp_sort asc'), $page);

		Tpl::output('spec_list',$spec_list);
		Tpl::output('page',$page->show());
		Tpl::showpage('spec.index');
	}

	/**
	 * 添加规格
	 */
	public function spec_addOp(){
		$lang	= Language::getLangContent();
		$model_spec = Model('spec');
		if (chksubmit()){
			$obj_validate = new Validator();
			$obj_validate->validateparam = array(
				array("input"=>$_POST["s_name"], "require"=>"true", "message"=>$lang['spec_add_name_no_null'])
			);
			$error = $obj_validate->validate();
			if ($error != ''){
				showMessage($error);
			}else {
				$spec = array();
				$spec['sp_name']		= $_POST['s_name'];
				$spec['sp_type']        = intval($_POST['sp_type']);
				$spec['sp_sort']		= intval($_POST['s_sort']);
				$spec['class_id']		= $_POST['class_id'];
				$spec['class_name']		= $_POST['class_name'];

				$return = $model_spec->addSpec($spec);
				if($return) {
					$url = array(
						array(
							'url'=>'index.php?act=spec&op=spec_add',
							'msg'=>$lang['spec_index_continue_to_dd']
						),
						array(
							'url'=>'index.php?act=spec&op=spec',
							'msg'=>$lang['spec_index_return_type_list']
						)
					);
					$this->log(L('nc_add,spec_index_spec_name').'['.$_POST['s_name'].']',1);
					showMessage($lang['nc_common_save_succ'], $url);
				}else {
					$this->log(L('nc_add,spec_index_spec_name').'['.$_POST['s_name'].']',0);
					showMessage($lang['nc_common_save_fail']);
				}
			}
		}
		// 一级商品分类
		$gc_list = Model('goods_class')->getGoodsClassListByParentId(0);
		Tpl::output('gc_list', $gc_list);

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

	public function spec_value_addOp()
    {
        $lang	= Language::getLangContent();
        $model_spec = Model('spec');
        if(chksubmit()) {
            $obj_validate = new Validator();
            $obj_validate->validateparam = array(
                array("input"=>$_POST["sp_value"], "require"=>"true", "message"=>$lang['spec_add_name_no_null'])
            );
            $error = $obj_validate->validate();
            if ($error != ''){
                showMessage($error);
            }else {
                $sp_value = [];
                $sp_value['sp_value_name']  = $_POST["sp_value"];
                $sp_value['sp_value_sort']	= intval($_POST['s_sort']);
                $sp_value['sp_id']          = intval($_POST['sp_id']);
                $sp_value['gc_id']          = $model_spec->spec_gc_id($sp_value['sp_id']);

                $add_new = $model_spec->addSpecValue($sp_value);
                if($add_new) {
                    $url = array(
                        array(
                            'url'=>'index.php?act=spec&op=spec_value_add',
                            'msg'=>"继续添加规格值"
                        ),
                        array(
                            'url'=>'index.php?act=spec&op=spec',
                            'msg'=>$lang['spec_index_return_type_list']
                        )
                    );
                    $this->log(L('nc_add,spec_index_spec_name').'['.$_POST['s_name'].']',1);
                    showMessage($lang['nc_common_save_succ'], $url);
                } else {
                    $this->log(L('nc_add,spec_index_spec_name').'['.$_POST['s_name'].']',0);
                    showMessage($lang['nc_common_save_fail']);
                }
            }
        }

        // 获取平台通用规格
        $sp_list = $model_spec->specPlatformList();
        Tpl::output('sp_list', $sp_list);

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

	/**
	 * 编辑规格
	 */
	public function spec_editOp() {
		$lang	= Language::getLangContent();
		if(empty($_GET['sp_id'])) {
			showMessage($lang['param_error']);
		}
		/**
		 * 规格模型
		 */
		$model_spec = Model('spec');

		/**
		 * 编辑保存
		 */
		if (chksubmit()) {
			$obj_validate = new Validator();
			$obj_validate->validateparam = array(
				array("input"=>$_POST["s_name"], "require"=>"true", "message"=>$lang['spec_add_name_no_null'])
			);
			$error = $obj_validate->validate();
			if ($error != '') {
				showMessage($error);
			} else {

				//更新规格表
				$param		= array();
				$param['sp_name']		= trim($_POST['s_name']);
				$param['sp_sort']		= intval($_POST['s_sort']);
				$param['class_id']		= $_POST['class_id'];
				$param['class_name']	= $_POST['class_name'];
				$return = $model_spec->specUpdate($param, array('sp_id'=>intval($_POST['s_id'])), 'spec');
				if ($return) {
					$url = array(
						array(
							'url'=>'index.php?act=spec&op=spec',
							'msg'=>$lang['spec_index_return_type_list']
						)
					);
					$this->log(L('nc_edit,spec_index_spec_name').'['.$_POST['s_name'].']',1);
					showMessage($lang['nc_common_save_succ'], $url);
				} else {
					$this->log(L('nc_edit,spec_index_spec_name').'['.$_POST['s_name'].']',0);
					showMessage($lang['nc_common_save_fail']);
				}
			}
		}

		//规格列表
		$spec_list	= $model_spec->getSpecInfo(intval($_GET['sp_id']));
		if(!$spec_list){
			showMessage($lang['param_error']);
		}

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

		Tpl::output('sp_list',$spec_list);
		Tpl::showpage('spec.edit');
	}

	/**
	 * 删除规格
	 */
	public function spec_delOp(){
		$lang	= Language::getLangContent();
		if(empty($_GET['del_id'])) {
			showMessage($lang['param_error']);
		}
		//规格模型
		$model_spec = Model('spec');

		if(is_array($_GET['del_id'])){
			$id = "'".implode("','", $_GET['del_id'])."'";
		}else{
			$id = intval($_GET['del_id']);
		}
		//规格列表
		$spec_list	= $model_spec->specList(array('in_sp_id'=>$id));

		if(is_array($spec_list) && !empty($spec_list)){
			// 删除类型与规格关联表
			$return = $model_spec->delSpec('type_spec', array('in_sp_id'=>$id));
			if(!$return){
				showMessage($lang['nc_common_save_fail']);
			}

			//删除规格值表
			$return = $model_spec->delSpec('spec_value',array('in_sp_id'=>$id));
			if(!$return){
				showMessage($lang['nc_common_save_fail']);
			}

			//删除规格表
			$return = $model_spec->delSpec('spec',array('in_sp_id'=>$id));
			if(!$return){
				showMessage($lang['nc_common_save_fail']);
			}

			$this->log(L('nc_delete,spec_index_spec_name').'[ID:'.$id.']',1);
			showMessage($lang['nc_common_del_succ']);

		}else{
			$this->log(L('nc_delete,spec_index_spec_name').'[ID:'.$id.']',0);
			showMessage($lang['param_error']);
		}
	}

	/**
	 * ajax操作
	 */
	public function ajaxOp(){
		//规格模型
		$model_spec = Model('spec');

		switch ($_GET['branch']){
			case 'sort':
//			case 'name':
				$return = $model_spec->specUpdate(
					array($_GET['column']=>trim($_GET['value'])),
					array('sp_id'=>intval($_GET['id'])),
					'spec'
				);
				if($return){
					$this->log(L('spec_index_spec_name,nc_sort').'[ID:'.intval($_GET['id']).']',1);
					echo 'true';exit;
				}else{
					echo 'false';exit;
				}
				break;
		}
	}

	public function ajax_spec_valuesOp()
    {
        $sp_id = intval($_GET['sp_id']);
        $mod_spec = Model('spec');
        $spec_values = $mod_spec->getSpecValueList(['sp_id'=>$sp_id]);
        if(!empty($spec_values)) {
            echo json_encode($spec_values);exit;
        } else {
            echo '';exit;
        }
    }

    public function ajax_edit_spec_valueOp()
    {
        $sp_value_id = intval($_GET['sp_value_id']);
        $mod_spec = Model('spec');
        $sp_id = $mod_spec->spec_value_belong_to($sp_value_id);
        $where = ['sp_value_id'=>$sp_value_id];
        $update = [
            'sp_id'         => $sp_id,
            'sp_value_name' => $_GET['sp_value_name'],
            'sp_value_sort' => intval($_GET['sp_value_sort']),
        ];
        $update = $mod_spec->editSpecValue($update, $where);
        echo json_encode($update);exit;
    }

    public function ajax_del_spec_valueOp()
    {
        $sp_value_id = intval($_GET['sp_value_id']);
        $del = Model('spec')->delSpecValue(['sp_value_id'=>$sp_value_id]);
        echo json_encode($del);exit;
    }

	/**
	 * 规格导出
	 */
	public function export_step1Op(){
		$model_spec = Model('spec');
		$page	= new Page();
		$page->setEachNum(self::EXPORT_SIZE);
		$spec_list	= $model_spec->specList(array('order'=>'sp_sort asc'), $page);
		if (!is_numeric($_GET['curpage'])){
			$count = $page->getTotalNum();
			$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=spec&op=spec');
				Tpl::showpage('export.excel');
			}else{	//如果数量小，直接下载
				$this->createExcel($spec_list);
			}
		}else{	//下载
			$this->createExcel($spec_list);
		}
	}

	/**
	 * 生成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_spec'));
		$excel_data[0][] = array('styleid'=>'s_title','data'=>L('exp_sp_content'));

		foreach ((array)$data as $k=>$v){
			$tmp = array();
			$tmp[] = array('data'=>$v['sp_name']);
			$tmp[] = array('data'=>$v['sp_value']);
			$excel_data[] = $tmp;
		}
		$excel_data = $excel_obj->charset($excel_data,CHARSET);
		$excel_obj->addArray($excel_data);
		$excel_obj->addWorksheet($excel_obj->charset(L('exp_spec'),CHARSET));
		$excel_obj->generateXML($excel_obj->charset(L('exp_spec'),CHARSET).$_GET['curpage'].'-'.date('Y-m-d-H',time()));
	}
}