public function importData()
{
$siswas = Siswa::all();
foreach ($siswas as $siswa) {
ini_set('max_execution_time', 300);
$student = new Student();
$student->name = $siswa->FullName;
if ($siswa->Sex == 'MALE') {
$student->sex = 'L';
$student->photo = 'boy.png';
} else {
$student->sex = 'P';
$student->photo = 'girl.png';
}
$student->birthplace = $siswa->BirthPlace;
$student->birthdate = $siswa->BirthDate;
$student->religion = $siswa->Religion;
$student->address = $siswa->FullAddress;
$student->contact = $siswa->CellPhone;
$student->father_name = $siswa->FatherName;
$student->father_occupation = $siswa->FatherOccupation;
$student->father_address = $siswa->FatherAddress;
$student->father_contact = $siswa->FatherContact;
$student->mother_name = $siswa->MotherName;
$student->mother_occupation = $siswa->MotherOccupation;
$student->mother_address = $siswa->MotherAddress;
$student->mother_contact = $siswa->MotherContact;
$student->save();
}
Session::flash('message', 'Sukses mengimport Data Siswa');
return Redirect::to('/');
}
public function getRubah($id)
{
// data
$buku = Buku::data();
$siswa = Siswa::data();
$pinjam = Peminjaman::set($id);
return View::make('modal.rubah_peminjaman', compact('buku', 'siswa', 'pinjam'));
}
public function ambilSemuaSiswaDenganKelas()
{
$ps = $this->connection->prepare("SELECT siswa.nomor_siswa,siswa.nama as namaSiswa,kelas.id_kelas,kelas.nama as namaKelas\n\t\t\tFROM siswa INNER JOIN kelas on(siswa.id_kelas=kelas.id_kelas)\n ORDER BY namaKelas,namaSiswa");
$ps->execute();
$rs = $ps->fetchAll();
$siswas = new ArrayObject();
foreach ($rs as $s) {
$siswa = new Siswa();
$kelas = new Kelas();
$siswa->setNomorSiswa($s["nomor_siswa"]);
$siswa->setNama($s['namaSiswa']);
$kelas->setIdKelas($s["id_kelas"]);
$kelas->setNama($s["namaKelas"]);
$siswa->setKelas($kelas);
$siswas->append($siswa);
}
return $siswas;
}
<?php
class Siswa
{
private $nama;
private $alamat;
public function setNama($val)
{
$this->nama = $val;
}
public function getNama()
{
return $this->nama;
}
public function setAlamat($val)
{
$this->alamat = $val;
}
public function getAlamat()
{
return $this->alamat;
}
}
$siswa = new Siswa();
$siswa->setNama("Beni");
$siswa->setAlamat("Bandung");
echo "Siswa " . $siswa->getNama() . " tinggal di " . $siswa->getAlamat() . "\n";
public function update_profile()
{
$siswa = Siswa::find(Input::get('nis'));
$siswa->nm_siswa = Input::get('nama');
$siswa->tmp_lahir = Input::get('tempat');
$siswa->tgl_lahir = date('Y-m-d', strtotime(Input::get('tanggal')));
$siswa->nm_ayah = Input::get('ayah');
$siswa->nm_ibu = Input::get('ibu');
$siswa->alamat = Input::get('alamat');
$siswa->thn_sttb = Input::get('tahun');
if (Input::hasFile('foto')) {
$file = Input::file('foto');
$filename = str_random(5) . '-' . $file->getClientOriginalName();
$destinationPath = 'uploads/siswa/';
$file->move($destinationPath, $filename);
//$siswa->foto=$filename;
if ($siswa->foto) {
$fotolama = $siswa->foto;
$filepath = public_path() . DIRECTORY_SEPARATOR . 'uploads/siswa' . DIRECTORY_SEPARATOR . $siswa->foto;
try {
File::delete($filepath);
} catch (FileNotFoundException $e) {
}
}
$siswa->foto = $filename;
}
$siswa->save();
Session::flash('pesan', "<div class='alert alert-info'>\n Data Berhasil diupdate</div>");
return Redirect::back();
}
<?php
require_once 'lib/view.php';
require_once 'models/m_siswa.php';
require_once 'models/m_nationality.php';
$siswa = new Siswa();
$nat = new Nationality();
$id = $_GET['id'];
if (!empty($id)) {
$siswa->deleteSiswa($id);
$success = "Data Berhasil di Hapus";
}
$data['title'] = "Students";
$data['page'] = "v_siswa.php";
$data['siswa'] = $siswa->readAllSiswa();
$data['nat'] = $nat->readAllNationality();
require_once View::getView('dashboard.php', $data);
/**
* 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 = Siswa::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<?php
require_once 'lib/view.php';
require_once 'models/m_siswa.php';
require_once 'models/m_nationality.php';
$siswa = new Siswa();
$nat = new Nationality();
$data['title'] = "Edit Student";
$data['page'] = "v_edit_siswa.php";
$data['nat'] = $nat->readAllNationality();
$id = $_GET['id'];
$s = $siswa->readSiswa($id);
if (!empty($_POST)) {
$fn = $_FILES['input_file'];
$ff = 'img/' . date('YmdHis') . '.jpg';
copy($fn['tmp_name'], $ff);
$_POST['foto'] = $ff;
$siswa->updateSiswa($id, $_POST);
$success = "Data Berhasil di Update";
}
$data['st'] = $s[0];
require_once View::getView('dashboard.php', $data);
public static function hapus($id)
{
Siswa::destroy($id);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$siswa = Siswa::find($id);
$cek = DB::table('siswa_rombel')->where('nis', '=', $siswa->nis)->count();
$harian = DB::table('nilai_harian')->where('nis', '=', $siswa->nis)->count();
$ujian = DB::table('nilai_ujian')->where('nis', '=', $siswa->nis)->count();
if ($cek > 0 && $harian > 0 && $ujian > 0) {
$html = "<div class='alert alert-danger'>Data tidak dapat dihapus\n\t\t\tkarena ada relasi dengan tabel lain</div>";
Session::flash('pesan', $html);
return Redirect::back();
} else {
if ($cek > 0) {
$html = "<hr><div class='alert alert-danger'>Data Gagal dihapus\n\t\t\tkarena masih memiliki relasi dengan data rombel<ul>";
$rombel = DB::table('siswa_rombel')->where('nis', '=', $id)->get();
foreach ($rombel as $row) {
$html .= "<li>" . $row->kd_rombel . "</li>";
}
$html .= "</ul></div>";
Session::flash('pesan', $html);
return Redirect::back();
} else {
if ($harian > 0) {
$html = "<hr><div class='alert alert-danger'>Data Gagal dihapus\n\t\t\tkarena masih memiliki relasi dengan data nilai harian</div>";
Session::flash('pesan', $html);
return Redirect::back();
} else {
if ($ujian > 0) {
$html = "<hr><div class='alert alert-danger'>Data Gagal dihapus\n\t\t\tkarena masih memiliki relasi dengan data nilai ujian</div>";
Session::flash('pesan', $html);
return Redirect::back();
} else {
$siswa = Siswa::find($id);
if ($siswa->foto) {
$fotolama = $siswa->foto;
$filepath = public_path() . DIRECTORY_SEPARATOR . 'uploads/siswa' . DIRECTORY_SEPARATOR . $siswa->foto;
try {
File::delete($filepath);
} catch (FileNotFoundException $e) {
}
}
$siswa->delete();
Session::flash('pesan', "<hr><div class='alert alert-info'>Data Siswa\n\t\t\t\tBerhasil dihapus</div>");
return Redirect::back();
}
}
}
}
}
<?php
require_once 'models/Siswa.php';
$peg = new Siswa();
$data = $peg->getSiswa();
echo '<pre>';
print_r($data);
$update = array('full_name' => 'Surya s', 'email' => 'surya.s@amikom');
echo '</pre>';
<?php
include_once '../service/SiswaServiceImpl.php';
include_once '../entity/Siswa.php';
include_once '../service/KelasServiceImpl.php';
$perintah = $_POST["perintah"];
$siswa = new Siswa();
$kelasService = new KelasServiceImpl();
$siswaService = new SiswaServiceImpl();
if ($perintah == "simpan") {
$nama = $_POST["nama"];
$idKelas = $_POST["kelas"];
$kelasObj = $kelasService->ambilKelas($idKelas);
$siswa->setNama($nama);
$siswa->setKelas($kelasObj);
$siswaService->simpanSiswa($siswa);
} elseif ($perintah == "ubah") {
$nama = $_POST["nama"];
$idKelas = $_POST["kelas"];
$nomorSiswa = $_POST["nomorSiswa"];
$kelasObj = $kelasService->ambilKelas($idKelas);
$siswa->setNomorSiswa($nomorSiswa);
$siswa->setNama($nama);
$siswa->setKelas($kelasObj);
$siswaService->ubahSiswa($siswa);
} elseif ($perintah == "hapus") {
$nomorSiswa = $_POST["nomorSiswa"];
$siswaService->hapusSiswa($nomorSiswa);
}
public function get_siswa()
{
if (Request::ajax()) {
$nis = Input::get('nis');
$siswa = Siswa::find($nis);
echo $siswa->nm_siswa . "|" . $siswa->jk;
}
}
public function excel()
{
// data
$sekolah = Sekolah::data();
$siswa = Siswa::semua();
return View::make('excel.siswa', compact('sekolah', 'siswa'));
}
<?php
require_once 'lib/view.php';
require_once 'models/m_siswa.php';
require_once 'models/m_nationality.php';
$siswa = new Siswa();
$nat = new Nationality();
$data['title'] = "Import Students";
$data['page'] = "v_insiswa.php";
if (!empty($_FILES)) {
$f = $_FILES['input_csv'];
copy($f['tmp_name'], 'tmp.csv');
$fo = fopen('tmp.csv', 'r');
$i = 1;
while ($read = fgetcsv($fo)) {
$siswa->createSiswa($read[0], $read[1], $read[2], $read[3], '');
$i++;
}
$data['num'] = $i;
}
require_once View::getView('dashboard.php', $data);
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
//
$Siswas = Siswa::getAll();
}
<?php
require_once 'lib/view.php';
require_once 'models/m_siswa.php';
require_once 'models/m_nationality.php';
$siswa = new Siswa();
$nat = new Nationality();
$data['title'] = "Students";
$data['page'] = "v_siswa.php";
if (!empty($_POST)) {
$nis = $_POST['input_nis'];
$name = $_POST['input_name'];
$email = $_POST['input_email'];
$id_nat = $_POST['input_nationality'];
$fn = $_FILES['input_file'];
$ff = 'img/' . date('YmdHis') . '.jpg';
copy($fn['tmp_name'], $ff);
$siswa->createSiswa($id_nat, $nis, $name, $email, $ff);
$success = "Data Berhasil di Tambahkan";
}
$data['siswa'] = $siswa->readAllSiswa();
$data['nat'] = $nat->readAllNationality();
require_once View::getView('dashboard.php', $data);
<th>nis</th>
<th>NAMA</th>
<th>NILAI AKHIR</th>
<th>UJIAN NASIONAL</th>
<th>UJIAN SEKOLAH</th>
</tr>
</thead>
<tbody>
<?php
/*$siswa=Siswa::model()->findAll(array(
//SELECT * FROM "siswa" WHERE kelas = '2' and lokal = 'B'
//'index'=>'nis',
'select'=>'*',
'condition'=>"kelas='".$pgi['kelas']."' or lokal='".$pgi['lokal']."'",
));*/
$siswa = Siswa::model()->with(array('nis0' => array('joinType' => 'INNER JOIN', 'condition' => "kelas='" . $pgi['kelas'] . "' or lokal='" . $pgi['lokal'] . "'")))->findAll();
foreach ($siswa as $i => $ii) {
?>
<?php
echo $form->hiddenField($model, "[{$i}]lokal");
?>
<?php
echo $form->hiddenField($model, "[{$i}]kelas");
?>
<?php
echo $form->hiddenField($model, "[{$i}]nis", array('value' => $ii['nis']));
?>
<tr>
<td><?php
echo $ii['nis'];
