Viewing file:  v_rptRis001PDF.php (4.33 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
define('FPDF_FONTPATH',$this->config->item('path_application').'/font/');
class PDF extends FPDF {
var $cfgClgLogo;
var $cfgClgName;
var $cfgSiteName;
//Page header
function Header() {
//Logo
//$this->Image($this->cfgClgLogo,10,6,18,15);
//AngsanaNew bold 15
$this->SetFont('AngsanaNew','B',15);
//Move to the right
$this->SetY(10);
$this->SetX(30);
//Title
//$this->Cell(0,0,$this->cfgClgName,0,0,'L');
$this->SetX(-10);
$this->SetFontSize(12);
$this->Cell(0,0,'RIS001',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,22,290,22);
}
//Page footer
function Footer() {
//Draw line
$this->SetLineWidth(0.4);
$this->Line(10,196,290,196);
$this->SetY(-10);
$this->SetFont('AngsanaNew','',14);
//Page number
$this->Cell(0,0,iconv('UTF-8','TIS-620','หน้า ').$this->PageNo().'/{nb}',0,0,'R');
$this->SetY(-10);
$this->Cell(0,0,iconv('UTF-8','TIS-620','วันที่พิมพ์ : ').date("d/m/y H:i"),0,0,'L');
}
} //End class
//Create new pdf file
$pdf=new PDF('L');
$pdf->cfgClgLogo = "images/".$this->config->item("rg_folder").$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 = 47;
//set initial x axis position of table
$x_axis_initial = 20;
//Set Row Height
$row_height = 6;
//initialize counter
$i = 0;
$r = 1;
//Set maximum rows per page
$max = 20;
if($qu_cur->num_rows()) {
$row = $qu_cur->row();
$curName = $row->curName;
}else $curName;
$rowCur = (isset($qu_cur) && $qu_cur!=NULL) ? $qu_cur->row() : NULL;
if($rs_am->num_rows()) {
$row = $rs_am->row();
$alumniId = $row->alumniId;
}else $alumniId = "";
if($rs_am->num_rows()) {
foreach($rs_am->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();
}
if($i == 0) {
$pdf->SetFont('AngsanaNew','B',18);
$pdf->SetX(105);
$pdf->SetY(27);
//$pdf->Cell(0,0,'รายชื่อศิษย์เก่า แยกตามหลักสูตร',0,0,'C');
$pdf->Cell(0,0,iconv('UTF-8','TIS-620','รายชื่อศิษย์เก่า แยกตามหลักสูตร'),0,0,'C');
$pdf->Ln(7);
$pdf->SetFontSize(16);
$pdf->Cell(0,0,iconv('UTF-8','TIS-620','หลักสูตร').iconv('UTF-8','TIS-620',$curName),0,0,'C');
$pdf->Ln(7);
$pdf->Cell(0,0,iconv('UTF-8','TIS-620','ปีที่จบการศึกษา ' ).iconv('UTF-8','TIS-620',$graduateYear),0,0,'C');
//print column titles for the actual page
$pdf->SetFillColor(232,232,232);
$pdf->SetFontSize(14);
$pdf->SetY($y_axis_initial);
$pdf->SetX($x_axis_initial);
$pdf->Cell(20,6,iconv('UTF-8','TIS-620','ที่'),1,0,'C',1);
$pdf->Cell(30,6,iconv('UTF-8','TIS-620','รหัสนักศึกษา'),1,0,'C',1);
$pdf->Cell(120,6,iconv('UTF-8','TIS-620','ชื่อ-นามสกุล'),1,0,'C',1);
$pdf->Cell(40,6,iconv('UTF-8','TIS-620','ปีที่จบการศึกษา'),1,0,'C',1);
$pdf->Cell(40,6,iconv('UTF-8','TIS-620','หมายเหตุ'),1,0,'C',1);
$y_axis = $y_axis_initial + $row_height;
}
$pdf->SetFont('AngsanaNew','',14);
$pdf->SetY($y_axis);
$pdf->SetX($x_axis_initial);
$pdf->Cell(20,6,$r,1,0,'C');
$pdf->Cell(30,6,iconv('UTF-8','TIS-620',$row->studentCode),1,0,'C');
$pdf->Cell(120,6,iconv('UTF-8','TIS-620',$row->prefixName.$row->studentName.' '.$row->studentSurname),1,0,'L');
$pdf->Cell(40,6,iconv('UTF-8','TIS-620',$row->graduateYear),1,0,'C');
$pdf->Cell(40,6,'',1,0,'C');
//Go to next row
$y_axis = $y_axis + $row_height;
$i = $i + 1;
$r = $r + 1;
} //End foreach($rs_std->result() as $row)
$pdf->Output();
} //End if($rs_std->num_rows())
else{
$pdf->SetFont('AngsanaNew','B',18);
$pdf->SetY(27);
$pdf->Cell(0,0,iconv('UTF-8','TIS-620','ไม่มีข้อมูล...'),0,0,'C');
$pdf->Output();
}
$pdf->Output();
?>
|