//$semester=Yii::app()->db->createCommand("select semester from semester_aktif where semester='".$smt."' limit 1;")->queryScalar();
?>
<?php
echo $form->hiddenField($model, 'semester', array('class' => 'span5', 'maxlength' => 1, 'value' => $smt));
?>
<div class="form-actions">
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'submit', 'type' => 'success', 'icon' => 'icon-plus icon-white', 'label' => $model->isNewRecord ? 'Tambah' : 'Save'));
?>
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'reset', 'label' => 'Ulangi', 'icon' => 'icon-refresh icon-white', 'type' => 'success'));
?>
</div>
<?php
$this->endWidget();
?>
<!-- Menampilkan dialog/popup ketika button di atas di klik -->
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'mydialog', 'options' => array('title' => 'Klik tanda <code>+</code> untuk input data siswa', 'autoOpen' => false, 'modal' => true, 'width' => 640, 'height' => 480)));
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'penempatan-grid', 'dataProvider' => Penempatan::model()->search2(), 'type' => 'striped bordered condensed', 'columns' => array('nis', 'nis0.nama_lengkap', 'kelas', 'lokal', array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button(
"+"
, array(
"class" => "btn submit"
, "id" => "get_link"
, "onClick" => "$(\\"#mydialog\\").dialog(\\"close\\");$(\\"#TrEkstra_nis \\").val(\\"". $data->nis."\\");"))'))));
$this->endWidget('zii.widgets.jui.CJuiDialog');
/**
* 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 = Penempatan::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function actionTemplate()
{
//Template excel untuk import xlsx to db
$bulan = date('m');
if ($bulan < 7) {
$smt = 2;
//jika th 2(1-6) maka tahun-1/tahun-2 2012/2013
$th_ajar = date('Y') - 1 . '/' . date('Y');
} elseif ($bulan < 13 && $bulan > 6) {
$smt = 1;
//jika th 1(7-12) maka tahun/tahun+1 2012/2013
$th_ajar = date('Y') . '/' . (date('Y') + 1);
}
Yii::import('ext.phpexcel.Classes.PHPExcel', true);
$objPHPExcel = new PHPExcel();
$ocim = $objPHPExcel->setActiveSheetIndex();
// Set document properties
$objPHPExcel->getProperties()->setCreator(date('d-m-Y'))->setLastModifiedBy(date('d-m-Y'))->setTitle("Nur Rochim | ISIMS")->setSubject("Raport I-SIMS Penilaian")->setDescription("Raport I-SIMS Penilaian")->setKeywords("Raport I-SIMS Penilaian")->setCategory("Raport I-SIMS Penilaian");
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
$kelas = Yii::app()->db->createCommand("select kelas from jadwal where kode_guru='" . Yii::app()->user->id . "';")->queryScalar();
$lokal = Yii::app()->db->createCommand("select lokal from jadwal where kode_guru='" . Yii::app()->user->id . "';")->queryScalar();
$penempatan = Penempatan::model()->findAll(array('condition' => "kelas='" . $kelas . "' and lokal='" . $lokal . "' and th_ajar='" . $th_ajar . "'"));
$tebal = array('font' => array('bold' => true));
$ocim->setCellValue("A1", "NO")->setCellValue("B1", "NIS")->setCellValue("C1", "NAMA")->setCellValue("D1", "KELAS")->setCellValue("E1", "LOKAL")->setCellValue("F1", "KODE MAPEL")->setCellValue("G1", "NILAI")->setCellValue("H1", "NILAI UN")->setCellValue("I1", "NILAI UAS")->getStyle("A1:I1")->applyFromArray($tebal);
$arraypen = array();
foreach ($penempatan as $pen) {
$arraypen[] = array('nis' => $pen->nis, 'nama_lengkap' => $pen->nis0->nama_lengkap, 'kelas' => $pen->kelas, 'lokal' => $pen->lokal);
}
foreach ($arraypen as $k => $u) {
$ocim->setCellValue('A' . ($k + 2), $k + 1)->setCellValue('B' . ($k + 2), $u['nis'])->setCellValue('C' . ($k + 2), $u['nama_lengkap'])->setCellValue('D' . ($k + 2), $u['kelas'])->setCellValue('E' . ($k + 2), $u['lokal']);
}
//Berikan Border All
$semua = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$ocim->getStyle('A1:I' . ($k + 2))->applyFromArray($semua);
$objPHPExcel->setActiveSheetIndex(0);
ob_end_clean();
ob_start();
// Redirect output to a client’s web browser (Excel2007)
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="isims"' . date("dmY-His") . '');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
}
<tr>
<th>NIS</th>
<th>NAMA</th>
<th>NILAI AKHIR</th>
<?php
$kelas = Yii::app()->db->createCommand("select kelas from jadwal where kode_guru='" . Yii::app()->user->id . "';")->queryScalar();
if ($kelas == 6) {
echo "<th>UJIAN NASIONAL</th>\n\t\t\t\t\t<th>UJIAN SEKOLAH</th>";
}
?>
<th>SIMPAN</th>
</tr>
</thead>
<tbody>
<?php
$siswa = Penempatan::model()->findAll(array('order' => 'nis ASC', 'condition' => "kelas='" . $pgi['kelas'] . "' and lokal='" . $pgi['lokal'] . "' and th_ajar='" . $th_ajar . "'"));
/*$siswa=Penempatan::model()->with('nilais')->findAll(array(
'order'=>'nilais.nis ASC',
//'condition'=>"nilais.kelas='".$pgi['kelas']."' and nilais.lokal='".$pgi['lokal']."' and nilais.th_ajar='".$th_ajar."'",
));
$siswa=Penempatan::model()->with(array(
'nilais'=>array(
'select'=>'*',
'joinType'=>'LEFT JOIN',
'condition'=>"nilais.kelas=".$pgi['kelas']." and nilais.lokal='".$pgi['lokal']."'",
),
))->findAll();*/
foreach ($siswa as $i => $ii) {
?>
