package com.job.zsc.mapper;

import com.job.zsc.pojo.OriginalData;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.util.List;

@Mapper
public interface SqlMapper {


    //查询所有
    @Select("select * from qianduan_sql.ed_data")
    List<OriginalData> show_all();

    //模糊查询
    @Select("select * from qianduan_sql.ed_data where shop_name like concat('%',#{shopname},'%')")
    List<OriginalData> findShop(String shopname);

    //条件查询
    List<OriginalData> list(String shopname, LocalDate begin, LocalDate end);

    @Select("select * from qianduan_sql.ed_data where reporting_time between #{begin} and #{end}")
    List<OriginalData> findDate(LocalDate begin, LocalDate end);

    //表单条件查询
    List<OriginalData> findByForm(String name, String number, String dname, String begin, String end);
}