Mon repertoire

Soyez le premier à donner votre avis sur cette source.

Vue 4 349 fois - Téléchargée 308 fois

Description

Salut
Encore pour mon initiation à wxpython j'ai réalisé cette aplli. Envoyer moi assez de commentaires.Merci

Source / Exemple :


# -*- coding: cp1252 -*-

#----------------------------------------------------------------------------
# Name:         MyAdresseBook.py
#
#
# Author:       Kouakou021988
#
# Created:      
# Licence:      GNU
#----------------------------------------------------------------------------

import os
import gadfly
import sys
import  wx
import  wx.lib.mixins.listctrl  as  listmix
import sha
import shutil
from wx.lib.wordwrap import wordwrap
import SimplePDF_Generateur

ID_CONNECT=100
ID_DECONNECT=101
ID_NEW=102
ID_PROPOS=103
ID_HELP=104
ID_SEARCH=105
ID_ENR=106
ID_IMP=107
ID_SUPP=108
ID_SELF=109

passe=0
refresh=0
user=""
cur=""
connection_ok=0
apercu=0
photo=""
photo_ok=0
recherche_ok=0

def takeId(fich):
        t=open(fich,'r')
        i=t.read()
        t.close()
        return i

def setId(fich,num):
        t=open(fich,'w')
        t.write(num)
        t.close()
        return 1

def codage(txt):
        p=sha.new(txt)
        return p.hexdigest()

def copie(num,path):
        ch,name=os.path.split(path)
        new=ch+"\%s.jpg"%num
        os.rename(path,new)
        shutil.copy2(new,"c:\\MyAddressBook\MyPhoto")
        os.rename(new,path)
        new="c:\\MyAddressBook\MyPhoto\%s.jpg"%num
        return new

def verif(name):
        global cur
        req="select * from UTILISATEUR where user='%s'"%name
        cur.execute(req)
        r=cur.fetchall()
        if len(r):      return 1
        else:   return 0

class Modif_contact(wx.Frame):
        def __init__(self,info):
                wx.Frame.__init__(self,None,title="::.MyAdressBook.::Modifier un contact",size=(300,250),style=wx.DEFAULT_FRAME_STYLE^(wx.RESIZE_BORDER
                                                                                                                         |wx.MAXIMIZE_BOX
                                                                                                                         |wx.MINIMIZE_BOX))
                frameicon = wx.Icon("./côte d'ivoire.ico", wx.BITMAP_TYPE_ICO)
                self.SetIcon(frameicon)
                self.panel = wx.Panel(self, -1)
                self.info=info
                self.builder()

        def builder(self):
                wx.StaticText(self.panel,-1,"Nom*: ",style=wx.ALIGN_LEFT,pos=(15,15))
                self.nom=wx.TextCtrl(self.panel,-1,self.info[1], size=(150,-1),pos=(100,10))
                wx.StaticText(self.panel,-1,"Prenoms*: ",style=wx.ALIGN_LEFT,pos=(15,50))
                self.prenom=wx.TextCtrl(self.panel,-1,self.info[2],size=(150,-1),pos=(100,45))
                wx.StaticText(self.panel,-1,"Contact I: ",style=wx.ALIGN_LEFT,pos=(15,85))
                self.contact1=wx.TextCtrl(self.panel,-1,self.info[3],size=(150,-1),pos=(100,80))
                wx.StaticText(self.panel,-1,"Contact II: ",style=wx.ALIGN_LEFT,pos=(15,120))
                self.contact2=wx.TextCtrl(self.panel,-1,self.info[4],size=(150,-1),pos=(100,115))
                wx.StaticText(self.panel,-1,"Email: ",style=wx.ALIGN_LEFT,pos=(15,155))
                self.email=wx.TextCtrl(self.panel,-1,self.info[5],size=(150,-1),pos=(100,150))
                b_Ok=wx.Button(self.panel,-1,"OK",pos=(60,180),size=(80,25))
                b_Annuler=wx.Button(self.panel,-1,"Annuler",pos=(150,180),size=(100,25))
                self.Bind(wx.EVT_BUTTON,self.close,b_Annuler)
                self.Bind(wx.EVT_BUTTON,self.modif_contact,b_Ok)
                self.Bind(wx.EVT_CLOSE,self.close)
                
        def modif_contact(self,event):
                global user,cur,refresh,connection_ok
                if self.nom.GetValue().strip()=="" or self.prenom.GetValue().strip()=="":
                        dlg=wx.MessageDialog(self, "Veuillez remplir les champs marqués par '*'.Merci",
                                                caption="::.MyAdressBook.::Modifier un contact",style=wx.OK|wx.ICON_ERROR,pos=wx.DefaultPosition)
                        result=dlg.ShowModal()
                        dlg.Destroy()
                else:
                        i=self.info[0]
                        req="""update contact set nom='%s',prenoms='%s',contact1='%s',contact2='%s',email='%s' where id='%s' and user='%s'"""%(self.nom.GetValue().strip().capitalize(),self.prenom.GetValue().strip().capitalize(),
                                                    self.contact1.GetValue().strip(),self.contact2.GetValue().strip(),self.email.GetValue().strip(),i, user)
                        
                        rep=self.verification([self.nom.GetValue().strip().capitalize(),self.prenom.GetValue().strip().capitalize(),user,self.contact1.GetValue().strip(),self.contact2.GetValue().strip(),self.email.GetValue().strip()])
                        if rep:
                                dlg=wx.MessageDialog(self, "Ce Contact existe déja.Merci",
                                                caption="::.MyAdressBook.::Modifier un contact",style=wx.OK|wx.ICON_ERROR,pos=wx.DefaultPosition)
                                result=dlg.ShowModal()
                                dlg.Destroy()
                        else:
                                cur.execute(req)
                                refresh=1
                                connection_ok=1
                                self.close(None)
                        
        def verification(self,l):
                global cur
                req="select id from contact where nom='%s' and prenoms='%s'and user='%s'and contact1='%s'and contact2='%s'and email='%s'"%(l[0],l[1],l[2],l[3],l[4],l[5])
                cur.execute(req)
                r=cur.fetchall()
                if len(r):      return 1
                else:   return 0
                
        def close(self,event):
                self.MakeModal(False)
                self.Destroy()
                
class Apercu(wx.Frame):
    def __init__(self,info):
        wx.Frame.__init__(self,None,-1,title="::.MyAdressBook.::Kouakou021988-Apercu",
                                      size=(400,250),style=wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER|wx.MAXIMIZE_BOX|wx.MINIMIZE_BOX))
        frameicon = wx.Icon("./côte d'ivoire.ico", wx.BITMAP_TYPE_ICO)
        self.SetIcon(frameicon)
        self.CenterOnParent(wx.BOTH)
        self.SetBackgroundColour("black")
        self.panel=wx.Panel(self,-1,size=self.GetClientSize())
        self.sizer = wx.FlexGridSizer(rows=0, cols=2, hgap=1, vgap=1)
        self.build()
        self.info=info
        self.note()

    def build(self):
        self.panelA=wx.Panel(self.panel,-1)
        self.panelA.SetBackgroundColour("black")
        self.sizer.Add(self.panelA, 0, 0)
        lui=self.FindWindowById(self.panelA.GetId())
        lui.SetMinSize((280,250))
        self.panelB=wx.Panel(self.panel,-1)
        self.panelB.SetBackgroundColour("black")
        self.sizer.Add(self.panelB, 0, 1)
        tof=self.FindWindowById(self.panelB.GetId())
        tof.SetMinSize((120,100))
        self.SetSizer(self.sizer)

    def note(self):
        font = wx.Font(10, wx.ROMAN,wx.ITALIC, wx.NORMAL)
        nom=wx.StaticText(self.panelA,-1,"Nom: ",style=wx.ALIGN_LEFT,pos=(15,15))
        prenoms=wx.StaticText(self.panelA,-1,"Prenoms: ",style=wx.ALIGN_LEFT,pos=(15,45))
        contact1=wx.StaticText(self.panelA,-1,"Contact I: ",style=wx.ALIGN_LEFT,pos=(15,75))
        contact2=wx.StaticText(self.panelA,-1,"Contact II: ",style=wx.ALIGN_LEFT,pos=(15,110))
        email=wx.StaticText(self.panelA,-1,"Email: ",style=wx.ALIGN_LEFT,pos=(15,145))
        sexe=wx.StaticText(self.panelA,-1,"Sexe: ",style=wx.ALIGN_LEFT,pos=(15,180))
        for i in [nom,prenoms,contact1,contact2,email,sexe]:
                i.SetFont(font)
                i.SetForegroundColour('white')
        self.remplir()

    def remplir(self):
        global cur
        req="select photo_path,sexe from contact where id='%s'"%self.info[0]
        cur.execute(req)
        rep=cur.fetchall()[0]
        sexe=rep[1]
        photo_path=rep[0]
        font = wx.Font(12, wx.ROMAN, wx.NORMAL,wx.NORMAL)
        nom=wx.StaticText(self.panelA,-1,self.info[1],style=wx.ALIGN_LEFT,pos=(105,15))
        prenoms=wx.StaticText(self.panelA,-1,self.info[2],style=wx.ALIGN_LEFT,pos=(105,45))
        contact1=wx.StaticText(self.panelA,-1,self.info[3],style=wx.ALIGN_LEFT,pos=(105,75))
        contact2=wx.StaticText(self.panelA,-1,self.info[4],style=wx.ALIGN_LEFT,pos=(105,110))
        email=wx.StaticText(self.panelA,-1,self.info[5],style=wx.ALIGN_LEFT,pos=(105,145))
        sexe=wx.StaticText(self.panelA,-1,sexe,style=wx.ALIGN_LEFT,pos=(105,180))
        for i in [nom,prenoms,contact1,contact2,email,sexe]:
                i.SetFont(font)
                i.SetForegroundColour('white')
        self.photo(photo_path)

    def photo(self,path):
        if os.path.exists(path):
                jpg = wx.Image(path, wx.BITMAP_TYPE_ANY)
                tof=jpg.Scale(120,100)
                wx.StaticBitmap(self.panelB, -1, wx.BitmapFromImage(tof))
                self.panelB.Refresh()
      
class DataBase:
        def __init__(self):
                i=self.existence()
                if i:   self.creation()

        def existence(self):
                for i in ["c:\\MyAddressBook","c:\\MyAddressBook\MyAddressBook.gfd","c:\\MyAddressBook\UTILISATEUR.grl",
                          "c:\\MyAddressBook\CONTACT.grl","c:\\MyAddressBook\MyPhoto"]:
                                if not os.path.exists(i):
                                        return 1

        def creation(self):
                self.destructeur()
                os.mkdir("c:\\MyAddressBook")
                os.mkdir("c:\\MyAddressBook\MyPhoto")
                base=gadfly.gadfly()
                base.startup("MyAddressBook","c:\\MyAddressBook")
                cur=base.cursor()
                cur.execute("create table Utilisateur (user varchar,password varchar)")
                cur.execute("create table Contact (id varchar,nom varchar,prenoms varchar,contact1 varchar,contact2 varchar,\
                                email varchar,sexe varchar,photo_path varchar,user varchar)")
                base.commit()
                cur.close()
                base.close()

        def destructeur(self):
                if sys.platform=="win32":
                                s="c:\\MyAddressBook"
                                cmd="rmdir %s /S/Q"%s
                                a=os.popen(cmd)
                else:
                                import glob
                                d=glob.glob("c:\\MyAddressBook\*.*")
                                for i in d:
                                                os.unlink(i)
                                d=glob.glob("c:\\MyAddressBook\MyPhoto\*.*")
                                for i in d:
                                                os.unlink(i)
                                os.rmdir("c:\\MyAddressBook\MyPhoto")
                                os.rmdir("c:\\MyAddressBook")

        def dbConnection(self):
                global cur
                self.base=gadfly.gadfly("MyAddressBook","c:\\MyAddressBook")
                cur=self.base.cursor()
                self.id_saisie()

        def id_saisie(self):
                global cur
                path=open("c:\\MyAddressBook\id.txt",'w')
                cur.execute("select id from CONTACT")
                r=cur.fetchall()
                if len(r)==0:
                        path.write(str(1))
                        path.close()
                else:
                        path.write(str(int(max(r)[0])+1))
                        path.close()

        def enr(self):
                self.base.commit()

        def fermer(self):
                global cur
                cur.close()
                self.base.close()
                
        
class Recherche(wx.Frame):
        def __init__(self):
                wx.Frame.__init__(self,None,title="::.MyAdressBook.::Rechercher un contact",size=(350,150),style=wx.DEFAULT_FRAME_STYLE^(wx.RESIZE_BORDER
                                                                                                                         |wx.MAXIMIZE_BOX
                                                                                                                         |wx.MINIMIZE_BOX))
                frameicon = wx.Icon("./côte d'ivoire.ico", wx.BITMAP_TYPE_ICO)
                self.SetIcon(frameicon)
                self.panel = wx.Panel(self, -1)
                self.option=""
                self.builder()

        def builder(self):
                wx.StaticText(self.panel,-1,"Recherche: ",style=wx.ALIGN_LEFT,pos=(15,15))
                self.recherche=wx.TextCtrl(self.panel,-1,"", size=(200,-1),pos=(100,10))
                nom= wx.RadioButton(self.panel, -1, " Nom", style =0,pos=(15,50))
                prenoms= wx.RadioButton(self.panel, -1, " Prenoms ",pos=(65,50))
                contact1 = wx.RadioButton(self.panel, -1, " Contact I ",pos=(135,50))
                contact2 = wx.RadioButton(self.panel, -1, " Contact II " ,pos=(205,50))
                email = wx.RadioButton(self.panel, -1, " Email ",pos=(280,50))
                b_Ok=wx.Button(self.panel,-1,"OK",pos=(80,80),size=(80,25))
                b_Annuler=wx.Button(self.panel,-1,"Annuler",pos=(170,80),size=(100,25))
                for eachRadio in [nom,prenoms,contact1,contact2,email]:      
                        self.Bind(wx.EVT_RADIOBUTTON, self.myOption, eachRadio)
                self.Bind(wx.EVT_BUTTON,self.close,b_Annuler)
                self.Bind(wx.EVT_BUTTON,self.new_recherche,b_Ok)
                self.Bind(wx.EVT_CLOSE,self.close)

        def myOption(self,event):
                button=event.GetEventObject()
                self.option=button.GetLabel()
                
        def new_recherche(self,event):
                global cur,user,recherche_ok,connection_ok
                dico={" Nom":"nom"," Prenoms ":"prenoms"," Contact I ":"contact1"," Contact II ":"contact2"," Email ":"email"}
                if not self.option:
                        dlg=wx.MessageDialog(self, "Veuillez utiliser une option.Merci",
                                                caption="::.MyAdressBook.::Rechercher un contact",style=wx.OK|wx.ICON_ERROR,pos=wx.DefaultPosition)
                        result=dlg.ShowModal()
                        dlg.Destroy()
                else:
                        option=dico[self.option]
                        req="select id from contact where %s='%s' and user='%s'"%(option,self.recherche.GetValue().strip().capitalize(),user)
                        cur.execute(req)
                        recherche_ok=1
                        self.close(None)
        
        def close(self,event):
                self.MakeModal(False)
                self.Destroy()

class New_contact(wx.Frame):
        def __init__(self):
                wx.Frame.__init__(self,None,title="::.MyAdressBook.::Enregistrer un contact",size=(300,320),style=wx.DEFAULT_FRAME_STYLE^(wx.RESIZE_BORDER
                                                                                                                         |wx.MAXIMIZE_BOX
                                                                                                                         |wx.MINIMIZE_BOX))
                frameicon = wx.Icon("./côte d'ivoire.ico", wx.BITMAP_TYPE_ICO)
                self.SetIcon(frameicon)
                self.panel = wx.Panel(self, -1)
                self.builder()
                self.sexe=""
                

        def builder(self):
                wx.StaticText(self.panel,-1,"Nom*: ",style=wx.ALIGN_LEFT,pos=(15,15))
                self.nom=wx.TextCtrl(self.panel,-1,"", size=(150,-1),pos=(100,10))
                wx.StaticText(self.panel,-1,"Prenoms*: ",style=wx.ALIGN_LEFT,pos=(15,50))
                self.prenom=wx.TextCtrl(self.panel,-1,"",size=(150,-1),pos=(100,45))
                wx.StaticText(self.panel,-1,"Contact I: ",style=wx.ALIGN_LEFT,pos=(15,85))
                self.contact1=wx.TextCtrl(self.panel,-1,"",size=(150,-1),pos=(100,80))
                wx.StaticText(self.panel,-1,"Contact II: ",style=wx.ALIGN_LEFT,pos=(15,120))
                self.contact2=wx.TextCtrl(self.panel,-1,"",size=(150,-1),pos=(100,115))
                wx.StaticText(self.panel,-1,"Email: ",style=wx.ALIGN_LEFT,pos=(15,155))
                self.email=wx.TextCtrl(self.panel,-1,"",size=(150,-1),pos=(100,150))
                wx.StaticText(self.panel,-1,"Photo: ",style=wx.ALIGN_LEFT,pos=(15,190))
                self.photo_path=wx.TextCtrl(self.panel,-1,"",size=(150,-1),pos=(100,185))
                b_photo=wx.Button(self.panel,-1,"...",pos=(250,183),size=(25,25))
                wx.StaticText(self.panel,-1,"Sexe*: ",style=wx.ALIGN_LEFT,pos=(15,220))
                radio_f=wx.RadioButton(self.panel,-1,"Feminin",style=0,pos=(100,220))
                radio_m=wx.RadioButton(self.panel,-1,"Masculin",pos=(180,220))
                b_Ok=wx.Button(self.panel,-1,"OK",pos=(60,250),size=(80,25))
                b_Annuler=wx.Button(self.panel,-1,"Annuler",pos=(150,250),size=(100,25))
                self.Bind(wx.EVT_BUTTON,self.path_photo,b_photo)
                self.Bind(wx.EVT_BUTTON,self.close,b_Annuler)
                self.Bind(wx.EVT_BUTTON,self.new_contact,b_Ok)
                self.Bind(wx.EVT_CLOSE,self.close)
                for eachRadio in [radio_f, radio_m]:      
                                self.Bind(wx.EVT_RADIOBUTTON, self.sexeChoix, eachRadio)

        def path_photo(self,event):
                wildcard = "Ma Photo (*.jpg)|*.jpg|"
                dialog = wx.FileDialog(None, "Photo", os.getcwd(),"", wildcard, wx.OPEN)
                if dialog.ShowModal() == wx.ID_OK:
                         self.photo_path.SetValue(dialog.GetPath())
                else:
                         self.photo_path=""
                dialog.Destroy()
                self.SetFocus()
        
        def sexeChoix(self,event):
                button=event.GetEventObject()
                self.sexe=button.GetLabel()

        def new_contact(self,event):
                global user,cur,refresh,connection_ok
                if self.sexe=="" or self.nom.GetValue().strip()=="" or self.prenom.GetValue().strip()=="":
                        dlg=wx.MessageDialog(self, "Veuillez remplir les champs marqués par '*'.Merci",
                                                caption="::.MyAdressBook.::Enregistrer un contact",style=wx.OK|wx.ICON_ERROR,pos=wx.DefaultPosition)
                        result=dlg.ShowModal()
                        dlg.Destroy()
                else:
                        i=takeId("c:\\MyAddressBook\id.txt")
                        if self.photo_path.GetValue()!="":
                            mytof=copie(i,self.photo_path.GetValue().strip())
                        else:   mytof=""
                        req="""insert into contact(id,nom,prenoms,contact1,contact2,email,sexe,photo_path,user)values\
                                ('%s','%s','%s','%s','%s','%s','%s','%s','%s')"""%(i, self.nom.GetValue().strip().capitalize(),self.prenom.GetValue().strip().capitalize(),
                                                                                   self.contact1.GetValue().strip(),self.contact2.GetValue().strip(),
                                                                                   self.email.GetValue().strip(),self.sexe,mytof,
                                                                                   user)
                        rep=self.verification([self.nom.GetValue().strip().capitalize(),self.prenom.GetValue().strip().capitalize(),self.sexe,user])
                        if rep:
                                dlg=wx.MessageDialog(self, "Ce Contact existe déja.Merci",
                                                caption="::.MyAdressBook.::Enregistrer un contact",style=wx.OK|wx.ICON_ERROR,pos=wx.DefaultPosition)
                                result=dlg.ShowModal()
                                dlg.Destroy()
                        else:
                                cur.execute(req)
                                setId("c:\\MyAddressBook\id.txt",str(int(i)+1))
                                refresh=1
                                connection_ok=1
                                self.close(None)
                        
        def verification(self,l):
                global cur,user
                req="select id from contact where nom='%s' and prenoms='%s' and sexe='%s' and user='%s'"%(l[0],l[1],l[2],l[3])
                cur.execute(req)
                r=cur.fetchall()
                if len(r):      return 1
                else:   return 0
                
        def close(self,event):
                self.MakeModal(False)
                self.Destroy()
                
class New_user(wx.Frame):
        def __init__(self):
                wx.Frame.__init__(self,None,title="::.MyAdressBook.::Nouvel Utilisateur",size=(300,200),style=wx.DEFAULT_FRAME_STYLE^(wx.RESIZE_BORDER
                                                                                                                         |wx.MAXIMIZE_BOX
                                                                                                                         |wx.MINIMIZE_BOX))
                frameicon = wx.Icon("./côte d'ivoire.ico", wx.BITMAP_TYPE_ICO)
                self.SetIcon(frameicon)
                self.panel = wx.Panel(self, -1)
                self.builder()

        def builder(self):
                wx.StaticText(self.panel,-1,"Utilisateur: ",style=wx.ALIGN_LEFT,pos=(15,15))
                self.user=wx.TextCtrl(self.panel,-1,"", size=(150,-1),pos=(140,10))
                wx.StaticText(self.panel,-1,"Mot de passe: ",style=wx.ALIGN_LEFT,pos=(15,50))
                self.passwd1=wx.TextCtrl(self.panel,-1,"",size=(150,-1),pos=(140,45),style=wx.TE_PASSWORD)
                wx.StaticText(self.panel,-1,"Repeter le mot de passe: ",style=wx.ALIGN_LEFT,pos=(15,85))
                self.passwd2=wx.TextCtrl(self.panel,-1,"",size=(150,-1),pos=(140,80),style=wx.TE_PASSWORD)
                b_Ok=wx.Button(self.panel,-1,"OK",pos=(60,130),size=(80,25))
                b_Annuler=wx.Button(self.panel,-1,"Annuler",pos=(150,130),size=(100,25))
                self.Bind(wx.EVT_BUTTON,self.close,b_Annuler)
                self.Bind(wx.EVT_BUTTON,self.new_connection,b_Ok)
                self.Bind(wx.EVT_CLOSE,self.close)

        def new_connection(self,event):
                global cur,refresh
                user=self.user.GetValue()
                pass1=self.passwd1.GetValue()
                pass2=self.passwd2.GetValue()
                if pass1==pass2 and not verif(user) and len(pass1)>5:
                                req="insert into UTILISATEUR(user,password) values ('%s','%s')"%(user,codage(str(pass1)))
                                cur.execute(req)
                                refresh=1
                                self.close(None)
                else:
                                dlg=wx.MessageDialog(self, "Verifier si vous avez entrer le même mot de passe dans les différents champs.\n"+
                                                        "Si le problème persiste changer de login et vérifier si la taille de votre passe est >=6.Merci",
                                                 caption="::.MyAdressBook.::Nouvel Utilisateur",style=wx.OK|wx.ICON_ERROR,pos=wx.DefaultPosition)
                                result=dlg.ShowModal()
                                dlg.Destroy()
                                self.user.Clear()
                                self.passwd1.Clear()
                                self.passwd2.Clear()
                        
        def close(self,event):
                self.MakeModal(False)
                self.Destroy()
                
class Connection(wx.Frame):
        def __init__(self):
                wx.Frame.__init__(self,None,title="::.MyAdressBook.::Connection",size=(300,150),style=wx.DEFAULT_FRAME_STYLE^(wx.RESIZE_BORDER
                                                                                                                         |wx.MAXIMIZE_BOX
                                                                                                                         |wx.MINIMIZE_BOX))
                frameicon = wx.Icon("./côte d'ivoire.ico", wx.BITMAP_TYPE_ICO)
                self.SetIcon(frameicon)
                self.panel = wx.Panel(self, -1)
                self.builder()
                
        def builder(self):
                wx.StaticText(self.panel,-1,"Login: ",style=wx.ALIGN_LEFT,pos=(15,15))
                self.user=wx.TextCtrl(self.panel,-1,"", size=(150,-1),pos=(100,10))
                wx.StaticText(self.panel,-1,"Mot de passe:",style=wx.ALIGN_LEFT,pos=(15,50))
                self.passwd=wx.TextCtrl(self.panel,-1,"",size=(150,-1),pos=(100,45),style=wx.TE_PASSWORD)
                b_Ok=wx.Button(self.panel,-1,"OK",pos=(60,80),size=(80,25))
                b_Annuler=wx.Button(self.panel,-1,"Annuler",pos=(150,80),size=(100,25))
                self.Bind(wx.EVT_BUTTON,self.close,b_Annuler)
                self.Bind(wx.EVT_BUTTON,self.connection,b_Ok)
                self.Bind(wx.EVT_CLOSE,self.close)
                
        def connection(self,event):
                global cur,user,connection_ok
                error=0
                u=self.user.GetValue()
                req="""select password from UTILISATEUR where user='%s'"""%u
                cur.execute(req)
                r=cur.fetchall()
                if len(r)==1:
                        passwd=r[0]
                        if codage(str(self.passwd.GetValue()))==passwd[0]:
                                connection_ok=1
                                user=u
                                self.close(None)
                        else:   error=1
                else:   error=1
                if error:
                        dlg=wx.MessageDialog(self, "Votre login ou votre mot de passe est incorrect",
                                                 caption="::.MyAdressBook.::Connection",style=wx.OK|wx.ICON_ERROR,pos=wx.DefaultPosition)
                        result=dlg.ShowModal()
                        dlg.Destroy()
                        self.user.Clear()
                        self.passwd.Clear()
                        self.user.SetFocus()
        
        def close(self,event):
                self.MakeModal(False)
                self.Destroy()
                
class AdressListCtrl(wx.ListCtrl, listmix.ListCtrlAutoWidthMixin):
        def __init__(self, parent, ID, pos=wx.DefaultPosition,
                 size=wx.DefaultSize, style=0):
                wx.ListCtrl.__init__(self, parent, ID, pos, size, style)
                listmix.ListCtrlAutoWidthMixin.__init__(self)

class ContenuPanel(wx.Panel,listmix.ColumnSorterMixin):
        def __init__(self, parent, log):
                wx.Panel.__init__(self, parent, -1,style=wx.WANTS_CHARS)
                self.log = log
                tID = wx.NewId()
                sizer = wx.BoxSizer(wx.VERTICAL)
                                         
                self.list=AdressListCtrl(self, tID,style=wx.LC_REPORT   | wx.BORDER_SUNKEN
                                                                        | wx.LC_SORT_ASCENDING
                                                                        | wx.LC_VRULES| wx.LC_HRULES)
                sizer.Add(self.list, 1, wx.EXPAND)
                self.remplissage()
                listmix.ColumnSorterMixin.__init__(self,7)
                self.SetSizer(sizer)
                self.SetAutoLayout(True)
                self.Bind(wx.EVT_LIST_COL_BEGIN_DRAG, self.bloqueColonne, self.list)
                self.list.Bind(wx.EVT_LIST_ITEM_RIGHT_CLICK, self.onClickDroit)
                self.list.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.double)
                self.Bind(wx.EVT_LIST_ITEM_SELECTED, self.photo, self.list)
                #self.Bind(wx.EVT_ClICK_DOWN,self.photo)

        def remplissage(self):
                self.list.InsertColumn(0, "Id")
                self.list.SetColumnWidth(0,0)                   #Cache de la colonne "id"
                self.list.InsertColumn(1, "photo_path")
                self.list.SetColumnWidth(1,0)  
                self.list.InsertColumn(2, "Nom")
                self.list.InsertColumn(3, "Prenoms")
                self.list.SetColumnWidth(3,110)
                self.list.InsertColumn(4, "Contact I (Fixe)")
                self.list.SetColumnWidth(4,100)
                self.list.InsertColumn(5, "Contact II (Cel)")
                self.list.SetColumnWidth(5,100)
                self.list.InsertColumn(6, "Email")
                self.list.SetColumnWidth(6,160)
                
        def GetListCtrl(self):
                return self.list

        def bloqueColonne(self, event):                       #bloque le redimensionnement de la colonne "id" et "phot_path"
                if event.GetColumn() == 0 or event.GetColumn() == 1:
                    event.Veto()

        def remplir(self,c):
                n=0
                self.itemDataMap=self.gotoDict(c)
                for i in c:
                    index = self.list.InsertStringItem(sys.maxint, i[0])
                    self.list.SetStringItem(index, 1, i[1])
                    self.list.SetStringItem(index, 2, i[2])
                    self.list.SetStringItem(index, 3, i[3])
                    self.list.SetStringItem(index, 4, i[4])
                    self.list.SetStringItem(index, 5, i[5])
                    self.list.SetStringItem(index, 6, i[6])
                    self.color(n,i[7])
                    self.list.SetItemData(index,n)
                    n+=1
                #self.SortListItems(2, True)    #force un tri à partir de la 2ème colonne
                    
        def gotoDict(self,c):
                    self.dico={}
                    n=0
                    for i in c:
                            self.dico[n]=(i[0],i[1],i[2],i[3],i[4],i[5],i[6])
                            n+=1
                    return self.dico

        def color(self,u,s):
                item = self.list.GetItem(u)
                if s.upper()=="Masculin".upper():
                        item.SetTextColour("blue")
                else:   item.SetTextColour("orange")
                self.list.SetItem(item)

        def effacer(self):
                self.list.DeleteAllItems()

        def getColumnText(self, index, col):
                item = self.list.GetItem(index, col)
                return item.GetText()
        
        def onClickDroit(self, event):
                self.p=event.m_itemIndex        #index de la selection
                if not hasattr(self, "popupID1"):
                    self.popupID1 = wx.NewId()
                    self.popupID2 = wx.NewId()
                    self.popupID3 = wx.NewId()
                    self.popupID4 = wx.NewId()
                    
                    self.Bind(wx.EVT_MENU, self.apercu, id=self.popupID1)
                    self.Bind(wx.EVT_MENU, self.modification, id=self.popupID2)
                    self.Bind(wx.EVT_MENU, self.supp, id=self.popupID4)
                    self.Bind(wx.EVT_MENU, self.imp, id=self.popupID3)

                menu = wx.Menu()
                menu.Append(self.popupID1, "Aperçu")
                menu.Append(self.popupID2, "Modifier le Contact")
                menu.Append(self.popupID3, "Imprimer Contact")
                menu.Append(self.popupID4, "Supprimer Contact")
                self.PopupMenu(menu)
                menu.Destroy()
                
        def appel(self,i):
                num=self.getColumnText(i, 0)
                nom= self.getColumnText(i, 2)
                prenoms= self.getColumnText(i, 3)
                contact1= self.getColumnText(i, 4)
                contact2=self.getColumnText(i, 5)
                email=self.getColumnText(i, 6)
                tof_path= self.getColumnText(i, 1)
                return [num,nom,prenoms,contact1,contact2,email,tof_path]
            
        def apercu(self,event):
                 i=self.appel(self.p)
                 fram=Apercu(i)
                 fram.CenterOnParent(wx.BOTH)
                 fram.Show(True)              

        def modification(self,event):
                 i=self.appel(self.p)
                 fram=Modif_contact(i)
                 fram.CenterOnParent(wx.BOTH)
                 fram.Show(True)   

        def supp(self,event):
                global cur,user,refresh,connection_ok
                i=self.appel(self.p)
                dlg=wx.MessageDialog(self, "Confirmer la Suppression de ce Contact",
                                        caption="::.MyAdressBook.::Supprimer ce Contact",style=wx.OK|wx.CANCEL|wx.ICON_QUESTION,pos=wx.DefaultPosition)
                if dlg.ShowModal()==wx.ID_OK:
                        req="delete from contact where user='%s' and id='%s'"%(user,i[0])
                        cur.execute(req)
                        refresh=1
                        connection_ok=1
                        
        def imp(self,event):
                global user,cur
                i=self.appel(self.p)[0]
                req="select nom,prenoms,contact1,contact2,email,photo_path from contact where user='%s' and id='%s' "%(user,i)
                cur.execute(req)
                rep=cur.fetchall()
                rep.sort()
                pdf=SimplePDF_Generateur.GenPDF_ONE()
                pdf.entete(user)
                pdf.contact(rep)
                pdf.pied()
                name=pdf.generate()
                os.system(name)
                
        def photo(self,event):
                global photo,photo_ok
                self.p=event.m_itemIndex
                lot=self.appel(self.p)
                if len(lot[6])==0:
                        photo=""
                else:
                        photo=lot[6]
                photo_ok=1
                event.Skip()
               

        def double(self,event):
                p=event.m_itemIndex
                i=self.appel(p)
                fram=Apercu(i)
                fram.CenterOnParent(wx.BOTH)
                fram.Show(True)

        def marqueur(self,i):
                global connection_ok,passe
                for u in i:
                        for s in self.dico.keys():
                                if u ==self.dico[s][0]:
                                         self.list.SetItemState(s, wx.LIST_STATE_SELECTED, wx.LIST_STATE_SELECTED)
                                         #passe=1                      
                
                                        
class Book(wx.Frame):
        def __init__(self):
                    wx.Frame.__init__(self,None,-1,title="::.MyAdressBook.::Kouakou021988",
                                      size=(800,400),style=wx.DEFAULT_FRAME_STYLE^ (wx.RESIZE_BORDER|wx.MAXIMIZE_BOX))
                    frameicon = wx.Icon("./côte d'ivoire.ico", wx.BITMAP_TYPE_ICO)
                    self.SetIcon(frameicon)
                    self.CenterOnParent(wx.BOTH)
                    self.SetBackgroundColour("black")
                    self.panel=wx.Panel(self,-1,size=self.GetClientSize())
                    self.framesizer=wx.BoxSizer(wx.VERTICAL)
                    self.sizer = wx.FlexGridSizer(rows=1, cols=2, hgap=1, vgap=1)
                    self.build()
                    self.base=DataBase()
                    self.base.dbConnection()
                    self.onTimer(None)
                    self.timer = wx.Timer(self)
                    self.timer.Start(1000)
                    self.Bind(wx.EVT_TIMER, self.onTimer)
                    self.Bind(wx.EVT_CLOSE,self.fermer)

        def build(self):
                    self.menu_barre()
                    self.A_list=ContenuPanel(self.panel,None)
                    self.sizer.Add(self.A_list, 0, 0)
                    self.panelA=wx.Panel(self.panel,-1,style=wx.BORDER_DOUBLE )
                    self.panelA.SetBackgroundColour("white")
                    self.sizer.Add(self.panelA, 0, 0)
                    tof=self.FindWindowById(self.panelA.GetId())
                    lui=self.FindWindowById(self.A_list.GetId())
                    lui.SetMinSize((600,325))
                    tof.SetMinSize((200,325))
                    self.panel.SetSizer(self.sizer)
                    self.framesizer.Add(self.panel,1)
                    self.SetSizer(self.framesizer)
                    self.affiche("IvoryCoast.gif",1)#---->Problème non resolu

        def menu_barre(self):
                    self.menuFichier=wx.Menu()
                    self.menuFichier.Append(ID_NEW,"Nouvel Utilisateur")
                    self.menuFichier.Append(ID_CONNECT, "Connection")
                    self.menuFichier.Append(ID_DECONNECT, "Deconnection")
                    self.menuFichier.Append(ID_ENR, "Enregistrer un contact")
                    self.menuFichier.Append(ID_IMP, "Imprimer vos contacts")
                    self.menuFichier.Append(ID_SUPP, "Supprimer vos contacts")
                    self.menuFichier.Append(ID_SELF, "Supprimer mon compte")
                    self.menuFichier.Append(ID_SEARCH, "Recherche")
                    self.menuFichier.AppendSeparator()
                    self.menuFichier.Append(wx.ID_CLOSE, "Quitter")
                    self.verrou([101,105,106])
                    menuAide=wx.Menu()
                    menuAide.Append(ID_HELP, "Aide")
                    menuAide.Append(ID_PROPOS, "A Propos")
                    menuBarre=wx.MenuBar()
                    menuBarre.Append(self.menuFichier,"Fichier")
                    menuBarre.Append(menuAide,"?")
                    self.SetMenuBar(menuBarre)
                    self.barre=wx.StatusBar(self,-1)
                    self.barre.SetFieldsCount(3)
                    self.barre.SetStatusWidths([-1,-1,-1])
                    self.SetStatusBar(self.barre)
                    wx.EVT_MENU(self,wx.ID_CLOSE,self.fermer)
                    wx.EVT_MENU(self,ID_CONNECT,self.connection)
                    wx.EVT_MENU(self,ID_HELP,self.aide)
                    wx.EVT_MENU(self,ID_PROPOS,self.a_propos)
                    wx.EVT_MENU(self,ID_NEW,self.user_new)
                    wx.EVT_MENU(self,ID_DECONNECT,self.deconnection)
                    wx.EVT_MENU(self,ID_SEARCH,self.recherche)
                    wx.EVT_MENU(self,ID_ENR,self.enregistrement)
                    wx.EVT_MENU(self,ID_IMP,self.impressionContact)
                    wx.EVT_MENU(self,ID_SUPP,self.suppContact)
                    wx.EVT_MENU(self,ID_SELF,self.suppProfil)

        def onTimer(self,event):
                global connection_ok,refresh,user,photo,photo_ok,cur,recherche_ok,passe
                if connection_ok:
                        self.active([101,105,106,107,108,109])
                        self.verrou([100])
                        titre="::.MyAdressBook.::Kouakou021988-Bienvenue %s"%user.capitalize()
                        self.SetTitle(titre)
                        if connection_ok!=2:
                                self.A_list.effacer()
                                self.sesame()
                                self.Refresh()
                        connection_ok=2
                        
                if not connection_ok:
                        self.SetTitle("::.MyAdressBook.::Kouakou021988")
                        self.verrou([101,105,106,107,108,109])
                        self.active([100])
                        self.A_list.effacer()
                        
                if refresh:
                        self.base.enr()
                        refresh=0
                        
                if photo_ok:
                        photo_ok=0
                        self.p.Destroy()
                        del self.p
                        if photo=="":
                                self.affiche("IvoryCoast.gif")
                        else:
                                self.affiche(photo)
                        photo=""
                        
                if recherche_ok:
                        rep=[]
                        r=cur.fetchall()
                        if r:
                                for i in r:
                                        rep.append(i[0])
                                self.A_list.effacer()
                                self.sesame()
                                self.Refresh()
                                self.A_list.marqueur(rep)
                                recherche_ok=0
                        else:
                                recherche_ok=0
                                dlg=wx.MessageDialog(self, "Aucun resultat.Merci",
                                                caption="::.MyAdressBook.::Rechercher un contact",style=wx.OK|wx.ICON_ERROR,pos=wx.DefaultPosition)
                                result=dlg.ShowModal()
                                dlg.Destroy()
#############################################################################################################################
        def affiche(self,path,n=0):
                if n==0:
                        jpg = wx.Image(path, wx.BITMAP_TYPE_ANY)
                        tof=jpg.Scale(150,175)
                        self.p=wx.StaticBitmap(self.panelA, -1, wx.BitmapFromImage(tof),pos=(20,50))
                        self.panelA.Refresh()

                else:                                           #Situation de mon problème(si c'est correct alors expliquez moi pourquoi c'est comme ça
                        jpg = wx.Image(path, wx.BITMAP_TYPE_ANY)
                        tof=jpg.Scale(150,200)
                        self.p=wx.StaticBitmap(self.panelA, -1, wx.BitmapFromImage(tof),pos=(625,50))
                        self.panelA.Refresh()
###############################################################################################################################
        def shutdown(self):
                self.timer.Stop()
                del self.timer
                        
        def sesame(self):
                global user,cur
                req="select id,photo_path,nom,prenoms,contact1,contact2,email,sexe from contact where user='%s'"%user
                cur.execute(req)
                rep=cur.fetchall()
                self.A_list.remplir(rep)
                self.barre.SetStatusText(user+" est connecté(e)",1)
                self.barre.SetStatusText("Choix=Connection",2)
                
        def verrou(self,i):
                for o in i:
                        self.menuFichier.Enable(o,False)

        def active(self,i):
                for o in i:
                        self.menuFichier.Enable(o,True)
                        
        def fermer(self,event):
                self.barre.SetStatusText("Cliquer pour sortir de l'application",0)
                self.barre.SetStatusText("Choix=Fermer",2)
                self.base.fermer()
                del self.base
                os.unlink("c:\\MyAddressBook\id.txt")
                self.Destroy()
                sys.exit(0)
                
        def connection(self,event):
                fram=Connection()
                fram.CenterOnParent(wx.BOTH)
                fram.Show(True)
                fram.MakeModal(True)                        
                        
        def deconnection(self,event):
                global connection_ok,user
                self.barre.SetStatusText("Deconnection de "+user,0)
                self.barre.SetStatusText("",1)
                self.barre.SetStatusText("Choix=Deconnection",2)
                connection_ok=0
                self.affiche("IvoryCoast.gif")
                
        def aide(self,event): pass
        def a_propos(self,event):
                info = wx.AboutDialogInfo()
                info.Name = "MyAddressBook"
                info.Version = "I"
                info.Copyright = "(C) 2008 AWRADEE"
                info.Description = wordwrap(
            "Salut\n Ben voici ma deuxième application avec wxpython.J'espère que je me suis améliorer."
            "Je débute avec wxpython et pour ma deuxième application j'ai décidé de faire une sorte de repertoire."
            " J'attends vos critiques parceque j'aimerai m'amélioré.\n"
            " Merci pour tout et VIVE PYTHON.",
            300, wx.ClientDC(self))
                info.Developers = [ "Kouakou021988"]
                licenseText="GNL"
                info.License = wordwrap(licenseText, 300, wx.ClientDC(self))
                wx.AboutBox(info)
        
        def enregistrement(self,event):
                self.barre.SetStatusText("Enregistrement d'un nouveau contact",0)
                fram=New_contact()
                fram.CenterOnParent(wx.BOTH)
                fram.Show(True)
                fram.MakeModal(True)
                
        def user_new(self,event):
                self.barre.SetStatusText("Création d'un nouvel utilisateur",0)
                fram=New_user()
                fram.CenterOnParent(wx.BOTH)
                fram.Show(True)
                fram.MakeModal(True)
                
        def recherche(self,event):
                self.barre.SetStatusText("Recherche d'un contact",0)
                fram=Recherche()
                fram.CenterOnParent(wx.BOTH)
                fram.Show(True)
                fram.MakeModal(True)

        def impressionContact(self,event):
                global user,cur
                self.barre.SetStatusText("Impression des contacts de "+user+"...",0)
                req="select nom,prenoms,contact1,contact2,email from contact where user='%s'"%user
                cur.execute(req)
                rep=cur.fetchall()
                rep.sort()
                pdf=SimplePDF_Generateur.GenPDF_ALL()
                pdf.entete(user.capitalize())
                pdf.liste_contact(rep)
                pdf.pied()
                name=pdf.generate()
                os.system(name)
                

        def suppContact(self,event):
                global user
                self.barre.SetStatusText("Suppression des contacts de "+user,0)
                supp=0
                dlg=wx.MessageDialog(self, "Confirmer la Suppression de vos Contacts",
                                        caption="::.MyAdressBook.::Supprimer vos Contacts",style=wx.OK|wx.CANCEL|wx.ICON_QUESTION,pos=wx.DefaultPosition)
                if dlg.ShowModal()==wx.ID_OK:
                        supp=1
                dlg.Destroy()
                if supp:
                        self.suppression(0,user)

        def suppProfil(self,event):
                global user
                self.barre.SetStatusText("Suppression du profil de "+user,0)
                supp=0
                dlg=wx.MessageDialog(self, "Confirmer la Suppression de votre Compte",
                                        caption="::.MyAdressBook.::Supprimer mon Compte",style=wx.OK|wx.CANCEL|wx.ICON_QUESTION,pos=wx.DefaultPosition)
                if dlg.ShowModal()==wx.ID_OK:
                        supp=1
                dlg.Destroy()
                if supp:
                        self.suppression(1,user)

        def suppression(self,code,utilisateur):
                global cur,refresh,connection_ok
                if code==0:
                        req="select photo_path from contact where user='%s'"%utilisateur
                        cur.execute(req)
                        r=cur.fetchall()
                        for i in r:
                            try:    os.unlink(i[0])
                            except: pass
                        req="delete from contact where user='%s'"%utilisateur
                        cur.execute(req)
                        refresh=1
                        connection_ok=1
                else:
                        if code==1:
                                req="delete from contact where user='%s'"%utilisateur
                                cur.execute(req)
                                req="delete from utilisateur where user='%s'"%utilisateur
                                cur.execute(req)
                                refresh=1
                                self.deconnection(None)

if __name__ == '__main__':
        app = wx.PySimpleApp()
        Book().Show()
        app.MainLoop()

Conclusion :


Bye

Codes Sources

A voir également

Vous n'êtes pas encore membre ?

inscrivez-vous, c'est gratuit et ça prend moins d'une minute !

Les membres obtiennent plus de réponses que les utilisateurs anonymes.

Le fait d'être membre vous permet d'avoir un suivi détaillé de vos demandes et codes sources.

Le fait d'être membre vous permet d'avoir des options supplémentaires.