AND ai.company_id IN (%s) AND pp.excluded_product IS NOT TRUE AND ai.date_invoice BETWEEN '%s' AND '%s' %s """ cr.execute(_sql % (','.join(str(com_id.id) for com_id in form.company_ids), form.from_dt, form.to_dt, _salesman_filter)) return [(record[0]) for record in cr.fetchall()] def validate_parameters(self, cr, uid, form, context=None): if len(form.company_ids) == 0: raise osv.except_osv(_('Caution !'), _('No page will be printed !')) def print_report(self, cr, uid, form, context=None): self.validate_parameters(cr, uid, form, context=context) _ails = self.get_ail(cr, uid, form, context=context) _ails_table = list_to_pgTable(_ails, _ARRAY_NAME, [('id', 'INTEGER')]) form.add_marshalled_data(_TABLE_NAME, _ails_table) form.add_marshalled_data('RPT_SQL', RPT_SQL) prec = self.pool.get('decimal.precision').precision_get( cr, uid, 'Product UoM') zero = '0' * prec form.add_marshalled_data('QTY_FORMAT', "#,##0.%s;-#,##0.%s" % (zero, zero)) register_report_wizard(RPT_NAME, wizard)
raise osv.except_osv(_('Caution !'), _('No page will be printed !')) def print_report(self, cr, uid, form, context=None): self.validate_parameters(cr, uid, form, context=context) form.add_marshalled_data('SQL_PARAMS', ar_cust_sql()) if len(form.customer_addr_ids) == 0: #TODO: Nothing sql_cust_ids = '' else: cust_list = form.get_customer_addr_ids(context=None) cust_addr_ids = ",".join(str(n) for n in cust_list) sql_cust_ids = ' AND id.address_id IN (%s)' % cust_addr_ids form.add_marshalled_data('CUSTOMER_ADDR_IDS', sql_cust_ids) receivable = self.get_receivable(cr, uid, form, context=context) receivable_table = list_to_pgTable(receivable, 'receivable_table', [('partner_id', 'INTEGER'), ('receivable', 'NUMERIC')]) form.add_marshalled_data('RECEIVABLE_TABLE', receivable_table) payable = self.get_payable(cr, uid, form, context=context) payable_table = list_to_pgTable(payable, 'payable_table', [('partner_id', 'INTEGER'), ('payable', 'NUMERIC')]) form.add_marshalled_data('PAYABLE_TABLE', payable_table) currency_company = self.get_currency_company(cr, uid, form, context=context) form.add_marshalled_data('CURRENCY_SYMBOL', currency_company) register_report_wizard(RPT_NAME, wizard)