public static function addTempAccessRequestAction($data, $userId)
{
try {
$db = Database::getInstance();
$conn = $db->getConnection();
$conn->beginTransaction();
HicreteLogger::logInfo("Adding temporary request");
$stmt = $conn->prepare("INSERT INTO `tempaccessrequestaction`(`requestId`, `actionBy`, `actionDate`, `remark`) \n VALUES (:requestId,:actionBy,now(),:remark)");
$stmt->bindParam(':requestId', $data->requestId, PDO::PARAM_STR);
$stmt->bindParam(':actionBy', $userId, PDO::PARAM_STR);
$stmt->bindParam(':remark', $data->remark, PDO::PARAM_STR);
$rollback = true;
HicreteLogger::logDebug("Query:\n " . json_encode($stmt));
HicreteLogger::logDebug("Data:\n " . json_encode($data));
if ($stmt->execute()) {
$stmt = $conn->prepare("UPDATE `tempaccessrequest` SET `status`=:status WHERE `requestId`=:requestId");
$stmt->bindParam(':requestId', $data->requestId, PDO::PARAM_STR);
$stmt->bindParam(':status', $data->status, PDO::PARAM_STR);
HicreteLogger::logDebug("Query:\n " . json_encode($stmt));
HicreteLogger::logDebug("Data:\n " . json_encode($data));
if ($stmt->execute()) {
if (strcasecmp($data->status, "Accepted") == 0) {
if (ConfigUtils::addTemporaryAccessPermission($conn, $data->requestId)) {
$rollback = false;
}
} else {
$rollback = false;
}
}
} else {
HicreteLogger::logError("Unknown databse error occured");
echo AppUtil::getReturnStatus("Unsuccessful", "Unknown database error occurred");
}
if ($rollback) {
$conn->rollback();
HicreteLogger::logError("Unknown databse error occured");
echo AppUtil::getReturnStatus("Unsuccessful", "Unknown database error occurred");
} else {
$conn->commit();
HicreteLogger::logInfo("Access request added");
echo AppUtil::getReturnStatus("Successful", "Access Request Added");
}
} catch (Exception $e) {
HicreteLogger::logFatal("Exception Occured Message:\n" . $e->getMessage());
echo AppUtil::getReturnStatus("Exception", $e->getMessage());
}
}
Config::getCompanyList($userId);
break;
case "getAllProcessUser":
ConfigUtils::getAllProcessUser($userId);
break;
case "getAccessApprovals":
if (appUtil::isSuperUser($userId)) {
ConfigUtils::getAccessApprovals();
} else {
echo appUtil::getReturnStatus("Unsuccessful", "You Do not have authority to view");
}
case "getAccessRequestList":
ConfigUtils::getAllAccessRequestForUser($userId);
break;
case "CancelTempAccessRequest":
ConfigUtils::CancelTempAccessRequest($data->requestId);
break;
}
/* $opt = array(
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
);
try{
$stmt = $conn->prepare("select * from userlogin where username=:username and password=:password");
$stmt->bindParam(':username', $params->username, PDO::PARAM_STR);
$stmt->bindParam(':password', $params->password, PDO::PARAM_STR);
$stmt->execute();
