<?php

use modules\contacts\Consts;

/**
 * @property ContactsBase $controller
 */
class ContactsModel_ extends Model implements Consts
{
    /**
     * Contact model
     * @param int|null $id
     * @param array $columns
     * @param array $with
     * @return \modules\contacts\models\Contact | \bff\db\illuminate\Model | array
     */
    public function contact($id = null, $columns = ['*'], array $with = [])
    {
        $model = $this->model('Contact');
        if (! empty($id)) {
            return $model->one($id, $columns, $with);
        }
        return $model;
    }

    /**
     * Список сообщений в админ-панели
     * @param array $filter
     * @param bool $countOnly
     * @param string $limit
     * @return int|mixed
     */
    public function contactsListing(array $filter, bool $countOnly = false, string $limit = '')
    {
        $filter = $this->prepareFilter($filter, 'C');

        if ($countOnly) {
            return (int)$this->db->one_data(
                'SELECT COUNT(C.id)
                FROM ' .  static::TABLE_CONTACTS . ' C' .
                $filter['where'],
                $filter['bind']
            );
        }

        return $this->db->select(
            'SELECT C.*
            FROM ' .  static::TABLE_CONTACTS . ' C
            ' . $filter['where'] . '
            ORDER BY C.created DESC ' . $limit,
            $filter['bind']
        );
    }

    /**
     * Метод обрабатывающий ситуацию с удалением пользователя
     * @param int $userID ID пользователя
     * @return void
     */
    public function deleteUserContacts($userID)
    {
        if (empty($userID)) {
            return;
        }
        $this->db->delete(static::TABLE_CONTACTS, ['user_id' => $userID]);
    }
}