PayOrderMapper.java 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196
  1. package com.platform.yijia.dao;
  2. import com.platform.yijia.pojo.*;
  3. import java.util.List;
  4. import java.util.Map;
  5. import org.apache.ibatis.annotations.Param;
  6. public interface PayOrderMapper {
  7. //LNG 平台第三方订单消费余额记录
  8. void insertStationBalanceExchange(StationBalanceChange stationBalanceChange);
  9. //根据订单号查询订单
  10. PayOrder selectOrderInfoByOrdNo(String orderNo);
  11. //获取系统支付类型
  12. List<PayType> selectPayTypeList();
  13. //获取订单列表已转化汉字支付方式的
  14. List<PayOrder> selectPayOrderListFormater(PayOrder payOrder);
  15. //查询POS机近七天数据
  16. List<Map<String, Object>> selectPosRecentlySevenData(PayOrder payOrder);
  17. //获取POS机昨天数据
  18. Map<String, Object> selectPosYesterDayData(PayOrder payOrder);
  19. //查询汇总数据
  20. List<Map> selectSum(PayOrder payOrder);
  21. /*
  22. * 根据用户openId和用户类型userType查询用户订单
  23. * @param payOrder
  24. * @return
  25. */
  26. List<PayOrder> getOrderListByOpenIdAndUserType(AppUserInfo appUserInfo);
  27. /*
  28. *修改订单状态
  29. */
  30. int updateOrderStatus(PayOrder payOrder);
  31. /*
  32. * 查询客户是否已存在
  33. * @param customerManage
  34. * @return
  35. */
  36. CustomerManage isExistCustomer(CustomerManage customerManage);
  37. /*
  38. * 根据用户登录openId 获取用户信息用于插入客户表
  39. * @param appUserInfo
  40. * @return
  41. */
  42. List<AppUserInfo> getUserInfoByOpenId(AppUserInfo appUserInfo);
  43. /*
  44. * 插入客户
  45. * @param customerManage
  46. * @return
  47. */
  48. void insertCustomer(CustomerManage customerManage);
  49. /*
  50. * 根据手机号更新客户表
  51. * @param customerManage
  52. */
  53. void updateCustomerByPhoneNumber(CustomerManage customerManage);
  54. /*
  55. * 生成订单时更新客户表
  56. * @param customerManage
  57. * @return
  58. */
  59. void updateCustomer(CustomerManage customerManage);
  60. /*
  61. * 根据订单号查询订单信息和用户信息 注:此方法在随行付回调校验之后修改状态完成后
  62. * @param payOrder
  63. * @return
  64. */
  65. Map<String, Object> getOrderInfoAndUserInfoByOrderNo(PayOrder payOrder);
  66. /***
  67. * 根据油品名称和油站查询油品调价信息
  68. * @param map
  69. * @return
  70. */
  71. List<Map> selectOilPriceAdjust(Map<String, Object> map);
  72. /***
  73. * 根据油品名称和油站查询油枪编号,油站名称,价格,加油员
  74. * @param map
  75. * @return
  76. */
  77. List<Map> selectOilGunNoAndOilPrice(Map<String, Object> map);
  78. //查询加油员
  79. List<Map> selectPersonelName(Map<String, Object> map);
  80. //查询班结订单
  81. List<PayOrder> selectPayOrderList(PayOrder payOrder);
  82. PayOrder getPayOrderInfoMin(PayOrder payOrder);
  83. /**
  84. * This method was generated by MyBatis Generator.
  85. * This method corresponds to the database table pay_order
  86. *
  87. * @mbg.generated
  88. */
  89. long countByExample(PayOrderExample example);
  90. /**
  91. * This method was generated by MyBatis Generator.
  92. * This method corresponds to the database table pay_order
  93. *
  94. * @mbg.generated
  95. */
  96. int deleteByExample(PayOrderExample example);
  97. /**
  98. * This method was generated by MyBatis Generator.
  99. * This method corresponds to the database table pay_order
  100. *
  101. * @mbg.generated
  102. */
  103. int deleteByPrimaryKey(Integer orderId);
  104. /**
  105. * This method was generated by MyBatis Generator.
  106. * This method corresponds to the database table pay_order
  107. *
  108. * @mbg.generated
  109. */
  110. int insert(PayOrder record);
  111. /**
  112. * This method was generated by MyBatis Generator.
  113. * This method corresponds to the database table pay_order
  114. *
  115. * @mbg.generated
  116. */
  117. int insertSelective(PayOrder record);
  118. /**
  119. * This method was generated by MyBatis Generator.
  120. * This method corresponds to the database table pay_order
  121. *
  122. * @mbg.generated
  123. */
  124. List<PayOrder> selectByExample(PayOrderExample example);
  125. /**
  126. * This method was generated by MyBatis Generator.
  127. * This method corresponds to the database table pay_order
  128. *
  129. * @mbg.generated
  130. */
  131. PayOrder selectByPrimaryKey(Integer orderId);
  132. /**
  133. * This method was generated by MyBatis Generator.
  134. * This method corresponds to the database table pay_order
  135. *
  136. * @mbg.generated
  137. */
  138. int updateByExampleSelective(@Param("record") PayOrder record, @Param("example") PayOrderExample example);
  139. /**
  140. * This method was generated by MyBatis Generator.
  141. * This method corresponds to the database table pay_order
  142. *
  143. * @mbg.generated
  144. */
  145. int updateByExample(@Param("record") PayOrder record, @Param("example") PayOrderExample example);
  146. /**
  147. * This method was generated by MyBatis Generator.
  148. * This method corresponds to the database table pay_order
  149. *
  150. * @mbg.generated
  151. */
  152. int updateByPrimaryKeySelective(PayOrder record);
  153. /**
  154. * This method was generated by MyBatis Generator.
  155. * This method corresponds to the database table pay_order
  156. *
  157. * @mbg.generated
  158. */
  159. int updateByPrimaryKey(PayOrder record);
  160. }