def keyReg(self,widget,event):
if gtk.gdk.keyval_name(event.keyval)=='Delete' and int(Glob.acc[1])==1:
sel=widget.get_selection()
mod,it=sel.get_selected()
if it:
msgbx=gtk.MessageDialog(None,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_YES_NO,'You are about to delete a Series, Are you sure?')
#msgbx.set_decorated(False)
msgbx.set_position(gtk.WIN_POS_CENTER)
res=msgbx.run()
msgbx.destroy()
if res==gtk.RESPONSE_YES:
try:
Conn.conDB().ser(3, mod[it][1])
mod.remove(it)
Glob.ser=[]
for i in range(len(self.regs)):
Glob.ser.append([self.regs[i][0],self.regs[i][1]])
except:
msgbx=gtk.MessageDialog(None,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_OK,'An error Occured, the Series was not Deleted?')
#msgbx.set_decorated(False)
msgbx.set_position(gtk.WIN_POS_CENTER)
msgbx.run()
msgbx.destroy()
def pref(self,widget,event,page):
if page==3:
res,acc=log.log().login('Create')
if res==gtk.RESPONSE_OK:
try:
Conn.conDB().acc(1,acc)
except:
msgbx=gtk.MessageDialog(self.back,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_OK,'The Account Could not be Created as it ALREADY EXISTS')
#msgbx.set_decorated(False)
msgbx.run()
msgbx.destroy()
else:
tools.Tools().back(page)
def search(self,widget,event):
lst='select*from record'
par=''
if self.txtReg.get_active()!=-1:
par=par + " reg="+str(self.txtReg.get_active())+ " and"
if self.txtCode.get_active()!=-1:
par=par + " code like '%"+self.txtCode.get_text()+ "%' and"
if self.txtRef.get_text()!='':
par=par + " ref like '%"+self.txtRef.get_text()+ "%' and"
if self.txtCon.get_text()!='':
par=par + " consign like '%"+self.txtCon.get_text()+ "%' and"
if self.txtL.get_text()!='':
par=par + " loc like '%"+self.txtL.get_text()+ "%' and"
if self.txtBox.get_text()!='':
par=par + " box='"+self.txtBox.get_text()+ "' and"
if self.txtSub.get_text()!='':
par=par + " sub like '%"+self.txtSub.get_text()+ "%' and"
if self.txtRet.get_text()!='':
par=par + " ret >"+self.txtRet.get_text()+ " and"
if self.txtAct.get_active() !=-1:
par=par + " act='"+str(Glob.act[self.txtAct.get_active()][0])+ "' and"
if len(par)>3:
par=par[:len(par)-3]
lst=lst+' where '+par
b=(Conn.conDB().ref_list(0,lst))
self.dialog.hide()
records.Files().list(b)
def key(self,widget,event):
if gtk.gdk.keyval_name(event.keyval)=='Delete' and int(Glob.acc[1])==0:
sel=widget.get_selection()
mod,it=sel.get_selected()
if it:
msgbx=gtk.MessageDialog(self.dialog,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_YES_NO,'You are about to delete a FILE, Are you sure?')
#msgbx.set_decorated(False)
res=msgbx.run()
msgbx.destroy()
if res==gtk.RESPONSE_YES:
try:
Conn.conDB().ref_list(1, mod[it][10])
mod.remove(it)
except:
msgbx=gtk.MessageDialog(self.dialog,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_OK,'An error Occured, the Record was not Deleted?')
#msgbx.set_decorated(False)
msgbx.run()
msgbx.destroy()
def addReg(self,widget,ev,view):
if self.txtReg.get_text()!='':
try:
for i in range(len(self.regs)):
if str(self.regs[i][0]).upper()==str(self.txtReg.get_text()).upper():
raise Exception('Exists')
Conn.conDB().ser(2,self.txtReg.get_text())
Glob.ser=Conn.conDB().ser(0,0)
self.regs.clear()
self.txtReg.set_text('')
for i in range(len(Glob.ser)):
self.regs.append([str(Glob.ser[i][0]),Glob.ser[i][1]])
view.set_model(self.regs)
except:
msgbx=gtk.MessageDialog(None,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_OK,'The Series could not be add becasue it cannot acquire a Unique ID')
msgbx.set_decorated(False)
msgbx.set_position(gtk.WIN_POS_CENTER)
res=msgbx.run()
msgbx.destroy()
def addRef(self,widget,ev,view):
if self.txtRef.get_text()!='' and self.txtSub.get_text()!='':
try:
for i in range(len(self.refs)):
if str(self.refs[i][0]).upper()==str(self.txtRef.get_text()).upper():
raise Exception('Exists')
data=[]
data.append(self.txtRef.get_text())
data.append(self.txtSub.get_text())
Conn.conDB().ref(2,data)
Glob.ref.append(([self.txtRef.get_text(),self.txtSub.get_text()]))
self.refs.append([self.txtRef.get_text(),self.txtSub.get_text()])
self.txtRef.set_text('')
self.txtSub.set_text('')
except:
msgbx=gtk.MessageDialog(None,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_OK,'The Reference could not be add becasue it cannot acquire a Unique ID')
msgbx.set_decorated(False)
msgbx.set_position(gtk.WIN_POS_CENTER)
res=msgbx.run()
msgbx.destroy()
def upAction(self,widget,event):
try:
datetime.datetime.strptime(self.ActDate.get_text(),'%d/%m/%Y')
if self.cboAct.get_active<0:
msgbx=gtk.MessageDialog(self.dialog,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_OK,'You have Not Selected Nay Action to Take!!')
msgbx.set_decorated(False)
res=msgbx.run()
msgbx.destroy()
else:
store=[]
itr=[]
model = self.cboAct.get_model()
active = self.cboAct.get_active()
for it in range(len(self.lst)):
if self.lst[it][11]:
if str(model[active][0])!=str(self.lst[it][9]):
stor=[]
'''#convert the combo active value to its item value'''
stor.append(model[active][0])
stor.append(self.ActDate.get_text())
stor.append(self.lst[it][10])
store.append(stor)
else:
self.lst[it][11]=False
if store!=[]:
Conn.conDB().recordUp(store)
for row in self.lst:
if row[11]:
self.lst.remove(row.iter)
except:
msgbx=gtk.MessageDialog(self.dialog,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_OK,'The Action Date is not Correct')
msgbx.set_decorated(True)
res=msgbx.run()
msgbx.destroy()
def Addrange(self,widget,event,stor):
res,ran=rang.New().Ref()
if res==gtk.RESPONSE_OK:# and ran!=[]:
try:
for i in range(len(ran)):
if ran[i]=="":
msgbx=gtk.MessageDialog(self.dialog,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_OK,'Files could not be retrieved as you did not fill in all the parameters')
msgbx.set_decorated(False)
res=msgbx.run()
msgbx.destroy()
raise Exception('empty')
sql="select*from dpp_registry where dpp_case_year="+str(ran[2])+\
" and dpp_case_categ_id =" + str(ran[3])+" and dpp_case_seq_no between "+\
str(ran[0]) +" and " + str(ran[1])
dat=Conn.conDB().rang(sql)
lst='select*from record'
archd=(Conn.conDB().ref_list(0,lst))
if dat!=[]:
if len(stor)==1 and stor[0][0]=='':
stor.clear()
for d in range(len(dat)):
try:
for a in range(len(archd)):# check if exists in database
if str(archd[a][5]).upper()==str(dat[d][0]).upper():
raise Exception ('Exists')
for b in range(len(stor)):#check if exists if liststore (stor)
if str(stor[b][0]).upper()==str(dat[d][0]).upper():
raise Exception ('Exists')
stor.append([dat[d][0],dat[d][1],ran[7],dat[d][2],dat[d][3],ran[4],ran[5],ran[6]])
except:
pass
except:
pass
def new(self, widget,event):
res,stor=new.new().Reg()
if res==gtk.RESPONSE_OK and stor!=[]:
Conn.conDB().newEntry(stor)
def __init__(self):
#Glob.init()
self.back=gtk.Window(gtk.WINDOW_TOPLEVEL)
try:
infile=open('conf.dat','r')
data = cPickle.load(infile)
infile.close()
Glob.host=data[0]
Glob.port=data[1]
except:
msgbx=gtk.MessageDialog(self.back,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_OK,'System cannot start, Missing Configuration File')
msgbx.set_decorated(False)
msgbx.run()
msgbx.destroy()
Glob.reg=Conn.conDB().reg(0,0)
Glob.act=Conn.conDB().actions(0,0)
Glob.ref=Conn.conDB().ref(0,0)
Glob.ser=Conn.conDB().ser(0,0)
#self.back=gtk.Window(gtk.WINDOW_TOPLEVEL)
self.back.connect("destroy", lambda wid: gtk.main_quit())
self.back.set_icon_from_file('BON.jpg')
self.back.maximize()
self.back.set_title("Registry")
self.v=gtk.VBox(False,0)
self.h=gtk.HBox(False,0)
self.mbar=gtk.MenuBar()
menuF=gtk.Menu()
menuT=gtk.Menu()
menuR=gtk.Menu()
self.file=gtk.MenuItem('File')
self.report=gtk.MenuItem('Reports')
self.tools=gtk.MenuItem('Tools')
nw=gtk.MenuItem('New files for Retention')
nw.connect('button_press_event',self.new)
cl=gtk.MenuItem('Close')
cl.connect('button_press_event',self.dest)
rp=gtk.MenuItem('Reports')
#rp.connect('button_press_event',self.reports)
mt=gtk.MenuItem('Material Estimates')
#mt.connect('button_press_event',self.materials)
wk=gtk.MenuItem('Duration Estimate')
#wk.connect('button_press_event',self.Wk_Plan)
act=gtk.MenuItem('Actions Taken')
act.connect('button_press_event',self.pref,0)
ref=gtk.MenuItem('File References')
ref.connect('button_press_event',self.pref,1)
reg=gtk.MenuItem('Preferences')
reg.connect('button_press_event',self.pref,2)
Acct=gtk.MenuItem('New User Account')
Acct.connect('button_press_event',self.pref,3)
menuF.append(nw)
menuF.append(cl)
self.file.set_submenu(menuF)
self.mbar.append(self.file)
menuR.append(rp)
menuR.append(mt)
menuR.append(wk)
self.report.set_submenu(menuR)
#self.mbar.append(self.report)
#menuT.append(act)
#menuT.append(ref)
menuT.append(reg)
self.tools.set_submenu(menuT)
self.mbar.append(self.tools)
org=gtk.Label('REGISTRY INFO SYS')
org.modify_font(pango.FontDescription("sans 18"))
org.set_size_request(300,35)
tt=gtk.Table(1,3,False)
tt.set_size_request(300,40)
btnN=gtk.Button('New')
btnN.connect('button_press_event',self.new)
tt.attach(btnN,0,1,0,1)
btnF=gtk.Button('Find')
btnF.connect('button_press_event',self.find)
tt.attach(btnF,3,4,0,1)
self.v.pack_start(self.mbar,False,False,0)
self.v.pack_start(org,False,True,0)
self.v.pack_start(tt,False,True,0)
self.back.add(self.v)
self.back.show()
res,acc=log.log().login('Login')
if res==gtk.RESPONSE_OK:
try:
ac=Conn.conDB().acc(0,acc)
if ac!=[]:
Glob.acc=ac
menuT.append(Acct)
self.back.show_all()
else:
msgbx=gtk.MessageDialog(None,gtk.DIALOG_MODAL,gtk.MESSAGE_INFO,
gtk.BUTTONS_OK,'You have entered Either a Wrong User Name or Password,CORRECT ENTRY!! ')
msgbx.set_position(gtk.WIN_POS_CENTER)
res=msgbx.run()
msgbx.destroy()
self.destroy()
raise Exception('No Account')
except:
pass
def editReg(self,widget,path, txt,stor):
if txt!=''and int(Glob.acc[1])==1:
stor[path][0]=(txt)
Glob.ser[int(path)][0]=txt
Conn.conDB().ser(1, stor[path])
def editRef(self,widget,path, txt,stor):
if txt!='' and int(Glob.acc[1])==1:
stor[path][1]=(txt)
Glob.ref[int(path)][1]=txt
Conn.conDB().ref(1, stor[path])
def editAct(self,widget,path, txt,stor):
if txt!='' and int(Glob.acc[1])==1:
stor[path][0]=(txt)
Glob.act[int(path)][0]=txt
Conn.conDB().actions(1, stor[path])
