Viewing file: v_rptRis130.php (4.52 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,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,'RIS130',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 = 50;
//Set Row Height $row_height = 6; if(!isset($errMs)) {
$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,'ประจำปีการศึกษา '.iconv('UTF-8','TIS-620',$acY).' ภาคการศึกษา '.iconv('UTF-8','TIS-620',$tmId),0,0,'C'); $pdf->Ln(7); $pdf->Cell(0,0,'หลักสูตร '.iconv('UTF-8','TIS-620',$qu_cur->curName),0,0,'C');
if($rs_std->num_rows()) { //print column titles for the actual page $pdf->SetFillColor(232,232,232); $pdf->SetFontSize(14); $pdf->SetY($y_axis_initial); $pdf->SetX(25); $pdf->Cell(10,6,'ที่',1,0,'C',1); $pdf->Cell(25,6,'รหัสนักศึกษา',1,0,'C',1); $pdf->Cell(40,6,'ชื่อ',1,0,'C',1); $pdf->Cell(45,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;
foreach($rs_std->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,'ประจำปีการศึกษา '.iconv('UTF-8','TIS-620',$acY).' ภาคการศึกษา '.iconv('UTF-8','TIS-620',$tmId),0,0,'C'); $pdf->Ln(7); $pdf->Cell(0,0,'หลักสูตร '.iconv('UTF-8','TIS-620',$qu_cur->curName),0,0,'C');
//print column titles for the current page $pdf->SetFillColor(232,232,232); $pdf->SetFontSize(14); $pdf->SetY($y_axis_initial); $pdf->SetX(25); $pdf->Cell(10,6,'ที่',1,0,'C',1); $pdf->Cell(25,6,'รหัสนักศึกษา',1,0,'C',1); $pdf->Cell(40,6,'ชื่อ',1,0,'C',1); $pdf->Cell(45,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','',14); $pdf->SetY($y_axis); $pdf->SetX(25); $pdf->Cell(10,6,$r,1,0,'C'); $pdf->Cell(25,6,iconv('UTF-8','TIS-620',$row->stdCode),1,0,'C'); $pdf->Cell(40,6,iconv('UTF-8','TIS-620',$row->prefixName.$row->stdName),1,0,'L'); $pdf->Cell(45,6,iconv('UTF-8','TIS-620',$row->stdSurname),1,0,'L'); $pdf->Cell(20,6,number_format($row->sumSbeCurPoint),1,0,'R'); $pdf->Cell(20,6,'',1,0,'L');
//Go to next row $y_axis = $y_axis + $row_height; $i = $i + 1; $r = $r + 1; } //End while
$pdf->SetFont('AngsanaNew','B',14); $pdf->SetY($y_axis + $row_height); $pdf->SetX(25); $pdf->Cell(0,6,'หมายเหตุ : คะแนนความประพฤติเต็ม 100 คะแนน',0,0,'L'); //Create file $pdf->Output();
} else { $pdf->Ln(7); $pdf->Cell(0,0,'ไม่มีข้อมูล...',0,0,'C'); $pdf->Output(); } }else{ $pdf->SetFontSize(18); $pdf->Cell(105); $pdf->SetY(27); $pdf->Cell(0,0,'ระบุเงื่อนไขในการค้นหาไม่ครบถ้วน',0,0,'C'); } ?>
|