oxuserlist.php

Go to the documentation of this file.

<?php

class oxUserList extends oxList
{

    public function __construct()
    {
        parent::__construct('oxuser');
    }


    public function loadWishlistUsers($sSearchStr)
    {
        $sSearchStr = oxDb::getInstance()->escapeString($sSearchStr);
        if (!$sSearchStr) {
            return;
        }

        $sSelect = "select oxuser.oxid, oxuser.oxfname, oxuser.oxlname from oxuser ";
        $sSelect .= "left join oxuserbaskets on oxuserbaskets.oxuserid = oxuser.oxid ";
        $sSelect .= "where oxuserbaskets.oxid is not null and oxuserbaskets.oxtitle = 'wishlist' ";
        $sSelect .= "and oxuserbaskets.oxpublic = 1 ";
        $sSelect .= "and ( oxuser.oxusername like '%$sSearchStr%' or oxuser.oxlname like '%$sSearchStr%')";
        $sSelect .= "and ( select 1 from oxuserbasketitems where oxuserbasketitems.oxbasketid = oxuserbaskets.oxid limit 1)";

        $this->selectString($sSelect);
    }
}