点击回首页
我的浏览记录 | | 帮助?
当前位置:
首页>> 企业应用>> 新翔网络OA系统V1.0>> 源文件浏览
[商业版 200RMB] WebForm,下载次数:1 次 | 关键字: PHP MYSQL OA 办公 网络办公

源码截图

源码目录树

;
当前路径: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>&nbsp;</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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><span lang=\"EN-US\"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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:...
完整源码文件,请先购买后再查看
关于我们 | 顾问团队 | 发展历程 | 联系我们 | 源码上传
联系电话(Tel):4008-010-151(免长途)
地址:北京市海淀区大恒科技大厦五层 邮编:100080
Floor 5th,Daheng Building,Zhongguancun,Beijing,China,100080
51Aspx.com 版权所有 CopyRight © 2006-2022. 京ICP备09089570号 | 京公网安备11010702000869号