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

<h1 style="text-align: center;">FEATURE# 3670&nbsp;- Pagination</h1>
<h2>[what]</h2>
<ol style="font-size: 10px; font-weight: normal;">
<li>]&nbsp;PAGINATION - return query results for records in pages (batches of (x)) results VS all results for a given query, &nbsp;</li>
<ol>
<li>] where x = a 'user configurable'&nbsp;parameter OR a pre-configured options(10,20,50) OR&nbsp;?</li>
</ol></ol>
<h2>[why]</h2>
<ol style="font-size: 10px; font-weight: normal;">
<li>] avoid long lists of results, ( too much scrolling, easier to print if ... )</li>
<ol>
<li>*] PRB if no limit is (potentially) "long lists",</li>
<li>*] WAS&nbsp; getting errors on long lists, *] ERROR = - too many connections</li>
</ol></ol>
<h2>[where]</h2>
<ol style="font-size: 10px; font-weight: normal;">
<li>] for L4 pages</li>
<ol>
<li>] ? = L4, L3, L2, L1</li>
</ol>
<li>] * normally NOT&nbsp;a problem</li>
<ol>
<li>as most content is in smaller/ish containers</li>
</ol>
<li>]</li>
</ol>
<h2>[when]</h2>
<ol style="font-size: 10px; font-weight: normal;">
<li>] ETA - 2014-03</li>
<ol>
<li>]</li>
</ol></ol>
<h2>[example]</h2>
<ol style="font-size: 10px; font-weight: normal;">
<li>]&nbsp;<a href="/view/libraries" target="_blank">http://sospep.com/view/libraries</a></li>
<ol>
<li>] this use case prj-DOC-pages - some have over 50 records</li>
</ol></ol>
<h2>[how-to]</h2>
<ol style="font-size: 10px; font-weight: normal;">
<li>[00:30] NEW task IN] #&nbsp;3670 - FEATURE pagination ON view/calendars</li>
<ol>
<li>x] PG - add var (] startPage ] startRecord, ] listStart)</li>
<li>x] PG - add method block PAGINATION&nbsp;(# desc=totalPages = totalRecords/recordsPerPage&nbsp;)</li>
<li>x] PG - add display links code below list</li>
<li>x] PG class= pagination for displayPaginationLinks codeblock</li>
<li>x] PG - MODIFY calls(1) to GetAtlases() to include arguments(startRecord, count), in code&nbsp;block#</li>
<li>x] CS -&nbsp;add recordCount method</li>
<li>x] CS - ADD NEW&nbsp;method GetCommunites() with&nbsp;2 args ( start, qty)</li>
<li>x] CS -&nbsp;UPDATE query getCommunities, replace LIMIT with var placeholders for start and quantity</li>
<li>] TEST =&nbsp;PASS || FAIL</li>
<li>? ] add start param to &lt;ol&gt; tag start="@listStart" // some pages use UL, change to OL tags</li>
<li>x] CS - modify Calls(3) to GetPersonsInMemberGroup(int parent_id) by manually adding vars&nbsp;&nbsp;(0,50)</li>
</ol>
<li>FEATURE PAGINATION on find/Articles</li>
<ol>
<li>] CS - add qry</li>
<li>] PG - post code block, swith case </li>
<li>] </li>
</ol></ol>
<h2>[reference]</h2>
<ol style="font-size: 10px; font-weight: normal;">
<li>]</li>
</ol><hr style="font-size: 10px; font-weight: normal;" />
<h1 style="text-align: center;">developer implementation</h1>
<h2>[-process-]</h2>
<ol style="font-size: 10px; font-weight: normal;">
<li>[2015-mm-dd] # PAGE - view/libraries</li>
<ol>
<li>x] starting here versus l5, wont likely use it here now BUT less clutter and easier to work with (lighter) page</li>
<li>*] to start we will only likely&nbsp;paginate L4 views</li>
</ol>
<li>[2015-mm-dd] # PAGE - AppStart</li>
<ol>
<li>x] ADDed var -&nbsp;numberRecords = 20;</li>
<li>// this is used to set the amount of records to return,</li>
<li>// we&nbsp;intend to&nbsp;make this is a user defineable setting (10,20,50)</li>
</ol>
<li>[2015-mm-dd] # PAGE - CS.Library - "query"&nbsp;for records has a LIMIT clause, CHANGE LIMIT to var</li>
<ol>
<li>*] limit clause restricts the results to the specified number, (CURRENLTY hardcoded @50 on SOME./ queries )</li>
<li>// with no limit specified we have run into "ERROR too many connections"</li>
</ol>
<li>[00:00] CS Library method -&nbsp;getLibraries(int limit)</li>
<ol>
<li>x] ADDed - arguement to method to return number of results, WHERE arg is the number of results to return, LIMIT is now specified as a parameter VS hardcoded into the qry variable&nbsp;</li>
</ol>
<li>[00:00] # PAGE .CS Library method -&nbsp;getLibraries()&nbsp;</li>
<ol>
<li>] ADDed - 2nd parameter to LIMIT clause, (start record#, # records)</li>
<li>] first parameter is start returning records startin g&nbsp;@ row#,</li>
<li>] 2nd parameter is the amount of records to be returned</li>
</ol>
<li>[00:00] JS - client side js - pageNumber click&nbsp;</li>
<ol>
<li>] to generate a link to the pages</li>
</ol>
<li>[00:00] build NAVIGATIONAL&nbsp;links in server side code VERSUS IN client side script /view/articles&nbsp;- pageNumber click()</li>
<ol>
<li>*] VS EX&nbsp;view/jobs - where links are dynamically generated in client side js function, pageNumer click()</li>
<li>] PageNumber displayed starting with 1 &nbsp;VS ( x=0, x &lt; )</li>
</ol>
<li>[00:00] link will use qstring value to pass (desired page#) back into query page</li>
<ol>
<li>] EX view/libraries?startpage=3</li>
<li>x] calculate startRecord = BY&nbsp;startpage * recordsPerPage</li>
</ol>
<li>[00:00] FORMAT display of links on PAGE</li>
<ol>
<li>] make pretty ier&nbsp;links - cc table in objects/specifiications -</li>
<li>x] use display inline to show links horizontally across screen VS vertically listing them</li>
</ol>
<li>[00:00] PAGE - view/articles - PORT FUNCTIONALITY from PAGE view/libraries to PAGE view/articles?id=#</li>
<ol>
<li>] multipe entry points into 'articles' page VS single on</li>
<li>x] articlesInChapter?id=#</li>
<li>x] getting count - b/c it is subset of records in table, not the whole table, we essentially are running the query twice</li>
</ol>
<li>[00:00] PAGE - view/articles - LIST records, numbering </li>
<ol>
<li>*] PRB list displays each new page of records starting with the number 1</li>
<li>x] add var for listStart, startRecord+1,</li>
<li>x] ADD start attr to ol displaying records</li>
<li>x] assign listart to start attrbute</li>
</ol></ol>
<h2>[-notes-]</h2>
<ol style="font-size: 10px; font-weight: normal;">
<li>*] have implemented pagination on PAGE view/jobs</li>
<ol>
<li>]&nbsp;initial json object with first set of results, contains the total# of records</li>
</ol>
<li>*] have js function that dynamically builds links</li>
<ol>
<li>*] uses id of clicked link to calculate 'start' and 'end' pages, then generates URL, switches/sets page to that url</li>
<li>] PRB ?? IMPROVEMENT - i am ALREADY building 'the&nbsp;links' in the&nbsp;original svr side page gen/build, Y NOT JUST build the links completely&nbsp;there</li>
</ol>
<li>x] startPage</li>
<ol>
<li>x] added qstring parameter</li>
<li>x] PAGE view/libraries CATCH startPage</li>
<li>] PASS startpage into query</li>
</ol>
<li>x]&nbsp;CS - Article</li>
<ol>
<li>x] getArticlesInChapter - added start and qty parameters</li>
<li>*] getArticlesInChapter(src db) - 2nd method&nbsp;USED for import process ??? </li>
<li>x] ADDED method for totalRecords</li>
</ol>
<li>x] count </li>
<ol>
<li>] on page libraries used 'sql qry' on </li>
<ol>
<li>] on page articles, we dont want all the articles, just the articles in the qry</li>
</ol>
<li>] result is being assigned to List 'System.Collections.Generic', list has a count property BUT b/c of way we are doing the qry with limit</li>
<li>] ADD/ALTER method totalRecords to take arg (parent_id) and pull the records in </li>
</ol>
<li>[2015-08-06] REVIEW</li>
<ol>
<li>x] subjects has</li>
<li>x] events has on bottom level(tasks)</li>
<li>x] items appears to have been started previously according to notes</li>
<li>] </li>
</ol>
<li>] </li>
</ol><hr style="font-size: 10px; font-weight: normal;" />
<h1 style="text-align: center;">status</h1>
<h2>[-previous-]</h2>
<ol>
<li>[00:00] <a href="/view/tasks?id=333" target="_blank">documenting-projects/feature-3670</a>&nbsp;-&nbsp;A look back&nbsp;</li>
<ol>
<li>x] at ALL the&nbsp;tasks COMPLETED&nbsp;along the way to getting this feature here. Link to Detailed view of each task, billing details,</li>
</ol>
<li>[00:00] <a href="/view/task?id=3682" target="_blank">FEATURE-3670-001</a></li>
<ol>
<li>x] # 3682 PAGINATION - getting started on PAGE view/libraries</li>
</ol>
<li>[00:00] <a href="/view/task?id=3683" target="_blank">FEATURE-3670-002</a></li>
<ol>
<li>x] # 3683 PAGINATION - page# click function, USE generated links VS link click handler function</li>
</ol>
<li>[00:00] <a href="/view/task?id=3695" target="_blank">FEATURE-3670-003</a></li>
<ol>
<li>x] # 3695 PAGINATION - implemented on x] PAGE view/items, x] pushed .org, x] pushed .com&nbsp;&nbsp;</li>
</ol>
<li>[00:00] <a href="/view/task?id=3689" target="_blank">FEATURE-3670-004</a></li>
<ol>
<li>i] # # - PAGINATION - map to PAGE view/items&nbsp;&amp;&amp; ] PORT list, see SECTION how to above &amp;&amp; ] map to PAGE view/...</li>
<li>x] # 3689 - UPLOAD - ] Article, ] Library, ] _AppStart&nbsp;] view/articles, ]</li>
</ol>
<li>[00:00]&nbsp;<a href="/view/task?id=3696" target="_blank">FEATURE-3670-005</a></li>
<ol>
<li>x] #&nbsp;5459 - PAGINATION -&nbsp;implemented on x] PAGE view/tasks, &nbsp;x] pushed .org, x] pushed .com,</li>
<li>**] return page results in batches of (#=20) || ] PAGE view/{L5} - {articles, items, ...}</li>
</ol>
<li>[2015-08-11]&gt; [00:00] FEATURE-3670-nnn</li>
<ol>
<li>x] PAGE view/libraries</li>
</ol>
<li>[01:00] <a href="/view/task?id=5459" target="_blank">FEATURE-3670-006</a></li>
<ol>
<li>x] #&nbsp;5459 - PAGINATION -&nbsp;implemented on x] PAGE view/steps, &nbsp;x] pushed .org, x] pushed .com,</li>
</ol>
<li>[00:00]&nbsp;REVIEW</li>
<ol>
<li>x] # # - PG view/items - x] has already been implemented NEED = ] view/people, ] view/places</li>
</ol>
<li>[2015-08-12][01:00] <a href="/view/task?id=5462" target="_blank">FEATURE-3670-007</a></li>
<ol>
<li>x] #&nbsp;5462 - PAGINATION&nbsp;- implementd on x] PAGE view/people</li>
</ol>
<li>[01:00] <a href="/view/task?id=5464" target="_blank">FEATURE-3670-008</a></li>
<ol>
<li>x] #&nbsp;5464 - PAGINATION&nbsp;- implementd on x] PAGE view/locations</li>
</ol>
<li>[2015-08-13][01:00] <a href="/view/task?id=5467" target="_blank">FEATURE-3670-009</a></li>
<ol>
<li>x] #&nbsp;5467 - PAGINATION&nbsp;- implementd on x] PAGE view/{L1} - all - except PG view/libraries, which had already been completed</li>
</ol>
<li>[2015-08-14] <a href="/view/task?id=5490" target="_blank">FEATURE-3670-010</a> </li>
<ol>
<li>x] # 5490 - PAGINATION - Search Results - search result pages, results are now paginated for Search articles&nbsp;</li>
<li>x] findBy name, x] findBy Description, x] findBy Content,&nbsp; x] findBy Library, x] findBy Book, x] findBy Chapter, x] findBy Status, x] findBy CreatedDate, x] findBy Owner</li>
<li>x] &nbsp;... will all return your results in nicely paginated lists. The default results per page is set to 20 results,&nbsp;our premium version enables the option to specify the results&nbsp; per page setting.</li>
</ol></ol>
<h2>[-current-]</h2>
<ol style="font-size: 10px; font-weight: normal;">
<li>[] </li>
<ol>
<li>]</li>
</ol></ol>
<h2>[-next-]</h2>
<ol style="font-size: 10px; font-weight: normal;">
<li>] PAGE - view/articles - PORT FUNCTIONALITY</li>
<ol>
<li>] multipe(2*) entry points into PAGE view/articles -&nbsp;page</li>
</ol>
<li>] <a href="/view/tasks?id=330" target="_blank">planning-projects/feature-3670</a>&nbsp;-&nbsp;A look ahead</li>
<ol>
<li>] at ALL the&nbsp;tasks&nbsp;PLANNED&nbsp;along the way to getting this feature here completed. Link to Detailed view of each task, with billing projections,</li>
</ol>
<li>] FIX-PRB/UPDATE on page view/{L5} ex tasks, AFTER edit<ol>
<li>]&nbsp; IF your editing an item on PG 3 and you update record, it will return to PG 1 </li>
</ol></li>
<li>[00:00] CREATE </li>
<ol>
<li>i] function - sospepHelper.generatePageNumbers - working for Articles, can I make it cross </li>
</ol>
<li>]&nbsp;TEST -&nbsp;when using find ON PG</li>
<ol>
<li>] results NOT paged</li>
<li>] limit = ?</li>
</ol>
<li>&gt;[00:00] PAGE m_articles</li>
<ol>
<li>] add PARAM values to call OR ...</li>
<li>] added Method</li>
</ol>
<li>[00:00] methods GetCalendars, Libraries , ...</li>
<ol>
<li>] manually specifying values for LIMIT (start, qty) in the query, RETHINK THIS&nbsp;cc FIX-PRB-5489</li>
</ol>
<li>[] PAGINATION</li>
<ol>
<li>] PAGES - L2</li>
</ol>
<li>[] PAGINATION</li>
<ol>
<li>] PAGES - L3&nbsp;</li>
</ol></ol>
&nbsp;
&nbsp;
&nbsp;
&nbsp;

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