public function loadMJGuruSelection($ta)
{
$guru_id = addslashes($_GET["guru_id"]);
$mp_id = addslashes($_GET["mp_id"]);
$kelas_id = addslashes($_GET["kelas_id"]);
$load = addslashes($_GET["load"]);
//load guru aktiv
$guru = new Guru();
$arrGuru = $guru->getWhere("guru_aktiv = 1 ORDER BY nama_depan ASC", "guru_id,nama_depan");
//define the ID's'
$id = Guru::createMjId($mp_id, $kelas_id, $ta);
$loadid = time() . "__" . $mp_id . "_" . $kelas_id;
if ($load) {
global $db;
$q = "SELECT * FROM {$this->table_mengajar} WHERE mengajar_id = '{$id}'";
$mj = $db->query($q, 1);
$return['mj'] = $mj;
}
//create returns
$return['mj_id'] = $id;
$return['loadid'] = $loadid;
$return['arrGuru'] = $arrGuru;
$return['posts'] = $_GET;
return $return;
}
public function myHomeroomTeacher()
{
$ta = TahunAjaran::ta();
$kelas = Account::getMyKelas($ta);
$guru = new Guru();
$row = $guru->getHomeroomFromKelas($ta, $kelas->kelas_id);
$guru->fill(toRow($row));
//pr($guru);
Mold::both("leap/homeroom_widget", array("guru" => $guru, "kelas" => $kelas));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$rombel = Rombel::find($id);
$kelas = Kelas::all();
$guru = Guru::all();
return View::make('rombel.edit')->with('rombel', $rombel)->with('kelas', $kelas)->with('guru', $guru);
}
public function n_harian()
{
$kelas = Kelas::all();
$tahun = DB::table('rombel')->groupBy('thn_ajaran')->get();
$mapel = Mapel::all();
$guru = Guru::all();
return View::make('laporan.harian')->with('kelas', $kelas)->with('tahun', $tahun)->with('mapel', $mapel)->with('guru', $guru);
}
public function get_guru()
{
if (Request::ajax()) {
$nip = Input::get('nip');
$guru = Guru::find($nip);
return $guru->nm_guru;
}
}
public function data_guru()
{
$guru = Guru::all();
return View::make('web.guru')->with('guru', $guru);
}
public function compose()
{
$kelas = new Kelas();
$arrKelas = $kelas->getWhere("kelas_aktiv = 1 ORDER BY kelas_id ASC", "kelas_id,kelas_name");
$guru = new Guru();
$arrGuru = $guru->getWhere("guru_aktiv = 1 ORDER BY nama_depan ASC", "guru_id,account_id,nama_depan");
$supervisor = new Supervisor();
$arrSupervisor = $supervisor->getWhere("supervisor_aktiv = 1 ORDER BY nama_depan ASC", "supervisor_id,account_id,nama_depan");
$tatausaha = new Tatausaha();
$arrTU = $tatausaha->getWhere("tu_aktiv = 1 ORDER BY nama_depan ASC", "tu_aktiv,account_id,nama_depan");
$admin = new Admin();
$arrAdmin = $admin->getWhere("sys_aktiv = 1 ORDER BY nama_depan ASC", "sys_id,account_id,nama_depan");
$t = time();
$return['arrTU'] = $arrTU;
$return['arrSupervisor'] = $arrSupervisor;
$return['arrAdmin'] = $arrAdmin;
$return['arrGuru'] = $arrGuru;
$return['arrKelas'] = $arrKelas;
$return['method'] = __FUNCTION__;
$return['webClass'] = __CLASS__;
$return['byID'] = 0;
Mold::both("inbox/compose", $return);
}
public function browseStaff()
{
$guru = new Guru();
$arrGuru = $guru->getWhere("guru_aktiv = 1 ORDER BY nama_depan ASC", "guru_id,account_id,nama_depan,foto");
$supervisor = new Supervisor();
$arrSupervisor = $supervisor->getWhere("supervisor_aktiv = 1 ORDER BY nama_depan ASC", "supervisor_id,account_id,nama_depan,foto");
$tatausaha = new Tatausaha();
$arrTU = $tatausaha->getWhere("tu_aktiv = 1 ORDER BY nama_depan ASC", "tu_aktiv,account_id,nama_depan,foto");
$admin = new Admin();
$arrAdmin = $admin->getWhere("sys_aktiv = 1 ORDER BY nama_depan ASC", "sys_id,account_id,nama_depan,foto");
$t = time();
$return['arrTU'] = $arrTU;
$return['arrSupervisor'] = $arrSupervisor;
$return['arrAdmin'] = $arrAdmin;
$return['arrGuru'] = $arrGuru;
$return['method'] = __FUNCTION__;
$return['webClass'] = __CLASS__;
Mold::both("leap/browseStaff", $return);
}
public function update_profile()
{
$guru = Guru::find(Sentry::getUser()->username);
$guru->nuptk = Input::get('nuptk');
$guru->nm_guru = Input::get('nama');
$guru->tmp_lahir = Input::get('tempat');
$guru->tgl_lahir = Input::get('tanggal');
$guru->pend_terakhir = Input::get('pend');
if (Input::hasFile('foto')) {
$file = Input::file('foto');
$filename = str_random(5) . '-' . $file->getClientOriginalName();
$destinationPath = 'uploads/guru/';
$file->move($destinationPath, $filename);
if ($guru->foto) {
$fotolama = $guru->foto;
$filepath = public_path() . DIRECTORY_SEPARATOR . 'uploads/guru' . DIRECTORY_SEPARATOR . $guru->foto;
try {
File::delete($filepath);
} catch (FileNotFoundException $e) {
}
}
$guru->foto = $filename;
}
$guru->save();
Session::flash('pesan', "<div class='alert alert-success'>\n Data Berhasil diupdate</div>");
return Redirect::back();
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$rombel = DB::table('rombel')->where('id_wali', '=', $id)->count();
$mengajar = DB::table('mengajar')->where('id_guru', '=', $id)->count();
if ($rombel > 0 && $mengajar > 0) {
$html = "<hr><div class='alert alert-danger'>Data Guru masih ada relasi \n\t\t\tdengan Data Rombel dan Data Mengajar</div>";
} else {
if ($rombel > 0) {
$html = "<hr><div class='alert alert-danger'>Data Guru tidak dapat dihapus\n\t\t\tkarena Masih ada relasi dengan\n\t\t\tdata Rombel <ul>";
$data = DB::table('rombel')->where('id_wali', '=', $id)->get();
foreach ($data as $row) {
$html .= "<li>" . $row->kd_rombel . "</li>";
}
$html .= "</ul></div>";
Session::flash('pesan', $html);
return Redirect::back();
} else {
if ($mengajar > 0) {
$html = "<hr><div class='alert alert-danger'>Data Guru tidak dapat dihapus\n\t\t\tkarena Masih ada relasi dengan\n\t\t\tdata Mengajar <ul>";
$data = DB::table('mengajar')->where('id_guru', '=', $id)->get();
foreach ($data as $row) {
$html .= "<li>" . $row->id_mengajar . "</li>";
}
$html .= "</ul></div>";
Session::flash('pesan', $html);
return Redirect::back();
} else {
$guru = Guru::find($id);
if ($guru->foto) {
$fotolama = $guru->foto;
$filepath = public_path() . DIRECTORY_SEPARATOR . 'uploads/guru' . DIRECTORY_SEPARATOR . $guru->foto;
try {
File::delete($filepath);
} catch (FileNotFoundException $e) {
}
}
$guru->delete();
return Redirect::to('admin/guru')->with('pesan', "<hr><div class='alert alert-info'>Data Berhasil dihapus</div>");
}
}
}
}
/**
* 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 = Guru::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<?php
$ruang = CHtml::listData(Ruangan::model()->findAll(array('order' => 'namaruang ASC', 'distinct' => true)), 'idruang', 'namaruang');
?>
<?php
echo $form->dropDownListRow($model, 'idruang', $ruang, array('empty' => '- PILIH RUANG -', 'id' => 'idruang'));
?>
<?php
echo $form->textFieldRow($model, 'idwaktu', array('hint' => 'Silahkan klik tombol <a href="#" onclick=$("#twaktu").dialog("open");
return false; class="btn submit">+</a> untuk melihat daftar waktu.'));
?>
<?php
echo $form->dropDownListRow($model, 'kode_guru', CHtml::listData(Guru::model()->findAll(), 'kode_guru', 'nama_guru'), array('empty' => '- PILIH GURU -'));
?>
<?php
echo $form->textFieldRow($model, 'kode_mapel', array('hint' => 'Silahkan klik tombol <a href="#" onclick=$("#tmapel").dialog("open");
return false; class="btn submit">+</a> untuk melihat daftar mapel.'));
?>
<?php
echo $form->hiddenField($model, 'kode_mapel', array());
?>
<?php
echo $form->textFieldRow($model, 'kelas', array());
?>
