예제 #1
0
파일: api.php 프로젝트: edusig/USP
         $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']);
         $maxlength = $sqlm->getColumnLength($v['Type']);
         $maxlength = is_array($maxlength) ? $maxlength[0] + $maxlength[1] + 1 : $maxlength;
         $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-3">' . $type . ', ' . $limit . '</div><div class="col-sm-6"><input name="' . $v['Field'] . 'Value" class="form-control" data-pk="' . ($v['Key'] == 'PRI' ? 1 : 0) . '" maxlength="' . $maxlength . '" id="' . $v['Field'] . '" type="text"></div></div>';
     }
     $html .= '<input type="hidden" id="formType" value="Insert"><input type="hidden" id="updatePks" value=""><input type="hidden" id="updatePksValue" value=""><div class="form-submit form-group pull-right"><input type="button" value="Cancelar" id="cancelarUpdate" class="btn btn-primary hide"><input type="submit" value="Inserir" class="btn btn-primary"></div></div></form></div>';
     $sqlm->setJSON(base64_encode(utf8_decode($html)));
     break;
 case 'Select':
     $distinct = isset($distinct) ? $distinct : false;
     $conditions = array();
     $attributeList = explode(',', $attributes);
     $attributeCompare = explode(',', $compares);
     $attributeCompareValue = explode(',', $values);
     $length = 0;
     foreach ($attributeCompare as $k => $v) {
         if ($v != '0') {