xcruder general table manager module handling relations

  1. Requirements
  2. History
  3. Using the module
  4. Using the demo (xcruder_demo)
  5. Limitations
  6. Resources

xcruder is a general table manager module being able to manage relations. Only the model class files have to be created, not any CRUD pages.

Find the module in the /protected/modules directory of the demo app.



  • 1.2 (current)
  • adopted to Yii v1.18
  • 1.1
  • cleaned up code, demo table structures
  • updated the used extension to the latest
  • more column types in the demo db (added date, enum)
  • added more validation rules to the demo models
  • 1.0
  • base version

Using the module

In your app,

  • Register advancedrelationsbehavior and nlsclientscript in /protected/config/main.php, see their tutorials and the demo app how to do that
  • Create the models for the tables to be managed, using some model generator - it can be the default gii one or giix. Don't forget to define the relations properly for the models
  • In all model classes to be managed, define this method (or inherit all models from a base model class having this method):
public function behaviors(){
		return array(
			'AdvancedRelationsBehavior' => array(
				'class' => 'application.extensions.advancedrelationsbehavior.AdvancedRelationsBehavior',//path to the extension
				'autoUpdate' => false,
				'autoDelete' => true,
				'relations' => null
  • In /protected/config/main.php, register the models you want to manage:
		'c_models' => array(
  • In /protected/config/main.php, register prado view renderer (i use prado format on some places):
  • In /protected/config/main.php, extend the params section by these values
		'dev' => 1,//0|1, developement stage 
		'pageSize' => 6//int, pagination size

Using the demo (xcruder_demo)

  • install the script xcruder_demo/protected/data/schema.mysql.sql into your database
  • set your database properly in /protected/config/main.php
  • in /index.php, set the $yii variable to have the proper framework directory path

Login as admin/admin and go to the xcruder menu item.


  • still can't handle 'set' an 'blob' fields
  • many others:)


See some screenshots here

Select a model first in the combo:

select a model

View the related records clicking the View icon of a row:

view the relations

Create a new related record:

create related record

Select an valid foreign key by the picker view, in either update or create modes:

update related record

5 0
1 949 downloads
Yii Version: 1.1
License: BSD-2-Clause
Category: Database
Developed by: nlac
Created on: Jun 13, 2011
Last updated: 12 years ago


show all

Related Extensions