| Server IP : 202.29.229.35 / Your IP : 18.119.120.88 Web Server : Apache System : Linux aapanel2 4.15.0-213-generic #224-Ubuntu SMP Mon Jun 19 13:30:12 UTC 2023 x86_64 User : www ( 1001) PHP Version : 5.5.38 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /www/wwwroot/www.ivecr2.ac.th/stdcard/ |
Upload File : |
<?php
error_reporting(0);
include("connect/connect.php");
include("connect/function.php");
$year =$_POST['y'];//ปีการศึกษา
$scid= $_POST['tecSchool'];//วิลัยฯที่เลือก$schoolid;
$major_id = $_POST['tecSub'];//รหัสสาขาวิชาที่เลือก$majorID;
//ดึงชื่อวิลัย
$sqlschool="select * from tbl_school where subscID='$scid' ";
$reschool=mysql_query($sqlschool);
$rsschool=mysql_fetch_array($reschool);
$scName=$rsschool['scName'];
//ดึงชื่อสาขา
$sqlmajor="select * from tbl_dptsubject where sbID='$major_id' ";
$remajor=mysql_query($sqlmajor);
$rsmajor=mysql_fetch_array($remajor);
$sbname=$rsmajor['sbName'];
if($scid ==""){
$scregister="";
}else{
$scregister="สังกัด";
$scnameori=$scName;
}
if($major_id==""){
$maname ="";
}else{
$maname = "สาขาวิชา";
$sbnameori = $sbname;
}
if($year == ""){
$yearsori="";
}else{
$textori="ประจำปี";
$yearsori=$year;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<p>
<form id="form1" name="form1" method="post" action="">
<table width="700" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td width="670" align="center" valign="top">แบบ บนศ.3<br />
บัญชีรายชื่อนักศึกษาหลักสูตรเทคโนโลยีบัณฑิต<br />
<?php echo $maname.$sbnameori."<br>".$scregister.$scnameori." สถาบันการอาชีวศึกษาภาคกลาง 2"; ?> </td>
</tr>
</table>
</form>
<p><center>
<h3><a href="system_pdffile/reportPcardbybns2.php?printyear=<?php echo $year;?>&major_id=<?php echo $major_id;?>&scid=<?php echo $scid;?>" target="_blank"><<พิมพ์รายงาน>></a> || <a href="listsubjectbybns2.php">ถอยกลับ</a></h3></center></p>
<table width="800" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td width="50" height="40" align="center" valign="middle" bgcolor="#CCCCCC">ลำดับที่</td>
<td width="100" height="40" align="center" valign="middle" bgcolor="#CCCCCC">เลขที่บัตร</td>
<td width="150" height="40" align="center" valign="middle" bgcolor="#CCCCCC">รหัส นศ.</td>
<td height="40" colspan="2" align="center" valign="middle" bgcolor="#CCCCCC">ชื่อ - นามกสุล</td>
<td width="100" height="40" align="center" valign="middle" bgcolor="#CCCCCC">วันออกบัตร</td>
<td width="100" height="40" align="center" valign="middle" bgcolor="#CCCCCC">บัตรหมดอายุ</td>
<td width="50" height="40" align="center" valign="middle" bgcolor="#CCCCCC"> </td>
</tr>
<?php
if($year == '' && $scid == '' && $major_id== ''){//4
$sqlstdall="select * from tblstd_idcard order by student_id,card_no ASC";
}else if($year != NULL && $scid == '' && $major_id== ''){//8
$sqlstdall="select * from tblstd_idcard where start_year='$year' order by student_id,card_no ASC";
}else if($year == '' && $scid != '' && $major_id== ''){//7
$sqlstdall="select * from tblstd_idcard where idschool='$scid' order by student_id,card_no ASC";
}else if($year == '' && $scid == '' && $major_id != ''){//11
$sqlstdall="select * from tblstd_idcard where major_id='$major_id' order by student_id,card_no ASC";
}else if($year != '' && $scid != '' && $major_id == ''){//10
$sqlstdall="select * from tblstd_idcard where start_year='$year' and idschool='$scid' order by student_id,card_no ASC";
}else if($year != '' && $scid == '' && $major_id != ''){//9
$sqlstdall="select * from tblstd_idcard where start_year='$year' and major_id='$major_id' order by student_id,card_no ASC";
}else if($year == '' && $scid != '' && $major_id == ''){ //1
$sqlstdall="select * from tblstd_idcard where idschool='$scid' order by student_id,card_no ASC";
}else if($year == '' && $scid != '' && $major_id != ''){//2
$sqlstdall="select * from tblstd_idcard where idschool='$scid' and major_id='$major_id' order by student_id,card_no ASC";
}else if($year == '' && $scid == '' && $major_id != ''){ //5
$sqlstdall="select * from tblstd_idcard where major_id='$major_id' order by student_id,card_no ASC";
}else if($year != '' && $scid == '' && $major_id != ''){//6
$sqlstdall="select * from tblstd_idcard where start_year='$year' and major_id='$major_id' order by student_id,card_no ASC";
}else if($year != '' && $scid != '' && $major_id != ''){ //3
$sqlstdall="select * from tblstd_idcard where start_year='$year' and major_id='$major_id' and idschool='$scid' order by student_id,card_no ASC";
}
//------------------
//echo "==>".$sqlstdall;
$result=mysql_query($sqlstdall);
$n=0;
while($rsstd=mysql_fetch_array($result)){
$n++;//ลำดับที่
$card_no=$rsstd['card_no'];//เลขที่บัตร
/*
if(strlen($card_no)==1)
$card_no_show = "000".$card_no;
elseif(strlen($card_no)==2)
$card_no_show = "00".$card_no;
elseif(strlen($card_no)==3)
$card_no_show = "0".$card_no;
elseif(strlen($card_no)==4)
$card_no_show = $card_no;
*/
$perfix_idori =$rsstd['perfix_id'];
if($perfix_idori=="002")
$stdPrefixThaiori="นาย";
elseif($perfix_idori=="003")
$stdPrefixThaiori="นางสาว";
elseif($perfix_idori=="009")
$stdPrefixThaiori="จ.ส.ท.";
else if($perfix_idori=="004")
$stdPrefixThaiori="นาง";
else
$stdPrefixThaiori="";
$bg="";
if($bg == "#D5EEFF"){
$bg= "#F0F9FF";
}else{
$bg ="#D5EEFF";
}
?>
<tr bgcolor="<?php echo $bg;?>" onmousemove="this.style.backgroundColor='#FFE495'" onmouseout="this.style.backgroundColor=''">
<td width="50" align="center" valign="top"><?php echo $n;?></td>
<td width="100" align="center" valign="top"><?php echo $card_no;?></td>
<td width="150" align="center" valign="top"><?php echo $rsstd['student_id'];?></td>
<td width="150" align="left" valign="top"><?php echo $stdPrefixThaiori.$rsstd['stu_fname'];?></td>
<td width="150" align="left" valign="top"><?php echo $rsstd['stu_lname'];?></td>
<td width="100" align="center" valign="top"><?php echo $rsstd['date_print'];?></td>
<td width="100" align="center" valign="top"><?php echo $rsstd['date_expire'];?></td>
<td width="50" align="center" valign="top">แก้ไข </td>
</tr>
<?php
}//end while
?>
</table>
<p> </p>
</body>
</html>