sCreateHolidaysTable example

/** * Get dispatch methods * * @param int $countryID Country id * @param int $paymentID Payment mean id * @param int $stateId Country state id * * @return array<int, array<string, mixed>> Shipping methods data, indexed by ID */
    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);