def _auto_init(self, cr, context=None): super(via_jasper_report, self)._auto_init(cr, context=context) create_composite_type(cr, 'pt_data_point', [('prod_cat', 'VARCHAR'), ('prod', 'VARCHAR'), ('lot', 'VARCHAR'), ('qty', 'NUMERIC'), ('uom', 'TEXT')]) create_composite_type(cr, 'pt_decorated_record', [('nth', 'BIGINT'), ('decorator_consumed_prod', 'BOOLEAN'), ('decorator_consumed_subtotal', 'BOOLEAN'), ('decorator_finished_prod', 'BOOLEAN'), ('decorator_finished_subtotal', 'BOOLEAN'), ('consumed_prod_cat', 'VARCHAR'), ('consumed_prod', 'VARCHAR'), ('consumed_lot', 'VARCHAR'), ('consumed_qty', 'NUMERIC'), ('consumed_uom', 'TEXT'), ('finished_prod_cat', 'VARCHAR'), ('finished_prod', 'VARCHAR'), ('finished_lot', 'VARCHAR'), ('finished_qty', 'NUMERIC'), ('finished_uom', 'TEXT')]) create_plpgsql_proc(cr, 'pt_decorator', [('IN', 'consumed_data', 'PT_DATA_POINT[]'), ('IN', 'finished_data', 'PT_DATA_POINT[]')], 'SETOF PT_DECORATED_RECORD', _PT_DECORATOR_DEF)
def _auto_init(self, cr, context=None): super(cash_flow_realization_report, self)._auto_init(cr, context=context) create_composite_type(cr, 'vcf_tuple', [('id', 'BIGINT'), ('date', 'DATE'), ('type', 'INT'), ('bank_acc_id', 'BIGINT')]) create_plpgsql_proc(cr, 'cash_flow_items', [('IN', 'date_start', 'DATE'), ('IN', 'date_end', 'DATE'), ('IN', 'company_ids', 'INTEGER[]'), ('IN', 'account_ids', 'INTEGER[]')], 'TABLE(type_ CHARACTER VARYING, id_ BIGINT, date_ DATE, bank_acc_id_ BIGINT)', def_cash_flow_items_sql())
def _auto_init(self, cr, context=None): super(tree_node, self)._auto_init(cr, context=context) create_composite_type(cr, 'via_tree_node', [('id', 'BIGINT'), ('parent_id', 'BIGINT')]) create_composite_type(cr, 'via_tree_node_unrolled', [('id', 'BIGINT'), ('parent_id', 'BIGINT'), ('level', 'BIGINT'), ('parent_left', 'BIGINT'), ('parent_right', 'BIGINT')]) create_composite_type(cr, 'via_tree_node_level_tagger_datum', [('id', 'BIGINT'), ('parent_id', 'BIGINT'), ('level', 'BIGINT'), ('unrolling_pid', 'BIGINT'), ('unique_id', 'BIGINT'), ('unique_parent_id', 'BIGINT')]) create_composite_type(cr, 'via_tree_node_child_count', [('id', 'BIGINT'), ('parent_id', 'BIGINT'), ('level', 'BIGINT'), ('unique_id', 'BIGINT'), ('unique_parent_id', 'BIGINT'), ('child_count', 'BIGINT')]) create_plpgsql_proc(cr, 'via_tree_node_unroller', [('IN', 'tree_nodes', 'VIA_TREE_NODE[]')], 'SETOF VIA_TREE_NODE_LEVEL_TAGGER_DATUM', via_tree_node_unroller_def) create_plpgsql_proc(cr, 'via_tree_node_count_children', [ ('IN', 'unrolled_tree_nodes', 'VIA_TREE_NODE_LEVEL_TAGGER_DATUM[]') ], 'SETOF VIA_TREE_NODE_CHILD_COUNT', via_tree_node_count_children_def) create_plpgsql_proc(cr, 'via_tree_node_parent_left_right_tagger', [ ('IN', 'unrolled_tree_nodes', 'VIA_TREE_NODE_CHILD_COUNT[]') ], 'SETOF VIA_TREE_NODE_UNROLLED', via_tree_node_parent_left_right_tagger_def) create_plpgsql_proc(cr, 'via_tree_node_level_tagger', [('IN', 'tree_nodes', 'VIA_TREE_NODE[]')], 'SETOF VIA_TREE_NODE_UNROLLED', via_tree_node_level_tagger_def)
def _auto_init(self, cr, context=None): super(cash_flow_realization_report, self)._auto_init(cr, context=context) create_composite_type( cr, "vcf_tuple", [("id", "BIGINT"), ("date", "DATE"), ("type", "INT"), ("bank_acc_id", "BIGINT")] ) create_plpgsql_proc( cr, "cash_flow_items", [ ("IN", "date_start", "DATE"), ("IN", "date_end", "DATE"), ("IN", "company_ids", "INTEGER[]"), ("IN", "account_ids", "INTEGER[]"), ], "TABLE(type_ CHARACTER VARYING, id_ BIGINT, date_ DATE, bank_acc_id_ BIGINT)", def_cash_flow_items_sql(), )
def _auto_init(self, cr, context=None): super(via_jasper_report, self)._auto_init(cr, context=context) create_composite_type(cr, 'srr_axes', [('prod_cat', 'VARCHAR'), ('year', 'DATE'), ('month', 'DATE'), ('period_start', 'DATE'), ('period_stop', 'DATE')]) create_composite_type(cr, 'srr_data_point', [('prod_cat', 'VARCHAR'), ('prod', 'VARCHAR'), ('year', 'DATE'), ('month', 'DATE'), ('weight', 'NUMERIC'), ('sales', 'NUMERIC')]) create_composite_type(cr, 'srr_decorated_record', [('nth', 'BIGINT'), ('decorator_prod_cat_header', 'BOOLEAN'), ('decorator_prod', 'BOOLEAN'), ('decorator_prod_cat_footer', 'BOOLEAN'), ('prod_cat', 'VARCHAR'), ('prod', 'VARCHAR'), ('year', 'DATE'), ('month', 'DATE'), ('weight', 'NUMERIC'), ('sales', 'NUMERIC')]) create_plpgsql_proc(cr, 'srr_decorator', [('IN', 'sales_data', 'SRR_DATA_POINT[]'), ('IN', 'refund_data', 'SRR_DATA_POINT[]'), ('IN', 'credit_notes_data', 'SRR_DATA_POINT[]'), ('IN', 'other_cat_name', 'VARCHAR')], 'SETOF SRR_DECORATED_RECORD', _SRR_DECORATOR_DEF)
def _auto_init(self, cr, context=None): super(tree_node, self)._auto_init(cr, context=context) create_composite_type(cr, 'via_tree_node', [('id', 'BIGINT'), ('parent_id', 'BIGINT')]) create_composite_type(cr, 'via_tree_node_unrolled', [('id', 'BIGINT'), ('parent_id', 'BIGINT'), ('level', 'BIGINT'), ('parent_left', 'BIGINT'), ('parent_right', 'BIGINT')]) create_composite_type(cr, 'via_tree_node_level_tagger_datum', [('id', 'BIGINT'), ('parent_id', 'BIGINT'), ('level', 'BIGINT'), ('unrolling_pid', 'BIGINT'), ('unique_id', 'BIGINT'), ('unique_parent_id', 'BIGINT')]) create_composite_type(cr, 'via_tree_node_child_count', [('id', 'BIGINT'), ('parent_id', 'BIGINT'), ('level', 'BIGINT'), ('unique_id', 'BIGINT'), ('unique_parent_id', 'BIGINT'), ('child_count', 'BIGINT')]) create_plpgsql_proc(cr, 'via_tree_node_unroller', [('IN', 'tree_nodes', 'VIA_TREE_NODE[]')], 'SETOF VIA_TREE_NODE_LEVEL_TAGGER_DATUM', via_tree_node_unroller_def) create_plpgsql_proc(cr, 'via_tree_node_count_children', [('IN', 'unrolled_tree_nodes', 'VIA_TREE_NODE_LEVEL_TAGGER_DATUM[]')], 'SETOF VIA_TREE_NODE_CHILD_COUNT', via_tree_node_count_children_def) create_plpgsql_proc(cr, 'via_tree_node_parent_left_right_tagger', [('IN', 'unrolled_tree_nodes', 'VIA_TREE_NODE_CHILD_COUNT[]')], 'SETOF VIA_TREE_NODE_UNROLLED', via_tree_node_parent_left_right_tagger_def) create_plpgsql_proc(cr, 'via_tree_node_level_tagger', [('IN', 'tree_nodes', 'VIA_TREE_NODE[]')], 'SETOF VIA_TREE_NODE_UNROLLED', via_tree_node_level_tagger_def)
def _auto_init(self, cr, context=None): super(via_jasper_report, self)._auto_init(cr, context=context) create_plpgsql_proc(cr, 'gl_array_cat', [('IN', 'array_1', 'BIGINT[]'), ('IN', 'array_2', 'BIGINT[]')], 'BIGINT[]', _GL_ARRAY_CAT_DEF) create_aggregator(cr, 'gl_array_reduce', 'BIGINT[]', {'sfunc': 'gl_array_cat', 'stype': 'BIGINT[]'}) create_composite_type(cr, 'gl_journal_item', [('id', 'BIGINT'), ('date', 'DATE'), ('no', 'VARCHAR'), ('partner', 'VARCHAR'), ('remarks', 'VARCHAR'), ('debit', 'NUMERIC'), ('credit', 'NUMERIC'), ('top_level_debit', 'NUMERIC'), ('top_level_credit', 'NUMERIC'), ('comparison_order', 'BIGINT'), ('com_id', 'BIGINT')]) create_composite_type(cr, 'gl_axes_data_point', [('decorator_bold', 'BOOLEAN'), ('decorator_underline', 'BOOLEAN'), ('decorator_italic', 'BOOLEAN'), ('decorator_move_bold', 'BOOLEAN'), ('decorator_move_underline', 'BOOLEAN'), ('decorator_move_italic', 'BOOLEAN'), ('decorator_blank_line', 'BOOLEAN'), ('decorator_title_line', 'BOOLEAN'), ('rtn_order', 'BIGINT'), ('comparison_order', 'BIGINT'), ('comparison_label', 'VARCHAR'), ('com_order', 'BIGINT'), ('com_id', 'BIGINT'), ('com_name', 'VARCHAR'), ('rtn_name', 'VARCHAR'), ('rtn_level', 'BIGINT'), ('bb', 'NUMERIC'), ('dr', 'NUMERIC'), ('cr', 'NUMERIC'), ('mv', 'NUMERIC'), ('eb', 'NUMERIC'), ('move_lines_count', 'NUMERIC'), ('move_lines', 'BIGINT[]')]) create_composite_type(cr, 'gl_decorated_record', [('decorator_header_band_selector', 'INT'), ('decorator_band_selector', 'INT'), ('decorator_bold', 'BOOLEAN'), ('decorator_underline', 'BOOLEAN'), ('decorator_italic', 'BOOLEAN'), ('decorator_move_bold', 'BOOLEAN'), ('decorator_move_underline', 'BOOLEAN'), ('decorator_move_italic', 'BOOLEAN'), ('decorator_blank_line', 'BOOLEAN'), ('decorator_title_line', 'BOOLEAN'), ('nth_row', 'BIGINT'), ('comparison_order', 'BIGINT'), ('comparison_label', 'VARCHAR'), ('com_order', 'BIGINT'), ('com_name', 'VARCHAR'), ('rtn_name', 'VARCHAR'), ('rtn_level', 'BIGINT'), ('bb', 'NUMERIC'), ('dr', 'NUMERIC'), ('cr', 'NUMERIC'), ('mv', 'NUMERIC'), ('eb', 'NUMERIC'), ('ji_date', 'DATE'), ('ji_no', 'VARCHAR'), ('ji_partner', 'VARCHAR'), ('ji_remarks', 'VARCHAR')]) create_composite_type(cr, 'gl_id_nth_row', [('comparison_order', 'BIGINT'), ('id', 'BIGINT'), ('nth_row', 'BIGINT')]) create_plpgsql_proc(cr, 'gl_decorator', [('IN', 'axes_data_points', 'GL_AXES_DATA_POINT[]'), ('IN', 'journal_items', 'GL_JOURNAL_ITEM[]')], 'SETOF GL_DECORATED_RECORD', _GL_DECORATOR_DEF)
def _auto_init(self, cr, context=None): super(via_jasper_report, self)._auto_init(cr, context=context) create_plpgsql_proc(cr, 'gl_array_cat', [('IN', 'array_1', 'BIGINT[]'), ('IN', 'array_2', 'BIGINT[]')], 'BIGINT[]', _GL_ARRAY_CAT_DEF) create_aggregator(cr, 'gl_array_reduce', 'BIGINT[]', { 'sfunc': 'gl_array_cat', 'stype': 'BIGINT[]' }) create_composite_type(cr, 'gl_journal_item', [('id', 'BIGINT'), ('date', 'DATE'), ('no', 'VARCHAR'), ('partner', 'VARCHAR'), ('remarks', 'VARCHAR'), ('debit', 'NUMERIC'), ('credit', 'NUMERIC'), ('top_level_debit', 'NUMERIC'), ('top_level_credit', 'NUMERIC'), ('comparison_order', 'BIGINT'), ('com_id', 'BIGINT')]) create_composite_type(cr, 'gl_axes_data_point', [('decorator_bold', 'BOOLEAN'), ('decorator_underline', 'BOOLEAN'), ('decorator_italic', 'BOOLEAN'), ('decorator_move_bold', 'BOOLEAN'), ('decorator_move_underline', 'BOOLEAN'), ('decorator_move_italic', 'BOOLEAN'), ('decorator_blank_line', 'BOOLEAN'), ('decorator_title_line', 'BOOLEAN'), ('rtn_order', 'BIGINT'), ('comparison_order', 'BIGINT'), ('comparison_label', 'VARCHAR'), ('com_order', 'BIGINT'), ('com_id', 'BIGINT'), ('com_name', 'VARCHAR'), ('rtn_name', 'VARCHAR'), ('rtn_level', 'BIGINT'), ('bb', 'NUMERIC'), ('dr', 'NUMERIC'), ('cr', 'NUMERIC'), ('mv', 'NUMERIC'), ('eb', 'NUMERIC'), ('move_lines_count', 'NUMERIC'), ('move_lines', 'BIGINT[]')]) create_composite_type(cr, 'gl_decorated_record', [('decorator_header_band_selector', 'INT'), ('decorator_band_selector', 'INT'), ('decorator_bold', 'BOOLEAN'), ('decorator_underline', 'BOOLEAN'), ('decorator_italic', 'BOOLEAN'), ('decorator_move_bold', 'BOOLEAN'), ('decorator_move_underline', 'BOOLEAN'), ('decorator_move_italic', 'BOOLEAN'), ('decorator_blank_line', 'BOOLEAN'), ('decorator_title_line', 'BOOLEAN'), ('nth_row', 'BIGINT'), ('comparison_order', 'BIGINT'), ('comparison_label', 'VARCHAR'), ('com_order', 'BIGINT'), ('com_name', 'VARCHAR'), ('rtn_name', 'VARCHAR'), ('rtn_level', 'BIGINT'), ('bb', 'NUMERIC'), ('dr', 'NUMERIC'), ('cr', 'NUMERIC'), ('mv', 'NUMERIC'), ('eb', 'NUMERIC'), ('ji_date', 'DATE'), ('ji_no', 'VARCHAR'), ('ji_partner', 'VARCHAR'), ('ji_remarks', 'VARCHAR')]) create_composite_type(cr, 'gl_id_nth_row', [('comparison_order', 'BIGINT'), ('id', 'BIGINT'), ('nth_row', 'BIGINT')]) create_plpgsql_proc( cr, 'gl_decorator', [('IN', 'axes_data_points', 'GL_AXES_DATA_POINT[]'), ('IN', 'journal_items', 'GL_JOURNAL_ITEM[]')], 'SETOF GL_DECORATED_RECORD', _GL_DECORATOR_DEF)