ak-design可视化低代码快速开发平台，使用基于vue3.x桌面端组件库 Elemnet-Plus，通过可视化的.zip

-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- 主机： 127.0.0.1 -- 生成日期： 2023-10-10 08:59:03 -- 服务器版本： 10.4.27-MariaDB -- PHP 版本： 8.2.0 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- 数据库： `akform` -- -- -------------------------------------------------------- -- -- 表的结构 `ak-customer` -- CREATE TABLE `ak-customer` ( `id` int(10) NOT NULL, `name` varchar(50) NOT NULL, `phone` varchar(11) DEFAULT NULL, `weixin` varchar(50) DEFAULT NULL, `creatTime` datetime DEFAULT NULL, `company` varchar(50) DEFAULT NULL, `status` int(2) NOT NULL, `remark` varchar(100) DEFAULT NULL, `intention` int(2) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='客户信息管理'; -- -- 转存表中的数据 `ak-customer` -- INSERT INTO `ak-customer` (`id`, `name`, `phone`, `weixin`, `creatTime`, `company`, `status`, `remark`, `intention`) VALUES (1, '客户名称', '13800138000', '337547038', '0000-00-00 00:00:00', '', 1, '', 1); -- -------------------------------------------------------- -- -- 表的结构 `ak-holidays` -- CREATE TABLE `ak-holidays` ( `id` int(10) NOT NULL, `type` int(2) NOT NULL, `startTime` datetime NOT NULL, `endTime` datetime NOT NULL, `duration` varchar(20) NOT NULL, `remark` varchar(200) DEFAULT NULL, `files` varchar(200) DEFAULT NULL, `creatTime` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='请假流程'; -- -- 转存表中的数据 `ak-holidays` -- INSERT INTO `ak-holidays` (`id`, `type`, `startTime`, `endTime`, `duration`, `remark`, `files`, `creatTime`) VALUES (9, 1, '2023-09-30 16:00:00', '2023-10-04 16:00:00', '4天', '请假事由', '', '0000-00-00 00:00:00'), (10, 2, '2023-09-30 08:00:00', '2023-10-06 08:00:00', '6天', '请假事由请假事由', '', '2023-10-09 01:44:04'); -- -------------------------------------------------------- -- -- 表的结构 `ak-test` -- CREATE TABLE `ak-test` ( `id` int(10) NOT NULL, `text` varchar(50) DEFAULT NULL, `textarea` varchar(50) DEFAULT NULL, `radio` int(1) DEFAULT NULL, `checkbox` varchar(50) DEFAULT NULL, `select1` varchar(50) DEFAULT NULL, `creatTime` datetime DEFAULT NULL, `color` varchar(10) DEFAULT NULL, `status` int(1) DEFAULT NULL, `number` int(1) DEFAULT NULL, `cascader` varchar(50) DEFAULT NULL, `rate` int(2) DEFAULT NULL, `slider` varchar(10) DEFAULT NULL, `tree` varchar(10) DEFAULT NULL, `table` varchar(50) DEFAULT NULL, `components` varchar(50) DEFAULT NULL, `upload` varchar(100) DEFAULT NULL, `tinymce` text DEFAULT NULL, `flex` varchar(50) DEFAULT NULL, `userName` varchar(50) DEFAULT NULL, `prepend` varchar(50) DEFAULT NULL, `append` varchar(50) DEFAULT NULL, `password` varchar(50) DEFAULT NULL, `input1` varchar(50) DEFAULT NULL, `input2` int(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='组件字段示例'; -- -- 转存表中的数据 `ak-test` -- INSERT INTO `ak-test` (`id`, `text`, `textarea`, `radio`, `checkbox`, `select1`, `creatTime`, `color`, `status`, `number`, `cascader`, `rate`, `slider`, `tree`, `table`, `components`, `upload`, `tinymce`, `flex`, `userName`, `prepend`, `append`, `password`, `input1`, `input2`) VALUES (1, '单行文本', '多行文本', 1, '1', '10', '2024-11-29 08:00:00', '#741010', 1, 1, '[]', 3, '30', '', '[]', '广东省广州市越秀区北京街道广州市人民政府', '/uploads/1681437452608-data.png', '<p>富文本内容</p>', '[{\"f1\":\"姓名1\",\"f2\":\"13800138000\"}]', 'user,admin', '1', '', '123', '1', 0); -- -------------------------------------------------------- -- -- 表的结构 `datasource` -- CREATE TABLE `datasource` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL COMMENT '数据源名称', `tableName` varchar(50) NOT NULL COMMENT '表名', `category` int(4) NOT NULL COMMENT '分类', `status` int(1) NOT NULL, `creatDate` datetime DEFAULT NULL, `updateDate` datetime DEFAULT NULL, `creatName` varchar(50) NOT NULL, `updateName` varchar(50) NOT NULL COMMENT '最后修改人', `remark` varchar(50) NOT NULL COMMENT '表注释', `tableData` text NOT NULL COMMENT '表结构数据' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='数据源表'; -- -- 转存表中的数据 `datasource` -- INSERT INTO `datasource` (`id`, `name`, `tableName`, `category`, `status`, `creatDate`, `updateDate`, `creatName`, `updateName`, `remark`, `tableData`) VALUES (12, '组件字段示例', 'ak-test', 0, 1, NULL, NULL, 'admin', '', '组件字段示例', '[\r\n {\r\n \"label\": \"单行文本\",\r\n \"name\": \"text\",\r\n \"type\": \"VARCHAR\",\r\n \"length\": \"50\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"多行文本\",\r\n \"name\": \"textarea\",\r\n \"type\": \"VARCHAR\",\r\n \"length\": \"50\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"单选组\",\r\n \"name\": \"radio\",\r\n \"type\": \"INT\",\r\n \"length\": \"1\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"多选组\",\r\n \"name\": \"checkbox\",\r\n \"type\": \"VARCHAR\",\r\n \"length\": \"50\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"下拉选择\",\r\n \"name\": \"select1\",\r\n \"type\": \"VARCHAR\",\r\n \"length\": \"50\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"时间\",\r\n \"name\": \"creatTime\",\r\n \"type\": \"DATETIME\",\r\n \"length\": \"\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"取色器\",\r\n \"name\": \"color\",\r\n \"type\": \"VARCHAR\",\r\n \"length\": \"10\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"状态开关\",\r\n \"name\": \"status\",\r\n \"type\": \"INT\",\r\n \"length\": \"1\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"计时器\",\r\n \"name\": \"number\",\r\n \"type\": \"INT\",\r\n \"length\": \"1\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"级联\",\r\n \"name\": \"cascader\",\r\n \"type\": \"VARCHAR\",\r\n \"length\": \"50\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"评分\",\r\n \"name\": \"rate\",\r\n \"type\": \"INT\",\r\n \"length\": \"2\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"滑块\",\r\n \"name\": \"slider\",\r\n \"type\": \"VARCHAR\",\r\n \"length\": \"10\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n \"enterable\": true\r\n },\r\n {\r\n \"label\": \"树形控件\",\r\n \"name\": \"tree\",\r\n \"type\": \"VARCHAR\",\r\n \"length\": \"10\",\r\n \"default\": \"\",\r\n \"empty\": false,\r\n \"remark\": \"\",\r\n