예제 #1
0
파일: api.php 프로젝트: edusig/USP
$params_start = strpos($_SERVER['REQUEST_URI'], '?') + 1;
if ($params_start > 1) {
    $requestURI = substr($_SERVER['REQUEST_URI'], $params_start);
    $params = explode('&', $requestURI);
    foreach ($params as $k => $v) {
        $params[$k] = explode('=', $v);
        ${$params}[$k][0] = $params[$k][1];
    }
}
$type = substr($queryType, 0, 5);
if ($type == 'Table' && isset($table)) {
    $sqlm->setTableParams($table);
}
switch ($queryType) {
    case 'TableCountRows':
        $sqlm->setJSON($sqlm->getCountRowsAllTables());
        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'));