(graphql) add sorter and filter for Smart Contract list

[Naupio]

No description provided.

[Naupio]

- [ ] sorted by balance

• sorted by tx count
• sorted by id
• sorted by name

[Naupio]

example:

    query {
      smart_contracts(
        input: { sorter: [{ sort_type: DESC, sort_value: EX_TX_COUNT }] }
      ) {
        entries {
          name
          account_id
          account {
            eth_address
            transaction_count
          }
        }
        metadata {
          total_count
          after
          before
        }
      }
    }

{
  "data": {
    "smart_contracts": {
      "entries": [
        {
          "account": {
            "eth_address": "0x2503a1a79a443f3961ee96a8c5ec513638129614",
            "transaction_count": 33
          },
          "account_id": "6841",
          "name": "EIP20"
        }
      ],
      "metadata": {
        "after": null,
        "before": null,
        "total_count": 1
      }
    }
  }
}

[Naupio]

add new sorter field for input object
@Keith-CY

[Naupio]

restful api use rpc to fetch ckb balance for responses , so doesn’t implement balance sorter for graphql query

[FrederLu]

@Naupio
There are 2 pieces of data on the page. The interface output parameter displays one piece of data. Is the second piece of data filtered?

[Keith-CY]

Not used in front-end yet

[Naupio]

@Naupio There are 2 pieces of data on the page. The interface output parameter displays one piece of data. Is the second piece of data filtered?

I check the source database table, the new record was exist now,