protected function _getSelect()
{
$ret = parent::_getSelect();
$ret->whereEquals('visible', 1);
$ret->whereEquals('component_id', $this->_getParam('eventsComponentId'));
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
if ($this->_model->hasColumn('newsletter_component_id')) {
if ($this->_getParam('newsletterComponentId')) {
// check if newsletterComponentId is allowed for user
$acl = Kwf_Registry::get('acl')->getComponentAcl();
$c = Kwf_Component_Data_Root::getInstance()->getComponentById($this->_getParam('newsletterComponentId'), array('ignoreVisible' => true, 'limit' => 1));
if (!$acl->isAllowed(Kwf_Registry::get('userModel')->getAuthedUser(), $c)) {
throw new Kwf_Exception_AccessDenied();
}
$ret->whereEquals('newsletter_component_id', $this->_getParam('newsletterComponentId'));
} else {
$c = Kwf_Component_Data_Root::getInstance()->getComponentByDbId($this->_getParam('componentId'), array('ignoreVisible' => true, 'limit' => 1));
$ret->whereEquals('newsletter_component_id', $c->parent->dbId);
}
}
$mailComponent = $this->_getMailComponent();
$rs = $mailComponent->getComponent()->getRecipientSources();
foreach (array_keys($rs) as $key) {
if (isset($rs[$key]['select']) && $rs[$key]['model'] == get_class($this->_getModel())) {
$ret->merge($rs[$key]['select']);
}
}
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$ret->whereEquals('deleted', 0);
$ret->whereEquals('author_id', $this->_getParam('author_id'));
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$ret->whereEquals('pool', $this->_getPool());
$ret->whereEquals('visible', 1);
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$ret->whereEquals('user_id', $this->_getParam('user_id'));
$ret->whereEquals('create_type', 'manual');
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
if ($this->_hasComponentId) {
$ret->whereEquals('component_id', $this->_getParam('componentId'));
}
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
if ($this->_getParam('filter_id')) {
$ret->whereEquals('filter_id', $this->_getParam('filter_id'));
}
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
if ($this->_model->hasColumn('component_id')) {
$ret->whereEquals('component_id', $this->_getCategoryDirectory()->dbId);
}
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
if (!$this->_getParam('project_id')) {
return null;
}
$ret->whereEquals('project_id', $this->_getParam('project_id'));
return $ret;
}
protected function _getSelect()
{
if (preg_match('#^id:(.*)$#', $this->_getParam('query'), $m)) {
$s = $this->_model->select();
$s->whereEquals('id', $m[1]);
return $s;
}
return parent::_getSelect();
}
protected function _getSelect()
{
$ret = parent::_getSelect();
if ($this->_getParam('valuesqry') == 'true') {
$ret = new Kwf_Model_Select();
$ret->whereEquals('id', explode('|', $this->_getParam('query')));
}
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
if ($this->_getParam('positionId')) {
$s = new Kwf_Model_Select();
$s->whereEquals('groupId', $this->_getParam('positionId'));
$ret->where(new Kwf_Model_Select_Expr_Child_Contains('EmployeeFlightRoles', $s))->whereEquals('groupType', '1');
}
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$domains = Kwf_Controller_Action_Redirects_RedirectController::getDomains();
if ($domains) {
if (!$this->_getParam('query_domain_component_id')) {
$ret->whereEquals('domain_component_id', array_keys($domains));
}
}
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
if ($this->_getParam('query_empty')) {
$or = array();
$langs = self::getLanguages();
foreach ($langs as $lang) {
$or[] = new Kwf_Model_Select_Expr_Equal($lang, '');
}
$ret->where(new Kwf_Model_Select_Expr_Or($or));
}
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$pattern = Kwc_Abstract::getSetting($this->_getParam('componentClass'), 'stylesIdPattern');
if ($pattern) {
if (preg_match('#' . $pattern . '#', $this->_getParam('componentId'), $m)) {
$ret->whereEquals('ownStyles', $m[0]);
}
} else {
$ret->whereEquals('ownStyles', '');
}
$this->_formatSelectTag($ret);
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$componentId = $this->_getParam('componentId');
$component = Kwf_Component_Data_Root::getInstance()->getComponentByDbId($componentId, array('ignoreVisible' => true));
if (isset($component->parent->chained)) {
$component = $component->parent->chained;
}
$dbIds = array($component->dbId);
foreach (Kwc_Chained_Abstract_Component::getAllChainedByMaster($component, 'Trl') as $c) {
$dbIds[] = $c->dbId;
}
$ret->whereEquals('component_id', $dbIds);
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$users = Kwf_Registry::get('userModel');
$employeesModel = Kwf_Model_Abstract::getInstance('Employees');
$employeesSelect = $employeesModel->select()->whereEquals('userId', $users->getAuthedUserId());
$employee = $employeesModel->getRow($employeesSelect);
$employeeId = -1;
if ($employee != NULL) {
$employeeId = $employee->id;
}
$s = new Kwf_Model_Select();
$s->whereEquals('employeeId', $employeeId);
$ret->where(new Kwf_Model_Select_Expr_Child_Contains('TrainingResults', $s));
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$users = Kwf_Registry::get('userModel');
$employeesModel = Kwf_Model_Abstract::getInstance('Employees');
$employeesSelect = $employeesModel->select()->whereEquals('userId', $users->getAuthedUserId());
$employee = $employeesModel->getRow($employeesSelect);
$employeeId = -1;
if ($employee != NULL) {
$employeeId = $employee->id;
}
$s = new Kwf_Model_Select();
$s->where(new Kwf_Model_Select_Expr_Sql("employeeId = " . $employeeId . " AND Hidden = 0"));
$ret->where(new Kwf_Model_Select_Expr_Child_Contains('Flightgroups', $s))->order('flightStartTime');
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$ret->whereEquals('status', array('ordered', 'payed'));
if ($this->_getParam('query_canceled')) {
$ret->whereEquals('canceled', 1);
} else {
$ret->whereEquals('canceled', 0);
}
if (!$this->_getParam('query_shipped')) {
$ret->where(new Kwf_Model_Select_Expr_IsNull('shipped'));
} else {
$ret->where(new Kwf_Model_Select_Expr_Not(new Kwf_Model_Select_Expr_IsNull('shipped')));
}
$ret->whereEquals('checkout_component_id', $this->_getParam('componentId'));
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$authedChangedRole = Zend_Registry::get('userModel')->getAuthedChangedUserRole();
$acl = Zend_Registry::get('acl');
if (!$acl->getRole($authedChangedRole) instanceof Kwf_Acl_Role_Admin) {
//wenn nicht superuser
foreach ($acl->getRoles() as $role) {
if ($role instanceof Kwf_Acl_Role && !$role instanceof Kwf_Acl_Role_Admin) {
$roles[] = $role->getRoleId();
}
}
$roles = array_values(array_unique($roles));
$ret->whereEquals('role', $roles);
}
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$ret->whereEquals('status', 'new');
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$ret->whereEquals('newsletter_component_id', $this->_getParam('componentId'));
return $ret;
}
protected function _getSelect()
{
$select = parent::_getSelect();
$select->whereEquals('newsletter_id', $this->_getNewsletterRow()->id);
return $select;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$ret->whereEquals('shop_order_id', $this->_getParam('shop_order_id'));
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$ret->group(array('user_id', 'article_id'));
return $ret;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$ret->whereEquals('deleted', false);
return $ret;
}
protected function _getSelect()
{
$select = parent::_getSelect();
$acl = Zend_Registry::get('acl');
if (!$acl->getRole($this->_getUserRole()) instanceof Kwf_Acl_Role_Admin) {
//admin always sees all roles
$roles = array();
foreach ($acl->getAllResources() as $res) {
if ($res instanceof Kwf_Acl_Resource_EditRole && $acl->isAllowed($this->_getUserRole(), $res, 'view')) {
$roles[] = $res->getRoleId();
}
}
if ($roles) {
$select->whereEquals('role', $roles);
} else {
$select = null;
}
}
if ($this->_getParam('query_role')) {
if ($acl->getRole($this->_getUserRole()) instanceof Kwf_Acl_Role_Admin) {
//admin always sees all roles, no need to validate it
$select->whereEquals('role', $this->_getParam('query_role'));
} else {
if (in_array($this->_getParam('query_role'), $roles)) {
$select->whereEquals('role', $this->_getParam('query_role'));
} else {
return null;
}
}
}
return $select;
}
protected function _getSelect()
{
$ret = parent::_getSelect();
$ret->whereEquals('is_spam', 0);
return $ret;
}
