public function actionCreate()
{
$Orang = new Orang();
$Mahasiswa = new Mahasiswa();
$MhsDoktor = new MhsDoktor();
// Uncomment the following line if AJAX validation is needed
$this->performAjaxValidation(array($Orang, $MhsDoktor));
//$this->performAjaxValidation($MhsDoktor);
if (isset($_POST['Orang'], $_POST['MhsDoktor'])) {
$Orang->attributes = $_POST['Orang'];
$MhsDoktor->attributes = $_POST['MhsDoktor'];
//validate both
$valid = $Orang->validate();
$valid = $MhsDoktor->validate() && $valid;
if ($valid) {
//use false param to disabel validation
$Orang->save(false);
$Mahasiswa->ID = $Orang->ID;
$Mahasiswa->save(false);
$MhsDoktor->ID = $Mahasiswa->ID;
$MhsDoktor->save(false);
//redirect
//die("Sukses nyimpan");
$this->redirect(array('view', 'id' => $Orang->ID));
}
}
$this->render('create', array('Orang' => $Orang, 'MhsDoktor' => $MhsDoktor));
}
public function actionImport()
{
$field = ['fileImport' => 'File Import'];
$modelImport = DynamicModel::validateData($field, [[['fileImport'], 'required'], [['fileImport'], 'file', 'extensions' => 'xls,xlsx', 'maxSize' => 1024 * 1024]]);
if (Yii::$app->request->post()) {
$modelImport->fileImport = \yii\web\UploadedFile::getInstance($modelImport, 'fileImport');
if ($modelImport->fileImport && $modelImport->validate()) {
$inputFileType = \PHPExcel_IOFactory::identify($modelImport->fileImport->tempName);
$objReader = \PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($modelImport->fileImport->tempName);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
$baseRow = 2;
while (!empty($sheetData[$baseRow]['A'])) {
$model = new Mahasiswa();
$model->nama = (string) $sheetData[$baseRow]['B'];
$model->nim = (string) $sheetData[$baseRow]['C'];
$model->save();
//die(print_r($model->errors));
$baseRow++;
}
Yii::$app->getSession()->setFlash('success', 'Success');
} else {
Yii::$app->getSession()->setFlash('error', 'Error');
}
}
return $this->redirect(['index']);
}
function Processrequest()
{
$ObjMahasiswa = new Mahasiswa();
$idMahasiswa = Dispatcher::Instance()->Encrypt($_GET['idMahasiswa']->Raw());
if (!empty($idMahasiswa)) {
$return['dataMahasiswa'] = $ObjMahasiswa->GetMahasiswaById($idMahasiswa);
}
$return['ID_MHS'] = $idMahasiswa;
return $return;
}
function ProcessRequest()
{
$msg = Messenger::Instance()->Receive(__FILE__);
if ($msg) {
$return['pesan'] = $msg[0][1];
$return['css'] = $msg[0][2];
} else {
$return['pesan'] = null;
$return['css'] = null;
}
$Obj = new Mahasiswa();
$return['dataMahasiswa'] = $Obj->GetListMahasiswa();
return $return;
}
function ProcessRequest()
{
$msg = Messenger::Instance()->Receive(__FILE__);
$Obj = new Mahasiswa();
$filter_data = !empty($msg[0][0]) ? $msg[0][0] : NULL;
$message['content'] = !empty($msg[0][1]) ? $msg[0][1] : NULL;
$message['style'] = !empty($msg[0][2]) ? $msg[0][2] : NULL;
$view_per_page = Configuration::Instance()->GetValue('application', 'paging_limit');
$view_per_page = 10;
if (!isset($_GET['display']) || empty($filter_data)) {
$page = 1;
$start = 0;
$display = $view_per_page;
$filter = compact('page', 'display', 'start');
} elseif ($_GET['display']->Raw() != '') {
$page = (int) $_GET['page']->SqlString()->Raw();
$display = (int) $_GET['display']->SqlString()->Raw();
if ($page < 1) {
$page = 1;
}
if ($display < 1) {
$display = $view_per_page;
}
$start = ($page - 1) * $display;
$filter = compact('page', 'display', 'start');
$filter += $filter_data;
} else {
$filter = $filter_data;
$page = $filter['page'];
$display = $filter['display'];
$start = $filter['start'];
}
$post_data = $_POST->AsArray();
if (!empty($post_data)) {
foreach ($post_data as $key => $value) {
$filter[$key] = $value;
}
}
Messenger::Instance()->Send(Dispatcher::Instance()->mModule, Dispatcher::Instance()->mSubModule, Dispatcher::Instance()->mAction, Dispatcher::Instance()->mType, array($filter), Messenger::UntilFetched);
$data = $Obj->getData($filter);
$total = $Obj->countData();
$url = Dispatcher::Instance()->GetUrl(Dispatcher::Instance()->mModule, Dispatcher::Instance()->mSubModule, Dispatcher::Instance()->mAction, Dispatcher::Instance()->mType) . '&display=' . $view_per_page;
Messenger::Instance()->SendToComponent('paging', 'Paging', 'view', 'html', 'paging_top', array($display, $total, $url, $page), Messenger::CurrentRequest);
return compact('data', 'filter', 'message');
}
function ProcessRequest()
{
$Obj = new Mahasiswa();
$totalData = $Obj->GetCountMahasiswa();
$itemViewed = 5;
$currPage = 1;
$startRec = 0;
if (isset($_GET['page'])) {
$currPage = (string) $_GET['page']->StripHtmlTags()->SqlString()->Raw();
$startRec = ($currPage - 1) * $itemViewed;
}
$return['dataMahasiswa'] = $Obj->GetListMahasiswa($startRec, $itemViewed);
$url = Dispatcher::Instance()->GetUrl(Dispatcher::Instance()->mModule, Dispatcher::Instance()->mSubModule, Dispatcher::Instance()->mAction, Dispatcher::Instance()->mType);
$destination_id = "subcontent-element";
Messenger::Instance()->SendToComponent('paging', 'Paging', 'view', 'html', 'paging_top', array($itemViewed, $totalData, $url, $currPage, $destination_id), Messenger::CurrentRequest);
$return['start_number'] = $startRec + 1;
return $return;
}
public function run()
{
DB::table('mahasiswa')->delete();
DB::table('wali')->delete();
DB::table('dosen')->delete();
$darwis = Dosen::create(array('nama' => 'Darwis', 'nip' => '12321310'));
$nabil = Mahasiswa::create(array('nama' => 'Nabil Farras', 'nim' => '1103124323', 'id_dosen' => $darwis->id));
$dani = Mahasiswa::create(array('nama' => 'Dani Firdaus', 'nim' => '11031202323', 'id_dosen' => $darwis->id));
$this->command->info('Mahasiswa telah diisi!');
Wali::create(array('nama' => 'Darto', 'id_mahasiswa' => $nabil->id));
Wali::create(array('nama' => 'Iman', 'id_mahasiswa' => $dani->id));
}
public function actionInsert()
{
$mahasiswa = Mahasiswa::model()->findAll();
$i = 17;
foreach ($mahasiswa as $value) {
$user = new User();
$user->id_user = $i;
$user->username = $value->NIM;
$user->password = md5($value->NIM);
$user->Level = 'mahasiswa';
$user->status = '1';
$user->save();
$i++;
}
}
public function actionDetailview()
{
$this->load();
$peserta = PesertaPkli::model()->findAllByAttributes(array('Id_program' => $_GET['id']));
$i = 0;
foreach ($peserta as $mahasiswa) {
$value = Mahasiswa::model()->findByAttributes(array('NIM' => $mahasiswa->NIM));
$result[$i]['nim'] = $value->NIM;
$result[$i]['nama'] = $value->Nama_lengkap;
$result[$i]['alamat'] = $value->Alamat_dmalang;
$result[$i]['telp'] = $value->No_tlp;
$result[$i]['email'] = $value->Email;
$i++;
}
echo json_encode($result);
}
function ubahdataMahasiswa($nimAwal, $nim, $nama, $alamat, $tempat_lahir, $tanggal_lahir, $fakultas, $jurusan, $agama)
{
$mahasiswa = new Mahasiswa();
return $mahasiswa->ubahdataMahasiswa($nimAwal, $nim, $nama, $alamat, $tempat_lahir, $tanggal_lahir, $fakultas, $jurusan, $agama);
}
$app->get('/halo(/:nama)', function ($nama = null) {
echo "Hallo " . $nama . "!";
});
$app->get('/home(/:nama)', function ($nama = null) use($app) {
$app->view()->appendData(array('nama' => $nama));
$app->render("home.php");
});
$app->get('/show', function () use($app) {
// with activerecord
// $data = Mahasiswa::all();
// echo json_encode(array_map(function($res){
// return $res->to_array();
// },$data));
//
// with elequent
echo Mahasiswa::all()->toJson();
});
$app->post('/insert', function () use($app) {
$mhs = new Mahasiswa();
$mhs->nama = $app->request->post('nama');
echo $mhs->save();
});
$app->put('/update/:kode', function ($kode) use($app) {
$mhs = Mahasiswa::find($kode);
$mhs->nama = $app->request->put('nama');
echo $mhs->save();
});
$app->delete('hapus/:kode', function ($kode) use($app) {
echo Mahasiswa::find($kode)->delete();
});
$app->run();
include "../library/fungsi-class.php";
?>
<!DOCTYPE html>
<html>
<head>
<title>Latihan Fungsi dan Object Oriented dalam PHP</title>
</head>
<body>
<h1><?php
echo tampilNama("Fahri");
?>
</h1>
<p>Hasil penjumlahan dari 5 dan 9 adalah <?php
echo 50 - tambah(5, 9);
?>
</p>
<h3><?php
pangkat(7, 9);
?>
</h3>
<br>
<?php
$mhs = new Mahasiswa();
$mhs->printInfo();
echo "<br />";
$mhs->initialize("A12345", "Ingsun", 3.9);
$mhs->printInfo();
?>
</body>
</html>
function ProcessRequest()
{
$Obj = new Mahasiswa();
$return['dataMahasiswa'] = $Obj->GetListMahasiswa();
return $return;
}
public function load()
{
if (Yii::app()->user->isGuest) {
$this->redirect(Yii::app()->request->baseUrl);
}
$this->identitas = Mahasiswa::model()->findByPk(Yii::app()->user->id);
date_default_timezone_set("Asia/Jakarta");
}
<?php
include "../db/mahasiswa.php";
// query statis
$mhs = new Mahasiswa();
$data = $mhs->getAllMhs();
echo '<table border="1" width="500">';
foreach ($data as $row) {
echo '<tr><td>' . $row['nim'] . ' </td><td> ' . $row['nama'] . '</td></tr>';
}
echo '</table>';
<title></title>
</head>
<body>
<?php
class Mahasiswa
{
public $nama;
public $kelas;
public $usia;
function __construct()
{
}
function biodata($nama, $kelas, $usia)
{
$this->nama = $nama;
$this->kelas = $kelas;
$this->usia = $usia;
echo $nama . "<br/>";
echo $kelas . "<br/>";
echo $usia . "<br/>";
}
function __destruct()
{
}
}
$mahasiswa = new Mahasiswa();
$mahasiswa->biodata("Iwan Bagus S", "VII", 7);
?>
</body>
</html>
public function actionNilai()
{
$mahasiswa = Mahasiswa::model()->findAll();
$error = false;
foreach ($mahasiswa as $mhs) {
if (isset($_POST[$mhs->NIM])) {
foreach ($_POST[$mhs->NIM] as $mk => $value) {
$nilai = Nilai::model()->findByAttributes(array('NIM' => $mhs->NIM, 'kode_mk' => $mk));
if ($nilai) {
$input = $nilai;
} else {
$input = new Nilai();
$input->NIM = $mhs->NIM;
$input->kode_mk = $mk;
}
$input->Nilai = $value;
if (!$input->save()) {
$error = true;
}
}
}
if (!$error) {
Yii::app()->user->setFlash('status', '<div class="alert alert-success">Data telah Tersimpan</div>');
} else {
Yii::app()->user->setFlash('status', '<div class="alert alert-success">Data Gagal Tersimpan</div>');
}
}
$this->render('nilai', array('mahasiswa' => $mahasiswa));
}
<th>Tgl Awal</th>
<th>Tgl Akhir</th>
<th>Keterangan</th>
</tr>
</thead>
<tbody>
<?php
foreach ($laporan as $list) {
?>
<tr>
<td><?php
echo $list->NIM;
?>
</td>
<td><?php
$mahasiswa = Mahasiswa::model()->findByAttributes(array('NIM' => $list->NIM));
echo $mahasiswa->Nama_lengkap;
?>
</td>
<td><?php
$programpkli = ProgramPkli::model()->findByAttributes(array('Id_program_pkli' => $list->Id_program));
$instansi = Instansi::model()->findByAttributes(array('Id_instansi' => $programpkli->Id_instansi));
echo $instansi->Nama_instansi;
?>
</td>
<td><?php
$programpkli = ProgramPkli::model()->findByAttributes(array('Id_program_pkli' => $list->Id_program));
echo $ahli[$programpkli->Bidang_Keahlian];
?>
</td>
<td><?php
<?php
include "mahasiswa.php";
// $ssql = $db->prepare("INSERT INTO mahasiswa VALUES (?, ?, ?, ?)");
// $ssql->execute( array('A11.2015.01234', 'Andi', 'Semarang', 3.7) );
// $ssql->execute( array('A11.2015.02345', 'Anton', 'Jepara', 3.4) );
// $ssql->execute( array('A11.2015.03456', 'Nisa', 'Jakarta', 3.9) );
// $ssql->execute( array('A11.2015.04567', 'Linda', 'Surabaya', 3.3) );
// echo "eksekusi input berhasil";
// query statis
$mhs = new Mahasiswa();
$data = $mhs->getAllMhs();
echo '<ol>';
foreach ($data as $row) {
echo '<li>' . $row['nim'] . ' - ' . $row['nama'] . '</li>';
}
echo '</ol>';
$mhs->addMhs('A11.2015.07890', 'Rendi', 'Papua', 3.1);
$mhs->addMhs('A11.2015.07892', 'Rere', 'Sumatra');
<?php
/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It's a breeze. Simply tell Laravel the URIs it should respond to
| and give it the Closure to execute when that URI is requested.
|
*/
Route::get('/', function () {
return View::make('hello');
});
Route::get('relasi-one', function () {
$mahasiswa = Mahasiswa::where('nim', '=', '1103124323')->first();
return $mahasiswa->wali->nama;
});
Route::get('relasi-Onemany1', function () {
$mahasiswa = Mahasiswa::where('nim', '=', '1103124323')->first();
return $mahasiswa->dosen->nama;
});
Route::get('relasi-Onemany2', function () {
$dosen = Dosen::where('nama', '=', 'Darwis')->first();
foreach ($dosen->mahasiswa as $temp) {
echo '<li> Nama : ' . $temp->nama . ' <strong>' . $temp->nim . '</strong></li>';
}
});
