[PHP] 商品类型规格属性后台管理（代码流程备忘）详解编程语言

<?php 
namespace Admin/Controller; 
use Think/Controller; 
class BaseController extends Controller { 
    protected $pageSize=1; 
    /** 
     * 获取分页对象 
     * @param  [type] $count [description] 
     * @return [type]        [description] 
     */ 
    public function getPager($count){ 
        $pager=new /Common/Libs/MyPage($count,$this->pageSize); 
        return $pager; 
    } 
}

<?php 
namespace Common/Model; 
use Think/Model; 
class BaseModel extends Model{ 
    /** 
     * 获取分页数据 
     * @param  [type] $pager     [description] 
     * @param  array  $condition [description] 
     * @param  string $order     [description] 
     * @return [type]            [description] 
     */ 
    public function getPagerResult($pager,$condition=array(),$order=""){ 
        if($pager==null){ 
            return; 
        } 
        return $this->where($condition) 
                    ->limit($pager->firstRow.','.$pager->listRows) 
                    ->order($order) 
                    ->select(); 
    } 
    /** 
     * 获取条数 
     * @return [type] [description] 
     */ 
    public function getCount($condition=array()){ 
        return $this->where($condition)->count(); 
    } 
    /** 
     * 添加数据 
     * @return [type] [description] 
     */ 
    public function addItem($data){ 
        $msg=array(); 
        if(!$this->create($data)){ 
            $msg['msg']=$this->getError(); 
            $msg['status']=false; 
        }else{ 
            $id=$this->add($data); 
            if($id){ 
                $msg['status']=true; 
                $msg['id']=$id; 
            }else{ 
                $msg['status']=false; 
                $msg['msg']=$this->getError(); 
            } 
        } 
        return $msg; 
    } 
    /** 
     * 获取单条数据 
     * @return [type] [description] 
     */ 
    public function getItem($condition=array()){ 
        return $this->where($condition)->find(); 
    } 
    /** 
     * 获取所有数据 
     * @return [type] [description] 
     */ 
    public function getAllResult($condition=array()){ 
        return $this->where($condition)->select(); 
    } 
    /** 
     * 删除数据 
     * @return [type] [description] 
     */ 
    public function delItem($condition=array()){ 
        if(empty($condition)){ 
            return false; 
        } 
        return $this->where($condition)->delete(); 
    } 
    /** 
     * 编辑数据 
     * @return [type] [description] 
     */ 
    public function setItem($condition=array(),$data){ 
        if(empty($condition)){ 
            return false; 
        } 
        $msg=array(); 
        if(!$this->create($data)){ 
            $msg['msg']=$this->getError(); 
            $msg['status']=false; 
        }else{ 
            $id=$this->where($condition)->save($data); 
            $msg['status']=true; 
            $msg['id']=$id; 
        } 
        return $msg; 
    } 
}

<?php 
namespace Admin/Controller; 
use Think/Controller; 
/** 
 * 类型（规格，属性） 
 */ 
class TypeController extends BaseController { 
    private $typeModel; 
    private $specModel; 
    private $attrModel; 
    private $typeId; 
    public function __construct(){ 
        parent::__construct(); 
        $this->typeModel=D("Type"); 
        $this->specModel=D("Spec"); 
        $this->attrModel=D("Attr"); 
    } 
    /** 
     * 列表 
     * @return [type] [description] 
     */ 
    public function index(){ 
        $nums=$this->typeModel->getCount(); 
        $pager=$this->getPager($nums); 
        $typeList=$this->typeModel->getPagerResult($pager,array(),"type_id desc"); 
        $pageHtml=$pager->show(); 
 
        $this->assign('typeList',$typeList); 
        $this->assign('pageHtml',$pageHtml); 
        $this->display(); 
    } 
    /** 
     * 添加类型(添加进4张表 type,type_spec,attribute,attribute_value) 
     * @return [type] [description] 
     */ 
    public function addType(){ 
        if(IS_POST){ 
            //添加类型表 
            $res=$this->typeModel->addTypeItem($_POST); 
            if($res['status']){ 
                $this->typeId=$res['id']; 
                //添加属性 
                if($_POST['attr_value'][0]['name']){ 
                    $this->addAttrData($_POST['attr_value']); 
                } 
                $this->success("操作成功！"); 
            }else{ 
                $this->error($res['msg']); 
            } 
        }else{ 
            $specList=$this->specModel->select(); 
            $this->assign("specList",$specList); 
            $this->display();  
        } 
    } 
    /** 
     * 添加属性 
     * @param [type] $data [description] 
     */ 
    private function addAttrData($data){ 
        foreach ($data as $key => $value) { 
            $temp=array(); 
            $temp['attr_name']=$value['name']; 
            $temp['attr_values']=$value['value']; 
            $temp['type_id']=$this->typeId; 
            $this->attrModel->addAttrItem($temp); 
        } 
        return true; 
    } 
    /** 
     * 编辑属性 
     * @param [type] $data [description] 
     */ 
    private function setAttrData($data){ 
        foreach ($data as $key => $value) { 
            $temp=array(); 
            $temp['attr_id']=$key; 
            $temp['attr_name']=$value['name']; 
            $temp['attr_values']=$value['value']; 
            $temp['type_id']=$this->typeId; 
            $this->attrModel->setAttrItem($temp); 
            //添加属性 
            if($key=='new'){ 
                $this->addAttrData($value); 
                break; 
            } 
        } 
        return true; 
    } 
    /** 
     * 编辑类型(添加进4张表 type,type_spec,attribute,attribute_value) 
     * @return [type] [description] 
     */ 
    public function editType(){ 
        $typeId=intval($_GET['typeId']); 
         
        if(IS_POST){ 
            $this->typeId=intval($_POST['type_id']); 
            //编辑类型表 
            $res=$this->typeModel->editTypeItem($_POST); 
            if($res['status']){ 
                //编辑属性 
                if(!empty($_POST['attr_value'])){ 
                    $this->setAttrData($_POST['attr_value']); 
                } 
                $this->success("操作成功！",U("Type/editType",array('typeId'=>$this->typeId))); 
            }else{ 
                $this->error($res['msg']); 
            } 
        }else{ 
            $typeInfo=$this->typeModel->getItem(array('type_id'=>$typeId)); 
            $this->assign("typeInfo",$typeInfo); 
 
            $specList=$this->specModel->select(); 
            $this->assign("specList",$specList); 
 
            $specTypeList=M("type_spec")->where(array('type_id'=>$typeId))->getField("spec_id",true); 
            $this->assign("specTypeList",$specTypeList); 
 
            $attrList=$this->attrModel->getAllResult(array('type_id'=>$typeId)); 
            $this->assign("attrList",$attrList); 
 
            $this->display();  
        } 
    } 
}

<?php 
namespace Common/Model; 
use Think/Model; 
class TypeModel extends BaseModel{ 
    /** 
     * 验证规则 
     * @var array 
     */ 
    protected $_validate = array( 
        array('type_name','require','类型名称必须！') 
    ); 
    /** 
    * 添加类型 
    */ 
    public function addTypeItem($data){ 
        $res=$this->addItem($data); 
 
        //添加类型规格 
        $typeSpecs=$data['spec_id']; 
        $typeSpecArray=array(); 
        foreach ($typeSpecs as $typeSpec) { 
            $temp=array(); 
            $temp['type_id']=$res['id']; 
            $temp['spec_id']=$typeSpec; 
            $typeSpecArray[]=$temp; 
        } 
         
        M("type_spec")->addAll($typeSpecArray); 
        return $res; 
    } 
    /** 
    * 编辑类型 
    */ 
    public function editTypeItem($data){ 
        $res=$this->setItem(array('type_id'=>$data['type_id']),$data); 
 
        //编辑类型规格 
        M("type_spec")->where(array('type_id'=>$data['type_id']))->delete(); 
        $typeSpecs=$data['spec_id']; 
        $typeSpecArray=array(); 
        foreach ($typeSpecs as $typeSpec) { 
            $temp=array(); 
            $temp['type_id']=$data['type_id']; 
            $temp['spec_id']=$typeSpec; 
            $typeSpecArray[]=$temp; 
        } 
         
        M("type_spec")->addAll($typeSpecArray); 
 
        return $res; 
    } 
}

<?php 
namespace Common/Model; 
use Think/Model; 
class SpecModel extends BaseModel{ 
    /** 
     * 验证规则 
     * @var array 
     */ 
    protected $_validate = array( 
        array('spec_name','require','规格名称必须！'),  
        array('spec_sort','number','排序必须是数字！') 
    ); 
}

<?php 
namespace Common/Model; 
use Think/Model; 
class AttrModel extends BaseModel{ 
    protected $tableName="attribute"; 
    /** 
     * 验证规则 
     * @var array 
     */ 
    protected $_validate = array( 
        array('attr_name','require','属性名称必须！'), 
        array('type_id','require','类型id必须！'), 
        array('attr_values','require','属性值必须！') 
    ); 
    /** 
     * 添加属性 
     */ 
    public function addAttrItem($data){ 
        $res=$this->addItem($data); 
 
        //添加属性值 
        $attrValues=explode("|", $data['attr_values']); 
        $attrValueArray=array(); 
        foreach ($attrValues as $attrValue) { 
            $temp=array(); 
            $temp['attr_id']=$res['id']; 
            $temp['attr_value']=$attrValue; 
            $attrValueArray[]=$temp; 
        } 
         
        M("attribute_value")->addAll($attrValueArray); 
    } 
    /** 
     * 编辑属性 
     */ 
    public function setAttrItem($data){ 
        $res=$this->setItem(array('attr_id'=>$data['attr_id']),$data); 
 
        //编辑属性值 
        M("attribute_value")->where(array('attr_id'=>$data['attr_id']))->delete(); 
        $attrValues=explode("|", $data['attr_values']); 
        $attrValueArray=array(); 
        foreach ($attrValues as $attrValue) { 
            if(!$attrValue){ 
                break; 
            } 
            $temp=array(); 
            $temp['attr_id']=$data['attr_id']; 
            $temp['attr_value']=$attrValue; 
            $attrValueArray[]=$temp; 
        } 
         
        M("attribute_value")->addAll($attrValueArray); 
    } 
}