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