<?php session_start();
//include('../../includes/connect.php');
include('../../includes/function_db.php');
//echo '0';
$dt = date('Y-m-d H:i:s');
$tbname = "students";
//print_r($_FILES);
function checkFileType($file, $allowType)
{
	$fileName = basename($_FILES[$file]['name']);
	$fileType = pathinfo($fileName, PATHINFO_EXTENSION);
	switch ($allowType) {
		case 'photo':
			$allow = array('jpg', 'jpeg', 'png', 'gif');
			break;
		case 'docutment':
			$allow = array('doc', 'docx', 'pdf');
			break;
		case 'word':
			$allow = array('doc', 'docx');
			break;
		case 'powerpoint':
			$allow = array('ptt', 'pttx');
			break;
		case 'excel':
			$allow = array('xls', 'xlsx');
			break;
		case 'pdf':
			$allow = array('pdf');
			break;;
	}
	if (in_array($allowType, $fileType)) {
		return 'true';
	} else {
		return 'false';
	}
}

$cdb = new control_db();
switch ($_POST['form_action']) {
		//แก้ไขข้อมูล
	case '2':
		$id = $_SESSION['login_id'];
		//print_r($_POST);

		if ($_FILES['photo']['error'] == '0') {
			$re = uploadFile('photo', '../../uploads/photo/', $id);
			$_POST['photo'] = $re['fileType'];
		}
		if ($_FILES['resume']['error'] == '0') {
			$re = uploadFile('resume', '../../uploads/resume/', $id);
			$_POST['resume'] = $re['fileType'];
		}
		unset($_POST['form_action'], $_POST['id']);
		if (isset($_POST['regularJob'])) {
			$_POST['regularJob'] = 1;
		} else {
			$_POST['regularJob'] = 0;
		}
		if (isset($_POST['parttime'])) {
			$_POST['parttime'] = 1;
		} else {
			$_POST['parttime'] = 0;
		}
		if (isset($_POST['freelance'])) {
			$_POST['freelance'] = 1;
		} else {
			$_POST['freelance'] = 0;
		}
		if (isset($_POST['train'])) {
			$_POST['train'] = 1;
		} else {
			$_POST['train'] = 0;
		}
		echo $cdb->update_data($tbname, $_POST, "id='$id'");
		break;
		// ลบข้อมูล
	case '3':
		$tbname = 'trainingHistory';
		echo $cdb->delete_data($tbname, "id='$_POST[id]'");
		break;
		// เช็ค url ซ้ำ
	case '4':
		/*
		unset($_POST['form_action'],$_POST['stamp'],$_POST['username']);
		$sql="select menu_url from menu where menu_url=:menu_url";
		$query=$cdb->conn->prepare($sql);
		try{
			$query->execute($_POST);
			$count = $query->rowCount();
			echo $count;
			}catch(PDOException $er){
			echo 'Error :'.$er->getMessage();
		}
		*/
		break;
		//ดึงข้อมูลเพื่อแก้ไขข้อมูล
	case '5':
		$param['id'] = $_SESSION['login_id'];

		$sql = "select * ";
		$sql .= " from $tbname ";
		$sql .= " where id=:id ";
		unset($_POST['form_action']);
		//print_r($_POST);
		$query = $cdb->conn->prepare($sql);
		try {
			$query->execute($param);
			$data = $query->fetch(PDO::FETCH_ASSOC);
			unset($data['password'], $data['createDate'], $data['status'], $data['updateDate']);
			foreach ($data as $key => $value) {
				if ($value == '') {
					$value = ' ';
				}
				$json_data[$key] = $value;
			}
		} catch (PDOException $er) {
			echo 'Error :' . $er->getMessage();
		}
		/*	$sql = "select * from trainingHistory where studentsID=:id ";
		$query = $cdb->conn->prepare($sql);
		try {
			$query->execute($param);
			$i = 1;
			$ar = array('createDate', 'studentsID');
			while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
				foreach ($data as $key => $value) {
					if (!in_array($key, $ar)) {
						$json_data[$key . '_' . $data['id']] = $value;
					}
				}
				++$i;
			}
		} catch (PDOException $er) {
			echo 'Error :' . $er->getMessage();
		}*/
		$sql = "select * from workHistory where studentsID=:id ";
		$query = $cdb->conn->prepare($sql);
		try {
			$query->execute($param);
			$i = 1;
			$ar = array('createDate', 'studentsID');
			while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
				foreach ($data as $key => $value) {
					if (!in_array($key, $ar)) {
						$json_data[$key . '_' . $data['id']] = $value;
					}
				}
				++$i;
			}
		} catch (PDOException $er) {
			echo 'Error :' . $er->getMessage();
		}
		$sql = "select * from education where studentsID=:id ";
		$query = $cdb->conn->prepare($sql);
		try {
			$query->execute($param);
			$i = 1;
			$ar = array('createDate', 'studentsID', 'updateDate');
			while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
				foreach ($data as $key => $value) {
					if (!in_array($key, $ar)) {
						$json_data[$key . '_' . $data['id']] = $value;
					}
				}
				++$i;
			}
		} catch (PDOException $er) {
			echo 'Error :' . $er->getMessage();
		}

		$json = json_encode($json_data);
		echo $json;

		break;
		//ดึงข้อมูลเพื่อแสดง
	case '6':
		//print_r($_POST);
		//ดึงข้อมูลหมวดหมู่
		$tbname = "trainingHistory";
		$no_field = array('page', 'qpage', 'form_action');
		$sql = "select * ";
		$sql .= " from $tbname where 1=1 ";
		$sql .= " and studentsID='$_SESSION[login_id]'";
		foreach ($_POST as $key => $value) {
			if (!in_array($key, $no_field)) {
				if ($value <> '') {
					$field = str_replace('s_', '', $key);
					$param[$field] = "%$value%";
					$sql .= " and $field like :$field ";
				}
			}
		}
		$sql .= " order by startYear desc ,startMon desc";
		//echo $sql;
		// คำนวณจำนวนหน้า	
		$query = $cdb->conn->prepare($sql);
		$query->execute($param);
		$count = $query->rowCount();
		$json_data['pagination']['max_data'] = $count;
		//คำนวณ record เริ่มต้น
		if ($_POST['page'] == 1) {
			$json_data['pagination']['state'] = 'แสดง 1 - ' . $_POST['qpage'] . ' จาก ' . number_format($count) . ' รายการ';
			$start = 0;
		} else {
			$start = ($_POST['page'] - 1) * $_POST['qpage'];
			$json_data['pagination']['state'] = 'แสดง ' . ($start + 1) . ' - ' . ($start + $_POST['qpage']) . ' จาก ' . number_format($count) . ' รายการ';
		}
		$json_data['pagination']['max_loop'] = ceil(($count / $_POST['qpage']));
		//
		$sql .= " limit $start,$_POST[qpage] ";
		//echo $sql;
		$query = $cdb->conn->prepare($sql);
		try {
			$query->execute($param);
			$count = $query->rowCount();
			$i = 1;
			while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
				foreach ($data as $key => $value) {
					//ดึงข้อหมวดหมู่
					if ($key == 'contentTypeID') {
						$json_data[$i]['name_type'] = $sjt[$value];
					}
					//จบข้อมูลหมวดหมู่
					$json_data[$i][$key] = $value;
				}
				++$i;
			}
		} catch (PDOException $er) {
			echo 'Error :' . $er->getMessage();
		}
		$json = json_encode($json_data);
		echo $json;
		break;

	case 'getDistrict':
		$sql = "select id,name_in_thai as title from districts where province_id='$_POST[id]'";
		//$json_data['sql'] = $sql;
		$query = $cdb->conn->prepare($sql);
		$query->execute();
		while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
			$json_data[$data['id']] = $data['title'];
		}
		//	print_r($json_data);
		echo json_encode($json_data);
		break;
	case 'getSubDistrict':
		$sql = "select id,name_in_thai as title from subdistricts where district_id='$_POST[id]'";
		$query = $cdb->conn->prepare($sql);
		$query->execute();
		while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
			$json_data[$data['id']] = $data['title'];
		}
		echo json_encode($json_data);
		break;
	case 'getZipcode':
		$sql = "select zip_code from subdistricts where id='$_POST[id]'";
		$query = $cdb->conn->prepare($sql);
		$query->execute();
		$data = $query->fetch(PDO::FETCH_ASSOC);
		//print_r($data);
		$json_data['zipcode'] = $data['zip_code'];
		echo json_encode($json_data);
		break;
	case 'getPosition':
		unset($_POST['form_action'], $_POST['username'], $_POST['stamp']);
		//print_r($_POST);
		$sql = "select id,title from subPositionType where positionTypeID=:id ";
		$query = $cdb->conn->prepare($sql);
		try {
			$query->execute($_POST);
			while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
				$json_data[$data['id']] = $data['title'];
			}
			echo json_encode($json_data);
		} catch (PDOException $er) {
			echo "Error : " . $er->getMessage();
		}
		break;
	case 'train':
		//print_r($_POST);
		$da = date('Y-m-d H:i:s');
		$param['studentsID'] = $_SESSION['login_id'];
		$param['createdate'] = $da;
		$param['stamp'] = time();
		//		$param['id'] = 1;
		unset($_POST['form_action']);
		foreach ($_POST as $key => $value) {
			$param[$key] = $value;
		}
		if ($_FILES['certificate']['error'] == '0') {
			$re = uploadFile('certificate', '../../uploads/certificate/', $param['studentsID'] . '_' . $param['stamp']);
			$param['certificate'] = $param['studentsID'] . '_' . $param['stamp'] . '.' . $re['fileType'];
			//$param['certificate'] = $re['fileType'];
		}
		//print_r($param);/*
		$re = $cdb->insert_data('trainingHistory', $param);
		//echo $re;
		if ($re == 0) {
			$json_data['result'] = 'true';
		} else {
			$json_data['result'] = 'false';
		}
		echo json_encode($json_data);
		//	print_r($param);*/
		break;
	case 'workHistory':
		//print_r($_POST);
		$da = date('Y-m-d H:i:s');
		$param['studentsID'] = $_SESSION['login_id'];
		$param2['studentsID'] = $_SESSION['login_id'];
		$param3['studentsID'] = $_SESSION['login_id'];
		$param4['studentsID'] = $_SESSION['login_id'];
		$param5['studentsID'] = $_SESSION['login_id'];
		$param['createdate'] = $da;
		$param2['createdate'] = $da;
		$param3['createdate'] = $da;
		$param4['createdate'] = $da;
		$param5['createdate'] = $da;
		$param['id'] = 1;
		$param2['id'] = 2;
		$param3['id'] = 3;
		$param4['id'] = 4;
		$param5['id'] = 5;

		unset($_POST['form_action']);
		foreach ($_POST as $key => $value) {
			if (strpos($key, '_1') > 0) {
				$param[str_replace('_1', '', $key)] = $value;
			}
			if (strpos($key, '_2') > 0) {
				$param2[str_replace('_2', '', $key)] = $value;
			}
			if (strpos($key, '_3') > 0) {
				$param3[str_replace('_3', '', $key)] = $value;
			}
			if (strpos($key, '_4') > 0) {
				$param4[str_replace('_4', '', $key)] = $value;
			}
			if (strpos($key, '_5') > 0) {
				$param5[str_replace('_5', '', $key)] = $value;
			}
		}

		$re = $cdb->replace_data('workHistory', $param);
		//echo $re;
		$cdb = new control_db();
		$re2 = $cdb->replace_data('workHistory', $param2);
		$cdb = new control_db();
		$re3 = $cdb->replace_data('workHistory', $param3);
		$cdb = new control_db();
		$re4 = $cdb->replace_data('workHistory', $param4);
		$cdb = new control_db();
		$re5 = $cdb->replace_data('workHistory', $param5);
		if ($re == 0 and $re2 == 0 and $re3 == 0 and $re4 == 0 and $re5 == 0) {
			$json_data['result'] = 'true';
		} else {
			$json_data['result'] = 'false';
		}
		echo json_encode($json_data);
		//print_r($param);
		break;
	case 'education':
		//print_r($_POST);
		$da = date('Y-m-d H:i:s');
		$param['studentsID'] = $_SESSION['login_id'];
		$param2['studentsID'] = $_SESSION['login_id'];
		$param3['studentsID'] = $_SESSION['login_id'];
		$param4['studentsID'] = $_SESSION['login_id'];
		$param5['studentsID'] = $_SESSION['login_id'];
		$param['createdate'] = $da;
		$param2['createdate'] = $da;
		$param3['createdate'] = $da;
		$param4['createdate'] = $da;
		$param5['createdate'] = $da;
		$param['id'] = 1;
		$param2['id'] = 2;
		$param3['id'] = 3;
		$param4['id'] = 4;
		$param5['id'] = 5;

		unset($_POST['form_action']);
		foreach ($_POST as $key => $value) {
			if (strpos($key, '_1') > 0) {
				$param[str_replace('_1', '', $key)] = $value;
			}
			if (strpos($key, '_2') > 0) {
				$param2[str_replace('_2', '', $key)] = $value;
			}
			if (strpos($key, '_3') > 0) {
				$param3[str_replace('_3', '', $key)] = $value;
			}
			if (strpos($key, '_4') > 0) {
				$param4[str_replace('_4', '', $key)] = $value;
			}
			if (strpos($key, '_5') > 0) {
				$param5[str_replace('_5', '', $key)] = $value;
			}
		}

		$re = $cdb->replace_data('education', $param);
		//echo $re;
		$cdb = new control_db();
		$re2 = $cdb->replace_data('education', $param2);
		$cdb = new control_db();
		$re3 = $cdb->replace_data('education', $param3);
		$cdb = new control_db();
		$re4 = $cdb->replace_data('education', $param4);
		$cdb = new control_db();
		$re5 = $cdb->replace_data('education', $param5);
		if ($re == 0 and $re2 == 0 and $re3 == 0 and $re4 == 0 and $re5 == 0) {
			$json_data['result'] = 'true';
		} else {
			$json_data['result'] = 'false';
		}
		echo json_encode($json_data);
		//print_r($param);
		break;
}