fastadmin生产代码的分析01 - 深圳全飞鸿

Execute start!
[COPY ]$\application\admin\controller\Test.php to #\application\admin\controller\Test.php
[COPY ]$\application\admin\lang\zh-cn\test.php to #\application\admin\lang\zh-cn\test.php
[COPY ]$\application\admin\model\Test.php to #\application\admin\model\Test.php
[COPY ]$\application\admin\validate\Test.php to #\application\admin\validate\Test.php
[MKDIR]$\application\admin\view\test\
[COPY ]$\application\admin\view\test\add.html to #\application\admin\view\test\add.html
[COPY ]$\application\admin\view\test\edit.html to #\application\admin\view\test\edit.html
[COPY ]$\application\admin\view\test\index.html to #\application\admin\view\test\index.html
[COPY ]$\application\admin\view\test\recyclebin.html to #\application\admin\view\test\recyclebin.html
[COPY ]$\public\assets\js\backend\test.js to #\public\assets\js\backend\test.js
Execute finish!

复制代码

namespace app\admin\validate;
use think\Validate;
class Test extends Validate
{
/**
* 验证规则
*/
protected $rule = [
];
/**
* 提示消息
*/
protected $message = [
];
/**
* 验证场景
*/
protected $scene = [
'add' => [],
'edit' => [],
];
}

复制代码

namespace app\admin\controller;
use app\common\controller\Backend;
/**
* 测试管理
*
* @icon fa fa-circle-o
*/
class Test extends Backend
{
/**
* Test模型对象
* @var \app\admin\model\Test
*/
protected $model = null;
public function _initialize()
{
parent::_initialize();
$this->model = new \app\admin\model\Test;
$this->view->assign("weekList", $this->model->getWeekList());
$this->view->assign("flagList", $this->model->getFlagList());
$this->view->assign("genderdataList", $this->model->getGenderdataList());
$this->view->assign("hobbydataList", $this->model->getHobbydataList());
$this->view->assign("statusList", $this->model->getStatusList());
$this->view->assign("stateList", $this->model->getStateList());
}
/**
* 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
* 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
* 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
*/
}

复制代码

<?php
namespace app\admin\model;
use think\Model;
use traits\model\SoftDelete;
class Test extends Model
{
use SoftDelete;
// 表名
protected $name = 'test';
// 自动写入时间戳字段
protected $autoWriteTimestamp = 'integer';
// 定义时间戳字段名
protected $createTime = 'createtime';
protected $updateTime = 'updatetime';
protected $deleteTime = 'deletetime';
// 追加属性
protected $append = [
'week_text',
'flag_text',
'genderdata_text',
'hobbydata_text',
'refreshtime_text',
'status_text',
'state_text'
];
protected static function init()
{
self::afterInsert(function ($row) {
if (!$row['weigh']) {
$pk = $row->getPk();
$row->getQuery()->where($pk, $row[$pk])->update(['weigh' => $row[$pk]]);
}
});
}
public function getWeekList()
{
return ['monday' => __('Week monday'), 'tuesday' => __('Week tuesday'), 'wednesday' => __('Week wednesday')];
}
public function getFlagList()
{
return ['hot' => __('Flag hot'), 'index' => __('Flag index'), 'recommend' => __('Flag recommend')];
}
public function getGenderdataList()
{
return ['male' => __('Genderdata male'), 'female' => __('Genderdata female')];
}
public function getHobbydataList()
{
return ['music' => __('Hobbydata music'), 'reading' => __('Hobbydata reading'), 'swimming' => __('Hobbydata swimming')];
}
public function getStatusList()
{
return ['normal' => __('Normal'), 'hidden' => __('Hidden')];
}
public function getStateList()
{
return ['0' => __('State 0'), '1' => __('State 1'), '2' => __('State 2')];
}
public function getWeekTextAttr($value, $data)
{
$value = $value ? $value : (isset($data['week']) ? $data['week'] : '');
$list = $this->getWeekList();
return isset($list[$value]) ? $list[$value] : '';
}
public function getFlagTextAttr($value, $data)
{
$value = $value ?: ($data['flag'] ?? '');
$valueArr = explode(',', $value);
$list = $this->getFlagList();
return implode(',', array_intersect_key($list, array_flip($valueArr)));
}
public function getGenderdataTextAttr($value, $data)
{
$value = $value ? $value : (isset($data['genderdata']) ? $data['genderdata'] : '');
$list = $this->getGenderdataList();
return isset($list[$value]) ? $list[$value] : '';
}
public function getHobbydataTextAttr($value, $data)
{
$value = $value ? $value : (isset($data['hobbydata']) ? $data['hobbydata'] : '');
$valueArr = explode(',', $value);
$list = $this->getHobbydataList();
return implode(',', array_intersect_key($list, array_flip($valueArr)));
}
public function getRefreshtimeTextAttr($value, $data)
{
$value = $value ? $value : (isset($data['refreshtime']) ? $data['refreshtime'] : '');
return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
}
public function getStatusTextAttr($value, $data)
{
$value = $value ? $value : (isset($data['status']) ? $data['status'] : '');
$list = $this->getStatusList();
return isset($list[$value]) ? $list[$value] : '';
}
public function getStateTextAttr($value, $data)
{
$value = $value ? $value : (isset($data['state']) ? $data['state'] : '');
$list = $this->getStateList();
return isset($list[$value]) ? $list[$value] : '';
}
protected function setFlagAttr($value)
{
return is_array($value) ? implode(',', $value) : $value;
}
protected function setHobbydataAttr($value)
{
return is_array($value) ? implode(',', $value) : $value;
}
protected function setRefreshtimeAttr($value)
{
return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
}
}

复制代码

define(['jquery', 'bootstrap', 'backend', 'table', 'form'], function ($, undefined, Backend, Table, Form) {
var Controller = {
index: function () {
// 初始化表格参数配置
Table.api.init({
extend: {
index_url: 'test/index' + location.search,
add_url: 'test/add',
edit_url: 'test/edit',
del_url: 'test/del',
multi_url: 'test/multi',
import_url: 'test/import',
table: 'test',
}
});
var table = $("#table");
// 初始化表格
table.bootstrapTable({
url: $.fn.bootstrapTable.defaults.extend.index_url,
pk: 'id',
sortName: 'weigh',
fixedColumns: true,
fixedRightNumber: 1,
columns: [
[
{checkbox: true},
{field: 'id', title: __('Id')},
{field: 'user_id', title: __('User_id')},
{field: 'admin_id', title: __('Admin_id')},
{field: 'category_id', title: __('Category_id')},
{field: 'category_ids', title: __('Category_ids'), operate: 'LIKE'},
{field: 'tags', title: __('Tags'), operate: 'LIKE', formatter: Table.api.formatter.flag},
{field: 'week', title: __('Week'), searchList: {"monday":__('Week monday'),"tuesday":__('Week tuesday'),"wednesday":__('Week wednesday')}, formatter: Table.api.formatter.normal},
{field: 'flag', title: __('Flag'), searchList: {"hot":__('Flag hot'),"index":__('Flag index'),"recommend":__('Flag recommend')}, operate:'FIND_IN_SET', formatter: Table.api.formatter.label},
{field: 'genderdata', title: __('Genderdata'), searchList: {"male":__('Genderdata male'),"female":__('Genderdata female')}, formatter: Table.api.formatter.normal},
{field: 'hobbydata', title: __('Hobbydata'), searchList: {"music":__('Hobbydata music'),"reading":__('Hobbydata reading'),"swimming":__('Hobbydata swimming')}, operate:'FIND_IN_SET', formatter: Table.api.formatter.label},
{field: 'title', title: __('Title'), operate: 'LIKE'},
{field: 'image', title: __('Image'), operate: false, events: Table.api.events.image, formatter: Table.api.formatter.image},
{field: 'images', title: __('Images'), operate: false, events: Table.api.events.image, formatter: Table.api.formatter.images},
{field: 'attachfile', title: __('Attachfile'), operate: false, formatter: Table.api.formatter.file},
{field: 'keywords', title: __('Keywords'), operate: 'LIKE', table: table, class: 'autocontent', formatter: Table.api.formatter.content},
{field: 'description', title: __('Description'), operate: 'LIKE', table: table, class: 'autocontent', formatter: Table.api.formatter.content},
{field: 'city', title: __('City'), operate: 'LIKE'},
{field: 'price', title: __('Price'), operate:'BETWEEN'},
{field: 'views', title: __('Views')},
{field: 'workrange', title: __('Workrange'), operate: 'LIKE'},
{field: 'startdate', title: __('Startdate'), operate:'RANGE', addclass:'datetimerange', autocomplete:false},
{field: 'activitytime', title: __('Activitytime'), operate:'RANGE', addclass:'datetimerange', autocomplete:false},
{field: 'year', title: __('Year')},
{field: 'times', title: __('Times')},
{field: 'refreshtime', title: __('Refreshtime'), operate:'RANGE', addclass:'datetimerange', autocomplete:false, formatter: Table.api.formatter.datetime},
{field: 'createtime', title: __('Createtime'), operate:'RANGE', addclass:'datetimerange', autocomplete:false, formatter: Table.api.formatter.datetime},
{field: 'updatetime', title: __('Updatetime'), operate:'RANGE', addclass:'datetimerange', autocomplete:false, formatter: Table.api.formatter.datetime},
{field: 'weigh', title: __('Weigh'), operate: false},
{field: 'switch', title: __('Switch'), searchList: {"1":__('Yes'),"0":__('No')}, table: table, formatter: Table.api.formatter.toggle},
{field: 'status', title: __('Status'), searchList: {"normal":__('Normal'),"hidden":__('Hidden')}, formatter: Table.api.formatter.status},
{field: 'state', title: __('State'), searchList: {"0":__('State 0'),"1":__('State 1'),"2":__('State 2')}, formatter: Table.api.formatter.normal},
{field: 'operate', title: __('Operate'), table: table, events: Table.api.events.operate, formatter: Table.api.formatter.operate}
]
]
});
// 为表格绑定事件
Table.api.bindevent(table);
},
recyclebin: function () {
// 初始化表格参数配置
Table.api.init({
extend: {
'dragsort_url': ''
}
});
var table = $("#table");
// 初始化表格
table.bootstrapTable({
url: 'test/recyclebin' + location.search,
pk: 'id',
sortName: 'id',
columns: [
[
{checkbox: true},
{field: 'id', title: __('Id')},
{field: 'title', title: __('Title'), align: 'left'},
{
field: 'deletetime',
title: __('Deletetime'),
operate: 'RANGE',
addclass: 'datetimerange',
formatter: Table.api.formatter.datetime
},
{
field: 'operate',
width: '140px',
title: __('Operate'),
table: table,
events: Table.api.events.operate,
buttons: [
{
name: 'Restore',
text: __('Restore'),
classname: 'btn btn-xs btn-info btn-ajax btn-restoreit',
icon: 'fa fa-rotate-left',
url: 'test/restore',
refresh: true
},
{
name: 'Destroy',
text: __('Destroy'),
classname: 'btn btn-xs btn-danger btn-ajax btn-destroyit',
icon: 'fa fa-times',
url: 'test/destroy',
refresh: true
}
],
formatter: Table.api.formatter.operate
}
]
]
});
// 为表格绑定事件
Table.api.bindevent(table);
},
add: function () {
Controller.api.bindevent();
},
edit: function () {
Controller.api.bindevent();
},
api: {
bindevent: function () {
Form.api.bindevent($("form[role=form]"));
}
}
};
return Controller;
});

复制代码

SHOW TABLE STATUS LIKE 'test'
SHOW TABLE STATUS LIKE 'test'
SHOW TABLE STATUS LIKE 'fa_test'
SHOW TABLE STATUS LIKE 'fa_test'
SELECT * FROM `information_schema`.`columns` WHERE TABLE_SCHEMA = 'sfc' AND table_name = 'fa_test' ORDER BY ORDINAL_POSITION
root@192.168.1.253 on sfc using TCP/IP
SHOW COLUMNS FROM `fa_user`
SHOW COLUMNS FROM `fa_user`
SHOW COLUMNS FROM `fa_category`
SHOW COLUMNS FROM `fa_category`
root@192.168.1.253 on sfc using TCP/IP
SHOW COLUMNS FROM `fa_auth_rule`
SHOW COLUMNS FROM `fa_auth_rule`
SELECT * FROM `fa_auth_rule` WHERE `name` = 'test' LIMIT 1
SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'test/index' LIMIT 1
SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'test/recyclebin' LIMIT 1
SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'test/add' LIMIT 1
SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'test/edit' LIMIT 1
SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'test/del' LIMIT 1
SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'test/destroy' LIMIT 1
SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'test/restore' LIMIT 1
SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'test/multi' LIMIT 1
START TRANSACTION
UPDATE `fa_auth_rule` SET `pid`=85,`name`='test/index',`icon`='fa fa-circle-o',`title`='查看',`ismenu`=0,`status`='normal',`py`='zk',`pinyin`='zhakan',`updatetime`=1737130948 WHERE `id` = 86
UPDATE `fa_auth_rule` SET `pid`=85,`name`='test/recyclebin',`icon`='fa fa-circle-o',`title`='回收站',`ismenu`=0,`status`='normal',`py`='hsz',`pinyin`='huishouzhan',`updatetime`=1737130948 WHERE `id` = 87
UPDATE `fa_auth_rule` SET `pid`=85,`name`='test/add',`icon`='fa fa-circle-o',`title`='添加',`ismenu`=0,`status`='normal',`py`='tj',`pinyin`='tianjia',`updatetime`=1737130948 WHERE `id` = 88
UPDATE `fa_auth_rule` SET `pid`=85,`name`='test/edit',`icon`='fa fa-circle-o',`title`='编辑',`ismenu`=0,`status`='normal',`py`='bj',`pinyin`='bianji',`updatetime`=1737130948 WHERE `id` = 89
UPDATE `fa_auth_rule` SET `pid`=85,`name`='test/del',`icon`='fa fa-circle-o',`title`='删除',`ismenu`=0,`status`='normal',`py`='sc',`pinyin`='shanchu',`updatetime`=1737130948 WHERE `id` = 90
UPDATE `fa_auth_rule` SET `pid`=85,`name`='test/destroy',`icon`='fa fa-circle-o',`title`='真实删除',`ismenu`=0,`status`='normal',`py`='zssc',`pinyin`='zhenshishanchu',`updatetime`=1737130948 WHERE `id` = 91
UPDATE `fa_auth_rule` SET `pid`=85,`name`='test/restore',`icon`='fa fa-circle-o',`title`='还原',`ismenu`=0,`status`='normal',`py`='hy',`pinyin`='huanyuan',`updatetime`=1737130948 WHERE `id` = 92
UPDATE `fa_auth_rule` SET `pid`=?,`name`=?,`icon`=?,`title`=?,`ismenu`=?,`status`=?,`py`=?,`pinyin`=?,`updatetime`=? WHERE `id` = ?
UPDATE `fa_auth_rule` SET `pid`=85,`name`='test/multi',`icon`='fa fa-circle-o',`title`='批量更新',`ismenu`=0,`status`='normal',`py`='plgx',`pinyin`='pilianggengxin',`updatetime`=1737130948 WHERE `id` = 93
COMMIT

复制代码