def get_objects(self, cr, uid, ids, report, data={}, context=None):
pool = pooler.get_pool(cr.dbname)
objects = []
if report.custom_sql:
cr.execute(report.custom_sql_src % data.get("form", {}))
records = cr.fetchall()
for record in records:
columns = {}
i = 0
for desc in cr._obj.description:
columns[desc[0]] = record[i]
i += 1
objects.append(columns)
else:
if report.custom_domain:
domain = eval(report.custom_domain_src % data.get("form", {}))
if report.custom_order:
ids = pool.get(report.model).search(cr, uid, domain, order=report.custom_order_src, context=context)
else:
ids = pool.get(report.model).search(cr, uid, domain, context=context)
elif report.custom_order:
ids = pool.get(report.model).search(
cr, uid, [("id", "in", ids)], order=report.custom_order_src, context=context
)
objects = pool.get(report.model).browse(cr, uid, ids, context=context)
return objects
def create(self, cr, uid, ids, data, context=None):
if context is None: context = {}
pool = pooler.get_pool(cr.dbname)
report_obj = pool.get('ir.actions.report.xml')
if context.has_key('cubicReport'):
report = report_obj.browse(cr,
uid,
context.get('cubicReport').get('id'),
context=context)
context['active_id'] = data['form']['cubicReport']['context'].get(
'active_id')
context['active_ids'] = data['form']['cubicReport']['context'].get(
'active_ids', [])
else:
report = report_obj.browse(
cr,
uid,
report_obj.search(cr,
uid, [('report_name', '=', self.name[7:])],
context=context)[0],
context=context)
objects = self.get_objects(cr, uid, ids, report, data, context=context)
tmp_file_name = '%s-%s' % (report.report_name, time.time())
context['tmp_file_name'] = tmp_file_name
for k in data.get('form', {}):
context['params_' + k] = data['form'][k]
tmp_file = report.generator_type == 'prn' and '%s.%s' % (
tmp_file_name, report.generator_type) or StringIO.StringIO()
_report_class = self._get_report_class(cr,
uid,
report,
context=context)(
cr,
uid,
pool,
queryset=objects,
report=report,
context=context)
if report.generator_type == 'pdf':
_report_class.generate_by(PDFGenerator,
filename=tmp_file,
variables=data.get('form', {}))
elif report.generator_type == 'prn':
_report_class.generate_by(TextGenerator,
filename=tmp_file,
variables=data.get('form', {}))
elif report.generator_type == 'csv':
_report_class.generate_by(CSVGenerator,
filename=tmp_file,
variables=data.get('form', {}))
res = (report.generator_type == 'prn' and open(tmp_file, 'r').read()
or tmp_file.getvalue(), report.extension_file
or report.generator_type)
for tmp_file in glob.glob('%s.*' % tmp_file_name):
os.remove(tmp_file)
return res
def create(self, cr, uid, ids, data, context=None):
if context is None:
context = {}
pool = pooler.get_pool(cr.dbname)
report_obj = pool.get("ir.actions.report.xml")
if context.has_key("cubicReport"):
report = report_obj.browse(cr, uid, context.get("cubicReport").get("id"), context=context)
context["active_id"] = data["form"]["cubicReport"]["context"].get("active_id")
context["active_ids"] = data["form"]["cubicReport"]["context"].get("active_ids", [])
else:
report = report_obj.browse(
cr,
uid,
report_obj.search(cr, uid, [("report_name", "=", self.name[7:])], context=context)[0],
context=context,
)
objects = self.get_objects(cr, uid, ids, report, data, context=context)
tmp_file_name = "%s-%s" % (report.report_name, time.time())
context["tmp_file_name"] = tmp_file_name
for k in data.get("form", {}):
context["params_" + k] = data["form"][k]
tmp_file = (
report.generator_type == "prn" and "%s.%s" % (tmp_file_name, report.generator_type) or StringIO.StringIO()
)
_report_class = self._get_report_class(cr, uid, report, context=context)(
cr, uid, pool, queryset=objects, report=report, context=context
)
if report.generator_type == "pdf":
_report_class.generate_by(PDFGenerator, filename=tmp_file, variables=data.get("form", {}))
elif report.generator_type == "prn":
_report_class.generate_by(TextGenerator, filename=tmp_file, variables=data.get("form", {}))
elif report.generator_type == "csv":
_report_class.generate_by(CSVGenerator, filename=tmp_file, variables=data.get("form", {}))
res = (
report.generator_type == "prn" and open(tmp_file, "r").read() or tmp_file.getvalue(),
report.extension_file or report.generator_type,
)
for tmp_file in glob.glob("%s.*" % tmp_file_name):
os.remove(tmp_file)
return res
def get_objects(self, cr, uid, ids, report, data={}, context=None):
pool = pooler.get_pool(cr.dbname)
objects = []
if report.custom_sql:
cr.execute(report.custom_sql_src % data.get('form', {}))
records = cr.fetchall()
for record in records:
columns = {}
i = 0
for desc in cr._obj.description:
columns[desc[0]] = record[i]
i += 1
objects.append(columns)
else:
if report.custom_domain:
domain = eval(report.custom_domain_src % data.get('form', {}))
if report.custom_order:
ids = pool.get(report.model).search(
cr,
uid,
domain,
order=report.custom_order_src,
context=context)
else:
ids = pool.get(report.model).search(cr,
uid,
domain,
context=context)
elif report.custom_order:
ids = pool.get(report.model).search(
cr,
uid, [('id', 'in', ids)],
order=report.custom_order_src,
context=context)
objects = pool.get(report.model).browse(cr,
uid,
ids,
context=context)
return objects
