jee-weapp基于jfinal，dubbo微服务

Table: t_agent -------------+--------------+------+-----+---------+--------- Field | Type | Null | Key | Default | Remarks -------------+--------------+------+-----+---------+--------- id | BIGINT(19) | NO | PRI | | seller_id | BIGINT(19) | NO | | | buyer_id | BIGINT(19) | NO | | | 关联的会员Id parent_id | BIGINT(19) | YES | | | 上级Id agent_name | VARCHAR(64) | YES | | | 代理人名称 agent_phone | VARCHAR(64) | YES | | | agent_addr | VARCHAR(255) | YES | | | 详细地址 expire_date | DATETIME(19) | YES | | | 到期时间 audit_date | DATETIME(19) | YES | | | 审核时间 status | INT(10) | YES | | | 状态0，不通过审核，1通过审核，2待审核，3取消分销商资格 active | BIT(1) | YES | | | created | DATETIME(19) | YES | | | updated | DATETIME(19) | YES | | | -------------+--------------+------+-----+---------+--------- Table: t_agent_aduit_log -------------+--------------+------+-----+---------+--------- Field | Type | Null | Key | Default | Remarks -------------+--------------+------+-----+---------+--------- id | BIGINT(19) | NO | PRI | | agent_id | BIGINT(19) | NO | | | 审核对象，审核的分销商 aduit_opter | BIGINT(19) | NO | | | 审核人 content | VARCHAR(255) | YES | | | 审核内容 status | VARCHAR(64) | YES | | | 审核状态，通过，不通过 active | BIT(1) | YES | | | created | DATETIME(19) | YES | | | updated | DATETIME(19) | YES | | | -------------+--------------+------+-----+---------+--------- Table: t_agent_cash_rcd ------------+---------------+------+-----+---------+--------- Field | Type | Null | Key | Default | Remarks ------------+---------------+------+-----+---------+--------- id | BIGINT(19) | NO | PRI | | agent_id | BIGINT(19) | NO | | | cash_value | DECIMAL(10,2) | YES | | | active | BIT(1) | YES | | | created | DATETIME(19) | YES | | | updated | DATETIME(19) | YES | | | ------------+---------------+------+-----+---------+--------- Table: t_agent_comm_rcd ------------------+---------------+------+-----+---------+--------- Field | Type | Null | Key | Default | Remarks ------------------+---------------+------+-----+---------+--------- id | BIGINT(19) | NO | PRI | | agent_id | BIGINT(19) | YES | | | 分销商 order_id | BIGINT(19) | YES | | | commission_value | DECIMAL(10,2) | YES | | | 每一次获得的佣金值，订单交易成功后结算 active | BIT(1) | YES | | | 0为未结算状态，1为已结算 created | DATETIME(19) | YES | | | updated | DATETIME(19) | YES | | | ------------------+---------------+------+-----+---------+--------- Table: t_agent_commssion -----------------+---------------+------+-----+---------+--------- Field | Type | Null | Key | Default | Remarks -----------------+---------------+------+-----+---------+--------- id | BIGINT(19) | NO | PRI | | agent_id | BIGINT(19) | NO | | | commssion_value | DECIMAL(10,2) | YES | | 0.00 | active | BIT(1) | YES | | | created | DATETIME(19) | YES | | | updated | DATETIME(19) | YES | | | -----------------+---------------+------+-----+---------+--------- Table: t_agent_rank ------------------+--------------+------+-----+---------+--------- Field | Type | Null | Key | Default | Remarks ------------------+--------------+------+-----+---------+--------- id | BIGINT(19) | NO | PRI | | seller_id | BIGINT(19) | NO | | | rank_name | VARCHAR(255) | YES | | | first_rate | DECIMAL(10) | YES | | | 一级佣金占比 second_rate | DECIMAL(10) | YES | | | 二级佣金占比 third_rate | DECIMAL(10) | YES | | | 三级佣金占比 reward_value | INT(10) | YES | | | 升到此等级奖励金额 get_cash_time | INT(10) | YES | | | 每月提现次数 get_cash_limit | INT(10) | YES | | | 每月提现上限 children_count | INT(10) | YES | | | 当月累计直属下级用户数量（自动升级条件） total_commission | DECIMAL(10) | YES | | | 当月累计获取佣金（自动升级条件） active | BIT(1) | YES | | | created | DATETIME(19) | YES | | | updated | DATETIME(19) | YES | | | ------------------+--------------+------+-----+---------+--------- Table: t_area -----------+----------------------+------+-----+---------+--------- Field | Type | Null | Key | Default | Remarks -----------+----------------------+------+-----+---------+--------- id | BIGINT(19) | NO | PRI | | 主键_id full_name | LONGTEXT(2147483647) | YES | | | 全称 name | VARCHAR(100) | NO | | | 名称 tree_path | VARCHAR(255) | YES | | | 树路径 parent_id | BIGINT(19) | YES | | | 上级地区 orders | INT(10) | YES | | | 排序 created | DATETIME(19) | YES | | | 创建日期 updated | DATETIME(19) | YES | | | 最后修改日期 active | BIT(1) | NO | | b'0' | 删除标记 -----------+----------------------+------+-----+---------+--------- Table: t_auth_cert -----------+--------------+------+-----+---------+--------- Field | Type | Null | Key | Default | Remarks -----------+--------------+------+-----+---------+--------- id | BIGINT(19) | NO | PRI | | app_id | VARCHAR(255) | YES | | | cert_file | BLOB(65535) | YES | | | active | INT(10) | YES | | | created | DATETIME(19) | YES | | | updated | DATETIME(19) | YES | | | -----------+--------------+------+-----+---------+--------- Table: t_auth_user --------------------------+--------------+------+-----+---------+--------- Field | Type | Null | Key | Default | Remarks --------------------------+--------------+------+-----+---------+--------- id | BIGINT(19) | NO | PRI | | seller_id | BIGINT(19) | NO | | | 注册用户 app_id | VARCHAR(255) | NO | | | 微信公众号id authorizer_access_token | VARCHAR(255) | YES | | | 授权token authorizer_refresh_token | VARCHAR(255) | YES | | | 刷新token expires_in | INT(10) | YES | | | token过期时长 select_func_info | TEXT(65535) | YES | | | 授权时候