public function executeForm_fields_image_type()
{
// who has the right to change the license:
// * only moderators have all right
// - but they can switch to copyright license only if the image is associated to a book
// * the creator can switch from personal to collaborative
// * other users cannot
$creator = $this->document->getCreator();
$image_type = $this->document->get('image_type');
// check if the image is already associated to a book (required to decide whether "copyright" is allowed or not)
$id = $this->document['id'];
$associations = Association::findAllAssociations($id, 'bi');
$this->hide_image_type_edit = !$this->moderator && $image_type != 2 || !$this->moderator && $this->getContext()->getUser()->getId() != $creator['id'];
// allow copyright license only for images associated to books, and only to moderators
$this->allow_copyright = $this->moderator && (count($associations) > 0 || $image_type == 3);
}
protected function endEdit()
{
//Test if form is submitted or not
if ($this->success) {
// try to perform association with linked_doc (if pertinent)
$summit_id = $this->getRequestParameter('summit_id');
$id = $this->document->get('id');
$user_id = $this->getUser()->getId();
if ($this->new_document && $summit_id || $summit_id && !Association::find($summit_id, $id, 'sr')) {
$sr = new Association();
$sr->doSaveWithValues($summit_id, $id, 'sr', $user_id);
// main, linked, type
// clear cache of associated summit ...
$this->clearCache('summits', $summit_id, false, 'view');
}
// here if we have created a new document and if $this->document->get('geom_wkt') is null, then use associated doc geom associations:
// this allows us to filter on ranges even if no GPX is uploaded
if ($this->new_document && $summit_id && !$this->document->get('geom_wkt')) {
// get all associated regions (3+maps) with this summit:
$associations = GeoAssociation::findAllAssociations($summit_id, array('dr', 'dc', 'dd', 'dv', 'dm'));
// replicate them with route_id instead of summit_id:
foreach ($associations as $ea) {
$a = new GeoAssociation();
$a->doSaveWithValues($id, $ea->get('linked_id'), $ea->get('type'));
}
}
// if we add a route to a summit-hut, link the route to the hut
$hut_asso = Association::findAllAssociations($summit_id, 'sh');
if ($this->new_document && $summit_id && count($hut_asso) > 0) {
// associate hut to summit
$asso = new Association();
$hut_id = $hut_asso[0]->get('linked_id');
$asso->doSaveWithValues($hut_id, $id, 'hr', 2);
// C2C user
// clear cache of associated hut ...
$this->clearCache('huts', $hut_id, false, 'view');
}
parent::endEdit();
// redirect to document view
} else {
if ($this->link_with = $this->getRequestParameter('link')) {
// linked_doc was already retrieved in filterAdditionalParameters
if ($this->linked_doc) {
$this->linked_doc->setBestCulture($this->getUser()->getCulturesForDocuments());
}
} else {
$this->linked_doc = $this->getHighestSummit();
}
}
}
/**
* Executes "associate current document with document" action
* associated document can only be : articles, summits, books, huts, outings, routes, sites, users
* ... restricted in security.yml to logged people
*/
public function executeAddAssociation()
{
$user = $this->getUser();
$user_id = $user->getId();
$is_moderator = $user->hasCredential(sfConfig::get('app_credentials_moderator'));
//
// Get parameters and check that association is allowed
//
// if session is time-over
if (!$user_id) {
return $this->ajax_feedback('Session is over. Please login again.');
}
if (!$this->hasRequestParameter('document_id') || !$this->hasRequestParameter('main_id') || !$this->hasRequestParameter('document_module')) {
return $this->ajax_feedback('Operation not allowed');
}
$main_module = $this->getRequestParameter('module');
$main_id = $this->getRequestParameter('main_id');
$linked_module = $this->getRequestParameter('document_module');
$linked_id = $this->getRequestParameter('document_id');
$icon = $this->getRequestParameter('icon', '');
$div = $this->getRequestParameter('div', false);
if ($linked_id == $main_id) {
return $this->ajax_feedback('A document can not be linked to itself');
}
switch ($linked_module) {
case 'summits':
$fields = array('id', 'is_protected', 'summit_type');
break;
case 'routes':
$fields = array('id', 'is_protected', 'duration');
break;
case 'huts':
$fields = array('id', 'is_protected', 'shelter_type');
break;
case 'articles':
$fields = array('id', 'is_protected', 'article_type');
break;
case 'images':
$fields = array('id', 'is_protected', 'image_type');
break;
case 'documents':
$fields = array('id', 'is_protected', 'module');
break;
// FIXME prevent such case?
// FIXME prevent such case?
default:
$fields = array('id', 'is_protected');
break;
}
$linked_document = Document::find(c2cTools::module2model($linked_module), $linked_id, $fields);
$linked_module = $linked_module != 'documents' ? $linked_module : $linked_document->get('module');
if (!$linked_document) {
return $this->ajax_feedback('Linked document does not exist');
}
$type_modules = c2cTools::Modules2Type($main_module, $linked_module);
if (empty($type_modules)) {
return $this->ajax_feedback('Wrong association type');
}
list($type, $swap, $main_module_new, $linked_module_new, $strict) = $type_modules;
switch ($main_module) {
case 'summits':
$fields = array('id', 'is_protected', 'summit_type');
break;
case 'routes':
$fields = array('id', 'is_protected', 'duration');
break;
case 'huts':
$fields = array('id', 'is_protected', 'shelter_type');
break;
case 'articles':
$fields = array('id', 'is_protected', 'article_type');
break;
case 'images':
$fields = array('id', 'is_protected', 'image_type');
break;
case 'documents':
$fields = array('id', 'is_protected', 'module');
break;
// FIXME prevent such case?
// FIXME prevent such case?
default:
$fields = array('id', 'is_protected');
break;
}
$main_document = Document::find(c2cTools::module2model($main_module), $main_id, $fields);
if (!$main_document) {
return $this->ajax_feedback('Main document does not exist');
}
if ($swap) {
$main_document_new = $linked_document;
$main_id_new = $linked_id;
$linked_document_new = $main_document;
$linked_id_new = $main_id;
} else {
$main_document_new = $main_document;
$main_id_new = $main_id;
$linked_document_new = $linked_document;
$linked_id_new = $linked_id;
}
if ($linked_module_new == 'articles') {
if (!$is_moderator) {
if ($linked_document_new->get('article_type') == 2 && !Association::find($user_id, $linked_id_new, 'uc')) {
return $this->ajax_feedback('You do not have the right to link a document to a personal article');
}
if ($main_module_new == 'articles') {
if ($main_document_new->get('article_type') == 2 && !Association::find($user_id, $main_id_new, 'uc')) {
return $this->ajax_feedback('You do not have the right to link a document to a personal article');
}
}
if ($main_module_new == 'outings' && !Association::find($user_id, $main_id_new, 'uo')) {
return $this->ajax_feedback('You do not have the right to link an article to another user outing');
}
}
if ($linked_document_new->get('article_type') != 2 && $type == 'uc') {
return $this->ajax_feedback('An user can not be linked to a collaborative article');
}
}
if ($linked_module_new == 'images') {
if ($main_document_new->get('is_protected') && !$is_moderator) {
return $this->ajax_feedback('Document is
protected');
}
if (!$is_moderator) {
if ($main_module_new == 'users' && $main_id_new != $user_id) {
return $this->ajax_feedback('You do not have the right to link an image to another user profile');
}
if ($main_module_new == 'outings' && !Association::find($user_id, $main_id_new, 'uo')) {
return $this->ajax_feedback('You do not have the right to link an image to another user outing');
}
if ($main_module_new == 'articles' && $main_document_new->get('article_type') == 2 && !Association::find($user_id, $main_id_new, 'uc')) {
return $this->ajax_feedback('You do not have the right to link an image to a personal article');
}
if ($main_module_new == 'images' && $main_document_new->get('image_type') == 2 && $document->getCreatorId() != $user_id) {
return $this->ajax_feedback('You do not have the right to link an image to a personal image');
}
}
}
if ($linked_module_new == 'outings') {
if (!$is_moderator) {
if ($main_module_new == 'users' && !Association::find($user_id, $linked_id_new, 'uo')) {
return $this->ajax_feedback('You do not have the right to link an user to another user outing');
}
if ($main_module_new == 'routes' && !Association::find($user_id, $linked_id_new, 'uo')) {
return $this->ajax_feedback('You do not have the right to link a route to another user outing');
}
if ($main_module_new == 'sites' && !Association::find($user_id, $linked_id_new, 'uo')) {
return $this->ajax_feedback('You do not have the right to link a site to another user outing');
}
}
}
if ($linked_module_new == 'xreports') {
if (!$is_moderator) {
if ($main_module_new == 'users' && !Association::find($user_id, $linked_id_new, 'ux')) {
return $this->ajax_feedback('You do not have the right to link an user to another user xreport');
}
if ($main_module_new == 'outings' && !Association::find($user_id, $linked_id_new, 'ux')) {
return $this->ajax_feedback('You do not have the right to link an outing to another user xreport');
}
if ($main_module_new == 'routes' && !Association::find($user_id, $linked_id_new, 'ux')) {
return $this->ajax_feedback('You do not have the right to link a route to another user xreport');
}
if ($main_module_new == 'sites' && !Association::find($user_id, $linked_id_new, 'ux')) {
return $this->ajax_feedback('You do not have the right to link a site to another user xreport');
}
}
}
if ($linked_module_new == 'huts') {
if ($main_module_new == 'summits') {
$associations = Association::findAllAssociations($linked_id_new, 'sh');
if (count($associations)) {
return $this->ajax_feedback('This hut is already linked to a summit');
}
}
if ($main_module_new == 'parkings') {
$associations_pp = Association::findAllAssociations($main_id_new, 'pp');
$associations_ph = Association::findAllAssociations($linked_id_new, 'ph');
foreach ($associations_pp as $a_pp) {
foreach ($associations_ph as $a_ph) {
if ($a_pp['main_id'] == $a_ph['main_id'] || $a_pp['linked_id'] == $a_ph['main_id']) {
return $this->ajax_feedback('A parking can not be linked to a hut if a main/sub parking is already linked to it');
}
}
}
}
}
if ($linked_module_new == 'routes') {
if ($main_module_new == 'summits' && $main_document_new->get('summit_type') == 5 && $linked_document_new->get('duration') <= 2) {
return $this->ajax_feedback('A raid summit can not be linked to a stage route');
}
if ($main_module_new == 'huts' && ($main_document_new->get('shelter_type') == 5 || $main_document_new->get('shelter_type') == 6)) {
return $this->ajax_feedback('A gite can not be linked to a route');
}
if ($main_module_new == 'parkings') {
$associations_pp = Association::findAllAssociations($main_id_new, 'pp');
$associations_pr = Association::findAllAssociations($linked_id_new, 'pr');
foreach ($associations_pp as $a_pp) {
foreach ($associations_pr as $a_pr) {
if ($a_pp['main_id'] == $a_pr['main_id'] || $a_pp['linked_id'] == $a_pr['main_id']) {
return $this->ajax_feedback('A parking can not be linked to a route if a main/sub parking is already linked to it');
}
}
}
}
}
if ($linked_module_new == 'sites') {
if ($main_module_new == 'sites') {
if (Association::countAllMain(array($linked_id_new), 'tt')) {
return $this->ajax_feedback('A sub site can not be linked to more than one main site');
}
}
if ($main_module_new == 'summits') {
if (Association::countAllMain(array($linked_id_new), 'st')) {
return $this->ajax_feedback('A site can not be linked to more than one summit');
}
if (Association::countAllMain(array($linked_id_new), 'tt')) {
return $this->ajax_feedback('A summit can not be linked to a sub site');
}
}
if ($main_module_new == 'parkings') {
$associations_pp = Association::findAllAssociations($main_id_new, 'pp');
$associations_pt = Association::findAllAssociations($linked_id_new, 'pt');
foreach ($associations_pp as $a_pp) {
foreach ($associations_pt as $a_pt) {
if ($a_pp['main_id'] == $a_pt['main_id'] || $a_pp['linked_id'] == $a_pt['main_id']) {
return $this->ajax_feedback('A parking can not be linked to a site if a main/sub parking is already linked to it');
}
}
}
}
}
if ($linked_module_new == 'summits') {
if ($main_module_new == 'summits') {
if ($main_document_new->get('summit_type') == 5 || $linked_document_new->get('summit_type') == 5) {
return $this->ajax_feedback('A raid summit can not be linked to a real summit');
}
if (Association::countAllMain(array($linked_id_new), 'ss')) {
return $this->ajax_feedback('A sub summit can not be linked to more than one main summit');
}
}
}
if ($linked_module_new == 'parkings') {
if ($main_module_new == 'parkings') {
if (Association::countAllMain(array($linked_id_new), 'pp')) {
// return $this->ajax_feedback('A sub parking can not be linked to more than one main parking');
}
}
}
if (Association::find($main_id_new, $linked_id_new, $type, false)) {
return $this->ajax_feedback('The document is already linked to the current document');
}
if ($linked_module_new == 'outings' && $main_module_new == 'users' && $linked_id != $user_id) {
// send an email to warn the new user associated
$email_recipient = UserPrivateData::find($linked_id)->getEmail();
$email_subject = $this->__('You have been associated to an outing');
$server = $_SERVER['SERVER_NAME'];
$outing_link = 'http' . (empty($_SERVER['HTTPS']) ? '' : 's') . "://{$server}/outings/{$main_id}";
$htmlBody = $this->__('You have been associated to outing %1% details', array('%1%' => '<a href="' . $outing_link . '">' . $outing_link . '</a>'));
$mail = new sfMail();
$mail->setCharset('utf-8');
// definition of the required parameters
$mail->setSender(sfConfig::get('app_outgoing_emails_sender'));
$mail->setFrom(sfConfig::get('app_outgoing_emails_from'));
$mail->addReplyTo(sfConfig::get('app_outgoing_emails_reply_to'));
$mail->addAddress($email_recipient);
$mail->setSubject($email_subject);
$mail->setContentType('text/html');
$mail->setBody($htmlBody);
$mail->setAltBody(strip_tags($htmlBody));
// send the email
$mail->send();
}
// Perform association
$a = new Association();
$status = $a->doSaveWithValues($main_id_new, $linked_id_new, $type, $user_id);
if (!$status) {
return $this->ajax_feedback('Could not perform association');
}
// cache clearing for current doc in every lang:
$this->clearCache($main_module, $main_id, false, 'view');
$this->clearCache($linked_module, $linked_id, false, 'view');
// html to return
sfLoader::loadHelpers(array('Tag', 'Url', 'Asset', 'AutoComplete'));
$linked_document->setBestName($user->getPreferedLanguageList());
$bestname = $linked_document->get('name');
if ($linked_module == 'routes') {
// in that case, output not only route name but also best summit name whose id has been passed (summit_id)
$summit = explode(' [', $this->getRequestParameter('summits_name'));
$bestname = $summit[0] . $this->__(' :') . ' ' . $bestname;
}
$linked_module_name = $icon ? $icon : $this->__($linked_module);
$type_id_string = $type . '_' . $linked_id;
$out = link_to($bestname, "@document_by_id?module={$linked_module}&id={$linked_id}");
if ($user->hasCredential('moderator')) {
$out .= c2c_link_to_delete_element($type, $main_id_new, $linked_id_new, !$swap, $strict);
}
if ($div) {
$icon_string = '';
if ($icon) {
$icon_string = '<div class="assoc_img picto_' . $icon . '" title="' . ucfirst(__($icon)) . '">' . '<span>' . ucfirst(__($icon)) . __(' :') . '</span>' . '</div>';
}
$out = '<div class="linked_elt" id="' . $type_id_string . '">' . $icon_string . $out . '</div>';
} else {
$out = '<li id="' . $type_id_string . '">' . picto_tag('picto_' . $linked_module, $linked_module_name) . ' ' . $out . '</li>';
}
return $this->renderText($out);
}
public function executeAddroute()
{
$id = $this->getRequestParameter('document_id');
// check if a summit is already associated to hut. if not, create it
$create_summit = Association::countMains($id, 'sh') == 0;
if ($create_summit) {
$document = Document::find('Hut', $id, array('elevation', 'geom_wkt'));
$conn = sfDoctrine::Connection();
try {
$conn->beginTransaction();
// create first version of document, with culture and geometry of hut document
$hut_elevation = $document['elevation'];
$hut_lat = $document['lat'];
$hut_lon = $document['lon'];
$hut_culture = $document->getCulture();
$hut_name = $document['name'];
$history_metadata = new HistoryMetadata();
$history_metadata->setComment($this->__('Created summit synchronized with hut for access'));
$history_metadata->set('is_minor', false);
$history_metadata->set('user_id', 2);
// C2C user
$history_metadata->save();
$summit = new Summit();
$summit->setCulture($hut_culture);
$summit->set('name', $hut_name);
$summit->set('elevation', $hut_elevation);
$summit->set('summit_type', 100);
// set summit type to ' hut'
$summit->set('lat', $hut_lat);
$summit->set('lon', $hut_lon);
$summit->save();
$conn->commit();
// add others culture versions
foreach ($document->get('HutI18n') as $i18n) {
$culture = $i18n->getCulture();
if ($culture != $hut_culture) {
$conn->beginTransaction();
$hut_name = $i18n->getName();
$history_metadata = new HistoryMetadata();
$history_metadata->setComment($this->__('Created summit synchronized with hut for access'));
$history_metadata->set('is_minor', false);
$history_metadata->set('user_id', 2);
// C2C user
$history_metadata->save();
$summit->setCulture($culture);
$summit->set('name', $hut_name);
$summit->save();
$conn->commit();
}
}
} catch (Exception $e) {
$conn->rollback();
return $this->setErrorAndRedirect($this->__('Failed to create synchronized summit'), "routes/edit?link={$summit_id}");
}
$summit_id = $summit->get('id');
// get all associated regions (3+maps) with this hut:
$associations = GeoAssociation::findAllAssociations($id, array('dr', 'dc', 'dd', 'dv', 'dm'));
// replicate them with summit_id instead of id:
foreach ($associations as $ea) {
$a = new GeoAssociation();
$a->doSaveWithValues($summit_id, $ea->get('linked_id'), $ea->get('type'));
}
// associate hut to summit
$asso = new Association();
$asso->doSaveWithValues($summit_id, $id, 'sh', 2);
// C2C user
} else {
$associations = Association::findAllAssociations($id, 'sh');
$summit_id = $associations[0]->get('main_id');
}
$this->clearCache('huts', $id);
return $this->redirect("routes/edit?link={$summit_id}");
}
protected function doMerge($from_id, $document_from, $to_id, $document_to)
{
// fetch associated documents before doing the merging as associations will be transferred
$associations = Association::findAllAssociations($from_id);
parent::doMerge($from_id, $document_from, $to_id, $document_to);
// search documents in which from is inserted, and replace the insertion with to
foreach ($associations as $a) {
$check_id = $a['main_id'] == $from_id ? $a['linked_id'] : ($check_id = $a['main_id']);
$check_model = c2cTools::Letter2Model(substr($a['type'], 0, 1));
$check_module = c2cTools::Model2Module($check_model);
$check_doc = Document::find($check_model, $check_id);
$fields = sfConfig::get('mod_images_bbcode_fields_' . $check_module);
// clear linked doc cache
$this->clearCache($check_module, $check_id);
$languages = $check_doc->getLanguages();
foreach ($languages as $language) {
$modified = false;
$conn = sfDoctrine::Connection();
$conn->beginTransaction();
$check_doc->setCulture($language);
foreach ($fields as $field) {
$text = $check_doc[$field];
$edited = preg_replace('#(\\[img=\\s*)' . $from_id . '([\\w\\s]*\\].*?\\[/img\\])\\n?#is', '${1}' . $to_id . '${2}', $text);
$edited = preg_replace('#(\\[img=\\s*)' . $from_id . '([\\w\\s]*\\/\\])\\n?#is', '${1}' . $to_id . '${2}', $edited);
if ($edited != $text) {
$modified = true;
$check_doc->set($field, $edited);
}
}
if ($modified) {
$history_metadata = new HistoryMetadata();
$history_metadata->setComment('Updated image tags');
$history_metadata->set('is_minor', true);
$history_metadata->set('user_id', sfConfig::get('app_moderator_user_id'));
$history_metadata->save();
c2cTools::log('After merge of image ' . $from_id . ' into ' . $to_id . ': update image tag for ' . strtolower($check_model) . ' ' . $check_id . ' (' . $language . ')');
$check_doc->save();
$conn->commit();
} else {
$conn->rollback();
}
}
}
// clear images lists and whatsnew cache
$this->clearCache('images', 0, true);
}
public static function getUsersToNotify($doc_id)
{
if (!is_int((int) $doc_id)) {
return array();
}
$result = Doctrine_Query::create()->select('d.module')->from('Document d')->where('d.id = ?', array($doc_id))->execute(array(), Doctrine::FETCH_ARRAY);
$module = $result[0]['module'];
// note: only personal articles are linked with users so it is ok to search users attached for each article
if (in_array($module, array('outings', 'users', 'articles', 'images'))) {
if ($module == 'users') {
return array($doc_id);
} else {
if ($module == 'images') {
$result = Doctrine_Query::create()->select('dv.document_id, hm.user_id')->from('DocumentVersion dv LEFT JOIN dv.history_metadata hm ')->where('dv.document_id = ? AND dv.version = ?', array($doc_id, 1))->orderBy('dv.created_at ASC')->limit(1)->execute(array(), Doctrine::FETCH_ARRAY);
return array($result[0]['history_metadata']['user_id']);
} else {
switch ($module) {
case 'outings':
$association_type = 'uo';
break;
case 'articles':
$association_type = 'uc';
break;
}
$associations = Association::findAllAssociations($doc_id, $association_type);
$users = array();
foreach ($associations as $association) {
$users[] = $association['main_id'];
}
return $users;
}
}
}
return array();
}