(public).sospep.events ~ view task ~ PAGE-find-items

<h1 style="text-align: center;">find/ items</h1>
<h2>[WHAT]&nbsp;</h2>
<ol>
<li>[def] this page displays a form with the input feilds for an item&nbsp;record, enables users to define and execute a search for a&nbsp;item or&nbsp;items with a variety of different parameters</li>
<li>[ args ] none</li>
<ol>
<li>]&nbsp;? OPTIONALLY take the itemCategory,&nbsp;inventory and&nbsp;warehouse names&nbsp;</li>
<li>] ? takes the qry name and parameter[s]</li>
</ol></ol>
<h2>[WHY]</h2>
<ol>
<li>
<p>] this page enables the user to define and execute a&nbsp;number of different search queries to execute against&nbsp;the people persons records table. The query will return&nbsp;the desired person record or records that the user desires.</p>
</li>
</ol>
<div>
<div>[ def ] page displays a form with the feilds of an object item record and enables the user to initiate a search on any of those feilds.</div>
<div>- takes the id of the ItemCategory that the item will belong to, OPTIONALLY take the itemCategory, inventory and warhouse names</div>
<div>[ returns ] the results of the user selected search</div>
</div>
<h2>[WHERE page is called from]</h2>
<ol>
<li>] menu Main - search menu, search option&nbsp;= 'search Objects, ??= RENAME as search Items??</li>
</ol>
<h2>[WHEN]</h2>
<ol>
<li>]&nbsp;</li>
</ol>
<h2>[EXAMPLE]</h2>
<ol>
<li>]</li>
</ol>
<h2>[HOW-TO]</h2>
<ol>
<li>]</li>
</ol>
<h2>[REFERENCE]</h2>
<ol>
<li>] /find/ items.cshtml</li>
<li>] find/items <a href="task?id=2246" target="_blank">-v-001</a> -&nbsp;</li>
<li>] find/item <a href="task?id=2247" target="_blank">-v-002</a> -&nbsp;</li>
</ol><hr />
<h1 style="text-align: center;">developer implementation</h1>
<h2>[.process]</h2>
<ol>
<li>
<div>set the qry value = to the name of desired qry</div>
</li>
<li>
<div>set the&nbsp;param value = to the user selected param value</div>
</li>
<li>
<div>user submits form == on post</div>
</li>
<ol>
<li>
<div>read qry,</div>
</li>
<li>
<div>read param,</div>
</li>
<li>
<div>build qstring to pass values to page view/articles,</div>
</li>
<li>
<div>redirect to page view/articles</div>
</li>
</ol>
<li>
<div>on page view/items</div>
</li>
<ol>
<li>
<div>get the qry name,</div>
</li>
<li>
<div>get the param value,</div>
</li>
<li>
<div>execute the qry(in the DAL&nbsp;helper)&nbsp;to return results to this page</div>
</li>
</ol></ol>
<h2>[.notes]</h2>
<ol>
<li>
<div>&nbsp;</div>
</li>
</ol>
<h2>[.by_date]</h2>
<ol>
<li><strong>[2012-02-02]</strong></li>
<ol>
<li><strong>16:00 ] NEW PAGE(id=1546)= find/ items</strong></li>
<li><strong>x] created new page record(id=1546) for new version</strong></li>
<ol>
<li>]&nbsp;edits=1492 for ] OOP(),&nbsp; ] navHeader added, PENDING= SEARCH CODE</li>
</ol>
<li><strong>x]&nbsp;updated new page record(id=917) for PAGE=searchObjects _v_001_003, (prev version)</strong></li>
<ol>
<li>x] editd page = prev ver (aligned comment format, closed, moved)</li>
</ol>
<li>] ...( see notes in record # 1545&nbsp;)</li>
</ol>
<li><strong>[2012-02-dd]</strong></li>
<ol>
<li>*] - these are some&nbsp;draft notes from scrap for this new page, REF=base page SearchObject....Items, REVISED logic as per notes below ,</li>
<li>] ADD REF= &nbsp;to fea! searchTables</li>
<li>] NOTE = currently only S(articles) and O(items) are using this methodology while other apps are si</li>
<li><strong>find / search</strong> == index / qry&nbsp; /s.o.y.p.e.l</li>
<li>on post</li>
<ol>
<li>switch(qry)</li>
<ol>
<li>case: "___"</li>
<li>{SET qry, SET param, REDIRECT to view/articles ADDING qry + parm to URL as qstring}</li>
</ol></ol>
<li><strong>view&nbsp;/ articles</strong></li>
<li><strong>if (qry)</strong></li>
<ol>
<li><strong>switch(qry)</strong></li>
<ol>
<li>case: "___"</li>
<li>{db.Execute(qry, param), REDIRECT to view/articles OR view/article }</li>
</ol></ol>
<li><strong>REVISED - find/Search page</strong></li>
<ol>
<li><strong>post directly to view articles</strong> VS using switch to catch the qry and build qstring with param values</li>
<li>NOTE = PRB with qry in url and no qry in url for reg pages,</li>
</ol></ol>
<li>[2013-08-05]</li>
<ol>
<li>] UPDATE FEATURE PAGE- view/items CODE for search function</li>
<li>x] replaced db acces CODE for search with OOP</li>
<li>+] PRB with ] find-name, ] find-description, ] content ONLY returns IF exact match , qry is LIKE not =&nbsp;</li>
<li>+] find/warehouse - ERROR if NO content in child record</li>
<li>*x] FIX PRB no results, qry was being posted directly to page view/items</li>
</ol></ol>
<div><strong><br /></strong></div>
<div>&nbsp;</div>
<h1 style="text-align: center;">status</h1>
<h2>[current]</h2>
<ol>
<li>
<div>&nbsp;]</div>
</li>
</ol>
<h2>[next]</h2>
<ol>
<li>
<div>]&nbsp;</div>
</li>
</ol>
<p>&nbsp;</p>
<p>&nbsp;</p>

~ view task ~ TaskGroup] PAGES-sospep-objects FROM [ Plan] doc-projects IN [ calendars] prj-022-sospep