rias\contactformextensions\elements\db\ContactFormSubmissionQuery

Complexity

Total Complexity

11

Size/Duplication

Total Lines	78
Duplicated Lines	0 %

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	message()	0	5	1
A	fromEmail()	0	5	1
A	form()	0	5	1
A	subject()	0	5	1
A	fromName()	0	5	1
A	beforePrepare()	0	35	6

<?php

namespace rias\contactformextensions\elements\db;

use craft\elements\db\ElementQuery;
use craft\helpers\Db;

class ContactFormSubmissionQuery extends ElementQuery
{
    public $form;
    public $subject;
    public $fromName;
    public $fromEmail;
    public $message;

    public function form($value)
    {
        $this->form = $value;

        return $this;
    }

    public function subject($value)
    {
        $this->subject = $value;

        return $this;
    }

    public function fromName($value)
    {
        $this->fromName = $value;

        return $this;
    }

    public function fromEmail($value)
    {
        $this->fromEmail = $value;

        return $this;
    }

    public function message($value)
    {
        $this->message = $value;

        return $this;
    }

    protected function beforePrepare(): bool
    {
        // join in the products table
        $this->joinElementTable('contactform_submissions');

        // select the columns
        $this->query->select([

The method select() does not exist on null.

            'contactform_submissions.form',
            'contactform_submissions.subject',
            'contactform_submissions.fromName',
            'contactform_submissions.fromEmail',
            'contactform_submissions.message',
        ]);

        if ($this->form) {
            $this->subQuery->andWhere(Db::parseParam('contactform_submissions.form', $this->form));

The method andWhere() does not exist on null.

        }

        if ($this->subject) {
            $this->subQuery->andWhere(Db::parseParam('contactform_submissions.subject', $this->subject));
        }

        if ($this->fromName) {
            $this->subQuery->andWhere(Db::parseParam('contactform_submissions.fromName', $this->fromName));
        }

        if ($this->fromEmail) {
            $this->subQuery->andWhere(Db::parseParam('contactform_submissions.fromEmail', $this->fromEmail));
        }

        if ($this->message) {
            $this->subQuery->andWhere(Db::parseParam('contactform_submissions.message', $this->message));
        }

        return parent::beforePrepare();
    }
}