Viewing file: mem.php (13.42 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<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>
|