/**
* update favorites to new filter syntax and update to 5.0
*
* @return void
*/
public function update_0()
{
$pfBackend = new Tinebase_PersistentFilter_Backend_Sql();
$filters = $pfBackend->getAll();
$projectFilters = $filters->filter('application_id', Tinebase_Application::getInstance()->getApplicationByName('Projects')->getId());
foreach ($projectFilters as $pfilter) {
foreach ($pfilter->filters as $filter) {
if ($filter->getField() === 'contact' && $filter instanceof Tinebase_Model_Filter_Relation) {
$values = array();
foreach ($filter->getValue() as $idx => $subfilter) {
$values[$idx] = $subfilter;
if (in_array($subfilter['field'], array('relation_type', 'id'))) {
$values[$idx]['field'] = ':' . $subfilter['field'];
}
}
$filter->setValue($values);
$pfBackend->update($pfilter);
}
}
}
$this->setApplicationVersion('Projects', '5.0');
}
/**
* update favorites to new filter syntax and update to 5.2
*
* @return void
*/
public function update_1()
{
$pfBackend = new Tinebase_PersistentFilter_Backend_Sql();
$filters = $pfBackend->getAll();
$timetrackerFilters = $filters->filter('application_id', Tinebase_Application::getInstance()->getApplicationByName('Timetracker')->getId());
foreach ($timetrackerFilters as $pfilter) {
foreach ($pfilter->filters as $filter) {
if (in_array($filter->getField(), array('timeaccount_id')) && $filter instanceof Tinebase_Model_Filter_ForeignId) {
$values = array();
foreach ($filter->getValue() as $idx => $subfilter) {
$values[$idx] = $subfilter;
if (in_array($subfilter['field'], array('id'))) {
$values[$idx]['field'] = ':' . $subfilter['field'];
}
}
$filter->setValue($values);
$pfBackend->update($pfilter);
}
}
}
$this->setApplicationVersion('Timetracker', '5.2');
}
/**
* add default grants to existing filters
*/
protected function _addGrantsToExistingFilters()
{
$pfBackend = new Tinebase_PersistentFilter_Backend_Sql();
$filters = $pfBackend->getAll();
$pfGrantsBackend = new Tinebase_Backend_Sql_Grants(array('modelName' => 'Tinebase_Model_PersistentFilterGrant', 'tableName' => 'filter_acl'));
$pfGrantsBackend->getGrantsForRecords($filters);
foreach ($filters as $filter) {
if (count($filter->grants) > 0) {
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Filter ' . $filter->name . ' already has grants.');
}
continue;
}
$grant = new Tinebase_Model_PersistentFilterGrant(array('account_type' => $filter->isPersonal() ? Tinebase_Acl_Rights::ACCOUNT_TYPE_USER : Tinebase_Acl_Rights::ACCOUNT_TYPE_ANYONE, 'account_id' => $filter->account_id, 'record_id' => $filter->getId()));
$grant->sanitizeAccountIdAndFillWithAllGrants();
$filter->grants = new Tinebase_Record_RecordSet('Tinebase_Model_PersistentFilterGrant');
$filter->grants->addRecord($grant);
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Updating filter "' . $filter->name . '" with grant: ' . print_r($grant->toArray(), true));
}
Tinebase_PersistentFilter::getInstance()->setGrants($filter);
}
}
