def main():
import sys
from library.database import connectDataBaseByInfo
from s11main import CS11mainApp
app = CS11mainApp(sys.argv, False, 'S11App.ini', False)
QtGui.qApp = app
QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8'))
QtGui.qApp.currentOrgId = lambda: 229525# 230493 # 229525 # 230226 #229525 #229005
connectionInfo = {'driverName' : 'mysql',
'host' : 'pacs',
'port' : 3306,
'database' : 'novros',
'user' : 'dbuser',
'password' : 'dbpassword',
'connectionName' : 'vista-med',
'compressData' : True,
'afterConnectFunc' : None}
"""
connectionInfo = {'driverName': 'mysql',
'host': 'pes',
'port': 3306,
'database': 's12',
'user': '******',
'password': '******',
'connectionName': 'vista-med',
'compressData': True,
'afterConnectFunc': None}
"""
QtGui.qApp.db = connectDataBaseByInfo(connectionInfo)
CReportF14DS(None).exec_()
sys.exit(app.exec_())
def main():
import sys
from library.database import connectDataBaseByInfo
from s11main import CS11mainApp
app = CS11mainApp(sys.argv, False, 'S11App.ini', False)
QtGui.qApp = app
QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8'))
QtGui.qApp.currentOrgId = lambda: 3147
connectionInfo = {
'driverName': 'mysql',
'host': '192.168.0.3',
'port': 3306,
'database': 'pnd5',
'user': '******',
'password': '******',
'connectionName': 'vista-med',
'compressData': True,
'afterConnectFunc': None
}
QtGui.qApp.db = connectDataBaseByInfo(connectionInfo)
CReportReHospitalization(None).exec_()
sys.exit(app.exec_())
def main():
import sys
from s11main import CS11mainApp
from library.database import connectDataBaseByInfo
from PyQt4 import QtCore
QtGui.qApp = CS11mainApp(sys.argv, False, 'S11App.ini', False)
QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8'))
connectionInfo = {
'driverName': 'mysql',
'host': 'pz12',
'port': 3306,
'database': 's11',
'user': '******',
'password': '******',
'connectionName': 'vista-med',
'compressData': True,
'afterConnectFunc': None
}
QtGui.qApp.db = connectDataBaseByInfo(connectionInfo)
w = CReportSurgical(None)
w.exec_()
sys.exit(QtGui.qApp.exec_())
def main():
import sys
from s11main import CS11mainApp
from library.database import connectDataBaseByInfo
QtGui.qApp = CS11mainApp(sys.argv, False, 'S11App.ini', False)
QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8'))
connectionInfo = {
'driverName': 'mysql',
'host': 'pes',
'port': 3306,
'database': 's12',
'user': '******',
'password': '******',
'connectionName': 'vista-med',
'compressData': True,
'afterConnectFunc': None
}
QtGui.qApp.db = connectDataBaseByInfo(connectionInfo)
QtGui.qApp.userId = 1
w = CHospitalizationTransferPage(None, 1243474)
w.show()
QtGui.qApp.exec_()
def main():
import sys
from library.database import connectDataBaseByInfo
app = CS11mainApp(sys.argv, False, 'S11App.ini', False)
QtGui.qApp = app
QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8'))
connectionInfo = {
'driverName': 'mysql',
'host': 'pes',
'port': 3306,
'database': 's12',
'user': '******',
'password': '******',
'connectionName': 'vista-med',
'compressData': True,
'afterConnectFunc': None
}
db = connectDataBaseByInfo(connectionInfo)
query = db.query(u'''
SELECT o.organisation_id
FROM OrgStructure o
INNER JOIN Person p ON p.orgStructure_id = o.id
''')
if query.first():
record = query.record()
print forceStringEx(record.value('organisation_id').toString()), type(
int(forceStringEx(record.value('organisation_id').toString())))
QtGui.qApp.currentOrgId = lambda: int(
forceStringEx(record.value('organisation_id').toString()))
print '229638_4'
QtGui.qApp.db = connectDataBaseByInfo(connectionInfo)
sys.exit(CRCReportList(None).exec_())
def main():
import sys
from s11main import CS11mainApp
from library.database import connectDataBaseByInfo
app = CS11mainApp(sys.argv, False, 'S11App.ini', False)
QtGui.qApp = app
QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8'))
QtGui.qApp.currentOrgId = lambda: 386271
QtGui.qApp.currentOrgStructureId = lambda: 34
QtGui.qApp.db = connectDataBaseByInfo({
'driverName': 'mysql',
'host': 'mos36',
'port': 3306,
'database': 's11',
'user': '******',
'password': '******',
'connectionName': 'vista-med',
'compressData': True,
'afterConnectFunc': None
})
CReportMovingB36Monthly(None).exec_()
def main():
import sys
from s11main import CS11mainApp
from library.database import connectDataBaseByInfo
QtGui.qApp = CS11mainApp(sys.argv, False, 'S11App.ini', False)
QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8'))
connectionInfo = {
'driverName': 'mysql',
'host': '192.168.0.207',
'port': 3306,
'database': 's11vm2',
'user': '******',
'password': '******',
'connectionName': 'vista-med',
'compressData': True,
'afterConnectFunc': None
}
QtGui.qApp.db = connectDataBaseByInfo(connectionInfo)
w = CClientDocumentsCheck(None)
w.exec_()
def main():
import sys
from s11main import CS11mainApp
from library.database import connectDataBaseByInfo
QtCore.QCoreApplication.setAttribute(QtCore.Qt.AA_X11InitThreads)
QtGui.qApp = CS11mainApp(sys.argv, False, 'S11App.ini', False)
QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8'))
connectionInfo = {
'driverName': 'mysql',
'host': 'pacs',
'port': 3306,
'database': 's11vm',
'user': '******',
'password': '******',
'connectionName': 'vista-med',
'compressData': True,
'afterConnectFunc': None
}
QtGui.qApp.db = connectDataBaseByInfo(connectionInfo)
w = CCashRegisterWindow(None)
w.exec_()
def main():
import sys
from s11main import CS11mainApp
from library.database import connectDataBaseByInfo
app = CS11mainApp(sys.argv, False, 'S11App.ini', False)
QtGui.qApp = app
QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName(u'utf8'))
QtGui.qApp.currentOrgId = lambda: 230493
QtGui.qApp.db = connectDataBaseByInfo({
'driverName': 'mysql',
'host': '192.168.0.207',
'port': 3306,
'database': 'most03-06-2016',
'user': '******',
'password': '******',
'connectionName': 'vista-med',
'compressData': True,
'afterConnectFunc': None
})
CEventServicesCheck(None).exec_()
def openInventoryDocument(self, index):
inventoryDocument = self.tblInventoryDocuments.model().getItem(
index.row())
dlg = CInventoryDocumentDialog(self)
dlg.setDocument(inventoryDocument, editable=False)
dlg.exec_()
self.reloadInventoryDocuments()
if __name__ == '__main__':
import sys
from library.database import connectDataBaseByInfo
from s11main import CS11mainApp
QtGui.qApp = CS11mainApp(sys.argv, False, 'S11App.ini', False)
QtCore.QTextCodec.setCodecForTr(QtCore.QTextCodec.codecForName('utf8'))
QtGui.qApp.applyDecorPreferences()
# QtGui.qApp.db = CDatabase()
QtGui.qApp.db = connectDataBaseByInfo({
'driverName': 'mysql',
'host': '192.168.0.3',
'port': 3306,
'database': 'ant_p17',
'user': '******',
'password': '******',
'connectionName': 'vista-med',
'compressData': True,
'afterConnectFunc': None
}) # for print templates
