public function sGetPremiumDispatches($countryID = null,
$paymentID = null,
$stateId = null
) { $this->
sCreateHolidaysTable();
$basket =
$this->
sGetDispatchBasket($countryID,
$paymentID,
$stateId);
$statements =
$this->connection->
createQueryBuilder() ->
select('id', 'bind_sql'
) ->
from('s_premium_dispatch'
) ->
where('active = 1 AND type IN (0)'
) ->
andWhere('bind_sql IS NOT NULL AND bind_sql != ""'
) ->
execute() ->
fetchAll(PDO::FETCH_KEY_PAIR
);
if (empty($basket)) { return [];
}