<?php
/**
 * The User Devices Model Class.
 *
 * @package  claud/afa-submission-manager
 * @since 1.0.0
 */

namespace AFASM\Includes\Models;

use AFASM\Includes\Plugins\AFASM_Constant;

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly.
}

/**
 * Class UserDevicesModel
 *
 * Hendler with user device data
 *
 * @since 1.0.0
 */
class AFASM_User_Devices_Model {

	/**
	 * Table name
	 *
	 * @var string
	 */
	private $table_name;

	/**
	 * UserQRCodeModel constructor.
	 */
	public function __construct() {
		global $wpdb;
		$this->table_name = $wpdb->prefix . AFASM_Constant::TABLE_USER_DEVICE;
	}

	/**
	 * Create new device register
	 *
	 * @param int    $user_id The user ID.
	 * @param string $device_id The device virtual ID.
	 * @param string $device_language The device language.
	 * @param string $expo_token The user token for push notification.
	 *
	 * @return int|false
	 */
	public function create( $user_id, $device_id, $device_language, $expo_token = '' ) {
		global $wpdb;

		$item = array(
			'user_id'         => $user_id,
			'device_id'       => $device_id,
			'device_language' => $device_language,
			'expo_token'      => $expo_token,
			'created_at'      => gmdate( 'Y-m-d H:i:s' ),
		);

		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery
		$results = $wpdb->insert(
			$this->table_name,
			$item
		);

		return $results;
	}

	/**
	 * Delete register
	 *
	 * @param string $expo_token The user token for push notification.
	 *
	 * @return int|false
	 */
	public function delete_register_by_expo_token( $expo_token ) {
		global $wpdb;

		$item = array(
			'expo_token' => $expo_token,
		);

		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
		$results = $wpdb->delete(
			$this->table_name,
			$item
		);

		return $results;
	}

	/**
	 * Delete register
	 *
	 * @param int $user_id The user ID.
	 *
	 * @return int|false
	 */
	public function delete_register_by_user_id( $user_id ) {
		global $wpdb;

		$item = array(
			'user_id' => $user_id,
		);

		$item_format = array(
			'%d',
		);

		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
		$results = $wpdb->delete(
			$this->table_name,
			$item,
			$item_format
		);

		return $results;
	}

	/**
	 * Get device register by expo_token
	 *
	 * @param string $expo_token The user token for push notification.
	 *
	 * @return object
	 */
	public function get_register_by_user_expo_token( $expo_token ) {
		global $wpdb;

		$sql = 'SELECT * FROM %i WHERE expo_token=%s';

		$sql = $wpdb->prepare( $sql, array( $this->table_name, $expo_token ) );// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

		// phpcs:ignore
		$results = $wpdb->get_results( $sql, OBJECT );

		if ( count( $results ) > 0 ) {
			return $results[0];
		}

		return null;
	}

	/**
	 * Get device register by expo_token
	 *
	 * @param string $device_id The device virtual ID.
	 *
	 * @return object
	 */
	public function get_register_by_user_device_id( $device_id ) {
		global $wpdb;

		$sql = 'SELECT * FROM %i WHERE device_id=%s';

		$sql = $wpdb->prepare( $sql, array( $this->table_name, $device_id ) );// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

		// phpcs:ignore
		$results = $wpdb->get_results( $sql, OBJECT );

		if ( count( $results ) > 0 ) {
			return $results[0];
		}

		return null;
	}

	/**
	 * Get enabled device register for push notification by notification type
	 *
	 * @param int $notification_type_id The notification type id.
	 *
	 * @return array
	 */
	public function get_enabled_register_by_notification_type( $notification_type_id ) {
		global $wpdb;

		$table_notification_subscription = $wpdb->prefix . AFASM_Constant::TABLE_NOTIFICATION_SUBSCRIPTION;

		$sql = 'SELECT afasm_tud.id, afasm_tud.user_id, afasm_tud.expo_token, afasm_tud.device_language FROM %i afasm_tud INNER JOIN %i afasm_tns ON afasm_tud.id = afasm_tns.user_devices_id AND afasm_tns.enabled = 1 WHERE afasm_tns.notification_type_id = %d';

		$sql = $wpdb->prepare( $sql, array( $this->table_name, $table_notification_subscription, $notification_type_id ) );// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

		// phpcs:ignore
		$results = $wpdb->get_results( $sql, OBJECT );

		return $results;
	}

	/**
	 * Update device register
	 *
	 * @param int    $user_id The user ID.
	 * @param string $device_id The device virtual ID.
	 * @param string $device_language The device language.
	 * @param string $expo_token The user token for push notification.
	 *
	 * @return int|false
	 */
	public function update( $user_id, $device_id, $device_language, $expo_token = '' ) {
		global $wpdb;

		$item = array(
			'device_language' => $device_language,
			'expo_token'      => $expo_token,
		);

		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
		$results = $wpdb->update(
			$this->table_name,
			$item,
			array(
				'user_id'   => $user_id,
				'device_id' => $device_id,
			)
		);

		return $results;
	}

	/**
	 * Create new device register if not exist or update
	 *
	 * @param int    $user_id The user ID.
	 * @param string $device_id The device virtual ID.
	 * @param string $device_language The device language.
	 * @param string $expo_token The user token for push notification.
	 *
	 * @return int|false
	 */
	public function create_device_register_if_not_exist( $user_id, $device_id, $device_language, $expo_token = '' ) {
		$device_register = $this->get_register_by_user_device_id( $device_id );

		if ( empty( $device_register ) ) {
			return $this->create( $user_id, $device_id, $device_language, $expo_token );
		}

		return $this->update( $user_id, $device_id, $device_language, $expo_token );
	}

	/**
	 * Update language device register
	 *
	 * @param int    $user_id The user ID.
	 * @param string $device_id The device virtual ID.
	 * @param string $device_language The device language.
	 *
	 * @return int|false
	 */
	public function language( $user_id, $device_id, $device_language ) {
		global $wpdb;

		$item = array(
			'device_language' => $device_language,
		);

		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
		$results = $wpdb->update(
			$this->table_name,
			$item,
			array(
				'user_id'   => $user_id,
				'device_id' => $device_id,
			)
		);

		return $results;
	}
}