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 );

    }

}