round(invoices_list['somme_timbre'], 3), 'somme_avoir': round(refund_list['somme_refund'], 3), 'total_general': round(somme_total, 3), 'from': datedebut, 'to': datefin, 'user': obj_user.name, } result.append(data) #invoices_list = cr.dictfetchall() count_month += 1 else: raise osv.except_osv(_('Avertissement !'), _("Verifier année début et année fin ")) return result jasper_report.report_jasper( 'report.jasper_recap_mouvement_print', 'account.invoice', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
'brut': '', 'employee': '', 'matricule': '', 'stat_path': os.getcwd() + "/addons/pay_report/", 'nb_jour': '', 'nb_heure': '', 'nb_heure_supp': '', 'cnss': '', 'irpp': '', 'date': date, 'avance': '', 'nap': '', 'from_date': from_date, 'to_date': to_date, 'company_name': '', 'company_street': '', 'company_street2': '', 'company_city': '', 'company_zip': '', } result.append(data) return result jasper_report.report_jasper( 'report.jasper_decompte_salaire_print', 'hr.payslip', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
cr.execute('SELECT * FROM product_product order by default_code') products = cr.dictfetchall() for product in products: dom = [('company_id', '=', 1), ('location_id', 'child_of', stock_id), ('product_id','=', product['id'])] quants = quant_obj.search(cr, uid, dom, context=context) tot_qty = 0 for quant in quant_obj.browse(cr, uid, quants, context=context): tot_qty += quant.qty if (tot_qty > 0 ): # get uom cr.execute('''SELECT product_uom.name as name FROM product_uom , product_template, product_product WHERE product_template.uom_id = product_uom.id AND product_product.product_tmpl_id = product_template.id AND product_product.id=%s''', (product['id'],)) uom = cr.dictfetchone()['name'] #end get uom data={ 'header1':header1, 'header2':header2, 'date':date, 'product_name':product['name_template'], 'ref':product['default_code'], 'uom':uom, 'quantity':tot_qty, 'location':location, 'user':obj_user.name, } result.append(data) return result jasper_report.report_jasper('report.jasper_report_stock_location_print', 'stock.picking', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
'montant_facture': signe * amount_total, 'montant_ht': signe * amount_untaxed, 'timbre': round(signe * timbre, 3), 'tva6': round(signe * tva6, 3), 'tva12': round(signe * tva12, 3), 'tva18': round(signe * tva18, 3), 'base_tva6': round(signe * base_tva6, 3), 'base_tva18': round(signe * base_tva18, 3), 'base_tva12': round(signe * base_tva12, 3), 'exoner': signe * exoner, 'recap_ttc_6': round(recap_ttc_6, 3), 'recap_ttc_18': round(recap_ttc_18, 3), 'recap_ttc_12': round(recap_ttc_12, 3), 'somme_recap_ttc': round(somme_recap_ttc, 3), 'amount_tax': round(signe * amount_tax, 3), 'total_general': signe * round(somme_total, 3), 'from': datedebut, 'to': datefin, 'user': obj_user.name, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_journal_vente_print', 'account.invoice', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
'partenaire': caut.partner_id.name, 'description': caut.description, 'total': total, 'type': caut.tt, 'date': caut.date_caution, 'dateAuj': dateAuj, } result.append(data) else: data = { 'montant': '', 'partenaire': '', 'description': '', 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'total': total, 'type': '', 'date': '', 'dateAuj': dateAuj, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_etat_caution_print', 'office.caution', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
'nature_piece':NaturePiece, 'mode_reglement':ModeReglement, 'etat_piece':StatePiece, } result.append(data) else: data={ 'stat_path' :os.getcwd()+"/openerp/addons/office_stat/", 'partenaire':'', 'num_cheque_traite':'', 'date_echeance':'', 'montant_piece':0, 'nature_piece':'', 'mode_reglement':'', 'etat_piece':'', } result.append(data) #------------------------------------------------------------------------------------------------------- return result jasper_report.report_jasper('report.jasper_liste_cheque_print_1', 'reglement.piece', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
if res: tot_debit_ht = res['tot_debit_ht'] tot_debit_ttc = res['tot_debit_ttc'] cr.execute('SELECT name FROM res_partner WHERE id=%s ', (user_id, )) partner = cr.dictfetchone()['name'] ca_ht = tot_debit_ht - tot_credit_ht ca_ttc = tot_debit_ttc - tot_credit_ttc data = { 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'path': "", #os.getcwd(), 'debit': tot_debit_ht, 'credit': tot_credit_ht, 'ca': ca_ht, 'ca_ttc': ca_ttc, 'from_date': from_date_f, 'to_date': to_date_f, 'partner': partner, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_report_turnover_client_print', 'res.users', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
os.getcwd() + "/openerp/addons/office_stat/", 'total': total, 'dateAuj': dateAuj, } result.append(data) if not reg_objs and not inv_picking_objs: data = { 'num_fac': '', 'fournisseur': '', 'date': '', 'date_echeance': '', 'montant': 0.000, 'MHTVA': 0.000, 'reste_a_payer': 0.000, 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'total': total, 'dateAuj': dateAuj } result.append(data) return result jasper_report.report_jasper( 'report.jasper_reg_fourns_locaux_print', 'account.invoice', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
'product_code': product_code, 'partner': partner, 'uom': uom, 'user': obj_user.name, } result.append(data) else: data = { 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'header1': header1, 'header2': header2, 'name_product': '', 'price': '', 'supplier_product_name': '', 'product_code': '', 'partner': partner, 'uom': '', 'user': obj_user.name, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_report_supplier_product_print', 'product.supplierinfo', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
#obj_company = cr.dictfetchone() header1 = 'header1' #obj_company['parametre1'] header2 = 'header1' #obj_company['parametre2'] obj_user = self.pool.get('res.users').browse(cr, uid, uid) inventory_id = data['form']['inventory_id'] inventory = self.pool.get('stock.inventory').browse( cr, uid, inventory_id[0]) inv_date = inventory.date.split(" ")[0] inv_date = inv_date.split("-")[2] + "/" + inv_date.split( "-")[1] + "/" + inv_date.split("-")[0] for line in inventory.line_ids: data = { 'header1': header1, 'header2': header2, 'location': inventory.location_id.name, 'produit': line.product_id.name, 'ref': line.product_id.default_code, 'unite': line.product_id.uom_id.name, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_report_stock_inventory_print', 'stock.inventory', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
montant_facture= round(facture_nonregler['amount_total'],3) #montant_payer= round(facture_nonregler['montant_paye'],3) if facture_nonregler['reste_a_payer']: reste_a_payer= round(facture_nonregler['reste_a_payer'],3) else : reste_a_payer=montant_facture retenue = facture_nonregler['montant_retenue'] or 0 montant_payer = round(facture_nonregler['montant_paye'],3) - round(retenue,3) data={ 'stat_path' :os.getcwd()+"/openerp/addons/office_stat/", 'header1':'', 'header2':'', 'raison_socaile':rs_fournisseur, 'matricule_fiscale':mf_fournisseur, 'numerofacture':numero_facture, 'datefacturation':datefacturation, 'reference_fournisseur':ref_fournisseur, 'montant_facture':montant_facture, 'montant_payer2':round(montant_payer,3), 'reste_a_payer2':reste_a_payer, 'retenue':round(retenue,3), 'user':obj_user.name, } result.append(data) return result jasper_report.report_jasper('report.jasper_facture_fournisseur_nonregler_print', 'account.invoice', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
os.getcwd() + "/openerp/addons/office_stat/", 'total': total, 'dateAuj': dateAuj, } print "...................data****.", data result.append(data) else: data = { 'num_cheq': '', 'Designation': '', 'date': '', 'date_echeeance': '', 'montant': '', 'type': '', 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'total': total, 'dateAuj': dateAuj, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_cheques_depenses_print', 'office.cheque', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
else : data={ 'net':0.00, 'cin':'', 'employee':'', 'matricule':'', 'stat_path' :os.getcwd()+"/addons/pay_report/", 'adresse':'', 'situation':'', 'chef_famille':'', 'irpp':0.00, 'enfant':'', 'imposable':0.00, 'annee':annee, 'date':date, 'company_name':'', 'company_street':'', 'company_street2':'', 'company_city':'', 'company_zip':'', } result.append(data) return result jasper_report.report_jasper('report.jasper_impot_print', 'hr.payslip', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
'Designation': reg.partner_id["name"], 'date': reg.date_encaissement, 'montant': reg.montant_piece, 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'total': total, 'dateAuj': dateAuj, } result.append(data) else: data = { 'num_cheq': '', 'Designation': '', 'date': '', 'montant': '', 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'total': total, 'dateAuj': dateAuj, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_cheques_circulation_print', 'reglement.piece', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
else: qte_livree = 0 #date = move['date'] #date.split("-")[2]+"/"+date.split("-")[1]+"/"+date.split("-")[0] data = { 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'header1': header1, 'header2': header2, 'order_name': order_name, 'partner': partner_name, 'product_name': product_name, 'ref': ref, 'uom': uom, 'quantity_order': quantity_order, 'quantity_picking': qte_livree, 'qty_remaining': quantity_order - qte_livree, #'date': date, 'pourcentage': (qte_livree / quantity_order) * 100, 'user': obj_user.name, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_product_order_statement_print', 'stock.move', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
if cash_line_objs: for cash in cash_line_objs: data={ 'date_op':cash.date, 'nom_so':cash.partner_id.id, 'Designation':cash.name, 'reference':cash.ref, 'montant':cash.amount, 'solde_ouverture':cash_objs.balance_start, 'solde_final':cash_objs.balance_end_real, 'caisse':caisse_id[1], } result.append(data) else : data={ 'date_op':'', 'nom_so':'', 'Designation':'', 'reference':'', 'montant':'', 'solde_ouverture':'', 'solde_final':'', 'caisse':caisse_id[1], } result.append(data) return result jasper_report.report_jasper('report.jasper_caisse_locaux_print', 'account.bank.statement', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
'dateAuj': dateAuj, 'from_date': from_date, 'to_date': to_date, } result.append(data) else: data = { 'employee': '', 'date': '', 'montant': '', 'etat': '', 'from_date': from_date, 'to_date': to_date, 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'dateAuj': dateAuj, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_avance_print', 'hr.avance', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
#print "result====",result rows_by_date = sorted(result, key=itemgetter('date_invoice')) for obj in rows_by_date: if 'date_invoice' in obj: obj['date_invoice'] = datetime.datetime.strftime(obj['date_invoice'], "%d-%m-%Y") print "data====",data if not (inv_objs or avoir_objs or invoice_picking_objs): print "not data............" data = { 'partner_id': partner_id[1], 'date_invoice': '', 'amount_untaxed': '', 'amount_total': '', 'number': '', 'etat': '', 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'total_result': '0', 'total_untaxed_result': '0', 'dateAuj': dateAuj, 'type': '', } rows_by_date.append(data) # print rows_by_date return rows_by_date jasper_report.report_jasper('report.jasper_fiche_fournisseur_print', 'account.invoice', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
if reg_objs: for reg in reg_objs: total=total+reg.montant_piece data={ 'num_cheq':reg.num_cheque_traite, 'Designation':reg.partner_id["name"], 'date':reg.date_echance, 'montant':reg.montant_piece, 'stat_path' :os.getcwd()+"/addons/office_stat/", 'total':total, 'dateAuj':dateAuj, } result.append(data) else : data={ 'num_cheq':'', 'Designation':'', 'date':'', 'montant':'', 'stat_path' :os.getcwd()+"/addons/office_stat/", 'total':total, 'dateAuj':dateAuj, } result.append(data) return result jasper_report.report_jasper('report.jasper_cheques_antidates_print', 'reglement.piece', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
# else : # caution=caution+caut.montant total=compte_biat+compte_zitouna+cheque_antidates+factures_clients+stock+solde_caisse+caution-(cheque_circ+fact_etrangr+fact_locaux+cheque_dep+avoir) ####fin data={ 'compte_biat':compte_biat, 'compte_zitouna':compte_zitouna, 'cheque_antidates':cheque_antidates, 'factures_clients':factures_clients, 'solde_caisse':solde_caisse, 'cheque_circ':cheque_circ, 'fact_etrangr':fact_etrangr, 'fact_locaux':fact_locaux, 'stock':stock, 'total':total, 'cautions':caution, 'avoir': avoir, 'cheques': cheque_dep, 'stat_path' :os.getcwd()+"/openerp/addons/office_stat/", } result.append(data) return result jasper_report.report_jasper('report.jasper_etat_profit_print', 'account.invoice', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
inventory = self.pool.get('stock.inventory').browse( cr, uid, inventory_id[0]) inv_date = inventory.date.split(" ")[0] inv_date = inv_date.split("-")[2] + "/" + inv_date.split( "-")[1] + "/" + inv_date.split("-")[0] for line in inventory.line_ids: data = { 'header1': header1, 'header2': header2, 'location': inventory.location_id.name, 'reference_inv': inventory.name, 'date_inventaire': inv_date, 'produit': line.product_id.name, 'ref': line.product_id.default_code, 'unite': line.product_id.uom_id.name, 'qte_initiale': round(line.theoretical_qty, 3), 'qte_inventaire': round(line.product_qty, 3), 'user': obj_user.name, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_report_etat_inventaire_print', 'stock.inventory', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
'raison_sociale': partner.name, 'num_BonReception': br_numero, 'date_br': br_date, 'montant_ttc': br['amount_total'], 'montant_ht': br['amount_untaxed'], 'user': obj_user.name, } result.append(data) else: data = { 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'raison_sociale': '', 'num_BonReception': '', 'date_br': '', 'montant_ttc': 0, 'montant_ht': 0, 'user': obj_user.name, } result.append(data) print 'data::::::', data return result jasper_report.report_jasper( 'report.jasper_bl_non_facturer_print', 'stock.move', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
data = { 'date': date, 'heure': heure, 'mat': employee.num_chezemployeur, 'nom': employee.name, 'ret_cnss': round(cnss, 3), 'ret_irpp': round(irpp, 3), 'salaire_net': round(net, 3), 'stat_path': os.getcwd() + "/addons_Polygarde/pay_report/", } result.append(data) return result jasper_report.report_jasper( 'report.jasper_report_journal_de_paie_print', 'hr.payslip', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
mode_paiement = self.pool.get('reglement.mode').browse(cr, uid, piece['mode_reglement'], context=context) type_piece = mode_paiement.designation jour = (piece['create_date'].split("-")[2]).split(" ")[0] date_piece = jour+"/"+piece['create_date'].split("-")[1]+"/"+piece['create_date'].split("-")[0] data={ 'stat_path' :os.getcwd()+"/openerp/addons/office_stat/", #'header1':header1, #'header2':header2, 'raison_social':RaisonSocial, 'matricule_fiscale':MatriculeFiscale, 'date_debut':datedebut, 'date_fin':datefin, 'date_piece':date_piece, 'libelle':'PIECE PAIEMENT:'+type_piece, 'num_piece':piece['num_cheque_traite'], 'debit':0, 'credit':piece['montant_piece'], 'solde':round (debit - credit,3), 'user':obj_user.name, 'date_report_precedent':ReportDatePiece, 'libelle_report_precedent':ReportLibellePiece, 'num_piece_report_precedent':ReportNumeroPiece, 'debit_report_precedent':ReportDebit, 'credit_report_precedent':ReportCredit, 'solde_precedant':solde_precedant, } result.append(data) return result jasper_report.report_jasper('report.jasper_rapport_grand_livre_print', 'reglement.piece', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
image = product['image'] name_file_image = '/home/mehdi/image/%s' % ( default_code) open(name_file_image, 'wb').write(base64.decodestring(str(image))) else: name_file_image = False data = { 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'company_id': '1', 'name_file_image': name_file_image, 'default_code': default_code, 'name_template': name_template, 'description': description, 'name_category': name_category, 'uom': uom, 'user': obj_user.name, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_report_category_product_print', 'product.category', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
} result.append(data) else: data = { 'brut1': '', 'brut2': '', 'brut3': '', 'total': '', 'matricule': '', 'cnss': '', 'trimestre': '', 'year': year, 'date': date, 'company_name': '', 'company_street': '', 'company_street2': '', 'company_city': '', 'company_zip': '', 'company_vat': '', } result.append(data) return result jasper_report.report_jasper( 'report.jasper_declaration_cnss_print', 'hr.payslip', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
data={ 'raison_socaile':rs_fournisseur, 'numerofacture':numero_facture, 'datefacturation':datefacturation, 'montant_facture':signe * round(ttc,3), 'montant_ht':signe * round(amount_untaxed,3), 'tva12':signe * round(tva12,3), 'tva6':signe * round(tva6,3), 'tva18':signe * round(tva18,3) , 'base0':signe * round(base0,3), 'base12':signe * round(base12,3), 'base6':signe * round(base6,3), 'base18':signe * round(base18,3), 'timbre':signe * round(timbre,3), 'exoner':signe * round(exoner,3), 'tot_general':signe * round(total,3), 'recap_ttc12':round(somme_ttc12,3), 'recap_ttc6':round(somme_ttc6,3), 'recap_ttc18':round(somme_ttc18,3), 'recap_somme_tva':round(somme_tva6 + somme_tva12 + somme_tva18,3), 'recap_somme_base':round(somme_base6 + somme_base12 + somme_base18,3), 'recap_somme_ttc':round(somme_ttc12 + somme_ttc12 + somme_ttc18,3), 'user':obj_user.name, } result.append(data) print 'data:::::::::::::::',data return result jasper_report.report_jasper('report.jasper_tva_achat_print', 'account.invoice', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
'dateAuj': dateAuj, } result.append(data) if not inv_picking_objs and not reg_objs: data = { 'num_fac': '', 'fournisseur': '', 'date': '', 'montant': '', 'montant_local': '', 'rate': '', # 'date_reg':'', 'date_echeance': reg.date_due, 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'total': total, 'dateAuj': dateAuj, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_reg_fourns_etrangeres_print', 'account.invoice', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c ###################"""""""""""""""""""
'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'dateAuj': dateAuj, } result.append(data) else: data = { 'num_fac': '', 'client': '', 'date': '', 'montant': '', 'reste_a_payer': '', 'etat': '', 'MHTVA': '', 'total': 0, 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'dateAuj': dateAuj, } result.append(data) return result jasper_report.report_jasper( 'report.jasper_fact_client_non_paye_print', 'account.invoice', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c
'nature_piece': NaturePiece, 'mode_reglement': ModeReglement, 'etat_piece': StatePiece, } result.append(data) else: data = { 'stat_path': os.getcwd() + "/openerp/addons/office_stat/", 'company_address': comp_address, 'company_tel': comp_tel, 'company_fax': comp_fax, 'partenaire': '', 'num_cheque_traite': '', 'date_echeance': '', 'montant_piece': 0, 'nature_piece': '', 'mode_reglement': '', 'etat_piece': '', } result.append(data) return result jasper_report.report_jasper( 'report.jasper_liste_cheque_fournisseur_print', 'reglement.piece', parser=jasper_client, ) # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:c