;ò
“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)

   This program 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.

   This library 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   gendevisc           B   sy  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 <Z d+ „  Z d, „  Z d- „  Z RS(.   NsG  
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, devis d, tva, statut st
WHERE d.uid=%s 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, statut st
WHERE d.uid=%s AND cp.ref_devis=d.uid AND cp.ref_statut=st.uid AND st.nom='valide'
ORDER BY cp.uids   ENTETEs   %# entete_from_genpdfs   INTITULEs   ~s   CLIENTs   ADRESSE_CLIENTs	   CP_CLIENTs   VILLE_CLIENTs	   NUM_DEVISs   DESCRIPTIONs   DESCRIPTION_PRESTATIONs   ARTICLESs   PRESTASs   PAIEMENTs   PERIODEs   ESCOMPTEs	   TOTAL_TVAs
   DETAIL_TVAs   CHARGEs   0s   COMMENTAIREs   CHARGE_COMMENTAIREs   %# commentaire_from_genpdfs	   GLOBAL_HTs
   GLOBAL_TTCs   DATE_ACCEPTATIONs   DATE_EMISSIONs   FICHIER_LOGOs   FICHIER_PIEDs   RAISONs   ACCROCHEs   MON_ADRESSEs   MON_CPs   MA_VILLEs   MON_TELs   MON_FAXs   MON_MAILs   SIRETs   UE_TVAs   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   gendevis.pys   __init__)   s    c         C   sS  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
 | ƒ \ } } |  i | | ƒ \ }
 } } } | 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 |  i d <| d  |  i d! <| d" |  i d# <| d$ |  i d% <| d& o | d& i d' ƒ |  i d( <n | d) o | d) i d' ƒ |  i d* <n | d+ |  i d, <| d- |  i d. <| d/ |  i d0 <| d1 |  i d2 <| d3 o! | d3 i d4 d5 ƒ |  i d6 <n | d7 |  i d8 <d9 t | |
 | ƒ | f |  i d: <|
 d; j o' |  i d: c d< t |
 ƒ | f 7<n | d; j o' |  i d: c d= t | ƒ | f 7<n d> t | | | ƒ | f |  i d? <d> t | | | | |
 | ƒ | f |  i d@ <d }	 x{ t i i ƒ  D]j } |	 dA | t t i | t | ƒ dB ƒ f 7}	 t i i dC | t t i | t | ƒ dB ƒ f ƒ qÔW|	 |  i dD <d  S(E   NsA  
SELECT d.id, d.commentaire, d.intitule, devise.nom AS devise, devise.symbole, d.date_accepte, d.date_emission, s.nom AS client, s.adresse1, s.cp, s.ville, s.logo, 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
LEFT JOIN view_mes_societes ms ON (d.ref_view_mes_societes=ms.uid)
LEFT JOIN devise ON (d.ref_devise=devise.uid),
view_client s
WHERE d.uid=%s AND d.ref_view_client=s.uidi   s   ERRORs   devises   Euros    \euros   symboles    s    s    ?s   logos   /s   FICHIER_LOGOs	   pied_pages   FICHIER_PIEDs   raisons   RAISONs   mon_adresses   MON_ADRESSEs   mon_cps   MON_CPs   ma_villes   MA_VILLEs   mon_tels   MON_TELs   mon_faxs   MON_FAXs   mon_mails   MON_MAILs   sirets   SIRETs   ue_tvas   UE_TVAs   accroches   ACCROCHEs   ids	   NUM_DEVISs   date_acceptes   %d %B %Ys   DATE_ACCEPTATIONs   date_emissions   DATE_EMISSIONs   clients   CLIENTs   cps	   CP_CLIENTs   adresse1s   ADRESSE_CLIENTs   villes   VILLE_CLIENTs   intitules   &s   \&s   INTITULEs   commentaires   COMMENTAIREs   Montant total HT & %.2f%s\\
s	   GLOBAL_HTi    s   Dont Escompte & %.2f%s\\s   Dont Charge Add. & %.2f%s\\s   %.2f%ss
   GLOBAL_TTCs	   TOTAL_TVAs    Total TVA à %s%% & %.2f \euro\\
id   s   Total tva à %s%% : %s
s
   DETAIL_TVA(   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   FILEDIRs   tokenss   strftimes   replaces
   euro_rounds   txts   add_tvas   tauxs   keyss   floats   syss   stderrs   write(   s   selfs
   charge_ttcs	   total_ttcs   devises   ress   reqs
   remise_ttcs   total_hts   tauxs   txts	   remise_hts	   charge_ht(    (    s   gendevis.pys   getinfo_devis,   sn    

  !%''%1 /9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³ | d | d d	 | d }	 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
		WHERE ca.ref_statut=s.uid AND s.nom='valide' AND ca.ref_devis=%s
		ORDER BY ca.uidi    s@   
			\vspace*{0.5cm}
			{\bf \noindent Nota :}
			\begin{itemize}s   CHARGE_COMMENTAIREs   absolui   s   montant_ttcs
   montant_htid   s   \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   tauxs   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   tauxs   calcul_remise_ht(    (    s   gendevis.pys   get_charges_remisesv   s@      --#"(   s   __name__s
   __module__s   query_articles   query_prestas   tokenss   __init__s   getinfo_deviss   get_charges_remises(    (    (    s   gendevis.pys   gendevis   s   ÿ K		Jc          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   /deviss   TEMPLATEs    s   template_devis.texs   DATABASEs   rm -f s   /pimengest2_debugs   UIDs   WITH_ENTETEs   VERBOSEs   FILEDIRs   bases   users   passs   hosts   ports   AFFICHAGE_TABs   LATEXDIRs   ERRORsX   
---
Certainly not enougth information to generate the "devis". This is the query :
---
iÿÿÿÿs   WITH_PDF(   s   get_optionss   optionss   OUTFILEs   extract_bases   bases   usages   __doc__s   oss   systems   gendeviss   objects   getConnections   getinfo_deviss   replace_valuess   logs
   DEBUG_INFOs   syss   exits   check_outputs   makedirss   savetexfiles   toPDF(   s   objects   OUTFILEs   bases   options(    (    s   gendevis.pys   main¦   s,    	%-
#s   __main__N(   s   __doc__s   genpdfs   gendeviss   mains   __name__(   s   mains   gendevis(    (    s   gendevis.pys   ?   s
   	
