大屏溯源统计次数sql修改

guoshilong

2022-11-08 72b971c98c46531064d74b68fc8fe8864ed0b544

 src/main/java/org/springblade/modules/process/mapper/ProcessMapper.java

@@ -16,11 +16,13 @@
 */
package org.springblade.modules.process.mapper;

import org.apache.ibatis.annotations.Param;
import org.springblade.modules.process.entity.Process;
import org.springblade.modules.process.vo.ProcessVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
import java.util.Map;

/**
 * 加工记录表 Mapper 接口
@@ -37,6 +39,17 @@
    * @param process
    * @return
    */
   List<ProcessVO> selectProcessPage(IPage page, ProcessVO process);
   List<ProcessVO> selectProcessPage(IPage page, @Param("process") ProcessVO process);

   boolean stockCompare(@Param("saleNum") Double saleNum, @Param("proid") String proid);

   Boolean stockReduce(@Param("saleNum") Double saleNum, @Param("proid") String proid);

    Double statistics(@Param("year") String year, @Param("farmId") String farmId);

   List<Map<String, String>> statisticsMonth(@Param("year") String year, @Param("farmId") String farmId);

   List<Map<String, String>> statisticsYear(@Param("year") String year, @Param("farmId") String farmId);

   List<Map<String, String>> statisticsDay(@Param("year") String year, @Param("farmId") String farmId);
}