Answers

• allan Posts: 63,258Questions: 1Answers: 10,421 Site admin

  November 2015

  Could you link to the page showing the issue so we can see what is happening please.

  Allan
• GeorgeGeorgiev Posts: 2Questions: 1Answers: 1

  November 2015 Answer ✓

  Hi, Allan,

  i have made it to work ... It was my error to use older php. I will share what was my solution:

  First the initialization code:

     var table = $('#dattab').DataTable({
              rowReorder: {
                  selector: 'tr',
                  //   update: true,
                  //   dataSrc: '.ord-id'
              },
              dom: 'Bfrtip',
              buttons: [
                  'copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5'
              ]
          });
  

  Second i was needed to attach event on which to send the ajax request i have try with the reorder but it not helped me for some reason it was sending one redraw old on the table so i use the draw event and it sends the ajax when the table is redrawn:

   $('#dattab').on('draw.dt', function () {
              if ($('#dattab').data('tabs')) {
                  var rows = table.rows().data();
                  var ord = new Array();
                  for (var i = 0, ien = rows.length; i < ien; i++) {
                      ord[i] = rows[i].DT_RowId;
                  }
                  post_order(ord, $('#dattab').data('tabs'));
              }
          });
  

  Third i need a php script to handle the reorder:

  if( $_POST['elem'] && $_POST['table']) {
      $i = 1;
      $error = 0;
      foreach ($_POST['elem'] as $row) {
          $q = "UPDATE " . "fit_" . $_POST["table"] . " set
              `order` = ".$i.  "
              ,updated_at = Now()
              WHERE id = " . GetSQLValueString($row, "int");
  
          $res = $mysqli->query($q);
          $i++;
          if(!$res)
          {
              $error++;
          }
  
      }
      if(!$error)
      {
          echo 'success';
      }
      else{
          echo 'error';
      }
  

  What do you think?
• allan Posts: 63,258Questions: 1Answers: 10,421 Site admin

  November 2015

  Looks good - thanks for sharing your solution with us.

  Allan