Advertisement
Guest User

Untitled

a guest
May 9th, 2016
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.73 KB | None | 0 0
  1.     def GET(self):
  2.         header('Content', 'text/json')
  3.         clients = get_company_clients(session.username)
  4.         company = get_company(session.username)
  5.         services = get_company_services(session.username)
  6.        
  7.         data = []
  8.  
  9.         i=0
  10.         for c in clients:
  11.             client_data = {'name':'text', 'data': [0,0]}
  12.             client_data['name'] = c.fullname
  13.             for s in services:
  14.                 service_tasks = db.query('SELECT * from task WHERE client=$client AND service=$service',{'client':c.id, 'service': s.id})
  15.                 client_data['data'][i] = len(service_tasks)
  16.                 i+=1
  17.             data.append(client_data)
  18.  
  19.         return json.dumps(data, default=json_serial)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement