Summary of problem or feature request

Problem 1
- Can only install one of: league/fractal[0.17.0, 0.16.0].
- Can only install one of: league/fractal[0.16.0, 0.17.0].
- Can only install one of: league/fractal[0.16.0, 0.17.0].
- yajra/laravel-datatables-fractal v1.0.0 requires league/fractal ^0.16 -> s
atisfiable by league/fractal[0.16.0].
- Installation request for yajra/laravel-datatables-fractal 1.0 -> satisfiab
le by yajra/laravel-datatables-fractal[v1.0.0].
- Installation request for league/fractal (locked at 0.17.0) -> satisfiable
by league/fractal[0.17.0].

Installation failed, reverting ./composer.json to its original content.

Code snippet of problem

System details

• Operating System
• PHP Version 7.1
• Laravel Version 5.5
• Laravel-Datatables Version 8.0

I am working on a project using Laravel with Mongo DB , this is my transformer

<?php


namespace App\Datatables;

use League\Fractal;
use App\Models\Device;
use Carbon\Carbon;
class DeviceTransformer extends Fractal\TransformerAbstract
{
public function transform(Device $device)
{
    $online='<a ><span class="avatar">  <span class="avatar-status-offline"></span>    </span>offline</a>';
        $vlan= $device->InternetGatewayDevice['WANDevice']['1']['WANConnectionDevice']['1']['WANPPPConnection']['1']['X_HW_VLAN']['_value']??"";
        $mac=$device->VirtualParameters['Macaddress']['_value']??"";
        $pppoeUsername=$device->VirtualParameters['pppoeUsername']['_value']??"";
        $rxpower=$device->VirtualParameters['RXPower']['_value']??"";
        $ssid=$device->InternetGatewayDevice['LANDevice']['1']['WLANConfiguration']['1']['SSID']['_value']??"";
        $lastinform=$device->_lastInform ??"";
        $lastinform=Carbon::parse($lastinform)->format('Y-m-d H:i:s');

        $now=Carbon::now()->subMinutes(5);
        $last24hours=Carbon::now()->subHours(24);
          if($lastinform> $now)
              $online='<a><span class="avatar"> <span class="avatar-status-online"></span>   </span>Online</a>';
          elseif($lastinform<$now && $lastinform > $last24hours)
              $online='<a><span class="avatar"> <span class="avatar-status-busy"></span>  </span>Past 24 Hours</a>';


return [
'id'   => $device->_id,
'serial'=>$device->_deviceId['_SerialNumber'],
'productclass'=>$device->_deviceId['_ProductClass'],
'vendor'=>$device->_deviceId['_Manufacturer'],
'lastInform'=> $lastinform,
'vlan' => $vlan."",
'Mac'=>$mac,
'PPPusername'=>$pppoeUsername,
'RX'=>$rxpower,
'ssid'=>$ssid,
'action'=> "<a href='".$device->_id."'>Show</a>",
'online'=>$online
];
}

}

this is how I call data in the controller

$data=Device::query();


 return DataTables::of($data)
      ->setTransformer('App\Datatables\DeviceTransformer')

      ->make(true);

the problem is after 3 or 4 pages same raws comming to data table , and just 2 or 3 raws change.
how is that Possible, it seems datatable return same raws again and again in different pages .

in README.md,
Yajra\Datatables\FractalServiceProvider::class
should be Yajra\DataTables\FractalServiceProvider::class, right?
DataTables not Datatables. Otherwise I'll get error.

how to use fractal transformer and ->addColumn('action', 'admin.categories.datatables_actions'); together ?

$dataTable = new EloquentDataTable($query);

        return $dataTable
            ->setTransformer(new CategoryTransformer())
            ->addColumn('action', 'admin.categories.datatables_actions');

If i user this - action buttons do not display. How to include them with the transformer ?

Summary of problem or feature request

Can't install the fractal, because fractal need to be exact on v0.18.0
seems have colleration with this statement craftcms/element-api#109 (comment)

Code snippet of problem

PS D:\htdocs\hokky-laravel> composer require yajra/laravel-datatables-fractal:^1.0
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - Can only install one of: league/fractal[0.16.0, 0.18.0].
    - Can only install one of: league/fractal[0.18.0, 0.16.0].
    - Can only install one of: league/fractal[0.16.0, 0.18.0].
    - yajra/laravel-datatables-fractal v1.0.0 requires league/fractal ^0.16 -> satisfiable by league/fractal[0.16.0].     
    - Installation request for yajra/laravel-datatables-fractal 1.0 -> satisfiable by yajra/laravel-datatables-fractal[v1.0.0].
    - Installation request for league/fractal (locked at 0.18.0) -> satisfiable by league/fractal[0.18.0].

if I tried using manual install fractal 0.16.0, it will conflict with newest datatables version

PS D:\htdocs\hokky-laravel> composer require league/fractal:^0.16.0
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.

  Problem 1
    - yajra/laravel-datatables-fractal v1.5.0 requires league/fractal ^0.18.0 -> satisfiable by league/fractal[0.18.0] but these conflict with your requirements or minimum-stability.
    - yajra/laravel-datatables-fractal v1.5.0 requires league/fractal ^0.18.0 -> satisfiable by league/fractal[0.18.0] but these conflict with your requirements or minimum-stability.
    - yajra/laravel-datatables-fractal v1.5.0 requires league/fractal ^0.18.0 -> satisfiable by league/fractal[0.18.0] but these conflict with your requirements or minimum-stability.
    - Installation request for yajra/laravel-datatables-fractal (locked at v1.5.0) -> satisfiable by yajra/laravel-datatables-fractal[v1.5.0].


Installation failed, reverting ./composer.json to its original content.

System details

• Operating System
  Windows 10 1909
• PHP Version
  php 7.4.1
• Laravel Version
  6.x (should be latest version)
• Laravel-Datatables Version
  "yajra/laravel-datatables": "1.5"

I can't get this plugin to work. I keep on getting a Method setTransformer does not exist. error.

Here's my code:

config/app.php

<?php

return [
    // Omitted

    /*
     * Package Service Providers...
     */
    // Omitted
    Yajra\DataTables\DataTablesServiceProvider::class,
    Yajra\DataTables\FractalServiceProvider::class,

    // Omitted


    'aliases' => [
        // Omitted
        'DataTables' => Yajra\DataTables\Facades\DataTables::class,
    ];
]

UserController.php

namespace App\Http\Controllers;

use App\Models\User;
use App\Transformers\EmployeeTransformer;
use DataTables;

class DailyTimeRecordController extends Controller
{
    public function getEmployees() {
        $employees = User::role('employee');

        return Datatables::eloquent($employees)
            ->setTransformer(new EmployeeTransformer)
            ->make()
    }
}

EmployeeTransformer.php

namespace App\Transformers;

use App\Models\User;
use League\Fractal\TransformerAbstract;

class DailyTimeRecordsTransformer extends TransformerAbstract
{
    /**
     * A Fractal transformer.
     *
     * @param User $user
     * @return array
     */
    public function transform(User $user)
    {
        return [
            'full_name' => $user->full_name,
            'avatar' => $user->avatar,
            // Omitted
        ];
    }
}

Error Stacktrace:
[2017-09-12 18:17:07] local.ERROR: BadMethodCallException: Method setTransformer does not exist. in /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Support/Traits/Macroable.php:74 Stack trace: #0 /Users/alexanderawitin/Code/tymelog/app/Http/Controllers/UserController.php(45): Yajra\DataTables\DataTableAbstract->__call('setTransformer', Array) #1 [internal function]: App\Http\Controllers\UserController->timeLogs(Object(Illuminate\Http\Request), NULL, NULL) #2 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #3 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('timeLogs', Array) #4 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\UserController), 'timeLogs') #5 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #6 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Router.php(572): Illuminate\Routing\Route->run() #7 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #8 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #9 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #10 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #11 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #12 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), '60', '1') #13 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Router.php(533): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #17 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #20 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #21 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #22 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #27 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #30 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #33 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #34 /Users/alexanderawitin/Code/tymelog/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #35 /Users/alexanderawitin/Code/tymelog/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #36 /Users/alexanderawitin/.composer/vendor/laravel/valet/server.php(133): require('/Users/alexande...') #37 {main}

Also, php artisan vendor:publish --tag=datatables-fractal --force don't seem to publish any file related to this package.

System details

• Operating System: macOS Sierra 10.12.6
• PHP Version: v7.1.8
• Laravel Version: v5.4.36
• Laravel-Datatables Version: v8.0.3
• Laravel-Datatables-Fractal Version: v1.0.1

Summary of problem or feature request

Can't install laravel-datatables-fractal because it's require yajra/laravel-datatables-oracle: 8.*
and not supporting yajra/laravel-datatables-oracle: 9.*

when trying to install this package plugin
with composer require yajra/laravel-datatables-fractal
composer shows error:

yajra/laravel-datatables-fractal v1.3.0 requires yajra/laravel-datatables-oracle 8.*

• Operating System : Ubuntu 16.04
• PHP Version : 7.2
• Laravel Version : 5.9
• Laravel-Datatables Version : 9.0

https://yajrabox.com/docs/laravel-datatables/master/response-fractal

When using tranformer, all response manipulations must be done via transformer. Thus addColumn, editColumn, removeColumn, setRowAttr,setClassAttr, etc... should be avoided when using fractal.

https://yajrabox.com/docs/laravel-datatables/master/row-options

The methods above are extremely useful, why is fractal preventing their use?

Summary of problem or feature request

Hello
It seems that searching the table always return empty if the data has been transform. How can I make the searching return the appropriate data while using transformer?

Code snippet of problem

System details

• Operating System Centos 6
• PHP Version PHP 7
• Laravel Version 5.6
• Laravel-Datatables Version 8.0

Summary of problem or feature request

Hi, I am trying to using fractal in datatables and after installing this plugin, I still have the above error.
The package that install in my Laravel Application is :

1. Fractal
2. Yajra Datatables
3. Yajra Fractal Datatables

here is my code

Code snippet of problem

DaftarMutasiController.php

use DataTables;
use League\Fractal\Manager;
use League\Fractal\Resource\Collection;
use App\Transformers\DaftarMutasiTransformers;

public function daftar_json(Request $request = null, $id)
	{
		$daftar = DaftarMutasi::select('id', 'no_urut', 'nama', 'nip', 'golru', 'ttl', 'jabatan_lama', 'unit_kerja_lama', 'jabatan_baru', 'unit_kerja_baru')
		->where('id_riwayat_mutasi', $id)
		->orderBy('no_urut', 'asc')
		->get();
		return DataTables::eloquent($daftar)
                ->setTransformer(new DaftarMutasiTransformers)
                ->toJson();
	}

DaftarMutasiTransformers.php

<?php
namespace App\Transformers;

use App\DaftarMutasi;
use League\Fractal;

class DaftarMutasiTransformers extends Fractal\TransformerAbstract
{
    
    /**
     * @param \App\User $user
     * @return array
     */
    public function transform(DaftarMutasi $daftar)
    {
		$daftar = DaftarMutasi::select('id', 'no_urut', 'nama', 'nip', 'golru', 'ttl', 'jabatan_lama', 'unit_kerja_lama', 'jabatan_baru', 'unit_kerja_baru')
		->where('id_riwayat_mutasi', $id)
		->orderBy('no_urut', 'asc')
		->get();
		
        return [
			'id'      => (int) $daftar['id'],
			'no_urut'   => $daftar['no_urut'],
			'nama' => $daftar['nama'] ,
			'nip' => $daftar['nip'],
			'golru' => $daftar['golru'],
			'ttl' => $daftar['ttl'],
			'jabatan_lama' => $daftar['jabatan_lama'].' '.$daftar['unit_kerja_lama'],
			'jabatan_baru' => $daftar['jabatan_baru'].' '.$daftar['unit_kerja_baru'],
		];
    }
}

System details

• Operating System
• PHP Version 7.0
• Laravel Version 5.4
• Laravel-Datatables Version 8.0

Hello,

I'm trying to use serverside datable loading with yajra/databale.

This my composer.json :

"require": {
        "php": ">=5.6.4",
        "elibyy/tcpdf-laravel": "5.5.*",
        "laravel/framework": "5.5.*",
        "laravel/socialite": "^3.0",
        "laravel/tinker": "~1.0",
        "paragonie/random_compat": "~1.4",
        "pulkitjalan/google-apiclient": "3.*",
        "yajra/laravel-datatables-fractal": "1.0",
        "yajra/laravel-datatables-oracle": "~8.0"
    },

this is my config/app.php

 'providers' => [
         //DATATABLES
         Yajra\DataTables\DataTablesServiceProvider::class,
         Yajra\DataTables\FractalServiceProvider::class
     ],
 
     'aliases' => [
         'DataTables' => Yajra\DataTables\Facades\DataTables::class,
     ],

This is my cntroller :

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Yajra\Datatables\Datatables;
use Yajra\DataTables\FractalServiceProvider;
use Illuminate\Support\Facades\DB;
use App\Peserta;
use App\Kegiatan;
use PDF;

class SertifikatController extends Controller
{
    public function index(){
      $getListKegiatan = Kegiatan::getListKegiatan();

      $data = array('list_kegiatan' => $getListKegiatan);

      return view('sertifikat.index', $data);
    }

    public function getSertifikatDatatables(request $request)
    {
        DB::statement(DB::raw('set @rownum=0'));

        $query = DB::table('tr_peserta')
              ->leftJoin('tr_kegiatan', 'tr_kegiatan.id', '=', 'tr_peserta.id_tr_kegiatan')
              ->leftJoin('mst_judul_acara', 'mst_judul_acara.id', '=', 'tr_kegiatan.id_mst_judul_acara')
              ->select([DB::raw('@rownum  := @rownum  + 1 AS rownum'),'tr_peserta.id','mst_judul_acara.judul_acara', 'tr_peserta.nim', 'tr_peserta.nama', 'tr_kegiatan.alias', 'tr_peserta.asal_kampus'])
              ->where('tr_peserta.active', 1);

        $datatables =  Datatables::of($query);

        if($id = $request->input('id_kegiatan')) {
            $datatables->where('tr_peserta.id_tr_kegiatan', $id);
        }

        return $datatables
        ->addColumn('action', function ($peserta) {
            return '<button type="button" class="btn btn-mini" onclick="hapusPeserta(\''.$peserta->id.'\')"><i class="fontello-icon-trash-3"></i></button>';
        })
        ->make(true);
    }
}

but i'm still got error.

Can someone help me please.

Thanks a lot.

System details

• Operating System
• PHP Version 7.1.8
• Laravel 5.5
• Laravel-Datatables 8

Updating dependencies
Your requirements could not be resolved to an installable set of packages.

Problem 1
- Root composer.json requires yajra/laravel-datatables-fractal ^1.6 -> satisfiable by yajra/laravel-datatables-fractal[v1.6.0].
- yajra/laravel-datatables-fractal v1.6.0 requires league/fractal ^0.19.0 -> found league/fractal[0.19, 0.19.1, 0.19.2] but the package is fixed to 0.20.x-dev (lock file version) by a partial update and that version does not match. Make sure you list it as an argument for the update command.

Use the option --with-all-dependencies (-W) to allow upgrades, downgrades and removals for packages currently locked to specific versions.
You can also try re-running composer require with an explicit version constraint, e.g. "composer require yajra/laravel-datatables-fractal:*" to figure out if any version is installable, or "composer require yajra/laravel-datatables-fractal:^2.1" if you know which you need.

How can I add yajra/laravel-datatables-fractal in laravel 9 ?