(public).sospep.events ~ view task ~ FEATURE-3670-010

<h1 style="text-align: center;">FEATURE-3670-010 - PAGINATION Search results</h1>
<h2>[previously]</h2>
<ol>
<li>[reference] <a href="/view/task?id=3670" target="_blank">FEATURE-3670</a></li>
<ol>
<li>x] overview and description</li>
</ol>
<li>[2015-08-14] NEW task</li>
<ol>
<li>] find byName -</li>
<li>] ADD -</li>
<li>]&nbsp;PRB - not getting pagination links to&nbsp;display&nbsp;</li>
</ol>
<li>[2015-08-17] NEW task</li>
<ol>
<li>x] MOVE - call to Articles.RecordCount INTO qry code block</li>
</ol>
<li>[00:00] NEW task</li>
<ol>
<li>i] #&nbsp;5490 - -010-PAGINATION-SEARCH-PAGES - Ariticles search, test use SQL_CALC_ROWS vs qry*2</li>
</ol>
<li>[00:00] NEW task</li>
<ol>
<li>i] #&nbsp;5490 - -010-PAGINATION-SEARCH-PAGES - Ariticles search, test use SQL_CALC_ROWS vs qry*2</li>
</ol><ol>
<li>x] ADD NEW - recordCount(string qry) method, takes string(qry) as arg</li>
<li>x] EDIT - recordCount(string qry, string param)&nbsp; - add param as well, concat in page doesnt work</li>
<li>&gt; x] MOVE - pagination code block(calculate pages)&nbsp;into qry code block</li>
<li>*] PRB - now getting all records</li>
<li>x] ADD NEW - qry2 is get count of records&nbsp;in query NOT get records in query</li>
<li>x] MODIFY - orig. "calculate pages" pagination block, init vars to 0</li>
<li>x]&nbsp;MOVE "calculate pages" code block&nbsp;(same block) into seperate blocks for ] getArticlesInChapter and ] getArticlesByQry</li>
<li>x] PRB - not getting pagination links to display</li>
<li>x] MODIFY CS recordCount() - prefix and append wildard character("%") to the parameter</li>
<li>x] PRB - link is non functional, uses parent_id which is 0</li>
<li>] MODIFY -&nbsp;code block, given arg = 'start page', alter qry LIMIT clause&nbsp;</li>
<li>x] MODIFY - pagination link to use orig link + append startPage param, this calculates start record value</li>
<li>x] PRB works for query records NOT for regular records</li>
<li>] NEW sospepHelper - generatePageLinks(qry,parent_id) -method to generate either/or</li>
</ol>
<li>[2015-08-18] NEW task</li>
<ol>
<li>x] push .org - x] article, x] view/articles, x] sospepHelper</li>
</ol>
<li>[00:00] NEW task</li>
<ol>
<li>] # # - find description .... || find items</li>
</ol>
<li>&gt; [00:00] NEW task - ] find description </li>
<ol>
<li>i] #&nbsp;5490 - -010-PAGINATION-SEARCH-PAGES - Ariticles search, test use SQL_CALC_ROWS vs qry*2</li>
<li>] # # - TRY using sql_calc_rows method,</li>
<li>] RESULT = WORKS but somewhat inconsistent in results,</li>
<li>] maybe its my implementation? ALSO for example test qry="interview" get 220 results (11 pages) then click on page 5 and now i only have 2 pages results</li>
</ol>
<li>[2015-08-19][00:00] NEW task </li>
<ol>
<li>x] push to production with FIX-PRB-5498 - not ready</li>
<li>x] PAGE links on view/article by browse(parent_id) are showing with</li>
</ol>
<li>[00:00] NEW task IN</li>
<ol>
<li>x] sospepHelper function - ] ADD 2nd condition to test qry if ( qry=qry and parent_id=0 )</li>
</ol>
<li>[00:00] NEW task - findBy Content - REVERT 2* query method, count(total_records) and results(qry, limit)</li>
<ol>
<li>x] CS&nbsp;- ADD NEW qstring for count records</li>
<li>x]&nbsp;CS verify method has wildcard param append/prepend to param, verify param is upper</li>
<li>x] PG findByContent - case statement - includes ...]</li>
<li>**</li>
<li>x] TEST.local qry(result)= vancouver(54), interview(272), javascript(218), asp.net(45), asp.net MVC(22), don sagrott(22)&nbsp;</li>
<li>x] PUSH .com</li>
<li>x] TEST.remote = &nbsp;PASS</li>
<li>x] PUSH .org</li>
<li>*] qry - blackberry z30(11) &lt;&gt; blackberry(299)</li>
</ol>
<li>[2015-08-19][00:00] NEW task - findBy - Library</li>
<ol>
<li>x] CS&nbsp;- ADD NEW qstring for count records</li>
<li>x]&nbsp;CS - NEW METHOD recordCount( string qry, int param parent_id)</li>
<li>x] PG findByLibrary - case statement - includes ... ] getArticles args (startRecord, qty), ] calculate totalRecords, totalPages</li>
<li>x] TEST.local qry(result)= ] test_book(84), ]</li>
</ol>
<li>[00:00] NEW task - findBy - Book<ol>
<li>x] CS&nbsp;- ADD NEW qstring for count records</li>
<li>x] PG findBy Book - case statement - includes ... ] getArticles args (startRecord, qty), ] calculate totalRecords, totalPages</li>
<li>x] TEST ] book git(21), book javascript(172)</li>
</ol></li>
<li>[00:00] NEW task - findBy - Chapter]</li>
<ol>
<li>*] CS - no new qry, orig recordCount method which takers parent_id, returns count</li>
<li>x] PG - findByChapter - use sospepFunction.totalPages()</li>
<li>] TEST book.git ch=#(#), book=javascript, ch=2-learning (9), book=test, ch=001 (37)</li>
</ol>
<li>[00:00] NEW task </li>
<ol>
<li>x] # # - NEW method - sospepFunction.totalPages(int totalRecords, resultsPerPage)</li>
<li>x] test on findBy Book</li>
<li>x] findBy Book, findByChapter</li>
</ol>
<li>[00:00] NEW task - findBy - status]</li>
<ol>
<li>x] CS - add qry</li>
<li>x] EDIT - recordCount(string qry, string param) - was adding wildcard in method, dont want appended wildcards here, will have to go back to adding on calling page</li>
<li>x] USE&nbsp;sospepFunction.totalPages()</li>
<li>x] TEST writing(37), written(447), write(lots)</li>
</ol>
<li>[00:00] NEW task - findBy - created]</li>
<ol>
<li>x] CS - add qry</li>
<li>x] USE&nbsp;sospepFunction.totalPages()</li>
</ol>
<li>[00:00] NEW task - findBy - owner]</li>
<ol>
<li>x] CS - add qry</li>
<li>x] USE&nbsp;sospepFunction.totalPages()</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li>]</li>
</ol>
<h2>[next]</h2>
<ol>
<li>[00:00] NEW task - findBy - index]</li>
<ol>
<li>]</li>
</ol>
<li>[REFERENCE]</li>
<ol>
<li>] TRY&nbsp;mysql <a href="http://www.arraystudio.com/as-workshop/mysql-get-total-number-of-rows-when-using-limit.html" target="_blank">Get total number of rows when using LIMIT</a> - use SQL_CALC_FOUND_ROWS</li>
<li>]&nbsp;<a href="http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#id2890708" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#id2890708</a>&nbsp;</li>
<li>] &nbsp;count (*) VS count(id_article) - <a href="https://www.percona.com/blog/2007/04/10/count-vs-countcol/">https://www.percona.com/blog/2007/04/10/count-vs-countcol/</a></li>
</ol></ol>

~ view task ~ TaskGroup] FEATURE-3670 FROM [ Plan] plan-projects IN [ calendars] prj-022-sospep