rias\contactformextensions\elements\db\ContactFormSubmissionQuery

Complexity

Total Complexity

13

Size/Duplication

Total Lines	92
Duplicated Lines	0 %

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	attachments()	0	5	1
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
B	beforePrepare()	0	40	7

<?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 $attachments;
    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 attachments($value)
    {
        $this->attachments = $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.attachments',
            '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->attachments) {
            $this->subQuery->andWhere(Db::parseParam('contactform_submissions.attachments', $this->attachments));
        }

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

        return parent::beforePrepare();
    }
}