Viewing file: reg_standard.php (11.33 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
require_once('nusoap.php');
//-----------------------------------------------------num student----------------------------------------------------------
function num_student($search_num_student,$search_term_date_start,$search_term_date_end) {
$information = '<?xml version="1.0" encoding="windows-874"?>';
//Standard 5-6
//$information .= "\n<Standard_5_6>";
//num_student
$host="localhost";
$username="root";
$pass_word="";
$db="reg";
//mysql_query("SET NAMES TIS620");
mysql_connect( $host,$username,$pass_word) or die ("ติดต่อกับฐานข้อมูล Mysql ไม่ได้ ");
mysql_select_db($db) or die("เลือกฐานข้อมูลไม่ได้");
$sql = "SELECT * FROM StudentMaster where (admitDate < '$search_term_date_end')";
$dbquery = mysql_query($sql);
$num_student_all =mysql_num_rows($dbquery) ;
//echo "นักศึกษาทั้งหมด $num_student_all<br>";
$sql2 = "SELECT * FROM StudentMaster WHERE (studentStatus = '1') and (admitDate < '$search_term_date_end')";
$dbquery2 = mysql_query($sql2);
$num_student_now =mysql_num_rows($dbquery2) ;
//echo "นักศึกษาที่กำลังศึกษาอยู่ $num_student<br>";
$sql2 = "SELECT * FROM StudentMaster WHERE studentStatus = '5' and (admitDate < '$search_term_date_end')";
$dbquery2 = mysql_query($sql2);
$num_student_out =mysql_num_rows($dbquery2) ;
//echo "นักศึกษาที่่ลาออก $num_student_out<br>";
//นับจำนวนนักศึกษา
$sql2 = "SELECT * FROM StudentMaster WHERE studentStatus = '1' and (admitDate < '$search_term_date_end')";
$dbquery2 = mysql_query($sql2);
$num_studentYear_1=0;
$num_studentYear_2=0;
$num_student2Year_2=0;
$num_studentYear_3=0;
$num_studentYear_4=0;
while($row = mysql_fetch_array($dbquery2))
{
$studentCode=$row["studentCode"];
$studentYear=$row["studentYear"];
$admitAcadYear=$row["admitAcadYear"];
//if($studentYear=='1'){$num_studentYear_1++;}
//if($studentYear=='2'){$num_studentYear_2++;}
//if($studentYear=='3'){$num_studentYear_3++;}
//if($studentYear=='4'){$num_studentYear_4++;}
$studentCode;
$studentCode_check = substr($studentCode, 0, 6);
if($admitAcadYear=='2550'){$num_studentYear_1++;}
if($admitAcadYear=='2549')
{
if($studentCode_check=='492101')
{
$num_studentYear_2++;
}
if($studentCode_check=='492103')
{
$num_student2Year_2++;
}
//$num_studentYear_2++;
}
if($admitAcadYear=='2548'){$num_studentYear_3++;}
if($admitAcadYear=='2547'){$num_studentYear_4++;}
}
$information .= "\n<num_student>";
$information .= "\n<num_student_all>";
$information .= "$num_student_all";
$information .= "\n</num_student_all>";
$information .= "\n<num_student_now>";
$information .= "$num_student_now";
$information .= "\n</num_student_now>";
$information .= "\n<num_student_out>";
$information .= "$num_student_out";
$information .= "\n</num_student_out>";
//---------------------------------------------------------------------------student_year1
$information .= "\n<student_year1>";
$information .= "\n<term1>";
$information .= "\n<num_student_year1_term1>";
$information .= "$num_studentYear_1";
$information .= "\n</num_student_year1_term1>";
$information .= "\n<num_cradit_year1_term1>";
$information .= "17";
$information .= "\n</num_cradit_year1_term1>";
$sum_year1_Term1=$num_studentYear_1*17;
$information .= "\n<sum_year1_Term1>";
$information .= "$sum_year1_Term1";
$information .= "\n</sum_year1_Term1>";
$information .= "\n</term1>";
$information .= "\n<term2>";
$information .= "\n<num_student_year1_term2>";
$information .= "$num_studentYear_1";
$information .= "\n</num_student_year1_term2>";
$information .= "\n<num_cradit_year1_term2>";
$information .= "20";
$information .= "\n</num_cradit_year1_term2>";
$sum_year1_Term2=$num_studentYear_1*20;
$information .= "\n<sum_year1_Term2>";
$information .= "$sum_year1_Term2";
$information .= "\n</sum_year1_Term2>";
$information .= "\n</term2>";
$information .= "\n<term3>";
$information .= "\n<num_student_year1_term3>";
$information .= "$num_studentYear_1";
$information .= "\n</num_student_year1_term3>";
$information .= "\n<num_cradit_year1_term3>";
$information .= "12";
$information .= "\n</num_cradit_year1_term3>";
$sum_year1_Term3=$num_studentYear_1*12;
$information .= "\n<sum_year1_Term3>";
$information .= "$sum_year1_Term3";
$information .= "\n</sum_year1_Term3>";
$information .= "\n</term3>";
$information .= "\n</student_year1>";
//---------------------------------------------------------------------------student_year2
$information .= "\n<student_year2>";
$information .= "\n<term1>";
$information .= "\n<num_student_year2_term1>";
$information .= "$num_studentYear_2";
$information .= "\n</num_student_year2_term1>";
$information .= "\n<num_cradit_year2_term1>";
$information .= "17";
$information .= "\n</num_cradit_year2_term1>";
$sum_year2_Term1=$num_studentYear_2*17;
$information .= "\n<sum_year2_Term1>";
$information .= "$sum_year2_Term1";
$information .= "\n</sum_year2_Term1>";
$information .= "\n</term1>";
$information .= "\n<term2>";
$information .= "\n<num_student_year2_term2>";
$information .= "$num_studentYear_2";
$information .= "\n</num_student_year2_term2>";
$information .= "\n<num_cradit_year2_term2>";
$information .= "18";
$information .= "\n</num_cradit_year2_term2>";
$sum_year2_Term2=$num_studentYear_2*18;
$information .= "\n<sum_year2_Term2>";
$information .= "$sum_year2_Term2";
$information .= "\n</sum_year2_Term2>";
$information .= "\n</term2>";
$information .= "\n<term3>";
$information .= "\n<num_student_year2_term3>";
$information .= "$num_studentYear_2";
$information .= "\n</num_student_year2_term3>";
$information .= "\n<num_cradit_year2_term3>";
$information .= "7";
$information .= "\n</num_cradit_year2_term3>";
$sum_year2_Term3=$num_studentYear_2*7;
$information .= "\n<sum_year2_Term3>";
$information .= "$sum_year2_Term3";
$information .= "\n</sum_year2_Term3>";
$information .= "\n</term3>";
$information .= "\n</student_year2>";
//-------------------------------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------student 2 _year2
$information .= "\n<student2_year2>";
$information .= "\n<term1>";
$information .= "\n<num_student_year2_term1>";
$information .= "$num_student2Year_2";
$information .= "\n</num_student_year2_term1>";
$information .= "\n<num_cradit_year2_term1>";
$information .= "15.5";
$information .= "\n</num_cradit_year2_term1>";
$sum2_year2_Term1=$num_student2Year_2*15.5;
$information .= "\n<sum_year2_Term1>";
$information .= "$sum2_year2_Term1";
$information .= "\n</sum_year2_Term1>";
$information .= "\n</term1>";
$information .= "\n<term2>";
$information .= "\n<num_student_year2_term2>";
$information .= "$num_student2Year_2";
$information .= "\n</num_student_year2_term2>";
$information .= "\n<num_cradit_year2_term2>";
$information .= "7.5";
$information .= "\n</num_cradit_year2_term2>";
$sum2_year2_Term2=$num_student2Year_2*7.5;
$information .= "\n<sum_year2_Term2>";
$information .= "$sum2_year2_Term2";
$information .= "\n</sum_year2_Term2>";
$information .= "\n</term2>";
$information .= "\n</student2_year2>";
//-------------------------------------------------------------------------------------------------------------------------
//---------------
//$information .= "\n<num_student2Year_2>";
//$information .= "$num_student2Year_2";
//$information .= "\n</num_student2Year_2>";
//-----------------------------------------------------------------student_year 4
$information .= "\n<student_year3>";
$information .= "\n<term1>";
$information .= "\n<num_student_year3_term1>";
$information .= "$num_studentYear_3";
$information .= "\n</num_student_year3_term1>";
$information .= "\n<num_cradit_year3_term1>";
$information .= "13";
$information .= "\n</num_cradit_year3_term1>";
$sum_year3_Term1=$num_studentYear_3*13;
$information .= "\n<sum_year3_Term1>";
$information .= "$sum_year3_Term1";
$information .= "\n</sum_year3_Term1>";
$information .= "\n</term1>";
$information .= "\n<term2>";
$information .= "\n<num_student_year3_term2>";
$information .= "$num_studentYear_3";
$information .= "\n</num_student_year3_term2>";
$information .= "\n<num_cradit_year3_term2>";
$information .= "16";
$information .= "\n</num_cradit_year3_term2>";
$sum_year3_Term2=$num_studentYear_3*16;
$information .= "\n<sum_year3_Term2>";
$information .= "$sum_year3_Term2";
$information .= "\n</sum_year3_Term2>";
$information .= "\n</term2>";
$information .= "\n<term3>";
$information .= "\n<num_student_year3_term3>";
$information .= "$num_studentYear_3";
$information .= "\n</num_student_year3_term3>";
$information .= "\n<num_cradit_year3_term3>";
$information .= "5";
$information .= "\n</num_cradit_year3_term3>";
$sum_year3_Term3=$num_studentYear_3*5;
$information .= "\n<sum_year3_Term3>";
$information .= "$sum_year3_Term3";
$information .= "\n</sum_year3_Term3>";
$information .= "\n</term3>";
$information .= "\n</student_year3>";
//-----------------------------------------------------------------student_year 3
$information .= "\n<student_year4>";
$information .= "\n<term1>";
$information .= "\n<num_student_year4_term1>";
$information .= "$num_studentYear_4";
$information .= "\n</num_student_year4_term1>";
$information .= "\n<num_cradit_year4_term1>";
$information .= "10";
$information .= "\n</num_cradit_year4_term1>";
$sum_year4_Term1=$num_studentYear_4*10;
$information .= "\n<sum_year4_Term1>";
$information .= "$sum_year4_Term1";
$information .= "\n</sum_year4_Term1>";
$information .= "\n</term1>";
$information .= "\n<term2>";
$information .= "\n<num_student_year4_term2>";
$information .= "$num_studentYear_4";
$information .= "\n</num_student_year4_term2>";
$information .= "\n<num_cradit_year4_term2>";
$information .= "10";
$information .= "\n</num_cradit_year4_term2>";
$sum_year3_Term2=$num_studentYear_3*10;
$information .= "\n<sum_year4_Term2>";
$information .= "$sum_year4_Term2";
$information .= "\n</sum_year4_Term2>";
$information .= "\n</term2>";
$information .= "\n</student_year4>";
//-------------------------------------------
$information .= "\n</num_student>";
//$prem=1;
//$information .= "\n</Standard_5_6>";
return $information;
}
$server = new soap_server;
$server->configureWSDL('ws_standard_on_reg', 'urn:ws_standard_on_reg_wsdl');
$server->register('num_student',
array('search_num_student' => 'xsd:string','search_term_date_start' => 'xsd:string','search_term_date_end' => 'xsd:string'),
array('information' => 'xsd:string'),
'http://58.147.103.67/ws_standard_on_reg/',
'http://58.147.103.67/ws_standard_on_reg/',
'rpc',
'encoded',
'Search_For_Student_Rent');
$HTTP_RAW_POST_DATA = isset($HTTP_RAW_POST_DATA) ? $HTTP_RAW_POST_DATA : '';
$server->service($HTTP_RAW_POST_DATA);
?>
|