RasPiDoorLock/rfiddl.py at master · athasamid/RasPiDoorLock · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
#!/usr/bin/env python
# -*- coding: utf8 -*-
# Credit to mxgxw whose program this is based on

import RPi.GPIO as GPIO
import MFRC522
import signal
import time
import MySQLdb
import datetime
from socketIO_client import SocketIO

db = MySQLdb.connect("localhost", "root", "root", "door_lock")

socketIO = SocketIO('localhost', 8000)
# Card Register

#GPIO setup

continue_reading = True

def end_read(signal,frame):
    global continue_reading
    print "Ctrl+C captured, ending read."
    continue_reading = False
    GPIO.cleanup()

def on_open_door(*args):
   print("open_door", args)
   GPIO.setup(11, GPIO.OUT)
   print "Door open"
   time.sleep(5)
   GPIO.setup(11, GPIO.IN)
   print "Finished"

# socketIO.wait();
# Hook the SIGINT
signal.signal(signal.SIGINT, end_read)

# Create an object of the class MFRC522
MIFAREReader = MFRC522.MFRC522()

while continue_reading:

# Scan for cards
    (status,TagType) = MIFAREReader.MFRC522_Request(MIFAREReader.PICC_REQIDL)

    # If a card is found
    if status == MIFAREReader.MI_OK:
        print "Card detected"

    # Get the UID of the card
    (status,uid) = MIFAREReader.MFRC522_Anticoll()

    # If we have the UID, continue
    if status == MIFAREReader.MI_OK:

        # Print UID
        UIDcode = str(uid[0])+str(uid[1])+str(uid[2])+str(uid[3])
        print UIDcode


        # Control door lock
        statusFile = open('/home/pi/status.txt', 'r')
        locked = statusFile.readline()
        statusFile.close()
        statusFile2 = open('/home/pi/status2.txt', 'r')
        openTrigSwitch = statusFile2.readline()
        statusFile2.close()

        curs=db.cursor()
        curs.execute("select * from user where rfid = %s", UIDcode);
        user = curs.fetchall()
        if len(user) > 0:
            if locked == '0' or user[0][5] == 1:
                socketIO.emit('new activity', {'nama' : user[0][1], 'date' : datetime.datetime.now().strftime("%d %B %Y at %I:%M%p")})
                curs.execute("""insert into log (id_user, waktu) values (%s, now())""", user[0][0])
                db.commit()
                GPIO.setup(11, GPIO.OUT)
                print "Door open"
                time.sleep(5)
                GPIO.setup(11, GPIO.IN)
                print "Finished"
            else:
                print "Door locked";
        else:
            print "Unrecognised Card";

        # if UIDcode == cameroncard:
        #     adminpriv = 1
        # else:
        #     adminpriv = 0

        # if UIDcode == cameroncard or UIDcode == lisacard or UIDcode == colincard:
        #     if locked == '0' or adminpriv == 1:
        #         GPIO.setup(11, GPIO.OUT)
        #         print "Door open"
        #         time.sleep(3)
        #         GPIO.setup(11, GPIO.IN)
        #         print "Finished"
        #     else:
        #         print "Door locked"
        # elif UIDcode == lockcard:
        #     counter = 0
        #     if locked == '0':
        #         while counter <> 5:
        #             GPIO.setup(11, GPIO.OUT)
        #             time.sleep(0.05)
        #             GPIO.setup(11, GPIO.IN)
        #             time.sleep(0.05)
        #             counter = counter + 1
        #         locked = 1
        #         time.sleep(3)
        #     else:
        #         while counter <> 2:
        #             GPIO.setup(11, GPIO.OUT)
        #             time.sleep(0.5)
        #             GPIO.setup(11, GPIO.IN)
        #             time.sleep(0.05)
        #             counter = counter + 1
        #         locked = 0
        #         time.sleep(3)

        #     fh = open('status.txt', 'w')
        #     fh.write(str(locked))
        #     fh.close()

        # else:
        #     print "Unrecognised Card"

socketIO.on('open door', on_open_door)