当前路径：db_oasystem.sql -- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- 主机： localhost -- 生成日期： 2021-07-12 16:11:28 -- 服务器版本： 5.7.26 -- PHP 版本： 7.3.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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 */; -- -- 数据库： `db_oasystem` -- -- -------------------------------------------------------- -- -- 表的结构 `tb_beiwang` -- CREATE TABLE `tb_beiwang` ( `id` int(11) NOT NULL, `userid` int(11) DEFAULT '0', `addtime` datetime DEFAULT NULL, `shijian` datetime DEFAULT NULL, `neirong` varchar(500) DEFAULT NULL, `isread` int(11) DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `tb_beiwang` -- INSERT INTO `tb_beiwang` (`id`, `userid`, `addtime`, `shijian`, `neirong`, `isread`) VALUES (1, 0, '2021-01-26 00:00:00', '2021-01-28 00:00:00', '测试软件', 1), (2, 0, '2021-01-26 00:00:00', '2021-01-30 00:00:00', '交付软件', 1), (3, 0, '2021-02-01 00:00:00', '2021-02-24 00:00:00', '内部测试', 0); -- -------------------------------------------------------- -- -- 表的结构 `tb_danwei` -- CREATE TABLE `tb_danwei` ( `id` int(11) NOT NULL, `bianhao` int(11) DEFAULT '0', `danwei` varchar(50) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `tb_danwei` -- INSERT INTO `tb_danwei` (`id`, `bianhao`, `danwei`) VALUES (1, 1, '土右站'), (2, 2, '人事科'), (3, 3, '财务科'), (4, 4, '后勤部'), (6, 5, '运销科'); -- -------------------------------------------------------- -- -- 表的结构 `tb_juese` -- CREATE TABLE `tb_juese` ( `id` int(11) NOT NULL, `bianhao` int(11) DEFAULT NULL, `juese` varchar(50) DEFAULT NULL, `quanxian` tinyint(3) NOT NULL DEFAULT '2', `menuid` varchar(1000) DEFAULT '', `beizhu` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `tb_juese` -- INSERT INTO `tb_juese` (`id`, `bianhao`, `juese`, `quanxian`, `menuid`, `beizhu`) VALUES (1, 1, '超级管理员', 0, '', ''), (3, 2, '管理角色', 1, '2,36,37,18,19,20,23,24,25,27,28,29', ''), (4, 2, '一般管理员', 1, '2,36,37,18,19,20,11', ''); -- -------------------------------------------------------- -- -- 表的结构 `tb_manage` -- CREATE TABLE `tb_manage` ( `id` int(11) NOT NULL, `loginname` varchar(50) DEFAULT NULL, `pwd` varchar(50) DEFAULT NULL, `userxm` varchar(50) DEFAULT NULL, `xb` varchar(5) DEFAULT NULL, `minzu` varchar(20) DEFAULT NULL, `csny` date DEFAULT NULL, `nianling` int(11) DEFAULT NULL, `mianmaoid` int(11) DEFAULT '0', `card` varchar(18) DEFAULT NULL, `gzny` date DEFAULT NULL, `danweiid` int(11) DEFAULT NULL, `zhiwuid` int(11) DEFAULT '0', `zhuzhi` varchar(100) DEFAULT NULL, `tel` varchar(50) DEFAULT NULL, `guhua` varchar(50) DEFAULT NULL, `qita` varchar(50) DEFAULT NULL, `qq` varchar(20) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `jinji` varchar(20) DEFAULT NULL, `beizhu` varchar(255) DEFAULT NULL, `xueliid` int(11) DEFAULT '0', `jueseid` int(11) DEFAULT '0', `mudidi` varchar(50) DEFAULT NULL, `hunyin` varchar(50) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `tb_manage` -- INSERT INTO `tb_manage` (`id`, `loginname`, `pwd`, `userxm`, `xb`, `minzu`, `csny`, `nianling`, `mianmaoid`, `card`, `gzny`, `danweiid`, `zhiwuid`, `zhuzhi`, `tel`, `guhua`, `qita`, `qq`, `email`, `jinji`, `beizhu`, `xueliid`, `jueseid`, `mudidi`, `hunyin`) VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '女', '汉族', '1980-11-08', NULL, 9, '412726198011081616', '2016-05-01', 1, 19, '河南周口', '13849422648', '0394-3531363', '', '958756413', 'djlhf@163.com', '15993212865', '', 14, 1, '河南郑州', '已婚'), (2, '000001', 'E10ADC3949BA59ABBE56E057F20F883E', '张学友', '男', '汉族', '1985-01-26', NULL, 8, '412726198501261633', '2015-12-20', 1, 18, '', '13522226666', '', '', '', '', '', '', 13, 3, '深圳', '未婚'), (3, '50166442', 'E10ADC3949BA59ABBE56E057F20F883E', '张永耀', '男', '汉族', '1986-10-17', NULL, 10, '130684198610170011', '1986-10-17', 6, 18, '陕西西安', '18691885933', '04713268306', '', '57469263', '', '', '', 16, 3, '', '已婚'); -- -------------------------------------------------------- -- -- 表的结构 `tb_menu` -- CREATE TABLE `tb_menu` ( `id` int(11) NOT NULL, `pid` int(11) DEFAULT '0', `px` varchar(255) DEFAULT NULL, `menu` varchar(255) DEFAULT NULL, `icon` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `tb_menu` -- INSERT INTO `tb_menu` (`id`, `pid`, `px`, `menu`, `icon`, `url`) VALUES (1, 0, '1', '系统管理', '', ''), (2, 0, '2', '业务管理', '', ''), (3, 1, '1', '单位管理', NULL, 'system/danwei.php'), (4, 1, '2', '管理员管理', NULL, 'system/manage.php'), (5, 1, '3', '字典管理', NULL, 'system/zidian.php'), (27, 0, '4', '请假管理', '', ''), (10, 1, '1', '菜单管理', '', 'system/menu.php'), (11, 2, '7', '任务记录', '', 'manage/renwu.php'), (12, 1, '1', '角色管理', '', 'system/juese.php'), (35, 31, '2', '备忘记录', '', 'manage/beiwang.php'), (31, 0, '5', '其他管理', '', ''), (33, 31, '3', '联系电话', '', 'manage/tongxunlu.php'), (36, 2, '1', '发起任务', '', 'manage/renwu_faqi.php'), (18, 2, '3', '任务分类', '', 'manage/renwu_fenlei.php'), (19, 2, '4', '问题清单', '', 'manage/renwu_wenti.php'), (20, 2, '5', '工作状态', '', 'manage/renwu_zhuangtai.php'), (23, 0, '3', '印章管理', '', ''), (24, 23, '1', '使用申请', '', 'manage/yinzhang_self.php'), (25, 23, '2', '印章审批', '', 'manage/yinzhang_shen.php'), (26, 23, '3', '使用查询', '', 'manage/yinzhang.php'), (28, 27, '1', '请假申请', '', 'manage/qingjia_self.php'), (29, 27, '4', '请假审批', '', 'manage/qingjia_shen.php'), (30, 27, '4', '请假查询', '', 'manage/qingjia.php'), (37, 2, '2', '任务发布', '', 'manage/renwu_fabu.php'); -- -------------------------------------------------------- -- -- 表的结构 `tb_muban` -- CREATE TABLE `tb_muban` ( `id` int(11) NOT NULL, `bianhao` int(11) DEFAULT NULL, `title` varchar(50) DEFAULT NULL, `content` text ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `tb_muban` -- INSERT INTO `tb_muban` (`id`, `bianhao`, `title`, `content`) VALUES (1, 1, '用章审批表', '<p class=\"MsoNormal\" style=\"text-indent:244.8pt;mso-char-indent-count:18.0;\nline-height:26.0pt\"><a name=\"_GoBack\"></a><span lang=\"EN-US\" style=\"font-size:\n14.0pt;mso-fareast-font-family:仿宋_GB2312;letter-spacing:-.2pt\">BFGDGS/ZJB.18-2018/JL-02<o:p></o:p></span></p><p class=\"MsoNormal\" align=\"center\"><span lang=\"EN-US\"><o:p> </o:p></span></p><p class=\"MsoNormal\" align=\"center\"><span>所属单位用章（科级）审批单</span><span lang=\"EN-US\"><o:p></o:p></span></p><p class=\"MsoNormal\"><span lang=\"EN-US\"><span> </span></span><span lang=\"EN-US\"><span> </span></span><span lang=\"EN-US\">NO.3<o:p></o:p></span></p><div align=\"center\">\n\n<table class=\"MsoNormalTable\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-collapse:collapse;mso-table-layout-alt:fixed;border:none;\n mso-border-alt:solid windowtext .5pt;mso-yfti-tbllook:1184;mso-padding-alt:\n 0cm 5.4pt 0cm 5.4pt;mso-border-insideh:.5pt solid windowtext;mso-border-insidev:\n .5pt solid windowtext\">\n <tbody><tr>\n <td width=\"119\" style=\"width:89.2pt;border:solid windowtext 1.0pt;mso-border-alt:\n solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.3pt\">\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span style=\"font-family:方正仿宋简体;mso-bidi-font-family:\n 方正仿宋简体;color:black\">单位名称</span><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:p></o:p></span></p>\n </td>\n <td width=\"216\" colspan=\"3\" style=\"width:162.15pt;border:solid windowtext 1.0pt;\n border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:\n solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.3pt\">\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:p> </o:p></span></p>\n </td>\n <td width=\"129\" style=\"width:96.9pt;border:solid windowtext 1.0pt;border-left:\n none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;\n padding:0cm 5.4pt 0cm 5.4pt;height:25.3pt\">\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span style=\"font-family:方正仿宋简体;mso-bidi-font-family:\n 方正仿宋简体;color:black\">申请时间</span><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:p></o:p></span></p>\n </td>\n <td width=\"93\" style=\"width:69.4pt;border:solid windowtext 1.0pt;border-left:\n none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;\n padding:0cm 5.4pt 0cm 5.4pt;height:25.3pt\">\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:p> </o:p></span></p>\n </td>\n </tr>\n <tr>\n <td width=\"119\" style=\"width:89.2pt;border:solid windowtext 1.0pt;border-top:\n none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;\n padding:0cm 5.4pt 0cm 5.4pt;height:25.3pt\">\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span style=\"font-family:方正仿宋简体;mso-bidi-font-family:\n 方正仿宋简体;color:black\">经 办 人</span><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:p></o:p></span></p>\n </td>\n <td width=\"438\" colspan=\"5\" style=\"width:328.45pt;border-top:none;border-left:\n none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;\n mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;\n mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:25.3pt\">\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:p> </o:p></span></p>\n </td>\n </tr>\n <tr>\n <td width=\"120\" colspan=\"2\" valign=\"top\" style=\"width:89.85pt;border:solid windowtext 1.0pt;\n border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;\n padding:0cm 5.4pt 0cm 5.4pt;height:234.65pt\">\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:p> </o:p></span></p>\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:p> </o:p></span></p>\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:p> </o:p></span></p>\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:p> </o:p></span></p>\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:p> </o:p></span></p>\n <p class=\"MsoNormal\" align=\"center\" style=\"text-align:center;line-height:16.0pt;\n mso-line-height-rule:exactly\"><span style=\"font-family:方正仿宋简体;mso-bidi-font-family:\n 方正仿宋简体;color:black\">事</span><span lang=\"EN-US\" style=\"font-family:方正仿宋简体;\n color:black\"><o:...
完整源码文件，请先购买后再查看
相关源码
- 基于SPRINGBOOT质量管理系统2023-12-06
- 基于SPRINGBOOT小学教学辅助平台2023-12-05
- 基于SSM实体专辑购物系统2023-12-04
- 电器设备企业网站模板源码2023-11-16
- PYTHON基于网络爬虫的的个性化新闻推荐系统(含论文)源码2023-10-07
- JAVA_SSM农产品仓库管理系统源码(含论文)源码2023-10-07
关于我们 | 顾问团队 | 发展历程 | 联系我们 | 源码上传
联系电话(Tel)：4008-010-151(免长途)
地址：北京市海淀区大恒科技大厦五层 邮编：100080
Floor 5th,Daheng Building,Zhongguancun,Beijing,China,100080
51Aspx.com 版权所有 CopyRight © 2006-2023. 京ICP备09089570号 | 京公网安备11010702000869号
联系电话(Tel)：4008-010-151(免长途)
地址：北京市海淀区大恒科技大厦五层 邮编：100080
Floor 5th,Daheng Building,Zhongguancun,Beijing,China,100080
51Aspx.com 版权所有 CopyRight © 2006-2023. 京ICP备09089570号 | 京公网安备11010702000869号