Home Esplora Aiuto
Accedi
dever-product
/
churen
2
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): 02d547305a
Rami (Branch) Tag
churen
/
churen.sql

churen.sql 49 KB
Cronologia Originale

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377 
  1. -- phpMyAdmin SQL Dump
    2. 

  2. -- version 4.8.3
    3. 

  3. -- https://www.phpmyadmin.net/
    4. 

  4. --
    5. 

  5. -- 主机： web-mysql
    6. 

  6. -- 生成日期： 2022-02-16 06:32:06
    7. 

  7. -- 服务器版本： 10.1.32-MariaDB
    8. 

  8. -- PHP 版本： 7.3.22
    9. 

  9. 

  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
    11. 

  11. SET AUTOCOMMIT = 0;
    12. 

  12. START TRANSACTION;
    13. 

  13. SET time_zone = "+00:00";
    14. 

  14. 

  15. 

  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    17. 

  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    18. 

  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    19. 

  19. /*!40101 SET NAMES utf8mb4 */;
    20. 

  20. 

  21. --
    22. 

  22. -- 数据库： `churen`
    23. 

  23. --
    24. 

  24. CREATE DATABASE IF NOT EXISTS `churen` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
    25. 

  25. USE `churen`;
    26. 

  26. 

  27. -- --------------------------------------------------------
    28. 

  28. 

  29. --
    30. 

  30. -- 表的结构 `churen_manage_group`
    31. 

  31. --
    32. 

  32. 

  33. DROP TABLE IF EXISTS `churen_manage_group`;
    34. 

  34. CREATE TABLE `churen_manage_group` (
    35. 

  35.   `id` int(11) UNSIGNED NOT NULL COMMENT '组ID',
    36. 

  36.   `name` varchar(50) DEFAULT NULL COMMENT '组名称',
    37. 

  37.   `area` varchar(255) DEFAULT NULL COMMENT '区域',
    38. 

  38.   `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
    39. 

  39.   `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间'
    40. 

  40. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    41. 

  41. 

  42. --
    43. 

  43. -- 转存表中的数据 `churen_manage_group`
    44. 

  44. --
    45. 

  45. 

  46. INSERT INTO `churen_manage_group` (`id`, `name`, `area`, `state`, `cdate`) VALUES
    47. 

  47. (1, '默认分组', NULL, 1, 1634207050);
    48. 

  48. 

  49. -- --------------------------------------------------------
    50. 

  50. 

  51. --
    52. 

  52. -- 表的结构 `churen_manage_menu`
    53. 

  53. --
    54. 

  54. 

  55. DROP TABLE IF EXISTS `churen_manage_menu`;
    56. 

  56. CREATE TABLE `churen_manage_menu` (
    57. 

  57.   `id` int(11) UNSIGNED NOT NULL COMMENT '菜单ID',
    58. 

  58.   `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
    59. 

  59.   `group_id` int(11) NOT NULL DEFAULT '1' COMMENT '选择分组',
    60. 

  60.   `menu_id` int(11) NOT NULL DEFAULT '-1' COMMENT '上级菜单',
    61. 

  61.   `menu` varchar(800) DEFAULT NULL COMMENT '上级菜单',
    62. 

  62.   `key` varchar(100) DEFAULT NULL COMMENT '菜单标识-选填，可以为空，用来标识菜单的唯一性',
    63. 

  63.   `link` varchar(150) DEFAULT NULL COMMENT '链接(或路径)-选填，可以为空',
    64. 

  64.   `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
    65. 

  65.   `type` tinyint(1) NOT NULL DEFAULT '2' COMMENT '开启子菜单',
    66. 

  66.   `icon` varchar(100) DEFAULT NULL COMMENT '图标代码-请<A HREF="HTTPS://WWW.LAYUI.COM/DOC/ELEMENT/ICON.HTML" TARGET="_BLANK">点此</A>查看图标代码',
    67. 

  67.   `fast` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否快捷菜单',
    68. 

  68.   `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
    69. 

  69.   `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间'
    70. 

  70. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    71. 

  71. 

  72. --
    73. 

  73. -- 转存表中的数据 `churen_manage_menu`
    74. 

  74. --
    75. 

  75. 

  76. INSERT INTO `churen_manage_menu` (`id`, `name`, `group_id`, `menu_id`, `menu`, `key`, `link`, `reorder`, `type`, `icon`, `fast`, `state`, `cdate`) VALUES
    77. 

  77. (1, '主页', 1, -1, '-1', 'console', 'console:主页', 10000, 2, 'layui-icon-home', 2, 1, 1634207090),
    78. 

  78. (2, '控制台', 1, 1, '1', 'console.index', 'http://zsmatest.nongxiaohe.com/package/manage/?l=console', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090),
    79. 

  79. (3, '后台设置', 5, -1, '-1', 'manage', '/share/lib/php/dever_package/manage/:后台设置', -100, 2, 'glyphicon glyphicon-wrench layui-icon-set-sm', 2, 1, 1634207090),
    80. 

  80. (4, '管理账户设置', 1, 3, '3', 'manage.admin', 'project/database/list?project=manage&table=admin&menu=manage&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090),
    81. 

  81. (5, '接口列表', 1, 3, '3', 'manage.api', 'project/database/list?project=manage&table=api&menu=manage&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090),
    82. 

  82. (6, '后台个性化', 1, 3, '3', 'manage.config', 'project/database/list?project=manage&table=config&menu=manage&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090),
    83. 

  83. (7, '计划任务', 1, 3, '3', 'manage.cron', 'project/database/list?project=manage&table=cron&menu=manage&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090),
    84. 

  84. (8, '管理组设置', 1, 3, '3', 'manage.group', 'project/database/list?project=manage&table=group&menu=manage&search_option_state=1', 8, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090),
    85. 

  85. (9, '管理操作日志', 1, 3, '3', 'manage.log', 'project/database/list?project=manage&table=log&menu=manage&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090),
    86. 

  86. (10, '管理菜单设置', 1, 3, '3', 'manage.menu', 'project/database/list?project=manage&table=menu&menu=manage&search_option_state=1', 2, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090),
    87. 

  87. (11, '后台公告管理', 1, 3, '3', 'manage.notice', 'project/database/list?project=manage&table=notice&menu=manage&search_option_state=1', 7, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090),
    88. 

  88. (12, '字段记录表', 1, 3, '3', 'manage.opt', 'project/database/list?project=manage&table=opt&menu=manage&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090),
    89. 

  89. (13, '管理角色设置', 1, 3, '3', 'manage.role', 'project/database/list?project=manage&table=role&menu=manage&search_option_state=1', 8, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207090),
    90. 

  90. (14, '用户管理', 5, -1, '-1', 'passport', '/share/lib/php/dever_package/passport/:用户管理', 50, 2, 'glyphicon glyphicon-user layui-icon-username', 2, 1, 1634207098),
    91. 

  91. (15, '默认头像', 1, 14, '14', 'passport.avatar', 'project/database/list?project=passport&table=avatar&menu=passport&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207098),
    92. 

  92. (16, '职业设置', 1, 14, '14', 'passport.profession', 'project/database/list?project=passport&table=profession&menu=passport&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207098),
    93. 

  93. (17, '项目管理', 1, 14, '14', 'passport.system', 'project/database/list?project=passport&table=system&menu=passport&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207098),
    94. 

  94. (18, '用户管理', 1, 14, '14', 'passport.user', 'project/database/list?project=passport&table=user&menu=passport&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207098),
    95. 

  95. (19, '上传资源管理', 5, -1, '-1', 'upload', '/share/lib/php/dever_package/upload/:资源库', 10, 2, 'glyphicon glyphicon-upload layui-icon-picture', 2, 1, 1634207104),
    96. 

  96. (20, '资源分类', 1, 19, '19', 'upload.cate', 'project/database/list?project=upload&table=cate&menu=upload&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207104),
    97. 

  97. (21, '资源列表', 1, 19, '19', 'upload.file', 'project/database/list?project=upload&table=file&menu=upload&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207104),
    98. 

  98. (22, '资源配置', 1, 19, '19', 'upload.upload', 'project/database/list?project=upload&table=upload&menu=upload&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207104),
    99. 

  99. (23, '云端配置', 1, 19, '19', 'upload.yun', 'project/database/list?project=upload&table=yun&menu=upload&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207104),
    100. 

  100. (24, '行政区域设置', 5, -1, '-1', 'area', '/share/lib/php/dever_package/area/:地区设置', 20, 2, 'glyphicon glyphicon-compressed layui-icon-flag', 2, 1, 1634207108),
    101. 

  101. (25, '城市', 1, 24, '24', 'area.city', 'project/database/list?project=area&table=city&menu=area&search_option_state=1', 11, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207108),
    102. 

  102. (26, '县区', 1, 24, '24', 'area.county', 'project/database/list?project=area&table=county&menu=area&search_option_state=1', 12, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207108),
    103. 

  103. (27, '省份', 1, 24, '24', 'area.province', 'project/database/list?project=area&table=province&menu=area&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207108),
    104. 

  104. (28, '零售订单管理', 6, -1, '-1', 'menu_28', '/share/lib/php/dever_package/category/:分类管理', 199, 2, 'glyphicon glyphicon-credit-card layui-icon-templeate-1', 2, 2, 1634207116),
    105. 

  105. (29, '栏目管理', 1, 28, '28', 'manage.menu.menu_29', 'project/database/list?project=category&table=column&menu=category&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207116),
    106. 

  106. (30, '分类列表', 1, 28, '28', 'menu_30', 'project/database/list?project=category&table=info&menu=category&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207116),
    107. 

  107. (31, '类别规格关联设置', 2, 53, '53', 'category.attr', 'project/database/list?project=category&table=attr&menu=category&search_option_state=1', 194, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207121),
    108. 

  108. (32, '采购订单管理', 6, -1, '-1', 'menu_32', '/share/lib/php/dever_package/attr/:属性管理', 10, 2, 'glyphicon glyphicon-hdd layui-icon-table', 2, 2, 1634207121),
    109. 

  109. (33, '商品规格分类设置', 2, 53, '53', 'attr.cate', 'project/database/list?project=attr&table=cate&menu=attr&search_option_state=1', 196, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207121),
    110. 

  110. (34, '商品规格设置', 2, 53, '53', 'attr.info', 'project/database/list?project=attr&table=info&menu=attr&search_option_state=1', 197, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207121),
    111. 

  111. (35, '积分规则配置', 5, -1, '-1', 'score', '/share/lib/php/dever_package/score/:积分规则配置', 1, 2, 'glyphicon glyphicon-credit-card layui-icon-chat', 2, 1, 1634207126),
    112. 

  112. (36, '用户行为配置', 1, 35, '35', 'score.action', 'project/database/list?project=score&table=action&menu=score&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207126),
    113. 

  113. (37, '积分名称设置', 1, 35, '35', 'score.config', 'project/database/list?project=score&table=config&menu=score&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207126),
    114. 

  114. (38, '积分等级设置', 1, 35, '35', 'score.level', 'project/database/list?project=score&table=level&menu=score&search_option_state=1', 8, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207126),
    115. 

  115. (39, '消息中心', 4, -1, '-1', 'message', '/share/lib/php/dever_package/message/:消息系统', 100, 2, 'glyphicon glyphicon-dashboard layui-icon-senior', 2, 1, 1634207132),
    116. 

  116. (40, '收件箱', 1, 39, '39', 'message.inbox', 'project/database/list?project=message&table=inbox&menu=message&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207132),
    117. 

  117. (41, '发件箱', 1, 39, '39', 'message.outbox', 'project/database/list?project=message&table=outbox&menu=message&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207132),
    118. 

  118. (42, '项目管理', 1, 39, '39', 'message.project', 'project/database/list?project=message&table=project&menu=message&search_option_state=1', 30, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207132),
    119. 

  119. (43, '推送配置', 1, 39, '39', 'manage.menu.menu_43', 'project/database/list?project=message&table=push&menu=message&search_option_state=1', 97, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207132),
    120. 

  120. (44, '消息类型设置', 1, 39, '39', 'manage.menu.menu_44', 'project/database/list?project=message&table=type&menu=message&search_option_state=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207132),
    121. 

  121. (45, '支付管理', 5, -1, '-1', 'pay', '/share/lib/php/dever_package/pay/:支付管理', 30, 2, 'glyphicon glyphicon-usd layui-icon-diamond', 2, 1, 1634207139),
    122. 

  122. (46, '账户管理', 1, 45, '45', 'pay.account', 'project/database/list?project=pay&table=account&menu=pay&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207139),
    123. 

  123. (47, '订单管理', 1, 45, '45', 'pay.order', 'project/database/list?project=pay&table=order&menu=pay&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207139),
    124. 

  124. (48, '项目管理', 1, 45, '45', 'pay.project', 'project/database/list?project=pay&table=project&menu=pay&search_option_state=1', 8, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207139),
    125. 

  125. (49, '平台设置', 4, -1, '-1', 'main', '/www/churen/main/:基础设置', 300, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 1, 1634207178),
    126. 

  126. (50, '网站基础信息', 2, 49, '49', 'main.config', 'project/database/list?project=main&table=config&menu=main&search_option_state=1', 97, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207178),
    127. 

  127. (51, '帮助中心', 4, 73, '73', 'main.help', 'project/database/list?project=main&table=help&menu=main&search_option_state=1', 199, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207178),
    128. 

  128. (52, '单页管理', 1, 49, '49', 'main.page', 'project/database/list?project=main&table=page&menu=main&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207178),
    129. 

  129. (53, '商品管理', 2, -1, '-1', 'goods', '/www/churen/app/goods/:商品管理', 500, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 1, 1634207186),
    130. 

  130. (54, '礼品卡配置', 4, 71, '71', 'manage.menu.menu_54', 'project/database/list?project=goods&table=card&menu=goods&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207186),
    131. 

  131. (55, '优惠券配置', 4, 71, '71', 'goods.coupon', 'project/database/list?project=goods&table=coupon&menu=goods&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207186),
    132. 

  132. (56, '商品设置', 2, 53, '53', 'goods.info', 'project/database/list?project=goods&table=info&menu=goods&search_option_state=1', 200, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207186),
    133. 

  133. (57, '工厂管理', 2, -1, '-1', 'factory', '/www/churen/app/factory/:工厂管理', 600, 2, 'glyphicon glyphicon-tower layui-icon-flag', 2, 1, 1634207199),
    134. 

  134. (58, '工厂列表', 2, 57, '57', 'factory.info', 'project/database/list?project=factory&table=info&menu=factory&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207199),
    135. 

  135. (59, '仓库管理', 2, -1, '-1', 'store', '/www/churen/app/store/:仓库管理', 700, 2, 'glyphicon glyphicon-tower layui-icon-template-1', 2, 1, 1634207205),
    136. 

  136. (60, '仓库列表', 2, 59, '59', 'store.info', 'project/database/list?project=store&table=info&menu=store&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207205),
    137. 

  137. (61, '门店管理', 2, -1, '-1', 'menu_61', '/www/churen/app/shop/:门店管理', 800, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 1, 1634207211),
    138. 

  138. (62, '反馈列表', 4, 69, '69', 'shop.feedback', 'project/database/list?project=shop&table=feedback&menu=shop&search_option_state=1', 80, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207211),
    139. 

  139. (63, '焦点图管理', 1, 61, '61', 'manage.menu.menu_63', 'project/database/list?project=shop&table=focus&menu=shop&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634207211),
    140. 

  140. (64, '门店列表', 2, 61, '61', 'shop.info', 'project/database/list?project=shop&table=info&menu=shop&search_option_state=1', 900, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634207211),
    141. 

  141. (65, '商品栏目管理', 2, 53, '53', 'goods.column', 'project/database/list?project=goods&table=column&menu=goods&search_option_state=1', 199, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634524826),
    142. 

  142. (66, '商品类别管理', 2, 53, '53', 'category.info', 'project/database/list?project=category&table=info&menu=category&search_option_state=1', 195, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634623901),
    143. 

  143. (67, '第三方登录', 1, -1, '-1', 'manage.menu.menu_67', '/share/lib/php/dever_package/oauth/:第三方登录', 1, 2, 'glyphicon glyphicon-filter layui-icon-group', 2, 2, 1634623901),
    144. 

  144. (68, '第三方管理', 1, 67, '67', 'oauth.account', 'project/database/list?project=oauth&table=account&menu=oauth&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634623901),
    145. 

  145. (69, '用户反馈', 4, -1, '-1', 'push', '/share/lib/php/dever_package/push/:推送管理', 199, 2, 'glyphicon glyphicon-tower layui-icon-template-1', 2, 1, 1634623901),
    146. 

  146. (70, '推送位管理', 1, 69, '69', 'manage.menu.menu_70', 'project/database/list?project=push&table=info&menu=push&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634623901),
    147. 

  147. (71, '营销设置', 4, -1, '-1', 'act', '/www/churen/app/act/:活动管理', 200, 2, 'glyphicon glyphicon-tower layui-icon-reply-fill', 2, 1, 1634623910),
    148. 

  148. (72, '活动管理', 1, 71, '71', 'act.info', 'project/database/list?project=act&table=info&menu=act&search_option_state=1', 200, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634623910),
    149. 

  149. (73, '内容管理', 4, -1, '-1', 'content', '/www/churen/app/content/:内容管理', 400, 2, 'glyphicon glyphicon-tower layui-icon-tabs', 2, 1, 1634623916),
    150. 

  150. (74, '专题页面', 4, 73, '73', 'content.feature', 'project/database/list?project=content&table=feature&menu=content&search_option_state=1', 195, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634623916),
    151. 

  151. (75, '文章页面', 4, 73, '73', 'manage.menu.menu_75', 'project/database/list?project=content&table=news&menu=content&search_option_state=1', 194, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634623916),
    152. 

  152. (76, '结算对账', 6, -1, '-1', 'manage.menu.menu_76', '/share/lib/php/dever_package/oauth/:第三方登录', 1, 2, 'glyphicon glyphicon-filter layui-icon-group', 2, 2, 1634624286),
    153. 

  153. (77, '推荐位管理', 1, 73, '73', 'push.data', 'project/database/list?project=push&table=data&menu=push&search_option_state=1', 200, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634624286),
    154. 

  154. (78, '街道', 1, 24, '24', 'area.town', 'project/database/list?project=area&table=town&menu=area&search_option_state=1', 13, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634710961),
    155. 

  155. (79, '社区', 1, 24, '24', 'area.village', 'project/database/list?project=area&table=village&menu=area&search_option_state=1', 14, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634710961),
    156. 

  156. (80, '推送位管理', 1, 69, '69', 'manage.menu.menu_80', 'project/database/list?project=push&table=info&menu=push&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1634710961),
    157. 

  157. (81, '海报管理', 5, -1, '-1', 'menu_81', '/share/lib/php/dever_package/poster/:海报管理', -2, 2, 'glyphicon glyphicon-warning-sign layui-icon-template', 2, 2, 1634710961),
    158. 

  158. (82, '模板设置', 1, 81, '81', 'poster.template', 'project/database/list?project=poster&table=template&menu=poster&search_option_state=1', 20, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634710961),
    159. 

  159. (83, '商品标签管理', 2, 53, '53', 'goods.tag', 'project/database/list?project=goods&table=tag&menu=goods&search_option_state=1', 198, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634786713),
    160. 

  160. (84, '门店采购查询', 2, 61, '61', 'menu_61.menu_84', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1&search_option_type=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634786713),
    161. 

  161. (85, '门店零售订单查询', 2, 61, '61', 'menu_61.menu_85', 'project/database/list?project=shop&table=sell_order&menu=shop&search_option_state=1&search_option_shop_type=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634786713),
    162. 

  162. (86, '推送位管理', 1, 3, '3', 'push.info', 'project/database/list?project=push&table=info&menu=push&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634786713),
    163. 

  163. (87, '公司动态', 4, 73, '73', 'main.news', 'project/database/list?project=main&table=news&menu=main&search_option_state=1', 198, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634802302),
    164. 

  164. (88, '招聘信息', 4, 73, '73', 'main.zhaopin', 'project/database/list?project=main&table=zhaopin&menu=main&search_option_state=1', 196, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1634802302),
    165. 

  165. (89, '供应链基础信息', 1, 49, '49', 'main.factory_config', 'project/database/list?project=main&table=factory_config&menu=main&search_option_state=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1635606246),
    166. 

  166. (90, '门店小程序信息', 1, 49, '49', 'main.manage_config', 'project/database/list?project=main&table=manage_config&menu=main&search_option_state=1', 95, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1635606246),
    167. 

  167. (91, '零售小程序信息', 1, 49, '49', 'main.sell_config', 'project/database/list?project=main&table=sell_config&menu=main&search_option_state=1', 96, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1635606246),
    168. 

  168. (92, '新增门店', 2, 61, '61', 'manage.menu.menu_92', 'project/database/update&project=shop&table=info&menu=shop&menu_id=64&search_option_state=1', 1000, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1635607001),
    169. 

  169. (93, '新增工厂', 2, 57, '57', 'manage.menu.menu_93', 'project/database/update&project=factory&&table=info&menu=factory&menu_id=58&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1635607648),
    170. 

  170. (94, '新增仓库', 1, 59, '59', 'manage.menu.menu_94', 'project/database/update&project=store&&table=info&menu=store&menu_id=60&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1635607688),
    171. 

  171. (95, '门店合作申请', 1, 61, '61', 'shop.apply', 'project/database/list?project=shop&table=apply&menu=shop&search_option_state=1', 800, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1635686596),
    172. 

  172. (96, '海报管理', 1, -1, '-1', 'manage.menu.menu_96', '/share/lib/php/dever_package/poster/:海报管理', -2, 2, 'glyphicon glyphicon-warning-sign layui-icon-template', 2, 2, 1635686596),
    173. 

  173. (97, '配送服务商', 4, 49, '49', 'main.menu_97', 'project/database/list?project=shop&table=service&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636450211),
    174. 

  174. (98, '平台订货下单', 2, 57, '57', 'factory.menu_98', 'http://zsmatest.nongxiaohe.com/app/factory/?l=lib/manage.cashier', 98, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636450920),
    175. 

  175. (99, '仓库入库单查询', 2, 59, '59', 'store.menu_99', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1&search_option_type=2', 97, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636451393),
    176. 

  176. (100, '门店零售结算单', 6, 76, '76', 'menu_76.menu_100', 'project/database/list?project=shop&table=sell_stat_month&menu=shop&search_option_state=1&search_option_type=2', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636451656),
    177. 

  177. (101, '分类管理', 1, -1, '-1', 'manage.menu.menu_101', '/share/lib/php/dever_package/category/:分类管理', 10, 2, 'glyphicon glyphicon-credit-card layui-icon-templeate-1', 2, 2, 1636452047),
    178. 

  178. (102, '属性管理', 1, -1, '-1', 'manage.menu.menu_102', '/share/lib/php/dever_package/attr/:属性管理', 10, 2, 'glyphicon glyphicon-hdd layui-icon-table', 2, 2, 1636452047),
    179. 

  179. (103, '采购订单', 1, 61, '61', 'manage.menu.menu_103', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1636452047),
    180. 

  180. (104, '配送服务商', 1, 61, '61', 'manage.menu.menu_104', 'project/database/list?project=shop&table=service&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1636452047),
    181. 

  181. (105, '第三方登录', 1, -1, '-1', 'manage.menu.menu_105', '/share/lib/php/dever_package/oauth/:第三方登录', 1, 2, 'glyphicon glyphicon-filter layui-icon-group', 2, 2, 1636452047),
    182. 

  182. (106, '门店零售对账单', 1, 76, '76', 'menu_76.menu_106', 'project/database/list?project=shop&table=sell_stat_month&menu=shop&search_option_state=1&search_option_type=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636452354),
    183. 

  183. (107, '门店采购对账单', 6, 76, '76', 'menu_76.menu_107', 'project/database/list?project=shop&table=buy_stat_month&menu=shop&search_option_state=1&search_option_type=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636453834),
    184. 

  184. (108, '门店采购结算单', 6, 76, '76', 'menu_76.menu_108', 'project/database/list?project=shop&table=buy_stat_month&menu=shop&search_option_state=1&search_option_type=2', 97, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636453860),
    185. 

  185. (109, '仓库对账单', 6, 76, '76', 'menu_76.menu_109', 'project/database/list?project=shop&table=store_stat_month&menu=shop&search_option_state=1', 96, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636453890),
    186. 

  186. (110, '工厂对账单', 1, 76, '76', 'menu_76.menu_110', 'project/database/list?project=shop&table=factory_stat_month&menu=shop&search_option_state=1&search_option_type=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636453927),
    187. 

  187. (111, '工厂结算单', 1, 76, '76', 'menu_76.menu_111', 'project/database/list?project=shop&table=factory_stat_month&menu=shop&search_option_state=1&search_option_type=2', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1636453948),
    188. 

  188. (112, '采购订单', 1, 61, '61', 'manage.menu.menu_112', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1636705853),
    189. 

  189. (113, '配送服务商', 1, 61, '61', 'manage.menu.menu_113', 'project/database/list?project=shop&table=service&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1636705853),
    190. 

  190. (114, '结算对账', 6, -1, '-1', 'menu_114', '/www/churen/app/cash/:结算对账', 8, 2, 'glyphicon glyphicon-tower layui-icon-form', 2, 2, 1636705853),
    191. 

  191. (115, '门店对账单', 1, 114, '114', 'manage.menu.menu_115', 'project/database/list?project=cash&table=shop&menu=cash&search_option_state=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1636705853),
    192. 

  192. (116, '分类管理', 5, -1, '-1', 'category', '/share/lib/php/dever_package/category/:分类管理', 10, 2, 'glyphicon glyphicon-credit-card layui-icon-templeate-1', 2, 1, 1637138455),
    193. 

  193. (117, '出库订单管理', 6, -1, '-1', 'menu_117', '/share/lib/php/dever_package/attr/:属性管理', 9, 2, 'glyphicon glyphicon-hdd layui-icon-table', 2, 2, 1637138455),
    194. 

  194. (118, '采购额统计', 6, 121, '121', 'menu_121.menu_118', 'project/database/list?project=shop&table=buy_stat&menu=shop&search_option_state=1', -5, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455),
    195. 

  195. (119, '门店出库单查询', 2, 61, '61', 'menu_61.menu_119', 'project/database/list?project=shop&table=out_order&menu=shop&search_option_state=1&search_option_type=1', 97, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455),
    196. 

  196. (120, '营业额统计', 6, 121, '121', 'menu_121.menu_120', 'project/database/list?project=shop&table=sell_stat&menu=shop&search_option_state=1', -4, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455),
    197. 

  197. (121, '统计分析', 1, -1, '-1', 'menu_121', '/share/lib/php/dever_package/oauth/:第三方登录', 1, 2, 'glyphicon glyphicon-filter layui-icon-group', 2, 1, 1637138455),
    198. 

  198. (122, '海报管理', 5, -1, '-1', 'poster', '/share/lib/php/dever_package/poster/:海报管理', -2, 2, 'glyphicon glyphicon-warning-sign layui-icon-template', 2, 1, 1637138455),
    199. 

  199. (123, '工厂对账单', 2, 57, '57', 'factory.menu_123', 'project/database/list?project=cash&table=factory&menu=cash&search_option_state=1', 70, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455),
    200. 

  200. (124, '门店结算单', 2, 61, '61', 'menu_61.menu_124', 'project/database/list?project=cash&table=order&menu=cash&search_option_state=1&search_option_search=1&page_type=2&search_option_type=1', 95, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455),
    201. 

  201. (125, '仓库对账单', 2, 59, '59', 'store.menu_125', 'project/database/list?project=cash&table=store&menu=cash&search_option_state=1', 60, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138455),
    202. 

  202. (126, '工厂结算单', 2, 57, '57', 'factory.menu_126', 'project/database/list?project=cash&table=order&menu=cash&search_option_state=1&search_option_search=3&page_type=2&search_option_source_type=3', 80, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637138766),
    203. 

  203. (127, '仓库出库查询', 2, 59, '59', 'store.menu_127', 'project/database/list?project=shop&table=out_order&menu=shop&search_option_state=1&search_option_type=2', 95, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637139739),
    204. 

  204. (128, '零售用户统计', 6, 121, '121', 'menu_121.menu_128', 'project/database/list?project=passport&table=stat&menu=stat&search_option_state=1', -11, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637139898),
    205. 

  205. (129, '属性管理', 5, -1, '-1', 'attr', '/share/lib/php/dever_package/attr/:属性管理', 10, 2, 'glyphicon glyphicon-hdd layui-icon-table', 2, 1, 1637143356),
    206. 

  206. (130, '采购订单', 1, 61, '61', 'manage.menu.menu_130', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356),
    207. 

  207. (131, '采购额统计', 1, 61, '61', 'manage.menu.menu_131', 'project/database/list?project=shop&table=buy_stat&menu=shop&search_option_state=1', -10, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356),
    208. 

  208. (132, '出库订单', 1, 61, '61', 'manage.menu.menu_132', 'project/database/list?project=shop&table=out_order&menu=shop&search_option_state=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356),
    209. 

  209. (133, '销售额统计', 1, 61, '61', 'manage.menu.menu_133', 'project/database/list?project=shop&table=sell_stat&menu=shop&search_option_state=1', -9, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356),
    210. 

  210. (134, '配送服务商', 1, 61, '61', 'manage.menu.menu_134', 'project/database/list?project=shop&table=service&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356),
    211. 

  211. (135, '第三方登录', 5, -1, '-1', 'oauth', '/share/lib/php/dever_package/oauth/:第三方登录', 1, 2, 'glyphicon glyphicon-filter layui-icon-group', 2, 1, 1637143356),
    212. 

  212. (136, '结算单', 1, 114, '114', 'manage.menu.menu_136', 'project/database/list?project=cash&table=order&menu=cash&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637143356),
    213. 

  213. (137, '门店对账单', 2, 61, '61', 'menu_61.menu_137', 'project/database/list?project=cash&table=shop&menu=cash&search_option_state=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143356),
    214. 

  214. (138, 'Token管理', 5, -1, '-1', 'token', '/share/lib/php/dever_package/token/:Token管理', -1, 2, 'glyphicon glyphicon-road layui-icon-engine', 2, 1, 1637143356),
    215. 

  215. (139, '请求日志', 1, 138, '138', 'token.log', 'project/database/list?project=token&table=log&menu=token&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143356),
    216. 

  216. (140, '项目管理', 1, 138, '138', 'token.project', 'project/database/list?project=token&table=project&menu=token&search_option_state=1', -10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143356),
    217. 

  217. (141, '小程序管理', 5, -1, '-1', 'wechat_applet', '/share/lib/php/dever_package/wechat_applet/:小程序管理', 90, 2, 'glyphicon glyphicon-tint layui-icon-release', 2, 1, 1637143367),
    218. 

  218. (142, '模板消息列表', 1, 141, '141', 'wechat_applet.msg', 'project/database/list?project=wechat_applet&table=msg&menu=wechat_applet&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143367),
    219. 

  219. (143, '模板消息日志', 1, 141, '141', 'wechat_applet.msg_log', 'project/database/list?project=wechat_applet&table=msg_log&menu=wechat_applet&search_option_state=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143367),
    220. 

  220. (144, '发送模板消息', 1, 141, '141', 'wechat_applet.msg_send', 'project/database/list?project=wechat_applet&table=msg_send&menu=wechat_applet&search_option_state=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143367),
    221. 

  221. (145, '统计概览', 1, 141, '141', 'wechat_applet.total_base', 'project/database/list?project=wechat_applet&table=total_base&menu=wechat_applet&search_option_state=1', 20, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637143367),
    222. 

  222. (146, '资源库', 5, -1, '-1', 'manage.menu.menu_146', '/share/lib/php/dever_package/upload/:资源库', -90, 2, 'glyphicon glyphicon-upload layui-icon-picture', 2, 2, 1637229112),
    223. 

  223. (147, '资源分类', 1, 146, '146', 'upload.cate', 'project/database/list?project=upload&table=cate&menu=upload&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    224. 

  224. (148, '资源列表', 1, 146, '146', 'upload.file', 'project/database/list?project=upload&table=file&menu=upload&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    225. 

  225. (149, '资源配置', 1, 146, '146', 'upload.upload', 'project/database/list?project=upload&table=upload&menu=upload&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    226. 

  226. (150, '云端配置', 1, 146, '146', 'upload.yun', 'project/database/list?project=upload&table=yun&menu=upload&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    227. 

  227. (151, '地区设置', 5, -1, '-1', 'manage.menu.menu_151', '/share/lib/php/dever_package/area/:地区设置', -10, 2, 'glyphicon glyphicon-compressed layui-icon-flag', 2, 2, 1637229112),
    228. 

  228. (152, '城市', 1, 151, '151', 'area.city', 'project/database/list?project=area&table=city&menu=area&search_option_state=1', 11, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    229. 

  229. (153, '县区', 1, 151, '151', 'area.county', 'project/database/list?project=area&table=county&menu=area&search_option_state=1', 12, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    230. 

  230. (154, '省份', 1, 151, '151', 'area.province', 'project/database/list?project=area&table=province&menu=area&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    231. 

  231. (155, '街道', 1, 151, '151', 'area.town', 'project/database/list?project=area&table=town&menu=area&search_option_state=1', 13, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    232. 

  232. (156, '社区', 1, 151, '151', 'area.village', 'project/database/list?project=area&table=village&menu=area&search_option_state=1', 14, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    233. 

  233. (157, '分类属性设置', 1, 101, '101', 'category.attr', 'project/database/list?project=category&table=attr&menu=category&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    234. 

  234. (158, '分类列表', 1, 101, '101', 'category.info', 'project/database/list?project=category&table=info&menu=category&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    235. 

  235. (159, '属性类别', 1, 102, '102', 'attr.cate', 'project/database/list?project=attr&table=cate&menu=attr&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    236. 

  236. (160, '属性设置', 1, 102, '102', 'attr.info', 'project/database/list?project=attr&table=info&menu=attr&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    237. 

  237. (161, '消息系统', 4, -1, '-1', 'message', '/share/lib/php/dever_package/message/:消息系统', -6, 2, 'glyphicon glyphicon-dashboard layui-icon-senior', 2, 1, 1637229112),
    238. 

  238. (162, '收件箱', 1, 161, '161', 'message.inbox', 'project/database/list?project=message&table=inbox&menu=message&search_option_state=1', 18, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    239. 

  239. (163, '发件箱', 1, 161, '161', 'message.outbox', 'project/database/list?project=message&table=outbox&menu=message&search_option_state=1', 19, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    240. 

  240. (164, '项目管理', 1, 161, '161', 'message.project', 'project/database/list?project=message&table=project&menu=message&search_option_state=1', 30, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    241. 

  241. (165, '基础设置', 4, -1, '-1', 'manage.menu.menu_165', '/www/churen/main/:基础设置', 98, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 2, 1637229112),
    242. 

  242. (166, '网站基础信息', 1, 165, '165', 'main.config', 'project/database/list?project=main&table=config&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    243. 

  243. (167, '供应链基础信息', 1, 165, '165', 'main.factory_config', 'project/database/list?project=main&table=factory_config&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    244. 

  244. (168, '帮助中心', 1, 165, '165', 'main.help', 'project/database/list?project=main&table=help&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    245. 

  245. (169, '门店小程序信息', 1, 165, '165', 'main.manage_config', 'project/database/list?project=main&table=manage_config&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    246. 

  246. (170, '文章管理', 1, 165, '165', 'main.news', 'project/database/list?project=main&table=news&menu=main&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    247. 

  247. (171, '单页管理', 1, 165, '165', 'main.page', 'project/database/list?project=main&table=page&menu=main&search_option_state=1', 2, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    248. 

  248. (172, '零售小程序信息', 1, 165, '165', 'main.sell_config', 'project/database/list?project=main&table=sell_config&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    249. 

  249. (173, '招聘信息', 1, 165, '165', 'main.zhaopin', 'project/database/list?project=main&table=zhaopin&menu=main&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    250. 

  250. (174, '礼品卡配置', 1, 53, '53', 'manage.menu.menu_174', 'project/database/list?project=goods&table=card&menu=goods&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1637229112),
    251. 

  251. (175, '栏目管理', 1, 53, '53', 'goods.column', 'project/database/list?project=goods&table=column&menu=goods&search_option_state=1', 9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    252. 

  252. (176, '优惠券配置', 1, 53, '53', 'goods.coupon', 'project/database/list?project=goods&table=coupon&menu=goods&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    253. 

  253. (177, '商品列表', 1, 53, '53', 'goods.info', 'project/database/list?project=goods&table=info&menu=goods&search_option_state=1', 200, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    254. 

  254. (178, '标签管理', 1, 53, '53', 'goods.tag', 'project/database/list?project=goods&table=tag&menu=goods&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    255. 

  255. (179, '门店零售', 2, -1, '-1', 'manage.menu.menu_179', '/www/churen/app/shop/:门店零售', 80, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 2, 1637229112),
    256. 

  256. (180, '门店合作申请', 1, 179, '179', 'shop.apply', 'project/database/list?project=shop&table=apply&menu=shop&search_option_state=1', 1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    257. 

  257. (181, '采购订单', 1, 179, '179', 'shop.buy_order', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    258. 

  258. (182, '采购额统计', 1, 179, '179', 'shop.buy_stat', 'project/database/list?project=shop&table=buy_stat&menu=shop&search_option_state=1', -10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    259. 

  259. (183, '反馈管理', 1, 179, '179', 'shop.feedback', 'project/database/list?project=shop&table=feedback&menu=shop&search_option_state=1', 80, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    260. 

  260. (184, '门店列表', 1, 179, '179', 'shop.info', 'project/database/list?project=shop&table=info&menu=shop&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    261. 

  261. (185, '出库订单', 1, 179, '179', 'shop.out_order', 'project/database/list?project=shop&table=out_order&menu=shop&search_option_state=1', 98, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    262. 

  262. (186, '销售订单', 1, 179, '179', 'shop.sell_order', 'project/database/list?project=shop&table=sell_order&menu=shop&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    263. 

  263. (187, '销售额统计', 1, 179, '179', 'shop.sell_stat', 'project/database/list?project=shop&table=sell_stat&menu=shop&search_option_state=1', -9, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    264. 

  264. (188, '配送服务商', 1, 179, '179', 'shop.service', 'project/database/list?project=shop&table=service&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    265. 

  265. (189, '推送管理', 4, -1, '-1', 'push', '/share/lib/php/dever_package/push/:推送管理', 199, 2, 'glyphicon glyphicon-tower layui-icon-template-1', 2, 1, 1637229112),
    266. 

  266. (190, '首页焦点图下的推送数据管理', 1, 189, '189', 'push.data', 'project/database/list?project=push&table=data&menu=push&search_option_state=1', 20, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    267. 

  267. (191, '推送位管理', 1, 189, '189', 'push.info', 'project/database/list?project=push&table=info&menu=push&search_option_state=1', 10, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    268. 

  268. (192, '活动管理', 4, -1, '-1', 'act', '/www/churen/app/act/:活动管理', 200, 2, 'glyphicon glyphicon-tower layui-icon-reply-fill', 2, 1, 1637229112),
    269. 

  269. (193, '活动管理', 1, 192, '192', 'act.info', 'project/database/list?project=act&table=info&menu=act&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    270. 

  270. (194, '专题管理', 1, 73, '73', 'content.feature', 'project/database/list?project=content&table=feature&menu=content&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    271. 

  271. (195, '文章管理', 1, 73, '73', 'content.news', 'project/database/list?project=content&table=news&menu=content&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    272. 

  272. (196, '结算单', 1, 76, '76', 'cash.order', 'project/database/list?project=cash&table=order&menu=cash&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    273. 

  273. (197, '门店对账单', 1, 76, '76', 'cash.shop', 'project/database/list?project=cash&table=shop&menu=cash&search_option_state=1', 90, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637229112),
    274. 

  274. (198, '门店零售', 1, -1, '-1', 'manage.menu.menu_198', '/www/churen/app/shop/:门店零售', 80, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 2, 1637813857),
    275. 

  275. (199, '订阅消息列表', 1, 141, '141', 'wechat_applet.subscribe', 'project/database/list?project=wechat_applet&table=subscribe&menu=wechat_applet&search_option_state=1', 89, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637813857),
    276. 

  276. (200, '订阅消息日志', 1, 141, '141', 'wechat_applet.subscribe_log', 'project/database/list?project=wechat_applet&table=subscribe_log&menu=wechat_applet&search_option_state=1', 77, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637813857),
    277. 

  277. (201, '发送订阅消息', 1, 141, '141', 'wechat_applet.subscribe_send', 'project/database/list?project=wechat_applet&table=subscribe_send&menu=wechat_applet&search_option_state=1', 79, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1637813857),
    278. 

  278. (202, '短信管理', 5, -1, '-1', 'sms', '/share/lib/php/dever_package/sms/:短信管理', -10, 2, 'glyphicon glyphicon-list-alt layui-icon-note', 2, 1, 1638238703),
    279. 

  279. (203, '基本配置', 1, 202, '202', 'sms.config', 'project/database/list?project=sms&table=config&menu=sms&search_option_state=1', 20, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1638238703),
    280. 

  280. (204, '出库类型设置', 1, 49, '49', 'main.menu_204', 'project/database/list?project=shop&table=out_type&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1638866110),
    281. 

  281. (205, '出库类型', 1, 198, '198', 'shop.out_type', 'project/database/list?project=shop&table=out_type&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1641294343),
    282. 

  282. (206, '礼品卡管理', 4, -1, '-1', 'menu_206', '/www/churen/app/card/:礼品卡管理', 90, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 1, 1641294343),
    283. 

  283. (207, '面值配置', 1, 206, '206', 'card.info', 'project/database/list?project=card&table=info&menu=card&search_option_state=1', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1641294343),
    284. 

  284. (208, '礼品卡订单', 1, 206, '206', 'card.order', 'project/database/list?project=card&table=order&menu=card&search_option_state=1', 100, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1641294343),
    285. 

  285. (209, '类型配置', 1, 206, '206', 'card.type', 'project/database/list?project=card&table=type&menu=card&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1641294343),
    286. 

  286. (210, '帮助管理', 1, 3, '3', 'manage.help', 'project/database/list?project=manage&table=help&menu=manage&search_option_state=1', 6, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1641643287),
    287. 

  287. (211, '门店零售', 1, -1, '-1', 'manage.menu.menu_211', '/www/churen/app/shop/:门店零售', 80, 2, 'glyphicon glyphicon-tower layui-icon-component', 2, 2, 1641643287),
    288. 

  288. (212, '礼品卡管理', 1, -1, '-1', 'card', '/www/churen/app/card/:礼品卡管理', 90, 2, 'glyphicon glyphicon-tower layui-icon-gift', 2, 1, 1641643287),
    289. 

  289. (213, '后台操作讲解', 4, 49, '49', 'main.menu_213', 'http://zsmatest.nongxiaohe.com/package/manage/?l=doc/help', -100, 2, 'glyphicon glyphicon-folder-close layui-icon-light', 2, 1, 1641643457),
    290. 

  290. (214, '门店单品销售统计', 6, 121, '121', 'menu_121.menu_214', 'project/database/list?project=shop&table=goods_stat&menu=shop&search_option_state=1', -2, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1644305353),
    291. 

  291. (215, '门店数据统计', 6, 121, '121', 'menu_121.menu_215', 'project/database/list?project=shop&table=shop_stat&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1644305353),
    292. 

  292. (216, '用户排名统计', 6, 121, '121', 'manage.menu.menu_216', 'project/database/list?project=shop&table=user_buy_stat&menu=shop&search_option_state=1', -1, 2, 'glyphicon glyphicon-folder-close', 2, 2, 1644305353),
    293. 

  293. (217, '门店用户复购统计', 1, 121, '121', 'menu_121.menu_217', 'project/database/list?project=shop&table=user_stat&menu=shop&search_option_state=1', -3, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1644305353),
    294. 

  294. (218, '平台商城订单管理', 2, 61, '61', 'menu_61.menu_218', 'project/database/list?project=shop&table=sell_order&menu=shop&search_option_state=1&search_option_shop_type=2', 99, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1644305749),
    295. 

  295. (219, '门店库存查询', 2, 61, '61', 'menu_61.menu_219', 'project/database/list?project=shop&table=goods_sku&menu=shop&search_option_state=1', 96, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1644305901),
    296. 

  296. (220, '仓库发货查询', 2, 59, '59', 'store.menu_220', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1&search_option_type=1&search_option_source_type=2', 96, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1644306270),
    297. 

  297. (221, '仓库库存查询', 2, 59, '59', 'store.menu_221', 'project/database/list?project=store&table=goods_sku&menu=shop&search_option_state=1', 94, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1644306341),
    298. 

  298. (222, '工厂订单查询', 2, 57, '57', 'factory.menu_222', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1&search_option_source_type=3', 97, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1644306465),
    299. 

  299. (223, '仓库库存调拨', 2, 59, '59', 'store.menu_223', 'project/database/list?project=shop&table=buy_order&menu=shop&search_option_state=1&search_option_type=2&search_option_source_type=2', 70, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1644758427),
    300. 

  300. (224, '用户排名统计', 1, 121, '121', 'menu_121.menu_224', 'project/database/list?project=shop&table=user_rank_stat&menu=shop&search_option_state=1', -12, 2, 'glyphicon glyphicon-folder-close', 2, 1, 1644849002);
    301. 

  301. 

  302. -- --------------------------------------------------------
    303. 

  303. 

  304. --
    305. 

  305. -- 表的结构 `churen_manage_menu_group`
    306. 

  306. --
    307. 

  307. 

  308. DROP TABLE IF EXISTS `churen_manage_menu_group`;
    309. 

  309. CREATE TABLE `churen_manage_menu_group` (
    310. 

  310.   `id` int(11) UNSIGNED NOT NULL COMMENT '分组ID',
    311. 

  311.   `name` varchar(50) DEFAULT NULL COMMENT '分组名称',
    312. 

  312.   `icon` varchar(100) DEFAULT NULL COMMENT '图标代码-请<A HREF="HTTPS://WWW.LAYUI.COM/DOC/ELEMENT/ICON.HTML" TARGET="_BLANK">点此</A>查看图标代码',
    313. 

  313.   `reorder` int(11) NOT NULL DEFAULT '1' COMMENT '排序',
    314. 

  314.   `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
    315. 

  315.   `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '录入时间'
    316. 

  316. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    317. 

  317. 

  318. --
    319. 

  319. -- 转存表中的数据 `churen_manage_menu_group`
    320. 

  320. --
    321. 

  321. 

  322. INSERT INTO `churen_manage_menu_group` (`id`, `name`, `icon`, `reorder`, `state`, `cdate`) VALUES
    323. 

  323. (1, '控制台', 'layui-icon layui-icon-home', 100, 1, 1634207090),
    324. 

  324. (2, '供应链管理', 'glyphicon glyphicon-folder-close', 3, 1, 1634207236),
    325. 

  325. (3, '商品管理', 'glyphicon glyphicon-folder-close', 80, 2, 1634207268),
    326. 

  326. (4, '基础运营', 'glyphicon glyphicon-folder-close', 70, 1, 1634207278),
    327. 

  327. (5, '平台系统管理', 'glyphicon glyphicon-folder-close', 1, 1, 1634207285),
    328. 

  328. (6, '财务管理', 'glyphicon glyphicon-folder-close', 2, 1, 1634207390);
    329. 

  329. 

  330. --
    331. 

  331. -- 转储表的索引
    332. 

  332. --
    333. 

  333. 

  334. --
    335. 

  335. -- 表的索引 `churen_manage_group`
    336. 

  336. --
    337. 

  337. ALTER TABLE `churen_manage_group`
    338. 

  338.   ADD PRIMARY KEY (`id`);
    339. 

  339. 

  340. --
    341. 

  341. -- 表的索引 `churen_manage_menu`
    342. 

  342. --
    343. 

  343. ALTER TABLE `churen_manage_menu`
    344. 

  344.   ADD PRIMARY KEY (`id`);
    345. 

  345. 

  346. --
    347. 

  347. -- 表的索引 `churen_manage_menu_group`
    348. 

  348. --
    349. 

  349. ALTER TABLE `churen_manage_menu_group`
    350. 

  350.   ADD PRIMARY KEY (`id`);
    351. 

  351. 

  352. --
    353. 

  353. -- 在导出的表使用AUTO_INCREMENT
    354. 

  354. --
    355. 

  355. 

  356. --
    357. 

  357. -- 使用表AUTO_INCREMENT `churen_manage_group`
    358. 

  358. --
    359. 

  359. ALTER TABLE `churen_manage_group`
    360. 

  360.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '组ID', AUTO_INCREMENT=2;
    361. 

  361. 

  362. --
    363. 

  363. -- 使用表AUTO_INCREMENT `churen_manage_menu`
    364. 

  364. --
    365. 

  365. ALTER TABLE `churen_manage_menu`
    366. 

  366.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '菜单ID', AUTO_INCREMENT=225;
    367. 

  367. 

  368. --
    369. 

  369. -- 使用表AUTO_INCREMENT `churen_manage_menu_group`
    370. 

  370. --
    371. 

  371. ALTER TABLE `churen_manage_menu_group`
    372. 

  372.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分组ID', AUTO_INCREMENT=7;
    373. 

  373. COMMIT;
    374. 

  374. 

  375. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    376. 

  376. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    377. 

  377. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    378.