def POST(self, lid='0'): init.checkadmin() if (not lid.isdigit()): return init.jsonerr('invalid line id') rs = mysql.conn.select('gt_line', where="id=" + lid) if (len(rs) < 1): return init.jsonerr('error line id') data = web.input(imgurl='', imgtext='', imgid='0') imgurl = data.imgurl imgtext = data.imgtext imgid = data.imgid if (imgurl != ''): sql = "insert ignore into gt_lineimg(lid,img) values(%s, '%s')" % ( lid, imgurl) rsa = mysql.conn.query(sql) if rsa: return init.jsonok([], '操作成功') else: return init.jsonerr('图片已插入,请不要重复图片.') if (imgtext != ''): imgid = imgid.split('_') imgid = imgid[-1] if (not init.checkadmin() and rs.locking == 1): return init.render.error('您不能修改已有图片!') mysql.conn.update('gt_lineimg', where="lid=" + lid + " and id=" + imgid, says=imgtext) return init.jsonok([], '描述添加成功') return init.jsonerr('无效操作')
def GET(self, lid='0'): init.checkadmin() if (not lid.isdigit()): raise seeother('/') rs = mysql.conn.select('gt_line', where="id=" + lid) if (len(rs) < 1): return seeother('/') rs = rs[0] data = web.input(delimg='0', mainimg='0') delimg = data.delimg mainimg = data.mainimg #delimg: if (delimg != '0'): if (not init.checkadmin() and rs.locking == 1): return init.render.error('您不能修改已有图片!') mysql.conn.delete('gt_lineimg', where="lid=" + lid + " and id=" + delimg) #mainimg: if (mainimg != '0'): if (not init.checkadmin() and rs.locking == 1): return init.render.error('您不能修改已有图片!') mysql.conn.update('gt_lineimg', where="lid=" + lid, ismain=0) mysql.conn.update('gt_lineimg', where="lid=" + lid + " and id=" + mainimg, ismain=1) imgs = mysql.conn.select('gt_lineimg', where="lid=" + lid, order="id asc") return init.render.lineimg(rs, imgs)
def GET(self): init.checkadmin() render = web.template.render('views/admin', base='layout', cache=conf.webview_cache, globals=init.temp_globals) return render.main()
def POST(self): init.checkadmin() data = web.input() line = int(data.line) island = int(data.island) area = int(data.area) keychar = data.statchar.lower().replace(' ', '') id = data.get('id', '0') #return id if (id == '0'): mysql.conn.insert('gt_station', pid=data.pid, keychar=keychar, cid=data.cid, station=data.station, statchar=data.statchar, grade=data.grade, address=data.address, longitude=data.longitude, latitude=data.latitude, line=line, island=island, area=area, building=data.building, passengers=data.passengers) else: rs = mysql.conn.select('gt_station', where="id=" + id) if (not len(rs)): return init.render.error('参数有误!') rs = rs[0] if (not init.checkadmin() and rs.locking == 1): return init.render.error('您不能修改已有内容!') mysql.conn.update('gt_station', where='id = $id', vars=locals(), keychar=keychar, pid=data.pid, cid=data.cid, station=data.station, statchar=data.statchar, grade=data.grade, address=data.address, longitude=data.longitude, latitude=data.latitude, line=line, island=island, area=area, building=data.building, passengers=data.passengers) raise web.seeother('/station') pass
def GET(self, lid='0'): init.checkadmin() data = {} data['statarr'] = mysql.getstatArr() line = mysql.conn.select("gt_line", where="id= " + lid) if (len(line) < 1): return init.render.error('id参数有误') line = line[0] rs = mysql.conn.query( "select gl.id,province,city,cid,station,stat_id,line_id from gt_linestats gl left join gt_station gt on gl.stat_id = gt.id left join gt_citys gc on gt.cid = gc.id where gl.line_id = %s order by gl.sort asc,gl.id asc" % lid) return init.render.linestats(line, rs, data)
def POST(self): init.checkadmin() data = web.input() longkm = int(data.longkm) speed = int(data.speed) onspeed = int(data.onspeed) keychar = data.namechar.lower().replace(' ', '') id = data.get('id', '0') #return id if (id == '0'): mysql.conn.insert('gt_line', keychar=keychar, name=data.name, fullname=data.fullname, namechar=data.namechar, statusc=data.statusc, speed=speed, building=data.building, longkm=longkm, onspeed=onspeed, color=data.color) else: rs = mysql.conn.select('gt_line', where="id=" + id) if (not len(rs)): return init.render.error('参数有误!') rs = rs[0] admin = init.checkadmin() if (rs.locking and not admin): raise web.seeother('/line') if (rs.locking): raise web.seeother('/line') if (not init.checkadmin() and rs.locking == 1): return init.render.error('您不能修改已有内容!') mysql.conn.update('gt_line', where='id = $id', vars=locals(), keychar=keychar, name=data.name, fullname=data.fullname, namechar=data.namechar, statusc=data.statusc, speed=speed, building=data.building, longkm=longkm, onspeed=onspeed, color=data.color) raise web.seeother('/line') pass
def GET(self): init.checkadmin() province = mysql.getproArr() get = web.input(proid='1000') proid = get.proid if (not proid.isdigit() or proid == '0'): proid = '1000' rs = mysql.conn.select('gt_citys', where="proid=" + proid, order='id asc') if (len(rs) < 1): return init.render.error('参数有误') proid = int(proid) return init.render.city(rs, province, proid)
def GET(self): init.checkadmin() data = {} data['status'] = conf.status #modify indata = web.input(id='0') if (indata.id.isdigit() and indata.id != '0'): oridata = mysql.conn.select('gt_line', where="id=" + indata.id) if (len(oridata) < 1): return init.render.error('id参数有误') oridata = oridata[0] else: id = '0' oridata = web.Storage() return init.render.linedit(data, oridata)
def GET(self, typeid): adminer = init.checkadmin(False) find = False for item in conf.typearr: if (item['id'] == typeid): find = True if (not find): return web.seeother('/') rs = mysql.conn.select('gt_article', where="typeval=" + typeid) return init.render.article(rs, adminer)
def GET(self): init.checkadmin() data = {} data['province'] = mysql.getproArr() data['city'] = mysql.getcityArr() data['cityj'] = json.dumps(data['city'], ensure_ascii=False) data['cityjson'] = data['cityj'] #.replace(""",'"'); data['grade'] = conf.grade #modify indata = web.input(id='0') if (indata.id.isdigit() and indata.id != '0'): oridata = mysql.conn.select('gt_station', where="id=" + indata.id) if (len(oridata) < 1): return init.render.error('id参数有误') oridata = oridata[0] else: id = '0' oridata = web.Storage() return init.render.stationedit(data, oridata)
def GET(self): adminer = init.checkadmin(False) province = mysql.getproArr() get = web.input(proid='0') proid = get.proid if (not proid.isdigit() or proid == '0'): rs = mysql.conn.select('gt_station', order='id asc') else: rs = mysql.conn.select('gt_station', where="pid=" + proid, order='id asc') proid = int(proid) return init.render.station(rs, adminer, proid, province)
def POST(self): init.checkadmin() data = web.input() id = data.get('id', '0') station_id = data.get('station_id', '0') if (not station_id.isdigit()): station_id = '0' line_id = data.get('line_id', '0') if (not line_id.isdigit()): line_id = '0' nowt = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) #return helps.htmlshow(data) if (id == '0'): mysql.conn.insert('gt_article', title=data.title, line_id=line_id, station_id=station_id, typeval=data.typeval, detail=data.detail, create_time=nowt, update_time=nowt) else: rs = mysql.conn.select('gt_article', where="id=" + id) if (not len(rs)): return init.render.error('参数错误!') rs = rs[0] if (not init.checkadmin() and rs.locking == 1): return init.render.error('您不能修改已有内容!') mysql.conn.update('gt_article', where="id=" + id, title=data.title, line_id=line_id, station_id=station_id, typeval=data.typeval, detail=data.detail, update_time=nowt) raise web.seeother("/article/" + data.typeval)
def GET(self): init.checkadmin() indata = web.input() aid = indata.get('aid', '0') sid = indata.get('sid', '0') lid = indata.get('lid', '0') if (not aid.isdigit()): aid = '0' if (not sid.isdigit()): sid = '0' if (not lid.isdigit()): lid = '0' oridata = {} if (aid != '0' or sid != '0' or lid != '0'): if (aid != '0'): oridata = mysql.conn.select('gt_article', where="id=" + aid) if (len(oridata) < 1): return init.render.error('参数有误') elif (sid != '0'): oridata = mysql.conn.select('gt_article', where="station_id=" + sid) else: oridata = mysql.conn.select('gt_article', where="line_id=" + lid) if (len(oridata) >= 1): oridata = oridata[0] else: oridata = {} data = {} data['type'] = conf.typearr data['linearr'] = mysql.getlineArr() data['statarr'] = mysql.getstatArr() return init.render.articledit(data, oridata, sid, lid)
def GET(self, lid='0'): if (not lid.isdigit()): raise seeother('/') rs = mysql.conn.select('gt_line', where="id=" + lid) if (len(rs) < 1): return seeother('/') rs = rs[0] admin = init.checkadmin() if (rs.locking and not admin): raise web.seeother('/line') #get all stations sql = "select * from gt_fullstats where line_id='%s' order by sortnum asc,id asc" % lid oridata = mysql.conn.query(sql) web.header("Access-Control-Allow-Origin", "*") return init.render.allstatedit(rs, oridata, lid)
def POST(self, lid='0'): adminer = init.checkadmin() line = mysql.conn.select("gt_line", where="id= " + lid) if (len(line) < 1): return init.jsonerr('无效参数') linedata = line[0] if (not adminer and linedata.locking == 1): return init.jsonerr('此线路已经完善,不能再编辑.') indata = web.input() sid = indata.get('sid', '0') if (not sid.isdigit() or sid == '0'): return init.jsonerr('无效参数sid') #do sort sort = indata.get('sort', '0') if (sort.isdigit() and sort != '0'): rs = mysql.conn.select("gt_linestats", order="sort asc,id asc", where="line_id=" + lid) index = 0 sort = int(sort) for row in rs: if (row.id == int(sid)): continue index += 1 if (index == sort): mysql.conn.update("gt_linestats", where="id=" + sid, sort=index) index += 1 mysql.conn.update("gt_linestats", where="id=" + str(row.id), sort=index) return init.jsonok('顺序调整完成') station = mysql.conn.select("gt_station", where="id= " + sid) if (len(station) < 1): return init.jsonerr('无效参数') mysql.conn.query( "insert ignore into gt_linestats(line_id, stat_id) values(%s, %s)" % (lid, sid)) return init.jsonok('添加成功')
def POST(self, lid='0'): rs = init.checkadmin() if not rs: raise web.seeother('/') if (not lid.isdigit()): raise seeother('/') rs = mysql.conn.select('gt_line', where="id=" + lid) if (len(rs) < 1): return seeother('/') #do stat data rs = rs[0] data = web.input() #return helps.htmlshow(data); test = [] for num in range(1, 200): i = str(num) stat = data.get("st_" + i, '') stat = stat.strip() if not stat: sql = "delete from gt_fullstats where line_id=%s and sortnum > %s" % ( lid, i) rs = mysql.conn.query(sql) break else: sortv = data.get("s_" + i, '1000') jwd = data.get("jwd_" + i, '116.400819,39.92556') sortv = sortv.strip() jwd = jwd.strip() web.header('Content-Type', 'text/html;charset=UTF-8') #return sortv+stat+jwd sql = "insert ignore into gt_fullstats(line_id,stat_name,jingweidu,sortnum) values('%s','%s','%s','%s') ON DUPLICATE KEY UPDATE jingweidu='%s',sortnum='%s'" % ( lid, stat, jwd, sortv, jwd, sortv) rs = mysql.conn.query(sql) #return sql raise web.seeother('/allstatedit/' + lid) pass
def GET(self): adminer = init.checkadmin(False) if( not adminer): return init.render.error('您无权限操作此项.') data = web.input(doid='0'); doid = data.doid if(not doid.isdigit()): return init.render.error('参数错误.') rs = mysql.conn.select('gt_line', where="id="+doid) if(not len(rs)): return init.render.error('参数错误.') rs=rs[0] if(rs.locking == 0): locking = '1' else: locking = '0' mysql.conn.update('gt_line', where="id=" +doid, locking=locking) return helps.goback()
def GET(self): init.checkadmin() rs = mysql.conn.select('gt_province', order='sort asc') return init.render.province(rs)
def GET(self): init.checkadmin() web.setcookie(conf.admincooker, '', expires=1) raise web.seeother('/gtadminerback')
def GET(self): adminer = init.checkadmin(False) rs = mysql.conn.select('gt_line', order='id desc') return init.render.line(rs, adminer)