$adapter
$adapter : \Phinx\Db\Adapter\AdapterInterface
Abstract Seed Class.
It is expected that the seeds you write extend from this class.
This abstract class proxies the various database methods to your specified adapter.
$adapter : \Phinx\Db\Adapter\AdapterInterface
$input : \think\console\Input
$output : \think\console\Output
__construct(\think\console\Input $input = null, \think\console\Output $output = null)
Class Constructor.
\think\console\Input | $input | |
\think\console\Output | $output |
run()
Run Method.
Write your database seeder using this method.
More information on writing seeders is available here: http://docs.phinx.org/en/latest/seeding.html
setAdapter(\Phinx\Db\Adapter\AdapterInterface $adapter) : \Phinx\Seed\MigrationInterface
Sets the database adapter.
\Phinx\Db\Adapter\AdapterInterface | $adapter | Database Adapter |
getAdapter() : \Phinx\Db\Adapter\AdapterInterface
Gets the database adapter.
setInput(\think\console\Input $input) : \Phinx\Seed\MigrationInterface
Sets the input object to be used in migration object
\think\console\Input | $input |
getInput() : \think\console\Input
Gets the input object to be used in migration object
setOutput(\think\console\Output $output) : \Phinx\Seed\MigrationInterface
Sets the output object to be used in migration object
\think\console\Output | $output |
getOutput() : \think\console\Output
Gets the output object to be used in migration object
table(string $tableName, array $options = array()) : \Phinx\Db\Table
Returns an instance of the <code>\Table</code> class.
You can use this class to create and manipulate tables.
string | $tableName | Table Name |
array | $options | Options |
<?php
use think\migration\Seeder;
class Rule extends Seeder
{
/**
* Run Method.
*
* Write your database seeder using this method.
*
* More information on writing seeders is available here:
* http://docs.phinx.org/en/latest/seeding.html
*/
public function run()
{
// 初始化超级管理员
$rows= [
// 一级菜单 1
['id'=>1,'title' =>'成绩采集','name'=>'chengji','paixu' =>1,'ismenu' =>true,'font'=>'Hui-iconfont-yuedu'],
['id'=>2,'title' =>'成绩统计','name'=>'tongji','paixu' =>2,'ismenu' =>true,'font'=>'Hui-iconfont-shujutongji','status'=>false],
['id'=>3,'title' =>'考试管理','name'=>'kaoshi','paixu' =>3,'ismenu' =>true,'font'=>'Hui-iconfont-canshu'],
['id'=>4,'title' =>'师生名单','name'=>'renshi','paixu' =>4,'ismenu' =>true,'font'=>'Hui-iconfont-user-group'],
['id'=>5,'title' =>'教务管理','name'=>'teach','paixu' =>5,'ismenu' =>true,'font'=>'Hui-iconfont-yuyin2'],
['id'=>6,'title' =>'管理员管理','name'=>'admin','paixu' =>8,'ismenu' =>true,'font'=>'Hui-iconfont-root'],
['id'=>7,'title'=>'系统管理','name' =>'system','paixu' =>9,'ismenu'=>true,'font' =>'Hui-iconfont-system'],
['id'=>8,'title'=>'荣誉管理','name' =>'rongyu','paixu' =>6,'ismenu'=>true,'font' =>'Hui-iconfont-huangguan','status'=>false],
['id'=>9,'title'=>'课题管理','name' =>'keti','paixu' =>7,'ismenu'=>true,'font' =>'Hui-iconfont-huangguan','status'=>false],
// 二级菜单
// 成绩采集
['id'=>101,'title'=>'扫码录入','name'=>'chengji/Index/malu','paixu'=>1,'ismenu' =>true,'pid' =>1,'url'=>'/chengji/malu',],
['id'=>102,'title'=>'表格录入','name'=>'chengji/Index/biaolu','paixu'=>2,'ismenu' =>true,'pid' =>1,'url'=>'/chengji/biaolu',],
// 成绩统计
['id'=>201,'title'=>'班级成绩','name'=>'tongji/Index/banji','paixu'=>1,'ismenu' =>true,'pid' =>2,'url'=>'/tongji',],
// 考试管理
['id'=>301,'title'=>'考试列表','name'=>'kaoshi/Index/index','paixu'=>1,'ismenu' =>true,'pid' =>3,'url'=>'/kaoshi',],
['id'=>302,'title'=>'考试操作','name'=>'Kaoshi/MoreAction/index','paixu'=>2,'ismenu' =>false,'pid' =>3],
// 师生名单
['id'=>401,'title'=>'学生列表','name'=>'renshi/Student/index','paixu'=>1,'ismenu' =>true,'pid' =>4,'url'=>'/student',],
['id'=>402,'title'=>'教师列表','name'=>'renshi/Index/index','paixu'=>2,'ismenu' =>true,'pid' =>4,'url'=>'/teacher',],
// 教务管理
['id'=>501,'title'=>'学期列表','name'=>'teach/Xueqi/index','paixu'=>1,'ismenu' =>true,'pid' =>5,'url'=>'/xueqi',],
['id'=>502,'title'=>'班级列表','name'=>'teach/Banji/index','paixu'=>2,'ismenu' =>true,'pid' =>5,'url'=>'/banji',],
['id'=>503,'title'=>'学科列表','name'=>'teach/Subject/index','paixu'=>3,'ismenu' =>true,'pid' =>5,'url'=>'/subject',],
// 管理员管理
['id'=>601,'title'=>'管理员列表','name'=>'admin/Index/index','paixu'=>1,'ismenu' =>true,'pid' =>6,'url'=>'/admin',],
['id'=>602,'title'=>'权限列表','name'=>'admin/AuthRule/index','paixu'=>2,'ismenu' =>true,'pid' =>6,'url'=>'/authrule',],
['id'=>603,'title'=>'角色列表','name'=>'admin/AuthGroup/index','paixu'=>3,'ismenu' =>true,'pid' =>6,'url'=>'/authgroup',],
// 系统设置
['id'=>701,'title'=>'类别管理','name'=>'system/Category/index','paixu'=>1,'ismenu' =>true,'pid' =>7,'url'=>'/category',],
['id'=>702,'title'=>'单位管理','name'=>'system/School/index','paixu'=>2,'ismenu' =>true,'pid' =>7,'url'=>'/school',],
['id'=>703,'title'=>'系统设置','name'=>'system/SystemBase/index','paixu'=>3,'ismenu' =>true,'pid' =>7,'url'=>'/sysbase',],
// 荣誉管理
['id'=>801,'title'=>'单位荣誉','name'=>'rongyu/DwRongyu/index','paixu'=>1,'ismenu' =>true,'pid' =>8,'url'=>'/dwry',],
['id'=>802,'title'=>'教师荣誉册','name'=>'rongyu/JsRongyu/index','paixu'=>2,'ismenu' =>true,'pid' =>8,'url'=>'/jsry',],
['id'=>803,'title'=>'教师荣誉信息','name'=>'rongyu/JsRongyuInfo/index','paixu'=>3,'ismenu' =>true,'pid' =>8,'url'=>'/jsryinfo',],
['id'=>804,'title'=>'学生荣誉','name'=>'rongyu/StuRongyu/index','paixu'=>7,'ismenu' =>true,'pid' =>8,'url'=>'/xsry','status'=>0],
// 荣誉管理
['id'=>901,'title'=>'课题册','name'=>'keti/Index/index','paixu'=>1,'ismenu' =>true,'pid' =>9,'url'=>'/kt',],
['id'=>902,'title'=>'课题列表','name'=>'ketiinfo/Index/index','paixu'=>2,'ismenu' =>true,'pid' =>9,'url'=>'/ktinfo',],
// 三级-权限
// 扫码录入
['title'=>'扫码查询','name'=>'Chengji/Index/read','paixu' =>1,'pid'=>101,'id'=>1000000],
['title'=>'扫码保存','name'=>'Chengji/Index/malusave','paixu' =>2,'pid'=>101],
// 表格录入
['title'=>'表格保存','name'=>'Chengji/Index/saveAll','paixu' =>3,'pid'=>102],
['title'=>'表格上传','name'=>'Chengji/Index/upload','paixu' =>4,'pid'=>102],
['title'=>'成绩修改','name'=>'Chengji/Index/edit','paixu' =>5,'pid'=>102],
// 考试管理
['title'=>'添加','name'=>'Kaoshi/Index/create','paixu' =>1,'pid'=>301],
['title'=>'删除','name'=>'Kaoshi/Index/delete','paixu'=>2,'pid'=>301],
['title'=>'编辑','name'=>'Kaoshi/Index/edit','paixu'=>3,'pid'=>301,],
['title'=>'状态','name'=>'Kaoshi/Index/setStatus','paixu'=>4,'pid'=>301],
// 考试操作
['title'=>'分配考号','name'=>'Kaoshi/MoreAction/kaohao','paixu'=>1,'pid'=>302],
['title'=>'下载试卷标签信息','name'=>'Kaoshi/MoreAction/biaoqian','paixu'=>2,'pid'=>302],
['title'=>'下载成绩采集表','name'=>'Kaoshi/MoreAction/caiji','paixu'=>3,'pid'=>302],
['title'=>'成绩列表','name'=>'Chengji/Index/stuChengjilist','paixu'=>4,'pid'=>302],
['title'=>'成绩清除','name'=>'Chengji/Index/deletecj','paixu'=>5,'pid'=>302],
['title'=>'成绩状态','name'=>'Chengji/Index/setStatus','paixu'=>6,'pid'=>302],
['title'=>'班级成绩统计','name'=>'Chengji/Tongji/banji','paixu'=>7,'pid'=>302],
['title'=>'年级成绩统计','name'=>'Chengji/Tongji/nianji','paixu'=>8,'pid'=>302],
['title'=>'下载学生成绩','name'=>'Chengji/Tongji/dwChengji','paixu'=>9,'pid'=>302],
['title'=>'下载班级成绩统计表','name'=>'Chengji/Tongji/dwBanji','paixu'=>10,'pid'=>302],
['title'=>'下载年级成绩统计表','name'=>'Chengji/Tongji/dwNianji','paixu'=>11,'pid'=>302],
// 师生管理
// 学生管理权限
['title'=>'添加','name'=>'renshi/Student/create','paixu' =>1,'pid'=>401],
['title'=>'删除','name'=>'renshi/Student/delete','paixu'=>2,'pid'=>401],
['title'=>'编辑','name'=>'renshi/Student/edit','paixu'=>3,'pid'=>401,],
['title'=>'查看','name'=>'renshi/Student/read','paixu'=>4,'pid'=>401,],
['title'=>'状态','name'=>'renshi/Student/setStatus','paixu'=>5,'pid'=>401],
['title'=>'下载模板','name'=>'renshi/Student/download','paixu'=>6,'pid'=>401],
['title'=>'批量上传','name'=>'renshi/Student/createAll','paixu'=>7,'pid'=>401],
// 教师管理权限
['title'=>'添加','name'=>'renshi/Index/create','paixu' =>1,'pid'=>402],
['title'=>'删除','name'=>'renshi/Index/delete','paixu'=>2,'pid'=>402],
['title'=>'编辑','name'=>'renshi/Index/edit','paixu'=>3,'pid'=>402,],
['title'=>'查看','name'=>'renshi/Index/read','paixu'=>4,'pid'=>402,],
['title'=>'状态','name'=>'renshi/Index/setStatus','paixu'=>5,'pid'=>402],
// 教务管理
// 学期管理权限
['title'=>'添加','name'=>'teach/Xueqi/create','paixu' =>1,'pid'=>501],
['title'=>'删除','name'=>'teach/Xueqi/delete','paixu'=>2,'pid'=>501],
['title'=>'编辑','name'=>'teach/Xueqi/edit','paixu'=>3,'pid'=>501,],
['title'=>'查看','name'=>'teach/Xueqi/read','paixu'=>4,'pid'=>501,],
['title'=>'状态','name'=>'teach/Xueqi/setStatus','paixu'=>5,'pid'=>501],
// 班级列表权限
['title'=>'添加','name'=>'teach/Banji/create','paixu' =>1,'pid'=>502],
['title'=>'移动','name'=>'teach/Banji/yidong','paixu'=>2,'pid'=>502],
['title'=>'状态','name'=>'teach/Banji/setStatus','paixu'=>3,'pid'=>502],
// 学科列表权限
['title'=>'添加','name'=>'teach/Subject/create','paixu' =>1,'pid'=>503],
['title'=>'删除','name'=>'teach/Subject/delete','paixu'=>2,'pid'=>503],
['title'=>'编辑','name'=>'teach/Subject/edit','paixu'=>3,'pid'=>503,],
['title'=>'查看','name'=>'teach/Subject/read','paixu'=>4,'pid'=>503,],
['title'=>'状态','name'=>'teach/Subject/setStatus','paixu'=>5,'pid'=>503],
//管理员管理
// 管理员列表权限
['title'=>'添加','name'=>'admin/Index/create','paixu' =>1,'pid'=>601],
['title'=>'删除','name'=>'admin/Index/delete','paixu'=>2,'pid'=>601],
['title'=>'编辑','name'=>'admin/Index/edit','paixu'=>3,'pid'=>601,],
['title'=>'查看','name'=>'admin/Index/read','paixu'=>4,'pid'=>601,],
['title'=>'状态','name'=>'admin/Index/setStatus','paixu'=>5,'pid'=>601],
['title'=>'重置密码','name'=>'admin/Index/resetpassword','paixu' =>6,'pid'=>601],
// 权限列表权限
['title'=>'添加','name'=>'admin/AuthRule/create','paixu' =>1,'pid'=>602],
['title'=>'删除','name'=>'admin/AuthRule/delete','paixu'=>2,'pid'=>602],
['title'=>'编辑','name'=>'admin/AuthRule/edit','paixu'=>3,'pid'=>602,],
['title'=>'查看','name'=>'admin/AuthRule/read','paixu'=>4,'pid'=>602,],
['title'=>'状态','name'=>'admin/AuthRule/setStatus','paixu'=>5,'pid'=>602],
// 角色列表权限
['title'=>'添加','name'=>'admin/AuthGroup/create','paixu' =>1,'pid'=>603],
['title'=>'删除','name'=>'admin/AuthGroup/delete','paixu'=>2,'pid'=>603],
['title'=>'编辑','name'=>'admin/AuthGroup/edit','paixu'=>3,'pid'=>603,],
['title'=>'查看','name'=>'admin/AuthGroup/read','paixu'=>4,'pid'=>603,],
['title'=>'状态','name'=>'admin/AuthGroup/setStatus','paixu'=>5,'pid'=>603],
// 系统设置
// 类别管理权限
['title'=>'添加','name'=>'system/Category/create','paixu' =>1,'pid'=>701],
['title'=>'删除','name'=>'system/Category/delete','paixu'=>2,'pid'=>701],
['title'=>'编辑','name'=>'system/Category/edit','paixu'=>3,'pid'=>701,],
['title'=>'查看','name'=>'system/Category/read','paixu'=>4,'pid'=>701,],
['title'=>'状态','name'=>'system/Category/setStatus','paixu'=>5,'pid'=>701],
// 单位管理权限
['title'=>'添加','name'=>'system/School/create','paixu' =>1,'pid'=>702],
['title'=>'删除','name'=>'system/School/delete','paixu'=>2,'pid'=>702],
['title'=>'编辑','name'=>'system/School/edit','paixu'=>3,'pid'=>702,],
['title'=>'查看','name'=>'system/School/read','paixu'=>4,'pid'=>702,],
['title'=>'状态','name'=>'system/School/setStatus','paixu'=>5,'pid'=>702],
// 系统设置权限
['title'=>'编辑','name'=>'system/SystemBase/edit','paixu'=>1,'pid'=>703,],
// 荣誉管理
// 单位荣誉管理
['title'=>'添加','name'=>'rongyu/DwRongyu/create','paixu' =>1,'pid'=>801],
['title'=>'删除','name'=>'rongyu/DwRongyu/delete','paixu'=>2,'pid'=>801],
['title'=>'编辑','name'=>'rongyu/DwRongyu/edit','paixu'=>3,'pid'=>801,],
['title'=>'查看','name'=>'rongyu/DwRongyu/read','paixu'=>4,'pid'=>801,],
['title'=>'状态','name'=>'rongyu/DwRongyu/setStatus','paixu'=>5,'pid'=>801],
['title'=>'批量上传','name'=>'rongyu/DwRongyu/createAll','paixu'=>6,'pid'=>801],
// 教师荣誉册管理
['title'=>'添加','name'=>'rongyu/JsRongyu/create','paixu' =>1,'pid'=>802],
['title'=>'删除','name'=>'rongyu/JsRongyu/delete','paixu'=>2,'pid'=>802],
['title'=>'编辑','name'=>'rongyu/JsRongyu/edit','paixu'=>3,'pid'=>802,],
['title'=>'查看','name'=>'rongyu/JsRongyu/read','paixu'=>4,'pid'=>802,],
['title'=>'状态','name'=>'rongyu/JsRongyu/setStatus','paixu'=>5,'pid'=>802],
// 教师荣誉信息管理
['title'=>'添加','name'=>'rongyu/JsRongyuInfo/create','paixu' =>1,'pid'=>803],
['title'=>'删除','name'=>'rongyu/JsRongyuInfo/delete','paixu'=>2,'pid'=>803],
['title'=>'编辑','name'=>'rongyu/JsRongyuInfo/edit','paixu'=>3,'pid'=>803,],
['title'=>'查看','name'=>'rongyu/JsRongyuInfo/read','paixu'=>4,'pid'=>803,],
['title'=>'状态','name'=>'rongyu/JsRongyuInfo/setStatus','paixu'=>5,'pid'=>803],
['title'=>'批量上传','name'=>'rongyu/JsRongyuInfo/createAll','paixu'=>6,'pid'=>803],
// 课题管理
// 课题册
['title'=>'添加','name'=>'keti/index/create','paixu' =>1,'pid'=>901],
['title'=>'删除','name'=>'keti/index/delete','paixu'=>2,'pid'=>901],
['title'=>'编辑','name'=>'keti/index/edit','paixu'=>3,'pid'=>901,],
['title'=>'课题信息','name'=>'keti/ketiinfo/KetiCe','paixu'=>4,'pid'=>901,],
['title'=>'查看','name'=>'keti/index/read','paixu'=>5,'pid'=>901,],
['title'=>'状态','name'=>'keti/index/setStatus','paixu'=>6,'pid'=>901],
// 课题信息
['title'=>'添加','name'=>'ketiinfo/index/create','paixu' =>1,'pid'=>902],
['title'=>'删除','name'=>'ketiinfo/index/delete','paixu'=>2,'pid'=>902],
['title'=>'编辑','name'=>'ketiinfo/index/edit','paixu'=>3,'pid'=>902,],
['title'=>'查看','name'=>'ketiinfo/index/read','paixu'=>4,'pid'=>902,],
['title'=>'状态','name'=>'ketiinfo/index/setStatus','paixu'=>5,'pid'=>902],
['title'=>'批量上传','name'=>'ketiinfo/index/createAll','paixu'=>6,'pid'=>902],
];
// 保存数据
$this->table('auth_rule')->insert($rows)->save();
}
}