oxuseraddresslist.php

Go to the documentation of this file.

<?php

class oxUserAddressList extends oxList
{

    public function __construct()
    {
        parent::__construct('oxaddress');
    }

    public function load($sUserId)
    {
        $sViewName = getViewName('oxcountry');
        $oBaseObject = $this->getBaseObject();
        $sSelectFields = $oBaseObject->getSelectFields();

        $sSelect = "
                SELECT {$sSelectFields}, `oxcountry`.`oxtitle` AS oxcountry
                FROM oxaddress
                LEFT JOIN {$sViewName} AS oxcountry ON oxaddress.oxcountryid = oxcountry.oxid
                WHERE oxaddress.oxuserid = " . oxDb::getDb()->quote($sUserId);
        $this->selectString($sSelect);
    }
}