Exemple #1
0
 def setupDB(self, filename):
     try:
         databaseschema.setupDatabase(filename)
         self.filename = filename
     except NotImplementedError:
         QMessageBox.information(self, 'Log In - Open production file', 'Wrong file!!!', QMessageBox.Ok)
         return False
     except exc.ArgumentError:
         QMessageBox.information(self, '%s - Open database', 'Could not successfully open new database.', QMessageBox.Ok)
         return False
     
     db_version = functions.dLookup(databaseschema.Settings.value_1, databaseschema.Settings.setting == '__version__')
     if not db_version:
         QMessageBox.information(self, 'Open Database', 'v: %s, db: %s \n Wrong Database File, ' \
                                 'please contact administrator' % (__version__, db_version),
                                  QMessageBox.Ok) 
         self.closeDB()
         return False
     
     elif db_version != __version__:
         progress = QProgressDialog('Updating File', 'Cancel', 0, 100)
         progress.setCancelButton(None)
         progress.show()
         progress.setValue(50)
         functions.updateDb(progress, __version__, db_version)
         return True
     else:
         return True
Exemple #2
0
 def showLogIn(self, filename):
     """ decide whether to whow the log in dialog based if there are users setup in the database."""
     # // check if there is a filename to open the database, if not we are done
     if not filename:
         return
     # // now even if there is a filename we still need to check if that file exists
     # // otherwise sqlalchemy will just create a new database, and we like control
     try:
         with open(filename) : pass
     except:
         self.filename = None
         return
     # // if we are all happy, there is a filename and it exists, lets go ahead and connect to database.
     ok = self.setupDB(filename)
     if not ok:
         return
     # // now lets check if there are any users in the database, to decide whether we should show log in
     users = orm.Session().query(databaseschema.Users).count()
     if users < 1:
         self.setGoAhead(True)
     else:
         self.logIn()
     # // the log will give the go ahead if user id and password match
     # // no we want to setup the rest of the ui for the main window, 
     # // provided we have a go ahead, and the ui has not yet been setup
     self.setWindowTitle('%s - (%s), (%s)' % (TITLE, ntpath.basename(self.filename),
                          functions.dLookup(databaseschema.Users.user_name, databaseschema.Users.user_id==self.user_id)))
     if self.go_ahead and self.ui_setup:
         self.setupUi()
         self.ui_setup = False
Exemple #3
0
 def helpAbout(self):
     db_v = functions.dLookup(databaseschema.Settings.value_1, databaseschema.Settings.setting=='__version__')
     QMessageBox.about(self, "About Production Program",
             """<b>Production Program</b> v {0}, db_v {1}
             <p>Copyright &copy; 2013 YF Consulting Inc. 
             All rights reserved.
             <p>This application should be used to calculate Costs of manufactured products and for Bill of material Inventory Control.
             <p>Python {2} - Qt {3} - PyQt {4}  - SQLAlchemy {5} on {6}""".format(
             __version__, db_v, platform.python_version(),
             QT_VERSION_STR, PYQT_VERSION_STR, sqlalchemy.__version__, 
             platform.system()))
Exemple #4
0
 def reportSettings(self, report, parent=None):
     dialog = reports.ReportDialog(self.bomModel)
     from_date = self.from_date if self.from_date else QDate().currentDate()
     to_date = self.to_date if self.to_date else QDate().currentDate()
     dialog.from_date.setDate(from_date)
     dialog.to_date.setDate(to_date)
     bom_no = functions.dLookup(databaseschema.BOM.bom_no, databaseschema.BOM.bom_id==self.report_bomId)
     bom_index = dialog.bom_comboBox.findText(str(bom_no), Qt.MatchExactly) \
                     if self.report_bomId else -1
     dialog.bom_comboBox.setCurrentIndex(bom_index)
     if dialog.exec_():
         self.from_date = dialog.from_date.date().toPyDate()
         self.to_date = dialog.to_date.date().toPyDate()
         if dialog.range_comboBox.currentText() == 'All':
             self.from_date = None
             self.to_date = None
         bom_no = str(dialog.bom_comboBox.currentText())
         self.report_bomId = functions.dLookup(databaseschema.BOM.bom_id, databaseschema.BOM.bom_no==bom_no)
         if parent:
             parent.refresh()
Exemple #5
0
    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()