Пример #1
0
 def index(self):
     """Отображение главной страницы"""
     campaign_q = meta.Session.query(model.Campaign)
     c.current_campaign = campaign_q.filter_by(status = '1').first()
     c.finished_active_campaign = campaign_q.filter_by(status = '2').first()
     c.finished_inactive_campaign = campaign_q.filter_by(status = '3').order_by(model.Campaign.id.desc()).all()
     return render('/derived/campaign/view.html')
Пример #2
0
 def user_app(self):
     """Вывод данных о заявке пользователя"""
     # Выбор заявки и элементов заявки для определённого пользователя
     app_q = meta.Session.query(model.App)
     c.current_app = app_q.filter_by(author_id = app_globals.user_id).filter_by(campaign_id = app_globals.current_campaign_id).first()   
     app_elements_q = meta.Session.query(model.AppElements)
     c.current_app_elements = app_elements_q.filter_by(app_id = c.current_app.id)
     
     # Выбор всех доступных вариантов источников финансирования и нужд
     finsource_q = meta.Session.query(model.FinSource)
     c.available_finsource = [(finsource.id, finsource.name) for finsource in finsource_q]     
     needs_q = meta.Session.query(model.Needs)
     c.available_needs = [(needs.id, needs.name) for needs in needs_q]
     users = request.environ['authkit.users']
     
     # c.available_groups = users.list_groups()  
     groups_q = meta.Session.query(model.Group)    
     c.available_groups = [(group.uid, group.view) for group in groups_q]
     
     # Информациия о заявке           
     values = {}
     element_amount = {}
     element_amountp = {}
     element_price = {}
     element_pricep = {}
     total_price = 0
     total_pricep = 0
     for element in c.current_app_elements:
         values['quarter1_el'+str(element.id)] = element.quarter1
         values['quarter2_el'+str(element.id)] = element.quarter2
         values['quarter3_el'+str(element.id)] = element.quarter3
         values['quarter4_el'+str(element.id)] = element.quarter4
         values['amountp_el'+str(element.id)] = element.amountp
         values['pricep_el'+str(element.id)] = element.pricep
         values['finsource_el'+str(element.id)] = element.finsource
         values['needs_el'+str(element.id)] = element.needs
         values['place_el'+str(element.id)] = element.place
         values['note_el'+str(element.id)] = element.note
         
         element_amount[element.id] = element.quarter1 + element.quarter2 + element.quarter3 + element.quarter4
         element_amountp[element.id] = element.amountp
         element_pricep[element.id] = element.pricep
         element_price[element.id] = element_amount[element.id] * element.items.price
         if element.status == 3:
             pass
         else:
             total_price += element_price[element.id]
             total_pricep += element_pricep[element.id]
     
     c.element_amount = element_amount
     c.element_amountp = element_amountp
     c.element_price = element_price  
     c.element_pricep = element_pricep  
     c.total_price = total_price
     c.total_pricep = total_pricep
     
     c.all_apps = app_q.filter_by(author_id = app_globals.user_id).all()
     
     return htmlfill.render(render('/derived/app/user_view.html'), values)
Пример #3
0
 def add_user_form(self):
     """Показывает форму регистрации, только Администратор должен иметь доступ к ней"""
     users = request.environ['authkit.users']
     #c.available_groups = users.list_groups()[1:]
     groups_q = meta.Session.query(model.Group)    
     c.available_groups = [(group.name, group.view) for group in groups_q]
     #c.available_roles = users.list_roles()
     return render('/derived/account/add_user_form.html')
Пример #4
0
 def new_item(self):
     """Отображение формы для создания объекта"""
     section_q = meta.Session.query(model.Section)
     available_sections = [(section.id, section.name) for section in section_q]
     c.available_sections = available_sections[1:]
     unit_q = meta.Session.query(model.Unit)
     c.available_units = [(unit.id, unit.name) for unit in unit_q]
     return render("/derived/catalog/new_item.html")
Пример #5
0
 def sale_app(self): 
     """Вывод формы для реализации заявок"""
     # Пустой запрос
     global_app_elements = meta.Session.query(model.AppElements).filter_by(id = 0)
     values = {}
     
     # Выбор нужных заявок и элементов заявки  
     app_q = meta.Session.query(model.App)
     approved_apps = app_q.filter_by(campaign_id = app_globals.current_campaign_id)
     approved_apps = approved_apps.filter(or_(model.App.status.like(4), model.App.status.like(4))).all()
     for approved_app in approved_apps:
         app_elements_q = meta.Session.query(model.AppElements)
         app_elements = app_elements_q.filter_by(app_id = approved_app.id)
         for element in app_elements:
             values['quarter1_el'+str(element.id)] = element.quarter1
             values['quarter2_el'+str(element.id)] = element.quarter2
             values['quarter3_el'+str(element.id)] = element.quarter3
             values['quarter4_el'+str(element.id)] = element.quarter4
             values['quarter1p_el'+str(element.id)] = element.quarter1p
             values['quarter2p_el'+str(element.id)] = element.quarter2p
             values['quarter3p_el'+str(element.id)] = element.quarter3p
             values['quarter4p_el'+str(element.id)] = element.quarter4p
             values['finsource_el'+str(element.id)] = element.finsource
             values['needs_el'+str(element.id)] = element.needs
             values['place_el'+str(element.id)] = element.place
             values['note_el'+str(element.id)] = element.note    
             values['action_el'+str(element.id)] = element.status         
         try:               
             global_app_elements = global_app_elements.union(app_elements) 
         except:
             pass     
     c.global_app_elements = global_app_elements.order_by(model.AppElements.item_id.asc())
     
     total_price = 0
     total_pricep = 0
     for app_element in c.global_app_elements:
         if (app_element.status == 3) or (app_element.status == 8):
             pass
         else:
             total_price += app_element.price
             total_pricep += app_element.pricep
     c.total_price = total_price
     c.total_pricep = total_pricep
     
     # Действия
     c.available_actions = [
                               (5, u'Закуплено'),
                               (6, u'Изменено'),
                               (7, u'Заменено'),
                               (8, u'Не закуплено'),
                           ]
     
     # Корректное отображение названий групп
     groups_q = meta.Session.query(model.Group)    
     c.available_groups = [(group.uid, group.view) for group in groups_q]
     #return render('/derived/app/sale_view.html')
     return htmlfill.render(render('/derived/app/sale_view.html'), values)
Пример #6
0
 def sale_app_print(self): 
     """Формы реализации заявки - версия для печати """
     #response.content_type = 'application/download'
     # Пустой запрос
     global_app_elements = meta.Session.query(model.AppElements).filter_by(id = 0)
     values = {}
     
     # Выбор нужных заявок и элементов заявки  
     app_q = meta.Session.query(model.App)
     approved_apps = app_q.filter_by(campaign_id = app_globals.current_campaign_id)
     approved_apps = approved_apps.filter(or_(model.App.status.like(4), model.App.status.like(4))).all()
     for approved_app in approved_apps:
         app_elements_q = meta.Session.query(model.AppElements)
         app_elements = app_elements_q.filter_by(app_id = approved_app.id)
         for element in app_elements:
             values['quarter1_el'+str(element.id)] = element.quarter1
             values['quarter2_el'+str(element.id)] = element.quarter2
             values['quarter3_el'+str(element.id)] = element.quarter3
             values['quarter4_el'+str(element.id)] = element.quarter4
             values['quarter1p_el'+str(element.id)] = element.quarter1p
             values['quarter2p_el'+str(element.id)] = element.quarter2p
             values['quarter3p_el'+str(element.id)] = element.quarter3p
             values['quarter4p_el'+str(element.id)] = element.quarter4p
             values['finsource_el'+str(element.id)] = element.finsource
             values['needs_el'+str(element.id)] = element.needs
             values['place_el'+str(element.id)] = element.place
             values['note_el'+str(element.id)] = element.note    
             values['action_el'+str(element.id)] = element.status         
         try:               
             global_app_elements = global_app_elements.union(app_elements) 
         except:
             pass     
     c.global_app_elements = global_app_elements.order_by(model.AppElements.item_id.asc())
     
     total_price = 0
     total_pricep = 0
     for app_element in c.global_app_elements:
         if app_element.status == 3:
             pass
         else:
             total_price += app_element.price
             total_pricep += app_element.pricep
     c.total_price = total_price
     c.total_pricep = total_pricep
     
     # Корректное отображение названий групп
     groups_q = meta.Session.query(model.Group)    
     c.available_groups = [(group.uid, group.view) for group in groups_q]
     
     # Текущий год
     c.year = datetime.datetime.now().strftime('%Y')
     
     return htmlfill.render(render('/derived/app/sale_view_print.html'), values)    
Пример #7
0
 def edit_section(self):
     """Отображение формы для изменения/удаления раздела"""
     section_q = meta.Session.query(model.Section)
     section = section_q.filter_by(id=request.urlvars["id"]).first()
     c.current_section = section
     c.available_sections = [(section.id, section.name) for section in section_q]
     values = {
         "name": c.current_section.name,
         "parent_section": c.current_section.id,
         "description": c.current_section.description,
     }
     return htmlfill.render(render("/derived/catalog/edit_section.html"), values)
Пример #8
0
 def signin(self):
     """Вход в систему
     Здесь происходит много всего:
     - добавление глобальной переменной, содержащей user_id
     - проверка, началась ли кампания
     - проверка, создана ли заявка для текущей кампании; если нет - создание
     - если кампания не запущена, сбросить глобальные переменные
     - TODO: что-то надо сделать с предыдущими заявками"""
     if not request.environ.get('REMOTE_USER'):
         # This triggers the AuthKit middleware into displaying the sign-in form
         abort(401)
     else:
         # Определить uis пользователя и поместить в глобальную переменную
         user_q = meta.Session.query(model.User)
         user = user_q.filter_by(username = request.environ['REMOTE_USER']).first()
         app_globals.user_id = user.uid
         app_globals.user_group = user.group.view
         app_globals.user_view = user.view
         
         campaign_q = meta.Session.query(model.Campaign)
         c.current_campaign = campaign_q.filter_by(status = '1').first()
         # Проверить, есть ли активные кампании
         if c.current_campaign:
             app_globals.current_campaign_id = c.current_campaign.id
             app_globals.current_campaign_start_date = c.current_campaign.start_date
             app_globals.current_campaign_end_date = c.current_campaign.end_date
             # Проверить, есть ли у пользователя заявка для этой кампании
             app_q = meta.Session.query(model.App)
             c.app = app_q.filter_by(author_id = app_globals.user_id).filter_by(campaign_id = app_globals.current_campaign_id).first()
             try:
                 c.app.id
             # Создать заявка для новой кампании
             except:
                 app = model.App()
                 app.author_id = app_globals.user_id
                 app.status = '1'
                 app.campaign_id = app_globals.current_campaign_id
                 app.created = datetime.datetime.now()
                 app.edited = datetime.datetime.now()
                 meta.Session.add(app)
                 meta.Session.flush()
                 '''
                 Сделать что-то с предыдущими заявками!!!
                 '''
         # Если кампаний не найдено, обнулить глобальные переменные
         else:
             #app_globals.current_campaign_id = 0
             #app_globals.current_campaign_start_date = 0
             #app_globals.current_campaign_end_date = 0 
             pass          
         return render('/derived/account/signedin.html')
Пример #9
0
    def group_app_print(self): 
        """Вывод данных о заявке по отделу - версия для печати"""
        #response.content_type = 'application/download'
        
        # Пустой запрос
        group_app_elements = meta.Session.query(model.AppElements).filter_by(id = 0)
        # Выбор группы
        boss_q = meta.Session.query(model.User)
        boss_group = boss_q.filter_by(username = request.environ['REMOTE_USER']).first().group_uid
        c.boss_group_view = boss_q.filter_by(username = request.environ['REMOTE_USER']).first().group.view
        # Выбор пользователей в этой группе
        users_q = meta.Session.query(model.User)
        users_in_group = users_q.filter_by(group_uid = boss_group).all()
        
        # Выбор заявки и элементов заявок, соответстующих определённой группе
        for user in users_in_group:       
            app_q = meta.Session.query(model.App)
            current_app = app_q.filter_by(author_id = user.uid).filter_by(campaign_id = app_globals.current_campaign_id) 
            current_app = current_app.filter(or_(model.App.status.like(2), model.App.status.like(3))).first()  
            app_elements_q = meta.Session.query(model.AppElements)
            try:
                current_app_elements = app_elements_q.filter_by(app_id = current_app.id)
                group_app_elements = group_app_elements.union(current_app_elements) 
            except:
                pass     
        c.group_app_elements = group_app_elements.order_by(model.AppElements.item_id.asc())
        
        total_price = 0
        for app_element in c.group_app_elements:
            if app_element.status == 3:
                pass
            else:
                total_price += app_element.price
        c.total_price = total_price
        
        # Вывод корректных названий групп
        groups_q = meta.Session.query(model.Group)    
        c.available_groups = [(group.uid, group.view) for group in groups_q]

        # Текущий год
        c.year = datetime.datetime.now().strftime('%Y')        

        # Вывод информации о лимитах
        users = request.environ['authkit.users']
        limit_q = meta.Session.query(model.Limit)
        try:
            c.limit = limit_q.filter_by(campaign_id = app_globals.current_campaign_id).filter_by(group_uid = boss_group).first()
        except:
            c.limit = '0'

        return render('/derived/app/group_view_print.html')
Пример #10
0
 def manage_accounts(self):
     """Основная страница управления пользователями
     Список пользователей, групп"""
     users = request.environ['authkit.users']
     boss_list = {}
     c.users = users
     for user in users.list_users():
         if users.user_has_role(user, 'boss'):
             try:
                 boss_list.update({users.user_group(user):user})
             except:
                 pass
     c.boss_list = boss_list
     return render('/derived/account/manage_accounts.html')
Пример #11
0
 def settings(self):
     """Настройка параметров:
         Нужды
         Источники финансирования
         Единица измерения"""
         
     finsource_q = meta.Session.query(model.FinSource)
     c.available_finsource = [(finsource.id, finsource.name) for finsource in finsource_q]     
     needs_q = meta.Session.query(model.Needs)
     c.available_needs = [(needs.id, needs.name) for needs in needs_q]
     unit_q = meta.Session.query(model.Unit)
     c.available_units = [(unit.id, unit.name) for unit in unit_q]
     
     return render('/derived/campaign/settings.html')
Пример #12
0
    def search_item(self):
        """Поиск объектов по каталогу"""
        section_q = meta.Session.query(model.Section)
        c.section = section_q

        item_q = meta.Session.query(model.Item)
        c.search_results = item_q.filter_by(brand=self.form_result["search_string"]).all()

        # To disable "Add" link
        app_q = meta.Session.query(model.App)
        c.current_app_status = (
            app_q.filter_by(author_id=app_globals.user_id)
            .filter_by(campaign_id=app_globals.current_campaign_id)
            .first()
            .status
        )

        return render("/derived/catalog/search_item.html")
Пример #13
0
 def edit_item(self):
     """Отображение формы для изменения/удаления объекта"""
     section_q = meta.Session.query(model.Section)
     c.available_sections = [(section.id, section.name) for section in section_q]
     unit_q = meta.Session.query(model.Unit)
     c.available_units = [(unit.id, unit.name) for unit in unit_q]
     item_q = meta.Session.query(model.Item)
     item = item_q.filter_by(id=request.urlvars["id"]).first()
     c.current_item = item
     values = {
         "brand": c.current_item.brand,
         "model": c.current_item.model,
         "description": c.current_item.description,
         "section_id": c.current_item.section_id,
         "unit_id": c.current_item.unit_id,
         "price": c.current_item.price,
     }
     # return render('/derived/catalog/edit.html')
     return htmlfill.render(render("/derived/catalog/edit_item.html"), values)
Пример #14
0
    def section(self, id):
        """Отображает список подразделов и breadcrumbs"""
        section_q = meta.Session.query(model.Section)
        c.section = section_q

        def breadcrumbs(section_id):
            "Отображает список разделов до Главного"
            a = ""
            b = []
            d = []
            while a != None:
                a = c.section.filter_by(id=section_id).first().parent_section_id
                a_name = c.section.filter_by(id=section_id).first().name
                a_id = c.section.filter_by(id=section_id).first().id
                if a != None:
                    b = [(a_name, a_id)] + b
                section_id = a
            c.breadcrumbs = b

        # try:
        c.current_section = section_q.filter_by(id=id).first()
        breadcrumbs(c.current_section.id)

        # item_q = meta.Session.query(model.Item)
        # c.section_items = item_q.filter_by(section_id = c.current_section.id)
        # Just using ORM relation instead of another query
        c.section_items = c.current_section.items

        # To disable "Add" link
        app_q = meta.Session.query(model.App)
        c.current_app_status = (
            app_q.filter_by(author_id=app_globals.user_id)
            .filter_by(campaign_id=app_globals.current_campaign_id)
            .first()
            .status
        )

        app_globals.current_section_id = c.current_section.id
        return render("/derived/catalog/section.html")
Пример #15
0
 def edit_group_form(self):
     """Форма изменения параметров группы"""
     users = request.environ['authkit.users']
     c.group = request.params['group']
     c.group_view = users.group_view(c.group)
     users_in_group_list = []
     for user in users.list_users():
         if users.user_has_group(user, request.params['group']):
             try:
                 users_in_group_list += [user]
             except:
                 pass
             if users.user_has_role(user, 'boss'):
                 c.boss = user
             else:
                 c.boss = ''
     c.users_in_group_list = users_in_group_list
     values = {
         'group': c.group,
         'view': c.group_view,
     }        
     return htmlfill.render(render('/derived/account/edit_group_form.html'), values)
Пример #16
0
 def edit_item_group_form(self):
     """Открывает новое окно для изменения конкретного элемента"""
     user_app_element = meta.Session.query(model.AppElements).filter_by(id = request.urlvars['id'])
     c.user_app_element = user_app_element
     
     finsource_q = meta.Session.query(model.FinSource)
     c.available_finsource = [(finsource.id, finsource.name) for finsource in finsource_q]     
     needs_q = meta.Session.query(model.Needs)
     c.available_needs = [(needs.id, needs.name) for needs in needs_q]
     users = request.environ['authkit.users']
     
     groups_q = meta.Session.query(model.Group)
     c.available_groups = [(group.uid, group.view) for group in groups_q]
     
     # Информациия о заявке           
     values = {}
     element_amount = {}
     element_price = {}
     total_price = 0
     for element in user_app_element:
         values['quarter1'] = element.quarter1
         values['quarter2'] = element.quarter2
         values['quarter3'] = element.quarter3
         values['quarter4'] = element.quarter4
         values['finsource'] = element.finsource
         values['needs'] = element.needs
         values['place'] = element.place
         values['note'] = element.note
         
         element_amount[element.id] = element.quarter1 + element.quarter2 + element.quarter3 + element.quarter4
         element_price[element.id] = element_amount[element.id] * element.items.price
         total_price += element_price[element.id]
     
     c.element_amount = element_amount
     c.element_price = element_price  
     c.total_price = total_price
     return htmlfill.render(render('/derived/app/edit_item_group_form.html'), values)
Пример #17
0
    def edit_user_form(self):
        """Показывает форму регистрации, только Администратор должен иметь доступ к ней"""
        users = request.environ['authkit.users']
        c.username = request.params['username']
        c.password = users.user_password(c.username)
        c.view = (users.user_view(c.username))
        c.mail = (users.user_mail(c.username))
        #c.available_groups = users.list_groups()[1:]
        groups_q = meta.Session.query(model.Group)    
        c.available_groups = [(group.name, group.view) for group in groups_q]
        try:
            c.group = users.user_group(request.params['username'])
        except:
            c.group = ''  
        #c.available_roles = users.list_roles()
#       c.roles = users.user_roles(request.params['username'])
        values = {
            'password': c.password,
            'group': c.group,
            'mail': c.mail,
            'view': c.view,
#            'roles': c.roles,
        }
        return htmlfill.render(render('/derived/account/edit_user_form.html'), values)
Пример #18
0
    def add_user(self):
        """Добавление нового пользователя"""
        users = request.environ['authkit.users']
        c.available_groups = users.list_groups()[1:]
        available_roles = users.list_roles()
        if not users.user_exists(self.form_result['username']):
            users.user_create(self.form_result['username'], password=self.form_result['password'])
            users.user_set_view(self.form_result['username'], self.form_result['view'])
            users.user_set_mail(self.form_result['username'], self.form_result['mail'])
            users.user_set_group(self.form_result['username'], self.form_result['group'])
#            try:
#                for role in self.form_result['roles']:
#                    if role not in available_roles:
#                        users.user_add_role(self.form_result['username']), self.form_result['roles'])
#                    else:
#                        users.user_add_role(self.form_result['username']), role)
#            except:
#                pass
            users.user_add_role(self.form_result['username'], 'user')
            meta.Session.commit()
            redirect(url(h.url(controller='account', action='manage_accounts')))
        else:
            c.username = self.form_result['username']
            return render('/derived/account/add_user_form.html')
Пример #19
0
 def signinagain(self):
     """Вход в системe с другими логином и паролем"""
     request.environ['paste.auth_tkt.logout_user']()
     return render('/derived/account/signin.html').replace('%s', h.url('signin'))
Пример #20
0
    def global_app_print(self):
        """Обобщённая заявка по предприятию - версия для печати """
        #response.content_type = 'application/download'
        
        # Пустой запрос
        global_app_elements = meta.Session.query(model.AppElements).filter_by(id = 0)
        
        # Выбор нужных заявок и элементов заявки    
        app_q = meta.Session.query(model.App)
        approved_apps = app_q.filter_by(campaign_id = app_globals.current_campaign_id)
        approved_apps = approved_apps.filter(or_(model.App.status.like(3), model.App.status.like(4))).all()
        for approved_app in approved_apps:
            app_elements_q = meta.Session.query(model.AppElements)
            app_elements = app_elements_q.filter_by(app_id = approved_app.id)
            try:
                global_app_elements = global_app_elements.union(app_elements) 
            except:
                pass     
        c.global_app_elements = global_app_elements.order_by(model.AppElements.item_id.asc())
        
        total_price = 0
        for app_element in c.global_app_elements:
            if app_element.status == 3:
                pass
            else:
                total_price += app_element.price
        c.total_price = total_price
        
        # Корректное отображение названий групп
        groups_q = meta.Session.query(model.Group)    
        c.available_groups = [(group.uid, group.view) for group in groups_q]
        
        # Сегодняшняя дата
        c.now = datetime.datetime.now().strftime('%d.%m.%Y') 
    
        # Сумма по группам
        users = request.environ['authkit.users']
        c.users = users

        total_group_price = {}

        for group in c.users.list_groups():
            # Пустой запрос
            group_app_elements = meta.Session.query(model.AppElements).filter_by(id = 0)
            # Выбор группы
            boss_group = c.users.group_uid(group)
            c.boss_group_view = c.users.group_view(group)
            # Выбор пользователей в этой группе
            users_q = meta.Session.query(model.User)
            users_in_group = users_q.filter_by(group_uid = boss_group).all()
            
            # Выбор заявки и элементов заявок, соответстующих определённой группе
            for user in users_in_group:       
                app_q = meta.Session.query(model.App)
                current_app = app_q.filter_by(author_id = user.uid).filter_by(campaign_id = app_globals.current_campaign_id) 
                current_app = current_app.filter(or_(model.App.status.like(2), model.App.status.like(3))).first()  
                app_elements_q = meta.Session.query(model.AppElements)
                try:
                    current_app_elements = app_elements_q.filter_by(app_id = current_app.id)
                    group_app_elements = group_app_elements.union(current_app_elements) 
                except:
                    pass     
            c.group_app_elements = group_app_elements.order_by(model.AppElements.item_id.asc())
            
            total_price = 0
            for app_element in c.group_app_elements:
                if (app_element.status == 3) or (app_element.status == 8):
                    pass
                else:
                    total_price += app_element.price
            total_group_price[group] = total_price

            c.total_group_price = total_group_price
            
        # Вывод информации о лимитах
        limit_q = meta.Session.query(model.Limit)
        try:
            c.limit = limit_q.filter_by(campaign_id = app_globals.current_campaign_id).all()
        except:
            pass
        
        return render('/derived/app/global_view_print.html')
Пример #21
0
 def new_section(self):
     """Отображение формы для создания раздела"""
     section_q = meta.Session.query(model.Section)
     c.available_sections = [(section.id, section.name) for section in section_q]
     return render("/derived/catalog/new_section.html")
Пример #22
0
 def new(self):
     """Форма создания новой заявочной кампании"""
     users = request.environ['authkit.users']
     c.users = users
     return render('/derived/campaign/new.html')
Пример #23
0
 def signout(self):
     """Выход из системы"""
     # The actual removal of the AuthKit cookie occurs when the response passes
     # through the AuthKit middleware, we simply need to display a page
     # confirming the user is signed out
     return render('/derived/account/signedout.html')