oxuserlist.php

Go to the documentation of this file.
00001 <?php
00002 
00007 class oxUserList extends oxList
00008 {
00016     public function __construct( $sObjectsInListName = 'oxuser')
00017     {
00018         parent::__construct( 'oxuser');
00019     }
00020 
00021 
00029     public function loadWishlistUsers( $sSearchStr)
00030     {
00031         $sSearchStr = mysql_real_escape_string($sSearchStr);
00032         if (!$sSearchStr) {
00033             return;
00034         }
00035 
00036         $sSelect  = "select oxuser.oxid, oxuser.oxfname, oxuser.oxlname from oxuser ";
00037         $sSelect .= "left join oxuserbaskets on oxuserbaskets.oxuserid = oxuser.oxid ";
00038         $sSelect .= "where oxuserbaskets.oxid is not null and oxuserbaskets.oxtitle = 'wishlist' ";
00039         $sSelect .= "and oxuserbaskets.oxpublic = 1 ";
00040         $sSelect .= "and ( oxuser.oxusername like '%$sSearchStr%' or oxuser.oxlname like '%$sSearchStr%')";
00041         $sSelect .= "and ( select 1 from oxuserbasketitems where oxuserbasketitems.oxbasketid = oxuserbaskets.oxid limit 1)";
00042 
00043         $this->selectString($sSelect);
00044     }
00045 }

Generated on Thu Dec 4 12:04:57 2008 for OXID eShop CE by  doxygen 1.5.5