开发者

Cakephp Find Problem

I have a deals table, with a field start date in the controller i am trying the below code and it is not returning any deal when there is deals with these conditions

Here's the codes:

function todays_deal($CitySlug = null) {

        $city = $this->City->find('first', array('conditions' => array('City.slug' => $CitySlug)));
        $CityID = $city['City']['id'];
        $now = date('Y-m-d H:i:s');
        $conditions = array(
            'Deal.city_id' => $CityID,
            'Deal.type' => 'F',
            'Deal.start >=' => $now
        );

        $deal = $this->Deal->find('first',array('conditions'=> $conditions, 'order' => 'Deal.start DESC'));
    $left = array();
        $now = time();
        //Change dates to timestamp
        $end = strtotime($deal['Deal']['end']);
        $start = strtotime($deal['Deal']['start']);
        if($end < $start){
            $end = $start;
        }

        $diff_time = $left_time = $end - $now;

        if ($start >= $now ) {
            $diff_time = $left_time = $start - $now;
        }

        $left_day = floor($diff_time/86400);
        $left_time = $left_time % 86400;
        $left_hour = floor($left_time/3600);
        $left_time = $left_time % 3600;
        $left_minute = floor($left_time/60);
        $开发者_如何转开发left_time = $left_time % 60;

        $this->set(compact('deal', 'left_day', 'left_hour', 'left_minute', 'left_time', 'now', 'diff_time'));

    }

I am totally lost to why this isnt returning any deals as it should.

All help appreciated

Thanks Dave


If you turn up the debug level in CakePHP, it should dump out the queries used.

Check the SQL generated for your select - perhaps the date format is the problem.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜