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;
}
