A tutorial with examples of Python's Tornado framework for data visualization

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import 

import 
import 
import 
import 
import 
import 
from  import define, options

import pymongo
import time
import datetime
import xlrd

define("port", default=8007, help="run on the given port", type=int)

class Application():
  def __init__(self):
    handlers = [
      (r"/", MainHandler),
      (r"/read", ReadHandler),
      (r"/day", DayHandler),
    ]
    settings = dict(
      template_path=((__file__), "templates"),
      static_path=((__file__), "static"),
      debug=True,
      )
    conn = ("localhost", 27017)
     = conn["kaoqin"]
    .__init__(self, handlers, **settings)


class MainHandler():
  def get(self):
    pass

class ReadHandler():
  def get(self):
    #GetCollection
    coll_record = 
    coll_user = 
    #Read excel sheet
    table = xlrd.open_workbook('/Users/ant/Webdev/python/excel/')
    #Read the punch list sheet
    sheet=table.sheet_by_index(2)
    #Read clock-in month range
    row3 = sheet.row_values(2)
    m1 = int(row3[2][5:7])
    m2 = int(row3[2][18:20])
    #Set the current year
    y = int(row3[2][0:4])
    # Set the current month as the first month
    m = m1
    #Read punch date range
    row4 = sheet.row_values(3)
    # Initialize the previous day
    lastday = row4[0]
    # Iterate through the dates in the fourth row
    for d in row4:
      # If the date is less than the previous date
      # Explain that if the month is increased, then the current month will be changed to the second month.
      if d < lastday:
        m = m2
        # If the two current months are December and January respectively
        #States that the year has crossed over, so year +1
        if m1 == 12 and m2 == 1:
          y = y + 1
      # counted by n, ranging from 3 to (total number of rows/2+1)
      # (Total lines/2+1) - 3 = Total users
      # i.e. iterating over all users
      for n in range(3, /2+1):
        # Take the first line of the user, i.e. the user information line
        row_1 = sheet.row_values(n*2-2)
        # Get user id
        u_id = row_1[2]
        # Get user name
        u_name = row_1[10]
        # Access to user departments
        u_dept = row_1[20]
        # Query the user
        user = coll_user.find_one({"id":u_id})
        # Create a new user if the user does not exist in the database
        if not user:
          user = dict()
          user['id'] = u_id
          user['name'] = u_name
          user['dept'] = u_dept
          coll_user.insert(user)
        # Fetch the second line of the user, the attendance record line
        row_2 = sheet.row_values(n*2-1)
        # Get the subscript to change the current date
        idx = (d)
        # Get the current user's attendance record for the current date
        check_data = row_2[idx]
        # Initialize empty attendance record list
        check = list()
        # In groups of 5 characters, iterates through the attendance records and deposits them in the attendance records list
        for i in range(0,len(check_data)/5):
          (check_data[i*5:i*5+5])
        # Query the current user's record for the day
        record = coll_record.find_one({"y":y, "m":m, "d":d, "id":user['id']})
        # Update the record if it exists
        if record:
          for item in check:
            # Add new attendance records to previous records
            if item not in record['check']:
              record['check'].append(item)
              coll_record.save(record)
        # Insert new record if record does not exist
        else:
          record = {"y":y, "m":m, "d":d, "id":user['id'], "check":check}
          coll_record.insert(record)

class DayHandler():
  def get(self):
    # Get year, month and day parameters
    y = self.get_argument("y",None)
    m = self.get_argument("m",None)
    d = self.get_argument("d",None)
    # Determine if the parameters are fully set
    if y and m and d:
      # Convert parameters to integers for ease of use
      y = int(y)
      m = int(m)
      d = int(d)
      # Get all records for the day
      coll_record = 
      record = coll_record.find({"y":y, "m":m, "d":d})
      # Get the day of the week
      weekday = (y,m,d).strftime("%w")
      # Get the duty roster for the day
      coll_duty = 
      duty = coll_duty.find_one({"id":int(weekday)})
      # Initialize empty target records (duty officer records for the day)
      target = list()
      # Iterate over all records of the day
      for item in record:
        # When the user of the record has a duty assignment for that day, it is calculated and stored in the target array
        if int(item['id']) in duty['list']:
          # Get the start and end of the user's shift by user id
          start = duty[item['id']][0]
          end = duty[item['id']][1]
          # of hours/seconds of calculated duty
          date1 = (y,m,d,int(start[:2]),int(start[-2:]))
          date2 = (y,m,d,int(end[:2]),int(end[-2:]))
          item['length'] = (date2 - date1).seconds
          # of actual shifts initialized
          item['per'] = 0
          # Initialize clock-in/clock-out times
          item['start'] = 0
          item['end'] = 0
          # Iterate through the user's punch log
          for t in item['check']:
            # When it's earlier than duty time
            if t < start:
              # Calculate the time difference
              date1 = (y,m,d,int(start[:2]),int(start[-2:]))
              date2 = (y,m,d,int(t[:2]),int(t[-2:]))
              dif = (date1 - date2).seconds
              #When clocking in within half an hour before duty time
              if dif <= 1800:
                # Clocked in at work and succeeded
                item['start'] = start
            elif t < end:
              # If you haven't clocked in at work
              if not item['start']:
                # then the current time is recorded as the time to clock in at work
                item['start'] = t
              else:
                # Otherwise record the current time as the off-duty clock-in time
                item['end'] = t
            else:
              # If you've clocked in at work
              if item['start']:
                # Calculate the time difference
                date1 = (y,m,d,int(end[:2]),int(end[-2:]))
                date2 = (y,m,d,int(t[:2]),int(t[-2:]))
                dif = (date1 - date2).seconds
                #When clocking in within half an hour of duty time
                if dif <= 1800:
                  # Clocked in from work
                  item['end'] = end
          # When clocking in and clocking out
          if item['start'] and item['end']:
            # Calculation of actual duty hours
            date1 = (y,m,d,int(item['start'][:2]),int(item['start'][-2:]))
            date2 = (y,m,d,int(item['end'][:2]),int(item['end'][-2:]))
            dif = (date2 - date1).seconds
            # Calculated (actual hours on duty/hours on duty) percentage
            item['per'] = int(dif/float(item['length']) * 100)
          else:
            # Failure to report for work on a regular basis is considered not on duty
            item['start'] = 0
            item['end'] = 0
          # Add records to the target array
          (item)
      # Output data
      ("",
        target = target
        )


def main():
  .parse_command_line()
  http_server = (Application())
  http_server.listen()
  ().start()


if __name__ == "__main__":
  main()

  

{
{% for item in target %}
  {
   'id':{{ item['id'] }},
   'start':{{ item['start'] }},
   'end':{{ item['end'] }},
   'length':{{ item['length'] }}, 
   'per':{{ item['per'] }}
   }
{% end %}
}