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.
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]