[waterloomatt]

Your _partial_view would look something like

<?php foreach ($data->targets as $target):?>
	<div class="drug-target">
		<?php echo "{$target->id}: {$target->name}";?>
	</div>
<?php endforeach; ?>

Matt

[Tanya_new_2_yii]

Hello Matt,
Thank you again for the reply!

I tried implementing this, and got a white screen with only 1 row, and still have nothing under the target column.

 changes.png (5.11K)
Number of downloads: 3

Tanya

//Drug.php (model)

public function relations()
	{
		// NOTE: you may need to adjust the relation name and the related
		// class name for the relations automatically generated below.
		return array(
			'targets' => array(self::MANY_MANY, 'Target', 'Drug_has_target(drug_id, target_id)')
		);
	}

public function targetsToString()
{
    $targets = $this->targets;
    if ($targets) 
        {
        $string = '';
        foreach($targets as $target) {
            $string .= $targets->target_id . ', ';
        }
        return substr($string,0,strlen($string)-1);
    }
    return null;
}

	/**
	 * @return array customized attribute labels (name=>label)
	 */
	public function attributeLabels()
	{
		return array(
			'drug_name' => 'Drug Name',
			'drug_id' => 'Drug ID',
			
		);
	}



//Admin.php (for Drug)
<?php $this->widget('zii.widgets.grid.CGridView', array(
        'id'=>'drug-targets-grid',
        'dataProvider'=>$model->search(),
        'filter'=>$model,
        'columns'=>array(
                'drug_id',
                'drug_name',
                array(
                        'header' => 'Targets',
                        'value' => '$data->targetsToString()'
                ),
                array(
                        'class'=>'CButtonColumn',
                ),
        ),
)); ?>

waterloomatt, on 18 March 2013 - 01:34 PM, said:

No, you've done everything correctly but you've run into the problem le_top and I were discussing. To display the names of the targets add this to your Drug model

public function targetsToString()
{
    $targets = $this->targets;
    if ($targets) 
	{
        $string = '';
        foreach($targets as $target) {
            $string .= $targets->name . ', ';
        }
        return substr($string,0,strlen($string)-1);
    }
    return null;
}

and modify your grid to this:

<?php $this->widget('zii.widgets.grid.CGridView', array(
	'id'=>'drug-targets-grid',
	'dataProvider'=>$model->search(),
	'filter'=>$model,
	'columns'=>array(
		'id',
		'name',
		array(
			'header' => 'Targets',
			'value' => '$data->targetsToString()'
		),
		array(
			'class'=>'CButtonColumn',
		),
	),
)); ?>

Please see my earlier post about how to cleanly get around this limitaion.

Matt

[Tanya_new_2_yii]

Just wondering where (in what file) to add the PHP code that you provided (I'm guessing that it would be in the Drug model page)?

I read the post that you referred me to, I am thinking that I will add the following within the code for the widget (parts I am unsure of are in CAPS);

//Admin.php
<?php $this->widget('zii.widgets.grid.CGridView', array(
        'id'=>'drug-targets-grid',
        'dataProvider'=>$model->search(),
        'filter'=>$model,
        'columns'=>array(
                'drug_id',
                'drug_name',
                array(
                        'header' => 'Target ID',
                        value'=>'$this->grid->getTARGET()->renderPartial(\'_viewTARGET_ID\', array(\'data\'=>$data),true);', 
                ),
                array(
                        'class'=>'CButtonColumn',
                ),
        ),
)); ?>

waterloomatt, on 18 March 2013 - 01:48 PM, said:

Your _partial_view would look something like

<?php foreach ($data->targets as $target):?>
	<div class="drug-target">
		<?php echo "{$target->id}: {$target->name}";?>
	</div>
<?php endforeach; ?>

Matt

[waterloomatt]

//Admin.php
<?php $this->widget('zii.widgets.grid.CGridView', array(
	'id'=>'drug-targets-grid',
	'dataProvider'=>$model->search(),
	'filter'=>$model,
	'columns'=>array(
		'drug_id',
		'drug_name',
		array(
			'header' => 'Target ID',
			'type' => 'raw',
			'value'=>'$this->grid->getOwner()->renderPartial("_drug_target", array("data"=>$data), true);', 
		),
		array(
			'class'=>'CButtonColumn',
		)
	)
)); ?>

// $this->grid->getOwner() returns the owner (usually a controller) of the grid. Then, we're using the controller to render a partial view of the 'targets' relation.

// _drug_target is the name of the partial view file to render. I've created and attached it to this post; drop it in the same folder and the grid. (views/drug ??)
// We're passing a $data object (Drug model) to the view and then looping over it's 'targets' relation

http://www.yiiframew...-clistview/#hh1

Matt

Attached File(s)

•  _drug_target.php (154bytes)
  Number of downloads: 1

[Tanya_new_2_yii]

Hello Matt,

Thank you for the explanation of how the partial view works. I just made the changes, and I still get the white screen with only the 1st result showing up (for drug_id and drug_name), and nothing under the results column.

Tanya

 waterloomatt, on 19 March 2013 - 10:39 PM, said:

//Admin.php
<?php $this->widget('zii.widgets.grid.CGridView', array(
	'id'=>'drug-targets-grid',
	'dataProvider'=>$model->search(),
	'filter'=>$model,
	'columns'=>array(
		'drug_id',
		'drug_name',
		array(
			'header' => 'Target ID',
			'type' => 'raw',
			'value'=>'$this->grid->getOwner()->renderPartial("_drug_target", array("data"=>$data), true);', 
		),
		array(
			'class'=>'CButtonColumn',
		)
	)
)); ?>

// $this->grid->getOwner() returns the owner (usually a controller) of the grid. Then, we're using the controller to render a partial view of the 'targets' relation.

// _drug_target is the name of the partial view file to render. I've created and attached it to this post; drop it in the same folder and the grid. (views/drug ??)
// We're passing a $data object (Drug model) to the view and then looping over it's 'targets' relation

http://www.yiiframew...-clistview/#hh1

Matt

[waterloomatt]

K - please post your models (Drug & Target), controller (DrugController) and view files. I'll take a look.

Thanks,

Matt

[Tanya_new_2_yii]

OK THANK YOU (I really appreciate it)!! I have attached the files.
Sorry for all the trouble,
Tanya

*I had tried the relatedbehavior function yesterday too (also had an empty target column), and so you'll see this commented out in the Drug model file.

 waterloomatt, on 20 March 2013 - 07:41 AM, said:

K - please post your models (Drug & Target), controller (DrugController) and view files. I'll take a look.

Thanks,

Matt

Attached File(s)

•  Drug.php (4.01K)
  Number of downloads: 1
•  Target.php (2.37K)
  Number of downloads: 1
•  DrugController.php (4.09K)
  Number of downloads: 2
•  admin.php (1.59K)
  Number of downloads: 1
•  _search.php (1.22K)
  Number of downloads: 1
•  view.php (815bytes)
  Number of downloads: 1
•  _view.php (827bytes)
  Number of downloads: 1
•  index.php (390bytes)
  Number of downloads: 1
•  _drug_target.php (169bytes)
  Number of downloads: 2
•  _form.php (1.59K)
  Number of downloads: 1
•  update.php (570bytes)
  Number of downloads: 1
•  create.php (353bytes)
  Number of downloads: 1

[waterloomatt]

Hi,

I got everything up and running. Had to make a few tweaks to the models. I've attached the entire app + SQL file. At this point, I would guess that there is something not right with the database. For example, the link table Drug_has_targets isn't being populated. Can you confirm there are records in the table for the drug/targets? Also, I noticed that the drug_id (Drug model) and target_id (target_model) have required validators. This is the default behavior when creating models with Gii but I usually remove them from the required list because they are usually setup as primary auto-increment keys in the DB. Are you manually entering their Ids into the create/update forms? And are they setup correctly as primary keys?
 medicine-app.jpg (61.47K)
Number of downloads: 4
 medicine.zip (326.57K)
Number of downloads: 1

-- 
-- Structure for table `drug`
-- 

DROP TABLE IF EXISTS `drug`;
CREATE TABLE IF NOT EXISTS `drug` (
  `drug_id` int(11) NOT NULL AUTO_INCREMENT,
  `drug_name` varchar(100) NOT NULL,
  `drug_indication` varchar(1700) NOT NULL,
  `drug_synonym` varchar(120) NOT NULL,
  `drug_brand` varchar(40) NOT NULL,
  PRIMARY KEY (`drug_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 
-- Data for table `drug`
-- 

INSERT INTO `drug` (`drug_id`, `drug_name`, `drug_indication`, `drug_synonym`, `drug_brand`) VALUES
  ('1', 'Test', 'Test', 'Test', 'Test');

-- 
-- Structure for table `target`
-- 

DROP TABLE IF EXISTS `target`;
CREATE TABLE IF NOT EXISTS `target` (
  `target_id` int(11) NOT NULL AUTO_INCREMENT,
  `target_name` varchar(70) NOT NULL,
  PRIMARY KEY (`target_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- 
-- Data for table `target`
-- 

INSERT INTO `target` (`target_id`, `target_name`) VALUES
  ('1', 'target1'),
  ('2', 'target2');

-- 
-- Structure for table `drug_has_target`
-- 

DROP TABLE IF EXISTS `drug_has_target`;
CREATE TABLE IF NOT EXISTS `drug_has_target` (
  `drug_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  PRIMARY KEY (`drug_id`,`target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Data for table `drug_has_target`
-- 

INSERT INTO `drug_has_target` (`drug_id`, `target_id`) VALUES
  ('1', '1'),
  ('1', '2');

Cheers,

Matt

[waterloomatt]

Also the _drug_target.php file you attached has an error in it. Sorry, if I sent it that way before.

<?php foreach ($data->targets as $target):?>
	<div class="drug-target">
		<?php echo $target->target_id?. ': '. $target->target_name;>
	</div>
<?php endforeach; ?>

// Notice this line: <?php echo $target->target_id?. ': '. $target->target_name;>
<?php foreach ($data->targets as $target):?>
	<div class="drug-target">
		<?php echo $target->id . ': '. $target->name;?>
	</div>
<?php endforeach; ?>

The app I sent you has all the correct files.

Matt

[Tanya_new_2_yii]

Hello Matt,

Thank you for fixing the issue - I will try to get this set-up (I'm a complete newbie, so this may take a while). For the drug and target tables I can confirm that there are records as I can see the records in PHPmyadmin, and the csv files from which I am loading my tables with are filled with entries. I am not sure about the id's in the DB create/update forms, so I guess I am not manually entering them :S. I have set the following though in my DB ..I am assuming that my primary keys are correctly set ..

Drug table -> PK = drug_id
Target table -> PK = target_id
Drug2target table -> drug_id = index -> FK to Drug table
target_id = index -> FK to Target table

Tanya

waterloomatt, on 20 March 2013 - 12:49 PM, said:

Hi,

I got everything up and running. Had to make a few tweaks to the models. I've attached the entire app + SQL file. At this point, I would guess that there is something not right with the database. For example, the link table Drug_has_targets isn't being populated. Can you confirm there are records in the table for the drug/targets? Also, I noticed that the drug_id (Drug model) and target_id (target_model) have required validators. This is the default behavior when creating models with Gii but I usually remove them from the required list because they are usually setup as primary auto-increment keys in the DB. Are you manually entering their Ids into the create/update forms? And are they setup correctly as primary keys?
medicine-app.jpg
medicine.zip

-- 
-- Structure for table `drug`
-- 

DROP TABLE IF EXISTS `drug`;
CREATE TABLE IF NOT EXISTS `drug` (
  `drug_id` int(11) NOT NULL AUTO_INCREMENT,
  `drug_name` varchar(100) NOT NULL,
  `drug_indication` varchar(1700) NOT NULL,
  `drug_synonym` varchar(120) NOT NULL,
  `drug_brand` varchar(40) NOT NULL,
  PRIMARY KEY (`drug_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 
-- Data for table `drug`
-- 

INSERT INTO `drug` (`drug_id`, `drug_name`, `drug_indication`, `drug_synonym`, `drug_brand`) VALUES
  ('1', 'Test', 'Test', 'Test', 'Test');

-- 
-- Structure for table `target`
-- 

DROP TABLE IF EXISTS `target`;
CREATE TABLE IF NOT EXISTS `target` (
  `target_id` int(11) NOT NULL AUTO_INCREMENT,
  `target_name` varchar(70) NOT NULL,
  PRIMARY KEY (`target_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- 
-- Data for table `target`
-- 

INSERT INTO `target` (`target_id`, `target_name`) VALUES
  ('1', 'target1'),
  ('2', 'target2');

-- 
-- Structure for table `drug_has_target`
-- 

DROP TABLE IF EXISTS `drug_has_target`;
CREATE TABLE IF NOT EXISTS `drug_has_target` (
  `drug_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  PRIMARY KEY (`drug_id`,`target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Data for table `drug_has_target`
-- 

INSERT INTO `drug_has_target` (`drug_id`, `target_id`) VALUES
  ('1', '1'),
  ('1', '2');

Cheers,

Matt

[waterloomatt]

K- it is also critical to confirm there are records in the link table.

[Tanya_new_2_yii]

Hi Matt,

I was able to get it running - AND IT WORKS!!!

Thank you SO much for your help ...you're a genius!

Tanya

waterloomatt, on 21 March 2013 - 08:33 AM, said:

K- it is also critical to confirm there are records in the link table.

[waterloomatt]

Quote

you're a genius!

I've been called names before, but never that.