Head and feet

The data table supports filling the head and foot blocks as you wish.

  1. $grid->header(function ($collection) {
  2.     return 'header';
  3. });
  5. $grid->footer(function ($collection) {
  6.     return 'footer'; 
  7. });

The parameter $collection of the closure function is Illuminate\Support\Collection class instance, which is the current page table data, the following is an example of the use of two different scenarios

Head

  1. $grid->header(function ($collection) use ($grid) {
  2.     $query = Model::query();
  4.     // Get the table filter where the conditional array is traversed.
  5.     $grid->model()->getQueries()->unique()->each(function ($value) use (&$query) {
  6.         if (in_array($value['method'], ['paginate', 'get', 'orderBy', 'orderByDesc'], true)) {
  7.             return;
  8.         }
  10.         $query = call_user_func_array([$query, $value['method']], $value['arguments'] ?? []);
  11.     });
  13.     // Identify statistical data
  14.     $data = $query->get();
  16.     // Custom component
  17.     return new Card($data);
  18. });

Component implementation for custom header display

  1. <?php
  3. use Illuminate\Contracts\Support\Renderable;
  4. use Dcat\Admin\Admin;
  6. class Card implements Renderable
  7. {
  8.     public static $js = [
  9.         'xxx/js/card.min.js',
  10.     ];
  11.     public static $css = [
  12.         'xxx/css/card.min.css',
  13.     ];
  15.     protected $data;
  17.     public function __construct($data) 
  18.     {
  19.         $this->data = $data;
  20.     }
  22.     public function script()
  23.     {
  24.         return <<<JS
  25.         console.log('All JS scripts are loaded.');
  26.         $('xxx').card();
  27. JS;        
  28.     }
  30.     public function render()
  31.     {
  32.         // You can introduce your js or css file here.
  33.         Admin::js(static::$js);
  34.         Admin::css(static::$css);
  36.         // JS code to be executed on the page
  37.         // The JS code set by Admin::script will be executed automatically when all JS scripts are loaded.
  38.         Admin::script($this->script());
  40.         return view('...', ['data' => $this->data])->render();
  41.     }
  42. }

Footer

A more common scenario is to display statistics in the footer of a data form, such as adding revenue statistics to the footer of an order form, which can be implemented with the following code.

  1. $grid->footer(function ($collection) use ($grid) {
  2.     $query = Model::query();
  4.     // Get the table to filter the where condition array for iterations
  5.     $grid->model()->getQueries()->unique()->each(function ($value) use (&$query) {
  6.         if (in_array($value['method'], ['paginate', 'get', 'orderBy', 'orderByDesc'], true)) {
  7.             return;
  8.         }
  10.         $query = call_user_func_array([$query, $value['method']], $value['arguments'] ?? []);
  11.     });
  13.     // Identifying statistics
  14.     $data = $query->get();
  16.     return "<div style='padding: 10px;'>gross income ： $data</div>";
  17. });

If there is a more complex footer that needs to be displayed, you can also use a view object or wrap it into a class.