edit-task

Task Description: [WHAT]page displays form with object feilds, [WHY] initiate search on o.items table by user selected, feild, REPLACING:SearchObjects

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;">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>