 just wanted to share some software that I've been working on here for guardhouses for gated communities and such to make it quick and easy for the guard at the gate to see who's allowed through the gate and log who comes and goes and if you've seen pure software I did use my cookbook application that I wrote for my wife as a base for this although this is a bit more complicated there's a bit more forms in here but let's go ahead and have a quick look at this so I filled in some fake information here right now you can currently see that there are six residents in the database I just made up fake information but let's go ahead and create a new resident so I'm gonna go new resident and we'll say Thomas Pickle we'll say is his name and he lives at eight six eight river turn drive or drive there we go and we'll say his phone number is 555 555 8585 and if you had a second phone we could put that there other residents would be let's say his wife or girlfriend or maybe some teenagers living at the house or if he has a roommate let's go ahead and put somebody in there we'll say that Thomas Pickle has a girlfriend and her name is Jennifer Smith sure all right have a couple Smiths in the database but we'll do that actually let's do something else let's do I'll make up a name Jennifer face there we go now guest sometimes at these gay neighborhoods you have regular visitors so you can put guests that are allowed in that guard doesn't have to call and say hey so-and-so's here if this person shows up go ahead and let them through and we'll just say Frank Bonnie sure and then comments can be any comments like don't call after 10 p.m. that way if anyone comes by 10 p.m. the guard's not supposed to call the house so go ahead and we'll click submit and that's safe we can still make some changes here if we want let's click on home and go back to our database our our main list here you can see currently there are seven residents in the database let's go ahead and look for our Thomas Pickle obviously right here you can see him already but let's pretend there's a thousand people on this list I can type in pickle and they're right away the guard goes oh Thomas Pickle let's say Frank Bonnie shows up he goes oh you're allowed in I can go ahead I don't have to call I'll just let you right in so I'll click on that and right away it brings up here if you needed to call you know Thomas Pickle there's the phone numbers up at the top there and if you have a hidden device card reader you can swipe their driver's license in this field and will automatically fill in their first name last name and address but let me go ahead and type in Frank Bonnie here and we'll say his address is 123 12th Avenue blah blah blah I'll get his license plate number off his car and any comments that I want to put in there I'll click submit and he goes in again if you swipe the the driver's license the only thing you really have to put in there is the tag number so he's in and after a few seconds goes back to the list view here because the next car will be driving up and I can start searching for them and again I can search as we did for Pickle but if they come here and say hey I'm here to see Jennifer base she shows up as well because she's an other resident in that house but if I do Frank you can see that Frank Bonnie doesn't show up because doesn't search visitors just residents at this screen okay now let's say a resident shows up and says hey I just was wondering who do you have logged that visit me recently let's say it's Thomas Pickle I can click here on history and it brings me to this menu of history I did a slightly different color just to so you don't get confused on what screen you're at and let's type in Pickle and you can say oh let's see Bonnie Frank visited at you know this date and time his address is this his tag is this and he visited Thomas Pickle which is what we just searched based on I can also say you know if they Thomas Pickle drives up and says hey has um Bonnie Frank Frank Bonnie come through you can type in Bonnie and also searches that so it searches both the visitor and the resident in the history view here okay so now let's go back to the home screen let's say we'll just use Tom Pickle Thomas Pickle I just realized I named him Thomas Pickle isn't that funny like Tommy Pickles anyway um type in Pickle here that was completely subconscious that I did that let's say Thomas Pickle calls because he bothers the guard at the gate a lot so now he's calling and he's saying hey I'm expecting um or I want to change my phone number I want to add a phone number so if I'm not available you can call this other phone number and get my girl friend Jennifer base so you go okay click here and then you can click anywhere up in this gray box and it brings you to that user to that resident and you can modify any of the information so now we can come in here and we can say okay if the first phone number is busy call the second phone number which is 555-555-5858 submit and then if I go back home and I type in Pickle you can click here and see the second phone number shows up so it's very simple to change the information that way now let's say uh we'll use a different resident uh a resident at this case I'll say um now we get a phone call from Terry Klein you type in Klein Terry Klein says hey I'm expecting uh the cable guy to come sometime between 10 a.m. and 10 p.m. today because that's how cable guys roll you can click on Terry Klein here click on here and go down to comments which you can put anything in here and they show up on the main search so you can say cable guy between 10 a.m. and 10 p.m. um whatever day they want we'll say 2015 that's today I'll click submit it tells you that it has been entered I can go back home now and now cable guy shows up later on maybe there's a different guy on the gate or you just forgot we type in Klein whoops and he shows right here expecting cable guy between 10 and 10 p.m. you can write other notes you know um don't call just let them do or let me know when they're here or whatever but here you know that he is expecting the cable guy so you can come in here you can check in the cable guy when you're done you can come in here clear out the comment click submit and it's cleared out so now we go back here we can type in Klein and you can see that comment is now removed so this is an application I wrote and pretty straightforward and simple to use again works great on tablets and phones and all you need to do is you know set up a server to run it on which is very simple and easy to do and I just thought I'd show the overview of this also if we click up the top here where it says project page it will bring you to the source code if you want to get this it is up on my github page uh username metal x1000 it's called the open gate and it is under an agpl license so I thank you for watching this video maybe you'll find the software useful maybe you'll want to add to it and uh I just hope that you have a great day