4--视图模型

1、创建视图

<?php
        class CategoryViewModel extends ViewModel{
            public $viewFields=array(
            //SELECT Category.id AS cid,Category.title AS ctitle,Category.alias AS calias,Category.published AS cpublished,
            //    Category.order AS corder,Category.access AS caccess,Category.sectionid AS sectionid,
            //        Section.title AS sec_Name 
            //            FROM joys_category Category JOIN joys_section Section 
            //                ON Category.sectionid=Section.id
                'Category'=>array('id'=>'cid','title'=>'ctitle','alias'=>'calias','published'=>'cpublished','order'=>'corder','access'=>'caccess','sectionid'),
                'Section'=>array('title'=>'sec_Name','_on'=>'Category.sectionid=Section.id'),
            
            );
        }
?>

2、测试

<?php
        class CategoryAction extends CommonAction{
            public function index(){
                $sec=new CategoryViewModel();
                dump($sec->select());
                $this->display();
            }
        public function add(){}
        public function edit(){}
        public function delete(){}
        public function update(){}
            
            
        }






?>