PayOrderMapper.java 4.9 KB

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