WarehouseManagement/ruoyi-system/src/main/java/com/ruoyi/system/mapper/OrderBillsPlansMapper.java

package com.ruoyi.system.mapper;

import com.ruoyi.system.domain.*;
import com.ruoyi.system.domain.vo.ItemsVo;
import com.ruoyi.system.domain.vo.OrderBillsPlansVo;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

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

@Mapper
public interface OrderBillsPlansMapper {
    /**
     * 获取业务表数据
     *
     * @param emplId
     * @param dataStart
     * @param dataEnd
     *
     *     and (p.ifStarted = 'F' or p.ifStarted = 'S' or p.ifStarted = 'A' or p.ifStarted = 'B')
     * @return
     */
    List<WfTaskList> getOrderBillsPlansLsit(Map map);

    /**
     * 根据orderNo查询
     *
     * @param orderNo 订单号
     * @return 详情
     */
    OrderBillsPlans getOrderBillsPlansByid(Long orderNo);

    /**
     *
     #             EMPTYADDR1    = #{emptyaddr1},
     #             ODOMETERSTART = #{odometerstart},
     #             EMPTYADDR2    = #{emptyaddr2},
     #             ODOMETEREND   = #{odometerend},
     #             LOADMILE      = #{loadmile},
     */
    /**
     * 保存保单信息
     *
     * @param orderBillsPlans
     * @return
     *
     *
     * <if test="loadDate = null">
     *             LoadDate = null,
     *         </if>
     *
     *         <if test="loadDate != null and loadDate != ''">
     *             LoadDate = #{loadDate},
     *         </if>
     *         UnLoadQty = #{unLoadQty},
     *         <if test="unLoadDate = null">
     *             UnLoadDate = null,
     *         </if>
     *
     *         <if test="unLoadDate != null and unLoadDate != ''">
     *             UnLoadDate = #{unLoadDate},
     *         </if>
     */
    Integer updateOrderBillsPlansByid(OrderBillsPlans orderBillsPlans);

    /**
     * 获取报销费用list
     *
     * @return
     */
    List<ItemsVo> getItemsList();

    Integer insertLoadFeeItems(@Param("o") OrderBillsPlansVo orderBillsPlansVo, @Param("i") ItemsVo itemsVo, @Param("e") Empls empls);

    @MapKey("itemId")
    Map<String, LoadFeeItems> getLoadFeeitemsMapByentityIdKeyItemId(Long entityId);

    /**
     * 更新金额
     *
     * @param loadFeeItems
     * @return
     */

    /**
     * 查询报销费用报销金额下拉选
     *
     * @return
     */
    List<GasStations> getGasStations();

    /**
     * 报销
     *
     * @param orderBillsPlansVo
     * @return
     */
    Integer updateOrderBillsPlansByOrderNo(OrderBillsPlansVo orderBillsPlansVo);

    /**
     * 删除
     *
     * @param loadBillsEntityId
     * @return
     */
    Integer deleteLoadFeeItemsByEntityId(Long loadBillsEntityId);

    /**
     * 查询报销信息
     *
     * @param
     * @return 数据
     */
    OrderBillsPlansVo getOrderBillsPlansByOrder(Long orderNo);

    /**
     * 查询其他费用list
     *
     * @param entityId
     * @return
     */
    List<LoadFeeItems> getLoadFeeItemsByEntityId(@Param("entityId") Long entityId);

    /**
     * 更新其他费用金额
     *
     * @param loadFeeItems
     */
    void updateOrderBillsPlansBySysidEntityidLineno(LoadFeeItems loadFeeItems);

    /**
     * 查询最大的lineNo进行+1赋值
     *
     * @param tmsAttachMngs
     * @return
     */
    Long getAttachMngsBySysIdEntityId(TmsAttachMngs tmsAttachMngs);

    /**
     * 插入照片表
     * @param tmsAttachMngs
     * @return
     */
    Integer insertAttachMngs(TmsAttachMngs tmsAttachMngs);

    /**
     * 查询AttachtypeId返回前端在照片库中插入
     * AttachtypeId
     * @param tmsAttachMngs
     * @return
     */
    Long getAttachMngsAttachtypeIdBySysIdAndEntityIdAndLineNo(TmsAttachMngs tmsAttachMngs);

    /**
     * 查找照片List
     * @param orderBillsPlans
     * @return
     */
    List<Long> getAttachMngsAttachIdBySysIdAndEntityIdAndActId(OrderBillsPlans orderBillsPlans);

    /**
     * 根据attachId在Tms库的AttachMngs表删除数据
     *
     * @param attachId
     * @return
     */
    Integer deleteTmsAttachMngsByAttachId(Long attachId);

    /**
     * 根据EntityId更新
     * @param srcEntityId
     * @return
     */
    Integer updateLoadBillsByEntityID(OrderBillsPlansVo srcEntityId);

    List<WfTaskList> getIsMileageOrderBillsPlansByOrder(Long orderNo);

    Integer submitAudit(String orderNo);

    /**
     * 审核通过 IfStard= A ，StartDate= NOW ，Status_375=2
     * @param orderNo 报单号
     * @return 成功修改条数
     */
    Integer approved(String orderNo);
    void approvedTaskList(@Param("actId") String actId, @Param("entityId") String entityId);

    void approvedTaskListV1(@Param("actId") String actId, @Param("entityId") String entityId,@Param("status") String status);

    /**
     * 审核不通过 IfStard=’B’，StartDate=’NOW’，Status_375=0
     * @param orderNo 报单号
     * @return 成功修改条数
     */
    Integer theAuditFailed(String orderNo);
    Integer theAuditFailedTaskList(@Param("actId") String actId, @Param("entityId") Long entityId);

    /**
     * 提交报账单
     * @param orderNo
     * @return
     */
    int upReceipts(Long orderNo);

    /**
     * 审核意见
     * @param entityId
     * @param audit2Desc
     */
    void addAReviewComment(@Param("entityId") Long entityId, @Param("audit2Desc") String audit2Desc, @Param("lineNo") Long lineNo);
}