Software: Apache/2.2.3 (CentOS). PHP/5.1.6 

uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/manage/teacher/   drwxr-xr-x
Free 52.63 GB of 127.8 GB (41.18%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     prePrintMoneyFormPDF-2.php (5.59 KB)      -rw-r--r--

execQuery($query);
	$rss = $dbObj->fetchArray($result);	

		
		$query = "SELECT *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId   LEFT JOIN position_tb ON personal_tb.PositionId = position_tb.PositionId LEFT JOIN faculty_tb ON personal_tb.Faculty_code = faculty_tb.Faculty_code  LEFT JOIN  training_tb ON  personal_tb.Teacher_code = training_tb.Teacher_code   LEFT JOIN  formaoffice  ON   training_tb.Teacher_code = formaoffice.Teacher_code   LEFT JOIN  formofficemoney ON    formaoffice.codeId = formofficemoney.codeId   WHERE   formofficemoney.maNo = '".$_REQUEST["maNo"]." '  and   formofficemoney.Teacher_code = '".$_REQUEST["Flag"]." '  Group  By   formofficemoney.maNo ,  formofficemoney.Flag ";
		$result5 = $dbObj->execQuery($query);
		$rss5 = $dbObj->fetchArray($result5);	
		

$query3 = "Select * From  college Where collegeStatus ='1'";
$result3 = $dbObj->execQuery($query3);
$rs3 = $dbObj->fetchArray($result3);

$query4 = "SELECT *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId LEFT JOIN position_tb ON personal_tb.PositionId = position_tb.PositionId LEFT JOIN faculty_tb ON personal_tb.Faculty_code = faculty_tb.Faculty_code Where personal_tb.Faculty_code = '".$rs['Faculty_code']."' and personal_tb.TeacherId = '1'";
$result4 = $dbObj->execQuery($query4);
$rs4 = $dbObj->fetchArray($result4);	

function readNumber($number, $len) {
	if($number=='0') { $number = ""; }
	else if($number=='1') {
		if($len==2) { $number = ""; }
		else { $number = "Л№Ци§"; }
	}
	else if($number=='2') { 
		if($len==2) { $number = "ВХи"; }
		else { $number = "КН§"; }
	}
	else if($number=='3') { $number = "КТБ"; }
	else if($number=='4') { $number = "КХи"; }
	else if($number=='5') { $number = "ЛйТ"; }
	else if($number=='6') { $number = "ЛЎ"; }
	else if($number=='7') { $number = "аЁзґ"; }
	else if($number=='8') { $number = "Ỵ"; }
	else if($number=='9') { $number = "аЎйТ"; }
	return $number;
}

function readUnit($len) {
	if($len=='1') { $len = ""; }
	else if($len=='2') { $len = "КФє"; }
	else if($len=='3') { $len = "ГйНВ"; }
	else if($len=='4') { $len = "ѕС№"; }
	else if($len=='5') { $len = "ЛБЧи№"; }
	else if($len=='6') { $len = "бК№"; }
	else if($len=='7') { $len = "ЕйТ№"; }
	return $len;
}

function convertNumberToString($amount) {
	list($baht, $satang) = split('[.]', $amount);
	while(strlen($satang) < 2)
		$satang .= '0';
		
	$str = "";
	$len = strlen($baht);
	$i = 0;
	while($i <= strlen($baht)) {
		if($len==1 && $baht[$i-1]!=0 && $baht[$i]==1)
			$str .= "аНзґ";
		else
			$str .= readNumber($baht[$i], $len);
		if($baht[$i] != 0)
			$str .= readUnit($len);
		$len--;
		$i++;
	}
	if($str != "")
		$str .= "єТ·";
	
	$len = strlen($satang);
	$i = 0;
	while($i <= strlen($satang)) {
		if($len==1 && $satang[$i-1]!=0 && $satang[$i]==1)
			$str .= "аНзґ";
		else
			$str .= readNumber($satang[$i], $len);
		if($satang[$i] != 0)
			$str .= readUnit($len);
		$len--;
		$i++;
	}
	if($satang != '00')
		$str .= "КµТ§¤м";
	return $str;
}
//----------------------------------------

//Create new pdf file
$pdf = new FPDF();

//Set thai font
$pdf->SetThaiFont();

$pdf->AddPage();

//-- Load Form Image to Background
$pdf->Image('../form/FormMoney-2.jpg', 0, 0, 210, 297);

//-- Set Font
$pdf->SetFont('AngsanaNew','',13);

//-- Body ЄЧиН µУбЛ№и§ јЩйГСєа§Ф№
if(!empty($rss5['First_name'])){
		$pdf->SetXY(14,94);
		$pdf->Cell(73,5,$rss5['First_name'].'  '.$rss5['Teacher_name'].'  '.$rss5['Teacher_lastname'],0,0,'C');
}
if(!empty($rss5['Position_name'])){
		$pdf->SetXY(20,101);
		$pdf->Cell(56,5,$rss5['Position_name'],0,0,'C');
}

//  ГЗБ·Сй§КФй№
$sql1 = " SELECT SUM(Budget_use)  AS SumB5  FROM  formofficemoney  WHERE  Flag='$Flag'   and  maNo='$maNo'  ";
$result1 = mysql_query($sql1);
$rss1 = mysql_fetch_array($result1);
if(!empty($rss1['SumB5'])){
	$pdf->SetXY(130,73.5);
	$pdf->Cell(45,5,number_format($rss1['SumB5'],2,'.',','),0,0,'C');
}
else{
	$pdf->SetXY(130,73.5);
	$pdf->Cell(45,5,'-',0,0,'C');
}

//  ЁУ№З№а§Ф№ (µСЗНСЎЙГ)
if(!empty($rss1['SumB5'])){
	$SumB5 = convertNumberToString($rss1['SumB5']);
	$pdf->SetXY(50,80.5);
	$pdf->Cell(45,5,$SumB5."¶йЗ№",0,0,'C');
}
else{
	$pdf->SetXY(60,203);
	$pdf->Cell(45,5,'-',0,0,'C');
}

//Create file
$pdf->Output();
?>
bool(false)