package com.ekexiu.console.system.dao;

import com.ekexiu.console.system.po.Ppaper;
import org.jfw.apt.annotation.Nullable;
import org.jfw.apt.orm.annotation.dao.Column;
import org.jfw.apt.orm.annotation.dao.DAO;
import org.jfw.apt.orm.annotation.dao.method.From;
import org.jfw.apt.orm.annotation.dao.method.OrderBy;
import org.jfw.apt.orm.annotation.dao.method.operator.PageQuery;
import org.jfw.apt.orm.annotation.dao.method.operator.QueryVal;
import org.jfw.apt.orm.annotation.dao.method.operator.SelectOne;
import org.jfw.apt.orm.annotation.dao.method.operator.UpdateWith;
import org.jfw.apt.orm.annotation.dao.param.*;
import org.jfw.apt.orm.core.defaultImpl.StringHandler;
import org.jfw.util.PageQueryResult;

import java.sql.Connection;
import java.sql.SQLException;

/**
 * Created by TT on 2017/7/26.
 */
@DAO
public interface PpaperDao {

    @Nullable
    @SelectOne
    Ppaper query(Connection con, String id) throws SQLException;

    @Nullable
    @QueryVal
    @Column(handlerClass = StringHandler.class, value = "name")
    @From(Ppaper.class)
    String queryById(Connection con, String id) throws SQLException;

    @PageQuery
    @OrderBy(" ORDER BY create_time DESC NULLS LAST")
    PageQueryResult<Ppaper> queryByTime(Connection con, @Nullable @Like String name, @Nullable @Like String authors, @Nullable @GtEq @Alias("createTime") String bt, @Nullable @Alias("createTime") @LtEq String et, int pageSize, int pageNo) throws SQLException;

    @PageQuery
    @OrderBy(" ORDER BY page_views DESC NULLS LAST")
    PageQueryResult<Ppaper> queryByPV(Connection con, @Nullable @Like String name,@Nullable @Like String authors, @Nullable @GtEq @Alias("createTime") String bt, @Nullable @Alias("createTime") @LtEq String et, int pageSize, int pageNo) throws SQLException;

    @UpdateWith
    @From(Ppaper.class)
    int updateSortNum(Connection con, String id, @Set long sortNum) throws SQLException;
}