Пример #1
0
 def view(self, id=None):
     c.division = h.checkdiv(id)
     c.division.responsible = meta.Session.query(model.Person).filter_by(div_id=id).filter_by(responsible=True).all()
     c.division.chief = meta.Session.query(model.Person).filter_by(div_id=id).filter_by(chief=True).all()
     c.lastorders = meta.Session.query(model.Order).filter_by(cust_id=id).\
         order_by(model.sql.desc(model.Order.created))[:10]
     c.personnel = meta.Session.query(model.Person).filter_by(div_id=id).\
         filter_by(deleted=False).order_by(model.Person.surname).all()
     # Учёт количества сделанных заявок
     thismonday = datetime.combine(date.today(), time(0, 0)) - timedelta(date.today().weekday())
     last = meta.Session.query(model.Person.id, func.count(model.Order.id), func.sum(model.OrderPerformer.workload)).\
         join(model.Person.order_performs, model.OrderPerformer.order).\
         filter(model.Person.div_id==id).filter(model.OrderPerformer.current==True).group_by(model.Person.id)
     last30d = last.filter(model.Order.doneAt > datetime.now()-timedelta(30)).all()
     thisweek = last.filter(model.Order.doneAt >= thismonday).all()
     prevweek = last.filter(model.Order.doneAt < thismonday).filter(model.Order.doneAt >= thismonday-timedelta(7)).all()
     last1d = last.filter(model.Order.doneAt > datetime.combine(date.today(), time(0, 0))).all()
     # Учёт по дням количества сделанных заявок
     dates = meta.Session.execute
     dates_q = """
       SELECT o."doneAt"::date AS done_date
       FROM orders o
       WHERE o."doneAt" BETWEEN (now() - '1 month'::interval)::timestamp AND now()
       GROUP BY done_date
       ORDER BY done_date;
     """
     order_count_q = """
       SELECT
            o."doneAt"::date AS done_date,
            (o."doneAt"::date - (SELECT a.created::date FROM actions a WHERE a.order_id = o.id AND a.status_id = 2 ORDER BY a.created DESC LIMIT 1) + 1) AS days,
            op.workload
       FROM   people p 
         JOIN orderperformers op ON p.id = op.person_id
         JOIN orders o ON op.order_id = o.id
       WHERE
             p.id = %d
         AND o.status_id IN (3, 4)
         AND o."doneAt" BETWEEN (now() - '1 month'::interval)::timestamp AND now()
       ORDER BY done_date;
     """
     c.dates = [row[0] for row in meta.Session.execute(dates_q)]
     c.graph_data = [[0 for d in c.dates] for user in c.personnel] # Empty graph data
     for user_idx, user in enumerate(c.personnel):
       for row in meta.Session.execute(order_count_q % user.id):
         stop_idx = c.dates.index(row[0])
         start_idx = stop_idx - row[1] - 2
         if start_idx < 0: start_idx = 0
         for idx in range(start_idx, stop_idx):
           c.graph_data[user_idx][idx] += float(row[2])/(row[1]+2)
     # Подготовка к отображению шаблона
     c.lastmonth = dict([[record[0], record[1:]] for record in last30d])
     c.prevweek = dict([[record[0], record[1:]] for record in prevweek])
     c.thisweek = dict([[record[0], record[1:]] for record in thisweek])
     c.today = dict([[record[0], record[1:]] for record in last1d])
     c.total = dict([[record[0], record[1:]] for record in last.all()])
     return render("/divisions/view.html")
Пример #2
0
 def delete(self, id=None):
     h.admincheck()
     div = h.checkdiv(id)
     # Стараемся не оставить людей сиротами
     for user in div.people:
         user.deleted = True
     #meta.Session.delete(div)
     div.deleted = True
     meta.Session.commit()
     h.flashmsg (u"Подразделение было удалено")
     redirect_to(h.url_for(controller='division', action='list', id=None))
Пример #3
0
 def save(self, id):
     h.requirelogin()
     div = h.checkdiv(id)
     if not (h.have_role('admin') or (session.get('division')==div.id and (session.get('chief') or session.get('responsible')))):
         abort(403)
     for key, value in self.form_result.items():
         if getattr(div, key) != value:
             setattr(div, key, value)
     meta.Session.commit()
     h.flashmsg (u"Информация о подразделении была сохранена")
     redirect_to(h.url_for(controller='division', action='view', id=div.id))
Пример #4
0
 def changeusers(self, id=None):
     h.admincheck()
     div = h.checkdiv(id)
     user = meta.Session.query(model.Person)
     userlist = eval(self.form_result['users'])
     # Сначала удалим всех нафиг
     oldusers = user.filter_by(div_id=id).all()
     for person in oldusers:
         person.div_id = None
     # Вносим в список новых пользователей
     try:
         users = user.filter(model.Person.id.in_(userlist)).all()
         for person in users:
             person.div_id = div.id
     except TypeError: # Если элемент один, то ругается, что Int не iterable
         user.get(userlist).div_id = div.id
     # Сохраняемся
     meta.Session.commit()
     h.flashmsg (u"Информация о подразделении была сохранена")
     redirect_to(h.url_for(controller='division', action='view', id=id))
Пример #5
0
 def edit(self, id=None):
     h.requirelogin()
     div = h.checkdiv(id)
     if not (h.have_role('admin') or (session.get('division')==div.id and (session.get('chief') or session.get('responsible')))):
         abort(403)
     users = meta.Session.query(model.Person).all()
     c.users = []
     for i in users:
         c.users.append([i.id, h.name(i)])
     #qmembers = meta.Session.query(model.Person).filter_by(division=div.id).all()
     members = []
     for i in div.people:
         members.append(i.id)
     values = {
         'title': div.title,
         'address': div.address,
         'description': div.description,
         'email': div.email,
         'phone': div.phone,
         'users': members,
     }
     return htmlfill.render(render("/divisions/edit.html"), values)
Пример #6
0
    def view(self, id=None):
        c.division = h.checkdiv(id)
        c.division.responsible = meta.Session.query(model.Person).filter_by(div_id=id).filter_by(responsible=True).all()
        c.division.chief = meta.Session.query(model.Person).filter_by(div_id=id).filter_by(chief=True).all()
        c.lastorders = meta.Session.query(model.Order).filter_by(cust_id=id).\
            order_by(model.sql.desc(model.Order.created))[:10]
        c.personnel = meta.Session.query(model.Person).filter_by(div_id=id).\
            filter_by(deleted=False).order_by(model.Person.surname).all()
        # Учёт количества сделанных заявок
        thismonday = datetime.combine(date.today(), time(0, 0)) - timedelta(date.today().weekday())
        last = meta.Session.query(model.Person.id, func.count(model.Order.id), func.sum(model.OrderPerformer.workload)).\
            join(model.Person.order_performs, model.OrderPerformer.order).\
            filter(model.Person.div_id==id).filter(model.OrderPerformer.current==True).group_by(model.Person.id)
        last30d = last.filter(model.Order.doneAt > datetime.now()-timedelta(30)).all()
        thisweek = last.filter(model.Order.doneAt >= thismonday).all()
        prevweek = last.filter(model.Order.doneAt < thismonday).filter(model.Order.doneAt >= thismonday-timedelta(7)).all()
        last1d = last.filter(model.Order.doneAt > datetime.combine(date.today(), time(0, 0))).all()
        # Реактивность и тормознутость

        reacts_q = """
        SELECT people.id, actions.created, orders.created
            FROM people JOIN actionperformers ap ON people.id = ap.person_id
            JOIN actions ON ap.action_id = actions.id
            JOIN orders ON actions.order_id = orders.id
            WHERE people.id IN (SELECT id FROM people WHERE div_id = %d)
            AND actions.created BETWEEN (now() - '1 month'::interval)::timestamp AND now()            
            AND actions.status_id = 2
            ORDER BY people.id
        """
        reacts = meta.Session.execute(reacts_q % c.division.id)

        count_of_actions = 0
        temp = 0
        first = True
        reaction = []
        thour = 0
        tminute = 0
        tsecond = 0
        lastid = None

        for row in reacts:
            if first:
                lastid = row[0]
                first = False
            if row[0] != lastid:
                if count_of_actions != 0:
                    temp = float(temp)/count_of_actions
                else:
                    temp = 0 
                thour = int(temp)
                tminute = int((temp-thour)*60)
                tsecond = int(((temp-thour)*60-tminute)*60)
                reaction.append([lastid, '%dh %dm %ds'%(thour,tminute,tsecond)])
                temp = 0
                lastid = row[0]
                count_of_actions = 0
            fromdate = row[2]
            todate = row[1]
            daygenerator = (fromdate.date() + timedelta(x) for x in range((todate.date() - fromdate.date()).days))
            res_d = sum(1 for day in daygenerator if day.weekday() < 5)
            fromtime = fromdate.time()
            totime = todate.time()
            res_m = (totime.minute - fromtime.minute)
            res_s = (totime.second - fromtime.second)
            if res_d == 0:
                res_h = (totime.hour - fromtime.hour)
                if fromtime.hour < 12 and totime.hour > 13:
                    res_h -= 1
            else:
                res_d -= 1
                res_h = 9-fromtime.hour+totime.hour
                if fromtime.hour < 12:
                    res_h -= 1
                if totime.hour > 13:
                    res_h -= 1
            if res_s < 0:
                res_m -= 1 
                res_s = 60 + res_s
            if res_m < 0:
                res_h -= 1
                res_m = 60 + res_m
            temp += 8*res_d + res_h + float(res_m)/60 + float(res_s)/3600
            count_of_actions +=1 
        if count_of_actions != 0:
            temp = float(temp)/count_of_actions
        else:
            temp = 0  
        thour = int(temp)
        tminute = int((temp-thour)*60)
        tsecond = int(((temp-thour)*60-tminute)*60)
        reaction.append([lastid, '%dh %dm %ds'%(thour,tminute,tsecond)])

        # Учёт по дням количества сделанных заявок
        dates = meta.Session.execute
        dates_q = """
          SELECT o."doneAt"::date AS done_date
          FROM orders o
          WHERE o."doneAt" BETWEEN (now() - '1 month'::interval)::timestamp AND now()
          GROUP BY done_date
          ORDER BY done_date;
        """
        order_count_q = """
          SELECT
               o."doneAt"::date AS done_date,
               (o."doneAt"::date - (SELECT a.created::date FROM actions a WHERE a.order_id = o.id AND a.status_id = 2 ORDER BY a.created DESC LIMIT 1) + 1) AS days,
               op.workload
          FROM   people p 
            JOIN orderperformers op ON p.id = op.person_id
            JOIN orders o ON op.order_id = o.id
          WHERE
                p.id = %d
            AND o.status_id IN (3, 4)
            AND o."doneAt" BETWEEN (now() - '1 month'::interval)::timestamp AND now()
          ORDER BY done_date;
        """
        c.dates = [row[0] for row in meta.Session.execute(dates_q)]
        c.graph_data = [[0 for d in c.dates] for user in c.personnel] # Empty graph data
        for user_idx, user in enumerate(c.personnel):
          for row in meta.Session.execute(order_count_q % user.id):
            stop_idx = c.dates.index(row[0])
            start_idx = stop_idx - row[1] - 2
            if start_idx < 0: start_idx = 0
            for idx in range(start_idx, stop_idx):
              c.graph_data[user_idx][idx] += float(row[2])/(row[1]+2)

        # Подготовка к отображению шаблона
        c.lastmonth = dict([[record[0], record[1:]] for record in last30d])
        c.prevweek = dict([[record[0], record[1:]] for record in prevweek])
        c.thisweek = dict([[record[0], record[1:]] for record in thisweek])
        c.today = dict([[record[0], record[1:]] for record in last1d])
        c.total = dict([[record[0], record[1:]] for record in last.all()])
        c.reacts = dict([[record[0], record[1]] for record in reaction])
        return render("/divisions/view.html")