Wduw{Aó*19hw]ԟ9̷tAڒu봁r-'Zgq8c)ޏĬYDW*)c <%}rB٨n{`2koQPN`^[5x2#tĸ9 _yen_& ld{>f'P_TsaZ8^u"Yv;rS:* Tꉼ@.ъt1 H}f+*%:oSe3FUaeig!V[ Z<4LYwC$]oQQT"iHe_Fig ddeKƫw @q .Hm's(}6ƔT4_&fUD HLwӍwC$]oQQT"iHV9r iAעfm}V}'ǔ(t˶Q7o 27~@xS!*mf ޶m2 u\|?iH7JQa#&W*@7ɕBeT~^5m`@;gl, GjTP>b&3g̉aOgݹCx#FXեˆǤ.Ci+jßM8kʨ:[Fs.1 M/j62@\`!&_ KIzyo"-D2+,{ʸy^F#[44˜:̜8]OA~,sv!N"<-ېjϢ[VH/b1L(-T|Ð}\W߰唋"D\A29)Hْ%uSS U rEL@˃=5 w'XAtnĉ%l*7i>Pҹc-bK,nkﻞX(z-Y2c_wQ>',dU (v\J7]M_7ƹSA nXn  Cgs5Js Oa]14K`HudCj-N؆: x VF‰-bL \%WpZA(%sc,P(0ri.4<s'l;r{{b5N?=ƕz'^#Z}И}ƴ#m]XpWL}Ego0b,\%WpZA( D|t/%ᴱsgXV1ڨcGT⿥=h:fͮBC7e)VUQLtqi@XuM>rCT-+8KC=E䘠),"mq q!d3$ hzY!n0Ps7k0R5([:O[Ue:4`Nq'(Z ׆ɐ=?E![E@4#{P[uq% +V~E>/“Eꔍ,m惰(& [w2YRL 77;63Xh4(vFcäM}>o>gxj.NPXvt`uu׀p3D}|Te&vUxg-4c)puͭtAf)<:; Kg^Z͚R$׈,cj:Z6xփ7 Zj׃x@&}awto\y@5e~, 3ZS#ī}߀9k)rP O(*(޳LP @lH2{QPKT0 ߽/4j*ۻ2] 3E\=/~pUGUiUOʭ\ 5N/C~Ap??f2ZUx_eF[]cö$ .X7s@,0ijRFtgƉ3iڭ ^ d%,U}]6ZrNɝ6Q!u#cc=&FKY=n㽹l',{-K'Ү'd9&挌J8)2v ?D+䃑Dmq_*}2Gzr5#u3}Z?xp늂?mfUgE e"O]>-Xq"l #kdV *p[hq[>8{1kz]5ܳVVD7g LY2F`sWu*2@&dӿ#w|)9%K66\ߐ*Ì$㔴߼>F!{j akobڀZaaQeH"rNd B?FR/Mo>)]A#-[t3z ӏ1ܵ=9B@WQ]R?Mͷ~Ydv1תy~n{`2kopʗj~ϛe' 8D1+a{cFXvp!~6 V^(P<0{H2 bQFN69?mNy6h߰-U@{HHC@{1? rY:vgxs[. 3]q׉O A`&gѦ SvUPiRIL;rb8TlwT갮0-i+hϔ5 @pOlLp azIe *E, mߥ`Zv㛏 sH Tv`5 ՉF=lē_=D.Z)W^6PC 5k|ɷ@QfZ`q7Qj69}[>eA)m$o}Gfƴt_">Qq BXW*lc9tm>-B{i wj]=I{H*"ٺh2"Zhr]6܁uεUriS"j] )ꪇȟ8Ժhu dhw$'ns^J l%2" ^W W((ɂ}hK4KthBS/A2rtD*ΦF6)fr1AHOh8vt…%e_H~մQipcgPaxV1 y<#.AnU{\B\F͛PkDŽԉxAT5R+󝚆!g)@|byp\}{HY-_}hCϪ6;?A$Ώt 6dl3Q 1;1);aB8Uw,` PsB+^zr M|= 9Xc&k|Xy*9˵% ٞ\}{HY-.open('Reports/dmc.php?programID=$programID&session_=$session_&semesterID=$semesterID&Section_=$Section_','_Blank')"; //exit(); } if(isset($_POST['btnDeleteMarks'])){ $session_ = $_POST['session_']; $programID = $_POST['programID']; $semesterID = $_POST['semesterID']; $Section_ ="";// $_POST['Section_']; $subjectID = $_POST['subjectID']; $cnt = $_POST['cnt']; $tmarks = $_POST['tmarks']; $TotalPrMarks = $_POST['TotalPrMarks']; $teacherID = $_POST['teacherID']; $passpercent = $_POST['passpercent']; $subjectsFail= addHeadValue($conn,"subjectsFail",$_POST['subjectsFail']); $percentFail= addHeadValue($conn,"percentFail",$_POST['percentFail']); $query="delete from obtainedmarks where programID='$programID' and section_='$Section_' and semesterID='$semesterID' and year_='$session_' and subID='$subjectID' "; $cur= odbc_exec( $conn, $query ); } if(isset($_POST['btnmarksentryInstitute'])){ $session_ = $_POST['session_']; $programID = $_POST['programID']; $semesterID = $_POST['semesterID']; $Section_ ="";// $_POST['Section_']; $subjectID = $_POST['subjectID']; $cnt = $_POST['cnt']; $tmarks = $_POST['tmarks']; $TotalPrMarks = $_POST['TotalPrMarks']; $teacherID = $_POST['teacherID']; $passpercent = $_POST['passpercent']; $subjectsFail= addHeadValue($conn,"subjectsFail",$_POST['subjectsFail']); $percentFail= addHeadValue($conn,"percentFail",$_POST['percentFail']); $sfCheck=isset($_POST['sfCheck'])?1:0; $pfCheck=isset($_POST['pfCheck'])?1:0; $sfCheck= addHeadValue($conn,"subjectsFailCheck",$sfCheck); $pfCheck= addHeadValue($conn,"percentFailCheck",$pfCheck); //if(canSave($conn,"marksentryInstitute")=="0"){ for ($i=1; $i<=$cnt; $i++) { $ID = "ID$i"; $ID = $_POST[$ID]; $th = "th$i"; $th = $_POST[$th]; $pr = "pr$i"; $pr = $_POST[$pr]; //echo substr($_SESSION['ID'],0,5); $query="delete from obtainedmarks where ID='$ID' and semesterID='$semesterID' and year_='$session_' and subID='$subjectID' "; $cur= odbc_exec( $conn, $query ); $query="insert into obtainedmarks(labid,userID,Section_,ID,Year_,semesterID,programID,subID,totalThMarks,Thmarks,prmarks,TotalPrMarks,teacherID,passPercent) values('".$_SESSION['labid']."','$userID','$Section_','$ID','$session_',$semesterID,$programID,$subjectID,$tmarks,$th,$pr,$TotalPrMarks,$teacherID,$passpercent)"; $cur= odbc_exec( $conn, $query ); } //} } if(isset($_POST['submit'])){ //$session_ = $_POST['session_']; $session_ = $_POST['session_']; $programID = $_POST['programID']; $semesterID = $_POST['semesterID']; $Section_ ="";// $_POST['Section_']; $subjectID = $_POST['subjectID']; //$Section_ ="";// $_POST['Section_']; //$tmarks = $_POST['tmarks']; } //Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'programID'., SQL state S0022 in SQLExecDirect in D:\xampp\htdocs\attHospital2\marksentryInstitute.php on line 92 if(isset($_POST['btnCalculateResult'])){ set_time_limit ( 100 ); $subjectsFail= addHeadValue($conn,"subjectsFail",$_POST['subjectsFail']); $percentFail= addHeadValue($conn,"percentFail",$_POST['percentFail']); $sfCheck=isset($_POST['sfCheck'])?1:0; $pfCheck=isset($_POST['pfCheck'])?1:0; $sfCheck= addHeadValue($conn,"subjectsFailCheck",$sfCheck); $pfCheck= addHeadValue($conn,"percentFailCheck",$pfCheck); $session =$session_ = $_POST['session_']; $programID = $_POST['programID']; $semesterID = $_POST['semesterID']; $Section_ ="";// $_POST['Section_']; $subjectID = $_POST['subjectID']; //$session = $_POST['session']; //$semesterID = $_POST['semesterID']; $failType=1;// $_POST['failType']; $subjectsFail= $_POST['subjectsFail']; $percentFail= $_POST['percentFail']; //change to thmarks1 %age //$query = " update obtainedmarks set thmarks1=thmarks where semesterID='$semesterID' and Year_='$session' )"; $cur= odbc_exec( $conn, $query ); //$query = " update obtainedmarks set thmarks1=0 where thmarks<0 semesterID='$semesterID' and Year_='$session' )"; $cur= odbc_exec( $conn, $query ); $query ="update obtainedmarks set totalThMarks=1 where totalThMarks+TotalPrMarks=0 and semesterID='$semesterID' and Year_='$session' "; $cur= odbc_exec( $conn, $query ); //Calculate %age $query = " update rollno set obtMarks=(select isnull(Sum(ThMarks1),0)+isnull(sum(PrMarks1),0) from ObtainedMarks where rollno.id=ObtainedMarks.ID and ObtainedMarks.semesterID='$semesterID' and ObtainedMarks.Year_='$session' )"; $query.= " where semesterID='$semesterID' and Year_='$session' and id in (select ID from ObtainedMarks where semesterID='$semesterID' and Year_='$session' ) "; $cur= odbc_exec( $conn, $query ); $query = " update rollno set TotalMarks=(select isnull(Sum(totalThMarks),0)+isnull(sum(TotalPrMarks),0) from ObtainedMarks where rollno.id=ObtainedMarks.ID and ObtainedMarks.semesterID='$semesterID' and ObtainedMarks.Year_='$session' )"; $query.= " where semesterID='$semesterID' and Year_='$session' and id in (select ID from ObtainedMarks where semesterID='$semesterID' and Year_='$session' ) "; $cur= odbc_exec( $conn, $query ); $sessionStart="4"; $year_=substr($session,0,4); //Calculate Attendance $dt1 = date_01(date('Y-m-d',strtotime("01-$sessionStart-$year_"))); $dt2="select isnull(min(date_),getdate()) from datesheet where session_='$session' and semesterID='$semesterID' "; $query="select count(*) from attendance where status=0 and (Date_ between '$dt1' and ($dt2)) and attendance.ID=rollno.ID "; $query="update RollNo set Attendance=($query) "; $query.=" where semesterID='$semesterID' and Year_='$session' "; //odbc_exec( $conn, $query); $query=" select CONVERT(varchar, count(*),4) from attendance where (Date_ between '$dt1' and ($dt2)) and attendance.ID=rollno.ID "; $query="update RollNo set Attendance=Attendance+'/'+($query) "; $query.=" where semesterID='$semesterID' and Year_='$session' "; //odbc_exec( $conn, $query); //Calculate Remarks old $query="update rollno set remarks='Pass' where semesterID='$semesterID' and Year_='$session' "; odbc_exec( $conn, $query); if($failType=="0"){ $query = "select rollno from obtainedmarks where semesterID='$semesterID' and Year_='$session' and remarks='Fail' group by rollno having count(remarks)>$subjectsFail"; $query = "update rollno set remarks='Fail' where semesterID='$semesterID' and Year_='$session' and id in ($query)"; }else{ // on Aggregate $query = "select ID from rollno where semesterID='$semesterID' and Year_='$session' and obtmarks*100/totalmarks<$percentFail"; $query = "update rollno set remarks='Fail' where semesterID='$semesterID' and Year_='$session' and id in ($query)"; } //odbc_exec( $conn, $query); //Calculate Remarks new $query = "update rollno set remarks='Fail' where semesterID='$semesterID' and Year_='$session' "; if($sfCheck==1 and $pfCheck==1){ $ids = "select ID from obtainedmarks where semesterID='$semesterID' and Year_='$session' and remarks='Fail' group by ID having count(remarks)>$subjectsFail"; $ids2 = "select ID from rollno where semesterID='$semesterID' and Year_='$session' and obtmarks*100/totalmarks<$percentFail"; $query.= " and (id in ($ids) or id in ($ids2) ) "; }elseif($sfCheck==1){ $ids = "select ID from obtainedmarks where semesterID='$semesterID' and Year_='$session' and remarks='Fail' group by ID having count(remarks)>$subjectsFail"; $query.= " and id in ($ids)"; }elseif($pfCheck==1){ $ids = "select ID from rollno where semesterID='$semesterID' and Year_='$session' and obtmarks*100/totalmarks<$percentFail"; $query.= " and id in ($ids)"; } odbc_exec( $conn, $query); //echo "



".$query; //$failType=getName($conn,"select Description from FeeHeads where headType='failType'"); //calculate positions odbc_exec( $conn, "update rollno set percentage=(obtMarks*100/TotalMarks) where semesterID='$semesterID' and year_='$session' "); $query = "Select percentage,ID from RollNo where semesterID='$semesterID' and Year_='$session' order by percentage desc"; $positionNo=0;$prepercentFail=0; //$rsCount ="22";// getName($conn,"Select Count(ID) from RollNo where semesterID='$semesterID' 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 semesterID='$semesterID' and year_='$session'" ); $prepercentFail=odbc_result($cur,'percentage'); } $cur1= odbc_exec( $conn, "Select programID,count(*) from RollNo where semesterID='$semesterID' and Year_='$session' group by programID" ); while( odbc_fetch_row( $cur1 ) ) { $query = "Select percentage,ID from RollNo where programID='".odbc_result( $cur1, 'programID' )."' and semesterID='$semesterID' 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 semesterID='$semesterID' and year_='$session'" ); $prepercentFail=odbc_result( $cur,'percentage'); } } //''''''''''''''''''''''' Section wise POosition $cur1= odbc_exec( $conn, "Select section_,programID,count(*) from RollNo where semesterID='$semesterID' and Year_='$session' group by section_,programID" ); while( odbc_fetch_row( $cur1 ) ) { $query = "Select percentage,ID from RollNo where programID='".odbc_result( $cur1, 'programID' )."' and section_='".odbc_result( $cur1, 'section_' )."' and semesterID='$semesterID' 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 semesterID='$semesterID' 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 semesterID='$semesterID' and year_='$session'" ; $query = "update rollno set sectionPosition=(select positionName from position where position.positionID=rollno.sectionPosition) where semesterID='$semesterID' 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_"); } ?> HOME
session_
Semester
Program
Subject
.
.
.
"; //echo ""; /* echo "
Program
"; echo "		Semester
"; echo "		Marks
"; echo "		"; echo ""; echo "
"; */ ?>
0){ $tmarks=$arr[1]; $TotalPrMarks=$arr[2]; }else{ $tmarks=1; $TotalPrMarks=0; } $query = "select ID,stdName,fname from student where session_='$session_' and semesterID='$semesterID' and status=0 and ProgramID='$programID' and recordType='Std' and labid='".$_SESSION['labid']."' order by ID"; $cur= odbc_exec( $conn, $query ); $cnt=1; $thmarks=$prmarks=$teacherID=0; echo "
S.#IDNameFather NameMarks
Oral/Prac
"; while( odbc_fetch_row( $cur ) ) { $ID= odbc_result( $cur,"ID"); $ID= odbc_result( $cur,"ID"); $name= odbc_result( $cur,"stdName"); $fname= odbc_result( $cur,"fname"); //if ($tmarks==0) $thmarks=-2; else $thmarks=0; //if ($TotalPrMarks==0) $prmarks=-2; else $prmarks=0; $arr =getName($conn,"select thmarks,prmarks,teacherID,passpercent from obtainedmarks where subID='$subjectID' and semesterID='$semesterID' and year_='$session_' and ID='$ID' "); if(count($arr)>0){ if($arr[1]>0) $thmarks=round($arr[1],2); else $thmarks=0; if($arr[2]>0) $prmarks=round($arr[2],2); else $prmarks=0; if($arr[3]>0) $teacherID=$arr[3]; if($arr[4]>0) $passpercent=$arr[4]; } echo "
$cnt$ID$name$fname"; echo ""; echo "" ; echo ""; $cnt+=1; } $cnt-=1; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
Teacher : "; echo "Passing %age : "; echo ""; echo "
"; ?>