Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.repository.dtr;

import java.time.LocalDateTime;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.spice.profitmandi.dao.entity.user.Lead;

import com.spice.profitmandi.dao.enumuration.dtr.LeadStatus;

@Repository

public interface LeadRepository {

	public void persist(Lead lead);

	public List<Lead> selectByAssignAuthIdAndStatus(int authId, LeadStatus status, int offset, int limit);

	public Lead selectById(int id);

	public List<Lead> selectByAssignAuthIdAndStatus(int authId, LeadStatus status);

	public List<Lead> selectByAssignAuthIdsAndStatus(List<Integer> authId, LeadStatus status);

	public List<Lead> selectAll(int offset, int limit);

	public List<Lead> selectAllBylistStatus(List<LeadStatus> status);

	public List<Lead> selectAllByStatus(LeadStatus status);

	public List<Lead> selectAllByStatusAndUpdatedTimestamp(List<LeadStatus> status, LocalDateTime updatedTimestamp);

	public List<Lead> selectAllByStatus(List<LeadStatus> status, int offset, int limit);

	List<Lead> selectLeadsScheduledBetweenDate(List<Integer> fofoIds, LocalDateTime startDate, LocalDateTime endDate);

	public long selectCountByStatus(List<LeadStatus> status);

	public long getLeadCount(LeadStatus status, String searchTerm);

	public List<Lead> selectBySearchTerm(List<LeadStatus> status, String searchTerm, int offset, int limit);

	public List<Lead> selectAllByColorStatusAndUpdatedTimestamp(List<LeadStatus> status,

			List<String> color, LocalDateTime updatedTimestamp);

	List<Lead> selectAllByStatusAndUpdatedTimestampAndAuthId(List<LeadStatus> status, LocalDateTime updatedTimestamp,

			List<Integer> authIds);

	List<Lead> selectAllByColorStatusAndUpdatedTimestampAndAuthIds(List<LeadStatus> status, List<Integer> authIds,

			List<String> color, LocalDateTime updatedTimestamp);

}