Answers

• allan Posts: 63,523Questions: 1Answers: 10,473 Site admin

  August 2016

  Thanks for your question - however, per the forum rules can you link to a test case showing the issue please. This will allow the issue to be debugged.

  Information on how to create a test page, if you can't provide a link to your own page can be found here.

  Thanks,
  Allan
• Jini Posts: 4Questions: 1Answers: 0

  August 2016 edited August 2016

  Thank you for your quick reply and your answer.

  And due to lack of experience with data table, I didn't acknowledge that there are rules of these. I apologize for that.

  ​As I found on the link page that you gave me, there were some ways to link for checking the source file including using JS Fiddle so I tried the methods,

  but couldn't manage to make it because I am not aware of the methods for these.

  I am truely sorry but if this problem could be solved by writing the URL of the source file, I hope this will work.

  Source URL -> http://jnpetrol.posissuer.com/csx/pages_account_spending_list_joy.php

  ​The problem that I have is that, like it is written above, in the process of linking the two databases, Row.add part is not working properly.

  One table shows the list of the information on the product sale, and the other table shows calculatioin and collection of the payment methods on the information of list table.

  When showing the first screen, the problem doesn't appear, but when filtering the information on the list table, after row.remove, row.add method doesn't work.

  //var mTable = $('#account_spending').DataTable() -> counting table
  //var nn = $('#account_spending_list').DataTable() -> sales infomation list table

  nn.on( 'draw', function () {

  mTable.rows().remove();
  .
  .
  .
  var anNodes = $("#account_spending_list tbody tr");

  for (var i = 0; i < anNodes.length; ++i) { ... }

  //Counting...

  mTable.row.add( {
  "AMT_DATE" : amtDt,
  "TOTAL" : priceAll,
  "CASH" : cashStr,
  "CARD" : cardStr,
  "CREDIT" : leftStr,
  "BANK_TRAN" : bankStr,
  "CANCEL" : payCancel,
  "FINISH_CD" : FINISH_CD
  } ).draw();

  ==================================================​

  ​I am sorry that I couldn't ask you by the rules you have.

  But I really I want to solve this problem in short time. Please help me and I really appriciate your help. Thank you.
• allan Posts: 63,523Questions: 1Answers: 10,473 Site admin

  August 2016

  A link to the page showing the issue is all that is needed!

  Can you also give me details on what I need to do to trigger the error please?

  Allan
• Jini Posts: 4Questions: 1Answers: 0

  August 2016

  I thought it would be helpful for you if I revise the screen contents.

  There are two tables like I explained previously.

  The below table (Payment Information) is the one showing the history of purchase and payment methods of the purchased product,
  and the upper table(Counting table) is the one showing the result of calculation and collection of the contents on the below table(Payment Information), by categories of payment methods and payment status(complete, ready, cancel etc.) .

  So contents of both tables should be matched by calculation.

  My problem doesn't show up when operating the screen for the first time.
  But when I filter the below table(Payment Information), the contents of the upper table(Counting Table) don't show up.

  For example, there are 5 contents of the history of purchase, date of 2nd August,
  In this list, there are two history of purchase by cash. (3,5000,000: Cancel & 50,000:Complete)

  When I search the Cash list of below table, the printed contents of below table should be on screen on the upper table, Cash payment category and Cancel payments. But they don't .

  So it made me think that Row.add method doesn't work.

  Thank you for your help.
• allan Posts: 63,523Questions: 1Answers: 10,473 Site admin

  August 2016 Answer ✓

  The row.add() call is working, but there is a custom filter which is being applied to the table and that is causing the row to be filtered out:

  $.fn.dataTable.ext.search.push(
    
      function( settings, data, dataIndex ) {
  
      var min = $('#minDate').val();
      var max = $('#maxDate').val();
    
      if ( min == "" && max == "" ) return true;
  
          var rowDate = data[2].split(" ")[0]; // use data for the age column
   
      //alert(min+" |  "+max+" | "+rowDate );
      
      if ( min <= rowDate && rowDate <= max ) return true;
      else return false;
   /*
          if ( ( isNaN( min ) && isNaN( max ) ) ||
               ( isNaN( min ) && rowDate <= max ) ||
               ( min <= rowDate   && isNaN( max ) ) ||
               ( min <= rowDate   && rowDate <= max ) )
          {
              return true;
          }
          return false;
          */
      }
  );
  
  } );
  

  The date information for the first table is in data[0] not data[2], hence it isn't working correctly on that table.

  You probably need to add a check into your filtering function to make it operate only on the second table:

  if ( settings.nTable.id !== 'account_spending_list' ) {
    return true;
  }
  

  Allan
• Jini Posts: 4Questions: 1Answers: 0

  August 2016

  Thank you. Because of your help I could solve the problem and get better understanding of source.

  I really appriciate your help.