esimonetti
/ indexFinder.php
Last active
August 21, 2017 06:22
Sugar 7.9.1.0 POC to remove sorting for all listview, subpanel and popup selection list fields that do not have a database index
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2017-08-18 on Sugar 7.9.1.0 | |
| // filename: custom/include/indexFinder.php | |
| // | |
| // Tool that helps retrieve and cache indexes on a per-module basis |
esimonetti
/ saveAllContactsAndTriggerAllWorkflows.php
Created
August 23, 2017 02:58
Save all Sugar Contacts, preserving the date modified and modified by. Enforce advanced workflows to trigger for each of the contacts
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| function usage($error = '') { | |
| if(!empty($error)) print(PHP_EOL . 'Error: ' . $error . PHP_EOL); | |
| print(' php ' . __FILE__ . ' --instance /full/path' . PHP_EOL); | |
| exit(1); | |
| } |
esimonetti
/ triggerAllWorkflowsForContacts.php
Last active
August 23, 2017 04:26
Enforce advanced workflows to trigger for each of the contacts, without processing a save
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| function usage($error = '') { | |
| if(!empty($error)) print(PHP_EOL . 'Error: ' . $error . PHP_EOL); | |
| print(' php ' . __FILE__ . ' --instance /full/path' . PHP_EOL); | |
| exit(1); | |
| } |
esimonetti
/ FakeLinkApi.php
Created
August 24, 2017 04:25
— forked from elchele/FakeLinkApi.php
Customization for pulling external/ad-hoc data into a Sugar subpanel
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /* File: ./custom/clients/base/api/FakeLinkApi.php */ | |
| if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); | |
| class FakeLinkApi extends SugarApi { | |
| public function registerApiRest() { | |
| return array( | |
| 'filterRelatedRecords' => array( |
esimonetti
/ CustomAccountsRelateApi.php
Last active
August 25, 2017 04:59
Sugar 7.9.1.0 example of how to extend the RelateApi to display on the Account's Notes subpanel all its Notes and all its first level members Accounts Notes
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2017-08-25 on Sugar 7.9.1.0 | |
| // filename: custom/modules/Accounts/clients/base/api/CustomAccountsRelateApi.php | |
| // | |
| // Display on the Account's Notes subpanel all its Notes and all its first level members Accounts Notes |
esimonetti
/ autoload_custom_redis_cache.php
Created
October 31, 2017 22:51
Forcing custom Sugar Cache to autoload: https://gist.github.com/esimonetti/78999f4dfbac22fd26bab8453a0ed149
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2017-11-01 tested on Sugar 7.9.1.0 | |
| // Forcing custom Sugar Cache to autoload: https://gist.github.com/esimonetti/78999f4dfbac22fd26bab8453a0ed149 | |
| // | |
| // file: custom/Extension/application/Ext/Include/autoload_custom_redis_cache.php | |
| SugarAutoloader::addDirectory('custom/include/SugarCache/'); |
esimonetti
/ repair.php
Last active
November 20, 2023 13:17
Sugar CLI Repair - Instance as script argument - USE TOOTHPASTE INSTEAD! https://github.com/esimonetti/toothpaste
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2017-11-01 on Sugar 7.9.2.0 | |
| function usage($error = '') { | |
| if (!empty($error)) print(PHP_EOL . 'Error: ' . $error . PHP_EOL); | |
| print(' php ' . __FILE__ . ' --instance /full/path' . PHP_EOL); |
esimonetti
/ notifications.js
Last active
November 24, 2017 00:59
Sample customised notifications view to increase Notifications polling and separate delays for Notifications from Meetings and Calls reminders
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2017-11-24 tested on Sugar 7.9.2.0 | |
| // Sample customised notifications view to increase Notifications polling and separate delays for Notifications from Meetings and Calls reminders | |
| // | |
| // IMPORTANT: Lowering the delay values through the configuration options will increase the frequency of the amount of requests completed to the server, for every user's open browser tab. You need to consider the server load implications and sizing requirements. | |
| // | |
| // file: custom/clients/base/views/notifications/notifications.js |
esimonetti
/ CustomNotesFilterApi.php
Last active
December 8, 2017 05:21
Sample customised filter api to help find Notes that are related to multiple Contacts at the same time, with a custom many to many relationship
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2017-12-08 tested on Sugar 7.9.2.0 | |
| // Sample customised filter api to help find Notes that are related to multiple Contacts at the same time, with a custom many to many relationship | |
| // eg: {{url}}/rest/v10/Notes?contact_id[]=<first id>&contact_id[]=<second id> will only return Notes that are related to both contacts at the same time | |
| // | |
| // file: custom/modules/Notes/clients/base/api/CustomNotesFilterApi.php |
esimonetti
/ delete_orphans.php
Last active
June 29, 2018 02:15
CLI script to find and delete orphan records on the custom tables of Sugar modules - Tested up to 35M records in one script run, at about 5,200 records deleted per second
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2017-12-13 on Sugar 7.9.2.0 | |
| // | |
| // CLI script to find and delete orphan records on the custom tables of Sugar modules | |
| function usage($error = '') { |