<?php
/**
 * @author  Magediary
 * @package Magediary_ProductQuestion
 */

namespace Magediary\ProductQuestion\Model\ResourceModel\Answer;

use Magento\Framework\Model\ResourceModel\Db\Collection\AbstractCollection;

class Collection extends AbstractCollection
{
    /**
     * @var string
     */
    protected $_idFieldName = 'answer_id';

    /**
     * Define resource model
     *
     * @return void
     */
    protected function _construct()
    {
        $this->_init(
            \Magediary\ProductQuestion\Model\Answer::class,
            \Magediary\ProductQuestion\Model\ResourceModel\Answer::class
        );
    }

    /**
     * Add question filter
     *
     * @param mixed $quesion
     * @return $this
     */
    public function addQuestionFilter($quesion)
    {
        $inCond = $this->getConnection()->prepareSqlCondition('main_table.question_id', ['in' => $quesion]);
        $this->getSelect()->where($inCond);
        return $this;
    }

    /**
     * Add customer filter
     *
     * @param mixed $customer
     * @return $this
     */
    public function addCustomerFilter($customer)
    {
        $inCond = $this->getConnection()->prepareSqlCondition('main_table.customer_id', ['in' => $customer]);
        $this->getSelect()->where($inCond);
        return $this;
    }

    /**
     * Add status filter
     *
     * @param int|string $status
     * @return $this
     */
    public function addStatusFilter($status)
    {
        $inCond = $this->getConnection()->prepareSqlCondition('main_table.status', ['in' => $status]);
        $this->getSelect()->where($inCond);
        return $this;
    }

    /**
     * Set date order
     *
     * @param string $dir
     * @return $this
     */
    public function setDateOrder($dir = 'DESC')
    {
        $this->setOrder('main_table.created_at', $dir);
        return $this;
    }
}