id problems

[ErichNiem]

I am trying to get the id from my database table to show on my datatable.

So far I have tried

$properties = DB::table('property')
    ->join('vetting', 'vetting.property_id', '=', 'property.id')
    ->where('vetting_status', 'LIKE', $status)
    ->where('property.deleted_at', '=', null)
    ->join('users', 'users.id', '=', 'property.user_id')
    ->select('reference', 'property.complex_number', 'property.complex_name',     'property.street_number', 'property.street_address', 'property.province', 'property.suburb_town_city',   'property_type', 'vetting_status', 'firstname', 'lastname', 'property_id', 'user_id', 'listing_type', 'featured')
    ->get();

    return Datatable::collection(new Collection($properties))
    ->showColumns('property_id', 'reference', 'listing_type')
    ->addColumn('street_address', function($Property){
        return $Property->complex_number . ' ' . $Property->complex_name . ' ' . $Property->street_number . ' ' . $Property->street_address;
    })............

I have tried

return Datatable::collection(new Collection($properties)) ->addColumn('id', function($Property){ return $Property->property_id; }) ->showColumns('reference', 'listing_type')..............

I have also tried

return Datatable::collection(new Collection($properties)) ->showColumns( ['property_id' => 'ID', 'reference' => 'Reference', 'listing_type' => 'Listing Type']) ->addColumn('street_address', function($Property){ return $Property->complex_number . ' ' . $Property->complex_name . ' ' . $Property->street_number . ' ' . $Property->street_address; }).............

my front end code is

{{ Datatable::table() // these are the column headings to be shown ->addColumn('ID', 'Reference', 'Listing Type', 'Street Address', 'Province', 'Suburb', 'Property Type', 'User Name', 'Vetting Status', 'Action') // this is the route where data will be retrieved ->setUrl(route('api.adminproperty', ['status' => $status])) ->setId('adminpropDatatable') ->render() }}

All give me an error Warning: table id = adminprop

Please note, adding the id was an after thought, everything was working perfectly.

[timgws]

You should be able to use Datatable::query, there should be no need to use a collection for this use case.

---- On Thu, 27 Aug 2015 20:49:25 +1000 [email protected] wrote ---- I am trying to get the id from my database table to show on my datatable. So far I have tried $properties = DB::table('property') ->join('vetting', 'vetting.property_id', '=', 'property.id') ->where('vetting_status', 'LIKE', $status) ->where('property.deleted_at', '=', null) ->join('users', 'users.id', '=', 'property.user_id') ->select('reference', 'property.complex_number', 'property.complex_name', 'property.street_number', 'property.street_address', 'property.province', 'property.suburb_town_city', 'property_type', 'vetting_status', 'firstname', 'lastname', 'property_id', 'user_id', 'listing_type', 'featured') ->get(); return Datatable::collection(new Collection($properties)) ->showColumns('property_id', 'reference', 'listing_type') ->addColumn('street_address', function($Property){ return $Property->complex_number . ' ' . $Property->complex_name . ' ' . $Property->street_number . ' ' . $Property->street_address; })............

I have tried return Datatable::collection(new Collection($properties))

    ->addColumn('id', function($Property){

        return $Property->property_id;

    })

    ->showColumns('reference', 'listing_type')..............

I have also tried return Datatable::collection(new Collection($properties))

    ->showColumns(

        ['property_id' => 'ID', 'reference' => 'Reference', 'listing_type' => 'Listing Type'])

    ->addColumn('street_address', function($Property){

        return $Property->complex_number . ' ' . $Property->complex_name . ' ' . $Property->street_number . ' ' . $Property->street_address;

    }).............

my front end code is {{ Datatable::table()

// these are the column headings to be shown

->addColumn('ID', 'Reference', 'Listing Type', 'Street Address', 'Province', 'Suburb', 'Property Type', 'User Name', 'Vetting Status', 'Action')

// this is the route where data will be retrieved

->setUrl(route('api.adminproperty', ['status' => $status]))

->setId('adminpropDatatable')

->render() }}

All give me an error

Warning: table id = adminprop Please note, adding the id was an after thought, everything was working perfectly. — Reply to this email directly or view it on GitHub.

[ErichNiem]

I have just changed this and I am still getting the same error.

return Datatable::query($properties) ->showColumns('id', 'reference', 'listing_type')................

I have just tried return Datatable::query($properties) ->showColumns('reference', 'listing_type')................

same error,

I also then realized that the error I gave you meant nothing

this is the response from ajax call

file: "C:\lamp\www\in2assets\vendor\chumper\datatable\src\Chumper\Datatable\Engines\CollectionEngine.php" line: 246 message: "Undefined offset: 0" type: "ErrorException"

With Collection

And

file: "C:\lamp\www\in2assets\vendor\chumper\datatable\src\Chumper\Datatable\Engines\QueryEngine.php" line: 56 message: "__clone method called on non-object" type: "Symfony\Component\Debug\Exception\FatalErrorException"

with Query

[timgws]

Hey Erich,

Sorry for the short reply earlier, I was on my phone (and also on a holiday!).

Please make sure that with Datatable::query that you are passing the QueryBuilder.

$query = DB::table('property')
    ->join('vetting', 'vetting.property_id', '=', 'property.id')
    ->where('vetting_status', 'LIKE', $status)
    ->where('property.deleted_at', '=', null)
    ->join('users', 'users.id', '=', 'property.user_id')
    ->select(/* columns */)
    // NOTICE I AM NOT CALLING GET HERE! ->get(); */
    ;

    return Datatable::query($query)
        ->//etc
        ;

[ErichNiem]

Hi. No stress, this has now broken search functionality.

And order column, also not working

[timgws]

@ErichNiem could you please let me know what version you have in your composer file?