feat(mall): 为资金流列表添加来源电话字段
- 在 AdminMoneyFlowListVo 中添加 rtPhone 字段,用于存储来源电话
- 在 MallMoneyFlowMapper.xml 中添加查询来源电话的 SQL语句
- 在 moneyFlowList.html 中添加来源电话的列显示
| | |
| | | |
| | | private String phone; |
| | | |
| | | private String rtPhone; |
| | | |
| | | private Integer status; |
| | | |
| | | private String payMethod; |
| | |
| | | select |
| | | a.*, |
| | | b.name, |
| | | b.phone |
| | | b.phone, |
| | | (select phone from mall_member where id = a.rt_member_id) rtPhone |
| | | from mall_money_flow a |
| | | inner join mall_member b on a.member_id=b.id |
| | | <where> |
| | |
| | | return '-'; |
| | | } |
| | | }, minWidth: 80,align:'center'}, |
| | | |
| | | {field: 'rtPhone', title: '来源', minWidth: 150,align:'left'}, |
| | | {field: 'createdTime', title: '创建时间', minWidth: 180,align:'center'} |
| | | ]] |
| | | }); |