protected function _getSelect() { $ret = parent::_getSelect(); $ret->whereEquals('pool', $this->_getPool()); $ret->whereEquals('visible', 1); return $ret; }
protected function _beforeInsert(Kwf_Model_Row_Interface $row, $submitRow) { parent::_beforeInsert($row, $submitRow); if ($this->_model->hasColumn('component_id')) { $row->component_id = $this->_getCategoryDirectory()->dbId; } }
protected function _getSelect() { $ret = parent::_getSelect(); $ret->whereEquals('visible', 1); $ret->whereEquals('component_id', $this->_getParam('eventsComponentId')); return $ret; }
protected function _appendMetaData() { parent::_appendMetaData(); $c = Kwc_Admin::getAvailableComponents(); sort($c); $this->view->metaData['components'] = $c; }
protected function _initColumns() { parent::_initColumns(); $this->_columns->add(new Kwf_Grid_Column('name', trlKwf('Name'), 290)); $this->_columns->add(new Kwf_Grid_Column('settings_controller_url')); $this->_columns->add(new Kwf_Grid_Column('edit_components'))->setData(new Kwc_Mail_Editable_ComponentsController_EditComponentsData()); }
protected function _initColumns() { $this->setModel(Kwf_Model_Abstract::getInstance('Kwf_Component_Generator_Plugin_Tags_Trl_AdminModel')); $this->_columns->add(new Kwf_Grid_Column('text', trlKwf('Tag'), 300))->setEditor(new Kwf_Form_Field_TextField()); $this->_columns->add(new Kwf_Grid_Column('original_text', trlKwf('Original Tag'), 300)); parent::_initColumns(); }
protected function _getWhere() { $ret = parent::_getWhere(); $ret['flightId = ?'] = $this->_getParam('flightId'); $ret['mainCrew = ?'] = TRUE; return $ret; }
protected function _initColumns() { parent::_initColumns(); $this->_columns->add(new Kwf_Grid_Column('recipient', trlKwf('Recipient'), 200)); $this->_columns->add(new Kwf_Grid_Column_Datetime('date', trlKwf('Date'), 100)); $this->_columns->add(new Kwf_Grid_Column('ip', trlKwf('IP-Address'), 100)); }
protected function _getSelect() { $ret = parent::_getSelect(); $ret->whereEquals('user_id', $this->_getParam('user_id')); $ret->whereEquals('create_type', 'auto'); 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(); if ($this->_getParam('filter_id')) { $ret->whereEquals('filter_id', $this->_getParam('filter_id')); } return $ret; }
protected function _initColumns() { parent::_initColumns(); $this->_columns->add(new Kwf_Grid_Column('firstname')); $this->_columns->add(new Kwf_Grid_Column('lastname')); $this->_columns->add(new Kwf_Grid_Column('role'))->setData(new Kwf_Controller_Action_User_Users_RoleData()); $this->_columns->add(new Kwf_Grid_Column('email')); }
protected function _getWhere() { $ret = parent::_getWhere(); if ($this->_getParam('trainingId') != NULL) { $ret['trainingId = ?'] = $this->_getParam('trainingId'); } return $ret; }
protected function _getSelect() { $ret = parent::_getSelect(); if ($this->_hasComponentId) { $ret->whereEquals('component_id', $this->_getParam('componentId')); } return $ret; }
protected function _getWhere() { $users = Kwf_Registry::get('userModel'); $ret = parent::_getWhere(); $ret['status = ?'] = 0; $ret['userId = ?'] = $users->getAuthedUserId(); 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 _initColumns() { parent::_initColumns(); $this->_columns->add(new Kwf_Grid_Column('pos')); $this->_columns->add(new Kwf_Grid_Column('link', trlKwf('Link'), 600)); $this->_columns->add(new Kwf_Grid_Column('title', trlKwf('Title'), 200)); $this->_columns->add(new Kwf_Grid_Column('count', trlKwf('Count'), 50))->setCssClass('kwf-renderer-decimal'); $this->_columns->add(new Kwf_Grid_Column('percent', trlKwf('[%]'), 50)); }
protected function _initColumns() { parent::_initColumns(); $this->_columns->add(new Kwf_Grid_Column_Date('date', trlKwf('Date'))); $this->_columns->add(new Kwf_Grid_Column('code', trlKwf('Code'))); $this->_columns->add(new Kwf_Grid_Column('amount', trlcKwf('Amount of Money', 'Amount'), 50))->setRenderer('euroMoney'); $this->_columns->add(new Kwf_Grid_Column('used_amount', trlcKwf('Amount of Money', 'Used Amount'), 50))->setType('float')->setRenderer('euroMoney'); $this->_columns->add(new Kwf_Grid_Column('comment', trlKwf('Comment')))->setRenderer('nl2br'); }
protected function _initColumns() { parent::_initColumns(); $columns = $this->_columns; $columns->add(new Kwf_Grid_Column('id')); $columns->add(new Kwf_Grid_Column('firstname'))->setData(new Kwc_Newsletter_Detail_SubscriberData()); $columns->add(new Kwf_Grid_Column('lastname'))->setData(new Kwc_Newsletter_Detail_SubscriberData()); $columns->add(new Kwf_Grid_Column('email'))->setData(new Kwc_Newsletter_Detail_SubscriberData()); }
protected function _initColumns() { $this->_filters['value'] = array('type' => 'Button', 'skipWhere' => true, 'text' => 'Filter'); $this->_columns->add(new Kwf_Grid_Column('id', 'Id', 50)); $this->_columns->add(new Kwf_Grid_Column('value', 'Context', 100)); $this->_columns->add(new Kwf_Grid_Column('value2', 'Context2', 100)); $this->_columns->add(new Kwf_Grid_Column('type', 'Type', 50)); parent::_initColumns(); }
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() { $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; }
public function _initColumns() { parent::_initColumns(); $this->_columns->add(new Kwf_Grid_Column('name', trlKwf('Name'), 190)); $this->_columns->add(new Kwf_Grid_Column('street', trlKwf('Street'), 150))->setHidden(true); $this->_columns->add(new Kwf_Grid_Column('zip', trlKwf('ZIP'), 55)); $this->_columns->add(new Kwf_Grid_Column('city', trlKwf('City'), 120)); $this->_columns->add(new Kwf_Grid_Column('phone', trlKwf('Phone'), 120))->setHidden(true); $this->_columns->add(new Kwf_Grid_Column('fax', trlKwf('Fax'), 120))->setHidden(true); $this->_columns->add(new Kwf_Grid_Column('email', trlKwf('E-Mail'), 120))->setHidden(true); $this->_columns->add(new Kwf_Grid_Column('website', trlKwf('Website'), 120))->setHidden(true); }
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 _initColumns() { parent::_initColumns(); $this->_filters['type'] = array('type' => 'ComboBox', 'text' => trlKwf('Type'), 'data' => array(array('error', trlKwf('Error')), array('accessdenied', trlKwf('Access Denied')), array('notfound', trlKwf('Not Found'))), 'width' => 100); $this->_filters['text'] = array('type' => 'TextField', 'width' => 300); $columns = $this->_columns; $columns->add(new Kwf_Grid_Column_Datetime('date')); $columns->add(new Kwf_Grid_Column('type', trlKwf('Type'), 80)); $columns->add(new Kwf_Grid_Column('message', trlKwf('Message'), 300)); $columns->add(new Kwf_Grid_Column('request_uri', 'Uri', 200))->setRenderer('clickableLink'); $columns->add(new Kwf_Grid_Column('http_referer', 'Referer', 200))->setRenderer('clickableLink'); $columns->add(new Kwf_Grid_Column('user', trlKwf('User'), 200)); }
protected function _beforeSave(Kwf_Model_Row_Interface $row, $submitRow) { parent::_beforeSave($row, $submitRow); foreach ($this->_colNames as $colName) { if (!$row->{$colName}) { $row->{$colName} = null; } else { if ($row->{$colName} == ' ') { $row->{$colName} = ''; } } } }
protected function _hasPermissions($row, $action) { //damit keine gefakte project_id übergeben werden kann //isAllowedComponent schaut ja nur auf componentId $p = $row->getParentRow('Project'); if ($p->component_id != $this->_getParam('componentId')) { return false; } if (!$p->visible) { return false; } return parent::_hasPermissions($row, $action); }
protected function _getWhere() { $users = Kwf_Registry::get('userModel'); $employeesModel = Kwf_Model_Abstract::getInstance('Employees'); $employeesSelect = $employeesModel->select()->whereEquals('userId', $users->getAuthedUserId()); $employee = $employeesModel->getRow($employeesSelect); $ret = parent::_getWhere(); $employeeId = -1; if ($employee != NULL) { $employeeId = $employee->id; } $ret['employeeId = ?'] = $employeeId; return $ret; }