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();