OrderBillsPlansMapper.java 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143
  1. package com.ruoyi.system.mapper;
  2. import com.ruoyi.system.domain.*;
  3. import com.ruoyi.system.domain.vo.ItemsVo;
  4. import com.ruoyi.system.domain.vo.OrderBillsPlansVo;
  5. import org.apache.ibatis.annotations.MapKey;
  6. import org.apache.ibatis.annotations.Mapper;
  7. import org.apache.ibatis.annotations.Param;
  8. import java.util.List;
  9. import java.util.Map;
  10. @Mapper
  11. public interface OrderBillsPlansMapper {
  12. /**
  13. * 获取业务表数据
  14. *
  15. * @param emplId
  16. * @param dataStart
  17. * @param dataEnd
  18. * @return
  19. */
  20. List<WfTaskList> getOrderBillsPlansLsit(Map map);
  21. /**
  22. * 根据orderNo查询
  23. *
  24. * @param orderNo 订单号
  25. * @return 详情
  26. */
  27. OrderBillsPlans getOrderBillsPlansByid(Long orderNo);
  28. /**
  29. * 保存保单信息
  30. *
  31. * @param orderBillsPlans
  32. * @return
  33. */
  34. Integer updateOrderBillsPlansByid(OrderBillsPlans orderBillsPlans);
  35. /**
  36. * 获取报销费用list
  37. *
  38. * @return
  39. */
  40. List<ItemsVo> getItemsList();
  41. Integer insertLoadFeeItems(@Param("o") OrderBillsPlansVo orderBillsPlansVo, @Param("i") ItemsVo itemsVo, @Param("e") Empls empls);
  42. @MapKey("itemId")
  43. Map<String, LoadFeeItems> getLoadFeeitemsMapByentityIdKeyItemId(Long entityId);
  44. /**
  45. * 更新金额
  46. *
  47. * @param loadFeeItems
  48. * @return
  49. */
  50. /**
  51. * 查询报销费用报销金额下拉选
  52. *
  53. * @return
  54. */
  55. List<GasStations> getGasStations();
  56. /**
  57. * 报销
  58. *
  59. * @param orderBillsPlansVo
  60. * @return
  61. */
  62. Integer updateOrderBillsPlansByOrderNo(OrderBillsPlansVo orderBillsPlansVo);
  63. /**
  64. * 删除
  65. *
  66. * @param loadBillsEntityId
  67. * @return
  68. */
  69. Integer deleteLoadFeeItemsByEntityId(Long loadBillsEntityId);
  70. /**
  71. * 查询报销信息
  72. *
  73. * @param
  74. * @return 数据
  75. */
  76. OrderBillsPlansVo getOrderBillsPlansByOrder(Long orderNo);
  77. /**
  78. * 查询其他费用list
  79. *
  80. * @param entityId
  81. * @return
  82. */
  83. List<LoadFeeItems> getLoadFeeItemsByEntityId(@Param("entityId") Long entityId);
  84. /**
  85. * 更新其他费用金额
  86. *
  87. * @param loadFeeItems
  88. */
  89. void updateOrderBillsPlansBySysidEntityidLineno(LoadFeeItems loadFeeItems);
  90. /**
  91. * 查询最大的lineNo进行+1赋值
  92. *
  93. * @param tmsAttachMngs
  94. * @return
  95. */
  96. Long getAttachMngsBySysIdEntityId(TmsAttachMngs tmsAttachMngs);
  97. /**
  98. * 插入照片表
  99. * @param tmsAttachMngs
  100. * @return
  101. */
  102. Integer insertAttachMngs(TmsAttachMngs tmsAttachMngs);
  103. /**
  104. * 查询AttachtypeId返回前端在照片库中插入
  105. * AttachtypeId
  106. * @param tmsAttachMngs
  107. * @return
  108. */
  109. Long getAttachMngsAttachtypeIdBySysIdAndEntityIdAndLineNo(TmsAttachMngs tmsAttachMngs);
  110. /**
  111. * 查找照片List
  112. * @param orderBillsPlans
  113. * @return
  114. */
  115. List<Long> getAttachMngsAttachIdBySysIdAndEntityIdAndActId(OrderBillsPlans orderBillsPlans);
  116. /**
  117. * 根据attachId在Tms库的AttachMngs表删除数据
  118. *
  119. * @param attachId
  120. * @return
  121. */
  122. Integer deleteTmsAttachMngsByAttachId(Long attachId);
  123. }