Gecko [ 122.154.134.11 ]

Name	Size	Permission
asset.php	89.73 KB	-rw-r--r--
asset_budget_type.php	6.99 KB	-rw-r--r--
asset_building.php	7.37 KB	-rw-r--r--
asset_code_model.php	7.75 KB	-rw-r--r--
asset_company.php	9.95 KB	-rw-r--r--
asset_form_upload.php	4.74 KB	-rw-r--r--
asset_list.php	12.23 KB	-rw-r--r--
asset_method.php	6.91 KB	-rw-r--r--
asset_notification.php	38.37 KB	-rw-r--r--
asset_permission.php	13.12 KB	-rw-r--r--
asset_print.php	9.88 KB	-rw-r--r--
asset_print1.php	8.43 KB	-rw-r--r--
asset_print_lend.php	3.49 KB	-rw-r--r--
asset_print_lend1.php	9.59 KB	-rw-r--r--
asset_print_lend2.php	8.85 KB	-rw-r--r--
asset_print_lendAll.php	3.27 KB	-rw-r--r--
asset_print_lendAll1.php	9.84 KB	-rw-r--r--
asset_print_qrcode.php	10.28 KB	-rw-r--r--
asset_print_qrcode1.php	1.45 KB	-rw-r--r--
asset_report1.php	20 KB	-rw-r--r--
asset_report23.php	20.09 KB	-rw-r--r--
asset_report4.php	19.76 KB	-rw-r--r--
asset_report_to_excell.php	6.54 KB	-rw-r--r--
asset_set.php	8.43 KB	-rw-r--r--
asset_status3.php	85.25 KB	-rw-r--r--
asset_status40.php	85.27 KB	-rw-r--r--
asset_type.php	9.5 KB	-rw-r--r--
index.php	5.76 KB	-rw-r--r--
livesearch.php	2.11 KB	-rw-r--r--
livesearch_notification.php	954 B	-rw-r--r--
manual.php	1.38 KB	-rw-r--r--

Code Editor : asset_code_model.php

echo "<br />";

echo "<center><font color='#006666' size='3'><strong>รูปแบบรหัสทรัพย์สินของ สพท.</strong></font><br>
	กำหนดครั้งแรกเมื่อเริ่มใช้งานเท่านั้น
	</center>";

//ส่วนปรับปรุงข้อมูล
if ($index==6){
$sql = "select * from asset_code_model";
$dbquery = mysqli_query($connect,$sql);
$sql = "update asset_code_model set code_0='$_POST[code_0]', code_1='$_POST[code_1]', code_2='$_POST[code_2]', code_3='$_POST[code_3]', code_4='$_POST[code_4]' ";
$dbquery = mysqli_query($connect,$sql);
}

//ส่วนการแสดงผล
$sql = "select * from asset_code_model";
$dbquery = mysqli_query($connect,$sql);
$result = mysqli_fetch_array($dbquery);

echo "<form id='frm1' name='frm1'>";
echo "<Center>";
echo "<br>";
echo "<table class='myTableGreen'>";
echo "<tr>";
	echo "<th></th>";
	echo "<th>ตัวคั่น</th>";
	echo "<th>รหัสชุดที่ 1</th>";
	echo "<th>รหัสชุดที่ 2</th>";
	echo "<th>รหัสชุดที่ 3</th>";
	echo "<th>รหัสชุดที่ 4</th>";
echo "</tr>";
echo "<tr>";
	echo "<th width=35%>เลือกกำหนดรูปแบบ</th>";
	//ตัวคั่น
	$code0_c_array=array(" ", "/", "-", ".", ",", ":", ";");
	$code0_n_array=array("เว้นวรรค", "ทับ (/)", "ยัติภังค์ (-)", "มหัพภาค (.)", "จุลภาค (,)", "ทวิภาค (:)", "อัฒภาค (;)");
	echo "<td align='center'>";
		echo "<select name='code_0' id='code_0'>";
		for($i=0; $i<count($code0_c_array); $i++){
			if($result[code_0]==$code0_c_array[$i]){
				echo "<option value='$code0_c_array[$i]' selected>$code0_n_array[$i]</option>";
			}else{
				echo "<option value='$code0_c_array[$i]'>$code0_n_array[$i]</option>";
			}
		}
		echo "</select>";
	echo "</td>";
	//ชุดที่ 1
	$code_c_array=array("code_no", "code_type", "code_list", "code_short_year", "code_long_year");
	$code_n_array=array("ลำดับที่", "ประเภททรัพย์สิน", "รายการทรัพย์สิน", "ปีงบประมาณ-แบบย่อ", "ปีงบประมาณ-แบบเต็ม");
	echo "<td align='center'>";
		echo "<select name='code_1' id='code_1'>";
		echo "<option value=''>ไม่กำหนด</option>";
		for($i=0; $i<count($code_c_array); $i++){
			if($result[code_1]==$code_c_array[$i]){
				echo "<option value='$code_c_array[$i]' selected>$code_n_array[$i]</option>";
			}else{
				echo "<option value='$code_c_array[$i]'>$code_n_array[$i]</option>";
			}
		}
		echo "</select>";
	echo "</td>";
	//ชุดที่ 2
	echo "<td align='center'>";
		echo "<select name='code_2' id='code_2'>";
		echo "<option value=''>ไม่กำหนด</option>";
		for($i=0; $i<count($code_c_array); $i++){
			if($result[code_2]==$code_c_array[$i]){
				echo "<option value='$code_c_array[$i]' selected>$code_n_array[$i]</option>";
			}else{
				echo "<option value='$code_c_array[$i]'>$code_n_array[$i]</option>";
			}
		}
		echo "</select>";
	echo "</td>";
	echo "<td align='center'>";
		echo "<select name='code_3' id='code_3'>";
		echo "<option value=''>ไม่กำหนด</option>";
		for($i=0; $i<count($code_c_array); $i++){
			if($result[code_3]==$code_c_array[$i]){
				echo "<option value='$code_c_array[$i]' selected>$code_n_array[$i]</option>";
			}else{
				echo "<option value='$code_c_array[$i]'>$code_n_array[$i]</option>";
			}
		}
		echo "</select>";
	echo "</td>";
	echo "<td align='center'>";
		echo "<select name='code_4' id='code_4'>";
		echo "<option value=''>ไม่กำหนด</option>";
		for($i=0; $i<count($code_c_array); $i++){
			if($result[code_4]==$code_c_array[$i]){
				echo "<option value='$code_c_array[$i]' selected>$code_n_array[$i]</option>";
			}else{
				echo "<option value='$code_c_array[$i]'>$code_n_array[$i]</option>";
			}
		}
		echo "</select>";
	echo "</td>";
echo "</tr>";
echo "</table>";
	switch ($result[code_1]){
		case 'code_no': $code_1='002'; break;		case 'code_type': $code_1='001'; break;	case 'code_list': $code_1='004'; break;
		case 'code_short_year': $code_1='61'; break;  case 'code_long_year': $code_1='2561'; break;
	}
	switch ($result[code_2]){
		case 'code_no': $code_2='002'; break;		case 'code_type': $code_2='001'; break;	case 'code_list': $code_2='004'; break;
		case 'code_short_year': $code_2='61'; break;  case 'code_long_year': $code_2='2561'; break;
	}
	switch ($result[code_3]){
		case 'code_no': $code_3='002'; break;		case 'code_type': $code_3='001'; break;	case 'code_list': $code_3='004'; break;
		case 'code_short_year': $code_3='61'; break;  case 'code_long_year': $code_3='2561'; break;
	}
	switch ($result[code_4]){
		case 'code_no': $code_4='002'; break;		case 'code_type': $code_4='001'; break;	case 'code_list': $code_4='004'; break;
		case 'code_short_year': $code_4='61'; break;  case 'code_long_year': $code_4='2561'; break;
	}

if(($result[code_4]=='') and ($result[code_3]=='')){
//		$asset_code_model="$".$result[code_1].''.$result[code_0].'$'.$result[code_2];
		$asset_code_model=$code_1.''.$result[code_0].''.$code_2;
	}else if($result[code_4]==''){
//		$asset_code_model="$".$result[code_1].''.$result[code_0].'$'.$result[code_2].''.$result[code_0].'$'.$result[code_3];
		$asset_code_model=$code_1.''.$result[code_0].''.$code_2.''.$result[code_0].''.$code_3;
	}else{
//		$asset_code_model='$'.$result[code_1].''.$result[code_0].'$'.$result[code_2].''.$result[code_0].'$'.$result[code_3].''.$result[code_0].'$'.$result[code_4];
		$asset_code_model=$code_1.''.$result[code_0].''.$code_2.''.$result[code_0].''.$code_3.''.$result[code_0].''.$code_4;
	}
	echo "<br>";
	echo "<b>ตัวอย่าง</b> รูปแบบรหัสทรัพย์สินที่ สพท.กำหนด";
	echo "<h4><font color=blue>".$asset_code_model."</font></h4>";
	echo "<input type='hidden' name='asset_code_model' value='$asset_code_model'>";
	echo "<INPUT TYPE='button' name='smb' value='บันทึก' onclick='goto_url_update(1)' class=entrybutton>";
echo "</form>";
echo "<table>";
	echo "<tr><td><b>หมายเหตุ </b></td><td></td><td></td></tr>";
	echo "<tr bgcolor='#d5ffd5'><td>รหัสชุด</td><td>ข้อมูลตัวอย่าง</td><td></td></tr>";
	echo "<tr><td>ลำดับที่ &nbsp;&nbsp;</td><td align=right bgcolor='#d5ffd5'>002</td><td></td></tr>";
	echo "<tr><td>ประเภททรัพย์สิน &nbsp;&nbsp;</td><td align=right bgcolor='#d5ffd5'>001</td><td>&nbsp; (อาคารถาวร)</td></tr>";
	echo "<tr><td>รายการทรัพย์สิน &nbsp;&nbsp;</td><td align=right bgcolor='#d5ffd5'>004</td><td>&nbsp; (สำนักงาน)</td></tr>";
	echo "<tr><td>ปีงบประมาณ-แบบย่อ &nbsp;&nbsp;</td><td align=right bgcolor='#d5ffd5'>61</td></tr>";
	echo "<tr><td>ปีงบประมาณ-แบบเต็ม &nbsp;&nbsp;</td><td align=right bgcolor='#d5ffd5'>2561</td></tr>";
echo "</table>";

?>
<script>
function goto_url_update(val){
	if(val==0){
		callfrm("javascript:history.back(-1)");   // page ย้อนกลับ 
	}else if(val==1){
		callfrm("?option=asset&task=main/asset_code_model&index=6");   //page ประมวลผล
	}
}
</script>

${this.title}

Code Editor : asset_code_model.php