break; case 'TableVisualize': $sort = isset($sort) ? $sort : false; $dir = isset($dir) ? $dir : false; $r = $sqlm->getAllFromTable($table, $sort, $dir); if (!$r) { $sqml->setErro('ET'); break; } $i = 0; foreach ($r as $k => $v) { $i++; $r[$k]['action'] = base64_encode("<input type='hidden' name='select_row_{$i}' id='row_pks_{$i}' data-pk='" . join(',', $sqlm->getPrimaryKeys($table)) . "' data-pkvalues='" . join(',', $sqlm->getPrimaryKeyValues($table, $v)) . "' class='tupla_select'><span class='glyphicon glyphicon-edit editarTupla' id='editar_{$table}_{$r[$k][0]}' data-row='{$i}' data-id='{$r[$k][0]}'></span><span class='glyphicon glyphicon-remove removerTupla' id='deletar_{$table}_{$r[$k][0]}' data-row='{$i}' data-id='{$r[$k][0]}'></span>"); } $columns = array(array('mData' => 'action', 'sTitle' => 'Ação', 'sClass' => 'actionColumn')); foreach ($sqlm->getColumns($table) as $k => $v) { if ($v['Field'] == $sort) { if ($dir) { $dirclass = $dir == 'asc' ? 'desc' : 'asc'; } else { $dirclass = 'desc'; } } else { $dirclass = 'desc'; } array_push($columns, array('mData' => $v['Field'], 'sTitle' => $sqlm->renameColumns($v['Field']), 'sClass' => 'sortCustomColumn ' . $v['Field'] . ' ' . $dirclass)); } $sqlm->setJSON(array('aoColumns' => $columns, 'aaData' => $r)); break; case 'TableSearch': $columns = $sqlm->getColumns($table);