Esempio n. 1
0
                        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
Esempio n. 3
0
                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:
Esempio n. 4
0
                        '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
Esempio n. 5
0
                        '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
Esempio n. 6
0
                                     '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
Esempio n. 7
0
                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:
Esempio n. 11
0
                   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
Esempio n. 13
0
            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
Esempio n. 14
0
                        '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:
Esempio n. 16
0
            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
Esempio n. 17
0
                        '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
Esempio n. 19
0
            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
Esempio n. 20
0
                        # 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
Esempio n. 21
0
            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:
Esempio n. 22
0
                        '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:
Esempio n. 24
0
                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
Esempio n. 25
0
                            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:
Esempio n. 26
0
                        }
                        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
Esempio n. 27
0
                    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
Esempio n. 28
0
                        '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
Esempio n. 30
0
                        '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