li0SSKJr SSKJrJr SSKJr SSKrSSK J r SSK r SSK J r SS1r/S Q/S QS .rS rS rSrSrSrg))db) StudentTable TeacherTable)SelectN) flag_modified)encrypt_passwordxlsxxls) firstnamelastnameroll_nogradesection)r r rr)studentteachercnSU;=(a* URSS5SR5[;$)N.)rsplitlowerALLOWED_EXTENSIONS)filenames >D:\beyond school\05_solvesmart\server\src\utils\upload_file.py allowed_filers0 (? WxsA6q9??AEWWWc US:Xa[[5R[RU:H5n[R R U5R5R5n/nUHWnURURURURURURURS.5 MY [ R""U5nO[[$5R[$RU:H5n[R R U5R5R5n/nUHinUR&HVn URURURU R)S5U R)S5URS.5 MX Mk [ R""U5n[*R,"5n [ R."U SS9n UR1U SS S 9 /S QUR)S S 5UR)SS 5UR)S S 5UR)SS 5-/S.n US:Xa:U SR3SS5 U SR3SUR)SS 55 [ R""U 5n U R1U SS S 9 SSS5 U R5S 5 U $!,(df  N!=f)z'Generate Excel file with processed datar) FirstnameLastnamezRoll NoGradeSectionUsernameclassr)rrrr r!openpyxl)engineDataF) sheet_nameindex)AddedSkippedTotaladdedrskipped)MetricCountrr-rUpdatedr.updatedSummaryN)rrwhere school_idrsessionexecutescalarsallappendr r r rrusernamepd DataFramergradesgetioBytesIO ExcelWriterto_excelinsertseek)result file_typer3stmt all_recordsdatardfr grade_infooutputwriter summary_data summary_dfs rgenerate_excel_reportrOskIl#)),*@*@I*MNjj((.668<<> "G KK$..#,,"?? "??#,,  #\\$ l#)),*@*@I*MNjj((.668<<> "G%nn  !(!2!2 ' 0 0'^^G4)~~i8 ' 0 0 -#\\$ ZZ\F z 2f FvU ;4 7A& 9a( 7A&Iq)AA   !  " ) )!Y 7  ! ( (FJJy!,D E\\,/ FyF' 3* KKN M- 3 2s CK## K1c [R"U5nURVs/sH o3R5R 5PM" snUl[ [ 5R[ RU:H5n[RRU5R5R5n[U5S-n[SU55n0nUHwn [!U R"5R 5[!U R$5R 54n X;a [5X'XR'U R(5 My Sn Sn /n UR+5GH9up[!UR-SS55R 5n[!UR-SS55R 5n[!UR-SS55R 5n[!UR-SS55R 5nUR-S 5nU(a0U(a)U(a"U(a."U5(a U S- n U R1S US -S 35 GM[3U5nUR5UR5UUU4nUU;aU S- n GMPUU4nUU;a1UUU;a(U S- n U R1S US -SUSUSU35 GMUR5SUUUU3nUR5U3n[ UUUUUUUUUUS9 nUR9U5 [RR'U5 UR'U5 UU;a [5UU'UUR'U5 U S- n GM< [RR=5 SU SU S3nU (a&[U 5S::aUSSR?U 53- nSUU U S.$s snf![4[64a" U S- n U R1S US -S 35 GMf=f![:a4nU S- n U R1S US -S[!U535 SnAGM SnAff=f)z7Process student Excel file and add students to databaserc3r# UHnURR5R5UR=(d SR5R5[ UR 5R5[ UR 5R5UR4v M g7f)N)r rstripr strrrr ).0stus r 'process_student_file..cs  C MM   ! ' ' ) \\ R & & ( . . 0  N "   " " $ KK   sB5B7rr rRr rrr Row : Missing required fieldsz: Invalid roll numberz: Roll number z already exists in Grade z , Section _) r9r r rrr r3overall_ranking speed_rankingaccuracy_ranking: NzStudents processed:  added,  skipped . Errors: ; T)successmessager+r,) r: read_excelcolumnsrrSrrr2r3rr4r5r6r7lensetrTrraddr iterrowsr=isnar8int ValueError TypeError set_password Exceptioncommitjoin) file_pathr3rIcolstmt_all_student all_students ranking_startexisting_student_setexisting_roll_nosrVkey added_count skipped_counterrorsidxrowr r rrr student_keygrade_section_keyr9default_password new_studentergs rprocess_student_filerXsi y !B13<#))+##% '!#!# -+!. K  $ $%5 6 JJNN; ' ! $ $[ 1 (997:u!"34 / 0 4 4W = 1 KK"XJJ$[M-QG #f+"Z & 1233  c=^ * "  S1WI-BCD n 6 Q M MMDq CF84 5 5 6sO'P :D Q P.Q8Q>B.Q-Q>QQQ R(Q??Rc ^^[R"U5nURVs/sH oDR5R 5PM" snUl[ [ 5R[ RU:H5n[RRU5R5R5n0nUH`nURR5R 5UR=(d SR5R 54n XU 'Mb Sn Sn Sn /n UR!5GHup[#UR%SS55R 5n[#UR%SS55R 5n[#UR%SS55R 5m[#UR%SS55R 5mU(aU(aT(aT(dU S- n U R'SUS -S 35 MUR5UR54nUU;aUUn[)UU4S jUR*55nU(aU S- n GM@UR*R'TTS .5 [-US 5 [RR/U5 U S- n GMUR5UR5SU3nUR5UR53n[ UUUTTS ./U[1U5US9n[RR/U5 UUU'U S- n GM [RR55 SU SU SU S3nU (a&[7U 5S::aUSSR9U 53- nSUU U U S.$s snf![2a4nU S- n U R'SUS -S[#U535 SnAGMSnAff=f)z>Process teacher Excel file and add/update teachers in databaserRrr r rrrrYrZr[c3># UH4nURS5T:H=(a URS5T:Hv M6 g7f)r"rN)r=)rUgrrs rrW'process_teacher_file..s;++EE'Ne+Ki0@G0KK+s?K//+K8(++$^^+($ (!Q&MNN))Eg*NO"'84JJNN7+!Q&M(oo/01A0B!I;O&/oo&7%89I8J#K *'%%&+@A'-.>?!  {+1<!+.q o"|JJ$[M- S`RaaijG #f+"Z & 1233   k=T 6 Q M MMDq CF84 5 5 6s3'OCO&AOAOB O P(O??Pcz[R"U5nURVs/sH o3R5R 5PM" nn[ R U/5nUVs/sH ofU;dM UPM nnU(aSSSRU534$UVs/sH ofU;dM UPM nnU(aSSSRU534$[U5[U5:waSS[U5S[U5S34$gs snfs snfs snf![an SS [U 534sSn A $Sn A ff=f) NFzMissing required headers: z, zExtra invalid headers found: z Header count mismatch. Expected z headers but found r)TzHeaders validated successfullyzError reading file: ) r:rhrirrSREQUIRED_HEADERSr=rurjrsrT) rvrErIrw file_headersrequired_headershmissing_headers extra_headersrs rvalidate_headersr5s?6 ]]9 %79zzBz ))+z B+// 2>&6P&6<:O1&6P 6tyy7Q6RSS S$0NLq=M4ML N 9$))M:R9STT T | $4 5 5src.lib.bcryptrrrrrOrrrrrrsU13 +e_H< XBJyx^B6r