Advertisement
Guest User

Untitled

a guest
Oct 21st, 2016
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.84 KB | None | 0 0
  1. <table id="dataTable">
  2. <tr>
  3. <th>Functional Category</th>
  4. <th>Brand Name</th>
  5. <th>When Obtained</th>
  6. <th>How Obtained</th>
  7. <th>How Often Worn</th>
  8. <th>Where Made</th>
  9. <th>Has a Graphic</th>
  10. </tr>
  11. <tr>
  12. <td>T-Shirt</td>
  13. <td>threadless</td>
  14. <td>Last 3 Months</td>
  15. <td>Purchased</td>
  16. <td>Monthly</td>
  17. <td>India</td>
  18. <td>Yes</td>
  19. </tr>
  20. <tr>
  21. <td>T-Shirt</td>
  22. <td>RVCA</td>
  23. <td>2 Years Ago</td>
  24. <td>Purchased</td>
  25. <td>Bi-Monthly</td>
  26. <td>Mexico</td>
  27. <td>Yes</td>
  28. </tr>
  29. </table>
  30.  
  31. var tableData = [
  32. {
  33. category: "T-shirt",
  34. brandName: "threadless",
  35. whenObtained: "Last 3 Months",
  36. howObtained: "Purchased",
  37. howOftenWorn: "Monthly",
  38. whereMade: "India",
  39. hasGraphic: "Yes"
  40. },
  41. {
  42. category: "T-shirt",
  43. brandName: "RVCA",
  44. whenObtained: "2 Years Ago",
  45. howObtained: "Purchased",
  46. howOftenWorn: "Bi-Monthly",
  47. whereMade: "Mexico",
  48. hasGraphic: "Yes"
  49. }
  50. ]
  51.  
  52. var array = [];
  53. var headers = [];
  54. $('#dataTable th').each(function(index, item) {
  55. headers[index] = $(item).html();
  56. });
  57. $('#dataTable tr').has('td').each(function() {
  58. var arrayItem = {};
  59. $('td', $(this)).each(function(index, item) {
  60. arrayItem[headers[index]] = $(item).html();
  61. });
  62. array.push(arrayItem);
  63. });
  64.  
  65. var table = document.getElementById( "dataTable" );
  66. var tableArr = [];
  67. for ( var i = 1; i < table.rows.length; i++ ) {
  68. tableArr.push({
  69. category: table.rows[i].cells[0].innerHTML,
  70. brandName: table.rows[i].cells[1].innerHTML,
  71. whenObtained: table.rows[i].cells[2].innerHTML,
  72. howObtained: table.rows[i].cells[3].innerHTML,
  73. howOftenWorn: table.rows[i].cells[4].innerHTML,
  74. whereMade: table.rows[i].cells[5].innerHTML,
  75. hasGraphic: table.rows[i].cells[6].innerHTML
  76. });
  77. }
  78.  
  79. var i, items, item, dataItem, data = [];
  80. var cols = [ "category", "brandName", "whenObtained", "howObtained", "howOftenWorn",
  81. "whereMade", "hasGraphic" ];
  82.  
  83. $("#dataTable tr").each(function() {
  84. items = $(this).children('td');
  85.  
  86. if(items.length === 0) { // return if this tr only contains th
  87. return;
  88. }
  89.  
  90. dataItem = {};
  91. for(i = 0; i < cols.length; i+=1) {
  92. item = items.eq(i);
  93. if(item) {
  94. dataItem[cols[i]] = item.html();
  95. }
  96. }
  97. data.push(dataItem);
  98. });
  99.  
  100. $(function() {
  101. var $rows= $("#tableName tbody tr");
  102. var data = [];
  103.  
  104. $rows.each(function(row, v) {
  105. $(this).find("td").each(function(cell, v) {
  106. if (typeof data[cell] === 'undefined') {
  107. data[cell] = [];
  108. }
  109. data[cell][row] = $(this).text();
  110. });
  111. });
  112.  
  113. console.log(data);
  114. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement