1 /* 2 * Copyright (c) 2002-2018, Mairie de 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.modules.recommendation.business; 35 36 import fr.paris.lutece.portal.service.plugin.Plugin; 37 import fr.paris.lutece.util.sql.DAOUtil; 38 import java.util.ArrayList; 39 import java.util.List; 40 41 /** 42 * StockPurchaseDAO 43 */ 44 public class StockPurchaseDAO 45 { 46 private static final String SQL_QUERY_SELECTALL = "SELECT a.username , b.product_id FROM stock_purchase a, stock_offer b WHERE a.offer_id = b.id_offer"; 47 private static final String SQL_QUERY_SELECT_USERS = "SELECT DISTINCT username FROM stock_purchase"; 48 49 /** 50 * Read all purchase data 51 * 52 * @param plugin 53 * The plugin 54 * @return The list of purchase data 55 */ 56 public List<UserItem> selectUserItemsList( Plugin plugin ) 57 { 58 List<UserItem> list = new ArrayList<UserItem>( ); 59 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECTALL, plugin ); 60 daoUtil.executeQuery( ); 61 62 while ( daoUtil.next( ) ) 63 { 64 UserItem userItem = new UserItem( ); 65 66 userItem.setUserName( daoUtil.getString( 1 ) ); 67 userItem.setItemId( daoUtil.getInt( 2 ) ); 68 69 list.add( userItem ); 70 } 71 72 daoUtil.free( ); 73 74 return list; 75 } 76 77 /** 78 * Select all users that purchase an item 79 * 80 * @param plugin 81 * The plugin 82 * @return The list of users 83 */ 84 public List<String> selectUsersList( Plugin plugin ) 85 { 86 List<String> list = new ArrayList<String>( ); 87 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_USERS, plugin ); 88 daoUtil.executeQuery( ); 89 90 while ( daoUtil.next( ) ) 91 { 92 list.add( daoUtil.getString( 1 ) ); 93 } 94 95 daoUtil.free( ); 96 97 return list; 98 } 99 }