work

Appearance

刘一山 -> 陈建 ​

消息列表 -> 消息通知 ​

http://192.168.2.108:8085/monitor/doc.html#/default/消息通知/listUsingGET_5

我的-会员卡 ​

注意，有两个会员卡 一个是 我的会员卡，怀似 上一个项目的 一个是 我的-会员卡，这个为 刘一山 编写

http://192.168.2.108:8085/monitor/doc.html#/default/我的-会员卡/generateQrVipCardUsingGET

会员卡 明细 TypeScript
ts
export interface IResVipCardRecord {
  orderId: number;
  orderName: string;
  orderNo: string;
  /**
   * 订单状态 1待支付 2已完成 3已取消 4支付失败 5已付款
   */
  orderStatus: 1 | 2 | 3 | 4 | 5;
  /**
   * 订单状态
   */
  orderStatusDesc: string;
  /**
   * 订单类型
   *
   * 卡通: 1充值，2消费
   * 足球：1售票，2办卡，3充值
   * 游泳：1售票，2办卡，3续卡，4退卡，5转卡，6冻卡，7解冻，8延期
   * 羽毛球：1=线下订场，2=办卡，3=充值，4=延期，5=锁场，6=微信订场
   */
  orderType: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8;
  payAmount: number;
  /**
   * 支付方式
   */
  payMode: string;
  /**
   * 锁场信息
   */
  reservationLockList: null | string[];
  /**
   * 交易类型 1体测机 2要事活动 3一卡通 4羽毛球 5足球馆 6游泳馆
   */
  tradeType: 1 | 2 | 3 | 4 | 5 | 6;
  /**
   * venue
   */
  venue: string;
  /**
   * 微信支付结果
   */
  wxPayOrderResult: null | string;
}
Response Type Java VO

会员卡信息

会员卡消费记录/CardOrderDetailVo

订单 ​

http://192.168.2.108:8085/monitor/doc.html#/default/订单/orderTotalPageUsingGET

刘一山 的 取消订单相关的 API 有三个

  • 已经下单、未付款 /monitor/device/osDeviceBodyOrderController/orderCancelNotPay
  • 已经下单、已付款 /monitor/device/osDeviceBodyOrderController/orderCancelRefund
  • 已经下单、已付款，查询可以退多少钱 /monitor/device/osDeviceBodyOrderController/orderCancelQueryMoney

体测机使用记录 ​

http://192.168.2.108:8085/monitor/doc.html#/default/体测机设备/queryPageListUsingGET_1

停车券 ​

/monitor/osCarParkLogController/carCouponBuy

停车缴费记录 > 停车券购买

后台-报表中心 ​

部分统计表报

其他 ​

sql
create or replace algorithm = UNDEFINED view
  `oss_upgrade`.`view_order_total` as select `o`.`id` as `order_id`,
  `o`.`trade_type` as `trade_type`,
  `o`.`order_no` as `order_no`,
  `o`.`user_id` as `user_id`,
  `o`.`order_name` as `order_name`,
  '' as `venue`,
  `o`.`order_type` as `order_type`,
  `o`.`create_time` as `create_time`,
  `o`.`pay_amount` as `pay_amount`,
  (case `o`.`pay_way`
    when 0 then '微信支付'
    when 1 then '会员卡支付'
    else `o`.`pay_way` end) as `pay_methode`,
  `o`.`order_status` as `order_status`,
  `o`.`wx_pay_order_result` as `wx_pay_order_result`
from `oss_upgrade`.`os_order` `o`
  where(`o`.`is_del` = 0)
union all
  select `oss_upgrade`.`view_order_feather`.`order_id` as `order_id`,
  `oss_upgrade`.`view_order_feather`.`trade_type` as `trade_type`,
  `oss_upgrade`.`view_order_feather`.`order_no` as `order_no`,
  `oss_upgrade`.`view_order_feather`.`user_id` as `user_id`,
  `oss_upgrade`.`view_order_feather`.`order_name` as `order_name`,
  `oss_upgrade`.`view_order_feather`.`venue` as `venue`,
  `oss_upgrade`.`view_order_feather`.`order_type` as `order_type`,
  `oss_upgrade`.`view_order_feather`.`create_time` as `create_time`,
  `oss_upgrade`.`view_order_feather`.`pay_amount` as `pay_amount`,
  `oss_upgrade`.`view_order_feather`.`pay_methode` as `pay_methode`,
  `oss_upgrade`.`view_order_feather`.`order_status` as `order_status`,
  `oss_upgrade`.`view_order_feather`.`wx_pay_order_result` as `wx_pay_order_result`
from `oss_upgrade`.`view_order_feather`
union all select
  `oss_upgrade`.`view_order_football`.`order_id` as `order_id`,
  `oss_upgrade`.`view_order_football`.`trade_type` as `trade_type`,
  `oss_upgrade`.`view_order_football`.`order_no` as `order_no`,
  `oss_upgrade`.`view_order_football`.`user_id` as `user_id`,
  `oss_upgrade`.`view_order_football`.`order_name` as `order_name`,
  `oss_upgrade`.`view_order_football`.`venue` as `venue`,
  `oss_upgrade`.`view_order_football`.`order_type` as `order_type`,
  `oss_upgrade`.`view_order_football`.`create_time` as `create_time`,
  `oss_upgrade`.`view_order_football