HEX
Server: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.30
System: Linux iZj6c1151k3ad370bosnmsZ 3.10.0-1160.76.1.el7.x86_64 #1 SMP Wed Aug 10 16:21:17 UTC 2022 x86_64
User: root (0)
PHP: 7.4.30
Disabled: NONE
Upload Files
File: /var/www/html/www.winghung.com/wp-content/plugins/conversational-forms/classes/query/pii.php
<?php

/**
 * Class Qcformbuilder_Forms_Query_Pii
 *
 * Queries for saved values of a form that are PII for a given email.
 * Decorates Qcformbuilder_Forms_Query_Paginated and reduces results to PII fields only.
 */
class Qcformbuilder_Forms_Query_Pii
{
    /**
     * The form configuration
     *
     * @since 1.7.0
     *
     * @var array $form
     */
    protected $form;

    /**
     * The email address to search by
     *
     * @since 1.7.0
     *
     * @var string
     */
    protected $email;

    /**
     * Paginated query
     *
     * @since 1.7.0
     *
     * @var Qcformbuilder_Forms_Query_Paginated
     */
    protected $paginated;

    /**
     *
     * @since 1.7.0
     *
     * @var int
     */
    protected $limit;

    /**
     * Qcformbuilder_Forms_Query_Pii constructor.
     *
     * @since 1.7.0
     *
     * @param array $form The form configuration
     * @param string $email Email address to search PII by
     * @param Qcformbuilder_Forms_Query_Paginates $paginated
     * @param int $limit Optional. Total entries per page  of results. Default is 25.
     */
    public function __construct(array $form, $email, Qcformbuilder_Forms_Query_Paginates $paginated, $limit = 25)
    {
        $this->form = $form;
        $this->email = sanitize_email($email);
        $this->paginated = $paginated;
        $this->limit = qcformbuilder_forms_validate_number( $limit, 25, 100 );
    }

    /**
     * Get one page of results
     *
     * @since 1.7.0
     *
     * @param int $page Which page of results?
     * @return Qcformbuilder_Forms_Entry_Fields
     */
    public function get_page($page)
    {
        return $this->find_entries($page);

    }

    /**
     * Given an array of entry IDs, reduce to personally identifying fields only
     *
     * @since 1.7.0
     *
     * @param array $ids
     * @return array
     */
    public function reduce_results_to_pii(array $ids)
    {
        $results = [];
        foreach ($ids as $entry_id) {
            $entry = new Qcformbuilder_Forms_Entry($this->form, $entry_id);
            $entry->get_fields();
            $results[ $entry_id ] = [];
            /** @var Qcformbuilder_Forms_Entry_Field $field_value */
            foreach ($entry->get_fields() as $field_value) {
                $results[ $entry_id ][$field_value->field_id] = [];

                if (Qcformbuilder_Forms_Field_Util::is_personally_identifying($field_value->field_id, $this->form)
                    || Qcformbuilder_Forms_Field_Util::is_email_identifying_field($field_value->field_id, $this->form)
                ) {
                    $results[ $entry_id ][$field_value->field_id] = $field_value->get_value();
                }


            }

        }

        return $results;

    }

    /**
     * Finds entries belonging to this
     *
     * @since 1.7.0
     *
     * @param int $page Which page of results?
     * @return array
     */
    private function find_entries($page)
    {
        $featureContainer = \qcformbuilderwp\QcformbuilderFormsQueries\QcformbuilderFormsQueries();
        $entryValueSelect = $featureContainer
            ->getQueries()
            ->entryValuesSelect();
        foreach (Qcformbuilder_Forms_Forms::email_identifying_fields($this->form) as $field) {
            $entryValueSelect->is('value', $this->email);
        }

        return $this
            ->paginated
            ->set_page($page)
            ->set_limit($this->limit)
            ->select_values_for_form($entryValueSelect);
    }

}