예제 #1
0
파일: api.php 프로젝트: edusig/USP
     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);
     $html = '<div class="sqlSearchForm"><h3>Pesquisar em ' . $table . '</h3><form id="sqlSearchForm">';
     foreach ($columns as $k => $v) {
         $compares = $sqlm->getComparesFields($sqlm->getCompares($sqlm->getColumnType($v['Type'])));
         $html .= '<div class="form-input form-group"><label for="' . $v['Field'] . 'Value" class="col-sm-3 control-label">' . $sqlm->renameColumns($v['Field']) . '</label><div class="col-sm-2"><select name="' . $v['Field'] . 'Compare" class="form-control" id="' . $v['Field'] . 'Compare"><option value="0">Selecione</option>';
         foreach ($compares as $key => $val) {
             $html .= '<option value="' . $val . '">' . $key . '</option>';
         }
         $html .= '</select></div><div class="col-sm-7"><input type="text" name="' . $v['Field'] . '" class="form-control" id="' . $v['Field'] . '"></div></div>';
     }
     $html .= '<div class="form-submit form-group pull-right"><input type="submit" name="envir" value="Pesquisar" class="btn btn-primary"></div></form></div><div class="sqlSearchResult"><table id="searchTable" class="table"><thead></thead><tbody></tbody></table></div>';