Viewing file:  send.php (24.94 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
header( "content-type: application/x-javascript; charset=TIS-620" );
require_once( "../includes/connMySQL.class.php" );
require_once( "../configuration.php" );
require_once("../lib/nusoap/nusoap.php");
$dataType = $_GET['dataType'];
/** Create Database Object */
$conn = new DBConn;
//-- Create SOAP CLIENT
$client = new soapclient($_Config_server_path);
if(isset($dataType) && $dataType == "personal"){
$client->call('deleteUpdatePersonal',array('collogeCode'=>base64_encode($_Config_college_code)));
$strQuery = "select * from personal_tb";
$result = $conn->execQuery($strQuery);
$dataNumPerLoop = 10;
$num_rows = mysql_num_rows($result);
if($num_rows <= $dataNumPerLoop){
$dataLoop = 1;
}
else if (($num_rows % $dataNumPerLoop) == 0){
$dataLoop = ($num_rows / $dataNumPerLoop);
}
else{
$dataLoop = ($num_rows / $dataNumPerLoop) + 1;
$dataLoop = (int)$dataLoop;
}
for($i=1;$i<=$dataLoop;$i++){
$strQuery = "select * from personal_tb limit ".(($dataNumPerLoop*$i) - $dataNumPerLoop).",".$dataNumPerLoop;
$result = $conn->execQuery($strQuery);
while($rs = $conn->fetchObject($result)){
$data[0] = base64_encode($rs->Teacher_code);
$data[1] = base64_encode($_Config_college_code);
$data[2] = base64_encode($rs->Teacher_id);
$data[3] = base64_encode($rs->prefixId);
$data[4] = base64_encode($rs->Teacher_name);
$data[5] = base64_encode($rs->Teacher_lastname);
$data[6] = base64_encode($rs->DateBirth);
$data[7] = base64_encode($rs->Sex);
$data[8] = base64_encode($rs->Nationality);
$data[9] = base64_encode($rs->Nation);
$data[10] = base64_encode($rs->Religion);
$data[11] = base64_encode($rs->Citizen_id);
$data[12] = base64_encode($rs->StatusId);
$data[13] = base64_encode($rs->Soulmate);
$data[14] = base64_encode($rs->Total_child);
$data[15] = base64_encode($rs->Address);
$data[16] = base64_encode($rs->districtId);
$data[17] = base64_encode($rs->amphurId);
$data[18] = base64_encode($rs->provinceId);
$data[19] = base64_encode($rs->conId);
$data[20] = base64_encode($_Config_live_site."/personal_pic/".$rs->Img1);
$data[21] = base64_encode($rs->Skill);
$data[22] = base64_encode($rs->Type_Degree);
$data[23] = base64_encode($rs->Degree_code);
$data[24] = base64_encode($rs->Degree_else);
$data[25] = base64_encode($rs->Degree_His1);
$data[26] = base64_encode($rs->Degree_His1_Major);
$data[27] = base64_encode($rs->Degree_His1_Institute);
$data[28] = base64_encode($rs->Degree_His1_End_Year);
$data[29] = base64_encode($rs->Degree_His2);
$data[30] = base64_encode($rs->Degree_His2_Major);
$data[31] = base64_encode($rs->Degree_His2_Institute);
$data[32] = base64_encode($rs->Degree_His2_End_Year);
$data[33] = base64_encode($rs->Degree_His3);
$data[34] = base64_encode($rs->Degree_His3_Major);
$data[35] = base64_encode($rs->Degree_His3_Institute);
$data[36] = base64_encode($rs->Degree_His3_End_Year);
$data[37] = base64_encode($rs->Type_degree1);
$data[38] = base64_encode($rs->Type_degree2);
$data[39] = base64_encode($rs->Type_degree3);
$data[40] = base64_encode($rs->Year_1);
$data[41] = base64_encode($rs->Year_2);
$data[42] = base64_encode($rs->Year_3);
$data[43] = base64_encode($rs->Person_type);
$data[44] = base64_encode($rs->Teacher_type);
$data[45] = base64_encode($rs->Gover_id);
$data[46] = base64_encode($rs->Forum_nid);
$data[47] = base64_encode($rs->Club_nid);
$data[48] = base64_encode($rs->Year_gov);
$data[49] = base64_encode($rs->Year_coll);
$data[50] = base64_encode($rs->Year_fac);
$data[51] = base64_encode($rs->Gover_pos);
$data[52] = base64_encode($rs->PositionId);
$data[53] = base64_encode($rs->Salary_1);
$data[54] = base64_encode($rs->TeacherId);
$data[55] = base64_encode($rs->Propessnal);
$data[56] = base64_encode($rs->Manage_pos);
$data[57] = base64_encode($rs->Faculty_code);
$data[58] = base64_encode($rs->Email);
$data[59] = base64_encode($rs->permission);
$data[60] = base64_encode($rs->date_added);
$data[61] = base64_encode($rs->date_updated);
$client->call('importToUpdatePersonal',array('data'=>$data));
}
}
?>
<table width="56%" border="0" align="center" cellpadding="0" cellspacing="0" class="BORDER-GREY">
<tr bgcolor="#F9FBFB">
<td height="22" colspan="2" align="center" ><strong>ยืนยันการส่งข้อมูล</strong></td>
</tr>
<tr bgcolor="#F9FBFB">
<td width="77%" height="22" align="center" class="BORDER-TOP">ชื่อ - สกุล</td>
<td width="23%" align="center" class="BORDER-TOP-LEFT">สถานะ</td>
</tr>
<?php
$response = $client->call('getUpdatePersonalID',array('collogeCode'=>base64_encode($_Config_college_code)));
$data = split(',',$response);
for($i=0;$i<sizeof($data);$i++){
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
$result = $client->call('getUpdatePersonal',array('Teacher_code'=>base64_encode($data[$i]) , 'collogeCode'=>base64_encode($_Config_college_code)));
?>
<tr bgcolor="<?=$bgColor;?>">
<td width="77%" height="22" align="left" class="BORDER-TOP"> <?=base64_decode($result[3]);?> <?=base64_decode($result[4]);?> <?=base64_decode($result[5]);?></td>
<td width="23%" align="center" class="BORDER-TOP-LEFT"><?=($result[62] )?"<font color='green'>UPDATE</font>":"<font color='red'>INSERT</font>"?></td>
</tr>
<?php }?>
<tr bgcolor="<?=( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";?>">
<td height="46" colspan="2" align="center" class="BORDER-TOP">
<input type="button" value="ยืนยัน" style="cursor:pointer" onClick="javascript:window.location='sendPersonalData.php?action=confirm'" /> <input type="button" value="ยกเลิก" style="cursor:pointer" onClick="javascript:window.location='sendPersonalData.php?action=cancel'" />
</td>
</tr>
</table>
<?php
}
if(isset($dataType) && $dataType == "building"){
/** Export to PI Process */
//-- 1.Delete update_building data (PI)
$client->call('deleteUpdateBuilding',array('collogeCode'=>base64_encode($_Config_college_code)));
//-- 2.Transfer Data From building_tb (Client) to update_building (PI)
$strQuery = "select * from building_tb";
$result = $conn->execQuery($strQuery);
$dataNumPerLoop = 10;
$num_rows = mysql_num_rows($result);
if($num_rows <= $dataNumPerLoop){
$dataLoop = 1;
}
else if (($num_rows % $dataNumPerLoop) == 0){
$dataLoop = ($num_rows / $dataNumPerLoop);
}
else{
$dataLoop = ($num_rows / $dataNumPerLoop) + 1;
$dataLoop = (int)$dataLoop;
}
for($i=1;$i<=$dataLoop;$i++){
$strQuery = "select * from building_tb limit ".(($dataNumPerLoop*$i) - $dataNumPerLoop).",".$dataNumPerLoop;
$result = $conn->execQuery($strQuery);
while($rs = $conn->fetchObject($result)){
$data[0] = base64_encode($rs->BuildD_No);
$data[1] = base64_encode($_Config_college_code);
$data[2] = base64_encode($rs->BuildD_ID);
$data[3] = base64_encode($rs->Build_name);
$data[4] = base64_encode($rs->Build_type);
$data[5] = base64_encode($rs->Date_note);
$data[6] = base64_encode($_Config_live_site."/Man_pic/".$rs->Img1);
$data[7] = base64_encode($rs->Short_name);
$data[8] = base64_encode($rs->Class_unit);
$data[9] = base64_encode($rs->Room_unit);
$data[10] = base64_encode($rs->BuildD_Yr);
$data[11] = base64_encode($rs->BuildD_Pr);
$data[12] = base64_encode($rs->MoneyS_C);
$data[13] = base64_encode($rs->Description);
$data[14] = base64_encode($rs->Area);
$client->call('importToUpdateBuilding',array('data'=>$data));
}
}
?>
<table width="66%" border="0" align="center" cellpadding="0" cellspacing="0" class="BORDER-GREY">
<tr bgcolor="#F9FBFB">
<td height="22" colspan="2" align="center" ><strong>ยืนยันการส่งข้อมูล</strong></td>
</tr>
<tr bgcolor="#F9FBFB">
<td width="77%" height="22" align="center" class="BORDER-TOP">ชื่ออาคาร</td>
<td width="23%" align="center" class="BORDER-TOP-LEFT">สถานะ</td>
</tr>
<?php
$response = $client->call('getUpdateBuildingID',array('collogeCode'=>base64_encode($_Config_college_code)));
$data = split(',',$response);
for($i=0;$i<sizeof($data);$i++){
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
$result = $client->call('getUpdateBuilding',array('BuildD_No'=>base64_encode($data[$i]) , 'collogeCode'=>base64_encode($_Config_college_code)));
?>
<tr bgcolor="<?=$bgColor;?>">
<td width="77%" height="22" align="left" class="BORDER-TOP"> <?=base64_decode($result[3]);?></td>
<td width="23%" align="center" class="BORDER-TOP-LEFT"><?=($result[15] )?"<font color='green'>UPDATE</font>":"<font color='red'>INSERT</font>"?></td>
</tr>
<?php }?>
<tr bgcolor="<?=( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";?>">
<td height="46" colspan="2" align="center" class="BORDER-TOP">
<input type="button" value="ยืนยัน" style="cursor:pointer" onclick="javascript:window.location='sendBuildingData.php?action=confirm'" /> <input type="button" value="ยกเลิก" style="cursor:pointer" onclick="javascript:window.location='sendBuildingData.php?action=cancel'" />
</td>
</tr>
</table>
<?php
}
if(isset($dataType) && $dataType == "student"){
//-- Connect Database REG
require_once( "../includes/FunctionDB.php" );
ConnectDB();
/** Export to PI Process */
//-- 1.Delete studentByYearTemp , studentByProgramTemp , studentByProvinceTemp , studentByLevelTemp data (PI)
$client->call('deleteStudentByYearRealT',array('collogeCode'=>base64_encode($_Config_college_code)));
$client->call('deleteStudentByProgram',array('collogeCode'=>base64_encode($_Config_college_code)));
$client->call('deleteStudentByProvince',array('collogeCode'=>base64_encode($_Config_college_code)));
$client->call('deleteStudentByLevel',array('collogeCode'=>base64_encode($_Config_college_code)));
//-- 2.Transfer Data From reg.studentMaster (Client) to studentByYearTemp , studentByProgramTemp , studentByProvinceTemp , studentByLevelTemp (PI)
//-- studentByYear
$strQueryAcadYear = "select admitAcadYear from StudentMaster group by admitAcadYear";
$resultAcadYear = mysql_query($strQueryAcadYear);
while($RSAcadYear = mysql_fetch_object($resultAcadYear)){
$strQueryStudent = "SELECT admitAcadYear , (select COUNT(*) from StudentMaster where studentSex = 'M' and studentStatus = '1' and admitAcadYear = '".$RSAcadYear->admitAcadYear."') as studentM , (select COUNT(*) from StudentMaster where studentSex = 'F' and studentStatus = '1' and admitAcadYear = '".$RSAcadYear->admitAcadYear."') as studentF FROM StudentMaster WHERE studentStatus = '1' and admitAcadYear = '".$RSAcadYear->admitAcadYear."' GROUP BY admitAcadYear";
$resultStudent = mysql_query($strQueryStudent);
$rows = mysql_num_rows($resultStudent);
if($rows){
$RSStudent = mysql_fetch_object($resultStudent);
$yearData[0] = base64_encode($_Config_college_code);
$yearData[1] = base64_encode($RSStudent->admitAcadYear);
$yearData[2] = base64_encode($RSStudent->studentM);
$yearData[3] = base64_encode($RSStudent->studentF);
$client->call('importToStudentByYear',array('data'=>$yearData));
}
}
//-- studentByProgram
$strQueryProgram = "select programId from Program";
$resultProgram = mysql_query($strQueryProgram);
while($RSProgram = mysql_fetch_object($resultProgram)){
$strQueryStudent = "SELECT programId , (select COUNT(*) from StudentMaster where studentSex = 'M' and studentStatus = '1' and programId = '".$RSProgram->programId."') as studentM , (select COUNT(*) from StudentMaster where studentSex = 'F' and studentStatus = '1' and programId = '".$RSProgram->programId."') as studentF FROM StudentMaster WHERE programId = '".$RSProgram->programId."' and studentStatus = '1' GROUP BY programId";
$resultStudent = mysql_query($strQueryStudent);
$rows = mysql_num_rows($resultStudent);
if($rows){
$RSStudent = mysql_fetch_object($resultStudent);
$programData[0] = base64_encode($_Config_college_code);
$programData[1] = base64_encode($RSStudent->programId);
$programData[2] = base64_encode($RSStudent->studentM);
$programData[3] = base64_encode($RSStudent->studentF);
$client->call('importToStudentByProgram',array('data'=>$programData));
}
}
//-- studentByProvince
$strQueryProvince = "select provinceId from Province";
$resultProvince = mysql_query($strQueryProvince);
while($RSProvince = mysql_fetch_object($resultProvince)){
//echo $RSProvince->provinceId."<br>";
$strQueryStudent = "SELECT StudentBio.homeProvinceId , (select COUNT(*) from StudentMaster , StudentBio where StudentMaster.studentSex = 'M' and StudentBio.homeProvinceId = '".$RSProvince->provinceId."' and StudentMaster.studentStatus = '1' and StudentMaster.studentId = StudentBio.studentId) as studentM , (select COUNT(*) from StudentMaster , StudentBio where StudentMaster.studentSex = 'F' and StudentBio.homeProvinceId = '".$RSProvince->provinceId."' and StudentMaster.studentStatus = '1' and StudentMaster.studentId = StudentBio.studentId) as studentF FROM StudentMaster , StudentBio WHERE StudentBio.homeProvinceId = '".$RSProvince->provinceId."' and StudentMaster.studentStatus = '1' and StudentMaster.studentId = StudentBio.studentId GROUP BY StudentBio.homeProvinceId";
$resultStudent = mysql_query($strQueryStudent);
$rows = mysql_num_rows($resultStudent);
if($rows){
$RSStudent = mysql_fetch_object($resultStudent);
$provinceData[0] = base64_encode($_Config_college_code);
$provinceData[1] = base64_encode($RSStudent->homeProvinceId);
$provinceData[2] = base64_encode($RSStudent->studentM);
$provinceData[3] = base64_encode($RSStudent->studentF);
$client->call('importToStudentByProvince',array('data'=>$provinceData));
}
}
//-- studentByLevel
//--New
$strQueryAcadYear = "select admitAcadYear from StudentMaster group by admitAcadYear";
$resultAcadYear = mysql_query($strQueryAcadYear);
while($RSAcadYear = mysql_fetch_object($resultAcadYear)){
$strQueryLevel = "select levelId from Level";
$resultLevel = mysql_query($strQueryLevel);
while($RSLevel = mysql_fetch_object($resultLevel)){
$strQueryStudent = "SELECT admitAcadYear , levelId , (select COUNT(*) from StudentMaster where studentSex = 'M' and studentStatus = '1' and studentYear = '1' and levelId = '".$RSLevel->levelId."' and admitAcadYear = '".$RSAcadYear->admitAcadYear."' GROUP BY admitAcadYear) as studentM , (select COUNT(*) from StudentMaster where studentSex = 'F' and studentStatus = '1' and studentYear = '1' and levelId = '".$RSLevel->levelId."' and admitAcadYear = '".$RSAcadYear->admitAcadYear."' GROUP BY admitAcadYear) as studentF FROM StudentMaster WHERE studentStatus = '1' and studentYear = '1' and levelId = '".$RSLevel->levelId."' and admitAcadYear = '".$RSAcadYear->admitAcadYear."' GROUP BY admitAcadYear";
$resultStudent = mysql_query($strQueryStudent);
$rows = mysql_num_rows($resultStudent);
if($rows){
$RSStudent = mysql_fetch_object($resultStudent);
$levelData[0] = base64_encode($_Config_college_code);
$levelData[1] = base64_encode($RSStudent->admitAcadYear);
$levelData[2] = base64_encode($RSStudent->levelId);
$levelData[3] = base64_encode($RSStudent->studentM);
$levelData[4] = base64_encode($RSStudent->studentF);
$levelData[5] = base64_encode("1");
$client->call('importToStudentByLevel',array('data'=>$levelData));
}
}
}
//-- studentByLevel
//--All
$strQueryAcadYear = "select admitAcadYear from StudentMaster group by admitAcadYear";
$resultAcadYear = mysql_query($strQueryAcadYear);
while($RSAcadYear = mysql_fetch_object($resultAcadYear)){
$strQueryLevel = "select levelId from Level";
$resultLevel = mysql_query($strQueryLevel);
while($RSLevel = mysql_fetch_object($resultLevel)){
$strQueryStudent = "SELECT admitAcadYear , levelId , (select COUNT(*) from StudentMaster where studentSex = 'M' and studentStatus = '1' and levelId = '".$RSLevel->levelId."' and admitAcadYear = '".$RSAcadYear->admitAcadYear."' GROUP BY admitAcadYear) as studentM , (select COUNT(*) from StudentMaster where studentSex = 'F' and studentStatus = '1' and levelId = '".$RSLevel->levelId."' and admitAcadYear = '".$RSAcadYear->admitAcadYear."' GROUP BY admitAcadYear) as studentF FROM StudentMaster WHERE studentStatus = '1' and levelId = '".$RSLevel->levelId."' and admitAcadYear = '".$RSAcadYear->admitAcadYear."' GROUP BY admitAcadYear";
$resultStudent = mysql_query($strQueryStudent);
$rows = mysql_num_rows($resultStudent);
if($rows){
$RSStudent = mysql_fetch_object($resultStudent);
$levelData[0] = base64_encode($_Config_college_code);
$levelData[1] = base64_encode($RSStudent->admitAcadYear);
$levelData[2] = base64_encode($RSStudent->levelId);
$levelData[3] = base64_encode($RSStudent->studentM);
$levelData[4] = base64_encode($RSStudent->studentF);
$levelData[5] = base64_encode("2");
$client->call('importToStudentByLevel',array('data'=>$levelData));
}
}
}
//-- studentByLevel
//--Graduate
$strQueryAcadYear = "select admitAcadYear from StudentMaster group by admitAcadYear";
$resultAcadYear = mysql_query($strQueryAcadYear);
while($RSAcadYear = mysql_fetch_object($resultAcadYear)){
$strQueryLevel = "select levelId from Level";
$resultLevel = mysql_query($strQueryLevel);
while($RSLevel = mysql_fetch_object($resultLevel)){
$strQueryStudent = "SELECT admitAcadYear , levelId , (select COUNT(*) from StudentMaster where studentSex = 'M' and studentStatus = '4' and levelId = '".$RSLevel->levelId."' and admitAcadYear = '".$RSAcadYear->admitAcadYear."' GROUP BY admitAcadYear) as studentM , (select COUNT(*) from StudentMaster where studentSex = 'F' and studentStatus = '4' and levelId = '".$RSLevel->levelId."' and admitAcadYear = '".$RSAcadYear->admitAcadYear."' GROUP BY admitAcadYear) as studentF FROM StudentMaster WHERE studentStatus = '4' and levelId = '".$RSLevel->levelId."' and admitAcadYear = '".$RSAcadYear->admitAcadYear."' GROUP BY admitAcadYear";
$resultStudent = mysql_query($strQueryStudent);
$rows = mysql_num_rows($resultStudent);
if($rows){
$RSStudent = mysql_fetch_object($resultStudent);
$levelData[0] = base64_encode($_Config_college_code);
$levelData[1] = base64_encode($RSStudent->admitAcadYear);
$levelData[2] = base64_encode($RSStudent->levelId);
$levelData[3] = base64_encode($RSStudent->studentM);
$levelData[4] = base64_encode($RSStudent->studentF);
$levelData[5] = base64_encode("3");
$client->call('importToStudentByLevel',array('data'=>$levelData));
}
}
}
?>
<table width="66%" border="0" align="center" cellpadding="0" cellspacing="0" class="BORDER-GREY">
<tr bgcolor="#F9FBFB">
<td height="22" colspan="2" align="center" ><strong>ยืนยันการส่งข้อมูล</strong></td>
</tr>
<tr bgcolor="#F9FBFB">
<td width="77%" height="22" align="center" class="BORDER-TOP">ข้อมูล</td>
<td width="23%" align="center" class="BORDER-TOP-LEFT">สถานะ</td>
</tr>
<?php
$resYear = $client->call('getStudentByYearID',array('collogeCode'=>base64_encode($_Config_college_code)));
$resProgram = $client->call('getStudentByProgramID',array('collogeCode'=>base64_encode($_Config_college_code)));
$resProvince= $client->call('getStudentByProvinceID',array('collogeCode'=>base64_encode($_Config_college_code)));
$resLevelNew = $client->call('getStudentByLevelID',array('collogeCode'=>base64_encode($_Config_college_code),'statusId'=>base64_encode("1")));
$resLevelAll = $client->call('getStudentByLevelID',array('collogeCode'=>base64_encode($_Config_college_code),'statusId'=>base64_encode("2")));
$resLevelGD = $client->call('getStudentByLevelID',array('collogeCode'=>base64_encode($_Config_college_code),'statusId'=>base64_encode("3")));
$dataYear = split(',',$resYear);
$dataProgram = split(',',$resProgram);
$dataProvince = split(',',$resProvince);
$dataLevelNew = split(',',$resLevelNew[0]);
$dataAdmitAcadYearNew = split(',',$resLevelNew[1]);
$dataLevelAll = split(',',$resLevelAll[0]);
$dataAdmitAcadYearAll = split(',',$resLevelAll[1]);
$dataLevelGD = split(',',$resLevelGD[0]);
$dataAdmitAcadYearGD = split(',',$resLevelGD[1]);
$status = false;
for($i=0;$i<sizeof($dataYear);$i++){
$resultYear = $client->call('getStudentByYear',array('admitAcadYear'=>base64_encode($dataYear[$i]) , 'collogeCode'=>base64_encode($_Config_college_code)));
if($resultYear[4] == "1") $status = true;
}
?>
<tr bgcolor="#FFFFFF">
<td width="77%" height="22" align="left" class="BORDER-TOP"> <a href="javascript:;" onclick="NewWindow('sendStudentDataDetail.php?dataType=year','StudentDataDetail','600','500','yes')">ข้อมูลนักศึกษาจำแนกตามปีการศึกษา</a></td>
<td width="23%" align="center" class="BORDER-TOP-LEFT"><?=($status)?"<font color='green'>UPDATE</font>":"<font color='red'>INSERT</font>"?></td>
</tr>
<?php
$status = false;
for($i=0;$i<sizeof($dataProgram);$i++){
$resultProgram = $client->call('getStudentByProgram',array('programId'=>base64_encode($dataProgram[$i]) , 'collogeCode'=>base64_encode($_Config_college_code)));
if($resultProgram[4] == "1") $status = true;
}
?>
<tr bgcolor="#F9FBFB">
<td width="77%" height="22" align="left" class="BORDER-TOP"> <a href="javascript:;" onclick="NewWindow('sendStudentDataDetail.php?dataType=program','StudentDataDetail','600','500','yes')">ข้อมูลนักศึกษาจำแนกตามหลักสูตร</a></td>
<td width="23%" align="center" class="BORDER-TOP-LEFT"><?=($status )?"<font color='green'>UPDATE</font>":"<font color='red'>INSERT</font>"?></td>
</tr>
<?php
$status = false;
for($i=0;$i<sizeof($dataProvince);$i++){
$resultProvince = $client->call('getStudentByProvince',array('provinceId'=>base64_encode($dataProvince[$i]) , 'collogeCode'=>base64_encode($_Config_college_code)));
if($resultProvince[4] == "1") $status = true;
}
?>
<tr bgcolor="#FFFFFF">
<td width="77%" height="22" align="left" class="BORDER-TOP"> <a href="javascript:;" onclick="NewWindow('sendStudentDataDetail.php?dataType=province','StudentDataDetail','600','500','yes')">ข้อมูลนักศึกษาจำแนกตามจังหวัด</a></td>
<td width="23%" align="center" class="BORDER-TOP-LEFT"><?=($status)?"<font color='green'>UPDATE</font>":"<font color='red'>INSERT</font>"?></td>
</tr>
<?php
$status = false;
for($i=0;$i<sizeof($dataLevelNew);$i++){
$resultLevel = $client->call('getStudentByLevel',array('levelId'=>base64_encode($dataLevelNew[$i]) , 'collogeCode'=>base64_encode($_Config_college_code),'admitAcadYear'=>base64_encode($dataAdmitAcadYearNew[$i]),'statusId'=>base64_encode("1")));
if($resultLevel[6] == "1") $status = true;
}
?>
<tr bgcolor="#F9FBFB">
<td width="77%" height="22" align="left" class="BORDER-TOP"> <a href="javascript:;" onclick="NewWindow('sendStudentDataDetail.php?dataType=level','StudentDataDetail','600','500','yes')">ข้อมูลนักศึกษาจำแนกตามระดับการศึกษา</a></td>
<td width="23%" align="center" class="BORDER-TOP-LEFT"><?=($status)?"<font color='green'>UPDATE</font>":"<font color='red'>INSERT</font>"?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="46" colspan="2" align="center" class="BORDER-TOP">
<input type="button" value="ยืนยัน" style="cursor:pointer" onclick="javascript:window.location='sendStudentData.php?action=confirm'" /> <input type="button" value="ยกเลิก" style="cursor:pointer" onclick="javascript:window.location='sendStudentData.php?action=cancel'" />
</td>
</tr>
</table>
<?php
}
?>
|