def get_count_query(self):
if wwwutils.get_filter_by_user():
curr_user = airflow.login.current_user
return self.session.query(func.count('*')).filter(
self.model.username == curr_user.user.username)
else:
return self.session.query(func.count('*'))
def get_count_query(self):
if not current_user.is_authenticated:
return self.session.query(
func.count('*')).filter(self.model.author == None)
elif current_user.has_role('admin'):
return self.session.query(func.count('*'))
else:
return self.session.query(
func.count('*')).filter(self.model.author == current_user)
def get_count_query(self):
if login.current_user.has_role('posel2'):
return self.session.query(func.count('*')).select_from(
self.model).filter(self.model.hostel_id == 1)
elif login.current_user.has_role('posel3'):
return self.session.query(func.count('*')).select_from(
self.model).filter(self.model.hostel_id == 2)
elif login.current_user.has_role('posel4'):
return self.session.query(func.count('*')).select_from(
self.model).filter(self.model.hostel_id == 3)
else:
return self.session.query(func.count('*')).select_from(self.model)
def get_query(self):
return self.session.query(
Account.id, Account.name, Account.text,
func.count(
Article.id).label("article_count")).join(Article).group_by(
Account.id)
def get_list_count_by_scoreaccount(model_class, view_class, view_object):
from flask_login import current_user
from flask_admin.contrib.sqla.view import func
if not current_user.is_admin():
from plugins.score import ScoreAccount
accounts = tuple(
[r.name for r in ScoreAccount.find_by_user(current_user.username)])
return view_object.session.query(func.count(1)).filter(
model_class.account.in_(accounts))
else:
return super(view_class, view_object).get_count_query()
def get_list_count_by_botassign(model_class, view_class, view_object):
from flask_login import current_user
from flask_admin.contrib.sqla.view import func
if not current_user.is_admin():
from common.bot import BotAssign
botids = tuple(
[r.botid for r in BotAssign.find_by_user(current_user.username)])
return view_object.session.query(func.count(1)).filter(
model_class.botid.in_(botids))
else:
return super(view_class, view_object).get_count_query()
def on_model_change(self, form, model, is_created=True):
model.month = date(model.month.year, model.month.month, 1)
user = User.query.get(model.uid)
basic = user._job.base_salary
atd_days = db.session.query(func.count('*')).\
filter(Attendance.uid == model.uid,
extract('year', Attendance.day) == extract('year', model.month),
extract('month', Attendance.day) == extract('month', model.month),
).scalar() or 0
alw_sum = sum(alw.bounty for alw in user.allowances
if (alw.day.year, alw.day.month) == (model.month.year,
model.month.month))
model.salary = basic + atd_days * 100 + alw_sum
model.dept = user.dept
return model
def get_count_query(self):
return self.session.query(
func.count('*')).filter(self.model.f_verify != 0)
def get_count_query(self):
return self.session.query(
func.count('*')).filter(self.model.f_src == 'h5')
def get_count_query(self):
last_90_day = datetime.now() + timedelta(days=-90)
num_last_90_receipes = self.session.query(func.count('*')).\
filter(self.model.community_id == current_user.community.id).\
filter(self.model.delivery_time >= last_90_day)
return num_last_90_receipes
def get_count_query(self):
return self.session.query(func.count('*')).filter(self.model.username != 'admin')
def get_count_query(self):
return self.session.query(
func.count("*")).filter(self.model.is_superuser is False)
def get_count_query(self):
current_user = flask_login.current_user
return self.session.query(
func.count('*')).filter(self.model.userid == current_user.id)
def get_count_query(self):
return self.session.query(
func.count('*')).filter(self.model.returned == False)
def get_count_query(self):
return self.session.query(func.count('*'))
def get_count_query(self):
return self.session.query(
func.count('*')).filter(self.model.status == 0)
def get_count_query(self):
semester = models.Semester.query.filter_by(current=True).one()
return self.session.query(func.count('*')).filter(self.model.semester==semester)
def get_count_query(self):
return self.session.query(
func.count('*')).filter(self.model.uid == current_user.uid)
