protected function beforeStoreStatement(array &$response, array &$params, \GO\Base\Data\AbstractStore &$store, \GO\Base\Db\FindParams $storeParams)
{
$multiSel = new \GO\Base\Component\MultiSelectGrid('ta-taskslists', "GO\\Tasks\\Model\\Tasklist", $store, $params);
$multiSel->setFindParamsForDefaultSelection($storeParams);
$multiSel->formatCheckedColumn();
return parent::beforeStoreStatement($response, $params, $store, $storeParams);
}
protected function beforeStoreStatement(array &$response, array &$params, \GO\Base\Data\AbstractStore &$store, \GO\Base\Db\FindParams $storeParams)
{
$storeParams->debugSql();
$multiSel = new \GO\Base\Component\MultiSelectGrid('books', "GO\\Addressbook\\Model\\Addressbook", $store, $params, true);
$multiSel->setFindParamsForDefaultSelection($storeParams);
$multiSel->formatCheckedColumn();
return parent::beforeStoreStatement($response, $params, $store, $storeParams);
}
protected function beforeStoreStatement(array &$response, array &$params, \GO\Base\Data\AbstractStore &$store, \GO\Base\Db\FindParams $storeParams)
{
//SELECT * FROM cal_categories t
//LEFT JOIN go_acl ON (`t`.`acl_id` = go_acl.acl_id AND (go_acl.user_id=57 OR go_acl.group_id IN (2)))
//WHERE t.calendar_id = 0 AND go_acl.acl_id IS NOT NULL OR t.calendar_id=56
$groupIds = \GO\Base\Model\User::getGroupIds(\GO::user()->id);
$storeCriteria = $storeParams->getCriteria();
$joinUserGroupCriteria = \GO\Base\Db\FindCriteria::newInstance()->addCondition('user_id', \GO::user()->id, '=', 'go_acl', false)->addInCondition('group_id', $groupIds, 'go_acl', false);
$joinCriteria = \GO\Base\Db\FindCriteria::newInstance()->addCondition('acl_id', 'go_acl.acl_id', '=', 't', true, true)->mergeWith($joinUserGroupCriteria);
$storeParams->join('go_acl', $joinCriteria, 'go_acl', 'LEFT');
if (!empty($params['global_categories']) && !empty($params['calendar_id'])) {
$storeCriteria->addCondition('calendar_id', 0, '=', 't', false);
$storeCriteria->addCondition('acl_id', NULL, 'IS NOT', 'go_acl');
$storeCriteria->addCondition('calendar_id', $params['calendar_id'], '=', 't', false);
} elseif (!empty($params['calendar_id'])) {
$storeCriteria->addCondition('calendar_id', $params['calendar_id']);
} else {
$storeCriteria->addCondition('calendar_id', 0);
}
$storeParams->ignoreAcl();
return parent::beforeStoreStatement($response, $params, $store, $storeParams);
}
protected function beforeStoreStatement(array &$response, array &$params, \GO\Base\Data\AbstractStore &$store, \GO\Base\Db\FindParams $storeParams)
{
if (!empty($params['filters'])) {
$abMultiSel = new \GO\Base\Component\MultiSelectGrid('books', "GO\\Addressbook\\Model\\Addressbook", $store, $params, true);
$abMultiSel->addSelectedToFindCriteria($storeParams, 'addressbook_id');
//$abMultiSel->setButtonParams($response);
//$abMultiSel->setStoreTitle();
$addresslistMultiSel = new \GO\Base\Component\MultiSelectGrid('addresslist_filter', "GO\\Addressbook\\Model\\Addresslist", $store, $params, false);
if (!empty($params['addresslist_filters'])) {
$addresslistMultiSel->addSelectedToFindCriteria($storeParams, 'addresslist_id', 'ac');
if (count($addresslistMultiSel->selectedIds)) {
//we need to join the addresslist link model if a filter for the addresslist is enabled.
$storeParams->join(\GO\Addressbook\Model\AddresslistCompany::model()->tableName(), \GO\Base\Db\FindCriteria::newInstance()->addCondition('id', 'ac.company_id', '=', 't', true, true), 'ac');
$storeParams->group('t.id');
}
}
}
return parent::beforeStoreStatement($response, $params, $store, $storeParams);
}
protected function beforeStoreStatement(array &$response, array &$params, \GO\Base\Data\AbstractStore &$store, \GO\Base\Db\FindParams $storeParams)
{
$storeParams->select('t.*')->criteria(\GO\Base\Db\FindCriteria::newInstance()->addCondition('domain_id', $params['domain_id']));
return parent::beforeStoreStatement($response, $params, $store, $storeParams);
}
protected function beforeStoreStatement(array &$response, array &$params, \GO\Base\Data\AbstractStore &$store, \GO\Base\Db\FindParams $storeParams)
{
$multiSel = new \GO\Base\Component\MultiSelectGrid('ta-taskslists', "GO\\Tasks\\Model\\Tasklist", $store, $params, true);
$multiSel->addSelectedToFindCriteria($storeParams, 'tasklist_id');
$multiSel->setButtonParams($response);
$multiSel->setStoreTitle();
$catMultiSel = new \GO\Base\Component\MultiSelectGrid('categories', "GO\\Tasks\\Model\\Category", $store, $params);
$catMultiSel->addSelectedToFindCriteria($storeParams, 'category_id');
return parent::beforeStoreStatement($response, $params, $store, $storeParams);
}
protected function beforeStoreStatement(array &$response, array &$params, \GO\Base\Data\AbstractStore &$store, \GO\Base\Db\FindParams $storeParams)
{
$storeParams->select('`t`.`folder_id`,`t`.`user_id`,`f`.`name`')->joinModel(array('model' => 'GO\\Files\\Model\\Folder', 'localTableAlias' => 't', 'localField' => 'folder_id', 'foreignField' => 'id', 'tableAlias' => 'f'))->getCriteria()->addCondition('user_id', \GO::user()->id);
return parent::beforeStoreStatement($response, $params, $store, $storeParams);
}
protected function beforeStoreStatement(array &$response, array &$params, \GO\Base\Data\AbstractStore &$store, \GO\Base\Db\FindParams $storeParams)
{
$storeParams->criteria(\GO\Base\Db\FindCriteria::newInstance()->addCondition('user_id', \GO::user()->id)->addCondition('user_id', 0, '=', 't', false));
return parent::beforeStoreStatement($response, $params, $store, $storeParams);
}
protected function beforeStoreStatement(array &$response, array &$params, \GO\Base\Data\AbstractStore &$store, \GO\Base\Db\FindParams $storeParams)
{
$storeParams->getCriteria()->addCondition('user_id', \GO::user()->id);
return parent::beforeStoreStatement($response, $params, $store, $storeParams);
}
protected function beforeStoreStatement(array &$response, array &$params, \GO\Base\Data\AbstractStore &$store, \GO\Base\Db\FindParams $storeParams)
{
$storeParams->joinModel(array('model' => 'GO\\Base\\Model\\UserGroup', 'localTableAlias' => 't', 'localField' => 'id', 'foreignField' => 'user_id', 'tableAlias' => 'ug'));
$storeParams->group('t.id');
$storeParams->export('users');
$groupsMultiSel = new \GO\Base\Component\MultiSelectGrid('users-groups-panel', "GO\\Base\\Model\\Group", $store, $params, true);
$groupsMultiSel->addSelectedToFindCriteria($storeParams, 'group_id', 'ug');
return parent::beforeStoreStatement($response, $params, $store, $storeParams);
}
