edit-task
Home
Up
Delete
Task Name:
Task Description:
PAGINATION - on SEARCH page -
TaskGroup ID:
Start Date:
Start Time:
Duration:
Priority:
Status:
To Do
Completed
In Process
Add Photo:
Owner ID:
Content:
use HTML
Edit Content
<h1 style="text-align: center;">FEATURE-3670-010 - PAGINATION Search results</h1> <h2>[previously]</h2> <ol> <li><strong>[reference] </strong><a href="/view/task?id=3670" target="_blank"><strong>FEATURE-3670</strong></a></li> <ol> <li>x] overview and description</li> </ol> <li><strong>[2015-08-14] NEW task</strong></li> <ol> <li><strong>] find byName -</strong></li> <li>] ADD -</li> <li>] PRB - not getting pagination links to display </li> </ol> <li><strong>[2015-08-17] NEW task</strong></li> <ol> <li>x] MOVE - call to Articles.RecordCount INTO qry code block</li> </ol> <li><strong>[00:00] NEW task</strong></li> <ol> <li>i] # 5490 - -010-PAGINATION-SEARCH-PAGES - Ariticles search, test use SQL_CALC_ROWS vs qry*2</li> </ol> <li><strong>[00:00] NEW task</strong></li> <ol> <li>i] # 5490 - -010-PAGINATION-SEARCH-PAGES - Ariticles search, test use SQL_CALC_ROWS vs qry*2</li> </ol><ol> <li><span style="background-color: #c0c0c0;"><strong>x] ADD NEW</strong> - recordCount(string qry) method, takes string(qry) as arg</span></li> <li>x] EDIT - recordCount(string qry, string param) - add param as well, concat in page doesnt work</li> <li><span style="background-color: #c0c0c0;">> x] MOVE - pagination code block(calculate pages) into qry code block</span></li> <li><strong>*] PRB - now getting all records</strong></li> <li><strong>x] ADD NEW</strong> - qry2 is get count of records in query NOT get records in query</li> <li>x] MODIFY - orig. "calculate pages" pagination block, init vars to 0</li> <li>x] MOVE "calculate pages" code block (same block) into seperate blocks for ] getArticlesInChapter and ] getArticlesByQry</li> <li><strong>x] PRB - not getting pagination links to display</strong></li> <li><span style="background-color: #c0c0c0;">x] MODIFY CS recordCount() - prefix</span> and append wildard character("%") to the parameter</li> <li><strong>x] PRB - link is non functional, uses parent_id which is 0</strong></li> <li>] MODIFY - code block, given arg = 'start page', alter qry LIMIT clause </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><strong>[2015-08-18] NEW task</strong></li> <ol> <li>x] push .org - x] article, x] view/articles, x] sospepHelper</li> </ol> <li><strong>[00:00] NEW task</strong></li> <ol> <li>] # # - find description .... || find items</li> </ol> <li><strong>> [00:00] NEW task - ] find description </strong></li> <ol> <li>i] # 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><strong>[2015-08-19][00:00] NEW task </strong></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><strong>[00:00] NEW task IN</strong></li> <ol> <li>x] sospepHelper function - ] ADD 2nd condition to test qry if ( qry=qry and parent_id=0 )</li> </ol> <li><strong>[00:00] NEW task - findBy Content - REVERT 2* query method, count(total_records) and results(qry, limit)</strong></li> <ol> <li>x] CS - ADD NEW qstring for count records</li> <li>x] 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) </li> <li>x] PUSH .com</li> <li>x] TEST.remote = PASS</li> <li>x] PUSH .org</li> <li>*] qry - blackberry z30(11) <> blackberry(299)</li> </ol> <li><strong>[2015-08-19][00:00] NEW task - findBy - Library</strong></li> <ol> <li>x] CS - ADD NEW qstring for count records</li> <li>x] 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><strong>[00:00] NEW task - findBy - Book</strong><ol> <li>x] CS - 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><strong>[00:00] NEW task - findBy - Chapter]</strong></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><strong>[00:00] NEW task </strong></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><strong>[00:00] NEW task - findBy - status]</strong></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 sospepFunction.totalPages()</li> <li>x] TEST writing(37), written(447), write(lots)</li> </ol> <li><strong>[00:00] NEW task - findBy - created]</strong></li> <ol> <li>x] CS - add qry</li> <li>x] USE sospepFunction.totalPages()</li> </ol> <li><strong>[00:00] NEW task - findBy - owner]</strong></li> <ol> <li>x] CS - add qry</li> <li>x] USE sospepFunction.totalPages()</li> </ol></ol> <h2>[currently]</h2> <ol> <li>]</li> </ol> <h2>[next]</h2> <ol> <li><strong>[00:00] NEW task - findBy - index]</strong></li> <ol> <li>]</li> </ol> <li><strong>[REFERENCE]</strong></li> <ol> <li>] TRY 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>] <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> </li> <li>] 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>