package ${basePackage}.entity.po;

import com.png.jdbc.BasicQuery;
import com.png.jdbc.annotations.*;
import com.png.jdbc.BasicEntity;

import lombok.Data;
import lombok.EqualsAndHashCode;

import java.util.Date;

/**
*${pojoComment}
*@date ${datetime}
*/
@Data
@EqualsAndHashCode(callSuper = false)
@Entity(clz = ${pojoName}.class,comment ="${pojoComment}")
public class ${pojoName} implements Serializable{
#foreach($ele in $fields)
    #if($ele.dataType=="int")
    @DBF(comment = "${ele.columnComment}")
    private int $ele.columnName;
    #end
    #if($ele.dataType=="tinyint"||$ele.dataType=="bool"||$ele.dataType=='int2')
    @DBF(comment = "${ele.columnComment}")
    private boolean $ele.columnName ;
    #end
    #if($ele.dataType=="bigint")
    @DBF(comment = "${ele.columnComment}")
    private long $ele.columnName ;
    #end
    #if($ele.dataType=="text")
    @DBF(comment = "${ele.columnComment}")
        #if($ele.columnName.indexOf("IdList")!=-1)
        private List<Long> $ele.columnName ;
        #else
            private List<SimpleVo> $ele.columnName ;
        #end
    #end
    #if($ele.dataType=="varchar")
        @DBF(comment = "${ele.columnComment}",max=$ele.dataLength)
        private String $ele.columnName ;
    #end
    #if($ele.dataType=="text")
        @DBF(comment = "${ele.columnComment}")
        private String $ele.columnName ;
    #end
    #if($ele.dataType=="char")
        @DBF(comment = "${ele.columnComment}",max=$ele.dataLength)
        private String $ele.columnName ;
    #end
    #if($ele.dataType=="date")
        @DBF(comment = "${ele.columnComment}")
        private Date $ele.columnName;
    #end
    #if($ele.dataType=="datetime")
        @DBF(comment = "${ele.columnComment}")
        private Date $ele.columnName;
    #end
    #if($ele.dataType=="timestamp")
        @DBF(comment = "${ele.columnComment}")
        private Date $ele.columnName;
    #end
#end

    @Data
    @EqualsAndHashCode(callSuper = true)
    public static class ${pojoName}Info extends ${pojoName}{
    // @One(mkf = "createBy", tf = "name", comment = "创建人")
    // private String createName;

    // @One(mkf = "updateBy", tf = "name", comment = "更新人")
    // private String updateName;
    }

    @Data
    @EqualsAndHashCode(callSuper = true)
    @QE(clz=${pojoName}Info.class)
    public static class ${pojoName}BasicQuery extends BasicQuery{
#foreach($ele in $fields)
    #if($ele.dataType=="int")
        private Integer ${ele.columnName} ;
    #end
    #if($ele.dataType=="tinyint")
        private Boolean $ele.columnName ;
    #end
    #if($ele.dataType=="bigint")
        private Long $ele.columnName ;
    #end
    #if($ele.dataType=="varchar")
        private String $ele.columnName ;
    #end
    #if($ele.dataType=="text")
        private String $ele.columnName ;
    #end
    #if($ele.dataType=="char")
        private String $ele.columnName ;
    #end
#end

    //region date query
#foreach($ele in $fields)
    #if($ele.dataType=="date")
        @QF(op=OP.GTE,tf="${ele.columnName}")
        private Date ${ele.columnName}Start  ;
        @QF(op=OP.LTE,tf="${ele.columnName}")
        private Date ${ele.columnName}End    ;
    #end
    #if($ele.dataType=="datetime")
        @QF(op=OP.GTE,tf="${ele.columnName}")
        private Date ${ele.columnName}Start;
        @QF(op=OP.LTE,tf="${ele.columnName}")
        private Date ${ele.columnName}End    ;
    #end
    #if($ele.dataType=="timestamp")
        @QF(op=OP.GTE,tf="${ele.columnName}")
        private Date ${ele.columnName}Start  ;
        @QF(op=OP.LTE,tf="${ele.columnName}")
        private Date ${ele.columnName}End    ;
    #end
#end
    //endregion


    //region sort query
#foreach($ele in $fields)
    #if($ele.dataType=="int"||$ele.dataType=="bigint"||$ele.dataType=="tinyint"||$ele.dataType=="datetime"||$ele.dataType=="timestamp")
        private Integer ${ele.columnName}Sort    ;
    #end
#end
    //endregion
    }
    }