oxorderarticlelist.php

Go to the documentation of this file.
00001 <?php
00002 
00007 class oxOrderArticleList extends oxList
00008 {
00012     public function __construct()
00013     {
00014         parent::__construct('oxorderarticle');
00015     }
00016 
00024     public function loadOrderArticlesForUser( $sOxId )
00025     {
00026         if (!$sOxId) {
00027             $this->clear();
00028             return;
00029         }
00030 
00031         $sSelect  = "SELECT oxorderarticles.* FROM oxorder ";
00032         $sSelect .= "left join oxorderarticles on oxorderarticles.oxorderid = oxorder.oxid ";
00033         $sSelect .= "left join oxarticles on oxorderarticles.oxartid = oxarticles.oxid ";
00034         $sSelect .= "WHERE oxorder.oxuserid = ".oxDb::getDb()->quote( $sOxId );
00035 
00036         $this->selectString( $sSelect );
00037 
00038     }
00039 
00040 }