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);
}