DAL-TMS-TRUCK-API/src/main/java/com/steerinfo/dil/mapper/StatisticalReportMapper.java

package com.steerinfo.dil.mapper;

import org.apache.ibatis.annotations.Mapper;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

/**
 * 统计报表
 * @ author    :TXF
 * @ time      :2021/12/14 15:27
 */
@Mapper
public interface StatisticalReportMapper {


    //查询采购统计报表 (辅料、燃料、内转、化工材料)
    List<Map<String, Object>> getAllPurchaseFLRLReport(Map<String, Object> map);

    //查询采购辅料统计报表
    List<Map<String, Object>> getFuPurchaseFLRLReport(Map<String, Object> map);


    //查询销售统计报表
    List<Map<String, Object>> getAllSaleReport(Map<String, Object> map);

//    查询零星物资进厂统计报表
    List<Map<String, Object>> getSporadicSuppliesReport1(Map<String, Object> mapValue);

    //    查询零星物资出厂统计报表
    List<Map<String, Object>> getSporadicSuppliesReport2(Map<String, Object> mapValue);

    // 查询采购内转统计报表
    List<Map<String, Object>> getTotalResultList();

    List<Map<String, Object>> getInwardReportResult(Map<String,Object> mapValue);

    //查看内转统计报表
    List<Map<String, Object>> getInwardReport(Map<String, Object> mapValue);
    //查看装货点统计表
    List<Map<String, Object>> getLoading(Map<String, Object> mapValue);

    List<Map<String, Object>> getUnLoading(Map<String, Object> mapValue);

    List<Map<String, Object>> getLXReportResult(Map<String, Object> mapValue);

    //获取装机统计报表
    List<Map<String,Object>> getLoaderResult(Map<String,Object> map);

    //保卫部随机抽查车牌号
    List<Map<String, Object>>   getCapacityByDefend(Map<String, Object> map);

    //拼装车统计报表
    List<Map<String, Object>> getInwardReportForAssemble(Map<String, Object> mapValue);

    //判断是否装机备注
    List<Map<String,Object>> getCapacityRemark(Map<String,Object> map);

    List<Map<String, Object>> getLoaderForResultDetail(Map<String, Object> mapValue);

    //查看该组织架构下的销售订单统计报表
    List<Map<String, Object>> getSaleOrderList(Map<String, Object> mapValue);

    //查看该组织架构下的采购订单统计报表
    List<Map<String, Object>> getPurchaseOrderList(Map<String, Object> mapValue);

    //查看该组织架构下的内转统计报表
    List<Map<String, Object>> getPurchaseInwardList(Map<String, Object> mapValue);


    //查看该组织架构下的厂内内转统计报表
    List<Map<String, Object>> getInwardInFactory(Map<String, Object> mapValue);

    //查询该组织下厂外-厂内内转统计报表（猫儿寨等）
    List<Map<String, Object>> getOutFactoryInwardList(Map<String, Object> mapValue);

    //查询销售钢材统计报表
    List<Map<String, Object>> getSaleSteelReport(Map<String, Object> mapValue);

    List<Map<String, Object>> getSaleSteelReportFD(Map<String, Object> mapValue);

    //查询销售钢材统计报表
    List<Map<String, Object>> getSaleSteelSpellingReport(Map<String, Object> mapValue);

    //根据计费详单的需求修改后的钢材统计报表
    List<Map<String, Object>> getSaleSteelReportNew(Map<String, Object> mapValue);

    //根据计费详单的需求修改后的钢材统计报表(已结算)
    List<Map<String, Object>> getSettledSaleSteelReportNew(Map<String, Object> mapValue);

    List<Map<String, Object>> getInwardSaleSteelReport(Map<String, Object> map);

    List<Map<String, Object>> getInwardSaleSteelOrder(Map<String, Object> map);

    Map<String, Object> getSteelReportDetailsBySmId(BigDecimal saleOrderMaterialId);

    List<Map<String, Object>> getSteelReportDetailsListBySmId(BigDecimal saleOrderMaterialId);

    String queryAddress(BigDecimal priceId);

    BigDecimal queryHistoryPrice(BigDecimal addressid);

    String queryCapacityNumber(BigDecimal capacityNumber);

    List<Map<String, Object>> getCarrierFilterList(Map<String, Object> map);


    List<Map<String, Object>> loadingSaleSteelReport(Map<String, Object> map);

    //获得进出厂状态
    String getStatus(BigDecimal orderId);

    List<String> getSaleAreaRemark(String saler);

    List<Map<String, Object>> getSaleSteelReportForFinance(Map<String, Object> map);

    List<Map<String, Object>> steelTransportReport(Map<String, Object> map);

    List<Map<String, Object>> getNoSaleterialIdWeight();

    List<BigDecimal> getSaleMaterialIds(BigDecimal orderId, BigDecimal materialId);

    int updateTw(BigDecimal weightTaskId, BigDecimal dataToBigDecimal);

    List<Map<String, Object>> saleSteelReportContinue(Map<String, Object> map);

    List<Map<String, Object>> yawnReport(Map<String, Object> map);

    BigDecimal getSpellNum(BigDecimal saleOrderMaterialId);

    List<Map<String, Object>> yawnReportMonth(Map<String, Object> map);

    List<Map<String, Object>> getAllSaleReportByLb(Map<String, Object> mapValue);

    Map<String, Object> getPreMap(Map<String, Object> mapValue);

    List<Map<String, Object>> getOyeSteelReport(Map<String, Object> map);


    Map<String, Object> getOyeSteelReportDetailsBySmId(BigDecimal saleOrderMaterialId);

    List<Map<String, Object>> getOyeSteelReportDetailsListBySmId(BigDecimal saleOrderMaterialId);


    String getRealSsoId(String carrierSsoId);
}