Code from the creek...
A SugarCRM, PHP, SQL and JavaScript developers blog from the backwoods office.
Wednesday, January 1, 2020
Tuesday, December 31, 2019
My new blog
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEpgyObpueGhrmNnyK0mzTWHy90rAUW2o63Kswhs_jK3JnR6Nun3639B103riLiBfj9XcjLfIn6VNZK770yOPPUujqtawmGsjb8f3nR19G4wi4PBiRlMpaKUhrqWLVkh0MyESyHnKz-x8/s200/IMAG0031.jpg)
On the farm, we raise about a dozen goats and sheep, 2 cows, 3 horses, 7 dogs (ranging from a Chihuahua and Maltese to a pair of Great Pyrenees, 6 cats of no discernible use, 4 kids (all girls), and a few dozen Chickens, Guinea fowl, Peacocks, Turkeys, and Ducks. We have been at it for 5 years now so we are still learning but it's a lot of fun when it's not freezing outside.
The last 12 years I have specialized in SugarCRM. I began with version 2.5 when a small company I worked for started using it and I have been working on SugarCRM ever since. I had my own consulting company for a few years where I sold a product called 'Sugar Fully Loaded' that was essentially the SugarCRM CE product with several popular add-ons already loaded and merged (no such thing as upgrade-safe back then). I spent 9 years after that working at SugarCRM in different roles and now I work remotely as a senior developer on an enterprise level installation and we are getting ready to roll out version 7.10 next year.
Wednesday, March 27, 2019
Adding Audit Logs to Reports
My users had a need to query the audit log for various modules in ways that the current built in system would not allow. Now I could create advanced report after advanced report but really I hate making advanced reports. So I added myself a JIRA task to create some way of reporting on the Audit Logs.
This was my list of criteria for this project
All the files are available for download from the GitHUB link at the end of this post.
This was my list of criteria for this project
- I need a way to report on any modules audit log
- I need a way that allows a manager to create their own reports
- That method has to be familiar to them already (this was really me saying I wanted it in the Reports module)
- It must not allow editing of Audit Logs in any way
- It must be fast over millions of records (some of our audit logs are huge)
- It must translate all the raw data back into English
- It must allow our system admins to include that new audit_events table data in the reports
- It cant break the current Audit code
Wednesday, November 7, 2018
Asynchronous Bean Saves
Why I needed this
In my SugarCRM installation I have many logic hooks that update values in other modules. For example, when you save a note it, in the before_save logic hook, it updates a "Last Note Update" field (among others) in the related Case. So that means that you save the note and it has to run all the logic hooks, workflows, advanced workflows and SugarLogic on that note and then it would have to run all that stuff on the related case as well, all while the user waits for their save to finish.In the past to avoid the overhead of a bean save I would just update the related bean with a direct SQL call. But this means you lose out on logic_hooks, workflow and all the rest. So if you can off-load all that extra bean save overhead to a JobQueue job, it will speed up saves while not impacting workflow or logic hooks the way a direct SQL call would. The JobQueue is explained in the developer guide here.
So this is an example of the kind of code I am talking about and the new code I use
The 'new' code would call a function I have placed in a file called custom/Extension/application/Ext/Utils/UpdateBean.php. This makes it available anywhere in the app. Custom utilities are in the developer guide here. That file looks like this
That function submits a job to the job queue and it will run the next time cron runs. So you bean save might be delayed by a minute but your user doesn't have to sit through it. The final file, the job itself is in a file called custom/Extension/modules/Schedulers/Ext/ScheduledTasks/updateBeanJob.php and looks like this
So thats it, easy Asynchronous bean saves.
Friday, October 19, 2018
A Custom SugarLogic Expression
I made my first custom SugarLogic expression tonight. It turned out to be fairly easy but the Manual has small error in it and it fails to explain one thing.
So here is the complete story. First, this is the Developer Guide Manual page for this. Its fairly complete but it tells you to run the SugarLogic repair from the 'Schedulers' menu instead of the 'Repair' menu, small detail. It also does not really go over where the little 'how to' popup text is created. I will go over that here.
For this demo I made a simple SugarLogic expression that returns the number of years from a date until now. It was to show the age of a person based on a birthday field. Here is the code that I placed in this file 'custom/include/Expressions/Expression/Date/NumberOfYearsExpression.php'
Once you have the file in place you run the Admin > Repair > Rebuild Sugar Logic Functions repair and then clear your local browser cache. That last step is crucial.
There is a popup on the Expression Editor that explains hwo to use a function, in this case it looks like this
The text for this popup comes from that comment at the top of the file there, I dont know how or where they do that and it seems rather silly to do it that way but there you go. The comment in question is above the CLASS in the code
So here is the complete story. First, this is the Developer Guide Manual page for this. Its fairly complete but it tells you to run the SugarLogic repair from the 'Schedulers' menu instead of the 'Repair' menu, small detail. It also does not really go over where the little 'how to' popup text is created. I will go over that here.
For this demo I made a simple SugarLogic expression that returns the number of years from a date until now. It was to show the age of a person based on a birthday field. Here is the code that I placed in this file 'custom/include/Expressions/Expression/Date/NumberOfYearsExpression.php'
Once you have the file in place you run the Admin > Repair > Rebuild Sugar Logic Functions repair and then clear your local browser cache. That last step is crucial.
There is a popup on the Expression Editor that explains hwo to use a function, in this case it looks like this
The text for this popup comes from that comment at the top of the file there, I dont know how or where they do that and it seems rather silly to do it that way but there you go. The comment in question is above the CLASS in the code
/** * <b>NumberOfYears(Date d)</b><br>
* Returns number of years since the specified date. */
Monday, October 8, 2018
Make a new team the primary team with confirmation alert
Where I work we use Tasks to pass around work from one department to the next. So a Lead might come in and a Task on that Lead is assigned to the Sales team. Once the Sales team finishes whatever they need to do they assign the Task to the Legal team. The Legal team then passes it to the Order Management team and so on.
One of the issues with this was that we couldnt preadd the teams as tasks take their own path sometimes and it muddied reports when we did that. So each team needed to add the next team to the Task and mark it as Primary.
Well, as with most manual workflows, it didn't always get marked as primary. So I came up with the code below to ask the user, after they add a team, if they want to make it the primary team and if they say yes, then mark it as primary. It took forever to figure out how to tell if a team had been added, and I dont really like this solution but it worked the best so I went with it.
So first the code, it just goes in the record.js of whatever module you want to add this to.
Then add a line to the language file custom/include/language/en_us.lang.php that reads. Notice how I am filling in the 'TeamName' variable with the app.lang.get() code in the record.js file.
With this code in place (after a QR&R of course) when a new team is added, the system will ask the use if they want that team marked as primary. If they say yes then it will be.
One of the issues with this was that we couldnt preadd the teams as tasks take their own path sometimes and it muddied reports when we did that. So each team needed to add the next team to the Task and mark it as Primary.
Well, as with most manual workflows, it didn't always get marked as primary. So I came up with the code below to ask the user, after they add a team, if they want to make it the primary team and if they say yes, then mark it as primary. It took forever to figure out how to tell if a team had been added, and I dont really like this solution but it worked the best so I went with it.
So first the code, it just goes in the record.js of whatever module you want to add this to.
Then add a line to the language file custom/include/language/en_us.lang.php that reads. Notice how I am filling in the 'TeamName' variable with the app.lang.get() code in the record.js file.
With this code in place (after a QR&R of course) when a new team is added, the system will ask the use if they want that team marked as primary. If they say yes then it will be.
Undocumented Alert() options - Confirmation label buttons
Normally, on a confirmation alert the two options are Confirm and Cancel. You can change the labels on these two buttons with the code below.
Subscribe to:
Posts (Atom)
-
My users had a need to query the audit log for various modules in ways that the current built in system would not allow. Now I could create...
-
A few weeks ago I wrote some posts about overriding the CRON handler and I showed code about Developer Communication. Since then I hav...
-
I have been thinking about this dashlet for about 7 years. Its been on my 'to-do' list for probably 4 years. It found its way ...