WatchedTarget.java

package models;

import java.util.ArrayList;
import java.util.List;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.OneToMany;
import javax.persistence.OneToOne;

import com.avaje.ebean.Expr;
import com.avaje.ebean.Expression;
import com.avaje.ebean.ExpressionList;
import com.avaje.ebean.Page;
import com.fasterxml.jackson.annotation.JsonIgnore;

import play.Logger;
import play.db.ebean.Model;
import uk.bl.Const;

@Entity
public class WatchedTarget extends Model {
	private static final long serialVersionUID = 1L;
	
	@Id
	public Long id;
	
	@JsonIgnore
	@OneToOne
	@JoinColumn(name="id_target")
	public Target target;
	
	@OneToMany(mappedBy="watchedTarget", cascade=CascadeType.ALL) @JsonIgnore
	public List<Document> documents;
    
	@OneToMany(mappedBy="watchedTarget", cascade=CascadeType.ALL) @JsonIgnore
    public List<JournalTitle> journalTitles = new ArrayList<>();
    
	@ManyToMany(cascade=CascadeType.ALL) @JsonIgnore
	@JoinTable(name = "fast_subject_watched_target",
		joinColumns = { @JoinColumn(name = "id_watched_target", referencedColumnName="id") },
		inverseJoinColumns = { @JoinColumn(name = "id_fast_subject", referencedColumnName="id") })
	public List<FastSubject> fastSubjects = new ArrayList<>();

	public String documentUrlScheme;
	
	@Column(columnDefinition = "text")
	public String archivistNotesWT;
	
	public String waybackTimestamp;
	public String getName() { return target.fieldUrls.get(0).url; }
	public static final String SEARCH_FIELD = "target.fieldUrls.url";
	
	public static final Model.Finder<Long, WatchedTarget> find = new Model.Finder<>(Long.class, WatchedTarget.class);
	
    public WatchedTarget(Target target, String documentUrlScheme) {
		this.target = target;
		this.documentUrlScheme = documentUrlScheme;
	}
	public static Page<WatchedTarget> page(Long userId, boolean children,
			int page, int pageSize, String sortBy, String order, String filter) {
		
		ExpressionList<WatchedTarget> el = find.fetch("target").where();
		
		if (userId != null) {
			if (children) {
				List<Target> ownedTargets = Target.find.where().eq(Const.ACTIVE, true).eq("author_id", userId).findList();						
				Expression expr = Expr.eq("target.authorUser.id", userId);
				for (Target ownedTarget : ownedTargets) {
					if(ownedTarget.fieldUrls.size()>0){
					String[] urlParts = ownedTarget.fieldUrls.get(0).url.split("//", 2);
					String urlWithoutProtocol = urlParts.length == 2 ?
							ownedTarget.fieldUrls.get(0).url.split("//", 2)[1] :
							ownedTarget.fieldUrls.get(0).url;
					expr = Expr.or(Expr.icontains("target.fieldUrls.url", urlWithoutProtocol), expr);
					}
				}
				el = el.add(expr);			
			} else {
				el = el.eq("target.authorUser.id", userId);
			}
		}
		
        return el.icontains(SEARCH_FIELD, filter)
        		.orderBy(sortBy + " " + order)
        		.findPagingList(pageSize)
        		.setFetchAhead(false)
        		.getPage(page);
    }
	@Override
	public String toString() {
		Long target_id = null;
		if( target != null ) target_id = target.id;
		return "WatchedTarget [id=" + id + ", documents=" + documents
				+ ", journalTitles=" + journalTitles + ", fastSubjects="
				+ fastSubjects + ", documentUrlScheme=" + documentUrlScheme
				+ ", archivistNotesWT=" + archivistNotesWT
				+ ", waybackTimestamp=" + waybackTimestamp 
				+ ", target_id=" + target_id + "]";
	}
}