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')