Viewing file:  v_rptRis202.php (7.52 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
define('FPDF_FONTPATH',$this->config->item('path_application').'/font/');
//$this->load->library('fpdf_thai');
class PDF extends FPDF {
var $cfgClgLogo;
var $cfgClgName;
var $cfgSiteName;
//Page header
function Header() {
//Logo
$this->Image($this->cfgClgLogo,10,3,18,15);
//AngsanaNew bold 15
$this->SetFont('AngsanaNew','B',15);
//Move to the right
$this->SetY(7);
$this->SetX(30);
//Title
$this->Cell(0,0,$this->cfgClgName,0,0,'L');
$this->SetX(-10);
$this->SetFontSize(12);
$this->Cell(0,0,'RIS202',0,0,'R');
$this->Ln(7);
$this->SetX(30);
$this->SetFontSize(15);
$this->Cell(0,0,$this->cfgSiteName,0,0,'L');
//Draw line
$this->SetLineWidth(0.4);
$this->Line(10,19,200,19);
}
//Page footer
function Footer() {
//Position at 3.0 cm from bottom
$this->SetLineWidth(0.4);
$this->Line(10,286,200,286);
$this->SetY(-7);
$this->SetFont('AngsanaNew','',14);
//Page number
$this->Cell(0,0,'หน้า '.$this->PageNo().'/{nb}',0,0,'R');
$this->SetY(-7);
$this->Cell(0,0,'วันที่พิมพ์ : '.date("d/m/y H:i"),0,0,'L');
}
} //End class
//Create new pdf file
$pdf=new PDF();
$pdf->cfgClgLogo = $this->config->item('rg_upload_picture').$cfgClgLogo;
$pdf->cfgClgName = iconv('UTF-8','TIS-620',$cfgClgName);
$pdf->cfgSiteName = iconv('UTF-8','TIS-620',$cfgSiteName);
//Set thai font
$pdf->SetThaiFont();
$pdf->AliasNbPages();
//Open file
$pdf->Open();
//Disable automatic page break
$pdf->SetAutoPageBreak(false);
//Add first page
$pdf->AddPage();
//set initial y axis position per page
$y_axis_initial = 40;
//Set Row Height
$row_height = 6;
$pdf->SetFontSize(18);
$pdf->Cell(105);
$pdf->SetY(27);
$pdf->Cell(0,0,'จำนวนผู้สำเร็จการศึกษา จำแนกรายหลักสูตร',0,0,'C');
$pdf->Ln(7);
$pdf->SetFontSize(16);
$pdf->Cell(0,0,'ประจำปีการศึกษา '.$graduateY,0,0,'C');
//print column titles for the actual page
$pdf->SetFillColor(232,232,232);
$pdf->SetFontSize(14);
$pdf->SetY($y_axis_initial);
$pdf->Cell(130,6,'หลักสูตร',1,0,'C',1);
$pdf->Cell(20,6,'ชาย',1,0,'C',1);
$pdf->Cell(20,6,'หญิง',1,0,'C',1);
$pdf->Cell(20,6,'รวม',1,0,'C',1);
$y_axis = $y_axis_initial + $row_height;
//initialize counter
$i = 0;
$r = 1;
//Set maximum rows per page
$max = 25;
if ($rs_cur->num_rows()) {
foreach ($rs_cur->result() as $row) {
//If the current row is the last one, create new page and print column title
if ($i == $max) {
//Set $i variable to 0 (first row)
$i = 0;
$pdf->AddPage();
$pdf->SetFont('AngsanaNew','B',18);
$pdf->Cell(105);
$pdf->SetY(27);
$pdf->Cell(0,0,'จำนวนผู้สำเร็จการศึกษา จำแนกรายหลักสูตร',0,0,'C');
$pdf->Ln(7);
$pdf->SetFontSize(16);
$pdf->Cell(0,0,'ประจำปีการศึกษา '.$graduateY,0,0,'C');
//print column titles for the current page
$pdf->SetFillColor(232,232,232);
$pdf->SetFontSize(14);
$pdf->SetY($y_axis_initial);
$pdf->Cell(130,6,'หลักสูตร',1,0,'C',1);
$pdf->Cell(20,6,'ชาย',1,0,'C',1);
$pdf->Cell(20,6,'หญิง',1,0,'C',1);
$pdf->Cell(20,6,'รวม',1,0,'C',1);
//Go to next row
$y_axis = $y_axis_initial + $row_height;
}
$pdf->SetFont('AngsanaNew','B',14);
$pdf->SetY($y_axis);
$pdf->Cell(130,6,iconv('UTF-8','CP874',$row->levelName),1,0,'L');
$pdf->Cell(20,6,'',1,0,'L');
$pdf->Cell(20,6,'',1,0,'L');
$pdf->Cell(20,6,'',1,0,'L');
//Go to next row
$y_axis = $y_axis + $row_height;
$i = $i + 1;
//If the current row is the last one, create new page and print column title
if ($i == $max)
{
//Set $i variable to 0 (first row)
$i = 0;
$pdf->AddPage();
$pdf->SetFont('AngsanaNew','B',18);
$pdf->Cell(105);
$pdf->SetY(27);
$pdf->Cell(0,0,'จำนวนผู้สำเร็จการศึกษา จำแนกรายหลักสูตร',0,0,'C');
$pdf->Ln(7);
$pdf->SetFontSize(16);
$pdf->Cell(0,0,'ประจำปีการศึกษา '.$graduateY,0,0,'C');
//print column titles for the current page
$pdf->SetFillColor(232,232,232);
$pdf->SetFontSize(14);
$pdf->SetY($y_axis_initial);
$pdf->Cell(130,6,'หลักสูตร',1,0,'C',1);
$pdf->Cell(20,6,'ชาย',1,0,'C',1);
$pdf->Cell(20,6,'หญิง',1,0,'C',1);
$pdf->Cell(20,6,'รวม',1,0,'C',1);
//Go to next row
$y_axis = $y_axis_initial + $row_height;
}
$sumM = 0;
$sumF = 0;
$sumTotal = 0;
// $con_cur = array('curElvId' => $row->curElvId ,
// 'curStatus' => 'Y');
// $rs_cur2 = $cur->qryCurJoinOther($con_cur);
$con_rs_std = array('curElvId' => $row->curElvId);
$rs_std = $std->qryStdGroupStdCurId($con_rs_std);
if ($rs_std->num_rows()) {
foreach ($rs_std->result() as $row2) {
//If the current row is the last one, create new page and print column title
if ($i == $max) {
//Set $i variable to 0 (first row)
$i = 0;
$pdf->AddPage();
$pdf->SetFont('AngsanaNew','B',18);
$pdf->Cell(105);
$pdf->SetY(27);
$pdf->Cell(0,0,'จำนวนผู้สำเร็จการศึกษา จำแนกรายหลักสูตร',0,0,'C');
$pdf->Ln(7);
$pdf->SetFontSize(16);
$pdf->Cell(0,0,'ประจำปีการศึกษา '.$graduateY,0,0,'C');
//print column titles for the current page
$pdf->SetFillColor(232,232,232);
$pdf->SetFontSize(14);
$pdf->SetY($y_axis_initial);
$pdf->Cell(130,6,'หลักสูตร',1,0,'C',1);
$pdf->Cell(20,6,'ชาย',1,0,'C',1);
$pdf->Cell(20,6,'หญิง',1,0,'C',1);
$pdf->Cell(20,6,'รวม',1,0,'C',1);
//Go to next row
$y_axis = $y_axis_initial + $row_height;
}
$qu_std = $std->qryStdByCurIdGdDateGdY($row2->stdCurId, $firstDate, $lastDate, $graduateY);
$sumTotalR = $qu_std->num_rows();
$cM = $std->getCountStIdByPgIdAndFinishDateAndGdYAndStSex($row2->stdCurId, $firstDate, $lastDate, $graduateY, 'M');
$cF = $std->getCountStIdByPgIdAndFinishDateAndGdYAndStSex($row2->stdCurId, $firstDate, $lastDate, $graduateY, 'F');
$pdf->SetFont('AngsanaNew','',14);
$pdf->SetY($y_axis);
$pdf->Cell(130,6,$r.'. '.iconv('UTF-8','CP874',$row2->curName),1,0,'L');
$pdf->Cell(20,6,$cM,1,0,'R');
$pdf->Cell(20,6,$cF,1,0,'R');
$pdf->Cell(20,6,$sumTotalR,1,0,'R');
$sumM += $cM;
$sumF += $cF;
$sumTotal += $sumTotalR;
//Go to next row
$y_axis = $y_axis + $row_height;
$i = $i + 1;
$r = $r + 1;
}
}
//If the current row is the last one, create new page and print column title
if ($i == $max)
{
//Set $i variable to 0 (first row)
$i = 0;
$pdf->AddPage();
$pdf->SetFont('AngsanaNew','B',18);
$pdf->Cell(105);
$pdf->SetY(27);
$pdf->Cell(0,0,'จำนวนผู้สำเร็จการศึกษา จำแนกรายหลักสูตร',0,0,'C');
$pdf->Ln(7);
$pdf->SetFontSize(16);
$pdf->Cell(0,0,'ประจำปีการศึกษา '.$graduateY,0,0,'C');
//print column titles for the current page
$pdf->SetFillColor(232,232,232);
$pdf->SetFontSize(14);
$pdf->SetY($y_axis_initial);
$pdf->Cell(130,6,'หลักสูตร',1,0,'C',1);
$pdf->Cell(20,6,'ชาย',1,0,'C',1);
$pdf->Cell(20,6,'หญิง',1,0,'C',1);
$pdf->Cell(20,6,'รวม',1,0,'C',1);
//Go to next row
$y_axis = $y_axis_initial + $row_height;
}
$pdf->SetFont('AngsanaNew','B',14);
$pdf->SetY($y_axis);
$pdf->Cell(130,6,'รวมหลักสูตร'.iconv('UTF-8','CP874',$row->levelName),1,0,'C');
$pdf->Cell(20,6,$sumM,1,0,'R');
$pdf->Cell(20,6,$sumF,1,0,'R');
$pdf->Cell(20,6,$sumTotal,1,0,'R');
//Go to next row
$y_axis = $y_axis + $row_height;
$i = $i + 1;
}//End foreach
//Create file
$pdf->Output();
} else {
echo "<font face='Microsoft Sans Serif' color='red'><b>ไม่มีข้อมูล...</b></font>";
}
?>
|