README

基于 adminlte 布局模板和 kartik dynagrid 的 yii2 框架生成代码

通过 composer 安装

"sintret/yii2-gii-adminlte": "dev-master"

在配置文件中设置如下

$config['modules']['gii'] = [
    'class' => 'yii\gii\Module',
    'generators' => [
        'sintret' => [
            'class' => 'sintret\gii\generators\crud\Generator',
        ],
        'sintretModel' => [
            'class' => 'sintret\gii\generators\model\Generator'
        ]
    ]
];

添加表

CREATE TABLE `log_upload` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `userId` INT(11) DEFAULT NULL,
  `title` VARCHAR(128) NOT NULL,
  `filename` VARCHAR(255) DEFAULT NULL,
  `fileori` VARCHAR(255) DEFAULT NULL,
  `params` longblob,
  `values` longblob,
  `warning` longblob,
  `keys` TEXT,
  `type` TINYINT(1) DEFAULT NULL,
  `userCreate` INT(11) DEFAULT NULL,
  `userUpdate` INT(11) DEFAULT NULL,
  `updateDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `createDate` DATETIME DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=INNODB;

CREATE TABLE `tbl_dynagrid` (
  `id` VARCHAR(100) NOT NULL COMMENT 'Unique dynagrid setting identifier',
  `filter_id` VARCHAR(100) DEFAULT NULL COMMENT 'Filter setting identifier',
  `sort_id` VARCHAR(100) DEFAULT NULL COMMENT 'Sort setting identifier',
  `data` VARCHAR(5000) DEFAULT NULL COMMENT 'Json encoded data for the dynagrid configuration',
  PRIMARY KEY (`id`),
  KEY `tbl_dynagrid_FK1` (`filter_id`),
  KEY `tbl_dynagrid_FK2` (`sort_id`),
  CONSTRAINT `tbl_dynagrid_FK1` FOREIGN KEY (`filter_id`) REFERENCES `tbl_dynagrid_dtl` (`id`),
  CONSTRAINT `tbl_dynagrid_FK2` FOREIGN KEY (`sort_id`) REFERENCES `tbl_dynagrid_dtl` (`id`)
) ENGINE=INNODB;

CREATE TABLE `tbl_dynagrid_dtl` (
  `id` VARCHAR(100) NOT NULL COMMENT 'Unique dynagrid detail setting identifier',
  `category` VARCHAR(10) NOT NULL COMMENT 'Dynagrid detail setting category "filter" or "sort"',
  `name` VARCHAR(150) NOT NULL COMMENT 'Name to identify the dynagrid detail setting',
  `data` VARCHAR(5000) DEFAULT NULL COMMENT 'Json encoded data for the dynagrid detail configuration',
  `dynagrid_id` VARCHAR(100) NOT NULL COMMENT 'Related dynagrid identifier',
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbl_dynagrid_dtl_UK1` (`name`,`category`,`dynagrid_id`)
) ENGINE=INNODB;

如果您想使用解析 Excel 文件到系统中，必须在您的 web 文件夹下添加 "uploads" 文件夹