• We provide the functional VB6 base software that will be used to add the followinG features
• Language VB.net or Web Forms, mysql or access for database
• The software must have 3 kinds of users, 1 adminstrator, 2 supervisor 3 operator. The operator only can add records, supervisor only can edit records and access to reports and export tool, and administrator full access
• first windows, a login form, will be the username and password form, then after validation, will appear the main form on it you will have the choices the user have available, like scan a visitor, a table with the actual inside visitors, visitors form, export data, search information, and reports
• The software need to be integrated with the SDK of the LDR Scanner to get the scanned infor from ID and Driver Licenses
• when the Guard scan a visitor using a SnapSell IDR scanner, the software must check in the DB if the visitor is new or not, in the case the visitor is new, it must add the new record to the visitors data base table, after the operator checked the ID number and name is correct, and add where the visitor will go, this action also add a record of the visit to a visits table with the time record. The scanner must record the information from the ID or License card to the form inmediately but some times it scan wrong words, so the operator must be able to correct the information scanned before click a buton named Check In to save the record in the table, and activate a usb relay to open a door. The image of the licence or id card have to be save in a field of the vititors table with a unique name referring to the Visitor
• For not a new visitor, only add the record to the visits table with the time information
• When save the record of the visit, the record must have a field to identify that the visitor is checked in, when the visitor leave, the guard must click the out buttom to save the time in the table inside a fiel ckecked out and send an eventual signal to the second port of the US RELAY
• We will supplie a computer with the LDR and USB relay installed for testing purposes
Software reporter when the Administrator is logged
In the Windows Administrator software, we need to include a reporter
forinforms. This reporter is a one query form that enable the
administratorto select many fields to get the inform.
The form will be divided in 3 sections as follows:
1. The first one with a combo box that will list the name of the five
designed and fixed reports, and enable the administrator to select the
range of visitor and range of dates he or she need
2. The second section, is a tool for the administrator to design
own report. In this section, the Administrator must select 7 fields
needed for the report, type the Name of the report the administator
to print in the form, and also the range of date and/or visitor. If
fields selected are widest than the page width, the administrator must
receive a message box informing that.
3. The third section is the export utility. In this section the
administrator must export the first or second section as an excel
Please include in your proposal separately the cost of the above and
button requirements for our evaluation.
License and Security Module
Each installation setup must have a key for installation like office and a expiration period of 1 year, so the software must show a msgbox when reach 90 days before the expiration day, and to renew the period, the user must get a new key, when reached the expiration day, the software must stop working.
• USB Dongle to operate the software, with expiration time. When 90 days to expire, each day the software must show the operator a message box to renew the dongle. If no dongle in the computer, the software will not open. This is for the Guard and administrator desktop software
When the software save the image of the id card, the software need to take a picture of the car o person using a web camera and save it also in a folder as a file and save in database the link of the photo
The software need to have a merge application to merge the data of the software, in the case a Customer have many installation without internet access, so we can merge the data of each slave app in one master app to make complete informs. So each village must have a unique number that identify each transaction from individual app into the master app