1 /* 2 * Copyright (c) 2002-2021, City of Paris 3 * All rights reserved. 4 * 5 * Redistribution and use in source and binary forms, with or without 6 * modification, are permitted provided that the following conditions 7 * are met: 8 * 9 * 1. Redistributions of source code must retain the above copyright notice 10 * and the following disclaimer. 11 * 12 * 2. Redistributions in binary form must reproduce the above copyright notice 13 * and the following disclaimer in the documentation and/or other materials 14 * provided with the distribution. 15 * 16 * 3. Neither the name of 'Mairie de Paris' nor 'Lutece' nor the names of its 17 * contributors may be used to endorse or promote products derived from 18 * this software without specific prior written permission. 19 * 20 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 21 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 22 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE 23 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR CONTRIBUTORS BE 24 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR 25 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF 26 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS 27 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN 28 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 29 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 30 * POSSIBILITY OF SUCH DAMAGE. 31 * 32 * License 1.0 33 */ 34 package fr.paris.lutece.plugins.stock.business.product; 35 36 import fr.paris.lutece.plugins.stock.commons.ResultList; 37 import fr.paris.lutece.plugins.stock.commons.dao.IStockDAO; 38 import fr.paris.lutece.plugins.stock.commons.dao.PaginationProperties; 39 40 import java.sql.Timestamp; 41 import java.util.List; 42 43 /** 44 * IPersonDAO Interface 45 */ 46 public interface IProductDAO extends IStockDAO<Integer, Product> 47 { 48 /** 49 * Finds by filter 50 * 51 * @param filter 52 * the filter 53 * @return the product list 54 */ 55 List<Product> findByFilter( ProductFilter filter ); 56 57 /** 58 * Finds by filter 59 * 60 * @param filter 61 * the filter 62 * @param paginationProperties 63 * the pagination properties 64 * @return the product list 65 */ 66 ResultList<Product> findByFilter( ProductFilter filter, PaginationProperties paginationProperties ); 67 68 /** 69 * Returns products by name 70 * 71 * @param name 72 * product name 73 * @return products list 74 */ 75 List<Product> getAllByName( String name ); 76 77 /** 78 * Return the number of current product 79 * 80 * @param strDate 81 * the current date 82 * @return number of product 83 */ 84 Integer getCountProductALAfficheByDate( String strDate ); 85 86 /** 87 * Return the number of future product 88 * 89 * @param strDate 90 * the current date 91 * @return number of product 92 */ 93 Integer getCountProductAVenirByDate( String strDate ); 94 95 /** 96 * Check if product is ful 97 * 98 * @param productId 99 * the product id 100 * @return true if full, false otherwise 101 */ 102 Boolean isFull( Integer productId ); 103 104 /** 105 * Check if product is type of representation 106 * 107 * @param genreId 108 * the genre to check 109 * @return true if product is, false otherwise 110 */ 111 Boolean isType( Integer productId, Integer genreId ); 112 113 Boolean isTypeOffer( Integer productId, Integer genreId, String keyDate, Timestamp now, String annuleKey ); 114 115 /** 116 * Returns products IDs between two timestamps 117 * 118 * @param keyDate 119 * the attribute key 120 * @param timestampStart 121 * the start timestamp 122 * @param timestamsEnd 123 * the end timestamp 124 * @return the products ids list 125 */ 126 List<Integer> getProductsIdsForTaskTimed( String keyDate, Timestamp timestampStart, Timestamp timestampEnd ); 127 }