def post(self):
kwargs = dict((k, v[-1]) for k, v in self.request.arguments.items())
substid = kwargs.pop('substid', None)
# 机器人添加管理人
loginname = kwargs.pop('loginname', '')
loginname = loginname.split(',')
users,t = mongo_util.m_list(T_PASSPORT, substid = substid, findall=True,fields={'loginname': 1})
users = [item.get('loginname') for item in users]
for ln in list(set(users) - set(loginname)):
mongo_util.m_pull(T_PASSPORT,{'loginname':ln},substid = substid)
for ln in loginname:
mongo_util.m_addToSet(T_PASSPORT,{'loginname':ln},substid = substid)
if substid:
values = ','.join([k+"='"+v+"'" for k, v in kwargs.items()])
sql = "update {} set {} where substid='{}'".format(T_SUBST_INFO, values, substid)
else:
kwargs['substid'] = str(ObjectId())
substid = kwargs['substid']
values = ','.join(["'" + item + "'" for item in kwargs.values()])
sql = "insert into {}({}) values ({})".format(T_SUBST_INFO, ','.join(kwargs.keys()), values)
mongo_util.m_addToSet('passport',{'_id': ObjectId(self.uid)}, substid = substid)
print sql
mysql_util.m_execute(sql)
self.write(dict(status = True))
def get(self):
uids, t = mongo_util.m_list(T_ACCESS, findall = '1', fields = {'_id': 1})
uids = [ObjectId(item.get('_id')) for item in uids]
userlist, t = mongo_util.m_list(T_PASSPORT, fields = {'pwd': 0}, findall = '1',
_id = {'$in': uids})
users = {}
for u in userlist:
company = mongo_util.m_find_one(T_COMPANY, user = u.get('_id'))
companyname = company.get('name', '未分组')
if users.has_key(companyname):
users[companyname].append(u)
else:
users[companyname] = [u]
self.write(dict(status = True, data = users))
def get(self):
"""
"""
kwargs = dict((k, v[-1]) for k, v in self.request.arguments.items())
fields = kwargs.pop('fields', {'pwd': 0})
users, t = mongo_util.m_list(T_PASSPORT, findall = True, fields = fields, sorts=[('_id', -1)])
pre_user(users)
print get_user_acs(self)
self.render('user.html', users = users,
access = get_fenlei_handlers(handler = self))
def get(self):
substid = self.get_argument('substid', None)
data = {}
users = []
if substid:
fields_s = ['substid', 'areaid', 'name', 'location_name', 'location_lat', 'location_lng']
sql = "select {}".format(','.join(fields_s))
sql += " from {} where substid='{}'"
data = mysql_util.m_query_one(sql.format(T_SUBST_INFO, substid), fields_s)
users,t = mongo_util.m_list(T_PASSPORT,substid = substid,findall = True,fields={'_id': 1, 'loginname': 1})
self.render("manageSubst_add.html", data = data, users=users)
def init_role(self, **kwargs):
role, page = mongo_util.m_list(T_ROLE, **kwargs)
return role, page
