protected function _getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage)
{
$iModule = 0;
if (strpos($sFilter, $this->sParamsDivider) !== false) {
list($iModule, $sFilter) = explode($this->sParamsDivider, $sFilter);
}
$aLanguage = array();
$iLanguage = $this->oDb->getLanguagesBy(array('type' => 'default'), $aLanguage);
if ($iLanguage <= 0 || empty($aLanguage)) {
$aLanguages = array();
$iLanguages = $this->oDb->getLanguagesBy(array('type' => 'active'), $aLanguages);
if ($iLanguages <= 0 || empty($aLanguages)) {
return array();
}
$aLanguage = $aLanguages[0];
}
$this->_aOptions['source'] = sprintf($this->_aOptions['source'], $aLanguage['id']);
if ((int) $iModule != 0) {
$this->_aOptions['source'] .= $this->oDb->prepare(" AND `tlk`.`IDCategory`=?", $iModule);
}
$aResults = parent::_getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage);
foreach ($aResults as $iIndex => $aResult) {
$aKey = $this->oDb->getKeyFullInfo($aResult['id'], $this->iPreviewLength);
if (empty($aKey)) {
continue;
}
$aResults[$iIndex]['module'] = $aKey['module'];
$aResults[$iIndex]['string'] = $aKey['strings'][$aLanguage['name']]['preview'];
$aResults[$iIndex]['languages'] = implode(', ', array_keys($aKey['strings']));
}
return $aResults;
}
protected function _getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage)
{
if (empty($this->sList)) {
return array();
}
$this->_aOptions['source'] .= $this->oDb->prepare(" AND `Key`=? ", $this->sList);
return parent::_getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage);
}
protected function _getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage)
{
if (empty($this->sObject) || empty($this->sDisplay)) {
return array();
}
$this->oDb->checkInputsInDisplays($this->sObject, $this->sDisplay);
$this->_aOptions['source'] = $this->oDb->prepare($this->_aOptions['source'], $this->sObject, $this->sDisplay);
return parent::_getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage);
}
protected function _getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage)
{
$sModule = '';
if (strpos($sFilter, $this->sParamsDivider) !== false) {
list($sModule, $sFilter) = explode($this->sParamsDivider, $sFilter);
}
if ($sModule != '') {
$this->_aOptions['source'] .= $this->oDb->prepare(" AND `module`=?", $sModule);
}
return parent::_getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage);
}
protected function _getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage)
{
$sModule = '';
if (strpos($sFilter, $this->sParamsDivider) !== false) {
list($sModule, $sFilter) = explode($this->sParamsDivider, $sFilter);
}
if ($sModule != '') {
$this->_aOptions['source'] .= $this->oDb->prepare(" AND `module`=?", $sModule);
}
$aResults = parent::_getDataSql($sFilter, !empty($sOrderField) ? $sOrderField : 'title', $sOrderDir, $iStart, $iPerPage);
$aLists = array();
$this->oDb->getLists(array('type' => 'pairs_list_values'), $aLists, false);
foreach ($aResults as $iKey => $aResult) {
if (isset($aLists[$aResult['key']])) {
$aResults[$iKey]['values_count'] = (int) $aLists[$aResult['key']];
}
}
return $aResults;
}
protected function _getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage)
{
if (empty($this->iLevel)) {
return array();
}
$sModule = '';
if (strpos($sFilter, $this->sParamsDivider) !== false) {
list($sModule, $sFilter) = explode($this->sParamsDivider, $sFilter);
}
if ($sModule != '') {
$this->_aOptions['source'] .= $this->oDb->prepare(" AND `Module`=?", $sModule);
}
$this->_aOptions['source'] .= $this->oDb->prepare(" AND (`DisabledForLevels`='0' OR `DisabledForLevels`&?=0)", pow(2, $this->iLevel - 1));
$aActions = parent::_getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage);
$aActionsActive = array();
$iActionsActive = $this->oDb->getActions(array('type' => 'by_level_id_key_id', 'value' => $this->iLevel), $aActionsActive);
foreach ($aActions as $iKey => $aAction) {
$aActions[$iKey]['Active'] = array_key_exists($aAction['ID'], $aActionsActive) ? 1 : 0;
}
return $aActions;
}
protected function _getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage)
{
$this->_aOptions['source'] .= $this->oDb->prepare("AND `IDLEvel`=? ", $this->iLevel);
return parent::_getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage);
}
protected function _getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage)
{
$this->_aOptions['source'] .= " AND `name`<>'system'";
$aData = array(array('id' => 0, 'title' => _t('_bx_dev_pgt_txt_manage_modules_all'), 'uri' => $this->sAllUri));
return array_merge($aData, parent::_getDataSql($sFilter, $sOrderField, $sOrderDir, $iStart, $iPerPage));
}
function __construct($aOptions, $oTemplate = false)
{
parent::__construct($aOptions, $oTemplate);
}
public function __construct($aOptions, $oTemplate = false)
{
parent::__construct($aOptions, $oTemplate);
$this->oDb = new BxDolStudioPermissionsQuery();
}