コード例 #1
0
ファイル: corrects.py プロジェクト: rafal-kos/pytis
    def list(self, id=None):        
        company_name = request.params.get('company_name', '')
        number = request.params.get('number', '')        
        date_from = request.params.get('invoiceDateFrom', h.today(30))
        date_to = request.params.get('invoiceDateTo', h.today())
             
        query = InvoiceCorrect.query
                
        if company_name:
            query = query.filter(Company.shortName.like('%' + company_name + '%') )        
        
        query = query.filter(InvoiceCorrect.created_at.between(date_from, date_to) )            
        query = query.filter(InvoiceCorrect.number.like('%' + number + '%') )

        if id:
            query = InvoiceCorrect.query.filter(InvoiceCorrect.invoice_id == id)
                
        records = query.order_by(InvoiceCorrect.created_at.desc(), InvoiceCorrect.series_number.desc())                  
        c.paginator = paginate.Page(
            records,
            page=int(request.GET.pop('page', 1)),
            items_per_page = int(request.GET.pop('page_size', 30)),
            **dict(request.GET)                        
        )
        
        if 'partial' in request.params:
            return render('/corrects/list-partial.xhtml')
        else:
            return render('/corrects/list.xhtml')
コード例 #2
0
ファイル: invoices.py プロジェクト: rafal-kos/pytis
    def add(self, id):
        order = Order.query.get_or_abort(id)
        c.invoices = Invoice.query.filter_by(idCompany=order.idCompany, isBooked=0).all()

        c.form = NewInvoiceForm(request.POST)
        if request.method == "POST" and c.form.validate():
            invoice = Invoice()
            element = InvoicePosition()

            invoice.series_year = c.form.year.data
            invoice.series_month = c.form.months.data
            invoice.issueDate = h.today()
            invoice.idCompany = order.idCompany
            invoice.tax = order.company.tax

            invoice.save()

            element.order_id = order.id
            element.invoice_id = invoice.id
            element.value = order.freight
            element.currency_id = order.currency.id
            element.tax = order.company.tax
            element.save()

            flash(u"Faktura pomyślnie dodana.")
            return self.redirect(url(controller="invoices", action="edit", id=invoice.id))

        return render("/invoices/add.xhtml")
コード例 #3
0
ファイル: orders.py プロジェクト: rafal-kos/pytis
 def month_balance(self, id):                
     orders = meta.Session.query(func.month(Order.created_at).label('month'), 
                                 func.day(Order.created_at).label('day'), 
                                 func.sum(Order.real_value - TransportOrder.real_value).label('value')) \
                  .join(Order.transport_order) \
                  .group_by( func.month(Order.created_at), func.day(Order.created_at)) \
                  .filter(and_(Order.idCreator == id, Order.created_at.between(h.today(31), h.today()))) \
                  .all()
     
     chart = open_flash_chart()
     t = title(text='Zestawienie')
     
     b = bar()        
     b.values = [order.value for order in orders]               
     
     lbl = labels(labels = [str(order.month) + ' ' + str(order.day) for order in orders])
     
     x = x_axis()
     x.labels = lbl
     
     y = y_axis()        
     y.min, y.max= 0, max(b.values or [0])         
     
     chart.title = t        
     chart.y_axis = y
     chart.x_axis = x
     chart.add_element(b)        
     
     return chart.render()
コード例 #4
0
ファイル: orders.py プロジェクト: rafal-kos/pytis
 def company_balance(self, id):
     orders = meta.Session.query(func.year(Order.created_at).label('year'), 
                                 func.month(Order.created_at).label('month'), 
                                 func.sum(Order.real_value).label('value')) \
                  .join(Order.transport_order) \
                  .filter(and_(Order.idCompany == id, Order.created_at.between(h.today(365), h.today()))) \
                  .group_by( func.year(Order.created_at), func.month(Order.created_at)) \
                  .all()
     
     profits = meta.Session.query(func.year(Order.created_at).label('year'), 
                                 func.month(Order.created_at).label('month'), 
                                 func.sum(Order.real_value - TransportOrder.real_value).label('value')) \
                  .join(Order.transport_order) \
                  .filter(and_(Order.idCompany == id, Order.created_at.between(h.today(365), h.today()))) \
                  .group_by( func.year(Order.created_at), func.month(Order.created_at)) \
                  .all()
     
     chart = open_flash_chart()
     t = title(text='Zestawienie')
     
     b = bar()        
     b.values = [order.value for order in orders]               
     
     b2 = bar()        
     b2.values = [order.value for order in profits]
     b2.colour = '#56acde'
     
     lbl = labels(labels = [str(order.year) + ' ' + str(order.month) for order in orders])
     
     x = x_axis()
     x.labels = lbl
     
     y = y_axis()
     y.min, y.max= 0, max(b.values or [0])
     y.labels = None
     y.offset = False
     
     chart.title = t        
     chart.y_axis = y
     chart.x_axis = x
     chart.add_element(b)
     chart.add_element(b2)         
     
     return chart.render() 
コード例 #5
0
ファイル: invoices.py プロジェクト: rafal-kos/pytis
    def list(self):
        company_name = request.params.get("company_name", "")
        number = request.params.get("number", "")
        is_booked = request.params.get("is_booked", "")
        date_from = request.params.get("invoiceDateFrom", h.today(30))
        date_to = request.params.get("invoiceDateTo", h.today())

        query = Invoice.query.join(Invoice.company).options(eagerload("company"), eagerload("elements"))

        if company_name != "":
            query = query.filter(Company.shortName.like(u"%" + company_name + u"%"))
        if is_booked:
            query = query.filter(Invoice.isBooked == is_booked)

        query = query.filter(Invoice.created_at.between(date_from, date_to))

        query = query.filter(Invoice.number.like(u"%" + number + u"%"))

        records = query.order_by(Invoice.created_at.desc(), Invoice.series_number.desc())

        invoice = Invoice()
        c.actions = invoice.get_action_choices(request)

        if request.method == "POST":
            response = invoice.response_action(request, Invoice.query)
            if response is not None:
                return response

        c.months = h.months_list()
        c.year = str(datetime.datetime.now().year)
        c.paginator = paginate.Page(
            records,
            page=int(request.GET.pop("page", 1)),
            items_per_page=int(request.GET.pop("page_size", 30)),
            **dict(request.GET)
        )

        if "partial" in request.params:
            return render("/invoices/list-partial.xhtml")
        else:
            return render("/invoices/list.xhtml")
コード例 #6
0
ファイル: orders.py プロジェクト: rafal-kos/pytis
    def list(self):        
        c.user = meta.Session.query(User.id, User.last_name + u' ' + User.first_name).all()
        
        company_name = request.params.get('company_name', '')
        number = request.params.get('number', '')
        is_factured = request.params.get('is_factured', '')
        numberTransportOrder = request.params.get('numberTransportOrder', '')        
        date_from = request.params.get('orderDateFrom', h.today(30))
        date_to = request.params.get('orderDateTo', h.today())
        idCreator = request.params.get('idCreator', '')
        
        records = Order.query.options(eagerload('places'), eagerload('transport_order'))
                
        if company_name:            
            records = records.join(Company, aliased=True).filter(Company.shortName.like('%' + company_name + '%') )
        if numberTransportOrder:            
            records = records.join(Order.transport_order).join(TransportOrder.company, aliased=True).filter(and_(Company.shortName.like('%' + numberTransportOrder + '%')))        
        if is_factured:
            records = records.filter(Order.isFactured == is_factured)                    
        if idCreator:
            records = records.filter(Order.idCreator == idCreator)
        if number:
            records = records.filter(Order.number.like('%' + number + '%') )
            
        records = records.filter(Order.created_at.between(date_from, date_to) ).order_by(desc(Order.id))                                                     

        c.paginator = paginate.Page(
            records,
            page=int(request.GET.pop('page', 1)),
            items_per_page = int(request.GET.pop('page_size', 30)),
            **dict(request.GET)
        )            
        
        if 'partial' in request.params:
            return render('/orders/list-partial.xhtml')
        else:
            return render('/orders/list.xhtml')              
コード例 #7
0
ファイル: corrects.py プロジェクト: rafal-kos/pytis
 def add(self, id):
     c.invoice = Invoice.query.get(id)               
     
     c.form = InvoiceCorrectForm(request.POST,
                                 correct_date = h.today(),
                                 sell_date = c.invoice.sellDate,                                    
                                 company=c.invoice.company.name,                                    
                                 payment_form=c.invoice.company.payment,
                                 payment_date=c.invoice.payment_date,
                                 positions=c.invoice.elements)
     
     for index, position in enumerate(c.form.positions):                       
         position.tax.value = c.invoice.elements[index].tax.id            
     
     if request.method == 'POST' and c.form.validate():
         correct = InvoiceCorrect()            
         correct.company = c.invoice.company
         correct.currency = c.invoice.elements[0].currency
         correct.invoice = c.invoice
         correct.series_year = str(datetime.datetime.now().year)
         correct.series_month = str(datetime.datetime.now().month)
         correct.currency_symbol = c.invoice.currencySymbol
         correct.currency_date = c.invoice.currencyDate
         correct.currency_value = c.invoice.currencyValue
         correct.currency_table_number = c.invoice.currencyTableNumber
         
         c.form.populate_obj(correct, exclude = ['id', 'company', 'number', 'positions'])
         for form_position in c.form.positions:
             position = InvoicePositionCorrect()                
             form_position.form.populate_obj(position, exclude=['id'])                                              
             correct.positions.append(position)                      
             
         correct.save()
         
         flash(u'Korekta pomyślnie dodana.')
         return self.redirect(url(controller='corrects', action='edit', id=correct.id))
     
     return render('/corrects/add.xhtml')
コード例 #8
0
ファイル: orders.py プロジェクト: rafal-kos/pytis
    def edit(self, id):                                          
        c.order = Order.query.get_or_abort(id)               
        
        c.form = OrderForm(request.POST, obj=c.order, prefix='order')
        c.places_form = OrderPlaceForm(request.POST)             
        c.transport_form = TransportOrderForm(request.POST, obj=c.order.transport_order, prefix='transport-order')
        
        c.place_form = PlaceForm(request.POST, idCompany=c.order.idCompany)
        if c.order.delegation is None:
            #c.drivers = [(driver.id, driver.full_name) for driver in Driver.query.filter(Driver.is_active == True).all()]
            c.drivers = [(driver.id, driver.full_name) for driver in Driver.query.filter(Driver.is_active == True).all()]
            c.delegation_form = DelegationForm(request.POST, prefix='delegation')                                               
        
        if request.method == 'POST':
            if request.POST['action'] == 'Save' and c.form.validate():                                        
                c.order.idCompany = c.form.idCompany.data
                c.order.freight = c.form.freight.data
                c.order.currency = c.form.currency.data
                c.order.description = c.form.description.data
                c.order.isCurrencyDate = c.form.isCurrencyDate.data
                c.order.foreignOrder = c.form.foreignOrder.data
                
                c.order.save()                               
                              
                flash(u'Zlecenie pomyślnie edytowane.')
                self.redirect(url(controller='orders', action='edit', id=c.order.id))
                return                
            if request.POST['action'] == 'Add Place':
                if c.places_form.validate():
                    place_order = PlaceOrder()
                    place_order.idOrder = c.order.id
                    place_order.type = c.places_form.idType.data
                    place_order.idPlace = c.places_form.idPlace.data
                    place_order.date = c.places_form.placeDate.data
                    place_order.name = 'PyTiS'
                    
                    place_order.save()
                    
                    return render_macro('/base/macros.xhtml', 'show_places', form=OrderPlaceForm(), places=c.order.places)
                else:
                    return render_macro('/base/macros.xhtml', 'show_places', form=c.places_form, places=c.order.places)
                                            
            if request.POST['action'] == 'Save TO':
                if c.transport_form.validate():
                    if not c.transport_form.id.data:
                        transport_order = TransportOrder()
                    else:                        
                        transport_order = TransportOrder.query.get(c.transport_form.id.data)
                    
                    transport_order.idOrder = c.order.id
                    transport_order.idCompany = c.transport_form.idCompany.data
                    transport_order.currency = c.transport_form.currency.data
                    transport_order.driverName = c.transport_form.driverName.data
                    transport_order.tractorName = c.transport_form.tractorName.data
                    transport_order.freight = c.transport_form.freight.data
                    transport_order.description = c.transport_form.description.data                                       
                    transport_order.save()
                    
                    c.transport_form.id.data = transport_order.id
                    c.transport_form.number.data = transport_order.number
                                                                              
                    return render_macro('/base/macros.xhtml', 'show_transport_order', order=c.order, form=c.transport_form)
                else:
                    return render_macro('/base/macros.xhtml', 'show_transport_order', order=c.order, form=c.transport_form)
            
            if request.POST['action'] == 'Create Place':                
                if c.place_form.validate():
                    place = Place()                    
                    c.place_form.populate_obj(place)
                    place.idCompany = c.order.company.id
                    place.save()                    
                    
                    return render_macro('/base/macros.xhtml', 'new_place', form=PlaceForm())                          
                else:
                    return render_macro('/base/macros.xhtml', 'new_place', form=c.place_form)
            
            if request.POST['action'] == 'Add Delegation':
                if c.delegation_form.validate():
                    delegation = Delegation()                
                    c.delegation_form.populate_obj(delegation)
                    delegation.series_year = h.today().year
                    delegation.series_month = h.today().month
                    delegation.save()
                    
                    c.order.delegation = delegation
                    c.order.save()
                    
                    return render_macro('/base/macros.xhtml', 'show_delegation')
                else:
                    return render_macro('/base/macros.xhtml', 'new_delegation')

        if c.order.isFactured:            
            c.invoice = InvoicePosition.query.filter_by(order_id = c.order.id).first()                        
                   
        return render('/orders/edit.xhtml')