/** * Updates media associated to a point * * @param string $poi * @param string $mm_type * * @return void */ public static function UpdateMedia($poi, $mm_type) { global $g_ado_db; global $g_user; /* A) 1) given article_number, language_id, map_id, list of map_loc_lan_id / new data B) //cycle: 1) read multimedia_id (as old_med_id) of the map_loc_med_id 2) insert new multimedia with new data 3) get the inserted id into new_med_id 4) update maplocationmultimedia into the new_med_id for the map_loc_med_id 6) delete multimedia of old_med_id if none maplocationmultimedia with a link into the old_med_id */ // ad B 1) $queryStr_med_id = "SELECT fk_multimedia_id AS med FROM " . self::TABLE_JOIN . " WHERE id = ?"; // ad B 2) $queryStr_med_in = "INSERT INTO " . self::TABLE . " (media_type, media_spec, media_src, media_width, media_height, IdUser) VALUES ("; $queryStr_med_in .= "?, ?, ?, ?, ?"; $queryStr_med_in .= ", %%user_id%%)"; // ad B 4) $queryStr_map_up = "UPDATE " . self::TABLE_JOIN . " SET fk_multimedia_id = ? WHERE id = ?"; $queryStr_map_in = "INSERT INTO " . self::TABLE_JOIN . " (fk_maplocation_id, fk_multimedia_id) VALUES (?, ?)"; $queryStr_map_rm = "DELETE FROM " . self::TABLE_JOIN . " WHERE id = ?"; // ad B 6) $queryStr_med_rm = "DELETE FROM " . self::TABLE . " WHERE id = ? AND NOT EXISTS (SELECT id FROM " . self::TABLE_JOIN . " WHERE fk_multimedia_id = ?)"; // ad B 1) $mm_id = null; $mm_spec = ""; $mm_src = ""; $mm_width = ""; $mm_height = ""; $mm_insert = false; if ("image" == $mm_type) { //print_r($poi); $mm_id = $poi["image_mm"]; $mm_spec = ""; $mm_src = $poi["image_src"]; $mm_width = $poi["image_width"]; $mm_height = $poi["image_height"]; if ("" != $mm_src) {$mm_insert = true;} } if ("video" == $mm_type) { $mm_id = $poi["video_mm"]; $mm_spec = $poi["video_type"]; $mm_src = $poi["video_id"]; $mm_width = $poi["video_width"]; $mm_height = $poi["video_height"]; if ("" != $mm_src) {$mm_insert = true;} } if (null === $mm_id) {return;} $med_old_id = null; if ($mm_id) { try { $mapmed_sel_params = array(); $mapmed_sel_params[] = $mm_id; $rows = $g_ado_db->GetAll($queryStr_med_id, $mapmed_sel_params); if (is_array($rows)) { foreach ($rows as $row) { $med_old_id = $row['med']; } } } catch (Exception $exc) { return false; } if (null === $med_old_id) {return;} } // ad B 2) $med_new_id = 0; // insert (and connect) just when there is something to insert if ($mm_insert) { $mm_options = ""; // currently no options used $reuse_id = Geo_Multimedia::FindMedia($mm_type, $mm_spec, $mm_src, $mm_width, $mm_height, $mm_options); if ($reuse_id && (0 < $reuse_id)) { $med_new_id = $reuse_id; } else { $med_ins_params = array(); $med_ins_params[] = "" . $mm_type; $med_ins_params[] = "" . $mm_spec; $med_ins_params[] = "" . $mm_src; $med_ins_params[] = 0 + $mm_width; $med_ins_params[] = 0 + $mm_height; $queryStr_med_in = str_replace("%%user_id%%", $g_user->getUserId(), $queryStr_med_in); $success = $g_ado_db->Execute($queryStr_med_in, $med_ins_params); // ad B 3) $med_new_id = $g_ado_db->Insert_ID(); } // ad B 4) -- was no media for this connector, thus create a new one if (null === $med_old_id) { $map_in_params = array(); $map_in_params[] = $poi["location_id"]; $map_in_params[] = $med_new_id; $success = $g_ado_db->Execute($queryStr_map_in, $map_in_params); return; } else // -- already had a media, thus just update the connector { $map_up_params = array(); $map_up_params[] = $med_new_id; $map_up_params[] = $mm_id; $success = $g_ado_db->Execute($queryStr_map_up, $map_up_params); } } else // here: nothing to left connected, thus deleting the old connector if any { if ($mm_id) // if a connector was there { // ad B 4) deleting the old connector; $map_rm_params = array(); $map_rm_params[] = $mm_id; $success = $g_ado_db->Execute($queryStr_map_rm, $map_rm_params); } } // ad B 6) try { $med_rm_params = array(); $med_rm_params[] = $med_old_id; $med_rm_params[] = $med_old_id; $success = $g_ado_db->Execute($queryStr_med_rm, $med_rm_params); } catch (Exception $exc) { return false; } } // fn UpdateMedia
/** * Inserts points (with locations and other contents) into the map. * NB: The result indices are used at the point order updating, since that order-updating * would not know id's of the new points otherwise. * * @param int $p_mapId * @param int $p_languageId * @param int $p_articleNumber * @param array $p_insertion * @param array $p_indices * * @return array */ public static function InsertPoints($p_mapId, $p_languageId, $p_articleNumber, $p_insertion, &$p_indices) { global $g_ado_db; global $g_user; Geo_MapLocation::CleanFound(); // this should not happen if (0 == $p_mapId) { return array(); } /* A) 1) given article_number, language_id, map_id, list of new data 2) read languages of the article B) cycle: 1) insert into Locations the new position 2) get inserted id as location_id 3) insert into LocationContents the most of the new data, 4) get inserted id as content_id 5) insert into MapLocations (map_id, location_id, data:style, rank=0) 6) get inserted id as maplocation_id 7) insert into MapLocationLanguages (maplocation_id, language_id, content_id, data:display) ad 7) this for all languages, with display=false for the other ones */ // ad B 1) $queryStr_loc_in = 'INSERT INTO Locations (poi_location, poi_type, poi_type_style, poi_center, poi_radius, IdUser) VALUES ('; $queryStr_loc_in .= "GeomFromText('POINT(? ?)'), 'point', 0, PointFromText('POINT(? ?)'), 0, %%user_id%%"; $queryStr_loc_in .= ')'; // ad B 3) // ad B 5) $queryStr_maploc = 'INSERT INTO MapLocations (fk_map_id, fk_location_id, poi_style, rank) '; $queryStr_maploc .= 'VALUES (?, ?, ?, 0)'; // ad B 7) $queryStr_maploclan = 'INSERT INTO MapLocationLanguages (fk_maplocation_id, fk_language_id, fk_content_id, poi_display) '; $queryStr_maploclan .= 'VALUES (?, ?, ?, ?)'; if ($p_articleNumber) { $languages = Geo_Map::ReadLanguagesByArticle($p_articleNumber); } else { $languages = Geo_Map::ReadLanguagesByMap($p_mapId); } foreach ($p_insertion as $poi) { if (is_object($poi)) { $poi = get_object_vars($poi); } $loc_id = null; $new_loc = array(); $new_loc[] = array('latitude' => $poi['latitude'], 'longitude' => $poi['longitude']); $new_cen = array('latitude' => $poi['latitude'], 'longitude' => $poi['longitude']); $new_style = 0; $new_radius = 0; $reuse_id = Geo_Location::FindLocation($new_loc, 'point', $new_style, $new_cen, $new_radius); if ($reuse_id && 0 < $reuse_id) { $loc_id = $reuse_id; } else { // ad B 1) $loc_in_params = array(); $loc_in_params[] = $poi['latitude']; $loc_in_params[] = $poi['longitude']; $loc_in_params[] = $poi['latitude']; $loc_in_params[] = $poi['longitude']; // the POI itself insertion $queryStr_loc_in = str_replace('%%user_id%%', $g_user->getUserId(), $queryStr_loc_in); $success = $g_ado_db->Execute($queryStr_loc_in, $loc_in_params); // ad B 2) // taking its ID for the next processing $loc_id = $g_ado_db->Insert_ID(); } // ad B 3/4) $con_id = Geo_MapLocationContent::InsertContent($poi); // ad B 5) $maploc_params = array(); $maploc_params[] = $p_mapId; $maploc_params[] = $loc_id; $maploc_params[] = '' . $poi['style']; // the map-point link insertion $success = $g_ado_db->Execute($queryStr_maploc, $maploc_params); // ad B 6) $maploc_id = $g_ado_db->Insert_ID(); Geo_Multimedia::InsertMultimedia($maploc_id, $poi); // ad B 7) $maploclan_params = array(); $maploclan_params[] = $maploc_id; $maploclan_params[] = 0 + $p_languageId; $maploclan_params[] = $con_id; $maploclan_params[] = 0 + $poi['display']; // the map-point link insertion $success = $g_ado_db->Execute($queryStr_maploclan, $maploclan_params); $poi_index = $poi['index']; $p_indices[$poi_index] = array('maploc' => $maploc_id); // insert the POI content for the other article's languages foreach ($languages as $one_lang) { if ($one_lang == $p_languageId) { continue; } $maploclan_params[1] = $one_lang; $maploclan_params[3] = 0; // false; // display; $success = $g_ado_db->Execute($queryStr_maploclan, $maploclan_params); } // if a new POI, then that's all for it here continue; } return $p_indices; }
/** * Get multimedia * @return array of IGeoMultimedia */ public function getMultimedia() { if ($this->multimedia === NULL) { $this->multimedia = Geo_Multimedia::GetByMapLocation($this); } return $this->multimedia; }
/** * Updates the point text content, the COW way * * @param int $p_mapId * @param array $p_contents * * @return bool */ public static function UpdateContents($p_mapId, $p_contents) { global $g_ado_db; foreach ($p_contents as $poi_obj) { $poi = get_object_vars($poi_obj); if ($poi['icon_changed']) { self::UpdateIcon($poi); } if ($poi['state_changed']) { Geo_MapLocationContent::UpdateState($poi); } if ($poi['image_changed']) { Geo_Multimedia::UpdateMedia($poi, 'image'); } if ($poi['video_changed']) { Geo_Multimedia::UpdateMedia($poi, 'video'); } if ($poi['text_changed']) { Geo_MapLocationContent::UpdateText($poi); } } return true; }
/** * Updates the point text content, the COW way * * @param int $p_mapId * @param array $p_contents * * @return bool */ public static function UpdateContents($p_mapId, $p_contents) { global $g_ado_db; foreach ($p_contents as $poi_obj) { $poi = get_object_vars($poi_obj); if ($poi["icon_changed"]) { self::UpdateIcon($poi); } if ($poi["state_changed"]) { Geo_MapLocationContent::UpdateState($poi); } if ($poi["image_changed"]) { Geo_Multimedia::UpdateMedia($poi, "image"); } if ($poi["video_changed"]) { Geo_Multimedia::UpdateMedia($poi, "video"); } if ($poi["text_changed"]) { Geo_MapLocationContent::UpdateText($poi); } } ; return true; } // fn UpdateContents
/** * Updates media associated to a point * * @param string $poi * @param string $mm_type * * @return void */ public static function UpdateMedia($poi, $mm_type) { global $g_ado_db; global $g_user; /* A) 1) given article_number, language_id, map_id, list of map_loc_lan_id / new data B) //cycle: 1) read multimedia_id (as old_med_id) of the map_loc_med_id 2) insert new multimedia with new data 3) get the inserted id into new_med_id 4) update maplocationmultimedia into the new_med_id for the map_loc_med_id 6) delete multimedia of old_med_id if none maplocationmultimedia with a link into the old_med_id */ // ad B 1) $queryStr_med_id = 'SELECT fk_multimedia_id AS med FROM ' . self::TABLE_JOIN . ' WHERE id = ?'; // ad B 2) $queryStr_med_in = 'INSERT INTO ' . self::TABLE . ' (media_type, media_spec, media_src, media_width, media_height, IdUser) VALUES ('; $queryStr_med_in .= '?, ?, ?, ?, ?'; $queryStr_med_in .= ', %%user_id%%)'; // ad B 4) $queryStr_map_up = 'UPDATE ' . self::TABLE_JOIN . ' SET fk_multimedia_id = ? WHERE id = ?'; $queryStr_map_in = 'INSERT INTO ' . self::TABLE_JOIN . ' (fk_maplocation_id, fk_multimedia_id) VALUES (?, ?)'; $queryStr_map_rm = 'DELETE FROM ' . self::TABLE_JOIN . ' WHERE id = ?'; // ad B 6) $queryStr_med_rm = 'DELETE FROM ' . self::TABLE . ' WHERE id = ? AND NOT EXISTS (SELECT id FROM ' . self::TABLE_JOIN . ' WHERE fk_multimedia_id = ?)'; // ad B 1) $mm_id = null; $mm_spec = ''; $mm_src = ''; $mm_width = ''; $mm_height = ''; $mm_insert = false; if ('image' == $mm_type) { $mm_id = $poi['image_mm']; $mm_spec = ''; $mm_src = $poi['image_src']; $mm_width = $poi['image_width']; $mm_height = $poi['image_height']; if ('' != $mm_src) { $mm_insert = true; } } if ('video' == $mm_type) { $mm_id = $poi['video_mm']; $mm_spec = $poi['video_type']; $mm_src = $poi['video_id']; $mm_width = $poi['video_width']; $mm_height = $poi['video_height']; if ('' != $mm_src) { $mm_insert = true; } } if (null === $mm_id) { return; } $med_old_id = null; if ($mm_id) { try { $mapmed_sel_params = array(); $mapmed_sel_params[] = $mm_id; $rows = $g_ado_db->GetAll($queryStr_med_id, $mapmed_sel_params); if (is_array($rows)) { foreach ($rows as $row) { $med_old_id = $row['med']; } } } catch (Exception $exc) { return false; } if (null === $med_old_id) { return; } } // ad B 2) $med_new_id = 0; // insert (and connect) just when there is something to insert if ($mm_insert) { $mm_options = ''; // currently no options used $reuse_id = Geo_Multimedia::FindMedia($mm_type, $mm_spec, $mm_src, $mm_width, $mm_height, $mm_options); if ($reuse_id && 0 < $reuse_id) { $med_new_id = $reuse_id; } else { $med_ins_params = array(); $med_ins_params[] = '' . $mm_type; $med_ins_params[] = '' . $mm_spec; $med_ins_params[] = '' . $mm_src; $med_ins_params[] = 0 + $mm_width; $med_ins_params[] = 0 + $mm_height; $queryStr_med_in = str_replace('%%user_id%%', $g_user->getUserId(), $queryStr_med_in); $success = $g_ado_db->Execute($queryStr_med_in, $med_ins_params); // ad B 3) $med_new_id = $g_ado_db->Insert_ID(); } // ad B 4) -- was no media for this connector, thus create a new one if (null === $med_old_id) { $map_in_params = array(); $map_in_params[] = $poi['location_id']; $map_in_params[] = $med_new_id; $success = $g_ado_db->Execute($queryStr_map_in, $map_in_params); return; } else { $map_up_params = array(); $map_up_params[] = $med_new_id; $map_up_params[] = $mm_id; $success = $g_ado_db->Execute($queryStr_map_up, $map_up_params); } } else { if ($mm_id) { // ad B 4) deleting the old connector; $map_rm_params = array(); $map_rm_params[] = $mm_id; $success = $g_ado_db->Execute($queryStr_map_rm, $map_rm_params); } } // ad B 6) try { $med_rm_params = array(); $med_rm_params[] = $med_old_id; $med_rm_params[] = $med_old_id; $success = $g_ado_db->Execute($queryStr_med_rm, $med_rm_params); } catch (Exception $exc) { return false; } }
/** * Returns map locations list based on the given parameters. * * @param array $p_parameters * An array of ComparionOperation objects * @param array $p_order * An array of columns and directions to order by * @param integer $p_start * The record number to start the list * @param integer $p_limit * The offset, how many records from $p_start will be retrieved * @param integer $p_count * Total count of POIs without p_start/p_limit limitations * @param bool $p_skipCache * Whether to skip caching * @param array $p_rawData * The variable for returning read points as raw array, used for the JS processing * * @return array */ public static function GetListExt(array $p_parameters, array $p_order = array(), $p_start = 0, $p_limit = 0, &$p_count, $p_skipCache = false, &$p_rawData = null) { $p_count = 0; if (!is_numeric($p_limit)) { $p_limit = 0; } if (!is_numeric($p_start)) { $p_start = 0; } $ps_saveArray = false; if (!is_null($p_rawData)) { $ps_saveArray = true; $p_rawData = array(); } $list_spec = array('params' => $p_parameters, 'order' => $p_order, 'start' => $p_start, 'limit' => $p_limit, 'skip_cache' => $p_skipCache, 'raw_data' => $p_rawData); $list_spec_str = serialize($list_spec); if (!$p_skipCache && !empty(self::$s_found_maplocations_list_ext) && isset(self::$s_found_maplocations_list_ext[$list_spec_str])) { $list_res_data = self::$s_found_maplocations_list_ext[$list_spec_str]; $p_count = $list_res_data['count']; $list_obj = $list_res_data['list_obj']; if ($ps_saveArray) { $p_rawData = $list_res_data['list_raw']; } return $list_obj; } $ps_mapId = 0; $ps_languageId = 0; $ps_preview = false; // read all the info, mostly cached at the upstream $ps_publicationId = 0; $mc_mapCons = false; $mc_article_types_yes = array(); $mc_article_types_no = array(); $mc_authors_yes = array(); $mc_authors_no = array(); $mc_users_yes = array(); $mc_users_no = array(); $mc_articles_yes = array(); $mc_articles_no = array(); $mc_issues = array(); $mc_sections = array(); $mc_section_names = array(); $mc_topics = array(); $mc_topic_names = array(); $mc_topics_matchall = false; $mc_multimedia = array(); $mc_areas = array(); $mc_areas_matchall = false; $mc_areas_exact = true; $mc_dates = array(); $mc_icons = array(); // process params foreach ($p_parameters as $param) { switch ($param->getLeftOperand()) { case 'constrained': $mc_mapCons = true; case 'map': if (is_numeric($param->getRightOperand())) { $ps_mapId = $param->getRightOperand(); } break; case 'language': if (is_numeric($param->getRightOperand())) { $ps_languageId = 0 + $param->getRightOperand(); } break; case 'active_only': case 'preview': $ps_preview = $param->getRightOperand(); break; case 'publication': $ps_publicationId = (int) $param->getRightOperand(); break; case 'article_type': $one_arttp_value = $param->getRightOperand(); $one_arttp_type = $param->getOperator()->getName(); if ('is' == $one_arttp_type) { $mc_article_types_yes[] = $one_arttp_value; $mc_mapCons = true; } if ('not' == $one_arttp_type) { $mc_article_types_no[] = $one_arttp_value; $mc_mapCons = true; } break; case 'author': $one_user_value = $param->getRightOperand(); $one_user_type = $param->getOperator()->getName(); if ('is' == $one_user_type) { $mc_authors_yes[] = $one_user_value; $mc_mapCons = true; } if ('not' == $one_user_type) { $mc_authors_no[] = $one_user_value; $mc_mapCons = true; } break; case 'article': $one_article_value = $param->getRightOperand(); $one_article_type = $param->getOperator()->getName(); if ('is' == $one_article_type) { $mc_articles_yes[] = $one_article_value; $mc_mapCons = true; } if ('not' == $one_article_type) { $mc_articles_no[] = $one_article_value; $mc_mapCons = true; } break; case 'issue': $mc_issues[] = $param->getRightOperand(); $mc_mapCons = true; break; case 'section': $mc_sections[] = $param->getRightOperand(); $mc_mapCons = true; break; case 'section_name': $mc_section_names[] = $param->getRightOperand(); $mc_mapCons = true; break; case 'topic': $mc_topics[] = $param->getRightOperand(); $mc_mapCons = true; break; case 'topic_name': $mc_topic_names[] = $param->getRightOperand(); $mc_mapCons = true; break; case 'matchalltopics': $mc_topics_matchall = $param->getRightOperand(); break; case 'matchanytopic': $mc_topics_matchall = !$param->getRightOperand(); break; case 'multimedia': $mc_multimedia[] = $param->getRightOperand(); $mc_mapCons = true; break; case 'area': $mc_areas[] = json_decode($param->getRightOperand()); $mc_mapCons = true; break; case 'matchallareas': $mc_areas_matchall = $param->getRightOperand(); break; case 'matchanyarea': $mc_areas_matchall = !$param->getRightOperand(); break; case 'exactarea': $mc_areas_exact = $param->getRightOperand(); break; case 'date': $mc_dates[$param->getOperator()->getName()] = $param->getRightOperand(); $mc_mapCons = true; break; case 'icon': $mc_icons[] = $param->getRightOperand(); $mc_mapCons = true; break; default: break; } } // constrained maps ned to have set publication if ($mc_mapCons && !$ps_publicationId) { return array(); } if (!$ps_languageId || 0 >= $ps_languageId) { $ps_languageId = $Context->language->number; } if (!$ps_languageId || 0 >= $ps_languageId) { return array(); } if (!CampCache::IsEnabled()) { $p_skipCache = true; } $ps_orders = array(); if (!$p_order || !is_array($p_order) || 0 == count($p_order)) { if ($mc_mapCons) { $ps_orders = array(array('a.Number' => 'DESC'), array('m.id' => 'DESC')); } } else { $allowed_order_dirs = array('DESC' => true, 'ASC' => true); foreach ($p_order as $one_order_column => $one_order_dir) { $one_dir = strtoupper($one_order_dir); if (!array_key_exists($one_dir, $allowed_order_dirs)) { continue; } switch (strtolower($one_order_column)) { case 'article': if (!$mc_mapCons) { break; } $ps_orders[] = array('a.Number' => $one_dir); break; case 'map': $ps_orders[] = array('m.id' => $one_dir); break; case 'name': $ps_orders[] = array('c.poi_name' => $one_dir); break; } } } if ((0 == $ps_mapId || !$ps_mapId) && !$mc_mapCons) { return array(); } $mc_limit = 0 + $p_limit; if (0 > $mc_limit) { $mc_limit = 0; } $mc_start = 0 + $p_start; if (0 > $mc_start) { $mc_start = 0; } $dataArray = array(); $objsArray = array(); $cachedData = null; $paramsArray_arr = array(); $paramsArray_obj = array(); $cacheList_arr = null; $cacheList_obj = null; if (!$p_skipCache) { $paramsArray_arr['as_array'] = true; $paramsArray_arr['map_id'] = $ps_mapId; $paramsArray_arr['publication_id'] = $ps_publicationId; $paramsArray_arr['language_id'] = $ps_languageId; $paramsArray_arr['preview'] = $ps_preview; $paramsArray_arr['map_cons'] = $mc_mapCons; $paramsArray_arr['article_types_yes'] = $mc_article_types_yes; $paramsArray_arr['article_types_no'] = $mc_article_types_no; $paramsArray_arr['authors_yes'] = $mc_authors_yes; $paramsArray_arr['authors_no'] = $mc_authors_no; $paramsArray_arr['articles_yes'] = $mc_articles_yes; $paramsArray_arr['articles_no'] = $mc_articles_no; $paramsArray_arr['issues'] = $mc_issues; $paramsArray_arr['sections'] = $mc_sections; $paramsArray_arr['section_names'] = $mc_section_names; $paramsArray_arr['topics'] = $mc_topics; $paramsArray_arr['topic_names'] = $mc_topic_names; $paramsArray_arr['topics_matchall'] = $mc_topics_matchall; $paramsArray_arr['multimedia'] = $mc_multimedia; $paramsArray_arr['areas'] = $mc_areas; $paramsArray_arr['areas_matchall'] = $mc_areas_matchall; $paramsArray_arr['areas_exact'] = $mc_areas_exact; $paramsArray_arr['dates'] = $mc_dates; $paramsArray_arr['icons'] = $mc_icons; $paramsArray_arr['orders'] = $ps_orders; $paramsArray_arr['limit'] = $mc_limit; $paramsArray_arr['start'] = $mc_start; $paramsArray_obj = $paramsArray_arr; $paramsArray_obj['as_array'] = false; $cacheList_arr = new CampCacheList($paramsArray_arr, __METHOD__); $cacheList_obj = new CampCacheList($paramsArray_obj, __METHOD__); if ($ps_saveArray) { $cachedData = $cacheList_arr->fetchFromCache(); if ($cachedData !== false && is_array($cachedData)) { $p_count = $cachedData['count']; $p_rawData = $cachedData['data']; } } $cachedData = $cacheList_obj->fetchFromCache(); if ($cachedData !== false && is_array($cachedData)) { $p_count = $cachedData['count']; return $cachedData['data']; } } global $g_ado_db; if (0 < count($mc_authors_yes)) { $author_ids_req_names = ArticleAuthor::BuildAuthorIdsQuery($mc_authors_yes); $author_ids_req_alias = AuthorAlias::BuildAuthorIdsQuery($mc_authors_yes); if ($author_ids_req_names) { $rows = $g_ado_db->GetAll($author_ids_req_names); if (is_array($rows)) { foreach ($rows as $row) { $mc_users_yes[] = trim(strtolower($row['id'])); } } } if ($author_ids_req_alias) { $rows = $g_ado_db->GetAll($author_ids_req_alias); if (is_array($rows)) { foreach ($rows as $row) { $mc_users_yes[] = trim(strtolower($row['id'])); } } } if (0 == count($mc_users_yes)) { return array(); } } if (0 < count($mc_authors_no)) { $author_ids_req_names = ArticleAuthor::BuildAuthorIdsQuery($mc_authors_no); $author_ids_req_alias = AuthorAlias::BuildAuthorIdsQuery($mc_authors_no); if ($author_ids_req_names) { $rows = $g_ado_db->GetAll($author_ids_req_names); if (is_array($rows)) { foreach ($rows as $row) { $mc_users_no[] = trim(strtolower($row['id'])); } } } if ($author_ids_req_alias) { $rows = $g_ado_db->GetAll($author_ids_req_alias); if (is_array($rows)) { foreach ($rows as $row) { $mc_users_no[] = trim(strtolower($row['id'])); } } } } if (0 < count($mc_section_names)) { $section_ids_req_names = Section::BuildSectionIdsQuery($mc_section_names, $ps_publicationId); if ($section_ids_req_names) { $rows = $g_ado_db->GetAll($section_ids_req_names); if (is_array($rows)) { foreach ($rows as $row) { $mc_sections[] = trim(strtolower($row['id'])); } } } if (0 == count($mc_sections)) { return array(); } } if (0 < count($mc_topic_names)) { $topic_ids_req_names = TopicName::BuildTopicIdsQuery($mc_topic_names); if ($topic_ids_req_names) { $rows = $g_ado_db->GetAll($topic_ids_req_names); if (is_array($rows)) { foreach ($rows as $row) { $mc_topics[] = trim(strtolower($row['id'])); } } } if (0 == count($mc_topics)) { return array(); } } $ps_orders = array(); if (!$p_order || !is_array($p_order) || 0 == count($p_order)) { if ($mc_mapCons) { $ps_orders = array(array('a.PublishDate' => 'DESC'), array('a.Number' => 'DESC'), array('m.id' => 'DESC')); } } else { $allowed_order_dirs = array('DESC' => true, 'ASC' => true); foreach ($p_order as $one_order_column => $one_order_dir) { $one_dir = strtoupper($one_order_dir); if (!array_key_exists($one_dir, $allowed_order_dirs)) { continue; } switch (strtolower($one_order_column)) { case 'publish': case 'published': if (!$mc_mapCons) { break; } $ps_orders[] = array('a.PublishDate' => $one_dir); break; case 'article': if (!$mc_mapCons) { break; } $ps_orders[] = array('a.Number' => $one_dir); break; case 'map': $ps_orders[] = array('m.id' => $one_dir); break; case 'name': $ps_orders[] = array('c.poi_name' => $one_dir); break; } } } if ((0 == $ps_mapId || !$ps_mapId) && !$mc_mapCons) { return array(); } $queryStr = ''; $queryStr_start = ''; $queryStr_start .= 'SELECT DISTINCT ml.id AS ml_id, mll.id as mll_id, ml.fk_location_id AS loc_id, mll.fk_content_id AS con_id, '; $queryStr_start .= 'ml.poi_style AS poi_style, ml.rank AS rank, mll.poi_display AS poi_display, '; // these few lines below are just for data for list-of-objects array $queryStr_start .= 'l.poi_radius AS l_radius, l.IdUser AS l_user, l.time_updated AS l_updated, '; if ($mc_mapCons) { $queryStr_start .= 'm.id AS m_id, m.IdUser AS m_user, m.fk_article_number AS art_number, GROUP_CONCAT(DISTINCT m.fk_article_number ORDER BY m.fk_article_number DESC) AS art_numbers, '; } $multimedia_def = "CONCAT(mu.id, \"-\", mlmu.id)"; if ($mc_mapCons) { $multimedia_def = 'mu.id'; } $queryStr_start .= "(SELECT {$multimedia_def} FROM MapLocationMultimedia AS mlmu INNER JOIN Multimedia AS mu ON mlmu.fk_multimedia_id = mu.id WHERE mlmu.fk_maplocation_id = ml.id AND mu.media_type = 'image' ORDER BY mu.id LIMIT 1) AS image_mm, "; $queryStr_start .= "(SELECT {$multimedia_def} FROM MapLocationMultimedia AS mlmu INNER JOIN Multimedia AS mu ON mlmu.fk_multimedia_id = mu.id WHERE mlmu.fk_maplocation_id = ml.id AND mu.media_type = 'video' ORDER BY mu.id LIMIT 1) AS video_mm, "; $queryStr_start .= 'c.IdUser AS c_user, c.time_updated AS c_updated, '; $queryStr_start .= 'AsText(l.poi_location) AS loc, l.poi_type AS poi_type, l.poi_type_style AS poi_type_style, '; $queryStr_start .= 'c.poi_name AS poi_name, c.poi_link AS poi_link, c.poi_perex AS poi_perex, '; $queryStr_start .= 'c.poi_content_type AS poi_content_type, c.poi_content AS poi_content, c.poi_text AS poi_text '; $queryStr .= 'FROM MapLocations AS ml INNER JOIN MapLocationLanguages AS mll ON ml.id = mll.fk_maplocation_id '; $queryStr .= 'INNER JOIN Locations AS l ON l.id = ml.fk_location_id '; $queryStr .= 'INNER JOIN LocationContents AS c ON c.id = mll.fk_content_id '; $query_mcons = ''; $article_mcons = false; $mc_filter_mm = false; $mc_filter_image = false; $mc_filter_video = false; if ($mc_mapCons) { $queryStr .= 'INNER JOIN Maps AS m ON m.id = ml.fk_map_id '; $queryStr .= 'INNER JOIN Articles AS a ON m.fk_article_number = a.Number '; if (0 < count($mc_users_yes) || 0 < count($mc_users_no)) { $queryStr .= 'INNER JOIN ArticleAuthors AS aa ON aa.fk_article_number = a.Number '; } $query_mcons = "a.IdPublication = {$ps_publicationId} AND "; $article_mcons = false; foreach ($mc_multimedia as $one_multimedia) { if ('any' == $one_multimedia) { $mc_filter_mm = true; } if ('image' == $one_multimedia) { $mc_filter_image = true; } if ('video' == $one_multimedia) { $mc_filter_video = true; } } if (0 < count($mc_users_yes)) { $query_mcons .= 'aa.fk_author_id IN (' . implode(', ', $mc_users_yes) . ') AND '; $article_mcons = true; } if (0 < count($mc_users_no)) { $query_mcons .= 'aa.fk_author_id NOT IN (' . implode(', ', $mc_users_no) . ') AND '; $article_mcons = true; } if (0 < count($mc_article_types_yes)) { $mc_correct = true; foreach ($mc_article_types_yes as $val) { if (false !== stripos($val, '\'')) { $mc_correct = false; break; } if (false !== stripos($val, '"')) { $mc_correct = false; break; } } if ($mc_correct) { $query_mcons .= 'a.Type IN (\'' . implode('\', \'', $mc_article_types_yes) . '\') AND '; $article_mcons = true; } } if (0 < count($mc_article_types_no)) { $mc_correct = true; foreach ($mc_article_types_no as $val) { if (false !== stripos($val, '\'')) { $mc_correct = false; break; } if (false !== stripos($val, '"')) { $mc_correct = false; break; } } if ($mc_correct) { $query_mcons .= 'a.Type NOT IN (\'' . implode('\', \'', $mc_article_types_no) . '\') AND '; $article_mcons = true; } } if (0 < count($mc_articles_yes)) { $mc_correct = true; foreach ($mc_articles_yes as $val) { if (!is_numeric($val)) { $mc_correct = false; } } if ($mc_correct) { $query_mcons .= 'a.Number IN (' . implode(', ', $mc_articles_yes) . ') AND '; $article_mcons = true; } } if (0 < count($mc_articles_no)) { $mc_correct = true; foreach ($mc_articles_no as $val) { if (!is_numeric($val)) { $mc_correct = false; } } if ($mc_correct) { $query_mcons .= 'a.Number NOT IN (' . implode(', ', $mc_articles_no) . ') AND '; $article_mcons = true; } } if (0 < count($mc_issues)) { $mc_correct = true; foreach ($mc_issues as $val) { if (!is_numeric($val)) { $mc_correct = false; } } if ($mc_correct) { $query_mcons .= 'a.NrIssue IN (' . implode(', ', $mc_issues) . ') AND '; $article_mcons = true; } } if (0 < count($mc_sections)) { $mc_correct = true; foreach ($mc_sections as $val) { if (!is_numeric($val)) { $mc_correct = false; } } if ($mc_correct) { $query_mcons .= 'a.NrSection IN (' . implode(', ', $mc_sections) . ') AND '; $article_mcons = true; } } foreach ($mc_dates as $one_date_type => $one_date_value_arr) { if (0 == count($one_date_value_arr)) { continue; } $one_date_value = $one_date_value_arr[0]; $one_date_value = trim($one_date_value); $one_date_value = trim($one_date_value, "\"'"); $one_date_value = str_replace("'", "\"", $one_date_value); $one_date_usage = 'CAST(a.PublishDate AS DATE) '; $one_date_known = false; if ('smaller_equal' == $one_date_type) { $one_date_usage .= '<= '; $one_date_known = true; } if ('smaller' == $one_date_type) { $one_date_usage .= '< '; $one_date_known = true; } if ('greater_equal' == $one_date_type) { $one_date_usage .= '>= '; $one_date_known = true; } if ('greater' == $one_date_type) { $one_date_usage .= '> '; $one_date_known = true; } if ('is' == $one_date_type) { $one_date_usage .= '= '; $one_date_known = true; } if ('not' == $one_date_type) { $one_date_usage .= '<> '; $one_date_known = true; } if (!$one_date_known) { continue; } $one_date_usage .= "'{$one_date_value}' AND "; $query_mcons .= $one_date_usage; $article_mcons = true; } $mc_icons_usage = array(); foreach ($mc_icons as $one_icon_value) { $one_icon_value = str_replace("'", "\"", $one_icon_value); if (0 < strlen($one_icon_value)) { $mc_icons_usage[] = $one_icon_value; } } if (0 < count($mc_icons_usage)) { $query_mcons .= "ml.poi_style IN ('" . implode("', '", $mc_icons_usage) . "') AND "; $article_mcons = true; } if (0 < count($mc_topics)) { $mc_topics_list = array(); $mc_topics_conn = 'OR'; if ($mc_topics_matchall) { $mc_topics_conn = 'AND'; } foreach ($mc_topics as $one_topic) { if (!is_numeric($one_topic)) { continue; } $mc_topics_list[] = 'EXISTS (SELECT at.TopicId FROM ArticleTopics AS at WHERE a.Number = at.NrArticle AND at.TopicId IN (' . Topic::BuildAllSubtopicsQuery($one_topic, false) . '))'; } if (0 < count($mc_topics_list)) { $query_mcons .= '(' . implode(" {$mc_topics_conn} ", $mc_topics_list) . ') AND '; $article_mcons = true; } } $mc_areas_list = array(); $mc_areas_conn = 'OR'; if ($mc_areas_matchall) { $mc_areas_conn = 'AND'; } foreach ($mc_areas as $one_area) { if (is_object($one_area)) { $one_area = get_object_vars($one_area); } $mc_rectangle = $one_area['rectangle']; $mc_polygon = $one_area['polygon']; if ($mc_rectangle && 2 == count($mc_rectangle)) { $area_cons_res = Geo_MapLocation::GetGeoSearchSQLCons($mc_rectangle, 'rectangle', 'l'); if (!$area_cons_res['error']) { $mc_areas_list[] = $area_cons_res['cons']; $article_mcons = true; } } if ($mc_polygon && 3 <= count($mc_polygon)) { $area_cons_res = Geo_MapLocation::GetGeoSearchSQLCons($mc_polygon, 'polygon', 'l'); $area_cons_res_finer = null; if ($mc_areas_exact) { $area_cons_res_finer = Geo_MapLocation::GetGeoSearchPointInPolygon($mc_polygon, 'l'); } if (!$area_cons_res['error']) { $one_area_cons = $area_cons_res['cons']; if ($mc_areas_exact && !$area_cons_res_finer['error']) { $one_area_cons = "({$one_area_cons} AND " . $area_cons_res_finer['cons'] . ')'; } $mc_areas_list[] = $one_area_cons; $article_mcons = true; } } } if (0 < count($mc_areas_list)) { $query_mcons .= '(' . implode(" {$mc_areas_conn} ", $mc_areas_list) . ') AND '; $article_mcons = true; } $mmu_test_join = '%%mmu_test_join%%'; $mmu_test_spec = '%%mmu_test_spec%%'; $multimedia_test_common = "EXISTS (SELECT mlmu.id FROM MapLocationMultimedia AS mlmu {$mmu_test_join} WHERE mlmu.fk_maplocation_id = ml.id {$mmu_test_spec}) AND "; $multimedia_test_basic = $multimedia_test_common; $multimedia_test_basic = str_replace($mmu_test_join, '', $multimedia_test_basic); $multimedia_test_basic = str_replace($mmu_test_spec, '', $multimedia_test_basic); $multimedia_test_spec = $multimedia_test_common; $multimedia_test_spec = str_replace($mmu_test_join, 'INNER JOIN Multimedia AS mu ON mlmu.fk_multimedia_id = mu.id ', $multimedia_test_spec); $multimedia_test_image = $multimedia_test_spec; $multimedia_test_image = str_replace($mmu_test_spec, "AND mu.media_type = 'image'", $multimedia_test_image); $multimedia_test_video = $multimedia_test_spec; $multimedia_test_video = str_replace($mmu_test_spec, "AND mu.media_type = 'video'", $multimedia_test_video); if ($mc_filter_image) { $query_mcons .= $multimedia_test_image; $article_mcons = true; } if ($mc_filter_video) { $query_mcons .= $multimedia_test_video; $article_mcons = true; } if ($mc_filter_mm) { $query_mcons .= $multimedia_test_basic; $article_mcons = true; } $queryStr .= 'WHERE '; if ($article_mcons) { $queryStr .= $query_mcons; } $queryStr .= "a.Published = 'Y' AND a.IdLanguage = {$ps_languageId} "; } else { $queryStr .= "WHERE ml.fk_map_id = {$ps_mapId} "; } $queryStr_mid = ""; $queryStr_mid .= "AND mll.fk_language_id = {$ps_languageId} "; if ($ps_preview) { $queryStr_mid .= "AND mll.poi_display = 1 "; } if ($mc_mapCons) { $queryStr_mid .= 'GROUP BY ml.fk_location_id, mll.fk_content_id, ml.poi_style, mll.poi_display, image_mm, video_mm '; } $queryStr .= $queryStr_mid; $queryStr = $queryStr_start . $queryStr; $queryStr .= 'ORDER BY '; foreach ($ps_orders as $one_order) { foreach ($one_order as $cur_order_col => $cur_order_dir) { $queryStr .= "{$cur_order_col} {$cur_order_dir}, "; } } $queryStr .= 'ml.rank, ml.id, mll.id'; $rows = $g_ado_db->GetAll($queryStr); if (is_array($rows)) { $p_count = count($rows); if ($mc_limit) { $rows = array_slice($rows, $mc_start, $mc_limit); } if ($mc_start && !$mc_limit) { $rows = array_slice($rows, $mc_start); } } $mm_objs = array(); if (is_array($rows)) { foreach ($rows as $row) { $tmp_loc = trim(strtolower($row['loc'])); $loc_matches = array(); if (!preg_match('/^point\\((?P<latitude>[\\d.-]+)\\s(?P<longitude>[\\d.-]+)\\)$/', $tmp_loc, $loc_matches)) { continue; } $tmp_latitude = $loc_matches['latitude']; $tmp_longitude = $loc_matches['longitude']; $tmpPoint = array(); $tmpPoint['latitude'] = $tmp_latitude; $tmpPoint['longitude'] = $tmp_longitude; $tmpPoint['loc_id'] = $row['ml_id']; $tmpPoint['con_id'] = $row['mll_id']; $tmpPoint['style'] = $row['poi_style']; $tmpPoint['rank'] = $row['rank']; $tmpPoint['display'] = $row['poi_display']; $tmpPoint['title'] = $row['poi_name']; $tmpPoint['link'] = $row['poi_link']; $tmpPoint['perex'] = $row['poi_perex']; $tmpPoint['content_type'] = $row['poi_content_type']; $tmpPoint['content'] = $row['poi_content']; $tmpPoint['text'] = $row['poi_text']; $tmpPoint['image_mm'] = 0; $tmpPoint['image_src'] = ''; $tmpPoint['image_width'] = ''; $tmpPoint['image_height'] = ''; $tmp_image = null; $tmp_video = null; if ($row['image_mm']) { $multimedia_spec = $row['image_mm']; $multimedia_link = $multimedia_spec; // the dynamic maps (i.e. with mc_mapCons) have grouping by multimedia, // while article maps have all multimedia separated (and read with concat) if (!$mc_mapCons) { $multimedia_spec_arr = explode('-', $multimedia_spec); if (2 == count($multimedia_spec_arr)) { $multimedia_spec = 0 + $multimedia_spec_arr[0]; $multimedia_link = 0 + $multimedia_spec_arr[1]; } } $tmpPoint['image_mm'] = $multimedia_link; $tmp_image = new Geo_Multimedia($multimedia_spec); if ($tmp_image) { $tmpPoint['image_src'] = $tmp_image->getSrc(); $tmpPoint['image_width'] = $tmp_image->getWidth(); $tmpPoint['image_height'] = $tmp_image->getHeight(); } } $tmpPoint['video_mm'] = 0; $tmpPoint['video_id'] = ''; $tmpPoint['video_type'] = ''; $tmpPoint['video_width'] = ''; $tmpPoint['video_height'] = ''; if ($row['video_mm']) { $multimedia_spec = $row['video_mm']; $multimedia_link = $multimedia_spec; // the dynamic maps (i.e. with mc_mapCons) have grouping by multimedia, // while article maps have all multimedia separated (and read with concat) if (!$mc_mapCons) { $multimedia_spec_arr = explode('-', $multimedia_spec); if (2 == count($multimedia_spec_arr)) { $multimedia_spec = 0 + $multimedia_spec_arr[0]; $multimedia_link = 0 + $multimedia_spec_arr[1]; } } $tmpPoint['video_mm'] = $multimedia_link; $tmp_video = new Geo_Multimedia($multimedia_spec); if ($tmp_video) { $tmpPoint['video_id'] = $tmp_video->getSrc(); $tmpPoint['video_type'] = $tmp_video->getSpec(); $tmpPoint['video_width'] = $tmp_video->getWidth(); $tmpPoint['video_height'] = $tmp_video->getHeight(); } } if ($tmp_image || $tmp_video) { $mm_objs[$row['ml_id']] = array('image' => $tmp_image, 'video' => $tmp_video); } // for the list-of-objects array $tmpPoint['map_id'] = $ps_mapId; $tmpPoint['art_number'] = 0; $tmpPoint['art_numbers'] = ''; if ($mc_mapCons) { $tmpPoint['map_id'] = $row['m_id']; $tmpPoint['art_number'] = $row['art_number']; $tmpPoint['art_numbers'] = $row['art_numbers']; } $tmpPoint['geo_id'] = $row['loc_id']; $tmpPoint['geo_type'] = $row['poi_type']; $tmpPoint['geo_style'] = $row['poi_type_style']; $tmpPoint['geo_radius'] = $row['l_radius']; $tmpPoint['geo_user'] = $row['l_user']; $tmpPoint['geo_updated'] = $row['l_updated']; $tmpPoint['txt_id'] = $row['con_id']; $tmpPoint['txt_user'] = $row['c_user']; $tmpPoint['txt_updated'] = $row['c_updated']; $dataArray[] = $tmpPoint; } } if (0 == count($dataArray)) { return array(); } $dataArray_tmp = $dataArray; $objsArray = array(); $dataArray = array(); foreach ($dataArray_tmp as $one_poi) { $one_poi_source = array('id' => $one_poi['loc_id'], 'fk_map_id' => $one_poi['map_id'], 'fk_location_id' => $one_poi['geo_id'], 'poi_style' => $one_poi['style'], 'rank' => $one_poi['rank']); $one_poi_obj = new self($one_poi_source, true); $one_geo_source = array('poi_location' => null, 'poi_type' => $one_poi['geo_type'], 'poi_type_style' => $one_poi['geo_style'], 'poi_center' => null, 'poi_radius' => $one_poi['geo_radius'], 'IdUser' => $one_poi['geo_user'], 'time_updated' => $one_poi['geo_updated'], 'latitude' => $one_poi['latitude'], 'longitude' => $one_poi['longitude']); $one_poi_obj->location = new Geo_Location($one_geo_source, true); $one_lan_source = array('id' => $one_poi['con_id'], 'fk_maplocation_id' => $one_poi['loc_id'], 'fk_language_id' => $ps_languageId, 'fk_content_id' => $one_poi['txt_id'], 'poi_display' => $one_poi['display']); $one_poi_obj->setLanguage($ps_languageId, new Geo_MapLocationLanguage(NULL, 0, $one_lan_source, true)); $one_txt_source = array('id' => $one_poi['txt_id'], 'poi_name' => $one_poi['title'], 'poi_link' => $one_poi['link'], 'poi_perex' => $one_poi['perex'], 'poi_content_type' => $one_poi['content_type'], 'poi_content' => $one_poi['content'], 'poi_text' => $one_poi['text'], 'IdUser' => $one_poi['txt_user'], 'time_updated' => $one_poi['txt_updated']); $one_poi_obj->setContent($ps_languageId, new Geo_MapLocationContent(NULL, NULL, $one_txt_source, true)); if (array_key_exists($one_poi['loc_id'], $mm_objs)) { $poi_mm = $mm_objs[$one_poi['loc_id']]; $one_poi_obj->multimedia = array(); foreach ($poi_mm as $one_mm) { if ($one_mm) { $one_poi_obj->multimedia[] = $one_mm; } } } $objsArray[] = $one_poi_obj; if (!$p_skipCache || $ps_saveArray) { $dataArray[] = $one_poi; } } if (!$p_skipCache && CampCache::IsEnabled()) { $cacheList_arr->storeInCache(array('count' => $p_count, 'data' => $dataArray)); $cacheList_obj->storeInCache(array('count' => $p_count, 'data' => $objsArray)); } if (empty(self::$s_found_maplocations_list_ext)) { self::$s_found_maplocations_list_ext = array(); } self::$s_found_maplocations_list_ext[$list_spec_str] = array('count' => $p_count, 'list_raw' => $dataArray, 'list_obj' => $objsArray); if ($ps_saveArray) { $p_rawData = $dataArray; } return $objsArray; }