def paymentMonth(self): #获取所有人员名单 sql="select a.id,b.role_level from sc_user a,sc_role b,sc_userrole c where a.id=c.user_id and c.role_id=b.id" data = db.session.execute(sql).fetchall() pay = Payment() #上月 lst_fist = datetime.date(datetime.datetime.now().year,datetime.datetime.now().month-1,1) #客户经理工资计算 for obj in data: if obj.role_level==2: pay.payroll(obj.id,lst_fist,80) #后台岗工资计算 for obj in data: if obj.role_level==3: pay.backPayment(obj.id,lst_fist,80)
def htgKPI(id):
if request.method == 'GET':
kpi_yunying = SC_Kpi_Yunying.query.filter_by(id=id).first()
return render_template("Performance/ygpgkh/htgKPI.html",kpi_yunying=kpi_yunying)
else:
try:
kpi_yunying = SC_Kpi_Yunying.query.filter_by(id=id).first()
kpi_yunying.bm_dkye = request.form['bm_dkye']
kpi_yunying.bm_ghs = request.form['bm_ghs']
kpi_yunying.bm_lrgxd = request.form['bm_lrgxd']
kpi_yunying.gz_sjlr = request.form['gz_sjlr']
kpi_yunying.gz_ywtj = request.form['gz_ywtj']
kpi_yunying.gz_ht = request.form['gz_ht']
kpi_yunying.gz_fk = request.form['gz_fk']
kpi_yunying.gz_dagl = request.form['gz_dagl']
kpi_yunying.gz_khgx = request.form['gz_khgx']
kpi_yunying.gz_alzl = request.form['gz_alzl']
kpi_yunying.gz_fxkz = request.form['gz_fxkz']
kpi_yunying.gz_rcxw = request.form['gz_rcxw']
kpi_yunying.gz_yql = request.form['gz_yql']
kpi_yunying.total = request.form['total']
kpi_yunying.result = request.form['result']
kpi_yunying.qtpj = request.form['qtpj']
kpi_yunying.manager = current_user.id
kpi_yunying.date_2 = datetime.datetime.now()
#调用贺珈的函数
pay = Payment()
pay.backPayment(kpi_yunying.user_id,kpi_yunying.assess_date,kpi_yunying.total)
# 事务提交
db.session.commit()
# 消息闪现
flash('保存成功','success')
except:
# 回滚
db.session.rollback()
logger.exception('exception')
# 消息闪现
flash('保存失败','error')
return redirect('Performance/ygpgkh/zgpg_search')
