Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

how to generate single report for all manufacturing orders?

By
Hammad hussain qureshi
on 3/4/15, 10:19 AM 346 views

I want to send daily manufacturing orders details to the manager via email. I had tried to acheive this by using email templates, it only generating report for only one manufacturing. Any good approach for this? 

0

I have acheived it by attaching custom report consisting of all MOs with the email template 

 

 if matching_reports:
            report = ir_actions_report.browse(cr, uid, matching_reports[0])
            report_service = 'report.' + report.report_name
            service = netsvc.LocalService(report_service)
            (result, format) = service.create(cr, uid, mrp_ids, {'model': self._name}, context=context)
#             eval_context = {'time': time, 'object': self.pool.get('mrp.production')}

        if not report.attachment: # or not eval(report.attachment, eval_context)
              
            file_name = "dailyreport" #re.sub(r'[^a-zA-Z0-9_-]', '_', 'dailyreport')
            file_name += ".pdf"
            attachment_id = attachment_obj.create(cr, uid,
                                                  {
                                                   'name': file_name,
                                                   'datas': result,
                                                   'datas_fname': file_name,
#                                                    'res_model': 'email.template',
#                                                    'res_id': email.id,
                                                   'type': 'binary'
                                                   }, context=context)
          
        email_obj.write(cr, uid, template_id, {'email_from': email.email_from, 
                                               'email_to': email.email_to, 
                                               'subject': email.subject,
                                               'body_html':email.body_html,
                                               'email_recipients': email.email_recipients,
                                               'attachment_ids' : [(6,0, [attachment_id])],
                                               })

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 3/4/15, 10:19 AM
Seen: 346 times
Last updated: 3/28/15, 7:42 AM