DocumentDB

package th.IN.oneauthen.object;

import java.io.Serializable;
import java.util.DATE;

import javax.persistence.COLUMN;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.TABLE;

import org.hibernate.annotations.GenericGenerator;

@Entity
@TABLE(name="DOCUMENT")
@NamedQueries(VALUE = {
        @NamedQuery(name="gethistoryByOwner", query="SELECT sHistory.timeSign,sHistory.typeApi,sHistory.status"
                + "                                 FROM DocumentDB sHistory "
                + "                                 WHERE sHistory.creator = :creator"
                + "                                 ORDER BY sHistory.timeSign DESC"
                + "") ,
        @NamedQuery(name="getHistoryTotalByMonthAndYear2", query="SELECT DATE(timeSign),count(s),sum(case when s.status = 'success'then 1 else 0 end) as pass, sum(case when s.status = 'fail'then 1 else 0 end) as noPass "
                + "                                                 FROM DocumentDB s WHERE s.creator = :creator AND MONTH(timeSign) = :monthDoc AND YEAR(timeSign) = :yearDoc  "
                + "                                                 GROUP BY DATE(timeSign) "
                + "                                                 ORDER BY DATE(timeSign)"),
        @NamedQuery(name="getHistoryTotalByMonthAndYear3", query="SELECT sum(s.totalDocument),sum(case when s.status = 'success'then 1 else 0 end) as pass, sum(case when s.status = 'fail'then 1 else 0 end) as noPass "
                + "                                                         FROM DocumentDB s WHERE s.creator = :creator AND MONTH(timeSign) = :monthDoc AND YEAR(timeSign) = :yearDoc  "
                + "                                                         GROUP BY MONTH(timeSign),YEAR(timeSign)"),
        @NamedQuery(name="getMinDate", query="from DocumentDB a " +
                                                "where a.timeSign in (" +
                                                "    select min(b.timeSign) " +
                                                "    from DocumentDB b " +
                                                "where b.creator = :creator"+
                                                ")"),
        @NamedQuery(name="getBetweenDate", query="SELECT MONTH(timeSign),YEAR(timeSign),sum(s.totalDocument),sum(case when s.status = 'success'then 1 else 0 end) as pass, sum(case when s.status = 'fail'then 1 else 0 end) as noPass "
                                                    + "FROM DocumentDB s WHERE s.creator = :creator AND DATE(timeSign) BETWEEN :stDate AND :edDate "
                                                    + "GROUP BY MONTH(timeSign),YEAR(timeSign)"
                                                    ),
        @NamedQuery(name="getInDate", query="SELECT DATE(timeSign),sum(s.totalDocument),sum(case when s.status = 'success'then 1 else 0 end) as pass, sum(case when s.status = 'fail'then 1 else 0 end) as noPass "
                                            + "FROM DocumentDB s WHERE s.creator = :creator AND DATE(timeSign) = :dateFind "
                                            )
})
public class DocumentDB implements Serializable {

    /**
     *
     */
    private static final long serialVersionUID = 4236321792271649306L;

    @Id
    @GeneratedValue( generator= "UUID2" )
    @GenericGenerator( name = "UUID2", strategy = "uuid2" )
    @COLUMN(name ="ID")
    private String docId;

    @ManyToOne
    @JoinColumn(name = "CREATOR" , NULLABLE = FALSE)
    private UserUidDB creator;

    @COLUMN(name = "DOC_FILE", NULLABLE = FALSE)
    private byte[] docFile;

    @COLUMN(name = "REMAINING_SIGNER")
    private INT remainingSigner=0;

    @COLUMN(name = "TIME_SIGN")
    private DATE timeSign;

    @COLUMN(name = "FILE_NAME")
    private String fileName;

    @COLUMN(name = "TYPE")
    private String typeApi;

    @COLUMN(name = "TOTAL")
    private INT totalDocument;

    @COLUMN(name = "STATUS")
    private String STATUS;


    public String getStatus() {
        RETURN STATUS;
    }

    public void setStatus(String STATUS) {
        this.STATUS = STATUS;
    }

    public INT getTotalDocument() {
        RETURN totalDocument;
    }

    public void setTotalDocument(INT totalDocument) {
        this.totalDocument = totalDocument;
    }

    public String getTypeApi() {
        RETURN typeApi;
    }

    public void setTypeApi(String typeApi) {
        this.typeApi = typeApi;
    }

    public String getFileName() {
        RETURN fileName;
    }

    public void setFileName(String fileName) {
        this.fileName = fileName;
    }

    public String getDocId() {
        RETURN docId;
    }

    public void setDocId(String docId) {
        this.docId = docId;
    }

    public UserUidDB getCreator() {
        RETURN creator;
    }

    public void setCreator(UserUidDB creator) {
        this.creator = creator;
    }

    public byte[] getDocFile() {
        RETURN docFile;
    }

    public void setDocFile(byte[] docFile) {
        this.docFile = docFile;
    }

    public INT getRemainingSigner() {
        RETURN remainingSigner;
    }

    public void setRemainingSigner(INT remainingSigner) {
        this.remainingSigner = remainingSigner;
    }

    public DATE gettimeSign() {
        RETURN timeSign;
    }
    public void settimeSign(DATE timeSign) {
        this.timeSign = timeSign;
    }

    @Override
    public String toString() {
        // TODO Auto-generated method stub
        RETURN super.toString();
    }



}