<?php

declare(strict_types=1);

namespace App\Model;

use Mosaico\Model\BaseModel;

class CustomerModel extends BaseModel
{
    public function getGuestCustomer($email)
    {
        $query = $this->connect()->query(
            "SELECT * 
            FROM customers 
            WHERE email = '" . $email . "'
            AND is_guest = 1
            ");
        return $query;
    }

    public function getAccount($email)
    {
        $query = $this->connect()->query(
            "SELECT * 
            FROM customers 
            WHERE email = '" . $email . "'
            AND is_guest = 0
            ");
        return $query;
    }

    public function getCustomerById($id)
    {
        $query = $this->connect()->query(
            "SELECT * 
            FROM customers 
            WHERE id_customer = " . $id . "
            ");
        return $query;
    }

    /**
     * [insertCustomer description]
     * @param  array $data
     * @return int id_customer
     */
    public function insertCustomer($data)
    {
        $this->connect()->query("
            INSERT IGNORE INTO customers SET
            firstname   = '" . $data['firstname'] . "',
            lastname    = '" . $data['lastname'] . "',
            email       =  '" . $data['email'] . "',
            street      =  '" . $data['street'] . "',
            city        =  '" . $data['city'] . "',
            id_state    =  '" . $data['id_state'] . "',
            zip_code    =  '" . $data['zip_code'] . "',
            phone       =  '" . $data['phone'] . "'
            ");

        return $this->connect()->getLastId();
    }

    public function getLastCustomerId()
    {
        $query = $this->connect()->query("
            SELECT max(id_customer) as id_customer FROM customers;
            ");
        return $query->row['id_customer'];
    }

    public function insertAccount($data)
    {
        $password = password_hash($data['password'], PASSWORD_BCRYPT);
        $this->connect()->query("
            INSERT INTO customers SET
            firstname   = '" . $data['firstname'] . "',
            lastname    = '" . $data['lastname'] . "',
            email       = '" . $data['email'] . "',
            phone       = '" . $data['phone'] . "',
            password    = '" . $password . "',
            is_guest    = 0
            ON DUPLICATE KEY UPDATE
            firstname   = '" . $data['firstname'] . "',
            lastname    = '" . $data['lastname'] . "',
            password    = '" . $password . "',
            phone       = '" . $data['phone'] . "',
            is_guest    = 0
            ");

        return $this->connect()->getLastId();
    }
}