/** * 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')); } }