| | |
| | | <if test="areaCode != null"> |
| | | and cs.area_code=#{areaCode} |
| | | </if> |
| | | AND su.create_at > #{createAt} GROUP BY createAt |
| | | AND su.create_at > #{createAt} GROUP BY specificDate |
| | | </select> |
| | | <select id="getActive" resultType="com.panzhihua.service_user.model.dtos.UsersStatisticsDTO"> |
| | | SELECT DATE_FORMAT( su.last_login_time, '%Y-%m-%d' ) as specificDate ,count(su.user_id) as total FROM |
| | |
| | | <if test="areaCode != null"> |
| | | and cs.area_code=#{areaCode} |
| | | </if> |
| | | AND su.last_login_time > #{lastLoginTime} GROUP BY createAt |
| | | AND su.last_login_time > #{lastLoginTime} GROUP BY specificDate |
| | | </select> |
| | | |
| | | <select id="selectStreetByAreaCode" resultType="com.panzhihua.common.model.vos.user.StreetVOS"> |