def refreshReport(self, model, report=None): period = '' model.load(self.reportName, period, self.query, self.fieldList, self.columnsToTotal) def clear(self): widgets = self.findChildren(QWidget) for widget in widgets: if isinstance(widget, (QLineEdit, QTextEdit)): widget.clear() elif isinstance(widget, QComboBox): if widget != self.typeCombo: widget.setCurrentIndex(-1) elif isinstance(widget, QCheckBox): widget.setChecked(False) if self.model is not None: self.model.clear() def formClosed(self): self.myParent.formClosed() if __name__ == '__main__': app = QApplication(sys.argv) setupDatabase("Production.sqlite") supModel = modelsandviews.SupplierModel() form = FindItemForm(supModel) form.show() app.exec_()
def setupUi(self): # setup Models self.supplierModel = modelsandviews.SupplierModel() self.bomModel = modelsandviews.ItemModel('BOM') self.itemModel = modelsandviews.ItemModel('Items') self.baseListModel = modelsandviews.BaseListModel() self.batchListModel = modelsandviews.BatchListModel() self.prepListModel = modelsandviews.PrepListModel() # prepare form variables self.home_form = None self.supplier_form = None self.item_form = None self.receive_form = None self.batch_form = None self.prodprep_form = None self.production_form = None self.inventoryAdj_form = None self.batchAdj_form = None self.findItem_form = None self.find_form = None self.settings_form = None # // prepare other variables self.from_date = QDate().currentDate().toPyDate() self.to_date = QDate().currentDate().toPyDate() self.report_bomId = None accounts = functions.dLookup(databaseschema.Settings.value_1, databaseschema.Settings.setting == 'export_accounts') accounts = accounts.split('|') self.ap_account = accounts[0].strip() self.ap_usAccount = accounts[1].strip() self.inv_account = accounts[2].strip() self.exp_class = accounts[3].strip() self.openWindowDock.show() self.openWindowDock.setObjectName('OpenWindowDock') self.openWindowDock.setAllowedAreas(Qt.LeftDockWidgetArea| Qt.RightDockWidgetArea) self.openWindowList = QListWidget() self.openWindowDock.setWidget(self.openWindowList) self.addDockWidget(Qt.LeftDockWidgetArea, self.openWindowDock) self.openWindowList.clicked.connect(self.dockWindow) importSupplierAction = self.createAction('Import Supplier List', self.importSupplier, None, ':/icons/import', 'Import supplier list from excel') importBOMAction = self.createAction('Import BOM List', self.importBOM, None, ':/icons/import', 'Import Bill Of Material list from excel') importBaseAction = self.createAction('Import Base', self.importBase, None, ':/icons/import', 'Import Bases from excel') importItemAction = self.createAction('Import Item List', self.importItem, None, ':/icons/import', 'Import item list from excel') importReceiveAction = self.createAction('Import Receive', self.importReceive, None, ':/icons/import', 'Import inventory receiving from excel') exportReceiveAction = self.createAction('Export IIF', self.exportReceive, None, ':/icons/export', 'Export receive reports to an IIF file.') setupUserAction = self.createAction('Setup User', self.userSetup, None, ':/icons/settings', 'Setup new user name and password') settingsAction = self.createAction('Preferences', self.settingsForm, None, ':/icons/settings', 'Settings and Tools') utilitiesMenu = self.fileMenu.addMenu('Utilities') self.addActions(utilitiesMenu, (importSupplierAction, importBOMAction, importBaseAction, importItemAction, importReceiveAction, None, exportReceiveAction, None, setupUserAction, settingsAction)) self.fileMenu.insertMenu(self.fileQuitAction, utilitiesMenu) self.fileMenu.insertSeparator(self.fileQuitAction) formHomeAction = self.createAction("Home", self.homeForm, 'Ctrl+H', ":/icons/home", "Go To Home") formSupplierAction = self.createAction("New Supplier", self.supplierForm, None, ":/icons/account", "Add New Supplier") formItemAction = self.createAction("New Item", self.itemForm, None, ":/icons/item", "Add New Item") formReceiveAction = self.createAction("Receive Inventory", self.receiveForm, None, ":/icons/inventory", "Receive Inventory") formProdprepAction = self.createAction('Prepare Production', self.prodprepForm, None, ":/icons/prep", "Prepare A Production") formBatchAction = self.createAction('Create Batch', self.batchForm, None, ':/icons/batch', 'Create A Batch') formBaseAction = self.createAction('Record Base', self.baseForm, None, ':/icons/batch', 'Record A New Base') formProduction = self.createAction('Production', self.productionForm, None, ':/icons/production', 'Record A Production') formInvAdjustment = self.createAction('Adjust Inventory', self.invAdjustment, None, ':/icons/journal', 'Adjust Inventory') formBatchAdjAction = self.createAction('Adjust Batch RM', self.batchAdjForm, None, ':/icons/settings', 'Adjust Raw Materials on a batch before production') formMenu = self.menuBar().addMenu("Form") self.addActions(formMenu, (formHomeAction, formSupplierAction, formItemAction, formReceiveAction, formProdprepAction, formBatchAction, formBaseAction, formProduction, formInvAdjustment, formBatchAdjAction)) findMenu = self.menuBar().addMenu('Find') findItemAction = self.createAction('Find Item', self.findItem, None, ':/icons/find', 'Find Item') findAction = self.createAction('&Find', self.findForm, 'Ctrl+F', ':/icons/search', 'Find Transaction') self.addActions(findMenu, (findItemAction, findAction)) reportInventorySumAction = self.createAction('Inventory Evaluation', self.inventorySumReport, None, ':/icons/report', 'Invenatory Report') reportInventoryDetailAction = self.createAction('Inventory Detail', self.inventoryDetReport, None, ':/icons/report', 'Inventory Detail Report') reportMenu = self.menuBar().addMenu('Reports') self.addActions(reportMenu, (reportInventorySumAction, reportInventoryDetailAction)) self.windowNextAction = self.createAction("&Next", self.mdi.activateNextWindow, QKeySequence.NextChild) self.windowPrevAction = self.createAction("&Previous", self.mdi.activatePreviousWindow, QKeySequence.PreviousChild) self.windowCascadeAction = self.createAction("Casca&de", self.mdi.cascade) self.windowTileAction = self.createAction("&Tile", self.mdi.tile) self.windowRestoreAction = self.createAction("&Restore All", self.windowRestoreAll) self.windowMinimizeAction = self.createAction("&Iconize All", self.windowMinimizeAll) self.windowArrangeIconsAction = self.createAction("&Arrange Icons", self.mdi.arrangeIcons) self.windowCloseAction = self.createAction("&Close", self.mdi.closeActiveWindow, QKeySequence.Close) self.showDockAction = self.createAction('Show Dock Window', self.showDockWindow) formToolBar = self.addToolBar('Forms Toolbar') formToolBar.setObjectName('FormToolBar') self.addActions(formToolBar, (formHomeAction, formSupplierAction, formItemAction, formReceiveAction, formProdprepAction, formBatchAction, formProduction, formBatchAdjAction, formInvAdjustment)) findToolBar = self.addToolBar('Find Toolbar') findToolBar.setObjectName('FindToolBar') self.addActions(findToolBar, (findItemAction, findAction)) self.windowMapper = QSignalMapper(self) self.connect(self.windowMapper, SIGNAL("mapped(QWidget*)"), self.mdi, SLOT("setActiveWindow(QWidget*)")) self.windowMenu = self.menuBar().addMenu("&Window") self.connect(self.windowMenu, SIGNAL("aboutToShow()"), self.updateWindowMenu) helpMenu = self.menuBar().addMenu('Help') aboutAction = self.createAction('&About Production Program', self.helpAbout) self.addActions(helpMenu, (aboutAction,)) self.homeForm() self.updateWindowMenu()