def fetch_all_lessons(self, page):
sql = '''select d.id, subject_name, username, from_unixtime(createtime) as createtime,
date(from_unixtime(start_time)) as start_time, date(from_unixtime(end_time)) as end_time,
d.actived from md_diy_subject d left join md_member m on d.member_id = m.id
order by createtime desc'''
sql = Pagination.add_limit_clause(sql, page)
return self.db.query(sql)
def fetch_all_lessons(self, page):
sql = '''select d.id, subject_name, username, from_unixtime(createtime) as createtime,
date(from_unixtime(start_time)) as start_time, date(from_unixtime(end_time)) as end_time,
d.actived from md_diy_subject d left join md_member m on d.member_id = m.id
order by createtime desc'''
sql = Pagination.add_limit_clause(sql, page)
return self.db.query(sql)
def get(self):
session = self.backend.get_session()
# 查询
package_name = self.get_argument("package_name", "")
if package_name:
hairpackages = session.query(HairPackage).filter(HairPackage.package_name.like("%" + package_name + "%"))
else:
hairpackages = session.query(HairPackage)
hairpackages = hairpackages.order_by(HairPackage.modifytime.desc())
# 分页
count = hairpackages.count()
page_count = Pagination.page_count(count)
params = dict(
hairpackages=hairpackages.all(),
config=self.config,
page_count=page_count,
informer=BootstrapInformer("success", "共 %s 条记录" % count, "查询结果："),
package_name=package_name,
)
self.render("hairpackages/index.html", **params)
session.close()
def get(self):
query_params = dict(
member_type=self.get_argument("member_type", None),
actived=self.get_argument("actived", None),
province_id=self.get_argument("province_id", None),
city_id=self.get_argument("city_id", None),
username=self.get_argument("username", ""),
email=self.get_argument("email", ""),
mobile=self.get_argument("mobile", None),
regtime_from=self.get_argument("regtime_from", ""),
regtime_to=self.get_argument("regtime_to", str(datetime.date.today())),
lastlogintime_from=self.get_argument("lastlogintime_from", ""),
lastlogintime_to=self.get_argument("lastlogintime_to", str(datetime.date.today())),
page=self.get_argument("page", 1)
)
try:
regions = self.fetch_all_regions()
entries = self.query_users(**query_params)
count = self.query_users_size(**query_params)
page_count = Pagination.page_count(count)
except Exception, e:
print e
self.redirect("/users")
return
def get(self):
query_params = dict(
member_type=self.get_argument("member_type", None),
actived=self.get_argument("actived", None),
province_id=self.get_argument("province_id", None),
city_id=self.get_argument("city_id", None),
username=self.get_argument("username", ""),
email=self.get_argument("email", ""),
mobile=self.get_argument("mobile", None),
regtime_from=self.get_argument("regtime_from", ""),
regtime_to=self.get_argument("regtime_to",
str(datetime.date.today())),
lastlogintime_from=self.get_argument("lastlogintime_from", ""),
lastlogintime_to=self.get_argument("lastlogintime_to",
str(datetime.date.today())),
page=self.get_argument("page", 1))
try:
regions = self.fetch_all_regions()
entries = self.query_users(**query_params)
count = self.query_users_size(**query_params)
page_count = Pagination.page_count(count)
except Exception, e:
print e
self.redirect("/users")
return
def get(self):
session = self.backend.get_session()
# 查询
package_name = self.get_argument("package_name", "")
if package_name:
hairpackages = session.query(HairPackage).filter(
HairPackage.package_name.like("%" + package_name + "%"))
else:
hairpackages = session.query(HairPackage)
hairpackages = hairpackages.order_by(HairPackage.modifytime.desc())
# 分页
count = hairpackages.count()
page_count = Pagination.page_count(count)
params = dict(
hairpackages=hairpackages.all(),
config=self.config,
page_count=page_count,
informer=BootstrapInformer("success", "共 %s 条记录" % count, "查询结果："),
package_name=package_name,
)
self.render("hairpackages/index.html", **params)
session.close()
def query_salons(self, salon_name, province_id, city_id, domain_id, page):
'''查询沙龙'''
sql = '''
select * from md_salon
'''
sql, params = self.gen_query_str(sql, salon_name, province_id, city_id, domain_id)
sql = Pagination.add_limit_clause(sql, page)
return self.db.query(sql, *params)
def query_salons(self, salon_name, province_id, city_id, domain_id, page):
'''查询沙龙'''
sql = '''
select * from md_salon
'''
sql, params = self.gen_query_str(sql, salon_name, province_id, city_id,
domain_id)
sql = Pagination.add_limit_clause(sql, page)
return self.db.query(sql, *params)
def get(self):
page = self.get_argument("page", 1)
seasons = self.fetch_all_seasons(page)
count = self.fetch_all_seasons_size()
page_count = Pagination.page_count(count)
params = dict(
seasons=seasons,
informer=BootstrapInformer("success", "共 %s 条记录" % len(seasons), "查询结果："),
page_count=page_count,
)
self.render("seasons/index.html", **params)
def get(self):
page = self.get_argument("page", 1)
seasons = self.fetch_all_seasons(page)
count = self.fetch_all_seasons_size()
page_count = Pagination.page_count(count)
params = dict(
seasons=seasons,
informer=BootstrapInformer("success", "共 %s 条记录" % len(seasons),
"查询结果："),
page_count=page_count,
)
self.render("seasons/index.html", **params)
def query_users(self, **args):
sql = '''
select m.id, m.username, m.email, m.member_type, m.regtime, m.recommend,
m.province_id, m.city_id, m.recommend_talent,
m.actived, s.works_count, s.lastlogintime, s.twitter_num, s.emotion_num,
from_unixtime(m.regtime) as regtime_str,
from_unixtime(s.lastlogintime) as lastlogintime_str
from md_member m left outer join md_member_statistics s on m.id = s.member_id
'''
query_str, params = self.query_users_where_clause(**args)
sql = sql + query_str
sql = sql + " order by m.id desc "
sql = Pagination.add_limit_clause(sql, args["page"])
return self.db.query(sql, *params)
def query_users(self, **args):
sql = '''
select m.id, m.username, m.email, m.member_type, m.regtime, m.recommend,
m.province_id, m.city_id, m.recommend_talent,
m.actived, s.works_count, s.lastlogintime, s.twitter_num, s.emotion_num,
from_unixtime(m.regtime) as regtime_str,
from_unixtime(s.lastlogintime) as lastlogintime_str
from md_member m left outer join md_member_statistics s on m.id = s.member_id
'''
query_str, params = self.query_users_where_clause(**args)
sql = sql + query_str
sql = sql + " order by m.id desc "
sql = Pagination.add_limit_clause(sql, args["page"])
return self.db.query(sql, *params)
def query_twitters(self, **args):
sql = '''
select m.id, m.share_type, m.createtime, from_unixtime(m.createtime) as createtime_str,
m.actived, s.description, s.comment_num,
p.id as pic_id, p.pic_url, p.img_path, p.img_type,
u.id as uid, u.username, u.member_type
from md_twitter m, md_twitter_show s, md_twitter_picture p, md_member u
where m.id = s.tid and s.pic_id = p.id and m.member_id = u.id
'''
sql, params = self.gen_query_str(sql, **args)
sql = sql + " order by m.createtime desc"
page = args.get("page", [1])[0]
sql = Pagination.add_limit_clause(sql, page)
return self.db.query(sql, *params)
def get(self):
salon_name = self.get_argument("salon_name", "")
province_id = self.get_argument("province_id", 0)
city_id = self.get_argument("city_id", 0)
domain_id = self.get_argument("domain_id", 0)
page = self.get_argument("page", 1)
salons = self.query_salons(salon_name, province_id, city_id, domain_id,
page)
count = self.fetch_salons_count(salon_name, province_id, city_id,
domain_id)
page_count = Pagination.page_count(count)
hairstylists = self.fetch_hairstylist_count()
logos = self.fetch_all_logos()
params = dict(
config=self.config,
# 沙龙列表
salons=salons,
hairstylists=hairstylists,
logos=logos,
default_img=self.default_image_url(),
#path_prefix=self.get_salon_path_prefix(),
# 查询模块
regions=self.fetch_all_regions(),
provinces=self.fetch_provinces(),
cities=self.fetch_cities(),
domains=self.fetch_domains(),
arguments=self.request.arguments,
# 分页
page_count=page_count,
# 提示信息
informer=BootstrapInformer("success", "共 %s 条记录" % count, "查询结果："),
)
self.render("salons/index.html", **params)
def get(self):
entries = self.query_twitters(**self.request.arguments)
count = self.query_twitters_count(**self.request.arguments)
page_count = Pagination.page_count(count)
informer = BootstrapInformer("success", "共 %s 条记录" % count, "查询结果")
# 图片的URL地址
for entry in entries:
entry["real_pic_url"] = self.real_pic_url(entry)
# 查询参数由数组变为数值
dataset = {}
for k, v in self.request.arguments.items():
dataset.setdefault(k, list(v)[0])
params = dict(
entries=entries,
config=self.config,
page_count=page_count,
informer=informer,
args=dataset,
)
self.render("twitters/index.html", **params)
def get(self):
salon_name = self.get_argument("salon_name", "")
province_id = self.get_argument("province_id", 0)
city_id = self.get_argument("city_id", 0)
domain_id = self.get_argument("domain_id", 0)
page = self.get_argument("page", 1)
salons = self.query_salons(salon_name, province_id, city_id, domain_id, page)
count = self.fetch_salons_count(salon_name, province_id, city_id, domain_id)
page_count = Pagination.page_count(count)
hairstylists = self.fetch_hairstylist_count()
logos = self.fetch_all_logos()
params = dict(
config=self.config,
# 沙龙列表
salons=salons,
hairstylists=hairstylists,
logos=logos,
default_img=self.default_image_url(),
#path_prefix=self.get_salon_path_prefix(),
# 查询模块
regions=self.fetch_all_regions(),
provinces=self.fetch_provinces(),
cities=self.fetch_cities(),
domains=self.fetch_domains(),
arguments=self.request.arguments,
# 分页
page_count=page_count,
# 提示信息
informer=BootstrapInformer("success", "共 %s 条记录" % count, "查询结果："),
)
self.render("salons/index.html", **params)
def fetch_all_seasons(self, page):
sql = '''select *, date(from_unixtime(createtime)) as createtime_str
from md_season_period order by createtime desc'''
sql = Pagination.add_limit_clause(sql, page)
return self.db.query(sql)
def fetch_all_seasons(self, page):
sql = '''select *, date(from_unixtime(createtime)) as createtime_str
from md_season_period order by createtime desc'''
sql = Pagination.add_limit_clause(sql, page)
return self.db.query(sql)