public function executeReviews(sfWebRequest $request)
{
$op = $request->getParameter('o');
$this->f = $request->getParameter('f');
$culture = $this->getUser()->getCulture();
$this->sfReviewType = $request->getParameter("type_id", false);
$this->text = $request->getParameter("t", false);
$this->forward404Unless($this->getUser()->getGuardUser());
$c = new Criteria();
$c->add(PropuestaPeer::SF_GUARD_USER_ID, $this->getUser()->getGuardUser()->getId());
$c->addDescendingOrderByColumn('created_at');
$this->propuestas = PropuestaPeer::doSelect($c);
if ($op == 'v' || $op == 'e') {
$t = $request->getParameter('t');
$e = $request->getParameter('e');
$r = $request->getParameter('r');
if ($t == '') {
$review = SfReviewPeer::retrieveByPk($e);
$type = $review->getSfReviewType();
$peer = $type->getModel() . 'Peer';
$c = new Criteria();
$c->addJoin($peer::ID, SfReviewPeer::ENTITY_ID, Criteria::INNER_JOIN);
$c->add(SfReviewPeer::ID, $e);
$entity = $peer::doSelectOne($c);
$dest = $type->getModule() . "/show?id=" . $entity->getVanity();
} else {
$type = SfReviewTypePeer::retrieveByPk($t);
$peer = $type->getModel() . 'Peer';
$entity = $peer::retrieveByPK($e);
$dest = $type->getModule() . "/show?id=" . $entity->getVanity();
}
if ($op == 'e') {
$this->getUser()->setAttribute('review_v', 1);
$this->getUser()->setAttribute('review_e', $entity->getId());
$this->getUser()->setAttribute('review_c', $e);
}
if ($t == '') {
$dest .= "#subreviews_box{$e}";
} else {
if ($op == 'v') {
$dest .= "#sf_review_c_m{$r}";
}
}
$this->redirect($dest);
}
if (!$this->getUser()->isAuthenticated()) {
$this->getUser()->setFlash('notice_type', 'warning', true);
$this->getUser()->setFlash('notice', sfContext::getInstance()->getI18N()->__('¿Nuevo por aquí? Necesitas tener una cuenta Voota (o en Facebook) para continuar. Tu vooto será público o secreto, como gustes.', array()), true);
$this->getUser()->setAttribute('url_back', '@usuario_votos', 'vo/redir');
}
$this->redirectUnless($this->getUser()->isAuthenticated(), "@sf_guard_signin");
$this->reviews = SfReviewManager::getReviewsByUser($this->getUser()->getGuardUser()->getId(), $this->f);
$this->user = $this->getUser()->getGuardUser();
}
function getEntity()
{
if (!$this->entity) {
if ($this->getType()) {
$this->aReview = false;
$type = SfReviewTypePeer::retrieveByPk($this->getType());
$peer = $type->getModel() . 'Peer';
$this->entity = call_user_func("{$peer}::retrieveByPK", $this->entity_id);
} else {
$this->aReview = SfReviewPeer::retrieveByPk($this->sf_review_id);
//$this->aReview = $this->review->getSfReviewRelatedBySfReviewId();
if ($this->aReview) {
$peer = $this->aReview->getSfReviewType()->getModel() . 'Peer';
$this->entity = call_user_func("{$peer}::retrieveByPk", $this->aReview->getEntityId());
}
}
}
return $this->entity;
}
/**
* Get the associated SfReview object
*
* @param PropelPDO Optional Connection object.
* @return SfReview The associated SfReview object.
* @throws PropelException
*/
public function getSfReview(PropelPDO $con = null)
{
if ($this->aSfReview === null && $this->sf_review_id !== null) {
$this->aSfReview = SfReviewPeer::retrieveByPk($this->sf_review_id);
/* The following can be used additionally to
guarantee the related object contains a reference
to this object. This level of coupling may, however, be
undesirable since it could result in an only partially populated collection
in the referenced object.
$this->aSfReview->addSfReviewAttachs($this);
*/
}
return $this->aSfReview;
}
function changeCulture($culture)
{
$extensions = array('es' => 'es', 'ca' => 'cat');
$sf_context = sfContext::getInstance();
$request = $sf_context->getRequest();
$module = $request->getParameter('module');
$action = $request->getParameter('action');
$parameters = $request->getParameterHolder()->getAll();
$curCulture = $sf_context->getUser()->getCulture('es');
$routeName = $sf_context->getRouting()->getCurrentRouteName();
$routeName = preg_replace("/_{$curCulture}\$/", "_{$culture}", $routeName);
$params = "";
foreach ($parameters as $name => $value) {
if ($name != 'module' && $name != 'action') {
if ($name == 'institucion') {
$c = new Criteria();
$c->addJoin(InstitucionPeer::ID, InstitucionI18nPeer::ID);
$c->addJoin(array(InstitucionPeer::ID, InstitucionI18nPeer::CULTURE), array(InstitucionI18nPeer::ID, "'{$curCulture}'"), Criteria::INNER_JOIN);
$c->add(InstitucionI18nPeer::VANITY, $value);
$aInstitucion = InstitucionPeer::doSelectOne($c);
if ($aInstitucion) {
$value = $aInstitucion->getVanity($culture);
}
}
if ($module == 'sfReviewFront' && $action == 'show' && $name == 'id') {
$review = SfReviewPeer::retrieveByPk($request->getParameter('id'));
$value = SfVoUtil::reviewPermalink($review, $culture);
}
$params .= ($params == "" ? '?' : '&') . "{$name}={$value}";
}
}
$route = sfContext::getInstance()->getController()->genUrl("@{$routeName}{$params}");
$host = preg_replace("/\\.[a-zA-Z]*\$/is", "." . $extensions[$culture], $_SERVER['HTTP_HOST']);
return "http://{$host}{$route}";
}
public function sendTasks(sfWebRequest $request)
{
$tw_publish = $request->getParameter("tw_publish", 0);
$t = $request->getParameter("t", false);
$v = $request->getParameter("v", false);
$e = $request->getParameter("e", false);
$review_text = $request->getParameter("review_text", false);
$this->updateSums($request);
if ($t) {
$type = SfReviewTypePeer::retrieveByPk($t);
$peer = $type->getModel() . "Peer";
$entity = call_user_func("{$peer}::retrieveByPk", $e);
} else {
$review = SfReviewPeer::retrieveByPk($request->getParameter('e'));
if ($typeId = $review->getSfReviewTypeId()) {
$type = SfReviewTypePeer::retrieveByPK($typeId);
$peer = $type->getModule() . 'Peer';
$entity = call_user_func("{$peer}::retrieveByPk", $review->getEntityId());
}
}
$msg = "";
if ($tw_publish && TwitterManager::verify($this->getUser())) {
switch ($t) {
case Politico::NUM_ENTITY:
$entityUrl = sfContext::getInstance()->getController()->genUrl("politico/show?id=" . $entity->getVanity(), true);
$msg = sfContext::getInstance()->getI18N()->__('Voto %1% de %2% en @Voota: %3%', array('%1%' => $v == -1 ? sfContext::getInstance()->getI18N()->__('en contra') : sfContext::getInstance()->getI18N()->__('a favor'), '%2%' => $entity, '%3%' => TwitterManager::shorten($entityUrl)));
break;
case Partido::NUM_ENTITY:
$entityUrl = sfContext::getInstance()->getController()->genUrl("partido/show?id=" . $entity->getAbreviatura(), true);
$msg = sfContext::getInstance()->getI18N()->__('Voto %1% del partido %2% en @Voota: %3%', array('%1%' => $v == -1 ? sfContext::getInstance()->getI18N()->__('en contra') : sfContext::getInstance()->getI18N()->__('a favor'), '%2%' => $entity->getAbreviatura(), '%3%' => TwitterManager::shorten($entityUrl)));
break;
case Propuesta::NUM_ENTITY:
$entityUrl = sfContext::getInstance()->getController()->genUrl("propuesta/show?id=" . $entity->getVanity(), true);
$msg = sfContext::getInstance()->getI18N()->__('Voto %1% de la propuesta "%2%" en @Voota: %3%', array('%1%' => $v == -1 ? sfContext::getInstance()->getI18N()->__('en contra') : sfContext::getInstance()->getI18N()->__('a favor'), '%2%' => SfVoUtil::cutToLength($entity->getTitulo(), 60, '...', true), '%3%' => TwitterManager::shorten($entityUrl)));
break;
case "":
$entityUrl = sfContext::getInstance()->getController()->genUrl($type->getModule() . "/show?id=" . $entity->getVanity(), true);
$msg = sfContext::getInstance()->getI18N()->__('Vooto %1% de una opinión sobre %2% en @Voota: %3%', array('%1%' => $v == -1 ? sfContext::getInstance()->getI18N()->__('en contra') : sfContext::getInstance()->getI18N()->__('a favor'), '%2%' => $entity, '%3%' => TwitterManager::shorten($entityUrl)));
break;
}
TwitterManager::post($this->getUser(), $msg);
}
// Enviar email
if (!$t) {
//echo $request->getParameter('i');
$user = $review->getsfGuardUser();
if ($user->getProfile()->getMailsComentarios()) {
if ($typeId) {
$user->getProfile()->setCodigo(util::generateUID());
$user->getProfile()->save();
$mailBody = $this->getPartial('reviewLeftMailBody', array('nombre' => $user->getProfile()->getNombre(), 'usuario' => $review->getAnonymous() ? sfContext::getInstance()->getI18N()->__('anónimo (está en su derecho)') : $this->getUser()->getProfile()->getNombre() . ' ' . $this->getUser()->getProfile()->getApellidos(), 'entity' => $typeId == Propuesta::NUM_ENTITY ? "\"{$entity}\"" : $entity, 'texto_ori' => $review->getText(), 'comentario' => $request->getParameter('review_text'), 'vanity' => $entity->getVanity(), 'codigo' => $user->getProfile()->getCodigo(), 'voto' => $request->getParameter('v'), 'module' => $entity->getModule()));
VoMail::send(sfContext::getInstance()->getI18N()->__('Tu vooto sobre %1% tiene un comentario', array('%1%' => $entity)), $mailBody, $user->getUsername(), array('*****@*****.**' => 'no-reply Voota'), true);
}
}
}
}
public static function postReview($userId, $typeId, $entityId, $value, $text = false, $entity = false, $rm = false, $fb = '?', $source = '', $anonymous = '?', $tw = '?')
{
$prevValue = false;
$guessAnonymous = $anonymous && $anonymous == '?' ? true : false;
$guessFB = $fb && $fb == '?' ? true : false;
$guessTW = $tw && $tw == '?' ? true : false;
if ($guessAnonymous) {
$user = sfGuardUserPeer::retrieveByPK($userId);
if ($user) {
$anonymous = $user->getProfile()->getAnonymous();
}
}
if (!$entityId || !$value) {
throw new Exception("Not enough parameters.");
}
if ($value != -1 && $value != 1) {
throw new Exception("Invalid data for 'value'.");
}
// Check if already exists
$c = new Criteria();
if (!$typeId) {
$c->add(SfReviewPeer::SF_REVIEW_ID, $entityId);
} else {
$c->add(SfReviewPeer::ENTITY_ID, $entityId);
}
$c->add(SfReviewPeer::SF_GUARD_USER_ID, $userId);
$c->add(SfReviewPeer::SF_REVIEW_TYPE_ID, $typeId ? $typeId : null);
$review = SfReviewPeer::doSelectOne($c);
if (!$review) {
$review = new SfReview();
if (!$typeId) {
$review->setSfReviewId($entityId);
} else {
$review->setEntityId($entityId);
}
$review->setSfReviewTypeId($typeId ? $typeId : null);
$review->setSfGuardUserId($userId);
$review->setCreatedAt(new DateTime());
$review->setSource($source);
} else {
if ($rm && $value == $review->getValue() && $review->getIsActive()) {
$review->setIsActive(false);
} else {
$review->setIsActive(true);
}
$review->setModifiedAt(new DateTime());
}
$review->setValue($value);
if ($text) {
$aText = SfVoUtil::cutToLength($text, self::MAX_LENGTH, '');
$aText = strip_tags($aText);
$review->setText($aText);
}
$review->setSfReviewStatusId(1);
$review->setIpAddress($_SERVER['REMOTE_ADDR']);
$review->setCookie(sfContext::getInstance()->getRequest()->getCookie('symfony'));
$review->setCulture(sfContext::getInstance()->getUser()->getCulture());
if (!$guessFB) {
$review->setToFb($fb);
}
if (!$guessTW) {
$review->setToTw($tw);
}
if (!$guessAnonymous || $review->isNew()) {
$review->setAnonymous($anonymous);
}
try {
$review->save();
if (!$typeId) {
$parentReview = SfReviewPeer::retrieveByPk($entityId);
$parentReview->setBalance(SfReviewManager::getBalanceByReviewId($entityId));
$parentReview->save();
}
if (!$entity) {
if (!$typeId) {
$aEntityId = $parentReview->getEntityId();
$aTypeId = $parentReview->getSfReviewTypeId();
} else {
$aTypeId = $typeId;
$aEntityId = $entityId;
}
$reviewType = SfReviewTypePeer::retrieveByPK($aTypeId);
$peer = $reviewType->getModel() . 'Peer';
$entity = $peer::retrieveByPK($aEntityId);
}
$entity->updateCalcs();
$entity->save();
} catch (Exception $e) {
throw new Exception('Error writing review.');
}
return $review->getIsActive() ? $review : false;
}
