class LoginUserDao extends BaseDao {

    public List<LoginUserView> findUserPageList(Paging<LoginUser> paging) throws SQLException {
        String sql = "SELECT t1.id, t1.user_no, t1.user_name, t1.user_email, t1.user_real_name , t2.user_real_name as update_user_name, t4.group_name FROM login_users t1 " +
                "left join login_users t2 on t1.update_user_no = t2.user_no " +
                "left join user_group t3 on t3.user_id = t1.id " +
                "left join dal_group t4 on t3.group_id= t4.id " + appenCondition(paging);
        return this.queryBySql(sql, LoginUserView.class);
    }

}