예제 #1
0
    def calc(self):

        if self.calcTimeStart:
            tdelta = datetime.now() - self.calcTimeStart
            timeSum = self.calcTimeSum + tdelta
        else:
            timeSum = self.calcTimeSum

        self.timeEdit.setTime(self.timedelta2qtime(timeSum))

        startBalance = self.removeFormat(self.startBalance.text())
        if guitools.isInt(startBalance):
            startBalance = int(startBalance)
        else:
            return

        currentBalance = self.removeFormat(self.currentBalance.text())
        if guitools.isInt(currentBalance):
            currentBalance = int(currentBalance)
        else:
            return

        totalProfit = currentBalance - startBalance
        self.totalProfit.setText(self.formatImput(totalProfit))

        if timeSum.total_seconds() <= 0:
            return

        hourProfit = (totalProfit / timeSum.total_seconds()) * 60 * 60
        hourProfit = int(round(hourProfit, 0))

        self.hourProfit.setText(self.formatImput(hourProfit))

        cargoSpace = self.removeFormat(self.cargoSpace.text())
        if guitools.isInt(cargoSpace):
            cargoSpace = int(cargoSpace)
        else:
            return

        cargoProfit = totalProfit / cargoSpace
        self.tonProfit.setText(self.formatImput(int(round(cargoProfit, 0))))

        cargoHourProfit = (cargoProfit / timeSum.total_seconds()) * 60 * 60
        self.tonHourProfit.setText(
            self.formatImput(int(round(cargoHourProfit, 0))))
예제 #2
0
    def calc(self):

        if self.calcTimeStart:
            tdelta = datetime.now() - self.calcTimeStart
            timeSum = self.calcTimeSum + tdelta
        else:
            timeSum = self.calcTimeSum

        self.timeEdit.setTime( self.timedelta2qtime(timeSum) )

        startBalance = self.removeFormat(self.startBalance.text())
        if guitools.isInt( startBalance ):
            startBalance = int( startBalance )
        else:
            return

        currentBalance = self.removeFormat(self.currentBalance.text())
        if guitools.isInt(currentBalance):
            currentBalance = int(currentBalance)
        else:
            return

        totalProfit = currentBalance - startBalance
        self.totalProfit.setText( self.formatImput(totalProfit) )

        if timeSum.total_seconds() <= 0:
            return

        hourProfit = ( totalProfit / timeSum.total_seconds() ) * 60 * 60
        hourProfit = int(round(hourProfit, 0))

        self.hourProfit.setText( self.formatImput(hourProfit) )

        cargoSpace = self.removeFormat(self.cargoSpace.text())
        if guitools.isInt(cargoSpace):
            cargoSpace = int(cargoSpace)
        else:
            return

        cargoProfit = totalProfit / cargoSpace
        self.tonProfit.setText( self.formatImput( int(round(cargoProfit, 0)) ) )

        cargoHourProfit = ( cargoProfit / timeSum.total_seconds() ) * 60 * 60
        self.tonHourProfit.setText( self.formatImput(int(round(cargoHourProfit, 0))) )
    def saveItems(self):
        self.parent.lockDB()
        failColor = QtGui.QColor(255, 0, 0, 180)
        system = self.systemLineEdit.text()
        systemID = self.mydb.getSystemIDbyName(system)
    
        station = self.stationLineEdit.text()
        stationID = self.mydb.getStationID(systemID, station)
        if not stationID:
            self.parent.unlockDB()
            return
        cur = self.mydb.cursor()
        modifiedDate = datetime.utcnow()
        
        for row in range(0, self.tableWidget.rowCount()):
            itemID = self.getSelectedItemId(row)
            stationBuy = self.tableWidget.item(row, self.headerList.index("Sell")).text()
            stationSell = self.tableWidget.item(row, self.headerList.index("Buy")).text()
            stock = self.tableWidget.item(row, self.headerList.index("Stock")).text()

            if not itemID or not guitools.isInt( stationBuy ) or not guitools.isInt( stationSell ) or not guitools.isInt( stock ):
                #print("fail", stationBuy, stationSell, stock)
                if not guitools.isInt( stationBuy ):
                    self.tableWidget.item(row, self.headerList.index("Sell")).setBackground( failColor )
                if not guitools.isInt( stationSell ):
                    self.tableWidget.item(row, self.headerList.index("Buy")).setBackground( failColor )
                if not guitools.isInt( stock ):
                    self.tableWidget.item(row, self.headerList.index("Stock")).setBackground( failColor )

                self.tableWidget.dataChanged(self.tableWidget.indexFromItem(self.tableWidget.item(row, 0)),
                                             self.tableWidget.indexFromItem(self.tableWidget.item(row, len(self.headerList))))

                msg = "Save Fail"
                msgBox = QtGui.QMessageBox(QtGui.QMessageBox.Information, "Error", msg,
                        QtGui.QMessageBox.NoButton, self)
        
                msgBox.exec_()
                self.parent.unlockDB()
                return

            else:

                cur.execute( "UPDATE price SET StationBuy=?, StationSell=?, Stock=?, modified=?, source=6 where StationID=? AND ItemID=?",
                                            (stationBuy, stationSell, stock, modifiedDate, stationID, itemID))

                if cur.rowcount <= 0:
                    print("no update, insert")
                    cur.execute("insert or IGNORE into price (SystemID, StationID, ItemID, StationBuy, StationSell, Stock, modified, source) values (?,?,?,?,?,?,?,6) ",
                                                            (systemID, stationID, itemID, stationBuy, stationSell, stock, modifiedDate))
            
                cur.execute("select id from price where StationID = ? AND ItemID = ? limit 1", ( stationID, itemID))
                priceID = cur.fetchone()[0]

                ''' blackmarket '''
                blackmarkedCheckBox = guitools.getChildByType(self.tableWidget.cellWidget(row, self.headerList.index("Blackmarket")), QtGui.QCheckBox)
                if blackmarkedCheckBox.isChecked():
                    self.mydb.setBlackmarketPrice(priceID)
                else:
                    self.mydb.removeBlackmarketPrice(priceID)

                ''' ignore '''
                ignoreCheckBox = guitools.getChildByType(self.tableWidget.cellWidget(row, self.headerList.index("Ignore")), QtGui.QCheckBox)
                if ignoreCheckBox.isChecked():
                    self.mydb.setIgnorePriceTemp(priceID)
                else:
                    self.mydb.removeIgnorePrice(priceID)

                ''' fake '''
                fakeCheckBox = guitools.getChildByType(self.tableWidget.cellWidget(row, self.headerList.index("Fake")), QtGui.QCheckBox)
                if fakeCheckBox.isChecked():
                    self.mydb.setFakePrice(priceID)
                else:
                    self.mydb.removeFakePrice(priceID)

                self.mydb.addSystemsInDistanceToDealsInDistancesCacheQueue(systemID, itemID)

        self.mydb.addSystemToDealsInDistancesCacheQueue( [{'id': systemID}] )
                
        self.mydb.con.commit()
        cur.close()
        self.parent.unlockDB()
예제 #4
0
 def formatImput(self, text):
     if guitools.isInt(self.removeFormat(text)):
         return "{:,}".format(int(self.removeFormat(text)))
     else:
         return text
예제 #5
0
 def formatImput(self, text):
     if guitools.isInt(self.removeFormat(text)):
         return "{:,}".format( int( self.removeFormat(text)))
     else:
         return text