Group By in Pagination
Hello All, I want to create a pagination in which the data is grouped using group by clause. I think cake php pagination do not support group by directly and instead we need to do it using custom pagination method. I saw the documentation for it in the book, but the issue is that I only want the group by in one action and lot of other actions depend on the same model. So my doubt is if I override paginate() and paginateCount() wont that affect all the other pagination which depends on the same action. If yes is there any other methods to use group by clause with pagination? Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Separate message for Auth and ACL
Hi, I had already asked this question in the IRC but I was told that it is not possible. I am just trying out my luck here in the group. The issue for me is that I want to provide separate messages for Auth component session timeout error and ACL permission denied error. Currently ACL uses the $this->Auth->authError variable to display permission denied message. What I want is if the session gets timed out then the system should display the login page and display the error "You are logged out from the system, Please Login again". If the the user tried to access the page which he do not have access to then the system should display the error "You do not have access to that page.". I guess that is more logical than displaying the error "You are logged out from the system, Please Login again" for ACL permission denied error. So is it possible to set seperate message for acl and auth? How is it possible? Hope to get a reply soon. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
ACL Deny Allow issue
Hello All, I am struck with a weird situation. I have a page which allows a user (admin) to create a group, set and deny permission to an controller action for that group. If it is a new group I am able to set and deny the permissions to certain actions of controller without any issues. But when it is in edit mode I am not able to remove (deny) the permissions of already set (allow) permission. For example the permission which is already set is for the action 'ROOT/groups/ search' . I used the following code to set the action: $group = & $this->Group; $group->id = $id; $this->Acl->allow ( $group, ''ROOT/groups/search' ); In edit I tried following code to remove the action for 'ROOT/groups/ search'. $group = & $this->Group; $group->id = $id; $this->Acl->deny ( $group, ''ROOT/groups/search' ); But it did not work. This is same for the reverse type, that is to allow permission to already permission denied action. Could anyone help me out from this situation? Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Checking permission
Hello all, I have set up a basic ACL and login using auth component. Now I want to create a menu which would be based on the users group. So if the group do not have access to an action then that action should not come up in the menu. What I wanted to know is how can I understand if the logged in user got access to an action? Please help. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Help with ACL
In my above post I had said "These 4 groups will be common for all office and the rules are predefined for these for groups.". Please read it as "From these, 4 groups will be common for all office and the rules for those four groups are predefined" On Nov 3, 11:44 am, jst4fun <[EMAIL PROTECTED]> wrote: > Hi Stinkbug, > Thanks again for your interest in helping me out. Sorry for the delay. > I was able to setup permission dynamically. But still it is not > proper. Before going further I will provide you my table structure > > offices table: > id - int > name - varchar > > groups Table > id - int > office_id - int > name - int > > users table > id - int > group_id -int > name - varchar > password - varchar > > The aco, aro and acos_aros table is created by cake console script. I > hope you dont need those tables. I have not altered it. > My requirement is to set up roles with permission set for controller/ > action access. Each offices will have a set of groups. These 4 groups > will be common for all office and the rules are predefined for these > for groups. Even the administrator cannot change the roles for these > four groups. Rest of the groups cannot be the duplicate for any office > and the administrator can edit the permission for these groups. > Groups will have many users and these users are depended on the > office. That is user of office 'z' can be a part of group 'f' if and > only if 'f' is a child group of 'z' office. A user can have multiple > groups. I will post the code I have below. Now I am able to save a > group under an office with a set of permission correctly. My issue is > that: > 1) I am not sure how to set 4 common groups to a offices when that > office is created. > 2) I am not sure on how to set up multiple groups for a user. > > Now I will provide the code I have done till date > > MODEL > 1) Office model -http://pastebin.com/m3f1f37de > 2) Group model -http://pastebin.com/m4464956 > 3) User model -http://pastebin.com/m1e7543f > > CONTROLLER > 1) Groups Controller:http://pastebin.com/m315b2987 > > I have done nothing related to ACL in office and user controller. The > code which I have posted above was the result of lot of researches I > had done on ACL :D. I guess this would be enough for you to understand > what I am trying to do. I hope you will try to help me soon. Thanks > once again. > > On Oct 31, 6:55 pm, Stinkbug <[EMAIL PROTECTED]> wrote: > > > Well, so much for an answer soon. Sorry about that. Not sure if you > > still need help with this, but could you show us your aro and aco > > structures so I get get a better idea as to what you're trying to do. > > > I think I see what you're trying to do, but let's see if you have a > > proper ACl setup first. > > > On Oct 24, 5:45 am, jst4fun <[EMAIL PROTECTED]> wrote: > > > > Well I had gone through the links which you guys had provided. Thanks. > > > But the issue for me to implement an ACL is that I am not sure what > > > all function should be used due to the lack of documentation. One of > > > the requirement is already discussed above. I think I was able to > > > implement it partially. What I did was to create three tables one > > > offices, groups and then users.I created parentNode() for group > > > binding it to the office model and in users binding every users to > > > group model. Now when I create a Group and select an office it is > > > correctly created in aros table. Same with the users too. I found a > > > script from cakebaker to list all controllers and save it as acos. Now > > > I have aros and acos setup. In my application a superadmin can add new > > > user, group and offices dynamically. This part i guess is already > > > solved, thanks to parentNode(). When the super admin takes the add > > > group page all the controllers with their actions are also displayed > > > in that page. Actions will be having checkboxes to enable or disable > > > that action to the user of that group. So my first doubt is > > > 1) How is it possible to save a group and then its associated > > > permissions dynamically? > > > Then definitely the admin might have to delete a office or a group. In > > > such a case > > > 2) How is it possible to delete all the office and its group and > > > remove the deleted group information from the users . > > > I hope I have made everything clear and hope to get a reply soon. > > > Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Help with ACL
Hi Stinkbug, Thanks again for your interest in helping me out. Sorry for the delay. I was able to setup permission dynamically. But still it is not proper. Before going further I will provide you my table structure offices table: id- int name - varchar groups Table id - int office_id - int name - int users table id - int group_id -int name - varchar password - varchar The aco, aro and acos_aros table is created by cake console script. I hope you dont need those tables. I have not altered it. My requirement is to set up roles with permission set for controller/ action access. Each offices will have a set of groups. These 4 groups will be common for all office and the rules are predefined for these for groups. Even the administrator cannot change the roles for these four groups. Rest of the groups cannot be the duplicate for any office and the administrator can edit the permission for these groups. Groups will have many users and these users are depended on the office. That is user of office 'z' can be a part of group 'f' if and only if 'f' is a child group of 'z' office. A user can have multiple groups. I will post the code I have below. Now I am able to save a group under an office with a set of permission correctly. My issue is that: 1) I am not sure how to set 4 common groups to a offices when that office is created. 2) I am not sure on how to set up multiple groups for a user. Now I will provide the code I have done till date MODEL 1) Office model - http://pastebin.com/m3f1f37de 2) Group model - http://pastebin.com/m4464956 3) User model - http://pastebin.com/m1e7543f CONTROLLER 1) Groups Controller: http://pastebin.com/m315b2987 I have done nothing related to ACL in office and user controller. The code which I have posted above was the result of lot of researches I had done on ACL :D. I guess this would be enough for you to understand what I am trying to do. I hope you will try to help me soon. Thanks once again. On Oct 31, 6:55 pm, Stinkbug <[EMAIL PROTECTED]> wrote: > Well, so much for an answer soon. Sorry about that. Not sure if you > still need help with this, but could you show us your aro and aco > structures so I get get a better idea as to what you're trying to do. > > I think I see what you're trying to do, but let's see if you have a > proper ACl setup first. > > On Oct 24, 5:45 am, jst4fun <[EMAIL PROTECTED]> wrote: > > > Well I had gone through the links which you guys had provided. Thanks. > > But the issue for me to implement an ACL is that I am not sure what > > all function should be used due to the lack of documentation. One of > > the requirement is already discussed above. I think I was able to > > implement it partially. What I did was to create three tables one > > offices, groups and then users.I created parentNode() for group > > binding it to the office model and in users binding every users to > > group model. Now when I create a Group and select an office it is > > correctly created in aros table. Same with the users too. I found a > > script from cakebaker to list all controllers and save it as acos. Now > > I have aros and acos setup. In my application a superadmin can add new > > user, group and offices dynamically. This part i guess is already > > solved, thanks to parentNode(). When the super admin takes the add > > group page all the controllers with their actions are also displayed > > in that page. Actions will be having checkboxes to enable or disable > > that action to the user of that group. So my first doubt is > > 1) How is it possible to save a group and then its associated > > permissions dynamically? > > Then definitely the admin might have to delete a office or a group. In > > such a case > > 2) How is it possible to delete all the office and its group and > > remove the deleted group information from the users . > > I hope I have made everything clear and hope to get a reply soon. > > Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Fetching ACO
David thanks, that worked. :) On Oct 29, 1:10 pm, "David C. Zentgraf" <[EMAIL PROTECTED]> wrote: > Off the top of my head I have used this quite a while ago: > $this->Acl->Aco->findAll(); > $this->Acl->Aco->generatetreelist(); > > I'd venture the guess that $this->Acl->Aco->find('threaded') should > work too. > > On 29 Oct 2008, at 16:18, jst4fun wrote: > > > > > Hello all, > > I am trying to fetch the list of all ACO as a tree from the acos > > table. I hope there will be some function in acl to fetch all the aco > > list as an array. Already there is a console method "acl view aco". So > > what is the php function to do the same so that I can use it in my > > controllers. Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Fetching ACO
Hello all, I am trying to fetch the list of all ACO as a tree from the acos table. I hope there will be some function in acl to fetch all the aco list as an array. Already there is a console method "acl view aco". So what is the php function to do the same so that I can use it in my controllers. Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Help with ACL
Well I had gone through the links which you guys had provided. Thanks. But the issue for me to implement an ACL is that I am not sure what all function should be used due to the lack of documentation. One of the requirement is already discussed above. I think I was able to implement it partially. What I did was to create three tables one offices, groups and then users.I created parentNode() for group binding it to the office model and in users binding every users to group model. Now when I create a Group and select an office it is correctly created in aros table. Same with the users too. I found a script from cakebaker to list all controllers and save it as acos. Now I have aros and acos setup. In my application a superadmin can add new user, group and offices dynamically. This part i guess is already solved, thanks to parentNode(). When the super admin takes the add group page all the controllers with their actions are also displayed in that page. Actions will be having checkboxes to enable or disable that action to the user of that group. So my first doubt is 1) How is it possible to save a group and then its associated permissions dynamically? Then definitely the admin might have to delete a office or a group. In such a case 2) How is it possible to delete all the office and its group and remove the deleted group information from the users . I hope I have made everything clear and hope to get a reply soon. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Help with ACL
Penfold and Stinkbug, thank you very much for your support. I am working on it and if I face any issues I will come back and I hope you guys will help out :). Thanks once again --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Help with ACL
Hi All, I have been trying to create an application using cakephp ACL and have been pulling out my hairs for past few days. I was not able to get much help from the IRC so my last hope is with this group.Those reading this might feel stupid, but I am beginner so please bear with me. I followed the tutorial at http://book.cakephp.org/view/641/Simple-Acl-controlled-Application and I felt it was a good starting point. But my issue is that, in that tutorial group structure created is of the following format Administrator - User1 Employee - User2 - User3 Editor - User2 - User4 In my situation there needs to be another top level group as follows Office1 - Administrator - User1 - Employee - User2 - User3 - Editor - User2 - User4 Office2 - Administrator - User5 - Accountant - Use5 - User2 - HR - User2 - User4 The above structure means there will be a parent group for a group. What change should be made to the code in http://book.cakephp.org/view/545/Using-the-AclBehavior to bring out such a grouping. If my question is not clear please let me know. Please please please help me out. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Setting ACL permission dynamically
I was just following your tutorial at http://mark-story.com/posts/view/auth-and-acl-an-end-to-end-tutorial-pt-1. The first part is fine, in the second part of your tutorial you are assigning the permission to the group manually using the method $this- >Acl->allow and $this->Acl->deny. Well as you know, I want that functionality to be dynamic. So what I will require is to get the group ID dynamically. It seems that I will have to setup an alias (which you have not covered in the tutorial for each group and users) in order to get the group ID. So my doubts are how to set an alias and also how to get the group ID of just saved group, in order to use it in $this->Acl->allow. Hope you will provide me a reply. Thank You On Oct 16, 1:31 am, mark_story <[EMAIL PROTECTED]> wrote: > Adding permissions can be done through a web interface. You just need > to know what actions there are in your app, and what the inherited > permissions are. I can't think of any tutorial that will cover your > exact use case, but there are plenty of tutorials covering how to > implement an ACL controlled app. All you need to figure out is how to > add permissions, which should be fairly evident after perusing the > tutorials. > > If another framework has this type of permissions system already done/ > built-in, I would like to know as I would be interested how it was > done. > > -Mark > > On Oct 15, 3:39 pm, jst4fun <[EMAIL PROTECTED]> wrote: > > > Hi, > > I got a requirement in one of the project which I though cakephp will > > be suitable. The reason is because it needs an ACL system. In that > > project, I have to implement add roles page (groups in ACL terms) > > which would add new groups which is attached with a set of permission. > > Once a group is added the user is redirected to a page where he can > > assign the permission for each actions in a controller. Well since I > > am just a beginner in ACL, I am not sure on how to implement it. In > > fact I am not even sure if this is possible because most of the > > tutorials I had followed explains methods to directly add the > > permission for each group. Could someone guide me on this else I will > > be forced to change from cakephp to some other framework, which I > > don't wish to. Please help. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Setting ACL permission dynamically
thanks mark. In fact i was following your tutorial which became the gateway for my entry to Acl. It was very easy to follow. Thanks for that great tutorial. Seriously it was too good to be missed. Back to the topic, i think i will be back if i face any issues while coding any part of the requirement. I just started. Thanks. On Oct 16, 1:31 am, mark_story <[EMAIL PROTECTED]> wrote: > Adding permissions can be done through a web interface. You just need > to know what actions there are in your app, and what the inherited > permissions are. I can't think of any tutorial that will cover your > exact use case, but there are plenty of tutorials covering how to > implement an ACL controlled app. All you need to figure out is how to > add permissions, which should be fairly evident after perusing the > tutorials. > > If another framework has this type of permissions system already done/ > built-in, I would like to know as I would be interested how it was > done. > > -Mark > > On Oct 15, 3:39 pm, jst4fun <[EMAIL PROTECTED]> wrote: > > > Hi, > > I got a requirement in one of the project which I though cakephp will > > be suitable. The reason is because it needs an ACL system. In that > > project, I have to implement add roles page (groups in ACL terms) > > which would add new groups which is attached with a set of permission. > > Once a group is added the user is redirected to a page where he can > > assign the permission for each actions in a controller. Well since I > > am just a beginner in ACL, I am not sure on how to implement it. In > > fact I am not even sure if this is possible because most of the > > tutorials I had followed explains methods to directly add the > > permission for each group. Could someone guide me on this else I will > > be forced to change from cakephp to some other framework, which I > > don't wish to. Please help. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Setting ACL permission dynamically
Hi, I got a requirement in one of the project which I though cakephp will be suitable. The reason is because it needs an ACL system. In that project, I have to implement add roles page (groups in ACL terms) which would add new groups which is attached with a set of permission. Once a group is added the user is redirected to a page where he can assign the permission for each actions in a controller. Well since I am just a beginner in ACL, I am not sure on how to implement it. In fact I am not even sure if this is possible because most of the tutorials I had followed explains methods to directly add the permission for each group. Could someone guide me on this else I will be forced to change from cakephp to some other framework, which I don't wish to. Please help. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Pagination Help
Hi Anja, thanks for your reply. :) On Oct 13, 11:35 am, "Liebermann, Anja Carolin" <[EMAIL PROTECTED]> wrote: > Hi jst4fun, > > I don't know one, but haven't investigated. I was just happy when mine worked > in the standard mode ;-) > > However for me this sounds as either writing your own controller action or > using JavaScript. > > Good luck! > > Anja > > -Ursprüngliche Nachricht- > Von: cake-php@googlegroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von > jst4fun > Gesendet: Montag, 13. Oktober 2008 08:30 > An: CakePHP > Betreff: Re:PaginationHelp > > Anyhelpon this issue? Thanks > > On Oct 10, 3:48 pm, jst4fun <[EMAIL PROTECTED]> wrote: > > > Hi all, > > I would like to have apaginationin which there wont be any numbered > > links instead it will be a textbox with next and previous links to > > each side of it. In the textbox the user can enter the page number to > > be loaded and then press enter. I am not sure if such an helper exist > > for cakephp or whether the defaultpaginationclass got that capability. > > Is there any helper that does this, then please provide me with the > > link or please let me know whether it is possible using the > > currentpaginationhelper. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Pagination Help
Any help on this issue? Thanks On Oct 10, 3:48 pm, jst4fun <[EMAIL PROTECTED]> wrote: > Hi all, > I would like to have apaginationin which there wont be any numbered > links instead it will be a textbox with next and previous links to > each side of it. In the textbox the user can enter the page number to > be loaded and then press enter. I am not sure if such an helper exist > for cakephp or whether the defaultpaginationclass got that > capability. Is there any helper that does this, then please provide me > with the link or please let me know whether it is possible using the > currentpaginationhelper. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Pagination Help
Hi all, I tried to get an answer to my problem from the IRC but failed. Well my issue is that I was a different king of pagination rather than the current one. The pagination should display a textbox instead of page numbers. This text box needs to be in between previous and next links. The purpose is for the user to enter the page number directly to the text box and on pressing enter key he will be taken to that page. Is there any helper or component like that for cakephp? If not is it possible to extend the current pagination helper in order to bring such a functionality? Hope to get some help on this. Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Pagination Help
Hi all, I would like to have a pagination in which there wont be any numbered links instead it will be a textbox with next and previous links to each side of it. In the textbox the user can enter the page number to be loaded and then press enter. I am not sure if such an helper exist for cakephp or whether the default pagination class got that capability. Is there any helper that does this, then please provide me with the link or please let me know whether it is possible using the current pagination helper. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---