Creating custom subpanel on Users module

[bs165]

Hi all,

I am trying to create a subpanel on the Users modules for any modules based on the created_by field on that module matching up with the id field on User, and am heavily basing it on examples in the following forum string from pgr:

Subpanels Cases

Let me try giving you a copy of a different example. My advice is to first try to get my example working as it is, without changing anything; only after it’s working you try and adapt it to your requirement, ok? Create this file custom/Extension/modules/Accounts/Ext/Layoutdefs/Leads.php with these contents: <?php $layout_defs["Accounts"]["subpanel_setup"]['leads'] = array( 'order' => 80, 'module' => 'Leads', 'sort_order' => 'asc', 'sort_by' => 'first_name, last_name', 's…

is this possible, or is Users some kind of special module? I am getting a permanent loading circle when trying to open the subpanel, and can create subpanels fine using that example above on other modules.

[pgr]

I don’t see why it wouldn’t work for Users module.

It’s better if you include your full code, file paths and names, and the exact error you’re seeing. Maybe it’s just some minor detail that is wrong.

[bs165]

thanks pgr, here’s my code:

custom/Extension/modules/Users/Ext/Layoutdefs/Contacts.php

<?php


$layout_defs["Users"]["subpanel_setup"]['contacts'] = array(
    'order' => 80,
    'module' => 'Users',
    'sort_order' => 'asc',
    'sort_by' => 'first_name, last_name',
    'subpanel_name' => 'default',
    'get_subpanel_data' => 'function:getRelatedContactsQueryData',
    'function_parameters' => array(
        'import_function_file' => 'custom/modules/Users/GetUsersSubpanelData.php',
        'link' => 'contacts'
    ),
    'add_subpanel_data' => 'contact_id',
    'title_key' => 'LBL_CONTACTS_SUBPANEL_TITLE',
); 

custom/modules/Users/GetContactsSubpanelData.php

<?php
require_once 'custom/modules/Users/BuildContactsSubpanelQueryService.php';

function getRelatedContactsQueryData($param){
$service = new BuildContactsSubpanelQueryService();
return $service->BuildQuery($param);
}

custom/modules/Users/BuildContactsSubpanelQueryService.php

<?php
class BuildContactsSubpanelQueryService
{

public function __construct(){}

public function buildQuery($param){
    global $app;
    $controller = $app->controller;
    $bean = $controller->bean;
    $query = "SELECT * FROM contacts WHERE contacts.created_by = '$bean->id'";
    return $query;
    }
}

with title created by
custom/Extension/modules/Users/Ext/Language/en_us.users_contacts_subpanel.php

<?php
$mod_strings['LBL_CONTACTS_SUBPANEL_TITLE']='Contacts';

on this fix I get a good looking subpanel header on the page but when you click it to drop it down its the loading circle(s) permanently, any advice? thanks again for your time

[pgr]

Look for errors both on the suitecrm.log and the php_errors.log

[bs165]

I’ve got MySQL error 1064: you have an error in your SQL syntax;
but I tried to mirror your syntax on that old example as strictly as possible, given that these are all default fields do you see anything glaringly wrong with my syntax in that query by chance?

[pgr]

SQL errors are usually more explicit than that, they tell you exactly what is wrong…

Try printing your $query variable to check if the quotes and variable substitution are working as intended.