def adminsaddentry(): if current_user.usertype == 'admin': if request.method == 'POST': uid = request.form['uid'] name = request.form['name'] year = request.form['year'] contact = request.form['contact'] address = request.form['address'] cutoff = request.form['cutoff'] brdpoint = request.form['brdpoint'] area = request.form['area'] branch = request.form['branch'] fathername = request.form['fathername'] fatheroccupation = request.form['fatheroccupation'] fathercontact = request.form['fathercontact'] email = request.form['email'] regno = request.form['regno'] dob = '-'.join(request.form['dob'].split('-')[::-1]) db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'insert into profile values ({uid},"{name}",{regno},"{dob}", "{address}", {contact}, "{email}","{brdpoint}", "{branch}", "{area}", "{fathername}", "{fatheroccupation}", {fathercontact}, {cutoff}, {year})' ) db.commit() db.close() return redirect('/admin') else: return render_template('admin/saddentry.html') else: return redirect(url_for('main'))
def subjectadd(): if current_user.usertype == 'admin': if request.method == 'POST': sem = request.form['sem'] subcode = request.form['subcode'] subname = request.form['subname'] branch = request.form['branch'] staffid = request.form['staffid'] year = request.form['year'] section = request.form['section'] db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'insert into subjects values({sem},"{subcode}","{subname}","{branch}","{staffid}",{year},"{section}")' ) db.commit() db.close() return render_template('attendance/add.html', alert="Subject added successfully") else: if session['message']: alert = session['message'] session['message'] = '' else: alert = '' return render_template('attendance/add.html', alert=alert)
def admineditprofile(): if current_user.usertype == 'admin': if request.method == 'POST': uid = request.form['uid'] name = request.form['name'] year = request.form['year'] contact = request.form['contact'] address = request.form['address'] cutoff = request.form['cutoff'] brdpoint = request.form['brdpoint'] bloodgrp = request.form['bloodgrp'] area = request.form['area'] branch = request.form['branch'] fathername = request.form['fathername'] fatheroccupation = request.form['fatheroccupation'] fathercontact = request.form['fathercontact'] email = request.form['email'] regno = request.form['regno'] dob = '-'.join(request.form['dob'].split('-')[::-1]) db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute('select * from profile') print( f'update profile set name = "{name}", regno = {regno}, dob = "{dob}", address = "{address}", contact = {contact},email = "{email}",brdpoint = "{brdpoint}", branch = "{branch}",area = "{area}",fathername = "{fathername}",fatheroccupation="{fatheroccupation}",fathercontact={fathercontact}, cutoff={cutoff}, year={year} where id = {uid}' ) cursor.execute( f'update profile set name = "{name}", regno = {regno}, dob = "{dob}", bloodgrp = "{bloodgrp}", address = "{address}", contact = {contact},email = "{email}",brdpoint = "{brdpoint}", branch = "{branch}",area = "{area}",fathername = "{fathername}",fatheroccupation="{fatheroccupation}",fathercontact={fathercontact}, cutoff={cutoff}, year={year} where id = {uid}' ) db.commit() db.close() return redirect(url_for('adminsprofilemain'))
def staff_materials(): if current_user.usertype == 'staff': if request.method == 'POST': upfile = request.files['filename'] branch = request.form['branch'] sem = request.form['sem'] subject = request.form['subject'] mtype = request.form['mtype'] captions = request.form['captions'] import os upfile.save("./erp/sts/materials/" + upfile.filename) db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'select code from subjects where name like "{subject}"') subject = cursor.fetchall()[0][0] cursor.execute( f'insert into materials values ( "{branch}", "{sem}", "{subject}", "{upfile.filename}", "xyz", "{mtype}", "{captions}")' ) db.commit() db.close() session['message'] = 'Uploaded Successfully' return redirect(url_for('staff_materials')) else: try: print(session['message']) if session['message']: alertmessage = session['message'] session['message'] = '' else: alertmessage = '' except: alertmessage = '' print(alertmessage) db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'select * from subjects where staffid like "{current_user.uid}"' ) data = cursor.fetchall() cursor.execute( f'select branch from subjects where staffid like "{current_user.uid}" group by branch' ) secdata = cursor.fetchall() print(data) db.close() return render_template('staff/materials.html', data=data, secdata=secdata, alertmessage=alertmessage)
def profile(): db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute(f'select * from profile where id={current_user.uid}') data = cursor.fetchall()[0] db.close() return render_template('profile.html', data=data)
def circular(): db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute('select * from circular') data = cursor.fetchall() db.close() return render_template('circular.html', data=data)
def adminviewprofile(): if current_user.usertype == 'admin': db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute(f'select * from profile') db.close() data = cursor.fetchall() return render_template('admin/viewprofile.html', data=data) else: return redirect(url_for('main'))
def deletestudent(studentid): if current_user.usertype == 'admin': db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute(f'delete from profile where id={studentid}') db.commit() db.close() return redirect(url_for('adminsprofilemain')) else: pass
def staff_home(): if current_user.usertype == 'staff': db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'select name, branch, year, sem, code from subjects where staffid like "{current_user.uid}"' ) data = cursor.fetchall() print(data) db.close() return render_template('staff/staff_h_page.html', i=data) else: return redirect(url_for('main'))
def subjects(): if not request.args: db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'select sem, name from subjects where branch like (select branch from profile where id = {current_user.uid})' ) data = cursor.fetchall() # ((1,"sci"),(2,"poi")) subject = {} for i in data: if i[0] in subject: subject[i[0]].append(i[1]) else: subject[i[0]] = [0, i[1]] print(subject) print("\n\n\n\n\\n\n\n\n\n\n\n\\n\nn\n", data) cursor.execute( f'select * from materials where branch like (select branch from profile where id = {current_user.uid})' ) print('\n\n\n\n\n\\n\n\n\n', subject) materials = cursor.fetchall() db.close() return render_template('subjects.html', subject=subject, materials=materials) else: subject = request.args.get('subjects') type = request.args.get('material') sem = request.args.get('sem') db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'select name, captions, filename from materials where branch like (select branch from profile where id = {current_user.uid}) and subject like (select code from subjects where name like "{subject}") and type like "{type}"' ) data = cursor.fetchall() return render_template("materials.html", data=data, type=type)
def main(): session['message'] = '' if current_user.usertype == 'student': db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute(f'select * from profile where id={current_user.uid}') data = cursor.fetchall()[0] db.close() return render_template('main.html', data=data) elif current_user.usertype == 'admin': return redirect(url_for('admin')) elif current_user.usertype == 'account': return redirect(url_for('accountspage')) elif current_user.usertype == 'staff': return redirect(url_for('staff_home')) else: return redirect('/attendance/mark')
def subjectedit(): if current_user.usertype == 'admin': if request.method == 'POST': try: subname = request.form['subname'] except: subname = None if subname: xyz = request.form sem = request.form['sem'] subcode = request.form['subcode'] branch = request.form['branch'] staffid = request.form['staffid'] year = request.form['year'] section = request.form['section'] db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'update subjects set sem = {sem},year = "{year}", section = "{section}", branch = "{branch}", staffid = "{staffid}", name = "{subname}" where code = "{subcode}"' ) db.commit() db.close() session['message'] = 'Edited Successfully' return redirect('/subject/add') else: subcode = request.form['subcode'] print(subcode) db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'select * from subjects where code = "{subcode}"') data = cursor.fetchall()[0] return render_template('attendance/edit.html', data=data) else: return render_template()
def staff_marks2(): if current_user.usertype == 'staff': if request.method == 'POST': data = dict(request.form) print(markdata.values) for i in data.keys(): markdata.values[str(i)]['sem' + str(session['sem'])][''.join( session['testname'].lower().split())]['marks'].append( data[i]) markdata.values[str(i)]['sem' + str(session['sem'])]['sub'].append( session['subject']) markdata.commit() session.pop("sem", None) session.pop("testname", None) session.pop("branch", None) session.pop("subject", None) session.pop("sec", None) return redirect(url_for('main')) else: sec = session['sec'] testname = session['testname'] branch = session['branch'] subject = session['subject'] db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'select id, name from profile where section like "{sec}" and branch like "{branch}"' ) data = cursor.fetchall() cursor.execute( f'select sem from subjects where code like "{subject}"') session['sem'] = cursor.fetchall()[0][0] db.close() return render_template('staff/marks_2.html', data=data)
def staff_attendance_mark(): if current_user.usertype == 'staff': if request.method == 'POST': book = load_workbook(path) writer = pd.ExcelWriter(path, engine='openpyxl') writer.book = book try: df = pd.read_excel(path, sheet_name=session['date']) except: df = pd.read_excel(path, sheet_name='template') attendance = {} db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'select id from profile where branch = \'{session["branch"]}\' and year = {session["year"]} and section like \'{session["sec"]}\'' ) for i in cursor.fetchall(): for j in df.values: if i[0] in j: tempvar = True break else: tempvar = False if tempvar: pass else: df = df.append( { 'sid': i[0], 'session1': 'p', 'session2': 'p', 'session3': 'p', 'session4': 'p', 'session5': 'p', 'overall': 'p' }, ignore_index=True, ) cdata = request.form for i in cdata: temp = i.split('-') attendance[int(temp[1])] = temp[0][0] print(attendance) for i in attendance.keys(): df.loc[df['sid'] == i, [session['session']]] = attendance[i] print(df) writer.sheets = dict((ws.title, ws) for ws in book.worksheets) df.to_excel(writer, sheet_name=session['date'], index=False) writer.save() writer.close() session['message'] = "Attendance Marked Sucessfully" db.close() return redirect(url_for('main')) else: db = pymysql.connect('localhost', password='******', db='erp', user='******') cursor = db.cursor() cursor.execute( f'select id,name from profile where branch = \'{session["branch"]}\' and year = \'{session["year"]}\' and section = \'{session["sec"]}\'' ) data = cursor.fetchall() print(data) db.close() return render_template('staff/markAttendance.html', data=data, len=len)