2-;R$?1祧Wgբv~ar$qj8NSl"2#n\|P-j>ub}r]oP0̰Mc{8M6rS)SPtVڒmK ?Io0B>G(]"Nu~5Wb[>!uJiy5YZ|O~}vܰB`i>h~w9j`ˀqE,P%q)hn[ #yqqK޼2zٶ8n$GZάhFxM%5@{:T\l{M>7t]w/҇Xk ;R6L!J>'%Vΐ9d8K7OuQIǍ4]L:X0iҋ+5oSWekě1;2إr8`TAchGkȎ}jwH*!~?\wBa'P2faV*I#:B%n,9B-@?zۜZFS5]94h4}nhjW4e%yG1Dsy]Annl/1)7+n! /@g'W7_2KUz/VMo#I$j!/ n5i>z FD66}0{'X{X lIlf>LՏ -8^݁O-P Δ麌)뎜(0yfQ2Pj/|ԫ e2kAxn7`[<)lg=-5\Ds*hVZIaX3mDf !pĜ꒥3U~Sed\9,we/whlk;ˍ$>Sy`) & ̶Y+qzϦ`05U0gJoQ.nBtłf5vf!yP8Y7yʨĪ`oL;p=T"qbl[/C(^#ǝvY}6vBIJsI"1v[4˱*h (S%?|TBš۱s?9%&w9,mAJDCg kU%qcV|+\|hգbɩt @/#ڪPs _ <55+""aYH!0\`  dpv2xgXw% f)onCx &`Jr8 lBoa=ʕuQr*4a9jn*NƱZABχGP< ڂ@/v> :Y99eAa?vA!Ufѣ-=/k-lQ$N#n^WGVL"v]MWx<lÅgm-lQ$N#n^WlC~f<ιg;J$߇Ƌlm[=RmnT,!*zɎA0 ]U,x URtgxfRE~MaNkQҹnD>[R[`Ѥsݐmֳ&~J[&5C"j5[HbRjQu[O{hVr?j+WP&̵UD xB͕,mzɪsX;(#NE4J^ڴfm2\aF&(oDyzﮌ6LAY݆S"IBTG F C&[ܐX8%+3%sBq6V&ZQ7{Ͱ ~) c_c(bj]fE5mW7AɅ ٪ljCoW5\:+ TOr*~_Xkpw@{GIV0*Yjy<L$4E>7y[*X3WѼ)'[2] ]tJcmBP>m,:Y!SjSbKI(k_[,$С4g}#NY3(Fb>P39Rgm{hPdn!"Ոu_ъ2姜So=U']'a]vF n:M-)3,< j[5CT>M]xx &`Jr8 lBoa=ʕuQr*4a+/E_%KLrZw!}n)xRAv䚦MwP~%f]?iBK*'H?'K |Hh{`lmHT9 T{x$?ip#+m9}t*p| ᨇ5X}숊lpQNb0X]`+)c#mY]"9h J$2xEoH|AIݲd ߋP\ěvXlose3-b&D)"bNtU ƌT.:Nc%鄺)/ci-L>GL"?_``G9"+-=?vlZ}~ G̢ҍLA)ii+J@ ƫwW~~qlv' \٦se5 !BvY%ꖐe> )!'ֽ̙ ٰ;sK痼z0 >a[@u~.U~/Z}Ф~bz*۠n}B /NJ^lP2S.ܸs&~q@r+Zt&Position: $position
Exam: $Year_
TERMS: $TermName"; // Hira New Exam Pattern //echo "select top 1 paperType from obtainedMarks where rollno='$ID' and Year_='$Year_' and TermID in ($TermID)"; $online =getName($conn, "select top 1 paperType from obtainedMarks where rollno='$ID' and Year_='$Year_' and TermID in ($TermID)"); if($online!=""){ //echo "Click to show DMC"; $subjects=array(); $paperTypeName=array(); $totalmarks=0; $query = "SELECT distinct subID,subName from dmcPreSchoolView where rollNo='$ID' and TermID in ($TermID) and year_='$Year_' order by subID"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { $subjects[$cnt++]= odbc_result($cur,'subName'); } $query = "SELECT distinct paperType,paperTypeName,totalThMarks,order_ from dmcPreSchoolView where rollNo='$ID' and TermID in ($TermID) and year_='$Year_' order by order_"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { $paperTypeName[$cnt++]= odbc_result($cur,'paperTypeName'); $totalThMarks[$cnt-1]= odbc_result($cur,'totalThMarks')*$termsNo; $totalmarks+=$totalThMarks[$cnt-1]; } echo "
SNOSubject"; for($x=1; $x<= count($paperTypeName); $x++) { echo "".$paperTypeName[$x]."
".$totalThMarks[$x]; } echo "		Total
$totalmarks"; for($x = 1; $x <= count($subjects); $x++) { echo "
$x".$subjects[$x].""; $t1=0; for($y = 1; $y <= count($paperTypeName); $y++) { $marks=getName($conn,"select isnull(sum(thMarks1),0) from dmcPreSchoolView where subName='".$subjects[$x]."' and paperTypeName='".$paperTypeName[$y]."' and rollNo='$ID' and TermID in ($TermID) and year_='$Year_'"); $t1+=$marks; $color=getName($conn,"select case when thMarks1*100/totalThMarks$marks"; echo "$marks"; } echo "$t1"; } $t1=0; echo "
Summary"; for($x = 1; $x <= count($paperTypeName); $x++) { $marks=getName($conn,"select isnull(sum(thMarks1),0) from dmcPreSchoolView where paperTypeName='".$paperTypeName[$x]."' and rollNo='$ID' and TermID in ($TermID) and year_='$Year_'"); $t1+=$marks; echo "$marks"; } $totalmarks=$totalmarks*count($subjects); echo "$t1 / $totalmarks"; exit(); } $online=""; $online =getName($conn, "select top 1 obtained3rd from obtainedMarks where rollno='$ID' and Year_='$Year_' and TermID='$TermID'"); if ($online=="") { $query = "select SubName,TotalThMarks,TotalPrMarks,thMarks1,prmarks1,Remarks,ClassName,SectionName,SectionPosition from DMC_View where ID='$ID' and Year_='$Year_' and TermID in ($TermID) order by SubID "; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { if ($cnt==1 ){ $ClassName=odbc_result( $cur, 7 ). "-" .odbc_result( $cur, 8 ); $Remarks= odbc_result( $cur, 6 ); echo "
Class$ClassName"; echo "
Remarks$Remarks"; echo "
Class Position". odbc_result( $cur, 9 ); echo "

"; echo "
SerialSubjectTotal MarksObtained Marks%age
TheoryPrac/OralTotalTheoryPrac/OralTotal"; } $SubName= odbc_result( $cur, 1 ); $ThMarks= odbc_result( $cur, 2 ); $PrMarks= odbc_result( $cur, 3 ); $ThMarks1= odbc_result( $cur, 4 ); $PrMarks1= odbc_result( $cur, 5 ); $t1=$t1+$ThMarks; $t2=$t2+$PrMarks; $t3=$t3+$ThMarks1; $t4=$t4+$PrMarks1; $total1=$ThMarks+$PrMarks; $obttotal1=$ThMarks1+$PrMarks1; $percentage=$obttotal1*100/$total1; $percentage=number_format((float)$percentage, 2, '.', ''); echo "
$cnt$SubName$ThMarks$PrMarks$total1$ThMarks1$PrMarks1$obttotal1$percentage"; $cnt+=1; } $total1=$t1+$t2; $obttotal1=$t3+$t4; if ($total1==0 ) $percentage=0; else $percentage=$obttotal1*100/$total1; $percentage=number_format((float)$percentage, 2, '.', ''); if ($total1==0 ) echo "

Sorry! Exam Data not Available

"; else echo "
Summary$t1$t2$total1$t3$t4$obttotal1$percentage"; echo "
"; }else { $query = "select ClassName,SectionName,Remarks,SectionPosition from qryrollno where ID='$ID' and Year_='$Year_' and TermID in ($TermID) "; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $ClassName=odbc_result( $cur, 1 ). "-" .odbc_result( $cur, 2 ); $Remarks= odbc_result( $cur, 3 ); echo "
Class$ClassName"; echo "
Remarks$Remarks"; echo "
Class Position". odbc_result( $cur, 4 ); echo "

"; } $query = "select Subjects.SubName,TotalThMarks,thMarks,TotalPrMarks,prmarks,Remarks,ClassID,Section_,'SecPos',obtained3rd,total3rd from ObtainedMarks, Subjects where Subjects.SubID=obtainedMarks.SubID and rollno='$ID' and Year_='$Year_' and TermID in ($TermID) order by obtainedMarks.SubID "; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { if ($cnt==1 ){ echo "
SerialSubjectFirst Term2nd TermFinal TermCombined Result%age
TotalObtainedTotalObtainedTotalObtainedTotalObtained"; } $SubName= odbc_result( $cur, 1 ); $total1st= odbc_result( $cur, 2 ); $obt1st= odbc_result( $cur, 3 ); $total2nd= odbc_result( $cur, 4 ); $obt2nd= odbc_result( $cur, 5 ); $total3rd= odbc_result( $cur, 11 ); $obt3rd= odbc_result( $cur, 10 ); $totalAll=$total1st+$total2nd+$total3rd; $obtAll=$obt1st+$obt2nd+$obt3rd; $t1=$t1+$total1st; $t2=$t2+$obt1st; $t3=$t3+$total2nd; $t4=$t4+$obt2nd; $t5=$t5+$total3rd; $t6=$t6+$obt3rd; //$total1=$ThMarks+$PrMarks; //$obttotal1=$ThMarks1+$PrMarks1; $percentage=$obtAll*100/$totalAll; $percentage=number_format((float)$percentage, 2, '.', ''); echo "
$cnt$SubName$total1st$obt1st$total2nd$obt2nd$total3rd$obt3rd$totalAll$obtAll$percentage"; $cnt+=1; } $total1=$t1+$t3+$t5; $obttotal1=$t2+$t4+$t6; if ($total1==0 ) $percentage=0; else $percentage=$obttotal1*100/$total1; $percentage=number_format((float)$percentage, 2, '.', ''); if ($total1==0 ) echo "

Sorry! Exam Data not Available

"; else echo "
Summary$t1$t2$t3$t4$t5$t6$total1$obttotal1$percentage"; echo "
"; } odbc_close($conn); ?>