/**
* Format content for DataTable plugin
* @param \Phalcon\Mvc\Model\Resultset\Simple $query
* @param array $params
* @return array
*/
public static function toDataTable(\Phalcon\Mvc\Model\Resultset\Simple $query, array $params = array())
{
$result = ['draw' => $params['sEcho'], 'recordsFiltered' => $params['iTotal'], 'recordsTotal' => $query->count(), 'data' => []];
foreach ($query->toArray() as $aRow) {
$row = [];
foreach ($params['aColumns'] as $col) {
$row[] = $aRow[substr($col, 2)];
}
// pre define first row as empty for checkboxes
$result['data'][] = array_merge([null], $row);
}
return $result;
}
