Files
sean 0e8a8b3028
Some checks failed
deploy-testing / deploy (push) Has been cancelled
Initial testing snapshot
2026-11-17 16:15:01 -05:00

356 lines
9.0 KiB
PHP

<?php
namespace WPGDPRC\Includes;
/**
* Class Requests
* @package WPGDPRC\Includes
*/
class AccessRequest {
/** @var null */
private static $instance = null;
/** @var int */
private $id = 0;
/** @var int */
private $siteId = 0;
/** @var string */
private $emailAddress = '';
/** @var string */
private $sessionId = '';
/** @var string */
private $ipAddress = '';
/** @var string */
private $token = '';
/** @var int */
private $expired = 0;
/** @var string */
private $dateCreated = '';
/**
* AccessRequest constructor.
* @param int $id
*/
public function __construct($id = 0) {
if ((int)$id > 0) {
$this->setId($id);
$this->load();
}
}
/**
* @param string $emailAddress
* @param string $sessionId
* @return bool|AccessRequest
*/
public function getByEmailAddressAndSessionId($emailAddress = '', $sessionId = '') {
global $wpdb;
$query = "SELECT * FROM `" . self::getDatabaseTableName() . "`";
$query .= " WHERE `email_address` = %s";
$query .= " AND `session_id` = %s";
$query .= " AND `expired` = '0'";
$query .= " AND `site_id` = %d";
$row = $wpdb->get_row($wpdb->prepare($query, $emailAddress, $sessionId, get_current_blog_id()));
if ($row !== null) {
return new self($row->ID);
}
return false;
}
/**
* @param string $token
* @return bool|AccessRequest
*/
public function getByToken($token = '') {
global $wpdb;
$query = "SELECT * FROM `" . self::getDatabaseTableName() . "`";
$query .= " WHERE `token` = %s";
$query .= " AND `expired` = '0'";
$query .= " AND `site_id` = %d";
$row = $wpdb->get_row($wpdb->prepare($query, $token, get_current_blog_id()));
if ($row !== null) {
return new self($row->ID);
}
return false;
}
/**
* @param array $filters
* @return int
*/
public function getTotal($filters = array()) {
global $wpdb;
$query = "SELECT COUNT(`ID`) FROM `" . self::getDatabaseTableName() . "` WHERE 1";
$query .= Helper::getQueryByFilters($filters);
$query .= sprintf(" AND `site_id` = %d", get_current_blog_id());
$result = $wpdb->get_var($query);
if ($result !== null) {
return absint($result);
}
return 0;
}
/**
* @param array $filters
* @param int $limit
* @param int $offset
* @return AccessRequest[]
*/
public function getList($filters = array(), $limit = 0, $offset = 0) {
global $wpdb;
$output = array();
$query = "SELECT * FROM `" . self::getDatabaseTableName() . "` WHERE 1";
$query .= Helper::getQueryByFilters($filters);
$query .= sprintf(" AND `site_id` = %d", get_current_blog_id());
$query .= " ORDER BY `date_created` DESC";
if (!empty($limit)) {
$query .= " LIMIT $offset, $limit";
}
$results = $wpdb->get_results($query);
if ($results !== null) {
foreach ($results as $row) {
$object = new self;
$object->loadByRow($row);
$output[] = $object;
}
}
return $output;
}
/**
* @param $row
*/
private function loadByRow($row) {
$this->setId($row->ID);
$this->setSiteId($row->site_id);
$this->setEmailAddress($row->email_address);
$this->setSessionId($row->session_id);
$this->setIpAddress($row->ip_address);
$this->setToken($row->token);
$this->setExpired($row->expired);
$this->setDateCreated($row->date_created);
}
public function load() {
global $wpdb;
$query = "SELECT * FROM `" . self::getDatabaseTableName() . "` WHERE `ID` = %d";
$row = $wpdb->get_row($wpdb->prepare($query, $this->getId()));
if ($row !== null) {
$this->loadByRow($row);
}
}
/**
* @param int $id
* @return bool
*/
public function exists($id = 0) {
global $wpdb;
$row = $wpdb->get_row(
$wpdb->prepare(
"SELECT * FROM `" . self::getDatabaseTableName() . "` WHERE `ID` = %d",
intval($id)
)
);
return ($row !== null);
}
/**
* @param string $emailAddress
* @param bool $nonExpiredOnly
* @return bool
*/
public function existsByEmailAddress($emailAddress = '', $nonExpiredOnly = false) {
global $wpdb;
$query = "SELECT * FROM `" . self::getDatabaseTableName() . "`";
$query .= " WHERE `email_address` = %s";
$query .= " AND `site_id` = %d";
if ($nonExpiredOnly === true) {
$query .= " AND `expired` = '0'";
}
$row = $wpdb->get_row($wpdb->prepare($query, $emailAddress, get_current_blog_id()));
return ($row !== null);
}
/**
* @return bool|int
*/
public function save() {
global $wpdb;
if ($this->exists($this->getId())) {
$wpdb->update(
self::getDatabaseTableName(),
array(
'email_address' => $this->getEmailAddress(),
'ip_address' => $this->getIpAddress(),
'expired' => $this->getExpired()
),
array('ID' => $this->getId()),
array('%s', '%s', '%d'),
array('%d')
);
return $this->getId();
} else {
$result = $wpdb->insert(
self::getDatabaseTableName(),
array(
'site_id' => $this->getSiteId(),
'email_address' => $this->getEmailAddress(),
'session_id' => $this->getSessionId(),
'ip_address' => $this->getIpAddress(),
'token' => $this->getToken(),
'expired' => $this->getExpired(),
'date_created' => date_i18n('Y-m-d H:i:s'),
),
array('%d', '%s', '%s', '%s', '%s', '%d', '%s')
);
if ($result !== false) {
$this->setId($wpdb->insert_id);
return $this->getId();
}
}
return false;
}
public function isAnonymised() {
return ($this->getIpAddress() === '127.0.0.1');
}
/**
* @return null|AccessRequest
*/
public static function getInstance() {
if (!isset(self::$instance)) {
self::$instance = new self();
}
return self::$instance;
}
/**
* @return int
*/
public function getId() {
return $this->id;
}
/**
* @param int $id
*/
public function setId($id) {
$this->id = $id;
}
/**
* @return int
*/
public function getSiteId() {
return $this->siteId;
}
/**
* @param int $siteId
*/
public function setSiteId($siteId) {
$this->siteId = $siteId;
}
/**
* @return string
*/
public function getEmailAddress() {
return $this->emailAddress;
}
/**
* @param string $emailAddress
*/
public function setEmailAddress($emailAddress) {
$this->emailAddress = $emailAddress;
}
/**
* @return string
*/
public function getSessionId() {
return $this->sessionId;
}
/**
* @param string $sessionId
*/
public function setSessionId($sessionId) {
$this->sessionId = $sessionId;
}
/**
* @return string
*/
public function getIpAddress() {
return $this->ipAddress;
}
/**
* @param string $ipAddress
*/
public function setIpAddress($ipAddress) {
$this->ipAddress = $ipAddress;
}
/**
* @return string
*/
public function getToken() {
return $this->token;
}
/**
* @param string $token
*/
public function setToken($token) {
$this->token = $token;
}
/**
* @return int
*/
public function getExpired() {
return $this->expired;
}
/**
* @param int $expired
*/
public function setExpired($expired) {
$this->expired = $expired;
}
/**
* @return string
*/
public function getDateCreated() {
return $this->dateCreated;
}
/**
* @param string $dateCreated
*/
public function setDateCreated($dateCreated) {
$this->dateCreated = $dateCreated;
}
/**
* @return bool
*/
public static function databaseTableExists() {
global $wpdb;
$result = $wpdb->query("SHOW TABLES LIKE '" . self::getDatabaseTableName() . "'");
return ($result === 1);
}
/**
* @return string
*/
public static function getDatabaseTableName() {
global $wpdb;
return $wpdb->base_prefix . 'wpgdprc_access_requests';
}
}