def getEmptyRecord(self):
isFirst = not bool(self.items())
result = CInDocTableModel.getEmptyRecord(self)
result.append(QtSql.QSqlField('diagnosis_id', QtCore.QVariant.Int))
result.append(QtSql.QSqlField('diagnosisType_id', QtCore.QVariant.Int))
result.append(QtSql.QSqlField('speciality_id', QtCore.QVariant.Int))
result.append(QtSql.QSqlField('person_id', QtCore.QVariant.Int))
result.append(QtSql.QSqlField('dispanser_id', QtCore.QVariant.Int))
result.append(QtSql.QSqlField('hospital', QtCore.QVariant.Int))
result.append(QtSql.QSqlField('healthGroup_id', QtCore.QVariant.Int))
result.append(QtSql.QSqlField('setDate', QtCore.QVariant.DateTime))
result.append(QtSql.QSqlField('endDate', QtCore.QVariant.DateTime))
result.append(QtSql.QSqlField('payStatus', QtCore.QVariant.Int))
result.setValue('diagnosisType_id',
QtCore.QVariant(self.getDiagnosisTypeId(isFirst)))
if isFirst:
if self._parent.inheritResult == True:
result.setValue(
'result_id',
toVariant(
CEventEditDialog.defaultDiagnosticResultId.get(
self._parent.eventPurposeId)))
else:
result.setValue('result_id', toVariant(None))
return result
def getEmptyRecord(self):
newRecord = super(CDestinationsModel, self).getEmptyRecord()
for col in self._cols:
newRecord.append(QtSql.QSqlField(col.fieldName()))
for col in self._hiddenCols:
newRecord.append(QtSql.QSqlField(col))
return newRecord
def get_record(tooth_id, section, state_id):
rec = QtSql.QSqlRecord()
rec.append(QtSql.QSqlField('id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('tooth_id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('section', QtCore.QVariant.String))
rec.append(QtSql.QSqlField('state_id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('deleted', QtCore.QVariant.Bool))
rec.setValue('tooth_id', tooth_id)
rec.setValue('section', section)
rec.setValue('state_id', state_id)
return rec
def handle_rcvd_record(self, r):
# Create QSqlRecord object
record = QtSql.QSqlRecord()
record.append(QtSql.QSqlField("timestamp"))
record.append(QtSql.QSqlField("component"))
record.append(QtSql.QSqlField("verbosity"))
record.append(QtSql.QSqlField("message"))
record.setValue(0, r['asctime'])
record.setValue(1, r['module'])
record.setValue(2, r['levelname'])
record.setValue(3, r['message'])
# Insert record
self.insert_record(record)
def run(self):
# Parse log message
ts, verb, comp, msg = self.parse_logmsg()
# Create record
record = QtSql.QSqlRecord()
record.append(QtSql.QSqlField("timestamp"))
record.append(QtSql.QSqlField("component"))
record.append(QtSql.QSqlField("verbosity"))
record.append(QtSql.QSqlField("message"))
record.setValue(0, ts)
record.setValue(1, comp)
record.setValue(2, verb)
record.setValue(3, msg)
# Insert record
self.parent.insertRecordSignal.emit(record)
def newRecord(self, fields=None, otherRecord=None):
record = QtSql.QSqlRecord()
for field in self.fields:
if fields and field.field.name() not in fields:
continue
record.append(QtSql.QSqlField(field.field))
if otherRecord and otherRecord.contains(field.field.name()) and field != self._idField:
record.setValue(field.field.name(), otherRecord.value(field.field.name()))
return record
def addItems(self, issueFormList):
self.removeRows(0, len(self._items))
for issueForm in issueFormList:
newRecord = super(CIssueFormTableModel, self).getEmptyRecord()
for col in self._cols:
newRecord.append(QtSql.QSqlField(col.fieldName()))
if col.fieldName() == 'issueForm':
newRecord.setValue(col.fieldName(), issueForm)
self.addRecord(newRecord)
def addItems(self, mnnList):
self.removeRows(0, len(self._items))
for mnn in mnnList:
newRecord = super(CMNNTableModel, self).getEmptyRecord()
for col in self._cols:
newRecord.append(QtSql.QSqlField(col.fieldName()))
if col.fieldName() == 'mnn':
newRecord.setValue(col.fieldName(), mnn)
self.addRecord(newRecord)
def prepareDiagnostics(self, eventTypeId):
includedGroups = []
db = QtGui.qApp.db
tableEventTypeDiagnostic = db.table('EventType_Diagnostic')
tableEvenType = db.table('EventType')
records = QtGui.qApp.db.getRecordList(tableEventTypeDiagnostic.innerJoin(tableEvenType, tableEvenType['id'].eq(tableEventTypeDiagnostic['eventType_id'])),
cols=['EventType_Diagnostic.*', tableEvenType['scene_id']],
where=tableEventTypeDiagnostic['eventType_id'].eq(eventTypeId),
order=[tableEventTypeDiagnostic['idx'], tableEventTypeDiagnostic['id']])
model = self.__modelDiagnostics
self.boolPersonSpecialityId = False if len(records) else True
for record in records:
if self.recordAcceptable(record):
target = model.getEmptyRecord()
target.append(QtSql.QSqlField('scene_id', QtCore.QVariant.Int))
target.append(QtSql.QSqlField('defaultHealthGroup_id', QtCore.QVariant.Int))
target.append(QtSql.QSqlField('defaultMedicalGroup_id', QtCore.QVariant.Int))
target.append(QtSql.QSqlField('defaultMKB', QtCore.QVariant.String))
target.setValue('speciality_id', record.value('speciality_id'))
target.setValue('visitType_id', record.value('visitType_id'))
target.setValue('actuality', record.value('actuality'))
target.setValue('selectionGroup', record.value('selectionGroup'))
target.setValue('defaultHealthGroup_id', record.value('defaultHealthGroup_id'))
target.setValue('defaultMedicalGroup_id', record.value('defaultMedicalGroup_id'))
target.setValue('defaultMKB', record.value('defaultMKB'))
target.setValue('defaultGoal_id', record.value('defaultGoal_id'))
target.setValue('service_id', record.value('service_id'))
target.setValue('scene_id', record.value('scene_id'))
selectionGroup = forceInt(record.value('selectionGroup'))
if selectionGroup <= 0:
target.setValue('include', QtCore.QVariant(0))
elif selectionGroup == 1:
target.setValue('include', QtCore.QVariant(1))
elif selectionGroup in includedGroups :
target.setValue('include', QtCore.QVariant(0))
else:
if forceRef(record.value('speciality_id')) == self.personSpecialityId:
target.setValue('include', QtCore.QVariant(1))
includedGroups.append(selectionGroup)
if forceRef(record.value('speciality_id')) == self.personSpecialityId:
self.boolPersonSpecialityId = True
model.items().append(target)
model.reset()
def _saveToSqlRecord(sqlRecordInfo, record, sourceData):
for fieldName in sqlRecordInfo.keys():
if not record.contains(
fieldName) and sqlRecordInfo[fieldName][0] is not None:
record.append(
QtSql.QSqlField(fieldName, sqlRecordInfo[fieldName][0]))
# получение значение поля через соответствующее свойство (указанное в _sqlRecordInfo)
value = sqlRecordInfo[fieldName][1].__get__(sourceData)
record.setValue(fieldName, toVariant(value))
return record
def empty_record():
rec = QtSql.QSqlRecord()
rec.append(QtSql.QSqlField('id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('formula_id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('number', QtCore.QVariant.String))
rec.append(QtSql.QSqlField('is_deciduous', QtCore.QVariant.Bool))
rec.append(QtSql.QSqlField('status_id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('mobility', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('deleted', QtCore.QVariant.Bool))
return rec
def __init__(self, database, tableName, field, fieldType=None):
self.database = database # type: CDatabase
self.tableName = tableName
if isinstance(field, QtSql.QSqlField):
self.fieldName = database.escapeFieldName(field.name())
self.field = field
self.isSurrogate = False
elif isinstance(field, (basestring, QString)):
self.fieldName = forceString(field)
self.field = QtSql.QSqlField(
field, fieldType
if isinstance(fieldType, QVariant.Type) else QVariant.String)
self.isSurrogate = True
def getEmptyRecord(self, propertyTypeCellsSettings=None):
if not propertyTypeCellsSettings:
propertyTypeCellsSettings = {}
record = self._table.newRecord()
for col in self._cols:
if not col.fieldName() in self._dbFieldNamesList:
record.append(QtSql.QSqlField(col.fieldName(),
col.valueType()))
for name in self._propertyColsNames:
isActive = propertyTypeCellsSettings.get(name, False)
if not isActive:
record.setValue(name, QtCore.QVariant(u'----'))
return record
def loadItems(self, masterId):
db = QtGui.qApp.db
cols = ['id', 'master_id', 'actionType_id', 'selectionGroup']
table = db.table('rbJobType_ActionType')
cond = [
table['master_id'].eq(masterId),
table['actionType_id'].notInlist(self._existsActionTypeIdList)
]
self._items = db.getRecordList(table, cols, cond, ['id'])
for item in self._items:
item.append(QtSql.QSqlField('checked', QtCore.QVariant.Bool))
item.append(QtSql.QSqlField('amount', QtCore.QVariant.Double))
selectionGroup = forceInt(item.value('selectionGroup'))
groupItemList = self._cacheItemsByGroup.setdefault(
selectionGroup, [])
groupItemList.append(item)
if selectionGroup == 1 or (selectionGroup
and len(groupItemList) == 1):
item.setValue('checked', QtCore.QVariant(True))
self.reset()
def record(self):
"""This method return in a QSqlRecord the fields (rows) of the last query"""
if DEBUG_MODE:
print "$$ -> LlampexResult.record() (crear QSqlRecord())"
info = QtSql.QSqlRecord()
if not self.isActive() or not self.isSelect():
return info
global pg2qttype
for field in self.fields:
f = QtSql.QSqlField(field[0], pg2qttype[field[1]])
info.append(f)
#if DEBUG_MODE:
# print "$$ -> field:", field
#if DEBUG_MODE:
# print "$$ <<< LlampexResult.record()"
return info
def getNewRecord():
rec = QtSql.QSqlRecord()
id_field = QtSql.QSqlField('id', QtCore.QVariant.ULongLong)
id_field.setAutoValue(True)
rec.append(id_field)
rec.append(QtSql.QSqlField('client_id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('amount', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('note', QtCore.QVariant.String))
rec.append(QtSql.QSqlField('tissueType_id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('unit_id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('number', QtCore.QVariant.String))
rec.append(QtSql.QSqlField('status', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('datetimeTaken', QtCore.QVariant.DateTime))
rec.append(QtSql.QSqlField('execPerson_id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('externalId', QtCore.QVariant.String))
return rec
def create_person(self, person, person_id=None):
rec = QtSql.QSqlRecord()
rec.append(QtSql.QSqlField('code', QtCore.QVariant.String))
rec.setValue('code', QtCore.QVariant(person['TabNumber']))
rec.append(QtSql.QSqlField('federalCode', QtCore.QVariant.String))
rec.setValue('federalCode', QtCore.QVariant(person['TabNumber']))
rec.append(QtSql.QSqlField('regionalCode', QtCore.QVariant.String))
rec.setValue('regionalCode', QtCore.QVariant(person['TabNumber']))
rec.append(QtSql.QSqlField('firstName', QtCore.QVariant.String))
rec.setValue('firstName', QtCore.QVariant(person['Name']))
rec.append(QtSql.QSqlField('lastName', QtCore.QVariant.String))
rec.setValue('lastName', QtCore.QVariant(person['Surname']))
rec.append(QtSql.QSqlField('patrName', QtCore.QVariant.String))
rec.setValue('patrName', QtCore.QVariant(person['Patroname']))
rec.append(QtSql.QSqlField('sex', QtCore.QVariant.Int))
rec.setValue('sex', QtCore.QVariant(person['Sex']))
rec.append(QtSql.QSqlField('post_id', QtCore.QVariant.Int))
if person['PostGUID'] in self.posts:
rec.setValue('post_id',
QtCore.QVariant(self.posts[person['PostGUID']]))
rec.append(QtSql.QSqlField('speciality_id', QtCore.QVariant.Int))
if person['SpecialityGUID'] in self.specialities:
rec.setValue(
'speciality_id',
QtCore.QVariant(self.specialities[person['SpecialityGUID']]))
rec.append(QtSql.QSqlField('orgStructure_id', QtCore.QVariant.Int))
if person['SubdivisionGUID'] in self.org_structures:
rec.setValue(
'orgStructure_id',
QtCore.QVariant(
self.org_structures[person['SubdivisionGUID']]))
rec.append(QtSql.QSqlField('SNILS', QtCore.QVariant.String))
rec.setValue('SNILS', QtCore.QVariant(person['SNILS']))
rec.append(QtSql.QSqlField('birthDate', QtCore.QVariant.Date))
rec.setValue('birthDate', QtCore.QVariant(person['DateBirth']))
rec.append(QtSql.QSqlField('syncGUID', QtCore.QVariant.String))
rec.setValue('syncGUID', QtCore.QVariant(person['GUID']))
if person['DateEnd']:
rec.append(QtSql.QSqlField('retired', QtCore.QVariant.Int))
rec.append(QtSql.QSqlField('retireDate', QtCore.QVariant.Date))
rec.setValue('retired', QtCore.QVariant(1))
rec.setValue('retireDate', QtCore.QVariant(person['DateEnd']))
if person_id:
rec.append(QtSql.QSqlField('id', QtCore.QVariant.Int))
rec.setValue('id', QtCore.QVariant(person_id))
rec.append(QtSql.QSqlField('org_id', QtCore.QVariant.Int))
rec.setValue('org_id', QtCore.QVariant(QtGui.qApp.currentOrgId()))
return rec
def __init__(self, name, fieldType):
super(CField, self).__init__()
self.database = None
self.tableName = ''
self.fieldName = name
self.field = QtSql.QSqlField(name, fieldType)
def getNewRecord(cls):
record = QtSql.QSqlRecord()
for fieldName, fieldType in cls.fields:
record.append(QtSql.QSqlField(fieldName, fieldType))
return record
def getEmptyRecord(self):
record = CRecordListModel.getEmptyRecord(self)
record.append(QtSql.QSqlField('id', QtCore.QVariant.Int))
return record
def empty_record():
rec = QtSql.QSqlRecord()
rec.append(QtSql.QSqlField('id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('event_id', QtCore.QVariant.ULongLong))
rec.append(QtSql.QSqlField('is_deciduous', QtCore.QVariant.Bool))
return rec
def getEmptyRecord(self):
result = CInDocTableModel.getEmptyRecord(self)
result.append(QtSql.QSqlField('payable', QtCore.QVariant.Int))
result.setValue('amount', QtCore.QVariant(1.0))
result.setValue('cash', QtCore.QVariant(self.wholeEventForCash))
return result
def loadData(self, eventId, dateBegin, dateEnd, doctorMode):
self._items = []
if not eventId:
self.reset()
return
db = QtGui.qApp.db
stmt = u'''
CALL getEventDrugDestinations('%(eventId)s', '%(dateBegin)s', '%(dateEnd)s', '%(doctorMode)d')
''' % {
'eventId': eventId,
'dateBegin': dateBegin.toString('yyyy-MM-dd'),
'dateEnd': dateEnd.toString('yyyy-MM-dd'),
'doctorMode': 1 if doctorMode else 0
}
query = db.query(stmt)
while query.next():
record = query.record()
takeDate = forceString(record.value('takeDate'))
takeDate = takeDate.split(',')
takeDose = forceString(record.value('takeDose'))
takeDose = takeDose.split(',')
takeTime = forceString(record.value('takeTime'))
takeTime = takeTime.split(',')
stmtUnit = u'''
SELECT rbUnit.code
FROM rbUnit
WHERE rbUnit.id = %(id)s
''' % {
'id': forceInt(record.value('drugMeasureUnit_id'))
}
queryUnit = QtGui.qApp.db.query(stmtUnit)
if queryUnit.first():
recordUnit = queryUnit.record()
unit = '(' + forceString(recordUnit.value('code')) + ')'
else:
unit = ''
destinationItems = []
for dose in takeDose:
item = dose + ' ' + unit if dose else ''
destinationItems.append(item)
i = 0
if len(takeDate) > 1:
date = QtCore.QDate(forceInt(takeDate[0][:4]),
forceInt(takeDate[0][5:7]),
forceInt(takeDate[0][8:]))
date = date.addDays(1)
endDate = QtCore.QDate(forceInt(takeDate[1][:4]),
forceInt(takeDate[1][5:7]),
forceInt(takeDate[1][8:]))
while date != endDate:
date = date.addDays(1)
i += 1
record.append(QtSql.QSqlField('interval'))
record.setValue('interval', toVariant(i))
itemDose = ''
i = 0
for date in takeDate:
curDate = date[8:] + '.' + date[5:7] + '.' + date[:4]
for time in takeTime:
curTime = time[:5]
itemDose += '(' + curDate + ' ' + curTime + ') ' + destinationItems[
i] + '; '
i += 1
record.append(QtSql.QSqlField('receivingTime'))
record.setValue('receivingTime', toVariant(itemDose))
self._items.append(record)
self.reset()
