Exemplo n.º 1
0
# -*- encoding: utf-8 -*-
from openerp.addons import jasper_reports


def pabi_advance_dunning_letter_parser(cr, uid, ids, data, context):
    if context.get('email_attachment', False):
        return {
            'ids': context['ids'],
            'parameters': {
                'date_print': context['date_print'],
            }
        }
    # For ORM, just pass ids
    return {
        'ids': data['parameters']['ids'],
        'parameters': {
            'date_print': data['parameters']['date_print'],
        }
    }


jasper_reports.report_jasper(
    'report.advance_dunning_letter',  # report_name in report_data.xml
    'pabi.advance.dunning.letter.line',  # Model View name
    parser=pabi_advance_dunning_letter_parser,
)
Exemplo n.º 2
0
#
##############################################################################
from openerp import pooler, _
from openerp.addons import jasper_reports
from datetime import datetime


def parser(cr, uid, ids, data, context):
    parameters = {}
    ids = ids
    name = 'report.stock_picking_out_std_2x'
    model = 'stock.picking'
    data_source = 'model'
    picking = pooler.get_pool(cr.dbname).get('stock.picking').browse(
        cr, uid, ids)
    language = picking and picking[0].partner_id.lang or False
    context['lang'] = language

    return {
        'ids': ids,
        'name': name,
        'model': model,
        'records': [],
        'data_source': data_source,
        'parameters': parameters,
    }


jasper_reports.report_jasper('report.stock_picking_out_std_2x',
                             'stock.picking', parser)
Exemplo n.º 3
0
            invoice = str(inv['name'])
            if i == a:
                invo += str(invoice)
            else:
                invo += str(invoice) + ' ,'
    return {
        'parameters': {
            'voucher_id': ids[0],
            'vat1' : vat1,
            'vat2' : vat2,
            'vat3' : vat3,
            'vat4' : vat4,
            'cvat1' : cvat1,
            'cvat2' : cvat2,
            'cvat3' : cvat3,
            'cvat4' : cvat4,
            'company': company.name,
            'street': company.street,
            'city': company.city or '',
            'invoice': invo,
            
        }, 
    }

jasper_reports.report_jasper(
    'report.account_voucher1',
    'account.voucher',
    parser=jasper_witholding
)

                uom_qty,
                'uos_qty':
                uos_qty,
                'uom_name':
                uom_id.name or '',
                'uos_name':
                uos_id.name or uom_id.name or '',
                'price_unit':
                price_unit or 0.0,
                'discount':
                line.discount or 0.0,
                'price_subtotal':
                line.price_subtotal,
                'taxes':
                line.tax_str or '',
            }
            invoice_lines_ids[str(invoice_id.id)].append(vals)
    parameters['invoice_lines_ids'] = invoice_lines_ids
    return {
        'ids': ids,
        'name': name,
        'model': model,
        'records': [],
        'data_source': data_source,
        'parameters': parameters,
    }


jasper_reports.report_jasper('report.invoice_report_jasper', 'account.invoice',
                             parser)
#    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 <http://www.gnu.org/licenses/>.
#
##############################################################################
from openerp.addons import jasper_reports


def parser(cr, uid, ids, data, context):
    language = data['form']['language']
    parameters = {}
    name = 'report.product_logistics_sheet'
    model = 'product.product'
    data_source = 'model'
    parameters['lang'] = language
    context['lang'] = language
    return {
        'ids': ids,
        'name': name,
        'model': model,
        'records': [],
        'data_source': data_source,
        'parameters': parameters,
    }


jasper_reports.report_jasper('report.product_logistics_sheet',
                             'product.product', parser)
Exemplo n.º 6
0
# -*- coding: utf-8 -*-
from openerp.addons import jasper_reports


def jasper_report_parser(cr, uid, ids, data, context):
    return data


jasper_reports.report_jasper(
    'report.cd_receivable_payment_history_group_by_customer',
    'cd.receivable.payment.history.view',
    parser=jasper_report_parser,
)

jasper_reports.report_jasper(
    'report.cd_receivable_payment_history_group_by_bank',
    'cd.receivable.payment.history.view',
    parser=jasper_report_parser,
)

jasper_reports.report_jasper(
    'report.cd_receivable_follow_up_group_by_customer',
    'cd.receivable.follow.up.view',
    parser=jasper_report_parser,
)

jasper_reports.report_jasper(
    'report.cd_receivable_follow_up_group_by_bank',
    'cd.receivable.follow.up.view',
    parser=jasper_report_parser,
)
Exemplo n.º 7
0
#--------------DELIVERY ORDER-----------------#

def delivery_order(cr, uid, ids, data, context):

    pool = pooler.get_pool(cr.dbname)
    s_id = pool.get('stock.picking').browse(cr, uid, ids[0], context=context).id

    return {
	'parameters':{
			'x': s_id

		},
	    }

jasper_reports.report_jasper('report.delivery_order','stock.picking',parser=delivery_order)


#--------------CERTIFICATE PRINT-----------------#

def certificate_print(cr, uid, ids, data, context):

    pool = pooler.get_pool(cr.dbname)
    s_id = pool.get('stock.production.lot').browse(cr, uid, ids[0],context=context).id

    return {
	'parameters':{
			'x': s_id,
		},
	    }
Exemplo n.º 8
0
#	it under the terms of the GNU Affero General Public License 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 <http://www.gnu.org/licenses/>.
#
##############################################################################
from openerp.addons import jasper_reports
from openerp.osv import osv, fields
import openerp.pooler
import datetime


def jasper_declaration_trim_cnss_parser(cr, uid, ids, data, context):
    return {
        'parameters': {
            'id_cnss': ids[0],
        },
    }


jasper_reports.report_jasper('report.hr_cnss_statement',
                             'hr.cnss',
                             parser=jasper_declaration_trim_cnss_parser)
# -*- encoding: utf-8 -*-
from openerp.addons import jasper_reports


def report_sample_partner_orm_parser(cr, uid, ids, data, context):
    # For ORM, just pass ids
    return {
        'ids': data['parameters']['ids'],
        'parameters': {
            'xxx': data['parameters']['ids'],
        }
    }


jasper_reports.report_jasper(
    'report.report_sample_partner_orm',  # report_name in report_data.xml
    'report.sample.partner.orm',  # Model View name
    parser=report_sample_partner_orm_parser,
)
# -*- coding: utf-8 -*-
from openerp.addons import jasper_reports


def pabi_hr_advance_status_report_parser(cr, uid, ids, data, context):
    # For ORM, just pass ids
    return {
        'ids': data['parameters']['ids'],
    }


jasper_reports.report_jasper(
    'report.pabi_hr_advance_status_report',
    'hr.expense.expense',
    parser=pabi_hr_advance_status_report_parser,
)

jasper_reports.report_jasper(
    'report.pabi_hr_advance_status_summary_report',
    'hr.expense.expense',
    parser=pabi_hr_advance_status_report_parser,
)

jasper_reports.report_jasper(
    'report.pabi_hr_advance_status_detail_report',
    'hr.expense.expense',
    parser=pabi_hr_advance_status_report_parser,
)
Exemplo n.º 11
0
import openerp
from openerp import pooler
from openerp.osv import osv, fields 

import datetime
import os
from openerp.tools.translate import _
import openerp.addons
from openerp.addons import jasper_reports

def jasper_mission(cr, uid, ids, data, context):
    return {
        'parameters': {
            'mission_id': ids[0],
        },
    }

jasper_reports.report_jasper(
    'report.mission_order',
    'mission.order',
    parser=jasper_mission
)

jasper_reports.report_jasper(
    'report.mission_order_xls',
    'mission.order',
    parser=jasper_mission
)


def print_account_invoice_parser(cr, uid, ids, data, context):
    return {
        'ids': data['parameters']['ids'],
    }


# jasper_reports.report_jasper(
#     'account.invoice.form',  # report_name in account_data.xml
#     'account.invoice',  # Model View name
#     parser=print_account_invoice_parser
# )

jasper_reports.report_jasper(
    'report.customer.invoice.en.form',
    'account.invoice',  # Model View name
    parser=print_account_invoice_parser)

jasper_reports.report_jasper(
    'report.customer.invoice.th.form',
    'account.invoice',  # Model View name
    parser=print_account_invoice_parser)

jasper_reports.report_jasper(
    'report.customer.tax.receipt.picking.form.en',
    'account.invoice',  # Model View name
    parser=print_account_invoice_parser)

jasper_reports.report_jasper(
    'report.customer.tax.receipt.picking.form.th',
    'account.invoice',  # Model View name
from openerp.addons import jasper_reports


def print_internal_charge_parser(cr, uid, ids, data, context):
    return {
        'ids': data['parameters']['ids'],
    }


jasper_reports.report_jasper(
    'report.internal.charge',  #report data name
    'hr.expense.expense',  # Model View name
    parser=print_internal_charge_parser)
Exemplo n.º 14
0
# -*- coding: utf-8 -*-
from openerp.addons import jasper_reports


def jasper_report_parser(cr, uid, ids, data, context):
    return data


jasper_reports.report_jasper(
    'report.cd_receivable_payment_history_group_by_customer',
    'pabi.common.loan.agreement.report.view',
    parser=jasper_report_parser,
)

jasper_reports.report_jasper(
    'report.cd_receivable_payment_history_group_by_bank',
    'pabi.common.loan.agreement.report.view',
    parser=jasper_report_parser,
)

jasper_reports.report_jasper(
    'report.cd_receivable_follow_up_group_by_customer',
    'pabi.common.loan.agreement.report.view',
    parser=jasper_report_parser,
)

jasper_reports.report_jasper(
    'report.cd_receivable_follow_up_group_by_bank',
    'pabi.common.loan.agreement.report.view',
    parser=jasper_report_parser,
)
Exemplo n.º 15
0
        if a == 1:
            invo = str(inv['name'])
        else:
            invoice = str(inv['name'])
            if i == a:
                invo += str(invoice)
            else:
                invo += str(invoice) + ' ,'
    return {
        'parameters': {
            'voucher_id': ids[0],
            'vat1': vat1,
            'vat2': vat2,
            'vat3': vat3,
            'vat4': vat4,
            'cvat1': cvat1,
            'cvat2': cvat2,
            'cvat3': cvat3,
            'cvat4': cvat4,
            'company': company.name,
            'street': company.street,
            'city': company.city or '',
            'invoice': invo,
        },
    }


jasper_reports.report_jasper('report.account_voucher1',
                             'account.voucher',
                             parser=jasper_witholding)
Exemplo n.º 16
0
import openerp
from openerp import pooler
from openerp.osv import osv, fields 

import datetime
import os
from openerp.tools.translate import _
import openerp.addons
from openerp.addons import jasper_reports

def jasper_vesement(cr, uid, ids, data, context):
    return {
        'parameters': {
            'vesement_id': ids[0],
        }, 
    }

jasper_reports.report_jasper(
    'report.vesement',
    'account.vesement',
    parser=jasper_vesement
)

jasper_reports.report_jasper(
    'report.cash_vesement',
    'account.vesement.cash',
    parser=jasper_vesement
)

Exemplo n.º 17
0
                    production.id)] or line.workcenter_id.control_sheet_mixed

    parameters = {}
    name = 'report.control_part'
    model = 'mrp.production'
    data_source = 'model'

    parameters['control_sheet_packing'] = control_sheet_packing
    parameters['control_sheet_salted'] = control_sheet_salted
    parameters['control_sheet_toasted'] = control_sheet_toasted
    parameters['control_sheet_fried'] = control_sheet_fried
    parameters['control_sheet_mixed'] = control_sheet_mixed

    parameters['control_sheet_packing_ids'] = control_sheet_packing_ids
    parameters['control_sheet_salted_ids'] = control_sheet_salted_ids
    parameters['control_sheet_toasted_ids'] = control_sheet_toasted_ids
    parameters['control_sheet_fried_ids'] = control_sheet_fried_ids
    parameters['control_sheet_mixed_ids'] = control_sheet_mixed_ids

    return {
        'ids': ids,
        'name': name,
        'model': model,
        'records': [],
        'data_source': data_source,
        'parameters': parameters,
    }


jasper_reports.report_jasper('report.control_part', 'mrp.production', parser)
                control_sheet_mixed_ids[str(production.id)] = control_sheet_mixed_ids[str(production.id)] or line.workcenter_id.control_sheet_mixed

    parameters = {}
    ids = ids
    name = 'report.control_part'
    model = 'mrp.production'
    data_source = 'model'

    parameters['control_sheet_packing'] = control_sheet_packing
    parameters['control_sheet_salted'] = control_sheet_salted
    parameters['control_sheet_toasted'] = control_sheet_toasted
    parameters['control_sheet_fried'] = control_sheet_fried
    parameters['control_sheet_mixed'] = control_sheet_mixed

    parameters['control_sheet_packing_ids'] = control_sheet_packing_ids
    parameters['control_sheet_salted_ids'] = control_sheet_salted_ids
    parameters['control_sheet_toasted_ids'] = control_sheet_toasted_ids
    parameters['control_sheet_fried_ids'] = control_sheet_fried_ids
    parameters['control_sheet_mixed_ids'] = control_sheet_mixed_ids

    return {
        'ids': ids,
        'name': name,
        'model': model,
        'records': [],
        'data_source': data_source,
        'parameters': parameters,
    }

jasper_reports.report_jasper('report.control_part', 'mrp.production', parser)
Exemplo n.º 19
0
from openerp.addons import jasper_reports
from openerp.osv import osv,fields
import openerp.pooler


def jasper_packing_parser( cr, uid, ids, data, context ):
    print"==========ids==============0",ids
    if 'picking_id' not in data:
        data['picking_id']=ids
    print"========== data['picking_id']==============",data['picking_id']
    return {
        'parameters': {
            'picking_id': data['picking_id'],
        },
   }

jasper_reports.report_jasper(
    'report.jasper_packing_list',
    'stock.picking',
    parser=jasper_packing_parser
)
Exemplo n.º 20
0
# -*- coding: utf-8 -*-
from openerp.addons import jasper_reports


def print_voucher_parser(cr, uid, ids, data, context):
    return {
        'ids': data['parameters']['ids'],
    }


# KV Voucher && DV Voucher
jasper_reports.report_jasper(
    'report.invoice.voucher',  # report_name in account_data.xml
    'account.move',  # Model View name
    parser=print_voucher_parser)

# PV Voucher
jasper_reports.report_jasper(
    'report.payment.voucher',  # report_name in account_data.xml
    'account.move',  # Model View name
    parser=print_voucher_parser)

# RC Voucher
jasper_reports.report_jasper(
    'report.receipt.voucher',  # report_name in account_data.xml
    'account.move',  # Model View name
    parser=print_voucher_parser)

# RV Voucher
jasper_reports.report_jasper(
    'report.bank.receipt.voucher',  # report_name in account_data.xml
#    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 <http://www.gnu.org/licenses/>.
#
##############################################################################
from openerp.addons import jasper_reports
from openerp import pooler
from datetime import datetime
from openerp.tools.translate import _

def parser( cr, uid, ids, data, context ):
    language = data['form']['language']
    parameters = {}
    ids = ids
    name = 'report.product_logistics_sheet'
    model = 'product.product'
    data_source = 'model'
    parameters['lang'] = language
    context['lang'] = language

    return { 
        'ids': ids, 
        'name': name, 
        'model': model, 
        'records': [], 
        'data_source': data_source,
        'parameters': parameters,
    }
jasper_reports.report_jasper( 'report.product_logistics_sheet', 'product.product', parser )
Exemplo n.º 22
0
from openerp.osv import osv, fields
import pooler
import datetime
from openerp.addons import jasper_reports
from openerp.tools.translate import _


def ijarah_equip( cr, uid, ids, data, context ):
      id1 = data['form']['id']
      return {
        'parameters': {	
          	'x': id1
        },
   }

jasper_reports.report_jasper('report.ijarah_equip_report', 'ijarah.hr.emp.equip', parser=ijarah_equip)
############################################# Receive Asset REports ###############################################################
def ijarah_equip_receive( cr, uid, ids, data, context ):
      id1 = data['form']['id']
      return {
        'parameters': {	
          	'x': id1
        },
   }

jasper_reports.report_jasper('report.ijarah_equip_report_receive', 'ijarah.hr.emp.equip', parser=ijarah_equip_receive)
######################################################### Sales Commission Import ###################################################
def ijarah_sales_com_parser(cr, uid, ids, data, context ):
    
	from_date = data['form'].get('from_date')
	to_date = data['form'].get('to_date')
#    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 <http://www.gnu.org/licenses/>.
#
##############################################################################
from openerp.addons import jasper_reports


def parser(cr, uid, ids, data, context):
    language = data['form']['language']
    parameters = {}
    name = 'report.product_technical_sheet'
    model = 'product.technical.sheet'
    data_source = 'model'
    parameters['lang'] = language
    context['lang'] = language
    return {
        'ids': ids,
        'name': name,
        'model': model,
        'records': [],
        'data_source': data_source,
        'parameters': parameters,
    }


jasper_reports.report_jasper('report.product_technical_sheet',
                             'product.technical.sheet', parser)
Exemplo n.º 24
0
# -*- encoding: utf-8 -*-
from openerp.addons import jasper_reports


def print_account_voucher_parser(cr, uid, ids, data, context):
    return {
        'ids': data['parameters']['ids'],
    }


jasper_reports.report_jasper(
    'report.supplier_netpay_form_en',
    'account.voucher',  # Model View name
    parser=print_account_voucher_parser
)

jasper_reports.report_jasper(
    'report.supplier_netpay_form_th',
    'account.voucher',  # Model View name
    parser=print_account_voucher_parser
)

jasper_reports.report_jasper(
    'report.customer.receipt.form.en',
    'account.voucher',  # Model View name
    parser=print_account_voucher_parser
)

jasper_reports.report_jasper(
    'report.customer.receipt.form.th',
    'account.voucher',  # Model View name
Exemplo n.º 25
0
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
##############################################################################

import openerp
from openerp import pooler
from openerp.osv import osv, fields

import datetime
import os
from openerp.tools.translate import _
import openerp.addons
from openerp.addons import jasper_reports


def jasper_vesement(cr, uid, ids, data, context):
    return {
        'parameters': {
            'vesement_id': ids[0],
        },
    }


jasper_reports.report_jasper('report.vesement',
                             'account.vesement',
                             parser=jasper_vesement)

jasper_reports.report_jasper('report.cash_vesement',
                             'account.vesement.cash',
                             parser=jasper_vesement)
    def send_mail(self, cr, uid, ids, context=None):

        if context is None:
            context = {}
        attachments = []

        form_obj = self.pool.get("mail.compose.message.product.datasheet").browse(cr, uid, ids[0], context=context)

        date = time.strftime("%Y-%m-%d %H:%M:%S")
        sent_date = _("On %(date)s, ") % {"date": date}
        sender = _("%(sender_name)s wrote:") % {"sender_name": tools.ustr(form_obj.email_from or _("You"))}
        quoted_body = "> %s" % tools.ustr(form_obj.body_text.replace("\n", "\n> ") or "")
        body = "\n".join(["\n", (sent_date + sender), quoted_body])
        if form_obj.user_signature == 1:
            body += "\n" + (self.pool.get("res.users").browse(cr, uid, uid).signature or "")

            subject = "%s" % (form_obj.subject)
        msg_vals = {
            "subject": form_obj.subject,
            "date": time.strftime("%Y-%m-%d %H:%M:%S"),
            "user_id": uid,
            "model": "product.product",
            "res_id": context["active_id"],
            "body_text": body,
            "body_html": False,
            "email_from": form_obj.email_from,
            "email_to": form_obj.email_to,
            "email_cc": "",
            "email_bcc": "",
            "subtype": "plain",
            #'headers': headers, # serialize the dict on the fly
            "state": "outgoing",
            "auto_delete": True,
        }
        email_msg_id = self.pool.get("mail.message").create(cr, uid, msg_vals, context)

        if form_obj.report_template:
            jasper_class = report_jasper("report.product.datasheet.jasper", "product.product", parser=None)
            (result, format) = jasper_class.create(
                cr,
                uid,
                context["active_ids"],
                {"model": "product.product", "id": context["active_ids"][0], "ids": context["active_ids"]},
                context=context,
            )

            attachment_data = {
                "name": "ficha_tecnica_" + time.strftime("%Y-%m-%d") + ".pdf",
                "datas_fname": "ficha_tecnica_" + time.strftime("%Y-%m-%d") + ".pdf",
                "datas": result and result.encode("base64"),
                "res_model": "mail.message",
                "res_id": email_msg_id,
            }

            attachments.append(self.pool.get("ir.attachment").create(cr, uid, attachment_data, context))
            if attachments:
                self.pool.get("mail.message").write(
                    cr, uid, email_msg_id, {"attachment_ids": [(6, 0, attachments)]}, context=context
                )

        ok = self.pool.get("mail.message").send(cr, uid, [email_msg_id], context=context)

        if ok == True:
            product_obj = self.pool.get("product.product").browse(cr, uid, context["active_ids"][0])
            if form_obj.contact_ids:
                for cont in form_obj.contact_ids:
                    if cont.partner_id:
                        partner_id = cont.partner_id.id
                    else:
                        partner_id = False

                    self.pool.get("product.sheet.shipments").create(
                        cr,
                        uid,
                        {
                            "partner_id": partner_id,
                            "contact_id": cont.id,
                            "date": time.strftime("%Y-%m-%d"),
                            "product_id": product_obj.id,
                            "revision": product_obj.last_revision,
                        },
                    )

        return {"type": "ir.actions.act_window_close"}
Exemplo n.º 27
0
x = datetime.now()


def sales_report(cr, uid, ids, data, context):
    return { #sip
        'parameters': {
            'order_id': data['order_id'],
            'order_date': data['order_date'],
            'print_datetime': str(datetime(x.year, x.month, x.day, x.hour, x.minute, x.second).strftime("%d-%m-%Y %H:%M:%S")),
        },
    }


jasper_reports.report_jasper('report.sales.order.pdf',
                             'sale.order',
                             parser=sales_report)
jasper_reports.report_jasper('report.quotation.pdf',
                             'sale.order',
                             parser=sales_report)
jasper_reports.report_jasper('report.quotation.other.pdf',
                             'sale.order',
                             parser=sales_report)


def boq_report(cr, uid, ids, data, context):
    return {
        'parameters': {
            'title': 'BoQ (Bill of Quantity)',
            'order_id': data['order_id'],
            'SUBREPORT_DIR': data['subdir_report'],
Exemplo n.º 28
0
# -*- encoding: utf-8 -*-
from openerp.addons import jasper_reports


def print_voucher_parser(cr, uid, ids, data, context):
    return {
        'ids': data['parameters']['ids'],
    }


# KV Voucher && DV Voucher
jasper_reports.report_jasper(
    'report.invoice.voucher',  # report_name in account_data.xml
    'account.move',  # Model View name
    parser=print_voucher_parser
)


# PV Voucher && RC Voucher
jasper_reports.report_jasper(
    'report.payment.voucher',  # report_name in account_data.xml
    'account.move',  # Model View name
    parser=print_voucher_parser
)


# RV Voucher
jasper_reports.report_jasper(
    'report.bank.receipt.voucher',  # report_name in account_data.xml
    'account.move',  # Model View name
    parser=print_voucher_parser
# -*- coding: utf-8 -*-
from openerp.addons import jasper_reports


def report_sample_partner_orm_parser(cr, uid, ids, data, context):
    # For ORM, just pass ids
    return {
        'ids': data['parameters']['ids'],
        'parameters': {
            'xxx': data['parameters']['ids'],
        }
    }


jasper_reports.report_jasper(
    'report.report_sample_partner_orm',  # report_name in report_data.xml
    'report.sample.partner.orm',  # Model View name
    parser=report_sample_partner_orm_parser,
)
#    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 <http://www.gnu.org/licenses/>.
#
##############################################################################
from openerp import pooler, _
from openerp.addons import jasper_reports
from datetime import datetime

def parser( cr, uid, ids, data, context ):
    parameters = {}
    ids = ids
    name = 'report.stock_picking_out_std'
    model = 'stock.picking'
    data_source = 'model'
    picking = pooler.get_pool(cr.dbname).get('stock.picking').browse(cr,uid,ids)
    language = picking and picking[0].partner_id.lang or False
    context['lang'] = language

    return {
        'ids': ids,
        'name': name,
        'model': model,
        'records': [],
        'data_source': data_source,
        'parameters': parameters,
    }
jasper_reports.report_jasper( 'report.stock_picking_out_std', 'stock.picking', parser )
from openerp.tools.translate import _


def parser(cr, uid, ids, data, context):
    name = 'report.purchase_order'
    model = 'purchase.order'
    data_source = 'model'
    parameters = {}
    if 'form' in data:
        language = data['form']['language']
        delivery_address = data['form']['delivery_address']
        signed = data['form']['signed']
        parameters = {}
        parameters['delivery_address'] = delivery_address
        parameters['signed'] = signed
        parameters['lang'] = language
        if 'lang' in context:
            context['lang'] = language

    return {
        'ids': ids,
        'name': name,
        'model': model,
        'records': [],
        'data_source': data_source,
        'parameters': parameters,
    }


jasper_reports.report_jasper('report.purchase_order', 'purchase.order', parser)
# -*- coding: utf-8 -*-
from openerp.addons import jasper_reports


def print_payment_cheque_parser(cr, uid, ids, data, context):
    return {
        'ids': data['parameters']['ids'],
    }


jasper_reports.report_jasper(
    'report.supplier.payment.bay.cheque',
    'account.voucher',  # Model View name
    parser=print_payment_cheque_parser
)

jasper_reports.report_jasper(
    'report.supplier.payment.bbl.cheque',
    'account.voucher',  # Model View name
    parser=print_payment_cheque_parser
)

jasper_reports.report_jasper(
    'report.supplier.payment.ktb.cheque',
    'account.voucher',  # Model View name
    parser=print_payment_cheque_parser
)

jasper_reports.report_jasper(
    'report.supplier.payment.scb.cheque',
    'account.voucher',  # Model View name
#    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 <http://www.gnu.org/licenses/>.
#
##############################################################################
from openerp.addons import jasper_reports
from openerp import pooler
from datetime import datetime
from openerp.tools.translate import _

def parser( cr, uid, ids, data, context ):
    language = data['form']['language']
    parameters = {}
    ids = ids
    name = 'report.product_datasheet'
    model = 'product.product'
    data_source = 'model'
    parameters['lang'] = language
    context['lang'] = language
    return { 
        'ids': ids, 
        'name': name, 
        'model': model, 
        'records': [], 
        'data_source': data_source,
        'parameters': parameters,
    }
jasper_reports.report_jasper( 'report.product_datasheet', 'product.product', parser )
from openerp.addons import jasper_reports
from openerp import pooler
from datetime import datetime
from openerp.tools.translate import _


def parser( cr, uid, ids, data, context ):
    name = 'report.purchase_order'
    model = 'purchase.order'
    data_source = 'model'
    parameters = {}
    if 'form' in data:
        language = data['form']['language']
        delivery_address = data['form']['delivery_address']
        signed = data['form']['signed']
        parameters = {}

        parameters['lang'] = language

        parameters['delivery_address'] = delivery_address
        parameters['signed'] = signed
    return {
        'ids': ids,
        'name': name,
        'model': model,
        'records': [],
        'data_source': data_source,
        'parameters': parameters,
    }
jasper_reports.report_jasper('report.purchase_order', 'purchase.order', parser)
Exemplo n.º 35
0
    def send_mail(self, cr, uid, ids, context=None):

        if context is None:
            context = {}
        attachments = []

        form_obj = self.pool.get(
            'mail.compose.message.product.datasheet').browse(cr,
                                                             uid,
                                                             ids[0],
                                                             context=context)

        date = time.strftime('%Y-%m-%d %H:%M:%S')
        sent_date = _('On %(date)s, ') % {'date': date}
        sender = _('%(sender_name)s wrote:') % {
            'sender_name': tools.ustr(form_obj.email_from or _('You'))
        }
        quoted_body = '> %s' % tools.ustr(
            form_obj.body_text.replace('\n', "\n> ") or '')
        body = '\n'.join(["\n", (sent_date + sender), quoted_body])
        if form_obj.user_signature == 1:
            body += "\n" + (self.pool.get('res.users').browse(
                cr, uid, uid).signature or '')

            subject = "%s" % (form_obj.subject)
        msg_vals = {
            'subject': form_obj.subject,
            'date': time.strftime('%Y-%m-%d %H:%M:%S'),
            'user_id': uid,
            'model': 'product.product',
            'res_id': context['active_id'],
            'body_text': body,
            'body_html': False,
            'email_from': form_obj.email_from,
            'email_to': form_obj.email_to,
            'email_cc': '',
            'email_bcc': '',
            'subtype': 'plain',
            #'headers': headers, # serialize the dict on the fly
            'state': 'outgoing',
            'auto_delete': True
        }
        email_msg_id = self.pool.get('mail.message').create(
            cr, uid, msg_vals, context)

        if form_obj.report_template:
            jasper_class = report_jasper('report.product.datasheet.jasper',
                                         'product.product',
                                         parser=None)
            (result,
             format) = jasper_class.create(cr,
                                           uid,
                                           context['active_ids'], {
                                               'model': 'product.product',
                                               'id': context['active_ids'][0],
                                               'ids': context['active_ids']
                                           },
                                           context=context)

            attachment_data = {
                'name': 'ficha_tecnica_' + time.strftime('%Y-%m-%d') + '.pdf',
                'datas_fname':
                'ficha_tecnica_' + time.strftime('%Y-%m-%d') + '.pdf',
                'datas': result and result.encode('base64'),
                'res_model': 'mail.message',
                'res_id': email_msg_id,
            }

            attachments.append(
                self.pool.get('ir.attachment').create(cr, uid, attachment_data,
                                                      context))
            if attachments:
                self.pool.get('mail.message').write(
                    cr,
                    uid,
                    email_msg_id, {'attachment_ids': [(6, 0, attachments)]},
                    context=context)

        ok = self.pool.get('mail.message').send(cr,
                                                uid, [email_msg_id],
                                                context=context)

        if ok == True:
            product_obj = self.pool.get('product.product').browse(
                cr, uid, context['active_ids'][0])
            if form_obj.contact_ids:
                for cont in form_obj.contact_ids:
                    if cont.partner_id:
                        partner_id = cont.partner_id.id
                    else:
                        partner_id = False

                    self.pool.get('product.sheet.shipments').create(
                        cr, uid, {
                            'partner_id': partner_id,
                            'contact_id': cont.id,
                            'date': time.strftime("%Y-%m-%d"),
                            'product_id': product_obj.id,
                            'revision': product_obj.last_revision
                        })

        return {'type': 'ir.actions.act_window_close'}
# -*- encoding: utf-8 -*-
from openerp.addons import jasper_reports


def print_payment_export_parser(cr, uid, ids, data, context):
    return {
        'ids': data['parameters']['ids'],
    }


jasper_reports.report_jasper(
    'report.payment.export.form',
    'payment.export',  # Model View name
    parser=print_payment_export_parser)

jasper_reports.report_jasper(
    'report.cheque.form',
    'payment.export',  # Model View name
    parser=print_payment_export_parser)
Exemplo n.º 37
0
##############################################################################
#
# 	OpenERP, Open Source Management Solution
# 	Copyright (C) 2011 Domsense s.r.l. (<http://www.domsense.com>).
#
# 	This program is free software: you can redistribute it and/or modify
# 	it under the terms of the GNU Affero General Public License 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 <http://www.gnu.org/licenses/>.
#
##############################################################################
from openerp.addons import jasper_reports
from openerp.osv import osv, fields
import openerp.pooler
import datetime


def jasper_declaration_trim_cnss_parser(cr, uid, ids, data, context):
    return {"parameters": {"id_cnss": ids[0]}}


jasper_reports.report_jasper("report.hr_cnss_statement", "hr.cnss", parser=jasper_declaration_trim_cnss_parser)