Development

Changeset 7040

You must first sign up to be able to contribute.

Changeset 7040

Show
Ignore:
Timestamp:
01/14/08 07:18:18 (8 months ago)
Author:
kupokomapa
Message:

[nahoWikiPlugin] Some optimizations with the Propel I18n queries.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • plugins/nahoWikiPlugin/branches/kupokomapa/lib/model/plugin/PluginnahoWikiPage.php

    r7037 r7040  
    77class PluginnahoWikiPage extends BasenahoWikiPage 
    88{ 
    9   public function getRevision($revision = null, $culture = 'en'
     9  public function getRevision($revision = null, $culture = null
    1010  { 
     11    if (is_null($culture))  
     12    { 
     13      $culture = sfContext::getInstance()->getUser()->getCulture(); 
     14      if (!$culture) { 
     15        $culture = 'en'; 
     16      } 
     17    } 
     18     
    1119    $revisions = $this->getRevisions($culture); 
    1220     
     
    1927      if ($rev->getRevision() == $revision)  
    2028      { 
    21         $rev->setCulture($culture); 
    2229        return $rev; 
    2330      } 
    24     } 
    25      
    26     if ($latest_revision) { 
    27       $latest_revision->setCulture($culture); 
    2831    } 
    2932     
     
    3134  } 
    3235   
    33   public function getRevisions($culture = 'en') 
    34   { 
     36  public function getRevisions($culture = null) 
     37  {  
     38    if (is_null($culture))  
     39    { 
     40      $culture = sfContext::getInstance()->getUser()->getCulture(); 
     41      if (!$culture) { 
     42        $culture = 'en'; 
     43      } 
     44    } 
     45     
    3546    $c = new Criteria(); 
    36     $c->addJoin(nahoWikiRevisionPeer::ID, nahoWikiRevisionI18nPeer::ID, Criteria::RIGHT_JOIN); 
    37     $c->add(nahoWikiRevisionI18nPeer::CULTURE, $culture); 
     47    $c->add(nahoWikiRevisionPeer::PAGE_ID, $this->getId()); 
    3848    $c->addDescendingOrderByColumn(nahoWikiRevisionPeer::ID); 
    3949     
    40     return $this->getnahoWikiRevisions($c); 
     50    return nahoWikiRevisionPeer::doSelectWithI18n($c, $culture); 
    4151  } 
    4252 
    43   public function getLatestRevision($culture = 'en'
     53  public function getLatestRevision($culture = null
    4454  { 
     55    if (is_null($culture))  
     56    { 
     57      $culture = sfContext::getInstance()->getUser()->getCulture(); 
     58      if (!$culture) { 
     59        $culture = 'en'; 
     60      } 
     61    } 
     62     
    4563    $c = new Criteria(); 
    4664    $c->add(nahoWikiRevisionPeer::PAGE_ID, $this->getId()); 
    47     $c->addJoin(nahoWikiRevisionPeer::ID, nahoWikiRevisionI18nPeer::ID, Criteria::RIGHT_JOIN); 
    48     $c->add(nahoWikiRevisionI18nPeer::CULTURE, $culture); 
    4965    $c->addDescendingOrderByColumn(nahoWikiRevisionPeer::ID); 
     66    $c->setLimit(1); 
    5067     
    51     $revision = nahoWikiRevisionPeer::doSelectOne($c); 
     68    $revision = nahoWikiRevisionPeer::doSelectWithI18n($c, $culture); 
     69    if (is_array($revision)) { 
     70      $revision = array_shift($revision); 
     71    } 
    5272     
    5373    return ($revision)?$revision->getRevision():0; 
  • plugins/nahoWikiPlugin/branches/kupokomapa/modules/nahoWiki/lib/BasenahoWikiComponents.class.php

    r6324 r7040  
    1010class BasenahoWikiComponents extends sfComponents 
    1111{ 
    12   public function executePage() 
    13   { 
    14   } 
    1512}