class EditSupplyerDetailModule(QDialog, Ui_Dialog): def __init__(self, autoid=None, parent=None): super(EditSupplyerDetailModule, self).__init__(parent) self.setupUi(self) if '3' not in user.powers: self.close() if user.powers['3'] == 0: self.close() self.power = '{:03b}'.format(user.powers['3']) if self.power[1] == '0': self.pushButton_accept.setVisible(False) self.pushButton_cancel.setVisible(False) self.autoid = autoid self.docid = 0 self.current_content = QWidget() self.ori_detail = dict() self.new_detail = dict() self.current_img = object self.current_page = object self.SC = SupplyerController() self.SDC = SelfdefinedformatController() self.IC = ImageController() self.treeWidget_stuff.hideColumn(0) self.treeWidget_revalution.hideColumn(0) self.treeWidget_imagenamelist.hideColumn(0) self.treeWidget_imagenamelist.hideColumn(1) # 自动缩放 self.label_image.setScaledContents(True) return_row = ('parentid', 'autoid', 'kindname') condition_key = {'autoid', 'kindname', 'inputcode'} treeheader_name = ['parentid', '编号', '名称'] condition = {'kind': 0} self.lineEdit_kind.setup('Treestructure', return_row, condition_key, treeheader_name, condition, treewidth=300) self.get_detail() def get_detail(self): if self.autoid is None: self.dateEdit_validdate.setDate(user.now_date) return key_dict = {'autoid': self.autoid} res = self.SC.get_data(0, False, *VALUE_TUPLE_SUP, **key_dict) if not len(res): return self.ori_detail = res[0] self.lineEdit_supid.setText(self.ori_detail['supid']) self.lineEdit_supname.setText(self.ori_detail['supname']) self.lineEdit_inputcode.setText(self.ori_detail['inputcode']) self.lineEdit_kind.setText( str(self.ori_detail['tstkind']) + ' ' + self.ori_detail['tstname']) self.lineEdit_address.setText(self.ori_detail['address']) self.lineEdit_postzip.setText(self.ori_detail['postzip']) self.lineEdit_charger.setText(self.ori_detail['charger']) self.lineEdit_telno.setText(self.ori_detail['telno']) self.lineEdit_chargertitle.setText(self.ori_detail['chargertitle']) self.lineEdit_email.setText(self.ori_detail['email']) self.lineEdit_bankname.setText(self.ori_detail['bankname']) self.lineEdit_bankaccount.setText(self.ori_detail['bankaccount']) self.lineEdit_taxno.setText(self.ori_detail['taxno']) self.dateEdit_validdate.setDate(self.ori_detail['validdate']) self.plainTextEdit_remark.setPlainText(self.ori_detail['remark']) def get_image(self): self.treeWidget_imagenamelist.clear() if self.autoid is None: return key_dict = {'scid': self.autoid, 'kind': 0} res = self.IC.get_data(0, False, *VALUE_TUPLE_IMRELA, **key_dict) for item in res: qtreeitem = QTreeWidgetItem(self.treeWidget_imagenamelist) qtreeitem.setText(0, str(item['autoid'])) qtreeitem.setText(1, str(item['imageid'])) qtreeitem.setText(2, item['title']) qtreeitem.setText(3, item['creatorid'] + item['creatorname']) qtreeitem.setText(4, str(item['createdate'])) def get_format(self): if self.autoid is None: return self.treeWidget_revalution.clear() key_dict = {'spid': self.autoid} res = self.SC.get_data(4, False, *VALUE_TUPLE_SR, **key_dict) if not len(res): return for item in res: qtreeitem = QTreeWidgetItem(self.treeWidget_revalution) qtreeitem.setText(0, str(item['autoid'])) qtreeitem.setText(1, item['title']) qtreeitem.setText(2, str(item['createdate'])) qtreeitem.setText(3, item['creatorid'] + ' ' + item['creatorname']) for i in range(1, 4): self.treeWidget_revalution.resizeColumnToContents(i) def get_stuff(self): if self.autoid is None: return self.treeWidget_stuff.clear() key_dict = {'spid': self.autoid} res = self.SC.get_data(1, False, **key_dict).extra( select={ 'autoid': 'stuffdictionary.autoid', 'stuffid': 'stuffdictionary.stuffid', 'stuffname': 'stuffdictionary.stuffname', 'stufftype': 'stuffdictionary.stufftype', 'spec': 'stuffdictionary.spec', 'package': 'stuffdictionary.package' }, tables=['stuffdictionary'], where=['stuffdictionary.autoid=stuffsupplyers.sdid' ]).values(*VALUE_TUPLE_STUFF) if not len(res): return for item in res: qtreeitem = QTreeWidgetItem(self.treeWidget_stuff) qtreeitem.setText(0, str(item['autoid'])) qtreeitem.setText(1, STUFFTYPE[item['stufftype']]) qtreeitem.setText(2, item['stuffid']) qtreeitem.setText(3, item['stuffname']) qtreeitem.setText(4, item['spec']) qtreeitem.setText(5, item['package']) for i in range(1, 6): self.treeWidget_stuff.resizeColumnToContents(i) @pyqtSlot(QTreeWidgetItem, int) def on_treeWidget_imagenamelist_itemDoubleClicked(self, qtreeitem, p_int): img_id = int(qtreeitem.text(1)) key_dict = {'autoid': img_id} res = self.IC.get_data(1, False, *VALUE_TUPLE_IM, **key_dict) if not len(res): return ext = res[0]['ext'] image = res[0]['img'] if ext.lower() == 'pdf': self.comboBox_jumpto.setVisible(True) self.pushButton_prepage.setVisible(True) self.pushButton_nextpage.setVisible(True) self.current_img = fitz.Document(stream=image, filetype='pdf') page_count = self.current_img.pageCount page_list = [] self.comboBox_jumpto.clear() for i in range(1, page_count + 1): page_list.append('第' + str(i) + '页') self.comboBox_jumpto.addItems(page_list) self.current_page = self.current_img.loadPage(0) else: self.comboBox_jumpto.setVisible(False) self.pushButton_prepage.setVisible(False) self.pushButton_nextpage.setVisible(False) img = QImage.fromData(image) self.current_img = QPixmap.fromImage(img) self.label_image.setPixmap(self.current_img) # 默认放大为3被,同时自动调用on_horizontalSlider_zoom_valueChanged self.horizontalSlider_zoom.setValue(30) @pyqtSlot(int) def on_horizontalSlider_zoom_valueChanged(self, p_int): try: self.label_zoom.setText(str(p_int * 10) + '%') # 把当前页面转为QPixmap,并缩放为p_int/10 cover = render_pdf_page(self.current_page, p_int / 10, p_int / 10) self.label_image.setPixmap(cover) except (ValueError, AttributeError): size = self.current_img.size() new_pixmap = self.current_img.scaled(size.width() * p_int / 10, size.height() * p_int / 10) self.label_image.setPixmap(new_pixmap) @pyqtSlot(int) def on_comboBox_jumpto_currentIndexChanged(self, p_int): try: self.current_page = self.current_img.loadPage(p_int) self.on_horizontalSlider_zoom_valueChanged( self.horizontalSlider_zoom.value()) except (AttributeError, ValueError): pass @pyqtSlot() def on_pushButton_prepage_clicked(self): index = self.comboBox_jumpto.currentIndex() if index - 1 >= 0: try: self.current_page = self.current_img.loadPage(index - 1) self.comboBox_jumpto.setCurrentIndex(index - 1) except (AttributeError, ValueError): pass @pyqtSlot() def on_pushButton_nextpage_clicked(self): index = self.comboBox_jumpto.currentIndex() if index + 1 < self.comboBox_jumpto.count(): try: self.current_page = self.current_img.loadPage(index + 1) self.comboBox_jumpto.setCurrentIndex(index + 1) except (AttributeError, ValueError): pass @pyqtSlot(QPoint) def on_treeWidget_imagenamelist_customContextMenuRequested(self, pos): if self.power[1] == '0': return # 返回调用者的对象 sender_widget = self.sender() menu = QMenu() button1 = menu.addAction("新增图片") button2 = menu.addAction("修改图片") button3 = menu.addAction("删除图片") global_pos = sender_widget.mapToGlobal(pos) action = menu.exec(global_pos) res = "rollback" # 增加 if action == button1: img_names, img_type = QFileDialog.getOpenFileNames( self, "打开图片", os.path.expanduser("~") + "\Desktop", "*.jpg;;*.png;;*.bmp;;*.gif;;*.pdf;;All Files(*)") for item in img_names: imagename_no_ext = item.split("/")[-1] image_ext = item.split(".")[1] if image_ext.lower() not in ("jpg", "png", "bmp", "gif", "pdf"): continue fp = open(item, 'rb') with fp: image_byte = fp.read() fp.close() imagedetail = {'img': image_byte, 'ext': image_ext} reladetail = { 'kind': 0, 'scid': self.autoid, 'title': imagename_no_ext, 'creatorid': user.user_id, 'creatorname': user.user_name, 'createdate': user.now_date } res = self.IC.update_images(reladetail, imagedetail) # 修改 elif action == button2: rela_id = self.treeWidget_imagenamelist.currentItem().text(0) img_id = self.treeWidget_imagenamelist.currentItem().text(1) img_name, img_type = QFileDialog.getOpenFileName( self, "打开图片", os.path.expanduser("~") + "\Desktop", "*.jpg;;*.png;;*.bmp;;*.gif;;*.pdf;;All Files(*)") imagename_no_ext = img_name.split("/")[-1] image_ext = img_name.split(".")[1] if image_ext.lower() in ("jpg", "png", "bmp", "gif", "pdf"): fp = open(img_name, 'rb') with fp: image_byte = fp.read() fp.close() imagedetail = {'img': image_byte, 'ext': image_ext} reladetail = { 'title': imagename_no_ext, 'creatorid': user.user_id, 'creatorname': user.user_name, 'createdate': user.now_date } res = self.IC.update_images(reladetail, imagedetail, rela_id, img_id) # 删除 elif action == button3: select_item = sender_widget.selectedItems() rela_id = [] img_id = [] for item in select_item: rela_id.append(item.text(0)) img_id.append(item.text(1)) res = self.IC.delete_images(rela_id, img_id) if res == "accept": self.get_image() @pyqtSlot(str) def on_lineEdit_supid_textChanged(self, p_str): try: if p_str != self.ori_detail['supid']: self.new_detail['supid'] = p_str else: try: del self.new_detail['supid'] except KeyError: pass except KeyError: self.new_detail['supid'] = p_str @pyqtSlot(bool, str) def on_pushButton_warrantor_signChanged(self, p_bool, p_str): id, name = p_str.split(' ') if p_bool else ('', '') try: if id != self.ori_detail['warrantorid'] or name != \ self.ori_detail[ 'warrantorname']: self.new_detail['warrantorid'] = id self.new_detail['warrantorname'] = name else: try: del self.new_detail['warrantorid'] del self.new_detail['warrantorname'] except KeyError: pass except KeyError: self.new_detail['warrantorid'] = id self.new_detail['warrantorname'] = name @pyqtSlot(str) def on_lineEdit_supname_textChanged(self, p_str): self.lineEdit_inputcode.setText(Inputcode.make_inputcode(p_str)) try: if p_str != self.ori_detail['supname']: self.new_detail['supname'] = p_str else: try: del self.new_detail['supname'] except KeyError: pass except KeyError: self.new_detail['supname'] = p_str @pyqtSlot(str) def on_lineEdit_kind_textChanged(self, p_str): if len(p_str.split(' ')) != 2 and p_str != '': return id, name = p_str.split(' ') if p_str != '' else ('', '') try: if id != self.ori_detail['tstkind'] or name != \ self.ori_detail['tstname']: self.new_detail['tstkind'] = id self.new_detail['tstname'] = name else: try: del self.new_detail['tstkind'] del self.new_detail['tstname'] except KeyError: pass except KeyError: self.new_detail['tstkind'] = id self.new_detail['tstname'] = name @pyqtSlot(str) def on_lineEdit_inputcode_textChanged(self, p_str): try: if p_str != self.ori_detail['inputcode']: self.new_detail['inputcode'] = p_str else: try: del self.new_detail['inputcode'] except KeyError: pass except KeyError: self.new_detail['inputcode'] = p_str @pyqtSlot(str) def on_lineEdit_address_textChanged(self, p_str): try: if p_str != self.ori_detail['address']: self.new_detail['address'] = p_str else: try: del self.new_detail['address'] except KeyError: pass except KeyError: self.new_detail['address'] = p_str @pyqtSlot(str) def on_lineEdit_postzip_textChanged(self, p_str): try: if p_str != self.ori_detail['postzip']: self.new_detail['postzip'] = p_str else: try: del self.new_detail['postzip'] except KeyError: pass except KeyError: self.new_detail['postzip'] = p_str @pyqtSlot(str) def on_lineEdit_charger_textChanged(self, p_str): try: if p_str != self.ori_detail['charger']: self.new_detail['charger'] = p_str else: try: del self.new_detail['charger'] except KeyError: pass except KeyError: self.new_detail['charger'] = p_str @pyqtSlot(str) def on_lineEdit_telno_textChanged(self, p_str): try: if p_str != self.ori_detail['telno']: self.new_detail['telno'] = p_str else: try: del self.new_detail['telno'] except KeyError: pass except KeyError: self.new_detail['telno'] = p_str @pyqtSlot(str) def on_lineEdit_chargertitle_textChanged(self, p_str): try: if p_str != self.ori_detail['chargertitle']: self.new_detail['chargertitle'] = p_str else: try: del self.new_detail['chargertitle'] except KeyError: pass except KeyError: self.new_detail['chargertitle'] = p_str @pyqtSlot(str) def on_lineEdit_email_textChanged(self, p_str): try: if p_str != self.ori_detail['email']: self.new_detail['email'] = p_str else: try: del self.new_detail['email'] except KeyError: pass except KeyError: self.new_detail['email'] = p_str @pyqtSlot(str) def on_lineEdit_bankname_textChanged(self, p_str): try: if p_str != self.ori_detail['bankname']: self.new_detail['bankname'] = p_str else: try: del self.new_detail['bankname'] except KeyError: pass except KeyError: self.new_detail['bankname'] = p_str @pyqtSlot(str) def on_lineEdit_bankaccount_textChanged(self, p_str): try: if p_str != self.ori_detail['bankaccount']: self.new_detail['bankaccount'] = p_str else: try: del self.new_detail['bankaccount'] except KeyError: pass except KeyError: self.new_detail['bankaccount'] = p_str @pyqtSlot(str) def on_lineEdit_taxno_textChanged(self, p_str): try: if p_str != self.ori_detail['taxno']: self.new_detail['taxno'] = p_str else: try: del self.new_detail['taxno'] except KeyError: pass except KeyError: self.new_detail['taxno'] = p_str @pyqtSlot(QDate) def on_dateEdit_validdate_dateChanged(self, q_date): try: if type(self.ori_detail['validdate']) is str: self.new_detail['validdate'] = q_date.toPyDate() return if q_date != QDate(self.ori_detail['validdate']): self.new_detail['validdate'] = q_date.toPyDate() else: try: del self.new_detail['validdate'] except KeyError: pass except KeyError: self.new_detail['validdate'] = q_date.toPyDate() @pyqtSlot() def on_plainTextEdit_remark_textChanged(self): p_str = self.plainTextEdit_remark.toPlainText() try: if p_str != self.ori_detail['remark']: self.new_detail['remark'] = p_str else: try: del self.new_detail['remark'] except KeyError: pass except KeyError: self.new_detail['remark'] = p_str @pyqtSlot() def on_pushButton_accept_clicked(self): if not len(self.new_detail): return condition = dict() if self.autoid is not None: condition['autoid'] = self.autoid self.SC.update_data(0, condition, **self.new_detail) self.accept() @pyqtSlot() def on_pushButton_cancel_clicked(self): self.close() @pyqtSlot(QTreeWidgetItem, int) def on_treeWidget_revalution_itemDoubleClicked(self, qtreeitem, p_int): if hasattr(self.current_content, 'flat'): if self.current_content.flat: dialog = MessageBox(self, title="提醒", text="文档尚未保存", informative="是否要保存文档", yes_text="保存", no_text="放弃保存") result = dialog.exec() if result == QMessageBox.Yes: # 调用保存的槽函数 self.on_pushButton_save_clicked() self.docid = int(qtreeitem.text(0)) key_dict = {'autoid': self.docid} res = self.SC.get_data(4, True, *VALUE_TUPLE_SD, **key_dict) if not len(res): return content = str(res[0]) if not self.gridLayout_7.isEmpty(): self.gridLayout_7.removeWidget(self.current_content) self.current_content.close() self.current_content = XMLReadWrite(self) self.current_content.openxml(content) self.gridLayout_7.addWidget(self.current_content) self.current_content.__setattr__('autoid', self.docid) @pyqtSlot() def on_pushButton_save_clicked(self): if self.docid == 0: return if not hasattr(self.current_content, 'flat'): return newcontent = self.current_content.get_content() condition = {'autoid': self.docid} kwargs = {'conclusion': newcontent} self.SC.update_data(4, condition, **kwargs) self.current_content.flat = 0 @pyqtSlot() def on_pushButton_undo_clicked(self): if hasattr(self.current_content, 'flat'): self.current_content.flat = 0 @pyqtSlot(QPoint) def on_treeWidget_revalution_customContextMenuRequested(self, pos): if self.power[1] == '0': return if self.autoid is None: return sender_widget = self.sender() current_item = sender_widget.currentItem() menu = QMenu() button1 = menu.addAction("增加记录") button2 = menu.addAction("修改记录") button3 = menu.addAction("删除记录") global_pos = sender_widget.mapToGlobal(pos) action = menu.exec(global_pos) if action == button1: detail = SelectSelfDefineFormatModule('4', self) detail.selected.connect(self.new_records) detail.accepted.connect(self.get_format) detail.show() elif action == button2: if current_item is None: return if hasattr(self.current_content, 'flat'): if self.current_content.flat: dialog = MessageBox(self, title="提醒", text="文档尚未保存", informative="是否要保存文档", yes_text="保存", no_text="放弃保存") result = dialog.exec() if result == QMessageBox.Yes: # 调用保存的槽函数 self.on_pushButton_accept_clicked() self.docid = int(current_item.text(0)) key_dict = {'autoid': self.docid} res = self.SC.get_data(4, True, *VALUE_TUPLE_SD, **key_dict) if not len(res): return content = str(res[0]) if not self.gridLayout_7.isEmpty(): self.gridLayout_7.removeWidget(self.current_content) self.current_content.close() self.current_content = XMLReadWrite(self) self.current_content.openxml(content) self.gridLayout_7.addWidget(self.current_content) self.current_content.__setattr__('autoid', self.docid) elif action == button3: if current_item is None: return id = int(current_item.text(0)) condition = {'autoid': id} self.SC.delete_data(4, condition) self.get_format() def new_records(self, q_list): detail = { 'creatorid': user.user_id, 'creatorname': user.user_name, 'createdate': user.now_date, 'spid': self.autoid } key_dict = {'autoid__in': q_list} sd_list = self.SDC.get_data(0, **key_dict) for item in q_list: for sd in sd_list: if item == sd.autoid: detail['title'] = sd.formatname detail['conclusion'] = sd.format self.SC.update_data(4, **detail) break @pyqtSlot(int) def on_tabWidget_currentChanged(self, p_int): if p_int == 0: self.get_detail() elif p_int == 1: self.get_image() elif p_int == 2: self.get_format() elif p_int == 3: self.get_stuff() else: pass
class SupplyerListModule(QWidget, Ui_Form): def __init__(self, parent=None): super(SupplyerListModule, self).__init__(parent) self.setupUi(self) if '3' not in user.powers: self.close() if user.powers['3'] == 0: self.close() self.power = '{:03b}'.format(user.powers['3']) self.SC = SupplyerController() self.IC = ImageController() self.kind_list = [] self.curremt_kind = 0 self.treeWidget_kind.hideColumn(1) self.treeWidget_detail.hideColumn(0) self.get_kind_list() self.get_supplyer_list() def get_kind_list(self): self.treeWidget_kind.clear() key_dict = {'kind': 0} self.kind_list = self.SC.get_data(5, False, *VALUES_TUPLE_KIND, **key_dict) # if not len(self.kind_list): # return self.set_kind_list(self.kind_list) # self.treeWidget_kind.resizeColumnToContents(0) self.treeWidget_kind.expandAll() def set_kind_list(self, items): qtreeitem_all = QTreeWidgetItem(self.treeWidget_kind) qtreeitem_all.setText(0, "全部") qtreeitem_all.setText(1, "0") for item in items: res = self.treeWidget_kind.findItems(str(item['autoid']), Qt.MatchRecursive, 1) if len(res): continue if item['parentid'] != 0: parent_item = self.find_kind_item(item['parentid']) qtreeitem = QTreeWidgetItem(parent_item) else: qtreeitem = QTreeWidgetItem(qtreeitem_all) qtreeitem.setText(0, item['kindname']) qtreeitem.setText(1, str(item['autoid'])) def find_kind_item(self, parentid, i=0): res = self.treeWidget_kind.findItems(str(parentid), Qt.MatchRecursive, 1) if len(res): return res[0] else: parent = self.treeWidget_kind.topLevelItem(0) try: if i > 10: # 手动设置最大循环深度位10 raise RecursionError for item in self.kind_list: if item['autoid'] == parentid: parent_id = item['parentid'] if parent_id == 0: parent = QTreeWidgetItem( self.treeWidget_kind.topLevelItem(0)) parent.setText(0, item['kindname']) parent.setText(1, str(item['autoid'])) break else: i += 1 parent = self.find_kind_item(parent_id, i) break return parent except RecursionError: return parent def get_supplyer_list(self): self.treeWidget_detail.clear() key_dict = dict() if self.curremt_kind != 0: key_dict['tstkind'] = self.curremt_kind res = self.SC.get_data(0, False, *VALUES_TUPLE_SP, **key_dict) if not len(res): return for item in res: qtreeitem = QTreeWidgetItem(self.treeWidget_detail) qtreeitem.setText(0, str(item['autoid'])) qtreeitem.setText(1, item['supid']) qtreeitem.setText(2, item['supname']) qtreeitem.setText(3, item['address']) qtreeitem.setText(4, item['charger']) qtreeitem.setText(5, item['telno']) qtreeitem.setText(6, item['taxno']) for i in range(1, 7): self.treeWidget_detail.resizeColumnToContents(i) @pyqtSlot(QTreeWidgetItem, int) def on_treeWidget_kind_itemClicked(self, qtreeitem, p_int): self.curremt_kind = int(qtreeitem.text(1)) self.get_supplyer_list() @pyqtSlot(QTreeWidgetItem, int) def on_treeWidget_detail_itemDoubleClicked(self, qtreeitem, p_int): if self.power[1] == '0': return id = int(qtreeitem.text(0)) detail = EditSupplyerDetailModule(id, self) detail.accepted.connect(self.get_supplyer_list) detail.show() @pyqtSlot(QPoint) def on_treeWidget_kind_customContextMenuRequested(self, pos): if self.power[1] == '0': return sender_widget = self.sender() current_item = sender_widget.currentItem() menu = QMenu() button1 = menu.addAction("增加分类") button2 = menu.addAction("修改分类") button3 = menu.addAction("删除分类") global_pos = sender_widget.mapToGlobal(pos) action = menu.exec(global_pos) if action == button1: if current_item is None: parent_item = self.treeWidget_kind.topLevelItem(0) else: parent_item = current_item parent_id = int(parent_item.text(1)) kwargs = { 'kind': 0, 'kindname': "新建分类", 'parentid': parent_id, 'inputcode': Inputcode.make_inputcode("新建分类") } kind_object = self.SC.update_data(5, **kwargs) qtreeitem = QTreeWidgetItem(parent_item) qtreeitem.setText(0, "新建分类") qtreeitem.setText(1, str(kind_object.autoid)) self.treeWidget_kind.openPersistentEditor(qtreeitem, 0) self.treeWidget_kind.setCurrentItem(qtreeitem) elif action == button2: if current_item is None: return self.treeWidget_kind.setCurrentItem(None) self.treeWidget_kind.openPersistentEditor(current_item, 0) self.treeWidget_kind.setCurrentItem(current_item, 0) elif action == button3: if current_item is None: return id = int(current_item.text(1)) condition = {'autoid': id} self.SC.delete_data(5, condition) self.get_kind_list() @pyqtSlot(QTreeWidgetItem, int) def on_treeWidget_kind_itemChanged(self, qtreeitem, p_int): if self.treeWidget_kind.isPersistentEditorOpen(qtreeitem, p_int): self.treeWidget_kind.closePersistentEditor(qtreeitem, p_int) id = int(qtreeitem.text(1)) new_kindname = qtreeitem.text(0) condition = {'autoid': id} kwargs = {'kindname': new_kindname} self.SC.update_data(5, condition, **kwargs) @pyqtSlot(QTreeWidgetItem, QTreeWidgetItem) def on_treeWidget_kind_currentItemChanged(self, qtreeitem, qtreeitem_1): if self.treeWidget_kind.isPersistentEditorOpen(qtreeitem_1, 0): self.treeWidget_kind.closePersistentEditor(qtreeitem_1, 0) id = int(qtreeitem_1.text(1)) new_kindname = qtreeitem_1.text(0) condition = {'autoid': id} kwargs = {'kindname': new_kindname} self.SC.update_data(5, condition, **kwargs) @pyqtSlot(QTreeWidgetItem, int) def on_treeWidget_kind_itemDoubleClicked(self, qtreeitem, p_int): self.treeWidget_kind.openPersistentEditor(qtreeitem, p_int) @pyqtSlot(QPoint) def on_treeWidget_detail_customContextMenuRequested(self, pos): if self.power[1] == '0': return sender_widget = self.sender() current_item = sender_widget.currentItem() menu = QMenu() button1 = menu.addAction("增加记录") button2 = menu.addAction("修改记录") button3 = menu.addAction("删除记录") global_pos = sender_widget.mapToGlobal(pos) action = menu.exec(global_pos) if action == button1: detail = EditSupplyerDetailModule(parent=self) detail.accepted.connect(self.get_supplyer_list) detail.show() elif action == button2: if current_item is None: return id = int(current_item.text(0)) detail = EditSupplyerDetailModule(id, self) detail.accepted.connect(self.get_supplyer_list) detail.show() elif action == button3: if current_item is None: return id = int(current_item.text(0)) condition = {'autoid': id} condition_2 = {'spid': id} condition_3 = {'scid': id, 'kind': 0} self.SC.delete_data(4, condition_2) self.SC.delete_data(0, condition) img_id_list = self.IC.get_data(0, True, *VALUES_TUPLE_IM, **condition_3) condition_4 = {'autoid__in': img_id_list} self.IC.delete_data(1, condition_4) self.IC.delete_data(0, condition_3) self.get_supplyer_list()
class StuffSupplyerModule(QDialog, Ui_Dialog): def __init__(self, autoid=None, sdid=None, parent=None): super(StuffSupplyerModule, self).__init__(parent) self.setupUi(self) # 修改前数据,若为新建则为空 self.ori_detail = object # 修改后的数据,自动把修改过的数据添加到字典中, # 若恢复原来的数据或者删除,则字典中也删除 self.new_detail = {} # 物料字典中的autoid,由生成界面时传入 self.sdid = sdid # 物料供应商的autoid,仅修改记录时才有值传入 self.autoid = autoid # 数据库操作类 self.SC = SupplyerController() return_row = ('autoid', 'supid', 'supname') condition_key = ('supid', 'supname', 'inputcode') treeheader_name = ["id", "编号", "名称"] self.lineEdit_supplyer.setup( 'Supplyer', return_row, condition_key, treeheader_name, None, 500, 180 ) self.get_detail() def get_detail(self): if self.autoid is None: return condition = {'autoid': self.autoid} res = self.SC.get_data(1, False, **condition) if len(res) != 1: return self.ori_detail = res[0] self.lineEdit_supplyer.setText( self.ori_detail.spid.supid + ' ' + self.ori_detail.spid.supname ) self.lineEdit_producer.setText(self.ori_detail.producer) @pyqtSlot(object) def on_lineEdit_supplyer_getItem(self, qtreeitem): spid = int(qtreeitem.text(0)) try: if spid != self.ori_detail.spid_id: self.new_detail['spid_id'] = spid else: try: del self.new_detail['spid_id'] except KeyError: pass except (KeyError, AttributeError): self.new_detail['spid_id'] = spid @pyqtSlot(str) def on_lineEdit_producer_textChanged(self, p_str): try: if p_str != self.ori_detail.producer: self.new_detail['producer'] = p_str else: try: del self.new_detail['producer'] except KeyError: pass except (KeyError, AttributeError): self.new_detail['producer'] = p_str # 确认 @pyqtSlot() def on_pushButton_accept_clicked(self): # autoid不为空,则为修改记录 # 否则为插入记录 if self.autoid: condition = {'autoid': self.autoid} self.SC.update_data(1, condition, **self.new_detail) else: # 把sdid加到更新内容里 if self.sdid: self.new_detail['sdid_id'] = self.sdid self.SC.update_data(1, **self.new_detail) self.accept() # 取消 @pyqtSlot() def on_pushButton_cancel_clicked(self): self.close()
class EditStuffDetailModule(QDialog, Ui_Dialog): def __init__(self, autoid=None, parent=None): super(EditStuffDetailModule, self).__init__(parent) self.setupUi(self) self.autoid = autoid self.SC = StuffController() self.LC = LabrecordsController() self.PC = ProductController() self.SPC = SupplyerController() self.ori_detail = {} self.new_detail = {} self.get_detail() if len(self.ori_detail): stufftype = self.ori_detail['stufftype'] if stufftype == 1: self.tab.removeTab(4) self.tab.removeTab(1) else: self.tab.removeTab(3) self.tab.removeTab(2) self.get_formula() self.get_checkitem(0, self.treeWidget_checkitem) self.get_checkitem(2, self.treeWidget_precheckitem) self.get_stuffsupplyer() def get_detail(self): if self.autoid is None: self.tab.setTabVisible(1, False) self.tab.setTabVisible(2, False) self.tab.setTabVisible(3, False) self.tab.setTabVisible(4, False) return condition = {'autoid': self.autoid} res = self.SC.get_data(0, False, *VALUES_TUPLE_SD, **condition) if len(res) != 1: return self.ori_detail = res[0] self.comboBox_stufftype.setCurrentIndex(self.ori_detail['stufftype']) self.lineEdit_stuffid.setText(self.ori_detail['stuffid']) self.lineEdit_stuffname.setText(self.ori_detail['stuffname']) self.lineEdit_kind.setText(self.ori_detail['kind']) self.lineEdit_allowno.setText(self.ori_detail['allowno']) self.lineEdit_inputcode.setText(self.ori_detail['inputcode']) self.lineEdit_spec.setText(self.ori_detail['spec']) self.comboBox_packageLv.setCurrentIndex(self.ori_detail['packagelv']) self.lineEdit_package.setText(self.ori_detail['package']) self.comboBox_midcheckunit.setCurrentText( self.ori_detail['midcheckunit']) self.comboBox_prodcheckunit.setCurrentText( self.ori_detail['prodcheckunit']) self.lineEdit_expired.setText(str(self.ori_detail['expireddays'])) self.lineEdit_storage.setText(self.ori_detail['storage']) self.lineEdit_lowlimit.setText(str(self.ori_detail['lowlimit'])) self.lineEdit_upperlimit.setText(str(self.ori_detail['upperlimit'])) self.lineEdit_recheck.setText(str(self.ori_detail['countercheckdays'])) self.lineEdit_cunit.setText(self.ori_detail['cunit']) def get_checkitem(self, itemtype, tree): tree.clear() condition = {'stuffid': self.autoid, 'itemtype': itemtype} res = self.LC.get_data(4, False, *VALUES_TUPLE_CI, **condition). \ order_by('seqid') if not len(res): return for item in res: qtreeitem = QTreeWidgetItem(tree) qtreeitem.setText(0, str(item['autoid'])) qtreeitem.setText(1, str(item['seqid'])) qtreeitem.setText(2, item['kind']) qtreeitem.setText(3, item['itemname']) qtreeitem.setText(4, item['referencevalue']) qtreeitem.setText(5, RESTYPE[item['restype']]) qtreeitem.setText(6, PUTINTYPE[item['putintype']]) for i in range(1, 7): tree.resizeColumnToContents(i) def get_formula(self): if self.autoid is None: return self.treeWidget_formula.clear() condition = {'prodid': self.autoid, 'prodtype': 1} res = self.PC.get_data(6, False, *VALUES_TUPLE_FL, **condition) if not len(res): return for item in res: qtreeitem = QTreeWidgetItem(self.treeWidget_formula) qtreeitem.setText(0, str(item['autoid'])) qtreeitem.setText(1, STUFFTYPE[item['stufftype']]) qtreeitem.setText(2, item['stuffkind']) qtreeitem.setText(3, item['formula']) qtreeitem.setText(4, item['presexpression']) qtreeitem.setText(5, item['presunit']) qtreeitem.setText(6, item['pracexpression']) qtreeitem.setText(7, item['pracunit']) qtreeitem.setText(8, item['drawexpression']) qtreeitem.setText(9, item['drawunit']) qtreeitem.setText(10, str(item['precision'])) qtreeitem.setText(11, str(item['loss']) + "%") for i in range(1, 12): self.treeWidget_formula.resizeColumnToContents(i) def get_stuffsupplyer(self): self.treeWidget_stuffsupplyer.clear() condition = {'sdid_id': self.autoid} res = self.SPC.get_data(1, **condition) if not len(res): return for item in res: qtreeitem = QTreeWidgetItem(self.treeWidget_stuffsupplyer) qtreeitem.setText(0, str(item.autoid)) qtreeitem.setText(1, item.spid.supid) qtreeitem.setText(2, item.spid.supname) qtreeitem.setText(3, item.producer) for i in range(1, 4): self.treeWidget_stuffsupplyer.resizeColumnToContents(i) @pyqtSlot(QTreeWidgetItem, int) def on_treeWidget_precheckitem_itemDoubleClicked(self, p_int): self.on_checkitem_itemDoubleClicked(self.treeWidget_precheckitem, 2) @pyqtSlot(QTreeWidgetItem, int) def on_treeWidget_checkitem_itemDoubleClicked(self, p_int): self.on_checkitem_itemDoubleClicked(self.treeWidget_checkitem, 0) # 原料检验项目,双击打开详细信息 def on_checkitem_itemDoubleClicked(self, tree, itemtype): # if self.power[1] == '0': # return detail = SetCheckItem(self, tree.currentItem().text(0)) detail.accepted.connect(lambda: self.get_checkitem(itemtype, tree)) detail.show() @pyqtSlot(QPoint) def on_treeWidget_precheckitem_customContextMenuRequested(self, pos): self.on_checkitem_customContextMenuRequested( self.treeWidget_precheckitem, 2, pos) @pyqtSlot(QPoint) def on_treeWidget_checkitem_customContextMenuRequested(self, pos): self.on_checkitem_customContextMenuRequested(self.treeWidget_checkitem, 0, pos) # 检验项目的右键菜单功能 def on_checkitem_customContextMenuRequested(self, tree, itemtype, pos): # if self.power[1] == '0': # return menu = QMenu() button1 = menu.addAction("增加") button2 = menu.addAction("修改") button3 = menu.addAction("删除") button4 = menu.addAction("复制") button5 = menu.addAction("黏贴") global_pos = tree.mapToGlobal(pos) action = menu.exec(global_pos) # 增加 if action == button1: set_check_item = SetCheckItem(self, prodid=self.autoid, itemtype=itemtype) set_check_item.accepted.connect( lambda: self.get_checkitem(itemtype, tree)) set_check_item.show() # 修改 elif action == button2: current_item = tree.currentItem() if current_item is None: return id = int(current_item.text(0)) set_check_item = SetCheckItem(self, autoid=id) set_check_item.accepted.connect( lambda: self.get_checkitem(itemtype, tree)) set_check_item.show() # 删除 elif action == button3: select_item = tree.selectedItems() checkitem_autoid = [] for item in select_item: checkitem_autoid.append(item.text(0)) condition = {'autoid__in': checkitem_autoid} self.LC.delete_data(4, condition) self.get_checkitem(itemtype, tree) # 复制 elif action == button4: clipboard = QApplication.clipboard() items = tree.selectedItems() select_item = tree.mimeData(items) clipboard.setMimeData(select_item) # 黏贴 elif action == button5: try: clipboard = QApplication.clipboard() data = clipboard.mimeData() # 获取当前行数,加1即为新的行号 count = tree.topLevelItemCount() res = tree.dropMimeData(tree.invisibleRootItem(), count + 1, data, Qt.CopyAction) finnal_index = tree.topLevelItemCount() if res: while count < finnal_index: tree_item = tree.topLevelItem(count) if tree_item is None: raise AttributeError detail = dict() detail["seqid"] = tree_item.text(1) detail["kind"] = tree_item.text(2) detail["itemname"] = tree_item.text(3) detail["referencevalue"] = tree_item.text(4) detail["restype"] = RESTYPE.index(tree_item.text(5)) detail["putintype"] = PUTINTYPE.index( tree_item.text(6)) detail["stuffid"] = self.autoid detail["itemtype"] = itemtype new_item = self.LC.update_data(4, **detail) tree_item.setText(0, str(new_item.autoid)) count += 1 except Exception as e: pass else: pass @pyqtSlot(QPoint) def on_treeWidget_formula_customContextMenuRequested(self, pos): # if self.power[1] == '0': # return current_item = self.treeWidget_formula.currentItem() menu = QMenu() action_1 = menu.addAction("增加") action_2 = menu.addAction("修改") action_3 = menu.addAction("删除") global_pos = self.treeWidget_formula.mapToGlobal(pos) action = menu.exec(global_pos) if action == action_1: detail = EditFormulaModule(prodid=self.autoid, prodtype=1, parent=self) detail.accepted.connect(self.get_formula) detail.show() elif action == action_2: if current_item is None: return id = int(current_item.text(0)) detail = EditFormulaModule(autoid=id, parent=self) detail.accepted.connect(self.get_formula) detail.show() elif action == action_3: if current_item is None: return id = int(current_item.text(0)) condition = {'autoid': id} self.PC.delete_data(6, condition) self.get_formula() @pyqtSlot(QTreeWidgetItem, int) def on_treeWidget_formula_itemDoubleClicked(self, qtreeitem, p_int): # if self.power[1] == '0': # return id = int(qtreeitem.text(0)) detail = EditFormulaModule(autoid=id, parent=self) detail.accepted.connect(self.get_formula) detail.show() @pyqtSlot(QTreeWidgetItem, int) def on_treeWidget_stuffsupplyer_itemDoubleClicked(self, qtreeitem, p_int): id = int(qtreeitem.text(0)) detail = StuffSupplyerModule(autoid=id, parent=self) detail.accepted.connect(self.get_stuffsupplyer) detail.show() # 物料供应商和生产厂家的右键菜单功能 @pyqtSlot(QPoint) def on_treeWidget_stuffsupplyer_customContextMenuRequested(self, pos): # 返回调用者的对象 current_item = self.treeWidget_stuffsupplyer.currentItem() menu = QMenu() button1 = menu.addAction("增加") button2 = menu.addAction("修改") button3 = menu.addAction("删除") button4 = menu.addAction("复制") button5 = menu.addAction("黏贴") global_pos = self.treeWidget_stuffsupplyer.mapToGlobal(pos) action = menu.exec(global_pos) # 增加 if action == button1: detail = StuffSupplyerModule(sdid=self.autoid, parent=self) detail.accepted.connect(self.get_stuffsupplyer) detail.show() # 修改 elif action == button2: if current_item is None: return id = int(current_item.text(0)) detail = StuffSupplyerModule(autoid=id, parent=self) detail.accepted.connect(self.get_stuffsupplyer) detail.show() # 删除 elif action == button3: select_item = self.treeWidget_stuffsupplyer.selectedItems() item_autoid = [] for item in select_item: item_autoid.append(int(item.text(0))) self.SPC.delete_data(1, *item_autoid) self.get_stuffsupplyer() # 复制 elif action == button4: clipboard = QApplication.clipboard() # 当前选择的项目 items = self.treeWidget_stuffsupplyer.selectedItems() # 把项目转为Mime对象 select_item = self.treeWidget_stuffsupplyer.mimeData(items) # 把Mime对象存入剪切板 clipboard.setMimeData(select_item) # 黏贴 elif action == button5: clipboard = QApplication.clipboard() # 获取剪切板里的内容 data = clipboard.mimeData() # 获取当前行数,加1即为新的行号 count = self.treeWidget_stuffsupplyer.topLevelItemCount() # dropMineData,把Mime对象转回Qtreeitem # 第一个参数:要添加到的父节点 # 第二个参数:行号 # 第三个参数:Mime数据 res = self.treeWidget_stuffsupplyer.dropMimeData( self.treeWidget_stuffsupplyer.invisibleRootItem(), count + 1, data, Qt.CopyAction) # 黏贴完成后的行数 finnal_index = self.treeWidget_stuffsupplyer.topLevelItemCount() if res: # 把黏贴的数据加入数据库中 # 数据从count到finnal_index即为黏贴的行号 while count < finnal_index: tree_item = self.treeWidget_stuffsupplyer.topLevelItem( count) if tree_item is None: return condition = {'autoid': int(tree_item.text(0))} res = self.SPC.get_data(1, **condition) if len(res) != 1: return ori_data = res[0] detail = dict() detail["spid_id"] = ori_data.spid_id detail["producer"] = ori_data.producer detail["sdid_id"] = self.autoid self.SPC.update_data(1, **detail) count += 1 self.get_stuffsupplyer() else: pass # 修改种类时触发 @pyqtSlot(int) def on_comboBox_stufftype_currentIndexChanged(self, p_int): try: if p_int != int(self.ori_detail['stufftype']): self.new_detail['stufftype'] = p_int else: try: del self.new_detail['stufftype'] except KeyError: pass except KeyError: self.new_detail['stufftype'] = p_int # 修改编号时触发 @pyqtSlot(str) def on_lineEdit_stuffid_textChanged(self, p_str): try: if p_str != self.ori_detail['stuffid']: self.new_detail['stuffid'] = p_str else: try: del self.new_detail['stuffid'] except KeyError: pass except KeyError: self.new_detail['stuffid'] = p_str # 修改名称时触发 @pyqtSlot(str) def on_lineEdit_stuffname_textChanged(self, p_str): try: if p_str != self.ori_detail['stuffname']: self.new_detail['stuffname'] = p_str self.lineEdit_inputcode.setText( Inputcode.make_inputcode(p_str)) self.lineEdit_kind.setText(p_str) else: try: del self.new_detail['stuffname'] except KeyError: pass except KeyError: self.new_detail['stuffname'] = p_str # 修改种类时触发 @pyqtSlot(str) def on_lineEdit_kind_textChanged(self, p_str): try: if p_str != self.ori_detail['kind']: self.new_detail['kind'] = p_str else: try: del self.new_detail['kind'] except KeyError: pass except KeyError: self.new_detail['kind'] = p_str # 修改批准文号时触发 @pyqtSlot(str) def on_lineEdit_allowno_textChanged(self, p_str): try: if p_str != self.ori_detail['allowno']: self.new_detail['allowno'] = p_str else: try: del self.new_detail['allowno'] except KeyError: pass except KeyError: self.new_detail['allowno'] = p_str # 修改输入码时触发 @pyqtSlot(str) def on_lineEdit_inputcode_textChanged(self, p_str): try: if p_str != self.ori_detail['inputcode']: self.new_detail['inputcode'] = p_str else: try: del self.new_detail['inputcode'] except KeyError: pass except KeyError: self.new_detail['inputcode'] = p_str # 修改含量规格时触发 @pyqtSlot(str) def on_lineEdit_spec_textChanged(self, p_str): try: if p_str != self.ori_detail['spec']: self.new_detail['spec'] = p_str else: try: del self.new_detail['spec'] except KeyError: pass except KeyError: self.new_detail['spec'] = p_str # 修改包装级别时触发 @pyqtSlot(int) def on_comboBox_packageLv_currentIndexChanged(self, p_int): try: if p_int != self.ori_detail['packagelv']: self.new_detail['packagelv'] = p_int else: try: del self.new_detail['packagelv'] except KeyError: pass except KeyError: self.new_detail['packagelv'] = p_int # 修改包装情况时触发 @pyqtSlot() def on_lineEdit_package_editingFinished(self): p_str = self.lineEdit_package.text() try: if p_str != self.ori_detail['package']: if self.set_package_rate(p_str): self.new_detail['package'] = p_str else: try: del self.new_detail['package'] except KeyError: pass except KeyError: if self.set_package_rate(p_str): self.new_detail['package'] = p_str def set_package_rate(self, package): lv = self.comboBox_packageLv.currentIndex() + 1 items = re.split(r'\*|×|x|X', package) if len(items) != lv: msg = MessageBox(title="错误1!", informative="包装比例错误!") msg.exec() return False num_tuple = ('basicamount', 'spamount', 'mpamount') unit_tuple = ('basicunit', 'spunit', 'mpunit', 'bpunit') try: for i in range(len(items)): values = re.findall(r'\d+|\w+', items[i]) self.new_detail[num_tuple[i]] = values[0] self.new_detail[unit_tuple[i]] = values[1] self.new_detail[unit_tuple[i + 1]] = values[2] return True except: msg = MessageBox(title="错误2!", informative="包装比例错误!") msg.exec() return False # 修改入库单位时触发 @pyqtSlot(str) def on_comboBox_midcheckunit_currentTextChanged(self, p_str): try: if p_str != self.ori_detail['midcheckunit']: self.new_detail['midcheckunit'] = p_str else: try: del self.new_detail['midcheckunit'] except KeyError: pass except KeyError: self.new_detail['midcheckunit'] = p_str # 修改取样单位时触发 @pyqtSlot(str) def on_comboBox_prodcheckunit_currentTextChanged(self, p_str): try: if p_str != self.ori_detail['prodcheckunit']: self.new_detail['prodcheckunit'] = p_str else: try: del self.new_detail['prodcheckunit'] except KeyError: pass except KeyError: self.new_detail['prodcheckunit'] = p_str # 修改库存上限时触发 @pyqtSlot(str) def on_lineEdit_upperlimit_textChanged(self, p_str): p_int = float(p_str) try: if p_int != self.ori_detail['upperlimit']: self.new_detail['upperlimit'] = p_int else: try: del self.new_detail['upperlimit'] except KeyError: pass except KeyError: self.new_detail['upperlimit'] = p_int # 修改库存下限时触发 @pyqtSlot(str) def on_lineEdit_lowlimit_textChanged(self, p_str): p_int = float(p_str) try: if p_int != self.ori_detail['lowlimit']: self.new_detail['lowlimit'] = p_int else: try: del self.new_detail['lowlimit'] except KeyError: pass except KeyError: self.new_detail['lowlimit'] = p_int # 修改复检天数时触发 @pyqtSlot(str) def on_lineEdit_recheck_textChanged(self, p_str): p_int = int(p_str) try: if p_int != self.ori_detail['countercheckdays']: self.new_detail['countercheckdays'] = p_int else: try: del self.new_detail['countercheckdays'] except KeyError: pass except KeyError: self.new_detail['countercheckdays'] = p_int # 修改有效期时触发 @pyqtSlot(str) def on_lineEdit_expired_textChanged(self, p_str): p_int = int(p_str) try: if p_int != self.ori_detail['expireddays']: self.new_detail['expireddays'] = p_int else: try: del self.new_detail['expireddays'] except KeyError: pass except KeyError: self.new_detail['expireddays'] = p_int # 修改效价单位时触发 @pyqtSlot(str) def on_lineEdit_cunit_textChanged(self, p_int): try: if p_int != self.ori_detail['cunit']: self.new_detail['cunit'] = p_int else: try: del self.new_detail['cunit'] except KeyError: pass except KeyError: self.new_detail['cunit'] = p_int # 修改储存条件时触发 @pyqtSlot(str) def on_lineEdit_storage_textChanged(self, p_int): try: if p_int != self.ori_detail['storage']: self.new_detail['storage'] = p_int else: try: del self.new_detail['storage'] except KeyError: pass except KeyError: self.new_detail['storage'] = p_int # 修改生产线和车间时触发 @pyqtSlot() def on_toolButton_workshop_clicked(self): setpl = SetProductLine(parent=self, pltype=1) setpl.select_line_signal.connect(self.setproductline) setpl.show() def setproductline(self, linedetail: dict): try: if linedetail['autoid'] != self.ori_detail['plid']: self.new_detail['plid'] = linedetail['autoid'] self.toolButton_workshop.setText(linedetail['deptname']) self.label_productionline.setText(linedetail['linename']) else: try: del self.new_detail['plid'] except KeyError: pass except KeyError: self.new_detail['plid'] = linedetail['autoid'] self.toolButton_workshop.setText(linedetail['deptname']) self.label_productionline.setText(linedetail['linename']) # 确认 @pyqtSlot() def on_pushButton_accept_clicked(self): if len(self.new_detail): if self.autoid is None: res = self.SC.update_data(0, **self.new_detail) self.autoid = res.autoid else: condition = {'autoiod': self.autoid} self.SC.update_data(0, condition, **self.new_detail) self.accept() # 取消 @pyqtSlot() def on_pushButton_cancel_clicked(self): self.close()