TOrderNewMapper.java 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182
  1. package com.goafanti.common.dao;
  2. import com.goafanti.common.model.Department;
  3. import com.goafanti.common.model.FinanceCount;
  4. import com.goafanti.common.model.TOrderBillNew;
  5. import com.goafanti.common.model.TOrderNew;
  6. import com.goafanti.expenseAccount.bo.ExpenseCountsBo;
  7. import com.goafanti.expenseAccount.bo.ExpenseCountsInput;
  8. import com.goafanti.order.bo.*;
  9. import com.goafanti.order.bo.outStatistics.OutOrderSalesSourceAmount;
  10. import com.goafanti.organization.bo.OrganizationListOut;
  11. import org.apache.ibatis.annotations.Param;
  12. import org.springframework.data.domain.Pageable;
  13. import java.math.BigDecimal;
  14. import java.util.Date;
  15. import java.util.List;
  16. import java.util.Map;
  17. /**
  18. * 订单表(TOrderNew)表数据库访问层
  19. *
  20. * @author makejava
  21. * @since 2024-09-27 16:04:11
  22. */
  23. public interface TOrderNewMapper {
  24. /**
  25. * 通过ID查询单条数据
  26. *
  27. * @param orderNo 主键
  28. * @return 实例对象
  29. */
  30. TOrderNew queryById(String orderNo);
  31. /**
  32. * 查询指定行数据
  33. *
  34. * @param tOrderNew 查询条件
  35. * @param pageable 分页对象
  36. * @return 对象列表
  37. */
  38. List<TOrderNew> findTOrderNewList(TOrderNew tOrderNew, @Param("pageable") Pageable pageable);
  39. /**
  40. * 统计总行数
  41. *
  42. * @param tOrderNew 查询条件
  43. * @return 总行数
  44. */
  45. int findTOrderNewCount(TOrderNew tOrderNew);
  46. /**
  47. * 新增数据
  48. *
  49. * @param tOrderNew 实例对象
  50. * @return 影响行数
  51. */
  52. int insert(TOrderNew tOrderNew);
  53. /**
  54. * 批量新增数据(MyBatis原生foreach方法)
  55. *
  56. * @param entities List<TOrderNew> 实例对象列表
  57. * @return 影响行数
  58. */
  59. int insertBatch(@Param("entities") List<TOrderNew> entities);
  60. /**
  61. * 批量新增或按主键更新数据(MyBatis原生foreach方法)
  62. *
  63. * @param entities List<TOrderNew> 实例对象列表
  64. * @return 影响行数
  65. * @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常,请自行校验入参
  66. */
  67. int insertOrUpdateBatch(@Param("entities") List<TOrderNew> entities);
  68. /**
  69. * 修改数据
  70. *
  71. * @param tOrderNew 实例对象
  72. * @return 影响行数
  73. */
  74. int update(TOrderNew tOrderNew);
  75. /**
  76. * 通过主键删除数据
  77. *
  78. * @param orderNo 主键
  79. * @return 影响行数
  80. */
  81. int deleteById(String orderNo);
  82. int insertSelective(TOrderNew record);
  83. TOrderNewBo getOrderNewDetail(String orderNo);
  84. int getCountByIdAndStatus(TOrderNew orderNew);
  85. /**
  86. * 获取订单信息
  87. * @param ono
  88. * @return orderNo , salesmanId,salesmanName, contractNo,email , userName, orderDep,
  89. * departmentName financeId(此财务编号为订单部门财务负责人)
  90. */
  91. TOrderNewBo getSaleIdByOno(String ono);
  92. TOrderNewBo agreeEmailData(Integer fid);
  93. OrderRefundDetailBo orderRefundDetail(String id);
  94. int updateFinance(@Param("aid")String aid, @Param("orderNos") List<String> orderNos, @Param("newFinance")String newFinance);
  95. int checkContractNo(String sno);
  96. Map<String, Object> countTotalAndActually(@Param("o") OrderListBo o, @Param("fids") List<String> fids, @Param("deps")List<String> listDep, @Param("types")List<String> types);
  97. TOrderBillNew getLastPayment(String orderNo);
  98. int updateSalesmanId(@Param("aid")String aid, @Param("transferId")String transferId);
  99. List<TOrderNewBo> selectUsedOrderByOrder(String orderNo);
  100. void updaterefund(TOrderNew o);
  101. List<BigDecimal> selectByUidAndNewUser(@Param("uid")String uid, @Param("aid")String aid, @Param("newUser")Integer newUser, @Param("date") Date date, @Param("now")Date now);
  102. List<OutStatisticsList> statisticsList(InputStatistics in);
  103. List<OutProvinceStatisticsList> provinceStatisticsList(InputStatistics in);
  104. List<Map<String, Object>> selectOrderByuid(String uid);
  105. List<OutOrderSalesSource> orderSalesSource(InputOrderSalesSource in);
  106. List<OutOrderSalesSourceAmount> orderSalesSourceAmount(InputOrderSalesSource in);
  107. TOrderNew checkOrderProcessStatus(Integer tid);
  108. List<TOrderNew> selectgetAll();
  109. /**
  110. * 获取订单审核人列表
  111. * @param orderNo
  112. * @return
  113. */
  114. OrderProcessName getProcessName(String orderNo);
  115. void updateExamineById(@Param("id") String id,@Param("type")Integer type);
  116. List<TOrderNewBo> selectByuidandAid(@Param("uid")String uid,@Param("aid") String aid);
  117. List<StatisOrderList> statisticsOrderList(InputStatistics in);
  118. List<UserOrder> matchingOrderNoOrUserName(@Param("orderNo") String orderNo, @Param("userName")String userName);
  119. void updateTagByListOrderNo(List<String> orderNos, Integer tag);
  120. int selectAidAndDate(@Param("aid") String aid, @Param("startTime") String startTime,
  121. @Param("endTime")String endTime);
  122. List<FinanceCount> selectCountByFinance(String id);
  123. OrganizationListOut selectOrderFinance(String orderNo);
  124. Department selectDepByOrderNo(String orderNo);
  125. List<String> selectByFinanceNotExamine(@Param("financeId") String financeId, @Param("depId") String depId);
  126. void updateOrderDepFinanceExamineName(@Param("list") List<String> list, @Param("processStatus") Integer processStatus);
  127. List<ExpenseCountsBo> selectExpenseCount(ExpenseCountsInput in);
  128. List<ExpenseCountsBo> selectExpenseDepCount(ExpenseCountsInput in);
  129. List<String> selectByDepAndProcess(@Param("depId") String depId, @Param("processStatus") Integer processStatus);
  130. TOrderNew selectByTid(Integer tid);
  131. }