code.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * Serving Flask app \"__main__\" (lazy loading)\n",
      " * Environment: production\n",
      "   WARNING: This is a development server. Do not use it in a production deployment.\n",
      "   Use a production WSGI server instead.\n",
      " * Debug mode: off\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      " * Running on http://0.0.0.0:10001/ (Press CTRL+C to quit)\n",
      "127.0.0.1 - - [02/Nov/2020 17:52:39] \"GET / HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [02/Nov/2020 17:52:40] \"GET /admin HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [02/Nov/2020 17:52:44] \"GET /admin?id=faculty123&pass=12345 HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [02/Nov/2020 17:52:46] \"GET /activate HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [02/Nov/2020 17:52:49] \"GET / HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [02/Nov/2020 17:53:42] \"GET /student HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [02/Nov/2020 17:53:49] \"POST /add HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [02/Nov/2020 17:53:49] \"GET /sub/4 HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 17:53:55] \"GET / HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 17:53:56] \"GET /student HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 17:54:02] \"POST /add HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 17:54:02] \"GET /sub/2 HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 17:54:05] \"POST /add HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 17:54:05] \"GET /sub/4 HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 18:01:20] \"GET / HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 18:01:20] \"GET /static/css/homepage.css HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 18:01:20] \"GET /favicon.ico HTTP/1.1\" 404 -\n",
      "192.168.0.103 - - [02/Nov/2020 18:01:20] \"GET /static/images/homepage.png HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 18:01:24] \"GET /student HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 18:01:24] \"GET /static/css/attendance.css HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 18:01:24] \"GET /static/images/attendance.png HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 18:01:29] \"POST /add HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 18:01:29] \"GET /sub/4 HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 18:01:30] \"GET /static/css/submit.css HTTP/1.1\" 200 -\n",
      "192.168.0.103 - - [02/Nov/2020 18:01:30] \"GET /static/images/submit.png HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:03:56] \"GET / HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:03:57] \"GET /static/css/homepage.css HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:03:57] \"GET /static/images/homepage.png HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:03:57] \"GET /favicon.ico HTTP/1.1\" 404 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:03:59] \"GET /student HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:03:59] \"GET /static/css/attendance.css HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:04:00] \"GET /static/images/attendance.png HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:04:10] \"POST /add HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:04:10] \"GET /sub/2 HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:04:10] \"GET /static/css/submit.css HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:04:10] \"GET /static/images/submit.png HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:04:17] \"POST /add HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:04:17] \"GET /sub/4 HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:04:31] \"POST /add HTTP/1.1\" 200 -\n",
      "192.168.0.101 - - [02/Nov/2020 18:04:31] \"GET /sub/1 HTTP/1.1\" 200 -\n"
     ]
    }
   ],
   "source": [
    "from flask import Flask,render_template,request\n",
    "import csv\n",
    "import socket\n",
    "from datetime import datetime,date\n",
    "\n",
    "nam = 'Mr P. Verma'\n",
    "ID = 'faculty123'\n",
    "pwd = '12345'\n",
    "perm = False\n",
    "data=[]\n",
    "final=[]\n",
    "\n",
    "s = socket.socket(socket.AF_INET, socket.SOCK_DGRAM)\n",
    "s.connect((\"8.8.8.8\", 80))\n",
    "ip = (s.getsockname()[0])\n",
    "s.close()\n",
    "\n",
    "app = Flask(__name__)\n",
    "\n",
    "@app.route('/',methods=['POST','GET'])\n",
    "def home():\n",
    "    return render_template('homepage.html')\n",
    "\n",
    "@app.route('/admin')\n",
    "def admin():\n",
    "    if(request.args.get('id')==ID and request.args.get('pass')==pwd):\n",
    "        i=0\n",
    "        global data\n",
    "        data=[]\n",
    "        with open('Name_List.csv', 'r') as file:\n",
    "            reader = csv.reader(file)\n",
    "            for row in reader:\n",
    "                i+=1\n",
    "                if(i==1): continue\n",
    "                data.append(row)\n",
    "        return render_template('dashboard.html',name=nam,status='INACTIVE',dat = data, col = '#dd7f1e',ip=ip)\n",
    "    elif(request.args.get('id')==None and request.args.get('pass')==None):\n",
    "        return render_template('login.html')\n",
    "    else:\n",
    "        return render_template('submit.html',a='Oops !!!',b='Invalid credentials have been entered.')\n",
    "    \n",
    "@app.route('/activate')\n",
    "def activate():\n",
    "    global perm\n",
    "    perm = True\n",
    "    return render_template('dashboard.html',name=nam,status='ACTIVE',dat = data, col = '#48695c',ip=ip)\n",
    "\n",
    "@app.route('/revoke')\n",
    "def revoke():\n",
    "    global perm\n",
    "    perm = False\n",
    "    return render_template('dashboard.html',name=nam,status='INACTIVE',dat = data, col = '#dd7f1e',ip=ip)\n",
    "\n",
    "@app.route('/generate')\n",
    "def generate():\n",
    "    global perm\n",
    "    perm = False\n",
    "    i=0\n",
    "    nums=dict()\n",
    "    with open('temp.csv', 'r') as file:\n",
    "        reader = csv.reader(file)\n",
    "        for row in reader:\n",
    "            i+=1\n",
    "            if(i==1): continue\n",
    "            nums[row[0]]=row[2].split(' ')[1]\n",
    "    global final\n",
    "    final=[]\n",
    "    for j in data:\n",
    "        if(j[1] in nums.keys()):\n",
    "            final.append(['#48695c',j[0],j[1],j[2],nums[j[1]],'Present'])\n",
    "        else:\n",
    "            final.append(['#dd7f1e',j[0],j[1],j[2],'NA','Absent'])\n",
    "    dat = str(date.today())\n",
    "    with open('Attendance_'+dat+'.csv', 'w', newline='\\n') as csvfile:\n",
    "        wrt = csv.writer(csvfile, delimiter=',')\n",
    "        wrt.writerow(['Serial No.','Registration No.','Name','Timestamp','Status'])\n",
    "        for i in final:\n",
    "            wrt.writerow(i[1:])\n",
    "    with open('temp.csv', 'w', newline='\\n') as csvfile:\n",
    "        wrt = csv.writer(csvfile, delimiter=',')\n",
    "        wrt.writerow(['Registration Number','Fingerprint','Timestamp'])\n",
    "    return render_template('report.html',name=nam,data=final,index='0')\n",
    "\n",
    "@app.route('/all')\n",
    "def allfunc():\n",
    "    return render_template('report.html',name=nam,data=final,index='0')\n",
    "\n",
    "@app.route('/present')\n",
    "def present():\n",
    "    pres=[]\n",
    "    for i in final:\n",
    "        if(i[5]=='Present'):\n",
    "            pres.append(i)\n",
    "    if(len(pres)==0):\n",
    "        pres.append(['#dd7f1e','NA','NA','NA','NA','NA'])\n",
    "    return render_template('report.html',name=nam,data=pres,index='1')\n",
    "\n",
    "@app.route('/absent')\n",
    "def absent():\n",
    "    absent=[]\n",
    "    for i in final:\n",
    "        if(i[5]=='Absent'):\n",
    "            absent.append(i)\n",
    "    if(len(absent)==0):\n",
    "        absent.append(['#dd7f1e','NA','NA','NA','NA','NA'])\n",
    "    return render_template('report.html',name=nam,data=absent,index='2')\n",
    "\n",
    "@app.route('/toggle/<id>',methods=['GET'])\n",
    "def toggle(id):\n",
    "    global final\n",
    "    for i in range(len(final)):\n",
    "        if(final[i][1]==id):\n",
    "            if(final[i][5]=='Absent'): \n",
    "                final[i][5]='Present'\n",
    "                now = datetime.now()\n",
    "                final[i][4]= now.strftime(\"%H:%M:%S\")\n",
    "                final[i][0]='#48695c'\n",
    "            else: \n",
    "                final[i][5]='Absent'\n",
    "                final[i][4]='NA'\n",
    "                final[i][0]='#dd7f1e'\n",
    "    dat = str(date.today())\n",
    "    with open('Attendance_'+dat+'.csv', 'w', newline='\\n') as csvfile:\n",
    "        wrt = csv.writer(csvfile, delimiter=',')\n",
    "        wrt.writerow(['Serial No.','Registration No.','Name','Timestamp','Status'])\n",
    "        for i in final:\n",
    "            wrt.writerow(i[1:])\n",
    "    return render_template('report.html',name=nam,data=final,index='0')\n",
    "\n",
    "@app.route('/student')\n",
    "def student():\n",
    "    return render_template('attendance.html')\n",
    "\n",
    "@app.route('/add', methods=['POST','GET'])\n",
    "def add():\n",
    "    if(perm==False):\n",
    "        return '0'\n",
    "    num = request.form['number']\n",
    "    fp = request.form['fp']\n",
    "    i=0\n",
    "    numbers = []\n",
    "    with open('Name_List.csv', 'r') as file:\n",
    "        reader = csv.reader(file)\n",
    "        for row in reader:\n",
    "            i+=1\n",
    "            if(i==1): continue\n",
    "            numbers.append(row[1])\n",
    "    if(num not in numbers):\n",
    "        return '1'\n",
    "    else:\n",
    "        i=0\n",
    "        nums = []\n",
    "        fps = []\n",
    "        with open('temp.csv', 'r') as file:\n",
    "            reader = csv.reader(file)\n",
    "            for row in reader:\n",
    "                i+=1\n",
    "                if(i==1): continue\n",
    "                nums.append(row[0])\n",
    "                fps.append(row[1])\n",
    "        if(num in nums):\n",
    "            return '2'\n",
    "        elif(fp in fps):\n",
    "            return '3'\n",
    "        else: \n",
    "            now = datetime.now()\n",
    "            time = now.strftime(\"%d/%m/%Y %H:%M:%S\")\n",
    "            with open('temp.csv', 'a', newline='\\n') as csvfile:\n",
    "                wrt = csv.writer(csvfile, delimiter=',')\n",
    "                wrt.writerow([num] + [fp] + [time])\n",
    "            return '4'\n",
    "\n",
    "@app.route('/sub/<ans>', methods=['POST','GET'])\n",
    "def sub(ans):\n",
    "    if(ans=='0'):\n",
    "        return render_template('submit.html',a='Oops !!!', b='Attendance link is inactive.')\n",
    "    elif(ans=='1'):\n",
    "        return render_template('submit.html',a='Oops !!!', b='Invalid Registration Number entered.')\n",
    "    elif(ans=='2'):\n",
    "        return render_template('submit.html',a='Oops !!!', b='Duplicate attendence.')\n",
    "    elif(ans=='3'):\n",
    "        return render_template('submit.html',a='Oops !!!', b='Device has already been used in this session.')\n",
    "    else:\n",
    "        return render_template('submit.html',a='Thank You', b='Your attendence has been successfully registered.')\n",
    "\n",
    "app.run('0.0.0.0', 10001)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}