Beispiel #1
0
    def __init__(self, cursor, uid, name, context):
        super(PartnersLedgerWebkit, self).__init__(cursor,
                                                   uid,
                                                   name,
                                                   context=context)
        self.pool = pooler.get_pool(self.cr.dbname)
        self.cursor = self.cr

        company = self.pool.get('res.users').browse(self.cr,
                                                    uid,
                                                    uid,
                                                    context=context).company_id
        header_report_name = ' - '.join(
            (_('PARTNER LEDGER'), company.name, company.currency_id.name))

        footer_date_time = self.formatLang(str(datetime.today()),
                                           date_time=True)

        self.localcontext.update({
            'cr':
            cursor,
            'uid':
            uid,
            'report_name':
            _('Partner Ledger'),
            'display_account_raw':
            self._get_display_account_raw,
            'filter_form':
            self._get_filter,
            'target_move':
            self._get_target_move,
            'initial_balance':
            self._get_initial_balance,
            'amount_currency':
            self._get_amount_currency,
            'display_partner_account':
            self._get_display_partner_account,
            'display_target_move':
            self._get_display_target_move,
            'additional_args': [
                ('--header-font-name', 'Helvetica'),
                ('--footer-font-name', 'Helvetica'),
                ('--header-font-size', '10'),
                ('--footer-font-size', '6'),
                ('--header-left', header_report_name),
                ('--header-spacing', '2'),
                ('--footer-left', footer_date_time),
                ('--footer-right', ' '.join(
                    (_('Page'), '[page]', _('of'), '[topage]'))),
                ('--footer-line', ),
            ],
        })
Beispiel #2
0
def migrate(cr, version):
    if not version:
        return

    pool = pooler.get_pool(cr.dbname)
    pto = pool['product.template']

    cr.execute(
        'ALTER TABLE "account_cutoff_line" RENAME "after_cutoff_days" '
        'TO "prepaid_days"')

    cr.execute(
        "UPDATE payment_line SET communication = communication2, "
        "communication2 = null "
        "FROM payment_order "
        "WHERE payment_line.order_id = payment_order.id "
        "AND payment_order.state in ('draft', 'open') "
        "AND payment_line.state = 'normal' "
        "AND communication2 is not null")
Beispiel #3
0
def migrate_lead_time(cr):
    pool = pooler.get_pool(cr.dbname)
    lead_time_obj = pool['stock.buffer.profile.lead.time']
    cr.execute("""
        SELECT old_lead_time, old_lead_time_factor
        FROM stock_buffer_profile
        WHERE old_lead_time IS NOT NULL
        AND old_lead_time_factor IS NOT NULL
        GROUP by old_lead_time, old_lead_time_factor""")
    for lead_time, lead_time_factor in cr.fetchall():
        lt_id = lead_time_obj.create(cr, SUPERUSER_ID, {
            'name': lead_time,
            'factor': lead_time_factor
        })
        cr.execute("""
        UPDATE stock_buffer_profile
        SET lead_time_id = %s
        WHERE old_lead_time_factor = %s
        AND old_lead_time = '%s'""" % (lt_id, lead_time_factor, lead_time))
Beispiel #4
0
def migrate_variability(cr):
    pool = pooler.get_pool(cr.dbname)
    variability_obj = pool['stock.buffer.profile.variability']
    cr.execute("""
        SELECT old_variability, old_variability_factor
        FROM stock_buffer_profile
        WHERE old_variability IS NOT NULL
        AND old_variability_factor IS NOT NULL
        GROUP by old_variability, old_variability_factor""")
    for variability, variability_factor in cr.fetchall():
        var_id = variability_obj.create(cr, SUPERUSER_ID, {
            'name': variability,
            'factor': variability_factor
        })
        cr.execute("""
        UPDATE stock_buffer_profile
        SET variability_id = %s
        WHERE old_variability_factor = %s
        AND old_variability = '%s'""" %
                   (var_id, variability_factor, variability))
    def __init__(self, cursor, uid, name, context=None):
        """Constructor,
           refer to :class:`openerp.report.report_sxw.rml_parse`"""
        super(AccountAgedOpenInvoicesWebkit, self).__init__(cursor, uid, name,
                                                            context=context)
        self.pool = pooler.get_pool(self.cr.dbname)
        self.cursor = self.cr
        company = self.pool.get('res.users').browse(self.cr, uid, uid,
                                                    context=context).company_id

        header_report_name = ' - '.join((_('Aged Open Invoices'),
                                         company.currency_id.name))

        footer_date_time = self.formatLang(str(datetime.today()),
                                           date_time=True)

        self.localcontext.update({
            'cr': cursor,
            'uid': uid,
            'company': company,
            'ranges': self._get_ranges(),
            'ranges_titles': self._get_ranges_titles(),
            'report_name': _('Aged Open Invoices'),
            'additional_args': [
                ('--header-font-name', 'Helvetica'),
                ('--footer-font-name', 'Helvetica'),
                ('--header-font-size', '10'),
                ('--footer-font-size', '6'),
                ('--header-left', header_report_name),
                ('--header-spacing', '2'),
                ('--footer-left', footer_date_time),
                ('--footer-right',
                 ' '.join((_('Page'), '[page]', _('of'), '[topage]'))),
                ('--footer-line',),
            ],
        })
Beispiel #6
0
def run_cron_ddmrp(cr):
    pool = pooler.get_pool(cr.dbname)
    pool['stock.warehouse.orderpoint'].cron_ddmrp(cr,
                                                  SUPERUSER_ID,
                                                  automatic=True)