src/main/resources/mapper/modules/ContractHoldOrderEntityMapper.xml
@@ -8,7 +8,7 @@ FROM contract_hold_order s LEFT JOIN member m ON m.id = s.member_id WHERE <where> s.member_id IN ( SELECT id @@ -17,7 +17,6 @@ WHERE account_type = '1' ) <where> <if test="record != null" > <if test="record.account!=null and record.account!=''"> and (m.phone = #{record.account} or m.email = #{record.account} or m.invite_id=#{record.account}) src/main/resources/mapper/modules/MemberMapper.xml
@@ -16,7 +16,7 @@ <if test="record.endTime!=null"> and #{record.endTime} >= m.create_time </if> <if test="record.account!=null"> <if test="record.account!=null and record.account!=''"> and (m.phone = #{record.account} or m.email = #{record.account} or m.invite_id=#{record.account}) </if> <if test="record.accountStatus!=null"> @@ -25,7 +25,7 @@ <if test="record.accountType != null" > and m.account_type = #{record.accountType} </if> <if test="record.certifyStatus != null"> <if test="record.certifyStatus != null and record.certifyStatus!=''"> and m.certify_status = #{record.certifyStatus} </if> </if> src/main/resources/templates/febs/views/modules/member/member.html
@@ -17,7 +17,6 @@ <div class="layui-input-inline"> <select name="certifyStatus"> <option value="">请选择</option> <option value="0">未通过</option> <option value="1">待审核</option> <option value="2">审核通过</option> <option value="3">未实名</option>
