data sorting/filtering - Githubissues

Magickbase / ckb-explorer-public-issues

CKB Explorer Issues

https://explorer.nervos.org/

3 stars 2 forks source link

data sorting/filtering #42

Open Keith-CY opened 2 years ago

Keith-CY commented 2 years ago

PRD: https://o093j5.axshare.com/#id=gausgg&p=_42%E5%8E%9F%E5%9E%8B-%E9%A1%B5%E9%9D%A2%E5%A2%9E%E5%8A%A0%E7%AD%9B%E9%80%89%E5%92%8C%E6%8E%92%E5%BA%8F&g=1

Kirl70 commented 1 year ago

 1.Address Detail   https://www.figma.com/file/6XNoimRDbFTTNm016rbIdU/Magickbase?node-id=11944-35195&t=8AH6DCCVVtWxYVxw-11

 2.Block Detail   https://www.figma.com/file/6XNoimRDbFTTNm016rbIdU/Magickbase?node-id=6112-27234&t=8AH6DCCVVtWxYVxw-11

P.S. The icon of the search bar has been adjusted:

  3.Block List    https://www.figma.com/file/6XNoimRDbFTTNm016rbIdU/Magickbase?node-id=5653-24602&t=8AH6DCCVVtWxYVxw-11

P.S. The head style has been adjusted：

  4.Transaction List    https://www.figma.com/file/6XNoimRDbFTTNm016rbIdU/Magickbase?node-id=5653-24841&t=8AH6DCCVVtWxYVxw-11

  5.Pending Transactions    https://www.figma.com/file/6XNoimRDbFTTNm016rbIdU/Magickbase?node-id=9669-31924&t=8AH6DCCVVtWxYVxw-11

 6.Tokens List   https://www.figma.com/file/6XNoimRDbFTTNm016rbIdU/Magickbase?node-id=5670-24740&t=8AH6DCCVVtWxYVxw-11

 7.NFT List   https://www.figma.com/file/6XNoimRDbFTTNm016rbIdU/Magickbase?node-id=5696-25396&t=8AH6DCCVVtWxYVxw-11

 8.Tokens Detail   https://www.figma.com/file/6XNoimRDbFTTNm016rbIdU/Magickbase?node-id=5670-24831&t=8AH6DCCVVtWxYVxw-11

 9.NFT Details Activity   https://www.figma.com/file/6XNoimRDbFTTNm016rbIdU/Magickbase?node-id=12014-36542&t=8AH6DCCVVtWxYVxw-11

 10.NFT Details Holders   https://www.figma.com/file/6XNoimRDbFTTNm016rbIdU/Magickbase?node-id=5696-24961&t=8AH6DCCVVtWxYVxw-11

pygman commented 1 year ago

Frontend PR: https://github.com/nervosnetwork/ckb-explorer-frontend/pull/1243

sort and other API parameters that need to be added

sort=${sort_column_0}[.'asc' | .'desc'][,${sort_column_1}[.'asc' | .'desc']][,${sort_column_2}[.'asc' | .'desc']] default asc e.g.

sort=capacity
sort=capacity.desc
sort=capacity.desc,time,reward.asc

GET /blocks

{
"page": 1,
"page_size": 10,
"sort": $ 'height' | 'transactions' | 'reward'
}

GET /address_transactions/${address}

{
"page": 1,
"page_size": 10,
"sort": $ 'time',
"tx_type": 'outgoing' | 'incoming' | 'customised'
}

GET /transactions

{
"page": 1,
"page_size": 10,
"sort": $ 'height' | 'capacity'
}

GET /pending_transactions

{
"page": 1,
"page_size": 10,
"sort": $ 'capacity' | 'time' | 'fee'
}

GET /udts

{
"page": 1,
"page_size": 10,
"sort": $ 'transactions' | 'addresses_count' | 'created_time'
}

iamyates commented 1 year ago

backend PR: https://github.com/nervosnetwork/ckb-explorer/pull/1243 some features done. some features seems complicated and need to changed database structure a lot. need another meeting/discussion.

iamyates commented 1 year ago

most of the features are done.
integrated with frontend . (https://github.com/pygman/ckb-explorer-frontend.git branch: ) please check this PR: https://github.com/nervosnetwork/ckb-explorer/pull/1243

some features are not done yet because we need to do many work/effort/db-migration, I think we can put these tasks into another iteration , if possible.

backend deployed to: http://3.112.30.76:8181/