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])