composer安装yii2 - treegrid:composer require --prefer-dist leandrogehlen/yii2-treegrid "*"
或者在composer.json
文件的require部分添加:"leandrogehlen/yii2-treegrid": "*"
分类表:
DROP TABLE IF EXISTS `shop_category`;
CREATE TABLE `shop_category` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`cat_name` varchar(90) NOT NULL DEFAULT '' COMMENT '分类名称',
`cat_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '分类描述',
`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
`sort_order` int(4) unsigned NOT NULL DEFAULT '50' COMMENT '显示排序,数字越大越后',
`is_show` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否在前台显示 (0:显示 1:不显示)',
`icon_url` varchar(255) NOT NULL COMMENT '图标地址',
`show_in_nav` tinyint(1) DEFAULT '0' COMMENT '是否在导航栏显示(0:显示 1:不显示)',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10008 DEFAULT CHARSET=utf8;
模型用gii生成
控制器:
public function actionIndex()
{
$query = Category::find();
$dataProvider =