Aplikasi-Presensi-Kuliah-dengan-RFID-disertai-Monitoring-Bot-Telegram

3rd Final Project in API Programming

This Telegram-based ChatBot is built on the Google App Scripts platform using Javascript as the programming language. The framework used is Lumpia.js. The purpose of this bot is to monitor lecture attendance data. While this RFID application is made by programmers to be able to help someone in filling the college attendance quickly and precisely. This RFID application is built with Visual Basic 6 programming language.

Project Requirements

Part	Description
Features	Reply Keyboard, Error Handling, User Log Activity, Attendance Data Monitoring, & Auto Input Data
Platform	Google Apps Script & Freemysqlhosting
Tools	Microsoft Visual Basic 6.0 Enterprise
Function VB 6	keybd_event & Sleep
Framework	Lumpia.js
Code	JavaScript, Visual Basic 6
Operation System	Windows 10

Download & Install Visual Basic 6.0 Enterprise

https://bit.ly/VisualBasic6_Installer

Get Started

1. Go to the site: https://www.freemysqlhosting.net/ -> Register for an account -> Login.
   
   

2. Download & Extract this repository.
   
   

3. Import sql file in the directory: Aplikasi-Presensi-Kuliah-dengan-RFID-disertai-Monitoring-Bot-Telegram\Assets\database\rfid_bot.sql.
   
   

4. Open the directory: Aplikasi-Presensi-Kuliah-dengan-RFID-disertai-Monitoring-Bot-Telegram\Src\RFID\Aplikasi RFID Presensi Bot Pintar.vbp, then find the modules section, please click Module2 (Module2.bas).
   
   

5. Fill in the dbName, dbUser, password sections according to your SQL Cloud.
   
   
   
   

6. Open Module3 (Module3.bas), then fill in the RFID Card Code, Telegram ID, and Telegram Username sections.
   
   
   
   The addition of this data is done manually, so if there are more than 2 users then the source code needs to be adjusted again.
   
   

7. Create a new project first on the platform: Google apps script.
   
   

8. Add new file on the platform Google apps script and regarding file name or number of files can be different according to your own creation, because this will not affect the performance of the bot system -> then don't forget to click Save.
   
   

9. Open the directory: Aplikasi-Presensi-Kuliah-dengan-RFID-disertai-Monitoring-Bot-Telegram\Src\BOT\ -> Copy & paste the entire contents into the file available on the platform Google apps script.
   
   

10. Enter the Library ID in the Library section:

    1Yo6vQRwjG5Gl9jeEF0g2tBTUa0XN5MyT4G_HeDpRr9DvabxhRcSdhPNj

    
    

11. Add the library -> Always select the highest version of the library -> Save.
    
    

12. Paste the API bot token telegram that you have obtained from @BotFather as follows :

    // Token API const token = '6402342255:AAGF8UBcj7mPyaE8Fv_6rFlhIOc8Np1od3I';

    
    

13. Click Apply -> New deployment -> Select type: Web Application.
    
    

14. Contents Description -> In the Access section, please select the section: anyone can access -> Apply.
    
    

15. Review permissions -> Select your email -> Continue -> Open your bot project (not secure) -> Allow.
    
    

16. Copy the web app URL link -> Paste the link into the let url section in config.gs as follows:

    let url = 'https://api.telegram.org/bot1164101112:AA1BC1DI/setwebhook?url=https://script.google.com/macros/s/AKfycbyKodePanjang/exec';

    
    

17. Make sure the function being executed is setWebHook -> Click Run.

    Will be considered successful if the execution log reads: Info {ok=true, description=Webhook is already set, result=true}.
    
    

18. Please enjoy [Done].

Highlights

RFID

Database

Telegram Bot

Reminder

Disadvantages: The database error control in the VB 6 application is still not working properly (there are still bugs in it). The SQL Cloud used is fairly free, so there are many limitations (not free in practice). Still constrained in the presence data loop, so that the data entered is only the initial index.

Demonstration of Application

Via Telegram: @simonsen_bot

Appreciation

If this work is useful to you, then support this work as a form of appreciation to the author by clicking the ⭐Star button at the top of the repository.

Disclaimer

This application has been created by including third-party sources. Third parties here are service providers, whose services are in the form of libraries, frameworks, and others. I thank you very much for the service. It has proven to be very helpful and implementable.

LICENSE

MIT License - Copyright © 2020 - Devan Cakra Mudra Wijaya

Permission is hereby granted without charge to any person obtaining a copy of this software and the software-related documentation files to deal in them without restriction, including without limitation the right to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons receiving the Software to be furnished therewith on the following terms:

The above copyright notice and this permission notice must accompany all copies or substantial portions of the Software.

IN ANY EVENT, THE AUTHOR OR COPYRIGHT HOLDER HEREIN RETAINS FULL OWNERSHIP RIGHTS. THE SOFTWARE IS PROVIDED AS IS, WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, THEREFORE IF ANY DAMAGE, LOSS, OR OTHERWISE ARISES FROM THE USE OR OTHER DEALINGS IN THE SOFTWARE, THE AUTHOR OR COPYRIGHT HOLDER SHALL NOT BE LIABLE, AS THE USE OF THE SOFTWARE IS NOT COMPELLED AT ALL, SO THE RISK IS YOUR OWN.