def setFile(self, date): if not date: date = self.defaultDate() self.filename = os.path.join(get_data_dir(), 'raw', '%s_raw.csv' % date.strftime('%Y%m%d')) if not os.path.exists(self.filename): self.makeFile() logger.info("Uitvoer naar %s" % self.filename)
def exportMultiple(self): files = QtGui.QFileDialog.getOpenFileNames( self, None, os.path.join(get_data_dir(), "raw"), "Ruwe verkoopdata (*.csv)") for file in files: proc = Processor(file).process() logger.info("%s verwerkt" % os.path.basename(file)) if not files: logger.warn("Geen bestanden geselecteerd")
def export(self): date = -1 for f in os.listdir(os.path.join(get_data_dir(), 'raw')): if date < int(f.split('_')[0]): date = int(f.split('_')[0]) if date == -1: return logger.warn("Geen raw rapportage gevonden") proc = Processor( os.path.join(get_data_dir(), 'raw', '%s_raw.csv' % date)) proc.process() os.startfile(proc.outfile) logger.info("Geƫxporteerd naar %s_proc.csv" % str(date))
def save(self, filename=None): if filename: self._filename = filename with open(self._filename, 'w') as f: writer = csv.writer(f, dialect='excel_semicolon') for product in self.products: writer.writerow([ product.name, product.price, product.group, product.category ]) logger.info("%d producten naar database weggeschreven" % len(self.products))
def __init__(self, filename=""): self.products = [] if not os.path.exists(filename): logger.warn("Productdatabase niet gevonden (%s)" % filename) return self._filename = os.path.abspath(filename) with open(self._filename, 'r') as f: reader = csv.reader(f, dialect='excel_semicolon') for row in reader: if len(row) != 4: continue product = Product(row[0], row[1], row[2], row[3]) self.products.append(product) num_products = len(self.products) if num_products: logger.info("%d producten uit database ingeladen" % num_products) else: logger.warn("Productdatabase is leeg")
logger.info("Geƫxporteerd naar %s_proc.csv" % str(date)) def exportMultiple(self): files = QtGui.QFileDialog.getOpenFileNames( self, None, os.path.join(get_data_dir(), "raw"), "Ruwe verkoopdata (*.csv)") for file in files: proc = Processor(file).process() logger.info("%s verwerkt" % os.path.basename(file)) if not files: logger.warn("Geen bestanden geselecteerd") def manageProducts(self): products = ProductsDialog(self) products.show() if __name__ == "__main__": locale.setlocale(locale.LC_ALL, '') log_dir = os.path.join(get_data_dir(), 'log') logging.init(log_dir) app = QtGui.QApplication(sys.argv) myapp = MainWindow() myapp.show() logger.info("Hallo!") sys.exit(app.exec_())