Yii Dropdown Dependent Controller

PHP

public function actionFilterjurusan() { $data=Jurusan::model()->findAll(‘id_tingkatan=:id_tingkatan’,array(‘:id_tingkatan’=>$_POST[‘id_tingkatan’])); $data=CHtml::listData($data,’id_jurusan’,’jurusan’); echo ‘<option value=””>Pilih Jurusan</option>’; foreach($data as $value=>$name) { echo CHtml::tag(‘option’,array(‘value’=>$value),CHtml::encode($name),true); } } public function actionFilterkelas() { $data=Kelas::model()->findAll(‘id_jurusan=:id_jurusan’,array(‘:id_jurusan’=>$_POST[‘id_jurusan’])); $data=CHtml::listData($data,’kelas’,’kelas’); echo ‘<option value=””>Pilih Kelas</option>’; foreach($data as $value=>$name) { echo CHtml::tag(‘option’,array(‘value’=>$value),CHtml::encode($name),true); } } public function actionFiltersiswa() { $data=Siswa::model()->findAll(‘kelas=:kelas’,array(‘:kelas’=>$_POST[‘kelas’])); $data=CHtml::listData($data,’nisn’,’nama’); foreach($data as $value=>$name) { echo CHtml::tag(‘option’,array(‘value’=>$value),CHtml::encode($name),true); } } public function actionAutocomplete() { //$id

Yii Dropdown Dependent

PHP

<?php $form=$this->beginWidget(‘CActiveForm’, array( ‘id’=>’keterangan-form’, ‘enableAjaxValidation’=>false, )); ?> <br><div class=”col-lg-12″> <div class=”card”> <div class=”card-close”> <div class=”dropdown”> <button type=”button” id=”closeCard2″ data-toggle=”dropdown” aria-haspopup=”true” aria-expanded=”false” class=”dropdown-toggle”><i class=”fa fa-ellipsis-v”></i></button> <div aria-labelledby=”closeCard2″ class=”dropdown-menu dropdown-menu-right has-shadow”><a href=”#” class=”dropdown-item remove”> <i class=”fa fa-times”></i>Close</a><a href=”#” class=”dropdown-item edit”> <i class=”fa fa-gear”></i>Edit</a></div> </div> </div> <div class=”card-header d-flex align-items-center”> <h3 class=”h4″>Input Presensi ( Izin/Sakit )</h3> </div> <div

Import Excel ke PHP

PHP

public function actionCreate() { $database = ‘karyawan’; //nama database $user = ‘user’; //nama user db $pass = ‘passwordnya’; //pass db $host = ‘localhost’; $conn = mysqli_connect($host,$user,$pass,$database); if (!$conn) { die(“Connection failed: ” . mysqli_connect_error()); exit(); } include”PHPExcel.php”; $random = “file_upload_”.date(‘Y-m-d-H-i-s’).rand(11111,99999); $target_file = Yii::app()->basePath.’/../upload/’.$random.basename($_FILES[“file_excel”][“name”]); $uploadOk = 1; if (move_uploaded_file($_FILES[“file_excel”][“tmp_name”], $target_file)) { ini_set(‘memory_limit’, ‘-1’); $objReader = PHPExcel_IOFactory::createReader(‘Excel2007’);

Rekap Nilai Rapor Jibas

Mysql

select `tahunajaran`.`tahunajaran` AS `tahunajaran`, `semester`.`semester` AS `semester`, `siswa`.`nis` AS `nis`, `siswa`.`nama` AS `siswa`, `pelajaran`.`nama` AS `mapel`, `dasarpenilaian`.`keterangan` AS `keterangan`, `nap`.`nilaiangka` AS `nilaiangka`, `nap`.`nilaihuruf` AS `nilaihuruf`, `nap`.`komentar` AS `komentar` from (((((((((`nap` join `infonap` on ((`nap`.`idinfo` = `infonap`.`replid`))) join `aturannhb` on ((`nap`.`idaturan` = `aturannhb`.`replid`))) join `pelajaran` on ((`aturannhb`.`idpelajaran` = `pelajaran`.`replid`))) join `semester` on ((`infonap`.`idsemester` = `semester`.`replid`))) join

Cara redirect ke https

PHP

Untuk redirect http ke https tambahkan baris dibawah ini kedalam file .htaccess RewriteEngine On RewriteCond %{HTTPS} off RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI}  

Mengubah Baris Ke Kolom di Mysql

Mysql

select `tabel1`.`nip` AS `nip`, date_format(`tabel1`.`tgl`, ‘%d-%m-%Y’) AS `tanggal`, year (`tabel1`.`tgl`) AS `tahun`, (case when (month (`tabel1`.`tgl`) < 4) then ‘p1’ when (month (`tabel1`.`tgl`) < 7) then ‘p2’ when (month (`tabel1`.`tgl`) < 10) then ‘p3’ when (month (`tabel1`.`tgl`) < 13) then ‘p4’ end) AS `periode`, max((case when (`tabel1`.`no` = 1) then `tabel1`.`nilai` end)) AS `s1`, max((case