弱小PHPerの憂鬱

all:
  max_jobs_on_category: 20

public function executeShow(sfWebRequest $request){
  $this->category = $this->getRoute()->getObject();
 
  $this->pager = new sfDoctrinePager(
    'JobeetJob',
    sfConfig::get('app_max_jobs_on_category')
  );
  $this->pager->setQuery($this->category->getActiveJobsQuery());
  $this->pager->setPage($request->getParameter('page', 1));
  $this->pager->init();
}

public function getActiveJobsQuery(){
  $q = Doctrine_Query::create()
    ->from('JobeetJob j')
    ->where('j.category_id = ?', $this->getId());
  return Doctrine::getTable('JobeetJob')->addActiveJobsQuery($q);
}

public function getActiveJobs($max = 10){
  $q = $this->getActiveJobsQuery()->limit($max);
  return $q->execute();
}
public function countActiveJobs(){
  return $this->getActiveJobsQuery()->count();
}

<?php use_stylesheet('jobs.css') ?>
 
<?php slot('title', sprintf('Jobs in the %s category', $category->getName())) ?>
 
<div class="category">
  <div class="feed">
    <a href="">Feed</a>
  </div>
  <h1><?php echo $category ?></h1>
</div>
 
<?php include_partial('job/list', array('jobs' => $pager->getResults())) ?>
 
<?php if ($pager->haveToPaginate()): ?>
  <div class="pagination">
    <a href="<?php echo url_for('category', $category) ?>?page=1">
      <img src="/images/first.png" alt="First page" title="First page" />
    </a>
 
    <a href="<?php echo url_for('category', $category) ?>
      ?page=<?php echo $pager->getPreviousPage() ?>">
      <img src="/images/previous.png" alt="Previous page" title="Previous page" />
    </a>
 
    <?php foreach ($pager->getLinks() as $page): ?>
      <?php if ($page == $pager->getPage()): ?>
        <?php echo $page ?>
      <?php else: ?>
        <a href="<?php echo url_for('category', $category) ?>
          ?page=<?php echo $page ?>"><?php echo $page ?></a>
      <?php endif; ?>
    <?php endforeach; ?>
 
    <a href="<?php echo url_for('category', $category) ?>
      ?page=<?php echo $pager->getNextPage() ?>">
      <img src="/images/next.png" alt="Next page" title="Next page" />
    </a>
 
    <a href="<?php echo url_for('category', $category) ?>
      ?page=<?php echo $pager->getLastPage() ?>">
      <img src="/images/last.png" alt="Last page" title="Last page" />
    </a>
  </div>
<?php endif; ?>
 
<div class="pagination_desc">
  <strong><?php echo $pager->getNbResults() ?></strong>
     jobs in this category
  <?php if ($pager->haveToPaginate()): ?>
    - page <strong><?php echo $pager->getPage() ?>
                  /<?php echo $pager->getLastPage() ?></strong>
  <?php endif; ?>
</div>

JobeetCategory:
  actAs:
    Sluggable:
      fields: [name]

CREATE TABLE IF NOT EXISTS `jobeet_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `sluggable_idx` (`slug`)) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

public function executeShow(sfWebRequest $request){
  $this->category = $this->getRoute()->getObject();
}

<?php use_stylesheet('jobs.css') ?>
<?php slot('title', sprintf('Jobs in the %s category', $category->getName())) ?>
<div class="category">
  <div class="feed">
    <a href="">Feed</a>
  </div>
  <h1><?php echo $category ?></h1>
</div>
<table class="jobs">
  <?php foreach ($category->getActiveJobs() as $i => $job): ?>
    <tr class="<?php echo fmod($i, 2) ? 'even' : 'odd' ?>">
      <td class="location">
        <?php echo $job->getLocation() ?>
      </td>
      <td class="position">
        <?php echo link_to($job->getPosition(), 'job_show_user', $job) ?>
      </td>
      <td class="company">
        <?php echo $job->getCompany() ?>
      </td>
    </tr>
  <?php endforeach; ?>
</table>

<table class="jobs">
  <?php foreach ($jobs as $i => $job): ?>
    <tr class="<?php echo fmod($i, 2) ? 'even' : 'odd' ?>">
      <td class="location">
        <?php echo $job->getLocation() ?>
      </td>
      <td class="position">
        <?php echo link_to($job->getPosition(), 'job_show_user', $job) ?>
      </td>
      <td class="company">
        <?php echo $job->getCompany() ?>
      </td>
    </tr>
  <?php endforeach; ?>
</table>

<?php include_partial('job/list', array('jobs' => $category->getActiveJobs())) ?>

<?php include_partial('job/list', 
  array('jobs' => $category->getActiveJobs(
   sfConfig::get('app_max_jobs_on_homepage'))))

category:
  url:      /category/:slug
  class:    sfDoctrineRoute
  param:    { module: category, action: show }
  options:  { model: JobeetCategory, type: object }

public function getSlug(){
  return Jobeet::slugify($this->getName());
}

<!-- some HTML code -->
 
        <h1>
          <?php echo link_to($category, 'category', $category) ?>
        </h1>
 
<!-- some HTML code -->
 
      </table>
      <?php if (($count = $category->countActiveJobs() - 
        sfConfig::get('app_max_jobs_on_homepage')) > 0):
       ?>
        <div class="more_jobs">
          and <?php echo link_to($count, 'category', $category) ?>
          more...
        </div>
      <?php endif; ?>
    </div>
  <?php endforeach; ?>
</div>

public function countActiveJobs(){
  return Doctrine_Query::create()
    ->from('JobeetJob j')
    ->addWhere('j.category_id = ?', $this->getId())
    ->addWhere('j.expires_at > NOW() ')
    ->count();
}

public function countActiveJobs(){
  $q= Doctrine_Query::create()
    ->from('JobeetJob j')
    ->addWhere('j.category_id = ?', $this->getId());
  return Doctrine::getTable('JobeetJob')->countActiveJobs($q);
}

public function countActiveJobs(Doctrine_Query $q = null){
    if (is_null($q)){
      $q = Doctrine_Query::create()
        ->from('JobeetJob j');
    }
  $q->addWhere('j.expires_at > NOW() ');
  return  $q->count();
}

class JobeetJobTable extends Doctrine_Table{
  /*
   *    現在有効なJobeetJobを一件だけ取得 
   */
  public function retrieveActiveJob(Doctrine_Query $q){
    return $this->addActiveJobsQuery($q)->fetchOne();
  }
 
  /*
   *     現在有効なJobeetJobを全件取得 
   */
  public function getActiveJobs(Doctrine_Query $q = null){
    return $this->addActiveJobsQuery($q)->execute();
  }
 
  /*
   *    現在有効なJobeetJobの件数を取得
   */
  public function countActiveJobs(Doctrine_Query $q = null){
    return $this->addActiveJobsQuery($q)->count();
  }
 
  /*
   *    DQLに現在有効なJobeetJobを追加
   */
  public function addActiveJobsQuery(Doctrine_Query $q = null){
    if (is_null($q)){
      $q = Doctrine_Query::create()->from('JobeetJob j');
    }
    $alias = $q->getRootAlias();
    $q->andWhere($alias . '.expires_at > NOW()')
      ->addOrderBy($alias . '.created_at DESC');
    return $q;
  }}

public function getActiveJobs($max = 10){
  $q = Doctrine_Query::create()
    ->from('JobeetJob j')
    ->where('j.category_id = ?', $this->getId())
    ->limit($max);
  return Doctrine::getTable('JobeetJob')->getActiveJobs($q);
}

  <?php foreach ($category->getActiveJobs(10) as $i => $job): ?>

all:
  active_days:          30
  max_jobs_on_homepage: 5

<?php foreach ($category->getActiveJobs(
   sfConfig::get('app_max_jobs_on_homepage')) as $i => $job):
?>

public function getActiveJobs($max = null){
  if(!$max){$max=sfConfig::get('app_max_jobs_on_homepage');}
  $q = Doctrine_Query::create()
    ->from('JobeetJob j')
    ->where('j.category_id = ?', $this->getId())
    ->limit($max);
  return Doctrine::getTable('JobeetJob')->getActiveJobs($q);
}

public function executeShow(sfWebRequest $request){
  $this->job = $this->getRoute()->getObject();
}

job_show_user:
  options: { model: JobeetJob, type: object, method_for_query:  retrieveActiveJob }

public function retrieveActiveJob(Doctrine_Query $q){
  $q->andWhere('a.expires_at > NOW()');
  return $q->fetchOne();
}