| | |
| | | |
| | | 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) { |