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.

[ 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.
- takes the id of the ItemCategory that the item will belong to, OPTIONALLY take the itemCategory, inventory and warhouse names
[ returns ] the results of the user selected search

[WHERE page is called from]

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

[WHEN]

[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]

  1.  

[.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]

 

 

Details Photos Edit more

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

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities