FindPaperFromReaction.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.tapestry5.annotations.*;
import org.apache.tapestry5.ioc.annotations.*;
import org.apache.tapestry5.services.*;

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

public class FindPaperFromReaction{

    @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 + "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();
    }
   
//    public String getSpiresId(){
//      Long _irn = _reaction.getYAxis().getDataset().getPaper().getSpiresId();
//      return String.valueOf(_irn);
//    }

//    public String getRedId(){
//      Long _red = _reaction.getYAxis().getDataset().getPaper().getRedId();
//      return String.valueOf(_red);
//    }

//Paper
    private Paper _paper;
    public Paper getPaper() { return _paper; }
    public void setPaper(Paper p) { _paper = p; }

    private List <Paper> pout = new Vector<Paper>();
    private Long old = null;

    public List <Paper> getPapers(){
        Query q = constructQuery();
//      q.setFirstResult(Integer.parseInt(getQueryParam("start"))).setMaxResults(Integer.parseInt(getQueryParam("number")));
//      q.setFirstResult(Integer.parseInt(getQueryParam("start"))).setMaxResults(Integer.parseInt(getQueryParam("number")));
        
        pout.clear();
        old = null;
        for (Iterator it = q.iterate();  it.hasNext();){
            AxisReaction _reaction = (AxisReaction) it.next();
            _paper = _reaction.getYAxis().getDataset().getPaper(); 
//          if(_paper.getSpiresId().equals(old) )  {} else { pout.add(_paper); }
            if(_paper.getSpiresId() != old) { pout.add(_paper); }
            old = _paper.getSpiresId(); 
            if(pout.size() > 9) break;
        }
        return pout;
    }


//AxisReaction
//    private AxisReaction _reaction;
//    public AxisReaction getReaction() { return _reaction; }
//    public void setReaction(AxisReaction r) { _reaction = r; }
//   
//    public List <AxisReaction> getReactions(){
//        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 = "";
        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"); }

        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 yrbeam) from AxisReaction yrbeam join yrbeam._initialState beam"); 
           }
            else{
                b.append("select distinct yrbeam from AxisReaction yrbeam join yrbeam._initialState beam"); 
            }
            if (theTarg != ""){ b.append(",AxisReaction yrtarg join yrtarg._initialState targ"); }
            if (theFsp1 != ""){ b.append(",AxisReaction yrfsp1 join yrfsp1._finalState fsp1"); }
            if (theFsp2 != ""){ b.append(",AxisReaction yrfsp2 join yrfsp2._finalState fsp2"); }
            if (theFsp3 != ""){ b.append(",AxisReaction 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 (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); }
        }

        // no inital state so next assuming we have a fsp
        else if(theFsp1 != "") {
            if (flag == "count"){
                b.append("select count(distinct yrfsp1) AxisReaction yrfsp1 join yrfsp1._finalState fsp1"); 
            }
            else{
                b.append("select distinct yrfsp1 from AxisReaction yrfsp1 join yrfsp1._finalState fsp1"); 
            }
            if (theFsp2 != ""){ b.append(",AxisReaction yrfsp2 join yrfsp2._finalState fsp2"); }
            if (theFsp3 != ""){ b.append(",AxisRreaction 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 (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);}
        }

        // nothing left so must want everything !!
        else {
            if (flag == "count"){
                b.append("select count(distinct reac) from AxisReaction reac");
            }
            else{
                b.append("select distinct reac from AxisReaction reac");
            }
            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;

    }
        
     
}

---