oxorderarticlelist.php

Go to the documentation of this file.

<?php

class oxOrderArticleList extends oxList
{

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

    public function loadOrderArticlesForUser($sOxId)
    {
        if (!$sOxId) {
            $this->clear();

            return;
        }

        $sSelect = "SELECT oxorderarticles.* FROM oxorder ";
        $sSelect .= "left join oxorderarticles on oxorderarticles.oxorderid = oxorder.oxid ";
        $sSelect .= "left join oxarticles on oxorderarticles.oxartid = oxarticles.oxid ";
        $sSelect .= "WHERE oxorder.oxuserid = " . oxDb::getDb()->quote($sOxId);

        $this->selectString($sSelect);

    }
}