Refresh Bootstrap-table

1

The problem is that I can not get the table (bootstrap-table) to update the data after the registration. I'm trying to do this via JS, but to no avail. I've tried the following:

- JS -

$.post($form.attr('action'), $form.serialize(), function (result) {
        if (result.status == "true") {
            $(location).attr('href', result.acao.url);
        } else {
            $('#cargo').formValidation('resetForm', true)
            $('#cadastroCargo').modal('hide')
            //TENTATIVA DO REFRESH NA TABLE:
            $('#teste').bootstrapTable('refresh')
        }
    }, 'json');

- HTML / PHP -

<button class="btn btn-primary pull-right btn-import-user btn-sm" data-toggle="modal" data-target="#cadastroCargo">Novo Cadastro</button>

<!-- Modal -->
<div class="modal fade" id="cadastroCargo" tabindex="-1" data-keyboard="false" data-backdrop="static" role="dialog" aria-labelledby="cargoLabel">

<div class="modal-dialog" role="document">
<div class="modal-content">
<form id="cargo" action="Cargo/inserir" method="POST" enctype="multipart/form-data" autocomplete="off">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                    <h4 class="modal-title" id="cargoLabel">Cadastrar Cargo</h4>
                </div>
                <div class="modal-body">
                    <fieldset>
                        <div class="form-group">
                            <label class="modal-font-body control-label">Informe o Cargo</label>
                            <input name="titulo" type="text" class="form-control input-sm" id="titulo" data-minlength="4" size="35" value="<?= @$cargo->titulo ?>" data-error="Por favor, preencha este campo corretamente!" required>
                            <input type="hidden" name="id"  value="<?= @$cargo->id ?>">
                            <input type="reset" id="configreset" value="reset" hidden>
                        </div>

                        <div id="mensagemSucesso" class="alert alert-success alerta-sucesso" hidden>

                        </div>
                    </fieldset>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Fechar</button>
                    <input type="submit" id="salvar" value="Salvar" name="salvar" class="btn btn-primary">
                </div>
            </form>
</div>
        </div>
    </div>
</div> 

<table id="teste" name="teste" class="table table-striped" data-toggle="table" data-search="true" data-show-refresh="true" data-show-columns="true"
<thead>
                <tr>
                    <th class="th-small" data-align="left" data-sortable="true">ID</th>
                    <th data-align="left" data-sortable="true">Nome</th>
                    <th class="th-small">Ações</th>
                </tr>
            </thead>
            <tbody>
                <?php
                foreach ($cargo as $key => $v) {
                    ?>
                    <tr>
                        <td><?= $v->id ?></td>
                        <td><?= $v->titulo ?></td>

                        <td>
                            <div class="dropdown">
                                <button class="btn btn-default dropdown-toggle" type="submit" data-toggle="dropdown">... <span class="caret"></span></button>
                                <ul class="table-modal dropdown-menu">
                                    <li><a data-remote="Cargo/page/visualizar/<?= $v->id ?>" role="button" data-toggle="modal" data-target="#select-modal">Visualizar</a></li>
                                    <li><a data-remote="Cargo/page/alterar/<?= $v->id ?>" data-toggle="modal" data-target="#editarIdade">Editar</a></li>
                                </ul>
                            </div>  
                        </td>
                    </tr>
                <?php } ?>
            </tbody>        
        </table>
    
asked by anonymous 10.02.2016 / 14:55

1 answer

2

This refresh only works if the plugin is mounting the table - in your case, you are mounting the table with foreach .

You can have the plugin create the table for you using js, or using the data-url="dados-table.php" parameter. I usually use this option. Just create another file, play the query and return the records in json_encode . (AH, in that case you have to use the data-toggle="table" pro plugin attribute to understand that you have to mount that table for you - you can also initialize it via js if you prefer).

Your table in the html code is very simple, only with the ths (nothing of td):

<table id="table"
       class="table"
       data-toggle="table"
       data-url="sql/dados-table.php">
  <thead>
    <tr>
      <th data-field="nome-do-campo-aqui">
        Titulo do TH
      </th>
   </tr>
  </thead>
</table>

If you do this, the refresh will work exactly as it is in your code.

Here you can view refresh (and everything else the bootstrap-table provides).

Here has an example of what I've tried to explain.

ps In the example they use a .json file, I am using a .php returning me with json_encode and it works as well.

    
15.02.2017 / 20:34