```[sql]
-- ----------------------------
-- Table structure for ns_fenxiao
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao`;
CREATE TABLE `ns_fenxiao` (
`fenxiao_id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NULL DEFAULT 0 COMMENT '站点id',
`fenxiao_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分销商编号',
`fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分销店铺名',
`mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '联系电话',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '会员ID',
`level_id` int(11) NOT NULL DEFAULT 0 COMMENT '分销商等级id',
`level_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '等级名称',
`parent` int(11) NOT NULL DEFAULT 0 COMMENT '上级ID',
`grand_parent` int(11) NOT NULL DEFAULT 0 COMMENT '上上级id',
`account` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '当前佣金',
`account_withdraw` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '已提现佣金',
`account_withdraw_apply` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提现中佣金',
`status` tinyint(3) NOT NULL DEFAULT 1 COMMENT '状态（1已审核 2拒绝 -1已冻结）',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`audit_time` int(11) NOT NULL DEFAULT 0 COMMENT '成为经分销商时间',
`lock_time` int(11) NOT NULL DEFAULT 0 COMMENT '冻结时间',
`one_fenxiao_order_num` int(11) NOT NULL DEFAULT 0 COMMENT '一级分销订单总数',
`one_fenxiao_order_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一级分销订单总额',
`one_child_num` int(11) NOT NULL DEFAULT 0 COMMENT '一级下线人数',
`one_child_fenxiao_num` int(11) NOT NULL DEFAULT 0 COMMENT '一级下线分销商',
`two_child_fenxiao_num` int(11) NOT NULL DEFAULT 0 COMMENT '二级下线分销商',
`total_commission` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '累计佣金',
PRIMARY KEY (`fenxiao_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1170 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分销商表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_account
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_account`;
CREATE TABLE `ns_fenxiao_account` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`account_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '账单编号',
`fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '分销商ID',
`fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分销商名称',
`money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '费用',
`type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '类型（withdraw提现 order订单结算）',
`type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型名称',
`relate_id` int(11) NOT NULL DEFAULT 0 COMMENT '关联id',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1638 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分销商流水表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_apply
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_apply`;
CREATE TABLE `ns_fenxiao_apply` (
`apply_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分销商店铺名',
`parent` int(11) NOT NULL DEFAULT 0 COMMENT '上级分销商ID',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '会员ID',
`mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '联系电话',
`nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户昵称',
`headimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户头像',
`level_id` int(11) NOT NULL DEFAULT 0 COMMENT '申请等级',
`level_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '等级名称',
`order_complete_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '订单完成-消费金额',
`order_complete_num` int(10) NOT NULL DEFAULT 0 COMMENT '订单完成-消费次数',
`reg_time` int(11) NOT NULL DEFAULT 0 COMMENT '注册时间',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '申请时间',
`update_time` int(11) NOT NULL DEFAULT 0,
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '申请状态（1申请中 2通过 -1拒绝）',
PRIMARY KEY (`apply_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 4096 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分销商申请表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_goods
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_goods`;
CREATE TABLE `ns_fenxiao_goods` (
`fenxiao_goods_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`goods_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID',
`one_rate` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '一级佣金',
`two_rate` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '二级佣金',
`three_rate` decimal(10,2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '三级佣金',
`state` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否参与',
PRIMARY KEY (`fenxiao_goods_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 8192 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分销商品表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_goods_collect
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_goods_collect`;
CREATE TABLE `ns_fenxiao_goods_collect` (
`collect_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '会员id',
`fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '分销商id',
`goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id',
`sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'skuid',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '收藏时间',
`site_id` int(10) NOT NULL DEFAULT 0 COMMENT '站点id',
PRIMARY KEY (`collect_id`) USING BTREE,
INDEX `IDX_ns_fenxiao_goods_collect_member_id`(`member_id`) USING BTREE,
INDEX `IDX_ns_fenxiao_goods_collect_sku_id`(`sku_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1092 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分销商关注商品表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_goods_sku
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_goods_sku`;
CREATE TABLE `ns_fenxiao_goods_sku` (
`goods_sku_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID',
`sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品skuID',
`level_id` int(11) NOT NULL DEFAULT 0 COMMENT '分销等级ID',
`one_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一级佣金比例',
`one_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一级佣金金额',
`two_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二级佣金比例',
`two_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二级佣金金额',
`three_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '三级佣金比例',
`three_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '三级佣金金额',
PRIMARY KEY (`goods_sku_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 256 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分销商品sku表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_level
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_level`;
CREATE TABLE `ns_fenxiao_level` (
`level_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`level_num` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '等级权重',
`level_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '等级名称',
`one_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一级佣金比例',
`two_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二级佣金比例',
`three_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '三级佣金比例',
`upgrade_type` tinyint(3) NOT NULL DEFAULT 0 COMMENT '升级方式（0满足任意条件 1满足全部条件）',
`fenxiao_order_num` int(11) NOT NULL DEFAULT 0 COMMENT '订单总数',
`fenxiao_order_meney` decimal(10,2) NULL DEFAULT 0.00 COMMENT '订单总金额',
`one_fenxiao_order_num` int(11) NOT NULL DEFAULT 0 COMMENT '一级分销订单总数',
`one_fenxiao_order_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一级分销订单总额',
`order_num` int(11) NOT NULL DEFAULT 0 COMMENT '自购订单总数',
`order_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '自购订单总额',
`child_num` int(11) NOT NULL DEFAULT 0 COMMENT '下线人数',
`child_fenxiao_num` int(11) NOT NULL DEFAULT 0 COMMENT '下线分销商人数',
`one_child_num` int(11) NOT NULL DEFAULT 0 COMMENT '一级下线人数',
`one_child_fenxiao_num` int(11) NOT NULL DEFAULT 0 COMMENT '一级下线分销商',
`status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '状态（0关闭 1启用）',
`create_time` int(11) NOT NULL DEFAULT 0,
`update_time` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`level_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2730 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分销等级配置表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_order
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_order`;
CREATE TABLE `ns_fenxiao_order` (
`fenxiao_order_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`order_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '订单ID',
`order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单编号',
`order_goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '订单项ID',
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点ID',
`site_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站点名称',
`goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID',
`sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品skuid',
`sku_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品sku名称',
`sku_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品图片',
`price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品卖价',
`num` int(11) NOT NULL DEFAULT 0 COMMENT '商品数量',
`real_goods_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品总价',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '购买人ID',
`member_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '购买人名称',
`member_mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '购买人电话',
`full_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '购买人详细地址',
`commission` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '总佣金',
`commission_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '分销总比率',
`one_fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '一级分销商ID',
`one_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一级分销比例',
`one_commission` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '一级分销佣金',
`one_fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '一级分销商名',
`two_fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '二级分销商ID',
`two_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二级分销比例',
`two_commission` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '二级分销佣金',
`two_fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二级分销商名',
`three_fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '三级分销商ID',
`three_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '三级分销比例',
`three_commission` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '三级分销佣金',
`three_fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '三级分销商名',
`is_settlement` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否结算',
`is_refund` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否退款',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`fenxiao_order_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 3276 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分销配置表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for ns_fenxiao_withdraw
-- ----------------------------
DROP TABLE IF EXISTS `ns_fenxiao_withdraw`;
CREATE TABLE `ns_fenxiao_withdraw` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id',
`withdraw_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提现流水号',
`member_id` int(11) NOT NULL DEFAULT 0 COMMENT '会员id',
`fenxiao_id` int(11) NOT NULL DEFAULT 0 COMMENT '分销商id',
`fenxiao_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分销商名称',
`withdraw_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提现类型（weixin-微信 alipay-支付宝 balance-余额 bank银行卡）',
`bank_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提现银行名称',
`account_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提现银行账号',
`realname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提现账户姓名',
`mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机',
`money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提现金额',
`withdraw_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提现手续费率',
`withdraw_rate_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提现手续费金额',
`real_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '实际到账金额',
`status` smallint(6) NOT NULL DEFAULT 1 COMMENT '当前状态 1待审核 2已审核 -1 已拒绝',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '申请日期',
`payment_time` int(11) NOT NULL DEFAULT 0 COMMENT '到账日期',
`modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改日期',
`transfer_type` int(11) NOT NULL DEFAULT 1 COMMENT '转账方式 1 线下转账 2线上转账',
`transfer_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '转账银行名称',
`transfer_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '转账备注',
`transfer_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '转账流水号',
`transfer_account_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '转账银行账号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1638 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会员余额提现记录表' ROW_FORMAT = Compact;
```
- 序言
- 商城简介
- 代码规范
- model层命名规范
- 前端（管理页面）命名
- 控制器命名规范
- 入门指导
- 伪静态配置
- 数据库配置
- 系统环境
- 系统框架
- 目录结构
- 数据库操作
- 标准代码(前端)
- 提示面板
- 表单
- 插件开发
- 插件目录
- 插件开发说明
- 事件开发
- 常用事件
- 数据字典
- 系统基础表
- 微信小程序相关
- 微信公众号相关
- 配送相关表
- 商品相关表
- 店铺网站设置相关
- 门店相关表
- 会员相关表
- 订单相关表
- 营销（组合套餐）
- 营销（砍价）
- 营销（优惠券）
- 营销（限时折扣）
- 营销（满额包邮）
- 营销（互动游戏）
- 营销（团购）
- 营销（满减送）
- 营销（拼团）
- 营销（秒杀）
- 营销（专题）
- 应用（分销）
- 应用（店铺笔记）
- 应用（小票打印）
- 应用（积分兑换）