You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
241 lines
11 KiB
241 lines
11 KiB
# -*- coding: utf-8 -*-
|
|
################################################################################
|
|
#
|
|
# Cybrosys Technologies Pvt. Ltd.
|
|
# Copyright (C) 2024-TODAY Cybrosys Technologies(<https://www.cybrosys.com>).
|
|
# Author: Bhagyadev KP (odoo@cybrosys.com)
|
|
#
|
|
# This program is free software: you can modify
|
|
# it under the terms of the GNU Affero General Public License (AGPL) as
|
|
# published by the Free Software Foundation, either version 3 of the
|
|
# License, or (at your option) any later version.
|
|
#
|
|
# This program is distributed in the hope that it will be useful,
|
|
# but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
# GNU Affero General Public License for more details.
|
|
#
|
|
# You should have received a copy of the GNU Affero General Public License
|
|
# along with this program. If not, see <https://www.gnu.org/licenses/>.
|
|
#
|
|
################################################################################
|
|
import xlsxwriter
|
|
import io
|
|
import json
|
|
import datetime
|
|
from odoo import fields, models
|
|
from odoo.tools import date_utils
|
|
|
|
|
|
class ExcelReport(models.TransientModel):
|
|
"""This is used to the wizard class"""
|
|
_name = "excel.report"
|
|
_description = "excel report"
|
|
|
|
def print_excel_report(self):
|
|
"""this is used to do the report action"""
|
|
excel_report_id = self.env['report.excel'].browse(
|
|
self._context.get('excel'))
|
|
for rec in excel_report_id:
|
|
data = {
|
|
'report_name': rec.name,
|
|
'model_name': rec.model_id.model,
|
|
'fields_name': rec.fields_ids.mapped('name'),
|
|
'field_label': rec.fields_ids.mapped('field_description'),
|
|
'date_field_id': rec.date_field_id.name,
|
|
'date_name': rec.date_field_id.field_description,
|
|
'start_date': rec.start_date,
|
|
'end_date': rec.end_date,
|
|
'field_order': rec.field_order,
|
|
'active_model_id': self.env.context['active_ids']
|
|
}
|
|
return {
|
|
'type': 'ir.actions.report',
|
|
'data': {'model': 'excel.report',
|
|
'options': json.dumps(data,
|
|
default=date_utils.json_default),
|
|
'output_format': 'xlsx',
|
|
'report_name': rec.name,
|
|
},
|
|
'report_type': 'stock_xlsx',
|
|
}
|
|
|
|
def get_xlsx_report(self, data, response):
|
|
"""This is used to prin the report for selected records."""
|
|
output = io.BytesIO()
|
|
workbook = xlsxwriter.Workbook(output, {'in_memory': True})
|
|
sheet = workbook.add_worksheet()
|
|
# Formats
|
|
format1 = workbook.add_format(
|
|
{'font_size': 15, 'align': 'center', 'bold': True})
|
|
format1.set_font_color('#000080')
|
|
format2 = workbook.add_format(
|
|
{'font_size': 11, 'bold': True, 'border': 1, 'bg_color': '#928E8E'})
|
|
format4 = workbook.add_format(
|
|
{'font_size': 10, 'num_format': 'yyyy-m-d', 'align': 'center',
|
|
'bold': True})
|
|
format5 = workbook.add_format(
|
|
{'font_size': 10, 'border': 1, 'text_wrap': True})
|
|
format6 = workbook.add_format({'font_size': 10, 'bold': True})
|
|
format8 = workbook.add_format({'font_size': 10, 'border': 1})
|
|
format9 = workbook.add_format(
|
|
{'font_size': 10, 'num_format': 'yyyy-m-d'})
|
|
format10 = workbook.add_format(
|
|
{'font_size': 10, 'num_format': 'yyyy-m-d', 'border': 1})
|
|
format2.set_align('center')
|
|
format4.set_align('right')
|
|
format6.set_align('right')
|
|
format8.set_align('left')
|
|
sheet.merge_range(1, 1, 1, len(data['field_label']) + 1,
|
|
data['report_name'], format1)
|
|
sheet.write(2, 0, "Date :", format4)
|
|
sheet.write(2, 1, fields.Datetime.today(), format4)
|
|
if data['date_field_id']:
|
|
sheet.write(3, 0, data['date_name'], format4)
|
|
if data['start_date']:
|
|
sheet.write(3, 1, "From:", format4)
|
|
sheet.write(3, 2, data['start_date'], format9)
|
|
else:
|
|
sheet.write(3, 2, "", format9)
|
|
if data['end_date']:
|
|
sheet.write(3, 3, "To:", format4)
|
|
sheet.write(3, 4, data['end_date'], format9)
|
|
else:
|
|
sheet.write(3, 4, "", format9)
|
|
sl_no = 1
|
|
sheet.write(5, 1, "SL No", format2)
|
|
row_num = 5
|
|
col_num = 2
|
|
order = data['field_order'].strip('][').split(', ')
|
|
for field_id in order:
|
|
field_name = self.env['ir.model.fields'].browse(
|
|
int(field_id)).field_description
|
|
sheet.write(row_num, col_num, field_name, format2)
|
|
col_num += 1
|
|
row_num += 1
|
|
records = []
|
|
if data['date_field_id']:
|
|
if data['start_date'] and data['end_date']:
|
|
records = self.env[data['model_name']].search([
|
|
(data['date_field_id'], '>=', data['start_date']),
|
|
('id', 'in', data['active_model_id']),
|
|
(data['date_field_id'], '<=', data['end_date'])])
|
|
elif data['start_date'] and not data['end_date']:
|
|
records = self.env[data['model_name']].search([
|
|
(data['date_field_id'], '>=', data['start_date']),
|
|
('id', 'in', data['active_model_id'])])
|
|
elif not data['start_date'] and data['end_date']:
|
|
records = self.env[data['model_name']].search([
|
|
(data['date_field_id'], '<=', data['end_date']),
|
|
('id', 'in', data['active_model_id'])])
|
|
else:
|
|
records = self.env[data['model_name']].search(
|
|
[('id', 'in', data['active_model_id'])])
|
|
new_table = []
|
|
for record in records:
|
|
order = data['field_order'].strip('][').split(', ')
|
|
record_dict = {}
|
|
for field_id in order:
|
|
field = self.env['ir.model.fields'].browse(int(field_id))
|
|
field_name = field.name
|
|
field_type = self.env['ir.model.fields'].browse(
|
|
int(field_id)).ttype
|
|
if field_type in ['many2many']:
|
|
one2many_values = ', '.join(
|
|
record[field_name].mapped('name'))
|
|
record_dict[field] = [one2many_values]
|
|
elif field_type in ['one2many']:
|
|
# if record[field_name]:
|
|
o2m_list = []
|
|
for rec in record[field_name]:
|
|
if rec:
|
|
o2m_list.append(rec)
|
|
else:
|
|
o2m_list.append('')
|
|
record_dict[field] = o2m_list
|
|
else:
|
|
record_dict[field] = [record[field_name]]
|
|
new_table.append(record_dict)
|
|
for record in new_table:
|
|
col_num = 1
|
|
sheet.write(row_num, col_num, sl_no, format5)
|
|
col_num += 1
|
|
occupied_rows = max(len(value) for value in record.values())
|
|
for field in record:
|
|
field_type = self.env['ir.model.fields'].browse(
|
|
int(field.id)).ttype
|
|
if not field_type in ['one2many', 'many2many']:
|
|
try:
|
|
if isinstance(record[field][0], datetime.date):
|
|
sheet.write(row_num, col_num, record[field][0],
|
|
format10)
|
|
elif isinstance(record[field][0], bool):
|
|
if not field:
|
|
sheet.write(row_num, col_num, " ", format5)
|
|
else:
|
|
sheet.write(row_num, col_num, "Yes", format5)
|
|
else:
|
|
sheet.write(row_num, col_num, record[field][0],
|
|
format5)
|
|
except Exception as e:
|
|
if record[field][0]:
|
|
sheet.write(row_num, col_num,
|
|
record[field][0].name_get()[0][1],
|
|
format5)
|
|
else:
|
|
sheet.write(row_num, col_num, "",
|
|
format5)
|
|
elif field_type == 'one2many':
|
|
for i in range(occupied_rows):
|
|
if len(record[field]) > i:
|
|
try:
|
|
if isinstance(record[field][i], datetime.date):
|
|
sheet.write(row_num + i, col_num,
|
|
record[field][i], format10)
|
|
elif isinstance(record[field][i], bool):
|
|
if not field:
|
|
sheet.write(row_num + i, col_num, "NO",
|
|
format5)
|
|
else:
|
|
sheet.write(row_num + i, col_num, "Yes",
|
|
format5)
|
|
else:
|
|
sheet.write(row_num + i, col_num,
|
|
record[field][i], format5)
|
|
except Exception as e:
|
|
if record[field][i]:
|
|
sheet.write(row_num + i, col_num,
|
|
record[field][i].name_get()[0][
|
|
1], format5)
|
|
else:
|
|
sheet.write(row_num + i, col_num, "",
|
|
format5)
|
|
elif field_type == 'many2many':
|
|
if record[field]:
|
|
try:
|
|
if isinstance(record[field], datetime.date):
|
|
sheet.write(row_num, col_num, record[field][0],
|
|
format10)
|
|
elif isinstance(record[field], bool):
|
|
if not field:
|
|
sheet.write(row_num, col_num, " ", format5)
|
|
else:
|
|
sheet.write(row_num, col_num, "Yes",
|
|
format5)
|
|
else:
|
|
sheet.write(row_num, col_num, record[field][0],
|
|
format5)
|
|
except Exception as e:
|
|
if record[field][0]:
|
|
sheet.write(row_num, col_num,
|
|
record[field].name_get()[0][1],
|
|
format5)
|
|
else:
|
|
sheet.write(row_num, col_num, "", format5)
|
|
col_num += 1
|
|
row_num += occupied_rows
|
|
sl_no += 1
|
|
workbook.close()
|
|
output.seek(0)
|
|
response.stream.write(output.read())
|
|
output.close()
|
|
|