Adding AJAX support in Module Builder's "Edit Relationship" in SugarCrm

In SugarCRM custom modules the default buttons in a subpanel are "Create" and "Select". In the framework SugarCrm is built on top there is support for AJAX / inline create in the subpanel as well as the normal full form create. There are also support for single row selection and multiple row selection. To utilize this you need to have knowledge about the various *defs.php files that are code generated by module builder and SugarCrm.

This hack shows how to add support for these buttons in Module Builder. We are going to UI support for selecting what buttons you want to show in your module's subpanel, the different buttons are AJAX Quick Create Button, Full Form Create Button, AJAX Single Select Button and/or AJAX Multiple Select Button.

After the hack is implemented your Edit Relationsship screen in Module Builder is going to look like the following.

After selecting required buttons save the changes, deploy the package (with the affected modules inside) to see the effect. The following screenshot shows the M1 Subpanel on M2 module where we have selected a Quick Create button.

The following screen shows the M2 Subpanel on M1 module where we have selected a Quick Create and Multi Select button.

Likewise we can select any combination we want for our subpanel. (apart from both having a single and a multiple select button - which I did not think made a lot of sense).

This hack is not upgrade safe.

This is the subversion diff file that outlines the changes made to a SugarCrm 5.5.2 code base to achieve the features described above.

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257

Index: modules/ModuleBuilder/javascript/ModuleBuilder.js =================================================================== --- modules/ModuleBuilder/javascript/ModuleBuilder.js (revision 1) +++ modules/ModuleBuilder/javascript/ModuleBuilder.js (working copy) @@ -872,7 +872,10 @@      ajaxStatus.hideStatus();      var tab = ModuleBuilder.findTabById('relEditor');      tab.set("content", o.responseText); -    SUGAR.util.evalScript(tab); +    //SUGAR.util.evalScript(tab); +    //Hack Relations between modules +    SUGAR.util.evalScript(o.responseText); +                //Hack Relations between modules     });    },    moduleDropDown: function(name, field){ Index: modules/ModuleBuilder/language/en_us.lang.php =================================================================== --- modules/ModuleBuilder/language/en_us.lang.php (revision 1) +++ modules/ModuleBuilder/language/en_us.lang.php (working copy) @@ -627,6 +627,12 @@                  'encrypt'=>'Encrypt'  ),    -'parent' => 'Flex Relate' +'parent' => 'Flex Relate', +//Hack Relations between modules +'LBL_AJAX_QUICK_CREATE_BTN' => 'AJAX Quick Create Button', +'LBL_AJAX_SINGLE_SELECT_BTN' => 'AJAX Single Select Button', +'LBL_AJAX_MULTIPLE_SELECT_BTN' => 'AJAX Multiple Select Button', +'LBL_FULL_FORM_CREATE_BTN' => 'Full Form Create Button', +//Hack Relations between modules  );    Index: modules/ModuleBuilder/parsers/relationships/AbstractRelationship.php =================================================================== --- modules/ModuleBuilder/parsers/relationships/AbstractRelationship.php (revision 1) +++ modules/ModuleBuilder/parsers/relationships/AbstractRelationship.php (working copy) @@ -80,6 +80,7 @@          'relationship_type' ,          'relationship_role_column' ,          'relationship_role_column_value' , +        'ext1' ,  //Hack Relations between modules          'reverse' ) ;         /* @@ -263,12 +264,52 @@    }else{     $subpanelDefinition [ 'title_key' ] = 'LBL_' . strtoupper ( $relationshipName . '_FROM_' . $sourceModule ) . '_TITLE' ;    } -        $subpanelDefinition [ 'get_subpanel_data' ] = $relationshipName ; -        $subpanelDefinition [ 'top_buttons' ] = array( +  $subpanelDefinition [ 'get_subpanel_data' ] = $relationshipName ; +  //Hack Relations between modules +  if(isset($this->definition['ext1']) AND $this->definition['ext1'] != ''){ +   $topBtnOption = explode('_@@_', $this->definition['ext1']); +   // LHS Module +   if ($this->definition['lhs_module'] == $sourceModule){ +    // Quick Create Button +    if($topBtnOption[0] == '1'){ +     $subpanelDefinition [ 'top_buttons' ][] = array('widget_class' => 'SubPanelTopButtonQuickCreate'); +    } +    // Full Form Create Button +    if($topBtnOption[1] == '1'){ +     $subpanelDefinition [ 'top_buttons' ][] = array('widget_class' => 'SubPanelTopCreateButton'); +    } +    // Single Select Button +    if($topBtnOption[2] == '1'){ +                    $subpanelDefinition [ 'top_buttons' ][] = array('widget_class' => 'SubPanelTopSelectButton'); +    } +    // Multiple Select Button +    if($topBtnOption[3] == '1'){ +                        $subpanelDefinition [ 'top_buttons' ][] = array('widget_class' => 'SubPanelTopSelectButton', 'popup_module' => $this->definition['rhs_module'], 'mode' => 'MultiSelect', 'initial_filter_fields' => array()); +    } +   }else{ +    // Quick Create Button +    if($topBtnOption[4] == '1'){ +     $subpanelDefinition [ 'top_buttons' ][] = array('widget_class' => 'SubPanelTopButtonQuickCreate'); +    } +    // Full Form Create Button +    if($topBtnOption[5] == '1'){ +     $subpanelDefinition [ 'top_buttons' ][] = array('widget_class' => 'SubPanelTopCreateButton'); +    } +    // Single Select Button +    if($topBtnOption[6] == '1'){ +                    $subpanelDefinition [ 'top_buttons' ][] = array('widget_class' => 'SubPanelTopSelectButton'); +    } +    // Multiple Select Button +    if($topBtnOption[7] == '1'){ +                        $subpanelDefinition [ 'top_buttons' ][] = array('widget_class' => 'SubPanelTopSelectButton', 'popup_module' => $this->definition['lhs_module'], 'mode' => 'MultiSelect', 'initial_filter_fields' => array());                        +    } +   } +  } +  /*$subpanelDefinition [ 'top_buttons' ] = array(        array('widget_class' => "SubPanelTopCreateButton"),        array('widget_class' => 'SubPanelTopSelectButton', 'mode'=>'MultiSelect') -  ); -        +  );*/ +        //Hack Relations between modules          return array ( $subpanelDefinition );      }          Index: modules/ModuleBuilder/parsers/relationships/AbstractRelationships.php =================================================================== --- modules/ModuleBuilder/parsers/relationships/AbstractRelationships.php (revision 1) +++ modules/ModuleBuilder/parsers/relationships/AbstractRelationships.php (working copy) @@ -151,7 +151,21 @@                      $this->delete ( $_REQUEST [ 'relationship_name' ] ) ;          }          } -        +  //Hack Relations between modules +  $buttonArr = array('lhs_quick_create', 'lhs_full_form_create','lhs_signle_select', 'lhs_multiple_select', 'rhs_quick_create', +                     'rhs_full_form_create', 'rhs_signle_select', 'rhs_multiple_select'); +  $ext1 = ''; +  foreach($buttonArr as $option){ +   $btn = false; +   if(isset($_REQUEST[$option]) AND $_REQUEST[$option] == '1'){ +    $ext1 .= '1_@@_'; +   }else{ +    $ext1 .= '0_@@_'; +   } +  } +  $ext1 = substr($ext1, 0, (strlen($ext1) - 4)); +  $definition ['ext1'] = $ext1; +  //Hack Relations between modules          $newRelationship = RelationshipFactory::newRelationship ( $definition ) ;          // TODO: error handling in case we get a badly formed definition and hence relationship          $this->add ( $newRelationship ) ; Index: modules/ModuleBuilder/tpls/studioRelationship.tpl =================================================================== --- modules/ModuleBuilder/tpls/studioRelationship.tpl (revision 1) +++ modules/ModuleBuilder/tpls/studioRelationship.tpl (working copy) @@ -178,6 +178,45 @@        {/if} {* subpanels etc for all but one-to-one relationships *}     {/if} {* if relationship_only *} +  {* Hack Relations between modules *} +  {if $rel.relationship_type != 'one-to-one'} +  <tr> +   <td colspan=2> +   {if $rel.relationship_type == 'many-to-many'} +   <table class="listView"><tr><td class="listViewThS1"> +   {sugar_translate label=$rel.lhs_module} Subpanel On {sugar_translate label=$rel.rhs_module} +   </td></tr> +   <tr><td class="evenListRowS1"> +   <input type="checkbox" name="lhs_quick_create" id="lhs_quick_create" value="1" onclick="lock_create_option(this.id, 'lhs')" +   {if $ckBoxOption.0 == 1}checked{/if} /> {$mod_strings.LBL_AJAX_QUICK_CREATE_BTN}   +   <input type="checkbox" name="lhs_full_form_create" id="lhs_full_form_create" value="1" onclick="lock_create_option(this.id, 'lhs')" +   {if $ckBoxOption.1 == 1}checked{/if} /> {$mod_strings.LBL_FULL_FORM_CREATE_BTN}   +   <input type="checkbox" name="lhs_signle_select" id="lhs_signle_select" value="1" onclick="lock_multiple_select(this.id, 'lhs')" +   {if $ckBoxOption.2 == 1}checked{/if}/> {$mod_strings.LBL_AJAX_SINGLE_SELECT_BTN}   +   <input type="checkbox" name="lhs_multiple_select" id="lhs_multiple_select" value="1" onclick="lock_multiple_select(this.id, 'lhs')" +   {if $ckBoxOption.3 == 1}checked{/if} /> {$mod_strings.LBL_AJAX_MULTIPLE_SELECT_BTN}   +   </td></tr></table> +   {/if}&nbsp; +   </td> +   <td>&nbsp;</td> +   <td colspan=2> +   <table class="listView"><tr><td class="listViewThS1"> +   {sugar_translate label=$rel.rhs_module} Subpanel On {sugar_translate label=$rel.lhs_module} +   </td></tr> +   <tr><td class="evenListRowS1"> +   <input type="checkbox" name="rhs_quick_create" id="rhs_quick_create" value="1" onclick="lock_create_option(this.id, 'rhs')" +   {if $ckBoxOption.4 == 1}checked{/if} /> {$mod_strings.LBL_AJAX_QUICK_CREATE_BTN}   +   <input type="checkbox" name="rhs_full_form_create" id="rhs_full_form_create" value="1" onclick="lock_create_option(this.id, 'rhs')" +   {if $ckBoxOption.5 == 1}checked{/if} /> {$mod_strings.LBL_FULL_FORM_CREATE_BTN}   +   <input type="checkbox" name="rhs_signle_select" id="rhs_signle_select" value="1" onclick="lock_multiple_select(this.id, 'rhs')" +   {if $ckBoxOption.6 == 1}checked{/if} /> {$mod_strings.LBL_AJAX_SINGLE_SELECT_BTN}   +   <input type="checkbox" name="rhs_multiple_select" id="rhs_multiple_select" value="1" onclick="lock_multiple_select(this.id, 'rhs')" +   {if $ckBoxOption.7 == 1}checked{/if} /> {$mod_strings.LBL_AJAX_MULTIPLE_SELECT_BTN} +   </td></tr>            +            </table> +  </tr> +  {/if} +  {* Hack Relations between modules *}    </table>   </td></tr>  </table> @@ -190,5 +229,53 @@  {else}  ModuleBuilder.helpSetup('studioWizard','relationshipHelp');  {/if} +{* Hack Relations between modules *} +{literal} +    + function lock_multiple_select(id, side){ +  if(!document.getElementById(id)){return false;}    +  if(side == 'lhs'){ +   lock_field = (id == 'lhs_signle_select') ? 'lhs_multiple_select' : 'lhs_signle_select'; +  } +  else{ +   lock_field = (id == 'rhs_signle_select') ? 'rhs_multiple_select' : 'rhs_signle_select'; +  } +  if(document.getElementById(id).checked){ +   document.getElementById(lock_field).disabled = true; +  } +  else{ +   document.getElementById(lock_field).disabled = false; +  } + } + function lock_create_option(id, side){ +  if(!document.getElementById(id)){return false;} +  var lock_field_create=""; +  +  if(side == 'lhs'){ +   lock_field_create = (id == 'lhs_quick_create') ? 'lhs_full_form_create' : 'lhs_quick_create'; +  }else { +   lock_field_create = (id == 'rhs_quick_create') ? 'rhs_full_form_create' : 'rhs_quick_create'; +  } +  +  if(document.getElementById(id).checked){ +   document.getElementById(lock_field_create).disabled = true; +  }else{ +   document.getElementById(lock_field_create).disabled = false; +  } + } + YAHOO.util.Event.onDOMReady(function(){ +  lock_multiple_select('lhs_signle_select', 'lhs'); +  lock_multiple_select('lhs_multiple_select', 'lhs'); +  lock_multiple_select('rhs_signle_select', 'rhs'); +  lock_multiple_select('rhs_multiple_select', 'rhs'); +  +  lock_create_option('lhs_quick_create', 'lhs'); +  lock_create_option('lhs_full_form_create', 'lhs'); +  lock_create_option('rhs_quick_create', 'rhs'); +  lock_create_option('rhs_full_form_create', 'rhs'); + }); +{/literal} + +{* Hack Relations between modules *}  </script> Index: modules/ModuleBuilder/views/view.relationship.php =================================================================== --- modules/ModuleBuilder/views/view.relationship.php (revision 1) +++ modules/ModuleBuilder/views/view.relationship.php (working copy) @@ -193,7 +193,10 @@          $this->smarty->assign ( 'cardinality', array_keys ( $cardinality ) ) ;          $this->smarty->assign ( 'translated_cardinality', $cardinality ) ;          $this->smarty->assign ( 'selected_cardinality', translate ( $relationship->getType () ) ) ; -        +        //Hack Relations between modules +  $ckBoxOption = explode('_@@_', $relationship->ext1); +        $this->smarty->assign ( 'ckBoxOption', $ckBoxOption ) ; +  //Hack Relations between modules          $relatable = array ( ) ;          foreach ( $relatableModules as $name => $dummy )          {

You can download the diff file and the modified core files here MB-RelationshipButtons.zip

The directory modified_files contains the original sugarcrm files with this patch applied for those users that are not yet familiar with SVN.

You are however recommended to use the diff files since you that way have 100% say over what code gets included in your code base rather than trusting the code blindly.
(This is not for these files in particular but goes in general on the internet)

No liability ... normal disclaimer goes here.