Gecko [ 122.154.134.11 ]

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

Code Editor : plan_in_acti.php

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

// ตรวจสอบปีงบประมาณ
if($_SESSION["budget_year"]==""){
echo "<br>";
echo "<div align='center'>";
echo "ตรวจสอบการกำหนดปีงบประมาณให้ถูกต้องก่อนค่ะ";
echo "</div>";
exit();
}

require_once("plan_function.php");
require_once("plan_editcalendar.php");
require_once("plan_calendar.php");
require("plan_authen.php");  //session_
$proj_year=$_SESSION["budget_year"];
?>

echo "<Select  name='vcode_approve' size='1'>";
		$sql = "select  num, item from  budget_receive where  budget_year='$proj_year' order by num desc";
		$dbquery =DBfieldQuery($sql);
		echo  "<option  value = ''>เลือก</option>" ;
		echo "<optgroup label='งบประมาณ'>";
		While ($result = mysqli_fetch_array($dbquery))
		   {
		$num = $result['num'];
		$item_name = $result['item'];
		$item_name=substr($item_name,0,80);
		echo  "<option value ='2_$num'>งวดที่&nbsp;$num&nbsp;$item_name</option>";
			}
		echo  "</optgroup>";
		
		$sql_type = "select * from budget_type where budget_year='$proj_year' and type_id<'200' order by type_id";
		$dbquery_type =DBfieldQuery($sql_type);
		echo "<optgroup label='เงินนอกงบประมาณ'>";
		While ($result_type = mysqli_fetch_array($dbquery_type))
		   {
		$type_id = $result_type['type_id']; 
		$type_name = $result_type['type_name']; 
		$type_name=substr($type_name,0,150);
		echo  "<option value ='1_$type_id'>$type_id $type_name</option>";
			}
		echo  "</optgroup>";
		echo "</select>";	
?>	
                    </td></tr>
					
              </table>
		</TD>
	 </table>
<?php
 //คำนวณเงิน 
 require_once("dbconfig.inc.php");

$sql_proj = "SELECT sum(budget_proj) as budget_proj_sum FROM  plan_proj  where  code_proj=$_SESSION[mcode_proj] and budget_year=$_SESSION[mplan_year] ";
$dbquery =DBfieldQuery($sql_proj);
$print_r=print_r($dbquery,true); //กรณีไม่มีข้อมูล
$budget_proj_sum=0;
if(!empty($print_r)){
$result = mysqli_fetch_array($dbquery);
$budget_proj_sum=$result['budget_proj_sum'];
}
$sql_acti="select sum(budget_acti) as budget_acti_sum from  plan_acti  where code_proj=$_SESSION[mcode_proj] and budget_year=$_SESSION[mplan_year] ";
$dbquery =DBfieldQuery($sql_acti);
$print_r=print_r($dbquery,true); //กรณีไม่มีข้อมูล
$budget_acti_sum=0;
if(!empty($print_r)){
$result = mysqli_fetch_array($dbquery);
$budget_acti_sum=$result['budget_acti_sum'];
}
//**************************************************
$mbalance=$budget_proj_sum-$budget_acti_sum;
$mbalance=number_format($mbalance,2);
$budget_proj_sum=number_format($budget_proj_sum,2);
$budget_acti_sum=number_format($budget_acti_sum,2);
echo "<BR><CENTER><FONT size='1' face='MS Sans Serif' color='#000099'>ยอดจัดสรร(โครงการ)&nbsp;$budget_proj_sum&nbsp;&nbsp;บาท&nbsp;&nbsp;รวมทุกกิจกรรม&nbsp;$budget_acti_sum&nbsp;&nbsp;บาท&nbsp;&nbsp;</font><FONT size='2' face='MS Sans Serif' color='#CC0000'>คงเหลือ&nbsp;$mbalance&nbsp;บาท</font>";
echo "<p align='center'><Br>";
echo "	<Input Type=Hidden Name=vcode_clus Value=$mcode_clus>";
echo "	<Input Type=Hidden Name=vcode_proj Value=$mcode_proj>";
echo "	<Input Type=Hidden Name=vname_proj Value=$mname_proj>";
echo "	<Input Type=Hidden Name=vbudget_proj Value=$mbudget_proj>";
//echo "	<Input Type=Hidden Name=vid_defalt  Value=$midentify>";
if($_SESSION["mpms_add"]=='1')
{
echo " <Input Type='button' name='smb' value='เพิ่มข้อมูล' onclick='goto_url_update(1)' class='button'>";
}
else{
echo "<div align='center'><font size='3' color='#FF0033'>คุณไม่ได้รับสิทธิ์บันทึกข้อมูล</font></div>";
}
echo "</p>";
echo "</CENTER><BR>";
 //====== end menu ====
?>
 </table>

<Table width="99%" Border="1" borderColor=#990000  Bgcolor="#FFFFFF" align="center" style="border-collapse: collapse">
<?php
echo   "<Tr>";
echo   "<Td  width='7%'  bgcolor='#E8B066'  valign='center'  align='center' >รหัสกิจกรรม</td>";
echo   "<Td  bgcolor='#E8B066'  valign='center'  align='center' >กิจกรรม</td>";
echo   "<Td  width='13%'  bgcolor='#E8B066'  valign='center'  align='center' >จำนวนเงิน</td>";
echo   "<Td  width='7%'  bgcolor='#E8B066'  valign='center'  align='center' >รหัสแหล่งเงิน</td>";
echo   "<Td  width='5%'  bgcolor='#E8B066'  valign='center'  align='center' >รายละเอียด</td>";
if($_SESSION["mpms_edit"]=='1')
{
echo   "<Td  width='5%'  bgcolor='#E8B066'  valign='center'  align='center' >แก้ไข</td>";
}
if($_SESSION["mpms_dele"]=='1')
{
echo   "<Td  width='5%'  bgcolor='#E8B066'  valign='center'  align='center' >ลบ</td>";
}
//echo   "<Td  width='15%'  bgcolor='#E8B066'  valign='center'  align='center' >มาตรฐานการศึกษา</td></tr>";
$mcode_proj=$_SESSION['mcode_proj'];
$mplan_year=$_SESSION['mplan_year'];
$sql_acti="select * from  plan_acti  where code_proj=$mcode_proj and budget_year=$mplan_year order by code_acti";
$dbquery =DBfieldQuery($sql_acti);
$print_r=print_r($dbquery,true); //กรณีไม่มีข้อมูล
if(!empty($print_r)){
while ($result = mysqli_fetch_array($dbquery))
	{
	$id =  $result['id'];
	$daythai =  $result['daythai'];
	$code_acti =$result['code_acti'];
	$code_approve =$result['code_approve'];
	$name_acti = $result['name_acti'];
	$tbudget_acti =$result['budget_acti'];
	$budget_approve =$result['budget_approve'];
	$owner_acti =$result['owner_acti'];
	$id_defalt = $result['id_defalt'];
	$mybeginday=$result['begin_date'];
	$myfinishday=$result['finish_date'];
	$id_defalt = substr($id_defalt,0,9);
    $actiname= substr($name_acti,0,60);
	$Fcredit1=number_format($tbudget_acti,2);
	$len=strlen($owner_acti);
	$point=strpos($owner_acti,' ');
	$long=$len-$point;
	$fname=substr($owner_acti,0,$point);
	$sname=substr($owner_acti,-$long,$long);
	$cname=trim($sname);
	echo   "<Tr>";
	echo   "<Td align='center' ><FONT size='2' face='MS Sans Serif' color='#330000'>$code_acti</td>";
	echo   "<Td align='left' ><FONT size='2' face='MS Sans Serif' color='#330000'>&nbsp;$name_acti</td>";
	echo   "<Td valign='center'  align='right' ><FONT size='2' face='MS Sans Serif' color='#330000'>$Fcredit1&nbsp;&nbsp;&nbsp;</td>";
	echo   "<Td valign='center'  align='center' ><FONT size='2' face='MS Sans Serif' color='#330000'>$code_approve&nbsp;&nbsp;&nbsp;</td>";
	echo   "<Td><div align=center><a href=?option=plan&task=planproject/plan_detailacti&plan_acti_id=$id><img src=\"./images/b_browse.png\" WIDTH='16' HEIGHT='16' BORDER=0 ALT='รายละเอียด'></a></div></Td>";
if($_SESSION["mpms_edit"]=='1'){
	echo   "<Td><div align=center><a href=?option=plan&task=planproject/plan_editacti&plan_acti_id=$id><img src=\"./images/b_edit.png\" WIDTH='16' HEIGHT='16' BORDER=0 ALT='แก้ไขกิจกรรม'></a></div></Td>";
}
if($_SESSION["mpms_dele"]=='1'){
	echo   "<Td><div align=center><a href=?option=plan&task=planproject/plan_deleacti&delete_id=$id&vcode_proj=$mcode_proj><img src=\"./images/b_drop.png\" WIDTH='16' HEIGHT='16' BORDER=0 ALT='ลบกิจกรรม'></a></div></Td>";
}	
// echo   "<Td align=center><a href=?option=plan&task=planproject/plan_estandard&gcode_acti=$code_acti&vcode_clus=$mcode_clus&vcode_proj=$mcode_proj><img src=\"./images/estandard.jpg\"  WIDTH='42' HEIGHT='16' BORDER=0 ALT='มฐ.ปฐมวัย'></a>&nbsp; <a href=?option=plan&task=planproject/plan_bstandard&gcode_acti=$code_acti&vcode_clus=$mcode_clus&vcode_proj=$mcode_proj><img src=\"./images/bstandard.jpg\"  WIDTH='42' HEIGHT='16' BORDER=0 ALT='มฐ.ขั้นพื้นฐาน'></a></Td>";

}}
			$mclus_code=$_SESSION['vclus_code'];
			$mproj_code=$_SESSION['vproj_code'];
			$mproj_name=$_SESSION['vproj_name'];
			$mbudget_proj=$_SESSION['vbudget_proj'];
?>  
       </Td>
	 </Tr>
</Table>
        </Tr>

    </Table>
	<BR>
	<BR>
</Center>
 </form>
<script>
function goto_url_update(val){
	if(val==0){
		callfrm("?option=plan");   // page ย้อนกลับ vcode_clus 	
	}
	else if(val==1)
	{ 
			if(frm1.vcode_proj.value == "")
				 {
				alert("กรุณาเลือกโครงการ");
				document.frm1.vcode_acti.focus();
				return false;
				}
				else if(frm1.vcode_acti.value == "")
						{
						alert("กรุณาป้อน	รหัสกิจกรรม \n 001,002,...");
						document.frm1.vcode_acti.focus();
						return false;
						}
				else if(frm1.vname_acti.value == "")
						{
						alert("กรุณาป้อน กิจกรรม");
						document.frm1.vname_acti.focus();
						return false;
						}
				else if(frm1.vbudget_acti.value == "")
						{
						 alert("กรุณาป้อน จำนวนเงิน");
						document.frm1.vbudget_acti.focus();
						return false;
						}
				else
						{ 
					if (confirm("ยืนยันต้องการบันทึก? \nDo you want to save?") == true){
		callfrm("?option=plan&task=planproject/plan_addacti"); }return false;} //page ประมวลผล
			} // if(val==1)
} //goto_url_update(val)
</script>

${this.title}

Code Editor : plan_in_acti.php