Roles in a combo box

64 Posts

culd | steffan Reply #1, 14 years, 8 months ago

Hi all,

I'm developing an extra and I need to link documents to modx roles.

I need a combobox to display all roles so I can select the right one and save it in the database but the combobox doesn't work.

The combobox is as follows:

/////////////////////////////////////////////////////////////////////////////////////////ROLLEN COMBOBOX
Catalogus.combo.rollen = function(config) {
    config = config || {};
    Ext.applyIf(config,{
        hiddenName: 'role_id',
        displayField: 'name',
        valueField: 'id',
        fields: ['id','name'],
        url: Catalogus.config.connectorUrl,
        baseParams: { action: 'mgr/cataloog/getComboRollen' }
    });
    Catalogus.combo.rollen.superclass.constructor.call(this,config);
};
Ext.extend(Catalogus.combo.rollen,MODx.combo.ComboBox);
Ext.reg('rollen-combo', Catalogus.combo.rollen);

So everything is working as it should exept the values aren't loaded in the combobox, all items in the box are empty.

Any ideas??? [ed. note: culd | steffan last edited this post 14 years, 8 months ago.]

64 Posts

culd | steffan Reply #2, 14 years, 8 months ago

The getcomborollen.php:

$sort = $modx->getOption('sort',$scriptProperties,'id');
$dir = $modx->getOption('dir',$scriptProperties,'ASC');

/* build query */
$c = $modx->newQuery('modUserGroupRole');

$count = $modx->getCount('modUserGroupRole',$c);
$c->sortby($sort,$dir);
if ($isLimit) $c->limit($limit,$start);

$c->prepare();
$modx->log(xPDO::LOG_LEVEL_ERROR, $c->toSql());

$rollen = $modx->getIterator('modUserGroupRole', $c);
 
/* iterate */
$list = array();
foreach ($rollen as $rol) {
    $rolARR = $rol->toArray();
	
    $list[]= $rolARR;
	
	
}
foreach($list as $key=>$value)
	{
	foreach ($value as $key2=>$value2)$modx->log(xPDO::LOG_LEVEL_ERROR, $key2."--".$value2);	
	}
return $this->outputArray($list,$count);

The output from this is:

[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) SELECT `modUserGroupRole`.`id` AS `modUserGroupRole_id`, `modUserGroupRole`.`name` AS `modUserGroupRole_name`, `modUserGroupRole`.`description` AS `modUserGroupRole_description`, `modUserGroupRole`.`authority` AS `modUserGroupRole_authority` FROM `modx_user_group_roles` AS `modUserGroupRole` ORDER BY id ASC 
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) id--1
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) name--Member
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) description--
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) authority--9999
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) id--2
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) name--Super User
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) description--
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) authority--0
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) id--6
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) name--R0
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) description--Deze klant krijgt enkel R0 prijzen te zien
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) authority--0
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) id--7
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) name--R1
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) description--Deze klant krijgt enkel R1 prijzen te zien
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) authority--0
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) id--8
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) name--R2
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) description--Deze klant krijgt enkel R2 prijzen te zien
[2012-02-24 14:48:36] (ERROR @ /catalogus/assets/components/catalogus/connector.php) authority--0