This document is a modified version with the comments from the customer embedded.

SquidSoft Inc. - GUIDOs

Overall Design Document - Personnel


                    Table of Contents                    

                    6.1 Personnel Button Selection                    

Description:

This function displays the employees by employee_id. And then allows the user to add, delete, edit, find, sort and clear the password for employees.

Input: employee_id, function_selection, employees.
Output: employee_id, employee_listing.

Psuedocode:

Print a list of all employees to screen
Get user function selection
If selection is add
Add a employee
If selection is delete
Delete a employee
If selection is clear password
Clear the customers password
If selection is clear the customer password
Update the customer information
If selection is print
Print all employees
If selection is find
Find the employee
If selection is sort_by
Sort the employees

A manager when making changes to their own security permissions, should be either warned or disallowed to perform these changes.


                    6.2 Add Personnel                    

Description:

The add function is used to add new employees to the database.

Input: store_id, employee_id, first_name, last_name, security_level, position, store_ids.
Output: employee.

Psuedocode:

Get employee information from user
If store id does not exist in employee database
Print error window "Invalid store_id information!!"
Else if employee_id exists in employee database
Print error window "Employee_id already exists."
Else if all fields exist
Add employee to database
Else
Print error window "Please enter data in all the fields."

Managers should only be allowed to enter new employees for their particular store, so store ID is not really necessary. When a new employee is entered, the manager should assign a password immediately for the new employee and then inform the employee of the password so they can then change it. This should hopefully prevent somebody else from logging onto the new employee account before a password has been added. Passwords should be a minimum of 5 letters/digits long.


                    6.3 Delete Personnel                    

Description:

This function deletes an employee from the database.

Input: choice.
Output: employee_id.

Psuedocode:

Print window "Are you sure you want to delete" employee_id
If answer is delete
Delete employee from the database
Else cancel

                    6.4 Clear Password                    

Description:

This function clears the password for a specific employee.

Input: choice.
Output: employee_id, employee_id.

Psuedocode:

Print window "Are you sure you want to clear the password for" employee_id
If answer is clear password
goto the employee in the database and write a null in the password
Else cancel

A password should never be cleared so to speak, because this allows anyone to log on if the password is null. A manager should not clear but rather modify the password to something else, which they will inform the employee of, so that they can change it. Reminder passwords are a minimum of 5 characters long.


                    6.5 Update Personnel                    

Description:

The update function allows the user to modify the fields on a employee.

Input: store_id, employee_id, first_name, last_name, security_level, position, store_ids.
Output: employee_id, store_id, employee_id, first_name, last_name, security_level, position.

Psuedocode:

The user enters the new information into all but the employee_id field
If store id does not exist in the database
print window "The store_id is invalid."
Else write new values to employee database

                    6.6 Print Personnel                    

Description:

This function prints a report listing all the employees information.

Input: employees.
Output: personel_report.

Psuedocode:

Print all the employee records in a report form to the printer

Can an employee choose how to print the report? Can they print according to the last name in alpabetical order? Can they print according to the employee security level or according to their ID?


                    6.7 Find Personnel                    

Description:

The find function will find an employee by a specific search criteria.

Input: employee_id, last_name, first_name, employee.
Output: employee.

Psuedocode:

Print window "Find by: employee id, first name, or last name"
Search database by last_name, first_name or employee_id
If search unsuccessful
Print error window "The employee" employee_id "was not found!!"

                    6.8 Sort By                    

Description:

This function sorts the employee list by a specific criteria.

Input: employees.
Output: sort_choice, employee_listing.

Psuedocode:

Print window "sort by employee id , last name, or first name."
If the choice is employee_id
List all employee in descending order by employee_id
Else if choice is last_name
List all employees in descending order by last name
Else if choice is first_name
List all employees in descending order by first name
Else (choice is cancel) do nothing.

Is it possible to sort the list according to the security level they are in?


  Data Dictionary  

Login  
Main Menu  
Security  
Orders  
Product  
Personnel  
Stores  
Cashier  
Inventory  

Client Concerns  

Glossary  
Main Page  


About SquidSoft Inc.