Answers

• wannberg Posts: 11Questions: 3Answers: 0

  September 2014 edited September 2014

  Not sure if this is the best way to do it, but I was able to edit the PHP file to sort the entries based on date and the timestamp, then create the balance object in the array.
  So then after an edit/create/delete I just reload the table.

  php file:

     ->process( $_POST )
      ->data();
  
  if ( !isset($_POST['action']) ) {
  
      $out['data'] = array_orderby($out['data'], 'transactionDate', SORT_ASC, 'dateCreated', SORT_ASC);
      $balance = 0;
      for ( $i=0, $ien=count($out['data']) ; $i<$ien ; $i++ ) {
          $balance = $balance + $out['data'][$i]['income'] - $out['data'][$i]['expense'];
          $out['data'][$i]['balance'] = $balance;
      }
  
  }else{
      $out['row']['balance']=null;
  }
  
  
  echo json_encode($out);
  
  //Sort data for proper output
  function array_orderby()
  {
      $args = func_get_args();
      $data = array_shift($args);
      foreach ($args as $n => $field) {
          if (is_string($field)) {
              $tmp = array();
              foreach ($data as $key => $row)
                  $tmp[$key] = $row[$field];
              $args[$n] = $tmp;
          }
      }
      $args[] = &$data;
      call_user_func_array('array_multisort', $args);
      return array_pop($args);
  }
  

  js file:

      editor.on('edit create remove', function(){
          accounting.ajax.reload();
          });
  
• nigel pasco Posts: 37Questions: 6Answers: 0

  September 2014

  It can be done with a function when defining the columns:data, like this:

  $('#tablename).DataTable( {
  (...blah, blah, blah...)
  "columns": [
  { "data": "income" },
  { "data": "expense"},
  { "data": null, render: function ( data, type, row ) {
  // Sum the income and expense to give total
  return '<a href="">$'+data.income+data.expense+'</a>';
  } },
  ]
  }];

  I hope that helps.
  nige
• wannberg Posts: 11Questions: 3Answers: 0

  September 2014

  Thanks I will try that.
• allan Posts: 63,552Questions: 1Answers: 10,477 Site admin

  September 2014

  If you are using client-side processing then the method shown in the footer callback example is probably the best way to do it.

  Alternatively (and required if you are using server-side processing) you could, as you suggest, add the sum information into the JSON data returned by the PHP script and use the submitComplete event to update the footer. You would probably also need to use initComplete to perform the same action on initial load.

  Allan