def __init__(self, query, db, parent=None): QtGui.QDialog.__init__(self, parent) self.ui = Ui_Dialog() self.ui.setupUi(self) self.query = query self.db = db self.signal()
def __init__(self,query,db,parent = None) : QtGui.QDialog.__init__(self,parent) self.ui = Ui_Dialog() self.ui.setupUi(self) self.query = query self.db = db self.signal()
class EmployerInformation(QtGui.QDialog): def __init__(self, query, db, parent=None): QtGui.QDialog.__init__(self, parent) self.ui = Ui_Dialog() self.ui.setupUi(self) self.query = query self.db = db self.signal() def signal(self): QtCore.QObject.connect(self.ui.browse, QtCore.SIGNAL('clicked()'), self.logo_employer) QtCore.QObject.connect(self.ui.browse_2, QtCore.SIGNAL('clicked()'), self.logo_company) QtCore.QObject.connect(self.ui.save, QtCore.SIGNAL('clicked()'), self.onclick_save) #QtCore.QObject.connect(self.ui.next,QtCore.SIGNAL('clicked()'),self.onclick_next) def logo_company(self): self.ui.browse_2.hide() self.filePath = QtGui.QFileDialog.getOpenFileName( self, "Select an image", ".", "Image Files(*.png *.gif *.jpg *jpeg *.bmp)") if not self.filePath.isEmpty(): self.filename = self.filePath.split('/')[-1] self.ui.imagepath.setText(self.filePath) self.ui.label_23.setPixmap(QtGui.QPixmap(self.filePath)) self.fi = open(str(self.filePath), 'rb').read() def logo_employer(self): self.ui.browse.hide() self.filePath_emp = QtGui.QFileDialog.getOpenFileName( self, "Select an image", ".", "Image Files(*.png *.gif *.jpg *jpeg *.bmp)") if not self.filePath_emp.isEmpty(): self.filename_emp = self.filePath_emp.split('/')[-1] self.ui.imagepath.setText(self.filePath_emp) self.ui.label_14.setPixmap(QtGui.QPixmap(self.filePath_emp)) self.fi = open(str(self.filePath_emp), 'rb').read() #self.fi = open(str(filePath),'rb').read() def onclick_save(self): ''' strList = [('First Name' , self.ui.firstname), ('Last Name' , self.ui.lastname), ('Organization Name',self.ui.organizationName), ('Country',self.ui.country), ('Nationality',self.ui.nationality)] ind = 0 ''' flag = True ''' while ind != len(strList): if validation.check_string(strList[ind][1].text()): pass else: strList[ind][1].clear() QtGui.QMessageBox.warning(None, "Warning",'Invalid %s'%strList[ind][0]) flag = False break ind += 1 ''' if self.ui.male.isChecked(): gender = 'male' if self.ui.female.isChecked(): gender = 'female' if self.ui.others.isChecked(): gender = 'other' print gender #if validation.check_email(self.ui.email.text()):pass #else:flage = False if flag: insert_path = open("Employer_Photo/" + str(self.filename_emp), 'wb') insert_path.write(self.fi_emp) insert_path.close() self.query.exec_( """ insert into employer_information(first_name ,last_name, gender ,dob ,email,website, address ,city ,state ,country ,pin_no ,nationality , mobile_no1 ,mobile_no2 ,landline_no ,account_no,image_path ) values ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s', '%s','%s','%s','%s','%s','%s')""" % (self.ui.lastname.text(), gender, str(self.ui.dob.date().toPyDate()), self.ui.email.text(), self.ui.website.text(), self.ui.address.text(), self.ui.city.text(), self.ui.state.text(), self.ui.country.text(), self.ui.pinno.text(), self.ui.nationality.text(), self.ui.mobileno.text(), self.ui.mobileno_2.text(), self.ui.landlineno.text(), self.ui.accountno.text(), self.filename_emp)) insert_path = open("Company_logo/" + str(self.filename), 'wb') insert_path.write(self.fi) insert_path.close() self.query.exec_( """ insert into company (company_name,company_category,address_line1,address_line2,city,state,country, pin_no ,nationality ,mobile_no1 ,mobile_no2 ,landline_no ,website,email,image_path ) values ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')""" % (self.ui.companyName.text(), self.ui.tradeName.text(), self.ui.address1.toPlainText(), self.ui.address2.toPlainText(), self.ui.city_2.text(), self.ui.state_2.text(), self.ui.country_2.text(), self.ui.pinno_2.text(), self.ui.nationality_2.text(), self.ui.mobileno_4.text(), self.ui.mobileno_3.text(), self.ui.landlineno_2.text(), self.ui.website_2.text(), self.ui.email_2.text(), self.filename)) print self.query.isActive() QtGui.QMessageBox.information(self, 'Information', 'Record Saved Successfully !!!') self.close()
class EmployerInformation(QtGui.QDialog): def __init__(self,query,db,parent = None) : QtGui.QDialog.__init__(self,parent) self.ui = Ui_Dialog() self.ui.setupUi(self) self.query = query self.db = db self.signal() def signal(self): QtCore.QObject.connect(self.ui.browse,QtCore.SIGNAL('clicked()'),self.logo_employer) QtCore.QObject.connect(self.ui.browse_2,QtCore.SIGNAL('clicked()'),self.logo_company) QtCore.QObject.connect(self.ui.save,QtCore.SIGNAL('clicked()'),self.onclick_save) #QtCore.QObject.connect(self.ui.next,QtCore.SIGNAL('clicked()'),self.onclick_next) def logo_company(self): self.ui.browse_2.hide() self.filePath = QtGui.QFileDialog.getOpenFileName( self, "Select an image", ".", "Image Files(*.png *.gif *.jpg *jpeg *.bmp)" ) if not self.filePath.isEmpty(): self.filename = self.filePath.split('/')[-1] self.ui.imagepath.setText(self.filePath) self.ui.label_23.setPixmap(QtGui.QPixmap(self.filePath)) self.fi = open(str(self.filePath),'rb').read() def logo_employer(self): self.ui.browse.hide() self.filePath_emp = QtGui.QFileDialog.getOpenFileName( self, "Select an image", ".", "Image Files(*.png *.gif *.jpg *jpeg *.bmp)" ) if not self.filePath_emp.isEmpty(): self.filename_emp = self.filePath_emp.split('/')[-1] self.ui.imagepath.setText(self.filePath_emp) self.ui.label_14.setPixmap(QtGui.QPixmap(self.filePath_emp)) self.fi = open(str(self.filePath_emp),'rb').read() #self.fi = open(str(filePath),'rb').read() def onclick_save(self): ''' strList = [('First Name' , self.ui.firstname), ('Last Name' , self.ui.lastname), ('Organization Name',self.ui.organizationName), ('Country',self.ui.country), ('Nationality',self.ui.nationality)] ind = 0 ''' flag = True ''' while ind != len(strList): if validation.check_string(strList[ind][1].text()): pass else: strList[ind][1].clear() QtGui.QMessageBox.warning(None, "Warning",'Invalid %s'%strList[ind][0]) flag = False break ind += 1 ''' if self.ui.male.isChecked() : gender = 'male' if self.ui.female.isChecked() : gender = 'female' if self.ui.others.isChecked() : gender = 'other' print gender #if validation.check_email(self.ui.email.text()):pass #else:flage = False if flag: insert_path = open("Employer_Photo/"+str(self.filename_emp),'wb') insert_path.write(self.fi_emp) insert_path.close() self.query.exec_(""" insert into employer_information(first_name ,last_name, gender ,dob ,email,website, address ,city ,state ,country ,pin_no ,nationality , mobile_no1 ,mobile_no2 ,landline_no ,account_no,image_path ) values ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s', '%s','%s','%s','%s','%s','%s')"""%(self.ui.lastname.text(), gender,str(self.ui.dob.date().toPyDate()), self.ui.email.text(),self.ui.website.text(), self.ui.address.text(), self.ui.city.text(),self.ui.state.text(), self.ui.country.text(),self.ui.pinno.text(), self.ui.nationality.text(),self.ui.mobileno.text(), self.ui.mobileno_2.text(),self.ui.landlineno.text(), self.ui.accountno.text(),self.filename_emp)) insert_path = open("Company_logo/"+str(self.filename),'wb') insert_path.write(self.fi) insert_path.close() self.query.exec_(""" insert into company (company_name,company_category,address_line1,address_line2,city,state,country, pin_no ,nationality ,mobile_no1 ,mobile_no2 ,landline_no ,website,email,image_path ) values ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')""" %(self.ui.companyName.text(),self.ui.tradeName.text(),self.ui.address1.toPlainText(), self.ui.address2.toPlainText(),self.ui.city_2.text(),self.ui.state_2.text(),self.ui.country_2.text(), self.ui.pinno_2.text(),self.ui.nationality_2.text(),self.ui.mobileno_4.text(), self.ui.mobileno_3.text(),self.ui.landlineno_2.text(), self.ui.website_2.text(),self.ui.email_2.text(),self.filename)) print self.query.isActive() QtGui.QMessageBox.information(self,'Information','Record Saved Successfully !!!') self.close()