<?php
/**
 * The Entry Model Class.
 *
 * @package  claud/afa-submission-manager
 * @since 1.0.0
 */

namespace AFASM\Includes\Models\WPF;

use AFASM\Includes\Models\AFASM_User_Model;
use AFASM\Includes\Models\WPF\AFASM_Form_Model;
use AFASM\Includes\Models\AFASM_Abstract_Entry_Model;
use AFASM\Includes\Plugins\Helpers\AFASM_Entry_Model_Helper;

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly.
}

/**
 * Class AbstractEntryModel
 *
 * Create model functions
 *
 * @since 1.0.0
 */
class AFASM_Entry_Model extends AFASM_Abstract_Entry_Model {

	/**
	 * Const to declare table name.
	 */
	const TABLE_NAME = 'wpforms_entries';

	/**
	 * The AFASM_Entry_Model_Helper
	 *
	 * @var AFASM_Entry_Model_Helper
	 */
	public $entry_model_helper;

	/**
	 * Table name with WP prefix
	 *
	 * @var string
	 */
	private $table_name_with_prefix;

	/**
	 * Entry model constructor
	 */
	public function __construct() {
		global $wpdb;
		$this->entry_model_helper     = new AFASM_Entry_Model_Helper( self::TABLE_NAME );
		$this->table_name_with_prefix = $wpdb->prefix . self::TABLE_NAME;
	}

	/**
	 * Get form entries
	 *
	 * @param int    $offset The offset.
	 * @param int    $number_of_records_per_page The posts per page.
	 * @param string $order_by The column name.
	 *
	 * @return array
	 */
	public function entries( $offset, $number_of_records_per_page, $order_by = 'entry_id' ) {
		$results = $this->entry_model_helper->entries( $offset, $number_of_records_per_page, $order_by );

		$entries = $this->prepare_data( $results );

		return $entries;
	}

	/**
	 * Get form entries
	 *
	 * @param int    $entry_id The form id.
	 * @param string $id The field.
	 *
	 * @return array
	 */
	public function entry_by_id( $entry_id, $id = 'entry_id' ) {
		$results = $this->entry_model_helper->entry_by_id( $entry_id, $id );

		$entries = $this->prepare_data( $results );

		if ( empty( $entries ) ) {
			return array();
		}

		return $entries[0];
	}

	/**
	 * Get Forms entries
	 *
	 * @param int $form_id The form id.
	 * @param int $offset The offset.
	 * @param int $number_of_records_per_page The posts per page.
	 *
	 * @return array
	 */
	public function entries_by_form_id( $form_id, $offset, $number_of_records_per_page ) {
		$results = $this->entry_model_helper->entries_by_form_id( $form_id, $offset, $number_of_records_per_page, 'entry_id' );
		$entries = $this->prepare_data( $results );
		return $entries;
	}

	/**
	 * Get form entries by user info
	 *
	 * @param string $user_info The user info.
	 * @param int    $offset The offset.
	 * @param int    $number_of_records_per_page The posts per page.
	 *
	 * @return array
	 */
	public function search_entries_by_user( $user_info, $offset, $number_of_records_per_page ) {
		global $wpdb;

		$sql = 'SELECT wpf.* FROM %i wpf INNER JOIN %i wpu ON  
        wpf.user_id = wpu.id WHERE wpu.user_login LIKE %s OR wpu.user_email LIKE %s ORDER BY wpf.entry_id DESC LIMIT %d,%d';

		$user_info = '%' . $wpdb->esc_like( $user_info ) . '%';

		$sql     = $wpdb->prepare( $sql, array( $this->table_name_with_prefix, $wpdb->users, $user_info, $user_info, $offset, $number_of_records_per_page ) );// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
		$results = $wpdb->get_results( $sql, OBJECT );// phpcs:ignore

		$entries = $this->prepare_data( $results );

		return $entries;

	}

	/**
	 * Count Forms entries
	 *
	 * @param int $form_id The form id.
	 *
	 * @return int
	 */
	public function mumber_of_items_by_form_id( $form_id ) {
		return $this->entry_model_helper->mumber_of_items_by_form_id( $form_id );
	}

	/**
	 * Count Forms entries
	 *
	 * @param string $user_info The user info.
	 *
	 * @return array
	 */
	public function mumber_of_items_by_user_info( $user_info ) {
		global $wpdb;

		$sql = 'SELECT count(*)  as number_of_rows FROM %i wpf INNER JOIN %i wpu ON  
        wpf.user_id = wpu.id WHERE wpu.user_login LIKE  %s OR wpu.user_email LIKE  %s ';

		$user_info = '%' . $wpdb->esc_like( $user_info ) . '%';

		$sql     = $wpdb->prepare( $sql, array( $this->table_name_with_prefix, $wpdb->users, $user_info, $user_info ) );// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
		$results = $wpdb->get_results( $sql, OBJECT );  // phpcs:ignore

		$number_of_rows = intval( $results[0]->number_of_rows );

		return $number_of_rows;
	}

	/**
	 * Format Forms entries
	 *
	 * @param array|object $results The entries data.
	 *
	 * @return array
	 */
	public function prepare_data( $results ) {
		$entries = array();

		foreach ( $results as $value ) {

			$entry = array();

			$entry['id']           = $value->entry_id;
			$entry['form_id']      = $value->form_id;
			$entry['date_created'] = $value->date;
			$entry['created_by']   = $value->user_id;
			$entry['author_info']  = array();

			if ( ! empty( $value->user_id ) ) {
				$user_model           = new AFASM_User_Model();
				$entry['author_info'] = $user_model->user_info_by_id( $value->user_id );
			}

			$form_model         = new AFASM_Form_Model();
			$entry['form_info'] = $form_model->form_by_id( $value->form_id );

			$entries[] = $entry;
		}

		return $entries;
	}

	/**
	 * Get the last  entry id
	 *
	 * @return int
	 */
	public function last_entry_id() {
		$result = $this->entry_model_helper->last_entry_id( 'entry_id' );
		return $result;
	}
}