Gecko [ 122.154.134.11 ]

Name	Size	Permission
detail	[ DIR ]	drwxr-xr-x
Thumbs.db	5.5 KB	-rw-r--r--
dbconfig.inc.php	134 B	-rw-r--r--
javachkbox.html	1.09 KB	-rw-r--r--
plan_BudgetCategory.php	3.29 KB	-rw-r--r--
plan_addacti.php	2.35 KB	-rw-r--r--
plan_addstd.php	1.86 KB	-rw-r--r--
plan_adduser.php	2.24 KB	-rw-r--r--
plan_addyear.php	1.4 KB	-rw-r--r--
plan_allot.php	3.62 KB	-rw-r--r--
plan_authen.php	6.55 KB	-rw-r--r--
plan_authenfg.php	9 B	-rw-r--r--
plan_bstandard.php	4.76 KB	-rw-r--r--
plan_calendar.php	297 B	-rw-r--r--
plan_cancel_form.php	775 B	-rw-r--r--
plan_config.php	634 B	-rw-r--r--
plan_dbconnect.php	291 B	-rw-r--r--
plan_dbconnon.php	252 B	-rw-r--r--
plan_default.php	592 B	-rw-r--r--
plan_deleacti.php	423 B	-rw-r--r--
plan_deleproj.php	581 B	-rw-r--r--
plan_deleuser.php	395 B	-rw-r--r--
plan_detailacti.php	7.69 KB	-rw-r--r--
plan_detailproj.php	6.76 KB	-rw-r--r--
plan_editacti.php	7.23 KB	-rw-r--r--
plan_editacti_bak.php	16.4 KB	-rw-r--r--
plan_editcalendar.php	818 B	-rw-r--r--
plan_editproj.php	8.78 KB	-rw-r--r--
plan_estandard.php	4.7 KB	-rw-r--r--
plan_eval_detail.php	4.13 KB	-rw-r--r--
plan_function.php	2.43 KB	-rw-r--r--
plan_grouplistadd.php	1.42 KB	-rw-r--r--
plan_in_acti.php	14.25 KB	-rw-r--r--
plan_in_proj.php	58.07 KB	-rw-r--r--
plan_in_proj_2.php	59.06 KB	-rw-r--r--
plan_owner_report.php	9.41 KB	-rw-r--r--
plan_owner_report2.php	3.03 KB	-rw-r--r--
plan_owner_report3.php	2.56 KB	-rw-r--r--
plan_person.php	1.36 KB	-rw-r--r--
plan_projcalendar.php	715 B	-rw-r--r--
plan_projlistadd.php	1.85 KB	-rw-r--r--
plan_report_tegy.php	7.46 KB	-rw-r--r--
plan_report_upload.php	2.53 KB	-rw-r--r--
plan_return_ajax_proj.php	1015 B	-rw-r--r--
plan_setgic.php	4.8 KB	-rw-r--r--
plan_setgic_year.php	10.98 KB	-rw-r--r--
plan_setgicadd.php	1.23 KB	-rw-r--r--
plan_setgicedit.php	3.28 KB	-rw-r--r--
plan_setuser.php	7.22 KB	-rw-r--r--
plan_setuser.php.bak	11.21 KB	-rw-r--r--
plan_show_plan.php	9.35 KB	-rw-r--r--
plan_show_plan.php.bak	13.04 KB	-rw-r--r--
plan_show_plan2.php	8.01 KB	-rw-r--r--
plan_show_steg.php	11.33 KB	-rw-r--r--
plan_signin.php	336 B	-rw-r--r--
plan_standard.php	653 B	-rw-r--r--
plan_temp.php	86 B	-rw-r--r--
plan_updacti.php	1.34 KB	-rw-r--r--
plan_updproj.php	1.11 KB	-rw-r--r--
plan_upload.php	2.38 KB	-rw-r--r--
plan_upload_detail.php	3.74 KB	-rw-r--r--
plan_upload_eval.php	3.54 KB	-rw-r--r--
plan_upload_form.php	1.28 KB	-rw-r--r--
plan_writeproj.php	1.18 KB	-rw-r--r--
plan_year.php	10.79 KB	-rw-r--r--
plan_year1.php	1.25 KB	-rw-r--r--
plan_year1.php.bak	1.24 KB	-rw-r--r--
test.php	392 B	-rw-r--r--
test1.php	536 B	-rw-r--r--
test2.php	1.46 KB	-rw-r--r--
test3.php	1.67 KB	-rw-r--r--
xplan_authen.php	3.85 KB	-rw-r--r--
xplan_authenfg.php	2.45 KB	-rw-r--r--
xplan_return_ajax_proj.php	1.12 KB	-rw-r--r--

Code Editor : plan_show_plan2.php

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

require_once("plan_authen.php");  //session_
	if(isset($_REQUEST['plan_tegic'])){
	$plan_tegic=$_REQUEST['plan_tegic'];
	}
	if(isset($_SESSION["budget_year"])){
	$proj_year=$_SESSION["budget_year"];
	}
	if(isset($_POST['year_index'])){
	$year_index=$_POST['year_index'];
	}
	
	if(isset($year_index)){
	$proj_year=$year_index;
	}
	
if($proj_year==""){
	echo "<br><div align='center'>ยังไม่ได้กำหนดปีงบประมาณ</div>";
	exit();
}

?>
<p align="center" STYLE="font-family: 'sans-serif', fantasy; font-size: 13pt; color:blue;font-weight: bold;">โครงการ จำแนกตามยุทธศาสตร์</Font></p>

<FORM  name="frm1" >
<?php
//เลือกประเภท
require_once("dbconfig.inc.php");
	echo "<table width='95%' align='center'><tr><td align='right'>";
//////////////////	
	echo "ปีงบประมาณ&nbsp";
	echo "<Select  name='year_index' size='1'>";
	echo  '<option value ="" >เลือก</option>' ;
	$sql_year = "SELECT *  FROM  plan_year order by budget_year";
	$dbquery_year =DBfieldQuery($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 "<Select  name='plan_tegic' size='1'>";
	echo  '<option value ="" >ทุกยุทธศาสตร์</option>' ;
	$sql = "SELECT *  FROM  plan_stregic where budget_year='$proj_year' ";
	$dbquery =DBfieldQuery($sql);
			While ($result = mysqli_fetch_array($dbquery))
			{ 
			$strategic=$result['strategic'];
			$strategic=substr($strategic,0,150);
					if ($plan_tegic==$result['id_tegic']){
					echo "<option value=$result[id_tegic]  selected>$strategic</option>"; 
					} 
					else{
					echo "<option value=$result[id_tegic]>$strategic</option>"; 
					}
			}
					echo "</select>";
					echo "&nbsp;<INPUT TYPE='button' name='smb' value='เลือก' onclick='goto_url(1)' class=entrybutton>";
echo "</td></tr></table>";
?>     
</FORM>

<?php
if(!(isset($plan_tegic))){
$plan_tegic="";
}
ShowProj($plan_tegic,$proj_year);
#######################################
function ShowProj($plan_tegic,$proj_year){
//อาเรย์บุคลากร
$sql = "SELECT *  FROM  person_main order by position_code,name";
$dbquery=DBfieldQuery($sql);
while ($result = mysqli_fetch_array($dbquery)){
$person_ar[$result['person_id']]=$result['prename'].$result['name']." ".$result['surname'];
}

if($plan_tegic!="")
$sql = "select * from  plan_proj  where (code_tegy='$plan_tegic')  and  (budget_year='$proj_year') order by code_proj ";
else
	$sql = "select * from  plan_proj  where (budget_year='$proj_year') order by code_proj ";
$dbquery =DBfieldQuery($sql);
$rd=1;
$budget_proj_sum=0; //ตัวแปรรวมเงินโครงการ
While ($result = mysqli_fetch_array($dbquery)) {
$code_clus_plan= $result['code_clus'];
$code_proj_plan= $result['code_proj'];
$name_proj_plan= $result['name_proj'];
$budget_proj_plan= $result['budget_proj'];
	$budget_proj_sum=$budget_proj_sum+$budget_proj_plan;  //รวมเงินโครงการ
$owner_proj_plan =$result['owner_proj'];
$code_tegy_plan =$result['code_tegy'];
$file_detail_plan =$result['file_detail']; 
$eval_activity_plan =$result['eval_activity'];
$allow_edit_plan =$result['allow_edit'];
$owner_proj_plan=trim($owner_proj_plan);
$point=strpos($owner_proj_plan,chr('38'));
$len=strlen($owner_proj_plan);
		if(($point>0) and ($point<5))
		{	$owner_proj_plan=substr($owner_proj_plan,$point,$len);
		$point=strpos($owner_proj_plan,chr('38'));
		$len=strlen($owner_proj_plan);
		}
$long=$len-$point;
$fname=substr($owner_proj_plan,0,$point);
$sname=substr($owner_proj_plan,-$long,$long);
$cname=trim($sname);
if(isset($budget_proj)){
$Fcredit1=number_format($budget_proj);
}
//::: valiable array ::://
$code_clus_plan_ar[$rd]=$code_clus_plan;
$code_proj_plan_ar[$rd]=$code_proj_plan;
$name_proj_plan_ar[$rd]=$name_proj_plan;
$budget_proj_plan_ar[$rd]=$budget_proj_plan;
$file_detail_plan_ar[$rd]=$file_detail_plan; 
$eval_activity_plan_ar[$rd]=$eval_activity_plan;
$allow_edit_plan_ar[$rd]=$allow_edit_plan;
$owner_proj_plan_ar[$rd]=$owner_proj_plan;
$fname_plan_ar[$rd]=$fname;
$cname_plan_ar[$rd]=$cname;
		if(empty($code_tegy_plan))
		{   $code_tegy_plan="_";   }
		$code_tegy_plan_ar[$rd] =$code_tegy_plan;
$rd++;
}
//::: End valiable array ::://

$sql_acti = "select * from  plan_acti where budget_year='$proj_year' order by code_acti";
					$dbquery_acti =DBfieldQuery($sql_acti);
					$re=1;
					While ($result_acti = mysqli_fetch_array($dbquery_acti))
						{
							$code_proj_acti= $result_acti['code_proj'];
							$code_acti= $result_acti['code_acti'];
							$name_acti= $result_acti['name_acti'];
							$budget_acti= $result_acti['budget_acti'];
							
							$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++;
	    				}

$space="  ";
echo  "<table width='95%' border='1'  borderColor='#FF0033'  align='center' style='border-collapse: collapse'>";
echo   "<Tr bgcolor='#FBD562'><Td  width='5%' valign='center'  align='center' ><font  size='2'>ที่</font></td>";
echo   "<Td  width='5%'  valign='center'  align='center' ><font  size='2'>รหัสโครงการ</font></td>";
echo   "<Td valign='center'  align='center' ><font  size='2'>ชื่อโครงการ/ชื่อกิจกรรม</font></td>";
echo   "<Td  width='12%' valign='center'  align='center' ><font  size='2'>งบประมาณ</font></td>";
echo   "<Td  width='20%'  valign='center'  align='center' ><font  size='2'>หัวหน้าโครงการ</font></td>";
echo   "<Td width='5%' align='center'>ไฟล์</td>";
echo   "</tr>";

for($i=1;$i<$rd;$i++)
{

$budget_proj=number_format($budget_proj_plan_ar[$i],2);
		echo "<Tr bgcolor='#CCFFFF'><Td align=center><font  size='2'>$i</font></Td><Td align=center><font  size='2'>$code_proj_plan_ar[$i]</font></Td><Td><font  size='2'>$name_proj_plan_ar[$i]</font></Td><Td align=right><font  size='2'>$budget_proj</font></Td><Td align=left><font  size='2'>";
echo $person_ar[$owner_proj_plan_ar[$i]];
echo "</font></Td>";	
	
		if($file_detail_plan_ar[$i] !=""){
		echo "<Td align='center'> <a href='$file_detail_plan_ar[$i]' target='_blank' title='อ่านโครงการ'><img src='images/b_browse.png' width='16' height='16' border='0'></a></td>";	
		 }
		 else{
		 echo "<Td>&nbsp;</td>";
		}
		
echo "</tr>";

for($x=1;$x<$re;$x++)
		{
				if($code_proj_acti_ar[$x]==$code_proj_plan_ar[$i]){
				echo "<Tr><Td>&nbsp;</td>";
				echo "<Td>&nbsp;</td>";
				echo "<Td>$code_acti_ar[$x]&nbsp;$name_acti_ar[$x]</td>";
				$budget_acti_ar[$x]=number_format($budget_acti_ar[$x],2);
				echo "<Td align='right'>$budget_acti_ar[$x]</td>";
				echo "<Td>&nbsp;</td>";
				echo "<Td>&nbsp;</td>";
				echo "</tr>";
				}
		}
} //loop rd		
$budget_proj_sum=number_format($budget_proj_sum,2);
echo "<Tr bgcolor='#FBD562' align='center'>";
echo "<Td colspan='3' align='center'>รวม</Td><td>$budget_proj_sum</td><Td colspan='3'>&nbsp;</Td></Tr></Table>";

return 0;
} //function
?>

</script>

${this.title}

Code Editor : plan_show_plan2.php