Document Navigator For The Design Index
Previous Section
(Book Administration)
This Section
(Customer Administration)
Next Section
(Transactions)
Previous (Add Customer) Search Customer Next (View / Update)

 


Search Customer                                   

 

Inputs                                   
     
Customer ID number
An integer.
Last Name
A string with a maximum length of 60 characters. This does not need to be unique to each customer (ie. more than one customer can have the same last name).
First Name
A string with a maximum length of 40 characters. This does not need to be unique to each customer (ie. more than one customer can have the same first name).
Phone number
A standard North American phone number. When entering the phone number, if the entry may begin with a '(' and if so has the form '(DDD) DDD-DDDD' where D is a decimal digit in the range of 0-9. If the entry begins with a digit then the accepted form is DDD-DDDD where D is as above. Any other input is invalid and upon leaving the entry will be cleared.
Address
A string with a maximum length of 80 characters. This field represents the name of the street portion of the customers mailing address.
City
A string with a maximum length of 20 characters. This field represents the name of the city portion of the customers mailing address. The acceptable input characters are in the range of A-Z and a-z. This field will be defaulted to the name of the city that the system is installed in.
Province
A string with exactly 2 characters. This field represents the name of the province/state portion of the customers mailing address. The acceptable input characters are in the range of A-Z and a-z. This field will be defaulted to the name of the province/state that the system is installed in.
Country
A string with a maximum of 10 characters. This field represents the name of the country portion of the customers mailing address. The acceptable input characters are in the range of A-Z and a-z. This field will be defaulted to the name of the country that the system is installed in.
Postal Code
A string with a maximum length of 11 characters. If the string begins with a letter then the string must be in the form of LDL DLD, where D is a decimal digit in the range of 0-9 and L is a letter in the english alphabet. If the string begins with a digit then it must be in the form of DDDDDDDDDDD where D is a decimal digit. Any other form the string takes is invalid and the field will be cleared.
Max Books
The maximum number of books the customer can borrow. This field can only be modified by a user with supervisor status. This field will be defaulted to a value determined by the customer.
Max fine
The maximum amount of fines the customer can have. Like the max books, this value can only be modified by a user with supervisor status. This field will be defaulted to a value determined by the customer.
Circulation Status
Circulation status refers to the current status of a customer in relation to if they have books that are one of: 'on hold', 'on loan', 'overdue', or 'clear'. For example, this allows a list to be generated limiting it to the customers who have books that fall into the above sections.

 

Outputs                                   
     If an unrecoverable error (such as read write errors to the database) occurs the module will output the error code to the error handling module and discontinue the process.
     With success, a list (also displayed on this screen) of the exact matches to the input criteria. This list will contain the First and Last Name and Telephone number.
     Selecting an entry from the list (either by single click on the entry and then pressing the select button or by double clicking on the entry) will display the View/Update customer screen with the selected entry filled in.

 

Error Conditions                                   
     Hardware error is an unrecoverable error that will be processed by the error module.
     Format errors in fields that impose a structure on the input.

 

Description                                   
     
Search Customer Window
The search window is divided into three areas; The top portion will contain text entry fields for: last name, first name, phone number, address, city, province, country, postal code, max fines, max books, customer Id, and circulation status.

Buttons Present: SEARCH

The middle portion will be where the results of the search are displayed. This will be in the form of a list with the following fields present: Last name, first name and any other fields that were present in the search criteria. It will only be possible to highlight one entry in the results list.

Buttons Present: None

The bottom portion will be buttons that will act upon the selected entry or the entire list from the middle portion. In addition there will be a space for any messages to the user to be printed.

Buttons Present: SELECT, PRINT, SAVE, QUIT

SEARCH
Upon selection the search customer module will check to see any fields have been entered.

If no fields have been entered the module will beep once and display the message : 'Please enter a search criteria in the fields supplied' and then discontinue the search.

The fields postal code, province, and ID number will be checked for format errors.

If format errors are found the system will beep and display the message: `Format error in field XXX' (where XXX is the name of one or more of postal code, province or ID number) the search will then be discontinued.

The search module will then formulate a Query based on the information present and send that query to the database. And clear the message section of the bottom portion of the screen.

If the database responds with an unrecoverable error this module will pass that error to the error handling module and discontinue the search.

The results of the search will be displayed in the middle portion of the screen sorted alphabetically by last and first name.

If the list has a length of 0 then the message : 'No matching items found please modify search criteria and reselect search, or select Quit to exit' will be displayed in message section.

SELECT (or double click on entry)
Check the results area to see if an entry has been selected.

If no entry has been selected display the message : 'Please click on an entry from the results list first'. Select will then discontinue.

Clear the message area.

If the Edit/Update window is currently open refresh it with the contents of the selected entry along with the results of a query to get a list of any books the customer has on loan or hold.

If the Edit/Update window is not currently open call it and give it the data from the selected entry along with the results of a query to get a list of any books the customer has on loan or hold.

PRINT
If the length of the list is 0 display the message : 'Nothing to print'. Discontinue the print process.

Send the list to the printer.

If an unrecoverable error (such as read write errors to the database) occurs the module will output the error code to the error handling module and discontinue the process.

SAVE
If the length of the list is 0 display the message : 'Nothing to save'. Discontinue the save process.

Open dialog box with message: 'Enter name of file to save to.'

Buttons Present: OK, QUIT

OK
If the filename is of acceptable format then close the dialog box and save the file to disk.

If an unrecoverable error (such as read write errors to the database) occurs the module will output the error code to the error handling module and discontinue the process.

QUIT
Close the dialog box and discontinue the save process.

QUIT
Close the customer search window and return control to the main customer window.

 

Walkthrough                                   
Screen ShotLibrarian enters the search criteria in the appropriate fields following the correct format. Librarian clicks on the 'Search' button. Search will return a list that matched the criteria. Librarian can either double click an entry or single click and then select 'Select' to display the View/Update screen. If the Librarian selects another entry the View/Update screen will be refreshed. To print or save the list the librarian need only select the appropriate button. When Finished the user selects 'Quit'.

 


Document Navigator For The Design Index
Previous Section
(Book Administration)
This Section
(Customer Administration)
Next Section
(Transactions)
Previous (Add Customer) Search Customer Next (View / Update)

Copyright ©1997 VoidWorks Software Inc.

Send mail to the Group Leader or the Webmaster
Pages created and maintained with Mortar