/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$Orang = new Orang();
$KontakOrang = new KontakOrang();
$Pegawai = new Pegawai();
$JenisPegawai = new JenisPegawai();
$Dosen = new Dosen();
// Uncomment the following line if AJAX validation is needed
$this->performAjaxValidation(array($Orang, $KontakOrang, $Pegawai, $Dosen));
if (isset($_POST['Orang'], $_POST['KontakOrang'], $_POST['Pegawai'], $_POST['Dosen'])) {
$Orang->attributes = $_POST['Orang'];
$KontakOrang->attributes = $_POST['KontakOrang'];
$Pegawai->attributes = $_POST['Pegawai'];
$Dosen->attributes = $_POST['Dosen'];
//validate
$valid = $Orang->validate();
$valid = $KontakOrang->validate() && $valid;
$valid = $Pegawai->validate() && $valid;
$valid = $Dosen->validate() && $valid;
if ($valid) {
$Orang->save(false);
$KontakOrang->OrangID = $Orang->ID;
$KontakOrang->save(false);
$Pegawai->ID = $Orang->ID;
$Pegawai->save(false);
$JenisPegawai->ID = $Pegawai->ID;
$JenisPegawai->save(false);
$Dosen->ID = $JenisPegawai->ID;
$Dosen->save(false);
//redirect
$this->redirect(array('view', 'id' => $Dosen->ID));
}
}
$this->render('create', array('Orang' => $Orang, 'KontakOrang' => $KontakOrang, 'Pegawai' => $Pegawai, 'Dosen' => $Dosen));
}
public function run()
{
DB::table('pegawai')->truncate();
$pegawai = new Pegawai();
$pegawai->Nama = 'Sufransyah SE.';
$pegawai->Npwp = '00.313.178.6-724.000';
$pegawai->NpwpDinas = '89.090.295.0-724.000';
$pegawai->NIP = '196711122007011019';
$pegawai->Alamat = 'Kawasan Pemerintahan bukit pelangi Sangatta';
$pegawai->Telepon = '08780292112';
$pegawai->Email = '*****@*****.**';
$pegawai->save();
$pegawai2 = new Pegawai();
$pegawai2->Nama = 'Yohana SE., MM.';
$pegawai2->NpwpDinas = '89.090.295.0-724.000';
$pegawai2->NIP = '196711122007011219';
$pegawai2->Alamat = 'Jl Pendidikan';
$pegawai2->Telepon = '081382831823';
$pegawai2->Email = '*****@*****.**';
$pegawai2->save();
$pegawai3 = new Pegawai();
$pegawai3->Nama = 'Ridwan';
$pegawai3->NpwpDinas = '89.090.295.0-724.000';
$pegawai3->NIP = '196711122006911019';
$pegawai3->Alamat = 'Jl Karya Etam';
$pegawai3->Telepon = '08780292112';
$pegawai3->Email = '*****@*****.**';
$pegawai3->save();
DB::table('users')->truncate();
$userX = new User();
$userX->username = '******';
$userX->id_pegawai = 1;
$userX->password = Hash::make(1234);
$userX->jenis_user = '******';
$userX->save();
$user2 = new User();
$user2->username = '******';
$user2->id_pegawai = 2;
$user2->password = Hash::make(1234);
$user2->jenis_user = '******';
$user2->save();
$user3 = new User();
$user3->username = '******';
$user3->id_pegawai = 3;
$user3->password = Hash::make(1234);
$user3->jenis_user = '******';
$user3->save();
// $user = new User;
// $user->username = '******';
// $user->password = Hash::make(1234);
// $user->email = '*****@*****.**';
// $user->jenis_user = '******';
// $user->nama_lengkap = 'Randa Wahyu Pradhana';
// $user->alamat = 'Jln Delima, Sangatta Kalimantan Timur';
// $user->telepon = '081391006092';
// $user->save();
}
public function actionIndex()
{
$model = new Pegawai('search');
$model->unsetAttributes();
// clear any default values
$_SESSION['lap_3_id_satuan_kerja'] = isset($_SESSION['lap_3_id_satuan_kerja']) ? $_SESSION['lap_3_id_satuan_kerja'] : 'Semua';
if (isset($_GET['Pegawai'])) {
$model->attributes = $_GET['Pegawai'];
$_SESSION['lap_3_id_satuan_kerja'] = isset($_GET['Pegawai']['id_satuan_kerja']) ? $_GET['Pegawai']['id_satuan_kerja'] : 'Semua';
}
$this->render('index', array('model' => $model));
}
public function add_task($tanggal = null)
{
$pegawai = new Pegawai($this->registry);
$this->view->date = $tanggal;
$this->view->pegawai = $pegawai->get();
if (isset($_POST['submit'])) {
$nomor = $_POST['nomor'];
$mulai = $_POST['mulai'];
$akhir = $_POST['akhir'];
$jam_mulai = $_POST['jam_mulai'] . ':' . $_POST['menit_mulai'] . ':00';
$jam_selesai = $_POST['jam_selesai'] . ':' . $_POST['menit_selesai'] . ':00';
$tujuan = $_POST['tujuan'];
$keperluan = $_POST['tentang'];
$peserta = $_POST['peserta'];
$d_mulai = strtotime($mulai);
$d_akhir = strtotime($akhir);
if ($nomor == '') {
$this->view->add_error('nomor', 'kolom nomor harus diisi!');
}
if ($tujuan == '') {
$this->view->add_error('tujuan', 'kolom daerah tujuan harus diisi!');
}
if ($keperluan == '') {
$this->view->add_error('tentang', 'kolom keperluan harus diisi!');
}
if ($d_mulai > $d_akhir) {
$this->view->add_error('tanggal', 'tanggal selesai tidak boleh sebelum tanggal mulai!');
}
if (!$this->view->is_error()) {
$data = array('nomor' => $nomor, 'tgl_mulai' => $mulai, 'tgl_selesai' => $akhir, 'jam_mulai' => $jam_mulai, 'jam_selesai' => $jam_selesai, 'tujuan' => $tujuan, 'uraian' => $keperluan);
$task = new Task($this->registry);
$task->add($data);
$id = $task->last_insert_id();
$p = new PesertaTask($this->registry);
$array = 0;
foreach ($peserta as $key => $value) {
$t_mulai = $_POST['pmulai'][$array] == '' ? $mulai : $_POST['pmulai'][$array];
$t_akhir = $_POST['pakhir'][$array] == '' ? $akhir : $_POST['pakhir'][$array];
$data = array('id_pegawai' => $value, 'id_task' => $id, 'tgl_mulai' => $t_mulai, 'tgl_selesai' => $t_akhir);
$p->add($data);
$array++;
}
$this->view->add_success('success', 'rekam data task/kegiatan berhasil!');
}
}
$this->view->aksi = 'add';
$this->view->render('wekdal/kalendar');
}
public function loadModel($id)
{
$model = Pegawai::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function indexx()
{
$nomedrec = Input::get('nomedrec');
$pegawai = Pegawai::where('IdPegawai', '=', '2')->first();
$pasien = Pasien2::where('id_pasien', 'LIKE', '%' . $nomedrec . '%')->paginate(10);
$pasiennama = Pasien2::where('nama', 'LIKE', '%' . $nomedrec . '%')->paginate(10);
$satuans = RegLab::orderBy('created_at', 'desc')->first();
return View::make('registrasi.index4_registrasi')->with('pasien', $pasien)->with('pegawai', $pegawai)->with('pasiennama', $pasiennama)->with('satuans', $satuans);
}
public function login()
{
if (isset($_POST['user'])) {
$user = $_POST['user'];
$pass = $_POST['pass'];
$pwd = Hash::create('sha1', $pass, HASH_SALT_KEY);
$cuser = new User($this->registry);
$res = $cuser->login($user, $pwd);
switch ($res[1]) {
case 1:
$role = 'admin';
break;
case 2:
$role = 'koordinator';
break;
case 3:
$role = 'inputer';
break;
default:
$role = 'guest';
}
if ((int) $res[0] == 1) {
$pegawai = new Pegawai($this->registry);
$data = $pegawai->get($res[3]);
Session::createSession();
Session::set('loggedin', TRUE);
Session::set('nama', $data[0]['nama']);
Session::set('user', $res[2]);
Session::set('role', $role);
Session::set('id_user', $res[4]);
header('location:' . URL);
} else {
if ((int) $res[0] == 0) {
$this->view->add_error('error', "user tidak ditemukan!");
$this->view->load('admin/login');
} else {
$this->view->add_error('error', "database tidak valid!");
$this->view->load('admin/login');
}
}
} else {
$this->view->load('admin/login');
}
}
public function run()
{
$criteria = new CDbCriteria();
$criteria->condition = 'id_pegawai = "' . $this->id_pegawai . '"';
$model = Pegawai::model()->find($criteria);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
echo $model->nama_pegawai;
}
public function EditBendahara()
{
$id = Input::get('id');
$input = array('Nama' => Input::get('Nama'), 'Npwp' => Input::get('NPWP2'), 'NpwpDinas' => Input::get('NPWP'), 'NIP' => Input::get('NIP'), 'Alamat' => Input::get('Alamat'), 'Telepon' => Input::get('Telepon'), 'Email' => Input::get('Email'));
$rules = array('NpwpDinas' => 'required|min:20|max:20', 'Nama' => 'required', 'NIP' => 'required|unique:pegawai,NIP,' . $id . ',id_pegawai', 'Alamat' => 'required', 'Telepon' => 'required', 'Email' => 'required|email', 'Npwp' => 'required|min:20|max:20|unique:pegawai,Npwp,' . $id . ',id_pegawai');
$messages = array('NpwpDinas.required' => 'Baris <b>NPWP</b> tidak boleh kosong.', 'NpwpDinas.min' => 'Baris <b>NPWP</b> harus 20 karakter.', 'NpwpDinas.max' => 'Baris <b>NPWP</b> harus 20 karakter.', 'Nama.required' => 'Baris <b>Nama</b> tidak boleh kosong.', 'NIP.required' => 'Baris <b>NIP</b> tidak boleh kosong.', 'NIP.unique' => 'NIP <b>' . Input::get('NIP') . '</b> sudah terdaftar', 'Alamat.required' => 'Baris <b>ALAMAT</b> tidak boleh kosong.', 'Telepon.required' => 'Baris <b>No. Telepon</b> tidak boleh kosong.', 'Email.required' => 'Baris <b>Email</b> tidak boleh kosong.', 'Email.email' => '<b>Email</b> harus valid.', 'Npwp.required' => 'Baris <b>NPWP Penandatangan</b> tidak boleh kosong.', 'Npwp.min' => 'Baris <b>NPWP Penandatangan</b> harus 20 karakter.', 'Npwp.max' => 'Baris <b>NPWP Penandatangan</b> harus 20 karakter.', 'Npwp.unique' => 'NPWP <b>' . Input::get('NPWP2') . '</b> sudah terdaftar.');
$validasi = BaseController::validasi($input, $rules, $messages);
if ($validasi->validator->fails()) {
$result['error'] = $validasi->PesanError;
} else {
Pegawai::where('id_pegawai', $id)->update($input);
$result['success'] = 'Data Bendahara Berhasil diupdate.';
}
return $result;
}
public function get_penerima_by_nip($peg = Pegawai, $filter = false)
{
$sql = "SELECT \r\n DISTINCT(a.nip) as nip,\r\n a.nama as nama,\r\n a.sex as sex,\r\n a.gol as gol\r\n FROM " . $this->_tb_peg . " a ";
if ($filter) {
$sql .= " LEFT JOIN d_pb b ON a.nip<>b.NIP_PB ";
}
$sql .= "WHERE a.nip LIKE '" . $peg->get_kd_peg() . "%'";
$result = $this->db->select($sql);
$data = array();
foreach ($result as $val) {
$tmp = new Pegawai($this->registry);
$tmp->set_kd_peg($val['nip']);
$tmp->set_nama($val['nama']);
$tmp->set_jkel($val['sex']);
$tmp->set_golongan($val['gol']);
$tmp->set_unit_asal($val['unit']);
$data[] = $tmp;
}
return $data;
}
function get_riwayat_pekerjaan($nip = "")
{
$pegawai = new Pegawai();
return $pegawai->get_riwayat_pekerjaan($nip);
}
public function ubahKorektor($id)
{
$pegawai = new Pegawai($this->registry);
$this->view->pegawai_for_peserta = $pegawai->get();
$korektor = new Korektor($this->registry);
$data = $korektor->get($id);
$this->view->data = array('id' => $data[0]['id'], 'id_pegawai' => $data[0]['id_pegawai'], 'id_assesment' => $data[0]['id_assesment']);
$id_assesment = $data[0]['id_assesment'];
$assesment = new Assesment($this->registry);
$data = $assesment->get($id_assesment);
$this->view->data_asses = $data;
if (isset($_POST['submit_e'])) {
$id_korektor = $_POST['id'];
$korek = $_POST['korektor'][0];
if ($korek == 0) {
$this->view->add_error('korektor', 'kolom korektor harus dipilih!');
}
if ($korektor->is_exist($korek, $this->view->data_asses[0]['id'], $id)) {
$this->view->add_error('korektor', 'korektor ini sudah ada!');
}
if (!$this->view->is_error()) {
$data = array('id_pegawai' => $korek);
$korektor->edit($id_korektor, $data);
header('location:' . URL . 'assesment/korektor/' . $this->view->data['id_assesment']);
} else {
$this->view->data = array('id' => $id_korektor, 'korektor' => $korek, 'id_assesment' => $this->view->data['id_assesment']);
}
}
$this->view->aksi = 'edit';
$this->view->render('assesment/korektor');
}
$user->save();
return Redirect::to('user/ganti-password')->with('success', 'Berhasil Mengganti Password !!');
} else {
return Redirect::to('user/ganti-password')->with('error', 'Password Lama Tidak Valid !!');
}
});
Route::get('user', function () {
$dataUser = User::join('Pegawai', 'Users.id_pegawai', '=', 'Pegawai.id_pegawai')->where('Users.id_pegawai', Auth::user()->id_pegawai)->first();
return View::make('v_profile_pengguna')->with('data', $dataUser);
});
Route::get('user/edit-user/{id}', function ($id) {
$getUser = User::join('Pegawai', 'Users.id_pegawai', '=', 'Pegawai.id_pegawai')->where('Users.id_pegawai', $id)->first();
return View::make('v_profile_pengguna_edit')->with('data', $getUser);
});
Route::post('user/update-user', function () {
$id = Input::get('id');
$input = Input::all();
$rules = array('nama' => 'required', 'email' => 'required|email', 'nip' => 'required|unique:pegawai,NIP,' . Auth::user()->id_pegawai . ',id_pegawai', 'telepon' => 'required|numeric', 'alamat' => 'required');
$messages = array('nama.required' => 'Baris <b>Nama</b> Harus diisi.', 'email.required' => 'Baris <b>Email</b> Harus diisi', 'email.email' => 'Baris <b>Email</b> Harus valid', 'nip.required' => 'baris <b>NIP</b> Harus diisi', 'nip.unique' => '<b>NIP</b> sudah terdaftar.', 'telepon.required' => 'Baris <b>Telepon</b> Harus diisi.', 'alamat.required' => 'Baris <b>Alamat</b> Harus diisi.');
$basecontroll = new BaseController();
$validasi = $basecontroll->validasi($input, $rules, $messages);
if ($validasi->validator->fails()) {
$result['error'] = $validasi->PesanError;
} else {
$inputData = array('Nama' => Input::get('nama'), 'NIP' => Input::get('nip'), 'Alamat' => Input::get('alamat'), 'Telepon' => Input::get('telepon'), 'Email' => Input::get('email'));
Pegawai::where('id_pegawai', $id)->update($inputData);
$result['success'] = Redirect::back()->with('success', 'Data Anda Berhasi diupdate.');
}
return $result;
});
});
<?php
require_once 'pegawai.php';
$pegawai = new Pegawai();
// $nip = $_GET['nip'];
$nnip = $_GET['nip'];
$nama = isset($_GET["nama"]) ? $_GET["nama"] : '';
$nik = isset($_GET["nik"]) ? $_GET["nik"] : '';
echo $nip;
$delete_riwayat = $pegawai->delete_riwayat($nnip);
var_dump($delete_riwayat);
if ($delete_riwayat) {
header('location:riwayat.php?nik=' . $nik . '&status=sukses&nama=' . $nama);
} else {
header('location:riwayat.php?nik=' . $nik . '&status=gagal&nama=' . $nama);
}
public function ubahUser($id)
{
$pegawai = new Pegawai($this->registry);
$this->view->data_peg = $pegawai->get();
$user = new User($this->registry);
$data = $user->get($id);
$this->view->data = array('id' => $data[0]['id'], 'id_pegawai' => $data[0]['id_pegawai'], 'nama' => $data[0]['nama_user'], 'pass' => $data[0]['password'], 'role' => $data[0]['role']);
if (isset($_POST['submit_e'])) {
$peg = $_POST['pegawai'];
$nama = $_POST['nama'];
$pass = $_POST['pass'];
$role = $_POST['role'];
if ($peg == 0) {
$this->view->add_error('pegawai', 'kolom pegawai harus dipilih!');
}
if ($nama == '') {
$this->view->add_error('nama', 'kolom nama harus diisi!');
}
if ($user->is_exist('nama_user', $nama, $id)) {
$this->view->add_error('nama', 'nama user ini sudah kepake!');
}
if ($pass == '') {
$this->view->add_error('pass', 'kolom password harus diisi!');
}
if ($role == 0) {
$this->view->add_error('role', 'kolom role harus dipilih!');
}
if (!$this->view->is_error()) {
$data = array('id_pegawai' => $peg, 'nama_user' => $nama, 'password' => Hash::create('sha1', $pass, HASH_SALT_KEY), 'role' => $role);
$user->edit($id, $data);
$this->view->add_success('success', 'ubah data user berhasil!');
}
$this->view->data = array('id' => $id, 'id_pegawai' => $peg, 'nama' => $nama, 'pass' => $pass, 'role' => $role);
}
$this->view->aksi = 'update';
$this->view->render('admin/user');
}
/**
* 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.
*/
public function loadModel()
{
if ($this->_model === null) {
if (isset($_GET['id'])) {
$this->_model = Pegawai::model()->findbyPk($_GET['id']);
}
if ($this->_model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
}
return $this->_model;
}
<?php
Route::group(array('before' => 'auth|bendahara.pembantu'), function () {
Route::get('profil/bendahara', array('uses' => 'Cbendahara@index'));
Route::get('profil/edit-bendahara/{id}', function ($id) {
$objek = Pegawai::where('id_pegawai', $id)->first();
return View::make('v_bendahara_edit')->with('datas', $objek);
});
Route::post('profil/update-bendahara', 'Cbendahara@EditBendahara');
});
public function save()
{
$rules = array('username' => 'required', 'password' => 'required', 'nama' => 'required', 'nip' => 'required|numeric', 'alamat' => 'required', 'phone' => 'required', 'mobile_phone' => 'required', 'id_satker' => 'required', 'level' => 'required', 'jabatan' => 'required', 'golongan' => 'required', 'email' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->fails()) {
return Redirect::to('admin/pegawai/add')->withErrors($validator)->withInput();
} else {
$pegawai = new Pegawai();
$pegawai->nama = Input::get('nama');
$pegawai->nip = Input::get('nip');
$pegawai->alamat = Input::get('alamat');
$pegawai->phone = Input::get('phone');
$pegawai->mobile_phone = Input::get('mobile_phone');
$pegawai->id_satker = Input::get('id_satker');
$pegawai->level = Input::get('level');
$pegawai->jabatan = Input::get('jabatan');
$pegawai->golongan = Input::get('golongan');
$pegawai->email = Input::get('email');
$pegawai->save();
$data = new User();
$data->user_id = Input::get('nip');
$data->username = Input::get('username');
$data->password = Hash::make(Input::get('password'));
$data->level_user = Input::get('level');
$data->save();
Session::flash('messages', '
<div class="alert alert-info alert-dismissable" id="notif">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<strong>Informasi...</strong><br>
data pegawai ' . Input::get('nama') . ' berhasil disimpan
</div>
');
return Redirect::to('admin/pegawai');
}
}
public function detil($id)
{
$data = Pegawai::find($id);
return View::make('master', array('menu' => 'admin.admin_menu', 'page' => 'admin.pegawai.detil'))->with('data', $data);
}
<?php
$form = $this->beginWidget('CActiveForm', array('id' => 'kenaikan-jabatan-form', 'enableAjaxValidation' => false));
?>
<p class="note">Fields with <span class="required">*</span> are required.</p>
<?php
echo $form->errorSummary($kenaikanJabatan);
?>
<div class="row">
<?php
echo $form->labelEx($kenaikanJabatan, 'pegawai_id');
?>
<?php
echo $form->dropDownList($kenaikanJabatan, 'pegawai_id', CHtml::listData(Pegawai::model()->findAll(), 'id', 'nama'));
?>
<?php
echo $form->error($kenaikanJabatan, 'pegawai_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($kenaikanJabatan, 'jabatan_id');
?>
<?php
echo $form->dropDownList($kenaikanJabatan, 'jabatan_id', CHtml::listData(Jabatan::model()->findAll(), 'id', 'nama'));
?>
<?php
echo $form->error($kenaikanJabatan, 'jabatan_id');
/**
* @param string id_pegawai
* @soap
*/
public function deletePegawai($id_pegawai)
{
Pegawai::model()->deleteAll("ID = '" . $id_pegawai . "'");
}
?>
<?php
echo $form->textAreaGroup($model, 'SUB_TOPIK', array('widgetOptions' => array('htmlOptions' => array('rows' => 6, 'cols' => 50, 'class' => 'span8'))));
?>
<?php
echo $form->textAreaGroup($model, 'OBJEKTIF', array('widgetOptions' => array('htmlOptions' => array('rows' => 6, 'cols' => 50, 'class' => 'span8'))));
?>
<?php
echo $form->dropDownListGroup($model, 'AKTIFITAS', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => array('1' => 'Teori', '2' => 'Praktikum', '3' => 'Mandiri'), 'htmlOptions' => array())));
?>
<?php
$pic = CHtml::listData(Pegawai::model()->findAll(array('order' => 'NAMA ASC', 'distinct' => true)), 'ID', 'NAMA');
echo $form->dropDownListGroup($model, 'PIC', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $pic, 'htmlOptions' => array('prompt' => '--Select PIC--'))));
?>
<?php
//echo $form->textAreaGroup($model, 'METODE', array('widgetOptions' => array('htmlOptions' => array('rows' => 6, 'cols' => 50, 'class' => 'span8'))));
?>
<?php
//echo $form->textAreaGroup($model, 'ALAT_BANTU', array('widgetOptions' => array('htmlOptions' => array('rows' => 6, 'cols' => 50, 'class' => 'span8'))));
?>
<?php
//echo $form->textFieldGroup($model, 'KET', array('widgetOptions' => array('htmlOptions' => array('class' => 'span5', 'maxlength' => 255))));
?>
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
//
$pegawai = Pegawai::find($id);
if ($pegawai->delete()) {
return Response::json(array('success' => TRUE));
}
}
public function hapusUser($id, $username)
{
User::where('id_pegawai', $id)->delete();
Pegawai::where('id_pegawai', $id)->delete();
return Redirect::to('daftar-user')->with('success', 'User dengan Username <b>' . $username . '</b> Berhasil dihapus.');
}
<?php
if ($_POST) {
require_once 'pegawai.php';
$pegawai = new Pegawai();
$nip = $_POST['pegawai'];
$res = $pegawai->register_pegawai($nip);
if ($res) {
header('Location: index.php?status=success');
} else {
header('Location: register.php?status=fail');
}
}
if (isset($_GET['']) && $_GET['status'] == 'fail') {
echo "<script>alert('Registrasi pegawai gagal')</alert>";
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Update Riwayat Pekerjaan Pegawai</title>
</head>
<body>
<h2>Update pegawai dengan nip <?php
echo $_GET['nip'];
?>
</h2>
<form action="<?php
echo $_SERVER['PHP_SELF'];
?>
<?php
require_once 'pegawai.php';
$pegawai = new Pegawai();
$nip = $_POST['nip'];
$res = $pegawai->delete_pegawai($nip);
if ($res) {
header('Location: index.php?delete=success');
} else {
header('Location: index.php?delete=fail');
}
?>
public function SPTMasa4($id, $masa_pajak)
{
$id_rekanan = $id;
$masapajak = explode('-', $masa_pajak);
$data['masa_bulan'] = str_split($masapajak[0]);
$data['masa_tahun'] = str_split($masapajak[1]);
$Rekanan = Rekanan::where('id_rekanan', $id_rekanan)->first();
$data['NPWP'] = str_split($Rekanan->NPWP);
$data['NamaPerusahaan'] = str_split($Rekanan->NamaPerusahaan);
$data['Alamat'] = str_split($Rekanan->Alamat);
$tanggal = '01-' . $masapajak[0] . '-' . $masapajak[1];
$tanggal1 = new \DateTime($tanggal);
$tanggal2 = clone $tanggal1;
$tanggal2->add(DateInterval::createFromDateString('1 month'));
$tanggal2->add(DateInterval::createFromDateString('-1 day'));
$data1 = DB::table('Pembayaran')->join('Pekerjaan', 'Pembayaran.id_pekerjaan', '=', 'pekerjaan.id_pekerjaan')->join('Rekanan', 'Rekanan.id_rekanan', '=', 'Pekerjaan.id_rekanan')->join('Jenissetoran', 'Jenissetoran.id_JenisSetoran', '=', 'Pekerjaan.id_JenisSetoran')->where('Rekanan.id_rekanan', $id_rekanan)->where('Pekerjaan.KategoriPelaksana', '1')->whereBetween('Pembayaran.TanggalPembayaran', array($tanggal1, $tanggal2))->get();
$data2 = DB::table('Pembayaran')->join('Pekerjaan', 'Pembayaran.id_pekerjaan', '=', 'pekerjaan.id_pekerjaan')->join('Rekanan', 'Rekanan.id_rekanan', '=', 'Pekerjaan.id_rekanan')->join('Jenissetoran', 'Jenissetoran.id_JenisSetoran', '=', 'Pekerjaan.id_JenisSetoran')->where('Rekanan.id_rekanan', $id_rekanan)->where('Pekerjaan.KategoriPelaksana', '2')->whereBetween('Pembayaran.TanggalPembayaran', array($tanggal1, $tanggal2))->get();
$data3 = DB::table('Pembayaran')->join('Pekerjaan', 'Pembayaran.id_pekerjaan', '=', 'pekerjaan.id_pekerjaan')->join('Rekanan', 'Rekanan.id_rekanan', '=', 'Pekerjaan.id_rekanan')->join('Jenissetoran', 'Jenissetoran.id_JenisSetoran', '=', 'Pekerjaan.id_JenisSetoran')->where('Rekanan.id_rekanan', $id_rekanan)->where('Pekerjaan.KategoriPelaksana', '3')->whereBetween('Pembayaran.TanggalPembayaran', array($tanggal1, $tanggal2))->get();
if (count($data1)) {
$PerencanaNOP = 0;
$PerencanaPPh = 0;
foreach ($data1 as $item) {
$PerencanaNOP += $item->NilaiPembayaran;
$PerencanaPPh += $item->NilaiPPh;
$data['PerencanaTarif'] = $item->Tarif * 100;
}
$data['PerencanaNOP'] = number_format($PerencanaNOP, 0, ',', '.');
$data['PerencanaPPh'] = number_format($PerencanaPPh, 0, ',', '.');
$data['PerencanaTarif'] .= '%';
} else {
$data['PerencanaNOP'] = '';
$data['PerencanaPPh'] = '';
$data['PerencanaTarif'] = '';
$PerencanaNOP = NULL;
$PerencanaPPh = NULL;
}
if (count($data2)) {
$PelaksanaNOP = 0;
$PelaksanaPPh = 0;
foreach ($data2 as $item) {
$PelaksanaNOP += $item->NilaiPembayaran;
$PelaksanaPPh += $item->NilaiPPh;
$data['PelaksanaTarif'] = $item->Tarif * 100;
}
$data['PelaksanaNOP'] = number_format($PelaksanaNOP, 0, ',', '.');
$data['PelaksanaPPh'] = number_format($PelaksanaPPh, 0, ',', '.');
$data['PelaksanaTarif'] .= '%';
} else {
$data['PelaksanaNOP'] = '';
$data['PelaksanaPPh'] = '';
$data['PelaksanaTarif'] = '';
$PelaksanaNOP = NULL;
$PelaksanaPPh = NULL;
}
if (count($data3)) {
$PengawasNOP = 0;
$PengawasPPh = 0;
foreach ($data3 as $item) {
$PengawasNOP += $item->NilaiPembayaran;
$PengawasPPh += $item->NilaiPPh;
$data['PengawasTarif'] = $item->Tarif * 100;
}
$data['PengawasNOP'] = number_format($PengawasNOP, 0, ',', '.');
$data['PengawasPPh'] = number_format($PengawasPPh, 0, ',', '.');
$data['PengawasTarif'] .= '%';
} else {
$data['PengawasNOP'] = '';
$data['PengawasPPh'] = '';
$data['PengawasTarif'] = '';
$PengawasNOP = NULL;
$PengawasPPh = NULL;
}
$data['JumlahNOP'] = $PerencanaNOP + $PelaksanaNOP + $PengawasNOP;
$data['JumlahPPh'] = $PerencanaPPh + $PelaksanaPPh + $PengawasPPh;
$nominal_pph = BaseController::terbilang($data['JumlahPPh']);
$data['terbilang'] = preg_replace('~((?:\\S*?\\s){7})~', "\$1\n", $nominal_pph);
$data['JumlahNOP'] = number_format($data['JumlahNOP'], 0, ',', '.');
$data['JumlahPPh'] = number_format($data['JumlahPPh'], 0, ',', '.');
$bendahara = Pegawai::where('id_pegawai', 1)->first();
$data['NamaBendahara'] = str_split($bendahara->Nama);
$data['NpwpBendahara'] = str_split($bendahara->Npwp);
// echo $id.' dan '.$masa_pajak.' dan '.$tanggal.' dan '.$data['PerencanaTarif'];
return View::make('cetak.SPTMasa4', $data);
}
<td width="180">Mata Kuliah</td>
<td> : </td>
<td>
<?php
$mk = Kurikulum::model()->findByAttributes(array('KODE_MK' => $Kode));
echo $mk->NAMA_KUL_IND;
?>
</td>
</tr>
<tr>
<td>Nama Dosen</td>
<td> : </td>
<td>
<?php
$pengajar = Pengajar::model()->findByAttributes(array('KODE_MK' => $Kode));
$pegawai = Pegawai::model()->findByAttributes(array('ID' => $pengajar->DOSEN_ID));
echo $pegawai->NAMA;
?>
</td>
</tr>
<tr>
<td>Semester</td>
<td> : </td>
<td>
<?php
echo $mk->SEM;
?>
</td>
</tr>
<tr>
<td>Angkatan / Kelas</td>
}
if ($file_size > 2097152) {
$errors[] = 'ukuran file harus kurang dari 2 MB';
}
//jika eror tidak ditemukan
if (empty($errors) == true) {
//memindahkan dan menyalin gambar ke di tektori images
move_uploaded_file($file_tmp, "images/" . $file_name);
echo "Success";
} else {
//mencetak eror
print_r($errors);
}
}
//membuat list pegawai dengan mengambil class pegawai
$list_pegawai = new Pegawai();
//memngambil method tampil data pada class pegawai
$data = $list_pegawai->tampil_data();
//jika data masih kosong
if ($data == "") {
echo "Belum Ada Data";
} else {
echo "<table>";
echo "<tr>";
echo "<th>No</td>";
echo "<th>NIP</td>";
echo "<th>Nama Pegawai</td>";
echo "<th>Unit Kerja</td>";
echo "<th>Photo</td>";
echo "</tr>";
//memcah string tiap 1 baris data pegawai
public function save($id)
{
$rules = array('username' => 'required', 'nip' => 'required|numeric', 'nama' => 'required', 'alamat' => 'required', 'phone' => 'required', 'mobile_phone' => 'required', 'jabatan' => 'required', 'golongan' => 'required', 'email' => 'required', 'foto' => 'max:200000|image|mimes:jpeg,jpg,png');
$message = array('required' => 'Data :attribute harus diisi', 'min' => 'Data :attribute minimal diisi :min karakter', 'image' => ':attribute harus berupa file gambar', 'mimes' => 'gambar :attribute harus berekstensi *.jpeg dan *.png');
$validator = Validator::make(Input::all(), $rules, $message);
if ($validator->fails()) {
return Redirect::to('admin/user/edit/' . Session::get('user_id'))->withErrors($validator)->withInput();
} else {
$image = Input::file('foto');
if (null == $image) {
$pegawai = Pegawai::find($id);
$pegawai->nama = Input::get('nama');
$pegawai->alamat = Input::get('alamat');
$pegawai->phone = Input::get('phone');
$pegawai->mobile_phone = Input::get('mobile_phone');
$pegawai->jabatan = Input::get('jabatan');
$pegawai->golongan = Input::get('golongan');
$pegawai->email = Input::get('email');
$pegawai->save();
if (empty(Input::get('password'))) {
$user = DB::table('user')->where('user_id', '=', $id)->update(array('username' => Input::get('username')));
} else {
$user = DB::table('user')->where('user_id', '=', $id)->update(array('username' => Input::get('username'), 'password' => Hash::make(Input::get('password'))));
}
} else {
$new_name = $id . "." . $image->guessClientExtension();
if (Image::make($image->getRealPath())->resize(183, 190)->save(public_path('/asset/img/foto_user/' . $new_name))) {
Image::make($image->getRealPath())->resize(80, 80)->save(public_path('/asset/img/foto_user/thumbnail/' . $new_name));
$pegawai = Pegawai::find($id);
$pegawai->nama = Input::get('nama');
$pegawai->alamat = Input::get('alamat');
$pegawai->phone = Input::get('phone');
$pegawai->mobile_phone = Input::get('mobile_phone');
$pegawai->jabatan = Input::get('jabatan');
$pegawai->golongan = Input::get('golongan');
$pegawai->email = Input::get('email');
$pegawai->foto = $new_name;
$pegawai->save();
if (empty(Input::get('password'))) {
$user = DB::table('user')->where('user_id', '=', $id)->update(array('username' => Input::get('username')));
} else {
$user = DB::table('user')->where('user_id', '=', $id)->update(array('username' => Input::get('username'), 'password' => Hash::make(Input::get('password'))));
}
} else {
echo "gagal";
exit;
}
}
Session::flash('messages', '
<div class="alert alert-info alert-dismissable" id="notif">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<strong>Informasi...</strong><br>
data User ' . Input::get('nama') . ' berhasil Update
</div>
');
return Redirect::to('admin/user/edit/' . Session::get('user_id'));
}
}
