<?php

declare(strict_types=1);

namespace App\Model;

use Mosaico\Model\BaseModel;

class MigrateCustomersModel extends BaseModel
{
    public function getCustomers(): bool|object
    {
        $query = $this->connectMagento()->query("
                SELECT
                entity_id,
                group_id,
                email,
                firstname,
                lastname
                FROM customer_entity
            ");
        return $query;
    }

    public function insertCustomer(array $data): bool
    {
        $query = $this->connect()->query("
            INSERT IGNORE INTO customers SET
            id_magento  = " . $data['entity_id'] . ",
            id_group_bc = " . $data['group_id'] . ",
            firstname   = '" . $data['firstname'] . "',
            lastname    = '" . $data['lastname'] . "',
            email       = '" . $data['email'] . "'
            ");

        return $query;
    }

}