Gecko [ 122.154.134.11 ]

Name	Size	Permission
images	[ DIR ]	drwxr-xr-x
index.php	994 B	-rw-r--r--
report2.php	9.24 KB	-rw-r--r--
report4.php	11.79 KB	-rw-r--r--
search.php	19.94 KB	-rw-r--r--
search2.php	19.94 KB	-rw-r--r--
search3.php	19.86 KB	-rw-r--r--
search_insert.php	17.4 KB	-rw-r--r--

Code Editor : search_insert.php

<?php

@ini_set('display_errors', '0');
if(!(isset($_POST['index']))){
$index="";
}
else{
$index=$_POST['index'];
}

if($index==1){
$study_school="";  
$be_under="";
$study_class="";
$sch_location="";
$cause="";
$in_out_area="";
		if($_POST['entered']==1){

if($_POST['enter_school']==11){
				$study_school=$_REQUEST['remote_user_office'];
				$be_under='1';
				$sqk=$sql = "select  classlevel from  student_main_main where person_id='$_POST[person_id]'";
				}
				else{
				$study_school=$_POST['sch_name'];
				$study_class=$_POST['study_class'];
							if($_POST['enter_school']==12){
							$be_under='1';
							$in_out_area='1';
							}
							else if($_POST['enter_school']==13){
							$be_under='2';
							$in_out_area='1';
							}
							else if($_POST['enter_school']==14){
							$be_under='3';
							$in_out_area='1';
							}
							else if($_POST['enter_school']==15){
							$be_under='4';
							$in_out_area='1';
							}
							else if($_POST['enter_school']==16){
							$be_under='1';
							$in_out_area='2';
							}
							else if($_POST['enter_school']==17){
							$be_under='2';
							$in_out_area='2';
							}
							else if($_POST['enter_school']==18){
							$be_under='3';
							$in_out_area='2';
							}
							else if($_POST['enter_school']==19){
							$be_under='4';
							$in_out_area='2';
							}
				$sch_location=$_POST['sch_location'];		
				}
		}
		else if($_POST['entered']==2){
		$cause=$_POST['cause'];
		}
		
$sql_edyear ="SELECT ed_year FROM student_main_edyear where year_active='1' ";
$dbquery_edyear= mysqli_query($connect,$sql_edyear);
$result_edyear = mysqli_fetch_array($dbquery_edyear);
$ed_year=$result_edyear['ed_year'];
$table="opportunity_search".$ed_year;  //ตารางแต่ละปีการศึกษา

$rec_date = date("Y-m-d");

$sql ="SELECT person_id FROM $table where person_id='$_POST[person_id]' "; 
$dbquery = mysqli_query($connect,$sql);
if($result= mysqli_fetch_array($dbquery)){
$sql = "update $table set  school_code='$_REQUEST[remote_user_office]', 
person_id='$_POST[person_id]',
status='$_POST[entered]', 
study_school='$study_school', 
be_under='$be_under', 
in_out_area='$in_out_area', 
study_class='$study_class', 
school_location='$sch_location', 
cause='$cause', 
rec_date='$rec_date', 
officer='$_REQUEST[login_user_id]' where person_id='$_POST[person_id]' ";
$dbquery = mysqli_query($connect,$sql);
}
else{
$sql = "insert into $table (school_code,person_id,status,study_school,be_under,in_out_area,study_class,school_location,cause,rec_date,officer) values ('$_REQUEST[remote_user_office]','$_POST[person_id]','$_POST[entered]','$study_school','$be_under','$in_out_area','$study_class','$sch_location','$cause','$rec_date','$_REQUEST[login_user_id]')";
$dbquery = mysqli_query($connect,$sql);
}
	if($_POST['file_index']==1){
	$file="search";
	}
	else if($_POST['file_index']==2){
	$file="search2";
	}
	else if($_POST['file_index']==3){
	$file="search3";
	}
	else{
	$file="search";
	}

echo "<script>document.location.href='?file=$file&page=$_POST[page]&remote_user_office=$_REQUEST[remote_user_office]&remote_user_id=$_REQUEST[remote_user_id]&remote_login_status=$_REQUEST[remote_login_status]&remote_sync=$_REQUEST[remote_sync]';</script>\n";
}  // end if index==1

require_once "../../../amssplus_connect.php";

$sql_edyear ="SELECT ed_year FROM student_main_edyear where year_active='1' ";
$dbquery_edyear= mysqli_query($connect,$sql_edyear);
$result_edyear = mysqli_fetch_array($dbquery_edyear);
$ed_year=$result_edyear['ed_year'];
$table="opportunity_search".$ed_year;  //ตารางแต่ละปีการศึกษา

$sql ="SELECT * FROM $table where person_id='$_GET[person_id]' "; 
$dbquery = mysqli_query($connect,$sql);
$result= mysqli_fetch_array($dbquery);
$status=$result['status'];  
$study_school=$result['study_school'];
$in_out_area=$result['in_out_area'];
$be_under=$result['be_under'];
$study_class=$result['study_class'];
$sch_location=$result['school_location'];
$cause=$result['cause'];

?>
<script>
e_show2(<?php echo $status; ?>);
</script>
<?php

echo "</br>";
echo "<form id='frm2' name='frm2' action='?file=search_insert&index=1' method=post>";
echo "<Center>";
$sql ="SELECT * FROM opportunity_population where person_id='$_GET[person_id]'";
$dbquery = mysqli_query($connect,$sql);
$result_sch = mysqli_fetch_array($dbquery);
$prename= $result_sch['prename'];
$name= $result_sch['name'];
$surname= $result_sch['surname'];
$prename_text="";
if($prename=="001"){
$prename_text="เด็กชาย";
}
else if($prename=="002"){
$prename_text="เด็กหญิง";
}
else if($prename=="003"){
$prename_text="นาย";
}
else if($prename=="004"){
$prename_text="นางสาว";
}

echo "<Font color='#006666' Size='3'><B>$prename_text$name  $surname</B></Font>";
echo "</Cener>";
echo "<Br><Br>";
echo "<Table  width='100%'  align='center' border='0' bgcolor='#FFFF66'>";
echo "<Tr align='left'><Td align='right' width='40%'>เข้าเรียน&nbsp;&nbsp;</Td><Td><Input Type='radio' Name='entered'  id='entered_1' value='1' onclick='e_show()'></Td></Tr>";
echo "<Tr align='left'><Td align='right'>ไม่เข้าเรียน&nbsp;&nbsp;</Td><Td><Input Type='radio' Name='entered'  id='entered_2' value='2' onclick='e_show()'></Td></Tr>";
echo "</Table>";
echo "<br>";
echo "<span id='cause' style='display:none' align='center'>";
$cause_check1="";
$cause_check2="";
$cause_check3="";
$cause_check4="";
$cause_check5="";
$cause_check6="";
$cause_check7="";
$cause_check8="";
$cause_check9="";
if($cause==21){
$cause_check1="checked";
}
else if($cause==22){
$cause_check2="checked";
}
else if($cause==23){
$cause_check3="checked";
}
else if($cause==24){
$cause_check4="checked";
}
else if($cause==25){
$cause_check5="checked";
}
else if($cause==26){
$cause_check6="checked";
}
else if($cause==27){
$cause_check7="checked";
}
else if($cause==28){
$cause_check8="checked";
}
else if($cause==29){
$cause_check9="checked";
}

echo "<Table width='75%'  align='center' border='0'>";
echo "<tr bgcolor='#FFFF66'><td align='center'>สาเหตุที่ไม่เข้าเรียน</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='cause'  id='cause_1' value='21' $cause_check1>ไม่พบตัวตนในพื้นที่</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='cause'  id='cause_2'  value='22' $cause_check2>ตาย</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='cause'  id='cause_3'  value='23' $cause_check3>พิการหรือเจ็บป่วยรุนแรง</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='cause'  id='cause_4'  value='24' $cause_check4>ย้ายออกนอกเขตพื้นที่</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='cause'  id='cause_5'  value='25' $cause_check5>ขาดแคลน ยากจนมากต้องหารายได้เลี้ยงครอบครัว</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='cause'  id='cause_6'  value='26' $cause_check6>สมรส</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='cause'  id='cause_7'  value='27' $cause_check7>ถูกดำเนินคดีหรืออยู่ในสถานพินิจ</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='cause'  id='cause_8'  value='28' $cause_check8>ไม่ต้องการมาเรียน</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='cause'  id='cause_9'  value='29' $cause_check9>สาเหตุอื่น ๆ</td></tr>";
echo "</table>";
echo "</span>";

echo "<span id='enter_sch' style='display:none' align='center'>";
$enter_school_check2="";
$enter_school_check3="";
$enter_school_check4="";
$enter_school_check5="";
$enter_school_check6="";
$enter_school_check7="";
$enter_school_check8="";
$enter_school_check9="";
if($be_under==12){
$cause_check1="checked";
}
else if($cause==22){
$cause_check2="checked";
}

$enter_check_12="";
$enter_check_13="";
$enter_check_14="";
$enter_check_15="";
$enter_check_16="";
$enter_check_17="";
$enter_check_18="";
$enter_check_19="";

if($in_out_area==1){
		if($be_under==1){
		$enter_check_12="checked";
		}
		else if($be_under==2){
		$enter_check_13="checked";
		}
		else if($be_under==3){
		$enter_check_14="checked";
		}
		else if($be_under==4){
		$enter_check_15="checked";
		}
}
else if($in_out_area==2){
		if($be_under==1){
		$enter_check_16="checked";
		}
		else if($be_under==2){
		$enter_check_17="checked";
		}
		else if($be_under==3){
		$enter_check_18="checked";
		}
		else if($be_under==4){
		$enter_check_19="checked";
		}
}

echo "<Table width='75%'  align='center' border='0'>";
echo "<tr><td align='left' bgcolor='#FFFF66'>โรงเรียนอื่น ๆ ในเขตพื้นที่การศึกษานี้</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='enter_school'  id='enter_school_2' value='12' $enter_check_12>สังกัด สพป.อบ.4</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='enter_school'  id='enter_school_3' value='13' $enter_check_13>โรงเรียนเอกชน</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='enter_school'  id='enter_school_4' value='14' $enter_check_14>สังกัดท้องถิ่น(อปท.)</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='enter_school'  id='enter_school_5' value='15' $enter_check_15>สังกัดอื่น ๆ</td></tr>";
echo "<tr><td align='left' bgcolor='#FFFF66'>โรงเรียนอื่น ๆ เขตพื้นที่การศึกษาอื่น ๆ</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='enter_school'  id='enter_school_6' value='16' $enter_check_16>สังกัด สพฐ.</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='enter_school'  id='enter_school_7' value='17' $enter_check_17>โรงเรียนเอกชน</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='enter_school'  id='enter_school_8' value='18' $enter_check_18>สังกัดท้องถิ่น(อปท.)</td></tr>";
echo "<tr><td align='left'><Input Type='radio' Name='enter_school'  id='enter_school_9' value='19' $enter_check_19>สังกัดอื่น ๆ</td></tr>";
echo "</table>";
echo "</span>";
echo "<br>";

echo "<span id='enter_sch2' style='display:none' align='center'>";
echo "<Table width='90%'  align='center' border='0' bgcolor='#FFFF66'>";
echo "<Tr align='left'><Td align='right'>ระบุชื่อโรงเรียน&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='sch_name'  id='sch_name'  Size='40' value='$study_school'></Td></Tr>";
echo "<Tr align='left'><Td align='right'>ชั้น&nbsp;&nbsp;</Td>";
$select_1=""; $select_2=""; $select_3=""; $select_4=""; $select_5=""; $select_6=""; $select_7=""; $select_8="";
$select_9=""; $select_10=""; $select_11=""; $select_12=""; $select_13=""; $select_14=""; $select_15="";
if($study_class==1){
$select_1="selected";
}
else if($study_class==2){
$select_2="selected";
}
else if($study_class==3){
$select_3="selected";
}
else if($study_class==4){
$select_4="selected";
}
else if($study_class==5){
$select_5="selected";
}
else if($study_class==6){
$select_6="selected";
}
else if($study_class==7){
$select_7="selected";
}
else if($study_class==8){
$select_8="selected";
}
else if($study_class==9){
$select_9="selected";
}
else if($study_class==10){
$select_10="selected";
}
else if($study_class==11){
$select_11="selected";
}
else if($study_class==12){
$select_12="selected";
}
else if($study_class==13){
$select_13="selected";
}
else if($study_class==14){
$select_14="selected";
}
else if($study_class==15){
$select_15="selected";
}

echo "<td><div align='left'><Select  name='study_class'  size='1'>";
echo  "<option  value = ''>เลือก</option>" ;
		echo  "<option value = '1' $select_1>อนุบาล1</option>" ;
		echo  "<option value = '2' $select_2>อนุบาล2</option>" ;
		echo  "<option value = '3' $select_3>อนุบาล3</option>" ;
		echo  "<option value = '4' $select_4>ป.1</option>" ;
		echo  "<option value = '5' $select_5>ป.2</option>" ;
		echo  "<option value = '6' $select_6>ป.3</option>" ;
		echo  "<option value = '7' $select_7>ป.4</option>" ;
		echo  "<option value = '8' $select_8>ป.5</option>" ;
		echo  "<option value = '9' $select_9>ป.6</option>" ;
		echo  "<option value = '10' $select_10>ม.1</option>" ;
		echo  "<option value = '11' $select_11>ม.2</option>" ;
		echo  "<option value = '12' $select_12>ม.3</option>" ;
		echo  "<option value = '13' $select_13>ม.4</option>" ;
		echo  "<option value = '14' $select_14>ม.5</option>" ;
		echo  "<option value = '15' $select_15>ม.6</option>" ;
echo " </select>";
echo " * ถ้าหากระบุได้</div></td></tr>";
echo "<Tr align='left'><Td align='right'>ระบุที่ตั้งโรงเรียน<br>(ตำบล อำเภอ จังหวัด)&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='sch_location'  id='sch_location'  Size='40' value='$sch_location'></Td></Tr>";
echo "</table>";
echo "</span>";
echo "<INPUT TYPE='hidden' name='person_id' value='$_GET[person_id]'>";
echo "<INPUT TYPE='hidden' name='index' value='1'>";
echo "<INPUT TYPE='hidden' name='page' value='$_GET[page]'>";
echo "<INPUT TYPE='hidden' name='file_index' value='$_GET[file_index]'>";

echo "<input type='hidden' name='remote_user_office' value='$_REQUEST[remote_user_office]'>";
		echo "<input type='hidden' name='remote_user_id' value='$_REQUEST[remote_user_id]'>";
		echo "<input type='hidden' name='remote_login_status' value='$_REQUEST[remote_login_status]'>";
		echo "<input type='hidden' name='remote_sync' value='$_REQUEST[remote_sync]'>";

echo "<INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url(1)'>";
echo "</form>";

?>
<script>
function e_show(){
		if(document.getElementById("entered_1").checked){
		$('input[name=cause]').attr('checked',false);
		document.getElementById("cause").style.display="none";
		document.getElementById("enter_sch").style.display="block";
		document.getElementById("enter_sch2").style.display="block";	
		}
		if(document.getElementById("entered_2").checked){
		document.getElementById("cause").style.display="block";
		document.getElementById("enter_sch").style.display="none";
		$('input[name=enter_school]').attr('checked',false);
		document.getElementById("sch_name").value="";
		document.getElementById("sch_location").value="";
		document.getElementById("enter_sch2").style.display="none";
		}
}

function callfrm()
	{
		frm2.target = "_self";
		frm2.method = "POST";
		document.getElementById("frm2").submit();
 	}	
</script>

${this.title}

Code Editor : search_insert.php