price=workcenter.product_id.standard_price
return price
# hpusa configures 27-05-2015
wizard_hpusa_report()
# openoffice_report.openoffice_report(
# 'report.manufacturing_summary',
# 'wizard.hpusa.report',
# parser=wizard_hpusa_report
# )
openoffice_report.openoffice_report(
'report.manufacturing_detail',
'wizard.hpusa.report',
parser=wizard_hpusa_report
)
openoffice_report.openoffice_report(
'report.material_repair_summay',
'wizard.hpusa.report',
parser=wizard_hpusa_report
)
openoffice_report.openoffice_report(
'report.manufacturing_v_invoice',
'wizard.hpusa.report',
parser=wizard_hpusa_report
)
#
def create(self, cr, uid, vals, context=None):
res = super(sale_order, self).create(cr, uid, vals, context)
template = self.pool.get('email.template').search(cr, uid, [('name','=','New Sale Order')])
if template:
self.pool.get('email.template').send_mail(cr, uid, template[0], int(res), True, context=context)
return res
def action_refuse(self, cr, uid, ids, context=None):
self.write(cr, uid, ids, {'state': 'draft'})
sale_order()
openoffice_report.openoffice_report(
'report.report_so_manufacturing',
'sale.order',
parser=sale_order
)
class sale_order_line(osv.osv):
_inherit = "sale.order.line"
def _get_mo(self, cr, uid, ids, field_name, arg, context=None):
result = {}
for record in self.browse(cr, uid, ids, context=context):
wo_id = None
state = ''
wo_state = ''
wo_name ='' # hpusa configure
production_id = self.pool.get('mrp.production').search(cr, uid, [('so_id','=',record.order_id.id),('so_line_id','=',record.id)])
if production_id:
i = 0
'qty': result['qty'],
'qly':result['qly'],
})
if result ['hp_type'] =='diamonds':
arr.append({
'p_code':result['p_code'],
'p_name': result['p_name'],
'unit': result['unit'],
'qty': result['qty'],
'qly':result['qly'],
})
return arr
openoffice_report.openoffice_report(
'report.material_request_detail',
'wizard.hpusa.material.request.report',
parser=wizard_hpusa_material_request_report
)
openoffice_report.openoffice_report(
'report.material_request_summary',
'wizard.hpusa.material.request.report',
parser=wizard_hpusa_material_request_report
)
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
# LEFT JOIN product_template p ON(p.id = line.product_id)
# LEFT JOIN stock_picking pk ON(pk.id = st.picking_id)
# LEFT JOIN product_uom uom ON(uom.id = st.product_uom)
# LEFT JOIN res_currency cu ON(cu.id = po.currency_id)
# WHERE st.state = 'done' AND po.partner_id = %s AND st.date >= '%s' AND st.date <= '%s' '''%(form['partner_id'][0],form['date_from'],form['date_to'])
# cr.execute(sql)
# print sql
result = cr.dictfetchall()
for i in result:
res.append({
'po_name': 's',
'product_name': 'ssss',
'picking_name': 'sdsd',
'uom': 'sssss',
'cu_name': 'sssss',
'product_quantity': 'sssss',
'input_quantity': 'ssas',
'date': 'sa',
'price_unit': 'sdsdsd',
'total': '0',
})
return res
report_report_picking_wizard()
openoffice_report.openoffice_report('report.report_picking_in',
'report.picking.in',
parser=report_report_picking_wizard)
# cr.execute(sql)
# print sql
result = cr.dictfetchall()
for i in result:
res.append({
'po_name': 's',
'product_name' : 'ssss',
'picking_name' : 'sdsd',
'uom' : 'sssss',
'cu_name' : 'sssss',
'product_quantity': 'sssss',
'input_quantity' : 'ssas',
'date': 'sa',
'price_unit': 'sdsdsd',
'total': '0',
})
return res
report_report_picking_wizard()
openoffice_report.openoffice_report(
'report.report_picking_in',
'report.picking.in',
parser=report_report_picking_wizard
)
# -*- encoding: utf-8 -*-
##############################################################################
#
# Copyright (C) 2014 Vision Software (<http://visoftware.com>). All Rights Reserved
#
##############################################################################
from dateutil import relativedelta
import time
from datetime import datetime
from datetime import timedelta
from openerp.osv import fields, osv, orm
from openerp.addons.pxgo_openoffice_reports import openoffice_report
from openerp.report import report_sxw
openoffice_report.openoffice_report(
'report.notify_commission',
'commission.worksheet',
)
'wt_first': sum_wt_first,
'qty_out': sum_qty_out,
'wt_out': sum_wt_out,
'qty_lost': sum_qty_lost,
'wt_lost': sum_wt_lost,
'qty_ship': sum_qty_ship,
'wt_ship': sum_wt_ship,
'qty_stock': sum_qty_stock,
'wt_stock': sum_wt_stock,
})
# hpusa 13-07-2015
print 'End get information'
return arr
openoffice_report.openoffice_report('report.stock_picking_detail',
'wizard.hpusa.product.list.report',
parser=wizard_hpusa_product_list_report)
openoffice_report.openoffice_report('report.stock_in_out',
'wizard.hpusa.report',
parser=wizard_hpusa_product_list_report)
# hpusa 08-07-2015
openoffice_report.openoffice_report('report.stock_in_out_diamond',
'wizard.hpusa.report',
parser=wizard_hpusa_product_list_report)
# hpusa 08-07-2015
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
'qty_lost': sum_qty_lost,
'wt_lost': sum_wt_lost,
'qty_ship': sum_qty_ship,
'wt_ship': sum_wt_ship,
'qty_stock': sum_qty_stock,
'wt_stock': sum_wt_stock,
})
# hpusa 13-07-2015
print 'End get information'
return arr
openoffice_report.openoffice_report(
'report.stock_picking_detail',
'wizard.hpusa.product.list.report',
parser=wizard_hpusa_product_list_report
)
openoffice_report.openoffice_report(
'report.stock_in_out',
'wizard.hpusa.report',
parser=wizard_hpusa_product_list_report
)
# hpusa 08-07-2015
openoffice_report.openoffice_report(
'report.stock_in_out_diamond',
'wizard.hpusa.report',
parser=wizard_hpusa_product_list_report
)
'stt': stt,
'name': i['name'],
'amount' : i['amount'],
'payment' : i['payment'],
'remain': remain ,
'limit': i['credit_limit'],
'str_limit': str_limit,
})
return {'line1':res, 'line2': res_1, 'total_pay1': total_pay1, 'pay_1': pay_1, 'debit1': debit1, 'total_pay2': total_pay2, 'pay_2': pay_2, 'debit2': debit2}
openoffice_report.openoffice_report(
'report.commission_summary',
'sale.order',
parser=agent_detail_report
)
openoffice_report.openoffice_report(
'report.liabilities',
'sale.order',
parser=agent_detail_report
)
openoffice_report.openoffice_report(
'report.commission_detail',
'sale.order',
parser=agent_detail_report
)
