Hey there,
ok, I think I'm following you.
Here's how to go about it:
First, if you're trying to filter on a real date or timestamp column,
then all the work is already done for you.
For example, the created_at/updated_at columns would automatically
cause the filter field that you describe to be created in the filter
form classes.
So, the only case that you'd have to manually create these fields, is
that you're not just filtering on one date field, but on a combination
of different fields..
Either way, the easiest way for you to see how things work is by
adding a created_at column, regenerating the model/forms and looking
at the code it generates. You'll find that it uses the
sfWidgetFormFilterDate widget, which wraps a start-date and an end-
date field.
So much for displaying the fields (you don't need to use a custom
partial in the admin generator to display those, the form render shows
them automatically).
As for building the query, the admin generator calls a "buildCriteria"
method on the form filter class, and that calls a method for every
field of the form, so all the query building happens inside the filter
class. If you add a custom field (as it seems your planning to do),
you also have to customize the query building by adding a method like
this:
public function addMyCustomFieldCriteria(Criteria $criteria, $field,
$value)
{
//manipulate criteria based on the $value variable..
//this can include whatever joins / filterings / custom-logic you
need..
}
depending on how you call your field, the method name needs to match.
And that's it.. Look more at the generated form filter classes to
really see what's going on.
Oh, and you always want to customize the regular form filter classes,
not the Basexxxx classes, as these get overridden whenever you
regenerate the model.
Does this help?
Daniel
On Apr 30, 3:22 pm, fRAnKEnSTEin <shirkav...@gmail.com> wrote:
> Hi,
>
> thank you for your answer. Ok i have a module in my backend called
> "price". For this module i need to add a custom filter this is: i need
> to add to dates, and make a quey based on the dates selected by the
> user. So by now as i said before i just configure the generator.yml of
> the "price" module, to show the partial that holds all the html i
> need(ie the 2 datapickers) in the view of the prices module.
>
> //app/backend/modules/price/config/generator.yml
> ...
> filter:
> display: [ _state ]
> ...
>
> So when i se my browser to enter into the price module i can see the
> filter section with thi inputs, where the user can enter the dates(for
> now they are just 2 simple text inputs) and the "filter" button. Now
> when the user enters the 2 dates and hit the "filter" button i need to
> take those 2 inputs and create a custom query(the query is in my first
> post), but i dont now where i have to create this query...i mean in
> wich file, maybe in "PriceFormFilter.class.php" or in
> "BasePriceFormFilter.class.php" or where else? i dont now if i need to
> overwrite a\ certain function in dome certain class....or if i need to
> create a normal function and then call it from some special where....
> that's why i need to do.
>
> So in few words: i have a price modulo in my backend, i need to show
> up two inputs in the filtering section of the module, when the user
> hit the filter button i need to take the values entered in the inputs
> and execute a custom query so the results will be reflected in the
> list action or something.
>
> Any example, ideas? (need more details..just tell me)
>
> Cheers
>
> --
> If you want to report a vulnerability issue on symfony, please send it to
> security at symfony-project.com
>
> You received this message because you are subscribed to the Google
> Groups "symfony users" group.
> To post to this group, send email to symfony-users@googlegroups.com
> To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com
> For more options, visit this group
> athttp://groups.google.com/group/symfony-users?hl=en
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
