Cashflow

高级搜索

POST

/api/cashflow/where

Cashflow

请求参数

Authorization

在 Header 添加参数

Authorization

，其值为在 Bearer 之后拼接 Token

示例：

Authorization: Bearer ********************

Body 参数application/json

fields

array[object (DataFieldDto) {3}]

查询显示字段

必需

field

string

字段

必需

label

string

字段名

必需

fun

object (SQLFn)

函数

可选

字段函数

where

object (SQLWhereDto)

必需

查询 SQL Where 条件

relational

enum<string>

关系

必需

枚举值:

andor

items

array [anyOf]

条件

必需

order

array[object (DataOrderDto) {3}]

查询排序字段

必需

field

string

字段

必需

fun

object (SQLFn)

函数

可选

字段函数

order

enum<string>

排序

必需

排序方式

枚举值:

ASCDESC

group

array[string]

查询分组字段

必需

index

number

起始 index

必需

count

number

查询数量

必需

示例

{
    "fields": [
        {
            "field": "string",
            "label": "string",
            "fun": {
                "name": "string",
                "params": [
                    {
                        "type": "value",
                        "value": "string"
                    }
                ]
            }
        }
    ],
    "where": {
        "relational": "and",
        "items": [
            {}
        ]
    },
    "order": [
        {
            "field": "string",
            "fun": {
                "name": "string",
                "params": [
                    {
                        "type": "value",
                        "value": "string"
                    }
                ]
            },
            "order": "ASC"
        }
    ],
    "group": [
        "string"
    ],
    "index": 0,
    "count": 0
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'https://s.hancel.org/api/cashflow/where' \
--header 'Content-Type: application/json' \
--data-raw '{
    "fields": [
        {
            "field": "string",
            "label": "string",
            "fun": {
                "name": "string",
                "params": [
                    {
                        "type": "value",
                        "value": "string"
                    }
                ]
            }
        }
    ],
    "where": {
        "relational": "and",
        "items": [
            {}
        ]
    },
    "order": [
        {
            "field": "string",
            "fun": {
                "name": "string",
                "params": [
                    {
                        "type": "value",
                        "value": "string"
                    }
                ]
            },
            "order": "ASC"
        }
    ],
    "group": [
        "string"
    ],
    "index": 0,
    "count": 0
}'

返回响应

🟢201成功

application/json

Body

data

array [object]

必需

code

integer

必需

message

string

必需

示例

{
    "data": [
        {
            "年": "2015",
            "总金额": "5062.90"
        },
        {
            "年": "2016",
            "总金额": "19507.32"
        },
        {
            "年": "2017",
            "总金额": "50727.85"
        },
        {
            "年": "2018",
            "总金额": "51349.38"
        },
        {
            "年": "2019",
            "总金额": "57003.13"
        },
        {
            "年": "2020",
            "总金额": "91331.35"
        },
        {
            "年": "2021",
            "总金额": "165998.34"
        },
        {
            "年": "2022",
            "总金额": "39598.33"
        },
        {
            "年": "2023",
            "总金额": "45602.00"
        },
        {
            "年": "2024",
            "总金额": "25971.49"
        }
    ],
    "code": 0,
    "message": "ok"
}

修改于 2024-09-08 07:12:10

搜索交易记录

更新交易项目