FindPaperPhysics.java

Go to the documentation of this file.

package cedar.hepdata.webapp.pages;

import cedar.hepdata.model.*;
import cedar.hepdata.xml.*;
import cedar.hepdata.db.*;

import org.apache.tapestry.annotations.*;
import org.apache.tapestry.services.*;

import org.hibernate.*;
import org.hibernate.criterion.*;
import java.util.*;

public class FindPaperPhysics{

    @Inject
    private RequestGlobals _reqGlobals;

    @Inject
    private org.hibernate.Session _session;

   
    public String getQueryParam(String param){
       return _reqGlobals.getRequest().getParameter(param);
    }

    public String getQueryParameters(){
        StringBuffer qs = new StringBuffer();
        String mid = "";
        int number =  Integer.parseInt(getQueryParam("number"));
        int newstart = Integer.parseInt(getQueryParam("start"));
        newstart += number;
        qs.append(mid + "beam=" + getQueryParam("beam"));  mid = "&";
        qs.append(mid + "targ=" + getQueryParam("targ"));  mid = "&";
        qs.append(mid + "fsp1=" + getQueryParam("fsp1"));  mid = "&"; 
        qs.append(mid + "mfsp1=" + getQueryParam("mfsp1"));  mid = "&";
        qs.append(mid + "fsp2=" + getQueryParam("fsp2"));  mid = "&"; 
        qs.append(mid + "mfsp2=" + getQueryParam("mfsp2"));  mid = "&";
        qs.append(mid + "fsp3=" + getQueryParam("fsp3"));  mid = "&"; 
        qs.append(mid + "mfsp3=" + getQueryParam("mfsp3"));  mid = "&";
        qs.append(mid + "obs=" + getQueryParam("obs"));  mid = "&";
        qs.append(mid + "number=" + getQueryParam("number") + mid + "start=" + Integer.toString(newstart));
        return qs.toString().replaceAll("\\+","%2B");
    }

    public String getFirstNumber(){
       return getQueryParam("start");
    }

    public String getLastNumber(){
        int first =  Integer.parseInt(getQueryParam("start"));
        int number = Integer.parseInt(getQueryParam("number"));
        int last = first + number - 1;
        return Integer.toString(last);
   }

    public String getPageSize(){
       return getQueryParam("number");
    }

    public Long getCount(){
        return (Long) constructQuery("count").uniqueResult();
    }

//Papers
    private Paper _paper;
    public Paper getPaper() { return _paper; }
    public void setPaper(Paper p) { _paper = p; }
   
    public List <Paper> getPapers(){
        Query q = constructQuery();
           // how many results do we want out and where to start
        q.setFirstResult(Integer.parseInt(getQueryParam("start"))).setMaxResults(Integer.parseInt(getQueryParam("number")));
           // execute the query and return the list of results
        return q.list();   
    }


    private Query constructQuery(){
        return this.constructQuery("blank");
    }

    private Query constructQuery(String flag){

        String theBeam = "";
        String theTarg = "";
        String theFsp1 = "";
        String theFsp2 = "";
        String theFsp3 = "";
        String theMFsp1 = "";
        String theMFsp2 = "";
        String theMFsp3 = "";
        String theObs = "";
        if ( getQueryParam("beam") != "") { theBeam = getQueryParam("beam"); }
        if ( getQueryParam("targ") != "") { theTarg = getQueryParam("targ"); }
        if ( getQueryParam("fsp1") != "") { theFsp1 = getQueryParam("fsp1"); } 
        if ( getQueryParam("mfsp1") != ""){ theMFsp1 = getQueryParam("mfsp1"); }
        if ( getQueryParam("fsp2") != "") { theFsp2 = getQueryParam("fsp2"); } 
        if ( getQueryParam("mfsp2") != ""){ theMFsp2 = getQueryParam("mfsp2"); }
        if ( getQueryParam("fsp3") != "") { theFsp3 = getQueryParam("fsp3"); } 
        if ( getQueryParam("mfsp3") != ""){ theMFsp3 = getQueryParam("mfsp3"); }
        if ( getQueryParam("obs")  != "") { theObs  = getQueryParam("obs");  }

        Query q = null;

        // the string buffer way!!
        StringBuffer b = new StringBuffer();

        // assuming a spiresid search first 
        // assuming we have a beam particle next 
        if(theBeam != ""){
            if (flag == "count"){
                b.append("select count(distinct pbeam) from Paper pbeam join pbeam._datasets dsbeam join dsbeam._yAxes yabeam join yabeam._reactions yrbeam join yrbeam._initialState beam"); 
           }
            else{
                b.append("select distinct pbeam from Paper pbeam join pbeam._datasets dsbeam join dsbeam._yAxes yabeam join yabeam._reactions yrbeam join yrbeam._initialState beam"); 
            }
            if (theTarg != ""){ b.append(",Paper ptarg join ptarg._datasets dstarg join dstarg._yAxes yatarg join yatarg._reactions yrtarg join yrtarg._initialState targ"); }
            if (theFsp1 != ""){ b.append(",Paper pfsp1 join pfsp1._datasets dsfsp1 join dsfsp1._yAxes yafsp1 join yafsp1._reactions yrfsp1 join yrfsp1._finalState fsp1"); }
            if (theFsp2 != ""){ b.append(",Paper pfsp2 join pfsp2._datasets dsfsp2 join dsfsp2._yAxes yafsp2 join yafsp2._reactions yrfsp2 join yrfsp2._finalState fsp2"); }
            if (theFsp3 != ""){ b.append(",Paper pfsp3 join pfsp3._datasets dsfsp3 join dsfsp3._yAxes yafsp3 join yafsp3._reactions yrfsp3 join yrfsp3._finalState fsp3"); }
            b.append(" where beam.name=:beampart");
            if (theTarg != ""){ b.append(" and targ.name=:targpart"); } 
            if (theFsp1 != ""){ b.append(" and fsp1.name=:fsp1part and fsp1.multiplicity=:fsp1mult"); } 
            if (theFsp2 != ""){ b.append(" and fsp2.name=:fsp2part and fsp2.multiplicity=:fsp2mult"); } 
            if (theFsp3 != ""){ b.append(" and fsp3.name=:fsp3part and fsp3.multiplicity=:fsp3mult"); } 
            if (theObs  != ""){ b.append(" and yabeam._observable=:observable"); } 
            if (theTarg != ""){ b.append(" and yrbeam = yrtarg");  }
            if (theFsp1 != ""){ b.append(" and yrbeam = yrfsp1"); }
            if (theFsp2 != ""){ b.append(" and yrbeam = yrfsp2"); }
            if (theFsp3 != ""){ b.append(" and yrbeam = yrfsp3"); }
            q = _session.createQuery(b.toString());
            q.setString("beampart",theBeam);
            if (theTarg != "")  {q.setString( "targpart",theTarg); }
            if (theFsp1 != "")  {q.setString( "fsp1part",theFsp1); }
            if (theFsp2 != "")  {q.setString( "fsp2part",theFsp2); }
            if (theFsp3 != "")  {q.setString( "fsp3part",theFsp3); }
            if (theFsp1 != "")  {q.setString( "fsp1mult",theMFsp1); }
            if (theFsp2 != "")  {q.setString( "fsp2mult",theMFsp2); }
            if (theFsp3 != "")  {q.setString( "fsp3mult",theMFsp3); }
            if (theObs  != "")  {q.setString( "observable",theObs); }
        }

        // no inital state so next assuming we have a fsp
        else if(theFsp1 != "") {
            if (flag == "count"){
                b.append("select count(distinct pfsp1) from Paper pfsp1 join pfsp1._datasets dsfsp1 join dsfsp1._yAxes yafsp1 join yafsp1._reactions yrfsp1 join yrfsp1._finalState fsp1"); 
            }
            else{
                b.append("select distinct pfsp1 from Paper pfsp1 join pfsp1._datasets dsfsp1 join dsfsp1._yAxes yafsp1 join yafsp1._reactions yrfsp1 join yrfsp1._finalState fsp1"); 
            }
            if (theFsp2 != ""){ b.append(",Paper pfsp2 join pfsp2._datasets dsfsp2 join dsfsp2._yAxes yafsp2 join yafsp2._reactions yrfsp2 join yrfsp2._finalState fsp2"); }
            if (theFsp3 != ""){ b.append(",Paper pfsp3 join pfsp3._datasets dsfsp3 join dsfsp3._yAxes yafsp3 join yafsp3._reactions yrfsp3 join yrfsp3._finalState fsp3"); }
            b.append(" where fsp1.name=:fsp1part and fsp1.multiplicity=:fsp1mult"); 
            if (theFsp2 != ""){ b.append(" and fsp2.name=:fsp2part and fsp2.multiplicity=:fsp2mult"); } 
            if (theFsp3 != ""){ b.append(" and fsp3.name=:fsp3part and fsp3.multiplicity=:fsp3mult"); } 
            if (theObs  != ""){ b.append(" and yafsp1._observable=:observable"); } 
            if (theFsp2 != ""){ b.append(" and yrfsp1 = yrfsp2"); }
            if (theFsp3 != ""){ b.append(" and yrfsp1 = yrfsp3"); }
            q = _session.createQuery(b.toString());
            q.setString("fsp1part",theFsp1); q.setString("fsp1mult",theMFsp1);
            if (theFsp2 != "") {q.setString("fsp2part",theFsp2); q.setString("fsp2mult",theMFsp2);}
            if (theFsp3 != "") {q.setString("fsp3part",theFsp3); q.setString("fsp3mult",theMFsp3);}
            if (theObs  != "") {q.setString("observable",theObs);}
        }

        // OK no reaction  .. so do we have an observable? 
        else if(theObs != "") {
            if (flag == "count"){
                b.append("select count(distinct pobs) from Paper pobs join pobs._datasets dsobs join dsobs._yAxes yaobs"); 
            }
            else{
                b.append("select distinct pobs from Paper pobs join pobs._datasets dsobs join dsobs._yAxes yaobs"); 
            }
            b.append(" where yaobs._observable=:observable");  
            q = _session.createQuery(b.toString());
            q.setString("observable",theObs);
        }

        // nothing left so must want everything !!
        else {
            if (flag == "count"){
                b.append("select count(distinct pa) from Paper pa");
            }
            else{
                b.append("select distinct pa from Paper pa");
            }
            q = _session.createQuery(b.toString());
        }

        // how many results do we want out
        q.setMaxResults(Integer.parseInt(getQueryParam("number")));

        // execute the query and return the list of results
        return q;

    }
        
     
}

---