def exportFileItem(pathFile):
if len(pathFile) == 0:
return
wb = Workbook()
ws = wb.active
data = Database()
listItem = data.getListItem()
for item in listItem:
ws = createSheetAsItem(wb,item)
createTitleTypeItem(ws, item)
addTypeIntoSheet(ws,item.listType)
adjustColumn(ws)
wb.remove_sheet(wb.active)
wb.save(pathFile)
def setupWidget(self):
data = Database()
self.listItem = data.getListItem()
for item in self.listItem:
self.comboItem.addItem(item.name)
self.spinAmount.setMinimum(1)
self.dateTimeEdit.setDisplayFormat("dd/MM/yyyy hh:mm")
date = datetime.datetime.now().date().strftime("%d/%m/%Y")
time = datetime.datetime.now().time().strftime("%H:%M")
# print(date + " " + time)
now = QtCore.QDateTime.fromString(date + " " + time,
"dd/MM/yyyy hh:mm")
self.dateTimeEdit.setDateTime(now)
self.radioUnit.setChecked(True)
self.comboItem.setCurrentIndex(0)
if len(self.listItem) != 0:
self.listType = self.listItem[0].listType
for typeItem in self.listType:
self.comboType.addItem(typeItem.name)
self.comboItem.setCurrentIndex(0)
self.headerID = self.listItem[0].idItem
if len(self.listType) != 0:
self.footerID = self.listType[0].idType
self.editPrice.setText(str(self.listType[0].unitPrice))
self.spinAmount.setMaximum(self.listType[0].amount)
self.onSetImage(self.listType[0].imagePath)
idBill = self.headerID + "-" + self.footerID
self.editID.setText(idBill)
