Symfony 2 PHP comparing dates issues

Question

using php 5.5.9 . I have Tranche Entity, and it has a date attribute. What I want is to get number of rows matching a criteria; having date gt/lt current date ,so I created a twig extension, this is my code: following this this

public function e()
{
    $criteria = new \Doctrine\Common\Collections\Criteria();
    $date=date('Y-m-d');
    $criteria->where($criteria->expr()->lt('date',$date));
    $result=$this->em->getRepository('OCUserBundle:Tranche')->matching($criteria);
    return count($result);
}

My problem is that I can't compare dates no matter what I tried.

This is the error:

DateType.php line 53: Error: Call to a member function format() on a non-object

I've searched a lot and tried many suggestions, not working and I'm stuck. What's happening and thank you in advance.

where do you get your date? You are converting it two times. — aldrin27, Aug 15 '15 at 16:38
`$criteria->where($criteria->expr()->lt('date', new \DateTime()));` — qooplmao, Aug 15 '15 at 16:40
Thanks, I don't why it didn't came to my mind! I have been sitting for 5 hours straight on my lap. Thank you @Qoop — Abdelaziz Dabebi, Aug 15 '15 at 16:44

score 2 · Answer 1 · answered Aug 15 '15 at 16:43

2

public function e() {
 $criteria = new \Doctrine\Common\Collections\Criteria();
 $d=date('Y-m-d'); // i think your error is here
 $timestamp = strtotime($d); //here
 $date=date('Y-m-d',$timestamp); //and here

 $d = //place here where the date is coming from
 $date = date('Y-m-d', strtotime($d)); //formatter of date
 $criteria->where($criteria->expr()->lt('date',$date));
 $result=$this->em->getRepository('OCUserBundle:Tranche')->matching($criteria);
 return count($result);
}

answered Aug 15 '15 at 16:43

aldrin27

3,407
3
29
43

Thank you for your efforts aldrin27. Qoop answered my question. – Abdelaziz Dabebi Aug 15 '15 at 16:46
No problem @AbdelazizDabebi. I realized that you want to get the current time. – aldrin27 Aug 15 '15 at 16:48

score 1 · Accepted Answer · answered Aug 15 '15 at 16:55

1

Solved as @Qoop said. It should be :

$criteria->where($criteria->expr()->lt('date', new \DateTime()));

answered Aug 15 '15 at 16:55

Abdelaziz Dabebi

1,624
1
16
21

Symfony 2 PHP comparing dates issues

2 Answers2