Skip to content

查看汇付余额及提现

数据库

新增汇付提现流水表

CREATE TABLE `tbl_huifu_withdraw_flow` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `hf_order_id` varchar(20) NOT NULL COMMENT '汇付提现订单ID',
      `orde_date` varchar(20) NOT NULL COMMENT '汇付提现订单日期',
      `withdraw_amount` int(11) NOT NULL COMMENT '提现金额',
      `user_cust_id` varchar(20) NOT NULL COMMENT '汇付个人账户',
      `card_no` varchar(20) NOT NULL COMMENT '汇付提现卡no',
      `cash_bind_card_id` varchar(20) NOT NULL COMMENT '汇付提现卡id',
      `status` tinyint(4) NOT NULL COMMENT '提现状态1失败2成功',
      `msg` varchar(20) NOT NULL COMMENT '汇付返回信息',
      `group_id` int(11) NOT NULL COMMENT '组ID',

      `create_time` datetime NOT NULL COMMENT '创建时间',
      `modify_time` datetime NOT NULL COMMENT '修改时间',
      `delete_time` datetime NOT NULL DEFAULT '1-1-1 00:00:00' COMMENT '删除时间',
      `pstatus` int NOT NULL DEFAULT '0' COMMENT '逻辑删除',
      `extra1` int NOT NULL DEFAULT '0',
      `extra2` int NOT NULL DEFAULT '0',
      `extra3` int NOT NULL DEFAULT '0',
      `extra4` varchar(128) NOT NULL DEFAULT '',
      `extra5` varchar(128) NOT NULL DEFAULT '',
      `extra6` varchar(128) NOT NULL DEFAULT '',
      `extra7` datetime NOT NULL DEFAULT '1-1-1 00:00:00',
      `extra8` datetime NOT NULL DEFAULT '1-1-1 00:00:00',
      `extra9` datetime NOT NULL DEFAULT '1-1-1 00:00:00',
      `extra10` decimal(15,4) NOT NULL DEFAULT '0.0000',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Ma

新接口:finance/huifu/balance/get

请求方式:GET

请求参数:无

返回参数:

{
    code: 0,
    msg: "ok",
    data: {
        "balance":"6.66",
        "card_no":"52234****1231"
    }
}

新接口:finance/huifu/withdraw_money

请求方式:POST

请求参数:

withdraw_amount       M        float            提现金额(精确到分)

返回参数:

提现成功:
{
    code: 0,
    msg: "提现申请已受理",
    data: None
}
失败:
{
    code: 4,
    msg: "提现失败",
    data: None
}

新增权限:

查看第三方余额 codename: view_huifu_balance

第三方余额提现 codename: export_huifu_balance