v 1.3.3 grocery CRUD - an automatic Codeigniter CRUD

[eluser]freeandy[/eluser]
Hi everybody,
I’m new to grocery crud and I’ld like to know how to set a field to insert/update data to my db as an input type password field and use the encryption MD5.
I’m integrating Ion_Auth into my framework and I need help on this topic.
Thanks in advance

[eluser]freeandy[/eluser]
..and another question is about the date format...
Where I can change the date format before the insert/update operations?
I need it because my date format is dd-mm-yyyy and not as usual in us format.
I've changed the js files for jquery localization but I still can't found where to change it into Grocery Crud.
Thanks in advance
Andy

[eluser]Unknown[/eluser]
GroceryCRUD is AWESOME. I cannot thank you enough for the work you have put into it!!

I have a few questions/issues that I wanted to ask about.

1. The flexigrid seems to be the only way to reliably handle large datasets...but it has some bugs. Sometimes searching or changing pages will not update the grid. Anyone else notice this and find a workaround? (Maybe this is something we can fix by updating that component?)

2. I have a self-referencing table where parent_id -> id on the same table. It does not look like I can make this a proper lookup field in GroceryCRUD.

3. I have some nullable foreign keys - how can I make a clear button or otherwise allow the user to enter "null" as an acceptable value for a field?

Thanks again, this is all wonderful stuff that has really helped me.

[eluser]skergetd[/eluser]
Hello, first of all: Great WORK! Thanks...

I have a little question. I have a relation like this...

Code:

$crud = new grocery_CRUD();
$crud->set_table('offer');
$crud->set_relation('coun_ID','country','coun_title');

And now when user wants to add na offer, he selects a country from a dropdown. But what if there is no country that he would like to select? Then he has to add it...
Could i somehow create a button ADD next to dropdown? Or maybe a field in a dropdown that says ADD RECORD? I have been looking everywhere for that, but found nothing.

Code:

callback_field

could kinda do what I want, but if I use it, I can get my button at the end of field, but then there is no dropdown.

Thanks if you could help

[eluser]web-johnny[/eluser]
[quote author="skergetd" date="1327519407"]Hello, first of all: Great WORK! Thanks...

I have a little question. I have a relation like this...

Code:

$crud = new grocery_CRUD();
$crud->set_table('offer');
$crud->set_relation('coun_ID','country','coun_title');

And now when user wants to add na offer, he selects a country from a dropdown. But what if there is no country that he would like to select? Then he has to add it...
Could i somehow create a button ADD next to dropdown? Or maybe a field in a dropdown that says ADD RECORD? I have been looking everywhere for that, but found nothing.

Code:

callback_field

could kinda do what I want, but if I use it, I can get my button at the end of field, but then there is no dropdown.

Thanks if you could help[/quote]

Hello @skergetd,

Actually there are some persons that create an add button at the right of the drop-down list but there is not anywhere as an extension or a sharing code.

Till now it is not available to do something like that so you have to change the library and probably some views to do it.

You can have a try and see how it goes and for any questions or any stack you can post a question to this forum or to the grocery CRUD forum.

[eluser]InsiteFX[/eluser]
@web-johnny

I will have some free time this week and I will see if I can add it.
I'll put the source here for download when I get it to work.

[eluser]web-johnny[/eluser]
[quote author="InsiteFX" date="1327765427"]@web-johnny

I will have some free time this week and I will see if I can add it.
I'll put the source here for download when I get it to work.
[/quote]
For extra coding it will be better to add it at the forums of grocery CRUD at the forum extra coding/plugins (http://www.grocerycrud.com/forums/forum/...g-plugins/) if you don't mind of course. I also write a topic of how to create an extension for grocery CRUD it is a small topic but I will add some more content time to time.

Thanks @InsiteFX

[eluser]fdias[/eluser]
I've been using Grocery Crud for the past couple of months and have to say it's amazing. The developer did a great job and it not only does the job well but also looks great visually.

Thanks a lot for your hard work!

Let me know if I can help.

[eluser]web-johnny[/eluser]
[quote author="fdias" date="1328029341"]I've been using Grocery Crud for the past couple of months and have to say it's amazing. The developer did a great job and it not only does the job well but also looks great visually.

Thanks a lot for your hard work!

Let me know if I can help.[/quote]
Thanks @fdias . This is actually a great post! Similar posts are usually just a beginning phrase of ... BUT I have this problem e.t.c. e.t.c.

I really appreciate it.

Thanks

[eluser]ReyPM[/eluser]
I'm working with n-n relationship and get this error:

Code:

Error Number: 1452</p><p>Cannot add or update a child row: a foreign key constraint fails (`nominas`.`asignaciones_has_ntrabajadores`, CONSTRAINT `Ref_07` FOREIGN KEY (`idasignacion`) REFERENCES `asignaciones` (`idasignacion`) ON DELETE NO ACTION ON UPDATE NO ACTION)</p><p>INSERT INTO `asignaciones_has_ntrabajadores` (`idasignacion`, `idtrabajador`) VALUES (12, '6')

Any advice or help on this?

Also it's possible to use group_by here?