techdivision / import

 * @link      https://www.techdivision.com

 * @link      https://www.refusion.com

 */

class CustomerGroupRepository extends AbstractRepository implements CustomerGroupRepositoryInterface

{

    /**

     * The prepared statement to load the customer groups.

     *

     * @var \PDOStatement

     */

    protected $customerGroupsStmt;

    /**

     * Initializes the repository's prepared statements.

     *

     * @return void

     */

    public function init()

    {

        // initialize the prepared statements

        $this->customerGroupsStmt =

            $this->getConnection()->prepare($this->loadStatement(SqlStatementKeys::CUSTOMER_GROUPS));

    }

    /**

     * Returns an array with the available customer groups and their code as keys.

     *

     * @return array The array with the customer groups

     */

    public function findAll()

    {

        // initialize the array for the customer groups

        $customerGroups = [];

        // execute the prepared statement

        $this->customerGroupsStmt->execute();

        // fetch the customer groups and assemble them as array with the codes as key

        foreach ($this->customerGroupsStmt->fetchAll() as $customerGroup) {

            $customerGroups[$customerGroup[MemberNames::CUSTOMER_GROUP_CODE]] = $customerGroup;

        }

        // return the customer groups

        return $customerGroups;

    }

}

 * @link      https://github.com/techdivision/import

 * @link      http://www.techdivision.com

 */

class StoreWebsiteRepository extends AbstractRepository implements StoreWebsiteRepositoryInterface

{

    /**

     * The prepared statement to load the store websites.

     *

     * @var \PDOStatement

     */

    protected $storeWebsitesStmt;

    /**

     * Initializes the repository's prepared statements.

     *

     * @return void

     */

    public function init()

    {

        // initialize the prepared statements

        $this->storeWebsitesStmt =

            $this->getConnection()->prepare($this->loadStatement(SqlStatementKeys::STORE_WEBSITES));

    }

    /**

     * Return's an array with the available store websites and their

     * code as keys.

     *

     * @return array The array with all available store websites

     */

    public function findAll()

    {

        // initialize the array with the available store websites

        $storeWebsites = array();

        // execute the prepared statement

        $this->storeWebsitesStmt->execute();

        // fetch the store websites and assemble them as array with the codes as key

        foreach ($this->storeWebsitesStmt->fetchAll() as $storeWebsite) {

            $storeWebsites[$storeWebsite[MemberNames::CODE]] = $storeWebsite;

        }

        // return the array with the store websites

        return $storeWebsites;

    }

}

 * @link      https://github.com/techdivision/import

 * @link      http://www.techdivision.com

 */

class TaxClassRepository extends AbstractRepository implements TaxClassRepositoryInterface

{

    /**

     * Initializes the repository's prepared statements.

     *

     * @return void

     */

    public function init()

    {

        // initialize the prepared statements

        $this->taxClassesStmt =

            $this->getConnection()->prepare($this->loadStatement(SqlStatementKeys::TAX_CLASSES));

    }

    /**

     * Return's an array with the available tax classes and their

     * class names as keys.

     *

     * @return array The array with all available tax classes

     */

    public function findAll()

    {

        // initialize the array with the available tax classes

        $taxClasses = array();

        // execute the prepared statement

        $this->taxClassesStmt->execute();

        // fetch the tax classes and assemble them as array with the class name as key

        foreach ($this->taxClassesStmt->fetchAll() as $taxClass) {

            $taxClasses[$taxClass[MemberNames::CLASS_NAME]] = $taxClass;

        }

        // return the array with the tax classes

        return $taxClasses;

    }

}