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