package org.jeecg.modules.arj.mapper;
|
|
import com.baomidou.mybatisplus.core.conditions.Wrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.Constants;
|
import org.jeecg.modules.arj.entity.Head;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
|
/**
|
* ;(head)表数据库访问层
|
* @author : http://www.chiner.pro
|
* @date : 2022-11-22
|
*/
|
@Mapper
|
@Repository
|
public interface HeadMapper extends BaseMapper<Head>{
|
/**
|
* 分页查询指定行数据
|
*
|
* @param page 分页参数
|
* @param wrapper 动态查询条件
|
* @return 分页对象列表
|
*/
|
// IPage<Head> selectByPage(IPage<Head> page , @Param(Constants.WRAPPER) Wrapper<Head> wrapper);
|
|
@Select("select * from (select d.*, row_number() over (partition by date(reportTime),leixing order by " +
|
"reportTime desc) as seqnum from head d ) dd" +
|
" where seqnum = 1 order by reportTime desc limit #{pageSize} offset #{pageNo}")
|
List<Head> queryPage2(@Param("pageNo") int pageNo,@Param("pageSize") int pageSize);
|
|
|
@Select("select count(*) from (select d.*, row_number() over (partition by date(reportTime) order by " +
|
"reportTime desc) as seqnum from head d ) dd" +
|
" where seqnum = 1 order by reportTime desc ")
|
int queryCount();
|
|
|
@Select("select * from (select d.*, row_number() over (partition by date(reportTime),leixing order by " +
|
"reportTime asc) as seqnum from head d ) dd" +
|
" where seqnum = 1 and year(now())=year(reportTime) and dayofyear(reportTime) = dayofyear(now()) order by reportTime desc ")
|
List<Head> queryToday();
|
|
/**
|
* 必须对年进行约束，不然，哼哼
|
* @param n
|
* @return
|
*/
|
@Select("select * from (select d.*, row_number() over (partition by date(reportTime),leixing order by " +
|
"reportTime asc) as seqnum from head d ) dd" +
|
" where seqnum = 1 and year(now())=year(reportTime) and (dayofyear(now())-dayofyear(reportTime) <= #{n}) order by reportTime desc ")
|
List<Head> queryNday(int n);
|
|
@Select("select * from (select d.*, row_number() over (partition by date(reportTime),leixing order by " +
|
"reportTime desc) as seqnum from head d ) dd" +
|
" where seqnum = 1 and date(reportTime)=date(#{shijian}) order by reportTime desc ")
|
List<Head> queryShijian(@Param("pageNo") int pageNo,@Param("pageSize") int pageSize,@Param("shijian")String shijian);
|
|
@Select("select * from (select d.*, row_number() over (partition by date(reportTime),leixing order by " +
|
"reportTime desc) as seqnum from head d ) dd" +
|
" where seqnum = 1 and leixing =#{leixing} order by reportTime desc ")
|
List<Head> queryleixing(@Param("pageNo") int pageNo,@Param("pageSize") int pageSize,@Param("leixing")String leixing);
|
|
@Select("select * from (select d.*, row_number() over (partition by date(reportTime),leixing order by " +
|
"reportTime desc) as seqnum from head d ) dd" +
|
" where seqnum = 1 and pici =#{pici} order by reportTime desc limit #{pageSize} offset #{pageNo}")
|
List<Head> queryPici(@Param("pageNo") int pageNo,@Param("pageSize") int pageSize,@Param("pici")String pici);
|
|
@Select("select * from (select d.*, row_number() over (partition by date(reportTime),leixing order by " +
|
"reportTime desc) as seqnum from head d ) dd" +
|
" where seqnum = 1 and chanxian =#{chanxian} order by reportTime desc limit #{pageSize} offset #{pageNo}")
|
List<Head> queryChanxian(@Param("pageNo") int pageNo,@Param("pageSize") int pageSize,@Param("chanxian")String chanxian);
|
|
@Select("select * from (select d.*, row_number() over (partition by date(reportTime),leixing order by " +
|
"reportTime desc) as seqnum from head d ) dd" +
|
" where seqnum = 1 and leixing =#{leixing} and date(reportTime)=date(#{shijian}) order by reportTime desc ")
|
List<Head> queryleixingAndShijian(@Param("pageNo") int pageNo,@Param("pageSize") int pageSize,@Param("leixing")String leixing,@Param("shijian")String shijian);
|
|
@Select("select * from head " +
|
" order by reportTime desc limit #{pageSize} offset #{pageNo}")
|
List<Head> queryAll(@Param("pageNo") int pageNo,@Param("pageSize") int pageSize);
|
|
@Select("select * from head " +
|
" where date(reportTime)=date(#{shijian}) order by reportTime desc limit #{pageSize} offset #{pageNo}")
|
List<Head> queryShijianAll(@Param("pageNo") int pageNo,@Param("pageSize") int pageSize,@Param("shijian")String shijian);
|
@Select("select * from head " +
|
" where leixing =#{leixing} order by reportTime desc limit #{pageSize} offset #{pageNo}")
|
List<Head> queryLeixingAll(@Param("pageNo") int pageNo,@Param("pageSize") int pageSize,@Param("leixing")String leixing);
|
|
|
|
@Select("select * from head " +
|
" where reportTime =#{reportTime} and leixing =#{leixing} order by reportTime desc limit #{pageSize} offset #{pageNo}")
|
List<Head> queryShijianAndleixingAll(@Param("pageNo") int pageNo,@Param("pageSize") int pageSize,@Param("leixing")String leixing,@Param("shijian")String shijian);
|
|
|
|
}
|
