function OnIcon($db, $fac_id) { $fac_name = getFacName($db, $fac_id); switch ($fac_id) { case 5: //寒梅館 echo '<form method="POST" action="map-i.php"> <DIV style="position:absolute; top : 35px ; left : 610px ; "> <button type="button" onclick="clickIcon(5)" data-toggle="modal" data-target="#myModal" name="TC1"><img src="doushisha_icon.png" width="30px" height="30px" border="0"></button> </DIV> </form>'; break; case 6: //チャペル echo '<form method="POST" action="map-i.php"> <DIV style="position:absolute; top : 350px ; left : 290px ; "> <button type="button" onclick="clickIcon(6)" data-toggle="modal" data-target="#myModal" name="TC2"><img src="doushisha_icon.png" width="30px" height="30px" border="0"></button> </DIV> </form>'; break; case 7: //未定 echo '<form method="POST" action="map-i.php"> <DIV style="position:absolute; top : 225px ; left : 415px ; "> <button type="button" onclick="clickIcon(7)" data-toggle="modal" data-target="#myModal" name="TC3"><img src="doushisha_icon.png" width="30px" height="30px" border="0"></button> </DIV> </form>'; break; case 8: //未定 echo '<form method="POST" action="map-i.php"> <DIV style="position:absolute; top : 480px ; left : 950px ; "> <button type="button" onclick="clickIcon(8)" data-toggle="modal" data-target="#myModal" name="TC3"><img src="doushisha_icon.png" width="30px" height="30px" border="0"></button> </DIV> </form>'; break; case 5: break; case 6: break; default: break; } }
} //connect to database and load startup row $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database"); mysql_select_db($mysql_database, $bd) or die("Could not select database"); $qry = "SELECT * FROM `table_data` WHERE ID='Startup'"; $res = mysql_query($qry); if (!mysql_query($qry, $bd)) { die("An unexpected error occured while saving the record, Please try again!"); } $Startup = mysql_fetch_assoc($res); $status = $Startup['Data1']; if ($status == 0) { header("location: index.php?e=1"); } $Subject = getSubName(stripSubCode($Allocation)); $FacName = getFacName(stripFacEmpCode($Allocation)); $FacCode = strtolower(stripFacEmpCode($Allocation)); $ClientIP = HashString($_SERVER['REMOTE_ADDR']); //echo $_SERVER['REMOTE_ADDR'];echo "<br>"; //echo $ClientIP; //echo $Subject; //echo $FacName;echo "<br>"; //echo $FacCode; //Create a new table if the table doesn't exists $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database"); mysql_select_db($mysql_database, $bd) or die("Could not select database"); if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . $FacCode . "'")) == 0) { $query = "CREATE TABLE {$FacCode} LIKE `table_dummyfac`"; //$res=mysql_query($query); if (!mysql_query($query)) { die("An unexpected error occured while creating the new table");
$facSubMapData["sub"]["5"]["subDep"] = getSubDep(stripSubCode($row['Data5'])); $facSubMapData["sub"]["5"]["subFacName"] = getFacName(stripFacEmpCode($row['Data5'])); $facSubMapData["sub"]["5"]["subSubName"] = getSubName(stripSubCode($row['Data5'])); if ($row['Data6'] != NULL) { $facSubMapData["sub"]["6"]["subDep"] = getSubDep(stripSubCode($row['Data6'])); $facSubMapData["sub"]["6"]["subFacName"] = getFacName(stripFacEmpCode($row['Data6'])); $facSubMapData["sub"]["6"]["subSubName"] = getSubName(stripSubCode($row['Data6'])); } if ($row['Data7'] != NULL) { $facSubMapData["sub"]["7"]["subDep"] = getSubDep(stripSubCode($row['Data7'])); $facSubMapData["sub"]["7"]["subFacName"] = getFacName(stripFacEmpCode($row['Data7'])); $facSubMapData["sub"]["7"]["subSubName"] = getSubName(stripSubCode($row['Data7'])); } if ($row['Data8'] != NULL) { $facSubMapData["sub"]["8"]["sub8Dep"] = getSubDep(stripSubCode($row['Data8'])); $facSubMapData["sub"]["8"]["sub8FacName"] = getFacName(stripFacEmpCode($row['Data8'])); $facSubMapData["sub"]["8"]["sub8SubName"] = getSubName(stripSubCode($row['Data8'])); } header('Content-Type:application/json'); echo json_encode($facSubMapData, JSON_PRETTY_PRINT); } else { echo "Something Went Wrong while Getting Faculty List!"; } } //To Return Faculty List of a Department $mapClassDep = $_REQUEST['mapClassDep']; if ($mapClassDep != NULL) { $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database"); mysql_select_db($mysql_database, $bd) or die("Could not select database"); //For Faculty List $query = "SELECT name,empcode FROM `table_faculty_info` WHERE dep='" . $mapClassDep . "'";