I need to display a sortable table of organization member records in frontend, preferably with pagination. Before I start coding this from scratch, I want to ask: Does anyone have some ideas on how to do this, and what Craft/Yii/plugin functionality I could use to accomplish this?
I'm fairly new to Craft, so at the moment I don't know where to start looking.
Some more details
I'm writing a frontend customer portal plugin, that uses the built in Craft functionality for handling user registration/login/etc. On top of that I've added a MyPlugin_UserRecord and a MyPlugin_OrganizationRecord record, with some service functionality to handle those.
The MyPlugin_UserRecord can be either a private user by it self, or belong to an organization as a member, and it's the latter that I want to display in the table.
Below you can see the relations I have defined:
UserRecord (Craft) MyPlugin_OrganizationRecord 'craft_user' => array(static::BELONGS_TO, 'UserRecord', 'craft_user_id'), 'members' => array(static::HAS_MANY, 'MyPlugin_UserRecord', 'organization_id'), MyPlugin_UserRecord 'craft_user' => array(static::BELONGS_TO, 'UserRecord', 'craft_user_id'), 'organization' => array(static::BELONGS_TO, 'MyPlugin_OrganizationRecord', 'organization_id'),