;ò
“hCc           @   sH   d  Z  d k Td e f d „  ƒ  YZ d „  Z e d j o e ƒ  n d S(   s(   
   Copyright (C) 2003-2005 PimenTech SARL (http://www.pimentech.net)

   Pimengest2 is free software; you can redistribute it and/or
   modify it under the terms of the GNU General Public License as
   published by the Free Software Foundation; either version 2 of the
   License, or (at your option) any later version.

   Pimengest2 is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
   General Public License for more details.

   You should have received a copy of the GNU General Public
   License along with this library; see the file COPYING.LIB.  If not,
   write to the Free Software Foundation, Inc., 59 Temple Place - Suite 330,
   Boston, MA 02111-1307, USA.	
(   s   *s
   genfacturec           B   s¦  t  Z d Z d Z h  d d <d d <d d <d d <d	 d <d
 d <d d <d d <d d <d d <d d <d d <d d <d d <d d <d d <d d <d d <d d <d d <d d <d d <d d <d d <d d <d  d <d! d <d" d <d# d <d$ d <d% d <d& d <d' d <d( d <d) d <d* d <d+ d <d, d <d- d <d# d <d. d <Z d/ „  Z d0 „  Z d1 „  Z RS(2   Nsh  
SELECT a.nom, a.description, a.code, tva.taux, ca.quantite, ca.declinaison, ca.remise, ca.montant_ht AS ca_ht, ca.montant_ttc AS ca_ttc
FROM article a, commande_article ca, facture f, devis d, tva, statut st
WHERE f.uid=%s AND f.ref_devis=d.uid AND d.uid=ca.ref_devis AND ca.ref_article=a.uid AND tva.uid=a.ref_tva AND ca.ref_statut=st.uid AND st.nom='valide's  
SELECT cp.uid, cp.intitule AS prestation, cp.description, cp.remise, cp.montant_ht, cp.montant_ttc
FROM commande_prestation cp, devis d, facture f, statut st
WHERE f.uid=%s AND f.ref_devis=d.uid AND cp.ref_devis=d.uid AND cp.ref_statut=st.uid AND st.nom='valide'
ORDER BY cp.uids   ENTETEs   %# entete_from_genpdfs   CLIENTs   ~s   ADRESSE_CLIENTs	   CP_CLIENTs   VILLE_CLIENTs   NUM_FACTUREs   DATE_EMISSIONs   DATE_ECHEANCEs   DEVIS_INTITULEs   DESCRIPTION_PRESTATIONs   ARTICLESs   PRESTASs	   GLOBAL_HTs
   GLOBAL_TTCs   REGLEs   0s   PAIEMENTs   PERIODEs
   MONTANT_HTs   ESCOMPTEs	   TOTAL_TVAs
   DETAIL_TVAs   DETAIL_TVA_RATIOs   TVAs   CHARGEs   CHARGE_COMMENTAIREs   %# commentaire_from_genpdfs   MONTANT_TTCs   FICHIER_LOGOs   FICHIER_PIEDs   RAISONs   ACCROCHEs   MON_ADRESSEs   MON_CPs   MA_VILLEs   MON_TELs   MON_FAXs   MON_MAILs   SIRETs   UE_TVAs   FAC_DESCRIPTIONs   CLIENT_UETVAc         C   s   t  i |  | | | | ƒ d  S(   N(   s   genpdfs   __init__s   selfs   uids   with_headers   verboses   filedir(   s   selfs   uids   with_headers   verboses   filedir(    (    s   genfacture.pys   __init__(   s    c         C   sU  d |  i } |  i i | ƒ |  i i d j o |  i | 7_ | GHd ‚ n`|  i i ƒ  } | d d j o
 d } nM | d d j o d	 | d } n* | d d j o d	 | d } n d
 } |  i
 | | d ƒ \ } } |  i | | ƒ \ } } } } | d d j  o d |  i d <n d |  i d <| d o  |  i d | d |  i d <n | d o  |  i d | d |  i d <n | d |  i d <| d |  i d <| d |  i d <| d |  i d <| d |  i d <| d |  i d  <| d! |  i d" <| d# o d$ | d# |  i d% <n | d& o d' | d& |  i d( <n | d) |  i d* <| d+ |  i d, <| d- o" d. | d- i d/ ƒ |  i d0 <n | d1 o" d. | d1 i d/ ƒ |  i d2 <n | d o% d3 t | d ƒ | f |  i d4 <n | d5 o% d3 t | d5 ƒ | f |  i d6 <n | d5 o | d o- d3 t | d5 | d ƒ | f |  i d7 <n | d8 |  i d9 <| d: |  i d; <| d< |  i d= <| d> |  i d? <| d@ |  i dA <| dB o | dB |  i dC <n | dD |  i dC <| dE o dF | dE |  i dG <n dH t | | | ƒ | f |  i dI <| d j o' |  i dI c dJ t | ƒ | f 7<n | d j o' |  i dI c dK t | ƒ | f 7<n d3 t | | | ƒ | f |  i dL <d3 t | | | ƒ | | | | f |  i dM <d }
 } | d t | | | ƒ } xø t i i ƒ  D]ç }	 |
 dN |	 t t i |	 t |	 ƒ dO ƒ f 7}
 t i i dP |	 t t i |	 t |	 ƒ dO ƒ f ƒ | dQ j op | dR |	 t t i |	 t |	 ƒ | dO ƒ f 7} t i i dS |	 t t i |	 t |	 ƒ | dO ƒ f ƒ q$q$W|
 |  i dT <| |  i dU <| dV j oj dW | dO t |  i d4 ƒ f |  i dX <|  i dX c |  i dU 7<|  i dX c dY t |  i d6 ƒ 7<n d |  i dX <dZ |  i } |  i i | ƒ |  i i d j o |  i | 7_ | GHd ‚ nW |  i i ƒ  } | d[ t  j o d\ | |  i d] <n" d3 t | d[ ƒ | f |  i d] <d  S(^   Ns¾  
SELECT f.id, f.date_echeance, f.date_emission, f.montant_ht, f.montant_ttc, f.description AS fac_desc, d.intitule, d.id AS id_devis, devise.nom AS devise, devise.symbole , s.nom AS client, s.adresse1, s.cp, s.ville, s.ue_tva as cli_ue_tva, ms.logo, ms.pied_page, ms.raison, ms.adresse1 as mon_adresse, ms.cp as mon_cp,ms.ville as ma_ville,'TEL : '||ms.tel as mon_tel,'FAX : '||ms.fax as mon_fax,'EMAIL : '||ms.email as mon_mail,ms.siret,ms.ue_tva,ms.commentaire AS accroche
FROM devis d
INNER JOIN facture f ON (f.uid=%s AND f.ref_devis=d.uid)
LEFT JOIN devise ON (d.ref_devise=devise.uid)
LEFT JOIN view_mes_societes ms ON (d.ref_view_mes_societes=ms.uid),
view_client s
WHERE d.ref_view_client=s.uidi   s   ERRORs   devises   Euros    \euros   symboles    s    s    ?s
   montant_hti    s   NOTE DE CREDITs   TYPE_FACTUREs   FACTUREs   logos   /s   FICHIER_LOGOs	   pied_pages   FICHIER_PIEDs   mon_adresses   MON_ADRESSEs   mon_cps   MON_CPs   ma_villes   MA_VILLEs   mon_tels   MON_TELs   mon_faxs   MON_FAXs   mon_mails   MON_MAILs   raisons   RAISONs   sirets   RCS: s   SIRETs   ue_tvas   TVA-IN. s   UE_TVAs   accroches   ACCROCHEs   ids   NUM_FACTUREs   date_emissions   %ss   %d %B %Ys   DATE_EMISSIONs   date_echeances   DATE_ECHEANCEs   %.2f%ss
   MONTANT_HTs   montant_ttcs   MONTANT_TTCs   TVAs   clients   CLIENTs   cps	   CP_CLIENTs   adresse1s   ADRESSE_CLIENTs   villes   VILLE_CLIENTs
   cli_ue_tvas   CLIENT_UETVAs   intitules   DEVIS_INTITULEs   id_deviss   fac_descsh   \begin{large}
{\bf \noindent Description}\end{large}\\
\vspace{-0.3cm}\hline
\vspace{0.3cm}
\noindent %ss   FAC_DESCRIPTIONs   Facture Globale HT & %.2f%s\\
s	   GLOBAL_HTs   Dont Escompte & %.2f%s\\s   Dont Charge Add. & %.2f%s\\s
   GLOBAL_TTCs	   TOTAL_TVAs    Total TVA à %s%% & %.2f \euro\\
id   s   Total tva à %s%% : %s
f0.001s   TVA à %s%% & %.2f \euro\\
s   tva à %s%% : %s
s
   DETAIL_TVAs   DETAIL_TVA_RATIOf0.995s&   \hline
Accompte de %.1f%% (HT) & %s\\
s   ACCOMPTEs.   {\bf Montant TTC à payer} & {\bf %s}\\
\hline
sþ   SELECT sum(rf.montant) AS montant FROM reglement r, reglement_facture rf, statut st, facture f WHERE rf.ref_reglement=r.uid AND r.ref_statut=st.uid AND f.ref_statut=st.uid AND rf.ref_statut=st.uid AND st.nom='valide' AND rf.ref_facture=f.uid AND f.uid=%ss   montants   0s   REGLE(!   s   selfs   UIDs   reqs   curss   executes   rowcounts
   DEBUG_INFOs   dictfetchones   ress   devises   get_articles_prestass   total_hts	   total_ttcs   get_charges_remisess	   remise_hts	   charge_hts
   remise_ttcs
   charge_ttcs   tokenss   FILEDIRs   strftimes
   euro_rounds   txts	   txt_ratios   floats   ratios   add_tvas   tauxs   keyss   syss   stderrs   writes   None(   s   selfs
   charge_ttcs	   total_ttcs   devises   ress   reqs
   remise_ttcs   total_hts   ratios   tauxs   txts	   remise_hts	   charge_hts	   txt_ratio(    (    s   genfacture.pys   getinfo_facture+   s²    	

  ""%%-%''%1
 /53A((
c   
   	   C   s"  d |  i } d }	 d } d } d } |  i i | ƒ |  i i	 d j o nÃd } d |  i d <x™t |  i i	 ƒ D]…} |  i i ƒ  } | d d j o• t | d | d ƒ |  i d c d	 | d
 d t | d ƒ 7<| d d j  o" |	 | d 7}	 | | d 7} q÷| | d 7} | | d 7} qr t | d ƒ |  i d c d	 | d
 d t | d ƒ 7<| d d j  oB |	 | |	 | | d d 7}	 | | | | | d d 7} qr | | |	 | | d d 7} | | | | | d d 7} qr W|  i d c d 7<|	 | | | f Sd S(   s@   Get info from table "charge_additionnelle" for facture and devissÖ   SELECT ca.nom, ca.montant_ttc, ca.montant_ht, ca.absolu
		FROM charge_additionnelle ca, statut s, facture f
		WHERE ca.ref_statut=s.uid AND s.nom='valide' AND ca.ref_devis=f.ref_devis AND f.uid=%s
		ORDER BY ca.uidi    s@   
			\vspace*{0.5cm}
			{\bf \noindent Nota :}
			\begin{itemize}s   CHARGE_COMMENTAIREs   absolui   s
   montant_hts   montant_ttcs   \item s   noms    (%.2f HT) 
s    (%.2f\%%) 
f100.0s   \end{itemize}
N(   s   selfs   UIDs   reqs   calcul_remise_hts   calcul_charge_hts   calcul_remise_ttcs   calcul_charge_ttcs   curss   executes   rowcounts   is   tokenss   ranges   dictfetchones   ress   add_tvas
   euro_rounds   total_hts	   total_ttc(
   s   selfs   total_hts	   total_ttcs   calcul_charge_hts   is   reqs   calcul_charge_ttcs   ress   calcul_remise_ttcs   calcul_remise_ht(    (    s   genfacture.pys   get_charges_remises£   s>      --#"(   s   __name__s
   __module__s   query_articles   query_prestas   tokenss   __init__s   getinfo_factures   get_charges_remises(    (    (    s   genfacture.pys
   genfacture   s   ÿ x		xc          C   s£  t  ƒ  } | d d } | d d j o d | d <n t | d ƒ } | o t t  i ƒ n y˜ t i d | d d ƒ t	 | d	 | d
 | d | d ƒ }  |  i | d | d | d | d | d ƒ |  i ƒ  |  i | d | d | d ƒ WnM d j
 oA t | d d d ƒ t | d d |  i ƒ t i d ƒ n Xt | d ƒ o t i | d ƒ n |  i | ƒ | d o |  i | d | ƒ GHn d  S(   Ns   OUTDIRs   /factures   TEMPLATEs    s   template_facture.texs   DATABASEs   rm -f s   /pimengest2_debugs   UIDs   WITH_ENTETEs   VERBOSEs   FILEDIRs   bases   users   passs   hosts   ports   AFFICHAGE_TABs   LATEXDIRs   ERRORsZ   
---
Certainly not enougth information to generate the "facture". This is the query :
---
i   s   WITH_PDF(   s   get_optionss   optionss   OUTFILEs   extract_bases   bases   usages   __doc__s   oss   systems
   genfactures   objects   getConnections   getinfo_factures   replace_valuess   logs
   DEBUG_INFOs   syss   exits   check_outputs   makedirss   savetexfiles   toPDF(   s   objects   OUTFILEs   bases   options(    (    s   genfacture.pys   mainÓ   s,    	%-
#s   __main__N(   s   __doc__s   genpdfs
   genfactures   mains   __name__(   s
   genfactures   main(    (    s   genfacture.pys   ?   s
   º	
