<?php 
session_start();
include ("Connections/config.php");
 //kpiYearITA
 if (isset($_POST['function']) && $_POST['function'] == 'kpiYearITA') {
	$id = $_POST['id'];
 	 $sql="SELECT ita_kpi.kpiID,ita_kpi.kpiYear,ita_kpi.kpiNo,ita_kpi.kpiName,ita_subkpi.skpiID,ita_subkpi.skpiNo,ita_subkpi.skpiName
				FROM ita_kpi
				Inner Join ita_subkpi ON ita_kpi.kpiID = ita_subkpi.kpiID
				where  ita_kpi.kpiYear='$id' 
				order by skpiNo+0 ";
	echo '<option value="" selected disabled>ตัวชี้วัดย่อย</option>';
	foreach ($db->dbSearch($sql) as $i=>$arr) {
		echo "<option  value=\"$arr[skpiID]\">$arr[skpiName]</option>";
	}
} //kpiYearITA

  //skpiIDITA
 if (isset($_POST['function']) && $_POST['function'] == 'skpiIDITA') {
	$id = $_POST['id'];
	$sql ="SELECT ita_subno.itasID,ita_subno.itasNo,ita_subno.itasName,ita_subno.itaID,ita_no.itaNo,ita_no.itaName,ita_no.skpiID,ita_subkpi.kpiID
			,ita_subkpi.skpiNo,ita_subkpi.skpiName,ita_kpi.kpiYear,ita_kpi.kpiNo,ita_kpi.kpiName
			FROM ita_subno
			Inner Join ita_no ON ita_subno.itaID = ita_no.itaID
			Inner Join ita_subkpi ON ita_no.skpiID = ita_subkpi.skpiID
			Inner Join ita_kpi ON ita_subkpi.kpiID = ita_kpi.kpiID
			where  ita_no.skpiID='$id' 
			order by ita_subno.itasNo+0 ";
	echo '<option value="" selected disabled>ITA</option>';
	foreach ($db->dbSearch($sql) as $i=>$arr) {
		echo "<option  value=\"$arr[itasID]\">$arr[itasNo] $arr[itasName]  </option>";
	}
} //skpiIDITA
		 
//provinces
 if (isset($_POST['function']) && $_POST['function'] == 'provinces') {
	$id = $_POST['id'];
  	$sql = "SELECT * FROM amphures WHERE province_id='$id'";
	echo '<option value="" selected disabled>-เลือกอำเภอ-</option>';
	foreach ($db->dbSearch($sql) as $i=>$arr) {
		echo "<option value=\"$arr[amphure_id]\">$arr[amphure_name_th]</option>";
	}
} //provinces

//amphures
if (isset($_POST['function']) && $_POST['function'] == 'amphures') {
	$id = $_POST['id'];
  	 $sql = "SELECT * FROM districts WHERE amphure_id='$id'";
	echo '<option value="" selected disabled>-เลือกตำบล-</option>';
	foreach ($db->dbSearch($sql) as $i=>$arr) {
		echo "<option value=\"$arr[district_id]\">$arr[district_name_th]</option>";
	}
} //amphures

//zip_code
 if (isset($_POST['function']) && $_POST['function'] == 'districts') {
    $id = $_POST['id'];
    $sql = "SELECT * FROM districts WHERE district_id='$id'";
 	$arr=$db->getRec($sql);		
     echo $arr['zip_code'];
	 exit();
  }
  //zip_code
 
 //สมาชิก
  //RegistDistrict_id
 if (isset($_POST['function']) && $_POST['function'] == 'RegistDistrict_id') {
	$id = $_POST['id'];
 	$sql2 ="select village.* from village  WHERE district_id='$id' order by vMoo ";   
	echo '<option value="" selected disabled>เลือกหมู่บ้าน</option>';
	foreach ($db->dbSearch($sql2) as $i=>$arr2) {
		if($arr2[vID]==$arrE[vID]){$se=" selected"; }else{$se="";}
		echo "<option  value=\"$arr2[vID]\" $se>หมู่ที่ $arr2[vMoo] $arr2[vName]</option>";
	}
 } //RegistDistrict_id

 //provinces2
 if (isset($_POST['function']) && $_POST['function'] == 'provinces2') {
	$id = $_POST['id'];
  	$sql = "SELECT * FROM amphures WHERE province_id='$id'";
	echo '<option value="" selected disabled>-เลือกอำเภอ-</option>';
	foreach ($db->dbSearch($sql) as $i=>$arr) {
		echo "<option value=\"$arr[amphure_id]\">$arr[amphure_name_th]</option>";
	}
} //provinces

//amphures2
if (isset($_POST['function']) && $_POST['function'] == 'amphures2') {
	$id = $_POST['id'];
  	 $sql = "SELECT * FROM districts WHERE amphure_id='$id'";
	echo '<option value="" selected disabled>-เลือกตำบล-</option>';
	foreach ($db->dbSearch($sql) as $i=>$arr) {
		echo "<option value=\"$arr[district_id]\">$arr[district_name_th]</option>";
	}
} //amphures

//zip_code2
 if (isset($_POST['function']) && $_POST['function'] == 'districts2') {
    $id = $_POST['id'];
    $sql = "SELECT * FROM districts WHERE district_id='$id'";
 	$arr=$db->getRec($sql);		
     echo $arr['zip_code'];
	 exit();
  }
  //zip_code
   //สมาชิก
 
  Function ShowAllDate($c_date,$Stype){
	if(!empty($c_date) and $c_date!="0000-00-00" and strlen($c_date)>0){
		$ShortCMonthT=array("","ม.ค.","ก.พ.","มี.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค."); 	$MonthT=array("","มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฏาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม"); 
		
		if($Stype==1){//เปลี่ยนเป็นแบบไทยเดือนย่อ
			$Cdd=trim(Substr($c_date,8,2));
			$Cmm=Substr($c_date,5,2);
			$Cyy=trim(Substr($c_date,0,4))+543;	
			$Cmm=$Cmm+0;
			$ShowCdate="$Cdd  $ShortCMonthT[$Cmm]  $Cyy";	
		} 
		if($Stype==2){ //เปลี่ยนเป็นแบบไทยเดือนเต็ม
			$Cdd=trim(Substr($c_date,8,2));
			$Cmm=Substr($c_date,5,2);
			$Cyy=trim(Substr($c_date,0,4))+543;	
			$Cmm=$Cmm+0;
			$ShowCdate="$Cdd  $MonthT[$Cmm]  $Cyy";	
		} 
		if($Stype==3){ //เปลียนเป็นแบบ dd-mm-yyyy
			$Cdd=trim(Substr($c_date,8,2));
			$Cmm=Substr($c_date,5,2);
			$Cyy=trim(Substr($c_date,0,4))+543;	
			$ShowCdate="$Cdd-$Cmm-$Cyy";	
		}
		if($Stype==4){ //เปลียนเป็นแบบ dd/mm/yyyy
			$Cdd=trim(Substr($c_date,8,2));
			$Cmm=Substr($c_date,5,2);
			$Cyy=trim(Substr($c_date,0,4))+543;	
			$ShowCdate="$Cdd/$Cmm/$Cyy";	
		}
		if($Stype==5){ //เปลียนเป็นแบบ yyyy/mm/dd
			$Cdd=Substr($c_date,0,2);	
			$Cmm=Substr($c_date,3,2);	
			$Cyy=Substr($c_date,6,4)-543;
			$ShowCdate="$Cyy-$Cmm-$Cdd";	
		}
		if($Stype==6){ //เปลียนเป็นแบบ yyyy/mm/dd
			$Cdd=trim(Substr($c_date,8,2));
			$Cmm=Substr($c_date,5,2);
			$Cyy=trim(Substr($c_date,0,4));	
			$ShowCdate="$Cdd/$Cmm/$Cyy";	
		}	
		if($Stype==7){ //แสดงเดือน
			$ShowCdate=$MonthT[$c_date];	
		}	
		if($Stype==8){//เปลี่ยนเป็นแบบไทยเดือนย่อ
			$Cdd=trim(Substr($c_date,8,2));
			$Cmm=Substr($c_date,5,2);
			$Cyy=substr(trim(Substr($c_date,0,4))+543,2,2);	
			$Cmm=$Cmm+0;
			$ShowCdate="$Cdd  $ShortCMonthT[$Cmm]  $Cyy";	
		} 
		if($Stype==9){ //เปลียนเป็นแบบ yyyy/mm/dd
			$Cdd=Substr($c_date,0,2);	
			$Cmm=Substr($c_date,3,2);	
			$Cyy=Substr($c_date,6,4);
			$ShowCdate="$Cyy-$Cmm-$Cdd";	
		}
	}
	 return $ShowCdate;
}
?>