Find Jobs
Hire Freelancers

RFID card reader/logger on raspberry pi, back end SQL database with Web functions.

€30-250 EUR

已完成
已发布将近 7 年前

€30-250 EUR

货到付款
My goal is to have a RFID card reader which could log card IDs and time stamps, do couple verification steps once card is read, sync data with back end database. Back-end should have a Web app to review, parse add/edit data, calculate time spent for each card. ----------- Equipment ----------- - Raspberry Pi 3, currently running jessie, if required could be changed to other distro. - RC522 card reader - [login to view URL] Reader already connected to a raspberry and is able to read the cards - python based script. - Few LEDs and a buzzer ([login to view URL]), already connected and triggered by python script module. - Back-end server. I will be able to provide a VM with desired OS to host a database (MySQL, MSSQL or any other desired) and the website. ----------- Programming details----------- Reader: Once raspberry boots up it starts a script which waits for cards; Once card is detected - unique ID is read (uid - etc: [6, 186, 170, 133, 147] ) verification executed. 1.1. if uid is known; Check against ID list which was defined in database earlier; 1.2. check if card was logged before on the same device, assign state value (IN or OUT) opposite to latest entry (Boolean value will work here). 1.3 if above checks success - log stamp - uid, timestamp, state, device name. Submit logged entries to back-end. Raspberry should be able to operate with out internet for couple of days and sync data afterwards. #Comment. I was experimenting with local .txt files for storing known id list, in/out table and log (have coded those parts successfully separately , but i'm not able to perform verification successfully in one script loop pass in python.). Thinking about local MySQL instance on a raspberry to store that data and do another script to sync local MySQL to back end MySQL. Pull known IDlist table and push Log. Database plan: (can be changed if required) Back-end database will be running on a VM will have few tables such as: idlist uid, cardnumber, card_owner, active; datalog uid; date; time; state; device; Web app requirements: To a be able to assign values to certain uid, such as card owner name, card number, set card as active, etc. To pull report for time spent in last 1 day, 7 days, 1 month and so on, query based on specific card or specific device which collected the data or overall. Edit certain entries in datalog table if required if those does not make sense. I will be able to provide direct access to the raspberry via ssh with all components connected and to the VM on the same Vlan. I'm looking for a person who has competence to code all above or in parts. Part 1. Rasberrypi reader with database Part 2. Web app. PM for more details.
项目 ID: 13838394

关于此项目

14提案
远程项目
活跃7 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi there! I would love to help you. tl; dr of the project is to read the RFID card and store the data. Then show it nicely in a webserver; right? I have experience with python/mysql/ and linux it self. I have few raspberry pi (but not the rfid card reader) so I can help you setting up the system in case something needs to be changed. Thanks, Ignacio.-
€250 EUR 在3天之内
5.0 (36条评论)
4.9
4.9
14威客以平均价€214 EUR来参与此工作竞价
用户头像
FREELANCER RECOMMENDED ------------------------------------------------------ Can help... I am an Expert... Lets Start! Please start a Discussion with me and we can get started from there... Please check the past projects I have handled and check my reviews for what employers have to say about my work... Can start right now...
€155 EUR 在3天之内
5.0 (47条评论)
6.5
6.5
用户头像
Hi, Can you share more details? Thanks David 30+ years C/Unix-HP-UX-Solaris-AIX/Linux programmer, performance +10 years embedded Linux (openwrt/raspberry/odroid) & Arduino. Oracle OVM admin Unix/Linux Kernel support & dev Python dev. PHP dev. Uni* scripting TCP/IP dev. mysql/mariadb/sql adm&dev NFS (admin & rpc programming) XML
€244 EUR 在5天之内
5.0 (25条评论)
6.0
6.0
用户头像
Hello, Greetings!!! Hope you are doing great..!! I have carefully reviewed the requirement. I am very much interested in this project and would like to work with you on your important project. Kindly share the detailed requirement, so I can work out on that and will give you specific time frame and cost. I have mentioned the estimated cost in a bid which is subject to vary depends on the final scope. I can start working on the project immediately. I’m glad to answer any question you may have! Looking for a favorable consideration and let me know to move further! Many Thanks & Regards, Rishi A.
€177 EUR 在20天之内
5.0 (58条评论)
5.5
5.5
用户头像
Hi Sir, Nearly ready solution for you just days ago finished similar project with rpi, MFRC522 and mysql. We offer our services at very feasible rates. Please discuss with us in details. We are team of developers and engineers professional in designing electronic circuit solutions, pcb designs, database programming such as MySQL etc, software designs and GUI/UI development, android applications, integrating software and hardware and providing complete solutions. In this bid, we offer you our solution at very low and affordable rates based on your desired requirements. we normally follow several checks to ensure the quality of service and products. In this bid prototyping is not included, if at certain point you would like to have prototypes manufactured, we can provide you at minimal cost including courier charges (DHL/FedX etc). We, very humbly deal with our clients and provide technical support to them during all phases of project execution. We are very much looking forward to hear from you in coming days. Cheers, Ahmad Lead Technical Engineer Turktronics Inc. An Internet of Things Company
€200 EUR 在5天之内
4.9 (18条评论)
5.6
5.6
用户头像
I can help you with that. I have done a similar project before. I can help you with that. I have done a similar project before.
€277 EUR 在3天之内
5.0 (11条评论)
4.8
4.8
用户头像
i am working as assistant technical manager. I have designed pakistan's 1st RFID debit card system for amusement parks. i have 5 year experience to work with microcontroller, single board computer , PLC , arduino , labview , visual basic , Report writing e.t.c. i can complete your project as you like
€200 EUR 在3天之内
4.4 (4条评论)
3.0
3.0
用户头像
Give us a chance to prove that your decision was best. We are providing the services by which customers are satisfied.
€155 EUR 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
I'm a hard worker, self-motivated one with a great desire to pursuit myself and be one of the top in my field and i believe that anyone can be a very successful person in any field by working hard, thinking different and of course believe in his/her strengths and enhancing his/her weaknesses. And for me now, i'm seeking a challenging position in a reputable firm where I can prove my skills, add new skills to myself and gain new experience. And also helping in firm’s success, accomplishing objectives, effectiveness and efficiency
€155 EUR 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Having practical experience of development in this area through some starling concepts. May be next one is yours . You may also wish to review my portfolio in order to check my previous work and learn more about my skill. Thank you
€400 EUR 在7天之内
5.0 (10条评论)
0.0
0.0

关于客户

LITHUANIA的国旗
Vilnius, Lithuania
0.0
0
会员自4月 25, 2017起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。