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}