Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Starting for <a href="https://stackoverflow.com/questions/8234107/remove-duplicate-trs-through-jquery/8234194#8234194">this answer</a> and using your table.</p> <pre><code>&lt;table cellpadding="0" cellspasing="0" class="sortable zebra tablesorter tablesorter-default" id="articles-table"&gt; &lt;thead&gt; &lt;tr class="tablesorter-headerRow"&gt; &lt;th data-column="0" class="tablesorter-header"&gt;&lt;div class="tablesorter-header-inner"&gt;Производитель&lt;i class="tablesorter-icon"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/th&gt; &lt;th data-column="1" class="tablesorter-header"&gt;&lt;div class="tablesorter-header-inner"&gt;Артикул&lt;i class="tablesorter-icon"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/th&gt; &lt;th data-column="2" class="tablesorter-header"&gt;&lt;div class="tablesorter-header-inner"&gt;Описание&lt;i class="tablesorter-icon"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/th&gt; &lt;th data-column="3" class="tablesorter-header"&gt;&lt;div class="tablesorter-header-inner"&gt;&lt;i class="tablesorter-icon"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/th&gt; &lt;th class="prcol tablesorter-header tablesorter-headerSortDown" data-column="4"&gt;&lt;div class="tablesorter-header-inner"&gt;Цена&lt;i class="tablesorter-icon"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/th&gt; &lt;th data-column="5" class="tablesorter-header"&gt;&lt;div class="tablesorter-header-inner"&gt;Наличие&lt;i class="tablesorter-icon"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/th&gt; &lt;th data-column="6" class="tablesorter-header"&gt;&lt;div class="tablesorter-header-inner"&gt;Сроки поставки&lt;i class="tablesorter-icon"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/th&gt; &lt;th data-column="7" class="tablesorter-header"&gt;&lt;div class="tablesorter-header-inner"&gt;&lt;i class="tablesorter-icon"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/th&gt; &lt;/tr&gt; &lt;/thead&gt; &lt;tbody class="analogs_art"&gt; &lt;tr class="zebra-stripe zebra-grey zebra2 even"&gt; &lt;td&gt; &lt;h5&gt; Knecht &lt;/h5&gt; &lt;/td&gt; &lt;td&gt; &lt;h4&gt; OC90 &lt;/h4&gt; &lt;/td&gt; &lt;td style="max-width: 300px;"&gt; (07786171)Фильтр масл OPEL (07786171)Фильтр масл OPEL &lt;/td&gt; &lt;td&gt; &lt;/td&gt; &lt;td&gt; 6124 &lt;/td&gt; &lt;td&gt; 20 &lt;/td&gt; &lt;td&gt; 0-1 &lt;/td&gt; &lt;td id="to_cart_and_qnt_td"&gt; &lt;form accept-charset="UTF-8" action="/line_items" method="post"&gt;&lt;div style="margin:0;padding:0;display:inline"&gt;&lt;input name="utf8" type="hidden" value="✓"&gt;&lt;input name="authenticity_token" type="hidden" value="0jlRLSkDKi6eM5SSL+3uRB0w2G141KUcJKuy4Bg2YNo="/&gt;&lt;/div&gt; &lt;input id="ART" name="ART" type="hidden" value="y1M1ZtdXgnMe6pOjjuXWPqhYR41SmQRKzlDOQ1uPwuru+AamPGpcOwOFFylbRDu5M1XUawCnukqNDQCuIr0JPA==--vNGx6/lYKRrpD5NGTJALcQ=="/&gt; &lt;input id="price" name="price" type="hidden" value="TodzvfOZCbK5T9+RLE1IQg==--qq8o30c5rTX91F8W42wdsQ=="/&gt; &lt;input id="distributor_id" name="distributor_id" type="hidden" value="6"/&gt; &lt;input id="waittime" name="waittime" type="hidden" value="1"/&gt; &lt;input class="qnt_to_cart2" id="OC90" name="cart_quantity" pattern="0|[1-9]\d{0,2}" required="required" type="text" value="1"/&gt; &lt;input class="orange-button to-cart_no" id="OC90" name="commit" type="submit" value="В корзину"/&gt; &lt;/form&gt; &lt;/td&gt; &lt;/tr&gt;&lt;tr class="zebra-stripe zebra-grey zebra2 odd"&gt; &lt;td&gt; &lt;h5&gt; KNECHT &lt;/h5&gt; &lt;/td&gt; &lt;td&gt; &lt;h4&gt; OC 90 &lt;/h4&gt; &lt;/td&gt; &lt;td style="max-width: 300px;"&gt; Масляный фильтр &lt;/td&gt; &lt;td&gt; &lt;a href="/articles/1248525/details" class="details-link"&gt;подробнее&lt;/a&gt; &lt;a href="/articles/1248525" class="analogs-link"&gt;аналоги&lt;/a&gt; &lt;/td&gt; &lt;td&gt; 6124 &lt;/td&gt; &lt;td&gt; 20 &lt;/td&gt; &lt;td&gt; 0-1 &lt;/td&gt; &lt;td id="to_cart_and_qnt_td"&gt; &lt;form accept-charset="UTF-8" action="/line_items" method="post"&gt;&lt;div style="margin:0;padding:0;display:inline"&gt;&lt;input name="utf8" type="hidden" value="✓"&gt;&lt;input name="authenticity_token" type="hidden" value="0jlRLSkDKi6eM5SSL+3uRB0w2G141KUcJKuy4Bg2YNo="&gt;&lt;/div&gt; &lt;input id="ART" name="ART" type="hidden" value="9x6mdLbW2aMaHqFK32kZwHWnWA7n0GBp/jXS8KeECsTS+78ytG0SQzFpVODplws5iHm6B6SkZzi3ej2+zpW8iQ==--RNoUUgcZu7MLU8BHJ4ynSQ=="&gt; &lt;input id="price" name="price" type="hidden" value="VqatEYzkPEf3P9Y/jNY9Zg==--Iw5nQDqjK9vvZX/RecD1eA=="&gt; &lt;input id="distributor_id" name="distributor_id" type="hidden" value="6"&gt; &lt;input id="waittime" name="waittime" type="hidden" value="1"&gt; &lt;input class="qnt_to_cart" id="cart_quantity" name="cart_quantity" pattern="0|[1-9]\d{0,2}" required="required" type="text" value="1"&gt; &lt;input class="orange-button to-cart" name="commit" type="submit" value="В корзину"&gt; &lt;/form&gt; &lt;/td&gt; &lt;/tr&gt;&lt;tr class="zebra-stripe zebra-grey zebra1 even"&gt; &lt;td&gt; &lt;h5&gt; Knecht &lt;/h5&gt; &lt;/td&gt; &lt;td&gt; &lt;h4&gt; OC90 &lt;/h4&gt; &lt;/td&gt; &lt;td style="max-width: 300px;"&gt; Фильтр масляный OPEL/GM/DAEWOO Фильтр масляный OPEL/GM/DAEWOO &lt;/td&gt; &lt;td&gt; &lt;/td&gt; &lt;td&gt; 6142 &lt;/td&gt; &lt;td&gt; 1000 &lt;/td&gt; &lt;td&gt; 3 &lt;/td&gt; &lt;td id="to_cart_and_qnt_td"&gt; &lt;form accept-charset="UTF-8" action="/line_items" method="post"&gt;&lt;div style="margin:0;padding:0;display:inline"&gt;&lt;input name="utf8" type="hidden" value="✓"&gt;&lt;input name="authenticity_token" type="hidden" value="0jlRLSkDKi6eM5SSL+3uRB0w2G141KUcJKuy4Bg2YNo="&gt;&lt;/div&gt; &lt;input id="ART" name="ART" type="hidden" value="NqgWSvcdv0FEQkjcJZp98gIYe20Fjol8Bn31tB/CjWnTFVsa3J3hmldO1RSqS/pNUcVZ5dh0wcP7YeZxPAkQc4DEPKy7EVuTpMw3oQw58T0=--/XCn0hP3w0mglJ1vTXSjHw=="&gt; &lt;input id="price" name="price" type="hidden" value="mFPLSHh7AdEMpQJiZHFKNg==--hfJQGWhjBoD6mNAetXZ3Xw=="&gt; &lt;input id="distributor_id" name="distributor_id" type="hidden" value="6"&gt; &lt;input id="waittime" name="waittime" type="hidden" value="3"&gt; &lt;input class="qnt_to_cart2" id="OC90" name="cart_quantity" pattern="0|[1-9]\d{0,2}" required="required" type="text" value="1"&gt; &lt;input class="orange-button to-cart_no" id="OC90" name="commit" type="submit" value="В корзину"&gt; &lt;/form&gt; &lt;/td&gt; &lt;/tr&gt;&lt;/tbody&gt; &lt;/table&gt; </code></pre> <p>And the jQuery code is</p> <pre><code>var seen = {}; $('table tr').each(function() { var tr = $(this).clone(); if(tr.not(':input')){ if(tr.not('a.details-link')){ tr.find("td:eq(7)").remove(); tr.find("td:eq(3)").remove(); // tr.find("td:eq(2)").remove(); var txt = tr.text().toLowerCase().replace(/\s+/g, '');; if (seen[txt]) $(this).remove(); else seen[txt] = true; } } }); </code></pre> <p>An functional example is <a href="http://jsfiddle.net/jefferson/VD32d/" rel="nofollow noreferrer">here</a></p>
    singulars
    1. This table or related slice is empty.
    1. POJquery delete almost same table rows
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USJeff
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COhm.... to complicated for my table: https://dl.dropbox.com/u/59666091/table.png i need that this two Knecht oc90 gave only one row, becouse first and second columns are same third could be different, and delete not such, where i have buttons (fourth td), also other are same (pricem quantity....) my table: http://jsfiddle.net/zvKSc/ ...Just delete if first second, and columns with price are same, but delete such, where i didn't have buttons...
      singulars
      1. PO
      1. USbrabertaser19
    2. COdoes 5th and 6th the other columns with values?, and if the row has buttons don't delete the row?
      singulars
      1. PO
      1. USJeff
    3. COyes, 6,7,8,9 colums are with values, and if the rows are same than delete duplicate, but leave that, which in 4-th column has buttons.... as in image
      singulars
      1. PO
      1. USbrabertaser19
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload