Use existing create/edit/delete procedures
3 posts by 2 authors in: Forums > CMS Builder
Last Post: January 3, 2013 (RSS)
By rconring - January 2, 2013 - edited: January 2, 2013
I thought I saw some time ago somewhere in the forum a discussion on using the existing admin CRUD to manage a database view from the front end calling it with a link like http://somesite.com/cmsAdmin/admin.php?menu=sometable&action=edit&num=recordnumber. This all works great, but I cannot figure out how to alter the redirect after save or cancel to go back from whence it came and reload the frontend page and cannot locate the discussion, if it did exist.
Is there a way to accomplish this without serious customization of the admin code? I hate to complicate any future upgrades and this would allow me to present the data in highly customized views and not have to re-write the update procedures in the front end.
Conring Automation Services
----------------------------------------
Software for Business and Industry Since 1987
Hi Ron,
Is the user already logged in to the back end for this to work, are you using the website Membership plugin plugin for this? Also, is there a particular reason your trying to get users to edit sections from the front end?
Are you familiar with creating plugins? You could use the record_postsave hook to redirect the page after the changes have been made, and use the setPrefixedCookie and getPrefixedCookie to store the orignal URL and redirect value. This is something we could create for you if you require, if you send an e-mail to consulting@interactivetools.com, and we can give you an estimated cost.
Thanks!
Greg
PHP Programmer - interactivetools.com
By rconring - January 3, 2013
Thanks for your reply. The answer to your first 3 questions is yes, yes and yes. I am using CMSB to build the data framework for online business applications for some of the clients that I have done sites for. I have, in the past, used AppGini from Bigprof Software since that is what is is designed to do but have used CMSB to build some fairly complex apps. The rub is that I have no problem writing the code for some fairly complex and interactive data views but find it extremely tedious to write the update procedures with my limited knowledge of PHP and MySQL.
For the most part the complexities lie in the views but the existing back end CRUD procedures usually suffice. I discovered that I could create the links in the front end view to call the back end update so all I need now is the redirect back to the calling view.
No, I haven't delved into plugins yet, but I guess the time has come to tackle that. If I get stumped (a relative certainty) I will get with consulting. In the meantime, if someone out there has done this I would like to hear from you.
Conring Automation Services
----------------------------------------
Software for Business and Industry Since 1987