Proposed key control program: Requirements ??" PC placement in operators area. This program will allow new keys to be entered or removed (for sold units), printing of reports for keys that are missing at the end of the day. Specs: PC based program ??" would like it to reside on the top of the screen like a tool bar and always remain on top of whatever program is being run. This program acts as a database with information/fields for stock number, model, signed out to, initials, and a comment field. When the program is run the used is prompted with the following choices: 1. Add new key 2. Remove from Inventory (Sold or DT’d) 3. Sign in/out keys 4. Display history of key 5. Print a report of missing keys 6. Exit If they choose to add a key ??" the user would be given a blank screen with an add button that prompts the user for stock, model and location on the rack i.e., A1, B12. This allows for entry of new keys ??" after the user presses the ‘add’ button it would check to see if this key number is already in the inventory and if the location of the keys is already being used by another key record ??" if it is already in the dbase then the user will be prompted to edit the current record (Y/N) and then present the information that is already in the database for editing (except the comment field ??" that should never be edited) and then would return them to the main menu with comments added ‘record edited by BB at 9am on 3/1/2004’ . If the location is already being used ??" then a popup would say ??" ‘location B12 is being used for B1001 ??" please choose another location’ and returned to the edit screen. We probably need a cancel button as well right here. (more below)
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
(**MORE) If they choose to remove from inventory it then prompts them with a stock number box, its location and an initials box ??" and a button ‘remove’. It would ask them again with a popup ??" ‘Remove B1000 from inventory (location A12)?’, the initials field and a yes/no button. The yes button would not be highlighted until the user puts two digits in the initials field. The yes response would remove the information in the location field but keep the record intact with the initial information and date and time placed in the comment field of the database ‘removed from inventory by BB at 5pm on 3/1/2004’ If they choose to sign in/out keys ??" the program would prompt for a stock number. If the key was already signed out it would prompt the user ??" ‘B1000 was signed out to Lenny Lynch at 1200hrs on 3/1/2004 Is this key being turned in?’ If yes ??" then it would put up another box with a yes/no confirm box ‘ B1000 was signed out to Lenny Lynch at 1200hrs on 3/1/2004 ??" and is returned to key room at 1600hrs ??" please place key at location B12’- with an initials box. Again the yes button would not be highlighted initial two initials are inputted. If yes then it would return to the main menu. And the information entered in the comment field (key returned at 3pm on 2/1/2004 as noted by BB’. If no is chosen about the key being returned the user would be prompted ??" ‘Is this key being reassigned?’ (Yes/No) ??" If yes then it would go into the entry screen. If the key was not previously signed out then the user is presented with a entry area ??" with an add or cancel button. The add button is not highlighted until all fields have text in them. The fields that would be displayed are stock, model, location and initials. The records are then added with ‘ added to inventory by BB at 5pm on 3/1/2004’ placed in the comment box. The comment box will hold the history of all keys. After the fields are entered and the user presses ‘add’ another box pops up to confirm entry ‘ B0000 has been successfully added to the database’ and the user is returned to the main menu. Display history of keys ??" would prompt the user for a stock number and then display the information contained. The history would be in the comment field. The user should be presented with two options ??" print record or ok. The print record would do just that ??" dump what it sees to the printer ??" all fields. Ok ??" would bring them back to the main menu. Print a report of missing keys would scan all records for those that have not been turned in and print a list. It would contain all fields in a spreadsheet type layout ??" example: Milton Ruben ??" Key Control List of keys not returned to Operator as of (current date and time) Stock Model signed out to(last entry in the comment field) B1000 Grand Cherokee Signed out to Lenny Lynch at 3pm on 3/1/2004 Maybe a field is needed to mark the keys in or out and that way the report could look to that field to figure out if it needed to be added to this report ??" your choice. Exit would close the program.
windows 98/xp - One last thing - I need a password protection scheme to open the program. In other words to run this program at all the user will need to input a password. The password and user names are in a text file. This text file would have names and their passwords - i.e, Lenny Lynch 1234. The program would write a log on who opened the program and at what time (ie. Opened at 4pm on 3/1/2004 by Lenny Lynch)- would be nice to also annotate when the program was closed.