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_())