php - Filter Date using Date Picker in Yii -

-

i have generated crud screens using gii.. have search form, have put date picker, give user select date wants.

but problem have date stored in seconds in database.

and know can convert date using strtotime. how filter using search method in model?

this date picker 

<?php          $this->widget('zii.widgets.jui.cjuidatepicker', array(          'name'=>'ordering_date',         'id'=>'ordering_date',         // additional javascript options date picker plugin         'options'=>array(             'showanim'=>'fold',         ),         'htmloptions'=>array(             'style'=>'height:20px;'         ),         ));     ?>

and search method in model. want compare ordering_date 

public function search() {     // warning: please modify following code remove attributes     // should not searched.     //echo $this->ordering_date;     $criteria=new cdbcriteria;      $criteria->compare('order_id',$this->order_id);     $criteria->compare('customer_id',$this->customer_id);     $criteria->compare('delivery_address_id',$this->delivery_address_id);     $criteria->compare('billing_address_id',$this->billing_address_id);     $criteria->compare('ordering_date',$this->ordering_date);     $criteria->compare('ordering_done',$this->ordering_done,true);     $criteria->compare('ordering_confirmed',$this->ordering_confirmed);     $criteria->compare('payment_method',$this->payment_method);     $criteria->compare('shipping_method',$this->shipping_method);     $criteria->compare('comment',$this->comment,true);     $criteria->compare('status',$this->status,true);     $criteria->compare('total_price',$this->total_price);      return new cactivedataprovider($this, array(         'criteria'=>$criteria,     )); }

try this:

$this->widget('zii.widgets.jui.cjuidatepicker', array(         'model'=>$model,         'attribute'=>'ordering_date',         'options'   => array('dateformat' => 'mm-dd-yy',),

and search

$begindate = cdatetimeparser::parse($this->ordering_date, 'mm-dd-yyyy'); $enddate   = $begindate + 24* 60*60; $criteria->addbetweencondition('ordering_date', $begindate, $enddate);

Comments

Post a Comment

Popular posts from this blog

How do you change vbulletin's home page to the forums instead of the default (CMS or Activity Stream)? -

-
i have created website using vbulletin have installed cms , blog modules in in admin default setting forums when enter homepage url redirecting me http://www.demo.com/content/ content cms page please help for vbulletin versions < 4.2. need modify forum index page located in top level of vbulletin directory. based on url in question it's file: http://www.demo.com/index.php here contents of file, can choose whether cms or forum default home page. /** * can choose default script here. uncomment appropriate line * set default script. note: uncomment 1 of these, must * add // comment out script(s) not want use * default script. * * can choose default script if not plan move * file root of website. */ /** * use cms default script: */ require('content.php'); /** * use forum default script: */ // require('forum.php'); for vbulletin versions >= 4.2. there's new "navigation manager". you'll find control settin...
Read more

c++ - Troubles when compiling phash program -

-
here (probably) simple problem: i'm trying use perceptual hashing library phash ubuntu 11.10. had ffmpeg installed, way i've done: sudo apt-get install libphash0 sudo apt-get install libphash0-dev then tried compile program: #include <iostream> #include <phash.h> using namespace std; int main() { ulong64 myhash=0; ph_dct_imagehash("test.jpg", myhash); cout<<myhash<<endl; } when compiling, prints out: undefined reference `ph_dct_imagehash' any suggestion? should do? in advance! matteo monti you forgot link phash library, linker cannot find function. try adding -l phash gcc command line (or update makefile). if doesn't work, maybe you'll need specify library path (the location of *.a file) using -l "/usr/lib/"
Read more