/**
* Adds active promotion check
*
* @param array $aWhere SQL condition array
* @param string $sqlFull SQL query string
*
* @return $sQ
*/
protected function _prepareWhereQuery($aWhere, $sqlFull)
{
$sQ = parent::_prepareWhereQuery($aWhere, $sqlFull);
$sDisplayType = (int) oxRegistry::getConfig()->getRequestParameter('displaytype');
$sTable = getViewName("oxactions");
//searchong for empty oxfolder fields
if ($sDisplayType) {
$sNow = date('Y-m-d H:i:s', oxRegistry::get("oxUtilsDate")->getTime());
switch ($sDisplayType) {
case 1:
// active
$sQ .= " and {$sTable}.oxactivefrom < '{$sNow}' and {$sTable}.oxactiveto > '{$sNow}' ";
break;
case 2:
// upcoming
$sQ .= " and {$sTable}.oxactivefrom > '{$sNow}' ";
break;
case 3:
// expired
$sQ .= " and {$sTable}.oxactiveto < '{$sNow}' and {$sTable}.oxactiveto != '0000-00-00 00:00:00' ";
break;
}
}
return $sQ;
}
/**
* Adding folder check and empty folder field check.
*
* @param array $aWhere SQL condition array
* @param string $sqlFull SQL query string
*
* @return string
*/
protected function _prepareWhereQuery($aWhere, $sqlFull)
{
$sQ = parent::_prepareWhereQuery($aWhere, $sqlFull);
$sFolder = oxRegistry::getConfig()->getRequestParameter('folder');
$sViewName = getviewName("oxcontents");
//searchong for empty oxfolder fields
if ($sFolder == 'CMSFOLDER_NONE' || $sFolder == 'CMSFOLDER_NONE_RR') {
$sQ .= " and {$sViewName}.oxfolder = '' ";
} elseif ($sFolder && $sFolder != '-1') {
$sFolder = oxDb::getDb()->quote($sFolder);
$sQ .= " and {$sViewName}.oxfolder = {$sFolder}";
}
return $sQ;
}
/**
* Adding folder check
*
* @param array $aWhere SQL condition array
* @param string $sqlFull SQL query string
*
* @return $sQ
*/
protected function _prepareWhereQuery($aWhere, $sqlFull)
{
$oDb = oxDb::getDb();
$sQ = parent::_prepareWhereQuery($aWhere, $sqlFull);
$myConfig = $this->getConfig();
$aFolders = $myConfig->getConfigParam('aOrderfolder');
$sFolder = oxRegistry::getConfig()->getRequestParameter('folder');
//searchong for empty oxfolder fields
if ($sFolder && $sFolder != '-1') {
$sQ .= " and ( oxorder.oxfolder = " . $oDb->quote($sFolder) . " )";
} elseif (!$sFolder && is_array($aFolders)) {
$aFolderNames = array_keys($aFolders);
$sQ .= " and ( oxorder.oxfolder = " . $oDb->quote($aFolderNames[0]) . " )";
}
return $sQ;
}
/**
* Adding folder check
*
* @param array $whereQuery SQL condition array
* @param string $fullQuery SQL query string
*
* @return string
*/
protected function _prepareWhereQuery($whereQuery, $fullQuery)
{
$database = oxDb::getDb();
$query = parent::_prepareWhereQuery($whereQuery, $fullQuery);
$config = $this->getConfig();
$folders = $config->getConfigParam('aOrderfolder');
$folder = oxRegistry::getConfig()->getRequestParameter('folder');
// Searching for empty oxfolder fields
if ($folder && $folder != '-1') {
$query .= " and ( oxorder.oxfolder = " . $database->quote($folder) . " )";
} elseif (!$folder && is_array($folders)) {
$folderNames = array_keys($folders);
$query .= " and ( oxorder.oxfolder = " . $database->quote($folderNames[0]) . " )";
}
return $query;
}
/**
* Prepares SQL where query according SQL condition array and attaches it to SQL end.
* For each search value if german umlauts exist, adds them
* and replaced by spec. char to query
*
* @param array $whereQuery SQL condition array
* @param string $fullQuery SQL query string
*
* @return string
*/
public function _prepareWhereQuery($whereQuery, $fullQuery)
{
$nameWhere = null;
if (isset($whereQuery['oxuser.oxlname']) && ($name = $whereQuery['oxuser.oxlname'])) {
// check if this is search string (contains % sign at begining and end of string)
$isSearchValue = $this->_isSearchValue($name);
$name = $this->_processFilter($name);
$nameWhere['oxuser.oxfname'] = $nameWhere['oxuser.oxlname'] = $name;
unset($whereQuery['oxuser.oxlname']);
}
$query = parent::_prepareWhereQuery($whereQuery, $fullQuery);
if ($nameWhere) {
$values = explode(' ', $name);
$query .= ' and (';
$queryBoolAction = '';
$utilsString = oxRegistry::get("oxUtilsString");
foreach ($nameWhere as $fieldName => $fieldValue) {
//for each search field using AND action
foreach ($values as $value) {
$query .= " {$queryBoolAction} {$fieldName} ";
//for search in same field for different values using AND
$queryBoolAction = ' or ';
$query .= $this->_buildFilter($value, $isSearchValue);
// trying to search spec chars in search value
// if found, add cleaned search value to search sql
$uml = $utilsString->prepareStrForSearch($value);
if ($uml) {
$query .= " or {$fieldName} ";
$query .= $this->_buildFilter($uml, $isSearchValue);
}
}
}
// end for AND action
$query .= ' ) ';
}
return $query;
}
/**
* Prepares SQL where query according SQL condition array and attaches it to SQL end.
* For each search value if german umlauts exist, adds them
* and replaced by spec. char to query
*
* @param array $aWhere SQL condition array
* @param string $sQueryFull SQL query string
*
* @return string
*/
public function _prepareWhereQuery($aWhere, $sQueryFull)
{
$aNameWhere = null;
if (isset($aWhere['oxuser.oxlname']) && ($sName = $aWhere['oxuser.oxlname'])) {
// check if this is search string (contains % sign at begining and end of string)
$blIsSearchValue = $this->_isSearchValue($sName);
$sName = $this->_processFilter($sName);
$aNameWhere['oxuser.oxfname'] = $aNameWhere['oxuser.oxlname'] = $sName;
// unsetting..
unset($aWhere['oxuser.oxlname']);
}
$sQ = parent::_prepareWhereQuery($aWhere, $sQueryFull);
if ($aNameWhere) {
$aVal = explode(' ', $sName);
$sQ .= ' and (';
$sSqlBoolAction = '';
$myUtilsString = oxRegistry::get("oxUtilsString");
foreach ($aNameWhere as $sFieldName => $sValue) {
//for each search field using AND anction
foreach ($aVal as $sVal) {
$sQ .= " {$sSqlBoolAction} {$sFieldName} ";
//for search in same field for different values using AND
$sSqlBoolAction = ' or ';
$sQ .= $this->_buildFilter($sVal, $blIsSearchValue);
// trying to search spec chars in search value
// if found, add cleaned search value to search sql
$sUml = $myUtilsString->prepareStrForSearch($sVal);
if ($sUml) {
$sQ .= " or {$sFieldName} ";
$sQ .= $this->_buildFilter($sUml, $blIsSearchValue);
}
}
}
// end for AND action
$sQ .= ' ) ';
}
return $sQ;
}
/**
* Adding folder check
*
* @param array $aWhere SQL condition array
* @param string $sqlFull SQL query string
*
* @return $sQ
*/
public function _prepareWhereQuery($aWhere, $sqlFull)
{
$sQ = oxAdminList::_prepareWhereQuery($aWhere, $sqlFull);
$sQ .= " group by oxorderarticles.oxartnum";
return $sQ;
}
/**
* Adding folder check
*
* @param array $aWhere SQL condition array
* @param string $sqlFull SQL query string
*
* @return $sQ
*/
protected function _prepareWhereQuery($aWhere, $sqlFull)
{
$oDb = oxDb::getDb();
$sQ = parent::_prepareWhereQuery($aWhere, $sqlFull);
$myConfig = $this->getConfig();
$aFolders = $myConfig->getConfigParam('aOrderfolder');
$sFolder = oxConfig::getParameter('folder');
//searchong for empty oxfolder fields
if ($sFolder && $sFolder != '-1') {
$sQ .= " and ( oxorder.oxfolder = " . $oDb->quote($sFolder) . " ";
//deprecated check for old orders
$sQ .= "or oxorder.oxfolder = " . $oDb->quote(oxLang::getInstance()->translateString($sFolder)) . " )";
} elseif (!$sFolder && is_array($aFolders)) {
$aFolderNames = array_keys($aFolders);
$sQ .= " and ( oxorder.oxfolder = " . $oDb->quote($aFolderNames[0]) . " ";
//deprecated check for old orders
$sQ .= "or oxorder.oxfolder = " . $oDb->quote(oxLang::getInstance()->translateString($aFolderNames[0])) . " )";
}
return $sQ;
}
