edit-task

Task Description: revising index_help page to index-articles page, for any BOOK

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;">index</h1> <h2>[previously]</h2> <ol> <li><strong>[2013-11-04] index_help -</strong></li> <ol> <li>x] PRB generated links that were not accessible, getting ERROR(S) on site crawl report for each page it generated</li> </ol> <li><strong>x] NEW PG index_articles</strong></li> <ol> <li>] replaces index for 1 book with index for any book, *] currently only accessed via the "main help menu" for BK sospep-help</li> <li>] ARGS library id</li> <li>] RETURNS - page with listing of passed in index strings, alpha letters, +&nbsp;</li> </ol> <li><strong>] CS sospepHelper - NEW method -&nbsp;</strong></li> <ol> <li>] sospepHelper.generateIndex([]index strings, list style, &nbsp;) - &nbsp;</li> </ol> <li><strong>] CS Article - NEW method&nbsp;</strong></li> <ol> <li>] ArticlesIndex - take the library id,&nbsp;</li> <li>] ARGS id of library, string search</li> <li>] RETURNS - result of search for index&nbsp;</li> </ol> <li><strong>] PG view_articles - EDIT "index" block in qry switch</strong></li> <ol> <li>] call new method that assigns results of index search to Page.articles</li> </ol></ol> <h2>[currently]</h2> <ol> <li><strong>&gt; i] PG index_help</strong></li> <ol> <li>] replacing with PG index_articles, can now index any BK, can create custom index(insert terms)</li> </ol></ol> <h2>[next]</h2> <ol> <li>]</li> </ol> <div><hr /></div> <div> <div>] mysql create transaction</div> <div>] PG view/articles?&nbsp;</div> <div>] select all from articles where name_article LIKE @0'</div> <div>] select SQL_CALC_FOUND_ROWS * from sospep.articles where id_article BETWEEN 100 AND 200 LIMIT 10;</div> <div>] select FOUND_ROWS();</div> <div>] library id = 27&nbsp;</div> <div>] select * from articles where name_article LIKE UPPER('S%');</div> <div>] select * from sospep.articles where name_article LIKE 'A%' &amp;&amp; parent_id IN (Select id_chapter FROM chapters WHERE parent_id IN (SELECT id_book from books where parent_id = 27));</div> </div>