/**
* returns Sql for export
*
* @param string $sWhere where part of sql
* @param int $iLanguage language id
* @param int $iShopID shop id
*
* @see objects/oxERPType#getSQL()
*
* @return string
*/
public function getSQL($sWhere, $iLanguage = 0, $iShopID = 1)
{
if (strstr($sWhere, 'where')) {
$sWhere .= ' and ';
} else {
$sWhere .= ' where ';
}
$sWhere .= 'oxordershopid = \'' . $iShopID . '\'';
return parent::getSQL($sWhere, $iLanguage, $iShopID);
}
/**
* returns SQL string for this type
*
* @param string $sWhere where part of sql
* @param int $iLanguage language id
* @param int $iShopId shop id
*
* @return string
*/
public function getSQL($sWhere, $iLanguage = 0, $iShopId = 1)
{
$myConfig = oxConfig::getInstance();
// add type 'user' for security reasons
if (strstr($sWhere, 'where')) {
$sWhere .= ' and ';
} else {
$sWhere .= ' where ';
}
$sWhere .= ' oxrights = \'user\'';
//MAFI also check for shopid to restrict access
return parent::getSQL($sWhere, $iLanguage, $iShopId);
}
