public static function model($className = __CLASS__)
{
return parent::model($className);
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = KomponengajiM::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
// $modKarykompn = KarykomponenM::model()->findAllByAttributes(array('karyawan_id'=>$id),array('distinct'=>'tglberlaku'));
$modKarykomponen = KarykomponenM::model()->findAll($criteria);
// $modKarykomponen = Yii::app()->db->createCommand('SELECT tglberlaku FROM karykomponen_m GROUP BY tglberlaku')->queryAll();
foreach ($modKarykomponen as $value) {
$tr = '<tr class="odd">';
$tr .= '<td>' . $i . '</td>';
$tr .= '<td>' . $value->tglberlaku . '</td>';
$modKarykomponengajipokok = KarykomponenM::model()->findByAttributes(array('karyawan_id' => $id, 'komponengaji_id' => '1', 'tglberlaku' => $value->tglberlaku));
$gajipokok = $modKarykomponengajipokok->jumlah;
$tr .= '<td>' . number_format($gajipokok, 0, '', '.') . '</td>';
$modKomponengaji = KomponengajiM::model()->findAll("isgaji=TRUE AND komponengaji_id > 1 ORDER BY komponengaji_id");
foreach ($modKomponengaji as $komponen) {
$modKarykomponenpendapatan = KarykomponenM::model()->findByAttributes(array('karyawan_id' => $id, 'tglberlaku' => $value->tglberlaku, 'komponengaji_id' => $komponen->komponengaji_id));
$totalpendapatan += $modKarykomponenpendapatan->jumlah;
}
$tr .= '<td>' . number_format($totalpendapatan, 0, '', '.') . '</td>';
$modKomponenpotongan = KomponengajiM::model()->findAll("ispotongan=TRUE ORDER BY komponengaji_id");
foreach ($modKomponenpotongan as $komponenpotongan) {
$modKarykomponenpembayaran = KarykomponenM::model()->findByAttributes(array('karyawan_id' => $id, 'tglberlaku' => $value->tglberlaku, 'komponengaji_id' => $komponenpotongan->komponengaji_id));
$totalpembayaran += $modKarykomponenpembayaran->jumlah;
}
$tr .= '<td>' . number_format($totalpembayaran, 0, '', '.') . '</td>';
$gajibersih = $gajipokok + $totalpendapatan - $totalpembayaran;
$tr .= '<td>' . number_format($gajibersih, 0, '', '.') . '</td>';
$tr .= '</tr>';
echo $tr;
$i++;
}
?>
</tbody>
</table>
echo $form->labelEx($modKarykomponen, 'tglberlaku');
?>
<div class="mws-form-item">
<?php
echo CHtml::hiddenField('tglberlaku', '', array('readonly' => false, 'id' => 'karyawan_id'));
?>
<?php
$this->widget('application.extensions.CJuiDateTimePicker.CJuiDateTimePicker', array('model' => $modKarykomponen, 'attribute' => 'tglberlaku', 'language' => '', 'mode' => 'date', 'options' => array('dateFormat' => 'dd-M-yy', 'changeYear' => true, 'changeMonth' => true, 'yearRange' => '-70y:+4y', 'showSecond' => false, 'showDate' => false, 'showMonth' => false, 'timeFormat' => 'hh:mm:ss', 'showOn' => 'button', 'buttonImage' => Yii::app()->baseUrl . "/css/icons/32/calendar.png", 'buttonImageOnly' => true), 'htmlOptions' => array('class' => 'isRequired', 'readonly' => true, 'onkeypress' => "return \$(this).focusNextInputField(event)")));
?>
</div>
</div>
</td>
</tr>
</table>
<?php
$modKomponengaji = KomponengajiM::model()->findAll();
?>
<table class="mws-table">
<thead>
<tr>
<th>No</th>
<th>Komponen</th>
<th>Gaji</th>
<th>Potongan</th>
<th>Pilih</th>
</tr>
</thead>
<tbody>
<?php
$id = $_GET['id'];
?>
