|  |  | 
 |  |  |  | 
 |  |  |     private String phone; | 
 |  |  |  | 
 |  |  |     private String bindPhone; | 
 |  |  |  | 
 |  |  |     private String level; | 
 |  |  |  | 
 |  |  |     private String levelName; | 
 
 |  |  | 
 |  |  |  | 
 |  |  |     private String memberPhone; | 
 |  |  |  | 
 |  |  |     private String memberBindPhone; | 
 |  |  |  | 
 |  |  |     private String memberEmail; | 
 |  |  | } | 
 
 |  |  | 
 |  |  |  | 
 |  |  |     private String buyPhone; | 
 |  |  |  | 
 |  |  |     private String buyBindPhone; | 
 |  |  |  | 
 |  |  |     private String addressDetail; | 
 |  |  |  | 
 |  |  |     private Long orderId; | 
 
 |  |  | 
 |  |  |  | 
 |  |  |     private String phone; | 
 |  |  |  | 
 |  |  |     private String bindPhone; | 
 |  |  |  | 
 |  |  |     private Integer status; | 
 |  |  | } | 
 
 |  |  | 
 |  |  |  | 
 |  |  |     private String payMethod; | 
 |  |  |  | 
 |  |  |     private String bindPhone; | 
 |  |  |  | 
 |  |  | } | 
 
 |  |  | 
 |  |  |                     and ( | 
 |  |  |                         m.phone like concat('%',  #{record.account},'%') | 
 |  |  |                         or m.email like concat('%',  #{record.account},'%') | 
 |  |  |                         or m.bind_phone like concat('%',  #{record.account},'%') | 
 |  |  |                         or m.invite_id like concat('%',  #{record.account},'%') | 
 |  |  |                         ) | 
 |  |  |                 </if> | 
 
 |  |  | 
 |  |  |         select | 
 |  |  |         a.*, | 
 |  |  |         b.name, | 
 |  |  |         b.bind_phone bindPhone, | 
 |  |  |         c.pay_method payMethod, | 
 |  |  |         b.phone | 
 |  |  |         from mall_money_flow a | 
 |  |  | 
 |  |  |         select | 
 |  |  |         a.*, | 
 |  |  |         b.name, | 
 |  |  |         b.bind_phone bindPhone, | 
 |  |  |         b.phone | 
 |  |  |         from mall_money_flow a | 
 |  |  |         inner join mall_member b on a.member_id=b.id | 
 
 |  |  | 
 |  |  |     </select> | 
 |  |  |  | 
 |  |  |     <select id="selectOrderListInPage" resultType="cc.mrbird.febs.mall.vo.AdminMallOrderInfoVo"> | 
 |  |  |         select *,b.name memberName,b.phone memberPhone | 
 |  |  |         select *, | 
 |  |  |                b.name memberName, | 
 |  |  |                b.bind_phone memberBindPhone, | 
 |  |  |                b.phone memberPhone | 
 |  |  |         from mall_order_info a | 
 |  |  |         left join mall_member b on a.member_id = b.id | 
 |  |  |         <where> | 
 
 |  |  | 
 |  |  |     </select> | 
 |  |  |  | 
 |  |  |     <select id="selectRefundListInPage" resultType="cc.mrbird.febs.mall.vo.AdminMallOrderRefundVo"> | 
 |  |  |         select a.*,b.name buyName ,b.phone buyPhone,c.order_no,c.amount,CONCAT(a.name,a.phone,a.address) addressDetail | 
 |  |  |         select a.*, | 
 |  |  |                b.name buyName , | 
 |  |  |                b.phone buyPhone, | 
 |  |  |                b.bind_phone buyBindPhone, | 
 |  |  |                c.order_no, | 
 |  |  |                c.amount, | 
 |  |  |                CONCAT(a.phone,a.bind_phone,a.address) addressDetail | 
 |  |  |  | 
 |  |  |         from mall_order_refund a | 
 |  |  |         left join mall_member b on b.id = a.member_id | 
 
 |  |  | 
 |  |  |                 id: 'userAgentTable', | 
 |  |  |                 url: ctx + 'admin/mallMember/getAgentList', | 
 |  |  |                 cols: [[ | 
 |  |  |                     {field: 'phone', title: '手机号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'bindPhone', title: '手机号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'phone', title: '账号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'name', title: '名称', minWidth: 100,align:'left'}, | 
 |  |  |                     {field: 'inviteId', title: '邀请码', minWidth: 100,align:'left'}, | 
 |  |  |                     {field: 'levelName', title: '代理层级', minWidth: 100,align:'left'}, | 
 
 |  |  | 
 |  |  |                 url: ctx + 'admin/mallMember/getMoneyChargeList', | 
 |  |  |                 cols: [[ | 
 |  |  |                     {field: 'name', title: '名称', minWidth: 100,align:'left'}, | 
 |  |  |                     {field: 'phone', title: '手机号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'phone', title: '账号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'bindPhone', title: '手机号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'amount', title: '金额', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'status', title: '状态', | 
 |  |  |                         templet: function (d) { | 
 
 |  |  | 
 |  |  |                 id: 'userTable', | 
 |  |  |                 url: ctx + 'admin/mallMember/getMallMemberList', | 
 |  |  |                 cols: [[ | 
 |  |  |                     {field: 'phone', title: '手机号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'phone', title: '账号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'bindPhone', title: '手机号', minWidth: 150,align:'left'}, | 
 |  |  |                     // {field: 'email', title: '邮箱', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'name', title: '名称', minWidth: 100,align:'left'}, | 
 |  |  |                     {field: 'inviteId', title: '邀请码', minWidth: 100,align:'left'}, | 
 
 |  |  | 
 |  |  |                 url: ctx + 'admin/mallMember/getMoneyFlowList', | 
 |  |  |                 cols: [[ | 
 |  |  |                     {field: 'name', title: '名称', minWidth: 100,align:'left'}, | 
 |  |  |                     {field: 'phone', title: '手机号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'phone', title: '账号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'bindPhone', title: '手机号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'amount', title: '金额', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'type', title: '流水类型', | 
 |  |  |                         templet: function (d) { | 
 
 |  |  | 
 |  |  |                 cols: [[ | 
 |  |  |                         {field: 'orderNo', title: '订单编号', minWidth: 200,align:'left'}, | 
 |  |  |                         {field: 'memberName', title: '购买人', minWidth: 120,align:'left'}, | 
 |  |  |                         {field: 'memberPhone', title: '联系方式', minWidth: 120,align:'left'}, | 
 |  |  |                         {field: 'memberPhone', title: '账号', minWidth: 120,align:'left'}, | 
 |  |  |                         {field: 'memberBindPhone', title: '联系方式', minWidth: 120,align:'left'}, | 
 |  |  |                         {field: 'amount', title: '订单金额', minWidth: 120,align:'left'}, | 
 |  |  |                         {field: 'orderTime', title: '下单时间', minWidth: 200,align:'left'}, | 
 |  |  |                         {field: 'payMethod', title: '支付方式', minWidth: 120,align:'left'}, | 
 
 |  |  | 
 |  |  |                 cols: [[ | 
 |  |  |                     {field: 'orderNo', title: '订单编号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'buyName', title: '用户名', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'buyPhone', title: '电话', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'buyPhone', title: '账号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'buyBindPhone', title: '手机号', minWidth: 150,align:'left'}, | 
 |  |  |                     {field: 'beforeStatus', title: '发货状态', | 
 |  |  |                         templet: function (d) { | 
 |  |  |                             if (d.status === 1) { |