oxorderarticlelist.php

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