/* * This file is part of gwap, an open platform for games with a purpose * * Copyright (C) 2013 * Project play4science * Lehr- und Forschungseinheit für Programmier- und Modellierungssprachen * Ludwig-Maximilians-Universität München * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ package gwap.model; import java.io.Serializable; import java.util.Date; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.Lob; import javax.persistence.NamedQueries; import javax.persistence.NamedQuery; /** * @author Fabian Kneißl */ @NamedQueries({ @NamedQuery(name="newsItem.byPlatform", query="from NewsItem where platform = :platform"), @NamedQuery(name="newsItem.current", query="from NewsItem where platform = :platform and language = :language " + "and datePublished <= NOW() and (dateExpired is null or dateExpired > NOW())") }) @Entity public class NewsItem implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue private Long id; private Date datePublished; private Date dateExpired; private String language; private String platform; @Lob private String text; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public Date getDatePublished() { return datePublished; } public void setDatePublished(Date datePublished) { this.datePublished = datePublished; } public Date getDateExpired() { return dateExpired; } public void setDateExpired(Date dateExpired) { this.dateExpired = dateExpired; } public String getLanguage() { return language; } public void setLanguage(String language) { this.language = language; } public String getPlatform() { return platform; } public void setPlatform(String platform) { this.platform = platform; } public String getText() { return text; } public void setText(String text) { this.text = text; } }