task

find/ items

[WHAT] 

1. [def] this page displays a form with the input feilds for an item record, enables users to define and execute a search for a item or items with a variety of different parameters
2. [ args ] none
1. ] ? OPTIONALLY take the itemCategory, inventory and warehouse names 
2. ] ? takes the qry name and parameter[s]

[WHY]

1. ] this page enables the user to define and execute a number of different search queries to execute against the people persons records table. The query will return the desired person record or records that the user desires.

[WHERE page is called from]

1. ] menu Main - search menu, search option = 'search Objects, ??= RENAME as search Items??

[WHEN]

1. ] 

[EXAMPLE]

1. ]

[HOW-TO]

1. ]

[REFERENCE]

1. ] /find/ items.cshtml
2. ] find/items -v-001 - 
3. ] find/item -v-002 - 

developer implementation

[.process]

1. set the qry value = to the name of desired qry
2. set the param value = to the user selected param value
3. user submits form == on post
1. read qry,
2. read param,
3. build qstring to pass values to page view/articles,
4. redirect to page view/articles
4. on page view/items
1. get the qry name,
2. get the param value,
3. execute the qry(in the DAL helper) to return results to this page

[.notes]

[.by_date]

1. [2012-02-02]
1. 16:00 ] NEW PAGE(id=1546)= find/ items
2. x] created new page record(id=1546) for new version
1. ] edits=1492 for ] OOP(),  ] navHeader added, PENDING= SEARCH CODE
3. x] updated new page record(id=917) for PAGE=searchObjects _v_001_003, (prev version)
1. x] editd page = prev ver (aligned comment format, closed, moved)
4. ] ...( see notes in record # 1545 )
2. [2012-02-dd]
1. *] - these are some draft notes from scrap for this new page, REF=base page SearchObject....Items, REVISED logic as per notes below ,
2. ] ADD REF=  to fea! searchTables
3. ] NOTE = currently only S(articles) and O(items) are using this methodology while other apps are si
4. find / search == index / qry  /s.o.y.p.e.l
5. on post
1. switch(qry)
1. case: "___"
2. {SET qry, SET param, REDIRECT to view/articles ADDING qry + parm to URL as qstring}
6. view / articles
7. if (qry)
1. switch(qry)
1. case: "___"
2. {db.Execute(qry, param), REDIRECT to view/articles OR view/article }
8. REVISED - find/Search page
1. post directly to view articles VS using switch to catch the qry and build qstring with param values
2. NOTE = PRB with qry in url and no qry in url for reg pages,
3. [2013-08-05]
1. ] UPDATE FEATURE PAGE- view/items CODE for search function
2. x] replaced db acces CODE for search with OOP
3. +] PRB with ] find-name, ] find-description, ] content ONLY returns IF exact match , qry is LIKE not = 
4. +] find/warehouse - ERROR if NO content in child record
5. *x] FIX PRB no results, qry was being posted directly to page view/items

status

[current]

1.  ]

[next]

1. ] 

Details

ID: 2245

NAME: PAGE-find-items

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

START DATE TIME: 2013-08-05 10:00:00

EST DURATION: 01:00:00

END DATE TIME: 2013-08-05 11:00:00

STATUS: To-Do

PRIORITY: -5

OWNER ID: 75

photos

actions