/* * Copyright 2014 Eric F. Savage, code@efsavage.com * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package com.ajah.user.audit.data; import java.util.List; import org.springframework.stereotype.Repository; import com.ajah.spring.jdbc.AbstractAjahDao; import com.ajah.spring.jdbc.criteria.Criteria; import com.ajah.spring.jdbc.criteria.Order; import com.ajah.spring.jdbc.err.DataOperationException; import com.ajah.user.audit.UserAudit; import com.ajah.user.audit.UserAuditField; import com.ajah.user.audit.UserAuditId; import com.ajah.user.audit.UserAuditType; import com.ajah.util.StringUtils; /** * MySQL-based implementation of {@link UserAuditDao}. * * @author Eric F. Savage <code@efsavage.com> * */ @Repository public class UserAuditDaoImpl extends AbstractAjahDao<UserAuditId, UserAudit, UserAudit> implements UserAuditDao { /** * @see com.ajah.user.audit.data.UserAuditDao#count(com.ajah.user.audit.UserAuditType, * com.ajah.user.audit.UserAuditField) */ @Override public int count(final UserAuditType type, final UserAuditField status) throws DataOperationException { final Criteria criteria = new Criteria(); if (type != null) { criteria.eq("type", type); } if (status != null) { criteria.eq("status", status); } return super.count(criteria); } @Override public List<UserAudit> list(final UserAuditType type, final UserAuditField status, final long page, final long count) throws DataOperationException { final Criteria criteria = new Criteria(); if (type != null) { criteria.eq("type", type); } if (status != null) { criteria.eq("status", status); } return super.list(criteria.offset(page * count).rows(count).orderBy("created_date", Order.DESC)); } /** * @see com.ajah.user.audit.data.UserAuditDao#searchCount(String search) */ @Override public int searchCount(final String search) throws DataOperationException { final Criteria criteria = new Criteria(); if (!StringUtils.isBlank(search)) { criteria.like("field", "%" + search.replaceAll("\\*", "%") + "%"); } return super.count(criteria); } }