<?php

namespace App\Taxation\Cron;

use App\Taxation\Entity;
use Exception;
use Qs_Db_Obj;

class Obj extends Qs_Db_Obj
{
    protected $_tableAlias = 'Taxation';
    protected $_tableShortAlias = 't';

    public function getListSelect()
    {
        $select = $this->_db->select();
        $select->from($this->_getPair(), ['id', 'dueDate']);
        if (!($dates = $this->getFilter('dueDate'))) {
            throw  new Exception('dueDate filter are note defined');
        };
        $select->join($this->_getPair('Vendor', 'v'), '`v`.`id` = `t`.`vendorId`', [
            'vendorDbaName' => 'dbaName'
        ]);
        $select->where('`t`.`dueDate` IN(?)', $dates);
        $select->where('`t`.`status` = ?', Entity::STATUS_PENDING);
        $select->order('t.dueDate DESC');

        return $select;
    }
}