public function executeMultipleEdit(sfWebRequest $request) { if ($request->getParameter('projects_id') > 0) { $this->forward404Unless($this->projects = Doctrine_Core::getTable('Projects')->createQuery()->addWhere('id=?', $request->getParameter('projects_id'))->fetchOne(), sprintf('Object projects does not exist (%s).', $request->getParameter('projects_id'))); $this->checkProjectsAccess($this->projects); $this->checkDiscussionsAccess('edit', false, $this->projects); } else { $this->checkDiscussionsAccess('edit'); } $this->fields = array(); $choices = app::getItemsChoicesByTable('DiscussionsStatus', true); if (count($choices) > 1) { $this->fields['discussions_status_id'] = array('title' => t::__('Status'), 'choices' => $choices); } if ($request->getParameter('fields')) { if (strlen($request->getParameter('selected_items') == 0)) { exit; } foreach ($request->getParameter('fields') as $key => $value) { if (strlen($value) == 0 and !is_array($value)) { continue; } if ($key == 'discussions_status_id') { foreach (explode(',', $request->getParameter('selected_items')) as $pid) { if ($p = Doctrine_Core::getTable('Discussions')->find($pid)) { if ($p->getDiscussionsStatusId() != $value) { $p->setDiscussionsStatusId($value); $p->save(); if (strlen($p->getAssignedTo()) > 0) { Discussions::sendNotification($this, $p, array('status' => explode(',', $p->getAssignedTo())), $this->getUser()); } $c = new DiscussionsComments(); $c->setDiscussionsStatusId($value); $c->setDiscussionsId($pid); $c->setCreatedAt(date('Y-m-d H:i:s')); $c->setUsersId($this->getUser()->getAttribute('id')); $c->save(); } } } } else { Doctrine_Query::create()->update('Discussions')->set($key, $value)->whereIn('id', explode(',', $request->getParameter('selected_items')))->execute(); } } $this->redirect_to($request->getParameter('redirect_to'), $request->getParameter('projects_id'), $request->getParameter('discussions_id')); } }