public static function fromBaseToken(BaseToken $token) { $extended = new self($token->getPrototype()); if ($token->isChanged()) { $extended->setContent('__CHANGE_HOLDER__' . $token->getContent()); $extended->setContent($token->getContent()); } return $extended; }
/** * return all replies on a specific ticket. * @param $ticket_id the id of the ticket of which we want the replies. * @param $view_as_admin if the browsing user is an admin/mod it should be 1, this will also show the hidden replies. * @return an array with ticket_reply objects (beware the author and content are objects on their own, not integers!) */ public static function getRepliesOfTicket($ticket_id, $view_as_admin) { $dbl = new DBLayer("lib"); $statement = $dbl->execute("SELECT * FROM ticket_reply INNER JOIN ticket_content INNER JOIN ticket_user ON ticket_reply.Content = ticket_content.TContentId and ticket_reply.Ticket=:id and ticket_user.TUserId = ticket_reply.Author ORDER BY ticket_reply.TReplyId ASC", array('id' => $ticket_id)); $row = $statement->fetchAll(); $result = array(); foreach ($row as $tReply) { //only add hidden replies if the user is a mod/admin if (!$tReply['Hidden'] || $view_as_admin) { //load author $instanceAuthor = Ticket_User::constr_TUserId($tReply['Author']); $instanceAuthor->setExternId($tReply['ExternId']); $instanceAuthor->setPermission($tReply['Permission']); //load content $instanceContent = new Ticket_Content(); $instanceContent->setTContentId($tReply['TContentId']); $instanceContent->setContent($tReply['Content']); //load reply and add the author and content object in it. $instanceReply = new self(); $instanceReply->setTReplyId($tReply['TReplyId']); $instanceReply->setTimestamp($tReply['Timestamp']); $instanceReply->setAuthor($instanceAuthor); $instanceReply->setTicket($ticket_id); $instanceReply->setContent($instanceContent); $instanceReply->setHidden($tReply['Hidden']); $result[] = $instanceReply; } } return $result; }
public static function create($data, $obj = null) { $obj = new self(); $options = json_decode($data['options'], true); $fblikeOptions = $options['fblikeOptions']; $obj->setFblikeOptions($fblikeOptions); $obj->setContent($data['fblike']); return parent::create($data, $obj); }
public static function createFromArray($input) { if (false == isset($input['filename']) || false == isset($input['content'])) { throw new \InvalidArgumentException('Not all required fields exists in array.'); } $dto = new self(); $dto->setFilename($input['filename']); $dto->setContent($input['content']); return $dto; }
/** * @param Title $title * @param PostRevision $post * @param User $user * @param string $content * @param string $format wikitext|html * @param string $changeType * @return PostSummary */ public static function create(Title $title, PostRevision $post, User $user, $content, $format, $changeType) { $obj = new self(); $obj->revId = UUID::create(); $obj->user = UserTuple::newFromUser($user); $obj->prevRevision = null; $obj->changeType = $changeType; $obj->summaryTargetId = $post->getPostId(); $obj->setContent($content, $format, $title); return $obj; }
/** * @param Workflow $workflow * @param User $user * @param string $content * @param string $format wikitext|html * @param string[optional] $changeType * @return Header */ public static function create(Workflow $workflow, User $user, $content, $format, $changeType = 'create-header') { $obj = new self(); $obj->revId = UUID::create(); $obj->workflowId = $workflow->getId(); $obj->user = UserTuple::newFromUser($user); $obj->prevRevision = null; // no prior revision $obj->setContent($content, $format, $workflow->getArticleTitle()); $obj->changeType = $changeType; return $obj; }
/** * @author WN * @param string|null $content * @param int|null $color * @param int|null $option * @param int|null $bgcolor * @return Char */ public static function make($content = null, $color = null, $option = null, $bgcolor = null, $default = null) { $obj = new self($content); if ($content !== null) { $obj->setContent($content); } if ($color !== null) { $obj->setColor($color); } if ($bgcolor !== null) { $obj->setBgcolor($bgcolor); } $obj->setDefault($default); return $obj; }
/** * {@inheritdoc} */ public function duplicate($name) { $clone = new self($name); $clone->setContent($this->content); $clone->setChecksum($this->checksum); $clone->setMetadata($this->metadata); $clone->setMimeType($this->mimetype); $clone->setSize($this->size); if (null !== $this->lastAccess) { $clone->setLastAccess($this->lastAccess); } if (null !== $this->lastModification) { $clone->setLastModification($this->lastModification); } return $clone; }
public static function byPath($_pathfile) { if (!file_exists($_pathfile)) { throw new Exception('Chemin jusqu\'au widget non trouvé : ' . $_pathfile); } $path_parts = pathinfo($_pathfile); $informations = explode('.', $path_parts['basename']); $widget = new self(); $widget->setType($informations[1]); $widget->setSubtype($informations[2]); $widget->setName($informations[3]); $folder = explode('/', $path_parts['dirname']); $widget->setVersion($folder[count($folder) - 1]); $widget->setContent(file_get_contents($_pathfile)); $widget->setPath($_pathfile); return $widget; }
/** * @param array $arr * @return RiakBlogPost|null */ public static function instanceFromAssocArray($arr) { if ($arr !== null) { $instance = new self(); $instance->identifier = $arr[static::$IDENTIFIER_NAME]; $instance->setAuthorIdentifier($arr[static::$AUTHOR_ID_NAME]); $instance->setAuthorDisplayName($arr[static::$AUTHOR_DISP_NAME]); $instance->postedDate = Carbon::createFromFormat(\DateTime::ISO8601, $arr[static::$POST_DATE_NAME]); $instance->lastModifiedDate = Carbon::createFromFormat(\DateTime::ISO8601, $arr[static::$MODIFIED_DATE_NAME]); $instance->setTitle(isset($arr[static::$TITLE_NAME]) ? $arr[static::$TITLE_NAME] : ""); $instance->setContent($arr[static::$CONTENT_NAME]); if ($arr[static::$PUBLISHED_NAME] == '1') { $instance->setIsPublished(true); } else { $instance->setIsPublished(false); } return $instance; } }
/** * {@inheritdoc} */ public static function fromArray(array $values) { $message = new self(); $values = array_merge(['name' => null, 'insertion_point' => null, 'content' => null], $values); $message->setName($values['name']); $message->setInsertionPoint($values['insertion_point']); $message->setContent($values['content']); return $message; }
/** * @param string $title * @param string $content * @return Post */ public static function create($title, $content) { $post = new self($postId = PostId::generate()); $post->setTitle($title); $post->setContent($content); $post->setPublishingDate($publishingDate = new \DateTime()); $post->recordThat(new PostWasPublished($postId, $title, $content, $publishingDate)); return $post; }
public static function create($data, $obj = null) { $obj = new self(); $obj->setContent($data['html']); return parent::create($data, $obj); }
/** * @param PostId $postId * @param string $author * @param string $content * @return Comment */ public static function create(PostId $postId, $author, $content) { $comment = new self($commentId = CommentId::generate()); $comment->setPostId($postId); $comment->setAuthor($author); $comment->setContent($content); $comment->setCreatingDate($creatingDate = new \DateTime()); $comment->recordThat(new CommentWasAdded($commentId, $postId, $author, $content, $creatingDate)); return $comment; }
/** * 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; }
/** * Construct the HttpResponse from a file, you can create the * dumps from actual traffic using "curl -i http://www.example.org > dump.txt" */ public static function fromFile($file) { $data = @file_get_contents($file); if (FALSE === $data) { throw new HttpResponseException("unable to read file"); } $response = new self(); // separate the headers from the content list($headerLines, $contentData) = explode("\r\n\r\n", $data); $headerLinesArray = explode("\r\n", $headerLines); // First header is HTTP response code, e.g.: HTTP/1.1 200 OK $responseCode = substr($headerLinesArray[0], 9, 3); $response->setStatusCode($responseCode); unset($headerLinesArray[0]); foreach ($headerLinesArray as $headerLine) { list($k, $v) = explode(":", $headerLine); $response->setHeader(trim($k), trim($v)); } $response->setContent($contentData); return $response; }
/** * @param Workflow $workflow * @param User $user * @param string $content * @param string $format wikitext|html * @param string[optional] $changeType * @return PostRevision */ public function reply(Workflow $workflow, User $user, $content, $format, $changeType = 'reply') { $reply = new self(); // UUIDs should not be reused for different entities/entity types in the future. // (It is also inconsistent with newFromId, which uses separate ones.) // This may be changed here in the future. $reply->revId = $reply->postId = UUID::create(); $reply->user = UserTuple::newFromUser($user); $reply->origUser = $reply->user; $reply->replyToId = $this->postId; $reply->setContent($content, $format, $workflow->getArticleTitle()); $reply->changeType = $changeType; $reply->setChildren(array()); $reply->setDepth($this->getDepth() + 1); $reply->rootPost = $this->rootPost; return $reply; }
public static function init(array $message) { $m = new self(); return $m->setContent($message['content'])->setMobiles($message['mobiles']); }
/** * fábrica de objetos * @param string $content * @return Content */ public static function factory($content = '') { $self = new self(); return $self->setContent($content); }
/** * Factory method for <i>HttpRequest</i> creation from server * * This method uses superglobal array <code>$_SERVER</code> to build single * Request-Line consisting of <i>METHOD</i>, <i>URI</i> and <i>PROTOCOL</i>. * Headers and content is created via functions <code>getallheaders()</code> * and <code>file_get_contents()</code>. * * @return HttpRequest request object */ public static function createFromServer() { $request = new self(); $request->setMethod($_SERVER['REQUEST_METHOD']); $request->setUri($_SERVER['REQUEST_URI']); $request->setVersion($_SERVER['SERVER_PROTOCOL']); $request->setHeaders(getallheaders()); $request->setContent(file_get_contents('php://input')); return $request; }