=47%RVfҫTN]U% ( bAVoC܎ } ~]fKkְwsLGY;ֳL+ZB%Ur%XiUQc^:H{D<9K$f6ZZ.UgG 㥌ypi3@qcVTeu&eϖ⏈D1{btJlɩբ 7Mc-zv2&_gi.3PAo g8ۙI9"(ܔ< k{,\.di)׿# <ұ0ݻ-,Դ[7aP[,$С4g}7=^ \HUl֦-Bn1yĩr<* L#pڣYI U!1ebx`qGs@3j|f c`.[4f Wq>E*-%EsXF 5G-QVwF](#$eقPe1M}kԾ!膱v+Ak+^Fzf}I ьk%c(k!B&>jѨd?5޽eWpGw_@dgo[4%5\w[)&-PErP g`tFVN +WKneA^_-|Yb'3Ux\A3@NJO'nx0)塐㾊 $i)+-5k.m٣ˌى.bBPqPғont0@Xo0E{#%W g7 ll\}{HY-_}hCϪR]ױ-X]i p~Sf 6-Wk}ME$?&@nEs96b cڼ|2-0=gZ!/p%*B%Cxxu# ?3a qc:kݩZ`dŭq^y,[Ћ |a0zu ɡke \E,1hz~:WY:\VJĹNTk,C0 TQ,?\,t!*]쥆kNn=Lr/d6V>Ӝ06e4f 'Yy&VFdSVC &s .ZGK*Q9D-6ͭI 6{aB΍kCQ݇&*vٞ%!'FH_ Q\qʙ̿&$AvcSsy]gI"RsBum:F2$˾hF*:u8-]^!Nm<[z $0=k.)!Sܴ_i-mĢBר' ԁp5}PGs?R[I`/B`u "L*]a ȫ̱mֵe{:|j5s3HbQ8 @v]CEpw~ r;8+ ?O= OM cI`TxAOj"8ܰp;$#NdA[[/}W^F%@މM17s}$T]qz`>Op=%ۻs-4l<;5@jR2 neNDGT%BV`I;1+D]McT%=c@VG'/1aCD 5[!CT٭cn$aKfjLqˑ"ylӁl8{A^ԉk/Qd`gMGFH'"9l~w0%QQkWJkqwSD=l aLX N#~:`[Ϲk\pJ :(QbUo\h$J+tkI`1jlkk+`҉zDdR%HORKqN.6]w6}A{pӸ^F%@މM17s}${ bVRa;\X?ҞPoz₻r+ JeJRB>pCQe|A!G8TlЛa Iڦ  jtԛ,L(9>'jIyVl_D{srN94qsa/mF|kH3ab@{eT9 T{x$?ip+tkI`1jlk6:.Oen$[C틢Gj&h8.YAy vV`I;1+D7K OwkfOx:3҇Vw`!g^T:j}:\`Ǐ8)2|D;M$~>W.\hj̜Uxo-Ճ\aUqCAYBऎN*/wYSTXH&r53~} < ARɒӹ{]W (ZύF(#SOCCް(?qzk׾]gFA{-w`a'L33Vcw2SHw +yWr3gft-K\ IF͵c\+SPV29|gQe |zf-;s KxƲtЌO-~Jӊe!7jm2m|%1M8^~lN,Bo&vAx,'m ]6W/%~5:'AoB7?DXŞtL'C_`0&gFͩ32rY0QMGFH'"9l~w0%QQkWJkqwSDmB`*Dp>F<ܤVK(ࠍk4VV`97Z8JsE /ik[aɺ' 8=Wf VrZC_׿ ]&C,T|KbdH":$q#ntd3zc*cW]=o"nogT0AT|sV赕miZo?W8Iٴ-\c:qD{%`Lf'D/f{oƚ fW w:kP|G@6; Ibq;BY ԃ1&&Gx#3]|ȿiBR)헶hDN5;P,|pcPI%ɸ-ɔHvظmⅱCۘ?31!yI8C }5a鼊l—hN\vXgcl7mP8kKqN.6TqxKU$(AcZeWx C:F"Q#Za%%y 'rfzëOZ 5a鼊l—hN\vXgcbgAxù w?:Wp^V <pjDDQdlanN TtfrC :JNvyEny|yf3=OB;]ȟt7SODf>ŧU(iKHatٶh{]ݠH?C`ӣiRMdoh5K7hs$`[,$С4g}7=^ \HUl֦-Bn1yĩr<*),Q6yO.i5NmZNXrH<3*  GVe3mpxÊLUfs set Description='$subjectsFail' where headType='subjectsFail'"); else odbc_exec( $conn, "insert into FeeHeads (Description,headType) values('$subjectsFail','subjectsFail')"); }else{ // on Aggregate $query = "select ID from rollno where TermID='$termID' and Year_='$session' and obtmarks*100/totalmarks<$percentFail"; $query = "update rollno set remarks='Fail' where TermID='$termID' and Year_='$session' and id in ($query)"; $passingPapers=getName($conn,"select Description from FeeHeads where headType='percentFail'"); if($passingPapers!="") odbc_exec( $conn, "update FeeHeads set Description='$percentFail' where headType='percentFail'"); else odbc_exec( $conn, "insert into FeeHeads(Description,headType) values('$percentFail','percentFail')"); } odbc_exec( $conn, $query); //$failType=getName($conn,"select Description from FeeHeads where headType='failType'"); if(getName($conn,"select Description from FeeHeads where headType='failType'")!="") odbc_exec( $conn, "update FeeHeads set Description='$failType' where headType='failType'"); else odbc_exec( $conn, "insert into FeeHeads(Description,headType) values('$failType','failType')"); //odbc_exec( $conn, "insert into FeeHeads(Description,headType,ID) values('$percentFail','failType',(select max(ID)+1 from FeeHeads))"); //calculate positions $query = "Select percentage,ID from qryRollNo where TermID='$termID' and Year_='$session' order by percentage desc"; $positionNo=0;$prepercentFail=0; //$rsCount ="22";// getName($conn,"Select Count(ID) from RollNo where TermID='$termID' and Year_='$session'"); $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { if($prepercentFail!=odbc_result( $cur, 'percentage' )) $positionNo++; odbc_exec( $conn, "update rollno set schoolPosition='$positionNo' where id='".odbc_result( $cur, 'ID' )."' and termid='$termID' and year_='$session'" ); $prepercentFail=odbc_result( $cur, 'percentage' ); } $cur1= odbc_exec( $conn, "Select ClassID,count(*) from RollNo where TermID='$termID' and Year_='$session' group by classid" ); while( odbc_fetch_row( $cur1 ) ) { $query = "Select percentage,ID from qryRollNo where classID='".odbc_result( $cur1, 'ClassID' )."' and TermID='$termID' and Year_='$session' order by percentage desc"; $positionNo=0;$prepercentFail=0; //$rsCount =odbc_result( $cur1, 1 ); $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { if($prepercentFail!=odbc_result( $cur, 'percentage' )) $positionNo++; odbc_exec( $conn, "update rollno set classPosition='$positionNo' where id='".odbc_result( $cur, 'ID' )."' and termid='$termID' and year_='$session'" ); $prepercentFail=odbc_result( $cur, 'percentage' ); } } //''''''''''''''''''''''' Section wise POosition $cur1= odbc_exec( $conn, "Select section_,ClassID,count(*) from RollNo where TermID='$termID' and Year_='$session' group by section_,ClassID" ); while( odbc_fetch_row( $cur1 ) ) { $query = "Select percentage,ID from qryRollNo where classID='".odbc_result( $cur1, 'ClassID' )."' and section_='".odbc_result( $cur1, 'section_' )."' and TermID='$termID' and Year_='$session' order by percentage desc"; $positionNo=0;$prepercentFail=0; //$rsCount =odbc_result( $cur1, 2 ); $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { if($prepercentFail!=odbc_result( $cur, 'percentage' )) $positionNo++; odbc_exec( $conn, "update rollno set sectionPosition='$positionNo' where id='".odbc_result( $cur, 'ID' )."' and termid='$termID' and year_='$session'" ); $prepercentFail=odbc_result( $cur, 'percentage' ); } } //echo $query = "update rollno set sectionPosition=(select positionName from position where position.positionID=CAST(rollno.sectionPosition AS int)) where termid='$termID' and year_='$session'" ; $query = "update rollno set sectionPosition=(select positionName from position where position.positionID=rollno.sectionPosition) where termid='$termID' and year_='$session'" ; $cur= odbc_exec( $conn, $query ); echo "Result Calculated "; //echo fillCMB($conn,$feeID,"select ID,Description from FeeHeads where (headType='feeHead') order by order_"); } $total1= 0; $discount1= 0; $paid1= 0; echo "
"; echo ""; echo "
session
"; echo "		Term
"; if($failType=='0'){ echo "		Fail Subjects:%age:"; }else{ echo "Fail Subjects:%age:"; } echo ""; echo "Class
"; echo "		Section
"; echo "		"; echo ""; echo ""; echo "
"; $TotalThMarks= 0; $TotalPrMarks= 0; $passpercentFail= 0; odbc_close($conn); ?>