public function getForLuceneQuery($query)
{
$hits = Job::getLuceneIndex()->find($query);
$pks = array();
foreach ($hits as $hit) {
$pks[] = $hit->pk;
}
if (empty($pks)) {
return array();
}
$q = $this->createQueryBuilder('j')->where('j.id IN (:pks)')->setParameter('pks', $pks)->andWhere('j.is_activated = :active')->setParameter('active', 1)->setMaxResults(20)->getQuery();
return $q->getResult();
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$days = $input->getArgument('days');
$em = $this->getContainer()->get('doctrine')->getManager();
//clean up Lucene index
$index = Job::getLuceneIndex();
$q = $em->getRepository('IbwJobeetBundle:Job')->createQueryBuilder('j')->where('j.expires_at < :date')->setParameter('date', date('Y-m-d'))->getQuery();
$jobs = $q->getResult();
foreach ($jobs as $job) {
if ($hit = $index->find('pk:' . $job->getId())) {
$index->delete($hit->id);
}
}
$index->optimize();
$output->writeln('Cleaned up and optimized the job index');
//Remoce stale jobs
$nb = $em->getRepository('IbwJobeetBundle:Job')->cleanup($days);
$output->writeln(sprintf('Removed %d stale Job.', $nb));
}
public function load(ObjectManager $em)
{
$job_sensio_labs = new Job();
$job_sensio_labs->setCategory($em->merge($this->getReference('category-programming')));
$job_sensio_labs->setType('full-time');
$job_sensio_labs->setCompany('Sensio Labs');
$job_sensio_labs->setLogo('sensio-labs.gif');
$job_sensio_labs->setUrl('http://www.sensiolabs.com/');
$job_sensio_labs->setPosition('Web Developer');
$job_sensio_labs->setLocation('Paris, France');
$job_sensio_labs->setDescription('You\'ve already developed websites with symfony and you want to work with Open-Source technologies. You have a minimum of 3 years experience in web development with PHP or Java and you wish to participate to development of Web 2.0 sites using the best frameworks available.');
$job_sensio_labs->setHowToApply('Send your resume to fabien.potencier [at] sensio.com');
$job_sensio_labs->setIsPublic(true);
$job_sensio_labs->setIsActivated(true);
$job_sensio_labs->setToken('job_sensio_labs');
$job_sensio_labs->setEmail('*****@*****.**');
$job_sensio_labs->setExpiresAt(new \DateTime('+30 days'));
$job_extreme_sensio = new Job();
$job_extreme_sensio->setCategory($em->merge($this->getReference('category-design')));
$job_extreme_sensio->setType('part-time');
$job_extreme_sensio->setCompany('Extreme Sensio');
$job_extreme_sensio->setLogo('extreme-sensio.gif');
$job_extreme_sensio->setUrl('http://www.extreme-sensio.com/');
$job_extreme_sensio->setPosition('Web Designer');
$job_extreme_sensio->setLocation('Paris, France');
$job_extreme_sensio->setDescription('Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in.');
$job_extreme_sensio->setHowToApply('Send your resume to fabien.potencier [at] sensio.com');
$job_extreme_sensio->setIsPublic(true);
$job_extreme_sensio->setIsActivated(true);
$job_extreme_sensio->setToken('job_extreme_sensio');
$job_extreme_sensio->setEmail('*****@*****.**');
$job_extreme_sensio->setExpiresAt(new \DateTime('+30 days'));
$em->persist($job_sensio_labs);
$em->persist($job_extreme_sensio);
$em->flush();
}
/**
*
* @param FormBuilderInterface $builder
* @param array $options
*/
public function buildForm(FormBuilderInterface $builder, array $options)
{
$builder->add('category')->add('type', 'choice', array('choices' => Job::getTypes(), 'expanded' => true))->add('company')->add('file', 'file', array('label' => 'Company logo', 'required' => false))->add('url')->add('position')->add('location')->add('description')->add('how_to_apply', null, array('label' => 'How to apply?'))->add('is_public', null, array('label' => 'Public?'))->add('email');
}
public function testSetExpiresAtValue()
{
$job = new Job();
$job->setExpiresAtValue();
$this->assertEquals(time() + 86400 * 30, $job->getExpiresAt()->format('U'));
}
protected function configureFormFields(FormMapper $formMapper)
{
$formMapper->add('category')->add('type', 'choice', array('choices' => Job::getTypes(), 'expanded' => true))->add('company')->add('file', 'file', array('label' => 'Company logo', 'required' => false))->add('url')->add('position')->add('location')->add('description')->add('how_to_apply')->add('is_public')->add('email')->add('is_activated');
}
public function load(ObjectManager $em)
{
for ($i = 100; $i <= 130; $i++) {
$job = new Job();
$job->setCategory($em->merge($this->getReference('category-programming')));
$job->setType('full-time');
$job->setCompany('Company ' . $i);
$job->setPosition('Web Developer');
$job->setLocation('Paris, France');
$job->setDescription('Lorem ipsum dolor sit amet, consectetur adipisicing elit.');
$job->setHowToApply('Send your resume to lorem.ipsum [at] dolor.sit');
$job->setIsPublic(true);
$job->setIsActivated(true);
$job->setToken('job_' . $i);
$job->setEmail('*****@*****.**');
$em->persist($job);
}
$em->flush();
}
public function testGetForLuceneQuery()
{
$em = static::$kernel->getContainer()->get('doctrine')->getManager();
$job = new Job();
$job->setType('part-time');
$job->setCompany('Sensio');
$job->setPosition('FOO6');
$job->setLocation('Paris');
$job->setDescription('WebDevelopment');
$job->setHowToApply('Send resumee');
$job->setEmail('*****@*****.**');
$job->setUrl('http://sensio-labs.com');
$job->setIsActivated(false);
$em->persist($job);
$em->flush();
$jobs = $em->getRepository('IbwJobeetBundle:Job')->getForLuceneQuery('FOO6');
$this->assertEquals(count($jobs), 0);
$job = new Job();
$job->setType('part-time');
$job->setCompany('Sensio');
$job->setPosition('FOO7');
$job->setLocation('Paris');
$job->setDescription('WebDevelopment');
$job->setHowToApply('Send resumee');
$job->setEmail('*****@*****.**');
$job->setUrl('http://sensio-labs.com');
$job->setIsActivated(true);
$em->persist($job);
$em->flush();
$jobs = $em->getRepository('IbwJobeetBundle:Job')->getForLuceneQuery('position:FOO7');
$this->assertEquals(count($jobs), 1);
foreach ($jobs as $job_rep) {
$this->assertEquals($job_rep->getId(), $job->getId());
}
$em->remove($job);
$em->flush();
$jobs = $em->getRepository('IbwJobeetBundle:Job')->getForLuceneQuery('position:FOO7');
$this->assertEquals(count($jobs), 0);
}
