public static function getAssociatedRoutesData($outings)
{
if (count($outings) == 0) {
return $outings;
}
$outing_ids = array();
foreach ($outings as $key => $outing) {
$outing_ids[] = $outing['id'];
$outings[$outing['id']] = $outing;
unset($outings[$key]);
}
$ro_associations = Association::countAllMain($outing_ids, 'ro');
if (count($ro_associations) == 0) {
return $outings;
}
$route_ids = array();
foreach ($ro_associations as $ro) {
$route_id = $ro['main_id'];
$outing_id = $ro['linked_id'];
$route_ids[] = $route_id;
$outings[$outing_id]['linked_routes'] = isset($outings[$outing_id]['linked_routes']) ? array_merge($outings[$outing_id]['linked_routes'], array($route_id)) : array($route_id);
}
$route_ids = array_unique($route_ids);
$outing_fields = array('max_elevation', 'height_diff_up');
$route_ski_fields = array('toponeige_technical_rating', 'toponeige_exposition_rating', 'labande_ski_rating', 'labande_global_rating');
$route_climbing_fields = array('global_rating', 'engagement_rating', 'objective_risk_rating', 'rock_free_rating', 'rock_required_rating', 'ice_rating', 'mixed_rating', 'aid_rating', 'rock_exposition_rating', 'equipment_rating');
$route_hiking_fields = array('hiking_rating');
$route_snowshoeing_fields = array('snowshoeing_rating');
$route_fields = array_merge($route_ski_fields, $route_climbing_fields, $route_hiking_fields, $route_snowshoeing_fields);
$routes = Document::findIn('Route', $route_ids);
foreach ($outings as &$outing) {
foreach ($outing_fields as $field) {
if (!$outing[$field] instanceof Doctrine_Null) {
$outing[$field . '_set'] = true;
}
}
$route_activities = array();
foreach ($routes as $route) {
if (!isset($outing['linked_routes'])) {
continue;
}
if (!in_array($route['id'], $outing['linked_routes'])) {
continue;
}
$route_activities = array_merge($route_activities, Document::convertStringToArray($route['activities']));
// if height_diff_up or max_elevation not in outing, get values from routes
foreach ($outing_fields as $field) {
if (!isset($outing[$field . '_set']) && ($outing[$field] instanceof Doctrine_Null || $route[$field] > $outing[$field])) {
$outing[$field] = $route[$field];
}
}
foreach ($route_fields as $field) {
$field_value = $route[$field];
if (!isset($outing[$field]) || isset($field_value) && $field_value > $outing[$field]) {
$outing[$field] = $field_value;
}
}
}
$activities_to_show = array_intersect(Document::convertStringToArray($outing['activities']), $route_activities);
if (count($activities_to_show) == 0) {
$activities_to_show = $route_activities;
}
if (!count(array_intersect($activities_to_show, array(1)))) {
foreach ($route_ski_fields as $field) {
$outing[$field] = null;
}
}
if (!count(array_intersect($activities_to_show, array(2, 3, 4, 5)))) {
foreach ($route_climbing_fields as $field) {
$outing[$field] = null;
}
}
if (!count(array_intersect($activities_to_show, array(6)))) {
foreach ($route_hiking_fields as $field) {
$outing[$field] = null;
}
}
if (!count(array_intersect($activities_to_show, array(7)))) {
foreach ($route_snowshoeing_fields as $field) {
$outing[$field] = null;
}
}
}
return $outings;
}
/**
* 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 static function countAssociatedDocuments(&$docs, $type, $is_main)
{
if (count($docs) == 0) {
return;
}
$doc_ids = array();
foreach ($docs as $key => $doc) {
$doc_ids[] = $doc['id'];
}
if ($is_main) {
$associations = Association::countAllLinked($doc_ids, $type);
} else {
$associations = Association::countAllMain($doc_ids, $type);
}
if (count($associations) == 0) {
return;
}
$linked_doc_count = array();
foreach ($associations as $assoc) {
if ($is_main) {
$linked_doc_count[] = $assoc['main_id'];
} else {
$linked_doc_count[] = $assoc['linked_id'];
}
}
$linked_doc_count = array_count_values($linked_doc_count);
foreach ($docs as $key => $doc) {
$doc_id = $doc['id'];
if (isset($linked_doc_count[$doc_id])) {
$docs[$key]['nb_linked_docs'] = $linked_doc_count[$doc_id];
} else {
$docs[$key]['nb_linked_docs'] = 0;
}
}
}
