public function setThresholdPeriod($thresholdPeriod)
{
$this->thresholdPeriodYears = $thresholdPeriod;
$s = new Sql();
global $databaseName;
$connectValue = $s->connectToDatabase($databaseName);
$row = $s->insertToConfig($connectValue, $thresholdPeriod);
}
public function __construct($name)
{
$s = new Sql();
$connect = $s->connectToDatabase('recruit');
$jbID = $s->createJobPosition($connect, $name);
$this->jpID = $jbID;
$this->jobPositionName = $name;
}
public function getStatus()
{
$s = new Sql();
$connect = $s->connectToDatabase('recruit');
$data = mysqli_query($connect, "SELECT sessionstatus.status FROM sessionstatus,recruitmentsession WHERE recruitmentsession.sessionStatusID=sessionstatus.sessionStatusID AND RSID='{$this->RSID}'");
$row = $data->fetch_row();
return $row[0];
}
public function __construct($name, $jb)
{
$s = new Sql();
$connectValue = $s->connectToDatabase($databaseName);
$this->name = $name;
$this->dateCreated = date("Y-m-d");
$this->jobPosition = $jb;
$RSID = $s->setSessionQuery($connectValue, $name, $this->dateCreated, $jb);
echo "RecruitmentSession works " . $RSID . "";
//$recSesID = $RSID;
// Set session variables
//$_SESSION["rSessionID"] = $RSID;
}
},
function(data)
{
//alert(interviewname);
}
);
});
});
</script>
<?php
require_once "Sql.php";
require_once "GlobalVariables.php";
$s = new Sql();
$connect = $s->connectToDatabase($databaseName);
global $db, $user, $pass;
try {
$dbh = new PDO($db, $user, $pass);
$loadStatus = $dbh->prepare("SELECT sessionStatusID,status FROM sessionStatus");
if ($loadStatus->execute()) {
$loadStatus->setFetchMode(PDO::FETCH_ASSOC);
}
} catch (Exception $error) {
echo '<p>', $error->getMessage(), '</p>';
}
?>
</head>
<body>
txt += "<br>The path of the selected file: " + x.value; // If the browser does not support the files property, it will return the path of the selected file instead.
}
}
}
</script>
<?php
if (isset($_GET["id"])) {
$sessionID = $_GET["id"];
}
if (isset($_FILES['fileToUpload'])) {
$file = $_FILES['fileToUpload'];
$fileCount = count($file["name"]);
//Used only for viewing purposes
$text = "";
$s = new Sql();
$connectValue = $s->connectToDatabase($databaseName);
for ($i = 0; $i < $fileCount; $i++) {
$cv = $s->createNewCV($connectValue, $i);
$candidate = null;
//$sessionID = $_SESSION['rSessionID'];
//if (isset($_COOKIE['rSessionID'])){
//$sessionID = $_COOKIE['rSessionID'];
//}
//echo $_GET["id"];
//$sessionID = $_GET["id"];
// $sessionID="RS055";
echo "<ul id=\"feedBack\" class=\"list-group\">";
if ($cv != null) {
$candidate = $s->createNewCandidate($connectValue, $cv, $sessionID);
echo "<li class=\"list-group-item list-group-item-success\">" . $file["name"][$i] . " upload is successful</li>";
} else {
function __construct()
{
$s = new Sql();
$this->connectValue = $s->connectToDatabase('recruit');
}
