<?php

declare(strict_types=1);

namespace App\Model;

use Mosaico\Model\BaseModel;

class ContactModel extends BaseModel
{

    public function getContactList (): bool|object
    {
        $query = $this->connect()->query("
            SELECT 
            id_contact,
            name,
            email
            FROM contacts
        ");
        return $query;
    }

    public function getContactByEmail ($email): int|string
    {
        $query = $this->connect()->query("
            SELECT 
            id_contact,
            name,
            email
            FROM contacts
            WHERE email = '" . $email . "'
        ");
        return $query->num_rows > 0 ? (int) $query->row['id_contact'] : '';
    }

    public function getContactSubjects (): bool|object
    {
        $query = $this->connect()->query("
            SELECT 
            id_subject,
            subject,
            weight
            FROM contact_subjects
            ORDER BY weight ASC
        ");
        return $query;
    }

    public function getSubject ($id_subject): string
    {
        $query = $this->connect()->query("
            SELECT 
            subject
            FROM contact_subjects
            WHERE id_subject = " . $id_subject . "
        ");
        return $query->num_rows > 0 ? $query->row['subject'] : 'other';
    }

    public function addContact ($data): int
    {
        $query = $this->connect()->query("
            INSERT INTO contacts SET
            name    = '" . $data['name'] . "',
            email   = '" . $data['email'] . "'
        ");
        return $this->getMaxContactId();
    }

    public function addContactSubject ($data): void
    {
        $query = $this->connect()->query("
            INSERT INTO contact_subjects SET
            subject    = '" . $data['name'] . "',
            weight      = " . $data['weight'] . "
        ");
    }

    public function addContactData ($data): void
    {
        $query = $this->connect()->query("
            INSERT INTO contact_data SET
            id_contact  = " . $data['id_contact'] . ",
            id_subject  = " . $data['id_subject'] . ",
            subject     = '" . $data['subject'] . "',
            content     = '" . $data['content'] . "',
            ip          = '" . $data['ip'] . "',
            send_status = '" . $data['send_status'] . "'
        ");
    }

    public function getMaxContactId (): int
    {
        $query = $this->connect()->query("
            SELECT 
            MAX(id_contact) as id_contact
            FROM contacts
        ");
        return $query->num_rows > 0 ? (int) $query->row['id_contact'] : 0;
    }

    public function getContactData ()
    {
        $query = $this->connect()->query("
            SELECT 
            A.send_date,
            A.content,
            A.ip,
            A.send_status,
            B.subject,
            C.email,
            C.name
            FROM contact_data A
            LEFT JOIN contact_subjects B
            ON A.id_subject = B.id_subject
            LEFT JOIN contacts C
            ON A.id_contact = C.id_contact
        ");
        return $query;
    }
}