public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('outings');
$this->hasColumn('date', 'date', null);
$this->hasColumn('activities', 'string', null);
// array
$this->hasColumn('height_diff_up', 'smallint', null);
$this->hasColumn('height_diff_down', 'smallint', null);
$this->hasColumn('outing_length', 'integer', 6);
$this->hasColumn('min_elevation', 'smallint', 4);
$this->hasColumn('max_elevation', 'smallint', 4);
$this->hasColumn('partial_trip', 'boolean', null);
$this->hasColumn('hut_status', 'smallint', 1);
$this->hasColumn('frequentation_status', 'smallint', 1);
$this->hasColumn('conditions_status', 'smallint', 1);
$this->hasColumn('access_status', 'smallint', 1);
$this->hasColumn('access_elevation', 'smallint', 4);
$this->hasColumn('lift_status', 'smallint', 1);
$this->hasColumn('glacier_status', 'smallint', 1);
$this->hasColumn('up_snow_elevation', 'smallint', 4);
$this->hasColumn('down_snow_elevation', 'smallint', 4);
$this->hasColumn('track_status', 'smallint', 1);
$this->hasColumn('outing_with_public_transportation', 'boolean', null);
$this->hasColumn('avalanche_date', 'string', null);
// array
$this->hasColumn('v4_id', 'smallint', 5);
$this->hasColumn('v4_app', 'string', 3);
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('sites');
$this->hasColumn('routes_quantity', 'smallint', 4);
$this->hasColumn('max_rating', 'smallint', 2);
$this->hasColumn('min_rating', 'smallint', 2);
$this->hasColumn('mean_rating', 'smallint', 2);
$this->hasColumn('max_height', 'smallint', 4);
$this->hasColumn('min_height', 'smallint', 4);
$this->hasColumn('mean_height', 'smallint', 4);
$this->hasColumn('equipment_rating', 'smallint', 1);
$this->hasColumn('climbing_styles', 'string', null);
// array in DB but Doctrine sees it as a string
$this->hasColumn('rock_types', 'string', null);
// array
$this->hasColumn('site_types', 'string', null);
// array
$this->hasColumn('children_proof', 'smallint', 1);
$this->hasColumn('rain_proof', 'smallint', 1);
$this->hasColumn('facings', 'string', null);
// array
$this->hasColumn('best_periods', 'string', null);
// array
$this->hasColumn('v4_id', 'smallint', 5);
$this->hasColumn('v4_type', 'string', 4);
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('summits');
$this->hasColumn('summit_type', 'smallint', null);
$this->hasColumn('maps_info', 'string', 300);
$this->hasColumn('v4_id', 'smallint', 5);
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('products');
$this->hasColumn('product_type', 'string', null);
// array
$this->hasColumn('url', 'string', 255);
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('maps');
$this->hasColumn('editor', 'integer', null);
$this->hasColumn('scale', 'integer', null);
$this->hasColumn('code', 'string', 20);
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('users');
$this->hasColumn('v4_id', 'smallint', 5);
$this->hasColumn('activities', 'string', null);
// array
$this->hasColumn('category', 'smallint', 1);
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('articles');
$this->hasColumn('categories', 'string', null);
// array
$this->hasColumn('activities', 'string', null);
// array
$this->hasColumn('article_type', 'integer', 1);
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('parkings');
$this->hasColumn('public_transportation_rating', 'smallint', 1);
$this->hasColumn('public_transportation_types', 'string', null);
// array
$this->hasColumn('snow_clearance_rating', 'smallint', 1);
$this->hasColumn('lowest_elevation', 'smallint', 4);
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('books');
$this->hasColumn('author', 'string', 100);
$this->hasColumn('editor', 'string', 100);
$this->hasColumn('activities', 'string', null);
// array
$this->hasColumn('url', 'string', 255);
$this->hasColumn('isbn', 'string', 17);
$this->hasColumn('langs', 'string', null);
// array
$this->hasColumn('book_types', 'string', null);
// array
$this->hasColumn('publication_date', 'string', 100);
$this->hasColumn('nb_pages', 'small_int', null);
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('huts');
$this->hasColumn('shelter_type', 'integer', 1);
$this->hasColumn('is_staffed', 'boolean', null);
$this->hasColumn('phone', 'string', 50);
$this->hasColumn('url', 'string', 255);
$this->hasColumn('staffed_capacity', 'smallint', 3);
$this->hasColumn('unstaffed_capacity', 'smallint', 2);
$this->hasColumn('has_unstaffed_matress', 'smallint', 1);
$this->hasColumn('has_unstaffed_blanket', 'smallint', 1);
$this->hasColumn('has_unstaffed_gas', 'smallint', 1);
$this->hasColumn('has_unstaffed_wood', 'smallint', 1);
$this->hasColumn('activities', 'string', null);
// array
}
public function delete($con = null)
{
$originalCacheRelations = sfConfig::get('sf_cache_relations');
sfConfig::set('sf_cache_relations', false);
try {
$docId = $this->getId();
$con = Propel::getConnection();
$con->begin();
// delete child relation
$c = new Criteria();
$c->add(RelationPeer::ID2, $docId);
$relations = RelationPeer::doSelect($c);
foreach ($relations as $relation) {
$relation->delete(null, sfConfig::get('sf_cache_relations'));
//$relation->delete();
}
// delete parent relations
$children = Document::getChildrenOf($docId);
foreach ($children as $child) {
$relation = new Relation();
$relation->setId1($docId);
$relation->setId2($child->getId());
$child->delete();
$relation->delete();
}
// delete any tags for this document
$c = new Criteria();
$c->add(TagrelationPeer::ID, $docId);
$tagRelations = TagrelationPeer::doSelect($c);
foreach ($tagRelations as $tag) {
$tag->delete();
}
parent::delete();
$con->commit();
} catch (Exception $e) {
$con->rollback();
throw $e;
}
// set 'sf_cache_relations' it's original value
sfConfig::set('sf_cache_relations', $originalCacheRelations);
if ($originalCacheRelations) {
Relation::updateRelationCache();
}
return true;
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('routes');
$this->hasColumn('activities', 'string', null);
// array in DB but Doctrine sees it as a string
$this->hasColumn('facing', 'smallint', null);
$this->hasColumn('height_diff_up', 'smallint', null);
$this->hasColumn('height_diff_down', 'smallint', null);
$this->hasColumn('route_type', 'smallint', null);
$this->hasColumn('route_length', 'integer', 5);
$this->hasColumn('min_elevation', 'smallint', null);
$this->hasColumn('max_elevation', 'smallint', null);
$this->hasColumn('duration', 'smallint', null);
$this->hasColumn('slope', 'string', 100);
$this->hasColumn('difficulties_height', 'smallint', null);
$this->hasColumn('configuration', 'string', null);
// array
$this->hasColumn('global_rating', 'smallint', null);
$this->hasColumn('engagement_rating', 'smallint', null);
$this->hasColumn('objective_risk_rating', 'smallint', null);
$this->hasColumn('equipment_rating', 'smallint', null);
$this->hasColumn('is_on_glacier', 'boolean', null);
$this->hasColumn('sub_activities', 'string', null);
// array
$this->hasColumn('toponeige_technical_rating', 'smallint', null);
$this->hasColumn('toponeige_exposition_rating', 'smallint', null);
$this->hasColumn('labande_ski_rating', 'smallint', null);
$this->hasColumn('labande_global_rating', 'smallint', null);
$this->hasColumn('ice_rating', 'smallint', null);
$this->hasColumn('mixed_rating', 'smallint', null);
$this->hasColumn('rock_free_rating', 'smallint', null);
$this->hasColumn('rock_required_rating', 'smallint', null);
$this->hasColumn('aid_rating', 'smallint', null);
$this->hasColumn('rock_exposition_rating', 'smallint', null);
$this->hasColumn('hiking_rating', 'smallint', null);
$this->hasColumn('snowshoeing_rating', 'smallint', null);
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('portals');
$this->hasColumn('activities', 'string', null);
// array
$this->hasColumn('has_map', 'boolean', null);
$this->hasColumn('map_filter', 'string', 255);
$this->hasColumn('topo_filter', 'string', 255);
$this->hasColumn('nb_outings', 'small_int', null);
$this->hasColumn('outing_filter', 'string', 255);
$this->hasColumn('nb_images', 'small_int', null);
$this->hasColumn('image_filter', 'string', 255);
$this->hasColumn('nb_videos', 'small_int', null);
$this->hasColumn('video_filter', 'string', 255);
$this->hasColumn('nb_articles', 'small_int', null);
$this->hasColumn('article_filter', 'string', 255);
$this->hasColumn('nb_topics', 'small_int', null);
$this->hasColumn('forum_filter', 'string', 255);
$this->hasColumn('nb_news', 'small_int', null);
$this->hasColumn('news_filter', 'string', 255);
$this->hasColumn('design_file', 'string', 255);
}
public function setTableDefinition()
{
parent::setTableDefinition();
$this->setTableName('images');
$this->hasColumn('filename', 'string', null);
$this->hasColumn('has_svg', 'boolean', null);
$this->hasColumn('width', 'smallint', null);
$this->hasColumn('height', 'smallint', null);
$this->hasColumn('file_size', 'integer', null);
$this->hasColumn('categories', 'string', null);
// array
$this->hasColumn('camera_name', 'string', 100);
$this->hasColumn('exposure_time', 'double', null);
$this->hasColumn('fnumber', 'double', null);
$this->hasColumn('focal_length', 'double', null);
$this->hasColumn('iso_speed', 'smallint', 4);
$this->hasColumn('date_time', 'timestamp', null);
$this->hasColumn('image_type', 'smallint');
$this->hasColumn('v4_id', 'smallint', 5);
$this->hasColumn('v4_app', 'string', 3);
$this->hasColumn('activities', 'string', null);
// array
$this->hasColumn('author', 'string', 100);
}
<?php
use_helper('Field', 'SmartFormat', 'sfBBCode');
$item_i18n = $item->getRaw('OutingI18n');
$item_i18n = $item_i18n[0];
$a = sfConfig::get('app_activities_list');
$c = sfConfig::get('mod_outings_conditions_statuses_list');
$f = sfConfig::get('mod_outings_frequentation_statuses_list');
$conditions_status = doctrine_value($item['conditions_status']);
$frequentation_status = doctrine_value($item['frequentation_status']);
$properties = array('module' => 'outings', 'name' => $item_i18n['name'], 'url' => jsonlist_url($item_i18n, 'outings'), 'date' => $item['date'], 'activities' => $use_keys ? BaseDocument::convertStringToArray($item['activities']) : BaseDocument::convertStringToArrayTranslate($item['activities'], $a), 'creator' => $item['creator'], 'maxElevation' => doctrine_value($item['max_elevation']), 'heightDiffUp' => doctrine_value($item['height_diff_up']), 'routesRating' => isset($item['linked_routes']) ? field_route_ratings_data($item, false, false, false, $use_keys ? 'jsonkeys' : 'json') : null, 'conditionsStatus' => $use_keys ? $conditions_status : @$c[$conditions_status], 'frequentationStatus' => $use_keys ? $frequentation_status : @$f[$frequentation_status], 'nbLinkedImages' => isset($item['nb_images']) ? $item['nb_images'] : 0, 'nbComments' => isset($item['nb_comments']) ? $item['nb_comments'] : 0, 'hasTrack' => strlen($item['geom_wkt']) > 0 ? true : false, 'linkedAreas' => json_decode(get_partial('documents/regions4jsonlist', array('geoassociations' => $item['geoassociations'], 'use_keys' => $use_keys))));
if ($add_conditions) {
$avalanche_date_list = sfConfig::get('mod_outings_avalanche_date_list');
$avalanche_date = $use_keys ? BaseDocument::convertStringToArray($item['avalanche_date']) : BaseDocument::convertStringToArrayTranslate($item['avalanche_date'], $avalanche_date_list);
$has_avalanche_date = check_not_empty($avalanche_date) && !$avalanche_date instanceof sfOutputEscaperObjectDecorator && count($avalanche_date) && !array_intersect(array(0, 1), $avalanche_date);
$glacier_statuses = sfConfig::get('mod_outings_glacier_statuses_list');
$glacier_status = doctrine_value($item['glacier_status']);
$properties = array_merge($properties, array('accessElevation' => doctrine_value($item['access_elevation']), 'upSnowElevation' => doctrine_value($item['up_snow_elevation']), 'downSnowElevation' => doctrine_value($item['down_snow_elevation']), 'glacierStatus' => $use_keys ? $glacier_status : @$glacier_statuses[$glacier_status], 'avalancheObsType' => $avalanche_date));
if ($add_text) {
$outing_route_desc = $item_i18n['outing_route_desc'];
if (check_not_empty($outing_route_desc) && !$outing_route_desc instanceof sfOutputEscaperObjectDecorator) {
if ($text_html) {
$outing_route_desc = parse_links(parse_bbcode($outing_route_desc, null, false, false));
}
} else {
$outing_route_desc = null;
}
$conditions_levels = unserialize($item_i18n['conditions_levels']);
$conditions = $item_i18n['conditions'];
if (check_not_empty($conditions) && !$conditions instanceof sfOutputEscaperObjectDecorator) {
if ($text_html) {
<?php
$item_i18n = $item->getRaw('PortalI18n');
$item_i18n = $item_i18n[0];
$a = sfConfig::get('app_activities_list');
echo json_encode(array('type' => 'Feature', 'geometry' => null, 'id' => $item['id'], 'properties' => array('module' => 'portals', 'name' => $item_i18n['name'], 'url' => jsonlist_url($item_i18n, 'portals'), 'activities' => BaseDocument::convertStringToArrayTranslate($item['activities'], $a, 0), 'nbLinkedImages' => isset($item['nb_images']) ? $item['nb_images'] : 0, 'nbComments' => isset($item['nb_comments']) ? $item['nb_comments'] : 0)));
/**
* Returns a peer instance associated with this om.
*
* Since Peer classes are not to have any instance attributes, this method returns the
* same instance for all member of this class. The method could therefore
* be static, but this would prevent one from overriding the behavior.
*
* @return DocumentPeer
*/
public function getPeer()
{
if (self::$peer === null) {
self::$peer = new DocumentPeer();
}
return self::$peer;
}
public static function filterGetActivities($value)
{
return BaseDocument::convertStringToArray($value);
}
public static function filterSetWay_back($value)
{
return BaseDocument::returnNullIfEmpty($value);
}
<?php
$item_i18n = $item->getRaw('BookI18n');
$item_i18n = $item_i18n[0];
$bt = sfCOnfig::get('mod_books_book_types_list');
$a = sfConfig::get('app_activities_list');
echo json_encode(array('type' => 'Feature', 'geometry' => null, 'id' => $item['id'], 'properties' => array('module' => 'books', 'name' => $item_i18n['name'], 'url' => jsonlist_url($item_i18n, 'books'), 'types' => BaseDocument::convertStringToArrayTranslate($item['book_types'], $bt, 0), 'author' => doctrine_value($item->get('author')), 'editor' => doctrine_value($item->get('editor')), 'publicationDate' => doctrine_value($item['publication_date']), 'activities' => BaseDocument::convertStringToArrayTranslate($item['activities'], $a, 0), 'languages' => BaseDocument::convertStringToArray($item['langs'], 0), 'nbLinkedImages' => isset($item['nb_images']) ? $item['nb_images'] : 0, 'nbComments' => isset($item['nb_comments']) ? $item['nb_comments'] : 0)));
<?php
$item_i18n = $item->getRaw('ProductI18n');
$item_i18n = $item_i18n[0];
$pt = sfConfig::get('mod_products_types_list');
echo json_encode(array('type' => 'Feature', 'geometry' => geojson_geometry($item), 'id' => $item['id'], 'properties' => array('module' => 'products', 'name' => $item_i18n['name'], 'url' => jsonlist_url($item_i18n, 'products'), 'elevation' => doctrine_value($item['elevation']), 'productTypes' => BaseDocument::convertStringToArrayTranslate($item['product_type'], $pt, 0), 'website' => doctrine_value($item['url']), 'nbLinkedImages' => isset($item['nb_images']) ? $item['nb_images'] : 0, 'nbComments' => isset($item['nb_comments']) ? $item['nb_comments'] : 0, 'linkedAreas' => json_decode(get_partial('documents/regions4jsonlist', array('geoassociations' => $item['geoassociations']))), 'linkedParkings' => json_decode(get_partial('parkings/parkings4jsonlist', array('parkings' => isset($item['linked_docs']) ? $item['linked_docs'] : array()))))));
public function getDocumentCategory(PropelPDO $con = null, $doQuery = true)
{
if ($this->aDocumentCategory === null && !$doQuery) {
return null;
}
if (!isset(self::$DOCUMENT_CATEGORIES[$this->getDocumentCategoryId()])) {
self::$DOCUMENT_CATEGORIES[$this->getDocumentCategoryId()] = parent::getDocumentCategory($con, true);
}
return self::$DOCUMENT_CATEGORIES[$this->getDocumentCategoryId()];
}
<?php
$item_i18n = $item->getRaw('HutI18n');
$item_i18n = $item_i18n[0];
$st = sfConfig::get('mod_huts_shelter_types_list');
$a = sfConfig::get('app_activities_list');
echo json_encode(array('type' => 'Feature', 'geometry' => geojson_geometry($item), 'id' => $item['id'], 'properties' => array('module' => 'huts', 'name' => $item_i18n['name'], 'url' => jsonlist_url($item_i18n, 'huts'), 'elevation' => $item['elevation'], 'type' => $st[$item['shelter_type']], 'staffedCapacity' => doctrine_value($item['staffed_capacity']), 'unstaffedCapacity' => doctrine_value($item['unstaffed_capacity']), 'activities' => BaseDocument::convertStringToArrayTranslate($item['activities'], $a, 0), 'phone' => doctrine_value($item['phone']), 'website' => doctrine_value($item['url']), 'nbLinkedImages' => isset($item['nb_images']) ? $item['nb_images'] : 0, 'nbLinkedRoutes' => isset($item['nb_linked_docs']) ? $item['nb_linked_docs'] : 0, 'nbComments' => isset($item['nb_comments']) ? $item['nb_comments'] : 0, 'linkedAreas' => json_decode(get_partial('documents/regions4jsonlist', array('geoassociations' => $item['geoassociations']))), 'linkedParkings' => json_decode(get_partial('parkings/parkings4jsonlist', array('parkings' => isset($item['linked_docs']) ? $item['linked_docs'] : array()))))));
/**
* Since Validate tests to make sure certain fields have values, populate requirements here such as the modified timestamp
* @return boolean from parent
*/
protected function beforeValidate()
{
if ($this->isNewRecord) {
$this->datetime_cre = new CDbExpression('NOW()');
}
$this->modified = new CDbExpression('NOW()');
return parent::beforeValidate();
}
<?php
$item_i18n = $item->getRaw('UserI18n');
$item_i18n = $item_i18n[0];
$a = sfConfig::get('app_activities_list');
$c = sfConfig::get('mod_users_category_list');
// note that only public profiles are listed when no credential is provided
echo json_encode(array('type' => 'Feature', 'geometry' => null, 'id' => $item['id'], 'properties' => array('module' => 'users', 'name' => $item_i18n['name'], 'activities' => BaseDocument::convertStringToArrayTranslate($item['activities'], $a, 0), 'category' => @$c[doctrine_value($item['category'])])));
<?php
$item_i18n = $item->getRaw('ParkingI18n');
$item_i18n = $item_i18n[0];
$sc = sfConfig::get('mod_parkings_snow_clearance_ratings_list');
$ptr = sfConfig::get('app_parkings_public_transportation_ratings');
$ptt = sfConfig::get('app_parkings_public_transportation_types');
echo json_encode(array('type' => 'Feature', 'geometry' => geojson_geometry($item), 'id' => $item['id'], 'properties' => array('module' => 'parkings', 'name' => $item_i18n['name'], 'url' => jsonlist_url($item_i18n, 'parkings'), 'elevation' => $item['elevation'], 'lowestElevation' => doctrine_value($item['lowest_elevation']), 'snowClearance' => @$sc[doctrine_value($item['snow_clearance_rating'])], 'publicTransportationRating' => @$ptr[doctrine_value($item['public_transportation_rating'])], 'publicTransportationTypes' => BaseDocument::convertStringToArrayTranslate($item['public_transportation_types'], $ptt, 0), 'nbLinkedImage' => isset($item['nb_images']) ? $item['nb_images'] : 0, 'nbLinkedRoutes' => isset($item['nb_linked_docs']) ? $item['nb_linked_docs'] : 0, 'nbComments' => isset($item['nb_comments']) ? $item['nb_comments'] : 0, 'linkedAreas' => json_decode(get_partial('documents/regions4jsonlist', array('geoassociations' => $item['geoassociations']))))));
/**
* Constructor
*/
public function __construct()
{
parent::__construct('container');
$this->sensors = array();
}
/**
* Delete document
*
* @param void
* @return null
*/
function delete()
{
$filepath = $this->getFilePath();
db_begin_work();
$delete = parent::delete();
if (!$delete || is_error($delete)) {
db_rollback();
return $delete;
}
// if
$delete_attachments = Attachments::deleteByObject($this);
if (!$delete_attachments || is_error($delete_attachments)) {
db_rollback();
return $delete_attachments;
}
// if
if (is_file($filepath)) {
@unlink($filepath);
}
// if
db_commit();
return true;
}
public static function filterSetAccess($value)
{
return BaseDocument::returnNullIfEmpty($value);
}
function get_paginated_activities($value, $hide_picto = false, $picto_separator = ' ')
{
if (empty($value) || !is_string($value)) {
return '';
}
// FIXME: perform this conversion when retrieving data
$value = BaseDocument::convertStringToArray($value);
$activities = sfConfig::get('app_activities_list');
$out = array();
foreach ($value as $item) {
if (array_key_exists($item, $activities) && !empty($activities[$item])) {
$activity = $activities[$item];
$activity_num = $item;
$name = __($activity);
if ($hide_picto) {
$out[] = $name;
} else {
$out[] = '<span class="activity_' . $activity_num . ' picto" title="' . $name . '"></span>';
}
}
}
if ($hide_picto) {
return implode(', ', $out);
}
return implode($picto_separator, $out);
}
