gimana caranya nampilin data dari multiple table

Halo agan-agan Yii Gamers

gan, ae punya table A, simpan: id, name, basic_salary

table B, simpan data: periode, allowance

ane pengen nampilin data kayak gini gan :

Dear %name%

Herewith your monthly salary = %basic_salary%

and allowance = %allowance%


subtotal = %basic_salary% + %allowance%

less :

2% THT -> the formula is 2% * %basic_salary%


total = %basic_salary% + %allowance% - 2% THT

pigimane sih gan caranye? sejauh ini ane cuma baru tau maenan model, view, gii, crud. jadi untuk manipulasi data dari table belon ngerti. mhon bantuan ya agan2. :)

[font="Trebuchet MS"]Mo coba bantu nih gan…

mungkin dengan melihat contoh coding dibawah ini bisa membantu:

di Controler (KriteriaController) buat function:

[/font]




public function actionCreate()

{

	$model=new Kriteria;

	$modelKriteriaGroup=KriteriaGroup::model();

	

	// Uncomment the following line if AJAX validation is needed

	// $this->performAjaxValidation($model);


	if(isset($_POST['Kriteria']))

	{

		$model->attributes=$_POST['Kriteria'];

		if($model->save())

			$this->redirect(array('view','id'=>$model->kriteria_id));

	}


	$this->render('create',array(

		'model'=>$model,

		'modelKriteriaGroup'=>$modelKriteriaGroup,

	));

}



[font="Trebuchet MS"]di Model (KriteriaGroup) buat function baru:[/font]




public function getDataKriteriaGroup() {

	$sql = "SELECT kriteriagrp_id as kriteriagrp_id ,kriteriagrp_nama as kriteriagrp_nama FROM kriteria_group WHERE 1=:kolKondisi";

	$kondisi = "1";

	$params = array(':kolKondisi'=>$kondisi);

	$dataKriteriaGroup=$this->findAllBySql($sql,$params);

	//$dataKriteriaGroup = $this->findAll();

	if($dataKriteriaGroup!==null) {

		foreach($dataKriteriaGroup as $i => $kriteriaGroup){

			$this->dataKriteriaGroupArray[$kriteriaGroup->kriteriagrp_id] = $kriteriaGroup->kriteriagrp_nama;

		}

	} else {

		$this->dataKriteriaGroupArray[] = array(''=>'None');

	}

	

	return $this->dataKriteriaGroupArray ;

}



[font="Trebuchet MS"]kemudian di view (create) bisa dipanggil seperti ini:[/font]




<? 

$test = $modelKriteriaGroup->getDataKriteriaGroup();

die(print_r($test));

?>



[font="Trebuchet MS"]semoga bisa membantu. [/font]

satu-satu ane tanyain ya gan, ada yang gak ngerti neh :)

[font="Trebuchet MS"]di Model (KriteriaGroup) buat function baru:[/font]




public function getDataKriteriaGroup() {

	$sql = "SELECT kriteriagrp_id as kriteriagrp_id ,kriteriagrp_nama as kriteriagrp_nama 

                FROM kriteria_group WHERE 1=:kolKondisi";

	$kondisi = "1";

	$params = array(':kolKondisi'=>$kondisi);

	$dataKriteriaGroup=$this->findAllBySql($sql,$params);

	//$dataKriteriaGroup = $this->findAll();

	if($dataKriteriaGroup!==null) {

		foreach($dataKriteriaGroup as $i => $kriteriaGroup){

			$this->dataKriteriaGroupArray[$kriteriaGroup->kriteriagrp_id] = $kriteriaGroup->kriteriagrp_nama;

		}

	} else {

		$this->dataKriteriaGroupArray[] = array(''=>'None');

	}

	

	return $this->dataKriteriaGroupArray ;

}



ane gak ngerti bagian ini gan




..WHERE 1=:kolKondisi";

	$kondisi = "1";

	$params = array(':kolKondisi'=>$kondisi);

mohon penjelasan ya gan

[font="Trebuchet MS"]itu contoh kalo agan butuh kondisi where gan.

sebenernya agan nggak perlu pake itu juga gak papa tinggal langsung nulis sql nya gan.

saya hanya mencoba mencontohkan param itu bisa digunakan seperti itu.

semoga membantu gan.[/font]