Viewing file: v_rptRis004PDF.php (4.99 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,'RIS004',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,200,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('P'); $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 = 10;
//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_ha->num_rows()) { // foreach($rs_ha->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(5,6,iconv('UTF-8','TIS-620','ที่'),1,0,'C',1); $pdf->Cell(115,6,iconv('UTF-8','TIS-620','รายการ'),1,0,'C',1); $pdf->Cell(15,6,iconv('UTF-8','TIS-620','ชาย'),1,0,'C',1); $pdf->Cell(15,6,iconv('UTF-8','TIS-620','หญิง'),1,0,'C',1); $pdf->Cell(15,6,iconv('UTF-8','TIS-620','รวม'),1,0,'C',1); $pdf->Cell(25,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(5,7,$r,1,0,'C'); $pdf->Cell(115,7,iconv('UTF-8','TIS-620', 'จำนวนผู้สำเร็จการศึกษาที่ได้งานทำ'),1,0,'L'); $pdf->Cell(15,7,iconv('UTF-8','TIS-620', $work[0]),1,0,'C'); $pdf->Cell(15,7,iconv('UTF-8','TIS-620',$work[1]),1,0,'C'); $pdf->Cell(15,7,iconv('UTF-8','TIS-620',$work[2]),1,0,'C'); $pdf->Cell(25,7,iconv('UTF-8','TIS-620',$work[3]),1,0,'C');
$pdf->SetFont('AngsanaNew','',14); $pdf->SetY($y_axis); $pdf->SetX($x_axis_initial); $pdf->Cell(5,14,$r,1,0,'C'); $pdf->Cell(115,14,iconv('UTF-8','TIS-620', 'จำนวนผู้สำเร็จการศึกษาที่ศึกษาต่อ'),1,0,'L'); $pdf->Cell(15,14,iconv('UTF-8','TIS-620', $work[0]),1,0,'C'); $pdf->Cell(15,14,iconv('UTF-8','TIS-620',$work[1]),1,0,'C'); $pdf->Cell(15,14,iconv('UTF-8','TIS-620',$work[2]),1,0,'C'); $pdf->Cell(25,14,iconv('UTF-8','TIS-620',$work[3]),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(); ?>
|