well, we have an app for IOS and ANDROID https://www.youtube.com/watch?v=-Sz5_nO9x-s
Te APP of the video, we used: - html + css - native javascript + ajax - cordova plugins for social share
The idea is simple, make an invitation and share the QR in WhatsApp, Email or in a SocialMedia
What do we need? in a blank webpage make - the function to sync all databases - the function for delete inactive or expires QR invitation (sqlite) - the function to create QR and share in a social media (whatsapp), background image size 800x800 pixels, with value text - the function to push notifications (its inside your QR visit!!! and its out your QR visit!!)
Ok, let me try to explain
============================== the function to sync all databases
we have 3 databases
Number 1, MySQL database EXCHANGE: is for: route the DOMAIN_SERVER, PORT_SERVER, Name_Database_To_Connect, User_Database, Pass_Database, On_or_Off_License, PinCode, for the connection to the license database.
Number 2, MysQL database LICENSE_A: is for NUMBER_QR, VISIT_NAME, START_QR_DATE, FINISH_QR_DATE, QR_ONE_TIME, TYPE_OF_CREDENTIAL, DATETIME_PASS_INSIDE, DATETIME_PASS_OUTSIDE, STATS_INSIDE_OR_OUSITE, ACTIVE_INACTIVE, Background _JPG (whtasapp INVITATION), JPG_VALUE_TEXT (whtasapp INVITATION), Push_Notifications, Alerts, Messages, etc.
Number 3, SQLite database for sync and save the information in the mobile device - CONNECTION_TABLE: IP, PORT, NAME_DATABASE_TO_CONNECT, USER_DATABASE, PASS_DATABASE, ON_OFF_LICENSE, PINCODE, ACCESS_TABLE: USER_login, PASSWORD_login, QR_INVITATION_TABLE: NUMBER_QR, VISIT_NAME, START_QR_DATE, FINISH_QR_DATE, QR_ONE_TIME, TYPE_OF_CREDENTIAL, DATETIME_PASS_INSIDE, DATETIME_PASS_OUTSIDE, STATS_INSIDE_OR_OUSITE, ACTIVE_INACTIVE
ok the idea is to sync the 3 databases
if i change DOMAIN_SERVER , changes in sqlite or mysql if i change Background _JPG , changes in sqlite or mysql if i change ACTIVE_INACTIVE, changes in sqlite or mysql
==============================
- the function for delete inactive or expires QR invitation (sqlite)
IF QR_ONE_TIME HAVE STATUS INSIDE/OUTSIDE, DELETE IF THE DATE_QR_FINISH IS A DATE PAST TODAY'S, DELETE IF THE ACTIVE_INACTIVE IS INACTIVE, DELETE
==============================
- the function to create QR and share in a social media (whatsapp), background image size 800x800 pixels, with value text
We need that in the mobile app, construct_the_process of the QR image to share - with no internet- and share to whatsapp in an image 800x800 pixels. the main idea is that all the process do it in the APP and sync to the database LICENSE_A the NUMBER_QR, VISIT_NAME, START_QR_DATE, FINISH_QR_DATE, QR_ONE_TIME, TYPE_OF_CREDENTIAL, DATETIME_PASS_INSIDE, DATETIME_PASS_OUTSIDE, STATS_INSIDE_OR_OUSITE, ACTIVE_INACTIVE
==============================
- the function to push notifications (its inside your QR visit!!! and its out your QR visit!!) IF QR_NUMBER IS INSIDE, push notifications "INSIDE YOUR VISIT_NAME WITH #NUMBER_QR VISIT" IF QR_NUMBER IS OUTSIDE, push notifications "OUTSIDE YOUR VISIT_NAME WITH #NUMBER VISIT"
=============================
easy right? ok we need
the functionality thats includes - CORDOVA (preference) OR CAPACITOR - source code - app/bundle for testing android and ios - help to make accounts of 3rd servers if we need (amazon, etc)
if you have some ideas, please talk to me.... dont forget that the app that i used, is in html+css, javascript and cordova
remember im not giving you any files. you need to make your own databases, in a blank webpage, only to make the functions and give the source code.