Gecko [ 122.154.134.11 ]

Name	Size	Permission
approve.php	20.37 KB	-rwxr-xr-x
approve_reserve.php	17.03 KB	-rwxr-xr-x
bud_book.php	15.15 KB	-rwxr-xr-x
budget_year.php	10.7 KB	-rwxr-xr-x
cancel_deega.php	12.45 KB	-rwxr-xr-x
cash_book.php	15.49 KB	-rwxr-xr-x
change_bud.php	19.67 KB	-rwxr-xr-x
change_ex_bud.php	22.41 KB	-rwxr-xr-x
change_income_bud.php	22.66 KB	-rwxr-xr-x
ex_bud_book.php	14.92 KB	-rwxr-xr-x
form1.php	14.16 KB	-rwxr-xr-x
form2.php	12.49 KB	-rwxr-xr-x
income_bud_book.php	14.99 KB	-rwxr-xr-x
livesearch.php	1.64 KB	-rwxr-xr-x
pay_bud.php	25.02 KB	-rwxr-xr-x
pay_check.php	25.89 KB	-rwxr-xr-x
pay_check_reserve.php	19.29 KB	-rwxr-xr-x
pay_ex_bud.php	29.83 KB	-rwxr-xr-x
pay_income_bud.php	22.75 KB	-rwxr-xr-x
permission.php	18.38 KB	-rwxr-xr-x
print_check.php	3.71 KB	-rwxr-xr-x
receive_bud.php	19.66 KB	-rwxr-xr-x
receive_ex_bud.php	24.18 KB	-rwxr-xr-x
receive_income_bud.php	24.01 KB	-rwxr-xr-x
refer_deega.php	8.07 KB	-rwxr-xr-x
refer_wd.php	9.41 KB	-rwxr-xr-x
report_1.php	12.31 KB	-rwxr-xr-x
report_10.php	6.31 KB	-rwxr-xr-x
report_10_2.php	8.67 KB	-rwxr-xr-x
report_10_3.php	7.79 KB	-rwxr-xr-x
report_10_4.php	7.17 KB	-rwxr-xr-x
report_12.php	10.69 KB	-rwxr-xr-x
report_12_2.php	6.12 KB	-rwxr-xr-x
report_12_3.php	7.82 KB	-rwxr-xr-x
report_13.php	9.17 KB	-rwxr-xr-x
report_1_mobile.php	11.19 KB	-rwxr-xr-x
report_2.php	6.39 KB	-rwxr-xr-x
report_21.php	17.04 KB	-rwxr-xr-x
report_23.php	8.06 KB	-rwxr-xr-x
report_3.php	9.5 KB	-rwxr-xr-x
report_4.php	6.38 KB	-rwxr-xr-x
report_5.php	5.96 KB	-rwxr-xr-x
report_8.php	6.5 KB	-rwxr-xr-x
report_9.php	8.54 KB	-rwxr-xr-x
report_pay_check.php	15.89 KB	-rwxr-xr-x
report_pay_check_reserve.php	13.11 KB	-rwxr-xr-x
reserve_money.php	29.05 KB	-rwxr-xr-x
return_ajax_proj.php	1.06 KB	-rwxr-xr-x
return_ajax_proj_2.php	859 B	-rw-r--r--
return_withdraw.php	26.73 KB	-rwxr-xr-x
today_report.php	16.29 KB	-rwxr-xr-x
withdraw.php	47.57 KB	-rwxr-xr-x
withdraw2.php	40.21 KB	-rw-r--r--

Code Editor : report_5.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
if($result_permission['p10']!=1){
exit();
}

if(!(isset($_REQUEST['year_index']))){
$_REQUEST['year_index']="";
}

$th_month['01']="มกราคม";
$th_month['02']="กุมภาพันธ์";
$th_month['03']="มีนาคม";
$th_month['04']="เมษายน";
$th_month['05']="พฤษภาคม";
$th_month['06']="มิถุนายน";
$th_month['07']="กรกฎาคม";
$th_month['08']="สิงหาคม";
$th_month['09']="กันยายน";
$th_month['10']="ตุลาคม";
$th_month['11']="พฤศจิกายน";
$th_month['12']="ธันวาคม";

list($now_year,$now_month,$now_day) = explode("-",date("Y-m-d"));	
$now_year=$now_year+543;
$today="วันที่ $now_day เดือน$th_month[$now_month] พ.ศ.$now_year";

//ปีงบประมาณ
$year_index=$_REQUEST['year_index'];
if($year_index!=""){
$year_active_result['budget_year']=$year_index;
}
else{
$sql = "select * from  budget_year where year_active='1' order by budget_year desc limit 1";
$dbquery = mysqli_query($connect,$sql);
$year_active_result = mysqli_fetch_array($dbquery);
			if($year_active_result['budget_year']==""){
			echo "<br />";
			echo "<div align='center'>ยังไม่ได้กำหนดทำงานในปีงบประมาณใด ๆ  กรุณาไปที่เมนูตั้งค่าระบบ เพื่อกำหนดปีงบประมาณ</div>";
			exit();
			}
}

echo "<br />";
echo "<table width='80%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>รายงานการใช้จ่าย จำแนกตามประเภทรายการจ่าย</strong></font></td></tr>";
echo "<tr align='center'><td><font  color='#006666' size='3'>$_SESSION[office_name]</font></td></tr>";
echo "<tr align='center'><td><font  color='#006666' size='3'>$today</font></td></tr>";
echo "</table>";

//ส่วนการแสดงผล
	//หารายจ่ายทั้งหมด
	$sql = "select sum(pay_amount) as total_pay_money from budget_main where  budget_year='$year_active_result[budget_year]' and pay_group>'100' and status!='null'";
	$dbquery = mysqli_query($connect,$sql);
	$result = mysqli_fetch_array($dbquery);
	$total_pay_money = $result['total_pay_money'];
	
	//เลืิอกปีและประเภท
	echo  "<table width='70%' border='0' align='center'>";
	echo "<form id='frm1' name='frm1'>";
	echo "<tr><td align='right'>";
		
	echo "ปีงบประมาณ&nbsp";
	echo "<Select  name='year_index' size='1'>";
	echo  '<option value ="" >เลือก</option>' ;
	$sql_year = "SELECT *  FROM  budget_year order by budget_year";
	$dbquery_year = mysqli_query($connect,$sql_year);
	While ($result_year = mysqli_fetch_array($dbquery_year)){
			 if($year_index==""){
					if($result_year['year_active']==1){
					echo "<option value=$result_year[budget_year]  selected>$result_year[budget_year]</option>"; 
					}
					else{
					echo "<option value=$result_year[budget_year]>$result_year[budget_year]</option>"; 
					}
			 }
			 else{
					if($year_index==$result_year['budget_year']){
					echo "<option value=$result_year[budget_year]  selected>$result_year[budget_year]</option>"; 
					}
					else{
					echo "<option value=$result_year[budget_year]>$result_year[budget_year]</option>"; 
					}
			}	
	}
		echo "</select>&nbsp;";		
		echo "<INPUT TYPE='button' name='smb' value='เลือก' onclick='goto_url(1)' class=entrybutton>";
		echo "</form>";
		echo "</td></Tr></Table>";
//จบส่วนเลือกประเภท

$sql = "select * from budget_pay_type order by pay_type_id";
$dbquery = mysqli_query($connect,$sql);
echo  "<table width=70% border=0 align=center>";
echo "<Tr bgcolor='#FFCCCC' align='center' class=style2><Td width='50'>ที่</Td> <Td>รหัส</Td><Td>ประเภทรายการจ่าย</Td><Td>จำนวนเงิน</Td><Td>ร้อยละ</Td></Tr>";
$M=1;
$total_sum_money=0;
$total_percent=0;
While ($result = mysqli_fetch_array($dbquery))
	{
		$id = $result['id'];
		$pay_type_id= $result['pay_type_id'];
		$pay_group_id= $result['pay_group_id'];
		$pay_type_name = $result['pay_type_name'];
//เิงินที่มีรายการจ่ายในตารางหลัก			
				$sql_sum = "select sum(pay_amount) as sum_money from budget_main where pay_group='$pay_type_id' and budget_year='$year_active_result[budget_year]' and status!='null'";
				$dbquery_sum = mysqli_query($connect,$sql_sum);
				$result_sum = mysqli_fetch_array($dbquery_sum);
				$sum_money=	$result_sum['sum_money'];  
				$total_sum_money=$total_sum_money+$sum_money;
				if($total_pay_money!=0){
				$percent=($sum_money/$total_pay_money)*100;
				$total_percent=$total_percent+$percent;
				$percent=number_format($percent,2);
				}
				else{
				$percent="";
				}
		
				if(($M%2) == 0)
				$color="#FFFFC";
				else  	$color="#FFFFFF";
				
$sum_money=number_format($sum_money,2);

echo "<Tr  bgcolor=$color align='center'><Td>$M</Td> <Td>$pay_type_id</Td> <Td align='left'>$pay_type_name</Td><Td align='right'>$sum_money</Td><Td>";
		if($percent!=0){
		echo $percent;
		}
echo "</Td></Tr>";
$M++;
	}
$total_sum_money=	number_format($total_sum_money,2);
$total_percent=	number_format($total_percent,2);
		echo "<Tr bgcolor='#FFCCCC' align='center'><Td></Td><Td></Td> <Td>รวม</Td><Td>$total_sum_money</Td><Td>$total_percent</Td></Tr>";
echo "</Table>";
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*ไม่รวมเงินรายได้แผ่นดิน";
?>
<script>
function goto_url(val){
	if(val==0){
		callfrm("?option=budget&task=main/report_5");   // page ย้อนกลับ 
	}else if(val==1){
			callfrm("?option=budget&task=main/report_5");   //page ประมวลผล
		}
}
</script>

${this.title}

Code Editor : report_5.php