@app.route('/login-user', methods=['POST','GET'])
def login_user():
# global db_user
global user
if 'user' not in session.keys():
form = request.form
user_id=form['userid']
company_c=form['company_c']
user_id=user_id.upper()
user_password=form['password']
db_user=form['fiscals']
fy_pass=''
fiscal_pass = engine.execute(f"select u_password from fiscal_year where user_name='{db_user}' and rownum=1")
for pa in fiscal_pass:
fy_pass=(pa.u_password)
#fy_renew_date=(pa.AMC_RENEWAL_DATE)
# print(fy_pass)
session['db_user']=db_user
session['db_password']=fy_pass
session['fy_renew_date']='12-apr-2024'
which_db()
try:
get_user=db.session.execute(""" select a.com_code,a.user_cat_id,a.mdm_code,upper(a.login_name) login_name\
,(select c.bra_name from UC_BRANCH_RIGHTS b,mdm_bra_setup c\
where b.bra_code=c.bra_code and b.user_id=a.user_id and rownum=1) bra_name\
,(select bra_code from UC_BRANCH_RIGHTS where user_id=a.user_id and rownum=1) bra_code,fn_pbrain_decrypt(a.password) password,user_id from uc_user_master a where UPPER(a.login_name)= :val """,{'val':user_id}).all()
except Exception as e:
return 'Password is not set in decrypted OR form PLease contact Pbrain @ 9801827885 !!!'
user=''
user_code=''
user_cat=''
bra_code=''
password=''
mdm_code=''
# print("i AM here for you")
for ere in get_user:
user = ere.login_name
user_code=ere.user_id
user=user.upper()
# print("user "+user)
password = ere.password
company_code=ere.com_code
bra_code=ere.bra_code
bra_name=ere.bra_name
user_cat=ere.user_cat_id
mdm_code=ere.mdm_code
# print("PASS "+password)
# print("USERERS "+user_id)
#print("1")
if user_id == user and session['fy_renew_date'] >= '12-apr-2024':
flash("Please contact PowerBrains Pvt. Ltd. for renewal at 9801800001.")
request.endpoint
return redirect(url_for('loginMain'))
elif user_id == user and password == user_password:
# if not, redirect to index and give flask message (don't worry about javascript validation)
session['user']=user_id
session['user_cat']=user_cat
session['user_code']=user_code
session['company_code']=company_c
session['sl_code']=mdm_code
session['bra_code']=bra_code
session['bra_name']=bra_name
which_db()
get_com=db.session.execute(f"select com_name from mdm_com_setup where com_code='{session['company_code']}' and rownum=1")
print("3")
for com in get_com:
print("4")
company_name=(com.com_name)
print("5")
session['company_name']=company_name
session['send_token_data']={"user_id":user_id,"user_code":user_code,"com_code":company_c,"bra_code":bra_code,"db_user":db_user,"db_pass":fy_pass,"user_cat":user_cat,"company_name":company_name}
token=create_access_token(identity={"user_id":user_id,"user_code":user_code,"com_code":company_c,"bra_code":bra_code,"db_user":db_user,"db_pass":fy_pass,"user_cat":user_cat,"company_name":company_name})
# session.pop('token', None)
session['token']=token
print("2")
print(token)
print("6")
update_access_flags()
return redirect(url_for('home'))
else:
print("i was here")
flash("Password was incorrect or user doesn't exist.")
request.endpoint
return redirect(url_for('loginMain'))
else:
request.endpoint
return redirect(url_for('loginMain'))
UPDATE MDM_COM_SETUP SET AMC_RENEWAL_DATE='12-APR-2024';
COMMIT;
