def get(self, request):
user = request.user
if (user.email == "ADMIN" or user.email == "PETUGAS"):
data = ConnectDB.getDataWithQuery(
'''
SELECT l.*
FROM anggota a, laporan l, person p
WHERE p.ktp = a.ktp AND a.no_kartu = l.no_kartu_anggota AND p.ktp = %s
''', [user.username])
return Response(data)
else:
return Response([{}])
def get(self, request):
user = request.user
if user.email == 'ANGGOTA':
data = ConnectDB.getDataWithQuery(
'''
SELECT m.*
FROM anggota a, peminjaman m, person p
WHERE p.ktp = a.ktp AND a.no_kartu = m.no_kartu_anggota AND p.ktp = %s
''', [user.username])
return Response(data)
else:
return Response([{}])
def get(self, request):
user = request.user
if (user.email == "ANGGOTA"):
data = ConnectDB.getDataWithQuery(
'''
SELECT t.* FROM transaksi t, anggota a, person p
WHERE p.ktp = a.ktp AND a.no_kartu = t.no_kartu_anggota AND
p.ktp = %s
''', [user.username])
return Response(data)
else:
return Response([{}])
def get(self, request):
user = request.user
if (user.email == 'ADMIN' or user.email == 'PETUGAS' or user.email == 'ANGGOTA'):
data = ConnectDB.getDataWithQuery(
'''
SELECT v.*
FROM anggota a, voucher v, person p
WHERE p.ktp = a.ktp AND a.no_kartu = v.no_kartu_anggota AND p.ktp = %s
''', [user.username])
return Response(data)
else:
return Response([{}])
def get(self, request):
user = request.user
if (user.email == "ADMIN" or user.email == "PETUGAS"):
data = ConnectDB.getDataWithQuery(
'''
SELECT s.* FROM penugasan s, person p
WHERE p.ktp = s.ktp AND
p.ktp = %s
''', [user.username]
)
return Response(data)
else:
return Response([{}])