Pajer_1.0

Pajer_1.0 is a Time Attendance System. It allows you to track employee attendance by using an RFID reader and a connected database. The system is adaptable for use on various operating systems with minimal modifications to the code.

Requirements:

• UART USB Converter LINK (just an example, can be any)

• RFID Reader LINK (just an example, can be any with serial communication)

• Some cables to connect them:

  

• RFID Cards

• Local / Remote Database (tested on MariaDB - LINK))

• Copy the RCP folder to the device to which you have connected the reader.

• Change the "port" in readrs.py:

ser = serial.Serial(
        port='COM7',
        baudrate=9600,
        parity=serial.PARITY_NONE,
        stopbits=serial.STOPBITS_ONE,
        bytesize=serial.EIGHTBITS,
        timeout=0.2,
)

• Change connection params in function Insert_SQL_Remote:

conn3 = database.connect(
        user="rcp",
        password="STRONGPASSWORD",
        host="XXX.XXX.XXX.XXX",
        database="RFID"
        )

Run with:

• startbat.vbs
• python readrs.py

There is also a function to turn on the computer for an employee who logs in, but this already requires changes in the database which I will not discuss here. Code was tested on Debian11 / Windows10. To change the system small changes in the code are required, currently the application is adapted to run on Windows.

Database Setup:

The next step is to create tables in the database. We do this by running the main database application. We do this either by installing it with an .exe file in releases or by cloning the repo and running python Pajer.py. The first run will ask us whether to create tables and to specify the connection parameters. NOTE: THE DATABASE ENGINE MUST BE INSTALLED BEFOREHAND!!! In case of problems, we create the database manually using the DB.sql file located in the application's main folder.

When you have done all this, reset the application and log in with:

• login/password: admin / qwerty