Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Corona Virus-Related Help
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

Corona Virus-Related Help

edoarudo5edoarudo5 Member
edited December 2020 in Help

Hello everyone,

So with the collaboration with my friends, we decided to meet to an agreement with the local government unit to implement a local protocol which requires people on the community to login whenever they enter any public establishment with a QR code (the protocol is already in place but not using QR codes, each person is required to fill out a form before they enter so it's a massive waste of time lining up). This is for contact tracing. None of us are coders, so this is where the problem lies on this implementation. I would like to ask if you know any Android open source apps which uses QR code to login to an establishment's own QR code. So our system goes like, every establishment has their own QR code and whenever people enter, say, to a local mall, instead of filling out on forms before entering, then just need to present their QR code (which contains their identity) to the guard of the premises. The guard will scan the code, whether it be from a phone or from a printed paper.

We need:

A website that lets user register their information (Name, Address, Contact Number) and generate a QR code for them
The same website that will let establishments register their information
A mobile app for the establishments that connects to the website's database and syncs all the login information they receive

They are all just log ins, no log outs. We just basically want to know who logs in at what time in what place and place it real-time on a website (of course the people who can only access the website are people on the CoVid-tracing team). Is there any open source app you know that can be used for this?

«1

Comments

  • yoursunnyyoursunny Member, IPv6 Advocate

    No need to bother with QR codes.

    • Every customer must prepare a business card or a piece of paper that has the same information.
    • The guard uses the camera app to take a picture of that paper.
    • Photos are auto-uploaded to Nextcloud.
    Thanked by 1edoarudo5
  • @yoursunny said:
    No need to bother with QR codes.

    • Every customer must prepare a business card or a piece of paper that has the same information.
    • The guard uses the camera app to take a picture of that paper.
    • Photos are auto-uploaded to Nextcloud.

    We at least need to have a website with meaningful data that can be used by beginners (most people on the trace team are at most beginners in using computers). So QR code with a simple database website will actually suffice...

  • No need for a mobile app. Just a website that presents a form to the person seeking entry via a url with the location id. Store the user info as cookies, so they do not need to key in every time they enter a place. Have a check-in/check-out system. Let the user scan a checkout QR code at the exist. Print entry and exit QR codes prominently.

  • The problem is that not every user has a cellphone. A kiosk is too big to put on an establishment entrance. So we plan to require a mobile phone for each establishment with an internet connection. Advantage is that it is low maintenance and can run on mobile data if the establishment's internet connection fails. We actually don't need a check out, just check ins, at least, that's what we all agreed upon on the meeting. You go to an establishment, the security guard scans your QR code and that's it. The mobile app just needs to send the logs to the website.

  • HaBangNetHaBangNet Member, Host Rep

    This was the same QR code eg. Personal Health Code which was using in China now, when you take train, airline or visit attractions place you will need to provide that QR code to scan before entering

  • @yoursunny said:
    No need to bother with QR codes.

    • Every customer must prepare a business card or a piece of paper that has the same information.
    • The guard uses the camera app to take a picture of that paper.
    • Photos are auto-uploaded to Nextcloud.

    Then OCR? A bunch of photos is useless and time consuming later on. Ain't nobody got time for that. The registration and QR code system would have the person's details in useful electronic form.

    If you're doing contact tracing, you need a database.

  • yoursunnyyoursunny Member, IPv6 Advocate

    @TimboJones said:

    @yoursunny said:
    No need to bother with QR codes.

    • Every customer must prepare a business card or a piece of paper that has the same information.
    • The guard uses the camera app to take a picture of that paper.
    • Photos are auto-uploaded to Nextcloud.

    Then OCR? A bunch of photos is useless and time consuming later on. Ain't nobody got time for that. The registration and QR code system would have the person's details in useful electronic form.

    If you're doing contact tracing, you need a database.

    No OCR. The patient will tell you where they visited, and you flip through the album from these places and call everyone on the business cards.

  • @yoursunny said:

    @TimboJones said:

    @yoursunny said:
    No need to bother with QR codes.

    • Every customer must prepare a business card or a piece of paper that has the same information.
    • The guard uses the camera app to take a picture of that paper.
    • Photos are auto-uploaded to Nextcloud.

    Then OCR? A bunch of photos is useless and time consuming later on. Ain't nobody got time for that. The registration and QR code system would have the person's details in useful electronic form.

    If you're doing contact tracing, you need a database.

    No OCR. The patient will tell you where they visited, and you flip through the album from these places and call everyone on the business cards.

    I guess you didn't read OP, at all.

  • @edoarudo5 Where are you doing this?

  • @edoarudo5 said:
    The problem is that not every user has a cellphone. A kiosk is too big to put on an establishment entrance. So we plan to require a mobile phone for each establishment with an internet connection. Advantage is that it is low maintenance and can run on mobile data if the establishment's internet connection fails. We actually don't need a check out, just check ins, at least, that's what we all agreed upon on the meeting. You go to an establishment, the security guard scans your QR code and that's it. The mobile app just needs to send the logs to the website.

    Hmm... if that's the case, maybe consider:

    1. Get a cheap 10-11" laptop and connect a 2D-barcode scanner to it (see: https://www.barcodehq.com/5302D.html)

    2. Have excel open and create a simple formula to capture the time when a barcode is scanned. (see: https://excelribbon.tips.net/T013233_Automatically_Entering_a_Data_Entry_Time.html#:~:text=The simplest way to go,time as you want it.)

    3. Email the excel file at the end of the day to a centralised place.

    Thanked by 1edoarudo5
  • jokotanjokotan Member
    edited December 2020

    Guys, you are incredible. Are you really want to destroy your freedom and leave under surveillance? I don't want to talk about this fantasy psychosis lets assume that this is all true. But you want gov to track you only because you want to receive sms notification one day about that you are sick? How did you leave all your life without this before? :smiley: You don't know when you got sick or hungry? You really need some app to notify you?

  • covid-19
    covid-20
    covid-21

    Thanked by 1yoursunny
  • edoarudo5edoarudo5 Member
    edited December 2020

    @FrankZ said:
    @edoarudo5 Where are you doing this?

    Somewhere in the Philippines. A neighboring province already did it so we're doing our own version. No, we can't have their software because money will always be involved, it's just how it works here.

    @jokotan said:
    Guys, you are incredible. Are you really want to destroy your freedom and leave under surveillance? I don't want to talk about this fantasy psychosis lets assume that this is all true. But you want gov to track you only because you want to receive sms notification one day about that you are sick? How did you leave all your life without this before? :smiley: You don't know when you got sick or hungry? You really need some app to notify you?

    You are being overly paranoid. This is how we do it here. We have protocols in place and people abide by it because they're not paranoid like you. That's why we currently only have 1 recorded case in our community with a population of at least 700,000 people because at least 80% of the people here strictly follow protocols. Whenever you go out, everyone has masks and face shields. More than half of us may be maleducated but at least we're not being arrogant or ignorant of the situation we're in right now. Btw, my current work's related to security and privacy and unless you're some hot shit, we don't care about your data.

  • jokotanjokotan Member
    edited December 2020

    @edoarudo5 said:
    You are being overly paranoid. This is how we do it here. We have protocols in place and people abide by it because they're not paranoid like you. That's why we currently only have 1 recorded case in our community with a population of at least 700,000 people because at least 80% of the people here strictly follow protocols.

    You said that 80% of population don't think at all and analyze, but only strictly performs commands? So beautiful. Your gov is very lucky to have such amount of non-thinking and obedient biorobots. At least somewhere communism is near the door.

    Whenever you go out, everyone has masks and face shields. More than half of us may be maleducated but at least we're not being arrogant or ignorant of the situation we're in right now.

    So, for sure you know nothing.... Don't know what to do and only follow party line. Because the party said what you must do... Okay... and you explain this by "at least we do something". Maybe better to jump or sing some songs? This won't help either, but at least you will do something and it will not hurt privacy of individuals. Or party don't want to pay you for singing songs?

    Btw, my current work's related to security and privacy and unless you're some hot shit, we don't care about your data.

    You work related to security and privacy and for that reason you steal privacy and securety from individuals with the system to control them more for no reason? The system that will not give them anything only troubles. Very nice :smiley:

    Thanked by 1anonym_user
  • edoarudo5edoarudo5 Member
    edited December 2020

    @jokotan said:

    You said that 80% of population don't think at all and analyze, but only strictly performs commands? So beautiful. Your gov is very lucky to have such amount of non-thinking and obedient biorobots. At least somewhere communism is near the door.

    It's illogical to make assumptions like that. What do you know about our government? It's called respect within the community. If you don't like the rules, you can go to another local government unit where you're comfortable with their laws. People here are not forced to obey the laws but like other places, you will be penalized for breaking it. Most of the people like to stay here, so most of them abide by the laws. And by the way, most the the people here hate the national government but the same could not be said about our local government. We're doing quite well containing cases related to the pandemic as compared to our neighboring provinces.

    So, for sure you know nothing.... Don't know what to do and only follow party line. Because the party said what you must do... Okay... and you explain this by "at least we do something". Maybe better to jump or sing some songs? This won't help either, but at least you will do something and it will not hurt privacy of individuals. Or party don't want to pay you for singing songs?

    I see that you're well-educated. Telling people that they know nothing will actually prove your point like that pompous jsg fellow. They're free to have their privacy, I am actually the one in-charge of collecting all these data - we don't use this for any other purpose, only for contact tracing. If they feel that somehow it violates their privacy, they can freely move to another province in which they feel their privacy will not be violated.

    You work related to security and privacy and for that reason you steal privacy and securety from individuals with the system to control them more for no reason? The system that will not give them anything only troubles. Very nice .

    You just don't make assumptions like that. Why steal? It is explicitly implied that if you want to go out and enter another establishment, you need to log in. It's like accepting the TOS of the building, if you agree to it, you can enter, if not, you can go to another building. No one is forcing you to log in. If you don't like your privacy breached, don't enter any establishment that follow these rules, you are always free to visit anyone's house (anyone you know) in case you need supplies.

  • @jokotan said:
    Guys, you are incredible. Are you really want to destroy your freedom and leave under surveillance? I don't want to talk about this fantasy psychosis lets assume that this is all true. But you want gov to track you only because you want to receive sms notification one day about that you are sick? How did you leave all your life without this before? :smiley: You don't know when you got sick or hungry? You really need some app to notify you?

    Yes, you're right - you do not know when you're sick. Covid-19 can be asymptomatic at the onset and different people response to the virus can differ from mild to live threatening. Even when a person is not displaying any symptoms of the illness, he/she can still be infectious.

    That's it why it is important to be able to identify people who might be infected, based on their proximity with those identified as positive Covid-19 cases, and get them tested or quarantine before they spread it to more people. Which is the whole idea of why this might be desirable.

    Thanked by 2vimalware dokter
  • In Europe already exist digital identity

  • In Mexico we do:

    We read a QR where we put our phone number on a government website. This website has a database of all establishments and their locations.

    That is all you need.

    Thanked by 1edoarudo5
  • @edoarudo5 said:
    Hello everyone,

    We need:

    A website that lets user register their information (Name, Address, Contact Number) and generate a QR code for them
    The same website that will let establishments register their information
    A mobile app for the establishments that connects to the website's database and syncs all the login information they receive

    They are all just log ins, no log outs. We just basically want to know who logs in at what time in what place and place it real-time on a website (of course the people who can only access the website are people on the CoVid-tracing team). Is there any open source app you know that can be used for this?

    @edoarudo5
    Is it something similar to this project?:
    trackcovid.net/
    The repository is here https://github.com/tyleryasaka/TrackCOVID-community

    Thanked by 1edoarudo5
  • jokotanjokotan Member
    edited December 2020

    @hwt said:
    Yes, you're right - you do not know when you're sick. Covid-19 can be asymptomatic at the onset and different people response to the virus can differ from mild to live threatening. Even when a person is not displaying any symptoms of the illness, he/she can still be infectious.

    That's it why it is important to be able to identify people who might be infected, based on their proximity with those identified as positive Covid-19 cases, and get them tested or quarantine before they spread it to more people. Which is the whole idea of why this might be desirable.

    Wake up, men! It was always exists, all of your previous life, and life of your parents and there parents too. Infections have always existed and asymptomatic carriers not displaying any symptoms of the illness, and people who response different. And some weak people who die, because of the flu. Nothing new under the sun. It's not a reason to support and participate in this hysteria. And throw over freedom and everything of your human been only because of seasonal flu.

  • Everyone's entitled to their own opinion. Freedom comes with responsibility to society as a whole, otherwise, everyone would be allowed to do whatever they want and there would be no prisoners. At least that's my opinion of freedom.

    In this situation, I guess it's a balance between law, privacy and freedom. But then, who am I to dictate what others might think. Just my two cents.

    To each his own.

    Good luck and good health.

    Thanked by 1jokotan
  • drunkendogdrunkendog Member
    edited December 2020

    @jokotan said:
    Guys, you are incredible. Are you really want to destroy your freedom and leave under surveillance? I don't want to talk about this fantasy psychosis lets assume that this is all true. But you want gov to track you only because you want to receive sms notification one day about that you are sick? How did you leave all your life without this before? :smiley: You don't know when you got sick or hungry? You really need some app to notify you?

    Do you actually believe COVID-19 is a hoax? wtf

    Edit: Also, since a significant amount of spread is from asymptomatic carriers, you might not know that you've been infected yet you can still spread the virus. This will completely stop said spread, if everyone potentially infected goes into quarantine

    @edoarudo5 is saving lives with this program, and you shouldn't reward him will bullshit conspiracy theories

    Thanked by 1edoarudo5
  • jokotanjokotan Member
    edited December 2020

    Do you actually believe COVID-19 is a hoax? wtf

    Sort of this to take privacy and security from people, manipulates them, divide and rule. Of course, virus exists. But it's simple some sort of every year flu with mass-media panic. Where do you think every year flu disappeared? Why nobody ill by simple flu? :smiley: It's called covID now and edoarudo5 working to ID everyone.

    Edit: Also, since a significant amount of spread is from asymptomatic carriers, you might not know that you've been infected yet you can still spread the virus. This will completely stop said spread, if everyone potentially infected goes into quarantine

    Oh no, please stop to blindly believe in all of this new narratives. Did you go to school? If yes, then you know that viruses/bacteria spread with sneezing. If you don't sneeze, then you don't spread anything. You want now to sleepy repeat the idea that some "asymptomatic carriers" spread virus with breath? Then you must know from school biologic lessons that first virus enters to the cell, then in replicate and to go out it destroy this cell and "carrier" will always fill this, because when you cells are being destroyed you feel this like sore throat or other signs of the disease. Anyway, if somebody ignore this symptoms and walks down the street and spreads the virus. This is nothing special. Every prev years everything happened the same. The weak were always infected. Someone die from the flu, most of them easy recover. This year, the only difference is mass media panic, other name and guys like edoarudo5 who helps to track everybody. Oh. and masks which helps to multiply bacteria and weakening your immunity, because of prosperous environment after your breeze to the mask and lack of oxygen when your breeze through it. Mask after some time become an excellent soil for inhibiting bacteria. All of this helps to get more cases of bacterial pneumonia this year. Because of this you can search and find statistic that 70-80% is ill now who wear masks everywhere.

    @edoarudo5 is saving lives with this program, and you shouldn't reward him will bullshit conspiracy theories

    Yeah, we all must blindly believe only in party line! Party never lie everyone know.

    Interesting how did you call 'conspiracy theories' simple biology from mine school classes, but that was a long time ago, now probably a new biology exists.

    Perhaps this is why 'hand washing' is presented on TV as something incredible and new for masses as if nobody knew before to wash their hands after come home

  • it need custom solution, if you can't do this yourself then hire somebody.

    Thanked by 1edoarudo5
  • @verd said:

    @edoarudo5 said:
    Hello everyone,

    We need:

    A website that lets user register their information (Name, Address, Contact Number) and generate a QR code for them
    The same website that will let establishments register their information
    A mobile app for the establishments that connects to the website's database and syncs all the login information they receive

    They are all just log ins, no log outs. We just basically want to know who logs in at what time in what place and place it real-time on a website (of course the people who can only access the website are people on the CoVid-tracing team). Is there any open source app you know that can be used for this?

    @edoarudo5
    Is it something similar to this project?:
    trackcovid.net/
    The repository is here https://github.com/tyleryasaka/TrackCOVID-community

    Thank you for this. This is good but lacks the paper code functionality. Majority of our community is poor so there are lots of people that have no mobile devices.

  • edoarudo5edoarudo5 Member
    edited December 2020

    @jokotan said:

    Sort of this to take privacy and security from people, manipulates them, divide and rule. Of course, virus exists. But it's simple some sort of every year flu with mass-media panic. Where do you think every year flu disappeared? Why nobody ill by simple flu? :smiley: It's called covID now and edoarudo5 working to ID everyone.

    We are working to ID everyone, for a cause that everyone knows, that is. And we're being transparent about it, we're not employing some sneaky tactics to steal their data and use it for some nefarious reasons like you think. We're asking for it because we need it and we're asking for everyone's participation. I'm so glad people here aren't so close-minded as you are, because unlike developed countries, our community would collapse if this virus were to spread here. Our hospitals (we have around 10 for over 700,000 people! not everyone would get sick but imagine if even a small percentage of that gets sick) doesn't have the necessary number of people or equipments to deal with a massive influx of CoVid patients. If your concern is privacy, majority of our people's main concern is money. A lot of us don't have it. A lot of us don't have money to go to hospitals to spend or eat food 3 times a day. I hope you get my point. We're just trying our best on what we can do to prevent the spread of this disease in our community. We don't have fancy hospitals or world-class doctors here.

    Oh no, please stop to blindly believe in all of this new narratives. Did you go to school? If yes, then you know that viruses/bacteria spread with sneezing. If you don't sneeze, then you don't spread anything. You want now to sleepy repeat the idea that some "asymptomatic carriers" spread virus with breath? Then you must know from school biologic lessons that first virus enters to the cell, then in replicate and to go out it destroy this cell and "carrier" will always fill this, because when you cells are being destroyed you feel this like sore throat or other signs of the disease. Anyway, if somebody ignore this symptoms and walks down the street and spreads the virus. This is nothing special. Every prev years everything happened the same. The weak were always infected. Someone die from the flu, most of them easy recover. This year, the only difference is mass media panic, other name and guys like edoarudo5 who helps to track everybody. Oh. and masks which helps to multiply bacteria and weakening your immunity, because of prosperous environment after your breeze to the mask and lack of oxygen when your breeze through it. Mask after some time become an excellent soil for inhibiting bacteria. All of this helps to get more cases of bacterial pneumonia this year. Because of this you can search and find statistic that 70-80% is ill now who wear masks everywhere.

    Yeah, we all must blindly believe only in party line! Party never lie everyone know.

    Interesting how did you call 'conspiracy theories' simple biology from mine school classes, but that was a long time ago, now probably a new biology exists.

    Perhaps this is why 'hand washing' is presented on TV as something incredible and new for masses as if nobody knew before to wash their hands after come home

    I can't even... But you know, if that's what you think, I respect that.

  • webcraftwebcraft Member
    edited December 2020

    I think it's important to note that it's definitely worth to find ways stopping the spread of a truly dangerous disease.
    Maybe you should redefine the data requirements since keeping the gathered data at a minimum and make transparent when they are deleted (maybe 5 days after no positiv test result) is necessary imo. An anonymous QR-code that you distribute in form of either a paper or within an app that is just connected to a phone number or email-adress (no name, address etc.) should be sufficient. ..like @Hosterlabs explained and from functionality like @hwt explained, though you didn't completely like this idea but it could be a point where to start. Everything else might end costly when no coding resources available.

    Thanked by 1edoarudo5
  • timelapsetimelapse Member
    edited December 2020

    what province is this? are you selling this off to the lgu?

    in my understanding there is already an official app for this? why not promote that app instead?

    Thanked by 1edoarudo5
  • edoarudo5edoarudo5 Member
    edited December 2020

    @timelapse said:
    what province is this? are you selling this off to the lgu?

    in my understanding there is already an official app for this? why not promote that app instead?

    What is the official app for this? Because we will be using that instead. If you want to know the province, PM me with the official app. And no, we will not be selling this to the LGU, lol.

    Edit: Replied to PM and it indeed is the official app but not the app we need.

  • @edoarudo5 said:

    This is good but lacks the paper code functionality.

    @edoarudo5.
    Can you explain more about "lacks the paper code functionality".

    Majority of our community is poor so there are lots of people that have no mobile devices.

    The project I mentioned needs to be modified in some extends to acommodate your requirement. Most functions seems already there.

Sign In or Register to comment.