def POST(self,name):
webData = json.loads(web.data())
action = webData["action"]
if "token" in webData:
token = webData["token"]
if common.func.checkSession(token) == False:
return packOutput({}, "401", "Tocken authority failed")
if action == "edit":
account = {}
stationID = webData["stationID"]
account["user"] = webData["user"]
account["password"] = webData["password"]
account["descText"] = webData["descText"]
stationAccount = DB.StationAccount()
stationAccount.edit(stationID,account)
return packOutput({})
elif action == "getList":
stationAccount = DB.StationAccount()
resultJson = {"accountList":[]}
list = stationAccount.getList()
for item in list:
resultJson["accountList"].append(item)
return packOutput(resultJson)
elif action == "getInfo":
stationID = webData["stationID"]
stationAccount = DB.StationAccount()
info = stationAccount.getInfo(stationID)
return packOutput(info)
def __init__(self):
self.stationID = 0
self.queueList = []
self.VistorSource = DB.StationVisitor()
self.DBLocal = DB.DBLocal
self.queueInfo = queueInfo.QueueInfoInterface()
self.visitorList = []
pass
def getSourceQueueList(self, inputData):
stationID = inputData["stationID"]
visitorSource = DB.StationVisitor()
visitorSource.SourceLoad(stationID)
sql = "select DISTINCT(queue) from " + visitorSource.getView()
print sql
res = visitorSource.DBSource.select(visitorSource.getView(),
what="DISTINCT(queue)")
colName = visitorSource.getColName("queue")
sourceQueueList = []
for item in res:
sourceQueueList.append(item[colName])
choseQueueList = self.getChoseQueueList(stationID)
print sourceQueueList
print choseQueueList
queueList = list(set(sourceQueueList) - set(choseQueueList))
return queueList
def GET(self, name):
if not name: name = 'world'
web.header('Content-Type', 'text/html; charset=UTF-8')
print(" ManagerPage")
config = {
"name": "分诊台2",
"descText": "软件新建分诊台",
"DBType": "mysql",
"host": "192.168.17.184",
"port": "3306",
"charset": "utf8",
"DBName": "HisQueue",
"tableName": "visitors",
"user": "******",
"passwd": "123456",
"aliasName": "name",
"aliasAge": "age",
"aliasQueue": "queue",
"aliasID": "ID",
"aliasOrderDate": "orderDate",
"aliasOrderTime": "orderTime",
"aliasRegistDate": "RegistDate",
"aliasRegistTime": "registTime",
"aliasSnumber": "snumber",
"aliasVIP": "emergency",
"aliasOrderType": "orderType",
"aliasWorkerID": "workerID",
"aliasWorkerName": "workerName",
"aliasDepartment": "department",
"aliasDescText": "descText",
"aliasStatus": "status",
"renewPeriod": 10
}
visitorSource = DB.StationVisitor()
if visitorSource.testAliasSql(config):
print("Add DBSource test Source success")
id = visitorSource.newSource(config)
visitorSource.SourceLoad(id)
else:
return "test Source failed"
outStr = visitorSource.getAliasSql(config)
return outStr
def __init__(self):
self.stationList = []
self.DBIO = DB.StationSet()
self.LoadStation()
elif action == "edit":
print(" Controller change station ")
req = json.loads(web.data())
id = req["stationID"]
config = req
ret = stationMagager.chgStation(id, config)
if ret == -1:
return packOutput({}, "500", "change station error")
else:
return packOutput({})
elif action == "sourceTest":
print(" Controller source Test ")
req = json.loads(web.data())
source = DB.StationVisitor()
ret = source.testSource(req)
if ret == 1:
resultJson = {"testResult": "success"}
else:
resultJson = {"testResult": "failed"}
return packOutput(resultJson)
elif action == "sourceConfigTest":
print(" Controller source config test ")
req = json.loads(web.data())
source = DB.StationVisitor()
ret = source.testAliasSql(req)
sql = source.getAliasSql(req)
if ret == 1:
resultJson = {"testResult": "success", "testSql": sql}