| author | ymh <ymh.work@gmail.com> |
| Mon, 26 Dec 2011 22:53:50 +0100 | |
| changeset 67 | 989d9e117586 |
| parent 65 | ba6b8e38d90e |
| child 68 | e7384fb35f7a |
| permissions | -rwxr-xr-x |
| 2 | 1 |
<?php |
2 |
||
3 |
namespace IRI\Bundle\WikiTagBundle\Entity; |
|
4 |
||
5 |
use Doctrine\ORM\EntityRepository; |
|
|
42
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
6 |
use IRI\Bundle\WikiTagBundle\Utils\WikiTagUtils; |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
7 |
use IRI\Bundle\WikiTagBundle\Entity\Tag; |
| 2 | 8 |
|
9 |
/** |
|
10 |
* TagRepository |
|
11 |
* |
|
12 |
* This class was generated by the Doctrine ORM. Add your own custom |
|
13 |
* repository methods below. |
|
14 |
*/ |
|
15 |
class TagRepository extends EntityRepository |
|
16 |
{ |
|
| 34 | 17 |
public function getTagCloud($max_tags) |
18 |
{ |
|
19 |
$qb = $this->getEntityManager()->createQueryBuilder(); |
|
20 |
$qb->select('t.id', 't.label', 'COUNT( dt.id ) AS nb_docs'); |
|
21 |
$qb->from('WikiTagBundle:Tag','t'); |
|
22 |
$qb->leftJoin('t.documents', 'dt', 'WITH', 't = dt.tag'); |
|
23 |
$qb->addGroupBy('t.id'); |
|
24 |
$qb->addOrderBy('nb_docs','DESC'); |
|
25 |
$qb->setMaxResults($max_tags); |
|
26 |
||
27 |
$query = $qb->getQuery(); |
|
28 |
return $query->getResult(); |
|
29 |
} |
|
30 |
||
31 |
public function getCompletion($seed) |
|
32 |
{ |
|
33 |
$qb = $this->getEntityManager()->createQueryBuilder(); |
|
|
65
ba6b8e38d90e
Correct event mamangement in hdabo_sf
ymh <ymh.work@gmail.com>
parents:
63
diff
changeset
|
34 |
$qb->select('DISTINCT t.label'); |
| 34 | 35 |
$qb->from('WikiTagBundle:Tag','t'); |
36 |
$qb->where($qb->expr()->orx( |
|
| 63 | 37 |
$qb->expr()->like('t.label',$qb->expr()->literal(addcslashes(mysql_real_escape_string($seed),"%_")."%")), |
| 34 | 38 |
$qb->expr()->like('t.label',$qb->expr()->literal("%".addcslashes(mysql_real_escape_string($seed),"%_"))), |
39 |
$qb->expr()->like('t.label',$qb->expr()->literal("% ".addcslashes(mysql_real_escape_string($seed),"%_")."%")) |
|
40 |
)); |
|
41 |
||
42 |
$query = $qb->getQuery(); |
|
43 |
||
44 |
return $query->getResult(); |
|
45 |
||
46 |
} |
|
|
42
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
47 |
|
| 67 | 48 |
private function findSemantizedTag($entityList, $normalized_label) |
|
42
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
49 |
{ |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
50 |
$tag = null; |
| 67 | 51 |
foreach ($entityList as $entity) { |
52 |
if(!is_null($normalized_label) && (!is_a($entity, "\IRI\Bundle\WikiTagBundle\Model\TagInterface") || $normalized_label !== $entity->getNormalizedLabel())) { |
|
53 |
continue; |
|
54 |
} |
|
55 |
$t = $entity; |
|
| 58 | 56 |
if($tag==null |
57 |
|| $tag->getUrlStatus() === Tag::$TAG_URL_STATUS_DICT['unsemantized'] |
|
58 |
|| ($tag->getUrlStatus() === Tag::$TAG_URL_STATUS_DICT['null_result'] && $t->getUrlStatus() !== Tag::$TAG_URL_STATUS_DICT['unsemantized'])) { |
|
|
42
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
59 |
$tag = $t; |
| 58 | 60 |
if($tag->getUrlStatus()!=Tag::$TAG_URL_STATUS_DICT['unsemantized'] && $tag->getUrlStatus()!=Tag::$TAG_URL_STATUS_DICT['null_result']) { |
|
42
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
61 |
break; |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
62 |
} |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
63 |
} |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
64 |
} |
| 67 | 65 |
|
66 |
return $tag; |
|
67 |
||
68 |
} |
|
69 |
||
70 |
/** |
|
71 |
* Get or create tag. Returns an array(tag:WikiTagTag, revision_id=int, created:Boolean) |
|
72 |
* @param $tag_label |
|
73 |
* @param $doctrine |
|
74 |
* @return multitype:boolean Ambigous <NULL, \IRI\Bundle\WikiTagBundle\Entity\Tag> Ambigous <NULL, unknown, mixed, string> (array(\IRI\Bundle\WikiTagBundle\Model\TagInterface, revision_id=int, created:Boolean)) |
|
75 |
*/ |
|
76 |
public function getOrCreateTag($tag_label, $ignore_wikipedia_info=false) |
|
77 |
{ |
|
78 |
$tag_label_normalized = WikiTagUtils::normalizeTag($tag_label); |
|
79 |
// We get the wikipedia references for the tag_label |
|
80 |
// We get or create the tag object |
|
81 |
$tags = $this->findBy(array('normalizedLabel' => $tag_label_normalized)); |
|
82 |
$tag = $this->findSemantizedTag($tags, null); |
|
83 |
$uow = $this->getEntityManager()->getUnitOfWork(); |
|
84 |
if(is_null($tag)) { |
|
85 |
$tag = $this->findSemantizedTag($uow->getScheduledEntityInsertions(), $tag_label_normalized); |
|
86 |
} |
|
87 |
if(is_null($tag)) { |
|
88 |
$tag = $this->findSemantizedTag($uow->getScheduledEntityUpdates(), $tag_label_normalized); |
|
89 |
} |
|
|
42
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
90 |
$wp_request_done = false; |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
91 |
if($tag==null) { |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
92 |
$tag = new Tag(); |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
93 |
$tag->setLabel($tag_label_normalized); |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
94 |
$tag->setOriginalLabel($tag_label); |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
95 |
$tag->setNormalizedLabel($tag_label_normalized); |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
96 |
$created = true; |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
97 |
} |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
98 |
else { |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
99 |
$created = false; |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
100 |
} |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
101 |
|
| 58 | 102 |
// We request Wikipedia if the tag is created or if this is a null result |
103 |
if($created==true || $tag->getUrlStatus()===Tag::$TAG_URL_STATUS_DICT['null_result']) { |
|
|
42
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
104 |
|
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
105 |
if($wp_request_done==false) { |
| 67 | 106 |
$wp_response = WikiTagUtils::getWikipediaInfo($tag_label_normalized, null, $ignore_wikipedia_info); |
|
42
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
107 |
} |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
108 |
|
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
109 |
$tag->setWikipediaInfo($wp_response); |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
110 |
|
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
111 |
// Save datas. |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
112 |
$em = $this->getEntityManager(); |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
113 |
$em->persist($tag); |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
114 |
|
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
115 |
$wikipedia_revision_id = $wp_response['revision_id']; |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
116 |
|
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
117 |
} |
| 60 | 118 |
elseif($tag!=null && $tag->getWikipediaPageId()!=null) { |
| 67 | 119 |
$wp_response = WikiTagUtils::getWikipediaInfo(null, $tag->getWikipediaPageId(), $ignore_wikipedia_info); |
|
42
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
120 |
$wikipedia_revision_id = $wp_response['revision_id']; |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
121 |
} |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
122 |
else { |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
123 |
$wikipedia_revision_id = null; |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
124 |
} |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
125 |
|
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
126 |
return array($tag, $wikipedia_revision_id, $created);//, $wpReponse); |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
127 |
} |
|
0e57c730bb18
Documentation and add alternative wp url and label + migrations
ymh <ymh.work@gmail.com>
parents:
34
diff
changeset
|
128 |
|
| 59 | 129 |
} |