def __init__(self,
name,
table,
rml=False,
parser=False,
header=True,
store=False):
super(account_invoice_line_xls_kaiser_compliance,
self).__init__(name, table, rml, parser, header, store)
# Cell Styles
_xs = self.xls_styles
# header
rh_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rh_cell_style = xlwt.easyxf(rh_cell_format)
self.rh_cell_style_center = xlwt.easyxf(rh_cell_format + _xs['center'])
self.rh_cell_style_right = xlwt.easyxf(rh_cell_format + _xs['right'])
# lines
aml_cell_format = _xs['borders_all']
self.aml_cell_style = xlwt.easyxf(aml_cell_format)
self.aml_cell_style_center = xlwt.easyxf(aml_cell_format +
_xs['center'])
self.aml_cell_style_date = xlwt.easyxf(
aml_cell_format + _xs['left'],
num_format_str=report_xls.date_format)
self.aml_cell_style_decimal = xlwt.easyxf(
aml_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
# totals
rt_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rt_cell_style = xlwt.easyxf(rt_cell_format)
self.rt_cell_style_right = xlwt.easyxf(rt_cell_format + _xs['right'])
self.rt_cell_style_decimal = xlwt.easyxf(
rt_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
self.col_specs_template_kaiser_compliance = {
'id': {
'header': [1, 10, 'text', _render("_('ID')")],
'lines': [1, 0, 'number',
_render("line.invoice_id.id ")],
'totals': [1, 0, 'text', None]
},
'date_service': {
'header': [1, 10, 'text',
_render("_('Date Service')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and str(line.invoice_id.event_id.event_start_date) or '' "
)
],
'totals': [1, 0, 'text', None]
},
'language': {
'header': [1, 13, 'text',
_render("_('Language')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.language_id and line.invoice_id.event_id.language_id.name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'interpretation_type': {
'header': [1, 20, 'text',
_render("_('Interpretation Type')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.appointment_type_id and line.invoice_id.event_id.appointment_type_id.name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'interpreter': {
'header': [1, 20, 'text',
_render("_('Interpreter Name')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.task_line_id and line.task_line_id.interpreter_id and line.task_line_id.interpreter_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'interpretation_city': {
'header': [1, 13, 'text',
_render("_('Job Loc. City')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.location_id and line.invoice_id.event_id.location_id.city or '' "
))
],
'totals': [1, 0, 'text', None]
},
'patient_name': {
'header': [1, 15, 'text',
_render("_('Patient Name')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.patient_id and line.invoice_id.event_id.patient_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'requester': {
'header': [1, 20, 'text',
_render("_('Requester')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.ordering_partner_id and line.invoice_id.event_id.ordering_partner_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'ordering_contact': {
'header': [1, 20, 'text',
_render("_('Ordering Contact')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.ordering_contact_id and line.invoice_id.event_id.ordering_contact_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'billing_customer': {
'header': [1, 20, 'text',
_render("_('Billing Customer')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.partner_id and line.invoice_id.event_id.partner_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'billing_customer_ref': {
'header':
[1, 13, 'text',
_render("_('Billing Customer Ref')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.partner_id and line.invoice_id.event_id.partner_id.ref or '' "
))
],
'totals': [1, 0, 'text', None]
},
'billing_contact': {
'header': [1, 20, 'text',
_render("_('Billing Contact')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.contact_id and line.invoice_id.event_id.contact_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'billing_contact_ref': {
'header': [1, 13, 'text',
_render("_('Billing Contact Ref')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.contact_id and line.invoice_id.event_id.contact_id.ref or ''"
))
],
'totals': [1, 0, 'text', None]
},
# 'address': {
# 'header': [1, 30, 'text', _render("_('Address')")],
# 'lines': [1, 0, 'text', self.parse_address('',_render("line.invoice_id.partner_id.street or '' "),_render("line.invoice_id.partner_id.street2 or '' "))],
# 'totals': [1, 0, 'text', None]},
'address': {
'header': [1, 30, 'text',
_render("_('Address')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render("line.invoice_id.partner_id.street or '' "))
],
'totals': [1, 0, 'text', None]
},
'city': {
'header': [1, 13, 'text', _render("_('City')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render("line.invoice_id.partner_id.city or '' "))
],
'totals': [1, 0, 'text', None]
},
'zip': {
'header': [1, 10, 'text', _render("_('Zip')")],
'lines': [
1, 0, 'text',
_render("line.invoice_id.partner_id.zip or '' ")
],
'totals': [1, 0, 'text', None]
},
'location': {
'header':
[1, 25, 'text',
_render("_('Location Services Provided')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.location_id and line.invoice_id.event_id.location_id.name or '' "
))
],
# _render("line.invoice_id.event_id and line.invoice_id.event_id.location_id and line.invoice_id.event_id.location_id.street or '' "),\
# _render("line.invoice_id.event_id and line.invoice_id.event_id.location_id and line.invoice_id.event_id.location_id.street2 or '' "))],
'totals': [1, 0, 'text', None]
},
'street': {
'header': [1, 25, 'text',
_render("_('Street')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.location_id and line.invoice_id.event_id.location_id.street or '' "
))
],
'totals': [1, 0, 'text', None]
},
'street2': {
'header': [1, 25, 'text',
_render("_('Street2')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.location_id and line.invoice_id.event_id.location_id.street2 or '' "
))
],
'totals': [1, 0, 'text', None]
},
'start_time': {
'header': [1, 10, 'text',
_render("_('Start Time')")],
'lines': [
1, 0, 'text',
_render(
"line.task_line_id and str(line.task_line_id.event_start_hr or '') + ':' + str(line.task_line_id.event_start_min or '') + ' ' + \
str(line.task_line_id.am_pm or '') or '' #"
)
],
'totals': [1, 0, 'text', None]
},
'end_time': {
'header': [1, 10, 'text',
_render("_('End Time')")],
'lines': [
1, 0, 'text',
_render(
"line.task_line_id and str(line.task_line_id.event_end_hr or '') + ':' + str(line.task_line_id.event_end_min or '') + ' ' + \
str(line.task_line_id.am_pm2 or '') or '' #"
)
],
'totals': [1, 0, 'text', None]
},
'duration': {
'header': [1, 10, 'text',
_render("_('Duration')")],
'lines': [
1, 0, 'text',
_render(
"line.task_line_id and line.task_line_id.time_spent and str(round(line.task_line_id.time_spent,2) or '')or ''"
)
],
'totals': [1, 0, 'text', None]
},
'rate': {
'header': [1, 10, 'text',
_render("_('AR Unit(Hourly)')")],
'lines': [
1, 0, 'number',
_render(
"line.price_unit and round(line.price_unit,2) or 0.0 ")
],
'totals': [1, 0, 'text', None]
},
'miles_driven': {
'header': [1, 10, 'text',
_render("_('Miles Driven')")],
'lines': [
1, 0, 'number',
_render(
"line.miles_driven and round(line.miles_driven,2)or 0.0 "
)
],
'totals': [1, 0, 'text', None]
},
'total_miles_rate': {
'header': [1, 13, 'text',
_render("_('Total Miles Cost')")],
'lines': [
1, 0, 'number',
_render(
"round(line.mileage * line.mileage_rate,2) or 0.0 ")
],
'totals': [1, 0, 'text', None]
},
#datetime.strptime(datetime.strptime(dt_from,"%Y-%m-%d").strftime('%Y-%m-%d %H:%M:%S'), "%Y-%m-%d %H:%M:%S")
'invoice_number': {
'header': [1, 13, 'text',
_render("_('Invoice Number')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.invoice_old_number and str(line.invoice_id.invoice_old_number) or str(line.invoice_id.number) or ''"
))
],
'totals': [1, 0, 'text', None]
},
'office': {
'header': [1, 15, 'text',
_render("_('Office')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'interpreter_gender': {
'header': [1, 10, 'text',
_render("_('Intp Gender')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.interpreter_id and \
str(line.invoice_id.event_id.interpreter_id.gender) or ''"
)
],
'totals': [1, 0, 'text', None]
},
'po_no': {
'header': [1, 13, 'text', _render("_('PO#')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.po_no or ''"
)
],
'totals': [1, 0, 'text', None]
},
'medical_number': {
'header': [1, 13, 'text', _render("_('MRN#')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.medical_no or ''"
))
],
'totals': [1, 0, 'text', None]
},
'contract_no': {
'header': [1, 13, 'text',
_render("_('Contract#')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.ordering_partner_id and line.invoice_id.ordering_partner_id.contract_no or ''"
))
],
'totals': [1, 0, 'text', None]
},
'date_invoice': {
'header': [1, 10, 'text',
_render("_('Invoice Date')")],
'lines': [
1, 0, 'text',
_render("str(line.invoice_id.date_invoice or '') or ''")
],
'totals': [1, 0, 'text', None]
},
'amount': {
'header': [
1, 10, 'text',
_render("_('Total Of Services')"), None,
self.rh_cell_style_right
],
'lines': [
1, 0, 'number',
_render(
"line.price_subtotal and round(line.price_subtotal,2) or 0.0 "
)
],
'totals': [
1, 0, 'number', None,
_render("amount_total_formula"), self.rt_cell_style_decimal
]
},
'comment': {
'header': [1, 40, 'text',
_render("_('Comment')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render("line.invoice_id.comment or ''"))
],
'totals': [1, 0, 'text', None]
},
'event_purpose': {
'header': [1, 13, 'text',
_render("_('Event Purpose')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and str(line.invoice_id.event_id.event_purpose or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'event_number': {
'header': [1, 13, 'text',
_render("_('Event Number')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and str(line.invoice_id.event_id.name or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'event_outcome': {
'header': [1, 20, 'text',
_render("_('Job Status')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.task_line_id and line.task_line_id.event_out_come_id and line.task_line_id.event_out_come_id.name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'cancel_reason': {
'header': [1, 20, 'text',
_render("_('Cancellation Reason')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.cancel_reason_id and line.invoice_id.event_id.cancel_reason_id.name or ''"
))
],
'totals': [1, 0, 'text', None]
},
'glcode': {
'header': [
1, 15, 'text',
_render("_('GL String/NCOA code/Cost Center#')")
],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.cust_gpuid or '' "
))
],
'totals': [1, 0, 'text', None]
},
'nuid': {
'header': [1, 15, 'text',
_render("_('FDA NUID#')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.cust_csid or '' "
))
],
'totals': [1, 0, 'text', None]
},
'requested_start_time': {
'header':
[1, 10, 'text',
_render("_('Requested Start Time')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and str(line.invoice_id.event_id.event_start_hr or '') + ':' + str(line.invoice_id.event_id.event_start_min or '') + ' ' + \
str(line.invoice_id.event_id.am_pm or '') or '' #"
)
],
'totals': [1, 0, 'text', None]
},
'requested_end_time': {
'header': [1, 10, 'text',
_render("_('Requested End Time')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and str(line.invoice_id.event_id.event_end_hr or '') + ':' + str(line.invoice_id.event_id.event_end_min or '') + ' ' + \
str(line.invoice_id.event_id.am_pm2 or '') or '' #"
)
],
'totals': [1, 0, 'text', None]
},
'billed_duration': {
'header': [1, 10, 'text',
_render("_('Billed Duration')")],
'lines': [
1, 0, 'number',
_render("line.quantity and round(line.quantity,2) or 0.0 ")
],
'totals': [1, 0, 'text', None]
},
'create_date': {
'header': [1, 10, 'text',
_render("_('Intake date')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and str(line.invoice_id.event_id.create_date or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'less_than_24_notice': {
'header': [1, 10, 'text',
_render("_('< 24 notice')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and str(line.invoice_id.event_id.intake_notice or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'total_interpretation_cost': {
'header': [1, 13, 'text',
_render("_('AR Total Amount')")],
'lines': [
1, 0, 'number',
_render(
"round(line.quantity * line.price_unit,2) or 0.0 ")
],
'totals': [1, 0, 'text', None]
},
'multi_type': {
'header': [1, 13, 'text',
_render("_('Bundled Appointment')")],
'lines': [
1, 0, 'text',
_render(
"'Two interpreters assigned for event' if line.invoice_id.event_id and line.invoice_id.event_id.multi_type and line.invoice_id.event_id.multi_type == '2' else '' "
)
],
'totals': [1, 0, 'text', None]
},
'comments': {
'header': [1, 13, 'text',
_render("_('Comments')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'payment_received': {
'header': [1, 10, 'text',
_render("_('Payment Received')")],
'lines': [
1, 0, 'number',
_render(
"round(line.invoice_id.amount_total - line.invoice_id.residual,2) or 0.0 "
)
],
'totals': [1, 0, 'number', None, None]
},
'status': {
'header': [1, 15, 'text',
_render("_('Status')")],
'lines':
[1, 0, 'text',
_render("line.invoice_id.state or '' ")],
'totals': [1, 0, 'text', None]
},
'department': {
'header': [1, 15, 'text',
_render("_('Department')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.department or '' "
))
],
'totals': [1, 0, 'text', None]
},
'dr_name': {
'header': [1, 15, 'text',
_render("_('Doctor Name')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.dr_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'patient_medical_number': {
'header': [1, 13, 'text',
_render("_('Patient Medical#')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.patient_id and line.invoice_id.event_id.patient_id.ssnid or ''"
))
],
'totals': [1, 0, 'text', None]
},
}
def __init__(self,
name,
table,
rml=False,
parser=False,
header=True,
store=False):
super(account_invoice_xls_invoice_profitability,
self).__init__(name, table, rml, parser, header, store)
# Cell Styles
_xs = self.xls_styles
# header
rh_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rh_cell_style = xlwt.easyxf(rh_cell_format)
self.rh_cell_style_center = xlwt.easyxf(rh_cell_format + _xs['center'])
self.rh_cell_style_right = xlwt.easyxf(rh_cell_format + _xs['right'])
# lines
aml_cell_format = _xs['borders_all']
self.aml_cell_style = xlwt.easyxf(aml_cell_format)
self.aml_cell_style_center = xlwt.easyxf(aml_cell_format +
_xs['center'])
self.aml_cell_style_date = xlwt.easyxf(
aml_cell_format + _xs['left'],
num_format_str=report_xls.date_format)
self.aml_cell_style_decimal = xlwt.easyxf(
aml_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
# totals
rt_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rt_cell_style = xlwt.easyxf(rt_cell_format)
self.rt_cell_style_right = xlwt.easyxf(rt_cell_format + _xs['right'])
self.rt_cell_style_decimal = xlwt.easyxf(
rt_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
self.col_specs_template_invoice_profitability = {
'id': {
'header': [1, 10, 'text', _render("_('ID')")],
'lines': [1, 0, 'number',
_render("each_line.invoice_id.id ")],
'totals': [1, 0, 'text', None]
},
'date_service': {
'header': [1, 10, 'text',
_render("_('Date Service')")],
'lines': [
1, 0, 'text',
_render(
"each_line.invoice_id.event_id and str(each_line.invoice_id.event_id.event_start_date) or '' "
)
],
'totals': [1, 0, 'text', None]
},
'language': {
'header': [1, 13, 'text',
_render("_('Language')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.language_id and each_line.invoice_id.event_id.language_id.name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'interpretation_type': {
'header': [1, 20, 'text',
_render("_('Interpretation Type')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.appointment_type_id and each_line.invoice_id.event_id.appointment_type_id.name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'interpreter': {
'header': [1, 20, 'text',
_render("_('Interpreter Name')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.task_line_id and each_line.task_line_id.interpreter_id and each_line.task_line_id.interpreter_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'interpretation_city': {
'header': [1, 13, 'text',
_render("_('Interpretation City')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.location_id and each_line.invoice_id.event_id.location_id.city or '' "
))
],
'totals': [1, 0, 'text', None]
},
'interpretation_state': {
'header':
[1, 13, 'text',
_render("_('Interpretation state')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.location_id and each_line.invoice_id.event_id.location_id.state_id.name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'patient_name': {
'header': [1, 15, 'text',
_render("_('Patient Name')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.patient_id and each_line.invoice_id.event_id.patient_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'requester': {
'header': [1, 20, 'text',
_render("_('Requester')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.ordering_partner_id and each_line.invoice_id.event_id.ordering_partner_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'ordering_contact': {
'header': [1, 20, 'text',
_render("_('Ordering Contact')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.ordering_contact_id and each_line.invoice_id.event_id.ordering_contact_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'ordering_contact_phone': {
'header': [1, 20, 'text',
_render("_('Phone No')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.ordering_contact_id and each_line.invoice_id.event_id.ordering_contact_id.phone or each_line.invoice_id.event_id.ordering_contact_id.phone2 or '' "
))
],
'totals': [1, 0, 'text', None]
},
'billing_customer': {
'header': [1, 20, 'text',
_render("_('Billing Customer')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.partner_id and each_line.invoice_id.event_id.partner_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'billing_customer_ref': {
'header':
[1, 13, 'text',
_render("_('Billing Customer Ref')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.partner_id and each_line.invoice_id.event_id.partner_id.ref or '' "
))
],
'totals': [1, 0, 'text', None]
},
'billing_contact': {
'header': [1, 20, 'text',
_render("_('Billing Contact')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.contact_id and each_line.invoice_id.event_id.contact_id.complete_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'billing_contact_ref': {
'header': [1, 13, 'text',
_render("_('Billing Contact Ref')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.contact_id and each_line.invoice_id.event_id.contact_id.ref or ''"
))
],
'totals': [1, 0, 'text', None]
},
# 'address': {
# 'header': [1, 30, 'text', _render("_('Address')")],
# 'lines': [1, 0, 'text', self.parse_address('',_render("line.invoice_id.partner_id.street or '' "),_render("line.invoice_id.partner_id.street2 or '' "))],
# 'totals': [1, 0, 'text', None]},
'address': {
'header': [1, 30, 'text',
_render("_('Address')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.partner_id.street or '' "))
],
'totals': [1, 0, 'text', None]
},
'city': {
'header': [1, 13, 'text', _render("_('City')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render("each_line.invoice_id.partner_id.city or '' "))
],
'totals': [1, 0, 'text', None]
},
'zip': {
'header': [1, 10, 'text', _render("_('Zip')")],
'lines': [
1, 0, 'text',
_render("each_line.invoice_id.partner_id.zip or '' ")
],
'totals': [1, 0, 'text', None]
},
'location': {
'header':
[1, 25, 'text',
_render("_('Location Services Provided')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.location_id and each_line.invoice_id.event_id.location_id.name or '' "
))
],
# _render("line.invoice_id.event_id and line.invoice_id.event_id.location_id and line.invoice_id.event_id.location_id.street or '' "),\
# _render("line.invoice_id.event_id and line.invoice_id.event_id.location_id and line.invoice_id.event_id.location_id.street2 or '' "))],
'totals': [1, 0, 'text', None]
},
'street': {
'header': [1, 25, 'text',
_render("_('Street')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.location_id and each_line.invoice_id.event_id.location_id.street or '' "
))
],
'totals': [1, 0, 'text', None]
},
'street2': {
'header': [1, 25, 'text',
_render("_('Street2')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.location_id and each_line.invoice_id.event_id.location_id.street2 or '' "
))
],
'totals': [1, 0, 'text', None]
},
'start_time': {
'header': [1, 10, 'text',
_render("_('Start Time')")],
'lines': [
1, 0, 'text',
_render(
"each_line.task_line_id and str(each_line.task_line_id.event_start_hr or '') + ':' + str(each_line.task_line_id.event_start_min or '') + ' ' + \
str(each_line.task_line_id.am_pm or '') or '' #"
)
],
'totals': [1, 0, 'text', None]
},
'end_time': {
'header': [1, 10, 'text',
_render("_('End Time')")],
'lines': [
1, 0, 'text',
_render(
"each_line.task_line_id and str(each_line.task_line_id.event_end_hr or '') + ':' + str(each_line.task_line_id.event_end_min or '') + ' ' + \
str(each_line.task_line_id.am_pm2 or '') or '' #"
)
],
'totals': [1, 0, 'text', None]
},
'duration': {
'header': [1, 10, 'text',
_render("_('Duration')")],
'lines': [
1, 0, 'text',
_render(
"each_line.task_line_id and each_line.task_line_id.time_spent and str(round(each_line.task_line_id.time_spent,2) or '')or ''"
)
],
'totals': [1, 0, 'text', None]
},
'rate': {
'header': [1, 10, 'text',
_render("_('Interpreter Rate')")],
# 'lines': [1, 0, 'number', _render("line.price_unit and round(line.price_unit,2) or 0.0 ")],
'lines': [
1, 0, 'number',
_render(
"rec_supplier_inv and round(rec_supplier_inv) or 0 ")
],
'totals': [1, 0, 'text', None]
},
'miles_driven': {
'header': [1, 10, 'text',
_render("_('Miles Driven')")],
'lines': [
1, 0, 'number',
_render(
"each_line.miles_driven and round(each_line.miles_driven,2)or 0.0 "
)
],
'totals': [1, 0, 'text', None]
},
'total_miles_rate': {
'header': [1, 13, 'text',
_render("_('Total Miles Rate')")],
#'lines': [1, 0, 'number', _render("round(each_line.mileage * each_line.mileage_rate,2) or 0.0 ")],
'lines': [
1, 0, 'number',
_render(
"rec_supplier_mileage * rec_supplier_mileage_rate or 0.0 "
)
],
'totals': [1, 0, 'text', None]
},
# datetime.strptime(datetime.strptime(dt_from,"%Y-%m-%d").strftime('%Y-%m-%d %H:%M:%S'), "%Y-%m-%d %H:%M:%S")
'invoice_number': {
'header': [1, 13, 'text',
_render("_('Invoice Number')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render("str(each_line.invoice_id.number) or ''"))
],
'totals': [1, 0, 'text', None]
},
'office': {
'header': [1, 15, 'text',
_render("_('Office')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'interpreter_gender': {
'header': [1, 10, 'text',
_render("_('Intp Gender')")],
'lines': [
1, 0, 'text',
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.interpreter_id and \
str(each_line.invoice_id.event_id.interpreter_id.gender) or ''"
)
],
'totals': [1, 0, 'text', None]
},
'po_no': {
'header': [1, 13, 'text', _render("_('PO#')")],
'lines': [
1, 0, 'text',
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.po_no or ''"
)
],
'totals': [1, 0, 'text', None]
},
'medical_number': {
'header': [1, 13, 'text',
_render("_('Medical#')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.medical_no or ''"
))
],
'totals': [1, 0, 'text', None]
},
'contract_no': {
'header': [1, 13, 'text',
_render("_('Contract#')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.ordering_partner_id and each_line.invoice_id.ordering_partner_id.contract_no or ''"
))
],
'totals': [1, 0, 'text', None]
},
'date_invoice': {
'header': [1, 10, 'text',
_render("_('Invoice Date')")],
'lines': [
1, 0, 'text',
_render(
"str(each_line.invoice_id.date_invoice or '') or ''")
],
'totals': [1, 0, 'text', None]
},
'amount': {
'header': [
1, 10, 'text',
_render("_('Amount')"), None, self.rh_cell_style_right
],
'lines': [
1, 0, 'number',
_render(
"each_line.price_subtotal and round(each_line.price_subtotal,2) or 0.0 "
)
],
'totals': [
1, 0, 'number', None,
_render("amount_total_formula"), self.rt_cell_style_decimal
]
},
'comment': {
'header': [1, 40, 'text',
_render("_('Comment')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render("each_line.invoice_id.comment or ''"))
],
'totals': [1, 0, 'text', None]
},
'event_purpose': {
'header': [1, 13, 'text',
_render("_('Event Purpose')")],
'lines': [
1, 0, 'text',
_render(
"each_line.invoice_id.event_id and str(each_line.invoice_id.event_id.event_purpose or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'cost_center': {
'header': [1, 40, 'text',
_render("_('Cost Center')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.cost_center or ''"
))
],
'totals': [1, 0, 'text', None]
},
'status': {
'header': [1, 15, 'text',
_render("_('Status')")],
'lines':
[1, 0, 'text',
_render("each_line.invoice_id.state or '' ")],
'totals': [1, 0, 'text', None]
},
'department': {
'header': [1, 15, 'text',
_render("_('Department')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.department or '' "
))
],
'totals': [1, 0, 'text', None]
},
'dr_name': {
'header': [1, 15, 'text',
_render("_('Doctor Name')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.dr_name or '' "
))
],
'totals': [1, 0, 'text', None]
},
'patient_medical_number': {
'header': [1, 13, 'text',
_render("_('Patient Medical#')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.patient_id and each_line.invoice_id.event_id.patient_id.ssnid or ''"
))
],
'totals': [1, 0, 'text', None]
},
'amount_total': {
'header': [1, 16, 'text',
_render("_('Total Vendor Pay')")],
'lines': [
1, 0, 'number',
self.parse_unicode(_render("rec_supplier_total or 0.0 "))
],
'totals': [1, 0, 'text', None]
},
'sales_representative_id': {
'header': [1, 13, 'text',
_render("_('Sales Rep')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.sales_representative_id and each_line.invoice_id.event_id.sales_representative_id.name or ''"
))
],
'totals': [1, 0, 'text', None]
},
'sales_representative_id_for_billing_customer': {
'header': [1, 13, 'text',
_render("_('Sales Rep By Cust')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.partner_id and each_line.invoice_id.event_id.partner_id.sales_representative_id and each_line.invoice_id.event_id.partner_id.sales_representative_id.name or ''"
))
],
'totals': [1, 0, 'text', None]
},
'requester_create_date': {
'header':
[1, 20, 'text',
_render("_('Requester Create Date')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"datetime.strptime(each_line.invoice_id.event_id.ordering_partner_id.create_date,'%Y-%m-%d %H:%M:%S').strftime('%m/%d/%Y') if each_line.invoice_id.event_id and each_line.invoice_id.event_id.ordering_partner_id and each_line.invoice_id.event_id.ordering_partner_id.create_date !='False' else ''"
))
],
'totals': [1, 0, 'text', None]
},
'metazone': {
'header': [1, 20, 'text',
_render("_('Metazone')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.zone_id and each_line.invoice_id.event_id.zone_id.name or ''"
))
],
'totals': [1, 0, 'text', None]
},
'scheduler': {
'header': [1, 20, 'text',
_render("_('Scheduler')")],
'lines': [
1, 0, 'text',
self.parse_unicode(
_render(
"each_line.invoice_id.event_id and each_line.invoice_id.event_id.scheduler_id and each_line.invoice_id.event_id.scheduler_id.name or ''"
))
],
'totals': [1, 0, 'text', None]
},
}
def __init__(self,
name,
table,
rml=False,
parser=False,
header=True,
store=False):
super(purchase_order_xls, self).__init__(name, table, rml, parser,
header, store)
# Cell Styles
_xs = self.xls_styles
# header
rh_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rh_cell_style = xlwt.easyxf(rh_cell_format)
self.rh_cell_style_center = xlwt.easyxf(rh_cell_format + _xs['center'])
self.rh_cell_style_right = xlwt.easyxf(rh_cell_format + _xs['right'])
# lines
aml_cell_format = _xs['borders_all']
self.aml_cell_style = xlwt.easyxf(aml_cell_format)
self.aml_cell_style_center = xlwt.easyxf(aml_cell_format +
_xs['center'])
self.aml_cell_style_date = xlwt.easyxf(
aml_cell_format + _xs['left'],
num_format_str=report_xls.date_format)
self.aml_cell_style_decimal = xlwt.easyxf(
aml_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
# totals
rt_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rt_cell_style = xlwt.easyxf(rt_cell_format)
self.rt_cell_style_right = xlwt.easyxf(rt_cell_format + _xs['right'])
self.rt_cell_style_decimal = xlwt.easyxf(
rt_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
self.col_specs_template = {
'name': {
'header': [1, 12, 'text',
_render("_('Item No.')")],
'lines':
[1, 0, 'text',
_render("line.product_id.default_code or ''")]
},
'desc': {
'header': [1, 42, 'text',
_render("_('Description')")],
'lines':
[1, 0, 'text',
_render("line.product_id.name_template or ''")]
},
'unit': {
'header': [1, 20, 'text',
_render("_('Unit of measure')")],
'lines': [1, 0, 'text', _render("'PCS'")]
},
'product_qty': {
'header': [
1, 10, 'text',
_render("_('Quantity')"), None, self.rh_cell_style_right
],
'lines': [1, 0, 'number',
_render("line.product_qty")]
},
}
def __init__(self, name, table, rml=False, parser=False, header=True, store=False):
super(account_invoice_xls_kaiser, self).__init__(name, table, rml, parser, header, store)
# Cell Styles
_xs = self.xls_styles
# header
rh_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rh_cell_style = xlwt.easyxf(rh_cell_format)
self.rh_cell_style_center = xlwt.easyxf(rh_cell_format + _xs['center'])
self.rh_cell_style_right = xlwt.easyxf(rh_cell_format + _xs['right'])
# lines
aml_cell_format = _xs['borders_all']
self.aml_cell_style = xlwt.easyxf(aml_cell_format)
self.aml_cell_style_center = xlwt.easyxf(aml_cell_format + _xs['center'])
self.aml_cell_style_date = xlwt.easyxf(aml_cell_format + _xs['left'], num_format_str=report_xls.date_format)
self.aml_cell_style_decimal = xlwt.easyxf(aml_cell_format + _xs['right'], num_format_str=report_xls.decimal_format)
# totals
rt_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rt_cell_style = xlwt.easyxf(rt_cell_format)
self.rt_cell_style_right = xlwt.easyxf(rt_cell_format + _xs['right'])
self.rt_cell_style_decimal = xlwt.easyxf(rt_cell_format + _xs['right'], num_format_str=report_xls.decimal_format)
self.col_specs_template = {
'id': {
'header': [1, 10, 'text', _render("_('ID')")],
'lines': [1, 0, 'number', _render("line.id ")],
'totals': [1, 0, 'text', None]},
'invoice_number': {
'header': [1, 15, 'text', _render("_('Invoice Number')")],
'lines': [1, 0, 'text', _render("line.number or ''")],
'totals': [1, 0, 'text', None]},
'date_service': {
'header': [1, 12, 'text', _render("_('Date Service')")],
'lines': [1, 0, 'text', _render("line.event_id and str(line.event_id.event_start_date) or ''")],
'totals': [1, 0, 'text', None]},
'date_invoice': {
'header': [1, 12, 'text', _render("_('Invoice Date')")],
'lines': [1, 0, 'text', _render("line.date_invoice or ''")],
'totals': [1, 0, 'text', None]},
'event_ref': {
'header': [1, 10, 'text', _render("_('Event No')")],
'lines': [1, 0, 'text', _render("line.event_id and line.event_id.name or ''")],
'totals': [1, 0, 'text', None]},
'language': {
'header': [1, 15, 'text', _render("_('Language')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.event_id and line.event_id.language_id and line.event_id.language_id.name or '' "))],
'totals': [1, 0, 'text', None]},
'amount': {
'header': [1, 10, 'text', _render("_('Amount')"), None, self.rh_cell_style_right],
'lines': [1, 0, 'number', _render("round(line.residual,2) or 0.0 ")],
'totals': [1, 0, 'number', None, _render("amount_total_formula"), self.rt_cell_style_decimal]},
'payment_received': {
'header': [1, 10, 'text', _render("_('Payment Received')")],
'lines': [1, 0, 'number', _render("round(line.amount_total - line.residual,2) or 0.0 ")],
'totals': [1, 0, 'number', None, _render("payment_total_formula"), self.rt_cell_style_decimal]},
'address': {
'header': [1, 30, 'text', _render("_('Address')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.partner_id and line.partner_id.street or '' "))],
'totals': [1, 0, 'text', None]},
'city': {
'header': [1, 13, 'text', _render("_('City')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.partner_id and line.partner_id.city or '' "))],
'totals': [1, 0, 'text', None]},
'zip': {
'header': [1, 10, 'text', _render("_('Zip')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.partner_id and line.partner_id.zip or '' "))],
'totals': [1, 0, 'text', None]},
'service_area': {
'header': [1, 15, 'text', _render("_('Service Area')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]},
'gl': {
'header': [1, 15, 'text', _render("_('GL#')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.event_id and line.event_id.cust_gpuid or '' "))],
'totals': [1, 0, 'text', None]},
'nud': {
'header': [1, 15, 'text', _render("_('NUD#')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.event_id and line.event_id.cust_csid or '' "))],
'totals': [1, 0, 'text', None]},
'approving_mgr': {
'header': [1, 15, 'text', _render("_('Approving Mgr')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.event_id and line.event_id.approving_mgr or '' "))],
'totals': [1, 0, 'text', None]},
'department': {
'header': [1, 15, 'text', _render("_('Department')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.event_id and line.event_id.department or '' "))],
'totals': [1, 0, 'text', None]},
'check': {
'header': [1, 10, 'text', _render("_('Check#')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]},
'check_date': {
'header': [1, 10, 'text', _render("_('Check date')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]},
'status': {
'header': [1, 15, 'text', _render("_('Status')")],
'lines': [1, 0, 'text', _render("line.state or '' ")],
'totals': [1, 0, 'text', None]},
'po_no': {
'header': [1, 13, 'text', _render("_('PO#')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.event_id and line.event_id.po_no or ''"))],
'totals': [1, 0, 'text', None]},
'contract_no': {
'header': [1, 13, 'text', _render("_('Contract#')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.ordering_partner_id and line.ordering_partner_id.contract_no or '' "))],
'totals': [1, 0, 'text', None]},
'iu_actions': {
'header': [1, 42, 'text', _render("_('IU Actions')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.comment or '' "))],
'totals': [1, 0, 'text', None]},
'event_purpose': {
'header': [1, 13, 'text', _render("_('Event Purpose')")],
'lines': [1, 0, 'text', _render("line.event_id and str(line.event_id.event_purpose or '') or ''")],
'totals': [1, 0, 'text', None]},
'department': {
'header': [1, 15, 'text', _render("_('Department')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.event_id and line.event_id.department or '' "))],
'totals': [1, 0, 'text', None]},
'dr_name': {
'header': [1, 15, 'text', _render("_('Doctor Name')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.event_id and line.event_id.dr_name or '' "))],
'totals': [1, 0, 'text', None]},
'patient_medical_number': {
'header': [1, 13, 'text', _render("_('Patient Medical#')")],
'lines': [1, 0, 'text', self.parse_unicode(_render("line.event_id and line.event_id.patient_id and line.event_id.patient_id.ssnid or ''"))],
'totals': [1, 0, 'text', None]},
}
def __init__(self,
name,
table,
rml=False,
parser=False,
header=True,
store=False):
super(account_invoice_xls_fcci_translation,
self).__init__(name, table, rml, parser, header, store)
# Cell Styles
_xs = self.xls_styles
# header
rh_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rh_cell_style = xlwt.easyxf(rh_cell_format)
self.rh_cell_style_center = xlwt.easyxf(rh_cell_format + _xs['center'])
self.rh_cell_style_right = xlwt.easyxf(rh_cell_format + _xs['right'])
# lines
aml_cell_format = _xs['borders_all']
self.aml_cell_style = xlwt.easyxf(aml_cell_format)
self.aml_cell_style_center = xlwt.easyxf(aml_cell_format +
_xs['center'])
self.aml_cell_style_date = xlwt.easyxf(
aml_cell_format + _xs['left'],
num_format_str=report_xls.date_format)
self.aml_cell_style_decimal = xlwt.easyxf(
aml_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
# totals
rt_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rt_cell_style = xlwt.easyxf(rt_cell_format)
self.rt_cell_style_right = xlwt.easyxf(rt_cell_format + _xs['right'])
self.rt_cell_style_decimal = xlwt.easyxf(
rt_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
self.col_specs_template = {
'id': {
'header': [1, 10, 'text', _render("_('ID')")],
'lines': [1, 0, 'number', _render("line.id ")],
'totals': [1, 0, 'text', None]
},
'invoice_number': {
'header': [1, 15, 'text',
_render("_('Invoice Number')")],
'lines': [1, 0, 'text',
_render("line.name or ''")],
'totals': [1, 0, 'text', None]
},
'payer': {
'header': [1, 12, 'text', _render("_('Payer')")],
'lines': [
1, 0, 'text',
_render(
"line.partner_id and str(line.partner_id.name or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'branch': {
'header': [1, 12, 'text',
_render("_('Branch')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'date_of_service': {
'header': [1, 10, 'text',
_render("_('Date of Service')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'claimant': {
'header': [1, 10, 'text',
_render("_('Claimant')")],
'lines': [
1, 0, 'text',
_render(
"line.event_id and line.event_id.patient_id and str(line.event_id.patient_id.complete_name or '') or '' "
)
],
'totals': [1, 0, 'text', None]
},
'adjuster': {
'header': [1, 15, 'text',
_render("_('Adjuster')")],
'lines': [
1, 0, 'text',
_render("line.event_id and line.event_id.contact_id and \
str(line.event_id.contact_id.complete_name) or ''"
)
],
'totals': [1, 0, 'text', None]
},
'job_outcome': {
'header': [1, 10, 'text',
_render("_('Job Outcome')")],
'lines': [
1, 0, 'text',
_render(
"line.event_id and line.event_id.event_out_come_id and \
str(line.event_id.event_out_come_id.name) or ''"
)
],
'totals': [1, 0, 'number', None, None]
},
'transport_type': {
'header': [1, 10, 'text',
_render("_('Transport Type')")],
'lines': [
1, 0, 'text',
_render(
"line.event_id and str(line.event_id.transportation_type or '') or ''"
)
],
'totals': [1, 0, 'text', None, None]
},
'claim_number': {
'header': [1, 15, 'text',
_render("_('Claim Number')")],
'lines': [
1, 0, 'text',
_render(
"line.event_id and str(line.event_id.claim_no or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'stardard': {
'header': [1, 15, 'text',
_render("_('Stardard')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'billed': {
'header': [1, 15, 'text',
_render("_('Billed')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'saving': {
'header': [
1, 10, 'text',
_render("_('Saving')"), None, self.rh_cell_style_right
],
'lines': [1, 0, 'text', None],
'totals': [
1, 0, 'number', None,
_render("amount_total_formula"), self.rt_cell_style_decimal
]
},
'vehicle_type': {
'header': [1, 10, 'text',
_render("_('Vehicle Type')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None, None]
},
'referral_state': {
'header': [1, 15, 'text',
_render("_('Referral State')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'description': {
'header': [1, 15, 'text',
_render("_('Description')")],
'lines':
[1, 0, 'text',
_render("str(line.comment or '') or ''")],
'totals': [1, 0, 'text', None]
},
'langauge_service_type': {
'header':
[1, 15, 'text',
_render("_('Langauge Service Type')")],
'lines': [
1, 0, 'text',
_render(
"line.event_id and line.event_id.lang_service_type or ''"
)
],
'totals': [1, 0, 'text', None]
},
'facility': {
'header': [1, 15, 'text',
_render("_('Facility')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
}
def __init__(self,
name,
table,
rml=False,
parser=False,
header=True,
store=False):
super(account_invoice_line_xls_hartford,
self).__init__(name, table, rml, parser, header, store)
# Cell Styles
_xs = self.xls_styles
# header
rh_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rh_cell_style = xlwt.easyxf(rh_cell_format)
self.rh_cell_style_center = xlwt.easyxf(rh_cell_format + _xs['center'])
self.rh_cell_style_right = xlwt.easyxf(rh_cell_format + _xs['right'])
# lines
aml_cell_format = _xs['borders_all']
self.aml_cell_style = xlwt.easyxf(aml_cell_format)
self.aml_cell_style_center = xlwt.easyxf(aml_cell_format +
_xs['center'])
self.aml_cell_style_date = xlwt.easyxf(
aml_cell_format + _xs['left'],
num_format_str=report_xls.date_format)
self.aml_cell_style_decimal = xlwt.easyxf(
aml_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
# totals
rt_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rt_cell_style = xlwt.easyxf(rt_cell_format)
self.rt_cell_style_right = xlwt.easyxf(rt_cell_format + _xs['right'])
self.rt_cell_style_decimal = xlwt.easyxf(
rt_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
self.col_specs_template_hartford = {
'vendor': {
'header': [1, 10, 'text',
_render("_('Vendor')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.partner_id and str(line.invoice_id.partner_id.complete_name or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'claim_number': {
'header': [1, 10, 'text',
_render("_('Claim Number')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and str(line.invoice_id.event_id.claim_no or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'segment': {
'header': [1, 13, 'text',
_render("_('Segment')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'claim_office': {
'header': [1, 20, 'text',
_render("_('Claim Office')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'requestor_name': {
'header': [1, 20, 'text',
_render("_('Requestor Name')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.ordering_partner_id and \
str(line.invoice_id.event_id.ordering_partner_id.complete_name or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'claim_handler_name': {
'header': [1, 13, 'text',
_render("_('Claim Handler Name')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'claim_name': {
'header': [1, 15, 'text',
_render("_('Claim Name')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'state': {
'header': [1, 20, 'text', _render("_('State')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.location_id and str(line.invoice_id.event_id.location_id.name or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'date_of_loss': {
'header': [1, 20, 'text',
_render("_('Date Of Loss')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'service_type': {
'header': [1, 13, 'text',
_render("_('Service Type')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.event_type or ''"
)
],
'totals': [1, 0, 'text', None]
},
'service_language': {
'header': [1, 20, 'text',
_render("_('Service Language')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.language_id and str(line.invoice_id.language_id.name or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'language_interpretation_type': {
'header':
[1, 13, 'text',
_render("_('Language Interpretation Type')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and line.invoice_id.event_id.lang_service_type or ''"
)
],
'totals': [1, 0, 'text', None]
},
'urgent_or_nonurgent': {
'header': [1, 30, 'text',
_render("_('Urgent or Nonurgent')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'referral_date': {
'header': [1, 13, 'text',
_render("_('Referral Date')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and str(line.invoice_id.event_id.event_start_date) or ''"
)
],
'totals': [1, 0, 'text', None]
},
'referral_time': {
'header': [1, 10, 'text',
_render("_('Referral Time')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id.event_id and str(line.invoice_id.event_id.event_start_hr or '') + ':' + str(line.invoice_id.event_id.event_start_min or '') + ' ' + str(line.invoice_id.event_id.am_pm or '') or '' "
)
],
'totals': [1, 0, 'text', None]
},
'telephonic_confirmation_date': {
'header':
[1, 25, 'text',
_render("_('Telephonic Confirmation Date')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'email_confirm_date': {
'header': [1, 10, 'text',
_render("_('Email Confirm Date')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'claim_contact_date': {
'header': [1, 10, 'text',
_render("_('Claim Contact Date')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'claim_reconfirm_date': {
'header':
[1, 10, 'text',
_render("_('Claim Reconfirm Date')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'claim_contact_date': {
'header': [1, 10, 'text',
_render("_('Claim Contact Date')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'claim_reconfirm_date': {
'header':
[1, 10, 'text',
_render("_('Claim Reconfirm Date')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'no_show': {
'header': [1, 13, 'text',
_render("_('No Show')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
#datetime.strptime(datetime.strptime(dt_from,"%Y-%m-%d").strftime('%Y-%m-%d %H:%M:%S'), "%Y-%m-%d %H:%M:%S")
'cancellation': {
'header': [1, 13, 'text',
_render("_('Cancellation')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'cancellation_reason': {
'header': [1, 15, 'text',
_render("_('Cancellation Reason')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id and line.invoice_id.event_id and str(line.invoice_id.event_id.cancel_reason_id.name or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'date_of_cancellation': {
'header':
[1, 10, 'text',
_render("_('Date Of Cancellation')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'cancellation_notice': {
'header': [1, 13, 'text',
_render("_('Cancellation Notice')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'date_summary_report_sent': {
'header':
[1, 10, 'text',
_render("_('Date Summary Report Sent')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'date_of_service': {
'header': [
1, 10, 'text',
_render("_('Date Of Service')"), None,
self.rh_cell_style_right
],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'invoice_number': {
'header': [1, 40, 'text',
_render("_('Invoice Number')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id and str(line.invoice_id.name or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'invoice_date': {
'header': [1, 40, 'text',
_render("_('Invoice Date')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id and str(line.invoice_id.date_invoice or '') or ''"
)
],
'totals': [1, 0, 'text', None]
},
'invoice_submission_date': {
'header':
[1, 40, 'text',
_render("_('Invoice Submission Date')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'invoice_amount': {
'header': [1, 40, 'text',
_render("_('Invoice Amount')")],
'lines':
[1, 0, 'number',
_render("line.price_subtotal or ''")],
'totals': [1, 0, 'text', None]
},
'cancellation_fee': {
'header': [1, 40, 'text',
_render("_('Cancellation Fee')")],
'lines': [1, 0, 'number', None],
'totals': [1, 0, 'text', None]
},
'mileage': {
'header': [1, 40, 'text',
_render("_('Mileage')")],
'lines': [1, 0, 'number',
_render("line.mileage or 0.0")],
'totals': [1, 0, 'text', None]
},
}
def __init__(self,
name,
table,
rml=False,
parser=False,
header=True,
store=False):
super(account_invoice_xls_sales_commission,
self).__init__(name, table, rml, parser, header, store)
# Cell Styles
_xs = self.xls_styles
# header
rh_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rh_cell_style = xlwt.easyxf(rh_cell_format)
self.rh_cell_style_center = xlwt.easyxf(rh_cell_format + _xs['center'])
self.rh_cell_style_right = xlwt.easyxf(rh_cell_format + _xs['right'])
# lines
aml_cell_format = _xs['borders_all']
self.aml_cell_style = xlwt.easyxf(aml_cell_format)
self.aml_cell_style_center = xlwt.easyxf(aml_cell_format +
_xs['center'])
self.aml_cell_style_date = xlwt.easyxf(
aml_cell_format + _xs['left'],
num_format_str=report_xls.date_format)
self.aml_cell_style_decimal = xlwt.easyxf(
aml_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
# totals
rt_cell_format = _xs['bold'] + _xs['fill'] + _xs['borders_all']
self.rt_cell_style = xlwt.easyxf(rt_cell_format)
self.rt_cell_style_right = xlwt.easyxf(rt_cell_format + _xs['right'])
self.rt_cell_style_decimal = xlwt.easyxf(
rt_cell_format + _xs['right'],
num_format_str=report_xls.decimal_format)
self.col_specs_template = {
'id': {
'header': [1, 10, 'text', _render("_('ID')")],
'lines': [1, 0, 'number', _render("line.id ")],
'totals': [1, 0, 'text', None]
},
'invoice_number': {
'header': [1, 15, 'text',
_render("_('Invoice Number')")],
'lines': [1, 0, 'text',
_render("line.number or ''")],
'totals': [1, 0, 'text', None]
},
'event_id': {
'header': [1, 12, 'text',
_render("_('Event Name')")],
'lines': [
1, 0, 'text',
_render("line.event_id and line.event_id.name or ''")
],
'totals': [1, 0, 'text', None]
},
'outcome': {
'header': [1, 12, 'text',
_render("_('Outcome')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'appt_month': {
'header': [1, 10, 'text',
_render("_('Appointment Month')")],
# 'lines': [1, 0, 'text',self._get_month(_render("line.event_start")), self.rt_cell_style_decimal],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'jurisdiction': {
'header': [1, 10, 'text',
_render("_('Jurisdiction')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'text', None]
},
'language': {
'header': [1, 15, 'text',
_render("_('Language')")],
'lines': [
1, 0, 'text',
_render(
"line.language_id and line.language_id.name or (line.event_id and line.event_id.language_id and line.event_id.language_id.name or '') "
)
],
'totals': [1, 0, 'text', None]
},
'transportation_type': {
'header': [1, 10, 'text',
_render("_('Transportation Type')")],
'lines': [1, 0, 'text', None],
'totals': [1, 0, 'number', None, None]
},
'service_type': {
'header': [1, 15, 'text',
_render("_('Service Type')")],
'lines': [
1, 0, 'text',
_render(
"line.invoice_id and line.invoice_id.event_id and line.invoice_id.event_id.event_type or ''"
)
],
'totals': [1, 0, 'text', None]
},
'pay_location': {
'header': [1, 15, 'text',
_render("_('Pay Location')")],
'lines': [
1, 0, 'text',
_render(
"line.location_id and line.location_id.city or '' ")
],
'totals': [1, 0, 'text', None]
},
'pay_company': {
'header': [1, 15, 'text',
_render("_('Pay Company')")],
'lines':
[1, 0, 'text',
_render("line.partner_id.name or '' ")],
'totals': [1, 0, 'text', None]
},
'amount': {
'header': [
1, 10, 'text',
_render("_('Amount')"), None, self.rh_cell_style_right
],
'lines': [
1, 0, 'number',
_render("line.residual and round(line.residual,2) or 0.0 ")
],
'totals': [
1, 0, 'number', None,
_render("amount_total_formula"), self.rt_cell_style_decimal
]
},
}
