OXID eShop CE  4.8.11
 All Classes Files Functions Variables Pages
oxorderarticlelist.php
Go to the documentation of this file.
1 <?php
2 
8 {
12  public function __construct()
13  {
14  parent::__construct('oxorderarticle');
15  }
16 
24  public function loadOrderArticlesForUser( $sOxId )
25  {
26  if (!$sOxId) {
27  $this->clear();
28  return;
29  }
30 
31  $sSelect = "SELECT oxorderarticles.* FROM oxorder ";
32  $sSelect .= "left join oxorderarticles on oxorderarticles.oxorderid = oxorder.oxid ";
33  $sSelect .= "left join oxarticles on oxorderarticles.oxartid = oxarticles.oxid ";
34  $sSelect .= "WHERE oxorder.oxuserid = ".oxDb::getDb()->quote( $sOxId );
35 
36  $this->selectString( $sSelect );
37 
38  }
39 
40 }