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_21.php

<?php
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );

if(!($_SESSION['login_status']<=5)){
exit();
}
//วันนี้
$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";

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

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

//ปีงบประมาณ
$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();
}
	//กรณีเลือกปี
	$year_index=$_REQUEST['year_index'];
	if($year_index!=""){
		$year_active_result['budget_year']=$year_index;
	}
	$workgroup=$_REQUEST['workgroup'];	
	
//ส่วนหัว
echo "<br>";
echo "<table width='100%' 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>";

/////////////////////////
if($index==17){
$proj_year=$year_active_result['budget_year'];
$sql_ref = "SELECT *  FROM  plan_acti_2  where budget_year='$proj_year' and  id = '$_GET[acti_id]' ";
$query_ref= mysqli_query($connect,$sql_ref);
$result_ref = mysqli_fetch_array($query_ref);

?>
<script type="text/javascript" src="./css/js/calendarDateInput.js"></script>

<br />
<p align="center"><Font Size='3' color='#000099'><B>รายละเอียดกิจกรรม</B></Font></p>
<TABLE width="80%"  border="0" align="center" cellpadding="2" cellspacing="2" height="50" Bgcolor="#Fcf9d8">
<?php
echo "<Tr ><Td colspan='2' align='right'><INPUT TYPE='button' name='smb' value='<<กลับหน้าก่อน' onclick='location.href=\"?option=budget&task=main/report_21\"'></Td></Tr>";
?>
<tr> 
                    <td align="right"><b><font color="#003333" size="2" face="MS Sans Serif">วัน- เดือน-ปี : </font></b></td>
                    <td align="left" width="60%"> 
					<?php
					echo thai_date_2($result_ref['rec_date']);
					?>
                    </td></tr>
					 <tr> 
                    <td align="right"><b><font color="#003333" size="2" face="MS Sans Serif">รหัสกิจกรรม :</font></b></td>
                    <td align="left">
					<?php
					echo $result_ref['code_acti'];
					?>
                    </td></tr>
				<tr> 
                    <td align="right"><b><font color="#003333" size="2" face="MS Sans Serif">กิจกรรม :</font></b></td>
                    <td align="left">
					<?php
					echo $result_ref['name_acti'];
					?>
                    </td></tr>
<tr> 
                    <td align="right"><b><font color="#003333" size="2" face="MS Sans Serif">วันเริ่มต้นกิจกรรม :</font></b></td>
                    <td align="left"> 
					<?php
					 echo thai_date_2($result_ref['begin_date']);
					?>
                    </td></tr>
				<tr> 
                    <td align="right"><b><font color="#003333" size="2" face="MS Sans Serif">วันสิ้นสุดกิจกรรม :</font></b></td>
                    <td align="left">
					<?php
					echo thai_date_2($result_ref['finish_date']);
					?>
                    </td></tr>
                 <tr> 
                    <td align="right"><b><font color="#003333" size="2" face="MS Sans Serif">แหล่งเงิน :</font></b></td>
                    <td align="left"></td></tr>
<?php
		
		//แสดงแหล่งเงิน
		$sql_budget = "SELECT *  FROM  plan_acti_3  where budget_year='$proj_year'  and  code_acti = '$result_ref[code_acti]' ";
		$query_budget =mysqli_query($connect,$sql_budget);
		$N=1;
		while($result_budget= mysqli_fetch_array($query_budget)){
		echo "<tr><td></td><td>$N ";
		echo "<Select  name='vcode_approve[]' size='1'>";
		$sql = "select  num, item,project from  budget_receive where  budget_year='$proj_year' order by num";
		$dbquery =mysqli_query($connect,$sql);
		echo  "<option  value = ''>เลือก</option>" ;
		echo "<optgroup label='งบประมาณ'>";
		While ($result = mysqli_fetch_array($dbquery))
		   {
		$num = $result['num'];
		$project = $result['project'];
		$num2="2_$num";
		echo $num2;
		$item_name = $result['item'];
		$item_name=substr($item_name,0,100);
		
					if($num2==$result_budget['code_approve']){
					echo  "<option value ='2_$num' selected>งวดที่&nbsp;$num&nbsp;[$project]$item_name</option>";
					}
			}
		echo  "</optgroup>";
		echo "</select>";	
		echo "<br><b><font color='#003333' size='2' face='MS Sans Serif'> จำนวนเงิน </font></b>";
		echo number_format($result_budget['budget_acti'],2);
		echo " บาท";
		echo "</td></tr>";
		$N++;
		} //while
		echo "<tr><td>&nbsp;</td><td></td></tr>";	
?>	
				
<table>
<?php

} //end if index==17

if($index!=17){

if($workgroup!=""){
$sql = "select * from  plan_proj_2 where budget_year='$year_active_result[budget_year]' and code_clus='$workgroup' order by code_proj ";
}
else{
$sql = "select * from  plan_proj_2 where budget_year='$year_active_result[budget_year]' order by code_proj ";
}
$dbquery = mysqli_query($connect,$sql);
$rd=1;
While ($result = mysqli_fetch_array($dbquery)){
$code_proj_plan= $result['code_proj']; 
$name_proj_plan= $result['name_proj'];
$budget_proj_plan= $result['budget_proj'];
							
$code_proj_plan_ar[$rd]=$code_proj_plan;
$name_proj_plan_ar[$rd]=$name_proj_plan;
$budget_proj_plan_ar[$rd]=$budget_proj_plan;
$rd++;
}
						
$sql = "select * from  plan_acti_2 where budget_year='$year_active_result[budget_year]'";
$dbquery = mysqli_query($connect,$sql);
$re=1;
While ($result = mysqli_fetch_array($dbquery)){
$acti_id= $result['id'];  
$code_proj_acti= $result['code_proj'];  
$code_acti= $result['code_acti'];
$name_acti= $result['name_acti'];

//จำนวนเงิน
				$sql_budget = "select  sum(budget_acti) as budget_acti  FROM  plan_acti_3  where budget_year='$year_active_result[budget_year]'  and  code_acti=$code_acti";
				$dbquery_budget =mysqli_query($connect,$sql_budget);
				$result_budget = mysqli_fetch_array($dbquery_budget);
				$budget_acti=$result_budget['budget_acti'];  
				//
$acti_id_ar[$re]=$acti_id;
$code_proj_acti_ar[$re]=$code_proj_acti;
$code_acti_ar[$re]=$code_acti;
$name_acti_ar[$re]=$name_acti;
$budget_acti_ar[$re]=$budget_acti;
$re++;
}

$sql = "select  distinct  pj_activity  from  budget_money_return where budget_year='$year_active_result[budget_year]'";
$dbquery = mysqli_query($connect,$sql);
$rf=1;
While ($result = mysqli_fetch_array($dbquery)){
$return_pj_activity= $result['pj_activity'];
$return_pj_activity_ar[$rf]=$return_pj_activity;
$rf++;
}

// loop โครงการ			
				for($i=1;$i<$rd;$i++){
				$proj_sum=0;  
				$return_proj_sum=0;
							//loop กิจกรรม
							for($x=1;$x<$re;$x++){
							$acti_sum=0;  // ตัวแปรเิงินเบิกกิจกรรม
							$return_sum=0; // ตัวแปรเงินคืนกิจกรรม
							
									if($code_proj_plan_ar[$i]==$code_proj_acti_ar[$x]){
							// รายจ่ายในกิจกรรม			
									$sql_acti = "select sum(money) as money from  budget_withdraw where budget_year='$year_active_result[budget_year]' and pj_activity='$code_acti_ar[$x]' ";
									$dbquery_acti = mysqli_query($connect,$sql_acti);
									$result_acti = mysqli_fetch_array($dbquery_acti);
									$acti_sum_ar[$x]=$result_acti['money']; //รายจ่ายในกิจกรรม
									$proj_sum=$proj_sum+ $acti_sum_ar[$x]; // รวมจ่ายในโครงการ   
											for($z=1;$z<$rf;$z++){
													if($code_acti_ar[$x]==$return_pj_activity_ar[$z]){
													// คืนเงินกิจกรรม
													$sql_return = "select  sum(money) as money from  budget_money_return where budget_year='$year_active_result[budget_year]' and pj_activity='$code_acti_ar[$x]'";  
													$dbquery_return = mysqli_query($connect,$sql_return);
													$result_return = mysqli_fetch_array($dbquery_return);
													$return_sum_ar[$x]=$result_return['money'];  //เง้นคืนกิจกรรม
													$return_proj_sum=$return_proj_sum+$return_sum_ar[$x];  //เงินคืนในโครงการ
													}
											}		
									}
							//จ่ายในแต่ละกิจกรรมเมื่อรวมเงินคืนโครงการแล้ว
							if(!(isset($return_sum_ar[$x]))){
							$return_sum_ar[$x]=0;
							}
							
							if(isset($acti_sum_ar[$x])){
							$acti_pay_ar[$x]=$acti_sum_ar[$x]-$return_sum_ar[$x]; 
							}
							else{
							$acti_pay_ar[$x]=0;
							}  
							
							}
				$proj_sum_ar[$i]=$proj_sum;   //เงินจ่ายโครงการ
				$return_proj_sum_ar[$i]=$return_proj_sum;   //เงินคืนโครงการ
				$true_withdraw[$i]=$proj_sum_ar[$i]-$return_proj_sum_ar[$i]; //รายจ่ายสุทธิโครงการ
				if(!(isset($total_withdraw))){
				$total_withdraw=0;
				}
				$total_withdraw=$total_withdraw+$true_withdraw[$i];			
				}
					
$space="  ";

//////////////////	เลือกปีงบประมาณ

echo "<form  name='frm1'>";
	echo "<table width='95%' align='center'><tr><td align='right'>";
if($_SESSION['login_status']<=4){
	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>";
}
echo "&nbsp;<Select  name='workgroup' size='1'>";
echo  '<option value ="" >ทุกกลุ่ม(งาน)</option>' ;
						$sql = "SELECT *  FROM   system_workgroup";
						$dbquery = mysqli_query($connect,$sql);
						While ($result = mysqli_fetch_array($dbquery))
							{ 
								if ($workgroup==$result[workgroup]){
								echo "<option value=$result[workgroup]  selected>$result[workgroup_desc]</option>"; 
								} 
								else{
								echo "<option value=$result[workgroup]>$result[workgroup_desc]</option>"; 
								}
							}
					echo "</select>";
echo "&nbsp;<INPUT TYPE='button' name='smb' value='เลือก' onclick='goto_url(1)' class=entrybutton>";
echo "</td></tr></table>";
echo "</form>";

/////////////////////

echo  "<table width='98%' border='0' align='center'>";
echo "<Tr bgcolor='#FFCCCC' align='center'><Td>ที่</Td><Td>รหัส</Td><Td>โครงการ</Td><Td>กิจกรรม</Td><Td>งบประมาณ</Td><Td>ใช้จ่าย</Td><Td>คงเหลือ</Td><Td>%จ่าย</Td><Td>เงินงวด</Td><Td>เบิก</Td></Tr>";

//กำหนดตัวแปร
		if(!(isset($sum_momey_proj))){
		$sum_momey_proj=0;
		}
		
		if(!(isset($total_withdraw))){
		$total_withdraw=0;
		}

if(!(isset($total_net))){
		$total_net=0;
		}

for($i=1;$i<$rd;$i++)
{		
		$sum_momey_proj=$sum_momey_proj+$budget_proj_plan_ar[$i];  //รวมยอดเงินทุกโครงการ
		$budget_project=number_format($budget_proj_plan_ar[$i],2);       //เงินแต่ละโครงการ
		
		if($budget_proj_plan_ar[$i]>0)
		{
		$proj_percent=($true_withdraw[$i]/$budget_proj_plan_ar[$i])*100;
		$proj_percent=number_format($proj_percent,2);
		}
		else
		$proj_percent="0.00";
		
		$proj_sum=number_format($true_withdraw[$i],2);
		$net_proj=$budget_proj_plan_ar[$i]-$true_withdraw[$i];
		$net_proj2=number_format($net_proj,2);
		$total_net=$total_net+$net_proj;  //เงินเหลือทั้งหมดทุกโครงการ
		
		echo "<Tr bgcolor='#FFFFC''><Td align='center'>$i</Td><Td align='center'><font>$code_proj_plan_ar[$i]</font></Td><Td colspan='2'>$name_proj_plan_ar[$i]</Td><Td align='right'><font color='#FF0033'>$budget_project</font></Td><Td align='right'><font color='#FF0033'>$proj_sum</font></Td><Td align='right'><font color='#FF0033'>$net_proj2</font></Td><Td align='right'><font color='#FF0033'>$proj_percent</font></Td><Td></Td><Td></Td></Tr>";		
		$acti_num=0;
		for($x=1;$x<$re;$x++)
		{
				if($code_proj_plan_ar[$i]==$code_proj_acti_ar[$x])
					{
					$acti_num=$acti_num+1;
					$budget_acti=number_format($budget_acti_ar[$x],2);
					$acti_sum=number_format($acti_pay_ar[$x],2);
					$net_acti=$budget_acti_ar[$x]-$acti_pay_ar[$x];
					$net_acti2=number_format($net_acti,2);
				
					if($budget_acti_ar[$x]>0)
					{
					$acti_percent=($acti_pay_ar[$x]/$budget_acti_ar[$x])*100;
					$acti_percent=number_format($acti_percent,2);
					}
					else
					$acti_percent="0.00";
				
						echo "<Tr><Td ></Td><Td></Td><Td></Td><Td align='left'>";
						echo "<font color='#0000FF'>$code_acti_ar[$x]</font>";
						
						echo "$space$name_acti_ar[$x]</Td><Td align=right>$budget_acti</Td><Td align=right>$acti_sum</Td><Td align='right'>$net_acti2</Td><Td align=right>$acti_percent</Td>";
					
						echo "<td align='center'><a href=?option=budget&task=main/report_21&acti_id=$acti_id_ar[$x]&index=17><img src=images/browse.png border='0'></a></td>";	
					
						if($acti_sum!=0){
						echo "<Td><div align='center'><a href=?option=budget&task=main/report_2&pj_activity=$code_acti_ar[$x]&year_index=$year_active_result[budget_year]><img src=images/browse.png border='0'></a></div></Td>";
						}
						else {  echo"<Td></Td>";
						}
						echo "</Tr>";
					}
		}
}
		
		if($sum_momey_proj>0)
		{
		$spt_percent=($total_withdraw/$sum_momey_proj)*100;
		$spt_percent=number_format($spt_percent,2);
		}
		else
		$spt_percent="0.00";

$sum_momey_proj=number_format($sum_momey_proj,2);
$total_withdraw=number_format($total_withdraw,2);
$total_net=number_format($total_net,2);

echo "<Tr bgcolor=#FFCCCC align=center class=style1><Td></Td><Td></Td><Td></Td><Td>รวม</Td><Td>$sum_momey_proj</Td><Td>$total_withdraw</Td><Td>$total_net</Td><Td>$spt_percent</Td><Td></Td><Td></Td></Tr>";
echo "</Table>";
} //$index!=17
?>

${this.title}

Code Editor : report_21.php