PHP Developer Guide
Other documentationsDemoCommunityGitHub
  • Forest Admin
  • Getting started
    • How it works
    • Quick start
      • Symfony
      • Laravel
    • Create your agent
    • Troubleshooting
    • Migrating legacy agents
      • Pre-requisites
      • Recommendations
      • Migration steps
      • Code transformations
        • API Charts
        • Live Queries
        • Smart Charts
        • Route overrides
        • Smart Actions
        • Smart Fields
        • Smart Relationships
        • Smart Segments
  • Data Sources
    • Getting Started
      • Collection selection
      • Naming conflicts
      • Query interface and Native Queries
        • Fields and projections
        • Filters
        • Aggregations
    • Provided data sources
      • Doctrine
      • Eloquent
        • Polymorphic relationships
    • Write your own
      • Translation strategy
        • Structure declaration
        • Capabilities declaration
        • Read implementation
        • Write implementation
        • Intra-data source Relationships
      • Contribute
  • Agent customization
    • Getting Started
    • Actions
      • Scope and context
      • Result builder
      • Static Forms
      • Dynamic Forms
      • Related data invalidation
    • Charts
      • Value
      • Objective
      • Percentage
      • Distribution
      • Leaderboard
      • Time-based
    • Fields
      • Add fields
      • Move, rename and remove fields
      • Override binary field mode
      • Override writing behavior
      • Override filtering behavior
      • Override sorting behavior
      • Validation
    • Hooks
      • Collection hook
      • Collection override
    • Pagination
    • Plugins
      • Write your own
    • Relationships
      • To a single record
      • To multiple records
      • Computed foreign keys
      • Under the hood
    • Search
    • Segments
  • Frontend customization
    • Smart Charts
      • Create a table chart
      • Create a bar chart
      • Create a cohort chart
      • Create a density map
    • Smart Views
      • Create a Map view
      • Create a Calendar view
      • Create a Shipping view
      • Create a Gallery view
      • Create a custom tinder-like validation view
      • Create a custom moderation view
  • Deploying to production
    • Environments
      • Deploy on AWS
      • Deploy on Heroku
      • Deploy on GCP
      • Deploy on Ubuntu
    • Development workflow
    • Using branches
    • Deploying your changes
    • Forest Admin CLI commands
      • init
      • login
      • branch
      • switch
      • set-origin
      • push
      • environments:create
      • environments:reset
      • deploy
  • Upgrade
    • Laravel agent upgrade to v3
  • Under the hood
    • .forestadmin-schema.json
    • Data Model
      • Typing
      • Relationships
    • Security & Privacy
Powered by GitBook
On this page
  • Tips
  • Count queries

Was this helpful?

  1. Data Sources
  2. Write your own
  3. Translation strategy

Read implementation

This is the official documentation of the forestadmin/laravel-forestadmin v2+ and forestadmin/symfony-forestadmin PHP agents.

Developing your query translation layer is much easier when you can preview your work and have intermediary deliverables.

Emulation comes to the rescue: all features that need to be implemented when making a translating data source can be emulated inside your Node.js, at the cost of performance.

This enables you to be up and running in minutes and then optimize your code as you go.

<?php

use ForestAdmin\AgentPHP\DatasourceToolkit\Collection;
use ForestAdmin\AgentPHP\DatasourceToolkit\Components\Caller;
use ForestAdmin\AgentPHP\DatasourceToolkit\Components\Query\Aggregation;
use ForestAdmin\AgentPHP\DatasourceToolkit\Components\Query\Filters\Filter;
use ForestAdmin\AgentPHP\DatasourceToolkit\Components\Query\Projection\Projection;

/**
 * This collection will have terrible performance, but is perfect to test that the
 * structure declaration is well done.
 */
class MyCollection extends Collection
{
    // [... Declare structure and capabilities]
    //  $this->client = new \GuzzleHttp\Client([...]);

    public function list(Caller $caller, Filter $filter, Projection $projection): array
    {
        // Fetch all records on all requests (this is _very_ inefficient)
        try {
            $response = $this->client->get('https://my-api/my-collection');
            $result = json_decode($response->getBody()->getContents(), true)['items'] ?? [];

            if ($filter->getConditionTree()) {
                $result = $filter->getConditionTree()->apply($response, $this, $caller->getTimezone());
            }
            if ($filter->getSort()) {
                $result = $filter->getSort()->apply($result);
            }
            if ($filter->getPage()) {
                $result = $filter->getPage()->apply($result);
            }
            if ($filter->getSegment()) {
                throw new \RuntimeException('This collection does not implements native segments');
            }
            if ($filter->getSearch()) {
                throw new \RuntimeException('This collection is not natively searchable');
            }

            return $projection->apply($result);
        } catch (\Exception $e) {
            throw new \RuntimeException('Failed to fetch or process items: ' . $e->getMessage());
        }
    }

    public function aggregate(Caller $caller, Filter $filter, Aggregation $aggregation, ?int $limit = null)
    {
        // Fetch all records which should be aggregated
        $records = $this->list($caller, $filter, $aggregation->getProjection());

        return $aggregation->apply($records, $caller->getTimezone(), $limit);
    }

Tips

Count queries

The aggregate method is used by Forest Admin both to count records and to extract the data which is needed to generate charts.

If the API/Database you are targeting has an efficient API that is made for counting records, you may want to handle this case first.

<?php

use ForestAdmin\AgentPHP\DatasourceToolkit\Collection;
use ForestAdmin\AgentPHP\DatasourceToolkit\Components\Caller;
use ForestAdmin\AgentPHP\DatasourceToolkit\Components\Query\Aggregation;
use ForestAdmin\AgentPHP\DatasourceToolkit\Components\Query\Filters\Filter;
use ForestAdmin\AgentPHP\DatasourceToolkit\Components\Query\Projection\Projection;

class MyCollection extends Collection
{
    // [... Declare structure, capabilities and list method]
    //  $this->client = new \GuzzleHttp\Client([...]);

    public function aggregate(Caller $caller, Filter $filter, Aggregation $aggregation, ?int $limit = null)
    {
        if ($aggregation->getOperation() === 'Count' && empty($aggregation->getGroups()) && ! $aggregation->getField()) {
            return [
                ['value' => $this->count($caller, $filter)],
            ];
        }

        // [... handle the general case]
    }

    public function count(Caller $caller, Filter $filter)
    {
        $response = $this->client->get('https://my-api/my-collection/count', [
            'query' => ['filter' => $this->translateFilter($caller, $filter)],
        ]);

        return json_decode($response->getBody()->getContents(), true)['count'];
    }

    private function translateFilter(Caller $caller, Filter $filter)
    {
        // [... translate filter]
    }
}
PreviousCapabilities declarationNextWrite implementation

Last updated 4 months ago

Was this helpful?