title: TeamBilling
blocks:
- type: table
fetchFn: |
const r = await axios({
url: BI_API + '/readonly-query',
method: 'POST',
data: {
token: SELECT_ACCESS_TOKEN,
query: `
SELECT * FROM TeamBilling
ORDER BY id DESC
LIMIT 10
`,
},
json: true
})
return r.data?.rows || r.data
autoHeader: true
headers:
receipt_json:
hidden: true
deleted_at:
hidden: true
json:
format: json
width: 500px
org_id:
format: link
# full: true
width: 100%
rowClickFn: |
const {block, row, key, $modal} = opt
if (key == 'org_id') {
opt.$router.push({
query: {
oid: row.org_id,
}
}).catch()
$modal.show('org_id')
}
- type: modal
name: org_id
header: Teams of organization
routeQuery: oid
width: 800
defaultHeight: 50vh
# clickToClose: false
blocks:
- type: table
fetchFn: |
const r = await axios({
url: BI_API + '/readonly-query',
method: 'POST',
data: {
token: SELECT_ACCESS_TOKEN,
query: `
SELECT id, name, created_at, plan, plan_state FROM Team
WHERE org_id = '${ params.$route?.query?.oid || 0 }'
LIMIT 10
`,
},
json: true
})
return r.data?.rows || r.data
autoHeader: true
rowClickFn: |
const {block, row, key, $modal} = opt
opt.$router.push({
query: {
...opt.$route.query,
tid: row.id,
}
}).catch()
$modal.show('team_id')
- type: modal
name: team_id
header: Team Info
routeQuery: tid
width: 800
defaultHeight: 50vh
# clickToClose: false
draggable: true
shiftX: 0.55
blocks:
- type: tab
tabOptions:
type: plain
autoload: 1
tabs:
- name: TeamRow
blocks:
- type: table
title: TeamRow
fetchFn: |
const r = await axios({
url: BI_API + '/readonly-query',
method: 'POST',
data: {
token: SELECT_ACCESS_TOKEN,
query: `
SELECT id, team_id, name, \`type\`, created_at, user_id FROM TeamRow
WHERE team_id = '${ params.$route?.query?.tid || 0 }'
LIMIT 10
`,
},
json: true
})
return r.data?.rows || r.data
autoHeader: true
- name: Detail
blocks:
- type: markdown
content: |
> todo
