一、角色管理 禁用启用状态没有保持一致,顺序混乱
解决办法:修改SQL语句
select * from tz_sysrole s
where 1=1
<if test="vo.state !=null ">
AND s.state = #{vo.state}
</if>
<if test="vo.name !=null ">
AND s.name like concat('%',#{vo.name},'%')
</if>
order by s.id asc
order by s.id asc 改为 order by s.state desc
二、书籍订单管理 创建时间顺序不正确
解决办法:修改SQL语句
SELECT
xo.id,
xo.orderId,
xo.allmoney,
xo.account,
xo.account AS nickname,
xo.state,
xo.dtime ,
xo.logisticsCompany,
xo.expressNum,
xo.orderFrom,
( SELECT GROUP_CONCAT( xot.kcname ) FROM `x_orderdetial` xot WHERE xot.OrderID = xo.orderId ) AS kcname
FROM
x_orders xo
left join x_orderdetial xd on xo.orderID=xd.OrderID
WHERE xo.paySource=4 and xd.type=1
<if test="orderId != null and orderId != ''">
and xo.orderId = #{orderId}
</if>
<if test="account != null and account != ''">
and xo.account = #{account}
</if>
<if test="nickName != null and nickName != ''">
and xo.account like concat('%',#{nickName},'%')
</if>
<if test="state != null">
and xo.state = #{state}
</if>
<if test="payType != null ">
and xo.orderFrom = #{payType}
</if>
<if test="payTime1 != null and payTime1 != ''">
and xo.dtime >= #{payTime1}
</if>
<if test="payTime2 != null and payTime2 != ''">
and xo.dtime <= #{payTime2}
</if>
order by xo.dtime desc
order by xo.dtime desc 改为 order by xo.dtime asc
三、无法新增轮播图图片,也无法更改轮播图图片
解决办法:前端接口参数上传不对
四、系统管理-角色管理 上一级无法进行修改下一级权限
解决办法:修改了逻辑判断语句及SQL语句
SELECT
DISTINCT r.*
FROM
tz_sysrole_sysuser s LEFT JOIN tz_sysrole r on s.sysRoleId = r.id
WHERE s.sysUserId= #{tokenUserId}
ORDER BY r.type asc
LIMIT 1
去掉了LIMIT 1,直接获取对象集合,再根据角色类型进行逻辑判断