anpinjingyuan/ruoyi-warehouse/src/main/java/com/ruoyi/warehouseBusiness/mapper/TWarehouseBillsMapper.java

package com.ruoyi.warehouseBusiness.mapper;


import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.ruoyi.anpin.MarketOut;
import com.ruoyi.anpin.WarehouseIn;
import com.ruoyi.anpin.WarhousrExcel;
import com.ruoyi.common.core.domain.entity.TWarehouse;
import com.ruoyi.reportManagement.domain.SingleAnalysisExcel;
import com.ruoyi.reportManagement.domain.SingleAnalysisFeesExcel;
import com.ruoyi.reportManagement.domain.TWareHouseItemsExcel;
import com.ruoyi.reportManagement.dto.TWarehousebill;
import com.ruoyi.warehouseBusiness.domain.TWareHouseExcelItems;
import com.ruoyi.warehouseBusiness.domain.TWarehouseBills;
import org.apache.ibatis.annotations.Param;


import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * 详情主表Mapper接口
 *
 * @author ruoyi
 * @date 2020-12-11
 */
public interface TWarehouseBillsMapper extends BaseMapper<TWarehouseBills> {
    /**
     * 查询详情主表
     *
     * @param fId 详情主表ID
     * @return 详情主表
     */
    public TWarehouseBills selectTWarehousebillsById(Long fId);

    /**
     * 查询对仓库物详情的列表
     *
     * @param tWarehousebills 详情主表
     * @return 结果
     */
    public List<Map<String, Object>> selectWarehouseBusinessList(TWarehouseBills tWarehousebills);

    public List<Map<String, Object>> selectWarehouseBusinessList1(TWarehouseBills tWarehousebills);

    /**
     * 查询详情主表列表
     *
     * @param tWarehousebills 详情主表
     * @return 详情主表集合
     */
    public List<TWarehouseBills> selectTWarehousebillsList(TWarehouseBills tWarehousebills);

    /**
     * 新增详情主表
     *
     * @param tWarehousebills 详情主表
     * @return 结果
     */
    public int insertTWarehousebills(TWarehouseBills tWarehousebills);

    /**
     * 修改详情主表
     *
     * @param tWarehousebills 详情主表
     * @return 结果
     */
    public int updateTWarehousebills(TWarehouseBills tWarehousebills);
    /**
     * 修改详情主表
     *
     * @param tWarehousebills 详情主表
     * @return 结果
     */
    public int updateKaHeOrder(TWarehouseBills tWarehousebills);

    /**
     * 删除详情主表
     *
     * @param fId 详情主表ID
     * @return 结果
     */
    public int deleteTWarehousebillsById(Long fId);

    /**
     * 批量删除详情主表
     *
     * @param fIds 需要删除的数据ID
     * @return 结果
     */
    public int deleteTWarehousebillsByIds(Long[] fIds);
    /**
     * 批量删除详情主表
     *
     * @param fIds 需要删除的数据ID
     * @return 结果
     */
    public int deleteKHTWarehousebillsByIds(Long[] fIds);

    /**
     *  根据主表id 更新库存主表对应状态
     *
     * @param fettle 对应状态
     * @param fPid 主表id
     * @return  结果
     */
    int warehouseFollowUpdate(@Param("fPid") Long fPid, @Param("fettle") Long fettle, @Param("auditItem") Date auditItem);

    /**
     * 查询详情主表列表
     * @param fid
     * @return 详情主表集合
     */
    public List<TWareHouseExcelItems> selectTWarehousebillsItemsList(@Param("fId") Long fid);

    List<Map<String, Object>> selectInventorySJRKList(TWarehouseBills tWarehousebills);
    List<Map<String, Object>> selectInventorySJCKList(TWarehouseBills tWarehousebills);

    public List<TWareHouseItemsExcel> selectTWarehousebillsItemList(TWarehouseBills tWarehouseBills);

    public List<Map<String, Object>> selectDetailedList(TWarehousebill tWarehousebill);

    /**
     *  根据提单号在当天时出现多少次
     * @param warehouseBills     提单号
     * @return  结果
     */
    public int selectContainMblno(TWarehouseBills warehouseBills);

    /**
     * 凯和订单查询
     * @param tWarehouseBills
     * @return
     */
    public List<TWarehouseBills> webVersionOrderList(TWarehouseBills tWarehouseBills);

    /**
     * 后台管理系统查询订单
     * @return
     */
    public List<Map<String,Object>> ruoYiVersionOrderList(TWarehouseBills tWarehouseBills);

    /**
     * 根据id获取订单信息
     * @param tWarehouseBills
     * @return
     */
    public List<TWarehouseBills> webVersionOrderById(TWarehouseBills tWarehouseBills);

    /**
     * 查询提单号的唯一性
     * @param tWarehouseBills
     * @return
     */
    public TWarehouseBills selectTWarehousebillsfMblno(TWarehouseBills tWarehouseBills);

    /**
     *  app 查询业务主表信息
     * @param warehousebills
     * @return
     */
    public List<Map<String, Object>> selectAppStockList(TWarehouseBills warehousebills);

    /**
     *  app 根据主表id查询主表对应明细列表数据
     * @param warehouseBills
     * @return
     */
    public List<Map<String, Object>> selectWarehouseItemListById(TWarehouseBills warehouseBills);

    /**
     *  查询单票分析信息
     * @param singleAnalysisExcel 查询条件
     * @return  结果
     */
    public List<SingleAnalysisExcel> selectSingleAnalysis(SingleAnalysisExcel singleAnalysisExcel);

    /**
     *  查询单票分析费用信息
     * @param singleAnalysisExcel
     * @return
     */
    public List<SingleAnalysisFeesExcel> selectSingleAnalysisFees(SingleAnalysisExcel singleAnalysisExcel);
    /**
     * 查询详情主表列表
     *
     * @param tWarehousebills 详情主表
     * @return 详情主表集合
     */
    public List<TWarehouseBills> selectAnPinList(TWarehouseBills tWarehousebills);
    /**
     *  根据主表id 更新库存主表对应状态
     *
     * @param delFlag 对应状态
     * @param fIds 主表id
     * @param updateBy 更新人
     * @param updateTime 更新时间
     * @return  结果
     */
    int anPinDeleteUpdate(@Param("fIds") Long[] fIds, @Param("delFlag") String delFlag, @Param("updateBy") String updateBy, @Param("updateTime") Date updateTime);
    /**
     * 更新项目审核信息
     * @param fId
     * @param fBillstatus
     * @param fAuditTime
     * @return
     */
    public int updateTProjectAudit(@Param("fId")Long fId,
                                   @Param("fBillstatus")Long fBillstatus,
                                   @Param("fAuditTime") Date fAuditTime);
    /**
     * 更新项目审核信息
     * @param fPid
     * @param fBillstatus
     * @param fAuditTime
     * @return
     */
    public int updateTProjectItemsAudit(@Param("fPid")Long fPid,
                                        @Param("fBillstatus")Long fBillstatus,
                                        @Param("fAuditTime") Date fAuditTime);
    /**
     * 安品查询详情主表
     *
     * @param fId 详情主表ID
     * @return 详情主表
     */
    public TWarehouseBills selectAnPinById(Long fId);
    /**
     * 查询调拨主表列表
     *
     * @param tWarehousebills 详情主表
     * @return 详情主表集合
     */
    public List<TWarehouseBills> cannibalizeList(TWarehouseBills tWarehousebills);

    /**
     * 安品导出仓库入库
     * @return
     */
    List<WarehouseIn> warehouseIn(TWarehouseBills tWarehousebills);
    /**
     * 安品导出销售出库
     * @return
     */
    List<MarketOut> marketOut(TWarehouseBills tWarehousebills);

    /**
     * 首页统计 采购 出库 入库 销售
     * @param tWarehousebills
     * @return
     */
    List<Map<String,Object>> statistics (TWarehouseBills tWarehousebills);
    /**
     * 首页统计 采购 出库 入库 销售
     * @param tWarehousebills
     * @return
     */
    List<Map<String,Object>> statisticsNew (TWarehouseBills tWarehousebills);
}