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