Viewing file: v_rptRis118.php (9.02 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 {
//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,'RIS118',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);
//Arial italic 8
$this->SetY(-7);
$this->SetFont('AngsanaNew','',14);
//Page number
$this->Cell(0,0,'Л№йТ '.$this->PageNo().'/{nb}',0,0,'R');
$this->SetY(-7);
//$this->Cell(10);
$this->Cell(0,0,'ЗС№·ХиѕФБѕм : '.date("d/m/y H:i"),0,0,'L');
}
}
//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 initial x position of table
$x_axis_initial = 10;
//Set Row Height
$row_height = 6;
if ($qu_std->num_rows()) {
$row = $qu_std->row();
$genNo = $row->genNo;
} else {
$genNo = "";
}
$pdf->SetFont('AngsanaNew','B',18);
$pdf->SetX(105);
$pdf->SetY(24);
$pdf->Cell(0,0,'ГТВ§Т№К¶Т№РЎТГаЕЧиН№ЄСй№»Х',0,0,'C');
$pdf->Ln(7);
$pdf->SetFontSize(16);
$pdf->Cell(0,0,'ЛЕСЎКЩµГ '.iconv('UTF-8','TIS-620',$cur->curName).' ГШи№·Хи '.$genNo,0,0,'C');
$pdf->Ln(7);
$pdf->Cell(0,0,'»ГРЁУ»ХЎТГИЦЎЙТ '.intval($acY-1),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(10,12,'·Хи',1,0,'C',1);
$pdf->Cell(20,12,'ГЛСК№СЎИЦЎЙТ',1,0,'C',1);
$pdf->Cell(60,12,'ЄЧиН-КЎШЕ№СЎИЦЎЙТ',1,0,'C',1);
$pdf->Cell(10,12,'ЄСй№»Х',1,0,'C',1);
$pdf->Cell(75,6,'¤Рб№№а©ЕХиВ',1,0,'C',1);
$pdf->Cell(15,12,'К¶Т№Р',1,0,'C',1);
$y_axis = $y_axis_initial + $row_height;
$pdf->SetY($y_axis);
$pdf->SetX($x_axis_initial+100);
$pdf->Cell(15,6,'ГТВАТ¤ 1',1,0,'C',1);
$pdf->Cell(15,6,'ГТВАТ¤ 2',1,0,'C',1);
$pdf->Cell(15,6,'ГТВАТ¤ 3',1,0,'C',1);
$pdf->Cell(15,6,'ГТВ»Х',1,0,'C',1);
$pdf->Cell(15,6,'КРКБ',1,0,'C',1);
$y_axis = $y_axis + $row_height;
//initialize counter
$i = 0;
$r = 1;
//Set maximum rows per page
$max = 35;
$tm = '';
if ($rs_std->num_rows()) {
foreach ($rs_std->result() as $row) {
$GPA1 = 0;
$GPA2 = 0;
$GPA3 = 0;
$passStatus = '-';
$con_ssm = array('ssmStdId' => $row->stdId, 'ssmAcY' => $acY-1, 'ssmTmId' => '1');
$qu_ssm = $ssm->qrySsm($con_ssm);
if($qu_ssm->num_rows()){
$GPA1 = $qu_ssm->row()->ssmGPA;
}
//echo $this->db->last_query();
$con_ssm = array('ssmStdId' => $row->stdId, 'ssmAcY' => $acY-1, 'ssmTmId' => '2');
$qu_ssm = $ssm->qrySsm($con_ssm);
if($qu_ssm->num_rows()){
$row_2 = $qu_ssm->row();
$GPA2 = $row_2->ssmGPA;
$passStatus = $row_2->ssmPassStatus;
$tm = 2;
}
$con_ssm = array('ssmStdId' => $row->stdId, 'ssmAcY' => $acY-1, 'ssmTmId' => '3');
$qu_ssm = $ssm->qrySsm($con_ssm);
if($qu_ssm->num_rows()){
$row_3 = $qu_ssm->row();
$GPA3 = $row_3->ssmGPA;
$passStatus = $row_3->ssmPassStatus;
$tm = 3;
}
if ($i == $max) {
$i = 0;
$pdf->AddPage();
$pdf->SetFont('AngsanaNew','B',18);
$pdf->SetX(105);
$pdf->SetY(24);
$pdf->Cell(0,0,'ГТВ§Т№К¶Т№РЎТГаЕЧиН№ЄСй№»Х',0,0,'C');
$pdf->Ln(7);
$pdf->SetFontSize(16);
$pdf->Cell(0,0,'ЛЕСЎКЩµГ '.iconv('UTF-8','TIS-620',$cur->curName).' ГШи№·Хи '.$genNo,0,0,'C');
$pdf->Ln(7);
$pdf->Cell(0,0,'»ГРЁУ»ХЎТГИЦЎЙТ '.intval($acY-1),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(10,12,'·Хи',1,0,'C',1);
$pdf->Cell(20,12,'ГЛСК№СЎИЦЎЙТ',1,0,'C',1);
$pdf->Cell(60,12,'ЄЧиН-КЎШЕ№СЎИЦЎЙТ',1,0,'C',1);
$pdf->Cell(10,12,'ЄСй№»Х',1,0,'C',1);
$pdf->Cell(75,6,'¤Рб№№а©ЕХиВ',1,0,'C',1);
$pdf->Cell(15,12,'К¶Т№Р',1,0,'C',1);
//Go to next row
$y_axis = $y_axis_initial + $row_height;
$pdf->SetY($y_axis);
$pdf->SetX($x_axis_initial+100);
$pdf->Cell(15,6,'ГТВАТ¤ 1',1,0,'C',1);
$pdf->Cell(15,6,'ГТВАТ¤ 2',1,0,'C',1);
$pdf->Cell(15,6,'ГТВАТ¤ 3',1,0,'C',1);
$pdf->Cell(15,6,'ГТВ»Х',1,0,'C',1);
$pdf->Cell(15,6,'КРКБ',1,0,'C',1);
$y_axis = $y_axis + $row_height;
}
$pdf->SetFont('AngsanaNew','',14);
$pdf->SetY($y_axis);
$pdf->Cell(10,6,$r,1,0,'C');
$pdf->Cell(20,6,iconv('UTF-8','TIS-620',$row->stdCode),1,0,'C');
$pdf->Cell(60,6,iconv('UTF-8','TIS-620',$row->prefixName).iconv('UTF-8','TIS-620',$row->stdName).' '.iconv('UTF-8','TIS-620',$row->stdSurname),1,0,'L');
$pdf->Cell(10,6,intval($row->stdSyId-1) ? intval($row->stdSyId-1) : 1,1,0,'C');
$pdf->Cell(15,6,number_format($GPA1, 2),1,0,'C');
$pdf->Cell(15,6,number_format($GPA2, 2),1,0,'C');
$pdf->Cell(15,6,number_format($GPA3, 2),1,0,'C');
$pdf->Cell(15,6,'-',1,0,'C');
$pdf->Cell(15,6,number_format($row->stdGPA, 2),1,0,'C');
$pdf->Cell(15,6,'ЎЕШиБ '.$passStatus,1,0,'C');
//Go to next row
$y_axis = $y_axis + $row_height;
$i = $i + 1;
$r = $r + 1;
} //End while
}
if ($i > 19) {
$i = 0;
$pdf->AddPage();
$pdf->SetFont('AngsanaNew','B',18);
$pdf->SetX(105);
$pdf->SetY(24);
$pdf->Cell(0,0,'ГТВ§Т№К¶Т№РЎТГаЕЧиН№ЄСй№»Х',0,0,'C');
$pdf->Ln(7);
$pdf->SetFontSize(16);
$pdf->Cell(0,0,'ЛЕСЎКЩµГ '.iconv('UTF-8','TIS-620',$cur->curName).' ГШи№·Хи '.$genNo,0,0,'C');
$pdf->Ln(7);
$pdf->Cell(0,0,'»ГРЁУ»ХЎТГИЦЎЙТ '.intval($acY-1),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(10,12,'·Хи',1,0,'C',1);
$pdf->Cell(20,12,'ГЛСК№СЎИЦЎЙТ',1,0,'C',1);
$pdf->Cell(60,12,'ЄЧиН-КЎШЕ№СЎИЦЎЙТ',1,0,'C',1);
$pdf->Cell(10,12,'ЄСй№»Х',1,0,'C',1);
$pdf->Cell(75,6,'¤Рб№№а©ЕХиВ',1,0,'C',1);
$pdf->Cell(15,12,'К¶Т№Р',1,0,'C',1);
//Go to next row
$y_axis = $y_axis_initial + $row_height;
$pdf->SetY($y_axis);
$pdf->SetX($x_axis_initial+100);
$pdf->Cell(15,6,'ГТВАТ¤ 1',1,0,'C',1);
$pdf->Cell(15,6,'ГТВАТ¤ 2',1,0,'C',1);
$pdf->Cell(15,6,'ГТВАТ¤ 3',1,0,'C',1);
$pdf->Cell(15,6,'ГТВ»Х',1,0,'C',1);
$pdf->Cell(15,6,'КРКБ',1,0,'C',1);
$y_axis = $y_axis + $row_height;
}
$y_axis = $y_axis + $row_height;
$pdf->SetY($y_axis);
$pdf->SetX(20);
$pdf->Cell(0,6,'КГШ»јЕЎТГаГХВ№',0,0,'L');
$pdf->Ln(7);
$pdf->SetX(20);
$pdf->Cell(0,6,'ЎЕШиБ 1 ЁУ№З№ '.$ssm->getCountStdIdBycurIdAdYTmPassStatus($curId, $adY, $acY-1, $tm, 1).' ¤№',0,0,'L');
$pdf->Ln(7);
$pdf->SetX(20);
$pdf->Cell(0,6,'ЎЕШиБ 2 ЁУ№З№ '.$ssm->getCountStdIdBycurIdAdYTmPassStatus($curId, $adY, $acY-1, $tm, 2).' ¤№',0,0,'L');
$pdf->Ln(7);
$pdf->SetX(20);
$pdf->Cell(0,6,'ЎЕШиБ 3 ЁУ№З№ '.$ssm->getCountStdIdBycurIdAdYTmPassStatus($curId, $adY, $acY-1, $tm, 3).' ¤№',0,0,'L');
$pdf->Ln(7);
$pdf->SetX(20);
$pdf->Cell(0,6,'ЎЕШиБ 4 ЁУ№З№ '.$ssm->getCountStdIdBycurIdAdYTmPassStatus($curId, $adY, $acY-1, $tm, 4).' ¤№',0,0,'L');
$pdf->Ln(7);
$pdf->SetX(20);
$pdf->Cell(0,6,'ЎЕШиБ 5 ЁУ№З№ '.$ssm->getCountStdIdBycurIdAdYTmPassStatus($curId, $adY, $acY-1, $tm, 5).' ¤№',0,0,'L');
$pdf->Ln(7);
$pdf->SetFont('AngsanaNew','B',14);
$pdf->Cell(0,6,'ЛБТВаЛµШ',0,0,'L');
$pdf->Ln(7);
$pdf->SetFont('AngsanaNew','',14);
$pdf->Cell(0,6,'ЎЕШиБ 1 ЛБТВ¶Ц§ аЕЧиН№ЄСй№дґй¤Рб№№а©ЕХиВКРКБµСй§бµи 2.00 ўЦй№д»бЕРдБиБХµЎг№ГТВЗФЄТ',0,0,'L');
$pdf->Ln(7);
$pdf->Cell(0,6,'ЎЕШиБ 2 ЛБТВ¶Ц§ аЕЧиН№ЄСй№дґйНВиТ§БХа§ЧиН№дў ¤Рб№№а©ЕХиВКРКБµСй§бµи 2.00 ўЦй№д»бЕРµЎг№єТ§ЗФЄТµйН§Е§·РаєХВ№аГХВ№гЛБиг№ГТВЗФЄТ·ХиµЎ',0,0,'L');
$pdf->Ln(7);
$pdf->Cell(0,6,'ЎЕШиБ 3 ЛБТВ¶Ц§ аЕЧиН№ЄСй№дґйНВиТ§БХа§ЧиН№дў ¤Рб№№а©ЕХиВКРКБГРЛЗиТ§ 1.95-1.99 µйН§·У¤Рб№№а©ЕХиВКРКБ аБЧиНЁєЄСй№»Х·Хи 2 дБи№йНВЎЗиТ 2.00',0,0,'L');
$pdf->Ln(7);
$pdf->Cell(0,6,'ЁЦ§ЁРаЕЧиН№ЄСй№дґй',0,0,'L');
$pdf->Ln(7);
$pdf->Cell(0,6,'ЎЕШиБ 4 ЛБТВ¶Ц§ «йУЄС鹤Рб№№а©ЕХиВКРКБ №йНВЎЗиТ 1.95 ЛГЧН¤Рб№№¤ЗТБ»ГРѕДµФµиУЎЗиТ 80 ¤Рб№№',0,0,'L');
$pdf->Ln(7);
$pdf->Cell(0,6,'ЎЕШиБ 5 ЛБТВ¶Ц§ ѕй№КАТѕ№СЎИЦЎЙТ дґй¤Рб№№а©ЕХиВКРКБ№йНВЎЗиТ 1.75',0,0,'L');
$pdf->Ln(14);
$pdf->Cell(60,6,'Е§ЄЧиН............................................................',0,0,'C');
$pdf->Cell(70,6,'Е§ЄЧиН............................................................',0,0,'C');
$pdf->Cell(0,6,'Е§ЄЧиН............................................................',0,0,'C');
$pdf->Ln(7);
$pdf->Cell(60,6,'№ТВ·РаєХВ№',0,0,'C');
$pdf->Cell(70,6,'ЛСЗЛ№йТЅиТВЗФЄТЎТГ',0,0,'C');
$pdf->Cell(0,6,'јНЎ.',0,0,'C');
//Create file
$pdf->Output();
?>
|