| | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import com.yeshi.fanli.entity.SystemEnum; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.dao.BaseMapper; |
| | |
| | | |
| | | public interface CommonOrderMapper extends BaseMapper<CommonOrder> { |
| | | |
| | | |
| | | /** |
| | | * 查询用户订单 并订单号分组 |
| | | * |
| | |
| | | @Param("type") Integer type, @Param("orderState") Integer orderState, @Param("startTime") String startTime, |
| | | @Param("endTime") String endTime, @Param("source") Integer source, |
| | | @Param("listShopId")List<Long> listShopId, @Param("listGoodsId")List<Long> listGoodsId, |
| | | @Param("minTime")Date minTime, @Param("money")BigDecimal money, @Param("payment") BigDecimal payment); |
| | | @Param("minTime")Date minTime, @Param("money")BigDecimal money, @Param("payment") BigDecimal payment, @Param("system") SystemEnum system); |
| | | |
| | | /** |
| | | * 订单列表查询(不包含子订单) |
| | |
| | | List<CommonOrderVO> listQueryWithNoChild(@Param("start") long start, @Param("count") int count, |
| | | @Param("keyType") Integer keyType, @Param("key") String key, @Param("state") Integer state, |
| | | @Param("type") Integer type, @Param("orderState") Integer orderState, @Param("startTime") String startTime, |
| | | @Param("endTime") String endTime, @Param("source") Integer source, @Param("payment") BigDecimal payment); |
| | | @Param("endTime") String endTime, @Param("source") Integer source, @Param("payment") BigDecimal payment, @Param("system") SystemEnum system); |
| | | |
| | | /** |
| | | * 统计 |
| | | */ |
| | | long countQuery(@Param("keyType") Integer keyType, @Param("key") String key, @Param("state") Integer state, |
| | | @Param("type") Integer type, @Param("orderState") Integer orderState, @Param("startTime") String startTime, |
| | | @Param("endTime") String endTime, @Param("source") Integer source, |
| | | @Param("listShopId")List<Long> listShopId, @Param("listGoodsId")List<Long> listGoodsId, |
| | | @Param("minTime")Date minTime, @Param("money")BigDecimal money,@Param("payment") BigDecimal payment); |
| | | @Param("type") Integer type, @Param("orderState") Integer orderState, @Param("startTime") String startTime, |
| | | @Param("endTime") String endTime, @Param("source") Integer source, |
| | | @Param("listShopId")List<Long> listShopId, @Param("listGoodsId")List<Long> listGoodsId, |
| | | @Param("minTime")Date minTime, @Param("money")BigDecimal money, @Param("payment") BigDecimal payment, @Param("system") SystemEnum system); |
| | | |
| | | long countQueryWithNoChild(@Param("keyType") Integer keyType, @Param("key") String key, |
| | | @Param("state") Integer state, @Param("type") Integer type, @Param("orderState") Integer orderState, |
| | | @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("source") Integer source, @Param("payment") BigDecimal payment); |
| | | @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("source") Integer source, @Param("payment") BigDecimal payment, @Param("system") SystemEnum system); |
| | | |
| | | /** |
| | | * 根据来源类型与订单号查询列表 |
| | |
| | | * @return |
| | | */ |
| | | List<CommonOrder> getByOrderNo(@Param("uid") Long uid, @Param("orderNo") String orderNo); |
| | | |
| | | /** |
| | | * 根据订单号查询 |
| | | * |
| | | * @param orderNO |
| | | * @return |
| | | */ |
| | | List<CommonOrder> getByOrderNoAndSourceType(@Param("uid") Long uid, @Param("orderNo") String orderNo, |
| | | @Param("sourceType") int sourceType); |
| | | |
| | | |
| | | /** |
| | |
| | | List<CommonOrderVO> getOrderList(@Param("start") long start, @Param("count") int count, @Param("uid") Long uid, |
| | | @Param("state") Integer state, @Param("type") Integer type, @Param("orderState") Integer orderState, |
| | | @Param("orderNo") String orderNo, @Param("startTime") String startTime, @Param("endTime") String endTime, |
| | | @Param("day") Integer day, @Param("listSource") List<Integer> listSource, @Param("notBackSuVip") boolean notBackSuVip); |
| | | @Param("day") Integer day, @Param("listSource") List<Integer> listSource); |
| | | |
| | | /** |
| | | * 统计用户订单 并订单号分组 |
| | |
| | | long countOrderList(@Param("uid") Long uid, @Param("state") Integer state, @Param("type") Integer type, |
| | | @Param("orderState") Integer orderState, @Param("orderNo") String orderNo, |
| | | @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("day") Integer day, |
| | | @Param("listSource") List<Integer> listSource, @Param("notBackSuVip") boolean notBackSuVip); |
| | | @Param("listSource") List<Integer> listSource); |
| | | |
| | | |
| | | /** |
| | |
| | | * @return |
| | | */ |
| | | List<CommonOrder> listByOrderNo(@Param("orderNo") String orderNo); |
| | | |
| | | |
| | | /** |
| | | * 获取首个订单 |
| | | * @param orderNo |
| | | * @return |
| | | */ |
| | | CommonOrder getFirstOrder(@Param("uid") Long uid); |
| | | |
| | | } |