ACADEMIC MANAGEMENT SYSTEM

proxy · 2016-11-12T13:36:52+00:00

Hello wadau na maprogrammer wote mlioko humu naomba msadawenu katika hili,Kwa sasa nipo kwenye final Stage ya kuimalizia System itakayoitwa Academic Management System ,hii system nimebase zaidi katika level za chuo kwa sababu wanamfumo wa GPA pamoja na Acreditation na Best performance kwa mwanafunzi atakayefanya vizuri,System inauwezo wa kutrack progress ya mwanafunzi na kujua progress yake,Kama inavyoonesha hapo chini. Kwa baadhi ya codes hizi:- PageNo()==$page) { $tday=date("Y-m-j"); //Go to 2 cm from bottom $this->SetY(-20); //$this->Image('corporate.png',80,null,0,0); $this->SetTextColor(black); $this->SetFont('Arial','',9); $this->Cell(15); $this->SetTextColor(black); $this->SetFont('Arial','I',6); $this->Cell(10,10,$tday,0,0,'R'); } } } $pdf=new PDF('P','mm','A4'); $pdf->AddPage(); $pdf->rect(15,15, 184,270); $pdf->ln(60); $regNo = trim($_GET['regNo']); $year1=$_GET['year1']; $year2=$_GET['year2']; $year3=$_GET['year3']; $year4=$_GET['year4']; $sql="SELECT p.*,r.programDetails,r.duration FROM tbl_ems_personal_details p INNER JOIN tbl_ems_program_detail r ON p.programCode = r.programCode where regNo='$regNo'"; $sql1=mysql_query($sql); $result1=mysql_fetch_assoc($sql1); $regNo=$result1['regNo']; $query_row=mysql_query("SELECT `dimensional` from provinal_lines where line_no='row_size'"); list($row_size)=mysql_fetch_array($query_row); $pdf->Cell(11); $fullName=ucwords(strtolower($result1['firstName']))." ".strtoupper($result1['otherName'])." ".ucwords(strtolower($result1['surName'])); $pdf->SetFont('Arial','',8); $pdf->Cell(100,$row_size,'Name: '. $fullName,1,0,'L'); $pdf->Cell(70,$row_size, 'RegNo:'.$result1[regNo],1,0,'L'); $pdf->ln($row_size); $pdf->Cell(11); $pdf->SetFont('Arial','',8); $pdf->Cell(170,$row_size,'Programme: '.$result1[programDetails],1,0,'L'); $pdf->ln(6); $pdf->Cell(11); $regNo = trim($_GET['regNo']); $qrl_sup="SELECT courseCode,remarks from tbl_ems_examination_results where regNo='$regNo' and remarks<>'P' ORDER BY Semister,examId ASC"; $result_sup=mysql_query($qrl_sup); //echo $qrl_sup; $max_row=mysql_num_rows($result_sup); if($max_row<>0) { $pdf->Cell(170,6,'',1,0 ,'l'); $pdf->ln(1); $pdf->Cell(11); $pdf->Cell(20,$row_size,'Remarks:',2,0 ,'l'); $i=1; while(list($courseCode,$remarks)=mysql_fetch_array($result_sup)) { if($i==$max_row) { $pdf->Cell(30,$row_size, $courseCode.'('.$remarks.')',2,0,'L'); }else { $pdf->Cell(20,$row_size, $courseCode.'('.$remarks.'),',2,0,'L'); } $i++; } //$pdf->ln(11); } //check programme duration $pduration=$result1['duration']; if((isset($year3)) or (isset($year4))) { $check=mysql_query("SELECT Semister,remarks from tbl_ems_examination_results where regNo = '$regNo' and Semister='2' and yearOfStudy='$pduration'"); list($Semister,$remarks)=mysql_fetch_array($check); } //echo $Semister; //exit(); if(($pduration==4) and (isset($year4))) { $setP=2; }elseif(($pduration==3) and (isset($year3))) { $setPy=2; }else{} if(($setP==2) or ($setPy==2)) { if(($Semister==2) and ($remarks=='P')) { $gpa="SELECT truncate(sum(point)/((count(courseCode))),2) as gpa FROM tbl_ems_examination_results where regNo = '$regNo' and courseCode<>'LG 211'and courseCode<>'LG 221' and courseCode<>'LG 311' and courseCode<>'LG 321' and courseCode<>'LG 311/321' and remarks<>'W'"; $gpa1=mysql_query($gpa); $gpa2=mysql_fetch_assoc($gpa1); $gpa3 = $gpa2[gpa]; switch ($gpa3) { case $gpa3 >=4.50: $class = 'FIRST'; break; case $gpa3 >=3.50: $class= 'UPPER SECOND'; break; case $gpa3 >=2.60: $class = 'LOWER SECOND'; break; case $gpa3 >=2.00: $class = 'PASS'; break; default: $class = 'FAILED'; } ......... Kilichonileta hapa ni kwamba nahitaji kubadilisha kwenye hiyo column ya points nahitaji kuzidisplay as a float au double ,lakini nimejaribu kuiport kupitia VB Excel(Macro) ,data zinakubali vizuri lakini points haziingii kama float na hata kama zikikubali ila total na GPA haziwi aligned vizuri kwenye cell ya hiyo attribute Kama kuna yeyote anauelewa namna ya kuzipoint data kutoka kwenye Integer kwenye Float au Double tuwasiliane please.

Thread starter proxy
Start date Nov 12, 2016

proxy

JamiiForums uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Accept Learn more…

Back

Top Bottom

Forums

New posts

ACADEMIC MANAGEMENT SYSTEM

proxy

JF-Expert Member

Our Community

Regional Communities