;ò
ÿ/Bc           @   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	   genlettrec           B   s§   t  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 <Z d „  Z d „  Z RS(   Ns   ENTETEs   %# entete_from_genpdfs   DESTINATAIREs    s   SOCIETEs   ADRESSE_SOCIETEs   ~s
   CP_SOCIETEs   VILLE_SOCIETEs   OBJETs   CIVILITEs   CONTENUs   FORMULEs
   EXPEDITEURs   FICHIER_LOGOs   FICHIER_PIEDs   UE_TVAs   SIRETc         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   genlettre.pys   __init__   s    c         C   s(  d |  i } |  i i | ƒ |  i i d j o |  i | 7_ | GHd ‚ n×|  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 o d | d |  i
 d <n | d o 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/ o | d/ |  i
 d0 <n | d1 o |  i
 d0 c d2 | d1 7<n | d3 o | d3 |  i
 d4 <n | d5 o |  i
 d4 c d2 | d5 7<n | d6 o |  i
 d4 c d7 | d6 7<n |  i
 d0 d8 j o |  i
 d  t j od9 |  i } |  i i | ƒ |  i i d j o¥ d: |  i } |  i i | ƒ |  i i d j o |  i | 7_ | GHd ‚ q|  i i ƒ  } | d |  i
 d  <| d! |  i
 d" <| d# |  i
 d$ <| d% |  i
 d& <q|  i i ƒ  } | d! |  i
 d" <| d# |  i
 d$ <| d% |  i
 d& <n |  i
 d4 d8 j o |  i
 d
 t j o² d; |  i } |  i i | ƒ |  i i d j o |  i | 7_ | GHd ‚ qæ|  i i ƒ  } | d! o$ |  i
 d4 d< | d! |  i
 d
 <n | d# |  i
 d <| d% |  i
 d <n x; |  i
 i ƒ  D]* \ } } | t j o d= |  i
 | <qöqöWd  S(>   NsD  
SELECT l.objet, fm.nom AS formule, cv.nom AS civilite, l.contenu, l.date_expedition,
       s.nom AS societe, s.cp, s.adresse1, s.ville,
	   pp.nom, pp.prenom, py.nom AS nom_expediteur, py.prenom AS prenom_expediteur,
	   ms.nom AS ma_societe, 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
FROM lettre l
LEFT JOIN personne_physique py ON (py.uid=l.ref_expe_personne_physique)
LEFT JOIN societe ms ON (l.ref_view_mes_societes=ms.uid)
LEFT JOIN formule fm ON (fm.uid=l.ref_formule)
LEFT JOIN civilite cv ON (cv.uid=l.ref_civilite)
LEFT JOIN personne_physique pp ON (pp.uid=l.ref_desti_personne_physique)
LEFT JOIN societe s ON (s.uid=l.ref_societe)
WHERE l.uid=%si   s   ERRORs   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   commentaires   ACCROCHEs   raisons   RAISONs   sirets   RCS: s   SIRETs   ue_tvas   TVA-IN. s   UE_TVAs   societes   SOCIETEs   adresse1s   ADRESSE_SOCIETEs   cps
   CP_SOCIETEs   villes   VILLE_SOCIETEs   objets   OBJETs   civilites   CIVILITEs   contenus   CONTENUs   formules   FORMULEs   prenoms   DESTINATAIREs   noms    s   prenom_expediteurs
   EXPEDITEURs   nom_expediteurs
   ma_societes    pour s    s   SELECT pp.adresse1, pp.cp, pp.ville FROM personne_physique pp, lettre l WHERE pp.uid=l.ref_desti_personne_physique AND l.uid=%ssæ   SELECT s.nom AS societe, s.cp, s.adresse1, s.ville FROM personne_physique pp, travail_pour tp, lettre l, societe s WHERE tp.ref_societe=s.uid AND tp.ref_personne_physique=pp.uid AND pp.uid=l.ref_expe_personne_physique AND l.uid=%ss~   SELECT pp.adresse1, pp.cp, pp.ville FROM personne_physique pp, lettre l WHERE pp.uid=l.ref_expe_personne_physique AND l.uid=%ss    - s   ~(   s   selfs   UIDs   reqs   curss   executes   rowcounts
   DEBUG_INFOs   dictfetchones   ress   FILEDIRs   tokenss   Nones   itemss   tokens   value(   s   selfs   ress   reqs   values   token(    (    s   genlettre.pys   getinfo_lettre    s˜    
  (
(
$ (   s   __name__s
   __module__s   tokenss   __init__s   getinfo_lettre(    (    (    s   genlettre.pys	   genlettre   s   	c          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   /lettres   TEMPLATEs    s   template_lettre.texs   DATABASEs   rm -f s   /pimengest2_debugs   UIDs   WITH_ENTETEs   VERBOSEs   FILEDIRs   bases   users   passs   hosts   porti    s   LATEXDIRs   ERRORsX   
---
Certainly not enougth infomation to generate the "lettre". This is the query :
---
iÿÿÿÿs   WITH_PDF(   s   get_optionss   optionss   OUTFILEs   extract_bases   bases   usages   __doc__s   oss   systems	   genlettres   objects   getConnections   getinfo_lettres   replace_valuess   logs
   DEBUG_INFOs   syss   exits   check_outputs   makedirss   savetexfiles   toPDF(   s   objects   OUTFILEs   bases   options(    (    s   genlettre.pys   main„   s,    	%-
s   __main__N(   s   __doc__s   genpdfs	   genlettres   mains   __name__(   s	   genlettres   main(    (    s   genlettre.pys   ?   s
   k	
