def aceptar( self ):
fecha = QDate.currentDate()
fecha = QDate( fecha.year(), fecha.month(), fecha.daysInMonth() )
if self.dtPicker.date() > fecha:
QMessageBox.information( None, "Cuentas Bancarias", "La cuenta seleccionada ya fue conciliada" )
else:
return self.accept()
def __init__(self, parent=None):
super(NewEntryDialog, self).__init__(parent)
loadUi(__file__, self)
# General window settings
self.monthTab = parent.currentMonthTab()
self.setWindowTitle('New Entry for \'%s\'' % self.monthTab.month())
self.setFixedSize(self.size())
# Entry name LineEdit settings
strValidator = QRegExpValidator(QRegExp('.+'))
self.nameLineEdit.setValidator(strValidator)
completer = QCompleter(self.monthTab.entriesStringList())
completer.setCaseSensitivity(Qt.CaseInsensitive)
self.nameLineEdit.setCompleter(completer)
# DateEdit settings
date = QDate(parent.year(), self.monthTab.monthIndex() + 1, 1)
self.dateEdit.setDateRange(
date, QDate(date.year(), date.month(), date.daysInMonth()))
self.dateEdit.setDate(date)
self.dateEdit.setCalendarPopup(True)
self.dateEdit.calendarWidget().setFirstDayOfWeek(Qt.Monday)
# CategoryComboBox settings
self.categoryComboBox.setModel(self.monthTab.categoriesModel())
# OK PushButton settings
self.okButton = self.buttonBox.button(QDialogButtonBox.Ok)
self.okButton.setEnabled(False)
# CONNECTIONS
self.nameLineEdit.textEdited.connect(self.setOKButton)
def __init__(self, parent):
CItemEditorBaseDialog.__init__(self, parent, 'DloDrugFormulary')
self.addModels('Items', CItemsModel(self))
self.setupUi(self)
self.setWindowFlags(QtCore.Qt.Dialog
| QtCore.Qt.WindowMaximizeButtonHint
| QtCore.Qt.WindowCloseButtonHint)
self.setWindowTitleEx(u'Лекарственный формуляр ДЛО')
self.prepareTable(self.tblItems, self.modelItems)
self.cmbType.addItem(u'Справочник лекарственных средств (ДЛО)')
tmpDate = QDate().currentDate().addMonths(1)
begDate = (QDate(tmpDate.year(), tmpDate.month(), 1))
self.edtBegDate.setDate(begDate)
self.edtEndDate.setDate(begDate.addMonths(1).addDays(-1))
self.setupDirtyCather()
def data(self, index, role=None):
"""return a QVariant saying if exists a payment at index.(row|column)"""
if not index.isValid() or role not in (Qt.DisplayRole,
Qt.CheckStateRole):
return QVariant()
#self.update_db_content()
# find the month from the row number
month_year = QDate().fromString(
self.headerData(index.row(), Qt.Vertical, role).toString(),
'MMMM yyyy')
month = month_year.month()
year = month_year.year()
# find the client from the column number
header_infos = self.headerData(index.column(), Qt.Horizontal,
role).toString().split('\n')
client = header_infos[0]
machine = header_infos[1]
selldate = QDate.fromString(header_infos[2], 'd MMMM yyyy')
deltamonth = int(header_infos[3][5:-5]) # [len('Ogni '):-len(' mesi')]
anticiped = header_infos[4][10:-6] == 'anti' # 'Pagamento ':-'cipato'
query = QSqlQuery(
'SELECT expected_datepayd, effective_datepayd FROM '
'payments WHERE clients_client = :client AND clients_machine = '
':machine AND clients_selldate = :selldate AND '
'expected_datepayd BETWEEN :datebefore AND :dateafter', self._db)
query.bindValue(':client', QVariant(client))
query.bindValue(':machine', QVariant(machine))
query.bindValue(':selldate', QVariant(selldate))
# primo giorno del mese
d = QDate(year, month, 1)
query.bindValue(':datebefore', QVariant(d))
# ultimo giorno del mese
query.bindValue(':dateafter', QVariant(d.addMonths(1).addDays(-1)))
if not query.exec_():
raise StandardError('SYNTAX ERROR')
if not query.first():
return QVariant()
expected_datepayd = query.value(0).toDate()
payed = not query.isNull(1)
effective_datepayd = query.value(1).toDate()
if role == Qt.CheckStateRole:
return QVariant(Qt.Checked if payed else Qt.Unchecked)
else: # DisplayRole
date = effective_datepayd if payed else expected_datepayd
return QVariant(date.toString('d MMMM yyyy'))
def __init__(self, parent):
CItemEditorBaseDialog.__init__(self, parent, 'DrugFormulary')
self.addModels('Items', CItemsModel(self))
self.setupUi(self)
self.setWindowFlags(QtCore.Qt.Dialog
| QtCore.Qt.WindowMaximizeButtonHint
| QtCore.Qt.WindowCloseButtonHint)
self.setWindowTitleEx(u'Лекарственный формуляр')
self.prepareTable(self.tblItems, self.modelItems)
self.cmbType.addItems(
[u'Формуляр отделение', u'Наркотики', u'Расходные материалы'])
tmpDate = QDate().currentDate().addMonths(1)
begDate = (QDate(tmpDate.year(), tmpDate.month(), 1))
self.edtBegDate.setDate(begDate)
self.edtEndDate.setDate(begDate.addMonths(1).addDays(-1))
self.chkIsActive.setChecked(True)
self.setupDirtyCather()
