弱小PHPerの憂鬱

<VirtualHost *:80>
    ServerName eccube.localhost
    DocumentRoot "C:\hoge\fuga\eccube\html"
    <Directory "C:\hoge\fuga\eccube\html">
      AllowOverride All
    </Directory>
</VirtualHost>

class JobeetTestFunctional extends sfTestFunctional{
  public function loadData(){
    Doctrine::loadData(sfConfig::get('sf_test_dir').'/fixtures');
    return $this;
  }
 
  public function getMostRecentProgrammingJob(){
    $q = Doctrine_Query::create()
      ->select('j.*')
      ->from('JobeetJob j')
      ->leftJoin('j.JobeetCategory c')
      ->where('c.slug = ?', 'programming');
    $q = Doctrine::getTable('JobeetJob')->addActiveJobsQuery($q);
    return $q->fetchOne();
  }
 
  public function getExpiredJob(){
    $q = Doctrine_Query::create()
      ->from('JobeetJob j')
      ->where('j.expires_at < ?', date('Y-m-d', time()));
    return $q->fetchOne();
  }}

include(dirname(__FILE__).'/../../bootstrap/functional.php');
 
$browser = new JobeetTestFunctional(new sfBrowser());
$browser->loadData();
 
$browser->info('1 - The homepage')->
  get('/')->
  with('request')->begin()->
    isParameter('module', 'job')->
    isParameter('action', 'index')->
  end()->
  with('response')->begin()->
    info('  1.1 - Expired jobs are not listed')->
    checkElement('.jobs td.position:contains("expired")', false)->
  end()
;
 
$max = sfConfig::get('app_max_jobs_on_homepage');
 
$browser->info('1 - The homepage')->
  info(sprintf('  1.2 - Only %s jobs are listed for a category', $max))->
  with('response')->
    checkElement('.category_programming tr', $max)
;
 
$browser->info('1 - The homepage')->
  get('/')->
  info('  1.3 - A category has a link to 
     the category page only if too many jobs')->
  with('response')->begin()->
    checkElement('.category_design .more_jobs', false)->
    checkElement('.category_programming .more_jobs')->
  end()
;
 
$browser->info('1 - The homepage')->
  info('  1.4 - Jobs are sorted by date')->
  with('response')->begin()->
    checkElement(sprintf('.category_programming tr:first a[href*="/%d/"]',
      $browser->getMostRecentProgrammingJob()->getId()))->
  end()
;
 
$browser->info('2 - The job page')->
  info('  2.1 - Each job on the homepage is clickable 
      and give detailed information')->
  click('Web Developer', array(), array('position' => 1))->
  with('request')->begin()->
    isParameter('module', 'job')->
    isParameter('action', 'show')->
    isParameter('company_slug', 'sensio-labs')->
    isParameter('location_slug', 'paris-france')->
    isParameter('position_slug', 'web-developer')->
    isParameter('id', $browser->getMostRecentProgrammingJob()->getId())->
  end()->
 
  info('  2.2 - A non-existent job forwards the user to a 404')->
  get('/job/foo-inc/milano-italy/0/painter')->
  with('response')->isStatusCode(404)->
 
  info('  2.3 - An expired job page forwards the user to a 404')->
  get(sprintf('/job/sensio-labs/paris-france/%d/web-developer',
    $browser->getExpiredJob()->getId()))->
  with('response')->isStatusCode(404)
;

include(dirname(__FILE__).'/../../bootstrap/functional.php');
 
$browser = new JobeetTestFunctional(new sfBrowser());
$browser->loadData();
 
$browser->info('1 - The category page')->
  info('  1.1 - Categories on homepage are clickable')->
  get('/')->
  click('Programming')->
  with('request')->begin()->
    isParameter('module', 'category')->
    isParameter('action', 'show')->
    isParameter('slug', 'programming')->
  end()->
 
  info(sprintf('  1.2 - Categories with 
      more than %s jobs also have a "more" link',
   sfConfig::get('app_max_jobs_on_homepage')))->
  get('/')->
  click('22')->
  with('request')->begin()->
    isParameter('module', 'category')->
    isParameter('action', 'show')->
    isParameter('slug', 'programming')->
  end()->
 
  info(sprintf('  1.3 - Only %s jobs are listed'
      , sfConfig::get('app_max_jobs_on_category')))->
  with('response')->checkElement('.jobs tr'
      , sfConfig::get('app_max_jobs_on_category'))->
 
  info('  1.4 - The job listed is paginated')->
  with('response')->begin()->
    checkElement('.pagination_desc', '/32 jobs/')->
    checkElement('.pagination_desc', '#page 1/2#')->
  end()->
 
  click('2')->
  with('request')->begin()->
    isParameter('page', 2)->
  end()->
  with('response')->checkElement('.pagination_desc', '#page 2/2#')
;

get('/category/programming')->
with('request')->begin()->
  isParameter('module', 'category')->
  isParameter('action', 'show')->
end()

class JobeetTestFunctional extends sfTestFunctional{
  public function loadData(){
    Doctrine::loadData(sfConfig::get('sf_test_dir').'/fixtures');
    return $this;
  }
}

include(dirname(__FILE__).'/../../bootstrap/functional.php');
$browser = new JobeetTestFunctional(new sfBrowser());
$browser->loadData();
 
$browser->info('1 - The homepage')->
  get('/')->
  with('request')->begin()->
    isParameter('module', 'job')->
    isParameter('action', 'index')->
  end()->
  with('response')->begin()->
    info('  1.1 - Expired jobs are not listed')->
    checkElement('.jobs td.position:contains("expired")', false)->
  end()
;

include(dirname(__FILE__).'/unit.php');
$configuration = ProjectConfiguration::getApplicationConfiguration(
    'frontend', 'test', true);
new sfDatabaseManager($configuration);
Doctrine::loadData(sfConfig::get('sf_test_dir').'/fixtures');

include(dirname(__FILE__).'/../../bootstrap/Doctrine.php');
$t = new lime_test(3, new lime_output_color());
 
$t->comment('->getCompanySlug()');
$job = Doctrine::getTable('JobeetJob')->createQuery()->fetchOne();
$t->is($job->getCompanySlug(), Jobeet::slugify($job->getCompany()),
 '->getCompanySlug() return the slufor the company');
 
$t->comment('->save()');
 
$job = create_job();
$job->save();
$expiresAt = date('Y-m-d', time() + 86400 * sfConfig::get('app_active_days'));
$t->is(date('Y-m-d', strtotime($job->getExpiresAt())), $expiresAt,
 '->save() updates expires_at if not set');
 
$job = create_job(array('expires_at' => '2008-08-08'));
$job->save();
$t->is(date('Y-m-d', strtotime($job->getExpiresAt())), '2008-08-08',
 '->save() does not update expires_at if set');
 
function create_job($defaults = array()){
  static $category = null;
 
  if (is_null($category)){
    $category = Doctrine::getTable('JobeetCategory')
      ->createQuery()
      ->limit(1)
      ->fetchOne();
  }
 
  $job = new JobeetJob();
  $job->fromArray(array_merge(array(
    'category_id'  => $category->getId(),
    'company'      => 'Sensio Labs',
    'position'     => 'Senior Tester',
    'location'     => 'Paris, France',
    'description'  => 'Testing is fun',
    'how_to_apply' => 'Send e-Mail',
    'email'        => 'job@example.com',
    'token'        => rand(1111, 9999),
    'is_activated' => true,
  ), $defaults));
 
  return $job;
}

require_once dirname(__FILE__).'/../bootstrap/unit.php';
$t = new lime_test(1, new lime_output_color());
 
$t->pass('This test always passes.');

$t->is(Jobeet::slugify('Sensio'), 'sensio');
$t->is(Jobeet::slugify('sensio labs'), 'sensio-labs');
$t->is(Jobeet::slugify('sensio   labs'), 'sensio-labs');
$t->is(Jobeet::slugify('paris,france'), 'paris-france');
$t->is(Jobeet::slugify('  sensio'), 'sensio');
$t->is(Jobeet::slugify('sensio  '), 'sensio');

$t->is(1,'1');
$t->is(1,true);

$t->comment('::slugify()');
$t->is(Jobeet::slugify('Sensio'), 'sensio'
  , '::slugify() converts all characters to lower case');

$t->is(Jobeet::slugify(''), 'n-a'
  , '::slugify() converts the empty string to n-a');

static public function slugify($text){
  //テキストが空であれば'n-a'を返す
  if (empty($text)){ return 'n-a'; }
  // 文字ではないもしくは数値ではないものすべてを-に置き換える
  $text = preg_replace('/\W+/', '-', $text);
  // トリムして小文字に変換する
  $text = strtolower(trim($text, '-'));
  return $text;
}

$t->is(Jobeet::slugify(' - '), 'n-a', 
  '::slugify() converts a string that only contains non-ASCII characters to n-a');

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();
}