Documentation for adding a calculated field

[waldo2188]

Hi,
is it possible to add documentation for how to add calculated fields.

In my case, I have a oneToMany relationship and i want to know how much row has the entity.

For exemple :

$datatable = $this->get('lankit_datatables')->getDatatable('WaldoMyBundle:Customer');
$datatable->setSelect("COUNT(Customer.shoppingCart) as nbShoppingCart");
        return $datatable->getSearchResults();

Thanks

[ChadSikorra]

You could use mRender on a column on the one-to-many entity to return a count of the array that is generated. An untested example, but should give you the gist of it...

    var oTable = $('#example').dataTable( {
        "sAjaxSource": "sources/deep.txt",
        "aoColumns": [
            { "mData": "firstName" },
            { "mData": "lastName" },
            {
              "mData": "shoppingCart.id",
              "mRender": function(data, type, full) {
                  return '<p>' + data.length + '</p>';   
              }
            }
        ]
    });

[waldo2188]

This work with this code:

{
   mData: "shoppingCart.id",
    sDefaultContent: "",
    bSortable: false,
    bVisible: false
}

The parameter sDefaultContent is for prevent a warning from datatable.

But it will be a great features, if we will can define a Query instead of a simple Entity.

By the way, this bundle is really useful, thanks for the work !

[ChadSikorra]

Yeah, that does sound like a good feature idea. I'll have to give some thought about how it would be implemented.

[waldo2188]

I found a solution ^^
It's a little bit messy but it's work fine.

Lets go for an exemple :

$datatable = $this->get('lankit_datatables')->getDatatable('WaldoMyBundle:Customer');

// Construction of DQL query
$datatable->makeSearch();

/* @var $queryBuilder \Doctrine\ORM\QueryBuilder */
$qb = $datatable->getQueryBuilder(); // we retrieve the QueryBuilder

// Here we add what we want in the query
// But I don't know why, it doesn't work really good if I use $qb->addSelect
$qb->select("Organisme.id, Organisme.sigle, Organisme.libelle, COUNT(ShoppingCart.id) as nbShoppingCart");
$qb->leftJoin("Customer.shoppingCart", "ShoppingCart");

// We execute the query
$dataTableResult = $datatable->executeSearch();

// Add generate the response !
return $dataTableResult->getSearchResultsResponse();

Thanks for this great bundle !