$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>'; $sqlm->setJSON(base64_encode(utf8_decode($html))); break; case 'TableInsert': $columns = $sqlm->getColumns($table); $html = '<div class="sqlInsertForm"><h3>Inserir/Editar em ' . $table . '</h3><form id="sqlInsertEditForm"><div class="baseForm">'; foreach ($columns as $k => $v) { $type = $sqlm->getColumnTypeRenamed($v['Type']); $limit = $sqlm->getColumnTypeLimit($v['Type']);