<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1" charset="x-windows-874">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Tangerine">
<link type="text/css" href="css/ui-lightness/jquery-ui-1.8.10.custom.css" rel="stylesheet" />
<script type="text/javascript" src="js/jquery-1.4.4.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.8.10.offset.datepicker.min.js"></script>
<script type="text/javascript">
$(function () {
var d = new Date();
var toDay = d.getDate() + '/' + (d.getMonth() + 1) + '/' + (d.getFullYear() + 543);
// �óյ�ͧ�����軯ԷԹŧ��ҡ���� 1 �ѹ���˹�� ����������� Code ����÷Ѵ��ҹ��ҧ���¤�Ѻ (1 �ش = 1 ��ԷԹ)
$("#datepicker-th").datepicker({ dateFormat: 'dd/mm/yy', isBuddhist: true, defaultDate: toDay, dayNames: ['ÍÒ·ÔµÂì', '¨Ñ¹·Ãì', 'Íѧ¤ÒÃ', '¾Ø¸', '¾ÄËÑʺ´Õ', 'ÈØ¡Ãì', 'àÊÒÃì'],
dayNamesMin: ['ÍÒ.','¨.','Í.','¾.','¾Ä.','È.','Ê.'],
monthNames: ['Á¡ÃÒ¤Á','¡ØÁÀҾѹ¸ì','ÁÕ¹Ò¤Á','àÁÉÒ¹','¾ÄÉÀÒÁ¤Á','ÁԶعÒ¹','¡Ã¡®Ò¤Á','ÊÔ§ËÒ¤Á','¡Ñ¹ÂÒ¹','µØÅÒ¤Á','¾ÄȨԡÒ¹','¸Ñ¹ÇÒ¤Á'],
monthNamesShort: ['Á.¤.','¡.¾.','ÁÕ.¤.','àÁ.Â.','¾.¤.','ÁÔ.Â.','¡.¤.','Ê.¤.','¡.Â.','µ.¤.','¾.Â.','¸.¤.']});
$("#datepicker-th-2").datepicker({ changeMonth: true, changeYear: true,dateFormat: 'dd/mm/yy', isBuddhist: true, defaultDate: toDay,dayNames: ['ÍÒ·ÔµÂì', '¨Ñ¹·Ãì', 'Íѧ¤ÒÃ', '¾Ø¸', '¾ÄËÑʺ´Õ', 'ÈØ¡Ãì', 'àÊÒÃì'],
dayNamesMin: ['ÍÒ.','¨.','Í.','¾.','¾Ä.','È.','Ê.'],
monthNames: ['Á¡ÃÒ¤Á','¡ØÁÀҾѹ¸ì','ÁÕ¹Ò¤Á','àÁÉÒ¹','¾ÄÉÀÒÁ¤Á','ÁԶعÒ¹','¡Ã¡®Ò¤Á','ÊÔ§ËÒ¤Á','¡Ñ¹ÂÒ¹','µØÅÒ¤Á','¾ÄȨԡÒ¹','¸Ñ¹ÇÒ¤Á'],
monthNamesShort: ['Á.¤.','¡.¾.','ÁÕ.¤.','àÁ.Â.','¾.¤.','ÁÔ.Â.','¡.¤.','Ê.¤.','¡.Â.','µ.¤.','¾.Â.','¸.¤.']});
$("#datepicker-en").datepicker({ dateFormat: 'dd/mm/yy'});
$("#inline").datepicker({ dateFormat: 'yy/mm/dd', inline: true });
});
</script>
<style type="text/css">
.demoHeaders { margin-top: 2em; }
#dialog_link {padding: .4em 1em .4em 20px;text-decoration: none;position: relative;}
#dialog_link span.ui-icon {margin: 0 5px 0 0;position: absolute;left: .2em;top: 50%;margin-top: -8px;}
ul#icons {margin: 0; padding: 0;}
ul#icons li {margin: 2px; position: relative; padding: 4px 0; cursor: pointer; float: left; list-style: none;}
ul#icons span.ui-icon {float: left; margin: 0 4px;}
ul.test {list-style:none; line-height:30px;}
</style>
<style>
body {
font-family: 'Prompt', sans-serif;
font-size: 16px;
}
</style>
</head>
<nav class="navbar navbar-light bg-primary">
<a class="navbar-brand" href="#">
<img src="./img/logo.png" width="40" height="40" alt=""> <font color="#FFFFFF"><b>Consulting system</b></font>
</a>
</nav>
<ul class="breadcrumb">
<img src="https://img.icons8.com/flat_round/64/000000/home.png" width="32" height="32"> <b>ª×èͼÙéãªé§Ò¹ ::</b> <b>ID:</b> <font color="blue"><?=$_GET['User'] ?></font> <b>ª×èÍ - ¹ÒÁÊ¡ØÅ</b> <span class="label label-info"><font color="blue"><?=$_GET['name']?></font></span>
<b>ºÑ¹·Ö¡¼Å¡ÒÃãËé¤Ó»ÃÖ¡ÉÒÊÓËÃѺ¹Ñ¡ÈÖ¡ÉÒ¾ÂÒºÒÅÈÒʵÃìºÑ³±Ôµ</b>
</ul>
<script>
function goBack() {
window.history.back();
}
</script>
<?php
include_once("classes/Crud.php");
$crud = new Crud();
?>
<form name="memmo" id="memmo" action="addDataIns.php" method="post">
<table class="table">
<tbody>
<tr>
<td align="left">
<div class="form-group">
<label for="round"><b>Ãͺ¡ÒÃãËé¤Ó»ÃÖ¡ÉÒ/¤ÃÑ駷Õè</b></label>
<input type="number" class="form-control" id="round" placeholder="Ãͺ·Õè" name="round" value="<?= $resf['round'] ?>" >
</div>
</td>
</tr>
<tr>
<td align="left">
<div class="form-group">
<label for="proDate"><b>¡ÃÍ¡Çѹ·Õè ¤ÅÔê¡à¾×èÍàÅ×Í¡¨Ò¡»¯Ô·Ô¹´éÒ¹ÅèÒ§</b>(Çѹ·ÕèºÑ¹·Ö¡/ÍѾഷ¢éÍÁÙÅ)</label>
<input type="text" class="form-control" name="proDate" id="datepicker-th" required>
</div>
</td>
</tr>
<?php
$termConfig = "SELECT * FROM TermConfig WHERE CURDATE() BETWEEN tmcFrDate AND tmcToDate ";
$result = $crud->getData($termConfig);
foreach ($result as $key => $res) {$academicYear=$res['tmcAcY'];$term=$res['tmcTmId'];}
echo $term;
?>
<!--
<tr>
<td align="left">
<div class="form-group">
<label for="round"><b>ÀÒ¤¡ÒÃÈÖ¡ÉÒ·Õè</b> (ÀÒ¤¡ÒÃÈÖ¡ÉÒ·Õè 3 ËÁÒ¶֧ ÀÒ¤¡ÒÃÈÖ¡ÉÒÄ´ÙÃé͹)</label>
<select class="custom-select" id="term" name="term">
<option value="<?=$term?>" selected><?=$term?></option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select>
</div>
</tr>
-->
<tr>
<td align="left">
<div class="form-group">
<input type="hidden" id="term" name="term" value="<?=$term?>">
<label for="round"><b>»Õ¡ÒÃÈÖ¡ÉÒ</b></label>
<select class="custom-select" id="academic_year" name="academic_year">
<option value="<?=$academicYear?>" selected><?=$academicYear?></option>
<option value="<?=$$academicYear-1?>"><?=$academicYear-1?></option>
</select>
</div>
</td>
</tr>
</td>
<td align="left">
<div class="form-group">
<label for="round"><b>ÀÒ¤¡ÒÃÈÖ¡ÉÒ·Õè</b></label>
<input type="text" class="form-control" id="reason" name="reason" required>
</div>
</td>
</tr>
<td align="left">
<div class="form-group">
<label for="round"><b>ÇÔ¸ÕµÔ´µè͡ѺÍÒ¨ÒÃÂì·Õè»ÃÖ¡ÉÒ(ÁÒ¾º/â·ÃÈѾ·ì/Í͹äŹì Ï)</b></label>
<input type="text" class="form-control" id="amountj" name="amountj" required>
</div>
</td>
</tr>
<td align="left">
<div class="form-group">
<label for="round"><b>ÃÇÁÃÐÂÐàÇÅÒãËé¤Ó»ÃÖ¡ÉÒ (ªÁ.)</b></label>
<input type="text" class="form-control" id="amountnj" name="amountnj" required>
</div>
</td>
</tr>
<tr>
<td align="center">
<table class="table">
<thead class="thead-dark">
<tr>
<th>¡ÒÃà¢éÒÃèÇÁ</th>
<th>ÃËÑʹѡÈÖ¡ÉÒ</th>
<th>ª×èÍ-¹ÒÁÊ¡ØÅ</th>
<th>GPA</th>
<th>ªÑé¹»Õ</th>
<th class="text-center">ÃÙ»ÀÒ¾</th>
</tr>
</thead>
<tbody>
<?php
$name=1;
$keyData=$_GET['User'];
$studentAll = "SELECT * FROM realAdviser WHERE officerCode='$keyData' AND advAcY='$academicYear' ";
$results = $crud->getData($studentAll);
foreach ($results as $key => $res1) {
$codediff=$res1['advStdId'];
$studentGpax = "SELECT *,CAST(ROUND(GPA,2) as DECIMAL (18,2) )as GPA1 FROM Student WHERE studentId='$codediff' "; //ORDER BY ssmAcY DESC , ssmTmId DESC LIMIT 1
$resultGpax = $crud->getData($studentGpax);
foreach ($resultGpax as $key => $res2) {
$GPA=$res2['GPA1'];
$studentYear=$res2['studentYear'];
}
?>
<tr>
<th>
<div class="custom-control custom-checkbox">
<input type="checkbox" id="per<?=$name?>" name="per<?=$name?>" class="custom-control-input" value="<?=$res1['advStdId']?>">
<label class="custom-control-label" for="per<?=$name?>"><font color="red">à¢éÒÃèÇÁ</font></label>
</div>
</th>
<th><?=$res1['studentCode']?></th>
<td><?=$res1['sprefix'].$res1['studentName']." ".$res1['studentSurname']?></td>
<td><?=$res2['GPA1']?></td>
<td><?=$res2['studentYear']?></td>
<td class="text-center"><img src="http://110.164.51.230/mis//uploads/eregis/pictureStd/<?=$res1['sdtPicturePath']?>"></td>
</tr>
<?php
$name++;
}
?>
</tbody>
</table>
<tr>
<td align="center">
<table class="table">
<thead class="thead-dark">
<tr>
<th>ËÑÇ¢éÍãËé¤Ó»ÃÖ¡ÉÒ</th>
<th>ºÑ¹·Ö¡¼Å¡ÒÃãËé¤Ó»ÃÖ¡ÉÒ/¡ÒêèÇÂàËÅ×Í</th>
</tr>
</thead>
<tbody>
<tr>
<td valign="top">
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input" id="s9" value="1" name="s9" <?php if($resf['s9']==1) echo checked ?>>
<label class="custom-control-label" for="s9"> ¡ÒûÃѺµÑÇ㹡ÒôÓà¹Ô¹ªÕÇÔµ</label>
</div>
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input" id="s10" value="1" name="s10" <?php if($resf['s10']==1) echo checked ?>>
<label class="custom-control-label" for="s10"> ¡ÒáéÒÇà¢éÒÊÙèÇÔªÒªÕ¾</label>
</div>
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input" id="s11" value="1" name="s11" <?php if($resf['s11']==1) echo checked ?>>
<label class="custom-control-label" for="s11"> ¡ÒÃàÊÃÔÁÊÃéÒ§·Ñȹ¤µÔ·Ò§ºÇ¡</label>
</div>
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input" id="s1" value="1" name="s1" <?php if($resf['s1']==1) echo checked ?>>
<label class="custom-control-label" for="s1"> ¡ÒÃàÃÕ¹</label>
</div>
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input" id="s2" value="1" name="s2" <?php if($resf['s2']==1) echo checked ?>>
<label class="custom-control-label" for="s2"> ÊØ¢ÀÒ¾</label>
</div>
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input" id="s3" value="1" name="s3" <?php if($resf['s3']==1) echo checked ?>>
<label class="custom-control-label" for="s3"> ¡ÒÃà§Ô¹/·Ø¹¡ÒÃÈÖ¡ÉÒ/¡ÒÃËÒÃÒÂä´é¾ÔàÈÉ</label>
</div>
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input" id="s4" value="1" name="s4" <?php if($resf['s4']==1) echo checked ?>>
<label class="custom-control-label" for="s4"> ¤ÇÒÁÃÑ¡</label>
</div>
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input" id="s5" value="1" name="s5" <?php if($resf['s5']==1) echo checked ?>>
<label class="custom-control-label" for="s5"> à¾×è͹</label>
</div>
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input" id="s6" value="1" name="s6" <?php if($resf['s6']==1) echo checked ?>>
<label class="custom-control-label" for="s6"> ¡Ô¨¡ÃÃÁàÊÃÔÁËÅÑ¡ÊÙµÃ</label>
</div>
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input" id="s7" value="1" name="s7" <?php if($resf['s7']==1) echo checked ?>>
<label class="custom-control-label" for="s7"> ¨ÔµÍÒÊÒ</label>
</div>
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input" id="s8" value="1" name="s8" <?php if($resf['s8']==1) echo checked ?>>
<label class="custom-control-label" for="s8"> Í×è¹æ</label>
</div>
<div class="form-group">
<input type="text" class="form-control" id="other" placeholder="ÃкØ" name="other" value="<?= $resf['other'] ?>">
</div>
</td>
<td valign="top"><textarea name="result" cols="50" rows="8"><?= $resf['result'] ?></textarea></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td colspan="2" align="left"><b>»ÑËÒ·Õ辺¨Ò¡¡ÒÃãËé¤Ó»ÃÖ¡ÉÒ ¤×Í ::</b><br>
<label for="option-two" class="pure-radio">
<input id="option-two" type="radio" name="problem" value="N" checked>
äÁèÁÕ»ÑËÒ
</label><br>
<label for="option-three" class="pure-radio">
<input id="option-three" type="radio" name="problem" value="Y" >
ÁÕ»ÑËÒ
</label>
</td>
</tr>
<tr>
<td align="left" ><b>ÃÒÂÅÐàÍÕ´Í×è¹æ ::</b><br>
<textarea name="ploblemDetail" cols="50" rows="3"></textarea>
</td>
</tr>
<tr>
<td align="left"><b>·èÒ¹ÊÒÁÒö¨Ñ´¡ÒáѺ»ÑËÒä´é´éǵ¹àͧËÃ×ÍäÁè</b><br>
<label for="option-two" class="pure-radio">
<input id="option-two" type="radio" name="probManage" value="Y" checked>
¨Ñ´¡ÒÃä´é
</label><br>
<label for="option-three" class="pure-radio">
<input id="option-three" type="radio" name="probManage" value="S" >
Ê觵èÍä»Âѧ§Ò¹á¹Ðá¹ÇáÅÐãËé¤Ó»ÃÖ¡ÉÒ
</label>
</td>
</tr>
<tr>
<td align="left"><b>ËÒ¡·èÒ¹ <u>äÁèÊÒÁÒö</u> ¨Ñ´¡ÒÃä´é´éǵ¹àͧ
·èÒ¹ÊÒÁÒöÊ觵èÍ»ÑËÒ¹ÕéãËé¡ÑºË¹èǧҹ/¼Ùéà¡ÕèÂÇ¢éͧ ¤×Í</b><br>
<label for="option-two" class="pure-radio">
<input id="option-two" type="radio" name="probSend" value="Y" checked>
Ê觵èÍä»Âѧ§Ò¹á¹Ðá¹ÇáÅÐãËé¤Ó»ÃÖ¡ÉÒ
</label><br>
<label for="option-three" class="pure-radio">
<input id="option-three" type="radio" name="probSend" value="N" >
äÁèÊ觵èÍ
</label>
</td>
</tr>
<tr>
<td align="left"><b>ÍÒ¨ÒÃÂì·Õè»ÃÖ¡ÉÒ</b> <?=$_GET['name']?><br> ID::<?=$_GET['User']?> <input type="hidden" name="name" value="<?=$_GET['name']?>"><input type="hidden" name="userID" value="<?=$_GET['User']?>"></td>
</tr>
<tr>
<td align="left"><button class="pure-button">ºÑ¹·Ö¡¼Å¡ÒÃãËé¤Ó»ÃÖ¡ÉÒ</button>
</td>
</tr>
</tbody>
</table>
</form>
<?php
function DateThai($strDate)
{
$strYear = date("Y",strtotime($strDate))+543;
$strMonth= date("n",strtotime($strDate));
$strDay= date("j",strtotime($strDate));
$strHour= date("H",strtotime($strDate));
$strMinute= date("i",strtotime($strDate));
$strSeconds= date("s",strtotime($strDate));
$strMonthCut = Array("","Á¡ÃÒ¤Á","¡ØÁÀҾѹ¸ì","ÁÕ¹Ò¤Á","àÁÉÒ¹","¾ÄÉÀÒ¤Á","ÁԶعÒ¹","¡Ã¡®Ò¤Á","ÊÔ§ËÒ¤Á","¡Ñ¹ÂÒ¹","µØÅÒ¤Á","¾ÄȨԡÒ¹","¸Ñ¹ÇÒ¤Á");
$strMonthThai=$strMonthCut[$strMonth];
return "$strDay $strMonthThai $strYear àÇÅÒ $strHour:$strMinute ¹.";
}
?>
</html>